Category: News
How to compile a Standalone App which requires Python?
I am trying to compile a Standalone App with App designer.
The goal should be that other user can open the App without having Matlab installed.
The App workes on App Designer perfectly. Even if I compile the App and open it on my computer everything runs.
However, if I open the App on an other computer (without MATLAB, Python and CoolProp) the App opens but the calculation can’t be done.
I guess the problem is the missing Python and/or CoolProp on the second Computer.
My code uses this function:
rho=py.CoolProp.CoolProp.PropsSI(‘D’,’T’,273.15+ T_gc_out ,’P’,p_h,KM)
Is there a way to compile the App including the required Python and CoolProp software to run my programm? I want to include these files, or codes in the app such that the other users don’t have to download Python and CoolProp separately.I am trying to compile a Standalone App with App designer.
The goal should be that other user can open the App without having Matlab installed.
The App workes on App Designer perfectly. Even if I compile the App and open it on my computer everything runs.
However, if I open the App on an other computer (without MATLAB, Python and CoolProp) the App opens but the calculation can’t be done.
I guess the problem is the missing Python and/or CoolProp on the second Computer.
My code uses this function:
rho=py.CoolProp.CoolProp.PropsSI(‘D’,’T’,273.15+ T_gc_out ,’P’,p_h,KM)
Is there a way to compile the App including the required Python and CoolProp software to run my programm? I want to include these files, or codes in the app such that the other users don’t have to download Python and CoolProp separately. I am trying to compile a Standalone App with App designer.
The goal should be that other user can open the App without having Matlab installed.
The App workes on App Designer perfectly. Even if I compile the App and open it on my computer everything runs.
However, if I open the App on an other computer (without MATLAB, Python and CoolProp) the App opens but the calculation can’t be done.
I guess the problem is the missing Python and/or CoolProp on the second Computer.
My code uses this function:
rho=py.CoolProp.CoolProp.PropsSI(‘D’,’T’,273.15+ T_gc_out ,’P’,p_h,KM)
Is there a way to compile the App including the required Python and CoolProp software to run my programm? I want to include these files, or codes in the app such that the other users don’t have to download Python and CoolProp separately. standalone app, app designer, matlab, python function, python, matlab compiler, compiler MATLAB Answers — New Questions
Limiting Team invitations to specific members
Dear Microsoft,
Within our organization, the ability to limit teams invites is a must for meetings. When we create a meeting, without doing so, optional members are added to the teams meeting. You can imagine that when a team meeting is created and 200 people are a member of a team but only 5 are invited, that a meeting can quickly become unproductive.
We’ve also noted that using private channels does not allow you to create meetings. And, in fact, using a private channel would be ideal when you don’t want 200+ personnel invited to a meeting that don’t belong.
Can we suggest two feature updates?
1. Prevent Teams from broadcasting to the whole team. Only invite the required personnel. Optional members should be just that, only receive the invite if you were included on the Optional field. Users would be able to see if they’re optional or not.
2. Allow Teams to utilize private channels for more meeting control or to allow for meetings which require extreme privacy (i.e., investigations, meetings about personal health discussions, etc.).
Thank you,
TC
Dear Microsoft,Within our organization, the ability to limit teams invites is a must for meetings. When we create a meeting, without doing so, optional members are added to the teams meeting. You can imagine that when a team meeting is created and 200 people are a member of a team but only 5 are invited, that a meeting can quickly become unproductive. We’ve also noted that using private channels does not allow you to create meetings. And, in fact, using a private channel would be ideal when you don’t want 200+ personnel invited to a meeting that don’t belong. Can we suggest two feature updates?1. Prevent Teams from broadcasting to the whole team. Only invite the required personnel. Optional members should be just that, only receive the invite if you were included on the Optional field. Users would be able to see if they’re optional or not.2. Allow Teams to utilize private channels for more meeting control or to allow for meetings which require extreme privacy (i.e., investigations, meetings about personal health discussions, etc.). Thank you, TC Read More
MS Teams Connector end of support clarification
We have Teams integration setup for our app and have a couple questions about the recent announcement of the end of support for Teams connectors:
– Are teams tab apps affected by this? Or only connector use that posts into teams channels and conversations?
– Is the use of the https://teams.microsoft.com/share URL to post into channels affected by this?
We have Teams integration setup for our app and have a couple questions about the recent announcement of the end of support for Teams connectors: – Are teams tab apps affected by this? Or only connector use that posts into teams channels and conversations?– Is the use of the https://teams.microsoft.com/share URL to post into channels affected by this? Read More
Solve F=ma for position. I need to solve 2nd order differential equation in MATLAB and I read all the tutorials out there I still can’t figure out how to do it, Please help!
I know I have F=ma=m*dv/dt=m*d^2x/dt^2 and I need first to solve for velocity by using ode23 once, then use ode23 again on whatever that answer is to solve for position, but I don’t know how to set it up in a code, please help!I know I have F=ma=m*dv/dt=m*d^2x/dt^2 and I need first to solve for velocity by using ode23 once, then use ode23 again on whatever that answer is to solve for position, but I don’t know how to set it up in a code, please help! I know I have F=ma=m*dv/dt=m*d^2x/dt^2 and I need first to solve for velocity by using ode23 once, then use ode23 again on whatever that answer is to solve for position, but I don’t know how to set it up in a code, please help! solve f=ma for position in matlab MATLAB Answers — New Questions
Can I transfer train “visionTransformer” to handle image sizes other than 384x384X3?
In the related Matlab doc, only change of "head" is described.In the related Matlab doc, only change of "head" is described. In the related Matlab doc, only change of "head" is described. visiontransformer, image size, grey images MATLAB Answers — New Questions
PRONOSTICO.ETS
He revisado diferentes portales sobre la función y todas se apoyan en la ayuda que brinda Microsoft sobre la estacionalidad.
He descubierto que es posible colocar otros valores en esa opción. Sin embargo, no encuentro información sobre qué significa esa posibilidad dentro de la opción de estacionalidad o de qué depende (criterio) para colocar un valor diferente a 0 y 1.
¿En caso de colocar “24”, por poner un ejemplo, significa que realiza la diferencia con el valor 24 datos antes?
He revisado diferentes portales sobre la función y todas se apoyan en la ayuda que brinda Microsoft sobre la estacionalidad.He descubierto que es posible colocar otros valores en esa opción. Sin embargo, no encuentro información sobre qué significa esa posibilidad dentro de la opción de estacionalidad o de qué depende (criterio) para colocar un valor diferente a 0 y 1.¿En caso de colocar “24”, por poner un ejemplo, significa que realiza la diferencia con el valor 24 datos antes? Read More
why is Excel returning False
see attached i don’t see a reason why excel returned false when i did on cell d1 =a1=c1
see attached i don’t see a reason why excel returned false when i did on cell d1 =a1=c1@HansVogelaar Read More
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