{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Unit Designation DHCD form","INSTRUCTIONS","UnitList2"],"not_rendered":{"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Unit Designation DHCD form","index":0,"n_rows":244,"n_cols":27,"rows_kept":244,"merged":[[1,3,1,12],[2,3,2,12],[3,0,3,16],[5,3,5,7],[5,11,5,12],[5,19,5,22],[6,3,6,12],[7,3,7,12],[10,10,10,11],[11,7,11,8],[11,10,11,11],[14,9,14,13],[16,1,16,2],[16,3,16,6],[16,9,16,11],[16,14,16,16],[20,3,20,7],[20,9,20,10],[20,11,20,14],[20,16,20,25]]}
[]
[{"$nulls":3},"UNIT DESIGNATION COMPLIANCE FORM"]
[{"$nulls":3}," HOME, HSF, CATNHP, CIPF, AHTF, HTF, CBH, HIF, FCF"]
["In lieu of completing this form, the project may provide a compliance report that includes all of the information detailed below: bedroom size, rent, income, and applicable funding sources."]
[]
[null,"1. Project Name:",{"$nulls":7},"2. Request Date:",{"$nulls":5},"STUDIO",{"$f":"COUNTIF(C26:C212,\"0\")","v":0}]
[null,"2. Property Address:",{"$nulls":13},"1-BDRM",{"$f":"COUNTIF(C26:C212,\"1\")","v":0}]
[null,"3. City:",{"$nulls":13},"2-BDRM",{"$f":"COUNTIF(C26:C212,\"2\")","v":0}]
[{"$nulls":15},"3-BDRM",{"$f":"COUNTIF(C26:C212,\"3\")","v":0}]
[null,"4. Utility Allowance Information, if applicable (Identify in Table 13**)",{"$nulls":13},"4-BDRM",{"$f":"COUNTIF(C26:C212,\"4\")","v":0}]
[{"$nulls":3},"Source of Utility Allowance Schedule(s):",{"$nulls":3},"A.",null,"B.",null,null,"C.",null,null,"OTHER",{"$f":"COUNTIF(C26:C212,\"5\")","v":0}]
[{"$nulls":3},"Effective Date of Current Schedule:",{"$nulls":11},"SRO",{"$f":"COUNTIF(C26:C212,\"SRO\")","v":0}]
[{"$nulls":15},"TOTAL",{"$f":"SUM(Q6:Q12)","v":0}]
[null,"5. Total PROJECT Units:",{"$nulls":13},"*Ensure unit distribution reflects project's Affordable Housing Restriction"]
[]
[null,"I certify the information provided on this form to be complete and accurate to the best of my knowledge. "]
[null,"6. Person Completing Form:",{"$nulls":6},"Email:",{"$nulls":4},"Phone:"]
[]
[]
[null,"7. Identify and complete for ALL DHCD-assisted units with CURRENT information:"]
[{"$nulls":3},"A. CURRENT RENTS",{"$nulls":4},"B. ","C. RENT DETAILS",null,"D.  INCOME DETAILS",{"$nulls":3},"E.","F. Funding Source & Income Designation by Unit as per AHR"]
[null,"Unit Number","Bedroom Size","Rent Designation","Tenant Rent","Subsidy Amount *","Utility Allowance (UA)","Total Gross Rent \n(inc UA)","Program Rent Limit","*Rental Assistance        \n","UA Source**","Household Income","Household Size","Actual\n Income \nTier","Most Recent Recert Date","Move-In Date if within past 12 months","HOME","AHTF","CATNHP","CIPF","HSF","HTF","HIF","CBH","FCF","LIHTC","Notes"]
[null,"TOTALS",null,{"$f":"COUNTIF(D26:D242,\"<>\"&\"\")","v":0},{"$nulls":9},{"$f":"COUNTIF(N26:N242,\"<>\"&\"\")","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,2,{"v":0.6,"d":"60%"},1100,null,50,{"$f":"SUM(E24:G24)","v":1150},1200,"No","A",{"v":33333,"d":"$33,333"},3,{"v":0.5,"d":"50%"},"2014-09-30","2014-03-14",{"v":0.6,"d":"60%"},{"v":0.3,"d":"30%"},null,null,{"v":0.6,"d":"60%"},null,{"v":0.5,"d":"50%"},{"v":0.3,"d":"30%"},null,"x"]
[null,"Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22","Column23","Column24","Column25","Column26"]
[1,{"$nulls":6},{"$f":"IF(ISBLANK(B26),\" \",SUM(E26:G26))","v":" "},{"$f":"IF(F26>0,IF(ISBLANK(Q26),\"NA\",IF(J26=\"Project-based\",\"PBA\",\" \")),\" \")","v":" "}]
[{"$f":"A26+1","v":2},{"$nulls":6}," "," "]
[3,{"$nulls":6}," "," "]
[4,{"$nulls":6}," "," "]
[5,{"$nulls":6}," "," "]
[6,{"$nulls":6}," ",{"$f":"IF(F31>0,IF(ISBLANK(Q31),\"NA\",IF(J31=\"Project-based\",\"PBA\",\" \")),\" \")","v":" "}]
[7,{"$nulls":6}," "," "]
[8,{"$nulls":6}," "," "]
[9,{"$nulls":6}," "," "]
[10,{"$nulls":6}," "," "]
[11,{"$nulls":6}," "," "]
[12,{"$nulls":6}," "," "]
[13,{"$nulls":6}," "," "]
[14,{"$nulls":6}," "," "]
[15,{"$nulls":6}," "," "]
[16,{"$nulls":6}," "," "]
[17,{"$nulls":6}," "," "]
[18,{"$nulls":6}," "," "]
[19,{"$nulls":6}," "," "]
[20,{"$nulls":6}," "," "]
[21,{"$nulls":6}," "," "]
[22,{"$nulls":6}," "," "]
[23,{"$nulls":6}," "," "]
[24,{"$nulls":6}," "," "]
[25,{"$nulls":6}," "," "]
[26,{"$nulls":6}," "," "]
[27,{"$nulls":6}," "," "]
[28,{"$nulls":6}," "," "]
[29,{"$nulls":6}," "," "]
[30,{"$nulls":6}," "," "]
[31,{"$nulls":6}," "," "]
[32,{"$nulls":6}," "," "]
[33,{"$nulls":6}," "," "]
[34,{"$nulls":6}," "," "]
[35,{"$nulls":6}," "," "]
[36,{"$nulls":6}," "," "]
[37,{"$nulls":6}," "," "]
[38,{"$nulls":6}," "," "]
[39,{"$nulls":6}," "," "]
[40,{"$nulls":6}," "," "]
[41,{"$nulls":6}," "," "]
[42,{"$nulls":6}," "," "]
[43,{"$nulls":6}," "," "]
[44,{"$nulls":6}," "," "]
[45,{"$nulls":6}," "," "]
[46,{"$nulls":6}," "," "]
[{"$f":"A71+1","v":47},{"$nulls":6}," "," "]
[48,{"$nulls":6}," "," "]
[49,{"$nulls":6}," "," "]
[50,{"$nulls":6}," "," "]
[51,{"$nulls":6}," "," "]
[52,{"$nulls":6}," "," "]
[53,{"$nulls":6}," "," "]
[54,{"$nulls":6}," "," "]
[55,{"$nulls":6}," "," "]
[56,{"$nulls":6}," "," "]
[57,{"$nulls":6}," "," "]
[58,{"$nulls":6}," "," "]
[59,{"$nulls":6}," "," "]
[60,{"$nulls":6}," "," "]
[61,{"$nulls":6}," "," "]
[62,{"$nulls":6}," "," "]
[63,{"$nulls":6}," "," "]
[64,{"$nulls":6}," "," "]
[65,{"$nulls":6},{"$f":"IF(ISBLANK(B90),\" \",SUM(E90:G90))","v":" "}," "]
[66,{"$nulls":6}," "," "]
[67,{"$nulls":6}," "," "]
[68,{"$nulls":6}," "," "]
[69,{"$nulls":6}," "," "]
[70,{"$nulls":6}," ",{"$f":"IF(F95>0,IF(ISBLANK(Q95),\"NA\",IF(J95=\"Project-based\",\"PBA\",\" \")),\" \")","v":" "}]
[71,{"$nulls":6}," "," "]
[72,{"$nulls":6}," "," "]
[73,{"$nulls":6}," "," "]
[74,{"$nulls":6}," "," "]
[75,{"$nulls":6}," "," "]
[{"$f":"A100+1","v":76},{"$nulls":6}," "," "]
[77,{"$nulls":6}," "," "]
[{"$f":"A102+1","v":78},{"$nulls":6}," "," "]
[79,{"$nulls":6}," "," "]
[80,{"$nulls":6}," "," "]
[81,{"$nulls":6}," "," "]
[82,{"$nulls":6}," "," "]
[83,{"$nulls":6}," "," "]
[84,{"$nulls":6}," "," "]
[85,{"$nulls":6}," "," "]
[86,{"$nulls":6}," "," "]
[87,{"$nulls":6}," "," "]
[88,{"$nulls":6}," "," "]
[89,{"$nulls":6}," "," "]
[90,{"$nulls":6}," "," "]
[91,{"$nulls":6}," "," "]
[92,{"$nulls":6}," "," "]
[93,{"$nulls":6}," "," "]
[94,{"$nulls":6}," "," "]
[95,{"$nulls":6}," "," "]
[96,{"$nulls":6}," "," "]
[97,{"$nulls":6}," "," "]
[98,{"$nulls":6}," "," "]
[99,{"$nulls":6}," "," "]
[100,{"$nulls":6}," "," "]
[101,{"$nulls":6}," "," "]
[102,{"$nulls":6}," "," "]
[103,{"$nulls":6}," "," "]
[104,{"$nulls":6}," "," "]
[105,{"$nulls":6}," "," "]
[106,{"$nulls":6}," "," "]
[107,{"$nulls":6}," "," "]
[108,{"$nulls":6}," "," "]
[109,{"$nulls":6}," "," "]
[110,{"$nulls":6}," "," "]
[111,{"$nulls":6}," "," "]
[112,{"$nulls":6}," "," "]
[113,{"$nulls":6}," "," "]
[114,{"$nulls":6}," "," "]
[115,{"$nulls":6}," "," "]
[116,{"$nulls":6}," "," "]
[117,{"$nulls":6}," "," "]
[118,{"$nulls":6}," "," "]
[119,{"$nulls":6}," "," "]
[120,{"$nulls":6}," "," "]
[121,{"$nulls":6}," "," "]
[122,{"$nulls":6}," "," "]
[123,{"$nulls":6}," "," "]
[124,{"$nulls":6}," "," "]
[125,{"$nulls":6}," "," "]
[126,{"$nulls":6}," "," "]
[127,{"$nulls":6}," "," "]
[128,{"$nulls":6}," "," "]
[129,{"$nulls":6},{"$f":"IF(ISBLANK(B154),\" \",SUM(E154:G154))","v":" "}," "]
[130,{"$nulls":6}," "," "]
[131,{"$nulls":6}," "," "]
[132,{"$nulls":6}," "," "]
[133,{"$nulls":6}," "," "]
[134,{"$nulls":6}," ",{"$f":"IF(F159>0,IF(ISBLANK(Q159),\"NA\",IF(J159=\"Project-based\",\"PBA\",\" \")),\" \")","v":" "}]
[135,{"$nulls":6}," "," "]
[136,{"$nulls":6}," "," "]
[137,{"$nulls":6}," "," "]
[138,{"$nulls":6}," "," "]
[139,{"$nulls":6}," "," "]
[140,{"$nulls":6}," "," "]
[141,{"$nulls":6}," "," "]
[{"$f":"A166+1","v":142},{"$nulls":6}," "," "]
[143,{"$nulls":6}," "," "]
[144,{"$nulls":6}," "," "]
[145,{"$nulls":6}," "," "]
[146,{"$nulls":6}," "," "]
[147,{"$nulls":6}," "," "]
[148,{"$nulls":6}," "," "]
[149,{"$nulls":6}," "," "]
[150,{"$nulls":6}," "," "]
[151,{"$nulls":6}," "," "]
[152,{"$nulls":6}," "," "]
[153,{"$nulls":6}," "," "]
[154,{"$nulls":6}," "," "]
[155,{"$nulls":6}," "," "]
[156,{"$nulls":6}," "," "]
[157,{"$nulls":6}," "," "]
[158,{"$nulls":6}," "," "]
[159,{"$nulls":6}," "," "]
[160,{"$nulls":6}," "," "]
[161,{"$nulls":6}," "," "]
[162,{"$nulls":6}," "," "]
[163,{"$nulls":6}," "," "]
[164,{"$nulls":6}," "," "]
[165,{"$nulls":6}," "," "]
[166,{"$nulls":6}," "," "]
[167,{"$nulls":6}," "," "]
[168,{"$nulls":6}," "," "]
[169,{"$nulls":6}," "," "]
[170,{"$nulls":6}," "," "]
[171,{"$nulls":6}," "," "]
[172,{"$nulls":6}," "," "]
[173,{"$nulls":6}," "," "]
[174,{"$nulls":6}," "," "]
[175,{"$nulls":6}," "," "]
[176,{"$nulls":6}," "," "]
[177,{"$nulls":6}," "," "]
[178,{"$nulls":6}," "," "]
[179,{"$nulls":6}," "," "]
[180,{"$nulls":6}," "," "]
[181,{"$nulls":6}," "," "]
[182,{"$nulls":6}," "," "]
[183,{"$nulls":6}," "," "]
[184,{"$nulls":6}," "," "]
[185,{"$nulls":6}," "," "]
[186,{"$nulls":6}," "," "]
[187,{"$nulls":6}," "," "]
[188,{"$nulls":6}," "," "]
[189,{"$nulls":6}," "," "]
[190,{"$nulls":6}," "," "]
[191,{"$nulls":6}," "," "]
[192,{"$nulls":6}," "," "]
[193,{"$nulls":6},{"$f":"IF(ISBLANK(B218),\" \",SUM(E218:G218))","v":" "}," "]
[194,{"$nulls":6}," "," "]
[195,{"$nulls":6}," "," "]
[196,{"$nulls":6}," "," "]
[197,{"$nulls":6}," "," "]
[198,{"$nulls":6}," ",{"$f":"IF(F223>0,IF(ISBLANK(Q223),\"NA\",IF(J223=\"Project-based\",\"PBA\",\" \")),\" \")","v":" "}]
[199,{"$nulls":6}," "," "]
[200,{"$nulls":6}," "," "]
[201,{"$nulls":6}," "," "]
[202,{"$nulls":6}," "," "]
[203,{"$nulls":6}," "," "]
[204,{"$nulls":6}," "," "]
[205,{"$nulls":6}," "," "]
[{"$f":"A230+1","v":206},{"$nulls":6}," "," "]
[207,{"$nulls":6}," "," "]
[208,{"$nulls":6}," "," "]
[209,{"$nulls":6}," "," "]
[210,{"$nulls":6}," "," "]
[211,{"$nulls":6}," "," "]
[212,{"$nulls":6}," "," "]
[213,{"$nulls":6}," "," "]
[214,{"$nulls":6}," "," "]
[215,{"$nulls":6}," "," "]
[216,{"$nulls":6}," "," "]
[217,{"$nulls":6}," "," "]
[{"$nulls":7}," "," "]
[{"$nulls":7},{"$f":"IF(ISBLANK(B244),\" \",SUM(E244:G244))","v":" "},{"$f":"IF(F244>0,IF(ISBLANK(Q244),\"NA\",IF(J244=\"Project-based\",\"PBA\",\" \")),\" \")","v":" "}]

{"sheet":"INSTRUCTIONS","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"merged":[[1,0,1,2],[2,0,2,2],[3,0,3,2]]}
[]
["DHCD-ASSISTED UNIT DESIGNATION COMPLIANCE FORM\t\t\t\t\t\t\t\t\t"]
["INSTRUCTIONS"]
[]
["Item","Item Description","Information required"]
["Item 1.","Project Name","DHCD name of the site for which you are submitting the desk review"]
["Item 2. ","Request Date","Date of submission "]
["Item 3. ","Property Address","Identify all addresses associated with the project"]
["Item 4.","Utility Allowance Information ","There may be more than one source of utility allowances at your site.  Include all here."]
["Item 5.","Total Project Units","Total number of units in the project"]
["Item 6.","Person Completing the form ","Most likely this will be a Property Manager or Regional Manager "]
["Item 6.","Contact information","Of the person completing the form"]
["Item 7.","Unit Table","Complete this table for all of the Bond-Assisted units at the site using Up-To-Date data"]
["Item 7A.","Rent Designation","Identify which rent tier the unit currently meets (30%, 50%, 60%, 65%, 80%, 110%)\nOI - over-income rent as per the AHR"]
["Item 7B. ","Program Rent Limit","Identify the rent limit of the MOST restrictive program applicable to each unit"]
["Item 7D. ","Rental Assistance","Select if mobile tenant-based voucher or project-based rental assistance. Review the project's Regulatory Agreement for specific rent restrictions and allowances.  Most projects with subsidies allow the collection of the full payment standard. Mobile voucher assistance stays with the tenant. Project-based assistance stays with the unit."]
["Item 7E.","Actual Income Tier","Identify the income tier the household currently falls within (30%, 50%, 60%, 80%, 110%)\n> 80%: household has an income over 80% and is considered over-income for the program\n> 110%: household has an income over 110% and is considered over-income for the program"]
["Item 7F.","Unit Funding Sources","Identify the income tier of the applicable funding program(s) the unit has been designated to comply with, as prescribed in the project's Affordable Housing Restriction (30%, 50%, 60%, 80%, 110%)."]
[null,null,"Affordable Housing Trust Fund (AHTF)"]
[null,null,"Capital Improvement & Preservation Trust Fund (CIPF)"]
[null,null,"Commercial Area Transit Node Housing Program (CATNHP)"]
[null,null,"Community-Based Housing (CBH)"]
[null,null,"Facilities Consolidation Fund (FCF)"]
[null,null,"Federal Low Income Housing Tax Credits (LIHTC)"]
[null,null,"HOME Investment Partnerships Program (HOME)"]
[null,null,"Housing Innovations Fund (HIF)"]
[null,null,"National Housing Trust Fund (HTF)"]
[null,null,"Transit-Oriented Development (TOD)"]

{"sheet":"UnitList2","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"hidden":true}
[{"v":0,"d":"$0"},null,null,"Mobile",null,{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},"A","LIHTC"]
[{"v":5,"d":"$5"},null,null,"Project-based",null,{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},"B","AHTF"]
[{"v":10,"d":"$10"},null,null,"No",null,{"v":0.6,"d":"60%"},{"v":0.6,"d":"60%"},"C","CATNHP"]
[{"$f":"A3+5","v":{"v":15,"d":"$15"}},{"$nulls":4},"65% HH",{"v":0.8,"d":"80%"},null,"CBH"]
[{"$f":"A4+5","v":{"v":20,"d":"$20"}},{"$nulls":4},{"v":0.8,"d":"80%"},">80%",null,"CIPF"]
[{"$f":"A5+5","v":{"v":25,"d":"$25"}},{"$nulls":4},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},null,"FCF"]
[{"v":30,"d":"$30"},{"$nulls":4},"OI",">110%",null,"HIF"]
[{"v":35,"d":"$35"},{"$nulls":7},"HSF"]
[{"v":40,"d":"$40"},{"$nulls":7},"HTF"]
[{"v":45,"d":"$45"},{"$nulls":7},"HOME"]
[{"v":50,"d":"$50"}]
[{"v":55,"d":"$55"}]
[{"v":60,"d":"$60"}]
[{"v":65,"d":"$65"}]
[{"v":70,"d":"$70"}]