{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Certification","Operating Budget","Tenant Survey and Evaluation","Performance Measures","Rep Worksheet","Data Sheet","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":141,"comments":2,"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":37,"n_cols":1,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,52,8],[2,0,6,8],[0,0,1,8],[7,0,13,8],[14,0,21,8],[22,0,35,8]]}
["INSTRUCTIONS"]
[]
["Pursuant to the Budget Act of 2019 as amended by Section 16 of Senate Bill 109. \nThe Department may implement the activities described in this provision through the issuance of forms, guidelines, and one or more notices of funding availability or requests for proposals, as the Department deems necessary."]
[]
[]
[]
[]
["Bi-Annual Reporting \nis due to be submitted to the Department no later than 30 days after the reporting period.  For example, a reporting period of July 1, 2020 to December 31, 2020 would have a due date of January 31, 2021 and a reporting period of January 1, 2021 to June 30, 2021, would have a due date of July 31, 2021. All reports must be submitted to: PAS@HCD.CA.GOV.  Please include in your email subject line: Bi-Annual Report, project name and contract number."]
[]
[]
[]
[]
[]
[]
["Completion of the Reporting Workbook:\nAll fields in which information is requested must be completed by the grantee within the 4 tabs of the reporting workbook.  Reporting workbooks which contain blank information will be considered incomplete and will be returned to the grantee for completion.  Any questions pertaining to the grantees reporting requirements should be directed to the Grant Management Representative assigned to their project. Or submit your email inquiry at PAS@HCD.CA.GOV, if, you do not have your Grant Management Representative information."]
[]
[]
[]
[]
[]
[]
[]
["Pursuant to Exhibit D, Section 5 of the Standard Agreement as stated under Reporting/Audits, it reads:   \nCommencing with the Effective Date of this Agreement and continuing through the Expiration Date, the Contractor shall submit a biannual report to the Department as follows:  1) If applicable, no later than one hundred and eighty (180) days after the Standard Agreement expires; the applicant shall submit the data as required by the Department to measure the costs and outcomes for each of the beds assisted pursuant to the Program. The Contractor shall work with service providers or other sub-recipients to gather any applicable data.\n2) The Contractor shall report on the sources of participant referrals to the shelter and submit both client data and performance outcome data to the Department. Performance outcome data shall include, but is not limited to, number of participants provided shelter, number assisted by the program, reason for exit, and satisfaction as measured in a survey, length of stay, and locating permanent housing.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            \nB.  The Department reserves the right to monitor the expenditures and activities of the Contractor, at the Departments discretion, to ensure compliance with Program requirements   \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pursuant to Section II E 5 & 6 of the Departments PAS Notice of Funding Availability (NOFA) dated December 31, 2019 reads:\nPerformance Measures: Projected measurable outcomes, including the number of participants, reported every six-months through June 30, 2022, that:\n a. Are assisted by the shelter in general;\n b. Are assisted by the PAS program specifically;\n c. Show increased residential stability;\n d. Show increased skills and/or income; \n e. A measurable outcome from a tenant satisfaction survey, as determined by the applicant    (for example does the tenant feel more self-sufficient); and \n f. An additional measurable outcome from a tenant satisfaction survey, as determined by the applicant.\n\nPerformance Measures: An evaluation plan that describes how data will be collected, tracked and analyzed in order to determine the effectiveness of the project. The evaluation plan should include the measurable outcomes, as well as indicate who will analyze the data and perform the PAS program evaluation."]

{"sheet":"Certification","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,0,17,9],[18,0,18,9],[15,1,15,4],[12,1,12,4],[13,1,13,4],[12,6,12,9],[15,6,15,9],[14,1,14,4],[16,1,16,4],[14,6,14,9],[16,6,16,9],[1,0,1,3],[2,0,2,1],[4,0,4,1],[8,0,10,9],[13,6,13,9],[19,0,19,1],[19,2,19,3],[22,6,22,9],[23,6,23,9],[22,0,22,5],[23,0,23,5],[20,0,20,5],[21,0,21,5],[20,6,20,9],[21,6,21,9]]}
["first sheet: cover and certification"]
["DEPARTMENT OF HOUSING AND COMMUNITY DEVELOPMENT"]
["DIVISION OF STATE FINANCIAL ASSISTANCE"]
["STATE GRANT MANAGEMENT"]
["2020 West El Camino, 4th Floor"]
["Sacramento, CA  95833"]
["PAS@HCD.CA.GOV "]
[]
["PET ASSISTANCE AND SUPPORT (PAS) PROGRAM\nBI-ANNUAL REPORTING\nCERTIFICATION"]
[]
[]
["Last Updated: 6/16/2022"]
["HCD Contract Number:",null,null,null,null,"Reporting Period",{"$f":"IF(TODAY()>=12/31/2022,\"January 1, 2022 - June 30, 2022\",\"July 1, 2022 - December 31, 2022\")","v":"January 1, 2022 - June 30, 2022"}]
["Project Name:",null,null,null,null,"Contractor Name:"]
["Project Address (Address, City, State, Zip):",null,null,null,null,"Project County"]
["Preparer Phone Number:",null,null,null,null,"Preparer Name:"]
["Total PAS Program Award:",null,null,null,null,"Preparer Email:"]
["CERTIFICATION"]
["By signing this request, I certify to the best of my knowledge and belief that the request is true, complete, and accurate, and the expenditures, disbursements and cash receipts will be  for the purposes and objectives set forth in the terms and conditions of the State award. I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise. (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)"]
["Signature Method: ",null,"Select One"]
["Name of Authorized Person (per final resolution)",null,null,null,null,null,"Title of Authorized Person"]
[]
["Signature of Authorized Person",null,null,null,null,null,"Date"]

{"sheet":"Operating Budget","index":2,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[54,1,54,6],[39,1,39,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[29,1,29,4],[30,1,30,4],[1,1,2,6],[23,1,23,4],[24,1,24,4],[25,1,25,4],[3,1,3,3],[3,4,3,6],[12,1,12,4],[5,1,5,4],[6,1,6,4],[5,5,5,6],[6,5,6,6],[7,1,7,6],[3,8,3,9],[10,1,10,5],[11,1,11,6],[52,1,52,4],[15,1,15,4],[26,1,26,4],[28,1,28,4],[31,1,31,4],[27,1,27,6],[32,1,32,4],[40,1,40,4],[41,1,41,4],[42,1,42,4],[43,1,43,4],[44,1,44,4],[9,1,9,5],[53,1,53,6],[4,1,4,6],[13,1,13,4],[14,1,14,4],[50,1,50,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,4],[51,1,51,4],[52,5,52,6],[8,1,8,5],[33,1,33,4]]}
[null,"beginning of second sheet: operating budget"]
[null,"PET ASSISTANCE AND SUPPORT (PAS) PROGRAM\nOPERATING BUDGET"]
[]
[null,"HCD Contract Number:",null,null,{"$f":"Certification!B13","v":0}]
[null,"Please include revenue and expenses as they relate to the Shelter in general and PAS-specific funding and expenses for the current reporting period. Input 0 in spaces where not applicable. Include funds spent/to be reimbursed by PAS."]
[null,"Total PAS Program Award:",null,null,null,{"$f":"Certification!B17","v":0}]
[null,"Total PAS Amount Disbursed by HCD:",null,null,null,0]
[null,"Shelter Operation"]
[null,"Is this shelter currently in operation? If No, please explain in additional comments section below.",null,null,null,null,"Please Select"]
[null,"Please input the date that the shelter began operation. If it is not currently in operation, please input the anticipated date for shelter operation beginning"]
[null,"Are the grant funds in an interest-bearing checking or savings account insured by the federal or state government and all interest earned from the deposit of grant funds used for eligible Program activities and accounted for? (pursuant to Exhibit B Section 5(B) of the Standard Agreement) \nIf No, please explain in additional notes below.",null,null,null,null,"Please Select"]
[null,{"$f":"IF(Certification!G13=\"\",\"Actual Revenues from this reporting period.\",_xlfn.CONCAT(\"Actual Revenues from \",Certification!G13))","v":"Actual Revenues from January 1, 2022 - June 30, 2022"}]
[null,"Revenue Sources",null,null,null,"PAS Revenue","Other Shelter Revenue"]
[null,"PAS Funding expended this reporting period",null,null,null,0]
[null,"PAS Funds Interest",null,null,null,0]
[null,"Private Donations ",null,null,null,null,0]
[null,"Local Government:",null,null,null,null,0]
[null,"State  ",null,null,null,null,0]
[null,"FEMA",null,null,null,null,0]
[null,"Federal (VOCA funding)",null,null,null,null,0]
[null,"Rental Income",null,null,null,null,0]
[null,"Fees",null,null,null,null,0]
[null,"Fundraising",null,null,null,null,0]
[null,"Other (enter here)",null,null,null,null,0]
[null,"Other (enter here)",null,null,null,null,0]
[null,"Other (enter here)",null,null,null,null,0]
[null,"Total Revenue",null,null,null,{"$f":"SUM($F14:$F26)","v":0},{"$f":"SUM($G14:$G26)","v":0}]
[null,{"$f":"IF(Certification!G13=\"\",\"Actual Expenses from this reporting period.\",_xlfn.CONCAT(\"Actual Expenses from \",Certification!G13))","v":"Actual Expenses from January 1, 2022 - June 30, 2022"}]
[null,"Expenses",null,null,null,"PAS Expenditures","Other Shelter Expenditures"]
[null,"Administration (including admin staff)",null,null,null,null,0]
[null,"Staff (for direct client services)",null,null,null,null,0]
[null,"Accounting & Legal",null,null,null,null,0]
[null,"Rent/Lease",null,null,null,null,0]
[null,"Operating and Maintenance ",null,null,null,null,0]
[null,"Debt Service (Principal & Interest paid)",null,null,null,null,0]
[null,"Taxes",null,null,null,null,0]
[null,"Utilities",null,null,null,null,0]
[null,"Insurance",null,null,null,null,0]
[null,"Food-Residents",null,null,null,null,0]
[null,"Crates and Kennels (PAS)",null,null,null,0,0]
[null,"Food-Animals (PAS)",null,null,null,0,0]
[null,"Veterinarian Services (PAS)",null,null,null,0,0]
[null,"Staff (for assisting Pets) (PAS)",null,null,null,0,0]
[null,"Independent Audit (PAS)",null,null,null,0,0]
[null,"Liability Insurance (PAS)",null,null,null,0,0]
[null,"Other (enter here)",null,null,null,0,0]
[null,"Other (enter here)",null,null,null,0,0]
[null,"Other (enter here)",null,null,null,0,0]
[null,"Other (enter here)",null,null,null,0,0]
[null,"TOTAL EXPENSES",null,null,null,{"$f":"SUM(F30:F49)","v":0},{"$f":"SUM(G30:G49)","v":0}]
[null,"PAS Net Operating Income",null,null,null,{"$f":"F27-F50","v":0}]
[null,"Non-PAS Net Operating Income\nIf negative, please explain why in Additional Notes",null,null,null,null,{"$f":"G27-G50","v":0}]
[null,"TOTAL NET OPERATING INCOME",null,null,null,{"$f":"(F27+G27)-(F50+G50)","v":0}]
[null,"Additional Notes"]
[]
[null,"Note: if you need to customize this form, please contact your PAS HCD Representative. "]

{"sheet":"Tenant Survey and Evaluation","index":3,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,1,25,11],[26,1,26,11],[27,1,27,11],[28,1,28,11],[23,1,23,11],[24,1,24,11],[21,1,21,11],[20,1,20,11],[19,1,19,6],[19,7,19,11],[22,1,22,11],[15,1,15,11],[16,1,16,11],[17,1,17,11],[18,1,18,11],[13,1,13,6],[1,1,2,11],[14,1,14,11],[4,1,4,11],[5,1,5,11],[6,1,6,11],[7,1,7,11],[8,1,8,11],[9,1,9,11],[10,1,10,11],[11,1,11,11],[12,1,12,11],[13,7,13,11],[3,7,3,8],[3,9,3,11],[3,1,3,3],[3,4,3,6]]}
[null,"beginning of sheet 3: Tenant survey and evaluation"]
[null,"PET ASSISTANCE AND SUPPORT (PAS) PROGRAM\nTENANT SURVEY"]
[]
[null,"HCD Contract Number:",null,null,{"$f":"Certification!B13","v":0},null,null,"Reporting Period: ",null,{"$f":"IF(Certification!G13=\"\",\"\",Certification!G13)","v":"January 1, 2022 - June 30, 2022"}]
[null,"I. Tenant Satisfaction Survey \nThe results of the survey may be incorporated as part of the other category's under Measurable Outcomes, i.e., satisfaction measured in a survey that would reveal the length of stay and locating permanent housing."]
[null,"1. Describe the type of questions asked, which should also include PAS or pet-specific questions."]
[]
[null,"2. How are the questions reviewed? "]
[]
[null,"3. What do you do with the results?"]
[]
[null,"4. How often do you conduct the survey? "]
[]
[null,"Most current copy or sample of tenant satisfaction survey submitted with Report? ",null,null,null,null,null,"Select One"]
[null,"II. Tenant Exit Survey\nplease submit a copy or sample of a tenant exit survey"]
[null,"1. Describe the questions asked to determine the reason(s) for exiting the shelter."]
[]
[null,"2. Provide the reason(s) given for tenants exiting the shelter."]
[]
[null,"Copy or sample of tenant exit survey submitted with Report? ",null,null,null,null,null,"Select One"]
[null,"III. Evaluation Plan"]
[null,"1. Describe your evaluation plan. "]
[]
[null,"2. How have you been collecting, tracking and analyzing the data (including the data from the measurable outcome category's listed within the Performance Measures Report) on the effectiveness of your project?"]
[]
[null,"3. Who is analyzing the data and performing the program evaluation? (e.g. staff, consultant, etc)."]
[]
[null,"4. What are any outcomes of the analyses? "]

{"sheet":"Performance Measures","index":4,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[3,2,3,3],[3,4,3,8],[34,0,34,3],[32,6,32,8],[33,6,33,8],[34,6,34,8],[16,6,16,8],[17,6,17,8],[18,0,18,3],[32,0,32,3],[33,0,33,3],[18,6,18,8],[19,0,19,3],[19,6,19,8],[8,0,8,3],[15,0,15,3],[12,6,12,8],[13,6,13,8],[21,0,21,8],[12,0,12,3],[13,0,13,3],[24,0,24,3],[24,6,24,8],[7,0,7,8],[26,6,26,8],[16,0,16,3],[17,0,17,3],[35,0,35,3],[22,0,22,8],[20,0,20,3],[28,0,28,3],[25,6,25,8],[27,6,27,8],[25,0,25,3],[39,0,39,8],[42,0,42,8],[43,0,43,3],[43,4,43,7],[29,0,29,3],[29,6,29,8],[45,0,45,3],[44,4,44,7],[45,4,45,7],[40,0,40,3],[38,0,38,3],[35,6,35,8],[38,6,38,8],[54,3,54,4],[51,0,51,2],[52,0,52,2],[30,6,30,8],[46,0,46,8],[51,3,51,4],[48,0,48,2],[48,3,48,4],[49,0,49,2],[49,3,49,4],[50,0,50,2],[50,3,50,4],[53,0,53,2],[54,0,54,2],[52,3,52,4],[53,3,53,4],[41,0,41,3],[44,0,44,3],[40,4,40,8],[41,4,41,8],[30,0,30,3],[36,0,36,3],[36,6,36,8],[47,0,47,8],[60,0,66,8],[56,0,56,2],[57,0,57,2],[58,0,58,2],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,0,59,8],[55,0,55,2],[14,0,14,8],[20,6,20,8],[31,0,31,8],[37,0,37,3],[37,6,37,8],[1,0,2,8],[23,0,23,3],[5,0,5,3],[23,6,23,8],[6,0,6,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[9,0,9,3],[10,0,10,3],[11,0,11,3],[3,0,3,1],[4,0,4,8],[5,6,5,8],[15,6,15,8],[26,0,26,3],[28,6,28,8],[27,0,27,3]]}
["beginning of sheet 4: Performance measures"]
["PET ASSISTANCE AND SUPPORT (PAS) PROGRAM\nPERFORMANCE MEASURES "]
[]
["HCD Contract Number:",null,{"$f":"Certification!B13","v":0}]
["Instructions: Please fill in outcomes from this reporting period and outcomes anticipated for the next reporting period for each category listed. Total numbers should be reported as whole numbers. Please provide as thorough a response as appropriate for narrative questions. "]
["Category",null,null,null,{"$f":"IF(Certification!G13=\"\",\"Total Number of Participants Served this reporting period\", _xlfn.CONCAT(\"Total Number of Participants Served from \",Certification!G13))","v":"Total Number of Participants Served from January 1, 2022 - June 30, 2022"},"Anticipated Number of Participants Served in next 6-month Reporting Period","Brief Description of Participant Outcome Objectives for the next 6 month reporting period (narrative response)"]
["NOFA E.5.a. General Outcomes "]
["Note: Totals should include all participants assisted within each category by the shelter during the reporting period, including those assisted by the PAS program."]
["Total Number of Participants assisted by the Shelter in General:"]
["Number of pets at shelter:"]
["Total Number of Shelter Beds available:"]
["Participant's Average Length of Stay (in days):"]
["Number of Exits to Permanent Housing:"]
["Number of Exits to homelessness:"]
["Instructions: Please report on the subpopulation of participants assisted by the shelter in the categories below. If information was not available or is unknown, please enter \"N/A\" in the corresponding field. Since a single Participant could fall into multiple subpopulations, the total number of participants listed below does not need to equal the total number of Participants served with program funds listed above. The following data is meant to help assist HCD in making data-based decisions on future program funding and awards."]
["Number of Minor Children (ages 0-17) assisted by the Shelter in General:"]
["Number of Transition-Aged Youth (ages 18-24) assisted by the Shelter in General:"]
["Number of Seniors (ages 65+) assisted by the Shelter in General:"]
["Number of Veterans assisted by the Shelter in General:"]
["Number of persons with a reported disability assisted by the Shelter in General:"]
["Number of persons identifying as LGBTQIA+ assisted by the Shelter in General:"]
["NOFA E.5.b. PAS-Specific Outcomes "]
["Note: Totals should include ONLY participants assisted within each category by the PAS program. Numbers may be a part of the totals listed above. "]
["Number of Participants assisted specifically by the PAS Program"]
["Total Number of PAS-assisted beds available this reporting period:"]
["Total number of PAS Participants that transitioned from shelter to permanent housing"]
["Total number of PAS Participants that transitioned from shelter to homelessness"]
["Total Number of common household pets assisted by the PAS program"]
["Total number of PAS-assisted Pets receiving Behavioral Support Training from Veterinary Services"]
["Total number of PAS-assisted Pets receiving Spay/Neuter Veterinary Services"]
["Total number of PAS-assisted Pets receiving Vaccination Veterinary Services"]
["Instructions: Please report on the subpopulation categories below of participants or pets specifically assisted by PAS-funded activities. If information was not available or is unknown, please enter \"N/A\" in the corresponding field. Since a single Participant could fall into multiple subpopulations, the total number of participants listed below does not need to equal the total number of Participants served with program funds listed above, and may overlap with the corresponding category above. The following data is meant to help assist HCD in making data-based decisions on future program funding and awards."]
["Number of Minor Children (ages 0-17) assisted by the PAS Program:"]
["Number of Transition-Aged Youth (ages 18-24) assisted by the PAS Program:"]
["Number of Seniors (ages 65+) assisted by the PAS Program:"]
["Number of Veterans assisted by the PAS Program:"]
["Number of persons with a reported disability assisted by the PAS Program:"]
["Number of persons identifying as LGBTQIA+ assisted by the PAS Program"]
["Total Number of PAS-assisted Pets that are Service or Emotional Support animals"]
["NOFA E.5.c and d. Increased Residential Stability and skills/income"]
["Please describe how both PAS participants and participants assisted by the shelter in general showed increased residential stability during this reporting period. This may include exits to permanent housing, rental application or deposit assistance, housing navigation services or other forms of assistance directly related to helping participants gain stable housing."]
["Please describe how both PAS participants and participants assisted by the shelter in general showed increased skills and/or income during this reporting period. This may include details about participants being given access to job-related training and/or education, part-time or full-time supported employment, access to mainstream service/income support programs for which they are eligible or other forms of assistance directly related to helping participants gain stable employment or income."]
["NOFA E.5.e and f. Other Measurable Outcomes"]
[null,null,null,null,"Description of Outcome",null,null,null,"Number of Tenants who achieved outcome this reporting period"]
["Please describe another measurable outcome determined from the tenant satisfaction survey or in your application relating to PAS-specific activities this reporting period that were not listed above."]
["Please describe another measurable outcome determined from the tenant satisfaction survey or in your application achieved this reporting period that were not listed above."]
["Participant Referrals"]
["Please provide details of participant referrals to your facility, which should include name of referring entity, their address, contact name and phone number and the numer of referrals per entity during the 6 month reporting period. "]
["Referring Entity",null,null,"Entity Address",null,"Contact Name","Phone Number","Email Address","Number of Referrals"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Additional details about participant referrals"]

{"sheet":"Rep Worksheet","index":5,"n_rows":54,"n_cols":27,"rows_kept":54,"cut":false,"hidden":true,"merged":[[4,0,4,12],[5,0,5,12],[29,17,29,18],[29,19,29,21],[26,11,26,16],[26,17,26,18],[26,19,26,21],[27,19,27,21],[28,11,28,16],[28,19,28,21],[13,16,13,17],[12,16,12,17],[12,18,12,19],[12,20,12,21],[15,14,15,15],[9,22,9,23],[7,18,7,19],[7,20,7,21],[7,22,7,23],[8,18,8,19],[8,20,8,21],[14,24,14,25],[13,18,13,19],[13,20,13,21],[13,22,13,23],[13,24,13,25],[11,24,11,25],[8,24,8,25],[9,24,9,25],[12,22,12,23],[14,22,14,23],[24,19,24,21],[21,17,21,18],[6,18,6,19],[6,20,6,21],[14,16,14,17],[14,18,14,19],[14,20,14,21],[15,16,15,17],[15,18,15,19],[15,20,15,21],[22,19,22,21],[19,19,19,21],[20,19,20,21],[21,19,21,21],[23,19,23,21],[15,22,15,23],[6,22,6,23],[7,16,7,17],[8,16,8,17],[10,16,10,17],[9,16,9,17],[9,18,9,19],[9,20,9,21],[6,0,7,2],[35,0,35,1],[36,0,36,1],[37,0,37,1],[39,0,39,1],[38,0,38,1],[35,4,35,5],[34,8,34,10],[37,11,38,16],[39,11,40,16],[35,11,35,16],[36,8,36,10],[37,8,37,10],[38,8,38,10],[39,8,39,10],[40,8,40,10],[35,8,35,10],[35,6,35,7],[36,11,36,26],[37,17,38,26],[39,17,40,26],[35,17,35,18],[34,11,34,16],[34,4,34,5],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[32,4,32,5],[17,4,17,5],[20,4,20,5],[21,4,21,5],[26,6,26,7],[27,6,27,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[34,6,34,7],[6,3,6,8],[7,3,7,8],[18,6,18,7],[20,6,20,7],[21,6,21,7],[22,8,22,10],[6,24,6,25],[7,24,7,25],[19,4,19,5],[17,19,17,21],[19,17,19,18],[17,11,17,16],[8,22,8,23],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[6,11,6,12],[7,11,7,12],[8,11,8,12],[9,11,9,12],[15,24,15,25],[12,24,12,25],[6,16,6,17],[14,3,14,5],[14,6,14,8],[15,3,15,5],[15,6,15,8],[10,0,13,2],[17,17,17,18],[12,14,12,15],[13,14,13,15],[14,14,14,15],[11,14,11,15],[10,9,10,12],[11,16,11,17],[10,18,10,19],[10,20,10,21],[10,22,10,23],[10,24,10,25],[11,18,11,19],[11,20,11,21],[11,22,11,23],[16,0,16,10],[22,0,22,1],[24,4,24,5],[23,4,23,5],[22,4,22,5],[25,4,25,5],[17,8,17,10],[19,8,19,10],[20,8,20,10],[21,8,21,10],[23,8,23,10],[24,8,24,10],[17,6,17,7],[18,0,18,1],[18,8,18,10],[8,0,9,2],[12,3,12,5],[12,6,12,8],[10,3,10,8],[11,3,11,8],[8,3,8,8],[9,3,9,8],[13,3,13,5],[13,6,13,8],[30,17,30,18],[22,11,22,16],[22,17,22,18],[22,6,22,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[23,17,23,18],[20,17,20,18],[27,11,27,16],[24,11,24,16],[24,17,24,18],[27,17,27,18],[28,17,28,18],[30,11,30,16],[26,4,26,5],[27,4,27,5],[28,4,28,5],[30,4,30,5],[29,4,29,5],[29,0,29,1],[17,0,17,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[18,4,18,5],[30,0,30,1],[32,6,32,7],[29,8,29,10],[19,11,19,16],[25,8,25,10],[26,8,26,10],[27,8,27,10],[28,8,28,10],[30,8,30,10],[29,11,29,16],[20,11,20,16],[21,11,21,16],[23,11,23,16],[32,11,32,16],[31,6,31,7],[31,11,31,16],[19,6,19,7],[32,8,32,10],[31,8,31,10],[45,19,46,20],[47,19,48,20],[49,19,50,20],[51,19,52,20],[43,13,44,18],[45,13,46,18],[47,13,48,18],[49,13,50,18],[51,13,52,18],[41,0,41,10],[40,2,40,3],[40,0,40,1],[39,2,39,3],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[36,6,36,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[42,0,42,2],[42,3,42,4],[42,6,42,7],[43,0,43,2],[43,3,43,4],[43,6,43,7],[43,9,43,10],[42,9,42,10],[44,0,44,2],[44,3,44,4],[44,6,44,7],[44,9,44,10],[45,9,45,10],[46,0,46,2],[46,3,46,4],[46,6,46,7],[46,9,46,10],[47,0,47,2],[47,3,47,4],[47,6,47,7],[47,9,47,10],[52,6,52,7],[52,9,52,10],[48,0,48,2],[48,3,48,4],[48,6,48,7],[48,9,48,10],[49,0,49,2],[49,3,49,4],[49,6,49,7],[49,9,49,10],[50,0,50,2],[50,3,50,4],[50,6,50,7],[50,9,50,10],[0,0,1,26],[2,0,2,26],[3,0,3,26],[4,13,4,26],[5,13,5,26],[16,11,16,26],[17,22,17,26],[18,11,18,26],[25,11,25,26],[19,22,19,26],[20,22,20,26],[21,22,21,26],[22,22,22,26],[23,22,23,26],[24,22,24,26],[11,9,11,12],[12,9,12,12],[13,9,13,12],[14,9,14,12],[6,14,6,15],[7,14,7,15],[9,14,9,15],[8,14,8,15],[10,14,10,15],[26,22,26,26],[27,22,27,26],[28,22,28,26],[29,22,29,26],[30,22,30,26],[31,22,31,26],[32,22,32,26],[33,22,33,26],[42,11,42,12],[42,18,42,20],[42,13,42,17],[32,19,32,21],[33,19,33,21],[34,19,34,21],[35,19,35,21],[34,22,34,26],[35,22,35,26],[33,11,33,16],[33,17,33,18],[34,17,34,18],[32,17,32,18],[31,17,31,18],[30,19,30,21],[31,19,31,21],[53,0,53,10],[53,11,53,26],[41,11,41,26],[42,21,42,26],[43,21,44,26],[45,21,46,26],[47,21,48,26],[49,21,50,26],[51,21,52,26],[43,11,44,12],[45,11,46,12],[47,11,48,12],[49,11,50,12],[51,11,52,12],[43,19,44,20],[51,0,51,2],[51,3,51,4],[51,6,51,7],[51,9,51,10],[45,0,45,2],[45,3,45,4],[45,6,45,7],[52,0,52,2],[52,3,52,4]]}
["Pet Assistance and Support (PAS)"]
[]
["Review Worksheet"]
[]
["Section 1",null,null,null,null,null,null,null,null,null,null,null,null,"Section 2"]
["General Information ",null,null,null,null,null,null,null,null,null,null,null,null,"Funding Overview\nFill in the green cells with corresponding report years' operating budget information."]
["Rep Information",null,null,"Reviewing Rep Name",null,null,null,null,null,"Review Start Date",null,"Review End Date",null,null,"Jul-Dec 2020",null,"Jan-Jun 2021",null,"Year 1 Total",null,"Jul-Dec 2021",null,"Jan-Jun 2022",null,"Year 2 Total",null,"Cumulative Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PAS Revenue\n(Amount Expended+Interest Earned)",null,null,null,null,{"$f":"SUM(O8:R8)","v":0},null,null,null,null,null,{"$f":"SUM(U8:X8)","v":0},null,{"$f":"SUM(O8:R8,U8:X8)","v":0}]
["Manager Information",null,null,"Reviewing Manager Name",null,null,null,null,null,"Review Start Date",null,"Manager Approval Date",null,"PAS Expenses",null,null,null,null,{"$f":"SUM(O9:R9)","v":0},null,null,null,null,null,{"$f":"SUM(U9:X9)","v":0},null,{"$f":"SUM(O9:R9,U9:X9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PAS NOI",{"$f":"O8-O9","v":0},null,{"$f":"Q8-Q9","v":0},null,{"$f":"S8-S9","v":0},null,{"$f":"U8-U9","v":0},null,{"$f":"W8-W9","v":0},null,0,null,0]
["General Applicant Information",null,null,"Grantee/Contractor Name",null,null,null,null,null,"Contract #",null,null,null,"Other Revenue",null,null,null,null,{"$f":"SUM(O11:R11)","v":0},null,null,null,null,null,0,null,0]
[null,null,null,{"$f":"Certification!G14","v":0},null,null,null,null,null,{"$f":"Certification!B13","v":0},null,null,null,"Other Expenses",null,null,null,null,0,null,null,null,null,null,0,null,0]
[null,null,null,"PAS Project Name",null,null,"PAS Project Address",null,null,"Total PAS Award",null,null,null,"Other NOI",{"$f":"O11-O12","v":0},null,{"$f":"Q11-Q12","v":0},null,{"$f":"S11-S12","v":0},null,{"$f":"U11-U12","v":0},null,{"$f":"W11-W12","v":0},null,{"$f":"Y11-Y12","v":0},null,0]
[null,null,null,{"$f":"Certification!B14","v":0},null,null,{"$f":"Certification!B15","v":0},null,null,{"$f":"Certification!B17","v":0},null,null,null,"Total Revenue",{"$f":"O8+O11","v":0},null,{"$f":"Q8+Q11","v":0},null,0,null,{"$f":"U8+U11","v":0},null,{"$f":"W8+W11","v":0},null,0,null,0]
[null,null,null,"Contractor Name",null,null,"Preparer Name",null,null,"Preparer Contact Information",null,null,null,"Total Expenses",{"$f":"O9+O12","v":0},null,{"$f":"Q9+Q12","v":0},null,0,null,{"$f":"U9+U12","v":0},null,{"$f":"W9+W12","v":0},null,0,null,0]
[null,null,null,{"$f":"Certification!G14","v":0},null,null,{"$f":"Certification!G16","v":0},null,null,"Email:",{"$f":"Certification!G17","v":0},"Phone: ",{"$f":"Certification!B16","v":0},"Total NOI",{"$f":"O14-O15","v":0},null,{"$f":"Q14-Q15","v":0},null,{"$f":"S14-S15","v":0},null,{"$f":"U14-U15","v":0},null,{"$f":"W14-W15","v":0},null,0,null,{"$f":"SUM(O16:R16,U16:X16)","v":0}]
["Section 3\nFinancial Summary",null,null,null,null,null,null,null,null,null,null,"Section 4\nProgram Outcomes"]
["Actual Expenses",null,"PAS Expenditures","Other Expenditures","Revenue Sources",null,"Amount for Reporting Period",null,"Comments",null,null,"Category",null,null,null,null,null,"Numerical Outcomes",null,"Anticipated Numerical Outcome \n(Next Reporting Period)",null,null,"Comments"]
["Administration",null,{"$f":"'Operating Budget'!F30","v":0},{"$f":"'Operating Budget'!G30","v":0},"PAS Funding Expended",null,{"$f":"'Operating Budget'!F14","v":0},null,null,null,null,"General Shelter Assistance"]
["Staff",null,{"$f":"'Operating Budget'!F31","v":0},{"$f":"'Operating Budget'!G31","v":0},"PAS Interest Earned",null,{"$f":"'Operating Budget'!F15","v":0},null,null,null,null,"Number of Participants assisted by the Shelter in General during reporting period:",null,null,null,null,null,{"$f":"'Performance Measures'!E9","v":0},null,{"$f":"'Performance Measures'!F9","v":0}]
["Accounting & Legal",null,{"$f":"'Operating Budget'!F32","v":0},{"$f":"'Operating Budget'!G32","v":0},"Private Donations ",null,{"$f":"'Operating Budget'!G16","v":0},null,null,null,null,"Approximate number of pets at shelter during reporting period:",null,null,null,null,null,{"$f":"'Performance Measures'!E10","v":0},null,{"$f":"'Performance Measures'!F10","v":0}]
["Rent/Lease",null,{"$f":"'Operating Budget'!F33","v":0},{"$f":"'Operating Budget'!G33","v":0},"Local Government:",null,{"$f":"'Operating Budget'!G17","v":0},null,null,null,null,"Total Number of Shelter Beds available during reporting period:",null,null,null,null,null,{"$f":"'Performance Measures'!E11","v":0},null,{"$f":"'Performance Measures'!F11","v":0}]
["Operating and Maintenance ",null,{"$f":"'Operating Budget'!F34","v":0},{"$f":"'Operating Budget'!G34","v":0},"State  ",null,{"$f":"'Operating Budget'!G18","v":0},null,null,null,null,"Participant's Average Length of Stay (in days):",null,null,null,null,null,{"$f":"'Performance Measures'!E12","v":0},null,{"$f":"'Performance Measures'!F12","v":0}]
["Debt Service (Principal & Interest)",null,{"$f":"'Operating Budget'!F35","v":0},{"$f":"'Operating Budget'!G35","v":0},"FEMA",null,{"$f":"'Operating Budget'!G19","v":0},null,null,null,null,"Number of Exits to Permanent Housing during reporting period:",null,null,null,null,null,{"$f":"'Performance Measures'!E13","v":0},null,{"$f":"'Performance Measures'!F13","v":0}]
["Taxes",null,{"$f":"'Operating Budget'!F36","v":0},{"$f":"'Operating Budget'!G36","v":0},"Federal (VOCA funding)",null,{"$f":"'Operating Budget'!G20","v":0},null,null,null,null,"Number of Exits to homelessness during reporting period:",null,null,null,null,null,{"$f":"'Performance Measures'!E14","v":0},null,{"$f":"'Performance Measures'!F14","v":0}]
["Utilities",null,{"$f":"'Operating Budget'!F37","v":0},{"$f":"'Operating Budget'!G37","v":0},"Rental Income",null,{"$f":"'Operating Budget'!G21","v":0},null,null,null,null,"PAS-Specific Assistance"]
["Insurance",null,{"$f":"'Operating Budget'!F38","v":0},{"$f":"'Operating Budget'!G38","v":0},"Fees",null,{"$f":"'Operating Budget'!G22","v":0},null,null,null,null,"Assisted by the PAS Program: Number of Participants assisted specifically by the PAS Program during reporting period:",null,null,null,null,null,{"$f":"'Performance Measures'!E24","v":0},null,{"$f":"'Performance Measures'!F24","v":0}]
["Food-Residents",null,{"$f":"'Operating Budget'!F39","v":0},{"$f":"'Operating Budget'!G39","v":0},"Fundraising",null,{"$f":"'Operating Budget'!G23","v":0},null,null,null,null,"Total Number of PAS-assisted beds available during reporting period:",null,null,null,null,null,{"$f":"'Performance Measures'!E25","v":0},null,{"$f":"'Performance Measures'!F25","v":0}]
["Crates and Kennels (PAS)",null,{"$f":"'Operating Budget'!F40","v":0},{"$f":"'Operating Budget'!G40","v":0},{"$f":"'Operating Budget'!B24","v":"Other (enter here)"},null,{"$f":"'Operating Budget'!G24","v":0},null,null,null,null,"Pets Assisted by the PAS Program: Total Number of common household pets assisted by the PAS program",null,null,null,null,null,{"$f":"'Performance Measures'!E28","v":0},null,{"$f":"'Performance Measures'!F28","v":0}]
["Food-Animals (PAS)",null,{"$f":"'Operating Budget'!F41","v":0},{"$f":"'Operating Budget'!G41","v":0},{"$f":"'Operating Budget'!B25","v":"Other (enter here)"},null,{"$f":"'Operating Budget'!G25","v":0},null,null,null,null,"Of Pets Assisted, total number receiving Behavioral Support Training from Veterinary Services",null,null,null,null,null,{"$f":"'Performance Measures'!E29","v":0},null,{"$f":"'Performance Measures'!F29","v":0}]
["Veterinarian Services (PAS)",null,{"$f":"'Operating Budget'!F42","v":0},{"$f":"'Operating Budget'!G42","v":0},{"$f":"'Operating Budget'!B26","v":"Other (enter here)"},null,{"$f":"'Operating Budget'!G26","v":0},null,null,null,null,"Of Pets Assisted, total number receiving Spay/Neuter Veterinary Services",null,null,null,null,null,{"$f":"'Performance Measures'!E30","v":0},null,{"$f":"'Performance Measures'!F30","v":0}]
["Staff (For Assisting Pets -PAS)",null,{"$f":"'Operating Budget'!F43","v":0},{"$f":"'Operating Budget'!G43","v":0},"Total Revenue",null,{"$f":"SUM(G19:H31)","v":0},null,null,null,null,"Of Pets Assisted, total number receiving Vaccination Veterinary Services",null,null,null,null,null,{"$f":"'Performance Measures'!E31","v":0},null,{"$f":"'Performance Measures'!F31","v":0}]
["Independent Audit (PAS)",null,{"$f":"'Operating Budget'!F44","v":0},{"$f":"'Operating Budget'!G44","v":0},"Net Operating Income:",null,{"$f":"G32-C40","v":0},null,null,null,null,"Residential Stability: PAS Participants that moved to permanent housing",null,null,null,null,null,{"$f":"'Performance Measures'!E26","v":0},null,{"$f":"'Performance Measures'!F26","v":0}]
["Liability Insurance (PAS)",null,{"$f":"'Operating Budget'!F45","v":0},{"$f":"'Operating Budget'!G45","v":0},null,null,null,null,null,null,null,"PAS Participants that exited to homelessness",null,null,null,null,null,{"$f":"'Performance Measures'!E27","v":0},null,{"$f":"'Performance Measures'!F27","v":0}]
[{"$f":"'Operating Budget'!B46","v":"Other (enter here)"},null,{"$f":"'Operating Budget'!F46","v":0},{"$f":"'Operating Budget'!G46","v":0},"Eligible Activity",null,"Average Cost to PAS Per Participant Bed by Activity ",null,"Additional Comments on how PAS funds were expended",null,null,{"$f":"'Performance Measures'!E45","v":0},null,null,null,null,null,{"$f":"'Performance Measures'!I45","v":0}]
[{"$f":"'Operating Budget'!B47","v":"Other (enter here)"},null,{"$f":"'Operating Budget'!F47","v":0},{"$f":"'Operating Budget'!G47","v":0},"Crates and Kennels",null,{"$f":"C29/$R$28","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"'Performance Measures'!E46","v":0},null,null,null,null,null,{"$f":"'Performance Measures'!I46","v":0}]
[{"$f":"'Operating Budget'!B48","v":"Other (enter here)"},null,{"$f":"'Operating Budget'!F48","v":0},{"$f":"'Operating Budget'!G48","v":0},"Animal Food",0,{"$f":"C30/$R$28","v":{"$error":"#DIV/0!"}},null,null,null,null,"To see numbers of sub-populations assisted by Shelter in General and PAS-Specific Activities, please refer to the Performance Measures Tab."]
[{"$f":"'Operating Budget'!B49","v":"Other (enter here)"},null,{"$f":"'Operating Budget'!F49","v":0},{"$f":"'Operating Budget'!G49","v":0},"Veterinarian Services",null,{"$error":"#DIV/0!"},null,null,null,null,"Please Describe how both PAS participants and participants assisted by the shelter in general showed increased residential stability during this reporting period. This may include exits to permanent housing, rental application or deposit assistance, housing navigation services or other forms of assistance directly related to helping participants gain stable housing.",null,null,null,null,null,{"$f":"'Performance Measures'!E41","v":0}]
["Total Expenses",null,{"$f":"SUM(C19:C38)","v":0},{"$f":"SUM(D18:D38)","v":0},"Staff for PAS",0,{"$error":"#DIV/0!"}]
["Total Expenses (Combined)",null,{"$f":"C39+D39","v":0},null,"PAS Independent Audit",null,{"$error":"#DIV/0!"},null,null,null,null,"Please describe how both PAS participants and participants assisted by the shelter in general showed increased skills and/or income during this reporting period. This may include details about participants being given access to job-related training and/or education, part-time or full-time supported employment, access to mainstream service/income support programs for which they are eligible or other forms of assistance directly related to helping participants gain stable employment or income.",null,null,null,null,null,{"$f":"'Performance Measures'!E42","v":0}]
["PAS NOI",null,{"$f":"G19+G20-C39","v":0},null,"PAS Liability Insurance",0,{"$error":"#DIV/0!"}]
["Section 5\nParticipant Referrals",null,null,null,null,null,null,null,null,null,null,"Section 6\nTenant Surveys"]
["Referring Entity",null,null,"Entity Address",null,"Contact Name","Phone Number",null,"Email Address","Number of Referrals",null,"Did the Grantee Submit copies of their tenant satisfaction surveys?",null,{"$f":"'Tenant Survey and Evaluation'!H14","v":"Select One"},null,null,null,null,"Did the Grantee Submit copies of their tenant exit surveys?",null,null,{"$f":"'Tenant Survey and Evaluation'!H20","v":"Select One"}]
[{"$f":"'Performance Measures'!A50","v":0},null,null,{"$f":"'Performance Measures'!D50","v":0},null,{"$f":"'Performance Measures'!F50","v":0},{"$f":"'Performance Measures'!G50","v":0},null,{"$f":"'Performance Measures'!H50","v":0},{"$f":"'Performance Measures'!I50","v":0},null,"Types of questions the Grantee's asked in their survey, including the PAS or pet-specific questions.",null,{"$f":"'Tenant Survey and Evaluation'!B7","v":0},null,null,null,null,null,"HCD Rep Comments"]
[{"$f":"'Performance Measures'!A51","v":0},null,null,{"$f":"'Performance Measures'!D51","v":0},null,{"$f":"'Performance Measures'!F51","v":0},{"$f":"'Performance Measures'!G51","v":0},null,{"$f":"'Performance Measures'!H51","v":0},{"$f":"'Performance Measures'!I51","v":0}]
[{"$f":"'Performance Measures'!A52","v":0},null,null,{"$f":"'Performance Measures'!D52","v":0},null,{"$f":"'Performance Measures'!F52","v":0},{"$f":"'Performance Measures'!G52","v":0},null,{"$f":"'Performance Measures'!H52","v":0},{"$f":"'Performance Measures'!I52","v":0},null,"How were the survey questions reviewed?",null,{"$f":"'Tenant Survey and Evaluation'!B9","v":0},null,null,null,null,null,"HCD Rep Comments"]
[{"$f":"'Performance Measures'!A53","v":0},null,null,{"$f":"'Performance Measures'!D53","v":0},null,{"$f":"'Performance Measures'!F53","v":0},{"$f":"'Performance Measures'!G53","v":0},null,{"$f":"'Performance Measures'!H53","v":0},{"$f":"'Performance Measures'!I53","v":0}]
[{"$f":"'Performance Measures'!A54","v":0},null,null,{"$f":"'Performance Measures'!D54","v":0},null,{"$f":"'Performance Measures'!F54","v":0},{"$f":"'Performance Measures'!G54","v":0},null,{"$f":"'Performance Measures'!H54","v":0},{"$f":"'Performance Measures'!I54","v":0},null,"What does the Grantee do with the results?",null,{"$f":"'Tenant Survey and Evaluation'!B11","v":0},null,null,null,null,null,"HCD Rep Comments"]
[{"$f":"'Performance Measures'!A55","v":0},null,null,{"$f":"'Performance Measures'!D55","v":0},null,{"$f":"'Performance Measures'!F55","v":0},{"$f":"'Performance Measures'!G55","v":0},null,{"$f":"'Performance Measures'!H55","v":0},{"$f":"'Performance Measures'!I55","v":0}]
[{"$f":"'Performance Measures'!A56","v":0},null,null,{"$f":"'Performance Measures'!D56","v":0},null,{"$f":"'Performance Measures'!F56","v":0},{"$f":"'Performance Measures'!G56","v":0},null,{"$f":"'Performance Measures'!H56","v":0},{"$f":"'Performance Measures'!I56","v":0},null,"How often is the survey conducted?",null,{"$f":"'Tenant Survey and Evaluation'!B13","v":0},null,null,null,null,null,"HCD Rep Comments"]
[{"$f":"'Performance Measures'!A57","v":0},null,null,{"$f":"'Performance Measures'!D57","v":0},null,{"$f":"'Performance Measures'!F57","v":0},{"$f":"'Performance Measures'!G57","v":0},null,{"$f":"'Performance Measures'!H57","v":0},{"$f":"'Performance Measures'!I57","v":0}]
[{"$f":"'Performance Measures'!A58","v":0},null,null,{"$f":"'Performance Measures'!D58","v":0},null,{"$f":"'Performance Measures'!F58","v":0},{"$f":"'Performance Measures'!G58","v":0},null,{"$f":"'Performance Measures'!H58","v":0},{"$f":"'Performance Measures'!I58","v":0},null,"Reasons Given for Tenants Exiting the Shelter",null,{"$f":"'Tenant Survey and Evaluation'!B19","v":0},null,null,null,null,null,"HCD Rep Comments"]
[{"$f":"'Performance Measures'!A59","v":0},null,null,{"$f":"'Performance Measures'!D59","v":0},null,{"$f":"'Performance Measures'!F59","v":0},{"$f":"'Performance Measures'!G59","v":0},null,{"$f":"'Performance Measures'!H59","v":0},{"$f":"'Performance Measures'!I59","v":0}]
["Additional Comments: "]

{"sheet":"Data Sheet","index":6,"n_rows":2,"n_cols":139,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["HCD Contract Number","HCD Reviewing Rep","HCD Reviewing Manager","Project Name","Contractor Name","Project Address","County","Preparer Name","Preparer Email","Reporting Period","Authorized Rep","PAS Grant Funding","Shelter in Operation?","Date of Operation","Grant Funds in Interest Bearing Account? ","PAS Expended","PAS Funds Interest","Total Pas Rev","$ Rev Private Donations","$ Rev Local Govt","$ Rev State","$ Rev FEMA","$ Rev Federal","$ Rev Rental Income","$ Rev Fees","$ Rev Fundraising","$ Rev Other","$ Other Rev Total","$ Shelter Rev Total","$ PAS Exp Crates and Kennels","$ PAS Exp Food-Pets","$ PAS Exp Veterinarian Services","$ PAS Exp Staff (Pet Asst)","$ PAS Exp Audit","$ PAS Exp Liability Insurance","$ PAS Exp Other","Total PAS Expenditures","PAS NOI","$ Exp Admin","$ Exp Staff (client service)","$ Exp Accounting and Legal","$ Exp Rent/Lease","$ Exp Maintenance","$ Exp Debt Service","$ Exp Taxes","$ Exp Utilites","$ Exp Insurance","$ Exp Food-Residents","$ Exp Crates and Kennels","$ Exp Food-Pets","$ Exp Vet Services","$ Exp Staff (Pet Asst)","$ Exp Audit","$ Exp Liability Insurance","$ Exp Other","Total Non-PAS Expenses","Total Shelter Expenses","PAS NOI","Other NOI","Total Shelter NOI","# Gen Participants Assisted","6 mos # Gen Assist by Shelter ","# Gen Pets at Shelter","6 mos # Gen Pets at Shelter","# Shelter Beds Avail.","6 mos # Shelter Beds","Av. Length of Stay","6 mos Av. Length of Stay","# Gen Exits to Perm Housing","6 mos # Gen Exits to Perm Housing","Gen Exits to Homelessness","6 mos # Gen Exits to Homelessness","# Gen Minor Children Asst.","6 mos # Gen Minor Children Asst.","# Gen TAY Asst.","6 mos # Gen TAY Asst.","# Gen Seniors Asst.","6 mos # Gen Seniors Asst.","# Gen Vets Asst.","6 mos # Gen Vets Asst.","# Gen Disabled Asst.","6 mos # Gen Disabled Asst.","# Gen LGBTQ Asst.","6 mos # Gen LGBTQ Asst.","# PAS Participants Assisted","6 mos # PAS Participants Assisted","# PAS Beds Avail.","6 mos # PAS Beds Avail.","# PAS Participants Moved to Perm Housing","6 mos # PAS Participants Moved to Perm Housing","# PAS Exits to Homelessness","6 mos # PAS Exits to Homelessness","# PAS Pets Assisted","# PAS Pets Assisted","# Pets Receiving Behavioral Support","6 mos # Pets Receiving Behavioral Support","# Pets Receiving Spay/Neuter Services","6 mos # Pets Receiving Spay/Neuter Services","# Pets Receiving Vaccination","6 mos # Pets Receiving Vaccination","# PAS Minor Children Asst.","6 mos # PAS Minor Children Asst.","# PAS TAY Asst.","6 mos # PAS TAY Asst.","# PAS Seniors Asst.","6 mos # PAS Seniors Asst.","# PAS Vets Asst.","6 mos # PAS Vets Asst.","# PAS Disabled Asst.","6 mos # PAS Disabled Asst.","# PAS LGBTQIA Asst.","6 mos # PAS LGBTQIA Asst.","#PAS Service Animals Asst.","6 mos #PAS Service Animals Asst.","Narrative:Residential Stability","Narrative: Skills/Income","Other Outcome 1","# Assisted by Outcome 1","Other Outcome 2","# Assisted by Outcome 2","# of Referring Entitites","# of Referrals Made","Cost per PAS Participant Assisted:","Cost per PAS bed: crates and kennels","Cost per PAS bed: Animal Food","Cost per PAS bed: Vet Services","Cost per PAS bed: PAS Staff","Cost per PAS bed: PAS Audit","Cost per PAS bed: Liability Insurance","Survey Questions","Survey Review","Survey Results","Survey Frequency","Exit Survey Questions","Exit Survey Reasons","Evaluation Plan","Evaluation Tracking and Analysis","Who is Analyzing","Evaluation Outcomes"]
[{"$f":"Certification!$B$13","v":0},{"$f":"'Rep Worksheet'!D8","v":0},{"$f":"'Rep Worksheet'!D10","v":0},{"$f":"Certification!B14","v":0},{"$f":"Certification!G14","v":0},{"$f":"Certification!B15","v":0},{"$f":"Certification!G15","v":0},{"$f":"Certification!G16","v":0},{"$f":"Certification!G17","v":0},{"$f":"Certification!G13","v":"January 1, 2022 - June 30, 2022"},{"$f":"Certification!A22","v":0},{"$f":"Certification!B17","v":0},{"$f":"'Operating Budget'!G9","v":"Please Select"},{"$f":"'Operating Budget'!G10","v":0},{"$f":"'Operating Budget'!G11","v":"Please Select"},{"$f":"'Operating Budget'!F14","v":0},{"$f":"'Operating Budget'!F15","v":0},{"$f":"'Operating Budget'!F27","v":0},{"$f":"'Operating Budget'!F16","v":0},{"$f":"'Operating Budget'!F17","v":0},{"$f":"'Operating Budget'!F18","v":0},{"$f":"'Operating Budget'!F19","v":0},{"$f":"'Operating Budget'!F20","v":0},{"$f":"'Operating Budget'!F21","v":0},{"$f":"'Operating Budget'!F22","v":0},{"$f":"'Operating Budget'!F23","v":0},{"$f":"SUM('Operating Budget'!F24:F26)","v":0},{"$f":"'Operating Budget'!G27","v":0},{"$f":"AB2+R2","v":0},{"$f":"'Operating Budget'!F40","v":0},{"$f":"'Operating Budget'!F41","v":0},{"$f":"'Operating Budget'!F42","v":0},{"$f":"'Operating Budget'!F43","v":0},{"$f":"'Operating Budget'!F44","v":0},{"$f":"'Operating Budget'!F45","v":0},{"$f":"SUM('Operating Budget'!F46:F49)","v":0},{"$f":"'Operating Budget'!F50","v":0},{"$f":"'Operating Budget'!F51","v":0},{"$f":"'Operating Budget'!$G30","v":0},{"$f":"'Operating Budget'!$G31","v":0},{"$f":"'Operating Budget'!$G32","v":0},{"$f":"'Operating Budget'!$G33","v":0},{"$f":"'Operating Budget'!$G34","v":0},{"$f":"'Operating Budget'!$G35","v":0},{"$f":"'Operating Budget'!$G36","v":0},{"$f":"'Operating Budget'!$G37","v":0},{"$f":"'Operating Budget'!$G38","v":0},{"$f":"'Operating Budget'!$G39","v":0},{"$f":"'Operating Budget'!$G40","v":0},{"$f":"'Operating Budget'!$G41","v":0},{"$f":"'Operating Budget'!$G42","v":0},{"$f":"'Operating Budget'!$G43","v":0},{"$f":"'Operating Budget'!$G44","v":0},{"$f":"'Operating Budget'!$G45","v":0},{"$f":"SUM('Operating Budget'!G46:G49)","v":0},{"$f":"'Operating Budget'!G50","v":0},{"$f":"'Operating Budget'!F50+'Operating Budget'!G50","v":0},{"$f":"'Operating Budget'!F51","v":0},{"$f":"'Operating Budget'!G52","v":0},{"$f":"'Operating Budget'!F53","v":0},{"$f":"'Performance Measures'!E9","v":0},{"$f":"'Performance Measures'!F9","v":0},{"$f":"'Performance Measures'!E10","v":0},{"$f":"'Performance Measures'!F10","v":0},{"$f":"'Performance Measures'!E11","v":0},{"$f":"'Performance Measures'!F11","v":0},{"$f":"'Performance Measures'!E12","v":0},{"$f":"'Performance Measures'!F12","v":0},{"$f":"'Performance Measures'!E13","v":0},{"$f":"'Performance Measures'!F13","v":0},{"$f":"'Performance Measures'!E14","v":0},{"$f":"'Performance Measures'!F14","v":0},{"$f":"'Performance Measures'!E16","v":0},{"$f":"'Performance Measures'!F16","v":0},{"$f":"'Performance Measures'!E17","v":0},{"$f":"'Performance Measures'!F17","v":0},{"$f":"'Performance Measures'!E18","v":0},{"$f":"'Performance Measures'!F18","v":0},{"$f":"'Performance Measures'!E19","v":0},{"$f":"'Performance Measures'!F19","v":0},{"$f":"'Performance Measures'!E20","v":0},{"$f":"'Performance Measures'!F20","v":0},{"$f":"'Performance Measures'!E21","v":0},{"$f":"'Performance Measures'!F21","v":0},{"$f":"'Performance Measures'!E24","v":0},{"$f":"'Performance Measures'!F24","v":0},{"$f":"'Performance Measures'!E25","v":0},{"$f":"'Performance Measures'!F25","v":0},{"$f":"'Performance Measures'!E26","v":0},{"$f":"'Performance Measures'!F26","v":0},{"$f":"'Performance Measures'!E27","v":0},{"$f":"'Performance Measures'!F27","v":0},{"$f":"'Performance Measures'!E28","v":0},{"$f":"'Performance Measures'!F28","v":0},{"$f":"'Performance Measures'!E29","v":0},{"$f":"'Performance Measures'!F29","v":0},{"$f":"'Performance Measures'!E30","v":0},{"$f":"'Performance Measures'!F30","v":0},{"$f":"'Performance Measures'!E31","v":0},{"$f":"'Performance Measures'!F31","v":0},{"$f":"'Performance Measures'!E33","v":0},{"$f":"'Performance Measures'!F33","v":0},{"$f":"'Performance Measures'!E34","v":0},{"$f":"'Performance Measures'!F34","v":0},{"$f":"'Performance Measures'!E35","v":0},{"$f":"'Performance Measures'!F35","v":0},{"$f":"'Performance Measures'!E36","v":0},{"$f":"'Performance Measures'!F36","v":0},{"$f":"'Performance Measures'!E37","v":0},{"$f":"'Performance Measures'!F37","v":0},{"$f":"'Performance Measures'!E38","v":0},{"$f":"'Performance Measures'!F38","v":0},{"$f":"'Performance Measures'!E39","v":0},{"$f":"'Performance Measures'!F39","v":0},{"$f":"'Performance Measures'!E41","v":0},{"$f":"'Performance Measures'!E42","v":0},{"$f":"'Performance Measures'!E45","v":0},{"$f":"'Performance Measures'!F45","v":0},{"$f":"'Performance Measures'!E46","v":0},{"$f":"'Performance Measures'!F46","v":0},{"$f":"COUNTA('Performance Measures'!A50:C59)","v":0},{"$f":"SUM('Performance Measures'!I50:I59)","v":0},{"$f":"'Rep Worksheet'!J14/'Rep Worksheet'!R27","v":{"$error":"#DIV/0!"}},{"$f":"'Rep Worksheet'!G36","v":{"$error":"#DIV/0!"}},{"$f":"'Rep Worksheet'!G37","v":{"$error":"#DIV/0!"}},{"$f":"'Rep Worksheet'!G38","v":{"$error":"#DIV/0!"}},{"$f":"'Rep Worksheet'!G39","v":{"$error":"#DIV/0!"}},{"$f":"'Rep Worksheet'!G40","v":{"$error":"#DIV/0!"}},{"$f":"'Rep Worksheet'!G41","v":{"$error":"#DIV/0!"}},{"$f":"'Tenant Survey and Evaluation'!B7","v":0},{"$f":"'Tenant Survey and Evaluation'!B9","v":0},{"$f":"'Tenant Survey and Evaluation'!B11","v":0},{"$f":"'Tenant Survey and Evaluation'!B13","v":0},{"$f":"'Tenant Survey and Evaluation'!B17","v":0},{"$f":"'Tenant Survey and Evaluation'!B19","v":0},{"$f":"'Tenant Survey and Evaluation'!B23","v":0},{"$f":"'Tenant Survey and Evaluation'!B25","v":0},{"$f":"'Tenant Survey and Evaluation'!B27","v":0},{"$f":"'Tenant Survey and Evaluation'!B29","v":0}]

{"sheet":"Lists","index":7,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Select Activity"]
[null,"Crates and Kennels"]
[null,"Animal Food"]
[null,"Staff for PAS"]
[null,"Veterinarian Services"]
[null,"PAS Liability Insurance"]
[null,"PAS Independent Audit"]
[]
[]
[]
[]
[null,"Select Reporting Period"]
[null,"July 1, 2020 to December 31, 2020"]
[null,"January 1, 2021 to June 30, 2021"]
[null,"July 1, 2021 to December 31, 2021"]
[null,"January 1, 2022 to June 30, 2022"]