{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Step 1 - Permit Fee Estimate","Step 2- Engineers Cost Estimate","Step 3- Fee and Deposit Summary","<!>","Annual Change of CCI","5% of Costs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,1,8,10],[0,0,0,10],[18,1,29,10],[11,1,15,10],[31,1,31,2]]}
["PERMIT AND ESCROW ESTIMATES FOR DEVELOPMENTS"]
[null,"Form Ver.","2022-01-18"]
[]
["1)","PURPOSE"]
[null,"The purpose of this spreadsheet is to (1) create consistency in unit pricing for Engineer's Cost Estimates and (2) simplify the determination of applicable permit fees and deposits / guarantees. A Developer submitting plans for Engineering Department review and approval, shall submit this spreadsheet as the Engineer's Cost Estimate.  The spreadsheet will be utilized to determine the appropriate permit fees in addition to required deposits and guarantees."]
[]
[]
[]
[]
[]
["2)","INSTRUCTIONS"]
[null,"Fill out this spreadsheet in the order of the steps indicated on the tabs.  Fill in the orange cells with the required information.  These are the only ones that are to be filled.  Insert additional rows as needed for material installation not listed.  Do not remove any lines from the estimate.  Print and submit with the appropriate application."]
[]
[]
[]
[]
[]
["3)","UNIT PRICES"]
[null,"Contained within the tabs are schedules of Unit Prices that were produced by the Saint Louis County Department of Planning and the Department of Highways & Traffic for the computation of subdivision escrows and/or bonds dated March 4, 2008.  The calculated unit prices shown are based on a combination of actual prices, bid tab estimates, the Construction Cost Index (CCI) (St. Louis County Design Criteria Section 74.00), and information provided by various sources, including but not limited to: the Site Improvement Association, Home Builders Association, Saint Louis County Department of Planning, Saint Louis County Department of Public Work, the Saint Louis County Department of Highways and Traffic, etc.  Unit Prices are analyzed during the last quarter of each year to determine the pricing adjustments necessary for the upcoming year to reflect a one (1) year inflationary value.  Where necessary, improvement items not shown on the schedules of Unit Prices shall be submitted with the estimated cost of construction for approval by the Engineering Department.  The schedules of Unit Prices with an W* are unit prices that were not provided or adopted from St. Louis County.  These prices are calculated based on actual prices and bid tab estimates from previous years."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4)","LEGEND"]
[null,"Acronym","Definition"]
[null,"LF","Linear Foot"]
[null,"SF","Square Foot"]
[null,"SY","Square Yard"]
[null,"CY","Cubic Yard"]
[null,"LS","Lump Sump"]

{"sheet":"Step 1 - Permit Fee Estimate","index":1,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[20,2,20,3],[26,2,26,3],[3,3,3,6],[2,3,2,6],[6,2,6,3],[13,2,13,3],[9,2,10,3],[11,2,11,3]]}
[]
[]
[null,null,null,{"$f":"'Step 1 - Permit Fee Estimate'!D15","v":0}]
[null,null,null,"Permit Fee Cost Estimate"]
[]
[]
[null,null,"Permit Fee Instructions"]
[null,null,"1. Fill out orange cell information within Permitting Fee Input Table"]
[null,null,"2. Fill out Engineers Cost Estimate Sheet"]
[null,null,"3. Total permitting fee will be based on the combination of Grading and Construction permitting unless permits are issued separately."]
[]
[null,null,"4. Hover over cells with red triangles in the top right corner as they provide additional refences and instructions."]
[]
[null,null,"Permitting Fee Input Table"]
[null,null,"Development Name"]
[null,null,"Development Type"]
[null,null,"Acres Disturbed"]
[null,null,{"$f":"IF(D16=\"Residential\",\"# of Lots\",\"# of Lots - N/A\")","v":"# of Lots - N/A"}]
[null,null,"Total Cost of Public Improvements",{"$f":"SUM('Step 2- Engineers Cost Estimate'!I207:I213)","v":0}]
[]
[null,null,{"$f":"IF(D17>=2.28,\"Grading Permit\",\"Grading Permit - N/A\")","v":"Grading Permit - N/A"}]
[null,null,"Base Fee",150]
[null,null,"$10 per Acre Disturbed",{"$f":"IF(D16=\"Non-Residential\",D17*10,0)","v":0}]
[null,null,"$10 per Residential Lot",{"$f":"IF(D16=\"Residential\",D18*10,0)","v":0}]
[null,null,null,{"$f":"IF(D17>=0.459,SUM(D22:D24),\"N/A - Site is less than 20,000 SF\")","v":"N/A - Site is less than 20,000 SF"}]
[]
[null,null,{"$f":"IF(D19>=0,\"Construction Permit - N/A\",\"Construction Permit\")","v":"Construction Permit - N/A"}]
[null,null,"2% Cost of Public Improvements",{"$f":"0.02*D19","v":0}]
[null,null,"Engineer Review Credit",{"$f":"-IF(D16=\"Residential\",150+(10*D18),150+(10*D17))","v":-150}]
[null,null,null,{"$f":"IF(D19=0,\"N/A - No Public Improvements\",IF(SUM(D28:D29)>0,SUM(D28:D29),0))","v":"N/A - No Public Improvements"}]

{"sheet":"Step 2- Engineers Cost Estimate","index":2,"n_rows":213,"n_cols":9,"rows_kept":213,"cut":false,"hidden":false,"merged":[[5,1,5,2],[155,1,155,2],[160,3,160,6],[197,1,197,2],[84,1,84,2],[195,3,195,6],[21,1,21,2],[33,1,33,2],[56,1,56,2],[163,1,163,2],[20,3,20,6],[205,3,205,6],[204,3,204,8],[202,3,202,6],[2,3,2,8],[208,3,208,6],[32,3,32,6],[54,3,54,6],[83,3,83,6],[153,3,153,6],[3,3,3,8],[209,3,209,6],[211,3,211,6],[212,3,212,6],[206,3,206,6],[207,3,207,6],[210,3,210,6]]}
[]
[]
[null,null,null,{"$f":"'Step 1 - Permit Fee Estimate'!D15","v":0}]
[null,null,null,"Improvements Cost Estimate"]
[null,null,"UNIT DESCRIPTION","UNIT PRICE","UNIT","ADD. COST","NO. OF UNITS",null,"TOTAL"]
[null,"Sediment and Erosion Control"]
[null,null,"Erosion Control - Apartments / Condominiums (vegetation)",{"$f":"311*('Annual Change of CCI'!C47)","v":461.86541090515357},"Unit",{"$f":"2480*('Annual Change of CCI'!C47)","v":3683.0425049671408},null,null,{"$f":"IF(G7>0,F7+(D7*G7),0)","v":0}]
[null,null,"Erosion Control - Industrial / Commercial (vegetation)",{"$f":"1860*('Annual Change of CCI'!C47)","v":2762.2818787253555},"Acre",{"$f":"1550*('Annual Change of CCI'!C47)","v":2301.901565604463},null,null,0]
[null,null,"Erosion Control - Residential (vegetation)",{"$f":"372*('Annual Change of CCI'!C47)","v":552.45637574507111},"Lot",{"$f":"1240*('Annual Change of CCI'!C47)","v":1841.5212524835704},null,null,0]
[null,null,"Siltation Control - Apartments (silt fence, silt basins, check dams, etc.)",{"$f":"56*('Annual Change of CCI'!C47)","v":83.165475918612856},"Unit",{"$f":"2480*('Annual Change of CCI'!C47)","v":3683.0425049671408},null,null,0]
[null,null,"Siltation Control - Non-Residential (silt fence, silt basins, check dams, etc.)",{"$f":"774*('Annual Change of CCI'!C47)","v":1149.4656850179706},"Acre",{"$f":"3110*('Annual Change of CCI'!C47)","v":4618.6541090515357},null,null,0]
[null,null,"Siltation Control - Residential (silt fence, silt basins, check dams, etc.)",{"$f":"158*('Annual Change of CCI'!C47)","v":234.64544991322913},"Lot",{"$f":"2480*('Annual Change of CCI'!C47)","v":3683.0425049671408},null,null,0]
[null,null,"Seeding - Common Ground",{"$f":"0.62*('Annual Change of CCI'!C47)","v":0.92076062624178523},"SY",null,null,null,{"$f":"IF(G13>0,F13+(D13*G13),0)","v":0}]
[null,null,"Sodding - Common Ground",{"$f":"8.3*('Annual Change of CCI'!C47)","v":12.326311609365835},"SY",null,null,null,0]
[null,"W*","Temporary Silt Basin - Outfall Structure",{"$f":"5193*('Annual Change of CCI'!D47)","v":5787.5692249736394},"Each",null,null,null,0]
[null,"W*","Temporary Silt Basin - Riser Pipe",{"$f":"10.386*('Annual Change of CCI'!D47)","v":11.575138449947277},"LF",null,null,null,0]
[null,"W*","Clearing",{"$f":"3115.8*('Annual Change of CCI'!D47)","v":3472.5415349841837},"Acres",null,null,null,{"$f":"IF(G17>0,F17+(D17*G17),0)","v":0}]
[null,"W*","Construction Entrance / Wash Down Pad / Parking",{"$f":"25.965*('Annual Change of CCI'!D47)","v":28.937846124868194},"SY",null,null,null,{"$f":"IF(G18>0,F18+(D18*G18),0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G19>0,F19+(D19*G19),0)","v":0}]
[]
[null,null,null,"Sediment and Erosion Control",null,null,null,null,{"$f":"SUM(I7:I20)","v":0}]
[null,"Grading"]
[null,null,"Rock Excavation",{"$f":"24.4*('Annual Change of CCI'!C47)","v":36.236385935967029},"CY",null,null,null,{"$f":"IF(G23>0,F23+(D23*G23),0)","v":0}]
[null,null,"Retaining Wall - Concrete",{"$f":"912*('Annual Change of CCI'!C47)","v":1354.4091792459808},"CY",null,null,null,0]
[null,null,"Retaining Wall - Large Panel Wall System",{"$f":"61.5*('Annual Change of CCI'!C47)","v":91.333513732048047},"SF",null,null,null,0]
[null,null,"Retaining Wall - Precast Concrete Block Wall",{"$f":"20.5*('Annual Change of CCI'!C47)","v":30.444504577349349},"SF",null,null,null,0]
[null,"W*","Horz Boring - Mobilization",{"$f":"5193*('Annual Change of CCI'!D47)","v":5787.5692249736394},"Each",null,null,null,{"$f":"IF(G27>0,F27+(D27*G27),0)","v":0}]
[null,"W*","Horz Boring - Bore Pit (Excavation and Backfilling)",{"$f":"51.93*('Annual Change of CCI'!D47)","v":57.875692249736389},"CY",null,null,null,{"$f":"IF(G28>0,F28+(D28*G28),0)","v":0}]
[null,"W*","Horz Boring - Casing Pipe",{"$f":"25.965*('Annual Change of CCI'!D47)","v":28.937846124868194},"LF",null,null,null,{"$f":"IF(G29>0,F29+(D29*G29),0)","v":0}]
[null,"W*","Horz Boring - Restoration (vegetation)",{"$f":"8.62038*('Annual Change of CCI'!D47)","v":9.6073649134562427},"SY",null,null,null,{"$f":"IF(G30>0,F30+(D30*G30),0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Grading",null,null,null,null,{"$f":"SUM(I23:I32)","v":0}]
[null,"Water"]
[null,"W*","Connect to Existing Main",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},"Each",null,null,null,{"$f":"IF(G35>0,F35+(D35*G35),0)","v":0}]
[null,"W*","6\" C-900 HDPE",{"$f":"25.965*('Annual Change of CCI'!D47)","v":28.937846124868194},"LF",null,null,null,{"$f":"IF(G36>0,F36+(D36*G36),0)","v":0}]
[null,"W*","8\" C-906 HDPE",{"$f":"31.158*('Annual Change of CCI'!D47)","v":34.725415349841839},"LF",null,null,null,0]
[null,"W*","Fire Hydrant Assembly",{"$f":"2596.5*('Annual Change of CCI'!D47)","v":2893.7846124868197},"Each",null,null,null,0]
[null,"W*","6\" Bend",{"$f":"233.685*('Annual Change of CCI'!D47)","v":260.44061512381376},"Each",null,null,null,0]
[null,"W*","8\" Bend",{"$f":"285.615*('Annual Change of CCI'!D47)","v":318.31630737355016},"Each",null,null,null,0]
[null,"W*","8\"x6\" Reducer",{"$f":"207.72*('Annual Change of CCI'!D47)","v":231.50276899894556},"Each",null,null,null,0]
[null,"W*","6\" Valve Box w/ Valve",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},"Each",null,null,null,0]
[null,"W*","8\" Valve Box w/ Valve",{"$f":"727.02*('Annual Change of CCI'!D47)","v":810.25969149630942},"Each",null,null,null,0]
[null,"W*","8\"x8\" Tee",{"$f":"363.51*('Annual Change of CCI'!D47)","v":405.12984574815471},"Each",null,null,null,0]
[null,"W*","Tracer Wire",{"$f":"1.0386*('Annual Change of CCI'!D47)","v":1.1575138449947278},"LF",null,null,null,0]
[null,"W*","Thrust Block",{"$f":"155.79*('Annual Change of CCI'!D47)","v":173.62707674920915},"Each",null,null,null,0]
[null,"W*","Granular Fill (crossings)",{"$f":"10.386*('Annual Change of CCI'!D47)","v":11.575138449947277},"Ton",null,null,null,0]
[null,"W*","Jetting",{"$f":"1.0386*('Annual Change of CCI'!D47)","v":1.1575138449947278},"LF",null,null,null,0]
[null,"W*","Location Markers",{"$f":"51.93*('Annual Change of CCI'!D47)","v":57.875692249736389},"Each",null,null,null,0]
[null,"W*","Backflow Preventer",{"$f":"3115.8*('Annual Change of CCI'!D47)","v":3472.5415349841837},"Each",null,null,null,0]
[null,"W*","Bacteria Test",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},"Each",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},null,null,0]
[null,"W*","Leakage Test",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},"Each",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},null,null,0]
[null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Water",null,null,null,null,{"$f":"SUM(I35:I54)","v":0}]
[]
[null,"Sanitary"]
[null,"W*","42\" Manhole - Precast",{"$f":"1850*('Annual Change of CCI'!E47)","v":2013.5399504939996},"Each",null,null,null,{"$f":"IF(G58>0,(D58*G58)+F58,0)","v":0}]
[null,"W*","48\" Manhole - Precast",{"$f":"2000*('Annual Change of CCI'!E47)","v":2176.7999464799996},"Each",null,null,null,{"$f":"IF(G59>0,(D59*G59)+F59,0)","v":0}]
[null,"W*","60\" Manhole - Precast",{"$f":"2250*('Annual Change of CCI'!E47)","v":2448.8999397899997},"Each",null,null,null,0]
[null,"W*","Manhole - Cast-in-Place (dog-house)",{"$f":"2250*('Annual Change of CCI'!E47)","v":2448.8999397899997},"Each",null,null,null,0]
[null,"W*","8\" PVC Pipe",{"$f":"14.5404*('Annual Change of CCI'!D47)","v":16.205193829926191},"LF",null,null,null,0]
[null,"W*","10\" PVC Pipe",{"$f":"15.579*('Annual Change of CCI'!D47)","v":17.362707674920919},"LF",null,null,null,0]
[null,"W*","8\" DIP",{"$f":"41.544*('Annual Change of CCI'!D47)","v":46.300553799789107},"LF",null,null,null,0]
[null,"W*","10\" DIP",{"$f":"46.737*('Annual Change of CCI'!D47)","v":52.088123024762751},"LF",null,null,null,0]
[null,"W*","8\"x6\" wyes",{"$f":"31.158*('Annual Change of CCI'!D47)","v":34.725415349841839},"Each",null,null,null,0]
[null,"W*","Grease Interceptor",{"$f":"4154.4*('Annual Change of CCI'!D47)","v":4630.0553799789113},"Each",null,null,null,{"$f":"IF(G67>0,(D67*G67)+F67,0)","v":0}]
[null,"W*","Granular Fill (crossings and bedding)",{"$f":"10.386*('Annual Change of CCI'!D47)","v":11.575138449947277},"Ton",null,null,null,0]
[null,"W*","Jetting",{"$f":"1.5579*('Annual Change of CCI'!D47)","v":1.7362707674920919},"LF",null,null,null,0]
[null,"W*","Concrete Encasement/Cradle",{"$f":"207.72*('Annual Change of CCI'!D47)","v":231.50276899894556},"CY",null,null,null,0]
[null,"W*","Connect to Existing Main",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},"Each",null,null,null,0]
[null,"W*","Connect to Existing Structure",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},"Each",null,null,null,0]
[null,"W*","Force Main - 2\" HDPE (& bends, fittings, valves)",{"$f":"46.737*('Annual Change of CCI'!D47)","v":52.088123024762751},"LF",null,null,null,0]
[null,"W*","Force Main - 6\" HDPE (& bends, fittings, valves)",{"$f":"57.123*('Annual Change of CCI'!D47)","v":63.663261474710026},"LF",null,null,null,0]
[null,"W*","Force Main - Lift Station (& associated construction)",{"$f":"311580*('Annual Change of CCI'!D47)","v":347254.15349841834},"LS",null,null,null,0]
[null,"W*","Force Main - Air Release Valves",{"$f":"623.16*('Annual Change of CCI'!D47)","v":694.50830699683661},"Each",null,null,null,0]
[null,"W*","Force Main - Location Markers",{"$f":"41.544*('Annual Change of CCI'!D47)","v":46.300553799789107},"LF",null,null,null,0]
[null,"W*","Force Main - Tracer Wire",{"$f":"1.0386*('Annual Change of CCI'!D47)","v":1.1575138449947278},"LF",null,null,null,0]
[null,"W*","Force Main - Leakage Test",{"$f":"51.93*('Annual Change of CCI'!D47)","v":57.875692249736389},"Run",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},null,null,0]
[null,"W*","Pressure and Vacuum Test",{"$f":"20.772*('Annual Change of CCI'!D47)","v":23.150276899894553},"Run",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},null,null,0]
[null,"W*","Mandrel Test",{"$f":"10.386*('Annual Change of CCI'!D47)","v":11.575138449947277},"Run",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},null,null,0]
[null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Sanitary",null,null,null,null,{"$f":"SUM(I58:I83)","v":0}]
[null,"Storm"]
[null,null,"12\" Flared End Section",{"$f":"517*('Annual Change of CCI'!C47)","v":767.79555446290794},"Each",null,null,null,{"$f":"IF(G86>0,(D86*G86)+F86,0)","v":0}]
[null,null,"15\" Flared End Section",{"$f":"569*('Annual Change of CCI'!C47)","v":845.02063924447702},"Each",null,null,null,{"$f":"IF(G87>0,(D87*G87)+F87,0)","v":0}]
[null,null,"18\" Flared End Section",{"$f":"621*('Annual Change of CCI'!C47)","v":922.2457240260461},"Each",null,null,null,{"$f":"IF(G88>0,(D88*G88)+F88,0)","v":0}]
[null,null,"21\" Flared End Section",{"$f":"673*('Annual Change of CCI'!C47)","v":999.47080880761519},"Each",null,null,null,0]
[null,null,"24\" Flared End Section",{"$f":"724*('Annual Change of CCI'!C47)","v":1075.2107958049232},"Each",null,null,null,0]
[null,null,"27\" Flared End Section",{"$f":"828*('Annual Change of CCI'!C47)","v":1229.6609653680616},"Each",null,null,null,0]
[null,null,"30\" Flared End Section",{"$f":"931*('Annual Change of CCI'!C47)","v":1382.6260371469386},"Each",null,null,null,0]
[null,null,"33\" Flared End Section",{"$f":"1294*('Annual Change of CCI'!C47)","v":1921.7165328336614},"Each",null,null,null,0]
[null,null,"36\" Flared End Section",{"$f":"1347*('Annual Change of CCI'!C47)","v":2000.4267153994913},"Each",null,null,null,0]
[null,null,"42\" Flared End Section",{"$f":"1552*('Annual Change of CCI'!C47)","v":2304.8717611729849},"Each",null,null,null,0]
[null,null,"48\" Flared End Section",{"$f":"1763*('Annual Change of CCI'!C47)","v":2618.2273936520442},"Each",null,null,null,0]
[null,null,"54\" Flared End Section",{"$f":"1865*('Annual Change of CCI'!C47)","v":2769.7073676466603},"Each",null,null,null,0]
[null,null,"60\" Flared End Section",{"$f":"2383*('Annual Change of CCI'!C47)","v":3538.988019893829},"Each",null,null,null,0]
[null,null,"66\" Flared End Section",{"$f":"2798*('Annual Change of CCI'!C47)","v":4155.303600362121},"Each",null,null,null,0]
[null,null,"72\" Flared End Section",{"$f":"3418*('Annual Change of CCI'!C47)","v":5076.0642266039058},"Each",null,null,null,0]
[null,null,"Toe Wall",{"$f":"207*('Annual Change of CCI'!C47)","v":307.41524134201541},"CY",null,null,null,0]
[null,null,"12\" Headwall",{"$f":"1219*('Annual Change of CCI'!C47)","v":1810.3341990140905},"Each",null,null,null,0]
[null,null,"15\" Headwall",{"$f":"1245*('Annual Change of CCI'!C47)","v":1848.9467414048752},"Each",null,null,null,0]
[null,null,"18\" Headwall",{"$f":"1255*('Annual Change of CCI'!C47)","v":1863.7977192474846},"Each",null,null,null,0]
[null,null,"21\" Headwall",{"$f":"1300*('Annual Change of CCI'!C47)","v":1930.6271195392269},"Each",null,null,null,0]
[null,null,"24\" Headwall",{"$f":"1347*('Annual Change of CCI'!C47)","v":2000.4267153994913},"Each",null,null,null,0]
[null,null,"27\" Headwall",{"$f":"1435*('Annual Change of CCI'!C47)","v":2131.1153204144543},"Each",null,null,null,0]
[null,null,"30\" Headwall",{"$f":"1609*('Annual Change of CCI'!C47)","v":2389.5223348758586},"Each",null,null,null,0]
[null,null,"33\" Headwall",{"$f":"1747*('Annual Change of CCI'!C47)","v":2594.4658291038691},"Each",null,null,null,0]
[null,null,"36\" Headwall",{"$f":"1947*('Annual Change of CCI'!C47)","v":2891.4853859560576},"Each",null,null,null,0]
[null,null,"42\" Headwall",{"$f":"2070*('Annual Change of CCI'!C47)","v":3074.1524134201536},"Each",null,null,null,0]
[null,null,"48\" Headwall",{"$f":"2280*('Annual Change of CCI'!C47)","v":3386.0229481149518},"Each",null,null,null,0]
[null,null,"54\" Headwall",{"$f":"2434*('Annual Change of CCI'!C47)","v":3614.7280068911373},"Each",null,null,null,0]
[null,null,"60\" Headwall",{"$f":"2665*('Annual Change of CCI'!C47)","v":3957.7855950554153},"Each",null,null,null,0]
[null,null,"66\" Headwall",{"$f":"2952*('Annual Change of CCI'!C47)","v":4384.008659138306},"Each",null,null,null,0]
[null,null,"72\" Headwall",{"$f":"3157*('Annual Change of CCI'!C47)","v":4688.4537049117998},"Each",null,null,null,0]
[null,null,"12\" RCP",{"$f":"34*('Annual Change of CCI'!C47)","v":50.493324664872091},"LF",null,null,null,0]
[null,null,"15\" RCP",{"$f":"38*('Annual Change of CCI'!C47)","v":56.433715801915866},"LF",null,null,null,0]
[null,null,"18\" RCP",{"$f":"40*('Annual Change of CCI'!C47)","v":59.403911370437754},"LF",null,null,null,0]
[null,null,"21\" RCP",{"$f":"44*('Annual Change of CCI'!C47)","v":65.34430250748153},"LF",null,null,null,0]
[null,null,"24\" RCP",{"$f":"50*('Annual Change of CCI'!C47)","v":74.254889213047193},"LF",null,null,null,0]
[null,null,"27\" RCP",{"$f":"52*('Annual Change of CCI'!C47)","v":77.22508478156908},"LF",null,null,null,0]
[null,null,"30\" RCP",{"$f":"55*('Annual Change of CCI'!C47)","v":81.680378134351912},"LF",null,null,null,0]
[null,null,"33\" RCP",{"$f":"59*('Annual Change of CCI'!C47)","v":87.620769271395687},"LF",null,null,null,0]
[null,null,"36\" RCP",{"$f":"62*('Annual Change of CCI'!C47)","v":92.076062624178519},"LF",null,null,null,0]
[null,null,"42\" RCP",{"$f":"75*('Annual Change of CCI'!C47)","v":111.38233381957079},"LF",null,null,null,0]
[null,null,"48\" RCP",{"$f":"87*('Annual Change of CCI'!C47)","v":129.20350723070212},"LF",null,null,null,0]
[null,null,"54\" RCP",{"$f":"111*('Annual Change of CCI'!C47)","v":164.84585405296477},"LF",null,null,null,0]
[null,null,"60\" RCP",{"$f":"133*('Annual Change of CCI'!C47)","v":197.51800530670553},"LF",null,null,null,0]
[null,null,"66\" RCP",{"$f":"168*('Annual Change of CCI'!C47)","v":249.49642775583857},"LF",null,null,null,0]
[null,null,"72\" RCP",{"$f":"230*('Annual Change of CCI'!C47)","v":341.57249038001709},"LF",null,null,null,0]
[null,null,"Area Inlet, Single",{"$f":"2070*('Annual Change of CCI'!C47)","v":3074.1524134201536},"Each",null,null,null,0]
[null,null,"Area Inlet, Double",{"$f":"2485*('Annual Change of CCI'!C47)","v":3690.4679938884456},"Each",null,null,null,0]
[null,null,"Area Inlet, Triple",{"$f":"3105*('Annual Change of CCI'!C47)","v":4611.2286201302304},"Each",null,null,null,0]
[null,null,"Manhole",{"$f":"1350*('Annual Change of CCI'!C47)","v":2004.8820087522743},"Each",null,null,null,0]
[null,null,"Curb Inlet, Single",{"$f":"1350*('Annual Change of CCI'!C47)","v":2004.8820087522743},"Each",null,null,null,0]
[null,null,"Curb Inlet, Double",{"$f":"2560*('Annual Change of CCI'!C47)","v":3801.8503277080163},"Each",null,null,null,0]
[null,null,"Curb Inlet, Triple",{"$f":"2700*('Annual Change of CCI'!C47)","v":4009.7640175045485},"Each",null,null,null,0]
[null,null,"Box Culvert",{"$f":"727*('Annual Change of CCI'!C47)","v":1079.6660891577062},"CY",null,null,null,0]
[null,"W*","Junction Chamber",{"$f":"13250*('Annual Change of CCI'!E47)","v":14421.299645429997},"Each",null,null,null,0]
[null,null,"Overflow Structure",{"$f":"6210*('Annual Change of CCI'!C47)","v":9222.4572402604608},"Each",null,null,null,0]
[null,null,"Detention / Retention Basin - Apartments / Condominiums",{"$f":"62*('Annual Change of CCI'!C47)","v":92.076062624178519},"Unit",{"$f":"9330*('Annual Change of CCI'!C47)","v":13855.962327154606},null,null,0]
[null,null,"Detention / Retention Basin - Industrial / Commercial",{"$f":"1238*('Annual Change of CCI'!C47)","v":1838.5510569150485},"Acre",{"$f":"15500*('Annual Change of CCI'!C47)","v":23019.01565604463},null,null,0]
[null,null,"Detention / Retention Basin - Residential",{"$f":"250*('Annual Change of CCI'!C47)","v":371.27444606523596},"Lot",{"$f":"7750*('Annual Change of CCI'!C47)","v":11509.507828022315},null,null,0]
[null,null,"Riprap / Revetment - Heavy Stone (12-24\")",{"$f":"47*('Annual Change of CCI'!C47)","v":69.799595860264361},"SY",null,null,null,0]
[null,null,"Riprap / Revetment - Light Stone (9-12\")",{"$f":"47*('Annual Change of CCI'!C47)","v":69.799595860264361},"SY",null,null,null,0]
[null,"W*","Mandrel Test",{"$f":"10*('Annual Change of CCI'!D47)","v":11.144943625984284},"Run",{"$f":"500*('Annual Change of CCI'!D47)","v":557.24718129921428},null,null,0]
[null,"W*","Jetting",{"$f":"1.5*('Annual Change of CCI'!D47)","v":1.6717415438976428},"LF",null,null,null,0]
[null,null,"Granular Fill",{"$f":"3.7*('Annual Change of CCI'!C47)","v":5.4948618017654924},"CY",null,null,null,0]
[null,null,"Concrete Encasement",{"$f":"220*('Annual Change of CCI'!C47)","v":326.72151253740765},"CY",null,null,null,{"$f":"IF(G150>0,(D150*G150)+F150,0)","v":0}]
[null,"W*","Underdrain",{"$f":"750*('Annual Change of CCI'!E47)","v":816.29997992999984},"Each",null,null,null,{"$f":"IF(G151>0,(D151*G151)+F151,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Storm",null,null,null,null,{"$f":"SUM(I86:I153)","v":0}]
[]
[null,"Water Quality Improvements"]
[null,"W*","Filter or Infiltration BMP ",{"$f":"16*('Annual Change of CCI'!E47)","v":17.414399571839997},"SF",null,null,null,{"$f":"IF(G157>0,(D157*G157)+F157,0)","v":0}]
[null,"W*","Wet Pond ",{"$f":"13.25*('Annual Change of CCI'!E47)","v":14.421299645429997},"SF",null,null,null,{"$f":"IF(G158>0,(D158*G158)+F158,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Water Quality",null,null,null,null,{"$f":"SUM(I157:I160)","v":0}]
[]
[]
[null,"Streets"]
[null,null,"Concrete ADA Curb Ramp with Truncated Domes",{"$f":"1035*('Annual Change of CCI'!C47)","v":1537.0762067100768},"Each",null,null,null,{"$f":"IF(G165>0,(D165*G165)+F165,0)","v":0}]
[null,null,"Concrete Sidewalk - 4\" Thick",{"$f":"4.7*('Annual Change of CCI'!C47)","v":6.9799595860264363},"SF",null,null,null,{"$f":"IF(G166>0,(D166*G166)+F166,0)","v":0}]
[null,null,"Concrete Sidewalk - 6\" Thick (Residential Entrances)",{"$f":"4.9*('Annual Change of CCI'!C47)","v":7.2769791428786252},"SF",null,null,null,0]
[null,null,"Concrete Sidewalk - 7\" Thick (Commercial Entrances)",{"$f":"5.1*('Annual Change of CCI'!C47)","v":7.5739986997308133},"SF",null,null,null,0]
[null,null,"Type 5 Aggregate Base - 4\"",{"$f":"4.4*('Annual Change of CCI'!C47)","v":6.5344302507481533},"SY",null,null,null,0]
[null,null,"Concrete Pavement - 7\" PCC (Non-Reinforced)",{"$f":"35*('Annual Change of CCI'!C47)","v":51.978422449133035},"SY",null,null,null,0]
[null,null,"Concrete Pavement - 8\" PCC (Non-Reinforced)",{"$f":"38.5*('Annual Change of CCI'!C47)","v":57.176264694046338},"SY",null,null,null,0]
[null,null,"Concrete Curb (Integral) - Type \"O\"",10.749510000000001,"LF",null,null,null,0]
[null,null,"Concrete Curb (Integral) - Rolled",{"$f":"8.5*('Annual Change of CCI'!C47)","v":12.623331166218023},"LF",null,null,null,0]
[null,null,"Concrete Curb & Gutter - Type \"O\"",{"$f":"20.7*('Annual Change of CCI'!C47)","v":30.741524134201537},"LF",null,null,null,0]
[null,null,"Concrete Curb & Gutter - Rolled",{"$f":"16.6*('Annual Change of CCI'!C47)","v":24.652623218731669},"LF",null,null,null,0]
[null,"W*","A2 Expansion Joint",{"$f":"519.3*('Annual Change of CCI'!D47)","v":578.75692249736392},"Each",null,null,null,0]
[null,null,"Guard Rail (Steel)",{"$f":"57.4*('Annual Change of CCI'!C47)","v":85.244612816578169},"LF",null,null,null,0]
[null,"W*","Street Name Sign",{"$f":"255.4956*('Annual Change of CCI'!D47)","v":284.74840586870306},"Each",null,null,null,0]
[null,"W*","Stop Sign",{"$f":"207.72*('Annual Change of CCI'!D47)","v":231.50276899894556},"Each",null,null,null,0]
[null,"W*","Yield Sign",{"$f":"207.72*('Annual Change of CCI'!D47)","v":231.50276899894556},"Each",null,null,null,0]
[null,"W*","Speed Limit Sign",{"$f":"181.755*('Annual Change of CCI'!D47)","v":202.56492287407735},"Each",null,null,null,0]
[null,"W*","No Parking Sign",{"$f":"129.825*('Annual Change of CCI'!D47)","v":144.68923062434098},"Each",null,null,null,0]
[null,"W*","End of Road Markers",{"$f":"311.58*('Annual Change of CCI'!D47)","v":347.2541534984183},"Each",null,null,null,0]
[null,"W*","Other Signs",{"$f":"207.72*('Annual Change of CCI'!D47)","v":231.50276899894556},"Each",null,null,null,0]
[null,"W*","Street Lights - Typical",{"$f":"778.95*('Annual Change of CCI'!D47)","v":868.13538374604593},"Each",null,null,null,0]
[null,"W*","Street Lights - Special",{"$f":"1557.9*('Annual Change of CCI'!D47)","v":1736.2707674920919},"Each",null,null,null,0]
[null,null,"Saw Cutting",{"$f":"5.75*('Annual Change of CCI'!C47)","v":8.5393122595004272},"LF",null,null,null,0]
[null,null,"Removal - Concrete Curb & Gutter",{"$f":"30.8*('Annual Change of CCI'!C47)","v":45.741011755237075},"LF",null,null,null,0]
[null,null,"Removal - Concrete Pavement",{"$f":"56.39598*('Annual Change of CCI'!C47)","v":83.753544939224511},"SY",null,null,null,0]
[null,null,"Removal - Concrete Sidewalk",{"$f":"7.3*('Annual Change of CCI'!C47)","v":10.841213825104889},"SF",null,null,null,0]
[null,null,"Removal - Concrete Driveway",{"$f":"49.2*('Annual Change of CCI'!C47)","v":73.06681098563844},"SY",null,null,null,0]
[null,null,"Removal - Residential Temporary Turnaround",{"$f":"4600*('Annual Change of CCI'!C47)","v":6831.449807600342},"Each",null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(G193>0,(D193*G193)+F193,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"Streets",null,null,null,null,{"$f":"SUM(I165:I195)","v":0}]
[]
[null,"Other"]
[null,"W*","As-Builts - Residential",{"$f":"25.965*('Annual Change of CCI'!D47)","v":28.937846124868194},"Lot",{"$f":"3115.8*('Annual Change of CCI'!D47)","v":3472.5415349841837},null,null,{"$f":"IF(G199>0,(G199*D199)+F199,0)","v":0}]
[null,"W*","As-Builts - Non-Residential",{"$f":"155.79*('Annual Change of CCI'!D47)","v":173.62707674920915},"Acre",{"$f":"1557.9*('Annual Change of CCI'!D47)","v":1736.2707674920919},null,null,{"$f":"IF(G200>0,(G200*D200)+F200,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G201>0,(G201*D201)+F201,0)","v":0}]
[]
[null,null,null,"Other",null,null,null,null,{"$f":"SUM(I199:I202)","v":0}]
[]
[null,null,null,"SUMMARY OF COST ESTIMATE"]
[null,null,null,"Sediment and Erosion Control",null,null,null,null,{"$f":"I21","v":0}]
[null,null,null,"Grading",null,null,null,null,{"$f":"I33","v":0}]
[null,null,null,"Water",null,null,null,null,{"$f":"I55","v":0}]
[null,null,null,"Sanitary",null,null,null,null,{"$f":"I84","v":0}]
[null,null,null,"Storm",null,null,null,null,{"$f":"I154","v":0}]
[null,null,null,"Water Quality",null,null,null,null,{"$f":"I161","v":0}]
[null,null,null,"Streets",null,null,null,null,{"$f":"I196","v":0}]
[null,null,null,"Other",null,null,null,null,{"$f":"I203","v":0}]

{"sheet":"Step 3- Fee and Deposit Summary","index":3,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,3,3,4],[2,3,2,4],[13,2,13,4],[19,2,19,4],[7,2,7,3]]}
[]
[]
[null,null,null,{"$f":"'Step 1 - Permit Fee Estimate'!D15","v":0}]
[null,null,null,"Permit Fee and Guarantee Summary"]
[]
[]
[]
[null,null,"Permit Fees"]
[null,null,"Type","Fee Amount"]
[null,null,"Grading Permit Fee",{"$f":"'Step 1 - Permit Fee Estimate'!D25","v":"N/A - Site is less than 20,000 SF"}]
[null,null,"Construction Permit Fee",{"$f":"'Step 1 - Permit Fee Estimate'!D30","v":"N/A - No Public Improvements"}]
[null,null,null,{"$f":"IF('Step 1 - Permit Fee Estimate'!D17>0.459,'Step 1 - Permit Fee Estimate'!D25,0)+IF('Step 1 - Permit Fee Estimate'!D28>0,'Step 1 - Permit Fee Estimate'!D30,0)","v":0}]
[]
[null,null,"Guarantee Deposits Required For Construction and/or Grading Permit(s)"]
[null,null,"Type","Calculation","Deposit Amount"]
[null,null,"Sediment and Erosion Control","110% Sediment and Erosion Control Estimate",{"$f":"('Step 2- Engineers Cost Estimate'!I206)*1.1","v":0}]
[null,null,"Improvements","100% Water Quality and 110% Other Improvements",{"$f":"SUM('Step 2- Engineers Cost Estimate'!I211,(SUM('Step 2- Engineers Cost Estimate'!I207:I210,'Step 2- Engineers Cost Estimate'!I212:I213))*1.1)","v":0}]
[null,null,null,null,{"$f":"IF('Step 1 - Permit Fee Estimate'!D19>0,'Step 3- Fee and Deposit Summary'!E17,0)+IF('Step 1 - Permit Fee Estimate'!D25>0,'Step 3- Fee and Deposit Summary'!E16,0)","v":0}]
[]
[null,null,"Guarantee Deposits Required for Release of Sediment and Erosion Control and Improvements Deposits"]
[null,null,"Type","Calculation","Deposit Amount"]
[null,null,"Maintenance","5% Public Improvements",{"$f":"IF('Step 1 - Permit Fee Estimate'!D16=\"Residential\",(SUM('Step 2- Engineers Cost Estimate'!I207:I210,'Step 2- Engineers Cost Estimate'!I212:I213))*0.05,\"N/A as Non-Residential\")","v":"N/A as Non-Residential"}]
[null,null,"Water Quality","100% Water Quality Improvements",{"$f":"IF('Step 1 - Permit Fee Estimate'!D16=\"Residential\",'Step 2- Engineers Cost Estimate'!I211,\"N/A as Non-Residential\")","v":"N/A as Non-Residential"}]
[null,null,null,null,{"$f":"IF('Step 1 - Permit Fee Estimate'!D16=\"Residential\",E22+E23,0)","v":0}]

{"sheet":"<!>","index":4,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["<DEVELOPMENT TYPE>"]
["Residential"]
["Non-Residential"]
[]
["Yes"]
["No"]

{"sheet":"Annual Change of CCI","index":5,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":true,"merged":[[0,3,0,8],[1,0,1,1],[0,0,0,2]]}
[" St. Louis County Escrow Unit Prices  ",null,null,"W* - Wentzville Cost Based on City Bid Tabs and Cost Estimates"]
["Base Year: ",null,2008,2016,2018]
["Year","Annual Change of CCI","Percent of Base Year Cost","Percent of Base Year Cost","Percent of Base Year Cost"]
[2008,"Base",1]
[2009,3.4000000000000002E-2,{"$f":"C4*(1+B5)","v":1.034}]
[2010,1.4999999999999999E-2,{"$f":"C5*(1+B6)","v":1.0495099999999999}]
[2011,3.9E-2,{"$f":"C6*(1+B7)","v":1.0904408899999998}]
[2012,8.9999999999999993E-3,1.1002548580099996]
[2013,2.4E-2,1.1266609746022396]
[2014,2.9000000000000001E-2,1.1593341428657045]
[2015,2.9000000000000001E-2,1.1929548330088098]
[2016,0.11700000000000001,1.3325305484708405,1]
[2017,2.5000000000000001E-2,1.3658438121826113,{"$f":"D12*(1+$B13)","v":1.0249999999999999}]
[2018,-1E-3,1.3644779683704287,{"$f":"D13*(1+$B14)","v":1.0239749999999999},1]
[2019,1.9E-2,1.3904030497694666,1.0434305249999998,{"$f":"E14*(1+$B15)","v":1.0189999999999999}]
[2020,5.0000000000000001E-3,1.3973550650183137,1.0486476776249996,{"$f":"E15*(1+$B16)","v":1.0240949999999998}]
[2021,1.7999999999999999E-2,1.4225074561886435,1.0675233358222496,1.0425287099999998]
[2022,4.3999999999999997E-2,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2023,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2024,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2025,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2026,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2027,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2028,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2029,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2030,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2031,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2032,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2033,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2034,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2035,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2036,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2037,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2038,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2039,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2040,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2041,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2042,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2043,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2044,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2045,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2046,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2047,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2048,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2049,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
[2050,null,1.4850977842609439,1.1144943625984285,1.0883999732399998]
["Percent Change from Base ",null,1.4850977842609439,1.1144943625984285,1.0883999732399998]

{"sheet":"5% of Costs","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,1,1,3],[4,2,10,2]]}
[]
[null,"Breakdown of Partial Release by Category of Improvement"]
[null,"Category","Calculation","Minimum Deposit Amount"]
[null,"Sediment and Erosion Control","10% Retention Upon Completion of Improvements",{"$f":"('Step 2- Engineers Cost Estimate'!I206)*0.1","v":0}]
[null,"Grading","5% Retention Upon Completion of Category",{"$f":"('Step 2- Engineers Cost Estimate'!I207)*0.05","v":0}]
[null,"Water",null,{"$f":"('Step 2- Engineers Cost Estimate'!I208)*0.05","v":0}]
[null,"Sanitary",null,{"$f":"('Step 2- Engineers Cost Estimate'!I209)*0.05","v":0}]
[null,"Storm ",null,{"$f":"('Step 2- Engineers Cost Estimate'!I210)*0.05","v":0}]
[null,"Water Quality",null,{"$f":"('Step 2- Engineers Cost Estimate'!I211)*0.05","v":0}]
[null,"Streets ",null,{"$f":"('Step 2- Engineers Cost Estimate'!I212)*0.05","v":0}]
[null,"Other",null,{"$f":"('Step 2- Engineers Cost Estimate'!I213)*0.05","v":0}]