{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["drop down menus","Application Instructions","Supporting Documents","General Information","Applicant Experience","Acknowledgement & Cert. ","Applicant Certification","Development Team","Development Timeline","Predev Financing","Sources","Unit Mix & Funding ","Operating Subsidies","Development Budget","Operating Budget","20-Year Cash Flow","H.2 Service Delivery - HIDDEN","I.16 Sust. Bldg. Methods ","I.16a Hlthy. Design Elem. "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":78,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"drop down menus","index":0,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["(Select)"]
["Yes"]
["No",null,null,null,null,null,"(Select)"]
["(Select)",null,null,"Seller",null,null,"Unincorporated Los Angeles"]
["Non-profit",null,null,"Owner",null,null,"City of Los Angeles"]
["For-profit",null,null,"Tenant",null,null,"City of Los Angeles, County Owned Land"]
["(Select)",null,null,null,null,null,"Incorporated area, outside City of Los Angeles"]
["Mixed Population",null,null,null,null,null,"HOME Participating City"]
["Special Needs",null,null,"(Select)"]
[null,null,null,"Single Family",null,null,"(Select)"]
["(Select)",null,null,"Multifamily (Apts)",null,null,"Predevelopment"]
["Construction only",null,null,"(Select)",null,null,"Construction"]
["Permanent only",null,null,"Full Time"]
["Construction & Perm",null,null,"Part Time",null,null,"(Select)"]
["(Select)",null,null,null,null,null,"Non-rural project, Census Tract is Highest Resource (20 Percentage Points)"]
["Hard payments",null,null,null,null,null,"Non-rural project, Census Tract is High Resource (10 Percentage Points)"]
["Soft debt",null,null,"(Select)",null,null,"Rural project, Census Tract is Highest Resource (10 Percentage Points)"]
["Grant",null,null,"4% Tax Credits",null,null,"Rural project, Census Tract is High Resource (5 Percentage Points)"]
["4% Equity",null,null,"9% Tax Credits",null,null,"N/A"]
["9% Equity",null,null,"Not Applying for Tax Credits"]
["Other"]
["(Select)",null,null,"(Select)"]
["Y",null,null,"Affordable Housing Trust Funds"]
["N",null,null,"HOME"]
["(Select)",null,null,"Measure H"]
["Studio / SRO",null,null,"MHHP"]
["1-Bedroom",null,null,"No Place Like Home"]
["2-Bedroom"]
["3-Bedroom",null,null,"(Select)",null,null,"(Select)"]
["4-Bedroom",null,null,"Capital",null,null,"Capital"]
["5-Bedroom",null,null,"Capital & Rental Assistance",null,null,"Preservation"]
[null,null,null,"Preservation"]
["(Select)",null,null,"PBVASH only"]
["Acquisition"]
["Predevelopment"]
["Acq & Predevelopment"]
[]
["(Select)",null,null,"(Select)"]
[0,null,null,"Large Family"]
[0.01,null,null,"Special Needs"]
[0.02,null,null,"Seniors"]
[0.03,null,null,"Supportive Housing"]
[0.04,null,null,"At High Risk"]
[0.05]
[0.06]
[7.0000000000000007E-2]
[0.08]
[0.09]
[0.1]
[]
[]
[]
[]
[]
[null,null,null,0]
[null,null,null,3,0,0,0,0]
[0,0,0,4,5,2,1,2]
[3,15,10,5,null,null,null,4]

{"sheet":"Application Instructions","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7],[15,2,15,7],[5,1,5,7],[9,1,9,7],[11,2,11,7],[13,2,13,7]]}
[null,"APPENDIX B"]
[null,"APPLICATION FOR FUNDING/PRO FORMA"]
[]
[null,"Introduction"]
[]
[null,"This application accompanies the Request for Proposals (RFP) LACDA21-028  released by the Los Angeles County Development Authority (LACDA).   "]
[]
[null,"Application Instructions"]
[]
[null,"Applications must comply with the general requirements below.  Once an application has been submitted, applicants will not be permitted the opportunity to add any information or cure deficiencies.  "]
[]
[null,1,"All applications must follow the format set forth in this document.  Applications that are incomplete, out of order, or have other content errors, inconsistencies, misrepresented information, or deficiencies may not receive further consideration.   "]
[]
[null,2,"Expand the narrative boxes to the size of the text entered.  Font size shall be uniform with no smaller than 10 pitch font and single spaced.  "]
[]
[null,3,"Failure to follow with these requirements may lead to disqualification.  Disqualified applications will not be evaluated."]

{"sheet":"Supporting Documents","index":2,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7],[3,1,3,7],[5,2,5,7],[6,2,6,7],[18,2,18,7],[7,2,7,7],[8,2,8,7],[9,2,9,7],[10,2,10,7],[11,2,11,7],[12,2,12,7],[13,2,13,7],[14,2,14,7],[15,2,15,7],[16,2,16,7],[17,2,17,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[28,2,28,7],[19,2,19,7],[20,2,20,7],[21,2,21,7],[22,2,22,7],[23,2,23,7],[24,2,24,7]]}
[]
[null," Supporting Documents Checklist"]
[]
[null,"Selected project(s) for DR- MHP funds will have to provide the following documents by December 31, 2021, if not already provided in the application."]
[]
[null,1,"Non-Debarment Verification for Partnership, Managing General Partner and Administrative General Partner\n (if applicable)"]
[null,2,"DR-MHP Project Contact Information \n"]
[null,3,"Partnership Agreement"]
[null,4,"DR-MHP Identity of Interest Disclosure "]
[null,5,"Qualifications of Development Team (e.g., resumes)"]
[null,6,"DR-MHP Developer’s Experience Form "]
[null,7,"Developer/Partnership Financial Statements"]
[null,8,"DR-MHP Developer's Legal Status Form "]
[null,9,"Site Map, Plans and Development Renderings"]
[null,10,"DR-MHP Unit Mix Form "]
[null,11,"Construction Schedule"]
[null,12,"If the project is not subject to WUI building codes, a map demonstrating the development is not in a High Fire Zone "]
[null,13,"Documentation from the local building official attesting that the project has all necessary approvals to be issued a building permit (if fully entitled or has a completed application)"]
[null,14,"Article XXXIV"]
[null,15,"DR-MHP Labor Standards Compliance Form "]
[null,16,"Letter from Architect stating they will comply with Section 504 accessibility regulations"]
[null,17,"Market Assessment or Study"]
[null,18,"20-year Operating Proforma"]
[null,19,"Copy of Local Development Application"]
[null,20,"Draft Affirmative Marketing Plan"]
[null,21,"Supportive Services Plan (If applicable)"]
[null,22,"Environmental Review Record and Request for Release of Funds (RROF)"]
[null,23,"Total Development Cost Line Item Budget and Sources & Uses Statement"]
[null,24,"Letters of funding commitments from all other sources (If available) "]

{"sheet":"General Information","index":3,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,2,4,11],[33,3,33,10],[34,3,34,10],[2,3,2,11],[28,8,28,11],[24,3,24,4],[9,4,9,8],[10,4,10,8],[12,4,12,8],[13,4,13,8],[14,4,14,8],[11,4,11,8],[20,4,20,8],[21,4,21,8],[18,4,18,8],[19,4,19,8],[22,1,22,8],[17,1,17,7],[8,1,8,8],[6,2,6,3],[15,4,15,5],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3]]}
[]
[null,"General Application Information"]
[]
[]
[null,"Project Name:"]
[]
[null,"Funding Request:",null,null,null,null,"Max. Funding Based on Formula",null,{"$f":"'Unit Mix & Funding '!D23","v":0}]
[]
[null,"Applicant Information"]
[null,"Applicant's Legal Name      "]
[null,"Common Name (if different) "]
[null,"Principal in charge"]
[null,"Address"]
[null,"Zip Code"]
[null,"City"]
[null,"Applicant Type (menu selection)",null,null,"(Select)"]
[]
[null,"Applicant Contact During RFP Process*"]
[null,"Name"]
[null,"Title"]
[null,"Telephone Number"]
[null,"Email"]
[null,"* Person most knowledgeable about the application; may be different from the individual authorized to sign and submit the app."]
[]
[null,"Proposed project type:",null,"(Select)"]
[]
[null,"If the project will apply for tax credits, which type is proposed?",null,null,null,null,null,"(Select)"]
[]
[null,"If so, what is the anticipated date (month/year) for applying for Tax Credits?"]
[]
[null,"Will the project use awarded funds as leverage for another funding application?",null,null,null,null,null,null,"(Select)"]
[]
[null,"If the project is using awarded funds to leverage other sources, state the source(s) and date(s) of application."]
[null,"Funding Source(s):"]
[null,"Application Date(s):"]

{"sheet":"Applicant Experience","index":4,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
[]
[null,"Applicant Experience"]
[]
[]
[null,"Name of Developer:"]
[null,"List ALL projects of the Lead Developer or the Joint Developer, but not both entities together."]
[]
[null,"Project Name & Address","Date Completed","Project type \n(New Construction or rehab)","Target Population","Number of Restricted Units","Number of Total Units","Principal Funding Sources (LIHTC, MHP, etc.)","Identify if Applicant Was Lead Developer"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[null," "]
[]
[null,"List ALL projects of the Lead Developer or the Joint Developer with LACDA funding in predevelopment or construction phase."]
[]
[null,"Project Name","City","District","Total Units","Phase"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"Acknowledgement & Cert. ","index":5,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,1,13,4],[14,1,14,4],[12,1,12,5],[8,1,8,4],[1,1,1,4],[6,1,6,4],[7,1,7,4],[3,3,3,4],[3,1,3,2]]}
[]
[null,"ACKNOWLEDGEMENTS AND CERTIFICATIONS"]
[]
[null,"Applicant:",null,{"$f":"IF('General Information'!C5=\"\",\"\",'General Information'!C5)","v":""}]
[]
[null,"General Application Certification"]
[null,"By checking below, Applicant hereby certifies under penalty of perjury that all representations made in this application are true and correct to the best of Applicant's knowledge, after a prudent and reasonable investigation of all relevant facts and circumstances, at the time of the application's submission."]
[null,"Applicant understands that if the above certification is untrue then, in addition to any remedies available at law or equity to the LACDA, this application may be rejected or the terms and conditions of any funding vehicle shall be modified by the LACDA, even after an award has been made."]
[null,"The representations made in this application shall remain true at all times from the date of this certification until any award is rendered and throughout the term of any loan or grant made to Applicant on account of this application, except that if any such representation should become materially false, misleading or incomplete, Applicant shall immediately notify the LACDA in writing and this application may be rejected or the terms and conditions of any grant or loan shall be modified by the LACDA, even after an award has been made."]
[null,null,"Applicant Acknowledgement and Certification"]
[]
[]
[]
[null,"Acknowledgement of Accessibility Requirements"]
[null,"Applicant understands the accessibility requirements for projects assisted by the LACDA and acknowledges that the development shall comply with all applicable requirements for access and design imposed by law, including, but not limited to, the 2010 ADA Standards, sections 11A and 11B of the California Building Code, Section 504 of the Rehabilitation Act, and the Fair Housing Act.  Applicant is responsible for ensuring the project architect incorporates all accessibility requirements into the project design."]
[null,null,"Applicant Acknowledgement and Certification"]

{"sheet":"Applicant Certification","index":6,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[[36,1,36,3],[31,2,31,3],[35,2,35,3],[32,2,32,3],[34,2,34,3],[28,2,28,3],[29,2,29,3],[23,2,23,3],[26,2,26,3],[22,2,22,3],[25,2,25,3],[19,2,19,3],[17,2,17,3],[20,2,20,3],[1,1,1,3],[6,2,6,3],[8,2,8,3],[3,1,3,3],[7,2,7,3],[11,2,11,3],[13,2,13,3],[16,2,16,3],[14,2,14,3],[10,2,10,3]]}
[]
[null,"Applicant Certification Statement"]
[]
[null,"Provide the following information as it relates to each entity of the applicant.  Provide separate forms for each entity, if necessary. Do not leave any question unanswered.  If not applicable, enter \"N/A\".  \n\nFor purposes of this Certification Statement, the term \"applicant\" refers to all persons or entities that are part of the applicant's team in relation to this RFP. The responses to the below questions shall include disclosures regarding jurisdictions outside of California. So if the applicant or any of its partners, principals, or affiliates are active outside of California or subject to the jurisdiction of parties outside of California, the responses below must include this information."]
[]
[null,null,"Applicant's Name:"]
[]
[null,1,"List any additional names or aliases, exercise of power of attorney, and/or fiduciary trust capacities that you are currently using or have used in the past.  If any, please explain."]
[]
[]
[null,2,"Has any funding approval or funding eligibility of the applicant ever been suspended, revoked, lapsed, and/or terminated for any reason? If yes, please explain."]
[]
[]
[null,3,"Has the applicant ever filed for bankruptcy? If yes, please explain and state the case number and whether the case was dismissed, discharged, or is current."]
[]
[]
[null,4,"Has the applicant ever defaulted on a financial obligation? If yes, please explain."]
[]
[]
[null,5,"Is there, or has there ever been, a settlement and/or judgment filed, or a case pending against the applicant?  If yes, please explain."]
[]
[]
[null,6,"Has the applicant had any professional licenses, revoked, suspended, surrendered, or terminated? If yes, please explain."]
[]
[]
[null,7,"Has the applicant defaulted on any contractual obligation, including but not limited to, loans, vendor agreements, and development agreements?  If yes, please explain."]
[]
[]
[null,8,"Does the applicant have any record of violation of affordability or regulatory agreements with any public agency?  If yes, please explain."]
[]
[]
[null,9,"Does the applicant employ current or past LACDA employees or their relatives? If yes, please explain."]
[]
[]
[null,10,"Does the applicant have any income and/or real property taxes or assessments that are past due? If yes, please explain."]
[]
[null,"NOTE: BY CHECKING BELOW, APPLICANT CERTIFIES ALL INFORMATION IS TRUE AND CORRECT.  ANY FALSE OR INCOMPLETE STATEMENTS MAY, IN THE LACDA'S SOLE DISCRETION, BE GROUNDS FOR DENIAL OR REVOCATION OF FUNDING AT ANY TIME PRIOR TO OR AFTER LOAN FUNDING."]
[]
[]
[null,null,"Applicant certifies information is true and correct"]

{"sheet":"Development Team","index":7,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,4,64,9],[56,4,56,9],[57,4,57,9],[58,4,58,9],[61,4,61,9],[62,4,62,9],[50,4,50,9],[51,4,51,9],[52,4,52,9],[55,4,55,9],[63,4,63,9],[43,4,43,9],[44,4,44,9],[45,4,45,9],[46,4,46,9],[49,4,49,9],[34,4,34,9],[37,4,37,9],[38,4,38,9],[39,4,39,9],[40,4,40,9],[27,4,27,9],[28,4,28,9],[31,4,31,9],[32,4,32,9],[33,4,33,9],[20,4,20,9],[21,4,21,9],[22,4,22,9],[25,4,25,9],[26,4,26,9],[13,4,13,9],[14,4,14,9],[15,4,15,9],[16,4,16,9],[19,4,19,9],[7,4,7,9],[8,4,8,9],[9,4,9,9],[2,1,2,9],[10,4,10,9]]}
[]
[null,"Development Team",null,null,null,null,null,null,null,""]
[null,"Enter \"TBD\" If Not Yet Known"]
[]
[null,"Development Team Members"]
[]
[null,null,"Managing General Partner (if applicable)"]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone:"]
[null,null,"Email:"]
[]
[null,null,"Co-General Partner (if applicable)"]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone:"]
[null,null,"Email:"]
[]
[null,null,"Lead Developer"]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone:"]
[null,null,"Email:"]
[]
[null,null,"Joint Developer"]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone:"]
[null,null,"Email:"]
[]
[null,null,"Lead Service Provider"]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone:"]
[null,null,"Email:"]
[]
[null,null,"Architect"]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone:"]
[null,null,"Email:"]
[]
[null,null,"Financial Consultant"]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone:"]
[null,null,"Email:"]
[]
[null,null,"Attorney"]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone:"]
[null,null,"Email:"]
[]
[null,null,"Property Management Agent"]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone:"]
[null,null,"Email:"]
[]
[null,null,"General Contractor"]
[null,null,"Name:"]
[null,null,"Address:"]
[null,null,"Phone:"]
[null,null,"Email:"]

{"sheet":"Development Timeline","index":8,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,1,2,9],[18,5,18,7],[24,5,24,7],[21,5,21,7],[30,5,30,7],[27,5,27,7]]}
[]
[null,"Development Timeline"]
[]
[]
[null,null,null,null,"Event ",null,null,null,"Date"]
[]
[null,null,null,null,"Site Control"]
[]
[null,null,null,null,"Entitlements "]
[]
[null,null,null,null,"CEQA Approval"]
[]
[null,null,null,null,"NEPA Approval "]
[]
[null,null,null,null,"Tax Credit Application "]
[]
[null,null,null,null,"Funding Commitments:"]
[]
[null,null,null,null,"Source:"]
[null,null,null,null,"Funding commitment"]
[]
[null,null,null,null,"Source:"]
[null,null,null,null,"Funding commitment"]
[]
[null,null,null,null,"Source:"]
[null,null,null,null,"Funding commitment"]
[]
[null,null,null,null,"Source:"]
[null,null,null,null,"Funding commitment"]
[]
[null,null,null,null,"Source:"]
[null,null,null,null,"Funding commitment"]
[]
[null,null,null,null,"Construction Start"]
[]
[null,null,null,null,"Construction Completion"]

{"sheet":"Predev Financing","index":9,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[33,4,33,6],[24,4,24,6],[25,4,25,6],[27,4,27,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[39,4,39,5],[38,4,38,6],[29,4,29,6],[32,4,32,6],[14,4,14,6],[23,4,23,6],[37,4,37,6],[30,4,30,5],[26,4,26,6],[21,4,21,5],[28,4,28,6],[34,4,34,6],[35,4,35,6],[36,4,36,6],[19,4,19,6],[20,4,20,6]]}
[]
[null,"Predevelopment Financing"]
[]
[null,null,"Lien Position","Name of Lender/Source","Term in Months","Interest Rate","Amount of Funds"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total Funds for Predevelopment",{"$f":"SUM(G5:G12)","v":0}]
[]
[null,"1.","Name of Lender/Source"]
[null,null,"Street Address"]
[null,null,"Contact Name"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Use (menu selection)",null,"(Select)"]
[]
[null,"2.","Name of Lender/Source"]
[null,null,"Street Address"]
[null,null,"Contact Name"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Use (menu selection)",null,"(Select)"]
[]
[null,"3.","Name of Lender/Source"]
[null,null,"Street Address"]
[null,null,"Contact Name"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Use (menu selection)",null,"(Select)"]

{"sheet":"Sources","index":10,"n_rows":57,"n_cols":17,"rows_kept":57,"cut":false,"hidden":false,"merged":[[18,10,18,11],[43,4,43,6],[53,4,53,6],[48,4,48,6],[38,4,38,6],[41,4,41,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[40,4,40,5],[2,1,2,8],[34,4,34,5],[35,4,35,5],[36,4,36,5],[39,4,39,5],[33,4,33,6],[18,5,18,6],[56,4,56,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[54,4,54,5],[55,4,55,5]]}
[]
[null,"Proposed Sources"]
[]
[]
[null,null,"CONSTRUCTION SOURCES"]
[null,null,"Lien Position","Name of Lender/Source","Term in Months","Interest Rate","Amount of Funds","Required Payment","Tax Exempt Amount","Residential Amount","Commercial Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total Tax Credit Equity"]
[null,null,null,null,null,"Total Funds for Construction",{"$f":"SUM(G7:G15)","v":0}]
[]
[]
[null,null,"PERMANENT SOURCES",null,null,"Interest Rate",null,null,null,null,"Repayment Terms"]
[null,null,"Lien Position","Name of Lender/Source","Term in Months","Interest Rate","Type","Amortizing Period (yrs)","Amount of Funds","Annual Debt Service","Type","Due in (yrs)","Required Residential Debt Service","Required Commercial Debt Service","Tax Exempt Amount","Residential Amount","Commercial Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total Permanent Financing",null,null,{"$f":"SUM(I21:I28)","v":0}]
[null,null,null,null,null,"Total Tax Credit Equity"]
[null,null,null,null,null,"Total Sources of Project Funds",null,null,{"$f":"SUM(I29:I30)","v":0}]
[]
[]
[null,"1.","Name of Lender/Source"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"2.","Name of Lender/Source"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"3.","Name of Lender/Source"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"4.","Name of Lender/Source"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"5.","Name of Lender/Source"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]

{"sheet":"Unit Mix & Funding ","index":11,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
["Unit Mix Chart"]
["Number \nof Bedrooms ","Income Limit \n(%AMI, Market, Mgr)","DR-MHP Assisted Units","Total Income Restricted Units (including DR-MHP units)","Non-Restricted Units","Total Units","Max. Gross Rent","Utility Allowance","Net Rent (gross - utility allw.)","Annual Net Rent"]
[null,null,null,null,null,null,0,0,{"$f":"Table3[[#This Row],[Max. Gross Rent]]-Table3[[#This Row],[Utility Allowance]]","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"Table3[[#This Row],[Max. Gross Rent]]-Table3[[#This Row],[Utility Allowance]]","v":0},{"$f":"Table3[[#This Row],[Net Rent (gross - utility allw.)]]*12","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"Table3[[#This Row],[Max. Gross Rent]]-Table3[[#This Row],[Utility Allowance]]","v":0},{"$f":"Table3[[#This Row],[Net Rent (gross - utility allw.)]]*12","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"Table3[[#This Row],[Max. Gross Rent]]-Table3[[#This Row],[Utility Allowance]]","v":0},{"$f":"Table3[[#This Row],[Net Rent (gross - utility allw.)]]*12","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"Table3[[#This Row],[Max. Gross Rent]]-Table3[[#This Row],[Utility Allowance]]","v":0},{"$f":"Table3[[#This Row],[Net Rent (gross - utility allw.)]]*12","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"Table3[[#This Row],[Max. Gross Rent]]-Table3[[#This Row],[Utility Allowance]]","v":0},{"$f":"Table3[[#This Row],[Net Rent (gross - utility allw.)]]*12","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"Table3[[#This Row],[Max. Gross Rent]]-Table3[[#This Row],[Utility Allowance]]","v":0},{"$f":"Table3[[#This Row],[Net Rent (gross - utility allw.)]]*12","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"Table3[[#This Row],[Max. Gross Rent]]-Table3[[#This Row],[Utility Allowance]]","v":0},{"$f":"Table3[[#This Row],[Net Rent (gross - utility allw.)]]*12","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"Table3[[#This Row],[Max. Gross Rent]]-Table3[[#This Row],[Utility Allowance]]","v":0},{"$f":"Table3[[#This Row],[Net Rent (gross - utility allw.)]]*12","v":0}]
["TOTAL",null,{"$f":"SUM(C4:C12)","v":0},{"$f":"SUM(D4:D12)","v":0},0,0,null,null,null,{"$f":"SUM(J4:J12)","v":0}]
[]
[]
["Maximum Funding Amount (formula based)"]
["Number \nof Bedrooms ","CDBG-DR Funding Limit/Unit  ","Number of DR-MHP Assisted Units","Maximum Funding Amount"]
[{"$f":"A28","v":"0 "},{"$f":"D28","v":153314},{"$f":"SUMIF('Unit Mix & Funding '!$A$4:$A$12, \"0\",'Unit Mix & Funding '!$C$4:$C$12)","v":0},{"$f":"C18*B18","v":0}]
[{"$f":"A29","v":"1 "},{"$f":"D29","v":175752},{"$f":"SUMIF('Unit Mix & Funding '!$A$4:$A$12, \"1\",'Unit Mix & Funding '!$C$4:$C$12)","v":0},{"$f":"C19*B19","v":0}]
["2 ",213718,{"$f":"SUMIF('Unit Mix & Funding '!$A$4:$A$12, \"2\",'Unit Mix & Funding '!$C$4:$C$12)","v":0},{"$f":"C20*B20","v":0}]
["3 ",276482,{"$f":"SUMIF('Unit Mix & Funding '!$A$4:$A$12, \"3\",'Unit Mix & Funding '!$C$4:$C$12)","v":0},{"$f":"C21*B21","v":0}]
["4+ ",303490,{"$f":"SUMIF('Unit Mix & Funding '!$A$4:$A$12, \">3\",'Unit Mix & Funding '!$C$4:$C$12)","v":0},{"$f":"C22*B22","v":0}]
["Total Funding Cap based on Unit Mix",null,null,{"$f":"SUM(D18:D22)","v":0}]
[]
[]
["Program Per Unit Subsidy Limit "]
["Bedrooms  ","HOME Funding Limit/Unit – \nNational (June 2020) ","HOME Funding Limit/Unit – California (Effective June 2020)  ","CDBG-DR Funding Limit/Unit  "]
["0 ","$63,881 ",153314,153314]
["1 ",73230,175752,175752]
["2 ","$89,049 ",213718,213718]
["3 ",115201,276482,276482]
["4+ ",126454,303490,303490]

{"sheet":"Operating Subsidies","index":12,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Operating Subsidies"]
[]
[]
[null,null,"Subsidy Source","Subsidy Program (PBV, PBVASH, etc.)","Number of Subsidized Units","Total Annual Subsidy","Contract Term (Years)","Total Contract Subsidy"]
[null,null,null,null,null,null,null,{"$f":"SUM(F6*G6)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(F7*G7)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,"Total",{"$f":"SUM(E6:E14)","v":0},{"$f":"SUM(F6:F14)","v":0},null,{"$f":"SUM(H6:H14)","v":0}]
[]
[null,null,"Calculation of Rent Subsidy Premium "]
[null,null,"# of Bedrooms","# of Units","Target AMI","Net Monthly Rent \n(Net of Utility Allowance)","Net Monthly Subsidy","Difference","Total Monthly Subsidy Premium","Annual Subsidy Premium"]
[null,null,null,null,null,null,null,{"$f":"+G19-F19","v":0},{"$f":"+H19*D19","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"+H20*D20","v":0},{"$f":"+H20*D20*12","v":0}]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,{"$f":"SUM(D19:D33)","v":0},null,null,null,null,{"$f":"SUM(I19:I33)","v":0},{"$f":"SUM(J19:J33)","v":0}]

{"sheet":"Development Budget","index":13,"n_rows":115,"n_cols":8,"rows_kept":115,"cut":false,"hidden":false,"merged":[[3,6,4,6],[3,7,4,7]]}
["Development Budget"]
[]
[null,null,null,null,null,null,"Eligible Basis"]
[null,null,"Total","Residential","Non-Residential",null,"New Construction / Rehab","Acquisition"]
[null,null,null,{"$f":"100%-E5","v":1},0]
["Acquisition"]
[null,"Total Land Cost",0,{"$f":"C7*D$5","v":0},{"$f":"C7-D7","v":0}]
[null,"Existing Improvements Value",null,{"$f":"C8*D$5","v":0},{"$f":"C8-D8","v":0}]
[null,"Legal / Title & Recording",null,{"$f":"C9*D$5","v":0},{"$f":"C9-D9","v":0}]
[null,"Total Acquisition Costs",0,{"$f":"SUM(D7:D9)","v":0},{"$f":"SUM(E7:E9)","v":0},null,{"$f":"SUM(G7:G9)","v":0},{"$f":"SUM(H7:H9)","v":0}]
["Construction"]
[null,"Demolition",null,{"$f":"C12*D$5","v":0},{"$f":"C12-D12","v":0}]
[null,"Toxic Abatement",null,0,0]
[null,"Offsite Improvements",null,0,{"$f":"C14-D14","v":0}]
[null,"On-site Improvements attributable \n     to unusual conditions",null,0,{"$f":"C15-D15","v":0}]
[null,"Site Work",null,0,{"$f":"C16-D16","v":0}]
[null,"Structures",null,0,0]
[null,"Parking ",null,0,{"$f":"C18-D18","v":0}]
[null,"General Requirements",null,0,0]
[null,"Contractor Overhead",null,0,0]
[null,"Contractor Profit",null,0,0]
[null,"General Liability Insurance",null,0,0]
[null,"Prevailing Wage ",null,0,0]
[null,"Total Construction Costs",{"$f":"SUM(C12:C23)","v":0},{"$f":"SUM(D12:D23)","v":0},{"$f":"SUM(E12:E23)","v":0},null,{"$f":"SUM(G12:G23)","v":0},{"$f":"SUM(H12:H23)","v":0}]
["Architectural Fees"]
[null,"Design",null,{"$f":"C26*D$5","v":0},{"$f":"C26-D26","v":0}]
[null,"Supervision",null,{"$f":"C27*D$5","v":0},{"$f":"C27-D27","v":0}]
[null,"Total Architectural Costs",{"$f":"SUM(C26:C27)","v":0},{"$f":"SUM(D26:D27)","v":0},{"$f":"SUM(E26:E27)","v":0},null,{"$f":"SUM(G26:G27)","v":0},{"$f":"SUM(H26:H27)","v":0}]
["Survey & Engineering"]
[null,"Total Survey & Engineering",null,{"$f":"C30*D$5","v":0},{"$f":"C30-D30","v":0},null,{"$f":"D30","v":0},0]
["Construction Interest & Fees"]
[null,"Construction Loan Interest",null,{"$f":"C32*D$5","v":0},{"$f":"C32-D32","v":0}]
[null,"Origination Fee",null,{"$f":"C33*D$5","v":0},0]
[null,"Costs of Bond Issuance"]
[null,"a)  Underwriter Fee",null,{"$f":"C35*D$5","v":0},0]
[null,"b)  Underwriter Counsel",null,0,0]
[null,"c)  Issuer Fee",null,0,0]
[null,"d)  Issuer Financial Advisor",null,0,0]
[null,"e)  Bond Counsel",null,0,0]
[null,"f)  Lender Origination/LOC Fee",null,0,0]
[null,"g)  Lender Counsel",null,0,0]
[null,"h)  Rating",null,0,0]
[null,"i)  Trustee Fee",null,0,0]
[null,"j)  Trustee Counsel",null,0,0]
[null,"k)  Printing",null,0,0]
[null,"l)  CDLAC Fees",null,0,0]
[null,"m)  COI Contingency",null,0,0]
[null,"Payment & Performance Bond",null,0,0]
[null,"Property Taxes",null,0,0]
[null,"Insurance",null,0,0]
[null,"Title and Recording",null,{"$f":"C51*D$5","v":0},{"$f":"C51-D51","v":0}]
[null,"Other: (specify)",null,0,0]
[null,"Other: (specify)",null,0,0]
[null,"Total Construction Financing Costs",{"$f":"SUM(C32:C53)","v":0},{"$f":"SUM(D32:D53)","v":0},{"$f":"SUM(E32:E53)","v":0},null,{"$f":"SUM(G32:G53)","v":0},{"$f":"SUM(H32:H53)","v":0}]
["Permanent Financing"]
[null,"Loan Origination Fee",null,{"$f":"C56*D$5","v":0},{"$f":"C56-D56","v":0}]
[null,"Credit Enhance. & App. Fee",null,{"$f":"C57*D$5","v":0},{"$f":"C57-D57","v":0}]
[null,"Title and Recording",null,{"$f":"C58*D$5","v":0},{"$f":"C58-D58","v":0}]
[null,"Other: (specify)",null,{"$f":"C59*D$5","v":0},{"$f":"C59-D59","v":0}]
[null,"Other: (specify)",null,{"$f":"C60*D$5","v":0},{"$f":"C60-D60","v":0}]
[null,"Total Permanent Financing Costs",{"$f":"SUM(C56:C60)","v":0},{"$f":"SUM(D56:D60)","v":0},{"$f":"SUM(E56:E60)","v":0},null,{"$f":"SUM(G56:G60)","v":0},{"$f":"SUM(H56:H60)","v":0}]
["Legal Fees"]
[null,"Lender Legal Pd. by Applicant",null,{"$f":"C63*D$5","v":0},{"$f":"C63-D63","v":0}]
[null,"Borrower - Transaction",null,{"$f":"C64*D$5","v":0},{"$f":"C64-D64","v":0}]
[null,"Borrower - Syndication",null,{"$f":"C65*D$5","v":0},{"$f":"C65-D65","v":0}]
[null,"Other: (specify)",null,{"$f":"C66*D$5","v":0},{"$f":"C66-D66","v":0}]
[null,"Total Attorney Costs",{"$f":"SUM(C63:C66)","v":0},{"$f":"SUM(D63:D66)","v":0},{"$f":"SUM(E63:E66)","v":0},null,{"$f":"SUM(G63:G66)","v":0},{"$f":"SUM(H63:H66)","v":0}]
["Reserves"]
[null,"Operating Reserves",null,{"$f":"C69*D$5","v":0},{"$f":"C69-D69","v":0}]
[null,"Replacement Reserve, Renewable Energy Equip. ",null,{"$f":"C70*D$5","v":0},{"$f":"C70-D70","v":0}]
[null,"Other: (specify)",null,{"$f":"C71*D$5","v":0},{"$f":"C71-D71","v":0}]
[null,"Total Reserve Costs",{"$f":"SUM(C69:C71)","v":0},{"$f":"SUM(D69:D71)","v":0},{"$f":"SUM(E69:E71)","v":0},null,{"$f":"SUM(G69:G71)","v":0},{"$f":"SUM(H69:H71)","v":0}]
["Appraisal"]
[null,"Total Appraisal Costs",null,{"$f":"C74*D$5","v":0},{"$f":"C74-D74","v":0},null,{"$f":"D74","v":0},0]
["Contingency"]
[null,"Hard Cost Contingency",null,{"$f":"C76*D$5","v":0},{"$f":"C76-D76","v":0}]
[null,"Soft Cost Contingency",null,{"$f":"C77*D$5","v":0},{"$f":"C77-D77","v":0}]
[null,"Total Contingency Costs",{"$f":"SUM(C76:C77)","v":0},{"$f":"SUM(D76:D77)","v":0},{"$f":"SUM(E76:E77)","v":0},null,{"$f":"SUM(G76:G77)","v":0},{"$f":"SUM(H76:H77)","v":0}]
["Other"]
[null,"TCAC App/Alloc/Monitor Fees",null,{"$f":"C80*D$5","v":0},{"$f":"C80-D80","v":0}]
[null,"Environmental Audit",null,0,0]
[null,"Local Development Impact Fees",null,0,0]
[null,"Permit Processing Fees",null,0,0]
[null,"School Fees",null,{"$f":"C84*D$5","v":0},{"$f":"C84-D84","v":0}]
[null,"Marketing",null,0,0]
[null,"Leasing (Lease-Up Expense)",null,0,0]
[null,"Leasing (Lease-Up) Fee",null,0,0]
[null,"Relocation Expenses",null,0,0]
[null,"Furnishings (common areas)",null,0,0]
[null,"Unit Furnishings (homeless units)",null,{"$f":"C90*D$5","v":0},{"$f":"C90-D90","v":0}]
[null,"Accounting/Audit",null,0,0]
[null,"Acq/Predev Loan Fees & Expenses",null,0,0]
[null,"Acq/Predev Loan Interest",null,0,0]
[null,"Construction Management",null,0,0]
[null,"Deputy Inspection",null,0,0]
[null,"LACDA - Reservation Fee",null,0,0]
[null,"Holding Costs",null,0,0]
[null,"Market Study",null,0,0]
[null,"Security",null,0,0]
[null,"Green Building Certification",null,0,0]
[null,"Consultant",null,0,{"$f":"C101-D101","v":0}]
[null,"Other: (specify)",null,0,0]
[null,"Total Other Costs",{"$f":"SUM(C80:C102)","v":0},{"$f":"SUM(D80:D102)","v":0},{"$f":"SUM(E80:E102)","v":0},null,{"$f":"SUM(G80:G102)","v":0},{"$f":"SUM(H80:H102)","v":0}]
[null,"Subtotals",{"$f":"SUM(C10,C24,C28,C30,C54,C61,C67,C72,C74,C78,C103)","v":0},{"$f":"SUM(D10,D24,D28,D30,D54,D61,D67,D72,D74,D78,D103)","v":0},{"$f":"SUM(E10,E24,E28,E30,E54,E61,E67,E72,E74,E78,E103)","v":0},null,{"$f":"SUM(G10,G24,G28,G30,G54,G61,G67,G72,G74,G78,G103)","v":0},{"$f":"SUM(H10,H24,H28,H30,H54,H61,H67,H72,H74,H78,H103)","v":0}]
["Developer Costs"]
[null,"Developer Fee",null,{"$f":"C106*D$5","v":0},{"$f":"C106-D106","v":0}]
[null,"Consultant/Processing Agent",null,{"$f":"C107*D$5","v":0},0]
[null,"Project Administration",null,0,0]
[null,"Broker fees paid by owner",null,0,0]
[null,"Other: (specify)",null,0,0]
[null,"Total Developer Costs",{"$f":"SUM(C106:C110)","v":0},{"$f":"SUM(D106:D110)","v":0},{"$f":"SUM(E106:E110)","v":0},null,{"$f":"SUM(G106:G110)","v":0},{"$f":"SUM(H106:H110)","v":0}]
[]
[null,"TOTAL",{"$f":"SUM(C104,C111)","v":0},{"$f":"SUM(D104,D111)","v":0},{"$f":"SUM(E104,E111)","v":0}]
[null,null,null,null,null,"Bridge Loan Expense During Construction",0,0]
[null,null,null,null,null,"TOTAL ELIGIBLE BASIS",{"$f":"SUM(G111:G114,G104)","v":0},{"$f":"SUM(H111:H114,H104)","v":0}]

{"sheet":"Operating Budget","index":14,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":false,"merged":[[2,1,3,1],[58,0,58,2],[57,0,57,2],[56,0,56,2]]}
[]
["Operating Budget"]
[null,"Residential Component"]
[]
[null,"Proposed","Per Unit","Per Unit"]
["Administrative Expenses","Budget","Per Month","Per Year"]
["   Office Salaries",null,{"$f":"IF(OR(B7<=0),\"\",B7/'Unit Mix & Funding '!F$13/\"12\")","v":""},{"$f":"IF(OR(B7=\"\"),\"\",C7*12)","v":""}]
["   Emp Benefits & Insurance",null,{"$f":"IF(OR(B8=\"\"),\"\",B8/'Unit Mix & Funding '!F$13/\"12\")","v":""},{"$f":"IF(OR(B8=\"\"),\"\",C8*12)","v":""}]
["   On-site Manager",null,{"$f":"IF(OR(B9=\"\"),\"\",B9/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Maintenance Personnel",null,{"$f":"IF(OR(B10=\"\"),\"\",B10/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Management Fee",null,{"$f":"IF(OR(B11=\"\"),\"\",B11/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Office Supplies",null,{"$f":"IF(OR(B12=\"\"),\"\",B12/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Advertising",null,{"$f":"IF(OR(B13=\"\"),\"\",B13/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Legal",null,{"$f":"IF(OR(B14=\"\"),\"\",B14/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Audit expense",null,{"$f":"IF(OR(B15=\"\"),\"\",B15/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Security",null,{"$f":"IF(OR(B16=\"\"),\"\",B16/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Communication",null,{"$f":"IF(OR(B17=\"\"),\"\",B17/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Miscellaneous Admin",null,{"$f":"IF(OR(B18=\"\"),\"\",B18/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["Total Administrative Expenses",{"$f":"SUM(B7:B18)","v":0},{"$f":"IF(OR(B19<=0),\"\",B19/'Unit Mix & Funding '!F$13/\"12\")","v":""},{"$f":"IF(OR(B19<=0),\"\",C19*12)","v":""}]
[]
["Maintenance Expenses"]
["   Maintenance supplies",null,{"$f":"IF(OR(B22=\"\"),\"\",B22/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Pest Control",null,{"$f":"IF(OR(B23=\"\"),\"\",B23/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Repairs Contract",null,{"$f":"IF(OR(B24=\"\"),\"\",B24/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   HVAC repairs & maintenance",null,{"$f":"IF(OR(B25=\"\"),\"\",B25/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Landscape Contract",null,{"$f":"IF(OR(B26=\"\"),\"\",B26/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Interior/exterior painting",null,{"$f":"IF(OR(B27=\"\"),\"\",B27/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Elevator maintenance",null,{"$f":"IF(OR(B28=\"\"),\"\",B28/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Interior cleaning",null,{"$f":"IF(OR(B29=\"\"),\"\",B29/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Misc. Maintenance Expense",null,{"$f":"IF(OR(B30=\"\"),\"\",B30/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Extra. Maintenance Expense *",null,{"$f":"IF(OR(B31=\"\"),\"\",B31/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["Total Maintenance Expenses",{"$f":"SUM(B22:B31)","v":0},{"$f":"IF(OR(B32<=0),\"\",B32/'Unit Mix & Funding '!F$13/\"12\")","v":""},{"$f":"IF(OR(B32<=0),\"\",C32*12)","v":""}]
[]
["Utilities Expenses"]
["   Trash removal",null,{"$f":"IF(OR(B35=\"\"),\"\",B35/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Electricity",null,{"$f":"IF(OR(B36=\"\"),\"\",B36/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Water/sewer",null,{"$f":"IF(OR(B37=\"\"),\"\",B37/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Gas",null,{"$f":"IF(OR(B38=\"\"),\"\",B38/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["Total Utilities Expense",{"$f":"SUM(B35:B38)","v":0},{"$f":"IF(OR(B39<=0),\"\",B39/'Unit Mix & Funding '!F$13/\"12\")","v":""},{"$f":"IF(OR(B39<=0),\"\",C39*12)","v":""}]
[]
["Tax & Insurance Expenses"]
["   Real estate taxes & assessments",null,{"$f":"IF(OR(B42=\"\"),\"\",B42/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Licenses & Fees",null,{"$f":"IF(OR(B43=\"\"),\"\",B43/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Property & liability insurance",null,{"$f":"IF(OR(B44=\"\"),\"\",B44/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["Total Tax & Insurance",{"$f":"SUM(B42:B44)","v":0},{"$f":"IF(OR(B45<=0),\"\",B45/'Unit Mix & Funding '!F$13/\"12\")","v":""},{"$f":"IF(OR(B45<=0),\"\",C45*12)","v":""}]
[]
["TOTAL OPERATING EXPENSES",{"$f":"SUM(B45,B39,B32,B19)","v":0},{"$f":"IF(OR(B47<=0),\"\",B47/'Unit Mix & Funding '!F$13/\"12\")","v":""},{"$f":"IF(OR(B47<=0),\"\",C47*12)","v":""}]
["Project Reserves"]
["   Operating Reserves",null,{"$f":"IF(OR(B49=\"\"),\"\",B49/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Replacement Reserve",null,{"$f":"IF(OR(B50=\"\"),\"\",B50/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Transition Reserve",null,{"$f":"IF(OR(B51=\"\"),\"\",B51/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
["   Social Services",null,{"$f":"IF(OR(B52=\"\"),\"\",B52/'Unit Mix & Funding '!F$13/\"12\")","v":""},""]
[]
["TOTAL EXPENSES",{"$f":"SUM(B49:B52,B47)","v":0},{"$f":"IF(OR(B54<=0),\"\",B54/'Unit Mix & Funding '!F$13/\"12\")","v":""},{"$f":"IF(OR(B54<=0),\"\",C54*12)","v":""}]
[]
[]
[]
["* Funds for this line item will be taken from the replacement reserves."]

{"sheet":"20-Year Cash Flow","index":15,"n_rows":61,"n_cols":22,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,0,1,8]]}
["20-Year Cash Flow"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[]
["Gross Potential Income - Residential",2.5000000000000001E-2,{"$f":"'Unit Mix & Funding '!J13","v":0},{"$f":"C5*(1+$B$5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q5*(1+$B$5)","v":0},{"$f":"R5*(1+$B$5)","v":0},{"$f":"S5*(1+$B$5)","v":0},{"$f":"T5*(1+$B$5)","v":0},{"$f":"U5*(1+$B$5)","v":0}]
["Gross Potential Income - Rent Subsidy",2.5000000000000001E-2,{"$f":"'Operating Subsidies'!F15","v":0},{"$f":"C6*(1+$B$6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q6*(1+$B$6)","v":0},{"$f":"R6*(1+$B$6)","v":0},{"$f":"S6*(1+$B$6)","v":0},{"$f":"T6*(1+$B$6)","v":0},{"$f":"U6*(1+$B$6)","v":0}]
["Project-funded Capitalized Subsidy Reserve"]
[]
["Miscellaneous Income",2.5000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Vacancy Loss - Residential*",0.1,{"$f":"-(C5)*$B11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Vacancy Loss - Operating Subsidy",0.1,{"$f":"-C6*$B12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Vacancy Loss - Miscellaneous Income",0.05,{"$f":"-C9*$B13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["EFFECTIVE GROSS INCOME",null,{"$f":"SUM(C5:C13)","v":0},{"$f":"SUM(D5:D12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Operating Expenses - Residential",3.5000000000000003E-2,{"$f":"-('Operating Budget'!B47-'Operating Budget'!B42)","v":0},{"$f":"C17*(1+$B17)","v":0},{"$f":"D17*(1+$B17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q17*(1+$B17)","v":0},{"$f":"R17*(1+$B17)","v":0},{"$f":"S17*(1+$B17)","v":0},{"$f":"T17*(1+$B17)","v":0},{"$f":"U17*(1+$B17)","v":0}]
["Real Estate Taxes & Assessments - Residential",0.02,{"$f":"-'Operating Budget'!B42","v":0},{"$f":"C18*(1+$B18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Supportive Services",3.5000000000000003E-2,{"$f":"-'Operating Budget'!B52","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Replacement Reserve - Residential",0,{"$f":"-'Operating Budget'!B50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cumulative Replacement Reserve - Residential",null,{"$f":"-C20","v":0},{"$f":"IF(C21-D20>0,C21-D20,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Q21-R20>0,Q21-R20,0)","v":0},{"$f":"IF(R21-S20>0,R21-S20,0)","v":0},{"$f":"IF(S21-T20>0,S21-T20,0)","v":0},{"$f":"IF(T21-U20>0,T21-U20,0)","v":0},{"$f":"IF(U21-V20>0,U21-V20,0)","v":0}]
["Operating Reserve",0,{"$f":"-'Operating Budget'!B49","v":0},{"$f":"C22*(1+$B22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q22*(1+$B22)","v":0},{"$f":"R22*(1+$B22)","v":0},{"$f":"S22*(1+$B22)","v":0},{"$f":"T22*(1+$B22)","v":0},{"$f":"U22*(1+$B22)","v":0}]
["Cumulative Operating Reserve",null,{"$f":"-C22","v":0},{"$f":"IF(C23-D22>0,C23-D22,0)","v":0},{"$f":"IF(D23-E22>0,D23-E22,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Q23-R22>0,Q23-R22,0)","v":0},{"$f":"IF(R23-S22>0,R23-S22,0)","v":0},{"$f":"IF(S23-T22>0,S23-T22,0)","v":0},{"$f":"IF(T23-U22>0,T23-U22,0)","v":0},{"$f":"IF(U23-V22>0,U23-V22,0)","v":0}]
["Transition Reserve",0,{"$f":"-'Operating Budget'!B51","v":0},{"$f":"C24*(1+$B24)","v":0},{"$f":"D24*(1+$B24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q24*(1+$B24)","v":0},{"$f":"R24*(1+$B24)","v":0},{"$f":"S24*(1+$B24)","v":0},{"$f":"T24*(1+$B24)","v":0},{"$f":"U24*(1+$B24)","v":0}]
["Cumulative Transition Reserve",null,{"$f":"-C24","v":0},{"$f":"IF(C25-D24>0,C25-D24,0)","v":0},{"$f":"IF(D25-E24>0,D25-E24,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Q25-R24>0,Q25-R24,0)","v":0},{"$f":"IF(R25-S24>0,R25-S24,0)","v":0},{"$f":"IF(S25-T24>0,S25-T24,0)","v":0},{"$f":"IF(T25-U24>0,T25-U24,0)","v":0},{"$f":"IF(U25-V24>0,U25-V24,0)","v":0}]
["TOTAL OPERATING EXPENSES & RESERVES",null,{"$f":"SUM(C17:C20,C22,C24)","v":0},{"$f":"SUM(D17:D20,D22,D24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R17:R20,R22,R24)","v":0},0,0,0,0]
[]
["NET OPERATING INCOME",null,{"$f":"SUM(C15,C26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R15,R26)","v":0},0,0,0,0]
[]
["Residential Component",null,{"$f":"SUM(C5:C6,C8:C12,C13)+SUM(C17,C18,C19,C20,C22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["DEBT SERVICE  "]
["LACDA Monitoring/Asset Management Pmt (55 yrs)",0,0,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7149,-7148,-7147,-7146,-7145]
[{"$f":"IF(Sources!J21<>0,Sources!D21,\"\")","v":""},null,{"$f":"IF(Sources!J21<>0,-Sources!J21,\"\")","v":""},{"$f":"$C$33","v":""},{"$f":"$C$33","v":""},"","","","","","","","","","","","","","","","",""]
[{"$f":"IF(Sources!J22<>0,Sources!D22,\"\")","v":""},null,{"$f":"IF(Sources!J22<>0,-Sources!J22,\"\")","v":""},{"$f":"$C$34","v":""},{"$f":"$C$34","v":""},"","","","","","","","","","","","","","","","",""]
[{"$f":"IF(Sources!J23<>0,Sources!D23,\"\")","v":""},null,{"$f":"IF(Sources!J23<>0,-Sources!J23,\"\")","v":""},{"$f":"$C$35","v":""},{"$f":"$C$35","v":""},"","","","","","","","","","","","","","","","",""]
["ANNUAL DEBT SERVICE RESIDENTIAL",null,{"$f":"SUM(C32:C35)","v":0},{"$f":"SUM(D32:D35)","v":-7150},-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,{"$f":"SUM(R32:R35)","v":-7149},-7148,-7147,-7146,-7145]
["Debt Service Coverage Ratio (Residential NOI)",null,{"$f":"IF(SUM(C36)=0,\"NA\",C30/SUM(C36))","v":"NA"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["NET CASH FLOW",null,{"$f":"C28+C36","v":0},-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7150,-7149,-7148,-7147,-7146,-7145]
[]
["Potential Partnership Management Fee",{"$f":"+B41","v":3.5000000000000003E-2}]
["Partnership Management Fee",3.5000000000000003E-2,{"$f":"-IF(C38>0,MIN(C38,C40))","v":0},{"$f":"IF(D38>0,IF(D38>D40,-D40,-D38),0)","v":0},{"$f":"IF(E38>0,IF(E38>E40,-E40,-E38),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(R38>0,IF(R38>R40,-R40,-R38),0)","v":0},0,0,0,0]
["CASH FLOW after Partnership Management Fee",null,{"$f":"IF(C41+C38>0,C41+C38,0)","v":0},{"$f":"IF(D41+D38>0,D41+D38,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(R41+R38>0,R41+R38,0)","v":0},0,0,0,0]
[]
["Deferred Developer Fee ",null,{"$f":"-(IF(C42>0,MIN(B45,C42),0))","v":0},{"$f":"-(IF(D42>0,MIN(C45,D42),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-(IF(R42>0,MIN(Q45,R42),0))","v":0},{"$f":"-(IF(S42>0,MIN(R45,S42),0))","v":0},{"$f":"-(IF(T42>0,MIN(S45,T42),0))","v":0},{"$f":"-(IF(U42>0,MIN(T45,U42),0))","v":0},{"$f":"-(IF(V42>0,MIN(U45,V42),0))","v":0}]
["Deferred Developer Fee Balance",null,{"$f":"B45+C44","v":0},{"$f":"C45+D44","v":0},0,{"$f":"E45+F44","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q45+R44","v":0},{"$f":"R45+S44","v":0},{"$f":"S45+T44","v":0},{"$f":"T45+U44","v":0},{"$f":"U45+V44","v":0}]
["CASH FLOW after Def Developer Fee Pmt",null,{"$f":"C42+C44","v":0},{"$f":"D42+D44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R42+R44","v":0},0,0,0,0]
[]
["RESIDUAL RECEIPTS"]
["Borrower",0.5,{"$f":"$B$49*C46","v":0},{"$f":"$B$49*D46","v":0},0,{"$f":"$B$49*F46","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"$B$49*Q46","v":0},{"$f":"$B$49*R46","v":0},0,0,0,0]
["LACDA",0.5,{"$f":"$B$50*C46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$B$50*Q46","v":0},{"$f":"$B$50*R46","v":0},0,0,0,0]
["[other Residual Receipt lender]",0,{"$f":"$B$51*C46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$B$51*Q46","v":0},{"$f":"$B$51*R46","v":0},0,0,0,0]
["[other Residual Receipt lender]",0,{"$f":"$B$52*C46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$B$52*Q46","v":0},{"$f":"$B$52*R46","v":0},0,0,0,0]
[]
[]
["PROJECT-FUNDED CAPITALIZED SUBSIDY RESERVE**"]
["Starting Reserve Balance",null,0,{"$f":"+C59","v":0},{"$f":"+D59","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Q59","v":0},{"$f":"+R59","v":0},{"$f":"+S59","v":0},{"$f":"+T59","v":0},{"$f":"+U59","v":0}]
["Annual Interest on Reserve",7.4999999999999997E-3,null,{"$f":"+C56*$B57","v":0},{"$f":"+D56*$B57","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Q56*$B57","v":0},{"$f":"+R56*$B57","v":0},{"$f":"+S56*$B57","v":0},{"$f":"+T56*$B57","v":0},{"$f":"+U56*$B57","v":0}]
["Annual Reserve Contribution",null,{"$f":"-C7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Ending Reserve Balance",null,{"$f":"SUM(C56:C58)","v":0},{"$f":"SUM(D56:D58)","v":0},{"$f":"SUM(E56:E58)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R56:R58)","v":0},0,0,0,0]
[]
["* Must be 10% for SN units, or blended rate for mixed populations."]

{"sheet":"H.2 Service Delivery - HIDDEN","index":16,"n_rows":107,"n_cols":13,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Mentally Ill",{"$f":"IF(OR(#REF!=B2,#REF!=B2,#REF!=B2,#REF!=B2),1,\"\")","v":{"$error":"#REF!"}},"Code"]
[null,"HIV / AIDS",{"$f":"IF(OR(#REF!=B3,#REF!=B3,#REF!=B3,#REF!=B3),1,\"\")","v":{"$error":"#REF!"}},"Application",0]
[null,"Developmentally Disabled",{"$f":"IF(OR(#REF!=B4,#REF!=B4,#REF!=B4,#REF!=B4),1,\"\")","v":{"$error":"#REF!"}},"Loan Close",1]
[null,"Transition Age Youth & Homeless Youth",{"$f":"IF(OR(#REF!=B5,#REF!=B5,#REF!=B5,#REF!=B5),1,\"\")","v":{"$error":"#REF!"}},"Loan Close, if applicable",2]
[null,"Frequent Users of DHS/DMH Services",{"$f":"IF(OR(#REF!=B6,#REF!=B6,#REF!=B6,#REF!=B6),1,\"\")","v":{"$error":"#REF!"}},"Not Applicable",3]
[null,"Homeless Households",{"$f":"IF(OR(#REF!=B7,#REF!=B7,#REF!=B7,#REF!=B7),1,\"\")","v":{"$error":"#REF!"}}]
[null,"Chronically Homeless",{"$f":"IF(OR(#REF!=B8,#REF!=B8,#REF!=B8,#REF!=B8),1,\"\")","v":{"$error":"#REF!"}}]
[null,"Homeless Veterans",{"$f":"IF(OR(#REF!=B9,#REF!=B9,#REF!=B9,#REF!=B9),1,\"\")","v":{"$error":"#REF!"}}]
[null,"Homeless Seniors",{"$f":"IF(OR(#REF!=B10,#REF!=B10,#REF!=B10,#REF!=B10),1,\"\")","v":{"$error":"#REF!"}}]
[null,"Mixed Population",{"$f":"IF(OR(#REF!=B11,#REF!=B11,#REF!=B11,#REF!=B11),1,\"\")","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Mentally Ill","HIV / AIDS","Developmentally Disabled","Transition Age Youth","Frequent Users of DHS/DMH Services","Homeless Households","Chronically Homeless","Homeless Veterans","Homeless Seniors","Mixed Population"]
[null,"Green Education",{"$f":"IF($C$2=1,C63,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$3=1,D63,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$4=1,E63,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$5=1,F63,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$6=1,G63,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$7=1,H63,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$8=1,I63,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$9=1,J63,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$10=1,K63,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$11=1,L63,\"\")","v":{"$error":"#REF!"}}]
[null,"Individualized Service Plans",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Case Management",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Mental Health Care",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Substance Use Services",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Education",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Employment & Training",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Housing Outplacement",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Life Skills",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Physical Health Care",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Benefits Assistance",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Representative Payee",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Legal Assistance",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Peer Advocacy",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Social Activities/Recreational",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Child Care",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Medication Management",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Attendant Care",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Adult Day Care",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"End of Life Counseling",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Info & Referral",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[null,null,"Mentally Ill","HIV / AIDS","Developmentally Disabled","Transition Age Youth","Frequent Users of DHS/DMH Services","Homeless Households","Chronically Homeless","Homeless Veterans","Homeless Seniors","Mixed Population","CALCULATION\nMINIMUM"]
[null,"Green Education",{"$f":"IF($C$2=1,C87,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$3=1,D87,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$4=1,E87,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$5=1,F87,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$6=1,G87,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$7=1,H87,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$8=1,I87,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$9=1,J87,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$10=1,K87,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$11=1,L87,\"\")","v":{"$error":"#REF!"}},{"$f":"MIN(C39:L39)","v":{"$error":"#REF!"}}]
[null,"Individualized Service Plans",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Case Management",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Mental Health Care",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Substance Use Services",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Education",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Employment & Training",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Housing Outplacement",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Life Skills",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Physical Health Care",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Benefits Assistance",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Representative Payee",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Legal Assistance",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Peer Advocacy",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Social Activities/Recreational",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Child Care",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Medication Management",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Attendant Care",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Adult Day Care",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"End of Life Counseling",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Info & Referral",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[null,null,"Mentally Ill","HIV / AIDS","Developmentally Disabled","Transition Age Youth","Frequent Users of DHS/DMH Services","Homeless Households","Chronically Homeless","Homeless Veterans","Homeless Seniors","Mixed Population",{"$f":"SUM(M39:M59)","v":{"$error":"#REF!"}}]
[null,"Green Education","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close"]
[null,"Individualized Service Plans","Application","Application","Application","Application","Application","Application","Application","Application","Application","Application"]
[null,"Case Management","Application","Application","Application","Application","Application","Application","Application","Application","Application","Loan Close"]
[null,"Mental Health Care","Application","Application","Application","Application","Application","Application","Application","Application","Application","Loan Close"]
[null,"Substance Use Services","Application","Application","Application","Application","Application","Application","Application","Application","Application","Loan Close"]
[null,"Education","Loan Close","Loan Close","Loan Close","Application","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close"]
[null,"Employment & Training","Loan Close","Loan Close","Loan Close","Application","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close"]
[null,"Housing Outplacement","Loan Close","Loan Close","Application","Application","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close"]
[null,"Life Skills","Loan Close","Loan Close","Application","Application","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close"]
[null,"Physical Health Care","Application","Application","Application","Loan Close","Application","Application","Application","Application","Application","Loan Close"]
[null,"Benefits Assistance","Application","Loan Close","Loan Close","Loan Close","Application","Application","Application","Application","Application","Loan Close"]
[null,"Representative Payee","Loan Close","Loan Close","Application","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close"]
[null,"Legal Assistance","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close"]
[null,"Peer Advocacy","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close"]
[null,"Social Activities/Recreational","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close"]
[null,"Child Care","Loan Close, if Applicable","Loan Close, if Applicable","Not Applicable","Loan Close, if Applicable","Not Applicable","Loan Close, if Applicable","Loan Close, if Applicable","Loan Close, if Applicable","Not Applicable","Loan Close, If Applicable"]
[null,"Medication Management","Loan Close","Application","Application","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close"]
[null,"Attendant Care","Loan Close","Loan Close","Application","Not Applicable","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Not Applicable"]
[null,"Adult Day Care","Loan Close","Loan Close","Application","Not Applicable","Loan Close","Loan Close","Loan Close","Loan Close","Loan Close","Not Applicable"]
[null,"End of Life Counseling","Not Applicable","Loan Close","Not Applicable","Not Applicable","Loan Close","Not Applicable","Not Applicable","Not Applicable","Loan Close","Not Applicable"]
[null,"Info & Referral","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Not Applicable","Application"]
[]
[]
[null,null,"Mentally Ill","HIV / AIDS","Developmentally Disabled","Transition Age Youth","Frequent Users of DHS/DMH Services","Homeless Households","Chronically Homeless","Homeless Veterans","Homeless Seniors","Mixed Population"]
[null,"Green Education",1,1,1,1,1,1,1,1,1,1]
[null,"Individualized Service Plans",0,0,0,0,0,0,0,0,0,0]
[null,"Case Management",0,0,0,0,0,0,0,0,0,1]
[null,"Mental Health Care",0,0,0,0,0,0,0,0,0,1]
[null,"Substance Use Services",0,0,0,0,0,0,0,0,0,1]
[null,"Education",1,1,1,0,1,1,1,1,1,1]
[null,"Employment & Training",1,1,1,0,1,1,1,1,1,1]
[null,"Housing Outplacement",1,1,0,0,1,1,1,1,1,1]
[null,"Life Skills",1,1,0,0,1,1,1,1,1,1]
[null,"Physical Health Care",0,0,0,1,0,0,0,0,0,1]
[null,"Benefits Assistance",0,1,1,1,0,0,0,0,0,1]
[null,"Representative Payee",1,1,0,1,1,1,1,1,1,1]
[null,"Legal Assistance",1,1,1,1,1,1,1,1,1,1]
[null,"Peer Advocacy",1,1,1,1,1,1,1,1,1,1]
[null,"Social Activities/Recreational",1,1,1,1,1,1,1,1,1,1]
[null,"Child Care",2,2,3,2,3,2,2,2,3,2]
[null,"Medication Management",1,0,0,1,1,1,1,1,1,2]
[null,"Attendant Care",1,1,0,3,1,1,1,1,1,3]
[null,"Adult Day Care",1,1,0,3,1,1,1,1,1,3]
[null,"End of Life Counseling",3,1,3,3,1,3,3,3,1,3]
[null,"Info & Referral",3,3,3,3,3,3,3,3,3,0]

{"sheet":"I.16 Sust. Bldg. Methods ","index":17,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":true,"merged":[[11,1,11,2],[29,1,29,3],[1,1,1,3],[4,1,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4]]}
[]
[null,"I.16 Sustainable Building Methods Compliance Certification"]
[null,{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}}]
[]
[null,"REQUIRED SUSTAINABLE BUILDING METHODS"]
[null,1,"Minimum Energy Efficiency: New Construction and Rehabilitation projects must be designed to meet the minimum construction requirements as defined by TCAC Regulations Section 10325(f)(7)(A).  Rehabilitation projects will need to demonstrate a 20% reduction in energy use from tabulated baseline, based on the HERS verified existing condition.  "]
[null,2,"Outdoor water conservation measures that include (not applicable for projects with graywater irrigation systems): \n1) Use native or drought-tolerant plants for a minimum of 75% of landscaped area; select plants from Los Angeles County's Drought-tolerant Plant List found at http://planning.lacounty.gov/green, or the local jurisdiction’s drought-tolerant plant list, if required to do so by the local jurisdiction. \n2) Limit conventional grass/turf to 25% of landscaped area.\n3) Group plants with similar watering needs (hydrozones). \n4) Install high efficiency irrigation system with smart irrigation controls for all landscaping.\n"]
[null,3,"At minimum the project shall recycle and/or salvage 70% of non-hazardous construction and demolition debris. "]
[null,4,"The project shall provide an easily-accessible recycling area for tenant use that serves the entire building. "]
[null,5,"Project team shall conduct a design charrette prior to the NOFA application deadline that meets the criteria specified by Enterprise Green Communities charrettes or requirements of LEED for Homes. At minimum the charrette shall include the architect, civil, MEP, landscape architect, structural, and the energy modeler.   Meeting minutes shall be provided as evidence of the design charrette."]
[null,6,"Property manager and maintenance staff shall be trained in the use of a Green Operations and Maintenance Manual. The manual shall be prepared at pre-lease up using Green Communities' template or shall be organized to satisfy the requirements of LEED for Homes AEc1.1.  \nMust include reference in Property Management Plan "]
[null,"ADDITIONAL SUSTAINABLE BUILDING METHODS\n8 POINTS MINIMUM / 40 POINTS MAXIMUM ",null,"Available Points","Points Selected by Project",null,0]
[null,1,"Graywater Irrigation: An eligible project must have a minimum of 3,000 square feet of landscaping on grade, and must include at a minimum all front, rear, and side yards, courtyards, and parking lot landscape areas.  See eligibility criteria and requirements in Appendix 7.  \nMust include reference in Property Management Plan. ",10,10]
[null,2,"DOE Zero Energy Ready Home:  Projects that incorporate DOE Zero Energy Ready Home requirements will receive 10 points.  Projects shall certify to using the DOE Zero Energy Ready Homes criteria (which includes ENERGY STAR Homes and portions of the EPA WaterSense specifications as prerequisites).  See eligibility criteria and requirements in Appendix 7.",10]
[null,3,"ENERGY STAR Homes:  Projects (not receiving HOME funding) that certify to using ENERGY STAR Homes v. 3 will receive 10 points.  At the time of application, project teams shall acknowledge this requirement, and shall identify the ENERGY STAR Rater who will work on the project.  Progress ENERGY STAR checklists (latest version), prepared and signed by the ENERGY STAR Rater, shall be submitted to the Commission at the time of the Loan Committee review (as early as five (5) months after the award).",10]
[null,4,"Green Building Certification Program: Projects that seek above the minimum certification in at least one (1) green building program will receive five (5) points.  See incentive structure and requirements in Appendix 7.     ",5]
[null,5,"Reduce Domestic Hot Water Energy Use:  Projects that reduce energy use associated with domestic hot water heating by a minimum of 40% (as measured in kTDV/Ft2-year using the 2016 Energy Code) will receive five (5) points.  Projects shall submit a conceptual energy analysis prepared by a qualified CEA demonstrating minimum compliance and a conceptual narrative of the approach that will be taken.  Detailed energy analyses and energy models are not required for the application phase.",5]
[null,6,"EPA WaterSense Specification:  Projects that incorporate EPA WaterSense Specification will receive five (5) points.  Project teams shall incorporate the EPA WaterSense Specification into the project documents, and shall ensure that these requirements are clearly understood and adopted by the architect, the plumbing engineer, and the landscape irrigation designer at the time of the design charrette.  In order to qualify for the incentive, the project team shall submit drawings and specifications for Commission review at the Loan Committee phase.",5]
[null,7,"ENERGY STAR ceiling fans:  Installation of ENERGY STAR rated ceiling fans in all bedrooms and living rooms will receive five (5) points.",5]
[null,8,"Increased Energy Efficiency:\na) For new construction projects that exceed Title 24 energy standards by 25% for new construction of low-rise multifamily (3 or fewer habitable stories) and 20% for new construction of high-rise multifamily (4 or more habitable stories), or rehabilitation project, not subject to Title 24, that reduces energy use on a per square foot basis by 25% will receive four (4) points.\n\nb) For rehabilitation projects, not subject to Title 24, use of fluorescent light fixtures for at least 75% of light fixtures or comparable energy lighting for the project’s total lighting throughout the compliance period will receive two (2) points.","Up to 4"]
[null,9,"Quality Insulation Installation:  Projects that incorporate Quality Insulation Installation will be eligible for three (3) points and up to $350 per unit.  Project teams shall utilize Quality Insulation Installation, meeting the 2016 Energy Code Standard as a HERS-verified energy feature.  A cost estimate must be provided to justify the maximum incentive.",3,null,null,5]
[null,10,"Electric Vehicle Parking: Projects that commit to equip 5% of the parking stalls (for use by owner and residents) with a receptacle to accommodate use by electric vehicles charging equipment will receive three (3) points.  To receive points projects must provide:  \n1) A parking plan with 5% of parking stalls designated for plug-in electric vehicles. \n2) Sufficient space in electrical room for future installation of electric equipment necessary for 100% of parking stalls for use by residential component of the building. \n3) A description of how the 5% of parking stalls will be shared.\n4) Explanation as to why this is appropriate for the project.",3,null,null,10]
[null,11,"High Efficiency Toilets: Projects that install high efficiency toilets that require 1.06 gallons or less to flush and meet a minimum MaP threshold of 600 grams of waste removed from the toilet in a single flush.  Toilets must be EPA WaterSense-qualified.  Quiet flush or very low-noise models are recommended.  Applicants are encouraged to check with their appropriate water utility or water district to take advantage of available rebates.",3]
[null,12,"Nonsmoking buildings.",3]
[null,13,"Use of energy conservation measures for all building locations include:  \n1) ENERGY STAR labeled refrigerators\n2) ENERGY STAR labeled dishwashers (4.25 gpc or less)\n3) ENERGY STAR clothes washers that are a current Consortium for Energy Efficiency (CEE) Tier 3, or 4 model with a Modified Energy Factor (MEF) of 2.4 or greater and a Water Factor (WF) of 4.0 or less.\n4) ENERGY STAR lighting for interior \n5) ENERGY STAR bathroom fan/light\n6) ENERGY STAR approved exterior lighting, or High Efficacy as defined by the California Energy Commission.",2]
[null,14,"Indoor water conservation measures:    \n1) Use of showerheads that are water efficient (1.5 gpm or less).\n2) Use water-saving fixtures or flow restrictors in the kitchen and bathrooms (1.5 gpm or less).",2]
[null,15,"Incorporate design to retain, infiltrate and/or treat on-site the first one-half (1/2) inch of rainfall in a 24-hour period.",2]
[null,16,"Use of no-VOC interior paint (5 g/l or less).",2]
[null,17,"Use of at least one (1) of the following recycled materials at the designated levels: \na) Cast-in-place concrete (20% flyash for foundations, slabs, and site concrete); \nb) Carpet and pad (25%); \nc) Road base, fill or landscaped amendments (30%).",2]
[null,"TOTAL  (40 PTS MAX)",null,null,{"$f":"IF(SUM(E13:E29)>40,40,SUM(E13:E29))","v":10}]
[]
[]
[null,null,"By checking this box, applicant certifies that the above items will be incorporated into the project's design."]

{"sheet":"I.16a Hlthy. Design Elem. ","index":18,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[[28,1,28,3],[1,1,1,3],[4,1,4,2],[11,1,11,3],[16,1,16,3],[19,1,19,3],[2,1,2,3]]}
[]
[null,"I.16a Healthy Design Elements Compliance Certification"]
[null,{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}}]
[]
[null,"VOLUNTARY HEALTHY DESIGN ELEMENTS - 20 POINTS MAX",null,"Points","Proposed Project"]
[null,1,"Onsite gym incentive:  Projects that include an onsite gym will receive ten (10) points.  Applicants must include at least three varieties of cardio equipment as well as strength training equipment. Room must be open at convenient times (before and after work hours and at lunch, and a minimum of 10 hours per day). ",10]
[null,2,"Designated Exercise Room: Projects that provide a designated exercise room will receive five (5) points.  The room must be open at convenient times (before and after work hours and at lunch, and a minimum of 10 hours per day). Capacity and class offerings should allow 10% of building occupants to take one class weekly.  The exercise room must be set aside for its own use and cannot be part of a community room or other dual-use space.  ",5]
[null,3,"Edible Garden Program:  Projects that provide an Edible Garden Program that includes education, on-site garden space, composting area, and necessary resources will receive five (5) points.  A vertical garden of equal area or an off-site program will be considered.  See incentive requirements in Appendix 7.  Must include reference to the Edible Garden in Service Plan",5]
[null,4,"Container Garden and Edible Landscaping Program:  Projects that do not have enough space to fully integrate an Edible Garden Program into the site plan may propose a Container Garden and Edible Landscaping Program for the development to receive three (3) points.  This program would involve the use of edible landscape components, which could include fruit trees, culinary herbs, and shrubs such as berries that could be put in designated areas of the landscape, such as along walls, fences, and walkways.  Must include reference to the Container Garden and Edible Landscaping Program in Service Plan",3]
[null,5,"Bike racks/secure storage: Projects that provide exterior bike racks and a secure interior bike storage room will receive (3) points.  See eligibility criteria and requirements in Appendix 7.",3]
[null,6,"DESIGN FOR INCREASED STAIR USE\nA maximum of 15 points are available.  If this option is selected, 5 base points are given for Required Design Items.  A maximum of 10 additional points are then available from the Optional Design Items.",5]
[null,"Stair Location"]
[null,"6a","VISIBILITY:  Position at least one stair to be visible from the building’s main lobby. A maximum of 25 feet travel and no turns should be required to reach stairs from the building’s main entry.","Required"]
[null,"6b","LOCATION WITH RESPECT TO ELEVATORS PRIORITY - Position at least one stair before access to elevators from the main building lobby, along the principal path of travel.  ","Required"]
[null,"6c","LOCATION WITH RESPECT TO ELEVATORS VISIBILITY - Position at least one stair within view of the elevators.",2]
[null,"6d","LOCATION ON PRINCIPAL PATH OF TRAVEL - At least one stair shall be located on, and visible from, the principal path of travel on each floor.",2]
[null,"Circulation Signage"]
[null,"6e","SIGNAGE PROMPTS AT STAIRS - Include permanent signage encouraging stair use to be integrated with the building’s way-finding program.","Required"]
[null,"6f","SIGNAGE PROMPTS AT ELEVATORS - Include permanent signage encouraging stair use to be integrated with the building’s way-finding program.","Required"]
[null,"Stair Design and Aesthetics"]
[null,"6g","ELECTRICAL LIGHTING - Incorporate a professionally-designed lighting program utilizing architectural fixtures that provide the light level and quality mandated by code and consistent with lighting in the building corridors.","Required"]
[null,"6h","NATURAL LIGHTING - Provide windows or skylight at each level. ",3]
[null,"6i","MUSIC - Provide music system within the stairs.",1]
[null,"6j","ARTWORK - Include permanent non-combustible artwork to increase visual interest within the stairs.",3]
[null,"6k","FINISHES - Provide similar or better quality finishes as building corridors.",1]
[null,"6l","VENTILATION - Provide same heat and air-conditioning level as building corridors.","Required"]
[null,"6m","SECURITY - Provide closed-caption television monitoring or similar system as provided in building corridors, or better.","Required"]
[null,"6n","SIZE - Provide stair width that is at least 20% greater than the minimum required by code.",3]
[null,"TOTAL (20 PTS MAX)",null,null,{"$f":"IF(SUM(E28,E22:E25,E15:E16,E6:E11)>20,20,SUM(E28,E22:E25,E15:E16,E6:E11))","v":0}]
[]
[]
[null,null,"By checking this box, applicant certifies that the above items will be incorporated into the project's design."]