{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["User Guide","1. Subarea Types","2. Subarea Names","3. Sampled Subareas & PIT","Sampling pcts","Random ranks","Calculations","4. Extrapolated PIT Count","5. Version Change Log"],"not_rendered":{"charts":0,"images":1,"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":"User Guide","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,31,15],[0,0,11,15],[23,0,23,15],[24,0,24,15],[21,0,21,15],[17,0,17,15],[25,1,25,15],[12,0,12,15],[22,0,22,15],[13,0,13,15],[14,0,14,15],[15,0,15,15],[16,0,16,15],[20,0,20,15],[18,0,18,15],[19,0,19,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PIT Count Sampling Tool Overview"]
["Background"]
["HUD requires Continuums of Care (CoCs) to conduct Point-in-Time (PIT) counts of people in unsheltered locations at least every other year.  Many CoCs conduct their PIT counts by sampling parts of their jurisdictions and using those samples to derive a full estimate of people experiencing unsheltered homelessness.  \n\nThe PIT Count Sampling Tool is intended to help CoCs to develop their sampling approaches and estimate of the total number of people experiencing unsheltered homelessness based on the sample data they collect.  "]
["Purpose of this Tool"]
["This tool helps CoCs use a sampling approach to estimate a total count of the number of people within their communities who are experiencing unsheltered homelessness on the night of the PIT count. This tool is intended to support communities that are in the planning phase of their PIT count to determine sample sites and then to use that framework after the count to calculate a weighted estimate that would represent all people experiencing unsheltered homelessness in the CoC."]
["CoCs that have already conducted a PIT count using sampling and that are seeking assistance with using data collected to estimate the total unsheltered PIT count should use the PIT Count Estimating Tool, available on the How to Use Sampling within a CoC to Conduct an Unsheltered PIT Count page on HUD Exchange (linked below)."]
["This tool will only help a CoC establish an estimate of total people experiencing unsheltered homelessness and will not calculate estimates for household, demographic, or subpopulation data. To estimate more specific data about the sampled population, a community would need to conduct a complete sampling of their community. Guidance on conducting a complete sample of a community is provided in the How to Use Sampling within a CoC to Conduct an Unsheltered PIT Count guidance document (linked below). "]
[" To extrapolate for demographic data, CoCs may also consider using the PIT Count Extrapolation Tool, an Excel file available for download here:"]
["PIT Count Implementation Tools page"]
["Version 1.0 introduces the PIT Count Sampling Tool."]
["PIT Count Sampling Tool User Guide"]
["To view the comprehensive user guide PIT Count Sampling Tool, please visit this page:"]
["https://www.hudexchange.info/resource/6218/how-to-use-sampling-within-a-coc-to-conduct-an-unsheltered-pit-count/"]
[null,"Note that this page also includes: \n   (1) How to Use Sampling within a CoC to Conduct an Unsheltered Point-in-Time Count: General guidance on how to use \n         sampling to conduct an unsheltered PIT count \n   (2) PIT Count Estimation Tool: Tool to help CoCs that have already conducted a sampling-based unsheltred PIT count to \n         calculate a weighted PIT count total \n   (3) PIT Count Estimation Tool User Guide: A user guide for the PIT Count Estimation Tool\n"]
["To view all of HUD’s PIT count and HIC resources visit the PIT and HIC Guides, Tools, and Webinars Page (https://tinyurl.com/jyad88ta). This is a one-stop site where communities can access all of HUD’s guidance on how to plan and implement their PIT counts. The resources include the How to Use Sampling within a CoC to Conduct an Unsheltered PIT Count guidance document (https://tinyurl.com/t65xntfb) , the PIT Count Methodology Guide (https://tinyurl.com/29bhdka2), survey tool resources, and implementation resources.\n\nIf you have technical questions about using this PIT Count Sampling Tool, please submit your questions to the Ask A Question (AAQ) portal (https://tinyurl.com/ne39t9rw). In Step 2 of the question submission process, select “HDX Homelessness Data Exchange (including PIT, HIC, AHAR, Sys PM, LSA, and PDX)” from the “My question is related to” drop down list."]

{"sheet":"1. Subarea Types","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Subarea Types and Sampling Percentages"]
["Subarea type","Sampling percentage","Total # of subareas","Total # of subareas to be sampled"]
["Example 1",0.8,5,{"$f":"IF(OR(A3=\"\",B3=\"\",C3=\"\"),\"\",ROUND(B3*C3,0))","v":4}]
["Example 2",0.7,4,3]
["Example 3",0.4,5,2]
["Example 4",0.3,5,2]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]

{"sheet":"2. Subarea Names","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,0,5,3],[0,0,1,0]]}
["Random Seed"]
[]
[]
[]
["Subarea Names"]
[]
[{"$f":"TRANSPOSE(IF('1. Subarea Types'!A3:A6=\"\",\"\",'1. Subarea Types'!A3:A6))","v":"Example 1"},"Example 2","Example 3","Example 4"]

{"sheet":"3. Sampled Subareas & PIT","index":3,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,8,1,9],[0,0,0,9],[1,6,1,7],[1,4,1,5],[1,2,1,3],[1,0,1,1],[3,0,3,7],[4,0,4,1],[4,2,4,3],[4,4,4,5],[4,6,4,7]]}
[]
[]
[]
["Sampled Subareas & Unsheltered PIT Counts"]
["Example 1",null,"Example 2",null,"Example 3",null,"Example 4"]
["Subarea Name","PIT Count","Subarea Name","PIT Count","Subarea Name","PIT Count","Subarea Name","PIT Count"]
[]
[]
[]
[]
[{"$f":"IF('Sampling pcts'!A2=\"\", \"\", IF(5>ROUND((ROWS('2. Subarea Names'!A:A)-COUNTBLANK('2. Subarea Names'!A:A)-4)*'Sampling pcts'!A2,0), \"\", INDEX('2. Subarea Names'!A8:A12,RANK('Random ranks'!A6,'Random ranks'!A2:A6),1)))","v":""},null,null,null,{"$f":"IF('Sampling pcts'!C2=\"\", \"\", IF(5>ROUND((ROWS('2. Subarea Names'!C:C)-COUNTBLANK('2. Subarea Names'!C:C)-1)*'Sampling pcts'!C2,0), \"\", INDEX('2. Subarea Names'!C8:C12,RANK('Random ranks'!C6,'Random ranks'!C2:C6),1)))","v":""},null,{"$f":"IF('Sampling pcts'!D2=\"\", \"\", IF(5>ROUND((ROWS('2. Subarea Names'!D:D)-COUNTBLANK('2. Subarea Names'!D:D)-1)*'Sampling pcts'!D2,0), \"\", INDEX('2. Subarea Names'!D8:D12,RANK('Random ranks'!D6,'Random ranks'!D2:D6),1)))","v":""}]

{"sheet":"Sampling pcts","index":4,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[{"$f":"TRANSPOSE(IF('1. Subarea Types'!A3:A6=\"\",\"\",'1. Subarea Types'!A3:A6))","v":"Example 1"},"Example 2","Example 3","Example 4"]
[{"$f":"TRANSPOSE(IF('1. Subarea Types'!B3:B6=\"\",\"\",'1. Subarea Types'!B3:B6))","v":0.8},0.7,0.4,0.3]

{"sheet":"Random ranks","index":5,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[{"$f":"TRANSPOSE(IF('1. Subarea Types'!A3:A6=\"\",\"\",'1. Subarea Types'!A3:A6))","v":"Example 1"},"Example 2","Example 3","Example 4"]
[4.8754751682281494E-2,0.45527940988540649,4.8754751682281494E-2,4.8754751682281494E-2]
[0.29802232980728149,0.70454698801040649,0.29802232980728149,0.29802232980728149]
[0.92265611886978149,0.36033922433853149,0.92265611886978149,0.92265611886978149]
[0.54728990793228149,0.95381456613540649,0.54728990793228149,0.54728990793228149]
[0.85960680246353149,null,0.85960680246353149,0.85960680246353149]

{"sheet":"Calculations","index":6,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Subarea type count",{"$f":"CONCATENATE(\"Subarea count (\", '1. Subarea Types'!A2,\")\")","v":"Subarea count (Subarea type)"},{"$f":"CONCATENATE(\"Subarea count (\", '1. Subarea Types'!A3,\")\")","v":"Subarea count (Example 1)"},{"$f":"CONCATENATE(\"Subarea count (\", '1. Subarea Types'!A4,\")\")","v":"Subarea count (Example 2)"},{"$f":"CONCATENATE(\"Subarea count (\", '1. Subarea Types'!A5,\")\")","v":"Subarea count (Example 3)"},{"$f":"CONCATENATE(\"Subarea count (\", '1. Subarea Types'!A6,\")\")","v":"Subarea count (Example 4)"}]
[{"$f":"ROWS('1. Subarea Types'!A:A)-COUNTBLANK('1. Subarea Types'!A:A)-2","v":4},{"$f":"ROWS('2. Subarea Names'!A:A) - COUNTBLANK('2. Subarea Names'!A:A)-1","v":2},{"$f":"ROWS('2. Subarea Names'!A:A) - COUNTBLANK('2. Subarea Names'!A:A)-4","v":-1},{"$f":"ROWS('2. Subarea Names'!B:B) - COUNTBLANK('2. Subarea Names'!B:B)-1","v":0},{"$f":"ROWS('2. Subarea Names'!C:C) - COUNTBLANK('2. Subarea Names'!C:C)-1","v":0},{"$f":"ROWS('2. Subarea Names'!D:D) - COUNTBLANK('2. Subarea Names'!D:D)-1","v":0}]
[{"$f":"COLUMNS('2. Subarea Names'!7:7)-COUNTBLANK('2. Subarea Names'!7:7)","v":4}]

{"sheet":"4. Extrapolated PIT Count","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1],[5,0,5,4]]}
["Unsheltered PIT Count Totals"]
["Unweighted Sample",{"$f":"SUM(B8:B11)","v":0}]
["Weighted Sample",{"$f":"SUM(E8:E11)","v":0}]
[]
[]
["Unsheltered PIT Count Subtotals"]
["Subarea Type","Summed Total # People Counted","Probability of Selection","Inverse of Probability (i.e., Weight)","Total # People to Include in PIT Count"]
[{"$f":"'1. Subarea Types'!A3","v":"Example 1"},{"$f":"SUM('3. Sampled Subareas & PIT'!B:B)","v":0},{"$f":"'1. Subarea Types'!B3","v":0.8},{"$f":"IF(C8=\"\",\"\", 1/C8)","v":1.25},{"$f":"IF(OR(B8=\"\",D8=\"\"),\"\",B8*D8)","v":0}]
[{"$f":"'1. Subarea Types'!A4","v":"Example 2"},{"$f":"SUM('3. Sampled Subareas & PIT'!D:D)","v":0},{"$f":"'1. Subarea Types'!B4","v":0.7},{"$f":"IF(C9=\"\",\"\", 1/C9)","v":1.4285714285714286},{"$f":"IF(OR(B9=\"\",D9=\"\"),\"\",B9*D9)","v":0}]
[{"$f":"'1. Subarea Types'!A5","v":"Example 3"},{"$f":"SUM('3. Sampled Subareas & PIT'!F:F)","v":0},{"$f":"'1. Subarea Types'!B5","v":0.4},{"$f":"IF(C10=\"\",\"\", 1/C10)","v":2.5},{"$f":"IF(OR(B10=\"\",D10=\"\"),\"\",B10*D10)","v":0}]
[{"$f":"'1. Subarea Types'!A6","v":"Example 4"},{"$f":"SUM('3. Sampled Subareas & PIT'!H:H)","v":0},{"$f":"'1. Subarea Types'!B6","v":0.3},{"$f":"IF(C11=\"\",\"\", 1/C11)","v":3.3333333333333335},{"$f":"IF(OR(B11=\"\",D11=\"\"),\"\",B11*D11)","v":0}]

{"sheet":"5. Version Change Log","index":8,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Version","Date","Change"]
[1,"2021-09-01","PIT Count Sampling Tool created."]