{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["IIG Cover","Overview","Narrative ","Elig, Units & Max Funds","Eligible Costs & Threshold","Dev Sources","Dev Budget","Scoring","Env & Land Use Verification","Sample Reso","Dropdowns"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":257,"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":"IIG Cover","index":0,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[[14,0,14,10],[6,2,9,9],[10,5,10,6],[11,0,11,10],[12,5,12,6],[13,0,13,10],[28,0,28,10],[15,0,15,10],[16,0,16,10],[18,0,18,10],[19,5,19,6],[20,0,20,10],[21,0,21,10],[23,0,23,10],[24,0,24,10],[25,5,25,6],[26,0,26,10],[27,0,27,10],[35,0,35,10],[29,0,29,10],[30,0,30,10],[31,5,31,6],[32,0,32,10],[33,0,33,10],[34,0,34,10]]}
[]
[]
[]
[]
[]
[]
[null,null,"DEPARTMENT OF HOUSING AND COMMUNITY DEVELOPMENT"]
[]
[]
[]
[]
["Lisa Bates, Deputy Director"]
[]
["INFILL INFRASTRUCTURE GRANT PROGRAM"]
["QUALIFYING INFILL PROJECT"]
["FY 2017-18 NOFA - GRANT APPLICATION"]
[]
["Rev 10/11/17"]
["Sabrina Sassman, Chief"]
[]
["Program Manager"]
["John Nunn"]
[]
["Specialist"]
["George Rodine"]
[]
["State of California"]
["Department of Housing and Community Development"]
["Division of Financial Assistance"]
["2020 W. El Camino Avenue"]
["Sacramento, CA 95833-1829"]
[]
["Telephone: (916) 263-2771"]
["Facsimile: (916) 263-2764"]
["Email: infill@hcd.ca.gov"]
["Website: http://www.hcd.ca.gov/grants-funding/nofas.shtml"]

{"sheet":"Overview","index":1,"n_rows":67,"n_cols":37,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,3,1,28],[1,29,1,31],[1,32,1,37],[0,0,0,35],[0,36,0,37],[54,0,54,37],[55,0,55,37],[56,0,56,17],[38,0,38,3],[38,4,38,10],[38,11,38,27],[38,28,38,31],[38,33,38,36],[28,0,28,17],[28,18,28,28],[30,0,30,37],[33,0,33,2],[36,20,36,22],[36,23,36,29],[36,30,36,32],[36,33,36,37],[40,36,40,37],[41,0,41,3],[41,4,41,10],[41,11,41,31],[51,36,51,37],[46,34,46,37],[45,0,45,1],[45,2,45,20],[23,0,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,12],[23,13,23,14],[28,29,28,37],[33,3,33,21],[33,22,33,25],[33,26,33,37],[23,15,23,17],[23,18,23,19],[29,18,29,28],[29,29,29,37],[29,0,29,17],[26,29,26,37],[27,0,27,17],[27,18,27,28],[27,29,27,37],[25,0,25,17],[25,18,25,28],[25,29,25,37],[26,0,26,17],[26,18,26,28],[22,5,22,6],[22,7,22,8],[22,9,22,12],[18,29,23,37],[20,25,20,28],[21,0,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,12],[21,13,21,14],[21,15,21,17],[21,18,21,19],[17,25,18,28],[18,0,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,12],[18,13,18,14],[20,0,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,12],[20,13,20,14],[20,15,20,17],[64,0,64,37],[65,0,65,37],[50,36,50,37],[51,11,51,31],[47,33,47,37],[49,0,49,3],[49,4,49,10],[52,11,52,31],[52,32,52,35],[52,36,52,37],[53,4,53,10],[53,11,53,31],[53,32,53,35],[48,0,48,1],[48,2,48,20],[48,22,48,27],[48,28,48,29],[48,30,48,32],[48,34,48,37],[49,11,49,27],[44,22,44,25],[44,26,44,37],[43,0,43,37],[49,28,49,31],[47,20,47,22],[47,23,47,29],[47,30,47,32],[34,30,34,32],[40,11,40,31],[40,0,40,3],[42,4,42,10],[45,22,45,27],[45,28,45,29],[45,30,45,32],[37,2,37,20],[37,22,37,27],[37,28,37,29],[37,30,37,32],[35,0,35,2],[46,19,46,23],[46,24,46,30],[46,31,46,33],[35,19,35,23],[35,24,35,30],[66,0,66,24],[2,0,2,37],[58,0,58,32],[59,0,59,37],[60,0,60,37],[61,0,61,37],[62,0,62,37],[57,0,57,37],[63,0,63,37],[52,0,52,3],[52,4,52,10],[50,0,50,3],[50,11,50,31],[50,32,50,35],[19,0,19,4],[53,0,53,3],[53,36,53,37],[49,33,49,36],[47,0,47,2],[20,18,20,19],[20,20,20,22],[20,23,20,24],[51,0,51,3],[51,4,51,10],[51,32,51,35],[46,0,46,2],[46,3,46,11],[46,13,46,18],[47,3,47,11],[47,13,47,19],[50,4,50,10],[40,32,40,35],[35,34,35,37],[45,34,45,37],[41,32,41,35],[41,36,41,37],[42,32,42,35],[42,36,42,37],[42,0,42,3],[42,11,42,31],[39,0,39,3],[39,4,39,10],[39,11,39,31],[39,32,39,35],[39,36,39,37],[40,4,40,10],[44,0,44,2],[44,3,44,21],[34,34,34,37],[37,34,37,37],[37,0,37,1],[35,3,35,11],[35,13,35,18],[36,0,36,2],[36,3,36,11],[36,13,36,19],[34,0,34,1],[34,2,34,20],[34,22,34,27],[34,28,34,29],[35,31,35,33],[3,32,3,34],[3,35,3,37],[4,0,11,0],[4,1,11,6],[4,7,11,16],[4,17,11,22],[4,23,11,25],[4,26,11,28],[4,29,11,31],[9,32,9,34],[9,35,9,37],[10,32,10,34],[10,35,10,37],[11,32,11,34],[11,35,11,37],[3,1,3,6],[3,7,3,16],[3,17,3,22],[3,23,3,25],[3,26,3,28],[3,29,3,31],[4,32,4,34],[4,35,4,37],[5,32,5,34],[19,25,19,28],[19,5,19,6],[19,7,19,8],[19,9,19,12],[19,13,19,14],[17,0,17,4],[17,5,17,8],[17,9,17,14],[17,15,18,19],[17,20,18,24],[19,15,19,17],[19,18,19,19],[19,20,19,22],[19,23,19,24],[8,35,8,37],[17,33,17,37],[12,0,16,0],[12,1,16,6],[12,7,16,16],[12,17,16,22],[12,23,16,25],[12,26,16,28],[12,29,16,31],[12,32,12,34],[12,35,12,37],[13,32,13,34],[13,35,13,37],[14,32,14,34],[14,35,14,37],[15,32,15,34],[15,35,15,37],[16,32,16,34],[31,0,31,35],[31,36,31,37],[16,35,16,37],[17,29,17,32],[66,25,66,37],[1,0,1,2],[21,20,21,22],[21,23,21,24],[21,25,23,28],[22,0,22,4],[32,0,32,37],[24,0,24,6],[24,8,24,9],[24,11,24,25],[22,13,22,14],[22,15,22,17],[22,18,22,19],[22,20,23,24],[5,35,5,37],[6,32,6,34],[6,35,6,37],[7,32,7,34],[7,35,7,37],[8,32,8,34]]}
["Overview - Project and Applicant Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'IIG Cover'!A18","v":"Rev 10/11/17"}]
["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,"AHSC PIN"]
["Capital Improvement Project (CIP) and Qualifying Infill Project (QIP) Information"]
[null,"Project Name",null,null,null,null,null,"Brief Description",null,null,null,null,null,null,null,null,null,"Address",null,null,null,null,null,"City",null,null,"Zip",null,null,"County",null,null,"Census Tracts",null,null,"APNs"]
["QIP"]
[]
[]
[]
[]
[]
[]
[]
["CIP"]
[]
[]
[]
[]
["QIP Information:",null,null,null,null,"Area Calculations:",null,null,null,"Unit Count:",null,null,null,null,null,"Building Count:",null,null,null,null,"Elevator Count:",null,null,null,null,"Project Design:",null,null,null,"Geographic Region:"]
["Land Area",null,null,null,null,"acres",null,null,null,"Units/Acre",null,null,null,{"$f":"IF(H19=0,0,'Elig, Units & Max Funds'!J50/H19)","v":0}]
["Residential Rental",null,null,null,null,"sq. ft.",null,null,null,"# of Units",null,null,null,{"$f":"'Elig, Units & Max Funds'!L50","v":0},null,"# of Buildings",null,null,null,null,"# of Elevators"]
["Homeownership",null,null,null,null,"sq. ft.",null,null,null,"# of Units",null,null,null,{"$f":"'Elig, Units & Max Funds'!O50","v":0},null,"# of Buildings",null,null,null,null,"# of Elevators"]
["Commercial",null,null,null,null,"sq. ft.",null,null,null,"# of Units/Spaces",null,null,null,null,null,"# of Buildings",null,null,null,null,"# of Elevators"]
["Residential Non-Rental",null,null,null,null,"sq. ft.",null,null,null,"# of Units/Spaces",null,null,null,null,null,"# of Buildings"]
["Other (Mixed Use)",null,null,null,null,"sq. ft.",null,null,null,"# of Units/Spaces",null,null,null,null,null,"# of Buildings"]
["Is the QIP a scattered site project?",null,null,null,null,null,null,null,null,null,null,"If yes, complete the section below"]
["Site Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Developer",null,null,null,null,null,null,null,null,null,null,"Homeownership or Rental"]
[]
[]
[]
[]
["Eligible Applicant §307(c)"]
["(a) Applicants certify the proposed CIP or portion thereof, has not previously received an award of Program funds under a previous NOFA."]
["Applicant #1"]
["Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant Type"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Auth Rep Name",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Authorized Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact Name",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"Contact Email",null,null,null,null,null,null,null,null,null,"Contact Phone"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["File Name:",null,null,null,"IIG App1 Cert & Legal Disclosure",null,null,null,null,null,null,"Certifications & Legal Disclosure (See Certifications & Legal Disclosure section below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hardcopy Included?",null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"IIG App1 Reso",null,null,null,null,null,null,"Resolutions (see Resolution section below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"IIG App1 OrgDoc1, IIG App1 OrgDoc2, IIG App1 OrgDoc3, etc.",null,null,null,null,null,null,"Organizational Documents (see Organizational Documents section below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Files Uploaded?"]
["File Name:",null,null,null,"IIG App1 Signature Block",null,null,null,null,null,null,"Signature Block (Upload in Microsoft Word Document)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"IIG App1 Payee Data",null,null,null,null,null,null,"STD-204 Payee Data Record (See Payee Data Record section below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["Applicant #2"]
["Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant Type"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Auth Rep Name",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Authorized Rep. Email",null,null,null,null,null,null,null,null,null,null,null,"Phone"]
["Contact Name",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,"Contact Email",null,null,null,null,null,null,null,null,null,"Contact Phone"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["File Name:",null,null,null,"IIG App2 Cert & Legal Disclosure",null,null,null,null,null,null,"Certifications & Legal Disclosure (See Certifications & Legal Disclosure section below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hardcopy Included?",null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"IIG App2 Reso",null,null,null,null,null,null,"Resolutions (see Resolution section below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"IIG App2 OrgDoc1, IIG App2 OrgDoc2, IIG App2 OrgDoc3, etc.",null,null,null,null,null,null,"Organizational Documents (see Organizational Documents section below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Files Uploaded?"]
["File Name:",null,null,null,"IIG App2 Signature Block",null,null,null,null,null,null,"Signature Block (Upload in Microsoft Word Document)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"IIG App2 Payee Data",null,null,null,null,null,null,"STD-204 Payee Data Record (See Payee Data Record section below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["Certifications & Legal Disclosure"]
["A completed and signed Certification is required for each Joint Applicant. Each Joint Applicant must sign an individual Certification form. A completed and signed Legal Disclosure is also required for each Joint Applicant. In addition, a wet signature original of each signed Certification & Legal Disclosure must be submitted to HCD. The hard copy Certifications & Legal Disclosure should be submitted with the application as detailed in the NOFA."]
["A copy of the required Certification & Legal Disclosure can be downloaded by clicking here."]
["Resolution"]
["A resolution is required of each Joint Applicant - both private and public entities.  Click here for Sample Resolution. "]
["The resolution template is intended to be a sample. Applicants may use their own format as long as it contains ALL of the authorizations contained in the template.\n▪ The person attesting to the signing of the resolution cannot be the same person authorized to execute the documents in the name of the applicant.\n▪ If more than one authorized signatory is identified in the resolution, specifically state whether both signatories are required (i.e. x and y) or only one signatory (i.e. x or y) is required to submit and execute the IIG Program documents.\n▪ If the application is being signed by a designee of the authorized signatory, the applicant must also submit a designee letter or other proof of signing authority."]
["Organizational Documents"]
["Org Docs are required for all Applicants, except where a joint applicant is a governmental entity. Governmental entities are not required to submit organizational documents with the application.   "]
["Submit Organizational Documents supporting the Resolution."]
["Signature Block"]
["All Applicants must submit a Signature Block in a Microsoft Word Document that will be used in Department legal documents such as a Standard Agreement."]
["Payee Data Record"]
["All Applicants must submit a Payee Data Record (STD-204), the document can be downloaded by clicking here."]

{"sheet":"Narrative ","index":2,"n_rows":16,"n_cols":37,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,35],[0,36,0,37],[14,0,14,37],[1,0,1,37],[2,0,2,37],[16,0,16,37],[3,0,3,37],[5,0,5,37],[7,0,7,37],[9,0,9,37],[11,0,11,37],[13,0,13,37],[15,0,15,37],[10,0,10,37],[12,0,12,37],[4,0,4,37],[6,0,6,37],[8,0,8,37]]}
[{"$f":"CONCATENATE(Overview!D2,\" Project Narrative\")","v":" Project Narrative"},null,null,null,null,null,null,null,null,null,null,null,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":"'IIG Cover'!A18","v":"Rev 10/11/17"}]
["1. Summarize the scope of work for the CIP. Specify the total number of distinct infrastructure improvements relating to Utilities, Surface Improvements, Landscape and Amenities, Environmental Mitigation and Remediation, Replacement Transit, Residential Parking and/or Transit:"]
[]
["2. Describe all on-site services that will be provided at the QIP:"]
[]
["3. List any rental or homeownership subsidies and amounts for the qualifying QIP:"]
[]
["4. If construction of QIP is multi-phased, describe proposed phased build out and number of housing units in each phase:"]
[]
["5. Explain any specific development issues (relocation, environmental, historical, topography, etc.):"]
[]
["6. Explain any required demolition:"]
[]
["7. Identify the developer(s) for the QIP. Describe developer(s) experience with affordable housing:"]
[]
["8. Has the QIP previously received a Funding Award from the IIG program or any other HCD program?  If yes, describe the funding sources. Indicate the HCD Contract Number, award date and award amount. Indicate whether other HCD funding applications will be submitted for the Project."]

{"sheet":"Elig, Units & Max Funds","index":3,"n_rows":72,"n_cols":40,"rows_kept":72,"cut":false,"hidden":false,"merged":[[19,24,19,37],[0,0,0,35],[0,36,0,37],[66,35,66,37],[67,32,67,33],[68,32,68,33],[69,32,69,33],[67,28,67,31],[68,28,68,31],[69,28,69,31],[67,23,67,27],[68,23,68,27],[69,23,69,27],[66,12,66,13],[66,14,66,15],[66,16,66,17],[66,18,66,19],[66,20,66,22],[66,23,66,25],[66,26,66,28],[66,29,66,31],[66,32,66,34],[67,0,67,15],[68,0,68,15],[69,0,69,15],[70,23,70,27],[71,23,71,27],[67,34,67,37],[71,34,71,37],[68,34,68,37],[69,34,69,37],[70,34,70,37],[70,32,70,33],[71,32,71,33],[70,28,70,31],[71,28,71,31],[70,0,70,15],[71,0,71,15],[67,16,67,22],[68,16,68,22],[69,16,69,22],[70,16,70,22],[71,16,71,22],[66,10,66,11],[65,8,65,9],[64,8,64,9],[63,8,63,9],[62,8,62,9],[60,8,60,9],[64,6,64,7],[65,6,65,7],[59,1,59,5],[61,1,61,5],[62,1,62,5],[63,1,63,5],[66,6,66,7],[66,8,66,9],[59,6,59,7],[60,6,60,7],[61,6,61,7],[62,6,62,7],[63,6,63,7],[64,1,64,5],[66,1,66,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[60,1,60,5],[52,6,53,7],[61,8,61,9],[57,6,57,7],[58,6,58,7],[46,31,46,33],[43,31,43,33],[40,31,40,33],[37,31,37,33],[35,31,35,33],[30,5,30,8],[31,5,31,8],[27,31,28,33],[15,35,16,37],[15,32,16,34],[24,11,24,31],[25,0,25,36],[22,0,22,3],[22,4,22,10],[22,11,22,31],[22,32,22,35],[16,21,16,22],[17,23,17,33],[17,34,17,36],[15,13,15,22],[17,9,17,12],[18,0,18,3],[18,4,18,10],[18,11,18,31],[54,0,58,0],[54,6,54,7],[55,6,55,7],[56,10,56,11],[56,12,56,13],[62,10,62,11],[62,12,62,13],[62,14,62,15],[56,14,56,15],[57,12,57,13],[57,14,57,15],[60,10,60,11],[60,12,60,13],[60,14,60,15],[59,0,65,0],[65,1,65,5],[56,6,56,7],[63,10,63,11],[63,12,63,13],[63,14,63,15],[65,10,65,11],[65,12,65,13],[65,14,65,15],[63,16,63,17],[55,12,55,13],[55,14,55,15],[3,0,3,3],[3,4,3,10],[3,11,3,31],[3,32,3,35],[3,36,3,37],[5,0,5,3],[53,10,53,11],[24,32,24,35],[24,36,24,37],[17,14,17,20],[10,0,10,20],[14,0,14,8],[11,23,11,29],[12,23,12,29],[13,23,13,29],[14,23,14,29],[13,30,13,31],[14,30,14,31],[16,9,16,12],[15,23,15,29],[16,23,16,29],[16,0,16,8],[15,30,15,31],[16,13,16,20],[11,30,11,31],[14,9,14,12],[15,0,15,8],[15,9,15,12],[13,0,13,8],[13,9,13,12],[11,13,14,22],[12,30,12,31],[4,0,4,7],[6,0,6,36],[7,0,7,22],[5,4,5,10],[5,11,5,31],[5,32,5,35],[7,23,7,24],[7,25,7,26],[7,27,7,29],[7,30,7,31],[7,32,7,34],[1,0,1,37],[4,8,4,37],[22,36,22,37],[21,0,21,13],[21,14,21,37],[8,0,8,37],[9,0,9,29],[9,31,9,34],[9,35,9,37],[20,0,20,3],[20,4,20,10],[20,11,20,31],[20,32,20,35],[20,36,20,37],[11,0,11,8],[11,9,11,12],[11,35,11,37],[12,0,12,12],[5,36,5,37],[2,36,2,37],[7,35,7,36],[2,0,2,35],[10,23,10,36],[16,30,16,31],[24,0,24,3],[24,4,24,10],[18,36,18,37],[17,0,17,8],[18,32,18,35],[17,21,17,22],[51,34,51,37],[51,0,51,5],[51,6,51,8],[51,9,51,16],[51,17,51,18],[51,29,51,33],[51,19,51,25],[51,26,51,27],[49,31,49,33],[49,34,49,35],[49,36,49,37],[50,0,50,37],[49,5,49,8],[49,0,49,1],[49,2,49,4],[49,9,49,10],[49,29,49,30],[49,11,49,13],[49,14,49,16],[49,17,49,19],[49,20,49,22],[47,0,47,1],[47,2,47,4],[47,9,47,10],[47,29,47,30],[48,23,48,25],[48,26,48,28],[49,23,49,25],[49,26,49,28],[47,5,47,8],[48,5,48,8],[46,34,46,35],[46,36,46,37],[47,31,47,33],[47,34,47,35],[47,36,47,37],[48,0,48,1],[48,2,48,4],[48,9,48,10],[48,29,48,30],[48,11,48,13],[48,14,48,16],[47,11,47,13],[47,14,47,16],[47,17,47,19],[47,20,47,22],[47,23,47,25],[47,26,47,28],[48,36,48,37],[48,17,48,19],[48,20,48,22],[48,31,48,33],[48,34,48,35],[46,5,46,8],[46,0,46,1],[46,2,46,4],[46,9,46,10],[46,29,46,30],[46,11,46,13],[46,14,46,16],[46,17,46,19],[46,20,46,22],[44,0,44,1],[44,2,44,4],[44,9,44,10],[44,29,44,30],[45,23,45,25],[45,26,45,28],[46,23,46,25],[46,26,46,28],[44,5,44,8],[45,5,45,8],[43,34,43,35],[43,36,43,37],[44,31,44,33],[44,34,44,35],[44,36,44,37],[45,0,45,1],[45,2,45,4],[45,9,45,10],[45,29,45,30],[45,11,45,13],[45,14,45,16],[44,11,44,13],[44,14,44,16],[44,17,44,19],[44,20,44,22],[44,23,44,25],[44,26,44,28],[45,36,45,37],[45,17,45,19],[45,20,45,22],[45,31,45,33],[45,34,45,35],[43,5,43,8],[43,0,43,1],[43,2,43,4],[43,9,43,10],[43,29,43,30],[43,11,43,13],[43,14,43,16],[43,17,43,19],[43,20,43,22],[41,0,41,1],[41,2,41,4],[41,9,41,10],[41,29,41,30],[42,23,42,25],[42,26,42,28],[43,23,43,25],[43,26,43,28],[41,5,41,8],[42,5,42,8],[40,34,40,35],[40,36,40,37],[41,31,41,33],[41,34,41,35],[41,36,41,37],[42,0,42,1],[42,2,42,4],[42,9,42,10],[42,29,42,30],[42,11,42,13],[42,14,42,16],[41,11,41,13],[41,14,41,16],[41,17,41,19],[41,20,41,22],[41,23,41,25],[41,26,41,28],[42,36,42,37],[42,17,42,19],[42,20,42,22],[42,31,42,33],[42,34,42,35],[40,5,40,8],[40,0,40,1],[40,2,40,4],[40,9,40,10],[40,29,40,30],[40,11,40,13],[40,14,40,16],[40,17,40,19],[40,20,40,22],[38,0,38,1],[38,2,38,4],[38,9,38,10],[38,29,38,30],[39,23,39,25],[39,26,39,28],[40,23,40,25],[40,26,40,28],[38,5,38,8],[39,5,39,8],[37,34,37,35],[37,36,37,37],[38,31,38,33],[38,34,38,35],[38,36,38,37],[39,0,39,1],[39,2,39,4],[39,9,39,10],[39,29,39,30],[39,11,39,13],[39,14,39,16],[38,11,38,13],[38,14,38,16],[38,17,38,19],[38,20,38,22],[38,23,38,25],[38,26,38,28],[39,36,39,37],[39,17,39,19],[39,20,39,22],[39,31,39,33],[39,34,39,35],[37,5,37,8],[37,0,37,1],[37,2,37,4],[37,9,37,10],[37,29,37,30],[37,11,37,13],[37,14,37,16],[37,17,37,19],[37,20,37,22],[35,0,35,1],[35,2,35,4],[35,9,35,10],[35,29,35,30],[36,23,36,25],[36,26,36,28],[37,23,37,25],[37,26,37,28],[35,5,35,8],[36,5,36,8],[35,34,35,35],[35,36,35,37],[36,0,36,1],[36,2,36,4],[36,9,36,10],[36,29,36,30],[36,11,36,13],[36,14,36,16],[35,11,35,13],[35,14,35,16],[35,17,35,19],[35,20,35,22],[35,23,35,25],[35,26,35,28],[36,36,36,37],[36,17,36,19],[36,20,36,22],[36,31,36,33],[36,34,36,35],[33,36,33,37],[33,17,33,19],[33,20,33,22],[34,0,34,1],[34,2,34,4],[34,9,34,10],[34,29,34,30],[34,11,34,13],[34,14,34,16],[34,17,34,19],[34,20,34,22],[33,23,33,25],[33,26,33,28],[33,31,33,33],[33,34,33,35],[34,23,34,25],[34,26,34,28],[34,31,34,33],[34,34,34,35],[34,36,34,37],[33,5,33,8],[34,5,34,8],[33,0,33,1],[33,2,33,4],[32,34,32,35],[33,9,33,10],[33,29,33,30],[33,11,33,13],[33,14,33,16],[32,11,32,13],[32,14,32,16],[32,17,32,19],[32,20,32,22],[32,23,32,25],[32,26,32,28],[31,0,31,1],[31,2,31,4],[31,9,31,10],[31,29,31,30],[31,11,31,13],[31,14,31,16],[31,17,31,19],[30,11,30,13],[30,14,30,16],[27,34,28,35],[27,36,28,37],[30,36,30,37],[30,31,30,33],[30,34,30,35],[31,20,31,22],[30,17,30,19],[30,20,30,22],[30,23,30,25],[30,26,30,28],[31,23,31,25],[31,26,31,28],[31,36,31,37],[31,31,31,33],[31,34,31,35],[30,29,30,30],[32,36,32,37],[29,0,29,1],[29,2,29,4],[29,9,29,10],[29,29,29,30],[29,31,29,33],[29,34,29,35],[29,36,29,37],[29,17,29,19],[29,20,29,22],[29,23,29,25],[29,26,29,28],[29,5,29,8],[29,11,29,13],[29,14,29,16],[32,0,32,1],[32,2,32,4],[32,9,32,10],[32,29,32,30],[32,5,32,8],[30,0,30,1],[30,2,30,4],[30,9,30,10],[32,31,32,33],[27,0,28,1],[27,2,28,4],[27,9,28,10],[27,29,28,30],[27,11,28,13],[27,14,28,16],[27,17,28,19],[27,20,28,22],[27,5,28,8],[27,23,28,25],[27,26,28,28],[56,18,56,19],[57,18,57,19],[58,8,58,9],[58,10,58,11],[58,12,58,13],[58,14,58,15],[58,16,58,17],[58,18,58,19],[59,10,59,11],[59,12,59,13],[59,14,59,15],[56,8,56,9],[53,14,53,15],[54,10,54,11],[54,12,54,13],[54,14,54,15],[54,16,54,17],[57,16,57,17],[59,16,59,17],[60,16,60,17],[55,16,55,17],[53,16,53,17],[64,20,64,22],[65,20,65,22],[53,23,53,25],[54,23,54,25],[55,23,55,25],[56,23,56,25],[57,23,57,25],[58,23,58,25],[54,32,54,34],[59,23,59,25],[60,23,60,25],[61,23,61,25],[62,23,62,25],[64,23,64,25],[65,23,65,25],[65,26,65,28],[53,29,53,31],[54,29,54,31],[55,29,55,31],[56,29,56,31],[57,29,57,31],[58,29,58,31],[59,29,59,31],[60,29,60,31],[65,16,65,17],[65,18,65,19],[52,8,52,19],[64,10,64,11],[64,12,64,13],[64,14,64,15],[64,16,64,17],[64,18,64,19],[61,10,61,11],[61,12,61,13],[61,14,61,15],[60,18,60,19],[59,8,59,9],[61,16,61,17],[53,8,53,9],[54,8,54,9],[55,8,55,9],[55,10,55,11],[57,8,57,9],[57,10,57,11],[53,12,53,13],[59,18,59,19],[62,16,62,17],[56,16,56,17],[59,32,59,34],[60,32,60,34],[61,32,61,34],[62,32,62,34],[61,29,61,31],[62,29,62,31],[64,29,64,31],[65,29,65,31],[55,26,55,28],[56,26,56,28],[57,26,57,28],[58,26,58,28],[59,26,59,28],[60,26,60,28],[61,26,61,28],[62,26,62,28],[64,26,64,28],[53,18,53,19],[54,18,54,19],[55,18,55,19],[62,18,62,19],[53,26,53,28],[54,26,54,28],[65,32,65,34],[53,35,53,37],[54,35,54,37],[55,35,55,37],[56,35,56,37],[57,35,57,37],[58,35,58,37],[59,35,59,37],[60,35,60,37],[61,35,61,37],[62,35,62,37],[64,35,64,37],[65,35,65,37],[63,35,63,37],[55,32,55,34],[56,32,56,34],[57,32,57,34],[58,32,58,34],[52,20,52,37],[23,0,23,9],[23,10,23,11],[23,12,23,36],[64,32,64,34],[53,32,53,34],[26,0,26,37],[63,18,63,19],[63,20,63,22],[63,23,63,25],[63,26,63,28],[63,29,63,31],[63,32,63,34],[53,20,53,22],[54,20,54,22],[55,20,55,22],[56,20,56,22],[57,20,57,22],[58,20,58,22],[59,20,59,22],[60,20,60,22],[61,20,61,22],[62,20,62,22],[61,18,61,19]]}
[{"$f":"CONCATENATE(Overview!D2,\" Project Eligibility, QIP Units and Max Funds\")","v":" Project Eligibility, QIP Units and Max Funds"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'IIG Cover'!A18","v":"Rev 10/11/17"}]
["Eligible Projects §303(a):"]
["Is the CIP an integral part of, or necessary for the development of a QIP?"]
["File Name:",null,null,null,"IIG CIP Integral to QIP",null,null,null,null,null,null,"Label and attach applicant narrative and documentation evidencing the locality requiring the CIP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(1) Is QIP in an Urbanized Area?"]
["File Name:",null,null,null,"IIG Urban Area",null,null,null,null,null,null,"Provide documentation QIP is located in an urban area ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(2) Is QIP located in a locality that has an adopted housing element in substantial compliance with Art. 10.6 (commencing with §65580) Ch. 3 Div. 1 of Title 7 pursuant to Gov. Code §65585?"]
["(3) Does QIP include not less than 15% of total residential units as Affordable Units (AU) to be developed in the QIP. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Units",null,{"$f":"J50","v":0},null,"Total Rental AU",null,null,{"$f":"X50","v":0},null,"Total Owner AU",null,null,{"$f":"AA50","v":0},null,{"$f":"IF(Z8=0,\"No\",IF((AE8+AJ8)/Z8<0.15,\"No\",\"Yes\"))","v":"No"}]
["(4) Average Residential Net Density (dwelling units per acre)"]
["Is parcel to be developed within a Rural Area per H&S Code §50199.21? (Refer to the document entitled IIG Program, Rural Area Determination Procedures)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If yes, skip to (5)",null,null,null,{"$f":"IF(AE10=\"Yes\",10,0)","v":0}]
["If non-rural, enter minimum net density for parcel to be developed per locality (see Appendix A, click here):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,"Is the QIP density equal to or greater than required §303(a)(4)?"]
["Total Site Area in Square Feet",null,null,null,null,null,null,null,null,{"$f":"Overview!H19*43560","v":0},null,null,null,"*NOTE:  NOT qualified site deductions: utility easements, setbacks, private drives and walkways, landscaping, common areas and facilities, off street parking, drainage facilities exclusive to a development project and other related mitigation space required for development.",null,null,null,null,null,null,null,null,null,"0 Bedroom Density Calculation:",null,null,null,null,null,null,{"$f":"(SUMIF($A$30:$B$49,\"0\",$J$30:$K$49)*0.7)","v":0}]
["(Less Qualified Site Deductions* in square feet):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 Bedroom Density Calculation:",null,null,null,null,null,null,{"$f":"+(SUMIF($A$30:$B$49,\"1\",$J$30:$K$49)*0.9)","v":0}]
["Public Streets ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 Bedroom Density Calculation:",null,null,null,null,null,null,{"$f":"+(SUMIF($A$30:$B$49,\"2\",$J$30:$K$49)*1.2)","v":0}]
["Public Sidewalks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 Bedroom Density Calculation:",null,null,null,null,null,null,{"$f":"+(SUMIF($A$30:$B$49,\"3\",$J$30:$K$49)*1.6)","v":0}]
["Public Open Space",null,null,null,null,null,null,null,null,null,null,null,null,"If QIP contains commercial answer V17 & 18 below:",null,null,null,null,null,null,null,null,null,"4 Bedroom Density Calculation:",null,null,null,null,null,null,{"$f":"+(SUMIF($A$30:$B$49,\"4\",$J$30:$K$49)*1.8)","v":0},null,"Commercial Square Feet.",null,null,{"$f":"Overview!H22","v":0}]
["Public Drainage Facilities",null,null,null,null,null,null,null,null,null,null,null,null,"Enter sq. feet of largest residential unit:",null,null,null,null,null,null,null,null,null,"Commercial Density Calculation:",null,null,null,null,null,null,{"$f":"IF(V17=0,0,IF(AJ16<=0,0,ROUNDDOWN((AJ16/V17),0)*N18))","v":0}]
["Net Site Area in Acres (43,540 sq ft per acre)",null,null,null,null,null,null,null,null,{"$f":"(J12-J14-J15-J16-J17)/43560","v":0},null,null,null,{"$f":"IF(V18=0,0.7,IF(V18=1,0.9,IF(V18=2,1.2,IF(V18=3,1.6,IF(V18=4,1.8)))))","v":0.7},"Enter # of Bedrooms in largest unit:",null,null,null,null,null,null,null,null,"Percentage QIP meets or exceeds required net density:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J18=0,0,SUM(AE12:AF17)/MAX(V11,AJ10)/J18)","v":0},null,null,{"$f":"IF(AI18>=1,\"Yes\",\"No\")","v":"No"}]
["File Name:",null,null,null,"IIG Net Density Verification",null,null,null,null,null,null,"Provide a date stamped map and letter certified by a California State-licensed professional such as an engineer, surveyor or landscape architect confirming the Net Density.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(5) Is QIP located in area designated for mixed-use or residential development pursuant to one of the following adopted plans?"]
["File Name:",null,null,null,"IIG Relevant Development Plan",null,null,null,null,null,null,"Provide, label and attach a copy of the relevant plan showing area designation of the QIP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(6) Does the QIP have one of the following in the dropdown list?"]
["File Name:",null,null,null,"IIG Site Plan",null,null,null,null,null,null,"Label and attach a site plan showing compliance with §303(a)(6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(7) Is QIP located in a redevelopment project area?",null,null,null,null,null,null,null,null,null,null,null,"If Yes, does QIP meet the replacement housing requirements contained in Subdivision (a) of §33413 of the Health & Safety Code?"]
["File Name:",null,null,null,"IIG Redevelopment Plan",null,null,null,null,null,null,"Label and attach a copy of redevelopment plan and replacement criteria relevant to QIP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(c) Is QIP a discrete development (all housing development components have been planned as one development and jointly considered for local land use approval; have common, affiliated or contractually-related ownership and financing structures)?"]
["QIP Unit Mix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
["# of\nBedrooms",null,"Unit Type",null,null,"% of\nArea\nMedian\nIncome ",null,null,null,"Total Units",null,"Total Rental Units",null,null,"Total Homeowner Units",null,null,"Total Restricted Units",null,null,"Total Unrestricted Units",null,null,"Total Restricted Affordable Rental Units",null,null,"Total Restricted Affordable HO Units",null,null,"Manager Units",null,"Special Needs or Supportive Housing Units",null,null,"Veterans Units",null,"Senior Units"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C30=\"Rental\",J30,\"\")","v":""},null,null,{"$f":"IF(C30=\"Home Owner\",J30,\"\")","v":""},null,null,{"$f":"IF(OR(F30=\"\",F30=\"none\"),\"\",J30)","v":""},null,null,{"$f":"IF(OR(F30=\"\",F30=\"none\"),J30,\"\")","v":0},null,null,{"$f":"IF(OR(C30=\"Home Owner\",J30=0),\"\",IF(OR(F30=\"none\",F30=\"\",F30=\"HO Lower\"),\"\",J30))","v":""},null,null,{"$f":"IF(OR(C30=\"Rental\",J30=0),\"\",IF(OR(F30=\"none\",F30=\"\"),\"\",IF(F30=\"HO Lower\",J30,\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,0,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J30:J49)","v":0},null,{"$f":"SUM(L30:L49)","v":0},null,null,{"$f":"SUM(O30:O49)","v":0},null,null,{"$f":"SUM(R30:T49)","v":0},null,null,{"$f":"SUM(U30:W49)","v":0},null,null,{"$f":"SUM(X30:Z49)","v":0},null,null,{"$f":"SUM(AA30:AC49)","v":0},null,null,{"$f":"SUM(AD30:AD49)","v":0},null,{"$f":"SUM(AF30:AF49)","v":0},null,null,{"$f":"SUM(AI30:AI49)","v":0},null,{"$f":"SUM(AK30:AK49)","v":0}]
["Maximum CIP Grant Amount §305(a) and NOFA; Affordability Point Score §309(b)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
["Total Base Grant Limit",null,null,null,null,null,{"$f":"AJ59+AJ66","v":0},null,null,"Housing Units per Acre (Net Density)",null,null,null,null,null,null,null,{"$f":"IF(J18=0,0,IF(V17=0,J50/J18,J50+ROUNDDOWN((AJ16/V17),0))/J18)","v":0},null,"Net Density Adjustment Factor",null,null,null,null,null,null,{"$f":"INDEX(AM51:AM64,MATCH(R52,AN51:AN64,1))","v":1},null,{"$f":"IF('Dev Sources'!J27=\"\",0,'Dev Sources'!J27)","v":0},"Max CIP Grant Amount",null,null,null,null,{"$f":"MIN(IF('Dev Budget'!C206=\"\",0,'Dev Budget'!C206),(G52*AA52))","v":0},null,null,null,1.04,30]
[null,null,null,null,null,null,"Points\n§309(b)(3)",null,"Number of Units",null,null,null,null,null,null,null,null,null,null,null,"Basic Grant Limit x Units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.08,35]
[null,"Income Level",null,null,null,null,null,null,"0-Bdrm",null,"1-Bdrm",null,"2-Bdrm",null,"3-Bdrm",null,"4-Bdrm",null,"Total",null,"0-Bdrm",null,null,"1-Bdrm",null,null,"2-Bdrm",null,null,"3-Bdrm",null,null,"4-Bdrm",null,null,"Total",null,null,1.1200000000000001,40]
["Owner Occupied","200%+FMR or > CalHFA",null,null,null,null,null,null,{"$f":"SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"200%+ FMR\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"> CalHFA Sales Price\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"200%+ FMR\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"> CalHFA Sales Price\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"200%+ FMR\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"> CalHFA Sales Price\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"200%+ FMR\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"> CalHFA Sales Price\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"200%+ FMR\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"> CalHFA Sales Price\")*($J$30:$J$49))","v":0},null,{"$f":"SUM(I55:R55)","v":0},null,{"$f":"I55*3000","v":0},null,null,{"$f":"K55*6000","v":0},null,null,{"$f":"M55*9000","v":0},null,null,{"$f":"O55*12000","v":0},null,null,{"$f":"Q55*15000","v":0},null,null,{"$f":"SUM(U55:AI55)","v":0},null,null,1.1599999999999999,45]
[null,"Unrestricted",null,null,null,null,null,null,{"$f":"SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"none\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"none\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"none\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"none\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"none\")*($J$30:$J$49))","v":0},null,{"$f":"SUM(I56:R56)","v":0},null,{"$f":"I56*20000","v":0},null,null,{"$f":"K56*23000","v":0},null,null,{"$f":"M56*27000","v":0},null,null,{"$f":"O56*33000","v":0},null,null,{"$f":"Q56*36000","v":0},null,null,{"$f":"SUM(U56:AI56)","v":0},null,null,1.2,50]
[null,"<= Moderate Income",null,null,null,null,{"$f":"IF(J50=0,0,(S57/$J$50)*100*0.3)","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"HO Moderate\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"HO Moderate\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"HO Moderate\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"HO Moderate\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"HO Moderate\")*($J$30:$J$49))","v":0},null,0,null,{"$f":"I57*23000","v":0},null,null,{"$f":"K57*26000","v":0},null,null,{"$f":"M57*31000","v":0},null,null,{"$f":"O57*37000","v":0},null,null,{"$f":"Q57*40000","v":0},null,null,0,null,null,1.24,55]
[null,"<= Lower Income",null,null,null,null,{"$f":"IF(J50=0,0,(S58/$J$50)*100*0.8)","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"HO Lower\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"HO Lower\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"HO Lower\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"HO Lower\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Home Owner\")*($F$30:$F$49=\"HO Lower\")*($J$30:$J$49))","v":0},null,0,null,{"$f":"I58*26000","v":0},null,null,{"$f":"K58*29000","v":0},null,null,{"$f":"M58*35000","v":0},null,null,{"$f":"O58*41000","v":0},null,null,{"$f":"Q58*45000","v":0},null,null,0,null,null,1.28,60]
[null,"Total Owner",null,null,null,null,{"$f":"SUM(G55:H58)","v":0},null,{"$f":"SUM(I55:J58)","v":0},null,{"$f":"SUM(K55:L58)","v":0},null,{"$f":"SUM(M55:N58)","v":0},null,{"$f":"SUM(O55:P58)","v":0},null,{"$f":"SUM(Q55:R58)","v":0},null,0,null,{"$f":"SUM(U55:W58)","v":0},null,null,{"$f":"SUM(X55:Z58)","v":0},null,null,{"$f":"SUM(AA55:AC58)","v":0},null,null,{"$f":"SUM(AD55:AF58)","v":0},null,null,{"$f":"SUM(AG55:AI58)","v":0},null,null,{"$f":"SUM(AJ55:AL58)","v":0},null,null,1.32,65]
["Rental Unit","200%+FMR or > CalHFA",null,null,null,null,null,null,{"$f":"SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"200%+ FMR\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"> CalHFA Sales Price\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"200%+ FMR\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"> CalHFA Sales Price\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"200%+ FMR\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"> CalHFA Sales Price\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"200%+ FMR\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"> CalHFA Sales Price\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"200%+ FMR\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"> CalHFA Sales Price\")*($J$30:$J$49))","v":0},null,{"$f":"SUM(I60:R60)","v":0},null,{"$f":"I60*3000","v":0},null,null,{"$f":"K60*6000","v":0},null,null,{"$f":"M60*9000","v":0},null,null,{"$f":"O60*12000","v":0},null,null,{"$f":"Q60*15000","v":0},null,null,{"$f":"SUM(U60:AI60)","v":0},null,null,1.36,70]
[null,"Unrestricted",null,null,null,null,null,null,{"$f":"SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"none\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"none\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"none\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"none\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"none\")*($J$30:$J$49))","v":0},null,0,null,{"$f":"I61*20000","v":0},null,null,{"$f":"K61*23000","v":0},null,null,{"$f":"M61*27000","v":0},null,null,{"$f":"O61*33000","v":0},null,null,{"$f":"Q61*36000","v":0},null,null,{"$f":"SUM(U61:AI61)","v":0},null,null,1.4,75]
[null,"<= 60% AMI to >50% AMI",null,null,null,null,null,null,{"$f":"SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"60% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"55% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"60% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"55% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"60% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"55% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"60% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"55% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"60% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"55% AMI\")*($J$30:$J$49))","v":0},null,0,null,{"$f":"I62*26000","v":0},null,null,{"$f":"K62*29000","v":0},null,null,{"$f":"M62*35000","v":0},null,null,{"$f":"O62*41000","v":0},null,null,{"$f":"Q62*45000","v":0},null,null,0,null,null,1.44,80]
[null,"<= 50% AMI to >40% AMI",null,null,null,null,{"$f":"IF(J50=0,0,(S63/$J$50)*100*0.4)","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"50% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"45% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"50% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"45% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"50% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"45% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"50% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"45% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"50% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"45% AMI\")*($J$30:$J$49))","v":0},null,0,null,{"$f":"I63*30000","v":0},null,null,{"$f":"K63*34000","v":0},null,null,{"$f":"M63*39000","v":0},null,null,{"$f":"O63*47000","v":0},null,null,{"$f":"Q63*50000","v":0},null,null,0,null,null,1.48,90]
[null,"<= 40% AMI to >30% AMI",null,null,null,null,{"$f":"IF(J50=0,0,(S64/$J$50)*100*0.4)","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"40% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"35% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"40% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"35% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"40% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"35% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"40% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"35% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"40% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"35% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUM(I64:R64)","v":0},null,{"$f":"I64*30000","v":0},null,null,{"$f":"K64*34000","v":0},null,null,{"$f":"M64*39000","v":0},null,null,{"$f":"O64*47000","v":0},null,null,{"$f":"Q64*50000","v":0},null,null,{"$f":"SUM(U64:AI64)","v":0},null,null,1.52,100]
[null,"<= 30% AMI",null,null,null,null,{"$f":"IF(J50=0,0,(S65/$J$50)*100*2)","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"30% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"25% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"20% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=0)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"15% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"30% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"25% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"20% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=1)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"15% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"30% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"25% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"20% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=2)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"15% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"30% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"25% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"20% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=3)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"15% AMI\")*($J$30:$J$49))","v":0},null,{"$f":"SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"30% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"25% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"20% AMI\")*($J$30:$J$49))+SUMPRODUCT(($A$30:$A$49=4)*($C$30:$C$49=\"Rental\")*($F$30:$F$49=\"15% AMI\")*($J$30:$J$49))","v":0},null,0,null,{"$f":"I65*35000","v":0},null,null,{"$f":"K65*37000","v":0},null,null,{"$f":"M65*42000","v":0},null,null,{"$f":"O65*54000","v":0},null,null,{"$f":"Q65*57000","v":0},null,null,0]
[null,"Total Rental",null,null,null,null,{"$f":"SUM(G60:H65)","v":0},null,{"$f":"SUM(I60:J65)","v":0},null,{"$f":"SUM(K60:L65)","v":0},null,{"$f":"SUM(M60:N65)","v":0},null,{"$f":"SUM(O60:P65)","v":0},null,{"$f":"SUM(Q60:R65)","v":0},null,0,null,{"$f":"SUM(U60:W65)","v":0},null,null,{"$f":"SUM(X60:Z65)","v":0},null,null,{"$f":"SUM(AA60:AC65)","v":0},null,null,{"$f":"SUM(AD60:AF65)","v":0},null,null,{"$f":"SUM(AG60:AI65)","v":0},null,null,{"$f":"SUM(AJ60:AL65)","v":0}]
[null,"Total Rental & Owner",null,null,null,null,{"$f":"MIN(60,(G59+G66))","v":0},null,{"$f":"I59+I66","v":0},null,{"$f":"K59+K66","v":0},null,{"$f":"M59+M66","v":0},null,{"$f":"O59+O66","v":0},null,{"$f":"Q59+Q66","v":0},null,{"$f":"S59+S66","v":0},null,{"$f":"U59+U66","v":0},null,{"$f":"W59+W66","v":0},{"$f":"X59+X66","v":0},null,{"$f":"Z59+Z66","v":0},{"$f":"AA59+AA66","v":0},null,{"$f":"AC59+AC66","v":0},{"$f":"AD59+AD66","v":0},null,{"$f":"AF59+AF66","v":0},{"$f":"AG59+AG66","v":0},null,{"$f":"AI59+AI66","v":0},{"$f":"AJ59+AJ66","v":0},null,{"$f":"AL59+AL66","v":0}]
["§309(b)(1) Restricted Units Designated for Households with Incomes of:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# of Restricted Units in Category",null,null,null,null,null,null,"% of Restricted Units",null,null,null,null,"Scoring Factor",null,null,null,"Points",null,"Total §309(b)(1) Pts"]
["MHP Level A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$50=0,0,Q69/$R$50)","v":0},null,null,null,null,0.75,null,null,null,{"$f":"X69*AC69*100","v":0}]
["MHP Level B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$50=0,0,Q70/$R$50)","v":0},null,null,null,null,1,null,null,null,{"$f":"X70*AC70*100","v":0}]
["MHP Level C not to exceed 10% of total Restricted Units (Max Points = 15)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$50=0,0,MIN(0.1,Q71/$R$50))","v":0},null,null,null,null,1.5,null,null,null,{"$f":"MIN(X71*AC71*100,15)","v":0}]
["MHP Level C Restricted Units in Excess of 10% of total Restricted Units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$50=0,0,Q72/$R$50)","v":0},null,null,null,null,1,null,null,null,{"$f":"X72*AC72*100","v":0},null,{"$f":"MIN(60,(SUM(AG69:AH72)*(60/35)))","v":0}]

{"sheet":"Eligible Costs & Threshold","index":4,"n_rows":50,"n_cols":38,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,35],[0,36,0,37],[26,23,28,37],[28,17,28,22],[48,32,48,34],[48,35,48,37],[49,32,49,34],[49,35,49,37],[35,0,35,31],[36,0,36,31],[37,0,37,31],[38,0,38,31],[39,0,39,31],[40,0,40,31],[42,0,42,31],[43,0,43,31],[44,0,44,31],[45,0,45,31],[46,0,46,31],[47,0,47,31],[48,0,48,31],[49,0,49,31],[36,35,36,37],[37,35,37,37],[38,35,38,37],[39,35,39,37],[40,35,40,37],[35,32,35,34],[36,32,36,34],[37,32,37,34],[38,32,38,34],[39,32,39,34],[40,32,40,34],[24,0,24,5],[24,6,24,7],[24,12,24,22],[24,8,24,10],[24,36,24,37],[24,34,24,35],[15,36,15,37],[8,0,8,36],[9,0,9,36],[10,0,10,36],[11,0,11,36],[12,0,12,10],[12,11,12,24],[12,25,12,33],[12,34,12,37],[13,0,13,37],[5,0,5,37],[17,0,17,9],[17,10,17,37],[18,0,18,3],[18,4,18,10],[18,11,18,31],[18,32,18,35],[18,36,18,37],[16,0,16,17],[16,19,16,37],[15,4,15,11],[15,12,15,31],[15,32,15,35],[6,0,6,36],[7,0,7,37],[3,0,3,18],[3,20,3,26],[3,28,3,35],[3,36,3,37],[4,0,4,11],[4,13,4,36],[1,0,1,37],[2,0,2,11],[2,13,2,36],[41,0,41,37],[33,0,33,37],[31,0,31,11],[31,12,31,37],[34,0,34,37],[32,0,32,37],[30,0,30,11],[30,12,30,37],[25,8,25,10],[25,12,25,22],[25,23,25,25],[25,26,25,31],[29,0,29,3],[29,4,29,10],[29,11,29,31],[29,32,29,35],[29,36,29,37],[27,0,27,8],[27,9,27,12],[27,13,27,16],[27,17,27,20],[25,32,25,33],[26,0,26,8],[26,9,26,12],[45,32,45,34],[45,35,45,37],[46,32,46,34],[46,35,46,37],[47,32,47,34],[47,35,47,37],[42,32,42,34],[42,35,42,37],[43,32,43,34],[43,35,43,37],[44,32,44,34],[44,35,44,37],[26,21,26,22],[35,35,35,37],[27,21,27,22],[28,0,28,5],[28,13,28,16],[28,6,28,12],[14,0,14,37],[15,0,15,3],[20,0,20,36],[21,0,21,3],[21,4,21,10],[21,11,21,31],[21,32,21,35],[21,36,21,37],[26,13,26,16],[26,17,26,20],[25,34,25,35],[25,36,25,37],[19,0,19,37],[24,23,24,25],[24,26,24,31],[24,32,24,33],[22,0,22,37],[23,0,23,37]]}
[{"$f":"CONCATENATE(Overview!D2,\" Eligible Costs, Threshold and Summary\")","v":" Eligible Costs, Threshold and Summary"},null,null,null,null,null,null,null,null,null,null,null,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":"'IIG Cover'!A18","v":"Rev 10/11/17"}]
["Eligible Costs §304"]
["(a)(4) Total # of replacement of transit station parking spaces:",null,null,null,null,null,null,null,null,null,null,null,null,"Are costs of replacement transit parking spaces less than $40,000 per space?",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(M3=\"\",\"\",IF('Dev Budget'!R173/M3>40000,\"No\",\"Yes\"))","v":""}]
["(a)(5) Minimum residential per unit parking spaces as req. by local land-use entitlement approval:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spaces exceed one space per unit?",null,null,null,null,null,null,{"$f":"IF(T4>'Elig, Units & Max Funds'!J50,\"Yes\",\"No\")","v":"No"},"Are costs less than $40,000 per space?",null,null,null,null,null,null,null,{"$f":"IF(T4=\"\",\"\",IF('Dev Budget'!R180/T4>40000,\"No\",\"Yes\"))","v":""}]
["(b) Impact fees for the CIP are required by local ordinance?",null,null,null,null,null,null,null,null,null,null,null,null,"If yes, impact fees do not to exceed 5% of the total Program grant amount? Describe fee(s), its association to CIP and locality:",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('Dev Budget'!R197=\"\",\"\",IF('Dev Budget'!R197>('Dev Budget'!C206*0.05),\"No\",\"Yes\"))","v":"Yes"}]
[]
["We certify the CIP funded costs do not include any of the following ineligible costs:\n(c) If there is another feasible, available source of funding for the Capital Asset or portion thereof to be funded by the Program;\n(d1) Parking spaces and structures except (a)(4) and (5) above;\n(d2) For buildings with parking structures below housing, costs of site acquisition for housing and mixed use structural improvements. For all other building types, costs of site acquisition, grading and foundations for housing and mixed use structural improvements;\n(d3) Costs of housing or mixed use structures;\n(d4) Any costs not permitted as a Capital Asset cost under Government Code §16727;\n(d5) Soft costs related to ineligible costs;\n(d6) In lieu fees for local inclusionary programs; and\n(d7) Brownfield cleanup activities eligible for funding under the CalReUSE program administered by the California Pollution Control Financing Authority."]
["Application Threshold Requirements - §308(a)"]
["(3) Is application including the Universal Application sufficiently complete to assess feasibility of application and its compliance with Program requirements?"]
["(4) We certify that construction of the CIP has not commenced as of the application deadline set forth in the NOFA."]
["(5) We certify the CIP is infeasible without CIP Program funds, and other available funds are not and will not be supplanted by CIP Program funds."]
["(6) Does applicant or Developer have Site Control for the CIP Project? If yes, enter form of site control and the most recent execution date below (see Site Control §302(v))"]
["Form of site control (see Site Control §302(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,"Most recent document execution date:"]
["Describe any special circumstances:"]
[]
["File Name:",null,null,null,"IIG CIP Site Control",null,null,null,null,null,null,null,"Attach appropriate documentation to demonstrate the form of site control indicated above",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Files Uploaded?"]
["Does the QIP trigger State Relocation Assistance Law (CA Gov Code §7260-7277)?"]
["If Yes, provide a narrative discussion on the number of impacted households and provided relocation assistance including what actions have or will be taken to comply with State Relocation Assistance Law? If No, provide documentation supporting  relocation is not required."]
["File Name:",null,null,null,"IIG QIP Relocation Plan",null,null,null,null,null,null,"Applicants must provide a Relocation Plan or documentation supporting no relocation. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["Market Study"]
["Does Market study demonstrate QIP is financially feasible?   (Must submit a market study that meets the requirements specified in TCAC Regs §10322(h)(10))"]
["File Name:",null,null,null,"IIG Market Study",null,null,null,null,null,null,"Applicants must provide a completed market study prepared within one year of the application due date.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["Tax Credits"]
["Select appropriate entry for each item:"]
["Type (Select One):",null,null,null,null,null,null,null,"Federal:",null,null,null,"Proposed Equity Investor Contribution ($):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Anticipated Tax Credit Factor",null,null,null,null,null,null,null,"App. Rate"]
[null,null,null,null,null,null,null,null,"State:",null,null,null,"Proposed Equity Investor Contribution ($):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Anticipated Tax Credit Factor",null,null,null,null,null,null,null,"App. Rate"]
["Timeframe for Applying for 4%Tax Credits",null,null,null,null,null,null,null,null,"Proposed Month:",null,null,null,null,null,null,null,"Proposed Year:"]
["Timeframe for Applying for 9%Tax Credits",null,null,null,null,null,null,null,null,"Proposed Round:",null,null,null,null,null,null,null,"Proposed Year:"]
["If already awarded:",null,null,null,null,null,"Date Tax Credit Reservation Award:"]
["File Name:",null,null,null,"IIG Tax Credit Reservation",null,null,null,null,null,null,"If this project has already received a tax credit reservation, attach documentation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["What covenants or regulatory agreements are already on title?"]
["What covenants or regulatory agreements are anticipated?"]
["Note:  Some of the following milestones may have already been achieved.  For previously met milestones, please enter the month and year completed. For those milestones not yet completed, please provide a projected completion date (MM/YY) for each of the applicable items below. If not applicable to the specific Capital Project, please indicate \"NA\" below. "]
["Provide the actual or anticipated completion date for the following performance milestones for the CIP.  If a milestone is not applicable, please enter \"N/A\"."]
["QIP MILESTONES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single-Phase Date",null,null,"Multi-Phase Date"]
["Executed binding agreement between the Recipient and developer of the proposed QIP detailing the terms and conditions of the development."]
["Submission of Final Construction Drawings and Specifications to the appropriate local building department or permitting authority."]
["Commencement of construction."]
["Construction complete and the filing of the Notice of Completion."]
["Program funds fully disbursed."]
["CIP MILESTONES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single-Phase Date",null,null,"Multi-Phase Date"]
["Executed binding agreement between the Recipient and developer of the proposed CIP detailing the terms and conditions of the development."]
["Obtaining all necessary and discretionary public land use approvals."]
["Obtaining all enforceable funding commitments for all construction period financing."]
["Submission of Final Construction Drawings and Specifications to the appropriate local building department or permitting authority."]
["Commencement of construction."]
["Construction complete and the filing of the Notice of Completion."]
["Program funds fully disbursed."]

{"sheet":"Dev Sources","index":5,"n_rows":46,"n_cols":20,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,17],[45,0,45,18],[46,0,46,18],[41,10,41,14],[43,3,43,4],[43,6,43,8],[42,3,42,4],[42,6,42,8],[41,5,41,8],[41,0,41,4],[40,5,40,8],[38,3,38,5],[39,3,39,5],[37,3,37,5],[3,2,4,2],[8,3,8,5],[24,19,25,19],[24,15,25,15],[24,16,25,16],[24,18,25,18],[36,3,36,5],[24,3,25,5],[26,3,26,5],[27,3,27,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[31,3,31,5],[24,9,25,9],[24,10,24,11],[24,14,25,14],[24,12,24,13],[20,6,20,8],[21,6,21,8],[19,5,19,8],[21,3,21,4],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[19,17,19,18],[23,0,23,18],[14,17,14,18],[3,15,19,15],[1,0,1,18],[16,17,16,18],[17,17,17,18],[18,5,18,8],[18,17,18,18],[13,17,13,18],[5,17,5,18],[6,17,6,18],[7,17,7,18],[5,3,5,5],[6,3,6,5],[7,3,7,5],[24,6,25,6],[24,8,25,8],[24,17,25,17],[24,7,25,7],[24,2,25,2],[8,17,8,18],[9,17,9,18],[15,17,15,18],[10,17,10,18],[11,17,11,18],[12,17,12,18],[3,16,3,18],[4,17,4,18],[2,0,2,17],[3,0,4,0],[3,1,4,1],[3,6,4,6],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,7,4,7],[3,3,4,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[35,3,35,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[19,0,19,4],[24,0,25,0],[24,1,25,1],[20,3,20,4]]}
[{"$f":"CONCATENATE(Overview!D2,\" QIP and CIP Sources of Development Funds\")","v":" QIP and CIP Sources of Development Funds"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'IIG Cover'!A18","v":"Rev 10/11/17"}]
["See IIG Guidelines §309(a)(3)(B) and (C) for an explanation of funding commitments."]
["Construction Period Sources of Funds"]
[null,"Committed by Application Due Date?","Rental vs Owner","Source Name\n(listed in order of lien priority)",null,null,"Source Type","Local Support §309(a)(4)","Lien\nNo.","Amount","Interest\nRate","Required\nPayment ","Loan Term\n(months)","Residential\nAmount","Commercial\nAmount",null,"*Details of Deferred Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount","Description"]
[1,"Yes",null,"IIG CIP Grant",null,null,"State-HCD","No"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13,null,null,"Deferred Costs (detail at right)",null,null,"Deferred Costs"]
[14,"Yes",null,null,"Equity Investor",null,null,null,null,null," ",null,null,{"$f":"J19","v":0}]
[null,null,null,null,null,"TOTALS",null,null,null,{"$f":"SUM(J6:J19)","v":0}," ",null,null,{"$f":"SUM(N6:N19)","v":0},{"$f":"SUM(O6:O18)","v":0},null,{"$f":"SUM(Q6:Q19)","v":0}," "]
[{"$f":"'Elig, Units & Max Funds'!L50","v":0},"<Rental Units",{"$f":"SUMPRODUCT(($B$6:$B$19=\"Yes\")*($C$6:$C$19=\"Rental\")*($J$6:$J$19))","v":0},"<Total Rental funds committed",null,{"$f":"IF(J20=0,0,C21/($J$20-$J$18))","v":0},"<% Rental funds committed"]
[{"$f":"'Elig, Units & Max Funds'!O50","v":0},"<Owner units",{"$f":"SUMPRODUCT(($B$6:$B$19=\"Yes\")*($C$6:$C$19=\"Owner\")*($J$6:$J$19))","v":0},"<Total Owner funds committed",null,{"$f":"IF(J20=0,0,C22/($J$20-$J$18))","v":0},"<% Owner funds committed"]
[]
["Permanent Sources of Funds"]
[null,"Committed by Application Due Date?","Rental vs Owner","Source Name\n(listed in order of lien priority)",null,null,"Source Type","Local Support §309(a)(4)","Lien\nNo.","Amount","Interest Rate ",null,"Repayment Terms",null,"Amortization\nPeriod (yrs.)","Required\nResidential\nDebt Service","Required\nCommercial\nDebt Service","Residential\nAmount","Commercial\nAmount","Balloon?"]
[null,null,null,null,null,null,null,null,null,null,"Type ","Rate","Type","Due in (yrs)"]
[1,"Yes",null,"IIG CIP Grant",null,null,"State-HCD","No",null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14,null,null,"Deferred Costs",null,null,"Deferred Costs"]
[15,"Yes",null,null,"Equity Investor",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I41","v":0},{"$f":"J41","v":0},{"$f":"COUNTIF(B29:B40,\"Yes\")","v":0}]
[null,null,null,null,null,"TOTALS",null,null,null,{"$f":"SUM(J27:J41)","v":0},"TOTALS",null,null,null,null,{"$f":"SUM(P41:P41)","v":0},{"$f":"SUM(Q41:Q41)","v":0},{"$f":"SUM(R27:R41)","v":0},{"$f":"SUM(S27:S41)","v":0},{"$f":"COUNTIF(B29:B40,\"Yes\")","v":0}]
[{"$f":"'Elig, Units & Max Funds'!L50","v":0},"<Rental Units",{"$f":"SUMPRODUCT(($B$27:$B$41=\"Yes\")*($C$27:$C$41=\"Rental\")*($J$27:$J$41))","v":0},"<Total Rental funds committed",null,{"$f":"IF($J$42=0,0,C43/($J$42-$J$40))","v":0},"<% Rental funds committed"]
[{"$f":"'Elig, Units & Max Funds'!O50","v":0},"<Owner units",{"$f":"SUMPRODUCT(($B$27:$B$41=\"Yes\")*($C$27:$C$41=\"Owner\")*($J$27:$J$41))","v":0},"<Total Owner funds committed",null,{"$f":"IF($J$42=0,0,C44/($J$42-$J$40))","v":0},"<% Owner funds committed"]
[]
["Applicant Comments: Include a description of unusual or extraordinary circumstances that have resulted in higher than expected project costs and provide a justification as to why these costs are reasonable. "]

{"sheet":"Dev Budget","index":6,"n_rows":208,"n_cols":24,"rows_kept":208,"cut":false,"hidden":false,"merged":[[0,1,0,23],[203,0,203,1],[204,0,204,1],[205,0,205,1],[206,0,206,1],[207,0,207,1],[197,0,197,1],[198,0,198,1],[199,0,199,1],[200,0,200,1],[201,0,201,1],[202,0,202,1],[191,0,191,1],[192,0,192,1],[193,0,193,1],[194,0,194,1],[195,0,195,1],[196,0,196,1],[185,0,185,1],[186,0,186,1],[187,0,187,1],[188,0,188,1],[189,0,189,1],[190,0,190,1],[179,0,179,1],[180,0,180,1],[181,0,181,1],[182,0,182,1],[183,0,183,1],[184,0,184,1],[173,0,173,1],[174,0,174,1],[175,0,175,1],[176,0,176,1],[177,0,177,1],[178,0,178,1],[167,0,167,1],[168,0,168,1],[169,0,169,1],[170,0,170,1],[171,0,171,1],[172,0,172,1],[161,0,161,1],[162,0,162,1],[163,0,163,1],[164,0,164,1],[165,0,165,1],[166,0,166,1],[155,0,155,1],[156,0,156,1],[157,0,157,1],[158,0,158,1],[159,0,159,1],[160,0,160,1],[149,0,149,1],[150,0,150,1],[151,0,151,1],[152,0,152,1],[153,0,153,1],[154,0,154,1],[143,0,143,1],[144,0,144,1],[145,0,145,1],[146,0,146,1],[147,0,147,1],[148,0,148,1],[137,0,137,1],[138,0,138,1],[139,0,139,1],[140,0,140,1],[141,0,141,1],[142,0,142,1],[131,0,131,1],[132,0,132,1],[133,0,133,1],[134,0,134,1],[135,0,135,1],[136,0,136,1],[125,0,125,1],[126,0,126,1],[127,0,127,1],[128,0,128,1],[129,0,129,1],[130,0,130,1],[119,0,119,1],[120,0,120,1],[121,0,121,1],[122,0,122,1],[123,0,123,1],[124,0,124,1],[113,0,113,1],[114,0,114,1],[115,0,115,1],[116,0,116,1],[117,0,117,1],[118,0,118,17],[107,0,107,1],[108,0,108,1],[109,0,109,1],[110,0,110,1],[111,0,111,1],[112,0,112,1],[101,0,101,1],[102,0,102,1],[103,0,103,1],[104,0,104,1],[105,0,105,1],[106,0,106,1],[95,0,95,1],[96,0,96,1],[97,0,97,1],[98,0,98,1],[99,0,99,1],[100,0,100,1],[89,0,89,1],[90,0,90,1],[91,0,91,1],[92,0,92,1],[93,0,93,1],[94,0,94,1],[83,0,83,1],[84,0,84,1],[85,0,85,1],[86,0,86,1],[87,0,87,1],[88,0,88,1],[77,0,77,1],[78,0,78,1],[79,0,79,1],[80,0,80,1],[81,0,81,1],[82,0,82,1],[71,0,71,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[65,0,65,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[59,0,59,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[47,0,47,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[35,0,35,1],[23,0,23,1],[24,0,24,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[16,0,16,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[9,0,9,1],[10,0,10,1],[2,16,3,16],[2,17,3,17],[2,10,3,10],[2,11,3,11],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,12,3,12],[2,13,3,13],[5,0,5,21],[6,0,6,1],[7,0,7,1],[8,0,8,1],[1,22,1,23],[2,0,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,14,3,14],[2,15,3,15],[2,9,3,9],[1,2,1,16],[1,17,1,18],[1,19,1,20]]}
[{"$f":"'IIG Cover'!A18","v":"Rev 10/11/17"},{"$f":"CONCATENATE(Overview!D2,\" QIP and CIP Permanent Sources and Uses\")","v":" QIP and CIP Permanent Sources and Uses"}]
[null,null,"QIP Residential and CIP Permanent Sources of Funds",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commercial Sources ",null,null,"Eligible Basis Costs"]
["USES OF FUNDS",null,{"$f":"'Dev Sources'!$D$27","v":"IIG CIP Grant"},{"$f":"'Dev Sources'!$D$28","v":0},{"$f":"'Dev Sources'!$D$29","v":0},{"$f":"'Dev Sources'!$D$30","v":0},{"$f":"'Dev Sources'!$D$31","v":0},{"$f":"'Dev Sources'!$D$32","v":0},{"$f":"'Dev Sources'!$D$33","v":0},{"$f":"'Dev Sources'!$D$34","v":0},{"$f":"'Dev Sources'!$D$35","v":0},{"$f":"'Dev Sources'!$D$36","v":0},{"$f":"'Dev Sources'!$D$37","v":0},{"$f":"'Dev Sources'!$D$38","v":0},{"$f":"'Dev Sources'!$D$39","v":0},{"$f":"'Dev Sources'!$D$40","v":"Deferred Costs"},{"$f":"'Dev Sources'!$E$41","v":"Equity Investor"},"Total\nResidential\nSources/Costs","Total\nCommercial\nSources/Costs","Source Name:","Source Name:","Total\nCosts\n(Residential\n&\nCommercial)",0.7,0.3]
[]
[]
["QUALIFYING INFILL PROJECT (QIP)"]
["Lesser of Land Cost or Value ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C7:Q7)","v":0},{"$f":"T7+U7","v":0},null,null,{"$f":"R7+S7","v":0},"XXXXXXXXXX","XXXXXXXXXX"]
["Demolition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"T8+U8","v":0},null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Legal & Closing Costs ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Verifiable Carrying Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Existing Improvements Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"T11+U11","v":0},null,null,0,"XXXXXXXXXX",{"$f":"R11","v":0}]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX",{"$f":"R12","v":0}]
["Total Acquisition ",null,{"$f":"SUM(C7:C12)","v":0},{"$f":"SUM(D7:D12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R7:R12)","v":0},{"$f":"SUM(S7:S12)","v":0},{"$f":"SUM(T7:T12)","v":0},{"$f":"SUM(U7:U12)","v":0},0,{"$f":"SUM(W7:W12)","v":0},0]
["Off-Site Improvements ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C14:Q14)","v":0},{"$f":"T14+U14","v":0},null,null,0,"XXXXXXXXXX",{"$f":"R14","v":0}]
["Environmental Remediation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C15:Q15)","v":0},0,null,null,0,{"$f":"R15","v":0},0]
["Site Work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C16:Q16)","v":0},0,null,null,0,0,0]
["Structures ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["General Requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Contractor Overhead",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Contractor Profit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["General Liability Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C21:Q21)","v":0},0,null,null,0,0,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Total Rehabilitation Costs",null,{"$f":"SUM(C14:C22)","v":0},{"$f":"SUM(D14:D22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R14:R22)","v":0},0,0,0,0,{"$f":"SUM(W14:W22)","v":0},0]
["Temporary Relocation ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C24:Q24)","v":0},{"$f":"T24+U24","v":0},null,null,0,{"$f":"R24","v":0},{"$f":"R24","v":0}]
["Permanent Relocation ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C25:Q25)","v":0},0,null,null,0,{"$f":"R25","v":0},{"$f":"R25","v":0}]
["Total Relocation ",null,{"$f":"SUM(C24:C25)","v":0},{"$f":"SUM(D24:D25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R24:R25)","v":0},0,0,0,0,{"$f":"SUM(W24:W25)","v":0},0]
["Off-Site Improvements ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C27:Q27)","v":0},{"$f":"T27+U27","v":0},null,null,0,"XXXXXXXXXX",{"$f":"R27","v":0}]
["Environmental Remediation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R28","v":0},0]
["Site Work (hard costs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Urban Greening",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Structures (hard costs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["General Requirements ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Contractor Overhead",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Contractor Profit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["General Liability Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Total New Construction",null,{"$f":"SUM(C27:C36)","v":0},{"$f":"SUM(D27:D36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R27:R36)","v":0},0,0,0,0,{"$f":"SUM(W27:W36)","v":0},0]
["Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C38:Q38)","v":0},{"$f":"T38+U38","v":0},null,null,0,{"$f":"R38","v":0},{"$f":"R38","v":0}]
["Supervision",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C39:Q39)","v":0},0,null,null,0,{"$f":"R39","v":0},{"$f":"R39","v":0}]
["Total Architectural Costs",null,{"$f":"SUM(C38:C39)","v":0},{"$f":"SUM(D38:D39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q38:Q39)","v":0},{"$f":"SUM(R38:R39)","v":0},0,0,0,0,{"$f":"U40+V40","v":0},{"$f":"SUM(X38:X39)","v":0}]
["Engineering ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C41:Q41)","v":0},{"$f":"T41+U41","v":0},null,null,0,{"$f":"R41","v":0},{"$f":"R41","v":0}]
["ALTA Land Survey ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C42:Q42)","v":0},0,null,null,0,{"$f":"R42","v":0},{"$f":"R42","v":0}]
["Total Survey & Engineering",null,{"$f":"SUM(C41:C42)","v":0},{"$f":"SUM(D41:D42)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R41:R42)","v":0},0,0,0,0,{"$f":"U43+V43","v":0},{"$f":"SUM(X41:X42)","v":0}]
["Hard Cost Contingency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C44:Q44)","v":0},{"$f":"T44+U44","v":0},null,null,0,{"$f":"R44","v":0},{"$f":"R44","v":0}]
["Soft Cost Contingency ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C45:Q45)","v":0},0,null,null,0,{"$f":"R45","v":0},{"$f":"R45","v":0}]
["Total Contingency Costs",null,{"$f":"SUM(C44:C45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R44:R45)","v":0},0,0,0,0,{"$f":"SUM(W44:W45)","v":0},0]
["Construction Loan Interest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C47:Q47)","v":0},{"$f":"T47+U47","v":0},null,null,0,{"$f":"R47","v":0},{"$f":"R47","v":0}]
["Origination Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Credit Enhancement & App. Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Owner Paid Bonds/Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Lender Inspection Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C51:Q51)","v":0},0,null,null,0,0,0]
["Taxes During Construction ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Prevailing Wage Monitor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Insurance During Construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Title and Recording Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Construction Mgmt. & Testing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Predevelopment Interest Exp. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Total Construction Expenses",null,{"$f":"SUM(C47:C59)","v":0},{"$f":"SUM(D47:D59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R47:R59)","v":0},0,0,0,0,{"$f":"SUM(W47:W59)","v":0},0]
["Loan Origination Fee(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C61:Q61)","v":0},{"$f":"T61+U61","v":0},null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Credit Enhancement & App. Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Title and Recording",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Property Taxes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Insurance ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Total Permanent Financing",null,{"$f":"SUM(C61:C67)","v":0},{"$f":"SUM(D61:D67)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R61:R67)","v":0},0,0,0,0,{"$f":"SUM(W61:W67)","v":0},0]
["Construction Lender Legal Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C69:Q69)","v":0},{"$f":"T69+U69","v":0},null,null,0,{"$f":"R69","v":0},{"$f":"R69","v":0}]
["Permanent Lender Legal Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R70","v":0},{"$f":"R70","v":0}]
["Sponsor Legal Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,{"$f":"R71+S71","v":0},{"$f":"R71","v":0},{"$f":"R71","v":0}]
["Organizational Legal Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R72","v":0},{"$f":"R72","v":0}]
["Syndication Legal Fees ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R74","v":0},{"$f":"R74","v":0}]
["Total Legal Fees",null,{"$f":"SUM(C69:C74)","v":0},{"$f":"SUM(D69:D74)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R69:R74)","v":0},0,0,0,0,{"$f":"SUM(W69:W74)","v":0},0]
["Operating Reserve",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C76:Q76)","v":0},{"$f":"T76+U76","v":0},null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Replacement Reserve",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Rent-Up Reserve",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Transition Reserve ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Total Capitalized Reserves",null,{"$f":"SUM(C76:C81)","v":0},{"$f":"SUM(D76:D81)","v":0},{"$f":"SUM(E76:E81)","v":0},{"$f":"SUM(F76:F81)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R76:R81)","v":0},{"$f":"SUM(S76:S81)","v":0},{"$f":"SUM(T76:T81)","v":0},{"$f":"SUM(U76:U81)","v":0},0,{"$f":"SUM(W76:W81)","v":0},{"$f":"SUM(X76:X81)","v":0}]
["Appraisal(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C83:Q83)","v":0},{"$f":"T83+U83","v":0},null,null,0,{"$f":"R83","v":0},{"$f":"R83","v":0}]
["Market Study",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Physical Needs Assessment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Environmental Studies ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0]
["Total Reports & Studies",null,{"$f":"SUM(C83:C90)","v":0},{"$f":"SUM(D83:D90)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R83:R90)","v":0},0,0,0,0,{"$f":"SUM(W83:W90)","v":0},0]
["CTCAC App./Alloc./Monitor Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C92:Q92)","v":0},{"$f":"T92+U92","v":0},null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["CDLAC Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C93:Q93)","v":0},0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Local Permit Fees ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R94","v":0},{"$f":"R94","v":0}]
["Local Development Impact Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R95","v":0},{"$f":"R95","v":0}]
["Other Costs of Bond Issuance ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R96","v":0},{"$f":"R96","v":0}]
["Syndicator / Investor Fees & Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C97:Q97)","v":0},0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Furnishings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R98","v":0},{"$f":"R98","v":0}]
["Final Cost Audit Expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R99","v":0},{"$f":"R99","v":0}]
["Marketing ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Financial Consulting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R101","v":0},{"$f":"R101","v":0}]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R102","v":0},{"$f":"R102","v":0}]
["Other:",null,null,null," "," ",null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R103","v":0},{"$f":"R103","v":0}]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R104","v":0},{"$f":"R104","v":0}]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R105","v":0},{"$f":"R105","v":0}]
["Total Other Costs",null,{"$f":"SUM(C92:C105)","v":0},{"$f":"SUM(D92:D105)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R92:R105)","v":0},0,0,0,0,{"$f":"SUM(W92:W105)","v":0},0]
["SUBTOTAL ",null,{"$f":"SUM(C13,C23,C26,C37,C40,C43,C46,C60,C68,C75,C82,C91,C106)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(W13,W23,W26,W37,W40,W43,W46,W60,W68,W75,W82,W91,W106)","v":0},0]
["Developer Fee/Overhead/Profit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C108:Q108)","v":0},{"$f":"T108+U108","v":0},null,null,0,{"$f":"R108","v":0},{"$f":"R108","v":0}]
["Consultant/Processing Agent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R109","v":0},{"$f":"R109","v":0}]
["Project Administration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R110","v":0},{"$f":"R110","v":0}]
["Syndicator Consultant Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Guarantee Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,"XXXXXXXXXX","XXXXXXXXXX"]
["Broker Fees Paid to Related Party",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R113","v":0},{"$f":"R113","v":0}]
["Construction Oversight & Mgmt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R114","v":0},{"$f":"R114","v":0}]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R115","v":0},{"$f":"R115","v":0}]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,{"$f":"R116","v":0},{"$f":"R116","v":0}]
["Total Developer Costs",null,{"$f":"SUM(C108:C116)","v":0},{"$f":"SUM(D108:D116)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R108:R116)","v":0},0,0,0,0,{"$f":"SUM(W108:W116)","v":0},0]
["QIP TOTAL PROJECT COSTS",null,{"$f":"+C107+C117","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+W107+W117","v":0},0]
["CAPITAL IMPROVEMENT PROJECT (CIP)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bridge Loan Expense During Construction",0,0]
["Site acquisition of CIP including easements and right of ways",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C120:Q120)","v":0},null,null,null,"Less Total Ineligible Financing Amounts",0,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C121:Q121)","v":0},null,null,null,"ELIGIBLE BASIS",{"$f":"W118-W119-W120","v":0},{"$f":"X118-X119-X120","v":0}]
["Total Site Acquisition (not parking)",null,{"$f":"SUM(C120:C121)","v":0},{"$f":"SUM(D120:D121)","v":0},{"$f":"SUM(E120:E121)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Clearing and Grubbing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C123:Q123)","v":0}]
["Demolition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Excavation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Grading (not grading for housing & mixed use structural improvements)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Soil Stabilization (Lime, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Erosion/Weed Control",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Dewatering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Site Preparation Costs",null,{"$f":"SUM(C123:C131)","v":0},{"$f":"SUM(D123:D131)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Sanitary Sewer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C133:Q133)","v":0}]
["Potable Water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Non-Potable Water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Storm Drain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Detention Basin/Culverts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Joint Trench:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Site Utilities Costs",null,{"$f":"SUM(C133:C139)","v":0},{"$f":"SUM(D133:D139)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Aggregate Base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C141:Q141)","v":0}]
["Asphalt Pavement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Curb, Gutter, Sidewalk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Street Lights",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Striping/Signage/Barricades",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Traffic Mitigation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Surface Improvements Costs",null,{"$f":"SUM(C141:C147)","v":0},{"$f":"SUM(D141:D147)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Irrigation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C149:Q149)","v":0}]
["Concrete Work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Landscaping",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Urban Greening",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Playground Facilities and Tot Lots",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Walking/Bike Path",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Drinking Fountains",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Structures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Lighting ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Open Space ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Parks-Landscape and Amenities",null,{"$f":"SUM(C149:C159)","v":0},{"$f":"SUM(D149:D159)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Wetland Mitigation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C161:Q161)","v":0}]
["Endangered Species",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C162:Q162)","v":0}]
["Tree Mitigation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C163:Q163)","v":0}]
["Environmental Remediation ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C164:Q164)","v":0}]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C165:Q165)","v":0}]
["Total Env. Mitigation/Remediation",null,{"$f":"SUM(C161:C165)","v":0},{"$f":"SUM(D161:D165)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Residential Parking Structures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C167:Q167)","v":0}]
["Grading",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Foundation Work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Site Work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Replacement Parking Costs ",null,{"$f":"SUM(C167:C172)","v":0},{"$f":"SUM(D167:D172)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Residential Parking Structures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C174:Q174)","v":0}]
["Grading",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Foundation Work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Site Work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Residential Parking Costs",null,{"$f":"SUM(C174:C179)","v":0},{"$f":"SUM(D174:D179)","v":0},{"$f":"SUM(E174:E179)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Access Plazas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C181:Q181)","v":0}]
["Pathways",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Bus Shelters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transit Shelters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Pedestrian Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Bicycle Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Transit Costs",null,{"$f":"SUM(C181:C187)","v":0},{"$f":"SUM(D181:D187)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Drainage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C189:Q189)","v":0}]
["Parks & Recreation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Streets/Signals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Traffic Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Waste Water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Water Facility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C195:Q195)","v":0}]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Impact Fees",null,{"$f":"SUM(C189:C196)","v":0},{"$f":"SUM(D189:D196)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Engineering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C198:Q198)","v":0}]
["Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C199:Q199)","v":0}]
["Contractor Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C200:Q200)","v":0}]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C201:Q201)","v":0}]
["Total Soft Costs",null,{"$f":"SUM(C198:C201)","v":0},{"$f":"SUM(D198:D201)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C203:Q203)","v":0}]
["Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C204:Q204)","v":0}]
["Total Other Asset Costs",null,{"$f":"SUM(C203:C204)","v":0},{"$f":"SUM(D203:D204)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CIP TOTAL PROJECT COSTS",null,{"$f":"SUM(C122,C132,C140,C148,C160,C166,C173,C180,C188,C197,C202,C205)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["QIP TOTAL PROJECT COSTS",null,{"$f":"C118","v":0},{"$f":"D118","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL QIP & CIP PROJECT COSTS",null,{"$f":"C207+C206","v":0},{"$f":"D207+D206","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Scoring","index":7,"n_rows":84,"n_cols":37,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,0,0,35],[0,36,0,37],[7,35,7,37],[54,0,54,2],[54,3,54,11],[54,13,54,18],[54,19,54,21],[54,22,54,27],[54,28,54,31],[54,32,54,37],[53,0,53,2],[50,3,50,11],[50,13,50,18],[50,19,50,21],[50,28,50,31],[50,32,50,37],[50,0,50,2],[1,0,1,27],[1,28,1,35],[1,36,1,37],[9,30,9,37],[10,0,10,37],[2,0,2,37],[4,0,4,37],[46,8,46,31],[46,32,46,35],[51,8,51,31],[51,32,51,35],[64,26,64,37],[62,36,62,37],[59,3,59,19],[59,20,59,25],[59,26,59,37],[53,22,53,27],[53,28,53,29],[53,30,53,32],[53,34,53,37],[57,30,57,37],[58,0,58,31],[59,0,59,2],[57,12,57,22],[58,32,58,35],[58,36,58,37],[57,24,57,27],[57,28,57,29],[57,0,57,11],[46,36,46,37],[47,32,47,35],[70,3,70,20],[66,0,66,2],[56,8,56,31],[56,32,56,35],[63,32,63,35],[60,34,60,37],[61,0,61,2],[61,3,61,11],[61,13,61,18],[61,28,61,31],[61,32,61,37],[64,0,64,2],[64,3,64,19],[62,32,62,35],[65,0,65,2],[64,20,64,25],[60,3,60,20],[66,3,66,11],[66,13,66,18],[66,19,66,21],[66,22,66,27],[66,28,66,31],[66,32,66,37],[65,22,65,27],[68,0,68,31],[68,32,68,35],[68,36,68,37],[67,8,67,31],[67,32,67,35],[60,0,60,2],[60,22,60,27],[60,28,60,29],[60,30,60,32],[63,0,63,31],[61,22,61,27],[62,8,62,31],[65,3,65,20],[65,28,65,29],[65,30,65,32],[65,34,65,37],[62,0,62,2],[61,19,61,21],[63,36,63,37],[62,3,62,7],[82,21,82,24],[83,21,83,24],[81,0,81,4],[81,5,81,19],[81,33,81,35],[81,36,83,37],[81,27,81,32],[81,25,81,26],[82,0,82,4],[82,5,82,19],[82,25,82,26],[82,27,82,32],[82,33,82,35],[83,0,83,4],[83,5,83,19],[83,25,83,26],[83,27,83,32],[83,33,83,35],[81,21,81,24],[77,0,77,37],[79,0,79,33],[79,34,79,35],[79,36,79,37],[80,0,80,37],[78,36,78,37],[78,0,78,31],[78,32,78,35],[73,0,73,37],[74,0,74,37],[76,0,76,3],[76,4,76,7],[76,8,76,31],[76,32,76,35],[76,36,76,37],[75,0,75,33],[75,34,75,35],[75,36,75,37],[3,36,3,37],[5,36,6,37],[7,0,7,1],[7,2,7,23],[7,25,7,34],[8,0,8,37],[9,0,9,1],[9,23,9,24],[9,25,9,27],[9,28,9,29],[5,0,5,34],[6,0,6,34],[9,2,9,7],[9,9,9,15],[9,17,9,22],[3,0,3,3],[3,4,3,10],[3,11,3,31],[3,32,3,35],[29,0,29,37],[22,0,22,9],[22,10,22,37],[23,0,23,37],[25,26,25,27],[25,28,25,29],[17,0,17,12],[17,13,17,17],[17,18,17,24],[17,25,17,37],[18,0,18,12],[18,13,18,17],[18,18,18,24],[18,25,18,37],[28,19,28,22],[11,0,11,37],[12,0,12,34],[13,0,13,34],[12,36,13,37],[14,0,14,37],[25,30,25,31],[24,32,25,35],[24,36,25,37],[25,0,25,1],[25,2,25,15],[25,16,25,18],[25,19,25,20],[25,21,25,23],[24,30,24,31],[24,2,24,15],[24,16,24,18],[24,19,24,20],[24,21,24,23],[24,28,24,29],[24,26,24,27],[24,24,24,25],[25,24,25,25],[24,0,24,1],[28,0,28,15],[28,34,28,35],[28,26,28,33],[27,0,27,37],[28,16,28,18],[26,0,26,37],[28,36,28,37],[28,23,28,25],[15,0,15,12],[36,0,36,2],[36,3,36,6],[36,34,36,36],[36,7,36,33],[44,3,44,20],[41,33,41,35],[41,0,41,32],[41,36,41,37],[15,13,15,17],[15,18,15,24],[15,25,15,37],[16,0,16,12],[32,0,32,23],[32,24,32,27],[32,28,32,29],[32,30,32,33],[32,34,32,35],[32,36,32,37],[30,36,30,37],[30,0,30,23],[30,24,30,27],[30,28,30,29],[30,30,30,33],[30,34,30,35],[33,0,33,37],[31,0,31,37],[35,36,35,37],[35,1,35,4],[35,5,35,7],[35,8,35,16],[35,17,35,18],[35,25,35,26],[35,31,35,35],[35,27,35,30],[35,19,35,24],[49,0,49,2],[49,30,49,32],[49,34,49,37],[42,36,42,37],[42,0,42,31],[42,32,42,35],[46,0,46,2],[46,3,46,7],[43,0,43,2],[43,26,43,37],[44,22,44,27],[44,28,44,29],[44,30,44,32],[44,34,44,37],[43,3,43,19],[43,20,43,25],[45,0,45,2],[45,3,45,11],[45,13,45,18],[45,19,45,21],[45,22,45,27],[45,28,45,31],[45,32,45,37],[44,0,44,2],[56,36,56,37],[47,36,47,37],[55,36,55,37],[55,0,55,31],[55,32,55,35],[56,0,56,2],[56,3,56,7],[47,0,47,31],[51,36,51,37],[51,0,51,2],[50,22,50,27],[52,0,52,2],[52,3,52,19],[52,20,52,25],[52,26,52,37],[51,3,51,7],[48,0,48,2],[48,3,48,19],[48,20,48,25],[48,26,48,37],[49,22,49,27],[49,28,49,29],[49,3,49,20],[53,3,53,20],[72,0,72,2],[72,3,72,7],[72,36,72,37],[67,0,67,2],[67,3,67,7],[67,36,67,37],[70,0,70,2],[70,22,70,27],[70,28,70,29],[70,30,70,32],[70,34,70,37],[71,0,71,2],[71,3,71,11],[71,13,71,18],[71,19,71,21],[71,22,71,27],[71,28,71,31],[72,8,72,31],[72,32,72,35],[71,32,71,37],[69,0,69,2],[69,3,69,19],[69,20,69,25],[69,26,69,37],[39,34,39,35],[38,0,38,33],[38,34,38,35],[37,36,39,37],[39,0,39,33],[40,0,40,37],[16,13,16,17],[16,18,16,24],[16,25,16,37],[19,0,19,12],[19,13,19,17],[19,18,19,24],[19,25,19,37],[21,0,21,12],[21,13,21,17],[21,18,21,24],[21,25,21,37],[20,0,20,12],[20,13,20,17],[20,18,20,24],[20,25,20,37],[34,0,34,37],[37,34,37,35],[37,0,37,33]]}
[{"$f":"CONCATENATE(Overview!D2,\" CIP Scoring\")","v":" CIP Scoring"},null,null,null,null,null,null,null,null,null,null,null,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":"'IIG Cover'!A18","v":"Rev 10/11/17"}]
["250 Points Max (points in blue shaded cells)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total CIP Self Score",null,null,null,null,null,null,null,{"$f":"AK6+AK13+AK25+AK29+AK31+AK33+AK38+AK43+AK48+AK56+AK59+AK64+AK69+AK76","v":0}]
["Project Readiness §309(a) - 100 Points Max"]
["File Name:",null,null,null,"IIG E&L Use",null,null,null,null,null,null,"Provide signed copy or copies of the Verification of Environmental Review and Land Use Entitlements Form (next worksheet). Identify name of locality at the beginning of document.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(1) Environmental Review Status - 30 points max"]
["(A) For the QIP, we have completion and approval or adoption of all necessary environmental clearances including those required under the CEQA and if applicable, NEPA, and all applicable time periods for filing appeals or lawsuits have lapsed. If no, answer (B).",null,null,null,null,null,null,null,null,null,null,null,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(AJ6=\"Yes\",30,IF(AJ7=\"Yes\",15,0))","v":0}]
["(B) For the QIP, we have issued of a public notice of the availability of a draft environmental impact report, negative declaration, or environmental assessment?"]
["NEPA:",null,"Is Federal funding proposed that will trigger NEPA requirements? Describe any special circumstances below:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If Yes, enter date of \"Authority to Use Grant Funds\":"]
[]
["CEQA:",null,"Project approved \"by-right\"?",null,null,null,null,null,null,"Is Project Categorically Exempt?",null,null,null,null,null,null,null,"Negative Declaration Date:",null,null,null,null,null,null,null,"Final EIR Date:",null,null,null,null,"Describe special circumstances below:"]
[]
["(2) Land Use Entitlement Status - 30 points max"]
["(A) For the QIP, all necessary discretionary local land use approvals, excluding design review, have been granted including sites zoned for residential use by right pursuant to §65583.2(h) and (i) of the Government Code? If no, answer (B) below:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ13=\"Yes\",30,IF(AJ14=\"Yes\",15,0))","v":0}]
["(B) The QIP is consistent with local planning documents and zoning ordinances and applications for all necessary discretionary local land use approvals, excluding design review, have been submitted, accepted, and deemed complete by the appropriate local agencies?"]
["Provide a listing and status of all discretionary local land use approvals, excluding design review, required to complete QIP that have been granted, submitted or to be applied for to the appropriate local agencies, or consistent with local planning documents. This information must match the info provided on the Verification of the Status of Environmental Review and Land Use Entitlements form.\n\n"]
["Agency / Issuer",null,null,null,null,null,null,null,null,null,null,null,null,"Land Use Approval Date ",null,null,null,null,"Approval Type",null,null,null,null,null,null,"Type and Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Plan Amendment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Site Plan Review"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zoning 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,"Conditional Use Permits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Density Bonus"]
[]
["(3) Funding Commitments - 20 points max",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Elig, Units & Max Funds'!L50=0,'Elig, Units & Max Funds'!O50=0),\"\",IF(AND('Elig, Units & Max Funds'!L50>0,'Elig, Units & Max Funds'!O50>0),\"Rental and Ownership Development\",IF('Elig, Units & Max Funds'!O50>0,\"Ownership Development\",\"Rental Development\")))","v":""}]
["All funding sources on the Dev Sources worksheet must include Rental or Owner relating to the type of QIP (see §309(a)(3)(B) and (C) for an explanation of funding commitments). "]
["Rental:",null,"Commitments as a % of total development costs less deferred costs:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction:",null,null,{"$f":"'Dev Sources'!F21","v":0},null,"Permanent:",null,null,{"$f":"'Dev Sources'!F43","v":0},null,null,null,"Points:",null,{"$f":"IF(MIN(T25,Y25)>=0.9,20,IF(MIN(T25,Y25)>=0.75,10,IF(T25>=0.5,5,0)))","v":0},null,null,null,null,null,{"$f":"MIN(20,IF(AND(AE25>0,AE26>0),(AE25*('Elig, Units & Max Funds'!L50/'Elig, Units & Max Funds'!J50))+(AE26*('Elig, Units & Max Funds'!L50/'Elig, Units & Max Funds'!J50)),IF(AE25>0,AE25,AE26)))","v":0}]
["Owner:",null,"Commitments as a % of total development costs less deferred costs:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction:",null,null,{"$f":"'Dev Sources'!F22","v":0},null,"Permanent:",null,null,{"$f":"'Dev Sources'!F44","v":0},null,null,null,"Points:",null,{"$f":"IF(MIN(T26,Y26)>=0.9,20,IF(MIN(T26,Y26)>=0.75,10,IF(T26>=0.5,5,0)))","v":0}]
["(4) Local Support - 20 points max"]
["All funding sources on the Dev Sources worksheet must include Yes or No regarding whether it is \"local support\" (see §309(a)(4)(A) and (B) for an explanation of what may be considered local support). "]
["Total Local Public Agencies Funding Commitment Amount:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(('Dev Sources'!B27:B39=\"Yes\")*('Dev Sources'!H27:H39=\"Yes\")*('Dev Sources'!J27:J39))","v":0},null,null,"CIP Grant Amount",null,null,null,{"$f":"'Elig, Units & Max Funds'!AI52","v":0},null,null,"Commitments as a % of Program grant:",null,null,null,null,null,null,null,{"$f":"IF(X29=0,0,Q29/X29)","v":0},null,{"$f":"IF(AI29>=0.25,20,IF(AI29>=0.15,5,0))","v":0}]
["Affordability §309(b) - 60 Points Max"]
["Points based on % of QIP units restricted to occupancy by various income groups. (see Elig, Units & Max Funds worksheet)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"§309(b)(1) points=",null,null,null,{"$f":"'Elig, Units & Max Funds'!AI72","v":0},null,"§309(b)(3) points=",null,null,null,{"$f":"'Elig, Units & Max Funds'!G67","v":0},null,{"$f":"MIN(60,MAX(AC31,AI31))","v":0}]
["Density §309(c) - 40 Points Max"]
["Points based on extent to which the average Net Density of QIP, adjusted by unit size, exceeds the required density specified in §303(a)(4). (see Elig, Units & Max Funds worksheet)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Net Density =",null,null,null,{"$f":"MAX('Elig, Units & Max Funds'!AJ10,'Elig, Units & Max Funds'!V11)","v":30},null,"% QIP meets or exceeds required net density:",null,null,null,{"$f":"'Elig, Units & Max Funds'!AI18","v":0},null,{"$f":"IF(AI33>=1.5,40,IF(AI33>=1.4,30,IF(AI33>=1.3,20,IF(AI33>=1.2,15,IF(AI33>=1.1,10,0)))))","v":0}]
["Access to Transit §309(d) - 20 Points Max"]
["Points based on the proximity of QIP to a Transit Station or Major Transit Stop. The distance to a Transit Station or Major Transit Stop shall be evidenced by a date stamped map certified by a California State-licensed professional such as an engineer, surveyor or landscape architect. Provide a walkable route map, current transit maps and route schedules, highlighting the appropriate routes."]
["Type",null,null,null,null,"Transit Name",null,null,null,null,null,null,null,null,null,null,null,"Contact",null,null,null,null,null,null,null,"Phone",null,null,null,null,null,"Planned Station Service Date"]
["File Name:",null,null,"IIG Transit Access",null,null,null,"Provide date stamped map certified by a California State-licensed professional such as an engineer, surveyor or landscape architect. Provide a walkable route map, current transit maps and route schedules; highlight appropriate routes. Identify all Transit Stations or Major Transit Stops.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(1) Is QIP within one-half mile of a Transit Station or Major Transit Stop per §302(l)(1) or (2) measured by a \"walkable route\" from nearest boundary of QIP? (If yes, skip to §309(e))",null,null,null,null,null,null,null,null,null,null,null,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(AI38=\"Yes\",20,IF(AI39=\"Yes\",10,IF(AI40=\"Yes\",5,0)))","v":0}]
["(2) Is QIP within one mile of a Transit Station or Major Transit Stop per §302(l)(1) or (2) measured by a \"walkable route\" from the nearest boundary of QIP? (If yes, skip to §309(e))"]
["(3) Is QIP within one mile of a Transit Station or Major Transit Stop per §302(l)(3) or (4) measured by a \"walkable route\" from the nearest boundary of QIP?"]
["Proximity to Amenities §309(e) - 20 Points Max"]
["Points based on the proximity or accessibility of QIP to the following existing amenities or amenities that will be in service when the QIP is completed. Distance to amenities shall be evidenced by a certified date stamped map. Also include an aerial photo clearly showing distance from amenity to QIP.  Distances are measured \"as the crow flies\".",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rural Area Project?",null,null,{"$f":"'Elig, Units & Max Funds'!AE10","v":0}]
["(1) The QIP is within what distance from a public park? ",null,null,null,null,null,null,null,null,null,null,null,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(AND($AK$42=\"Yes\",OR(AG43=\"Within 1/2 mile\",AG43=\"Within 1/4 mile\")),6,IF(AND($AK$42=\"Yes\",AG43=\"Within 1 mile\"),4,IF(AND(OR($AK$42=0,$AK$42=\"No\"),AG43=\"Within 1/4 mile\"),6,IF(AND(OR($AK$42=0,$AK$42=\"No\"),AG43=\"Within 1/2 mile\"),4,0))))","v":0}]
["Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Responsible Jurisdiction"]
["Site Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Contact",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,"Date In Service"]
["File Name:",null,null,"IIG Park Access",null,null,null,null,"Provide date stamped map certified by a California State-licensed professional showing distances to public park.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(2) The QIP is within what distance from a locally recognized employment center with a minimum of 50 full-time employees? ",null,null,null,null,null,null,null,null,null,null,null,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(AND($AK$42=\"Yes\",OR(AG48=\"Within 1 mile\",AG48=\"Within 2 miles\")),7,IF(AND($AK$42=\"Yes\",AG48=\"Within 4 miles\"),4,IF(AND(OR($AK$42=0,$AK$42=\"No\"),AG48=\"Within 1 mile\"),7,IF(AND(OR($AK$42=0,$AK$42=\"No\"),AG48=\"Within 2 miles\"),4,0))))","v":0}]
["Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Responsible Jurisdiction"]
["Site Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Contact",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,"Date In Service"]
["File Name:",null,null,"IIG Employment Access",null,null,null,null,"Provide date stamped map certified by a California State-licensed professional showing distances to employment center.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Responsible Jurisdiction"]
["Site Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Contact",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,"Date In Service"]
["(3) The QIP is within what distance from a locally recognized retail center with a minimum of 50 full-time employees? ",null,null,null,null,null,null,null,null,null,null,null,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(AND($AK$42=\"Yes\",OR(AG56=\"Within 1 mile\",AG56=\"Within 2 miles\")),7,IF(AND($AK$42=\"Yes\",AG56=\"Within 4 miles\"),4,IF(AND(OR($AK$42=0,$AK$42=\"No\"),AG56=\"Within 1 mile\"),7,IF(AND(OR($AK$42=0,$AK$42=\"No\"),AG56=\"Within 2 miles\"),4,0))))","v":0}]
["File Name:",null,null,"IIG Retail Access",null,null,null,null,"Provide date stamped map certified by a California State-licensed professional showing distances to retail center.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(4) Only for QIPs where 50% of units have 2 or more bedrooms:",null,null,null,null,null,null,null,null,null,null,null,"# of two+ bedrooms in QIP (see QIP Units & Max Funds):",null,null,null,null,null,null,null,null,null,null,{"$f":"(SUMIF('Elig, Units & Max Funds'!A30:B49,\"2\",'Elig, Units & Max Funds'!J30:K49)+SUMIF('Elig, Units & Max Funds'!A30:B49,\"3\",'Elig, Units & Max Funds'!J30:K49)+SUMIF('Elig, Units & Max Funds'!A30:B49,\"4\",'Elig, Units & Max Funds'!J30:K49))","v":0},"% of two+ bedrooms",null,null,null,{"$f":"IF('Elig, Units & Max Funds'!J50=0,0,X58/'Elig, Units & Max Funds'!J50)","v":0},null,{"$f":"IF(AC58>=0.5,\">=50% answer (a) below\",\"Below 50% skip to (5)\")","v":"Below 50% skip to (5)"}]
["(a) The QIP is within what distance from a public school or community college that QIP residents may attend (only for QIPs where 50% of units have 2 or more bedrooms?",null,null,null,null,null,null,null,null,null,null,null,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(AE58=\"Below 50% skip to (5)\",0,IF(AND($AK$42=\"Yes\",OR(AG59=\"Within 1/2 mile\",AG59=\"Within 1/4 mile\")),7,IF(AND($AK$42=\"Yes\",AG59=\"Within 1 mile\"),4,IF(AND(OR($AK$42=0,$AK$42=\"No\"),AG59=\"Within 1/4 mile\"),7,IF(AND(OR($AK$42=0,$AK$42=\"No\"),AG59=\"Within 1/2 mile\"),4,0)))))","v":0}]
["Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Responsible Jurisdiction"]
["Site Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Contact",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,"Date In Service"]
["File Name:",null,null,"IIG Education Access",null,null,null,null,"Provide date stamped map certified by a California State-licensed professional showing distances to school/college.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(5) The QIP is within how far from a social service facility that operates to serve residents of QIP? ",null,null,null,null,null,null,null,null,null,null,null,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(AG64=\"Within 1/2 mile\",7,IF(AG64=\"Within 1 mile\",4,0))","v":0}]
["Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Responsible Jurisdiction"]
["Site Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Contact",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,"Date In Service"]
["File Name:",null,null,"IIG TCAC-MHP type",null,null,null,null,"Provide documentation of amenity compliance with TCAC or MHP guidelines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["(6) The QIP is within how far from a senior center or a facility regularly offering services specifically designed for seniors? ",null,null,null,null,null,null,null,null,null,null,null,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(AND($AK$42=\"Yes\",OR(AG69=\"Within 1/2 mile\",AG69=\"Within 1/4 mile\")),7,IF(AND($AK$42=\"Yes\",AG69=\"Within 1 mile\"),4,IF(AND($AK$42=\"No\",AG69=\"Within 1/4 mile\"),7,IF(AND($AK$42=\"No\",AG69=\"Within 1/2 mile\"),4,0))))","v":0}]
["Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Responsible Jurisdiction"]
["Site Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Contact",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,"Date In Service"]
["File Name:",null,null,"IIG Qualified Seniors",null,null,null,null,"Provide documentation that some QIP units are reserved senior citizens under Sections 51.2, 51.3 and 51.4 of the Civil Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["Consistency with Regional Plans §309(f) - 10 Points Max"]
["Points based on QIP’s location is consistent with an adopted regional blueprint plan or other adopted regional growth plan (including, but not limited to, an adopted regional transportation plan or sustainable communities strategy) with the stated intent of fostering efficient land use and that encourages infill development."]
["Is QIP consistent with a Regional Blueprint Plan or other Regional Growth Plan adopted by a regional council of government, metropolitan planning organization, or regional transportation planning agency with the stated intent of fostering infill development and efficient land use and in effect by the application due date? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI76=\"Yes\",10,0)","v":0}]
["File Name:",null,null,null,"IIG QIP Consistency",null,null,null,"Submit a letter or resolution from the local council of government, metropolitan planning organization or regional transportation planning agency confirming consistency with adopted regional blueprint or other adopted regional growth plan.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["Tie Breaker §307(f) "]
["In the event two or more applications have the same rating and ranking scores, HCD will apply tie breaking criteria outlined in the NOFA.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"App due date:",null,null,null,"2017-01-16"]
["(1) 10 bonus points will be given to the QIP having the lowest ratio between the requested grant amount to the total allowable maximum grant amount per §305(a).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ratio=",null,{"$f":"IF(MIN(5000000,('Elig, Units & Max Funds'!G52*'Elig, Units & Max Funds'!AA52)=0),0,'Dev Sources'!J27/MIN(5000000,('Elig, Units & Max Funds'!G52*'Elig, Units & Max Funds'!AA52)))","v":0}]
["(1) If tie still exists, 3 points will be give to QIP for each prior awarded QIP developed by the Applicant Entity that has received a Certificate of Occupancy by the application deadline set forth in the NOFA."]
["Name of Development:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AH82<>\"\",AH82<=$AK$79),1,0)","v":0},"IIG prior NOFA Date",null,null,null,null,null,"Certificate of Occupancy Date:",null,null,null,null,null,null,null,null,{"$f":"SUM(U82:U84)*3","v":0}]
["Name of Development:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AH83<>\"\",AH83<=$AK$79),1,0)","v":0},"IIG prior NOFA Date",null,null,null,null,null,"Certificate of Occupancy Date:"]
["Name of Development:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"IIG prior NOFA Date",null,null,null,null,null,"Certificate of Occupancy Date:"]

{"sheet":"Env & Land Use Verification","index":8,"n_rows":52,"n_cols":37,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,35],[0,36,0,37],[2,11,2,31],[2,4,2,10],[2,0,2,3],[47,20,48,37],[48,0,48,8],[49,0,49,5],[49,6,49,18],[49,19,49,24],[49,25,49,37],[37,0,37,37],[41,0,41,3],[41,4,41,8],[44,28,44,29],[44,30,44,32],[44,34,44,37],[41,20,42,37],[41,9,42,19],[43,6,43,18],[43,19,43,24],[43,25,43,37],[44,5,44,20],[44,22,44,27],[44,0,44,4],[36,26,36,34],[50,0,50,4],[50,5,50,20],[50,22,50,27],[50,28,50,29],[50,30,50,32],[50,34,50,37],[47,0,47,3],[47,4,47,8],[47,9,48,19],[34,18,34,25],[34,0,34,12],[35,0,35,12],[36,0,36,12],[34,13,34,17],[35,13,35,17],[36,13,36,17],[35,18,35,25],[36,18,36,25],[28,35,28,37],[29,35,29,37],[30,35,30,37],[31,35,31,37],[32,35,32,37],[33,35,33,37],[26,18,26,25],[27,18,27,25],[28,18,28,25],[29,18,29,25],[30,18,30,25],[31,18,31,25],[32,18,32,25],[33,18,33,25],[26,26,26,34],[27,26,27,34],[28,26,28,34],[29,26,29,34],[30,26,30,34],[31,26,31,34],[32,26,32,34],[33,26,33,34],[7,29,7,31],[7,32,7,34],[7,35,7,37],[8,0,15,0],[8,1,15,6],[8,7,15,16],[8,17,15,22],[8,23,15,25],[8,26,15,28],[8,29,15,31],[8,32,8,34],[8,35,8,37],[9,32,9,34],[15,32,15,34],[15,35,15,37],[9,35,9,37],[10,32,10,34],[10,35,10,37],[11,32,11,34],[11,35,11,37],[12,32,12,34],[3,0,3,37],[7,1,7,6],[7,7,7,16],[7,17,7,22],[7,23,7,25],[7,26,7,28],[1,0,1,3],[1,4,1,10],[1,11,1,31],[1,32,1,35],[1,36,1,37],[4,0,4,37],[5,0,5,2],[5,3,5,21],[5,22,5,25],[5,26,5,37],[2,36,2,37],[2,32,2,35],[6,0,6,1],[6,2,6,20],[6,22,6,27],[6,28,6,29],[6,30,6,32],[6,34,6,37],[18,0,18,36],[19,0,19,37],[20,33,20,37],[20,28,20,32],[20,23,20,27],[20,18,20,22],[20,13,20,17],[20,8,20,12],[12,35,12,37],[13,32,13,34],[13,35,13,37],[14,32,14,34],[14,35,14,37],[20,0,20,7],[16,0,16,37],[17,0,17,37],[28,0,28,12],[25,0,25,37],[26,13,26,17],[27,13,27,17],[26,0,26,12],[27,0,27,12],[21,18,21,22],[22,18,22,22],[21,23,21,27],[22,23,22,27],[21,28,21,32],[22,28,22,32],[21,33,21,37],[22,33,22,37],[23,0,23,37],[21,8,21,12],[22,8,22,12],[21,0,21,7],[22,0,22,7],[21,13,21,17],[22,13,22,17],[24,0,24,37],[26,35,26,37],[27,35,27,37],[51,0,51,37],[29,0,29,12],[28,13,28,17],[29,13,29,17],[30,0,30,12],[31,0,31,12],[32,0,32,12],[33,0,33,12],[30,13,30,17],[31,13,31,17],[32,13,32,17],[33,13,33,17],[34,26,34,34],[38,0,38,37],[39,0,39,37],[40,0,40,37],[45,0,45,37],[46,0,46,23],[42,0,42,8],[43,0,43,5],[34,35,34,37],[35,35,35,37],[36,35,36,37],[35,26,35,34]]}
[{"$f":"CONCATENATE(Overview!D2,\" Verification of Environmental Review & Land Use Entitlements\")","v":" Verification of Environmental Review & Land Use Entitlements"},null,null,null,null,null,null,null,null,null,null,null,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":"'IIG Cover'!A18","v":"Rev 10/11/17"}]
["File Name:",null,null,null,"IIG Auth to Use Grant Funds",null,null,null,null,null,null,"For NEPA only, provide a copy of the HUD 7015.16 \"Authority To Use Grant Funds\" or clarify the current status of the issuance of the HUD form.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["File Name:",null,null,null,"IIG Environmental",null,null,null,null,null,null,"Provide a copy of all environmental clearances or Notice of Exemption",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Uploaded?"]
["TO THE APPLICANT:  Submit this form to the Agency or Department of local government responsible for administration of the items listed.  This form may be submitted to more than one Agency or Department, if necessary.  QIP applicants need only submit one completed form per locality.   If the NEPA Responsible Entity is not a local government, submit a copy of this form to the appropriate NEPA Responsible Entity.  If an item is not required, include the reason why in the box provided."]
["Applicant"]
["Entity Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicant Type"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
[null,"Project Name",null,null,null,null,null,"Brief Description",null,null,null,null,null,null,null,null,null,"Address",null,null,null,null,null,"City",null,null,"Zip",null,null,"County",null,null,"Census Tracts",null,null,"APNs"]
["QIP"]
[]
[]
[]
[]
[]
[]
[]
["TO THE LOCAL JURISDICTION OR NEPA RESPONSIBLE ENTITY:  The Applicant named above will submit an application to the State of California, Department of Housing and Community Development, requesting funding for the project named above under the Infill Infrastructure Grant Program (IIG).  Projects will be evaluated based upon readiness.  Please answer the following questions:"]
["Environmental Review"]
["Is this QIP approved \"by right\"?"]
["This form must be completed in its entirety regardless of the answer to the preceding question."]
["All Environmental Clearances (CEQA/NEPA) necessary to begin construction are:",null,null,null,null,null,null,null,"Not Required for this Project",null,null,null,null,"Has a Negative Declaration been issued? ",null,null,null,null,"Final Date of Public Comment Period",null,null,null,null,"Date(s) EIR Certified / Notice of Determination filed",null,null,null,null,"Date Appeal Period Ends",null,null,null,null,"Have any appeals been filed?"]
["CEQA"]
["NEPA*"]
["In the box below, explain why any items are not required and include documentation, if applicable:"]
[]
["Land Use Entitlements  (indicate below the status of the following local approvals)"]
["All necessary and discretionary public land use approvals except building permits and other ministerial approvals are:",null,null,null,null,null,null,null,null,null,null,null,null,"Not Required for this Project",null,null,null,null,"QIP is consistent with local planning documents & zoning ordinances",null,null,null,null,null,null,null,"An Application has been submitted, accepted and deemed complete for processing.",null,null,null,null,null,null,null,null,"Date Approved"]
["General Plan Amendment:"]
["Site Plan Review:"]
["Zoning Approval:"]
["Conditional Use Permits:"]
["Density Bonus:"]
["Other Variances: "]
["Other Variances: "]
["Other Variances: "]
["Other Variances: "]
["Other Variances: "]
["In the box below, explain why any items are not required and include documentation, if applicable:"]
[]
["Signature Block for Environmental Review"]
["I certify that the information on this form is true and correct to the best of my knowledge."]
["Date: ",null,null,null,null,null,null,null,null,"Signature of party completing form:  "]
["Printed name of party completing form:"]
["Title of party completing form:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency and/or Dept. name:"]
["Agency/Dept. Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["Signature Block for Land Use Entitlements"]
["I certify that the information on this form is true and correct to the best of my knowledge."]
["Date: ",null,null,null,null,null,null,null,null,"Signature of party completing form:  "]
["Printed name of party completing form:"]
["Title of party completing form:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency and/or Dept. name:"]
["Agency/Dept. Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City",null,null,null,null,null,null,"State",null,null,null,null,"Zip"]
["TO THE APPLICANT:  HCD requires an original, fully completed form with \"wet signatures\".  Faxes or electronically transmitted versions of this document will not be accepted."]

{"sheet":"Sample Reso","index":9,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,0,5,12],[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[4,0,4,12],[6,1,6,5],[6,7,6,12],[7,1,7,12],[8,1,10,12],[11,1,11,5],[11,6,11,12],[12,1,12,12],[13,1,13,3],[13,4,13,12],[14,0,14,12],[15,1,15,5],[15,6,15,12],[26,1,26,12],[16,1,16,12],[17,1,17,3],[17,4,17,12],[18,1,18,12],[19,1,19,6],[19,7,19,12],[20,1,20,12],[21,1,21,6],[22,1,22,6],[24,1,24,6],[25,1,25,6],[27,0,27,4],[27,7,27,8],[27,11,27,12],[28,5,28,6],[28,7,28,8],[28,9,28,10],[34,1,34,7],[29,0,29,2],[29,3,29,5],[29,6,29,7],[29,8,29,12],[30,1,30,12],[31,1,31,7],[32,1,32,7],[32,8,33,8],[32,9,32,10],[33,1,33,7],[33,9,33,10],[35,1,35,7],[36,0,36,1],[39,1,39,12],[37,1,37,12],[38,1,38,12]]}
["Governing Board Resolution (SAMPLE)"]
["RESOLUTION No."]
["__________"]
[]
["HEREBY AUTHORIZES THE SUBMITTAL OF AN APPLICATION TO THE CALIFORNIA STATE DEPARTMENT OF HOUSING AND COMMUNITY DEVELOPMENT FOR FUNDING UNDER THE INFILL INFRASTRUCTURE GRANT PROGRAM; THE EXECUTION OF A STANDARD AGREEMENT IF SELECTED FOR SUCH FUNDING AND ANY AMENDMENTS THERETO; AND ANY RELATED DOCUMENTS NECESSARY TO PARTICIPATE IN THE INFILL INFRASTRUCTURE GRANT PROGRAM."]
["WHEREAS:"]
["A.",{"$f":"A4","v":0},null,null,null,null,", a"]
[null,"wishes to apply for and receive an allocation of funds through the Infill Infrastructure Grant Program; and"]
["B.","The California Department of Housing and Community Development (hereinafter referred to as “HCD”) has issued a Notice of Funding Availability (“NOFA”) for the Infill Infrastructure Grant Program established under the Housing and Emergency Shelter Trust Fund Act of 2006 (Proposition 1C) pursuant to the Infill Infrastructure Grant Program established Part 12 of Division 31 of the Health and Safety Code, commencing with Section 53545.12. Pursuant to the statute, HCD is authorized to approve funding allocations utilizing monies made available by the State Legislature, subject to the terms and conditions of the statute and the Infill Infrastructure Grant Program Guidelines implemented SEPTEMBER 29, 2017; and"]
[]
[]
["C.",{"$f":"B7","v":0},null,null,null,null,"wishes to submit an application to obtain"]
[null," from HCD an allocation of the Infill Infrastructure Grant Program funds in the amount of "]
[null,null,null,null,"."]
["IT IS NOW THEREFORE RESOLVED THAT:"]
["1.",{"$f":"B7","v":0},null,null,null,null,"shall submit to HCD an application to"]
[null," participate in the Infill Infrastructure Grant Program in response to the NOFA issued on OCTOBER 2, 2017 which will request a funding allocation in the amount of "]
[null,{"$f":"B14","v":0},null,null,"for the following activities:"]
[null,"(Briefly describe the proposed Capital Improvement Project)"]
["2.","If the application for funding is approved, the ",null,null,null,null,null,{"$f":"B7","v":0}]
[null,"hereby agrees to use the Infill Infrastructure Grant Program funds for eligible activities in the manner presented in the application as approved by HCD and in accordance with program Guidelines cites above.  It also may execute any and all other instruments necessary or required by HCD for participation in the Infill Infrastructure Grant Program."]
["3.",{"$f":"B7","v":0}]
[null,"authorizes"]
[null,"[name(s) of person(s) and office or position title(s) of authorized person(s)]"]
[null,"to execute in the name of the "]
[null,{"$f":"B7","v":0}]
[null,"the application, the Standard Agreement, and all other documents required by HCD for participation in the Infill Infrastructure Grant Program, and any amendments thereto."]
["PASSED AND ADOPTED THIS",null,null,null,null,"(Day)","of","(Month)",null,",","(Year)","by the following vote:"]
[null,"AYES","(#)","NAYS","(#)","ABSTAIN",null,"(#)",null,"ABSENT",null,"(#)"]
["The undersigned",null,null,"(title of officer)",null,null,"of the",null,{"$f":"B7","v":0}]
[null," there before names does hereby attest and certify that the foregoing is a true and full copy of a resolution of the Governing Board adopted at a duly convened meeting on the date above-mentioned, which has not been altered, amended or repealed."]
[]
[]
[null,"Signature",null,null,null,null,null,null,null,"Date"]
[]
[null,"Print Name"]
["NOTES:  "]
["1.","This is intended to be a sample resolution authorizing submittal of an application to HCD.  Applicants may use their own format it if contains all of the authorizations contained in this sample"]
["2.","The person attesting to the signing of the resolution cannot be the same person who is authorized to execute documents in the name of the applicant."]
["3.","Original resolution or a live certified copy of the resolution must be submitted with the application."]

{"sheet":"Dropdowns","index":10,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["No","Non-profit Developer","Locality","Employment Centers","City","Alameda","single story","Fixed for Term","Interest Only","Fully Amortized"]
["Yes, at least 75% of the area included within QIP was previously improved or used for any use other than open space, agriculture, forestry or mining waste storage","For-profit Developer","Public Housing Authority","Retail Center","County","Alpine","town-house","Fixed with Reset","Deferred","Amortized with Call"]
["Yes, at least 75% of QIP perimeter adjoining parcels are developed with Urban Uses or QIP is separated from parcels that are developed with Urban Uses only by an improved public right-of-way",null,"Redevelopment Successory Agency","Public Park","City/County","Amador","mid-rise buildings","Fixed, then Variable","None","Residual Receipts"]
["Yes, at least 50% of the perimeter adjoining parcels developed with urban uses AND at least 50% of the area within the QIP was previously developed",null,"Transit Agency or Transit Operator","Public School/College","Community Service District","Butte","high-rise buildings","Variable","Other","Deferred"]
[null,null,"Regional Transportation Planning Agency (RTPA)","Special Needs","State","Calaveras",null,"Other",null,"Interest Only"]
[null,null,"Local Transportation Commissions","Senior Services","National","Colusa",null,null,null,"Fixed to Float"]
[null,null,"Congestion Management Agencies",null,"Private (full public access)","Contra Costa",null,null,null,"MHP-Partial Interest Only"]
[null,null,"Joint Powers Authority (JPA)",null,null,"Del Norte"]
[null,null,"School District",null,null,"El Dorado"]
[null,null,"Facilites District",null,null,"Fresno"]
[null,null,"University or Community College District",null,null,"Glenn"]
[null,null,"Developer",null,null,"Humboldt"]
[null,null,"Program Operator",null,null,"Imperial"]
[null,null,null,null,null,"Inyo"]
[null,null,null,null,null,"Kern"]
[null,null,null,null,null,"Kings"]
[null,null,null,null,null,"Lake"]
[null,null,null,null,null,"Lassen"]
[null,null,null,null,null,"Los Angeles"]
[null,null,null,null,null,"Madera"]
[null,null,null,null,null,"Marin"]
[null,null,null,null,null,"Mariposa"]
[null,null,null,null,null,"Mendocino"]
[null,null,null,null,null,"Merced"]
[null,null,null,null,null,"Modoc"]
[null,null,null,null,null,"Mono"]
[null,null,null,null,null,"Monterey"]
[null,null,null,null,null,"Napa"]
[null,null,null,null,null,"Nevada"]
[null,null,null,null,null,"Orange"]
[null,null,null,null,null,"Placer"]
[null,null,null,null,null,"Plumas"]
[null,null,null,null,null,"Riverside"]
[null,null,null,null,null,"Sacramento"]
[null,null,null,null,null,"San Benito"]
[null,null,null,null,null,"San Bernardino"]
[null,null,null,null,null,"San Diego"]
[null,null,null,null,null,"San Francisco"]
[null,null,null,null,null,"San Joaquin"]
[null,null,null,null,null,"San Luis Obispo"]
[null,null,null,null,null,"San Mateo"]
[null,null,null,null,null,"Santa Barbara"]
[null,null,null,null,null,"Santa Clara"]
[null,null,null,null,null,"Santa Cruz"]
[null,null,null,null,null,"Shasta"]
[null,null,null,null,null,"Sierra"]
[null,null,null,null,null,"Siskiyou"]
[null,null,null,null,null,"Solano"]
[null,null,null,null,null,"Sonoma"]
[null,null,null,null,null,"Stanislaus"]
[null,null,null,null,null,"Sutter"]
[null,null,null,null,null,"Tehama"]
[null,null,null,null,null,"Trinity"]
[null,null,null,null,null,"Tulare"]
[null,null,null,null,null,"Tuolumne"]
[null,null,null,null,null,"Ventura"]
[null,null,null,null,null,"Yolo"]
[null,null,null,null,null,"Yuba"]