Article Number: 52 | VC6 | VC5 | VC4 | VC3 | Post Date: December 20, 2017 | Last Updated: December 20, 2017
How do I export report dynamics data to Excel?
There are a numer of ways to do this. Suppose we’re interested in studying head impact speed for a case where a person trips and falls. First, go to the report dynamics menu, and create a report. Note, for multibody element data, such as the head, you’ll need to check “multibody elements.” You’ll also likely want to check “use global space” so that the velocity vector data for the mutibody elements is defined in global space rather than the local space of each element (see this KB post for more information).
Method 1: Copy and Paste
Scroll through the log to find the desired data. Once you find it, left-click, hold, and drag your mouse down to highlight the data.
Next, right-click to access the pop-up menu, then left-click on “Copy”.
Now your data is copied to your Windows clipboard. Next, go into Excel. Right-click to access the pop-up menu. Left-click on one of the two paste options (with or without source formatting).
Here we see our data pasted into Excel with source formatting. Now you’re ready to analyze your data.
Method 2: Create a plain text file output and open the file in Excel.
Below we review how to make a plain text output log file in Virtual CRASH 4, 5, and 6 (see this KB post for making plain text output log file in Virtual CRASH 3). First, from the template dropdown, select “text.xslt”.
Now you’ll see your report appear without colors or other special formatting. Next, save the file as a txt file.
Be sure to change the “Save as type” drop down to “Text File (“*.txt”).
Next, open the file in Excel by going to File > Open, then choose "Browse". This should bring up a file browser. Chose “Text Files” in the file type dropdown.
You should now see a “Text Import Wizard” appear. Choose Delimited and press “Next”.
Select “Tab” and press “Next”.
Select “General” and press “Finish”.
You should now see your data in Excel. You may want to reformat the data header rows to make them easier to read, but the columns are ordered in the same manner as they are in the Virtual CRASH report window. Scroll down the file to find your data. In this case, we simply searched for the word “head” to find the corresponding data.
Method 3: Export htm file and open with Excel.
An alternative to exporting a plain text file is to export an htm file directly with xslt formatting. To do this, simply select which of the templates you want to use in the upper right corner: compressed, default, monochromatic, or text. Then press the save button. Note your file will be saved in htm format.
Next, go to File > Open in Excel. Use the file browser. Chose “All Web Pages” in the file type dropdown and open your output htm file.
Now you should see your data appear in Excel. Here we searched for the word “head” to find our head impact data. Here you see the default formatting is preserved from the report dynamics window.
Here we see monochrome formatting:
Tags: Report dynamics, exporting data, open in Excel, how do I read data in Excel, biomechanics.
© 2021 Virtual CRASH, LLC. All Rights Reserved