Month: May 2024
Excel slowed noticably overnight
Using Excel via Office 365, I have noticed a dramatic increase in the amount of time required to open any member of a group of files, each of which have links to other workbooks.
These are files that I open daily, and have opened daily for quite some time. Each of them have links to other workbooks, very simple in nature, simply referencing cells in the other workbooks; no calculations are performed in the reference.
The files themselves are fairly small, on the order of 2 MB. They previously opened in 2-8 seconds, I would guess. Now, they can take up to 30 minutes(!) to open.
I noticed this first on the morning of May 25th. No 365 updates are shown for the 24th or 25th; however, I did have a new message from Windows on my computer that morning letting me know that service for Windows 10 would be ending soon.
All other Excel files open totally as normal.
Anyone have ANY idea how to make this make sense?
Using Excel via Office 365, I have noticed a dramatic increase in the amount of time required to open any member of a group of files, each of which have links to other workbooks. These are files that I open daily, and have opened daily for quite some time. Each of them have links to other workbooks, very simple in nature, simply referencing cells in the other workbooks; no calculations are performed in the reference. The files themselves are fairly small, on the order of 2 MB. They previously opened in 2-8 seconds, I would guess. Now, they can take up to 30 minutes(!) to open. I noticed this first on the morning of May 25th. No 365 updates are shown for the 24th or 25th; however, I did have a new message from Windows on my computer that morning letting me know that service for Windows 10 would be ending soon. All other Excel files open totally as normal. Anyone have ANY idea how to make this make sense? Read More
Unable to ssh using pen key windows ec2 instance
I launched windows ec2 instance and download pem key , then connected through RDP , installed openssh server, started ssh service, disabled firewall, but I am not able to login through pem keys.
I launched windows ec2 instance and download pem key , then connected through RDP , installed openssh server, started ssh service, disabled firewall, but I am not able to login through pem keys. Read More
Virtual synchronous machine (simulink file)
Hi, I’m doing a research about appliying virtual synchronous machine in tidal energy.
Do anyone has a simulink model of Virtual Synchronous Machine (VSM)?
Many thanks.Hi, I’m doing a research about appliying virtual synchronous machine in tidal energy.
Do anyone has a simulink model of Virtual Synchronous Machine (VSM)?
Many thanks. Hi, I’m doing a research about appliying virtual synchronous machine in tidal energy.
Do anyone has a simulink model of Virtual Synchronous Machine (VSM)?
Many thanks. virtual synchronous generator MATLAB Answers — New Questions
How can one use a variable to set color of a line plot , and use colorbar?
Dear MAtLab community,
I am creating a simple line plot, and I would like to use a third variable to color the line at every point .
the line comes as:
line(koordmean(:,1),koordmean(:,2))
xlim([1 640])
ylim([1 480])
set(gca,’ydir’,’reverse’)
and the line should be colouread according to the variable ‘anx’. It should work similar to the imagesc function combined with the colorbar function.
Any suggestions are highly appreciated! Kind regards
lgDear MAtLab community,
I am creating a simple line plot, and I would like to use a third variable to color the line at every point .
the line comes as:
line(koordmean(:,1),koordmean(:,2))
xlim([1 640])
ylim([1 480])
set(gca,’ydir’,’reverse’)
and the line should be colouread according to the variable ‘anx’. It should work similar to the imagesc function combined with the colorbar function.
Any suggestions are highly appreciated! Kind regards
lg Dear MAtLab community,
I am creating a simple line plot, and I would like to use a third variable to color the line at every point .
the line comes as:
line(koordmean(:,1),koordmean(:,2))
xlim([1 640])
ylim([1 480])
set(gca,’ydir’,’reverse’)
and the line should be colouread according to the variable ‘anx’. It should work similar to the imagesc function combined with the colorbar function.
Any suggestions are highly appreciated! Kind regards
lg line plot, imagesc, colorbar MATLAB Answers — New Questions
Limit on email recipients
I have a large group (approx. 700) email addresses for retirees from my former workplace, and I keep them informed of retiree events and noteworthy happenings (obituaries, new retirements, etc.). I have the retiree email addresses organized into groups of 100 (the limit from my Comcast email account) and send a message out to everyone by sending to the first group, then simply forwarding that message to the remaining 6 groups. Starting last week, my emails started being throttled down to the point where I can only send out to 2 groups, then I have to wait an hour before being able to send to the next 2 groups (otherwise I get an error message of a “policy violation”). Comcast support tells me they’re not throttling me down, that it’s Outlook doing that. Has anyone else had a similar experience? How do I convince Outlook (Microsoft) that I’m not a spammer? I tried calling a help line but the automated message sends me to online support, and I’ve found no help there.
I have a large group (approx. 700) email addresses for retirees from my former workplace, and I keep them informed of retiree events and noteworthy happenings (obituaries, new retirements, etc.). I have the retiree email addresses organized into groups of 100 (the limit from my Comcast email account) and send a message out to everyone by sending to the first group, then simply forwarding that message to the remaining 6 groups. Starting last week, my emails started being throttled down to the point where I can only send out to 2 groups, then I have to wait an hour before being able to send to the next 2 groups (otherwise I get an error message of a “policy violation”). Comcast support tells me they’re not throttling me down, that it’s Outlook doing that. Has anyone else had a similar experience? How do I convince Outlook (Microsoft) that I’m not a spammer? I tried calling a help line but the automated message sends me to online support, and I’ve found no help there. Read More
Best Practices for Tracking Changes on a SharePoint List Accessed by a Service Account
Hello Microsoft Community,
I am reaching out to seek advice and best practices for monitoring and tracking changes on a SharePoint list that is accessed via a service account. In our organization, multiple individuals have access to this service account, which raises concerns about maintaining accountability and transparency regarding the modifications made to the list.
The SharePoint list in question contains various columns, including calculated columns, which are crucial for our operations. However, these calculated columns present a challenge as they do not inherently track who made changes or when these changes were made. This lack of traceability is problematic, especially when trying to audit or review historical data.
I am looking for a method or tool that can help us keep a detailed log of all activities on the list. Ideally, this solution would capture:
Timestamps of when changes are made.Identification of the specific elements that were altered (from metadata to formulas).The nature of the changes (what columns was added, removed, or modified).
We want to ensure that our SharePoint list remains a reliable and accurate source of information for all team members. Therefore, having a system that can provide a comprehensive audit trail would be extremely beneficial.
I would greatly appreciate any recommendations on features within SharePoint, Power Automate, or custom solutions that could assist us in achieving this level of oversight. Additionally, if there are any best practices for managing shared service account access to SharePoint lists, I would be eager to learn about those as well.
Thank you in advance for your time and assistance.
Hello Microsoft Community, I am reaching out to seek advice and best practices for monitoring and tracking changes on a SharePoint list that is accessed via a service account. In our organization, multiple individuals have access to this service account, which raises concerns about maintaining accountability and transparency regarding the modifications made to the list. The SharePoint list in question contains various columns, including calculated columns, which are crucial for our operations. However, these calculated columns present a challenge as they do not inherently track who made changes or when these changes were made. This lack of traceability is problematic, especially when trying to audit or review historical data. I am looking for a method or tool that can help us keep a detailed log of all activities on the list. Ideally, this solution would capture:Timestamps of when changes are made.Identification of the specific elements that were altered (from metadata to formulas).The nature of the changes (what columns was added, removed, or modified).We want to ensure that our SharePoint list remains a reliable and accurate source of information for all team members. Therefore, having a system that can provide a comprehensive audit trail would be extremely beneficial. I would greatly appreciate any recommendations on features within SharePoint, Power Automate, or custom solutions that could assist us in achieving this level of oversight. Additionally, if there are any best practices for managing shared service account access to SharePoint lists, I would be eager to learn about those as well. Thank you in advance for your time and assistance. Read More
Resource room calendar not updating meeting times: Intermittent
I’ve encountered a situation where a user creates a meeting with a resource room attached. Sometimes, when she updates the meeting times and forwards the invitation to all users, their times update accordingly, but the meeting room calendar does not.
Although she receives the accepted time email from the meeting room email, the time does not actually update on the calendar.
When testing with her account on another meeting made the exact same way it worked without issue.
Deleting and recreating the meeting worked fine but she’s mentioned this multiple times and it continues to be dismissed because upon testing it works as expected.
I’ve encountered a situation where a user creates a meeting with a resource room attached. Sometimes, when she updates the meeting times and forwards the invitation to all users, their times update accordingly, but the meeting room calendar does not. Although she receives the accepted time email from the meeting room email, the time does not actually update on the calendar.When testing with her account on another meeting made the exact same way it worked without issue.Deleting and recreating the meeting worked fine but she’s mentioned this multiple times and it continues to be dismissed because upon testing it works as expected. Read More
trying to edit entire column
how do I apply this formula to the entire column B3 to B1873?
=LEFT(B3, LEN(B3) – 10)
Also, I have a column with first and last name together, is there a way to separate these into 2 columns?
how do I apply this formula to the entire column B3 to B1873? =LEFT(B3, LEN(B3) – 10) Also, I have a column with first and last name together, is there a way to separate these into 2 columns? Read More
How can I restart the optimization in “Optimize Live Editor”?
I am new in use of MATLAB_. I want to do a nonlinear optimization with genetic algorithm in Solver-based application. My problem is that I failed, but if I start again, it still includes the things and choices I entered before. How can I start with a clean sheet?I am new in use of MATLAB_. I want to do a nonlinear optimization with genetic algorithm in Solver-based application. My problem is that I failed, but if I start again, it still includes the things and choices I entered before. How can I start with a clean sheet? I am new in use of MATLAB_. I want to do a nonlinear optimization with genetic algorithm in Solver-based application. My problem is that I failed, but if I start again, it still includes the things and choices I entered before. How can I start with a clean sheet? use optimize leve editor task MATLAB Answers — New Questions
Error using sdo.SimulationTest/sim
Hello everyone, i’m having an issue with an application, using AppDesigner, but after deployment only.
In the log file, I can find:
Error using sdo.SimulationTest/sim
Unrecognized function or variable ‘private_sl_CPUInfo’.
sim() is called in a sdo.optimize loop in a annonymous function and I don’t understand at all what could cause the issue, and the application is running fine before deployement (in the AppDesigner).
Does anybody already had this issue or knows something about it?Hello everyone, i’m having an issue with an application, using AppDesigner, but after deployment only.
In the log file, I can find:
Error using sdo.SimulationTest/sim
Unrecognized function or variable ‘private_sl_CPUInfo’.
sim() is called in a sdo.optimize loop in a annonymous function and I don’t understand at all what could cause the issue, and the application is running fine before deployement (in the AppDesigner).
Does anybody already had this issue or knows something about it? Hello everyone, i’m having an issue with an application, using AppDesigner, but after deployment only.
In the log file, I can find:
Error using sdo.SimulationTest/sim
Unrecognized function or variable ‘private_sl_CPUInfo’.
sim() is called in a sdo.optimize loop in a annonymous function and I don’t understand at all what could cause the issue, and the application is running fine before deployement (in the AppDesigner).
Does anybody already had this issue or knows something about it? appdesigner, simulink, simscape, simulation MATLAB Answers — New Questions
How to get rid of the error: Error using horzcat. Dimensions of matrices being concatenated are not consistent
Post Content Post Content horzcat MATLAB Answers — New Questions
Mathematics relationship between CDL channels and Saleh-Valenzuela model
Hi everyone,
I’m learning to generate a CDL channel through example CDL Channel Model Customization with Ray Tracing, and I also read some papers about Saleh-Valenzuela model for mmWave, and I see they have some things in common, like AoA, AoD,… But I didn’t find any Matlab source explaining the mathematics behind the functions related to nrCDLChannel() object.
I am wondering if CDL channel use the Saleh-Valenzuela model? Could you please give me some Matlab sites that explain the mathematical formulas behind that? because I saw different papers have different notations of Saleh-Valenzuela model, and it quite confusing for me as a new learner.
Thanks a lot in advance.Hi everyone,
I’m learning to generate a CDL channel through example CDL Channel Model Customization with Ray Tracing, and I also read some papers about Saleh-Valenzuela model for mmWave, and I see they have some things in common, like AoA, AoD,… But I didn’t find any Matlab source explaining the mathematics behind the functions related to nrCDLChannel() object.
I am wondering if CDL channel use the Saleh-Valenzuela model? Could you please give me some Matlab sites that explain the mathematical formulas behind that? because I saw different papers have different notations of Saleh-Valenzuela model, and it quite confusing for me as a new learner.
Thanks a lot in advance. Hi everyone,
I’m learning to generate a CDL channel through example CDL Channel Model Customization with Ray Tracing, and I also read some papers about Saleh-Valenzuela model for mmWave, and I see they have some things in common, like AoA, AoD,… But I didn’t find any Matlab source explaining the mathematics behind the functions related to nrCDLChannel() object.
I am wondering if CDL channel use the Saleh-Valenzuela model? Could you please give me some Matlab sites that explain the mathematical formulas behind that? because I saw different papers have different notations of Saleh-Valenzuela model, and it quite confusing for me as a new learner.
Thanks a lot in advance. cdl channel, saleh-valenzuela, channel model, multi-antenna MATLAB Answers — New Questions
Cant use nested bus objects with bus object arrays in simulink
Hello,
I am trying to build a Bus (struct) (<Quiver>) that has an array of a nested bus type (<Arrow>). Later, I want to dissect this array (<arrows>), loop over it and use the members (<point>, <head>) of that bus object.
However, I get the following error:
Selected signal ‘arrows.origin.x’ in the Bus Selector block ‘Demo/Inport’ is invalid since it refers to a bus element within an array of sub-buses. The path to the array of sub-buses is ‘arrows’. Please select the appropriate array element using a Selector block before using the Bus Selector block to access an element within the bus.
This is very annoying. Programatically this is totally normal, nested stucts. Why can I specify the dimension of that struct array, if it wont compile?
How can I do what I intend to do?
This is what I am doing, basically:Hello,
I am trying to build a Bus (struct) (<Quiver>) that has an array of a nested bus type (<Arrow>). Later, I want to dissect this array (<arrows>), loop over it and use the members (<point>, <head>) of that bus object.
However, I get the following error:
Selected signal ‘arrows.origin.x’ in the Bus Selector block ‘Demo/Inport’ is invalid since it refers to a bus element within an array of sub-buses. The path to the array of sub-buses is ‘arrows’. Please select the appropriate array element using a Selector block before using the Bus Selector block to access an element within the bus.
This is very annoying. Programatically this is totally normal, nested stucts. Why can I specify the dimension of that struct array, if it wont compile?
How can I do what I intend to do?
This is what I am doing, basically: Hello,
I am trying to build a Bus (struct) (<Quiver>) that has an array of a nested bus type (<Arrow>). Later, I want to dissect this array (<arrows>), loop over it and use the members (<point>, <head>) of that bus object.
However, I get the following error:
Selected signal ‘arrows.origin.x’ in the Bus Selector block ‘Demo/Inport’ is invalid since it refers to a bus element within an array of sub-buses. The path to the array of sub-buses is ‘arrows’. Please select the appropriate array element using a Selector block before using the Bus Selector block to access an element within the bus.
This is very annoying. Programatically this is totally normal, nested stucts. Why can I specify the dimension of that struct array, if it wont compile?
How can I do what I intend to do?
This is what I am doing, basically: array, bus, simulink, matlab, error MATLAB Answers — New Questions
How to enable required buttons and plot linear fit from group of graphs
I have created an where i want to enable required buttons based on the input given. I have the maxium limit of the required buttons. My app tells about the mangoes quantity in the basket and the plot are made for the estimation of the ripeness of mangoes. Where i have known about the maximum number of mangoes in basket. What i required is, 1) if i change my input, i don’t want the import excel buttons to be deleted instead those should be diabled. 2) After plotting the graphs, i want to make the linear fit and the squareroot fit to the plotted group of graphs. i have attached my app and the excel file for the plot.I have created an where i want to enable required buttons based on the input given. I have the maxium limit of the required buttons. My app tells about the mangoes quantity in the basket and the plot are made for the estimation of the ripeness of mangoes. Where i have known about the maximum number of mangoes in basket. What i required is, 1) if i change my input, i don’t want the import excel buttons to be deleted instead those should be diabled. 2) After plotting the graphs, i want to make the linear fit and the squareroot fit to the plotted group of graphs. i have attached my app and the excel file for the plot. I have created an where i want to enable required buttons based on the input given. I have the maxium limit of the required buttons. My app tells about the mangoes quantity in the basket and the plot are made for the estimation of the ripeness of mangoes. Where i have known about the maximum number of mangoes in basket. What i required is, 1) if i change my input, i don’t want the import excel buttons to be deleted instead those should be diabled. 2) After plotting the graphs, i want to make the linear fit and the squareroot fit to the plotted group of graphs. i have attached my app and the excel file for the plot. matlab, appdesigner MATLAB Answers — New Questions
Re-importing Calendar items from In-Place Archive, back into live Exchange mailbox?
I have a user whose primary Exchange Online mailbox had hit the 50GB limit, so In-Place Archiving needed to be turned on in order to make room in live mailbox.
However, the user wants to be able to have ALL the Calendar items accessible in the live mailbox. They are fine with the Archived email items remaining in the In-Place Archive. So the questions I have are:
If I set the user’s MRM policy on the Archive Mailbox to ‘No Policy’ but leave In-Place Archving active, would I be able to export the Calendar items from the In-Place Archive to a PST (via Outlook) and then re-import them into the live mailbox? If the above were possible would all the Calendar items import back into the live mailbox’s calendar in the same state they were in, in the In-Place Archive (i.e accepted, etc.)If the items reimport, will Outlook Reminders get triggered for all the re-imported items, in that the user would get a whole list of Calendar items showing up as Overdue?
I have a user whose primary Exchange Online mailbox had hit the 50GB limit, so In-Place Archiving needed to be turned on in order to make room in live mailbox.However, the user wants to be able to have ALL the Calendar items accessible in the live mailbox. They are fine with the Archived email items remaining in the In-Place Archive. So the questions I have are: If I set the user’s MRM policy on the Archive Mailbox to ‘No Policy’ but leave In-Place Archving active, would I be able to export the Calendar items from the In-Place Archive to a PST (via Outlook) and then re-import them into the live mailbox? If the above were possible would all the Calendar items import back into the live mailbox’s calendar in the same state they were in, in the In-Place Archive (i.e accepted, etc.)If the items reimport, will Outlook Reminders get triggered for all the re-imported items, in that the user would get a whole list of Calendar items showing up as Overdue? Read More
Issues setting exact sampling rates when using the data acquisition toolbox in MATLAB’s app designer
Hi all,
I have been having issues setting my sampling rate/ DAQ.Rate to the values 2048 and 120. I am using a start function that is set for x amount of seconds. This then triggers the scansavailablecallback and within this callback it will readout about 1 tenth of the values to be graphed out over time. When setting the DAQ’s Rate to 2048 is collects in sample batches of 205, this leaves the sample batch for 0.9s to 1.0s missing 2 samples and does not end up triggering final 0.1s of the callback. I am not too sure why it does this and am wondering if using the scansavailable callback is part of the issue. I have tried to change the DAQ rate for the 0.9-1.0s time to then activate the callback again but this does not seem to work. A similiar issue happens for 120 where it’s sample batch seems to be 13 which I am quite confused by. Any ideas or guidance on how to go about solving these issues would be greatly appreciated.
This is the callback function
function scansAvailable_Callback(app, src, ~)
% Callback function executed on DAQ object ScansAvailable event
% runs after the start button pushed event is complete
if ~isvalid(app)
return
end
disp (app.numscan)
% Read data from the DAQ object
% Read data from the DAQ object
[app.data, timestamps] = read(src,app.DAQ.ScansAvailableFcnCount, ‘OutputFormat’,’Matrix’);
test = [timestamps,app.data];
assignin("base","test",test)
% Calibration
if app.calibrate == true
% sends data to function to be calibrated appropriately
app.calibratedData = calibrateData(app,app.data, app.sl, app.int);
else
% if calibration is not turned off, just take the voltage values
for jj = app.SelectedChannels
app.calibratedData(:,jj) = (app.data(:,jj));
end
end
% checking too put the app back into configuration @ the end of the
% Store continuous acquisition data in FIFO data buffers
buffersize = round(app.DAQ.Rate * app.TimewindowEditField.Value) + 1;
app.TimestampsFIFOBuffer = storeDataInFIFO(app, app.TimestampsFIFOBuffer, buffersize, timestamps);
app.DataFIFOBufferch1 = storeDataInFIFO(app, app.DataFIFOBufferch1, buffersize, app.calibratedData(:,app.SelectedChannels));
% Plotting (Update the plot every N data points received
updatePlotInterval = 1; % Adjust this value based on your preference
if mod(src.ScansAvailableFcnCount, updatePlotInterval) == 0
% runs function that is responsible for plotting a singular
% graph
updateLivePlot(app);
end
% for data that goes to the workspace and
for ii = 1:(round(app.RateEdit.Value/10))
% keep count of the sample#/time
app.fws_x = app.fws_x + 1;
% initialize data to be written into the workspace
app.fwsdata(app.fws_x,(app.SelectedChannels)) = app.calibratedData(ii,app.SelectedChannels);
end
disp(app.fws_x)
if app.ContinuousSwitch.Value == "Off"
lengthcheck = (app.TrialLengthsEditField.Value* app.RateEdit.Value);
disp(lengthcheck)
if app.fws_x >= lengthcheck
if app.LogRequested
try
% Change the data to a timetable
WSData = array2timetable(app.fwsdata(1:app.TrialLengthsEditField.Value*app.DAQ.Rate,app.SelectedChannels),’SampleRate’,app.RateEdit.Value);
varname = table2array(app.UITable.Data(:,1));
% renames the variable names to match the channel names
for i = app.SelectedChannels
WSData = renamevars(WSData,i,varname(i));
end
% write into base workspace with the name stated in the UI
assignin(‘base’, app.VariableNameEditField.Value, WSData);
assignin("base","variable_name",app.VariableNameEditField.Value)
catch exception
uialert(app.LiveDataAcquisitionUIFigure,exception.message,’You cannot start the variable name with a number’)
end
end
setAppViewState(app, ‘configuration’);
end
end
app.numscan = app.numscan + 1;
end
And the following is what initiates the callback
function StartButtonPushed(app, event)
% so the app can go back into "configuration state"
app.fws_x = 0;
app.fwsdata = 0;
app.wstimestamps= 0;
% clearing the graphs just helps with mainly tab 2 when the
% user is switching where a channels goes (between the 2
% graphs)
cla(app.LiveAxes)
if numel(app.SelectedChannels) == 0
warndlg(‘Please select Channels to record’,’No Channels to Record from Selected’)
else
% dur = isinteger(app.DAQ.Rate/10);
% Disable DAQ device, channel properties, and start acquisition UI components
setAppViewState(app, ‘acquisition’);
% Reset FIFO buffer data
app.calibratedData = [];
app.DataFIFOBufferch1 = [];
app.TimestampsFIFOBuffer = [];
% Checks to see if the app is set to continuous or has a the
% User selected to use a recording window instead
if app.continuous == true
% preallocate for the data that is to be written for
% the workspace
app.fwsdata = zeros(400000,numel(app.numchan));
try
% starts data collection
start(app.DAQ,’continuous’);
catch exception
% In case of error show it and revert the change
uialert(app.LiveDataAcquisitionUIFigure, exception.message, ‘Start error, you may have selected channels too quick!’);
setAppViewState(app, ‘configuration’);
end
else
% preallocate for the data that is to be written for
% the workspace based on the trial length and the
% sample rate
app.fwsdata = zeros((app.RateEdit.Value*app.TrialLengthsEditField.Value),numel(app.numchan));
try
start(app.DAQ,"Duration",app.TrialLengthsEditField.Value)
catch exception
% In case of error show it and revert the change
uialert(app.LiveDataAcquisitionUIFigure, exception.message, ‘Start error’);
setAppViewState(app, ‘configuration’);
end
end
% Clear Log status text
app.LogStatusText.Text = ”;
endHi all,
I have been having issues setting my sampling rate/ DAQ.Rate to the values 2048 and 120. I am using a start function that is set for x amount of seconds. This then triggers the scansavailablecallback and within this callback it will readout about 1 tenth of the values to be graphed out over time. When setting the DAQ’s Rate to 2048 is collects in sample batches of 205, this leaves the sample batch for 0.9s to 1.0s missing 2 samples and does not end up triggering final 0.1s of the callback. I am not too sure why it does this and am wondering if using the scansavailable callback is part of the issue. I have tried to change the DAQ rate for the 0.9-1.0s time to then activate the callback again but this does not seem to work. A similiar issue happens for 120 where it’s sample batch seems to be 13 which I am quite confused by. Any ideas or guidance on how to go about solving these issues would be greatly appreciated.
This is the callback function
function scansAvailable_Callback(app, src, ~)
% Callback function executed on DAQ object ScansAvailable event
% runs after the start button pushed event is complete
if ~isvalid(app)
return
end
disp (app.numscan)
% Read data from the DAQ object
% Read data from the DAQ object
[app.data, timestamps] = read(src,app.DAQ.ScansAvailableFcnCount, ‘OutputFormat’,’Matrix’);
test = [timestamps,app.data];
assignin("base","test",test)
% Calibration
if app.calibrate == true
% sends data to function to be calibrated appropriately
app.calibratedData = calibrateData(app,app.data, app.sl, app.int);
else
% if calibration is not turned off, just take the voltage values
for jj = app.SelectedChannels
app.calibratedData(:,jj) = (app.data(:,jj));
end
end
% checking too put the app back into configuration @ the end of the
% Store continuous acquisition data in FIFO data buffers
buffersize = round(app.DAQ.Rate * app.TimewindowEditField.Value) + 1;
app.TimestampsFIFOBuffer = storeDataInFIFO(app, app.TimestampsFIFOBuffer, buffersize, timestamps);
app.DataFIFOBufferch1 = storeDataInFIFO(app, app.DataFIFOBufferch1, buffersize, app.calibratedData(:,app.SelectedChannels));
% Plotting (Update the plot every N data points received
updatePlotInterval = 1; % Adjust this value based on your preference
if mod(src.ScansAvailableFcnCount, updatePlotInterval) == 0
% runs function that is responsible for plotting a singular
% graph
updateLivePlot(app);
end
% for data that goes to the workspace and
for ii = 1:(round(app.RateEdit.Value/10))
% keep count of the sample#/time
app.fws_x = app.fws_x + 1;
% initialize data to be written into the workspace
app.fwsdata(app.fws_x,(app.SelectedChannels)) = app.calibratedData(ii,app.SelectedChannels);
end
disp(app.fws_x)
if app.ContinuousSwitch.Value == "Off"
lengthcheck = (app.TrialLengthsEditField.Value* app.RateEdit.Value);
disp(lengthcheck)
if app.fws_x >= lengthcheck
if app.LogRequested
try
% Change the data to a timetable
WSData = array2timetable(app.fwsdata(1:app.TrialLengthsEditField.Value*app.DAQ.Rate,app.SelectedChannels),’SampleRate’,app.RateEdit.Value);
varname = table2array(app.UITable.Data(:,1));
% renames the variable names to match the channel names
for i = app.SelectedChannels
WSData = renamevars(WSData,i,varname(i));
end
% write into base workspace with the name stated in the UI
assignin(‘base’, app.VariableNameEditField.Value, WSData);
assignin("base","variable_name",app.VariableNameEditField.Value)
catch exception
uialert(app.LiveDataAcquisitionUIFigure,exception.message,’You cannot start the variable name with a number’)
end
end
setAppViewState(app, ‘configuration’);
end
end
app.numscan = app.numscan + 1;
end
And the following is what initiates the callback
function StartButtonPushed(app, event)
% so the app can go back into "configuration state"
app.fws_x = 0;
app.fwsdata = 0;
app.wstimestamps= 0;
% clearing the graphs just helps with mainly tab 2 when the
% user is switching where a channels goes (between the 2
% graphs)
cla(app.LiveAxes)
if numel(app.SelectedChannels) == 0
warndlg(‘Please select Channels to record’,’No Channels to Record from Selected’)
else
% dur = isinteger(app.DAQ.Rate/10);
% Disable DAQ device, channel properties, and start acquisition UI components
setAppViewState(app, ‘acquisition’);
% Reset FIFO buffer data
app.calibratedData = [];
app.DataFIFOBufferch1 = [];
app.TimestampsFIFOBuffer = [];
% Checks to see if the app is set to continuous or has a the
% User selected to use a recording window instead
if app.continuous == true
% preallocate for the data that is to be written for
% the workspace
app.fwsdata = zeros(400000,numel(app.numchan));
try
% starts data collection
start(app.DAQ,’continuous’);
catch exception
% In case of error show it and revert the change
uialert(app.LiveDataAcquisitionUIFigure, exception.message, ‘Start error, you may have selected channels too quick!’);
setAppViewState(app, ‘configuration’);
end
else
% preallocate for the data that is to be written for
% the workspace based on the trial length and the
% sample rate
app.fwsdata = zeros((app.RateEdit.Value*app.TrialLengthsEditField.Value),numel(app.numchan));
try
start(app.DAQ,"Duration",app.TrialLengthsEditField.Value)
catch exception
% In case of error show it and revert the change
uialert(app.LiveDataAcquisitionUIFigure, exception.message, ‘Start error’);
setAppViewState(app, ‘configuration’);
end
end
% Clear Log status text
app.LogStatusText.Text = ”;
end Hi all,
I have been having issues setting my sampling rate/ DAQ.Rate to the values 2048 and 120. I am using a start function that is set for x amount of seconds. This then triggers the scansavailablecallback and within this callback it will readout about 1 tenth of the values to be graphed out over time. When setting the DAQ’s Rate to 2048 is collects in sample batches of 205, this leaves the sample batch for 0.9s to 1.0s missing 2 samples and does not end up triggering final 0.1s of the callback. I am not too sure why it does this and am wondering if using the scansavailable callback is part of the issue. I have tried to change the DAQ rate for the 0.9-1.0s time to then activate the callback again but this does not seem to work. A similiar issue happens for 120 where it’s sample batch seems to be 13 which I am quite confused by. Any ideas or guidance on how to go about solving these issues would be greatly appreciated.
This is the callback function
function scansAvailable_Callback(app, src, ~)
% Callback function executed on DAQ object ScansAvailable event
% runs after the start button pushed event is complete
if ~isvalid(app)
return
end
disp (app.numscan)
% Read data from the DAQ object
% Read data from the DAQ object
[app.data, timestamps] = read(src,app.DAQ.ScansAvailableFcnCount, ‘OutputFormat’,’Matrix’);
test = [timestamps,app.data];
assignin("base","test",test)
% Calibration
if app.calibrate == true
% sends data to function to be calibrated appropriately
app.calibratedData = calibrateData(app,app.data, app.sl, app.int);
else
% if calibration is not turned off, just take the voltage values
for jj = app.SelectedChannels
app.calibratedData(:,jj) = (app.data(:,jj));
end
end
% checking too put the app back into configuration @ the end of the
% Store continuous acquisition data in FIFO data buffers
buffersize = round(app.DAQ.Rate * app.TimewindowEditField.Value) + 1;
app.TimestampsFIFOBuffer = storeDataInFIFO(app, app.TimestampsFIFOBuffer, buffersize, timestamps);
app.DataFIFOBufferch1 = storeDataInFIFO(app, app.DataFIFOBufferch1, buffersize, app.calibratedData(:,app.SelectedChannels));
% Plotting (Update the plot every N data points received
updatePlotInterval = 1; % Adjust this value based on your preference
if mod(src.ScansAvailableFcnCount, updatePlotInterval) == 0
% runs function that is responsible for plotting a singular
% graph
updateLivePlot(app);
end
% for data that goes to the workspace and
for ii = 1:(round(app.RateEdit.Value/10))
% keep count of the sample#/time
app.fws_x = app.fws_x + 1;
% initialize data to be written into the workspace
app.fwsdata(app.fws_x,(app.SelectedChannels)) = app.calibratedData(ii,app.SelectedChannels);
end
disp(app.fws_x)
if app.ContinuousSwitch.Value == "Off"
lengthcheck = (app.TrialLengthsEditField.Value* app.RateEdit.Value);
disp(lengthcheck)
if app.fws_x >= lengthcheck
if app.LogRequested
try
% Change the data to a timetable
WSData = array2timetable(app.fwsdata(1:app.TrialLengthsEditField.Value*app.DAQ.Rate,app.SelectedChannels),’SampleRate’,app.RateEdit.Value);
varname = table2array(app.UITable.Data(:,1));
% renames the variable names to match the channel names
for i = app.SelectedChannels
WSData = renamevars(WSData,i,varname(i));
end
% write into base workspace with the name stated in the UI
assignin(‘base’, app.VariableNameEditField.Value, WSData);
assignin("base","variable_name",app.VariableNameEditField.Value)
catch exception
uialert(app.LiveDataAcquisitionUIFigure,exception.message,’You cannot start the variable name with a number’)
end
end
setAppViewState(app, ‘configuration’);
end
end
app.numscan = app.numscan + 1;
end
And the following is what initiates the callback
function StartButtonPushed(app, event)
% so the app can go back into "configuration state"
app.fws_x = 0;
app.fwsdata = 0;
app.wstimestamps= 0;
% clearing the graphs just helps with mainly tab 2 when the
% user is switching where a channels goes (between the 2
% graphs)
cla(app.LiveAxes)
if numel(app.SelectedChannels) == 0
warndlg(‘Please select Channels to record’,’No Channels to Record from Selected’)
else
% dur = isinteger(app.DAQ.Rate/10);
% Disable DAQ device, channel properties, and start acquisition UI components
setAppViewState(app, ‘acquisition’);
% Reset FIFO buffer data
app.calibratedData = [];
app.DataFIFOBufferch1 = [];
app.TimestampsFIFOBuffer = [];
% Checks to see if the app is set to continuous or has a the
% User selected to use a recording window instead
if app.continuous == true
% preallocate for the data that is to be written for
% the workspace
app.fwsdata = zeros(400000,numel(app.numchan));
try
% starts data collection
start(app.DAQ,’continuous’);
catch exception
% In case of error show it and revert the change
uialert(app.LiveDataAcquisitionUIFigure, exception.message, ‘Start error, you may have selected channels too quick!’);
setAppViewState(app, ‘configuration’);
end
else
% preallocate for the data that is to be written for
% the workspace based on the trial length and the
% sample rate
app.fwsdata = zeros((app.RateEdit.Value*app.TrialLengthsEditField.Value),numel(app.numchan));
try
start(app.DAQ,"Duration",app.TrialLengthsEditField.Value)
catch exception
% In case of error show it and revert the change
uialert(app.LiveDataAcquisitionUIFigure, exception.message, ‘Start error’);
setAppViewState(app, ‘configuration’);
end
end
% Clear Log status text
app.LogStatusText.Text = ”;
end data acquisition, toolbox, graph, callback, appdesigner, app designer MATLAB Answers — New Questions
I Just Want To Read Text From URL And Save It As Txt…. But How?
Hello, Community
I just want to ask about how to read text data from URL and save it as ASCII / .Txt Data. It maybe a simple question for all of you, but it kinda so difficult for me…
So i have a data from URL like this :
2024 05 21 33744 33744.5 2602 4 1.667 1.000 1.000 2.667 2.667 2.333 1.667 1.667 6 4 4 12 12 9 6 6 7 165 190.8 195.4 0 2024 05 22 33745 33745.5 2602 5 1.667 0.667 0.333 0.333 0.000 0.667 1.333 1.333 6 3 2 2 0 3 5 5 3 152 195.7 200.6 0 2024 05 23 33746 33746.5 2602 6 0.667 1.667 1.667 2.333 2.333 1.667 2.333 4.000 3 6 6 9 9 6 9 27 9 134 176.2 180.7 0 2024 05 24 33747 33747.5 2602 7 2.000 3.000 2.667 3.000 2.000 1.333 0.333 1.333 7 15 12 15 7 5 2 5 8 126 162.8 167.0 0 2024 05 25 33748 33748.5 2602 8 1.667 1.333 1.333 0.667 0.667 1.667 1.333 2.333 6 5 5 3 3 6 5 9 5 104 152.4 156.4 0 2024 05 26 33749 33749.5 2602 9 1.333 2.333 1.000 2.000 2.667 2.667 2.667 1.000 5 9 4 7 12 12 12 4 8 120 155.6 159.7 0
Or like this in the image of the source:
The data result of webread function is just like this :
textweb = webread("https://kp.gfz-potsdam.de/kpdata?startdate=2024-05-21&enddate=2024-05-26&format=kp1#kpdatadownload-143");
textweb =
‘2024 05 21 33744 33744.5 2602 4 1.667 1.000 1.000 2.667 2.667 2.333 1.667 1.667 6 4 4 12 12 9 6 6 7 165 190.8 195.4 0
2024 05 22 33745 33745.5 2602 5 1.667 0.667 0.333 0.333 0.000 0.667 1.333 1.333 6 3 2 2 0 3 5 5 3 152 195.7 200.6 0
2024 05 23 33746 33746.5 2602 6 0.667 1.667 1.667 2.333 2.333 1.667 2.333 4.000 3 6 6 9 9 6 9 27 9 134 176.2 180.7 0
2024 05 24 33747 33747.5 2602 7 2.000 3.000 2.667 3.000 2.000 1.333 0.333 1.333 7 15 12 15 7 5 2 5 8 126 162.8 167.0 0
2024 05 25 33748 33748.5 2602 8 1.667 1.333 1.333 0.667 0.667 1.667 1.333 2.333 6 5 5 3 3 6 5 9 5 104 152.4 156.4 0
2024 05 26 33749 33749.5 2602 9 1.333 2.333 1.000 2.000 2.667 2.667 2.667 1.000 5 9 4 7 12 12 12 4 8 120 155.6 159.7 0
‘
And i want to know how to convert the output of webread function above to become a data like this :
"2024 05 21 33744 33744.5 2602 4 1.667 1.000 1.000 2.667 2.667 2.333 1.667 1.667 6 4 4 12 12 9 6 6 7 165 190.8 195.4 0"
"2024 05 22 33745 33745.5 2602 5 1.667 0.667 0.333 0.333 0.000 0.667 1.333 1.333 6 3 2 2 0 3 5 5 3 152 195.7 200.6 0"
"2024 05 23 33746 33746.5 2602 6 0.667 1.667 1.667 2.333 2.333 1.667 2.333 4.000 3 6 6 9 9 6 9 27 9 134 176.2 180.7 0"
"2024 05 24 33747 33747.5 2602 7 2.000 3.000 2.667 3.000 2.000 1.333 0.333 1.333 7 15 12 15 7 5 2 5 8 126 162.8 167.0 0"
"2024 05 25 33748 33748.5 2602 8 1.667 1.333 1.333 0.667 0.667 1.667 1.333 2.333 6 5 5 3 3 6 5 9 5 104 152.4 156.4 0"
"2024 05 26 33749 33749.5 2602 9 1.333 2.333 1.000 2.000 2.667 2.667 2.667 1.000 5 9 4 7 12 12 12 4 8 120 155.6 159.7 0"
OR just simply save the output of webread function to become a txt file (ASCII) which can be opened in my local PC…
Thank you everyone for your attention and cooperation. I would be very grateful if community can help me to solve this problem /. /. /.Hello, Community
I just want to ask about how to read text data from URL and save it as ASCII / .Txt Data. It maybe a simple question for all of you, but it kinda so difficult for me…
So i have a data from URL like this :
2024 05 21 33744 33744.5 2602 4 1.667 1.000 1.000 2.667 2.667 2.333 1.667 1.667 6 4 4 12 12 9 6 6 7 165 190.8 195.4 0 2024 05 22 33745 33745.5 2602 5 1.667 0.667 0.333 0.333 0.000 0.667 1.333 1.333 6 3 2 2 0 3 5 5 3 152 195.7 200.6 0 2024 05 23 33746 33746.5 2602 6 0.667 1.667 1.667 2.333 2.333 1.667 2.333 4.000 3 6 6 9 9 6 9 27 9 134 176.2 180.7 0 2024 05 24 33747 33747.5 2602 7 2.000 3.000 2.667 3.000 2.000 1.333 0.333 1.333 7 15 12 15 7 5 2 5 8 126 162.8 167.0 0 2024 05 25 33748 33748.5 2602 8 1.667 1.333 1.333 0.667 0.667 1.667 1.333 2.333 6 5 5 3 3 6 5 9 5 104 152.4 156.4 0 2024 05 26 33749 33749.5 2602 9 1.333 2.333 1.000 2.000 2.667 2.667 2.667 1.000 5 9 4 7 12 12 12 4 8 120 155.6 159.7 0
Or like this in the image of the source:
The data result of webread function is just like this :
textweb = webread("https://kp.gfz-potsdam.de/kpdata?startdate=2024-05-21&enddate=2024-05-26&format=kp1#kpdatadownload-143");
textweb =
‘2024 05 21 33744 33744.5 2602 4 1.667 1.000 1.000 2.667 2.667 2.333 1.667 1.667 6 4 4 12 12 9 6 6 7 165 190.8 195.4 0
2024 05 22 33745 33745.5 2602 5 1.667 0.667 0.333 0.333 0.000 0.667 1.333 1.333 6 3 2 2 0 3 5 5 3 152 195.7 200.6 0
2024 05 23 33746 33746.5 2602 6 0.667 1.667 1.667 2.333 2.333 1.667 2.333 4.000 3 6 6 9 9 6 9 27 9 134 176.2 180.7 0
2024 05 24 33747 33747.5 2602 7 2.000 3.000 2.667 3.000 2.000 1.333 0.333 1.333 7 15 12 15 7 5 2 5 8 126 162.8 167.0 0
2024 05 25 33748 33748.5 2602 8 1.667 1.333 1.333 0.667 0.667 1.667 1.333 2.333 6 5 5 3 3 6 5 9 5 104 152.4 156.4 0
2024 05 26 33749 33749.5 2602 9 1.333 2.333 1.000 2.000 2.667 2.667 2.667 1.000 5 9 4 7 12 12 12 4 8 120 155.6 159.7 0
‘
And i want to know how to convert the output of webread function above to become a data like this :
"2024 05 21 33744 33744.5 2602 4 1.667 1.000 1.000 2.667 2.667 2.333 1.667 1.667 6 4 4 12 12 9 6 6 7 165 190.8 195.4 0"
"2024 05 22 33745 33745.5 2602 5 1.667 0.667 0.333 0.333 0.000 0.667 1.333 1.333 6 3 2 2 0 3 5 5 3 152 195.7 200.6 0"
"2024 05 23 33746 33746.5 2602 6 0.667 1.667 1.667 2.333 2.333 1.667 2.333 4.000 3 6 6 9 9 6 9 27 9 134 176.2 180.7 0"
"2024 05 24 33747 33747.5 2602 7 2.000 3.000 2.667 3.000 2.000 1.333 0.333 1.333 7 15 12 15 7 5 2 5 8 126 162.8 167.0 0"
"2024 05 25 33748 33748.5 2602 8 1.667 1.333 1.333 0.667 0.667 1.667 1.333 2.333 6 5 5 3 3 6 5 9 5 104 152.4 156.4 0"
"2024 05 26 33749 33749.5 2602 9 1.333 2.333 1.000 2.000 2.667 2.667 2.667 1.000 5 9 4 7 12 12 12 4 8 120 155.6 159.7 0"
OR just simply save the output of webread function to become a txt file (ASCII) which can be opened in my local PC…
Thank you everyone for your attention and cooperation. I would be very grateful if community can help me to solve this problem /. /. /. Hello, Community
I just want to ask about how to read text data from URL and save it as ASCII / .Txt Data. It maybe a simple question for all of you, but it kinda so difficult for me…
So i have a data from URL like this :
2024 05 21 33744 33744.5 2602 4 1.667 1.000 1.000 2.667 2.667 2.333 1.667 1.667 6 4 4 12 12 9 6 6 7 165 190.8 195.4 0 2024 05 22 33745 33745.5 2602 5 1.667 0.667 0.333 0.333 0.000 0.667 1.333 1.333 6 3 2 2 0 3 5 5 3 152 195.7 200.6 0 2024 05 23 33746 33746.5 2602 6 0.667 1.667 1.667 2.333 2.333 1.667 2.333 4.000 3 6 6 9 9 6 9 27 9 134 176.2 180.7 0 2024 05 24 33747 33747.5 2602 7 2.000 3.000 2.667 3.000 2.000 1.333 0.333 1.333 7 15 12 15 7 5 2 5 8 126 162.8 167.0 0 2024 05 25 33748 33748.5 2602 8 1.667 1.333 1.333 0.667 0.667 1.667 1.333 2.333 6 5 5 3 3 6 5 9 5 104 152.4 156.4 0 2024 05 26 33749 33749.5 2602 9 1.333 2.333 1.000 2.000 2.667 2.667 2.667 1.000 5 9 4 7 12 12 12 4 8 120 155.6 159.7 0
Or like this in the image of the source:
The data result of webread function is just like this :
textweb = webread("https://kp.gfz-potsdam.de/kpdata?startdate=2024-05-21&enddate=2024-05-26&format=kp1#kpdatadownload-143");
textweb =
‘2024 05 21 33744 33744.5 2602 4 1.667 1.000 1.000 2.667 2.667 2.333 1.667 1.667 6 4 4 12 12 9 6 6 7 165 190.8 195.4 0
2024 05 22 33745 33745.5 2602 5 1.667 0.667 0.333 0.333 0.000 0.667 1.333 1.333 6 3 2 2 0 3 5 5 3 152 195.7 200.6 0
2024 05 23 33746 33746.5 2602 6 0.667 1.667 1.667 2.333 2.333 1.667 2.333 4.000 3 6 6 9 9 6 9 27 9 134 176.2 180.7 0
2024 05 24 33747 33747.5 2602 7 2.000 3.000 2.667 3.000 2.000 1.333 0.333 1.333 7 15 12 15 7 5 2 5 8 126 162.8 167.0 0
2024 05 25 33748 33748.5 2602 8 1.667 1.333 1.333 0.667 0.667 1.667 1.333 2.333 6 5 5 3 3 6 5 9 5 104 152.4 156.4 0
2024 05 26 33749 33749.5 2602 9 1.333 2.333 1.000 2.000 2.667 2.667 2.667 1.000 5 9 4 7 12 12 12 4 8 120 155.6 159.7 0
‘
And i want to know how to convert the output of webread function above to become a data like this :
"2024 05 21 33744 33744.5 2602 4 1.667 1.000 1.000 2.667 2.667 2.333 1.667 1.667 6 4 4 12 12 9 6 6 7 165 190.8 195.4 0"
"2024 05 22 33745 33745.5 2602 5 1.667 0.667 0.333 0.333 0.000 0.667 1.333 1.333 6 3 2 2 0 3 5 5 3 152 195.7 200.6 0"
"2024 05 23 33746 33746.5 2602 6 0.667 1.667 1.667 2.333 2.333 1.667 2.333 4.000 3 6 6 9 9 6 9 27 9 134 176.2 180.7 0"
"2024 05 24 33747 33747.5 2602 7 2.000 3.000 2.667 3.000 2.000 1.333 0.333 1.333 7 15 12 15 7 5 2 5 8 126 162.8 167.0 0"
"2024 05 25 33748 33748.5 2602 8 1.667 1.333 1.333 0.667 0.667 1.667 1.333 2.333 6 5 5 3 3 6 5 9 5 104 152.4 156.4 0"
"2024 05 26 33749 33749.5 2602 9 1.333 2.333 1.000 2.000 2.667 2.667 2.667 1.000 5 9 4 7 12 12 12 4 8 120 155.6 159.7 0"
OR just simply save the output of webread function to become a txt file (ASCII) which can be opened in my local PC…
Thank you everyone for your attention and cooperation. I would be very grateful if community can help me to solve this problem /. /. /. read webdata as text MATLAB Answers — New Questions
selecting a value based on criteria from three columns
I have a table with 13 columns. Two additional columns need to be calculated based on values in columns 1-13. Specifically as follows:
If G2=”C” and if B2=”Y” and E2=””, then the column M1 Value should = “HIG”
If G2=”C” and if B2=”” and E2=””, then the column M1 Value should = “TP”
If G2=”C” and if B2=”Y” and E2=”CTIM”, then the column M1 Value should = “TP”
If G2=”T” and if B2=”Y” and E2=””, then the column M1 Value should = “GFP”
If G2=”T” and if B2=”” and E2=””, then the column M1 Value should = “SP”
If G2=”T” and if B2=”Y” and E2=”BDSF”, then the column M1 Value should = “SP”
If G2=”O” then the column M1 Value should = “C”
If G2=”C” and if B2=”Y” and E2=””, then the column M1 Value should =
If G2=”” and if A2=not Blank, then the column M1 Value should = Error
A1B1C1D1E1F1G1H1I1J1K1L1M1ABC-DEF-GHIJ-0YSTARTRED NT N5/17/202406:21POUT BCD-EFG-HIJK-0YSTOP
GREEN
BDSF C CDE-FGH-IJKL-0YSTARTBLUE
I am thinking that a VLOOKUP would probably work best, but my brain just can’t close the loop. Thanks
I have a table with 13 columns. Two additional columns need to be calculated based on values in columns 1-13. Specifically as follows:If G2=”C” and if B2=”Y” and E2=””, then the column M1 Value should = “HIG”If G2=”C” and if B2=”” and E2=””, then the column M1 Value should = “TP”If G2=”C” and if B2=”Y” and E2=”CTIM”, then the column M1 Value should = “TP”If G2=”T” and if B2=”Y” and E2=””, then the column M1 Value should = “GFP”If G2=”T” and if B2=”” and E2=””, then the column M1 Value should = “SP”If G2=”T” and if B2=”Y” and E2=”BDSF”, then the column M1 Value should = “SP”If G2=”O” then the column M1 Value should = “C”If G2=”C” and if B2=”Y” and E2=””, then the column M1 Value should =If G2=”” and if A2=not Blank, then the column M1 Value should = ErrorA1B1C1D1E1F1G1H1I1J1K1L1M1ABC-DEF-GHIJ-0YSTARTRED NT N5/17/202406:21POUT BCD-EFG-HIJK-0YSTOPGREENBDSF C CDE-FGH-IJKL-0YSTARTBLUE I am thinking that a VLOOKUP would probably work best, but my brain just can’t close the loop. Thanks Read More
Turn sequence into a loop
idler_1 = 17;
idler_2 = 17;
idler_3 = 17;
Z_gears(1) = 17;
% Z_gear(1) is defined same holds for the idler’s
% Number of Z_gears is determined by N and gear_ratio_combo goes from (1,1)
% to (1,(columlength)
% idlers are on Z_gear place Z_gear(3),Z_gear(5),Z_gear(7) etc
% but if Z_gear(end) is uneven then do not place idler there
Z_gears(2) = Z_gears(1)*gear_ratio_combo(1,1);
Z_gears(3) = idler_1;
Z_gears(4) = Z_gears(3)*gear_ratio_combo(1,2);
Z_gears(5) = idler_2;
Z_gears(6) = Z_gears(5)*gear_ratio_combo(1,3);
Z_gears(7) = idler_3;
Z_gears(8) = Z_gears(7)*gear_ratio_combo(1,4);idler_1 = 17;
idler_2 = 17;
idler_3 = 17;
Z_gears(1) = 17;
% Z_gear(1) is defined same holds for the idler’s
% Number of Z_gears is determined by N and gear_ratio_combo goes from (1,1)
% to (1,(columlength)
% idlers are on Z_gear place Z_gear(3),Z_gear(5),Z_gear(7) etc
% but if Z_gear(end) is uneven then do not place idler there
Z_gears(2) = Z_gears(1)*gear_ratio_combo(1,1);
Z_gears(3) = idler_1;
Z_gears(4) = Z_gears(3)*gear_ratio_combo(1,2);
Z_gears(5) = idler_2;
Z_gears(6) = Z_gears(5)*gear_ratio_combo(1,3);
Z_gears(7) = idler_3;
Z_gears(8) = Z_gears(7)*gear_ratio_combo(1,4); idler_1 = 17;
idler_2 = 17;
idler_3 = 17;
Z_gears(1) = 17;
% Z_gear(1) is defined same holds for the idler’s
% Number of Z_gears is determined by N and gear_ratio_combo goes from (1,1)
% to (1,(columlength)
% idlers are on Z_gear place Z_gear(3),Z_gear(5),Z_gear(7) etc
% but if Z_gear(end) is uneven then do not place idler there
Z_gears(2) = Z_gears(1)*gear_ratio_combo(1,1);
Z_gears(3) = idler_1;
Z_gears(4) = Z_gears(3)*gear_ratio_combo(1,2);
Z_gears(5) = idler_2;
Z_gears(6) = Z_gears(5)*gear_ratio_combo(1,3);
Z_gears(7) = idler_3;
Z_gears(8) = Z_gears(7)*gear_ratio_combo(1,4); sequences, for loop MATLAB Answers — New Questions
Having problems with the trainnet function
I am trying to fine tune a machine learning model. While using the trainnet function it states "Training stopped: Training loss is NaN" in the command window. The old trainNetwork functions works, which to me makes it weird that trainnet does not. How do I work around this? Possible solutions?I am trying to fine tune a machine learning model. While using the trainnet function it states "Training stopped: Training loss is NaN" in the command window. The old trainNetwork functions works, which to me makes it weird that trainnet does not. How do I work around this? Possible solutions? I am trying to fine tune a machine learning model. While using the trainnet function it states "Training stopped: Training loss is NaN" in the command window. The old trainNetwork functions works, which to me makes it weird that trainnet does not. How do I work around this? Possible solutions? machine learning, image processing MATLAB Answers — New Questions