Collected some time data and want to calculate statistics like maximums, minimums, and means? It is easy to calculate many different statistics and export them to Excel in Simcenter Testlab (formerly called LMS Test.Lab).
First, right click on the time file that statistics should be calculated upon and choose “Replace in Input Basket” as shown in Figure 1.
Using “Replace in Input Basket” clears out the current contents of the input basket. To add additional time files for analysis, right click on them and select “Add to Input Basket”.
Make sure that the ‘Time Data Selection’ worksheet is ON under ‘Tools -> Add-ins” from the main Simcenter Testlab menu.
Time Data Selection
In the ‘Time Data Selection’ worksheet, click on the button with a “…” in the upper left of the screen as shown in Figure 2.
Once the ‘Data Source Selection’ menu is open, make sure it is on ‘Input Basket’ and press the ‘Replace’ button. The time data channels will appear on the left side.
Optionally, before calculating the statistics, the time history channels can be viewed as shown in Figure 3.
Viewing the time histories has no bearing on the statistic calculations, it is just a convenience.
To calculate the statistics, click in the upper corner and toggle to ‘Single Value Statistics’ as shown in Figure 4.
An area for statistical calculations appears in the lower right of the ‘Time Data Selection’ worksheet.
Next, click on the words ‘Select Function…’ in the lower right as shown in Figure 5.
In the ‘Function Selection’ menu, highlight the desired statistical functions to be calculated on the left side of the dialog.
Use the arrow key in the center to move the functions from the left to the right side to make the statistics active as shown in Figure 6.
Press ‘OK’ when finished. Press the word ‘Calculate’ in the lower right to compute the statistics as shown in Figure 7.
After the calculations are done and the statistics are available, it is possible to copy them to Excel. First click in the upper left corner of the statistics area to highlight all the cells (Figure 8).
After highlighting the cells, right click and choose ‘Copy’. Then open Excel, right click, and choose ‘Paste’.
All the values will be in Excel. Each row represents one channel, with all the selected statistics shown.
Hope this helps with calculating statistics from time files!