{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["LHTF Coverpage","Project and Applicant","Threshold","Style Guide","Threshold Review","Certification & Legal","Drop downs","Application Score","Score Review","Document Checklist.","Application Support"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":814,"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":"LHTF Coverpage","index":0,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,0,8,22],[11,0,11,22],[12,0,12,22],[6,25,6,35],[23,0,23,22],[20,0,20,22],[21,0,21,22],[22,0,22,22],[15,0,15,22],[16,0,16,22],[19,0,19,22],[0,0,0,24],[1,0,1,22],[2,0,2,22],[5,0,5,22],[7,0,7,22],[3,0,3,22],[6,0,6,22]]}
[]
["Local Housing Trust Fund (LHTF) Program"]
["Application"]
["Rev. 2/2022"]
[]
["2022 Notice of Funding Availability"]
[]
["State of California"]
["Governor Gavin Newsom"]
[]
[]
["Lourdes Castro Ramírez, Secretary"]
["Business, Consumer Services and Housing Agency"]
[]
[]
["Gustavo Velasquez, Director"]
["Department of Housing and Community Development"]
[]
[]
["2020 West El Camino Avenue, Suite 150, Sacramento, CA 95833\n\n\n "]
["Website: http://www.hcd.ca.gov/grants-funding/active-funding/lhtf.shtml"]
["Program Email: LHTF@hcd.ca.gov "]
[]
["NOFA Release: April 5, 2022"]

{"sheet":"Project and Applicant","index":1,"n_rows":28,"n_cols":42,"rows_kept":28,"cut":false,"hidden":false,"merged":[[20,35,20,37],[19,35,19,37],[23,24,23,26],[22,24,22,26],[21,24,21,26],[20,24,20,26],[19,24,19,26],[23,32,23,34],[22,32,22,34],[18,27,18,31],[18,24,18,26],[10,31,10,33],[10,34,10,37],[10,21,10,30],[20,0,20,4],[19,0,19,4],[17,0,17,37],[22,21,22,23],[21,21,21,23],[20,21,20,23],[19,21,19,23],[18,14,18,20],[18,5,18,13],[18,35,18,37],[18,0,18,4],[18,32,18,34],[22,0,22,4],[21,0,21,4],[18,21,18,23],[11,31,11,33],[16,23,16,33],[13,0,13,4],[14,19,14,26],[24,0,24,37],[19,32,19,34],[23,27,23,31],[22,27,22,31],[21,27,21,31],[20,27,20,31],[19,27,19,31],[22,5,22,13],[21,5,21,13],[20,5,20,13],[19,5,19,13],[23,14,23,20],[22,14,22,20],[21,14,21,20],[20,14,20,20],[19,14,19,20],[21,32,21,34],[20,32,20,34],[23,5,23,13],[23,21,23,23],[23,0,23,4],[23,35,23,37],[22,35,22,37],[21,35,21,37],[25,0,25,37],[27,0,27,10],[27,12,27,20],[26,22,26,32],[27,22,27,32],[27,34,27,37],[26,34,26,37],[26,12,26,20],[26,0,26,10],[16,0,16,22],[16,34,16,37],[14,34,14,37],[7,19,7,20],[7,21,7,26],[10,9,10,10],[10,11,10,16],[11,34,11,37],[11,27,11,28],[9,29,9,30],[9,31,9,33],[10,17,10,20],[7,29,7,30],[8,9,8,10],[7,3,7,12],[7,13,7,14],[7,15,7,18],[7,34,7,37],[15,0,15,3],[15,4,15,37],[13,31,13,34],[13,35,13,37],[9,34,9,37],[8,0,8,3],[0,35,0,37],[8,31,8,33],[9,19,9,26],[11,19,11,26],[8,21,8,30],[8,17,8,20],[0,0,0,34],[3,0,3,37],[6,0,6,3],[5,0,5,37],[6,25,6,29],[11,0,11,2],[1,0,1,37],[7,31,7,33],[7,27,7,28],[7,0,7,2],[6,30,6,37],[6,4,6,24],[2,0,2,37],[4,0,4,5],[4,6,4,37],[8,11,8,16],[9,0,9,2],[9,3,9,16],[8,34,8,37],[10,0,10,3],[10,4,10,8],[8,4,8,8],[14,27,14,28],[14,29,14,30],[14,31,14,33],[14,5,14,16],[11,3,11,16],[11,17,11,18],[9,17,9,18],[11,29,11,30],[13,5,13,30],[14,0,14,4],[14,17,14,18],[12,0,12,37],[9,27,9,28]]}
["Project and Applicant Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'LHTF Coverpage'!A4","v":"Rev. 2/2022"}]
["§101(p) “Local Housing Trust Fund” definition"]
["§101(dd) “Regional Housing Trust Fund” definition."]
["§102 Eligible Applicants"]
["Applicant Type:"]
["Applicant Information"]
["Applicant Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Organization Type:",null,null,null,null,{"$f":"IF(G5=\"(a) city\",\"Local Public Entity\",IF(G5=\"(a) city and county\",\"Local Public Entity\",IF(G5=\"(a) county\",\"Local Public Entity\",IF(G5=\"(b) charitable nonprofit organization\",\"Charitable Nonprofit Organization\",IF(G5=\"(c) native american tribe or tribes\",\"Native American Tribe(s)\",\"\")))))","v":""}]
["Address:",null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,"County:",null,null,null,null,null,null,null,"State:",null,"CA",null,"Zip Code:"]
["Auth Rep Name:",null,null,null,null,null,null,null,null,"Title:",null,null,null,null,null,null,null,"Auth Rep. Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
["Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip Code:"]
["Contact Name:",null,null,null,null,null,null,null,null,"Title:",null,null,null,null,null,null,null," Contact Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
["Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip Code:"]
["Trust Fund Information"]
["Full Trust Fund Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Established"]
["Trust Fund Address: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City: ",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip Code:"]
["Trust Fund Type:",null,null,null,"(a) Existing Local Housing Trust Fund (or Existing Regional Housing Trust Fund)"]
[{"$f":"IF(E16='Drop downs'!A2,\"(a) The minimum application request shall be $1 million with a max request of $5 million.\",IF(OR(E16='Drop downs'!A3),\"(b) The minimum application request shall be $500,000 with a max request of $5 million.\",IF(E16='Drop downs'!A4,\"(c) The minimum application request shall be $750,000 with a max request of $5 million.\",\"\")))","v":"(a) The minimum application request shall be $1 million with a max request of $5 million."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount of LHTF Program Funds Requested",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E16='Drop downs'!A2,1000000,IF(E16='Drop downs'!A3,500000,IF(E16='Drop downs'!A4,750000,0)))","v":1000000}]
["Proposed Activity Timeline - provide a timeline of implementation of your Project(s) (§101(g), (1)(2)(3)&(4))"]
["Project Type and Activity",null,null,null,null,"Name of Project",null,null,null,null,null,null,null,null,"When will you issue commitments?",null,null,null,null,null,null,"When will you issue a NOFA/RFQ?",null,null,"When will loan closing occur?",null,null,"When do you anticipate disbursement of LHTF funds?",null,null,null,null,"  Amount of Matching Funds designated to project:",null,null,"Amount of Program Funds designated to project:"]
[]
[]
[]
[]
[]
["Certifications "]
["On behalf of the entity identified below, I certify that: The information, statements and attachments included in this application are, to the best of my knowledge and belief, true and correct and I possess the legal authority to submit this application on behalf of the entity identified in the signature block."]
[]
["Authorized Representative Printed Name ",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,null,null,"Signature (Please Type Name)",null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Threshold","index":2,"n_rows":71,"n_cols":27,"rows_kept":71,"cut":false,"hidden":false,"merged":[[39,17,39,20],[38,0,38,3],[14,21,14,22],[13,21,13,22],[10,21,10,22],[39,8,39,13],[39,14,39,16],[34,0,34,3],[34,4,34,7],[34,8,34,13],[34,14,34,16],[34,17,34,20],[30,0,30,3],[30,4,30,7],[30,8,30,13],[30,14,30,16],[30,17,30,20],[34,21,34,22],[31,0,31,3],[31,4,31,7],[31,8,31,13],[31,14,31,16],[31,17,31,20],[31,21,31,22],[32,0,32,3],[32,4,32,7],[32,8,32,13],[32,14,32,16],[32,17,32,20],[32,21,32,22],[24,8,24,13],[33,0,33,3],[50,0,50,13],[50,14,50,16],[50,17,50,22],[53,17,53,18],[52,17,52,18],[53,11,53,13],[52,11,52,13],[53,8,53,10],[59,5,59,8],[60,0,60,4],[60,5,60,8],[53,0,53,1],[52,2,52,3],[52,0,52,1],[53,14,53,15],[52,14,52,15],[54,0,54,1],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,10],[54,11,54,13],[60,9,60,12],[59,9,59,12],[58,9,58,12],[60,13,60,15],[59,13,59,15],[58,13,58,15],[60,16,60,18],[59,16,59,18],[58,16,58,18],[71,0,71,5],[71,6,71,12],[71,13,71,18],[71,19,71,22],[51,0,51,22],[49,0,49,3],[49,4,49,7],[49,8,49,13],[49,14,49,16],[49,17,49,20],[49,21,49,22],[56,0,56,22],[57,0,57,18],[57,19,57,22],[52,4,52,5],[52,6,52,7],[53,19,53,20],[52,19,52,20],[52,8,52,10],[53,6,53,7],[53,4,53,5],[53,2,53,3],[55,0,55,13],[55,14,55,16],[70,6,70,12],[70,0,70,5],[70,13,70,18],[70,19,70,22],[69,6,69,12],[69,13,69,18],[69,19,69,22],[67,20,67,22],[40,17,40,20],[40,21,40,22],[42,17,42,20],[42,21,42,22],[41,0,41,3],[41,4,41,7],[41,8,41,13],[41,14,41,16],[41,17,41,20],[41,21,41,22],[44,4,44,7],[44,8,44,13],[44,14,44,16],[44,0,44,3],[44,17,44,20],[42,0,42,3],[42,4,42,7],[42,8,42,13],[42,14,42,16],[40,8,40,13],[40,14,40,16],[15,0,15,20],[15,21,15,22],[33,4,33,7],[33,8,33,13],[33,14,33,16],[33,17,33,20],[33,21,33,22],[30,21,30,22],[29,0,29,3],[29,4,29,7],[29,8,29,13],[29,14,29,16],[29,17,29,20],[29,21,29,22],[28,0,28,3],[28,4,28,7],[28,8,28,13],[28,14,28,16],[28,17,28,20],[28,21,28,22],[22,0,22,3],[22,4,22,7],[22,8,22,13],[22,14,22,16],[22,17,22,22],[20,0,20,20],[20,21,20,22],[24,0,24,3],[16,0,16,22],[0,0,0,20],[0,21,0,22],[1,0,1,5],[1,6,1,20],[1,21,1,22],[2,21,2,22],[6,0,6,20],[6,21,6,22],[2,0,2,20],[5,21,5,22],[3,0,3,20],[3,21,3,22],[4,0,4,20],[4,21,4,22],[5,0,5,20],[10,0,10,20],[14,0,14,20],[7,21,7,22],[9,21,9,22],[11,0,11,20],[11,21,11,22],[8,0,8,20],[8,21,8,22],[12,0,12,20],[12,21,12,22],[9,0,9,20],[13,0,13,20],[7,0,7,20],[35,0,35,13],[35,17,35,22],[35,14,35,16],[24,21,24,22],[23,0,23,3],[23,4,23,7],[23,8,23,13],[23,14,23,16],[17,0,18,20],[19,0,19,20],[27,21,27,22],[26,0,26,3],[26,4,26,7],[26,8,26,13],[26,14,26,16],[26,17,26,20],[26,21,26,22],[25,0,25,3],[24,14,24,16],[24,17,24,20],[21,0,21,22],[36,0,36,22],[37,4,37,7],[37,8,37,13],[37,14,37,16],[23,17,23,20],[23,21,23,22],[19,21,19,22],[38,4,38,7],[38,8,38,13],[38,14,38,16],[38,17,38,20],[38,21,38,22],[39,0,39,3],[39,4,39,7],[45,0,45,3],[45,4,45,7],[39,21,39,22],[37,0,37,3],[37,17,37,22],[40,0,40,3],[40,4,40,7],[25,4,25,7],[25,8,25,13],[25,14,25,16],[25,17,25,20],[25,21,25,22],[27,0,27,3],[27,4,27,7],[27,8,27,13],[27,14,27,16],[27,17,27,20],[24,4,24,7],[47,8,47,13],[47,14,47,16],[47,17,47,20],[47,21,47,22],[48,0,48,3],[48,4,48,7],[48,8,48,13],[48,14,48,16],[48,17,48,20],[48,21,48,22],[44,21,44,22],[43,0,43,3],[43,4,43,7],[43,8,43,13],[43,14,43,16],[43,17,43,20],[43,21,43,22],[47,0,47,3],[63,69,63,91],[63,92,63,114],[63,115,63,137],[63,138,63,160],[63,161,63,183],[63,184,63,206],[54,17,54,18],[54,19,54,20],[54,14,54,15],[55,17,55,22],[62,0,62,22],[58,0,58,4],[58,5,58,8],[61,0,61,8],[63,46,63,68],[61,9,61,12],[61,13,61,15],[61,16,61,18],[58,19,59,22],[60,19,61,22],[63,207,63,229],[63,230,63,252],[63,253,63,275],[63,276,63,298],[63,299,63,321],[63,322,63,344],[63,345,63,367],[63,368,63,390],[63,391,63,413],[63,414,63,436],[63,437,63,459],[63,460,63,482],[63,483,63,505],[63,506,63,528],[63,529,63,551],[63,552,63,574],[63,575,63,597],[63,598,63,620],[63,621,63,643],[63,644,63,666],[63,667,63,689],[63,690,63,712],[63,713,63,735],[63,736,63,758],[63,759,63,781],[63,782,63,804],[63,805,63,827],[63,828,63,850],[63,851,63,873],[63,874,63,896],[63,897,63,919],[63,920,63,942],[63,943,63,965],[63,966,63,988],[63,989,63,1011],[63,1012,63,1034],[63,1035,63,1057],[63,1058,63,1080],[63,1081,63,1103],[63,1104,63,1126],[63,1127,63,1149],[63,1150,63,1172],[63,1173,63,1195],[63,1196,63,1218],[63,1219,63,1241],[63,1242,63,1264],[63,1265,63,1287],[63,1288,63,1310],[63,1311,63,1333],[63,1334,63,1356],[63,1357,63,1379],[63,1380,63,1402],[63,1403,63,1425],[63,1426,63,1448],[63,1449,63,1471],[63,1472,63,1494],[63,1495,63,1517],[63,1518,63,1540],[63,1541,63,1563],[63,1564,63,1586],[63,1587,63,1609],[63,1610,63,1632],[63,1633,63,1655],[63,1656,63,1678],[63,1679,63,1701],[63,1702,63,1724],[63,1725,63,1747],[63,1748,63,1770],[63,1771,63,1793],[63,1794,63,1816],[63,1817,63,1839],[63,1840,63,1862],[63,1863,63,1885],[63,1886,63,1908],[63,1909,63,1931],[63,1932,63,1954],[63,1955,63,1977],[63,1978,63,2000],[63,2001,63,2023],[63,2024,63,2046],[63,2047,63,2069],[63,2070,63,2092],[63,2093,63,2115],[63,2116,63,2138],[63,2139,63,2161],[63,2162,63,2184],[63,2185,63,2207],[63,2208,63,2230],[63,2231,63,2253],[63,2254,63,2276],[63,2277,63,2299],[63,2300,63,2322],[63,2323,63,2345],[63,2346,63,2368],[63,2369,63,2391],[63,2392,63,2414],[63,2415,63,2437],[63,2438,63,2460],[63,2461,63,2483],[63,2484,63,2506],[63,2507,63,2529],[63,2530,63,2552],[63,2553,63,2575],[63,2576,63,2598],[63,2599,63,2621],[63,2622,63,2644],[63,2645,63,2667],[63,2668,63,2690],[63,2691,63,2713],[63,2714,63,2736],[63,2737,63,2759],[63,2760,63,2782],[63,2783,63,2805],[63,2806,63,2828],[63,2829,63,2851],[63,2852,63,2874],[63,2875,63,2897],[63,2898,63,2920],[63,2921,63,2943],[63,2944,63,2966],[63,2967,63,2989],[63,2990,63,3012],[63,3013,63,3035],[63,3036,63,3058],[63,3059,63,3081],[63,3082,63,3104],[63,3105,63,3127],[63,3128,63,3150],[63,3151,63,3173],[63,3174,63,3196],[63,3197,63,3219],[63,3220,63,3242],[63,3243,63,3265],[63,3266,63,3288],[63,3289,63,3311],[63,3312,63,3334],[63,3335,63,3357],[63,3358,63,3380],[63,3381,63,3403],[63,3404,63,3426],[63,3427,63,3449],[63,3450,63,3472],[63,3473,63,3495],[63,3496,63,3518],[63,3519,63,3541],[63,3542,63,3564],[63,3565,63,3587],[63,3588,63,3610],[63,3611,63,3633],[63,3634,63,3656],[63,3657,63,3679],[63,3680,63,3702],[63,3703,63,3725],[63,3726,63,3748],[63,3749,63,3771],[63,3772,63,3794],[63,3795,63,3817],[63,3818,63,3840],[63,3841,63,3863],[63,3864,63,3886],[63,3887,63,3909],[63,3910,63,3932],[63,3933,63,3955],[63,3956,63,3978],[63,3979,63,4001],[63,4002,63,4024],[63,4025,63,4047],[63,4048,63,4070],[63,4071,63,4093],[63,4094,63,4116],[63,4117,63,4139],[63,4140,63,4162],[63,4163,63,4185],[63,4186,63,4208],[63,4209,63,4231],[63,4232,63,4254],[63,4255,63,4277],[63,4278,63,4300],[63,4301,63,4323],[63,4324,63,4346],[63,4347,63,4369],[63,4370,63,4392],[63,4393,63,4415],[63,4416,63,4438],[63,4439,63,4461],[63,4462,63,4484],[63,4485,63,4507],[63,4508,63,4530],[63,4531,63,4553],[63,4554,63,4576],[63,4577,63,4599],[63,4600,63,4622],[63,4623,63,4645],[63,4646,63,4668],[63,4669,63,4691],[63,4692,63,4714],[63,4715,63,4737],[63,4738,63,4760],[63,4761,63,4783],[63,4784,63,4806],[63,4807,63,4829],[63,4830,63,4852],[63,4853,63,4875],[63,4876,63,4898],[63,4899,63,4921],[63,4922,63,4944],[63,4945,63,4967],[63,4968,63,4990],[63,4991,63,5013],[63,5014,63,5036],[63,5037,63,5059],[63,5060,63,5082],[63,5083,63,5105],[63,5106,63,5128],[63,5129,63,5151],[63,5152,63,5174],[63,5175,63,5197],[63,5198,63,5220],[63,5221,63,5243],[63,5244,63,5266],[63,5267,63,5289],[63,5290,63,5312],[63,5313,63,5335],[63,5336,63,5358],[63,5359,63,5381],[63,5382,63,5404],[63,5405,63,5427],[63,5428,63,5450],[63,5451,63,5473],[63,5474,63,5496],[63,5497,63,5519],[63,5520,63,5542],[63,5543,63,5565],[63,5566,63,5588],[63,5589,63,5611],[63,5612,63,5634],[63,5635,63,5657],[63,5658,63,5680],[63,5681,63,5703],[63,5704,63,5726],[63,5727,63,5749],[63,5750,63,5772],[63,5773,63,5795],[63,5796,63,5818],[63,5819,63,5841],[63,5842,63,5864],[63,5865,63,5887],[63,5888,63,5910],[63,5911,63,5933],[63,5934,63,5956],[63,5957,63,5979],[63,5980,63,6002],[63,6003,63,6025],[63,6026,63,6048],[63,6049,63,6071],[63,6072,63,6094],[63,6095,63,6117],[63,6118,63,6140],[63,6141,63,6163],[63,6164,63,6186],[63,6187,63,6209],[63,6210,63,6232],[63,6233,63,6255],[63,6256,63,6278],[63,6279,63,6301],[63,6302,63,6324],[63,6325,63,6347],[63,6348,63,6370],[63,6371,63,6393],[63,6394,63,6416],[63,6417,63,6439],[63,6440,63,6462],[63,6463,63,6485],[63,6486,63,6508],[63,6509,63,6531],[63,6532,63,6554],[63,6555,63,6577],[63,6578,63,6600],[63,6601,63,6623],[63,6624,63,6646],[63,6647,63,6669],[63,6670,63,6692],[63,6693,63,6715],[63,6716,63,6738],[63,6739,63,6761],[63,6762,63,6784],[63,6785,63,6807],[63,6808,63,6830],[63,6831,63,6853],[63,6854,63,6876],[63,6877,63,6899],[63,6900,63,6922],[63,6923,63,6945],[63,6946,63,6968],[63,6969,63,6991],[63,6992,63,7014],[63,7015,63,7037],[63,7038,63,7060],[63,7061,63,7083],[63,7084,63,7106],[63,7107,63,7129],[63,7130,63,7152],[63,7153,63,7175],[63,7176,63,7198],[63,7199,63,7221],[63,7222,63,7244],[63,7245,63,7267],[63,7268,63,7290],[63,7291,63,7313],[63,7314,63,7336],[63,7337,63,7359],[63,7360,63,7382],[63,7383,63,7405],[63,7406,63,7428],[63,7429,63,7451],[63,7452,63,7474],[63,7475,63,7497],[63,7498,63,7520],[63,7521,63,7543],[63,7544,63,7566],[63,7567,63,7589],[63,7590,63,7612],[63,7613,63,7635],[63,7636,63,7658],[63,7659,63,7681],[63,7682,63,7704],[63,7705,63,7727],[63,7728,63,7750],[63,7751,63,7773],[63,7774,63,7796],[63,7797,63,7819],[63,7820,63,7842],[63,7843,63,7865],[63,7866,63,7888],[63,7889,63,7911],[63,7912,63,7934],[63,7935,63,7957],[63,7958,63,7980],[63,7981,63,8003],[63,8004,63,8026],[63,8027,63,8049],[63,8050,63,8072],[63,8073,63,8095],[63,8096,63,8118],[63,8119,63,8141],[63,8142,63,8164],[63,8165,63,8187],[63,8188,63,8210],[63,8211,63,8233],[63,8234,63,8256],[63,8257,63,8279],[63,8280,63,8302],[63,8303,63,8325],[63,8326,63,8348],[63,8349,63,8371],[63,8372,63,8394],[63,8395,63,8417],[63,8418,63,8440],[63,8441,63,8463],[63,8464,63,8486],[63,8487,63,8509],[63,8510,63,8532],[63,8533,63,8555],[63,8556,63,8578],[63,8579,63,8601],[63,8602,63,8624],[63,8625,63,8647],[63,8648,63,8670],[63,8671,63,8693],[63,8694,63,8716],[63,8717,63,8739],[63,8740,63,8762],[63,8763,63,8785],[63,8786,63,8808],[63,8809,63,8831],[63,8832,63,8854],[63,8855,63,8877],[63,8878,63,8900],[63,8901,63,8923],[63,8924,63,8946],[63,8947,63,8969],[63,8970,63,8992],[63,8993,63,9015],[63,9016,63,9038],[63,9039,63,9061],[63,9062,63,9084],[63,9085,63,9107],[63,9108,63,9130],[63,9131,63,9153],[63,9154,63,9176],[63,9177,63,9199],[63,9200,63,9222],[63,9223,63,9245],[63,9246,63,9268],[63,9269,63,9291],[63,9292,63,9314],[63,9315,63,9337],[63,9338,63,9360],[63,9361,63,9383],[63,9384,63,9406],[63,9407,63,9429],[63,9430,63,9452],[63,9453,63,9475],[63,9476,63,9498],[63,9499,63,9521],[63,9522,63,9544],[63,9545,63,9567],[63,9568,63,9590],[63,9591,63,9613],[63,9614,63,9636],[63,9637,63,9659],[63,9660,63,9682],[63,9683,63,9705],[63,9706,63,9728],[63,9729,63,9751],[63,9752,63,9774],[63,9775,63,9797],[63,9798,63,9820],[63,9821,63,9843],[63,9844,63,9866],[63,9867,63,9889],[63,9890,63,9912],[63,9913,63,9935],[63,9936,63,9958],[63,9959,63,9981],[63,9982,63,10004],[63,10005,63,10027],[63,10028,63,10050],[63,10051,63,10073],[63,10074,63,10096],[63,10097,63,10119],[63,10120,63,10142],[63,10143,63,10165],[63,10166,63,10188],[63,10189,63,10211],[63,10212,63,10234],[63,10235,63,10257],[63,10258,63,10280],[63,10281,63,10303],[63,10304,63,10326],[63,10327,63,10349],[63,10350,63,10372],[63,10373,63,10395],[63,10396,63,10418],[63,10419,63,10441],[63,10442,63,10464],[63,10465,63,10487],[63,10488,63,10510],[63,10511,63,10533],[63,10534,63,10556],[63,10557,63,10579],[63,10580,63,10602],[63,10603,63,10625],[63,10626,63,10648],[63,10649,63,10671],[63,10672,63,10694],[63,10695,63,10717],[63,10718,63,10740],[63,10741,63,10763],[63,10764,63,10786],[63,10787,63,10809],[63,10810,63,10832],[63,10833,63,10855],[63,10856,63,10878],[63,10879,63,10901],[63,10902,63,10924],[63,10925,63,10947],[63,10948,63,10970],[63,10971,63,10993],[63,10994,63,11016],[63,11017,63,11039],[63,11040,63,11062],[63,11063,63,11085],[63,11086,63,11108],[63,11109,63,11131],[63,11132,63,11154],[63,11155,63,11177],[63,11178,63,11200],[63,11201,63,11223],[63,11224,63,11246],[63,11247,63,11269],[63,11270,63,11292],[63,11293,63,11315],[63,11316,63,11338],[63,11339,63,11361],[63,11362,63,11384],[63,11385,63,11407],[63,11408,63,11430],[63,11431,63,11453],[63,11454,63,11476],[63,11477,63,11499],[63,11500,63,11522],[63,11523,63,11545],[63,11546,63,11568],[63,11569,63,11591],[63,11592,63,11614],[63,11615,63,11637],[63,11638,63,11660],[63,11661,63,11683],[63,11684,63,11706],[63,11707,63,11729],[63,11730,63,11752],[63,11753,63,11775],[63,11776,63,11798],[63,11799,63,11821],[63,11822,63,11844],[63,11845,63,11867],[63,11868,63,11890],[63,11891,63,11913],[63,11914,63,11936],[63,11937,63,11959],[63,11960,63,11982],[63,11983,63,12005],[63,12006,63,12028],[63,12029,63,12051],[63,12052,63,12074],[63,12075,63,12097],[63,12098,63,12120],[63,12121,63,12143],[63,12144,63,12166],[63,12167,63,12189],[63,12190,63,12212],[63,12213,63,12235],[63,12236,63,12258],[63,12259,63,12281],[63,12282,63,12304],[63,12305,63,12327],[63,12328,63,12350],[63,12351,63,12373],[63,12374,63,12396],[63,12397,63,12419],[63,12420,63,12442],[63,12443,63,12465],[63,12466,63,12488],[63,12489,63,12511],[63,12512,63,12534],[63,12535,63,12557],[63,12558,63,12580],[63,12581,63,12603],[63,12604,63,12626],[63,12627,63,12649],[63,12650,63,12672],[63,12673,63,12695],[63,12696,63,12718],[63,12719,63,12741],[63,12742,63,12764],[63,12765,63,12787],[63,12788,63,12810],[63,12811,63,12833],[63,12834,63,12856],[63,12857,63,12879],[63,12880,63,12902],[63,12903,63,12925],[63,12926,63,12948],[63,12949,63,12971],[63,12972,63,12994],[63,12995,63,13017],[63,13018,63,13040],[63,13041,63,13063],[63,13064,63,13086],[63,13087,63,13109],[63,13110,63,13132],[63,13133,63,13155],[63,13156,63,13178],[63,13179,63,13201],[63,13202,63,13224],[63,13225,63,13247],[63,13248,63,13270],[63,13271,63,13293],[63,13294,63,13316],[63,13317,63,13339],[63,13340,63,13362],[63,13363,63,13385],[63,13386,63,13408],[63,13409,63,13431],[63,13432,63,13454],[63,13455,63,13477],[63,13478,63,13500],[63,13501,63,13523],[63,13524,63,13546],[63,13547,63,13569],[63,13570,63,13592],[63,13593,63,13615],[63,13616,63,13638],[63,13639,63,13661],[63,13662,63,13684],[63,13685,63,13707],[63,13708,63,13730],[63,13731,63,13753],[63,13754,63,13776],[63,13777,63,13799],[63,13800,63,13822],[63,13823,63,13845],[63,13846,63,13868],[63,13869,63,13891],[63,13892,63,13914],[63,13915,63,13937],[63,13938,63,13960],[63,13961,63,13983],[63,13984,63,14006],[63,14007,63,14029],[63,14030,63,14052],[63,14053,63,14075],[63,14076,63,14098],[63,14099,63,14121],[63,14122,63,14144],[63,14145,63,14167],[63,14168,63,14190],[63,14191,63,14213],[63,14214,63,14236],[63,14237,63,14259],[63,14260,63,14282],[63,14283,63,14305],[63,14306,63,14328],[63,14329,63,14351],[63,14352,63,14374],[63,14375,63,14397],[63,14398,63,14420],[63,14421,63,14443],[63,14444,63,14466],[63,14467,63,14489],[63,14490,63,14512],[63,14513,63,14535],[63,14536,63,14558],[63,14559,63,14581],[63,14582,63,14604],[63,14605,63,14627],[63,14628,63,14650],[63,14651,63,14673],[63,14674,63,14696],[63,14697,63,14719],[63,14720,63,14742],[63,14743,63,14765],[63,14766,63,14788],[63,14789,63,14811],[63,14812,63,14834],[63,14835,63,14857],[63,14858,63,14880],[63,14881,63,14903],[63,14904,63,14926],[63,14927,63,14949],[63,14950,63,14972],[63,14973,63,14995],[63,14996,63,15018],[63,15019,63,15041],[63,15042,63,15064],[63,15893,63,15915],[63,15916,63,15938],[63,15525,63,15547],[63,15548,63,15570],[63,15571,63,15593],[63,15594,63,15616],[63,15617,63,15639],[63,15640,63,15662],[63,15663,63,15685],[63,15686,63,15708],[63,15709,63,15731],[63,15065,63,15087],[63,15088,63,15110],[63,15111,63,15133],[63,15134,63,15156],[63,15157,63,15179],[63,15180,63,15202],[63,15203,63,15225],[63,15226,63,15248],[63,15249,63,15271],[63,15272,63,15294],[63,15295,63,15317],[63,15318,63,15340],[63,15341,63,15363],[63,15364,63,15386],[63,15387,63,15409],[63,15410,63,15432],[63,15433,63,15455],[63,16353,63,16375],[63,16376,63,16383],[63,0,63,18],[63,19,63,22],[63,16146,63,16168],[63,16169,63,16191],[63,16192,63,16214],[63,16215,63,16237],[63,16238,63,16260],[63,16261,63,16283],[63,16284,63,16306],[63,16307,63,16329],[63,16330,63,16352],[63,15939,63,15961],[63,15962,63,15984],[63,15985,63,16007],[63,16008,63,16030],[63,16031,63,16053],[63,16054,63,16076],[63,16077,63,16099],[63,16100,63,16122],[63,16123,63,16145],[63,15732,63,15754],[63,15755,63,15777],[63,15456,63,15478],[63,15479,63,15501],[63,15502,63,15524],[63,15778,63,15800],[63,15801,63,15823],[63,15824,63,15846],[63,15847,63,15869],[63,15870,63,15892],[67,16,67,19],[67,12,67,15],[68,0,68,22],[69,0,69,5],[45,17,45,20],[45,21,45,22],[46,0,46,3],[46,4,46,7],[46,8,46,13],[46,14,46,16],[46,17,46,20],[46,21,46,22],[67,8,67,11],[67,3,67,7],[67,0,67,2],[66,0,66,2],[66,3,66,7],[66,8,66,11],[66,12,66,15],[66,16,66,19],[66,20,66,22],[64,0,64,22],[65,0,65,2],[65,20,65,22],[59,0,59,4],[45,8,45,13],[45,14,45,16],[65,3,65,7],[65,8,65,11],[65,12,65,15]],"merged_total":1002,"flags":["merged_cut"]}
["§102 Eligible Applicants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"§103 Funding Amount Minimums and Maximums "]
["Applicant Type:",null,null,null,null,null,{"$f":"'Project and Applicant'!G5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Project and Applicant'!E16","v":"(a) Existing Local Housing Trust Fund (or Existing Regional Housing Trust Fund)"}]
["Amount Requested: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Project and Applicant'!AI17","v":0}]
["(a)(1)(A)  How was the Housing Trust Fund established? \nThe Housing Trust Fund utilizes a public, or joint public and private, fund established by legislation, ordinance, resolution, or a public-private partnership, to receive specific revenue to address local housing needs. \nFrom the dropdown list please select the documentation that establishes the HTF. Please highlight the sections in your documentation that outline the reqirements below. \n          - Language establishing the Local Housing Trust Fund\n          - Identify the specific revenue given to the Local Housing Trust Fund\n          - Identify the language that states the Housing Trust Fund addresses the local housing needs\n          - NOTE: For public RHTFs only, RHTF must include Resolution or Ordinance from each Local government entity that is a member of the RHTF "]
["(a)(1)(B)  Does the Housing Trust Fund meet the minimum Ongoing Revenue requirements? \nThe Trust Fund is funded from Ongoing Revenues as required by the definition in §101 from Dedicated Sources of funding such as taxes, fees, loan repayments, or public or private contributions. \nPlease see requirements in Section 101(z). "]
["(a)(2) Does the city or county have a Housing Element that was adopted by the city or county’s governing body and determined by HCD to be in compliance with state Housing Element law pursuant to GC §65585?"]
["(a)(3) The city or county has submitted to HCD the Annual Progress Report required by GC Code §65400 for the current or prior year? "]
["(b)(1)(A)  How was the charitable nonprofit Housing Trust Fund established? \nThe charitable nonprofit Housing Trust Fund utilizes a public, or joint public and private, fund established by legislation, ordinance, resolution, or a public-private partnership, to receive specific revenue to address local housing needs. \nFrom the dropdown list please select the documentation that establishes the HTF. Please highlight the sections in your documentation that outline the reqirements below. \n          - Language establishing the Local Housing Trust Fund\n          - Identify the specific revenue given to the Local Housing Trust Fund\n          - Identify the language that states the Housing Trust Fund addresses the local housing needs"]
["(b)(1)(B)  Does the charitable nonprofit Housing Trust Fund meet the minimum Ongoing Revenue requirements? \nThe charitable nonprofit Housing Trust Fund is funded from Ongoing Revenues as required by the definition in §101 from Dedicated Sources of funding such as taxes, fees, loan repayments, or public or private contributions. \nPlease see requirements in Section 101(z). "]
["(b)(2) Does the charitable nonprofit organization agree to utilize Program Funds only for Eligible Projects located in cities and counties that have, at the time of application, an adopted Housing Element that the Department has determined, pursuant to Section 65585 of the GC, to be in substantial compliance with the requirements of Article 10.6 (commencing with Section 65580) of Chapter 3 of Division 1 of Title 7 of the GC?"]
["(b)(3) Does the charitable nonprofit organization agree to utilize Program Funds only for Eligible Projects located in cities and counties that have submitted to the Department the Annual Progress Report required by GC Code 65400 for the current year or prior year?"]
["(c)(1)(A)  How was the Housing Trust Fund established? \nThe Housing Trust Fund utilizes a public, or joint public and private, fund established by legislation, ordinance, resolution, or a public-private partnership, to receive specific revenue to address local housing needs. \nFrom the dropdown list please select the documentation that establishes the HTF. Please highlight the sections in your documentation that outline the reqirements below. \n          - Language establishing the Local Housing Trust Fund\n          - Identify the specific revenue given to the Local Housing Trust Fund\n          - Identify the language that states the Housing Trust Fund addresses the local housing needs"]
["(c)(1)(B)  Does the Housing Trust Fund meet the minimum Ongoing Revenue requirements? \nThe Housing Trust Fund is funded from Ongoing Revenues as required by the definition in §101 from Dedicated Sources of funding such as taxes, fees, loan repayments, or public or private contributions. \nPlease see requirements in Section 101(z). "]
["(c)(2) Does the Native American Tribe (or Tribes) agree to utilize Program Funds only for Eligible Projects either (A) located on Native American Lands or (B) located in cities and counties that have, at the time of application, an adopted Housing Element that the Department has determined, pursuant to Section 65585 of the GC, to be in substantial compliance with the requirements of Article 10.6 (commencing with Section 65580) of Chapter 3 of Division 1 of Title 7 of the GC?"]
["(c)(3) Does the Native American Tribe (or Tribes) agree to utilize Program Funds only for Eligible Projects either (A) located on Native American Lands or (B) in cities and counties that have submitted to the Department the Annual Progress Report required by GC Code 65400 for the current year or prior year?"]
["(4) A Local Housing Trust Fund or Regional Housing Trust Fund that was created, funded, and operated by a combination of two or more cities or counties, agrees to utilize Program Funds only for Eligible Projects located in cities or counties that have, at the time of application, an adopted Housing Element meeting the requirements of subparagraph (2) above, and for which the Annual Progress Report was submitted for the current or prior year by the application deadline date, as required by subparagraph (3) above? (Should we make applicant enter in their HE compliance date and remove dropdown)? "]
["§102(d): Previous Awardees"]
["Enter the dollar amount of Program Funds that have been committed from all previous LHTF awards (leave blank if not previously awarded)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Awarded",null,{"$f":"W18*0.4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Committed"]
["Matching Funds Committed "]
["New Applicants (no previous LHTF award) provide the amount of local Matching Funds that have been committed (leave blank if previously awarded)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Project and Applicant'!AI17:AL17*0.4","v":0},0,0,0]
["§104 Matching Funds Requirements"]
["Name of Matching Funds",null,null,null," Select Type of\nMatching Fund ",null,null,null,"Specify Source of Funds",null,null,null,null,null,"Matching Fund Amount",null,null,"Required Documentation for Matching Funds "]
["Example-\nPublic Contribution ",null,null,null,"Example-\nResidential Local Impact Fee",null,null,null,"Example- Residential local impact fees",null,null,null,null,null,3000000,null,null,"Match_Fund_1",null,null,null,"Uploaded to HCD?"]
["Example-\nLand Donation",null,null,null,"Example-\nPublic Contribution",null,null,null,"Example-The public contribution will be from foreclosed land.",null,null,null,null,null,5000000,null,null,"Match_Fund_2",null,null,null,"Uploaded to HCD?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E26<>\"Residential in Lieu Fees\",E26<>\"Residential Local Impact Fees\"),1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E27<>\"Residential in Lieu Fees\",E27<>\"Residential Local Impact Fees\"),1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Total Matching Funds",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O26:Q35)","v":0}]
["Ongoing Revenue\n"]
["Name of Ongoing Revenue ",null,null,null," Select Type of Ongoing Revenue ",null,null,null,"Specify Source of Funds",null,null,null,null,null,"Annual average amount deposited into the HTF",null,null,"Required documentation for Ongoing Revenue \nNOTE: Executed documentation only; no drafts",null,null,null,"Uploaded to HCD?"]
["Example:\nLoan Repayments",null,null,null,"Loan Repayments",null,null,null,"Developer Loan",null,null,null,null,null,50000,null,null,"Ongoing_Rev_1",null,null,null,"Uploaded to HCD?"]
["Example:\nTaxes",null,null,null,"Taxes",null,null,null,"Residential local impact fees",null,null,null,null,null,40000,null,null,"Ongoing_Rev_2",null,null,null,"Uploaded to HCD?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Ongoing Revenues",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O41:Q50)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($V$2=\"(b) New Local Housing Trust Fund (NOT a Regional Housing Trust Fund)\",$O$56,IF($V$2=\"(c) New Local Housing Trust Fund (also a Regional Housing Trust Fund)\",$O$56,0))","v":0},{"$f":"IF($V$2=\"(a) Existing Local Housing Trust Fund (or Existing Regional Housing Trust Fund)\",100000,0)","v":100000}]
["New Housing Trust Fund Only : Complete the average annual projected Operating Costs for the five years after Program Award\nNOTE: If using \"Other,\" please delete \"Other: (Describe)\" and provide a brief description."]
["Salaries and Benefits:",null,null,null,"Insurance: ",null,null,null,"Utilities ",null,null,null,null,null,"Phone/Internet",null,null,"Marketing",null,null,null,"Mailing Fees"]
["Recording Fees",null,null,null,"Supplies",null,null,null,"Real Property Taxes",null,null,null,null,null,"Rent",null,null,"Property Maintenance",null,null,null,"Interest on Loans"]
["Other: (Describe)",null,null,null,"Other: (Describe)",null,null,null,"Other: (Describe)",null,null,null,null,null,"Other: (Describe)",null,null,"Other: (Describe)",null,null,null,"Other: (Describe)"]
["Total Average Operating Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C53,C54,C55,G53,G54,G55,L53,L54,L55,Q53,Q54,Q55,T53,T54,T55,W53,W54,W55)","v":0}]
["§105 Eligible Uses of Funds"]
["105(a): How will Program Funds be used by the Grantee?\nNote: Please reference the 2022 LHTF NOFA (II.G.2. Rating and Ranking) for details regarding scoring"]
["105(a)",null,null,null,null,"105(b)",null,null,null,"105(c)",null,null,null,"105(d)",null,null,"105(e)",null,null,"Total Program Funds accounted for:"]
["What is the simple interest rate for Program Funded Loan(s)",null,null,null,null,"Will Program Funds be used toward administrative expenses? (5% Maximum) ",null,null,null,"Enter percentage of Program Funds designated to serving housholds no higher then 30% Area Median Income ",null,null,null,"Enter percentage of Program Funds designated to serving housholds no higher then 120% Area Median Income ",null,null,"Enter percentage of Program Funds designated to serving housholds no higher then 80% Area Median Income "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F61=\"Yes\",(J61+N61+Q61+0.05),(J61+N61+Q61))","v":0}]
["Minimum Amount of Matching Funds",null,null,null,null,null,null,null,null,{"$f":"J61*V3","v":0},null,null,null,{"$f":"N61*V3","v":0},null,null,{"$f":"Q61*V3","v":0}]
["NOFA Section II(G)(1)(f) Loan Guidelines and Underwriting Standard and Procedures"]
["Applicant has adopted the Uniform Multifamily Regulations (UMRs) as their loan guidelines, underwriting standards, and procedures. \nThe UMRs can be found on our website at  https://hcd.ca.gov/grants-funding/already-have-funding/uniform-multifamily-regulations/docs/uniform-multifamily-regulations-2017.pdf"]
["All ten factors must be addressed in your loan guidelines. Underwriting standards and procedures must be submitted to the department for review. \nPlease complete the fields below by providing where within your guidelines we can verify this information."]
["Debt ratio coverage",null,null,"Minimum projected operating expenses",null,null,null,null,"Replacement reserve \n(enter the amount per unit)",null,null,null,"Capitalized operating reserve (Development funding source at a minimum)",null,null,null,"Positive cash flow",null,null,null,"Projected vacancy rate"]
["An example can be found in §8310(e) Page 19 of UMRs.",null,null,"An example can be found in §8301(k) Page 4 of UMRs, or TCAC limits.",null,null,null,null,"An example can be found in §8309(b)(1)(2) Page 16 of UMRs.",null,null,null,"An example can be found in §8308(b) Page 14 of UMRs.",null,null,null,"An example can be found in §8310(i) Page 20 of UMRs.",null,null,null,"An example can be found in §8310(a)(b) Page 18 of UMRs."]
[]
[]
["Construction Contingency \n(LHTF Construction Financing only)",null,null,null,null,null,"Senior lender and/or junior lender loan requirements",null,null,null,null,null,null,"Interest Rate",null,null,null,null,null,"Leasehold Security Requirements"]
["An example can be found in §8310(j) Page 20 of UMRs.",null,null,null,null,null,"An example can be found in §8310(f) Page 19 or \n§8310(g)(h) Page 20 of UMRs.",null,null,null,null,null,null,"See LTHF Guidelines, Section 105(a)",null,null,null,null,null,"An example can be found in §8316 Page 32 of UMRs."]

{"sheet":"Style Guide","index":3,"n_rows":22,"n_cols":37,"rows_kept":22,"cut":false,"hidden":true,"merged":[[10,33,10,34],[10,35,10,37],[11,0,11,37],[9,31,9,32],[9,33,9,34],[9,35,9,37],[10,0,10,9],[10,10,10,14],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,24,10,30],[9,0,9,5],[9,8,9,9],[9,10,9,14],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,21,9,22],[9,24,9,30],[10,31,10,32],[7,33,7,35],[7,36,7,37],[8,0,8,5],[8,8,8,9],[8,10,8,14],[8,15,8,16],[8,17,8,18],[8,19,8,20],[8,21,8,22],[8,24,8,30],[8,31,8,32],[8,33,8,34],[8,35,8,37],[7,0,7,5],[7,8,7,9],[7,10,7,14],[7,15,7,16],[7,17,7,18],[7,19,7,20],[7,21,7,22],[7,28,7,30],[7,31,7,32],[6,24,7,27],[6,28,6,30],[6,31,6,32],[5,33,5,35],[5,36,5,37],[6,0,6,5],[6,8,6,9],[6,10,6,14],[6,15,6,16],[6,17,6,18],[5,0,5,5],[5,8,5,9],[5,10,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[6,36,6,37],[6,19,6,20],[6,21,6,22],[6,33,6,35],[4,0,4,5],[4,8,4,9],[4,10,4,14],[4,15,4,16],[4,17,4,18],[4,19,4,20],[5,21,5,22],[5,28,5,30],[5,31,5,32],[2,31,2,32],[2,33,2,35],[2,36,2,37],[2,19,2,20],[4,21,4,22],[4,24,4,27],[4,28,4,30],[4,31,4,32],[4,33,4,35],[4,36,4,37],[0,0,0,34],[0,35,0,37],[1,0,1,9],[1,10,1,22],[1,24,1,32],[1,33,1,37],[3,0,3,5],[3,8,3,9],[3,10,3,14],[3,15,3,16],[3,17,3,18],[2,0,2,5],[2,8,2,9],[2,10,2,14],[2,15,2,16],[2,17,2,18],[3,19,3,20],[3,21,3,22],[3,24,3,30],[3,31,3,32],[3,33,3,35],[3,36,3,37],[2,21,2,22],[2,24,2,30]]}
["Application Development Style Guide ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev. 10/28/19"]
["TEXT STYLE ",null,null,null,null,null,null,null,null,null,"Colors & Shading ",null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE SETUP",null,null,null,null,null,null,null,null,"MARGINS/FOOTERS"]
["Font",null,null,null,null,null,"Arial",null,"Style",null,"Colors/Shading",null,null,null,null,"Red",null,"Green ",null,"Blue",null,null,null,null,"Columns Used",null,null,null,null,null,null,"A-AL",null,"Left ",null,null,0.5]
["Worksht Title (0,0,255)",null,null,null,null,null,14,null,"Bold",null,"Error or Failed Item ",null,null,null,null,255,null,133,null,133,null,"FADE",null,null,"Column Width",null,null,null,null,null,null,3.43,null,"Right",null,null,0]
["Section",null,null,null,null,null,12,null,"Bold",null,"Input",null,null,null,null,255,null,255,null,204,null,null,null,null,"Row Height ",null,null,null,"1 Line ",null,null,15,null,"Top",null,null,0.5]
["Sub-Sections",null,null,null,null,null,11,null,null,null,"Point Score (Main)",null,null,null,null,204,null,236,null,255,null,null,null,null,"Increments of 15",null,null,null,"2 Lines ",null,null,30,null,"Bottom",null,null,0.3]
["Body",null,null,null,null,null,11,null,null,null,"Point Score (sub cat)",null,null,null,null,229,null,251,null,255,null,null,null,null,null,null,null,null,"3 Lines",null,null,45,null,"Header ",null,null,0]
["Scores",null,null,null,null,null,11,null,"Bold",null,"File Attachment ",null,null,null,null,253,null,233,null,217,null,null,null,null,null,null,null,null,"4+ Lines",null,null,"+15",null,"Footer",null,null,0]
["Instructions",null,null,null,null,null,12,null,"Italic",null,"§Color ",null,null,null,null,191,null,191,null,191,null,null,null,null,"Title Row Height ",null,null,null,null,null,null,18,null,"Left footer",null,"Prgrm Accronym  & Rnd \"MHP R1\""]
["Guideline/ Regulation ",null,null,null,null,null,11,null,"Bold",null,"Dead Space ",null,null,null,null,242,null,242,null,242,null,null,null,null,"§Row Height ",null,null,null,null,null,null,18,null,"Center footer",null,"Page # of Pages"]
[null,null,null,null,null,null,null,null,null,null,"HCD Use Only ",null,null,null,null,225,null,255,null,225,null,null,null,null,"Explanation Box Height ",null,null,null,null,null,null,75,null,"Right footer",null,"worksheet tab/name"]
["Do's & Don'ts -- Application Development Best Practices "]
["Do"]
[">Develop the application in order of the program guidelines or regulations. Only make minor deviations to improve the application flow. "]
[">All references to an attachment goes under the §in which the attachment is needed for substantiation"]
[">Reference other similar programs that are compatible with the most recent Application Development Style Guide and Application Boilerplate"]
[">Each time application is updated, update the revision date in the right hand corner of the application worksheets and log the changes to the Revision Log worksheet (hidden)."]
[]
[]
["Do Not"]
[">Deviate from the most recent Application Development Style Guide "]
[">Use unnecessary rows or columns for aesthetics"]

{"sheet":"Threshold Review","index":4,"n_rows":75,"n_cols":31,"rows_kept":75,"cut":false,"hidden":true,"merged":[[72,0,72,5],[72,6,72,12],[72,13,72,18],[72,19,72,22],[73,0,73,30],[74,0,74,5],[74,6,74,12],[74,13,74,17],[74,18,74,21],[74,22,74,27],[69,0,69,22],[70,0,70,5],[70,6,70,12],[70,13,70,18],[70,19,70,22],[71,0,71,5],[71,6,71,12],[71,13,71,18],[71,19,71,22],[68,0,68,2],[68,3,68,7],[68,8,68,11],[68,12,68,15],[68,16,68,19],[68,20,68,22],[66,20,66,22],[67,0,67,2],[67,3,67,7],[67,8,67,11],[67,12,67,15],[67,16,67,19],[67,20,67,22],[64,16371,64,16378],[65,0,65,22],[65,28,72,28],[65,29,72,29],[65,30,72,30],[66,0,66,2],[66,3,66,7],[66,8,66,11],[66,12,66,15],[66,16,66,19],[64,16233,64,16255],[64,16256,64,16278],[64,16279,64,16301],[64,16302,64,16324],[64,16325,64,16347],[64,16348,64,16370],[64,16095,64,16117],[64,16118,64,16140],[64,16141,64,16163],[64,16164,64,16186],[64,16187,64,16209],[64,16210,64,16232],[64,15957,64,15979],[64,15980,64,16002],[64,16003,64,16025],[64,16026,64,16048],[64,16049,64,16071],[64,16072,64,16094],[64,15819,64,15841],[64,15842,64,15864],[64,15865,64,15887],[64,15888,64,15910],[64,15911,64,15933],[64,15934,64,15956],[64,15681,64,15703],[64,15704,64,15726],[64,15727,64,15749],[64,15750,64,15772],[64,15773,64,15795],[64,15796,64,15818],[64,15543,64,15565],[64,15566,64,15588],[64,15589,64,15611],[64,15612,64,15634],[64,15635,64,15657],[64,15658,64,15680],[64,15405,64,15427],[64,15428,64,15450],[64,15451,64,15473],[64,15474,64,15496],[64,15497,64,15519],[64,15520,64,15542],[64,15267,64,15289],[64,15290,64,15312],[64,15313,64,15335],[64,15336,64,15358],[64,15359,64,15381],[64,15382,64,15404],[64,15129,64,15151],[64,15152,64,15174],[64,15175,64,15197],[64,15198,64,15220],[64,15221,64,15243],[64,15244,64,15266],[64,14991,64,15013],[64,15014,64,15036],[64,15037,64,15059],[64,15060,64,15082],[64,15083,64,15105],[64,15106,64,15128],[64,14853,64,14875],[64,14876,64,14898],[64,14899,64,14921],[64,14922,64,14944],[64,14945,64,14967],[64,14968,64,14990],[64,14715,64,14737],[64,14738,64,14760],[64,14761,64,14783],[64,14784,64,14806],[64,14807,64,14829],[64,14830,64,14852],[64,14577,64,14599],[64,14600,64,14622],[64,14623,64,14645],[64,14646,64,14668],[64,14669,64,14691],[64,14692,64,14714],[64,14439,64,14461],[64,14462,64,14484],[64,14485,64,14507],[64,14508,64,14530],[64,14531,64,14553],[64,14554,64,14576],[64,14301,64,14323],[64,14324,64,14346],[64,14347,64,14369],[64,14370,64,14392],[64,14393,64,14415],[64,14416,64,14438],[64,14163,64,14185],[64,14186,64,14208],[64,14209,64,14231],[64,14232,64,14254],[64,14255,64,14277],[64,14278,64,14300],[64,14025,64,14047],[64,14048,64,14070],[64,14071,64,14093],[64,14094,64,14116],[64,14117,64,14139],[64,14140,64,14162],[64,13887,64,13909],[64,13910,64,13932],[64,13933,64,13955],[64,13956,64,13978],[64,13979,64,14001],[64,14002,64,14024],[64,13749,64,13771],[64,13772,64,13794],[64,13795,64,13817],[64,13818,64,13840],[64,13841,64,13863],[64,13864,64,13886],[64,13611,64,13633],[64,13634,64,13656],[64,13657,64,13679],[64,13680,64,13702],[64,13703,64,13725],[64,13726,64,13748],[64,13473,64,13495],[64,13496,64,13518],[64,13519,64,13541],[64,13542,64,13564],[64,13565,64,13587],[64,13588,64,13610],[64,13335,64,13357],[64,13358,64,13380],[64,13381,64,13403],[64,13404,64,13426],[64,13427,64,13449],[64,13450,64,13472],[64,13197,64,13219],[64,13220,64,13242],[64,13243,64,13265],[64,13266,64,13288],[64,13289,64,13311],[64,13312,64,13334],[64,13059,64,13081],[64,13082,64,13104],[64,13105,64,13127],[64,13128,64,13150],[64,13151,64,13173],[64,13174,64,13196],[64,12921,64,12943],[64,12944,64,12966],[64,12967,64,12989],[64,12990,64,13012],[64,13013,64,13035],[64,13036,64,13058],[64,12783,64,12805],[64,12806,64,12828],[64,12829,64,12851],[64,12852,64,12874],[64,12875,64,12897],[64,12898,64,12920],[64,12645,64,12667],[64,12668,64,12690],[64,12691,64,12713],[64,12714,64,12736],[64,12737,64,12759],[64,12760,64,12782],[64,12507,64,12529],[64,12530,64,12552],[64,12553,64,12575],[64,12576,64,12598],[64,12599,64,12621],[64,12622,64,12644],[64,12369,64,12391],[64,12392,64,12414],[64,12415,64,12437],[64,12438,64,12460],[64,12461,64,12483],[64,12484,64,12506],[64,12231,64,12253],[64,12254,64,12276],[64,12277,64,12299],[64,12300,64,12322],[64,12323,64,12345],[64,12346,64,12368],[64,12093,64,12115],[64,12116,64,12138],[64,12139,64,12161],[64,12162,64,12184],[64,12185,64,12207],[64,12208,64,12230],[64,11955,64,11977],[64,11978,64,12000],[64,12001,64,12023],[64,12024,64,12046],[64,12047,64,12069],[64,12070,64,12092],[64,11817,64,11839],[64,11840,64,11862],[64,11863,64,11885],[64,11886,64,11908],[64,11909,64,11931],[64,11932,64,11954],[64,11679,64,11701],[64,11702,64,11724],[64,11725,64,11747],[64,11748,64,11770],[64,11771,64,11793],[64,11794,64,11816],[64,11541,64,11563],[64,11564,64,11586],[64,11587,64,11609],[64,11610,64,11632],[64,11633,64,11655],[64,11656,64,11678],[64,11403,64,11425],[64,11426,64,11448],[64,11449,64,11471],[64,11472,64,11494],[64,11495,64,11517],[64,11518,64,11540],[64,11265,64,11287],[64,11288,64,11310],[64,11311,64,11333],[64,11334,64,11356],[64,11357,64,11379],[64,11380,64,11402],[64,11127,64,11149],[64,11150,64,11172],[64,11173,64,11195],[64,11196,64,11218],[64,11219,64,11241],[64,11242,64,11264],[64,10989,64,11011],[64,11012,64,11034],[64,11035,64,11057],[64,11058,64,11080],[64,11081,64,11103],[64,11104,64,11126],[64,10851,64,10873],[64,10874,64,10896],[64,10897,64,10919],[64,10920,64,10942],[64,10943,64,10965],[64,10966,64,10988],[64,10713,64,10735],[64,10736,64,10758],[64,10759,64,10781],[64,10782,64,10804],[64,10805,64,10827],[64,10828,64,10850],[64,10575,64,10597],[64,10598,64,10620],[64,10621,64,10643],[64,10644,64,10666],[64,10667,64,10689],[64,10690,64,10712],[64,10437,64,10459],[64,10460,64,10482],[64,10483,64,10505],[64,10506,64,10528],[64,10529,64,10551],[64,10552,64,10574],[64,10299,64,10321],[64,10322,64,10344],[64,10345,64,10367],[64,10368,64,10390],[64,10391,64,10413],[64,10414,64,10436],[64,10161,64,10183],[64,10184,64,10206],[64,10207,64,10229],[64,10230,64,10252],[64,10253,64,10275],[64,10276,64,10298],[64,10023,64,10045],[64,10046,64,10068],[64,10069,64,10091],[64,10092,64,10114],[64,10115,64,10137],[64,10138,64,10160],[64,9885,64,9907],[64,9908,64,9930],[64,9931,64,9953],[64,9954,64,9976],[64,9977,64,9999],[64,10000,64,10022],[64,9747,64,9769],[64,9770,64,9792],[64,9793,64,9815],[64,9816,64,9838],[64,9839,64,9861],[64,9862,64,9884],[64,9609,64,9631],[64,9632,64,9654],[64,9655,64,9677],[64,9678,64,9700],[64,9701,64,9723],[64,9724,64,9746],[64,9471,64,9493],[64,9494,64,9516],[64,9517,64,9539],[64,9540,64,9562],[64,9563,64,9585],[64,9586,64,9608],[64,9333,64,9355],[64,9356,64,9378],[64,9379,64,9401],[64,9402,64,9424],[64,9425,64,9447],[64,9448,64,9470],[64,9195,64,9217],[64,9218,64,9240],[64,9241,64,9263],[64,9264,64,9286],[64,9287,64,9309],[64,9310,64,9332],[64,9057,64,9079],[64,9080,64,9102],[64,9103,64,9125],[64,9126,64,9148],[64,9149,64,9171],[64,9172,64,9194],[64,8919,64,8941],[64,8942,64,8964],[64,8965,64,8987],[64,8988,64,9010],[64,9011,64,9033],[64,9034,64,9056],[64,8781,64,8803],[64,8804,64,8826],[64,8827,64,8849],[64,8850,64,8872],[64,8873,64,8895],[64,8896,64,8918],[64,8643,64,8665],[64,8666,64,8688],[64,8689,64,8711],[64,8712,64,8734],[64,8735,64,8757],[64,8758,64,8780],[64,8505,64,8527],[64,8528,64,8550],[64,8551,64,8573],[64,8574,64,8596],[64,8597,64,8619],[64,8620,64,8642],[64,8367,64,8389],[64,8390,64,8412],[64,8413,64,8435],[64,8436,64,8458],[64,8459,64,8481],[64,8482,64,8504],[64,8229,64,8251],[64,8252,64,8274],[64,8275,64,8297],[64,8298,64,8320],[64,8321,64,8343],[64,8344,64,8366],[64,8091,64,8113],[64,8114,64,8136],[64,8137,64,8159],[64,8160,64,8182],[64,8183,64,8205],[64,8206,64,8228],[64,7953,64,7975],[64,7976,64,7998],[64,7999,64,8021],[64,8022,64,8044],[64,8045,64,8067],[64,8068,64,8090],[64,7815,64,7837],[64,7838,64,7860],[64,7861,64,7883],[64,7884,64,7906],[64,7907,64,7929],[64,7930,64,7952],[64,7677,64,7699],[64,7700,64,7722],[64,7723,64,7745],[64,7746,64,7768],[64,7769,64,7791],[64,7792,64,7814],[64,7539,64,7561],[64,7562,64,7584],[64,7585,64,7607],[64,7608,64,7630],[64,7631,64,7653],[64,7654,64,7676],[64,7401,64,7423],[64,7424,64,7446],[64,7447,64,7469],[64,7470,64,7492],[64,7493,64,7515],[64,7516,64,7538],[64,7263,64,7285],[64,7286,64,7308],[64,7309,64,7331],[64,7332,64,7354],[64,7355,64,7377],[64,7378,64,7400],[64,7125,64,7147],[64,7148,64,7170],[64,7171,64,7193],[64,7194,64,7216],[64,7217,64,7239],[64,7240,64,7262],[64,6987,64,7009],[64,7010,64,7032],[64,7033,64,7055],[64,7056,64,7078],[64,7079,64,7101],[64,7102,64,7124],[64,6849,64,6871],[64,6872,64,6894],[64,6895,64,6917],[64,6918,64,6940],[64,6941,64,6963],[64,6964,64,6986],[64,6711,64,6733],[64,6734,64,6756],[64,6757,64,6779],[64,6780,64,6802],[64,6803,64,6825],[64,6826,64,6848],[64,6573,64,6595],[64,6596,64,6618],[64,6619,64,6641],[64,6642,64,6664],[64,6665,64,6687],[64,6688,64,6710],[64,6435,64,6457],[64,6458,64,6480],[64,6481,64,6503],[64,6504,64,6526],[64,6527,64,6549],[64,6550,64,6572],[64,6297,64,6319],[64,6320,64,6342],[64,6343,64,6365],[64,6366,64,6388],[64,6389,64,6411],[64,6412,64,6434],[64,6159,64,6181],[64,6182,64,6204],[64,6205,64,6227],[64,6228,64,6250],[64,6251,64,6273],[64,6274,64,6296],[64,6021,64,6043],[64,6044,64,6066],[64,6067,64,6089],[64,6090,64,6112],[64,6113,64,6135],[64,6136,64,6158],[64,5883,64,5905],[64,5906,64,5928],[64,5929,64,5951],[64,5952,64,5974],[64,5975,64,5997],[64,5998,64,6020],[64,5745,64,5767],[64,5768,64,5790],[64,5791,64,5813],[64,5814,64,5836],[64,5837,64,5859],[64,5860,64,5882],[64,5607,64,5629],[64,5630,64,5652],[64,5653,64,5675],[64,5676,64,5698],[64,5699,64,5721],[64,5722,64,5744],[64,5469,64,5491],[64,5492,64,5514],[64,5515,64,5537],[64,5538,64,5560],[64,5561,64,5583],[64,5584,64,5606],[64,5331,64,5353],[64,5354,64,5376],[64,5377,64,5399],[64,5400,64,5422],[64,5423,64,5445],[64,5446,64,5468],[64,5193,64,5215],[64,5216,64,5238],[64,5239,64,5261],[64,5262,64,5284],[64,5285,64,5307],[64,5308,64,5330],[64,5055,64,5077],[64,5078,64,5100],[64,5101,64,5123],[64,5124,64,5146],[64,5147,64,5169],[64,5170,64,5192],[64,4917,64,4939],[64,4940,64,4962],[64,4963,64,4985],[64,4986,64,5008],[64,5009,64,5031],[64,5032,64,5054],[64,4779,64,4801],[64,4802,64,4824],[64,4825,64,4847],[64,4848,64,4870],[64,4871,64,4893],[64,4894,64,4916],[64,4641,64,4663],[64,4664,64,4686],[64,4687,64,4709],[64,4710,64,4732],[64,4733,64,4755],[64,4756,64,4778],[64,4503,64,4525],[64,4526,64,4548],[64,4549,64,4571],[64,4572,64,4594],[64,4595,64,4617],[64,4618,64,4640],[64,4365,64,4387],[64,4388,64,4410],[64,4411,64,4433],[64,4434,64,4456],[64,4457,64,4479],[64,4480,64,4502],[64,4227,64,4249],[64,4250,64,4272],[64,4273,64,4295],[64,4296,64,4318],[64,4319,64,4341],[64,4342,64,4364],[64,4089,64,4111],[64,4112,64,4134],[64,4135,64,4157],[64,4158,64,4180],[64,4181,64,4203],[64,4204,64,4226],[64,3951,64,3973],[64,3974,64,3996],[64,3997,64,4019],[64,4020,64,4042],[64,4043,64,4065],[64,4066,64,4088],[64,3813,64,3835],[64,3836,64,3858],[64,3859,64,3881],[64,3882,64,3904],[64,3905,64,3927],[64,3928,64,3950],[64,3675,64,3697],[64,3698,64,3720],[64,3721,64,3743],[64,3744,64,3766],[64,3767,64,3789],[64,3790,64,3812],[64,3537,64,3559],[64,3560,64,3582],[64,3583,64,3605],[64,3606,64,3628],[64,3629,64,3651],[64,3652,64,3674],[64,3399,64,3421],[64,3422,64,3444],[64,3445,64,3467],[64,3468,64,3490],[64,3491,64,3513],[64,3514,64,3536],[64,3261,64,3283],[64,3284,64,3306],[64,3307,64,3329],[64,3330,64,3352],[64,3353,64,3375],[64,3376,64,3398],[64,3123,64,3145],[64,3146,64,3168],[64,3169,64,3191],[64,3192,64,3214],[64,3215,64,3237],[64,3238,64,3260],[64,2985,64,3007],[64,3008,64,3030],[64,3031,64,3053],[64,3054,64,3076],[64,3077,64,3099],[64,3100,64,3122],[64,2847,64,2869],[64,2870,64,2892],[64,2893,64,2915],[64,2916,64,2938],[64,2939,64,2961],[64,2962,64,2984],[64,2709,64,2731],[64,2732,64,2754],[64,2755,64,2777],[64,2778,64,2800],[64,2801,64,2823],[64,2824,64,2846],[64,2571,64,2593],[64,2594,64,2616],[64,2617,64,2639],[64,2640,64,2662],[64,2663,64,2685],[64,2686,64,2708],[64,2433,64,2455],[64,2456,64,2478],[64,2479,64,2501],[64,2502,64,2524],[64,2525,64,2547],[64,2548,64,2570],[64,2295,64,2317],[64,2318,64,2340],[64,2341,64,2363],[64,2364,64,2386],[64,2387,64,2409],[64,2410,64,2432],[64,2157,64,2179],[64,2180,64,2202],[64,2203,64,2225],[64,2226,64,2248],[64,2249,64,2271],[64,2272,64,2294],[64,2019,64,2041],[64,2042,64,2064],[64,2065,64,2087],[64,2088,64,2110],[64,2111,64,2133],[64,2134,64,2156],[64,1881,64,1903],[64,1904,64,1926],[64,1927,64,1949],[64,1950,64,1972],[64,1973,64,1995],[64,1996,64,2018],[64,1743,64,1765],[64,1766,64,1788],[64,1789,64,1811],[64,1812,64,1834],[64,1835,64,1857],[64,1858,64,1880],[64,1605,64,1627],[64,1628,64,1650],[64,1651,64,1673],[64,1674,64,1696],[64,1697,64,1719],[64,1720,64,1742],[64,1467,64,1489],[64,1490,64,1512],[64,1513,64,1535],[64,1536,64,1558],[64,1559,64,1581],[64,1582,64,1604],[64,1329,64,1351],[64,1352,64,1374],[64,1375,64,1397],[64,1398,64,1420],[64,1421,64,1443],[64,1444,64,1466],[64,1191,64,1213],[64,1214,64,1236],[64,1237,64,1259],[64,1260,64,1282],[64,1283,64,1305],[64,1306,64,1328],[64,1053,64,1075],[64,1076,64,1098],[64,1099,64,1121],[64,1122,64,1144],[64,1145,64,1167],[64,1168,64,1190],[64,915,64,937],[64,938,64,960],[64,961,64,983],[64,984,64,1006],[64,1007,64,1029],[64,1030,64,1052],[64,777,64,799],[64,800,64,822],[64,823,64,845],[64,846,64,868],[64,869,64,891],[64,892,64,914],[64,639,64,661],[64,662,64,684],[64,685,64,707],[64,708,64,730],[64,731,64,753],[64,754,64,776],[64,501,64,523],[64,524,64,546],[64,547,64,569],[64,570,64,592],[64,593,64,615],[64,616,64,638],[64,363,64,385],[64,386,64,408],[64,409,64,431],[64,432,64,454],[64,455,64,477],[64,478,64,500],[64,225,64,247],[64,248,64,270],[64,271,64,293],[64,294,64,316],[64,317,64,339],[64,340,64,362],[64,93,64,111],[64,112,64,132],[64,133,64,155],[64,156,64,178],[64,179,64,201],[64,202,64,224],[63,0,63,22],[63,27,63,30],[64,0,64,18],[64,19,64,22],[64,47,64,69],[64,70,64,92],[61,9,61,12],[61,13,61,15],[61,16,61,18],[61,19,62,22],[62,0,62,8],[62,9,62,12],[62,13,62,15],[62,16,62,18],[59,28,62,28],[59,29,62,29],[59,30,62,30],[60,0,60,4],[60,5,60,8],[60,9,60,12],[60,13,60,15],[60,16,60,18],[61,0,61,4],[61,5,61,8],[59,0,59,4],[59,5,59,8],[59,9,59,12],[59,13,59,15],[59,16,59,18],[59,19,60,22],[56,14,56,16],[56,17,56,22],[57,0,57,22],[57,27,57,30],[58,0,58,18],[58,19,58,22],[55,0,55,1],[55,2,55,3],[55,4,55,5],[55,6,55,7],[55,8,55,10],[55,11,55,13],[53,30,56,30],[54,0,54,1],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,10],[54,11,54,13],[54,14,54,15],[54,17,54,18],[54,19,54,20],[53,11,53,13],[53,14,53,15],[53,17,53,18],[53,19,53,20],[53,28,56,28],[53,29,56,29],[55,14,55,15],[55,17,55,18],[55,19,55,20],[56,0,56,13],[51,0,51,13],[51,14,51,16],[51,17,51,22],[52,0,52,22],[52,27,52,30],[53,0,53,1],[53,2,53,3],[53,4,53,5],[53,6,53,7],[53,8,53,10],[50,0,50,3],[50,4,50,7],[50,8,50,13],[50,14,50,16],[50,17,50,20],[50,21,50,22],[49,0,49,3],[49,4,49,7],[49,8,49,13],[49,14,49,16],[49,17,49,20],[49,21,49,22],[38,29,51,29],[44,4,44,7],[44,8,44,13],[44,14,44,16],[44,17,44,20],[44,21,44,22],[43,0,43,3],[43,4,43,7],[43,8,43,13],[43,14,43,16],[43,17,43,20],[43,21,43,22],[48,0,48,3],[48,4,48,7],[48,8,48,13],[48,14,48,16],[48,17,48,20],[48,21,48,22],[47,0,47,3],[47,4,47,7],[47,8,47,13],[47,14,47,16],[47,17,47,20],[47,21,47,22],[46,0,46,3],[46,4,46,7],[46,8,46,13],[46,14,46,16],[46,17,46,20],[46,21,46,22],[42,0,42,3],[42,4,42,7],[42,8,42,13],[42,14,42,16],[42,17,42,20],[42,21,42,22],[40,8,40,13],[40,14,40,16],[40,17,40,20],[40,21,40,22],[41,0,41,3],[41,4,41,7],[41,8,41,13],[41,14,41,16],[41,17,41,20],[41,21,41,22],[38,28,51,28],[39,0,39,3],[39,4,39,7],[39,8,39,13],[39,14,39,16],[39,17,39,20],[39,21,39,22],[40,0,40,3],[40,4,40,7],[45,0,45,3],[45,4,45,7],[45,8,45,13],[45,14,45,16],[45,17,45,20],[45,21,45,22],[44,0,44,3],[36,0,36,13],[36,14,36,16],[36,17,36,22],[37,0,37,22],[37,27,37,30],[38,0,38,3],[38,4,38,7],[38,8,38,13],[38,14,38,16],[38,17,38,22],[35,0,35,3],[35,4,35,7],[35,8,35,13],[35,14,35,16],[35,17,35,20],[35,21,35,22],[34,0,34,3],[34,4,34,7],[34,8,34,13],[34,14,34,16],[34,17,34,20],[34,21,34,22],[23,29,36,29],[29,4,29,7],[29,8,29,13],[29,14,29,16],[29,17,29,20],[29,21,29,22],[28,0,28,3],[28,4,28,7],[28,8,28,13],[28,14,28,16],[28,17,28,20],[28,21,28,22],[33,0,33,3],[33,4,33,7],[33,8,33,13],[33,14,33,16],[33,17,33,20],[33,21,33,22],[32,0,32,3],[32,4,32,7],[32,8,32,13],[32,14,32,16],[32,17,32,20],[32,21,32,22],[31,0,31,3],[31,4,31,7],[31,8,31,13],[31,14,31,16],[31,17,31,20],[31,21,31,22],[27,0,27,3],[27,4,27,7],[27,8,27,13],[27,14,27,16],[27,17,27,20],[27,21,27,22],[25,8,25,13],[25,14,25,16],[25,17,25,20],[25,21,25,22],[26,0,26,3],[26,4,26,7],[26,8,26,13],[26,14,26,16],[26,17,26,20],[26,21,26,22],[23,28,36,28],[24,0,24,3],[24,4,24,7],[24,8,24,13],[24,14,24,16],[24,17,24,20],[24,21,24,22],[25,0,25,3],[25,4,25,7],[30,0,30,3],[30,4,30,7],[30,8,30,13],[30,14,30,16],[30,17,30,20],[30,21,30,22],[29,0,29,3],[21,0,21,20],[21,21,21,22],[22,0,22,20],[22,21,22,22],[22,27,22,30],[23,0,23,3],[23,4,23,7],[23,8,23,13],[23,14,23,16],[23,17,23,22],[17,0,17,20],[17,21,17,22],[17,27,17,30],[18,0,19,20],[20,0,20,20],[20,21,20,22],[20,27,20,30],[14,0,14,20],[14,21,14,22],[15,0,15,20]],"merged_total":1044,"flags":["merged_cut"]}
["Applicant Name:",null,null,{"$f":"'Project and Applicant'!E7","v":0},null,null,null,"Reviewer 1",null,null,null,null,"Date",null,"Threshold Determination",null,{"$f":"AE75","v":"INSTRUCTIONS: \nDelete the text in this box if applicant passes.\nIf \"Pending\" or \"Fail,\" provide a brief description highlighting the reasons for the chosen status."},null,null,null,null,"Reviewer-determined Data \n(feeds directly from Threshold tab, but reviewer will alter based on findings)",null,null,null,null,null,"Document Name (override if different)","Reviewer 1 Determination","Manager Determination","Comments"]
["HTF Name",null,null,{"$f":"'Project and Applicant'!F14","v":0},null,null,null,"Manager Rev.",null,null,null,null,"Date",null,{"$f":"AD75","v":0}]
["Applicant Type:",null,null,null,null,null,{"$f":"'Project and Applicant'!G5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Project and Applicant'!E16","v":"(a) Existing Local Housing Trust Fund (or Existing Regional Housing Trust Fund)"}]
["Amount Requested: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Project and Applicant'!AI17","v":0}]
["(a)(1)(A)  How was the Housing Trust Fund established? \nThe Housing Trust Fund utilizes a public, or joint public and private, fund established by legislation, ordinance, resolution, or a public-private partnership, to receive specific revenue to address local housing needs. \nFrom the dropdown list please select the documentation that establishes the HTF. Please highlight the sections in your documentation that outline the reqirements below. \n          - Language establishing the Local Housing Trust Fund\n          - Identify the specific revenue given to the Local Housing Trust Fund\n          - Identify the language that states the Housing Trust Fund addresses the local housing needs\nREVIEWER: Make sure public RHTFs include Resolutions or Ordinances from each Local government entity that is a member of the RHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V4","v":0},null,null,null,null,null,"HTF"]
["(a)(1)(B)  Does the Housing Trust Fund meet the minimum Ongoing Revenue requirements? \nThe Trust Fund is funded from Ongoing Revenues as required by the definition in §101 from Dedicated Sources of funding such as taxes, fees, loan repayments, or public or private contributions. \nPlease see requirements in Section 101(z). ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V5","v":0},null,null,null,null,null,{"$f":"'Document Checklist.'!C25","v":"Ongoing_Rev_1, Ongoing_Rev_2, etc."}]
["(a)(2) Does the city or county have a Housing Element that was adopted by the city or county’s governing body and determined by HCD to be in compliance with state Housing Element law pursuant to GC §65585?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V6","v":0}]
["(a)(3) The city or county has submitted to HCD the Annual Progress Report required by GC Code §65400 for the current or prior year? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V7","v":0}]
["(b)(1)(A)  How was the charitable nonprofit Housing Trust Fund established? \nThe charitable nonprofit Housing Trust Fund utilizes a public, or joint public and private, fund established by legislation, ordinance, resolution, or a public-private partnership, to receive specific revenue to address local housing needs. \nFrom the dropdown list please select the documentation that establishes the HTF. Please highlight the sections in your documentation that outline the reqirements below. \n          - Language establishing the Local Housing Trust Fund\n          - Identify the specific revenue given to the Local Housing Trust Fund\n          - Identify the language that states the Housing Trust Fund addresses the local housing needs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V8","v":0},null,null,null,null,null,"HTF"]
["(b)(1)(B)  Does the charitable nonprofit Housing Trust Fund meet the minimum Ongoing Revenue requirements? \nThe charitable nonprofit Housing Trust Fund is funded from Ongoing Revenues as required by the definition in §101 from Dedicated Sources of funding such as taxes, fees, loan repayments, or public or private contributions. \nPlease see requirements in Section 101(z). ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V9","v":0},null,null,null,null,null,{"$f":"'Document Checklist.'!C25","v":"Ongoing_Rev_1, Ongoing_Rev_2, etc."}]
["(b)(2) Does the charitable nonprofit organization agree to utilize Program Funds only for Eligible Projects located in cities and counties that have, at the time of application, an adopted Housing Element that the Department has determined, pursuant to Section 65585 of the GC, to be in substantial compliance with the requirements of Article 10.6 (commencing with Section 65580) of Chapter 3 of Division 1 of Title 7 of the GC?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V10","v":0}]
["(b)(3) Does the charitable nonprofit organization agree to utilize Program Funds only for Eligible Projects located in cities and counties that have submitted to the Department the Annual Progress Report required by GC Code 65400 for the current year or prior year?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V11","v":0}]
["(c)(1)(A)  How was the Housing Trust Fund established? \nThe Housing Trust Fund utilizes a public, or joint public and private, fund established by legislation, ordinance, resolution, or a public-private partnership, to receive specific revenue to address local housing needs. \nFrom the dropdown list please select the documentation that establishes the HTF. Please highlight the sections in your documentation that outline the reqirements below. \n          - Language establishing the Local Housing Trust Fund\n          - Identify the specific revenue given to the Local Housing Trust Fund\n          - Identify the language that states the Housing Trust Fund addresses the local housing needs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V12","v":0},null,null,null,null,null,{"$f":"'Document Checklist.'!C11","v":"HTF"}]
["(c)(1)(B)  Does the Housing Trust Fund meet the minimum Ongoing Revenue requirements? \nThe Housing Trust Fund is funded from Ongoing Revenues as required by the definition in §101 from Dedicated Sources of funding such as taxes, fees, loan repayments, or public or private contributions. \nPlease see requirements in Section 101(z). ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V13","v":0},null,null,null,null,null,{"$f":"'Document Checklist.'!C25","v":"Ongoing_Rev_1, Ongoing_Rev_2, etc."}]
["(c)(2) Does the Native American Tribe (or Tribes) agree to utilize Program Funds only for Eligible Projects either (A) located on Native American Lands or (B) located in cities and counties that have, at the time of application, an adopted Housing Element that the Department has determined, pursuant to Section 65585 of the GC, to be in substantial compliance with the requirements of Article 10.6 (commencing with Section 65580) of Chapter 3 of Division 1 of Title 7 of the GC?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V14","v":0}]
["(c)(3) Does the Native American Tribe (or Tribes) agree to utilize Program Funds only for Eligible Projects either (A) located on Native American Lands or (B) in cities and counties that have submitted to the Department the Annual Progress Report required by GC Code 65400 for the current year or prior year?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V15","v":0}]
["(4) A Local Housing Trust Fund or Regional Housing Trust Fund that was created, funded, and operated by a combination of two or more cities or counties, agrees to utilize Program Funds only for Eligible Projects located in cities or counties that have, at the time of application, an adopted Housing Element meeting the requirements of subparagraph (2) above, and for which the Annual Progress Report was submitted for the current or prior year by the application deadline date, as required by subparagraph (3) above? (Should we make applicant enter in their HE compliance date and remove dropdown)? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V16","v":0}]
["102(d): Previous Awardees"]
["VERIFIED dollar amount of Program Funds that have been committed from all previous LHTF awards (leave blank if not previously awarded)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Awarded",{"$f":"Threshold!W18","v":0},{"$f":"W19*0.4","v":0},null,null,null,{"$f":"'Document Checklist.'!C6","v":"Award_Commitment"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Committed",{"$f":"Threshold!W19","v":0},null,null,null,null,{"$f":"'Document Checklist.'!C6","v":"Award_Commitment"}]
["Matching Funds Committed "]
["New Applicants (no previous LHTF award) VERIFIED amount of local Matching Funds that have been committed (leave blank if previously awarded)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!V21","v":0},null,{"$f":"'Project and Applicant'!AI17:AL17*0.4","v":0},0,0,0,{"$f":"'Document Checklist.'!C9","v":"MF_Commitment"}]
["§104 Matching Funds Requirements"]
["Name of Matching Funds",null,null,null," Select Type of\nMatching Fund ",null,null,null,"Specify Source of Funds",null,null,null,null,null,"VERIFIED \nMatching Fund Amount",null,null,"Required Documentation for Matching Funds \nNote (PDI Rep.): Legally binding agreement must be review and approved by LAD."]
["Example-\nPublic Contribution ",null,null,null,"Example-\nResidential Local Impact Fee",null,null,null,"Example- Residential local impact fees",null,null,null,null,null,3000000,null,null,"Match_Fund_1",null,null,null,"Uploaded to HCD?"]
["Example-\nLand Donation",null,null,null,"Example-\nPublic Contribution",null,null,null,"Example-The public contribution will be from foreclosed land.",null,null,null,null,null,5000000,null,null,"Match_Fund_2",null,null,null,"Uploaded to HCD?"]
[{"$f":"Threshold!A26","v":0},null,null,null,{"$f":"Threshold!E26","v":0},null,null,null,{"$f":"Threshold!I26","v":0},null,null,null,null,null,{"$f":"Threshold!O26","v":0},null,null,{"$f":"Threshold!R26","v":0},null,null,null,{"$f":"Threshold!V26","v":0},null,{"$f":"IF(AND(E27<>\"Residential in Lieu Fees\",E27<>\"Residential Local Impact Fees\"),1,0)","v":1},null,null,null,"Match_Fund_1"]
[{"$f":"Threshold!A27","v":0},null,null,null,{"$f":"Threshold!E27","v":0},null,null,null,{"$f":"Threshold!I27","v":0},null,null,null,null,null,{"$f":"Threshold!O27","v":0},null,null,{"$f":"Threshold!R27","v":0},null,null,null,{"$f":"Threshold!V27","v":0},null,{"$f":"IF(AND(E28<>\"Residential in Lieu Fees\",E28<>\"Residential Local Impact Fees\"),1,0)","v":1},null,null,null,"Match_Fund_2"]
[{"$f":"Threshold!A28","v":0},null,null,null,{"$f":"Threshold!E28","v":0},null,null,null,{"$f":"Threshold!I28","v":0},null,null,null,null,null,{"$f":"Threshold!O28","v":0},null,null,{"$f":"Threshold!R28","v":0},null,null,null,{"$f":"Threshold!V28","v":0},null,1,null,null,null,"Match_Fund_3"]
[{"$f":"Threshold!A29","v":0},null,null,null,{"$f":"Threshold!E29","v":0},null,null,null,{"$f":"Threshold!I29","v":0},null,null,null,null,null,{"$f":"Threshold!O29","v":0},null,null,{"$f":"Threshold!R29","v":0},null,null,null,{"$f":"Threshold!V29","v":0},null,1,null,null,null,"Match_Fund_4"]
[{"$f":"Threshold!A30","v":0},null,null,null,{"$f":"Threshold!E30","v":0},null,null,null,{"$f":"Threshold!I30","v":0},null,null,null,null,null,{"$f":"Threshold!O30","v":0},null,null,{"$f":"Threshold!R30","v":0},null,null,null,{"$f":"Threshold!V30","v":0},null,1,null,null,null,"Match_Fund_5"]
[{"$f":"Threshold!A31","v":0},null,null,null,{"$f":"Threshold!E31","v":0},null,null,null,{"$f":"Threshold!I31","v":0},null,null,null,null,null,{"$f":"Threshold!O31","v":0},null,null,{"$f":"Threshold!R31","v":0},null,null,null,{"$f":"Threshold!V31","v":0},null,1,null,null,null,"Match_Fund_6"]
[{"$f":"Threshold!A32","v":0},null,null,null,{"$f":"Threshold!E32","v":0},null,null,null,{"$f":"Threshold!I32","v":0},null,null,null,null,null,{"$f":"Threshold!O32","v":0},null,null,{"$f":"Threshold!R32","v":0},null,null,null,{"$f":"Threshold!V32","v":0},null,1,null,null,null,"Match_Fund_7"]
[{"$f":"Threshold!A33","v":0},null,null,null,{"$f":"Threshold!E33","v":0},null,null,null,{"$f":"Threshold!I33","v":0},null,null,null,null,null,{"$f":"Threshold!O33","v":0},null,null,{"$f":"Threshold!R33","v":0},null,null,null,{"$f":"Threshold!V33","v":0},null,1,null,null,null,"Match_Fund_8"]
[{"$f":"Threshold!A34","v":0},null,null,null,{"$f":"Threshold!E34","v":0},null,null,null,{"$f":"Threshold!I34","v":0},null,null,null,null,null,{"$f":"Threshold!O34","v":0},null,null,{"$f":"Threshold!R34","v":0},null,null,null,{"$f":"Threshold!V34","v":0},null,1,null,null,null,"Match_Fund_9"]
[{"$f":"Threshold!A35","v":0},null,null,null,{"$f":"Threshold!E35","v":0},null,null,null,{"$f":"Threshold!I35","v":0},null,null,null,null,null,{"$f":"Threshold!O35","v":0},null,null,{"$f":"Threshold!R35","v":0},null,null,null,{"$f":"Threshold!V35","v":0},null,1,null,null,null,"Match_Fund_10"]
["Total Matching Funds",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O27:Q36)","v":0}]
["Ongoing Revenue"]
["Name of Ongoing Revenue ",null,null,null," Select Type of Ongoing Revenue ",null,null,null,"Specify Source of Funds",null,null,null,null,null,"VERIFIED \nAnnual average amount deposited into the HTF",null,null,"Required documentation for Ongoing Revenue \nNOTE: Executed documentation only; no drafts",null,null,null,"Uploaded to HCD?"]
["Example:\nLoan Repayments",null,null,null,"Loan Repayments",null,null,null,"Developer Loan",null,null,null,null,null,50000,null,null,"Ongoing_Rev_1",null,null,null,"Promissory Note"]
["Example:\nTaxes",null,null,null,"Taxes",null,null,null,"Residential local impact fees",null,null,null,null,null,40000,null,null,"Ongoing_Rev_2",null,null,null,"Ordinance"]
[{"$f":"Threshold!A41","v":0},null,null,null,{"$f":"Threshold!E41","v":0},null,null,null,{"$f":"Threshold!I41","v":0},null,null,null,null,null,{"$f":"Threshold!O41","v":0},null,null,{"$f":"Threshold!R41","v":0},null,null,null,{"$f":"Threshold!V41","v":0},null,null,null,null,null,"Ongoing_Rev_1"]
[{"$f":"Threshold!A42","v":0},null,null,null,{"$f":"Threshold!E42","v":0},null,null,null,{"$f":"Threshold!I42","v":0},null,null,null,null,null,{"$f":"Threshold!O42","v":0},null,null,{"$f":"Threshold!R42","v":0},null,null,null,{"$f":"Threshold!V42","v":0},null,null,null,null,null,"Ongoing_Rev_2"]
[{"$f":"Threshold!A43","v":0},null,null,null,{"$f":"Threshold!E43","v":0},null,null,null,{"$f":"Threshold!I43","v":0},null,null,null,null,null,{"$f":"Threshold!O43","v":0},null,null,{"$f":"Threshold!R43","v":0},null,null,null,{"$f":"Threshold!V43","v":0},null,null,null,null,null,"Ongoing_Rev_3"]
[{"$f":"Threshold!A44","v":0},null,null,null,{"$f":"Threshold!E44","v":0},null,null,null,{"$f":"Threshold!I44","v":0},null,null,null,null,null,{"$f":"Threshold!O44","v":0},null,null,{"$f":"Threshold!R44","v":0},null,null,null,{"$f":"Threshold!V44","v":0},null,null,null,null,null,"Ongoing_Rev_4"]
[{"$f":"Threshold!A45","v":0},null,null,null,{"$f":"Threshold!E45","v":0},null,null,null,{"$f":"Threshold!I45","v":0},null,null,null,null,null,{"$f":"Threshold!O45","v":0},null,null,{"$f":"Threshold!R45","v":0},null,null,null,{"$f":"Threshold!V45","v":0},null,null,null,null,null,"Ongoing_Rev_5"]
[{"$f":"Threshold!A46","v":0},null,null,null,{"$f":"Threshold!E46","v":0},null,null,null,{"$f":"Threshold!I46","v":0},null,null,null,null,null,{"$f":"Threshold!O46","v":0},null,null,{"$f":"Threshold!R46","v":0},null,null,null,{"$f":"Threshold!V46","v":0},null,null,null,null,null,"Ongoing_Rev_6"]
[{"$f":"Threshold!A47","v":0},null,null,null,{"$f":"Threshold!E47","v":0},null,null,null,{"$f":"Threshold!I47","v":0},null,null,null,null,null,{"$f":"Threshold!O47","v":0},null,null,{"$f":"Threshold!R47","v":0},null,null,null,{"$f":"Threshold!V47","v":0},null,null,null,null,null,"Ongoing_Rev_7"]
[{"$f":"Threshold!A48","v":0},null,null,null,{"$f":"Threshold!E48","v":0},null,null,null,{"$f":"Threshold!I48","v":0},null,null,null,null,null,{"$f":"Threshold!O48","v":0},null,null,{"$f":"Threshold!R48","v":0},null,null,null,{"$f":"Threshold!V48","v":0},null,null,null,null,null,"Ongoing_Rev_8"]
[{"$f":"Threshold!A49","v":0},null,null,null,{"$f":"Threshold!E49","v":0},null,null,null,{"$f":"Threshold!I49","v":0},null,null,null,null,null,{"$f":"Threshold!O49","v":0},null,null,{"$f":"Threshold!R49","v":0},null,null,null,{"$f":"Threshold!V49","v":0},null,null,null,null,null,"Ongoing_Rev_9"]
[{"$f":"Threshold!A50","v":0},null,null,null,{"$f":"Threshold!E50","v":0},null,null,null,{"$f":"Threshold!I50","v":0},null,null,null,null,null,{"$f":"Threshold!O50","v":0},null,null,{"$f":"Threshold!R50","v":0},null,null,null,{"$f":"Threshold!V50","v":0},null,null,null,null,null,"Ongoing_Rev_10"]
["Total Ongoing Revenues",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O42:Q51)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($V$3=\"(b) New Local Housing Trust Fund (NOT a Regional Housing Trust Fund)\",$O$57,IF($V$3=\"(c) New Local Housing Trust Fund (also a Regional Housing Trust Fund)\",$O$57,0))","v":0},{"$f":"IF($V$3=\"(a) Existing Local Housing Trust Fund (also a Regional Housing Trust Fund)\",100000,0)","v":0}]
["New Housing Trust Fund Only : Complete the average annual projected Operating Costs for the five years after Program Award\nNOTE: If using \"Other,\" please delete \"Other: (Describe)\" and provide a brief description."]
["Salaries and Benefits:",null,{"$f":"Threshold!C53","v":0},null,"Insurance: ",null,{"$f":"Threshold!G53","v":0},null,"Utilities ",null,null,{"$f":"Threshold!L53","v":0},null,null,"Phone/Internet",null,{"$f":"Threshold!Q53","v":0},"Marketing",null,{"$f":"Threshold!T53","v":0},null,"Mailing Fees",{"$f":"Threshold!W53","v":0}]
["Recording Fees",null,{"$f":"Threshold!C54","v":0},null,"Supplies",null,{"$f":"Threshold!G54","v":0},null,"Real Property Taxes",null,null,{"$f":"Threshold!L54","v":0},null,null,"Rent",null,{"$f":"Threshold!Q54","v":0},"Property Maintenance",null,{"$f":"Threshold!T54","v":0},null,"Interest on Loans",{"$f":"Threshold!W54","v":0}]
[{"$f":"Threshold!A55","v":"Other: (Describe)"},null,{"$f":"Threshold!C55","v":0},null,{"$f":"Threshold!E55","v":"Other: (Describe)"},null,{"$f":"Threshold!G55","v":0},null,{"$f":"Threshold!I55","v":"Other: (Describe)"},null,null,{"$f":"Threshold!L55","v":0},null,null,{"$f":"Threshold!O55","v":"Other: (Describe)"},null,{"$f":"Threshold!Q55","v":0},{"$f":"Threshold!R55","v":"Other: (Describe)"},null,{"$f":"Threshold!T55","v":0},null,{"$f":"Threshold!V55","v":"Other: (Describe)"},{"$f":"Threshold!W55","v":0}]
["Total Average Operating Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C54,C55,C56,G54,G55,G56,L54,L55,L56,Q54,Q55,Q56,T54,T55,T56,W54,W55,W56)","v":0}]
["§105 Eligible uses of funds"]
["105(a): How will Program Funds be used by the Grantee?\nNote: Please reference the NOFA (II.G.2. Rating and Ranking) for details regarding scoring (LINK NOFA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!T58","v":0}]
["105(a)",null,null,null,null,"105(b)",null,null,null,"105(c)",null,null,null,"105(d)",null,null,"105(e)",null,null,"Total Program Funds accounted for:"]
["What is the simple interest rate for Program Funded Loan(s)",null,null,null,null,"Will Program Funds be used toward administrative expenses? (5% Maximum) ",null,null,null,"Enter percentage of Program Funds designated to serving housholds no higher then 30% Area Median Income ",null,null,null,"Enter percentage of Program Funds designated to serving housholds no higher then 120% Area Median Income ",null,null,"Enter percentage of Program Funds designated to serving housholds no higher then 80% Area Median Income "]
[{"$f":"Threshold!A61","v":0},null,null,null,null,{"$f":"Threshold!F61","v":0},null,null,null,{"$f":"Threshold!J61","v":0},null,null,null,{"$f":"Threshold!N61","v":0},null,null,{"$f":"Threshold!Q61","v":0},null,null,{"$f":"IF(F62=\"Yes\",(J62+N62+Q62+0.05),(J62+N62+Q62))","v":0},null,null,null,null,null,null,null,{"$f":"'Document Checklist.'!C19","v":"App_Reso"}]
["Minimum Amount of Matching Funds",null,null,null,null,null,null,null,null,{"$f":"J62*V4","v":0},null,null,null,{"$f":"N62*V4","v":0},null,null,{"$f":"Q62*V4","v":0}]
["NOFA II.(G)(1)(f) Loan guidelines and underwriting standard and procedures"]
["Applicant has adopted the Uniform Multifamily Regulations (UMRs) as their loan guidelines, underwriting standards, and procedures. \nThe Department's UMRs can be found on our website at  https://hcd.ca.gov/grants-funding/already-have-funding/uniform-multifamily-regulations/docs/uniform-multifamily-regulations-2017.pdf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Threshold!T64","v":0}]
["All ten factors must be addressed in your loan guidelines. Underwriting standards and procedures must be submitted to the department for review. \nPlease complete the fields below by providing where within your guidelines we can verify this information."]
["Debt ratio coverage",null,null,"Minimum projected operating expenses",null,null,null,null,"Replacement reserve \n(enter the amount per unit)",null,null,null,"Capitalized operating reserve (Development funding source at a minimum)",null,null,null,"Positive cash flow",null,null,null,"Projected vacancy rate"]
["An example can be found in §8310(e) Page 19 of UMRs.",null,null,"An example can be found in §8301(k) Page 4 of UMRs, or TCAC limits.",null,null,null,null,"An example can be found in §8309(b)(1)(2) Page 16 of UMRs.",null,null,null,"An example can be found in §8308(b) Page 14 of UMRs.",null,null,null,"An example can be found in §8310(i) Page 20 of UMRs.",null,null,null,"An example can be found in §8310(a)(b) Page 18 of UMRs."]
[{"$f":"Threshold!A68","v":0},null,null,{"$f":"Threshold!D68","v":0},null,null,null,null,{"$f":"Threshold!I68","v":0},null,null,null,{"$f":"Threshold!M68","v":0},null,null,null,{"$f":"Threshold!Q68","v":0},null,null,null,{"$f":"Threshold!U68","v":0},null,null,null,null,null,null,{"$f":"'Document Checklist.'!C20","v":"Guidelines_107d"}]
[]
["Construction Contingency \n(LHTF Construction Financing only)",null,null,null,null,null,"Senior lender and/or junior lender loan requirements",null,null,null,null,null,null,"Interest Rate",null,null,null,null,null,"Leasehold Security Requirements"]
["An example can be found in §8310(j) Page 20 of UMRs.",null,null,null,null,null,"An example can be found in §8310(f) Page 19 or \n§8310(g)(h) Page 20 of UMRs.",null,null,null,null,null,null,"See LTHF Guidelines, Section 105(a)",null,null,null,null,null,"An example can be found in §8316 Page 32 of UMRs."]
[{"$f":"Threshold!A72","v":0},null,null,null,null,null,{"$f":"Threshold!G72","v":0},null,null,null,null,null,null,{"$f":"Threshold!N72","v":0},null,null,null,null,null,{"$f":"Threshold!T72","v":0},null,null,null,null,null,null,null,{"$f":"'Document Checklist.'!C20","v":"Guidelines_107d"}]
[]
["Date Resolution and/or legally binding agreement Sent to LAD for Review:",null,null,null,null,null,null,null,null,null,null,null,null,"LAD Resolution and/or legally binding agreement Determination",null,null,null,null,null,null,null,null,"Final Threshold Determination",null,null,null,null,null,null,null,"INSTRUCTIONS: \nDelete the text in this box if applicant passes.\nIf \"Pending\" or \"Fail,\" provide a brief description highlighting the reasons for the chosen status."]

{"sheet":"Certification & Legal","index":5,"n_rows":33,"n_cols":37,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,0,32,8],[32,10,32,18],[32,20,32,33],[29,0,29,37],[30,0,30,37],[31,0,31,8],[31,10,31,18],[31,20,31,33],[31,35,31,37],[26,0,26,35],[26,36,26,37],[27,0,27,35],[27,36,27,37],[28,0,28,35],[28,36,28,37],[23,0,23,35],[23,36,23,37],[24,0,24,35],[24,36,24,37],[25,0,25,35],[25,36,25,37],[22,0,22,35],[22,36,22,37],[16,0,16,35],[16,36,16,37],[17,0,17,35],[17,36,17,37],[18,0,18,35],[18,36,18,37],[19,0,19,35],[19,36,19,37],[20,0,20,35],[20,36,20,37],[21,0,21,37],[15,0,15,37],[7,0,7,37],[8,0,8,37],[9,0,9,37],[10,0,10,37],[11,0,11,37],[12,0,12,37],[13,0,13,37],[14,0,14,37],[6,34,6,37],[0,0,0,37],[1,0,1,37],[2,0,2,37],[3,14,3,18],[3,0,3,12],[4,14,4,18],[4,0,4,12],[3,20,3,34],[3,36,3,37],[4,20,4,34],[4,36,4,37],[5,0,5,5],[5,6,5,18],[5,19,5,24],[5,25,5,37],[6,0,6,4],[6,5,6,20],[6,22,6,27],[6,28,6,29],[6,30,6,32]]}
["Certification & Legal Status"]
["1. On behalf of the entity identified below, I certify that: The information, statements and attachments included in this application are, to the best of my knowledge and belief, true and correct and I possess the legal authority to submit this application on behalf of the entity identified in the signature block."]
["2. In addition, I acknowledge that all information in this application and attachments is public, and may be disclosed by the State."]
[{"$f":"IFERROR('Project and Applicant'!E9,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Project and Applicant'!L9","v":0}]
["Authorized Representative Printed Name ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["Entity Name:",null,null,null,null,null,{"$f":"'Project and Applicant'!E7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Phone Number:",null,null,null,null,null,{"$f":"'Project and Applicant'!AI9","v":0}]
["Entity Address",null,null,null,null,{"$f":"IFERROR('Project and Applicant'!D8,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",{"$f":"'Project and Applicant'!T8","v":"County:"},null,null,null,null,null,"State",null,{"$f":"'Project and Applicant'!AD8","v":"CA"},null,null,"Zip",{"$f":"'Project and Applicant'!AI8","v":0}]
["Legal Disclosure"]
["For purposes of the following questions, and with the exceptions noted below, the term “applicant” shall include the applicant and joint applicant, and any subsidiary of the applicant or joint applicant if the subsidiary is involved in (for example, as a guarantor) or will be benefited by the application or the project. "]
["In addition to each of these entities themselves, the term “applicant” shall also include the direct and indirect holders of more than ten percent (10%) of the ownership interests in the entity, as well as the officers, directors, principals and senior executives of the entity if the entity is a corporation, the general and limited partners of the entity if the entity is a partnership, and the members or managers of the entity if the entity is a limited liability company. For projects using tax-exempt bonds, it shall also include the individual who will be executing the bond purchase agreement."]
["The following questions must be responded to for each entity and person qualifying as an \"applicant,\" or \"joint applicant\" as defined above.  "]
["Explain all positive responses on a separate sheet and include with this questionnaire in the application."]
["Exceptions:"]
["Exceptions: Public entity applicants without an ownership interest in the proposed project, including but not limited to cities, counties, and joint powers authorities with 100 or more members, are not required to respond to this questionnaire. "]
["Members of the boards of directors of non-profit corporations, including officers of the boards, are also not required to respond. However, chief executive officers (Executive Directors, Chief Executive Officers, Presidents or their equivalent), and chief financial officers (Treasurers, Chief Financial Officers, or their equivalent) must respond."]
["Civil Matters"]
["1. Has the applicant filed a bankruptcy or receivership case or had a bankruptcy or receivership action commenced against it, defaulted on a loan or been foreclosed against in past ten years? "]
["2. Is the applicant currently a party to, or been notified that it may become a party to, any civil litigation that may materially and adversely affect (a) the financial condition of the applicant’s business, or (b) the project that is the subject of the application?"]
["3. Have there been any administrative or civil settlements, decisions, or judgments against the applicant within the past ten years that materially and adversely affected (a) the financial condition of the applicant’s business, or (b) the project that is the subject of the application?"]
["4. Is the applicant currently subject to, or been notified that it may become subject to, any civil or administrative proceeding, examination, or investigation by a local, state or federal licensing or accreditation agency, a local, state or federal taxing authority, or a local, state or federal regulatory or enforcement agency? "]
["5. In the past ten years, has the applicant been subject to any civil or administrative proceeding, examination, or investigation by a local, state or federal licensing or accreditation agency, a local, state or federal taxing authority, or a local, state or federal regulatory or enforcement agency that resulted in a settlement, decision, or judgment? "]
["Criminal Matters"]
["6. Is the applicant currently a party to, or the subject of, or been notified that it may become a party to or the subject of, any criminal litigation, proceeding, charge, complaint, examination or investigation, of any kind, involving, or that could result in, felony charges against the applicant? "]
["7. Is the applicant currently a party to, or the subject of, or been notified that it may become a party to or the subject of, any criminal litigation, proceeding, charge, complaint, examination or investigation, of any kind, involving, or that could result in, misdemeanor charges against the applicant for matters relating to the conduct of the applicant’s business? "]
["8. Is the applicant currently a party to, or the subject of, or been notified that it may become a party to or the subject of, any criminal litigation, proceeding, charge, complaint, examination or investigation, of any kind, involving, or that could result in, criminal charges (whether felony or misdemeanor) against the applicant for any financial or fraud related crime? "]
["9. Is the applicant currently a party to, or the subject of, or been notified that it may become a party to or the subject of, any criminal litigation, proceeding, charge, complaint, examination or investigation, of any kind, that could materially affect the financial condition of the applicant’s business?"]
["10. Within the past ten years, has the applicant been convicted of any felony? "]
["11. Within the past ten years, has the applicant been convicted of any misdemeanor related to the conduct of the applicant’s business?  "]
["12. Within the past ten years, has the applicant been convicted of any misdemeanor for any financial or fraud related crime? "]
["Please provide a letter of explanation if you responded \"Yes\" to any of the questions above."]
[]
[]
["Printed Name",null,null,null,null,null,null,null,null,null,"Title of Signatory",null,null,null,null,null,null,null,null,null,"Signature (Please Type Name)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Drop downs","index":6,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
["(a) Existing Local Housing Trust Fund (or Existing Regional Housing Trust Fund)","Tax",null,"(a) City"]
["(b) New Local Housing Trust Fund (NOT a Regional Housing Trust Fund)","Residential Local Impact Fee",null,"(a) County"]
["(c) New Local Housing Trust Fund (also a Regional Housing Trust Fund)","Residential in Lieu Fee",null,"(a) City and County"]
[null,"Loan Repayment",null,"(b) Charitable nonprofit organization",null,null,null,"Rental new construction"]
["New Local Housing Trust fund","Public Contribution",null,"(c) Native American Tribe or Tribes",null,null,null,"Rental rehab & acquisition"]
["Existing Local Housing Trust Fund","Private Contribution",null,null,null,null,null,"Emergency Shelter new construction"]
[null,"Commercial Fees",null,null,"Letter",null,null,"Emergency Shelter rehab & acq."]
[null,"PLHA funds (RHTF Only)",null,null,"Resolution",null,null,"Transitional Housing new construction"]
["Existing Local Housing Trust Fund",null,null,null,"Agreement",null,null,"Transitional Housing rehab & acq."]
["New Local Housing Trust Fund","Yes",null,null,"Staff Report",null,null,"Perm. Supportive Housing new construction"]
["Regional Housing Trust Fund","No",null,"≤30% AMI","Meeting Minutes",null,null,"Perm. Supportive Housing rehab & acq."]
[null,null,null,"≤60% AMI",null,null,null,"HB Project Construction"]
["Type of Housing Trust Fund","Unincorporated County Only",null,"≤80% AMI",null,null,null,"Owner-Occupied Rehab"]
["In Lieu Fees","Entire County (All Incorp. Cities)",null,"≤120% AMI",null,null,null,"ADU Stand Alone"]
["Non-residential Local Impact Fees",null,null,null,null,null,null,"Homebuyer Assistance"]
["Residential Local Impact Fees","Will be served by this application"]
[null,"Will NOT be served by this application"]
["Type of Housing Trust Fund"]
["Public Housing Trust Fund"]
["Non-profit Housing Trust Fund","Tax"]
["Tribal Housing Trust Fund ","Residential Local Impact Fee",null,"Match_Fund_1","Ongoing_Rev_1",null,null,"Legislation"]
[null,"Residential in Lieu Fee",null,"Match_Fund_2","Ongoing_Rev_2",null,null,"Ordinance"]
[null,"Loan Repayment",null,"Match_Fund_3","Ongoing_Rev_3",null,null,"Resolution"]
["Type of Housing Trust Fund","Public Contribution",null,"Match_Fund_4","Ongoing_Rev_4",null,null,"Public Agreement"]
["Local Public Entity","Private Contribution",null,"Match_Fund_5","Ongoing_Rev_5",null,null,"Private Agreement"]
["Charitable nonprofit organization","Commercial Fees",null,"Match_Fund_6","Ongoing_Rev_6",null,null,"Promissory Note"]
["Native American Tribe","PLHA funds",null,"Match_Fund_7","Ongoing_Rev_7",null,null,"Loan Agreement"]
[null,"HOME funds",null,"Match_Fund_8","Ongoing_Rev_8"]
[null,"CDBG funds",null,"Match_Fund_9","Ongoing_Rev_9"]
[null,null,null,"Match_Fund_10","Ongoing_Rev_10"]
[]
["Funding for permanent financing for 60% AMI or less","Construction"]
["Funding for non-permanent financing for 60% AMI or less ","Permanent"]
[]
[]
["Pass"]
["Pending"]
["Fail"]
["N/A"]

{"sheet":"Application Score","index":7,"n_rows":65,"n_cols":43,"rows_kept":65,"cut":false,"hidden":false,"merged":[[11,27,11,37],[12,27,12,37],[13,27,13,37],[14,27,14,37],[15,27,15,37],[11,19,11,22],[12,19,12,22],[13,19,13,22],[14,19,14,22],[15,19,15,22],[16,15,16,18],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[8,3,8,14],[9,3,9,14],[10,3,10,14],[11,3,11,14],[12,3,12,14],[13,3,13,14],[14,3,14,14],[15,3,15,14],[16,3,16,14],[7,15,7,18],[8,15,8,18],[9,15,9,18],[10,15,10,18],[11,15,11,18],[12,15,12,18],[13,15,13,18],[14,15,14,18],[15,15,15,18],[8,27,8,37],[7,27,7,37],[16,23,16,26],[10,23,10,26],[9,23,9,26],[8,23,8,26],[7,23,7,26],[49,0,49,10],[49,11,49,12],[49,13,49,22],[49,23,49,24],[49,25,49,35],[49,36,49,37],[48,0,48,10],[48,11,48,12],[48,13,48,22],[48,23,48,24],[11,23,11,26],[12,23,12,26],[13,23,13,26],[14,23,14,26],[15,23,15,26],[7,0,7,2],[7,3,7,14],[53,0,53,37],[48,25,48,35],[48,36,48,37],[47,0,47,10],[47,11,47,12],[47,13,47,22],[47,23,47,24],[47,25,47,35],[47,36,47,37],[52,0,52,37],[50,36,50,37],[51,36,51,37],[51,0,51,35],[50,0,50,35],[46,0,46,10],[46,11,46,12],[46,13,46,22],[46,23,46,24],[46,25,46,35],[46,36,46,37],[45,0,45,10],[45,11,45,12],[45,13,45,22],[45,23,45,24],[45,25,45,35],[45,36,45,37],[44,0,44,10],[44,11,44,12],[44,13,44,22],[44,23,44,24],[44,25,44,35],[44,36,44,37],[43,0,43,10],[43,11,43,12],[43,13,43,22],[43,23,43,24],[43,25,43,35],[43,36,43,37],[42,0,42,10],[42,11,42,12],[42,13,42,22],[42,23,42,24],[42,25,42,35],[42,36,42,37],[41,0,41,10],[41,11,41,12],[41,13,41,22],[41,23,41,24],[41,25,41,35],[41,36,41,37],[40,0,40,10],[40,11,40,12],[40,13,40,22],[40,23,40,24],[40,25,40,35],[40,36,40,37],[39,0,39,10],[39,11,39,12],[39,13,39,22],[39,23,39,24],[39,25,39,35],[39,36,39,37],[38,0,38,10],[38,11,38,12],[38,13,38,22],[38,23,38,24],[38,25,38,35],[38,36,38,37],[36,0,36,37],[37,0,37,10],[37,11,37,12],[37,13,37,22],[37,23,37,24],[37,25,37,35],[37,36,37,37],[33,19,33,27],[33,28,33,37],[33,0,33,18],[34,28,34,37],[34,19,34,27],[34,0,34,18],[35,28,35,37],[35,19,35,27],[35,0,35,18],[31,19,31,27],[31,28,31,37],[32,19,32,27],[32,28,32,37],[29,19,29,27],[29,28,29,37],[30,19,30,27],[30,28,30,37],[32,0,32,18],[31,0,31,18],[30,0,30,18],[29,0,29,18],[27,19,27,27],[27,28,27,37],[28,19,28,27],[28,28,28,37],[24,0,24,37],[25,0,25,18],[26,19,26,27],[26,28,26,37],[25,28,25,37],[25,19,25,27],[28,0,28,18],[27,0,27,18],[26,0,26,18],[21,0,21,35],[21,36,21,37],[22,0,22,34],[22,35,22,37],[23,0,23,13],[23,14,23,33],[23,34,23,35],[23,36,23,37],[20,31,20,34],[20,35,20,37],[18,0,18,2],[18,3,18,8],[18,9,18,29],[18,30,18,35],[18,36,18,37],[19,0,19,35],[19,36,19,37],[20,0,20,5],[20,6,20,9],[20,10,20,14],[20,15,20,17],[20,18,20,28],[4,23,4,27],[4,28,4,30],[4,31,4,34],[17,0,17,8],[17,9,17,11],[17,12,17,19],[17,20,17,22],[17,23,17,34],[17,35,17,37],[4,35,4,37],[5,0,5,35],[5,36,5,37],[6,0,6,20],[6,21,6,22],[6,23,6,26],[6,27,6,37],[16,19,16,22],[10,19,10,22],[9,19,9,22],[8,19,8,22],[7,19,7,22],[16,27,16,37],[10,27,10,37],[9,27,9,37],[54,0,54,2],[54,21,54,25],[54,3,54,11],[54,12,54,15],[54,16,54,20],[54,26,54,29],[54,31,54,37],[0,0,0,32],[0,33,0,35],[0,36,0,37],[1,0,1,35],[1,36,1,37],[2,0,2,18],[2,19,2,21],[2,22,2,26],[2,27,2,29],[2,30,2,34],[2,35,2,37],[3,0,3,35],[3,36,3,37],[4,0,4,15],[4,16,4,17],[4,18,4,20],[4,21,4,22],[55,0,55,2],[55,3,55,11],[55,12,55,15],[55,16,55,20],[55,21,55,25],[55,26,55,29],[55,31,55,37],[56,0,56,2],[56,3,56,11],[56,12,56,15],[56,16,56,20],[56,21,56,25],[56,26,56,29],[56,31,56,37],[57,0,57,2],[57,3,57,11],[57,12,57,15],[57,16,57,20],[57,21,57,25],[57,26,57,29],[57,31,57,37],[58,0,58,2],[58,3,58,11],[58,12,58,15],[58,16,58,20],[58,21,58,25],[58,26,58,29],[58,31,58,37],[59,0,59,2],[59,3,59,11],[59,12,59,15],[59,16,59,20],[59,21,59,25],[59,26,59,29],[59,31,59,37],[60,0,60,2],[60,3,60,11],[60,12,60,15],[60,16,60,20],[60,21,60,25],[60,26,60,29],[60,31,60,37],[61,0,61,2],[61,3,61,11],[61,12,61,15],[61,16,61,20],[61,21,61,25],[61,26,61,29],[61,31,61,37],[62,0,62,2],[62,3,62,11],[62,12,62,15],[62,16,62,20],[62,21,62,25],[62,26,62,29],[62,31,62,37],[63,0,63,2],[63,3,63,11],[63,12,63,15],[63,16,63,20],[63,21,63,25],[63,26,63,29],[63,31,63,37],[64,26,64,29],[64,21,64,25]]}
["Application Score - 100 points max §106(f)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Project and Applicant'!AJ1","v":"Rev. 2/2022"},null,null,{"$f":"IF(AK2+AK4+AK6+AK20+AK22+AK24>100,100,AK2+AK4+AK6+AK20+AK22+AK24+AK51+AK52)","v":0}]
["(1) Non-Residential Matching Funds - 15 points max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ3>0.5,15,IF(AJ3>0.25,10,0))","v":0}]
["Matching Funds (sources other than residential Local Impact Fees or In Lieu Fees)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Threshold!X26:X35,\"1\",Threshold!O26:Q35)","v":0},null,null,"Total Matching Funds",null,null,null,null,{"$f":"IF(Threshold!O36>Threshold!V3,Threshold!V3,Threshold!O36)","v":0},null,null,"% of Matching Funds",null,null,null,null,{"$f":"IFERROR(T3/AB3,0)","v":0}]
["(2) Deeper Income Targeting - 20 points max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q5=\"No\",Q5=\"\"),0,IF(V5=\"\",0,IF(V5=0,20,IF(V5<0.06,15,IF(V5<0.11,10,IF(V5<=0.18,5,0))))))","v":0}]
["Does Applicant commit to expend no more than 18% of its Program Funds and Matching Funds on Moderate-Income (MI) households?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If yes, select MI exp. %",null,null,null,null,"Program + Matching Funds - Admin Exp.",null,null,null,null,{"$f":"('Project and Applicant'!AI17+Threshold!O36)-(('Project and Applicant'!AI17+Threshold!O36)*0.05)","v":0},null,null,"Max MI exp. (per commitment)",null,null,null,{"$f":"V5*AC5","v":0}]
["(3) Readiness - 15 points max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM18+AN18","v":0}]
["Has Applicant completed a first phase funding process for multifamily rental projects and announced on its website the status of each project, including those projects that were approved to submit a final application upon award of Program Funds by HCD §106(f)(3)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct link (website address) to page showing project status:"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,null,null,null,null,"Direct link to website"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,null,null,null,null,"Direct link to website"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,null,null,null,null,"Direct link to website"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,null,null,null,null,"Direct link to website"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,null,null,null,null,"Direct link to website"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,null,null,null,null,"Direct link to website"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,null,null,null,null,"Direct link to website"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,null,null,null,null,"Direct link to website"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,null,null,null,null,"Direct link to website"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,null,null,null,null,"Direct link to website"]
["Total Amount of pre-approved \nFirst Phase Funding",null,null,null,null,null,null,null,null,{"$f":"SUM(T8:W17)","v":0},null,null,"Total Program Funds Requested",null,null,null,null,null,null,null,{"$f":"'Project and Applicant'!AI17","v":0},null,null,"First Phase Funding vs. Requested (times)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUNDDOWN(J18/U18,0),0)","v":0},null,null,{"$f":"IF(V7=\"Yes\",5,0)","v":0},{"$f":"IF(AJ18>=3,10,IF(AJ18=2,5,0))","v":0}]
["File Name:",null,null,"Readiness_1, Readiness_2, etc.",null,null,null,null,null,"Provide a list of rental projects that have received a first phase funding approval, and proposed loan amounts.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["(4) Increasing the Supply of Lower-Income (LI) Rental Housing - 20 points max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE21<=50%,\"0\",IF(AE21<=74%,10,IF(AE21<=99%,15,IF(AE21=100%,20,\"0\"))))","v":"0"},null,null,null,null,null,"Will update based on NOFA feedback"]
["How will the Applicant use the HCD Program Funds and Matching Funds - for permanent or construction financing?",null,null,null,null,null,null,null,null,null,"(A) Program Funds + Matching Funds - Admin Exp.",null,null,null,null,{"$f":"('Project and Applicant'!AI17+Threshold!O36)-(('Project and Applicant'!AI17+Threshold!O36)*0.05)","v":0},null,null,"(B) Percentage of Program Funds and Matching Funds Applicant commits to use for new construction of rental housing developments Affordable to and restricted to households with average incomes of no more than 60% of AMI?",null,null,null,null,null,null,null,null,null,null,null,null,"(C) Amount Applicant commits based on (B) %",null,null,null,{"$f":"AE21*P21","v":0}]
["(5) Community Need - 15 points max (NOTE: this section will be scored by HCD using CHAS data (Comprehensive Housing Affordability Strategy): https://www.huduser.gov/portal/datasets/cp.html#2006-2016-datacollapse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ23=\"\",0,IF(AJ23>0.34,15,IF(AJ23>0.15,10,IF(AJ23>=0,5,0))))","v":0},null,null,null,null,null,"Chart needs update"]
["HCD will provide the percentage of Lower-Income Households paying more than 50 percent of their household income for rent or owner expenses. Applicant does not complete this field. "]
["(6) Regional Housing Trust Fund Applicants - 5 points",null,null,null,null,null,null,null,null,null,null,null,null,null,"Does your Regional Housing Trust Fund meet the description and requirements below?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI24=\"Yes\",5,0)","v":0}]
["A Regional Housing Trust Fund meeting the description herein receive all points in this category: A Regional Housing Trust Fund is one that includes six jurisdictions (in counties with total populations of 250,000 or less) or eight jurisdictions (in counties with more than 250,000), or that meets the minimum threshold (two jurisdictions with more than one million people, or three jurisdictions in counties with total populations of 250,000 or less, or four jurisdictions in counties with more than 250,000), and includes more than 66% of the population of the county or counties."]
["List the jurisdictions that your trust fund serves: City of, County of, or Town of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Of those served, which Jurisdictions will be served with this application.",null,null,null,null,null,null,null,null,"Are you serving the unincorporated county only, or the entire county including all incorporated areas?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["List the appropriate representatives from the areas that the Applicant serves."]
["Congressperson Name(s)\n(First and last name)",null,null,null,null,null,null,null,null,null,null,"District #",null,"State Senator Name(s)\n(First and last name)",null,null,null,null,null,null,null,null,null,"District #",null,"State Assembly Member Name(s)\n(First and last name)",null,null,null,null,null,null,null,null,null,null,"District #"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(7) Performance - Applicant has committed at least 40 percent of the Program Funds previously awarded to the Applicant - 10 points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AO$51>0.4,10,0)","v":0},null,{"$f":"Threshold!W18","v":0},{"$f":"Threshold!W19","v":0},{"$f":"IFERROR(AN51/AM51,0)","v":0}]
["     New Applicant (not previously awarded) has committed at least 40 percent of the local Matching Funds - 10 points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AO$52>=0.4,10,0)","v":0},null,{"$f":"Threshold!V3","v":0},{"$f":"Threshold!V21","v":0},{"$f":"IFERROR(AN52/AM52,0)","v":0}]
["Tie Breaker"]
["Tie Breaker, if needed. Readiness: The extent to which the application identifies specific multifamily rental projects for which the trust fund has issued Letters of Intent (LOIs) to developers for construction or permanent financing, (which includes dollar amounts). Explain below."]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,"Funding Source",null,null,null,null,null,null,null,null,"Commitment Amount ",null,null,null,null,null,null,null,null,"Loan Type"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,"Funding Source",null,null,null,null,null,null,null,null,"Commitment Amount ",null,null,null,null,null,null,null,null,"Loan Type"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,"Funding Source",null,null,null,null,null,null,null,null,"Commitment Amount ",null,null,null,null,null,null,null,null,"Loan Type"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,"Funding Source",null,null,null,null,null,null,null,null,"Commitment Amount ",null,null,null,null,null,null,null,null,"Loan Type"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,"Funding Source",null,null,null,null,null,null,null,null,"Commitment Amount ",null,null,null,null,null,null,null,null,"Loan Type"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,"Funding Source",null,null,null,null,null,null,null,null,"Commitment Amount ",null,null,null,null,null,null,null,null,"Loan Type"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,"Funding Source",null,null,null,null,null,null,null,null,"Commitment Amount ",null,null,null,null,null,null,null,null,"Loan Type"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,"Funding Source",null,null,null,null,null,null,null,null,"Commitment Amount ",null,null,null,null,null,null,null,null,"Loan Type"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,"Funding Source",null,null,null,null,null,null,null,null,"Commitment Amount ",null,null,null,null,null,null,null,null,"Loan Type"]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,"Funding Source",null,null,null,null,null,null,null,null,"Commitment Amount ",null,null,null,null,null,null,null,null,"Loan Type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commitment vs. Request",null,null,null,null,{"$f":"IFERROR(((AA55+AA56+AA57+AA58+AA59+AA60+AA61+AA62+AA63+AA64)/AM52),0)","v":0}]

{"sheet":"Score Review","index":8,"n_rows":65,"n_cols":48,"rows_kept":65,"cut":false,"hidden":true,"merged":[[11,27,11,37],[12,27,12,37],[13,27,13,37],[14,27,14,37],[15,27,15,37],[0,33,0,35],[0,36,0,37],[1,36,1,37],[2,0,2,18],[2,19,2,21],[2,22,2,26],[2,27,2,29],[2,30,2,34],[4,35,4,37],[5,36,5,37],[6,0,6,20],[6,21,6,22],[6,23,6,26],[6,27,6,37],[2,35,2,37],[3,36,3,37],[4,0,4,15],[4,16,4,17],[4,18,4,20],[4,21,4,22],[4,23,4,27],[4,28,4,30],[4,31,4,34],[8,0,8,2],[8,3,8,14],[8,15,8,18],[8,19,8,22],[8,23,8,26],[8,27,8,37],[7,0,7,2],[7,3,7,14],[7,15,7,18],[7,19,7,22],[7,23,7,26],[7,27,7,37],[5,0,5,10],[10,0,10,2],[10,3,10,14],[10,15,10,18],[10,19,10,22],[10,23,10,26],[10,27,10,37],[9,0,9,2],[9,3,9,14],[9,15,9,18],[9,19,9,22],[9,23,9,26],[9,27,9,37],[11,0,11,2],[11,3,11,14],[11,15,11,18],[11,19,11,22],[11,23,11,26],[12,0,12,2],[12,3,12,14],[12,15,12,18],[12,19,12,22],[12,23,12,26],[13,0,13,2],[13,3,13,14],[13,15,13,18],[13,19,13,22],[13,23,13,26],[14,0,14,2],[14,3,14,14],[14,15,14,18],[14,19,14,22],[14,23,14,26],[15,0,15,2],[15,3,15,14],[15,15,15,18],[15,19,15,22],[15,23,15,26],[16,0,16,2],[16,3,16,14],[16,15,16,18],[16,19,16,22],[16,23,16,26],[18,36,18,37],[16,27,16,37],[17,0,17,8],[17,9,17,11],[17,12,17,19],[17,20,17,22],[17,23,17,34],[17,35,17,37],[18,0,18,10],[23,0,23,37],[24,0,24,18],[24,19,24,27],[24,28,24,37],[25,0,25,18],[25,19,25,27],[25,28,25,37],[19,35,19,37],[20,36,20,37],[21,0,21,34],[21,35,21,37],[22,14,22,33],[22,34,22,35],[22,36,22,37],[19,0,19,5],[19,6,19,9],[19,10,19,14],[19,15,19,17],[19,18,19,28],[19,31,19,34],[20,0,20,10],[22,0,22,10],[32,0,32,18],[32,19,32,27],[32,28,32,37],[33,0,33,18],[33,19,33,27],[33,28,33,37],[30,0,30,18],[30,19,30,27],[30,28,30,37],[31,0,31,18],[31,19,31,27],[31,28,31,37],[37,0,37,10],[37,11,37,12],[37,13,37,22],[37,23,37,24],[37,25,37,35],[37,36,37,37],[34,0,34,18],[34,19,34,27],[34,28,34,37],[36,0,36,10],[36,11,36,12],[36,13,36,22],[36,23,36,24],[36,25,36,35],[36,36,36,37],[35,0,35,10],[39,0,39,10],[39,11,39,12],[39,13,39,22],[39,23,39,24],[39,25,39,35],[39,36,39,37],[38,0,38,10],[38,11,38,12],[38,13,38,22],[38,23,38,24],[38,25,38,35],[38,36,38,37],[41,0,41,10],[41,11,41,12],[41,13,41,22],[41,23,41,24],[41,25,41,35],[41,36,41,37],[40,0,40,10],[40,11,40,12],[40,13,40,22],[40,23,40,24],[40,25,40,35],[40,36,40,37],[43,0,43,10],[43,11,43,12],[43,13,43,22],[43,23,43,24],[43,25,43,35],[43,36,43,37],[42,0,42,10],[42,11,42,12],[42,13,42,22],[42,23,42,24],[42,25,42,35],[42,36,42,37],[45,0,45,10],[45,11,45,12],[45,13,45,22],[45,23,45,24],[45,25,45,35],[45,36,45,37],[44,0,44,10],[44,11,44,12],[44,13,44,22],[44,23,44,24],[44,25,44,35],[44,36,44,37],[47,0,47,10],[47,11,47,12],[47,13,47,22],[47,23,47,24],[47,25,47,35],[47,36,47,37],[46,0,46,10],[46,11,46,12],[46,13,46,22],[46,23,46,24],[46,25,46,35],[46,36,46,37],[49,36,49,37],[50,36,50,37],[52,0,52,37],[48,0,48,10],[48,11,48,12],[48,13,48,22],[48,23,48,24],[48,25,48,35],[48,36,48,37],[51,0,51,10],[50,0,50,10],[49,0,49,10],[53,31,53,37],[54,0,54,2],[54,3,54,11],[54,12,54,15],[54,16,54,20],[54,21,54,25],[54,26,54,29],[54,31,54,37],[53,0,53,2],[53,3,53,11],[53,12,53,15],[53,16,53,20],[53,21,53,25],[53,26,53,29],[55,31,55,37],[56,0,56,2],[56,3,56,11],[56,12,56,15],[56,16,56,20],[56,21,56,25],[56,26,56,29],[56,31,56,37],[55,0,55,2],[55,3,55,11],[55,12,55,15],[55,16,55,20],[55,21,55,25],[55,26,55,29],[57,31,57,37],[58,0,58,2],[58,3,58,11],[58,12,58,15],[58,16,58,20],[58,21,58,25],[58,26,58,29],[58,31,58,37],[57,0,57,2],[57,3,57,11],[57,12,57,15],[57,16,57,20],[57,21,57,25],[57,26,57,29],[59,31,59,37],[60,0,60,2],[60,3,60,11],[60,12,60,15],[60,16,60,20],[60,21,60,25],[60,26,60,29],[60,31,60,37],[59,0,59,2],[59,3,59,11],[59,12,59,15],[59,16,59,20],[59,21,59,25],[59,26,59,29],[63,21,63,25],[63,26,63,29],[61,31,61,37],[62,0,62,2],[62,3,62,11],[62,12,62,15],[62,16,62,20],[62,21,62,25],[62,26,62,29],[62,31,62,37],[61,0,61,2],[61,3,61,11],[61,12,61,15],[61,16,61,20],[61,21,61,25],[61,26,61,29],[28,0,28,18],[28,19,28,27],[28,28,28,37],[29,0,29,18],[29,19,29,27],[29,28,29,37],[26,0,26,18],[26,19,26,27],[26,28,26,37],[27,0,27,18],[27,19,27,27],[27,28,27,37],[0,0,0,2],[0,44,0,45],[0,47,0,48],[1,44,1,45],[1,47,1,48],[3,44,3,45],[3,47,3,48],[0,15,0,16],[3,0,3,10],[1,0,1,10],[5,44,5,45],[5,47,5,48],[18,44,18,45],[18,47,18,48],[20,44,20,45],[20,47,20,48],[22,44,22,45],[22,47,22,48],[19,44,19,45],[19,47,19,48],[11,44,11,45],[11,47,11,48],[12,44,12,45],[12,47,12,48],[13,44,13,45],[13,47,13,48],[14,44,14,45],[14,47,14,48],[15,44,15,45],[15,47,15,48],[6,44,6,45],[6,47,6,48],[7,44,7,45],[7,47,7,48],[8,44,8,45],[8,47,8,48],[9,44,9,45],[9,47,9,48],[10,44,10,45],[10,47,10,48],[55,44,55,45],[55,47,55,48],[16,44,16,45],[16,47,16,48],[25,44,25,45],[25,47,25,48],[26,44,26,45],[26,47,26,48],[27,44,27,45],[27,47,27,48],[28,44,28,45],[28,47,28,48],[29,44,29,45],[29,47,29,48],[30,44,30,45],[30,47,30,48],[56,44,56,45],[56,47,56,48],[57,44,57,45],[57,47,57,48],[58,44,58,45],[58,47,58,48],[31,44,31,45],[31,47,31,48],[32,44,32,45],[32,47,32,48],[33,44,33,45],[33,47,33,48],[34,44,34,45],[34,47,34,48],[53,44,53,45],[53,47,53,48],[50,44,50,45],[50,47,50,48],[49,44,49,45],[49,47,49,48],[63,44,63,48],[65,47,65,48],[64,47,64,48],[65,44,65,45],[64,44,64,45],[0,25,0,28],[0,22,0,24],[0,3,0,5],[0,6,0,7],[0,8,0,10],[0,12,0,14],[0,17,0,19],[0,20,0,21],[59,44,59,45],[59,47,59,48],[60,44,60,45],[60,47,60,48],[61,44,61,45],[61,47,61,48],[62,44,62,45],[62,47,62,48],[0,31,0,32],[54,44,54,45],[54,47,54,48]]}
["Reviewer 1:",null,null,"Veronika Katayama",null,null,"Date:",null,null,null,null,"Rev. 1 Status",{"$f":"AS66","v":0},null,null,"Manager:",null,"Doniell Cummings",null,null,"Date:",null,null,null,null,"Manager Review Status:",null,null,null,{"$f":"AV66","v":0},"App Self Score Total:",{"$f":"IF((AQ2+AQ4+AQ6+AQ19+AQ21+AQ23+AQ50+AQ51)>100,100,(AQ2+AQ4+AQ6+AQ19+AQ21+AQ23+AQ50+AQ51))","v":0},null,"HCD Score:",null,null,{"$f":"IF((AK2+AK4+AK6+AK19+AK21+AK23+AK50+AK51)>100,100,(AK2+AK4+AK6+AK19+AK21+AK23+AK50+AK51))","v":{"$error":"#VALUE!"}},null,null,null,null,null,"App Self Score",null,"Reviewer Comments",null,null,"Manager Comments"]
["(1) Non-Residential Matching Funds - 15 points max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ3>0.5,15,IF(AJ3>0.25,10,0))","v":0},null,null,null,null,null,{"$f":"'Application Score'!AK2","v":0}]
["Matching Funds (sources other than residential Local Impact Fees or In Lieu Fees)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF('Threshold Review'!X27:X36,\"1\",'Threshold Review'!O27:Q36)","v":0},null,null,"Total Matching Funds",null,null,null,null,{"$f":"IF('Threshold Review'!O37>'Threshold Review'!V4,'Threshold Review'!V4,'Threshold Review'!O37)","v":0},null,null,"% of Matching Funds",null,null,null,null,{"$f":"IFERROR(T3/AB3,0)","v":0}]
["(2) Deeper Income Targeting - 20 points max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q5=\"No\",Q5=0),\"\",IF(V5=\"\",0,IF(V5=0,20,IF(V5<0.06,15,IF(V5<0.11,10,IF(V5<=0.18,5,0))))))","v":""},null,null,null,null,null,{"$f":"'Application Score'!AK4","v":0}]
["Does Applicant commit to expend no more than 18% of its Program Funds and Matching Funds on Moderate-Income (MI) households?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!Q5","v":0},null,"If yes, select MI exp. %",null,null,{"$f":"'Application Score'!V5","v":0},null,"Program + Matching Funds - Admin Exp.",null,null,null,null,{"$f":"('Project and Applicant'!AI17+'Threshold Review'!O37)-(('Project and Applicant'!AI17+'Threshold Review'!O37)*0.05)","v":0},null,null,"Max MI exp. (per commitment)",null,null,null,{"$f":"V5*AC5","v":0}]
["(3) Readiness - 15 points max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM18+AN18","v":0},null,null,null,null,null,{"$f":"'Application Score'!AK6","v":0}]
["Has Applicant completed a first phase funding process for multifamily rental projects and announced on its website the status of each project, including those projects that were approved to submit a final application upon award of Program Funds by HCD §106(f)(3)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!V7","v":0},null,"Direct link (website address) to page showing project status:",null,null,null,{"$f":"'Application Score'!AB7","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D8","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,{"$f":"'Application Score'!T8","v":0},null,null,null,"Direct link to website",null,null,null,{"$f":"'Application Score'!AB8","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D9","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,{"$f":"'Application Score'!T9","v":0},null,null,null,"Direct link to website",null,null,null,{"$f":"'Application Score'!AB9","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D10","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,{"$f":"'Application Score'!T10","v":0},null,null,null,"Direct link to website",null,null,null,{"$f":"'Application Score'!AB10","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D11","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,{"$f":"'Application Score'!T11","v":0},null,null,null,"Direct link to website",null,null,null,{"$f":"'Application Score'!AB11","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D12","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,{"$f":"'Application Score'!T12","v":0},null,null,null,"Direct link to website",null,null,null,{"$f":"'Application Score'!AB12","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D13","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,{"$f":"'Application Score'!T13","v":0},null,null,null,"Direct link to website",null,null,null,{"$f":"'Application Score'!AB13","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D14","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,{"$f":"'Application Score'!T14","v":0},null,null,null,"Direct link to website",null,null,null,{"$f":"'Application Score'!AB14","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D15","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,{"$f":"'Application Score'!T15","v":0},null,null,null,"Direct link to website",null,null,null,{"$f":"'Application Score'!AB15","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D16","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,{"$f":"'Application Score'!T16","v":0},null,null,null,"Direct link to website",null,null,null,{"$f":"'Application Score'!AB16","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D17","v":0},null,null,null,null,null,null,null,null,null,null,null,"Pre-approved Amount",null,null,null,{"$f":"'Application Score'!T17","v":0},null,null,null,"Direct link to website",null,null,null,{"$f":"'Application Score'!AB17","v":0}]
["Total Amount of pre-approved \nFirst Phase Funding",null,null,null,null,null,null,null,null,{"$f":"SUM(T8:W17)","v":0},null,null,"Total Program Funds Requested",null,null,null,null,null,null,null,{"$f":"'Project and Applicant'!AI17","v":0},null,null,"First Phase Funding vs. Requested (times)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUNDDOWN(J18/U18,0),0)","v":0},null,null,{"$f":"IF(V7=\"Yes\",5,0)","v":0},{"$f":"IF(AJ18>=3,10,IF(AJ18=2,5,0))","v":0}]
["(4) Increasing the Supply of Lower-Income (LI) Rental Housing - 20 points max",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE20<=50%,\"0\",IF(AE20<=74%,10,IF(AE20<=99%,15,IF(AE20=100%,20,\"0\"))))","v":"0"},null,null,null,null,null,{"$f":"'Application Score'!AK20","v":"0"}]
["How will the Applicant use the HCD Program Funds and Matching Funds - for permanent or construction financing?",null,null,null,null,null,{"$f":"'Application Score'!G21","v":0},null,null,null,"(A) Program Funds + Matching Funds - Admin Exp.",null,null,null,null,{"$f":"('Project and Applicant'!AI17+'Threshold Review'!O37)-(('Project and Applicant'!AI17+'Threshold Review'!O37)*0.05)","v":0},null,null,"(B) Percentage of Program Funds and Matching Funds Applicant commits to use for new construction of rental housing developments Affordable to and restricted to households with average incomes of no more than 60% of AMI?",null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AD21","v":0},{"$f":"'Application Score'!AE21","v":0},"(C) Amount Applicant commits based on (B) %",null,null,null,{"$f":"AE20*P20","v":0}]
["(5) Community Need - 15 points max ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ22=\"\",0,IF(AJ22>0.34,15,IF(AJ22>0.15,10,IF(AJ22>=0,5,0))))","v":0},null,null,null,null,null,{"$f":"'Application Score'!AK22","v":0}]
["HCD will provide the percentage of Lower-Income Households paying more than 50 percent of their household income for rent or owner expenses. "]
["(6) Regional Housing Trust Fund Applicants - 5 points",null,null,null,null,null,null,null,null,null,null,null,null,null,"Does your Regional Housing Trust Fund meet the description and requirements below?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AI24","v":0},null,{"$f":"IF(AI23=\"Yes\",5,0)","v":0},null,null,null,null,null,{"$f":"'Application Score'!AK24","v":0}]
["A Regional Housing Trust Fund meeting the description herein receive all points in this category: A Regional Housing Trust Fund is one that includes six jurisdictions (in counties with total populations of 250,000 or less) or eight jurisdictions (in counties with more than 250,000), or that meets the minimum threshold (two jurisdictions with more than one million people, or three jurisdictions in counties with total populations of 250,000 or less, or four jurisdictions in counties with more than 250,000), and includes more than 66% of the population of the county or counties."]
["List the jurisdictions that your trust fund serves: City of, County of, or Town of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Of those served, which Jurisdictions will be served with this application.",null,null,null,null,null,null,null,null,"Are you serving the unincorporated county only, or the entire county including all incorporated areas?"]
[{"$f":"'Application Score'!A27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!T27","v":0},null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AC27","v":0}]
[{"$f":"'Application Score'!A28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!T28","v":0},null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AC28","v":0}]
[{"$f":"'Application Score'!A29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!T29","v":0},null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AC29","v":0}]
[{"$f":"'Application Score'!A30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!T30","v":0},null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AC30","v":0}]
[{"$f":"'Application Score'!A31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!T31","v":0},null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AC31","v":0}]
[{"$f":"'Application Score'!A32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!T32","v":0},null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AC32","v":0}]
[{"$f":"'Application Score'!A33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!T33","v":0},null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AC33","v":0}]
[{"$f":"'Application Score'!A34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!T34","v":0},null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AC34","v":0}]
[{"$f":"'Application Score'!A35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!T35","v":0},null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AC35","v":0}]
[{"$f":"'Application Score'!A36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!T36","v":0},null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AC36","v":0}]
["List the appropriate representatives from the areas that the Applicant serves."]
["Congressperson Name(s)\n(First and last name)",null,null,null,null,null,null,null,null,null,null,"District #",null,"State Senator Name(s)\n(First and last name)",null,null,null,null,null,null,null,null,null,"District #",null,"State Assembly Member Name(s)\n(First and last name)",null,null,null,null,null,null,null,null,null,null,"District #"]
[{"$f":"'Application Score'!A39","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L39","v":0},null,{"$f":"'Application Score'!N39","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X39","v":0},null,{"$f":"'Application Score'!Z39","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK39","v":0}]
[{"$f":"'Application Score'!A40","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L40","v":0},null,{"$f":"'Application Score'!N40","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X40","v":0},null,{"$f":"'Application Score'!Z40","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK40","v":0}]
[{"$f":"'Application Score'!A41","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L41","v":0},null,{"$f":"'Application Score'!N41","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X41","v":0},null,{"$f":"'Application Score'!Z41","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK41","v":0}]
[{"$f":"'Application Score'!A42","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L42","v":0},null,{"$f":"'Application Score'!N42","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X42","v":0},null,{"$f":"'Application Score'!Z42","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK42","v":0}]
[{"$f":"'Application Score'!A43","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L43","v":0},null,{"$f":"'Application Score'!N43","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X43","v":0},null,{"$f":"'Application Score'!Z43","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK43","v":0}]
[{"$f":"'Application Score'!A44","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L44","v":0},null,{"$f":"'Application Score'!N44","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X44","v":0},null,{"$f":"'Application Score'!Z44","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK44","v":0}]
[{"$f":"'Application Score'!A45","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L45","v":0},null,{"$f":"'Application Score'!N45","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X45","v":0},null,{"$f":"'Application Score'!Z45","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK45","v":0}]
[{"$f":"'Application Score'!A46","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L46","v":0},null,{"$f":"'Application Score'!N46","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X46","v":0},null,{"$f":"'Application Score'!Z46","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK46","v":0}]
[{"$f":"'Application Score'!A47","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L47","v":0},null,{"$f":"'Application Score'!N47","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X47","v":0},null,{"$f":"'Application Score'!Z47","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK47","v":0}]
[{"$f":"'Application Score'!A48","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L48","v":0},null,{"$f":"'Application Score'!N48","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X48","v":0},null,{"$f":"'Application Score'!Z48","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK48","v":0}]
[{"$f":"'Application Score'!A49","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L49","v":0},null,{"$f":"'Application Score'!N49","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X49","v":0},null,{"$f":"'Application Score'!Z49","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK49","v":0}]
[{"$f":"'Application Score'!A50","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!L50","v":0},null,{"$f":"'Application Score'!N50","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!X50","v":0},null,{"$f":"'Application Score'!Z50","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Score'!AK50","v":0}]
["(7) Performance - Applicant has committed at least 40 percent of the Program Funds previously awarded to the Applicant - 10 points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AO$50>0.4,10,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"'Threshold Review'!W19","v":0},{"$f":"'Threshold Review'!W20","v":0},{"$f":"AN50/AM50","v":{"$error":"#DIV/0!"}},null,{"$f":"'Application Score'!AK51","v":0}]
["New Applicant (not previously awarded) has committed at least 40 percent of the local Matching Funds - 10 points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AO$51>=0.4,10,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"Threshold!V3","v":0},{"$f":"'Threshold Review'!V22","v":0},{"$f":"AN51/AM51","v":{"$error":"#DIV/0!"}},null,{"$f":"'Application Score'!AK52","v":0}]
["Tie Breaker"]
["Tie Breaker, if needed. Readiness: The extent to which the application identifies specific multifamily rental projects for which the trust fund has issued Letters of Intent (LOIs) to developers for construction or permanent financing, (which includes dollar amounts). Explain below."]
["Project Name",null,null,{"$f":"'Application Score'!D55","v":0},null,null,null,null,null,null,null,null,"Funding Source",null,null,null,{"$f":"'Application Score'!Q55","v":0},null,null,null,null,"Commitment Amount ",null,null,null,null,{"$f":"'Application Score'!AA55","v":0},null,null,null,"Loan Type",{"$f":"'Application Score'!AF55","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D56","v":0},null,null,null,null,null,null,null,null,"Funding Source",null,null,null,{"$f":"'Application Score'!Q56","v":0},null,null,null,null,"Commitment Amount ",null,null,null,null,{"$f":"'Application Score'!AA56","v":0},null,null,null,"Loan Type",{"$f":"'Application Score'!AF56","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D57","v":0},null,null,null,null,null,null,null,null,"Funding Source",null,null,null,{"$f":"'Application Score'!Q57","v":0},null,null,null,null,"Commitment Amount ",null,null,null,null,{"$f":"'Application Score'!AA57","v":0},null,null,null,"Loan Type",{"$f":"'Application Score'!AF57","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D58","v":0},null,null,null,null,null,null,null,null,"Funding Source",null,null,null,{"$f":"'Application Score'!Q58","v":0},null,null,null,null,"Commitment Amount ",null,null,null,null,{"$f":"'Application Score'!AA58","v":0},null,null,null,"Loan Type",{"$f":"'Application Score'!AF58","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D59","v":0},null,null,null,null,null,null,null,null,"Funding Source",null,null,null,{"$f":"'Application Score'!Q59","v":0},null,null,null,null,"Commitment Amount ",null,null,null,null,{"$f":"'Application Score'!AA59","v":0},null,null,null,"Loan Type",{"$f":"'Application Score'!AF59","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D60","v":0},null,null,null,null,null,null,null,null,"Funding Source",null,null,null,{"$f":"'Application Score'!Q60","v":0},null,null,null,null,"Commitment Amount ",null,null,null,null,{"$f":"'Application Score'!AA60","v":0},null,null,null,"Loan Type",{"$f":"'Application Score'!AF60","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D61","v":0},null,null,null,null,null,null,null,null,"Funding Source",null,null,null,{"$f":"'Application Score'!Q61","v":0},null,null,null,null,"Commitment Amount ",null,null,null,null,{"$f":"'Application Score'!AA61","v":0},null,null,null,"Loan Type",{"$f":"'Application Score'!AF61","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D62","v":0},null,null,null,null,null,null,null,null,"Funding Source",null,null,null,{"$f":"'Application Score'!Q62","v":0},null,null,null,null,"Commitment Amount ",null,null,null,null,{"$f":"'Application Score'!AA62","v":0},null,null,null,"Loan Type",{"$f":"'Application Score'!AF62","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D63","v":0},null,null,null,null,null,null,null,null,"Funding Source",null,null,null,{"$f":"'Application Score'!Q63","v":0},null,null,null,null,"Commitment Amount ",null,null,null,null,{"$f":"'Application Score'!AA63","v":0},null,null,null,"Loan Type",{"$f":"'Application Score'!AF63","v":0}]
["Project Name",null,null,{"$f":"'Application Score'!D64","v":0},null,null,null,null,null,null,null,null,"Funding Source",null,null,null,{"$f":"'Application Score'!Q64","v":0},null,null,null,null,"Commitment Amount ",null,null,null,null,{"$f":"'Application Score'!AA64","v":0},null,null,null,"Loan Type",{"$f":"'Application Score'!AF64","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commitment vs. Request",null,null,null,null,{"$f":"IFERROR(((AA54+AA55+AA56+AA57+AA58+AA59+AA60+AA61+AA62+AA63)/AM51),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reviewer 1 Score Review Complete?",null,null," Manager Score Review Complete?"]

{"sheet":"Document Checklist.","index":9,"n_rows":30,"n_cols":36,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,0,29,34],[29,35,29,37],[21,0,21,37],[20,0,20,1],[20,2,20,8],[20,9,20,34],[20,35,20,37],[25,0,25,37],[26,0,26,1],[26,2,26,8],[26,9,26,34],[26,35,26,37],[27,0,27,1],[27,2,27,8],[27,9,27,34],[27,35,27,37],[24,0,24,1],[24,2,24,8],[24,9,24,34],[24,35,24,37],[19,0,19,1],[19,2,19,8],[19,9,19,34],[19,35,19,37],[23,0,23,1],[23,2,23,8],[23,9,23,34],[23,35,23,37],[17,0,17,1],[17,2,17,8],[17,9,17,34],[17,35,17,37],[22,0,22,1],[22,2,22,8],[22,9,22,34],[22,35,22,37],[18,0,18,1],[18,2,18,8],[18,9,18,34],[18,35,18,37],[14,0,14,1],[14,2,14,8],[14,9,14,34],[14,35,14,37],[16,0,16,1],[16,2,16,8],[16,9,16,34],[16,35,16,37],[15,0,15,1],[15,2,15,8],[15,9,15,34],[15,35,15,37],[13,0,13,1],[13,2,13,8],[13,9,13,34],[13,35,13,37],[11,0,11,1],[11,2,11,8],[11,9,11,34],[11,35,11,37],[12,0,12,1],[12,2,12,8],[12,9,12,34],[12,35,12,37],[6,0,6,1],[6,2,6,8],[6,9,6,34],[6,35,6,37],[8,0,8,1],[8,2,8,8],[8,9,8,34],[8,35,8,37],[7,0,7,37],[9,0,9,37],[10,0,10,1],[10,2,10,8],[10,9,10,34],[10,35,10,37],[4,0,4,37],[5,0,5,1],[5,2,5,8],[5,9,5,34],[5,35,5,37],[0,0,0,37],[1,0,1,37],[3,0,3,1],[3,2,3,8],[3,9,3,34],[3,35,3,37]]}
["LOCAL HOUSING TRUST FUND (LHTF) Document Checklist"]
["Use this document to properly name your attachments before uploading them with your application submission. \nYou must confirm below that you have completed this step. "]
[]
["Threshold Requirement?",null,"What You'll Name Your Document:",null,null,null,null,null,null,"Document Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Included?"]
["§102(d) Eligible Applicants: Previous Awardees"]
["Yes","X","Award_Commitment",null,null,null,null,null,null,"Previously awarded applicants only. Documentation evidencing the commitment of at least 40% of the previously awarded LHTF funds."]
["Yes",null,"LHTF_AR",null,null,null,null,null,null,"Previously awarded applicants only. §106(e) Submit evidence that the most recently required LHTF Annual Report was submitted to HCD State Grants Management (e.g. include a copy of the email submission)"]
["New Applicants (no previous LHTF award)"]
["No",null,"MF_Commitment",null,null,null,null,null,null,"New Applicants only. Documentation evidencing the commitment of at least 40% of the local Matching Funds."]
["Application Information"]
["Yes",null,"HTF",null,null,null,null,null,null,"§102(a),(b),(c): Legislation, Ordinance, Resolution, or public-private partnership agreement creating the HTF. \nRHTF must include Resolution or Ordinance from each Local government entity that is a member of the RHTF (public RHTFs only)."]
["Yes ",null,"OrgDoc1, OrgDoc2, etc.",null,null,null,null,null,null,"§106(e) Organizational Documents (Articles of Incorporation, Bylaws, Amendments, Certificate of Good Standing, etc.)"]
["Yes ",null,"Org_Chart",null,null,null,null,null,null,"§106(e) Organizational Chart"]
["Yes \n(if applicable)",null,"Gov_TIN_Form",null,null,null,null,null,null,"§106(e) Government Agency Taxpayer ID Form"]
["Yes \n(if applicable)",null,"STD_204",null,null,null,null,null,null,"§106(e) STD-204 Payee Data Record"]
["Yes \n(if applicable)",null,"Sig_Block",null,null,null,null,null,null,"501(c)(3) nonprofit corporation only §106(e) - Signature Block, upload as a Microsoft Word document"]
["Yes \n(if applicable)",null,"Fin_Statements",null,null,null,null,null,null,"501(c)(3) nonprofit corporation only §106(e) - Audited financial statements (2 years)"]
["Yes \n(if applicable)",null,"501c3_Determination",null,null,null,null,null,null,"501(c)(3) nonprofit corporation only §106(e)  - IRS determination letter regarding 501(c)(3) status \n(this letter must address the name of the 501(c)(3), which must match the name of the HTF)"]
["Yes",null,"App_Reso",null,null,null,null,null,null,"§106(e) Application Resolution  Note: Only one Application Resolution may be submitted and must be from the Applicant. Additionally, Attachment 1 must be an attachment to the Resolution prior to approval by the governing body and must be included with your submission."]
["Yes",null,"Guidelines_107d",null,null,null,null,null,null,"§107(d) Loan guidelines and underwriting standards and procedures"]
["Yes \n(if applicable)",null,"Cert_LOE",null,null,null,null,null,null,"Letter of Explanation for any applicable items on \"Certification & Legal\" tab of the application"]
["Matching Funds and Ongoing Revenue"]
["Yes",null,"Match_Fund_1, Match_Fund_2, etc. ",null,null,null,null,null,null,"§104 Required Documentation for Matching Funds"]
["Yes \n(if applicable)",null,"Binding_Agreement",null,null,null,null,null,null,"§104(b) Fully executed commitment letter or a fully executed contract to provide Matching Funds, specifying the source(s) of the Matching Funds, the amount of Matching Funds from each source, the date upon which the funds will be deposited into the LHTF or RHTF account, and remedies for not depositing the Matching Funds on/by that date. "]
["Yes",null,"Ongoing_Rev_1, Ongoing_Rev_2, etc.",null,null,null,null,null,null,"§102(a),(b),(c) Required Documentation for Ongoing Revenues"]
["§106 Application Scoring"]
["No",null,"Readiness_1, Readiness_2, etc.",null,null,null,null,null,null,"§106(f)(3) Readiness List"]
["No",null,"LOI_1, LOI_2, etc.",null,null,null,null,null,null,"§106(g)(1) Letter(s) of Intent"]
[]
[" I have reviewed the Document Checklist and have named my documents according to the instructions. \nI will upload all required documents to the LHTF submission portal."]

{"sheet":"Application Support","index":10,"n_rows":31,"n_cols":42,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,29,30,31],[30,32,30,34],[30,35,30,37],[30,0,30,1],[30,2,30,4],[30,5,30,8],[30,9,30,14],[30,15,30,16],[30,17,30,28],[29,0,29,1],[29,2,29,4],[29,5,29,8],[29,9,29,14],[29,15,29,16],[29,17,29,28],[29,29,29,31],[29,32,29,34],[29,35,29,37],[28,0,28,1],[28,2,28,4],[28,5,28,8],[28,9,28,14],[28,15,28,16],[28,17,28,28],[28,29,28,31],[28,32,28,34],[28,35,28,37],[26,29,26,31],[26,32,26,34],[26,35,26,37],[27,0,27,1],[27,2,27,4],[27,5,27,8],[27,9,27,14],[27,15,27,16],[27,17,27,28],[27,29,27,31],[26,0,26,1],[26,2,26,4],[26,5,26,8],[26,9,26,14],[26,15,26,16],[26,17,26,28],[27,32,27,34],[27,35,27,37],[25,0,25,1],[25,2,25,4],[25,5,25,8],[25,9,25,14],[25,15,25,16],[25,17,25,28],[25,29,25,31],[25,32,25,34],[25,35,25,37],[24,0,24,1],[24,2,24,4],[24,5,24,8],[24,9,24,14],[24,15,24,16],[24,17,24,28],[24,29,24,31],[24,32,24,34],[24,35,24,37],[22,29,22,31],[22,32,22,34],[22,35,22,37],[23,0,23,1],[23,2,23,4],[23,5,23,8],[23,9,23,14],[23,15,23,16],[23,17,23,28],[23,29,23,31],[22,0,22,1],[22,2,22,4],[22,5,22,8],[22,9,22,14],[22,15,22,16],[22,17,22,28],[23,32,23,34],[23,35,23,37],[21,0,21,1],[21,2,21,4],[21,5,21,8],[21,9,21,14],[21,15,21,16],[21,17,21,28],[21,29,21,31],[21,32,21,34],[21,35,21,37],[20,0,20,1],[20,2,20,4],[20,5,20,8],[20,9,20,14],[20,15,20,16],[20,17,20,28],[20,29,20,31],[20,32,20,34],[20,35,20,37],[18,29,18,31],[18,32,18,34],[18,35,18,37],[19,0,19,1],[19,2,19,4],[19,5,19,8],[19,9,19,14],[19,15,19,16],[19,17,19,28],[19,29,19,31],[18,0,18,1],[18,2,18,4],[18,5,18,8],[18,9,18,14],[18,15,18,16],[18,17,18,28],[19,32,19,34],[19,35,19,37],[17,0,17,1],[17,2,17,4],[17,5,17,8],[17,9,17,14],[17,15,17,16],[17,17,17,28],[17,29,17,31],[17,32,17,34],[17,35,17,37],[16,0,16,1],[16,2,16,4],[16,5,16,8],[16,9,16,14],[16,15,16,16],[16,17,16,28],[16,29,16,31],[16,32,16,34],[16,35,16,37],[14,29,14,31],[14,32,14,34],[14,35,14,37],[15,0,15,1],[15,2,15,4],[15,5,15,8],[15,9,15,14],[15,15,15,16],[15,17,15,28],[15,29,15,31],[14,0,14,1],[14,2,14,4],[14,5,14,8],[14,9,14,14],[14,15,14,16],[14,17,14,28],[15,32,15,34],[15,35,15,37],[13,0,13,1],[13,2,13,4],[13,5,13,8],[13,9,13,14],[13,15,13,16],[13,17,13,28],[13,29,13,31],[13,32,13,34],[13,35,13,37],[12,0,12,1],[12,2,12,4],[12,5,12,8],[12,9,12,14],[12,15,12,16],[12,17,12,28],[12,29,12,31],[12,32,12,34],[12,35,12,37],[10,29,10,31],[10,32,10,34],[10,35,10,37],[11,0,11,1],[11,2,11,4],[11,5,11,8],[11,9,11,14],[11,15,11,16],[11,17,11,28],[11,29,11,31],[10,0,10,1],[10,2,10,4],[10,5,10,8],[10,9,10,14],[10,15,10,16],[10,17,10,28],[11,32,11,34],[11,35,11,37],[9,0,9,1],[9,2,9,4],[9,5,9,8],[9,9,9,14],[9,15,9,16],[9,17,9,28],[9,29,9,31],[9,32,9,34],[9,35,9,37],[8,0,8,1],[8,2,8,4],[8,5,8,8],[8,9,8,14],[8,15,8,16],[8,17,8,28],[8,29,8,31],[8,32,8,34],[8,35,8,37],[6,29,6,31],[6,32,6,34],[6,35,6,37],[7,0,7,1],[7,2,7,4],[7,5,7,8],[7,9,7,14],[7,15,7,16],[7,17,7,28],[7,29,7,31],[6,0,6,1],[6,2,6,4],[6,5,6,8],[6,9,6,14],[6,15,6,16],[6,17,6,28],[7,32,7,34],[7,35,7,37],[4,0,4,37],[5,0,5,1],[5,2,5,4],[5,5,5,8],[5,9,5,14],[5,15,5,16],[5,17,5,28],[5,29,5,31],[5,32,5,34],[5,35,5,37],[0,35,0,37],[0,0,0,34],[3,0,3,3],[3,4,3,14],[3,15,3,16],[3,17,3,27],[3,28,3,31],[3,32,3,37],[1,0,1,37],[2,0,2,2],[2,3,2,21],[2,22,2,25],[2,26,2,29],[2,30,2,33],[2,34,2,37]]}
["Application Development Team (ADT) Support Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'LHTF Coverpage'!A4","v":"Rev. 2/2022"}]
["Please complete the \"yellow\" cells in the form below and email a copy to: LHTF@hcd.ca.gov and to AppSupport@hcd.ca.gov. \nA member of the LHTF Team will respond to your request ASAP. "]
["Full Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Requested:",null,null,null,null,null,null,null,"Application Version Date:"]
["Organization:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:",null,null,null,null,null,null,null,null,null,null,null,null,"Contact Phone:"]
["Justification:"]
["Issue #",null,"Program Name",null,null,"Tab",null,null,null,"Section",null,null,null,null,null,"Cell#",null,"Update/Comment",null,null,null,null,null,null,null,null,null,null,null,"Urgency ",null,null,"ADT Status",null,null,"Status Date",null,null,"Requestor","Email","Phone","App Version"]
[1,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7=\"\",\"\",$D$3)","v":0},{"$f":"IF(C7=\"\",\"\",$R$4)","v":0},{"$f":"IF(C7=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C7=\"\",\"\",$AI$3)","v":"00:00:00"}]
[2,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(C8=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C8=\"\",\"\",$AI$3)","v":"00:00:00"}]
[3,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(C9=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C9=\"\",\"\",$AI$3)","v":"00:00:00"}]
[4,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(C10=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C10=\"\",\"\",$AI$3)","v":"00:00:00"}]
[5,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(C11=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C11=\"\",\"\",$AI$3)","v":"00:00:00"}]
[6,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[7,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[8,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[9,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[10,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[11,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[12,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[13,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[14,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[15,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[16,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[17,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[18,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[19,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[20,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[21,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[22,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[23,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[24,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]
[25,null,"LHTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"00:00:00"]