Category: News
Access to Sql Server Migration
I am trying to come up with Access code that will allow a query to migrate to Sql Server. The current Access Sql is:
SELECT Last(tblSecurityPrices.Price) AS LastOfPrice, tblSecurityPrices.Security, Last(tblSecurityPrices.PriceDate) AS LastOfPriceDate
FROM tblSecurityPrices
GROUP BY tblSecurityPrices.Security;
I know very little about Sql Server. Bob
I am trying to come up with Access code that will allow a query to migrate to Sql Server. The current Access Sql is:SELECT Last(tblSecurityPrices.Price) AS LastOfPrice, tblSecurityPrices.Security, Last(tblSecurityPrices.PriceDate) AS LastOfPriceDateFROM tblSecurityPricesGROUP BY tblSecurityPrices.Security; I know very little about Sql Server. Bob Read More
Setting a default calendar for all new projects
I want to set up my Project 2019 so that every time I open a new blank project it defaults to a particular calendar that I have created. Can this be done, or do you have to open a new blank project and select the calendar?
I want to set up my Project 2019 so that every time I open a new blank project it defaults to a particular calendar that I have created. Can this be done, or do you have to open a new blank project and select the calendar? Read More
Yahoo Finance library in Python
I tried to build a model that explains the difference between the financial data entered by the client and Yao’s financial data to verify the accuracy of a report, and I discovered that there is an error and the Yahoo Finance library does not work., in show Error
(ModuleNotFoundError: No module named ‘yfinance’)
i want Help
I tried to build a model that explains the difference between the financial data entered by the client and Yao’s financial data to verify the accuracy of a report, and I discovered that there is an error and the Yahoo Finance library does not work., in show Error(ModuleNotFoundError: No module named ‘yfinance’) i want Help Read More
Users cannot see the Sharepoint data in Powerapps, but can edit it in Sharepoint itself
Hello,
I changed some Sharepoint permissions because I wanted to solve the classic “I want the user to be able to read and edit the data from Power Apps, but not in Sharepoint” problem. I created a new permission level, broke some inheritances, changed the item level permissions in one of the lists, etc. It didn’t work, so I changed everything again. I gave the users back the basic permission level to edit, but it seems I messed up pretty bad, because my test user with that permission level can do everything with the sharepoint lists in Sharepoint, but doesn’t see any data in Power Apps. I’ve waited, created a new app from the same list, reassigned permissions (I’ve been working on this with small breaks for about 7 hours), but nothing helps. Maybe I forgot to change something again, but I have no idea. The power apps are shared with the test user who has edit permissions on the sharepoint list, so it should work. I don’t even want to solve my first problem anymore, I just want to undo the whole thing so that users can use my app. I think it’s a sharepoint issue rather than a power apps issue, but maybe one of you can help.
Thank you!
Hello,I changed some Sharepoint permissions because I wanted to solve the classic “I want the user to be able to read and edit the data from Power Apps, but not in Sharepoint” problem. I created a new permission level, broke some inheritances, changed the item level permissions in one of the lists, etc. It didn’t work, so I changed everything again. I gave the users back the basic permission level to edit, but it seems I messed up pretty bad, because my test user with that permission level can do everything with the sharepoint lists in Sharepoint, but doesn’t see any data in Power Apps. I’ve waited, created a new app from the same list, reassigned permissions (I’ve been working on this with small breaks for about 7 hours), but nothing helps. Maybe I forgot to change something again, but I have no idea. The power apps are shared with the test user who has edit permissions on the sharepoint list, so it should work. I don’t even want to solve my first problem anymore, I just want to undo the whole thing so that users can use my app. I think it’s a sharepoint issue rather than a power apps issue, but maybe one of you can help.Thank you! Read More
Add Entries to WMI
Hello all, i am urgently looking for help from you guys. I have this script with entries that are being written to the registry. I am looking for a way to write the same entries into custom WMI class as well. Here is the script.
$RegKeyName = “OSDBuild”
# Set values
$tsenv = New-Object -COMObject Microsoft.SMS.TSEnvironment
$FullRegKeyName = “HKLM:SOFTWARE” + $regkeyname
# Create Registry key
New-Item -Path $FullRegKeyName -type Directory -Force -ErrorAction SilentlyContinue
# Get values
$InstallTime = Get-Date -Format G
$OSDStartTime = $tsenv.Value(“OSDStartTime”)
$AdvertisementID = $tsenv.Value(“_SMSTSAdvertID”)
$Organisation = $tsenv.value(“_SMSTSOrgName”)
$TaskSequenceID = $tsenv.value(“_SMSTSPackageID”)
$Packagename = $tsenv.value(“_SMSTSPackageName”)
$MachineName = $env:computername
$Installationmode = $tsenv.value(“_SMSTSLaunchMode”)
#Calculate time elapsed
$OSDTImeSpan = New-TimeSpan -start $OSDStartTime -end $installtime
$OSDDuration = “{0:hh}:{0:mm}:{0:ss}” -f $OSDTimeSpan
# Write values
new-itemproperty $FullRegKeyName -Name “Installed Date” -Value $InstallTime -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “OSD Start Time” -Value $OSDStartTime -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
New-ItemProperty $FullRegKeyName -Name “OSD Duration” -Value $OSDDuration -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “OrganisationName” -Value $Organisation -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “AdvertisementID” -Value $AdvertisementID -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “TaskSequenceID” -Value $TaskSequenceID -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “Task Sequence Name” -Value $Packagename -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “Installation Type” -Value $Installationmode -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “Computername” -Value $MachineName -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
New-ItemProperty $FullRegKeyName -Name “OS Version” -value (Get-CimInstance Win32_Operatingsystem).version -PropertyType String -Force | Out-Null
Hello all, i am urgently looking for help from you guys. I have this script with entries that are being written to the registry. I am looking for a way to write the same entries into custom WMI class as well. Here is the script. $RegKeyName = “OSDBuild”
# Set values
$tsenv = New-Object -COMObject Microsoft.SMS.TSEnvironment
$FullRegKeyName = “HKLM:SOFTWARE” + $regkeyname
# Create Registry key
New-Item -Path $FullRegKeyName -type Directory -Force -ErrorAction SilentlyContinue
# Get values
$InstallTime = Get-Date -Format G
$OSDStartTime = $tsenv.Value(“OSDStartTime”)
$AdvertisementID = $tsenv.Value(“_SMSTSAdvertID”)
$Organisation = $tsenv.value(“_SMSTSOrgName”)
$TaskSequenceID = $tsenv.value(“_SMSTSPackageID”)
$Packagename = $tsenv.value(“_SMSTSPackageName”)
$MachineName = $env:computername
$Installationmode = $tsenv.value(“_SMSTSLaunchMode”)
#Calculate time elapsed
$OSDTImeSpan = New-TimeSpan -start $OSDStartTime -end $installtime
$OSDDuration = “{0:hh}:{0:mm}:{0:ss}” -f $OSDTimeSpan
# Write values
new-itemproperty $FullRegKeyName -Name “Installed Date” -Value $InstallTime -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “OSD Start Time” -Value $OSDStartTime -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
New-ItemProperty $FullRegKeyName -Name “OSD Duration” -Value $OSDDuration -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “OrganisationName” -Value $Organisation -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “AdvertisementID” -Value $AdvertisementID -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “TaskSequenceID” -Value $TaskSequenceID -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “Task Sequence Name” -Value $Packagename -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “Installation Type” -Value $Installationmode -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
new-itemproperty $FullRegKeyName -Name “Computername” -Value $MachineName -Type STRING -Force -ErrorAction SilentlyContinue | Out-Null
New-ItemProperty $FullRegKeyName -Name “OS Version” -value (Get-CimInstance Win32_Operatingsystem).version -PropertyType String -Force | Out-Null Read More
Function with multiple input parameters to be determined through fitting
Hi, I have a function to be fitted to some experimental data, but this function has multiple fitting parameters (6 parameters). I know that one of the ways to find these fitting parameters is to pass the function, the inital guess to the parameters and the lower and upper bounds into the lsqcurvefit function.
I have already created the function, but it seems like the software doesn’t know that the p(1),p(2), p(3)… are parameters. Sorry if the function is very long.
What I wanted was p to be a vector with 6 elements p(1) p(2) p(3) p(4) p(5) p(6) but it seems like the software cant differentiate betwen p and p(1) p(2) p(3) p(4) p(5) p(6). When I try running the code, the error message I got was "Not enough input arguments"
Thank you for helping
function F = EM_SS(p, E_p)
F = p(1)*(2*pi*sqrt(p(4))/E_p)*(1/p(6))*(int(sech(((E_p – E)./p(6)))*(1 + 10*p(5)*(E – p(3)) + 126*p(5)^2*(E – p(3))^2)/(1 – exp(-2*pi*sqrt(p(4)/(E – p(3))))), E, p(3), Inf, ‘ArrayValued’, 1)) + p(2)*(2*pi*p(4)^3/2)*1/p(6)*((1/1^3)*sech((E_p – p(3) + p(4)/1^2)./p(6)) + (1/2^3)*sech((E_p – p(3) + p(4)/2^2)./p(6)) + (1/3^3)*sech((E_p – p(3) + p(4)/3^2)./p(6)) + (1/4^3)*sech((E_p – p(3) + p(4)/4^2)./p(6)) + (1/5^3)*sech((E_p – p(3) + p(4)/5^2)./p(6)) + (1/6^3)*sech((E_p – p(3) + p(4)/6^2)./p(6)) + (1/7^3)*sech((E_p – p(3) + p(4)/7^2)./p(6)));
endHi, I have a function to be fitted to some experimental data, but this function has multiple fitting parameters (6 parameters). I know that one of the ways to find these fitting parameters is to pass the function, the inital guess to the parameters and the lower and upper bounds into the lsqcurvefit function.
I have already created the function, but it seems like the software doesn’t know that the p(1),p(2), p(3)… are parameters. Sorry if the function is very long.
What I wanted was p to be a vector with 6 elements p(1) p(2) p(3) p(4) p(5) p(6) but it seems like the software cant differentiate betwen p and p(1) p(2) p(3) p(4) p(5) p(6). When I try running the code, the error message I got was "Not enough input arguments"
Thank you for helping
function F = EM_SS(p, E_p)
F = p(1)*(2*pi*sqrt(p(4))/E_p)*(1/p(6))*(int(sech(((E_p – E)./p(6)))*(1 + 10*p(5)*(E – p(3)) + 126*p(5)^2*(E – p(3))^2)/(1 – exp(-2*pi*sqrt(p(4)/(E – p(3))))), E, p(3), Inf, ‘ArrayValued’, 1)) + p(2)*(2*pi*p(4)^3/2)*1/p(6)*((1/1^3)*sech((E_p – p(3) + p(4)/1^2)./p(6)) + (1/2^3)*sech((E_p – p(3) + p(4)/2^2)./p(6)) + (1/3^3)*sech((E_p – p(3) + p(4)/3^2)./p(6)) + (1/4^3)*sech((E_p – p(3) + p(4)/4^2)./p(6)) + (1/5^3)*sech((E_p – p(3) + p(4)/5^2)./p(6)) + (1/6^3)*sech((E_p – p(3) + p(4)/6^2)./p(6)) + (1/7^3)*sech((E_p – p(3) + p(4)/7^2)./p(6)));
end Hi, I have a function to be fitted to some experimental data, but this function has multiple fitting parameters (6 parameters). I know that one of the ways to find these fitting parameters is to pass the function, the inital guess to the parameters and the lower and upper bounds into the lsqcurvefit function.
I have already created the function, but it seems like the software doesn’t know that the p(1),p(2), p(3)… are parameters. Sorry if the function is very long.
What I wanted was p to be a vector with 6 elements p(1) p(2) p(3) p(4) p(5) p(6) but it seems like the software cant differentiate betwen p and p(1) p(2) p(3) p(4) p(5) p(6). When I try running the code, the error message I got was "Not enough input arguments"
Thank you for helping
function F = EM_SS(p, E_p)
F = p(1)*(2*pi*sqrt(p(4))/E_p)*(1/p(6))*(int(sech(((E_p – E)./p(6)))*(1 + 10*p(5)*(E – p(3)) + 126*p(5)^2*(E – p(3))^2)/(1 – exp(-2*pi*sqrt(p(4)/(E – p(3))))), E, p(3), Inf, ‘ArrayValued’, 1)) + p(2)*(2*pi*p(4)^3/2)*1/p(6)*((1/1^3)*sech((E_p – p(3) + p(4)/1^2)./p(6)) + (1/2^3)*sech((E_p – p(3) + p(4)/2^2)./p(6)) + (1/3^3)*sech((E_p – p(3) + p(4)/3^2)./p(6)) + (1/4^3)*sech((E_p – p(3) + p(4)/4^2)./p(6)) + (1/5^3)*sech((E_p – p(3) + p(4)/5^2)./p(6)) + (1/6^3)*sech((E_p – p(3) + p(4)/6^2)./p(6)) + (1/7^3)*sech((E_p – p(3) + p(4)/7^2)./p(6)));
end curve fitting, lsqcurvefit MATLAB Answers — New Questions
intarpulation on a sin wall
I have a large data set and want to interpolate it; I am using this code to do so. Is there bater way or method to do so? My wave amplitude is 3.6mm, and length is 28.8 mm, which is very short. Any idea? i see some people segest Karnels intepulation? (i dont see a point to uplode any data it really simpal 2D data of velocity in a wavy tunnel, just want any good idea of intarpulations). i have large amount of waves and measurments so i need to be fast as well.
F_u = scatteredInterpolant(section_x(:), section_y(:), section_u(:), ‘linear’, ‘none’);
interp_u = F_u(interp_x, interp_y);
F_v = scatteredInterpolant(section_x(:), section_y(:), section_v(:), ‘linear’, ‘none’);
interp_v = F_v(interp_x, interp_y);
F_T = scatteredInterpolant(section_x(:), section_y(:), section_T(:), ‘linear’, ‘none’);
interp_T = F_T(interp_x, interp_y);
F_P = scatteredInterpolant(section_x(:), section_y(:), section_P(:), ‘linear’, ‘none’);
interp_P = F_P(interp_x, interp_y);
F_Tw = scatteredInterpolant(section_x(:), section_y(:), section_Tw(:), ‘linear’, ‘none’);
interp_Tw = F_Tw(interp_x, interp_y);I have a large data set and want to interpolate it; I am using this code to do so. Is there bater way or method to do so? My wave amplitude is 3.6mm, and length is 28.8 mm, which is very short. Any idea? i see some people segest Karnels intepulation? (i dont see a point to uplode any data it really simpal 2D data of velocity in a wavy tunnel, just want any good idea of intarpulations). i have large amount of waves and measurments so i need to be fast as well.
F_u = scatteredInterpolant(section_x(:), section_y(:), section_u(:), ‘linear’, ‘none’);
interp_u = F_u(interp_x, interp_y);
F_v = scatteredInterpolant(section_x(:), section_y(:), section_v(:), ‘linear’, ‘none’);
interp_v = F_v(interp_x, interp_y);
F_T = scatteredInterpolant(section_x(:), section_y(:), section_T(:), ‘linear’, ‘none’);
interp_T = F_T(interp_x, interp_y);
F_P = scatteredInterpolant(section_x(:), section_y(:), section_P(:), ‘linear’, ‘none’);
interp_P = F_P(interp_x, interp_y);
F_Tw = scatteredInterpolant(section_x(:), section_y(:), section_Tw(:), ‘linear’, ‘none’);
interp_Tw = F_Tw(interp_x, interp_y); I have a large data set and want to interpolate it; I am using this code to do so. Is there bater way or method to do so? My wave amplitude is 3.6mm, and length is 28.8 mm, which is very short. Any idea? i see some people segest Karnels intepulation? (i dont see a point to uplode any data it really simpal 2D data of velocity in a wavy tunnel, just want any good idea of intarpulations). i have large amount of waves and measurments so i need to be fast as well.
F_u = scatteredInterpolant(section_x(:), section_y(:), section_u(:), ‘linear’, ‘none’);
interp_u = F_u(interp_x, interp_y);
F_v = scatteredInterpolant(section_x(:), section_y(:), section_v(:), ‘linear’, ‘none’);
interp_v = F_v(interp_x, interp_y);
F_T = scatteredInterpolant(section_x(:), section_y(:), section_T(:), ‘linear’, ‘none’);
interp_T = F_T(interp_x, interp_y);
F_P = scatteredInterpolant(section_x(:), section_y(:), section_P(:), ‘linear’, ‘none’);
interp_P = F_P(interp_x, interp_y);
F_Tw = scatteredInterpolant(section_x(:), section_y(:), section_Tw(:), ‘linear’, ‘none’);
interp_Tw = F_Tw(interp_x, interp_y); interpolation, scatteredinterpolant MATLAB Answers — New Questions
Pixel by pixel comparison of 5 matrices into new matrices.
Hello!
I have 5 matrices: M1 = randi(100,10) , M2, M3 etc.
I want to be able to make new matrices with all of the same pixels in each matrix (so N1 = M1(1), M2(1) etc. until I reach N100 = M1(100), M2(100), etc.). I can do this manually, but the size of each matrix(10×10) would make this a very long process. I have been trying to mess around with for loops but cannot seem to figure out how to properly use them to create all 100 1×5 matrices. Are there any tips or ways to make this process happen? I tried using cell arrays as well in a for loop and yet I still am unable to do so.Hello!
I have 5 matrices: M1 = randi(100,10) , M2, M3 etc.
I want to be able to make new matrices with all of the same pixels in each matrix (so N1 = M1(1), M2(1) etc. until I reach N100 = M1(100), M2(100), etc.). I can do this manually, but the size of each matrix(10×10) would make this a very long process. I have been trying to mess around with for loops but cannot seem to figure out how to properly use them to create all 100 1×5 matrices. Are there any tips or ways to make this process happen? I tried using cell arrays as well in a for loop and yet I still am unable to do so. Hello!
I have 5 matrices: M1 = randi(100,10) , M2, M3 etc.
I want to be able to make new matrices with all of the same pixels in each matrix (so N1 = M1(1), M2(1) etc. until I reach N100 = M1(100), M2(100), etc.). I can do this manually, but the size of each matrix(10×10) would make this a very long process. I have been trying to mess around with for loops but cannot seem to figure out how to properly use them to create all 100 1×5 matrices. Are there any tips or ways to make this process happen? I tried using cell arrays as well in a for loop and yet I still am unable to do so. matrices, image segmentation, for loop, help MATLAB Answers — New Questions
struct to restrict curve in max problem
I have to keep the blue curve for a=1.617915e-01 (black broken line) to a=1.619728e-01. There’s a small segment of the curve near the black vertical line that is unwanted. How can I remove it?
clear all
warning off
format long
set(0,’DefaultAxesFontSize’,20);
figure;
load(‘H_LC(1).mat’);
dim=2; %number of variables of my system which are x and y
MM=max(x(1:dim:end-2,:));
plot(x(end,:),MM,’b’, ‘LineWidth’,2);
xlabel(‘$arightarrow$’,’FontSize’,20,’interpreter’,’latex’,’FontWeight’,’normal’,’Color’,’k’);
ylabel(‘$brightarrow$’,’FontSize’,20,’interpreter’,’latex’,’FontWeight’,’normal’,’Color’,’k’);
hold on; xline(1.617915e-01,’k–‘, ‘LineWidth’,1);
axis([.16175 .1621 .3 1]);I have to keep the blue curve for a=1.617915e-01 (black broken line) to a=1.619728e-01. There’s a small segment of the curve near the black vertical line that is unwanted. How can I remove it?
clear all
warning off
format long
set(0,’DefaultAxesFontSize’,20);
figure;
load(‘H_LC(1).mat’);
dim=2; %number of variables of my system which are x and y
MM=max(x(1:dim:end-2,:));
plot(x(end,:),MM,’b’, ‘LineWidth’,2);
xlabel(‘$arightarrow$’,’FontSize’,20,’interpreter’,’latex’,’FontWeight’,’normal’,’Color’,’k’);
ylabel(‘$brightarrow$’,’FontSize’,20,’interpreter’,’latex’,’FontWeight’,’normal’,’Color’,’k’);
hold on; xline(1.617915e-01,’k–‘, ‘LineWidth’,1);
axis([.16175 .1621 .3 1]); I have to keep the blue curve for a=1.617915e-01 (black broken line) to a=1.619728e-01. There’s a small segment of the curve near the black vertical line that is unwanted. How can I remove it?
clear all
warning off
format long
set(0,’DefaultAxesFontSize’,20);
figure;
load(‘H_LC(1).mat’);
dim=2; %number of variables of my system which are x and y
MM=max(x(1:dim:end-2,:));
plot(x(end,:),MM,’b’, ‘LineWidth’,2);
xlabel(‘$arightarrow$’,’FontSize’,20,’interpreter’,’latex’,’FontWeight’,’normal’,’Color’,’k’);
ylabel(‘$brightarrow$’,’FontSize’,20,’interpreter’,’latex’,’FontWeight’,’normal’,’Color’,’k’);
hold on; xline(1.617915e-01,’k–‘, ‘LineWidth’,1);
axis([.16175 .1621 .3 1]); plotting MATLAB Answers — New Questions
How to predict with 1Dconvolution layers: get 3 channels to produce one output?
Hello there I am tying to build a model to test what a 1D convolution layer will do to my data. I have 3 input accelerometer mesurements in the x,y,z directions and am trying to predict a continuous output. The Xtrain is a 3×500 double with the 3 input accelerometer mesurements over 500 time steps and the Ytrain is a 1×500 double of the target output variable. The code I have developed is here:
numFilters = 64;
filterSize = 5;
droupoutFactor = 0.005;
numBlocks = 4;
dilationFactor = 1;
net = dlnetwork;
layers = sequenceInputLayer(NumFeatures,Normalization="rescale-symmetric",Name="inputaccelerometers")
convolution1dLayer(filterSize,numFilters,DilationFactor=dilationFactor,Padding="causal",Name="conv1_")
net = addLayers(net,layers)
options = trainingOptions("adam", …
MaxEpochs=60, …
miniBatchSize=1, …
InputDataFormats="CTB", …
Plots="training-progress", …
Metrics="rmse", …
Verbose=0);
net = trainnet(Xtrain’,Ytrain’,net,"mse",options)
But when I try and train the model I get and error that says: Number of channels in predictions (3) must match the number of channels in the targets (1). Do I need to add another layer to convert the inputs into one predicted output and which layer should I use to do this? Any suggestions on how to remove this error and get the network to run accurately? Thanks so much!Hello there I am tying to build a model to test what a 1D convolution layer will do to my data. I have 3 input accelerometer mesurements in the x,y,z directions and am trying to predict a continuous output. The Xtrain is a 3×500 double with the 3 input accelerometer mesurements over 500 time steps and the Ytrain is a 1×500 double of the target output variable. The code I have developed is here:
numFilters = 64;
filterSize = 5;
droupoutFactor = 0.005;
numBlocks = 4;
dilationFactor = 1;
net = dlnetwork;
layers = sequenceInputLayer(NumFeatures,Normalization="rescale-symmetric",Name="inputaccelerometers")
convolution1dLayer(filterSize,numFilters,DilationFactor=dilationFactor,Padding="causal",Name="conv1_")
net = addLayers(net,layers)
options = trainingOptions("adam", …
MaxEpochs=60, …
miniBatchSize=1, …
InputDataFormats="CTB", …
Plots="training-progress", …
Metrics="rmse", …
Verbose=0);
net = trainnet(Xtrain’,Ytrain’,net,"mse",options)
But when I try and train the model I get and error that says: Number of channels in predictions (3) must match the number of channels in the targets (1). Do I need to add another layer to convert the inputs into one predicted output and which layer should I use to do this? Any suggestions on how to remove this error and get the network to run accurately? Thanks so much! Hello there I am tying to build a model to test what a 1D convolution layer will do to my data. I have 3 input accelerometer mesurements in the x,y,z directions and am trying to predict a continuous output. The Xtrain is a 3×500 double with the 3 input accelerometer mesurements over 500 time steps and the Ytrain is a 1×500 double of the target output variable. The code I have developed is here:
numFilters = 64;
filterSize = 5;
droupoutFactor = 0.005;
numBlocks = 4;
dilationFactor = 1;
net = dlnetwork;
layers = sequenceInputLayer(NumFeatures,Normalization="rescale-symmetric",Name="inputaccelerometers")
convolution1dLayer(filterSize,numFilters,DilationFactor=dilationFactor,Padding="causal",Name="conv1_")
net = addLayers(net,layers)
options = trainingOptions("adam", …
MaxEpochs=60, …
miniBatchSize=1, …
InputDataFormats="CTB", …
Plots="training-progress", …
Metrics="rmse", …
Verbose=0);
net = trainnet(Xtrain’,Ytrain’,net,"mse",options)
But when I try and train the model I get and error that says: Number of channels in predictions (3) must match the number of channels in the targets (1). Do I need to add another layer to convert the inputs into one predicted output and which layer should I use to do this? Any suggestions on how to remove this error and get the network to run accurately? Thanks so much! neural network, convolution layer, input MATLAB Answers — New Questions
Azure Streaming Analytics Job not writing data to Azure storage container
Hello,
I have a situation where my Azure Streaming Analytics job is not writing the incoming events coming from our IoT Hub to the Azure storage container.
Within my dashboard, The IoT Hub Usage states there are several thousand messages coming through daily.
Below were the steps taken to start troubleshooting my problem:
Tested both the input and output connections from the query and they were both successfulUploaded test data and the file format has not changedChecked for errors within the input/IoT Hub for malformed and/or deserialization errors but there are none
Any help with this problem would be greatly appreciated.
Thank you
Hello, I have a situation where my Azure Streaming Analytics job is not writing the incoming events coming from our IoT Hub to the Azure storage container. Within my dashboard, The IoT Hub Usage states there are several thousand messages coming through daily. Below were the steps taken to start troubleshooting my problem: Tested both the input and output connections from the query and they were both successfulUploaded test data and the file format has not changedChecked for errors within the input/IoT Hub for malformed and/or deserialization errors but there are noneAny help with this problem would be greatly appreciated. Thank you Read More
Shifting from Thunderbird to Outlook
I have created a bunch of filters and folders, so that incoming mail is moved to the desired folder as soon as it comes in. But, unlike Thunderbird, the Outlook folder name does not become bold (dark characters) to indicate that there is new/unread email in this folder. Is there something I can set, for Outlook to show which folders have unread email
I have created a bunch of filters and folders, so that incoming mail is moved to the desired folder as soon as it comes in. But, unlike Thunderbird, the Outlook folder name does not become bold (dark characters) to indicate that there is new/unread email in this folder. Is there something I can set, for Outlook to show which folders have unread email Read More
Microsoft CSP – Indirect Reseller Status is Suspended and Can’t Get Fixed
I am in a very bad spot with our indirect reseller Microsoft account and am hoping that maybe someone out there might be able to help me.
In mid May, I placed an order with Pax8 for a new customer and the order was rejected by Microsoft with the error, “Associated partner LegalBusinessProfile NotFound.”
It turns out that when we moved offices and I updated our business’s address at partner.microsoft.com, Microsoft de-authorized our partner status, which I didn’t catch, and then put our Cloud Service Provider (CSP) indirect reseller program into “Suspended” status after some time.
In the partner center, I was able to get our legal business profile fixed easy enough – I just had to open a ticket and send them some legal documentation. Everything under the “Partner” tab in the Partner Portal is now green checkboxes and “Authorized”. Pax8 tried the provisioning again, and got the same error.
It turns out that our “Indirect Reseller status” is now “Suspended” and this wasn’t changed when the “Partner” status was fixed.
Microsoft has a webpage that describes why this can happen and what to do to get it fixed at https://learn.microsoft.com/en-us/partner-center/account-settings/suspended-partner-center-account . It says, “Microsoft suspends Partner Center accounts for Microsoft AI Cloud Partner Program when:
Significant account abuse is detected
Your vetting status is Rejected for more than 30 days”
We haven’t had any account abuse (mercifully, our existing tenants are still operational and being billed for through Pax8), so our vetting status was almost certainly to blame. That same document says, “If you are sure that your account is compliant and should be moved back to Active state, contact Support for help with reactivating your account,” so I opened a ticket with Microsoft.
Actually, 3 tickets so far, because every single one has the same copy-and-paste reply:
Thank you for contacting Microsoft Partner support about the suspension of the CSP account.
In the Microsoft AI Cloud Partner Program Agreement, both Microsoft and our partners reserve the right to walk away from the partner relationship by providing 30 days’ notice to the other. The notice of suspension and termination proceeding was provided April 2024. Neither party is required to offer an explanation for the decision to terminate the partner agreement. As Microsoft is exercising its rights under this section 4.b of the Microsoft AI Cloud Program Agreement, we are unable to share an explanation or further details.
Thanks,
I can’t get anywhere with Microsoft support. We just landed a big customer and need to set up their tenant. I am afraid that if this goes on much longer or if somehow we are unable to add any more customers to our Pax8 account, that we’ll lose this customer, which is large enough to really hurt the business.
Does anyone here have any ideas on how to get through to someone at Microsoft that could help with this situation? Does anyone else have any other ideas on what else we could try?
Some additional notes:
When clicking “Agreements” in the partner portal, we get an error message, “Service unavailable. Something went wrong. Please try reloading the page, if this problem persists please contact Microsoft support.”
Everything in Legal Info/Partner looks good. Our “Microsoft AI Cloud Partner Program status” is “Active”.
Everything in Legal Info/Reseller looks good except that “Indirect Reseller status” shows “Suspended”.
Under Identifiers/Microsoft AI Cloud Partner Program, I have 1 PartnerGlobal ID and 2 PartnerLocation IDs, corresponding to our old and new addresses. Do I need to delete the old PartnerLocation ID? I haven’t done so because it looks like this step is irreversible but I am getting desperate enough to try it.
Our “Company profile” is not filled out, but the “Update” button stays grayed out after I fill in the information and it appears that I am unable to update this.
I thought that maybe I just needed to sign the “Microsoft AI Cloud Partner Program Agreement” again, but I can’t find anywhere on the partner portal where I would do so.
I went through my emails exhaustively and we did not receive a, “notice of suspension and termination proceeding” in April 2024, or any other time for that matter.
I can’t find a copy of the Microsoft AI Cloud Program Agreement to even see what section 4.b says.
I’ve dealt with government bureaucracies a lot in my career, but I’ve never experienced a Kafkaesque situation 10% as bad as this one. This is probably the most stressful thing I’ve dealt with in this business in the last decade. This could destroy our business if I can’t get this sorted out.
Sorry for the wall of text, but I tried to include as much detail as possible and it got long. If you got to this point in my post, thank you for helping or trying to help me.
The latest ticket ID we have from Microsoft is 2406050040012239
I am in a very bad spot with our indirect reseller Microsoft account and am hoping that maybe someone out there might be able to help me.In mid May, I placed an order with Pax8 for a new customer and the order was rejected by Microsoft with the error, “Associated partner LegalBusinessProfile NotFound.”It turns out that when we moved offices and I updated our business’s address at partner.microsoft.com, Microsoft de-authorized our partner status, which I didn’t catch, and then put our Cloud Service Provider (CSP) indirect reseller program into “Suspended” status after some time.In the partner center, I was able to get our legal business profile fixed easy enough – I just had to open a ticket and send them some legal documentation. Everything under the “Partner” tab in the Partner Portal is now green checkboxes and “Authorized”. Pax8 tried the provisioning again, and got the same error.It turns out that our “Indirect Reseller status” is now “Suspended” and this wasn’t changed when the “Partner” status was fixed.Microsoft has a webpage that describes why this can happen and what to do to get it fixed at https://learn.microsoft.com/en-us/partner-center/account-settings/suspended-partner-center-account . It says, “Microsoft suspends Partner Center accounts for Microsoft AI Cloud Partner Program when:Significant account abuse is detectedYour vetting status is Rejected for more than 30 days”We haven’t had any account abuse (mercifully, our existing tenants are still operational and being billed for through Pax8), so our vetting status was almost certainly to blame. That same document says, “If you are sure that your account is compliant and should be moved back to Active state, contact Support for help with reactivating your account,” so I opened a ticket with Microsoft.Actually, 3 tickets so far, because every single one has the same copy-and-paste reply:Thank you for contacting Microsoft Partner support about the suspension of the CSP account. In the Microsoft AI Cloud Partner Program Agreement, both Microsoft and our partners reserve the right to walk away from the partner relationship by providing 30 days’ notice to the other. The notice of suspension and termination proceeding was provided April 2024. Neither party is required to offer an explanation for the decision to terminate the partner agreement. As Microsoft is exercising its rights under this section 4.b of the Microsoft AI Cloud Program Agreement, we are unable to share an explanation or further details. Thanks,I can’t get anywhere with Microsoft support. We just landed a big customer and need to set up their tenant. I am afraid that if this goes on much longer or if somehow we are unable to add any more customers to our Pax8 account, that we’ll lose this customer, which is large enough to really hurt the business.Does anyone here have any ideas on how to get through to someone at Microsoft that could help with this situation? Does anyone else have any other ideas on what else we could try?Some additional notes:When clicking “Agreements” in the partner portal, we get an error message, “Service unavailable. Something went wrong. Please try reloading the page, if this problem persists please contact Microsoft support.”Everything in Legal Info/Partner looks good. Our “Microsoft AI Cloud Partner Program status” is “Active”.Everything in Legal Info/Reseller looks good except that “Indirect Reseller status” shows “Suspended”.Under Identifiers/Microsoft AI Cloud Partner Program, I have 1 PartnerGlobal ID and 2 PartnerLocation IDs, corresponding to our old and new addresses. Do I need to delete the old PartnerLocation ID? I haven’t done so because it looks like this step is irreversible but I am getting desperate enough to try it.Our “Company profile” is not filled out, but the “Update” button stays grayed out after I fill in the information and it appears that I am unable to update this.I thought that maybe I just needed to sign the “Microsoft AI Cloud Partner Program Agreement” again, but I can’t find anywhere on the partner portal where I would do so.I went through my emails exhaustively and we did not receive a, “notice of suspension and termination proceeding” in April 2024, or any other time for that matter.I can’t find a copy of the Microsoft AI Cloud Program Agreement to even see what section 4.b says.I’ve dealt with government bureaucracies a lot in my career, but I’ve never experienced a Kafkaesque situation 10% as bad as this one. This is probably the most stressful thing I’ve dealt with in this business in the last decade. This could destroy our business if I can’t get this sorted out.Sorry for the wall of text, but I tried to include as much detail as possible and it got long. If you got to this point in my post, thank you for helping or trying to help me.The latest ticket ID we have from Microsoft is 2406050040012239 Read More
That should be obvious: get my contacts from outlook.com (OWA) synced Outlook 2016 or Outlook 2019.
Call me stupid; I can’t get my contacts from my outlook.com account to show up in Outlook 2016 for Mac or Outlook2019 for Windows.
All my contacts are on https://outlook.live.com/people/, I can see them in Outlook for Android on my Smartphone but I can’t see them in the desktop apps.
What are the steps to initiate the contacts syncing on desktop apps?
Call me stupid; I can’t get my contacts from my outlook.com account to show up in Outlook 2016 for Mac or Outlook2019 for Windows.All my contacts are on https://outlook.live.com/people/, I can see them in Outlook for Android on my Smartphone but I can’t see them in the desktop apps.What are the steps to initiate the contacts syncing on desktop apps? Read More
Tech Presentations: Key Strategies for Success
Navigating the intricate world of technology requires more than just expertise; it demands the ability to share that knowledge effectively. This article embarks on a journey to uncover the most effective strategies for crafting presentations tailored for the tech-savvy audience. We will dissect the elements that make a presentation not just informative, but memorable and engaging. From leveraging the latest tools to understanding the nuances of audience engagement, we aim to provide a comprehensive guide that empowers tech professionals to deliver their message with precision and impact. We’ll discuss these strategies with U.S. M365 MVP Melissa Marshall.
MVP Melissa Marshall
Share with us your journey into becoming a top-level presenter.
I started my career as a professor at Penn State University, where I taught public speaking courses for engineering students. While I was there, I had the good fortune to give a TED Talk entitled “Talk Nerdy to Me” about the importance of science communication, and that really launched my ideas on scientific presentations into global prominence. I began to receive additional invitations to speak at conferences and provide training workshops at companies and institutions. In 2015, I went full-time into my speaking, training, and consulting business, Present Your Science. I now help the leading tech professionals and companies in the world present their work in a meaningful and compelling way that inspires stakeholders to take action.
Could you please share with us the three main tools to improve presentations?
Be audience-centric. Your ability to be successful as a speaker depends upon your ability to make your audience successful.
TIP: Be an interpreter of your work, not a reporter. Always connect each piece of technical info to a “So what?” point.
Filter and Focus. When you try to share everything, you share nothing.
TIP: Start your planning with the ‘view’ you want your audience to have at the end of the talk. Then ask yourself “What would they need to know in order to get there?”
Show Your Science. Your slides should do something for you that your words cannot. This means make your slides VISUAL not VERBAL.
TIP: Avoid bullet points (seriously!). Have a brief take-away message at the top of each slide and support it with visual evidence.
What are the main challenges that presenters face during a presentation?
Presenters often allow the “status quo” of how slides are typically designed in their industry or at their company to dictate their choices. Unfortunately, this status quo is often rooted in text heavy, bulleted slides which are not successful for an audience. Instead of designing slides how you have always seen it done, I think presenters need to use a more strategic, evidence-based approach for their slide design. That’s why I worked with the MS PowerPoint team to create this slide design template for technical presenters. This template is fully customizable, but it helps to lead the presenter to a design strategy that focuses on take away messages supported by visual evidence. Which is a big step in the right direction for technical slides that are more successful for an audience.
Also, presenters often struggle to filter their details in presentations, and they overwhelm the audience with too much information. This can be improved by beginning your preparation by identifying the most critical single message you must convey. And then focus on including information that relates to that message.
When sharing data, it’s important to be very descriptive about not just what the data is, but why the data is significant. It is easy to get in the habit of simply sharing the information, without providing context for it.
How are you using AI today to help you with presentations?
I love sharing PowerPoint Speaker Coach with my clients. This is an awesome AI-Driven tool that provides the speaker with private feedback on presentation elements like rate of speaking, emphasis, verbal fillers, and inclusive language. It’s a great way to add some structure and purpose to practicing a presentation.
What advice would you have for tech professionals beginning their journey presenting?
Look for more opportunities to present! Most people have some anxiety associated with speaking in front of others, which causes them to avoid those situations as much as possible. However, the answer to becoming more comfortable speaking is to simply DO IT MORE. It’s counterintuitive to what we feel like we want to do, but if you embraced the discomfort of presenting more often, you would find quite quickly that you are all the sudden becoming more comfortable and confident.
In summary, the journey through the landscape of technical presentations is one of continuous learning and adaptation. The strategies discussed here provide a roadmap for creating presentations that not only convey complex information but also engage and inspire the tech community. By weaving together a narrative that resonates with the audience, utilizing visual aids to clarify and emphasize key points, and delivering with confidence and passion, presenters can leave a lasting impact. As technology continues to advance, so must our approach to sharing it. Let this article serve as a catalyst for innovation in your presentation techniques, empowering you to illuminate the path forward in the ever-changing world of technology.
Microsoft Tech Community – Latest Blogs –Read More
Maintain formatting while reading PDF document
Hello, while reading a PDF document, I want to let the formatting as it is – for the bold to be bold, for the italic to be italic. I have tried this with extractFileText, but not successful. How can this be done? Thanks.Hello, while reading a PDF document, I want to let the formatting as it is – for the bold to be bold, for the italic to be italic. I have tried this with extractFileText, but not successful. How can this be done? Thanks. Hello, while reading a PDF document, I want to let the formatting as it is – for the bold to be bold, for the italic to be italic. I have tried this with extractFileText, but not successful. How can this be done? Thanks. pdf, formatting, read file, text analytics MATLAB Answers — New Questions
Unable to display the data from the DHT11 sensor on the channel without Wi Fi using TTGO T-Call (=esp32 + SIM800L) and TCP/IP commands
the files attached contains the code that i used , and when i upload, it shows the results in the screenshots below,
Task : sending dht11 data without Wi Fi to thingspeakthe files attached contains the code that i used , and when i upload, it shows the results in the screenshots below,
Task : sending dht11 data without Wi Fi to thingspeak the files attached contains the code that i used , and when i upload, it shows the results in the screenshots below,
Task : sending dht11 data without Wi Fi to thingspeak sim800l, ttgo t-call, data, dht11, arduino ide, tcp/ip MATLAB Answers — New Questions
Quadratic optimization with quadratic constraints
Hi everyone,
I have an optimization problem with a quadratic objective function and quadratic constraint functions AND the problem is non-convex.
Is there any Matlab function which can do this? QUADPROG and FMINCON only allow linear constraints afaik. I also tried a solver by MOSEK (http://mosek.com/) but this only can deal with convex problems. Is there any tool/function for the non-convex case?
Thanks!
RenéHi everyone,
I have an optimization problem with a quadratic objective function and quadratic constraint functions AND the problem is non-convex.
Is there any Matlab function which can do this? QUADPROG and FMINCON only allow linear constraints afaik. I also tried a solver by MOSEK (http://mosek.com/) but this only can deal with convex problems. Is there any tool/function for the non-convex case?
Thanks!
René Hi everyone,
I have an optimization problem with a quadratic objective function and quadratic constraint functions AND the problem is non-convex.
Is there any Matlab function which can do this? QUADPROG and FMINCON only allow linear constraints afaik. I also tried a solver by MOSEK (http://mosek.com/) but this only can deal with convex problems. Is there any tool/function for the non-convex case?
Thanks!
René optimization, nonlinear, mathematics MATLAB Answers — New Questions
MEX-Function execution time issue in Simulink model
I am working on integrating a MEX function into a Simulink model to protect the source code of an algorithm from direct visibility. To achieve this, I converted the original MATLAB function into a MEX function, which I then call within a MATLAB Function block using the coder.extrinsic command.
During my testing, I’ve observed that the MEX function executes at each simulation step and is significantly slower compared to the original MATLAB function, resulting in a much higher overall simulation time.
I have several questions and would appreciate insights from the community:
Why might the MEX function be performing slower than the MATLAB function within the Simulink environment?
How does Simulink handle MEX functions during simulation and compilation?
What are the best practices or correct methods for integrating a MEX function into a Simulink model to ensure optimal performance?
Any detailed explanations or guidance on troubleshooting and improving the performance of MEX functions in Simulink would be highly appreciated. Thank you!I am working on integrating a MEX function into a Simulink model to protect the source code of an algorithm from direct visibility. To achieve this, I converted the original MATLAB function into a MEX function, which I then call within a MATLAB Function block using the coder.extrinsic command.
During my testing, I’ve observed that the MEX function executes at each simulation step and is significantly slower compared to the original MATLAB function, resulting in a much higher overall simulation time.
I have several questions and would appreciate insights from the community:
Why might the MEX function be performing slower than the MATLAB function within the Simulink environment?
How does Simulink handle MEX functions during simulation and compilation?
What are the best practices or correct methods for integrating a MEX function into a Simulink model to ensure optimal performance?
Any detailed explanations or guidance on troubleshooting and improving the performance of MEX functions in Simulink would be highly appreciated. Thank you! I am working on integrating a MEX function into a Simulink model to protect the source code of an algorithm from direct visibility. To achieve this, I converted the original MATLAB function into a MEX function, which I then call within a MATLAB Function block using the coder.extrinsic command.
During my testing, I’ve observed that the MEX function executes at each simulation step and is significantly slower compared to the original MATLAB function, resulting in a much higher overall simulation time.
I have several questions and would appreciate insights from the community:
Why might the MEX function be performing slower than the MATLAB function within the Simulink environment?
How does Simulink handle MEX functions during simulation and compilation?
What are the best practices or correct methods for integrating a MEX function into a Simulink model to ensure optimal performance?
Any detailed explanations or guidance on troubleshooting and improving the performance of MEX functions in Simulink would be highly appreciated. Thank you! simulink, mex function, coder.extrinsic, simulation speed, mex compiler, execution time, matlab compiler MATLAB Answers — New Questions
Assertion block does not stop simulation if I run the model with “sim” function
Hi, I’m having issues with the Assertion block in Simulink when it comes to pause the current simulation.
Please refer to the following toy-example, which is enough to show the problem. Here, the assertion should be triggered after one second of simulation.
Here is what I’m trying to do:
Run the simulation programmatically, using a Matlab script
When a certain condition is met (here: after one seconds of simulation), pause the simulation in order to trigger the model callback "PauseFcn"
After performing some operations within the callback, resume the simulation
Following the documentation, I configured the Assertion block in order to monitor the desired condition and pause the model. Specifically, I set the Assertion block callback to:
set_param(bdroot,’SimulationCommand’,’pause’)
—————————————
If I run the model using Simulink GUI, everything works fine: the model pauses after one second and the "PauseFcn" callabck is executed.
However, if I run the model programmatically using
MyOut = sim("MyModelName");
Then the following happens:
The Assertion block triggers a warning after one second, as it should; the warning is dispayed in the Command Window
Despite this, the simulation does not pause: it proceeds beyond one second.
As an additional consequence, the model callback "PauseFcn" is not triggered (as confirmed by tracing the callbacks)
Do you have any suggestions?
I’m using Matlab R2024aHi, I’m having issues with the Assertion block in Simulink when it comes to pause the current simulation.
Please refer to the following toy-example, which is enough to show the problem. Here, the assertion should be triggered after one second of simulation.
Here is what I’m trying to do:
Run the simulation programmatically, using a Matlab script
When a certain condition is met (here: after one seconds of simulation), pause the simulation in order to trigger the model callback "PauseFcn"
After performing some operations within the callback, resume the simulation
Following the documentation, I configured the Assertion block in order to monitor the desired condition and pause the model. Specifically, I set the Assertion block callback to:
set_param(bdroot,’SimulationCommand’,’pause’)
—————————————
If I run the model using Simulink GUI, everything works fine: the model pauses after one second and the "PauseFcn" callabck is executed.
However, if I run the model programmatically using
MyOut = sim("MyModelName");
Then the following happens:
The Assertion block triggers a warning after one second, as it should; the warning is dispayed in the Command Window
Despite this, the simulation does not pause: it proceeds beyond one second.
As an additional consequence, the model callback "PauseFcn" is not triggered (as confirmed by tracing the callbacks)
Do you have any suggestions?
I’m using Matlab R2024a Hi, I’m having issues with the Assertion block in Simulink when it comes to pause the current simulation.
Please refer to the following toy-example, which is enough to show the problem. Here, the assertion should be triggered after one second of simulation.
Here is what I’m trying to do:
Run the simulation programmatically, using a Matlab script
When a certain condition is met (here: after one seconds of simulation), pause the simulation in order to trigger the model callback "PauseFcn"
After performing some operations within the callback, resume the simulation
Following the documentation, I configured the Assertion block in order to monitor the desired condition and pause the model. Specifically, I set the Assertion block callback to:
set_param(bdroot,’SimulationCommand’,’pause’)
—————————————
If I run the model using Simulink GUI, everything works fine: the model pauses after one second and the "PauseFcn" callabck is executed.
However, if I run the model programmatically using
MyOut = sim("MyModelName");
Then the following happens:
The Assertion block triggers a warning after one second, as it should; the warning is dispayed in the Command Window
Despite this, the simulation does not pause: it proceeds beyond one second.
As an additional consequence, the model callback "PauseFcn" is not triggered (as confirmed by tracing the callbacks)
Do you have any suggestions?
I’m using Matlab R2024a simulink, simulation, callback MATLAB Answers — New Questions