{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dropdowns","MPRROP Coverpage","Applicant & Project Info","Development Team-Contacts","Residence Analysis","2020 Low Income Limits","Threshold & Standard Conditions","Certification & Legal","Dev Sources","Dev Budget","Operating Budget","Cash Flow","Application Support"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":748,"comments":8,"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":"Dropdowns","index":0,"n_rows":59,"n_cols":2,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
["Alameda","Group of mobilehome park residents who have formed a nonprofit corporation"]
["Alpine","Group of mobilehome park residents who have formed a other legally recogized entity"]
["Amador","Nonprofit public benefit corporation with tax-exempt status under IRC §501(c)(3) and not affiliated with or controlled by a for-profit"]
["Butte","Limited partnership (all the general partners must be nonprofit mutual or public benefit corporations that meet HSC §50781(k) requirements"]
["Calaveras","County"]
["Colusa","City"]
["Contra Costa","City and county"]
["Del Norte","Duly constituted body of an Indian reservation or rancheria"]
["El Dorado","Duly constituted body of a public district"]
["Fresno","Duly constituted body of a political subdivision of the state"]
["Glenn","Two or more public entities acting jointly"]
["Humboldt"]
["Imperial","1. Construction of a new or replacement mobilehome park to replace a park destroyed as a result of a natural disaster"]
["Inyo","2. Acquisition of a mobilehome park by qualified nonprofit housing sponsors or local public entities only"]
["Kern","2. Acquisition and rehabilitation of a mobilehome park by qualified nonprofit housing sponsors or local public entities only"]
["Kings","2. Rehabilitation of a mobilehome park by qualified nonprofit housing sponsors or local public entities only"]
["Lake","3. Conversion of mobilehome park ownership to qualified resident organizations, including permissible rehabilitation and repair costs"]
["Lassen","4. Assistance to low-income (80% AMI or less) residents to purchase a space in a park converting to resident ownership"]
["Los Angeles","5. Assistance to low-income (80% AMI or less) residents to replace or make necessary repairs and accessibility upgrades to an owner-occupied mobilehome"]
["Madera"]
["Marin","N/A"]
["Mariposa","The mobilehome park at time of application has significant outstanding violations of the Mobilehome Parks Act that threaten the viability of the park; or"]
["Mendocino","The acquisition or rehabilitation will substantially benefit low (80% AMI or less) and moderate-income (120% AMI or less) homeowners; applicant agrees to maintain affordable rents for low-income residents."]
["Merced"]
["Modoc","N/A"]
["Mono","Resident-owned subdivided park"]
["Monterey","Stock cooperative"]
["Napa","Limited equity housing cooperative"]
["Nevada","Nonprofit mutual benefit corporation"]
["Orange"]
["Placer"]
["Plumas","Executed Contract to Purchase"]
["Riverside","Executed Irrevocable Option Agreement"]
["Sacramento","Written Agreement"]
["San Benito"]
["San Bernardino"]
["San Diego","The acquisition and construction of a mobilehome park to replace a destroyed mobilehome park."]
["San Francisco","“Acquisition and Rehabilitation” includes park purchase, rehabilitation, refinancing of short-term loans used for park acquisition and/or rehabilitation, financing costs, infrastructure improvements, park and/or resident relocation, professional fees, operating reserve, etc."]
["San Joaquin","Conversion costs include acquisition cost, loan origination, appraisal, inspection fees, and other related financial costs, title and escrow fees, engineering, legal and other professional fees, expenditures required to obtain governmental approvals, relocation costs per 25 CCR §8020, park rehabilitation costs, and contingency funds per 25 CCR §8006(b)."]
["San Luis Obispo","Acquisition costs for individual interests, including nonrecurring closing costs per 25 CCR §8010, and to reduce the housing costs for low-income (80% AMI or less) residents to an affordable level."]
["San Mateo","To assist low-income (80% AMI or less) mobilehome owners residing in the park to make repairs to, make accessibility-related upgrades to, or replace their mobilehomes and the cost of a new mobilehome; the cost of rehabilitation of an existing mobilehome; and the cost of building permits and other related government fees, consultant services directly related to the rehabilitation, and non-recurring loan closing costs.\n"]
["Santa Barbara"]
["Santa Clara"]
["Santa Cruz"]
["Shasta"]
["Sierra"]
["Siskiyou"]
["Solano"]
["Sonoma"]
["Stanislaus"]
["Sutter"]
["Tehama"]
["Trinity"]
["Tulare"]
["Tuolumne"]
["Ventura"]
["Yolo"]
["Yuba"]

{"sheet":"MPRROP Coverpage","index":1,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,0,22,22],[23,0,23,22],[24,0,24,22],[7,0,7,22],[10,0,10,22],[11,0,11,22],[14,0,14,22],[15,0,15,22],[18,0,18,22],[19,0,19,22],[20,0,20,22],[21,0,21,22],[6,0,6,22],[0,0,0,22],[1,0,1,22],[2,0,2,22],[4,0,4,22],[5,0,5,22]]}
[]
["Mobilehome Park Rehabilitation and Resident Ownership Program (MPRROP)"]
["Supplemental Application"]
[]
["2020 Notice of Funding Availability"]
[]
["State of California"]
["Governor Gavin Newsom"]
[]
[]
["Lourdes Castro Ramírez, Secretary"]
["Business, Consumer Services and Housing Agency"]
[]
[]
["Gustavo Velasquez, Director"]
["Department of Housing and Community Development"]
[]
[]
["2020 West El Camino Avenue, Suite 150, Sacramento, CA 95833\n\n\n "]
["Phone: (916) 263-2771"]
["Website: https://www.hcd.ca.gov/grants-funding/active-funding/mprrop.shtml"]
["Program Email: MPRROP@hcd.ca.gov "]
[]
["NOFA Release: May 29, 2020"]
["Rev. 6/12/20"]

{"sheet":"Applicant & Project Info","index":2,"n_rows":121,"n_cols":39,"rows_kept":121,"cut":false,"hidden":false,"merged":[[115,0,115,35],[115,36,115,37],[95,0,95,4],[95,5,95,7],[95,8,95,14],[95,15,95,17],[95,29,95,31],[95,32,95,34],[114,0,114,35],[103,0,103,8],[103,9,103,37],[108,14,108,16],[108,17,108,20],[110,14,110,15],[110,16,110,21],[110,22,110,24],[110,25,110,37],[109,0,109,37],[104,36,104,37],[112,0,112,37],[113,0,113,34],[113,35,113,37],[108,0,108,13],[107,0,107,34],[38,31,38,33],[39,31,39,33],[40,31,40,33],[41,31,41,33],[42,31,42,33],[85,35,85,37],[38,36,38,37],[40,34,40,35],[80,14,80,37],[38,34,38,35],[39,34,39,35],[41,11,41,21],[40,28,40,30],[41,28,41,30],[82,12,82,13],[62,0,62,37],[77,0,77,35],[77,36,77,37],[78,0,78,37],[79,0,79,37],[71,0,71,35],[41,34,41,35],[42,34,42,35],[43,36,43,37],[38,28,38,30],[38,0,38,4],[96,3,96,10],[96,11,96,29],[96,30,96,35],[96,36,96,37],[89,0,89,37],[81,4,81,6],[82,4,82,6],[81,31,81,34],[74,8,74,14],[74,0,74,4],[68,17,68,18],[68,19,68,24],[68,25,68,26],[68,27,68,30],[42,36,42,37],[42,28,42,30],[42,11,42,21],[80,0,80,13],[81,12,81,13],[75,36,75,37],[74,5,74,7],[53,0,53,37],[16,1,16,37],[17,1,17,37],[18,1,18,37],[19,1,19,37],[20,1,20,37],[21,1,21,37],[36,31,36,33],[35,36,35,37],[66,0,66,35],[66,36,66,37],[65,0,65,35],[65,36,65,37],[33,0,33,37],[34,0,34,37],[36,28,36,30],[54,0,54,37],[56,0,56,37],[55,0,55,37],[35,5,35,10],[36,5,36,10],[37,5,37,10],[38,5,38,10],[39,5,39,10],[40,5,40,10],[12,0,12,37],[35,31,35,33],[23,36,23,37],[25,0,25,37],[28,0,28,2],[100,25,100,37],[100,14,100,15],[94,36,94,37],[86,0,86,13],[86,19,86,21],[91,11,91,29],[90,25,90,37],[97,35,97,37],[71,36,71,37],[72,0,72,35],[72,36,72,37],[73,0,73,35],[75,0,75,2],[75,3,75,10],[75,11,75,29],[75,30,75,35],[13,1,13,37],[14,1,14,37],[15,1,15,37],[107,35,107,37],[91,30,91,35],[91,36,91,37],[96,0,96,2],[35,34,35,35],[36,36,36,37],[36,34,36,35],[73,36,73,37],[76,0,76,37],[83,0,83,35],[83,36,83,37],[84,35,84,37],[88,35,88,37],[88,22,88,31],[88,0,88,13],[88,33,88,34],[81,7,81,9],[82,7,82,9],[84,18,84,34],[67,24,67,25],[98,0,98,13],[98,14,98,16],[98,17,98,20],[94,0,94,35],[70,25,70,26],[70,27,70,30],[69,0,69,4],[70,0,70,2],[68,0,68,2],[70,31,70,33],[58,0,58,37],[59,0,59,25],[59,26,59,37],[60,0,60,37],[61,0,61,37],[67,31,67,37],[67,22,67,23],[67,0,67,4],[68,3,68,16],[67,5,67,21],[67,26,67,30],[7,32,7,37],[9,0,9,3],[8,0,8,1],[8,34,8,37],[7,22,7,29],[7,20,7,21],[9,22,9,29],[9,30,9,31],[7,11,7,12],[9,11,9,12],[7,30,7,31],[8,31,8,32],[7,13,7,19],[7,0,7,3],[9,32,9,37],[9,20,9,21],[9,4,9,10],[9,13,9,19],[7,4,7,10],[8,2,8,19],[8,20,8,21],[8,22,8,28],[8,29,8,30],[0,0,0,34],[0,35,0,37],[4,5,4,37],[4,0,4,4],[6,34,6,37],[6,20,6,21],[6,22,6,28],[6,31,6,32],[6,0,6,1],[6,2,6,19],[2,0,2,37],[5,0,5,5],[5,6,5,37],[3,0,3,4],[3,5,3,37],[6,29,6,30],[1,0,1,37],[118,35,118,37],[118,0,118,34],[10,3,10,10],[10,11,10,29],[10,30,10,35],[10,36,10,37],[11,0,11,2],[11,3,11,10],[11,11,11,29],[11,30,11,35],[11,36,11,37],[10,0,10,2],[29,0,29,2],[29,3,29,10],[29,11,29,29],[29,30,29,35],[29,36,29,37],[30,0,30,2],[22,1,22,37],[23,0,23,2],[28,3,28,10],[28,11,28,29],[28,30,28,35],[28,36,28,37],[110,0,110,13],[91,0,91,2],[91,3,91,10],[87,0,87,2],[87,3,87,10],[87,11,87,29],[97,0,97,34],[37,11,37,21],[35,0,35,4],[36,0,36,4],[37,0,37,4],[74,24,74,26],[74,27,74,28],[74,29,74,31],[50,0,50,37],[51,0,51,37],[40,0,40,4],[40,11,40,21],[43,11,43,21],[43,34,43,35],[100,16,100,21],[48,0,48,1],[48,2,48,19],[48,20,48,21],[98,22,98,31],[98,33,98,34],[98,35,98,37],[93,36,93,37],[90,0,90,13],[90,14,90,15],[90,16,90,21],[90,22,90,24],[95,35,95,37],[95,18,95,28],[92,0,92,37],[93,0,93,35],[39,36,39,37],[38,22,38,27],[39,22,39,27],[39,28,39,30],[38,11,38,21],[39,11,39,21],[88,14,88,16],[88,17,88,20],[82,0,82,3],[81,14,81,25],[82,14,82,25],[48,22,48,28],[48,29,48,30],[43,31,43,33],[40,22,40,27],[41,22,41,27],[42,22,42,27],[41,5,41,10],[42,5,42,10],[43,5,43,10],[64,0,64,37],[63,0,63,37],[23,3,23,10],[23,11,23,29],[23,30,23,35],[35,22,35,27],[36,22,36,27],[37,22,37,27],[35,11,35,21],[30,3,30,10],[30,11,30,29],[30,30,30,35],[24,0,24,37],[26,0,26,37],[27,0,27,37],[30,36,30,37],[32,0,32,37],[37,34,37,35],[37,36,37,37],[39,0,39,4],[37,28,37,30],[35,28,35,30],[37,31,37,33],[74,35,74,37],[74,32,74,34],[74,18,74,23],[70,34,70,37],[69,22,69,23],[68,34,68,37],[68,31,68,33],[69,5,69,21],[69,24,69,25],[69,26,69,30],[69,31,69,37],[70,3,70,16],[70,17,70,18],[70,19,70,24],[74,15,74,17],[52,0,52,37],[31,0,31,2],[31,3,31,10],[31,11,31,29],[31,30,31,35],[31,36,31,37],[46,0,46,35],[46,36,46,37],[57,0,57,25],[57,26,57,37],[45,6,45,37],[49,0,49,37],[43,28,43,30],[36,11,36,21],[45,0,45,5],[41,0,41,4],[42,0,42,4],[43,0,43,4],[43,22,43,27],[47,0,47,5],[47,6,47,37],[41,36,41,37],[48,31,48,37],[40,36,40,37],[44,0,44,37],[106,0,106,4],[106,5,106,7],[106,8,106,14],[106,15,106,17],[106,18,106,28],[106,29,106,31],[106,32,106,34],[106,35,106,37],[99,0,99,37],[100,0,100,13],[105,0,105,35],[105,36,105,37],[100,22,100,24],[85,0,85,14],[85,15,85,17],[85,18,85,31],[85,32,85,34],[87,30,87,35],[81,35,81,37],[82,35,82,37],[81,26,81,28],[82,26,82,28],[82,10,82,11],[82,29,82,30],[81,10,81,11],[81,29,81,30],[84,0,84,4],[84,5,84,7],[84,8,84,14],[84,15,84,17],[81,0,81,3],[87,36,87,37],[82,31,82,34],[86,14,86,16],[86,17,86,18],[124,0,124,1],[124,2,124,11],[119,0,119,11],[119,25,119,37],[120,0,120,1],[120,2,120,11],[119,12,119,24],[120,12,120,13],[120,14,120,24],[124,12,124,13],[124,14,124,24],[124,25,124,26],[124,27,124,37],[123,12,123,13],[123,14,123,24],[123,25,123,26],[123,27,123,37],[121,0,121,1],[121,2,121,11],[121,12,121,13],[123,0,123,1],[123,2,123,11],[120,25,120,26],[120,27,120,37],[121,14,121,24],[121,25,121,26],[121,27,121,37],[122,0,122,1],[122,2,122,11],[122,12,122,13],[122,14,122,24],[122,25,122,26],[122,27,122,37],[117,18,117,22],[117,23,117,37],[101,0,101,2],[101,3,101,10],[101,11,101,29],[101,30,101,35],[101,36,101,37],[111,0,111,2],[111,3,111,10],[111,11,111,29],[111,30,111,35],[111,36,111,37],[117,0,117,4],[117,5,117,7],[117,8,117,14],[117,15,117,17],[114,36,114,37],[108,22,108,31],[108,33,108,34],[108,35,108,37],[102,0,102,37],[104,0,104,35],[116,0,116,35],[116,36,116,37]]}
["Applicant and Project Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'MPRROP Coverpage'!A25","v":"Rev. 6/12/20"}]
["This application for Mobilehome Park Rehabilitation and Resident Ownership Program (MPRROP) funds is made available as a part of the May 29, 2020 Notice of Funding Availability (NOFA). As an applicant, fill out the yellow shaded cells, as appropriate to your application. The application form has provided cells in which you can provide additional narrative where needed or you may upload a seperate sheet of paper in a file name that matches the tab name. If a response to a drop-down menu results in a red shaded cell, there is a possibility that the application will not meet the threshold requirements; however, if the narrative response adequately addresses such a circumstance, the application may continue to be reviewed.  When you open this file, you may see a yellow banner at the top with a button that says \"Enable Content\" or \"Enable Editing\".  It is essential that you click this box so that the macros are enabled. Enabling macros is necessary for full workbook functionality.  Macros may not work with Apple Mac MS Excel (Office 365 for Mac may work)."]
["NOFA II(A) - Eligible Applicant"]
["Applicant Type",null,null,null,null,null,null,null,null,null,null,null,null,null,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(F4=\"Resident organization (members must be no less than 2/3 of the residents of each represented park)\",\"1\",IF(F4=\"Qualified nonprofit housing sponsor\",\"2\",IF(F4=\"Local public entity\",\"3\",\"\")))","v":""}]
["Entity Type"]
["Sponsor/Applicant Name"]
["Address",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,"State",null,null,null,"Zip"]
["Auth Rep Name",null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,null,"Email",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,"City",null,null,null,null,null,null,null,null,"State",null,null,null,"Zip"]
["Contact Name",null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,"Phone"]
["File Name:",null,null,"Cert & Legal Disclosure",null,null,null,null,null,null,null,"Certifications & Legal Disclosure tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Reso",null,null,null,null,null,null,null,"Resolution - see below for the minimum Resolution content - NOFA IV(2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["What must your Resolutions contain? (visit the MPRROP webpage to see sample resolutions)"]
[1,"Entity Name (identity of the contracting party or borrower) and Entity Type (corporation, non-profit, for-profit, city, etc.)"]
[2,"Name & Title of Signatory(ies)                                                                                                                                                                                                         \nNOTE: Name and title of authorized signatory(ies) is preferred. In instances pertaining to municipalities/jurisdictions/transit agencies (when title is acceptable), supporting documentation evidencing the individual who currently holds the position must be provided."]
[3,"NOFA Date."]
[4,"Language authorizing Signatory(ies) to sign Standard Agreement (if more than one is listed, ensure \"and\" or \"or\" is defined for individuals required to sign)."]
[5,"Amendment Provision included. "]
[6,"Aggregate dollar amount (should be equal to or greater than the requested/award amount), Loan Amount, and each to be listed individually."]
[7,"Person attesting validity of resolution (must be someone other than person authorized to sign Standard Agreement)."]
[8,"The meeting date authorizing resolution."]
[9,"All votes taken at meeting authorizing resolution (ayes, no's, absent, vacant)."]
[10,"Project name as it appears on the application."]
["File Name:",null,null,"OrgDoc1, OrgDoc2, etc.",null,null,null,null,null,null,null,"Organizational Documents (see below) - not applicable to public entities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Corporation Organization 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."]
["Limited Partnership Organization 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."]
["File Name:",null,null,"OrgChart",null,null,null,null,null,null,null,"Organizational Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Signature Block",null,null,null,null,null,null,null,"Signature Block, upload in Microsoft Word Doc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Government TIN Form",null,null,null,null,null,null,null,"Gov't Agency Taxpayer ID Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Payee Data Record",null,null,null,null,null,null,null,"STD-204 Payee Data Record",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Qualified Nonprofit Housing Applicants - Organization Capacity (Multifamily Affordable Housing, Mobilehome or Single Family Affordable)"]
["Per HSC §50781(k) - a “Qualified nonprofit housing sponsor” must have extensive experience with the development and operation of publicly subsidized affordable housing. HCD must determine if sponsor is qualified by experience and capability to own and operate a mobilehome park that provides housing affordable to low-income households. Provide a detailed narrative section below describing how you meet §50781(k) requirements. Also, complete experience chart."]
[]
["Type",null,null,null,null,"Project Name",null,null,null,null,null,"Project Address",null,null,null,null,null,null,null,null,null,null,"Project City",null,null,null,null,null,"Built in last 5 years",null,null,"Developed",null,null,"Own ",null,"Manage"]
[]
[]
[]
[]
[]
[]
[]
[]
["NOFA II(B) - Eligible Project (only one Project allowed per application)"]
["Applicant is applying for:"]
["Is your Project considered a rural project? For the purposes of MPRROP, “Rural Area” (HSC §50199.21 and Revenue and Taxation Code §17058 and §23610.5) means an area, which, on January 1 of any calendar year satisfies any of the following criteria: \n(a) The area is eligible for financing under the §515 program, or successor program, of the Rural Development Administration of the US Dept. of Agriculture. \n(b) The area is located in a nonmetropolitan area as defined in §50090. \n(c) The area is either (1) an incorporated city having a population of 40,000 or less as identified in the most recent Report E-1 published by the Demographic Research Unit of the Department of Finance, or (2) an unincorporated area which adjoins a city having a population of 40,000 or less, provided that the city and its adjoining unincorporated area are not located within a census tract designated as an urbanized area by the US Census Bureau. HCD shall assist in determinations of eligibility pursuant to this subdivision upon request. With respect to areas eligible under subdivision (b) and this subdivision, the committee may rely upon the recommendations made by HCD. Any inconsistencies between areas eligible under subdivisions (a) and (b), and this subdivision, shall be resolved in favor of considering the area a rural area. Eligible and ineligible areas need not be established by regulation.",null,null,null,null,null,null,null,null,null,null,null,null,null,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":"LEFT(G46,1)","v":""}]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM47=\"1\",Dropdowns!B38,IF(AM47=\"2\",Dropdowns!B39,IF(AM47=\"3\",Dropdowns!B40,IF(AM47=\"4\",Dropdowns!B41,IF(AM47=\"5\",Dropdowns!B42,\"\")))))","v":""}]
["Address",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,"County"]
["Indicate by selecting below all other Projects that you as the Applicant have applied for or anticipate applying for under this MPRROP NOFA?"]
[]
[]
[]
[]
[]
["Provide a full description of your Project including total spaces, income and other restrictions on spaces, general timeline and site characteristics."]
[]
["Proposed type of long-term ownership structure"]
[]
["Circumstances of sale"]
[]
["Describe resident participation and/or control"]
[]
["NOFA III and IV - Funding Types - Eligibility and Threshold"]
["1. Disaster reconstruction loan"]
["Applicant agrees the uses of funds will be for the acquisition and construction of a mobilehome park to replace a destroyed mobilehome park?"]
["Is the proposed mobilehome park on the site of or located within 20 miles from the destroyed mobilehome park?"]
["Destroyed park name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yr. built",null,null,null,"Assessor Parcel #(s)"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"Zip",null,null,null,null,null,"County"]
["Proposed park name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yr. built",null,null,null,"Assessor Parcel #(s)"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,null,"Zip",null,null,null,null,null,"County"]
["At the time the disaster occurred, were at least 50% of the residents of the destroyed mobilehome park low-income (80% AMI or less) residents?"]
["Will at least 50% of the spaces in the proposed mobilehome park be restricted to occupancy by households with incomes not exceeding 50% of AMI of the county in which the destroyed park was located?"]
["Applicant agrees the low-income (80% AMI or less) residents of the destroyed mobilehome park will be provided the right of first refusal for a minimum of 180 days. Low-income (80% AMI or less) residents of the destroyed mobilehome park will have the same lease or rental terms as were in effect at the destroyed park, before the park offers leases or rentals to occupy mobilehomes in the new park)?"]
["Max HCD loan amt:",null,null,null,null,{"$f":"IF(OR(P75=\"\",Y75=\"\"),0,MIN(P75,AD75,AJ75))","v":0},null,null,"Amount you are requesting:",null,null,null,null,null,null,null,null,null,"Post-rehab park value:",null,null,null,null,null,null,null,null,"x 115%",null,{"$f":"Y75*1.15","v":0},null,null,"NOFA max:",null,null,5000000]
["File Name:",null,null,"Appraisal",null,null,null,null,null,null,null,"Income approach appraisal - market value of the property based on the property’s income. The property’s value today, based on the present value of future cash flow. Combined Loan to Value (CLTV) – the combined loan (Senior lender and the HCD MPRROP loan) to value ratio.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["2. Acquisition and/or rehabilitation loan"]
["Applicant agrees the uses of funds will be for acquisition and rehabilitation including: park purchase, rehabilitation, refinancing of short-term loans used for park acquisition and/or rehabilitation, financing costs, infrastructure improvements, park and/or resident relocation, professional fees, operating reserve, etc.?"]
["Select from below the applicable Project eligibility criteria:\n1. The mobilehome park at time of application has significant outstanding violations of the Mobilehome Parks Act that threaten the viability of the park; or\n2. The acquisition or rehabilitation will substantially benefit low (80% AMI or less) and moderate-income (120% AMI or less) homeowners; applicant agrees to maintain affordable rents for low-income residents."]
[]
["Government agency/address responsible for park oversight:"]
["Most recent park inspection date",null,null,null,null,null,null,"Violations",null,null,null,null,"If yes, explain",null,null,null,null,null,null,null,null,null,null,null,null,null,"Corrected",null,null,null,null,"Date corrected"]
["Public utility inspection date",null,null,null,null,null,null,"Violations",null,null,null,null,"If yes, explain",null,null,null,null,null,null,null,null,null,null,null,null,null,"Corrected",null,null,null,null,"Date corrected"]
["Applicant confirms that at least 30% of residents at time of application are low-income (80% AMI or less) residents as defined by 25 CCR §8002?"]
["Max HCD loan amt:",null,null,null,null,{"$f":"IF(AJ86>0,IF(OR(P85=\"\",O87=\"\",O89=\"\"),0,MIN(P85,AJ85,AJ86,T87,AJ89)),IF(OR(P85=\"\",O87=\"\",O89=\"\"),0,MIN(P85,AJ85,T87,AJ89)))","v":0},null,null,"Amount you are requesting:",null,null,null,null,null,null,null,null,null,"NOFA max:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5000000]
["Minimum amount necessary to bring the park into compliance with all applicable health and safety standards?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum amount to maintain the monthly housing costs of low-income residents at an affordable level?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P86+AG86","v":0}]
["HCD approved Post-rehab park value including senior debt:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x 115%",null,{"$f":"O87*1.15","v":0}]
["File Name:",null,null,"Appraisal",null,null,null,null,null,null,null,"Income approach appraisal - market value of the property based on the property’s income. The property’s value today, based on the present value of future cash flow. Combined Loan to Value (CLTV) – the combined loan (Senior lender and the HCD MPRROP loan) to value ratio.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Acquisition and rehab costs (Dev Budget tab cell I122):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total spaces:",null,null,null,null,"Spaces occupied by low-income residents:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AG89=0,V89=0),0,IF(O91<>\"Yes\",MIN(0.5,AG89/V89),AG89/V89))","v":0},null,{"$f":"AH89*O89","v":0}]
["To apply for an amount more than 50% of acquisition and/or rehabilitation costs, applicants must demonstrate that they have made unsuccessful efforts to secure funds from other sources, and that the requested loan amount is necessary for feasibility."]
["Have you applied for funding from another source?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O91=\"Yes\",\"Were you successful?\",\"\")","v":""}]
["File Name:",null,null,"Funding App1, Funding App2, etc.",null,null,null,null,null,null,null,"Upload documentation such as a copy of the other Non-HCD funding application.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["3. Short-term conversion financing loan"]
["Applicant agrees the uses of funds will be for conversion including: acquisition cost; loan origination, appraisal, inspection fees, and other related financial costs; title and escrow fees; engineering, legal and other professional fees; expenditures required to obtain governmental approvals; relocation costs pursuant to 25 CCR §8020; park rehabilitation costs; and contingency funds 25 CCR §8006(b)?"]
["Applicant agrees the proposed conversion Project will be a proposed resident-owned subdivided park?"]
["Max HCD loan amt:",null,null,null,null,{"$f":"IF(OR(P96=\"\",AD96=\"\",AJ98=\"\",O99=\"\"),0,MIN(P96,AD96,AJ96,AJ98,AJ99))","v":0},null,null,"Amount you are requesting:",null,null,null,null,null,null,null,null,null,"Value of collateral securing loan (incl. sr. debt):",null,null,null,null,null,null,null,null,null,null,null,null,null,"NOFA max:",null,null,5000000]
["File Name:",null,null,"Collateral Value",null,null,null,null,null,null,null,"Documentation of the appraised value of the land and buildings situated on and securing the mobilehome park.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Minimum amount required for the Project to be feasible (minimum amt. to maintain monthly housing costs of low-income residents at an affordable level)?"]
["Total conversion costs (Dev Budget tab cell I122):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total spaces:",null,null,null,null,"Spaces occupied by low-income (80% AMI or less) residents:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AG99=0,V99=0),0,IF(O101<>\"Yes\",MIN(0.5,AG99/V99),MIN(0.95,AG99/V99)))","v":0},null,{"$f":"AH99*O99","v":0}]
["To apply for an amount more than 50% of conversion costs, applicants must demonstrate that they have made unsuccessful efforts to secure funds from other sources, and that the requested loan amount is necessary for feasibility."]
["Have you applied for funding from another source?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O101=\"Yes\",\"Were you successful?\",\"\")","v":""}]
["File Name:",null,null,"Funding App1, Funding App2, etc.",null,null,null,null,null,null,null,"Upload documentation such as a copy of the other Non-HCD funding application.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["4. Blanket loan and the associated low-income (80% AMI or less) individual acquisition loan for converted parks or those converting to resident ownership"]
["Select applicable Project eligibility type:"]
["Applicant agrees the park will undergo conversion or has converted to resident ownership, and any subsequent resident borrower will be the registered owner of the mobilehome?"]
["Applicant agrees the uses of funds will be for acquisition costs for individual interests, including nonrecurring closing costs, and to reduce the housing costs for low-income (80% AMI or less) residents to an affordable level?"]
["Max HCD loan amt:",null,null,null,null,{"$f":"IF(O111=\"Yes\",IF(OR(P107=\"\",AD107=\"\",O109=\"\",AJ108=\"\"),0,MIN(P107,AD107,AJ107,AJ109)),IF(OR(P107=\"\",AD107=\"\",O109=\"\",AJ108=\"\"),0,MIN(P107,AD107,AJ107,(MIN(AJ109,0.5*O109)))))","v":0},null,null,"Amount you are requesting:",null,null,null,null,null,null,null,null,null,"Value of collateral securing loan (incl. sr. debt):",null,null,null,null,null,null,null,null,null,null,null,null,null,"NOFA max:",null,null,5000000]
["Minimum amount required for the Project to be feasible (minimum amt. to maintain monthly housing costs of low-income residents at an affordable level)?"]
["Conversion costs - (Dev Budget tab cell I122):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total spaces:",null,null,null,null,"Spaces occupied by low-income residents:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P107=0,AD107=0,O109=0),0,IF(O111<>\"Yes\",MIN(0.5,AG109/V109),AG109/V109))","v":0},null,{"$f":"AH109*O109","v":0}]
["Individual loans may be up to 100% of conversion costs if low-income (80% AMI or less) applicants demonstrate that they have made unsuccessful efforts to secure funds from other sources, and that without the requested loan amount, the low-income (80% AMI or less) applicant is unable to purchase the individual interest."]
["Have you applied for funding from another source?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O111=\"Yes\",\"Were you successful?\",\"\")","v":""}]
["File Name:",null,null,"Funding App1, Funding App2, etc.",null,null,null,null,null,null,null,"Upload documentation such as a copy of the other Non-HCD funding application.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["5. Mobilehome rehabilitation or replacement grant"]
["Applicant confirms the mobilehome park has previously received a loan(s) pursuant to HSC §50783, §50784, or §50784.5 for the purpose of assisting homeowners within a park proposed for acquisition or conversion?"]
["Applicant can demonstrate sufficient organizational stability and capacity to manage a portfolio of individual loans over an extended time period or will contract with third-party originator and/or servicer?"]
["Applicant agrees funds will be used only for the following: to assist low-income (80% AMI or less) mobilehome owners residing in the park to make repairs to, make accessibility-related upgrades to, or replace their mobilehomes?"]
["Applicant agrees eligible costs include the cost of a new mobilehome; the cost of rehabilitation of an existing mobilehome; and the cost of building permits and other related government fees, consultant services directly related to the rehabilitation, and non-recurring loan closing costs?"]
["Max HCD loan amt:",null,null,null,null,{"$f":"IF(P118=\"\",0,MIN(P118,X118,AJ119))","v":0},null,null,"Amount you are requesting:",null,null,null,null,null,null,null,null,null,"NOFA max: ",null,null,null,null,5000000]
["Must complete the Residence Analysis tab including column P  (Mobilehome Rehab Amount). For low-income (80% AMI or less) households only, enter the amount necessary to replace a mobilehome, make needed repairs, or make accessibility-related upgrades to their mobilehomes.",null,null,null,null,null,null,null,null,null,null,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":"SUMIF('Residence Analysis'!A4:A103,\"Yes\",'Residence Analysis'!S4:U103)","v":0}]
["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":"Development Team-Contacts","index":3,"n_rows":91,"n_cols":36,"rows_kept":91,"cut":false,"hidden":false,"merged":[[34,11,34,29],[34,30,34,35],[35,0,35,2],[47,36,47,37],[23,0,23,2],[23,3,23,10],[23,11,23,29],[23,30,23,35],[23,36,23,37],[24,0,24,2],[24,3,24,10],[24,11,24,29],[24,30,24,35],[32,0,32,2],[32,3,32,10],[32,11,32,29],[32,30,32,35],[32,36,32,37],[33,0,33,2],[33,3,33,10],[33,11,33,29],[40,0,40,2],[40,3,40,11],[40,13,40,19],[48,36,48,37],[36,0,36,2],[36,3,36,10],[36,11,36,29],[36,30,36,35],[43,0,43,2],[43,3,43,10],[43,11,43,29],[43,30,43,35],[43,36,43,37],[42,0,42,1],[42,2,42,20],[42,22,42,29],[42,30,42,31],[42,34,42,37],[44,0,44,2],[40,34,40,37],[41,0,41,2],[41,3,41,11],[41,13,41,19],[41,20,41,21],[41,22,41,30],[41,31,41,32],[41,33,41,37],[11,11,11,29],[11,30,11,35],[11,36,11,37],[12,0,12,2],[12,3,12,10],[12,11,12,29],[12,30,12,35],[12,36,12,37],[11,0,11,2],[11,3,11,10],[7,36,7,37],[8,0,8,2],[8,3,8,10],[8,11,8,29],[8,30,8,35],[8,36,8,37],[7,0,7,2],[7,3,7,10],[7,11,7,29],[7,30,7,35],[40,20,40,23],[40,24,40,31],[40,32,40,33],[44,36,44,37],[45,0,45,2],[45,3,45,10],[45,11,45,29],[45,30,45,35],[46,0,46,2],[46,3,46,10],[46,11,46,29],[46,30,46,35],[46,36,46,37],[30,34,30,37],[31,0,31,2],[31,3,31,10],[31,11,31,29],[31,30,31,35],[31,36,31,37],[38,0,38,2],[38,3,38,25],[38,26,38,29],[38,30,38,37],[35,36,35,37],[36,36,36,37],[35,3,35,10],[35,11,35,29],[35,30,35,35],[34,36,34,37],[30,0,30,1],[30,2,30,20],[30,22,30,29],[30,30,30,31],[33,30,33,35],[33,36,33,37],[34,0,34,2],[34,3,34,10],[39,0,39,1],[39,2,39,20],[39,22,39,29],[39,30,39,31],[39,34,39,37],[26,3,26,25],[26,26,26,29],[26,30,26,37],[27,0,27,1],[27,2,27,20],[27,22,27,29],[27,30,27,31],[27,34,27,37],[29,3,29,11],[29,13,29,19],[29,20,29,21],[29,22,29,30],[29,31,29,32],[29,33,29,37],[28,3,28,11],[28,13,28,19],[28,20,28,23],[28,24,28,31],[28,32,28,33],[16,24,16,31],[16,32,16,33],[16,34,16,37],[17,0,17,2],[17,3,17,11],[17,13,17,19],[28,34,28,37],[21,30,21,35],[21,36,21,37],[19,30,19,35],[19,36,19,37],[20,30,20,35],[20,36,20,37],[20,0,20,2],[20,3,20,10],[20,11,20,29],[21,0,21,2],[21,3,21,10],[21,11,21,29],[28,0,28,2],[24,36,24,37],[13,0,13,37],[14,0,14,2],[14,3,14,25],[14,26,14,29],[14,30,14,37],[15,0,15,1],[15,2,15,20],[15,22,15,29],[15,30,15,31],[15,34,15,37],[9,0,9,2],[9,3,9,10],[9,11,9,29],[9,30,9,35],[9,36,9,37],[10,0,10,2],[10,3,10,10],[10,11,10,29],[10,30,10,35],[10,36,10,37],[90,34,90,37],[1,0,1,37],[2,0,2,2],[2,3,2,25],[2,26,2,29],[2,30,2,37],[5,0,5,2],[5,3,5,11],[5,22,5,30],[90,0,90,1],[90,2,90,6],[90,7,90,8],[90,9,90,20],[90,22,90,29],[90,30,90,31],[87,34,87,37],[88,0,88,37],[89,0,89,2],[89,3,89,14],[89,15,89,17],[89,18,89,26],[89,27,89,29],[89,30,89,37],[87,0,87,1],[87,2,87,6],[87,7,87,8],[87,9,87,20],[87,22,87,29],[87,30,87,31],[84,34,84,37],[85,0,85,37],[86,0,86,2],[86,3,86,14],[86,15,86,17],[86,18,86,26],[86,27,86,29],[86,30,86,37],[84,0,84,1],[84,2,84,6],[84,7,84,8],[84,9,84,20],[84,22,84,29],[84,30,84,31],[81,34,81,37],[82,0,82,37],[83,0,83,2],[83,3,83,14],[83,15,83,17],[83,18,83,26],[83,27,83,29],[83,30,83,37],[81,0,81,1],[81,2,81,6],[81,7,81,8],[81,9,81,20],[81,22,81,29],[81,30,81,31],[78,34,78,37],[79,0,79,37],[80,0,80,2],[80,3,80,14],[80,15,80,17],[80,18,80,26],[80,27,80,29],[80,30,80,37],[78,0,78,1],[78,2,78,6],[78,7,78,8],[78,9,78,20],[78,22,78,29],[78,30,78,31],[75,34,75,37],[76,0,76,37],[77,0,77,2],[77,3,77,14],[77,15,77,17],[77,18,77,26],[77,27,77,29],[77,30,77,37],[75,0,75,1],[75,2,75,6],[75,7,75,8],[75,9,75,20],[75,22,75,29],[75,30,75,31],[72,34,72,37],[73,0,73,37],[74,0,74,2],[74,3,74,14],[74,15,74,17],[74,18,74,26],[74,27,74,29],[74,30,74,37],[72,0,72,1],[72,2,72,6],[72,7,72,8],[72,9,72,20],[72,22,72,29],[72,30,72,31],[69,34,69,37],[70,0,70,37],[71,0,71,2],[71,3,71,14],[71,15,71,17],[71,18,71,26],[71,27,71,29],[71,30,71,37],[69,0,69,1],[69,2,69,6],[69,7,69,8],[69,9,69,20],[69,22,69,29],[69,30,69,31],[66,34,66,37],[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],[66,0,66,1],[66,2,66,6],[66,7,66,8],[66,9,66,20],[66,22,66,29],[66,30,66,31],[63,34,63,37],[64,0,64,37],[65,0,65,2],[65,3,65,14],[65,15,65,17],[65,18,65,26],[65,27,65,29],[65,30,65,37],[63,0,63,1],[63,2,63,6],[63,7,63,8],[63,9,63,20],[63,22,63,29],[63,30,63,31],[60,34,60,37],[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],[60,0,60,1],[60,2,60,6],[60,7,60,8],[60,9,60,20],[60,22,60,29],[60,30,60,31],[57,34,57,37],[58,0,58,37],[59,0,59,2],[59,3,59,14],[59,15,59,17],[59,18,59,26],[59,27,59,29],[59,30,59,37],[57,0,57,1],[57,2,57,6],[57,7,57,8],[57,9,57,20],[57,22,57,29],[57,30,57,31],[54,34,54,37],[55,0,55,37],[56,0,56,2],[56,3,56,14],[56,15,56,17],[56,18,56,26],[56,27,56,29],[56,30,56,37],[54,0,54,1],[54,2,54,6],[54,7,54,8],[54,9,54,20],[54,22,54,29],[54,30,54,31],[51,34,51,37],[52,0,52,37],[53,0,53,2],[53,3,53,14],[53,15,53,17],[53,18,53,26],[53,27,53,29],[53,30,53,37],[51,0,51,1],[51,2,51,6],[51,7,51,8],[51,9,51,20],[51,22,51,29],[51,30,51,31],[50,0,50,2],[50,3,50,14],[50,15,50,17],[50,18,50,26],[50,27,50,29],[50,30,50,37],[49,0,49,37],[5,31,5,32],[5,33,5,37],[6,2,6,20],[6,22,6,29],[48,0,48,2],[48,3,48,10],[48,11,48,29],[48,30,48,35],[47,0,47,2],[47,3,47,10],[47,11,47,29],[47,30,47,35],[45,36,45,37],[44,3,44,10],[44,11,44,29],[44,30,44,35],[37,0,37,37],[29,0,29,2],[25,0,25,37],[26,0,26,2],[22,0,22,2],[22,3,22,10],[22,11,22,29],[22,30,22,35],[22,36,22,37],[16,0,16,2],[16,3,16,11],[16,13,16,19],[16,20,16,23],[17,20,17,21],[17,22,17,30],[17,31,17,32],[17,33,17,37],[18,0,18,1],[18,2,18,20],[18,22,18,29],[18,30,18,31],[18,34,18,37],[19,0,19,2],[19,3,19,10],[19,11,19,29],[6,0,6,1],[6,34,6,37],[6,30,6,31],[5,13,5,19],[5,20,5,21],[4,34,4,37],[3,0,3,1],[0,0,0,34],[0,35,0,37],[3,2,3,20],[3,22,3,29],[3,30,3,31],[3,34,3,37],[4,0,4,2],[4,3,4,11],[4,13,4,19],[4,20,4,23],[4,24,4,31],[4,32,4,33]]}
["Development Team-Contacts",null,null,null,null,null,null,null,null,null,null,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":"'MPRROP Coverpage'!A25","v":"Rev. 6/12/20"}]
["Owner/Borrower Entity"]
["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,"Org. 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,null,null,"State",null,null,"Zip"]
["Auth. Rep",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"Auth. Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact ",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"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,null,null,"State",null,null,"Zip"]
["File Name:",null,null,"Bwr Cert & Legal Disclosure",null,null,null,null,null,null,null,"Certifications & Legal Disclosure tab",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,"Bwr Reso",null,null,null,null,null,null,null,"see 'Applicant & Project Info' tab row 13 for Resolution content; NOFA IV(2)",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,"Bwr OrgChart",null,null,null,null,null,null,null,"Organizational Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Bwr Signature Block",null,null,null,null,null,null,null,"Signature Block, upload in Microsoft Word Doc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Bwr Government TIN Form",null,null,null,null,null,null,null,"Gov't Agency Taxpayer ID Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"Bwr Payee Data Record",null,null,null,null,null,null,null,"STD-204 Payee Data Record",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Managing General Partner"]
["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,"Org. 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,null,null,"State",null,null,"Zip"]
["Auth. Rep",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"Auth. Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact ",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"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,null,null,"State",null,null,"Zip"]
["File Name:",null,null,"MGP Cert & Legal Disclosure",null,null,null,null,null,null,null,"Certifications & Legal Disclosure tab",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,"MGP Reso",null,null,null,null,null,null,null,"see 'Applicant & Project Info' tab row 13 for Resolution content; NOFA IV(2)",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,"MGP OrgChart",null,null,null,null,null,null,null,"Organizational Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"MGP Signature Block",null,null,null,null,null,null,null,"Signature Block, upload in Microsoft Word Doc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"MGP Government TIN Form",null,null,null,null,null,null,null,"Gov't Agency Taxpayer ID Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"MGP Payee Data Record",null,null,null,null,null,null,null,"STD-204 Payee Data Record",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Administrative General Partner #1"]
["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,"Org. 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,null,null,"State",null,null,"Zip"]
["Auth. Rep",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"Auth. Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact ",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"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,null,null,"State",null,null,"Zip"]
["File Name:",null,null,"AGP1 Cert & Legal Disclosure",null,null,null,null,null,null,null,"Certifications & Legal Disclosure tab",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,"AGP1 Reso",null,null,null,null,null,null,null,"see 'Applicant & Project Info' tab row 13 for Resolution content; NOFA IV(2)",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,"AGP1 OrgChart",null,null,null,null,null,null,null,"Organizational Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"AGP1 Signature Block",null,null,null,null,null,null,null,"Signature Block, upload in Microsoft Word Doc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"AGP1 Government TIN Form",null,null,null,null,null,null,null,"Gov't Agency Taxpayer ID Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"AGP1 Payee Data Record",null,null,null,null,null,null,null,"STD-204 Payee Data Record",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Administrative General Partner #2"]
["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,"Org. 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,null,null,"State",null,null,"Zip"]
["Auth. Rep",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"Auth. Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact ",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"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,null,null,"State",null,null,"Zip"]
["File Name:",null,null,"AGP2 Cert & Legal Disclosure",null,null,null,null,null,null,null,"Certifications & Legal Disclosure tab",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,"AGP2 Reso",null,null,null,null,null,null,null,"see 'Applicant & Project Info' tab row 13 for Resolution content; NOFA IV(2)",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,"AGP2 OrgChart",null,null,null,null,null,null,null,"Organizational Chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"AGP2 Signature Block",null,null,null,null,null,null,null,"Signature Block, upload in Microsoft Word Doc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"AGP2 Government TIN Form",null,null,null,null,null,null,null,"Gov't Agency Taxpayer ID Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["File Name:",null,null,"AGP2 Payee Data Record",null,null,null,null,null,null,null,"STD-204 Payee Data Record",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Property Management Agent"]
["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,"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,null,"State",null,null,"Zip"]
["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,"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,null,"State",null,null,"Zip"]
["Rehabilitation Specialist"]
["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,"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,null,"State",null,null,"Zip"]
["Borrower 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,"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,null,"State",null,null,"Zip"]
["General Contractor"]
["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,"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,null,"State",null,null,"Zip"]
["Architect"]
["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,"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,null,"State",null,null,"Zip"]
["Income Verifier"]
["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,"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,null,"State",null,null,"Zip"]
["Loan Originator"]
["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,"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,null,"State",null,null,"Zip"]
["Development Funding Source "]
["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,"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,null,"State",null,null,"Zip"]
["Development Funding Source "]
["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,"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,null,"State",null,null,"Zip"]
["Development Funding Source "]
["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,"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,null,"State",null,null,"Zip"]
["Development Funding Source "]
["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,"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,null,"State",null,null,"Zip"]
["Rent/Operating Subsidy Source "]
["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,"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,null,"State",null,null,"Zip"]
["Rent/Operating Subsidy Source "]
["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,"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,null,"State",null,null,"Zip"]

{"sheet":"Residence Analysis","index":4,"n_rows":103,"n_cols":67,"rows_kept":103,"cut":false,"hidden":false,"merged":[[100,52,100,54],[101,52,101,54],[43,52,43,54],[44,52,44,54],[45,52,45,54],[46,52,46,54],[47,52,47,54],[48,52,48,54],[49,52,49,54],[50,52,50,54],[51,52,51,54],[52,52,52,54],[53,52,53,54],[54,52,54,54],[55,52,55,54],[56,52,56,54],[57,52,57,54],[102,52,102,54],[69,52,69,54],[70,52,70,54],[71,52,71,54],[72,52,72,54],[73,52,73,54],[74,52,74,54],[75,52,75,54],[76,52,76,54],[77,52,77,54],[78,52,78,54],[79,52,79,54],[80,52,80,54],[81,52,81,54],[82,52,82,54],[83,52,83,54],[84,52,84,54],[85,52,85,54],[86,52,86,54],[87,52,87,54],[88,52,88,54],[89,52,89,54],[90,52,90,54],[91,52,91,54],[92,52,92,54],[93,52,93,54],[94,52,94,54],[95,52,95,54],[96,52,96,54],[97,52,97,54],[98,52,98,54],[99,52,99,54],[18,52,18,54],[19,52,19,54],[20,52,20,54],[21,52,21,54],[22,52,22,54],[23,52,23,54],[24,52,24,54],[25,52,25,54],[26,52,26,54],[27,52,27,54],[28,52,28,54],[29,52,29,54],[30,52,30,54],[31,52,31,54],[32,52,32,54],[33,52,33,54],[34,52,34,54],[1,55,1,57],[1,52,1,54],[2,52,2,54],[3,52,3,54],[4,52,4,54],[5,52,5,54],[6,52,6,54],[7,52,7,54],[8,52,8,54],[9,52,9,54],[10,52,10,54],[11,52,11,54],[12,52,12,54],[13,52,13,54],[14,52,14,54],[15,52,15,54],[86,55,86,57],[85,55,85,57],[47,55,47,57],[48,55,48,57],[49,55,49,57],[50,55,50,57],[51,55,51,57],[52,55,52,57],[53,55,53,57],[54,55,54,57],[55,55,55,57],[56,55,56,57],[57,55,57,57],[58,55,58,57],[59,55,59,57],[60,55,60,57],[87,55,87,57],[88,55,88,57],[89,55,89,57],[90,55,90,57],[91,55,91,57],[92,55,92,57],[93,55,93,57],[94,55,94,57],[95,55,95,57],[96,55,96,57],[97,55,97,57],[98,55,98,57],[99,55,99,57],[100,55,100,57],[101,55,101,57],[102,55,102,57],[69,55,69,57],[70,55,70,57],[71,55,71,57],[72,55,72,57],[73,55,73,57],[74,55,74,57],[75,55,75,57],[76,55,76,57],[77,55,77,57],[78,55,78,57],[79,55,79,57],[80,55,80,57],[81,55,81,57],[82,55,82,57],[83,55,83,57],[84,55,84,57],[63,55,63,57],[7,55,7,57],[8,55,8,57],[9,55,9,57],[10,55,10,57],[11,55,11,57],[12,55,12,57],[13,55,13,57],[14,55,14,57],[15,55,15,57],[16,55,16,57],[17,55,17,57],[18,55,18,57],[19,55,19,57],[20,55,20,57],[21,55,21,57],[22,55,22,57],[23,55,23,57],[3,1,3,7],[2,1,2,7],[2,8,2,14],[3,8,3,14],[2,21,2,22],[2,23,2,25],[83,18,83,20],[84,18,84,20],[5,26,5,28],[5,35,5,37],[5,38,5,40],[81,18,81,20],[82,18,82,20],[79,18,79,20],[80,18,80,20],[77,18,77,20],[77,38,77,40],[77,8,77,14],[77,21,77,22],[77,23,77,25],[77,29,77,31],[77,26,77,28],[77,35,77,37],[45,32,45,34],[10,1,10,7],[10,8,10,14],[10,21,10,22],[10,23,10,25],[10,29,10,31],[10,26,10,28],[10,35,10,37],[10,38,10,40],[2,61,2,63],[3,61,3,63],[2,41,2,43],[2,44,2,46],[2,47,2,49],[2,32,2,34],[3,32,3,34],[78,18,78,20],[75,18,75,20],[76,18,76,20],[73,18,73,20],[3,35,3,37],[3,38,3,40],[3,41,3,43],[3,44,3,46],[4,44,4,46],[5,44,5,46],[11,41,11,43],[11,44,11,46],[73,41,73,43],[73,44,73,46],[75,41,75,43],[2,18,2,20],[3,18,3,20],[2,29,2,31],[2,26,2,28],[3,21,3,22],[2,35,2,37],[2,38,2,40],[9,38,9,40],[2,55,2,57],[3,55,3,57],[4,47,4,49],[5,47,5,49],[4,32,4,34],[8,38,8,40],[8,41,8,43],[8,44,8,46],[8,47,8,49],[4,50,4,51],[4,58,4,60],[4,61,4,63],[5,1,5,7],[5,8,5,14],[5,21,5,22],[5,23,5,25],[5,29,5,31],[4,29,4,31],[4,26,4,28],[4,35,4,37],[4,38,4,40],[4,41,4,43],[4,18,4,20],[5,18,5,20],[4,1,4,7],[4,8,4,14],[4,21,4,22],[4,23,4,25],[5,61,5,63],[8,61,8,63],[4,55,4,57],[5,55,5,57],[6,55,6,57],[7,18,7,20],[11,50,11,51],[11,58,11,60],[10,18,10,20],[10,61,10,63],[10,41,10,43],[10,44,10,46],[10,47,10,49],[10,50,10,51],[10,58,10,60],[9,1,9,7],[9,32,9,34],[10,32,10,34],[9,8,9,14],[9,18,9,20],[9,41,9,43],[9,44,9,46],[9,47,9,49],[9,50,9,51],[9,58,9,60],[9,21,9,22],[9,23,9,25],[9,29,9,31],[9,26,9,28],[9,35,9,37],[9,61,9,63],[73,29,73,31],[73,26,73,28],[73,35,73,37],[73,38,73,40],[11,61,11,63],[12,1,12,7],[12,8,12,14],[12,21,12,22],[12,23,12,25],[12,29,12,31],[12,26,12,28],[12,35,12,37],[12,38,12,40],[12,18,12,20],[12,61,12,63],[12,41,12,43],[12,44,12,46],[12,47,12,49],[12,50,12,51],[12,58,12,60],[11,1,11,7],[11,8,11,14],[11,21,11,22],[11,23,11,25],[11,32,11,34],[12,32,12,34],[11,29,11,31],[11,26,11,28],[11,35,11,37],[11,38,11,40],[11,18,11,20],[11,47,11,49],[75,1,75,7],[75,8,75,14],[75,21,75,22],[75,23,75,25],[75,29,75,31],[75,44,75,46],[75,32,75,34],[73,47,73,49],[73,50,73,51],[73,58,73,60],[73,61,73,63],[74,1,74,7],[74,8,74,14],[74,21,74,22],[74,23,74,25],[74,29,74,31],[74,26,74,28],[74,35,74,37],[74,38,74,40],[74,18,74,20],[74,61,74,63],[74,41,74,43],[74,44,74,46],[74,47,74,49],[74,50,74,51],[74,58,74,60],[73,32,73,34],[74,32,74,34],[73,1,73,7],[73,8,73,14],[73,21,73,22],[73,23,73,25],[78,1,78,7],[78,8,78,14],[78,21,78,22],[78,23,78,25],[78,29,78,31],[78,26,78,28],[78,35,78,37],[78,38,78,40],[78,61,78,63],[78,41,78,43],[78,44,78,46],[78,47,78,49],[78,50,78,51],[78,58,78,60],[77,1,77,7],[75,47,75,49],[75,50,75,51],[75,58,75,60],[75,61,75,63],[76,1,76,7],[76,8,76,14],[76,21,76,22],[76,23,76,25],[76,29,76,31],[76,26,76,28],[76,35,76,37],[76,38,76,40],[76,61,76,63],[76,41,76,43],[76,44,76,46],[76,47,76,49],[76,50,76,51],[79,21,79,22],[79,23,79,25],[79,29,79,31],[79,26,79,28],[79,35,79,37],[79,38,79,40],[80,15,80,17],[77,41,77,43],[77,44,77,46],[75,26,75,28],[75,35,75,37],[75,38,75,40],[77,47,77,49],[77,50,77,51],[77,58,77,60],[79,41,79,43],[79,44,79,46],[79,47,79,49],[79,50,79,51],[79,58,79,60],[76,58,76,60],[82,21,82,22],[82,23,82,25],[82,29,82,31],[82,26,82,28],[82,35,82,37],[82,38,82,40],[81,1,81,7],[81,8,81,14],[81,21,81,22],[81,23,81,25],[81,29,81,31],[81,26,81,28],[81,35,81,37],[81,38,81,40],[81,15,81,17],[79,61,79,63],[80,1,80,7],[80,8,80,14],[80,21,80,22],[80,23,80,25],[80,29,80,31],[80,26,80,28],[80,35,80,37],[80,38,80,40],[80,61,80,63],[80,41,80,43],[80,44,80,46],[80,47,80,49],[80,50,80,51],[80,58,80,60],[79,1,79,7],[79,8,79,14],[84,23,84,25],[84,29,84,31],[84,26,84,28],[85,58,85,60],[85,61,85,63],[84,32,84,34],[84,15,84,17],[85,18,85,20],[83,41,83,43],[83,44,83,46],[83,47,83,49],[83,50,83,51],[83,58,83,60],[83,61,83,63],[82,61,82,63],[83,1,83,7],[83,8,83,14],[83,21,83,22],[83,23,83,25],[83,29,83,31],[83,26,83,28],[83,35,83,37],[83,38,83,40],[82,41,82,43],[82,44,82,46],[82,47,82,49],[82,50,82,51],[82,58,82,60],[82,15,82,17],[83,15,83,17],[82,1,82,7],[82,8,82,14],[86,1,86,7],[86,8,86,14],[86,21,86,22],[86,23,86,25],[86,29,86,31],[86,26,86,28],[86,35,86,37],[86,38,86,40],[85,38,85,40],[85,32,85,34],[86,32,86,34],[85,15,85,17],[86,15,86,17],[87,15,87,17],[84,50,84,51],[84,58,84,60],[84,61,84,63],[85,1,85,7],[85,8,85,14],[85,21,85,22],[85,23,85,25],[85,29,85,31],[85,26,85,28],[85,35,85,37],[84,35,84,37],[84,38,84,40],[84,41,84,43],[84,44,84,46],[84,47,84,49],[84,1,84,7],[84,8,84,14],[84,21,84,22],[88,1,88,7],[88,8,88,14],[88,21,88,22],[88,23,88,25],[88,29,88,31],[88,26,88,28],[88,35,88,37],[88,38,88,40],[87,32,87,34],[88,32,88,34],[85,41,85,43],[85,44,85,46],[85,47,85,49],[85,50,85,51],[86,61,86,63],[86,18,86,20],[87,1,87,7],[87,8,87,14],[87,21,87,22],[87,23,87,25],[87,29,87,31],[87,26,87,28],[87,35,87,37],[87,38,87,40],[86,41,86,43],[86,44,86,46],[86,47,86,49],[86,50,86,51],[86,58,86,60],[87,61,87,63],[87,18,87,20],[87,41,87,43],[90,1,90,7],[90,8,90,14],[90,21,90,22],[90,23,90,25],[90,29,90,31],[90,26,90,28],[90,35,90,37],[90,38,90,40],[89,32,89,34],[90,32,90,34],[87,44,87,46],[87,47,87,49],[87,50,87,51],[87,58,87,60],[88,61,88,63],[88,18,88,20],[89,1,89,7],[89,8,89,14],[89,21,89,22],[89,23,89,25],[89,29,89,31],[89,26,89,28],[89,35,89,37],[89,38,89,40],[88,41,88,43],[88,44,88,46],[88,47,88,49],[88,50,88,51],[88,58,88,60],[89,61,89,63],[89,18,89,20],[89,41,89,43],[92,1,92,7],[92,8,92,14],[92,21,92,22],[92,23,92,25],[92,29,92,31],[92,26,92,28],[92,35,92,37],[92,38,92,40],[91,32,91,34],[92,32,92,34],[89,47,89,49],[89,50,89,51],[89,58,89,60],[90,61,90,63],[90,18,90,20],[91,1,91,7],[91,8,91,14],[91,21,91,22],[91,23,91,25],[91,29,91,31],[91,26,91,28],[91,35,91,37],[91,38,91,40],[90,41,90,43],[90,44,90,46],[90,47,90,49],[90,50,90,51],[90,58,90,60],[91,61,91,63],[91,18,91,20],[91,41,91,43],[91,44,91,46],[94,1,94,7],[94,8,94,14],[94,21,94,22],[94,23,94,25],[94,29,94,31],[94,26,94,28],[94,35,94,37],[94,38,94,40],[93,32,93,34],[94,32,94,34],[91,50,91,51],[91,58,91,60],[92,61,92,63],[92,18,92,20],[93,1,93,7],[93,8,93,14],[93,21,93,22],[93,23,93,25],[93,29,93,31],[93,26,93,28],[93,35,93,37],[93,38,93,40],[92,41,92,43],[92,44,92,46],[92,47,92,49],[92,50,92,51],[92,58,92,60],[93,61,93,63],[93,18,93,20],[93,41,93,43],[93,44,93,46],[93,47,93,49],[96,8,96,14],[96,21,96,22],[96,23,96,25],[96,29,96,31],[96,26,96,28],[96,35,96,37],[96,38,96,40],[95,32,95,34],[96,32,96,34],[93,58,93,60],[94,61,94,63],[94,18,94,20],[95,1,95,7],[95,8,95,14],[95,21,95,22],[95,23,95,25],[95,29,95,31],[95,26,95,28],[95,35,95,37],[95,38,95,40],[94,41,94,43],[94,44,94,46],[94,47,94,49],[94,50,94,51],[94,58,94,60],[95,61,95,63],[95,18,95,20],[95,41,95,43],[95,44,95,46],[95,47,95,49],[95,50,95,51],[95,58,95,60],[99,41,99,43],[99,44,99,46],[99,47,99,49],[99,50,99,51],[99,58,99,60],[98,1,98,7],[98,8,98,14],[98,21,98,22],[98,23,98,25],[98,29,98,31],[98,26,98,28],[98,35,98,37],[98,38,98,40],[96,61,96,63],[96,18,96,20],[97,1,97,7],[97,8,97,14],[97,21,97,22],[97,23,97,25],[97,29,97,31],[97,26,97,28],[97,35,97,37],[97,38,97,40],[96,41,96,43],[96,44,96,46],[96,47,96,49],[96,50,96,51],[96,58,96,60],[97,61,97,63],[97,18,97,20],[97,41,97,43],[97,44,97,46],[101,35,101,37],[101,38,101,40],[100,41,100,43],[100,44,100,46],[100,47,100,49],[100,50,100,51],[100,58,100,60],[100,1,100,7],[100,8,100,14],[100,21,100,22],[100,23,100,25],[100,29,100,31],[100,26,100,28],[100,35,100,37],[100,38,100,40],[98,61,98,63],[98,18,98,20],[99,1,99,7],[99,8,99,14],[99,21,99,22],[99,23,99,25],[99,29,99,31],[99,26,99,28],[99,35,99,37],[99,38,99,40],[98,41,98,43],[98,44,98,46],[98,47,98,49],[98,50,98,51],[98,58,98,60],[99,61,99,63],[99,18,99,20],[102,61,102,63],[102,18,102,20],[1,61,1,63],[102,41,102,43],[102,44,102,46],[102,47,102,49],[102,50,102,51],[102,58,102,60],[101,61,101,63],[101,18,101,20],[102,1,102,7],[102,8,102,14],[102,21,102,22],[102,23,102,25],[102,29,102,31],[102,26,102,28],[102,35,102,37],[102,38,102,40],[101,41,101,43],[101,44,101,46],[101,47,101,49],[101,50,101,51],[101,58,101,60],[100,61,100,63],[100,18,100,20],[101,1,101,7],[101,8,101,14],[101,21,101,22],[101,23,101,25],[97,32,97,34],[101,29,101,31],[101,26,101,28],[99,32,99,34],[100,32,100,34],[101,32,101,34],[102,32,102,34],[43,1,43,7],[43,8,43,14],[43,18,43,20],[43,21,43,22],[43,23,43,25],[43,26,43,28],[43,29,43,31],[43,32,43,34],[44,1,44,7],[44,8,44,14],[44,18,44,20],[44,21,44,22],[44,23,44,25],[44,26,44,28],[44,29,44,31],[44,32,44,34],[45,1,45,7],[45,8,45,14],[76,32,76,34],[77,32,77,34],[78,32,78,34],[79,32,79,34],[80,32,80,34],[81,32,81,34],[82,32,82,34],[83,32,83,34],[51,1,51,7],[96,1,96,7],[44,35,44,37],[44,38,44,40],[44,41,44,43],[44,44,44,46],[44,47,44,49],[44,50,44,51],[44,58,44,60],[44,61,44,63],[43,35,43,37],[43,38,43,40],[43,41,43,43],[43,44,43,46],[43,47,43,49],[43,50,43,51],[43,58,43,60],[43,61,43,63],[98,32,98,34],[97,47,97,49],[97,50,97,51],[97,58,97,60],[93,50,93,51],[91,47,91,49],[89,44,89,46],[81,41,81,43],[81,44,81,46],[81,47,81,49],[81,50,81,51],[81,58,81,60],[81,61,81,63],[77,61,77,63],[43,55,43,57],[44,55,44,57],[45,41,45,43],[45,44,45,46],[45,47,45,49],[45,50,45,51],[45,58,45,60],[45,61,45,63],[46,1,46,7],[46,8,46,14],[46,18,46,20],[46,21,46,22],[46,23,46,25],[46,26,46,28],[46,29,46,31],[46,32,46,34],[46,35,46,37],[46,38,46,40],[46,41,46,43],[46,44,46,46],[46,47,46,49],[46,50,46,51],[46,58,46,60],[46,61,46,63],[45,18,45,20],[45,21,45,22],[45,23,45,25],[45,26,45,28],[45,29,45,31],[45,35,45,37],[45,38,45,40],[45,55,45,57],[46,55,46,57],[50,61,50,63],[47,38,47,40],[47,41,47,43],[47,44,47,46],[47,47,47,49],[47,50,47,51],[47,58,47,60],[47,61,47,63],[48,1,48,7],[48,8,48,14],[48,18,48,20],[48,21,48,22],[48,23,48,25],[48,26,48,28],[48,29,48,31],[48,32,48,34],[48,35,48,37],[48,38,48,40],[48,41,48,43],[48,44,48,46],[48,47,48,49],[48,50,48,51],[48,58,48,60],[47,1,47,7],[47,8,47,14],[47,18,47,20],[47,21,47,22],[47,23,47,25],[47,26,47,28],[47,29,47,31],[47,32,47,34],[47,35,47,37],[50,1,50,7],[50,8,50,14],[50,18,50,20],[50,21,50,22],[50,23,50,25],[50,26,50,28],[50,29,50,31],[50,32,50,34],[50,35,50,37],[48,61,48,63],[49,1,49,7],[49,8,49,14],[49,18,49,20],[49,21,49,22],[49,23,49,25],[49,26,49,28],[49,29,49,31],[49,32,49,34],[49,35,49,37],[49,38,49,40],[49,41,49,43],[49,44,49,46],[49,47,49,49],[49,50,49,51],[49,58,49,60],[49,61,49,63],[50,38,50,40],[50,41,50,43],[50,44,50,46],[50,47,50,49],[50,50,50,51],[50,58,50,60],[53,44,53,46],[53,47,53,49],[53,50,53,51],[53,58,53,60],[53,61,53,63],[51,8,51,14],[51,18,51,20],[51,21,51,22],[51,23,51,25],[51,26,51,28],[51,29,51,31],[51,32,51,34],[51,35,51,37],[51,38,51,40],[51,41,51,43],[51,44,51,46],[51,47,51,49],[51,50,51,51],[51,58,51,60],[52,15,52,17],[53,15,53,17],[54,61,54,63],[55,1,55,7],[55,8,55,14],[55,18,55,20],[53,1,53,7],[53,8,53,14],[53,18,53,20],[53,21,53,22],[53,23,53,25],[53,26,53,28],[53,29,53,31],[53,32,53,34],[53,35,53,37],[51,61,51,63],[52,1,52,7],[52,8,52,14],[52,18,52,20],[52,21,52,22],[52,23,52,25],[52,26,52,28],[52,29,52,31],[52,32,52,34],[52,35,52,37],[52,38,52,40],[52,41,52,43],[52,44,52,46],[52,47,52,49],[52,50,52,51],[52,58,52,60],[52,61,52,63],[53,38,53,40],[53,41,53,43],[54,1,54,7],[54,8,54,14],[54,18,54,20],[54,21,54,22],[54,23,54,25],[54,26,54,28],[54,29,54,31],[54,32,54,34],[54,35,54,37],[54,38,54,40],[54,41,54,43],[54,44,54,46],[54,47,54,49],[54,50,54,51],[54,58,54,60],[56,1,56,7],[56,8,56,14],[56,18,56,20],[56,21,56,22],[56,23,56,25],[56,26,56,28],[56,29,56,31],[56,32,56,34],[56,35,56,37],[54,15,54,17],[55,15,55,17],[56,15,56,17],[57,61,57,63],[58,1,58,7],[58,8,58,14],[58,18,58,20],[55,21,55,22],[55,23,55,25],[55,26,55,28],[55,29,55,31],[55,32,55,34],[55,35,55,37],[55,38,55,40],[55,41,55,43],[55,44,55,46],[55,47,55,49],[55,50,55,51],[55,58,55,60],[55,61,55,63],[56,38,56,40],[56,41,56,43],[56,44,56,46],[56,47,56,49],[56,50,56,51],[56,58,56,60]],"merged_total":1934,"flags":["merged_cut"]}
["Residence Analysis of all lots/spaces (unhide/hide rows if your Project has more/less lots/spaces than shown)"]
["Total Project lots/spaces",null,null,{"$f":"(COUNTA(A4:A103))","v":0},null,{"$f":"IF(AND('Applicant & Project Info'!AM47=\"2\",'Applicant & Project Info'!V89<>D2),\"No\",IF(AND('Applicant & Project Info'!AM47=\"3\",'Applicant & Project Info'!V99<>D2),\"No\",IF(AND('Applicant & Project Info'!AM47=\"4\",'Applicant & Project Info'!V109<>D2),\"No\",\"Yes\")))","v":"Yes"},"Total low-income (80% AMI or less) lots/spaces:",null,null,null,null,null,{"$f":"COUNTIFS(A4:A103,\"Yes\",BM4:BM103,\"Yes\")","v":0},null,{"$f":"IF(AND('Applicant & Project Info'!AM47=\"2\",'Applicant & Project Info'!AG89<>M2),\"No\",IF(AND('Applicant & Project Info'!AM47=\"3\",'Applicant & Project Info'!AG99<>M2),\"No\",IF(AND('Applicant & Project Info'!AM47=\"4\",'Applicant & Project Info'!AG109<>M2),\"No\",\"Yes\")))","v":"Yes"},"Percentage of low-income lots/spaces vs total:",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(A4:A103)=0,0,COUNTIFS(A4:A103,\"Yes\",BM4:BM103,\"Yes\")/COUNTA(A4:A103))","v":0},null,null,"Total monthly space rent for all lots/spaces:",null,null,null,null,null,{"$f":"SUM(AG4:AI103)","v":0},null,null,"Monthly household costs (not including lot/space rent and HOA fees) - CCR §6920",null,null,null,null,null,null,null,null,null,null,null,"Monthly household costs (inc. rent/fees)",null,null,null,null,"Program Assistance",null,null,{"$f":"SUM(BD4:BF103)*12","v":0},null,null,"Household support %:",null,null,{"$f":"IF(COUNTA(A4:A103)=0,0,COUNTIF(BJ4:BL103,\"Yes\")/COUNTA(A4:A103))","v":0}]
["Low-income household?","Name(s) of Residents",null,null,null,null,null,null,"Address and lot/space #",null,null,null,null,null,null,"Household Owner or Renter",null,null,"Mobilehome rehab amt. (low-income hshld only)",null,null,"Hshld size",null,"Annual household income",null,null,"Maximum income for low-income household",null,null,"Monthly household income",null,null,"Monthly lot/space rent and HOA fees",null,null,"Monthly utilities cost",null,null,"Monthly insurance cost",null,null,"Monthly loan payments",null,null,"Monthly taxes, reg. fees and maintenance",null,null,"Total monthly costs",null,null,"Monthly cost as % of income",null,"Low-income household 30% of mo. income",null,null,"Monthly household assistance",null,null,"Participates  in conversion and management",null,null,"Supports park conversion",null,null,"Hshld income test","Hshld costs test"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V4=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V4+1))","v":""},null,null,{"$f":"IF(X4>0,X4/12,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AG4:AU4)>0,SUM(AG4:AU4),\"\")","v":""},null,null,{"$f":"IF(OR(AV4=\"\",AD4=\"\"),\"\",AV4/AD4)","v":""},null,{"$f":"IF(AD4=\"\",\"\",IF(A4=\"Yes\",AD4*0.3,\"\"))","v":""},null,null,{"$f":"IF(OR(AD4=\"\",AV4=\"\"),\"\",IF(AD4*0.3>=AV4,0,IF(A4=\"Yes\",AV4-(AD4*0.3),\"\")))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(X4>AA4,\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(AY4>0.3,\"No\",\"Yes\")","v":"No"},{"$f":"IF(OR(BM4=\"No\",BN4=\"No\"),\"No\",\"Yes\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V5=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V5+1))","v":""},null,null,{"$f":"IF(X5>0,X5/12,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes",{"$f":"IF(AY5>0.3,\"No\",\"Yes\")","v":"No"},{"$f":"IF(OR(BM5=\"No\",BN5=\"No\"),\"No\",\"Yes\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V6=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V6+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V7=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V7+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes",{"$f":"IF(AY7>0.3,\"No\",\"Yes\")","v":"No"},{"$f":"IF(OR(BM7=\"No\",BN7=\"No\"),\"No\",\"Yes\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V8=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V8+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V9=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V9+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V10=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V10+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V11=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V11+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V12=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V12+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V13=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V13+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V14=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V14+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V15=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V15+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V16=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V16+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V17=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V17+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V18=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V18+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V19=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V19+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V20=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V20+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V21=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V21+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V22=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V22+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V23=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V23+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V24=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V24+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V25=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V25+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V26=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V26+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V27=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V27+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V28=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V28+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V29=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V29+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V30=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V30+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V31=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V31+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V32=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V32+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V33=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V33+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V34=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V34+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V35=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V35+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V36=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V36+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AG36:AU36)>0,SUM(AG36:AU36),\"\")","v":""},null,null,{"$f":"IF(OR(AV36=\"\",AD36=\"\"),\"\",AV36/AD36)","v":""},null,{"$f":"IF(AD36=\"\",\"\",IF(A36=\"Yes\",AD36*0.3,\"\"))","v":""},null,null,{"$f":"IF(OR(AD36=\"\",AV36=\"\"),\"\",IF(AD36*0.3>=AV36,0,IF(A36=\"Yes\",AV36-(AD36*0.3),\"\")))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(X36>AA36,\"No\",\"Yes\")","v":"Yes"},"No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V37=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V37+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V38=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V38+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V39=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V39+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V40=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V40+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V41=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V41+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V42=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V42+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V43=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V43+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V44=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V44+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes",{"$f":"IF(AY44>0.3,\"No\",\"Yes\")","v":"No"},{"$f":"IF(OR(BM44=\"No\",BN44=\"No\"),\"No\",\"Yes\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V45=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V45+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V46=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V46+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V47=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V47+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V48=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V48+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V49=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V49+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V50=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V50+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V51=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V51+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V52=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V52+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V53=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V53+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V54=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V54+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V55=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V55+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V56=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V56+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V57=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V57+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V58=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V58+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V59=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V59+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V60=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V60+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V61=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V61+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V62=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V62+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V63=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V63+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V64=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V64+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V65=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V65+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V66=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V66+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V67=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V67+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V68=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V68+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AG68:AU68)>0,SUM(AG68:AU68),\"\")","v":""},null,null,{"$f":"IF(OR(AV68=\"\",AD68=\"\"),\"\",AV68/AD68)","v":""},null,{"$f":"IF(AD68=\"\",\"\",IF(A68=\"Yes\",AD68*0.3,\"\"))","v":""},null,null,{"$f":"IF(OR(AD68=\"\",AV68=\"\"),\"\",IF(AD68*0.3>=AV68,0,IF(A68=\"Yes\",AV68-(AD68*0.3),\"\")))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(X68>AA68,\"No\",\"Yes\")","v":"Yes"},"No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V69=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V69+1))","v":""},null,null,{"$f":"IF(X69>0,X69/12,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V70=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V70+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V71=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V71+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V72=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V72+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V73=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V73+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V74=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V74+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V75=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V75+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V76=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V76+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V77=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V77+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V78=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V78+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V79=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V79+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V80=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V80+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V81=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V81+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V82=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V82+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V83=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V83+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V84=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V84+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V85=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V85+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V86=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V86+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V87=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V87+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V88=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V88+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V89=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V89+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V90=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V90+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V91=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V91+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V92=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V92+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V93=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V93+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V94=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V94+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V95=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V95+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V96=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V96+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V97=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V97+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V98=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V98+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V99=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V99+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V100=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V100+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AG100:AU100)>0,SUM(AG100:AU100),\"\")","v":""},null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V101=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V101+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V102=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V102+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Applicant & Project Info'!$AF$49=\"\",V103=\"\"),\"\",INDEX('2020 Low Income Limits'!$A$1:$I$59,MATCH('Applicant & Project Info'!$AF$49,'2020 Low Income Limits'!$A$1:$A$59,0),V103+1))","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,"",null,null,null,null,null,null,null,null,"Yes","No","No"]

{"sheet":"2020 Low Income Limits","index":5,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County",1,2,3,4,5,6,7,8,"Median"]
["Alameda",73100,83550,94000,104400,112800,121150,129500,137850,111700]
["Alpine",46600,53250,59900,66550,71900,77200,82550,87850,94900]
["Amador",44100,50400,56700,62950,68000,73050,78100,83100,73600]
["Butte",39600,45250,50900,56550,61100,65600,70150,74650,66500]
["Calaveras",45050,51450,57900,64300,69450,74600,79750,84900,75300]
["Colusa",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Contra Costa",73100,83550,94000,104400,112800,121150,129500,137850,111700]
["Del Norte",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["El Dorado",48350,55250,62150,69050,74600,80100,85650,91150,83600]
["Fresno",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Glenn",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Humboldt",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Imperial",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Inyo ",42100,48100,54100,60100,64950,69750,74550,79350,72700]
["Kern",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Kings",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Lake",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Lassen",39600,45250,50900,56550,61100,65600,70150,74650,69400]
["Los Angeles",63100,72100,81100,90100,97350,104550,111750,118950,73100]
["Madera",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Marin",97600,111550,125500,139400,150600,161750,172900,184050,136800]
["Mariposa",39150,44750,50350,55900,60400,64850,69350,73800,65500]
["Mendocino",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Merced",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Modoc",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Mono",45300,51800,58250,64700,69900,75100,80250,85450,81200]
["Monterey",54250,62000,69750,77500,83700,89900,96100,102300,74100]
["Napa",60100,68650,77250,85800,92700,99550,106400,113300,100400]
["Nevada",48200,55050,61950,68800,74350,79850,85350,90850,85100]
["Orange",71750,82000,92250,102450,110650,118850,127050,135250,97900]
["Placer",48350,55250,62150,69050,74600,80100,85650,91150,83600]
["Plumas",40450,46200,52000,57750,62400,67000,71650,76250,70700]
["Riverside",42200,48200,54250,60250,65100,69900,74750,79550,69700]
["Sacramento",48350,55250,62150,69050,74600,80100,85650,91150,83600]
["San Benito",57150,65300,73450,81600,88150,94700,101200,107750,84500]
["San Bernardino",42200,48200,54250,60250,65100,69900,74750,79550,69700]
["San Diego",64700,73950,83200,92400,99800,107200,114600,122000,86300]
["San Francisco",97600,111550,125500,139400,150600,161750,172900,184050,136800]
["San Joaquin",42000,48000,54000,60000,64800,69600,74400,79200,71400]
["San Luis Obispo",54350,62100,69850,77600,83850,90050,96250,102450,87500]
["San Mateo",97600,111550,125500,139400,150600,161750,172900,184050,136800]
["Santa Barbara",66750,76250,85800,95300,102950,110550,118200,125800,79600]
["Santa Clara",78550,89750,100950,112150,121150,130100,139100,148050,131400]
["Santa Cruz",74350,85000,95600,106200,114700,123200,131700,140200,98000]
["Shasta",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Sierra",45100,51550,58000,64400,69600,74750,79900,85050,71800]
["Siskiyou",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Solano",51800,59200,66600,73950,79900,85800,91700,97650,85700]
["Sonoma",63650,72750,81850,90900,98200,105450,112750,120000,93300]
["Stanislaus",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Sutter",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Tehama",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Trinity",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Tulare",39150,44750,50350,55900,60400,64850,69350,73800,64800]
["Tuolumne",39700,45400,51050,56700,61250,65800,70350,74850,66700]
["Ventura",63250,72300,81350,90350,97600,104850,112050,119300,97800]
["Yolo",51800,59200,66600,74000,79950,85850,91800,97700,87900]
["Yuba",39150,44750,50350,55900,60400,64850,69350,73800,64800]

{"sheet":"Threshold & Standard Conditions","index":6,"n_rows":87,"n_cols":39,"rows_kept":87,"cut":false,"hidden":false,"merged":[[56,0,56,10],[56,11,56,24],[21,0,21,37],[16,0,16,37],[83,35,83,37],[83,22,83,23],[83,24,83,29],[82,35,82,37],[82,25,82,34],[82,21,82,24],[83,30,83,34],[63,0,63,22],[63,23,63,24],[70,21,70,22],[56,25,56,37],[57,0,57,22],[57,23,57,24],[48,0,48,13],[49,0,49,2],[65,0,65,22],[65,23,65,24],[66,28,66,30],[48,14,48,15],[48,36,48,37],[78,25,78,37],[71,0,71,27],[72,0,72,27],[70,0,70,6],[70,9,70,20],[75,0,75,35],[75,36,75,37],[76,0,76,22],[76,23,76,24],[74,12,74,21],[74,22,74,29],[74,0,74,7],[74,8,74,11],[74,30,74,31],[74,32,74,37],[78,0,78,22],[78,23,78,24],[73,0,73,7],[73,8,73,10],[70,7,70,8],[77,0,77,2],[77,3,77,10],[77,11,77,29],[77,30,77,35],[12,0,12,37],[13,0,13,2],[13,3,13,10],[13,11,13,29],[13,30,13,35],[13,36,13,37],[14,0,14,37],[15,0,15,2],[15,3,15,10],[15,11,15,29],[15,30,15,35],[15,36,15,37],[5,25,5,33],[5,34,5,37],[6,0,6,37],[11,36,11,37],[10,0,10,37],[11,0,11,2],[11,3,11,10],[11,11,11,29],[11,30,11,35],[7,0,7,37],[0,0,0,34],[0,35,0,37],[52,17,52,23],[52,24,52,27],[52,0,52,9],[52,28,52,37],[1,0,1,37],[2,0,2,35],[2,36,2,37],[5,0,5,5],[5,6,5,24],[8,0,8,2],[8,3,8,10],[8,11,8,29],[8,30,8,35],[8,36,8,37],[9,0,9,2],[9,3,9,10],[9,11,9,29],[9,30,9,35],[9,36,9,37],[3,0,3,37],[4,0,4,35],[4,36,4,37],[57,25,57,37],[59,0,59,22],[59,23,59,24],[66,31,66,37],[61,3,61,10],[61,11,61,29],[61,30,61,35],[61,36,61,37],[62,0,62,2],[62,3,62,10],[62,11,62,29],[62,30,62,35],[62,36,62,37],[63,25,63,37],[59,25,59,37],[65,25,65,37],[61,0,61,2],[51,0,51,37],[52,10,52,16],[54,0,54,37],[66,0,66,25],[70,30,70,31],[70,32,70,37],[70,23,70,29],[17,0,17,37],[24,0,24,37],[25,0,25,2],[25,3,25,10],[25,11,25,29],[25,30,25,35],[25,36,25,37],[26,0,26,37],[27,0,27,35],[27,36,27,37],[18,0,18,37],[19,0,19,35],[19,36,19,37],[22,0,22,2],[22,3,22,10],[22,11,22,29],[22,30,22,35],[22,36,22,37],[20,0,20,2],[20,3,20,10],[20,11,20,29],[20,30,20,35],[20,36,20,37],[43,0,43,37],[45,0,45,2],[45,3,45,10],[45,11,45,29],[45,30,45,35],[45,36,45,37],[28,0,28,37],[34,19,34,37],[34,0,34,18],[33,0,33,35],[33,36,33,37],[29,36,29,37],[35,0,35,37],[36,0,36,37],[32,0,32,2],[32,3,32,10],[32,11,32,29],[32,30,32,35],[32,36,32,37],[29,0,29,13],[29,14,29,15],[47,0,47,2],[47,3,47,10],[47,11,47,29],[47,30,47,35],[47,36,47,37],[46,0,46,13],[44,0,44,13],[44,16,44,22],[46,16,46,22],[44,23,44,24],[46,23,46,24],[44,25,44,37],[46,25,46,37],[44,14,44,15],[46,14,46,15],[38,19,38,37],[39,0,39,37],[40,0,40,37],[41,0,41,35],[41,36,41,37],[42,0,42,2],[42,3,42,10],[42,11,42,29],[42,30,42,35],[42,36,42,37],[69,0,69,2],[69,3,69,10],[69,11,69,29],[67,0,67,2],[67,3,67,10],[67,11,67,29],[67,30,67,35],[55,0,55,37],[60,0,60,2],[60,3,60,10],[60,11,60,29],[60,30,60,35],[60,36,60,37],[64,0,64,2],[64,3,64,10],[64,11,64,29],[64,30,64,35],[64,36,64,37],[58,0,58,37],[68,31,68,37],[77,36,77,37],[66,26,66,27],[73,11,73,21],[73,22,73,24],[73,25,73,34],[73,35,73,37],[71,28,71,29],[72,28,72,29],[69,30,69,35],[69,36,69,37],[68,26,68,27],[68,28,68,30],[68,0,68,22],[68,23,68,24],[67,36,67,37],[86,3,86,10],[86,11,86,29],[86,30,86,35],[86,36,86,37],[85,0,85,37],[79,0,79,2],[79,3,79,10],[79,11,79,29],[79,30,79,35],[79,36,79,37],[81,25,81,33],[81,7,81,24],[80,36,80,37],[81,34,81,37],[81,0,81,6],[83,5,83,21],[83,0,83,4],[80,0,80,35],[86,0,86,2],[84,0,84,2],[84,3,84,10],[84,11,84,29],[84,30,84,35],[84,36,84,37],[29,16,29,35],[31,0,31,37],[23,0,23,2],[23,3,23,10],[23,11,23,29],[23,30,23,35],[23,36,23,37],[30,0,30,37],[53,0,53,2],[53,3,53,10],[53,11,53,29],[53,30,53,35],[53,36,53,37],[50,0,50,37],[49,3,49,10],[49,11,49,29],[49,30,49,35],[49,36,49,37],[48,16,48,30],[48,31,48,32],[48,33,48,35],[37,0,37,35],[37,36,37,37],[38,0,38,18]]}
["Threshold Requirements and Standard Conditions",null,null,null,null,null,null,null,null,null,null,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":"'Applicant & Project Info'!AJ1","v":"Rev. 6/12/20"}]
["NOFA IV(1) low-income households - affordable housing costs"]
["For all low-income (80% AMI or less) households, are \"housing costs\" affordable (no more than 30% of monthly income; see Residence Analysis tab)?"]
["NOFA IV(3), §8012(b)(8) Site control"]
["Does the Applicant have site control? Must be in Applicant's name at time application is submitted and enforceable for at least 120 days beyond submittal date."]
["Form of site control:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Most recent document execution date:"]
["Provide details below for unusual site control issues or site control special circumstances:"]
[]
["File Name:",null,null,"Site Control ",null,null,null,null,null,null,null,"Site control documentation",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,"Preliminary Title Report",null,null,null,null,null,null,null,"Provide a current preliminary report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["NOFA IV(4) Applicants converting a subdivided, condominium, limited equity housing cooperative, or stock cooperative mobilehome park"]
["File Name:",null,null,"Subdivision Public Report",null,null,null,null,null,null,null,"Preliminary or Final Subdivision Public Report obtained from the Department of Real Estate (DRE). Exception is an application by the above-named entities for short-term conversion financing as described by HSC §50783.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["NOFA IV(5) Qualified nonprofit housing applicants: evidence of resident participation in the conversion and management of the park"]
["File Name:",null,null,"Resident Participation",null,null,null,null,null,null,null,"Documentation showing resident participation on the board of directors of the entity that acquires ownership of the park; or the establishment of, and consultation with, a permanent resident advisory board.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["NOFA IV(6) Resident organization applicants: two-thirds of residents support park conversion to resident ownership"]
["File Name:",null,null,"Resident Support",null,null,null,null,null,null,null,"Certifications of Resident Support indicating support for the park conversion to resident ownership. If the park is a subdivision, stock, or limited-equity housing cooperative and individual interests are being purchased, two-thirds of the residents must be buyers of their subdivided space or co-op membership share.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["NOFA IV(7) Local public entities - explain below the extent to which Project will receive below-market financing, resources, and any other assistance"]
[]
["NOFA V Financial Feasibility"]
["Applicant certifies the proposed Project will be financially feasible including development costs that are appropriate and reasonable and MPRROP funds will be used in the most efficient manner to assist the maximum number of low-income households.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signatories to receiving MPRROP funds"]
["File Name:",null,null,"Financial Statements",null,null,null,null,null,null,null,"Park audited financial statements for prior fiscal year. Describe below any extenuating circumstances. Audit must conform to HCD Audited Financial Statements Handbook.",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,"Physical Needs Assessment",null,null,null,null,null,null,null,"Physical Needs Assessment - only applicable if rehabilitating park or individual spaces",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,"Management Plan",null,null,null,null,null,null,null,"Copy of management plan including executed current management agreements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["NOFA IX(1) & CCR §8004(b) Nonprofit Housing & Local Public Entity applicants (except disaster loans)-2/3 of residents must support park acquisition"]
["File Name:",null,null,"Resident Support",null,null,null,null,null,null,null,"Certifications of Resident Support indicating support for the park acquisition.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["NOFA IX(2) Nonprofit Housing applicants:  verification that at least 30% of park residents are low-income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tenants who don't own the mobilehome"]
["Are at least 30% of park residents low-income (80% AMI or less)?",null,null,null,null,null,null,null,null,null,null,null,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('Applicant & Project Info'!F4<>\"Qualified nonprofit housing sponsor\",\"N/A\",IF('Residence Analysis'!X2>=0.3,\"Yes\",\"No\"))","v":"N/A"},null,"Owners who own the mobilehome"]
["NOFA IX(4) and CCR §8020 Displacement and 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,null,null,null,"Both tenants who don't own the mobilehome and owners who own the mobilehome"]
["Will Project potentially involve displacement of residents?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If Yes, will it be mitigated in accordance with state relocation law (Gov. Code §66427.5)?"]
["If Project will potentially involve displacement of residents, provide a statement below or a Relocation Plan concerning the potential for displacement of residents from the Project, specific displacement measures, and relocation benefits consistent with §8020."]
["   "]
["File Name:",null,null,"Relocation Plan",null,null,null,null,null,null,null,"Relocation plan covering both temporary and permanent displacement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?",null,null,null,null,null,null,null,"Signatories to receiving MPRROP funds"]
["(a) Will any park resident be temporarily displaced through rent increases or other means?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not signatories to receiving MPRROP funds, Some are signatories to receiving MPRROP funds"]
["If (a) is Yes, are the displaced individual(s) tenants or owners of the mobilehome?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Some are signatories to receiving MPRROP funds"]
["If (a) is Yes, are the displaced individual(s) signatories to receiving MPRROP funds (have the authority to sign as applicants to receive MPRROP funds)?"]
["   "]
["(b) Will anyone have to permanently move or be permanently displaced from their mobilehome as a result of the activity undertaken using the MPRROP funds (includes people moving due to failure to meet income or other tenancy requirements)?  Permanently for relocation purposes is deemed to be more than 1 year."]
["If (b) is Yes, are the displaced individual(s) tenants or owners of the mobilehome?"]
["If (b) is Yes, are the displaced individual(s) signatories to receiving MPRROP funds (have the authority to sign as applicants to receive MPRROP funds)?"]
["   "]
["Are there any existing agreements or interests with non-mobilehome owners that will be terminated due to MPRROP funding? (examples: vacant land used for event parking, fruit stands, billboards, etc.) If yes, must submit agreement(s)"]
["File Name:",null,null,"Other Agreements",null,null,null,null,null,null,null,"Agreements or interests with non-mobilehome owners that will be terminated due to MPRROP funding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["NOFA IX(6) Phase I Environmental Site Assessment and any follow-up studies required by the Phase I Assessment"]
["Is California Environmental Quality Act (CEQA) required? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Determination date:"]
["File Name:",null,null,"CEQA",null,null,null,null,null,null,null,"Copy of CEQA determination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Is the National Environmental Policy Act (NEPA) required?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Determination date:"]
["File Name:",null,null,"NEPA",null,null,null,null,null,null,null,"Copy of NEPA determination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Is project located in an Earthquake Fault Zone?  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Was a Phase 1 Environmental Assessment Report completed?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report date:"]
["File Name:",null,null,"Phase 1",null,null,null,null,null,null,null,"Copy of Phase I Assessment Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["HSC §50781(i) Permit to Operate a Mobilehome Park"]
["Mobilehome parks must have an active or suspended permit to operate as a Mobilehome park as defined in §50781(i). Existing unpermitted Mobilehome parks may be eligible for rehabilitation loans and/or grants, subject to additional conditions and limitations. Recreational vehicle parks do not qualify for the MPRROP program unless using program funding to convert to a permitted Mobilehome park.  Permit to Operate (if no permit, explain why below including when permit is anticipated)."]
["1. Identification Number: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Expiration Date:"]
["File Name:",null,null,"Permit to Operate",null,null,null,null,null,null,null,"Copy of permit to operate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
[]
["NOFA IX(21) Governmental Approvals"]
["What is the current zoning designation for park?"]
["Is zoning change required?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If yes, describe required change and timeline below:"]
[]
["Is Project consistent with zoning and land use requirements?"]
["File Name:",null,null,"Zoning Map",null,null,null,null,null,null,null,"Zoning map and project location",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,"Aerial Map",null,null,null,null,null,null,null,"Aerial map and project location",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,"Site Plan",null,null,null,null,null,null,null,"Site plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Is the park required to have a conditional use permit (CUP)?"]
["File Name:",null,null,"Conditional Use Permit",null,null,null,null,null,null,null,"CUP documentation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Is Project subject to Subdivision Map Act - Government Code §66410? (If yes, complete a-c below)"]
["a. Date of tentative map approval",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,"Attached and on USB?"]
["File Name:",null,null,"Subdivision Map",null,null,null,null,null,null,null,"Copy of subdivision map",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["b. Certificate of Compliance (in lieu of map approval)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,"Attached and on USB?"]
["File Name:",null,null,"Cert of Compliance",null,null,null,null,null,null,null,"Copy of certificate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["c. City/County planner name",null,null,null,null,null,null,"Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:",null,null,null,null,null,null,null,null,"Phone:"]
["Will individual interests such as memberships, shares, lots or spaces be sold?"]
["Will Project require issuance of a Public Report from the California Department of Real Estate (DRE)? (If yes, complete below)"]
["Submittal date of DRE application:",null,null,null,null,null,null,null,null,null,null,"Issuance date of DRE Conditional Public Report:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Issuance date of DRE Final Public Report:"]
["RE file number assigned to Project:",null,null,null,null,null,null,null,null,null,null,null,"DRE Deputy assigned to project (Name):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
["Will the Project be a limited equity housing cooperative claiming an exemption under the Business and Professional (B&P) Code §11003.4? "]
["Submit Project operating documents pursuant to B&P Code §11003.4(b)(4)."]
["File Name:",null,null,"Operating Documents",null,null,null,null,null,null,null,"Operating documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Have you submitted DRE Form 662 (Exemption Request) §11003.4(b)?"]
["File Name:",null,null,"Exemption Opinion",null,null,null,null,null,null,null,"Copy of opinion of attorney that the cooperative meets the requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["Will securities subject to California Department of Corporations (DOC) approval be sold? (If Yes, complete section below)"]
["Name on application to DOC:",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 Number:"]
["Date of submittal of application to DOC for a permit to issue securities:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date of issuance of permit to issue securities:",null,null,null,null,null,null,null,null,null,null,null,"Attached and on USB?"]
["DOC Contact Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:",null,null,null,null,null,null,null,"DOC approval date:"]
["File Name:",null,null,"DOC Approval",null,null,null,null,null,null,null,"DOC approval documentation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]
["If \"No\", and DOC-exempt shares will be sold, provide documentation showing completion of steps to qualify for exemption or a timetable showing the exemption will be approved. Identify the California code section which authorizes the exemption."]
["File Name:",null,null,"DOC Exemption",null,null,null,null,null,null,null,"DOC exemption documentation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uploaded to HCD?"]

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

{"sheet":"Dev Sources","index":8,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,1,5,2],[1,0,1,9],[0,0,0,13],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,0,3,0],[2,1,3,2],[2,3,3,3],[2,4,3,4],[6,1,6,2],[7,1,7,2],[8,1,8,2],[11,0,11,3],[14,0,15,0],[14,1,15,2],[14,3,15,3],[13,0,13,13],[12,0,12,13],[14,11,15,11],[14,12,15,12],[14,13,15,13],[2,10,11,13],[10,1,10,2],[9,1,9,2],[4,1,4,2],[14,4,15,4],[25,0,25,13],[21,1,21,2],[22,1,22,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[24,0,24,13],[23,0,23,3],[23,5,23,9],[14,5,14,6],[14,7,15,7],[14,8,14,9],[14,10,15,10]]}
["Sources of Development Funds"]
["Construction Period Sources of Funds "]
["Committed?","Source Name\n(in lien priority order)",null,"Lien\nNo.","Amount","Interest\nRate","Required\nPayment ","Loan Term\n(months)","Residential\nAmount","Commercial\nAmount"," "]
[]
[null,"MPRROP - HCD"]
[]
[]
[]
[]
[]
[]
["Construction Totals",null,null,null,{"$f":"SUM(E5:E11)","v":0}," ",null,null,{"$f":"SUM(I5:I11)","v":0},{"$f":"SUM(J5:J11)","v":0}]
[]
["Permanent Sources of Funds "]
["Committed?","Source Name\n(in lien priority order)",null,"Lien\nNo.","Amount","Interest Rate ",null,"Amortization\nPeriod (yrs.)","Repayment Terms",null,"Required\nResidential\nDebt Service","Required\nCommercial\nDebt Service","Residential\nAmount","Commercial\nAmount"]
[null,null,null,null,null,"Rate","Type ",null,"Type","Due in (yrs)"]
[null,"MPRROP - HCD"]
[]
[]
[]
[]
[]
[]
["Permanent Totals",null,null,null,{"$f":"SUM(E17:E23)","v":0}," ",null,null,null,null,{"$f":"SUM(K17:K23)","v":0},{"$f":"SUM(L17:L23)","v":0},{"$f":"SUM(M17:M23)","v":0},{"$f":"SUM(N17:N23)","v":0}]
["Applicant Comments"]

{"sheet":"Dev Budget","index":9,"n_rows":122,"n_cols":13,"rows_kept":122,"cut":false,"hidden":false,"merged":[[0,0,0,8],[0,9,0,11],[2,0,2,8],[2,9,2,11]]}
["Development Budget and Permanent Sources of Funds",null,null,null,null,null,null,null,null,"Commercial Sources ",null,null,"Requested Amt"]
["USES OF FUNDS",{"$f":"'Dev Sources'!B17&\"*\"","v":"MPRROP - HCD*"},{"$f":"'Dev Sources'!B18","v":0},{"$f":"'Dev Sources'!B19","v":0},{"$f":"'Dev Sources'!B20","v":0},{"$f":"'Dev Sources'!B21","v":0},{"$f":"'Dev Sources'!B22","v":0},{"$f":"'Dev Sources'!B23","v":0},"Total\nResidential\nSources/Costs","Total\nCommercial\nSources/Costs","Source Name:","Source Name:",{"$f":"IF('Applicant & Project Info'!AM47=\"1\",'Applicant & Project Info'!P75,IF('Applicant & Project Info'!AM47=\"2\",'Applicant & Project Info'!P85,IF('Applicant & Project Info'!AM47=\"3\",'Applicant & Project Info'!P96,IF('Applicant & Project Info'!AM47=\"4\",'Applicant & Project Info'!P107,IF('Applicant & Project Info'!AM47=\"5\",'Applicant & Project Info'!P118,0)))))","v":0}]
[{"$f":"\"*Eligible uses of MPRROP funds: \"&'Applicant & Project Info'!AM48","v":"*Eligible uses of MPRROP funds: "}]
["LAND COST/ACQUISITION"]
["Land Cost or Value",null,null,null,null,null,null,null,{"$f":"SUM(B5:H5)","v":0},{"$f":"K5+L5","v":0}]
["Demolition",null,null,null,null,null,null,null,{"$f":"SUM(B6:H6)","v":0},{"$f":"K6+L6","v":0}]
["Legal",null,null,null,null,null,null,null,{"$f":"SUM(B7:H7)","v":0},0]
["Land Lease Rent Prepayment",null,null,null,null,null,null,null,{"$f":"SUM(B8:H8)","v":0},0]
["Total Land Cost or Value",{"$f":"SUM(B5:B8)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K5:K8)","v":0},{"$f":"SUM(L5:L8)","v":0}]
["Existing Improvements Cost or Value",null,null,null,null,null,null,null,{"$f":"SUM(B10:H10)","v":0},0]
["Off-Site Improvements",null,null,null,null,null,null,null,{"$f":"SUM(B11:H11)","v":0},0]
["Total Acquisition Cost",{"$f":"SUM(B10:B11)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K10:K11)","v":0},{"$f":"SUM(L10:L11)","v":0}]
["Total Land Cost / Acquisition Cost",{"$f":"B9+B12","v":0},{"$f":"C9+C12","v":0},0,0,0,0,0,0,0,{"$f":"SUM(K9+K12)","v":0},{"$f":"SUM(L9+L12)","v":0}]
["Predevelopment Interest/Holding Cost",null,null,null,null,null,null,null,{"$f":"SUM(B14:H14)","v":0},0]
["Assumed, Accrued Interest on Existing Debt (Rehab/Acq)",null,null,null,null,null,null,null,{"$f":"SUM(B15:H15)","v":0},0]
["Excess Purchase Price Over Appraisal",null,null,null,null,null,null,null,{"$f":"SUM(B16:H16)","v":0},0]
["REHABILITATION"]
["Site Work",null,null,null,null,null,null,null,{"$f":"SUM(B18:H18)","v":0},{"$f":"K18+L18","v":0}]
["Structures",null,null,null,null,null,null,null,0,0]
["General Requirements",null,null,null,null,null,null,null,0,0]
["Contractor Overhead",null,null,null,null,null,null,null,0,0]
["Contractor Profit",null,null,null,null,null,null,null,0,0]
["Prevailing Wages",null,null,null,null,null,null,null,0,0]
["General Liability Insurance",null,null,null,null,null,null,null,0,0]
["Urban Greening",null,null,null,null,null,null,null,0,0]
["Other Rehabilitation: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Rehabilitation: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Rehabilitation: (Specify)",null,null,null,null,null,null,null,0,0]
["Total Rehabilitation Costs",{"$f":"SUM(B18:B28)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K18:K28)","v":0},{"$f":"SUM(L18:L28)","v":0}]
["Total Relocation Expenses",null,null,null,null,null,null,null,{"$f":"SUM(B30:H30)","v":0},0]
["NEW CONSTRUCTION"]
["Site Work",null,null,null,null,null,null,null,{"$f":"SUM(B32:H32)","v":0},{"$f":"K32+L32","v":0}]
["Structures",null,null,null,null,null,null,null,0,0]
["General Requirements",null,null,null,null,null,null,null,0,0]
["Contractor Overhead",null,null,null,null,null,null,null,0,0]
["Contractor Profit",null,null,null,null,null,null,null,0,0]
["Prevailing Wages",null,null,null,null,null,null,null,0,0]
["General Liability Insurance",null,null,null,null,null,null,null,0,0]
["Urban Greening",null,null,null,null,null,null,null,0,0]
["Other New Construction: (Specify)",null,null,null,null,null,null,null,0,0]
["Other New Construction: (Specify)",null,null,null,null,null,null,null,0,0]
["Other New Construction: (Specify)",null,null,null,null,null,null,null,0,0]
["Total New Construction Costs",{"$f":"SUM(B32:B42)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K32:K42)","v":0},{"$f":"SUM(L32:L42)","v":0}]
["ARCHITECTURAL FEES"]
["Design",null,null,null,null,null,null,null,{"$f":"SUM(B45:H45)","v":0},{"$f":"K45+L45","v":0}]
["Supervision",null,null,null,null,null,null,null,{"$f":"SUM(B46:H46)","v":0},0]
["Total Architectural Costs",{"$f":"SUM(B44:B46)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K44:K46)","v":0},{"$f":"SUM(L44:L46)","v":0}]
["Total Survey & Engineering",null,null,null,null,null,null,null,{"$f":"SUM(B48:H48)","v":0},0]
["CONSTRUCTION INTEREST & FEES"]
["Construction Loan Interest",null,null,null,null,null,null,null,{"$f":"SUM(B50:H50)","v":0},{"$f":"K50+L50","v":0}]
["Origination Fee",null,null,null,null,null,null,null,0,0]
["Credit Enhancement/Application Fee",null,null,null,null,null,null,null,0,0]
["Bond Premium",null,null,null,null,null,null,null,0,0]
["Cost of Issuance",null,null,null,null,null,null,null,0,0]
["Title & Recording",null,null,null,null,null,null,null,0,0]
["Taxes",null,null,null,null,null,null,null,0,0]
["Insurance",null,null,null,null,null,null,null,0,0]
["Employment Reporting",null,null,null,null,null,null,null,0,0]
["Other Construction Int. & Fees: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Construction Int. & Fees: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Construction Int. & Fees: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Construction Int. & Fees: (Specify)",null,null,null,null,null,null,null,0,0]
["Total Construction Interest & Fees",{"$f":"SUM(B50:B62)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K50:K62)","v":0},{"$f":"SUM(L50:L62)","v":0}]
["PERMANENT FINANCING"]
["Loan Origination Fee",null,null,null,null,null,null,null,{"$f":"SUM(B65:H65)","v":0},{"$f":"K65+L65","v":0}]
["Credit Enhancement/Application Fee",null,null,null,null,null,null,null,0,0]
["Title & Recording",null,null,null,null,null,null,null,0,0]
["Taxes",null,null,null,null,null,null,null,0,0]
["Insurance",null,null,null,null,null,null,null,0,0]
["Other Perm. Financing Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Perm. Financing Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Perm. Financing Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Perm. Financing Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Total Permanent Financing Costs",{"$f":"SUM(B65:B73)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K65:K73)","v":0},{"$f":"SUM(L65:L73)","v":0}]
["Subtotals Forward",{"$f":"B9+B12+B14+B15+B16+B29+B30+B43+B47+B48+B63+B74","v":0},{"$f":"C9+C12+C14+C15+C16+C29+C30+C43+C47+C48+C63+C74","v":0},0,0,0,0,0,0,0,0,0]
["LEGAL FEES"]
["Legal Paid by Applicant",null,null,null,null,null,null,null,{"$f":"SUM(B77:H77)","v":0},0]
["Other Attorney Costs: (Specify)",null,null,null,null,null,null,null,{"$f":"SUM(B78:H78)","v":0},0]
["Other Attorney Costs: (Specify)",null,null,null,null,null,null,null,{"$f":"SUM(B79:H79)","v":0},0]
["Other Attorney Costs: (Specify)",null,null,null,null,null,null,null,{"$f":"SUM(B80:H80)","v":0},0]
["Total Attorney Costs",{"$f":"SUM(B76:B80)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(J76:J80)","v":0},{"$f":"SUM(K76:K80)","v":0},{"$f":"SUM(L76:L80)","v":0}]
["RESERVES"]
["Operating Reserve",null,null,null,null,null,null,null,{"$f":"SUM(B83:H83)","v":0},{"$f":"K83+L83","v":0}]
["Replacement Reserve",null,null,null,null,null,null,null,0,0]
["Transition Reserve",null,null,null,null,null,null,null,0,0]
["Rent Reserve",null,null,null,null,null,null,null,0,0]
["Other Reserve Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Reserve Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Reserve Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Total Reserve Costs",{"$f":"SUM(B83:B89)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K83:K89)","v":0},{"$f":"SUM(L83:L89)","v":0}]
["CONTINGENCY COSTS"]
["Construction Hard Cost Contingency ",null,null,null,null,null,null,null,{"$f":"SUM(B92:H92)","v":0},{"$f":"K92+L92","v":0}]
["Soft Cost Contingency",null,null,null,null,null,null,null,{"$f":"SUM(B93:H93)","v":0},0]
["Total Contingency Costs",{"$f":"SUM(B92:B93)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K92:K93)","v":0},{"$f":"SUM(L92:L93)","v":0}]
["OTHER PROJECT COSTS"]
["TCAC App/Allocation/Monitoring Fees",null,null,null,null,null,null,null,{"$f":"SUM(B96:H96)","v":0},{"$f":"K96+L96","v":0}]
["Environmental Audit",null,null,null,null,null,null,null,0,0]
["Local Development Impact Fees",null,null,null,null,null,null,null,0,0]
["Permit Processing Fees",null,null,null,null,null,null,null,0,0]
["Capital Fees",null,null,null,null,null,null,null,0,0]
["Marketing",null,null,null,null,null,null,null,0,0]
["Furnishings",null,null,null,null,null,null,null,0,0]
["Market Study",null,null,null,null,null,null,null,0,0]
["Accounting/Reimbursable",null,null,null,null,null,null,null,0,0]
["Appraisal Costs",null,null,null,null,null,null,null,0,0]
["Other Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Other Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Total Other Costs",{"$f":"SUM(B96:B111)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K96:K111)","v":0},{"$f":"SUM(L96:L111)","v":0}]
["SUBTOTAL PROJECT COST",{"$f":"SUM(B75+B81+B90+B94+B112)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K75+K81+K90+K94+K112)","v":0},{"$f":"SUM(L75+L81+L90+L94+L112)","v":0}]
["DEVELOPER COSTS"]
["Developer Overhead/Profit",null,null,null,null,null,null,null,{"$f":"SUM(B115:H115)","v":0},{"$f":"K115+L115","v":0}]
["Consultant/Processing Agent",null,null,null,null,null,null,null,0,0]
["Project Administration",null,null,null,null,null,null,null,0,0]
["Broker Fees Paid  to a Related Party",null,null,null,null,null,null,null,0,0]
["Construction Oversight by Developer",null,null,null,null,null,null,null,0,0]
["Other Developer Costs: (Specify)",null,null,null,null,null,null,null,0,0]
["Total Developer Costs",{"$f":"SUM(B115:B120)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K115:K120)","v":0},{"$f":"SUM(L115:L120)","v":0}]
["TOTAL PROJECT COST",{"$f":"SUM(B113+B121)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K113+K121)","v":0},{"$f":"SUM(L113+L121)","v":0}]

{"sheet":"Operating Budget","index":10,"n_rows":124,"n_cols":7,"rows_kept":124,"cut":false,"hidden":false,"merged":[[120,0,120,1],[121,0,121,1],[122,0,122,1],[111,0,111,1],[117,0,117,1],[115,0,115,1],[112,0,112,1],[113,0,113,1],[114,0,114,1],[116,0,116,4],[118,0,118,1],[119,0,119,1],[110,0,110,1],[103,0,103,1],[104,0,104,4],[107,0,107,1],[108,0,108,1],[109,0,109,1],[105,0,105,1],[106,0,106,1],[98,0,98,1],[99,0,99,1],[100,0,100,1],[101,0,101,1],[102,0,102,1],[81,0,81,1],[82,0,82,1],[97,0,97,1],[84,0,84,1],[85,0,85,1],[87,0,87,1],[88,0,88,1],[89,0,89,1],[90,0,90,1],[91,0,91,1],[83,0,83,1],[92,0,92,1],[93,0,93,1],[94,0,94,1],[95,0,95,1],[96,0,96,1],[86,0,86,1],[76,0,76,1],[77,0,77,1],[78,0,78,1],[79,0,79,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[65,0,65,1],[67,0,67,1],[68,0,68,1],[70,0,70,1],[71,0,71,1],[72,0,72,1],[74,0,74,1],[75,0,75,1],[69,0,69,1],[73,0,73,1],[66,0,66,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[41,0,41,1],[40,0,40,1],[50,0,50,1],[47,0,47,1],[60,0,60,1],[61,0,61,1],[0,0,0,4],[1,0,1,4],[21,0,21,4],[22,0,22,1],[14,4,19,4],[18,0,18,1],[19,0,19,1],[31,0,31,1],[34,0,34,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[27,0,27,4],[28,0,28,1],[29,0,29,1],[30,0,30,1],[26,0,26,1],[32,0,32,1],[33,0,33,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[56,0,56,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[48,0,48,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[39,0,39,1]]}
["Annual Income and Expenses"]
["EMPLOYEE INFORMATION"]
["No.","FTE","Employee Job Title","Salary/Wages","Value of Free Rent"]
[null,null,"On-Site Manager(s)",0,0]
[null,null,"On-Site Assistant Manager(s)",0,0]
[null,null,"Supportive Services Staff Supervisor(s)",0]
[null,null,"Supportive Services Coordinator, On-Site",0]
[null,null,"Other Supportive Services Staff (inc. Case Manager)",0]
[null,null,"On-Site Maintenance Employee(s)",0,0]
[null,null,"On-Site Leasing Agent/Administrative Employee(s)",0,0]
[null,null,"On-Site Security Employee(s)",0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,"Total Salaries and Value of Free Rent Units",{"$f":"SUM(D4:D13)","v":0},{"$f":"SUM(E4:E13)","v":0}]
[null,6711,"Payroll Taxes",0]
[null,6722,"Workers Compensation",0,null,null,"Count free rent as an "]
[null,6723,"Employee Benefits",0,null,null,"expense?"]
[null,null,"Employee(s) Payroll Taxes, Workers Comp. & Benefits",{"$f":"SUM(D15:D17)","v":0},null,null,2]
[null,null,"Total Employee(s) Expenses",{"$f":"D18+D14","v":0}]
[]
[]
["Employee Units"]
["Income Limit",null,"Job Title(s) of Employee(s) Living On-Site","Unit Type\n(No. of bdrms.)","Square Footage","Income Limit","Job Title(s) of Employee(s) Living On-Site"]
[null,null,null,0,0,0.6,"On-Site Manager(s)"]
[null,null,null,0,0,0.55000000000000004,"On-Site Assistant Manager(s)"]
[null,null,null,0,0,0.5,"On-Site Maintenance Employee(s)"]
[null,null,null,"Total Square Footage",{"$f":"SUM(E24:E26)","v":0},"None","On-Site Leasing Agent/Administrative Employee(s)"]
["Annual Operating Budget",null,null,null,null,"Other","On-Site Security Employee(s)"]
[" Acct. No.",null,"REVENUE - INCOME","Residential ","Commercial ",null,"Services Coordinator"]
["5120/5140",null,"Rent Revenue - Gross Potential",null,0]
[null,null,"Space/Lot Rents & HOA fees (Residence Analysis tab)",{"$f":"'Residence Analysis'!AG2","v":0}]
[5121,null,"Tenant Assistance Payments"]
[null,null,"Other: (specify)",0]
[null,null,"Other: (specify)",0]
[null,null,"Operating Subsidies",0]
[null,null,"Other: (specify)",0,0]
[5910,null,"Laundry and Vending Revenue",0]
[5170,null,"Garage and Parking Spaces",0,0]
[5990,null,"Miscellaneous Rent Revenue ",0,0]
[null,null,"Gross Potential Income (GPI)",{"$f":"SUM(D30:D39)","v":0},{"$f":"SUM(E30:E39)","v":0}]
[]
[null,null,"Vacancy Rate:  Space/Lot Rents and HOA fees",0.05]
[null,null,"Vacancy Rate:  Tenant Assistance Payments",0.05]
[null,null,{"$f":"\"Vacancy Rate:  \" & C36","v":"Vacancy Rate:  Other: (specify)"},0.05]
[null,null,"Vacancy Rate:  Laundry & Vending & Other Income  ",0.05]
[null,null,"Vacancy Rate:  Commercial Income ",null,0.5]
["5220/5240",null,"Vacancy Loss(es)",{"$f":"(D31*D42)+((D33+D34)*D43)+(D36*D44)+((D37+D38+D39)*D45)","v":0},{"$f":"+E40*E46","v":0}]
[null,null,"Effective Gross Income (EGI)",{"$f":"+D40-D47","v":0},{"$f":"+E40-E47","v":0}]
[" Acct. No.",null,"EXPENSES","Residential ","Commercial "]
[]
[null,null,"ADMINISTRATIVE EXPENSES: 6200/6300"]
[6203,null,"Conventions and Meetings",0,0]
[6210,null,"Advertising and Marketing",0,0]
[6250,null,"Other Renting Expenses",0,0]
[6310,null,"Office/Administrative Salaries -- from above",{"$f":"+D10","v":0},0]
[6311,null,"Office Expenses",0,0]
[6312,null,"Office or Model Apartment Rent",0,0]
[6320,null,"Management Fee",0,0]
[6330,null,"Site/Resident Manager(s) Salaries -- from above",{"$f":"+D4+D5","v":0},0]
[6331,null,"Administrative Free Rent Unit  -- from above",{"$f":"IF(G18=1,+E4+E5+E10,0)","v":0},0]
[6340,null,"Legal Expense -- Project",0,0]
[6350,null,"Audit Expense",0,0]
[6351,null,"Bookkeeping Fees/Accounting Services",0,0]
[6390,null,"Miscellaneous Administrative Expenses",0,0]
["6263T",null,"  TOTAL ADMINISTRATIVE EXPENSES",{"$f":"SUM(D52:D64)","v":0},{"$f":"SUM(E52:E64)","v":0}]
[" Acct. No.",null,"EXPENSES (continued) ","Residential ","Commercial "]
[null,null,"UTILITIES EXPENSES: 6400"]
[6450,null,"Electricity",0,0]
[6451,null,"Water",0,0]
[6452,null,"Gas",0,0]
[6453,null,"Sewer",0,0]
[null,null,"Other Utilities: (specify)",0,0]
["6400T",null,"  TOTAL UTILITIES EXPENSES",{"$f":"SUM(D68:D72)","v":0},{"$f":"SUM(E68:E72)","v":0}]
[null,null,"OPERATING AND MAINTENANCE EXPENSES: 6500"]
[6510,null,"Payroll -- from above",{"$f":"D9+D11+D12+D13","v":0},0]
[6515,null,"Supplies ",0,0]
[6520,null,"Contracts",0,0]
[6521,null,"Operating & Maintenance Free Rent Unit -- from above",{"$f":"IF(G18=1,+E9+E12+E13,0)","v":0},0]
[6525,null,"Garbage and Trash Removal",0,0]
[6530,null,"Security Contract",0,0]
[6531,null,"Security Free Rent Unit -- from above",{"$f":"IF(G18=1,+E11,0)","v":0},0]
[6546,null,"Heating/Cooling Repairs and Maintenance",0,0]
[6548,null,"Snow Removal",0,0]
[6570,null,"Vehicle & Maintenance Equipment Operation/Reports",0,0]
[6590,null,"Miscellaneous Operating and Maintenance Expenses",0,0]
["6500T",null,"TOTAL OPERATING & MAINTENANCE EXPENSES",{"$f":"SUM(D75:D85)","v":0},{"$f":"SUM(E75:E85)","v":0}]
[null,null,"TAXES AND INSURANCE: 6700"]
[6710,null,"Real Estate Taxes",0,0]
[6711,null,"Payroll Taxes (Project's Share) -- from above",{"$f":"D15","v":0},0]
[6720,null,"Property and Liability Insurance (Hazard)",0,0]
[6729,null,"Other Insurance (e.g. Earthquake)",0,0]
[6721,null,"Fidelity Bond Insurance",0,0]
[6722,null,"Worker's Compensation -- from above",{"$f":"D16","v":0},0]
[6723,null,"Health Insurance/Other Employee Benefits--from above",{"$f":"D17","v":0},0]
[6790,null,"Miscellaneous Taxes, Licenses, Permits & Insurance",0,0]
["6700T",null,"  TOTAL TAXES AND INSURANCE",{"$f":"SUM(D88:D95)","v":0},{"$f":"SUM(E88:E95)","v":0}]
[null,null,"SUPPORTIVE SERVICES COSTS: 6900"]
[6990,null,"Staff Supervisor(s) Salaries - from above",{"$f":"D6","v":0},0]
[6990,null,"Services Coordinator Salaries, On-Site - from above",{"$f":"D7","v":0},0]
[6990,null,"Other Supportive Services Staff Salaries - from above",{"$f":"D8","v":0},0]
[6990,null,"Supportive Services Admin Overhead",0,0]
[6990,null,"Other Supportive Services Costs: (specify)",0,0]
[6990,null,"Other Supportive Services Costs: (specify)",0,0]
["6900T",null,"  TOTAL SUPPORTIVE SERVICES COSTS",{"$f":"SUM(D98:D103)","v":0},{"$f":"SUM(E98:E103)","v":0}]
[]
[null,null,"TOTAL OPERATING EXPENSES",{"$f":"+D65+D73+D86+D96+D104","v":0},{"$f":"+E65+E73+E86+E96+E104","v":0}]
[null,null,"FUNDED RESERVES: 7200","Residential","Commercial"]
[7210,null,"Required Replacement Reserve Deposits",0,0]
[7220,null,"Other Reserves: (specify)",0,0]
[7230,null,"Other Reserves: (specify)",0,0]
[7240,null,"Other Reserves: (specify)",0,0]
[null,null,"TOTAL RESERVES",{"$f":"SUM(D108:D111)","v":0},{"$f":"SUM(E108:E111)","v":0}]
[null,null,"GROUND LEASE","Residential","Commercial"]
[null,null,"Ground Lease",0,0]
[null,null,"TOTAL GROUND LEASE",{"$f":"SUM(D114:D114)","v":0},{"$f":"SUM(E114:E114)","v":0}]
[null,null,"NET OPERATING INCOME",{"$f":"+D48-D106-D112-D115","v":0},{"$f":"+E48-E106-E112-E115","v":0}]
[]
[null,null,"FINANCIAL EXPENSES: 6800"]
[6820,null,"1st Mortgage Debt Service",0,0]
[6830,null,"2nd Mortgage Debt Service ",0,0]
[6840,null,"3rd Mortgage Debt Service",0,0]
[6890,null,"MPRROP .42% Monitoring Fees",0,0]
["6800T",null,"TOTAL FINANCIAL EXPENSES",{"$f":"SUM(D119:D122)","v":0},{"$f":"SUM(E119:E122)","v":0}]
[null,null," CASH FLOW",{"$f":"+D116-D123","v":0},{"$f":"+E116-E123","v":0}]

{"sheet":"Cash Flow","index":11,"n_rows":41,"n_cols":23,"rows_kept":41,"cut":false,"hidden":false,"merged":[[9,0,9,1],[23,0,23,3],[0,0,0,22],[2,0,2,1],[3,0,3,1],[7,0,7,1],[4,0,4,1],[5,0,5,1],[1,0,1,1],[33,0,33,2],[40,0,40,2],[10,0,10,1],[11,0,11,1],[12,0,12,1],[24,0,24,1],[15,0,15,1],[16,0,16,1]]}
["Cash Flow Analysis"]
["INCOME FROM HOUSING UNITS",null,"Inflation","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20"]
["Lot/Space Rent & HOA Fees",null,2.5000000000000001E-2,{"$f":"'Operating Budget'!D31","v":0},{"$f":"D3*(1+$C$3)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q3*(1+$C$3)","v":0},0,0,0,0,0]
["Tenant Assistance Payments"]
[{"$f":"IF('Operating Budget'!C33=\"\",\"\",'Operating Budget'!C33)","v":"Other: (specify)"},null,2.5000000000000001E-2,{"$f":"'Operating Budget'!D33","v":0},{"$f":"D5*(1+$C$5)","v":0},{"$f":"E5*(1+$C$5)","v":0},{"$f":"F5*(1+$C$5)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q5*(1+$C$5)","v":0},0,0,0,0,0]
[{"$f":"IF('Operating Budget'!C34=\"\",\"\",'Operating Budget'!C34)","v":"Other: (specify)"},null,2.5000000000000001E-2,{"$f":"'Operating Budget'!D34","v":0},{"$f":"D6*(1+$C$6)","v":0},{"$f":"E6*(1+$C$6)","v":0},{"$f":"F6*(1+$C$6)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q6*(1+$C$6)","v":0},0,0,0,0,0]
["Operating Subsidies",null,0.02,{"$f":"'Operating Budget'!D35","v":0},{"$f":"D7*(1+$C$7)","v":0},{"$f":"E7*(1+$C$7)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q7*(1+$C$7)","v":0},0,0,0,0,0]
["Other: (specify)",null,{"$f":"C5","v":2.5000000000000001E-2},{"$f":"'Operating Budget'!D36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["GROSS POTENTIAL INCOME - HOUSING",null,null,{"$f":"SUM(D3:D8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OTHER INCOME"]
["Laundry & Vending",null,2.5000000000000001E-2,{"$f":"'Operating Budget'!D37","v":0},{"$f":"D11*(1+$C$11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q11*(1+$C$11)","v":0},0,0,0,0,0]
["Other Income    ",null,2.5000000000000001E-2,{"$f":"'Operating Budget'!D38+'Operating Budget'!D39","v":0},{"$f":"D12*(1+$C$12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q12*(1+$C$12)","v":0},0,0,0,0,0]
["Commercial Income",null,2.5000000000000001E-2,{"$f":"'Operating Budget'!E40","v":0},{"$f":"D13*(1+$C$13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q13*(1+$C$13)","v":0},0,0,0,0,0]
["GROSS POTENTIAL INCOME - OTHER",null,null,{"$f":"SUM(D11:D13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["GROSS POTENTIAL INCOME - TOTAL",null,null,{"$f":"D9+D14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["VACANCY ASSUMPTIONS "]
["Lot/Space Rent & HOA Fees",null,{"$f":"'Operating Budget'!D42","v":0.05},{"$f":"+$C17*D3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tenant Assistance Payments",null,{"$f":"'Operating Budget'!D43","v":0.05},{"$f":"+$C18*(D5+D6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other: (specify)",null,{"$f":"'Operating Budget'!D44","v":0.05},{"$f":"+$C19*D8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Laundry/Vending/Other Income ",null,{"$f":"'Operating Budget'!D45","v":0.05},{"$f":"+$C20*(D11+D12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Commercial Income ",null,{"$f":"'Operating Budget'!E46","v":0.5},{"$f":"+$C21*D13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL VACANCY LOSS",null,null,{"$f":"SUM(D17:D21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["EFFECTIVE GROSS INCOME ",null,null,{"$f":"D15-D22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OPERATING EXPENSES & RESERVE DEPOSITS"]
["Residential Exp. (w/o Real Estate Taxes & Sup. Services)",null,3.5000000000000003E-2,{"$f":"'Operating Budget'!D106-'Operating Budget'!D88-'Operating Budget'!D104","v":0},{"$f":"(1+$C$25)*D25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(1+$C$25)*Q25","v":0},0,0,0,0,0]
["Real Estate Taxes",null,0.02,{"$f":"'Operating Budget'!D88","v":0},{"$f":"(1+$C$26)*D26","v":0},{"$f":"(1+$C$26)*E26","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"(1+$C$26)*Q26","v":0},0,0,0,0,0]
["Supportive Services Costs",null,2.5000000000000001E-2,{"$f":"'Operating Budget'!D104","v":0},{"$f":"(1+$C$27)*D27","v":0},{"$f":"(1+$C$27)*E27","v":0},{"$f":"(1+$C$27)*F27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Replacement Reserve",null,0,{"$f":"'Operating Budget'!D108","v":0},{"$f":"(1+$C$28)*D28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(1+$C$28)*Q28","v":0},0,0,0,0,0]
["Other Reserves",null,0,{"$f":"'Operating Budget'!D109+'Operating Budget'!D110+'Operating Budget'!D111","v":0},{"$f":"(1+$C$29)*D29","v":0},{"$f":"(1+$C$29)*E29","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"(1+$C$29)*Q29","v":0},0,0,0,0,0]
["Ground Lease",null,0.02,{"$f":"'Operating Budget'!D114","v":0},{"$f":"(1+$C$30)*D30","v":0},{"$f":"(1+$C$30)*E30","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"(1+$C$30)*Q30","v":0},0,0,0,0,0]
["Commercial Expenses",null,3.5000000000000003E-2,{"$f":"'Operating Budget'!E106+'Operating Budget'!E112+'Operating Budget'!E115","v":0},{"$f":"(1+$C$31)*D31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(1+$C$31)*Q31","v":0},0,0,0,0,0]
["TOTAL EXPENSES & RESERVES",null,null,{"$f":"SUM(D25:D31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["NET OPERATING INCOME ",null,null,{"$f":"D23-D32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["DEBT SERVICE"]
[{"$f":"'Operating Budget'!C119","v":"1st Mortgage Debt Service"},null,null,{"$f":"'Operating Budget'!D119+'Operating Budget'!E119","v":0},{"$f":"$D$35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bridge Loan (repaid from Investor equity)",null,null,0,0,0,0,0]
[{"$f":"'Operating Budget'!C120","v":"2nd Mortgage Debt Service "},null,null,{"$f":"'Operating Budget'!D120+'Operating Budget'!E120","v":0},{"$f":"$D$37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'Operating Budget'!C121","v":"3rd Mortgage Debt Service"},null,null,{"$f":"'Operating Budget'!D121+'Operating Budget'!E121","v":0},{"$f":"$D$38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'Operating Budget'!C122","v":"MPRROP .42% Monitoring Fees"},null,null,{"$f":"+'Operating Budget'!D122+'Operating Budget'!E122","v":0},{"$f":"$D$39","v":0},{"$f":"$D$39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R39","v":0},{"$f":"S39","v":0},{"$f":"T39","v":0},{"$f":"U39","v":0},{"$f":"V39","v":0}]
["Total Required Debt Service",null,null,{"$f":"SUM(D35,D37,D38,D39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CASH FLOW after all debt service",null,null,{"$f":"D33-D40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Application Support","index":12,"n_rows":31,"n_cols":40,"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],[27,32,27,34],[27,35,27,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],[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],[28,35,28,37],[26,0,26,1],[26,2,26,4],[26,5,26,8],[26,9,26,14],[26,15,26,16],[26,17,26,28],[26,29,26,31],[26,32,26,34],[26,35,26,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],[23,32,23,34],[23,35,23,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],[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],[24,35,24,37],[22,0,22,1],[22,2,22,4],[22,5,22,8],[22,9,22,14],[22,15,22,16],[22,17,22,28],[22,29,22,31],[22,32,22,34],[22,35,22,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],[19,32,19,34],[19,35,19,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],[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],[20,35,20,37],[18,0,18,1],[18,2,18,4],[18,5,18,8],[18,9,18,14],[18,15,18,16],[18,17,18,28],[18,29,18,31],[18,32,18,34],[18,35,18,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],[15,32,15,34],[15,35,15,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],[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],[16,35,16,37],[14,0,14,1],[14,2,14,4],[14,5,14,8],[14,9,14,14],[14,15,14,16],[14,17,14,28],[14,29,14,31],[14,32,14,34],[14,35,14,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],[11,32,11,34],[11,35,11,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],[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],[12,35,12,37],[10,0,10,1],[10,2,10,4],[10,5,10,8],[10,9,10,14],[10,15,10,16],[10,17,10,28],[10,29,10,31],[10,32,10,34],[10,35,10,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],[7,32,7,34],[7,35,7,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],[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],[8,35,8,37],[6,0,6,1],[6,2,6,4],[6,5,6,8],[6,9,6,14],[6,15,6,16],[6,17,6,28],[6,29,6,31],[6,32,6,34],[6,35,6,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":"'MPRROP Coverpage'!A25","v":"Rev. 6/12/20"}]
["Please complete the \"yellow\" cells in the form below and email a copy to: AppSupport@hcd.ca.gov. A member of the Application Development Team will respond to your request within ASAP. "]
["Full Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Requested:",null,null,null,null,null,null,null,"Application Version Date:",null,null,null,null,null,null,null,null,"MPRROP Coverpage"]
["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:",null,null,null,null,null,null,null,null,null,null,"Applicant & Project Info"]
["Justification:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Development Team-Contacts"]
["Issue #",null,"Program Name",null,null,"Tab",null,null,null,"Section",null,null,null,null,null,"Cell#",null,"Update/Comment",null,null,null,null,null,null,null,null,null,null,null,"Urgency ",null,null,"ADT Status",null,null,"Status Date",null,null,null,"Residence Analysis"]
[1,null,"MPPROP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Threshold & Standard Conditions"]
[2,null,"MPPROP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Certification & Legal"]
[3,null,"MPPROP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dev Sources"]
[4,null,"MPPROP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dev Budget"]
[5,null,"MPPROP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Budget"]
[6,null,"MPPROP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Flow"]
[7,null,"MPPROP"]
[8,null,"MPPROP"]
[9,null,"MPPROP"]
[10,null,"MPPROP"]
[11,null,"MPPROP"]
[12,null,"MPPROP"]
[13,null,"MPPROP"]
[14,null,"MPPROP"]
[15,null,"MPPROP"]
[16,null,"MPPROP"]
[17,null,"MPPROP"]
[18,null,"MPPROP"]
[19,null,"MPPROP"]
[20,null,"MPPROP"]
[21,null,"MPPROP"]
[22,null,"MPPROP"]
[23,null,"MPPROP"]
[24,null,"MPPROP"]
[25,null,"MPPROP"]