{"id":6609,"date":"2017-06-19T12:25:52","date_gmt":"2017-06-19T17:25:52","guid":{"rendered":"https:\/\/blogs.mathworks.com\/simulink\/?p=6609"},"modified":"2017-06-20T10:24:31","modified_gmt":"2017-06-20T15:24:31","slug":"logging-simulation-data-in-timetable-format","status":"publish","type":"post","link":"https:\/\/blogs.mathworks.com\/simulink\/2017\/06\/19\/logging-simulation-data-in-timetable-format\/","title":{"rendered":"Logging Simulation Data in Timetable format"},"content":{"rendered":"

In case you did not notice, MATLAB R2016b introduced a new type of table: timetables<\/tt><\/a>. Because Simulink logs data over time, we decided in R2017a to give the possibility to use this format for signal logging.<\/p>\n

Configuring the Model<\/strong><\/p>\n

First, you need to enable logging for some signals. For this example, I chose a house heating example, where the simulation duration is a week. I log the inside and outside temperatures, along with the energy cost. Such a long application is particularly appropriate for timetables. You will see why later.<\/p>\n

\"Enable<\/p>\n

Next, in the model configuration, ensure Signal Logging is enabled.<\/p>\n

\"Enable<\/p>\n

Finally, in the model Configuration Parameters, switch from the Commonly Used Parameters tab to the All Parameters<\/strong> tab. Select the Data Import\/Export category, and scroll to the bottom. The DatasetSignalFormat<\/tt> parameter allows you to choose between timeseries<\/tt><\/a> and timetables<\/tt><\/a>. (Note: If you prefer, you can also type \"DatasetSignalFormat\" in the search box<\/em>)<\/p>\n

\"Enable<\/p>\n

Exploring the Simulation Output<\/strong><\/p>\n

After simulating the model, a dataset<\/a> object is created in the MATLAB workspace.<\/p>\n

\"Logged<\/p>\n

For example, we can access the first ten points of the timetable for the \"cost\" signal using:<\/p>\n

\"Logged<\/p>\n

Advantages of Timetables<\/strong><\/p>\n

As mentioned previously, the example used here simulates for a long period of time (7 days). Let's look at a few features of the timetables that are particularly useful for such simulation.<\/p>\n

The first obvious advantage is that you can select the units in which the time is displayed. <\/p>\n

\"Time<\/p>\n

You have to admit that 6 days and 23 hours is easier to understand than 682560 seconds.<\/p>\n

One thing I like is the indexing based on time. For example, if I want the data between the 36th and 37th hours of the simulation, I can simply define a timerange<\/a> to index in the timetable:<\/p>\n

\"Time<\/p>\n

In a similar way, if I want to extract a few points around a specific instant, I can create a withtol subscript<\/a>. In the following example, I extract the points within a +\/- 2 minutes range around the 48th hour of simulation.<\/p>\n

\"time<\/p>\n

Using retime<\/a>, it is possible to aggregate data quite easily. The following line returns the average value for each day of simulation.<\/p>\n

\"Aggretating<\/p>\n

Those are just a few basic examples. I recommend looking at the timetable documentation for more advanced maneuvers.<\/p>\n

In my case, based on the example Preprocess and Explore Time-stamped Data Using timetable<\/a>, I have been able to group the data in four periods of the day (AM, PM, evening and night) and get an average of the outside temperature for each of those periods during the entire week the simulation lasted.<\/p>\n

\"Grouping<\/p>\n

Now it's your turn<\/strong><\/p>\n

Have you already adopted or considering adopting timetables to log your simulation data? Let us know what you think of this new feature by leaving a comment below.<\/p>\n","protected":false},"excerpt":{"rendered":"

<\/div>\n

In case you did not notice, MATLAB R2016b introduced a new type of table: timetables. Because Simulink logs data over time, we decided in R2017a to give the possibility to use this format for signal... read more >><\/a><\/p>\n","protected":false},"author":41,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[121,15,16],"tags":[215,498],"_links":{"self":[{"href":"https:\/\/blogs.mathworks.com\/simulink\/wp-json\/wp\/v2\/posts\/6609"}],"collection":[{"href":"https:\/\/blogs.mathworks.com\/simulink\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.mathworks.com\/simulink\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/simulink\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/simulink\/wp-json\/wp\/v2\/comments?post=6609"}],"version-history":[{"count":34,"href":"https:\/\/blogs.mathworks.com\/simulink\/wp-json\/wp\/v2\/posts\/6609\/revisions"}],"predecessor-version":[{"id":6643,"href":"https:\/\/blogs.mathworks.com\/simulink\/wp-json\/wp\/v2\/posts\/6609\/revisions\/6643"}],"wp:attachment":[{"href":"https:\/\/blogs.mathworks.com\/simulink\/wp-json\/wp\/v2\/media?parent=6609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/simulink\/wp-json\/wp\/v2\/categories?post=6609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/simulink\/wp-json\/wp\/v2\/tags?post=6609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}