The size of Journey Time files
Due to the limitations of spreadsheet packages like Excel, in rare instances generated Journey Time files may exceed the possibilities of the data that can be contained within a single xls file (or when Excel attempts to open a very large csv file). For instance, if a file contains more than 256 columns or more than 65,536 rows, it cannot be opened within Excel.
Depending on the amount of analyses (columns) being run in a simulation and the number of Entities (rows) involved, a Journey Time file may need to be split into two or more files. LEGION Simulators handles this in the following ways.
Splitting csv files
The naming convention for a generated csv file is:
JT (.ana file name) HH-MM-SS DD-MM-YY_x_y.csvwhere JT indicates that it is a Journey Time file, HH-MM-SS are Hours, Minutes and Seconds and DD-MM-YY are Day, Month and Year. The element _x represents a split when there are too many columns, _y represents a split when there are too many rows.
For a file named JT (Stairs.ana) 14-25-41 04-11-04_x_y.csv, the following files would be generated, depending on the number of columns and rows it contains:
Number of files | File names |
---|---|
One file, within maximum number of columns and rows permitted | JT (Stairs.ana) 14-25-41 04-11-04_1_1.csv |
Two files due to excess columns |
JT (Stairs.ana) 14-25-41 04-11-04_1_1.csv
& JT (Stairs.ana) 14-25-41 04-11-04_2_1.csv |
Two files due to excess rows |
JT (Stairs.ana) 14-25-41 04-11-04_1_1.csv
& JT (Stairs.ana) 14-25-41 04-11-04_1_2.csv |
Four files due to excess columns and rows |
JT (Stairs.ana) 14-25-41 04-11-04_1_1.csv
& JT (Stairs.ana) 14-25-41 04-11-04_2_1.csv& JT (Stairs.ana) 14-25-41 04-11-04_1_2.csv& JT (Stairs.ana) 14-25-41 04-11-04_2_2.csv |