Category: News
Run Simulink Model via parsim() and save after each simulation
I am trying to run my simulink model in parallel while saving the results to a matfile after each simulation has completed.
Each worker should take the following action:
Simulate model with simIn( j )
Create matfile for above simulation
Repeate with simIn ( K ) until all simulations are complete.
The below code is my starting point. "test_model" is a simulink model of only a sin wave going into a gain, integrator, and to workspace block simply to test out parsim().
%% Example of how to run simulink models in parallel
clear; close all; clc;
mdl = "test_model";
amp= 1:10;
freq = 1:10;
nSims = length(amp);
simIn(1:nSims) = Simulink.SimulationInput(mdl);
% Setup model workspace
k = 5;
for i =1:nSims
nm = [num2str(i) ‘.mat’];
simIn(i) = setVariable(simIn(i), "amp", amp(i), ‘Workspace’, mdl);
simIn(i) = setVariable(simIn(i), "freq", freq(i), ‘Workspace’, mdl);
simIn(i) = setPostSimFcn(simIn(i), @(x)postSim(x, simIn(i), nm));
end
out = parsim (simIn, ‘UseFastRestart’,’on’, ‘TransferBaseWorkspaceVariables’,’on’);
function postSim(out, in, nm)
% postSim – Run @ completion of each simulation
% Saves simulation input, output, and name to file "nm"
m = matfile(nm, ‘Writable’, true);
m.out = out;
m.in = in;
m.nm = nm;
end
I understand that save() does not work as expected in parallel, so I’ve implemented the example from the question below as a method of creating my mat files. The above code works exactly as expected if "parsim" is replaced with "sim"; however, no files are created when using "parsim".
https://www.mathworks.com/matlabcentral/answers/135285-how-do-i-use-save-with-a-parfor-loop-using-parallel-computing-toolbox
Note: setting ‘TransferBaseWorkspaceVariables’ to ‘off’ and setting k via setVariable does not have any impact on this behavior.
Ask: How can I modify the above code to also work with the parsim command?I am trying to run my simulink model in parallel while saving the results to a matfile after each simulation has completed.
Each worker should take the following action:
Simulate model with simIn( j )
Create matfile for above simulation
Repeate with simIn ( K ) until all simulations are complete.
The below code is my starting point. "test_model" is a simulink model of only a sin wave going into a gain, integrator, and to workspace block simply to test out parsim().
%% Example of how to run simulink models in parallel
clear; close all; clc;
mdl = "test_model";
amp= 1:10;
freq = 1:10;
nSims = length(amp);
simIn(1:nSims) = Simulink.SimulationInput(mdl);
% Setup model workspace
k = 5;
for i =1:nSims
nm = [num2str(i) ‘.mat’];
simIn(i) = setVariable(simIn(i), "amp", amp(i), ‘Workspace’, mdl);
simIn(i) = setVariable(simIn(i), "freq", freq(i), ‘Workspace’, mdl);
simIn(i) = setPostSimFcn(simIn(i), @(x)postSim(x, simIn(i), nm));
end
out = parsim (simIn, ‘UseFastRestart’,’on’, ‘TransferBaseWorkspaceVariables’,’on’);
function postSim(out, in, nm)
% postSim – Run @ completion of each simulation
% Saves simulation input, output, and name to file "nm"
m = matfile(nm, ‘Writable’, true);
m.out = out;
m.in = in;
m.nm = nm;
end
I understand that save() does not work as expected in parallel, so I’ve implemented the example from the question below as a method of creating my mat files. The above code works exactly as expected if "parsim" is replaced with "sim"; however, no files are created when using "parsim".
https://www.mathworks.com/matlabcentral/answers/135285-how-do-i-use-save-with-a-parfor-loop-using-parallel-computing-toolbox
Note: setting ‘TransferBaseWorkspaceVariables’ to ‘off’ and setting k via setVariable does not have any impact on this behavior.
Ask: How can I modify the above code to also work with the parsim command? I am trying to run my simulink model in parallel while saving the results to a matfile after each simulation has completed.
Each worker should take the following action:
Simulate model with simIn( j )
Create matfile for above simulation
Repeate with simIn ( K ) until all simulations are complete.
The below code is my starting point. "test_model" is a simulink model of only a sin wave going into a gain, integrator, and to workspace block simply to test out parsim().
%% Example of how to run simulink models in parallel
clear; close all; clc;
mdl = "test_model";
amp= 1:10;
freq = 1:10;
nSims = length(amp);
simIn(1:nSims) = Simulink.SimulationInput(mdl);
% Setup model workspace
k = 5;
for i =1:nSims
nm = [num2str(i) ‘.mat’];
simIn(i) = setVariable(simIn(i), "amp", amp(i), ‘Workspace’, mdl);
simIn(i) = setVariable(simIn(i), "freq", freq(i), ‘Workspace’, mdl);
simIn(i) = setPostSimFcn(simIn(i), @(x)postSim(x, simIn(i), nm));
end
out = parsim (simIn, ‘UseFastRestart’,’on’, ‘TransferBaseWorkspaceVariables’,’on’);
function postSim(out, in, nm)
% postSim – Run @ completion of each simulation
% Saves simulation input, output, and name to file "nm"
m = matfile(nm, ‘Writable’, true);
m.out = out;
m.in = in;
m.nm = nm;
end
I understand that save() does not work as expected in parallel, so I’ve implemented the example from the question below as a method of creating my mat files. The above code works exactly as expected if "parsim" is replaced with "sim"; however, no files are created when using "parsim".
https://www.mathworks.com/matlabcentral/answers/135285-how-do-i-use-save-with-a-parfor-loop-using-parallel-computing-toolbox
Note: setting ‘TransferBaseWorkspaceVariables’ to ‘off’ and setting k via setVariable does not have any impact on this behavior.
Ask: How can I modify the above code to also work with the parsim command? simulink, parallel computing toolbox MATLAB Answers — New Questions
Controlled Voltage Source (Three-Phase)
After the three-phase voltage signal passes through the Controlled Voltage Source (Three-Phase), the amplitude becomes root three times the original value, and the phase also changes. But according to the module description:
Instantaneous — The output voltages, [va vb vc], are equal to the values of the input port S.
The signal input and output should be same..
Could anyone help me this question? Many thanks.After the three-phase voltage signal passes through the Controlled Voltage Source (Three-Phase), the amplitude becomes root three times the original value, and the phase also changes. But according to the module description:
Instantaneous — The output voltages, [va vb vc], are equal to the values of the input port S.
The signal input and output should be same..
Could anyone help me this question? Many thanks. After the three-phase voltage signal passes through the Controlled Voltage Source (Three-Phase), the amplitude becomes root three times the original value, and the phase also changes. But according to the module description:
Instantaneous — The output voltages, [va vb vc], are equal to the values of the input port S.
The signal input and output should be same..
Could anyone help me this question? Many thanks. controlled voltage source (three-phase) MATLAB Answers — New Questions
A struct in the workspace window consists of n (say 1000 or more) different variable names. How to quickly look for a variable name without any code?
I am having a struct data type that consists of 2000 different names of places with their avg temperatures . When I open the struct variable I get a huge list. How can I quickly locate the variable and read its values without scrolling down to every variable. I don’t see any find option in the window. One may say I can code it. Yes, I can do that but I am looking for alternative quick ways so that I don’t need to write the code to find it.I am having a struct data type that consists of 2000 different names of places with their avg temperatures . When I open the struct variable I get a huge list. How can I quickly locate the variable and read its values without scrolling down to every variable. I don’t see any find option in the window. One may say I can code it. Yes, I can do that but I am looking for alternative quick ways so that I don’t need to write the code to find it. I am having a struct data type that consists of 2000 different names of places with their avg temperatures . When I open the struct variable I get a huge list. How can I quickly locate the variable and read its values without scrolling down to every variable. I don’t see any find option in the window. One may say I can code it. Yes, I can do that but I am looking for alternative quick ways so that I don’t need to write the code to find it. quick variable search in struct variable window MATLAB Answers — New Questions
Custom fields in Email confirmation
Hello,
I would like to include one of the custom fields in the email confirmation. At this point I dont think it is possible in bookings, unless I am terribly missing something obvious.
Thanks!
Hello,I would like to include one of the custom fields in the email confirmation. At this point I dont think it is possible in bookings, unless I am terribly missing something obvious. Thanks! Read More
Excel not sorting numbers correctly
I have what I hope is a simple problem – all that I need is for excel to sort numbers numerically. Instead, it is sorting them 1, 10, 11 … 19, 2, 20, etc.
I’ve tried pasting my raw data as values, I’ve tried converting to number, I’ve tried =CLEAN, =TRIM, =SUBSTITUTE, I’ve tried pasting just the numbers as values, none of it is working. When I do =ISNUMBER, it keeps coming back false no matter what I try.
My function for Stop (clean) is =CLEAN(TRIM(SUBSTITUTE(C2,CHAR(160),””)))
I have what I hope is a simple problem – all that I need is for excel to sort numbers numerically. Instead, it is sorting them 1, 10, 11 … 19, 2, 20, etc.I’ve tried pasting my raw data as values, I’ve tried converting to number, I’ve tried =CLEAN, =TRIM, =SUBSTITUTE, I’ve tried pasting just the numbers as values, none of it is working. When I do =ISNUMBER, it keeps coming back false no matter what I try.My function for Stop (clean) is =CLEAN(TRIM(SUBSTITUTE(C2,CHAR(160),””))) Read More
Inactivating some of the builtin Microsoft Sensitive Information Types / SITs?
In Purview’s CONTENT EXPLORER we see all 300+ built-in Microsoft SITs being discovered – about 2/3 of which aren’t relevant to my org (i.e. identification numbers, social welfare numbers, passport numbers, revenue numbers, etc. from other countries – PNG attached with a few of them highlighted).
Is there any way to inactivate or NOT search for/identify these irrelevant SITs?
In Purview’s CONTENT EXPLORER we see all 300+ built-in Microsoft SITs being discovered – about 2/3 of which aren’t relevant to my org (i.e. identification numbers, social welfare numbers, passport numbers, revenue numbers, etc. from other countries – PNG attached with a few of them highlighted).Is there any way to inactivate or NOT search for/identify these irrelevant SITs? Read More
Shared / Shift Mobile Phone
Hi All
I hope you are well.
Anyway, is it possible to deploy a config that allows for a Mobile Phone to be shared amongst shift users?
Does Entra Shared Device Mode cover this scenario?
Info appreciated.
Stuart
Hi All I hope you are well. Anyway, is it possible to deploy a config that allows for a Mobile Phone to be shared amongst shift users? Does Entra Shared Device Mode cover this scenario? Info appreciated. Stuart Read More
Teams calendar help
Hello
Please i need your help on this issue.
Need to add an event to a teams calendar without sending notifications to all members
Hello Please i need your help on this issue. Need to add an event to a teams calendar without sending notifications to all members Read More
Generally Available: Transition to WS2012 / R2 ESUs enabled by Azure Arc from Volume Licensing
Customers that have enrolled in WS2012/ R2 ESUs through Volume Licensing for Year 1 can transition to Azure Arc for Year 2 of the program. Extended Security Updates afford customers with critical security patches for end of support Windows Server 2012/R2 machines. ESUs are available at no additional cost to customers running on Azure VMs or Azure Stack HCI. For customers running on-premises or other public clouds, WS2012/R2 ESUs are a paid offer.
The WS2012/R2 ESUs enabled by Azure Arc affords key advantages compared to ESUs through Volume Licensing including:
Pay as you Go flexibility to scale down WS2012 ESU consumption consumptively as customers migrate workloads to Azure and modernize affording flexibility.
Ability to apply Azure Discounting with the decrement of a Microsoft Azure Consumption Commitment (MACC) affording significant financial benefits.
Azure management capabilities including Azure Update Manager, Azure Change Tracking and Inventory, and Azure Machine Configuration are available at no additional cost.
For enrollment, customers must specify their Year 1 Volume Licensing entitlement, indicating their Invoice Id (Invoice Number) to reflect their MAK Key entitlement at the time of Azure Arc WS2012 / R2 ESU license provisioning. This is available directly in the Azure portal with the current experience for Create an Extended Security Updates license. Programmatically, customers can use Azure CLI to generate new licenses, specifying the new Volume License Details parameter in az connectedmachine license | Microsoft Learn their Year 1 Volume Licensing entitlements by entering their respective Invoice Numbers. Customers must explicitly specify the Invoice Id (Number) in their license provisioning for Azure Arc.
Customers that make this indication in their license creation will not be back billed for Year 1 of Extended Security Updates, with billing to commence from the start of Year 2 of Windows Server 2012/R2 Extended Security Updates. Customers do not need to deactivate existing MAK Keys or unenroll from ESUs through Volume Licensing to enroll in WS2012/R2 ESUs enabled by Azure Arc. See enrollment steps at Deliver Extended Security Updates for Windows Server 2012 – Azure Arc | Microsoft Learn. After reviewing Azure Arc and licensing terms, connect your servers to Azure Arc, provision new WS2012/R2 ESU licenses in Azure portal specifying Volume Licensing entitlements, and link your servers to these licenses for enrollment. With just three months until the end of Year 1, the time is now to transition to WS2012/R2 Extended Security Updates enabled by Azure Arc.
Microsoft Tech Community – Latest Blogs –Read More
while writing script for automatic Model advisor check for a model , getting this error
Post Content Post Content automate model advisor, model advisor MATLAB Answers — New Questions
I need to create a polygon or buffer along an irregular shaped coastline in a 2D array of gridded sea temperature data.
I have a 578×235 grid of ocean temperature data in which the land pixels are NaN. I would like to create a 1 pixel buffer around the coastline so that all pixels adjacent to an existing NaN also become NaN. I’m unsure on the best way to do this. I thought I could create a logical array of NaNs and not NaNs but am not sure on the best way to extract a polygon and create the buffer after that step.I have a 578×235 grid of ocean temperature data in which the land pixels are NaN. I would like to create a 1 pixel buffer around the coastline so that all pixels adjacent to an existing NaN also become NaN. I’m unsure on the best way to do this. I thought I could create a logical array of NaNs and not NaNs but am not sure on the best way to extract a polygon and create the buffer after that step. I have a 578×235 grid of ocean temperature data in which the land pixels are NaN. I would like to create a 1 pixel buffer around the coastline so that all pixels adjacent to an existing NaN also become NaN. I’m unsure on the best way to do this. I thought I could create a logical array of NaNs and not NaNs but am not sure on the best way to extract a polygon and create the buffer after that step. extract polygon, buffer MATLAB Answers — New Questions
Training Data type error for a CNN using trainnet function
Trying to use a convolution1dLayer for my sequence input data put when I try to train it i get the error:
"Error using trainnet
Invalid targets. Network expects numeric or categorical targets, but received a cell array."
I’ve looked at many exemples of how the data must be structed but even if is in the same format, it doesn’t work.
For the predictors I’m doing a test with only 4 observations, each one with 4 features and 36191 points:
For the targets there are also for observations with only one target each and also 36191 points:
I can’t understand why it doesn’t accept it, like I said, its equal to many other exemples. I leave down here the code for the CNN-LSTM network and the trainnet function:
lgraph = layerGraph();
tempLayers = [
sequenceInputLayer(4,"Name","input")
convolution1dLayer(4,32,"Name","conv1d","Padding","same")
globalAveragePooling1dLayer("Name","gapool1d")];
lgraph = addLayers(lgraph,tempLayers);
tempLayers = lstmLayer(25,"Name","lstm");
lgraph = addLayers(lgraph,tempLayers);
tempLayers = lstmLayer(25,"Name","lstm_1");
lgraph = addLayers(lgraph,tempLayers);
tempLayers = [
concatenationLayer(1,2,"Name","concat")
lstmLayer(55,"Name","lstm_2")
dropoutLayer(0.5,"Name","drop")
fullyConnectedLayer(1,"Name","fc")
sigmoidLayer("Name","sigmoid")];
lgraph = addLayers(lgraph,tempLayers);
% clean up helper variable
clear tempLayers;
lgraph = connectLayers(lgraph,"gapool1d","lstm");
lgraph = connectLayers(lgraph,"gapool1d","lstm_1");
lgraph = connectLayers(lgraph,"lstm","concat/in1");
lgraph = connectLayers(lgraph,"lstm_1","concat/in2");
plot(lgraph);
epochs = 800;
miniBatchSize = 128;
LRDropPeriod = 200;
InitialLR = 0.01;
LRDropFactor = 0.1;
valFrequency = 30;
options = trainingOptions("adam", …
MaxEpochs=epochs, …
SequencePaddingDirection="left", …
Shuffle="every-epoch", …
GradientThreshold=1, …
InitialLearnRate=InitialLR, …
LearnRateSchedule="piecewise", …
LearnRateDropPeriod=LRDropPeriod, …
LearnRateDropFactor=LRDropFactor, …
MiniBatchSize=miniBatchSize, …
Plots="training-progress", …
Metrics="rmse", …
Verbose=0, …
ExecutionEnvironment="parallel");
CNN_LTSM = trainnet(trainDataX, trainDataY, dlnetwork(lgraph),"mse",options);
using version 2023bTrying to use a convolution1dLayer for my sequence input data put when I try to train it i get the error:
"Error using trainnet
Invalid targets. Network expects numeric or categorical targets, but received a cell array."
I’ve looked at many exemples of how the data must be structed but even if is in the same format, it doesn’t work.
For the predictors I’m doing a test with only 4 observations, each one with 4 features and 36191 points:
For the targets there are also for observations with only one target each and also 36191 points:
I can’t understand why it doesn’t accept it, like I said, its equal to many other exemples. I leave down here the code for the CNN-LSTM network and the trainnet function:
lgraph = layerGraph();
tempLayers = [
sequenceInputLayer(4,"Name","input")
convolution1dLayer(4,32,"Name","conv1d","Padding","same")
globalAveragePooling1dLayer("Name","gapool1d")];
lgraph = addLayers(lgraph,tempLayers);
tempLayers = lstmLayer(25,"Name","lstm");
lgraph = addLayers(lgraph,tempLayers);
tempLayers = lstmLayer(25,"Name","lstm_1");
lgraph = addLayers(lgraph,tempLayers);
tempLayers = [
concatenationLayer(1,2,"Name","concat")
lstmLayer(55,"Name","lstm_2")
dropoutLayer(0.5,"Name","drop")
fullyConnectedLayer(1,"Name","fc")
sigmoidLayer("Name","sigmoid")];
lgraph = addLayers(lgraph,tempLayers);
% clean up helper variable
clear tempLayers;
lgraph = connectLayers(lgraph,"gapool1d","lstm");
lgraph = connectLayers(lgraph,"gapool1d","lstm_1");
lgraph = connectLayers(lgraph,"lstm","concat/in1");
lgraph = connectLayers(lgraph,"lstm_1","concat/in2");
plot(lgraph);
epochs = 800;
miniBatchSize = 128;
LRDropPeriod = 200;
InitialLR = 0.01;
LRDropFactor = 0.1;
valFrequency = 30;
options = trainingOptions("adam", …
MaxEpochs=epochs, …
SequencePaddingDirection="left", …
Shuffle="every-epoch", …
GradientThreshold=1, …
InitialLearnRate=InitialLR, …
LearnRateSchedule="piecewise", …
LearnRateDropPeriod=LRDropPeriod, …
LearnRateDropFactor=LRDropFactor, …
MiniBatchSize=miniBatchSize, …
Plots="training-progress", …
Metrics="rmse", …
Verbose=0, …
ExecutionEnvironment="parallel");
CNN_LTSM = trainnet(trainDataX, trainDataY, dlnetwork(lgraph),"mse",options);
using version 2023b Trying to use a convolution1dLayer for my sequence input data put when I try to train it i get the error:
"Error using trainnet
Invalid targets. Network expects numeric or categorical targets, but received a cell array."
I’ve looked at many exemples of how the data must be structed but even if is in the same format, it doesn’t work.
For the predictors I’m doing a test with only 4 observations, each one with 4 features and 36191 points:
For the targets there are also for observations with only one target each and also 36191 points:
I can’t understand why it doesn’t accept it, like I said, its equal to many other exemples. I leave down here the code for the CNN-LSTM network and the trainnet function:
lgraph = layerGraph();
tempLayers = [
sequenceInputLayer(4,"Name","input")
convolution1dLayer(4,32,"Name","conv1d","Padding","same")
globalAveragePooling1dLayer("Name","gapool1d")];
lgraph = addLayers(lgraph,tempLayers);
tempLayers = lstmLayer(25,"Name","lstm");
lgraph = addLayers(lgraph,tempLayers);
tempLayers = lstmLayer(25,"Name","lstm_1");
lgraph = addLayers(lgraph,tempLayers);
tempLayers = [
concatenationLayer(1,2,"Name","concat")
lstmLayer(55,"Name","lstm_2")
dropoutLayer(0.5,"Name","drop")
fullyConnectedLayer(1,"Name","fc")
sigmoidLayer("Name","sigmoid")];
lgraph = addLayers(lgraph,tempLayers);
% clean up helper variable
clear tempLayers;
lgraph = connectLayers(lgraph,"gapool1d","lstm");
lgraph = connectLayers(lgraph,"gapool1d","lstm_1");
lgraph = connectLayers(lgraph,"lstm","concat/in1");
lgraph = connectLayers(lgraph,"lstm_1","concat/in2");
plot(lgraph);
epochs = 800;
miniBatchSize = 128;
LRDropPeriod = 200;
InitialLR = 0.01;
LRDropFactor = 0.1;
valFrequency = 30;
options = trainingOptions("adam", …
MaxEpochs=epochs, …
SequencePaddingDirection="left", …
Shuffle="every-epoch", …
GradientThreshold=1, …
InitialLearnRate=InitialLR, …
LearnRateSchedule="piecewise", …
LearnRateDropPeriod=LRDropPeriod, …
LearnRateDropFactor=LRDropFactor, …
MiniBatchSize=miniBatchSize, …
Plots="training-progress", …
Metrics="rmse", …
Verbose=0, …
ExecutionEnvironment="parallel");
CNN_LTSM = trainnet(trainDataX, trainDataY, dlnetwork(lgraph),"mse",options);
using version 2023b deep learning, cnn, data, neural network, machine learning MATLAB Answers — New Questions
Default Authentication Policy – does not apply to mailboxes where AuthenticationPolicy = $null
I need to verify this in another tenant, but I’ve always assumed as per the docs that if an authentication policy is not set on a mailbox, that it assumes the policy that is set as the default org policy. However, I’ve just had a user being password sprayed from the usual countries via SMTP, evidenced in the sign-in logs (lots of ‘failed’ entries). The users auth policy was null. I then set the auth policy to the ‘default’ (which was already set as the default in the org settings) and this appears to have stopped the SMTP sign-in attempts. Can anyone verify this? Has there been a change to the behaviour? Any insights appreciated.
I need to verify this in another tenant, but I’ve always assumed as per the docs that if an authentication policy is not set on a mailbox, that it assumes the policy that is set as the default org policy. However, I’ve just had a user being password sprayed from the usual countries via SMTP, evidenced in the sign-in logs (lots of ‘failed’ entries). The users auth policy was null. I then set the auth policy to the ‘default’ (which was already set as the default in the org settings) and this appears to have stopped the SMTP sign-in attempts. Can anyone verify this? Has there been a change to the behaviour? Any insights appreciated. Read More
Multiparty private offers now available in the UK and Canada
Multiparty private offers, which allows partners to co-sell through the marketplace framework, are now available in the United Kingdom and Canada, in addition to the United States.
The cloud marketplace opportunity is projected to reach $45 billion by next year, with a third of this revenue driven by channel partners. Microsoft’s ecosystem includes over 500,000 partners, and Microsoft is focused on enhancing collaborative selling. Multiparty private offers enable channel partners to procure solutions on behalf of customers, streamlining the sales process and counting the entire purchase towards a customer’s Azure consumption commitment. This approach not only maximizes customer investments but also encourages larger transactions, with sales involving multiparty private offers averaging double the size of standard private offers.
The process of creating and executing multiparty private offers involves collaboration between ISV and channel partners to identify the right solution and negotiate terms. The ISV extends a private offer to the channel partner, who then adds their details to create a multiparty private offer. The channel partner presents the offer to the customer, who accepts and purchases it as they would a private offer from an ISV. For Azure consumption commitment customers, eligible purchases contribute towards their commitment. Microsoft handles the payment collection and ensures partners are compensated.
Channel partners can resell an ISV’s solution—provided they operate within a qualified geographic region. Currently, multiparty private offers are available to customers in the United States, Canada, and the United Kingdom. There are plans to extend the availability to more regions—starting with Western Europe and Japan in the near future.
To learn more about the expansion of multiparty private offers, check out this blog: Activating the ecosystem: marketplace multiparty private offers expand to new regions
Have you already sold or are planning to sell through multiparty private offers? Comment below to share your feedback!
Multiparty private offers, which allows partners to co-sell through the marketplace framework, are now available in the United Kingdom and Canada, in addition to the United States.
The cloud marketplace opportunity is projected to reach $45 billion by next year, with a third of this revenue driven by channel partners. Microsoft’s ecosystem includes over 500,000 partners, and Microsoft is focused on enhancing collaborative selling. Multiparty private offers enable channel partners to procure solutions on behalf of customers, streamlining the sales process and counting the entire purchase towards a customer’s Azure consumption commitment. This approach not only maximizes customer investments but also encourages larger transactions, with sales involving multiparty private offers averaging double the size of standard private offers.
The process of creating and executing multiparty private offers involves collaboration between ISV and channel partners to identify the right solution and negotiate terms. The ISV extends a private offer to the channel partner, who then adds their details to create a multiparty private offer. The channel partner presents the offer to the customer, who accepts and purchases it as they would a private offer from an ISV. For Azure consumption commitment customers, eligible purchases contribute towards their commitment. Microsoft handles the payment collection and ensures partners are compensated.
Channel partners can resell an ISV’s solution—provided they operate within a qualified geographic region. Currently, multiparty private offers are available to customers in the United States, Canada, and the United Kingdom. There are plans to extend the availability to more regions—starting with Western Europe and Japan in the near future.
To learn more about the expansion of multiparty private offers, check out this blog: Activating the ecosystem: marketplace multiparty private offers expand to new regions
Have you already sold or are planning to sell through multiparty private offers? Comment below to share your feedback!
Read More
Using functions to calculate hours in an Excel schedule
Hello, I’m going to try to explain what I’m looking for, so please be patient as I’m not particularly well versed in function commands for Excel. I am attempting to optimize a work schedule template that we use Excel for so that it calculates the hours an employee works in a given week. In the mock up below, I want to be able to calculate the total hours an employee works (let’s say John, for example) in a week, despite them working a variety of days/hours (New York, Boston, etc.). I’m trying to get Excel to search for all instances of John’s name in the chart from D4 to H21 and calculate the value of each cell that his name appears in. So in this example, John works an 8 hour New York run, an 8 hour Boston run, a 6 hour LA run, a 6 hour New Orleans run and a 5 hour Philadelphia run. I want to try to get the red box next to his name to display the total 33 hours that he worked for the week. I believe the SUMIF function will help me accomplish this, but so far when I attempt this with a function template I found on another forum (=SUMIF(D4:H21,”John”,C4:C21), I get only the Mondays work for some people and 0’s for others. I’m not entirely sure what the issue is here, or if I’m just asking too much of Excel. Hopefully I’ve explained this coherently and any input here would be very helpful. Thank you.
Hello, I’m going to try to explain what I’m looking for, so please be patient as I’m not particularly well versed in function commands for Excel. I am attempting to optimize a work schedule template that we use Excel for so that it calculates the hours an employee works in a given week. In the mock up below, I want to be able to calculate the total hours an employee works (let’s say John, for example) in a week, despite them working a variety of days/hours (New York, Boston, etc.). I’m trying to get Excel to search for all instances of John’s name in the chart from D4 to H21 and calculate the value of each cell that his name appears in. So in this example, John works an 8 hour New York run, an 8 hour Boston run, a 6 hour LA run, a 6 hour New Orleans run and a 5 hour Philadelphia run. I want to try to get the red box next to his name to display the total 33 hours that he worked for the week. I believe the SUMIF function will help me accomplish this, but so far when I attempt this with a function template I found on another forum (=SUMIF(D4:H21,”John”,C4:C21), I get only the Mondays work for some people and 0’s for others. I’m not entirely sure what the issue is here, or if I’m just asking too much of Excel. Hopefully I’ve explained this coherently and any input here would be very helpful. Thank you. Read More
Simulating Multiple Reviewers to Collate Changes in a Document
I have a very long document in which I’m tracking multiple discrete batches of changes, and I’d like to be able to effectively turn one or more batches on or off by assigning a “reviewer” to each batch of changes and then using “Show Markup -> Specific People” to select which I want to see.
My problem is I can’t figure out how to simulate different users when making batches of changes from the same account. Any ideas?
I have a very long document in which I’m tracking multiple discrete batches of changes, and I’d like to be able to effectively turn one or more batches on or off by assigning a “reviewer” to each batch of changes and then using “Show Markup -> Specific People” to select which I want to see. My problem is I can’t figure out how to simulate different users when making batches of changes from the same account. Any ideas? Read More
Filter working and then only partially working
I have been using filters on my spreadsheet and they were working fine and then all of a sudden it would only partially work – for example, I have a row that I have drop down options: Ok, To Query, Queried, Resolved. If I filtered the row to find only OK, when it is partially working, it would include all the ‘OK’s, but then some Queried, etc.
I couldn’t figure out why this was happening so I made a new spreadsheet and copied everything over. Again, it was working all fine for a while, and then all of a sudden it stopped filtering properly again.
I am not sure what is happening.
I have attached a screenshot of the specific row in my spreadsheet – it is filtered on OK
I have been using filters on my spreadsheet and they were working fine and then all of a sudden it would only partially work – for example, I have a row that I have drop down options: Ok, To Query, Queried, Resolved. If I filtered the row to find only OK, when it is partially working, it would include all the ‘OK’s, but then some Queried, etc. I couldn’t figure out why this was happening so I made a new spreadsheet and copied everything over. Again, it was working all fine for a while, and then all of a sudden it stopped filtering properly again. I am not sure what is happening. I have attached a screenshot of the specific row in my spreadsheet – it is filtered on OK Read More
Using Query Store to Capture PostgreSQL Performance in Azure Database | Data Exposed: MVP Edition
Capturing query metrics in PostgreSQL can be a challenge. Add in running that PostgreSQL database on Azure and things get even more challenging. However, Microsoft has a great addition to PostgreSQL when running in Azure Database, Query Store. This session will show the great query information available within the Query Store and how to query it.
Resources:
Query Store – Azure Database for PostgreSQL – Flexible Server
Using Azure Query Store to Understand PostgreSQL Performance
Query Store best practices – Azure Database for PostgreSQL – Flexible Server
About Grant Fritchey:
Grant Fritchey works for Red Gate Software as a Product Advocate. Grant has more than 30 years of experience in the industry as a DBA and developer. Grant has written many books including “SQL Server 2022 Query Performance Tuning”. Grant teaches classes on data management and databases to the smallest user groups and largest events, all around the world.
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the “bleeding edge” and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others – that’s what sets them apart. Learn more.
View/share our latest episodes on Microsoft Learn and YouTube!
Microsoft Tech Community – Latest Blogs –Read More
Try out the new Copilot in Planner (preview) today in the new Microsoft Planner in Teams
We are excited to share that Copilot in Planner (preview) is now rolled out to 100% of users with a Project Plan 3 or Project Plan 5 license* in Microsoft Planner in Teams. With the power of generative AI, Copilot in Planner streamlines the planning, management, and execution of your work, keeping you informed as you achieve your goals.
Over the last few weeks as we started rolling out Copilot in Planner we’ve received tremendous feedback from early users. Thank you! We value your feedback and have been incorporating it into product improvements. Recent updates include:
• The ability to return to previous chats and improved reliability in answering questions about progress, due dates, and assignments
• Enhancements in adding subtasks and linking tasks to buckets and goals
• New suggested prompts to highlight question and answer capabilities
In the coming weeks, users can expect the ability to build a plan – including goals, buckets, and a work breakdown – with a single prompt.
Explore Copilot in Planner (preview) for planning, managing, and tracking projects:
• Planning: Copilot assists teams in setting goals, breaking down work, and generating tasks, goals, and buckets based on user prompts, facilitating the creation of a comprehensive project plan.
• Effective Execution: Copilot helps streamline processes, identify next steps, and break down large tasks. It manages collaboration, tracks new goals, and identifies workload issues among team members.
• Tracking Progress: Copilot aids in tracking complex plans by quickly surfacing necessary information about progress, priorities, and workload, ensuring teams stay informed and on track.
Get started
If you already have a Project Plan 3 or Project Plan 5 license, you can preview Copilot in Planner capabilities*.
If you do not have a Project license, you can request a free 30-day trial. Simply click on the diamond icon within the Planner app in Teams where you can begin your free 30-day trial of advanced capabilities of Planner including Copilot in Planner or proceed with requesting a premium license.
Share your feedback
You can share feedback through the new Planner app in Teams directly. You can also send us your feedback via the Planner Feedback Portal.
Here is how you can share your feedback directly from within the new Planner app.
Resources
• Explore the new Day in the Life guides to use Planner and Copilot for individual task management, collaborative work management and project management.
• Watch the new Planner demos for inspiration on how to get the most out of the new Planner app in Microsoft Teams.
• Bookmark the new Planner adoption website
• We’ve got a lot more ‘planned’ for the new Planner this year! Stay tuned to the Planner Blog – Microsoft Community Hub for news.
• For Planner feature updates, visit the Microsoft 365 roadmap here
• Learn about Planner and Project plans and pricing here
• Read the FAQs here
Requirements
In general, Copilot supports the following languages for prompts: Chinese (Simplified), English, French, German, Italian, Japanese, Portuguese (Brazil), Spanish. We plan on to add more languages to Copilot and will update as additional languages are supported.
* While final pricing for Copilot in Planner has not been announced, users with a Project Plan 3 or Project Plan 5 license can preview Copilot in Planner capabilities.
Microsoft Tech Community – Latest Blogs –Read More
How to plot cross quantile correltaion heatmap
How do I plot similar cross quantile correlation plotHow do I plot similar cross quantile correlation plot How do I plot similar cross quantile correlation plot heatmap, quantile, correlat MATLAB Answers — New Questions