{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["RSMP Payment Calculator","Lists","CCC Rate Compare Graphs","Automation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"RSMP Payment Calculator","index":0,"n_rows":45,"n_cols":21,"rows_kept":45,"cut":false,"hidden":false,"merged":[[7,2,7,4],[13,2,13,4],[14,2,14,4],[3,7,6,9],[27,12,32,20],[24,7,26,9],[22,4,24,4],[23,7,23,9],[17,2,17,4],[18,2,18,4],[11,2,11,4],[7,7,12,9],[14,17,14,18],[15,17,15,18],[16,17,16,18],[6,13,6,14],[23,1,23,2],[24,1,24,2],[25,1,25,2],[40,12,40,20],[36,12,36,13],[36,14,36,16],[34,15,34,16],[34,12,34,13],[35,12,35,13],[35,15,35,16],[34,18,37,19],[34,20,37,20],[39,12,39,20],[37,12,37,13],[37,14,37,16],[43,19,44,20],[42,19,42,20],[33,1,33,2],[26,1,26,2],[27,1,27,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[37,1,37,2],[42,18,44,18],[43,12,43,14],[44,12,44,14],[26,12,26,20],[18,12,20,20],[6,20,7,20],[6,15,7,15],[6,12,7,12],[22,12,23,12],[22,14,23,14],[22,16,23,16],[22,20,24,20],[22,18,24,19],[4,12,4,20],[6,16,7,16],[6,19,7,19],[16,14,16,15],[6,17,7,18],[8,17,8,18],[9,17,9,18],[10,17,10,18],[11,17,11,18],[12,17,12,18],[13,17,13,18],[3,1,4,1],[3,2,4,2],[39,7,44,9],[40,1,42,1],[40,2,42,4],[43,2,44,4],[35,7,37,9],[36,1,36,2],[43,1,44,1],[27,7,28,9],[35,1,35,4],[30,7,33,9],[19,7,21,9],[14,7,17,9],[36,3,36,4],[37,3,37,4]]}
[null,"RSMP PAYMENT CALCULATOR",null,null,null,null,null,"RSMP PAYMENT CALCULATOR",null,null,null,null,"RSMP PAYMENT CALCULATOR"]
[null,"VALID THROUGH SEPTEMBER 2026",null,"Construction Cost Component:",{"$f":"U23","v":{"$error":"#VALUE!"}},null,null,"VALID THROUGH SEPTEMBER 2026",null,null,null,null,"VALID THROUGH SEPTEMBER 2026"]
[null,null,null,"Land Cost Component:",{"$f":"U35","v":{"$error":"#DIV/0!"}}]
[null,"RSMP Payment Total:",{"$f":"IF(E4>=10%, (T44*(1-E4)-E5), (T44-E5))","v":{"$error":"#VALUE!"}},"Smart Housing Discount:",{"$f":"IF(AND(D37>=40, AND(D38>=10%, D38<50%)), D38, IF(AND(D37>=40, D38>=50%), \"50%\", \"0%\"))","v":"0%"},null,null,"INSTRUCTIONS: Provide information in the boxes underlined with dashes. The RSMP Payment Calculator will estimate the RSMP Payment amount. Use the Property Profile and Appraisal District Property Search tools to find any missing details. ",null,null,null,null,"CONSTRUCTION COST COMPONENT (CCC) CALCULATOR"]
[null,null,null,"Improvements Total:",{"$f":"C44","v":0},null,null,null,null,null,null,null,"Based on Site Area (or LOC), Existing IC, Proposed IC, and Land Use inputs."]
[]
[null,"PROJECT INFORMATION",null,null,null,null,null,null,null,null,null,null,"Segment","IC (acres)",null,"Cost per IC Acre","X","IC (acres)",null,"=","Subtotal Cost"]
[null,"Project Name / Address:",null,null,null,null,null,"NOTE: The RSMP Payment Calculator is for RSMP Payment estimation. The RSMP Team calculates the RSMP Payment amount during the development application review process. RSMP Payment Calculations are valid through September 30, 2024. The RSMP Team updates the RSMP Payment Calculator and outstanding RSMP Payment invoices on October 1 with the new September Engineering News-Record Construction Cost Index (ENR CCI). The RSMP website (https://www.austintexas.gov/RSMP) has more information.",null,null,null,null,null,"From","To"]
[null,"RSMP Number:",null,"Case Number:",null,null,null,null,null,null,null,null,"A1",0,1,{"$f":"IF($C$14=Lists!$C$4, 'CCC Rate Compare Graphs'!R4, IF($C$14=Lists!$C$3, 'CCC Rate Compare Graphs'!S4, \"Input Error\"))","v":"Input Error"}," ",{"$f":"IF(D28>1, 1, D28)","v":0},null," ",{"$f":"P9*R9","v":{"$error":"#VALUE!"}}]
[null,"RSMP Reviewer:",null,"Case Manager: ",null,null,null,null,null,null,null,null,"A2",1.01,2,{"$f":"IF($C$14=Lists!$C$4, 'CCC Rate Compare Graphs'!R5, IF($C$14=Lists!$C$3, 'CCC Rate Compare Graphs'!S5, \"Input Error\"))","v":"Input Error"}," ",{"$f":"IF($D$28>O9, IF(($D$28-O10)>0, O10-O9, IF($D$28>O9, ($D$28-O9), 0)), 0)","v":0},null," ",{"$error":"#VALUE!"}]
[null,"Drainage / WQ Reviewer:",null,"SP / C8 Planner:",null,null,null,null,null,null,null,null,"A3",2.0099999999999998,5,{"$f":"IF($C$14=Lists!$C$4, 'CCC Rate Compare Graphs'!R6, IF($C$14=Lists!$C$3, 'CCC Rate Compare Graphs'!S6, \"Input Error\"))","v":"Input Error"}," ",0,null," ",{"$error":"#VALUE!"}]
[null,"Watershed: ","CLICK TO SELECT ONE",null,null,null,null,null,null,null,null,null,"A4",5.01,10,{"$f":"IF($C$14=Lists!$C$4, 'CCC Rate Compare Graphs'!R7, IF($C$14=Lists!$C$3, 'CCC Rate Compare Graphs'!S7, \"Input Error\"))","v":"Input Error"}," ",0,null," ",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"A5",10.01,20,{"$f":"IF($C$14=Lists!$C$4, 'CCC Rate Compare Graphs'!R8, IF($C$14=Lists!$C$3, 'CCC Rate Compare Graphs'!S8, \"Input Error\"))","v":"Input Error"}," ",0,null," ",{"$error":"#VALUE!"}]
[null,"Land Use: ","CLICK TO SELECT ONE",null,null,null,null,null,null,null,null,null,"A6",20.010000000000002,50,{"$f":"IF($C$14=Lists!$C$4, 'CCC Rate Compare Graphs'!R9, IF($C$14=Lists!$C$3, 'CCC Rate Compare Graphs'!S9, \"Input Error\"))","v":"Input Error"}," ",0,null," ",{"$error":"#VALUE!"}]
[null,"RSMP Participation Type: ","CLICK TO SELECT ONE",null,null,null,null,"Land Use is either Single-Family Residential or Multi-Family Residential / Mixed-Use / Commerical based on the site's zoning designation. If a development is not Single-Family Residential, choose Multi-Family Residential / Mixed-Use / Commerical (the latter includes ROW, industrial, and religious land uses). Select an option to populate the RSMP Payment Calculator.",null,null,null,null,"A7",50.01,100,{"$f":"IF($C$14=Lists!$C$4, 'CCC Rate Compare Graphs'!R10, IF($C$14=Lists!$C$3, 'CCC Rate Compare Graphs'!S10, \"Input Error\"))","v":"Input Error"}," ",0,null," ",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"A8",100.01,">",{"$f":"IF($C$14=Lists!$C$4, 'CCC Rate Compare Graphs'!R11, IF($C$14=Lists!$C$3, 'CCC Rate Compare Graphs'!S11, \"Input Error\"))","v":"Input Error"}," ",{"$f":"IF($D$28>O15, IF(($D$28-1000000)>0, 1000000-O15, IF($D$28>O15, ($D$28-O15), 0)), 0)","v":0},null," ",{"$error":"#VALUE!"}]
[null,"APPRAISAL INFORMATION",null,null,null,null,null,null,null,null,null,null," "," ","CCC Subtotal",null,"=",{"$f":"SUM(S9:S16)","v":0},null," ",{"$f":"SUM(U9:U16)","v":{"$error":"#VALUE!"}}]
[null,"Zoning:"]
[null,"TCAD ID (10-Digit):",null,null,null,null,null,null,null,null,null,null,"The CCC is multiplied by an adjustment factor (AF) that is updated annually in October to reflect changes in construction costs using the Engineering News-Record Construction Cost Index."]
[null,"TCAD Area (acres): ",null,"Land Appraisal Value ($): ",null,null,null,"APPRAISAL INFORMATION comes from the Travis Central Appraisal District (TCAD, traviscad.org), Bastrop CAD, Blanco CAD, Caldwell CAD, Hays CAD, Williamson CAD, or a certified private appraiser."]
[null,"Appraisal District:","CLICK TO SELECT ONE","Appraisal Tax Year: ","CLICK TO SELECT ONE"]
[]
[null,"SITE AREA / LOC & IMPERVIOUS COVER",null,"Acres","Impervious Cover %",null,null,null,null,null,null,null,"ENR AF",null,"ENR CCI 2025",null,"ENR CCI 2018",null,"Adjusted CCC Total",null,{"$f":"U17*M25","v":{"$error":"#VALUE!"}}]
[null,"Site Area:",null,null,null,null,null,"Site Area for new development is the gross site area. "]
[null,"Limits of Construction (LOC):",null,null,null,null,null,"Limits of Construction (LOC) applies for redevelopment. The RSMP Payment Calculator will use the LOC if it's greater than the Site Area.",null,null,null,null,{"$f":"O25/Q25","v":1.2468577331991677},"=",13927.75,"÷",11170.28]
[null,"Existing Impervious Cover: ",null,null,{"$f":"D26/$D$24","v":{"$error":"#DIV/0!"}}]
[null,"Proposed Impervious Cover:",null,null,{"$f":"D27/$D$24","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"LAND COST COMPONENT (LCC) CALCULATOR"]
[null,"Change in Impervious Cover: ",null,{"$f":"D27-D26","v":0},{"$f":"D28/$D$24","v":{"$error":"#DIV/0!"}},null,null,"Impervious Cover (IC) for site plans should be the actual proposed IC. For single-family residential subdivisions, use the maximum allowable IC based on zoning and watershed requirements (usually 45%).",null,null,null,null,"Based on the site's Appraisal Value. This approach replaces the previous static, capped cost-per-acre values for different land use types. The LCC is multiplied by the Relative IC AF that accounts for a site's relative IC compared to the weighted IC average in the City of Austin. This is the same adjustment used for the Watershed Protection Department Drainage Utility Charge."]
[]
[null,"DEDUCTIBLE AREAS",null,"Acres","Site Area %"]
[null,"Floodplain / Drainage Easement Area:",null,null,{"$f":"D31/$D$24","v":{"$error":"#DIV/0!"}},null,null,"DEDUCTIBLE AREAS include qualifying Floodplain, Drainage, Water Quality, and Conservation Easements and other undevelopable areas as defined by City of Austin ordinances. Provide documentation during formal review that shows easement dedication or other supporting documentation of the undevelopable area."]
[null,"Water Quality Easement Area:",null,null,{"$f":"D32/$D$24","v":{"$error":"#DIV/0!"}}]
[null,"Conservation Easement Area:",null,null,{"$error":"#DIV/0!"}]
[null,"Total Deductible Land Area:",null,{"$f":"SUM(D31:D33)","v":0},{"$f":"SUM(E31:E33)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Land Value",null,"Land Area","Appraised Value per Acre",null,null,"Adjusted LCC Total",null,{"$f":"M38*O38","v":{"$error":"#DIV/0!"}}]
[null,"SMART HOUSING DISCOUNT",null,null,null,null,null,"SMART HOUSING DISCOUNT applies to Smart Housing Certified developments that meet additional requirements as adopted in the FY22 Budget. The minimum term of affordability is 40 years for a minimum percentage of 10% of units. The maximum discount is 50%.",null,null,null,null,{"$f":"E20","v":0},null,{"$f":"IF(D25>D24,(D25-D34),(D24-D34))","v":0},{"$f":"M36/O36","v":{"$error":"#DIV/0!"}}]
[null,"Affordability Term (years, 40+):",null,null,null,null,null,null,null,null,null,null,"Relative IC AF",null,"Land Cost Component (LCC) Subtotal"]
[null,"Affordable Units (%, 10%+): ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(((1.5425*E27)+0.1933)<1, (1.5425*E27)+0.1933, 1)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D25>D24,(0.8*(E20/D24)*0.05*(D25-D34)),(0.8*(E20/D24)*0.05*(D24-D34)))","v":{"$error":"#DIV/0!"}}]
[]
[null,"IMPROVEMENTS",null,null,null,null,null,"IMPROVEMENTS apply to developments participating in RSMP by constructing approved offsite drainage infrastructure improvements. Provide a brief Description and Construction Cost Estimate (CCE) for the improvements. The RSMP Team credits this amount toward the RSMP Payment amount. If the CCE is less than the RSMP Payment amount, the RSMP Team will generate an RSMP Payment invoice for the difference. If the CCE exceeds the RSMP Payment amount, there will be no additional payment required.",null,null,null,null,"CHECK & CAP FOR EXTREME COST"]
[null,"Description:",null,null,null,null,null,null,null,null,null,null,"Prevents a site's excessively high appraisal values from skewing the calculated RSMP Payment."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount","Cost / Acre",null,"Result",{"$f":"IF(Q44>Q45, \"Use Capped Rate\", \"Use Calculated Rate\")","v":{"$error":"#VALUE!"}}]
[null,"Construction Cost Estimate:",null,null,null,null,null,null,null,null,null,null,"Calculated RSMP Payment",null,null,{"$f":"U23+U35","v":{"$error":"#VALUE!"}},{"$f":"P44/$D$24","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(T43=\"Use Calculated Rate\", P44, P45)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Capped RSMP Payment",null,null,{"$f":"Q45*D24","v":0},{"$f":"440000*M25","v":548617.40260763385}]

{"sheet":"Lists","index":1,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
["LISTS",null,"Land Use","Participation Type","Appraisal District","Watershed","Drainage Reviewer","Case Manager","Appraisal Tax Year"]
[null,null,"CLICK TO SELECT ONE","CLICK TO SELECT ONE","CLICK TO SELECT ONE","CLICK TO SELECT ONE",null,null,"CLICK TO SELECT ONE"]
[null,null,"Single-Family Residential","RSMP Payment","TCAD","Barton Creek",null,null,2023]
[null,null,"Commercial / Mixed-Use / Multi-Family Residential","RSMP Drainage Infrastructure Improvements","Bastrop CAD","Bear Creek",null,null,2024]
[null,null,null,null,"Blanco CAD","Bear Creek West",null,null,2025]
[null,null,null,null,"Caldwell CAD","Bee Creek"]
[null,null,null,null,"Hays CAD","Big Sandy Creek"]
[null,null,null,null,"Williamson CAD","Blunn Creek"]
[null,null,null,null,"Certified Private Appraiser","Boggy Creek"]
[null,null,null,null,null,"Buck Hollow"]
[null,null,null,null,null,"Bull Creek"]
[null,null,null,null,null,"Bullick Hollow"]
[null,null,null,null,null,"Buttercup Creek"]
[null,null,null,null,null,"Buttermilk Branch"]
[null,null,null,null,null,"Carson Creek"]
[null,null,null,null,null,"Chalk Knob Hollow"]
[null,null,null,null,null,"Cherry Creek Branch"]
[null,null,null,null,null,"Coldwater Creek"]
[null,null,null,null,null,"Collier Hollow"]
[null,null,null,null,null,"Colorado River"]
[null,null,null,null,null,"Commons Ford Creek"]
[null,null,null,null,null,"Connors Creek"]
[null,null,null,null,null,"Cottonmouth Creek"]
[null,null,null,null,null,"Country Club East"]
[null,null,null,null,null,"Country Club West"]
[null,null,null,null,null,"Cow Fork Bull Creek"]
[null,null,null,null,null,"Cuernavaca Creek"]
[null,null,null,null,null,"Cypress Creek"]
[null,null,null,null,null,"Danz Creek"]
[null,null,null,null,null,"Decker Creek"]
[null,null,null,null,null,"Devil's Hollow"]
[null,null,null,null,null,"Devil's Pen Creek"]
[null,null,null,null,null,"Devil's Pen Creek"]
[null,null,null,null,null,"Dry Creek East"]
[null,null,null,null,null,"Dry Creek North"]
[null,null,null,null,null,"Eanes Creek"]
[null,null,null,null,null,"East Bouldin Creek"]
[null,null,null,null,null,"Elm Creek"]
[null,null,null,null,null,"Fort Branch"]
[null,null,null,null,null,"Gilleland Creek"]
[null,null,null,null,null,"Gragg Hollow"]
[null,null,null,null,null,"Grape Creek"]
[null,null,null,null,null,"Hancock Branch"]
[null,null,null,null,null,"Harper's Branch"]
[null,null,null,null,null,"Harris Branch"]
[null,null,null,null,null,"Harrison Hollow"]
[null,null,null,null,null,"Hog Pen Creek"]
[null,null,null,null,null,"Holman Hollow"]
[null,null,null,null,null,"Honey Creek"]
[null,null,null,null,null,"Huck's Slough"]
[null,null,null,null,null,"Hurst Creek"]
[null,null,null,null,null,"Johnson Creek"]
[null,null,null,null,null,"Kincheon Branch"]
[null,null,null,null,null,"Lady Bird Lake"]
[null,null,null,null,null,"Lake Austin"]
[null,null,null,null,null,"Lake Creek"]
[null,null,null,null,null,"Lake Travis"]
[null,null,null,null,null,"Lime Creek"]
[null,null,null,null,null,"Little Bear Creek"]
[null,null,null,null,null,"Little Bee Creek"]
[null,null,null,null,null,"Little Devil's Hollow"]
[null,null,null,null,null,"Little Walnut Creek"]
[null,null,null,null,null,"Long Branch"]
[null,null,null,null,null,"Long Hollow"]
[null,null,null,null,null,"Long Hollow Creek"]
[null,null,null,null,null,"Marble Creek"]
[null,null,null,null,null,"Myrtle Creek"]
[null,null,null,null,null,"Onion Creek"]
[null,null,null,null,null,"Panther Hollow"]
[null,null,null,null,null,"Quail Creek Branch"]
[null,null,null,null,null,"Rattan Creek"]
[null,null,null,null,null,"Rinard Creek"]
[null,null,null,null,null,"Rocky Creek"]
[null,null,null,null,null,"Running Deer Creek"]
[null,null,null,null,null,"Shoal Creek"]
[null,null,null,null,null,"Short Spring Branch"]
[null,null,null,null,null,"Slaughter Creek"]
[null,null,null,null,null,"South Boggy Creek"]
[null,null,null,null,null,"South Brushy Creek"]
[null,null,null,null,null,"Spring Hollow"]
[null,null,null,null,null,"St. Stephens Creek"]
[null,null,null,null,null,"Steiner Creek"]
[null,null,null,null,null,"Sycamore Creek"]
[null,null,null,null,null,"Tannehill Branch"]
[null,null,null,null,null,"Tar Branch"]
[null,null,null,null,null,"Tar Hollow"]
[null,null,null,null,null,"Taylor Slough North"]
[null,null,null,null,null,"Taylor Slough South"]
[null,null,null,null,null,"Thomas Spring Branch"]
[null,null,null,null,null,"Turkey Creek"]
[null,null,null,null,null,"Waller Creek"]
[null,null,null,null,null,"Walnut Creek"]
[null,null,null,null,null,"Walter E. Long Lake"]
[null,null,null,null,null,"Wells Branch"]
[null,null,null,null,null,"West Bouldin Creek"]
[null,null,null,null,null,"West Bull Creek"]
[null,null,null,null,null,"White Branch"]
[null,null,null,null,null,"Williamson Creek"]
[null,null,null,null,null,"Yaupon Creek"]
[null,null,null,null,null,"Yett Branch"]

{"sheet":"CCC Rate Compare Graphs","index":2,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,3,0,4],[1,1,1,2]]}
["ENR 2002",null,null,"Cost per impervious acre",null,"Oct 2018/2002 number"]
[6579,"Impervious Acres",null,"ENR CCI AF (2018)",null,1.6998,1.6998,1,null,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,101991,59495,129000,103000,129000,null,82500,84100,140237,142957,95000,null,129000,103000]
["A2",1.01,2,18000,15000,30597,25498,70000,70000,70000,null,23900,34500,40626,58645,64000,null,70000,70000]
["A3",2.0099999999999998,5,8000,10000,13599,16998,44000,44000,44000,null,14200,22800,24138,38756,40000,null,44000,44000]
["A4",5.01,10,6000,7000,10199,11899,29000,29000,29000,null,8600,15300,14619,26008,26000,null,29000,29000]
["A5",10.01,20,5000,5000,8499,8499,20000,20000,20000,null,5600,10800,9519,18358,18000,null,20000,20000]
["A6",20.010000000000002,50,4000,3000,6799,5100,12000,12000,12000,null,4600,5000,7819,8499,11000,null,12000,12000]
["A7",50.01,100,2500,2000,4250,3400,8000,8000,8000,null,2500,3700,4250,6289,8000,null,8000,8000]
["A8",100.01,">",2500,1500,4250,2550,4000,4000,4000,null,2500,2500,4250,4250,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,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,0.88742500000000002]
[null,null,null,null,null,null,0.55000000000000004,null,1.0416749999999999]
[null,null,null,null,null,null,0.65,null,1.1959249999999999]
[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,"2023-10-18","2023-10-02"]
[null,null,null,null,11183.28,6579,1.6998]
[null,"From","To","Commercial","Residential","Current Commercial (Adjusted)","Current Residential (Adjusted)","Proposed Commercial","Proposed Residential"]
["A1",0,1,60000,35000,101991,59495,129000,103000]
["A2",1.01,2,18000,15000,30597,25498,70000,70000]
["A3",2.0099999999999998,5,8000,10000,13599,16998,44000,44000]
["A4",5.01,10,6000,7000,10199,11899,29000,29000]
["A5",10.01,20,5000,5000,8499,8499,20000,20000]
["A6",20.010000000000002,50,4000,3000,6799,5100,12000,12000]
["A7",50.01,100,2500,2000,4250,3400,8000,8000]
["A8",100.01,">",2500,1500,4250,2550,4000,4000]

{"sheet":"Automation","index":3,"n_rows":2,"n_cols":38,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Row","Project Name","Project Address(es)","Watershed","10-Digit Parcel ID","Appraisal District","Appraisal Year","Appraised Land Value","Zoning","Zoning Overlay(s)","%IC Allowed by Zoning","Site Area (acres)","LOC (acres)","Area Allowable Exclusions","Existing IC","Proposed IC","Owner Name","Owner Phone","Owner Email","Owner Address","Applicant Name","Applicant Phone","Applicant Email","Applicant Address","Dev Type SF","Dev Type MF/MU/C","Dev Type MF","Dev Type MU","Dev Type C","Dev Type Other","Dev App Type SP","Dev App Type C8","Dev App Type C8 PP","Dev App Type C8 FP","Dev App Type C8 CP","RSMP Part Type Payment","RSMP Part Type Improvements","RSMP Part Type Other"]
[1]