A complete table of network connections can be exported through Export > Cycle Times to CSV. This will create a lookup table of every possible permutation of source, destination, truck, loader and material. The complete lookup table can number in the tens of thousands of rows.
You might choose to do this when evaluating multiple scenarios, so you don't have to process each schedule one by one in Haul Infinity, or when generating dispatch tables for your fleet management database.
To export the complete network data, follow the steps below:
Go to the Network tab.
Go to Export > Cycle Times to CSV.
In Export Wizard window select Destination file(a) for the export. You can choose file from a list or create a new one. In this example create a file “cycle_time_export” and save it in the \NodesVersion folder.
Click NEXT to continue.
5. In Select Material Types window select which material types to include in cycle time calculations. These material types were set in Cycle Times > Materials setup step.
6. Click NEXT to continue.
7. Select Blocks and press NEXT to continue.
8. Select which operating conditions to include in the cycle time export and click NEXT to continue.
9. Select which loaders to include when exporting cycle times and click NEXT to continue.
10. Select trucks from the list. Note, that if you don’t select any trucks, then travel times won’t be calculated (shortest routes only). Click NEXT to continue.
11. Configure flags. Choose which flag states to calculate routes for. You can also drag and drop headers to organize columns order, or remove those, you don’t want to see in export file. Click NEXT to continue.
12. Wait for the export to complete and click FINISH to exit the Wizard. This will generate a haul for every single combination of material, operating condition, loader, truck and flag between every source and every destination.
| Info |
|---|
The size of the export file increases exponentially with the number of blocks selected. For large models, use the Schedule Auditor. |