Month: July 2024
Excel Formulas Not Working On Programme
Hi everyone,
I’m new to Excel and I’m having difficulty with some of the functions/formulas. For example, I want to join cell A2 with B2 and place an underscore between them. Whenever I try using this formula: =CONCATENATE(A2, “_”, B2), I get an error.
However, when I use the same formula on the web version of Excel, it works without any problems, just like other formulas I have tested. Is there anything I can do about it, or is using the web version of Excel my only option?
Thank you in advance.
Hi everyone,I’m new to Excel and I’m having difficulty with some of the functions/formulas. For example, I want to join cell A2 with B2 and place an underscore between them. Whenever I try using this formula: =CONCATENATE(A2, “_”, B2), I get an error.However, when I use the same formula on the web version of Excel, it works without any problems, just like other formulas I have tested. Is there anything I can do about it, or is using the web version of Excel my only option?Thank you in advance. Read More
Struggling with LAMBDA in my LET statement
I have a table that has repeating product numbers (P_NUM) and for each row, there is an attribute value. I want to turn that into a single row with the P_NUM and the list of attributes.
The LET statement was provided by ChatGPT and should work, but I am having trouble with the LAMBDA functions. If I modify the data line to have getValues, instead of rowBuilder, I get the headings printed out and rows of data, with P_NUM having a #CALC error and the values have #N/A.
If I keep the formula as it is, I get a single #CALC error in the cell where the LET statement resides and nothing else.
I have added CLEAN and TRIM on P_NUM as I know I have had problems with type mismatch when extracting data from the original source – made no difference.
=LET(
PNums, UNIQUE(A2:A100),
attributeNames, UNIQUE(F2:F100),
attributeValues, G2:G100,
PNumRange, (A2:A100),
attributeNameRange, F2:F100,
headers, HSTACK(“P_NUM”, TRANSPOSE(attributeNames)),
getValues, LAMBDA(pn, LAMBDA(an, IFERROR(INDEX(attributeValues, MATCH(1, (PNumRange = pn) * (attributeNameRange = an), 0)), “”))),
rowBuilder, LAMBDA(pn, HSTACK(pn, MAP(attributeNames, getValues(pn)))),
data, BYROW(PNums, rowBuilder),
result, VSTACK(headers, data),
result
)
first result
second result when I change rowBuilder in the data line with getValues (to see what I get)
I have a table that has repeating product numbers (P_NUM) and for each row, there is an attribute value. I want to turn that into a single row with the P_NUM and the list of attributes. The LET statement was provided by ChatGPT and should work, but I am having trouble with the LAMBDA functions. If I modify the data line to have getValues, instead of rowBuilder, I get the headings printed out and rows of data, with P_NUM having a #CALC error and the values have #N/A. If I keep the formula as it is, I get a single #CALC error in the cell where the LET statement resides and nothing else. I have added CLEAN and TRIM on P_NUM as I know I have had problems with type mismatch when extracting data from the original source – made no difference. =LET(PNums, UNIQUE(A2:A100),attributeNames, UNIQUE(F2:F100),attributeValues, G2:G100,PNumRange, (A2:A100),attributeNameRange, F2:F100,headers, HSTACK(“P_NUM”, TRANSPOSE(attributeNames)),getValues, LAMBDA(pn, LAMBDA(an, IFERROR(INDEX(attributeValues, MATCH(1, (PNumRange = pn) * (attributeNameRange = an), 0)), “”))),rowBuilder, LAMBDA(pn, HSTACK(pn, MAP(attributeNames, getValues(pn)))),data, BYROW(PNums, rowBuilder),result, VSTACK(headers, data),result) first result second result when I change rowBuilder in the data line with getValues (to see what I get) Read More
I need help with this IF function
I want to C1 to include if B1>A1 give me zero, otherwise give me the difference between the two. I’ve attached a screenshot.
I want to C1 to include if B1>A1 give me zero, otherwise give me the difference between the two. I’ve attached a screenshot. Read More
e mail problem
e mail problem
hello community
when sending or forwarding an e-mail, it goes to pending and does not recover without terminating the task.
e mail problemhello communitywhen sending or forwarding an e-mail, it goes to pending and does not recover without terminating the task. Read More
Help with Creating 365 Users and Altering UPN
I have been working on the below script for a little while and I am still having some trouble getting it to fully function. Please be kind, as this is the first script I’ve ever written.
The goal of the code is to create 365 user accounts using a .csv file. The loop should check if the upn exists, if it does not it will create the user using email address removed for privacy reasons and if it does then it will change the upn to firstname.lastname[int]@domain.com and create the user. The integer should increment up depending on how many users have a similar upn.
Right now, I can get it to create a user but it will not increment automatically. Any help would be greatly appreciated. See code below. I have switched out sensitive information that was included in the code with confidential. I set all the variables to null at the bottom in an effort to troubleshoot where the problem may be, so it is not intended to be part of the code.
Also, I would like to generate a random password. I read that I should just leave the password profile blank to complete that but it didn’t seem to work. Any suggestions with that are also welcomed.
#Connect to Microsoft Graph Powershell Module
Connect-MgGraph -Scopes “User.ReadWrite.All”,”Group.ReadWrite.All”,”Directory.ReadWrite.All”
#Connect to Exchange Online Powershell Module
Connect-ExchangeOnline
# Import the CSV file
$csvrecords = Import-Csv -Path “C:UsersConfidentialOneDrive – ConfidentialDocumentsPowerShellScriptsO365PowershellTest1.csv” #Add our file here
# Create a password profile
$PasswordProfile = @{
Password = “Password1234!”
}
# Loop through each user in the CSV file
foreach ($csvrecord in $csvrecords)
{
#Variable to increment UserPrincipalName
$i = 1
$created = $false #set the variable to end the loop
$user = Get-MgUser -Filter “UserPrincipalName eq ‘$upn'” #Set User variable to User’s GUID
do {
If(!$User.ID)
{
$upn = $csvrecord.UserPrincipalName #Set the UPN variable to the user’s email address
# Create a new user if the username does not exist
$newUser = New-MgUser -GivenName $csvrecord.FirstName -Surname $csvrecord.LastName -DisplayName $csvrecord.DisplayName -UserPrincipalName $upn -UsageLocation ‘US’ -JobTitle $csvrecord.JobTitle -Department $csvrecord.Department -PasswordProfile $PasswordProfile -MailNickname $csvrecord.MailNickname -AccountEnabled
$created = $true
}
else {
$i = $i + 1
#Add an interger to the end of first and last name in username
$upn = $csvrecord.FirstName + “.” + $csvrecord.LastName + $i + “@Confidential.org”
#create the user
$newUser = New-MgUser -GivenName $csvrecord.FirstName -Surname $csvrecord.LastName -DisplayName $csvrecord.DisplayName -UserPrincipalName $upn -UsageLocation ‘US’ -JobTitle $csvrecord.JobTitle -Department $csvrecord.Department -PasswordProfile $PasswordProfile -MailNickname $csvrecord.MailNickname -AccountEnabled
$created = $true
}
} until ($created = $true)
# Assign a license to the new user
$e3Sku = Get-MgSubscribedSku | Where SkuPartNumber -eq ‘SPE_E3’
Set-MgUserLicense -UserID $newUser.UserPrincipalName -AddLicenses @{SkuId = $e3Sku.SkuId} -RemoveLicenses @()
# Export the results to a CSV file
$csvrecords | Export-Csv -Path “C:UsersConfidentialOneDrive -ConfidentialDocumentsPowerShellScriptsO365NewAccountResultsTest1.csv” -NoTypeInformation #Add our file here
$i = $null
$created = $null
$upn = $null
$user = $null
}
#Disconnect from Microsoft Exchange
Disconnect-ExchangeOnline
#Disconnect from MgGraph
Disconnect-MgGraph
I have been working on the below script for a little while and I am still having some trouble getting it to fully function. Please be kind, as this is the first script I’ve ever written. The goal of the code is to create 365 user accounts using a .csv file. The loop should check if the upn exists, if it does not it will create the user using email address removed for privacy reasons and if it does then it will change the upn to firstname.lastname[int]@domain.com and create the user. The integer should increment up depending on how many users have a similar upn. Right now, I can get it to create a user but it will not increment automatically. Any help would be greatly appreciated. See code below. I have switched out sensitive information that was included in the code with confidential. I set all the variables to null at the bottom in an effort to troubleshoot where the problem may be, so it is not intended to be part of the code.Also, I would like to generate a random password. I read that I should just leave the password profile blank to complete that but it didn’t seem to work. Any suggestions with that are also welcomed. #Connect to Microsoft Graph Powershell ModuleConnect-MgGraph -Scopes “User.ReadWrite.All”,”Group.ReadWrite.All”,”Directory.ReadWrite.All” #Connect to Exchange Online Powershell ModuleConnect-ExchangeOnline # Import the CSV file$csvrecords = Import-Csv -Path “C:UsersConfidentialOneDrive – ConfidentialDocumentsPowerShellScriptsO365PowershellTest1.csv” #Add our file here # Create a password profile $PasswordProfile = @{ Password = “Password1234!” } # Loop through each user in the CSV fileforeach ($csvrecord in $csvrecords) { #Variable to increment UserPrincipalName $i = 1 $created = $false #set the variable to end the loop $user = Get-MgUser -Filter “UserPrincipalName eq ‘$upn'” #Set User variable to User’s GUID do { If(!$User.ID) { $upn = $csvrecord.UserPrincipalName #Set the UPN variable to the user’s email address # Create a new user if the username does not exist $newUser = New-MgUser -GivenName $csvrecord.FirstName -Surname $csvrecord.LastName -DisplayName $csvrecord.DisplayName -UserPrincipalName $upn -UsageLocation ‘US’ -JobTitle $csvrecord.JobTitle -Department $csvrecord.Department -PasswordProfile $PasswordProfile -MailNickname $csvrecord.MailNickname -AccountEnabled $created = $true} else { $i = $i + 1 #Add an interger to the end of first and last name in username $upn = $csvrecord.FirstName + “.” + $csvrecord.LastName + $i + “@Confidential.org” #create the user $newUser = New-MgUser -GivenName $csvrecord.FirstName -Surname $csvrecord.LastName -DisplayName $csvrecord.DisplayName -UserPrincipalName $upn -UsageLocation ‘US’ -JobTitle $csvrecord.JobTitle -Department $csvrecord.Department -PasswordProfile $PasswordProfile -MailNickname $csvrecord.MailNickname -AccountEnabled $created = $true } } until ($created = $true) # Assign a license to the new user $e3Sku = Get-MgSubscribedSku | Where SkuPartNumber -eq ‘SPE_E3’ Set-MgUserLicense -UserID $newUser.UserPrincipalName -AddLicenses @{SkuId = $e3Sku.SkuId} -RemoveLicenses @() # Export the results to a CSV file$csvrecords | Export-Csv -Path “C:UsersConfidentialOneDrive -ConfidentialDocumentsPowerShellScriptsO365NewAccountResultsTest1.csv” -NoTypeInformation #Add our file here $i = $null$created = $null$upn = $null$user = $null } #Disconnect from Microsoft ExchangeDisconnect-ExchangeOnline #Disconnect from MgGraphDisconnect-MgGraph Read More
how to use Matlab netCDF functions for 4 dimensions data?
I have data with four dimensions, there are (lon,lat,level,time).
I have no idea what should I do with this kind of data..
this is the display of my data:
Variablename
Size: 249x249x34x2
Dimensions: west_east,south_north,bottom_top,Time
Datatype: single
Attributes:
FieldType = 104
MemoryOrder = ‘XYZ’
description = ‘pm10 dry mass’
units = ‘ug m^-3’
stagger = ”
coordinates = ‘XLONG XLAT’
% code
clc
clear
file = ‘F:…’;
data = double (ncread(file,’variablename’));
DATA = squeeze(data(:,:,1,1)); % I just think this command usable to 4D data (lon,lat,level,time), I don’t know for sure
DATA = log10(DATA);
% lattitude and longitude
lat = double(ncread(file,’XLAT’));
lon = double(ncread(file,’XLONG’));
xlat = lat(1,:,1);
xlon = lon(:,1,1);
[xlat,xlon] = meshgrid(xlat,xlon);
When I use ‘surfacem(xlat,xlon,DATA);’ with the codes that following above, my result it is not look good, the DATA only shown around the ocean (lat and lon).
please give me the suggestions the correct way to read 4D data and get the result from that kind of data..
I really need your help
Thank youI have data with four dimensions, there are (lon,lat,level,time).
I have no idea what should I do with this kind of data..
this is the display of my data:
Variablename
Size: 249x249x34x2
Dimensions: west_east,south_north,bottom_top,Time
Datatype: single
Attributes:
FieldType = 104
MemoryOrder = ‘XYZ’
description = ‘pm10 dry mass’
units = ‘ug m^-3’
stagger = ”
coordinates = ‘XLONG XLAT’
% code
clc
clear
file = ‘F:…’;
data = double (ncread(file,’variablename’));
DATA = squeeze(data(:,:,1,1)); % I just think this command usable to 4D data (lon,lat,level,time), I don’t know for sure
DATA = log10(DATA);
% lattitude and longitude
lat = double(ncread(file,’XLAT’));
lon = double(ncread(file,’XLONG’));
xlat = lat(1,:,1);
xlon = lon(:,1,1);
[xlat,xlon] = meshgrid(xlat,xlon);
When I use ‘surfacem(xlat,xlon,DATA);’ with the codes that following above, my result it is not look good, the DATA only shown around the ocean (lat and lon).
please give me the suggestions the correct way to read 4D data and get the result from that kind of data..
I really need your help
Thank you I have data with four dimensions, there are (lon,lat,level,time).
I have no idea what should I do with this kind of data..
this is the display of my data:
Variablename
Size: 249x249x34x2
Dimensions: west_east,south_north,bottom_top,Time
Datatype: single
Attributes:
FieldType = 104
MemoryOrder = ‘XYZ’
description = ‘pm10 dry mass’
units = ‘ug m^-3’
stagger = ”
coordinates = ‘XLONG XLAT’
% code
clc
clear
file = ‘F:…’;
data = double (ncread(file,’variablename’));
DATA = squeeze(data(:,:,1,1)); % I just think this command usable to 4D data (lon,lat,level,time), I don’t know for sure
DATA = log10(DATA);
% lattitude and longitude
lat = double(ncread(file,’XLAT’));
lon = double(ncread(file,’XLONG’));
xlat = lat(1,:,1);
xlon = lon(:,1,1);
[xlat,xlon] = meshgrid(xlat,xlon);
When I use ‘surfacem(xlat,xlon,DATA);’ with the codes that following above, my result it is not look good, the DATA only shown around the ocean (lat and lon).
please give me the suggestions the correct way to read 4D data and get the result from that kind of data..
I really need your help
Thank you netcdf, 4d datasets, surfacem MATLAB Answers — New Questions
Finding a a path between two points on a 3d surface that proceeds through lowest value points.
Hello,
I have data (100X50 array for X, Y and Z coordiantes ) corresponding to the surface shown in the below image. I am interested in obtaining paths from flat region (right side yellow circle) of the surface to the minima at red and brown cricle on the left side of the surface. Only condition is that the path should proceed through lowest value points along the Z axis. I could obtain one path connecting yellow and red circles by using "min" function in matlab. I tried find peaks in order to obtain the other path (shown with black arrow in the image). But, the well around the brown circle is very shallow resulting the findpeaks gives only one peak at the region of red circle. Could you please help me to obtain the second path that connects yellow and brown circles. I have also attached my data file. "Shortestpath" function in matlab might be useful for this purpose. I am however not sure how to use it.
These type of paths are referred as "minimum energy paths" in chemistry, assuming that the Z-axis is energy and X- and Y-axis represent molecular coordiantes. In other words, I am looking for a steepest descent path between yellow and brown circles.
Thank you very much for your time
Regards,
MaheshHello,
I have data (100X50 array for X, Y and Z coordiantes ) corresponding to the surface shown in the below image. I am interested in obtaining paths from flat region (right side yellow circle) of the surface to the minima at red and brown cricle on the left side of the surface. Only condition is that the path should proceed through lowest value points along the Z axis. I could obtain one path connecting yellow and red circles by using "min" function in matlab. I tried find peaks in order to obtain the other path (shown with black arrow in the image). But, the well around the brown circle is very shallow resulting the findpeaks gives only one peak at the region of red circle. Could you please help me to obtain the second path that connects yellow and brown circles. I have also attached my data file. "Shortestpath" function in matlab might be useful for this purpose. I am however not sure how to use it.
These type of paths are referred as "minimum energy paths" in chemistry, assuming that the Z-axis is energy and X- and Y-axis represent molecular coordiantes. In other words, I am looking for a steepest descent path between yellow and brown circles.
Thank you very much for your time
Regards,
Mahesh Hello,
I have data (100X50 array for X, Y and Z coordiantes ) corresponding to the surface shown in the below image. I am interested in obtaining paths from flat region (right side yellow circle) of the surface to the minima at red and brown cricle on the left side of the surface. Only condition is that the path should proceed through lowest value points along the Z axis. I could obtain one path connecting yellow and red circles by using "min" function in matlab. I tried find peaks in order to obtain the other path (shown with black arrow in the image). But, the well around the brown circle is very shallow resulting the findpeaks gives only one peak at the region of red circle. Could you please help me to obtain the second path that connects yellow and brown circles. I have also attached my data file. "Shortestpath" function in matlab might be useful for this purpose. I am however not sure how to use it.
These type of paths are referred as "minimum energy paths" in chemistry, assuming that the Z-axis is energy and X- and Y-axis represent molecular coordiantes. In other words, I am looking for a steepest descent path between yellow and brown circles.
Thank you very much for your time
Regards,
Mahesh minimum value path between two points on 3d grid MATLAB Answers — New Questions
Extract two floating point numbers from a string
This should be easy, but I have no experience with MATLAB regexp or pattern and can’t adapt the other answers about extracting numbers from a mixed string.
I want to get the latitude and longitude as floating point numbers from a string that looks like this:
23.047°S 67.782°W
The numbers will have 1-3 characters before the decimal point. An "S" or a "W" will produce a negative number.
Suggestions welcome.This should be easy, but I have no experience with MATLAB regexp or pattern and can’t adapt the other answers about extracting numbers from a mixed string.
I want to get the latitude and longitude as floating point numbers from a string that looks like this:
23.047°S 67.782°W
The numbers will have 1-3 characters before the decimal point. An "S" or a "W" will produce a negative number.
Suggestions welcome. This should be easy, but I have no experience with MATLAB regexp or pattern and can’t adapt the other answers about extracting numbers from a mixed string.
I want to get the latitude and longitude as floating point numbers from a string that looks like this:
23.047°S 67.782°W
The numbers will have 1-3 characters before the decimal point. An "S" or a "W" will produce a negative number.
Suggestions welcome. string MATLAB Answers — New Questions
No Caller ID information on voicemails
Teams Windows desktop client – Incoming calls DO display Caller ID information, but voicemails only display the number. My users swear that voicemails used to have the caller’s name, but now only show the number so it is difficult for them to discern who the call is from.
The Teams mobile app DOES show Caller ID information on each voicemail. It seems like a huge omission for this to be missing on the desktop client.
Teams Windows desktop client – Incoming calls DO display Caller ID information, but voicemails only display the number. My users swear that voicemails used to have the caller’s name, but now only show the number so it is difficult for them to discern who the call is from.The Teams mobile app DOES show Caller ID information on each voicemail. It seems like a huge omission for this to be missing on the desktop client. Read More
Excel Formula Help! Automate data from tabs to master tab
Hello! I am having trouble figuring out how to automate data between tabs. I have a Master list and then separate sheets with each category. I would like to be able to input data into the category sheet and it automatically populate into my master sheet. Is this possible? Any help would be greatly appreciated!! 🙂
Hello! I am having trouble figuring out how to automate data between tabs. I have a Master list and then separate sheets with each category. I would like to be able to input data into the category sheet and it automatically populate into my master sheet. Is this possible? Any help would be greatly appreciated!! 🙂 Read More
Auto-populate a column in one list from a source in a lookup list
I have a list built with the new SharePoint list template called “Approvals Content Scheduler With Approvals” (the target list) and the list is called Timesheet. The purpose is for an employee to log time for a given week and the time is entered into a column as a number. By default, this list has a column named “Author” (Employee) and “Approver” (Person selected to approve).
In a separate lookup list (the source), I have two columns; Employee (which would be the Author in this case) and their manager in the second column named “Manager”.
When an employee creates a new item in the Timesheet list (the target list), the employee becomes the Author, and whomever they selected as the approver becomes the “Approver”. In addition to these two columns, I have created a new column in the Timesheet list (the target list) called “Manager”.
The scenario: When an employee enters a new item in the Timesheet (the target list), I want to use the lookup list (the source list) to grab the Manager’s name and auto-populate this name into the Manager column in the target list.
The lookup list (source) has one column for the employee’s name and one column with the name of their manager. How do I get the name of the employee’s manager to auto-populate the Manager column in the Timesheet list (target list)? Basically, I want to use the lookup list to determine who the manager is for the employee and insert the Manager’s name in the Manager column in the target list. I don’t want the user (Employee) to make the selection.
I have a list built with the new SharePoint list template called “Approvals Content Scheduler With Approvals” (the target list) and the list is called Timesheet. The purpose is for an employee to log time for a given week and the time is entered into a column as a number. By default, this list has a column named “Author” (Employee) and “Approver” (Person selected to approve). In a separate lookup list (the source), I have two columns; Employee (which would be the Author in this case) and their manager in the second column named “Manager”. When an employee creates a new item in the Timesheet list (the target list), the employee becomes the Author, and whomever they selected as the approver becomes the “Approver”. In addition to these two columns, I have created a new column in the Timesheet list (the target list) called “Manager”. The scenario: When an employee enters a new item in the Timesheet (the target list), I want to use the lookup list (the source list) to grab the Manager’s name and auto-populate this name into the Manager column in the target list. The lookup list (source) has one column for the employee’s name and one column with the name of their manager. How do I get the name of the employee’s manager to auto-populate the Manager column in the Timesheet list (target list)? Basically, I want to use the lookup list to determine who the manager is for the employee and insert the Manager’s name in the Manager column in the target list. I don’t want the user (Employee) to make the selection. Read More
Excel Filter() Function Skipping Data
Hello all!
I am completing an analysis based on a very large master data set (around 50.,000 rows). I have encountered an issue in one specific calculation I am trying to program. Basically, a part of my algorithm for this calculation is using the Filter() function to find specific values based on an ID and two other criteria. However, I noticed that many expected values for a test cell with the formula were missing (e.g., I expected a dozen rows to return for this test cell but only 5 or so results would appear. I managed to find a very specific test example with a small subset of the data I have that gives the same error:
Formula is: =FILTER(DB!W$18844:W$18850;DB!H$18844:H$18850=A2;0), A2 is 102158
Data pulled directly from my report (apologies, I use the French Canadian version of Excel which uses commas and not periods for decimals):
HW188441021582232,1188451021580188461021580188471021580188481021580188491021580188501021580
This results in only row 18844 and 18848 being pulled by the Filter function, giving 2232,1 and 0
I have checked the “Evaluate Formula” tool and it successfully matches the ID number (column H) to all 7 rows as it gives the array {TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE} at the step where it compares A2 to the range provided and it does not provide any further calculation steps after this. I have no idea what to check next to find the source of the error. Any ideas?
Thanks!
Hello all! I am completing an analysis based on a very large master data set (around 50.,000 rows). I have encountered an issue in one specific calculation I am trying to program. Basically, a part of my algorithm for this calculation is using the Filter() function to find specific values based on an ID and two other criteria. However, I noticed that many expected values for a test cell with the formula were missing (e.g., I expected a dozen rows to return for this test cell but only 5 or so results would appear. I managed to find a very specific test example with a small subset of the data I have that gives the same error: Formula is: =FILTER(DB!W$18844:W$18850;DB!H$18844:H$18850=A2;0), A2 is 102158 Data pulled directly from my report (apologies, I use the French Canadian version of Excel which uses commas and not periods for decimals): HW188441021582232,1188451021580188461021580188471021580188481021580188491021580188501021580 This results in only row 18844 and 18848 being pulled by the Filter function, giving 2232,1 and 0I have checked the “Evaluate Formula” tool and it successfully matches the ID number (column H) to all 7 rows as it gives the array {TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE} at the step where it compares A2 to the range provided and it does not provide any further calculation steps after this. I have no idea what to check next to find the source of the error. Any ideas? Thanks! Read More
Variable Performance when Creating or Removing Shortcut Folders for SharePoint libraries
When using the “Add shortcut to OneDrive” feature for a SharePoint online library or folder, we experience inconsistent performance with the local OneDrive sync application creating/initializing the local “shortcut folder”. Sometimes the sync application processes “changes” very quickly–100s of changes per second. And sometimes it does so very slowly–10s (or less) changes per second.
We experience the same inconsistent behavior when removing a “shortcut folder”–sometimes it’s fast and sometimes it’s slow.
In my testing, the difference cannot be attributed to either the specific SharePoint library/folder or the the specific client machine. On my own machine, I have seen both the fast and slow behavior when creating a “shortcut folder” for the same SharePoint library.
Can anyone provide any insight on what might be causing this inconsistent performance?
Could any service limits be coming into play?
https://learn.microsoft.com/en-us/graph/throttling-limits#files-and-lists-service-limits
Environment: Large SharePoint online libraries; Windows 11 client machines; current PROD ring OneDrive sync applications; Files On-Demand enforced via group policy; no rate limiting used for the local sync application.
When using the “Add shortcut to OneDrive” feature for a SharePoint online library or folder, we experience inconsistent performance with the local OneDrive sync application creating/initializing the local “shortcut folder”. Sometimes the sync application processes “changes” very quickly–100s of changes per second. And sometimes it does so very slowly–10s (or less) changes per second.We experience the same inconsistent behavior when removing a “shortcut folder”–sometimes it’s fast and sometimes it’s slow. In my testing, the difference cannot be attributed to either the specific SharePoint library/folder or the the specific client machine. On my own machine, I have seen both the fast and slow behavior when creating a “shortcut folder” for the same SharePoint library. Can anyone provide any insight on what might be causing this inconsistent performance?Could any service limits be coming into play?https://learn.microsoft.com/en-us/graph/throttling-limits#files-and-lists-service-limits Environment: Large SharePoint online libraries; Windows 11 client machines; current PROD ring OneDrive sync applications; Files On-Demand enforced via group policy; no rate limiting used for the local sync application. Read More
WARNING for users of Dropbox (Beta) integration with Microsoft 365/Word
Anyone concerned with the “last modified date” of their files should NOT use the Dropbox (Beta) integration sent out by Dropbox earlier in the week. Once the Beta is installed in Word, it will alter the dates of every file you open, even if you do nothing to the file. If the last modified date was, say, June 27, opening the file merely to look at, making NO changes, the last modified date will change to the date you open the file. The problem occurs in Mac and Windows.
This is a disaster for law offices, which count on the last modified dates in a number of ways.
Anyone concerned with the “last modified date” of their files should NOT use the Dropbox (Beta) integration sent out by Dropbox earlier in the week. Once the Beta is installed in Word, it will alter the dates of every file you open, even if you do nothing to the file. If the last modified date was, say, June 27, opening the file merely to look at, making NO changes, the last modified date will change to the date you open the file. The problem occurs in Mac and Windows. This is a disaster for law offices, which count on the last modified dates in a number of ways. Read More
When running the setup.exe file for MATLAB R2024A on a Windows system, the “Error code: -354” appears.
Unable to open the requested feature.Check your internet connection and proxy settings in MATLAB Web preferences and then try starting the feature again.
Detailed information:
Error code: -354
Error message: ERR_CONTENT_LENGTH_MISMATCHUnable to open the requested feature.Check your internet connection and proxy settings in MATLAB Web preferences and then try starting the feature again.
Detailed information:
Error code: -354
Error message: ERR_CONTENT_LENGTH_MISMATCH Unable to open the requested feature.Check your internet connection and proxy settings in MATLAB Web preferences and then try starting the feature again.
Detailed information:
Error code: -354
Error message: ERR_CONTENT_LENGTH_MISMATCH installation error MATLAB Answers — New Questions
How do I integrate my MATLAB Compiler SDK C or C++ shared library in Visual Studio?
I have used MATLAB Compiler SDK to compile a C/C++ library from MATLAB and I would like to integrate it into a C/C++ application in Visual Studio. How can I do this?I have used MATLAB Compiler SDK to compile a C/C++ library from MATLAB and I would like to integrate it into a C/C++ application in Visual Studio. How can I do this? I have used MATLAB Compiler SDK to compile a C/C++ library from MATLAB and I would like to integrate it into a C/C++ application in Visual Studio. How can I do this? visual, studio, compiler, sdk, dynamic, static, library MATLAB Answers — New Questions
Eliminate the long number appearing in symbolic calculations
I am doing some symbolic calculations and end up with very large numbers in the symbolic expression. For example, I get the variable "term" as the result of my calculation:
syms J1
term = J1*(6582018229284824168619876730229377341315370891042652124695852093/13164036458569648337239753460458804039861886925068638906788872192 – 4302204281461843i/81129638414606681695789005144064);
It contains these long numbers. When I use vpa(), I get the following:
vpa(term)
How can I eliminate these small numbers with imaginary parts using vpa() or any other function? They should be rounded to zero. (I don’t want to take only the real part using the real() function because these numbers can show up as real part too.)I am doing some symbolic calculations and end up with very large numbers in the symbolic expression. For example, I get the variable "term" as the result of my calculation:
syms J1
term = J1*(6582018229284824168619876730229377341315370891042652124695852093/13164036458569648337239753460458804039861886925068638906788872192 – 4302204281461843i/81129638414606681695789005144064);
It contains these long numbers. When I use vpa(), I get the following:
vpa(term)
How can I eliminate these small numbers with imaginary parts using vpa() or any other function? They should be rounded to zero. (I don’t want to take only the real part using the real() function because these numbers can show up as real part too.) I am doing some symbolic calculations and end up with very large numbers in the symbolic expression. For example, I get the variable "term" as the result of my calculation:
syms J1
term = J1*(6582018229284824168619876730229377341315370891042652124695852093/13164036458569648337239753460458804039861886925068638906788872192 – 4302204281461843i/81129638414606681695789005144064);
It contains these long numbers. When I use vpa(), I get the following:
vpa(term)
How can I eliminate these small numbers with imaginary parts using vpa() or any other function? They should be rounded to zero. (I don’t want to take only the real part using the real() function because these numbers can show up as real part too.) vpa, symbolic, round MATLAB Answers — New Questions
Scatteredinterpolant (linear) from symmetric data does not produce symmetric isolines
I utilised the scatteredinterpolant function to generate an interpolation from which I derived isolines. My data are situated on a non-equispaced grid of points that are symmetric with respect to the midline. In fact, I only have data on one side, so I placed data on the other side by copying the values from the original data set, exploiting the symmetry.
When I generate iso-lines using the NATURAL method, the isolines have a symmetric trend. If I use the simplest method, i.e. LINEAR, the iso-lines are not symmetric, which does not make sense.
Do you know what may cause this issue and how to sort it out?I utilised the scatteredinterpolant function to generate an interpolation from which I derived isolines. My data are situated on a non-equispaced grid of points that are symmetric with respect to the midline. In fact, I only have data on one side, so I placed data on the other side by copying the values from the original data set, exploiting the symmetry.
When I generate iso-lines using the NATURAL method, the isolines have a symmetric trend. If I use the simplest method, i.e. LINEAR, the iso-lines are not symmetric, which does not make sense.
Do you know what may cause this issue and how to sort it out? I utilised the scatteredinterpolant function to generate an interpolation from which I derived isolines. My data are situated on a non-equispaced grid of points that are symmetric with respect to the midline. In fact, I only have data on one side, so I placed data on the other side by copying the values from the original data set, exploiting the symmetry.
When I generate iso-lines using the NATURAL method, the isolines have a symmetric trend. If I use the simplest method, i.e. LINEAR, the iso-lines are not symmetric, which does not make sense.
Do you know what may cause this issue and how to sort it out? matlab, scatteredinterpolant, interpolation MATLAB Answers — New Questions
Outlook on IMAC Issue
have an odd issue, screenshot below: the user when they respond or create a new email to a user they get this redbox with an ! in it and the first letter of the username. after deleting it and retyping its not longer an issue.. was just curious if anyone else has experience this before?
have an odd issue, screenshot below: the user when they respond or create a new email to a user they get this redbox with an ! in it and the first letter of the username. after deleting it and retyping its not longer an issue.. was just curious if anyone else has experience this before? Read More
Microsoft edge windows 10
how do i keep signed in, when i want to comment on a news item, i always have to sign in? thank you.
how do i keep signed in, when i want to comment on a news item, i always have to sign in? thank you. Read More