{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Macros Disabled","Welcome","locations","routes","journey_data","matrix_time_alternatives","matrix_km_alternatives","settings"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Macros Disabled","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Welcome","index":1,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Welcome"]
[null,"This file will help you to create the datasets required for upload into the TESS Elation™ scheduler"]
[null,"For user guide see website","https://tessscheduling.com/support/"]
[]
[null,"Warnings"]
[null,"Macros","This system requires macros, and is provided without warranty. Always save your work before running macros as they can be unstable and cause Excel to crash."]
[null,"Windows required","Macros require access to FileSystemObjects, and will not work with non-Windows machines. Please contact your supplier for further support options."]
[null,"Commas in CSVs","CSV = Comma Separated Variables. Data cannot contain commas, and any found will be cleaned out by macros during processing."]
[null,"Accuracy of spellings","Location names are used for multiple lookup purposes, and so the system requires consistency of spellings throughout. Again, integrity is tested by macros."]
[]
[null,"Formatting"]
[null,"Input","Enter data in cells that have the \"Input\" style applied"]
[null,"Zero","Matrices only: leave as zero values"]
[null,"Structural boundary","These cells force you to enter data above them, which helps ensure worksheet integrity"]
[]
[null,"Worksheets"]
[null,"Locations","This list is the list of all key locations on your network. It includes the Start and End points of any bus route, but excludes individual bus stops along a route"]
[null,"Routes","This is the list of all routes along which a bus will travel"]
[null,"Journey_data","This list is your required timetable, which should be based on a separate demand study and include your expected Departure and Arrival times"]
[null,"Matrix_time_alternatives","The time required to travel directly between any two locations if required"]
[null,"Matrix_km_alternatives","The distance to travel directly between any two locations if required"]
[]
[null,"Instructions","Follow these steps in the order shown"]
[1,"Complete Locations","enter data on Locations worksheet"]
[2,"Complete Routes","enter data on Routes worksheet"]
[3,"Complete Journey Data","enter data on Journeys worksheet"]
[4,"Create Matrices","run this macro"]
[5,"Complete Matrices","enter data on Matrix worksheets"]
[6,"Validate all data entered","run this macro"]
[7,"Check for commas","run this macro"]
[8,"Create CSVs","run this macro"]
[]
[null,"Reset system"]
[null,"Reset system","all data will be lost"]
[]
[null,"Outcome"]
[null,"Three CSV files will be created in the same folder as this file, which can be uploaded to the TESS Elation™ web app"]
[null,"Files will have names like [yyyymmdd hhmmss Journeys.csv]"]

{"sheet":"locations","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Name","LocationType"]

{"sheet":"routes","index":3,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Name","StartLocation","EndLocation","Distance","maxVehicleSize"]

{"sheet":"journey_data","index":4,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["JourneyRef","RouteNum","DepTime","ArrTime","VehCap"]

{"sheet":"matrix_time_alternatives","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,"location 1"]
["location 1","00:00:00"]

{"sheet":"matrix_km_alternatives","index":6,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,"location 1"]
["location 1",0]

{"sheet":"settings","index":7,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Locations MUST be one of the following types:"]
[null,"Stop"]
[null,"BreakLocation"]
[null,"VehicleDepot"]