{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Macros Disabled","Controls","original data","original timeline","original summary","live data","live timeline","live summary","Analysis",">Reports>","Waybill"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":40,"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":"Controls","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Welcome"]
[null,null,"This file will help you to interpret the results provided by the TESS Elation™ scheduler"]
[null,null,"For user guide see website","https://tessscheduling.com/support/"]
[]
[]
[]
[]
[null,"Project Details",null,null,null,"Colour scheme:"]
[null,"Project Name","Example Bus Service"]
[null,null,null,null,null,"Largest vehicle"]
[null,"Scenario settings:"]
[null,"Spreadover","14:00:00"]
[null,"Working time","09:00:00"]
[null,"Maximum shift","05:00:00"]
[]
[null,"Waybill settings:"]
[null,"Implementation","2020-06-01"]
[null,"Applicable days","Monday to Friday"]
[null,"Pre-shift label","Book on at depot",null,null,"Downtime"]
[null,"Pre-shift time","00:10:00",null,null,"Repo"]
[null,"Post-shift label","Book off and pay in",null,null,"Stem"]
[null,"Post-shift time","00:10:00",null,null,"Break"]

{"sheet":"original data","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"original timeline","index":3,"n_rows":1,"n_cols":64,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,3,0,62]]}
["vehicle ref","size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]

{"sheet":"original summary","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"live data","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"live timeline","index":6,"n_rows":1,"n_cols":64,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,3,0,62]]}
["vehicle ref","size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]

{"sheet":"live summary","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Analysis","index":8,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Original","Live","change"]
[]
[null,null,"values:"]
[null,null,"Records",{"$f":"COUNTA('original data'!A:A)","v":0},{"$f":"COUNTA('live data'!A:A)","v":0},{"$f":"E5-D5","v":0}]
[null,null,"Vehicles",{"$f":"COUNTA(rngV_references)-1","v":0},{"$f":"COUNTA('live timeline'!rngV_references)-1","v":0},{"$f":"E6-D6","v":0}]
[null,null,"Drivers",{"$f":"COUNTIF('original summary'!C:C,\"total\")","v":0},{"$f":"COUNTIF('live summary'!C:C,\"total\")","v":0},{"$f":"E7-D7","v":0}]
[]
[null,null,"hours:"]
[null,null,"StemJourney",{"$f":"24*SUM('original summary'!H:H)","v":0},{"$f":"24*SUM('live summary'!H:H)","v":0},{"$f":"E10-D10","v":0}]
[null,null,"Journey",{"$f":"24*SUM('original summary'!I:I)","v":0},{"$f":"24*SUM('live summary'!I:I)","v":0},0]
[null,null,"DownTime",{"$f":"24*SUM('original summary'!J:J)","v":0},{"$f":"24*SUM('live summary'!J:J)","v":0},0]
[null,null,"Reposition",{"$f":"24*SUM('original summary'!K:K)","v":0},{"$f":"24*SUM('live summary'!K:K)","v":0},0]
[null,null,"DriverBreak",{"$f":"24*SUM('original summary'!L:L)","v":0},{"$f":"24*SUM('live summary'!L:L)","v":0},0]
[null,null,"WorkTime",{"$f":"24*SUM('original summary'!M:M)","v":0},{"$f":"24*SUM('live summary'!M:M)","v":0},0]

{"sheet":">Reports>","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Waybill","index":10,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":true,"merged":[[1,0,3,2],[1,10,3,11],[4,3,4,7],[4,8,4,9],[0,0,0,2],[12,8,12,9],[13,8,13,9],[0,10,0,11],[15,8,15,9],[18,8,18,9],[5,0,5,2],[7,8,7,9],[58,7,58,8],[58,9,58,11],[11,8,11,9],[10,8,10,9],[8,8,8,9],[25,8,25,9],[23,8,23,9],[9,8,9,9],[24,8,24,9],[17,8,17,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9]]}
["DUTY  No",null,null,{"$f":"projectName","v":"Example Bus Service"},null,null,null,null,null,null,"DUTY  No"]
[1,null,null,"DEPOT",null,null,{"$f":"D8","v":0},null,null,null,{"$f":"wbDuty","v":1}]
[null,null,null,{"$f":"ImplementationDays","v":"Monday to Friday"}]
[null,null,null," DATE IMPLEMENTED",null,null,{"$f":"ImplementationDate","v":"2020-06-01"}]
["TRIP\nNo","ROUTE\nNo","DEPART","DESTINATION  FROM",null,null,null,null,"DESTINATION TO",null,"ARRIVE","LAYOVER MINUTES"]
[{"$f":"INDEX('live timeline'!rngV_Sizes,MATCH(INDEX('live data'!A:A,MATCH(\"Duty-\" & REPT(\"0\",4-LEN(wbDuty)) & wbDuty,'live data'!B:B,0)),'live timeline'!rngV_references,0))","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PORTION","BOOK ON","BOOK OFF","PAY HRS","LAYOVER",null,"SPREAD OVER",null,"REMARKS"]
[null,null,null,null,null,null,null,"Book On",{"$f":"MIN(K7:K58)","v":"00:00:00"}]
[null,null,null,null,null,null,null,"Book Off",{"$f":"MAX(K7:K58)","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTAL    ",null,null,{"$f":"SUM(E60:E70)","v":"00:00:00"},null,null,"TOTAL HRS",{"$f":"I61-I60","v":"00:00:00"}]