{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Calculator","Assumptions","Rent-Owner Afford Cost","Homeowner Cost","PMI","Interest Rates","IncomeLimits","2023","2022","2021","2020","2019","2018","2017","2016","2015","2014","2013"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Calculator","index":0,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Housing Affordability Calculator","Inputs/Outputs"]
["Year",2023]
["County","Fresno"]
["Tenure","Renter",null,null,null,null,null,null,null,null,"Renter"]
["Bedrooms",2,null,null,null,null,null,null,null,null,"Owner"]
[{"$f":"IF(B4=\"Owner\",\"Sales Price\",IF(B4=\"Renter\",\"Monthly Rent\",\"\"))","v":"Monthly Rent"},1200,null,null,null,null,null,null,null,null,0]
["Monthly Cost (Before Utilities)",{"$f":"IF(B4=\"Renter\",$B$6,IF(B4=\"Owner\",'Homeowner Cost'!$B$21,\"\"))","v":1200},null,null,null,null,null,null,null,null,1]
["Lowest Affordability Level",{"$f":"IFERROR(IF(B7<E40,\"Extremely Low Income\",IF(B7>E40,IF(B7<F40,\"Very Low Income\",IF(B7<G40,\"Lower Income\",IF(B7<H40,\"Moderate Income\",\"Above Moderate Income\"))))),\"\")","v":"Lower Income"},null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,3]
["A. Check to make sure you are using the calculator for the year of the Annual Progress\n   ",null,null,null,null,null,null,null,null,null,4]
["Report you are completing. The year in row 2 should match the year of the Annual ",null,null,null,null,null,null,null,null,null,5]
["Progress Report you are completing. If it does not, close the AMI calculator workbook ",null,null,null,null,null,null,null,null,null,6]
["and download the AMI calculator workbook for the most recent year.",null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,2023]
["B. In row 3, select from the drop down list the County in which the jurisdiction for which ",null,null,null,null,null,null,null,null,null,2022]
[" you are completing the annual report is located.  ",null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,null,null,null,null,null,null,2020]
["C. In row 4, select the tenure of the unit for which you are calculating the affordability",null,null,null,null,null,null,null,null,null,2019]
["level. If “Owner” is selected in row 4, row 6 will update to say “Sales Price”. If ",null,null,null,null,null,null,null,null,null,{"$f":"K18-1","v":2018}]
["“Renter” is selected in row 4, row 6 will update to say “Monthly Rent”",null,null,null,null,null,null,null,null,null,{"$f":"K19-1","v":2017}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K20-1","v":2016}]
["D. In row 5, select the number of bedrooms in the unit for which affordability level is being \n",null,null,null,null,null,null,null,null,null,{"$f":"K21-1","v":2015}]
["calculated.",null,null,null,null,null,null,null,null,null,{"$f":"K22-1","v":2014}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K23-1","v":2013}]
["E. If “Sales Price” appears in row 6, enter the sales price of the unit for which \n    ",null,null,null,null,null,null,null,null,null,2012]
["affordability level is being calculated. If “Monthly Rent” appears in row 6, enter on",null,null,null,null,null,null,null,null,null,2011]
["the right the monthly rent for the unit for which affordability level is being calculated.",null,null,null,null,null,null,null,null,null,2010]
[null,null,null,null,null,null,null,null,null,null,2009]
["F. Row 7 will auto-populate with the monthly housing cost before utilities. For renter-   "]
["occupied units, the number in row 7 will match the monthly rent provided in row 6. For"]
["owner-occupied units, the number in row 7 will be calculated based on the sales price"]
["provided in row 6 and estimated monthly housing costs associated with owning a home"]
["with that sales price. For more detail on monthly housing costs for owner-occupied units,"]
["please see the “Assumptions” tab of this workbook."]
[]
["G. Once rows 2-6 are completed, row 8 will auto-populate with a determination of the\n   "]
["lowest affordability level a unit of the tenure, size, and monthly cost in rows 2-7"]
["could serve based on Health & Safety Code Sections 50052.5 and 50053."]
[null,null,null,null,"ELI","VLI","LI","MI"]
[null,"Based on BR and Tenure",null,null,{"$f":"VLOOKUP(Calculator!$B$4&Calculator!$B$5,'Rent-Owner Afford Cost'!$C$92:$G$107,2,FALSE)","v":427.36},{"$f":"VLOOKUP(Calculator!$B$4&Calculator!$B$5,'Rent-Owner Afford Cost'!$C$92:$G$107,3,FALSE)","v":804.46},{"$f":"VLOOKUP(Calculator!$B$4&Calculator!$B$5,'Rent-Owner Afford Cost'!$C$92:$G$107,4,FALSE)","v":1345.585},{"$f":"VLOOKUP(Calculator!$B$4&Calculator!$B$5,'Rent-Owner Afford Cost'!$C$92:$G$107,5,FALSE)","v":2124.085}]

{"sheet":"Assumptions","index":1,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Housing Affordability Calculator"]
["Assumptions"]
["The Housing Affordability Calculator makes its affordability determinations based on the income levels provided in the Official State Income Limits published annually by HCD. The Official State Income Limits are available on HCDs website at http://www.hcd.ca.gov/grants-funding/income-limits/state-and-federal-income-limits.shtml. The Calculator uses the definition of “affordable” as defined in Health and Safety Code Sections 50052.5 and 50053. Where these sections provide more than one option for the rent or housing cost used to calculate affordability, the calculator bases its determination on the higher option.  "]
["For all units, the calculator assumes the following:\nA. Household size will exceed bedroom count by one (e.g. the household size of a two \n     bedroom unit will be three persons).\nB. Monthly housing costs will include a utility allowance equal to the Average California \n     Monthly Residential Utility Bill according to the U.S. Energy Information Administration[i]\n     (EIA) ($116.94 per month in 2020)."]
["For owner-occupied units, the calculator assumes the following based on the most recent data available at the time that the calculator is updated:\nA. A 30-year Federal Housing Administration (FHA) mortgage with a down-payment of\n     3.5% of the sales price.\nB. The highest national average mortgage interest rate from the fiscal year prior[ii]\nC. A private mortgage insurance premium calculated pursuant to HUD’s FHA methodology\nD. A property tax rate of 1.1%\nE. For homeowners’ insurance, the Annual Average Written Premium according to the \n     Homeowners Multi-Peril Data[iii] from the California Department of Insurance.\nF. Average annual home maintenance equal to 1% of sales price\nG. Statewide Average Monthly Water Bill per most recent California Water Boards Drinking\n     Water Needs Assessment [iv]\nH. Monthly sewer costs pursuant to the average California wastewater costs in the State\n     Water Resources Control Board survey [v]\nI.  Monthly trash pickup and residential garbage collection costs in the middle of the range provided by HomeAdvisor[vi].\n\n"]
["References"]
["[i] https://www.eia.gov/electricity/sales_revenue_price/pdf/table5_a.pdf"]
["[ii] https://fred.stlouisfed.org/series/MORTGAGE30US"]
["[iii] https://www.insurance.ca.gov/0400-news/0200-studies-reports/0250-homeowners-study/upload/A-Part-I-Data-Summary.xlsx"]
["[iv]https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/needs/2021_needs_assessment.pdf "]
["[v]https://www.waterboards.ca.gov/water_issues/programs/grants_loans/srf/docs/cy2018ww_user_charge_survey.pdf"]
["[vi] https://www.homeadvisor.com/cost/cleaning-services/remove-waste/"]

{"sheet":"Rent-Owner Afford Cost","index":2,"n_rows":107,"n_cols":20,"rows_kept":107,"cut":false,"hidden":true,"merged":[[3,2,3,8],[71,0,71,16],[5,0,5,4],[13,4,15,4],[53,0,69,0],[35,0,51,0],[26,0,33,0],[17,0,24,0],[35,5,42,5],[44,3,51,3],[53,5,60,5],[62,3,69,3],[86,13,86,14],[81,7,82,8],[80,0,80,16],[83,13,83,14],[84,13,84,14],[85,13,85,14],[72,0,72,16],[77,0,77,16],[78,0,78,16],[79,0,79,16],[73,7,73,9],[73,11,73,12],[73,13,73,16],[74,7,74,9],[74,11,74,12],[74,13,74,16]]}
["HCD GUIDE: Applicable for Projects Required to Comply with CA Health & Safety Code Sections 50052.5 and 50053."]
["Example of affordable housing cost estimator:"]
[]
[null,"COUNTY (fill-in):",{"$f":"Calculator!B3","v":"Fresno"},null,null,null,null,null,null,null,{"$f":"Calculator!B2","v":2023},"(fill-in: Calendar Year)"]
["Affordable Housing Cost:",null,"             AREA MEDIAN INCOME (AMI):",null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,IncomeLimits!$A$2:$B$59,2,FALSE)","v":83800},"(Auto calculated by County name)"]
["Reasonable Utility Allowance (Most Recent Average California Monthly Residential Utility Bill (EIA))\nhttps://www.eia.gov/electricity/sales_revenue_price/pdf/table5_a.pdf:",null,null,null,null,138.29,null,"To find COUNTY & INCOME to \"fill-in\":"]
[null,null,null,"RENTER",null,"OWNER",null,"for AMI, use \"Official State Income Limits\" at below link"]
["Health & Safety Code (H&SC):",null,null,"§§   50053   ",null,"§§   50052.5",null,"http://www.hcd.ca.gov/grants-funding/income-limits/state-and-federal-income-limits/docs/inc2k18.pdf"]
["Extremely Low",null,null,0.3,null,0.3,null,"[",null,null,null," Formula",null,null,null,"Months ]"]
["Very Low",null,null,0.5,null,0.5,null,"  (These columns show how the maximum monthly"]
["Low",null,null,0.6,null,0.7,null,"    rent and maximum housing cost were calculated.)"]
["Moderate",null,null,1.1000000000000001,null,1.1000000000000001,null,null,null,null,null,null,"Above"]
[null," H&SC 50052.5(h)",null,"Maximum",null,null,null,null,null,null,null,null,"County's"]
[null,"Unit","HH","Monthly","Rent After Utility Allowance","Maximum Month",null,null,"Max",null,null,null,"Area",null,"* Family"]
[null,"Size","Size","Renter Housing Cost",null,"House Cost",null,null,"Cost",null,"Median %",null,"Median",null,"Size"]
["Income Group","Bedrooms","Persons","(Renters)",null,"(Owners)",null,"[","%",null,"Upper Limit",null,"Income",null,"Adj.","Months ]",null,null,"Alternate Rent Option"]
[]
["Extremely Low Income HH","0 (Studio)",1,{"$f":"(($I18*$K18*$M18*$O18)/12)","v":439.95},{"$f":"D18-$F$6","v":301.65999999999997},"same",{"$f":"D18-$F$6","v":301.65999999999997},"[ (",0.3,"x",0.3,"x",{"$f":"K$5","v":83800},"x",0.7,")"," / 12  ]"]
[null,"1 bedroom",2,502.8,{"$f":"D19-$F$6","v":364.51},"same",{"$f":"D19-$F$6","v":364.51},"[ (",0.3,"x",0.3,"x",{"$f":"K$5","v":83800},"x",0.8,")"," / 12  ]"]
[null,"2 bedrooms",3,565.65,{"$f":"D20-$F$6","v":427.36},"same",427.36,"[ (",0.3,"x",0.3,"x",{"$f":"K$5","v":83800},"x",0.9,")"," / 12  ]"]
[null,"3 bedrooms",4,628.5,{"$f":"D21-$F$6","v":490.21000000000004},"same",490.21000000000004,"[ (",0.3,"x",0.3,"x",{"$f":"K$5","v":83800},"x",1,")"," / 12  ]"]
[null,"4 bedrooms",5,678.78000000000009,{"$f":"D22-$F$6","v":540.49000000000012},"same",540.49000000000012,"[ (",0.3,"x",0.3,"x",{"$f":"K$5","v":83800},"x",1.08,")"," / 12  ]"]
[null,"5 bedrooms",6,729.06,{"$f":"D23-$F$6","v":590.77},"same",590.77,"[ (",0.3,"x",0.3,"x",{"$f":"K$5","v":83800},"x",1.1599999999999999,")"," / 12  ]"]
[null,"6 bedrooms",7,{"$f":"(($I24*$K24*$M24*$O24)/12)","v":779.34},641.05000000000007,"same",641.05000000000007,"[ (",0.3,"x",0.3,"x",83800,"x",1.24,")"," / 12  ]"]
[null,"7 bedrooms",8,829.62,691.33,"same",691.33,"[ (",0.3,"x",0.3,"x",83800,"x",1.32,")"," / 12  ]"]
[]
["Very Low Income HH","0 (Studio)",1,{"$f":"(($I27*$K27*$M27*$O27)/12)","v":733.25},{"$f":"D27-$F$6","v":594.96},"same",594.96,"[ (",0.3,"x",0.5,"x",{"$f":"K$5","v":83800},"x",0.7,")"," / 12  ]"]
[null,"1 bedroom",2,{"$f":"(($I28*$K28*$M28*$O28)/12)","v":838},{"$f":"D28-$F$6","v":699.71},"same",699.71,"[ (",0.3,"x",0.5,"x",{"$f":"K$5","v":83800},"x",0.8,")"," / 12  ]"]
[null,"2 bedrooms",3,{"$f":"(($I29*$K29*$M29*$O29)/12)","v":942.75},{"$f":"D29-$F$6","v":804.46},"same",804.46,"[ (",0.3,"x",0.5,"x",{"$f":"K$5","v":83800},"x",0.9,")"," / 12  ]"]
[null,"3 bedrooms",4,{"$f":"(($I30*$K30*$M30*$O30)/12)","v":1047.5},{"$f":"D30-$F$6","v":909.21},"same",909.21,"[ (",0.3,"x",0.5,"x",{"$f":"K$5","v":83800},"x",1,")"," / 12  ]"]
[null,"4 bedrooms",5,{"$f":"(($I31*$K31*$M31*$O31)/12)","v":1131.3},{"$f":"D31-$F$6","v":993.01},"same",993.01,"[ (",0.3,"x",0.5,"x",{"$f":"K$5","v":83800},"x",1.08,")"," / 12  ]"]
[null,"5 bedrooms",6,{"$f":"(($I32*$K32*$M32*$O32)/12)","v":1215.0999999999999},{"$f":"D32-$F$6","v":1076.81},"same",1076.81,"[ (",0.3,"x",0.5,"x",{"$f":"K$5","v":83800},"x",1.1599999999999999,null," / 12  ]"]
[null,"6 bedrooms",7,1298.8999999999999,1160.6099999999999,"same",1160.6099999999999,"[ (",0.3,"x",0.5,"x",83800,"x",1.24,null," / 12  ]"]
[null,"7 bedrooms",8,1382.7,1244.4100000000001,"same",1244.4100000000001,"[ (",0.3,"x",0.5,"x",83800,"x",1.32,null," / 12  ]"]
[]
["Low        Income HH","0 (Studio)",1,{"$f":"(($I36*$K36*$M36*$O36)/12)","v":879.9},{"$f":"D36-$F$6","v":741.61},"60% median               applies to        renters",null,"[ (",0.3,"x",0.6,"x",{"$f":"K$5","v":83800},"x",0.7,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$C$59,3,FALSE)*O36*I36)/12)-$F$6","v":1015.835},"H&SC 50053(b)(4) provides option for highest maximum rent to not exceed"]
[null,"1 bedroom",2,{"$f":"(($I37*$K37*$M37*$O37)/12)","v":1005.6},{"$f":"D37-$F$6","v":867.31000000000006},null,null,"[ (",0.3,"x",0.6,"x",{"$f":"K$5","v":83800},"x",0.8,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$C$59,3,FALSE)*O37*I37)/12)-$F$6","v":1180.71},"30% of household (HH) gross income when lower income HH gross income"]
[null,"2 bedrooms",3,{"$f":"(($I38*$K38*$M38*$O38)/12)","v":1131.3},{"$f":"D38-$F$6","v":993.01},null,null,"[ (",0.3,"x",0.6,"x",{"$f":"K$5","v":83800},"x",0.9,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$C$59,3,FALSE)*O38*I38)/12)-$F$6","v":1345.585},"exceeds 60% of AMI adjusted for HH size or when moderate income HH"]
[null,"3 bedrooms",4,{"$f":"(($I39*$K39*$M39*$O39)/12)","v":1257},{"$f":"D39-$F$6","v":1118.71},null,null,"[ (",0.3,"x",0.6,"x",{"$f":"K$5","v":83800},"x",1,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$C$59,3,FALSE)*O39*I39)/12)-$F$6","v":1510.46},"gross income exceeds 110% of AMI adjusted for HH size"]
[null,"4 bedrooms",5,{"$f":"(($I40*$K40*$M40*$O40)/12)","v":1357.5600000000002},{"$f":"D40-$F$6","v":1219.2700000000002},null,null,"[ (",0.3,"x",0.6,"x",{"$f":"K$5","v":83800},"x",1.08,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$C$59,3,FALSE)*O40*I40)/12)-$F$6","v":1642.36}]
[null,"5 bedrooms",6,{"$f":"(($I41*$K41*$M41*$O41)/12)","v":1458.12},{"$f":"D41-$F$6","v":1319.83},null,null,"[ (",0.3,"x",0.6,"x",{"$f":"K$5","v":83800},"x",1.1599999999999999,null," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$C$59,3,FALSE)*O41*I41)/12)-$F$6","v":1774.26}]
[null,"6 bedrooms",7,1558.68,1420.39,null,null,"[ (",0.3,"x",0.6,"x",83800,"x",1.24,null," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$C$59,3,FALSE)*O42*I42)/12)-$F$6","v":1906.1599999999999}]
[null,"7 bedrooms",8,1659.24,1520.95,null,null,"[ (",0.3,"x",0.6,"x",83800,"x",1.32,null," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$C$59,3,FALSE)*O43*I43)/12)-$F$6","v":2038.06}]
[]
[null,"0 (Studio)",1,"70% median applies to owners",null,{"$f":"(($I45*$K45*$M45*$O45)/12)","v":1026.55},{"$f":"F45-$F$6","v":888.26},"[ (",0.3,"x",0.7,"x",{"$f":"K$5","v":83800},"x",0.7,")"," / 12  ]"]
[null,"1 bedroom",2,null,null,{"$f":"(($I46*$K46*$M46*$O46)/12)","v":1173.2},{"$f":"F46-$F$6","v":1034.9100000000001},"[ (",0.3,"x",0.7,"x",{"$f":"K$5","v":83800},"x",0.8,")"," / 12  ]"]
[null,"2 bedrooms",3,null,null,{"$f":"(($I47*$K47*$M47*$O47)/12)","v":1319.8500000000001},{"$f":"F47-$F$6","v":1181.5600000000002},"[ (",0.3,"x",0.7,"x",{"$f":"K$5","v":83800},"x",0.9,")"," / 12  ]"]
[null,"3 bedrooms",4,null,null,{"$f":"(($I48*$K48*$M48*$O48)/12)","v":1466.5},{"$f":"F48-$F$6","v":1328.21},"[ (",0.3,"x",0.7,"x",{"$f":"K$5","v":83800},"x",1,")"," / 12  ]"]
[null,"4 bedrooms",5,null,null,{"$f":"(($I49*$K49*$M49*$O49)/12)","v":1583.82},{"$f":"F49-$F$6","v":1445.53},"[ (",0.3,"x",0.7,"x",{"$f":"K$5","v":83800},"x",1.08,")"," / 12  ]"]
[null,"5 bedrooms",6,null,null,{"$f":"(($I50*$K50*$M50*$O50)/12)","v":1701.14},{"$f":"F50-$F$6","v":1562.8500000000001},"[ (",0.3,"x",0.7,"x",{"$f":"K$5","v":83800},"x",1.1599999999999999,null," / 12  ]"]
[null,"6 bedrooms",7,null,null,1818.46,1680.17,"[ (",0.3,"x",0.7,"x",83800,"x",1.24,null," / 12  ]"]
[null,"7 bedrooms",8,null,null,1935.78,1797.49,"[ (",0.3,"x",0.7,"x",83800,"x",1.32,null," / 12  ]"]
[]
["Moderate Income HH","0 (Studio)",1,{"$f":"(($I54*$K54*$M54*$O54)/12)","v":1613.1499999999999},{"$f":"D54-$F$6","v":1474.86},"30% cost                  applies to        renters",null,"[ (",0.3,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",0.7,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$D$59,4,FALSE)*O54*I54)/12)-$F$6","v":1621.335},"H&SC 50053(b)(4) provides option for highest maximum rent to not exceed"]
[null,"1 bedroom",2,{"$f":"(($I55*$K55*$M55*$O55)/12)","v":1843.6000000000001},{"$f":"D55-$F$6","v":1705.3100000000002},null,null,"[ (",0.3,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",0.8,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$D$59,4,FALSE)*O55*I55)/12)-$F$6","v":1872.71},"30% of household (HH) gross income when moderate income HH gross"]
[null,"2 bedrooms",3,{"$f":"(($I56*$K56*$M56*$O56)/12)","v":2074.0500000000002},{"$f":"D56-$F$6","v":1935.7600000000002},null,null,"[ (",0.3,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",0.9,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$D$59,4,FALSE)*O56*I56)/12)-$F$6","v":2124.085},"income exceeds 110% of AMI adjusted for HH size"]
[null,"3 bedrooms",4,{"$f":"(($I57*$K57*$M57*$O57)/12)","v":2304.5},{"$f":"D57-$F$6","v":2166.21},null,null,"[ (",0.3,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",1,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$D$59,4,FALSE)*O57*I57)/12)-$F$6","v":2375.46}]
[null,"4 bedrooms",5,{"$f":"(($I58*$K58*$M58*$O58)/12)","v":2488.86},{"$f":"D58-$F$6","v":2350.5700000000002},null,null,"[ (",0.3,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",1.08,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$D$59,4,FALSE)*O58*I58)/12)-$F$6","v":2576.56}]
[null,"5 bedrooms",6,{"$f":"(($I59*$K59*$M59*$O59)/12)","v":2673.22},{"$f":"D59-$F$6","v":2534.9299999999998},null,null,"[ (",0.3,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",1.1599999999999999,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$D$59,4,FALSE)*O59*I59)/12)-$F$6","v":2777.6599999999994}]
[null,"6 bedrooms",7,2857.58,2719.29,null,null,"[ (",0.3,"x",1.1000000000000001,"x",83800,"x",1.24,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$D$59,4,FALSE)*O60*I60)/12)-$F$6","v":2978.7599999999998}]
[null,"7 bedrooms",8,3041.94,2903.65,null,null,"[ (",0.3,"x",1.1000000000000001,"x",83800,"x",1.32,")"," / 12  ]",null,{"$f":"((VLOOKUP($C$4,IncomeLimits!$A$2:$D$59,4,FALSE)*O61*I61)/12)-$F$6","v":3179.8599999999997}]
[]
[null,"0 (Studio)",1,"35% cost applies to owners",null,{"$f":"(($I63*$K63*$M63*$O63)/12)","v":1882.0083333333332},{"$f":"F63-$F$6","v":1743.7183333333332},"[ (",0.35,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",0.7,")"," / 12  ]"]
[null,"1 bedroom",2,null,null,{"$f":"(($I64*$K64*$M64*$O64)/12)","v":2150.8666666666668},{"$f":"F64-$F$6","v":2012.5766666666668},"[ (",0.35,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",0.8,")"," / 12  ]"]
[null,"2 bedrooms",3,null,null,{"$f":"(($I65*$K65*$M65*$O65)/12)","v":2419.7249999999999},{"$f":"F65-$F$6","v":2281.4349999999999},"[ (",0.35,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",0.9,")"," / 12  ]"]
[null,"3 bedrooms",4,null,null,{"$f":"(($I66*$K66*$M66*$O66)/12)","v":2688.5833333333335},{"$f":"F66-$F$6","v":2550.2933333333335},"[ (",0.35,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",1,")"," / 12  ]"]
[null,"4 bedrooms",5,null,null,{"$f":"(($I67*$K67*$M67*$O67)/12)","v":2903.67},{"$f":"F67-$F$6","v":2765.38},"[ (",0.35,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",1.08,")"," / 12  ]"]
[null,"5 bedrooms",6,null,null,{"$f":"(($I68*$K68*$M68*$O68)/12)","v":3118.7566666666662},{"$f":"F68-$F$6","v":2980.4666666666662},"[ (",0.35,"x",1.1000000000000001,"x",{"$f":"K$5","v":83800},"x",1.1599999999999999,")"," / 12  ]"]
[null,"6 bedrooms",7,null,null,3333.8433333333337,3195.5533333333337,"[ (",0.35,"x",1.1000000000000001,"x",83800,"x",1.24,")"," / 12  ]"]
[null,"7 bedrooms",8,null,null,3548.9300000000003,3410.6400000000003,"[ (",0.35,"x",1.1000000000000001,"x",83800,"x",1.32,")"," / 12  ]"]
[]
["* Family Size (1-8) Adjustment:  Adjustments are made so larger families have higher income limits.                                                         The 4-person income limit serves as the base in calculating income limits for household sizes other than 4 persons.                                                 For family sizes ranging from 1 to 8 persons, the multipliers are as follows:"]
["Number of Persons (below):"]
[1,2,3,4,null,null,null,5,null,null,6,7,null,8]
[0.7,0.8,0.9,"1.0 (base)",null,null,null,1.08,null,null,1.1599999999999999,1.24,null,1.32]
["Decimal Multipliers (above):"]
[]
["For households larger than eight persons (all income categories), determine income limit as follows:"]
["Per person (PP) adjustment above 8: (1) multiply the four-person income limit by eight percent (8%), (2) multiply result by"]
["number of persons in excess of eight, (3) add the amount to the income limit for eight persons, and         "]
["(4) round the result to the nearest $100."]
[null,null,null,null,null,null,null,"added to 8 persons"]
["E X A M P L E",null,"4 persons","x 8% PP Adj",null,null,null,null,null,null,"=  9 persons","8 persons+8%PPAdj(x2)",null,null,null,"= 10 persons"]
["Extremely Low",null,19500,{"$f":"+C84*0.08","v":1560},null,null,null,null,{"$f":"+C84*1.32+10","v":25750},null,{"$f":"+I84+D84-10","v":27300},null,25750,{"$f":"+D84*2","v":3120},null,null,{"$f":"+D84*2+I84+30","v":28900}]
["Very Low Income",null,35650,{"$f":"+C85*0.08","v":2852},null,null,null,null,{"$f":"+C85*1.32+42","v":47100},null,{"$f":"+I85+D85+48","v":50000},null,47100,{"$f":"+D85*2","v":5704},null,null,{"$f":"+D85*2+I85-4","v":52800}]
["Lower Income",null,55750,{"$f":"+C86*0.08","v":4460},null,null,null,null,{"$f":"+C86*1.32+10","v":73600},null,{"$f":"+I86+D86+40","v":78100},null,73600,{"$f":"+D86*2","v":8920},null,null,{"$f":"+D86*2+I86-20","v":82500}]
["Moderate Income",null,80500,{"$f":"+C87*0.08","v":6440},null,null,null,null,{"$f":"+C87*1.32-10","v":106250},null,{"$f":"+I87+D87+10","v":112700},null,106250,{"$f":"+D87*2","v":12880},null,null,{"$f":"+D87*2+I87-30","v":119100}]
[]
["Source: California Department of Housing and Community Development/ Division of Housing Policy 4/26/2018"]
[]
[null,"BR",null,"ELI","VLI","LI","MI"]
["Renter",0,{"$f":"A92&B92","v":"Renter0"},{"$f":"E18","v":301.65999999999997},{"$f":"E27","v":594.96},{"$f":"IF(E36<S36,S36,E36)","v":1015.835},{"$f":"IF(E54<S54,S54,E54)","v":1621.335}]
["Renter",1,{"$f":"A93&B93","v":"Renter1"},{"$f":"E19","v":364.51},{"$f":"E28","v":699.71},{"$f":"IF(E37<S37,S37,E37)","v":1180.71},{"$f":"IF(E55<S55,S55,E55)","v":1872.71}]
["Renter",2,"Renter2",{"$f":"E20","v":427.36},{"$f":"E29","v":804.46},{"$f":"IF(E38<S38,S38,E38)","v":1345.585},{"$f":"IF(E56<S56,S56,E56)","v":2124.085}]
["Renter",3,"Renter3",{"$f":"E21","v":490.21000000000004},{"$f":"E30","v":909.21},{"$f":"IF(E39<S39,S39,E39)","v":1510.46},{"$f":"IF(E57<S57,S57,E57)","v":2375.46}]
["Renter",4,"Renter4",{"$f":"E22","v":540.49000000000012},{"$f":"E31","v":993.01},{"$f":"IF(E40<S40,S40,E40)","v":1642.36},{"$f":"IF(E58<S58,S58,E58)","v":2576.56}]
["Renter",5,"Renter5",{"$f":"E23","v":590.77},{"$f":"E32","v":1076.81},{"$f":"IF(E41<S41,S41,E41)","v":1774.26},{"$f":"IF(E59<S59,S59,E59)","v":2777.6599999999994}]
["Renter",6,"Renter6",641.05000000000007,1160.6099999999999,1906.1599999999999,2978.7599999999998]
["Renter",7,"Renter7",691.33,1244.4100000000001,2038.06,3179.8599999999997]
["Owner",0,"Owner0",{"$f":"G18","v":301.65999999999997},{"$f":"G27","v":594.96},{"$f":"G45","v":888.26},{"$f":"G63","v":1743.7183333333332}]
["Owner",1,"Owner1",{"$f":"G19","v":364.51},{"$f":"G28","v":699.71},{"$f":"G46","v":1034.9100000000001},{"$f":"G64","v":2012.5766666666668}]
["Owner",2,"Owner2",{"$f":"G20","v":427.36},{"$f":"G29","v":804.46},{"$f":"G47","v":1181.5600000000002},{"$f":"G65","v":2281.4349999999999}]
["Owner",3,"Owner3",{"$f":"G21","v":490.21000000000004},{"$f":"G30","v":909.21},{"$f":"G48","v":1328.21},{"$f":"G66","v":2550.2933333333335}]
["Owner",4,"Owner4",{"$f":"G22","v":540.49000000000012},{"$f":"G31","v":993.01},{"$f":"G49","v":1445.53},{"$f":"G67","v":2765.38}]
["Owner",5,"Owner5",{"$f":"G23","v":590.77},{"$f":"G32","v":1076.81},{"$f":"G50","v":1562.8500000000001},{"$f":"G68","v":2980.4666666666662}]
["Owner",6,"Owner6",641.05000000000007,1160.6099999999999,1680.17,3195.5533333333337]
["Owner",7,"Owner7",691.33,1244.4100000000001,1797.49,{"$f":"G70","v":3410.6400000000003}]

{"sheet":"Homeowner Cost","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,1]
[null,3.5000000000000003E-2]
["SP",{"$f":"Calculator!B6","v":1200}]
[null,{"$f":"B3","v":1200}]
["DP",{"$f":"B2*B4","v":42.000000000000007}]
["LA",{"$f":"B3-B5","v":1158}]
["IR",{"$f":"'Interest Rates'!C54/100","v":7.0800000000000002E-2},"Updates based on \"Interest Rates\" tab"]
["YR",30]
["PPY",12]
["TP",{"$f":"B9*B8","v":360}]
["PPP",{"$f":"MROUND(-PMT(B7/B9,B10,B6,0),0.01)","v":7.7700000000000005}]
["PMI",{"$f":"PMI!B17","v":0.52},"Updates based on \"PMI\" tab"]
["PT",{"$f":"B3*0.011","v":13.2}]
["INS",1458.47,"https://www.insurance.ca.gov/0400-news/0200-studies-reports/0250-homeowners-study/upload/A-Part-I-Data-Summary.xlsx"]
["MNT",{"$f":"B3*0.01","v":12}]
["WSG",{"$f":"(75.95)+47.87+((25+100)/2)","v":186.32},"Water:\nhttps://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/documents/needs/2021_needs_assessment.pdf","Sewer: \nhttps://public.tableau.com/app/profile/rafael.maestu/viz/WastewaterSurvey12-18PUBLICAGENCIES/Story1","Garbage: https://www.homeadvisor.com/cost/cleaning-services/remove-waste/"]
["SUM",{"$f":"B11*B10","v":2797.2000000000003}]
["IC",{"$f":"B17-B6","v":1639.2000000000003}]
["R"]
["E",{"$f":"((SUM($B$13:$B$16)/12)+$B$11+$B$12)*12","v":1769.4700000000003}]
["Monthly Cost:",{"$f":"B20/12","v":147.45583333333335}]

{"sheet":"PMI","index":4,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,"https://www.hud.gov/program_offices/housing/comp/premiums/sfpcalc","a.","b.","c.","d"]
[null,{"$f":"'Homeowner Cost'!B6","v":1158},{"$f":"MROUND($B$2*'Homeowner Cost'!B$7*100,0.01)","v":8198.64},{"$f":"MROUND((C2/1200),0.01)","v":6.83},{"$f":"D2+B2","v":1164.83},{"$f":"$E$2-'Homeowner Cost'!$B$11","v":1157.06}]
[null,{"$f":"F2","v":1157.06},{"$f":"MROUND($B3*'Homeowner Cost'!B$7*100,0.01)","v":8191.9800000000005},{"$f":"MROUND((C3/1200),0.01)","v":6.83},{"$f":"D3+B3","v":1163.8899999999999},{"$f":"$E3-'Homeowner Cost'!$B$11","v":1156.1199999999999}]
[null,{"$f":"F3","v":1156.1199999999999},{"$f":"MROUND($B4*'Homeowner Cost'!B$7*100,0.01)","v":8185.33},6.82,{"$f":"D4+B4","v":1162.9399999999998},{"$f":"$E4-'Homeowner Cost'!$B$11","v":1155.1699999999998}]
[null,1155.1699999999998,{"$f":"MROUND($B5*'Homeowner Cost'!B$7*100,0.01)","v":8178.6},6.82,1161.9899999999998,{"$f":"$E5-'Homeowner Cost'!$B$11","v":1154.2199999999998}]
[null,1154.2199999999998,{"$f":"MROUND($B6*'Homeowner Cost'!B$7*100,0.01)","v":8171.88},6.8100000000000005,1161.0299999999997,{"$f":"$E6-'Homeowner Cost'!$B$11","v":1153.2599999999998}]
[null,1153.2599999999998,{"$f":"MROUND($B7*'Homeowner Cost'!B$7*100,0.01)","v":8165.08},6.8,1160.0599999999997,{"$f":"$E7-'Homeowner Cost'!$B$11","v":1152.2899999999997}]
[null,1152.2899999999997,{"$f":"MROUND($B8*'Homeowner Cost'!B$7*100,0.01)","v":8158.21},6.8,1159.0899999999997,{"$f":"$E8-'Homeowner Cost'!$B$11","v":1151.3199999999997}]
[null,1151.3199999999997,{"$f":"MROUND($B9*'Homeowner Cost'!B$7*100,0.01)","v":8151.35},6.79,1158.1099999999997,{"$f":"$E9-'Homeowner Cost'!$B$11","v":1150.3399999999997}]
[null,1150.3399999999997,{"$f":"MROUND($B10*'Homeowner Cost'!B$7*100,0.01)","v":8144.41},6.79,1157.1299999999997,{"$f":"$E10-'Homeowner Cost'!$B$11","v":1149.3599999999997}]
[null,1149.3599999999997,{"$f":"MROUND($B11*'Homeowner Cost'!B$7*100,0.01)","v":8137.47},6.78,1156.1399999999996,{"$f":"$E11-'Homeowner Cost'!$B$11","v":1148.3699999999997}]
[null,{"$f":"F11","v":1148.3699999999997},{"$f":"MROUND($B12*'Homeowner Cost'!B$7*100,0.01)","v":8130.46},6.78,{"$f":"D12+B12","v":1155.1499999999996},{"$f":"$E12-'Homeowner Cost'!$B$11","v":1147.3799999999997}]
[null,{"$f":"F12","v":1147.3799999999997},{"$f":"MROUND($B13*'Homeowner Cost'!B$7*100,0.01)","v":8123.45},6.7700000000000005,{"$f":"D13+B13","v":1154.1499999999996},{"$f":"$E13-'Homeowner Cost'!$B$11","v":1146.3799999999997}]
["Step 1",{"$f":"SUM(B2:B13)/12","v":1152.7408333333331}]
["Step 2",{"$f":"MROUND(IF(B2>F20,(MROUND(B14*H19,0.01)),(MROUND(B14*(H18),0.01))),0.01)","v":6.34},"MIP Rate: https://www.hud.gov/sites/documents/40001HSGH.PDF"]
["Step 3",{"$f":"MROUND((B15/(1+H17)),0.01)","v":6.23},"UFMIP Rate: https://www.hud.gov/sites/documents/40001HSGH.PDF",null,null,null,null,{"$f":"106605/0.965","v":110471.50259067358}]
["Step 4",{"$f":"MROUND((B16/12),0.01)","v":0.52},null,null,null,"UFMIP Rate (Basis Points)",175,{"$f":"G17/10000","v":1.7500000000000002E-2}]
["Step 5",{"$f":"B17*12","v":6.24},null,null,null,{"$f":"CONCATENATE(\"Annual MIP Rate (Basis Points) for Loans Less than or equal to $\", F20)","v":"Annual MIP Rate (Basis Points) for Loans Less than or equal to $726200"},55,{"$f":"G18/10000","v":5.4999999999999997E-3}]
[null,null,null,null,null,{"$f":"CONCATENATE(\"Annual MIP Rate (Basis Points) for Loans Greater Than $\",F20)","v":"Annual MIP Rate (Basis Points) for Loans Greater Than $726200"},65,{"$f":"G19/10000","v":6.4999999999999997E-3}]
[null,null,null,null,null,726200]

{"sheet":"Interest Rates","index":5,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["DATE","MORTGAGE30US","https://fred.stlouisfed.org/series/MORTGAGE30US"]
["2022-07-07",5.3]
["2022-07-14",5.51]
["2022-07-21",5.54]
["2022-07-28",5.3]
["2022-08-04",4.99]
["2022-08-11",5.22]
["2022-08-18",5.13]
["2022-08-25",5.55]
["2022-09-01",5.66]
["2022-09-08",5.89]
["2022-09-15",6.02]
["2022-09-22",6.29]
["2022-09-29",6.7]
["2022-10-06",6.66]
["2022-10-13",6.92]
["2022-10-20",6.94]
["2022-10-27",7.08]
["2022-11-03",6.95]
["2022-11-10",7.08]
["2022-11-17",6.61]
["2022-11-23",6.58]
["2022-12-01",6.49]
["2022-12-08",6.33]
["2022-12-15",6.31]
["2022-12-22",6.27]
["2022-12-29",6.42]
["2023-01-05",6.48]
["2023-01-12",6.33]
["2023-01-19",6.15]
["2023-01-26",6.13]
["2023-02-02",6.09]
["2023-02-09",6.12]
["2023-02-16",6.32]
["2023-02-23",6.5]
["2023-03-02",6.65]
["2023-03-09",6.73]
["2023-03-16",6.6]
["2023-03-23",6.42]
["2023-03-30",6.32]
["2023-04-06",6.28]
["2023-04-13",6.27]
["2023-04-20",6.39]
["2023-04-27",6.43]
["2023-05-04",6.39]
["2023-05-11",6.35]
["2023-05-18",6.39]
["2023-05-25",6.57]
["2023-06-01",6.79]
["2023-06-08",6.71]
["2023-06-15",6.69]
["2023-06-22",6.67]
["2023-06-29",6.71]
[null,null,{"$f":"MAX(B2:B53)","v":7.08}]

{"sheet":"IncomeLimits","index":6,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income ","Low Income","Moderate Income",{"$f":"'Rent-Owner Afford Cost'!K4","v":2023}]
["Alameda",{"$f":"VLOOKUP($A2,INDIRECT(\"\"&$E$1&\"!\"&\"$A$2:$D$59\"),2,FALSE)","v":147900},{"$f":"VLOOKUP($A2,INDIRECT(\"\"&$E$1&\"!\"&\"$A$2:$D$59\"),3,FALSE)","v":112150},{"$f":"VLOOKUP($A2,INDIRECT(\"\"&$E$1&\"!\"&\"$A$2:$D$59\"),4,FALSE)","v":177500}]
["Alpine",{"$f":"VLOOKUP($A3,INDIRECT(\"\"&$E$1&\"!\"&\"$A$2:$D$59\"),2,FALSE)","v":114600},{"$f":"VLOOKUP($A3,INDIRECT(\"\"&$E$1&\"!\"&\"$A$2:$D$59\"),3,FALSE)","v":76900},{"$f":"VLOOKUP($A3,INDIRECT(\"\"&$E$1&\"!\"&\"$A$2:$D$59\"),4,FALSE)","v":137500}]
["Amador",101200,73350,121450]
["Butte",91600,65950,109900]
["Calaveras",96200,76250,115450]
["Colusa",83800,65950,100550]
["Contra Costa",147900,112150,177500]
["Del Norte",83800,65950,100550]
["El Dorado",113900,85750,136700]
["Fresno",83800,65950,100550]
["Glenn",83800,65950,100550]
["Humboldt",83800,65950,100550]
["Imperial",83800,65950,100550]
["Inyo",85400,68300,102500]
["Kern",83800,65950,100550]
["Kings",83800,65950,100550]
["Lake",83800,65950,100550]
["Lassen",83800,67050,100550]
["Los Angeles",98200,100900,117850]
["Madera",83800,65950,100550]
["Marin",175000,149100,210000]
["Mariposa",83800,65950,100550]
["Mendocino",89700,68000,107650]
["Merced",83800,65950,100550]
["Modoc",83800,65950,100550]
["Mono",95800,68000,114950]
["Monterey",100400,96350,120500]
["Napa",129600,106700,155500]
["Nevada",112500,83350,135000]
["Orange",127800,114800,153350]
["Placer",113900,85750,136700]
["Plumas",83800,67050,100550]
["Riverside",94500,74550,113400]
["Sacramento",113900,85750,136700]
["San Benito",140200,89050,168250]
["San Bernardino",94500,74550,113400]
["San Diego",116800,110250,140150]
["San Francisco",175000,149100,210000]
["San Joaquin",100300,70100,120350]
["San Luis Obispo",113100,92650,135700]
["San Mateo",175000,149100,210000]
["Santa Barbara",107300,118500,128750]
["Santa Clara",181300,137100,217550]
["Santa Cruz",132800,132100,159350]
["Shasta",89800,67200,107750]
["Sierra",90000,72000,108000]
["Siskiyou",83800,65950,100550]
["Solano",112600,91500,135100]
["Sonoma",128100,100650,153700]
["Stanislaus",92600,67500,111100]
["Sutter",83800,65950,100550]
["Tehama",83800,65950,100550]
["Trinity",83800,65950,100550]
["Tulare",83800,65950,100550]
["Tuolumne",97700,70450,117250]
["Ventura",123500,106250,148200]
["Yolo",114000,83900,136800]
["Yuba",83800,65950,100550]

{"sheet":"2023","index":7,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income 2023","Low Income 2023","Moderate Income 2023"]
["Alameda",147900,112150,177500]
["Alpine",114600,76900,137500]
["Amador",101200,73350,121450]
["Butte",91600,65950,109900]
["Calaveras",96200,76250,115450]
["Colusa",83800,65950,100550]
["Contra Costa",147900,112150,177500]
["Del Norte",83800,65950,100550]
["El Dorado",113900,85750,136700]
["Fresno",83800,65950,100550]
["Glenn",83800,65950,100550]
["Humboldt",83800,65950,100550]
["Imperial",83800,65950,100550]
["Inyo",85400,68300,102500]
["Kern",83800,65950,100550]
["Kings",83800,65950,100550]
["Lake",83800,65950,100550]
["Lassen",83800,67050,100550]
["Los Angeles",98200,100900,117850]
["Madera",83800,65950,100550]
["Marin",175000,149100,210000]
["Mariposa",83800,65950,100550]
["Mendocino",89700,68000,107650]
["Merced",83800,65950,100550]
["Modoc",83800,65950,100550]
["Mono",95800,68000,114950]
["Monterey",100400,96350,120500]
["Napa",129600,106700,155500]
["Nevada",112500,83350,135000]
["Orange",127800,114800,153350]
["Placer",113900,85750,136700]
["Plumas",83800,67050,100550]
["Riverside",94500,74550,113400]
["Sacramento",113900,85750,136700]
["San Benito",140200,89050,168250]
["San Bernardino",94500,74550,113400]
["San Diego",116800,110250,140150]
["San Francisco",175000,149100,210000]
["San Joaquin",100300,70100,120350]
["San Luis Obispo",113100,92650,135700]
["San Mateo",175000,149100,210000]
["Santa Barbara",107300,118500,128750]
["Santa Clara",181300,137100,217550]
["Santa Cruz",132800,132100,159350]
["Shasta",89800,67200,107750]
["Sierra",90000,72000,108000]
["Siskiyou",83800,65950,100550]
["Solano",112600,91500,135100]
["Sonoma",128100,100650,153700]
["Stanislaus",92600,67500,111100]
["Sutter",83800,65950,100550]
["Tehama",83800,65950,100550]
["Trinity",83800,65950,100550]
["Tulare",83800,65950,100550]
["Tuolumne",97700,70450,117250]
["Ventura",123500,106250,148200]
["Yolo",114000,83900,136800]
["Yuba",83800,65950,100550]

{"sheet":"2022","index":8,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income 2022","Low Income 2022","Moderate Income 2022"]
["Alameda",142800,109600,171350]
["Alpine",94900,72650,113900]
["Amador",86600,69300,103900]
["Butte",85000,62300,102000]
["Calaveras",90000,72000,108000]
["Colusa",80300,62300,96350]
["Contra Costa",142800,109600,171350]
["Del Norte",80300,62300,96350]
["El Dorado",102200,81050,122650]
["Fresno",80300,62300,96350]
["Glenn",80300,62300,96350]
["Humboldt",80300,62300,96350]
["Imperial",80300,62300,96350]
["Inyo",82700,66150,99250]
["Kern",80300,62300,96350]
["Kings",80300,62300,96350]
["Lake",80300,62300,96350]
["Lassen",80300,64250,96350]
["Los Angeles",91100,95300,109300]
["Madera",80300,62300,96350]
["Marin",166000,149100,199200]
["Mariposa",80300,62300,96350]
["Mendocino",80300,64250,96350]
["Merced",80300,62300,96350]
["Modoc",80300,62300,96350]
["Mono",81200,64700,97450]
["Monterey",90100,91000,108100]
["Napa",119400,100750,143300]
["Nevada",98400,78700,118100]
["Orange",119100,108400,142900]
["Placer",102200,81050,122650]
["Plumas",82400,65350,98900]
["Riverside",87400,70400,104900]
["Sacramento",102200,81050,122650]
["San Benito",105100,84100,126100]
["San Bernardino",87400,70400,104900]
["San Diego",106900,104100,128300]
["San Francisco",166000,149100,199200]
["San Joaquin",85000,66200,102000]
["San Luis Obispo",109200,87500,131050]
["San Mateo",166000,149100,199200]
["Santa Barbara",100100,111900,120100]
["Santa Clara",168500,131750,202200]
["Santa Cruz",119300,124750,143150]
["Shasta",89800,63500,107750]
["Sierra",90000,72000,108000]
["Siskiyou",80300,62300,96350]
["Solano",108700,86800,130450]
["Sonoma",112800,95050,135350]
["Stanislaus",80300,63750,96350]
["Sutter",80300,62300,96350]
["Tehama",80300,62300,96350]
["Trinity",80300,62300,96350]
["Tulare",80300,62300,96350]
["Tuolumne",84300,66550,101150]
["Ventura",115400,100350,138500]
["Yolo",106600,79300,127900]
["Yuba",80300,62300,96350]

{"sheet":"2021","index":9,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income 2021","Low Income 2021","Moderate Income 2021"]
["Alameda",125600,109600,150700]
["Alpine",94900,66550,113900]
["Amador",78700,62950,94450]
["Butte",70700,56550,84850]
["Calaveras",81700,65350,98050]
["Colusa",70700,55900,84850]
["Contra Costa",125600,109600,150700]
["Del Norte",70700,55900,84850]
["El Dorado",91100,72500,109300]
["Fresno",70700,55900,84850]
["Glenn",70700,55900,84850]
["Humboldt",72000,55900,86400]
["Imperial",70700,55900,84850]
["Inyo",75100,60100,90100]
["Kern",70700,55900,84850]
["Kings",70700,55900,84850]
["Lake",70700,55900,84850]
["Lassen",72200,57750,86650]
["Los Angeles",80000,94600,96000]
["Madera",70700,55900,84850]
["Marin",149600,146350,179500]
["Mariposa",70700,55900,84850]
["Mendocino",70700,57850,84850]
["Merced",70700,55900,84850]
["Modoc",70700,55900,84850]
["Mono",81200,64700,97450]
["Monterey",81600,81350,97900]
["Napa",109200,90050,131050]
["Nevada",92400,71850,110900]
["Orange",106700,107550,128050]
["Placer",91100,72500,109300]
["Plumas",73100,58500,87700]
["Riverside",77500,63200,93000]
["Sacramento",91100,72500,109300]
["San Benito",90700,81600,108850]
["San Bernardino",77500,63200,93000]
["San Diego",95100,97000,114100]
["San Francisco",149600,146350,179500]
["San Joaquin",75000,60000,90000]
["San Luis Obispo",97800,78250,117350]
["San Mateo",149600,146350,179500]
["Santa Barbara",90100,100050,108100]
["Santa Clara",151300,117750,181550]
["Santa Cruz",111900,111500,134300]
["Shasta",70700,56800,84850]
["Sierra",84800,67600,101750]
["Siskiyou",70700,55900,84850]
["Solano",99300,77600,119150]
["Sonoma",103300,93050,123950]
["Stanislaus",70700,57050,84850]
["Sutter",75000,55900,90000]
["Tehama",70700,55900,84850]
["Trinity",70700,55900,84850]
["Tulare",70700,55900,84850]
["Tuolumne",75600,59500,90700]
["Ventura",98800,90350,118550]
["Yolo",92500,74000,111000]
["Yuba",75000,55900,90000]

{"sheet":"2020","index":10,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income 2020","Low Income 2020","Moderate Income 2020"]
["Alameda",119200,104400,143050]
["Alpine",94900,66550,113900]
["Amador",78700,62950,94450]
["Butte",70700,56550,84850]
["Calaveras",80400,64300,96500]
["Colusa",70700,55900,84850]
["Contra Costa",119200,104400,143050]
["Del Norte",70700,55900,84850]
["El Dorado",86300,69050,103550]
["Fresno",70700,55900,84850]
["Glenn",70700,55900,84850]
["Humboldt",72000,55900,86400]
["Imperial",70700,55900,84850]
["Inyo",75100,60100,90100]
["Kern",70700,55900,84850]
["Kings",70700,55900,84850]
["Lake",70700,55900,84850]
["Lassen",70700,56550,84850]
["Los Angeles",77300,90100,92750]
["Madera",70700,55900,84850]
["Marin",143100,139400,171700]
["Mariposa",70700,55900,84850]
["Mendocino",70700,55900,84850]
["Merced",70700,55900,84850]
["Modoc",70700,55900,84850]
["Mono",81200,64700,97450]
["Monterey",81600,77500,97900]
["Napa",109200,85800,131050]
["Nevada",92400,68800,110900]
["Orange",103000,102450,123600]
["Placer",86300,69050,103550]
["Plumas",72200,57750,86650]
["Riverside",75300,60250,90350]
["Sacramento",86300,69050,103550]
["San Benito",89700,81600,107650]
["San Bernardino",75300,60250,90350]
["San Diego",92700,92400,111250]
["San Francisco",143100,139400,171700]
["San Joaquin",75000,60000,90000]
["San Luis Obispo",97300,77600,116750]
["San Mateo",143100,139400,171700]
["Santa Barbara",87800,95300,105350]
["Santa Clara",141600,112150,169900]
["Santa Cruz",110000,106200,132000]
["Shasta",70700,55900,84850]
["Sierra",80500,64400,96600]
["Siskiyou",70700,55900,84850]
["Solano",95400,73950,114500]
["Sonoma",102700,90900,123250]
["Stanislaus",70700,55900,84850]
["Sutter",75000,55900,90000]
["Tehama",70700,55900,84850]
["Trinity",70700,55900,84850]
["Tulare",70700,55900,84850]
["Tuolumne",71600,56700,85900]
["Ventura",97800,90350,117350]
["Yolo",92500,74000,111000]
["Yuba",75000,55900,90000]

{"sheet":"2019","index":11,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income 2019","Low Income 2019","Moderate Income 2019"]
["Alameda",111700,98550,134050]
["Alpine",94900,65800,113900]
["Amador",73600,58900,88300]
["Butte",66500,53200,79800]
["Calaveras",75300,60250,90350]
["Colusa",64800,51850,77750]
["Contra Costa",111700,98550,134050]
["Del Norte",64800,51850,77750]
["El Dorado",83600,66900,100300]
["Fresno",64800,51850,77750]
["Glenn",64800,51850,77750]
["Humboldt",64800,51850,77750]
["Imperial",64800,51850,77750]
["Inyo",72700,58150,87250]
["Kern",64800,51850,77750]
["Kings",64800,51850,77750]
["Lake",64800,51850,77750]
["Lassen",69400,55500,83300]
["Los Angeles",73100,83500,87700]
["Madera",64800,51850,77750]
["Marin",136800,129150,164150]
["Mariposa",65500,52400,78600]
["Mendocino",64800,51850,77750]
["Merced",64800,51850,77750]
["Modoc",64800,51850,77750]
["Mono",81200,63900,97450]
["Monterey",74100,71850,88900]
["Napa",100400,79500,120500]
["Nevada",85100,63750,102100]
["Orange",97900,94950,117500]
["Placer",83600,66900,100300]
["Plumas",70700,55700,84850]
["Riverside",69700,57450,83650]
["Sacramento",83600,66900,100300]
["San Benito",84500,81600,101400]
["San Bernardino",69700,57450,83650]
["San Diego",86300,85600,103550]
["San Francisco",136800,129150,164150]
["San Joaquin",71400,56000,85700]
["San Luis Obispo",87500,71900,105000]
["San Mateo",136800,129150,164150]
["Santa Barbara",79600,88300,95500]
["Santa Clara",131400,103900,157700]
["Santa Cruz",98000,98400,117600]
["Shasta",64800,51850,77750]
["Sierra",71800,60300,86150]
["Siskiyou",64800,51850,77750]
["Solano",85700,68550,102850]
["Sonoma ",93300,86400,111950]
["Stanislaus",64800,51850,77750]
["Sutter",64800,51850,77750]
["Tehama",64800,51850,77750]
["Trinity",64800,51850,77750]
["Tulare",64800,51850,77750]
["Tuolumne",66700,53100,80050]
["Ventura",97800,83700,117350]
["Yolo",87900,70300,105500]
["Yuba",64800,51850,77750]

{"sheet":"2018","index":12,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income 2018","Low Income 2018","Moderate Income 2018"]
["Alameda",104400,89600,125300]
["Alpine",94900,65800,113900]
["Amador",73600,58900,88300]
["Butte",62600,50100,75100]
["Calaveras",72300,57850,86750]
["Colusa",59900,47900,71900]
["Contra Costa",104400,89600,125300]
["Del Norte",59900,47900,71900]
["El Dorado",80100,64100,96100]
["Fresno",59900,47900,71900]
["Glenn",59900,47900,71900]
["Humboldt",59900,47900,71900]
["Imperial",59900,47900,71900]
["Inyo",72000,57600,86400]
["Kern",59900,47900,71900]
["Kings",59900,47900,71900]
["Lake",59900,47900,71900]
["Lassen",69400,55500,83300]
["Los Angeles",69300,77500,83150]
["Madera",59900,47900,71900]
["Marin",118400,117400,142100]
["Mariposa",65500,52400,78600]
["Mendocino",60600,48700,72700]
["Merced",59900,47900,71900]
["Modoc",59900,47900,71900]
["Mono",81200,63900,97450]
["Monterey",69100,66800,82900]
["Napa",91000,74500,109200]
["Nevada",73500,61300,88200]
["Orange",92700,87450,111250]
["Placer",80100,64100,96100]
["Plumas",63300,50650,75950]
["Riverside",65800,53900,78950]
["Sacramento",80100,64100,96100]
["San Benito",81100,74550,97300]
["San Bernardino",65800,53900,78950]
["San Diego",81800,77850,98150]
["San Francisco",118400,117400,142100]
["San Joaquin",66300,53050,79550]
["San Luis Obispo",83200,66550,99850]
["San Mateo",118400,117400,142100]
["Santa Barbara",79600,80300,95500]
["Santa Clara",125200,94450,150250]
["Santa Cruz",87000,89450,104400]
["Shasta",61800,49450,74150]
["Sierra",71800,56250,86150]
["Siskiyou",59900,47900,71900]
["Solano",83700,66950,100450]
["Sonoma ",84100,78550,100900]
["Stanislaus",62000,49600,74400]
["Sutter",60000,48000,72000]
["Tehama",59900,47900,71900]
["Trinity",59900,47900,71900]
["Tulare",59900,47900,71900]
["Tuolumne",66700,53100,80050]
["Ventura",96000,81100,115200]
["Yolo",85100,66550,102100]
["Yuba",60000,48000,72000]

{"sheet":"2017","index":13,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income 2017","Low Income 2017","Moderate Income 2017"]
["Alameda",97400,80400,116900]
["Alpine",94900,65800,113900]
["Amador",72300,57850,86750]
["Butte",62600,50100,75100]
["Calaveras",70200,56150,84250]
["Colusa",59900,47900,71900]
["Contra Costa",97400,80400,116900]
["Del Norte",59900,47900,71900]
["El Dorado",76100,60900,91300]
["Fresno",59900,47900,71900]
["Glenn",59900,47900,71900]
["Humboldt",59900,47900,71900]
["Imperial",59900,47900,71900]
["Inyo",72000,57600,86400]
["Kern",59900,47900,71900]
["Kings",59900,47900,71900]
["Lake",59900,47900,71900]
["Lassen",69400,55500,83300]
["Los Angeles",64800,72100,77750]
["Madera",59900,47900,71900]
["Marin",115300,105350,138350]
["Mariposa",65500,52400,78600]
["Mendocino",59900,48700,71900]
["Merced",59900,47900,71900]
["Modoc",59900,47900,71900]
["Mono",81200,63900,97450]
["Monterey",68700,65100,82450]
["Napa",91000,74500,109200]
["Nevada",73500,61300,88200]
["Orange",88000,83450,105600]
["Placer",76100,60900,91300]
["Plumas",62600,50100,75100]
["Riverside",65000,53600,78000]
["Sacramento",76100,60900,91300]
["San Benito",81100,66900,97300]
["San Bernardino",65000,53600,78000]
["San Diego",79300,72750,95150]
["San Francisco",115300,105350,138350]
["San Joaquin",66300,53050,79550]
["San Luis Obispo",83200,65350,99850]
["San Mateo",115300,105350,138350]
["Santa Barbara",77100,72050,92500]
["Santa Clara",113300,84900,135950]
["Santa Cruz",87000,80650,104400]
["Shasta",61800,49450,74150]
["Sierra",71800,56250,86150]
["Siskiyou",59900,47900,71900]
["Solano",82600,65000,99100]
["Sonoma ",83900,70500,100700]
["Stanislaus",62000,49600,74400]
["Sutter",59900,47900,71900]
["Tehama",59900,47900,71900]
["Trinity",59900,47900,71900]
["Tulare",59900,47900,71900]
["Tuolumne",66700,53100,80050]
["Ventura",89300,79900,107150]
["Yolo",76900,61500,92300]
["Yuba",59900,47900,71900]

{"sheet":"2016","index":14,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income 2016","Low Income 2016","Moderate Income 2016"]
["Alameda",93600,75150,112300,7]
["Alpine",94900,65800,113900,{"$f":"E2+6","v":13}]
["Amador",72300,57850,86750,{"$f":"E3+6","v":19}]
["Butte",58900,47100,70700,25]
["Calaveras",70200,56150,84250,31]
["Colusa",58900,47100,70700,37]
["Contra Costa",93600,75150,112300,43]
["Del Norte",58900,47100,70700,49]
["El Dorado",76100,60900,91300,55]
["Fresno",58900,47100,70700,61]
["Glenn",58900,47100,70700,67]
["Humboldt",58900,47100,70700,73]
["Imperial",58900,47100,70700,79]
["Inyo",72000,57600,86400,85]
["Kern",58900,47100,70700,91]
["Kings",58900,47100,70700,97]
["Lake",58900,47100,70700,103]
["Lassen",69400,55500,83300,109]
["Los Angeles",64800,69450,77750,115]
["Madera",58900,47100,70700,121]
["Marin",107700,98500,129250,127]
["Mariposa",63900,51100,76700,133]
["Mendocino",58900,48700,70700,139]
["Merced",58900,47100,70700,145]
["Modoc",58900,47100,70700,151]
["Mono",81200,63900,97450,157]
["Monterey",68700,60900,82450,163]
["Napa",86100,69900,103300,169]
["Nevada",73500,61300,88200,175]
["Orange",87200,78000,104650,181]
["Placer",76100,60900,91300,187]
["Plumas",62000,49600,74400,193]
["Riverside",65000,53600,78000,199]
["Sacramento",76100,60900,91300,205]
["San Benito",81100,64400,97300,211]
["San Bernardino",65000,53600,78000,217]
["San Diego",75900,68000,91100,223]
["San Francisco",107700,98500,129250,229]
["San Joaquin",66300,53050,79550,235]
["San Luis Obispo",77100,61700,92500,241]
["San Mateo",107700,98500,129250,247]
["Santa Barbara",77100,67350,92500,253]
["Santa Clara",107100,84900,128500,259]
["Santa Cruz",87000,80650,104400,265]
["Shasta",59000,47200,70800,271]
["Sierra",71800,56250,86150,277]
["Siskiyou",58900,47100,70700,283]
["Solano",82600,65000,99100,289]
["Sonoma ",82600,65900,99100,295]
["Stanislaus",62000,49600,74400,301]
["Sutter",59400,47500,71300,307]
["Tehama",58900,47100,70700,313]
["Trinity",58900,47100,70700,319]
["Tulare",58900,47100,70700,325]
["Tuolumne",66700,53100,80050,331]
["Ventura",89300,74700,107150,337]
["Yolo",76900,61500,92300,343]
["Yuba",59400,47500,71300,349]

{"sheet":"2015","index":15,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income 2015","Low Income 2015","Moderate Income 2015"]
["Alameda",93500,71600,112200,7]
["Alpine",94900,65800,113900,{"$f":"E2+6","v":13}]
["Amador",72300,57850,86750,{"$f":"E3+6","v":19}]
["Butte",58700,46950,70450,25]
["Calaveras",70200,56150,84250,31]
["Colusa",58700,46950,70450,37]
["Contra Costa",93500,71600,112200,43]
["Del Norte",57900,46300,69500,49]
["El Dorado",76100,60900,91300,55]
["Fresno",57900,46300,69500,61]
["Glenn",57900,46300,69500,67]
["Humboldt",57900,46300,69500,73]
["Imperial",57900,46300,69500,79]
["Inyo",71500,57200,85800,85]
["Kern",57900,46300,69500,91]
["Kings",57900,46300,69500,97]
["Lake",57900,46300,69500,103]
["Lassen",69400,55500,83300,109]
["Los Angeles",64800,68300,77750,115]
["Madera",57900,46300,69500,121]
["Marin",103000,93850,123600,127]
["Mariposa",61900,49500,74300,133]
["Mendocino",58900,46400,70700,139]
["Merced",57900,46300,69500,145]
["Modoc",57900,46300,69500,151]
["Mono",81200,63900,97450,157]
["Monterey",68700,58000,82450,163]
["Napa",86100,69800,103300,169]
["Nevada",73500,61300,88200,175]
["Orange",87200,77050,104650,181]
["Placer",76100,60900,91300,187]
["Plumas",62000,49600,74400,193]
["Riverside",65000,53600,78000,199]
["Sacramento",76100,60900,91300,205]
["San Benito",81100,64400,97300,211]
["San Bernardino",65000,53600,78000,217]
["San Diego",75900,66100,91100,223]
["San Francisco",103000,93850,123600,229]
["San Joaquin",66300,53050,79550,235]
["San Luis Obispo",77100,61700,92500,241]
["San Mateo",103000,93850,123600,247]
["Santa Barbara",75400,64150,90500,253]
["Santa Clara",106300,84900,127550,259]
["Santa Cruz",87000,80650,104400,265]
["Shasta",59000,47200,70800,271]
["Sierra",71800,56250,86150,277]
["Siskiyou",57900,46300,69500,283]
["Solano",82600,65000,99100,289]
["Sonoma ",82600,65000,99100,295]
["Stanislaus",62000,49600,74400,301]
["Sutter",59400,47500,71300,307]
["Tehama",57900,46300,69500,313]
["Trinity",57900,46300,69500,319]
["Tulare",57900,46300,69500,325]
["Tuolumne",66700,53100,80050,331]
["Ventura",89300,72500,107150,337]
["Yolo",76900,61500,92300,343]
["Yuba",59400,47500,71300,349]

{"sheet":"2014","index":16,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income 2014","Low Income 2014","Moderate Income 2014"]
["Alameda",93500,67600,112200,7]
["Alpine",85000,63900,102000,{"$f":"E2+6","v":13}]
["Amador",72300,57850,86750,{"$f":"E3+6","v":19}]
["Butte",58700,46950,70450,25]
["Calaveras",70000,56000,84000,31]
["Colusa",57900,46300,69500,37]
["Contra Costa",93500,67600,112200,43]
["Del Norte",57900,46300,69500,49]
["El Dorado",76100,60900,91300,55]
["Fresno",57900,46300,69500,61]
["Glenn",57900,46300,69500,67]
["Humboldt",57900,46300,69500,73]
["Imperial",57900,46300,69500,79]
["Inyo",70900,55200,85100,85]
["Kern",57900,46300,69500,91]
["Kings",57900,46300,69500,97]
["Lake",57900,46300,69500,103]
["Lassen",68000,54300,81600,109]
["Los Angeles",64800,68300,77750,115]
["Madera",57900,46300,69500,121]
["Marin",103000,90500,123600,127]
["Mariposa",61300,49050,73550,133]
["Mendocino",57900,46300,69500,139]
["Merced",57900,46300,69500,145]
["Modoc",57900,46300,69500,151]
["Mono",81200,63900,97450,157]
["Monterey",68700,57500,82450,163]
["Napa",86100,65900,103300,169]
["Nevada",73500,58100,88200,175]
["Orange",87200,77050,104650,181]
["Placer",76100,60900,91300,187]
["Plumas",62000,49600,74400,193]
["Riverside",65000,53600,78000,199]
["Sacramento",76100,60900,91300,205]
["San Benito",81100,64400,97300,211]
["San Bernardino",65000,53600,78000,217]
["San Diego",75900,66100,91100,223]
["San Francisco",103000,90500,123600,229]
["San Joaquin",66300,53050,79550,235]
["San Luis Obispo",77000,60300,92400,241]
["San Mateo",103000,90500,123600,247]
["Santa Barbara",73300,63700,87950,253]
["Santa Clara",105500,84900,126600,259]
["Santa Cruz",87000,80650,104400,265]
["Shasta",59000,47200,70800,271]
["Sierra",71800,56250,86150,277]
["Siskiyou",57900,46300,69500,283]
["Solano",82600,65000,99100,289]
["Sonoma ",82600,65000,99100,295]
["Stanislaus",62000,49600,74400,301]
["Sutter",59400,47500,71300,307]
["Tehama",57900,46300,69500,313]
["Trinity",57900,46300,69500,319]
["Tulare",57900,46300,69500,325]
["Tuolumne",66700,53100,80050,331]
["Ventura",89300,71200,107150,337]
["Yolo",76900,61500,92300,343]
["Yuba",59400,47500,71300,349]

{"sheet":"2013","index":17,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Median Income","Lower Income","Moderate Income"]
["Alameda",93500,66250,112200]
["Alpine",85300,62250,102350]
["Amador",69200,55350,83050]
["Butte",58700,46950,70450]
["Calaveras",69700,55750,83650]
["Colusa",57900,46300,69500]
["Contra Costa",93500,66250,112200]
["Del Norte",57900,46300,69500]
["El Dorado",76100,60900,91300]
["Fresno",57900,46300,69500]
["Glenn",57900,46300,69500]
["Humboldt",57900,46300,69500]
["Imperial",57900,46300,69500]
["Inyo",65800,52650,78950]
["Kern",57900,46300,69500]
["Kings",57900,46300,69500]
["Lake",57900,46300,69500]
["Lassen",66800,51750,80150]
["Los Angeles",64800,68300,77750]
["Madera",57900,46300,69500]
["Marin",103000,90500,123600]
["Mariposa",61300,49050,73550]
["Mendocino",57900,46300,69500]
["Merced",57900,46300,69500]
["Modoc",57900,46300,69500]
["Mono",79600,62650,95500]
["Monterey",68700,57050,82450]
["Napa",86100,65750,103300]
["Nevada",72600,58100,87100]
["Orange",87200,77050,104650]
["Placer",76100,60900,91300]
["Plumas",62000,49600,74400]
["Riverside",65000,53600,78000]
["Sacramento",76100,60900,91300]
["San Benito",81100,64400,97300]
["San Bernardino",65000,53600,78000]
["San Diego",75900,66100,91100]
["San Francisco",103000,90500,123600]
["San Joaquin",66300,53050,79550]
["San Luis Obispo",75400,60300,90500]
["San Mateo",103000,90500,123600]
["Santa Barbara",73300,63700,87950]
["Santa Clara",105500,84900,126600]
["Santa Cruz",87000,80650,104400]
["Shasta",59000,47200,70800]
["Sierra",72200,56250,86650]
["Siskiyou",57900,46300,69500]
["Solano",82600,65000,99100]
["Sonoma ",82600,65000,99100]
["Stanislaus",62000,49600,74400]
["Sutter",59400,47500,71300]
["Tehama",57900,46300,69500]
["Trinity",57900,46300,69500]
["Tulare",57900,46300,69500]
["Tuolumne",66700,53100,80050]
["Ventura",89300,71200,107150]
["Yolo",76900,61500,92300]
["Yuba",59400,47500,71300]