{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Onsite Information","Offsite Permanent","HCD USE ONLY","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Onsite Information","index":0,"n_rows":84,"n_cols":8,"rows_kept":84,"cut":false,"hidden":false,"merged":[[82,0,82,4],[83,0,83,4],[84,0,84,4],[82,5,82,7],[83,5,83,7],[84,5,84,7],[5,0,5,7],[49,0,49,1],[49,2,49,3],[49,4,49,5],[81,0,81,4],[81,5,81,7],[37,0,37,5],[38,0,38,5],[39,0,39,5],[37,6,37,7],[38,6,38,7],[39,6,39,7],[18,0,18,7],[19,0,19,7],[34,0,34,5],[35,0,35,5],[0,0,0,7],[1,0,1,7],[2,4,2,5],[3,4,3,5],[4,0,4,7],[2,1,2,2],[3,1,3,2],[36,0,36,5],[34,6,34,7],[35,6,35,7],[36,6,36,7],[32,0,32,7],[33,0,33,7],[45,6,45,7],[46,6,46,7],[40,0,40,7],[41,0,41,5],[42,0,42,5],[43,0,43,5],[44,0,44,5],[45,0,45,5],[46,0,46,5],[41,6,41,7],[42,6,42,7],[43,6,43,7],[44,6,44,7],[47,0,47,7],[48,0,48,7],[49,6,49,7],[50,6,50,7],[51,6,51,7],[52,6,52,7],[53,6,53,7],[54,6,54,7],[55,6,55,7],[76,0,76,7],[64,4,64,5],[65,4,65,5],[66,1,66,2],[70,0,70,7],[71,0,71,7],[72,0,72,7],[73,0,73,7],[59,4,59,5],[60,4,60,5],[61,4,61,5],[62,4,62,5],[63,4,63,5],[57,0,57,7],[58,0,58,7],[67,0,67,7],[68,0,68,7],[69,0,69,7],[79,0,79,7],[80,0,80,7],[74,0,74,7],[75,0,75,7],[77,0,77,7],[78,0,78,7]]}
["Homekey Interim to Permanent Conversion Notice Form"]
["The purpose of this form is to notify the Department of the Grantee's intent to convert their interim Homekey project to permanent housing. Please fill out this form and submit it to the Department prior to beginning construction or rehabilitation. Forms should be submitted to your assigned Grant Management Representative for the respective funding Round and Contract Number."]
["HCD Contract Number:",null,null,"Grantee Name:",null,null,"Project Name"]
["Preparer Name, Title:",null,null,"Preparer Email",null,null,"Preparer Phone Number"]
["1.  Current Unit Mix"]
["Please fill out the following unit mix table with information regarding the current interim project site per the Standard Agreement, including tenants currently housed."]
["Unit Size","Number of Interim Units Created","Area Median Income (AMI)","Approx. Square Footage of each Unit ","Number of Units Currently Occupied","Individuals Currently Housed in Units ","Minimum Individuals to be Housed in Units\nPer the 2017 UMR Regulations","Maximum Individuals to be Housed"]
["Select One",null,null,null,null,null,{"$f":"1*B8","v":0},{"$f":"2*B8","v":0}]
["Select One",null,null,null,null,null,{"$f":"1*B9","v":0},{"$f":"2*B9","v":0}]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Manager/Staff Units",null,null,null,null,null,"N/A","N/A"]
["Communal/Service Spaces (cumulative sq ft)"]
["Total:",{"$f":"SUM(B8:B16)","v":0},{"$f":"IFERROR((((B8*C8)+(B9*C9)+(B10*C10)+(B11*C11)+(B12*C12)+(B13*C13)+(B14*C14)+(B15*C15))/(SUM(B8:B15))),0)","v":0},{"$f":"SUM((B8*D8),(B9*D9),(B10*D10),(B11*D11),(B12*D12),(B13*D13),(B14*D14),(B15*D15),(D16*B16),D17)","v":0},{"$f":"SUM(E8:E16)","v":0},{"$f":"SUM(F8:F16)","v":0},{"$f":"SUM(G8:G15)","v":0},{"$f":"SUM(H8:H15)","v":0}]
["2. New Onsite Unit Mix Proposal"]
["Please fill out the following unit mix table for the planned permanent project site. If this proposal changes at any time, you will be required to submit a new Conversion Notice form to the Department for review and consideration.\nNote: Planned project must be projected to serve a number of people higher than or equal to the existing occupancy or must provide the same or higher square footage in the site. Projected number of people served is based on the average of the minimum and maximum capacity of planned units."]
["Unit Size","Number of Planned Permanent Units","Area Median Income (AMI)","Approx. Planned Square Footage of each Unit",null,null,"Minimum Individuals to be Housed in Units\nPer the 2017 UMR Regulations","Maximum Individuals to be Housed"]
["Select One",null,null,null,null,null,{"$f":"1*B22","v":0},{"$f":"2*B22","v":0}]
["Select One",null,null,null,null,null,{"$f":"1*B23","v":0},{"$f":"2*B23","v":0}]
["Select One",null,null,null,null,null,{"$f":"2*B24","v":0},{"$f":"4*B24","v":0}]
["Select One",null,null,null,null,null,{"$f":"4*B25","v":0},{"$f":"6*B25","v":0}]
["Select One",null,null,null,null,null,{"$f":"6*B26","v":0},{"$f":"8*B26","v":0}]
["Select One",null,null,null,null,null,{"$f":"6*B27","v":0},{"$f":"8*B27","v":0}]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Manager/Staff Units",null,null,null,null,null,"N/A","N/A"]
["Communal/Service Spaces (cumulative sq ft)"]
["Total:",{"$f":"SUM(B22:B30)","v":0},{"$f":"IFERROR((((B22*C22)+(B23*C23)+(B24*C24)+(B25*C25)+(B26*C26)+(B27*C27)+(B28*C28)+(B29*C29))/(SUM(B22:B29))),0)","v":0},{"$f":"SUM((B22*D22),(B23*D23),(B24*D24),(B25*D25),(B26*D26),(B27*D27),(B28*D28),(B29*B29),(B30*D30),D31)","v":0},null,null,{"$f":"SUM(G22:G29)","v":0},{"$f":"SUM(H22:H29)","v":0}]
["3.  Project Details and Requirements"]
["3a. Construction Timeline"]
["Will Perm Conversion Involve Loan Closing/Close of Escrow? ",null,null,null,null,null,"Select One"]
["If Yes above, Anticipated Date of Loan Closing/Close of Escrow\nPlease note that the 55-year Homekey Use Restriction will need to be recorded at this time in first lien priority "]
["Start Date of Construction:\nPlease keep your Grant Management Representative apprised of changes to your construction timeline after submitting this form"]
["Construction Completion Date"]
["Date Project will reach Full Occupancy\nProjects are required to reach full occupancy within 90 days of Construction Completion",null,null,null,null,null,{"$f":"IF(G38=\"\",\"\",G38+90)","v":""}]
["Date Interim to Perm Conversion Completion Form Due\nProjects are required to submit the form and proof of completion (TCO, rent roll) within 90 days of Construction Completion",null,null,null,null,null,{"$f":"IF(G38=\"\",\"\",G38+90)","v":""}]
["3b. Use Restriction"]
["Deadline for submission of Draft 55-year Use Restriction\nPlease review MGM's Use Restriction Requirements prior to submitting Covenant or Regulatory Agreement.\nDraft is due 90 days before anticipated Construction Completion or anticipated Date of Loan Closing, whichever is applicable",null,null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(G35=\"Select One\",\"\",AND(G35=\"Yes\",G36>DATE(2020,1,1)),G36-90,AND(G35=\"No\",G38>DATE(2020,1,1)),G38-90),\"Please enter a date in Cell G30 or G32\")","v":""}]
["Deadline for Recordation\nGrantees must record the HCD-approved 55-year Perm. Use Restriction within 24 hours of receiving approval from the Department and within 3 months of conversion completion",null,null,null,null,null,{"$f":"IFERROR(IF(G38=\"\",\"\",G42+90),\"Please make a selection in Cell G29\")","v":""}]
["Deadline for Title Report Updated Post-Recordation\nGrantees must provide an updated title report within 14 days of recording the Perm. Use Restriction",null,null,null,null,null,{"$f":"IFERROR(IF(G43=\"\",\"\",G43+14),\"Please make a selection in Cell G29\")","v":""}]
["Lien Priority \nHomekey must remain senior to any newly contemplated loans, including, but not limited to, new construction financing. Under no circumstances will the Department relinquish enforceability of the SA or its lien priority.  Your Grant Management Representative will need 60 days to review the 55-year use restriction and all funding commitments identified under Funding Sources",null,null,null,null,null,"Select One"]
["Will Site Control be Transferred to a New Owner/Operator? \nIf Yes, a Standard Agreement amendment will be required. Special Purpose entities are considered new organizations, even if managed by existing Grantees.",null,null,null,null,null,"Select One"]
["If yes, please name the entity(ies) to be added to the Standard Agreement. \nIf forming a new Special Purpose Entity, please include the full name and the name of the Managing Partner, if applicable.\nNote: Original Grantee(s) will remain liable to the Department for compliance with and the performance of all Program requirements regardless of any Department-approved transfer or assignment of interest."]
["4. Offsite Housing Information"]
["If doing an occupied rehabilitation, please answer the first question in this section, then you may skip the table below and proceed to the next section.\nIf permanently housing tenants offsite using Homekey funds, please notify your Grant Management Representative."]
["Will this be an occupied rehab (tenants residing on site during construction)?",null,"Select One",null,"Has offsite interim housing been secured for the duration of construction?",null,"Select One"]
["Site Location","Number of Interim Units or Beds Available for Homekey tenants","Number of Individuals staying in offsite interim housing","How long is planned tenancy at offsite housing? (in months)","What is the maximum length of time (in months) offsite housing will accommodate Homekey tenants? If no limit, input \"N/A\"","Will Services be provided to tenants at off-site location(s)?","Additional Comments"]
[]
[]
[]
[]
[]
["Total:",{"$f":"SUM(B52:B56)","v":0},{"$f":"SUM(C52:C56)","v":0}]
["5. Funding Commitments"]
["Please list non-Homekey funding sources that will be used to accomplish conversion of the project and sustain ongoing operations. For any new sources since initial application, please attach proof of commitments.\nAlso, please note, if there have been changes to the funding sources since the time of application submission, the Grantee will be required to submit a Budget Details Adjustment Request for HCD's review and approval."]
["Funding Source","Source Type","Amount","Status","Planned Use",null,"Proof of Commitment Attached","Notes"]
[null,"Select One",null,"Select One","Select One",null,"Select One"]
[null,"Select One",null,"Select One","Select One",null,"Select One"]
[null,"Select One",null,"Select One","Select One",null,"Select One"]
[null,"Select One",null,"Select One","Select One",null,"Select One"]
[null,"Select One",null,"Select One","Select One",null,"Select One"]
[null,"Select One",null,"Select One","Select One",null,"Select One"]
["Total:",{"$f":"SUM(C61:C66)","v":0}]
["6. Narrative Questions"]
["1. Please describe the changes that will be made to units during the rehabilitation (e.g. installation of kitchenettes, ADA upgrades, combining of units, etc.)"]
[]
["2. Please provide details on the proposed timeline for the conversion of this project from Interim to Permanent as summarized in Row 21. Include contractor selection process plan and anticipated date that full occupancy will be reached after construction is finished."]
[]
["3. If applicable, please describe plans to relocate and house existing tenants at the location(s) listed in the Offsite Housing Information table above during the interim to permanent transition. Include the type of offsite interim housing selected and services that will be available. Refer to the Homekey Conversion and Relocation FAQ located at https://homekey.hcd.ca.gov/monitoring-forms-and-disbursement "]
[]
["4. Please describe the proposed changes in number of units between the current interim and proposed permanent unit mixes, as applicable. If the proposed total number of permanent units AND total overall capacity is lower than that of the current interim units, please provide justification for the reduction."]
[]
["5. If tenants are being displaced by a reduction in units during the transition, please describe how Grantee will ensure that displaced tenants will be relocated into permanent housing units."]
[]
["7. Certification"]
["Homekey must remain senior to any newly contemplated loans, including, but not limited to, new construction financing. Under no circumstances will the Department relinquish enforceability of the SA or its lien priority nor the ability of the Department to recapture grant funds.  Your Grant Management Representative will need 60 days to review the 55-year use restriction and all funding commitments identified under Funding Sources. \nBy signing this request, I acknowledge that I have read and understand this policy."]
["***By signing this request, I certify to the best of my knowledge and belief that the information presented in this form 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)\n\nBy signing this request, I acknowledge that outcomes of the decisions made during conversion of this project and any public inquiries regarding construction, tenant relocation and other uses of Homekey award funds are my responsibility as the authorized representative of the Homekey program Grantee. The certification of this form does not reflect the Department's endorsement of my proposed plan for conversion to permanent housing, and it is incumbent upon me to exercise best practices and review recommended guidance to ensure the best possible outcomes for beneficiaries of Homekey funds and the awarded jurisdiction."]
["    Name and Title of Grantee Representative",null,null,null,null,"     Date"]
[]
["    Name of HCD Manager",null,null,null,null,"     Date"]

{"sheet":"Offsite Permanent","index":1,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":true,"merged":[[56,0,56,7],[57,0,57,7],[58,0,58,7],[59,0,59,7],[60,0,60,7],[0,0,0,7],[17,1,17,4],[17,6,17,7],[30,1,30,4],[30,6,30,7],[43,1,43,4],[43,6,43,7],[1,0,1,7],[2,0,2,7],[3,1,3,3],[3,4,3,7],[4,1,4,4],[4,6,4,7]]}
["Homekey Interim to Permanent Conversion Notice - Offsite Permanent Housing"]
["1. Scattered Site Housing Mix"]
["This sheet is only for permanent housing units created offsite from the Homekey project site. \nPlease fill out the following table with information units for Homekey tenants being permanently housed offsite."]
["Number of Alternative Sites","Select Number of Sites"]
["Address of Alternative Site",null,null,null,null,"APN"]
["Unit Size","Number of Permanent Units","Area Median Income (AMI)","Approx. Square Footage of each Unit","Number of Units Currently Occupied","Individuals Currently Housed","Minimum Individuals to be Housed in Units\nPer the 2017 UMR Regulations","Maximum Individuals to be Housed"]
["Select One",null,null,null,null,null,{"$f":"1*B7","v":0},{"$f":"2*B7","v":0}]
["Select One",null,null,null,null,null,{"$f":"1*B8","v":0},{"$f":"2*B8","v":0}]
["Select One",null,null,null,null,null,{"$f":"2*B9","v":0},{"$f":"4*B9","v":0}]
["Select One",null,null,null,null,null,{"$f":"4*B10","v":0},{"$f":"6*B10","v":0}]
["Select One",null,null,null,null,null,{"$f":"6*B11","v":0},{"$f":"8*B11","v":0}]
["Select One",null,null,null,null,null,{"$f":"6*B12","v":0},{"$f":"8*B12","v":0}]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Manager/Staff Units",null,null,null,null,null,"N/A","N/A"]
["Communal/Service Spaces"]
["Total:",{"$f":"SUM(B7:B16)","v":0},{"$f":"IFERROR((((B7*C7)+(B8*C8)+(B9*C9)+(B10*C10)+(B11*C11)+(B12*C12)+(B13*C13)+(B14*C14))/(SUM(B7:B14))),0)","v":0},{"$f":"SUM((B7*D7),(B8*D8),(B9*D9),(B10*D10),(B11*D11),(B12*D12),(B13*D13),(B14*D14),(B15*D15),D16)","v":0},{"$f":"SUM(E7:E15)","v":0},{"$f":"SUM(F7:F15)","v":0},0,0]
["Address of Alternative Site 2",null,null,null,null,"APN 2"]
["Unit Size","Number of Permanent Units","Area Median Income (AMI)","Approx. Square Footage of each Unit","Number of Units Currently Occupied","Individuals Currently Housed","Minimum Individuals to be Housed in Units\nPer the 2017 UMR Regulations","Maximum Individuals to be Housed"]
["Select One",null,null,null,null,null,{"$f":"1*B20","v":0},{"$f":"2*B20","v":0}]
["Select One",null,null,null,null,null,{"$f":"1*B21","v":0},{"$f":"2*B21","v":0}]
["Select One",null,null,null,null,null,{"$f":"2*B22","v":0},{"$f":"4*B22","v":0}]
["Select One",null,null,null,null,null,{"$f":"4*B23","v":0},{"$f":"6*B23","v":0}]
["Select One",null,null,null,null,null,{"$f":"4*B24","v":0},{"$f":"6*B24","v":0}]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Manager/Staff Units",null,null,null,null,null,"N/A","N/A"]
["Communal/Service Spaces"]
["Total:",{"$f":"SUM(B20:B29)","v":0},{"$f":"IFERROR((((B20*C20)+(B21*C21)+(B22*C22)+(B23*C23)+(B24*C24)+(B25*C25)+(B26*C26)+(B27*C27))/(SUM(B20:B27))),0)","v":0},{"$f":"SUM((B20*D20),(B21*D21),(B22*D22),(B23*D23),(B24*D24),(B25*D25),(B26*D26),(B27*D27),(B28*D28),D29)","v":0},{"$f":"SUM(E20:E28)","v":0},{"$f":"SUM(F20:F28)","v":0},{"$f":"SUM(G20:G28)","v":0},{"$f":"SUM(H20:H28)","v":0}]
["Address of Alternative Site 3",null,null,null,null,"APN 3"]
["Unit Size","Number of Permanent Units","Area Median Income (AMI)","Approx. Square Footage of each Unit","Number of Units Currently Occupied","Individuals Currently Housed","Minimum Individuals to be Housed in Units\nPer the 2017 UMR Regulations","Maximum Individuals to be Housed"]
["Select One",null,null,null,null,null,{"$f":"1*B33","v":0},{"$f":"2*B33","v":0}]
["Select One",null,null,null,null,null,{"$f":"1*B34","v":0},{"$f":"2*B34","v":0}]
["Select One",null,null,null,null,null,{"$f":"1*B35","v":0},{"$f":"2*B35","v":0}]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,{"$f":"2*B38","v":0},{"$f":"4*B38","v":0}]
["Select One",null,null,null,null,null,{"$f":"4*B39","v":0},{"$f":"6*B39","v":0}]
["Select One",null,null,null,null,null,{"$f":"6*B40","v":0},{"$f":"8*B40","v":0}]
["Manager/Staff Units",null,null,null,null,null,"N/A","N/A"]
["Communal/Service Spaces"]
["Total:",{"$f":"SUM(B33:B42)","v":0},{"$f":"IFERROR((((B33*C33)+(B34*C34)+(B35*C35)+(B36*C36)+(B37*C37)+(B38*C38)+(B39*C39)+(B40*C40))/(SUM(B33:B40))),0)","v":0},{"$f":"SUM((B33*D33),(B34*D34),(B35*D35),(B36*D36),(B37*D37),(B38*D38),(B39*D39),(B40*D40),(B41*D41),D42)","v":0},{"$f":"SUM(E33:E41)","v":0},{"$f":"SUM(F33:F41)","v":0},0,0]
["Address of Alternative Site 4",null,null,null,null,"APN 4"]
["Unit Size","Number of Permanent Units","Area Median Income (AMI)","Approx. Square Footage of each Unit","Number of Units Currently Occupied","Individuals Currently Housed","Minimum Individuals to be Housed in Units\nPer the 2017 UMR Regulations","Maximum Individuals to be Housed"]
["Select One",null,null,null,null,null,{"$f":"1*B46","v":0},{"$f":"2*B46","v":0}]
["Select One",null,null,null,null,null,{"$f":"1*B47","v":0},{"$f":"2*B47","v":0}]
["Select One",null,null,null,null,null,{"$f":"2*B48","v":0},{"$f":"4*B48","v":0}]
["Select One",null,null,null,null,null,{"$f":"2*B49","v":0},{"$f":"4*B49","v":0}]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,0,0]
["Select One",null,null,null,null,null,{"$f":"4*B52","v":0},{"$f":"6*B52","v":0}]
["Select One",null,null,null,null,null,{"$f":"6*B53","v":0},{"$f":"8*B53","v":0}]
["Manager/Staff Units",null,null,null,null,null,"N/A","N/A"]
["Communal/Service Spaces"]
["Total:",{"$f":"SUM(B46:B55)","v":0},{"$f":"IFERROR((((B46*C46)+(B47*C47)+(B48*C48)+(B49*C49)+(B50*C50)+(B51*C51)+(B52*C52)+(B53*C53))/(SUM(B46:B53))),0)","v":0},{"$f":"SUM((B46*D46),(B47*D47),(B48*D48),(B49*D49),(B50*D50),(B51*D51),(B52*D52),(B53*D53),(B54*D54),D55)","v":0},{"$f":"SUM(E46:E54)","v":0},{"$f":"SUM(F46:F54)","v":0},0,0]
["2. Narrative Questions"]
["Please provide an explanation as to why you are requesting that Homekey tenants be permanently housed offsite."]
[]
["Please provide a detailed explanation of the proposed plan for the original site that was acquired with Homekey award funds."]

{"sheet":"HCD USE ONLY","index":2,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":true,"merged":[[11,0,11,1],[11,2,11,3],[11,4,11,5],[0,0,0,5],[1,0,1,5],[4,0,4,1],[4,2,4,3],[4,4,4,5],[12,4,13,4],[12,5,13,5],[14,4,15,4],[14,5,15,5],[16,2,16,3],[16,4,16,5],[26,0,26,2],[26,4,26,5],[17,0,17,1],[17,4,20,5],[18,0,18,1],[19,0,19,1],[20,0,20,1],[22,0,22,5],[23,0,23,5],[24,0,24,2],[24,4,24,5],[25,0,25,2],[25,4,25,5],[27,0,27,2],[27,4,27,5],[28,0,28,2],[28,4,28,5],[29,0,29,2],[29,4,29,5],[30,0,30,2],[30,4,30,5],[31,0,31,2],[31,4,31,5],[32,0,32,2],[32,4,32,5],[36,0,36,2],[36,4,36,5],[33,0,33,2],[33,4,33,5],[34,0,34,2],[34,4,34,5],[35,0,35,2],[35,4,35,5]]}
["Homekey Interim to Permanent Conversion Notice Form"]
["Worksheet (HCD USE ONLY)"]
["Homekey Contract Number",{"$f":"IF('Onsite Information'!$B$3=\"\",\"\",'Onsite Information'!$B$3)","v":""},"Grantee Name",{"$f":"IF('Onsite Information'!E3=\"\",\"\",'Onsite Information'!E3)","v":""},"Project Name",{"$f":"IF('Onsite Information'!H3=\"\",\"\",'Onsite Information'!H3)","v":""}]
["Preparer Name and Title",{"$f":"IF('Onsite Information'!B4=\"\",\"\",'Onsite Information'!B4)","v":""},"Preparer Email",{"$f":"IF('Onsite Information'!E4=\"\",\"\",'Onsite Information'!E4)","v":""},"Preparer Phone Number",{"$f":"IF('Onsite Information'!H4=\"\",\"\",'Onsite Information'!H4)","v":""}]
["Current Unit Mix Totals",null,"New Onsite Unit Mix Proposal Totals",null,"New Offsite Unit Mix Proposal Totals"]
["Number of Interim Units Created:",{"$f":"'Onsite Information'!$B$18","v":0},"Planned Number of Perm Units:",{"$f":"'Onsite Information'!B32","v":0},"Planned Number of Perm Units:",{"$f":"'Offsite Permanent'!B17+'Offsite Permanent'!B30+'Offsite Permanent'!B43+'Offsite Permanent'!B56","v":0}]
["Average Area Median Income (AMI)",{"$f":"'Onsite Information'!C18","v":0},"Average Area Median Income (AMI)",{"$f":"'Onsite Information'!C32","v":0},"Average Area Median Income (AMI)",{"$f":"IFERROR((('Offsite Permanent'!C43*'Offsite Permanent'!B43)+('Offsite Permanent'!B56*'Offsite Permanent'!D56)+('Offsite Permanent'!B30*'Offsite Permanent'!D30)+('Offsite Permanent'!B17*'Offsite Permanent'!C17)/('Offsite Permanent'!B17+'Offsite Permanent'!B30+'Offsite Permanent'!B43+'Offsite Permanent'!B56)),0)","v":0}]
[" Total Square Footage:",{"$f":"'Onsite Information'!$D$18","v":0},"Total Planned Square Footage:",{"$f":"'Onsite Information'!$D$32","v":0},"Total Planned Square Footage:",{"$f":"'Offsite Permanent'!D43+'Offsite Permanent'!D56+'Offsite Permanent'!D17+'Offsite Permanent'!D30","v":0}]
["Min # of Individuals Housed:",{"$f":"'Onsite Information'!$G$18","v":0},"Minimum Individuals Housed:",{"$f":"'Onsite Information'!$G$32","v":0},"Minimum Individuals Housed:",{"$f":"'Offsite Permanent'!G17+'Offsite Permanent'!G30+'Offsite Permanent'!G43+'Offsite Permanent'!G56","v":0}]
["Max # of Individuals Housed:",{"$f":"'Onsite Information'!H18","v":0},"Maximum Individuals Housed:",{"$f":"'Onsite Information'!$H$32","v":0},"Maximum Individuals Housed:",{"$f":"'Offsite Permanent'!H17+'Offsite Permanent'!H30+'Offsite Permanent'!H43+'Offsite Permanent'!H56","v":0}]
["Average Number of Individuals Housed",{"$f":"AVERAGE(B9:B10)","v":0},"Average Number of Individuals Housed",{"$f":"AVERAGE(D9:D10)","v":0},"Average Number of Individuals Housed",{"$f":"AVERAGE(F9:F10)","v":0}]
["Total Proposed On and Offsite Permanent Housing ",null,"Change in Units and Square Footage",null,"Form and Manager Determination"]
["Number of Perm Units:",{"$f":"D6+F6","v":0},"Change in # of Units:",{"$f":"$B13-$B$6","v":0},"Form Calculated Determination Recommendation",{"$f":"IF(OR(AND($D$14<0,$D$15<0,D13<0),AND(D14<0,D16>0,D13<0),AND(D15<0,D16>0,D13<0),AND(D14<0,D15<0,D16>0)),\"Deny\",\"Approve\")","v":"Approve"}]
["Approx. Square Footage:",{"$f":"D8+F8","v":0},"Change in Square Footage:",{"$f":"$B$14-$B$8","v":0}]
["Average Number of Individuals Housed",{"$f":"D11+F11","v":0},"Change in Average Housing Capacity:",{"$f":"$B$15-$B$11","v":0},"Manager Final Decision:","Select One"]
["Average AMI:",{"$f":"IFERROR(IF('Offsite Permanent'!B4=\"Select Number of Sites\",'HCD USE ONLY'!D7,((($D$7*D6)+($F$6*$F$7))/($D$6+$F$6))),0)","v":0},"Change in Average AMI:",{"$f":"IFERROR(B16-B7,0)","v":0}]
["Maximum Individuals Housed:",{"$f":"D10+F10","v":0},null,null,"Manager Explanation of Decision"]
["Grant Management Representative Name",null,"Initials","Date"]
[]
["HCD Manager",null,"Initials","Date"]
[]
[]
["MGM Rep Analysis Checklist"]
["If  average housing capacity, number of units, average AMI, and square footage are ALL reduced in the proposed permanent housing mix, Grantee will need to adjust conversion plan to prevent reduction in at least one category."]
["Question",null,null,"Y/N","Notes"]
["1. Will a Standard Agreement Amendment be required?"]
["1a. For a Unit Mix change? (Compare permanent unit mix on this form to SA unit mix)"]
["1b. For an Ownership Transfer? Refer to cell G40 on first tab\nInclude in Notes if Ownership Transfer Amendment is already underway"]
["1c. For Other Reason? (explain in notes)"]
["2. If Sponsor/Grantee reported that they have submitted a 55-year covenant, do we already have that in our file? \n"]
["2a. If yes, what is the status of the covenant?"]
["2b. If no, enter this date into the Tracker as a reminder to follow up with the Grantee for a draft 55-Year Covenant",null,null,{"$f":"IF('Onsite Information'!$G$42=\"\",\"\",'Onsite Information'!$G$42-30)","v":""}]
["2c. Grantee's next steps for handling new financing:",null,null,{"$f":"IF('Onsite Information'!$G$45=\"Select One\",\"\",'Onsite Information'!$G$45)","v":""}]
["3. Did Sponsor adequately answer each question in the narrative section? "]
["4. Is the Sponsor's plan for tenants following best practices, meeting the minimum standard, or is it out of compliance? (refer to responses to questions 3 and 5)"]
["5. Is Sponsor's plan for site conversion and changes to the site before and after acceptable? (refer to question 4 and cell I7 in the table above)"]
["6. Enter \"Yes\" once you have inputted the following into the MGM Homekey Tracker:\n- Conversion Notice Section\n- Due Date of Draft Use Restriction (cell G42)\nNote: These dates may change over time as construction timelines fluctuate - adjust the tracker as needed, but do not change this Interim to Perm workbook."]

{"sheet":"Lists","index":3,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,"Lien Priority"]
[null,"Select One"]
[null,"1) All funding sources are grants and will not be secured against the Homekey site"]
[null,"2) We acknowledge that the Homekey 55-year Use Restriction will be recorded in first lien priority"]
[null,"3) The Homekey 55-year Use Restriction already recorded in fist lien priority and will remain in first."]
[]
[null,"Manager Approval"]
[null,"Select One"]
[null,"Approve"]
[null,"Approve with Conditions"]
[null,"Deny"]
[]
[null,"Unit Size"]
[null,"Select One"]
[null,"Studio"]
[null,"1 Bedroom"]
[null,"2 Bedroom"]
[null,"3 Bedroom"]
[null,"4+ Bedroom"]