Month: September 2024
Formula for comparing multiple columns
Good afternoonÂ
Â
I’m struggling to get formulas to work for me when comparing two data sets. There are four columns to compare and wanting to find if there is a matching “set” in another range of data
Â
So I’ve been trying to do as a two step process where it checks whether the information in Data Set 1 is in Data set 2 unless concat to create unique strings, however what I also require is it then to state if there is no match, is there a match on say 3/4 items and then what is wrong if so.Â
Â
Understand this might not be possible but wanted to see if anyone else had any suggestions
​Good afternoon  I’m struggling to get formulas to work for me when comparing two data sets. There are four columns to compare and wanting to find if there is a matching “set” in another range of data So I’ve been trying to do as a two step process where it checks whether the information in Data Set 1 is in Data set 2 unless concat to create unique strings, however what I also require is it then to state if there is no match, is there a match on say 3/4 items and then what is wrong if so.  Understand this might not be possible but wanted to see if anyone else had any suggestions  Read More
​
Exchanhe MAPI trouble
Good afternoon!
The Exchange 2016 server freezes periodically and stops working for several minutes for all users. In the Windows log events, there is a “Warning” with event code 2002 “The number of outstanding requests for guard TargetBackend has exceeded the max limit 150.Current request will be rejected”, which occurred when Exchange hung. Please help me understand who is the source of the warning.
​Good afternoon!The Exchange 2016 server freezes periodically and stops working for several minutes for all users. In the Windows log events, there is a “Warning” with event code 2002 “The number of outstanding requests for guard TargetBackend has exceeded the max limit 150.Current request will be rejected”, which occurred when Exchange hung. Please help me understand who is the source of the warning.  Read More
​
Extending by a function output
datatable(ids: dynamic)
[
dynamic([“value1”, “value2”])
]
| function(ids)
This above snippet works fine and returns a table
datatable(date: datetime, ids: dynamic)
[
datetime(2022-01-01), dynamic([“value1”, “value2”]),
datetime(2022-01-02), dynamic([“value3”, “value4”])
]
| extend outputs = function(ids)
This one however complains that extend expects a scalar and not table that the function returns
datatable(date: datetime, ids: dynamic)
[
datetime(2022-01-01), dynamic([“value1”, “value2”]),
datetime(2022-01-02), dynamic([“value3”, “value4”])
]
| extend outputs = toscalar(function(ids))
When using toscalar, ids cannot be referenced. Is there a workaround?
​datatable(ids: dynamic)
[
dynamic([“value1”, “value2”])
]
| function(ids)This above snippet works fine and returns a tabledatatable(date: datetime, ids: dynamic)
[
datetime(2022-01-01), dynamic([“value1”, “value2”]),
datetime(2022-01-02), dynamic([“value3”, “value4”])
]
| extend outputs = function(ids)This one however complains that extend expects a scalar and not table that the function returnsdatatable(date: datetime, ids: dynamic)
[
datetime(2022-01-01), dynamic([“value1”, “value2”]),
datetime(2022-01-02), dynamic([“value3”, “value4”])
]
| extend outputs = toscalar(function(ids))When using toscalar, ids cannot be referenced. Is there a workaround?  Read More
​
Pivot Table Dr. & Cr. column values are Misaligned
I have created a Journal entries sheet in Excel which have one month sample transactions entered in it now I am trying to create Ledger from that sheet using Pivot table but problem occurs that the Dr. and Cr. amounts of entries are not lying in their corresponding cells. I mean that Dr. and Cr. amounts of a transaction are misaligned according to date entry. Can you help?
​I have created a Journal entries sheet in Excel which have one month sample transactions entered in it now I am trying to create Ledger from that sheet using Pivot table but problem occurs that the Dr. and Cr. amounts of entries are not lying in their corresponding cells. I mean that Dr. and Cr. amounts of a transaction are misaligned according to date entry. Can you help?  Read More
​
Conversation Clean Up | Issues
Hi,
I usually copy and paste the body text of a message and send it to different recipients.
Although the text is similar, they are completely different conversations but Conversation Clean Up F&S deletes all the messages except for the last one.
I don’t see any settings in File/Mail/Conversation Clean Up that can be of help.
How can I prevent the Clean Up option of deleting equal body messages but with different recipients?
Thanks/Brgds
joao
​Hi,I usually copy and paste the body text of a message and send it to different recipients.Although the text is similar, they are completely different conversations but Conversation Clean Up F&S deletes all the messages except for the last one.I don’t see any settings in File/Mail/Conversation Clean Up that can be of help.How can I prevent the Clean Up option of deleting equal body messages but with different recipients?Thanks/Brgdsjoao  Read More
​
VLOOKUP perhaps
Hi. I have 2 big tables.Â
In 1 18251 lines like this
Â
In other I want to get like this
Â
How to do it?
Please)
​Hi. I have 2 big tables. In 1 18251 lines like this In other I want to get like this How to do it?Please)  Read More
​
How to use two releases of MATLAB (R2017a and R2022b) simultaneously on my laptop?
I had one relaese of MATLAB R2022b installed on my system but it is missing the optimtool. Then I treid to install R2017a, it is not working. Instrad it gives me the license error. Further when I uninstall the 2nd one, then the system gives me the message " Deactivate the license. If you deactivate the license, all releases will not work on this system". How to solve this issue?I had one relaese of MATLAB R2022b installed on my system but it is missing the optimtool. Then I treid to install R2017a, it is not working. Instrad it gives me the license error. Further when I uninstall the 2nd one, then the system gives me the message " Deactivate the license. If you deactivate the license, all releases will not work on this system". How to solve this issue? I had one relaese of MATLAB R2022b installed on my system but it is missing the optimtool. Then I treid to install R2017a, it is not working. Instrad it gives me the license error. Further when I uninstall the 2nd one, then the system gives me the message " Deactivate the license. If you deactivate the license, all releases will not work on this system". How to solve this issue? matlab r2022b, matlab r2017a, two releases of matlab MATLAB Answers — New Questions
​
how to find LPC feature from speech to recognize human emotions in matlab? Please, can anyone help?
Can anyone provide LPC feature extraction matlab algorithm or code for speech emotion recognition?Can anyone provide LPC feature extraction matlab algorithm or code for speech emotion recognition? Can anyone provide LPC feature extraction matlab algorithm or code for speech emotion recognition? lpc feature MATLAB Answers — New Questions
​
Filename truncated in MATLAB
I am using a command:
[TestDefinitionFiles,testDefinitionFolder] = uigetfile(‘*.xlsx’,’Select one or more test definitions that you to execute’,’MultiSelect’,’on’);
When I load the excel file (Disabled_to_MoveMotor), I see it in TestDefinitionFiles as
Why is the name truncated or is anything wrong from the user’s side?
Thanks.I am using a command:
[TestDefinitionFiles,testDefinitionFolder] = uigetfile(‘*.xlsx’,’Select one or more test definitions that you to execute’,’MultiSelect’,’on’);
When I load the excel file (Disabled_to_MoveMotor), I see it in TestDefinitionFiles as
Why is the name truncated or is anything wrong from the user’s side?
Thanks. I am using a command:
[TestDefinitionFiles,testDefinitionFolder] = uigetfile(‘*.xlsx’,’Select one or more test definitions that you to execute’,’MultiSelect’,’on’);
When I load the excel file (Disabled_to_MoveMotor), I see it in TestDefinitionFiles as
Why is the name truncated or is anything wrong from the user’s side?
Thanks. excel, matlab MATLAB Answers — New Questions
​
PowerGUI and Rapid Accelerator: A new block names […] cannot be added
I built an electrical simulation in Simulink using Simscape Specialized Technology with fixed-step simulations. The powergui block is in the main system. When I want to run the simulation in Rapid Accelerator mode, it compiles successfully with MSVC++. At the stage "Connect to Rapid Accelerator Process and Simulate" it outputs:
A new block named ‘MainSimulation/powergui/EquivalentModel19’ cannot be added
How can I get past that and/or further understand the problem?
(The ultimate goal is to deploy this as a Desktop app, so Rapid Accelerator mode is required)I built an electrical simulation in Simulink using Simscape Specialized Technology with fixed-step simulations. The powergui block is in the main system. When I want to run the simulation in Rapid Accelerator mode, it compiles successfully with MSVC++. At the stage "Connect to Rapid Accelerator Process and Simulate" it outputs:
A new block named ‘MainSimulation/powergui/EquivalentModel19’ cannot be added
How can I get past that and/or further understand the problem?
(The ultimate goal is to deploy this as a Desktop app, so Rapid Accelerator mode is required)Â I built an electrical simulation in Simulink using Simscape Specialized Technology with fixed-step simulations. The powergui block is in the main system. When I want to run the simulation in Rapid Accelerator mode, it compiles successfully with MSVC++. At the stage "Connect to Rapid Accelerator Process and Simulate" it outputs:
A new block named ‘MainSimulation/powergui/EquivalentModel19’ cannot be added
How can I get past that and/or further understand the problem?
(The ultimate goal is to deploy this as a Desktop app, so Rapid Accelerator mode is required) powergui, rapid accelerator MATLAB Answers — New Questions
​
Share OSU OSA benefits bewtween partners
Hello,Â
My company is serving a global customer. This customer has separated projects lead be other partners but on the same product Dynamics Finance.
How is it possible to claim for OSU OSA within our project only ?
Thank you.
Â
Pierre-OlivierÂ
​Hello, My company is serving a global customer. This customer has separated projects lead be other partners but on the same product Dynamics Finance.How is it possible to claim for OSU OSA within our project only ?Thank you. Pierre-Olivier   Read More
​
Consecutive task
Hi,
I have a task that I want to be performed consecutively, so if there’s a holiday in the middle, the software will postpone the beginning of the task to the next day when it can be performed continuously.
How do I do this?Â
​Hi,I have a task that I want to be performed consecutively, so if there’s a holiday in the middle, the software will postpone the beginning of the task to the next day when it can be performed continuously.How do I do this?   Read More
​
Microsoft Bookings: Allow double bookings of a staff member
Hello community,
Â
I hope someone can help me here, as I was unable to find any answers to this and documentation to Microsoft Bookings feels somewhat barebones.
Â
What I want to achieve:
I want to have a bookings page, where customers can book appointments with one single staff member and I want to have up to three appointments to happen at the same time, all with the same one staff member.
Â
I don’t want to use 1:N or group appointments, because the lack some basic functionality, e.g. they act as a single appointment with three slots and not as three distinct appointments. Because of this, the staff member only gets a single E-Mail for the first booking, but not for the others, that are booked later at the same time slot.
Â
Using dummy users is not a solution for me, as I want all of the bookings to be in the same Outlook calender of the one staff member, because we don’t really use the bookings calender (would be just another tool to log into).
Â
So is there any way to enable a limited number of simultaneous 1:1-bookings for the same staff member?
Â
Thanks!
​Hello community, I hope someone can help me here, as I was unable to find any answers to this and documentation to Microsoft Bookings feels somewhat barebones. What I want to achieve:I want to have a bookings page, where customers can book appointments with one single staff member and I want to have up to three appointments to happen at the same time, all with the same one staff member. I don’t want to use 1:N or group appointments, because the lack some basic functionality, e.g. they act as a single appointment with three slots and not as three distinct appointments. Because of this, the staff member only gets a single E-Mail for the first booking, but not for the others, that are booked later at the same time slot. Using dummy users is not a solution for me, as I want all of the bookings to be in the same Outlook calender of the one staff member, because we don’t really use the bookings calender (would be just another tool to log into). So is there any way to enable a limited number of simultaneous 1:1-bookings for the same staff member? Thanks!  Read More
​
Issues with Microsoft Lists
For the past few weeks, our users have been experiencing strange issues with the Microsoft Lists application. It’s possible that more people have encountered these problems and may have a solution. In some cases, clearing the SharePoint cookies helps, but unfortunately, not always.
When entering numbers in a number column, a 0 is automatically added, turning 100 into 1000.A choice column, where additional choices can be added during input, often no longer shows these externally input values in the filter window.When opening a list for the first time, it often fails to display, and the page needs to be refreshed before it becomes visible.
​For the past few weeks, our users have been experiencing strange issues with the Microsoft Lists application. It’s possible that more people have encountered these problems and may have a solution. In some cases, clearing the SharePoint cookies helps, but unfortunately, not always.When entering numbers in a number column, a 0 is automatically added, turning 100 into 1000.A choice column, where additional choices can be added during input, often no longer shows these externally input values in the filter window.When opening a list for the first time, it often fails to display, and the page needs to be refreshed before it becomes visible.  Read More
​
How to show a figure in the MATLAB App designer with both X and Y axis from signal in simulink real-time model?
How can we customize the x-axis of the instrumented axes in MATLAB App (with model running on Speedgoat)? I wanted to plot Speed vs Torque (signals from Simulink model) (in the axes) instead of separately plotting them with respect to time.How can we customize the x-axis of the instrumented axes in MATLAB App (with model running on Speedgoat)? I wanted to plot Speed vs Torque (signals from Simulink model) (in the axes) instead of separately plotting them with respect to time. How can we customize the x-axis of the instrumented axes in MATLAB App (with model running on Speedgoat)? I wanted to plot Speed vs Torque (signals from Simulink model) (in the axes) instead of separately plotting them with respect to time. simulink, appdesigner MATLAB Answers — New Questions
​
Memory efficient alternative for meshgrid?
I am generating a meshgrid to be able to calculate my result fast:
% x, y, z are some large vectors
[a,b,c] = meshgrid(x,y,z);
% s, t are constants, M some matrix
result = (((c*s – b*t).^2)./(a.^2 + b.^2 + c.^2)).*M;
This is actually working quite nicely. Unfortunately, for very large x,y,z, the meshgrid function is running out of memory.
How do I rewrite the meshgrid function to be memory efficient?
I had thought of three loops like this:
result = zeros(length(x), length(y), length(z));
for i = 1:lenght(x)-1
for j = y = 1:lenght(y)-1
for k = z = 1:lenght(z)-1
b = ??
c = ??
result(i,j,k) = (((c*s – b*t).^2)./(x(i)^2 + y(j)^2 + z(k).^2));
end
end
end
result = result.*M;
What are the values for b and c?
How can I turn the outer for into a parfor?I am generating a meshgrid to be able to calculate my result fast:
% x, y, z are some large vectors
[a,b,c] = meshgrid(x,y,z);
% s, t are constants, M some matrix
result = (((c*s – b*t).^2)./(a.^2 + b.^2 + c.^2)).*M;
This is actually working quite nicely. Unfortunately, for very large x,y,z, the meshgrid function is running out of memory.
How do I rewrite the meshgrid function to be memory efficient?
I had thought of three loops like this:
result = zeros(length(x), length(y), length(z));
for i = 1:lenght(x)-1
for j = y = 1:lenght(y)-1
for k = z = 1:lenght(z)-1
b = ??
c = ??
result(i,j,k) = (((c*s – b*t).^2)./(x(i)^2 + y(j)^2 + z(k).^2));
end
end
end
result = result.*M;
What are the values for b and c?
How can I turn the outer for into a parfor? I am generating a meshgrid to be able to calculate my result fast:
% x, y, z are some large vectors
[a,b,c] = meshgrid(x,y,z);
% s, t are constants, M some matrix
result = (((c*s – b*t).^2)./(a.^2 + b.^2 + c.^2)).*M;
This is actually working quite nicely. Unfortunately, for very large x,y,z, the meshgrid function is running out of memory.
How do I rewrite the meshgrid function to be memory efficient?
I had thought of three loops like this:
result = zeros(length(x), length(y), length(z));
for i = 1:lenght(x)-1
for j = y = 1:lenght(y)-1
for k = z = 1:lenght(z)-1
b = ??
c = ??
result(i,j,k) = (((c*s – b*t).^2)./(x(i)^2 + y(j)^2 + z(k).^2));
end
end
end
result = result.*M;
What are the values for b and c?
How can I turn the outer for into a parfor? meshgrid, parfor MATLAB Answers — New Questions
​
Can I input an array of derivatives to the integrator and obtain an array as output?
I am new to Simulink/Matlab. I have a 2-element array of time-derivatives as input to a Simulink integrator block and I want to get a corresponding array as output. Is this even admissible? If so, how do I specify the dimensions of the inputs and outputs to the integrator block?
I get the following error when I try to build the model.
Error in port widths or dimensions. Invalid dimension has been specified for ‘Input Port 1’ of ‘<foo>/Integrator’. I have seen some people ask similar questions
Thanks.I am new to Simulink/Matlab. I have a 2-element array of time-derivatives as input to a Simulink integrator block and I want to get a corresponding array as output. Is this even admissible? If so, how do I specify the dimensions of the inputs and outputs to the integrator block?
I get the following error when I try to build the model.
Error in port widths or dimensions. Invalid dimension has been specified for ‘Input Port 1’ of ‘<foo>/Integrator’. I have seen some people ask similar questions
Thanks. I am new to Simulink/Matlab. I have a 2-element array of time-derivatives as input to a Simulink integrator block and I want to get a corresponding array as output. Is this even admissible? If so, how do I specify the dimensions of the inputs and outputs to the integrator block?
I get the following error when I try to build the model.
Error in port widths or dimensions. Invalid dimension has been specified for ‘Input Port 1’ of ‘<foo>/Integrator’. I have seen some people ask similar questions
Thanks. array input to integrator MATLAB Answers — New Questions
​
Integral and inverse integral
Hi,
I would like to calculate the probability of failure using the convolution therom as described in this paper https://www.researchgate.net/publication/314278481_Reliability_Index_for_Non-normal_Distribution_of_Limit_State_Functions
First I wanted to write the code using examples of this paper (Please look at the attached screenshots). Unfortunately, I didn’t get the same results. I found a probabilty of failure Pf=3.82 10^-08 instead of 5.55 10^-02.
In addition, I am struggling to write the inverse function to derive the reliabilty index. I always leads to errors?
Can anyone explain the mistake?
Sigma= 1;
Mu=5;
PDF_Norm=@(x) exp(-0.5.*((x-Mu)/Sigma).^2)/(Sigma*sqrt(2*pi));
a=2;
b=1;
Gamma=@(x) x.^(a-1).*exp(-x/b)/((b^a).*gamma(a));
FUN=@(x) PDF_Norm(x).*Gamma(-x);
Pf=integral(@(x) FUN(x),-Inf,0);
sym x
Beta=finverse(F,x);Hi,
I would like to calculate the probability of failure using the convolution therom as described in this paper https://www.researchgate.net/publication/314278481_Reliability_Index_for_Non-normal_Distribution_of_Limit_State_Functions
First I wanted to write the code using examples of this paper (Please look at the attached screenshots). Unfortunately, I didn’t get the same results. I found a probabilty of failure Pf=3.82 10^-08 instead of 5.55 10^-02.
In addition, I am struggling to write the inverse function to derive the reliabilty index. I always leads to errors?
Can anyone explain the mistake?
Sigma= 1;
Mu=5;
PDF_Norm=@(x) exp(-0.5.*((x-Mu)/Sigma).^2)/(Sigma*sqrt(2*pi));
a=2;
b=1;
Gamma=@(x) x.^(a-1).*exp(-x/b)/((b^a).*gamma(a));
FUN=@(x) PDF_Norm(x).*Gamma(-x);
Pf=integral(@(x) FUN(x),-Inf,0);
sym x
Beta=finverse(F,x);Â Hi,
I would like to calculate the probability of failure using the convolution therom as described in this paper https://www.researchgate.net/publication/314278481_Reliability_Index_for_Non-normal_Distribution_of_Limit_State_Functions
First I wanted to write the code using examples of this paper (Please look at the attached screenshots). Unfortunately, I didn’t get the same results. I found a probabilty of failure Pf=3.82 10^-08 instead of 5.55 10^-02.
In addition, I am struggling to write the inverse function to derive the reliabilty index. I always leads to errors?
Can anyone explain the mistake?
Sigma= 1;
Mu=5;
PDF_Norm=@(x) exp(-0.5.*((x-Mu)/Sigma).^2)/(Sigma*sqrt(2*pi));
a=2;
b=1;
Gamma=@(x) x.^(a-1).*exp(-x/b)/((b^a).*gamma(a));
FUN=@(x) PDF_Norm(x).*Gamma(-x);
Pf=integral(@(x) FUN(x),-Inf,0);
sym x
Beta=finverse(F,x); integral, convolution MATLAB Answers — New Questions
​
Bug in saving .fig (but not .png or .pdf) from when specifiying YAxis.Exponent as -6
In my livescript (MATLAB R2023b), I programatically save some of my plots via saveas(). I’m currently saving as a .pdf, a .png, and a .fig.
When I first specify that that the plot should have a YAxis exponent of -6 (it defaults to -5), my plots look as expected in the produced/displayed MATLAB .fig, and in the saved .pdf and .png. BUT…when I open the saved .fig, it shows an exponent of 10^2147483647. Not 10^-6 as everything else does.
I’ve been able to reproduce this in a .m file as well, so it doesn’t seem to be related to the .mlx.
This is how I’m saving the plots:
set(gcf, ‘visible’, ‘on’); % have to do this bc livescripts sets off, but then the figs open as invisible later
saveas(gcf,plotFullFilename,’fig’)
saveas(gcf,plotFullFilename,’png’)
exportgraphics(gcf,allPlotsFilename,’append’,true)
This is how I set the exponent:
axA.YAxis.Exponent = -6;
axB.YAxis.Exponent = -6;
If I comment out the exponent code and let it default to a yaxis exponent to -5, then the .fig saves with an exponent of -5.
But I don’t want a y-axis exponent of -5. I want it in engineering notation, e.g. an exponent of -6. This looks like a bug to me. Any ideas?In my livescript (MATLAB R2023b), I programatically save some of my plots via saveas(). I’m currently saving as a .pdf, a .png, and a .fig.
When I first specify that that the plot should have a YAxis exponent of -6 (it defaults to -5), my plots look as expected in the produced/displayed MATLAB .fig, and in the saved .pdf and .png. BUT…when I open the saved .fig, it shows an exponent of 10^2147483647. Not 10^-6 as everything else does.
I’ve been able to reproduce this in a .m file as well, so it doesn’t seem to be related to the .mlx.
This is how I’m saving the plots:
set(gcf, ‘visible’, ‘on’); % have to do this bc livescripts sets off, but then the figs open as invisible later
saveas(gcf,plotFullFilename,’fig’)
saveas(gcf,plotFullFilename,’png’)
exportgraphics(gcf,allPlotsFilename,’append’,true)
This is how I set the exponent:
axA.YAxis.Exponent = -6;
axB.YAxis.Exponent = -6;
If I comment out the exponent code and let it default to a yaxis exponent to -5, then the .fig saves with an exponent of -5.
But I don’t want a y-axis exponent of -5. I want it in engineering notation, e.g. an exponent of -6. This looks like a bug to me. Any ideas? In my livescript (MATLAB R2023b), I programatically save some of my plots via saveas(). I’m currently saving as a .pdf, a .png, and a .fig.
When I first specify that that the plot should have a YAxis exponent of -6 (it defaults to -5), my plots look as expected in the produced/displayed MATLAB .fig, and in the saved .pdf and .png. BUT…when I open the saved .fig, it shows an exponent of 10^2147483647. Not 10^-6 as everything else does.
I’ve been able to reproduce this in a .m file as well, so it doesn’t seem to be related to the .mlx.
This is how I’m saving the plots:
set(gcf, ‘visible’, ‘on’); % have to do this bc livescripts sets off, but then the figs open as invisible later
saveas(gcf,plotFullFilename,’fig’)
saveas(gcf,plotFullFilename,’png’)
exportgraphics(gcf,allPlotsFilename,’append’,true)
This is how I set the exponent:
axA.YAxis.Exponent = -6;
axB.YAxis.Exponent = -6;
If I comment out the exponent code and let it default to a yaxis exponent to -5, then the .fig saves with an exponent of -5.
But I don’t want a y-axis exponent of -5. I want it in engineering notation, e.g. an exponent of -6. This looks like a bug to me. Any ideas? saveas, save figure, livescript, bug, exponent MATLAB Answers — New Questions
​
