Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Navigation
- Simcenter
- Forums
- Blogs
- Knowledge Bases

- Siemens PLM Community
- Simcenter
- Testing Knowledge Base
- Simcenter Testlab: Calculating Statistics from Tim...

- Article History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content

Simcenter Testlab: Calculating Statistics from Time Histories

Siemens Experimenter

12-20-2017
09:21 PM

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).

**Getting Started**

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.

Functions include:

- MIN – The minimum value of the time history
- MIN_X – The time value where the minimum occurs in the time history
- MAX – The maximum value of the time history
- MAX_X – The time value where the maximum occurs in the time history
- RANGE – Difference between maximum and minimum
- MEAN – Sum of data values in time history divided by number of values, mean is important in fatigue life, see SN-Curve knowledge base article
- KURTOSIS_EXCESS – Indicates the “peakiness” of the data, see Kurtosis knowledge base article
- AND MORE…

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!

Questions? Post a reply, email scott.beebe@siemens.com or contact Siemens PLM GTAC support.

**Related Links**

- Simcenter Testlab Active Picture
- Simcenter Testlab Active Picture Plug-in Download
- Simcenter Testlab Token Licensing: What is it? How does it work?
- Simcenter Testlab: Import/Export to Excel
- Simcenter Testlab: Documentation Tab
- Simcenter Testlab: Templates
- Simcenter Testlab: Keyboard and Mouse Shortcuts
- Simcenter Testlab: CTRL-PageUp and CTRL-PageDown to change worksheets
- Simcenter Testlab: How to create a custom workflow
- Simcenter Testlab: Format Based Printing with Powerpoint
- Simcenter Testlab: Eliminate Folder Clicking with List All Blocks!
- Simcenter Testlab: Replace Data Origin...
- Simcenter Testlab: Batch Reporting
- Nastran and Simcenter Testlab: Viewing Mode Shapes and FRFs
- Import ANSYS Geometry and Mode Shapes in Simcenter Testlab

Labels:

- Article History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content

Related content

Follow Siemens PLM Software

© 2019 Siemens Product Lifecycle Management Software Inc