{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Important","Instructions","Data Input","Outputs for CLP"],"not_rendered":{"charts":7,"images":4,"macros":1,"external_links":1,"defined_names":3,"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":"Important","index":0,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Important note"]
[]
["Before opening this tool, you must enable macros.  If you have not done this, please make a note of the instructions below, close this spreadsheet and Excel, follow the instructions and then re-download the tool."]
[]
["To enable macros"]
[]
["Open Excel, go to File > Options > Trust Center > Trust Center Options/Settings > Macro settings and select ‘Enable all macros (not recommended; potentially dangerous code can run) then click ok. "]
[]
["Note that you should reverse these settings and disable macros once this exercise is completed."]

{"sheet":"Instructions","index":1,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,3,34,34],[26,22,26,26],[26,3,26,21],[27,3,27,5],[27,7,27,35],[28,3,28,35],[2,2,4,35],[10,3,10,8],[9,10,9,13],[10,10,10,13],[30,3,31,34],[16,3,20,34],[9,3,9,8],[6,3,7,14],[13,3,14,14],[23,3,24,14],[8,21,8,34],[9,14,9,19],[10,14,10,19],[9,21,9,34]]}
[]
[]
[null,null,"          CONSTRUCTION LOGISTICS PLANNING TOOL"]
[]
[]
[]
[null,null,null,"REFERENCE INFORMATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," K   ENTER NAME BELOW   K"]
[null,null,null,"Version:",null,null,null,null,null,null,"v 3.0",null,null,null,"Completed by:"]
[null,null,null,"Last Updated:",null,null,null,null,null,null,"2017-07-06",null,null,null,"Shortcut:"]
[]
[]
[null,null,null,"PURPOSE OF TOOL"]
[]
[]
[null,null,null,"The purpose of the Tool is to help improve the creation and evaluation of CLPs by providing a number of standardised outputs. These graphical and tabular outputs provide detailed information to be used within a CLP from typical input data. The tool will help logistics managers feed reliable and relevant information into the CLP assisting them with creating this documentation."]
[]
[]
[]
[]
[]
[]
[null,null,null,"HOW TO USE CLP TOOL"]
[]
[]
[null,null,null,"Data should only be input into the blue boxes available:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATA INPUT"]
[null,null,null,"Use the",null,null,null,"button at the top of the sheet to expand columns for further data entry where required."]
[null,null,null,"The remainder of the sheet will populate accordingly based on the data input into the tool."]
[]
[null,null,null,"Chosing Buildings or Infrastructure will update the names of the phases only. The spreadsheet functions the same no matter which is chosen."]
[]
[]
[null,null,null,"Ensure that Macros are enabled for the spreadsheet. For further information on how to use the excel based tool refer to the CLP Guidence Documentation. "]

{"sheet":"Data Input","index":2,"n_rows":135,"n_cols":81,"rows_kept":135,"cut":false,"hidden":false,"merged":[[50,4,50,27],[25,7,25,8],[26,7,26,8],[24,7,24,8],[59,3,60,4],[59,9,60,15],[94,29,95,29],[50,3,51,3],[94,24,95,24],[94,25,95,25],[94,26,95,26],[94,27,95,27],[94,28,95,28],[94,19,95,19],[94,20,95,20],[94,21,95,21],[94,22,95,22],[94,23,95,23],[94,14,95,14],[94,15,95,15],[94,16,95,16],[94,17,95,17],[94,6,95,6],[94,7,95,7],[94,8,95,8],[94,18,95,18],[94,9,95,9],[94,10,95,10],[94,11,95,11],[94,12,95,12],[94,13,95,13],[21,3,22,3],[21,4,21,5],[2,3,3,3],[94,3,95,3],[94,4,94,5],[13,4,13,9],[14,4,14,9],[72,3,73,3],[72,4,72,7],[27,7,27,8],[62,3,63,3],[62,4,62,7],[41,3,42,3],[41,4,41,6],[30,4,30,7],[30,3,31,3],[84,19,85,19],[84,18,85,18],[84,17,85,17],[1,1,1,81],[7,17,7,18],[8,17,8,18],[21,7,22,15],[5,4,5,9],[6,4,6,9],[7,4,7,9],[8,4,8,9],[9,4,9,9],[11,4,11,9],[21,6,22,6],[10,4,10,9],[12,4,12,9],[84,24,85,24],[84,23,85,23],[84,22,85,22],[84,21,85,21],[84,20,85,20],[84,29,85,29],[84,28,85,28],[84,27,85,27],[84,26,85,26],[84,25,85,25],[84,16,85,16],[84,7,85,7],[84,8,85,8],[84,9,85,9],[84,10,85,10],[84,11,85,11],[81,3,82,4],[84,12,85,12],[84,13,85,13],[84,14,85,14],[84,15,85,15],[84,3,85,3],[84,4,84,5],[84,6,85,6]]}
[]
[null,"                 CONSTRUCTION LOGISTICS PLANNING TOOL   (INPUTS)"]
[null,null,null,"USER INPUTS"]
[]
[]
[null,null,null,"Development name:",null,null,null,null,null,null,null,"Building","Infrastructure","Renovation of existing building"]
[null,null,null,"Landowner:",null,null,null,null,null,null,null,"Site setup and demolition","Site establishment, clearance & alterations","New build"]
[null,null,null,"Principal contractor:",null,null,null,null,null,null,null,"Basement excavation and piling","Excavation and foundations","Vacant"]
[null,null,null,"Site addess:",null,null,null,null,null,null,null,"Sub-structure","Sub-structure","Structures to be demolished"]
[null,null,null,"Site postcode:",null,null,null,null,null,null,null,"Super-structure","Super-structure","Structures to be retianed"]
[null,null,null,"Consolidation centre postcode:",null,null,null,null,null,null,null,"Cladding","Services & systems installation "]
[null,null,null,"Type of project:"]
[null,null,null,"Type of construction:"]
[null,null,null,"State of current site:"]
[null,null,null,"Number of working days per month:",null,null,null,null,null,null,"Buildings","Fit-out, testing and commissioning","Fit-out, testing and commissioning"]
[]
[null,null,null,"Gross floor area (sqm)","   Residential","   A1 Retail","   A3 Retail","   A5 Retail","   B1 Office","   B2 General industry","   B8 Storage and distribution","   D1 Residential institutions","   D2 Leisure","   Hotel","   Other","   Total"]
[null,null,null,"New/additional floor area",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E18:O18)","v":0}]
[null,null,null,"Refurbished floor area",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E19:O19)","v":0}]
[null,null,null,"Total",{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(E18:O19)","v":0}]
[]
[null,null,null,"Construction phase","Schedule (mmm/yyyy)"]
[null,null,null,null,"Start month","End month"]
[null,null,{"$f":"DATE(YEAR(E24) - 5, MONTH(E24), DAY(E24))","v":"3794-12-31"},{"$f":"IF($E$12=\"Building\", $L7, IF($E$12=\"Infrastructure\", $M7, \"Select Project Type Above\"))","v":"Select Project Type Above"}]
[null,null,{"$f":"F29","v":"00:00:00"},{"$f":"IF($E$12=\"Building\", $L8, IF($E$12=\"Infrastructure\", $M8, \"Select Project Type Above\"))","v":"Select Project Type Above"},null,null,"Axis Scale","X"]
[null,null,null,{"$f":"IF($E$12=\"Building\", $L9, IF($E$12=\"Infrastructure\", $M9, \"Select Project Type Above\"))","v":"Select Project Type Above"},null,null,"Min",{"$f":"EDATE(E24, -1)","v":{"$error":"#NUM!"}}]
[null,null,null,{"$f":"IF($E$12=\"Building\", $L10, IF($E$12=\"Infrastructure\", $M10, \"Select Project Type Above\"))","v":"Select Project Type Above"},null,null,"Max",{"$f":"EDATE(F29, 3)","v":91}]
[null,null,"2012-07-10",{"$f":"IF($E$12=\"Building\", $L11, IF($E$12=\"Infrastructure\", $M11, \"Select Project Type Above\"))","v":"Select Project Type Above"},null,null,"Tick",100]
[null,null,41100,{"$f":"IF($E$12=\"Building\", $L15, IF($E$12=\"Infrastructure\", $M15, \"Select Project Type Above\"))","v":"Select Project Type Above"}]
[]
[null,null,null,"Construction phase","Schedule",null,null,null,{"$f":"E24","v":"00:00:00"},{"$f":"EDATE(I31,1)","v":"1900-01-31"},{"$f":"EDATE(J31,1)","v":"1900-02-28"},"1900-03-28","1900-04-28","1900-05-28","1900-06-28","1900-07-28","1900-08-28","1900-09-28","1900-10-28","1900-11-28","1900-12-28","1901-01-28","1901-02-28","1901-03-28","1901-04-28","1901-05-28","1901-06-28","1901-07-28","1901-08-28","1901-09-28","1901-10-28","1901-11-28","1901-12-28","1902-01-28","1902-02-28","1902-03-28","1902-04-28","1902-05-28","1902-06-28",{"$f":"EDATE(AM31,1)","v":"1902-07-28"},"1902-08-28","1902-09-28","1902-10-28","1902-11-28","1902-12-28","1903-01-28","1903-02-28","1903-03-28","1903-04-28","1903-05-28","1903-06-28","1903-07-28","1903-08-28","1903-09-28","1903-10-28","1903-11-28","1903-12-28","1904-01-28","1904-02-28","1904-03-28","1904-04-28","1904-05-28","1904-06-28","1904-07-28","1904-08-28","1904-09-28","1904-10-28","1904-11-28","1904-12-28","1905-01-28","1905-02-28","1905-03-28","1905-04-28","1905-05-28","1905-06-28","1905-07-28","1905-08-28","1905-09-28","1905-10-28","1905-11-28","Total"]
[null,null,"Duration (Number of days)",null,"Start month (mmm/yyyy)","End month (mmm/yyyy)","Duration (Number of months)","Month number",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72]
[null,null,{"$f":"F33-E33","v":0},{"$f":"$D$24","v":"Select Project Type Above"},{"$f":"E24","v":"00:00:00"},"00:00:00",{"$f":"(YEAR(F33)-YEAR(E33))*12+MONTH(F33)-MONTH(E33)+1","v":1},{"$f":"1","v":1},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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I33:CB33)","v":0}]
[null,null,0,{"$f":"$D$25","v":"Select Project Type Above"},"00:00:00","00:00:00",{"$f":"(YEAR(F34)-YEAR(E34))*12+MONTH(F34)-MONTH(E34)+1","v":1},{"$f":"IF(E34>=$E$33,(YEAR(E34)-YEAR($E$33))*12+MONTH(E34)-MONTH($E$33)+1,0)","v":1},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,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,0,{"$f":"$D$26","v":"Select Project Type Above"},"00:00:00","00:00:00",1,{"$f":"IF(E35>=$E$33,(YEAR(E35)-YEAR($E$33))*12+MONTH(E35)-MONTH($E$33)+1,0)","v":1},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,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,0,{"$f":"$D$27","v":"Select Project Type Above"},"00:00:00","00:00:00",1,{"$f":"IF(E36>=$E$33,(YEAR(E36)-YEAR($E$33))*12+MONTH(E36)-MONTH($E$33)+1,0)","v":1},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,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,0,{"$f":"$D$28","v":"Select Project Type Above"},"00:00:00","00:00:00",1,{"$f":"IF(E37>=$E$33,(YEAR(E37)-YEAR($E$33))*12+MONTH(E37)-MONTH($E$33)+1,0)","v":1},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,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,0,{"$f":"$D$29","v":"Select Project Type Above"},"00:00:00","00:00:00",1,{"$f":"IF(E38>=$E$33,(YEAR(E38)-YEAR($E$33))*12+MONTH(E38)-MONTH($E$33)+1,0)","v":1},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,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,"Monthly total",{"$f":"SUM(I33:I38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AM33:AM38)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AX33:AX38)","v":0},{"$f":"SUM(AY33:AY38)","v":0},{"$f":"SUM(AZ33:AZ38)","v":0},0,0,0,0,0,{"$f":"SUM(BF33:BF38)","v":0},{"$f":"SUM(BG33:BG38)","v":0},{"$f":"SUM(BH33:BH38)","v":0},{"$f":"SUM(BI33:BI38)","v":0},{"$f":"SUM(BJ33:BJ38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(CC33:CC38)","v":0}]
[null,null,null,null,null,null,null,"Average daily total",{"$f":"I39/Days","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AM39/Days","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BF39/Days","v":{"$error":"#DIV/0!"}},{"$f":"BG39/Days","v":{"$error":"#DIV/0!"}},{"$f":"BH39/Days","v":{"$error":"#DIV/0!"}},{"$f":"BI39/Days","v":{"$error":"#DIV/0!"}},{"$f":"BJ39/Days","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"CC39/Days","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Construction phase","Vehicle type"]
[null,null,null,null,"≤ 3.5t","3.5t - 7.5t"," ≥ 7.5t","Total"]
[null,null,null,{"$f":"$D$24","v":"Select Project Type Above"},null,null,null,{"$f":"SUM(E44:G44)","v":0}]
[null,null,null,{"$f":"$D$25","v":"Select Project Type Above"},null,null,null,0]
[null,null,null,{"$f":"$D$26","v":"Select Project Type Above"},null,null,null,0]
[null,null,null,{"$f":"$D$27","v":"Select Project Type Above"},null,null,null,0]
[null,null,null,{"$f":"$D$28","v":"Select Project Type Above"},null,null,null,0]
[null,null,null,{"$f":"$D$29","v":"Select Project Type Above"},null,null,null,0]
[]
[null,null,null,"Construction phase","Input hourly distribution of vehicles on typical day"]
[null,null,null,null,"00:00:00","01:00:00","02:00:00","03:00:00","04:00:00","05:00:00","06:00:00","07:00:00","08:00:00","09:00:00","10:00:00","11:00:00","12:00:00","13:00:00","14:00:00","15:00:00","16:00:00","17:00:00","18:00:00","19:00:00","20:00:00","21:00:00","22:00:00","23:00:00","Total"]
[null,null,null,{"$f":"$D$24","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E53:AB53)","v":0}]
[null,null,null,{"$f":"$D$25","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"$D$26","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"$D$27","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"$D$28","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"$D$29","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"EXPECTED NUMBER OF VEHICLES ",null,null,null,null,null,"  CONSTRUCTION PROGRAMME OVERVIEW "]
[]
[]
[null,null,null,"Construction phase",{"$f":"\"No. of vehicles in peak month (\"&TEXT(OFFSET($H$32,-1,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0)),\"mmm-yyyy\")&\")\"","v":"No. of vehicles in peak month (Jan-1900)"}]
[null,null,null,null,"≤ 3.5t","3.5t - 7.5t"," ≥ 7.5t","Total"]
[null,null,null,{"$f":"$D$24","v":"Select Project Type Above"},{"$f":"H65*E44","v":0},{"$f":"H65*F44","v":0},{"$f":"H65*G44","v":0},{"$f":"E87","v":0}]
[null,null,null,{"$f":"$D$25","v":"Select Project Type Above"},0,0,0,0]
[null,null,null,{"$f":"$D$26","v":"Select Project Type Above"},0,0,0,0]
[null,null,null,{"$f":"$D$27","v":"Select Project Type Above"},0,0,0,0]
[null,null,null,{"$f":"$D$28","v":"Select Project Type Above"},0,0,0,0]
[null,null,null,{"$f":"$D$29","v":"Select Project Type Above"},0,0,0,0]
[null,null,null,"Total",{"$f":"SUM(E65:E70)","v":0},{"$f":"SUM(F65:F70)","v":0},{"$f":"SUM(G65:G70)","v":0},{"$f":"SUM(E65:G70)","v":0}]
[]
[null,null,null,"Construction phase","Vehicle type in peak of individual construction phase"]
[null,null,null,null,"≤ 3.5t","3.5t - 7.5t"," ≥ 7.5t","Total"]
[null,null,null,{"$f":"$D$24","v":"Select Project Type Above"},{"$f":"H75*E44","v":{"$error":"#REF!"}},{"$f":"H75*F44","v":{"$error":"#REF!"}},{"$f":"H75*G44","v":{"$error":"#REF!"}},{"$f":"E97","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"$D$25","v":"Select Project Type Above"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"$D$26","v":"Select Project Type Above"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"$D$27","v":"Select Project Type Above"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"$D$28","v":"Select Project Type Above"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"$D$29","v":"Select Project Type Above"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,null,"EXPECTED SCHEDULE OF VEHICLES "]
[]
[]
[null,null,null,"Construction phase",{"$f":"\"Number of vehicles in peak month (\"&TEXT(OFFSET($H$32,-1,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0)),\"mmm-yyyy\")&\")\"","v":"Number of vehicles in peak month (Jan-1900)"},null,"00:00:00","01:00:00","02:00:00","03:00:00","04:00:00","05:00:00","06:00:00","07:00:00","08:00:00","09:00:00","10:00:00","11:00:00","12:00:00","13:00:00","14:00:00","15:00:00","16:00:00","17:00:00","18:00:00","19:00:00","20:00:00","21:00:00","22:00:00","23:00:00"]
[null,null,null,null,"Total","Avg daily tot"]
[null,null,null,{"$f":"$D$24","v":"Select Project Type Above"},{"$f":"OFFSET($H$32,1,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":0},{"$f":"IFERROR(E87/Days,\"\")","v":""},{"$f":"$F$87*E53","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"$D$25","v":"Select Project Type Above"},{"$f":"OFFSET($H$32,2,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":0},{"$f":"IFERROR(E88/Days,\"\")","v":""},{"$f":"$F$88*E54","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"$D$26","v":"Select Project Type Above"},{"$f":"OFFSET($H$32,3,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":0},"",{"$f":"$F$89*E55","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"$D$27","v":"Select Project Type Above"},{"$f":"OFFSET($H$32,4,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":0},{"$f":"IFERROR(E90/Days,\"\")","v":""},{"$f":"$F$90*E56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"$D$28","v":"Select Project Type Above"},{"$f":"OFFSET($H$32,5,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":0},"",{"$f":"$F$91*E57","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"$D$29","v":"Select Project Type Above"},{"$f":"OFFSET($H$32,6,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":0},"",{"$f":"$F$92*E58","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,"Total",{"$f":"SUM(E87:E92)","v":0},{"$f":"SUM(F87:F92)","v":0},{"$f":"SUM(G87:G92)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,{"$f":"IFERROR(60/G93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/H93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/I93, NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IFERROR(60/K93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/L93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/M93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/N93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/O93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/P93, NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IFERROR(60/R93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/S93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/T93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/U93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/V93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/W93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/X93, NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(60/Y93, NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"Construction phase","Number of vehicles in peak of phase (including possible overlap of subsequent phases)",null,"00:00:00","01:00:00","02:00:00","03:00:00","04:00:00","05:00:00","06:00:00","07:00:00","08:00:00","09:00:00","10:00:00","11:00:00","12:00:00","13:00:00","14:00:00","15:00:00","16:00:00","17:00:00","18:00:00","19:00:00","20:00:00","21:00:00","22:00:00","23:00:00"]
[null,null,null,null,"Total","Avg daily tot"]
[null,null,null,{"$f":"$D$24","v":"Select Project Type Above"},{"$f":"MAX(OFFSET($H$32,7,$H33,1,COUNT(I33:CB33)))","v":{"$error":"#REF!"}},{"$f":"IFERROR(E97/Days,\"\")","v":""},{"$f":"$F$97*E53","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"$D$25","v":"Select Project Type Above"},{"$error":"#REF!"},"",{"$f":"$F$98*E54","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"$D$26","v":"Select Project Type Above"},{"$error":"#REF!"},"",{"$f":"$F$99*E55","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"$D$27","v":"Select Project Type Above"},{"$error":"#REF!"},"",{"$f":"$F$100*E56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"$D$28","v":"Select Project Type Above"},{"$error":"#REF!"},"",{"$f":"$F$101*E57","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"$D$29","v":"Select Project Type Above"},{"$error":"#REF!"},"",{"$f":"$F$102*E58","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Chart labels"]
[null,null,null,"Chart","Titles","Xaxis","Y axis left","y axis right"]
[null,null,null,"Programme","Construction programme"]
[null,null,null,"Vehicle type","Number of vehicles by types during peak of phase","phase of construction","Number of vehicles"]
[null,null,null,"Vehcile Programme","Total number of vehicles through construction programme","Month beginning","Number of vehicles per month","Number of vehicles per day"]
[null,null,null,"Hourly",{"$f":"\"Number of vehicles in peak month (\"&TEXT(OFFSET($H$32,-1,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0)),\"mmm-yyyy\")&\")\"","v":"Number of vehicles in peak month (Jan-1900)"},"Hour beginning","Number of vehicles per hour","Estimated minutes between vehicle arrivals"]
[]
[]
[null,null,null,"Construction phase","Start","End"]
[null,null,null,{"$f":"$D$24","v":"Select Project Type Above"},{"$f":"E24","v":"00:00:00"},"00:00:00"]
[null,null,null,{"$f":"$D$25","v":"Select Project Type Above"},"00:00:00","00:00:00"]
[null,null,null,{"$f":"$D$26","v":"Select Project Type Above"},"00:00:00","00:00:00"]
[null,null,null,{"$f":"$D$27","v":"Select Project Type Above"},"00:00:00","00:00:00"]
[null,null,null,{"$f":"$D$28","v":"Select Project Type Above"},"00:00:00","00:00:00"]
[null,null,null,{"$f":"$D$29","v":"Select Project Type Above"},"00:00:00","00:00:00"]
[]
[null,null,null,"Construction phase","Period of phase","No. of trips (monthly)","Peak no. of trips (daily)"]
[null,null,null,{"$f":"$D$24","v":"Select Project Type Above"},{"$f":"\"Q\"&ROUNDUP(MONTH($E24)/3,0)&\" \"&YEAR($E24)&\" - Q\"&ROUNDUP(MONTH($F24)/3,0)&\" \"&YEAR($F24)","v":"Q1 1900 - Q1 1900"},{"$f":"MAX($I33:$CB33)","v":0},{"$f":"F121/Days","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"$D$25","v":"Select Project Type Above"},"Q1 1900 - Q1 1900",0,{"$error":"#DIV/0!"}]
[null,null,null,{"$f":"$D$26","v":"Select Project Type Above"},"Q1 1900 - Q1 1900",0,{"$error":"#DIV/0!"}]
[null,null,null,{"$f":"$D$27","v":"Select Project Type Above"},"Q1 1900 - Q1 1900",0,{"$error":"#DIV/0!"}]
[null,null,null,{"$f":"$D$28","v":"Select Project Type Above"},"Q1 1900 - Q1 1900",0,{"$error":"#DIV/0!"}]
[null,null,null,{"$f":"$D$29","v":"Select Project Type Above"},"Q1 1900 - Q1 1900",0,{"$error":"#DIV/0!"}]
[null,null,null,"Peak period of construction",{"$f":"\"Q\"&ROUNDUP(MONTH((EDATE(I31,((MATCH(F127,I39:CB39,0))-1))))/3,0)&\" \"&YEAR((EDATE(I31,((MATCH(F127,I39:CB39,0))-1))))&\" - Q\"&ROUNDUP(MONTH(EDATE(((EDATE(I31,((MATCH(F127,I39:CB39,0))-1)))-1),COUNTIF(I39:CB39,F127)))/3,0)&\" \"&YEAR(EDATE(((EDATE(I31,((MATCH(F127,I39:CB39,0))-1)))-1),COUNTIF(I39:CB39,F127)))","v":{"$error":"#NUM!"}},0,{"$error":"#DIV/0!"}]
[]
[null,null,null,"Construction phase","Period of phase","No. of trips (monthly)","Peak no. of trips (daily)"]
[null,null,null,{"$f":"$D$24","v":"Select Project Type Above"},{"$f":"\"Q\"&ROUNDUP(MONTH($E33)/3,0)&\" \"&YEAR($E33)&\" - Q\"&ROUNDUP(MONTH($F33)/3,0)&\" \"&YEAR($F33)","v":"Q1 1900 - Q1 1900"},{"$f":"H75","v":{"$error":"#REF!"}},{"$f":"F130/Days","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"$D$25","v":"Select Project Type Above"},"Q1 1900 - Q1 1900",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"$D$26","v":"Select Project Type Above"},"Q1 1900 - Q1 1900",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"$D$27","v":"Select Project Type Above"},"Q1 1900 - Q1 1900",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"$D$28","v":"Select Project Type Above"},"Q1 1900 - Q1 1900",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"$D$29","v":"Select Project Type Above"},"Q1 1900 - Q1 1900",{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Outputs for CLP","index":3,"n_rows":58,"n_cols":69,"rows_kept":58,"cut":false,"hidden":false,"merged":[[6,29,7,35],[57,2,57,15],[57,16,57,23],[57,24,57,29],[57,30,57,35],[55,2,55,15],[55,16,55,23],[55,24,55,29],[55,30,55,35],[56,2,56,15],[56,16,56,23],[56,24,56,29],[56,30,56,35],[53,2,53,15],[53,16,53,23],[53,24,53,29],[53,30,53,35],[54,2,54,15],[54,16,54,23],[54,24,54,29],[54,30,54,35],[50,2,51,15],[50,16,51,23],[50,24,51,29],[50,30,51,35],[52,2,52,15],[52,16,52,23],[52,24,52,29],[52,30,52,35],[44,2,44,15],[44,16,44,23],[44,24,44,29],[44,30,44,35],[45,2,45,15],[45,16,45,23],[45,24,45,29],[45,30,45,35],[37,30,38,35],[37,24,38,29],[37,16,38,23],[37,2,38,15],[41,2,41,15],[41,16,41,23],[41,24,41,29],[41,30,41,35],[40,16,40,23],[40,24,40,29],[40,30,40,35],[43,2,43,15],[43,16,43,23],[43,24,43,29],[43,30,43,35],[42,2,42,15],[42,16,42,23],[42,24,42,29],[42,30,42,35],[1,68,2,74],[1,39,2,67],[11,2,11,21],[11,22,11,28],[11,29,11,35],[8,2,8,21],[8,22,8,28],[8,29,8,35],[6,22,7,28],[6,2,7,21],[10,2,10,21],[10,22,10,28],[10,29,10,35],[9,2,9,21],[9,22,9,28],[9,29,9,35],[3,2,4,21],[34,2,35,36],[47,2,48,36],[1,2,2,29],[1,30,2,36],[12,2,12,21],[12,22,12,28],[12,29,12,35],[13,2,13,21],[13,22,13,28],[13,29,13,35],[39,2,39,15],[39,16,39,23],[39,24,39,29],[39,30,39,35],[40,2,40,15]]}
[]
[null,null,"          CONSTRUCTION LOGISTICS PLANNING TOOL   (OUTPUTS)",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,"Sheet 1 of 2",null,null,null,null,null,null,null,null,"              CONSTRUCTION LOGISTICS PLANNING TOOL   (OUTPUTS)",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,"Sheet 2 of 2"]
[]
[null,null,"CONSTRUCTION PROGRAMME OVERVIEW "]
[]
[]
[null,null,"Construction phase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start",null,null,null,null,null,null,"End"]
[]
[null,null,{"$f":"'Data Input'!D24","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E24","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Data Input'!F24","v":"00:00:00"}]
[null,null,{"$f":"'Data Input'!D25","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E25","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Data Input'!F25","v":"00:00:00"}]
[null,null,{"$f":"'Data Input'!D26","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E26","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Data Input'!F26","v":"00:00:00"}]
[null,null,{"$f":"'Data Input'!D27","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E27","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Data Input'!F27","v":"00:00:00"}]
[null,null,{"$f":"'Data Input'!D28","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E28","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Data Input'!F28","v":"00:00:00"}]
[null,null,{"$f":"'Data Input'!D29","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E29","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Data Input'!F29","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"NO. OF VEHICLES IN PEAK PHASE (EX. OTHER PHASES)"]
[]
[]
[null,null,"Construction phase",null,null,null,null,null,null,null,null,null,null,null,null,null,"Period of stage",null,null,null,null,null,null,null,"No. of \ntrips (monthly)",null,null,null,null,null,"Peak no. of trips (daily)"]
[]
[null,null,{"$f":"'Data Input'!D24","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E121","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F121","v":0},null,null,null,null,null,{"$f":"'Data Input'!G121","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'Data Input'!D25","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E122","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F122","v":0},null,null,null,null,null,{"$f":"'Data Input'!G122","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'Data Input'!D26","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E123","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F123","v":0},null,null,null,null,null,{"$f":"'Data Input'!G123","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'Data Input'!D27","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E124","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F124","v":0},null,null,null,null,null,{"$f":"'Data Input'!G124","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'Data Input'!D28","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E125","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F125","v":0},null,null,null,null,null,{"$f":"'Data Input'!G125","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'Data Input'!D29","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E126","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F126","v":0},null,null,null,null,null,{"$f":"'Data Input'!G126","v":{"$error":"#DIV/0!"}}]
[null,null,"Peak period of construction",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E127","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,{"$f":"'Data Input'!F127","v":0},null,null,null,null,null,{"$f":"'Data Input'!G127","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"NO. OF VEHICLES IN PEAK PHASE (INC. POSSIBLE OVERLAP OF SUBSEQUENT PHASES)"]
[]
[]
[null,null,"Construction phase",null,null,null,null,null,null,null,null,null,null,null,null,null,"Period of stage",null,null,null,null,null,null,null,"No. of \ntrips (monthly)",null,null,null,null,null,"Peak no. of trips (daily)"]
[]
[null,null,{"$f":"'Data Input'!D24","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E130","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F130","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"'Data Input'!G130","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'Data Input'!D25","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E131","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F131","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"'Data Input'!G131","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'Data Input'!D26","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E132","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F132","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"'Data Input'!G132","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'Data Input'!D27","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E133","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F133","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"'Data Input'!G133","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'Data Input'!D28","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E134","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F134","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"'Data Input'!G134","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'Data Input'!D29","v":"Select Project Type Above"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E135","v":"Q1 1900 - Q1 1900"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F135","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"'Data Input'!G135","v":{"$error":"#REF!"}}]