|Figure 1: Copy data from Energy2D.|
Since a few users asked if the simulation data in Energy2D can be exported to other applications such as Excel, I have added a feature to the app for extracting virtual sensor data as multi-column time series data. For the user’s convenience, there are three different ways of getting these data:
- When right-clicking on a sensor, the “View Data…” from the popup menu returns the data that has been recorded by the selected sensor.
- When right-clicking on a spot not occupied by a sensor, the “View Data…” from the popup menu returns a tabbed pane that contains all the sensor data — different types of sensor are organized in different tabs.
- When the translucent graph is open, clicking the View Data button on the graph window’s control panel returns the data recorded by all the sensors of the selected type, in consistent with the current display of the data in the graph window.
|Figure 2: Paste data into Excel.|
Regardless of which way you use, use the “Copy Data” button at the bottom of the data window to copy the data (Figure 1) and paste it into Excel. Once you get the data into Excel, you can process and plot them in any way you want (Figure 2). This feature is very handy if you need to combine data from multiple simulations into a single graph.
Note: This feature only works for the app. For security reason, the embedded applet is not allowed to access the System Clipboard (this is understandable, because people often copy and paste important information!)