Written by on Friday August 9th 2013 in SIMUL8 Tips, Technical Corner

SIMUL8 Tip – Setting Up Arrival Times and Additional Label Values from a CSV File

This feature reads the exact times Work Items should be generated at a Start Point from a CSV file. It can also assign label values to the Work Items. The CSV file can be generated by saving an Excel worksheet in this format.



1. Excel Spreadsheet Set-Up


csv1


This feature requires the CSV file to be formatted in the following way:


The CSV file must be closed before running the simulation.




2. Labels in SIMUL8


csv2


You must create labels within SIMUL8 that are identical to your label headers in your spreadsheet.  Note that these labels were created to correspond with the label name headers in the Excel CSV File.



3. Attaching the CSV File


csv3


Once the CSV file and the corresponding labels are created, the CSV file will need to be linked to the Start Point. To do this, double-click on the Start Point and the above menu will appear. Select the “File” option, and then select the CSV file. It is now linked to the Start Point.



4. Running the Simulation


csv4


When the simulation has run, you will be able to verify that the CSV file was working correctly by selecting a queue, navigating to the Properties tab, and then viewing the Contents by selecting Current Contents. Below, we can see that all of the Arrival Times and Label Values have been automatically allocated to our Work Items by using the external CSV file!


csv5