{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Data Input and Model","Baseline Model (Hide+Lock)"],"not_rendered":{"charts":2,"images":55,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,5,4,13],[8,1,23,13],[7,1,7,13]]}
[]
[null,null,null,null,null,"Welcome to System Planning and Optimization Concepts (SPOC)! SPOC uses a simplified model to help communities think about system change concepts to impact the size of their homeless population. For detailed and precise homeless system modeling, check out SWAP."]
[]
[]
[]
[]
[]
[null,"Instructions"]
[null,"1. Point in Time Count: Enter the number of unsheltered and sheltered households from your most recent Point In Time (PIT) Count.\n\n2. Capacity: Enter the total number of households that can be served in each project type at a single point in time.\n\n3. Project Performance: For each project type and performance measure, click the button that most closely represents your current average system performance.\n\n4. Understanding Your Community: Click “Calculate Baseline.” A brief system description and suggested system improvement strategies will appear.\n\n5. Modeling Impacts of System Changes: Click a grey system improvement button to see the estimated impact of making that change on the size of your community’s homeless population; the population change reflects only the current improvement selected. Try them all to see what helps the most!\n\n6. Resetting Your Community Data: If you want to change the PIT count, capacity, or performance measures you entered after you've tried some system changes, click \"Reset Baseline.\" Then enter your changes and click \"Calculate Baseline\" again. "]

{"sheet":"Data Input and Model","index":1,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,20,4,25],[16,14,17,18],[6,15,7,17],[0,14,4,18],[25,1,26,3],[19,7,20,9],[19,10,19,12],[21,7,22,9],[23,7,24,9],[25,7,26,9],[2,7,3,12],[7,1,7,3],[23,1,24,3],[17,7,18,9],[2,1,3,6],[5,20,11,25],[9,10,9,12],[9,1,10,3],[15,7,16,9],[15,1,16,3],[13,1,14,3],[11,1,12,3],[9,7,10,9],[9,4,9,6],[11,7,12,9],[13,7,14,9],[19,4,19,6],[4,7,8,9],[21,1,22,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[17,1,18,3],[19,1,20,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"System Planning and Optimization Concepts (SPOC)"]
[]
[null,"Point In Time Count",null,null,null,null,null,"Recent Changes in Unsheltered Homelessness"]
[]
[null,null,null,null,null,null,null,"Over the last two Point In Time counts, the unsheltered homeless population in my community has:"]
[null,"Unsheltered",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF('Baseline Model (Hide+Lock)'!H15=1,IF(AND('Baseline Model (Hide+Lock)'!I14=1,'Baseline Model (Hide+Lock)'!J14=0),'Baseline Model (Hide+Lock)'!M2,IF(AND('Baseline Model (Hide+Lock)'!I14=2,'Baseline Model (Hide+Lock)'!J14=0),'Baseline Model (Hide+Lock)'!N2,IF(AND('Baseline Model (Hide+Lock)'!I14=3,'Baseline Model (Hide+Lock)'!J14=0),'Baseline Model (Hide+Lock)'!O2,IF(AND('Baseline Model (Hide+Lock)'!I14=4,'Baseline Model (Hide+Lock)'!J14=0),'Baseline Model (Hide+Lock)'!P2,IF(AND('Baseline Model (Hide+Lock)'!I14=5,'Baseline Model (Hide+Lock)'!J14=0),'Baseline Model (Hide+Lock)'!Q2,IF('Baseline Model (Hide+Lock)'!J14>0,'Baseline Model (Hide+Lock)'!R2,\"\")))))),\"\"),\"Your data is incomplete. Please enter all necessary data and click Calculate Baseline again.\")","v":""}]
[null,"Sheltered",null,null,null,null,null,null,null,null,null,null,null,null,null,"Model Baseline"]
[null,"Total",null,null,null,{"$f":"F6+F7","v":0}]
[]
[null,"Emergency Shelter",null,null,"Capacity",null,null,"Transitional Housing",null,null,"Capacity"]
[]
[null,"Length of Stay (days)",null,null,null,null,null,"Length of Stay (days)"]
[]
[null,"Utilization Rate",null,null,null,null,null,"Utilization Rate"]
[]
[null,"Entries from Unsheltered Homelessness",null,null,null,null,null,"Entries from Literal Homelessness"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"System Change Options"]
[null,"Exits to Permanent Housing",null,null,null,null,null,"Exits to Permanent Housing"]
[]
[null,"Rapid Rehousing",null,null,"Capacity",null,null,"Permanent \nSupportive Housing",null,null,"Capacity"]
[]
[null,"Length of Stay (days)",null,null,null,null,null,"Annual Unit Turnover"]
[]
[null,"Entries from Literal Homelessness",null,null,null,null,null,"Utilization Rate"]
[]
[null,"Exits to Permanent Housing",null,null,null,null,null,"Entries from Literal Homelessness"]

{"sheet":"Baseline Model (Hide+Lock)","index":2,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,"Capacity","LOS/PSH Turnover","UR","% Entries from Unsheltered/Homelessness","% Exits to PH","Annual Capacity","Used Capacity","Annual Available Capacity","Annual Available Capacity for Unsheltered","Annual Available Capacity for Other"]
["ES",{"$f":"'Data Input and Model'!F11","v":0},75,0.9,0.8,0.25,{"$f":"B2*((365*D2)/C2)","v":0},{"$f":"IFERROR(B11*(B2/(B2+B3)),0)","v":0},{"$f":"G2-H2","v":0},{"$f":"I2*E2","v":0},{"$f":"I2-J2","v":0},null,{"$f":"CONCATENATE(\"Your community has a large unsheltered population. \",\"If you maintain your current services and performance, the homeless population in your community \",'Baseline Model (Hide+Lock)'!F15,\" by \",TEXT(ABS('Baseline Model (Hide+Lock)'!F16),\"#0%\"),\" this year. \",\"You may be able to decrease your homeless population by improving system performance or adding/expanding diversion.\")","v":{"$error":"#DIV/0!"}},{"$f":"CONCATENATE(\"Your community's homeless programs serve a high percentage of clients who aren't literally homeless. \",\"If you maintain your current services and performance, the homeless population in your community \",'Baseline Model (Hide+Lock)'!F15,\" by \",TEXT(ABS('Baseline Model (Hide+Lock)'!F16),\"#0%\"),\" this year. \",\"You may be able to decrease your homeless population by improving system performance or adding/expanding diversion.\")","v":{"$error":"#DIV/0!"}},{"$f":"CONCATENATE(\"A high percentage of clients served in your homeless system exit to destinations that are not permanent housing. \",\"If you maintain your current services and performance, the homeless population in your community \",'Baseline Model (Hide+Lock)'!F15,\" by \",TEXT(ABS('Baseline Model (Hide+Lock)'!F16),\"#0%\"),\" this year. \",\"You may be able to decrease your homeless population by improving system performance.\")","v":{"$error":"#DIV/0!"}},{"$f":"CONCATENATE(\"Your community contains a large amount of transitional housing. \",\"If you maintain your current services and performance, the homeless population in your community \",'Baseline Model (Hide+Lock)'!F15,\" by \",TEXT(ABS('Baseline Model (Hide+Lock)'!F16),\"#0%\"),\" this year. \",\"You may be able to decrease your homeless population by retooling your transitional housing.\")","v":{"$error":"#DIV/0!"}},{"$f":"CONCATENATE(\"Your community's homeless system is performing well and may be able to achieve functional zero in the near future. \",\"If you maintain your current services and performance, the homeless population in your community \",'Baseline Model (Hide+Lock)'!F15,\" by \",TEXT(ABS('Baseline Model (Hide+Lock)'!F16),\"#0%\"),\" this year. \",\"Try the options below for potential strategies to serve your homeless population even better.\")","v":{"$error":"#DIV/0!"}},{"$f":"CONCATENATE(\"By \",J15,\" you \",'Baseline Model (Hide+Lock)'!F15,\" your homeless population by \",TEXT(ABS('Baseline Model (Hide+Lock)'!E16),\"#0%\"),\" this year. \",\"This is \",TEXT(ABS(G15),\"#0%\"),\" \",G16,\" than without \",J15,\".\")","v":{"$error":"#N/A"}}]
["TH",{"$f":"'Data Input and Model'!L11","v":0},200,0.9,0.8,0.75,{"$f":"B3*((365*D3)/C3)","v":0},{"$f":"B11-H2","v":0},{"$f":"IF(G3-H3>0,G3-H3,0)","v":0},{"$f":"I3*E3","v":0},{"$f":"I3-J3","v":0}]
["RRH",{"$f":"'Data Input and Model'!F21","v":0},200,1,0.8,0.8,0,{"$f":"B4*D4","v":0},{"$f":"G4-H4","v":0},0,0]
["PSH",{"$f":"'Data Input and Model'!L21","v":0},10,0.9,0.8,1,null,null,{"$f":"C5*B5","v":0},0,0]
[null,null,null,null,{"$f":"SUMPRODUCT(E2:E5,I2:I5/SUM(I2:I5))","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(F2:F4,I2:I4)/SUM(I2:I4)","v":{"$error":"#DIV/0!"}}]
[null,"Unsheltered","% Newly Homeless","% Housed On Own","Unsheltered HHs Needing Housing","Unsheltered HHs Served in RRH","Unsheltered HHs Served in PSH","Unsheltered HHs Served in ES","Unsheltered HHs Served in TH","Unsheltered HHs Housed","Unsheltered HHs Remaining"]
["Population",{"$f":"'Data Input and Model'!F6","v":0},0.05,0.05,{"$f":"B8+(C8*B8)-((B8+(C8*B8))*D8)","v":0},{"$f":"IF(J4<=E8,J4,E8)","v":0},{"$f":"IF(J5<=E8-F8,J5,E8-F8)","v":0},{"$f":"IF(J2<=E8-F8-G8,J2,E8-F8-G8)","v":0},{"$f":"IF(J3<=E8-F8-G8-H8,J3,E8-F8-G8-H8)","v":0},{"$f":"(F8*F4)+(G8*F5)+(H8*F2)+(I8*F3)","v":0},{"$f":"IF(J11=((B2*D2)+(B3*D3)),E8-J8+(F11-I11+(H8*(1-F2))+(I8*(1-F3)))-((B2*D2)+(B3*D3)),E8-J8)","v":0}]
[]
[null,"Sheltered","Sheltered HHs in ES","Sheltered HHs in TH","Sheltered HHs Housed by Shelter","Sheltered HHs Needing Housing","Sheltered HHs Served in RRH","Sheltered HHs Served in PSH","Sheltered HHs Housed by RRH/PSH","Sheltered HHs Remaining"]
["Population",{"$f":"'Data Input and Model'!F7","v":0},{"$f":"IFERROR(B11*(B2/(B2+B3)),0)","v":0},{"$f":"B11-C11+I8","v":0},{"$f":"(C11*F2)+(D11*F3)","v":0},{"$f":"B11-E11","v":0},{"$f":"IF(J4-F8<=F11,J4-F8,F11)","v":0},{"$f":"IF(J5-G8<=F11-G11,J5-G8,F11-G11)","v":0},{"$f":"(G11*F4)+(H11*F5)","v":0},{"$f":"IF((F11-I11+(H8*(1-F2))+(I8*(1-F3)))>((B2*D2)+(B3*D3)),((B2*D2)+(B3*D3)),(F11-I11+(H8*(1-F2))+(I8*(1-F3))))","v":0},null,null,1,"adding/expanding Diversion"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,"improving system performance"]
[null,"Total Homeless at Start","Total Homeless at Finish","Total Homeless at Finish (Baseline)","Net Change in Homeless Population","Net Change in Homeless Population (Baseline)","Difference vs Baseline","All data entered?","Community Type","Improvement Attempted?",null,null,3,"adding ES inventory"]
[null,{"$f":"B8+B11","v":0},{"$f":"K8+J11","v":0},null,{"$f":"(C14-B14)/B14","v":{"$error":"#DIV/0!"}},null,{"$f":"F14-E14","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Instructions!#REF!<>\"\",Instructions!#REF!<>\"\",Instructions!#REF!<>\"\",Instructions!#REF!<>\"\",Instructions!#REF!<>\"\",Instructions!#REF!<>\"\",'Baseline Model (Hide+Lock)'!C2<>\"\",'Baseline Model (Hide+Lock)'!C3<>\"\",'Baseline Model (Hide+Lock)'!C4<>\"\",'Baseline Model (Hide+Lock)'!C5<>\"\",'Baseline Model (Hide+Lock)'!D2<>\"\",'Baseline Model (Hide+Lock)'!D3<>\"\",'Baseline Model (Hide+Lock)'!D5<>\"\",'Baseline Model (Hide+Lock)'!E2<>\"\",'Baseline Model (Hide+Lock)'!E3<>\"\",'Baseline Model (Hide+Lock)'!E4<>\"\",'Baseline Model (Hide+Lock)'!E5<>\"\",'Baseline Model (Hide+Lock)'!F2<>\"\",'Baseline Model (Hide+Lock)'!F3<>\"\",'Baseline Model (Hide+Lock)'!F4<>\"\"),1,0)","v":{"$error":"#REF!"}},{"$f":"IF((B8/(B8+B11))>0.45,1,IF(E6<0.8,2,IF(F6<0.5,3,IF((B3/SUM(B2:B5))>0.2,4,5))))","v":{"$error":"#DIV/0!"}},0,null,null,4,"retooling TH inventory"]
[null,null,null,null,null,{"$f":"IF(E14<0,\"can decrease\",\"may increase\")","v":{"$error":"#DIV/0!"}},{"$f":"G14","v":{"$error":"#DIV/0!"}},null,null,{"$f":"VLOOKUP(J14,$M$11:$N$16,2,0)","v":{"$error":"#N/A"}},null,null,5,"adding RRH inventory"]
[null,null,null,null,{"$f":"ABS(E14)","v":{"$error":"#DIV/0!"}},{"$f":"ABS(F14)","v":0},{"$f":"IF(G14<0,\"less\",\"more\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,6,"adding PSH inventory"]
[null,"Capacity","LOS/PSH Turnover","UR","% Entries from Unsheltered/Homelessness","% Exits to PH",null,"Unsheltered HHs Remaining"]
["ES"]
["TH",null,null,null,null,null,null,"Sheltered HHs Remaining"]
["RRH"]
["PSH"]
[null,"Start"]
[null,"Unsheltered"]
["Population"]
[]
[null,"Sheltered"]
["Population"]