{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","TN Housing"],"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":"Sheet1","index":0,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,14,15,19],[16,14,16,19],[6,15,6,16],[10,15,11,16],[10,17,11,18],[14,1,14,6],[15,1,15,6],[16,1,16,6],[14,7,14,12],[15,7,15,12],[16,7,16,12],[14,14,14,19],[6,2,6,3],[10,2,11,3],[10,4,11,5],[6,8,6,9],[10,8,11,9],[10,10,11,11]]}
[]
[]
[null,"Current SSA Benefit"]
[null,"80 years old"]
[]
["AGI including 1/2 of SS Pmts exceeds 25,000 (32,000 for married couple)"]
[null,"Dad","50% taxable",null,"85% taxable",null,null,"Mom","50% taxable",null,"85% taxable",null,null,null,"Combined","50% taxable",null,"85% taxable"]
["Monthly",1000,{"$f":"C9/12","v":2083.3333333333335},{"$f":"C8-(0.5*B8)","v":1583.3333333333335},{"$f":"E9/12","v":2833.3333333333335},{"$f":"E8-(0.5*B8)","v":2333.3333333333335},null,750,{"$f":"I9/12","v":2083.3333333333335},{"$f":"I8-(0.5*H8)","v":1708.3333333333335},{"$f":"K9/12","v":2833.3333333333335},{"$f":"K8-(0.5*H8)","v":2458.3333333333335},null,null,{"$f":"SUM(B8,H8)","v":1750},{"$f":"P9/12","v":2666.6666666666665},{"$f":"P8-(0.5*O8)","v":1791.6666666666665},{"$f":"R9/12","v":3666.6666666666665},{"$f":"R8-(0.5*O8)","v":2791.6666666666665}]
["Annual",{"$f":"B8*12","v":12000},25000,{"$f":"C9-(0.5*B9)","v":19000},34000,{"$f":"E9-(0.5*B9)","v":28000},null,{"$f":"H8*12","v":9000},25000,{"$f":"I9-(0.5*H9)","v":20500},34000,{"$f":"K9-(0.5*H9)","v":29500},null,null,{"$f":"SUM(B9,H9)","v":21000},32000,{"$f":"P9-(0.5*O9)","v":21500},44000,{"$f":"R9-(0.5*O9)","v":33500}]
[]
[null,null,{"$f":"TEXT((0.5*B9),\"$#,000\")&\" per year is taxable\"","v":"$6,000 per year is taxable"},null,{"$f":"TEXT((0.85*B9),\"$#,000\")&\" per year is taxable\"","v":"$10,200 per year is taxable"},null,null,null,{"$f":"TEXT((0.5*H9),\"$#,000\")&\" per year is taxable\"","v":"$4,500 per year is taxable"},null,{"$f":"TEXT((0.85*H9),\"$#,000\")&\" per year is taxable\"","v":"$7,650 per year is taxable"},null,null,null,null,{"$f":"TEXT((0.5*O9),\"$#,000\")&\" per year is taxable\"","v":"$10,500 per year is taxable"},null,{"$f":"TEXT((0.85*O9),\"$#,000\")&\" per year is taxable\"","v":"$17,850 per year is taxable"}]
[]
[]
[]
[null,"To avoid additional taxes, Dad can earn an additional $1,500 per month",null,null,null,null,null,"To avoid additional taxes, Mom can earn an additional $1,700 per month",null,null,null,null,null,null,"To avoid additional taxes, together they can earn an additional $1,700 per month"]
[null,"$6,000 of SSA benefits are taxable if he earns more than $1,500 per month",null,null,null,null,null,"$4,500 of SSA benefits are taxable if she earns more than $1,700 per month",null,null,null,null,null,null,"$4,500 of SSA benefits are taxable if she earns more than $1,700 per month"]
[null,"$10,200 of SSA benefits are taxable if he earns more than $2,8oo per month.","`",null,null,null,null,"$7,650 of SSA benefits are taxable if she earns more than $2,800 per month.","`",null,null,null,null,null,"$7,650 of SSA benefits are taxable if she earns more than $2,800 per month.","`"]
[]
[]
[]
[]
[]
[null,null,"Current SSA","Additional","Tax implications",null,null,"Taxable % of SSA"]
[{"$f":"D24/4.33","v":300.2309468822171},null,1000,1300,{"$f":"IF(D24+(0.5*C24)>2833,TEXT(0.85*C24,\"$#,000\")&\" is taxable\",IF(D24+(0.5*C24)>2083,TEXT(0.5*C24,\"$#,000\")&\" is taxable\",\"None Taxable\"))","v":"None Taxable"}]
[{"$f":"D25/4.33","v":113.16397228637413},null,750,490,{"$f":"IF(D25+(0.5*C25)>2833,TEXT(0.85*C25,\"$#,000\")&\" is taxable\",IF(D25+(0.5*C25)>2083,TEXT(0.5*C25,\"$#,000\")&\" is taxable\",\"None Taxable\"))","v":"None Taxable"}]
[null,null,{"$f":"SUM(C24:C25)","v":1750},{"$f":"SUM(D24:D25)","v":1790},{"$f":"IF(D26+(0.5*C26)>3667,TEXT(0.85*C26,\"$#,000\")&\" is taxable\",IF(D26+(0.5*C26)>2667,TEXT(0.5*C26,\"$#,000\")&\" is taxable\",\"None Taxable\"))","v":"None Taxable"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,1792]

{"sheet":"Sheet2","index":1,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,7,16,11],[19,7,19,11],[24,8,24,9],[25,8,25,9],[26,8,26,9],[0,0,0,5],[15,7,15,8],[3,7,3,11],[11,7,11,10]]}
["Housing Allowances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U3:U16)","v":3012}]
[null,1,2,3,4,5]
["County:"," Family of 1"," Family of 2"," Family of 3"," Family of 4"," Family of 5",null,null,null,null,null,null,null,null,null,null,null,null,"Family Size",2,{"$f":"INDIRECT(ADDRESS(MATCH(T4,Table2[County:],0)+3,MATCH(T3,B2:F2,0)+1))","v":1686},null,{"$f":"MATCH(T4,Table2[County:],0)","v":2}]
["Anderson",{"$f":"_xlfn.XLOOKUP(($A4&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1337},{"$f":"_xlfn.XLOOKUP(($A4&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1571},{"$f":"_xlfn.XLOOKUP(($A4&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1655},{"$f":"_xlfn.XLOOKUP(($A4&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1845},{"$f":"_xlfn.XLOOKUP(($A4&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1875},null,"National Standards: Food, Clothing and Other Items",null,null,null,null,null,null,null,null,null,null,"County","Blount",null,null,{"$f":"MATCH(T3,B2:F2,0)","v":2}]
["Blount",{"$f":"_xlfn.XLOOKUP(($A5&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1436},{"$f":"_xlfn.XLOOKUP(($A5&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1686},{"$f":"_xlfn.XLOOKUP(($A5&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1777},{"$f":"_xlfn.XLOOKUP(($A5&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1981},{"$f":"_xlfn.XLOOKUP(($A5&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":2013},null,"Expense","1 Person","2 Persons","3 Persons","4 Persons",null,null,null,null,null,null,"Cars",2,{"$f":"IF(T5=1,I19,IF(T5=2,K19,\"\"))","v":1176}]
["Bradley",{"$f":"_xlfn.XLOOKUP(($A6&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1363},{"$f":"_xlfn.XLOOKUP(($A6&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1601},{"$f":"_xlfn.XLOOKUP(($A6&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1687},{"$f":"_xlfn.XLOOKUP(($A6&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1881},{"$f":"_xlfn.XLOOKUP(($A6&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1911},null,"Food",431,779,903,1028,null,null,null,null,null,null,"Age 1",40,{"$f":"IF(T6<65,I26,I27)","v":75}]
["Cumberland",{"$f":"_xlfn.XLOOKUP(($A7&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1189},{"$f":"_xlfn.XLOOKUP(($A7&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1396},{"$f":"_xlfn.XLOOKUP(($A7&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1471},{"$f":"_xlfn.XLOOKUP(($A7&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1640},{"$f":"_xlfn.XLOOKUP(($A7&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1667},null,"Housekeeping",40,82,74,85,null,null,null,null,null,null,"Age 2",40,{"$f":"IF(T7<65,I26,I27)","v":75}]
["Davidson",{"$f":"_xlfn.XLOOKUP(($A8&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1603},{"$f":"_xlfn.XLOOKUP(($A8&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1883},{"$f":"_xlfn.XLOOKUP(($A8&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1984},{"$f":"_xlfn.XLOOKUP(($A8&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":2212},{"$f":"_xlfn.XLOOKUP(($A8&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":2248},null,"Apparel & Svc",99,161,206,279]
["DeKalb",{"$f":"_xlfn.XLOOKUP(($A9&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1211},{"$f":"_xlfn.XLOOKUP(($A9&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1423},{"$f":"_xlfn.XLOOKUP(($A9&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1499},{"$f":"_xlfn.XLOOKUP(($A9&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1671},{"$f":"_xlfn.XLOOKUP(($A9&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1698},null,"Personal care",45,82,78,96]
["Franklin",{"$f":"_xlfn.XLOOKUP(($A10&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1295},{"$f":"_xlfn.XLOOKUP(($A10&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1521},{"$f":"_xlfn.XLOOKUP(($A10&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1603},{"$f":"_xlfn.XLOOKUP(($A10&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1787},{"$f":"_xlfn.XLOOKUP(($A10&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1816},null,"Miscellaneous",170,306,349,412]
["Grundy",{"$f":"_xlfn.XLOOKUP(($A11&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1175},{"$f":"_xlfn.XLOOKUP(($A11&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1380},{"$f":"_xlfn.XLOOKUP(($A11&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1454},{"$f":"_xlfn.XLOOKUP(($A11&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1621},{"$f":"_xlfn.XLOOKUP(($A11&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1647},null,"Total",785,1410,1610,1900]
["Hamilton",{"$f":"_xlfn.XLOOKUP(($A12&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1475},{"$f":"_xlfn.XLOOKUP(($A12&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1732},{"$f":"_xlfn.XLOOKUP(($A12&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1825},{"$f":"_xlfn.XLOOKUP(($A12&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":2035},{"$f":"_xlfn.XLOOKUP(($A12&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":2068},null,"Each additional person, adds to four-person:",null,null,null,344]
["Knox",{"$f":"_xlfn.XLOOKUP(($A13&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1471},{"$f":"_xlfn.XLOOKUP(($A13&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1728},{"$f":"_xlfn.XLOOKUP(($A13&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1821},{"$f":"_xlfn.XLOOKUP(($A13&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":2030},{"$f":"_xlfn.XLOOKUP(($A13&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":2063}]
["Loudon",{"$f":"_xlfn.XLOOKUP(($A14&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1376},{"$f":"_xlfn.XLOOKUP(($A14&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1616},{"$f":"_xlfn.XLOOKUP(($A14&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1703},{"$f":"_xlfn.XLOOKUP(($A14&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1899},{"$f":"_xlfn.XLOOKUP(($A14&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1929}]
["McMinn",{"$f":"_xlfn.XLOOKUP(($A15&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1241},{"$f":"_xlfn.XLOOKUP(($A15&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1458},{"$f":"_xlfn.XLOOKUP(($A15&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1536},{"$f":"_xlfn.XLOOKUP(($A15&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1713},{"$f":"_xlfn.XLOOKUP(($A15&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1740}]
["Madison",{"$f":"_xlfn.XLOOKUP(($A16&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1366},{"$f":"_xlfn.XLOOKUP(($A16&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1604},{"$f":"_xlfn.XLOOKUP(($A16&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1690},{"$f":"_xlfn.XLOOKUP(($A16&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1884},{"$f":"_xlfn.XLOOKUP(($A16&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1915},null,"Public Transportation",null,"National ",242]
["Marion",{"$f":"_xlfn.XLOOKUP(($A17&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1281},{"$f":"_xlfn.XLOOKUP(($A17&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1504},{"$f":"_xlfn.XLOOKUP(($A17&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1585},{"$f":"_xlfn.XLOOKUP(($A17&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1767},{"$f":"_xlfn.XLOOKUP(($A17&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1796},null,"Ownership "]
["Meigs",{"$f":"_xlfn.XLOOKUP(($A18&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1247},{"$f":"_xlfn.XLOOKUP(($A18&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1464},{"$f":"_xlfn.XLOOKUP(($A18&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1543},{"$f":"_xlfn.XLOOKUP(($A18&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1720},{"$f":"_xlfn.XLOOKUP(($A18&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1748},null,null,"1 Car",null,"2 Cars"]
["Monroe",{"$f":"_xlfn.XLOOKUP(($A19&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1245},{"$f":"_xlfn.XLOOKUP(($A19&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1462},{"$f":"_xlfn.XLOOKUP(($A19&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1541},{"$f":"_xlfn.XLOOKUP(($A19&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1718},{"$f":"_xlfn.XLOOKUP(($A19&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1746},null,"National ",588,null,1176]
["Polk",{"$f":"_xlfn.XLOOKUP(($A20&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1200},{"$f":"_xlfn.XLOOKUP(($A20&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1409},{"$f":"_xlfn.XLOOKUP(($A20&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1485},{"$f":"_xlfn.XLOOKUP(($A20&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1656},{"$f":"_xlfn.XLOOKUP(($A20&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1683},null,"Operating "]
["Rhea",{"$f":"_xlfn.XLOOKUP(($A21&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1292},{"$f":"_xlfn.XLOOKUP(($A21&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1517},{"$f":"_xlfn.XLOOKUP(($A21&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1599},{"$f":"_xlfn.XLOOKUP(($A21&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1783},{"$f":"_xlfn.XLOOKUP(($A21&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1812},null,"South Region",267,null,534]
["Roane",{"$f":"_xlfn.XLOOKUP(($A22&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1364},{"$f":"_xlfn.XLOOKUP(($A22&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1602},{"$f":"_xlfn.XLOOKUP(($A22&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1688},{"$f":"_xlfn.XLOOKUP(($A22&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1882},{"$f":"_xlfn.XLOOKUP(($A22&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1913}]
["Rutherford",{"$f":"_xlfn.XLOOKUP(($A23&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1542},{"$f":"_xlfn.XLOOKUP(($A23&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1812},{"$f":"_xlfn.XLOOKUP(($A23&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1909},{"$f":"_xlfn.XLOOKUP(($A23&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":2129},{"$f":"_xlfn.XLOOKUP(($A23&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":2163}]
["Sequatchie",{"$f":"_xlfn.XLOOKUP(($A24&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1286},{"$f":"_xlfn.XLOOKUP(($A24&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1510},{"$f":"_xlfn.XLOOKUP(($A24&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1591},{"$f":"_xlfn.XLOOKUP(($A24&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1774},{"$f":"_xlfn.XLOOKUP(($A24&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1803}]
["Sevier",{"$f":"_xlfn.XLOOKUP(($A25&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1346},{"$f":"_xlfn.XLOOKUP(($A25&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1581},{"$f":"_xlfn.XLOOKUP(($A25&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1666},{"$f":"_xlfn.XLOOKUP(($A25&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1858},{"$f":"_xlfn.XLOOKUP(($A25&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1888},null,"Age","Out of Pocket"]
["Shelby",{"$f":"_xlfn.XLOOKUP(($A26&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1557},{"$f":"_xlfn.XLOOKUP(($A26&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1829},{"$f":"_xlfn.XLOOKUP(($A26&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1927},{"$f":"_xlfn.XLOOKUP(($A26&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":2149},{"$f":"_xlfn.XLOOKUP(($A26&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":2183},null,"Under 65",75]
["Union",{"$f":"_xlfn.XLOOKUP(($A27&\" County\"),TNHousing[County],TNHousing[[ Family of 1]],\"not found\")","v":1252},{"$f":"_xlfn.XLOOKUP(($A27&\" County\"),TNHousing[County],TNHousing[[ Family of 2]],\"not found\")","v":1470},{"$f":"_xlfn.XLOOKUP(($A27&\" County\"),TNHousing[County],TNHousing[[ Family of 3]],\"not found\")","v":1549},{"$f":"_xlfn.XLOOKUP(($A27&\" County\"),TNHousing[County],TNHousing[[ Family of 4]],\"not found\")","v":1727},{"$f":"_xlfn.XLOOKUP(($A27&\" County\"),TNHousing[County],TNHousing[[ Family of 5]],\"not found\")","v":1755},null,"65 and Older",153]

{"sheet":"TN Housing","index":2,"n_rows":96,"n_cols":6,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
["County"," Family of 1"," Family of 2"," Family of 3"," Family of 4"," Family of 5"]
["Anderson County",1337,1571,1655,1845,1875]
["Bedford County",1295,1521,1603,1787,1816]
["Benton County",1125,1321,1392,1552,1577]
["Bledsoe County",1186,1393,1468,1637,1663]
["Blount County",1436,1686,1777,1981,2013]
["Bradley County",1363,1601,1687,1881,1911]
["Campbell County",1179,1385,1459,1627,1653]
["Cannon County",1308,1536,1619,1805,1834]
["Carroll County",1127,1324,1395,1555,1581]
["Carter County",1154,1355,1428,1592,1618]
["Cheatham County",1490,1750,1844,2056,2089]
["Chester County",1249,1467,1546,1724,1752]
["Claiborne County",1122,1318,1389,1549,1574]
["Clay County",1155,1357,1430,1594,1620]
["Cocke County",1148,1349,1421,1584,1610]
["Coffee County",1314,1543,1626,1813,1842]
["Crockett County",1193,1402,1477,1647,1673]
["Cumberland County",1189,1396,1471,1640,1667]
["Davidson County",1603,1883,1984,2212,2248]
["Decatur County",1226,1440,1517,1691,1719]
["DeKalb County",1211,1423,1499,1671,1698]
["Dickson County",1375,1615,1702,1898,1928]
["Dyer County",1231,1446,1524,1699,1727]
["Fayette County",1564,1837,1936,2159,2193]
["Fentress County",1096,1288,1357,1513,1537]
["Franklin County",1295,1521,1603,1787,1816]
["Gibson County",1274,1497,1577,1758,1787]
["Giles County",1289,1514,1595,1778,1807]
["Grainger County",1206,1416,1492,1664,1690]
["Greene County",1185,1391,1466,1635,1661]
["Grundy County",1175,1380,1454,1621,1647]
["Hamblen County",1210,1422,1498,1670,1697]
["Hamilton County",1475,1732,1825,2035,2068]
["Hancock County",1084,1273,1341,1495,1519]
["Hardeman County",1206,1416,1492,1664,1690]
["Hardin County",1128,1325,1396,1557,1582]
["Hawkins County",1218,1431,1508,1681,1709]
["Haywood County",1207,1418,1494,1666,1693]
["Henderson County",1180,1386,1460,1628,1654]
["Henry County",1149,1349,1422,1586,1611]
["Hickman County",1249,1467,1546,1724,1752]
["Houston County",1286,1510,1591,1774,1803]
["Humphreys County",1204,1414,1490,1661,1688]
["Jackson County",1139,1338,1410,1572,1598]
["Jefferson County",1290,1516,1597,1781,1809]
["Johnson County",1141,1340,1412,1574,1600]
["Knox County",1471,1728,1821,2030,2063]
["Lake County",1093,1284,1353,1509,1533]
["Lauderdale County",1175,1380,1454,1621,1647]
["Lawrence County",1216,1428,1505,1678,1705]
["Lewis County",1212,1424,1500,1673,1700]
["Lincoln County",1333,1566,1650,1840,1869]
["Loudon County",1376,1616,1703,1899,1929]
["McMinn County",1241,1458,1536,1713,1740]
["McNairy County",1188,1395,1470,1639,1666]
["Macon County",1175,1380,1454,1621,1647]
["Madison County",1366,1604,1690,1884,1915]
["Marion County",1281,1504,1585,1767,1796]
["Marshall County",1332,1564,1648,1838,1867]
["Maury County",1441,1693,1784,1989,2021]
["Meigs County",1247,1464,1543,1720,1748]
["Monroe County",1245,1462,1541,1718,1746]
["Montgomery County",1425,1673,1763,1966,1997]
["Moore County",1477,1735,1828,2038,2071]
["Morgan County",1201,1411,1487,1658,1685]
["Obion County",1152,1353,1426,1590,1616]
["Overton County",1178,1384,1458,1626,1652]
["Perry County",1113,1308,1378,1536,1561]
["Pickett County",1039,1220,1286,1434,1457]
["Polk County",1200,1409,1485,1656,1683]
["Putnam County",1339,1572,1657,1848,1877]
["Rhea County",1292,1517,1599,1783,1812]
["Roane County",1364,1602,1688,1882,1913]
["Robertson County",1508,1771,1866,2081,2114]
["Rutherford County",1542,1812,1909,2129,2163]
["Scott County",1139,1338,1410,1572,1598]
["Sequatchie County",1286,1510,1591,1774,1803]
["Sevier County",1346,1581,1666,1858,1888]
["Shelby County",1557,1829,1927,2149,2183]
["Smith County",1354,1591,1676,1869,1899]
["Stewart County",1362,1600,1686,1880,1910]
["Sullivan County",1244,1461,1540,1717,1745]
["Sumner County",1636,1922,2025,2258,2294]
["Tipton County",1451,1704,1796,2003,2035]
["Trousdale County",1354,1591,1676,1869,1899]
["Unicoi County",1180,1386,1460,1628,1654]
["Union County",1252,1470,1549,1727,1755]
["Van Buren County",1171,1375,1449,1616,1642]
["Warren County",1132,1330,1401,1562,1587]
["Washington County",1371,1610,1697,1892,1923]
["Wayne County",1115,1310,1380,1539,1564]
["Weakley County",1143,1343,1415,1578,1603]
["White County",1149,1349,1422,1586,1611]
["Williamson County",2271,2668,2811,3134,3185]
["Wilson County",1748,2053,2163,2412,2451]