{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["HMIS Project-Grant Form","Agency - Program","HMIS Adminstration","Definitions","notes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"HMIS Project-Grant Form","index":0,"n_rows":87,"n_cols":4,"rows_kept":87,"cut":false,"hidden":false,"merged":[[28,19,28,20],[49,19,49,20],[53,5,54,5],[33,7,33,9],[33,10,33,13],[39,8,39,9],[60,8,62,15],[19,1,19,2],[34,8,34,9],[34,10,39,13],[35,8,35,9],[37,8,37,9],[38,8,38,9],[32,1,32,2]]}
[null,"KC METRO HMIS Project / Grant Request Form"]
[null,"Instructions:  Fill out one form per project. (For grant consolidation please reach out to HMIS Administration.)"]
[null,"Many cells have drop-down menus with selection options, click on down triangle to view/select option."]
[]
[null,"1.  Agency Info"]
[null,null,"Org Name"]
[null,null,"Contact Name"]
[null,null,"Contact email"]
[null,null,"Contact phone"]
[]
[null,null,"CoC"]
[null,null,"State"]
[]
[null,"2. Request Type Info"]
[null,null,"Request Type"]
[]
[null,null,"HMIS Program Name"]
[null,null,"HMIS Program ID"]
[]
[null,"Brief Descritption\n  of Request"]
[]
[null,"3. Date Required In HMIS"]
[]
[null,"4. Project Summary"]
[null,null,"Project Type"]
[null,null,"Target Population"]
[null,null,"Operating Start Date"]
[null,null,"Operating End Date"]
[null,null,"Family or Individual"]
[null,null,"Is Project Included in  PIT?"]
[]
[null,"Residential Programs Info"]
[null,"Bed Use"]
[null,null,"Target Population (A)"]
[null,null,"# of Beds-Households with Children"]
[null,null,"# of Units-Households with Children"]
[]
[null,null,"# of Beds-Households w/out Children"]
[null,null,"# of Beds HH w/ only Children"]
[null,null,"# of Chronic Homeless Beds"]
[]
[null,null,"# of HMIS Beds: HH w/ Children"]
[null,null,"HMIS Beds HH w/o Children"]
[null,null,"HMIS Beds HH w/ only Children"]
[]
[null,null,"Geo Code"]
[null,null,"Site Type"]
[null,null,"Bed Type"]
[null,null,"HIC Program Name\n"]
[]
[null,"5. Funding Source"]
[null,null,"Funding Type"]
[null,null,"Grant ID"]
[null,null,"Grant Start Date"]
[null,null,"Grant End Date"]
[null,null,"Program Grant Name"]
[]
[null,"5. Provider (location; program address) (for SO use zipcode)"]
[null,null,"Location Name"]
[null,null,"Address"]
[null,null,"City"]
[null,null,"State"]
[null,null,"Zip"]
[]
[null,"6. Services assigned to this"]
[null,"program"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7. Reporting Needs","Identify all reports needs for this program: APR, CAPER, SSVF, RHY, other. "]
[null,null,null," For \"other\" please describe"]
[]
[]
[]
[]
[]
[]
[null,"8.  Any additional information \nyou would like to share about this program?"]

{"sheet":"Agency - Program","index":1,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":true,"merged":[[2,18,2,19],[3,18,3,19],[4,18,4,19],[14,7,14,8],[0,3,0,4],[0,8,0,9],[0,5,0,6],[0,10,0,11],[0,12,0,14],[10,1,10,5],[10,6,10,8],[10,9,10,12],[6,4,7,4],[18,7,20,14],[22,7,23,14],[11,9,15,12],[15,1,15,5],[15,7,15,8],[18,1,28,5],[17,1,17,5],[11,1,11,5],[14,1,14,5],[13,1,13,5],[11,7,11,8],[12,7,12,8],[13,7,13,8],[12,1,12,5]]}
[null,"Date Required",null,"Primary contact email",null,null,null,"Phone",null,null,"Name of existing program to model this one after"]
[null,"Instructions:  Fill out the tan fields for the HMIS new program setup.   For fields you are not sure of just leave blank. Note:  light grayed entry is example data."]
[null,"Year","CoC","State","Prog. Type","Organization Name","HMIS Program Name\nuse the format:  aaa - bb ccc\nwhere aaa = agency code\nbb - program type code\nccc - descr identifier of prog.","Target \nPopulation","Operating Start Date","Operating End Date","Family or Individual","Auto Exit Days","Reopen Days","Allow Post Exit  Assessments\nY or N","Funding Source","Grant ID","Grant Start Date","Grant End Date","Program Grant Name\n(from GIW)"]
[null,2018,"MO-604","KS","ES","Community Service League","CSL - ES MHDC ESG 2018","Not Applicable","2018-01-01","Open","Both Individual or Family",-1,30,null,"HUD"]
[]
[]
[null,null,null,null,"Complete this section if the project is a RESIDENTIAL Project Type\n(ie., ES, RRH, PH, TH, SH. . . ) ","Who Can Occupy these Beds?","Target Pop. A","Beds HH w/ Children","Units HH w/ Children","Beds HH w/o Children","Beds HH w/ only Children","CH Beds","Year-Round Beds","HMIS Beds HH w/ Children","HMIS Beds HH w/o Children","HMIS Beds HH w/ only Children","Geo Code","Inventory Type","Bed Type","Program Name\n(from HIC)"]
[null,null,null,null,null,"Homeless Only (street, ES, car, abondoned building)","SMF",0,0,5,0,5,{"$f":"SUM(H8+J8+K8)","v":5},0,5,0,90726,"New","Voucher"]
[]
[]
[null,"Providers this program should be tied to \nAll is acceptable response; else list individually",null,null,null,null,"Services assigned to this project\nRefer = refer to model after program",null,null,"Identify Reporting needs"]
[null,null,null,null,null,null,null,null,null,"APR, CAPER, SSVF,RHY,Other   Identify reports needed for this program."]
[null,"change this to be (Provider (client location)"]
[]
[]
[]
[]
[null,"Share any additional information about this program:"]
[null,null,null,null,null,null,null,"The Definitions for drop down categories are on the next tab.  For bed and unit counts, please input the number of beds and units outlined in your contract.  For HMIS beds, please input the number of those beds that will be tracked in HMIS."]
[]
[]
[]
[null,null,null,null,null,null,null,"If you are unsure of a response leave it blank. "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KCMETRO Use","Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Org Set Up"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provider Set Up"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Set Up"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Set Up"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project ID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ticket #"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PIT ID #"]

{"sheet":"HMIS Adminstration","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"KCMETRO Use"]
[null,"Org Set Up"]
[null,"Provider Set Up"]
[null,"Project Set Up"]
[null,"Assessments"]
[null,"Services Setup"]
[null,"User Set Up"]
[null,"Project ID"]
[null,"Ticket #"]
[null,"PIT ID #"]
[null,"Need to be added to HIC Translation table?"]
["For New Projects setup:"]
["HMIS Project id"]
["Program added to HIC translation table","date forward this request to Sherry"]

{"sheet":"Definitions","index":3,"n_rows":66,"n_cols":19,"rows_kept":66,"cut":false,"hidden":false,"merged":[[17,11,17,12],[21,1,21,2],[1,11,1,12],[1,8,1,9],[1,5,1,6],[1,1,1,2],[9,8,9,9]]}
[]
[null,"Prog. Type",null,null,null,"Inventory Type",null,null,"Bed Type",null,null,"Target Pop. A",null,null,null,"AHAR/PIT"]
[null,"ES","Emergency Shelter ",null,"ES :  Emergency Shelter ","C","Current ",null,"F","Facility","F  - Facility","None","None",null,{"$f":"CONCATENATE(\"     \",M3)","v":"     None"},"Yes "]
[null,"TH","Transitional Housing",null,"TH :  Transitional Housing","N","New ",null,"V","Voucher","V - Voucher","SM","Single Male (18+)",null,{"$f":"CONCATENATE(L4,\":  \",M4)","v":"SM:  Single Male (18+)"},"No "]
[null,"PSH-D","PSH  (Disability Required for Entry)",null,"PSH-D :  PSH  (Disability Required for Entry)","U","Under Development",null,"O","Other","O - Other","SF","Single Female (18+)",null,{"$f":"CONCATENATE(L5,\":  \",M5)","v":"SF:  Single Female (18+)"},"DK"]
[null,"PH  ","Housing Only (No Services)",null,"PH   :  Housing Only (No Services)",null,null,null,null,null,null,"SMF","Single Male or Female (18+)",null,{"$f":"CONCATENATE(L6,\":  \",M6)","v":"SMF:  Single Male or Female (18+)"}]
[null,"*PH","Housing with Services (no disability required)",null,"*PH :  Housing with Services (no disability required)",null,null,null,null,null,null,"CO","Couples Only, No Children",null,{"$f":"CONCATENATE(L7,\":  \",M7)","v":"CO:  Couples Only, No Children"}]
[null,"SH","Safe Haven",null,"SH :  Safe Haven",null,null,null,null,null,null,"HC","Households with Children",null,"HC:  Households with Children","HOPWA"]
[null,"CA","Coordinated Assessment",null,"CA :  Coordinated Assessment",null,null,null,null,null,null,"SMHC","SM and Households with Children ",null,"SMHC:  SM and Households with Children ","Master Leasing "]
[null,"PATH","PATH ",null,"PATH :  PATH ","Site Type",null,null,"Funding Source",null,null,"SFHC","SF and Households with Children",null,"SFHC:  SF and Households with Children","Permanent Housing Facilities"]
[null,"RRH","Rapid Re-Housing",null,"RRH :  Rapid Re-Housing","Multi site",null,null,"HUD",null,null,"SMF+HC","SM, SF and Households with Children",null,"SMF+HC:  SM, SF and Households with Children","Permanent Housing Facilities - Federal Fund"]
[null,"RHY ","Runaway Homeless Youth",null,"RHY  :  Runaway Homeless Youth","Single site, multi buildings",null,null,"MHDC",null,null,"YM","Unaccompanied Young Males Under 18",null,"YM:  Unaccompanied Young Males Under 18","Permanent Housing Placement Services"]
[null,"HP","Homeless Prevention",null,"HP :  Homeless Prevention","single site, single building",null,null,"UGovt Jo Co",null,null,"YF","Unaccompanied Young Females Under 18",null,"YF:  Unaccompanied Young Females Under 18","Receiving NO HOPWA housing Assistance"]
[null,"TH & RRH","Joint TH & PH-RRH",null,"TH & RRH :  Joint TH & PH-RRH",null,null,null,"RHY/HHS",null,null,"YMF","Unaccompanied Male and Female Under 18",null,"YMF:  Unaccompanied Male and Female Under 18","Short-Term Rent, Mortgage and Utility Assistance"]
[null,"SO","Street Outreach",null,"SO :  Street Outreach","Housing Type",null,null,"ESG",null,null,null,null,null,null,"Supportive Services Only"]
[null,"SSO","Supportive Services Only",null,"SSO :  Supportive Services Only","Dorm/Hotel/Motel",null,null,"KCMO ESG",null,null,null,null,null,null,"Tenant Based Rental Assistance"]
[null,"Non-HUD","Not a HUD HMIS Project",null,"Non-HUD :  Not a HUD HMIS Project","Shelter/Barracks",null,null,"Private",null,null,null,null,null,null,"Transitional/Short-Term Housing Faci-Federal Fund"]
[null,"DS","Day Shelter",null,"DS :  Day Shelter","NA",null,null,"Mo Dept of Corrections",null,null,"Target Pop. B",null,null,null,"Transitional/Short-Term Housing Facilities"]
[null,null,null,null,null,"Shared Housing",null,null,"Municipal",null,null,"Domestic Violence"]
[null,null,null,null,null,"Single Room Occupancy",null,null,"DMHAS",null,null,"HIV",null,"Family or Individual"]
[null,null,null,null,null,"Single Apartment",null,null,"SAMSHA",null,null,"Not Applicable",null,"Family"]
[null,"CoC Code",null,null,null,"Single Home/Townhouse/dulex",null,null,"VA",null,null,null,null,"Individual"]
[null,"KS-505","Johnson County",null,null,null,null,null,null,null,null,null,null,"Both Individual or Family"]
[null,"MO-604","KC Regional",null,null,null,null,null,"Funding Source",null,null,"Bed Use"]
[null,null,null,null,null,null,null,null,"HUD",null,null,"Homeless Only (street, ES, car, abondoned building)",null,null,null,null,null,null,"Federal Partner Funding Programs and Component"]
[null,"State",null,null,null,"Housing Status Exception",null,null,"DMHAS",null,null,"Not Required to be Homeless",null,null,null,null,null,null,"HHS:PATH – Street Outreach & Supportive Services Only"]
[null,"KS","Kansas",null,null,"Is Project Included in PIT",null,null,"DOH",null,null,null,null,null,null,null,null,null,"HUD:HOPWA – Permanent Housing (facility based or TBRA)"]
[null,"MO","Missouri",null,null,"Yes",null,null,"ESG",null,null,null,null,null,null,null,null,null,"VA:Grant Per Diem – Clinical Treatment"]
[null,null,null,null,null,"No",null,null,"MHTF",null,null,null,null,null,null,null,null,null,"HHS:RHY – Transitional Living Program"]
[null,null,null,null,null,null,null,null,"MoHIP",null,null,null,null,null,null,null,null,null,"VA: Compensated Work Therapy Transitional Residence"]
[null,null,null,null,null,null,null,null,"Municipal",null,null,null,null,null,null,null,null,null,"HUD:Rural Housing Stability Assistance Program"]
[null,null,null,null,null,null,null,null,"Private",null,null,null,null,null,null,null,null,null,"HUD:HOPWA – Short-Term Supportive Facility"]
[null,"Setup New Project in HMIS",null,"Setup New Project in HMIS",null,null,null,null,"RHY/HHS",null,null,null,null,null,null,null,null,null,"HUD: CoC - Rapid Re-Housing"]
[null,"Update Existing Project in HMIS with new Grant info",null,"Update Existing Project in HMIS with new Grant info",null,null,null,null,"SAMSHA",null,null,null,null,null,null,null,null,null,"VA:Grant Per Diem – Service Intensive Transitional Housing"]
[null,null,null,null,null,null,null,null,"VA",null,null,null,null,null,null,null,null,null,"HUD:HOPWA – Transitional Housing (facility based or TBRA)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD: Pay for Success"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA: CRS Contract Residential Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA: Supportive Services for Veteran Families"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:HOPWA – Hotel/Motel Vouchers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:CoC – Safe Haven"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA:Grant Per Diem – Low Demand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA: Community Contract Safe Haven Program"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:HOPWA – Permanent Housing Placement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:ESG – Homelessness Prevention"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HHS:RHY – Street Outreach Project"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:CoC – Homelessness Prevention (High Performing Comm. Only)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA:Grant Per Diem – Hospital to Housing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:ESG – Street Outreach"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:CoC – Supportive Services Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA:Grant Per Diem – Transition in Place"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HHS:RHY – Basic Center Program (prevention and shelter)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-HUD Funder"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD: Public and Indian Housing (PIH) Programs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:ESG – Rapid Rehousing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:HOPWA – Housing Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:CoC – Single Room Occupancy (SRO)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HHS:RHY – Maternity Group Home for Pregnant and Parenting Youth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA:Grant Per Diem – Bridge Housing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA: Domiciliary Care"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:CoC - Youth Homeless Demonstration Program (YHDP)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:HOPWA – Short-Term Rent, Mortgage, Utility assistance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:ESG – Emergency Shelter (operating and/or essential services)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:CoC – Permanent Supportive Housing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HHS:RHY – Demonstration Project"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:HUD/VASH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD:CoC – Transitional Housing"]

{"sheet":"notes","index":4,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["2019-10-29","Added question about \"Is this project included in the PIT count?\"    This is for the Housing Status Exception field in the program setup."]
[]
["2019-07-08","Completely changed the layout of the form and also incorporated Excel Workbook code for fields relating to request type and project type.  To see code right click on tab"]
[]
["2019-06-19","Updated to include GIW project name,  HIC project name, added Joing TH-RRH project"]
[]
[]
["2018-09-16","modified to utlize cell lockout and reformat"]
[]
["2018-08-03","Tool provided by Jim Bombaci from Nutmeg"]
[null,"Used to capture key info needed to setup new projects in CaseWorthy"]
[]
[]
[]
[]
[]
[null,"Private Sub Worksheet_Change(ByVal Target As Range)"]
[null,"ActiveSheet.Activate"]
[]
[null,"'Toggle message off/on about model off existing project, depending on Project Type selection"]
[null,"   If Range(\"D15\") = \"Setup New Project in HMIS\" Then"]
[null,"        Range(\"D16\").Value = \"To model new project off of existing project please provide:\""]
[null,"    Else"]
[null,"        Range(\"D16\").ClearContents"]
[null,"    End If"]
[]
[null,"End Sub"]