simulink spreadsheet, datetime as duration

Question

Ultrareidar 2023-2-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1919675-simulink-spreadsheet-datetime-as-duration

评论： Ultrareidar 2023-3-31

采纳的回答： Nehemiae

Hi, I have like 5 spreadsheets sampled with different sampling time over a year.

I want to use them in simulink, how can i use a datetime (dd/mm/yyyy hh:mm:ss) as sampling time?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Nehemiae 2023-3-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1919675-simulink-spreadsheet-datetime-as-duration#answer_1186025

在 MATLAB Online 中打开

Hello @Ultrareidar,

I will assume an Excel file "Sample Data.xlsx", which has a column named DateTime with time logs for each data sample, in the format (dd/mm/yyyy hh:mm:ss). MATLAB has the datetime datatype that is automatically associated with the table that is read in. Then the duration in seconds between sample points can be calculated as below.

dataTable = readtable("Sample Data.xlsx"); 
reqDur = dataTable.DateTime(2) - dataTable.DateTime(1); % Replace DateTime with the column name in the Excel file with the time log
reqSec = seconds(reqDur);

Then, "reqSec" can be used in the "Sample Time" property of the "powergui" of Simulink that controls the sample time for discrete simulations in Simulink.

The documentation on datetime (https://www.mathworks.com/help/matlab/ref/datetime.html#d124e321916) can help in understanding the above code.

8 个评论
显示 6更早的评论隐藏 6更早的评论

Nehemiae 2023-3-9

编辑：Nehemiae 2023-3-10

在 MATLAB Online 中打开

Since you trying to extract the values from the spreadsheet, based on the logged time, essentially in Simulink what is required is a scaled version of the same. This can be done by transforming the time data into a character array and feeding it along with the data, into a timeseries object. Now this timeseries object can be called in the From Workspace block. The "Sample Time" property for each From Workspace block can be set to 0. If it is required that the data value from the spreadsheet is held till the next the timestamp, then uncheck "Interpolate data". Based on your requirement, under "Form output after final data value by" select "Holding final value". In the Model Settings > Solver, set the "Max step size" to 0.001 and "Min step size" to 0.0001, in the case of a variable-step solver. The code below can then be extended to the 5 files as required.

dataTable1 = readtable("Sample Data.xlsx"); 
dataFile1 = timeseries(dataTable1.Values, char(dataTable1.DateTime));

This is the output for interpolated data.

You could use the From Spreadsheet block, if you had time data in terms of simulation time, which is what is created above.

The documentation on the "timeseries" function (https://www.mathworks.com/help/matlab/ref/timeseries.html#d124e1251402) can be helpful.

Eric Sofen 2023-3-29

It's not clear to me whether you want to:

A) bring the data into Simulink at its original logged rate and do aligning (interpolation or sampling) as part of the data ingestion and solving process, or

B) Align the data from the 5 spreadsheets first in MATLAB and then pass it to Simulink.

I think Nehemiae's answers address (A). For (B), you can read the data into timetables and then use the synchronize function to get all the data into a timetable with a 1s timestep.

Ultrareidar 2023-3-31

Yes, its has been solved. I added a column to my excel sheet that stored the duration between each sample point, often 15 sec. Then used this line to use it as duration in a timetable : cumsum(duration(0, 0, seconds(dataTable.Duration - dateshift(dataTable.Duration, 'start', 'day'))))

And now i can run with a steptime of 1s.

Thanks

请先登录，再进行评论。