{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Summary","CCC Rate Compare Graphs","Instructions","RSMP Payment Calculator","RSMP Payment Calculator (2)","Proposed Commercial","Proposed Commercial Combined","PropCommercial (MF-MU) Combined","Proposed Lg Residential Combin","Proposed Residential","Proposed Sm Residential Combin","Proposed Sm Residential Com (2)"],"not_rendered":{"charts":2,"images":1,"macros":0,"external_links":0,"defined_names":7,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":true,"merged":[[43,9,43,11],[43,1,43,3],[29,1,29,3],[1,4,1,5],[2,4,2,5],[1,1,1,3],[15,1,15,3],[1,9,1,11],[15,9,15,11],[29,9,29,11]]}
[]
[null,"Commercial Example",null,null,null,null,null,null,null,"Commercial Example"]
[null,"Total Site Area (acres)",2,null,null,null,null,null,null,"Total Site Area (acres)",7]
[null,null,"Existing I.C.","Proposed I.C.",null,null,null,null,null,null,"existing","proposed"]
[null,"Impervious Cover (%)",0.3,0.8,null,null,null,null,null,"Impervious Cover (%)",0.5,0.8]
[null,"Impervious Cover (acres)",{"$f":"$C$3*C5","v":0.6},{"$f":"$C$3*D5","v":1.6},null,null,null,null,null,"Impervious Cover (acres)",3.5,5.6000000000000005]
[null,"Land Appraisal ($/acre)",250000,null,null,null,null,null,null,"Land Appraisal ($/acre)",250000]
[null,"ENR CCI AF (CCC)",null,{"$f":"'Proposed Commercial'!$H$45","v":1.0139495160371987},null,null,null,null,null,"ENR CCI AF (CCC)",1.6998,1]
[null,"I.C. AF (LCC)",null,{"$f":"'Proposed Commercial'!H71","v":1},null,null,null,null,null,"I.C. AF (LCC)","n/a",1.4273]
[null,null,null,"Proposed Comm/MF/MU",null,null,null,null,null,null,"Current Payment Calculation","Proposed Comm/MF/MU"]
[null,"Land Value ($/acre)",null,{"$f":"'Proposed Commercial'!$D$66","v":4760448},null,null,null,null,null,"Land Value ($/acre)",120000,200000]
[null,"Construction Cost Component",null,{"$f":"'Proposed Commercial'!$H$48","v":159190.0740178402},null,null,null,null,null,"Construction Cost Component",133944.24,203400.00000000003]
[null,"Land Cost Component",null,{"$f":"'Proposed Commercial'!$H$74","v":495086.59200000012},null,null,null,null,null,"Land Cost Component",42000,99911]
[null,"Total",null,{"$f":"'Proposed Commercial'!$H$78","v":654276.66601784038},null,null,null,null,null,"Total",175944.24,303311]
[]
[null,"MF/Mixed-Use Example",null,null,null,null,null,null,null,"MF/Mixed-Use Example"]
[null,"Total Site Area (acres)",0.5,null,null,null,null,null,null,"Total Site Area (acres)",0.3]
[null,null,"Existing I.C.","Proposed I.C.",null,null,null,null,null,null,"existing","proposed"]
[null,"Impervious Cover (%)",0.5,0.9,null,null,null,null,null,"Impervious Cover (%)",0.8,0.95]
[null,"Impervious Cover (acres)",{"$f":"$C$17*C19","v":0.25},{"$f":"$C$17*D19","v":0.45},null,null,null,null,null,"Impervious Cover (acres)",0.24,0.28499999999999998]
[null,"Land Appraisal ($/acre)",2000000,null,null,null,null,null,null,"Land Appraisal ($/acre)",800000]
[null,"2018 ENR CCI AF (CCC)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"2018 ENR CCI AF (CCC)",1.6998,1]
[null,"I.C. AF (LCC)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"I.C. AF (LCC)","n/a",1.6586749999999999]
[null,null,null,"Proposed Comm/MF/MU",null,null,null,null,null,null,"Current Payment Calculation","Proposed Comm/MF/MU"]
[null,"Land Value ($/acre)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Land Value ($/acre)",120000,640000]
[null,"Construction Cost Component",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Construction Cost Component",4589.4599999999982,5804.9999999999982]
[null,"Land Cost Component",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Land Cost Component",1800,15923.279999999999]
[null,"Total",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Total",6389.4599999999982,21728.28]
[]
[null,"Single-Family Example (large development)",null,null,null,null,null,null,null,"Single-Family Example (large development)"]
[null,"Total Site Area (acres)",60,null,null,null,null,null,null,"Total Site Area (acres)",60]
[null,null,"Existing I.C.","Proposed I.C.",null,null,null,null,null,null,"existing","proposed"]
[null,"Impervious Cover (%)",0,0.5,null,null,null,null,null,"Impervious Cover (%)",0,0.5]
[null,"Impervious Cover (acres)",{"$f":"$C$31*C33","v":0},{"$f":"$C$31*D33","v":30},null,null,null,null,null,"Impervious Cover (acres)",{"$f":"$C$31*K33","v":0},{"$f":"$C$31*L33","v":30}]
[null,"Land Appraisal ($/acre)",150000,null,null,null,null,null,null,"Land Appraisal ($/acre)",150000]
[null,"2018 ENR CCI AF (CCC)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"2018 ENR CCI AF (CCC)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"I.C. AF (LCC)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"I.C. AF (LCC)","n/a",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Proposed Residential",null,null,null,null,null,null,"Current Payment Calculation","Proposed Residential"]
[null,"Land Value ($/acre)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Land Value ($/acre)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Construction Cost Component",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Construction Cost Component",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Land Cost Component",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Land Cost Component",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Total",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Total",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Single-Family Example (small resubdivision)",null,null,null,null,null,null,null,"Single-Family Example (small resubdivision)"]
[null,"Total Site Area (acres)",0.5,null,null,null,null,null,null,"Total Site Area (acres)",0.5]
[null,null,"Existing I.C.","Proposed I.C.",null,null,null,null,null,null,"existing","proposed"]
[null,"Impervious Cover (%)",0,0.45,null,null,null,null,null,"Impervious Cover (%)",0.15,0.45]
[null,"Impervious Cover (acres)",{"$f":"$C$45*C47","v":0},{"$f":"$C$45*D47","v":0.22500000000000001},null,null,null,null,null,"Impervious Cover (acres)",7.4999999999999997E-2,0.22500000000000001]
[null,"Land Appraisal ($/acre)",500000,null,null,null,null,null,null,"Land Appraisal ($/acre)",500000]
[null,"2018 ENR CCI AF (CCC)",null,{"$f":"'Proposed Residential'!H41","v":1.0139495160371987},null,null,null,null,null,"2018 ENR CCI AF (CCC)",1.6998,1]
[null,"I.C. AF (LCC)",null,{"$f":"'Proposed Residential'!H68","v":0.88742500000000002},null,null,null,null,null,"I.C. AF (LCC)","n/a",0.88742500000000002]
[null,null,null,"Proposed Residential",null,null,null,null,null,null,"Current Payment Calculation","Proposed Residential"]
[null,"Land Value ($/acre)",null,{"$f":"'Proposed Residential'!$D$62","v":589970.50147492625},null,null,null,null,null,"Land Value ($/acre)",40000,400000]
[null,"Construction Cost Component",null,{"$f":"'Proposed Residential'!$H$44","v":122855.19311064719},null,null,null,null,null,"Construction Cost Component",8923.9500000000007,15450.000000000002]
[null,"Land Cost Component",null,{"$f":"'Proposed Residential'!$H$71","v":88742.500000000015},null,null,null,null,null,"Land Cost Component",1000,8874.25]
[null,"Total",null,{"$f":"'Proposed Residential'!$H$75","v":211597.6931106472},null,null,null,null,null,"Total",9923.9500000000007,24324.25]

{"sheet":"CCC Rate Compare Graphs","index":1,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":true,"merged":[[1,1,1,2],[0,3,0,4]]}
["ENR 2002",null,null,"Cost per impervious acre",null,"Oct 2018/2002 number"]
[6579,"Impervious Acres",null,"ENR CCI AF (2018)",null,{"$f":"11183.28/6579","v":1.6998449612403101},{"$f":"11183.28/6579","v":1.6998449612403101},{"$f":"11170.28/11170.28","v":1},null,{"$f":"11170.28/11170.28","v":1}]
[null,"From","To","Commercial","Residential","Current Commercial (Adjusted)","Current Residential (Adjusted)","Proposed Commercial","Proposed Residential","Recommended Combined",null,"Unadjusted 2002 Commercial","Unadjusted 2002 Residential","Adjusted 2002 Commercial","Adjusted 2002 Residential","mid point max",null,"Proposed Commercial","Proposed Residential"]
["A1",0,1,60000,35000,{"$f":"D4*$F$2","v":101990.69767441861},{"$f":"E4*$F$2","v":59494.573643410855},129000,103000,129000,null,82500,84100,{"$f":"L4*F$2","v":140237.20930232559},{"$f":"M4*G$2","v":142956.96124031008},95000,null,129000,103000]
["A2",1.01,2,18000,15000,30597.209302325584,25497.674418604653,70000,70000,70000,null,23900,34500,{"$f":"L5*F$2","v":40626.294573643412},{"$f":"M5*G$2","v":58644.651162790702},64000,null,70000,70000]
["A3",{"$f":"C5+0.01","v":2.0099999999999998},5,8000,10000,13598.759689922481,16998.449612403103,44000,44000,44000,null,14200,22800,24137.798449612405,38756.465116279069,40000,null,44000,44000]
["A4",5.01,10,6000,7000,10199.069767441861,11898.914728682172,29000,29000,29000,null,8600,15300,14618.666666666668,26007.627906976744,26000,null,29000,29000]
["A5",10.01,20,5000,5000,8499.2248062015515,8499.2248062015515,20000,20000,20000,null,5600,10800,9519.1317829457366,18358.325581395351,18000,null,20000,20000]
["A6",20.010000000000002,50,4000,3000,6799.3798449612405,5099.5348837209303,12000,12000,12000,null,4600,5000,7819.2868217054265,8499.2248062015515,11000,null,12000,12000]
["A7",50.01,100,2500,2000,4249.6124031007757,3399.6899224806202,8000,8000,8000,null,2500,3700,4249.6124031007757,6289.4263565891479,8000,null,8000,8000]
["A8",100.01,">",2500,1500,4249.6124031007757,2549.7674418604652,4000,4000,4000,null,2500,2500,4249.6124031007757,4249.6124031007757,4000,null,4000,4000]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ENR 2018",null,"ENR 2002"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ENR AF = ",11183.28,"÷",6579,"=",1.6998]
[null,"Adjustment Factor for Relative Impervious Cover Percentage (accounts for lower or higher than City-wide average I.C.)"]
[]
[null,null,"I.C. Adjustment Factor =",null,"(1.5425    x","TOTAL Proposed I.C.)",null," + 0.1933 =",0.88742500000000002]
[null,null,null,null,null,null,"Impervious Cover (Total Proposed)"]
[null,null,null,null,null,1.5425,0.25,0.1933,{"$f":"($F$23*G23)+$H$23","v":0.57892500000000002}]
[null,null,null,null,null,null,0.3,null,0.65605000000000002]
[null,null,null,null,null,null,0.4,null,0.81030000000000002]
[null,null,null,null,null,null,0.45,null,{"$f":"($F$23*G26)+$H$23","v":0.88742500000000002}]
[null,null,null,null,null,null,0.55000000000000004,null,1.0416750000000001]
[null,null,null,null,null,null,0.65,null,1.1959250000000001]
[null,null,null,null,null,null,0.7,null,1.27305]
[null,null,null,null,null,null,0.8,null,1.4273]
[null,null,null,null,null,null,0.9,null,1.58155]
[null,null,null,null,null,null,1,null,1.7358]
[]
[]
[]
[null,null,null,null,"2018-10-01","2002-10-01"]
[null,null,null,null,11183.28,6579,{"$f":"E37/F37","v":1.6998449612403101}]
[null,"From","To","Commercial","Residential","Current Commercial (Adjusted)","Current Residential (Adjusted)","Proposed Commercial","Proposed Residential"]
["A1",0,1,60000,35000,{"$f":"D39*$G$37","v":101990.69767441861},{"$f":"E39*$G$37","v":59494.573643410855},129000,103000]
["A2",1.01,2,18000,15000,{"$f":"D40*$G$37","v":30597.209302325584},{"$f":"E40*$G$37","v":25497.674418604653},70000,70000]
["A3",{"$f":"C40+0.01","v":2.0099999999999998},5,8000,10000,13598.759689922481,16998.449612403103,44000,44000]
["A4",5.01,10,6000,7000,10199.069767441861,11898.914728682172,29000,29000]
["A5",10.01,20,5000,5000,8499.2248062015515,8499.2248062015515,20000,20000]
["A6",20.010000000000002,50,4000,3000,6799.3798449612405,5099.5348837209303,12000,12000]
["A7",50.01,100,2500,2000,4249.6124031007757,3399.6899224806202,8000,8000]
["A8",100.01,">",2500,1500,4249.6124031007757,2549.7674418604652,4000,4000]

{"sheet":"Instructions","index":2,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":true,"merged":[[48,0,57,9],[8,0,9,9],[5,0,7,9],[0,0,3,9],[40,0,46,9],[47,0,47,4],[21,0,22,9],[23,0,25,9],[27,0,27,4],[28,0,32,9],[33,0,37,9],[39,0,39,6],[10,0,11,9],[12,0,18,9],[20,0,20,4]]}
["DISCLAIMER: This calculation spreadsheet is valid until September 30, 2022 and is to be used only for the purpose of estimating participation payments. The final payment calculation will be completed by Watershed Protection Department staff. Please visit the RSMP website for more information. Please direct questions by email to RSMP@austintexas.gov."]
[]
[]
[]
["PROJECT INFORMATION"]
["Provide project name, address, watershed, case number, Map grid #, zoning, drainage reviewer, case manager, TCAD PID, and TCAD area. These fields are required when submitting application but may not yet be known at the time of the feasibility meeting. RSMP number will be provided by WPD staff."]
[]
[]
["Land use, for the purposes of the RSMP payment calculator, is defined as either single-family residential or commercial/multi-family/mixed-use. Zoning designations can be found in the Land Development Code."]
[]
["The TCAD 10-digit Parcel ID number and watershed can both be found using the Property Profile tool (link available on the RSMP website at www.austintexas.gov/rsmp)"]
[]
["Total site area for new development is the gross site area. \nTotal site area for redevelopment is the limits of construction. This is input in the land area section and automatically used if LOC area is greater than the total site area.\nExisting impervious cover is defined by permitted impervious cover\nProposed impervious cover for site plan applications should be based on the actual proposed impervious cover. For subdivisions, the proposed impervious cover should be the maximum allowable impervious cover based on zoning and watershed requirements."]
[]
[]
[]
[]
[]
[]
[]
["CONSTRUCTION COST COMPONENT"]
["The Construction Cost Component is automatically calculated based on the total site area and the existing and proposed impervious cover values provided."]
[]
["The construction cost component is multiplied by an adjustment factor which is updated on an annual basis to account for changes in construction costs. The adjustment factor is based on the ENR Construction Cost Index (CCI) and is updated each October."]
[]
[]
[]
["LAND COST COMPONENT"]
["The Land Cost Component is based on the appraised land value and then multiplied by 80%. This replaces the previously static capped $/acre values for different land use types. The Land Cost Component is also multiplied by an adjustment factor which accounts for the relative impervious cover of a site compared with the weighted average in the City. This impervious cover adjustment factor is the same as the adjustment factor for the drainage utility fee."]
[]
[]
[]
[]
["Deductible areas include floodplain/drainage easements, water quality easements, conservation easements, and other non-developable areas as defined by City ordinances. If an area is claimed as deductible for RSMP payment calculation purposes, documentation must be provided with the participation application that shows easement dedication or other supporting documentation of undevelopable area."]
[]
[]
[]
[]
[]
["CREDIT FOR CONSTRUCTION OF OFF-SITE DRAINAGE IMPROVEMENTS"]
["For sites which are participating via construction of approved off-site drainage improvements, please provide the total construction cost estimate for the improvements. This amount should match the formal cost estimate provided as part of the application and as part of Exhibit A of the formal RSMP agreement. This amount will be credited towards the calculated participation payment amount. If the cost estimate is less than the payment amount, the difference will be paid by the applicant to the City. If the cost estimate is more than the payment amount, no additional payment will be necessary and no refund will be provided."]
[]
[]
[]
[]
[]
[]
["OVERALL COST CAP"]
["An overall cap will be applied to the calculated payment amount per acre based on the estimated costs for an underground detention vault such as would be utilized on a small urban site with very high (95-100%) impervious cover (typically a tall building with parking structure). This cap ($440,000/acre initially and then indexed annually based on the Engineering News Record Construction Cost Index) is meant to prevent extremely high land appraisal values from skewing the calculated payment amount of a site so that it is out of proportion with on-site detention. The general payment calculation has a construction cost component that is based on the cost of on-site detention with the assumption that the detention would be an above-ground pond. For urban sites, where the land cost could impact the overall payment amount, the typical on-site detention solution is more likely to be an underground vault given the limited site area and high impervious cover."]

{"sheet":"RSMP Payment Calculator","index":3,"n_rows":111,"n_cols":9,"rows_kept":111,"cut":false,"hidden":false,"merged":[[19,8,26,16],[5,8,8,16],[10,8,11,16],[13,8,18,16],[81,8,81,12],[68,8,75,16],[64,8,66,16],[49,8,52,16],[58,8,62,16],[104,8,104,14],[105,8,112,16],[28,8,28,12],[56,8,56,12],[30,8,34,16],[100,8,103,16],[82,8,92,16],[0,8,3,16],[4,8,4,16],[0,0,2,7],[11,3,11,4],[12,3,12,4],[13,3,14,5],[13,6,17,7],[105,0,105,2],[106,0,106,7],[80,0,81,7],[28,4,29,7],[29,1,29,2],[53,0,55,3],[61,0,65,2],[66,6,67,7],[100,0,101,3],[100,5,101,6]]}
["DISCLAIMER: This calculation spreadsheet is valid only for estimates until September 30, 2023. Please visit the RSMP website for more information. Please direct questions by email to RSMP@austintexas.gov.",null,null,null,null,null,null,null,"DISCLAIMER: This calculation spreadsheet is valid until September 30, 2023, and is to be used only for the purpose of estimating participation payments. The final payment calculation will be completed by Watershed Protection Department staff. Please visit the RSMP website for more information. Please direct questions by email to RSMP@austintexas.gov."]
[]
[]
[null,null,null,null,null,null,"Watershed: "]
[null,null,null,null,null,null,"Mapsco Grid #: ",null,"INSTRUCTIONS for completing the payment calculation estimate tool."]
[null,null,null,null,null,null,"TCAD PID_10: ",null,"Provide project name, address, watershed, case number, Map grid #, zoning, drainage reviewer, case manager, TCAD PID, and TCAD area. These fields are required when submitting application but may not yet be known at the time of the feasibility meeting. RSMP number will be provided by WPD staff."]
[null,null,null,null,null,null,"TCAD Area: "]
[null,null,null,null,null,null,"Zoning: "]
[null,null,null,null,null,null,"SH Certified:"]
[null,null,null,null,null,null,"Type of Participation:"]
["RSMP PARTICIPATION PAYMENT CALCULATOR",null,null,null,null,null,"Drainage Reviewer: ",null,"The TCAD 10-digit Parcel ID number and watershed can both be found using the Property Profile tool (link available on the RSMP website at www.austintexas.gov/rsmp)"]
[null,null,"Project Name/ Address: ",null,null,null,"Case Manager: "]
[null,null,"Case Number: ",null,null,null,"RSMP Number: "]
[null,null,"Land Use: ",null,null,null,"NOTE: Only edit the shaded cells -- all others are calculated automatically",null,"Land use, for the purposes of the RSMP payment calculator, is defined as either single-family residential or commercial/multi-family/mixed-use. Zoning designations can be found in the Land Development Code. Use the drop-down menu to select the appropriate designation. If a development is not single family residential, \"commercial/ multi-family residential/ mixed-use\" should be chosen - this applies to churches, ROW, industrial, etc. Note that this drop-down must be selected to populate the calculator."]
[]
[]
["Input Site and Impervious Cover Area in Acres"]
[]
[null,"1 acre = 43,560 SF",null,null,null,"Area (acres)",null,"Impervious %"]
[null,null,null,null,"Total Site Area = ",null,null,null,"Total site area for new development is the gross site area. \nTotal site area for redevelopment is the limits of construction. This is input in the land area section and automatically used if LOC area is greater than the total site area.\nExisting impervious cover is defined by permitted impervious cover\nProposed impervious cover for site plan applications should be based on the actual proposed impervious cover. For subdivisions, the proposed impervious cover should be the maximum allowable impervious cover based on zoning and watershed requirements."]
[]
[null,null,null,null,"Existing Impervious Cover Area = ",null,null,{"$f":"F22/$F$20","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Proposed Impervious Cover Area = ",null,null,{"$f":"F24/$F$20","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Increase in Impervious Cover Area  = ",{"$f":"F24-F22","v":0},null,{"$f":"F26/$F$20","v":{"$error":"#DIV/0!"}}]
[]
[]
["Construction Cost Component (CCC)",null,null,null,"Values in this section are calculated automatically based on inputs of site area, impervious cover, and land use",null,null,null,"CONSTRUCTION COST COMPONENT"]
[null,"Impervious Acres"]
[null,"From","To","Cost per impervious acre","X","Impervious Acres","=","Sub-Total Cost","The Construction Cost Component is automatically calculated based on the total site area and the existing and proposed impervious cover values provided."]
["A1",0,1,{"$f":"IF($D$14='Proposed Residential'!$I$12,'Proposed Commercial'!D33,IF($D$14='Proposed Residential'!$I$11,'Proposed Residential'!D29,\"Input Error\"))","v":"Input Error"},null,{"$f":"IF($F$26>1,1,$F$26)","v":0},"ac.",{"$f":"D32*F32","v":{"$error":"#VALUE!"}}]
[]
["A2",1.01,2,{"$f":"IF($D$14='Proposed Residential'!$I$12,'Proposed Commercial'!D34,IF($D$14='Proposed Residential'!$I$11,'Proposed Residential'!D30,\"Input Error\"))","v":"Input Error"},null,{"$f":"IF($F$26>C32,IF(($F$26-C34)>0,C34-C32,IF($F$26>C32,($F$26-C32),0)),0)","v":0},"ac.",{"$f":"D34*F34","v":{"$error":"#VALUE!"}}]
[]
["A3",{"$f":"C34+0.01","v":2.0099999999999998},5,{"$f":"IF($D$14='Proposed Residential'!$I$12,'Proposed Commercial'!D35,IF($D$14='Proposed Residential'!$I$11,'Proposed Residential'!D31,\"Input Error\"))","v":"Input Error"},null,{"$f":"IF($F$26>C34,IF(($F$26-C36)>0,C36-C34,IF($F$26>C34,($F$26-C34),0)),0)","v":0},"ac.",{"$f":"D36*F36","v":{"$error":"#VALUE!"}}]
[]
["A4",{"$f":"C36+0.01","v":5.01},10,{"$f":"IF($D$14='Proposed Residential'!$I$12,'Proposed Commercial'!D36,IF($D$14='Proposed Residential'!$I$11,'Proposed Residential'!D32,\"Input Error\"))","v":"Input Error"},null,{"$f":"IF($F$26>C36,IF(($F$26-C38)>0,C38-C36,IF($F$26>C36,($F$26-C36),0)),0)","v":0},"ac.",{"$f":"D38*F38","v":{"$error":"#VALUE!"}}]
[]
["A5",{"$f":"C38+0.01","v":10.01},20,{"$f":"IF($D$14='Proposed Residential'!$I$12,'Proposed Commercial'!D37,IF($D$14='Proposed Residential'!$I$11,'Proposed Residential'!D33,\"Input Error\"))","v":"Input Error"},null,{"$f":"IF($F$26>C38,IF(($F$26-C40)>0,C40-C38,IF($F$26>C38,($F$26-C38),0)),0)","v":0},"ac.",{"$f":"D40*F40","v":{"$error":"#VALUE!"}}]
[]
["A6",{"$f":"C40+0.01","v":20.010000000000002},50,{"$f":"IF($D$14='Proposed Residential'!$I$12,'Proposed Commercial'!D38,IF($D$14='Proposed Residential'!$I$11,'Proposed Residential'!D34,\"Input Error\"))","v":"Input Error"},null,{"$f":"IF($F$26>C40,IF(($F$26-C42)>0,C42-C40,IF($F$26>C40,($F$26-C40),0)),0)","v":0},"ac.",{"$f":"D42*F42","v":{"$error":"#VALUE!"}}]
[]
["A7",{"$f":"C42+0.01","v":50.01},100,{"$f":"IF($D$14='Proposed Residential'!$I$12,'Proposed Commercial'!D39,IF($D$14='Proposed Residential'!$I$11,'Proposed Residential'!D35,\"Input Error\"))","v":"Input Error"},null,{"$f":"IF($F$26>C42,IF(($F$26-C44)>0,C44-C42,IF($F$26>C42,($F$26-C42),0)),0)","v":0},"ac.",{"$f":"D44*F44","v":{"$error":"#VALUE!"}}]
[]
["A8",{"$f":"C44+0.01","v":100.01},">",{"$f":"IF($D$14='Proposed Residential'!$I$12,'Proposed Commercial'!D40,IF($D$14='Proposed Residential'!$I$11,'Proposed Residential'!D36,\"Input Error\"))","v":"Input Error"},null,{"$f":"IF($F$26>C44,IF(($F$26-1000000)>0,1000000-C44,IF($F$26>C44,($F$26-C44),0)),0)","v":0},"ac.",{"$f":"D46*F46","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"SUB TOTAL",null,{"$f":"SUM(F32:F46)","v":0},"ac.",{"$f":"SUM(H32:H46)","v":{"$error":"#VALUE!"}}]
[]
["Adjustment Factor",null,null,null,null,null,null,null,"The construction cost component is multiplied by an adjustment factor which is updated on an annual basis to account for changes in construction costs. The adjustment factor is based on the ENR Construction Cost Index (CCI) and is updated each October."]
[null,null,null,"ENR 2022",null,"ENR 2018"]
[null,null,"ENR AF = ",13173.43,"÷",11170.28,"=",{"$f":"D52/F52","v":1.1793285396605993}]
[]
["Note: this adjustment factor accounts for annual changes in construction costs based on ENR CCI from October each year.",null,null,null,null,"CCC Sub Total ($)","ENR AF","Adjusted CCC Total"]
[null,null,null,null,null,{"$f":"H48","v":{"$error":"#VALUE!"}},{"$f":"\"x \"&ROUND(D52/F52,4)&\" = \"","v":"x 1.1793 = "},{"$f":"F55*H52","v":{"$error":"#VALUE!"}}]
[]
["Land Cost Component (LCC)",null,null,null,null,null,null,null,"LAND COST COMPONENT"]
["Part A - Land Cost per Acre"]
[null,null,null,null,"TCAD Parcel ID (10-digit)* = ",null,"Value = ",null,"The Land Cost Component is based on the appraised land value and then multiplied by 80%. This replaces the previously static capped $/acre values for different land use types. The Land Cost Component is also multiplied by an adjustment factor which accounts for the relative impervious cover of a site compared with the weighted average in the City. This impervious cover adjustment factor is the same as the adjustment factor for the drainage utility fee."]
[]
[null,null,null,null,"Appraisal District: ",null,"Tax Year: "]
["User Inputs - if different from appraisal district land value and area (provide certified appraisal documentation)"]
[null,null,null,"Certified Appraisal Land Valuation ($)",null,"Certified Appraisal Land Area (Acre)",null,"Certified Appraisal Value per Acre"]
[null,null,null,{"$f":"H59","v":0},"÷",{"$f":"F20","v":0},"=",{"$f":"D64/F64","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"The TCAD 10-digit Parcel ID number and watershed can both be found using the Property Profile tool (link available on the RSMP website at www.austintexas.gov/rsmp)"]
[]
["Part B - Land Cost Area",null,null,null,null,{"$f":"IF(F64=F20,\"equal\",\"not the same\")","v":"equal"},"User Input - if greater than total site area"]
[null,null,null,null,"Limits of Construction Area (acres) = "]
[null,null,null,null,null,null,null,null,"Deductible areas include floodplain/drainage easements, water quality easements, conservation easements, and other non-developable areas as defined by City ordinances. If an area is claimed as deductible for RSMP payment calculation purposes, documentation must be provided with the participation application that shows easement dedication or other supporting documentation of undevelopable area."]
["Deductible Areas (must have documentation of easements to deduct)"]
[null,null,null,null,"SF","Acres"]
[null,null,null,"Floodplain/Drainage Easement Area: ",null,{"$f":"E72/43560","v":0}]
[null,null,null,"Water Quality Easement Area: ",null,{"$f":"E73/43560","v":0}]
[null,null,null,"Conservation Easement Area: ",null,{"$f":"E74/43560","v":0}]
[]
[null,null,null,null,"Total Deductible Land Area  (acres) = ",{"$f":"SUM(F72:F74)","v":0}]
[]
[null,null,null,"Value per Acre",null,"Land Cost Area***",null,"Land Cost Component (LCC)"]
[null,null,"80%   x",{"$f":"H64","v":{"$error":"#DIV/0!"}},"x 0.05 x",{"$f":"IF(F68>F20,F68,F20)-F76","v":0},"=",{"$f":"0.8*D79*0.05*F79","v":{"$error":"#DIV/0!"}}]
[]
["Adjustment Factor for Relative Impervious Cover Percentage (accounts for lower or higher than City-wide average I.C.)"]
[null,null,null,null,null,null,null,null,"OVERALL COST CAP"]
[null,null,null,"I.C. Adjustment Factor =","(1.5425 x",{"$f":"H24","v":{"$error":"#DIV/0!"}},") + 0.1933 =",{"$f":"IF(((1.5425*F83)+0.1933)<1,(1.5425*F83)+0.1933,1)","v":{"$error":"#DIV/0!"}},"An overall cap will be applied to the calculated payment amount per acre based on the estimated costs for an underground detention vault such as would be utilized on a small urban site with very high (95-100%) impervious cover (typically a tall building with parking structure). This cap ($440,000/acre initially and then indexed annually based on the Engineering News Record Construction Cost Index) is meant to prevent extremely high land appraisal values from skewing the calculated payment amount of a site so that it is out of proportion with on-site detention. The general payment calculation has a construction cost component that is based on the cost of on-site detention with the assumption that the detention would be an above-ground pond. For urban sites, where the land cost could impact the overall payment amount, the typical on-site detention solution is more likely to be an underground vault given the limited site area and high impervious cover."]
[]
[null,null,null,null,null,"LCC Sub Total ($)","I.C. AF","Adjusted LCC Total"]
[null,null,null,null,null,{"$f":"H79","v":{"$error":"#DIV/0!"}},{"$f":"\"x \"&ROUND(H83,4)&\" = \"","v":{"$error":"#DIV/0!"}},{"$f":"F86*H83","v":{"$error":"#DIV/0!"}}]
[]
["Total RSMP Participation Cost"]
[null,null,null,"Adjusted CCC",null,"LCC",null,"Total "]
[null,null,null,{"$f":"H55","v":{"$error":"#VALUE!"}},"+",{"$f":"H86","v":{"$error":"#DIV/0!"}},"=",{"$f":"IF(D95>D96,$D$93,$D$92)","v":{"$error":"#VALUE!"}}]
[]
[null,"Calculated",null,{"$f":"D90+F90","v":{"$error":"#VALUE!"}}]
[null,"Capped",null,{"$f":"D96*F20","v":0}]
[null,null,null,"Check for extreme $/acre RSMP cost and use cap as necessary"]
[null,null,null,{"$f":"(D90+F90)/F20","v":{"$error":"#VALUE!"}},"per acre"]
[null,null,null,{"$f":"440000*H52","v":518904.55745066365},"per acre"]
[]
[null,null,null,{"$f":"IF(D95>D96,\"USE CAPPED RATE\", \"USE CALCULATED RATE\")","v":{"$error":"#VALUE!"}}]
[]
["S.M.A.R.T. Housing Payment Adjustment",null,null,null,null,null,null,null,"Affordable Housing Discount Structure"]
["Affordability Term (in years, must be at least 40):",null,null,null,null,"Smart Housing Adjustment**:",null,{"$f":"IF(H9=\"yes\",IF(E101>=40,IF(AND(E103>10%,E103<50%),E103,IF(E103<10%,\"n/a\",IF(OR(E103=50%,E103>50%),E103,\"n/a\"))),\"n/a\"),\"not SH\")","v":"not SH"},"Only applicable for SH certified developments which meet additional requirements as adopted in the FY22 Budget. Minimum term of affordability is 40 years. Minimum percentage of units is 10%. \n**The \"SH Certified\" cell at the top of the form must have a value of \"yes\" for this portion of the spreadsheet to calculate."]
[]
[null,null,null,"Percentage of Affordable Units:",null,null,"Final Total:",{"$f":"IF(H101=\"n/a\",H90,(H90*(1-H101)))","v":{"$error":"#VALUE!"}}]
[]
["Public Improvements Provided in Lieu of On-site Detention",null,null,null,null,null,null,null,"CREDIT FOR CONSTRUCTION OF OFF-SITE DRAINAGE IMPROVEMENTS"]
["Short description:",null,null,null,null,null,null,null,"For sites which are participating via construction of approved off-site drainage improvements, please provide a brief description of the RSMP improvements and the total construction cost estimate for the improvements. This amount should match the formal cost estimate provided as part of the application and as part of Exhibit A of the formal RSMP agreement. This amount will be credited towards the calculated participation payment amount. If the cost estimate is less than the payment amount, the difference will be paid by the applicant to the City. If the cost estimate is more than the payment amount, no additional payment will be necessary and no refund will be provided.\n^the \"short description\" must be filled out and the participation type must be \"improvements\" for this calculation to populate. Participation by payment does not need this section."]
["Refer to construction documents and cost estimate attached to the RSMP agreement."]
[]
["Adjustment of Participation Payment based on Engineer's Cost Estimate of Improvements"]
[null,null,null,"Total",null,"Construction Cost Estimate^",null,"Remaining Payment"]
[null,null,null,{"$f":"IF(H101>0,H103,H90)","v":{"$error":"#VALUE!"}},"-",null,"=",{"$f":"IF(H10=\"improvements\",IF(D106=\"\",\"refer to total\",IF(D111-F111>0,D111-F111,\"no remaining cost\")),\"this section not applicable - refer to total\")","v":"this section not applicable - refer to total"}]

{"sheet":"RSMP Payment Calculator (2)","index":4,"n_rows":106,"n_cols":9,"rows_kept":106,"cut":false,"hidden":true,"merged":[[100,0,100,2],[101,0,101,7],[27,4,28,7],[28,1,28,2],[52,0,54,3],[60,0,64,2],[65,6,66,7],[80,0,81,7],[15,0,16,7],[0,0,2,7],[9,3,9,4],[10,3,10,4],[11,3,12,5],[11,6,14,7]]}
["DISCLAIMER: This calculation spreadsheet is valid only for estimates until September 30, 2021. Please visit the RSMP website for more information. Please direct questions by email to RSMP@austintexas.gov."]
[]
[]
[null,null,null,null,null,null,"Watershed: "]
[null,null,null,null,null,null,"Mapsco Grid #: "]
[null,null,null,null,null,null,"TCAD PID_10: "]
[null,null,null,null,null,null,"TCAD Area: "]
[null,null,null,null,null,null,"Zoning: "]
["RSMP PARTICIPATION PAYMENT CALCULATOR",null,null,null,null,null,"Drainage Reviewer: "]
[null,null,"Project Name/ Address: ",null,null,null,"Case Manager: "]
[null,null,"Case Number: ",null,null,null,"RSMP Number: "]
[null,null,"Land Use: ","Commercial/ Multi-family Residential/ Mixed-Use",null,null,"NOTE: Only edit the shaded cells -- all others are calculated automatically"]
[]
[]
["Input Site and Impervious Cover Area in Acres"]
["NOTE: The total site and impervious cover areas entered must include any additional area beyond the property boundary that is within the limits of construction for the project."]
[]
[]
[null,"1 acre = 43,560 SF",null,null,null,"Area (acres)",null,"Impervious %"]
[null,null,null,null,"Total Site Area = ",0.45]
[]
[null,null,null,null,"Existing Impervious Cover Area = ",0,null,{"$f":"F22/$F$20","v":0}]
[]
[null,null,null,null,"Proposed Impervious Cover Area = ",null,null,{"$f":"F24/$F$20","v":0}]
[]
[null,null,null,null,"Increase in Impervious Cover Area  = ",{"$f":"F24-F22","v":0},null,{"$f":"F26/$F$20","v":0}]
[]
["Construction Cost Component (CCC)",null,null,null,"Values in this section are calculated automatically based on inputs of site area, impervious cover, and land use"]
[null,"Impervious Acres"]
[null,"From","To","Cost per impervious acre","X","Impervious Acres","=","Sub-Total Cost"]
["A1",0,1,{"$f":"IF($D$12='Proposed Residential'!$I$12,'Proposed Commercial'!D33,IF($D$12='Proposed Residential'!$I$11,'Proposed Residential'!D29,\"Input Error\"))","v":129000},null,{"$f":"IF($F$26>1,1,$F$26)","v":0},"ac.",{"$f":"D31*F31","v":0}]
[]
["A2",1.01,2,{"$f":"IF($D$12='Proposed Residential'!$I$12,'Proposed Commercial'!D34,IF($D$12='Proposed Residential'!$I$11,'Proposed Residential'!D30,\"Input Error\"))","v":70000},null,{"$f":"IF($F$26>C31,IF(($F$26-C33)>0,C33-C31,IF($F$26>C31,($F$26-C31),0)),0)","v":0},"ac.",{"$f":"D33*F33","v":0}]
[]
["A3",{"$f":"C33+0.01","v":2.0099999999999998},5,{"$f":"IF($D$12='Proposed Residential'!$I$12,'Proposed Commercial'!D35,IF($D$12='Proposed Residential'!$I$11,'Proposed Residential'!D31,\"Input Error\"))","v":44000},null,{"$f":"IF($F$26>C33,IF(($F$26-C35)>0,C35-C33,IF($F$26>C33,($F$26-C33),0)),0)","v":0},"ac.",{"$f":"D35*F35","v":0}]
[]
["A4",{"$f":"C35+0.01","v":5.01},10,{"$f":"IF($D$12='Proposed Residential'!$I$12,'Proposed Commercial'!D36,IF($D$12='Proposed Residential'!$I$11,'Proposed Residential'!D32,\"Input Error\"))","v":29000},null,{"$f":"IF($F$26>C35,IF(($F$26-C37)>0,C37-C35,IF($F$26>C35,($F$26-C35),0)),0)","v":0},"ac.",{"$f":"D37*F37","v":0}]
[]
["A5",{"$f":"C37+0.01","v":10.01},20,{"$f":"IF($D$12='Proposed Residential'!$I$12,'Proposed Commercial'!D37,IF($D$12='Proposed Residential'!$I$11,'Proposed Residential'!D33,\"Input Error\"))","v":20000},null,{"$f":"IF($F$26>C37,IF(($F$26-C39)>0,C39-C37,IF($F$26>C37,($F$26-C37),0)),0)","v":0},"ac.",{"$f":"D39*F39","v":0}]
[]
["A6",{"$f":"C39+0.01","v":20.010000000000002},50,{"$f":"IF($D$12='Proposed Residential'!$I$12,'Proposed Commercial'!D38,IF($D$12='Proposed Residential'!$I$11,'Proposed Residential'!D34,\"Input Error\"))","v":12000},null,{"$f":"IF($F$26>C39,IF(($F$26-C41)>0,C41-C39,IF($F$26>C39,($F$26-C39),0)),0)","v":0},"ac.",{"$f":"D41*F41","v":0}]
[]
["A7",{"$f":"C41+0.01","v":50.01},100,{"$f":"IF($D$12='Proposed Residential'!$I$12,'Proposed Commercial'!D39,IF($D$12='Proposed Residential'!$I$11,'Proposed Residential'!D35,\"Input Error\"))","v":8000},null,{"$f":"IF($F$26>C41,IF(($F$26-C43)>0,C43-C41,IF($F$26>C41,($F$26-C41),0)),0)","v":0},"ac.",{"$f":"D43*F43","v":0}]
[]
["A8",{"$f":"C43+0.01","v":100.01},">",{"$f":"IF($D$12='Proposed Residential'!$I$12,'Proposed Commercial'!D40,IF($D$12='Proposed Residential'!$I$11,'Proposed Residential'!D36,\"Input Error\"))","v":4000},null,{"$f":"IF($F$26>C43,IF(($F$26-1000000)>0,1000000-C43,IF($F$26>C43,($F$26-C43),0)),0)","v":0},"ac.",{"$f":"D45*F45","v":0}]
[]
[null,null,null,"SUB TOTAL",null,{"$f":"SUM(F31:F45)","v":0},"ac.",{"$f":"SUM(H31:H45)","v":0}]
[]
["Adjustment Factor"]
[null,null,null,"ENR 2020",null,"ENR 2018"]
[null,null,"ENR AF = ",11326.1,"÷",11170.28,"=",{"$f":"D51/F51","v":1.0139495160371987}]
[]
["Note: this adjustment factor accounts for annual changes in construction costs based on ENR CCI from October each year.",null,null,null,null,"CCC Sub Total ($)","ENR AF","Adjusted CCC Total"]
[null,null,null,null,null,{"$f":"H47","v":0},{"$f":"\"x \"&ROUND(D51/F51,4)&\" = \"","v":"x 1.0139 = "},{"$f":"F54*H51","v":0}]
[]
["Land Cost Component (LCC)"]
["Part A - Land Cost per Acre"]
[null,null,null,null,"TCAD Parcel ID (10-digit)* = ",null,"Value = "]
[]
[null,null,null,null,"Appraisal District: ",null,"Tax Year: ",{"$f":"YEAR(TODAY())","v":2022}]
["User Inputs - if different from appraisal district land value and area (provide certified appraisal documentation)"]
[null,null,null,"Certified Appraisal Land Valuation ($)",null,"Certified Appraisal Land Area (Acre)",null,"Certified Appraisal Value per Acre"]
[null,null,null,{"$f":"H58","v":0},"÷",{"$f":"F20","v":0.45},"=",{"$f":"D63/F63","v":0}]
[]
[]
["Part B - Land Cost Area",null,null,null,null,null,"User Input - if greater than total site area"]
[null,null,null,null,"Limits of Construction Area (acres) = "]
[]
["Deductible Areas (must have documentation of easements to deduct)"]
[null,null,null,null,"SF","Acres"]
[null,null,null,"Floodplain/Drainage Easement Area: ",null,{"$f":"E71/43560","v":0}]
[null,null,null,"Water Quality Easement Area: "]
[null,null,null,"Conservation Easement Area: "]
[]
[null,null,null,null,"Total Deductible Land Area  (acres) = ",{"$f":"SUM(F71:F73)","v":0}]
[]
[null,null,null,"Value per Acre",null,"Land Cost Area***",null,"Land Cost Component (LCC)"]
[null,null,"80%   x",{"$f":"H63","v":0},"x 0.05 x",{"$f":"IF(F67>F20,F67,F20)-F75","v":0.45},"=",{"$f":"0.8*D78*0.05*F78","v":0}]
[]
[]
["Adjustment Factor for Relative Impervious Cover Percentage (accounts for lower or higher than City-wide average I.C.)"]
[]
[null,null,null,"I.C. Adjustment Factor =","(1.5425 x",{"$f":"H24","v":0},") + 0.1933 =",{"$f":"IF(((1.5425*F83)+0.1933)<1,(1.5425*F83)+0.1933,1)","v":0.1933}]
[]
[null,null,null,null,null,"LCC Sub Total ($)","I.C. AF","Adjusted LCC Total"]
[null,null,null,null,null,{"$f":"H78","v":0},{"$f":"\"x \"&ROUND(H83,4)&\" = \"","v":"x 0.1933 = "},{"$f":"F86*H83","v":0}]
[]
["Total RSMP Participation Cost"]
[null,null,null,"Adjusted CCC",null,"LCC",null,"Total "]
[null,null,null,{"$f":"H54","v":0},"+",{"$f":"H86","v":0},"=",{"$f":"IF(D95>D96,$D$93,$D$92)","v":0}]
[]
[null,"Calculated",null,{"$f":"D90+F90","v":0}]
[null,"Capped",null,{"$f":"D96*F20","v":198000},null,null,null,null,{"$f":"D98","v":"USE CALCULATED RATE"}]
[null,null,null,"Check for extreme $/acre RSMP cost and use cap as necessary"]
[null,null,null,{"$f":"(D90+F90)/F20","v":0},"per acre"]
[null,null,null,440000,"per acre"]
[]
[null,null,null,{"$f":"IF(D95>D96,\"USE CAPPED RATE\", \"USE CALCULATED RATE\")","v":"USE CALCULATED RATE"}]
[]
["Public Improvements Provided in Lieu of On-site Detention"]
["Short description:"]
["Refer to construction documents and cost estimate attached to the RSMP agreement."]
[]
["Adjustment of Participation Payment based on Engineer's Cost Estimate of Improvements"]
[null,null,null,"Total",null,"Construction Cost Estimate",null,"Remaining Payment"]
[null,null,null,{"$f":"H90","v":0},"-",null,"=",{"$f":"D106-F106","v":0}]

{"sheet":"Proposed Commercial","index":5,"n_rows":86,"n_cols":19,"rows_kept":86,"cut":false,"hidden":true,"merged":[[30,1,30,2],[68,0,69,7],[0,0,3,7]]}
["DISCLAIMER: This calculation spreadsheet is valid until September 30, 2020 and is to be used only for the purpose of previewing the proposed changes to the payment structure for FY21. Please visit the RSMP website for more information. Please direct questions by email to RSMP@austintexas.gov."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Watershed: "]
[null,null,null,null,null,null,null,null,null,null,null,"Mapsco Grid #: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD PID_10: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD Area: "]
[null,null,null,null,null,null,null,null,null,null,null,"Zoning: "]
[null,null,null,null,null,null,null,null,null,null,null,"Drainage Reviewer: "]
[null,null,null,null,null,null,null,null,null,null,null,"Case Manager: "]
[]
["RSMP PARTICIPATION PAYMENT CALCULATOR (proposed)"]
[]
[null,null,"Project Name: ","Address/Case Name"]
[null,null,"Case Number: ","RSMP Number, Case Number"]
[]
["Input Site and Impervious Cover Area in Acres"]
["NOTE: The total and impervious cover areas entered must include any additional area beyond"]
["the property boundary that is within the limits of construction for the project."]
[null,null,null,null,null,"Area (acres)",null,"Impervious %",null,"Area (SF)"]
[null,null,null,null,"Total Site Area = ",2.5,null,null,null,{"$f":"F22*43560","v":108900}]
[]
[null,null,null,null,"Existing Impervious Cover Area = ",1,null,{"$f":"F24/F22","v":0.4},null,{"$f":"F24*43560","v":43560}]
[]
[null,null,null,null,"Proposed Impervious Cover Area = ",2.4,null,{"$f":"F26/F22","v":0.96},null,{"$f":"F26*43560","v":104544}]
[]
[null,null,null,null,"Increase in Impervious Cover Area  = ",{"$f":"F26-F24","v":1.4},null,{"$f":"F28/F22","v":0.55999999999999994},null,{"$f":"F28*43560","v":60983.999999999993}]
[]
["Construction Cost Component (CCC)"]
[null,"Impervious Acres"]
[null,"From","To","Cost per impervious acre",null,"Impervious Acres",null,"Sub-Total Cost"]
["A1",0,1,{"$f":"'CCC Rate Compare Graphs'!R4","v":129000},null,{"$f":"IF($F$28>1,1,$F$28)","v":1},"ac.",{"$f":"D33*F33","v":129000}]
["A2",1.01,2,{"$f":"'CCC Rate Compare Graphs'!R5","v":70000},null,{"$f":"IF($F$28>C33,IF(($F$28-C34)>0,C34-C33,IF($F$28>C33,($F$28-C33),0)),0)","v":0.39999999999999991},"ac.",27999.999999999993]
["A3",{"$f":"C34+0.01","v":2.0099999999999998},5,{"$f":"'CCC Rate Compare Graphs'!R6","v":44000},null,0,"ac.",0]
["A4",5.01,10,{"$f":"'CCC Rate Compare Graphs'!R7","v":29000},null,0,"ac.",0]
["A5",10.01,20,{"$f":"'CCC Rate Compare Graphs'!R8","v":20000},null,0,"ac.",0]
["A6",20.010000000000002,50,{"$f":"'CCC Rate Compare Graphs'!R9","v":12000},null,0,"ac.",0]
["A7",50.01,100,{"$f":"'CCC Rate Compare Graphs'!R10","v":8000},null,0,"ac.",0,null,null,null,null,null,null,"ENR 2018",null,"ENR 2002"]
["A8",100.01,">",{"$f":"'CCC Rate Compare Graphs'!R11","v":4000},null,{"$f":"IF($F$28>C39,IF(($F$28-1000000)>0,1000000-C39,IF($F$28>C39,($F$28-C39),0)),0)","v":0},"ac.",0,null,null,null,null,null,"ENR AF = ",11183.28,"÷",6579,"=",1.6998]
[null,null,null,"SUB TOTAL",null,{"$f":"SUM(F33:F40)","v":1.4},"ac.",{"$f":"SUM(H33:H40)","v":157000}]
[]
["Adjustment Factor (accounts for changes in construction costs)"]
[null,null,null,"ENR 2019",null,"ENR 2018",null,null,null,"September 18 CCI value"]
[null,null,"ENR AF = ",11326.1,"÷",11170.28,"=",{"$f":"D45/F45","v":1.0139495160371987}]
[]
[null,null,null,null,null,"CCC Sub Total ($)","ENR AF","Adjusted CCC Total"]
[null,null,null,null,null,{"$f":"H41","v":157000},{"$f":"\"x \"&ROUND(D45/F45,4)&\" = \"","v":"x 1.0139 = "},{"$f":"F48*H45","v":159190.0740178402}]
[]
["Land Cost Component (LCC)"]
["Part A - Land Cost per Acre"]
["Type values into boxes that indicate required user input."]
[]
[null,null,null,null,"TCAD Parcel ID (10-digit) = ",null,"Value = ",{"$f":"5950560+2975280+2975280","v":11901120},null,null,"Tax Year"]
[]
[null,null,null,"Certified Appraisal Land Valuation ($)*",null,"Certified Appraisal Land Area (Acre)",null,"Certified Appraisal Value per Acre"]
[null,null,null,{"$f":"H54","v":11901120},"÷",{"$f":"F22","v":2.5},"=",{"$f":"D57/F57","v":4760448},null,null,null,null,"Area"]
[null,null,null,"User Input",null,"User Input",null,null,null,null,null,null,"SF","Acres"]
["* Certified appraisal value if available, otherwise use the current appraisal district land values.",null,null,null,null,null,null,null,null,null,null,"Floodplain/Drainage Easement Area: ",null,{"$f":"M59/43560","v":0}]
["Part B - Land Cost Area",null,null,null,null,null,null,null,null,null,null,"Water Quality Easement Area: "]
[null,null,null,null,"Limits of Construction Area (acres) = ",2.6,null,null,null,null,null,"Conservation Easement Area: "]
[]
[null,null,null,null,"Deductible Land Area  (acres) = ",{"$f":"M63","v":0},null,null,null,null,null,"Total Deductible Area: ",{"$f":"SUM(M59:M61)","v":0},{"$f":"SUM(N59:N61)","v":0}]
[]
[null,null,null,"Value per Acre",null,"Land Cost Area",null,"Land Cost Component (LCC)"]
[null,null,"80%   x",{"$f":"H57","v":4760448},"x 0.05 x",{"$f":"IF(F61>F22,F61,F22)-F63","v":2.6},"=",{"$f":"0.8*D66*0.05*F66","v":495086.59200000012}]
[null,null,null,null,null,"User Input"]
[]
["Adjustment Factor for Relative Impervious Cover Percentage (accounts for lower or higher than City-wide average I.C.)"]
[]
[null,null,null,"I.C. Adjustment Factor =","(1.5425 x",{"$f":"H26","v":0.96},") + 0.1933 =",{"$f":"IF(((1.5425*F71)+0.1933)<1,(1.5425*F71)+0.1933,1)","v":1}]
[]
[null,null,null,null,null,"LCC Sub Total ($)","I.C. AF","Adjusted LCC Total"]
[null,null,null,null,null,{"$f":"H66","v":495086.59200000012},{"$f":"\"x \"&ROUND(H71,4)&\" = \"","v":"x 1 = "},{"$f":"F74*H71","v":495086.59200000012}]
[]
["Total RSMP Participation Cost"]
[null,null,null,"Adjusted CCC",null,"LCC",null,"Total "]
[null,"Calculated",null,{"$f":"H48","v":159190.0740178402},"+",{"$f":"H74","v":495086.59200000012},"=",{"$f":"D78+F78","v":654276.66601784038}]
[]
[null,"Capped",null,null,null,null,null,{"$f":"D84*F22","v":1100000}]
[null,null,null,null,null,null,null,null,{"$f":"D86","v":"USE CALCULATED RATE"}]
[null,null,null,"Check for extreme $/acre RSMP cost and use cap as necessary"]
[null,null,null,{"$f":"(D78+F78)/F22","v":261710.66640713616},"per acre"]
[null,null,null,440000,"per acre"]
[]
[null,null,null,{"$f":"IF(D83>D84,\"USE CAPPED RATE\", \"USE CALCULATED RATE\")","v":"USE CALCULATED RATE"}]

{"sheet":"Proposed Commercial Combined","index":6,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":true,"merged":[[26,1,26,2]]}
[null,null,null,null,null,null,null,null,null,null,null,"Watershed: "]
[null,null,null,null,null,null,null,null,null,null,null,"Mapsco Grid #: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD PID_10: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD Area: "]
[null,null,null,null,null,null,null,null,null,null,null,"Zoning: "]
[null,null,null,null,null,null,null,null,null,null,null,"Drainage Reviewer: "]
[null,null,null,null,null,null,null,null,null,null,null,"Case Manager: "]
[]
["RSMP PARTICIPATION PAYMENT CALCULATOR (proposed)"]
[]
[null,null,"Project Name: ","Address/Case Name"]
[null,null,"Case Number: ","RSMP Number, Case Number"]
[]
["Input Site and Impervious Cover Area in Acres"]
["NOTE: The total and impervious cover areas entered must include any additional area beyond"]
["the property boundary that is within the limits of construction for the project."]
[null,null,null,null,null,"Area (acres)",null,"Impervious %",null,"Area (SF)"]
[null,null,null,null,"Total Site Area = ",{"$f":"Summary!C3","v":2},null,null,null,{"$f":"F18*43560","v":87120}]
[]
[null,null,null,null,"Existing Impervious Cover Area = ",{"$f":"Summary!C6","v":0.6},null,{"$f":"F20/F18","v":0.3},null,{"$f":"F20*43560","v":26136}]
[]
[null,null,null,null,"Proposed Impervious Cover Area = ",{"$f":"Summary!D6","v":1.6},null,{"$f":"F22/F18","v":0.8},null,{"$f":"F22*43560","v":69696}]
[]
[null,null,null,null,"Increase in Impervious Cover Area  = ",{"$f":"F22-F20","v":1},null,{"$f":"F24/F18","v":0.5},null,{"$f":"F24*43560","v":43560}]
[]
["Construction Cost Component (CCC)"]
[null,"Impervious Acres"]
[null,"From","To","Cost per impervious acre",null,"Impervious Acres",null,"Sub-Total Cost"]
["A1",0,1,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>1,1,$F$24)","v":1},"ac.",{"$f":"D29*F29","v":{"$error":"#REF!"}}]
["A2",1.01,2,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>C29,IF(($F$24-C30)>0,C30-C29,IF($F$24>C29,($F$24-C29),0)),0)","v":0},"ac.",{"$error":"#REF!"}]
["A3",{"$f":"C30+0.01","v":2.0099999999999998},5,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A4",5.01,10,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A5",10.01,20,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A6",20.010000000000002,50,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A7",50.01,100,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A8",100.01,">",{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>C35,IF(($F$24-1000000)>0,1000000-C35,IF($F$24>C35,($F$24-C35),0)),0)","v":0},"ac.",{"$error":"#REF!"}]
[null,null,null,"SUB TOTAL",null,{"$f":"SUM(F29:F36)","v":1},"ac.",{"$f":"SUM(H29:H36)","v":{"$error":"#REF!"}}]
[]
["Adjustment Factor (Accounts for increases in construction costs.)"]
[null,null,null,"ENR 2018",null,"ENR 2018",null,null,null,"September 18 CCI value"]
[null,null,"ENR AF = ",11170.28,"÷",11170.28,"=",{"$f":"D41/F41","v":1}]
[]
[null,null,null,null,null,"CCC Sub Total ($)","ENR AF","Adjusted CCC Total"]
[null,null,null,null,null,{"$f":"H37","v":{"$error":"#REF!"}},{"$f":"\"x \"&ROUND(D41/F41,4)&\" = \"","v":"x 1 = "},{"$f":"F44*H41","v":{"$error":"#REF!"}}]
[]
["Land Cost Component (LCC)"]
["Part A - Land Cost per Acre"]
["Type values into boxes that indicate required user input."]
[]
[null,null,null,null,"TCAD Parcel ID (10-digit) = ",null,"Value = ",{"$f":"250000*F53","v":500000},null,null,"Tax Year"]
[]
[null,null,null,"Certified Appraisal Land Valuation ($)*",null,"Certified Appraisal Land Area (Acre)",null,"Certified Appraisal Value per Acre"]
[null,null,null,{"$f":"Summary!C3*Summary!C7","v":500000},"÷",{"$f":"F18","v":2},"=",{"$f":"D53/F53","v":250000},null,null,null,null,"Area"]
[null,null,null,"User Input",null,"User Input",null,null,null,null,null,null,"SF","Acres"]
["* Certified appraisal value if available, otherwise use the current appraisal district land values.",null,null,null,null,null,null,null,null,null,null,"Floodplain/Drainage Easement Area: ",null,{"$f":"M55/43560","v":0}]
["Part B - Land Cost Area",null,null,null,null,null,null,null,null,null,null,"Water Quality Easement Area: "]
[null,null,null,null,"Limits of Construction Area (acres) = ",null,null,null,null,null,null,"Conservation Easement Area: "]
[]
[null,null,null,null,"Deductible Land Area  (acres) = ",{"$f":"M59","v":0},null,null,null,null,null,"Total Deductible Area: ",{"$f":"SUM(M55:M57)","v":0},{"$f":"SUM(N55:N57)","v":0}]
[]
[null,null,null,"Value per Acre",null,"Land Cost Area",null,"Land Cost Component (LCC)"]
[null,null,0.8,{"$f":"C62*H53","v":200000},"x 0.05 x",{"$f":"IF(F57>F18,F57,F18)-F59","v":2},"=",{"$f":"D62*0.05*F62","v":20000}]
[null,null,null,null,null,"User Input"]
[null,null,null,{"$f":"\"NOTE: Land value of 80% of appraised value per acre used for calculation.\"","v":"NOTE: Land value of 80% of appraised value per acre used for calculation."}]
[]
["Adjustment Factor for Relative Impervious Cover Percentage (accounts for lower or higher than City-wide average I.C.)"]
[]
[null,null,null,"I.C. Adjustment Factor =","(1.5425 x",{"$f":"H22","v":0.8},") + 0.1933 =",{"$f":"(1.5425*F68)+0.1933","v":1.4273}]
[]
[null,null,null,null,null,"LCC Sub Total ($)","I.C. AF","Adjusted LCC Total"]
[null,null,null,null,null,{"$f":"H62","v":20000},{"$f":"\"x \"&ROUND(H68,4)&\" = \"","v":"x 1.4273 = "},{"$f":"F71*H68","v":28546}]
[]
["Total RSMP Participation Cost"]
[null,null,null,"Adjusted CCC",null,"LCC",null,"Total "]
[null,null,null,{"$f":"H44","v":{"$error":"#REF!"}},"+",{"$f":"H71","v":28546},"=",{"$f":"D75+F75","v":{"$error":"#REF!"}}]

{"sheet":"PropCommercial (MF-MU) Combined","index":7,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":true,"merged":[[26,1,26,2]]}
[null,null,null,null,null,null,null,null,null,null,null,"Watershed: "]
[null,null,null,null,null,null,null,null,null,null,null,"Mapsco Grid #: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD PID_10: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD Area: "]
[null,null,null,null,null,null,null,null,null,null,null,"Zoning: "]
[null,null,null,null,null,null,null,null,null,null,null,"Drainage Reviewer: "]
[null,null,null,null,null,null,null,null,null,null,null,"Case Manager: "]
[]
["RSMP PARTICIPATION PAYMENT CALCULATOR (proposed)"]
[]
[null,null,"Project Name: ","Address/Case Name"]
[null,null,"Case Number: ","RSMP Number, Case Number"]
[]
["Input Site and Impervious Cover Area in Acres"]
["NOTE: The total and impervious cover areas entered must include any additional area beyond"]
["the property boundary that is within the limits of construction for the project."]
[null,null,null,null,null,"Area (acres)",null,"Impervious %",null,"Area (SF)"]
[null,null,null,null,"Total Site Area = ",{"$f":"Summary!C17","v":0.5},null,null,null,{"$f":"F18*43560","v":21780}]
[]
[null,null,null,null,"Existing Impervious Cover Area = ",{"$f":"Summary!C20","v":0.25},null,{"$f":"F20/F18","v":0.5},null,{"$f":"F20*43560","v":10890}]
[]
[null,null,null,null,"Proposed Impervious Cover Area = ",{"$f":"Summary!D20","v":0.45},null,{"$f":"F22/F18","v":0.9},null,{"$f":"F22*43560","v":19602}]
[]
[null,null,null,null,"Increase in Impervious Cover Area  = ",{"$f":"F22-F20","v":0.2},null,{"$f":"F24/F18","v":0.4},null,{"$f":"F24*43560","v":8712}]
[]
["Construction Cost Component (CCC)"]
[null,"Impervious Acres"]
[null,"From","To","Cost per impervious acre",null,"Impervious Acres",null,"Sub-Total Cost"]
["A1",0,1,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>1,1,$F$24)","v":0.2},"ac.",{"$f":"D29*F29","v":{"$error":"#REF!"}}]
["A2",1.01,2,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>C29,IF(($F$24-C30)>0,C30-C29,IF($F$24>C29,($F$24-C29),0)),0)","v":0},"ac.",{"$error":"#REF!"}]
["A3",{"$f":"C30+0.01","v":2.0099999999999998},5,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A4",5.01,10,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A5",10.01,20,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A6",20.010000000000002,50,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A7",50.01,100,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A8",100.01,">",{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>C35,IF(($F$24-1000000)>0,1000000-C35,IF($F$24>C35,($F$24-C35),0)),0)","v":0},"ac.",{"$error":"#REF!"}]
[null,null,null,"SUB TOTAL",null,{"$f":"SUM(F29:F36)","v":0.2},"ac.",{"$f":"SUM(H29:H36)","v":{"$error":"#REF!"}}]
[]
["Adjustment Factor (Accounts for increases in construction costs.)"]
[null,null,null,"ENR 2018",null,"ENR 2018",null,null,null,"September 18 CCI value"]
[null,null,"ENR AF = ",11170.28,"÷",11170.28,"=",{"$f":"D41/F41","v":1}]
[]
[null,null,null,null,null,"CCC Sub Total ($)","ENR AF","Adjusted CCC Total"]
[null,null,null,null,null,{"$f":"H37","v":{"$error":"#REF!"}},{"$f":"\"x \"&ROUND(D41/F41,4)&\" = \"","v":"x 1 = "},{"$f":"F44*H41","v":{"$error":"#REF!"}}]
[]
["Land Cost Component (LCC)"]
["Part A - Land Cost per Acre"]
["Type values into boxes that indicate required user input."]
[]
[null,null,null,null,"TCAD Parcel ID (10-digit) = ",null,"Value = ",{"$f":"250000*F53","v":125000},null,null,"Tax Year"]
[]
[null,null,null,"Certified Appraisal Land Valuation ($)*",null,"Certified Appraisal Land Area (Acre)",null,"Certified Appraisal Value per Acre"]
[null,null,null,{"$f":"Summary!C17*Summary!C21","v":1000000},"÷",{"$f":"F18","v":0.5},"=",{"$f":"D53/F53","v":2000000},null,null,null,null,"Area"]
[null,null,null,"User Input",null,"User Input",null,null,null,null,null,null,"SF","Acres"]
["* Certified appraisal value if available, otherwise use the current appraisal district land values.",null,null,null,null,null,null,null,null,null,null,"Floodplain/Drainage Easement Area: ",null,{"$f":"M55/43560","v":0}]
["Part B - Land Cost Area",null,null,null,null,null,null,null,null,null,null,"Water Quality Easement Area: "]
[null,null,null,null,"Limits of Construction Area (acres) = ",null,null,null,null,null,null,"Conservation Easement Area: "]
[]
[null,null,null,null,"Deductible Land Area  (acres) = ",{"$f":"M59","v":0},null,null,null,null,null,"Total Deductible Area: ",{"$f":"SUM(M55:M57)","v":0},{"$f":"SUM(N55:N57)","v":0}]
[]
[null,null,null,"Value per Acre",null,"Land Cost Area",null,"Land Cost Component (LCC)"]
[null,null,0.8,{"$f":"C62*H53","v":1600000},"x 0.05 x",{"$f":"IF(F57>F18,F57,F18)-F59","v":0.5},"=",{"$f":"D62*0.05*F62","v":40000}]
[null,null,null,null,null,"User Input"]
[null,null,null,{"$f":"\"NOTE: Land value of 80% of appraised value per acre used for calculation.\"","v":"NOTE: Land value of 80% of appraised value per acre used for calculation."}]
[]
["Adjustment Factor for Relative Impervious Cover Percentage (accounts for lower or higher than City-wide average I.C.)"]
[]
[null,null,null,"I.C. Adjustment Factor =","(1.5425 x",{"$f":"H22","v":0.9},") + 0.1933 =",{"$f":"(1.5425*F68)+0.1933","v":1.58155}]
[]
[null,null,null,null,null,"LCC Sub Total ($)","I.C. AF","Adjusted LCC Total"]
[null,null,null,null,null,{"$f":"H62","v":40000},{"$f":"\"x \"&ROUND(H68,4)&\" = \"","v":"x 1.5816 = "},{"$f":"F71*H68","v":63262}]
[]
["Total RSMP Participation Cost"]
[null,null,null,"Adjusted CCC",null,"LCC",null,"Total "]
[null,null,null,{"$f":"H44","v":{"$error":"#REF!"}},"+",{"$f":"H71","v":63262},"=",{"$f":"D75+F75","v":{"$error":"#REF!"}}]

{"sheet":"Proposed Lg Residential Combin","index":8,"n_rows":83,"n_cols":14,"rows_kept":83,"cut":false,"hidden":true,"merged":[[26,1,26,2]]}
[null,null,null,null,null,null,null,null,null,null,null,"Watershed: "]
[null,null,null,null,null,null,null,null,null,null,null,"Mapsco Grid #: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD PID_10: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD Area: "]
[null,null,null,null,null,null,null,null,null,null,null,"Zoning: "]
[null,null,null,null,null,null,null,null,null,null,null,"Drainage Reviewer: "]
[null,null,null,null,null,null,null,null,null,null,null,"Case Manager: "]
[]
["RSMP SINGLE FAMILY DEVELOPMENT CALCULATOR"]
[]
[null,null,"Project Name: ","Address/Case Name"]
[null,null,"Case Nmber: ","RSMP Number, Case Number"]
[]
["Input Site and Impervious Cover Area in Acres"]
["NOTE:  The proposed impervious cover entered must be the maximum allowed by zoning"]
["or watershed ordinance."]
[null,null,null,null,null,"Area (acres)",null,"Impervious %",null,"Area (SF)"]
[null,null,null,null,"Total Site Area = ",{"$f":"Summary!C31","v":60},null,null,null,{"$f":"F18*43560","v":2613600}]
[]
[null,null,null,null,"Existing Impervious Cover Area = ",{"$f":"Summary!C34","v":0},null,{"$f":"F20/F18","v":0},null,{"$f":"F20*43560","v":0}]
[]
[null,null,null,null,"Proposed Impervious Cover Area = ",{"$f":"Summary!D34","v":30},null,{"$f":"F22/F18","v":0.5},null,{"$f":"F22*43560","v":1306800}]
[]
[null,null,null,null,"Increase in Impervious Cover Area  = ",{"$f":"F22-F20","v":30},null,{"$f":"F24/F18","v":0.5},null,{"$f":"F24*43560","v":1306800}]
[]
["Construction Cost Component (CCC)"]
[null,"Impervious Acres"]
[null,"From","To","Cost per impervious acre",null,"Impervious Acres",null,"Sub-Total Cost"]
["A1",0,1,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>1,1,$F$24)","v":1},"ac.",{"$f":"D29*F29","v":{"$error":"#REF!"}}]
["A2",1.01,2,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>C29,IF(($F$24-C30)>0,C30-C29,IF($F$24>C29,($F$24-C29),0)),0)","v":1},"ac.",{"$error":"#REF!"}]
["A3",{"$f":"C30+0.01","v":2.0099999999999998},5,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,3,"ac.",{"$error":"#REF!"}]
["A4",5.01,10,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,5,"ac.",{"$error":"#REF!"}]
["A5",10.01,20,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,10,"ac.",{"$error":"#REF!"}]
["A6",20.010000000000002,50,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,10,"ac.",{"$error":"#REF!"}]
["A7",50.01,100,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A8",100.01,">",{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>C35,IF(($F$24-1000000)>0,1000000-C35,IF($F$24>C35,($F$24-C35),0)),0)","v":0},"ac.",{"$error":"#REF!"}]
[null,null,null,"SUB TOTAL",null,{"$f":"SUM(F29:F36)","v":30},"ac.",{"$f":"SUM(H29:H36)","v":{"$error":"#REF!"}}]
[]
["Adjustment Factor (Accounts for increases in construction costs.)"]
[null,null,null,"ENR 2018",null,"ENR 2018",null,null,null,"September 18 CCI value"]
[null,null,"ENR AF = ",11170.28,"÷",11170.28,"=",{"$f":"D41/F41","v":1}]
[]
[null,null,null,null,null,"CCC Sub Total ($)","ENR AF","Adjusted CCC Total"]
[null,null,null,null,null,{"$f":"H37","v":{"$error":"#REF!"}},{"$f":"\"x \"&ROUND(D41/F41,4)&\" = \"","v":"x 1 = "},{"$f":"F44*H41","v":{"$error":"#REF!"}}]
[]
["Land Cost Component (LCC)"]
["Part A - Land Cost per Acre"]
["Type values into boxes that indicate required user input."]
[]
[null,null,null,"Certified Appraisal Land Valuation ($)*",null,"Certified Appraisal Land Area (Acre)",null,"Certified Appraisal Value per Acre"]
[null,null,null,{"$f":"Summary!C35*Summary!C31","v":9000000},"÷",{"$f":"F18","v":60},"=",{"$f":"D51/F51","v":150000},null,null,"Tax Year",null,"Area"]
[null,null,null,"User Input",null,"User Input",null,null,null,null,null,null,"SF","Acres"]
["* Certified appraisal value if available, otherwise use the current appraisal district land values.",null,null,null,null,null,null,null,null,null,null,"Floodplain/Drainage Easement Area: ",null,{"$f":"M53/43560","v":0}]
["Part B - Land Cost Area",null,null,null,null,null,null,null,null,null,null,"Water Quality Easement Area: "]
[null,null,null,null,"Limits of Construction Area (acres) = ",null,null,null,null,null,null,"Conservation Easement Area: "]
[]
[null,null,null,null,"Deductible Land Area (acres) = ",{"$f":"M57","v":0},null,null,null,null,null,"Total Deductible Area: ",{"$f":"SUM(M53:M55)","v":0},{"$f":"SUM(N53:N55)","v":0}]
[]
[null,null,null,"Value per Acre",null,"Land Cost Area",null,"Land Cost Component (LCC)"]
[null,null,0.8,{"$f":"C60*H51","v":120000},"x 0.05 x",{"$f":"IF(F55>F18,F55,F18)-F57","v":60},"=",{"$f":"D60*0.05*F60","v":360000}]
[null,null,null,null,null,"User Input"]
[null,null,null,{"$f":"\"NOTE: Land value of 80% of appraised value per acre used for calculation.\"","v":"NOTE: Land value of 80% of appraised value per acre used for calculation."}]
[]
["Adjustment Factor for Relative Impervious Cover Percentage (accounts for lower or higher than City-wide average I.C.)"]
[]
[null,null,null,"I.C. Adjustment Factor =","(1.5425 x",{"$f":"H22","v":0.5},") + 0.1933 =",{"$f":"(1.5425*F66)+0.1933","v":0.96455000000000002}]
[]
[null,null,null,null,null,"LCC Sub Total ($)","I.C. AF","Adjusted LCC Total"]
[null,null,null,null,null,{"$f":"H60","v":360000},{"$f":"\"x \"&ROUND(H66,4)&\" = \"","v":"x 0.9646 = "},{"$f":"F69*H66","v":347238}]
[]
["Total RSMP Participation Cost"]
[null,null,null,"Adjusted CCC",null,"LCC",null,"Total "]
[null,null,null,{"$f":"H44","v":{"$error":"#REF!"}},"+",{"$f":"H69","v":347238},"=",{"$f":"D73+F73","v":{"$error":"#REF!"}}]
[]
["Adjustment for Large Lot Single Family Residential Developments"]
[]
[null,null,null,null,"Average Lot Size (acres) = ",3]
[]
[null,null,null,"If lots are between 2 and 5 acres and impervious"]
[null,null,null,"cover is <20%, then multiply by 50%",null,null,null,{"$f":"IF(AND(F77>1.99999,F77<5.00001),H73*0.5,\"\")","v":{"$error":"#REF!"}}]
[]
[null,null,null,"If lots are greater than 5 acres and impervious"]
[null,null,null,"cover is <20%, then multiply by 25%",null,null,null,{"$f":"IF(F77>5,H73*0.25,\"\")","v":""}]

{"sheet":"Proposed Residential","index":9,"n_rows":83,"n_cols":17,"rows_kept":83,"cut":false,"hidden":true,"merged":[[26,1,26,2],[14,0,15,7],[65,0,66,7]]}
[null,null,null,null,null,null,null,null,null,null,null,"Watershed: "]
[null,null,null,null,null,null,null,null,null,null,null,"Mapsco Grid #: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD PID_10: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD Area: "]
[null,null,null,null,null,null,null,null,null,null,null,"Zoning: ",null,null,null,"yes","payment"]
[null,null,null,null,null,null,null,null,null,null,null,"Drainage Reviewer: ",null,null,null,"no","improvements"]
[null,null,null,null,null,null,null,null,null,null,null,"Case Manager: "]
[]
["RSMP SINGLE FAMILY DEVELOPMENT CALCULATOR (proposed)"]
[]
[null,null,"Project Name: ","Address/Case Name",null,null,null,null,"Single Family Residential"]
[null,null,"Case Number: ","RSMP Number, Case Number",null,null,null,null,"Commercial/ Multi-family Residential/ Mixed-Use"]
[]
["Input Site and Impervious Cover Area in Acres"]
["NOTE:  The proposed impervious cover entered for subdivisions must be the maximum allowed by zoning or watershed ordinance."]
[]
[null,null,null,null,null,"Area (acres)",null,"Impervious %",null,"Area (SF)"]
[null,null,null,null,"Total Site Area = ",3.39,null,null,null,{"$f":"F18*43560","v":147668.4}]
[]
[null,null,null,null,"Existing Impervious Cover Area = ",0.26600000000000001,null,{"$f":"F20/F18","v":7.8466076696165191E-2},null,{"$f":"F20*43560","v":11586.960000000001}]
[]
[null,null,null,null,"Proposed Impervious Cover Area = ",{"$f":"0.45*F18","v":1.5255000000000001},null,{"$f":"F22/F18","v":0.45},null,{"$f":"F22*43560","v":66450.78}]
[]
[null,null,null,null,"Increase in Impervious Cover Area  = ",{"$f":"F22-F20","v":1.2595000000000001},null,{"$f":"F24/F18","v":0.37153392330383483},null,{"$f":"F24*43560","v":54863.82}]
[]
["Construction Cost Component (CCC)"]
[null,"Impervious Acres"]
[null,"From","To","Cost per impervious acre",null,"Impervious Acres",null,"Sub-Total Cost"]
["A1",0,1,{"$f":"'CCC Rate Compare Graphs'!S4","v":103000},null,{"$f":"IF($F$24>1,1,$F$24)","v":1},"ac.",{"$f":"D29*F29","v":103000}]
["A2",1.01,2,{"$f":"'CCC Rate Compare Graphs'!S5","v":70000},null,{"$f":"IF($F$24>C29,IF(($F$24-C30)>0,C30-C29,IF($F$24>C29,($F$24-C29),0)),0)","v":0.25950000000000006},"ac.",18165.000000000004]
["A3",{"$f":"C30+0.01","v":2.0099999999999998},5,{"$f":"'CCC Rate Compare Graphs'!S6","v":44000},null,0,"ac.",0]
["A4",5.01,10,{"$f":"'CCC Rate Compare Graphs'!S7","v":29000},null,0,"ac.",0]
["A5",10.01,20,{"$f":"'CCC Rate Compare Graphs'!S8","v":20000},null,0,"ac.",0]
["A6",20.010000000000002,50,{"$f":"'CCC Rate Compare Graphs'!S9","v":12000},null,0,"ac.",0]
["A7",50.01,100,{"$f":"'CCC Rate Compare Graphs'!S10","v":8000},null,0,"ac.",0]
["A8",100.01,">",{"$f":"'CCC Rate Compare Graphs'!S11","v":4000},null,{"$f":"IF($F$24>C35,IF(($F$24-1000000)>0,1000000-C35,IF($F$24>C35,($F$24-C35),0)),0)","v":0},"ac.",0]
[null,null,null,"SUB TOTAL",null,{"$f":"SUM(F29:F36)","v":1.2595000000000001},"ac.",{"$f":"SUM(H29:H36)","v":121165}]
[]
["Adjustment Factor (accounts for changes in construction costs)"]
[null,null,null,"ENR 2019",null,"ENR 2018",null,null,null,"September 18 CCI value"]
[null,null,"ENR AF = ",11326.1,"÷",11170.28,"=",{"$f":"D41/F41","v":1.0139495160371987}]
[]
[null,null,null,null,null,"CCC Sub Total ($)","ENR AF","Adjusted CCC Total"]
[null,null,null,null,null,{"$f":"H37","v":121165},{"$f":"\"x \"&ROUND(D41/F41,4)&\" = \"","v":"x 1.0139 = "},{"$f":"F44*H41","v":122855.19311064719}]
[]
["Land Cost Component (LCC)"]
["Part A - Land Cost per Acre"]
["Type values into boxes that indicate required user input."]
[]
[null,null,null,null,"TCAD Parcel ID (10-digit) = ",null,"Value = ",2500000,null,null,"Tax Year"]
[]
[null,null,null,"Certified Appraisal Land Valuation ($)*",null,"Certified Appraisal Land Area (Acre)",null,"Certified Appraisal Value per Acre"]
[null,null,null,{"$f":"H50","v":2500000},"÷",{"$f":"F18","v":3.39},"=",{"$f":"D53/F53","v":737463.12684365781},null,null,null,null,"Area"]
[null,null,null,"User Input",null,"User Input",null,null,null,null,null,null,"SF","Acres"]
["* Certified appraisal value if available, otherwise use the current appraisal district land values.",null,null,null,null,null,null,null,null,null,null,"Floodplain/Drainage Easement Area: ",null,{"$f":"M55/43560","v":0}]
["Part B - Land Cost Area",null,null,null,null,null,null,null,null,null,null,"Water Quality Easement Area: "]
[null,null,null,null,"Limits of Construction Area (acres) = ",null,null,null,null,null,null,"Conservation Easement Area: "]
[]
[null,null,null,null,"Deductible Land Area (acres) = ",{"$f":"M59","v":0},null,null,null,null,null,"Total Deductible Area: ",{"$f":"SUM(M55:M57)","v":0},{"$f":"SUM(N55:N57)","v":0}]
[]
[null,null,null,"Value per Acre",null,"Land Cost Area",null,"Land Cost Component (LCC)"]
[null,null,0.8,{"$f":"C62*H53","v":589970.50147492625},"x 0.05 x",{"$f":"IF(F57>F18,F57,F18)-F59","v":3.39},"=",{"$f":"D62*0.05*F62","v":100000.00000000001}]
[null,null,null,null,null,"User Input"]
[null,null,null,{"$f":"\"NOTE: Land value of 80% of appraised value per acre used for calculation.\"","v":"NOTE: Land value of 80% of appraised value per acre used for calculation."}]
[]
["Adjustment Factor for Relative Impervious Cover Percentage (accounts for lower or higher than City-wide average I.C.)"]
[]
[null,null,null,"I.C. Adjustment Factor =","(1.5425 x",{"$f":"H22","v":0.45},") + 0.1933 =",{"$f":"IF(((1.5425*F68)+0.1933)<1,(1.5425*F68)+0.1933,1)","v":0.88742500000000002}]
[]
[null,null,null,null,null,"LCC Sub Total ($)","I.C. AF","Adjusted LCC Total"]
[null,null,null,null,null,{"$f":"H62","v":100000.00000000001},{"$f":"\"x \"&ROUND(H68,4)&\" = \"","v":"x 0.8874 = "},{"$f":"F71*H68","v":88742.500000000015}]
[]
["Total RSMP Participation Cost"]
[null,null,null,"Adjusted CCC",null,"LCC",null,"Total "]
[null,null,null,{"$f":"H44","v":122855.19311064719},"+",{"$f":"H71","v":88742.500000000015},"=",{"$f":"D75+F75","v":211597.6931106472}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(D80>D81,D81*F18,H75)","v":211597.6931106472}]
[null,null,null,null,null,null,null,null,{"$f":"D83","v":"USE CALCULATED RATE"}]
[null,null,null,"Check for extreme $/acre RSMP cost and use cap as necessary"]
[null,null,null,{"$f":"(D75+F75)/F18","v":62418.19855771304},"per acre"]
[null,null,null,440000,"per acre"]
[]
[null,null,null,{"$f":"IF(D80>D81,\"USE CAPPED RATE\", \"USE CALCULATED RATE\")","v":"USE CALCULATED RATE"}]

{"sheet":"Proposed Sm Residential Combin","index":10,"n_rows":83,"n_cols":14,"rows_kept":83,"cut":false,"hidden":true,"merged":[[26,1,26,2]]}
[null,null,null,null,null,null,null,null,null,null,null,"Watershed: "]
[null,null,null,null,null,null,null,null,null,null,null,"Mapsco Grid #: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD PID_10: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD Area: "]
[null,null,null,null,null,null,null,null,null,null,null,"Zoning: "]
[null,null,null,null,null,null,null,null,null,null,null,"Drainage Reviewer: "]
[null,null,null,null,null,null,null,null,null,null,null,"Case Manager: "]
[]
["RSMP SINGLE FAMILY DEVELOPMENT CALCULATOR"]
[]
[null,null,"Project Name: ","Address/Case Name"]
[null,null,"Case Nmber: ","RSMP Number, Case Number"]
[]
["Input Site and Impervious Cover Area in Acres"]
["NOTE:  The proposed impervious cover entered must be the maximum allowed by zoning"]
["or watershed ordinance."]
[null,null,null,null,null,"Area (acres)",null,"Impervious %",null,"Area (SF)"]
[null,null,null,null,"Total Site Area = ",{"$f":"Summary!C45","v":0.5},null,null,null,{"$f":"F18*43560","v":21780}]
[]
[null,null,null,null,"Existing Impervious Cover Area = ",{"$f":"Summary!C48","v":0},null,{"$f":"F20/F18","v":0},null,{"$f":"F20*43560","v":0}]
[]
[null,null,null,null,"Proposed Impervious Cover Area = ",{"$f":"Summary!D48","v":0.22500000000000001},null,{"$f":"F22/F18","v":0.45},null,{"$f":"F22*43560","v":9801}]
[]
[null,null,null,null,"Increase in Impervious Cover Area  = ",{"$f":"F22-F20","v":0.22500000000000001},null,{"$f":"F24/F18","v":0.45},null,{"$f":"F24*43560","v":9801}]
[]
["Construction Cost Component (CCC)"]
[null,"Impervious Acres"]
[null,"From","To","Cost per impervious acre",null,"Impervious Acres",null,"Sub-Total Cost"]
["A1",0,1,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>1,1,$F$24)","v":0.22500000000000001},"ac.",{"$f":"D29*F29","v":{"$error":"#REF!"}},null,null,null,95000]
["A2",1.01,2,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>C29,IF(($F$24-C30)>0,C30-C29,IF($F$24>C29,($F$24-C29),0)),0)","v":0},"ac.",{"$error":"#REF!"},null,null,null,40000]
["A3",{"$f":"C30+0.01","v":2.0099999999999998},5,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"},null,null,null,18000]
["A4",5.01,10,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"},null,null,null,8000]
["A5",10.01,20,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A6",20.010000000000002,50,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A7",50.01,100,{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,0,"ac.",{"$error":"#REF!"}]
["A8",100.01,">",{"$f":"'CCC Rate Compare Graphs'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($F$24>C35,IF(($F$24-1000000)>0,1000000-C35,IF($F$24>C35,($F$24-C35),0)),0)","v":0},"ac.",{"$error":"#REF!"}]
[null,null,null,"SUB TOTAL",null,{"$f":"SUM(F29:F36)","v":0.22500000000000001},"ac.",{"$f":"SUM(H29:H36)","v":{"$error":"#REF!"}}]
[]
["Adjustment Factor (Accounts for increases in construction costs.)"]
[null,null,null,"ENR 2018",null,"ENR 2018",null,null,null,"September 18 CCI value"]
[null,null,"ENR AF = ",11170.28,"÷",11170.28,"=",{"$f":"D41/F41","v":1}]
[]
[null,null,null,null,null,"CCC Sub Total ($)","ENR AF","Adjusted CCC Total"]
[null,null,null,null,null,{"$f":"H37","v":{"$error":"#REF!"}},{"$f":"\"x \"&ROUND(D41/F41,4)&\" = \"","v":"x 1 = "},{"$f":"F44*H41","v":{"$error":"#REF!"}}]
[]
["Land Cost Component (LCC)"]
["Part A - Land Cost per Acre"]
["Type values into boxes that indicate required user input."]
[]
[null,null,null,"Certified Appraisal Land Valuation ($)*",null,"Certified Appraisal Land Area (Acre)",null,"Certified Appraisal Value per Acre"]
[null,null,null,{"$f":"Summary!C45*Summary!C49","v":250000},"÷",{"$f":"F18","v":0.5},"=",{"$f":"D51/F51","v":500000},null,null,"Tax Year",null,"Area"]
[null,null,null,"User Input",null,"User Input",null,null,null,null,null,null,"SF","Acres"]
["* Certified appraisal value if available, otherwise use the current appraisal district land values.",null,null,null,null,null,null,null,null,null,null,"Floodplain/Drainage Easement Area: ",null,{"$f":"M53/43560","v":0}]
["Part B - Land Cost Area",null,null,null,null,null,null,null,null,null,null,"Water Quality Easement Area: "]
[null,null,null,null,"Limits of Construction Area (acres) = ",null,null,null,null,null,null,"Conservation Easement Area: "]
[]
[null,null,null,null,"Deductible Land Area (acres) = ",{"$f":"M57","v":0},null,null,null,null,null,"Total Deductible Area: ",{"$f":"SUM(M53:M55)","v":0},{"$f":"SUM(N53:N55)","v":0}]
[]
[null,null,null,"Value per Acre",null,"Land Cost Area",null,"Land Cost Component (LCC)"]
[null,null,0.8,{"$f":"C60*H51","v":400000},"x 0.05 x",{"$f":"IF(F55>F18,F55,F18)-F57","v":0.5},"=",{"$f":"D60*0.05*F60","v":10000}]
[null,null,null,null,null,"User Input"]
[null,null,null,{"$f":"\"NOTE: Land value of 80% of appraised value per acre used for calculation.\"","v":"NOTE: Land value of 80% of appraised value per acre used for calculation."}]
[]
["Adjustment Factor for Relative Impervious Cover Percentage (accounts for lower or higher than City-wide average I.C.)"]
[]
[null,null,null,"I.C. Adjustment Factor =","(1.5425 x",{"$f":"H22","v":0.45},") + 0.1933 =",{"$f":"(1.5425*F66)+0.1933","v":0.88742500000000002}]
[]
[null,null,null,null,null,"LCC Sub Total ($)","I.C. AF","Adjusted LCC Total"]
[null,null,null,null,null,{"$f":"H60","v":10000},{"$f":"\"x \"&ROUND(H66,4)&\" = \"","v":"x 0.8874 = "},{"$f":"F69*H66","v":8874.25}]
[]
["Total RSMP Participation Cost"]
[null,null,null,"Adjusted CCC",null,"LCC",null,"Total "]
[null,null,null,{"$f":"H44","v":{"$error":"#REF!"}},"+",{"$f":"H69","v":8874.25},"=",{"$f":"D73+F73","v":{"$error":"#REF!"}}]
[]
["Adjustment for Large Lot Single Family Residential Developments"]
[]
[null,null,null,null,"Average Lot Size (acres) = "]
[]
[null,null,null,"If lots are between 2 and 5 acres and impervious"]
[null,null,null,"cover is <20%, then multiply by 50%",null,null,null,{"$f":"IF(AND(F77>1.99999,F77<5.00001),H73*0.5,\"\")","v":""}]
[]
[null,null,null,"If lots are greater than 5 acres and impervious"]
[null,null,null,"cover is <20%, then multiply by 25%",null,null,null,{"$f":"IF(F77>5,H73*0.25,\"\")","v":""}]

{"sheet":"Proposed Sm Residential Com (2)","index":11,"n_rows":83,"n_cols":14,"rows_kept":83,"cut":false,"hidden":true,"merged":[[26,1,26,2]]}
[null,null,null,null,null,null,null,null,null,null,null,"Watershed: "]
[null,null,null,null,null,null,null,null,null,null,null,"Mapsco Grid #: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD PID_10: "]
[null,null,null,null,null,null,null,null,null,null,null,"TCAD Area: "]
[null,null,null,null,null,null,null,null,null,null,null,"Zoning: "]
[null,null,null,null,null,null,null,null,null,null,null,"Drainage Reviewer: "]
[null,null,null,null,null,null,null,null,null,null,null,"Case Manager: "]
[]
["RSMP SINGLE FAMILY DEVELOPMENT CALCULATOR"]
[]
[null,null,"Project Name: ","Address/Case Name"]
[null,null,"Case Nmber: ","RSMP Number, Case Number"]
[]
["Input Site and Impervious Cover Area in Acres"]
["NOTE:  The proposed impervious cover entered must be the maximum allowed by zoning"]
["or watershed ordinance."]
[null,null,null,null,null,"Area (acres)",null,"Impervious %",null,"Area (SF)"]
[null,null,null,null,"Total Site Area = ",{"$f":"Summary!C45","v":0.5},null,null,null,{"$f":"F18*43560","v":21780}]
[]
[null,null,null,null,"Existing Impervious Cover Area = ",{"$f":"Summary!C48","v":0},null,{"$f":"F20/F18","v":0},null,{"$f":"F20*43560","v":0}]
[]
[null,null,null,null,"Proposed Impervious Cover Area = ",{"$f":"Summary!D48","v":0.22500000000000001},null,{"$f":"F22/F18","v":0.45},null,{"$f":"F22*43560","v":9801}]
[]
[null,null,null,null,"Increase in Impervious Cover Area  = ",{"$f":"F22-F20","v":0.22500000000000001},null,{"$f":"F24/F18","v":0.45},null,{"$f":"F24*43560","v":9801}]
[]
["Construction Cost Component (CCC)"]
[null,"Impervious Acres"]
[null,"From","To","Cost per impervious acre",null,"Impervious Acres",null,"Sub-Total Cost"]
["A1",0,1,{"$f":"'CCC Rate Compare Graphs'!P4","v":95000},null,{"$f":"IF($F$24>1,1,$F$24)","v":0.22500000000000001},"ac.",{"$f":"D29*F29","v":21375},null,null,null,95000]
["A2",1.01,2,{"$f":"'CCC Rate Compare Graphs'!P5","v":64000},null,{"$f":"IF($F$24>C29,IF(($F$24-C30)>0,C30-C29,IF($F$24>C29,($F$24-C29),0)),0)","v":0},"ac.",0,null,null,null,40000]
["A3",{"$f":"C30+0.01","v":2.0099999999999998},5,{"$f":"'CCC Rate Compare Graphs'!P6","v":40000},null,0,"ac.",0,null,null,null,18000]
["A4",5.01,10,{"$f":"'CCC Rate Compare Graphs'!P7","v":26000},null,0,"ac.",0,null,null,null,8000]
["A5",10.01,20,{"$f":"'CCC Rate Compare Graphs'!P8","v":18000},null,0,"ac.",0]
["A6",20.010000000000002,50,{"$f":"'CCC Rate Compare Graphs'!P9","v":11000},null,0,"ac.",0]
["A7",50.01,100,{"$f":"'CCC Rate Compare Graphs'!P10","v":8000},null,0,"ac.",0]
["A8",100.01,">",{"$f":"'CCC Rate Compare Graphs'!P11","v":4000},null,{"$f":"IF($F$24>C35,IF(($F$24-1000000)>0,1000000-C35,IF($F$24>C35,($F$24-C35),0)),0)","v":0},"ac.",0]
[null,null,null,"SUB TOTAL",null,{"$f":"SUM(F29:F36)","v":0.22500000000000001},"ac.",{"$f":"SUM(H29:H36)","v":21375}]
[]
["Adjustment Factor (Accounts for increases in construction costs.)"]
[null,null,null,"ENR 2018",null,"ENR 2018",null,null,null,"September 18 CCI value"]
[null,null,"ENR AF = ",11170.28,"÷",11170.28,"=",{"$f":"D41/F41","v":1}]
[]
[null,null,null,null,null,"CCC Sub Total ($)","ENR AF","Adjusted CCC Total"]
[null,null,null,null,null,{"$f":"H37","v":21375},{"$f":"\"x \"&ROUND(D41/F41,4)&\" = \"","v":"x 1 = "},{"$f":"F44*H41","v":21375}]
[]
["Land Cost Component (LCC)"]
["Part A - Land Cost per Acre"]
["Type values into boxes that indicate required user input."]
[]
[null,null,null,"Certified Appraisal Land Valuation ($)*",null,"Certified Appraisal Land Area (Acre)",null,"Certified Appraisal Value per Acre"]
[null,null,null,{"$f":"Summary!C45*Summary!C49","v":250000},"÷",{"$f":"F18","v":0.5},"=",{"$f":"D51/F51","v":500000},null,null,"Tax Year",null,"Area"]
[null,null,null,"User Input",null,"User Input",null,null,null,null,null,null,"SF","Acres"]
["* Certified appraisal value if available, otherwise use the current appraisal district land values.",null,null,null,null,null,null,null,null,null,null,"Floodplain/Drainage Easement Area: ",null,{"$f":"M53/43560","v":0}]
["Part B - Land Cost Area",null,null,null,null,null,null,null,null,null,null,"Water Quality Easement Area: "]
[null,null,null,null,"Limits of Construction Area (acres) = ",null,null,null,null,null,null,"Conservation Easement Area: "]
[]
[null,null,null,null,"Deductible Land Area (acres) = ",{"$f":"M57","v":0},null,null,null,null,null,"Total Deductible Area: ",{"$f":"SUM(M53:M55)","v":0},{"$f":"SUM(N53:N55)","v":0}]
[]
[null,null,null,"Value per Acre",null,"Land Cost Area",null,"Land Cost Component (LCC)"]
[null,null,0.8,{"$f":"C60*H51","v":400000},"x 0.05 x",{"$f":"IF(F55>F18,F55,F18)-F57","v":0.5},"=",{"$f":"D60*0.05*F60","v":10000}]
[null,null,null,null,null,"User Input"]
[null,null,null,{"$f":"\"NOTE: Land value of 80% of appraised value per acre used for calculation.\"","v":"NOTE: Land value of 80% of appraised value per acre used for calculation."}]
[]
["Adjustment Factor for Relative Impervious Cover Percentage (accounts for lower or higher than City-wide average I.C.)"]
[]
[null,null,null,"I.C. Adjustment Factor =","(1.5425 x",{"$f":"H22","v":0.45},") + 0.1933 =",{"$f":"(1.5425*F66)+0.1933","v":0.88742500000000002}]
[]
[null,null,null,null,null,"LCC Sub Total ($)","I.C. AF","Adjusted LCC Total"]
[null,null,null,null,null,{"$f":"H60","v":10000},{"$f":"\"x \"&ROUND(H66,4)&\" = \"","v":"x 0.8874 = "},{"$f":"F69*H66","v":8874.25}]
[]
["Total RSMP Participation Cost"]
[null,null,null,"Adjusted CCC",null,"LCC",null,"Total "]
[null,null,null,{"$f":"H44","v":21375},"+",{"$f":"H69","v":8874.25},"=",{"$f":"D73+F73","v":30249.25}]
[]
["Adjustment for Large Lot Single Family Residential Developments"]
[]
[null,null,null,null,"Average Lot Size (acres) = "]
[]
[null,null,null,"If lots are between 2 and 5 acres and impervious"]
[null,null,null,"cover is <20%, then multiply by 50%",null,null,null,{"$f":"IF(AND(F77>1.99999,F77<5.00001),H73*0.5,\"\")","v":""}]
[]
[null,null,null,"If lots are greater than 5 acres and impervious"]
[null,null,null,"cover is <20%, then multiply by 25%",null,null,null,{"$f":"IF(F77>5,H73*0.25,\"\")","v":""}]