Export Reports to CSV
After running a report, you can export the data into a .csv file format for further analysis in other applications such as Microsoft Excel.
You have two export options:
- Export to CSV provides raw data for every event that occurred in the simulation. You will most likely turn to this report if the Summary report highlights an issue that you need to investigate further.
- Line Efficiency Summary Report to CSV provides a big picture of the simulation including elapsed time, total uptime and downtime, processor utilization comparisons, and details for specific objects. See the CSV Summary Report Reference table below for a description of the export fields.
To export a report to .csv
- Select Reports, and then a CSV export option:
- Select the location to save your file to and click Save.
CSV Summary Report Reference
| Column | Description |
|---|---|
| ObjectID | The unique identifier for the object in the process model. |
| ObjectName | The user-specified name for the object in the process model. |
| Object Type | The type of object: Source, processor, buffer, operator, end product, or connection |
| Items Received | The number of items received by a processor, buffer, connection, or end product. |
| Items Delivered | The number of items delivered or output by a source, processor, connection, or buffer. |
| AverageOutputCycleTime | Amount of time that a source/buffer/processor/connection sends out an item (in seconds). Calculated as: (total simulation time) / (items delivered) |
| TimeProducing | Amount of time that a processor was performing operations (in seconds). This includes Operator data. |
| TimeIdle | Amount of time that a processor or connection was idle (in seconds). This includes Operator data. |
| TimeBlocked | Amount of time that a processor or connection was blocked (in seconds). |
| TimeSetup | Amount of time that a processor was performing setup (in seconds). |
| TimeDowntime | Amount of time that a source/buffer/processor/end product was down (in seconds). |
| MinQuantity | The minimum capacity of a buffer over the entire simulation. |
| MaxQuantity | The maximum capacity of a buffer over the entire simulation. |
| AverageTimeInBuffer | The average time an item is held in a buffer over the whole simulation. Calculated as: (total stay time of all items in a buffer) / (total number of items a buffer received) |
| TimeLoad | The amount of time a connection was loading items. |
| TimeTransport | The amount of time a connection or operator was transporting items. |
| TimeUnload | The amount of time a connection was unloading items. |
| CountOfMTBF | How many times a processor experienced a failure; this excludes user stoppages. |