{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Summary","RD-02-T10","RD-03-T10","RD-04-T10","RD-05-T10","RD-06-T10","RD-07-T10","RD-07dual -T11"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":16,"comments":7,"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":"Summary","index":0,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[47,1,47,5],[19,0,20,0],[19,1,20,1],[45,1,45,6],[46,1,46,6],[21,1,22,1],[4,0,4,1],[16,1,17,1],[13,1,14,1],[16,0,17,0],[13,0,14,0]]}
["PRELIMINARY ESTIMATE OF DEVELOPMENT COSTS"]
["SUMMARY SHEET"]
["CG140690"]
["Wollert PSP - Roads Cost Estimate"]
[{"$f":"TODAY()","v":"2015-05-14"}]
["Version 4"]
[null,null,null,null,null,null,null," ",null,"Alternative Option"]
["ITEM","DESCRIPTION",{"$f":"'RD-02-T10'!B4","v":"RD-02"},{"$f":"'RD-03-T10'!B4","v":"RD-03"},{"$f":"'RD-04-T10'!B4","v":"RD-04"},{"$f":"'RD-05-T10'!B4","v":"RD-05"},{"$f":"'RD-06-T10'!B4","v":"RD-06"},{"$f":"'RD-07-T10'!B4","v":"RD-07"},"Total Precinct",{"$f":"'RD-07dual -T11'!B4","v":"RD-07-DUAL"}]
[null,"DRAWING SHEET REFERENCE","T10-02  & 03-P2","T10-03 & 04-P2","T10-04 & 05-P2","T10-06 & 07-P2","T10-07 & 08-P2","T10-09, 10 & 11-P2","Developer Cost","T11-P1"]
["A","Project and Program Management (%)",{"$f":"'RD-02-T10'!G7","v":120901.98993714286},{"$f":"'RD-03-T10'!G7","v":186694.11792342854},{"$f":"'RD-04-T10'!G7","v":161831.73050464282},{"$f":"'RD-05-T10'!G7","v":194967.77491371427},{"$f":"'RD-06-T10'!G7","v":190121.54274285713},{"$f":"'RD-07-T10'!G7","v":221712.53837742857},null,{"$f":"'RD-07dual -T11'!G7","v":263045.37545785715}]
["B","Design and Investigation (%)",{"$f":"'RD-02-T10'!G15","v":241803.97987428572},{"$f":"'RD-03-T10'!G15","v":373388.23584685713},{"$f":"'RD-04-T10'!G15","v":323663.46100928565},{"$f":"'RD-05-T10'!G15","v":389935.54982742859},{"$f":"'RD-06-T10'!G15","v":380243.08548571425},{"$f":"'RD-07-T10'!G15","v":443425.07675485715},null,{"$f":"'RD-07dual -T11'!G15","v":526090.75091571431}]
["C","Construction including Final Design",{"$f":"'RD-02-T10'!G24","v":2680753.6571428571},{"$f":"'RD-03-T10'!G24","v":4403163.1585714286},{"$f":"'RD-04-T10'!G24","v":3741774.1157142855},{"$f":"'RD-05-T10'!G24","v":4631063.537142857},{"$f":"'RD-06-T10'!G24","v":4499918.1714285715},{"$f":"'RD-07-T10'!G24","v":5361850.9885714287},null,{"$f":"'RD-07dual -T11'!G24","v":6519092.3285714285}]
[]
[null,"TOTAL A - C",{"$f":"'RD-02-T10'!G86","v":3043459.6269542859},{"$f":"'RD-03-T10'!G85","v":4963245.5123417145},{"$f":"'RD-04-T10'!G84","v":4227269.3072282141},{"$f":"'RD-05-T10'!G85","v":5215966.8618839998},{"$f":"'RD-06-T10'!G85","v":5070282.7996571427},{"$f":"'RD-07-T10'!G85","v":6026988.603703714},{"$f":"SUM(C14:H14)","v":28547212.711769074}]
[null,null,null,null,null,null,null,null,null,{"$f":"'RD-07dual -T11'!G85","v":7308228.4549449999}]
["D","CONTINGENCY"]
[null,"Contingency (15% of C)",{"$f":"'RD-02-T10'!G89","v":402113.04857142858},{"$f":"'RD-03-T10'!G88","v":660474.47378571425},{"$f":"'RD-04-T10'!G87","v":561266.11735714285},{"$f":"'RD-05-T10'!G88","v":694659.53057142848},{"$f":"'RD-06-T10'!G88","v":674987.72571428574},{"$f":"'RD-07-T10'!G88","v":804277.64828571433},{"$f":"SUM(C17:H17)","v":3797778.5442857146}]
[null,null,null,null,null,null,null,null,null,{"$f":"'RD-07dual -T11'!G88","v":977863.84928571421}]
["E","PROJECT BUDGET"]
[null,"Total Estimate",{"$f":"'RD-02-T10'!G92","v":3445572.6755257146},{"$f":"'RD-03-T10'!G91","v":5623719.9861274287},{"$f":"'RD-04-T10'!G90","v":4788535.4245853573},{"$f":"'RD-05-T10'!G91","v":5910626.3924554279},{"$f":"'RD-06-T10'!G91","v":5745270.5253714286},{"$f":"'RD-07-T10'!G91","v":6831266.251989428},{"$f":"SUM(C20:H20)","v":32344991.256054785}]
[null,null,null,null,null,null,null,null,null,{"$f":"'RD-07dual -T11'!G91","v":8286092.3042307142}]
[null,"Total Estimate per linear metre",{"$f":"'RD-02-T10'!G93","v":6501.0805198598391},{"$f":"'RD-03-T10'!G92","v":6283.4860180194737},{"$f":"'RD-04-T10'!G91","v":6243.2013358348859},{"$f":"'RD-05-T10'!G92","v":5916.5429353908185},{"$f":"'RD-06-T10'!G92","v":6258.4646245876129},{"$f":"'RD-07-T10'!G92","v":6221.5539635604991},null,{"$f":"'RD-07dual -T11'!G92","v":7546.5321532155867}]
[]
[null,"PM %",{"$f":"'RD-02-T10'!D3","v":9.0200000000000002E-2},{"$f":"'RD-03-T10'!D3","v":8.48E-2},{"$f":"'RD-04-T10'!D3","v":8.6499999999999994E-2},{"$f":"'RD-05-T10'!D3","v":8.4199999999999997E-2},{"$f":"'RD-06-T10'!D3","v":8.4500000000000006E-2},{"$f":"'RD-07-T10'!D3","v":8.2699999999999996E-2},null,{"$f":"'RD-07dual -T11'!D3","v":8.0699999999999994E-2}]
["Notes:"]
["-","Due to flat topography of the area, no major cut/fill works have been included for road"]
[]
["Landscaping"]
["1","No landscaping allowed for other than topsoiling and seeding"]
["Preliminaries"]
["2","Based on nominal rates"]
["Subsoil Drain"]
["3","Assume same as kerb and channel"]
["Side Entry Pits"]
["4","Based on 50 m intervals"]
["Tactile Pavers"]
["5","Assume hazard TGSI's (no directional)"]
["Signing"]
["6","Nominal rate"]
["Pavement"]
["7","Assume deep lift asphalt pavement "]
["Tree Removal"]
["8","Based on preliminary information/aerial photography"]
["Roads"]
["9","Where applicable, existing road conditions based on limited crushed rock roads assumed to be of no consequence to works"]
["10","Where applicable, existing asphalt roads to be demolished as part of intersection works"]
["Dry Stone Wall"]
["11","Dry stone wall works allowance has assumed the wall is not heritage listed and does not need to be reconstructed"]
["Lighting"]
["12","Based on 70 m intervals"]
["375 RCP"]
["13","Based on (road length + (No. of SEPs x 8.0m))"]
[]
["AUTHOR:","Graeme Stenton"]
["Date:","2014-12-18"]
[]
["REVIEWER:","Rob Henry"]
["Date:"," "]

{"sheet":"RD-02-T10","index":1,"n_rows":127,"n_cols":11,"rows_kept":127,"cut":false,"hidden":false,"merged":[[3,4,4,5],[117,1,117,6],[118,1,118,6],[119,1,119,6],[120,1,120,5]]}
["PRELIMINARY ESTIMATE OF DEVELOPMENT COSTS",null,null,null,null,null,{"$f":"Summary!A5","v":"2015-05-14"}]
[{"$f":"Summary!A3","v":"CG140690"},null,null,null,null,null,{"$f":"Summary!A6","v":"Version 4"}]
[{"$f":"Summary!A4","v":"Wollert PSP - Roads Cost Estimate"},null,"PM %:",9.0200000000000002E-2]
["Intersection Ref:",{"$f":"J7","v":"RD-02"},null,null,"DRAFT",null,null,null,"Do not Delete the below info"]
["Sheet Ref:",{"$f":"Summary!C9","v":"T10-02  & 03-P2"}]
["ITEM","DESCRIPTION","QUANTITY","UNIT","RATE ","AMOUNT","SUBTOTAL",null,"Sheet Specific Information","Input","Cell Reference"]
["A",{"$f":"Summary!B10","v":"Project and Program Management (%)"},null,null,null,null,{"$f":"SUM(F7:F14)","v":120901.98993714286},null,"Intersection Name","RD-02","A4"]
[null,"Project Management",null,0.03,{"$f":"($D$3/0.1)*D8","v":2.7060000000000001E-2},{"$f":"E8*$G$24","v":72541.193962285717},null,null,"Existing road directions","N-S","B87"]
[null,"Project scoping, planning, scheduling, monitoring, reporting and commissioning",null,null,null,null,null,null,"Previous Road area",0,"m²"]
[null,"Management of preconstruction activities, development of tender documents and management of contracts",null,null,null,null,null,null,"Total Roadway Area",3548,"m²"]
[null,"Managing external interfaces, including community liaison, environmental issues, traffic issues etc",null,null,null,null,null,null,"Island Area",0,"m²"]
[null,"Records management",null,null,null,null,null,null,"Kerb and Channel",530,"Lm"]
[null,"Program Administration",null,0.02,{"$f":"($D$3/0.1)*D13","v":1.804E-2},{"$f":"E13*$G$24","v":48360.795974857145},null,null,"Shoulder",530,"m²"]
[null,null,null,null,null,null,null,null,"Footpath Length",0,"Lm"]
["B",{"$f":"Summary!B11","v":"Design and Investigation (%)"},null,null,null,null,{"$f":"SUM(F15:F23)","v":241803.97987428572},null,"Pipe Length",null,"Lm"]
[null,"Traffic Investigations",null,8.5000000000000006E-3,{"$f":"($D$3/0.1)*D16","v":7.6670000000000011E-3},{"$f":"E16*$G$24","v":20553.338289314288},null,null,"Island Concrete infill",0,"m²"]
[null,"Cadastral and Engineering Survey",null,1.2E-2,1.0824E-2,29016.477584914286,null,null,"Shared Path Length",1060,"Lm"]
[null,"Geotechnical investigations Pavement Investigations and Design",null,1.2E-2,1.0824E-2,29016.477584914286,null,null,"Total Road Length",530,"Lm"]
[null,"Environmental Investigations",null,null,0,0]
[null,"Landscape Design",null,null,0,0]
[null,"Preliminary and Final Design",null,4.2500000000000003E-2,3.8335000000000001E-2,102766.69144657144]
[null,"Construction Management",null,2.5000000000000001E-2,2.2550000000000001E-2,60450.994968571431]
[null,null,null,null,null,null,null,null,"2.5% of construction cost",{"$f":"0.025*G24","v":67018.841428571424}]
["C","Construction",null,null,null,{"$f":"SUM(F25:F85)","v":2680753.6571428571},{"$f":"SUM(G25:G84)","v":2680753.6571428571}]
[1,"PRELIMINARIES",null,null,null,null,{"$f":"SUM(F25:F29)","v":156000}]
[1.1000000000000001,"Site establishment",1,"Item",10000,{"$f":"E26*C26","v":10000}]
[1.2,"Site management & supervision including QA",20,"wks",2500,{"$f":"SUM(E27*C27)","v":50000}]
[1.3,"Provision for traffic",1,"Item",{"$f":"C27*6*800","v":96000},{"$f":"SUM(E28*C28)","v":96000}]
[2,"DEMOLITION",null,null,null,null,{"$f":"SUM(F29:F32)","v":0},null,null,null,"  "]
["2.1","Trees",0,"No",500,{"$f":"SUM(E30*C30)","v":0}]
["2.2","Strip asphalt from existing pavement",{"$f":"J9","v":0},"m²",5,{"$f":"SUM(E31*C31)","v":0}]
[3,"EARTHWORKS",null,null,null,null,{"$f":"SUM(F32:F39)","v":317377.3}]
[3.1,"Stripping topsoil (150mm)",{"$f":"J10+J12*1+J13*1.3-J11-J9","v":4767},"m²",6,{"$f":"SUM(E33*C33)","v":28602}]
[3.2,"Excavation and removal (inc. reclamation of FCR)",{"$f":"C41*0.18","v":667.26},"m³",30,{"$f":"SUM(E34*C34)","v":20017.8}]
[3.3,"Filling",{"$f":"C41*0.71","v":2631.97},"m³",15,{"$f":"C35*E35","v":39479.549999999996}]
["3.4","Import Fill material ",{"$f":"C35-C34","v":1964.7099999999998},"m³",45,{"$f":"C36*E36","v":88411.95}]
["3.5","Soft spot rectification (reclaimed FCR)",{"$f":"C41*20%","v":741.40000000000009},"m³",15,{"$f":"SUM(E37*C37)","v":11121.000000000002}]
["3.6","Rock excavation & sub-surface remediation 450mm",{"$f":"C41*50%","v":1853.5},"m²",{"$f":"55+15","v":70},{"$f":"SUM(E38*C38)","v":129745}]
[4,"PAVEMENT "," ",null,null,null,{"$f":"SUM(F39:F43)","v":597625}]
[4.0999999999999996,"Deep lift asphalt 195 mm ",{"$f":"J10-J13-J11","v":3018},"m²",{"$f":"IF(C40<15000,105,85)","v":105},{"$f":"SUM(E40*C40)","v":316890}]
[4.2,"Subbase course - 250 mm 3% CTCR",{"$f":"C40+(J12*1)+C42*0.3","v":3707},"m²",{"$f":"IF(C41<15000,55,45)","v":55},{"$f":"SUM(E41*C41)","v":203885}]
["4.3","Shoulder - full depth pavement",{"$f":"J13","v":530},"m²",145,{"$f":"SUM(E42*C42)","v":76850}]
["5","DRAINAGE"," ",null,null,null,{"$f":"SUM(F43:F48)","v":162816}]
[5.0999999999999996,"Subsoil drains 100mm dia - screenings",{"$f":"J12+J13","v":1060},"Lm",30,{"$f":"SUM(E44*C44)","v":31800}]
[5.2,"Subsoil drains 100mm dia - no fines conc",0,"Lm",45,{"$f":"SUM(E45*C45)","v":0}]
[5.3,"375 RCP (class 2)",{"$f":"J18+(C47*8)","v":614.79999999999995},"Lm",170,{"$f":"SUM(E46*C46)","v":104515.99999999999}]
["5.4","Side entry pits",{"$f":"J12/50","v":10.6},"No",2500,{"$f":"SUM(E47*C47)","v":26500}]
["5.5","Allowance to modify draiange to ultimate location",null,"item",{"$f":"14*(2500+2000+10*E46)","v":86800},{"$f":"SUM(E48*C48)","v":0}]
[6,"CONCRETE WORKS"," ",null,null,null,{"$f":"SUM(F49:F54)","v":164300}]
[6.1,"Kerb &channel",{"$f":"J12","v":530},"Lm",50,{"$f":"SUM(E50*C50)","v":26500}]
[6.2,"Shared Paths (3.0m wide,125 mm, residential, as per MPA)",{"$f":"J17","v":1060},"Lm",130,137800]
[6.3,"Footpaths (1.5m wide,125 mm, residential, as per MPA)",{"$f":"J14","v":0},"No",65,0]
[6.4,"Laybacks and tactile pavers",0,"m²",1200,0]
[6.5,"10m concrete  maintenance area end of all islands",{"$f":"J16","v":0},"m²",85,0]
["7","TRAFFIC SIGNAL WORKS",null,"NA",null,null,{"$f":"SUM(F55:F55)","v":0}]
["8","SIGNAL MAINTENANCE (10 YEARS) by Road Authority",null,"NA",null,{"$f":"SUM(E56*C56)","v":0},{"$f":"F56","v":0}]
["9","POWER & LIGHTING",null,null,null,null,{"$f":"SUM(F58:F63)","v":122892.85714285714}]
["9.1","Light pole (1-way) and luminous lights",0,"No",8000,0]
["9.2","Light pole (2-way) and luminous lights",{"$f":"J18/70","v":7.5714285714285712},"No",9000,68142.857142857145]
["9.3","JUP lighting single",0,"No",4000,0]
["9.4","JUP lighting dual",0,"No",5000,0]
["9.5","Cabling, conduits and pits",{"$f":"J18","v":530},"Lm",75,39750]
["9.6","Electrical connection",1,"Item",15000,15000]
["10","LANDSCAPING WORKS",null,null,null,null,{"$f":"SUM(F64:F66)","v":83342.5}]
["10.1","Topsoiling seeding",{"$f":"SUM(J13,J17)*6+J12*0.5+J11-J16","v":9805},"m²",8.5,{"$f":"SUM(E65*C65)","v":83342.5}]
["10.2","Landcape planting",0,"NA"]
["11","SIGNING",1,"item",10000,10000,{"$f":"F67","v":10000}]
["12","LINEMARKING (Thermoplastic)",1,"item",30000,30000,{"$f":"F68","v":30000}]
["13","SERVICES",null,null,null,null,{"$f":"SUM(F69:F77)","v":1036400}]
["13.1","Water supply main, 300 mm",{"$f":"$J$18","v":530},"Lm",350,{"$f":"SUM(E70*C70)","v":185500}]
["13.2","Gas supply main 150 mm",{"$f":"$J$18","v":530},"Lm",180,{"$f":"SUM(E71*C71)","v":95400}]
["13.3","Telco Pit and Pipe (Assume 3x100mm)",530,"Lm",120,{"$f":"SUM(E72*C72)","v":63600}]
["13.4","Sewer main 300 mm (Assume Gravity + FCR Backfill)",530,"Lm",450,238500]
["13.5","UG electrical (HV + LV)",530,"Lm",300,{"$f":"SUM(E74*C74)","v":159000}]
["13.6","Water supply main (RECYCLED), 300 mm",530,"Lm",350,{"$f":"SUM(E75*C75)","v":185500}]
["13.7","Transmission pipleline slab protection 200mm",{"$f":"330*2","v":660},"m²",165,{"$f":"C76*E76","v":108900}]
["13.8","(Overhead electrical) No allowance",0,"Lm",null,{"$f":"SUM(E77*C77)","v":0}]
["14","MISCELLANEOUS ",null,null,null,null,{"$f":"SUM(F78:F83)","v":0}]
[null,"Exisiting Road outside of new road pavements"]
["14.1","Strip asphalt",{"$f":"J9","v":0},"m²",5,{"$f":"SUM(E80*C80)","v":0}]
["14.2","Recycle FCR to stockpile",{"$f":"C80*0.3","v":0},"m³",10,{"$f":"SUM(E81*C81)","v":0}]
["14.3","backfill with structural fill",{"$f":"C80*0.5","v":0},"m³",12,{"$f":"SUM(E82*C82)","v":0}]
["14.4","Topsoiling",{"$f":"C80","v":0},"m²",8.5,{"$f":"SUM(E83*C83)","v":0}]
["15","PROVISIONAL SUM - DAYWORK",null,"item",null,{"$f":"SUM(E84*C84)","v":0},{"$f":"F84","v":0}]
[]
[null,"TOTAL A - C",null,null,null,{"$f":"SUM(F25:F85,F7:F23)","v":3043459.6269542859},{"$f":"SUM(G24+G15+G7)","v":3043459.6269542859}]
[]
["D","Contingency"]
[null,{"$f":"Summary!B17","v":"Contingency (15% of C)"},null,null,null,0.15,{"$f":"F89*G24","v":402113.04857142858}]
[]
["E","PROJECT BUDGET"]
[null,"Total Estimate",null,null,null,null,{"$f":"G89+G86","v":3445572.6755257146}]
[null,"Total Estimate per linear metre",null,null,null,null,{"$f":"G92/J18","v":6501.0805198598391}]
[]
["Notes:"]
["-","Koukoura Road earthworks based on a concept vertical grade alignment"]
[]
["Services"]
["1"," Basic supply infrastructure has been included  for Gas, Telco, Sewer, Water, U/G HV & LV elect  have been incorporated for the road sections"]
["2","No allowance for water, gas, telstra, sewer"]
["Substations"]
["3","No allowance for substations"]
["Preliminaries"]
["4","Based on nominal rates"]
["Subsoil Drain"]
["5","Assume same as kerb and channel"]
["Side Entry Pits"]
["6","Based on 50 m intervals"]
["Tactile Pavers"]
["7","Assume hazard TGSI's (no directional)"]
["Signing"]
["8","Nominal rate"]
["Pavement"]
["9","Assume deep lift asphalt pavement "]
["Tree Removal"]
["10","Based on preliminary information"]
["Roads"]
["11","Where applicable, existing asphalt roads to be demolished as part of intersection works"]
[]
[]
[]
[]
["AUTHOR:","Graeme Stenton"]
["Date:","2014-12-16"]
[]
["REVIEWER:","Rob Henry"]
["Date:"," "]

{"sheet":"RD-03-T10","index":2,"n_rows":126,"n_cols":11,"rows_kept":126,"cut":false,"hidden":false,"merged":[[3,4,4,5],[116,1,116,6],[117,1,117,6],[118,1,118,6],[119,1,119,5]]}
["PRELIMINARY ESTIMATE OF DEVELOPMENT COSTS",null,null,null,null,null,{"$f":"Summary!A5","v":"2015-05-14"}]
[{"$f":"Summary!A3","v":"CG140690"},null,null,null,null,null,{"$f":"Summary!A6","v":"Version 4"}]
[{"$f":"Summary!A4","v":"Wollert PSP - Roads Cost Estimate"},null,"PM %:",8.48E-2]
["Intersection Ref:",{"$f":"J7","v":"RD-03"},null,null,"DRAFT",null,null,null,"Do not Delete the below info"]
["Sheet Ref:",{"$f":"Summary!D9","v":"T10-03 & 04-P2"}]
["ITEM","DESCRIPTION","QUANTITY","UNIT","RATE ","AMOUNT","SUBTOTAL",null,"Sheet Specific Information","Input","Cell Reference"]
["A",{"$f":"Summary!B10","v":"Project and Program Management (%)"},null,null,null,null,{"$f":"SUM(F7:F14)","v":186694.11792342854},null,"Intersection Name","RD-03","A4"]
[null,"Project Management",null,0.03,{"$f":"($D$3/0.1)*D8","v":2.5439999999999997E-2},{"$f":"E8*$G$24","v":112016.47075405713},null,null,"Existing road directions","N-S","B87"]
[null,"Project scoping, planning, scheduling, monitoring, reporting and commissioning",null,null,null,null,null,null,"Previous Road area",0,"m²"]
[null,"Management of preconstruction activities, development of tender documents and management of contracts",null,null,null,null,null,null,"Total Roadway Area",6299,"m²"]
[null,"Managing external interfaces, including community liaison, environmental issues, traffic issues etc",null,null,null,null,null,null,"Island Area",0,"m²"]
[null,"Records management",null,null,null,null,null,null,"Kerb and Channel",895,"Lm"]
[null,"Program Administration",null,0.02,{"$f":"($D$3/0.1)*D13","v":1.6959999999999999E-2},{"$f":"E13*$G$24","v":74677.647169371427},null,null,"Shoulder",894,"m²"]
[null,null,null,null,null,null,null,null,"Footpath Length",0,"Lm"]
["B",{"$f":"Summary!B11","v":"Design and Investigation (%)"},null,null,null,null,{"$f":"SUM(F15:F23)","v":373388.23584685713},null,"Pipe Length",null,"Lm"]
[null,"Traffic Investigations",null,8.5000000000000006E-3,{"$f":"($D$3/0.1)*D16","v":7.208E-3},{"$f":"E16*$G$24","v":31738.000046982859},null,null,"Island Concrete infill",0,"m²"]
[null,"Cadastral and Engineering Survey",null,1.2E-2,1.0175999999999999E-2,44806.588301622854,null,null,"Shared Path Length",1785,"Lm"]
[null,"Geotechnical investigations Pavement Investigations and Design",null,1.2E-2,1.0175999999999999E-2,44806.588301622854,null,null,"Total Road Length",895,"Lm"]
[null,"Environmental Investigations",null,null,0,0]
[null,"Landscape Design",null,null,0,0]
[null,"Preliminary and Final Design",null,4.2500000000000003E-2,3.6040000000000003E-2,158690.0002349143]
[null,"Construction Management",null,2.5000000000000001E-2,2.12E-2,93347.058961714283]
[null,null,null,null,null,null,null,null,"2.5% of construction cost",{"$f":"0.025*G24","v":110079.07896428573}]
["C","Construction",null,null,null,{"$f":"SUM(F25:F84)","v":4403163.1585714286},{"$f":"SUM(G25:G83)","v":4403163.1585714286}]
[1,"PRELIMINARIES",null,null,null,null,{"$f":"SUM(F25:F28)","v":156000}]
[1.1000000000000001,"Site establishment",1,"Item",10000,{"$f":"E26*C26","v":10000}]
[1.2,"Site management & supervision including QA",20,"wks",2500,{"$f":"SUM(E27*C27)","v":50000}]
[1.3,"Provision for traffic",1,"Item",{"$f":"C27*6*800","v":96000},{"$f":"SUM(E28*C28)","v":96000}]
[2,"DEMOLITION",null,null,null,null,{"$f":"SUM(F29:F32)","v":0},null,null,null,"  "]
["2.1","Trees",0,"No",500,{"$f":"SUM(E30*C30)","v":0}]
["2.2","Strip asphalt from existing pavement",{"$f":"J9","v":0},"m²",5,{"$f":"SUM(E31*C31)","v":0}]
[3,"EARTHWORKS",null,null,null,null,{"$f":"SUM(F32:F38)","v":331912.98}]
[3.1,"Stripping topsoil (150mm)",{"$f":"J10+J12*1+J13*1.3-J11-J9","v":8356.2000000000007},"m²",6,{"$f":"SUM(E33*C33)","v":50137.200000000004}]
[3.2,"Excavation and removal (inc. reclamation of FCR)",{"$f":"C40*0.18","v":1182.2759999999998},"m³",30,{"$f":"SUM(E34*C34)","v":35468.28}]
[3.3,"Filling",{"$f":"C40*0.71","v":4663.4219999999996},"m³",15,{"$f":"C35*E35","v":69951.329999999987}]
["3.4","Import Fill material ",{"$f":"C35-C34","v":3481.1459999999997},"m³",45,{"$f":"C36*E36","v":156651.56999999998}]
[3.3,"Soft spot rectification (reclaimed FCR)",{"$f":"C40*20%","v":1313.64},"m³",15,{"$f":"SUM(E37*C37)","v":19704.600000000002}]
[4,"PAVEMENT "," ",null,null,null,{"$f":"SUM(F38:F42)","v":1419657}]
[4.0999999999999996,"Deep lift asphalt 195 mm ",{"$f":"J10-J13-J11","v":5405},"m²",{"$f":"IF(C39<15000,105,85)","v":105},{"$f":"SUM(E39*C39)","v":567525}]
[4.2,"Subbase course - 250 mm 3% CTCR",{"$f":"C39+(J12*1)+C41*0.3","v":6568.2},"m²",{"$f":"IF(C40<15000,55,45)","v":55},{"$f":"SUM(E40*C40)","v":361251}]
["4.3","Shoulder - full depth pavement",{"$f":"J13","v":894},"m²",145,{"$f":"SUM(E41*C41)","v":129630}]
["4.4","Rock excavation & sub-surface remediation 450mm",{"$f":"C40","v":6568.2},"m²",55,{"$f":"SUM(E42*C42)","v":361251}]
["5","DRAINAGE"," ",null,null,null,{"$f":"SUM(F43:F48)","v":274914}]
[5.0999999999999996,"Subsoil drains 100mm dia - screenings",{"$f":"J12+J13","v":1789},"Lm",30,{"$f":"SUM(E44*C44)","v":53670}]
[5.2,"Subsoil drains 100mm dia - no fines conc",0,"Lm",45,0]
[5.3,"375 RCP (class 2)",{"$f":"J18+(C47*8)","v":1038.2},"Lm",170,176494]
["5.4","Side entry pits",{"$f":"J12/50","v":17.899999999999999},"No",2500,44750]
["5.5","Allowance to modify draiange to ultimate location",null,"item",{"$f":"14*(2500+2000+10*E46)","v":86800},0]
["6.6","Transmission pipleline slab protection 200mm",0,"m",130,0]
[6,"CONCRETE WORKS"," ",null,null,null,{"$f":"SUM(F50:F55)","v":276800}]
[6.1,"Kerb &channel",{"$f":"J12","v":895},"Lm",50,{"$f":"SUM(E51*C51)","v":44750}]
[6.2,"Shared Paths (3.0m wide,125 mm, residential, as per MPA)",{"$f":"J17","v":1785},"Lm",130,{"$f":"SUM(E52*C52)","v":232050}]
[6.3,"Footpaths (1.5m wide,125 mm, residential, as per MPA)",{"$f":"J14","v":0},"No",65,{"$f":"SUM(E53*C53)","v":0}]
[6.4,"Laybacks and tactile pavers",0,"m²",1200,{"$f":"SUM(E54*C54)","v":0}]
[6.5,"10m concrete  maintenance area end of all islands",{"$f":"J16","v":0},"m²",85,{"$f":"SUM(E55*C55)","v":0}]
["7","TRAFFIC SIGNAL WORKS",null,"NA",null,null,{"$f":"SUM(F56:F56)","v":0}]
["8","SIGNAL MAINTENANCE (10 YEARS) by Road Authority",null,"NA",null,{"$f":"SUM(E57*C57)","v":0},{"$f":"F57","v":0}]
["9","POWER & LIGHTING",null,null,null,null,{"$f":"SUM(F59:F64)","v":197196.42857142858}]
["9.1","Light pole (1-way) and luminous lights",0,"No",8000,0]
["9.2","Light pole (2-way) and luminous lights",{"$f":"J18/70","v":12.785714285714286},"No",9000,115071.42857142858]
["9.3","JUP lighting single",0,"No",4000,0]
["9.4","JUP lighting dual",0,"No",5000,0]
["9.5","Cabling, conduits and pits",{"$f":"J18","v":895},"Lm",75,67125]
["9.6","Electrical connection",1,"Item",15000,15000]
["10","LANDSCAPING WORKS",null,null,null,null,{"$f":"SUM(F65:F66)","v":140432.75}]
["10.1","Topsoiling seeding",{"$f":"SUM(J13,J17)*6+J12*0.5+J11-J16","v":16521.5},"m²",8.5,{"$f":"SUM(E66*C66)","v":140432.75}]
["11","SIGNING",1,"item",10000,10000,{"$f":"F67","v":10000}]
["12","LINEMARKING (Thermoplastic)",1,"item",30000,30000,{"$f":"F68","v":30000}]
["13","SERVICE RELOCATION",null,null,null,null,{"$f":"SUM(F69:F76)","v":1566250}]
["13.1","Water supply main, 300 mm",{"$f":"$J$18","v":895},"Lm",350,{"$f":"SUM(E70*C70)","v":313250}]
["13.2","Gas supply main 150 mm",{"$f":"$J$18","v":895},"Lm",180,{"$f":"SUM(E71*C71)","v":161100}]
["13.3","Telco Pit and Pipe (Assume 3x100mm)",895,"Lm",120,{"$f":"SUM(E72*C72)","v":107400}]
["13.4","Sewer main 300 mm (Assume Gravity + FCR Backfill)",895,"Lm",450,402750]
["13.5","UG electrical (HV + LV)",895,"Lm",300,{"$f":"SUM(E74*C74)","v":268500}]
["13.6","Water supply main (RECYCLED), 300 mm",895,"Lm",350,{"$f":"SUM(E75*C75)","v":313250}]
["13.7","(Overhead electrical) No allowance",0,"Lm",null,{"$f":"SUM(E76*C76)","v":0}]
["14","MISCELLANEOUS ",null,null,null,null,{"$f":"SUM(F77:F82)","v":0}]
[null,"Exisiting Road outside of new road pavements"]
["14.1","Strip asphalt",{"$f":"J9","v":0},"m²",5,{"$f":"SUM(E79*C79)","v":0}]
["14.2","Recycle FCR to stockpile",{"$f":"C79*0.3","v":0},"m³",10,{"$f":"SUM(E80*C80)","v":0}]
["14.3","backfill with structural fill",{"$f":"C79*0.5","v":0},"m³",12,{"$f":"SUM(E81*C81)","v":0}]
["14.4","Topsoiling",{"$f":"C79","v":0},"m²",8.5,{"$f":"SUM(E82*C82)","v":0}]
["15","PROVISIONAL SUM - DAYWORK",null,"item",null,0,{"$f":"F83","v":0}]
[]
[null,"TOTAL A - C",null,null,null,{"$f":"SUM(F25:F84,F7:F23)","v":4963245.5123417145},{"$f":"SUM(G24+G15+G7)","v":4963245.5123417145}]
[]
["D","Contingency"]
[null,{"$f":"Summary!B17","v":"Contingency (15% of C)"},null,null,null,0.15,{"$f":"F88*G24","v":660474.47378571425}]
[]
["E","PROJECT BUDGET"]
[null,"Total Estimate",null,null,null,null,{"$f":"G88+G85","v":5623719.9861274287}]
[null,"Total Estimate per linear metre",null,null,null,null,{"$f":"G91/J18","v":6283.4860180194737}]
[]
["Notes:"]
["-","Koukoura Road earthworks based on a concept vertical grade alignment"]
[]
["Services"]
["1"," Basic supply infrastructure has been included  for Gas, Telco, Sewer, Water, U/G HV & LV elect  have been incorporated for the road sections"]
["2","No allowance for water, gas, telstra, sewer"]
["Substations"]
["3","No allowance for substations"]
["Preliminaries"]
["4","Based on nominal rates"]
["Subsoil Drain"]
["5","Assume same as kerb and channel"]
["Side Entry Pits"]
["6","Based on 50 m intervals"]
["Tactile Pavers"]
["7","Assume hazard TGSI's (no directional)"]
["Signing"]
["8","Nominal rate"]
["Pavement"]
["9","Assume deep lift asphalt pavement "]
["Tree Removal"]
["10","Based on preliminary information"]
["Roads"]
["11","Where applicable, existing asphalt roads to be demolished as part of intersection works"]
[]
[]
[]
[]
["AUTHOR:","Graeme Stenton"]
["Date:","2014-12-16"]
[]
["REVIEWER:","Rob Henry"]
["Date:"," "]

{"sheet":"RD-04-T10","index":3,"n_rows":125,"n_cols":11,"rows_kept":125,"cut":false,"hidden":false,"merged":[[3,4,4,5],[115,1,115,6],[116,1,116,6],[117,1,117,6],[118,1,118,5]]}
["PRELIMINARY ESTIMATE OF DEVELOPMENT COSTS",null,null,null,null,null,{"$f":"Summary!A5","v":"2015-05-14"}]
[{"$f":"Summary!A3","v":"CG140690"},null,null,null,null,null,{"$f":"Summary!A6","v":"Version 4"}]
[{"$f":"Summary!A4","v":"Wollert PSP - Roads Cost Estimate"},null,"PM %:",8.6499999999999994E-2]
["Intersection Ref:",{"$f":"J7","v":"RD-04"},null,null,"DRAFT",null,null,null,"Do not Delete the below info"]
["Sheet Ref:",{"$f":"Summary!E9","v":"T10-04 & 05-P2"}]
["ITEM","DESCRIPTION","QUANTITY","UNIT","RATE ","AMOUNT","SUBTOTAL",null,"Sheet Specific Information","Input","Cell Reference"]
["A",{"$f":"Summary!B10","v":"Project and Program Management (%)"},null,null,null,null,{"$f":"SUM(F7:F14)","v":161831.73050464282},null,"Intersection Name","RD-04","A4"]
[null,"Project Management",null,0.03,{"$f":"($D$3/0.1)*D8","v":2.5949999999999994E-2},{"$f":"E8*$G$24","v":97099.038302785688},null,null,"Existing road directions","N-S","B87"]
[null,"Project scoping, planning, scheduling, monitoring, reporting and commissioning",null,null,null,null,null,null,"Previous Road area",0,"m²"]
[null,"Management of preconstruction activities, development of tender documents and management of contracts",null,null,null,null,null,null,"Total Roadway Area",5129,"m²"]
[null,"Managing external interfaces, including community liaison, environmental issues, traffic issues etc",null,null,null,null,null,null,"Island Area",0,"m²"]
[null,"Records management",null,null,null,null,null,null,"Kerb and Channel",767,"Lm"]
[null,"Program Administration",null,0.02,{"$f":"($D$3/0.1)*D13","v":1.7299999999999999E-2},{"$f":"E13*$G$24","v":64732.692201857135},null,null,"Shoulder",764,"m²"]
[null,null,null,null,null,null,null,null,"Footpath Length",0,"Lm"]
["B",{"$f":"Summary!B11","v":"Design and Investigation (%)"},null,null,null,null,{"$f":"SUM(F15:F23)","v":323663.46100928565},null,"Pipe Length",null,"Lm"]
[null,"Traffic Investigations",null,8.5000000000000006E-3,{"$f":"($D$3/0.1)*D16","v":7.3524999999999997E-3},{"$f":"E16*$G$24","v":27511.394185789282},null,null,"Island Concrete infill",0,"m²"]
[null,"Cadastral and Engineering Survey",null,1.2E-2,1.0379999999999999E-2,38839.615321114281,null,null,"Shared Path Length",1531,"Lm"]
[null,"Geotechnical investigations Pavement Investigations and Design",null,1.2E-2,1.0379999999999999E-2,38839.615321114281,null,null,"Total Road Length",767,"Lm"]
[null,"Environmental Investigations",null,null,0,0]
[null,"Landscape Design",null,null,0,0]
[null,"Preliminary and Final Design",null,4.2500000000000003E-2,3.6762499999999997E-2,137556.97092894642]
[null,"Construction Management",null,2.5000000000000001E-2,2.1624999999999998E-2,80915.865252321411]
[null,null,null,null,null,null,null,null,"2.5% of construction cost",{"$f":"0.025*G24","v":93544.352892857147}]
["C","Construction",null,null,null,{"$f":"SUM(F25:F83)","v":3741774.1157142855},{"$f":"SUM(G25:G82)","v":3741774.1157142855}]
[1,"PRELIMINARIES",null,null,null,null,{"$f":"SUM(F25:F28)","v":156000}]
[1.1000000000000001,"Site establishment",1,"Item",10000,{"$f":"E26*C26","v":10000}]
[1.2,"Site management & supervision including QA",20,"wks",2500,{"$f":"SUM(E27*C27)","v":50000}]
[1.3,"Provision for traffic",1,"Item",{"$f":"C27*6*800","v":96000},{"$f":"SUM(E28*C28)","v":96000}]
[2,"DEMOLITION",null,null,null,null,{"$f":"SUM(F29:F32)","v":2500},null,null,null,"  "]
["2.1","Trees",5,"No",500,{"$f":"SUM(E30*C30)","v":2500}]
["2.2","Strip asphalt from existing pavement",{"$f":"J9","v":0},"m²",5,{"$f":"SUM(E31*C31)","v":0}]
[3,"EARTHWORKS",null,null,null,null,{"$f":"SUM(F32:F38)","v":271330.67999999993}]
[3.1,"Stripping topsoil (150mm)",{"$f":"J10+J12*1+J13*1.3-J11-J9","v":6889.2},"m²",6,{"$f":"SUM(E33*C33)","v":41335.199999999997}]
[3.2,"Excavation and removal (inc. reclamation of FCR)",{"$f":"C40*0.18","v":965.01599999999996},"m³",30,{"$f":"SUM(E34*C34)","v":28950.48}]
[3.3,"Filling",{"$f":"C40*0.71","v":3806.4519999999998},"m³",15,{"$f":"C35*E35","v":57096.78}]
["3.4","Import Fill material ",{"$f":"C35-C34","v":2841.4359999999997},"m³",45,{"$f":"C36*E36","v":127864.61999999998}]
["3.5","Soft spot rectification (reclaimed FCR)",{"$f":"C40*20%","v":1072.24},"m³",15,{"$f":"SUM(E37*C37)","v":16083.6}]
[4,"PAVEMENT "," ",null,null,null,{"$f":"SUM(F38:F42)","v":1158837}]
[4.0999999999999996,"Deep lift asphalt 195 mm ",{"$f":"J10-J13-J11","v":4365},"m²",{"$f":"IF(C39<15000,105,85)","v":105},{"$f":"SUM(E39*C39)","v":458325}]
[4.2,"Subbase course - 250 mm 3% CTCR",{"$f":"C39+(J12*1)+C41*0.3","v":5361.2},"m²",{"$f":"IF(C40<15000,55,45)","v":55},{"$f":"SUM(E40*C40)","v":294866}]
["4.3","Shoulder - full depth pavement",{"$f":"J13","v":764},"m²",145,{"$f":"SUM(E41*C41)","v":110780}]
["4.4","Rock excavation & sub-surface remediation 450mm",{"$f":"C40","v":5361.2},"m²",55,{"$f":"SUM(E42*C42)","v":294866}]
["5","DRAINAGE"," ",null,null,null,{"$f":"SUM(F43:F48)","v":235532.4}]
[5.0999999999999996,"Subsoil drains 100mm dia - screenings",{"$f":"J12+J13","v":1531},"Lm",30,{"$f":"SUM(E44*C44)","v":45930}]
[5.2,"Subsoil drains 100mm dia - no fines conc",0,"Lm",45,{"$f":"SUM(E45*C45)","v":0}]
[5.3,"375 RCP (class 2)",{"$f":"J18+(C47*8)","v":889.72},"Lm",170,{"$f":"SUM(E46*C46)","v":151252.4}]
["5.4","Side entry pits",{"$f":"J12/50","v":15.34},"No",2500,{"$f":"SUM(E47*C47)","v":38350}]
["5.5","Allowance to modify draiange to ultimate location",null,"item",{"$f":"14*(2500+2000+10*E46)","v":86800},{"$f":"SUM(E48*C48)","v":0}]
[6,"CONCRETE WORKS"," ",null,null,null,{"$f":"SUM(F49:F55)","v":243880}]
[6.1,"Kerb &channel",{"$f":"J12","v":767},"Lm",50,{"$f":"SUM(E50*C50)","v":38350}]
[6.2,"Shared Paths (3.0m wide,125 mm, residential, as per MPA)",{"$f":"J17","v":1531},"Lm",130,199030]
[6.3,"Footpaths (1.5m wide,125 mm, residential, as per MPA)",{"$f":"J14","v":0},"No",65,0]
[6.4,"Laybacks and tactile pavers",0,"m²",1200,0]
[6.5,"10m concrete  maintenance area end of all islands",{"$f":"J16","v":0},"m²",85,0]
["6.6","Transmission pipleline slab protection 200mm",50,"m",130,6500]
["7","TRAFFIC SIGNAL WORKS",null,"NA",null,null,{"$f":"SUM(F56:F56)","v":0}]
["8","SIGNAL MAINTENANCE (10 YEARS) by Road Authority",null,"NA",null,null,{"$f":"F57","v":0}]
["9","POWER & LIGHTING",null,null,null,null,{"$f":"SUM(F59:F64)","v":171139.28571428571}]
["9.1","Light pole (1-way) and luminous lights",0,"NA",null,{"$f":"SUM(E59*C59)","v":0}]
["9.2","Light pole (2-way) and luminous lights",{"$f":"J18/70","v":10.957142857142857},"No",9000,{"$f":"SUM(E60*C60)","v":98614.28571428571}]
["9.3","JUP lighting single",0,"No",4000,{"$f":"SUM(E61*C61)","v":0}]
["9.4","JUP lighting dual",0,"No",5000,0]
["9.5","Cabling, conduits and pits",{"$f":"J18","v":767},"Lm",75,57525]
["9.6","Electrical connection",1,"Item",15000,15000]
["10","LANDSCAPING WORKS",null,null,null,null,{"$f":"SUM(F65:F66)","v":120304.75}]
["10.1","Topsoiling seeding",{"$f":"SUM(J13,J17)*6+J12*0.5+J11-J16","v":14153.5},"m²",8.5,{"$f":"SUM(E66*C66)","v":120304.75}]
["11","SIGNING",1,"item",10000,10000,{"$f":"F67","v":10000}]
["12","LINEMARKING (Thermoplastic)",1,"item",30000,30000,{"$f":"F68","v":30000}]
["13","SERVICE RELOCATION",null,null,null,null,{"$f":"SUM(F69:F76)","v":1342250}]
["13.1","Water supply main, 300 mm",{"$f":"$J$18","v":767},"Lm",350,{"$f":"SUM(E70*C70)","v":268450}]
["13.2","Gas supply main 150 mm",{"$f":"$J$18","v":767},"Lm",180,{"$f":"SUM(E71*C71)","v":138060}]
["13.3","Telco Pit and Pipe (Assume 3x100mm)",767,"Lm",120,{"$f":"SUM(E72*C72)","v":92040}]
["13.4","Sewer main 300 mm (Assume Gravity + FCR Backfill)",767,"Lm",450,345150]
["13.5","UG electrical (HV + LV)",767,"Lm",300,{"$f":"SUM(E74*C74)","v":230100}]
["13.6","Water supply main (RECYCLED), 300 mm",767,"Lm",350,{"$f":"SUM(E75*C75)","v":268450}]
["13.7","(Overhead electrical) No allowance",0,"Item",0,{"$f":"SUM(E76*C76)","v":0}]
["14","MISCELLANEOUS ",null,null,null,null,{"$f":"SUM(F77:F81)","v":0}]
[null,"Exisiting Road outside of new road pavements"]
["14.1","Strip asphalt",{"$f":"J9","v":0},"m²",5,{"$f":"SUM(E79*C79)","v":0}]
["14.2","Recycle FCR to stockpile",{"$f":"C79*0.3","v":0},"m³",10,{"$f":"SUM(E80*C80)","v":0}]
["14.3","backfill with structural fill",{"$f":"C79*0.5","v":0},"m³",12,{"$f":"SUM(E81*C81)","v":0}]
["15","PROVISIONAL SUM - DAYWORK",null,"item",null,{"$f":"SUM(E82*C82)","v":0},{"$f":"F82","v":0}]
[]
[null,"TOTAL A - C",null,null,null,{"$f":"SUM(F25:F83,F7:F23)","v":4227269.3072282141},{"$f":"SUM(G24+G15+G7)","v":4227269.3072282141}]
[]
["D","Contingency"]
[null,{"$f":"Summary!B17","v":"Contingency (15% of C)"},null,null,null,0.15,{"$f":"F87*G24","v":561266.11735714285}]
[]
["E","PROJECT BUDGET"]
[null,"Total Estimate",null,null,null,null,{"$f":"G87+G84","v":4788535.4245853573}]
[null,"Total Estimate per linear metre",null,null,null,null,{"$f":"G90/J18","v":6243.2013358348859}]
[]
["Notes:"]
["-","Koukoura Road earthworks based on a concept vertical grade alignment"]
[]
["Services"]
["1"," Basic supply infrastructure has been included  for Gas, Telco, Sewer, Water, U/G HV & LV elect  have been incorporated for the road sections"]
["2","No allowance for water, gas, telstra, sewer"]
["Substations"]
["3","No allowance for substations"]
["Preliminaries"]
["4","Based on nominal rates"]
["Subsoil Drain"]
["5","Assume same as kerb and channel"]
["Side Entry Pits"]
["6","Based on 50 m intervals"]
["Tactile Pavers"]
["7","Assume hazard TGSI's (no directional)"]
["Signing"]
["8","Nominal rate"]
["Pavement"]
["9","Assume deep lift asphalt pavement "]
["Tree Removal"]
["10","Based on preliminary information"]
["Roads"]
["11","Where applicable, existing asphalt roads to be demolished as part of intersection works"]
[]
[]
[]
[]
["AUTHOR:","Graeme Stenton"]
["Date:","2014-12-16"]
[]
["REVIEWER:","Rob Henry"]
["Date:"," "]

{"sheet":"RD-05-T10","index":4,"n_rows":126,"n_cols":11,"rows_kept":126,"cut":false,"hidden":false,"merged":[[3,4,4,5],[116,1,116,6],[117,1,117,6],[118,1,118,6],[119,1,119,5]]}
["PRELIMINARY ESTIMATE OF DEVELOPMENT COSTS",null,null,null,null,null,{"$f":"Summary!A5","v":"2015-05-14"}]
[{"$f":"Summary!A3","v":"CG140690"},null,null,null,null,null,{"$f":"Summary!A6","v":"Version 4"}]
[{"$f":"Summary!A4","v":"Wollert PSP - Roads Cost Estimate"},null,"PM %:",8.4199999999999997E-2]
["Intersection Ref:",{"$f":"J7","v":"RD-05"},null,null,"DRAFT",null,null,null,"Do not Delete the below info"]
["Sheet Ref:",{"$f":"Summary!F9","v":"T10-06 & 07-P2"}]
["ITEM","DESCRIPTION","QUANTITY","UNIT","RATE ","AMOUNT","SUBTOTAL",null,"Sheet Specific Information","Input","Cell Reference"]
["A",{"$f":"Summary!B10","v":"Project and Program Management (%)"},null,null,null,null,{"$f":"SUM(F7:F14)","v":194967.77491371427},null,"Intersection Name","RD-05","A4"]
[null,"Project Management",null,0.03,{"$f":"($D$3/0.1)*D8","v":2.5259999999999998E-2},{"$f":"E8*$G$24","v":116980.66494822856},null,null,"Existing road directions","E-W","B87"]
[null,"Project scoping, planning, scheduling, monitoring, reporting and commissioning",null,null,null,null,null,null,"Previous Road area",0,"m²"]
[null,"Management of preconstruction activities, development of tender documents and management of contracts",null,null,null,null,null,null,"Total Roadway Area",6692,"m²"]
[null,"Managing external interfaces, including community liaison, environmental issues, traffic issues etc",null,null,null,null,null,null,"Island Area",0,"m²"]
[null,"Records management",null,null,null,null,null,null,"Kerb and Channel",999,"Lm"]
[null,"Program Administration",null,0.02,{"$f":"($D$3/0.1)*D13","v":1.6840000000000001E-2},{"$f":"E13*$G$24","v":77987.10996548571},null,null,"Shoulder",999,"m²"]
[null,null,null,null,null,null,null,null,"Footpath Length",0,"Lm"]
["B",{"$f":"Summary!B11","v":"Design and Investigation (%)"},null,null,null,null,{"$f":"SUM(F15:F23)","v":389935.54982742859},null,"Pipe Length",null,"Lm"]
[null,"Traffic Investigations",null,8.5000000000000006E-3,{"$f":"($D$3/0.1)*D16","v":7.1570000000000002E-3},{"$f":"E16*$G$24","v":33144.521735331429},null,null,"Island Concrete infill",0,"m²"]
[null,"Cadastral and Engineering Survey",null,1.2E-2,1.0104E-2,46792.265979291427,null,null,"Shared Path Length",999,"Lm"]
[null,"Geotechnical investigations Pavement Investigations and Design",null,1.2E-2,1.0104E-2,46792.265979291427,null,null,"Total Road Length",999,"Lm"]
[null,"Environmental Investigations",null,null,0,0]
[null,"Landscape Design",null,null,0,0]
[null,"Preliminary and Final Design",null,4.2500000000000003E-2,3.5785000000000004E-2,165722.60867665717]
[null,"Construction Management",null,2.5000000000000001E-2,2.1049999999999999E-2,97483.887456857134]
[null,null,null,null,null,null,null,null,"2.5% of construction cost",{"$f":"0.025*G24","v":115776.58842857143}]
["C","Construction",null,null,null,{"$f":"SUM(F25:F84)","v":4631063.537142857},{"$f":"SUM(G25:G83)","v":4631063.537142857}]
[1,"PRELIMINARIES",null,null,null,null,{"$f":"SUM(F25:F28)","v":156000}]
[1.1000000000000001,"Site establishment",1,"Item",10000,{"$f":"E26*C26","v":10000}]
[1.2,"Site management & supervision including QA",20,"wks",2500,{"$f":"SUM(E27*C27)","v":50000}]
[1.3,"Provision for traffic",1,"Item",{"$f":"C27*6*800","v":96000},{"$f":"SUM(E28*C28)","v":96000}]
[2,"DEMOLITION",null,null,null,null,{"$f":"SUM(F29:F32)","v":0},null,null,null,"  "]
["2.1","Trees",0,"No",500,{"$f":"SUM(E30*C30)","v":0}]
["2.2","Strip asphalt from existing pavement",{"$f":"J9","v":0},"m²",5,{"$f":"SUM(E31*C31)","v":0}]
[3,"EARTHWORKS",null,null,null,null,{"$f":"SUM(F32:F38)","v":353882.13}]
[3.1,"Stripping topsoil (100mm)",{"$f":"J10+J12*1+J13*1.3-J11-J9","v":8989.7000000000007},"m²",6,{"$f":"SUM(E33*C33)","v":53938.200000000004}]
[3.2,"Excavation and removal (inc. reclamation of FCR)",{"$f":"C40*0.18","v":1258.5059999999999},"m³",30,{"$f":"SUM(E34*C34)","v":37755.179999999993}]
["3.3","Filling",{"$f":"C40*0.71","v":4964.107},"m³",15,{"$f":"C35*E35","v":74461.604999999996}]
["3.4","Import Fill material ",{"$f":"C35-C34","v":3705.6010000000001},"m³",45,{"$f":"C36*E36","v":166752.04500000001}]
["3.5","Soft spot rectification (reclaimed FCR)",{"$f":"C40*20%","v":1398.3400000000001},"m³",15,{"$f":"SUM(E37*C37)","v":20975.100000000002}]
[4,"PAVEMENT "," ",null,null,null,{"$f":"SUM(F38:F42)","v":1511707}]
[4.0999999999999996,"Deep lift asphalt 195 mm ",{"$f":"J10-J13-J11","v":5693},"m²",{"$f":"IF(C39<15000,105,85)","v":105},{"$f":"SUM(E39*C39)","v":597765}]
[4.2,"Subbase course - 250 mm 3% CTCR",{"$f":"C39+(J12*1)+C41*0.3","v":6991.7},"m²",{"$f":"IF(C40<15000,55,45)","v":55},{"$f":"SUM(E40*C40)","v":384543.5}]
["4.3","Shoulder - full depth pavement",{"$f":"J13","v":999},"m²",145,{"$f":"SUM(E41*C41)","v":144855}]
["4.4","Rock excavation & sub-surface remediation 450mm",{"$f":"C40","v":6991.7},"m²",55,{"$f":"SUM(E42*C42)","v":384543.5}]
["5","DRAINAGE"," ",null,null,null,{"$f":"SUM(F43:F48)","v":306892.79999999999}]
[5.0999999999999996,"Subsoil drains 100mm dia - screenings",{"$f":"J12+J13","v":1998},"Lm",30,{"$f":"SUM(E44*C44)","v":59940}]
[5.2,"Subsoil drains 100mm dia - no fines conc",0,"Lm",45,{"$f":"SUM(E45*C45)","v":0}]
[5.3,"375 RCP (class 2)",{"$f":"J18+(C47*8)","v":1158.8399999999999},"Lm",170,{"$f":"SUM(E46*C46)","v":197002.8}]
["5.4","Side entry pits",{"$f":"J12/50","v":19.98},"No",2500,{"$f":"SUM(E47*C47)","v":49950}]
["5.5","Allowance to modify draiange to ultimate location",null,"item",{"$f":"14*(2500+2000+10*E46)","v":86800},{"$f":"SUM(E48*C48)","v":0}]
[6,"CONCRETE WORKS"," ",null,null,null,{"$f":"SUM(F49:F54)","v":179820}]
[6.1,"Kerb &channel",{"$f":"J12","v":999},"Lm",50,{"$f":"SUM(E50*C50)","v":49950}]
[6.2,"Shared Paths (3.0m wide,125 mm, residential, as per MPA)",{"$f":"J17","v":999},"Lm",130,{"$f":"SUM(E51*C51)","v":129870}]
[6.3,"Footpaths (1.5m wide,125 mm, residential, as per MPA)",{"$f":"J14","v":0},"No",65,{"$f":"SUM(E52*C52)","v":0}]
[6.4,"Laybacks and tactile pavers",0,"m²",1200,{"$f":"SUM(E53*C53)","v":0}]
[6.5,"10m concrete  maintenance area end of all islands",{"$f":"J16","v":0},"m²",85,{"$f":"SUM(E54*C54)","v":0}]
["7","TRAFFIC SIGNAL WORKS",null,"NA",null,null,{"$f":"SUM(F55:F55)","v":0}]
["8","SIGNAL MAINTENANCE (10 YEARS) by Road Authority",null,"NA",null,{"$f":"SUM(E56*C56)","v":0},{"$f":"F56","v":0}]
["9","POWER & LIGHTING",null,null,null,null,{"$f":"SUM(F58:F64)","v":228367.85714285716}]
["9.1","Light pole (1-way) and luminous lights",0,"No",8000,0]
["9.2","Light pole (2-way) and luminous lights",{"$f":"J18/70","v":14.271428571428572},"No",9000,128442.85714285714]
["9.3","JUP lighting single",0,"No",4000,0]
["9.4","JUP lighting dual",0,"No",5000,0]
["9.5","Cabling, conduits and pits",{"$f":"J18","v":999},"Lm",75,74925]
["9.6","Electrical connection",1,"Item",15000,15000]
["9.7","Removal & replacement of pole-mounted substation",2,"Item",5000,10000]
["10","LANDSCAPING WORKS",null,null,null,null,{"$f":"SUM(F65:F66)","v":106143.75}]
["10.1","Topsoiling seeding",{"$f":"SUM(J13,J17)*6+J12*0.5+J11-J16","v":12487.5},"m²",8.5,{"$f":"SUM(E66*C66)","v":106143.75}]
["11","SIGNING",1,"item",10000,10000,{"$f":"F67","v":10000}]
["12","LINEMARKING (Thermoplastic)",1,"item",30000,30000,{"$f":"F68","v":30000}]
["13","SERVICE RELOCATION",null,null,null,null,{"$f":"SUM(F69:F76)","v":1748250}]
["13.1","Water supply main, 300 mm",{"$f":"$J$18","v":999},"Lm",350,{"$f":"SUM(E70*C70)","v":349650}]
["13.2","Gas supply main 150 mm",{"$f":"$J$18","v":999},"Lm",180,{"$f":"SUM(E71*C71)","v":179820}]
["13.3","Telco Pit and Pipe (Assume 3x100mm)",999,"Lm",120,{"$f":"SUM(E72*C72)","v":119880}]
["13.4","Sewer main 300 mm (Assume Gravity + FCR Backfill)",999,"Lm",450,449550]
["13.5","UG electrical (HV + LV)",999,"Lm",300,{"$f":"SUM(E74*C74)","v":299700}]
["13.6","Water supply main (RECYCLED), 300 mm",999,"Lm",350,{"$f":"SUM(E75*C75)","v":349650}]
["13.7","(Overhead electrical) No allowance",0,"Lm",null,{"$f":"SUM(E76*C76)","v":0}]
["14","MISCELLANEOUS ",null,null,null,null,{"$f":"SUM(F77:F82)","v":0}]
[null,"Exisiting Road outside of new road pavements"]
["14.1","Strip asphalt",{"$f":"J9","v":0},"m²",5,{"$f":"SUM(E79*C79)","v":0}]
["14.2","Recycle FCR to stockpile",{"$f":"C79*0.3","v":0},"m³",10,{"$f":"SUM(E80*C80)","v":0}]
["14.3","backfill with structural fill",{"$f":"C79*0.5","v":0},"m³",12,{"$f":"SUM(E81*C81)","v":0}]
["14.4","Topsoiling",{"$f":"C79","v":0},"m²",8.5,{"$f":"SUM(E82*C82)","v":0}]
["15","PROVISIONAL SUM - DAYWORK",null,"item",null,0,{"$f":"F83","v":0}]
[]
[null,"TOTAL A - C",null,null,null,{"$f":"SUM(F25:F84,F7:F23)","v":5215966.8618839998},{"$f":"SUM(G24+G15+G7)","v":5215966.8618839998}]
[]
["D","Contingency"]
[null,{"$f":"Summary!B17","v":"Contingency (15% of C)"},null,null,null,0.15,{"$f":"F88*G24","v":694659.53057142848}]
[]
["E","PROJECT BUDGET"]
[null,"Total Estimate",null,null,null,null,{"$f":"G88+G85","v":5910626.3924554279}]
[null,"Total Estimate per linear metre",null,null,null,null,{"$f":"G91/J18","v":5916.5429353908185}]
[]
["Notes:"]
["-","Koukoura Road earthworks based on a concept vertical grade alignment"]
[]
["Services"]
["1"," Basic supply infrastructure has been included  for Gas, Telco, Sewer, Water, U/G HV & LV elect  have been incorporated for the road sections"]
["2","No allowance for water, gas, telstra, sewer"]
["Substations"]
["3","No allowance for substations"]
["Preliminaries"]
["4","Based on nominal rates"]
["Subsoil Drain"]
["5","Assume same as kerb and channel"]
["Side Entry Pits"]
["6","Based on 50 m intervals"]
["Tactile Pavers"]
["7","Assume hazard TGSI's (no directional)"]
["Signing"]
["8","Nominal rate"]
["Pavement"]
["9","Assume deep lift asphalt pavement "]
["Tree Removal"]
["10","Based on preliminary information"]
["Roads"]
["11","Where applicable, existing asphalt roads to be demolished as part of intersection works"]
[]
[]
[]
[]
["AUTHOR:","Graeme Stenton"]
["Date:","2014-12-16"]
[]
["REVIEWER:","Rob Henry"]
["Date:"," "]

{"sheet":"RD-06-T10","index":5,"n_rows":126,"n_cols":11,"rows_kept":126,"cut":false,"hidden":false,"merged":[[3,4,4,5],[116,1,116,6],[117,1,117,6],[118,1,118,6],[119,1,119,5]]}
["PRELIMINARY ESTIMATE OF DEVELOPMENT COSTS",null,null,null,null,null,{"$f":"Summary!A5","v":"2015-05-14"}]
[{"$f":"Summary!A3","v":"CG140690"},null,null,null,null,null,{"$f":"Summary!A6","v":"Version 4"}]
[{"$f":"Summary!A4","v":"Wollert PSP - Roads Cost Estimate"},null,"PM %:",8.4500000000000006E-2,null,null,null,null,"Click here for Nearmap Screenshots taken July 2014"]
["Intersection Ref:",{"$f":"J7","v":"RD-06"},null,null,"DRAFT",null,null,null,"Do not Delete the below info"]
["Sheet Ref:",{"$f":"Summary!G9","v":"T10-07 & 08-P2"}]
["ITEM","DESCRIPTION","QUANTITY","UNIT","RATE ","AMOUNT","SUBTOTAL",null,"Sheet Specific Information","Input","Cell Reference"]
["A",{"$f":"Summary!B10","v":"Project and Program Management (%)"},null,null,null,null,{"$f":"SUM(F7:F14)","v":190121.54274285713},null,"Intersection Name","RD-06","A4"]
[null,"Project Management",null,0.03,{"$f":"($D$3/0.1)*D8","v":2.5349999999999998E-2},{"$f":"E8*$G$24","v":114072.92564571428},null,null,"Existing road directions","N-S E-W","B87"]
[null,"Project scoping, planning, scheduling, monitoring, reporting and commissioning",null,null,null,null,null,null,"Previous Road area",5160,"m²"]
[null,"Management of preconstruction activities, development of tender documents and management of contracts",null,null,null,null,null,null,"Total Roadway Area",6212,"m²"]
[null,"Managing external interfaces, including community liaison, environmental issues, traffic issues etc",null,null,null,null,null,null,"Island Area",0,"m²"]
[null,"Records management",null,null,null,null,null,null,"Kerb and Channel",1808,"Lm"]
[null,"Program Administration",null,0.02,{"$f":"($D$3/0.1)*D13","v":1.6899999999999998E-2},{"$f":"E13*$G$24","v":76048.617097142851},null,null,"Shoulder",0,"m²"]
[null,null,null,null,null,null,null,null,"Footpath Length",0,"Lm"]
["B",{"$f":"Summary!B11","v":"Design and Investigation (%)"},null,null,null,null,{"$f":"SUM(F15:F23)","v":380243.08548571425},null,"Pipe Length",null,"Lm"]
[null,"Traffic Investigations",null,8.5000000000000006E-3,{"$f":"($D$3/0.1)*D16","v":7.1825000000000005E-3},{"$f":"E16*$G$24","v":32320.662266285715},null,null,"Island Concrete infill",0,"m²"]
[null,"Cadastral and Engineering Survey",null,1.2E-2,1.014E-2,45629.170258285711,null,null,"Shared Path Length",0,"Lm"]
[null,"Geotechnical investigations Pavement Investigations and Design",null,1.2E-2,1.014E-2,45629.170258285711,null,null,"Total Road Length",918,"Lm"]
[null,"Environmental Investigations",null,null,0,0]
[null,"Landscape Design",null,null,0,0]
[null,"Preliminary and Final Design",null,4.2500000000000003E-2,3.59125E-2,161603.31133142856]
[null,"Construction Management",null,2.5000000000000001E-2,2.1125000000000001E-2,95060.771371428578]
[null,null,null,null,null,null,null,null,"2.5% of construction cost",{"$f":"0.025*G24","v":112497.9542857143}]
["C","Construction",null,null,null,{"$f":"SUM(F25:F84)","v":4499918.1714285715},{"$f":"SUM(G25:G83)","v":4499918.1714285715}]
[1,"PRELIMINARIES",null,null,null,null,{"$f":"SUM(F25:F28)","v":156000}]
[1.1000000000000001,"Site establishment",1,"Item",10000,{"$f":"E26*C26","v":10000}]
[1.2,"Site management & supervision including QA",20,"wks",2500,{"$f":"SUM(E27*C27)","v":50000}]
[1.3,"Provision for traffic",1,"Item",{"$f":"C27*6*800","v":96000},{"$f":"SUM(E28*C28)","v":96000}]
[2,"DEMOLITION",null,null,null,null,{"$f":"SUM(F29:F32)","v":25800},null,null,null,"  "]
["2.1","Trees",0,"No",500,{"$f":"SUM(E30*C30)","v":0}]
["2.2","Strip asphalt from existing pavement",{"$f":"J9","v":5160},"m²",5,{"$f":"SUM(E31*C31)","v":25800}]
[3,"EARTHWORKS",null,null,null,null,{"$f":"SUM(F32:F38)","v":361218}]
[3.1,"Stripping topsoil (100mm)",{"$f":"J10+J12*1+J13*1.3-J11-J9","v":2860},"m²",6,{"$f":"SUM(E33*C33)","v":17160}]
[3.2,"Excavation and removal (inc. reclamation of FCR)",{"$f":"C40*0.18","v":1443.6},"m³",30,{"$f":"SUM(E34*C34)","v":43308}]
["3.3","Filling",{"$f":"C40*0.71","v":5694.2},"m³",15,{"$f":"C35*E35","v":85413}]
["3.4","Import Fill material ",{"$f":"C35-C34","v":4250.6000000000004},"m³",45,{"$f":"C36*E36","v":191277.00000000003}]
["3.5","Soft spot rectification (reclaimed FCR)",{"$f":"C40*20%","v":1604},"m³",15,{"$f":"SUM(E37*C37)","v":24060}]
[4,"PAVEMENT "," ",null,null,null,{"$f":"SUM(F38:F42)","v":1534460}]
[4.0999999999999996,"Deep lift asphalt 195 mm ",{"$f":"J10-J13-J11","v":6212},"m²",{"$f":"IF(C39<15000,105,85)","v":105},{"$f":"SUM(E39*C39)","v":652260}]
[4.2,"Subbase course - 250 mm 3% CTCR",{"$f":"C39+(J12*1)+C41*0.3","v":8020},"m²",{"$f":"IF(C40<15000,55,45)","v":55},{"$f":"SUM(E40*C40)","v":441100}]
["4.3","Shoulder - full depth pavement",{"$f":"J13","v":0},"m²",145,{"$f":"SUM(E41*C41)","v":0}]
["4.4","Rock excavation & sub-surface remediation 450mm",{"$f":"C40","v":8020},"m²",55,{"$f":"SUM(E42*C42)","v":441100}]
["5","DRAINAGE"," ",null,null,null,{"$f":"SUM(F43:F48)","v":349877.6}]
[5.0999999999999996,"Subsoil drains 100mm dia - screenings",{"$f":"J12+J13","v":1808},"Lm",30,{"$f":"SUM(E44*C44)","v":54240}]
[5.2,"Subsoil drains 100mm dia - no fines conc",0,"Lm",45,{"$f":"SUM(E45*C45)","v":0}]
[5.3,"375 RCP (class 2)",{"$f":"J18+(C47*8)","v":1207.28},"Lm",170,{"$f":"SUM(E46*C46)","v":205237.6}]
["5.4","Side entry pits",{"$f":"J12/50","v":36.159999999999997},"No",2500,{"$f":"SUM(E47*C47)","v":90399.999999999985}]
["5.5","Allowance to modify draiange to ultimate location",null,"item",{"$f":"14*(2500+2000+10*E46)","v":86800},{"$f":"SUM(E48*C48)","v":0}]
[6,"CONCRETE WORKS"," ",null,null,null,{"$f":"SUM(F49:F54)","v":90400}]
[6.1,"Kerb &channel",{"$f":"J12","v":1808},"Lm",50,{"$f":"SUM(E50*C50)","v":90400}]
[6.2,"Shared Paths (3.0m wide,125 mm, residential, as per MPA)",{"$f":"J17","v":0},"Lm",130,{"$f":"SUM(E51*C51)","v":0}]
[6.3,"Footpaths (1.5m wide,125 mm, residential, as per MPA)",{"$f":"J14","v":0},"No",65,{"$f":"SUM(E52*C52)","v":0}]
[6.4,"Laybacks and tactile pavers",0,"m²",1200,{"$f":"SUM(E53*C53)","v":0}]
[6.5,"10m concrete  maintenance area end of all islands",{"$f":"J16","v":0},"m²",85,{"$f":"SUM(E54*C54)","v":0}]
["7","TRAFFIC SIGNAL WORKS",null,"NA",null,null,{"$f":"SUM(F55:F55)","v":0}]
["8","SIGNAL MAINTENANCE (10 YEARS) by Road Authority",null,"NA",null,{"$f":"SUM(E56*C56)","v":0},{"$f":"F56","v":0}]
["9","POWER & LIGHTING",null,null,null,null,{"$f":"SUM(F58:F64)","v":211878.57142857142}]
["9.1","Light pole (1-way) and luminous lights",0,"No",8000,0]
["9.2","Light pole (2-way) and luminous lights",{"$f":"J18/70","v":13.114285714285714},"No",9000,118028.57142857142]
["9.3","JUP lighting single",0,"No",4000,0]
["9.4","JUP lighting dual",0,"No",5000,0]
["9.5","Cabling, conduits and pits",{"$f":"J18","v":918},"Lm",75,68850]
["9.6","Electrical connection",1,"Item",15000,15000]
["9.7","Removal & replacement of pole-mounted substation",2,"Item",5000,10000]
["10","LANDSCAPING WORKS",null,null,null,null,{"$f":"SUM(F65:F66)","v":7684}]
["10.1","Topsoiling seeding",{"$f":"SUM(J13,J17)*6+J12*0.5+J11-J16","v":904},"m²",8.5,{"$f":"SUM(E66*C66)","v":7684}]
["11","SIGNING",1,"item",10000,10000,{"$f":"F67","v":10000}]
["12","LINEMARKING (Thermoplastic)",1,"item",30000,30000,{"$f":"F68","v":30000}]
["13","SERVICE RELOCATION",null,null,null,null,{"$f":"SUM(F69:F76)","v":1606500}]
["13.1","Water supply main, 300 mm",{"$f":"$J$18","v":918},"Lm",350,{"$f":"SUM(E70*C70)","v":321300}]
["13.2","Gas supply main 150 mm",{"$f":"$J$18","v":918},"Lm",180,{"$f":"SUM(E71*C71)","v":165240}]
["13.3","Telco Pit and Pipe (Assume 3x100mm)",918,"Lm",120,{"$f":"SUM(E72*C72)","v":110160}]
["13.4","Sewer main 300 mm (Assume Gravity + FCR Backfill)",918,"Lm",450,413100]
["13.5","UG electrical (HV + LV)",918,"Lm",300,{"$f":"SUM(E74*C74)","v":275400}]
["13.6","Water supply main (RECYCLED), 300 mm",918,"Lm",350,{"$f":"SUM(E75*C75)","v":321300}]
["13.7","(Overhead electrical) No allowance",0,"Lm",null,{"$f":"SUM(E76*C76)","v":0}]
["14","MISCELLANEOUS ",null,null,null,null,{"$f":"SUM(F77:F82)","v":116100}]
[null,"Exisiting Road outside of new road pavements"]
["14.1","Strip asphalt",{"$f":"J9","v":5160},"m²",5,{"$f":"SUM(E79*C79)","v":25800}]
["14.2","Recycle FCR to stockpile",{"$f":"C79*0.3","v":1548},"m³",10,{"$f":"SUM(E80*C80)","v":15480}]
["14.3","backfill with structural fill",{"$f":"C79*0.5","v":2580},"m³",12,{"$f":"SUM(E81*C81)","v":30960}]
["14.4","Topsoiling",{"$f":"C79","v":5160},"m²",8.5,{"$f":"SUM(E82*C82)","v":43860}]
["15","PROVISIONAL SUM - DAYWORK",null,"item",null,0,{"$f":"F83","v":0}]
[]
[null,"TOTAL A - C",null,null,null,{"$f":"SUM(F25:F84,F7:F23)","v":5070282.7996571437},{"$f":"SUM(G24+G15+G7)","v":5070282.7996571427}]
[]
["D","Contingency"]
[null,{"$f":"Summary!B17","v":"Contingency (15% of C)"},null,null,null,0.15,{"$f":"F88*G24","v":674987.72571428574}]
[]
["E","PROJECT BUDGET"]
[null,"Total Estimate",null,null,null,null,{"$f":"G88+G85","v":5745270.5253714286}]
[null,"Total Estimate per linear metre",null,null,null,null,{"$f":"G91/J18","v":6258.4646245876129}]
[]
["Notes:"]
["-","Koukoura Road earthworks based on a concept vertical grade alignment"]
[]
["Services"]
["1"," Basic supply infrastructure has been included  for Gas, Telco, Sewer, Water, U/G HV & LV elect  have been incorporated for the road sections"]
["2","No allowance for water, gas, telstra, sewer"]
["Substations"]
["3","No allowance for substations"]
["Preliminaries"]
["4","Based on nominal rates"]
["Subsoil Drain"]
["5","Assume same as kerb and channel"]
["Side Entry Pits"]
["6","Based on 50 m intervals"]
["Tactile Pavers"]
["7","Assume hazard TGSI's (no directional)"]
["Signing"]
["8","Nominal rate"]
["Pavement"]
["9","Assume deep lift asphalt pavement "]
["Tree Removal"]
["10","Based on preliminary information"]
["Roads"]
["11","Where applicable, existing asphalt roads to be demolished as part of intersection works"]
[]
[]
[]
[]
["AUTHOR:","Graeme Stenton"]
["Date:","2014-12-16"]
[]
["REVIEWER:","Rob Henry"]
["Date:"," "]

{"sheet":"RD-07-T10","index":6,"n_rows":126,"n_cols":11,"rows_kept":126,"cut":false,"hidden":false,"merged":[[3,4,4,5],[116,1,116,6],[117,1,117,6],[118,1,118,6],[119,1,119,5]]}
["PRELIMINARY ESTIMATE OF DEVELOPMENT COSTS",null,null,null,null,null,{"$f":"Summary!A5","v":"2015-05-14"}]
[{"$f":"Summary!A3","v":"CG140690"},null,null,null,null,null,{"$f":"Summary!A6","v":"Version 4"}]
[{"$f":"Summary!A4","v":"Wollert PSP - Roads Cost Estimate"},null,"PM %:",8.2699999999999996E-2,null,null,null,null,"Click here for Nearmap Screenshots taken July 2014"]
["Intersection Ref:",{"$f":"J7","v":"RD-07"},null,null,"DRAFT",null,null,null,"Do not Delete the below info"]
["Sheet Ref:",{"$f":"Summary!H9","v":"T10-09, 10 & 11-P2"}]
["ITEM","DESCRIPTION","QUANTITY","UNIT","RATE ","AMOUNT","SUBTOTAL",null,"Sheet Specific Information","Input","Cell Reference"]
["A",{"$f":"Summary!B10","v":"Project and Program Management (%)"},null,null,null,null,{"$f":"SUM(F7:F14)","v":221712.53837742857},null,"Intersection Name","RD-07","A4"]
[null,"Project Management",null,0.03,{"$f":"($D$3/0.1)*D8","v":2.4809999999999999E-2},{"$f":"E8*$G$24","v":133027.52302645714},null,null,"Existing road directions","E-W","B87"]
[null,"Project scoping, planning, scheduling, monitoring, reporting and commissioning",null,null,null,null,null,null,"Previous Road area",3342,"m²"]
[null,"Management of preconstruction activities, development of tender documents and management of contracts",null,null,null,null,null,null,"Total Roadway Area",7352,"m²"]
[null,"Managing external interfaces, including community liaison, environmental issues, traffic issues etc",null,null,null,null,null,null,"Island Area",0,"m²"]
[null,"Records management",null,null,null,null,null,null,"Kerb and Channel",1098,"Lm"]
[null,"Program Administration",null,0.02,{"$f":"($D$3/0.1)*D13","v":1.6539999999999999E-2},{"$f":"E13*$G$24","v":88685.015350971429},null,null,"Shoulder",1098,"m²"]
[null,null,null,null,null,null,null,null,"Footpath Length",0,"Lm"]
["B",{"$f":"Summary!B11","v":"Design and Investigation (%)"},null,null,null,null,{"$f":"SUM(F15:F23)","v":443425.07675485715},null,"Pipe Length",null,"Lm"]
[null,"Traffic Investigations",null,8.5000000000000006E-3,{"$f":"($D$3/0.1)*D16","v":7.0295000000000002E-3},{"$f":"E16*$G$24","v":37691.131524162862},null,null,"Island Concrete infill",0,"m²"]
[null,"Cadastral and Engineering Survey",null,1.2E-2,9.9240000000000005E-3,53211.009210582859,null,null,"Shared Path Length",2196,"Lm"]
[null,"Geotechnical investigations Pavement Investigations and Design",null,1.2E-2,9.9240000000000005E-3,53211.009210582859,null,null,"Total Road Length",1098,"Lm"]
[null,"Environmental Investigations",null,null,0,0]
[null,"Landscape Design",null,null,0,0]
[null,"Preliminary and Final Design",null,4.2500000000000003E-2,3.5147499999999998E-2,188455.65762081428]
[null,"Construction Management",null,2.5000000000000001E-2,2.0674999999999999E-2,110856.26918871429]
[null,null,null,null,null,null,null,null,"2.5% of construction cost",{"$f":"0.025*G24","v":134046.27471428571}]
["C","Construction",null,null,null,{"$f":"SUM(F25:F84)","v":5361850.9885714287},{"$f":"SUM(G25:G83)","v":5361850.9885714287}]
[1,"PRELIMINARIES",null,null,null,null,{"$f":"SUM(F25:F28)","v":156000}]
[1.1000000000000001,"Site establishment",1,"Item",10000,{"$f":"E26*C26","v":10000}]
[1.2,"Site management & supervision including QA",20,"wks",2500,{"$f":"SUM(E27*C27)","v":50000}]
[1.3,"Provision for traffic",1,"Item",{"$f":"C27*6*800","v":96000},{"$f":"SUM(E28*C28)","v":96000}]
[2,"DEMOLITION",null,null,null,null,{"$f":"SUM(F29:F32)","v":30710},null,null,null,"  "]
["2.1","Trees",28,"No",500,{"$f":"SUM(E30*C30)","v":14000}]
["2.2","Strip asphalt from existing pavement",{"$f":"J9","v":3342},"m²",5,{"$f":"SUM(E31*C31)","v":16710}]
[3,"EARTHWORKS",null,null,null,null,{"$f":"SUM(F32:F38)","v":368744.46}]
[3.1,"Stripping topsoil (150mm)",{"$f":"J10+J12*1+J13*1.3-J11-J9","v":6535.4},"m²",6,{"$f":"SUM(E33*C33)","v":39212.399999999994}]
[3.2,"Excavation and removal (inc. reclamation of FCR)",{"$f":"C40*0.18","v":1382.6519999999998},"m³",30,{"$f":"SUM(E34*C34)","v":41479.56}]
["3.3","Filling",{"$f":"C40*0.71","v":5453.7939999999999},"m³",15,{"$f":"C35*E35","v":81806.91}]
["3.4","Import Fill material ",{"$f":"C35-C34","v":4071.1419999999998},"m³",45,{"$f":"C36*E36","v":183201.38999999998}]
["3.5","Soft spot rectification (reclaimed FCR)",{"$f":"C40*0.2","v":1536.28},"m³",15,{"$f":"SUM(E37*C37)","v":23044.2}]
[4,"PAVEMENT "," ",null,null,null,{"$f":"SUM(F38:F42)","v":1660834}]
[4.0999999999999996,"Deep lift asphalt 195 mm ",{"$f":"J10-J13-J11","v":6254},"m²",{"$f":"IF(C39<15000,105,85)","v":105},{"$f":"SUM(E39*C39)","v":656670}]
[4.2,"Subbase course - 250 mm 3% CTCR",{"$f":"C39+(J12*1)+C41*0.3","v":7681.4},"m²",{"$f":"IF(C40<15000,55,45)","v":55},{"$f":"SUM(E40*C40)","v":422477}]
["4.3","Shoulder - full depth pavement",{"$f":"J13","v":1098},"m²",145,{"$f":"SUM(E41*C41)","v":159210}]
["4.4","Rock excavation & sub-surface remediation 450mm",{"$f":"C40","v":7681.4},"m²",55,{"$f":"SUM(E42*C42)","v":422477}]
["5","DRAINAGE"," ",null,null,null,{"$f":"SUM(F43:F48)","v":337305.59999999998}]
[5.0999999999999996,"Subsoil drains 100mm dia - screenings",{"$f":"J12+J13","v":2196},"Lm",30,{"$f":"SUM(E44*C44)","v":65880}]
[5.2,"Subsoil drains 100mm dia - no fines conc",0,"Lm",45,{"$f":"SUM(E45*C45)","v":0}]
[5.3,"375 RCP (class 2)",{"$f":"J18+(C47*8)","v":1273.68},"Lm",170,{"$f":"SUM(E46*C46)","v":216525.6}]
["5.4","Side entry pits",{"$f":"J12/50","v":21.96},"No",2500,{"$f":"SUM(E47*C47)","v":54900}]
["5.5","Allowance to modify draiange to ultimate location",0,"item",{"$f":"14*(2500+2000+10*E46)","v":86800},{"$f":"SUM(E48*C48)","v":0}]
[6,"CONCRETE WORKS"," ",null,null,null,{"$f":"SUM(F49:F54)","v":340380}]
[6.1,"Kerb &channel",{"$f":"J12","v":1098},"Lm",50,{"$f":"SUM(E50*C50)","v":54900}]
[6.2,"Shared Paths (3.0m wide,125 mm, residential, as per MPA)",{"$f":"J17","v":2196},"Lm",130,{"$f":"SUM(E51*C51)","v":285480}]
[6.3,"Footpaths (1.5m wide,125 mm, residential, as per MPA)",{"$f":"J14","v":0},"No",65,{"$f":"SUM(E52*C52)","v":0}]
[6.4,"Laybacks and tactile pavers",0,"m²",1200,{"$f":"SUM(E53*C53)","v":0}]
[6.5,"10m concrete  maintenance area end of all islands",{"$f":"J16","v":0},"m²",85,{"$f":"SUM(E54*C54)","v":0}]
["7","TRAFFIC SIGNAL WORKS",null,"NA",null,null,{"$f":"SUM(F55:F55)","v":0}]
["8","SIGNAL MAINTENANCE (10 YEARS) by Road Authority",null,"NA",null,{"$f":"SUM(E56*C56)","v":0},{"$f":"F56","v":0}]
["9","POWER & LIGHTING",null,null,null,null,{"$f":"SUM(F58:F64)","v":258521.42857142858}]
["9.1","Light pole (1-way) and luminous lights",0,"No",8000,0]
["9.2","Light pole (2-way) and luminous lights",{"$f":"J18/70","v":15.685714285714285},"No",9000,141171.42857142858]
["9.3","JUP lighting single",0,"No",4000,0]
["9.4","JUP lighting dual",0,"No",5000,0]
["9.5","Cabling, conduits and pits",{"$f":"J18","v":1098},"Lm",75,82350]
["9.6","Electrical connection",1,"Item",15000,15000]
["9.7","Removal & replacement of pole-mounted substation",4,"Item",5000,20000]
["10","LANDSCAPING WORKS",null,null,null,null,{"$f":"SUM(F65:F66)","v":172660.5}]
["10.1","Topsoiling seeding",{"$f":"SUM(J13,J17)*6+J12*0.5+J11-J16","v":20313},"m²",8.5,{"$f":"SUM(E66*C66)","v":172660.5}]
["11","SIGNING",1,"item",10000,10000,{"$f":"F67","v":10000}]
["12","LINEMARKING (Thermoplastic)",1,"item",30000,30000,{"$f":"F68","v":30000}]
["13","SERVICE RELOCATION",null,null,null,null,{"$f":"SUM(F69:F76)","v":1921500}]
["13.1","Water supply main, 300 mm",{"$f":"$J$18","v":1098},"Lm",350,{"$f":"SUM(E70*C70)","v":384300}]
["13.2","Gas supply main 150 mm",{"$f":"$J$18","v":1098},"Lm",180,{"$f":"SUM(E71*C71)","v":197640}]
["13.3","Telco Pit and Pipe (Assume 3x100mm)",1098,"Lm",120,{"$f":"SUM(E72*C72)","v":131760}]
["13.4","Sewer main 300 mm (Assume Gravity + FCR Backfill)",1098,"Lm",450,494100]
["13.5","UG electrical (HV + LV)",1098,"Lm",300,{"$f":"SUM(E74*C74)","v":329400}]
["13.6","Water supply main (RECYCLED), 300 mm",1098,"Lm",350,{"$f":"SUM(E75*C75)","v":384300}]
["13.7","(Overhead electrical) No allowance",0,"Lm",null,{"$f":"SUM(E76*C76)","v":0}]
["14","MISCELLANEOUS ",null,null,null,null,{"$f":"SUM(F77:F82)","v":75195}]
[null,"Exisiting Road outside of new road pavements"]
["14.1","Strip asphalt",{"$f":"J9","v":3342},"m²",5,{"$f":"SUM(E79*C79)","v":16710}]
["14.2","Recycle FCR to stockpile",{"$f":"C79*0.3","v":1002.5999999999999},"m³",10,{"$f":"SUM(E80*C80)","v":10026}]
["14.3","backfill with structural fill",{"$f":"C79*0.5","v":1671},"m³",12,{"$f":"SUM(E81*C81)","v":20052}]
["14.4","Topsoiling",{"$f":"C79","v":3342},"m²",8.5,{"$f":"SUM(E82*C82)","v":28407}]
["15","PROVISIONAL SUM - DAYWORK",null,"item",null,0,{"$f":"F83","v":0}]
[]
[null,"TOTAL A - C",null,null,null,{"$f":"SUM(F25:F84,F7:F23)","v":6026988.6037037149},{"$f":"SUM(G24+G15+G7)","v":6026988.603703714}]
[]
["D","Contingency"]
[null,{"$f":"Summary!B17","v":"Contingency (15% of C)"},null,null,null,0.15,{"$f":"F88*G24","v":804277.64828571433}]
[]
["E","PROJECT BUDGET"]
[null,"Total Estimate",null,null,null,null,{"$f":"G88+G85","v":6831266.251989428}]
[null,"Total Estimate per linear metre",null,null,null,null,{"$f":"G91/J18","v":6221.5539635604991}]
[]
["Notes:"]
["-","Koukoura Road earthworks based on a concept vertical grade alignment"]
[]
["Services"]
["1"," Basic supply infrastructure has been included  for Gas, Telco, Sewer, Water, U/G HV & LV elect  have been incorporated for the road sections"]
["2","No allowance for water, gas, telstra, sewer"]
["Substations"]
["3","No allowance for substations"]
["Preliminaries"]
["4","Based on nominal rates"]
["Subsoil Drain"]
["5","Assume same as kerb and channel"]
["Side Entry Pits"]
["6","Based on 50 m intervals"]
["Tactile Pavers"]
["7","Assume hazard TGSI's (no directional)"]
["Signing"]
["8","Nominal rate"]
["Pavement"]
["9","Assume deep lift asphalt pavement "]
["Tree Removal"]
["10","Based on preliminary information"]
["Roads"]
["11","Where applicable, existing asphalt roads to be demolished as part of intersection works"]
[]
[]
[]
[]
["AUTHOR:","Graeme Stenton"]
["Date:","2014-12-16"]
[]
["REVIEWER:","Rob Henry"]
["Date:"," "]

{"sheet":"RD-07dual -T11","index":7,"n_rows":126,"n_cols":11,"rows_kept":126,"cut":false,"hidden":false,"merged":[[3,4,4,5],[116,1,116,6],[117,1,117,6],[118,1,118,6],[119,1,119,5]]}
["PRELIMINARY ESTIMATE OF DEVELOPMENT COSTS",null,null,null,null,null,{"$f":"Summary!A5","v":"2015-05-14"}]
[{"$f":"Summary!A3","v":"CG140690"},null,null,null,null,null,{"$f":"Summary!A6","v":"Version 4"}]
[{"$f":"Summary!A4","v":"Wollert PSP - Roads Cost Estimate"},null,"PM %:",8.0699999999999994E-2,null,null,null,null,"Click here for Nearmap Screenshots taken July 2014"]
["Intersection Ref:",{"$f":"J7","v":"RD-07-DUAL"},null,null,"DRAFT",null,null,null,"Do not Delete the below info"]
["Sheet Ref:",{"$f":"Summary!J9","v":"T11-P1"}]
["ITEM","DESCRIPTION","QUANTITY","UNIT","RATE ","AMOUNT","SUBTOTAL",null,"Sheet Specific Information","Input","Cell Reference"]
["A",{"$f":"Summary!B10","v":"Project and Program Management (%)"},null,null,null,null,{"$f":"SUM(F7:F14)","v":263045.37545785715},null,"Intersection Name","RD-07-DUAL","A4"]
[null,"Project Management",null,0.03,{"$f":"($D$3/0.1)*D8","v":2.4209999999999999E-2},{"$f":"E8*$G$24","v":157827.22527471429},null,null,"Existing road directions","E-W","B87"]
[null,"Project scoping, planning, scheduling, monitoring, reporting and commissioning",null,null,null,null,null,null,"Previous Road area",3342,"m²"]
[null,"Management of preconstruction activities, development of tender documents and management of contracts",null,null,null,null,null,null,"Total Roadway Area",10315,"m²"]
[null,"Managing external interfaces, including community liaison, environmental issues, traffic issues etc",null,null,null,null,null,null,"Island Area",0,"m²"]
[null,"Records management",null,null,null,null,null,null,"Kerb and Channel",2195,"Lm"]
[null,"Program Administration",null,0.02,{"$f":"($D$3/0.1)*D13","v":1.6139999999999998E-2},{"$f":"E13*$G$24","v":105218.15018314285},null,null,"Shoulder",2195,"m²"]
[null,null,null,null,null,null,null,null,"Footpath Length",0,"Lm"]
["B",{"$f":"Summary!B11","v":"Design and Investigation (%)"},null,null,null,null,{"$f":"SUM(F15:F23)","v":526090.75091571431},null,"Pipe Length",null,"Lm"]
[null,"Traffic Investigations",null,8.5000000000000006E-3,{"$f":"($D$3/0.1)*D16","v":6.8595000000000001E-3},{"$f":"E16*$G$24","v":44717.713827835716},null,null,"Island Concrete infill",0,"m²"]
[null,"Cadastral and Engineering Survey",null,1.2E-2,9.6839999999999999E-3,63130.890109885717,null,null,"Shared Path Length",2196,"Lm"]
[null,"Geotechnical investigations Pavement Investigations and Design",null,1.2E-2,9.6839999999999999E-3,63130.890109885717,null,null,"Total Road Length",1098,"Lm"]
[null,"Environmental Investigations",null,null,0,0]
[null,"Landscape Design",null,null,0,0]
[null,"Preliminary and Final Design",null,4.2500000000000003E-2,3.4297500000000002E-2,223588.56913917858]
[null,"Construction Management",null,2.5000000000000001E-2,2.0174999999999998E-2,131522.68772892855]
[null,null,null,null,null,null,null,null,"2.5% of construction cost",{"$f":"0.025*G24","v":162977.30821428573}]
["C","Construction",null,null,null,{"$f":"SUM(F25:F84)","v":6519092.3285714285},{"$f":"SUM(G25:G83)","v":6519092.3285714285}]
[1,"PRELIMINARIES",null,null,null,null,{"$f":"SUM(F25:F28)","v":156000}]
[1.1000000000000001,"Site establishment",1,"Item",10000,{"$f":"E26*C26","v":10000}]
[1.2,"Site management & supervision including QA",20,"wks",2500,{"$f":"SUM(E27*C27)","v":50000}]
[1.3,"Provision for traffic",1,"Item",{"$f":"C27*6*800","v":96000},{"$f":"SUM(E28*C28)","v":96000}]
[2,"DEMOLITION",null,null,null,null,{"$f":"SUM(F29:F32)","v":30710},null,null,null,"  "]
["2.1","Trees",28,"No",500,{"$f":"SUM(E30*C30)","v":14000}]
["2.2","Strip asphalt from existing pavement",{"$f":"J9","v":3342},"m²",5,{"$f":"SUM(E31*C31)","v":16710}]
[3,"EARTHWORKS",null,null,null,null,{"$f":"SUM(F32:F38)","v":542892.15}]
[3.1,"Stripping topsoil (150mm)",{"$f":"J10+J12*1+J13*1.3-J11-J9","v":12021.5},"m²",6,{"$f":"SUM(E33*C33)","v":72129}]
[3.2,"Excavation and removal (inc. reclamation of FCR)",{"$f":"C40*0.18","v":1975.23},"m³",30,{"$f":"SUM(E34*C34)","v":59256.9}]
["3.3","Filling",{"$f":"C40*0.71","v":7791.1849999999995},"m³",15,{"$f":"C35*E35","v":116867.77499999999}]
["3.4","Import Fill material ",{"$f":"C35-C34","v":5815.9549999999999},"m³",45,{"$f":"C36*E36","v":261717.97500000001}]
["3.5","Soft spot rectification (reclaimed FCR)",{"$f":"C40*0.2","v":2194.7000000000003},"m³",15,{"$f":"SUM(E37*C37)","v":32920.500000000007}]
[4,"PAVEMENT "," ",null,null,null,{"$f":"SUM(F38:F42)","v":2377960}]
[4.0999999999999996,"Deep lift asphalt 195 mm ",{"$f":"J10-J13-J11","v":8120},"m²",{"$f":"IF(C39<15000,105,85)","v":105},{"$f":"SUM(E39*C39)","v":852600}]
[4.2,"Subbase course - 250 mm 3% CTCR",{"$f":"C39+(J12*1)+C41*0.3","v":10973.5},"m²",{"$f":"IF(C40<15000,55,45)","v":55},{"$f":"SUM(E40*C40)","v":603542.5}]
["4.3","Shoulder - full depth pavement",{"$f":"J13","v":2195},"m²",145,{"$f":"SUM(E41*C41)","v":318275}]
["4.4","Rock excavation & sub-surface remediation 450mm",{"$f":"C40","v":10973.5},"m²",55,{"$f":"SUM(E42*C42)","v":603542.5}]
["5","DRAINAGE"," ",null,null,null,{"$f":"SUM(F43:F48)","v":487814}]
[5.0999999999999996,"Subsoil drains 100mm dia - screenings",{"$f":"J12+J13","v":4390},"Lm",30,{"$f":"SUM(E44*C44)","v":131700}]
[5.2,"Subsoil drains 100mm dia - no fines conc",0,"Lm",45,{"$f":"SUM(E45*C45)","v":0}]
[5.3,"375 RCP (class 2)",{"$f":"J18+(C47*8)","v":1449.2},"Lm",170,{"$f":"SUM(E46*C46)","v":246364}]
["5.4","Side entry pits",{"$f":"J12/50","v":43.9},"No",2500,{"$f":"SUM(E47*C47)","v":109750}]
["5.5","Allowance to modify drainage to ultimate location",0,"item",{"$f":"14*(2500+2000+10*E46)","v":86800},{"$f":"SUM(E48*C48)","v":0}]
[6,"CONCRETE WORKS"," ",null,null,null,{"$f":"SUM(F49:F54)","v":395230}]
[6.1,"Kerb &channel",{"$f":"J12","v":2195},"Lm",50,{"$f":"SUM(E50*C50)","v":109750}]
[6.2,"Shared Paths (3.0m wide,125 mm, residential, as per MPA)",{"$f":"J17","v":2196},"Lm",130,{"$f":"SUM(E51*C51)","v":285480}]
[6.3,"Footpaths (1.5m wide,125 mm, residential, as per MPA)",{"$f":"J14","v":0},"No",65,{"$f":"SUM(E52*C52)","v":0}]
[6.4,"Laybacks and tactile pavers",0,"m²",1200,{"$f":"SUM(E53*C53)","v":0}]
[6.5,"10m concrete  maintenance area end of all islands",{"$f":"J16","v":0},"m²",85,{"$f":"SUM(E54*C54)","v":0}]
["7","TRAFFIC SIGNAL WORKS",null,"NA",null,null,{"$f":"SUM(F55:F55)","v":0}]
["8","SIGNAL MAINTENANCE (10 YEARS) by Road Authority",null,"NA",null,{"$f":"SUM(E56*C56)","v":0},{"$f":"F56","v":0}]
["9","POWER & LIGHTING",null,null,null,null,{"$f":"SUM(F58:F64)","v":258521.42857142858}]
["9.1","Light pole (1-way) and luminous lights",0,"No",8000,0]
["9.2","Light pole (2-way) and luminous lights",{"$f":"J18/70","v":15.685714285714285},"No",9000,141171.42857142858]
["9.3","JUP lighting single",0,"No",4000,0]
["9.4","JUP lighting dual",0,"No",5000,0]
["9.5","Cabling, conduits and pits",{"$f":"J18","v":1098},"Lm",75,82350]
["9.6","Electrical connection",1,"Item",15000,15000]
["9.7","Removal & replacement of pole-mounted substation",4,"Item",5000,20000]
["10","LANDSCAPING WORKS",null,null,null,null,{"$f":"SUM(F65:F66)","v":233269.75}]
["10.1","Topsoiling seeding",{"$f":"SUM(J13,J17)*6+J12*0.5+J11-J16","v":27443.5},"m²",8.5,{"$f":"SUM(E66*C66)","v":233269.75}]
["11","SIGNING",1,"item",10000,10000,{"$f":"F67","v":10000}]
["12","LINEMARKING (Thermoplastic)",1,"item",30000,30000,{"$f":"F68","v":30000}]
["13","SERVICE RELOCATION",null,null,null,null,{"$f":"SUM(F69:F76)","v":1921500}]
["13.1","Water supply main, 300 mm",{"$f":"$J$18","v":1098},"Lm",350,{"$f":"SUM(E70*C70)","v":384300}]
["13.2","Gas supply main 150 mm",{"$f":"$J$18","v":1098},"Lm",180,{"$f":"SUM(E71*C71)","v":197640}]
["13.3","Telco Pit and Pipe (Assume 3x100mm)",1098,"Lm",120,{"$f":"SUM(E72*C72)","v":131760}]
["13.4","Sewer main 300 mm (Assume Gravity + FCR Backfill)",1098,"Lm",450,494100]
["13.5","UG electrical (HV + LV)",1098,"Lm",300,{"$f":"SUM(E74*C74)","v":329400}]
["13.6","Water supply main (RECYCLED), 300 mm",1098,"Lm",350,{"$f":"SUM(E75*C75)","v":384300}]
["13.7","(Overhead electrical) No allowance",0,"Lm",null,{"$f":"SUM(E76*C76)","v":0}]
["14","MISCELLANEOUS ",null,null,null,null,{"$f":"SUM(F77:F82)","v":75195}]
[null,"Existing Road outside of new road pavements"]
["14.1","Strip asphalt",{"$f":"J9","v":3342},"m²",5,{"$f":"SUM(E79*C79)","v":16710}]
["14.2","Recycle FCR to stockpile",{"$f":"C79*0.3","v":1002.5999999999999},"m³",10,{"$f":"SUM(E80*C80)","v":10026}]
["14.3","backfill with structural fill",{"$f":"C79*0.5","v":1671},"m³",12,{"$f":"SUM(E81*C81)","v":20052}]
["14.4","Topsoiling",{"$f":"C79","v":3342},"m²",8.5,{"$f":"SUM(E82*C82)","v":28407}]
["15","PROVISIONAL SUM - DAYWORK",null,"item",null,0,{"$f":"F83","v":0}]
[]
[null,"TOTAL A - C",null,null,null,{"$f":"SUM(F25:F84,F7:F23)","v":7308228.4549449999},{"$f":"SUM(G24+G15+G7)","v":7308228.4549449999}]
[]
["D","Contingency"]
[null,{"$f":"Summary!B17","v":"Contingency (15% of C)"},null,null,null,0.15,{"$f":"F88*G24","v":977863.84928571421}]
[]
["E","PROJECT BUDGET"]
[null,"Total Estimate",null,null,null,null,{"$f":"G88+G85","v":8286092.3042307142}]
[null,"Total Estimate per linear metre",null,null,null,null,{"$f":"G91/J18","v":7546.5321532155867}]
[]
["Notes:"]
["-","Koukoura Road earthworks based on a concept vertical grade alignment"]
[]
["Services"]
["1"," Basic supply infrastructure has been included  for Gas, Telco, Sewer, Water, U/G HV & LV elect  have been incorporated for the road sections"]
["2","No allowance for water, gas, telstra, sewer"]
["Substations"]
["3","No allowance for substations"]
["Preliminaries"]
["4","Based on nominal rates"]
["Subsoil Drain"]
["5","Assume same as kerb and channel"]
["Side Entry Pits"]
["6","Based on 50 m intervals"]
["Tactile Pavers"]
["7","Assume hazard TGSI's (no directional)"]
["Signing"]
["8","Nominal rate"]
["Pavement"]
["9","Assume deep lift asphalt pavement "]
["Tree Removal"]
["10","Based on preliminary information"]
["Roads"]
["11","Where applicable, existing asphalt roads to be demolished as part of intersection works"]
[]
[]
[]
[]
["AUTHOR:","Graeme Stenton"]
["Date:","2014-12-18"]
[]
["REVIEWER:","Rob Henry"]
["Date:"," "]