{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["READ ME FIRST!","CUSTOM S.A. CALCULATOR","CONFORMING S.A. CALCULATOR","MASTER POPULATION LIST","SAMPLE LIST","POST SURVEY DATA SCREENING","POST SURVEY CALCULATIONS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"READ ME FIRST!","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CUSTOM S.A. CALCULATOR","index":1,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,2,0,8],[8,1,10,1],[3,1,7,1],[2,2,2,3],[2,5,2,7],[10,6,10,7],[6,5,7,7],[8,5,9,7]]}
[null,null,"Use this calculator tool if you have a custom service area which does not conform to a HUD boundary (such as a city/town corporate boundary, block group, township, or county boundary."]
[]
[null,null,"POPULATION CALCULATOR FOR CUSTOM S.A.",null,null,"SAMPLE SIZE CALCULATOR"]
[null,"Step 1: Determine population of your custom service area.","Number of Households in Service Area",null,null,"Population Size (LOWMODUNIV from Larger Geography)","Confidence Level (Defaulted to 95%)","Margin of Error +/-     (Can't be greater than 10)"]
[null,null,"LOWMODUNIV (from Larger Geography)",null,null,null,0.95,null,null,"Z-Score",1.96]
[null,null,"Est. # of Houses (Census.gov Table B11016)",null,null,"SAMPLE SIZEè",{"$f":"ROUNDUP(K11,0)","v":{"$error":"#DIV/0!"}},"çSAMPLE SIZE",null,"Population Proportion",0.5]
[null,null,"People/ Household",{"$f":"IFERROR(D5/D6, \"Enter LOWMODUNIV data and Est. # of houses.\")","v":"Enter LOWMODUNIV data and Est. # of houses."},null,"Access the American Fact Finder Housing by House Type dataset by clicking on the link in the calculation table. Use the most recent ACS 5-Year dataset available for the geography.                                                                                                                                                       ",null,null,null,"Alpha/2",{"$f":"(1-G5)/2","v":2.5000000000000022E-2},2.5000000000000001E-2]
[null,null,"Population Size",{"$f":"IFERROR(D4*D7, \"Complete fields above to yeild result.\")","v":"Complete fields above to yeild result."}]
[null,"Step 2: Determine Est. # of Households to Survey","LOWMODUNIV (from Larger Geography)",{"$f":"D5","v":0},null,"NOTE: HUD requires you to survey a minimum number of PEOPLE, not HOUSEHOLDS. The estimated # of households is just that, an estimate. It may be necessary to survey additional households on your sample list to reach the number of people to sample. You may also find that you do not need to survey all households in your sample to reach the required number of people to sample.",null,null,null,"Numerator Formula",{"$f":"(1.96^2)*(0.5*(1-0.5))/H5^2","v":{"$error":"#DIV/0!"}}]
[null,null,"Number of Households in Service Area",{"$f":"D4","v":0},null,null,null,null,null,"Denominator Formula",{"$f":"1+(1.96^2)*(0.5*(1-0.5))/(H5^2*F5)","v":{"$error":"#DIV/0!"}}]
[null,null,"Number of People to Sample",{"$f":"G6","v":{"$error":"#DIV/0!"}},null,"Est. # of Households to Survey ",{"$f":"IFERROR(D11/D7, \"Complete Step 1 and Sample Size Calculator first.\")","v":"Complete Step 1 and Sample Size Calculator first."},null,null,"Unrounded Total",{"$f":"K9/K10","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Random # Generator","https://www.random.org/sequences/"]

{"sheet":"CONFORMING S.A. CALCULATOR","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,7],[2,1,2,2],[2,4,2,6],[6,4,8,6],[9,4,10,4],[9,5,10,6]]}
[null,"Use this calculator tool if you have the service area conforms to a HUD boundary (such as a city/town corporate boundary, block group, township, or county boundary."]
[]
[null,"POPULATION CALCULATOR FOR CONFORMING SERVICE AREA",null,null,"SAMPLE SIZE CALCULATOR"]
[null,"Number of Households in Service Area",null,null,"Population Size (LOWMODUNIV for S.A.)","Confidence Level (Defaulted to 95%)","Margin of Error +/-     (Can't be greater than 10)"]
[null,"LOWMODUNIV                (from HUD Census Map)",null,null,null,0.95,null,null,"Z-Score",1.96]
[null,"People/ Household",{"$f":"IFERROR(C5/C4, \"Enter LOWMODUNIV and # of houses.\")","v":"Enter LOWMODUNIV and # of houses."},null,"SAMPLE SIZEè",{"$f":"ROUNDUP(J11,0)","v":{"$error":"#DIV/0!"}},"çSAMPLE SIZE",null,"Population Proportion",0.5]
[null,"Number of People to Sample",{"$f":"F6","v":{"$error":"#DIV/0!"}},null,"Access the American Fact Finder Housing by House Type dataset by clicking on the link in the calculation table. Use the most recent ACS dataset available, currently ACS 2021 5-year estimate (as of August 2023).                                                                                                                                                      ",null,null,null,"Alpha/2",{"$f":"(1-F5)/2","v":2.5000000000000022E-2},2.5000000000000001E-2]
[]
[null,null,null,null,null,null,null,null,"Numerator Formula",{"$f":"(1.96^2)*(0.5*(1-0.5))/G5^2","v":{"$error":"#DIV/0!"}}]
[null,"Random # Generator","https://www.random.org/sequences/",null,"Est. # of Households to Survey ",{"$f":"IFERROR(C7/C6, \"Complete Step 1 and Sample Size Calculator first.\")","v":"Complete Step 1 and Sample Size Calculator first."},null,null,"Denominator Formula",{"$f":"1+(1.96^2)*(0.5*(1-0.5))/(G5^2*E5)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Unrounded Total",{"$f":"J9/J10","v":{"$error":"#DIV/0!"}}]

{"sheet":"MASTER POPULATION LIST","index":3,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["MASTER POPULATION RANDOM SAMPLING TOOL"]
[]
["Account #/Local Identifier","Resident Name/Utility Customer","Address Line 1","Address Line 2","City","State","Zip"]

{"sheet":"SAMPLE LIST","index":4,"n_rows":203,"n_cols":17,"rows_kept":203,"cut":false,"hidden":false,"merged":[]}
["SAMPLE POPULATION LIST & CONTACT LOG"]
[]
["Survey ID","Account #/Local Identifier","Resident Name/Utility Customer","Address Line 1","Address Line 2","City","State","Zip","Random Sorting ID","Survey ID","Date Contacted","Survey Method","Responded?","Date of 2nd Attempt","Survey Method 2nd Attempt","Removed?","Reason for Removal"]
[1,null,null,null,null,null,null,null,null,1]
[2,null,null,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,null,null,3]
[4,null,null,null,null,null,null,null,null,4]
[5,null,null,null,null,null,null,null,null,5]
[6,null,null,null,null,null,null,null,null,6]
[7,null,null,null,null,null,null,null,null,7]
[8,null,null,null,null,null,null,null,null,8]
[9,null,null,null,null,null,null,null,null,9]
[10,null,null,null,null,null,null,null,null,10]
[11,null,null,null,null,null,null,null,null,11]
[12,null,null,null,null,null,null,null,null,12]
[13,null,null,null,null,null,null,null,null,13]
[14,null,null,null,null,null,null,null,null,14]
[15,null,null,null,null,null,null,null,null,15]
[16,null,null,null,null,null,null,null,null,16]
[17,null,null,null,null,null,null,null,null,17]
[18,null,null,null,null,null,null,null,null,18]
[19,null,null,null,null,null,null,null,null,19]
[20,null,null,null,null,null,null,null,null,20]
[21,null,null,null,null,null,null,null,null,21]
[22,null,null,null,null,null,null,null,null,22]
[23,null,null,null,null,null,null,null,null,23]
[24,null,null,null,null,null,null,null,null,24]
[25,null,null,null,null,null,null,null,null,25]
[26,null,null,null,null,null,null,null,null,26]
[27,null,null,null,null,null,null,null,null,27]
[28,null,null,null,null,null,null,null,null,28]
[29,null,null,null,null,null,null,null,null,29]
[30,null,null,null,null,null,null,null,null,30]
[31,null,null,null,null,null,null,null,null,31]
[32,null,null,null,null,null,null,null,null,32]
[33,null,null,null,null,null,null,null,null,33]
[34,null,null,null,null,null,null,null,null,34]
[35,null,null,null,null,null,null,null,null,35]
[36,null,null,null,null,null,null,null,null,36]
[37,null,null,null,null,null,null,null,null,37]
[38,null,null,null,null,null,null,null,null,38]
[39,null,null,null,null,null,null,null,null,39]
[40,null,null,null,null,null,null,null,null,40]
[41,null,null,null,null,null,null,null,null,41]
[42,null,null,null,null,null,null,null,null,42]
[43,null,null,null,null,null,null,null,null,43]
[44,null,null,null,null,null,null,null,null,44]
[45,null,null,null,null,null,null,null,null,45]
[46,null,null,null,null,null,null,null,null,46]
[47,null,null,null,null,null,null,null,null,47]
[48,null,null,null,null,null,null,null,null,48]
[49,null,null,null,null,null,null,null,null,49]
[50,null,null,null,null,null,null,null,null,50]
[51,null,null,null,null,null,null,null,null,51]
[52,null,null,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,null,null,55]
[56,null,null,null,null,null,null,null,null,56]
[57,null,null,null,null,null,null,null,null,57]
[58,null,null,null,null,null,null,null,null,58]
[59,null,null,null,null,null,null,null,null,59]
[60,null,null,null,null,null,null,null,null,60]
[61,null,null,null,null,null,null,null,null,61]
[62,null,null,null,null,null,null,null,null,62]
[63,null,null,null,null,null,null,null,null,63]
[64,null,null,null,null,null,null,null,null,64]
[65,null,null,null,null,null,null,null,null,65]
[66,null,null,null,null,null,null,null,null,66]
[67,null,null,null,null,null,null,null,null,67]
[68,null,null,null,null,null,null,null,null,68]
[69,null,null,null,null,null,null,null,null,69]
[70,null,null,null,null,null,null,null,null,70]
[71,null,null,null,null,null,null,null,null,71]
[72,null,null,null,null,null,null,null,null,72]
[73,null,null,null,null,null,null,null,null,73]
[74,null,null,null,null,null,null,null,null,74]
[75,null,null,null,null,null,null,null,null,75]
[76,null,null,null,null,null,null,null,null,76]
[77,null,null,null,null,null,null,null,null,77]
[78,null,null,null,null,null,null,null,null,78]
[79,null,null,null,null,null,null,null,null,79]
[80,null,null,null,null,null,null,null,null,80]
[81,null,null,null,null,null,null,null,null,81]
[82,null,null,null,null,null,null,null,null,82]
[83,null,null,null,null,null,null,null,null,83]
[84,null,null,null,null,null,null,null,null,84]
[85,null,null,null,null,null,null,null,null,85]
[86,null,null,null,null,null,null,null,null,86]
[87,null,null,null,null,null,null,null,null,87]
[88,null,null,null,null,null,null,null,null,88]
[89,null,null,null,null,null,null,null,null,89]
[90,null,null,null,null,null,null,null,null,90]
[91,null,null,null,null,null,null,null,null,91]
[92,null,null,null,null,null,null,null,null,92]
[93,null,null,null,null,null,null,null,null,93]
[94,null,null,null,null,null,null,null,null,94]
[95,null,null,null,null,null,null,null,null,95]
[96,null,null,null,null,null,null,null,null,96]
[97,null,null,null,null,null,null,null,null,97]
[98,null,null,null,null,null,null,null,null,98]
[99,null,null,null,null,null,null,null,null,99]
[100,null,null,null,null,null,null,null,null,100]
[101,null,null,null,null,null,null,null,null,101]
[102,null,null,null,null,null,null,null,null,102]
[103,null,null,null,null,null,null,null,null,103]
[104,null,null,null,null,null,null,null,null,104]
[105,null,null,null,null,null,null,null,null,105]
[106,null,null,null,null,null,null,null,null,106]
[107,null,null,null,null,null,null,null,null,107]
[108,null,null,null,null,null,null,null,null,108]
[109,null,null,null,null,null,null,null,null,109]
[110,null,null,null,null,null,null,null,null,110]
[111,null,null,null,null,null,null,null,null,111]
[112,null,null,null,null,null,null,null,null,112]
[113,null,null,null,null,null,null,null,null,113]
[114,null,null,null,null,null,null,null,null,114]
[115,null,null,null,null,null,null,null,null,115]
[116,null,null,null,null,null,null,null,null,116]
[117,null,null,null,null,null,null,null,null,117]
[118,null,null,null,null,null,null,null,null,118]
[119,null,null,null,null,null,null,null,null,119]
[120,null,null,null,null,null,null,null,null,120]
[121,null,null,null,null,null,null,null,null,121]
[122,null,null,null,null,null,null,null,null,122]
[123,null,null,null,null,null,null,null,null,123]
[124,null,null,null,null,null,null,null,null,124]
[125,null,null,null,null,null,null,null,null,125]
[126,null,null,null,null,null,null,null,null,126]
[127,null,null,null,null,null,null,null,null,127]
[128,null,null,null,null,null,null,null,null,128]
[129,null,null,null,null,null,null,null,null,129]
[130,null,null,null,null,null,null,null,null,130]
[131,null,null,null,null,null,null,null,null,131]
[132,null,null,null,null,null,null,null,null,132]
[133,null,null,null,null,null,null,null,null,133]
[134,null,null,null,null,null,null,null,null,134]
[135,null,null,null,null,null,null,null,null,135]
[136,null,null,null,null,null,null,null,null,136]
[137,null,null,null,null,null,null,null,null,137]
[138,null,null,null,null,null,null,null,null,138]
[139,null,null,null,null,null,null,null,null,139]
[140,null,null,null,null,null,null,null,null,140]
[141,null,null,null,null,null,null,null,null,141]
[142,null,null,null,null,null,null,null,null,142]
[143,null,null,null,null,null,null,null,null,143]
[144,null,null,null,null,null,null,null,null,144]
[145,null,null,null,null,null,null,null,null,145]
[146,null,null,null,null,null,null,null,null,146]
[147,null,null,null,null,null,null,null,null,147]
[148,null,null,null,null,null,null,null,null,148]
[149,null,null,null,null,null,null,null,null,149]
[150,null,null,null,null,null,null,null,null,150]
[151,null,null,null,null,null,null,null,null,151]
[152,null,null,null,null,null,null,null,null,152]
[153,null,null,null,null,null,null,null,null,153]
[154,null,null,null,null,null,null,null,null,154]
[155,null,null,null,null,null,null,null,null,155]
[156,null,null,null,null,null,null,null,null,156]
[157,null,null,null,null,null,null,null,null,157]
[158,null,null,null,null,null,null,null,null,158]
[159,null,null,null,null,null,null,null,null,159]
[160,null,null,null,null,null,null,null,null,160]
[161,null,null,null,null,null,null,null,null,161]
[162,null,null,null,null,null,null,null,null,162]
[163,null,null,null,null,null,null,null,null,163]
[164,null,null,null,null,null,null,null,null,164]
[165,null,null,null,null,null,null,null,null,165]
[166,null,null,null,null,null,null,null,null,166]
[167,null,null,null,null,null,null,null,null,167]
[168,null,null,null,null,null,null,null,null,168]
[169,null,null,null,null,null,null,null,null,169]
[170,null,null,null,null,null,null,null,null,170]
[171,null,null,null,null,null,null,null,null,171]
[172,null,null,null,null,null,null,null,null,172]
[173,null,null,null,null,null,null,null,null,173]
[174,null,null,null,null,null,null,null,null,174]
[175,null,null,null,null,null,null,null,null,175]
[176,null,null,null,null,null,null,null,null,176]
[177,null,null,null,null,null,null,null,null,177]
[178,null,null,null,null,null,null,null,null,178]
[179,null,null,null,null,null,null,null,null,179]
[180,null,null,null,null,null,null,null,null,180]
[181,null,null,null,null,null,null,null,null,181]
[182,null,null,null,null,null,null,null,null,182]
[183,null,null,null,null,null,null,null,null,183]
[184,null,null,null,null,null,null,null,null,184]
[185,null,null,null,null,null,null,null,null,185]
[186,null,null,null,null,null,null,null,null,186]
[187,null,null,null,null,null,null,null,null,187]
[188,null,null,null,null,null,null,null,null,188]
[189,null,null,null,null,null,null,null,null,189]
[190,null,null,null,null,null,null,null,null,190]
[191,null,null,null,null,null,null,null,null,191]
[192,null,null,null,null,null,null,null,null,192]
[193,null,null,null,null,null,null,null,null,193]
[194,null,null,null,null,null,null,null,null,194]
[195,null,null,null,null,null,null,null,null,195]
[196,null,null,null,null,null,null,null,null,196]
[197,null,null,null,null,null,null,null,null,197]
[198,null,null,null,null,null,null,null,null,198]
[199,null,null,null,null,null,null,null,null,199]
[200,null,null,null,null,null,null,null,null,200]

{"sheet":"POST SURVEY DATA SCREENING","index":5,"n_rows":108,"n_cols":9,"rows_kept":108,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
[]
[]
[null,"SURVEY RESPONSE AGGREGATION REPORT"]
[null,"Survey ID","Address","City","Zip","Survey Response Date","# of Persons in Family ","Mark \"X\" if ABOVE Limit","Mark \"X\" if  BELOW Limit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"COUNTIF(B5:B104,\"<>\")","v":0},null,null,null,null,{"$f":"SUM(G5:G104)","v":0},{"$f":"COUNTIF(H5:H104, \"*X*\")","v":0},{"$f":"COUNTIF(I5:I104, \"*X*\")","v":0}]
[]
[null,null,null,null,null,"Total # of Persons in families ABOVE limit",{"$f":"SUMIF(H5:H104,\"X\",G5:G104)","v":0}]
[null,null,null,null,null,"Total # of Persons in families BELOW limit",{"$f":"SUMIF(I5:I104,\"X\",G5:G104)","v":0}]

{"sheet":"POST SURVEY CALCULATIONS","index":6,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,3],[9,1,9,3],[1,1,1,3]]}
[]
[null,"LMI WORKSHEET: POST-SURVEY CALCULATIONS "]
[null,"PART A.  INFORMATION OBTAINED FROM SURVEY"]
[null,1,"Number of families in the target area"]
[null,2,"Total number of families interviewed",{"$f":"'POST SURVEY DATA SCREENING'!B105","v":0}]
[null,3,"Total number of low- and moderate income families",{"$f":"'POST SURVEY DATA SCREENING'!I105","v":0}]
[null,4,"Total number of persons living in the low- and moderate income families interviewed",{"$f":"'POST SURVEY DATA SCREENING'!G108","v":0}]
[null,5,"Total number of families interviewed in which the income was above the low- and moderate income level",{"$f":"'POST SURVEY DATA SCREENING'!H105","v":0}]
[null,6,"Total number of persons living in the families in which the income was above the low- and moderate-income level.",{"$f":"'POST SURVEY DATA SCREENING'!G107","v":0}]
[null,"PART B.  CALCULATIONS BASED ON DATA CONTAINED IN SURVEY"]
[null,7,"Average size of low- and moderate households (line 4 divided by line 3)",{"$f":"IFERROR(D7/D6, \"Complete Part A.\")","v":"Complete Part A."}]
[null,8,"Average size of non-low- and moderate households (line 6 divided by line 5)",{"$f":"IFERROR(D9/D8, \"Complete Part A.\")","v":"Complete Part A."}]
[null,9,"Proportion of families interviewed with low- and moderate income (line 3 divided by line 2)",{"$f":"IFERROR(D6/D5, \"Complete Part A.\")","v":"Complete Part A."}]
[null,10,"Proportion of families interviewed with non-low- and moderate income (line 5 divided by line 2)",{"$f":"IFERROR(D8/D5, \"Complete Part A.\")","v":"Complete Part A."}]
[null,11,"Estimate of total number of low- and moderate income families in the target area (line 1 multiplied by line 9)",{"$f":"IFERROR(D4*D13, \"No result in Line 9.\")","v":"No result in Line 9."}]
[null,12,"Estimate of total number of non-low- and moderate income families in the target area (line 1 multiplied by line 10)",{"$f":"IFERROR(D4*D14,\"No result in Line10.\")","v":"No result in Line10."}]
[null,13,"Estimate of total number of low- and moderate income persons in the target area (line 7 multiplied by line 11)",{"$f":"IFERROR(D11*D15, \"No results in Line 7 or 11.\")","v":"No results in Line 7 or 11."}]
[null,14,"Estimate of total number of non-low- and moderate income persons in the target area (line 8 multiplied by line 12)",{"$f":"IFERROR(D12*D16, \"No results in Line 8 or 12.\")","v":"No results in Line 8 or 12."}]
[null,15,"Estimate of total number of persons in the target area (line 13 added to line 14)",{"$f":"IFERROR(D17+D18, \"No results in Line 13 or 14.\")","v":"No results in Line 13 or 14."}]
[null,16,"Estimated percentage of persons in target area who have low- and moderate income (line 13 divided by line 15)",{"$f":"IFERROR(D17/D19, \"No results in Line 13 or 15.\")","v":"No results in Line 13 or 15."}]