{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["User Guide","1. Subarea Types","2. PIT Count Worksheet","3. Extrapolated PIT Count","4. 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":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,11,15],[24,0,24,15],[25,0,25,15],[26,1,26,15],[27,0,32,15],[12,0,12,15],[13,0,13,15],[14,0,14,15],[15,0,15,15],[16,0,16,15],[21,0,21,15],[22,0,22,15],[23,0,23,15],[18,0,18,15],[17,0,17,15],[19,0,19,15],[20,0,20,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PIT Count Estimating 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 counts by sampling parts of their jurisdiction and using those samples to derive a full estimate of people experiencing unsheltered homelessness.  \n\nThe PIT Count Estimating Tool is intended to help CoCs develop the 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 that already conducted the unsheltered PIT count using a sampling approach to estimate a total unsheltered PIT count.  "]
["This tool assumes that the CoC already divided its geography into smaller subareas and categorized them based on the likely number of people experiencing unsheltered homelessness within each subarea, then sampled those selected areas during the unsheltered PIT count. The tool takes the CoC’s sampled PIT count data and calculates an estimated total unsheltered PIT count, which is weighted to represent the subareas that were not counted to estimate an overall count for the full area. This tool is designed to guide CoCs through these steps."]
["CoCs seeking assistance with selecting sample sites should use the PIT Count Sampling 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 Estimating Tool."]
["PIT Count Estimating Tool User Guide"]
["To view the comprehensive user guide for the PIT Count Estimating 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 PIT Count: General guidance on how to use \n         sampling to conduct an unsheltered PIT count \n   (2) PIT Count Sampling Tool: A tool to help CoCs to develop and use a sampling appraoch to conduct their unsheltered PIT \n         counts. This tool includes the \"estimation\" function covered in the PIT Count Estimating Tool.\n   (3) PIT Count Sampling Tool User Guide: A user guide for the PIT Count Sampling 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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,0,4,3]]}
[]
[]
[]
[]
["Subarea Types and Percentages sampled"]
["Subarea type","Total # of subareas","Total # of subareas sampled","Percentage sampled"]
["Certainty",6,6,{"$f":"IF(OR(A7=\"\",B7=\"\",C7=\"\"),\"\",C7/B7)","v":1}]
["High",1,1,{"$f":"IF(OR(A8=\"\",B8=\"\",C8=\"\"),\"\",C8/B8)","v":1}]
["Medium/Low",23,23,{"$f":"IF(OR(A9=\"\",B9=\"\",C9=\"\"),\"\",C9/B9)","v":1}]
["None/Rare",471,369,{"$f":"IF(OR(A10=\"\",B10=\"\",C10=\"\"),\"\",C10/B10)","v":0.78343949044585992}]

{"sheet":"2. PIT Count Worksheet","index":2,"n_rows":376,"n_cols":8,"rows_kept":376,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["PIT Count Worksheet"]
["Certainty",null,"High",null,"Medium/Low",null,"None/Rare"]
["Subarea Name","PIT Count","Subarea Name","PIT Count","Subarea Name","PIT Count","Subarea Name","PIT Count"]
[150,0,251,2,29,0,0,0]
[152,0,null,null,64,1,1,0]
[209,0,null,null,83,0,2,0]
[229,0,null,null,107,0,3,0]
[230,0,null,null,159,0,7,0]
[302,0,null,null,161,0,9,0]
[null,null,null,null,190,0,10,0]
[null,null,null,null,191,0,12,0]
[null,null,null,null,198,0,13,0]
[null,null,null,null,208,0,14,0]
[null,null,null,null,210,0,15,0]
[null,null,null,null,211,0,16,0]
[null,null,null,null,217,0,17,0]
[null,null,null,null,227,0,18,0]
[null,null,null,null,287,0,19,0]
[null,null,null,null,297,0,22,0]
[null,null,null,null,332,0,23,0]
[null,null,null,null,340,0,24,0]
[null,null,null,null,383,0,25,0]
[null,null,null,null,407,0,27,0]
[null,null,null,null,440,0,28,0]
[null,null,null,null,450,0,30,0]
[null,null,null,null,453,0,31,0]
[null,null,null,null,null,null,32,0]
[null,null,null,null,null,null,33,0]
[null,null,null,null,null,null,34,0]
[null,null,null,null,null,null,35,0]
[null,null,null,null,null,null,36,0]
[null,null,null,null,null,null,37,0]
[null,null,null,null,null,null,38,0]
[null,null,null,null,null,null,40,0]
[null,null,null,null,null,null,42,0]
[null,null,null,null,null,null,43,0]
[null,null,null,null,null,null,44,0]
[null,null,null,null,null,null,45,0]
[null,null,null,null,null,null,46,0]
[null,null,null,null,null,null,47,0]
[null,null,null,null,null,null,48,0]
[null,null,null,null,null,null,49,0]
[null,null,null,null,null,null,51,0]
[null,null,null,null,null,null,52,0]
[null,null,null,null,null,null,53,0]
[null,null,null,null,null,null,54,0]
[null,null,null,null,null,null,55,0]
[null,null,null,null,null,null,56,0]
[null,null,null,null,null,null,57,0]
[null,null,null,null,null,null,58,0]
[null,null,null,null,null,null,59,0]
[null,null,null,null,null,null,60,0]
[null,null,null,null,null,null,61,0]
[null,null,null,null,null,null,63,0]
[null,null,null,null,null,null,65,0]
[null,null,null,null,null,null,66,0]
[null,null,null,null,null,null,67,0]
[null,null,null,null,null,null,69,0]
[null,null,null,null,null,null,70,0]
[null,null,null,null,null,null,71,0]
[null,null,null,null,null,null,72,0]
[null,null,null,null,null,null,73,0]
[null,null,null,null,null,null,74,0]
[null,null,null,null,null,null,75,0]
[null,null,null,null,null,null,76,0]
[null,null,null,null,null,null,77,0]
[null,null,null,null,null,null,78,0]
[null,null,null,null,null,null,79,0]
[null,null,null,null,null,null,80,0]
[null,null,null,null,null,null,81,0]
[null,null,null,null,null,null,82,0]
[null,null,null,null,null,null,85,0]
[null,null,null,null,null,null,86,0]
[null,null,null,null,null,null,87,0]
[null,null,null,null,null,null,89,0]
[null,null,null,null,null,null,90,0]
[null,null,null,null,null,null,91,0]
[null,null,null,null,null,null,92,0]
[null,null,null,null,null,null,93,0]
[null,null,null,null,null,null,94,0]
[null,null,null,null,null,null,95,0]
[null,null,null,null,null,null,96,0]
[null,null,null,null,null,null,97,0]
[null,null,null,null,null,null,98,0]
[null,null,null,null,null,null,99,0]
[null,null,null,null,null,null,100,0]
[null,null,null,null,null,null,101,0]
[null,null,null,null,null,null,102,0]
[null,null,null,null,null,null,103,0]
[null,null,null,null,null,null,105,0]
[null,null,null,null,null,null,106,0]
[null,null,null,null,null,null,108,0]
[null,null,null,null,null,null,109,0]
[null,null,null,null,null,null,110,0]
[null,null,null,null,null,null,112,0]
[null,null,null,null,null,null,113,0]
[null,null,null,null,null,null,114,0]
[null,null,null,null,null,null,115,0]
[null,null,null,null,null,null,116,0]
[null,null,null,null,null,null,117,0]
[null,null,null,null,null,null,118,0]
[null,null,null,null,null,null,119,0]
[null,null,null,null,null,null,125,0]
[null,null,null,null,null,null,126,0]
[null,null,null,null,null,null,127,0]
[null,null,null,null,null,null,128,0]
[null,null,null,null,null,null,129,0]
[null,null,null,null,null,null,130,0]
[null,null,null,null,null,null,131,0]
[null,null,null,null,null,null,132,0]
[null,null,null,null,null,null,133,0]
[null,null,null,null,null,null,134,0]
[null,null,null,null,null,null,135,0]
[null,null,null,null,null,null,136,0]
[null,null,null,null,null,null,138,0]
[null,null,null,null,null,null,139,0]
[null,null,null,null,null,null,140,0]
[null,null,null,null,null,null,141,0]
[null,null,null,null,null,null,142,0]
[null,null,null,null,null,null,143,0]
[null,null,null,null,null,null,144,0]
[null,null,null,null,null,null,147,0]
[null,null,null,null,null,null,148,0]
[null,null,null,null,null,null,151,0]
[null,null,null,null,null,null,154,0]
[null,null,null,null,null,null,155,0]
[null,null,null,null,null,null,156,0]
[null,null,null,null,null,null,157,0]
[null,null,null,null,null,null,158,0]
[null,null,null,null,null,null,160,0]
[null,null,null,null,null,null,162,0]
[null,null,null,null,null,null,163,0]
[null,null,null,null,null,null,164,0]
[null,null,null,null,null,null,165,0]
[null,null,null,null,null,null,166,0]
[null,null,null,null,null,null,167,0]
[null,null,null,null,null,null,168,0]
[null,null,null,null,null,null,169,0]
[null,null,null,null,null,null,170,0]
[null,null,null,null,null,null,176,0]
[null,null,null,null,null,null,177,0]
[null,null,null,null,null,null,178,0]
[null,null,null,null,null,null,179,2]
[null,null,null,null,null,null,180,0]
[null,null,null,null,null,null,181,0]
[null,null,null,null,null,null,182,0]
[null,null,null,null,null,null,183,0]
[null,null,null,null,null,null,184,0]
[null,null,null,null,null,null,185,0]
[null,null,null,null,null,null,186,0]
[null,null,null,null,null,null,187,0]
[null,null,null,null,null,null,188,0]
[null,null,null,null,null,null,189,0]
[null,null,null,null,null,null,192,0]
[null,null,null,null,null,null,193,0]
[null,null,null,null,null,null,194,0]
[null,null,null,null,null,null,195,0]
[null,null,null,null,null,null,196,0]
[null,null,null,null,null,null,197,0]
[null,null,null,null,null,null,199,0]
[null,null,null,null,null,null,200,0]
[null,null,null,null,null,null,201,0]
[null,null,null,null,null,null,202,0]
[null,null,null,null,null,null,203,0]
[null,null,null,null,null,null,204,0]
[null,null,null,null,null,null,205,0]
[null,null,null,null,null,null,206,0]
[null,null,null,null,null,null,207,0]
[null,null,null,null,null,null,212,0]
[null,null,null,null,null,null,213,0]
[null,null,null,null,null,null,214,0]
[null,null,null,null,null,null,215,0]
[null,null,null,null,null,null,216,0]
[null,null,null,null,null,null,218,0]
[null,null,null,null,null,null,219,0]
[null,null,null,null,null,null,220,0]
[null,null,null,null,null,null,221,0]
[null,null,null,null,null,null,222,0]
[null,null,null,null,null,null,223,0]
[null,null,null,null,null,null,224,0]
[null,null,null,null,null,null,225,0]
[null,null,null,null,null,null,226,0]
[null,null,null,null,null,null,228,0]
[null,null,null,null,null,null,231,0]
[null,null,null,null,null,null,232,0]
[null,null,null,null,null,null,238,0]
[null,null,null,null,null,null,240,0]
[null,null,null,null,null,null,242,0]
[null,null,null,null,null,null,248,0]
[null,null,null,null,null,null,249,0]
[null,null,null,null,null,null,250,0]
[null,null,null,null,null,null,252,0]
[null,null,null,null,null,null,253,0]
[null,null,null,null,null,null,254,0]
[null,null,null,null,null,null,255,0]
[null,null,null,null,null,null,256,0]
[null,null,null,null,null,null,257,0]
[null,null,null,null,null,null,258,0]
[null,null,null,null,null,null,259,0]
[null,null,null,null,null,null,260,0]
[null,null,null,null,null,null,261,0]
[null,null,null,null,null,null,262,0]
[null,null,null,null,null,null,263,0]
[null,null,null,null,null,null,264,0]
[null,null,null,null,null,null,267,0]
[null,null,null,null,null,null,268,0]
[null,null,null,null,null,null,269,0]
[null,null,null,null,null,null,270,0]
[null,null,null,null,null,null,271,0]
[null,null,null,null,null,null,272,0]
[null,null,null,null,null,null,273,0]
[null,null,null,null,null,null,274,0]
[null,null,null,null,null,null,275,0]
[null,null,null,null,null,null,276,0]
[null,null,null,null,null,null,277,0]
[null,null,null,null,null,null,278,0]
[null,null,null,null,null,null,279,0]
[null,null,null,null,null,null,280,0]
[null,null,null,null,null,null,281,0]
[null,null,null,null,null,null,283,0]
[null,null,null,null,null,null,284,0]
[null,null,null,null,null,null,286,0]
[null,null,null,null,null,null,288,0]
[null,null,null,null,null,null,289,0]
[null,null,null,null,null,null,290,0]
[null,null,null,null,null,null,291,0]
[null,null,null,null,null,null,292,0]
[null,null,null,null,null,null,293,0]
[null,null,null,null,null,null,294,0]
[null,null,null,null,null,null,295,0]
[null,null,null,null,null,null,296,0]
[null,null,null,null,null,null,298,0]
[null,null,null,null,null,null,299,0]
[null,null,null,null,null,null,300,0]
[null,null,null,null,null,null,301,0]
[null,null,null,null,null,null,303,0]
[null,null,null,null,null,null,304,0]
[null,null,null,null,null,null,307,0]
[null,null,null,null,null,null,308,0]
[null,null,null,null,null,null,309,0]
[null,null,null,null,null,null,310,0]
[null,null,null,null,null,null,311,0]
[null,null,null,null,null,null,312,0]
[null,null,null,null,null,null,313,0]
[null,null,null,null,null,null,314,0]
[null,null,null,null,null,null,315,0]
[null,null,null,null,null,null,317,0]
[null,null,null,null,null,null,318,0]
[null,null,null,null,null,null,321,0]
[null,null,null,null,null,null,322,1]
[null,null,null,null,null,null,323,0]
[null,null,null,null,null,null,326,0]
[null,null,null,null,null,null,327,0]
[null,null,null,null,null,null,328,0]
[null,null,null,null,null,null,329,0]
[null,null,null,null,null,null,330,0]
[null,null,null,null,null,null,331,0]
[null,null,null,null,null,null,333,0]
[null,null,null,null,null,null,334,0]
[null,null,null,null,null,null,335,0]
[null,null,null,null,null,null,336,0]
[null,null,null,null,null,null,338,0]
[null,null,null,null,null,null,341,0]
[null,null,null,null,null,null,343,0]
[null,null,null,null,null,null,344,0]
[null,null,null,null,null,null,345,0]
[null,null,null,null,null,null,346,0]
[null,null,null,null,null,null,347,0]
[null,null,null,null,null,null,348,0]
[null,null,null,null,null,null,349,0]
[null,null,null,null,null,null,350,0]
[null,null,null,null,null,null,351,0]
[null,null,null,null,null,null,352,0]
[null,null,null,null,null,null,362,0]
[null,null,null,null,null,null,363,0]
[null,null,null,null,null,null,364,0]
[null,null,null,null,null,null,365,0]
[null,null,null,null,null,null,366,0]
[null,null,null,null,null,null,367,0]
[null,null,null,null,null,null,368,0]
[null,null,null,null,null,null,369,0]
[null,null,null,null,null,null,370,0]
[null,null,null,null,null,null,371,0]
[null,null,null,null,null,null,372,0]
[null,null,null,null,null,null,373,0]
[null,null,null,null,null,null,377,0]
[null,null,null,null,null,null,378,0]
[null,null,null,null,null,null,379,0]
[null,null,null,null,null,null,380,0]
[null,null,null,null,null,null,381,0]
[null,null,null,null,null,null,384,0]
[null,null,null,null,null,null,385,0]
[null,null,null,null,null,null,386,0]
[null,null,null,null,null,null,387,0]
[null,null,null,null,null,null,388,0]
[null,null,null,null,null,null,389,0]
[null,null,null,null,null,null,390,0]
[null,null,null,null,null,null,391,0]
[null,null,null,null,null,null,392,0]
[null,null,null,null,null,null,393,0]
[null,null,null,null,null,null,394,0]
[null,null,null,null,null,null,396,0]
[null,null,null,null,null,null,397,0]
[null,null,null,null,null,null,400,0]
[null,null,null,null,null,null,401,0]
[null,null,null,null,null,null,402,0]
[null,null,null,null,null,null,403,0]
[null,null,null,null,null,null,404,0]
[null,null,null,null,null,null,405,0]
[null,null,null,null,null,null,406,0]
[null,null,null,null,null,null,408,0]
[null,null,null,null,null,null,409,0]
[null,null,null,null,null,null,410,0]
[null,null,null,null,null,null,411,0]
[null,null,null,null,null,null,412,0]
[null,null,null,null,null,null,413,0]
[null,null,null,null,null,null,414,0]
[null,null,null,null,null,null,417,0]
[null,null,null,null,null,null,420,0]
[null,null,null,null,null,null,422,0]
[null,null,null,null,null,null,423,0]
[null,null,null,null,null,null,424,0]
[null,null,null,null,null,null,425,0]
[null,null,null,null,null,null,427,0]
[null,null,null,null,null,null,428,0]
[null,null,null,null,null,null,431,0]
[null,null,null,null,null,null,432,0]
[null,null,null,null,null,null,433,0]
[null,null,null,null,null,null,434,0]
[null,null,null,null,null,null,435,0]
[null,null,null,null,null,null,436,0]
[null,null,null,null,null,null,437,0]
[null,null,null,null,null,null,442,0]
[null,null,null,null,null,null,443,0]
[null,null,null,null,null,null,444,0]
[null,null,null,null,null,null,446,0]
[null,null,null,null,null,null,447,0]
[null,null,null,null,null,null,448,0]
[null,null,null,null,null,null,449,0]
[null,null,null,null,null,null,454,0]
[null,null,null,null,null,null,455,0]
[null,null,null,null,null,null,456,0]
[null,null,null,null,null,null,457,0]
[null,null,null,null,null,null,458,0]
[null,null,null,null,null,null,459,0]
[null,null,null,null,null,null,460,0]
[null,null,null,null,null,null,461,0]
[null,null,null,null,null,null,462,0]
[null,null,null,null,null,null,465,0]
[null,null,null,null,null,null,466,0]
[null,null,null,null,null,null,469,0]
[null,null,null,null,null,null,470,0]
[null,null,null,null,null,null,471,0]
[null,null,null,null,null,null,472,0]
[null,null,null,null,null,null,474,0]
[null,null,null,null,null,null,475,0]
[null,null,null,null,null,null,476,0]
[null,null,null,null,null,null,477,0]
[null,null,null,null,null,null,482,0]
[null,null,null,null,null,null,483,0]
[null,null,null,null,null,null,484,0]
[null,null,null,null,null,null,485,0]
[null,null,null,null,null,null,488,0]
[null,null,null,null,null,null,490,0]
[null,null,null,null,null,null,492,0]
[null,null,null,null,null,null,493,0]
[null,null,null,null,null,null,494,0]
[null,null,null,null,null,null,495,0]
[null,null,null,null,null,null,497,0]
[null,null,null,null,null,null,498,2]
[null,null,null,null,null,null,499,0]
[null,null,null,null,null,null,500,0]

{"sheet":"3. Extrapolated PIT Count","index":3,"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":8}]
["Weighted Sample",{"$f":"SUM(E8:E11)","v":9.382113821138212}]
[]
[]
["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'!A7","v":"Certainty"},{"$f":"SUM('2. PIT Count Worksheet'!B:B)","v":0},{"$f":"'1. Subarea Types'!D7","v":1},{"$f":"IF(C8=\"\",\"\", 1/C8)","v":1},{"$f":"IF(OR(B8=\"\",D8=\"\"),\"\",B8*D8)","v":0}]
[{"$f":"'1. Subarea Types'!A8","v":"High"},{"$f":"SUM('2. PIT Count Worksheet'!D:D)","v":2},{"$f":"'1. Subarea Types'!D8","v":1},{"$f":"IF(C9=\"\",\"\", 1/C9)","v":1},{"$f":"IF(OR(B9=\"\",D9=\"\"),\"\",B9*D9)","v":2}]
[{"$f":"'1. Subarea Types'!A9","v":"Medium/Low"},{"$f":"SUM('2. PIT Count Worksheet'!F:F)","v":1},{"$f":"'1. Subarea Types'!D9","v":1},{"$f":"IF(C10=\"\",\"\", 1/C10)","v":1},{"$f":"IF(OR(B10=\"\",D10=\"\"),\"\",B10*D10)","v":1}]
[{"$f":"'1. Subarea Types'!A10","v":"None/Rare"},{"$f":"SUM('2. PIT Count Worksheet'!H:H)","v":5},{"$f":"'1. Subarea Types'!D10","v":0.78343949044585992},{"$f":"IF(C11=\"\",\"\", 1/C11)","v":1.2764227642276422},{"$f":"IF(OR(B11=\"\",D11=\"\"),\"\",B11*D11)","v":6.3821138211382111}]

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