{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","1a","1b","2","3","4","5","6","Subpopulations","KG Notes"],"not_rendered":{"charts":23,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[17,2,17,18],[18,2,18,18],[20,1,20,18],[24,1,24,18],[1,1,1,19],[14,1,14,19],[4,1,4,18],[6,1,6,18],[8,1,8,18],[12,1,12,18],[16,2,16,18]]}
[]
[null,"Outcome goal worksheet\nPurpose and instructions"]
[null,"About this resource"]
[]
[null,"This outcome goal worksheet is intended to help communities work through their outcome goal setting process related to HHAP 3 proposals. Its use is not required for setting outcome goals.  "]
[]
[null,"This resource is intended to offer communities a way of looking at the Baseline data and thinking through actions they may take to impact system-level outcomes by the end of CY2024. Note that the goal achievement timeframe set by the State is Fiscal Year 2024 ending June 2024. This workbook uses calendar year throughout because the HDIS data communities have received to date is based on past calendar year performance. Communities should keep this in mind as they establish any annual progress targets"]
[]
[null,"This worksheet DOES generate possible forward-looking outcome goals, and DOES NOT predict outcomes."]
[]
[null,"How to use this resource"]
[]
[null,"In preparation for the HHAP 3 application process, CAL ICH distributed a community-specific data file titled \"Baseline Data for Outcome Goals.\" The baseline data will be the data source used by CAL ICH to monitor achievement of outcome goals. As such, it should be used here to inform the goal setting process within this framework. "]
[]
[null,"On each tab in this workbook, there are three key sections:"]
[]
[null,"1)","HDIS Baseline data: You are first prompted to enter your community's outcome data from the Baseline Data for Outcome Goals file.  Only enter data in the cells highlighted yellow."]
[null,"2)","Meaning making: Past performance is visualized with a trend line and a future projection based on the current trajectory. You are asked to interpret this trend and discuss factors that are likely to influence future performance. Discussion questions are provided for each measure to facilitate this discussion/process.  "]
[null,"3)","Goal setting: After you understand the past data and factors likely to influence outcomes, you are prompted to enter a potential performance goal for calendar year 2024. This is visualized as a new trend line as well as showing the year by year changes that would be needed to make the goal. Look at the new goal trajectory and decide whether it represents an ambitious but achievable goal given your local community context. You can revise your goal as needed and see the impact of different scenarios. Discussion questions are provided to help facilitate this discussion/process.  "]
[]
[null,"In addition to thinking about system-level performance goal setting, this resource provides a complementary exercise on each tab to help you hone-in on a potential equity-related outcome goal for populations disproportionately affected by homelessness. Using this portion of the resource requires familiarity with the detail tab on subpopulations. It is recommended that the detailed subpopulation data be reviewed in advance and one or more subpopulations is already identified to explore for each measure. "]
[]
[null,"Who to contact if you need support using this resource"]
[]
[null,"If you would like support using this tool within your community’s HHAP 3 goal planning process, please contact Focus Strategies to schedule a consultation.  "]
[]
[null,"Tara Carruth"]
[null,"tara@focusstrategies.net"]

{"sheet":"1a","index":1,"n_rows":78,"n_cols":11,"rows_kept":78,"cut":false,"hidden":false,"merged":[[30,3,30,11],[45,3,45,11],[49,3,49,11],[59,3,59,11],[40,3,40,4],[55,6,55,9],[56,3,56,4],[33,3,33,9],[39,6,39,9],[46,3,46,11],[36,3,36,11],[40,6,40,9],[56,6,56,9],[41,3,41,4],[27,1,27,19],[1,1,1,19],[6,6,6,9],[7,3,7,4],[21,3,21,4],[20,6,20,9],[12,3,12,11],[24,3,24,11],[14,3,14,11],[7,6,7,9],[21,6,21,9],[8,3,8,4]]}
[]
[null,"Measure #1a: Change in the number of persons experiencing homelessness\nAs measured by the number of individuals accessing services who are homeless."]
[]
[null,"①",null,"Enter HDIS data from CY2020 Baseline Goals tab, cells D5-F5, in the highlighted cells."]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G10","v":{"$error":"#N/A"}},{"$f":"H10","v":{"$error":"#N/A"}},{"$f":"I10","v":{"$error":"#N/A"}},{"$f":"J10","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),D6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),E6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),F6)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Projections based on average annual change of \"&(F6-D6)/2&\" individuals\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (F6-D6)/D6), \"\")","v":""},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (J6-F6)/F6), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F6=\"\", E6=\"\", D6=\"\"), NA(), F6)","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+F10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+G10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+H10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+I10","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F10","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),F11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),G11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),H11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),I11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Consider what may be contributing to and influence these outcomes."]
[null,null,null,"• Does the data match what your community is experiencing?\n• Were there changes in how data was collected with your community during this time ('18 - '20) that might account for upward or downward changes?\n• What recent changes in the community could be influencing this outcome (e.g. decreasing vacancy rates, increased outreach efforts, etc.) \n• What programs and efforts within the CoC influence this goal area most directly? \n• Do you plan to introduce new efforts that are likely to influence this outcome (e.g. as a result of HHAP funding or other resources)?  "]
[]
[null,"②b",null,"Given the trajectory of past data and the influence of factors identified in 2a above, what is the likely direction this outcome will trend over the next few years (e.g., up steeply, up slightly, remain flat, go down slightly, go down steeply)?"]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G11","v":{"$error":"#N/A"}},{"$f":"H11","v":{"$error":"#N/A"}},{"$f":"I11","v":{"$error":"#N/A"}},{"$f":"J11","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR((J20-F7)/F7, \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③b",null,"Review the result of this potential goal. "]
[null,null,null,"• Look at the new line on the graph in Visual A.  Does the trajectory of the outcome goal seem reasonable given the contextual factors identified in step 2a? \n• To reach this goal, you will need to make average progress each year as shown in the cells above. Does this seem achievable?  \n• Continue working with this data to see how different goal targets change the trajectory."]
[]
[]
[null,"Measure #1a: Setting your goal for underserved populations and populations disproportionately impacted by homelessness"]
[]
[null,"①a",null,"Explore the data and select a subpopulation."]
[null,null,null,"Review the data on the sheet titled \"Measure 7 Pop Groups Detail\" to get a sense of how subpopulations may be disproportionately represented as it relates to this outcome measure. You'll find data for Measure 1a in column B.\n\nYou may also want to see which populations your landscape assessment identified as being underserved."]
[]
[null,null,null,"Identify a subpopulation from the dropdown menu and indicate it here."]
[]
[]
[null,"①b",null,"Enter the data related to this subpopulation below in the highlighted cells. "]
[null,null,null,"If using the Population Detail tab, enter the data related to this subpopulation for CY2018 - CY2020 below. (Note you could also use Point in time count data or other data you have on trends for this analysis.)"]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G43","v":{"$error":"#N/A"}},{"$f":"H43","v":{"$error":"#N/A"}},{"$f":"I43","v":{"$error":"#N/A"}},{"$f":"J43","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),D39)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),E39)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),F39)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F39=\"\",E39=\"\",D39=\"\"),\"\", \"Projection based on average annual change of \"&(F39-D39)/2&\" individuals\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D39=\"\", E39=\"\", F39=\"\"), NA(), (F39-D39)/D39), \"\")","v":""},{"$f":"IF(OR(F39=\"\",E39=\"\",D39=\"\"),\"\",\"Annual change calculation: (CY20 - CY18) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D39=\"\", E39=\"\", F39=\"\"), NA(), (J39-F39)/F39), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F39=\"\", E39=\"\", D39=\"\"), NA(), F39)","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+F43","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+G43","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+H43","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+I43","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F43","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),F44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),G44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),H44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),I44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Examine the rate of change and potential disproportionalities."]
[null,null,null,"Using Visual B and C, consider the subpopulation's a) size relative to all persons and b) rate of change over CY2018 - CY2020. Equity questions to consider: "]
[null,null,null,"● Is the rate of change for the subpopulation greater or less than that of all persons?  \n● Is the subpopulation disproportionately represented among those accessing services as compared to the \n   region's overall, low-income, and/or homeless population? \n● What does your landscape assessment show in terms of this population’s services?"]
[]
[null,"②b",null,"Consider potential strategies that promote equity."]
[null,null,null,"What types of programmatic, policy, or operational changes could be implemented to support a more equitable outcome for this subpopulation? If implemented, how might these strategies affect this outcome for this subpopulation? "]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G44","v":{"$error":"#N/A"}},{"$f":"H44","v":{"$error":"#N/A"}},{"$f":"I44","v":{"$error":"#N/A"}},{"$f":"J44","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(D55=\"\", NA(), (J55-F40)/F40), \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③a",null,"Review the result of this potential goal."]
[null,null,null,"Using Visual C, compare the rates of change for all persons and the subpopulation. Does the projected change for the subpopulation make sense given the intended strategies to promote greater equity? If this does not seem ambitious enough, or achievable, then experiment with a using a different goal target."]
[]
[]
[]
[null,null,null,{"$f":"IF(OR($D$39=\"\", $E$39=\"\", $F$39=\"\"), N/A(), D39/D6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$39=\"\", $E$39=\"\", $F$39=\"\"), N/A(), E39/E6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$39=\"\", $E$39=\"\", $F$39=\"\"), N/A(), F39/F6)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"1-D64","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,"Remainder"]
[null,null,null,null,null,null,{"$f":"G55/G20","v":{"$error":"#N/A"}},{"$f":"H55/H20","v":{"$error":"#N/A"}},{"$f":"I55/I20","v":{"$error":"#N/A"}},{"$f":"J55/J20","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]
[null,null,null,null,null,null,{"$f":"1-G66","v":{"$error":"#N/A"}},{"$f":"1-H66","v":{"$error":"#N/A"}},{"$f":"1-I66","v":{"$error":"#N/A"}},{"$f":"1-J66","v":{"$error":"#N/A"}},"Remainder"]
[]
[]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(H20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(I20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(J20-$F$6)/$F$6","v":{"$error":"#N/A"}},"All persons rate of growth from 2020"]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G55-$F$39)/$F$39","v":{"$error":"#N/A"}},{"$f":"(H55-$F$39)/$F$39","v":{"$error":"#N/A"}},{"$f":"(I55-$F$39)/$F$39","v":{"$error":"#N/A"}},{"$f":"(J55-$F$39)/$F$39","v":{"$error":"#N/A"}},"Subpopulation rate of growth from 2020"]
[]
[]
[null,null,null,"Baseline Year\nCY2018\nCY2020","Year 1\nCY2019\nCY2021","Year 2\nCY2020\nCY2022","Year 3\n\nCY2023","Year 4\n\nCY2024","\n\nCY2023","\n\nCY2024"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),F8)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"All Persons Past (CY2018 - CY2020)"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),F22)","v":{"$error":"#N/A"}},null,null,"All Persons Goal (CY2020 - CY2024)"]
[null,null,null,{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),F41)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"IF(OR(D39=\"\",E39=\"\",F39=\"\",D55=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D39=\"\",E39=\"\",F39=\"\",D55=\"\"),NA(),F57)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]

{"sheet":"1b","index":2,"n_rows":78,"n_cols":11,"rows_kept":78,"cut":false,"hidden":false,"merged":[[1,1,1,19],[6,6,6,9],[7,3,7,4],[20,6,20,9],[21,3,21,4],[12,3,12,11],[14,3,14,11],[8,3,8,4],[7,6,7,9],[21,6,21,9],[24,3,24,11],[36,3,36,11],[27,1,27,19],[30,3,30,11],[33,3,33,9],[59,3,59,11],[39,6,39,9],[40,3,40,4],[46,3,46,11],[49,3,49,11],[56,6,56,9],[40,6,40,9],[45,3,45,11],[41,3,41,4],[55,6,55,9],[56,3,56,4]]}
[]
[null,"Measure #1b: Reducing the number of persons experiencing unsheltered homelessness on a daily basis\nAs measured by the PIT count of unsheltered individuals. "]
[]
[null,"①",null,"Enter HDIS data from CY2020 Baseline Goals tab, cells D10—F10, in the highlighted cells."]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G10","v":{"$error":"#N/A"}},{"$f":"H10","v":{"$error":"#N/A"}},{"$f":"I10","v":{"$error":"#N/A"}},{"$f":"J10","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),D6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),E6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),F6)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Projection based on average annual change of \"&(F6-D6)/2&\" individuals\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (F6-D6)/D6), \"\")","v":""},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (J6-F6)/F6), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F6=\"\", E6=\"\", D6=\"\"), NA(), F6)","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+F10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+G10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+H10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+I10","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F10","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),F11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),G11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),H11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),I11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Consider what may be contributing to and influence these outcomes."]
[null,null,null,"• Does this data match what your community is experiencing?\n• Were there changes in how data was collected with your community during this time ('18 - '20) that might account for upward or downward changes?\n• What recent changes in the community could be influencing this outcome (e.g. increases/decreases in available shelter, etc.) \n• What programs and efforts within the CoC influence this goal area most directly? \n• Do you plan to introduce new efforts that are likely to influence this outcome (e.g. as a result of HHAP funding or other resources)? "]
[]
[null,"②b",null,"Given the trajectory of past data and the influence of factors identified in 2a above, what is the likely direction this outcome will trend over the next few years (e.g., up steeply, up slightly, remain flat, go down slightly, go down steeply)?"]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G11","v":{"$error":"#N/A"}},{"$f":"H11","v":{"$error":"#N/A"}},{"$f":"I11","v":{"$error":"#N/A"}},{"$f":"J11","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR((J20-F7)/F7, \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③b",null,"Review the result of this potential goal."]
[null,null,null,"• Look at the new line on the graph in Visual A.  Does the trajectory of the outcome goal seem reasonable given the contextual factors identified in step 2a? \n• To reach this goal, you will need to make average progress each year as shown in the cells above. Does this seem achievable?  \n• Continue working with this data to see how different goal targets change the trajectory."]
[]
[]
[null,"Measure #1b: Setting your goal for underserved populations and populations disproportionately impacted by homelessness"]
[]
[null,"①a",null,"Explore the data and select a subpopulation."]
[null,null,null,"Review the data on the sheet titled \"Measure 7 Pop Groups Detail\" to get a sense of how subpopulations may be disproportionately represented as it relates to this outcome measure. You'll find data for Measure 1b in column C. \n\nYou may also want to see which populations your landscape assessment identified as being underserved."]
[]
[null,null,null,"Identify a subpopulation from the dropdown menu and indicate it here."]
[]
[]
[null,"①b",null,"Enter the data related to this subpopulation below in the highlighted cells. "]
[null,null,null,"If using the Population Detail tab, enter the data related to this subpopulation for CY2018 - CY2020 below."]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G43","v":{"$error":"#N/A"}},{"$f":"H43","v":{"$error":"#N/A"}},{"$f":"I43","v":{"$error":"#N/A"}},{"$f":"J43","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),D39)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),E39)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),F39)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F39=\"\",E39=\"\",D39=\"\"),\"\", \"Projection based on average annual change of \"&(F39-D39)/2&\" individuals\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D39=\"\", E39=\"\", F39=\"\"), NA(), (F39-D39)/D39), \"\")","v":""},{"$f":"IF(OR(F39=\"\",E39=\"\",D39=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D39=\"\", E39=\"\", F39=\"\"), NA(), (J39-F39)/F39), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F39=\"\", E39=\"\", D39=\"\"), NA(), F39)","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+F43","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+G43","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+H43","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+I43","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F43","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),F44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),G44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),H44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),I44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Examine the rate of change and potential disproportionalities."]
[null,null,null,"Using Visual B and C, consider the subpopulation's a) size relative to all persons and b) rate of change over CY2018 - CY2020. Equity questions to consider: "]
[null,null,null,"● Is the rate of change for the subpopulation greater or less than that of all persons?  \n● Is the subpopulation disproportionately represented among those experiencing unsheltered homelessness as compared to the overall homeless population? As compared to the region's population?  \n● What does your landscape assessment show in terms of this population's services? "]
[]
[null,"②b",null,"Consider potential strategies that promote equity."]
[null,null,null,"What types of programmatic, policy, or operational changes could be implemented to support a more equitable outcome for this subpopulation? If implemented, how might these strategies affect this outcome for this subpopulation? "]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G44","v":{"$error":"#N/A"}},{"$f":"H44","v":{"$error":"#N/A"}},{"$f":"I44","v":{"$error":"#N/A"}},{"$f":"J44","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(D55=\"\", NA(), (J55-F40)/F40), \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③a",null,"Review the result of this potential goal."]
[null,null,null,"Using Visual C, compare the rates of change for all persons and the subpopulation. Does the projected change for the subpopulation make sense given the intended goal of strategies to promote greater equity? If this does not seem ambitious enough, or achievable, then experiment with a using a different goal target."]
[]
[]
[]
[null,null,null,{"$f":"IF(OR($D$39=\"\", $E$39=\"\", $F$39=\"\"), N/A(), D39/D6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$39=\"\", $E$39=\"\", $F$39=\"\"), N/A(), E39/E6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$39=\"\", $E$39=\"\", $F$39=\"\"), N/A(), F39/F6)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"1-D64","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,"Remainder"]
[null,null,null,null,null,null,{"$f":"G55/G20","v":{"$error":"#N/A"}},{"$f":"H55/H20","v":{"$error":"#N/A"}},{"$f":"I55/I20","v":{"$error":"#N/A"}},{"$f":"J55/J20","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]
[null,null,null,null,null,null,{"$f":"1-G66","v":{"$error":"#N/A"}},{"$f":"1-H66","v":{"$error":"#N/A"}},{"$f":"1-I66","v":{"$error":"#N/A"}},{"$f":"1-J66","v":{"$error":"#N/A"}},"Remainder"]
[]
[]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(H20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(I20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(J20-$F$6)/$F$6","v":{"$error":"#N/A"}},"All persons rate of growth from 2020"]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G55-$F$39)/$F$39","v":{"$error":"#N/A"}},{"$f":"(H55-$F$39)/$F$39","v":{"$error":"#N/A"}},{"$f":"(I55-$F$39)/$F$39","v":{"$error":"#N/A"}},{"$f":"(J55-$F$39)/$F$39","v":{"$error":"#N/A"}},"Subpopulation rate of growth from 2020"]
[]
[]
[null,null,null,"Baseline Year\nCY2018\nCY2020","Year 1\nCY2019\nCY2021","Year 2\nCY2020\nCY2022","Year 3\n\nCY2023","Year 4\n\nCY2024","\n\nCY2023","\n\nCY2024"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),F8)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"All Persons Past (CY2018 - CY2020)"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),F22)","v":{"$error":"#N/A"}},null,null,"All Persons Goal (CY2020 - CY2024)"]
[null,null,null,{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),F41)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"IF(OR(D39=\"\",E39=\"\",F39=\"\",D55=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D39=\"\",E39=\"\",F39=\"\",D55=\"\"),NA(),F57)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]

{"sheet":"2","index":3,"n_rows":78,"n_cols":11,"rows_kept":78,"cut":false,"hidden":false,"merged":[[1,1,1,19],[6,6,6,9],[7,3,7,4],[20,6,20,9],[21,3,21,4],[12,3,12,11],[14,3,14,11],[8,3,8,4],[7,6,7,9],[21,6,21,9],[24,3,24,11],[36,3,36,11],[27,1,27,19],[30,3,30,11],[33,3,33,9],[55,6,55,9],[56,3,56,4],[59,3,59,11],[39,6,39,9],[40,3,40,4],[56,6,56,9],[46,3,46,11],[49,3,49,11],[40,6,40,9],[45,3,45,11],[41,3,41,4]]}
[]
[null,"Measure #2: Reducing the number of persons who become homeless for the first time "]
[]
[null,"①",null,"Enter HDIS data from Baseline Goals tab, cells D15-F15, in the highlighted cells."]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G10","v":{"$error":"#N/A"}},{"$f":"H10","v":{"$error":"#N/A"}},{"$f":"I10","v":{"$error":"#N/A"}},{"$f":"J10","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),D6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),E6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),F6)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Projection based on average annual change of \"&(F6-D6)/2&\" individuals\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (F6-D6)/D6), \"\")","v":""},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (J6-F6)/F6), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F6=\"\", E6=\"\", D6=\"\"), NA(), F6)","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+F10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+G10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+H10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+I10","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F10","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),F11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),G11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),H11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),I11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Consider what may be contributing to and influence these outcomes."]
[null,null,null,"• Does this data match what your community is experiencing?\n• Were there changes in how data was collected with your community during this time ('18 - '20) that might account for upward or downward changes?\n• What recent changes in the community could be influencing this outcome (e.g., increasing rents, investments in homeless prevention, etc.)\n• What programs and efforts within the CoC influence this goal area most directly? \n• Do you plan to introduce new efforts that are likely to influence this outcome (e.g., because of HHAP funding or other resources)? "]
[]
[null,"②b",null,"Given the trajectory of past data and the influence of factors identified in 2a above, what is the likely direction this outcome will trend over the next few years (e.g., up steeply, up slightly, remain flat, go down slightly, go down steeply)?"]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G11","v":{"$error":"#N/A"}},{"$f":"H11","v":{"$error":"#N/A"}},{"$f":"I11","v":{"$error":"#N/A"}},{"$f":"J11","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR((J20-F7)/F7, \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③b",null,"Review the result of this potential goal. "]
[null,null,null,"• Look at the new line on the graph in Visual A.  Does the trajectory of the outcome goal seem reasonable given the contextual factors identified in step 2a? \n• To reach this goal, you will need to make average progress each year as shown in the cells above. Does this seem achievable?  \n• Continue working with this data to see how different goal targets change the trajectory."]
[]
[]
[null,"Measure #2: Setting your goal for underserved populations and populations disproportionately impacted by homelessness"]
[]
[null,"①a",null,"Explore the data and select a subpopulation."]
[null,null,null,"Review the data on the sheet titled \"Measure 7 Pop Groups Detail\" to get a sense of how subpopulations may be disproportionately represented as it relates to this outcome measure. You'll find data for Measure 2 in column D.\n\nYou may also want to see which populations your landscape assessment identified as having high rates of new entries to homelessness"]
[]
[null,null,null,"Identify a subpopulation from the dropdown menu and indicate it here."]
[]
[]
[null,"①b",null,"Enter the data related to this subpopulation for CY2018, CY2019, and CY2020 below in the highlighted cells. "]
[null,null,null,"If using the Population Detail tab, enter the data related to this subpopulation for CY2018 - CY2020 below. (Note you could also use Point in time count data or other data you have on trends for this analysis.)"]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G43","v":{"$error":"#N/A"}},{"$f":"H43","v":{"$error":"#N/A"}},{"$f":"I43","v":{"$error":"#N/A"}},{"$f":"J43","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),D39)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),E39)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),F39)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F39=\"\",E39=\"\",D39=\"\"),\"\", \"Projection based on average annual change of \"&(F39-D39)/2&\" individuals\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D39=\"\", E39=\"\", F39=\"\"), NA(), (F39-D39)/D39), \"\")","v":""},{"$f":"IF(OR(F39=\"\",E39=\"\",D39=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D39=\"\", E39=\"\", F39=\"\"), NA(), (J39-F39)/F39), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F39=\"\", E39=\"\", D39=\"\"), NA(), F39)","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+F43","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+G43","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+H43","v":{"$error":"#N/A"}},{"$f":"(F39-D39)/2+I43","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F43","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),F44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),G44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),H44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$55=\"\",NA(),I44+(($D$55-$F$39)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Examine the rate of change and potential disproportionalities."]
[null,null,null,"Using Visual B and C, consider the subpopulation's a) size relative to all persons and b) rate of change over CY2018 - CY2020. Equity questions to consider: "]
[null,null,null,"● Is the rate of change for the subpopulation greater or less than that of all persons?  \n● Is the subpopulation disproportionately represented among those newly experiencing homelessness as compared to the overall homeless population? A compared to the region’s population? \n● What does your landscape assessment show in terms of this population’s services?"]
[]
[null,"②b",null,"Consider potential strategies that promote equity."]
[null,null,null,"What types of programmatic, policy, or operational changes could be implemented to support a more equitable outcome for this subpopulation? If implemented, how might these strategies affect this outcome for this subpopulation? "]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G44","v":{"$error":"#N/A"}},{"$f":"H44","v":{"$error":"#N/A"}},{"$f":"I44","v":{"$error":"#N/A"}},{"$f":"J44","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(D55=\"\", NA(), (J55-F40)/F40), \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③a",null,"Review the result of this potential goal."]
[null,null,null,"Using Visual C, compare the rates of change for all persons and the subpopulation. Does the projected change for the subpopulation make sense given the intended goal of strategies to promote greater equity? If this does not seem ambitious enough, or achievable, then experiment with a using a different goal target."]
[]
[]
[]
[null,null,null,{"$f":"IF(OR($D$39=\"\", $E$39=\"\", $F$39=\"\"), N/A(), D39/D6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$39=\"\", $E$39=\"\", $F$39=\"\"), N/A(), E39/E6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$39=\"\", $E$39=\"\", $F$39=\"\"), N/A(), F39/F6)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"1-D64","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,"Remainder"]
[null,null,null,null,null,null,{"$f":"G55/G20","v":{"$error":"#N/A"}},{"$f":"H55/H20","v":{"$error":"#N/A"}},{"$f":"I55/I20","v":{"$error":"#N/A"}},{"$f":"J55/J20","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]
[null,null,null,null,null,null,{"$f":"1-G66","v":{"$error":"#N/A"}},{"$f":"1-H66","v":{"$error":"#N/A"}},{"$f":"1-I66","v":{"$error":"#N/A"}},{"$f":"1-J66","v":{"$error":"#N/A"}},"Remainder"]
[]
[]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(H20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(I20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(J20-$F$6)/$F$6","v":{"$error":"#N/A"}},"All persons rate of growth from 2020"]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G55-$F$39)/$F$39","v":{"$error":"#N/A"}},{"$f":"(H55-$F$39)/$F$39","v":{"$error":"#N/A"}},{"$f":"(I55-$F$39)/$F$39","v":{"$error":"#N/A"}},{"$f":"(J55-$F$39)/$F$39","v":{"$error":"#N/A"}},"Subpopulation rate of growth from 2020"]
[]
[]
[null,null,null,"Baseline Year\nCY2018\nCY2020","Year 1\nCY2019\nCY2021","Year 2\nCY2020\nCY2022","Year 3\n\nCY2023","Year 4\n\nCY2024","\n\nCY2023","\n\nCY2024"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),F8)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"All Persons Past (CY2018 - CY2020)"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),F22)","v":{"$error":"#N/A"}},null,null,"All Persons Goal (CY2020 - CY2024)"]
[null,null,null,{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$39=\"\",$E$39=\"\",$F$39=\"\"),NA(),F41)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"IF(OR(D39=\"\",E39=\"\",F39=\"\",D55=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D39=\"\",E39=\"\",F39=\"\",D55=\"\"),NA(),F57)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]

{"sheet":"3","index":4,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":false,"merged":[[40,3,40,4],[1,1,1,19],[6,6,6,9],[7,3,7,4],[20,6,20,9],[21,3,21,4],[12,3,12,11],[14,3,14,11],[8,3,8,4],[55,3,55,4],[58,3,58,11],[7,6,7,9],[21,6,21,9],[45,3,45,11],[48,3,48,11],[54,6,54,9],[39,6,39,9],[55,6,55,9],[44,3,44,11],[24,3,24,11],[27,1,27,19],[30,3,30,11],[33,3,33,9],[38,6,38,9],[39,3,39,4]]}
[]
[null,"Measure #3: Increasing the number of people exiting homelessness into permanent housing \nAs measured by system exits to permanent housing (does not include move-ins to RRH and/or PSH)"]
[]
[null,"①",null,"Enter HDIS data from Baseline Goals tab, cells D20 – F20, in the highlighted cells."]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G10","v":{"$error":"#N/A"}},{"$f":"H10","v":{"$error":"#N/A"}},{"$f":"I10","v":{"$error":"#N/A"}},{"$f":"J10","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),D6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),E6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),F6)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Projection based on average annual change of \"&(F6-D6)/2&\" individuals\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (F6-D6)/D6), \"\")","v":""},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (J6-F6)/F6), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F6=\"\", E6=\"\", D6=\"\"), NA(), F6)","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+F10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+G10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+H10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+I10","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F10","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),F11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),G11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),H11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),I11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Consider what may be contributing to and influence these outcomes."]
[null,null,null,"• Does this data match what your community is experiencing?\n• Were there changes in how data was collected with your community during this time ('18 - '20) that might account for upward or downward changes?\n• What recent changes in the community could be influencing this outcome (e.g., increases in overall homelessness, opening or closing of housing projects, etc.)\n• What programs and efforts within the CoC influence this goal area most directly? \n• Do you plan to introduce new efforts that are likely to influence this outcome (e.g., because of HHAP funding or other resources)? "]
[]
[null,"②b",null,"Given the trajectory of past data and the influence of factors identified in 2a above, what is the likely direction this outcome will trend over the next few years (e.g., up steeply, up slightly, remain flat, go down slightly, go down steeply)?"]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G11","v":{"$error":"#N/A"}},{"$f":"H11","v":{"$error":"#N/A"}},{"$f":"I11","v":{"$error":"#N/A"}},{"$f":"J11","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR((J20-F7)/F7, \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③b",null,"Review the result of this potential goal. "]
[null,null,null,"• Look at the new line on the graph in Visual A.  Does the trajectory of the outcome goal seem reasonable given the contextual factors identified in step 2a? \n• To reach this goal, you will need to make average progress each year as shown in the cells above. Does this seem achievable?  \n• Continue working with this data to see how different goal targets change the trajectory."]
[]
[]
[null,"Measure #3: Setting your goal for underserved populations and populations disproportionately impacted by homelessness"]
[]
[null,"①a",null,"Explore the data and select a subpopulation."]
[null,null,null,"Review the data on the sheet titled \"Measure 7 Pop Groups Detail\" to get a sense of how subpopulations may be disproportionately represented as it relates to this outcome measure. You'll find data for Measure 3 in column E."]
[]
[null,null,null,"Identify a subpopulation from the dropdown menu and indicate it here."]
[]
[]
[null,"①b",null,"Enter the data related to this subpopulation for CY2018, CY2019, and CY2020 below in the highlighted cells. "]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G42","v":{"$error":"#N/A"}},{"$f":"H42","v":{"$error":"#N/A"}},{"$f":"I42","v":{"$error":"#N/A"}},{"$f":"J42","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),D38)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),E38)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),F38)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F38=\"\",E38=\"\",D38=\"\"),\"\", \"Projection based on average annual change of \"&(F38-D38)/2&\" individuals\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D38=\"\", E38=\"\", F38=\"\"), NA(), (F38-D38)/D38), \"\")","v":""},{"$f":"IF(OR(F38=\"\",E38=\"\",D38=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D38=\"\", E38=\"\", F38=\"\"), NA(), (J38-F38)/F38), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F38=\"\", E38=\"\", D38=\"\"), NA(), F38)","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+F42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+G42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+H42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+I42","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F42","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),F43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),G43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),H43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),I43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Examine the rate of change and potential disproportionalities."]
[null,null,null,"Using Visual B and C, consider the subpopulation's a) size relative to all persons and b) rate of change over CY2018 - CY2020. Equity questions to consider: "]
[null,null,null,"• Is the rate of change for the subpopulation greater or less than that of all persons? \n• Is the subpopulation underrepresented among those leaving for permanent housing as compared to the overall homeless population? A compared to the region’s population?\n• What does your landscape assessment show in terms of this population’s access to housing?"]
[]
[null,"②b",null,"Consider potential strategies that promote equity."]
[null,null,null,"What types of programmatic, policy, or operational changes could be implemented to support a more equitable outcome for this subpopulation? If implemented, how might these strategies affect this outcome for this subpopulation? "]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G43","v":{"$error":"#N/A"}},{"$f":"H43","v":{"$error":"#N/A"}},{"$f":"I43","v":{"$error":"#N/A"}},{"$f":"J43","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(D54=\"\", NA(), (J54-F39)/F39), \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③a",null,"Review the result of this potential goal."]
[null,null,null,"Using Visual C, compare the rates of change for all persons and the subpopulation. Does the projected change for the subpopulation make sense given the intended goal of strategies to promote greater equity? If this does not seem ambitious enough, or achievable, then experiment with a using a different goal target."]
[]
[]
[]
[null,null,null,{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), D38/D6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), E38/E6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), F38/F6)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"1-D63","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,"Remainder"]
[null,null,null,null,null,null,{"$f":"G54/G20","v":{"$error":"#N/A"}},{"$f":"H54/H20","v":{"$error":"#N/A"}},{"$f":"I54/I20","v":{"$error":"#N/A"}},{"$f":"J54/J20","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]
[null,null,null,null,null,null,{"$f":"1-G65","v":{"$error":"#N/A"}},{"$f":"1-H65","v":{"$error":"#N/A"}},{"$f":"1-I65","v":{"$error":"#N/A"}},{"$f":"1-J65","v":{"$error":"#N/A"}},"Remainder"]
[]
[]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(H20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(I20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(J20-$F$6)/$F$6","v":{"$error":"#N/A"}},"All persons rate of growth from 2020"]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(H54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(I54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(J54-$F$38)/$F$38","v":{"$error":"#N/A"}},"Subpopulation rate of growth from 2020"]
[]
[]
[null,null,null,"Baseline Year\nCY2018\nCY2020","Year 1\nCY2019\nCY2021","Year 2\nCY2020\nCY2022","Year 3\n\nCY2023","Year 4\n\nCY2024","\n\nCY2023","\n\nCY2024"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),F8)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"All Persons Past (CY2018 - CY2020)"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),F22)","v":{"$error":"#N/A"}},null,null,"All Persons Goal (CY2020 - CY2024)"]
[null,null,null,{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),F40)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),F56)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]

{"sheet":"4","index":5,"n_rows":98,"n_cols":11,"rows_kept":98,"cut":false,"hidden":false,"merged":[[40,3,40,4],[1,1,1,19],[6,6,6,9],[7,3,7,4],[20,6,20,9],[21,3,21,4],[12,3,12,11],[14,3,14,11],[8,3,8,4],[55,3,55,4],[58,3,58,11],[7,6,7,9],[21,6,21,9],[45,3,45,11],[48,3,48,11],[54,6,54,9],[39,6,39,9],[55,6,55,9],[44,3,44,11],[24,3,24,11],[27,1,27,19],[30,3,30,11],[33,3,33,9],[38,6,38,9],[39,3,39,4]]}
[]
[null,"Measure #4: Reducing the length of time persons remain homeless "]
[]
[null,"①",null,"Enter HDIS data from Baseline Goals tab, cells D25-F25, in the highlighted cells."]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G10","v":{"$error":"#N/A"}},{"$f":"H10","v":{"$error":"#N/A"}},{"$f":"I10","v":{"$error":"#N/A"}},{"$f":"J10","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),D6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),E6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),F6)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Projection based on average annual change of \"&ROUND((F6-D6)/2, 1)&\" days\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (F6-D6)/D6), \"\")","v":""},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (J6-F6)/F6), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F6=\"\", E6=\"\", D6=\"\"), NA(), F6)","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+F10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+G10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+H10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+I10","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F10","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),F11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),G11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),H11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),I11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Consider what may be contributing to and influence these outcomes."]
[null,null,null,"• Does this data match what your community is experiencing?\n• Were there changes in how data was collected with your community during this time ('18 - '20) that might account for upward or downward changes?\n• What recent changes in the community could be influencing this outcome (e.g., changes in rules about how long people can be sheltered, increase in available housing exits, etc.\n• What programs and efforts within the CoC influence this goal area most directly? \n• Do you plan to introduce new efforts that are likely to influence this outcome (e.g., because of HHAP funding or other resources)? "]
[]
[null,"②b",null,"Given the trajectory of past data and the influence of factors identified in 2a above, what is the likely direction this outcome will trend over the next few years (e.g., up steeply, up slightly, remain flat, go down slightly, go down steeply)?"]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G11","v":{"$error":"#N/A"}},{"$f":"H11","v":{"$error":"#N/A"}},{"$f":"I11","v":{"$error":"#N/A"}},{"$f":"J11","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR((J20-F7)/F7, \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③b",null,"Review the result of this potential goal. "]
[null,null,null,"• Look at the new line on the graph in Visual A.  Does the trajectory of the outcome goal seem reasonable given the contextual factors identified in step 2a? \n• To reach this goal, you will need to make average progress each year as shown in the cells above. Does this seem achievable?  \n• Continue working with this data to see how different goal targets change the trajectory."]
[]
[]
[null,"Measure #4: Setting your goal for underserved populations and populations disproportionately impacted by homelessness"]
[]
[null,"①a",null,"Explore the data and select a subpopulation."]
[null,null,null,"Review the data on the sheet titled \"Measure 7 Pop Groups Detail\" to get a sense of how subpopulations may be disproportionately represented as it relates to this outcome measure. You'll find data for Measure 4 in column F."]
[]
[null,null,null,"Identify a subpopulation from the dropdown menu and indicate it here."]
[]
[]
[null,"①b",null,"Enter the data related to this subpopulation for CY2018, CY2019, and CY2020 below in the highlighted cells. "]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G42","v":{"$error":"#N/A"}},{"$f":"H42","v":{"$error":"#N/A"}},{"$f":"I42","v":{"$error":"#N/A"}},{"$f":"J42","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),D38)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),E38)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),F38)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F38=\"\",E38=\"\",D38=\"\"),\"\", \"Projection based on average annual change of \"&(F38-D38)/2&\" days\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D38=\"\", E38=\"\", F38=\"\"), NA(), (F38-D38)/D38), \"\")","v":""},{"$f":"IF(OR(F38=\"\",E38=\"\",D38=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D38=\"\", E38=\"\", F38=\"\"), NA(), (J38-F38)/F38), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F38=\"\", E38=\"\", D38=\"\"), NA(), F38)","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+F42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+G42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+H42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+I42","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F42","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),F43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),G43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),H43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),I43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Examine the rate of change and potential disproportionalities."]
[null,null,null,"Using Visual B and C, consider the subpopulation's a) size relative to all persons and b) rate of change over CY2018 - CY2020. Equity questions to consider: "]
[null,null,null,"● Is the rate of change for the subpopulation greater or less than that of all persons?  \n● Is the subpopulation homeless longer on average than other people experiencing homelessness? \n● What does your landscape assessment show in terms of this population’s access to housing and services?"]
[]
[null,"②b",null,"Consider potential strategies that promote equity."]
[null,null,null,"What types of programmatic, policy, or operational changes could be implemented to support a more equitable outcome for this subpopulation? If implemented, how might these strategies affect this outcome for this subpopulation? "]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G43","v":{"$error":"#N/A"}},{"$f":"H43","v":{"$error":"#N/A"}},{"$f":"I43","v":{"$error":"#N/A"}},{"$f":"J43","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(D54=\"\", NA(), (J54-F39)/F39), \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③a",null,"Review the result of this potential goal."]
[null,null,null,"Using Visual C, compare the rates of change for all persons and the subpopulation. Does the projected change for the subpopulation make sense given the intended goal of strategies to promote greater equity? If this does not seem ambitious enough, or achievable, then experiment with a using a different goal target."]
[]
[]
[]
[null,null,null,{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), D38/D6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), E38/E6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), F38/F6)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"1-D63","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,"Remainder"]
[null,null,null,null,null,null,{"$f":"G54/G20","v":{"$error":"#N/A"}},{"$f":"H54/H20","v":{"$error":"#N/A"}},{"$f":"I54/I20","v":{"$error":"#N/A"}},{"$f":"J54/J20","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]
[null,null,null,null,null,null,{"$f":"1-G65","v":{"$error":"#N/A"}},{"$f":"1-H65","v":{"$error":"#N/A"}},{"$f":"1-I65","v":{"$error":"#N/A"}},{"$f":"1-J65","v":{"$error":"#N/A"}},"Remainder"]
[]
[]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(H20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(I20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(J20-$F$6)/$F$6","v":{"$error":"#N/A"}},"All persons rate of growth from 2020"]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(H54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(I54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(J54-$F$38)/$F$38","v":{"$error":"#N/A"}},"Subpopulation rate of growth from 2020"]
[]
[]
[null,null,null,"Baseline Year\nCY2018\nCY2020","Year 1\nCY2019\nCY2021","Year 2\nCY2020\nCY2022","Year 3\n\nCY2023","Year 4\n\nCY2024","\n\nCY2023","\n\nCY2024"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),F8)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"All Persons Past (CY2018 - CY2020)"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),F22)","v":{"$error":"#N/A"}},null,null,"All Persons Goal (CY2020 - CY2024)"]
[null,null,null,{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),F40)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),F56)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]
[]
[]
[null,null,null,null,null,"Past","Goal","Past","Goal"]
[null,null,null,"All Persons"]
[null,null,null,null,"CY18",{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),D6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY19",{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),E6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY20",{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),F6)","v":{"$error":"#N/A"}},{"$f":"F84","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY21",null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),G20)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY22",null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),H20)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY23",null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),I20)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY24",null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),J20)","v":{"$error":"#N/A"}}]
[]
[null,null,null,{"$f":"IF(D34=\"\",\"Subpopulation\", D34)","v":"Subpopulation"}]
[null,null,null,null,"CY18",null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\"),NA(),D38)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY19",null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\"),NA(),E38)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY20",null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\"),NA(),F38)","v":{"$error":"#N/A"}},{"$f":"H93","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY21",null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),G54)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY22",null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),H54)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY23",null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),I54)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY24",null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),J54)","v":{"$error":"#N/A"}}]
[null,null,null,null," "]

{"sheet":"5","index":6,"n_rows":98,"n_cols":11,"rows_kept":98,"cut":false,"hidden":false,"merged":[[40,3,40,4],[1,1,1,19],[6,6,6,9],[7,3,7,4],[20,6,20,9],[21,3,21,4],[12,3,12,11],[14,3,14,11],[8,3,8,4],[55,3,55,4],[58,3,58,11],[7,6,7,9],[21,6,21,9],[45,3,45,11],[48,3,48,11],[54,6,54,9],[39,6,39,9],[55,6,55,9],[44,3,44,11],[24,3,24,11],[27,1,27,19],[30,3,30,11],[33,3,33,9],[38,6,38,9],[39,3,39,4]]}
[]
[null,"Measure #5: Reducing the number of persons who return to homelessness after exiting homelessness to permanent housing."]
[]
[null,"①",null,"Enter HDIS data from Baseline Goals tab, cells D30-F30, in the highlighted cells."]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G10","v":{"$error":"#N/A"}},{"$f":"H10","v":{"$error":"#N/A"}},{"$f":"I10","v":{"$error":"#N/A"}},{"$f":"J10","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),D6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),E6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),F6)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Projection based on average annual change of \"&(F6-D6)/2*100&\"% points\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), F6-D6), \"\")","v":""},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), J6-F6), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F6=\"\", E6=\"\", D6=\"\"), NA(), F6)","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+F10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+G10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+H10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+I10","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F10","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),F11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),G11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),H11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),I11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Consider what may be contributing to and influence these outcomes."]
[null,null,null,"• Does this data match what your community is experiencing?\n• Were there changes in how data was collected with your community during this time ('18 - '20) that might account for upward or downward changes?\n• What recent changes in the community could be influencing this outcome (e.g., increasing rents, expansion of aftercare support or subsidies, etc.) \n• What programs and efforts within the CoC influence this goal area most directly? \n• Do you plan to introduce new efforts that are likely to influence this outcome (e.g., because of HHAP funding or other resources)?  "]
[]
[null,"②b",null,"Given the trajectory of past data and the influence of factors identified in 2a above, what is the likely direction this outcome will trend over the next few years (e.g., up steeply, up slightly, remain flat, go down slightly, go down steeply)?"]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G11","v":{"$error":"#N/A"}},{"$f":"H11","v":{"$error":"#N/A"}},{"$f":"I11","v":{"$error":"#N/A"}},{"$f":"J11","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(J20-F7, \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③b",null,"Review the result of this potential goal. "]
[null,null,null,"• Look at the new line on the graph in Visual A.  Does the trajectory of the outcome goal seem reasonable given the contextual factors identified in step 2a? \n• To reach this goal, you will need to make average progress each year as shown in the cells above. Does this seem achievable?  \n• Continue working with this data to see how different goal targets change the trajectory."]
[]
[]
[null,"Measure #5: Setting your goal for underserved populations and populations disproportionately impacted by homelessness"]
[]
[null,"①a",null,"Explore the data and select a subpopulation."]
[null,null,null,"Review the data on the sheet titled \"Measure 7 Pop Groups Detail\" to get a sense of how subpopulations may be disproportionately represented as it relates to this outcome measure. You'll find data for Measure 5 in column G."]
[]
[null,null,null,"Identify a subpopulation from the dropdown menu and indicate it here."]
[]
[]
[null,"①b",null,"Enter the data related to this subpopulation for CY2018, CY2019, and CY2020 below in the highlighted cells. "]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G42","v":{"$error":"#N/A"}},{"$f":"H42","v":{"$error":"#N/A"}},{"$f":"I42","v":{"$error":"#N/A"}},{"$f":"J42","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),D38)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),E38)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),F38)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F38=\"\",E38=\"\",D38=\"\"),\"\",\"Projection based on average annual change of \"&(F38-D38)/2*100&\"% points\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D38=\"\", E38=\"\", F38=\"\"), NA(), F38-D38), \"\")","v":""},{"$f":"IF(OR(F38=\"\",E38=\"\",D38=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D38=\"\", E38=\"\", F38=\"\"), NA(), J38-F38), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F38=\"\", E38=\"\", D38=\"\"), NA(), F38)","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+F42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+G42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+H42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+I42","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F42","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),F43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),G43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),H43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),I43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Examine the rate of change and potential disproportionalities."]
[null,null,null,"Using Visual B and C, consider the subpopulation's a) size relative to all persons and b) rate of change over CY2018 - CY2020. Equity questions to consider: "]
[null,null,null,"• Is the rate of change for the subpopulation greater or less than that of all persons? \n• Is the subpopulation disproportionately represented among those returning to homelessness compared to the overall homeless population? As compared to the region’s population?\n• What does your landscape assessment show in terms of this population’s services?"]
[]
[null,"②b",null,"Consider potential strategies that promote equity."]
[null,null,null,"What types of programmatic, policy, or operational changes could be implemented to support a more equitable outcome for this subpopulation? If implemented, how might these strategies affect this outcome for this subpopulation? "]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G43","v":{"$error":"#N/A"}},{"$f":"H43","v":{"$error":"#N/A"}},{"$f":"I43","v":{"$error":"#N/A"}},{"$f":"J43","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(D54=\"\", NA(), J54-F39), \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③a",null,"Review the result of this potential goal."]
[null,null,null,"Using Visual C, compare the rates of change for all persons and the subpopulation. Does the projected change for the subpopulation make sense given the intended goal of strategies to promote greater equity? If this does not seem ambitious enough, or achievable, then experiment with a using a different goal target."]
[]
[]
[]
[null,null,null,{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), D38/D6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), E38/E6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), F38/F6)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"1-D63","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,"Remainder"]
[null,null,null,null,null,null,{"$f":"G54/G20","v":{"$error":"#N/A"}},{"$f":"H54/H20","v":{"$error":"#N/A"}},{"$f":"I54/I20","v":{"$error":"#N/A"}},{"$f":"J54/J20","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]
[null,null,null,null,null,null,{"$f":"1-G65","v":{"$error":"#N/A"}},{"$f":"1-H65","v":{"$error":"#N/A"}},{"$f":"1-I65","v":{"$error":"#N/A"}},{"$f":"1-J65","v":{"$error":"#N/A"}},"Remainder"]
[]
[]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(H20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(I20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(J20-$F$6)/$F$6","v":{"$error":"#N/A"}},"All persons rate of growth from 2020"]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(H54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(I54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(J54-$F$38)/$F$38","v":{"$error":"#N/A"}},"Subpopulation rate of growth from 2020"]
[]
[]
[null,null,null,"Baseline Year\nCY2018\nCY2020","Year 1\nCY2019\nCY2021","Year 2\nCY2020\nCY2022","Year 3\n\nCY2023","Year 4\n\nCY2024","\n\nCY2023","\n\nCY2024"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),F8)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"All Persons Past (CY2018 - CY2020)"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),F22)","v":{"$error":"#N/A"}},null,null,"All Persons Goal (CY2020 - CY2024)"]
[null,null,null,{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),F40)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),F56)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]
[]
[]
[null,null,null,null,null,"Past","Goal","Past","Goal"]
[null,null,null,"All Persons"]
[null,null,null,null,"CY18",{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),D6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY19",{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),E6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY20",{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),F6)","v":{"$error":"#N/A"}},{"$f":"F84","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY21",null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),G20)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY22",null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),H20)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY23",null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),I20)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY24",null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),J20)","v":{"$error":"#N/A"}}]
[]
[null,null,null,{"$f":"IF(D34=\"\",\"Subpopulation\", D34)","v":"Subpopulation"}]
[null,null,null,null,"CY18",null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\"),NA(),D38)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY19",null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\"),NA(),E38)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY20",null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\"),NA(),F38)","v":{"$error":"#N/A"}},{"$f":"H93","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY21",null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),G54)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY22",null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),H54)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY23",null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),I54)","v":{"$error":"#N/A"}}]
[null,null,null,null,"CY24",null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),J54)","v":{"$error":"#N/A"}}]
[null,null,null,null," "]

{"sheet":"6","index":7,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":false,"merged":[[40,3,40,4],[1,1,1,19],[6,6,6,9],[7,3,7,4],[20,6,20,9],[21,3,21,4],[12,3,12,11],[14,3,14,11],[8,3,8,4],[55,3,55,4],[58,3,58,11],[7,6,7,9],[21,6,21,9],[45,3,45,11],[48,3,48,11],[54,6,54,9],[39,6,39,9],[55,6,55,9],[44,3,44,11],[24,3,24,11],[27,1,27,19],[30,3,30,11],[33,3,33,9],[38,6,38,9],[39,3,39,4]]}
[]
[null,"Measure #6: Increasing successful placements from street outreach "]
[]
[null,"①",null,"Enter HDIS data from Baseline Goals tab, cells D35-F35, in the highlighted cells."]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G10","v":{"$error":"#N/A"}},{"$f":"H10","v":{"$error":"#N/A"}},{"$f":"I10","v":{"$error":"#N/A"}},{"$f":"J10","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),D6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),E6)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$6=\"\",$E$6=\"\",$F$6=\"\"),NA(),F6)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Projection based on average annual change of \"&(F6-D6)/2&\" individuals\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (F6-D6)/D6), \"\")","v":""},{"$f":"IF(OR(F6=\"\",E6=\"\",D6=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D6=\"\", E6=\"\", F6=\"\"), NA(), (J6-F6)/F6), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F6=\"\", E6=\"\", D6=\"\"), NA(), F6)","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+F10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+G10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+H10","v":{"$error":"#N/A"}},{"$f":"(F6-D6)/2+I10","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F10","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),F11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),G11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),H11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$20=\"\",NA(),I11+(($D$20-$F$6)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Consider what may be contributing to and influence these outcomes."]
[null,null,null,"• Does this data match what your community is experiencing?\n• Were there changes in how data was collected with your community during this time ('18 - '20) that might account for upward or downward changes?\n• What recent changes in the community could be influencing this outcome (e.g., decreasing vacancy rates, increased outreach efforts, etc.) \n• What programs and efforts within the CoC influence this goal area most directly? \n• Do you plan to introduce new efforts that are likely to influence this outcome (e.g., because of HHAP funding or other resources)? "]
[]
[null,"②b",null,"Given the trajectory of past data and the influence of factors identified in 2a above, what is the likely direction this outcome will trend over the next few years (e.g., up steeply, up slightly, remain flat, go down slightly, go down steeply)?"]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G11","v":{"$error":"#N/A"}},{"$f":"H11","v":{"$error":"#N/A"}},{"$f":"I11","v":{"$error":"#N/A"}},{"$f":"J11","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR((J20-F7)/F7, \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③b",null,"Review the result of this potential goal. "]
[null,null,null,"• Look at the new line on the graph in Visual A.  Does the trajectory of the outcome goal seem reasonable given the contextual factors identified in step 2a? \n• To reach this goal, you will need to make average progress each year as shown in the cells above. Does this seem achievable?  \n• Continue working with this data to see how different goal targets change the trajectory."]
[]
[]
[null,"Measure #6: Setting your goal for underserved populations and populations disproportionately impacted by homelessness"]
[]
[null,"①a",null,"Explore the data and select a subpopulation."]
[null,null,null,"Review the data on the sheet titled \"Measure 7 Pop Groups Detail\" to get a sense of how subpopulations may be disproportionately represented as it relates to this outcome measure. You'll find data for Measure 6 in column H.\n\nYou may also want to see which populations your landscape assessment identified as populations that do not receive outreach support or get access to housing."]
[]
[null,null,null,"Identify a subpopulation from the dropdown menu and indicate it here."]
[]
[]
[null,"①b",null,"Enter the data related to this subpopulation for CY2018, CY2019, and CY2020 below in the highlighted cells. "]
[null,null,null,"CY2018","CY2019","CY2020","CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G42","v":{"$error":"#N/A"}},{"$f":"H42","v":{"$error":"#N/A"}},{"$f":"I42","v":{"$error":"#N/A"}},{"$f":"J42","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),D38)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),E38)","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),F38)","v":{"$error":"#N/A"}},{"$f":"IF(OR(F38=\"\",E38=\"\",D38=\"\"),\"\", \"Projection based on average annual change of \"&(F38-D38)/2&\" individuals\")","v":""}]
[null,null,null,"% change 2018 - 2020: ",null,{"$f":"IFERROR(IF(OR(D38=\"\", E38=\"\", F38=\"\"), NA(), (F38-D38)/D38), \"\")","v":""},{"$f":"IF(OR(F38=\"\",E38=\"\",D38=\"\"),\"\",\"Annual change calculation: (CY2020 - CY2018) / 2 + prior CY\")","v":""}]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(OR(D38=\"\", E38=\"\", F38=\"\"), NA(), (J38-F38)/F38), \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F38=\"\", E38=\"\", D38=\"\"), NA(), F38)","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+F42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+G42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+H42","v":{"$error":"#N/A"}},{"$f":"(F38-D38)/2+I42","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"F42","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),F43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),G43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),H43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}},{"$f":"IF($D$54=\"\",NA(),I43+(($D$54-$F$38)/4))","v":{"$error":"#N/A"}}]
[null,"②a",null,"Examine the rate of change and potential disproportionalities."]
[null,null,null,"Using Visual B and C, consider the subpopulation's a) size relative to all persons and b) rate of change over CY2018 - CY2020. Equity questions to consider: "]
[null,null,null,"● Is the rate of change for the subpopulation greater or less than that of all persons?  \n● Is the subpopulation underrepresented among those who are served by outreach or who get access to placements in shelter and housing? \n● What does your landscape assessment show in terms of this population’s access to shelter and housing?"]
[]
[null,"②b",null,"Consider potential strategies that promote equity."]
[null,null,null,"What types of programmatic, policy, or operational changes could be implemented to support a more equitable outcome for this subpopulation? If implemented, how might these strategies affect this outcome for this subpopulation? "]
[]
[]
[null,"③a",null,"Enter an ambitious but achievable outcome goal to reach by CY2024 in the highlighted cell."]
[null,null,null,"CY2024",null,null,"CY2021","CY2022","CY2023","CY2024"]
[null,null,null,null,null,null,{"$f":"G43","v":{"$error":"#N/A"}},{"$f":"H43","v":{"$error":"#N/A"}},{"$f":"I43","v":{"$error":"#N/A"}},{"$f":"J43","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Annual targets given CY2024 goal input"]
[null,null,null,"% change 2020 - 2024: ",null,{"$f":"IFERROR(IF(D54=\"\", NA(), (J54-F39)/F39), \"\")","v":""},"Progress distributed evenly across years"]
[]
[null,"③a",null,"Review the result of this potential goal."]
[null,null,null,"Using Visual C, compare the rates of change for all persons and the subpopulation. Does the projected change for the subpopulation make sense given the intended goal of strategies to promote greater equity? If this does not seem ambitious enough, or achievable, then experiment with a using a different goal target.  "]
[]
[]
[]
[null,null,null,{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), D38/D6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), E38/E6)","v":{"$error":"#NAME?"}},{"$f":"IF(OR($D$38=\"\", $E$38=\"\", $F$38=\"\"), N/A(), F38/F6)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"1-D63","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,"Remainder"]
[null,null,null,null,null,null,{"$f":"G54/G20","v":{"$error":"#N/A"}},{"$f":"H54/H20","v":{"$error":"#N/A"}},{"$f":"I54/I20","v":{"$error":"#N/A"}},{"$f":"J54/J20","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]
[null,null,null,null,null,null,{"$f":"1-G65","v":{"$error":"#N/A"}},{"$f":"1-H65","v":{"$error":"#N/A"}},{"$f":"1-I65","v":{"$error":"#N/A"}},{"$f":"1-J65","v":{"$error":"#N/A"}},"Remainder"]
[]
[]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(H20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(I20-$F$6)/$F$6","v":{"$error":"#N/A"}},{"$f":"(J20-$F$6)/$F$6","v":{"$error":"#N/A"}},"All persons rate of growth from 2020"]
[null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"(G54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(H54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(I54-$F$38)/$F$38","v":{"$error":"#N/A"}},{"$f":"(J54-$F$38)/$F$38","v":{"$error":"#N/A"}},"Subpopulation rate of growth from 2020"]
[]
[]
[null,null,null,"Baseline Year\nCY2018\nCY2020","Year 1\nCY2019\nCY2021","Year 2\nCY2020\nCY2022","Year 3\n\nCY2023","Year 4\n\nCY2024","\n\nCY2023","\n\nCY2024"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),NA(),F8)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"All Persons Past (CY2018 - CY2020)"]
[null,null,null,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",D20=\"\"),NA(),F22)","v":{"$error":"#N/A"}},null,null,"All Persons Goal (CY2020 - CY2024)"]
[null,null,null,{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),0%)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR($D$38=\"\",$E$38=\"\",$F$38=\"\"),NA(),F40)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(D34=\"\",\"Subpopulation Past (CY2018 - CY2020)\",D34&\" Past (CY2018 - CY2020)\")","v":"Subpopulation Past (CY2018 - CY2020)"}]
[null,null,null,{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),0)","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(OR(D38=\"\",E38=\"\",F38=\"\",D54=\"\"),NA(),F56)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(D34=\"\", \"Subpopulation Goal (CY2020 - CY2024)\", D34&\" Goal (CY2020 - CY2024)\")","v":"Subpopulation Goal (CY2020 - CY2024)"}]

{"sheet":"Subpopulations","index":8,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Persons in HHs without children "]
["Persons in HHs with at least 1 adult and 1 child "]
["Persons in HHs with only children "]
["Woman/Girl"]
["Male/Boy"]
["People who are Transgender "]
["People who are Hispanic/Latino "]
["People who are Non-Hispanic/ Non-Latino "]
["People with Unknown Ethnicity (client doesn't know ethnicity, refused to repond, or data were not collected)"]
["People who are American Indian or Alaska Native "]
["People who are Asian "]
["People who are Black or African American "]
["People who are Native Hawaiian or Other Pacific Islander "]
["People who are White "]
["People who are Multiple Races "]
["# of Adults who are Experiencing Significant Mental Illness"]
["# of Adults who are Experiencing Substance Abuse Disorders"]
["# of Adults who are Veterans"]
["# of Adults with HIV/AIDS"]
["# of Adults who are Currently Fleeing Domestic Violence"]
["# of Unaccompanied Youth (18- 24 years old)"]
["# of Parenting Youth (18-24 years old)"]
["Other"]

{"sheet":"KG Notes","index":9,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,2018,2019,2020,"2021 (est)","What is says","Factors to Consider","Programs with most impact on this indicator","Supop considerations ",null,null,"Goal",2021,2022,2023,2024]
["Measure 1a",5423,8140,11673,null,"The numbers of people who are being served annually in SF are increasing at an increasing rate","Growth of the ONE system coverage could imply growth of the population which is really growth in coverage; growth in the PIT indicates more of a 50% increase over three years than 115%","Enrollements in CE and in shelter constitute most of this","African Americans are largest racial group represented and have grown at an increasing rate during this period",null,"Goal for Measure 1 a","Increase by 5000","xx",{"$f":"+D2+2000","v":13673},{"$f":"+N2+2000","v":15673},{"$f":"+O2+1000","v":16673}]