{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Data Input","Outputs for CLP"],"not_rendered":{"charts":7,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":"Instructions","index":0,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[[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],[33,3,34,34],[26,22,26,26],[26,3,26,21],[27,3,27,5],[27,7,27,35],[28,3,28,35]]}
[]
[]
[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 1.0",null,null,null,"Completed by:"]
[null,null,null,"Last Updated:",null,null,null,null,null,null,"2017-04-13",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":1,"n_rows":135,"n_cols":81,"rows_kept":135,"cut":false,"hidden":false,"merged":[[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],[84,16,85,16],[84,7,85,7],[84,8,85,8],[84,9,85,9],[84,10,85,10],[84,11,85,11],[84,29,85,29],[84,28,85,28],[84,27,85,27],[84,26,85,26],[84,25,85,25],[84,24,85,24],[84,23,85,23],[84,22,85,22],[84,21,85,21],[84,20,85,20],[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],[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],[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],[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],[50,4,50,27],[25,7,25,8],[26,7,26,8],[24,7,24,8],[59,3,60,4],[59,9,60,15]]}
[]
[null,"                 CONSTRUCTION LOGISTICS PLANNING TOOL   (INPUTS)"]
[null,null,null,"USER INPUTS"]
[]
[]
[null,null,null,"Development name:","Developments Inc",null,null,null,null,null,null,"Building","Infrastructure","Renovation of existing building"]
[null,null,null,"Landowner:","HWWinning",null,null,null,null,null,null,"Site setup and demolition","Site establishment, clearance & alterations","New build"]
[null,null,null,"Principal contractor:","Sander & Sons",null,null,null,null,null,null,"Basement excavation and piling","Excavation and foundations","Vacant"]
[null,null,null,"Site addess:","2 St John's Wood Road",null,null,null,null,null,null,"Sub-structure","Sub-structure","Structures to be demolished"]
[null,null,null,"Site postcode:","NW8",null,null,null,null,null,null,"Super-structure","Super-structure","Structures to be retianed"]
[null,null,null,"Freight infrastructure postcode:","NW1 8NS",null,null,null,null,null,null,"Cladding","Services & systems installation "]
[null,null,null,"Type of project:","Building"]
[null,null,null,"Type of construction:","New build"]
[null,null,null,"State of current site:","Structures to be demolished"]
[null,null,null,"Number of working days per month:",22,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",18000,2200,null,null,15000,null,null,null,3600,null,3900,{"$f":"SUM(E18:O18)","v":42700}]
[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":18000},{"$f":"SUM(F18:F19)","v":2200},0,0,15000,0,0,0,3600,0,3900,{"$f":"SUM(E18:O19)","v":42700}]
[]
[null,null,null,"Construction stage","Schedule (mmm/yyyy)"]
[null,null,null,null,"Start month","End month"]
[null,null,{"$f":"DATE(YEAR(E24) - 5, MONTH(E24), DAY(E24))","v":"2020-04-01"},{"$f":"IF($E$12=\"Building\", $L7, IF($E$12=\"Infrastructure\", $M7, \"Select Project Type Above\"))","v":"Site setup and demolition"},"2025-04-01","2025-11-01"]
[null,null,{"$f":"F29","v":"2028-08-01"},{"$f":"IF($E$12=\"Building\", $L8, IF($E$12=\"Infrastructure\", $M8, \"Select Project Type Above\"))","v":"Basement excavation and piling"},"2025-11-01","2026-06-01","Axis Scale","X"]
[null,null,null,{"$f":"IF($E$12=\"Building\", $L9, IF($E$12=\"Infrastructure\", $M9, \"Select Project Type Above\"))","v":"Sub-structure"},"2026-04-01","2027-03-01","Min",{"$f":"EDATE(E24, -1)","v":45717}]
[null,null,null,{"$f":"IF($E$12=\"Building\", $L10, IF($E$12=\"Infrastructure\", $M10, \"Select Project Type Above\"))","v":"Super-structure"},"2027-02-01","2027-10-01","Max",{"$f":"EDATE(F29, 3)","v":47058}]
[null,null,"2012-07-10",{"$f":"IF($E$12=\"Building\", $L11, IF($E$12=\"Infrastructure\", $M11, \"Select Project Type Above\"))","v":"Cladding"},"2027-06-01","2028-01-01","Tick",100]
[null,null,41100,{"$f":"IF($E$12=\"Building\", $L15, IF($E$12=\"Infrastructure\", $M15, \"Select Project Type Above\"))","v":"Fit-out, testing and commissioning"},"2027-10-01","2028-08-01"]
[]
[null,null,null,"Construction stage","Schedule",null,null,null,{"$f":"E24","v":"2025-04-01"},{"$f":"EDATE(I31,1)","v":"2025-05-01"},{"$f":"EDATE(J31,1)","v":"2025-06-01"},"2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01","2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01","2027-06-01","2027-07-01","2027-08-01","2027-09-01","2027-10-01",{"$f":"EDATE(AM31,1)","v":"2027-11-01"},"2027-12-01","2028-01-01","2028-02-01","2028-03-01","2028-04-01","2028-05-01","2028-06-01","2028-07-01","2028-08-01","2028-09-01","2028-10-01","2028-11-01","2028-12-01","2029-01-01","2029-02-01","2029-03-01","2029-04-01","2029-05-01","2029-06-01","2029-07-01","2029-08-01","2029-09-01","2029-10-01","2029-11-01","2029-12-01","2030-01-01","2030-02-01","2030-03-01","2030-04-01","2030-05-01","2030-06-01","2030-07-01","2030-08-01","2030-09-01","2030-10-01","2030-11-01","2030-12-01","2031-01-01","2031-02-01","2031-03-01","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":214},{"$f":"$D$24","v":"Site setup and demolition"},{"$f":"E24","v":"2025-04-01"},"2025-11-01",{"$f":"(YEAR(F33)-YEAR(E33))*12+MONTH(F33)-MONTH(E33)+1","v":8},{"$f":"1","v":1},550,550,550,880,880,880,880,700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":5870}]
[null,null,212,{"$f":"$D$25","v":"Basement excavation and piling"},"2025-11-01","2026-06-01",8,{"$f":"IF(E34>=$E$33,(YEAR(E34)-YEAR($E$33))*12+MONTH(E34)-MONTH($E$33)+1,0)","v":8},null,null,null,null,null,null,null,400,880,990,990,990,660,660,550,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6120]
[null,null,334,{"$f":"$D$26","v":"Sub-structure"},"2026-04-01","2027-03-01",12,{"$f":"IF(E35>=$E$33,(YEAR(E35)-YEAR($E$33))*12+MONTH(E35)-MONTH($E$33)+1,0)","v":13},null,null,null,null,null,null,null,null,null,null,null,null,330,330,440,990,990,990,770,770,770,1540,1000,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9820]
[null,null,242,{"$f":"$D$27","v":"Super-structure"},"2027-02-01","2027-10-01",9,{"$f":"IF(E36>=$E$33,(YEAR(E36)-YEAR($E$33))*12+MONTH(E36)-MONTH($E$33)+1,0)","v":23},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,540,540,1980,1980,1000,1000,500,500,500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8540]
[null,null,214,{"$f":"$D$28","v":"Cladding"},"2027-06-01","2028-01-01",8,{"$f":"IF(E37>=$E$33,(YEAR(E37)-YEAR($E$33))*12+MONTH(E37)-MONTH($E$33)+1,0)","v":27},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,980,1050,1000,900,1100,1100,1000,500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7630]
[null,null,305,{"$f":"$D$29","v":"Fit-out, testing and commissioning"},"2027-10-01","2028-08-01",11,{"$f":"IF(E38>=$E$33,(YEAR(E38)-YEAR($E$33))*12+MONTH(E38)-MONTH($E$33)+1,0)","v":31},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,500,500,1000,1000,1000,1870,1870,1540,1540,770,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12090]
[null,null,null,null,null,null,null,"Monthly total",{"$f":"SUM(I33:I38)","v":550},550,550,880,880,880,880,1100,880,990,990,990,990,990,990,990,990,990,770,770,770,1540,1540,1440,1980,1980,1980,2050,1500,1400,{"$f":"SUM(AM33:AM38)","v":2100},1600,1500,1500,1000,1000,1870,1870,1540,1540,770,{"$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":50070}]
[null,null,null,null,null,null,null,"Average daily total",{"$f":"I39/Days","v":25},25,25,40,40,40,40,50,40,45,45,45,45,45,45,45,45,45,35,35,35,70,70,65.454545454545453,90,90,90,93.181818181818187,68.181818181818187,63.636363636363633,{"$f":"AM39/Days","v":95.454545454545453},72.727272727272734,68.181818181818187,68.181818181818187,45.454545454545453,45.454545454545453,85,85,70,70,35,0,0,0,0,0,0,0,0,{"$f":"BF39/Days","v":0},{"$f":"BG39/Days","v":0},{"$f":"BH39/Days","v":0},{"$f":"BI39/Days","v":0},{"$f":"BJ39/Days","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"CC39/Days","v":2275.909090909091}]
[]
[null,null,null,"Construction stage","Vehicle type"]
[null,null,null,null,"≤ 3.5t","3.5t - 7.5t"," ≥ 7.5t","Total"]
[null,null,null,{"$f":"$D$24","v":"Site setup and demolition"},0.1,0.15,0.75,{"$f":"SUM(E44:G44)","v":1}]
[null,null,null,{"$f":"$D$25","v":"Basement excavation and piling"},0.28000000000000003,0.22,0.5,1]
[null,null,null,{"$f":"$D$26","v":"Sub-structure"},0.22,0.28000000000000003,0.5,1]
[null,null,null,{"$f":"$D$27","v":"Super-structure"},0.13,0.12,0.75,1]
[null,null,null,{"$f":"$D$28","v":"Cladding"},0.15,0.1,0.75,1]
[null,null,null,{"$f":"$D$29","v":"Fit-out, testing and commissioning"},0.8,0.14000000000000001,0.06,1]
[]
[null,null,null,"Construction stage","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":"Site setup and demolition"},0,0,0,0,0,0,0.05,0.1,0.25,0.25,0.15,0.1,0.05,0.01,0.01,0.01,0.01,0.01,0,0,0,0,0,0,{"$f":"SUM(E53:AB53)","v":1}]
[null,null,null,{"$f":"$D$25","v":"Basement excavation and piling"},0,0,0,0,0,0,0.05,0.1,0.25,0.25,0.15,0.1,0.05,0.01,0.01,0.01,0.01,0.01,0,0,0,0,0,0,1]
[null,null,null,{"$f":"$D$26","v":"Sub-structure"},0,0,0,0,0,0,0.05,0.1,0.2,0.2,0.2,0.1,0.05,0.02,0.02,0.02,0.02,0.02,0,0,0,0,0,0,1]
[null,null,null,{"$f":"$D$27","v":"Super-structure"},0,0,0,0,0,0.01,0.04,0.05,0.05,0.06,0.08,0.08,0.1,0.13,0.1,0.12,0.1,0.08,0,0,0,0,0,0,1]
[null,null,null,{"$f":"$D$28","v":"Cladding"},0,0,0,0,0,0.02,0.03,0.1,0.15,0.25,0.2,0.1,0.05,0.02,0.02,0.02,0.02,0.02,0,0,0,0,0,0,1]
[null,null,null,{"$f":"$D$29","v":"Fit-out, testing and commissioning"},0,0,0,0,0,0.01,0.04,0.08,0.08,0.06,0.05,0.04,0.05,0.05,7.0000000000000007E-2,0.2,0.25,0.02,0,0,0,0,0,0,1]
[]
[null,null,null,"EXPECTED NUMBER OF VEHICLES ",null,null,null,null,null,"  CONSTRUCTION PROGRAMME OVERVIEW "]
[]
[]
[null,null,null,"Construction stage",{"$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 (Oct-2027)"}]
[null,null,null,null,"≤ 3.5t","3.5t - 7.5t"," ≥ 7.5t","Total"]
[null,null,null,{"$f":"$D$24","v":"Site setup and demolition"},{"$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":"Basement excavation and piling"},0,0,0,0]
[null,null,null,{"$f":"$D$26","v":"Sub-structure"},0,0,0,0]
[null,null,null,{"$f":"$D$27","v":"Super-structure"},65,60,375,500]
[null,null,null,{"$f":"$D$28","v":"Cladding"},165,110,825,1100]
[null,null,null,{"$f":"$D$29","v":"Fit-out, testing and commissioning"},400,70,30,500]
[null,null,null,"Total",{"$f":"SUM(E65:E70)","v":630},{"$f":"SUM(F65:F70)","v":240},{"$f":"SUM(G65:G70)","v":1230},{"$f":"SUM(E65:G70)","v":2100}]
[]
[null,null,null,"Construction stage","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":"Site setup and demolition"},{"$f":"H75*E44","v":110},{"$f":"H75*F44","v":165},{"$f":"H75*G44","v":825},{"$f":"E97","v":1100}]
[null,null,null,{"$f":"$D$25","v":"Basement excavation and piling"},308.00000000000006,242,550,1100]
[null,null,null,{"$f":"$D$26","v":"Sub-structure"},338.8,431.20000000000005,770,1540]
[null,null,null,{"$f":"$D$27","v":"Super-structure"},273,252,1575,2100]
[null,null,null,{"$f":"$D$28","v":"Cladding"},315,210,1575,2100]
[null,null,null,{"$f":"$D$29","v":"Fit-out, testing and commissioning"},1680,294,126,2100]
[]
[null,null,null,"EXPECTED SCHEDULE OF VEHICLES "]
[]
[]
[null,null,null,"Construction stage",{"$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 (Oct-2027)"},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":"Site setup and demolition"},{"$f":"OFFSET($H$32,1,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":0},{"$f":"IFERROR(E87/Days,\"\")","v":0},{"$f":"$F$87*E53","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]
[null,null,null,{"$f":"$D$25","v":"Basement excavation and piling"},{"$f":"OFFSET($H$32,2,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":0},0,{"$f":"$F$88*E54","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]
[null,null,null,{"$f":"$D$26","v":"Sub-structure"},{"$f":"OFFSET($H$32,3,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":0},0,{"$f":"$F$89*E55","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]
[null,null,null,{"$f":"$D$27","v":"Super-structure"},{"$f":"OFFSET($H$32,4,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":500},{"$f":"IFERROR(E90/Days,\"\")","v":22.727272727272727},{"$f":"$F$90*E56","v":0},0,0,0,0,0.22727272727272727,0.90909090909090906,1.1363636363636365,1.1363636363636365,1.3636363636363635,1.8181818181818181,1.8181818181818181,2.2727272727272729,2.9545454545454546,2.2727272727272729,2.7272727272727271,2.2727272727272729,1.8181818181818181,0,0,0,0,0,0]
[null,null,null,{"$f":"$D$28","v":"Cladding"},{"$f":"OFFSET($H$32,5,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":1100},50,{"$f":"$F$91*E57","v":0},0,0,0,0,1,1.5,5,7.5,12.5,10,5,2.5,1,1,1,1,1,0,0,0,0,0,0]
[null,null,null,{"$f":"$D$29","v":"Fit-out, testing and commissioning"},{"$f":"OFFSET($H$32,6,MATCH(MAX($I$39:$CB$39),$I$39:$CB$39,0))","v":500},22.727272727272727,{"$f":"$F$92*E58","v":0},0,0,0,0,0.22727272727272727,0.90909090909090906,1.8181818181818181,1.8181818181818181,1.3636363636363635,1.1363636363636365,0.90909090909090906,1.1363636363636365,1.1363636363636365,1.5909090909090911,4.5454545454545459,5.6818181818181817,0.45454545454545453,0,0,0,0,0,0]
[null,null,null,"Total",{"$f":"SUM(E87:E92)","v":2100},{"$f":"SUM(F87:F92)","v":95.454545454545439},{"$f":"SUM(G87:G92)","v":0},0,0,0,0,1.4545454545454546,3.3181818181818183,7.954545454545455,10.454545454545455,15.227272727272727,12.954545454545455,7.7272727272727275,5.9090909090909101,5.0909090909090908,4.8636363636363642,8.2727272727272734,8.954545454545455,3.2727272727272729,0,0,0,0,0,0]
[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":41.25},{"$f":"IFERROR(60/M93, NA())","v":18.082191780821915},{"$f":"IFERROR(60/N93, NA())","v":7.5428571428571427},{"$f":"IFERROR(60/O93, NA())","v":5.7391304347826084},{"$f":"IFERROR(60/P93, NA())","v":3.9402985074626868},4.6315789473684212,{"$f":"IFERROR(60/R93, NA())","v":7.7647058823529411},{"$f":"IFERROR(60/S93, NA())","v":10.153846153846152},{"$f":"IFERROR(60/T93, NA())","v":11.785714285714286},{"$f":"IFERROR(60/U93, NA())","v":12.33644859813084},{"$f":"IFERROR(60/V93, NA())","v":7.2527472527472518},{"$f":"IFERROR(60/W93, NA())","v":6.7005076142131976},{"$f":"IFERROR(60/X93, NA())","v":18.333333333333332},{"$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 stage","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":"Site setup and demolition"},{"$f":"MAX(OFFSET($H$32,7,$H33,1,COUNT(I33:CB33)))","v":1100},{"$f":"IFERROR(E97/Days,\"\")","v":50},{"$f":"$F$97*E53","v":0},0,0,0,0,0,2.5,5,12.5,12.5,7.5,5,2.5,0.5,0.5,0.5,0.5,0.5,0,0,0,0,0,0]
[null,null,null,{"$f":"$D$25","v":"Basement excavation and piling"},1100,50,{"$f":"$F$98*E54","v":0},0,0,0,0,0,2.5,5,12.5,12.5,7.5,5,2.5,0.5,0.5,0.5,0.5,0.5,0,0,0,0,0,0]
[null,null,null,{"$f":"$D$26","v":"Sub-structure"},1540,70,{"$f":"$F$99*E55","v":0},0,0,0,0,0,3.5,7,14,14,14,7,3.5,1.4000000000000001,1.4000000000000001,1.4000000000000001,1.4000000000000001,1.4000000000000001,0,0,0,0,0,0]
[null,null,null,{"$f":"$D$27","v":"Super-structure"},2100,95.454545454545453,{"$f":"$F$100*E56","v":0},0,0,0,0,0.95454545454545459,3.8181818181818183,4.7727272727272725,4.7727272727272725,5.7272727272727266,7.6363636363636367,7.6363636363636367,9.545454545454545,12.40909090909091,9.545454545454545,11.454545454545453,9.545454545454545,7.6363636363636367,0,0,0,0,0,0]
[null,null,null,{"$f":"$D$28","v":"Cladding"},2100,95.454545454545453,{"$f":"$F$101*E57","v":0},0,0,0,0,1.9090909090909092,2.8636363636363633,9.545454545454545,14.318181818181818,23.863636363636363,19.09090909090909,9.545454545454545,4.7727272727272725,1.9090909090909092,1.9090909090909092,1.9090909090909092,1.9090909090909092,1.9090909090909092,0,0,0,0,0,0]
[null,null,null,{"$f":"$D$29","v":"Fit-out, testing and commissioning"},2100,95.454545454545453,{"$f":"$F$102*E58","v":0},0,0,0,0,0.95454545454545459,3.8181818181818183,7.6363636363636367,7.6363636363636367,5.7272727272727266,4.7727272727272725,3.8181818181818183,4.7727272727272725,4.7727272727272725,6.6818181818181825,19.09090909090909,23.863636363636363,1.9090909090909092,0,0,0,0,0,0]
[]
[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 (Oct-2027)"},"Hour beginning","Number of vehicles per hour","Estimated minutes between vehicle arrivals"]
[]
[]
[null,null,null,"Construction stage","Start","End"]
[null,null,null,{"$f":"$D$24","v":"Site setup and demolition"},{"$f":"E24","v":"2025-04-01"},"2025-11-01"]
[null,null,null,{"$f":"$D$25","v":"Basement excavation and piling"},"2025-11-01","2026-06-01"]
[null,null,null,{"$f":"$D$26","v":"Sub-structure"},"2026-04-01","2027-03-01"]
[null,null,null,{"$f":"$D$27","v":"Super-structure"},"2027-02-01","2027-10-01"]
[null,null,null,{"$f":"$D$28","v":"Cladding"},"2027-06-01","2028-01-01"]
[null,null,null,{"$f":"$D$29","v":"Fit-out, testing and commissioning"},"2027-10-01","2028-08-01"]
[]
[null,null,null,"Construction stage","Period of stage","No. of trips (monthly)","Peak no. of trips (daily)"]
[null,null,null,{"$f":"$D$24","v":"Site setup and demolition"},{"$f":"\"Q\"&ROUNDUP(MONTH($E24)/3,0)&\" \"&YEAR($E24)&\" - Q\"&ROUNDUP(MONTH($F24)/3,0)&\" \"&YEAR($F24)","v":"Q2 2025 - Q4 2025"},{"$f":"MAX($I33:$CB33)","v":880},{"$f":"F121/Days","v":40}]
[null,null,null,{"$f":"$D$25","v":"Basement excavation and piling"},"Q4 2025 - Q2 2026",990,45]
[null,null,null,{"$f":"$D$26","v":"Sub-structure"},"Q2 2026 - Q1 2027",1540,70]
[null,null,null,{"$f":"$D$27","v":"Super-structure"},"Q1 2027 - Q4 2027",1980,90]
[null,null,null,{"$f":"$D$28","v":"Cladding"},"Q2 2027 - Q1 2028",1100,50]
[null,null,null,{"$f":"$D$29","v":"Fit-out, testing and commissioning"},"Q4 2027 - Q3 2028",1870,85]
[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":"Q4 2027 - Q4 2027"},2100,95.454545454545453]
[]
[null,null,null,"Construction stage","Period of stage","No. of trips (monthly)","Peak no. of trips (daily)"]
[null,null,null,{"$f":"$D$24","v":"Site setup and demolition"},{"$f":"\"Q\"&ROUNDUP(MONTH($E33)/3,0)&\" \"&YEAR($E33)&\" - Q\"&ROUNDUP(MONTH($F33)/3,0)&\" \"&YEAR($F33)","v":"Q2 2025 - Q4 2025"},{"$f":"H75","v":1100},{"$f":"F130/Days","v":50}]
[null,null,null,{"$f":"$D$25","v":"Basement excavation and piling"},"Q4 2025 - Q2 2026",1100,50]
[null,null,null,{"$f":"$D$26","v":"Sub-structure"},"Q2 2026 - Q1 2027",1540,70]
[null,null,null,{"$f":"$D$27","v":"Super-structure"},"Q1 2027 - Q4 2027",2100,95.454545454545453]
[null,null,null,{"$f":"$D$28","v":"Cladding"},"Q2 2027 - Q1 2028",2100,95.454545454545453]
[null,null,null,{"$f":"$D$29","v":"Fit-out, testing and commissioning"},"Q4 2027 - Q3 2028",2100,95.454545454545453]

{"sheet":"Outputs for CLP","index":2,"n_rows":58,"n_cols":69,"rows_kept":58,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[53,30,53,35],[54,2,54,15],[54,16,54,23],[54,24,54,29],[54,30,54,35],[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]]}
[]
[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 stage",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":"Site setup and demolition"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E24","v":"2025-04-01"},null,null,null,null,null,null,{"$f":"'Data Input'!F24","v":"2025-11-01"}]
[null,null,{"$f":"'Data Input'!D25","v":"Basement excavation and piling"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E25","v":"2025-11-01"},null,null,null,null,null,null,{"$f":"'Data Input'!F25","v":"2026-06-01"}]
[null,null,{"$f":"'Data Input'!D26","v":"Sub-structure"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E26","v":"2026-04-01"},null,null,null,null,null,null,{"$f":"'Data Input'!F26","v":"2027-03-01"}]
[null,null,{"$f":"'Data Input'!D27","v":"Super-structure"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E27","v":"2027-02-01"},null,null,null,null,null,null,{"$f":"'Data Input'!F27","v":"2027-10-01"}]
[null,null,{"$f":"'Data Input'!D28","v":"Cladding"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E28","v":"2027-06-01"},null,null,null,null,null,null,{"$f":"'Data Input'!F28","v":"2028-01-01"}]
[null,null,{"$f":"'Data Input'!D29","v":"Fit-out, testing and commissioning"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E29","v":"2027-10-01"},null,null,null,null,null,null,{"$f":"'Data Input'!F29","v":"2028-08-01"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"NO. OF VEHICLES IN PEAK PHASE (EX. OTHER PHASES)"]
[]
[]
[null,null,"Construction Stage",null,null,null,null,null,null,null,null,null,null,null,null,null,"Period of stage",null,null,null,null,null,null,null,"Peak no. of \ntrips (monthly)",null,null,null,null,null,"Peak no. of trips (daily)"]
[]
[null,null,{"$f":"'Data Input'!D24","v":"Site setup and demolition"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E121","v":"Q2 2025 - Q4 2025"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F121","v":880},null,null,null,null,null,{"$f":"'Data Input'!G121","v":40}]
[null,null,{"$f":"'Data Input'!D25","v":"Basement excavation and piling"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E122","v":"Q4 2025 - Q2 2026"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F122","v":990},null,null,null,null,null,{"$f":"'Data Input'!G122","v":45}]
[null,null,{"$f":"'Data Input'!D26","v":"Sub-structure"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E123","v":"Q2 2026 - Q1 2027"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F123","v":1540},null,null,null,null,null,{"$f":"'Data Input'!G123","v":70}]
[null,null,{"$f":"'Data Input'!D27","v":"Super-structure"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E124","v":"Q1 2027 - Q4 2027"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F124","v":1980},null,null,null,null,null,{"$f":"'Data Input'!G124","v":90}]
[null,null,{"$f":"'Data Input'!D28","v":"Cladding"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E125","v":"Q2 2027 - Q1 2028"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F125","v":1100},null,null,null,null,null,{"$f":"'Data Input'!G125","v":50}]
[null,null,{"$f":"'Data Input'!D29","v":"Fit-out, testing and commissioning"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E126","v":"Q4 2027 - Q3 2028"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F126","v":1870},null,null,null,null,null,{"$f":"'Data Input'!G126","v":85}]
[null,null,"Peak period of construction",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E127","v":"Q4 2027 - Q4 2027"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F127","v":2100},null,null,null,null,null,{"$f":"'Data Input'!G127","v":95.454545454545453}]
[]
[null,null,"NO. OF VEHICLES IN PEAK PHASE (INC. POSSIBLE OVERLAP OF SUBSEQUENT PHASES)"]
[]
[]
[null,null,"Construction Stage",null,null,null,null,null,null,null,null,null,null,null,null,null,"Period of stage",null,null,null,null,null,null,null,"Peak no. of \ntrips (monthly)",null,null,null,null,null,"Peak no. of trips (daily)"]
[]
[null,null,{"$f":"'Data Input'!D24","v":"Site setup and demolition"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E130","v":"Q2 2025 - Q4 2025"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F130","v":1100},null,null,null,null,null,{"$f":"'Data Input'!G130","v":50}]
[null,null,{"$f":"'Data Input'!D25","v":"Basement excavation and piling"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E131","v":"Q4 2025 - Q2 2026"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F131","v":1100},null,null,null,null,null,{"$f":"'Data Input'!G131","v":50}]
[null,null,{"$f":"'Data Input'!D26","v":"Sub-structure"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E132","v":"Q2 2026 - Q1 2027"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F132","v":1540},null,null,null,null,null,{"$f":"'Data Input'!G132","v":70}]
[null,null,{"$f":"'Data Input'!D27","v":"Super-structure"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E133","v":"Q1 2027 - Q4 2027"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F133","v":2100},null,null,null,null,null,{"$f":"'Data Input'!G133","v":95.454545454545453}]
[null,null,{"$f":"'Data Input'!D28","v":"Cladding"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E134","v":"Q2 2027 - Q1 2028"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F134","v":2100},null,null,null,null,null,{"$f":"'Data Input'!G134","v":95.454545454545453}]
[null,null,{"$f":"'Data Input'!D29","v":"Fit-out, testing and commissioning"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Input'!E135","v":"Q4 2027 - Q3 2028"},null,null,null,null,null,null,null,{"$f":"'Data Input'!F135","v":2100},null,null,null,null,null,{"$f":"'Data Input'!G135","v":95.454545454545453}]