MATLAB Answers

Sample time settings to read data correctly from Spreadsheet

7 views (last 30 days)
I've created a model in Simulink and Simscape physical system (thermal, thermal liquid). This model needs to be simulated for a duration of a year (365 days). It is important to have a sample time of 3600sec or less. The model includes a set of data inside a spreadsheet (From Spreadsheet block), which has data on an hourly basis (24*365=8760 data sets). When simulating, it is clear that the data read from the spreadsheet are collected as if they include data at a sample rate of 1sec rather than 1 hour. As a result, within 8760 samples the data run out, which is actually after a simulation duration of 8760/60=146min=2.4hours.
No matter how I set up the solver, variable step, fixed step, the sampling rate is the same. I have even experimented with all possible settings in the "From Spreadsheet" block (sample time) but still the same results.
Any ideas on how to set this up so I can simulate for this yearly duration but utilize spreadsheet data every 3600 samples (1hr)?

  0 Comments

Sign in to comment.

Accepted Answer

Steve Miller
Steve Miller on 10 Aug 2020
I suspect the easiest way is to multiply your time vector by 3600.
If you upload the Excel spreadsheet, we can test further.

  1 Comment

Phivos Koumides
Phivos Koumides on 11 Aug 2020
Thanks Steve, I figured that out. I probably should have updated my comments then.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!