{"text_format":"2","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","EXAMPLE_1_Families TOTALS","EXAMPLE_1a_Families_PY","Project Info","1_Families TOTALS","1a_Families_PY","1b_ Families_Vets","2_Singles TOTALS","2a_Singles_UY","2b_Singles_Vets","3_Only Children TOTALS","3a_Only Children_PY"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Instructions","index":0,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,2],[36,0,36,2],[10,0,10,2]]}
["Quick Tips"]
["•   The aggregate data collection sheet is ONLY for agencies that do not participate in HMIS and are not using the PIT LIVE survey tool."]
["•   Complete one Excel sheet for each Emergency Shelter and/or Transitional Housing project that your agency has."]
["•   The data is organized by household types. You only need to complete the questions for the household type(s) your program serves"]
["•   IMPORTANT INSTRUCTION: The first tab of each household type is the total number of people for that household type. The following tabs in each color group are subsets of data and those people should also be included on the first tab. For example, if you have parenting youth in an adult/child household, those families should be counted on the 1a_Families_PY tab AND the 1_Families TOTALS tab."]
["•   There are two example tabs \"EXAMPLE_1_Families TOTALS\" and \"EXAMPLE_1a_Families_PY\" that will demonstrate what correct data entry looks like if your program served adult/child households with one family that is a parenting youth."]
["•   Pay close attention to each tab's instructions to help guide data entry. Specifcally, subset data (parenting youth, unaccompanied youth, and veterans) only count the demographics (gender and race) of parenting youth, unaccompanied youth, or veterans in the family. The TOTALS tab of each household type counts demographics (gender and race) of all household members."]
["•   The Race/Ethnicity fields are single select so each person should only count in one category. For example, if someone identifies as multi-racial including White and Asian or Asian American, they should be counted once in the \"Multiple Races (not Hispanic/Latina/e/o)\" field. Do not count them in the \"White\" or \"Asian or Asian American\" fields."]
["• The Gender fields are also single-select. Then, for the population of clients who identify as \"More than One Gender\", also complete the following question \"If More than One Gender, how many people reported gender identities that includes\" and select all gender identities included. For example, if someone identifies as a \"Man (Boy, if child)\" and \"Questioning\", then count them once in \"More than One Gender\", and for the \"If More than One Gender...\" question, count them once in \"Man (Boy, if child)\" and once in \"Questioning\". The total count of sub-responses under \"If More than One Gender\" should equal at least double the count in the \"More than One Gender\" field. This is likely the most complicated field in this form - reach out to your CoC Coordinator or ICA for help as needed!"]
["•   Make sure to add your basic project information and contact info on the Project Info tab"]
["Definitions"]
["Household Types "]
["(green tabs)   Household Type I:  Adult (18+) and children (<18) Households (aka: Families)"]
["•         This could be families with at least one parent and one child"]
["•         This could be groups with at least an adult and a minor who don’t share a parent-child relationship"]
["(purple tabs) Household Type iI:  Adult (18+) Only Households (aka: Singles)"]
["•         This could be one single adult"]
["•         This could be a group of single adults"]
["•         This could be a couple without children and both individuals are over 18"]
["(orange tabs) Household Type III:  Children (<18) Only Households "]
["•         This could be one single person under 18"]
["•         This could be a group of persons under 18"]
["•         This could be a couple without children and both individuals are under 18"]
["•         This could be a couple with children under 18 and both individuals are under 18"]
[]
["Parenting Youth (PY)"]
["               •  A youth who identifies as the parent or legal guardian of one or more children who are present with or sleeping in the same place as that youth parent, where there is no person aged 25 or older in the household. "]
[]
["Unaacompanied Youth (UY)"]
["               •  Unaccompanied youth are persons under age 25 who are not accompanied by a parent or guardian, or any other household member aged 25 or older, and who are not a parent presenting with or sleeping in the same place as his/her child(ren). Unaccompanied youth are single youth, youth couples, and groups of youth presenting together as a household. "]
[]
["Veterans "]
["               •  Veterans are adults (18+) who have served on active duty in the Armed Forces of the United States. This does not include inactive military reserves or the National Guard unless the person was called up to active duty."]
[]
["Additional information and definitions can be found in the Surveyor Guide (linked here) which is located on the hmismn.org website under Projects > Point-in-Time Count (PIT)"]
[]
["Navigating the Tabs"]
["Answer the following questions to determine which tabs you should complete for this project.","Yes or No?","Instructions"]
["→Did your project serve adult/child households on PIT night? (Household Type I aka Families)         ","Select Answer",{"$f":"IF(B39=\"Yes\",\"Complete tab 1_Families TOTALS\",IF(B39=\"No\",\"Move to next household type\",IF(B39=\"Select Answer\",\"\")))","v":""}]
["          Were any of these households parenting youth?          ","Select Answer",{"$f":"IF(B40=\"Yes\",\"Complete tab 1a_Families_PY\",IF(B40=\"No\",\"Move to next question\",IF(B40=\"Select Answer\",\"\")))","v":""}]
["          Were there any veterans in these households?             ","Select Answer",{"$f":"IF(B41=\"Yes\",\"Complete tab 1b_Families_Vets\",IF(B41=\"No\",\"Move to next question\",IF(B41=\"Select Answer\",\"\")))","v":""}]
[]
["→Did your project serve single adults on PIT night? (Household Type II aka Singles)          ","Select Answer",{"$f":"IF(B43=\"Yes\",\"Complete tab 2_Singles TOTALS\",IF(B43=\"No\",\"Move to next household type\",IF(B43=\"Select Answer\",\"\")))","v":""}]
["          Were any of these households unaccompanied youth?          ","Select Answer",{"$f":"IF(B44=\"Yes\",\"Complete tab 2a_Singles_UY\",IF(B44=\"No\",\"Move to next question\",IF(B44=\"Select Answer\",\"\")))","v":""}]
["          Were there any veterans in these households?        ","Select Answer",{"$f":"IF(B45=\"Yes\",\"Complete tab 2b_Singles_Vets\",IF(B45=\"No\",\"Move to next question\",IF(B45=\"Select Answer\",\"\")))","v":""}]
[]
["→Did your project serve child-only households on PIT night? (Household Type III aka Children Only)","Select Answer",{"$f":"IF(B47=\"Yes\",\"Complete tab 3_Only Children TOTALS\",IF(B47=\"No\",\"No further questions\",IF(B47=\"Select Answer\",\"\")))","v":""}]
["          Were any of these households parenting youth?","Select Answer",{"$f":"IF(B48=\"Yes\",\"Complete tab 3a_Only Children_PY\",IF(B48=\"No\",\"No further questions\",IF(B48=\"Select Answer\",\"\")))","v":""}]

{"sheet":"EXAMPLE_1_Families TOTALS","index":1,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,1,1],[0,2,1,2],[9,0,50,0],[9,1,17,1],[18,1,33,1],[34,1,48,1],[49,1,50,1],[51,0,54,0],[51,1,54,1]]}
["Example scenario:",null,"Your program served two adult/child households on PIT night and you have completed the EXAMPLE 1_Families TOTALS table below. These are the deomgraphics of the two households served:"]
[]
[null,"Family 1:","Mom: 23 years old, Woman (Girl, if child), White and Asian or Asian American, has a substance use disorder.                                                               Daughter: 5 years old, Woman (Girl, if child), White and Asian or Asian American.                                                                                                         ","<< This is a parenting youth household so this household is also counted on the EXAMPLE 1a_Families_PY tab"]
[null,"Family 2:","Dad: 40 years old, Man (Boy, if child) and Questioning, Black, African American, or African.                                                                                                  Son: 10 years old, Man (Boy, if child), Black, African American, or African Daughter: 4 years old, Woman (Girl, if child), Black, African American, or African","<<This is not a parenting youth household, or a veteran household, so this household is only counted on this tab."]
[]
["Household Type I:  Adult (18+) and children (<18) Households (aka: Families)"]
["•         This could be families with at least one parent and one child"]
["•         This could be groups with at least an adult and a minor who don’t share a parent-child relationship"]
["Please Read:",null,"This tab should show the total count of people in an adult/child household type. If there are parenting youth or veterans within this household type, you should complete the respective following tabs, (1a) and/or (1b).The data collected on the following two tabs (parenting youth and vets) should also be counted in this tab 1_Families TOTALS."]
["Persons in Households with at least one Adult (18+) and one Child (<18)","Person Counts","Total Households",2]
[null,null,"Total People",5]
[null,null,"Number of Persons (under age 18)",3]
[null,null,"Number of Persons (18 - 24)",1]
[null,null,"Number of Persons (25-34)"]
[null,null,"Number of Persons (35-44)",1]
[null,null,"Number of Persons (45-54)"]
[null,null,"Number of Persons (55-64)"]
[null,null,"Number of Persons (65+)"]
[null,"Gender (select one per person)","Woman (Girl, if child)",3]
[null,null,"Man (Boy, if child)",1]
[null,null,"Cultrally Specific Identity"]
[null,null,"Transgender"]
[null,null,"Non-Binary"]
[null,null,"Questioning"]
[null,null,"Different Identity"]
[null,null,"More Than One Gender (complete question below)",1]
[null,null,"If More Than One Gender, how many people reported gender identities that includes:"]
[null,null,"          Woman (Girl, if child)"]
[null,null,"          Man (Boy, if child)",1]
[null,null,"          Cultrally Specific Identity"]
[null,null,"          Transgender"]
[null,null,"          Non-Binary"]
[null,null,"          Questioning",1]
[null,null,"          Different Identity"]
[null,"Race/Ethnicity (select one per person)","American Indian, Alaska Native, or Indigenous"]
[null,null,"American Indian, Alaska Native, or Indigenous & Hispanic/Latina/e/o"]
[null,null,"Asian or Asian American"]
[null,null,"Asian or Asian American & Hispanic/Latina/e/o"]
[null,null,"Black, African American, or African",3]
[null,null,"Black, African American, or African & Hispanic/Latina/e/o"]
[null,null,"Hispanic/Latina/e/o"]
[null,null,"Middle Eastern or North African"]
[null,null,"Middle Eastern or North African & Hispanic/Latina/e/o"]
[null,null,"Native Hawaiian or Pacific Islander"]
[null,null,"Native Hawaiian or Pacific Islander & Hispanic/Latina/e/o"]
[null,null,"White"]
[null,null,"White & Hispanic/Latina/e/o"]
[null,null,"Multiple Races (not Hispanic/Latina/e/o)",2]
[null,null,"Multiple Races & Hispanic/Latina/e/o"]
[null,"Chronic","Total Chronically Homeless Households"]
[null,null,"Total Chronic Homeless Persons"]
["Other",null,"Adults with a Serious Mental Illness"]
[null,null,"Adults with a Substance Use Disorder",1]
[null,null,"Adults with HIV/AIDS"]
[null,null,"Adult Survivors of Domestic Violence"]

{"sheet":"EXAMPLE_1a_Families_PY","index":2,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,1,1],[0,2,1,2],[18,0,48,0],[18,1,33,1],[34,1,48,1],[49,0,50,0],[49,1,50,1],[51,0,54,0],[51,1,54,1],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,1,10,2],[11,0,17,0],[11,1,17,1]]}
["Example scenario:",null,"Your program served two adult/child households on PIT night and you have completed the EXAMPLE 1_Families TOTALS table. One of these households is a parenting youth, so they are also counted on the EXAMPLE 1a_Families_PY table below. These are the deomgraphics of the two households served:"]
[]
[null,"Family 1:","Mom: 23 years old, Woman (Girl, if child), White and Asian or Asian American, has a substance use disorder.                                                                                                                   Daughter: 5 years old, Woman (Girl, if child), White and Asian or Asian American.                                                                                                         ","<<Parenting youth household so counted below."]
[null,"Family 2:","Dad: 40 years old, Man (Boy, if child) and Questioning, Black, African American, or African.                                                                                                            Son: 10 years old, Man (Boy, if child), Black, African American, or African    Daughter: 4 years old, Woman (Girl, if child), Black, African American, or African","<<NOT a parenting youth household, so not counted on this table."]
[]
["Household Type I:  Adult (18+) and children (<18) Households (aka: Families)"]
["•         This could be families with a parent(s) who are both under 24 years old and a child"]
["Parenting youth"]
["            •     A youth (18-24) who identifies as the parent or legal guardian of one or more children who are present with or sleeping in the same place as that youth parent, where there is no person aged 25 or older in the household. For example, a mom (20yo) with a child (5yo) will count as a parenting youth. However, if grandma (50) is in the household too, this household will NOT count as a parenting youth household."]
["            •    For example, a mom (20yo) with a child (5yo) will count as a parenting youth. However, if grandma (50) is in the household too, this household will NOT count as a parenting youth household."]
["Please read:","Use this tab to record data about parenting youth who are in adult/child households. The person counts and chronic fields should include all people in the household. The demographic fields are only for the youth parents in the household."]
["Parenting Youth Households","Person Counts","Total Parenting Youth Households",1]
[null,null,"Total People in Parenting Youth Households",2]
[null,null,"Total Parenting Youth",1]
[null,null,"Number of Parenting Youth (under age 18)"]
[null,null,"Number of Children (under age 18) with parenting youth (under age 18)"]
[null,null,"Number of Parenting Youth (age 18 to 24)",1]
[null,null,"Number of Children (under age 18) with parenting youth (age 18 to 24)",1]
["Youth Parents Only","Gender (select one per parenting youth)","Woman (Girl, if child)",1]
[null,null,"Man (Boy, if child)"]
[null,null,"Cultrally Specific Identity"]
[null,null,"Transgender"]
[null,null,"Non-Binary"]
[null,null,"Questioning"]
[null,null,"Different Identity"]
[null,null,"More Than One Gender (complete question below)"]
[null,null,"If More Than One Gender, how many people reported gender identities that includes:"]
[null,null,"          Woman (Girl, if child)"]
[null,null,"          Man (Boy, if child)"]
[null,null,"          Cultrally Specific Identity"]
[null,null,"          Transgender"]
[null,null,"          Non-Binary"]
[null,null,"          Questioning"]
[null,null,"          Different Identity"]
[null,"Race/Ethnicity (select one per parenting youth)","American Indian, Alaska Native, or Indigenous"]
[null,null,"American Indian, Alaska Native, or Indigenous & Hispanic/Latina/e/o"]
[null,null,"Asian or Asian American"]
[null,null,"Asian or Asian American & Hispanic/Latina/e/o"]
[null,null,"Black, African American, or African"]
[null,null,"Black, African American, or African & Hispanic/Latina/e/o"]
[null,null,"Hispanic/Latina/e/o"]
[null,null,"Middle Eastern or North African"]
[null,null,"Middle Eastern or North African & Hispanic/Latina/e/o"]
[null,null,"Native Hawaiian or Pacific Islander"]
[null,null,"Native Hawaiian or Pacific Islander & Hispanic/Latina/e/o"]
[null,null,"White"]
[null,null,"White & Hispanic/Latina/e/o"]
[null,null,"Multiple Races (not Hispanic/Latina/e/o)",1]
[null,null,"Multiple Races & Hispanic/Latina/e/o"]
["Parenting Youth Households","Chronic","Total Chronically Homeless Households"]
[null,null,"Total Chronic Homeless Persons"]
["Other",null,"Adults with a Serious Mental Illness"]
[null,null,"Adults with a Substance Use Disorder",1]
[null,null,"Adults with HIV/AIDS"]
[null,null,"Adult Survivors of Domestic Violence"]

{"sheet":"Project Info","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,2,2],[0,0,0,3],[5,0,7,2],[4,0,4,2],[3,0,3,2],[1,0,1,2]]}
["Project Information"]
["What is the agency name?"]
["What is the project name?"]
["Is this an Emergency Shelter or Transitional Housing project?",null,null,"Select Project Type"]
["Which CoC is the project located in?",null,null,"Select CoC"]
["Please provide contact information for your agency:",null,null,"Person completing this form:"]
[null,null,null,"Email address:"]
[null,null,null,"Phone number:"]

{"sheet":"1_Families TOTALS","index":4,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[[46,1,49,1],[4,0,45,0],[46,0,49,0],[4,1,12,1],[13,1,28,1],[29,1,43,1],[44,1,45,1]]}
["Household Type I:  Adult (18+) and children (<18) Households (aka: Families)"]
["•         This could be families with at least one parent and one child"]
["•         This could be groups with at least an adult and a minor who don’t share a parent-child relationship"]
["Please Read:",null,"This tab should show the total count of people in an adult/child household type. If there are parenting youth or veterans within this household type, you should complete the respective following tabs, (1a) and/or (1b).The data collected on the following two tabs (parenting youth and vets) should also be counted in this tab 1_Families TOTALS."]
["Persons in Households with at least one Adult (18+) and one Child (<18)","Person Counts","Total Households"]
[null,null,"Total People"]
[null,null,"Number of Persons (under age 18)"]
[null,null,"Number of Persons (18 - 24)"]
[null,null,"Number of Persons (25-34)"]
[null,null,"Number of Persons (35-44)"]
[null,null,"Number of Persons (45-54)"]
[null,null,"Number of Persons (55-64)"]
[null,null,"Number of Persons (65+)"]
[null,"Gender (select one per person)","Woman (Girl, if child)"]
[null,null,"Man (Boy, if child)"]
[null,null,"Cultrally Specific Identity"]
[null,null,"Transgender"]
[null,null,"Non-Binary"]
[null,null,"Questioning"]
[null,null,"Different Identity"]
[null,null,"More Than One Gender (complete question below)"]
[null,null,"If More Than One Gender, how many people reported gender identities that includes:"]
[null,null,"          Woman (Girl, if child)"]
[null,null,"          Man (Boy, if child)"]
[null,null,"          Cultrally Specific Identity"]
[null,null,"          Transgender"]
[null,null,"          Non-Binary"]
[null,null,"          Questioning"]
[null,null,"          Different Identity"]
[null,"Race/Ethnicity (select one per person)","American Indian, Alaska Native, or Indigenous"]
[null,null,"American Indian, Alaska Native, or Indigenous & Hispanic/Latina/e/o"]
[null,null,"Asian or Asian American"]
[null,null,"Asian or Asian American & Hispanic/Latina/e/o"]
[null,null,"Black, African American, or African"]
[null,null,"Black, African American, or African & Hispanic/Latina/e/o"]
[null,null,"Hispanic/Latina/e/o"]
[null,null,"Middle Eastern or North African"]
[null,null,"Middle Eastern or North African & Hispanic/Latina/e/o"]
[null,null,"Native Hawaiian or Pacific Islander"]
[null,null,"Native Hawaiian or Pacific Islander & Hispanic/Latina/e/o"]
[null,null,"White"]
[null,null,"White & Hispanic/Latina/e/o"]
[null,null,"Multiple Races (not Hispanic/Latina/e/o)"]
[null,null,"Multiple Races & Hispanic/Latina/e/o"]
[null,"Chronic","Total Chronically Homeless Households"]
[null,null,"Total Chronic Homeless Persons"]
["Other",null,"Adults with a Serious Mental Illness"]
[null,null,"Adults with a Substance Use Disorder"]
[null,null,"Adults with HIV/AIDS"]
[null,null,"Adult Survivors of Domestic Violence"]

{"sheet":"1a_Families_PY","index":5,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,0,2,2],[3,0,3,2],[46,1,49,1],[5,1,5,2],[6,0,12,0],[13,0,43,0],[44,0,45,0],[46,0,49,0],[29,1,43,1],[44,1,45,1],[6,1,12,1],[13,1,28,1],[4,0,4,2]]}
["Household Type I:  Adult (18+) and children (<18) Households (aka: Families)"]
["•         This could be families with a parent(s) who are both under 24 years old and a child"]
["Parenting youth"]
["            •     A youth (18-24) who identifies as the parent or legal guardian of one or more children who are present with or sleeping in the same place as that youth parent, where there is no person aged 25 or older in the household. For example, a mom (20yo) with a child (5yo) will count as a parenting youth. However, if grandma (50) is in the household too, this household will NOT count as a parenting youth household."]
["            •    For example, a mom (20yo) with a child (5yo) will count as a parenting youth. However, if grandma (50) is in the household too, this household will NOT count as a parenting youth household."]
["Please read:","Use this tab to record data about parenting youth who are in adult/child households. The person counts and chronic fields should include all people in the household. The demographic fields are only for the youth parents in the household."]
["Parenting Youth Households","Person Counts","Total Parenting Youth Households"]
[null,null,"Total People in Parenting Youth Households"]
[null,null,"Total Parenting Youth"]
[null,null,"Number of Parenting Youth (under age 18)"]
[null,null,"Number of Children (under age 18) with parenting youth (under age 18)"]
[null,null,"Number of Parenting Youth (age 18 to 24)"]
[null,null,"Number of Children (under age 18) with parenting youth (age 18 to 24)"]
["Youth Parents Only","Gender (select one per parenting youth)","Woman (Girl, if child)"]
[null,null,"Man (Boy, if child)"]
[null,null,"Cultrally Specific Identity"]
[null,null,"Transgender"]
[null,null,"Non-Binary"]
[null,null,"Questioning"]
[null,null,"Different Identity"]
[null,null,"More Than One Gender (complete question below)"]
[null,null,"If More Than One Gender, how many people reported gender identities that includes:"]
[null,null,"          Woman (Girl, if child)"]
[null,null,"          Man (Boy, if child)"]
[null,null,"          Cultrally Specific Identity"]
[null,null,"          Transgender"]
[null,null,"          Non-Binary"]
[null,null,"          Questioning"]
[null,null,"          Different Identity"]
[null,"Race/Ethnicity (select one per parenting youth)","American Indian, Alaska Native, or Indigenous"]
[null,null,"American Indian, Alaska Native, or Indigenous & Hispanic/Latina/e/o"]
[null,null,"Asian or Asian American"]
[null,null,"Asian or Asian American & Hispanic/Latina/e/o"]
[null,null,"Black, African American, or African"]
[null,null,"Black, African American, or African & Hispanic/Latina/e/o"]
[null,null,"Hispanic/Latina/e/o"]
[null,null,"Middle Eastern or North African"]
[null,null,"Middle Eastern or North African & Hispanic/Latina/e/o"]
[null,null,"Native Hawaiian or Pacific Islander"]
[null,null,"Native Hawaiian or Pacific Islander & Hispanic/Latina/e/o"]
[null,null,"White"]
[null,null,"White & Hispanic/Latina/e/o"]
[null,null,"Multiple Races (not Hispanic/Latina/e/o)"]
[null,null,"Multiple Races & Hispanic/Latina/e/o"]
["Parenting Youth Households","Chronic","Total Chronically Homeless Households"]
[null,null,"Total Chronic Homeless Persons"]
["Other",null,"Adults with a Serious Mental Illness"]
[null,null,"Adults with a Substance Use Disorder"]
[null,null,"Adults with HIV/AIDS"]
[null,null,"Adult Survivors of Domestic Violence"]

{"sheet":"1b_ Families_Vets","index":6,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,0,4,2],[3,0,3,2],[42,1,45,1],[5,1,5,2],[6,0,8,0],[9,0,39,0],[40,0,41,0],[42,0,45,0],[6,1,8,1],[9,1,24,1],[25,1,39,1],[40,1,41,1]]}
["Household Type I:  Adult (18+) and children (<18) Households (aka: Families)"]
["•         This could be families with at least one parent and one child"]
["•         This could be groups with at least an adult and a minor who don’t share a parent-child relationship"]
["Veterans"]
["             •     Veterans are adults (18+) who have served on active duty in the Armed Forces of the United States. This does not include inactive military reserves or the National Guard unless the person was called up to active duty."]
["Please read:","Use this tab to record data about veterans who are in adult/child households. The person counts and chronic fields should include all people in the household. The demographic fields are only for veterans in the household."]
["Veteran Households with at least one Adult (18+) and one Child (<18)","Person Counts","Total Number of Veteran Households"]
[null,null,"Total People in Veteran Households"]
[null,null,"Total Veterans"]
["Veterans Only","Gender (select one per veteran)","Woman (Girl, if child)"]
[null,null,"Man (Boy, if child)"]
[null,null,"Cultrally Specific Identity"]
[null,null,"Transgender"]
[null,null,"Non-Binary"]
[null,null,"Questioning"]
[null,null,"Different Identity"]
[null,null,"More Than One Gender (complete question below)"]
[null,null,"If More Than One Gender, how many people reported gender identities that includes:"]
[null,null,"          Woman (Girl, if child)"]
[null,null,"          Man (Boy, if child)"]
[null,null,"          Cultrally Specific Identity"]
[null,null,"          Transgender"]
[null,null,"          Non-Binary"]
[null,null,"          Questioning"]
[null,null,"          Different Identity"]
[null,"Race/Ethnicity (select one per veteran)","American Indian, Alaska Native, or Indigenous"]
[null,null,"American Indian, Alaska Native, or Indigenous & Hispanic/Latina/e/o"]
[null,null,"Asian or Asian American"]
[null,null,"Asian or Asian American & Hispanic/Latina/e/o"]
[null,null,"Black, African American, or African"]
[null,null,"Black, African American, or African & Hispanic/Latina/e/o"]
[null,null,"Hispanic/Latina/e/o"]
[null,null,"Middle Eastern or North African"]
[null,null,"Middle Eastern or North African & Hispanic/Latina/e/o"]
[null,null,"Native Hawaiian or Pacific Islander"]
[null,null,"Native Hawaiian or Pacific Islander & Hispanic/Latina/e/o"]
[null,null,"White"]
[null,null,"White & Hispanic/Latina/e/o"]
[null,null,"Multiple Races (not Hispanic/Latina/e/o)"]
[null,null,"Multiple Races & Hispanic/Latina/e/o"]
["Veteran Households with at least one Adult (18+) and one Child (<18)","Chronic","Total Chronically Homeless Households"]
[null,null,"Total Chronic Homeless Persons"]
["Other",null,"Adults with a Serious Mental Illness"]
[null,null,"Adults with a Substance Use Disorder"]
[null,null,"Adults with HIV/AIDS"]
[null,null,"Adult Survivors of Domestic Violence"]

{"sheet":"2_Singles TOTALS","index":7,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,0,5,1],[4,2,5,2],[47,0,50,0],[47,1,50,1],[6,0,46,0],[6,1,13,1],[14,1,29,1],[30,1,44,1],[45,1,46,1]]}
["Household Type iI:  Adult (18+) Only Households (aka: Singles)"]
["•         This could be one single adult"]
["•         This could be a group of single adults"]
["•         This could be a couple without children and both individuals are over 18"]
["Please Read:",null,"This tab should show the total count of people in an adult-only household type. If there are unaccompanied youth or veterans within this household type, you should complete the respective following tabs, (2a) and/or (2b).The data collected on the following two tabs (unaccompanied youth and vets) should also be included in this tab 2_ Singles TOTALS."]
[]
["Persons (18+) in Households without Children","Person Counts","Total Households"]
[null,null,"Total People"]
[null,null,"Number of Persons (18 - 24)"]
[null,null,"Number of Persons (25-34)"]
[null,null,"Number of Persons (35-44)"]
[null,null,"Number of Persons (45-54)"]
[null,null,"Number of Persons (55-64)"]
[null,null,"Number of Persons (65+)"]
[null,"Gender (select one per person)","Woman (Girl, if child)"]
[null,null,"Man (Boy, if child)"]
[null,null,"Cultrally Specific Identity"]
[null,null,"Transgender"]
[null,null,"Non-Binary"]
[null,null,"Questioning"]
[null,null,"Different Identity"]
[null,null,"More Than One Gender (complete question below)"]
[null,null,"If More Than One Gender, how many people reported gender identities that includes:"]
[null,null,"          Woman (Girl, if child)"]
[null,null,"          Man (Boy, if child)"]
[null,null,"          Cultrally Specific Identity"]
[null,null,"          Transgender"]
[null,null,"          Non-Binary"]
[null,null,"          Questioning"]
[null,null,"          Different Identity"]
[null,"Race/Ethnicity (select one per person)","American Indian, Alaska Native, or Indigenous"]
[null,null,"American Indian, Alaska Native, or Indigenous & Hispanic/Latina/e/o"]
[null,null,"Asian or Asian American"]
[null,null,"Asian or Asian American & Hispanic/Latina/e/o"]
[null,null,"Black, African American, or African"]
[null,null,"Black, African American, or African & Hispanic/Latina/e/o"]
[null,null,"Hispanic/Latina/e/o"]
[null,null,"Middle Eastern or North African"]
[null,null,"Middle Eastern or North African & Hispanic/Latina/e/o"]
[null,null,"Native Hawaiian or Pacific Islander"]
[null,null,"Native Hawaiian or Pacific Islander & Hispanic/Latina/e/o"]
[null,null,"White"]
[null,null,"White & Hispanic/Latina/e/o"]
[null,null,"Multiple Races (not Hispanic/Latina/e/o)"]
[null,null,"Multiple Races & Hispanic/Latina/e/o",1]
[null,"Chronic","Total Chronically Homeless Households"]
[null,null,"Total Chronic Homeless Persons"]
["Other",null,"Adults with a Serious Mental Illness"]
[null,null,"Adults with a Substance Use Disorder"]
[null,null,"Adults with HIV/AIDS"]
[null,null,"Adult Survivors of Domestic Violence"]

{"sheet":"2a_Singles_UY","index":8,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[[4,0,4,2],[5,0,5,2],[7,1,7,2],[45,0,48,0],[45,1,48,1],[8,0,44,0],[8,1,11,1],[12,1,27,1],[28,1,42,1],[43,1,44,1],[6,0,6,2]]}
["Household Type iI:  Adult (18+) Only Households (aka: Singles)"]
["•         This could be one single adult who is 18-24"]
["•         This could be a group of single adults who are 18-24"]
["•         This could be a couple without children and both individuals are 18-24"]
["Unaccompanied Youth"]
["            •     Unaccompanied youth are persons under age 25 who are not accompanied by a parent or guardian, or any other household member aged 25 or older, and who are not a parent presenting with or sleeping in the same place as his/her child(ren). Unaccompanied youth are single youth, youth couples, and groups of youth presenting together as a household. "]
["            •     For example, two partners aged 20 and 21 will count as unaccompanied youth. But, one partner age 24 and one partner age 25 will NOT count as unaccompanied youth."]
["Please read:","Use this tab to record data about unaccompanied youth who are in adult-only households."]
["Unaccompanied Youth","Person Count","Total Unaccompanied Youth Households"]
[null,null,"Total Unaccompanied Youth"]
[null,null,"Number of Unaccompanied Children (under age 18)"]
[null,null,"Number of Unaccompanied Young Adults (age 18 to 24)"]
[null,"Gender (select one per unaccompanied youth)","Woman (Girl, if child)"]
[null,null,"Man (Boy, if child)"]
[null,null,"Cultrally Specific Identity"]
[null,null,"Transgender"]
[null,null,"Non-Binary"]
[null,null,"Questioning"]
[null,null,"Different Identity"]
[null,null,"More Than One Gender (complete question below)"]
[null,null,"If More Than One Gender, how many people reported gender identities that includes:"]
[null,null,"          Woman (Girl, if child)"]
[null,null,"          Man (Boy, if child)"]
[null,null,"          Cultrally Specific Identity"]
[null,null,"          Transgender"]
[null,null,"          Non-Binary"]
[null,null,"          Questioning"]
[null,null,"          Different Identity"]
[null,"Race/Ethnicity (select one per unaccompanied youth)","American Indian, Alaska Native, or Indigenous"]
[null,null,"American Indian, Alaska Native, or Indigenous & Hispanic/Latina/e/o"]
[null,null,"Asian or Asian American"]
[null,null,"Asian or Asian American & Hispanic/Latina/e/o"]
[null,null,"Black, African American, or African"]
[null,null,"Black, African American, or African & Hispanic/Latina/e/o"]
[null,null,"Hispanic/Latina/e/o"]
[null,null,"Middle Eastern or North African"]
[null,null,"Middle Eastern or North African & Hispanic/Latina/e/o"]
[null,null,"Native Hawaiian or Pacific Islander"]
[null,null,"Native Hawaiian or Pacific Islander & Hispanic/Latina/e/o"]
[null,null,"White"]
[null,null,"White & Hispanic/Latina/e/o"]
[null,null,"Multiple Races (not Hispanic/Latina/e/o)"]
[null,null,"Multiple Races & Hispanic/Latina/e/o"]
[null,"Chronic","Total Chronically Homeless Households"]
[null,null,"Total Chronic Homeless Persons"]
["Other",null,"Adults with a Serious Mental Illness"]
[null,null,"Adults with a Substance Use Disorder"]
[null,null,"Adults with HIV/AIDS"]
[null,null,"Adult Survivors of Domestic Violence"]

{"sheet":"2b_Singles_Vets","index":9,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,0,4,2],[5,0,5,2],[6,1,6,2],[43,0,46,0],[43,1,46,1],[7,0,9,0],[7,1,9,1],[10,0,40,0],[10,1,25,1],[26,1,40,1],[41,0,42,0],[41,1,42,1]]}
["Household Type iI:  Adult (18+) Only Households (aka: Singles)"]
["•         This could be one single adult"]
["•         This could be a group of single adults"]
["•         This could be a couple without children and both individuals are over 18"]
["Veterans"]
["             •     Veterans are adults (18+) who have served on active duty in the Armed Forces of the United States. This does not include inactive military reserves or the National Guard unless the person was called up to active duty."]
["Please read:","Use this tab to record data about veterans who are in an adult-only household. The person counts and chronic fields should include all people in the household. The demographic fields are only for veterans in the household."]
["Veteran (18+) Households without Children","Person Counts","Total Number of Veteran Households"]
[null,null,"Total People in Veteran Households"]
[null,null,"Total Veterans"]
["Veterans Only","Gender (select one per veteran)","Woman (Girl, if child)"]
[null,null,"Man (Boy, if child)"]
[null,null,"Cultrally Specific Identity"]
[null,null,"Transgender"]
[null,null,"Non-Binary"]
[null,null,"Questioning"]
[null,null,"Different Identity"]
[null,null,"More Than One Gender (complete question below)"]
[null,null,"If More Than One Gender, how many people reported gender identities that includes:"]
[null,null,"          Woman (Girl, if child)"]
[null,null,"          Man (Boy, if child)"]
[null,null,"          Cultrally Specific Identity"]
[null,null,"          Transgender"]
[null,null,"          Non-Binary"]
[null,null,"          Questioning"]
[null,null,"          Different Identity"]
[null,"Race/Ethnicity (select one per veteran)","American Indian, Alaska Native, or Indigenous"]
[null,null,"American Indian, Alaska Native, or Indigenous & Hispanic/Latina/e/o"]
[null,null,"Asian or Asian American"]
[null,null,"Asian or Asian American & Hispanic/Latina/e/o"]
[null,null,"Black, African American, or African"]
[null,null,"Black, African American, or African & Hispanic/Latina/e/o"]
[null,null,"Hispanic/Latina/e/o"]
[null,null,"Middle Eastern or North African"]
[null,null,"Middle Eastern or North African & Hispanic/Latina/e/o"]
[null,null,"Native Hawaiian or Pacific Islander"]
[null,null,"Native Hawaiian or Pacific Islander & Hispanic/Latina/e/o"]
[null,null,"White"]
[null,null,"White & Hispanic/Latina/e/o"]
[null,null,"Multiple Races (not Hispanic/Latina/e/o)"]
[null,null,"Multiple Races & Hispanic/Latina/e/o"]
["Veteran (18+) Households without Children","Chronic","Total Chronically Homeless Households"]
[null,null,"Total Chronic Homeless Persons"]
["Other",null,"Adults with a Serious Mental Illness"]
[null,null,"Adults with a Substance Use Disorder"]
[null,null,"Adults with HIV/AIDS"]
[null,null,"Adult Survivors of Domestic Violence"]

{"sheet":"3_Only Children TOTALS","index":10,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,0,6,1],[5,2,6,2],[7,0,41,0],[9,1,24,1],[25,1,39,1],[40,1,41,1],[7,1,8,1]]}
["Household Type III:  Children (<18) Only Households "]
["•         This could be one single person under 18"]
["•         This could be a group of persons under 18"]
["•         This could be a couple without children and both individuals are under 18"]
["•         This could be a couple with children under 18 and both individuals are under 18"]
["Please Read:",null,"This tab should show the total count of people in a child-only household type. If there are parenting youth within this household type, you should complete the following tab, 3a. The data collected on the following tab, 3a_Only Children_PY, should also be included in this tab 3_Only Children TOTALS."]
[]
["Persons in Households with only Children <18","Person Counts","Total Households"]
[null,null,"Total People"]
[null,"Gender (select one per person)","Woman (Girl, if child)"]
[null,null,"Man (Boy, if child)"]
[null,null,"Cultrally Specific Identity"]
[null,null,"Transgender"]
[null,null,"Non-Binary"]
[null,null,"Questioning"]
[null,null,"Different Identity"]
[null,null,"More Than One Gender (complete question below)"]
[null,null,"If More Than One Gender, how many people reported gender identities that includes:"]
[null,null,"          Woman (Girl, if child)"]
[null,null,"          Man (Boy, if child)"]
[null,null,"          Cultrally Specific Identity"]
[null,null,"          Transgender"]
[null,null,"          Non-Binary"]
[null,null,"          Questioning"]
[null,null,"          Different Identity"]
[null,"Race/Ethnicity (select one per person)","American Indian, Alaska Native, or Indigenous"]
[null,null,"American Indian, Alaska Native, or Indigenous & Hispanic/Latina/e/o"]
[null,null,"Asian or Asian American"]
[null,null,"Asian or Asian American & Hispanic/Latina/e/o"]
[null,null,"Black, African American, or African"]
[null,null,"Black, African American, or African & Hispanic/Latina/e/o"]
[null,null,"Hispanic/Latina/e/o"]
[null,null,"Middle Eastern or North African"]
[null,null,"Middle Eastern or North African & Hispanic/Latina/e/o"]
[null,null,"Native Hawaiian or Pacific Islander"]
[null,null,"Native Hawaiian or Pacific Islander & Hispanic/Latina/e/o"]
[null,null,"White"]
[null,null,"White & Hispanic/Latina/e/o"]
[null,null,"Multiple Races (not Hispanic/Latina/e/o)"]
[null,null,"Multiple Races & Hispanic/Latina/e/o"]
[null,"Chronic","Total Chronically Homeless Households"]
[null,null,"Total Chronic Homeless Persons"]

{"sheet":"3a_Only Children_PY","index":11,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,0,3,2],[4,0,4,2],[5,0,5,2],[42,0,43,0],[42,1,43,1],[6,1,6,2],[7,0,10,0],[7,1,10,1],[11,0,41,0],[11,1,26,1],[27,1,41,1]]}
["Household Type III:  Children (<18) Only Households "]
["•         This could be single person under 18 with a child under 18"]
["•         This could be a couple who are both under 18 with a child/children under 18"]
["Parenting youth (under 18)"]
["            •     A youth (<18) who identifies as the parent or legal guardian of one or more children who are present with or sleeping in the same place as that youth parent, where there is no person aged 19 or older in the household. For example, a mom (17yo) with a child (5yo) will count as a parenting youth. However, if dad (18) is in the household too, this household will NOT count as a child-only parenting youth household."]
["            •   For example, a mom (17yo) with a child (5yo) will count as a parenting youth. However, if dad (18) is in the household too, this household will NOT count as a child-only parenting youth household."]
["Please read:","Use this tab to record data about parenting youth who are in child-only households. The person counts and chronic fields should include all people in the household. The demographic fields are only for the youth parents in the household."]
["Parenting Youth Households","Person Counts","Total Parenting Youth Households"]
[null,null,"Total People in Parenting Youth Households"]
[null,null,"Total Parenting Youth"]
[null,null,"Number of Children (under age 18) with parenting youth (under age 18)"]
["Youth Parents Only","Gender (select one per parenting youth)","Woman (Girl, if child)"]
[null,null,"Man (Boy, if child)"]
[null,null,"Cultrally Specific Identity"]
[null,null,"Transgender"]
[null,null,"Non-Binary"]
[null,null,"Questioning"]
[null,null,"Different Identity"]
[null,null,"More Than One Gender (complete question below)"]
[null,null,"If More Than One Gender, how many people reported gender identities that includes:"]
[null,null,"          Woman (Girl, if child)"]
[null,null,"          Man (Boy, if child)"]
[null,null,"          Cultrally Specific Identity"]
[null,null,"          Transgender"]
[null,null,"          Non-Binary"]
[null,null,"          Questioning"]
[null,null,"          Different Identity"]
[null,"Race/Ethnicity (select one per parenting youth)","American Indian, Alaska Native, or Indigenous"]
[null,null,"American Indian, Alaska Native, or Indigenous & Hispanic/Latina/e/o"]
[null,null,"Asian or Asian American"]
[null,null,"Asian or Asian American & Hispanic/Latina/e/o"]
[null,null,"Black, African American, or African"]
[null,null,"Black, African American, or African & Hispanic/Latina/e/o"]
[null,null,"Hispanic/Latina/e/o"]
[null,null,"Middle Eastern or North African"]
[null,null,"Middle Eastern or North African & Hispanic/Latina/e/o"]
[null,null,"Native Hawaiian or Pacific Islander"]
[null,null,"Native Hawaiian or Pacific Islander & Hispanic/Latina/e/o"]
[null,null,"White"]
[null,null,"White & Hispanic/Latina/e/o"]
[null,null,"Multiple Races (not Hispanic/Latina/e/o)"]
[null,null,"Multiple Races & Hispanic/Latina/e/o"]
["Parenting Youth Households","Chronic","Total Chronically Homeless Households"]
[null,null,"Total Chronic Homeless Persons"]