{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet2","index":0,"n_rows":188,"n_cols":8,"rows_kept":188,"cut":false,"hidden":false,"merged":[[166,1,166,4],[0,6,0,7],[0,0,0,5],[177,1,177,6]]}
["Project Name: ",{"$nulls":5},"Date:"]
[]
[null,null,"Unit","Price ($)","Quantity","Total Cost ($)","Security ($)","Reduced Value, max. 10% ($)"]
[1,"Erosion & Sediment Control",{"$nulls":4},0]
[]
[null,"Maintenance of Erosion & Sediment Controls to Ensure Compliance with Sewer Use By-Law 2016-006","Time Basis",null,null,{"$f":"D6*E6","v":0},"-"]
[null,"Light Duty Silt Fencing (219.110)","m",null,null,{"$f":"D7*E7","v":0},"-"]
[null,"Heavy Duty Silt Fencing","m",null,null,0,"-"]
[null,"Mud Mat","ea",null,null,0,"-"]
[null,"Check Dams","ea",null,null,0,"-"]
[null,"Straw Bale Flow Check","ea",null,null,0,"-"]
[null,"R50 Rip Rap and Filter Cloth","m2",null,null,0,"-"]
[null,"Swales","m",null,null,0,"-"]
[null,"Filter Strip","m",null,null,0,"-"]
[]
[null,"Subtotal: Erosion & Sediment Control*",null,null,null,{"$f":"SUM(F6:F15)","v":0}]
[]
[2,"Site Preparation and Earthworks",{"$nulls":4},0]
[]
[null,"Clearing and Grubbing","LS",null,null,{"$f":"D20*E20","v":0},"-"]
[null,"Topsoil Strip and Stockpile","m3",null,null,0,"-"]
[null,"Earth Excavation and Grading","m3",null,null,0,"-"]
[null,"Ditching","m",null,null,0,"-"]
[null,"Cut to Fill","m3",null,null,0,"-"]
[null,"Import Fill ","m3",null,null,0,"-"]
[null,"Disposal of Fill Material Off-Site","m3",null,null,0,"-"]
[]
[null,"Subtotal: Earthworks*",null,null,null,{"$f":"SUM(F20:F27)","v":0}]
[]
[3,"Road - Internal Site Work",{"$nulls":4},0]
[]
[null,"Street, Stop and Parking Signs","LS",null,null,{"$f":"D32*E32","v":0},"-"]
[null,"Granular 'B' 300mm Depth","m2",null,null,0,"-"]
[null,"Granular 'A' 150mm Depth","m2",null,null,0,"-"]
[null,"HL8 Asphalt Binder Course 50mm Depth","m2",null,null,0,"-"]
[null,"HL4 Asphalt Surface course 40mm Depth","m2",null,null,0,"-"]
[null,"HL3 Asphalt Driveway","m2",null,null,0,"-"]
[null,"Storm 150 mm Dia Subdrain Road (OPSD216.021)","m",null,null,0,"-"]
[null,"Barrier Curb and Gutter (muni-1350) (608.010/605.030/600.040)","m",null,null,0,"-"]
[null,"2.0m wide Concrete Sidewalk","m2",null,null,0,"-"]
[null,"1.8m wide Concrete Sidewalk","m2",null,null,0,"-"]
[null,"1.5m wide Concrete Sidewalk","m2",null,null,0,"-"]
[null,"Ditching","m",null,null,0,"-"]
[null,"Topsoil, Seed & Mulch","m²",null,null,0,"-"]
[null,"Concrete Mail Box Pad","ea",null,null,0,"-"]
[null,"Line Painting","LS",null,null,0,"-"]
[null,"Dead End Barrier (chain","ea",null,null,0,"-"]
[null,"Parking Curb","ea",null,null,0,"-"]
[]
[null,"Subtotal: Road Internal Site Work *",null,null,null,{"$f":"SUM(F32:F49)","v":0}]
[]
[4,"External Site Work (100% Security)",{"$nulls":4},1]
[]
[null,"Street, Stop and Parking Signs","LS",null,null,{"$f":"D54*E54","v":0},{"$f":"F54","v":0}]
[null,"Granular 'B' 300mm Depth","m2",null,null,0,{"$f":"F55","v":0}]
[null,"Granular 'A' 150mm Depth","m2",null,null,0,0]
[null,"HL8 Asphalt Binder Course 50mm Depth","m2",null,null,0,0]
[null,"HL4 Asphalt Surface course 40mm Depth","m2",null,null,0,0]
[null,"HL3 Asphalt Driveway","m2",null,null,0,0]
[null,"Storm 150 mm Dia Subdrain Road (OPSD216.021)","m",null,null,0,0]
[null,"Barrier Curb and Gutter (muni-1350) (608.010/605.030/600.040)","m",null,null,0,0]
[null,"2.0m wide Concrete Sidewalk","m2",null,null,0,0]
[null,"1.8m wide Concrete Sidewalk","m2",null,null,0,0]
[null,"1.5m wide Concrete Sidewalk","m2",null,null,0,0]
[null,"Ditching","m",null,null,0,0]
[null,"Topsoil, Seed & Mulch","m²",null,null,0,0]
[null,"Concrete Pad (i.e. mailbox, bus stop)","ea",null,null,0,0]
[null,"Line Painting","LS",null,null,0,0]
[null,"Dead End Barrier (barricade and checkerboard sign)","ea",null,null,0,0]
[null,"Right of Way General Housekeeping (street sweeping, sediment transport, etc.)","LS",null,null,{"$f":"D70*E70","v":0},{"$f":"F70","v":0}]
[null,"Parking Curb","ea",null,null,0,0]
[null,"Water Servicing (connection, commissioning, materials)","LS",null,null,0,0]
[null,"Storm Servicing (connection, materials) - bulkhead to be in place until occupancy","LS",null,null,0,0]
[null,"Sanitary Servicing  (connection, materials)","LS",null,null,0,0]
[]
[null,"Subtotal:  External Site Work*",null,null,null,{"$f":"SUM(F54:F75)","v":0},{"$f":"SUM(G54:G75)","v":0}]
[]
[5,"Storm",{"$nulls":4},0]
[]
[null,"250mm ø P.V.C. ","m",null,null,{"$f":"D80*E80","v":0},"-"]
[null,"300mm ø P.V.C. ","m",null,null,0,"-"]
[null,"375mm ø P.V.C. ","m",null,null,0,"-"]
[null,"450mm ø P.V.C. ","m",null,null,0,"-"]
[null,"525mm ø Conc. ","m",null,null,0,"-"]
[null,"600mm ø Conc.","m",null,null,0,"-"]
[null,"675mm ø Conc. ","m",null,null,0,"-"]
[null,"750mm ø Conc. ","m",null,null,0,"-"]
[null,"825mm ø Conc.","m",null,null,0,"-"]
[null,"1050mm ø Conc.","m",null,null,0,"-"]
[null,"450mm CSP Culvert","m",null,null,0,"-"]
[null,"Oil Grit Separator","ea",null,null,0,"-"]
[null,"1200mm ø  (OPSD:701.010)","ea",null,null,0,"-"]
[null,"1500mm ø  (OPSD:701.011)","ea",null,null,0,"-"]
[null,"1800mm ø (OPSD:701.012)","ea",null,null,0,"-"]
[null,"2400mm ø (OPSD:701.013)","ea",null,null,0,"-"]
[null,"600mm ø Catch Basin c/w Frame & Grate (OPSD:705.010/400.020)","ea",null,null,0,"-"]
[null,"600mm ø Ditch Inlet Catch Basin c/w Frame & Grate (OPSD:705.030/403.010)","ea",null,null,0,"-"]
[null,"150mm ø Long Storm Service","ea",null,null,0,"-"]
[null,"150mm ø Short Storm Service","ea",null,null,0,"-"]
[null,"Clean, Flush and Video Inspection of Storm Sewers","m",null,null,0,"-"]
[null,"Pond",null,null,null,0,"-"]
[null,"Swales",null,null,null,0,"-"]
[null,"Soak Away Pit",null,null,null,0,"-"]
[null,"Operations and Maintenance - During Construction","Time Basis",null,null,0,"-"]
[null,"Other (please list)",null,null,null,0,"-"]
[]
[null,"Subtotal: Storm*",null,null,null,{"$f":"SUM(F80:F105)","v":0}]
[]
[]
[]
[6,"Sanitary",{"$nulls":4},0]
[]
[null,"200mm ø P.V.C. 404.020","m",null,null,{"$f":"D113*E113","v":0},"-"]
[null,"1200mm ø (701.010)","ea",null,null,0,"-"]
[null,"Manhole Drop Structure 1003.01","ea",null,null,0,"-"]
[null,"100mm ø Short Sanitary Service","ea",null,null,0,"-"]
[null,"100mm ø Long Sanitary Service","ea",null,null,0,"-"]
[null,"Clean, Flush and Video Inspection of Sewer","m",null,null,0,"-"]
[]
[null,"Subtotal: Sanitary*",null,null,null,{"$f":"SUM(F113:F119)","v":0}]
[]
[]
[]
[7,"Watermain and Appurtenances",{"$nulls":4},0]
[]
[null,"150 mm P.V.C. watermain ","m",null,null,{"$f":"D126*E126","v":0},"-"]
[null,"50 mm Copper","m",null,null,0,"-"]
[null,"150 mm Gate Valve","ea",null,null,0,"-"]
[null,"Yard Hydrant","ea",null,null,0,"-"]
[null,"Hydrant Set, Valve and Tee","ea",null,null,0,"-"]
[null,"19 mm Short Water Service","ea",null,null,0,"-"]
[null,"19 mm ø Long Water Service","ea",null,null,0,"-"]
[null,"19mm Curbstop with rod & box","ea",null,null,0,"-"]
[null,"300 mm P.V.C. watermain","m",null,null,0,"-"]
[null,"300 mm Gate Valve","ea",null,null,0,"-"]
[null,"Water, Disinfection and Pressure Testing","LS",null,null,0,"-"]
[]
[null,"Subtotal: Watermain and Appurtenances*",null,null,null,{"$f":"SUM(F126:F137)","v":0}]
[]
[]
[]
[8,"Lighting (50% Security)",{"$nulls":4},0.5]
[]
[null,"Exterior Wall Lighting","ea",null,null,{"$f":"D144*E144","v":0},{"$f":"F144*0.5","v":0}]
[null,"Light Standards","ea",null,null,0,{"$f":"F145*0.5","v":0}]
[]
[null,"Subtotal: Lighting",null,null,null,{"$f":"SUM(F144:F146)","v":0},{"$f":"SUM(G144:G146)","v":0}]
[]
[9,"Landscaping (100% Security)",{"$nulls":4},1]
[]
[null,"Clearing & Grubbing","ea",null,null,{"$f":"D151*E151","v":0},{"$f":"F151","v":0}]
[null,"Strip & Stockpile Topsoil","m3",null,null,0,0]
[null,"Earth Excavation","m3",null,null,0,0]
[null,"Topsoil, Seed & Mulch","m3",null,null,0,0]
[null,"Supply & Installation of Plants","ea",null,null,0,0]
[null,"Construction of Berm","ea",null,null,0,0]
[null,"Garbage Enclosure","ea",null,null,0,0]
[null,"Gates","ea",null,null,0,0]
[null,"Acoustical Fencing","m",null,null,0,0]
[null,"Chain Link Fencing","m",null,null,0,0]
[null,"Other (please list)",null,null,null,0,0]
[]
[null,"Subtotal: Landscaping",null,null,null,{"$f":"SUM(F151:F162)","v":0},{"$f":"SUM(G151:G162)","v":0}]
[]
[null,"Subtotal Construction Costs",null,null,null,{"$f":"SUM(F16,F28,F50,F76,F107,F120,F138,F147,F163)","v":0}]
[]
[null,"H.S.T - 13%",null,null,null,{"$f":"F165*0.13","v":0}]
[null,"City Rebate - 11.24%",null,null,null,{"$f":"0.1124*F165","v":0}]
[]
[null,"HST to be Paid",null,null,null,{"$f":"F167-F168","v":0}]
[]
[null,"Total Construction Costs",null,null,null,{"$f":"SUM(F165,F170)","v":0}]
[]
[null,"*DAAP Fee: 3.70% of Subtotal - Pre H.S.T.",null,null,null,{"$f":"SUM(F138,F120,F107,F76,F50,F28,F16)*0.037","v":0}]
[]
[null,"Total of Security (inclusive of HST)",null,null,null,{"$f":"SUM(G76,G147,G163)*1.0176","v":0}]
[]
[null,"I certify these engineering costs to be the current estimated costs for the works proposed within the approved engineering drawings."]
[null,"Name"]
[null,"_____________________________"]
[null,"Title"]
[]
[]
[null,"Note: Release of any security will require signoff from all other involved parties certifying all works are completed "]
[null,"as per the site plan agreement (i.e.City of Kawartha Lakes Building Division, Parks Canada, Conservation Authority)."]
[null,"Upon completion of the site works, the Engineering department will require as-built information, certification, a statutory "]
[null,"declaration, and Details regarding the cleaning of the Oil/Grit Separator (OGS) as well as installation certification of the"]
[null,"OGS prior to any inspection for security reduction. "]

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