=0 DESCRIPTION =SUBSTITUTE((UPPER(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),0,1))),"MILES","MILE") =SUBSTITUTE((UPPER(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),0,2))),"MILES","MILE") =SUBSTITUTE((UPPER(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),0,3))),"MILES","MILE") MSA DESCRIPTION =D8 =E8 =F8 =G8 =LEFT(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),1,0),4) POPULATION TOTAL HOUSEHOLDS =LEFT(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),2,0),4) =Demo_OldestDecade&" Census" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),1,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),1,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),1,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Population Summary",INDEX(Demo_Data2,0,1),0),1),1,1)),"#,##0"),"") =Demo_OldestDecade&" Census" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),1,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),1,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),1,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Household Summary",INDEX(Demo_Data2,0,1),0),1),1,1)),"#,##0"),"") =LEFT(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),4,0),4) =Demo_PriorDecade&" Census" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),2,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),2,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),2,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Population Summary",INDEX(Demo_Data2,0,1),0),1),2,1)),"#,##0"),"") =Demo_PriorDecade&" Census" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),3,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),3,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),3,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Household Summary",INDEX(Demo_Data2,0,1),0),1),3,1)),"#,##0"),"") =LEFT(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),6,0),4) =Demo_CurrentYr&" Estimate" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),4,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),4,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),4,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Population Summary",INDEX(Demo_Data2,0,1),0),1),4,1)),"#,##0"),"") =Demo_CurrentYr&" Estimate" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),5,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),5,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),5,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Household Summary",INDEX(Demo_Data2,0,1),0),1),5,1)),"#,##0"),"") =LEFT(OFFSET(FV11,Demo_RadiusRowOffset,0),4) =Demo_FutrureYear&" Projection" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),6,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),6,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),6,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Population Summary",INDEX(Demo_Data2,0,1),0),1),6,1)),"#,##0"),"") =Demo_FutrureYear&" Projection" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),7,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),7,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),7,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Household Summary",INDEX(Demo_Data2,0,1),0),1),7,1)),"#,##0"),"") =LEFT(OFFSET(FV12,Demo_RadiusRowOffset,0),4) ="Δ "&LEFT(A9,4)&"-"&LEFT(A10,4) =IFERROR((D11-D10)/D10,0) =IFERROR((E11-E10)/E10,0) =IFERROR((F11-F10)/F10,0) =IFERROR((G11-G10)/G10,0) ="Δ "&LEFT(I10,4)&"-"&LEFT(I11,4) =IFERROR((J11-J10)/J10,0) =IFERROR((K11-K10)/K10,0) =IFERROR((L11-L10)/L10,0) =IFERROR((M11-M10)/M10,0) =LEFT(OFFSET(FV14,Demo_RadiusRowOffset,0),4) ="Δ "&LEFT(A10,4)&"-"&LEFT(A11,4) =IFERROR((D12-D11)/D11,0) =IFERROR((E12-E11)/E11,0) =IFERROR((F12-F11)/F11,0) =IFERROR((G12-G11)/G11,0) ="Δ "&LEFT(I11,4)&"-"&LEFT(I12,4) =IFERROR((J12-J11)/J11,0) =IFERROR((K12-K11)/K11,0) =IFERROR((L12-L11)/L11,0) =IFERROR((M12-M11)/M11,0) =LEFT(OFFSET(FV16,Demo_RadiusRowOffset,0),4) ="Δ "&LEFT(A11,4)&"-"&LEFT(A12,4) =IFERROR((D13-D12)/D12,0) =IFERROR((E13-E12)/E12,0) =IFERROR((F13-F12)/F12,0) =IFERROR((G13-G12)/G12,0) ="Δ "&LEFT(I12,4)&"-"&LEFT(I13,4) =IFERROR((J13-J12)/J12,0) =IFERROR((K13-K12)/K12,0) =IFERROR((L13-L12)/L12,0) =IFERROR((M13-M12)/M12,0) Total Daytime Population =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),8,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),8,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Population Summary",INDEX(Demo_Data,0,1),0),1),8,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Population Summary",INDEX(Demo_Data2,0,1),0),1),8,1)),"#,##0"),"") ="HOUSEHOLDS BY INCOME ("&UPPER(C28)&")" HOUSING UNITS <$30,000 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),2,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),3,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),4,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),5,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),6,1)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),2,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),3,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),4,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),5,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),6,2)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),2,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),3,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),4,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),5,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),6,3)*100 =OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),2,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),3,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),4,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),5,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),6,1)*100 ="Total ("&C32&")" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),9,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),9,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),9,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Housing Unit Summary",INDEX(Demo_Data2,0,1),0),1),9,1)),"#,##0"),"") $30,000-74,999 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),7,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),8,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),9,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),10,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),11,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),12,1)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),7,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),8,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),9,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),10,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),11,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),12,2)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),7,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),8,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),9,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),10,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),11,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),12,3)*100 =OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),7,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),8,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),9,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),10,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),11,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),12,1)*100 Owner Occupied =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),10,1)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),10,2)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),10,3)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data2,MATCH("Housing Unit Summary",INDEX(Demo_Data2,0,1),0),1),10,1)*100,"") $75,000-99,999 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),13,1)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),13,2)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),13,3)*100 =OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),13,1)*100 Renter Occupied =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),11,1)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),11,2)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),11,3)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data2,MATCH("Housing Unit Summary",INDEX(Demo_Data2,0,1),0),1),11,1)*100,"") $100,000-124,999 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),14,1)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),14,2)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),14,3)*100 =OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),14,1)*100 Vacant Housing Units =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),12,1)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),12,2)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),12,3)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data2,MATCH("Housing Unit Summary",INDEX(Demo_Data2,0,1),0),1),12,1)*100,"") $125,000-149,999 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),15,1)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),15,2)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),15,3)*100 =OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),15,1)*100 ="Total ("&C33&")" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),13,1)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),13,2)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),13,3)),"#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Housing Unit Summary",INDEX(Demo_Data2,0,1),0),1),13,1)),"#,##0"),"") $150,000-199,999 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),16,1)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),16,2)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),16,3)*100 =OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),16,1)*100 Owner Occupied =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),14,1)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),14,2)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),14,3)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data2,MATCH("Housing Unit Summary",INDEX(Demo_Data2,0,1),0),1),14,1)*100,"") $200,000-249,999 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),17,1)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),17,2)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),17,3)*100 =OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),17,1)*100 Renter Occupied =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),15,1)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),15,2)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),15,3)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data2,MATCH("Housing Unit Summary",INDEX(Demo_Data2,0,1),0),1),15,1)*100,"") $250,000-299,999 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),18,1)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),18,2)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),18,3)*100 =OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),18,1)*100 Vacant Housing Units =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),16,1)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),16,2)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Housing Unit Summary",INDEX(Demo_Data,0,1),0),1),16,3)*100,"") =IFERROR(OFFSET(INDEX(Demo_Data2,MATCH("Housing Unit Summary",INDEX(Demo_Data2,0,1),0),1),16,1)*100,"") $300,000+ =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),19,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),20,1)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),21,1)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),19,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),20,2)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),21,2)*100 =OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),19,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),20,3)*100+OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),21,3)*100 =OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),19,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),20,1)*100+OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),21,1)*100 AVERAGE HOUSEHOLD INCOME AVERAGE HOUSEHOLD SIZE =Demo_CurrentYr&" Estimate" =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),22,1)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),22,2)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data,0,1),0),1),22,3)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Households by Income",INDEX(Demo_Data2,0,1),0),1),22,1)),"$#,##0"),"") =C12 =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),6,1),"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),6,2),"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),6,3),"") =IFERROR(OFFSET(INDEX(Demo_Data2,MATCH("Household Summary",INDEX(Demo_Data2,0,1),0),1),6,1),"") ="" ="" ="" ="" ="" =C13 =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),8,1),"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),8,2),"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Household Summary",INDEX(Demo_Data,0,1),0),1),8,3),"") =IFERROR(OFFSET(INDEX(Demo_Data2,MATCH("Household Summary",INDEX(Demo_Data2,0,1),0),1),8,1),"") ="" ="" ="" ="" ="" ="Δ "&LEFT(I28,4)&"-"&LEFT(I29,4) =IFERROR((J29-J28)/J28,0) =IFERROR((K29-K28)/K28,0) =IFERROR((L29-L28)/L28,0) =IFERROR((M29-M28)/M28,0) MEDIAN HOUSEHOLD INCOME MEDIAN HOME VALUE =C12 =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Median Household Income",INDEX(Demo_Data,0,1),0),1),1,1)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Median Household Income",INDEX(Demo_Data,0,1),0),1),1,2)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Median Household Income",INDEX(Demo_Data,0,1),0),1),1,3)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Median Household Income",INDEX(Demo_Data2,0,1),0),1),1,1)),"$#,##0"),"") =C12 =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Median Home Value",INDEX(Demo_Data,0,1),0),1),1,1),"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Median Home Value",INDEX(Demo_Data,0,1),0),1),1,2),"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Median Home Value",INDEX(Demo_Data,0,1),0),1),1,3),"") =IFERROR(OFFSET(INDEX(Demo_Data2,MATCH("Median Home Value",INDEX(Demo_Data2,0,1),0),1),1,1),"") =C13 =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Median Household Income",INDEX(Demo_Data,0,1),0),1),2,1)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Median Household Income",INDEX(Demo_Data,0,1),0),1),2,2)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Median Household Income",INDEX(Demo_Data,0,1),0),1),2,3)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Median Household Income",INDEX(Demo_Data2,0,1),0),1),2,1)),"$#,##0"),"") =C13 =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Median Home Value",INDEX(Demo_Data,0,1),0),1),2,1),"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Median Home Value",INDEX(Demo_Data,0,1),0),1),2,2),"") =IFERROR(OFFSET(INDEX(Demo_Data,MATCH("Median Home Value",INDEX(Demo_Data,0,1),0),1),2,3),"") =IFERROR(OFFSET(INDEX(Demo_Data2,MATCH("Median Home Value",INDEX(Demo_Data2,0,1),0),1),2,1),"") ="Δ "&LEFT(C32,4)&"-"&LEFT(C33,4) =IFERROR((D33-D32)/D32,0) =IFERROR((E33-E32)/E32,0) =IFERROR((F33-F32)/F32,0) =IFERROR((G33-G32)/G32,0) ="Δ "&LEFT(I32,4)&"-"&LEFT(I33,4) =IFERROR((J33-J32)/J32,0) =IFERROR((K33-K32)/K32,0) =IFERROR((L33-L32)/L32,0) =IFERROR((M33-M32)/M32,0) PER CAPITA INCOME AVERAGE HOME VALUE =C32 =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Per Capita Income",INDEX(Demo_Data,0,1),0),1),1,1)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Per Capita Income",INDEX(Demo_Data,0,1),0),1),1,2)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Per Capita Income",INDEX(Demo_Data,0,1),0),1),1,3)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Per Capita Income",INDEX(Demo_Data2,0,1),0),1),1,1)),"$#,##0"),"") =C12 =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Home Value",INDEX(Demo_Data,0,1),0),1),15,1)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Home Value",INDEX(Demo_Data,0,1),0),1),15,2)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH(Demo_CurrentYr&" Home Value",INDEX(Demo_Data,0,1),0),1),15,3)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH(Demo_CurrentYr&" Home Value",INDEX(Demo_Data2,0,1),0),1),15,1)),"$#,##0"),"") =C33 =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Per Capita Income",INDEX(Demo_Data,0,1),0),1),2,1)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Per Capita Income",INDEX(Demo_Data,0,1),0),1),2,2)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data,MATCH("Per Capita Income",INDEX(Demo_Data,0,1),0),1),2,3)),"$#,##0"),"") =IFERROR(TEXT(TRIM(OFFSET(INDEX(Demo_Data2,MATCH("Per Capita Income",INDEX(Demo_Data2,0,1),0),1),2,1)),"$#,##0"),"") ="" ="" ="" ="" ="" ="Δ "&LEFT(C36,4)&"-"&LEFT(C37,4) =IFERROR((D37-D36)/D36,0) =IFERROR((E37-E36)/E36,0) =IFERROR((F37-F36)/F36,0) =IFERROR((G37-G36)/G36,0) ="" ="" ="" ="" =""