Sample time settings to read data correctly from Spreadsheet
2 views (last 30 days)
Show older comments
Phivos Koumides
on 12 Aug 2019
Commented: Phivos Koumides
on 11 Aug 2020
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
Accepted Answer
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.
More Answers (0)
See Also
Categories
Find more on Thermal Liquid Library in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!