{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["LHTF Coverpage","Style Guide","Project and Applicant","Certification & Legal","Application Score","Drop downs","Checklist","Application Support"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":595,"comments":4,"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":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,0,23,22],[19,0,19,22],[20,0,20,22],[21,0,21,22],[24,0,24,22],[5,0,5,22],[0,0,0,24],[1,0,1,22],[2,0,2,22],[4,0,4,22],[6,0,6,22],[7,0,7,22],[10,0,10,22],[11,0,11,22],[22,0,22,22],[14,0,14,22],[15,0,15,22],[18,0,18,22]]}
[]
["Local Housing Trust Fund (LHTF) Program"]
["Application"]
[]
["2020 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 "]
["Phone: (916) 263-2771"]
["Website: http://www.hcd.ca.gov/grants-funding/active-funding/lhtf.shtml"]
["Program Email: LHTF@hcd.ca.gov "]
[]
["NOFA Release: April 30, 2020"]
["Rev. 5/13/20"]

{"sheet":"Style Guide","index":1,"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":"Project and Applicant","index":2,"n_rows":156,"n_cols":42,"rows_kept":156,"cut":false,"hidden":false,"merged":[[154,35,154,37],[155,0,155,4],[155,5,155,34],[155,35,155,37],[156,0,156,4],[156,5,156,34],[156,35,156,37],[152,35,152,37],[153,35,153,37],[152,0,152,4],[153,0,153,4],[152,5,152,34],[153,5,153,34],[154,0,154,4],[154,5,154,34],[49,11,49,29],[91,0,91,10],[114,0,114,10],[115,0,115,10],[92,0,92,10],[93,0,93,10],[94,0,94,10],[95,0,95,10],[54,0,54,3],[54,4,54,37],[53,31,53,34],[53,35,53,37],[50,0,50,2],[50,3,50,10],[51,30,51,35],[51,36,51,37],[51,0,51,2],[51,3,51,10],[98,30,98,35],[98,36,98,37],[99,30,99,35],[99,36,99,37],[97,30,97,35],[114,11,114,17],[114,18,114,20],[115,11,115,17],[119,0,119,26],[119,27,119,34],[120,32,120,37],[121,32,121,37],[122,32,122,37],[51,11,51,29],[104,30,104,35],[103,30,103,35],[115,21,115,23],[114,21,114,23],[111,21,111,23],[108,30,108,35],[110,30,110,35],[103,36,103,37],[106,30,106,35],[101,36,101,37],[101,30,101,35],[102,30,102,35],[116,24,116,29],[117,30,117,35],[105,24,105,29],[104,24,104,29],[102,24,102,29],[103,24,103,29],[105,30,105,35],[115,24,115,29],[117,36,117,37],[114,24,114,29],[114,30,114,35],[107,24,107,29],[114,36,114,37],[105,36,105,37],[104,36,104,37],[107,36,107,37],[110,36,110,37],[109,30,109,35],[106,36,106,37],[107,30,107,35],[109,36,109,37],[116,30,116,35],[116,36,116,37],[23,36,23,37],[27,11,27,16],[28,0,28,2],[28,3,28,16],[46,30,46,35],[44,0,44,2],[46,36,46,37],[33,11,33,29],[32,11,32,29],[41,1,41,37],[42,1,42,37],[43,1,43,37],[32,0,32,2],[32,36,32,37],[32,3,32,10],[32,30,32,35],[33,36,33,37],[46,0,46,2],[31,11,31,29],[31,30,31,35],[31,36,31,37],[31,0,31,2],[31,3,31,10],[29,29,29,32],[4,0,4,5],[4,6,4,37],[102,36,102,37],[5,0,5,37],[7,0,7,35],[7,36,7,37],[8,0,8,35],[8,36,8,37],[13,0,13,35],[13,36,13,37],[9,0,9,35],[9,36,9,37],[10,0,10,35],[10,36,10,37],[11,0,11,35],[11,36,11,37],[12,0,12,37],[14,0,14,35],[14,36,14,37],[55,0,55,22],[55,34,55,37],[22,0,22,35],[22,36,22,37],[97,36,97,37],[2,0,2,37],[88,0,88,37],[113,21,113,23],[113,24,113,29],[113,30,113,35],[113,36,113,37],[15,0,15,35],[15,36,15,37],[16,0,16,35],[16,36,16,37],[17,0,17,35],[17,36,17,37],[18,0,18,37],[19,0,19,35],[19,36,19,37],[20,0,20,35],[20,36,20,37],[111,36,111,37],[112,21,112,23],[112,24,112,29],[112,30,112,35],[112,36,112,37],[111,30,111,35],[108,36,108,37],[49,0,49,2],[48,30,48,35],[44,36,44,37],[45,0,45,37],[47,30,47,35],[25,30,25,37],[25,4,25,24],[28,27,28,28],[28,29,28,30],[28,31,28,33],[49,3,49,10],[26,0,26,2],[44,3,44,10],[34,1,34,37],[35,1,35,37],[36,1,36,37],[37,1,37,37],[38,1,38,37],[39,1,39,37],[40,1,40,37],[44,11,44,29],[47,3,47,10],[33,30,33,35],[30,31,30,33],[55,23,55,33],[89,35,89,37],[89,28,89,34],[87,0,87,37],[92,30,92,35],[92,36,92,37],[71,36,71,37],[71,30,71,35],[72,30,72,35],[91,21,91,37],[73,36,73,37],[74,30,74,35],[74,36,74,37],[75,36,75,37],[73,30,73,35],[80,30,80,35],[79,30,79,35],[79,36,79,37],[79,21,79,23],[80,21,80,23],[83,18,83,20],[76,36,76,37],[77,30,77,35],[77,36,77,37],[94,24,94,29],[95,24,95,29],[94,30,94,35],[76,30,76,35],[99,24,99,29],[100,24,100,29],[106,24,106,29],[96,0,96,10],[63,0,63,37],[90,0,90,37],[79,0,79,10],[80,0,80,10],[82,21,82,23],[81,36,81,37],[82,30,82,35],[82,36,82,37],[84,18,84,20],[81,0,81,10],[84,0,84,10],[83,30,83,35],[82,24,82,29],[75,30,75,35],[83,11,83,17],[72,36,72,37],[48,3,48,10],[30,29,30,30],[144,9,144,12],[144,13,144,23],[144,24,144,27],[144,28,144,33],[144,34,144,37],[47,36,47,37],[48,36,48,37],[49,36,49,37],[44,30,44,35],[49,30,49,35],[100,30,100,35],[100,36,100,37],[95,36,95,37],[96,30,96,35],[96,36,96,37],[95,21,95,23],[50,11,50,29],[50,30,50,35],[50,36,50,37],[97,24,97,29],[98,24,98,29],[105,21,105,23],[146,9,146,12],[146,13,146,23],[150,3,150,8],[150,9,150,29],[147,0,147,37],[150,0,150,2],[150,30,150,35],[150,36,150,37],[148,0,148,37],[149,0,149,37],[146,24,146,27],[146,28,146,33],[146,34,146,37],[137,0,137,37],[141,36,141,37],[143,36,143,37],[145,36,145,37],[140,13,140,23],[140,34,140,37],[140,0,140,8],[140,28,140,33],[141,0,141,35],[143,0,143,35],[145,0,145,35],[140,9,140,12],[140,24,140,27],[142,0,142,8],[142,9,142,12],[142,13,142,23],[142,24,142,27],[151,0,151,37],[146,0,146,8],[94,36,94,37],[95,30,95,35],[93,30,93,35],[93,36,93,37],[83,36,83,37],[80,36,80,37],[81,30,81,35],[86,0,86,37],[91,11,91,17],[91,18,91,20],[92,11,92,17],[82,0,82,10],[83,0,83,10],[85,0,85,37],[81,24,81,29],[84,24,84,29],[83,24,83,29],[84,21,84,23],[83,21,83,23],[84,30,84,35],[84,36,84,37],[81,21,81,23],[78,30,78,35],[78,36,78,37],[72,0,72,10],[73,0,73,10],[74,0,74,10],[77,24,77,29],[77,21,77,23],[78,21,78,23],[73,21,73,23],[74,21,74,23],[74,24,74,29],[73,18,73,20],[74,18,74,20],[75,18,75,20],[76,18,76,20],[77,18,77,20],[78,18,78,20],[75,24,75,29],[75,21,75,23],[76,21,76,23],[76,24,76,29],[78,24,78,29],[76,0,76,10],[77,0,77,10],[78,0,78,10],[56,0,56,37],[53,0,53,4],[53,5,53,30],[52,0,52,37],[75,0,75,10],[69,36,69,37],[65,30,65,35],[70,30,70,35],[66,30,66,35],[66,36,66,37],[67,30,67,35],[67,36,67,37],[68,30,68,35],[68,36,68,37],[70,36,70,37],[69,30,69,35],[67,24,67,29],[68,24,68,29],[69,24,69,29],[70,24,70,29],[71,24,71,29],[65,21,65,23],[70,0,70,10],[71,0,71,10],[47,0,47,2],[48,0,48,2],[69,0,69,10],[26,34,26,37],[57,0,57,35],[57,36,57,37],[58,0,58,35],[58,36,58,37],[64,0,64,10],[65,0,65,10],[66,0,66,10],[67,0,67,10],[68,0,68,10],[65,24,65,29],[48,11,48,29],[47,11,47,29],[46,11,46,29],[29,17,29,20],[29,21,29,28],[26,17,26,18],[29,9,29,10],[29,11,29,16],[46,3,46,10],[68,21,68,23],[69,21,69,23],[70,21,70,23],[71,21,71,23],[66,24,66,29],[66,21,66,23],[67,21,67,23],[72,24,72,29],[73,24,73,29],[72,21,72,23],[115,18,115,20],[116,11,116,17],[142,28,142,33],[142,34,142,37],[144,0,144,8],[115,30,115,35],[115,36,115,37],[117,11,117,17],[117,18,117,20],[138,0,138,35],[139,0,139,35],[139,36,139,37],[118,18,118,20],[116,18,116,20],[118,0,118,10],[123,32,123,37],[129,32,129,37],[130,32,130,37],[128,32,128,37],[131,32,131,37],[135,32,135,37],[118,21,118,23],[118,11,118,17],[138,36,138,37],[98,18,98,20],[101,24,101,29],[93,21,93,23],[92,21,92,23],[92,18,92,20],[110,18,110,20],[111,18,111,20],[112,18,112,20],[113,18,113,20],[103,18,103,20],[104,18,104,20],[105,18,105,20],[106,18,106,20],[107,18,107,20],[109,18,109,20],[106,21,106,23],[111,24,111,29],[108,24,108,29],[109,24,109,29],[110,24,110,29],[108,21,108,23],[109,21,109,23],[110,21,110,23],[107,21,107,23],[0,35,0,37],[27,31,27,33],[26,19,26,26],[28,19,28,26],[30,19,30,26],[27,21,27,30],[27,17,27,20],[0,0,0,34],[3,0,3,37],[6,0,6,35],[6,36,6,37],[25,0,25,3],[24,0,24,37],[25,25,25,29],[30,0,30,2],[1,0,1,37],[26,3,26,16],[26,31,26,33],[26,27,26,28],[26,29,26,30],[29,4,29,8],[21,0,21,35],[21,36,21,37],[23,0,23,35],[65,36,65,37],[64,21,64,37],[59,0,59,35],[59,36,59,37],[60,0,60,35],[60,36,60,37],[61,0,61,35],[61,36,61,37],[64,18,64,20],[65,18,65,20],[62,11,62,17],[62,21,62,37],[62,18,62,20],[29,33,29,37],[33,3,33,10],[28,34,28,37],[27,0,27,3],[27,4,27,8],[27,9,27,10],[27,34,27,37],[29,0,29,3],[33,0,33,2],[30,34,30,37],[30,3,30,16],[30,17,30,18],[30,27,30,28],[28,17,28,18],[66,18,66,20],[67,18,67,20],[68,18,68,20],[69,18,69,20],[70,18,70,20],[71,18,71,20],[72,18,72,20],[62,0,62,10],[82,11,82,17],[82,18,82,20],[73,11,73,17],[74,11,74,17],[75,11,75,17],[76,11,76,17],[77,11,77,17],[78,11,78,17],[79,11,79,17],[80,11,80,17],[81,11,81,17],[64,11,64,17],[65,11,65,17],[66,11,66,17],[67,11,67,17],[68,11,68,17],[109,0,109,10],[79,18,79,20],[80,18,80,20],[81,18,81,20],[79,24,79,29],[80,24,80,29],[102,0,102,10],[103,0,103,10],[104,0,104,10],[105,0,105,10],[84,11,84,17],[97,0,97,10],[108,11,108,17],[108,18,108,20],[102,11,102,17],[100,18,100,20],[96,24,96,29],[92,24,92,29],[93,24,93,29],[101,21,101,23],[102,21,102,23],[103,21,103,23],[104,21,104,23],[102,18,102,20],[69,11,69,17],[70,11,70,17],[71,11,71,17],[72,11,72,17],[101,11,101,17],[101,18,101,20],[96,21,96,23],[97,21,97,23],[98,21,98,23],[99,21,99,23],[100,21,100,23],[89,0,89,27],[93,11,93,17],[93,18,93,20],[94,11,94,17],[94,18,94,20],[95,11,95,17],[95,18,95,20],[96,11,96,17],[96,18,96,20],[97,11,97,17],[97,18,97,20],[99,18,99,20],[94,21,94,23],[113,0,113,10],[99,0,99,10],[100,0,100,10],[101,0,101,10],[98,11,98,17],[110,0,110,10],[111,0,111,10],[110,11,110,17],[98,0,98,10],[99,11,99,17],[100,11,100,17],[107,11,107,17],[107,0,107,10],[109,11,109,17],[111,11,111,17],[112,11,112,17],[113,11,113,17],[103,11,103,17],[106,11,106,17],[104,11,104,17],[105,11,105,17],[112,0,112,10],[106,0,106,10],[108,0,108,10],[117,21,117,23],[117,24,117,29],[116,0,116,10],[117,0,117,10],[124,32,124,37],[125,0,125,31],[125,32,125,37],[119,35,119,37],[124,0,124,31],[118,24,118,29],[118,30,118,35],[118,36,118,37],[116,21,116,23],[126,0,126,31],[126,32,126,37],[127,0,127,31],[127,32,127,37],[136,32,136,37],[120,0,120,31],[121,0,121,31],[122,0,122,31],[123,0,123,31],[129,0,129,31],[130,0,130,31],[128,0,128,31],[131,0,131,31],[135,0,135,31],[136,0,136,31],[133,0,133,31],[133,32,133,37],[134,0,134,31],[134,32,134,37],[132,0,132,31],[132,32,132,37]]}
["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'!A25","v":"Rev. 5/13/20"}]
["§101(p) “Local Housing Trust Fund” is a public, joint public and private, or charitable nonprofit organization organized under §501(c)(3) of the Internal Revenue Code, which was established by legislation, ordinance, resolution (including nonprofit articles of incorporation), or a public-private partnership organized to receive specific public, or public and private, revenue to address local housing needs. The key characteristic of a Local Housing Trust Fund is that it receives Ongoing Revenues from Dedicated Sources of funding sufficient to permit the Local Housing Trust Fund to comply with the requirements of the Program."]
["§101(dd) “Regional Housing Trust Fund” means a Trust Fund serving two or more jurisdictions if the combined population is more than 1 million people; serving three or more jurisdictions in counties with total populations of 250,000 or less; and serving four or more jurisdictions in counties with total populations of more than 250,000."]
["§102 Eligible Applicants"]
["Applicant Type:"]
["City and/or County Applicants §102(a)"]
["(a) Applicant has created, funded, and operated an Existing or Local or Regional Housing Trust Fund, or that has created and funded a New Local or Regional Housing Trust Fund?"]
["(1)(A) The 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?"]
["(1)(B) The 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?"]
["(2) The city or county has 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?"]
["(3) The city or county has submitted to HCD the Annual Progress Report required by GC Code §65400 for the current 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?"]
["Charitable nonprofit Applicant §102(b)"]
["(b) Applicant is a nonprofit as described in Internal Revenue Code §501(c)(3) that is an Existing Local Housing Trust Fund or a New Local Housing Trust Fund? "]
["(1)(A) The Trust Fund consists of 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?"]
["(1)(B) The 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?"]
["(2) The charitable nonprofit organization agrees 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 HCD has determined, pursuant to GC §65585, to be in substantial compliance with the requirements of Article 10.6 (commencing with GC §65580) of Chapter 3 of Division 1 of Title 7 of the GC?"]
["(3) The charitable nonprofit organization agrees to utilize Program Funds only for Eligible Projects located in cities and counties that have submitted to HCD the Annual Progress Report required by GC Code §65400 for the current year or prior year?"]
["Native American Tribe or Tribes Applicants §102(c)"]
["(c) Applicant has or have created, funded, and operated an Existing Local Housing Trust Fund, or has created and funded a New Local Housing Trust Fund? "]
["(1)(A) The 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?"]
["(1)(B) The 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?"]
["(2) The Native American Tribe or Tribes agrees 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 HCD has determined, pursuant to  GC §65585, to be in substantial compliance with the requirements of Article 10.6 (commencing with GC §65580) of Chapter 3 of Division 1 of Title 7 of the GC?"]
["(3) The Native American Tribe or Tribes agrees 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 HCD the Annual Progress Report required by GC Code §65400 for the current year or prior year?"]
["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:"]
["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:"]
["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,"Contact 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:"]
["File Name:",null,null,"HTF",null,null,null,null,null,null,null,"Legislation, Ordinance or Resolution creating the HTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Cert & Legal Disclosure",null,null,null,null,null,null,null,"Certifications & Legal Disclosure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Reso",null,null,null,null,null,null,null,"Resolution (see below for the minimum Resolution content requirements)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["(1)","Entity Name (identity of the contracting party or borrower) and Entity Type (corporation, non-profit, for-profit, LLC, etc.)"]
["(2)","Name & Title of Signatory(ies)****                                                                                                                                                                                                                \nNOTE: Name and title of authorized signatory(ies) is preferred. In instances pertaining to municipalities/jurisdictions/transit agencies (when title is acceptable), supporting documentation evidencing the individual who currently holds the position must be provided."]
["(3)","NOFA Date."]
["(4)","Language authorizing Signatory(ies) to sign Standard Agreement (if more than one is listed, ensure \"and\" or \"or\" is defined for individuals required to sign)."]
["(5)","Amendment Provision included. "]
["(6)","Aggregate dollar amount (should be equal to or greater than the requested/award amount)."]
["(7)","Person attesting validity of resolution (must be someone other than person authorized to sign Standard Agreement)."]
["(8)","The meeting date authorizing resolution."]
["(9)","All votes taken at meeting authorizing resolution (ayes, no's, absent, vacant)."]
["(10)","LHTF name(s) as it appears on the LHTF application."]
["File Name:",null,null,"OrgDoc1, OrgDoc2, etc.",null,null,null,null,null,null,null,"Organizational Documents ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Articles of Incorporation (Corp. Code §154, 200 and 202) as certified by the CA Secretary of State.\nBylaws and any amendments thereto (Corp. Code §207(b), 211 and 212).\nCertificate of Amendment of Articles of Incorporation (Corp. Code §900-910 (general stock), §5810-5820 (public benefit and religious corporations), §7810-7820 (mutual benefit corporations), or §12500-12510 (general cooperative corporations)) as applicable.\nRestated Articles of Incorporation (Corp. Code §901, 906, 910 (general stock), §5811, 5815, 5819 (public benefit and religious corporations), §7811, 7815 and 7819 (mutual benefit corporations) and §12501, 12506 and 12510 (general cooperative corporations)) as applicable.\nStatement of Information (CA Secretary of State form SI-100 or SI-200)\nShareholder Agreements (Corp. Code §186) if applicable.\nCertificate of Good Standing certified by Secretary of State."]
["File Name:",null,null,"OrgChart",null,null,null,null,null,null,null,"Organizational Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Signature Block",null,null,null,null,null,null,null,"501(c)(3) nonprofit corporation only - Signature Block, upload in Microsoft Word Doc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Government TIN Form",null,null,null,null,null,null,null,"Gov't Agency Taxpayer ID Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Payee Data Record",null,null,null,null,null,null,null,"STD-204 Payee Data Record",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Financial Statements",null,null,null,null,null,null,null,"501(c)(3) nonprofit corporation only - Audited financial statements (2 years)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"501 Determination",null,null,null,null,null,null,null,"501(c)(3) nonprofit corporation only - determination letter regarding 501(c)(3) status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["§103 and NOFA Funding Amount Minimums and Maximums"]
["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 Type:"]
[{"$f":"IF(E55='Drop downs'!A2,\"(a) The minimum application request shall be $1 million with a max request of $5 million.\",IF(OR(E55='Drop downs'!A3,E55='Drop downs'!A5),\"(b) The minimum application request shall be $500,000 with a max request of $5 million.\",IF(E55='Drop downs'!A4,\"(c) The minimum application request shall be $750,000 with a max request of $5 million.\",\"\")))","v":""},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(E55='Drop downs'!A2,1000000,IF(E55='Drop downs'!A3,500000,IF(E55='Drop downs'!A4,750000,0)))","v":0}]
["§104 Matching Funds Requirements"]
["(a) Applicant agrees Program Funds provided will be matched on a dollar for dollar basis with dedicated sources of funding, such as taxes, fees, or loan repayments, or public or private contributions by the Applicant? Lines of Credit and loans received by the Trust Fund are not eligible sources of Matching Funds."]
["(b) Applicant understands an application for LHTF funds will not be considered unless the application contains required documentation of the deposit in the Local Housing Trust Fund of the local Matching Funds, and the identity of the source of Matching Funds, or evidence of a legally binding commitment to deposit the required Matching Funds, and the identity of the source of Matching Funds?"]
["(c) Applicant understands that funds restricted for housing use by state or federal law (such as funds from the Home Investment Partnerships Program (HOME), the Community Development Block Grant Program (CDBG), redevelopment agency low- and moderate-income housing fund set-aside (LMIHF) funds, or state housing programs administered by HCD), will not be considered Matching Funds? Permanent Local Housing Allocation (PLHA) Program funds may be considered Matching Funds for Regional Housing Trust Funds."]
["(d) Applicant agrees that Matching Funds will be on deposit prior to disbursement of Program Funds?"]
["(e) Applicant agrees Matching Funds will be utilized on a dollar-for-dollar basis for the same Eligible Project for which Program Funds are used?"]
["Matching Funds",null,null,null,null,null,null,null,null,null,null,"Total Matching Funds",null,null,null,null,null,null,{"$f":"SUM(S66:U85)","v":0}]
["Attach documentation for each source of Matching Funds. These include, but are not limited to, Bank statement(s) showing the deposit(s), letter of explanation for each deposit, and a fully-executed, legally-binding commitment/award letter or contract from each funding entity; ordinances adopting fees and/or taxes, prior year financial statement showing fees and/or taxes actually received; land title and appraisal dated within 6 months of application deadline documenting donated land value; Trust Fund loan portfolio spreadsheet showing required interest payments, required principal payments, loan due dates, and required fees, as well as promissory notes for loans whose interest or payments are used as Matching Funds."]
["Name of Matching Funds",null,null,null,null,null,null,null,null,null,null,"Describe or Select\nMatching Fund Type",null,null,null,null,null,null,"Amount",null,null,"Required Documentation for Matching Funds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," File Name:",null,null,"Matching Fund 1",null,null,null,null,null,"Uploaded to HCD?",null,null,null,null,null,null,null,{"$f":"IF(AND(L66<>\"Residential in Lieu Fee\",L66<>\"Residential Local Impact Fee\"),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," File Name:",null,null,"Matching Fund 2",null,null,null,null,null,"Uploaded to HCD?",null,null,null,null,null,null,null,{"$f":"IF(AND(L67<>\"Residential in Lieu Fee\",L67<>\"Residential Local Impact Fee\"),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," File Name:",null,null,"Matching Fund 3",null,null,null,null,null,"Uploaded to HCD?",null,null,null,null,null,null,null,{"$f":"IF(AND(L68<>\"Residential in Lieu Fee\",L68<>\"Residential Local Impact Fee\"),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," File Name:",null,null,"Matching Fund 4",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 5",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 6",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 7",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 8",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 9",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 10",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 11",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 12",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 13",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 14",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 15",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 16",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 17",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 18",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 19",null,null,null,null,null,"Uploaded to HCD?",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," File Name:",null,null,"Matching Fund 20",null,null,null,null,null,"Uploaded to HCD?",null,null,null,null,null,null,null,1]
["Ongoing Revenues"]
["§101(p) “Local Housing Trust Fund” - The key characteristic of a Local Housing Trust Fund is that it receives Ongoing Revenues from Dedicated Sources of funding sufficient to permit the Local Housing Trust Fund to comply with the requirements of the Program\n"]
["§101(e) “Dedicated Source” means taxes, fees, and loan repayments consistent with §104(c), and/or public or private contributions that will provide Ongoing Revenues to the Local Housing Trust Fund sufficient to meet the LHTF Program requirements. Dedicated Source does not include lines of credit or loans obtained by the Trust Fund. \n"]
["§101(z) “Ongoing Revenues” means the following: (1) For an Existing Housing Trust Fund, it means a public or private source, or sources, of revenue totaling at least an average of $100,000 per year for three years after the date of the Program award; (2) For a New Housing Trust Fund, it means sufficient public or private sources of revenue to pay for the Trust Fund’s operating costs for a minimum of five years after the date of the Program award. (3) Ongoing Revenues may not include one-time donations, such as land donations or large bequests. \n"]
[{"$f":"IF(E55='Drop downs'!A2,\"Ongoing Revenues must be at least an average of $100,000 per year for three years after Program award.\",IF(OR(E55='Drop downs'!A3,E55='Drop downs'!A4),\"Ongoing Revenues must be sufficient to pay Fund's operating costs for five years after Program award.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Ongoing Revenues",null,null,null,null,null,null,{"$f":"SUM(R93:U119)","v":0},null,null,{"$f":"MID(E55,2,1)","v":""},{"$f":"IF(AND(AM90=\"a\",AJ90<100000),\"No\",IF(AND(OR(AM90=\"b\",AM90=\"c\",AM90=\"d\"),AJ90<AJ120),\"No\",\"Yes\"))","v":"Yes"}]
["Attach documentation for each source of Ongoing Revenues. These include, but are not limited to, Bank statement(s) showing the deposit(s), letter of explanation for each deposit, and a fully-executed, legally-binding commitment/award letter or contract from each funding entity; ordinances adopting fees and/or taxes, prior year financial statement showing fees and/or taxes actually received; Trust Fund loan portfolio spreadsheet showing required interest payments, required principal payments, loan due dates, and required fees, as well as promissory notes for loans whose interest or payments are used as Ongoing Revenues."]
["Dedicated Source of Ongoing Revenues",null,null,null,null,null,null,null,null,null,null,"Describe or Select\nOngoing Revenues Type",null,null,null,null,null,null,"Annual Amount",null,null,"Required Documentation for Ongoing Revenues"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," File Name:",null,null,"Ongoing Revenue 1",null,null,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," File Name:",null,null,"Ongoing Revenue 2",null,null,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," File Name:",null,null,"Ongoing Revenue 3",null,null,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," File Name:",null,null,"Ongoing Revenue 4",null,null,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," File Name:",null,null,"Ongoing Revenue 5",null,null,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," File Name:",null,null,"Ongoing Revenue 6",null,null,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," File Name:",null,null,"Ongoing Revenue 7",null,null,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," File Name:",null,null,"Ongoing Revenue 8",null,null,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," File Name:",null,null,"Ongoing Revenue 9",null,null,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," File Name:",null,null,"Ongoing Revenue 10",null,null,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," File Name:",null,null,"Ongoing Revenue 11",null,null,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," File Name:",null,null,"Ongoing Revenue 12",null,null,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," File Name:",null,null,"Ongoing Revenue 13",null,null,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," File Name:",null,null,"Ongoing Revenue 14",null,null,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," File Name:",null,null,"Ongoing Revenue 15",null,null,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," File Name:",null,null,"Ongoing Revenue 16",null,null,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," File Name:",null,null,"Ongoing Revenue 17",null,null,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," File Name:",null,null,"Ongoing Revenue 18",null,null,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," File Name:",null,null,"Ongoing Revenue 19",null,null,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," File Name:",null,null,"Ongoing Revenue 20",null,null,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," File Name:",null,null,"Ongoing Revenue 21",null,null,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," File Name:",null,null,"Ongoing Revenue 22",null,null,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," File Name:",null,null,"Ongoing Revenue 23",null,null,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," File Name:",null,null,"Ongoing Revenue 24",null,null,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," File Name:",null,null,"Ongoing Revenue 25",null,null,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," File Name:",null,null,"Ongoing Revenue 26",null,null,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," File Name:",null,null,"Ongoing Revenue 27",null,null,null,null,null,"Uploaded to HCD?"]
["Average annual projected Operating Costs for the five years after Program award.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Average Operating Costs",null,null,null,null,null,null,null,{"$f":"SUM(AE122:AL137)","v":0}]
["New Housing Trust Fund only: average annual operating cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Operating Cost"]
["Salaries and benefits"]
["Insurance"]
["Utilities"]
["Phone and internet"]
["Marketing"]
["Mailing fees"]
["Recording fees"]
["Supplies"]
["Real property taxes"]
["Rent"]
["Property maintenance"]
["Interest on loans"]
["Other - describe"]
["Other - describe"]
["Other - describe"]
["Other - describe"]
["§105. Eligible Uses of Funds"]
["(a) Applicant agrees Program Funds will be used to provide construction loans and/or permanent financing loans at simple interest rates of no higher than 3% per annum, for payment of predevelopment costs, acquisition costs and other costs associated with the development, or rehabilitation of Eligible Projects?"]
["(b) Applicant understands administrative expenses of up to 5% of Program Funds and up to 5% of Matching Funds are allowed (see amount below)?"]
["Max Program admin. expenses (5%)",null,null,null,null,null,null,null,null,{"$f":"AI56*0.05","v":0},null,null,null," Max Matching Funds admin. expenses (5%)",null,null,null,null,null,null,null,null,null,null,{"$f":"S63*0.05","v":0},null,null,null,"Max admin. expenses",null,null,null,null,null,{"$f":"J141+Y141","v":0}]
["(c) Applicant agrees at least 30% of the Program Funds, after deducting administrative expense, and the Matching Funds will be expended on assistance to Extremely Low-Income (ELI) Households. To comply with this requirement, dwelling units or shelter beds must be Affordable to, and restricted for, ELI Households with household income of no more than 30% of AMI (see amount below)?"]
["Min Program funds for ELI Households",null,null,null,null,null,null,null,null,{"$f":"SUM(AI56-J141)*0.3","v":0},null,null,null,"Minimum Matching Funds for ELI Households",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S63-Y141)*0.3","v":0},null,null,null,"Minimum ELI assistance",null,null,null,null,null,{"$f":"J143+Y143","v":0}]
["(d) Applicant agrees no more than 20% of the Program Funds, after deducting administrative expense, and the Matching Funds will be expended on assistance to Moderate-Income (MI) Households. To comply with this requirement, dwelling units must be Affordable to, and restricted for, MI Households with household income of no more than 120% of AMI (see amount below)?"]
["Max Program funds for MI Households",null,null,null,null,null,null,null,null,{"$f":"SUM(AI56-J141)*0.2","v":0},null,null,null,"Maximum Matching Funds for MI Households",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S63-Y141)*0.2","v":0},null,null,null,"Maximum MI assistance",null,null,null,null,null,{"$f":"J145+Y145","v":0}]
["(e) Applicant agrees the remaining Program Funds and Matching Funds will be expended on assistance to Lower-Income (LI) Households. To comply with this requirement, dwelling units must be Affordable to, and restricted for, LI Households with household income of no more than 80% of AMI (see amount below)?"]
["Min Program funds for LI Households",null,null,null,null,null,null,null,null,{"$f":"AI56-(J141+J143+J145)","v":0},null,null,null,"Minimum Matching Funds for LI Households",null,null,null,null,null,null,null,null,null,null,{"$f":"S63-(Y141+Y143+Y145)","v":0},null,null,null,"Minimum LI assistance",null,null,null,null,null,{"$f":"J147+Y147","v":0}]
["§107(d) Applicant's Loan Guidelines and Underwriting Standards and Procedures"]
["Applicant must upload loan guidelines and underwriting standards and procedures. Describe the guidelines and underwriting standards and procedures.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rental new construction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rental rehab & acquisition"]
["File Name:",null,null,"Guidelines 107d",null,null,null,null,null," Local loan guidelines and underwriting standards and procedures","Provide a copy of loan guidelines and underwriting standards and procedures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?",null,null,null,null,null,null,null,"Emergency Shelter"]
["List all of the proposed project(s) and activities in connection with this application as specified in §101(g), (1)(2)(3)&(4).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transitional Housing"]
["Project Type and Activity",null,null,null,null,"Proposed Activity Timeline - provide a general timeline of implementation of your Project, including at a minimum, when you will issue commitments, when construction loan closing will occur, and when you anticipate a disbursement of LHTF Program Funds.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed amount",null,null,"HB Project Construction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner-Occupied Rehab"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADU stand alone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Homebuyer Assistance"]

{"sheet":"Certification & Legal","index":3,"n_rows":39,"n_cols":37,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,8],[38,10,38,18],[38,20,38,33],[34,0,34,37],[35,0,35,2],[35,3,35,10],[35,11,35,30],[35,31,35,35],[35,36,35,37],[36,0,36,37],[37,0,37,8],[37,10,37,18],[37,20,37,33],[37,35,37,37],[31,0,31,35],[31,36,31,37],[32,0,32,35],[32,36,32,37],[33,0,33,35],[33,36,33,37],[28,0,28,35],[28,36,28,37],[29,0,29,35],[29,36,29,37],[30,0,30,35],[30,36,30,37],[27,0,27,35],[27,36,27,37],[21,0,21,35],[21,36,21,37],[22,0,22,35],[22,36,22,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],[26,0,26,37],[20,0,20,37],[11,0,11,8],[11,10,11,18],[11,20,11,33],[12,0,12,37],[13,0,13,37],[14,0,14,37],[15,0,15,37],[16,0,16,37],[17,0,17,37],[18,0,18,37],[19,0,19,37],[6,0,6,37],[7,0,7,37],[8,0,8,37],[9,0,9,37],[10,0,10,8],[10,10,10,18],[10,20,10,33],[10,35,10,37],[5,0,5,37],[0,0,0,37],[1,0,1,37],[2,0,2,37],[3,0,3,37],[4,0,4,37]]}
["Certification & Legal Status"]
["On behalf of the entity identified in the signature block below, I certify that:"]
["1. The information, statements and attachments included in this application are, to the best of my knowledge and belief, true and correct."]
["2. I possess the legal authority to submit this application on behalf of the entity identified in the signature block."]
["3. The following is a complete disclosure of all identities of interest - of all persons or entities, including affiliates, that will provide goods or services to the Project either (a) in one or more capacity or (b) that qualify as a \"Related Party\" to any person or entity that will provide goods or services to the project. \"Related Party\" is defined in Section 10302 of the California Code of Regulations (CTCAC Regulations): "]
[]
["4. As of the date of application, the Project, or the real property on which the Project is proposed (Property) is not part to or the subject of any claim or action at the State or Federal appellate level."]
["5. I have disclosed and described below any claim or action undertaken which affects or potentially affects the feasibility of the Project."]
["In addition, I acknowledge that all information in this application and attachments is public, and may be disclosed by the State."]
[]
["     "]
["Printed Name",null,null,null,null,null,null,null,null,null,"Title of Signatory",null,null,null,null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["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:"]
["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) must respond, as must chief financial officers (Treasurers, Chief Financial Officers, or their equivalent)."]
["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."]
["File Name:",null,null,"Cert. Letter of Explanation",null,null,null,null,null,null,null,"'Letter of explanation for any \"red\" shaded cells above. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
[]
[]
["Printed Name",null,null,null,null,null,null,null,null,null,"Title of Signatory",null,null,null,null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Application Score","index":4,"n_rows":52,"n_cols":40,"rows_kept":52,"cut":false,"hidden":false,"merged":[[50,0,50,2],[50,3,50,8],[50,30,50,35],[50,36,50,37],[51,0,51,2],[51,3,51,8],[51,30,51,35],[51,36,51,37],[50,9,50,24],[51,9,51,24],[50,25,50,29],[51,25,51,29],[48,0,48,2],[48,3,48,8],[48,30,48,35],[48,36,48,37],[49,0,49,2],[49,3,49,8],[49,30,49,35],[49,36,49,37],[48,9,48,24],[49,9,49,24],[48,25,48,29],[49,25,49,29],[46,0,46,2],[46,3,46,8],[46,30,46,35],[46,36,46,37],[47,0,47,2],[47,3,47,8],[47,30,47,35],[47,36,47,37],[46,9,46,24],[47,9,47,24],[46,25,46,29],[47,25,47,29],[44,0,44,2],[44,3,44,8],[44,30,44,35],[44,36,44,37],[45,0,45,2],[45,3,45,8],[45,30,45,35],[45,36,45,37],[44,9,44,24],[45,9,45,24],[44,25,44,29],[45,25,45,29],[42,0,42,2],[42,3,42,8],[42,30,42,35],[42,36,42,37],[43,0,43,2],[43,3,43,8],[43,30,43,35],[43,36,43,37],[42,9,42,24],[43,9,43,24],[42,25,42,29],[43,25,43,29],[1,0,1,35],[1,36,1,37],[23,0,23,8],[19,28,19,37],[20,0,20,8],[19,0,19,8],[21,9,21,18],[18,0,18,8],[17,0,17,8],[17,9,17,18],[13,36,13,37],[8,0,8,2],[8,3,8,8],[8,9,8,29],[8,30,8,35],[8,36,8,37],[3,0,3,35],[3,36,3,37],[2,35,2,37],[2,0,2,18],[11,0,11,35],[11,36,11,37],[9,0,9,35],[9,36,9,37],[7,35,7,37],[24,0,24,37],[25,0,25,37],[38,36,38,37],[36,36,36,37],[33,36,33,37],[34,36,34,37],[26,0,26,37],[7,9,7,11],[7,20,7,22],[34,0,34,10],[34,11,34,12],[15,0,15,18],[15,19,15,37],[16,19,16,27],[16,28,16,37],[22,0,22,8],[20,9,20,18],[10,31,10,34],[10,35,10,37],[10,0,10,20],[12,0,12,34],[12,35,12,37],[10,21,10,22],[2,30,2,34],[2,19,2,21],[2,27,2,29],[2,22,2,26],[39,36,39,37],[40,0,40,37],[38,0,38,10],[38,11,38,12],[38,23,38,24],[39,0,39,10],[35,36,35,37],[37,36,37,37],[37,0,37,10],[37,11,37,12],[37,13,37,22],[37,23,37,24],[32,36,32,37],[32,11,32,12],[31,23,31,24],[32,23,32,24],[30,23,30,24],[27,36,27,37],[27,25,27,35],[23,19,23,27],[4,28,4,30],[4,31,4,34],[5,0,5,35],[5,36,5,37],[6,21,6,22],[4,0,4,15],[4,16,4,17],[4,21,4,22],[4,18,4,20],[4,23,4,27],[4,35,4,37],[6,23,6,26],[6,27,6,37],[10,23,10,27],[10,28,10,30],[14,0,14,37],[32,0,32,10],[28,13,28,22],[28,25,28,35],[29,25,29,35],[30,25,30,35],[16,0,16,8],[20,19,20,27],[21,19,21,27],[22,19,22,27],[17,19,17,27],[17,28,17,37],[18,19,18,27],[18,28,18,37],[19,19,19,27],[18,9,18,18],[19,9,19,18],[23,9,23,18],[16,9,16,18],[23,28,23,37],[32,13,32,22],[31,11,31,12],[35,0,35,10],[33,0,33,10],[33,11,33,12],[33,13,33,22],[35,11,35,12],[35,13,35,22],[20,28,20,37],[21,28,21,37],[22,28,22,37],[21,0,21,8],[22,9,22,18],[33,23,33,24],[33,25,33,35],[28,23,28,24],[29,23,29,24],[41,0,41,37],[0,36,0,37],[0,33,0,35],[0,0,0,32],[38,13,38,22],[35,23,35,24],[35,25,35,35],[36,0,36,10],[36,11,36,12],[36,13,36,22],[36,23,36,24],[36,25,36,35],[27,13,27,22],[27,0,27,10],[28,0,28,10],[29,0,29,10],[30,0,30,10],[31,0,31,10],[38,25,38,35],[7,0,7,8],[34,13,34,22],[7,23,7,34],[7,12,7,19],[6,0,6,20],[39,13,39,22],[13,0,13,13],[13,14,13,33],[13,34,13,35],[28,36,28,37],[29,36,29,37],[30,36,30,37],[31,36,31,37],[39,25,39,35],[39,11,39,12],[31,25,31,35],[32,25,32,35],[39,23,39,24],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[37,25,37,35],[34,23,34,24],[27,23,27,24],[34,25,34,35],[29,13,29,22],[30,13,30,22],[31,13,31,22]]}
["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":"'LHTF Coverpage'!A25","v":"Rev. 5/13/20"},null,null,{"$f":"IF(AK2+AK4+AK6+AK10+AK12+AK14>100,100,AK2+AK4+AK6+AK10+AK12+AK14)","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('Project and Applicant'!AM66:AM85,\"1\",'Project and Applicant'!S66:U85)","v":0},null,null,"Total Matching Funds",null,null,null,null,{"$f":"'Project and Applicant'!S63","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'!AI56+'Project and Applicant'!S63)-(('Project and Applicant'!AI56+'Project and Applicant'!S63)*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":"AM8+AN8","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,"Website address that shows projects status:"]
["Total Amount of First Phase Funding",null,null,null,null,null,null,null,null,null,null,null,"Total Program Funds Requested",null,null,null,null,null,null,null,{"$f":"'Project and Applicant'!AI56","v":0},null,null,"First Phase Funding vs. Requested (times)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUNDDOWN(J8/U8,0),0)","v":0},null,null,{"$f":"IF(V7=\"Yes\",5,0)","v":0},{"$f":"IF(AJ8>=3,10,IF(AJ8=2,5,0))","v":0}]
["File Name:",null,null,"MF Readiness List",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(ROUNDDOWN(V11,2)=1,20,IF(ROUNDDOWN(V11,2)>0.74,15,IF(ROUNDDOWN(V11,2)>0.5,10,0)))","v":0}]
["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,null,null,null,null,null,null,null,null,null,null,"Program Funds + Matching Funds - Admin Exp.",null,null,null,null,{"$f":"('Project and Applicant'!AI56+'Project and Applicant'!S63)-(('Project and Applicant'!AI56+'Project and Applicant'!S63)*0.05)","v":0},null,null,"Minimum amount of LI rental exp.",null,null,null,{"$f":"V11*AC11","v":0}]
["(5) Community Need - 15 points max (NOTE: this section will be scored by HCD only)",null,null,null,null,null,null,null,null,null,null,null,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(AJ13=\"\",0,IF(AJ13>0.34,15,IF(AJ13>0.15,10,IF(AJ13>=0,5,0))))","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 - 15 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(AI14=\"Yes\",15,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."]
[]
[]
[]
[]
[]
[]
[]
[]
["Explain below."]
[]
["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 #"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]
["File Name:",null,null,"LOI 1",null,null,null,null,null,"Enter developer name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter LOI date",null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"LOI 2",null,null,null,null,null,"Enter developer name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter LOI date",null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"LOI 3",null,null,null,null,null,"Enter developer name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter LOI date",null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"LOI 4",null,null,null,null,null,"Enter developer name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter LOI date",null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"LOI 5",null,null,null,null,null,"Enter developer name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter LOI date",null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"LOI 6",null,null,null,null,null,"Enter developer name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter LOI date",null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"LOI 7",null,null,null,null,null,"Enter developer name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter LOI date",null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"LOI 8",null,null,null,null,null,"Enter developer name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter LOI date",null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"LOI 9",null,null,null,null,null,"Enter developer name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter LOI date",null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"LOI 10",null,null,null,null,null,"Enter developer name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter LOI date",null,null,null,null,"Uploaded to HCD?"]

{"sheet":"Drop downs","index":5,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
["(a) Existing Local Housing Trust Fund","Tax",null,"(a) City"]
["(b) New Local Housing Trust Fund, but 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) utilizing Permanent Local Housing Allocation Funds as Matching Funds","Residential in Lieu Fee",null,"(a) City and County"]
["(d) New Local Housing Trust Fund (also a Regional Housing Trust Fund) not utilizing Permanent Local Housing Allocation Funds as Matching Funds","Loan Repayment",null,"(b) Charitable nonprofit organization"]
[null,"Public Contribution",null,"(c) Native American Tribe or Tribes"]
["New Local Housing Trust fund","Private Contribution"]
["Existing Local Housing Trust Fund","Commercial Fees"]
[null,"PLHA funds"]
[null,"HOME funds"]
["Existing Local Housing Trust Fund","CDBG funds"]
["New Local Housing Trust Fund"]
["Regional Housing Trust Fund"]
[]
["Type of Housing Trust Fund"]
["In Lieu Fees"]
["Non-residential Local Impact Fees"]
["Residential Local Impact Fees"]
[]
["Type of Housing Trust Fund"]
["Public Housing Trust Fund"]
["Non-profit Housing Trust Fund"]
["Tribal Housing Trust Fund "]
[]
[]
["Type of Housing Trust Fund"]
["Local Public Entity"]
["Charitable nonprofit organization"]
["Native American Tribe"]

{"sheet":"Checklist","index":6,"n_rows":28,"n_cols":39,"rows_kept":28,"cut":false,"hidden":true,"merged":[[27,1,27,4],[27,5,27,11],[27,32,27,37],[27,38,27,40],[27,12,27,19],[27,20,27,31],[25,38,25,40],[26,1,26,4],[26,5,26,11],[26,32,26,37],[26,38,26,40],[26,12,26,19],[26,20,26,31],[25,1,25,4],[25,5,25,11],[25,12,25,19],[25,20,25,31],[25,32,25,37],[23,38,23,40],[24,1,24,4],[24,5,24,11],[24,12,24,19],[24,20,24,31],[24,32,24,37],[24,38,24,40],[23,1,23,4],[23,5,23,11],[23,12,23,19],[23,20,23,31],[23,32,23,37],[21,38,21,40],[22,1,22,4],[22,5,22,11],[22,12,22,19],[22,20,22,31],[22,32,22,37],[22,38,22,40],[21,1,21,4],[21,5,21,11],[21,12,21,19],[21,20,21,31],[21,32,21,37],[18,1,18,4],[19,0,19,40],[20,1,20,4],[20,5,20,11],[20,12,20,19],[20,20,20,31],[20,32,20,37],[20,38,20,40],[0,34,0,37],[10,1,10,4],[18,38,18,40],[15,5,15,11],[15,12,15,31],[16,5,16,11],[16,12,16,31],[15,38,15,40],[16,38,16,40],[18,5,18,11],[18,12,18,31],[15,32,15,37],[16,32,16,37],[18,32,18,37],[15,1,15,4],[16,1,16,4],[8,1,8,4],[9,1,9,4],[1,0,1,40],[8,38,8,40],[9,12,9,37],[8,12,8,37],[8,5,8,11],[4,1,4,37],[2,0,2,37],[5,1,5,37],[6,1,6,37],[10,38,10,40],[12,38,12,40],[11,38,11,40],[17,0,17,40],[9,5,9,11],[10,5,10,11],[11,5,11,11],[12,5,12,11],[11,1,11,4],[12,1,12,4],[10,12,10,37],[11,12,11,37],[12,12,12,37],[14,38,14,40],[14,0,14,37],[9,38,9,40]]}
[null,null,null,null,null,null,null,null,null,null,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'!A25","v":"Rev. 5/13/20"}]
["LOCAL HOUSING TRUST FUND (LHTF) Document Checklist"]
["Packaging instructions for the LHTF Program application submission:"]
[]
["(1)","Use 3ring binder/binders appropriate to the size/thickness of the Universal Application and the Supplemental Application when submitting the application package to the Department."]
["(2)","Use labeled tabs to separate each section and document attached according to the Application checklist to separate each section and document attached in the application."]
["(3)","Use the tab file name descriptions and file structure below for the 1. binder tab numbers and 2. electronic folder and file name."]
[]
["Binder Tab #","Threshold Requirement",null,null,null,"Electronic File Name",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?"]
[1,"X",null,null,null," Document Checklist",null,null,null,null,null,null," Document Checklist."]
[2,"X",null,null,null," Universal Application",null,null,null,null,null,null," Universal Application."]
[3,"X",null,null,null," Supplemental Application",null,null,null,null,null,null," JOE SERNA, JR. FARMWORKER HOUSING GRANT PROGRAM Supplemental Application."]
["3a",null,null,null,null," LOE",null,null,null,null,null,null," Letters of Explanation."]
[]
["RHD Past \"Project Experience\".",null,null,null,null,null,null,null,null,null,null,null,null,null,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?"]
[4,null,null,null,null," Past Exp RHD1, RHD2, and\n RHD3",null,null,null,null,null,null," Applicants must upload Certificates of Occupancy for at least one or more completed\n Rental Housing Development(s).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hard copy and on USB?"]
[4,null,null,null,null," Staff Resume",null,null,null,null,null,null," Upload staff resume to verify staff experience.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hard copy and on USB?"]
["If applicant is a \"Non-profit Organization\"."]
[5,null,null,null,null," Current Financial Statement",null,null,null,null,null,null," If applicant is Non-profit organization, submit a current \"Financial Statement\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hard copy and on USB?"]
["Applicant 1 Organizational Documents"]
[14,null,null,null,null," App1 Cert & Legal Disclosure",null,null,null,null,null,null," Certifications & Legal Disclosure",null,null,null,null,null,null,null," See Certifications & Legal Disclosure",null,null,null,null,null,null,null,null,null,null,null,"Hard Copy and on USB?"]
[14,null,null,null,null," App1 Reso",null,null,null,null,null,null," Resolutions ",null,null,null,null,null,null,null," See Resolution ",null,null,null,null,null,null,null,null,null,null,null,"Hard Copy and on USB?"]
[14,null,null,null,null," App1 Cert of Good Stan.",null,null,null,null,null,null," Certificate of Good Standing",null,null,null,null,null,null,null," Certificate of Good Standing certified by Secretary of\n State.",null,null,null,null,null,null,null,null,null,null,null,"Hard Copy and on USB?"]
[14,null,null,null,null," App1 OrgDoc1, \n App1 OrgDoc2, etc.",null,null,null,null,null,null," Organizational Documents ",null,null,null,null,null,null,null," See Organizational Documents",null,null,null,null,null,null,null,null,null,null,null,"Hard Copy and on USB?"]
[14,null,null,null,null," App1 OrgChart",null,null,null,null,null,null," Organizational Chart",null,null,null,null,null,null,null," See Organizational Chart",null,null,null,null,null,null,null,null,null,null,null,"Hard Copy and on USB?"]
[14,null,null,null,null," App1 Signature Block",null,null,null,null,null,null," Signature Block",null,null,null,null,null,null,null," Upload in Microsoft Word Document",null,null,null,null,null,null,null,null,null,null,null,"Hard Copy and on USB?"]
[14,null,null,null,null," App1 FI$CAL Form",null,null,null,null,null,null,"Gov't Agency Taxpayer ID Form",null,null,null,null,null,null,null," Government TIN Form",null,null,null,null,null,null,null,null,null,null,null,"Hard Copy and on USB?"]
[14,null,null,null,null," App1 Payee Data Record",null,null,null,null,null,null,"STD-204 Payee Data Record",null,null,null,null,null,null,null," STD-204",null,null,null,null,null,null,null,null,null,null,null,"Hard Copy and on USB?"]

{"sheet":"Application Support","index":7,"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'!A25","v":"Rev. 5/13/20"}]
["Please complete the \"yellow\" cells in the form below and email a copy to: AppSupport@hcd.ca.gov. A member of the Application Development Team will respond to your request within 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"]