{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Summary","Preconstruction","Construction","Receiving","Condensed","Recommendations"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":1,"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":"Summary","index":0,"n_rows":80,"n_cols":18,"rows_kept":80,"cut":false,"hidden":false,"merged":[[11,6,11,7],[11,14,11,15],[11,16,11,17],[48,6,48,7]]}
[{"$nulls":10},"New Costs Associated with Excess Soil Regulations"]
[]
[{"$nulls":10},"\"An estimated 25 million cubic metres of excess soil is generated in Ontario every year.\"  www.ontario.ca"]
[{"$nulls":10},"https://www.ontario.ca/page/handling-excess-soil#:~:text=About%20excess%20soil,-What%20is%20excess&text=An%20estimated%2025%20million%20cubic,where%20it%20may%20be%20reused."]
[{"$nulls":10},"Stats Can 2003: 120,000km of paved road in Ontario"]
[]
[]
[null,"Residential Development",{"$nulls":7},"Municipal Road"]
[null,"(High rise building)",{"$nulls":7},"(Complete Sewer, Water, and Road Reconstruction)"]
[null,"(Approx. 25,000m3)",{"$nulls":7},"(Approx. 1120m & 53,150m3 excess)"]
[]
[{"$nulls":6},"Per m3",{"$nulls":7},"Per m",null,"Per m3"]
[null,"Preconstruction Costs - Owner's Direct Costs",{"$nulls":4},"Low","High",null,"Preconstruction Costs - Municipality Costs",{"$nulls":4},"Low","High","Low","High"]
[null,null,"Site Characterization & Testing",null,null,null,{"$f":"Construction!C133","v":4.1061999999999994},{"$f":"Construction!C133","v":4.1061999999999994},null,null,"Site Characterization and Testing",null,null,null,{"$f":"Preconstruction!C18","v":48},{"$f":"Preconstruction!D18","v":80},{"$f":"Preconstruction!C19","v":1},{"$f":"Preconstruction!D19","v":1.7}]
[null,null,"Engineering",null,null,null,{"$f":"Construction!C97+Preconstruction!D29","v":0.66351834430856071},{"$f":"Construction!C97*2+Preconstruction!E29","v":1.378777046095955},null,null,"Engineering",null,null,null,{"$f":"Preconstruction!D28","v":1.1160714285714286},{"$f":"Preconstruction!E28","v":4.6875},{"$f":"Preconstruction!D29","v":2.3518344308560677E-2},{"$f":"Preconstruction!E29","v":9.8777046095954849E-2}]
[null,null,"Delays",null,null,null,{"$f":"Construction!C91","v":1.9323999999999999},{"$f":"Construction!C90","v":7.7295999999999996},null,null,"Delays",null,null,null,0.01,1,0.01,0.1]
[null,null,"Total",null,null,null,{"$f":"SUM(G14:G16)","v":6.7021183443085608},{"$f":"SUM(H14:H16)","v":13.214577046095954},null,null,"Total",null,null,null,{"$f":"SUM(O14:O16)","v":49.126071428571429},{"$f":"SUM(P14:P16)","v":85.6875},1.0335183443085607,1.898777046095955]
[]
[null,"Construction Costs - Contractor Tender Price",{"$nulls":7},"Construction Costs - Contractor Tender Price"]
[null,null,"Contractor QP - Fill management plan",null,null,null,{"$f":"Q20","v":0.7},{"$f":"R20","v":1.1000000000000001},null,null,"Contractor QP - Fill management plan, QA",null,null,null,{"$f":"Construction!C18","v":30},{"$f":"Construction!D18","v":50},{"$f":"Construction!C19","v":0.7},{"$f":"Construction!D19","v":1.1000000000000001}]
[null,null,"Excavation inefficiencies",null,null,null,{"$f":"Q21","v":0.72224835371589835},{"$f":"R21","v":1.8889934148635936},null,null,"Excavation inefficiencies",null,null,null,{"$f":"Construction!F30+Construction!D39","v":34.727678571428569},{"$f":"Construction!G30+Construction!E39","v":89.455357142857139},{"$f":"Construction!F31+Construction!D40","v":0.72224835371589835},{"$f":"Construction!G31+Construction!E40","v":1.8889934148635936}]
[null,null,"Load tracking",null,null,null,0.11767110795400003,0.22267110795400002,null,null,"Load tracking",null,null,null,{"$f":"Construction!G52+Construction!C60","v":5.5841244533527696},{"$f":"Construction!H52+Construction!C60","v":10.566936953352769},{"$f":"Construction!I52+Construction!C61","v":0.11767110795400003},{"$f":"Construction!J52+Construction!C61","v":0.22267110795400002}]
[null,null,"Travel Distance",null,null,null,0,10,null,null,"Travel Distance",null,null,null,0,{"$f":"Construction!D72","v":474.55357142857144},0,{"$f":"Construction!D73","v":10}]
[null,null,"Increased tipping fees",null,null,null,0,{"$f":"Construction!C100","v":4}]
[null,null,"Double handling",null,null,null,0,5]
[null,null,"Margin/Overhead (15%)",null,null,null,0.23098791925048473,1.9817496784226392,null,null,"Margin/Overhead (15%)",null,null,null,{"$f":"SUM(O20:O23)*0.15","v":10.546770453717201},{"$f":"SUM(P20:P23)*0.15","v":93.686379828717207},0.23098791925048473,1.9817496784226392]
[null,null,"Total",null,null,null,{"$f":"SUM(G20:G26)","v":1.770907380920383},{"$f":"SUM(H20:H26)","v":24.19341420124023},null,null,"Total",null,null,null,{"$f":"SUM(O20:O26)","v":80.858573478498542},{"$f":"SUM(P20:P26)","v":718.26224535349866},1.770907380920383,15.193414201240234]
[]
[null,"Receiving Site -  Tipping Fees",{"$nulls":7},"Receiving Site -  Tipping Fees"]
[null,null,"Administration",null,null,null,{"$f":"Q30","v":5.2751646284101603E-2},5.2751646284101603E-2,null,null,"Administration",null,null,null,{"$f":"Receiving!D17+Receiving!D25","v":2.5033482142857144},{"$f":"O30","v":2.5033482142857144},{"$f":"Receiving!D18+Receiving!D26","v":5.2751646284101603E-2},{"$f":"Q30","v":5.2751646284101603E-2}]
[null,null,"Registration",null,null,null,{"$f":"Q31","v":1.4999999999999999E-2},{"$f":"R31","v":1.25},null,null,"Registration",null,null,null,{"$f":"Receiving!C32","v":0.33482142857142855},{"$f":"Receiving!D32","v":0.6696428571428571},{"$f":"Receiving!C33","v":1.4999999999999999E-2},{"$f":"Receiving!D33","v":1.25}]
[null,null,"QC/QA",null,null,null,0.25870178739416744,0.25870178739416744,null,null,"QC/QA",null,null,null,{"$f":"Receiving!C40","v":12.276785714285714},{"$f":"O32","v":12.276785714285714},{"$f":"Receiving!C41","v":0.25870178739416744},{"$f":"Q32","v":0.25870178739416744}]
[null,null,"Risk/Margin/Overhead (20%)",null,null,null,6.5290686735653816E-2,0.31229068673565386,null,null,"Risk/Margin/Overhead (20%)",null,null,null,{"$f":"SUM(O30:O32)*0.2","v":3.0229910714285713},{"$f":"SUM(P30:P32)*0.2","v":3.0899553571428573},6.5290686735653816E-2,0.31229068673565386]
[null,null,"Total",null,null,null,{"$f":"SUM(G30:G33)","v":0.39174412041392287},1.8737441204139229,null,null,"Total",null,null,null,{"$f":"SUM(O29:O33)","v":18.137946428571428},{"$f":"SUM(P29:P33)","v":18.53973214285714},{"$f":"SUM(Q29:Q33)","v":0.39174412041392287},{"$f":"SUM(R29:R33)","v":1.8737441204139229}]
[]
[null,"Total per cu.m",{"$nulls":4},{"$f":"G34+G27+G17","v":8.8647698456428667},{"$f":"H34+H27+H17","v":39.281735367750109},null,"Grand Total",{"$nulls":4},{"$f":"O34+O27+O17","v":148.1225913356414},{"$f":"P34+P27+P17","v":822.48947749635579},3.1961698456428667,18.965935367750113]
[]
[null,"Grand Total (25,000 cu.m)",{"$nulls":4},{"$f":"ROUND(G36*25000,0)","v":221619},{"$f":"ROUND(H36*25000,0)","v":982043},null,"25 Million Cubic Meters (annually)",{"$nulls":6},{"$f":"Q36*25000000","v":79904246.141071662},{"$f":"R36*25000000","v":474148384.19375283}]
[]
[{"$nulls":9},"m road","with infrastructure",null,"replacement cycle"]
[null,"Per Apartment",{"$nulls":4},{"$f":"ROUND(G38/172,0)","v":1288},{"$f":"ROUND(H38/172,0)","v":5710},null,120000000,0.5,null,0.01,null,{"$f":"J41*K41*M41*O36","v":88873554.801384836},{"$f":"J41*K41*M41*P36","v":493493686.49781346}]
[]
[null,"50,261 Apts-2021 (Starts per CMHC)",{"$nulls":4},{"$f":"ROUND(G41*50261,0)","v":64736168},{"$f":"ROUND(H41*50261,0)","v":286990310}]
[]
[null,"Residential Development"]
[null,"(Subdivision)"]
[null,"(Approx. 50,000m3)"]
[]
[{"$nulls":6},"Per m3"]
[null,"Preconstruction Costs - Owner's Direct Costs",{"$nulls":4},"Low","High"]
[null,null,"Site Characterization & Testing",null,null,null,{"$f":"Construction!C191","v":3.0998000000000001},{"$f":"Construction!C191","v":3.0998000000000001}]
[null,null,"Engineering",null,null,null,{"$f":"Construction!C155+Preconstruction!C19","v":1.46},{"$f":"Construction!C155*2+Preconstruction!D19","v":2.62}]
[null,null,"Delays",null,null,null,{"$f":"Construction!C149","v":0.96620000000000006},{"$f":"Construction!C148","v":5.7972000000000001}]
[null,null,"Total",null,null,null,{"$f":"SUM(G51:G53)","v":5.5259999999999998},{"$f":"SUM(H51:H53)","v":11.516999999999999}]
[]
[null,"Construction Costs - Contractor Tender Price"]
[null,null,"Contractor QP - Fill management plan",null,null,null,{"$f":"G20","v":0.7},{"$f":"H20","v":1.1000000000000001}]
[null,null,"Excavation inefficiencies",null,null,null,{"$f":"G21","v":0.72224835371589835},1.8889934148635936]
[null,null,"Load tracking",null,null,null,{"$f":"G22","v":0.11767110795400003},0.22267110795400002]
[null,null,"Travel Distance",null,null,null,{"$f":"G23","v":0},10]
[null,null,"Increased tipping fees",null,null,null,{"$f":"G24","v":0},4]
[null,null,"Double handling",null,null,null,{"$f":"G25","v":0},5]
[null,null,"Margin/Overhead (15%)",null,null,null,{"$f":"G26","v":0.23098791925048473},1.9817496784226392]
[null,null,"Total",null,null,null,{"$f":"SUM(G57:G63)","v":1.770907380920383},{"$f":"SUM(H57:H63)","v":24.19341420124023}]
[]
[null,"Receiving Site -  Tipping Fees"]
[null,null,"Administration",null,null,null,{"$f":"Q30","v":5.2751646284101603E-2},{"$f":"R30","v":5.2751646284101603E-2}]
[null,null,"Registration",null,null,null,{"$f":"Q31","v":1.4999999999999999E-2},1.25]
[null,null,"QC/QA",null,null,null,{"$f":"Q32","v":0.25870178739416744},0.25870178739416744]
[null,null,"Risk/Margin/Overhead (20%)",null,null,null,{"$f":"Q33","v":6.5290686735653816E-2},0.31229068673565386]
[null,null,"Total",null,null,null,{"$f":"SUM(G67:G70)","v":0.39174412041392287},1.8737441204139229]
[]
[null,"Total per cu.m",{"$nulls":4},{"$f":"G71+G64+G54","v":7.6886515013343057},{"$f":"H71+H64+H54","v":37.584158321654158}]
[]
[null,"Grand Total (50,000 cu.m)",{"$nulls":4},{"$f":"ROUND(G73*50000,0)","v":384433},{"$f":"ROUND(H73*50000,0)","v":1879208}]
[]
[]
[null,"Per Single Family Home",{"$nulls":4},{"$f":"ROUND(G75/172,0)","v":2235},{"$f":"ROUND(H75/172,0)","v":10926}]
[]
[null,"26,373 SF starts-2021 (per CMHC)",{"$nulls":4},{"$f":"ROUND(G78*26373,0)","v":58943655},{"$f":"ROUND(H78*26373,0)","v":288151398}]

{"sheet":"Preconstruction","index":1,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
["Example"]
[null,"City of London Queens Ave. BRT project.  2022"]
[null,"Details"]
[null,null,"Storm, sanitary and watermain replacement"]
[null,null,"Road reconstruction incl. pavement, curbs, sidewalk and BRT appurtenances"]
[null,null,"Dry utility relocation and replacement"]
[null,null,1120,"m of road way"]
[null,null,53150,"m3 of excess soils"]
[null,"Actual QP Quote"]
[null,119950,"$120,000 allowance for all QP and testing requirements - Actual quote: see attached"]
[null,null,"Meant to include Site Characterization report, soil testing, QP construction management, receiving site evaluation, fill management plan and contractor QA."]
[]
[null,"QP Work"]
[null,"Assume 60% is for preconstruction costs: Site Characterization report and soil testing."]
[null,{"$f":"B11*0.6","v":71970},"+/-25%"]
[null,"Actual","Low Range","High Range"]
[null,{"$f":"B16/C8","v":64.258928571428569},{"$f":"ROUND(B18*0.75,0.1)","v":48},{"$f":"ROUND(B18*1.25,0.1)","v":80},"per m of road way"]
[null,{"$f":"B16/C9","v":1.3540921919096895},{"$f":"ROUND(B19*0.75,1)","v":1},{"$f":"ROUND(B19*1.25,1)","v":1.7},"per m3 of excess soil"]
[]
[]
[null,"Engineering: ","Extra engineering may be required to handle testing or construction activities associated with soils management"]
[null,null,"Examples include:"]
[null,null,null,"traffic control design for insitu testing - Likely to occur (75% probability) - Assume $1000-$5000 to design plan"]
[null,null,null,"special excavation/construction methods - Unlikely to occur (10% probability) - Assume $5000-15000 to design plan"]
[null,null,null,"Low Range","High Range"]
[null,null,null,{"$f":"(1000*0.75)+(5000*0.1)","v":1250},{"$f":"(5000*0.75)+(15000*0.1)","v":5250}]
[null,null,null,{"$f":"D27/C8","v":1.1160714285714286},{"$f":"E27/C8","v":4.6875},"per m"]
[null,null,null,{"$f":"D27/C9","v":2.3518344308560677E-2},{"$f":"E27/C9","v":9.8777046095954849E-2},"per m3"]
[]
[]
[null,"Delays:","Due to the extra preconstruction work required it could cause delays to bring a project to tender. "]
[null,null,"Examples"]
[null,null,null,"Inflationary cost increases - Minimum 2% per annum but this year upwards of 10% due to high oil prices effecting many materials."]
[null,null,null,"Repair costs during the delay period - Ex. Watermain break - Likely $15,000+ per break"]
[null,null,null,"Other indirect costs - damages to residents, businesses, users of facilities."]
[null,null,"This is extremely hard to evaluate but statistically not zero."]

{"sheet":"Construction","index":2,"n_rows":191,"n_cols":10,"rows_kept":191,"cut":false,"hidden":false,"merged":[[48,6,48,7],[48,8,48,9]]}
[]
["Example"]
[null,"City of London Queens Ave. BRT project.  2022"]
[null,"Details"]
[null,null,"Storm, sanitary and watermain replacement"]
[null,null,"Road reconstruction incl. pavement, curbs, sidewalk and BRT appurtenances"]
[null,null,"Dry utility relocation and replacement"]
[null,null,{"$f":"Preconstruction!C8","v":1120},"m of road way"]
[null,null,{"$f":"Preconstruction!C9","v":53150},"m3 of excess soils"]
[]
[null,{"$f":"Preconstruction!B11","v":119950},"$120,000 allowance for all QP and testing requirements"]
[null,null,"Meant to include Site Characterization report, soil testing, QP construction management, receiving site evaluation, fill management plan and contractor QA."]
[]
[null,"QP work"]
[null,"Assume 40% is for construction costs: Fill Management plan creation; on-site QA"]
[null,{"$f":"B11*0.4","v":47980},"+/-25% of actual quote for different projects."]
[null,"Actual","Low Range","High Range"]
[null,{"$f":"B16/C8","v":42.839285714285715},{"$f":"ROUND(B18*0.75,-1)","v":30},{"$f":"ROUND(B18*1.25,-1)","v":50},"per m of road way"]
[null,{"$f":"B16/C9","v":0.90272812793979307},{"$f":"ROUND(B19*0.75,1)","v":0.7},{"$f":"ROUND(B19*1.25,1)","v":1.1000000000000001},"per m3 of excess soil"]
[]
[null,"Excavation Inefficiencies:"]
[null,"Examples"]
[null,null,"Inability to store soil on neighbouring properties or within Right of Way for reuse requires trucking to and from recieiving or Class 1 site.  In the past soil was at times permitted to be side casted or stored in a nearby yard for reuse."]
[{"$nulls":4},"Probability",0.05,0.1]
[{"$nulls":4},"Round trip to storage site",1,"hr"]
[{"$nulls":4},"Truck cost/hr",100]
[{"$nulls":4},"Truck volume",10,"m3"]
[{"$nulls":5},"Low","High"]
[{"$nulls":4},"Total Cost",{"$f":"C9/F27*F26*F25*F24","v":26575},{"$f":"C9/F27*F26*F25*G24","v":53150},"for extra trucking rather than side casting or nearby storage yard."]
[{"$nulls":5},{"$f":"F29/C8","v":23.727678571428573},{"$f":"G29/C8","v":47.455357142857146},"per m of road"]
[{"$nulls":5},{"$f":"F29/C9","v":0.5},{"$f":"G29/C9","v":1},"per m3"]
[]
[null,null,"Mixing, sorting, segregation of soil types and stockpiling on site and traffic control requirements. This slows down production of equipment.   "]
[null,null,null,"5-10% reduction of crew efficiency @ $750/hr is a reasonable assumption."]
[null,null,null,"Probability of occurance is 25-50%."]
[null,null,null,"Crew hours = @$750/hr x 10hr/day x 21 working days/month x 6 months of excess soil management per job"]
[null,null,null,"Low (25%)","High (50%)"]
[null,null,null,{"$f":"750*0.05*0.25*10*21*6","v":11812.5},{"$f":"750*0.1*0.5*10*21*6","v":47250},"Extra costs for excavation inefficiencies."]
[null,null,null,{"$f":"ROUND(D38/C8,0.1)","v":11},{"$f":"ROUND(E38/C8,0.1)","v":42},"per m of road"]
[null,null,null,{"$f":"D38/C9","v":0.22224835371589841},{"$f":"E38/C9","v":0.88899341486359362},"per m3"]
[]
[null,"Load Tracking"]
[null,"Software system","TREAD or SoilFlo"]
[null,null,"$4/day/truck licencing fees"]
[null,null,"$1/hr per truck for hardware and connectivity"]
[null,null,null,"Triaxle dump truck holds 10m3",null,null,{"$f":"C9/10","v":5315},"truck loads"]
[null,null,null,"Round trip 0.75-1.5hr",null,null,{"$f":"G46*0.75","v":3986.25},"hrs",{"$f":"G46*1.5","v":7972.5},"hrs"]
[null,null,null,"Assume 10 hour work days",null,null,{"$f":"G47/10","v":398.625},"days",{"$f":"I47/10","v":797.25},"days"]
[{"$nulls":4},"Low","High","per m",null,"per m3"]
[null,null,null,"licencing",{"$f":"G48*4","v":1594.5},{"$f":"4*I48","v":3189},{"$f":"E50/$C$8","v":1.4236607142857143},{"$f":"F50/$C$8","v":2.8473214285714286},{"$f":"E50/$C$9","v":0.03},{"$f":"F50/$C$9","v":0.06}]
[null,null,null,"Hardware",{"$f":"1*G47","v":3986.25},{"$f":"I47*1","v":7972.5},{"$f":"E51/$C$8","v":3.5591517857142856},{"$f":"F51/$C$8","v":7.1183035714285712},{"$f":"E51/$C$9","v":7.4999999999999997E-2},{"$f":"F51/$C$9","v":0.15}]
[null,null,null,"Total",{"$f":"SUM(E50:E51)","v":5580.75},{"$f":"SUM(F50:F51)","v":11161.5},4.9828124999999996,9.9656249999999993,0.105,0.21]
[]
[null,"Administrative","Administrative and reporting to owner/QP"]
[null,null,3.5,"hrs per month per project"]
[null,null,65000,"Cost for administrator - includes wages, benefits, pension, vacation, wsib, ei, cpp, etc."]
[null,null,null,"Assume 35 hours/wk with 3 weeks vacation or 1715 annual hours"]
[null,null,{"$f":"55000/1715*3.5","v":112.24489795918367},"per month"]
[null,null,{"$f":"C58*6","v":673.46938775510205},"per 6 month project"]
[null,null,{"$f":"C59/C8","v":0.60131195335276966},"per m of road"]
[null,null,{"$f":"C59/C9","v":1.2671107954000038E-2},"per m3 of soil"]
[]
[null,"Travel distance"]
[null,null,"Under the new regulations there will be less sites approved for disposal."]
[null,null,"In the past nearby soil deficient sites didn't need a full QP report prior to acceptance therefore they were ready and waiting on a moments notice. "]
[null,null,null,"Often sites were determined at the time of construction"]
[null,null,null,"To meet the new regulations it would be impossible to prepare the necessary items for sites to receive soils without 3 - 6 months notice."]
[null,null,null,"Tendered contracts don't give that kind of notice prior to construction requirements.  Thus nearby opportunities won't exist."]
[null,null,"Therefore, soils will be sent further to past approved sites.  This further distance travelled can range between and additional 0 min - 1 hour per round trip"]
[null,null,null,"Assume 10m3/load and a triaxle dump truck @ $100/hr"]
[null,null,null,{"$f":"C9/10*100*1","v":531500},"Extra trucking costs for an additional 1 hour of round trip travel time."]
[null,null,null,{"$f":"D71/C8","v":474.55357142857144},"per m of roadway"]
[null,null,null,{"$f":"D71/C9","v":10},"per m3 of soil"]
[]
["Example (high rise)"]
[null,"300 South Carriage - London (172 units)"]
[null,"Details"]
[null,null,"High rise residential construction"]
[null,null,"1 level of underground parking"]
[null,null,25000,"m3 of excess soils"]
[]
[null,null,"Delay costs"]
[null,null,172,"units"]
[null,null,60000,"land price/unit"]
[null,null,{"$f":"C83*C84","v":10320000},"land price"]
[null,null,4,"delay (months)-high delay"]
[null,null,2.9,"5 year mortgage rate/25 year ammortization (March 15th)"]
[null,null,48310,"monthly payment"]
[null,null,{"$f":"C88*C86","v":193240},"total delay cost"]
[null,null,{"$f":"C89/25000","v":7.7295999999999996},"total delay cost/cu.m (25,000 cu.m export high end)"]
[null,null,{"$f":"C90/4","v":1.9323999999999999},"total delay cost/cu.m (25,000 cu.m export low end- 1 month delay)"]
[]
[null,null,"Engineering Costs (low end, high end would be double due to smaller Developer inefficiencies)"]
[null,null,10000,"Additional Developer staff"]
[null,null,4000,"Civil Engineer (includes contract wording, enforcement)"]
[null,null,2000,"Dump site negotiations"]
[null,null,{"$f":"SUM(C94:C96)/25000","v":0.64},"Engineering costs/cu.m"]
[]
[]
[null,null,4,"Additional tipping fees/cu.m - assume $40/load"]
{"$rows_empty":27}
[null,null,"** Confidential - Geotechnical costs for 25,000 cu.m sampling.  Would be worse in a stockpile"]
[]
[null,null,"Sampling and analysis/reports - Project area only"]
[null,null,{"$f":"77650/25000","v":3.1059999999999999},"Sampling and testing per cu.m"]
[null,null,{"$f":"(102655-77650)/25000","v":1.0002},"Reports per cu.m"]
[null,null,{"$f":"C131+C132","v":4.1061999999999994},"total"]
[]
["Example (subdivision)"]
[null,"Summerside Phase 17 - London (174 units)"]
[null,"Details"]
[null,null,50000,"m3 of excess soils"]
[]
[null,null,"Delay costs"]
[null,null,174,"lots"]
[null,null,68000,"land price/SFH ($1,500,000/acre)"]
[null,null,{"$f":"C141*C142","v":11832000},"land price"]
[null,null,6,"delay (months)-high delay"]
[null,null,2.9,"5 year mortgage rate/25 year ammortization (March 15th)"]
[null,null,48310,"monthly payment"]
[null,null,{"$f":"C146*C144","v":289860},"total delay cost"]
[null,null,{"$f":"C147/50000","v":5.7972000000000001},"total delay cost/cu.m (50,000 cu.m export high end)"]
[null,null,{"$f":"C148/6","v":0.96620000000000006},"total delay cost/cu.m (50,000 cu.m export low end- 2 month delay)"]
[]
[null,null,"Engineering Costs (low end, high end would be double due to smaller Developer inefficiencies)"]
[null,null,15000,"Additional Developer staff"]
[null,null,6000,"Civil Engineer (includes contract wording, enforcement)"]
[null,null,2000,"Dump site negotiations"]
[null,null,{"$f":"SUM(C152:C154)/50000","v":0.46},"Engineering costs/cu.m"]
[]
[]
[null,null,4,"Additional tipping fees/cu.m - assume $40/load"]
{"$rows_empty":27}
[null,null,"** Confidential - Geotechnical costs for 50,000 cu.m sampling.  Would be worse in a stockpile"]
[]
[null,null,"Sampling and analysis/reports - Project area only"]
[null,null,{"$f":"129985/50000","v":2.5996999999999999},"Sampling and testing per cu.m"]
[null,null,{"$f":"(154990-129985)/50000","v":0.50009999999999999},"Reports per cu.m"]
[null,null,{"$f":"C189+C190","v":3.0998000000000001},"total"]

{"sheet":"Receiving","index":3,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
["Example"]
[null,"City of London Queens Ave. BRT project.  2022"]
[null,"Details"]
[null,null,"Storm, sanitary and watermain replacement"]
[null,null,"Road reconstruction incl. pavement, curbs, sidewalk and BRT appurtenances"]
[null,null,"Dry utility relocation and replacement"]
[null,null,{"$f":"Preconstruction!C8","v":1120},"m of road way"]
[null,null,{"$f":"Preconstruction!C9","v":53150},"m3 of excess soils"]
[]
[]
[null,"Administration"]
[null,null,"Ticketing"]
[null,null,null,"$0.25/ticket/load"]
[null,null,null,"Assume 10m3/load"]
[null,null,null,{"$f":"C9/10*0.25","v":1328.75},"Extra for the project to produce a ticket per load of excess soil"]
[null,null,null,{"$f":"D16/C8","v":1.1863839285714286},"per m of road"]
[null,null,null,{"$f":"D16/C9","v":2.5000000000000001E-2},"per m3 of soil"]
[]
[null,null,"Administration"]
[null,null,null,"$5000 annual in software & hardware and assume 10 projects per year"]
[null,null,null,65000,"annual labour costs."]
[{"$nulls":4},"Assume 15% of a person to manage new tracking of soils for 10 projects"]
[null,null,null,{"$f":"D22*0.15/10+5000/10","v":1475},"Extra for the project for the receiving site to administer the excess soil"]
[null,null,null,{"$f":"D24/C8","v":1.3169642857142858},"per m of road"]
[null,null,null,{"$f":"D24/C9","v":2.7751646284101598E-2},"per m3 of soil"]
[]
[null,"Registration"]
[null,null,750,"is the minimum cost to register - allows 50,000m3"]
[null,null,null,"Receiving site could be for 50000 or lowest quantity of 600m3"]
[null,null,"Low","High"]
[null,null,{"$f":"C29/C8/2","v":0.33482142857142855},{"$f":"C29/C8","v":0.6696428571428571},"per m of road"]
[null,null,{"$f":"C29/50000","v":1.4999999999999999E-2},{"$f":"C29/600","v":1.25},"per m3 of soil"]
[]
[]
[null,"QA/QC"]
[null,null,"It is a requirement that QA/QC is performed by the receiving site for every 10,000m3"]
[null,null,"This requires $5500 in costs to perform spot excavation and testing of the material"]
[null,null,5500,"Cost to excavate, sample and report QA/QC"]
[null,null,{"$f":"C39*2.5/C8","v":12.276785714285714},"per m of roadway"]
[null,null,{"$f":"C39*2.5/C9","v":0.25870178739416744},"per m3 of soil"]
[]
[]
[null,"Risk"]
[null,null,"The receiving site is taking the risk that soils received are not what they appear.  This requires coverage should QA/QC tests fail."]
[null,null,"This requires at least a 5% margin above overhead and profit margins."]

{"sheet":"Condensed","index":4,"n_rows":78,"n_cols":18,"rows_kept":78,"cut":false,"hidden":false,"merged":[[11,6,11,7],[11,14,11,15],[11,16,11,17],[46,6,46,7]]}
[{"$nulls":10},"New Costs Associated with Excess Soil Regulations"]
[]
[{"$nulls":10},"\"An estimated 25 million cubic metres of excess soil is generated in Ontario every year.\"  www.ontario.ca"]
[{"$nulls":10},"https://www.ontario.ca/page/handling-excess-soil#:~:text=About%20excess%20soil,-What%20is%20excess&text=An%20estimated%2025%20million%20cubic,where%20it%20may%20be%20reused."]
[{"$nulls":10},"Stats Can 2003: 120,000km of paved road in Ontario"]
[]
[]
[null,"Residential Development - 300 South Carriage - London (172 units)",{"$nulls":7},"Municipal Road"]
[null,"(High rise building - one storey of underground parking)",{"$nulls":7},"(Complete Sewer, Water, and Road Reconstruction)"]
[null,"(Approx. 25,000m3 export)",{"$nulls":7},"(Approx. 1120m & 53,150m3 excess)"]
[]
[{"$nulls":6},"Per m3 of Soil",{"$nulls":7},"Per m of Road",null,"Per m3 of Soil"]
[{"$nulls":6},"Low","High",{"$nulls":6},"Low","High","Low","High"]
[null,null,"Site Characterization & Testing",null,null,null,{"$f":"Construction!C133","v":4.1061999999999994},{"$f":"Construction!C133","v":4.1061999999999994},null,null,"Site Characterization and Testing",null,null,null,{"$f":"Preconstruction!C18","v":48},{"$f":"Preconstruction!D18","v":80},{"$f":"Preconstruction!C19","v":1},{"$f":"Preconstruction!D19","v":1.7}]
[null,null,"Engineering",null,null,null,{"$f":"Construction!C97+Preconstruction!D29","v":0.66351834430856071},{"$f":"Construction!C97*2+Preconstruction!E29","v":1.378777046095955},null,null,"Engineering",null,null,null,{"$f":"Preconstruction!D28","v":1.1160714285714286},{"$f":"Preconstruction!E28","v":4.6875},{"$f":"Preconstruction!D29","v":2.3518344308560677E-2},{"$f":"Preconstruction!E29","v":9.8777046095954849E-2}]
[null,null,"Delays",null,null,null,{"$f":"Construction!C91","v":1.9323999999999999},{"$f":"Construction!C90","v":7.7295999999999996},null,null,"Delays",null,null,null,0.01,1,0.01,0.1]
[null,"Preconstruction Costs ",{"$nulls":4},{"$f":"SUM(G14:G16)","v":6.7021183443085608},{"$f":"SUM(H14:H16)","v":13.214577046095954},null,null,"Preconstruction Costs ",null,null,null,{"$f":"SUM(O14:O16)","v":49.126071428571429},{"$f":"SUM(P14:P16)","v":85.6875},1.0335183443085607,1.898777046095955]
[]
[]
[null,"Contractor QP - Fill management plan",{"$nulls":4},{"$f":"Q20","v":0.7},{"$f":"R20","v":1.1000000000000001},null,null,"Contractor QP - Fill management plan",null,null,null,{"$f":"Construction!C18","v":30},{"$f":"Construction!D18","v":50},{"$f":"Construction!C19","v":0.7},{"$f":"Construction!D19","v":1.1000000000000001}]
[null,"Excavation inefficiencies",{"$nulls":4},{"$f":"Q21","v":0.72224835371589835},1.8889934148635936,null,null,"Excavation inefficiencies",null,null,null,{"$f":"Construction!F30+Construction!D39","v":34.727678571428569},{"$f":"Construction!G30+Construction!E39","v":89.455357142857139},{"$f":"Construction!F31+Construction!D40","v":0.72224835371589835},{"$f":"Construction!G31+Construction!E40","v":1.8889934148635936}]
[null,"Load tracking",{"$nulls":4},0.11767110795400003,0.22267110795400002,null,null,"Load tracking",null,null,null,{"$f":"Construction!G52+Construction!C60","v":5.5841244533527696},{"$f":"Construction!H52+Construction!C60","v":10.566936953352769},{"$f":"Construction!I52+Construction!C61","v":0.11767110795400003},{"$f":"Construction!J52+Construction!C61","v":0.22267110795400002}]
[null,"Travel Distance",{"$nulls":4},0,10,null,null,"Travel Distance",null,null,null,0,{"$f":"Construction!D72","v":474.55357142857144},0,{"$f":"Construction!D73","v":10}]
[null,"Increased tipping fees",{"$nulls":4},0,{"$f":"Construction!C100","v":4},null,null,"Increased tipping fees"]
[null,"Double handling",{"$nulls":4},0,5,null,null,"Double handling"]
[null,"Margin/Overhead (15%)",{"$nulls":4},0.23098791925048473,1.9817496784226392,null,null,"Margin/Overhead (15%)",null,null,null,{"$f":"SUM(O20:O23)*0.15","v":10.546770453717201},{"$f":"SUM(P20:P23)*0.15","v":93.686379828717207},0.23098791925048473,1.9817496784226392]
[null,"Construction Costs ",{"$nulls":4},{"$f":"SUM(G20:G26)","v":1.770907380920383},{"$f":"SUM(H20:H26)","v":24.19341420124023},null,null,"Construction Costs ",null,null,null,{"$f":"SUM(O20:O26)","v":80.858573478498542},{"$f":"SUM(P20:P26)","v":718.26224535349866},1.770907380920383,15.193414201240234]
[]
[]
[null,"Administration",{"$nulls":4},{"$f":"Q30","v":5.2751646284101603E-2},5.2751646284101603E-2,null,null,"Administration",null,null,null,{"$f":"Receiving!D17+Receiving!D25","v":2.5033482142857144},{"$f":"O30","v":2.5033482142857144},{"$f":"Receiving!D18+Receiving!D26","v":5.2751646284101603E-2},{"$f":"Q30","v":5.2751646284101603E-2}]
[null,"Registration",{"$nulls":4},1.4999999999999999E-2,1.25,null,null,"Registration",null,null,null,{"$f":"Receiving!C32","v":0.33482142857142855},{"$f":"Receiving!D32","v":0.6696428571428571},{"$f":"Receiving!C33","v":1.4999999999999999E-2},{"$f":"Receiving!D33","v":1.25}]
[null,"QC/QA",{"$nulls":4},0.25870178739416744,0.25870178739416744,null,null,"QC/QA",null,null,null,{"$f":"Receiving!C40","v":12.276785714285714},{"$f":"O32","v":12.276785714285714},{"$f":"Receiving!C41","v":0.25870178739416744},{"$f":"Q32","v":0.25870178739416744}]
[null,"Risk/Margin/Overhead (20%)",{"$nulls":4},6.5290686735653816E-2,0.31229068673565386,null,null,"Risk/Margin/Overhead (20%)",null,null,null,{"$f":"SUM(O30:O32)*0.2","v":3.0229910714285713},{"$f":"SUM(P30:P32)*0.2","v":3.0899553571428573},6.5290686735653816E-2,0.31229068673565386]
[null,"Receiving Site ",{"$nulls":4},{"$f":"SUM(G30:G33)","v":0.39174412041392287},1.8737441204139229,null,null,"Receiving Site ",null,null,null,{"$f":"SUM(O29:O33)","v":18.137946428571428},{"$f":"SUM(P29:P33)","v":18.53973214285714},0.39174412041392287,1.8737441204139229]
[]
[null,"Total per cu.m",{"$nulls":4},{"$f":"G34+G27+G17","v":8.8647698456428667},{"$f":"H34+H27+H17","v":39.281735367750109},null,"Grand Total",{"$nulls":4},{"$f":"O34+O27+O17","v":148.1225913356414},{"$f":"P34+P27+P17","v":822.48947749635579},3.1961698456428667,18.965935367750113]
[]
[null,"Grand Total (25,000 cu.m)",{"$nulls":4},{"$f":"ROUND(G36*25000,0)","v":221619},{"$f":"ROUND(H36*25000,0)","v":982043},null,"25 Million Cubic Meters (annually)",{"$nulls":6},{"$f":"Q36*25000000","v":79904246.141071662},{"$f":"R36*25000000","v":474148384.19375283}]
[]
[{"$nulls":9},"m road","with infrastructure",null,"replacement cycle"]
[null,"Per Apartment",{"$nulls":4},{"$f":"ROUND(G38/172,0)","v":1288},{"$f":"ROUND(H38/172,0)","v":5710},null,120000000,0.5,null,0.01,null,{"$f":"J41*K41*M41*O36","v":88873554.801384836},{"$f":"J41*K41*M41*P36","v":493493686.49781346}]
[]
[null,"50,261 Apts-2021 (Starts per CMHC)",{"$nulls":4},{"$f":"ROUND(G41*50261,0)","v":64736168},{"$f":"ROUND(H41*50261,0)","v":286990310}]
[]
[null,"Residential Development - Summerside Phase 17 - London (174 units)"]
[null,"(Subdivision - approximately 50,000m3 export)"]
[{"$nulls":6},"Per m3 of Soil"]
[{"$nulls":6},"Low","High"]
[null,null,"Site Characterization & Testing",null,null,null,{"$f":"Construction!C191","v":3.0998000000000001},{"$f":"Construction!C191","v":3.0998000000000001}]
[null,null,"Engineering",null,null,null,{"$f":"Construction!C155+Preconstruction!C19","v":1.46},{"$f":"Construction!C155*2+Preconstruction!D19","v":2.62}]
[null,null,"Delays",null,null,null,{"$f":"Construction!C149","v":0.96620000000000006},{"$f":"Construction!C148","v":5.7972000000000001}]
[null,"Preconstruction Costs ",{"$nulls":4},{"$f":"SUM(G49:G51)","v":5.5259999999999998},{"$f":"SUM(H49:H51)","v":11.516999999999999}]
[]
[]
[null,"Contractor QP - Fill management plan",{"$nulls":4},{"$f":"G20","v":0.7},1.1000000000000001]
[null,"Excavation inefficiencies",{"$nulls":4},0.72224835371589835,1.8889934148635936]
[null,"Load tracking",{"$nulls":4},0.11767110795400003,0.22267110795400002]
[null,"Travel Distance",{"$nulls":4},0,10]
[null,"Increased tipping fees",{"$nulls":4},0,4]
[null,"Double handling",{"$nulls":4},0,5]
[null,"Margin/Overhead (15%)",{"$nulls":4},0.23098791925048473,1.9817496784226392]
[null,"Construction Costs ",{"$nulls":4},{"$f":"SUM(G55:G61)","v":1.770907380920383},{"$f":"SUM(H55:H61)","v":24.19341420124023}]
[]
[]
[null,"Administration",{"$nulls":4},{"$f":"Q30","v":5.2751646284101603E-2},5.2751646284101603E-2]
[null,"Registration",{"$nulls":4},1.4999999999999999E-2,1.25]
[null,"QC/QA",{"$nulls":4},0.25870178739416744,0.25870178739416744]
[null,"Risk/Margin/Overhead (20%)",{"$nulls":4},6.5290686735653816E-2,0.31229068673565386]
[null,"Receiving Site ",{"$nulls":4},{"$f":"SUM(G65:G68)","v":0.39174412041392287},1.8737441204139229]
[]
[null,"Total per cu.m",{"$nulls":4},{"$f":"G69+G62+G52","v":7.6886515013343057},{"$f":"H69+H62+H52","v":37.584158321654158}]
[]
[null,"Grand Total (50,000 cu.m)",{"$nulls":4},{"$f":"ROUND(G71*50000,0)","v":384433},{"$f":"ROUND(H71*50000,0)","v":1879208}]
[]
[]
[null,"Per Single Family Home",{"$nulls":4},{"$f":"ROUND(G73/172,0)","v":2235},{"$f":"ROUND(H73/172,0)","v":10926}]
[]
[null,"26,373 SF starts-2021 (per CMHC)",{"$nulls":4},{"$f":"ROUND(G76*26373,0)","v":58943655},{"$f":"ROUND(H76*26373,0)","v":288151398}]

{"sheet":"Recommendations","index":5,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Recommendations"]
["Item","Suggestion","Reasoning"]
["1)","If soils are deemed by QP to be Table 1 then considered clean and acceptable anywhere.  Regulations no longer apply and only municipal restrictions come into play.","Table 1 soils are the cleanest soil types.  Therefore environmental risk logically no longer exists as it pertains to chemical properties.  Municipalities can manage through site alteration permits."]
["2)","If 1) above is not acceptable then need to reduce red tape for Table 1 type soil receiving sites.  Should be similar to EASR process where approvals can be done by a QP in hours not months.","A large part of the costs and strain are that soils will travel further because nearby acceptable sites haven't been approved yet.  Table 1 soils are low environmental risk soils.  Approval of nearby receiving sites should be quick so that owners can take advantage of them.  Positive for climate change issues as well."]
["3)","Reduce samples required within table.","It is our understanding that the soil's characterization can be performed with fewer samples required.  It is also unclear to QPs if the table is to be used for the total volume excavated or for APECs only.  QPs should be able to use discretion for non APEC and a revised, realistic table used for APECs.  Labs and QPs can't keep up with the revised testing requirements and the cost is prohibitive to future home buyers"]
["4)","Consistency across municipalities.","A provincial regulation should create consistency across all municipalities across Ontario.  There is very little consistency how excess soils are dealt with from municipality to municipality.  Some municipalities are very dilligent like Durham and Sarnia.  Others have ignored the regs.  And others are taking the middle ground like London.  This makes it confusing for QPs, contractors and owners to keep it all straight."]
["5)","Allow for greater volumes in gravel pits.","The MNRF expresses to licence holders they are \"not in the filling business\" and discourage receiving excess soils beyond rehabilitation purposes.  Gravel pits are ideal locations for receiving excess soils.  1) They have gone through stringent approval processes for licencing including studies for: archeology, hydrogeology, natural environment, traffic studies, noise and dust, etc.  They are also monitored and inspected regularly by MNRF inspectors.  Filling gravel pits to pregrade levels should be considered to: avoid bowl like grades; encourage farmland retention; efficient utilization of provincial inspectors; and efficient transportation methods with 2 way haulage. Gravel pits are also ideal candidates for Class 1 receiving sites.  This should be encouraged."]
["6)","Reduce reports required to one simple document","Eliminate costly reports that create delays and add costs to housing"]
["7)","Create legislature to make finding  reuse sites and getting reuse site approvals easier instead of more restrictive","O. Reg 406/19 has eliminated many reuse sites due to its cumbersome and complex nature resulting in soil being trucked much further (significant environmental impacts).  Municipalities are reluctant to approve reuse sites due to nimbyism, misunderstanding of soil reuse benefits, staging and construction methodology, risk aversion and inexperienced staff.  Creating standard requirements that allow soil import is required to allow soil to be reused locally."]
["8)","Removal of instrument requirement","Although not identified in the cost summary due to time constraints, subdivision costs and delays are impacted the most.  There is typically a lot more fill/topsoil to be moved/exported on a subdivision and receiving approvals to import/export can take over a year.  For sites with a significant net shortage, import needs to take place over several years as fill becomes available .  This is a good opportunity for both receiving and exporting sites to reuse fill locally.  Oftentimes, developers/landowners aren't in a position to have the servicing design complete and agreements in place years before the subdivision is ready to be constructed and fill gets hauled away that can be reused locally.  Many municipalities don't have site alteration agreements and need the site/subdivision designed/approved  fully prior to import."]
["9)","Remove MECP soil rules pile size restrictions ","2,500 cu.m piles prevent a landowner from stockpiling enough material onsite to complete cut/fill.  Creates drainage issues between the piles.  "]
["10)","Increase max volumes for temp sites (Soil Rules)","More flexibility required at temp sites. Many projects generate more than 10,000 cu.m"]
["11)","Same QP can be used on both project area and reuse site","Avoid duplication of work and associated costs"]
["12)","Liaise with landfills about 2025 change to regulation"]
["13)","Confirm grandfathering in 2023"]
["14)","Review wet soil requirements","This will add significant costs to SWMF clean outs.  Discuss with municipalities, developers, QPs"]
["15)","Less complex regulations that can be understood by all stakeholders in the costruction industry","Smaller Contractors, Municipalities and Landowners don't have the sophistication to understand and comply with this regulation"]