{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Serna SF Cover Page","Overview","Certification & Legal","Applicant Documents","Application Support","Unit Des Table","NEW MAPPING","DROPDOWNS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":5,"defined_names":1043,"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":"Serna SF Cover Page","index":0,"n_rows":42,"n_cols":2,"rows_kept":42,"cut":false,"hidden":false,"merged":[[26,0,26,22],[29,0,29,22],[32,0,32,22],[27,0,27,22],[4,0,4,22],[7,0,7,22],[24,0,24,22],[25,0,25,22],[8,0,8,22],[6,0,6,22],[41,1,41,2],[28,0,28,22],[30,0,30,22],[31,0,31,22],[34,0,34,22],[35,0,35,22],[36,0,36,22],[37,0,37,22],[38,0,38,22],[39,0,39,22],[40,0,40,22],[33,0,33,22]]}
[]
[]
[]
[]
["Joe Serna, Jr. Farmworker Housing Grant Program"]
[]
["Round 2 Notice of Funding Availability (February 25, 2021)"]
[]
["Application - Single Family New Construction and\nOwner-Occupied Rehabilitation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State of California"]
["Governor Gavin Newsom"]
[]
["Lourdes Castro Ramirez, 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"]
["Phone (916) 263-2771   "]
["Email: serna@hcd.ca.gov"]
["http://www.hcd.ca.gov/grants-funding/active-funding/fwhg.shtml"]
[]
[]
["Rev.","2021-03-04"]

{"sheet":"Overview","index":1,"n_rows":198,"n_cols":41,"rows_kept":198,"cut":false,"hidden":false,"merged":[[95,0,95,2],[95,3,95,10],[95,11,95,30],[95,31,95,35],[95,36,95,37],[93,0,93,2],[93,3,93,10],[93,11,93,30],[93,31,93,35],[93,36,93,37],[94,0,94,2],[94,3,94,10],[94,11,94,30],[94,31,94,35],[94,36,94,37],[92,0,92,2],[92,3,92,10],[92,11,92,30],[92,31,92,35],[92,36,92,37],[90,0,90,2],[90,3,90,10],[90,11,90,30],[90,31,90,35],[87,0,87,2],[87,3,87,10],[87,11,87,30],[87,31,87,35],[87,36,87,37],[90,36,90,37],[91,0,91,2],[91,3,91,10],[91,11,91,30],[91,31,91,35],[91,36,91,37],[64,0,64,37],[65,7,65,37],[80,0,80,37],[81,7,81,37],[29,11,29,32],[33,4,33,10],[71,0,71,2],[71,3,71,10],[71,11,71,30],[71,31,71,35],[71,36,71,37],[72,0,72,2],[72,3,72,10],[72,11,72,30],[72,31,72,35],[72,36,72,37],[73,0,73,2],[73,3,73,10],[73,11,73,30],[73,31,73,35],[73,36,73,37],[74,0,74,2],[74,3,74,10],[74,11,74,30],[6,0,6,13],[6,14,6,18],[6,19,6,26],[6,27,6,29],[6,30,6,37],[7,0,7,13],[7,14,7,18],[7,19,7,26],[7,27,7,29],[7,30,7,37],[0,0,0,35],[0,36,0,37],[3,0,3,16],[3,17,3,37],[4,0,4,35],[4,36,4,37],[5,0,5,13],[5,14,5,18],[5,19,5,26],[5,27,5,29],[5,30,5,37],[1,0,1,30],[1,31,1,34],[1,35,1,37],[178,19,178,20],[178,23,178,25],[178,11,178,12],[176,0,176,37],[177,9,177,11],[177,13,177,15],[177,16,177,20],[177,21,177,23],[177,0,177,8],[178,7,178,8],[178,31,178,32],[178,33,178,34],[178,35,178,37],[177,24,177,34],[177,35,177,37],[178,9,178,10],[178,13,178,14],[178,17,178,18],[166,0,166,10],[166,11,166,15],[166,16,166,22],[166,23,166,37],[164,0,164,37],[175,4,175,8],[175,33,175,36],[175,9,175,32],[167,16,167,22],[167,23,167,37],[168,0,168,10],[168,11,168,15],[168,16,168,22],[168,23,168,37],[169,0,169,10],[169,11,169,15],[169,16,169,22],[169,23,169,37],[152,20,152,24],[152,25,152,29],[152,30,152,34],[153,15,153,19],[153,20,153,24],[153,25,153,29],[153,30,153,34],[153,35,153,37],[152,0,152,4],[144,25,144,29],[144,30,144,34],[146,10,146,14],[146,15,146,19],[146,20,146,24],[146,25,146,29],[146,30,146,34],[143,35,143,37],[144,35,144,37],[146,35,146,37],[145,35,145,37],[143,0,143,4],[144,0,144,4],[146,0,146,4],[141,5,141,34],[141,0,142,4],[142,5,142,9],[142,10,142,14],[142,15,142,19],[142,20,142,24],[142,25,142,29],[142,30,142,34],[145,0,145,4],[145,5,145,9],[145,10,145,14],[145,15,145,19],[145,20,145,24],[145,25,145,29],[145,30,145,34],[143,20,143,24],[143,25,143,29],[143,30,143,34],[144,10,144,14],[144,15,144,19],[144,20,144,24],[141,35,142,37],[143,5,143,9],[144,5,144,9],[146,5,146,9],[143,10,143,14],[143,15,143,19],[137,0,137,37],[104,0,104,37],[105,0,105,36],[107,0,107,36],[109,0,109,36],[106,0,106,37],[108,0,108,37],[110,0,110,37],[111,0,111,36],[112,0,112,37],[113,0,113,36],[114,0,114,37],[115,0,115,37],[116,0,116,36],[117,0,117,37],[118,0,118,36],[119,0,119,37],[120,0,120,36],[122,0,122,36],[123,0,123,37],[135,0,135,3],[135,4,135,8],[136,0,136,3],[136,4,136,8],[135,33,135,36],[136,33,136,36],[135,9,135,32],[136,9,136,32],[132,0,132,1],[132,2,132,7],[132,9,132,15],[132,17,132,22],[132,23,132,24],[132,25,132,29],[132,30,132,31],[133,0,133,37],[134,0,134,37],[129,2,129,6],[129,7,129,8],[129,9,129,20],[129,22,129,28],[129,29,129,30],[129,31,129,32],[129,34,129,37],[130,0,130,36],[131,0,131,1],[131,2,131,23],[131,25,131,35],[131,36,131,37],[100,34,100,37],[103,0,103,3],[103,4,103,10],[103,33,103,36],[103,11,103,32],[127,0,127,1],[127,2,127,6],[127,7,127,8],[127,9,127,20],[127,22,127,28],[127,29,127,30],[127,31,127,32],[127,34,127,37],[126,0,126,3],[126,16,126,17],[121,0,121,37],[126,4,126,15],[9,31,9,37],[37,0,37,36],[38,0,38,36],[9,24,9,30],[9,6,9,23],[30,11,30,32],[30,33,30,36],[10,0,10,36],[33,0,33,3],[30,0,30,3],[30,4,30,10],[31,0,31,3],[31,4,31,10],[32,0,32,3],[22,30,22,37],[27,22,27,27],[27,28,27,29],[32,4,32,10],[31,11,31,32],[32,11,32,32],[27,34,27,37],[26,0,26,2],[26,3,26,11],[11,0,11,37],[126,18,126,26],[126,27,126,29],[126,30,126,37],[97,0,97,4],[31,33,31,36],[32,33,32,36],[33,33,33,36],[33,11,33,32],[97,22,97,23],[97,32,97,33],[97,24,97,31],[97,5,97,21],[97,34,97,37],[65,0,65,6],[81,0,81,6],[70,22,70,27],[70,28,70,29],[70,30,70,32],[70,34,70,37],[74,31,74,35],[74,36,74,37],[75,0,75,2],[75,3,75,10],[75,11,75,30],[8,0,8,37],[9,0,9,5],[61,0,61,37],[62,0,62,2],[62,3,62,14],[62,15,62,17],[62,18,62,26],[62,27,62,29],[62,30,62,37],[59,18,59,26],[59,27,59,29],[59,30,59,37],[60,0,60,1],[60,2,60,6],[60,7,60,8],[60,9,60,20],[60,22,60,28],[60,29,60,30],[60,31,60,32],[60,34,60,37],[43,31,43,33],[21,0,21,37],[42,34,42,37],[42,23,42,27],[88,31,88,35],[88,36,88,37],[89,0,89,2],[89,3,89,10],[89,11,89,30],[89,31,89,35],[89,36,89,37],[75,31,75,35],[75,36,75,37],[76,0,76,2],[76,3,76,10],[76,11,76,30],[76,31,76,35],[85,31,85,32],[85,33,85,37],[86,0,86,1],[86,2,86,20],[76,36,76,37],[77,0,77,2],[77,3,77,10],[77,11,77,30],[77,31,77,35],[77,36,77,37],[78,0,78,2],[138,0,138,37],[139,0,139,37],[124,0,124,36],[83,0,83,1],[83,2,83,20],[83,22,83,27],[83,28,83,29],[83,30,83,32],[83,34,83,37],[84,0,84,3],[84,4,84,12],[84,14,84,19],[84,20,84,24],[84,25,84,31],[84,32,84,33],[84,34,84,37],[85,0,85,2],[85,3,85,11],[85,13,85,19],[85,20,85,22],[85,23,85,30],[88,0,88,2],[88,3,88,10],[88,11,88,30],[63,9,63,20],[63,22,63,28],[198,14,198,24],[43,28,43,30],[194,0,194,37],[195,0,195,37],[57,0,57,37],[99,0,99,37],[68,20,68,24],[68,25,68,31],[68,32,68,33],[68,34,68,37],[69,0,69,2],[69,3,69,11],[69,13,69,19],[69,20,69,22],[69,23,69,30],[69,31,69,32],[43,23,43,27],[44,23,44,27],[45,23,45,27],[46,23,46,27],[96,0,96,37],[196,0,196,11],[200,27,200,37],[199,0,199,1],[199,2,199,11],[199,12,199,13],[199,14,199,24],[199,25,199,26],[199,27,199,37],[200,0,200,1],[200,2,200,11],[200,12,200,13],[200,14,200,24],[23,0,23,2],[35,0,35,36],[198,0,198,1],[198,2,198,11],[98,0,98,37],[125,0,125,3],[125,4,125,10],[125,33,125,36],[125,11,125,32],[128,0,128,3],[128,4,128,15],[128,16,128,17],[128,18,128,26],[43,0,43,22],[196,12,196,24],[128,27,128,29],[140,0,140,37],[56,0,56,37],[66,0,66,2],[66,3,66,25],[66,26,66,29],[86,22,86,27],[86,28,86,29],[86,30,86,32],[63,34,63,37],[44,0,44,22],[63,29,63,30],[63,31,63,32],[58,0,58,37],[45,34,45,37],[46,28,46,30],[46,31,46,33],[198,27,198,37],[196,25,196,37],[197,0,197,1],[197,2,197,11],[197,12,197,13],[197,14,197,24],[197,25,197,26],[197,27,197,37],[86,34,86,37],[128,30,128,37],[129,0,129,1],[59,3,59,14],[59,15,59,17],[63,0,63,1],[63,2,63,6],[63,7,63,8],[82,0,82,2],[82,3,82,25],[82,26,82,29],[82,30,82,37],[70,0,70,1],[70,2,70,20],[67,22,67,27],[67,28,67,29],[67,30,67,32],[67,34,67,37],[68,0,68,3],[68,4,68,12],[68,14,68,19],[78,3,78,10],[78,11,78,30],[78,31,78,35],[78,36,78,37],[79,0,79,2],[79,3,79,10],[79,11,79,30],[79,31,79,35],[79,36,79,37],[41,34,41,37],[42,28,42,30],[42,0,42,22],[45,0,45,22],[40,23,41,27],[40,0,41,22],[43,34,43,37],[44,28,44,30],[46,0,46,22],[2,0,2,37],[200,25,200,26],[198,25,198,26],[198,12,198,13],[23,3,23,37],[29,33,29,36],[28,0,28,3],[28,4,28,10],[28,11,28,32],[28,33,28,36],[66,30,66,37],[67,0,67,1],[67,2,67,20],[29,0,29,3],[27,30,27,32],[69,33,69,37],[59,0,59,2],[24,30,24,32],[24,34,24,37],[34,0,34,36],[36,0,36,36],[27,0,27,1],[27,2,27,20],[45,28,45,30],[46,34,46,37],[42,31,42,33],[29,4,29,10],[22,24,22,29],[22,3,22,23],[25,0,25,2],[25,3,25,11],[25,13,25,18],[25,19,25,23],[25,24,25,30],[25,31,25,33],[25,34,25,37],[24,0,24,1],[24,2,24,20],[24,22,24,27],[24,28,24,29],[39,0,39,37],[45,31,45,33],[44,31,44,33],[44,34,44,37],[40,28,40,33],[40,34,40,37],[41,28,41,30],[41,31,41,33],[180,4,180,8],[180,9,180,32],[180,33,180,36],[167,0,167,10],[167,11,167,15],[170,0,170,10],[170,11,170,15],[170,16,170,22],[170,23,170,37],[171,0,171,10],[171,11,171,15],[171,16,171,22],[171,23,171,37],[174,0,174,36],[175,0,175,3],[173,0,173,37],[172,23,172,36],[172,0,172,13],[172,14,172,22],[178,21,178,22],[178,26,178,27],[178,28,178,30],[178,0,178,6],[178,15,178,16],[148,35,148,37],[149,0,149,4],[149,5,149,9],[149,10,149,14],[149,15,149,19],[149,20,149,24],[149,25,149,29],[149,30,149,34],[179,0,179,37],[149,35,149,37],[160,0,160,37],[161,0,161,37],[162,0,162,37],[163,0,163,3],[163,4,163,8],[163,9,163,32],[163,33,163,36],[165,0,165,37],[152,35,152,37],[153,0,153,4],[153,5,153,9],[153,10,153,14],[152,10,152,14],[152,15,152,19],[151,35,151,37],[150,0,150,4],[150,5,150,9],[150,15,150,19],[150,20,150,24],[150,25,150,29],[150,30,150,34],[150,35,150,37],[150,10,150,14],[147,0,147,4],[147,5,147,9],[147,10,147,14],[147,15,147,19],[147,20,147,24],[147,25,147,29],[147,30,147,34],[151,20,151,24],[151,25,151,29],[151,30,151,34],[148,25,148,29],[148,30,148,34],[159,0,159,3],[159,4,159,8],[152,5,152,9],[185,32,185,34],[157,0,157,37],[155,0,155,4],[155,5,155,9],[155,10,155,14],[155,15,155,19],[155,20,155,24],[155,25,155,29],[155,30,155,34],[155,35,155,37],[156,5,156,9],[156,10,156,14],[156,15,156,19],[156,20,156,24],[156,25,156,29],[156,30,156,34],[156,35,156,37],[156,0,156,4],[159,9,159,32],[159,33,159,36],[180,0,180,3],[187,12,187,16],[187,29,187,33],[185,35,185,37],[186,0,186,7],[186,8,186,10],[185,16,185,18],[186,19,186,21],[186,11,186,18],[181,0,181,37],[182,0,182,37],[183,0,183,37],[185,0,185,4],[185,22,185,24],[185,25,185,28],[185,29,185,31],[185,6,185,8],[185,19,185,21],[184,0,184,37],[185,10,185,15],[188,12,188,16],[188,29,188,33],[187,34,187,37],[187,23,187,28],[188,23,188,28],[187,17,187,22],[188,17,188,22],[188,34,188,37],[17,0,17,37],[18,0,18,37],[100,24,100,32],[102,0,102,37],[101,0,101,36],[187,0,191,4],[188,5,188,7],[187,5,187,7],[191,5,191,7],[190,5,190,7],[189,5,189,7],[187,8,187,11],[188,8,188,11],[189,8,189,11],[190,8,190,11],[191,8,191,11],[192,0,192,37],[193,10,193,11],[193,12,193,23],[193,24,193,25],[193,26,193,37],[189,29,189,33],[189,34,189,37],[190,12,190,16],[190,17,190,22],[190,23,190,28],[190,29,190,33],[190,34,190,37],[191,12,191,16],[191,17,191,22],[191,23,191,28],[191,29,191,33],[191,34,191,37],[189,12,189,16],[189,17,189,22],[189,23,189,28],[193,0,193,9],[12,0,12,37],[13,0,13,37],[14,0,14,37],[100,0,100,9],[100,11,100,23],[47,0,47,37],[48,0,48,37],[49,0,49,37],[50,0,50,3],[50,4,50,10],[50,11,50,36],[51,0,51,36],[52,0,52,37],[26,13,26,19],[26,20,26,22],[26,23,26,29],[26,30,26,32],[26,33,26,37],[22,0,22,2],[55,0,55,3],[55,4,55,10],[53,0,53,36],[54,0,54,37],[15,0,15,37],[16,0,16,37],[19,0,19,37],[20,0,20,37],[158,0,158,37],[55,33,55,36],[55,11,55,32],[154,0,154,4],[154,5,154,9],[154,10,154,14],[154,15,154,19],[154,20,154,24],[154,25,154,29],[154,30,154,34],[154,35,154,37],[147,35,147,37],[148,0,148,4],[148,5,148,9],[148,10,148,14],[148,15,148,19],[148,20,148,24],[151,0,151,4],[151,5,151,9],[151,10,151,14],[151,15,151,19]]}
["Overview - 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,null,{"$f":"'Serna SF Cover Page'!B42","v":"2021-03-04"}]
["The applicant must submit a complete original application and one electronic copy on CD or USB flash drive that includes a copy of the application with signatures with all files uploaded. Applications must be uploaded to the USB flash drive in Excel format. The HCD Universal Application is not required.\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application submittal date"]
["Disclosure of Application (California Public Records Act Statutes of 1968 Chapter 1473)  information provided in the application will become a public record available for review by the public, pursuant to the California Public Records Act Statutes of 1968 Chapter 1473. As such, any materials  provided will be disclosable to any person making a request under this Act. The Department cautions Applicants to use discretion in providing information not specifically requested, including but not limited to, bank accounts, personal phone numbers and home addresses. By providing this information to the Department, the Applicant is waiving any claim of confidentiality and consents to the disclosure of submitted material upon request."]
["If Project is also known under another Project name(s) or was formerly known under another name(s), enter the name(s)."]
["Have you applied, do you plan to apply, or has the Project been awarded other HCD program funds?"]
["Other HCD Program(s) Name(s):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Funding Amount",null,null,null,null,"Funding Status",null,null,null,null,null,null,null,"NOFA Date",null,null," Award Date/Expected Award Date"]
[]
[]
["Project Eligibility §7204"]
["Housing Development Name:                                                                                                                                                                                                                                      ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Development Activity §7206(b)-(c):"]
["(e) New Construction projects only:  Applicant certifies it will comply with this subsection regarding assisted unit household income and monthly housing costs?                                                                                                                                                                                                                                          "]
["Describe Project including housing type(s) - single family, townhouse, condominium, duplex; recent history of events in the selection of this site and the proposed work scope."]
[]
["Describe any innovative or other special features, and/or amenities, including any energy-efficient design or materials, which are planned for the Project."]
[]
["How do you propose to assist agricultural households in this Project, including those of low-income and very low-income?"]
[]
["Describe your capacity to undertake this Project including other housing projects developed in the last five years."]
[]
["Describe Project’s feasibility and potential obstacles to that feasibility.  How will you overcome those obstacles?"]
[]
["Applicant Requirements §7205(a) (b), §7205.1, §7205.2 and NOFA page 2"]
["Applicant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant Type §7205(a)"]
["Department"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Auth Rep ",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Authorized Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact ",null,null,null,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,"Contact Phone"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["File Name:",null,null,null,"App Cert & Legal",null,null,null,null,null,null,"See Certifications & Legal worksheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"App Resolution",null,null,null,null,null,null,"Signature required; see Applicant Documents worksheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"App Org1, App1 Org2, etc.",null,null,null,null,null,null,"See Applicant Documents worksheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Files Uploaded?"]
["File Name:",null,null,null,"App OrgChart",null,null,null,null,null,null,"See Applicant Documents worksheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"App Signature",null,null,null,null,null,null,"See Applicant Documents worksheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"App Payee Data or TIN",null,null,null,null,null,null,"See Applicant Documents worksheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(a) Applicant certifies it can demonstrate to HCD's satisfaction it is independent from any direction of, or control by, a for-profit entity and shall meet §7205.1 requirements.                                                                                                                                                                                                                                          "]
["(b)(1) Applicant certifies it has the ability to timely proceed with the construcction or rehabilitation of the development or program upon commitment of Program funds.                                                                                                                                                                                                                                          "]
["(b)(2) Applicant certifies it has sufficient experience and organizational capacity to carry out the activity for which Program funds are being requested.                                                                                                                                                                                                                                          "]
["§7205.1 Limited Partnership Applicant: Applicant certifies it shall comply with the requirements of this subsection?                                                                                                                                                                                                             "]
["§7205.2 All applicants where a nonprofit corporation is part of the ownership structure:  Applicant certifies it shall meet the requirements of this subsection?                                                                                                                                                                                                             "]
["NOFA page 2: Applicant must have successfully sponsored and supervised a new construction or local owner-occupied rehabilitation (OOR) programs for a minimum of two years within the ten years immediately preceding the application. Indicate qualifying experience below. If program is on-going at time of application, then enter application date as \"End Date\".",null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AM41-(10*365)","v":-3650}]
["Describe the Program(s) you have successfully administered within the last ten years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# of Units Constructed or Rehabilitated",null,null,null,null,"Sponsor/Supervise Period",null,null,null,null,null,"Total Years",null,null,null,{"$f":"Overview!AJ2","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Begin Date",null,null,"End Date",null,null,{"$f":"IF(SUM($AM$43:$AM$47)<=0,0,SUM($AM$43:$AM$47))","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,{"$f":"IF($AF$43>=$AM$40,$AM$43,0)","v":0},null,null,null,{"$f":"IF($AF$43=\"\",0,IF($AC$43=\"\",0,AO43-AN43)/365)","v":0},{"$f":"IF(AC43=\"\",0,IF(AC43<$AM$40,$AM$40,AC43))","v":"00:00:00"},{"$f":"IF(AF43=\"\",0,IF(AF43>$AM$41,$AM$41,AF43))","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,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($AF$44>=$AM$40,$AM$44,0)","v":0},null,null,null,{"$f":"IF($AF$43=\"\",0,IF($AC$43=\"\",0,AO44-AN44)/365)","v":0},{"$f":"IF(AC44=\"\",0,IF(AC44<$AM$40,$AM$40,AC44))","v":"00:00:00"},{"$f":"IF(AF44=\"\",0,IF(AF44>$AM$41,$AM$41,AF44))","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,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($AF$45>=$AM$40,$AM$45,0)","v":0},null,null,null,0,"00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,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($AF$46>=$AM$40,$AM$46,0)","v":0},null,null,null,0,"00:00:00","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,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($AF$47>=$AM$40,$AM$47,0)","v":0},null,null,null,0,"00:00:00","00:00:00"]
["General Requirements §7208"]
["(b) Describe the architectural and engineering requirements."]
[]
["File Name:",null,null,null,"Schematic",null,null,null,null,null,null,"Schematic Plans - include name and telephone number of architect and indicate status of design approvals."]
["(c) Applicant certifies the Project is consistent with Non-Discrimination, Affirmative Action and Fair Housing requirements including duties to affirmatively further fair housing (explain below)."]
[]
["(d) Does the Project trigger State Relocation Assistance Law (CA Gov Code §7260-7277)? If Yes, provide a narrative discussion on the number of impacted households and provided relocation assistance including what actions have or will be taken to comply with State Relocation Assistance Law? If No, provide explanation supporting  relocation is not required."]
[]
["File Name:",null,null,null,"Relocation Plan",null,null,null,null,null,null,"Applicants must provide a Relocation Plan or documentation supporting no relocation. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["Application Content Requirements §7217(c)"]
["(1) Contact Information"]
["Financial Consultant"]
["Legal Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact",null,null,null,null,null,null,null,null,null,null,null,"Contact Email"]
["Phone",null,null,null,null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"State",null,null,null,"Zip"]
["Legal Counsel"]
["Legal Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact",null,null,null,null,null,null,null,null,null,null,null,"Contact Email"]
["Phone",null,null,null,null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"State",null,null,null,"Zip"]
["In the cell below, select an applicable controlling party to the organization type in cell AE23"]
["Controlling party #1 title"]
["Legal 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,"Organization Type"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Auth Rep ",null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Authorized Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact",null,null,null,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,"Phone"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["File Name",null,null,{"$f":"CONCATENATE(H66,\" Cert & Legal\")","v":" Cert & Legal"},null,null,null,null,null,null,null,"See Certifications & Legal worksheet.",null,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,{"$f":"CONCATENATE(H66,\" Resolution\")","v":" Resolution"},null,null,null,null,null,null,null,"Signature required; see Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H66,\" OrgDoc1, OrgDoc3, etc\")","v":" OrgDoc1, OrgDoc3, etc"},null,null,null,null,null,null,null,"See Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H66,\" OrgChart\")","v":" OrgChart"},null,null,null,null,null,null,null,"See Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H66,\" Signature Block\")","v":" Signature Block"},null,null,null,null,null,null,null,"See Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H66,\" Payee Data Record\")","v":" Payee Data Record"},null,null,null,null,null,null,null,"See Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H66,\" FISCAL TIN Form\")","v":" FISCAL TIN Form"},null,null,null,null,null,null,null,"See Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H66,\" Cert of Good Standing\")","v":" Cert of Good Standing"},null,null,null,null,null,null,null,"Dated 30 days or less from the application due date.",null,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,{"$f":"CONCATENATE(H66,\" Tax-Exempt Status\")","v":" Tax-Exempt Status"},null,null,null,null,null,null,null,"Evidence of tax-exempt status from IRS and from FTB for Corporations.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["In the cell below, select an applicable controlling party to the organization type in cell AE23"]
["Controlling party #2 title"]
["Legal 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,"Organization Type"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Auth Rep",null,null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Authorized Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact",null,null,null,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,"Phone"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["File Name",null,null,{"$f":"CONCATENATE(H82,\" Cert & Legal\")","v":" Cert & Legal"},null,null,null,null,null,null,null,"See Certifications & Legal worksheet.",null,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,{"$f":"CONCATENATE(H82,\" Resolution\")","v":" Resolution"},null,null,null,null,null,null,null,"Signature required; see Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H82,\" OrgDoc1, OrgDoc3, etc\")","v":" OrgDoc1, OrgDoc3, etc"},null,null,null,null,null,null,null,"See Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H82,\" OrgChart\")","v":" OrgChart"},null,null,null,null,null,null,null,"See Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H82,\" Signature Block\")","v":" Signature Block"},null,null,null,null,null,null,null,"See Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H82,\" Payee Data Record\")","v":" Payee Data Record"},null,null,null,null,null,null,null,"See Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H82,\" FISCAL TIN Form\")","v":" FISCAL TIN Form"},null,null,null,null,null,null,null,"See Applicant Documents worksheet.",null,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,{"$f":"CONCATENATE(H82,\" Cert of Good Standing\")","v":" Cert of Good Standing"},null,null,null,null,null,null,null,"Dated 30 days or less from the application due date.",null,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,{"$f":"CONCATENATE(H82,\" Tax-Exempt Status\")","v":" Tax-Exempt Status"},null,null,null,null,null,null,null,"Evidence of tax-exempt status from IRS and from FTB for Corporations.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["(3) Project site information"]
["Development Address:                                                                                                                                                                                                                                      ",null,null,null,null,null,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,"County:"]
["Describe any special circumstances or hazards, e.g. flood plain, utility availability, multiple sites projects (provide site control info for each), other lender approvals.  "]
[]
["(A) Does Applicant have Site Control (§7207)?",null,null,null,null,null,null,null,null,null,null,"If yes, enter form of Site Control and most recent execution date:"]
["Are utilities, water and sewer services now available at Project site? If not, explain when and how you will obtain these services."]
[]
["File Name:",null,null,null,"Site Control",null,null,null,null,null,null,"Attach appropriate documentation to demonstrate the form of Site Control indicated above.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["Site Criteria §7210(a)(1) - answer and explain how the project site or location complies with each of the following:"]
["The location is in or reasonably near a residential area with access to schools, shopping, medical services, social services and employment."]
[]
["The location does not unnecessarily confine assisted units to an area in which there exists a high concentration of low income households."]
[]
["The location of housing development is not found to be inconsistent with housing element or housing assistance plan of public jurisdiction in which housing development is to be located.                                                                                                                                                                                                          "]
[]
["The characteristics of the site, including its topography and distance to public utilities, do not result in unreasonable development or rehabilitation costs."]
[]
["The site will not be in a 100 year flood plain unless sufficient measures have been taken, as determined by HCD, to ensure the security of the housing development in the event of flooding."]
[]
["Design Criteria §7210(a)(2) - answer and explain how the project design complies with each of the following:"]
["The design will provide safe, sanitary, and decent housing meeting the requirements of all applicable building and housing standards and codes."]
[]
["The design to the maximum extent feasible, is compatible with the existing community in which the housing development will be located."]
[]
["To the maximum extent feasible, the design of the improvements, the materials and the mechanical equipment to be used, and the siting of the structures shall be consistent with effective energy conservation design principles."]
[]
["The design provides for a cost effective use of grant funds in order to achieve affordable housing costs for agricultural households."]
[]
["(B) Provide a current preliminary title report (within six months of application submittal date)."]
["File Name:",null,null,null,"Preliminary Title",null,null,null,null,null,null,"Provide preliminary title report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(C) Current owner:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact:",null,null,null,null,null,null,null,null,null,null,"Contact Email"]
["Phone",null,null,null,null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"State",null,null,null,"Zip"]
["Proposed owner:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact:",null,null,null,null,null,null,null,null,null,null,"Contact Email"]
["Phone",null,null,null,null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"State",null,null,null,"Zip"]
["(D) Can you provide documentation of completion and approval or adoption of all necessary environmental clearances including those required under the CEQA and if applicable, NEPA?"]
["NEPA:",null,"Is Federal funding proposed that will trigger NEPA requirements?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If Yes, enter date of \"Authority to Use Grant Funds\""]
["CEQA:",null,"Project approved \"by-right\"?",null,null,null,null,null,null,"Is Project Categorically Exempt?",null,null,null,null,null,null,null,"Negative Declaration Date:",null,null,null,null,null,null,null,"Final EIR Date:"]
["Discuss below any special NEPA and/or CEQA Special Circumstances or exemptions and provide estimated/actual completion dates of all necessary environmental clearances."]
[]
["File Name:",null,null,null,"Environmental",null,null,null,null,"Copy of all environmental clearances (e.g. Environmental Impact Report, Phase 1, Phase 2) or Notice of Exemption.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"Auth to Use Grant Funds",null,null,null,null,"For NEPA only, copy of HUD 7015.16 \"Authority To Use Grant Funds\" or clarify the status of issuance of HUD form.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(4) Proposed Improvements"]
["Describe the proposed improvements both residential and commercial, and a timetable for construction (start, completion, occupancy)."]
[]
["(6) and (7) Detailed Cost Breakdown / Sources and Uses"]
["Uses of Funds §7209.5(a)",null,null,null,null,"Sources of 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,"Total"]
[null,null,null,null,null,"HCD Serna",null,null,null,null,"Other funding source",null,null,null,null,"Other funding source",null,null,null,null,"Other funding source",null,null,null,null,"Other funding source",null,null,null,null,"Other funding source"]
["(1) Land Acquisition",null,null,null,null,null,null,null,null,null,null,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":"F144+K144+P144+U144+Z144+AE144","v":0}]
["(2) Site Development",null,null,null,null,null,null,null,null,null,null,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":"F145+K145+P145+U145+Z145+AE145","v":0}]
["(3) Professional fees",null,null,null,null,null,null,null,null,null,null,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":"F146+K146+P146+U146+Z146+AE146","v":0}]
["(4) Reports, plans, permits",null,null,null,null,null,null,null,null,null,null,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]
["(5) Insurance and financing",null,null,null,null,null,null,null,null,null,null,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":"F148+K148+P148+U148+Z148+AE148","v":0}]
["(6) Construction or 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,{"$f":"F149+K149+P149+U149+Z149+AE149","v":0}]
["(7) Land improvements",null,null,null,null,null,null,null,null,null,null,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]
["(8) Profit and overhead",null,null,null,null,null,null,null,null,null,null,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":"F151+K151+P151+U151+Z151+AE151","v":0}]
["(9) Reserves",null,null,null,null,null,null,null,null,null,null,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":"F152+K152+P152+U152+Z152+AE152","v":0}]
["(10) Repay predevelop. loan",null,null,null,null,null,null,null,null,null,null,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]
["(11) ADA modifications",null,null,null,null,null,null,null,null,null,null,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":"F154+K154+P154+U154+Z154+AE154","v":0}]
["(12) Relocation",null,null,null,null,null,null,null,null,null,null,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":"F155+K155+P155+U155+Z155+AE155","v":0}]
["(13) Solar; energy efficiencies",null,null,null,null,null,null,null,null,null,null,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":"F156+K156+P156+U156+Z156+AE156","v":0}]
["Total",null,null,null,null,{"$f":"SUM(F144:J156)","v":0},null,null,null,null,{"$f":"SUM(K144:O156)","v":0},null,null,null,null,{"$f":"SUM(P144:T156)","v":0},null,null,null,null,{"$f":"SUM(U144:Y156)","v":0},null,null,null,null,{"$f":"SUM(Z144:AD156)","v":0},null,null,null,null,{"$f":"SUM(AE144:AI156)","v":0},null,null,null,null,0]
["Describe the terms and conditions of funding, other than HCD, that is being proposed and the current status of such funding. Attach letters of commitment or applications for funding."]
[]
["File Name:",null,null,null,"Fund Source Name",null,null,null,null,"Copies of letters of commitments, applications for funding or funding commitments for each funding source above.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(8) Method of Construction or Rehabilitation"]
["Describe the method of construction or rehabilitation and on the architectural, engineering and legal services to be provided. Include copies of contracts for these services."]
[]
["File Name:",null,null,null,"Contract 1, 2, 3, etc.",null,null,null,null,"Copy of all architectural, engineering and legal service contracts.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(9) Review and Approval by the Required State and Local Officials"]
["If applicable, provide a listing and status of all discretionary local land use entitlements and permits, excluding design review, required to complete the Project that have been granted, submitted or to be applied for to the appropriate local agencies, or consistent with local planning documents."]
["Agency / Issuer",null,null,null,null,null,null,null,null,null,null,"Land Use Approval Date ",null,null,null,null,"Approval Type",null,null,null,null,null,null,"Comments"]
[]
[]
[]
[]
[]
["What is the current zoning classification of the development site?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the development site currently zoned for the proposed use?"]
["(10) Market Analysis"]
["Provide a market study or market analysis which supports the need for the proposed housing and includes the characteristics of the persons eligible for occupancy including income and estimates of the number of eligible occupants willing and able to occupy the proposed housing. This market analysis shall specifically address the demand for agricultural worker housing and the ability of local agricultural workers to pay the rents or housing costs proposed in the application."]
["File Name:",null,null,null,"Market Analysis",null,null,null,null,"Provide a completed market study or analysis (prepared within one year of the application date).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(11) Income Ranges of the Agricultural Households to be Served (Assisted units)"]
["Proposed annual household income range:                                                                                                                                                                                                                ",null,null,null,null,null,null,null,null,null,null,null,"to",null,null,null,"County Median Income",null,null,null,null,null,null,null,"Percentage of household costs to minimum income",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ179=0,0,AJ179/J178)","v":0}]
["Est. monthly household costs:                                                                                                                                                                                                                ",null,null,null,null,null,null,"Mortgages",null,null,null,"Taxes/Ins.",null,null,null,"Utilities",null,null,null,"Fees",null,null,null,"Maint/Repairs",null,null,null,null,"Monthly costs",null,null,{"$f":"J179+N179+R179+V179+AA179","v":0},null,"Annual",null,{"$f":"AF179*12","v":0}]
["(13) Current Financial Statements for Nonprofit Organization Applicants"]
["File Name:",null,null,null,"Financial Statement",null,null,null,null,"Applicant to provide most recent financial statement (balance sheet and income statement); not required for public entity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(14) Related Facilities"]
["Describe any facilities planned for the Project."]
[]
[{"$f":"\"Homeownership \"&AF10&\" Application Content Requirements §7217(e)\"","v":"Homeownership  Application Content Requirements §7217(e)"}]
["Number of Project units:",null,null,null,null,null,"Assisted units",null,null,null,"Grant amt. per Assisted unit:",null,null,null,null,null,{"$f":"IF(AF10=\"Owner Occupied Rehabilitation\",75000,150000)","v":150000},null,null,"Max grant:",null,null,{"$f":"IF(AM10=\"Owner Occupied Rehabilitation\",MIN(2000000,J186*Q186),MIN(3000000,J186*Q186))","v":0},null,null,"Requested amt:",null,null,null,{"$f":"F157","v":0},null,null,"HCD Grant:",null,null,{"$f":"MIN(W186,AD186)","v":0}]
["Average Serna grant per Assisted unit:",null,null,null,null,null,null,null,{"$f":"AJ186/J186","v":{"$error":"#DIV/0!"}},null,null,"Total Project development cost per unit:",null,null,null,null,null,null,null,{"$f":"IF(F186=0,0,AJ157/F186)","v":0}]
["Pro-rata share of the grant applied to each assisted unit",null,null,null,null,"Unit Size",null,null,"# of Assited units",null,null,null,{"$f":"IF(AF10=\"Owner Occupied Rehabilitation\",\"Proposed Rehab Amt.\",\"Proposed Sales Price\")","v":"Proposed Sales Price"},null,null,null,null,"(a) Proposed 1st Mortgage",null,null,null,null,null,"(b) HCD Serna Assistance",null,null,null,null,null,"(c) Other Assistance",null,null,null,null,"Total (a)+(b)+(c)"]
[null,null,null,null,null,"1-Bedroom",null,null,null,null,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":"SUM(R189:AH189)","v":0}]
[null,null,null,null,null,"2-Bedroom",null,null,null,null,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":"SUM(R190:AH190)","v":0}]
[null,null,null,null,null,"3-Bedroom",null,null,null,null,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]
[null,null,null,null,null,"4-Bedroom",null,null,null,null,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]
["§7209(b) Percentage of assisted units must not be less than percentage of grant versus total development costs"]
["Percentage of Assisted units vs. total units:",null,null,null,null,null,null,null,null,null,{"$f":"IF(F186=0,0,J186/F186)","v":0},null,"Percentage of HCD grant vs. total development costs:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ157=0,0,AJ186/AJ157)","v":0},null,{"$f":"IF(K194<Y194,\"Fails threshold, increase Assisted Units or lower costs\",\"Passes this threshold requirement\")","v":"Passes this threshold requirement"}]
["Legislator Information"]
["Indicate all Legislators who represent any portion of the proposed Project area. If you have vacancies in your legislative seats, list your district number and address. "]
["Members of the State Assembly",null,null,null,null,null,null,null,null,null,null,null,"Members of the State Senate",null,null,null,null,null,null,null,null,null,null,null,null,"Members of the of the U.S. House of Representatives"]
["District #",null,"Name",null,null,null,null,null,null,null,null,null,"District #",null,"Name",null,null,null,null,null,null,null,null,null,null,"District #",null,"Name"]

{"sheet":"Certification & Legal","index":2,"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],[38,35,38,37],[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],[20,0,20,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],[19,0,19,37],[11,0,11,8],[11,10,11,18],[11,20,11,33],[11,35,11,37],[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],[10,0,10,8],[10,10,10,18],[10,20,10,33],[10,35,10,37],[0,0,0,35],[0,36,0,37],[1,0,1,37],[2,0,2,37],[3,0,3,37],[4,0,4,37],[5,0,5,37],[6,0,6,37],[7,0,7,37],[8,0,8,37],[9,0,9,37]]}
["Certification & Legal Disclosure",null,null,null,null,null,null,null,null,null,null,null,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":"'Serna SF Cover Page'!B42","v":"2021-03-04"}]
["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 party 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,"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 & Legal Explanation",null,null,null,null,null,null,null,"Letter of explanation for any \"Yes\" answers or red shaded items 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,"Date"]

{"sheet":"Applicant Documents","index":3,"n_rows":24,"n_cols":37,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,23,37],[17,0,17,37],[18,0,18,37],[19,0,19,37],[20,0,20,37],[21,0,21,37],[22,0,22,37],[16,0,16,37],[5,0,5,37],[6,0,6,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],[15,0,15,37],[4,0,4,37],[0,0,0,35],[0,36,0,37],[1,0,1,37],[2,0,2,37],[3,0,3,37]]}
["Required Applicant Documentation",null,null,null,null,null,null,null,null,null,null,null,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":"'Serna SF Cover Page'!B42","v":"2021-03-04"}]
["Certifications & Legal Disclosure"]
["A completed and signed Certification is required for each Joint Applicant. Each Joint Applicant must sign an individual Certification form. A completed and signed Legal Disclosure is also required for each Joint Applicant. The hard copy Certifications & Legal Disclosure should be submitted with the application as detailed in the NOFA."]
["Resolutions"]
["Applicant may use their own Resolution format as long as it contains ALL of the authorizations as in the sample.\nThe person attesting to the resolution signing cannot be the same person authorized to execute the documents in the name of the applicant.\nIf more than one authorized signatory is identified, state whether both signatories are required or only one signatory is required to submit and execute Program docs.\nIf the application is being signed by a designee of the authorized signatory, the applicant must also submit a designee letter or other proof of signing authority."]
["A resolution is required of each Joint Applicant - both private and public entities.  A sample resolution template is available on the Serna website. "]
["Organizational Documents"]
["Organizational documents are required for all Applicants, except where a joint applicant is a governmental entity.  Governmental entities are not required to submit organizational documents with the application.   "]
["Submit organizational documents supporting the Resolution submitted with the application."]
["Corporation organizational documents"]
["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."]
["Any other CA Secretary of State filings applicable to revivals, conversions or mergers."]
["Limited Liability Company organizational documents"]
["Articles of Organization (CA Secretary of State form LLC-1)\nCertificate of Amendment (CA Secretary of State form LLC-2) if applicable.\nRestated Articles of Organization (CA Secretary of State form LLC-10) if applicable.\nCertificate of Correction (CA Secretary of State form LLC-11) if applicable.\nStatement of Information (CA Secretary of State form LLC-12 or LLC-12NC)\nOperating Agreement (Corp. Code §17707.02(s) and 17701.10.)\nCertificate of Good Standing certified by Secretary of State."]
["Any other CA Secretary of State filings applicable to revivals, conversions or mergers."]
["Limited Partnership organizational documents"]
["Certificate of Limited Partnership (CA Secretary of State form LP-1)\nAmendment to Certificate of Limited Partnership (CA Secretary of State form LP-2) if applicable.\nCertificate of Correction (CA Secretary of State form LP-2) if applicable.\nLimited Partnership Agreement (CA Corp. Code §15901.02(x) and 15901.10)\nCertificate of Good Standing certified by Secretary of State."]
["Any other CA Secretary of State filings applicable to revivals, conversions or mergers."]
["Organizational Chart"]
["The Organizational chart must depict the organizational structure of the entities in relation to the applicant."]
["Signature Block"]
["All Applicants must submit a Signature Block in a Microsoft Word Document that will be used in the HCD legal documents such as the Standard Agreement."]
["Payee Data Record STD-204 or Taxpayer Identification Number (TIN)"]
["The TIN must be submitted by all governmental entity Applicants.  All other Applicants must submit the STD-204 Payee Data Record. Forms available on Serna website."]

{"sheet":"Application Support","index":4,"n_rows":31,"n_cols":43,"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],[3,0,3,3],[3,4,3,14],[3,15,3,16],[3,17,3,27],[3,28,3,31],[3,32,3,37],[0,0,0,34],[0,35,0,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":"'Serna SF Cover Page'!B42","v":"2021-03-04"}]
["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 & Round",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,"Serna SF",null,null,null,null,null,null,null,null,null,null,null,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"},"Coverpage"]
[2,null,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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"},"Overview"]
[3,null,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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"},"Application Support"]
[4,null,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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,"Serna MF",null,null,null,null,null,null,null,null,null,null,null,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"]

{"sheet":"Unit Des Table","index":5,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Limited Partnership","Limited Liability Company","Non-profit Corporation","Public Agency","Governing Body of Indian Reservation","Governing Body of Indian Rancheria","Tribally Designated Housing Entity"]
["General Partner","Manager","President","Chairperson of the Board","Tribal Council Leader","Tribal Council Leader","Tribal Council Leader"]
["Co-General Partner","Member","Chief Executive Officer","Chief Executive Officer","Tribal Council Representative","Tribal Council Representative","Tribal Council Representative"]
["Managing General Partner","Member/Manager","Vice President","Chief Administrative Officer","Authorized Federal Official","Authorized Federal Official","Authorized Federal Official"]
["Administrative General Partner",null,"Chief Operating Officer","City Manager"]
[null,null,"Treasurer","Assistant City Manager"]
[null,null,"Chief Financial Officer","Finance Director"]
[null,null,"Secretary","Chief Financial Officer"]
[null,null,null,"Mayor"]
[null,null,null,"Chancellor"]
[null,null,null,"Superintendent"]
[null,null,null,"Director"]
[null,null,null,"Secretary"]

{"sheet":"NEW MAPPING","index":6,"n_rows":7,"n_cols":650,"rows_kept":7,"cut":false,"hidden":true,"merged":[[1,110,1,115],[1,453,1,471],[1,128,1,135],[1,201,1,209],[1,210,1,212],[1,147,1,150],[1,145,1,146],[1,214,1,231],[1,368,1,375],[1,396,1,414],[1,415,1,433],[1,434,1,452],[1,31,1,32],[1,80,1,81],[1,105,1,106],[0,11,0,17],[0,18,0,23],[0,24,0,29],[0,66,0,71],[0,72,0,77],[1,44,1,51],[1,52,1,59],[0,91,0,96],[0,97,0,102]]}
[null,null,null,null,null,null,null,null,null,null,null,"Applicant Requirements §7205(a) (b), §7205.1, §7205.2 and NOFA page 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(11) Income Ranges of the Agricultural Households to be Served (Assisted units)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," §7217 Application Content Requirements"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"App Resolution",null,null,null,null,null,null,null,null,null,null,null,null,"Financial Consultant",null,null,null,null,null,null,null,"Legal Counsel",null,null,null,null,null,null,null,"Managing General Partner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Administrative General Partner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},null,null,null,null,"(3) Project site information",null,null,null,null,null,null,"Site Criteria §7210(a)(1) ",null,null,null,null,"Design Criteria §7210(a)(2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEPA:",null,"CEQA:",null,null,null,null,null,null,null,null,null,null,null,null,"Est. monthly household costs:          ",null,null,null,null,null,null,null,{"$f":"Overview!A185","v":"Homeownership  Application Content Requirements §7217(e)"},null,null,null,null,null,null,null,"1 BEDROOM",null,null,null,null,null,"2 BEDROOMS",null,null,null,null,null,"3 BEDROOMS",null,null,null,null,null,"4 BEDROOMS",null,null,null,null,null,null,"§7222. Environmental Clearances.",null,null,null,null,null,null,null,null,"§7207. Site Control Requirements. ",null,null,"Relocation","(c)(1) Contact Information Owner/Borrower Entity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In the cell below, select an authorized party related to the Organization Type in cell AE4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In the cell below, select an authorized party related to the Organization Type in cell AE4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In the cell below, select an authorized party related to the Organization Type in cell AE4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Property Management Agent",null,null,null,null,null,null,null,"Financial Consultant",null,null,null,null,null,null,null,"Primary Service Provider",null,null,null,null,null,null,null,"Borrower Legal Counsel",null,null,null,null,null,null,null,"General Contractor",null,null,null,null,null,null,null,"Architect",null,null,null,null,null,null,null,"Rent/Operating Subsidy Source ",null,null,null,null,null,null,null,"Rent/Operating Subsidy Source ",null,null,null,null,null,null,null,"(c)(3) Project Site Information",null,null,null,null,null,"Site Criteria §7210(a)(1)",null,null,null,null,"Design Criteria §7210(a)(2)",null,null,null,"(B) Provide a current preliminary title report (within six months of application submittal date).",null,null,null,null,null,null,null,"(D) Environmental Clearances §7222","Application # 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner/Borrower Entity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Managing General Partner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGP #1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGP #2"]
["Count","Portal Submission #","HCD Contract #","CAPES #","Received Date & Times","Region","Rural","Housing Development Name","Development Activity §7206(b)-(c):","(e) New Construction projects only:  Applicant certifies it will comply with this subsection regarding assisted unit household income and monthly housing costs?                ","Application submittal Date","Applicant Name","Applicant Type §7205(a)","Department","Address","City ","State","Zip","Auth. Rep","Title","Email","Phone","Contact ","Title","Email","Phone","Address","City","State","Zip","App Cert & Legal - Uploaded to HCD","Copy Submitted","File Uploaded","(a) Applicant certifies it can demonstrate to HCD's satisfaction it is independent from any direction of, or control by, a for-profit entity and shall meet §7205.1 requirements. ","(b)(1) Applicant certifies it has the ability to timely proceed with the construcction or rehabilitation of the development or program upon commitment of Program funds.   ","(b)(2) Applicant certifies it has sufficient experience and organizational capacity to carry out the activity for which Program funds are being requested.   ","§7205.1 Limited Partnership Applicant: Applicant certifies it shall comply with the requirements of this subsection?           ","§7205.2 All applicants where a nonprofit corporation is part of the ownership structure:  Applicant certifies it shall meet the requirements of this subsection?   ","App Org1, App1 Org2, etc. - Uploaded to HCD","App OrgChart - Uploaded to HCD","App Signature - Uploaded to HCD","Payee Data Record STD-204 or Taxpayer Identification Number (TIN)","Schematic - Uploaded to HCD","Relocation Plan - Uploaded to HCD","Legal Name","Contact","Email","Phone","Address","City","State","Zip","Legal Name","Contact","Email","Phone","Address","City","State","Zip","Legal Name","Organization Type","Address","City ","State","Zip","Auth. Rep","Title","Auth Rep. Email","Phone","Contact ","Title","Contact Email","Phone","Address","City","State","Zip",{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},"Copy Submitted","File Uploaded to HCD",{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},"Legal Name","Organization Type","Address","City ","State","Zip","Auth. Rep","Title","Auth Rep. Email","Phone","Contact ","Title","Contact Email","Phone","Address","City","State","Zip",{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},"Copy Submitted","File Uploaded to HCD",{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},"Development Address","City","County","(A) Does Applicant have Site Control (§7207)?","If yes, enter form of Site Control ","and most recent execution date:","Site Control - Uploaded to HCD","The location is in or reasonably near a residential area with access to schools, shopping, medical services, social services and employment.","The location does not unnecessarily confine assisted units to an area in which there exists a high concentration of low income households.","The location of housing development is not found to be inconsistent with housing element or housing assistance plan of public jurisdiction in which housing development is to be located.   ","The characteristics of the site, including its topography and distance to public utilities, do not result in unreasonable development or rehabilitation costs.","The site will not be in a 100 year flood plain unless sufficient measures have been taken, as determined by HCD, to ensure the security of the housing development in the event of flooding.","The design will provide safe, sanitary, and decent housing meeting the requirements of all applicable building and housing standards and codes.","The design to the maximum extent feasible, is compatible with the existing community in which the housing development will be located.","To the maximum extent feasible, the design of the improvements, the materials and the mechanical equipment to be used, and the siting of the structures shall be consistent with effective energy conservation design principles.","The design provides for a cost effective use of grant funds in order to achieve affordable housing costs for agricultural households.","(B) Provide a current preliminary title report (within six months of application submittal date).","Preliminary Report - Uploaded to HCD","(C) Current owner:","Contact","Contact Email","Phone","Address","City","State","Zip","Proposed Owner","Contact","Contact Email","Phone","Address","City","State","Zip","(D) Can you provide documentation of completion and approval or adoption of all necessary environmental clearances including those required under the CEQA and if applicable, NEPA?","Is Federal funding proposed that will trigger NEPA requirements?","If Yes, enter date of \"Authority to Use Grant Funds\"","Project approved \"by-right\"?","Is Project Categorically Exempt?","Negative Declaration Date:","Final EIR Date:","Environmental - Uploaded to HCD","Auth to Use Grant Funds - Uploaded to HCD","Fund Source Name - Uploaded to HCD","Contract 1, 2, 3, etc. - Uploaded to HCD","Market Analysis - Uploaded to HCD","Proposed annual household income range:   ","To:","County Median Income","Percentage of household costs to minimum income","Mortgages","Taxes/ Ins.","Utilities","Fees","Maint. Repairs","Monthly Cost","Annual","Financial Statement - Uploaded to HCD","Number of Project units:","Assisted units","Grant amt. per Assisted unit:","Max grant:","Requested amt:","HCD Grant:","Average Serna grant per Assisted unit:","Total Project development cost per unit:","# of Assited units",{"$f":"Overview!M188","v":"Proposed Sales Price"},"(a) Proposed 1st Mortgage","(b) HCD Serna Assistance","(c) Other Assistance","Total (a)+(b)+©","# of Assited units",{"$f":"Overview!M188","v":"Proposed Sales Price"},"(a) Proposed 1st Mortgage","(b) HCD Serna Assistance","(c) Other Assistance","Total (a)+(b)+©","# of Assited units",{"$f":"Overview!M188","v":"Proposed Sales Price"},"(a) Proposed 1st Mortgage","(b) HCD Serna Assistance","(c) Other Assistance","Total (a)+(b)+©","# of Assited units",{"$f":"Overview!M188","v":"Proposed Sales Price"},"(a) Proposed 1st Mortgage","(b) HCD Serna Assistance","(c) Other Assistance","Total (a)+(b)+©",null,"For the RHD, Applicant(s) have completion and approval or adoption of all necessary environmental clearances NEPA & CEQA","NEPA\nIs Federal funding proposed that will trigger NEPA requirements? ","If Yes, enter date of \"Authority to Use Grant Funds\".","Describe special circumstances","CEQA\nProject approved \"by-right\"?","Is Project Categorically Exempt?","Negative Declaration Date:","Final EIR Date:","Describe special circumstances","Does applicant or Developer of Project have Site Control for the RHD Project? ","Form of Site Control","Most recent document execution date:","Does_Project_trigger_State_Relocation\nROW 225","Legal Name","Org Type","Adress ","City ","State","Zip","Auth Rep Name","Title","Email","Phone","Contact_Name","Title","Contact_Email","Contact_Phone ","Address","City","State ","Zip","In the cell below, select an authorized party related to the Organization Type in cell AE4","Legal Name","Organization Type","Adress ","City ","State","Zip","Auth_Rep_Name","Title","Authorized_Rep_Email","Phone","Contact_Name","Title","Contact_Email","Contact_Phone ","Address","City","State ","Zip","In the cell below, select an authorized party related to the Organization Type in cell AE4","Legal Name","Organization Type","Adress ","City ","State","Zip","Auth_Rep_Name","Title","Authorized_Rep_Email","Phone","Contact_Name","Title","Contact_Email","Contact_Phone ","Address","City","State ","Zip","In the cell below, select an authorized party related to the Organization Type in cell AE4","Legal Name","Organization Type","Adress ","City ","State","Zip","Auth_Rep_Name","Title","Authorized_Rep_Email","Phone","Contact_Name","Title","Contact_Email","Contact_Phone ","Address","City","State ","Zip","Legal Name","Contact","Email","Phone","Address","City","State","Zip","Legal Name","Contact","Email","Phone","Address","City","State","Zip","Legal Name","Contact","Email","Phone","Address","City","State","Zip","Legal Name","Contact","Email","Phone","Address","City","State","Zip","Legal Name","Contact","Email","Phone","Address","City","State","Zip","Legal Name","Contact","Email","Phone","Address","City","State","Zip","Legal Name","Contact","Email","Phone","Address","City","State","Zip","Legal Name","Contact","Email","Phone","Address","City","State","Zip","Total Land Area in Acres:","Commercial Square Feet","(A) Applicant has Site Control (§7207)?","If yes, enter Site Control type","Execution Date for Site Control","Are utilities, water and sewer services now available at Project site? ","The Project is in or reasonably near a residential area with access to schools, shopping, medical services, social services and employment.","The Project does not unnecessarily confine Assisted units to an area in which there exists a high concentration of low income households.","The Project is not found to be inconsistent with housing element or housing assistance plan of public jurisdiction in which the Project is located.        ","The characteristics of the site, including its topography and distance to public utilities, do not result in unreasonable development or rehabilitation costs.","The site will not be in a 100 year flood plain unless sufficient measures have been taken, as determined by HCD, to ensure the security of the housing development in the event of flooding.","The design will provide safe, sanitary, and decent housing meeting the requirements of all applicable building and housing standards and codes.","The design to the maximum extent feasible, is compatible with the existing community in which the housing development will be located.","To the maximum extent feasible, the design of the improvements, the materials and the mechanical equipment to be used, and the siting of the structures shall be consistent with effective energy conservation design principles.","The design provides for a cost effective use of grant funds in order to achieve affordable housing costs for agricultural households.","(C) Owner:","Contact","Contact Email","Phone","Address","City","State","Zip","Is the Project free from severe adverse environmental conditions that are economically infeasible to remove and cannot be mitigated? ","Entity Name","Eligible Applicant","Organization Type","Adress ","City ","State","Zip","Auth_Rep_Name","Title","Authorized_Rep_Email","Phone","Contact_Name","Title","Contact_Email","Contact_Phone ","Address","City","State ","Zip","Entity Name","Eligible Applicant","Organization Type","Adress ","City ","State","Zip","Auth_Rep_Name","Title","Authorized_Rep_Email","Phone","Contact_Name","Title","Contact_Email","Contact_Phone ","Address","City","State ","Zip","(Managing_General_Partner)_Legal_Name","Eligible Applicant","Organization_Type","Address","City ","State ","Zip","Auth_Rep_Name","Title","Authorized_Rep_Email","Phone ","Contact_Name","Title","Contact_Email","Phone","Address","City","Sate ","Zip","(Administrative General Partner #1) Legal Name","Eligible Applicant","Organization_Type","Address","City ","State ","Zip","Auth_Rep_Name","Title","Authorized_Rep._Email","Phone ","Contact Name","Title","Contact_Email","Phone","Address","City","Sate ","Zip","(Administrative_General_Partner_#2)_Legal_Name","Eligible Applicant","Organization_Type","Address","City ","State ","Zip","Auth_Rep_Name","Title","Authorized_Rep_Email","Phone ","Contact Name","Title","Contact_Email","Phone","Address","City","Sate ","Zip","Property_Management_Agent_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","Zip","Financial_Consultant_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","Zip","Lead(primary)Service_ Provider_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","Zip","Borrower_Legal_Counsel_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","Zip","General_Contractor_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","Zip","Architect_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","Zip","Development_Funding_Source_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","Zip","Development_Funding_Source_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","zip","Development_Funding_Source_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","zip","Development_Funding_Source_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","zip","Development_Funding_Source_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","Zip","Development_Funding_Source_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","Zip","Rent/Operating_Subsidy_Source_Legal_Name","Contact_Name","Contact_Email","Phone","Address","City","State","Zip","Enter_Name_Entity_Qualifying_for_Experience:"," Lead_Service_Provider_Name","Relationship_to_Sponsor","Staffing_ratios: Total_MHP_Assisted_Units","Total_FTE","#_of_MHP_Units_per_FTE_Staff","Total_MHP_Assisted_units_Chronically_Homeless","Total_Case_manager_FTE_reserved_SH_Chronically_Honeless_only","Number_of_MHP_Assisted_units_for_SH_Chronically_Homeless_per_case_manager_FTE ","Total_MHP_Assisted_units_for_SNP_Homeless_with_Disability","Total_case_manager_FTE_devoted_to_tenants_in_units_reserved_for_SNP_Homeless_with_Disability_only","Number_of_MHP_Assisted_units_for_SNP_Homeless_with_Disability_per_case_manager_FTE","Total_MHP_Assisted_units_for_those_SNP_Other_Homeless","Total_Case_manager_FTE_Devoted_to_Tenants_in_units_reserved_for_those_Exiting_Institutions_only","Number_of_MHP_Assisted_units_SNP_Other_Homeless _per_case_managers_FTE","Total_MHP_Assisted_units","Total_Supportive _Services_Expenses","Total_Supportive_Services_Expenses_per_Unit","Not_Required_for_this_Project(CEQA)","Not_Required_for_this_Project(NEPA)","Final_date_of_Public_Comment_ Period(CEQA)","Final_Date_ of_Public_Comment_ Period(NEPA)","Approved _Date(CEQA)","Approved _Date(NEPA)","Not_Required_for_this_Project(Nessary_Discretionary_nondiscressionarry_public_land_udr_approval)","Not_Required_for_this_Project(design_Review)","Verified_Complete and date completed(Nessary_Discretionary_nondiscressionarry_public_land_udr_approval)","Verified_Complete_and_date_completed(design_Review)","Is_ project_located_ in_an_area_shown_on_TCAC/HCD_Opportunity_Area_Map ","If_Yes_ Select _or_ Enter_TCAC/HCD_Opportunity_Area_Map_Tract_ID_#","Opportunity_Area_Map_Category","Unit_info(A)","Unit_info(B)","Unit_info(C)","Unit_info(C)","Unit_info(D)","Unit_info(D)","MHP_Assisted_Units_Lareg_Family(E)","MHP_Assisted_Units_Special_Need(F)","MHP_Assisted_Units_Senior_Housing(G)","MHP_Assisted_Units_Sup_Housing(H)","MHP_Assisted_Units_AT_High_Risk(I)","MHP_Assisted_Units_Other_Assisted(I)","Total_MHP_Assisted_Units","Other_Restricted_Units_Large_Family(E) ","Other_Restricted_Units_Special_Needs(F)","Other_Restricted_Units_Senior_Housing(G)","Other_Restricted_Units_Suup_Housing(H)","Other_Restricted_Units_At_High_Risk(I)","Other_Restricted_Units_Other_RU","Other_Restricted_Units_total_other_RU","Total_RU","Other_HCD_Assisted_Units","#_of_Other_HCD_ Assisted_Units","Total_Project_Cost","Less:Net_Syndication_Proceeds/Investor_Equity","Less:Additional_Owner/General_Partner_Equity","Total_Estimated_Financing_Need"," Less:Supportable_Conventional_or_Bond Debt_Financing"," Less:\"Soft\"_Financing_and_Grants","Funding_Gap","1.Total_Residential_Development_Cost","2a.Gross_sq._footage_ of_Restricted_units","2b.Gross_square_footage_of_all_Residential_units","3.Restricted_square footage_as_%_of_total","4.MHP Residential_Dev_cost_on_%_of_Restricted_sq._footage","Total_Self_Score","Serving_Lowest_ Income_ Levels","Addressing_Most_Serious_Local_Housing_Need","Development_and_Ownership_Experience"," Leverage_of_Other_Funds","Project_Readiness","Adaptive Reuse /Infill/Proximity_to_Amenities","Tiebreaker_Score "]
[null,null,null,null,null,null,null,{"$f":"Overview!G10","v":0},{"$f":"Overview!AF10","v":0},{"$f":"Overview!AL11","v":0},{"$f":"Overview!AJ2","v":0},{"$f":"Overview!D23","v":0},{"$f":"Overview!AE23","v":0},{"$f":"Overview!D24","v":0},{"$f":"Overview!C25","v":0},{"$f":"Overview!W25","v":0},{"$f":"Overview!AE25","v":0},{"$f":"Overview!AI25","v":0},{"$f":"Overview!D26","v":0},{"$f":"Overview!N26","v":0},{"$f":"Overview!Y26","v":0},{"$f":"Overview!AI26","v":0},{"$f":"Overview!D27","v":0},{"$f":"Overview!N27","v":0},{"$f":"Overview!X27","v":0},{"$f":"Overview!AH27","v":0},{"$f":"Overview!C28","v":0},{"$f":"Overview!W28","v":0},{"$f":"Overview!AE28","v":0},{"$f":"Overview!AI28","v":0},{"$f":"Overview!AL29","v":0},{"$f":"Overview!AG30","v":0},{"$f":"Overview!AL30","v":0},{"$f":"Overview!AL35","v":0},{"$f":"Overview!AL36","v":0},{"$f":"Overview!AL37","v":0},{"$f":"Overview!AL38","v":0},{"$f":"Overview!AL39","v":0},{"$f":"Overview!AL31","v":0},{"$f":"Overview!AL32","v":0},{"$f":"Overview!AL33","v":0},{"$f":"Overview!AL34","v":0},{"$f":"Overview!AL51","v":0},{"$f":"Overview!AL56","v":0},{"$f":"Overview!D60","v":0},{"$f":"Overview!S60","v":0},{"$f":"Overview!AE60","v":0},{"$f":"Overview!C61","v":0},{"$f":"Overview!J61","v":0},{"$f":"Overview!W61","v":0},{"$f":"Overview!AF61","v":0},{"$f":"Overview!AI61","v":0},{"$f":"Overview!D63","v":0},{"$f":"Overview!S63","v":0},{"$f":"Overview!AE63","v":0},{"$f":"Overview!C64","v":0},{"$f":"Overview!J64","v":0},{"$f":"Overview!W64","v":0},{"$f":"Overview!AF64","v":0},{"$f":"Overview!AI64","v":0},{"$f":"Overview!D67","v":0},{"$f":"Overview!AE67","v":0},{"$f":"Overview!C68","v":0},{"$f":"Overview!W68","v":0},{"$f":"Overview!AE68","v":0},{"$f":"Overview!AI68","v":0},{"$f":"Overview!E69","v":0},{"$f":"Overview!O69","v":0},{"$f":"Overview!Z69","v":0},{"$f":"Overview!AI69","v":0},{"$f":"Overview!D70","v":0},{"$f":"Overview!N70","v":0},{"$f":"Overview!X70","v":0},{"$f":"Overview!AH70","v":0},{"$f":"Overview!C71","v":0},{"$f":"Overview!W71","v":0},{"$f":"Overview!AE71","v":0},{"$f":"Overview!AI71","v":0},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!D83","v":0},{"$f":"Overview!AE83","v":0},{"$f":"Overview!C84","v":0},{"$f":"Overview!W84","v":0},{"$f":"Overview!AE84","v":0},{"$f":"Overview!AI84","v":0},{"$f":"Overview!E85","v":0},{"$f":"Overview!O85","v":0},{"$f":"Overview!Z85","v":0},{"$f":"Overview!AI85","v":0},{"$f":"Overview!D86","v":0},{"$f":"Overview!N86","v":0},{"$f":"Overview!X86","v":0},{"$f":"Overview!AH86","v":0},{"$f":"Overview!C87","v":0},{"$f":"Overview!W87","v":0},{"$f":"Overview!AE87","v":0},{"$f":"Overview!AI87","v":0},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!#REF!","v":{"$error":"#REF!"}},{"$f":"Overview!F98","v":0},{"$f":"Overview!Y98","v":0},{"$f":"Overview!AI98","v":0},{"$f":"Overview!K101","v":0},{"$f":"Overview!Y101","v":0},{"$f":"Overview!AI101","v":0},{"$f":"Overview!AL104","v":0},{"$f":"Overview!AL106","v":0},{"$f":"Overview!AL108","v":0},{"$f":"Overview!AL110","v":0},{"$f":"Overview!AL112","v":0},{"$f":"Overview!AL114","v":0},{"$f":"Overview!AL117","v":0},{"$f":"Overview!AL119","v":0},{"$f":"Overview!AL121","v":0},{"$f":"Overview!AL123","v":0},{"$f":"Overview!AL125","v":0},{"$f":"Overview!AL126","v":0},{"$f":"Overview!E127","v":0},{"$f":"Overview!S127","v":0},{"$f":"Overview!AE127","v":0},{"$f":"Overview!C128","v":0},{"$f":"Overview!J128","v":0},{"$f":"Overview!W128","v":0},{"$f":"Overview!AF128","v":0},{"$f":"Overview!AI128","v":0},{"$f":"Overview!E129","v":0},{"$f":"Overview!S129","v":0},{"$f":"Overview!AE129","v":0},{"$f":"Overview!C130","v":0},{"$f":"Overview!J130","v":0},{"$f":"Overview!W130","v":0},{"$f":"Overview!AF130","v":0},{"$f":"Overview!AI130","v":0},{"$f":"Overview!AL131","v":0},{"$f":"Overview!Y132","v":0},{"$f":"Overview!AK132","v":0},{"$f":"Overview!I133","v":0},{"$f":"Overview!Q133","v":0},{"$f":"Overview!X133","v":0},{"$f":"Overview!AE133","v":0},{"$f":"Overview!AL136","v":0},{"$f":"Overview!AL137","v":0},{"$f":"Overview!AL160","v":0},{"$f":"Overview!AL164","v":0},{"$f":"Overview!AL176","v":0},{"$f":"Overview!J178","v":0},{"$f":"Overview!N178","v":0},{"$f":"Overview!V178","v":0},{"$f":"Overview!AJ178","v":0},{"$f":"Overview!J179","v":0},{"$f":"Overview!N179","v":0},{"$f":"Overview!R179","v":0},{"$f":"Overview!V179","v":0},{"$f":"Overview!AA179","v":0},{"$f":"Overview!AF179","v":0},{"$f":"Overview!AJ179","v":0},{"$f":"Overview!AL181","v":0},{"$f":"Overview!F186","v":0},{"$f":"Overview!J186","v":0},{"$f":"Overview!Q186","v":150000},{"$f":"Overview!W186","v":0},{"$f":"Overview!AD186","v":0},{"$f":"Overview!AJ186","v":0},{"$f":"Overview!I187","v":{"$error":"#DIV/0!"}},{"$f":"Overview!T187","v":0},{"$f":"Overview!I189","v":0},{"$f":"Overview!M189","v":0},{"$f":"Overview!R189","v":0},{"$f":"Overview!X189","v":0},{"$f":"Overview!AD189","v":0},{"$f":"Overview!AI189","v":0},{"$f":"Overview!I190","v":0},{"$f":"Overview!M190","v":0},{"$f":"Overview!R190","v":0},{"$f":"Overview!X190","v":0},{"$f":"Overview!AD190","v":0},{"$f":"Overview!AI190","v":0},{"$f":"Overview!I191","v":0},{"$f":"Overview!M191","v":0},{"$f":"Overview!R191","v":0},{"$f":"Overview!X191","v":0},{"$f":"Overview!AD191","v":0},{"$f":"Overview!AI191","v":0},{"$f":"Overview!I192","v":0},{"$f":"Overview!M192","v":0},{"$f":"Overview!R192","v":0},{"$f":"Overview!X192","v":0},{"$f":"Overview!AD192","v":0},{"$f":"Overview!AI192","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"DROPDOWNS","index":7,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["SERNA","SERNA","SERNA","SERNA","SERNA"]
[]
[" ","Local public entity",null,null,"     "]
["Single Family New Construction","Non-profit corporation"," ","Fee Title","Alameda","Townhouse","Conventional"]
["Owner-Occupied Rehabilitation","Limitied liability company","Yes","Leasehold Interest","Alpine","Single Family","FHA"]
["Acquisition of Manufactured Homes","Limited partnership","No","Enforceable Option to Lease or Purchase","Amador","Condominium","CalHFA"]
["Migrant farmworker assistance",null,null,"Disposition and Development Agreement","Butte","Duplex/Triplex","USDA-Rural Development"]
[null,null,null,"Exclusive Right to Negotiate","Calaveras","Manufactured Housing","Federal HOME"]
[null,null,null,"Sales Contract","Colusa","Other (describe in narrative below)","Redevelopment Agency"]
[null,null,null,"Other (describe below)","Contra Costa",null,"Other"]
[null,null,null,null,"Del Norte"]
[null,null,null,null,"El Dorado"]
[null,null,null,null,"Fresno"]
[null,null," ",null,"Glenn"]
["  ",null,"N/A",null,"Humboldt"]
["SERNA ",null,"YES",null,"Imperial"]
[null,null,"NO",null,"Inyo"]
[null,null,null,null,"Kern"]
[null,null,null,null,"Kings"]
[null,null," ",null,"Lake"]
[null,null,"N/A",null,"Lassen"]
[null,null,"Include",null,"Los Angeles"]
[null,null,"Not Included",null,"Madera"]
[null,null,null,null,"Marin"]
[null,null,null,null,"Mariposa"]
[null,null,null,null,"Mendocino"]
[null,null,null,null,"Merced"]
[null,null,null,null,"Modoc"]
[null,null,null,null,"Mono"]
[null,null,null,null,"Monterey"]
[null,null,null,null,"Napa"]
[null,null,null,null,"Nevada"]
[null,null,null,null,"Orange"]
[null,null,null,null,"Placer"]
[null,null,null,null,"Plumas"]
[null,null,null,null,"Riverside"]
[null,null,null,null,"Sacramento"]
[null,null,null,null,"San Benito"]
[null,null,null,null,"San Bernardino"]
[null,null,null,null,"San Diego"]
[null,null,null,null,"San Francisco"]
[null,null,null,null,"San Joaquin"]
[null,null,null,null,"San Luis Obispo"]
[null,null,null,null,"San Mateo"]
[null,null,null,null,"Santa Barbara"]
[null,null,null,null,"Santa Clara"]
[null,null,null,null,"Santa Cruz"]
[null,null,null,null,"Shasta"]
[null,null,null,null,"Sierra"]
[null,null,null,null,"Siskiyou"]
[null,null,null,null,"Solano"]
[null,null,null,null,"Sonoma"]
[null,null,null,null,"Stanislaus"]
[null,null,null,null,"Sutter"]
[null,null,null,null,"Tehama"]
[null,null,null,null,"Trinity"]
[null,null,null,null,"Tulare"]
[null,null,null,null,"Tuolumne"]
[null,null,null,null,"Ventura"]
[null,null,null,null,"Yolo"]
[null,null,null,null,"Yuba"]