Month: June 2024
cannot find matlab function wizard add-in in excel
I am not able to find the matlab function wizard excel add in on my C drive. I have followed the directions in the link below but still no luck:
http://www.mathworks.com/help/releases/R2016a/compiler/excel/executing-functions-and-creating-macros-using-the-function-wizard.html
I am stuck on this step:
6. Browse to matlabroot/toolbox/matlabxl/matlabxl/arch, and select FunctionWizard2007.xlam. Click OK
When the browse window pops up I enter C:UsersusernameAppDataRoamingMicrosoftAddInsmatlabroot/toolbox/matlabxl/matlabxl/arch but get nothing…
Can someone help?
ThanksI am not able to find the matlab function wizard excel add in on my C drive. I have followed the directions in the link below but still no luck:
http://www.mathworks.com/help/releases/R2016a/compiler/excel/executing-functions-and-creating-macros-using-the-function-wizard.html
I am stuck on this step:
6. Browse to matlabroot/toolbox/matlabxl/matlabxl/arch, and select FunctionWizard2007.xlam. Click OK
When the browse window pops up I enter C:UsersusernameAppDataRoamingMicrosoftAddInsmatlabroot/toolbox/matlabxl/matlabxl/arch but get nothing…
Can someone help?
Thanks I am not able to find the matlab function wizard excel add in on my C drive. I have followed the directions in the link below but still no luck:
http://www.mathworks.com/help/releases/R2016a/compiler/excel/executing-functions-and-creating-macros-using-the-function-wizard.html
I am stuck on this step:
6. Browse to matlabroot/toolbox/matlabxl/matlabxl/arch, and select FunctionWizard2007.xlam. Click OK
When the browse window pops up I enter C:UsersusernameAppDataRoamingMicrosoftAddInsmatlabroot/toolbox/matlabxl/matlabxl/arch but get nothing…
Can someone help?
Thanks excel, add in, add-in, function wizard MATLAB Answers — New Questions
Running 2 commands at same time
I am working on a data acquisition program. Within that program, i need the following functionality:
1- start recording data on a raspberry pi
2- send a command that triggers an output voltage from the pi, some time after starting recording (say 0.25 sec).
I spoke with a matlab engineer who was totally unfamiliar with what I wanted to do. I don’t really care about the order. If issuing a command first that tells the pi to generate a trigger signal is easier that is easy to adjust the delay time, but the actual trigger has to start after the data collection starts. I’m not really running 2 scripts just 2 commands and I’d like them to be able to run non-sequentially, or parallel.
I don’t really even know enough to ask Mathworks the right question. Any guideance would be helpful.I am working on a data acquisition program. Within that program, i need the following functionality:
1- start recording data on a raspberry pi
2- send a command that triggers an output voltage from the pi, some time after starting recording (say 0.25 sec).
I spoke with a matlab engineer who was totally unfamiliar with what I wanted to do. I don’t really care about the order. If issuing a command first that tells the pi to generate a trigger signal is easier that is easy to adjust the delay time, but the actual trigger has to start after the data collection starts. I’m not really running 2 scripts just 2 commands and I’d like them to be able to run non-sequentially, or parallel.
I don’t really even know enough to ask Mathworks the right question. Any guideance would be helpful. I am working on a data acquisition program. Within that program, i need the following functionality:
1- start recording data on a raspberry pi
2- send a command that triggers an output voltage from the pi, some time after starting recording (say 0.25 sec).
I spoke with a matlab engineer who was totally unfamiliar with what I wanted to do. I don’t really care about the order. If issuing a command first that tells the pi to generate a trigger signal is easier that is easy to adjust the delay time, but the actual trigger has to start after the data collection starts. I’m not really running 2 scripts just 2 commands and I’d like them to be able to run non-sequentially, or parallel.
I don’t really even know enough to ask Mathworks the right question. Any guideance would be helpful. 2 commands, parallel computing MATLAB Answers — New Questions
Last color on legend does not match last color on stem plot, after manually setting color in for loops.
This code generates stem plots for functions of number sequences. The last two plots require for loops to shift the sequences. The plot colors are hard coded in each loop to keep the same color. This works for the plots, but the legend shows the last two funcitons as both green when the last one should be purple. What might be causing this and is there a work-around?
x = [0,1,2,3,4,-4,-3,-2,-1,0];
y = [0,0,-1,0,1,0,-1,0,1,0,0];
longest_sequence = max(numel(x),numel(y));
figure(1)
hold on
stem(x,’LineWidth’,2.0)
stem(5*x,’LineWidth’,2.0)
stem(y,’LineWidth’,2.0)
for n = 2:9
stem(n-1,y(n+1),’LineWidth’,2.0, ‘Color’,’#77AC30′)
end
for n = 2:9
stem(n-1,-2*x(n-1)+3*y(n+2),’LineWidth’,2.0,’Color’,’#7E2F8E’)
end
hold off
title(‘Problem 1’)
xlim([0 longest_sequence+1])
xticks(0:1:11)
yticks(-20:1:20)
xlabel(‘Time’)
ylabel(‘Amplitude’)
set(gca,’FontWeight’,’bold’)
legend(‘x’,’5x’,’y’,’y(n+1)’,’-2x(n-1)+3y(n+2)’)This code generates stem plots for functions of number sequences. The last two plots require for loops to shift the sequences. The plot colors are hard coded in each loop to keep the same color. This works for the plots, but the legend shows the last two funcitons as both green when the last one should be purple. What might be causing this and is there a work-around?
x = [0,1,2,3,4,-4,-3,-2,-1,0];
y = [0,0,-1,0,1,0,-1,0,1,0,0];
longest_sequence = max(numel(x),numel(y));
figure(1)
hold on
stem(x,’LineWidth’,2.0)
stem(5*x,’LineWidth’,2.0)
stem(y,’LineWidth’,2.0)
for n = 2:9
stem(n-1,y(n+1),’LineWidth’,2.0, ‘Color’,’#77AC30′)
end
for n = 2:9
stem(n-1,-2*x(n-1)+3*y(n+2),’LineWidth’,2.0,’Color’,’#7E2F8E’)
end
hold off
title(‘Problem 1’)
xlim([0 longest_sequence+1])
xticks(0:1:11)
yticks(-20:1:20)
xlabel(‘Time’)
ylabel(‘Amplitude’)
set(gca,’FontWeight’,’bold’)
legend(‘x’,’5x’,’y’,’y(n+1)’,’-2x(n-1)+3y(n+2)’) This code generates stem plots for functions of number sequences. The last two plots require for loops to shift the sequences. The plot colors are hard coded in each loop to keep the same color. This works for the plots, but the legend shows the last two funcitons as both green when the last one should be purple. What might be causing this and is there a work-around?
x = [0,1,2,3,4,-4,-3,-2,-1,0];
y = [0,0,-1,0,1,0,-1,0,1,0,0];
longest_sequence = max(numel(x),numel(y));
figure(1)
hold on
stem(x,’LineWidth’,2.0)
stem(5*x,’LineWidth’,2.0)
stem(y,’LineWidth’,2.0)
for n = 2:9
stem(n-1,y(n+1),’LineWidth’,2.0, ‘Color’,’#77AC30′)
end
for n = 2:9
stem(n-1,-2*x(n-1)+3*y(n+2),’LineWidth’,2.0,’Color’,’#7E2F8E’)
end
hold off
title(‘Problem 1’)
xlim([0 longest_sequence+1])
xticks(0:1:11)
yticks(-20:1:20)
xlabel(‘Time’)
ylabel(‘Amplitude’)
set(gca,’FontWeight’,’bold’)
legend(‘x’,’5x’,’y’,’y(n+1)’,’-2x(n-1)+3y(n+2)’) color, legend, for loop MATLAB Answers — New Questions
Change background screen on dedicated device, kiosk mode single android app Enterprise.
Good morning, when the device is turned on, “Starting Device” appears with a default wallpaper, how can I configure this
wallpaper? I’ve been told Microsoft Launcher is for this, but I haven’t been able to apply it to the kiosk mode simgle app device.
I await a response.
Good morning, when the device is turned on, “Starting Device” appears with a default wallpaper, how can I configure thiswallpaper? I’ve been told Microsoft Launcher is for this, but I haven’t been able to apply it to the kiosk mode simgle app device.I await a response. Read More
How to call microsoft graph api inside my web app?
I have a web app embedded in MS Teams. I’m trying to figure out how to call the MS Graph API in my JS code to get user information. How can I do that?
I have a web app embedded in MS Teams. I’m trying to figure out how to call the MS Graph API in my JS code to get user information. How can I do that? Read More
Partners – let’s share ideas on Copilot! Event in Dallas and Virtually, June 27
Dallas IAMCP Chapter Meeting, “Your everyday AI companion” June 27 – Hybrid
You’re invited to join us in-person or virtually!
IAMCP (International Association of Microsoft Channel Partners) TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are!
Our June meeting will continue the conversation last month in Austin, about Copilot for Microsoft 365. Have you been using Copilot & AI? How has it impacted your business since then? How have your clients responded? Let’s dig in and share ideas!
Join us online or in-person (lunch included) in Dallas at the Microsoft office –
7000 State Highway 161
Irving, TX 75039
11:30am-1:00pm CST
Not a member of IAMCP? You can attend for $30 or, as a new member, join for $1 for your first 90 days!
I myself have been a member of IAMCP for about 2+ years and I’m the Secretary of the Houston chapter. There are plenty of other virtual meetings every month covering all topics concerning partners. It’s a great way to understand the ecosystem, how to gain designations and credentials, and find partner to partner opportunities.
Dallas IAMCP Chapter Meeting, “Your everyday AI companion” June 27 – HybridYou’re invited to join us in-person or virtually! IAMCP (International Association of Microsoft Channel Partners) TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are! Our June meeting will continue the conversation last month in Austin, about Copilot for Microsoft 365. Have you been using Copilot & AI? How has it impacted your business since then? How have your clients responded? Let’s dig in and share ideas! Join us online or in-person (lunch included) in Dallas at the Microsoft office – 7000 State Highway 161Irving, TX 7503911:30am-1:00pm CST Register Here > Not a member of IAMCP? You can attend for $30 or, as a new member, join for $1 for your first 90 days! I myself have been a member of IAMCP for about 2+ years and I’m the Secretary of the Houston chapter. There are plenty of other virtual meetings every month covering all topics concerning partners. It’s a great way to understand the ecosystem, how to gain designations and credentials, and find partner to partner opportunities. Read More
Script Google Sheet
Hi,
Can someone assist me with writing a script for the “Save” button in the Data entry tab? When I click save, I want the data to automatically populate in the Raw Data tab starting from line 18.
Thank you.
Hi, Can someone assist me with writing a script for the “Save” button in the Data entry tab? When I click save, I want the data to automatically populate in the Raw Data tab starting from line 18. https://docs.google.com/spreadsheets/d/1utdQMucH7XDKTmJHIjLITOgeQHazQXibZktqMxSAA9g/edit?usp=sharing Thank you. Read More
How do i check for empty cells within a list
How do i check for empty cells within list? I have a list of cells, namelist, and it has 12 values, i need to check if some of the cells are empty. ThanksHow do i check for empty cells within list? I have a list of cells, namelist, and it has 12 values, i need to check if some of the cells are empty. Thanks How do i check for empty cells within list? I have a list of cells, namelist, and it has 12 values, i need to check if some of the cells are empty. Thanks empty, cell MATLAB Answers — New Questions
How to find the position of a number in an array?
If I have a vector, a = [7 8 8 2 5 6], how do I compute the positions of the value 8?
I expect 2 and 3 or (1,2) and (1,3).If I have a vector, a = [7 8 8 2 5 6], how do I compute the positions of the value 8?
I expect 2 and 3 or (1,2) and (1,3). If I have a vector, a = [7 8 8 2 5 6], how do I compute the positions of the value 8?
I expect 2 and 3 or (1,2) and (1,3). array MATLAB Answers — New Questions
Taking the last value of a matrix or vector
Hi. How can I take a last term of a vector – since my vector dimensions change -, and plug it in somewhere else in my code without keep changing the code?
for example right now I do v(6) to get the 6th term. How can I do it for nth term…. ThanksHi. How can I take a last term of a vector – since my vector dimensions change -, and plug it in somewhere else in my code without keep changing the code?
for example right now I do v(6) to get the 6th term. How can I do it for nth term…. Thanks Hi. How can I take a last term of a vector – since my vector dimensions change -, and plug it in somewhere else in my code without keep changing the code?
for example right now I do v(6) to get the 6th term. How can I do it for nth term…. Thanks last term of a vector with n rows MATLAB Answers — New Questions
How to extract columns of a matrix into seperate vectors?
Hallo,
Let’s assume a matrix (100×3). I want to extract out each of the columns, and store them in 3 separate vectors.
The code for the loop is clear, but what’s the right code for storing each column?
—————————-
for i = 1 : 3
vector = matrix(:, i);
end
—————————-
I guess it’s probably simple, but I am still a beginner and couldn’t find much useful information in the documentation so far.
Thank you.
DominikHallo,
Let’s assume a matrix (100×3). I want to extract out each of the columns, and store them in 3 separate vectors.
The code for the loop is clear, but what’s the right code for storing each column?
—————————-
for i = 1 : 3
vector = matrix(:, i);
end
—————————-
I guess it’s probably simple, but I am still a beginner and couldn’t find much useful information in the documentation so far.
Thank you.
Dominik Hallo,
Let’s assume a matrix (100×3). I want to extract out each of the columns, and store them in 3 separate vectors.
The code for the loop is clear, but what’s the right code for storing each column?
—————————-
for i = 1 : 3
vector = matrix(:, i);
end
—————————-
I guess it’s probably simple, but I am still a beginner and couldn’t find much useful information in the documentation so far.
Thank you.
Dominik matrix, column, separate, bad idea MATLAB Answers — New Questions
Developing an external teams tab- do I need microsoft entra?
I’m creating an external facing teams tab which can be downloaded by anyone with a teams client. I do need to gather context about the user and gain access to calendars. From my understanding, SSO might require setup from my side and the user’s org. Is there a way for me to access user information such as email and access calendars in a tab? I don’t think I need SSO setup from my end so do I still need to set up entra and register my app there? Are there docs for this process?
I’m creating an external facing teams tab which can be downloaded by anyone with a teams client. I do need to gather context about the user and gain access to calendars. From my understanding, SSO might require setup from my side and the user’s org. Is there a way for me to access user information such as email and access calendars in a tab? I don’t think I need SSO setup from my end so do I still need to set up entra and register my app there? Are there docs for this process? Read More
Summing all previous numbers with criteria
Hi again,
Looking to sum all previous numbers based on criteria. Need output to be a horizontal spilled range.. Example below. Tried using TAKE function
Ex
2024-11-18 2024-05-12 2024-10-09 2024-11-18 2024-10-09
50 100 30 75 90
Output all summed previous numbers as a horizontal spilled range that are equal to 2024-11-18
Output:
2024-11-18 2024-05-12 2024-10-09 2024-11-18 2024-10-09
50 n/a n/a 125 n/a
If it could also display n/a or 0 as a value that would be great (e.g changeable between both). Thanks
Hi again, Looking to sum all previous numbers based on criteria. Need output to be a horizontal spilled range.. Example below. Tried using TAKE function Ex2024-11-18 2024-05-12 2024-10-09 2024-11-18 2024-10-0950 100 30 75 90 Output all summed previous numbers as a horizontal spilled range that are equal to 2024-11-18Output:2024-11-18 2024-05-12 2024-10-09 2024-11-18 2024-10-0950 n/a n/a 125 n/a If it could also display n/a or 0 as a value that would be great (e.g changeable between both). Thanks Read More
Virtual Appointment
When you schedule a meeting using virtual appointment meeting type, it only allows 8 external guests to be invited. Is there a way to add more without just forwarding them the invite after? Does it affect the meeting at all if more than 8 external participants show up?
When you schedule a meeting using virtual appointment meeting type, it only allows 8 external guests to be invited. Is there a way to add more without just forwarding them the invite after? Does it affect the meeting at all if more than 8 external participants show up? Read More
Show Last Record
Hello experts,
I need to show the last record in another column of this data set based on 2 criteria.
The criteria is I need to show the last record of [MTM] based on the MAX of [Valuation Date] but based on a grouping of [Trade Ref #].
I have attached the file with some comments of what I need.
Let me know if its not clear.
thank you very much.
Hello experts, I need to show the last record in another column of this data set based on 2 criteria.The criteria is I need to show the last record of [MTM] based on the MAX of [Valuation Date] but based on a grouping of [Trade Ref #]. I have attached the file with some comments of what I need. Let me know if its not clear. thank you very much. Read More
How to start an Azure User Group
Hey there!
May I know how can I start a Microsoft Tech Community in my region or Azure User Group?
A guide will be appreciated.
Hey there! May I know how can I start a Microsoft Tech Community in my region or Azure User Group? A guide will be appreciated. Read More
Issue with “Edit with Paint 3D” Functionality
I have recently encountered an issue with Paint 3D. When I try to edit a picture using Paint 3D by right-clicking on the photo and selecting “Edit with Paint 3D,” I am unexpectedly prompted to choose an app to open the file instead of Paint 3D launching directly.
Has anyone else experienced this problem, or does anyone have any insights on why this might be happening and how to resolve it?
Thank you for your assistance!
I have recently encountered an issue with Paint 3D. When I try to edit a picture using Paint 3D by right-clicking on the photo and selecting “Edit with Paint 3D,” I am unexpectedly prompted to choose an app to open the file instead of Paint 3D launching directly.Has anyone else experienced this problem, or does anyone have any insights on why this might be happening and how to resolve it?Thank you for your assistance! Read More
SharePoint Online – Large List | REST API Issue
Hi,
I have a list which has around 28K items. We have a dashboard displaying data from this list. By default, we are fetching data for the past 120 days, and it perfectly worked fine.
Today, we have around 13K items created on the same list by mistake. Now the dashboard is not working and it is giving this error “The attempted operation is prohibited because it exceeds the list view threshold”.
The following steps are taken as of now.
deleted 13k items from the process listdeleted from the recycle bin ( primary and secondary)
I’m still facing the same error.
Can you please let me know if anyone has come across this kind of issue & let me know any solution?
Thanks in advance.
Hi, I have a list which has around 28K items. We have a dashboard displaying data from this list. By default, we are fetching data for the past 120 days, and it perfectly worked fine. Today, we have around 13K items created on the same list by mistake. Now the dashboard is not working and it is giving this error “The attempted operation is prohibited because it exceeds the list view threshold”. The following steps are taken as of now.deleted 13k items from the process listdeleted from the recycle bin ( primary and secondary)I’m still facing the same error. Can you please let me know if anyone has come across this kind of issue & let me know any solution? Thanks in advance. Read More
Upcoming Event in Dallas & Virtual: Copilot, Your Everyday AI Companion, June 27
Dallas IAMCP Chapter Meeting, “Your everyday AI companion” June 27 – Hybrid
You’re invited to join us in-person or virtually!
IAMCP (International Association of Microsoft Channel Partners) TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are!
Our June meeting will continue the conversation last month in Austin, about Copilot for Microsoft 365. Have you been using Copilot & AI? How has it impacted your business since then? How have your clients responded? Let’s dig in and share ideas!
Join us online or in-person (lunch included) in Dallas at the Microsoft office –
7000 State Highway 161
Irving, TX 75039
11:30am-1:00pm CST
Not a member of IAMCP? You can attend for $30 or, as a new member, join for $1 for your first 90 days!
I myself have been a member of IAMCP for about 2+ years and I’m the Secretary of the Houston chapter. There are plenty of other virtual meetings every month covering all topics concerning partners. It’s a great way to understand the ecosystem, how to gain designations and credentials, and find partner to partner opportunities.
Dallas IAMCP Chapter Meeting, “Your everyday AI companion” June 27 – HybridYou’re invited to join us in-person or virtually! IAMCP (International Association of Microsoft Channel Partners) TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are! Our June meeting will continue the conversation last month in Austin, about Copilot for Microsoft 365. Have you been using Copilot & AI? How has it impacted your business since then? How have your clients responded? Let’s dig in and share ideas! Join us online or in-person (lunch included) in Dallas at the Microsoft office – 7000 State Highway 161Irving, TX 7503911:30am-1:00pm CST Register Here > Not a member of IAMCP? You can attend for $30 or, as a new member, join for $1 for your first 90 days! I myself have been a member of IAMCP for about 2+ years and I’m the Secretary of the Houston chapter. There are plenty of other virtual meetings every month covering all topics concerning partners. It’s a great way to understand the ecosystem, how to gain designations and credentials, and find partner to partner opportunities. Read More
Index Match to get Avg. price of a period
Hello All,
Hope you are doing well.
May I ask for a little help from you, actually I have daywise sales units in upper table of the attached sheet and price per unit in the second table, there is a dropdown in cell AH2 & AI2 where units sold appears in within a date range.
Pls help me to get the avg. price of that units sold of the same date range in column AJ row no 12 to 17.
Requesting you to pls help me in this, will wait for your reply.
Thanks & Regards,
Subhasis
Hello All, Hope you are doing well.May I ask for a little help from you, actually I have daywise sales units in upper table of the attached sheet and price per unit in the second table, there is a dropdown in cell AH2 & AI2 where units sold appears in within a date range.Pls help me to get the avg. price of that units sold of the same date range in column AJ row no 12 to 17.Requesting you to pls help me in this, will wait for your reply. Thanks & Regards,Subhasis Read More
