{"text_format":"3","workbook":"xlsx","n_sheets":20,"sheets":["Form 1A Census","Form 1A Census Ex.","Form 1B Random","Form 1B Random Ex.","Form 2","Form 2 Ex.","Form 3","Form 3 Ex.","Form 4","Form 4 Ex.","Form 5","Form 5 Ex.","Form 6 Part 1-2","Form 6 Part 3","Form 6 Part 1-2 Ex.","Form 6 Part 3Ex.","Form 7","Form 7 Ex.","Form 8","Form 8 Ex."],"not_rendered":{"images":2,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Form 1A Census","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"merged":[[0,0,0,2]]}
["(FORM 1A)  Census Survey: Income Survey Results Income Tabulation Form"]
[]
["Instructions:  Complete the yellow highlighted cells below.  Select only one option for Entry #16."]
[]
["Municipality:                                                                                                 "]
[null,"Survey Start Date (date first survey was conducted/distributed):                                          "]
[null,"Survey Completion Date (date last survey was conducted/collected):                  "]
[]
["Entry #:"]
[1,"Number of families in the project service area.  [All families in the service area must be given the opportunity to complete the survey for a Census Survey.  Refer to the “Families in the Service Area” section in the Income Survey Guide for guidance on estimating and determining the number of families in a project service area.]"]
[2,"Minimum number of families needed to respond to meet HUD Margin of Error (MOE) standard.  [Refer to the “Margin of Error/Response Rate” section in the Income Survey Guide for guidance on meeting applicable HUD Margin of Error standard.]"]
[3,"Number of families that completed a survey (i.e., survey respondents).  [calculate using survey responses]"]
[4,"Maximum Margin of Error (MOE) for Survey Allowed.  [Refer to \"Margin of Error/Response Rate\" section of Income Survey Guide for guidance in determining maximum MOE allowed.]","+/- "]
[5,"Actual Margin of Error (MOE) of Survey.  [Refer to \"Margin of Error/Response Rate\" section of Income Survey Guide for guidance on using SurveyMonkey.com to determine MOE.]","+/- "]
[6,"Number of LMI families among survey respondents.  [calculate using survey responses]"]
[7,"Number of LMI persons among survey respondents (this number is also considered the total number of LMI persons living in the project service area).  [calculate using survey responses]"]
[8,"Average size of LMI families in sample/among respondents.  [value of Entry 7 divided by value of Entry 6]",{"$f":"C16/C15","v":{"$error":"#DIV/0!"}}]
[9,"Number of Non-LMI families among survey respondents.  [calculate using survey responses]"]
[10,"Number of Non-LMI persons among survey respondents.  [calculate using survey responses]"]
[11,"Average size of Non-LMI families in sample/among respondents.  [value of Entry 10 divided by value of Entry 9]",{"$f":"C19/C18","v":{"$error":"#DIV/0!"}}]
[12,"Number of all persons in all families among survey respondents.  [value of Entry 7 + Entry 10]",{"$f":"C16+C19","v":0}]
[13,"Average family size among all survey respondents.  [value of Entry 12 divided by value of Entry 3]",{"$f":"C21/C12","v":{"$error":"#DIV/0!"}}]
[14,"Number of non-responding families (families that did not return survey or returned invalid survey).  [value of Entry 1 minus value of Entry 3]",{"$f":"C10-C12","v":0}]
[15,"Estimated number of persons in non-responding families.  [value of Entry 13 multiplied by value of Entry 14 rounded to nearest whole number]",{"$f":"C22*C23","v":{"$error":"#DIV/0!"}}]
[16,"Number of persons living in the Service Area (i.e., Service Area population).  [Enter the exact population if known (i.e., if a 100% survey response rate was achieved) for 16(a) Option 1 below.  If the survey response rate was less than 100%, then the population must be estimated.  Refer to the “Tabulating Survey Results” section in the Income Survey Guide and the items below for guidance on estimating population.  Select one of the methods below for estimating the population.]","Enter number in cell below corresponding to Method/ Option used to determine or estimate population:"]
["16(a)","Option 1 - Exact/Known:  Exact population based on 100% survey responses.  [value of Entry 12]  "]
["16(b)","Option 2 - Estimate:  STANDARD Calculated estimate by multiplying the average family size of survey respondents by the number of all families in the service area.  [value of Entry 1 multiplied by value of Entry 13]."]
["16(c)","Option 3 - Estimate:  Calculated estimate by adding the estimated number of persons in non-responding families to the number of persons in responding families.  [value of Entry 12 + Entry 15] -- May be appropriate option when the average family size of the LMI families varies signficantly from the average family size of the non-LMI families among survey respondents."]
["16(d)","Option 4 - Estimate:  Total population based on the most recent U.S. Census American Community Survey 5-Year Estimates data available and in effect at the time of the survey distribution end date. [May be considered/allowed for service areas that are community-wide, contingent upon being approved by DEHCR as methodologically sound prior to application, upon review of survey response data.  Typically Option 2 or Option 3 above using survey data to estimate the population in the income survey tabulation is more methodologically sound.]"]
["16(e)","Option 5 - Estimate:  Total population based on HUD LMISD for local government(s) and/or census block group(s)/tracts(s).  [May be considered/allowed for service areas for which HUD LMISD are available, contingent upon being approved by DEHCR as methodologically sound prior to CDBG application, upon review of survey response data. Typically Option 2 or Option 3 above using survey data to estimate the population in the income survey tabulation is more methodologically sound.]"]
["16(f)","Option 6 - Estimate:  OTHER - CONTACT DEHCR.  [An alternative method may be considered/used to adjust for the statistical impact of significant outliers and/or data anomalies if pre-approved by DEHCR prior to final submission to DEHCR.  Contact DEHCR for guidance on other options for calculating population to adjust for the statistical impact of significant outliers and/or data anomalies.]"]
[17,"LMI Percentage for Service Area/Survey Area  [value of Entry 7 divided by the population number entered for the value in Entry 16; then multiplied by 100]  This value must be at least 51.00% for the Service Area/Survey Area to meet the LMI National Objective.",{"$f":"(C16/C27)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Form 1A Census Ex.","index":1,"n_rows":31,"n_cols":3,"rows_kept":31,"merged":[[0,0,0,2]]}
["(FORM 1A EXAMPLE)  Census Survey: Income Survey Results Income Tabulation Form"]
[]
["Instructions:  Complete the yellow highlighted cells below.  Select only one option for Entry #16."]
[]
["Municipality:                                                                                                 ","Village of Yourville"]
[null,"Survey Start Date (date first survey was conducted/distributed):                                          ","2019-11-15"]
[null,"Survey Completion Date (date last survey was conducted/collected):                  ","2020-01-24"]
["Entry #:"]
[1,"Number of families in the project service area.  [All families in the service area must be given the opportunity to complete the survey for a Census Survey.  Refer to the “Families in the Service Area” section in the Income Survey Guide for guidance on estimating and determining the number of families in a project service area.]",100]
[2,"Minimum number of families needed to respond to meet HUD Margin of Error (MOE) standard.  [Refer to the “Margin of Error/Response Rate” section in the Income Survey Guide for guidance on meeting applicable HUD Margin of Error standard.]",41]
[3,"Number of families that completed a survey (i.e., survey respondents).  [calculate using survey responses]",75]
[4,"Maximum Margin of Error (MOE) for Survey Allowed.  [Refer to \"Margin of Error/Response Rate\" section of Income Survey Guide for guidance in determining maximum MOE allowed.]","+/- 10.00"]
[5,"Actual Margin of Error (MOE) of Survey.  [Refer to \"Margin of Error/Response Rate\" section of Income Survey Guide for guidance on using SurveyMonkey.com to determine MOE.]","+/- 4.76"]
[6,"Number of LMI families among survey respondents.  [calculate using survey responses]",52]
[7,"Number of LMI persons among survey respondents (this number is also considered the total number of LMI persons living in the project service area).  [calculate using survey responses]",135]
[8,"Average size of LMI families in sample/among respondents.  [value of Entry 7 divided by value of Entry 6]",{"$f":"C15/C14","v":{"v":2.5961538461538463,"d":"2.60"}}]
[9,"Number of Non-LMI families among survey respondents.  [calculate using survey responses]",23]
[10,"Number of Non-LMI persons among survey respondents.  [calculate using survey responses]",40]
[11,"Average size of Non-LMI families in sample/among respondents.  [value of Entry 10 divided by value of Entry 9]",{"$f":"C18/C17","v":{"v":1.7391304347826086,"d":"1.74"}}]
[12,"Number of all persons in all families among survey respondents.  [value of Entry 7 + Entry 10]",{"$f":"C15+C18","v":175}]
[13,"Average family size among all survey respondents.  [value of Entry 12 divided by value of Entry 3]",{"$f":"C20/C11","v":{"v":2.3333333333333335,"d":"2.33"}}]
[14,"Number of non-responding families (families that did not return survey or returned invalid survey).  [value of Entry 1 minus value of Entry 3]",{"$f":"C9-C11","v":25}]
[15,"Estimated number of persons in non-responding families.  [value of Entry 13 multiplied by value of Entry 14 rounded to nearest whole number]",{"$f":"C21*C22","v":{"v":58.333333333333336,"d":"58"}}]
[16,"Number of persons living in the Service Area (i.e., Service Area population).  [Enter the exact population if known (i.e., if a 100% survey response rate was achieved) for 16(a) Option 1 below.  If the survey response rate was less than 100%, then the population must be estimated.  Refer to the “Tabulating Survey Results” section in the Income Survey Guide and the items below for guidance on estimating population.  Select one of the methods below for estimating the population.]","Enter number in cell below corresponding to Method/Option used to determine or estimate population:"]
["16(a)","Option 1 - Exact/Known:  Exact population based on 100% survey responses.  [value of Entry 12]  "]
["16(b)","Option 2 - Estimate:  STANDARD Calculated estimate by multiplying the average family size of survey respondents by the number of all families in the service area.  [value of Entry 1 multiplied by value of Entry 13].",{"$f":"C9*C21","v":{"v":233.33333333333334,"d":"233"}}]
["16(c)","Option 3 - Estimate:  Calculated estimate by adding the estimated number of persons in non-responding families to the number of persons in responding families.  [value of Entry 12 + Entry 15] -- May be appropriate option when the average family size of the LMI families varies signficantly from the average family size of the non-LMI families among survey respondents."]
["16(d)","Option 4 - Estimate:  Total population based on the most recent U.S. Census American Community Survey 5-Year Estimates data available and in effect at the time of the survey distribution end date. [May be considered/allowed for service areas that are community-wide, contingent upon being approved by DEHCR as methodologically sound prior to application, upon review of survey response data.  Typically Option 2 or Option 3 above using survey data to estimate the population in the income survey tabulation is more methodologically sound.]"]
["16(e)","Option 5 - Estimate:  Total population based on HUD LMISD for local government(s) and/or census block group(s)/tracts(s).  [May be considered/allowed for service areas for which HUD LMISD are available, contingent upon being approved by DEHCR as methodologically sound prior to CDBG application, upon review of survey response data. Typically Option 2 or Option 3 above using survey data to estimate the population in the income survey tabulation is more methodologically sound.]"]
["16(f)","Option 6 - Estimate:  OTHER - CONTACT DEHCR.  [An alternative method may be considered/used to adjust for the statistical impact of significant outliers and/or data anomalies if pre-approved by DEHCR prior to final submission to DEHCR.  Contact DEHCR for guidance on other options for calculating population to adjust for the statistical impact of significant outliers and/or data anomalies.]"]
[17,"LMI Percentage for Service Area/Survey Area  [value of Entry 7 divided by the population number entered for the value in Entry 16; then multiplied by 100]  This value must be at least 51.00% for the Service Area/Survey Area to meet the LMI National Objective.",{"$f":"(C15/C26)","v":{"v":0.5785714285714285,"d":"57.86%"}}]

{"sheet":"Form 1B Random","index":2,"n_rows":33,"n_cols":3,"rows_kept":33,"merged":[[0,0,0,2]]}
["(FORM 1B)  Random Sample Survey: Income Survey Results Income Tabulation Form"]
[]
["Instructions:  Complete the yellow highlighted cells below.  Select only one option for Entry #18."]
[]
["Municipality:                                                                                                 "]
[null,"Survey Start Date (date first survey was conducted/distributed):                                          "]
[null,"Survey Completion Date (date last survey was conducted/collected):                  "]
[]
["Entry #:"]
[1,"Number of families in the Service Area.  [Refer to the “Families in the Service Area” section in this Income Survey Guide for guidance on estimating and determining the number of families in a Service Area.] "]
[2,"Sample Size. (i.e., number of families needed to respond to meet HUD Margin of Error (MOE) standard).  [Refer to the “Margin of Error/Response Rate” section in the Income Survey Guide for guidance on meeting applicable HUD Margin of Error standard.]"]
[3,"Number of families in randomized sample (i.e., number of families to which the survey was distributed).  [Refer to the “Random Sample Survey” section in the Income Survey Guide to review the terms for oversampling for a randomized sample survey (value of Entry 3 cannot exceed: value of Entry 2 multiplied by 1.20).]"]
[4,"Margin of Error (MOE) required.  [Refer to \"Margin of Error/Response Rate\" section of Income Survey Guide for guidance in determining the MOE standard that must be met.]"]
[5,"Number of families that responded [Must equal value of Entry 2.  Do not count responses in Oversample that were not needed - only use Oversample responses to reach the Sample Size number in Line 2 required and replace non-respondents from the Original Sample with respondents from the Oversample using random sample survey methodology in selecting replacements.  Refer to the \"Random Sample Section\" of the Income Survey Guide for guidance.]"]
[6,"Actual Margin of Error (MOE) of Survey.  [Refer to \"Margin of Error/Response Rate\" section of Income Survey Guide for guidance on using SurveyMonkey.com to determine MOE.]"]
[7,"Number of LMI families among survey respondents.  [calculate using survey responses]"]
[8,"Number of LMI persons among survey respondents.  [calculate using survey responses]"]
[9,"Average size of LMI families in sample/among survey respondents.  [value of Entry 8 divided by value of Entry 7]",{"$f":"C17/C16","v":{"$error":"#DIV/0!"}}]
[10,"Number of Non-LMI families among survey respondents.  [calculate using survey responses]"]
[11,"Number of Non-LMI persons among survey respondents.  [calculate using survey responses]"]
[12,"Average size of Non-LMI families in sample/among respondents.  [value of Entry 11 divided by value of Entry 10]",{"$f":"C20/C19","v":{"$error":"#DIV/0!"}}]
[13,"Number of all persons in all families among survey respondents.  [value of Entry 8 + Entry 11]",{"$f":"C17+C20","v":0}]
[14,"Average family size among all survey respondents.  [value of Entry 13 divided by value of Entry 5]",{"$f":"C22/C14","v":{"$error":"#DIV/0!"}}]
[15," LMI ratio of sample/respondents.  [value of Entry 8 divided by value of Entry 13]",{"$f":"C17/C22","v":{"$error":"#DIV/0!"}}]
[16,"Non-LMI ratio of sample/respondents.  [value of Entry 11 divided by value of Entry 13]",{"$f":"C20/C22","v":{"$error":"#DIV/0!"}}]
[17,"Estimated LMI Percentage for Service Area/Survey Area (percentage of LMI persons in the project service area).  [value of Entry 15 mulitiplied by 100.  The LMI percentage of survey sample is applied to the entire service area population when the Random Sample Survey methodology is used.  The percentage must be at least 51.00 to meet the LMI National Objective.]",{"$f":"C24*100","v":{"$error":"#DIV/0!"}}]
[18,"Number of persons living in the Service Area (i.e., Service Area population).   For all Random Sample Surveys, the total population of the Service Area must be estimated.  Refer to the “Tabulating Survey Results” section in the Income Survey Guide and the items below for guidance on estimating population.  Select one of the methods below to estimate the population.","Enter number in cell below corresponding to Method/ Option used to determine or estimate population:"]
["18(a)"," Option 1:  STANDARD:  Calculated estimate using survey data - Method 1:  [value of Entry 1 multiplied by value of Entry 14; then rounded to nearest whole number]"]
["18(b)"," Option 2:  Calculated estimate using survey data - Method 2:  May be used to reduce the statistical impact of outliers.  [(value of Entry 1 multiplied by Entry 15, and then multiplied by Entry 9) added to (value of Entry 1 multiplied by Entry 16 and then multiplied by Entry 12); then rounded to nearest whole number]"]
["18(c)","Option 3:  Total population based on the most recent U.S. Census American Community Survey 5-Year Estimates data.  [Allowed for service areas that are community-wide, contingent upon being pre-approved by DEHCR as methodologically sound for the service area population calculation prior to CDBG application.]"]
["18(d)","Option 4:  Total population based on HUD LMISD for local government(s) and/or census block group(s)/tracts(s).  [Allowed for service areas for which HUD LMISD are available, contingent upon being pre-approved by DEHCR as methodologically sound for the service area population calculation prior to CDBG application.]"]
["18(e)","Option 5:  OTHER - CONTACT DEHCR  [An alternative method may be considered/used if pre-approved by DEHCR prior to CDBG application.  Contact DEHCR for guidance on other options for calculating population to adjust for the statistical impact of significant outliers and/or data anomalies.]"]
[19,"Estimated total number of LMI persons in the project service area.  [value of Entry 18 multiplied by value of Entry 15; then rounded to the nearest whole number]",{"$f":"(SUM(C28:C32))*C24","v":{"$error":"#DIV/0!"}}]

{"sheet":"Form 1B Random Ex.","index":3,"n_rows":33,"n_cols":3,"rows_kept":33,"merged":[[0,0,0,2]]}
["(FORM 1B EXAMPLE)  Random Sample Survey: Income Survey Results Income Tabulation Form"]
[]
["Instructions:  Complete the yellow highlighted cells below.  Select only one option for Entry #18."]
[]
["Municipality:                                                                                                 ","Village of Yourville"]
[null,"Survey Start Date (date first survey was conducted/distributed):                                          ","2019-11-15"]
[null,"Survey Completion Date (date last survey was conducted/collected):                  ","2020-01-24"]
[]
["Entry #:"]
[1,"Number of families in the Service Area.  [Refer to the “Families in the Service Area” section in this Income Survey Guide for guidance on estimating and determining the number of families in a Service Area.] ",1000]
[2,"Sample Size. (i.e., number of families needed to respond to meet HUD Margin of Error (MOE) standard).  [Refer to the “Margin of Error/Response Rate” section in the Income Survey Guide for guidance on meeting applicable HUD Margin of Error standard.]",280]
[3,"Number of families in randomized sample (i.e., number of families to which the survey was distributed).  [Refer to the “Random Sample Survey” section in the Income Survey Guide to review the terms for oversampling for a randomized sample survey (value of Entry 3 cannot exceed: value of Entry 2 multiplied by 1.20).]",336]
[4,"Margin of Error (MOE) required.  [Refer to \"Margin of Error/Response Rate\" section of Income Survey Guide for guidance in determining the MOE standard that must be met.]","+/- 4.67"]
[5,"Number of families that responded  [Must equal value of Entry 2.  Do not count responses in Oversample that were not needed - only use Oversample responses to reach the Sample Size number in Line 2 required and replace non-respondents from the Original Sample with respondents from the Oversample using random sample survey methodology in selecting replacements.  Refer to the \"Random Sample Section\" of the Income Survey Guide for guidance.]",280]
[6,"Actual Margin of Error (MOE) of Survey.  [Refer to \"Margin of Error/Response Rate\" section of Income Survey Guide for guidance on using SurveyMonkey.com to determine MOE.]","+/- 4.67"]
[7,"Number of LMI families among survey respondents.  [calculate using survey responses]",131]
[8,"Number of LMI persons among survey respondents.  [calculate using survey responses]",352]
[9,"Average size of LMI families in sample/among survey respondents.  [value of Entry 8 divided by value of Entry 7]",{"$f":"C17/C16","v":{"v":2.687022900763359,"d":"2.69"}}]
[10,"Number of Non-LMI families among survey respondents.  [calculate using survey responses]",149]
[11,"Number of Non-LMI persons among survey respondents.  [calculate using survey responses]",303]
[12,"Average size of Non-LMI families in sample/among respondents.  [value of Entry 11 divided by value of Entry 10]",{"$f":"C20/C19","v":{"v":2.033557046979866,"d":"2.03"}}]
[13,"Number of all persons in all families among survey respondents.  [value of Entry 8 + Entry 11]",{"$f":"C17+C20","v":655}]
[14,"Average family size among all survey respondents.  [value of Entry 13 divided by value of Entry 5]",{"$f":"C22/C14","v":{"v":2.3392857142857144,"d":"2.34"}}]
[15," LMI ratio of sample/respondents.  [value of Entry 8 divided by value of Entry 13]",{"$f":"C17/C22","v":{"v":0.5374045801526718,"d":"0.5374"}}]
[16,"Non-LMI ratio of sample/respondents.  [value of Entry 11 divided by value of Entry 13]",{"$f":"C20/C22","v":{"v":0.46259541984732827,"d":"0.4626"}}]
[17,"Estimated LMI Percentage for Service Area/Survey Area (percentage of LMI persons in the project service area).  [value of Entry 15 mulitiplied by 100.  The LMI percentage of survey sample is applied to the entire service area population when the Random Sample Survey methodology is used.  The percentage must be at least 51.00 to meet the LMI National Objective.]",{"$f":"C24*100","v":{"v":53.74045801526718,"d":"53.74"}}]
[18,"Number of persons living in the Service Area (i.e., Service Area population)   For all Random Sample Surveys, the total population of the Service Area must be estimated.  Refer to the “Tabulating Survey Results” section in the Income Survey Guide and the items below for guidance on estimating population.  Select one of the methods below to estimate the population.","Enter number in cell below corresponding to Method/Option used to determine or estimate population:"]
["18(a)"," Option 1:  STANDARD:  Calculated estimate using survey data - Method 1:  [value of Entry 1 multiplied by value of Entry 14; then rounded to nearest whole number]"]
["18(b)"," Option 2:  Calculated estimate using survey data - Method 2:  May be used to reduce the statistical impact of outliers.  [(value of Entry 1 multiplied by Entry 15, and then multiplied by Entry 9) added to (value of Entry 1 multiplied by Entry 16 and then multiplied by Entry 12); then rounded to nearest whole number].  ",{"$f":"((C10*C24*C18)+(C10*C25*C21))","v":{"v":2384.7325897764913,"d":"2385"}}]
["18(c)","Option 3:  Total population based on the most recent U.S. Census American Community Survey 5-Year Estimates data.  [Allowed for service areas that are community-wide, contingent upon being pre-approved by DEHCR as methodologically sound for the service area population calculation prior to CDBG application.]"]
["18(d)","Option 4:  Total population based on HUD LMISD for local government(s) and/or census block group(s)/tracts(s).  [Allowed for service areas for which HUD LMISD are available, contingent upon being pre-approved by DEHCR as methodologically sound for the service area population calculation prior to CDBG application.]"]
["18(e)","Option 5:  OTHER - CONTACT DEHCR  [An alternative method may be considered/used if pre-approved by DEHCR prior to CDBG application.  Contact DEHCR for guidance on other options for calculating population to adjust for the statistical impact of significant outliers and/or data anomalies.]"]
[19,"Estimated total number of LMI persons in the project service area.  [value of Entry 18 multiplied by value of Entry 15; then rounded to the nearest whole number]",{"$f":"(SUM(C28:C32))*C24","v":{"v":1281.566216185229,"d":"1282"}}]

{"sheet":"Form 2","index":4,"n_rows":30,"n_cols":14,"rows_kept":30,"merged":[[3,1,5,1],[3,2,5,2],[3,3,3,10],[3,12,3,13],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,12,4,13]]}
["(FORM 2)  Income Survey Income Level Responses Form",{"$nulls":9},"Survey End Date: ",null,"ADD DATE"]
["[ADD UGLG NAME HERE, e.g. VILLAGE OF YOURVILLE]"]
[]
[null,"Non-Respondent (enter \"1\" if applicable)","Vacant (enter \"1\" if applicable)","Family Size",{"$nulls":8},"Family Income Level "]
[{"$nulls":3},1,2,3,4,5,6,7,"≥8",null,"(Enter # of persons in family in column associated with their income level.)"]
["Survey #",{"$nulls":11},"Family BELOW LMI Threshold (enter Family Size #)","ABOVE LMI Threshold (enter Family Size #)"]
["Insert/Delete Rows Below As Needed."]
{"$rows_empty":19}
[{"$nulls":12},"TOTALS:"]
["# FAMILIES RESPONDING FAMILIES:",null,null,{"$f":"COUNT(D8:D27)","v":0},{"$f":"COUNT(E8:E27)","v":0},{"$f":"COUNT(F8:F27)","v":0},{"$f":"COUNT(G8:G27)","v":0},{"$f":"COUNT(H8:H27)","v":0},{"$f":"COUNT(I8:I27)","v":0},{"$f":"COUNT(J8:J27)","v":0},{"$f":"COUNT(K8:K27)","v":0},{"$f":"SUM(D28:K28)","v":0},{"$f":"COUNT(M8:M27)","v":0},{"$f":"COUNT(N8:N27)","v":0}]
["# PERSONS IN RESPONDING FAMILIES:",null,null,{"$f":"SUM(D8:D27)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(D29:K29)","v":0},{"$f":"SUM(M8:M27)","v":0},{"$f":"SUM(N8:N27)","v":0}]
["# VACANT OR NON-RESPOND-ING",{"$f":"SUM(B8:B27)","v":0},{"$f":"SUM(C8:C27)","v":0}]

{"sheet":"Form 2 Ex.","index":5,"n_rows":31,"n_cols":15,"rows_kept":31,"merged":[[3,2,5,2],[3,3,5,3],[3,4,3,11],[3,13,3,14],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,13,4,14]]}
[null,"(FORM 2 EXAMPLE)  Income Survey Income Level Responses Form",{"$nulls":9},"Survey End Date:   1/24/2020"]
[null,"VILLAGE OF YOURVILLE"]
[]
[null,null,"Non-Respondent (enter \"1\" if applicable)","Vacant (enter \"1\" if applicable)","Family Size",{"$nulls":8},"Family Income Level "]
[{"$nulls":4},1,2,3,4,5,6,7,"≥8",null,"(Enter # of persons in family in column associated with their income level.)"]
[null,"Survey #",{"$nulls":11},"Family BELOW LMI Threshold (enter Family Size #)","ABOVE LMI Threshold (enter Family Size #)"]
[null,"Insert/Delete Rows Below As Needed."]
[null,1,{"$nulls":4},3,{"$nulls":7},3]
[null,2,null,1]
[null,3,null,null,1,{"$nulls":8},1]
[null,4,null,null,1,{"$nulls":8},1]
[null,5,{"$nulls":3},2,{"$nulls":7},2]
[null,6,1]
[null,7,null,null,1,{"$nulls":8},1]
[null,8,{"$nulls":3},2,{"$nulls":7},2]
[null,9,null,1]
[null,10,{"$nulls":3},2,{"$nulls":8},2]
[null,11,{"$nulls":3},2,{"$nulls":8},2]
[null,12,null,null,1,{"$nulls":9},1]
[null,13,null,null,1,{"$nulls":8},1]
[null,14,null,null,1,{"$nulls":8},1]
[null,15,{"$nulls":3},2,{"$nulls":8},2]
[null,16,{"$nulls":4},3,{"$nulls":7},3]
[null,17,null,null,1,{"$nulls":8},1]
[null,18,{"$nulls":3},2,{"$nulls":7},2]
[null,19,null,null,1,{"$nulls":8},1]
[null,20,null,null,1,{"$nulls":8},1]
[{"$nulls":13},"TOTALS:"]
[null,"# FAMILIES RESPONDING FAMILIES:",null,null,{"$f":"COUNT(E8:E28)","v":9},6,2,0,0,0,0,0,{"$f":"SUM(E29:L29)","v":17},{"$f":"COUNT(N8:N28)","v":11},{"$f":"COUNT(O8:O28)","v":6}]
[null,"# PERSONS IN RESPONDING FAMILIES:",null,null,{"$f":"SUM(E8:E28)","v":9},12,6,0,0,0,0,0,{"$f":"SUM(E30:L30)","v":27},{"$f":"SUM(N8:N28)","v":14},{"$f":"SUM(O8:O28)","v":13}]
[null,"# VACANT OR NON-RESPONDING",{"$f":"SUM(C8:C28)","v":1},{"$f":"SUM(D8:D28)","v":2}]

{"sheet":"Form 3","index":6,"n_rows":30,"n_cols":25,"rows_kept":30,"merged":[[0,20,0,21],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,3,23],[3,24,4,24]]}
["(FORM 3)  Income Survey Race/Ethnicity Responses Form",{"$nulls":16},"Survey End Date: ",null,null,"[ADD DATE]"]
["ENTER UGLG NAME HERE, e.g. VILLLAGE OF YOURVILLE"]
[]
["Survey #","Non-Respon-dent (enter \"1\" if appli-cable)","Vacant (enter \"1\" if appli-cable)","Family Race/ Ethnicity Information",{"$nulls":20},"TOTAL # IN FAMILY (Family Size)"]
[{"$nulls":3},"White","White + HISPANIC","Black/\nAfrican American","Black/\nAfrican American + HISPANIC","Asian","Asian  + HISPANIC","American Indian/ \nAlaskan Native","American Indian/ \nAlaskan Native + HISPANIC","Native Hawaiian/\nPacific Islander","Native Hawaiian/\nPacific Islander + HISPANIC","American Indian/ \nAlaskan Native & White","American Indian/ \nAlaskan Native & White + HISPANIC","Asian & White","Asian &\nWhite + HISPANIC","Black/\nAfrican American\n& White","Black/\nAfrican American\n& White + HISPANIC","American Indian/ Alaskan Native \n& Black/African American","American Indian/ Alaskan Native \n& Black/African American + HISPANIC","Other \nMulti- Racial","Other \nMulti- Racial + HISPANIC","No Answer"]
["Insert/Delete Rows Below As Needed."]
[{"$nulls":24},{"$f":"SUM(D7:X7)","v":0}]
[{"$nulls":24},{"$f":"SUM(D8:X8)","v":0}]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},0]
[{"$nulls":24},{"$f":"SUM(D27:X27)","v":0}]
[{"$nulls":24},0]
[]
["TOTALS:",{"$f":"SUM(B7:B29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Form 3 Ex.","index":7,"n_rows":28,"n_cols":25,"rows_kept":28,"merged":[[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,3,23],[3,24,4,24]]}
["(FORM 3 EXAMPLE)  Income Survey Race/Ethnicity Responses Form",{"$nulls":15},"Survey End Date:  1/24/2020"]
["Village of Yourville"]
[]
["Survey #","Non-Respon-dent (enter \"1\" if appli-cable)","Vacant (enter \"1\" if appli-cable)","Family Race/ Ethnicity Information",{"$nulls":20},"TOTAL # IN FAMILY (Family Size)"]
[{"$nulls":3},"White","White + HISPANIC","Black/\nAfrican American","Black/\nAfrican American + HISPANIC","Asian","Asian  + HISPANIC","American Indian/ \nAlaskan Native","American Indian/ \nAlaskan Native + HISPANIC","Native Hawaiian/\nPacific Islander","Native Hawaiian/\nPacific Islander + HISPANIC","American Indian/ \nAlaskan Native & White","American Indian/ \nAlaskan Native & White + HISPANIC","Asian & White","Asian &\nWhite + HISPANIC","Black/\nAfrican American\n& White","Black/\nAfrican American\n& White + HISPANIC","American Indian/ Alaskan Native \n& Black/African American","American Indian/ Alaskan Native \n& Black/African American + HISPANIC","Other \nMulti- Racial","Other \nMulti- Racial + HISPANIC","No Answer"]
["Insert/Delete Rows Below As Needed."]
[1,null,null,3,{"$nulls":20},{"$f":"SUM(D7:X7)","v":3}]
[2,null,1,{"$nulls":21},{"$f":"SUM(D8:X8)","v":0}]
[3,null,null,1,{"$nulls":20},1]
[4,null,null,1,{"$nulls":20},1]
[5,null,null,2,{"$nulls":20},2]
[6,1,{"$nulls":22},0]
[7,null,null,1,{"$nulls":20},1]
[8,{"$nulls":3},2,{"$nulls":19},2]
[9,null,1,{"$nulls":21},0]
[10,null,null,2,{"$nulls":20},2]
[11,{"$nulls":12},2,{"$nulls":10},2]
[12,null,null,1,{"$nulls":20},1]
[13,null,null,1,{"$nulls":20},1]
[14,null,null,1,{"$nulls":20},1]
[15,{"$nulls":3},2,{"$nulls":19},2]
[16,{"$nulls":4},3,{"$nulls":18},3]
[17,null,null,1,{"$nulls":20},1]
[18,null,null,2,{"$nulls":20},2]
[19,null,null,1,{"$nulls":20},1]
[20,{"$nulls":6},1,{"$nulls":16},1]
[]
["TOTALS:",{"$f":"SUM(B7:B26)","v":1},2,17,4,3,0,1,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,27]

{"sheet":"Form 4","index":8,"n_rows":28,"n_cols":12,"rows_kept":28,"merged":[[0,10,0,11]]}
["(FORM 4)  Income Survey Distribution Contact List Form",{"$nulls":6},"Survey End Date: ",null,null,"[ADD DATE]"]
["ENTER UGLG NAME HERE, e.g. VILLLAGE OF YOURVILLE"]
[]
["Survey #","Non-Reson-dent (enter \"1\" if appli-cable)","Vacant (enter \"1\" if appli-cable)","Property Street Address (Property Location in Service Area):","(Property Location) City:","(Property Location) Zip:","Mailing Address (If Different than Property Location Address):","(Mailing) City:","(Mail-ing) State:","(Mail-ing) Zip:","Telephone # (Only If Used to Contact/Attempt to Contact):","Email Address (Only If Used to Contact/Attempt to Contact):"]
["Insert/Delete Rows Below As Needed.  Insert/Delete Columns As Needed."]
{"$rows_empty":22}
["TOTALS:",{"$f":"SUM(B5:B27)","v":0},{"$f":"SUM(C5:C27)","v":0}]

{"sheet":"Form 4 Ex.","index":9,"n_rows":27,"n_cols":12,"rows_kept":27}
["(FORM 4 EXAMPLE)  Income Survey Distribution Contact List Form",{"$nulls":6},"Survey End Date:  1/24/2020"]
["VILLAGE OF YOURVILLE"]
[]
["Survey #","Non-Reson-dent (enter \"1\" if appli-cable)","Vacant (enter \"1\" if appli-cable)","Property Street Address (Property Location in Service Area):","(Property Location) City:","(Property Location) Zip:","Mailing Address (If Different than Property Location Address):","(Mailing) City:","(Mail-ing) State:","(Mail-ing) Zip:","Telephone # (Only If Used to Contact):","Email Address (Only If Used to Contact):"]
["Insert/Delete Rows Below As Needed.  Insert/Delete Columns As Needed."]
[1,null,null,"123 Wisconsin Ave.","Yourville",59999]
[2,null,1,"124 Wisconsin Ave.","Yourville",59999,"123 Washington Ave.","Fort Myers","FL",99999]
[3,null,null,"125 Wisconsin Ave.","Yourville",59999]
[4,null,null,"126 Wisconsin Ave.","Yourville",59999]
[5,null,null,"127 Wisconsin Ave.","Yourville",59999]
[6,1,null,"128 Wisconsin Ave.","Yourville",59999,"456 Miller Lane","Phoenix","AZ",88888,"708-123-5555","smith@tds.com"]
[7,null,null,"129 Wisconsin Ave.","Yourville",59999]
[8,null,null,"130 Wisconsin Ave.","Yourville",59999]
[9,null,1,"131 Wisconsin Ave.","Yourville",59999]
[10,null,null,"132 Wisconsin Ave.","Yourville",59999]
[11,null,null,"133 Wisconsin Ave.","Yourville",59999]
[12,null,null,"134 Wisconsin Ave.","Yourville",59999]
[13,null,null,"135 Wisconsin Ave.","Yourville",59999]
[14,null,null,"136 Wisconsin Ave.","Yourville",59999]
[15,null,null,"137 Wisconsin Ave.","Yourville",59999]
[16,null,null,"138 Wisconsin Ave.","Yourville",59999]
[17,null,null,"139 Wisconsin Ave. (Unit 1)","Yourville",59999,{"$nulls":4},"608-987-6666"]
[18,null,null,"139 Wisconsin Ave. (Unit 2)","Yourville",59999,{"$nulls":4},"608-987-2222"]
[19,null,null,"141 Wisconsin Ave.","Yourville",59999,{"$nulls":4},"608-987-4444"]
[20,null,null,"142 Wisconsin Ave.","Yourville",59999]
[]
["TOTALS:",{"$f":"SUM(B6:B25)","v":1},{"$f":"SUM(C6:C25)","v":2}]

{"sheet":"Form 5","index":10,"n_rows":7,"n_cols":13,"rows_kept":7}
[null,"(FORM 5)  Income Survey Distribution Efforts Tracking Form",{"$nulls":6},"Survey End Date: ",null,"[ADD DATE]"]
[null,"ENTER UGLG NAME HERE, e.g. VILLLAGE OF YOURVILLE"]
[null,"Add ALL distribution efforts.  Must provide details shown for each effort made."]
[null,"Note:  The contact information used (e.g., residential location address, mailing address(es), phone number(s), email "]
[null,"address(es), etc.) MUST be included on Form 4 (Contact List Form) in this Excel document)."]
["Survey #","Non-Respon-dent:","Vacant","Date Confirmed Vacant:","Survey Response Date (if responded):","Survey Mailing #1 Date:","Survey Mailing #2 Date:","Email #1 Date","Email #2 Date:","In-Person Contact/ Attempt #1 Date & Time:","In-Person Contact/ Attempt #2 Date & Time:","Phone Contact/ Attempt #1 Date & Time:","Phone Contact/ Attempt #2 Date & Time:"]
[null,"Insert/Delete Rows Below As Needed.  Insert/Delete Columns As Needed."]

{"sheet":"Form 5 Ex.","index":11,"n_rows":27,"n_cols":13,"rows_kept":27}
[null,"(FORM 5)  Income Survey Distribution Efforts Tracking Form",{"$nulls":8},"Survey End Date:  1/24/2020"]
[null,"ENTER UGLG NAME HERE, e.g. VILLLAGE OF YOURVILLE"]
[null,"Add ALL distribution efforts.  Must provide details shown for each effort made."]
[null,"Note:  The contact information used (e.g., residential location address, mailing address(es), phone number(s), email "]
[null,"address(es), etc.) MUST be included on Form 4 (Contact List Form) in this Excel document)."]
["Survey #","Non-Respon-dent:","Vacant","Date Confirmed Vacant:","Survey Response Date (if responded):","Survey Mailing #1 Date:","Survey Mailing #2 Date:","Email #1 Date:","Email #2 Date:","In-Person Contact/ Attempt #1 Date & Time:","In-Person Contact/ Attempt #2 Date & Time:","Phone Contact/ Attempt #1 Date & Time:","Phone Contact/ Attempt #2 Date & Time:"]
[null,"Insert/Delete Rows Below As Needed.  Insert/Delete Columns As Needed."]
[1,{"$nulls":3},"2019-11-22","2019-11-15"]
[2,null,1,"2019-11-20","Vacant","2019-11-15"]
[3,{"$nulls":3},"2019-11-23","2019-11-15"]
[4,{"$nulls":3},"2019-11-26","2019-11-15"]
[5,{"$nulls":3},"2019-12-14","2019-11-15","2019-12-05"]
[6,1,null,null,"No Response","2019-11-15","2019-12-05","2020-01-06","2020-01-23","1/5/2020 - PM","1/14/2020 - AM","12/20/2019 - PM","1/16/2020 - AM"]
[7,{"$nulls":3},"2019-12-28","2019-11-15","2019-12-05"]
[8,{"$nulls":3},"2020-01-12","2019-11-15","2019-12-05",null,null,"1/5/2020 - PM"]
[9,null,1,"2019-11-22","Vacant","2019-11-15"]
[10,{"$nulls":3},"2019-11-23","2019-11-15"]
[11,{"$nulls":3},"2019-11-22","2019-11-15"]
[12,{"$nulls":3},"2019-11-30","2019-11-15"]
[13,{"$nulls":3},"2019-12-20","2019-11-15","2019-12-05"]
[14,{"$nulls":3},"2019-12-08","2019-11-15","2019-12-05"]
[15,{"$nulls":3},"2019-12-08","2019-11-15","2019-12-05"]
[16,{"$nulls":3},"2019-12-18","2019-11-15","2019-12-05"]
[17,{"$nulls":3},"2020-01-24","2019-11-15","2019-12-05",null,null,"1/5/2020 - PM","1/14/2020 - AM","12/20/2019 - PM","1/16/2020 - AM"]
[18,{"$nulls":3},"2020-01-14","2019-11-15","2019-12-05",null,null,"1/5/2020 - PM","1/14/2020 - AM","12/20/2019 - PM"]
[19,{"$nulls":3},"2020-01-05","2019-11-15","2019-12-05",null,null,"1/5/2020 - PM",null,"12/20/2019 - PM"]
[20,{"$nulls":3},"2019-12-17","2019-11-15","2019-12-05"]

{"sheet":"Form 6 Part 1-2","index":12,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[5,1,5,3]]}
["(FORM 6 PART 1-2)  Random Sample Survey Methodology:"]
["ENTER UGLG NAME HERE, e.g. VILLLAGE OF YOURVILLE",null,null,"Survey End Date: ","ADD DATE"]
[]
["PART 1 - Summary of Randomization Process:"]
[]
[null,"ADD SUMMARY OF RANDOMIZATION PROCESS HERE"]
[]
["PART 2 - Randomizer.org Random Number Generator Criteria Entered and Results Screenshots:"]
[]
["ADD SCREEN SHOTS BELOW OF NUMBER GENERATOR CRITERIA USED AND RESULTS  AS SHOWN IN EXAMPLE FORM 6 PART 1-2 EXAMPLE:"]

{"sheet":"Form 6 Part 3","index":13,"n_rows":107,"n_cols":5,"rows_kept":107}
["(FORM 6 PART 3)  Random Sample Survey Methodology",null,null,"Survey End Date:   ADD DATE"]
["ENTER UGLG NAME HERE, e.g. VILLLAGE OF YOURVILLE"]
[]
["PART 3 - Random Number Assignments, Original Sample & Oversample"]
[]
["Family # Assigned for Randomization","Street/Residential Unit Address:","Original Sample (## families) Assigned","Oversample (additional ## families) Assigned","Original Sample # Non-Respondent replaced by Oversample Respondent:"]
["Insert/Delete Rows Below As Needed."]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"Form 6 Part 1-2 Ex.","index":14,"n_rows":8,"n_cols":10,"rows_kept":8,"merged":[[5,1,5,11]]}
["(FORM 6 - PART 1-2 EXAMPLE)  Random Sample Survey Methodology:",{"$nulls":8},"Survey End Date:   1/24/2020"]
["VILLAGE OF YOURVILLE"]
[]
["PART 1 - Summary of Randomization Process:"]
[]
[null,"Used Randomizer.org.  Randomized 100 families.  Selected families for Original Sample and Over Sample through corresponding Family #s to p1-p49 in Randomizer.org Results. Results are below."]
[]
["PART 2 - Randomizer.org Random Number Generator Criteria Entered and Results Screenshots:"]

{"sheet":"Form 6 Part 3Ex.","index":15,"n_rows":107,"n_cols":5,"rows_kept":107}
["(FORM 6 - PART 3 EXAMPLE)  Random Sample Survey Methodology",null,null,"Survey End Date:   1/24/2020"]
["VILLAGE OF YOURVILLE"]
[]
["PART 3 - Random Number Assignments, Original Sample & Oversample"]
[]
["Family # Assigned for Randomization","Street/Residential Unit Address:","Original Sample 41 families) Assigned","Oversample (additional 8 families) Assigned","Original Sample # Non-Respondent replaced by Oversample Respondent:"]
["Insert/Delete Rows Below As Needed."]
[1,"123 Wisconsin Ave.","p6"]
[2,"124 Wisconsin Ave.","p24"]
[3,"125 Wisconsin Ave."]
[4,"126 Wisconsin Ave. Rm 1 Friendship Nursing Care",null,"p45","p21"]
[5,"126 Wisconsin Ave. Rm 2 Friendship Nursing Care"]
[6,"126 Wisconsin Ave. Rm 3 Friendship Nursing Care"]
[7,"126 Wisconsin Ave. Rm 4 Friendship Nursing Care","p2"]
[8,"126 Wisconsin Ave. Rm 5 Friendship Nursing Care"]
[9,"126 Wisconsin Ave. Rm 6 Friendship Nursing Care"]
[10,"132 Wisconsin Ave."]
[11,"133 Wisconsin Ave.","p21 (non-respondent)"]
[12,"134 Wisconsin Ave."]
[13,"135 Wisconsin Ave."]
[14,"136 Wisconsin Ave."]
[15,"137 Wisconsin Ave.","p28 (non-respondent)"]
[16,"138 Wisconsin Ave."]
[17,"139 Wisconsin Ave. Unit 1","p4"]
[18,"139 Wisconsin Ave. Unit 2","p30"]
[19,"141 Wisconsin Ave."]
[20,"142 Wisconsin Ave.","p31"]
[21,"143 Wisconsin Ave.","p36"]
[22,"144 Wisconsin Ave."]
[23,"145 Wisconsin Ave."]
[24,"146 Wisconsin Ave."]
[25,"147 Wisconsin Ave."]
[26,"148 Wisconsin Ave."]
[27,"149 Wisconsin Ave."]
[28,"150 Wisconsin Ave."]
[29,"151 Wisconsin Ave.","p1"]
[30,"152 Wisconsin Ave."]
[31,"153 Wisconsin Ave. Apt A"]
[32,"153 Wisconsin Ave. Apt B","p16"]
[33,"155 Wisconsin Ave."]
[34,"156 Wisconsin Ave.","p37"]
[35,"157 Wisconsin Ave.","p38 (non-respondent)"]
[36,"158 Wisconsin Ave.",null,"p48","p33"]
[37,"159 Wisconsin Ave."]
[38,"160 Wisconsin Ave."]
[39,"161 Wisconsin Ave.","p39"]
[40,"162 Wisconsin Ave.","p25"]
[41,"163 Wisconsin Ave.","p20"]
[42,"164 Wisconsin Ave.","p17"]
[43,"165 Wisconsin Ave."]
[44,"166 Wisconsin Ave."]
[45,"167 Wisconsin Ave."]
[46,"168 Wisconsin Ave."]
[47,"169 Wisconsin Ave."]
[48,"170 Wisconsin Ave."]
[49,"171 Wisconsin Ave."]
[50,"172 Wisconsin Ave."]
[51,"173 Wisconsin Ave."]
[52,"174 Wisconsin Ave."]
[53,"175 Wisconsin Ave.","p12"]
[54,"176 Wisconsin Ave."]
[55,"177 Wisconsin Ave.","p19"]
[56,"178 Wisconsin Ave."]
[57,"179 Wisconsin Ave.","p14"]
[58,"180 Wisconsin Ave."]
[59,"181 Wisconsin Ave.","p3","p49","p38"]
[60,"182 Wisconsin Ave."]
[61,"183 Wisconsin Ave."]
[62,"184 Wisconsin Ave."]
[63,"185 Wisconsin Ave."]
[64,"186 Wisconsin Ave.","p11"]
[65,"187 Wisconsin Ave.","p15"]
[66,"188 Wisconsin Ave."]
[67,"189 Wisconsin Ave.","p32"]
[68,"190 Wisconsin Ave.","p40 (non-respondent)"]
[69,"191 Wisconsin Ave.","p9"]
[70,"192 Wisconsin Ave.","p27"]
[71,"193 Wisconsin Ave.",null,"p47","p29"]
[72,"194 Wisconsin Ave.",null,"p42","p5"]
[73,"195 Wisconsin Ave.","p33 (non-respondent)"]
[74,"196 Wisconsin Ave.","p22"]
[75,"197 Wisconsin Ave.","p23"]
[76,"198 Wisconsin Ave.","p5 (non-respondent)"]
[77,"199 Wisconsin Ave.","p41"]
[78,"200 Wisconsin Ave.","p7"]
[79,"201 Wisconsin Ave.","p29 (non-respondent)"]
[80,"202 Wisconsin Ave.","p10"]
[81,"203 Wisconsin Ave.","p26"]
[82,"204 Wisconsin Ave.","p18 (non-respondent)"]
[83,"205 Wisconsin Ave."]
[84,"206 Wisconsin Ave.","p35"]
[85,"207 Wisconsin Ave.",null,"p44","p18"]
[86,"208 Wisconsin Ave."]
[87,"209 Wisconsin Ave."]
[88,"210 Wisconsin Ave."]
[89,"211 Wisconsin Ave.",null,"p43","p8"]
[90,"212 Wisconsin Ave.",null,"p46","p28"]
[91,"213 Wisconsin Ave."]
[92,"214 Wisconsin Ave.","p8 (non-respondent)"]
[93,"215 Wisconsin Ave."]
[94,"216 Wisconsin Ave.","p34"]
[95,"217 Wisconsin Ave."]
[96,"218 Wisconsin Ave."]
[97,"219 Wisconsin Ave.","p13"]
[98,"220 Wisconsin Ave."]
[99,"221 Wisconsin Ave."]
[100,"222 Wisconsin Ave."]

{"sheet":"Form 7","index":16,"n_rows":26,"n_cols":24,"rows_kept":26,"merged":[[4,0,4,23],[8,0,9,0],[8,1,9,1],[8,2,8,22],[8,23,9,23]]}
["(FORM 7)  Limited Clientele Residential Living Facility Family Data",{"$nulls":14},"Survey End Date:  ADD DATE"]
["ENTER UGLG NAME HERE, e.g. VILLLAGE OF YOURVILLE"]
["ENTER NAME OF FACILITY",{"$nulls":9},"Address:  Enter Facility Address"]
[]
["*Must record family occupancy (# of families and family size in each living unit) for ALL living units.  Married or related persons in the same living unit may be counted as 1 family.  Unrelated persons who are not family living in the same living unit are separate families.  Enter the # of persons in the family under the corresponding race/ethnicity (if available) or under the \"Not Available\" option.  Also incorporate/report this data in Forms 2-6 in the data for all families in the Service Area/Survey Area."]
[]
["*A letter from the the facility must be provided with this form.  Refer to Income Survey Guide for guidance."]
[]
["Unit #","Vacant (enter \"1\" if appli-cable)","Family Race/ Ethnicity Information",{"$nulls":20},"TOTAL # IN FAMILY (Family Size)"]
[null,null,"White","White + HISPANIC","Black/\nAfrican American","Black/\nAfrican American + HISPANIC","Asian","Asian  + HISPANIC","American Indian/ \nAlaskan Native","American Indian/ \nAlaskan Native + HISPANIC","Native Hawaiian/\nPacific Islander","Native Hawaiian/\nPacific Islander + HISPANIC","American Indian/ \nAlaskan Native & White","American Indian/ \nAlaskan Native & White + HISPANIC","Asian & White","Asian &\nWhite + HISPANIC","Black/\nAfrican American\n& White","Black/\nAfrican American\n& White + HISPANIC","American Indian/ Alaskan Native \n& Black/African American","American Indian/ Alaskan Native \n& Black/African American + HISPANIC","Other \nMulti- Racial","Other \nMulti- Racial + HISPANIC","Not Available"]
["Insert/Delete Rows Below As Needed."]
[{"$nulls":23},{"$f":"SUM(C12:W12)","v":0}]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[]
["TOTALS:",{"$f":"SUM(B11:B25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Form 7 Ex.","index":17,"n_rows":27,"n_cols":24,"rows_kept":27,"merged":[[4,0,4,23],[8,0,9,0],[8,1,9,1],[8,2,8,22],[8,23,9,23]]}
["(FORM 7 EXAMPLE)  Limited Clientele Residential Living Facility Family Data",{"$nulls":17},"Survey End Date:  1/24/2020"]
["Village of Yourville"]
["Friendly Services Convalescent Center",{"$nulls":12},"Address:  100 Riverdale Avenue, Yourville, WI  53333"]
[]
["*Must record family occupancy (# of families and family size in each living unit) for ALL living units.  Married or related persons in the same living unit may be counted as 1 family.  Unrelated persons who are not family living in the same living unit are separate families.  Enter the # of persons in the family under the corresponding race/ethnicity (if available) or under the \"Not Available\" option.)  Also incorporate/report this data in Forms 2-6 in the data for all families in the Service Area/Survey Area."]
[]
["*A letter from the the facility must be provided with this form.  Refer to Income Survey Guide for guidance."]
[]
["Unit #","Vacant (enter \"1\" if appli-cable)","Family Race/ Ethnicity Information",{"$nulls":20},"TOTAL # IN FAMILY (Family Size)"]
[null,null,"White","White + HISPANIC","Black/\nAfrican American","Black/\nAfrican American + HISPANIC","Asian","Asian  + HISPANIC","American Indian/ \nAlaskan Native","American Indian/ \nAlaskan Native + HISPANIC","Native Hawaiian/\nPacific Islander","Native Hawaiian/\nPacific Islander + HISPANIC","American Indian/ \nAlaskan Native & White","American Indian/ \nAlaskan Native & White + HISPANIC","Asian & White","Asian &\nWhite + HISPANIC","Black/\nAfrican American\n& White","Black/\nAfrican American\n& White + HISPANIC","American Indian/ Alaskan Native \n& Black/African American","American Indian/ Alaskan Native \n& Black/African American + HISPANIC","Other \nMulti- Racial","Other \nMulti- Racial + HISPANIC","Not Available"]
["Insert/Delete Rows Below As Needed."]
["Room 1",null,1,{"$nulls":20},{"$f":"SUM(C12:W12)","v":1}]
["Room 2",null,2,{"$nulls":20},{"$f":"SUM(C13:W13)","v":2}]
["Room 3",null,1,{"$nulls":20},1]
["Room 4A",null,1,{"$nulls":20},1]
["Room 4B",{"$nulls":3},1,{"$nulls":18},1]
["Room 5",null,1,{"$nulls":20},1]
["Room 6",1,{"$nulls":21},0]
["Room 7A",null,1,{"$nulls":20},1]
["Room 7B",{"$nulls":7},1,{"$nulls":14},1]
["Room 8",1,{"$nulls":21},0]
["Room 9",null,1,{"$nulls":20},1]
["Room 10",null,null,2,{"$nulls":19},2]
["Room 11",1,{"$nulls":21},0]
["Room 12",1,{"$nulls":21},0]
[]
["TOTALS:",{"$f":"SUM(B12:B26)","v":4},8,2,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12]

{"sheet":"Form 8","index":18,"n_rows":29,"n_cols":5,"rows_kept":29,"merged":[[4,1,4,4],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[19,1,19,4]]}
[null,"(FORM 8)  Multi-Jurisdictional Service Area LMI Calculation"]
[null,"ENTER UGLG NAME HERE, e.g. VILLLAGE OF YOURVILLE"]
[{"$nulls":3},"Survey End Date:   ADD DATE"]
[]
[null,"Maps of the entire Service Area as well as each individual Survey Area and/or Census Tract (as applicable) must be submitted with the Income Survey Packet in the Service Area/Survey Area Maps section."]
[]
[null,"Beneficiaries/Service Area","Data Source**","# LMI Persons [LOWMOD]","# Persons Total Population [LOWMODUNIV]"]
[]
[null,"ADD JURISDICTION 1 NAME*",null,0,0]
[null,"ADD JURISDICTION 2 NAME*",null,0,0]
[null,"ADD JURISDICTION 3 NAME*",null,0,0]
[null,"ADD JURISDICTION 4 NAME*",null,0,0]
[null,"ADD JURISDICTION 5 NAME*",null,0,0]
[null,"ADD JURISDICTION 6 NAME*",null,0,0]
[null,"ADD JURISDICTION 7 NAME*",null,0,0]
[null,"[INSERT ROWS AS NEEDED]",null,0,0]
[null,"TOTALS  [formula pre-entered here]",null,{"$f":"SUM(D9:D16)","v":0},{"$f":"SUM(E9:E16)","v":0}]
[null,"SERVICE AREA (ALL) LMI % "," [formula pre-entered here]***",null,{"$f":"D17/E17","v":{"$error":"#DIV/0!"}}]
[]
[null,"*For Jurisdiction Name, add ULGLG name (e.g., Town of Yourville) or Census Tract #-Block # (e.g., Census Tract 100.01 Block 3) and if only a portion of the jurisdiction is included in the survey, make the notation, \"(Partial)\"."]
[]
[null,"**For Data Source, enter 1 of 4 options:  "]
[null,null,"1)  HUD LMISD Community-Wide"]
[null,null,"2)  HUD LMISD Census Tract (ADD Tract # and Block #)"]
[null,null,"3)  Income Survey-Census Survey"]
[null,null,"4)  Income Survey-Random Sample Survey"]
[]
[null,"***LMI Percentage Calculation for complete Service Area (formula entered in table above):  "]
[null,null," (## TOTAL LOWMOD) ÷ (## TOTAL LOWMODUNIV) x 100"]

{"sheet":"Form 8 Ex.","index":19,"n_rows":28,"n_cols":5,"rows_kept":28,"merged":[[3,1,3,4],[6,1,6,4],[20,1,20,4],[27,2,27,3]]}
[null,"(FORM 8 EXAMPLES)  Multi-Jurisdictional Service Area LMI Calculation"]
[null,"TOWN OF YOURVILLE",null,null,"Survey End Date:   1/24/2020"]
[]
[null,"Maps of the entire Service Area as well as each individual Survey Area and/or Census Tract (as applicable) must be submitted with the Income Survey Packet in the Service Area/Survey Area Maps section."]
[]
[null,"EXAMPLE 1"]
[null,"LMI calculation for a project benefitting/serving multiple jurisdictions, for which HUD LMISD Census Tract data are used for two jurisdictions (portions of 2 UGLGs); HUD LMISD Community-Wide for 1 jurisdiction (LMISD for 1 entire UGLG); and income survey data for 2 jurisdictions (census survey of 1 entire UGLG and census survey for a portion of 1 UGLG)"]
[]
[null,"Beneficiaries/Service Area","Data Source","# LMI Persons  [LOWMOD]","# Persons Total Population [LOWMODUNIV]"]
[null,"Town of Adamsville (Partial)","HUD LMISD Census Tract 100.20 - Block 1",340,1000]
[null,"Town of Hillside (Partial)","HUD LMISD Census Tract 100.20 - Block 2",1740,3000]
[null,"Town of Yourville","HUD LMISD Community-Wide",260,500]
[null,"Village of Cantonville","Census Survey",280,400]
[null,"Village of Madisontown (Partial)","Census Survey",60,100]
[null,"TOTALS ","  ",{"$f":"SUM(D10:D14)","v":2680},{"$f":"SUM(E10:E14)","v":5000}]
[null,"SERVICE AREA (ALL) LMI % ",null,null,{"$f":"D15/E15","v":{"v":0.536,"d":"53.60%"}}]
[]
[]
[]
[null,"EXAMPLE 2"]
[null,"LMI calculation for a project benefitting/serving multiple Census Tracts, for which HUD LMISD are used for 2 Census Tracts and Random Sample Survey data are used for 1 Census Tract:"]
[]
[null,"Beneficiaries/Service Area","Data Source","# LMI Persons [LOWMOD]","# Persons Total Population [LOWMODUNIV]"]
[null,"HUD LMISD Census Tract 100.20 - Block 1","HUD LMISD Census Tract 100.20 - Block 1",380,1000]
[null,"HUD LMISD Census Tract 100.20 - Block 2","HUD LMISD Census Tract 100.20 - Block 2",1200,2000]
[null,"HUD LMISD Census Tract 100.30 - Block 1","Random Sample Survey",1000,2000]
[null,"TOTALS ","  ",{"$f":"SUM(D24:D26)","v":2580},{"$f":"SUM(E24:E26)","v":5000}]
[null,"SERVICE AREA (ALL) LMI % ",null,null,{"$f":"D27/E27","v":{"v":0.516,"d":"51.60%"}}]