Sample time settings to read data correctly from Spreadsheet

3 次查看（过去 30 天）
Phivos Koumides
Phivos Koumides 2019-8-12
评论： Phivos Koumides 2020-8-11
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)?

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

采纳的回答

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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Thermal Liquid Library 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by