{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Instructions & Definitions","Plan and Building Inputs","Engineering Inspection Inputs","Calculated Fees","Without Subs (OTC Permits)","With Subs (Plan & Building)","Minimum Project Values","Accela Options","To Do","Dropdowns","Electric","Comm Revenue Elec Fee","County TCEF","Schools","Stormwater","Water WW","Capital Expansion","Reference ->","Water","pud calculation"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions & Definitions","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[9,1,9,9],[11,1,11,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"*Disclaimer* This fee calculator is only to be used for estimation purposes, actual fees will be assessed at the time the permit application is submitted"]
[]
[null,"The output of this calculator is only as good as the input, if fields are missing or incorrect, the estimate will be further off from expected assessed fees."]
[]
[]
[null,"Step 1: Click the Start new Construction/Remodel Estimation button to start"]

{"sheet":"Plan and Building Inputs","index":1,"n_rows":96,"n_cols":20,"rows_kept":96,"cut":false,"hidden":false,"merged":[[15,3,22,3],[8,3,9,3],[10,3,14,3],[48,1,48,3],[3,3,6,3]]}
[]
[null,"Step 2: Enter the detail of the construction project to estimate the city fees, enter data only in grey cells"]
[]
[null,"Type",null,"Drop down"]
[null,"Sub-Type"]
[null,"Change of Use?"]
[null,"Sub-Type City of Fort Collins"]
[]
[null,"Stock Plan?",null,"Drop down"]
[null,"New Development?"]
[" ","Building Square Ft",null,"Enter Numeric Value"]
[null,"Finished Square Ft"]
[null,"Number of Bedrooms"]
[null,"Number of Units"]
[null,"Valuation",null,null,{"$f":"IF(C15<'Minimum Project Values'!H31,1,0)","v":0}]
[null,"Lot Square Ft",null,"Water, Waste Water and Stormwater fees are based on the details of the Square footage of the lot. If you are unsure of the break out, put the total lot square footage in both \"Lot Square Ft\" and \"Building Ground Level Sq Ft\""]
[null,"Building Ground Level Sq Ft"]
[null,"ROW Square Ft"]
[null,"Parking/Drives/Walks/Patios Sq Ft"]
[null,"Gravel Sq Ft"]
[null,"Private Open Space (Sq ft)"]
[null,"Public Open Space (Sq ft)"]
[null,"Land use square footage check",{"$f":"IF((C22+C21+C19+C20+C18+C17)=C16, \"OK\", \"Update Lot use sq ft\")","v":"OK"}]
[null,"Water Tap Size",null,"3/4 inch is most common residential size"]
[null,"Water Meters Needed",null,"Used for Multi-family"]
[null,"Non-resdiential Water gpd peak demand"]
[null,"Non-residential Wastewater BOD (mg/L)"]
[null,"Non-residential Wastewater TSS (mg/L)"]
[null,"Power Phase"]
[null,"Electrical Amps"]
[null,"Requested Voltage"]
[null,"School District",null,"*South of Trilby = Big Thompson"]
[]
[null,"Options:"]
[null,"Garage Square Feet",0]
[null,"Pole Barn (Post Frame Const) Square Feet",0]
[null,"Carport Square Feet",0]
[null,"Fabric Carport Square Feet",0]
[null,"Metal Carport Square Feet",0]
[null,"Shed Square Feet",0]
[null,"Patio Cover/Deck Square Feet",0]
[null,"Pergola/Sunshade Square Feet",0]
[null,"Basement (Finished) Square Feet",0]
[null,"Basement (Unfinished) Square Feet",0]
[null,"Garden Level (Finished) Square Feet",0]
[null,"Garden Level (Unfinished)",0]
[null,"Finishing Existing Basement",0]
[]
[null,"Step 3: If you don’t have any public infrastructure construction, click \"Calculate Fees\". Otherwise Click \"Continue to Inspection Fees\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"School District",null,null,"Valuation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Landscape Escrow",null,"Police Capital Exp. (Res)","Based on Dwelling Sq Ft."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County Sales/Use Tax",null,"Fire Capital Exp. (Res)","Based on Dwelling Sq Ft."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contractor Licensing",null,"Parkland: Community","Based on Dwelling Sq Ft."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bld Permit/Re-Inspection",null,"Parkland: Neighborhood","Based on Dwelling Sq Ft."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan Check Fee",null,"General Govt. Capt. Exp. (Res)","Based on Dwelling Sq Ft."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fire Capital Expansion",null,"Street Oversizing: Res-Detached","Flat Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City Sales/Use Tax",null,"Stormwater Dev. Review","Based on Lot Sq Ft."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parkland: Neighborhood",null,"Stormwater PIF","Based on Lot Sq Ft."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Larimer County Reg. Road",null,"Water PIF","Based on Lot Sq Ft."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation Capital Expansion",null,"Wasterwater","Flat Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Street voersizing: Contrib & Aid of Constr",null,"Elec: City Sales Tax","Figured by Utilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elec: City Sales Tax",null,"Elec: Comm. Revenue","Figured by Utilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elec: City Sales Tax",null,"Elec: PILOTS","Figured by Utilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elec: Comm. Revenue",null,"Elec: Secondary Service (Service B)","Figured by Utilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elec: PILOTS",null,"Elec: Temp Pedestal","Figured by Utilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elec: Secondary Service (Service B)",null,"Building Permit Fee w/Subs","Based on Permit Value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elec: Temp Pedestal",null,"Plan Review Fee","Based on Permit Value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction Water",null,"FF Permit Fee (Flat Fee)","Flat Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water 6% PILOT Fees",null,"Plan Check Fee w/Stock Plan","$1/$1000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water PIF",null,"City Sales/Use Tax","50% of value * Tax Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Dev Review",null,"Larimer County Reg. Road (Res Detached)","Flat Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Right",null,"County Sales/Use Tax","50% of value * Tax Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Meter",null,"Poudre School District (1-4 Units)","Flat Fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sewer PIF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sewer Dev Rev"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erosion Escrow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floodplain Use Permit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stomeater Dev Review"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stormwater PIF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gen. Govt Capital Exp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Police Capital Expansion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parkland: Community"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contractor Licensing - Engineering"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transporation Dev Review"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trust Account Def Revenue"]

{"sheet":"Engineering Inspection Inputs","index":2,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Step 4: Enter data to calculate estimated Public Infrastructure Inspection Fees"]
[]
["Description (List all Public and applicable *private improvements)","Units of Measure","Estimated Quantity (provided by the project engineer)","Infrastructure construction cost per unit","Total Estimated Infrastructure Cost","Inspection Fee per unit (provided by the City)","Total Inspection Fee"]
["Sanitary Sewer System"]
["Sanitary Sewer Main","L.F.",0,0,{"$f":"C6*D6","v":0},0.7,{"$f":"IF(C6=0,0,IF(C6<=100,70,((C6-100)*F6)+70))","v":0}]
["Manhole","EACH",0,0,{"$f":"C7*D7","v":0},103,{"$f":"C7*F7","v":0}]
["Sewer Service Line Stub","EACH",0,0,{"$f":"C8*D8","v":0},70,{"$f":"C8*F8","v":0}]
["Sewer Connection/Disconnect","EACH",0,0,{"$f":"C9*D9","v":0},35,{"$f":"C9*F9","v":0}]
[null,null,null,null,"Sanitary Sewer Inspection Fees ",null,{"$f":"SUM(G6:G9)","v":0}]
["Water System"]
["Water Main","L.F.",0,0,{"$f":"C12*D12","v":0},0.7,{"$f":"IF(C12=0,0,IF(C12<=100,70,((C12-100)*F12)+70))","v":0}]
["Water Service Line Stub","EACH",0,0,0,70,{"$f":"C13*F13","v":0}]
["Fire Hydrant","EACH",0,0,0,70,0]
["Valves","EACH",0,0,0,70,0]
["Meter Pit (3/4\" )","EACH",0,0,0,35,0]
["Meter Pit (1 1/2\")","EACH",0,0,0,35,0]
["Meter Pit (3\" )","EACH",0,0,0,35,0]
["Water Main (Fire Line)**","L.F.",0,0,0,0.7,{"$f":"IF(C19=0,0,IF(C19<=100,70,((C19-100)*F19)+70))","v":0}]
["Water Fitting ( Bend, Tee, Cross )","EACH",0,0,0,35,{"$f":"C20*F20","v":0}]
["Fireline Fitting ( Bend, Tee, Cross )","EACH",0,0,0,35,{"$f":"C21*F21","v":0}]
["Water Connection/Disconnect","EACH",0,0,0,35,{"$f":"C22*F22","v":0}]
[null,null,null,null,"Water Inspection Fees ",null,{"$f":"SUM(G12:G22)","v":0}]
["Public Storm Sewer System"]
["Reinforced Concrete Pipe","L.F.",0,0,{"$f":"C25*D25","v":0},0.7,{"$f":"IF(C25=0,0,IF(C25<=100,70,((C25-100)*F25)+70))","v":0}]
["Underdrain","L.F.",0,0,0,0.7,{"$f":"IF(C26=0,0,IF(C26<=100,70,((C26-100)*F26)+70))","v":0}]
["Concrete Headwall","L.F.",0,0,0,3.5,{"$f":"IF((C27*F27)=0,0,IF((C27*F27)<=75,75,IF((C27*F27)>75,(C27*F27))))","v":0}]
["Water Quality Outlet Structure","C.Y.",0,0,0,3.5,{"$f":"IF((C28*F28)=0,0,IF((C28*F28)<=75,75,IF((C28*F28)>75,(C28*F28))))","v":0}]
["All Inlet Types","EACH",0,0,0,103,{"$f":"C29*F29","v":0}]
["Manhole","EACH",0,0,0,103,{"$f":"C30*F30","v":0}]
[null,null,null,null,"Public Storm Inspection Fees",null,{"$f":"SUM(G25:G30)","v":0}]
["Street System/ Trench"]
["Grading ","L.S.",0,0,{"$f":"C33*D33","v":0}]
["Asphalt Pavement ","SY",0,0,0,0.45,{"$f":"IF(C34=0,0,IF(C34<=50,70,((C34-50)*F34)+70))","v":0}]
["Concrete Pavement ","SY",0,0,0,0.45,0]
["Colored Concrete Pavement","SY",0,0,0,0.45,0]
["Curb & Gutter","L.F.",0,0,0,1,0]
[" Sidewalk ***","L.F.",0,0,0,1,0]
["Pedestrian Ramps","L.F.",0,0,0,1,0]
["Fire Access Grass Crete","S.Y.",0,0,0,0.45,{"$f":"IF(C40=0,0,IF(C40<=300,103,((C40-300)*F40)+103))","v":0}]
["Gutter Pan","S.Y.",0,0,0,0.45,{"$f":"IF(C41=0,0,IF(C41<=300,103,((C41-300)*F41)+103))","v":0}]
["Drive Approach","S.Y.",0,0,0,0.45,{"$f":"IF(C42=0,0,IF(C42<=300,103,((C42-300)*F42)+103))","v":0}]
["Storm Trench","L.F.",0,0,0,0.7,{"$f":"IF(C43=0,0,IF(C43<=100,70,((C43-100)*F43)+70))","v":0}]
["SewerTrench","L.F.",0,0,0,0.7,{"$f":"IF(C44=0,0,IF(C44<=100,70,((C44-100)*F44)+70))","v":0}]
["Water Trench","L.F.",0,0,0,0.7,{"$f":"IF(C45=0,0,IF(C45<=100,70,((C45-100)*F45)+70))","v":0}]
[null,null,null,null,"Street System Inspection Fees ",null,{"$f":"SUM(G33:G45)","v":0}]
["Excavation Permit"]
["Application","L.S.",0,0,null,null,{"$f":"IF(C48=0, 0, 30)","v":0}]
["Pavement","S.Y.",0,0,{"$f":"C49*D49","v":0},0.45,{"$f":"IF(C49=0,0,IF(C49<=300,103,((C49-300)*F49)+103))","v":0}]
["Potholing","E.A.",0,0,{"$f":"C50*D50","v":0},10,{"$f":"SUM(C50*F50)","v":0}]
["Pavement Impact Fees","S.F.",0,0,null,null,{"$f":"IF(C52<=5,IF(C51=0,0,IF(C51<=100,(C51*3.85),IF(C51<=500,(C51*2.75),IF(C51<=3000,(C51*2.2),IF(C51>3000,(C51*1.65))))))*3,IF(C51=0,0,IF(C51<=100,(C51*3.85),IF(C51<=500,(C51*2.75),IF(C51<=3000,(C51*2.2),IF(C51>3000,(C51*1.65)))))))","v":0}]
["Pavement Age (years)",null,0,0]
[null,null,null,null,"Excavation Permit Fees",null,{"$f":"SUM(G48:G51)","v":0}]
[]
[null,null,null,null,"TOTAL INSPECTION  FEES",null,{"$f":"SUM(G10+G23+G31+G46+G53)","v":0}]
[]
[null,"TOTAL PUBLIC INFRASTRUCTURE COST",null,null,{"$f":"SUM(E5:E52)","v":0}]
[]
[]
[]
["* PRIVATE IMPROVEMENTS REQUIRING CITY INSPECTIONS WILL NEED TO BE INCLUDED. HOWEVER PRIVATE IMPROVEMENTS WILL NOT BE INCLUDED "]
["IN THE TOTAL INFRASTRUCTURE COST FOR BONDING. "]
["** INCLUDES TRENCH PRICE "]
["*** SIDEWALK LENGTH IS INCREASED DUE TO OVERSIZE WIDTH.  STANDARD SIDEWALK INSPECTION FEE WIDTH IS 4.5' "]

{"sheet":"Calculated Fees","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Fee Type","Amount","Links for additional Info"]
[null,"Police Capital Exp",{"$f":"+'Capital Expansion'!P14","v":0},"https://www.fcgov.com/finance/capitalexpansion.php","https://www.fcgov.com/developmentreview/fees.php"]
[null,"Fire Capital Exp",{"$f":"+'Capital Expansion'!O14","v":0},"https://www.fcgov.com/finance/capitalexpansion.php"]
[null,"Parkland: Community",{"$f":"+'Capital Expansion'!N14","v":0},"https://www.fcgov.com/finance/capitalexpansion.php"]
[null,"Parkland: Neighborhood",{"$f":"+'Capital Expansion'!M14","v":0},"https://www.fcgov.com/finance/capitalexpansion.php"]
[null,"General Govt. Capt. Exp. ",{"$f":"+'Capital Expansion'!Q14","v":0},"https://www.fcgov.com/finance/capitalexpansion.php"]
[null,"Transportation Capital Expansion",{"$f":"IF('Plan and Building Inputs'!C6 = \"No\", 0,'Capital Expansion'!R14)","v":0},"https://www.fcgov.com/finance/capitalexpansion.php"]
[null,"Plan Check Fee",{"$f":"IF('Without Subs (OTC Permits)'!C19>0,'Without Subs (OTC Permits)'!G19,(IF('Plan and Building Inputs'!C9=\"Yes\",ROUNDUP('Plan and Building Inputs'!C15/1000,0),'With Subs (Plan & Building)'!G17)))","v":{"$error":"#N/A"}},"https://www.fcgov.com/building/permit-fees-and-taxes"]
[null,"Building Permit Fee",{"$f":"IF('Without Subs (OTC Permits)'!C19>0,'Without Subs (OTC Permits)'!F19,'With Subs (Plan & Building)'!H15)","v":{"$error":"#N/A"}},"https://www.fcgov.com/building/permit-fees-and-taxes"]
[null,"Water PIF",{"$f":"+'Water WW'!P18","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Water Meter",{"$f":"+'Water WW'!S18","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"WSR",{"$f":"+'Water WW'!R18","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Water Dev Rev",{"$f":"+'Water WW'!T18","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Wasterwater PIF",{"$f":"+'Water WW'!U18","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Wasterwater Dev Rev",{"$f":"+'Water WW'!V18","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Sewer PIF",{"$f":"IF(AND('Plan and Building Inputs'!$C$4=\"Residential\",'Plan and Building Inputs'!$C$5=\"New\"),Water!I16,0)","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Stormwater PIF",{"$f":"+Stormwater!T4","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Stormwater Dev. Review",{"$f":"+Stormwater!U4","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Elec: City Sales Tax",{"$f":"+C21*0.0385","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Elec: Comm. Revenue",{"$f":"IF(AND('Plan and Building Inputs'!C5=\"New\",Electric!B32>0),'Comm Revenue Elec Fee'!D36,0)","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Elec: PILOTS",{"$f":"+C21*0.06","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Elec: Secondary Service",{"$f":"IF(AND('Plan and Building Inputs'!C5=\"New\",Electric!B32>0),Electric!B22,0)","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"Elec: Temp Pedestal",{"$f":"IF(AND('Plan and Building Inputs'!C5=\"New\",Electric!B32>0),'Comm Revenue Elec Fee'!D38,0)","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"City Sales/Use Tax",{"$f":"IF('Without Subs (OTC Permits)'!C19>0,'Without Subs (OTC Permits)'!D19,'Plan and Building Inputs'!C15/2*0.0385)","v":0},"https://www.fcgov.com/building/permit-fees-and-taxes"]
[null,"County Sales/Use Tax",{"$f":"IF('Without Subs (OTC Permits)'!C19>0,'Without Subs (OTC Permits)'!E19,'Plan and Building Inputs'!C15/2*0.008)","v":0},"https://www.fcgov.com/building/permit-fees-and-taxes"]
[null,"School District Impact Fee",{"$f":"+Schools!H6","v":0},"https://www.fcgov.com/developmentreview/fees.php"]
[null,"Larimer County Reg. Road",{"$f":"IFERROR(IF('Plan and Building Inputs'!C6=\"No\", 0, 'County TCEF'!O15),0)","v":0},"https://www.larimer.org/sites/default/files/2018_capital_expansion_fees-fees_in_lieu_of_handout.pdf"]
[null,"Electric Fees",{"$f":"+Electric!Q10","v":0},"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
[null,"FF Permit Fee (Flat Fee)",null,"https://www.fcgov.com/building/permit-fees-and-taxes"]
[]
[]
[null,"Total Permit Fees",{"$f":"_xlfn.AGGREGATE(9,6,C3:C30)","v":0}]
[null,"Total Engineering Inspection Fees",{"$f":"+'Engineering Inspection Inputs'!G55","v":0}]
[null,"Total Cost",{"$f":"+C34+C33","v":0}]
[]
[null,"Engineering Escrow Deposit",{"$f":"+'Engineering Inspection Inputs'!E57","v":0},"*Deposit will be returned after final"]

{"sheet":"Without Subs (OTC Permits)","index":4,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
["Type","Sub-Type City of Fort Collins","Project Value","Sales & Use Tax","County Sales & Use Tax","Building Permit Fee","Plan Check Fee","Total Fee"]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Fireplace",{"$f":"IF(B3='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},{"$f":"+C3*(0.0385)/2","v":0},{"$f":"+C3/2*0.0055","v":0},{"$f":"IF(C3=0,0,(IF(C3<=500,25,IF(AND(C3>500,C3<=2000),25+ROUNDUP((C3-500)/100,0)*2.75,IF(AND(C3>2000,C3<=25000),66.25+ROUNDUP((C3-2000)/1000,0)*10.25,IF(AND(C3>25000,C3<=50000),302+ROUNDUP((C3-25000)/1000,0)*8.5,IF(AND(C3>50000,C3<=100000),514.5+ROUNDUP((C3-50000)/1000,0)*6,IF(AND(C3>100000,C3<=500000),814.5+ROUNDUP((C3-100000)/1000,0)*4,IF(AND(C3>500000,C3<=1000000),2414.5+ROUNDUP((C3-500000)/1000,0)*3.5,IF(AND(C3>1000000,C3<=10000000),4164.5+ROUNDUP((C3-1000000)/1000,0)*2.5,26664.5+ROUNDUP((C3-10000000)/1000,0)))))))))))","v":0},{"$f":"IF(AND(A3=\"Commercial (Single Phase)\"),0,IF(AND(C3>0,A3=\"Residential\",IFERROR(MATCH(B3,$A$23:$A$28,0),0)),25,IF(C3<=3000,0,IF(AND(C3>3000,C3<=25000),(66.25+ROUNDUP((C3-2000)/1000,0)*10.25)*0.65,IF(AND(C3>25000,C3<=50000),(302+ROUNDUP((C3-25000)/1000,0)*8.5)*0.65,IF(AND(C3>50000,C3<=100000),(514.5+ROUNDUP((C3-50000)/1000,0)*6)*0.65,IF(AND(C3>100000,C3<=500000),(814.5+ROUNDUP((C3-100000)/1000,0)*4)*0.65,IF(AND(C3>500000,C3<=1000000),(2414.5+ROUNDUP((C3-500000)/1000,0)*3.5)*0.65,IF(AND(C3>1000000,C3<=10000000),(4164.5+ROUNDUP((C3-1000000)/1000,0)*2.5)*0.65,(26664.5+ROUNDUP((C3-10000000)/1000,0))*0.65)))))))))","v":0},{"$f":"+D3+F3+G3","v":0}]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Air Conditioning",{"$f":"IF(B4='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},{"$f":"+C4*(0.0385)/2","v":0},{"$f":"+C4/2*0.0055","v":0},{"$f":"IF(C4=0,0,(IF(C4<=500,25,IF(AND(C4>500,C4<=2000),25+ROUNDUP((C4-500)/100,0)*2.75,IF(AND(C4>2000,C4<=25000),66.25+ROUNDUP((C4-2000)/1000,0)*10.25,IF(AND(C4>25000,C4<=50000),302+ROUNDUP((C4-25000)/1000,0)*8.5,IF(AND(C4>50000,C4<=100000),514.5+ROUNDUP((C4-50000)/1000,0)*6,IF(AND(C4>100000,C4<=500000),814.5+ROUNDUP((C4-100000)/1000,0)*4,IF(AND(C4>500000,C4<=1000000),2414.5+ROUNDUP((C4-500000)/1000,0)*3.5,IF(AND(C4>1000000,C4<=10000000),4164.5+ROUNDUP((C4-1000000)/1000,0)*2.5,26664.5+ROUNDUP((C4-10000000)/1000,0)))))))))))","v":0},0,{"$f":"+D4+F4+G4","v":0}]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Furnace",{"$f":"IF(B5='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},{"$f":"+C5*(0.0385)/2","v":0},{"$f":"+C5/2*0.0055","v":0},0,0,0]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Mechanical",{"$f":"IF(B6='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},{"$f":"+C6*(0.0385)/2","v":0},{"$f":"+C6/2*0.0055","v":0},0,0,0]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Mobile Home",{"$f":"IF(B7='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},{"$f":"+C7*(0.0385)/2","v":0},{"$f":"+C7/2*0.0055","v":0},0,0,0]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Mobile Home Installation",{"$f":"IF(B8='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},0,0,{"$f":"IF(C8>0,25,0)","v":0},0,{"$f":"+D8+F8+G8","v":0},"Flat fee on Mobile home installation"]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Plumbing",{"$f":"IF(B9='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},{"$f":"+C9*(0.0385)/2","v":0},{"$f":"+C9/2*0.0055","v":0},{"$f":"IF(C9=0,0,(IF(C9<=500,25,IF(AND(C9>500,C9<=2000),25+ROUNDUP((C9-500)/100,0)*2.75,IF(AND(C9>2000,C9<=25000),66.25+ROUNDUP((C9-2000)/1000,0)*10.25,IF(AND(C9>25000,C9<=50000),302+ROUNDUP((C9-25000)/1000,0)*8.5,IF(AND(C9>50000,C9<=100000),514.5+ROUNDUP((C9-50000)/1000,0)*6,IF(AND(C9>100000,C9<=500000),814.5+ROUNDUP((C9-100000)/1000,0)*4,IF(AND(C9>500000,C9<=1000000),2414.5+ROUNDUP((C9-500000)/1000,0)*3.5,IF(AND(C9>1000000,C9<=10000000),4164.5+ROUNDUP((C9-1000000)/1000,0)*2.5,26664.5+ROUNDUP((C9-10000000)/1000,0)))))))))))","v":0},{"$f":"IF(AND(A9=\"Commercial (Single Phase)\"),0,IF(AND(C9>0,A9=\"Residential\",IFERROR(MATCH(B9,$A$23:$A$28,0),0)),25,IF(C9<=3000,0,IF(AND(C9>3000,C9<=25000),(66.25+ROUNDUP((C9-2000)/1000,0)*10.25)*0.65,IF(AND(C9>25000,C9<=50000),(302+ROUNDUP((C9-25000)/1000,0)*8.5)*0.65,IF(AND(C9>50000,C9<=100000),(514.5+ROUNDUP((C9-50000)/1000,0)*6)*0.65,IF(AND(C9>100000,C9<=500000),(814.5+ROUNDUP((C9-100000)/1000,0)*4)*0.65,IF(AND(C9>500000,C9<=1000000),(2414.5+ROUNDUP((C9-500000)/1000,0)*3.5)*0.65,IF(AND(C9>1000000,C9<=10000000),(4164.5+ROUNDUP((C9-1000000)/1000,0)*2.5)*0.65,(26664.5+ROUNDUP((C9-10000000)/1000,0))*0.65)))))))))","v":0},0]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Re-Roof",{"$f":"IF(B10='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},0,0,0,0,0]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Sprinkler",{"$f":"IF(B11='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},0,0,0,0,0]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Water Heater",{"$f":"IF(B12='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},0,0,0,0,0]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Sign",{"$f":"IF(B13='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},0,0,0,0,{"$f":"+D13+F13+G13","v":0}]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Shed",{"$f":"IF(B14='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},0,0,0,0,{"$f":"+D14+F14+G14","v":0}]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Electrical",{"$f":"IF(B15='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},0,0,{"$f":"IF(C15=0,0,(IF(C15<=500,25,IF(AND(C15>500,C15<=2000),25+ROUNDUP((C15-500)/100,0)*2.75,IF(AND(C15>2000,C15<=25000),66.25+ROUNDUP((C15-2000)/1000,0)*10.25,IF(AND(C15>25000,C15<=50000),302+ROUNDUP((C15-25000)/1000,0)*8.5,IF(AND(C15>50000,C15<=100000),514.5+ROUNDUP((C15-50000)/1000,0)*6,IF(AND(C15>100000,C15<=500000),814.5+ROUNDUP((C15-100000)/1000,0)*4,IF(AND(C15>500000,C15<=1000000),2414.5+ROUNDUP((C15-500000)/1000,0)*3.5,IF(AND(C15>1000000,C15<=10000000),4164.5+ROUNDUP((C15-1000000)/1000,0)*2.5,26664.5+ROUNDUP((C15-10000000)/1000,0)))))))))))","v":0},0,{"$f":"+D15+F15+G15","v":0}]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Demolition",{"$f":"IF(B16='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},0,0,{"$f":"IF(C16>0,50,IF(C16=0,0,(IF(C16<=500,25,IF(AND(C16>500,C16<=2000),25+ROUNDUP((C16-500)/100,0)*2.75,IF(AND(C16>2000,C16<=25000),66.25+ROUNDUP((C16-2000)/1000,0)*10.25,IF(AND(C16>25000,C16<=50000),302+ROUNDUP((C16-25000)/1000,0)*8.5,IF(AND(C16>50000,C16<=100000),514.5+ROUNDUP((C16-50000)/1000,0)*6,IF(AND(C16>100000,C16<=500000),814.5+ROUNDUP((C16-100000)/1000,0)*4,IF(AND(C16>500000,C16<=1000000),2414.5+ROUNDUP((C16-500000)/1000,0)*3.5,IF(AND(C16>1000000,C16<=10000000),4164.5+ROUNDUP((C16-1000000)/1000,0)*2.5,26664.5+ROUNDUP((C16-10000000)/1000,0))))))))))))","v":0},0,{"$f":"+D16+F16+G16","v":0},"Flat Fee on Demoltion"]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},"Sales Trailer",{"$f":"IF(B17='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$15,0)","v":0},0,0,0,0,0]
[]
[null,"Total OTC Permits",{"$f":"SUM(C3:C18)","v":0},{"$f":"SUMIFS(D3:D17, $C$3:$C$17, \"<>\")","v":0},{"$f":"SUMIFS(E3:E17, $C$3:$C$17, \"<>\")","v":0},{"$f":"SUMIFS(F3:F17, $C$3:$C$17, \"<>\")","v":0},{"$f":"SUMIFS(G3:G17, $C$3:$C$17, \"<>\")","v":0},{"$f":"SUMIFS(H3:H17, $C$3:$C$17, \"<>\")","v":0}]
[]
[]
["Plan Check Fee $25"]
["Sprinkler"]
["Water Heater"]
["Fireplace"]
["Air Conditioning"]
["Furnace"]
["Electrical"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://www.fcgov.com/building/permit-fees-and-taxes"]

{"sheet":"With Subs (Plan & Building)","index":5,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
["Value Plan",null,"Total Valuation","Plan Review","Building Permit Fee w/ Subs","Value","Plan Fee","Permit Fee w/ Subs"]
[]
[{"$f":"+'Plan and Building Inputs'!$C$15","v":0},null,"$1 to $500","None",25,{"$f":"AND(A4<=500,'Plan and Building Inputs'!$C$7=\"Mobile Home\")","v":false},0,25]
[{"$f":"+'Plan and Building Inputs'!$C$15","v":0},null,"$501 to $2,000","None","$25 for the first $500 plus $2.75 for each additional $100 or fraction thereof to and including $2,000",{"$f":"AND(A5>501, A5<=2000)","v":false},0,{"$f":"25+ROUNDUP((A5-500)/100,0)*2.75","v":11.25}]
[{"$f":"+'Plan and Building Inputs'!$C$15","v":0},null,"$2,001 to $3,000","No plan review fee for valuations $3,000 and under.","Use the formula in the column to the left, but take this total times 1.35",{"$f":"AND(A6>2001, A6<=3000)","v":false},0,{"$f":"(66.25+ROUNDUP((A6-2000)/1000,0)*10.25)*1.35","v":61.762500000000003}]
[{"$f":"+'Plan and Building Inputs'!$C$15","v":0},null,"$3,001 to $25,000","Over $3,000 -- $66.25 for the first $2,000 plus $10.25 for each additional $1,000 fraction thereof to and including $25,000. Take this total times 0.65",null,{"$f":"AND(A7>3001, A7<=25000)","v":false},{"$f":"(66.25+ROUNDUP((A7-2000)/1000,0)*10.25)*0.65","v":29.737500000000001},{"$f":"(66.25+ROUNDUP((A7-2000)/1000,0)*10.25)*1.35","v":61.762500000000003}]
[{"$f":"+'Plan and Building Inputs'!$C$15","v":0},null,"$25,001 to $50,000","$302.00 for the first $25,000 plus $8.50 for each additional $1,000 or fraction thereof to and including $50,000.  Take this total times 0.65","Use the formula in the column to the left, but take this total times 1.35",{"$f":"AND(A8>25001, A8<=50000)","v":false},{"$f":"(302+ROUNDUP((A7-25000)/1000,0)*8.5)*0.65","v":58.175000000000004},{"$f":"(302+ROUNDUP((A8-25000)/1000,0)*8.5)*1.35","v":120.825}]
[{"$f":"+'Plan and Building Inputs'!$C$15","v":0},null,"$50,001 to $100,000","$514.50 for the first $50,000 plus $6 for each additional $1,000 or fraction thereof to and including $100,000. Take this total times 0.65","Use the formula in the column to the left, but take this total times 1.35",{"$f":"AND(A9>50001, A9<=100000)","v":false},{"$f":"(514.5+ROUNDUP((A8-50000)/1000,0)*6)*0.65","v":139.42500000000001},{"$f":"(514.5+ROUNDUP((A9-50000)/1000,0)*6)*1.35","v":289.57500000000005}]
[{"$f":"+'Plan and Building Inputs'!$C$15","v":0},null,"$100,001 to $500,000","$814.50 for the first $100,000 plus $4.00 for each additional $1,000 or fraction thereof. Take this total times 0.65","Use the formula in the column to the left, but take this total times 1.35",{"$f":"AND(A10>100001, A10<=500000)","v":false},{"$f":"(814.5+ROUNDUP((A9-100000)/1000,0)*4)*0.65","v":269.42500000000001},{"$f":"(814.5+ROUNDUP((A10-100000)/1000,0)*4)*1.35","v":559.57500000000005}]
[{"$f":"+'Plan and Building Inputs'!$C$15","v":0},null,"$500,001 to $1,000,000","$2414.50 for the first $500,000 plus $3.50 for each additional $1,000 or fraction thereof. Take this total times 0.65","Use the formula in the column to the left, but take this total times 1.35",{"$f":"AND(A11>500001, A11<=1000000)","v":false},{"$f":"(2414.5+ROUNDUP((A10-500000)/1000,0)*3.5)*0.65","v":431.92500000000001},{"$f":"(2414.5+ROUNDUP((A11-500000)/1000,0)*3.5)*1.35","v":897.07500000000005}]
[{"$f":"+'Plan and Building Inputs'!$C$15","v":0},null,"$1,000,001 to $10,000,000","$4,164.50 for the first $1,000,000 plus $2.50 for each additional $1,000 or fraction thereof. Take this total times 0.65","Use the formula in the column to the left, but take this total times 1.35",{"$f":"AND(A12>1000001, A12<=10000000)","v":false},{"$f":"(4164.5+ROUNDUP((A11-1000000)/1000,0)*2.5)*0.65","v":1081.925},{"$f":"(4164.5+ROUNDUP((A12-1000000)/1000,0)*2.5)*1.35","v":2247.0750000000003}]
[{"$f":"+'Plan and Building Inputs'!$C$15","v":0},null,"$10,000,001 and up","$26,664.50 for the first $10,000,000 plus $1.00 for each additional $1,000 or fraction thereof.Take this total times 0.65","Use the formula in the column to the left, but take this total times 1.35",{"$f":"A13>10000001","v":false},{"$f":"(26664.5+ROUNDUP((A12-10000000)/1000,0)*1)*0.65","v":10831.925000000001},{"$f":"(26664.5+ROUNDUP((A13-10000000)/1000,0)*1)*1.35","v":22497.075000000001}]
[]
[null,null,null,null,"Output",null,{"$f":"VLOOKUP(TRUE, $F$2:$H$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(TRUE, $F$2:$H$13,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Extra $12 for Secondary building",null,{"$f":"IF('Plan and Building Inputs'!C7=\"Secondary Building\",12,0)","v":0}]
[null,null,null,null,"Total",null,{"$f":"IF(G16=12,G16,G15)","v":{"$error":"#N/A"}}]

{"sheet":"Minimum Project Values","index":6,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Type","Area","Square Feet","Cost/Sq Ft","Total"]
[null,null,null,null,"Garage",{"$f":"'Plan and Building Inputs'!C35","v":0},37.299999999999997,{"$f":"+G3*F3","v":0}]
[null,null,null,null,"Pole Barn (Post Frame Const)",{"$f":"'Plan and Building Inputs'!C36","v":0},29,{"$f":"+G4*F4","v":0}]
[null,null,null,null,"Carport",{"$f":"'Plan and Building Inputs'!C37","v":0},27.9,0]
[null,null,null,null,"Fabric Carport",{"$f":"'Plan and Building Inputs'!C38","v":0},1.5,0]
[null,null,null,null,"Metal Carport",{"$f":"'Plan and Building Inputs'!C39","v":0},6.5,0]
[null,null,null,null,"Shed",{"$f":"'Plan and Building Inputs'!C40","v":0},17.5,0]
[null,null,null,null,"Patio Cover/Deck",{"$f":"'Plan and Building Inputs'!C41","v":0},22.35,0]
[null,null,null,null,"Pergola/Sunshade",{"$f":"'Plan and Building Inputs'!C42","v":0},11.18,0]
[null,null,null,null,"Basement (Finished)",{"$f":"'Plan and Building Inputs'!C43","v":0},45.3,0]
[null,null,null,null,"Basement (Unfinished)",{"$f":"'Plan and Building Inputs'!C44","v":0},15,0]
[null,null,null,null,"Garden Level (Finished)",{"$f":"'Plan and Building Inputs'!C45","v":0},45.3,0]
[null,null,null,null,"Garden Level (Unfinished)",{"$f":"'Plan and Building Inputs'!C46","v":0},15,0]
[null,null,null,null,"Finishing Existing Basement",{"$f":"'Plan and Building Inputs'!C47","v":0},30.3,0]
[null,null,null,"Single Family - Attached","Less than 1600 sq Finished",{"$f":"IF(AND(D16='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11<1600),'Plan and Building Inputs'!$C$11,0)","v":0},75.900000000000006,0]
[null,null,null,"Single Family - Attached","1600 - 2500 sq ft Finished",{"$f":"IF(AND(D17='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11>1600,'Plan and Building Inputs'!$C$11<2500),'Plan and Building Inputs'!$C$11,0)","v":0},85.9,0]
[null,null,null,"Single Family - Attached","Over 2500 sq ft Finished",{"$f":"IF(AND(D18='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11>2500),'Plan and Building Inputs'!$C$11,0)","v":0},95.9,0]
[null,null,null,"Single Family - Detached","Less than 1600 sq Finished",{"$f":"IF(AND(D19='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11<1600),'Plan and Building Inputs'!$C$11,0)","v":0},75.900000000000006,0]
[null,null,null,"Single Family - Detached","1600 - 2500 sq ft Finished",{"$f":"IF(AND(D20='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11>1600,'Plan and Building Inputs'!$C$11<2500),'Plan and Building Inputs'!$C$11,0)","v":0},85.9,0]
[null,null,null,"Single Family - Detached","Over 2500 sq ft Finished",{"$f":"IF(AND(D21='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11>2500),'Plan and Building Inputs'!$C$11,0)","v":0},95.9,0]
[null,null,null,"Duplex","Less than 1600 sq Finished",{"$f":"IF(AND(D22='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11<1600),'Plan and Building Inputs'!$C$11,0)","v":0},75.900000000000006,0]
[null,null,null,"Duplex","1600 - 2500 sq ft Finished",{"$f":"IF(AND(D23='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11>1600,'Plan and Building Inputs'!$C$11<2500),'Plan and Building Inputs'!$C$11,0)","v":0},85.9,0]
[null,null,null,"Duplex","Over 2500 sq ft Finished",{"$f":"IF(AND(D24='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11>2500),'Plan and Building Inputs'!$C$11,0)","v":0},95.9,0]
[null,null,null,"Multi-Family","Less than 1600 sq Finished",{"$f":"IF(AND(D25='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11<1600),'Plan and Building Inputs'!$C$11,0)","v":0},73.010000000000005,0]
[null,null,null,"Multi-Family","1600 - 2500 sq ft Finished",{"$f":"IF(AND(D26='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11>1600,'Plan and Building Inputs'!$C$11<2500),'Plan and Building Inputs'!$C$11,0)","v":0},83.01,0]
[null,null,null,"Multi-Family","Over 2500 sq ft Finished",{"$f":"IF(AND(D27='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11>2500),'Plan and Building Inputs'!$C$11,0)","v":0},93.01,0]
[null,null,null,"Townhome","Less than 1600 sq Finished",{"$f":"IF(AND(D28='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11<1600),'Plan and Building Inputs'!$C$11,0)","v":0},73.010000000000005,0]
[null,null,null,"Townhome","1600 - 2500 sq ft Finished",{"$f":"IF(AND(D29='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11>1600,'Plan and Building Inputs'!$C$11<2500),'Plan and Building Inputs'!$C$11,0)","v":0},83.01,0]
[null,null,null,"Townhome","Over 2500 sq ft Finished",{"$f":"IF(AND(D30='Plan and Building Inputs'!$C$7,'Plan and Building Inputs'!$C$11>2500),'Plan and Building Inputs'!$C$11,0)","v":0},93.01,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H30)","v":0},"Minimum Value"]
[null,null,null,null,null,null,null,{"$f":"+'Plan and Building Inputs'!C15-'Minimum Project Values'!H31","v":0},"Difference Between entered Valuation and minimum valuation"]

{"sheet":"Accela Options","index":7,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[null,null,"Group","Type","Subtype","Category","Building Permit # used to validate","Comment"]
[null,null,"Building","Addition","Commercial","na","B1801026","Off captial expansion"]
[null,null,"Building","Addition","Residential","na","B1802186","X"]
[null,null,"Building","Alteration","Commercial","CFB","looks like we don't do these anymore"]
[null,null,"Building","Alteration","Commercial","General","B1803506","X"]
[null,null,"Building","Alteration","Commercial","Minor","B1800398","X"]
[null,null,"Building","Alteration","Residential","General","B1803867","X"]
[null,null,"Building","Alteration","Residential","Minor","B1803846","Slightly off on Building Pemit fee 52.31. I'm not sure how they are coming up with 52.31. OK otherwise. This is the only one of this type that I could find"]
[null,null,"Building","Minor Permit","Awning","na","B1800227","X"]
[null,null,"Building","Minor Permit","Commercial","Electric sprinkler Control Clock","B1705001","X"]
[null,null,"Building","Minor Permit","Commercial","Electrical","B1803983","X"]
[null,null,"Building","Minor Permit","Commercial","Fireplace - Wood Burning Stove",null,"went back to 2014 can't find a permit"]
[null,null,"Building","Minor Permit","Commercial","Gas lOg-Gas Lighter","B1702231","X"]
[null,null,"Building","Minor Permit","Commercial","Mechanical","B1805589","X"]
[null,null,"Building","Minor Permit","Commercial","Plumbing","B1805761","X"]
[null,null,"Building","Minor Permit","Commercial","Pool","B1804143","X"]
[null,null,"Building","Minor Permit","Commercial","Roofing - Re-roofing","B1805851","X"]
[null,null,"Building","Minor Permit","Commercial","Sprinkler","B1805113","To do: Check when a flat $25 Permit fee is assesed. Thought I had, it but I don't"]
[null,null,"Building","Minor Permit","Commercial","Water Heater",null,"No permits issued back to 2013"]
[null,null,"Building","Minor Permit","Deck","na","B1805726","X"]
[null,null,"Building","Minor Permit","Demolition","na","B1805785","X"]
[null,null,"Building","Minor Permit","Electric Service Change","na","B1805459","To do: Need to implement which the flat fee is applied to building permit and not plan check fee for electrical changes. Thought I had, it but I don't"]
[null,null,"Building","Minor Permit","Fence","na","B1803588","X"]
[null,null,"Building","Minor Permit","New Mobile Home","na",null,"went back to 2014 can't find a permit"]
[null,null,"Building","Minor Permit","Patio Cover","na","B1806060","X"]
[null,null,"Building","Minor Permit","Residential","Pool","B1801303","X"]
[null,null,"Building","Minor Permit","Sales Trailer","na","B1802280","X"]
[null,null,"Building","Minor Permit","Sign","na","B1805911","X"]
[null,null,"Building","Minor Permit","Storage Shed","na","B1804901","X"]
[null,null,"Building","Minor Permit","Temporary Structure","na","B1401844","X"]
[null,null,"Building","New","Commercial","Com-Ind-Mixed-Use Building","B1803238","X"]
[null,null,"Building","New","Residential","Duplex","B1705260","This permit is the newest one and based on the secondary service, rates might be out dated from model. We are higher"]
[null,null,"Building","New","Residential","Manufactured Home","B1700435","This permit is the newest one and based on the secondary service, rates might be out dated from model. We are higher"]
[null,null,"Building","New","Residential","Multi-Family","B1805098","Now it ties once I have the right lot size (the lot squar footage that Joni gave me I couldn’t find in accella). Distribution of lot size break out for Stormwater is unclear. Mostly out because WSR was resolved outside the permit"]
[null,null,"Building","New","Residential","Secondary Building","B1805816","X"]
[null,null,"Building","New","Residential","Single Family Attached","B1805810","Close. Need further research on sewer and water fees"]
[null,null,"Building","New","Residential","Single Family Detached","B1806160","Off sewer. Unclear as to the information provided in accella to the fees that are charged."]
[null,null,"Building","OTC","Residential","Basement Finish","B1806078","To do: Need to implement which the flat fee is applied to building permit and not plan check fee for electrical changes. Thought I had, it but I don't"]
[null,null,"Building","OTC","Residential","Electric sprinkler Control Clock","B1508463","X"]
[null,null,"Building","OTC","Residential","Electrical","B1806014","X"]
[null,null,"Building","OTC","Residential","Fireplace - Wood Burning Stove","B1805543","X"]
[null,null,"Building","OTC","Residential","Gas lOg-Gas Lighter","B1805849","X"]
[null,null,"Building","OTC","Residential","Mechanical","B1806144","X"]
[null,null,"Building","OTC","Residential","Mobile Home Installation","B1803815","X"]
[null,null,"Building","OTC","Residential","Plumbing","B1806107","X"]
[null,null,"Building","OTC","Residential","Roofing - Re-roofing","B1806150","X"]
[null,null,"Building","OTC","Residential","Sprinkler","B1805756","X"]
[null,null,"Building","OTC","Residential","Water Heater","B1806113"]
[]
[null,null,"Did not include Building MISC, Project or Unapproved Dwelling unit"]

{"sheet":"To Do","index":8,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Tyler siegmund - Electric Dev Rev"]
[]
[]
[]
["Change valuation for Plan Check Fee w/ stock fee using dropdown"]
["Talk to Utilities about BOD","Biochemical Oxygen Demand"]
["Talk to Utilities about TSS","Total Suspended Solids"]
["Talk to Utilities about how often multiple meters occur"]
["Talk to Utilities about Multi-Family number of meters for water - depends on how they will do it… one meter per building and size or individually metered, etc."]
["Look at items like adding a parking lot and how we would calculate those fees"]
["ESCROWS!"]
["Create Development Review Calculator"]
["Create pop up when project minimums have not been met and unhide project minimum sheet"]
[]
[]
[]
[]
[]
["Questions for Kiana"]
["With a new build, if they are doing a fireplace/finished basement/etc, is that included as part of the overall project cost?","part of the overall project - do not need to as part of the OTC"]
["What is the difference b/n a general commerical alteration and a minor?","minor is combined OTC for commerical or residential (e.g. new furnace, water heater, all in one).  General is like a tenant finish on a commerical speace"]

{"sheet":"Dropdowns","index":9,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Type","DropDown1","Residential","Commercial (Single Phase)","Office and Other Services (3-phase)","Industrial/Warehouse (Large Comm)",null,null,null,null,null,null,null,null,null,"Amps",null,"Voltage"]
[null,"Commercial (Single Phase)","Addition","--","--","Church/Synagogue","General Ligh Industrial/Industrial Park",null,null,"3/4 inch",null,"Yes",null,"Single Family",null,null,150,null,208,null,"Single"]
[null,"Industrial/Warehouse (Large Comm)","Alteration","Accessory Living Area - Attached","Auto Sales (& Speciality Retail)","Day Care Center","Mini-Warehouse",null,null,"1 inch",null,"No",null,"Duplex",null,null,200,null,240,null,"Three"]
[null,"Office and Other Services (3-phase)","Minor Permit","Accessory Living Area - Detached","Auto Service/Repair/Tire Store","Elementary/Secondary School","Warehouse",null,null,"1-1/2 inch",null,"--",null,"Multi-Family",null,null,"EH",null,277]
[null,"Residential","New","Air Conditioning","Bank","Hospital",null,null,null,"2 inch",null,null,null,"--",null,null,"--",null,480]
[null,null,null,"Basement Finish","Basement Finish","Medical Office",null,null,null,"3 inch",null,null,null,null,null,null,null,null,13200]
[null,null,null,"Cabin (30% of single family detached)","Building Materials/Hardware/Nursery","Nursing Home",null,null,null,"4 inch",null,null,null,null,null,null,null,null,"--"]
[null,null,null,"Deck","Convenience store","Office, General < 100,000 sq ft",null,null,null,"--"]
[null,null,null,"Demolition","Deck","Office, General 100k - 200k sq ft"]
[null,null,null,"Duplex","Demolition","Office, General > 200,000 sq ft"]
[null,null,null,"Electrical","Discount Store"]
[null,null,null,"Extended Family (3 yr permit)","Electrical"]
[null,null,null,"Farmstead Accessory Living","Fence"]
[null,null,null,"Fence","Fireplace"]
[null,null,null,"Fireplace","Funiture Store"]
[null,null,null,"Furnace","General Reatial <100,000 sq ft"]
[null,null,null,"Gas","General Reatil 100k - 500k sq ft"]
[null,null,null,"Hotel/Motel","General Reatil 500k - 1M sqt ft"]
[null,null,null,"Manufactured Home","General Retail > 1 million sq ft"]
[null,null,null,"Mechanical","Mechanical"]
[null,null,null,"Mobile Home","Mobile Home"]
[null,null,null,"Mobile Home Installation","Movie Theater"]
[null,null,null,"Multi-Family","Patio Cover"]
[null,null,null,"New Secondary","Plumbing"]
[null,null,null,"Patio Cover","Pool"]
[null,null,null,"Plumbing","Re-Roof"]
[null,null,null,"Pool","Restaurant, Fast Food"]
[null,null,null,"Re-Roof","Restaurant, Sit Down"]
[null,null,null,"Secondary Building","Sales Trailer"]
[null,null,null,"Sales Trailer","Secondary Building"]
[null,null,null,"Shed","Shed"]
[null,null,null,"Single Family - Attached","Sign"]
[null,null,null,"Single Family - Detached","Sprinkler"]
[null,null,null,"Sprinkler","Temporary Structure"]
[null,null,null,"Temporary Structure","Water Heater"]
[null,null,null,"Water Heater"]
[]
[null,null,null,null,"Residential","Residential"]
[null,null,null,null,"Commercial (Single Phase)","CommercialSinglePhase"]
[null,null,null,null,"Office and Other Services (3-phase)","OfficeandOtherServices"]
[null,null,null,null,"Industrial/Warehouse (Large Comm)","Industrial"]

{"sheet":"Electric","index":10,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Type","Sub Type","# of units","Amps","Phase ","Voltage","Category",null,"Phase",null,null,null,"Voltage","Calculated kW","$/kW","Cost per Unit","Amount"]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"+'Plan and Building Inputs'!$C$30","v":0},{"$f":"+'Plan and Building Inputs'!$C$29","v":0},{"$f":"+'Plan and Building Inputs'!$C$31","v":0},{"$f":"IF(AND(A2=\"Residential\", B2=\"Single Family\"), \"Single Family\", IF(AND(A2=\"Residential\", B2<>\"Single Family\"), \"Multi-Family\", \"Commercial\"))","v":"Commercial"},{"$f":"IF(G2=\"Single Family\", \"SF \"&D2&\" Amp\", IF(G2=\"Multi-Family\", \"MF \"&D2&\" Amp\", D2))","v":0},{"$f":"'Plan and Building Inputs'!$C$29","v":0},{"$f":"IF('Plan and Building Inputs'!$C$10=\"Yes\",IF(A2=\"Residential\",H2=M2,FALSE),FALSE)","v":false},"Residential","Single Family","SF 150 Amp",null,null,1537,{"$f":"C2*P2","v":0}]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"+'Plan and Building Inputs'!$C$30","v":0},{"$f":"+'Plan and Building Inputs'!$C$29","v":0},{"$f":"+'Plan and Building Inputs'!$C$31","v":0},{"$f":"IF(AND(A3=\"Residential\", B3=\"Single Family\"), \"Single Family\", IF(AND(A3=\"Residential\", B3<>\"Single Family\"), \"Multi-Family\", \"Commercial\"))","v":"Commercial"},{"$f":"IF(G3=\"Single Family\", \"SF \"&D3&\" Amp\", IF(G3=\"Multi-Family\", \"MF \"&D3&\" Amp\", D3))","v":0},{"$f":"'Plan and Building Inputs'!$C$29","v":0},{"$f":"IF('Plan and Building Inputs'!$C$10=\"Yes\",IF(A3=\"Residential\",H3=M3,FALSE),FALSE)","v":false},"Residential","Single Family","SF 200 Amp",null,null,1879,{"$f":"C3*P3","v":0}]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"+'Plan and Building Inputs'!$C$30","v":0},{"$f":"+'Plan and Building Inputs'!$C$29","v":0},{"$f":"+'Plan and Building Inputs'!$C$31","v":0},"Commercial",0,{"$f":"'Plan and Building Inputs'!$C$29","v":0},{"$f":"IF('Plan and Building Inputs'!$C$10=\"Yes\",IF(A4=\"Residential\",H4=M4,FALSE),FALSE)","v":false},"Residential","Single Family","SF EH Amp",null,null,2508,{"$f":"C4*P4","v":0}]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"+'Plan and Building Inputs'!$C$30","v":0},{"$f":"+'Plan and Building Inputs'!$C$29","v":0},{"$f":"+'Plan and Building Inputs'!$C$31","v":0},"Commercial",0,{"$f":"'Plan and Building Inputs'!$C$29","v":0},{"$f":"IF('Plan and Building Inputs'!$C$10=\"Yes\",IF(A5=\"Residential\",H5=M5,FALSE),FALSE)","v":false},"Residential","Multi-Family","MF 150 Amp",null,null,1349.5364199798519,{"$f":"C5*P5","v":0}]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"+'Plan and Building Inputs'!$C$30","v":0},{"$f":"+'Plan and Building Inputs'!$C$29","v":0},{"$f":"+'Plan and Building Inputs'!$C$31","v":0},"Commercial",0,{"$f":"'Plan and Building Inputs'!$C$29","v":0},{"$f":"IF('Plan and Building Inputs'!$C$10=\"Yes\",IF(A6=\"Residential\",H6=M6,FALSE),FALSE)","v":false},"Residential","Multi-Family","MF 200 Amp",null,null,2066.1437839988907,{"$f":"C6*P6","v":0}]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"+'Plan and Building Inputs'!$C$30","v":0},{"$f":"+'Plan and Building Inputs'!$C$29","v":0},{"$f":"+'Plan and Building Inputs'!$C$31","v":0},"Commercial",0,{"$f":"'Plan and Building Inputs'!$C$29","v":0},{"$f":"IF('Plan and Building Inputs'!$C$10=\"Yes\",IF(A7=\"Residential\",H7=M7,FALSE),FALSE)","v":false},"Commercial","Primary Metered",13200,{"$f":"IFERROR(D7*M7*$B$18*$B$19*IF(I7=\"Three\", SQRT(3), 1)/1000,0)","v":0},{"$f":"IFERROR(C14+C15*LN(N7),0)","v":0},null,{"$f":"+O7*N7","v":0}]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"+'Plan and Building Inputs'!$C$30","v":0},{"$f":"+'Plan and Building Inputs'!$C$29","v":0},{"$f":"+'Plan and Building Inputs'!$C$31","v":0},"Commercial",0,{"$f":"'Plan and Building Inputs'!$C$29","v":0},{"$f":"IF('Plan and Building Inputs'!$C$10=\"Yes\",IF(A8=\"Residential\",H8=M8,FALSE),FALSE)","v":false},"Commercial","Secondary Metered",13200,{"$f":"IFERROR(D8*M8*$B$18*$B$19*IF(I8=\"Three\", SQRT(3), 1)/1000,0)","v":0},{"$f":"IFERROR(C15+C16*LN(N8),0)","v":0},null,{"$f":"+O8*N8","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IFERROR(VLOOKUP(TRUE, J1:Q8,8,FALSE),0)","v":0}]
[]
[]
["Regression Result","Secondary Metered","Primary Metered"]
["Constant*",320.31,212.77817456127622]
["Coefficient*",21,7.8869348543152515]
[]
[]
["Power Factor",0.9]
["Panel Utilizaiton Factor",0.3]
[]
["Electric Underground Secondary Service Charge:"]
["Single Family Resident",1143,"Updated fees"]
["Temporary Pedestal Service",182.7]
[]
["Type"]
["Duplex",{"$f":"IFERROR(MATCH(A26,'Plan and Building Inputs'!$C$7,0),0)","v":0}]
["Multi-Family",{"$f":"IFERROR(MATCH(A27,'Plan and Building Inputs'!$C$7,0),0)","v":0}]
["Single Family",{"$f":"IFERROR(MATCH(A28,'Plan and Building Inputs'!$C$7,0),0)","v":0}]
["Manufactured Home",{"$f":"IFERROR(MATCH(A29,'Plan and Building Inputs'!$C$7,0),0)","v":0}]
["Single Family - Attached",{"$f":"IFERROR(MATCH(A30,'Plan and Building Inputs'!$C$7,0),0)","v":0}]
["Single Family - Detached",{"$f":"IFERROR(MATCH(A31,'Plan and Building Inputs'!$C$7,0),0)","v":0}]
["Check",{"$f":"SUM(B26:B31)","v":0}]

{"sheet":"Comm Revenue Elec Fee","index":11,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["Labor is Cacluated as Follows:",null,null,"Per Temp","Per Hour","Per Hour"]
["Services Supervisor",null,null,{"$f":"+E2*F2","v":30.954999999999998},61.91,0.5]
["Lineworker One",null,null,{"$f":"+E3*F3","v":28.27},56.54,0.5]
["Groundworker",null,null,{"$f":"+E4*F4","v":38.4},38.4,1]
[null,null,null,{"$f":"SUM(D2:D4)","v":97.625},{"$f":"SUM(E2:E4)","v":156.85}]
[]
["Equipment is calculated as Follows:",null,null,"Per Temp","Per Hour","Per Hour"]
["One Ton Truck",null,null,{"$f":"+E8*F8","v":2.65},5.3,0.5]
["Utility Truck",null,null,{"$f":"+E9*F9","v":28.22},56.44,0.5]
["Backhoe",null,null,{"$f":"+E10*F10","v":14.137499999999999},56.55,0.25]
["Misc. Tools",null,null,{"$f":"+E11*F11","v":5.835},11.67,0.5]
[null,null,null,{"$f":"SUM(D8:D11)","v":50.842499999999994},{"$f":"SUM(E8:E11)","v":129.95999999999998}]
[]
["Total Labor and Equipment",null,null,{"$f":"+D5+D12","v":148.4675},null,"Labor and Equipment per Temp"]
[]
[null,null,null,{"$f":"+D14*0.15","v":22.270125},null,"15% Overhead (15% by City Code0"]
[null,null,null,{"$f":"+D14+D16","v":170.73762500000001}]
[]
[]
["Material Costs",null,null,10.39,null,"Annual GFI Replacement/1100 temps"]
[null,null,null,1.56,null,"15% Overhead (15% by City Code0"]
["Total Materials",null,null,{"$f":"SUM(D20:D21)","v":11.950000000000001}]
[]
["Energy is calculated as follows:"]
["Fixed Charge",null,null,3.6]
["Average kWh",null,null,null,null,150,"Per Month"]
["Charge per kWh",null,null,14.33,null,9.5500000000000002E-2,"Per kWh"]
[null,null,null,{"$f":"SUM(D25:D27)","v":17.93},null,"per month"]
[]
["PILOT",null,null,1.08,null,0.06,"PILOTS percent"]
[]
["average months",null,null,{"$f":"+D28+D30","v":19.009999999999998},null,"per month"]
[]
[null,null,null,{"$f":"+D32*3","v":57.029999999999994},null,"3 month Energy charge per temp"]
[]
[null,null,null,{"$f":"+D28*3","v":53.79},null,"Comm Revenue"]
[]
[null,null,null,{"$f":"+D17+D22","v":182.687625},null,"Misc Revenue Temp Pedestal"]

{"sheet":"County TCEF","index":12,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Type","Category","Square Feet","Units",null,"Type","Category","Unit of Measure","Area Test","Type Test","Dwelling test","New/Addition","Cap Expansion Test","County ","Regional"]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"G4=B4","v":false},"Residential","Resid., up to 900 sf","1 Dwelling",{"$f":"C4<=900","v":true},{"$f":"A4=F4","v":false},{"$f":"IF(AND(A4=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},{"$f":"IF(AND(I4=TRUE,J4=TRUE,K4=TRUE),TRUE,FALSE)","v":false},1946,163]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"G5=B5","v":false},"Residential","Resid., 901-1,300 sf","1 Dwelling",{"$f":"AND(C5>901, C5<=1300)","v":false},{"$f":"A5=F5","v":false},{"$f":"IF(AND(A5=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},{"$f":"IF(AND(I5=TRUE,J5=TRUE,K5=TRUE),TRUE,FALSE)","v":false},2727,228]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"G6=B6","v":false},"Residential","Resid., 1,301-1,800 sf","1 Dwelling",{"$f":"AND(C6>1301, C6<=1800)","v":false},false,{"$f":"IF(AND(A6=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},false,3284,275]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"G7=B7","v":false},"Residential","Resid., 1,801-2,400 sf","1 Dwelling",{"$f":"AND(C7>1801, C7<=2400)","v":false},false,{"$f":"IF(AND(A7=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},false,3846,322]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},false,"Residential","Resid., 2,401-3,000 sf","1 Dwelling",{"$f":"AND(C8>2401, C8<=3000)","v":false},false,{"$f":"IF(AND(A8=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},{"$f":"IF(AND(I8=TRUE,J8=TRUE,K8=TRUE),TRUE,FALSE)","v":false},4315,361]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"G9=B9","v":false},"Residential","Resid., 3,001-3,600 sf","1 Dwelling",{"$f":"AND(C9>3001, C9<=3600)","v":false},false,{"$f":"IF(AND(A9=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},false,3699,393]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},false,"Residential","Resid., over 3,600 sf","1 Dwelling",{"$f":"C10>3600","v":false},false,{"$f":"IF(AND(A10=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},{"$f":"IF(AND(I10=TRUE,J10=TRUE,K10=TRUE),TRUE,FALSE)","v":false},5020,420]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},false,"Commercial (Single Phase)","Commercial (Single Phase)","1,000 sf",{"$f":"+C11/1000","v":0},false,{"$f":"IF(AND(A11=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},{"$f":"IF(AND(I11=TRUE,J11=TRUE,K11=TRUE),TRUE,FALSE)","v":false},5039,422]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},false,"Office and Other Services (3-phase)","Office and Other Services (3-phase)","1,000 sf",{"$f":"+C12/1000","v":0},false,{"$f":"IF(AND(A12=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},{"$f":"IF(AND(I12=TRUE,J12=TRUE,K12=TRUE),TRUE,FALSE)","v":false},2965,248]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},false,"Industrial/Warehouse (Large Comm)","Industrial/Warehouse (Large Comm)","1,000 sf",0,false,{"$f":"IF(AND(A13=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},{"$f":"IF(AND(I13=TRUE,J13=TRUE,K13=TRUE),TRUE,FALSE)","v":false},1196,100]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ouput",{"$f":"IFERROR(IF('Plan and Building Inputs'!$C$4=\"Residential\",VLOOKUP(TRUE,$M$3:$O$13,3,FALSE)*D4,VLOOKUP(TRUE,$M$3:$O$13,3,FALSE)*$I$11),0)","v":0}]

{"sheet":"Schools","index":13,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,{"$f":"D3<=4","v":true},{"$f":"D3>4","v":false}]
["Type","Sub-Type City of Fort Collins","District","Units",null,null,null,"1-4 Unit","5+ Units"]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$32","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},null,"Poudre",{"$f":"+IF(AND(C3=F3,'Plan and Building Inputs'!C5=\"New\",IFERROR(MATCH(B3,$A$15:$A$26,0),0)),TRUE,FALSE)","v":false},1710,855]
[{"$f":"'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$32","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},null,"Big Thompson",{"$f":"+IF(AND(C4=F4,'Plan and Building Inputs'!C6=\"New\",IFERROR(MATCH(B4,$A$15:$A$26,0),0)),TRUE,FALSE)","v":false},1382,946]
[]
[null,null,null,null,null,"Output",null,{"$f":"IFERROR(IF(A3=\"Residential\",VLOOKUP(TRUE, G3:I4, MATCH(TRUE, G1:I1, FALSE), FALSE)*D3, 0),0)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MATCH(B3,$A$15:$A$24)","v":{"$error":"#N/A"}}]
[]
[]
[]
["Cabin (30% of single family detached)"]
["Duplex"]
["Extended Family (3 yr permit)"]
["Farmstead Accessory Living"]
["Hotel/Motel"]
["Mobile Home Park"]
["Multi-Family"]
["Single Family"]
["Mobile Home"]
["Manufactured Home"]
["Single Family - Attached"]
["Single Family - Detached"]

{"sheet":"Stormwater","index":14,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Site Sq. Ft","Building Sq Ft","ROW","Parking/Drives/walks/patios","Gravel","Private O.S.","Public O.S","Gross:","% Impervious","% Gravel","% Pervious","Net Acres","Net % Impervious","Net % Semi-pervious","Net % Pervious","Cg","Cn","Rate Factor","Basin Rate:","SW PIF:","Review Charge:"]
[{"$f":"+'Plan and Building Inputs'!C16","v":0},{"$f":"+'Plan and Building Inputs'!C17","v":0},{"$f":"+'Plan and Building Inputs'!C18","v":0},{"$f":"+'Plan and Building Inputs'!C19","v":0},{"$f":"+'Plan and Building Inputs'!C20","v":0},{"$f":"+'Plan and Building Inputs'!C21","v":0},{"$f":"+'Plan and Building Inputs'!C22","v":0},{"$f":"SUM(B4:G4)","v":0},{"$f":"IFERROR(SUM(B4+C4+D4)/A4,0)","v":0},{"$f":"+IFERROR(E4/A4,0)","v":0},{"$f":"IFERROR((F4+G4)/A4,0)","v":0},{"$f":"A4-C4","v":0},{"$f":"IFERROR(SUM(B4+D4)/L4,0)","v":0},{"$f":"IFERROR(E4/L4,0)","v":0},{"$f":"IFERROR(SUM(F4+G4)/L4,0)","v":0},{"$f":"SUM(I4*0.95)+(J4*0.5)+(K4*0.2)","v":0},{"$f":"(M4*0.95)+(N4*0.05)+(O4*0.2)","v":0},{"$f":"IF(M4<=0.3, 0.25, IF(AND(M4>0.31, M4<=0.5), 0.4, IF(AND(M4>0.51, M4<=0.7), 0.6, IF(AND(M4>0.71, M4<=0.9), 0.8, 0.95))))","v":0.25},{"$f":"+B7/D7","v":0.18863636363636363},{"$f":"A4*(B7/D7)*R4","v":0},{"$f":"(A24/B24)*L4*$R$4","v":0}]
[]
[null,"Base rate",null,"Sq feet per acre"]
[null,8217,null,43560]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["https://www.fcgov.com/utilities/img/site_specific/uploads/2018_Stormwater_PIF_2018.pdf"]
[]
["Stormwater constant","Sq feet per acre"]
[1045,43560]
[]
["https://www.fcgov.com/utilities/img/site_specific/uploads/2017_WaterWastewaterand_Stormwater_Review_Charges_.pdf"]

{"sheet":"Water WW","index":15,"n_rows":103,"n_cols":23,"rows_kept":103,"cut":false,"hidden":true,"merged":[[19,0,19,1]]}
[]
["Residential Calculations"]
["Type","Sub Type","Tap Size","Water Meters needed","Lot Area","Bedrooms","Units","Peak GPD","BOD","TSS","Peak Annual","I&I Flow","Sub-Type City of Fort Collins","Water Meter Size","T/F","Water PIF","WSR (Ac-Ft)","WSR (Cash)","Meter Cost","Water Dev Rev","WW PIF","WW Dev Rev","Total"]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$24","v":0},{"$f":"+'Plan and Building Inputs'!$C$25","v":0},{"$f":"+'Plan and Building Inputs'!$C$16","v":0},{"$f":"+'Plan and Building Inputs'!$C$13","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},null,null,null,null,null,"Single Family - Attached",null,{"$f":"IF( A4=\"Residential\", B4=M4,C4=N4)","v":true},{"$f":"IF(O4=TRUE,_xlfn.IFS(AND(LEFT(B4,6)=\"Single\",C4=$N$22),P22+0.33*E4,AND(LEFT(B4,6)=\"Single\",C4=$N$23),P23+0.33*E4),0)","v":{"$error":"#N/A"}},{"$f":"IF(O4=TRUE,(((7.048*E4)+(12216.9*F4))/325851)*1.92,0)","v":0},{"$f":"Q4*R24","v":0},{"$f":"IF(O4=TRUE,_xlfn.IFS(AND(M4=B4,C4=N22),S22,AND(B4=M4,C4=N23),S23),0)","v":{"$error":"#N/A"}},{"$f":"IF(O4=TRUE,T23*G4,0)","v":0},{"$f":"+IF(O4=TRUE,(G4*U22),0)","v":0},{"$f":"IF(O4=TRUE,T23*G4,0)","v":0},{"$f":"SUM(R4:V4,P4)","v":{"$error":"#N/A"}}]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$24","v":0},{"$f":"+'Plan and Building Inputs'!$C$25","v":0},{"$f":"+'Plan and Building Inputs'!$C$16","v":0},{"$f":"+'Plan and Building Inputs'!$C$13","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},null,null,null,null,null,"Duplex",null,{"$f":"IF( A5=\"Residential\", B5=M5,C5=N5)","v":true},{"$f":"IF(O5=TRUE,(540*G5)+E5*0.24,0)","v":0},{"$f":"IF(O5=TRUE,(((7.048*E5)+(12216.9*F5))/325851)*1.92,0)","v":0},{"$f":"+Q5*R24","v":0},{"$f":"IF(O5=TRUE,_xlfn.IFS(AND(M5=B5,C5=N24),S24,AND(B5=M5,C5=N25),S25),0)","v":{"$error":"#N/A"}},{"$f":"IF(O5=TRUE,T24*G5,0)","v":0},{"$f":"IF(O5=TRUE,U24*G5,0)","v":0},{"$f":"IF(O5=TRUE,T24*G5,0)","v":0},{"$f":"SUM(R5:V5,P5)","v":{"$error":"#N/A"}}]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$24","v":0},{"$f":"+'Plan and Building Inputs'!$C$25","v":0},{"$f":"+'Plan and Building Inputs'!$C$16","v":0},{"$f":"+'Plan and Building Inputs'!$C$13","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},null,null,null,null,null,"Multi-Family",null,true,{"$f":"IF(O6=TRUE,(540*G6)+E6*0.24,0)","v":0},0,{"$f":"+Q6*$R$24","v":0},{"$f":"IF(O6=TRUE,_xlfn.IFS(AND(M6=B6,C6=N25),S25,AND(B6=M6,C6=N22),S22),0)","v":{"$error":"#N/A"}},{"$f":"IF(O6=TRUE,T25*G6,0)","v":0},{"$f":"IF(O6=TRUE,U25*G6,0)","v":0},0,{"$f":"SUM(R6:V6,P6)","v":{"$error":"#N/A"}}]
[]
["Non Residential Calculation"]
["Type","Sub Type","Tap Size","Water Meters needed","Lot Area","Bedrooms","Units","Peak GPD","BOD","TSS","Peak Annual","I&I Flow","Sub-Type City of Fort Collins","Water Meter Size","T/F","Water PIF","WSR (Ac-Ft)","WSR (Cash)","Meter Cost","Water Dev Rev","WW PIF","WW Dev Rev","Total"]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$24","v":0},{"$f":"+'Plan and Building Inputs'!$C$25","v":0},{"$f":"+'Plan and Building Inputs'!$C$16","v":0},{"$f":"+'Plan and Building Inputs'!$C$13","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},null,null,null,null,null,"Non-Residential","3/4 inch",{"$f":"IF( A10=\"Residential\", B10=M10,C10=N10)","v":false},{"$f":"IF(O10=TRUE,P26,0)","v":0},{"$f":"+IF(O10=TRUE,(Q26),0)","v":0},{"$f":"IF(O10=TRUE,(Q10*$R$24),0)","v":0},{"$f":"IF(O10=TRUE,S26,0)","v":0},{"$f":"IF(O10=TRUE,T26*G10,0)","v":0},{"$f":"IF(O10=TRUE,(G10*U26),0)","v":0},{"$f":"IF(O10=TRUE,T26*G10,0)","v":0},{"$f":"SUM(R10:V10,P10)","v":0}]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$24","v":0},{"$f":"+'Plan and Building Inputs'!$C$25","v":0},{"$f":"+'Plan and Building Inputs'!$C$16","v":0},{"$f":"+'Plan and Building Inputs'!$C$13","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},null,null,null,null,null,"Non-Residential","1 inch",false,{"$f":"IF(O11=TRUE,P27,0)","v":0},{"$f":"+IF(O11=TRUE,(Q27),0)","v":0},0,0,{"$f":"IF(O11=TRUE,T27*G11,0)","v":0},{"$f":"IF(O11=TRUE,(G11*U27),0)","v":0},{"$f":"IF(O11=TRUE,T27*G11,0)","v":0},0]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$24","v":0},{"$f":"+'Plan and Building Inputs'!$C$25","v":0},{"$f":"+'Plan and Building Inputs'!$C$16","v":0},{"$f":"+'Plan and Building Inputs'!$C$13","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},null,null,null,null,null,"Non-Residential","1-1/2 inch",false,{"$f":"IF(O12=TRUE,P28,0)","v":0},{"$f":"+IF(O12=TRUE,(Q28),0)","v":0},0,0,0,0,0,0]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$24","v":0},{"$f":"+'Plan and Building Inputs'!$C$25","v":0},{"$f":"+'Plan and Building Inputs'!$C$16","v":0},{"$f":"+'Plan and Building Inputs'!$C$13","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},null,null,null,null,null,"Non-Residential","2 inch",false,{"$f":"IF(O13=TRUE,P29,0)","v":0},{"$f":"+IF(O13=TRUE,(Q29),0)","v":0},0,0,0,0,0,0]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$24","v":0},{"$f":"+'Plan and Building Inputs'!$C$25","v":0},{"$f":"+'Plan and Building Inputs'!$C$16","v":0},{"$f":"+'Plan and Building Inputs'!$C$13","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"+'Plan and Building Inputs'!$C$26","v":0},{"$f":"+'Plan and Building Inputs'!$C$27","v":0},{"$f":"+'Plan and Building Inputs'!$C$28","v":0},{"$f":"+H14*365","v":0},{"$f":"+H14*0.465","v":0},"Non-Residential","3 inch",false,{"$f":"IF(O14=TRUE,(4.66*H14),0)","v":0},{"$f":"IF(O14=TRUE,(K14*1.92/325851),0)","v":0},0,0,0,{"$f":"+(H14*($B$21+(I14*$B$22)+(J14*$B$23)))+(L14*($B$21+(I14*$B$22)+(J14*$B$23)))","v":0},0,0]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$7","v":0},{"$f":"+'Plan and Building Inputs'!$C$24","v":0},{"$f":"+'Plan and Building Inputs'!$C$25","v":0},{"$f":"+'Plan and Building Inputs'!$C$16","v":0},{"$f":"+'Plan and Building Inputs'!$C$13","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},{"$f":"+'Plan and Building Inputs'!$C$26","v":0},{"$f":"+'Plan and Building Inputs'!$C$27","v":0},{"$f":"+'Plan and Building Inputs'!$C$28","v":0},{"$f":"+H15*365","v":0},{"$f":"+H15*0.465","v":0},"Non-Residential","4 inch",false,{"$f":"IF(O15=TRUE,(4.66*H15),0)","v":0},{"$f":"IF(O15=TRUE,(K15*1.92/325851),0)","v":0},0,0,0,{"$f":"+(H15*($B$21+(I15*$B$22)+(J15*$B$23)))+(L15*($B$21+(I15*$B$22)+(J15*$B$23)))","v":0},0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water PIF","WSR (Ac-Ft)","WSR (Cash)","Meter Cost","Water Dev Rev","WW PIF","WW Dev Rev","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Output",null,true,{"$f":"IFERROR(VLOOKUP($O18, $O$4:$W$15, MATCH(P17, $O$3:$W$3,FALSE),FALSE),)","v":0},0,0,0,0,0,0,0]
[]
["Rates",null,null,null,null,null,null,null,null,null,null,null,"Residential"]
["Flow $",8.76,null,null,null,null,null,null,null,null,null,null,"Sub-Type City of Fort Collins","Water Meter Size",null,"Water PIF","Minimum WSR Acre-feet)","WSR (Cash) per Ac-Ft flat rate","Water Meter","Water/WW Dev Rev","WW PIF","Water Meter"]
["BOD $ ",1.2999999999999999E-2,null,null,null,null,null,null,null,null,null,null,"Single Family","3/4 inch",null,720,"calculation given",null,350.02,53,3500,694.31]
["TSS $",1.04E-2,null,null,null,null,null,null,null,null,null,null,"Single Family","1 inch",null,1220,"calculation given",null,389.7,53,3500,789.82]
[null,null,null,null,null,null,null,null,null,null,null,null,"Duplex","3/4 inch",null,540,"calculation given",17300,350.02,43,2520,350.02]
["Waste Water PIF",null,null,null,null,null,null,null,null,null,null,null,"Multi-Family","1 inch",null,540,"calculation given",null,389.7,43,2520,389.7]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non-Residential","3/4 inch",null,7180,0.9,null,350.02,128,7130]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non-Residential","1 inch",null,19710,2.27,null,389.7,333,17200]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non-Residential","1-1/2 inch",null,42220,4.72,null,694.31,658,33410]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non-Residential","2 inch",null,66680,7.91,null,789.82,965,59140]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non-Residential","3 inch",null,"Based on use","Based on use",null,2637.76,2020]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non-Residential","4 inch",null,"Based on use","Based on use",null,3358.88,2020]
[]
[]
[]
["Below are the parameters given for the fee calculations above as well as the locations of each file",null,null,null,null,null,null,null,null,null,null,"Water PIF"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Supply Requirment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.fcgov.com/utilities/img/site_specific/uploads/Non_Res_WSR_Schedule_2018_a.pdf"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"https://www.fcgov.com/utilities/img/site_specific/uploads/2018_Water_PIF_2018.pdf"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.fcgov.com/utilities/img/site_specific/uploads/Res_WSR_Schedule_2018.pdf"]
[]
[]
[]
[]
[]
[]
[]
["https://www.fcgov.com/utilities/img/site_specific/uploads/2018_Wastewater_PIF_2018.pdf"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.fcgov.com/utilities/img/site_specific/uploads/2018_Wastewater_PIF_2018.pdf"]

{"sheet":"Capital Expansion","index":16,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Input","Type","Input","Units","Type","Land Use Type","Unit","Area Test","Type Test","Dwelling test","New/Addition","Cap Expansion Test","Parkland: Neighborhood","Parkland: Community","Fire Capital Exp","Police Capital Exp","General Govt. Capt. Exp. ","Transportation Capital Expansion"]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$5","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},"Residential","Resid., up to 700 sf","Dwelling",{"$f":"C4<=700","v":true},{"$f":"A4=E4","v":false},{"$f":"IF(AND(A4=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},{"$f":"IF(AND(H4=TRUE,I4=TRUE,J4=TRUE),TRUE,FALSE)","v":false},1647,2326,403,226,549,2321]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$5","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},"Residential","Resid., 701-1,200 sf","Dwelling",{"$f":"AND(C5>701, C5<=1200)","v":false},{"$f":"A5=E5","v":false},{"$f":"IF(AND(A5=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},{"$f":"IF(AND(H5=TRUE,I5=TRUE,J5=TRUE),TRUE,FALSE)","v":false},2205,3114,546,305,741,4310]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$5","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},"Residential","Resid., 1,201-1,700 sf"," Dwelling",{"$f":"AND(C6>1201, C6<=1700)","v":false},false,{"$f":"IF(AND(A6=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},false,2408,3400,593,332,809,5596]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$5","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},"Residential","Resid., 1,701-2,200 sf","Dwelling",{"$f":"AND(C7>1701, C7<=2200)","v":false},false,{"$f":"IF(AND(A7=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},false,2433,3436,603,337,821,6543]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$5","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},"Residential","Resid., over 2,200 sf","Dwelling",{"$f":"C8>2200","v":false},false,{"$f":"IF(AND(A8=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},false,2712,3830,671,375,914,7014]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$5","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},"Commercial (Single Phase)","Commercial (Single Phase)","1,000 sf",{"$f":"+C9/1000","v":0},false,{"$f":"IF(AND(A9=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},false,0,0,508,284,1389,8539]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$5","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},"Office and Other Services (3-phase)","Office and Other Services (3-phase)","1,000 sf",{"$f":"+C10/1000","v":0},false,{"$f":"IF(AND(A10=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},false,0,0,508,284,1389,6291]
[{"$f":"+'Plan and Building Inputs'!$C$4","v":0},{"$f":"+'Plan and Building Inputs'!$C$5","v":0},{"$f":"+'Plan and Building Inputs'!$C$11","v":0},{"$f":"+'Plan and Building Inputs'!$C$14","v":0},"Industrial/Warehouse (Large Comm)","Industrial/Warehouse (Large Comm)","1,000 sf",{"$f":"+C11/1000","v":0},false,{"$f":"IF(AND(A11=\"Residential\",'Plan and Building Inputs'!$C$13>0,'Without Subs (OTC Permits)'!$C$19=0),TRUE,FALSE)","v":false},{"$f":"IF(OR('Plan and Building Inputs'!$C$5=\"New\",'Plan and Building Inputs'!$C$5=\"Addition\"),TRUE,FALSE)","v":false},false,0,0,119,66,327,2030]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IFERROR(IF('Plan and Building Inputs'!$C$4=\"Residential\",VLOOKUP(TRUE,$L$3:$R$11,2,FALSE)*D4,VLOOKUP(TRUE,$L$3:$R$11,2,FALSE)*'Capital Expansion'!$H$9),0)","v":0},{"$f":"IFERROR(IF('Plan and Building Inputs'!$C$4=\"Residential\",VLOOKUP(TRUE,$L$3:$R$11,3,FALSE)*D4,VLOOKUP(TRUE,$L$3:$R$11,3,FALSE)*'Capital Expansion'!$H$9),0)","v":0},{"$f":"IFERROR(IF('Plan and Building Inputs'!$C$4=\"Residential\",VLOOKUP(TRUE,$L$3:$R$11,4,FALSE)*D4,VLOOKUP(TRUE,$L$3:$R$11,4,FALSE)*'Capital Expansion'!$H$9),0)","v":0},{"$f":"IFERROR(IF('Plan and Building Inputs'!$C$4=\"Residential\",VLOOKUP(TRUE,$L$3:$R$11,5,FALSE)*D4,VLOOKUP(TRUE,$L$3:$R$11,5,FALSE)*'Capital Expansion'!$H$9),0)","v":0},{"$f":"IFERROR(IF('Plan and Building Inputs'!$C$4=\"Residential\",VLOOKUP(TRUE,$L$3:$R$11,6,FALSE)*D4,VLOOKUP(TRUE,$L$3:$R$11,6,FALSE)*'Capital Expansion'!$H$9),0)","v":0},{"$f":"IFERROR(IF('Plan and Building Inputs'!$C$4=\"Residential\",VLOOKUP(TRUE,$L$3:$R$11,7,FALSE)*D4,VLOOKUP(TRUE,$L$3:$R$11,7,FALSE)*'Capital Expansion'!$H$9),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["https://www.fcgov.com/finance/capitalexpansion.php"]

{"sheet":"Reference ->","index":17,"n_rows":114,"n_cols":6,"rows_kept":114,"cut":false,"hidden":true,"merged":[]}
["Fee Type",null,"Evaluation Criteria","Fee"," Location"]
["Plan check fee - Plan Review",null,"     $1 to $3,000","$0 - No plan review fee for valuations $3,000 and under","https://www.fcgov.com/building/fees.php"]
["Plan check fee - Plan Review",null,"     $3,001 to 25,000","$66.25 for first $2,000 plus\n$10.25 for each additional $1,000 or fraction thereof\nTake this total times 0.65","https://www.fcgov.com/building/fees.php"]
["Plan check fee - Plan Review",null,"     $25,001 to $50,000","$302 for the first $25,000 plus\n$8.50 for each additional $1,000 or fraction thereof\nTake this total times 0.65","https://www.fcgov.com/building/fees.php"]
["Plan check fee - Plan Review",null,"     $50,001 to$100,000","$514.50 for the first $50,000 plus\n$6.00 for each additional $1,000 or fraction thereof\nTake this total times 0.65","https://www.fcgov.com/building/fees.php"]
["Plan check fee - Plan Review",null,"     $100,001 to $500,000","$814.50 for the first $100,000 plus\n$4.00 for each additional $1,000 or fraction thereof\nTake this total times 0.65","https://www.fcgov.com/building/fees.php"]
["Plan check fee - Plan Review",null,"     $500,001 to $1,000,000","$2,414.50 for the first $500,000 plus\n$3.50 for each additional $1,000 or fraction thereof\nTake this total times 0.65","https://www.fcgov.com/building/fees.php"]
["Plan check fee - Plan Review",null,"     $1,000,001 to $10,000,000","$4,164.50 for the first $1,000,000 plus\n$2.50 for each additional $1,000 or fraction thereof\nTake this total times 0.65","https://www.fcgov.com/building/fees.php"]
["Plan check fee - Plan Review",null,"     $10,000,001 and up","$26,664.50 for the first $10,000,000 plus\n$1.00 for each additional $1,000 or fraction thereof\nTake this total times 0.65","https://www.fcgov.com/building/fees.php"]
["Building permit fee w/ subs",null,"     $1 to $500",25,"https://www.fcgov.com/building/fee-calc-2012.php"]
["Building permit fee w/ subs",null,"     $501 to $2,000","$25 for the first $500 plus\n$2.75 for each additional $100 or fraction thereof ","https://www.fcgov.com/building/fee-calc-2012.php"]
["Building permit fee w/ subs",null,"     $2,001 to 25,000","$66.25 for first $2,000 plus\n$10.25 for each additional $1,000 or fraction thereof\nTake this total times 0.65","https://www.fcgov.com/building/fee-calc-2012.php"]
["Building permit fee w/ subs",null,"     $25,001 to $50,000","$302 for the first $25,000 plus\n$8.50 for each additional $1,000 or fraction thereof\nTake this total times 1.35","https://www.fcgov.com/building/fee-calc-2012.php"]
["Building permit fee w/ subs",null,"     $50,001 to$100,000","$514.50 for the first $50,000 plus\n$6.00 for each additional $1,000 or fraction thereof\nTake this total times 1.35","https://www.fcgov.com/building/fee-calc-2012.php"]
["Building permit fee w/ subs",null,"     $100,001 to $500,000","$814.50 for the first $100,000 plus\n$4.00 for each additional $1,000 or fraction thereof\nTake this total times 1.35","https://www.fcgov.com/building/fee-calc-2012.php"]
["Building permit fee w/ subs",null,"     $500,001 to $1,000,000","$2,414.50 for the first $500,000 plus\n$3.50 for each additional $1,000 or fraction thereof\nTake this total times 1.35","https://www.fcgov.com/building/fee-calc-2012.php"]
["Building permit fee w/ subs",null,"     $1,000,001 to $10,000,000","$4,164.50 for the first $1,000,000 plus\n$2.50 for each additional $1,000 or fraction thereof\nTake this total times 1.35","https://www.fcgov.com/building/fee-calc-2012.php"]
["Building permit fee w/ subs",null,"     $10,000,001 and up","$26,664.50 for the first $10,000,000 plus\n$1.00 for each additional $1,000 or fraction thereof\nTake this total times 1.35","https://www.fcgov.com/building/fee-calc-2012.php"]
["City Sales/Use Tax",null,null,"3.85% on 1/2 total construction value","https://www.fcgov.com/salestax/tax-rates.php"]
["Larimer County Sales/Use Tax",null,null,"0.55% on 1/2 total construction value","https://www.larimer.org/finance/sales-tax"]
["FF Building permit fee w/subs",null,null,"Contractor gives value of FF, this number is then subtracted from full valuation and amount of fee is calculated.  Do not take 1/2 total construction value when figuring.  Use full valuation.","https://www.fcgov.com/building/fee-calc-2012.php"]
["FF City Sales/Use Tax",null,null,"Contractor gives values of FF.  We multipy that value at 3.85% to get tax owing.","https://www.fcgov.com/salestax/tax-rates.php"]
["FF County Sales/Use Tax",null,null,"Contractor gives values of FF.  We multipy that value at 0.55% to get tax owing.","https://www.larimer.org/finance/sales-tax"]
["Fire CIE - Commercial single phase and Office and Other Services (3-phase)",null,null,"$475 per 1,000 sf","https://www.fcgov.com/finance/capitalexpansion.php"]
["Police CIE - Commercial single phase and Office and Other Services (3-phase)",null,null,"$223 per 1,000 sf","https://www.fcgov.com/finance/capitalexpansion.php"]
["Gen Govt. - CIE- Commercial single phase and Office and Other Services (3-phase)",null,null,"$1,088 per 1,000 sf","https://www.fcgov.com/finance/capitalexpansion.php"]
["Transportation CIE - Commercial single phase ",null,null,"$6,721 per 1,000 sf ","https://www.fcgov.com/finance/capitalexpansion.php"]
["Transportation CIE - Office and Other Services (3-phase)",null,null,"$4,951 per 1,000 sf","https://www.fcgov.com/finance/capitalexpansion.php"]
["Fire CIE - Industrial/Warehouse (Large Commercial)",null,null,"$111 per 1,000 sf","https://www.fcgov.com/finance/capitalexpansion.php"]
["Police CIE - Industiral/Warehouse (Large Commerical)",null,null,"$52 per 1,000 sf","https://www.fcgov.com/finance/capitalexpansion.php"]
["Gen Govt. CIE - Industrial/Warehouse (Large Commercial)",null,null,"$257 per 1,000 sf","https://www.fcgov.com/finance/capitalexpansion.php"]
["Transportation CIE - Industrial/Warhousre (Large Commercial)",null,null,"$1,598 per 1,000 sf","https://www.fcgov.com/finance/capitalexpansion.php"]
["Larimer County Regional Road - Retail/Commercial",null,"     Auto Sales (& Specialty Retail)","$6,231 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     Auto Service/Repair/Tire Store ","$3,804 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     Bank 1,000 sq ft ","$19,947 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     Building Materials/Hardware/Nursery ","$8,670 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     Convenience Store ","$50,899 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     Discount Store ","$6,269 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     Furniture Store ","$1,364 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     General Retail <100,000 sq ft ","$12,425 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     General Retail 100,000-500,000 sq ft ","$8,812 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     General Retail 500,000-1,000,000 sq ft ","$7,279 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     General Retail > 1 million sq ft ","$5,850 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     Movie Theater","$21,067 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     Restaurant, Fast Food ","$29,749 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Retail/Commercial",null,"     Restaurant, Sit-Down ","$10,249 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Office/Institutuional",null,"     Church/Synagogue","$3,087 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Office/Institutuional",null,"     Day Care Center","$6,438 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Office/Institutuional",null,"     Elementary/Scondary School","$2,454 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Office/Institutuional",null,"     Hospital","$5,949 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Office/Institutuional",null,"     Medial Office","$12,230 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Office/Institutuional",null,"     Nursing Home","$2,102 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Office/Institutuional",null,"     Office, General <100,000 sq ft","$5,542 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Office/Institutuional",null,"     Office, General >200,000 sq ft","$4,309 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Office/Institutuional",null,"     Office, General 100,000 - 200,000 sq ft","$4,726 per 1,000 sf","https://www.larimer.org/sites/default/files/uploads/2017/2015_county_tcef_schedule_form.pdf"]
["Larimer County Regional Road - Industrial",null,"     General Light Industrial/Industrial Park","$2,894 per 1,000 sf"]
["Larimer County Regional Road - Industrial",null,"     Mini-Warehouse","$1,040 per 1,000 sf"]
["Larimer County Regional Road - Industrial",null,"     Warehouse","$2,061 per 1,000 sf"]
["Electric - capacity (Commercial)",null,"     208 V single phase",null,"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees/electric-development-fee-estimator?id=3","Charged seperately, prior to scheduling of construction; Dev. Rev. fees included in development fees"]
["Electric - capacity (Commercial)",null,"     204 V single phase",null,"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees/electric-development-fee-estimator?id=3","Charged seperately, prior to scheduling of construction; Dev. Rev. fees included in development fees"]
["Electric - capacity (Commercial)",null,"     480 V single phase",null,"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees/electric-development-fee-estimator?id=3","Charged seperately, prior to scheduling of construction; Dev. Rev. fees included in development fees"]
["Electric - capacity (Commercial)",null,"     208 V three phase",null,"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees/electric-development-fee-estimator?id=3","Charged seperately, prior to scheduling of construction; Dev. Rev. fees included in development fees"]
["Electric - capacity (Commercial)",null,"     240 V three phase",null,"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees/electric-development-fee-estimator?id=3","Charged seperately, prior to scheduling of construction; Dev. Rev. fees included in development fees"]
["Electric - capacity (Commercial)",null,"     480 V three phase",null,"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees/electric-development-fee-estimator?id=3","Charged seperately, prior to scheduling of construction; Dev. Rev. fees included in development fees"]
["Electric - building site estimate",null,"     # single phase transformers"]
["Electric - building site estimate",null,"     #3 phase transformers"]
["Electric - building site estimate",null,"     Trench distance from source to single phase transformer"]
["Electric - building site estimate",null,"     Trench distance from source to three phase transformer"]
["Water PIF",null,null,null,"https://www.fcgov.com/utilities/img/site_specific/uploads/2018_Water_PIF_2018.pdf","Paid upon issuance of building permit"]
["     Water Dev. Rev. fee",null,"          3/4\"",128,"https://www.fcgov.com/utilities/img/site_specific/uploads/2017_WaterWastewaterand_Stormwater_Review_Charges_.pdf"]
["     Water Dev. Rev. fee",null,"          1\"",333]
["     Water Dev. Rev. fee",null,"          1-1/2\"",658]
["     Water Dev. Rev. fee",null,"          2\"",965]
["     Water Dev. Rev. fee",null,"          3\" and greater",2020]
["     Water Meter Size",null,"          3/4\" ","$7,530.02 = $7,180 water PIF + $350.02 water meter or $350.02 irrigation meter"]
["     Water Meter Size",null,"          1\"","$20,099.70 = $19,710 water PIF + $389.70 water meter or $389.70 irrigation meter"]
["     Water Meter Size",null,"          1-1/2\"","$42,914.31 = $42,220 water PIF + 694.31 water meter or $937.33 irrigation meter"]
["     Water Meter Size",null,"          2\"","$67,469.82 = 66,650 water PIF + 789.82 water meter or $971.24 irrigation meter"]
["     Water Meter Size",null,"          3\"  ","$     = Based on peak day demand + 2,637.76 water meter or $1,589.33 irrigation meter"]
["     Water Meter Size",null,"          4\"","$     = Based on peak day demand + $3,358.88 water meter or $2n122.50 irrigation meter"]
["Water supply requirement",null,"          3/4\"","0.900 min. WSR per acre foot or $15,570 cash, allotment per year 293,270","https://www.fcgov.com/utilities/img/site_specific/uploads/Non_Res_WSR_Schedule_2018_b.pdf","If cash payment, paid at time of permit issuance otherwise due before water service permit issuance\nUp to 2\" in diameter - if 3 and above, charged based on use\n*acre-foot = 325,851 gallons of water\n*Equivalent Cash payment $17,300/acre foot\n*Surcharge of $8.14 per 1,000 gallons assessed if over annual allotment"]
["Water supply requirement",null,"          1\"","2.270 min. WSR per acre foot or $39,271 cash, allotment per year 739,680"]
["Water supply requirement",null,"         1-1/2\"","4.720 min. WSR per acre foot or $81,656 cash, allotment per year 1,538,020"]
["Water supply requirement",null,"          2\"","7.910 min. WSR per acre foot or $136,843 cash, allotment per year 2,577,480"]
["Water supply requirement",null,"          3\" and above","Based on use"]
[null,null,"Wastewater PIF",null,"https://www.fcgov.com/utilities/img/site_specific/uploads/2018_Wastewater_PIF_2018.pdf","Paid upon issuance of building permit"]
["Wastewater Dev. Rev. fee",null,"          3/4\" ",128,"https://www.fcgov.com/utilities/img/site_specific/uploads/2017_WaterWastewaterand_Stormwater_Review_Charges_.pdf"]
["Wastewater Dev. Rev. fee",null,"          1\"",333]
["Wastewater Dev. Rev. fee",null,"          1-1/2\"",658]
["Wastewater Dev. Rev. fee",null,"          2\"",965]
["Wastewater Dev. Rev. fee",null,"          3\"  and greater",2020]
["Wastewater  PIF",null,"          3/4\" water meter size",7130]
["Wastewater  PIF",null,"          1\" water meter size",17200]
["Wastewater  PIF",null,"          1-1/2\" water meter size",33410]
["Wastewater  PIF",null,"          2\" water meter size",59140]
["Wastewater  PIF",null,"          3\"  and greater water meter size","Calculated on an individual basis, but not less than the 2\" charge"]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Fast Food Restaurant","          3/4",8748]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Fast Food Restaurant","          1\"",21102]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Fast Food Restaurant","          1-1/2\"",40997]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Fast Food Restaurant","          2\"",72562]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Restaurant","          3/4",12295]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Restaurant","          1\"",29663]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Restaurant","          1-1/2\"",57621]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Restaurant","          2\"",101986]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Commercial Laundry","          3/4",9335]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Commercial Laundry","          1\"",22517]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Commercial Laundry","          1-1/2\"",43745]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Commercial Laundry","          2\"",77426]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Car Wash","          3/4",7482]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Car Wash","          1\"",18044]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Car Wash","          1-1/2\"",35061]
["Wastewater PIF surcharge  (high strength)- full list available, examples below","     Car Wash","          2\"",62053]
["Stormwater PIF",null,"1 acre x $8,217 /acre x .8 = $6,573.60 (this is an example of 1-acre commercial site with heavy runoff)\nGross Acres = Area of development in acres, including open space and right-of-way\nBase Rate = The base rate is $8,217 per gross acre for all area of the city\nRunoff Coefficient = Determined based on the percentage of impervious area\nPI = (Gross acres of development) x ($8,217) x (Runoff coefficient)",null,"https://www.fcgov.com/utilities/img/site_specific/uploads/2018_Stormwater_PIF_2018.pdf","Applied when impervious surface area of more than 350 sq ft.  Paid upon issuance of building permit"]
["     Stormwater Dev. Rev. fee",null,"Rate factor x $1,045/acre x acres of net area",null,"https://www.fcgov.com/utilities/img/site_specific/uploads/2017_WaterWastewaterand_Stormwater_Review_Charges_.pdf","Rate factor is determined by the percentage of impervious area (area that does not absorb water) in the development.  Neta area includes allocated open space but excludes right of way."]

{"sheet":"Water","index":18,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[44,0,44,5]]}
["Water and Wastewater PIF's, WSR, and Dev Fees"]
["NOTE:  NO REFLECTION TO ANY PROPOSED CHANGES IN PIFS - PLEASE VERIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plant Investment & Dev Fees:",null,null,null,"https://www.fcgov.com/utilities/business/builders-and-developers/plant-investment-development-fees"]
["WITH UTILITY FEE AND RATE SPECIALIST AT UtilityFees@fcgov.com or 970-416-4252",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.fcgov.com/utilities/utility-rates/"]
["***********Changes to PIFs &/or Dev Rev Fees will be effective April 2018************",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.fcgov.com/utilities/manage-your-account/monitor-my-use/"]
[]
[]
[null,null,null,null,"Water ","Water",null,null,"WW"]
["Lot Area","Water","WSR","WSR","Meter","Dev Rev","Water","WW","Dev Rev","WW","Water/WW"]
["(sq.ft.)","PIF","Ac-ft","Cash","Cost","Fee","Subtotal","PIF","Fee","Subtotal","Total Cost"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"43560/2","v":21780}]
["Single Family Residential",null,null,null,null,null,null,null,null,null,null,"1/2 acre max."]
["Effective 01/01/2018"]
["For SFR: Enter Lot Sq Ft in A15 & Number of Bedrooms in L15",null,null,null,null,null,null,null,null,null,null,"Bedrooms"]
[null,{"$f":"720+A15*0.33","v":720},{"$f":"(((7.048*A15)+(12216.9*L15))/325851)*1.92","v":0},{"$f":"C15*17300","v":0},350.02,53,{"$f":"B15+D15+E15+F15","v":1123.02},3500,53,{"$f":"H15+I15","v":3553},{"$f":"G15+J15","v":4676.0200000000004}]
[]
[]
[null,"DUPLEX",null,null,"Enter Meter costs"]
["Effective 01/01/2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"acres","=",{"$f":"O19*43560","v":0},"sq ft"]
["For Duplex: Enter Lot Sq Ft in A27 , Number of Bedrooms in L27, & # of units in M27",null,null,null,null,null,null,null,null,null,null,"Bedrooms","Units"]
[null,{"$f":"(540*M21)+A21*0.24","v":0},{"$f":"(((7.048*A21)+(12216.9*L21))/325851)*1.92","v":0},{"$f":"C21*17300","v":0},700.04,{"$f":"43*M21","v":0},{"$f":"B21+D21+E21+F21","v":700.04},{"$f":"2520*M21","v":0},{"$f":"43*L21","v":0},{"$f":"H21+I21","v":0},{"$f":"G21+J21","v":700.04}]
[null,null,null,null,null,"Per Unit"]
[]
[]
[null,"Multi-Family"]
["Effective 01/01/2018"]
["For MF: Enter Lot Sq Ft in A39 , # of bedrooms in L39, & # of units in M39",null,null,null,null,null,null,null,null,null,null,"Bedrooms","# of units"]
[null,{"$f":"(540*M28)+A28*0.24","v":0},{"$f":"(((9.636*A28)+(13592.8*L28))/325851)*1.92","v":0},{"$f":"C28*17300","v":0},null,{"$f":"43*M28","v":0},{"$f":"B28+D28+E28+F28","v":0},{"$f":"2520*M28","v":0},{"$f":"43*L28","v":0},{"$f":"H28+I28","v":0},{"$f":"G28+J28","v":0}]
[null,null,null,null,"Enter Meter costs","Per Unit"]
["Non-Residential"]
["Effective 01/01/2018"]
["Non-Residential"]
[null,null,null,"WSR","Water ","Water",null,null,"WW",null,null,"Annual"]
[null,"Water","RWR","Cash","Meter","Dev Rev","Water","WW","Dev Rev","WW","Water/WW","Allotment"]
["Size","PIF","Ac-ft","@$17,300","Cost","Fee","Subtotal","PIF","Fee","Subtotal","Total Cost","(gallons)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*separate meter required, per City Code, for commercial"]
["3/4\"",7180,0.9,{"$f":"C37*17300","v":15570},350.02,128,{"$f":"B37+D37+E37+F37","v":23228.02},7130,128,{"$f":"H37+I37","v":7258},{"$f":"G37+J37","v":30486.02},293270,null,null,"buildings included in a Mixed Used Development"]
["1\"",19710,2.27,{"$f":"C38*17300","v":39271},389.7,333,59703.7,17200,333,{"$f":"H38+I38","v":17533},77236.7,739680,null,null,"i.e. Clubhouse, residential units above retail space"]
["1-1/2\"",42220,4.72,{"$f":"C39*17300","v":81656},694.31,658,125228.31,33410,658,{"$f":"H39+I39","v":34068},159296.31,1538020]
["2\"",66680,7.91,{"$f":"C40*17300","v":136843},789.82,965,205277.82,59140,965,{"$f":"H40+I40","v":60105},265382.82,2577480]
["*3\"",null,null,null,2637.76,2020,4657.76,null,2020,null,4657.76,"*325,851 gallons X ac-ft"]
["*4\"",null,null,null,3358.88,2020,5378.88,null,2020,null,5378.88]
[]
[]
["* acre-foot = 325,851 gallons of water"]
["3\" and >","         Based on usage"]
[null,"WPIF's  =  $4.66 x gpd of peak day demand"]
[null,"RWR = Peak Annual Usage x 1.92 divided by 325,851 = ac-ft   ac-ft required x $17,300 = cash in lieu"]
[null,"WWPIF's  =  $13.96/ gpd of peak day discharge PLUS infiltration and inflow, based on domestic strength waste (BOD and TSS).  "]
[null,"                                 Ratio of System I&I plus discharge to customer discharge:  x 1.465"]
[null,"SPIF = Site flow x[8.76 = (BOD x 0.0130) + (TSS x 0.0104)]+"]
[null,"            l & l flow x [8.76 + (200 mg/l x 0.0130) + (250 mg/l x 0.0104)]"]
[null,"            l & l flow x [8.76 + 2.60 + 2.60]"]
[null,"           0.465 x flow x [13.96]"]
[]
["Raw Water surcharge for usage above annual allotment  =  $8.14 / 1,000 gallons",null,null,null,null,null,null,"effective 01/01/18"]
["Conservation rate applies above 5 x average usage for that respective meter size.  "]

{"sheet":"pud calculation","index":19,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["PRELIMINARY",null,null,"ESCROW:",0]
["________________ W/WW"]
["Reviewer:  "]
["B#"]
[]
["PUD Name:","name"]
["Address:","address"]
[]
[null,null,"Basin:"]
["Site Acres:",null,"Rate:"]
["Site Sq. Ft",null,"ROC:"]
["# of Buildings"]
["Building Sq Ft"]
["ROW"]
["Parking/Drives/walks/patios"]
["Gravel"]
["Private O.S."]
["Public O.S"]
["Gross:",{"$f":"SUM(B13:B18)","v":0}]
["% Impervious",{"$f":"SUM(B13+B14+B15)/B11","v":{"$error":"#DIV/0!"}}]
["% Gravel",{"$f":"+B16/B11","v":{"$error":"#DIV/0!"}}]
["% Pervious",{"$f":"(B17+B18)/B11","v":{"$error":"#DIV/0!"}}]
["Net Acres",{"$f":"B11-B14","v":0}]
["Net % Impervious",{"$f":"SUM(B13+B15)/B23","v":{"$error":"#DIV/0!"}}]
["Net % Semi-pervious",{"$f":"+B16/B23","v":{"$error":"#DIV/0!"}}]
["Net % Pervious",{"$f":"SUM(B17+B18)/B23","v":{"$error":"#DIV/0!"}}]
[]
["Cg",{"$f":"SUM(B20*0.95)+(B21*0.5)+(B22*0.2)","v":{"$error":"#DIV/0!"}}]
["Cn",{"$f":"(B24*0.95)+(B25*0.05)+(B26*0.2)","v":{"$error":"#DIV/0!"}}]
[]
["Basin Rate:",{"$f":"8217/43560","v":0.18863636363636363}]
["SW PIF:",{"$f":"B11*B28*B31","v":{"$error":"#DIV/0!"}}]
["Review Charge:",{"$f":"(1045/43560)*B23*$D$11","v":0}]
[]
[]
[]
[]
[]
[2017,"Stormwater Units Computation for CIS"]
["Residential",null,null,null,"Commercial"]
[]
["Area in SF",21780,null,null,"Area in SF",64420]
["Runoff Coef",0.4,null,null,"Runoff Coef",0.8]
[]
["Units",{"$f":"IF(B42>12000,((B42-12000)*B51+(12000*B50))/1000*B43/B50,B42*B43/1000)","v":5.7780224688124617},null,null,"Units",{"$f":"F42*F43/1000","v":51.536000000000001}]
[]
[]
["Note: The residential units value is calculated based on Rate1 for the first 12000 SF and Rate 2 for area above 12000 SF."]
[]
["Res Rate 1",4.3527000000000001E-3]
["Res Rate 2",1.0882000000000001E-3]