{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Serna Cover Page","Overview","Application Support","DROPDOWNS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":168,"comments":1,"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 Cover Page","index":0,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,2],[43,0,43,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],[42,0,42,22],[27,0,27,22],[4,0,4,22],[5,0,5,22],[7,0,7,22],[24,0,24,22],[25,0,25,22]]}
[]
[]
[]
[]
["Joe Serna, Jr. Farmworker Housing Grant Program"]
["Single Family New Construction and Owner-Occupied Rehabilitation Application"]
[]
["2019 NOTICE OF FUNDING AVAILABILITY"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State of California"]
["Governor Gavin Newsom"]
[]
["Alexis Podesta, Secretary"]
["Business, Consumer Services and Housing Agency"]
[]
["Douglas R. McCauley, Acting Director"]
["Department of Housing and Community Development (HCD)"]
[]
[]
["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"]
["Application Technical Support email:"]
["AppSupport@hcd.ca.gov"]
[]
["December 26, 2019"]
[]
["Rev.","2019-12-19"]

{"sheet":"Overview","index":1,"n_rows":196,"n_cols":41,"rows_kept":196,"cut":false,"hidden":false,"merged":[[39,4,39,8],[39,9,39,10],[157,0,157,3],[157,4,157,8],[157,9,157,32],[157,33,157,36],[10,0,10,37],[11,0,11,37],[14,0,14,37],[15,0,15,37],[6,0,6,37],[7,0,7,37],[8,0,8,37],[9,0,9,37],[98,0,98,9],[98,11,98,23],[53,0,53,37],[54,0,54,37],[55,0,55,37],[56,0,56,3],[56,4,56,10],[56,11,56,36],[57,0,57,36],[58,0,58,37],[21,13,21,19],[21,20,21,22],[21,23,21,29],[21,30,21,32],[21,33,21,37],[17,0,17,2],[190,0,190,37],[191,10,191,11],[191,12,191,23],[191,24,191,25],[191,26,191,37],[187,29,187,33],[187,34,187,37],[188,12,188,16],[188,17,188,22],[188,23,188,28],[188,29,188,33],[188,34,188,37],[186,12,186,16],[186,29,186,33],[185,34,185,37],[185,23,185,28],[186,23,186,28],[185,17,185,22],[186,17,186,22],[186,34,186,37],[12,0,12,37],[13,0,13,37],[98,24,98,32],[100,0,100,37],[99,0,99,36],[189,12,189,16],[189,17,189,22],[189,23,189,28],[189,29,189,33],[189,34,189,37],[185,0,189,4],[186,5,186,7],[185,5,185,7],[189,5,189,7],[188,5,188,7],[187,5,187,7],[185,8,185,11],[186,8,186,11],[187,8,187,11],[188,8,188,11],[189,8,189,11],[187,12,187,16],[187,17,187,22],[187,23,187,28],[185,12,185,16],[185,29,185,33],[183,35,183,37],[184,0,184,7],[184,8,184,10],[183,16,183,18],[184,19,184,21],[184,11,184,18],[179,0,179,37],[180,0,180,37],[181,0,181,37],[183,0,183,4],[183,22,183,24],[183,25,183,28],[183,29,183,31],[183,6,183,8],[183,19,183,21],[156,0,156,37],[182,0,182,37],[183,10,183,15],[61,0,61,3],[61,4,61,10],[59,0,59,36],[60,0,60,37],[61,33,61,36],[61,11,61,32],[152,0,152,4],[152,5,152,9],[152,10,152,14],[152,15,152,19],[152,20,152,24],[152,25,152,29],[152,30,152,34],[152,35,152,37],[80,11,80,32],[80,33,80,36],[92,11,92,32],[92,33,92,36],[150,0,150,4],[150,5,150,9],[183,32,183,34],[155,0,155,37],[153,0,153,4],[153,5,153,9],[153,10,153,14],[153,15,153,19],[153,20,153,24],[153,25,153,29],[153,30,153,34],[153,35,153,37],[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],[154,0,154,4],[145,35,145,37],[146,0,146,4],[146,5,146,9],[146,10,146,14],[146,15,146,19],[146,20,146,24],[149,0,149,4],[149,5,149,9],[149,10,149,14],[149,15,149,19],[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],[149,20,149,24],[149,25,149,29],[149,30,149,34],[149,35,149,37],[148,0,148,4],[148,5,148,9],[148,15,148,19],[177,0,177,37],[178,0,178,3],[178,4,178,8],[178,9,178,32],[178,33,178,36],[165,0,165,10],[165,11,165,15],[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],[172,0,172,36],[173,0,173,3],[171,0,171,37],[170,23,170,36],[170,0,170,13],[170,14,170,22],[176,21,176,22],[176,26,176,27],[176,28,176,30],[17,30,17,37],[17,24,17,29],[17,3,17,23],[20,0,20,2],[20,3,20,11],[20,13,20,18],[20,19,20,23],[20,24,20,30],[20,31,20,33],[20,34,20,37],[19,0,19,1],[19,2,19,20],[19,22,19,27],[19,28,19,29],[74,33,74,37],[65,0,65,2],[19,30,19,32],[19,34,19,37],[40,0,40,36],[42,0,42,36],[22,0,22,1],[22,2,22,20],[22,22,22,27],[22,28,22,29],[37,4,37,10],[36,11,36,32],[37,11,37,32],[46,23,47,27],[46,0,47,22],[69,9,69,20],[69,22,69,28],[22,34,22,37],[21,0,21,2],[21,3,21,11],[52,34,52,37],[48,31,48,33],[25,4,25,10],[34,0,34,37],[65,3,65,14],[65,15,65,17],[69,0,69,1],[69,2,69,6],[69,7,69,8],[191,0,191,9],[2,0,2,37],[198,25,198,26],[196,25,196,26],[196,12,196,13],[18,3,18,37],[25,11,25,27],[25,28,25,31],[25,33,25,36],[23,0,23,3],[23,4,23,10],[23,11,23,32],[23,33,23,36],[71,30,71,37],[72,0,72,1],[72,2,72,20],[24,0,24,37],[25,0,25,3],[22,30,22,32],[64,0,64,37],[51,34,51,37],[52,28,52,30],[52,31,52,33],[51,28,51,30],[45,0,45,37],[51,31,51,33],[50,31,50,33],[50,34,50,37],[46,28,46,33],[46,34,46,37],[47,28,47,30],[47,31,47,33],[47,34,47,37],[48,28,48,30],[48,0,48,22],[51,0,51,22],[126,30,126,37],[127,0,127,1],[49,34,49,37],[50,28,50,30],[52,0,52,22],[83,0,83,2],[83,3,83,25],[83,26,83,29],[83,30,83,37],[75,0,75,1],[75,2,75,20],[72,22,72,27],[72,28,72,29],[72,30,72,32],[72,34,72,37],[73,0,73,3],[73,4,73,12],[73,14,73,19],[69,34,69,37],[79,0,79,3],[79,4,79,10],[50,0,50,22],[69,29,69,30],[69,31,69,32],[196,27,196,37],[194,25,194,37],[195,0,195,1],[195,2,195,11],[195,12,195,13],[195,14,195,24],[195,25,195,26],[195,27,195,37],[18,0,18,2],[41,0,41,36],[196,0,196,1],[196,2,196,11],[96,0,96,37],[123,0,123,3],[123,4,123,10],[123,33,123,36],[123,11,123,32],[126,0,126,3],[126,4,126,15],[126,16,126,17],[126,18,126,26],[49,0,49,22],[194,12,194,24],[126,27,126,29],[198,27,198,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],[198,0,198,1],[198,2,198,11],[198,12,198,13],[198,14,198,24],[194,0,194,11],[136,0,136,37],[137,0,137,37],[138,0,138,37],[62,0,62,37],[81,0,81,3],[81,4,81,10],[71,0,71,2],[71,3,71,25],[71,26,71,29],[77,4,77,10],[77,11,77,32],[77,33,77,36],[87,22,87,27],[87,28,87,29],[87,30,87,32],[87,34,87,37],[88,11,88,32],[88,33,88,36],[93,0,93,3],[93,4,93,10],[92,0,92,3],[92,4,92,10],[91,0,91,3],[196,14,196,24],[49,28,49,30],[192,0,192,37],[193,0,193,37],[63,0,63,37],[97,0,97,37],[80,4,80,10],[73,20,73,24],[73,25,73,31],[73,32,73,33],[73,34,73,37],[74,0,74,2],[74,3,74,11],[74,13,74,19],[74,20,74,22],[74,23,74,30],[74,31,74,32],[49,23,49,27],[50,23,50,27],[51,23,51,27],[52,23,52,27],[91,11,91,32],[91,33,91,36],[94,0,94,37],[91,4,91,10],[89,0,89,3],[89,4,89,10],[89,11,89,32],[122,0,122,36],[84,0,84,1],[84,2,84,20],[84,22,84,27],[84,28,84,29],[84,30,84,32],[84,34,84,37],[85,0,85,3],[85,4,85,12],[85,14,85,19],[85,20,85,24],[85,25,85,31],[85,32,85,33],[85,34,85,37],[88,4,88,10],[86,0,86,2],[86,3,86,11],[86,13,86,19],[86,20,86,22],[86,23,86,30],[86,31,86,32],[86,33,86,37],[87,0,87,1],[87,2,87,20],[90,0,90,3],[90,4,90,10],[90,11,90,27],[90,28,90,31],[90,33,90,36],[88,0,88,3],[78,0,78,3],[78,4,78,10],[78,11,78,27],[78,28,78,31],[78,33,78,36],[80,0,80,3],[75,22,75,27],[75,28,75,29],[75,30,75,32],[75,34,75,37],[76,0,76,3],[76,4,76,10],[77,0,77,3],[3,0,3,37],[4,0,4,5],[67,0,67,37],[68,0,68,2],[68,3,68,14],[68,15,68,17],[68,18,68,26],[68,27,68,29],[68,30,68,37],[65,18,65,26],[65,27,65,29],[65,30,65,37],[66,0,66,1],[66,2,66,6],[66,7,66,8],[66,9,66,20],[66,22,66,28],[66,29,66,30],[66,31,66,32],[66,34,66,37],[49,31,49,33],[16,0,16,37],[48,34,48,37],[48,23,48,27],[124,18,124,26],[124,27,124,29],[124,30,124,37],[95,0,95,4],[36,33,36,36],[37,33,37,36],[39,33,39,36],[39,11,39,32],[76,33,76,36],[76,11,76,32],[79,33,79,36],[81,33,81,36],[79,11,79,32],[81,11,81,32],[95,22,95,23],[95,32,95,33],[95,24,95,31],[95,5,95,21],[95,34,95,37],[93,11,93,32],[93,33,93,36],[70,0,70,6],[82,0,82,6],[89,33,89,36],[4,31,4,37],[43,0,43,36],[44,0,44,36],[4,24,4,30],[4,6,4,23],[26,0,26,37],[27,0,27,37],[28,0,28,37],[29,0,29,37],[30,0,30,37],[31,0,31,37],[32,0,32,37],[33,0,33,37],[35,11,35,32],[35,33,35,36],[5,0,5,36],[38,0,38,37],[39,0,39,3],[35,0,35,3],[35,4,35,10],[36,0,36,3],[36,4,36,10],[37,0,37,3],[127,31,127,32],[127,34,127,37],[128,0,128,36],[129,0,129,1],[129,2,129,23],[129,25,129,35],[129,36,129,37],[98,34,98,37],[101,0,101,3],[101,4,101,10],[101,33,101,36],[101,11,101,32],[125,0,125,1],[125,2,125,6],[125,7,125,8],[125,9,125,20],[125,22,125,28],[125,29,125,30],[125,31,125,32],[125,34,125,37],[124,0,124,3],[124,16,124,17],[119,0,119,37],[124,4,124,15],[120,0,120,36],[121,0,121,37],[133,0,133,3],[133,4,133,8],[134,0,134,3],[134,4,134,8],[133,33,133,36],[134,33,134,36],[133,9,133,32],[134,9,134,32],[130,0,130,1],[130,2,130,7],[130,9,130,15],[130,17,130,22],[130,23,130,24],[130,25,130,29],[130,30,130,31],[131,0,131,37],[132,0,132,37],[127,2,127,6],[127,7,127,8],[127,9,127,20],[127,22,127,28],[127,29,127,30],[139,35,140,37],[141,5,141,9],[142,5,142,9],[144,5,144,9],[141,10,141,14],[141,15,141,19],[135,0,135,37],[102,0,102,37],[103,0,103,36],[105,0,105,36],[107,0,107,36],[104,0,104,37],[106,0,106,37],[108,0,108,37],[109,0,109,36],[110,0,110,37],[111,0,111,36],[112,0,112,37],[113,0,113,37],[114,0,114,36],[115,0,115,37],[116,0,116,36],[117,0,117,37],[118,0,118,36],[141,0,141,4],[142,0,142,4],[144,0,144,4],[139,5,139,34],[139,0,140,4],[140,5,140,9],[140,10,140,14],[140,15,140,19],[140,20,140,24],[140,25,140,29],[140,30,140,34],[143,0,143,4],[143,5,143,9],[143,10,143,14],[143,15,143,19],[143,20,143,24],[143,25,143,29],[143,30,143,34],[141,20,141,24],[141,25,141,29],[141,30,141,34],[142,10,142,14],[142,15,142,19],[142,20,142,24],[142,25,142,29],[142,30,142,34],[144,10,144,14],[144,15,144,19],[144,20,144,24],[144,25,144,29],[144,30,144,34],[141,35,141,37],[142,35,142,37],[144,35,144,37],[143,35,143,37],[148,20,148,24],[148,25,148,29],[148,30,148,34],[148,35,148,37],[150,35,150,37],[151,0,151,4],[151,5,151,9],[151,10,151,14],[150,10,150,14],[150,15,150,19],[150,20,150,24],[150,25,150,29],[150,30,150,34],[148,10,148,14],[151,15,151,19],[151,20,151,24],[151,25,151,29],[151,30,151,34],[151,35,151,37],[146,25,146,29],[146,30,146,34],[146,35,146,37],[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],[147,35,147,37],[158,0,158,37],[159,0,159,37],[160,0,160,37],[161,0,161,3],[161,4,161,8],[161,9,161,32],[161,33,161,36],[163,0,163,37],[164,0,164,10],[164,11,164,15],[164,16,164,22],[164,23,164,37],[162,0,162,37],[173,4,173,8],[173,33,173,36],[173,9,173,32],[165,16,165,22],[165,23,165,37],[166,0,166,10],[166,11,166,15],[166,16,166,22],[166,23,166,37],[167,0,167,10],[167,11,167,15],[167,16,167,22],[167,23,167,37],[1,0,1,30],[1,31,1,34],[1,35,1,37],[0,0,0,37],[176,0,176,6],[176,15,176,16],[176,19,176,20],[176,23,176,25],[176,11,176,12],[174,0,174,37],[175,9,175,11],[175,13,175,15],[175,16,175,20],[175,21,175,23],[175,0,175,8],[176,7,176,8],[176,31,176,32],[176,33,176,34],[176,35,176,37],[175,24,175,34],[175,35,175,37],[176,9,176,10],[176,13,176,14],[176,17,176,18]]}
["Joe Serna, Jr. Farmworker Housing Grant Program Single Family New Construction and Owner-Occupied Rehabilitation Application"]
["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."]
["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,"Certification & Legal Disclosure (required except where Applicant is a governmental entity). Click here for form:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["The resolution template is intended to be a sample. Applicants may use their own format as long as it contains ALL of the authorizations contained in the template.\n▪ The person attesting to the signing of the resolution cannot be the same person authorized to execute the documents in the name of the applicant.\n▪ If more than one authorized signatory is identified in the resolution, state whether both signatories are required or only one signatory is required to submit and execute Program documents.\n▪ If 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."]
["File Name:",null,null,null,"App Resolution",null,null,null,null,null,null,"Wet signature required; a resolution template is available on Serna website",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy submitted",null,null,null,null,"File Uploaded?"]
["Corporation organizational documents §7217(c)(12)(A)"]
["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 §7217(c)(12)(B)"]
["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 §7217(c)(12)(C)"]
["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."]
["File Name:",null,null,null,"App Org1, App1 Org2, etc.",null,null,null,null,null,null,"Organizational Documents; required except for government entities; Org docs must support resolution",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,"Organizational Chart",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,"Signature Block (Upload as Microsoft Word Doc); used in HCD legal docs such as a Standard Agreement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["Applicant or party that receives HCD funding must submit a Payee Data Record or Taxpayer Identification Number (TIN) form. The TIN must be submitted by all governmental entities. All others must submit the STD-204 Payee Data Record. A wet signature original must be submitted to HCD."]
["File Name:",null,null,null,"App Payee Data or",null,null,null,null,"TIN",null,"Payee Data Record STD-204 or Taxpayer Identification Number (TIN)",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":"AM47-(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$49:$AM$53)<=0,0,SUM($AM$49:$AM$53))","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$49>=$AM$46,$AM$49,0)","v":0},null,null,null,{"$f":"IF($AF$49=\"\",0,IF($AC$49=\"\",0,AO49-AN49)/365)","v":0},{"$f":"IF(AC49=\"\",0,IF(AC49<$AM$46,$AM$46,AC49))","v":"00:00:00"},{"$f":"IF(AF49=\"\",0,IF(AF49>$AM$47,$AM$47,AF49))","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$50>=$AM$46,$AM$50,0)","v":0},null,null,null,{"$f":"IF($AF$49=\"\",0,IF($AC$49=\"\",0,AO50-AN50)/365)","v":0},{"$f":"IF(AC50=\"\",0,IF(AC50<$AM$46,$AM$46,AC50))","v":"00:00:00"},{"$f":"IF(AF50=\"\",0,IF(AF50>$AM$47,$AM$47,AF50))","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$51>=$AM$46,$AM$51,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$52>=$AM$46,$AM$52,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$53>=$AM$46,$AM$53,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"]
[{"$f":"IF(AE18=\"Limited liability company\",\"Member #1\",\"Managing General Partner\")","v":"Managing General Partner"},null,null,null,null,null,null,{"$f":"IF(AE18=\"Limited liability company\",\"M1\",\"MGP\")","v":"MGP"}]
["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,null,{"$f":"H71&\" Org1, AGP1 Org2, etc.\"","v":"MGP Org1, AGP1 Org2, etc."},null,null,null,null,null,null,"Organizational Documents; required except for government entities; Org docs must support resolution",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,{"$f":"H71&\" Cert & Legal\"","v":"MGP Cert & Legal"},null,null,null,null,null,null,"Certification & Legal Disclosure (required except where Applicant is a governmental entity). Click here for form:",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,{"$f":"H71&\" Resolution\"","v":"MGP Resolution"},null,null,null,null,null,null,"Wet signature required; see below, a sample reso is available on Serna website",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy submitted",null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,{"$f":"H71&\" OrgChart\"","v":"MGP OrgChart"},null,null,null,null,null,null,"Organizational Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,{"$f":"H71&\" Signature\"","v":"MGP Signature"},null,null,null,null,null,null,"Signature Block (Upload as Microsoft Word Doc); used in HCD legal docs such as a Standard Agreement",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,{"$f":"H71&\" Payee Data or TIN\"","v":"MGP Payee Data or TIN"},null,null,null,null,null,null,"Payee Data Record STD-204 or Taxpayer Identification Number (TIN); see below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
[{"$f":"IF(AE30=\"Limited liability company\",\"Member #2\",\"Administrative General Partner\")","v":"Administrative General Partner"},null,null,null,null,null,null,{"$f":"IF(AE30=\"Limited liability company\",\"M2\",\"AGP\")","v":"AGP"}]
["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,null,{"$f":"H83&\" Org1, AGP1 Org2, etc.\"","v":"AGP Org1, AGP1 Org2, etc."},null,null,null,null,null,null,"Organizational Documents; required except for government entities; Org docs must support resolution",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,{"$f":"H83&\" Cert & Legal\"","v":"AGP Cert & Legal"},null,null,null,null,null,null,"Certification & Legal Disclosure (required except where Applicant is a governmental entity). Click here for form:",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,{"$f":"H83&\" Resolution\"","v":"AGP Resolution"},null,null,null,null,null,null,"Wet signature required; see below, a sample reso is available on Serna website",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy submitted",null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,{"$f":"H83&\" OrgChart\"","v":"AGP OrgChart"},null,null,null,null,null,null,"Organizational Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,{"$f":"H83&\" Signature\"","v":"AGP Signature"},null,null,null,null,null,null,"Signature Block (Upload as Microsoft Word Doc); used in HCD legal docs such as a Standard Agreement",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,{"$f":"H83&\" Payee Data or TIN\"","v":"AGP Payee Data or TIN"},null,null,null,null,null,null,"Payee Data Record STD-204 or Taxpayer Identification Number (TIN); see below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(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":"F142+K142+P142+U142+Z142+AE142","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":"F143+K143+P143+U143+Z143+AE143","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":"F144+K144+P144+U144+Z144+AE144","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":"F146+K146+P146+U146+Z146+AE146","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":"F147+K147+P147+U147+Z147+AE147","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":"F149+K149+P149+U149+Z149+AE149","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":"F150+K150+P150+U150+Z150+AE150","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":"F152+K152+P152+U152+Z152+AE152","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":"F153+K153+P153+U153+Z153+AE153","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":"F154+K154+P154+U154+Z154+AE154","v":0}]
["Total",null,null,null,null,{"$f":"SUM(F142:J154)","v":0},null,null,null,null,{"$f":"SUM(K142:O154)","v":0},null,null,null,null,{"$f":"SUM(P142:T154)","v":0},null,null,null,null,{"$f":"SUM(U142:Y154)","v":0},null,null,null,null,{"$f":"SUM(Z142:AD154)","v":0},null,null,null,null,{"$f":"SUM(AE142:AI154)","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(AJ177=0,0,AJ177/J176)","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":"J177+N177+R177+V177+AA177","v":0},null,"Annual",null,{"$f":"AF177*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 \"&AF5&\" 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(AF5=\"Owner Occupied Rehabilitation\",75000,150000)","v":150000},null,null,"Max grant:",null,null,{"$f":"IF(AM5=\"Owner Occupied Rehabilitation\",MIN(2000000,J184*Q184),MIN(3000000,J184*Q184))","v":0},null,null,"Requested amt:",null,null,null,{"$f":"F155","v":0},null,null,"HCD Grant:",null,null,{"$f":"MIN(W184,AD184)","v":0}]
["Average Serna grant per Assisted unit:",null,null,null,null,null,null,null,{"$f":"AJ184/J184","v":{"$error":"#DIV/0!"}},null,null,"Total Project development cost per unit:",null,null,null,null,null,null,null,{"$f":"IF(F184=0,0,AJ155/F184)","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(AF5=\"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(R187:AH187)","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(R188:AH188)","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(F184=0,0,J184/F184)","v":0},null,"Percentage of HCD grant vs. total development costs:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ155=0,0,AJ184/AJ155)","v":0},null,{"$f":"IF(K192<Y192,\"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":"Application Support","index":2,"n_rows":31,"n_cols":42,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,29,30,31],[30,32,30,34],[30,35,30,37],[30,0,30,1],[30,2,30,4],[30,5,30,8],[30,9,30,14],[30,15,30,16],[30,17,30,28],[29,0,29,1],[29,2,29,4],[29,5,29,8],[29,9,29,14],[29,15,29,16],[29,17,29,28],[29,29,29,31],[29,32,29,34],[29,35,29,37],[28,0,28,1],[28,2,28,4],[28,5,28,8],[28,9,28,14],[28,15,28,16],[28,17,28,28],[28,29,28,31],[28,32,28,34],[28,35,28,37],[26,29,26,31],[26,32,26,34],[26,35,26,37],[27,0,27,1],[27,2,27,4],[27,5,27,8],[27,9,27,14],[27,15,27,16],[27,17,27,28],[27,29,27,31],[26,0,26,1],[26,2,26,4],[26,5,26,8],[26,9,26,14],[26,15,26,16],[26,17,26,28],[27,32,27,34],[27,35,27,37],[25,0,25,1],[25,2,25,4],[25,5,25,8],[25,9,25,14],[25,15,25,16],[25,17,25,28],[25,29,25,31],[25,32,25,34],[25,35,25,37],[24,0,24,1],[24,2,24,4],[24,5,24,8],[24,9,24,14],[24,15,24,16],[24,17,24,28],[24,29,24,31],[24,32,24,34],[24,35,24,37],[22,29,22,31],[22,32,22,34],[22,35,22,37],[23,0,23,1],[23,2,23,4],[23,5,23,8],[23,9,23,14],[23,15,23,16],[23,17,23,28],[23,29,23,31],[22,0,22,1],[22,2,22,4],[22,5,22,8],[22,9,22,14],[22,15,22,16],[22,17,22,28],[23,32,23,34],[23,35,23,37],[21,0,21,1],[21,2,21,4],[21,5,21,8],[21,9,21,14],[21,15,21,16],[21,17,21,28],[21,29,21,31],[21,32,21,34],[21,35,21,37],[20,0,20,1],[20,2,20,4],[20,5,20,8],[20,9,20,14],[20,15,20,16],[20,17,20,28],[20,29,20,31],[20,32,20,34],[20,35,20,37],[18,29,18,31],[18,32,18,34],[18,35,18,37],[19,0,19,1],[19,2,19,4],[19,5,19,8],[19,9,19,14],[19,15,19,16],[19,17,19,28],[19,29,19,31],[18,0,18,1],[18,2,18,4],[18,5,18,8],[18,9,18,14],[18,15,18,16],[18,17,18,28],[19,32,19,34],[19,35,19,37],[17,0,17,1],[17,2,17,4],[17,5,17,8],[17,9,17,14],[17,15,17,16],[17,17,17,28],[17,29,17,31],[17,32,17,34],[17,35,17,37],[16,0,16,1],[16,2,16,4],[16,5,16,8],[16,9,16,14],[16,15,16,16],[16,17,16,28],[16,29,16,31],[16,32,16,34],[16,35,16,37],[14,29,14,31],[14,32,14,34],[14,35,14,37],[15,0,15,1],[15,2,15,4],[15,5,15,8],[15,9,15,14],[15,15,15,16],[15,17,15,28],[15,29,15,31],[14,0,14,1],[14,2,14,4],[14,5,14,8],[14,9,14,14],[14,15,14,16],[14,17,14,28],[15,32,15,34],[15,35,15,37],[13,0,13,1],[13,2,13,4],[13,5,13,8],[13,9,13,14],[13,15,13,16],[13,17,13,28],[13,29,13,31],[13,32,13,34],[13,35,13,37],[12,0,12,1],[12,2,12,4],[12,5,12,8],[12,9,12,14],[12,15,12,16],[12,17,12,28],[12,29,12,31],[12,32,12,34],[12,35,12,37],[10,29,10,31],[10,32,10,34],[10,35,10,37],[11,0,11,1],[11,2,11,4],[11,5,11,8],[11,9,11,14],[11,15,11,16],[11,17,11,28],[11,29,11,31],[10,0,10,1],[10,2,10,4],[10,5,10,8],[10,9,10,14],[10,15,10,16],[10,17,10,28],[11,32,11,34],[11,35,11,37],[9,0,9,1],[9,2,9,4],[9,5,9,8],[9,9,9,14],[9,15,9,16],[9,17,9,28],[9,29,9,31],[9,32,9,34],[9,35,9,37],[8,0,8,1],[8,2,8,4],[8,5,8,8],[8,9,8,14],[8,15,8,16],[8,17,8,28],[8,29,8,31],[8,32,8,34],[8,35,8,37],[6,29,6,31],[6,32,6,34],[6,35,6,37],[7,0,7,1],[7,2,7,4],[7,5,7,8],[7,9,7,14],[7,15,7,16],[7,17,7,28],[7,29,7,31],[6,0,6,1],[6,2,6,4],[6,5,6,8],[6,9,6,14],[6,15,6,16],[6,17,6,28],[7,32,7,34],[7,35,7,37],[4,0,4,37],[5,0,5,1],[5,2,5,4],[5,5,5,8],[5,9,5,14],[5,15,5,16],[5,17,5,28],[5,29,5,31],[5,32,5,34],[5,35,5,37],[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,"Rev. 08/09/2019"]
["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,"  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7=\"\",\"\",$D$3)","v":0},{"$f":"IF(C7=\"\",\"\",$R$4)","v":0},{"$f":"IF(C7=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C7=\"\",\"\",$AI$3)","v":"00:00:00"}]
[2,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(C8=\"\",\"\",$AG$4)","v":0},{"$f":"IF(C8=\"\",\"\",$AI$3)","v":"00:00:00"}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C9=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C9=\"\",\"\",$AI$3)","v":""}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(C10=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C10=\"\",\"\",$AI$3)","v":""}]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C11=\"\",\"\",$AG$4)","v":""},{"$f":"IF(C11=\"\",\"\",$AI$3)","v":""}]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,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":3,"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"]