{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["App. Instructions","Dev Input Sheet","Application","TS-Reqrmnts","TS Review HM 6-21TS","Pre-Apprvl HM 6-21","Form HM 6-24","HM 6-24 Addl Sheet-1","HM 6-24 Addl Sheet-2","HM 6-24 Addl Sheet-3","HM 6-24 Addl Sheet-4","Release Apprvl HM 6-20","Standards-Design","RR Codes HM 6-22","RR Codes HM 6-23"],"not_rendered":{"charts":0,"images":67,"macros":1,"external_links":1,"defined_names":16,"comments":0,"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":"App. Instructions","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,1,8,9],[0,0,0,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[15,1,15,9],[23,0,23,9],[9,1,9,9],[10,1,10,9],[11,1,11,9],[12,1,12,9],[13,1,13,9],[14,1,14,9]]}
["Department of Housing / Connecticut Housing Finance Authority\nSSHP Priority / Critical  Needs Funding\nApplication Instructions"]
[]
["Application:"]
[null,"- Owner should complete all areas highlighted in yellow"]
[null,"Section II - Development Reserves:"]
[null,"- If CHFA has not already received the referenced balance sheet, a copy should be included with application package."]
[null,"- Development reserves, less CHFA's per unit minimum, must be used and will automatically be factored into total project costs."]
[null,"- For multiple properties under one Housing Authority where the Reserves are shared and only one property is being funded: Divide the reserve balance by the total number of units then multiply by the number of units of the property you are seeking funding for. For example: XYZ Housing Authority has three elderly properties with a total number of 80 units. The reserve balance is $250,000. One property is applying for critical needs funding and has 20 units. The Reserve share for that property is $62,500 ($250,000 / 80 x 20 = $62,500)."]
[null,"- CHFA Approved Adjustment: Speak with your Asset Manager for approval of any adjustments the Applicant seeks to create a more accurate picture of available reserves. Property financial statements will need to be updated for the following quarter's submission. Provide documentation to your Asset Manager evidencing previously committed reserves."]
[null,"-  The application must include a certification from a building design professional, or other qualified professional, certifying that the stated need is a priority or urgent need that may threaten the health and safety of the residents."]
[null,"Section III - Description Of Work Items for Total Project:"]
[null,"- Project Costs: This funding is for Priority/Critical Needs. Add description of the project (i.e. boiler replacement). Add cost of the project described.\n\n- Quotes/Proposals must be submitted with application. Total projects costs may not exceed the combined total of included quote(s)/proposal(s).\n\n- Depending on the scope of work proposed, CHFA/DOH reserve the right to require additional information/certifications to complete its review of the application.\n\n-The Owner must procure services in accordance with State and Federal requirements as well as the  property's Owner/Board approved procurement policy."]
[null,"Section IV - Project Costs and Schedule:"]
[null,"- Schedule: Applicants should estimate a work commencement within 75 days of the submission of an application."]
[null,"- Other Commitment of Funds: This could include a Letter of Participation (LOP) from the utility company, a CDBG award, donation from local bank etc. Insert a description of the funds and the amount committed. Include a copy of the commitment letter with the application package."]
[null,"- The total request for SSHP Priority Needs will calculate automatically."]
[]
["Complete Development Input Sheet - Information will populate to TS Review HM 6-21TS and Pre-Approval HM 6-21"]
[]
["TS Review HM 6-21TS Form - Complete sections III & IV (Sec. IV requires a signature) *refer to owners checklist*"]
[]
["Pre-Approval HM 6-21 form - Section IV requires signature, submit pdf with application"]
[]
["Upon approval of the application, additional documentation may need to be submitted depending on the scope of work. Your Asset Manager will be available to guide you through the necessary steps."]

{"sheet":"Dev Input Sheet","index":1,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[3,0,3,1]]}
["Development Input Sheet"]
[]
[]
["In order to make your experience with this workbook \"user-friendly\" we have created this Development Input Sheet.  The information which is inserted below will automatically flow to the applicable areas within each worksheet."]
[]
["Development Name:"]
[]
["No. of Units:"]
[]
["CHFA Development / Loan No.:"]
[]
["CHFA Asset Manager:"]
[]
["Owner:"]
[]
["Management Company:"]
[]
["Project Contact Name:"]
[]
["Contact Email:"]
[]
["Contact Phone No.:"]

{"sheet":"Application","index":2,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":false,"merged":[[25,1,25,10],[0,0,0,15],[2,5,2,8],[2,12,2,14],[4,5,4,8],[4,12,4,14],[6,5,6,8],[6,12,6,14],[8,5,8,8],[10,5,10,8],[12,5,12,8],[12,12,12,14],[16,8,16,9],[26,1,26,11],[29,1,29,3],[30,1,30,11],[30,12,30,13],[31,1,31,11],[31,12,31,13],[32,1,32,11],[32,12,32,13],[33,1,33,11],[33,12,33,13],[34,1,34,11],[34,12,34,13],[35,1,35,11],[35,12,35,13],[36,1,36,11],[36,12,36,13],[37,1,37,11],[37,12,37,13],[46,14,46,15],[47,12,47,13],[47,14,47,15],[38,1,38,11],[38,12,38,13],[39,1,39,11],[39,12,39,13],[40,1,40,11],[40,12,40,13],[41,1,41,11],[41,12,41,13],[42,12,42,13],[46,12,46,13],[48,9,48,10],[48,12,48,13],[48,14,48,15],[49,12,49,13],[49,14,49,15],[61,2,61,8],[62,2,62,8],[51,8,51,9],[63,2,63,8],[64,14,64,15],[52,8,52,9],[56,1,56,14],[57,0,57,8],[57,12,57,13],[58,12,58,13],[60,2,60,8]]}
["Department of Housing / Connecticut Housing Finance Authority\nSSHP Priority Needs Funding Application"]
["I. DEVELOPMENT INFORMATION:"]
[null,null,null,null,"DEVELOPMENT NAME:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B6),\"\",'Dev Input Sheet'!B6)","v":""},null,null,null,null,null,"CHFA DEVELOPMENT #:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B10),\"\",'Dev Input Sheet'!B10)","v":""}]
[]
[null,null,null,null,"OWNER/AGENT NAME:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B14),\"\",'Dev Input Sheet'!B14)","v":""},null,null,null,null,null,"CHFA ASSET MANAGER:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B12),\"\",'Dev Input Sheet'!B12)","v":""}]
[]
[null,null,null,null,"CONTACT EMAIL:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B20),\"\",'Dev Input Sheet'!B20)","v":""},null,null,null,null,null,"MANAGEMENT CO.:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B16),\"\",'Dev Input Sheet'!B16)","v":""}]
[]
[null,null,null,null,"CONTACT PHONE:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B22),\"\",'Dev Input Sheet'!B22)","v":""},null,null,null,null,null,"DATE:"]
[]
[null,null,null,null,"PROPERTY ADDRESS:",null,null,null,null,null,null,"NUMBER OF UNITS:",{"$f":"'Dev Input Sheet'!B8","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"OWNER LEGAL NAME:"]
[]
["II. DEVELOPMENT RESERVES:"]
[]
[null,"Most Recent Balance Sheet Dated:",null,null,null,null,null,null,null,null,null,null,"All Units",null,"Per Unit"]
[null,"Enter amount reflected in Reserve Cash (Acct. 1123)",null,null,null,null,null,null,null,null,null,"+",null,null,{"$f":"IF(ISBLANK(M11),0,M18/M11)","v":{"$error":"#DIV/0!"}}]
[null,"Plus: Replacement Reserve (Acct. 1320)",null,null,null,null,null,null,null,null,null,"+",null,null,{"$f":"IF(ISBLANK(M11),0,M19/M11)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Reserves Available:",{"$f":"+M19+M18","v":0},null,{"$f":"+O19+O18","v":{"$error":"#DIV/0!"}}]
[null,"Less: CHFA Minimum RM&R per unit recommendation "]
[null,null,null,"($1,000 p/u Elderly    $1,500 p/u Family)",null,null,null,null,null,null,null,"-",null,null,{"$f":"IF(ISBLANK(M11),0,M22/M11)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Reserves Available for Replacement/Repair Project:",{"$f":"+M20-M22","v":0},null,{"$f":"+O20-O22","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"CHFA Approved Adjustment: Explain below. +/-"]
[null,null,null,null,null,null,null,null,null,null,null,"Total Amount the Property is required to contribute to Project:",{"$f":"IF((M23+M24)<0,0,(M23+M24))","v":0}]
[null,"CHFA Approved Adjustment Explanation:"]
[]
[]
["III. DESCRIPTION OF WORK ITEMS FOR TOTAL PROJECT:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHFA"]
[null,"Supporting quotes/proposals must be included with application.",null,null,null,null,null,null,null,null,null,null,"Cost",null,"Adjustment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Project Cost:",{"$f":"SUM(M32:N42)","v":0}]
[]
["IV. PROJECT COSTS & SCHEDULE:"]
[]
[null,"Total Project Costs:",null,null,null,null,null,null,null,null,null,null,{"$f":"M43","v":0}]
[null,"Less Contribution from Property:",null,null,null,null,null,null,null,null,null,null,{"$f":"M25*-1","v":0}]
[null,"Less Other Funding Commitment: (Attach Evidence)"]
[null,null,null,null,null,null,null,null,null,null,null,"Total Request for Critical Needs Funding Request =",{"$f":"M47+M48+M49","v":0}]
[]
[null,"Anticipated Project Start Date:"]
[null,"Anticipated Construction Period in Months:"]
[]
["V. CERTIFICATION:"]
[]
[null,"False Statement\nThe undersigned acknowledges that they may be prosecuted for false statement under the laws of the State of Connecticut under Section 53a-157b of the General Statutes, as amended from time to time, for any false statement made herein. The undersigned understands that CHFA and DOH will rely on the information in this application and that the undersigned is under a continuing obligation to inform CHFA and DOH in writing of any corrections, omissions or material changes in this application and its exhibits. \n\nAuthorization\nThe undersigned has been duly authorized by resolution of the Applicant’s governing body to submit the attached in its name and knows of no reason why the Applicant cannot complete the project in accordance with the representations contained herein. The undersigned is not in default with any branch of the State of Connecticut or the federal government, except as has been specifically and fully disclosed in this application.\n\nCertification\nI understand that the funds awarded as a result of this request are to be expended for the purposes set forth herein and in accordance with all applicable laws, regulations, policies, and procedures of CHFA, DOH and the State of Connecticut. I also understand that any changes in the use of funds must be approved by CHFA and DOH in writing prior to an expenditure of funds. Funds may be terminated at any time for violations of any terms, conditions, and requirements of this agreement. I further agree to notify CHFA upon completion of the project/program via e-mail and provide final documentation via the Confirmation of Completion form. By signing this document I am confirming my understanding that this funding is associated with a loan and that this critical scope is a part of a larger redevelopment project that I plan on applying for in a future State-Sponsored Housing Program funding round. "]
[]
["Signature of Owner/Applicant"]
[]
["By:"]
["Name:"]
["Its:"]
["Date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev 10.21.21"]

{"sheet":"TS-Reqrmnts","index":3,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,1,16,10],[18,1,18,10],[1,1,1,10],[3,0,3,10],[14,1,14,10],[6,1,6,10],[12,1,12,10],[4,1,4,2]]}
[]
[null,"TECHNICAL SERVICES REQUIREMENTS"]
[]
["Please be sure to read and refer to the current Construction Guidelines: Technical Services/Asset Management (TSAM) and Capital Improvement Guide (CIG) (see link below to Guidelines).  Any purchase or contracts in Classification B.2  and/or Classification C of the Guidelines will require pre-approval.  To avoid delays, please submit all applicable items, such as those listed below."]
[null,"Guidelines link"]
[]
["1)","Scope of Work (SOW) should be clearly detailed in the bid package.  All relevant project information must be submitted as a package, not piecemeal."]
[]
["2)","Submit entire bid package to your Asset Manager.  SOW identified in bids are consistent with one another."]
[]
["3)","Depending upon SOW and Classification structure, submit bid solicitation documents if and when required."]
[]
["4)","If the SOW needs Building Design/Construction Professional's Involvement, ensure they sign the certification (Item IV on Form HM 6-21TS) and not the owner/agent."]
[]
["5)","If the Classification structure requires involvement of Technical Services (TS), TS will need to be notified BEFORE the start of project.  TS CANNOT approve things retroactively."]
[]
["6)","Provide information regarding the design professional (if any), GC involvement (if any) and copies of all contractor licenses."]
[]
["7)","Please note, if request includes multiple items, TS will not be able to provide approval for the request until all the various SOWs listed on the form are acceptable."]

{"sheet":"TS Review HM 6-21TS","index":4,"n_rows":67,"n_cols":46,"rows_kept":67,"cut":false,"hidden":false,"merged":[[47,1,47,45],[15,22,15,28],[12,35,12,45],[14,35,14,45],[8,1,8,7],[10,1,10,7],[12,1,12,7],[14,1,14,7],[41,13,41,36],[42,13,42,36],[43,13,43,36],[41,5,41,8],[42,5,42,8],[43,5,43,8],[9,22,9,28],[28,13,28,43],[4,2,4,45],[5,2,5,7],[36,13,36,30],[37,5,37,8],[37,13,37,30],[20,27,20,45],[11,22,11,28],[13,22,13,28],[18,10,18,19],[20,14,20,23],[14,27,14,34],[14,9,14,26],[27,13,27,43],[27,5,27,8],[8,35,8,45],[10,35,10,45],[66,29,66,36],[50,5,50,23],[49,29,49,45],[50,29,50,45],[66,10,66,25],[61,19,61,45],[58,41,58,45],[58,22,58,26],[57,12,57,15],[49,4,49,23],[51,6,51,23],[51,29,51,45],[38,5,38,8],[38,13,38,30],[12,27,12,34],[10,9,10,26],[8,9,8,26],[8,27,8,34],[10,27,10,34],[12,9,12,26],[29,13,29,43],[30,13,30,43],[31,13,31,43],[36,5,36,8],[28,5,28,8],[29,5,29,8],[30,5,30,8],[31,5,31,8]]}
[null,"CHFA TECHNICAL SERVICES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connecticut Housing Finance Authority"]
[null,"REVIEW & 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Management - Multifamily Housing"]
[]
[null,"CHFA Form HM 6-21TS (01/2019)"]
[null,null,"The purpose of this form is to obtain approval from CHFA Technical Services PRIOR to bid solicitation on all Capital Improvement Projects (CIP) outlined in the current Construction Guidelines: Technical Services/Asset Management (TSAM) and Capital Improvement Guide (CIG) under Classification B.2 & Classification C (see link below to Guidelines)."]
[null,null,"Guidelines link"]
[null,"I. DEVELOPMENT INFORMATION:"]
[]
[null,"DEVELOPMENT NAME:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B6),\"\",'Dev Input Sheet'!B6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHFA DEVELOPMENT #:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B10),\"\",'Dev Input Sheet'!B10)","v":""}]
[]
[null,"OWNER:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B14),\"\",'Dev Input Sheet'!B14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHFA ASSET MANAGER:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B12),\"\",'Dev Input Sheet'!B12)","v":""}]
[]
[null,"CONTACT EMAIL:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B20),\"\",'Dev Input Sheet'!B20)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MANAGEMENT CO.:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B16),\"\",'Dev Input Sheet'!B16)","v":""}]
[]
[null,"CONTACT PHONE:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B22),\"\",'Dev Input Sheet'!B22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:"]
[]
[null,"II. MAJOR REPAIR / REPLACEMENT DOCUMENTS SUBMITTED"]
[]
[null,"Check where applicable:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[null,"IlI. PROJECT CLASSIFICATION:"]
[]
[null,null,"Indicate Classification B.2 and / or Classification C work using the drop-down identifiers below."]
[null,null,"Classification B.2 / C"]
[null,null,null,"Code:",null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,"Scope:"]
[]
[null,null,"If the CIP includes Classification A & B.1 work in addition to Classification B.2  and / or Classification C work, indicate by using the drop-down identifiers below."]
[]
[null,null,"Classification A"]
[null,null,null,"Code:",null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,"Scope:"]
[]
[null,null,"Classification B.1"]
[null,null,null,"Code:",null,"N/A",null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,"Scope:"]
[]
[null,"IV. BUILDING DESIGN / CONSTRUCTION PROFESSIONAL'S CERTIFICATION:"]
[]
[null,"As the Building Design/Construction Professional for the above referenced property, I do hereby CERTIFY, to the best of my knowledge and ability that the Capital Repairs / Replacements noted above were planned and designed and will be completed in accordance with current Building Codes, Local, State & Federal regulations and current CHFA Standards of Design and Construction and all related building components and associated systems were evaluated and considered in the planning and design."]
[]
[null,"Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,"Printed 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,"Title:"]
[null,"Printed Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone #: "]
[]
[]
[null,"V. CHFA APPROVAL:"]
[]
[null,"To be completed by Program Administration:"]
[null,"Date submitted to Technical Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Funding Source:"]
[null,"Time request for TS response:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"or",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Needed:"]
[null,"Development Officer Approval:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sr. Program Officer Approval:"]
[null,"To be completed by Technical Services:"]
[null,"Technical Service Approval?"]
[null,"Required Technical Services Certifications / Observations for Payment"]
[]
[]
[]
[null,"Technical Services Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]

{"sheet":"Pre-Apprvl HM 6-21","index":5,"n_rows":78,"n_cols":46,"rows_kept":78,"cut":false,"hidden":false,"merged":[[75,14,75,31],[75,32,75,34],[75,35,75,43],[77,14,77,31],[77,32,77,34],[77,35,77,43],[12,22,12,28],[13,1,13,8],[13,9,13,26],[13,27,13,34],[13,35,13,45],[10,22,10,28],[11,1,11,8],[11,9,11,26],[11,27,11,34],[11,35,11,45],[4,2,4,44],[9,1,9,8],[9,9,9,26],[9,27,9,34],[9,35,9,45],[5,2,5,45],[14,22,14,28],[15,1,15,8],[15,9,15,26],[15,27,15,34],[15,35,15,45],[16,22,16,28],[19,10,19,19],[23,8,23,36],[24,8,24,14],[24,21,24,26],[24,32,24,36],[25,8,25,14],[25,26,25,32],[37,5,37,8],[37,14,37,33],[32,7,33,45],[34,5,34,8],[34,14,34,33],[35,5,35,8],[35,14,35,33],[36,5,36,8],[36,14,36,33],[29,1,29,45],[44,5,44,8],[44,14,44,38],[39,7,40,45],[41,5,41,8],[41,14,41,38],[42,5,42,8],[42,14,42,38],[43,5,43,8],[43,14,43,38],[46,7,47,45],[46,2,46,6],[57,1,57,45],[59,21,59,25],[59,30,59,43],[50,1,50,45],[52,4,52,23],[52,27,52,45],[53,5,53,23],[53,27,53,45],[51,1,51,45],[63,26,63,33],[63,34,63,41],[65,18,65,43],[70,32,70,34],[70,35,70,43],[66,1,66,11],[66,15,66,25],[66,29,66,34],[68,1,68,45],[70,14,70,31]]}
[null,"ESCROW RELEASE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connecticut Housing Finance Authority"]
[null,"PRE-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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Management - Multifamily Housing"]
[]
[null,"CHFA Form HM 6-21  (Rev. 12/2023)"]
[null,null,"The purpose of this form is to obtain pre-approval from Asset Management in order to commence work or purchase items intended to be reimbursed from a CHFA held escrow account.  All purchases or contracts in excess of $10,000 require pre-approval.  Any purchases/contracts which cannot be categorized using the descriptive codes (as outlined in CHFA Form HM 6-22), regardless of cost, require pre-approval.  Any purchase or contracts in Classification B.2  and/or Classification C of the current Construction Guidelines: Technical Services/Asset Management (TSAM) and Capital Improvement Guide (CIG) require pre-approval (see link below to Guidelines)."]
[null,null,"Guidelines Link"]
[]
[null,"I. DEVELOPMENT INFORMATION:"]
[]
[null,"DEVELOPMENT NAME:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B6),\"\",'Dev Input Sheet'!B6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHFA DEVELOPMENT #:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B10),\"\",'Dev Input Sheet'!B10)","v":""}]
[]
[null,"OWNER:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B14),\"\",'Dev Input Sheet'!B14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHFA ASSET MANAGER:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B12),\"\",'Dev Input Sheet'!B12)","v":""}]
[]
[null,"CONTACT EMAIL:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B20),\"\",'Dev Input Sheet'!B20)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MANAGEMENT CO:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B16),\"\",'Dev Input Sheet'!B16)","v":""}]
[]
[null,"CONTACT PHONE:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B22),\"\",'Dev Input Sheet'!B22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:"]
[]
[null,"II. PROPOSED PURCHASE/PROJECT INFORMATION:"]
[]
[null,"Check where applicable:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,"Recommended Vendor:"]
[null,"Projected Cost of Project:",null,null,null,null,null,null,{"$f":"+IF(V25+AG25>0,V25+AG25,\"\")","v":""},null,null,null,null,null,null,null,null,"Hard Costs:",null,null,null,null,null,null,null,null,null,null,"Soft Costs:"]
[null,"Proposed Start Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Completion Date:"]
[null,"Payment Expectations:"]
[null,"Was project included on your previously submitted Capital Improvement Schedule?"]
[]
[null,"IlI. PROJECT CLASSIFICATION per the current Construction Guidelines: Technical Services/Asset Management (TSAM) and Capital Improvement Guide (CIG)"]
[null,"Indicate the Classification(s) of proposed scope of work by selecting the appropriate drop-down identifier below."]
[]
[null,null,"Classification A:",null,null,null,null,"1. If the Owner will be completing any of the Capital Improvement Projects (CIP) listed under CIG section: Classification A, the Owner may certify that the work has been completed in accordance with applicable building codes, Local, State and Federal regulations and the current Standards, unless included in the scope of work for a Classification B.2  and/or Classification C."]
[]
[null,null,null,"Code:",null,"N/A",null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,null,"Scope:"]
[]
[null,null,"Classification B.1",null,null,null,null,"If the Owner will be completing any of the CIP listed under CIG section: Classification B, and cost of work for the CIP is less than $20,000, the Owner may certify that the work has been completed in accordance with applicable building codes, Local, State and Federal regulations and the current Standards, unless included in the scope of work of a Classification B.2  and/or Classification C. "]
[]
[null,null,null,"Code:",null,"N/A",null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,null,"Scope:"]
[null,null,null,"Code:",null,null,null,null,null,null,null,"Scope:"]
[]
[null,null,"Classification B.2 & Classification C",null,null,null,null,"If the Owner will be completing any of the CIP listed under CIG section: Classification B and the cost of work for the CIP is greater than or equal to $25,000 and/ or CIG section: Classification C (regardless of the anticipated cost), the Owner must retain a building design professional/consultant to determine the scope of work, prepare the bid solicitation documents, and certify that the work has been completed in accordance with applicable building codes, Local, State and Federal regulations and current Standards."]
[]
[null,"IV. OWNER / DESIGN PROFESSIONAL CERTIFICATION:"]
[]
[null,"As the Owner/Agent or Building Design/Construction Professional (as applicable) for the above referenced property, I do hereby CERTIFY, to the best of my knowledge and ability that the Capital Repairs / Replacements noted above were planned and designed and will be completed in accordance with current Building Codes, Local, State and Federal Regulations and current CHFA Standards of Design and Construction and all related building components and associated systems were evaluated and considered in the planning and design.  I further agree that the Repairs/Replacement will be certified as outlined in the current Construction Guidelines: Technical Services/Asset Management (TSAM) and Capital Improvement Guide (CIG)."]
[null,"                    Signed under penalty for false statement, sec. 53a - 157b of the Connecticut General Statutes."]
[null,"Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,"Printed Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:"]
[]
[null,"V. CHFA PRE-APPROVAL:"]
[]
[null,"APPROVAL IS CONTINGENT UPON CONFORMITY TO ALL CHFA POLICIES AND PROCEDURES & LOAN DOCUMENTS RELATED TO THIS DEVELOPMENT."]
[]
[null,"The following will be necessary for payment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cost Estimate Approved and Not to Exceed:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Reason for Denial:"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"COMMENTS:"]
[]
[]
[null,"Underwriter OR Senior Program Officer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,"For CRITICAL NEEDS APPLICATIONS ONLY, additional signatures needed, as follows:"]
[]
[null,"Senior Program Officer, Multifamily:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"Managing Director of Multifamily:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]

{"sheet":"Form HM 6-24","index":6,"n_rows":49,"n_cols":23,"rows_kept":49,"cut":false,"hidden":true,"merged":[[36,17,36,21],[35,17,35,21],[34,17,34,21],[8,2,8,4],[8,6,8,7],[8,8,8,9],[2,11,2,12],[48,15,48,16],[44,15,44,16],[45,15,45,16],[46,15,46,16],[47,15,47,16],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[44,1,44,2],[45,1,45,2],[29,3,29,9],[30,3,30,9],[31,3,31,9],[32,3,32,9],[46,1,46,2],[47,1,47,2],[48,1,48,2],[7,2,7,4],[11,3,11,9],[23,3,23,9],[24,3,24,9],[25,3,25,9],[38,5,38,7],[41,5,41,7],[33,0,37,14],[29,12,29,13],[30,12,30,13],[30,10,30,11],[31,12,31,13],[12,3,12,9],[13,3,13,9],[14,3,14,9],[15,3,15,9],[16,3,16,9],[17,3,17,9],[27,12,27,13],[23,10,23,11],[25,10,25,11],[26,10,26,11],[16,12,16,13],[17,12,17,13],[18,12,18,13],[28,12,28,13],[16,10,16,11],[26,3,26,9],[27,3,27,9],[24,12,24,13],[22,12,22,13],[23,12,23,13],[28,3,28,9],[18,3,18,9],[19,3,19,9],[20,3,20,9],[25,12,25,13],[26,12,26,13],[24,10,24,11],[19,12,19,13],[20,12,20,13],[21,12,21,13],[3,0,3,1],[13,18,13,21],[14,18,14,21],[15,18,15,21],[6,6,6,7],[6,8,6,9],[28,10,28,11],[17,10,17,11],[18,10,18,11],[14,10,14,11],[20,10,20,11],[21,10,21,11],[22,10,22,11],[12,10,12,11],[23,18,23,21],[24,18,24,21],[19,10,19,11],[11,10,11,11],[11,12,11,13],[12,12,12,13],[13,12,13,13],[14,12,14,13],[15,12,15,13],[15,10,15,11],[48,20,48,22],[41,18,41,19],[41,21,41,22],[28,18,28,21],[11,18,11,21],[25,18,25,21],[26,18,26,21],[22,3,22,9],[3,6,4,7],[3,8,4,9],[4,10,5,10],[4,11,5,11],[12,18,12,21],[2,15,3,15],[2,17,3,18],[2,6,2,7],[7,6,7,7],[7,8,7,9],[46,20,46,22],[29,18,29,21],[43,0,43,21],[30,18,30,21],[31,18,31,21],[31,10,31,11],[2,0,2,1],[5,6,5,7],[5,8,5,9],[13,10,13,11],[2,8,2,9],[38,18,38,19],[38,21,38,22],[32,17,32,21],[33,17,33,21],[37,17,37,21],[21,3,21,9],[27,10,27,11],[32,10,32,15],[27,18,27,21],[29,10,29,11],[22,18,22,21],[16,18,16,21],[17,18,17,21],[18,18,18,21],[19,18,19,21],[20,18,20,21],[21,18,21,21],[4,0,4,1],[10,0,10,22]]}
[null,null,null,null,null,null,"REQUEST TO RELEASE ESCROW FUNDS",null,null,null,null,null,null,null,null,null,null,null,null,"CHFA Form HM 6-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Rev. 01/2019)"]
["Development Name:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B6),\"\",'Dev Input Sheet'!B6)","v":""},null,null,null,null,null,null,null,"CHFA Loan #:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B10),\"\",'Dev Input Sheet'!B10)","v":""}]
["Owner:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B14),\"\",'Dev Input Sheet'!B14)","v":""}]
["Project Contact Name:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B18),\"\",'Dev Input Sheet'!B18)","v":""},null,null,null,null,null,null,null,null,null,"As the Owner/Agent for the referenced property, I do hereby CERTIFY that the "]
[null,"       Mgmt.  Co:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B16),\"\",'Dev Input Sheet'!B16)","v":""},null,null,null,null,null,null,null,null,null,"Capital Repairs/Replacements noted were not paid from Insurance Proceeds."]
[null,"        # of Units:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B8),\"\",'Dev Input Sheet'!B8)","v":""}]
[null," Contact Email:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B20),\"\",'Dev Input Sheet'!B20)","v":""},null,null,null,null,null,null,null,null,null,"Signature of Owner/Agent ",null,null,"____________________________________________"]
[null," Contact Phone #:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B22),\"\",'Dev Input Sheet'!B22)","v":""}]
[]
["Replacement Reserve Requests should be forwarded to the following CHFA e-mail addresses:  rrdraws@chfa.org and to your Asset Manager"]
["HUD Item Code ","Invoice Date","Invoice Number","CIG Code & Description of Work Performed/Item Replaced",null,null,null,null,null,null,"Location \n(i.e. Unit, Bldg #)",null,"Vendor",null,"Identity-of-Interest","Age of Replaced Item (if applicable)","Amount","Check Number","CHFA Preapproval Date\n(if applicable)",null,null,null,"HUD Approval Attached"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Use additional sheets as needed",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(Q13:Q32)=0, \"\",(SUM(Q13:Q32)))","v":""},"Subtotal of this sheet"]
["As the Owner/Agent and/or Building Design/Construction Professional for the above referenced property, I do hereby CERTIFY, to the best of my knowledge and ability that the Capital Repairs/Replacements noted above were planned and designed and has been/will be completed in accordance with current Building Codes and CHFA Standards of Design and Construction and all related building components and associated systems were evaluated and considered in the planning and design. I further certify that all warranties have been received and the Repairs/Replacements, as outlined in the current Construction Guidelines:  Technical Services/Asset Management (TSAM) and Capital Improvement Guide (CIG), comply with HUD Handbook 4350.1, if applicable, the CHFA Escrow Release Policy and all related loan documents prior to submission for payment/reimbursement from CHFA.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HM 6-24 Addl Sheet-1'!J41","v":""},"Subtotal from attached sheet 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HM 6-24 Addl Sheet-2'!J41","v":""},"Subtotal from attached sheet 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HM 6-24 Addl Sheet-3'!J41","v":""},"Subtotal from attached sheet 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HM 6-24 Addl Sheet-4'!J41","v":""},"Subtotal from attached sheet 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(Q33:Q37)=0,\"\",(SUM(Q33:Q37)))","v":""},"Total Amount Requested"]
[]
["Signature of Design Professional",null,null,null,null,"Date"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page",1,null,"of"]
["Signature of Owner/Agent",null,null,null,null,"Date"]
["TO BE COMPLETED BY THE CHFA FINANCE DEPARTMENT"]
["Prepared",null,null,null,null,null,null,null,"Replacement Reserve Balance:",null,null,null,null,"#of Units:","#of Units:"]
["Entered",null,null,null,null,null,null,null,"Replacement Reserve Per Unit:",null,null,null,null,"Paid to Date:","Paid to Date:"]
["Reviewed",null,null,null,null,null,null,null,"Net Escrow Balance:",null,null,null,null,"Draw #:","Draw #:",null,null,null,null,"Req. #:"]
["Reviewed",null,null,null,null,null,null,null,"Current Balance per Unit:",null,null,null,null,"Previous Disb Date:","Previous Disb Date:"]
["Approved",null,null,null,null,null,null,null,"Required Balance per Unit:",null,null,null,null,"Current Disb Date:"," Current Disb Date:",null,null,null,null,"Supplier / Site #:"]

{"sheet":"HM 6-24 Addl Sheet-1","index":7,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":true,"merged":[[18,11,18,14],[19,11,19,14],[32,11,32,14],[40,11,40,14],[33,11,33,14],[34,11,34,14],[35,11,35,14],[36,11,36,14],[37,11,37,14],[2,9,2,10],[39,11,39,14],[7,11,7,14],[8,11,8,14],[2,11,2,16],[3,11,3,16],[4,11,4,16],[10,11,10,14],[11,11,11,14],[12,11,12,14],[9,11,9,14],[3,9,3,10],[6,0,6,16],[5,8,5,9],[5,10,5,14],[5,0,5,1],[2,6,2,8],[3,6,3,8],[4,0,4,1],[4,2,4,3],[2,0,2,1],[3,0,3,1],[2,2,2,3],[3,2,3,3],[4,6,4,8],[4,9,4,10],[14,11,14,14],[15,11,15,14],[16,11,16,14],[17,11,17,14],[13,11,13,14],[40,6,40,8],[43,0,43,5],[42,0,42,5],[38,11,38,14],[20,11,20,14],[21,11,21,14],[28,11,28,14],[29,11,29,14],[30,11,30,14],[31,11,31,14],[22,11,22,14],[23,11,23,14],[24,11,24,14],[25,11,25,14],[26,11,26,14],[27,11,27,14]]}
["CONNECTICUT HOUSING FINANCE AUTHORITY",null,null,null,null,{"$f":"+'Form HM 6-24'!G1","v":"REQUEST TO RELEASE ESCROW FUNDS"},null,null,null,null,null,null,null,null,null,null,"CHFA Form HM 6-24-addl sheet(s)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," (Rev. 01/2019)"]
["Development Name:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B6),\"\",'Dev Input Sheet'!B6)","v":""},null,null,"Mgmt.  Co.",{"$f":"IF(ISBLANK('Dev Input Sheet'!B16),\"\",'Dev Input Sheet'!B16)","v":""},null,null," CHFA Loan #:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B10),\"\",'Dev Input Sheet'!B10)","v":""}]
["Owner:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B14),\"\",'Dev Input Sheet'!B14)","v":""},null,null,"# of Units:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B8),\"\",'Dev Input Sheet'!B8)","v":""},null,null,"CHFA Asset Manager:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B12),\"\",'Dev Input Sheet'!B12)","v":""}]
["Project Contact Name:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B18),\"\",'Dev Input Sheet'!B18)","v":""},null,null," Contact Email:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B20),\"\",'Dev Input Sheet'!B20)","v":""},null,null,"Contact Phone:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B22),\"\",'Dev Input Sheet'!B22)","v":""}]
[]
[]
["Item Code","Invoice Date","Invoice Number","CIG Code & Description of Work Performed/Item Replaced",null,"Location \n(i.e. Unit, Bldg #) etc","Vendor","Identity-of-Interest","Age of Replaced Item (if applicable)","Amount","Check Number","CHFA Preapproval Date\n(if applicable)",null,null,null,"HUD Approval Attached","Contract Attached"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Use additional sheets as needed",null,null,"Subtotal of this sheet",null,null,{"$f":"IF(SUM(J9:J40)=0,\"\",(SUM(J9:J40)))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]

{"sheet":"HM 6-24 Addl Sheet-2","index":8,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":true,"merged":[[42,0,42,5],[43,0,43,5],[36,11,36,14],[37,11,37,14],[38,11,38,14],[39,11,39,14],[40,6,40,8],[40,11,40,14],[35,11,35,14],[24,11,24,14],[25,11,25,14],[26,11,26,14],[27,11,27,14],[28,11,28,14],[29,11,29,14],[30,11,30,14],[31,11,31,14],[32,11,32,14],[33,11,33,14],[34,11,34,14],[23,11,23,14],[12,11,12,14],[13,11,13,14],[14,11,14,14],[15,11,15,14],[16,11,16,14],[17,11,17,14],[18,11,18,14],[19,11,19,14],[20,11,20,14],[21,11,21,14],[22,11,22,14],[11,11,11,14],[4,0,4,1],[4,2,4,3],[4,6,4,8],[4,9,4,10],[4,11,4,16],[5,0,5,1],[5,8,5,9],[5,10,5,14],[6,0,6,16],[7,11,7,14],[8,11,8,14],[9,11,9,14],[10,11,10,14],[2,0,2,1],[2,2,2,3],[2,6,2,8],[2,9,2,10],[2,11,2,16],[3,0,3,1],[3,2,3,3],[3,6,3,8],[3,9,3,10],[3,11,3,16]]}
["CONNECTICUT HOUSING FINANCE AUTHORITY",null,null,null,null,{"$f":"+'Form HM 6-24'!G1","v":"REQUEST TO RELEASE ESCROW FUNDS"},null,null,null,null,null,null,null,null,null,null,"CHFA Form HM 6-24-addl sheet(s)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," (Rev. 01/2019)"]
["Development Name:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B6),\"\",'Dev Input Sheet'!B6)","v":""},null,null,"Mgmt.  Co.",{"$f":"IF(ISBLANK('Dev Input Sheet'!B16),\"\",'Dev Input Sheet'!B16)","v":""},null,null," CHFA Loan #:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B10),\"\",'Dev Input Sheet'!B10)","v":""}]
["Owner:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B14),\"\",'Dev Input Sheet'!B14)","v":""},null,null,"# of Units:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B8),\"\",'Dev Input Sheet'!B8)","v":""},null,null,"CHFA Asset Manager:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B12),\"\",'Dev Input Sheet'!B12)","v":""}]
["Project Contact Name:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B18),\"\",'Dev Input Sheet'!B18)","v":""},null,null," Contact Email:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B20),\"\",'Dev Input Sheet'!B20)","v":""},null,null,"Contact Phone:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B22),\"\",'Dev Input Sheet'!B22)","v":""}]
[]
[]
["Item Code","Invoice Date","Invoice Number","CIG Code & Description of Work Performed/Item Replaced",null,"Location \n(i.e. Unit, Bldg #) etc","Vendor","Identity-of-Interest","Age of Replaced Item (if applicable)","Amount","Check Number","CHFA Preapproval Date\n(if applicable)",null,null,null,"HUD Approval Attached","Contract Attached"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Use additional sheets as needed",null,null,"Subtotal of this sheet",null,null,{"$f":"IF(SUM(J9:J40)=0,\"\",(SUM(J9:J40)))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]

{"sheet":"HM 6-24 Addl Sheet-3","index":9,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":true,"merged":[[42,0,42,5],[43,0,43,5],[36,11,36,14],[37,11,37,14],[38,11,38,14],[39,11,39,14],[40,6,40,8],[40,11,40,14],[35,11,35,14],[24,11,24,14],[25,11,25,14],[26,11,26,14],[27,11,27,14],[28,11,28,14],[29,11,29,14],[30,11,30,14],[31,11,31,14],[32,11,32,14],[33,11,33,14],[34,11,34,14],[23,11,23,14],[12,11,12,14],[13,11,13,14],[14,11,14,14],[15,11,15,14],[16,11,16,14],[17,11,17,14],[18,11,18,14],[19,11,19,14],[20,11,20,14],[21,11,21,14],[22,11,22,14],[11,11,11,14],[4,0,4,1],[4,2,4,3],[4,6,4,8],[4,9,4,10],[4,11,4,16],[5,0,5,1],[5,8,5,9],[5,10,5,14],[6,0,6,16],[7,11,7,14],[8,11,8,14],[9,11,9,14],[10,11,10,14],[2,0,2,1],[2,2,2,3],[2,6,2,8],[2,9,2,10],[2,11,2,16],[3,0,3,1],[3,2,3,3],[3,6,3,8],[3,9,3,10],[3,11,3,16]]}
["CONNECTICUT HOUSING FINANCE AUTHORITY",null,null,null,null,{"$f":"+'Form HM 6-24'!G1","v":"REQUEST TO RELEASE ESCROW FUNDS"},null,null,null,null,null,null,null,null,null,null,"CHFA Form HM 6-24-addl sheet(s)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," (Rev. 01/2019)"]
["Development Name:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B6),\"\",'Dev Input Sheet'!B6)","v":""},null,null,"Mgmt.  Co.",{"$f":"IF(ISBLANK('Dev Input Sheet'!B16),\"\",'Dev Input Sheet'!B16)","v":""},null,null," CHFA Loan #:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B10),\"\",'Dev Input Sheet'!B10)","v":""}]
["Owner:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B14),\"\",'Dev Input Sheet'!B14)","v":""},null,null,"# of Units:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B8),\"\",'Dev Input Sheet'!B8)","v":""},null,null,"CHFA Asset Manager:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B12),\"\",'Dev Input Sheet'!B12)","v":""}]
["Project Contact Name:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B18),\"\",'Dev Input Sheet'!B18)","v":""},null,null," Contact Email:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B20),\"\",'Dev Input Sheet'!B20)","v":""},null,null,"Contact Phone:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B22),\"\",'Dev Input Sheet'!B22)","v":""}]
[]
[]
["Item Code","Invoice Date","Invoice Number","CIG Code & Description of Work Performed/Item Replaced",null,"Location \n(i.e. Unit, Bldg #) etc","Vendor","Identity-of-Interest","Age of Replaced Item (if applicable)","Amount","Check Number","CHFA Preapproval Date\n(if applicable)",null,null,null,"HUD Approval Attached","Contract Attached"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Use additional sheets as needed",null,null,"Subtotal of this sheet",null,null,{"$f":"IF(SUM(J9:J40)=0,\"\",(SUM(J9:J40)))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]

{"sheet":"HM 6-24 Addl Sheet-4","index":10,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":true,"merged":[[42,0,42,5],[43,0,43,5],[36,11,36,14],[37,11,37,14],[38,11,38,14],[39,11,39,14],[40,6,40,8],[40,11,40,14],[35,11,35,14],[24,11,24,14],[25,11,25,14],[26,11,26,14],[27,11,27,14],[28,11,28,14],[29,11,29,14],[30,11,30,14],[31,11,31,14],[32,11,32,14],[33,11,33,14],[34,11,34,14],[23,11,23,14],[12,11,12,14],[13,11,13,14],[14,11,14,14],[15,11,15,14],[16,11,16,14],[17,11,17,14],[18,11,18,14],[19,11,19,14],[20,11,20,14],[21,11,21,14],[22,11,22,14],[11,11,11,14],[4,0,4,1],[4,2,4,3],[4,6,4,8],[4,9,4,10],[4,11,4,16],[5,0,5,1],[5,8,5,9],[5,10,5,14],[6,0,6,16],[7,11,7,14],[8,11,8,14],[9,11,9,14],[10,11,10,14],[2,0,2,1],[2,2,2,3],[2,6,2,8],[2,9,2,10],[2,11,2,16],[3,0,3,1],[3,2,3,3],[3,6,3,8],[3,9,3,10],[3,11,3,16]]}
["CONNECTICUT HOUSING FINANCE AUTHORITY",null,null,null,null,{"$f":"+'Form HM 6-24'!G1","v":"REQUEST TO RELEASE ESCROW FUNDS"},null,null,null,null,null,null,null,null,null,null,"CHFA Form HM 6-24-addl sheet(s)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," (Rev. 01/2019)"]
["Development Name:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B6),\"\",'Dev Input Sheet'!B6)","v":""},null,null,"Mgmt.  Co.",{"$f":"IF(ISBLANK('Dev Input Sheet'!B16),\"\",'Dev Input Sheet'!B16)","v":""},null,null," CHFA Loan #:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B10),\"\",'Dev Input Sheet'!B10)","v":""}]
["Owner:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B14),\"\",'Dev Input Sheet'!B14)","v":""},null,null,"# of Units:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B8),\"\",'Dev Input Sheet'!B8)","v":""},null,null,"CHFA Asset Manager:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B12),\"\",'Dev Input Sheet'!B12)","v":""}]
["Project Contact Name:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B18),\"\",'Dev Input Sheet'!B18)","v":""},null,null," Contact Email:",{"$f":"IF(ISBLANK('Dev Input Sheet'!B20),\"\",'Dev Input Sheet'!B20)","v":""},null,null,"Contact Phone:",null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B22),\"\",'Dev Input Sheet'!B22)","v":""}]
[]
[]
["Item Code","Invoice Date","Invoice Number","CIG Code & Description of Work Performed/Item Replaced",null,"Location \n(i.e. Unit, Bldg #) etc","Vendor","Identity-of-Interest","Age of Replaced Item (if applicable)","Amount","Check Number","CHFA Preapproval Date\n(if applicable)",null,null,null,"HUD Approval Attached","Contract Attached"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Use additional sheets as needed",null,null,"Subtotal of this sheet",null,null,{"$f":"IF(SUM(J9:J40)=0,\"\",(SUM(J9:J40)))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]

{"sheet":"Release Apprvl HM 6-20","index":11,"n_rows":50,"n_cols":46,"rows_kept":50,"cut":false,"hidden":true,"merged":[[35,3,35,24],[4,1,4,45],[5,36,5,45],[6,36,6,45],[7,22,7,23],[8,22,8,23],[11,1,11,8],[11,9,11,26],[11,27,11,34],[11,35,11,45],[12,22,12,28],[13,1,13,8],[13,9,13,26],[13,27,13,34],[13,35,13,45],[14,22,14,28],[16,19,16,23],[16,30,16,37],[17,20,17,24],[24,7,24,11],[24,12,24,18],[24,23,24,29],[26,7,26,11],[26,12,26,18],[26,23,26,29],[32,1,32,45],[33,13,33,21],[33,35,33,43],[36,2,36,43],[37,10,37,31],[37,32,37,34],[37,35,37,43],[39,10,39,31],[39,32,39,34],[39,35,39,43],[46,35,46,43],[41,10,41,31],[41,32,41,34],[41,35,41,43],[43,10,43,31],[43,32,43,34],[43,35,43,43]]}
[null,"AUTHORIZATION TO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connecticut Housing Finance Authority"]
[null,"RELEASE ESCROW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Management - Multifamily Housing"]
[null,"CHFA Form HM 6-20 (Rev. 01/2019)"]
[]
[null,"This Authorization to Release Escrow satisfies Asset Management Policy relative to eligible items and supporting documentation.  Asset Management has reviewed this request and authorizes the release of the following amounts from one of the following:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Submitted to Finance:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Submitted to Asset Mgt.:"]
[]
[]
[null,"I.  DEVELOPMENT INFORMATION:"]
[]
[null,"DEVELOPMENT NAME:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B6),\"\",'Dev Input Sheet'!B6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHFA DEVELOPMENT #:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B10),\"\",'Dev Input Sheet'!B10)","v":""}]
[]
[null,"OWNER:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B14),\"\",'Dev Input Sheet'!B14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHFA ASSET MANAGER:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Dev Input Sheet'!B12),\"\",'Dev Input Sheet'!B12)","v":""}]
[]
[null,"II.  OBSERVATION APPROVAL"]
[null,null,"Asset Management Observations"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Initials"]
[null,"III.  ESCROW INFORMATION"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"From: $",null,null,null,null,null,null,null,null,null,null,null,null,"To",null,"$ "]
[]
[null,null,null,null,null,null,null,"Effective:",null,null,null,null,null,null,null,null,null,null,null,null,"To"]
[]
[]
[]
[]
[null,"COMMENTS:"]
[]
[null,null,null,"AMOUNT of Original Request:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMOUNT Approved:"]
[]
[null,null,null,"Executive Director (E. D.) signature required:"]
[]
[null,null,null,"Asset Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,null,null,"Director, MH:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,null,null,"Managing Director, MH:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,null,null,"E.D. (if applicable):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REQ #: "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Standards-Design","index":12,"n_rows":124,"n_cols":13,"rows_kept":124,"cut":false,"hidden":true,"merged":[[25,2,25,9],[26,2,26,9],[44,2,44,9],[0,0,0,9],[1,0,1,9],[3,0,3,9],[4,0,4,9],[5,2,5,9]]}
[]
["CHFA Capital Improvement Project Classifications for Repairs/Replacements/Installations"]
[]
["CHFA requires that repair/replacement work be completed in accordance with all applicable Building Codes, State and Federal regulations current CHFA Multifamily Design, Construction and Sustainability Standards (Standards).  Below is a list of example projects which require certification of completion in accordance with the Standards.  Examples are listed in three categories, and acceptable certifying agent(s) are indicated for each project.  Depending upon the project, the acceptable certifying agent(s) may include one or more of the following: the Owner [O], a CT-licensed/insured Building and/or Home Inspector, or HUD-approved Inspector [I], insured FHA 203K Compliance Consultant [C], Architect [A], Professional Engineer [PE], Licensed Environmental Consultant [LEC], or Approved Vendor [AV].  "]
["CHFA prefers the use of design professionals (A and PEs), whenever possible, to determine and develop the scope of work to be included in the bid documents, coordinate bids and certify that the work has been completed in accordance with CHFA's Standards.  CHFA reserves the right to require a design professional on any and all replacement/repair construction projects, subject to the scope and complexity of the proposed project.  "]
["Classification A.",null,"If the Owner will be completing any of the following Capital Improvement Repair/Replacement/Installation projects, the Owner may certify that the work has been completed in accordance with applicable building codes, State and Federal regulations, and CHFA's current Standards:"]
[]
[null,null,"N/A"]
[null,null,"Air-Conditioning units in existing sleeves replacement"]
[null,null,"Appliance replacement"]
[null,null,"Bathroom cabinet/countertop/plumbing fixtures/fans/lights/outlets"]
[null,null,"Building and site termite treatment"]
[null,null,"Decking repair/replacement"]
[null,null,"Door replacement (Storm Door or Interior Door)"]
[null,null,"Exterior painting/caulking/weaterproofing"]
[null,null,"Flooring replacement"]
[null,null,"Gutter system replacement/installation"]
[null,null,"Kitchen cabinet/countertop/plumbing fixtures/fans/lights/outlets"]
[null,null,"Masonry re-pointing, minor brick replacement and joint repair"]
[null,null,"Pool/tennis court/fitness center/playground repair/replacement"]
[null,null,"Power washing of exterior building elements"]
[null,null,"Security systems repair/replacement"]
[null,null,"Tree/brush/shrub trimming or removal"]
[]
["Classification B.",null,"If the Owner will be completing any of the following Capital Improvement Repair/Replacement/Installation projects, and…"]
[1,null,"…the anticipated cost of the project is < $20,000, the Owner may certify that the work has been completed in accordance with current Building Codes, State and Federal regulations and CHFA Standards of Design and Construction;"]
[2,null,"...the anticipated cost of the project is > $20,000, a Building Design/Construction Professional/Consultant must be retained to determine the scope of work to be included in the bid documents and certify that the work has been completed in accordance with current Building Codes, State and Federal regulations and CHFA Standards of Design and Construction:"]
[]
[null,null,"N/A"]
["I/C",null,"Air-conditioning units in existing/new sleeves replacement/installation"]
["PE",null,"Air-conditioning equipment and systems (roof-top) repair/replacement/installation"]
["I/C",null,"Asphalt roof shingle repair/replacement/installation"]
["I/C",null,"Bathroom and kitchen exhaust fans/systems installation"]
["A/PE/I",null,"Built-up roofing repair/replacement/installation"]
["I",null,"Electrical service repair/replacement "]
["I/C",null,"Exterior door replacement/installation"]
["I/C",null,"Exterior siding repair/replacement/installation"]
["PE",null,"Hard-wired smoke detector system/carbon monoxide detector system installation"]
["PE",null,"Heating equipment/controls repair/replacement/installation"]
["I/C",null,"Hot water heaters/controls replacement/installation"]
["A/PE",null,"Single-ply roofing repair/replacement/installation"]
["I/PE",null,"Site paving repair/replacement/installation, including parking areas and sidewalks"]
["I/C",null,"Window replacement/installation"]
[]
["Classification C.",null,"If the Owner will be completing any of the following projects (regardless of the anticipated cost), a building design/construction professional must be retained to determine the scope of work to be included in the bid documents, the bid documents must be reviewed and accepted by CHFA Technical Services prior to bid solicitation, and the building design/construction professional of record must certify that the work has been completed in accordance with current Building Codes, State and Federal regulations and CHFA Standards of Design and Construction:"]
[]
[null,null,"N/A"]
["A/PE",null,"Alterations to or removal of fire-rated enclosures/separations/pasages/doors"]
["PE",null,"Antenna; i.e. cell tower installation "]
["PE",null,"Building or site structural repairs/replacement"]
["A",null,"Commercial space build-out"]
["PE",null,"Cooling plants for buildings (cooling towers, piping, ductwork, etc.) repair/replacement/installation "]
["A/PE",null,"Decking/balcony repair/replacement (>24\" above finished grade)"]
["PE",null,"Electrical service upgrade"]
["PE",null,"Electrical switchgear repair/replacement"]
["A V/PE",null,"Elevator repair/upgrade/replacement"]
["PE",null,"Emergency generator repair/replacement/installation"]
["A/PE",null,"Energy-efficiency upgrades (building components/systems)"]
["A/PE",null,"Exterior fire-escape repair/replacement"]
["PE",null,"Exterior masonry repairs where movement cracks are apparent"]
["PE",null,"Geothermal heating/cooling system installation"]
["A V/PE",null,"Heat/fire/smoke suppression systems"]
["PE",null,"Heating plants (boilers/furnaces, and associated piping/ductwork and chimneys/flues) repair/replacement/installation"]
["A/PE",null,"Parking structure repair/modification"]
["PE",null,"Photovoltaic/solar thermal system installation"]
["PE",null,"Site grading and retaining wall repair/replacement/installation)"]
["PE",null,"Site utility (storm/sanitary drainage system, and electric/gas/phone/cable line) work"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Air-Conditioning units in existing sleeves replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Appliance replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Bathroom cabinet/countertop/plumbing fixtures/fans/lights/outlets"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Building and site termite treatment"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Decking repair/replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Door replacement (Storm Door or Interior Door)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Exterior painting/caulking/weatherproofing"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Flooring replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Gutter system replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Kitchen cabinet/countertop/plumbing fixtures/fans/lights/outlets"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Masonry re-pointing, minor brick replacement and joint repair"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Pool/tennis court/fitness center/playground repair/replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Power washing of exterior building elements"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Security system repair/replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A.  Tree/brush/shrub trimming or removal"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Air-conditioning units in existing/new sleeves replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Air-conditioning units and sleeves installation  "]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Asphalt roof shingle repair/replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Bathroom and Kitchen exhaust fans/systems/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Built-up roofing repair/replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Electrical service repair/replacement "]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Exterior door replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Exterior siding repair/replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Hard-wired smoke detector system/carbon monoxide detector system installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Heating equipment/controls repair/replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Hot water heaters/controls replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Single-ply roofing repair/replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Site paving repair/replacement/installation, including parking areas and sidewalks"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B. Window replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Alterations to or removal of fire-rated enclosures/separations/pasages/doors"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Antenna; i.e. cell tower installation "]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Building or site structural repairs/replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Commercial space build-out"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Cooling plants for buildings (cooling towers, piping, ductwork, etc.) repair/replacement/installation "]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Decking/balcony repair/replacement (>24\" above finished grade)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Electrical service upgrade"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Electrical switchgear repair/replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Elevator repair/upgrade/replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Emergency generator repair/replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Energy-efficiency upgrades (building components/systems)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Exterior fire-escape repair/replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Exterior masonry repairs where movement cracks are apparent"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Geothermal heating/cooling system installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Heat/fire/smoke suppression systems"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Heating plants (boilers/furnaces, and associated piping/ductwork and chimneys/flues) repair/replacement/installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Parking structure repair/modification"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Photovoltaic/solar thermal system installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Site grading and retaining wall repair/replacement/installation)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C. Site utility (storm/sanitary drainage system, and electric/gas/phone/cable line) work"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Approved Operating Payables: Utilities/Insurance/Real Estate"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Approved Operating Deficits: Per Invoice"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Approved Operating Deficits: Per Attachment"]

{"sheet":"RR Codes HM 6-22","index":13,"n_rows":79,"n_cols":10,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,2,0,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[1,2,1,3],[4,0,4,3],[7,1,7,3],[8,1,8,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[19,0,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[25,0,25,3],[27,0,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[39,1,39,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3]]}
["REPLACEMENT RESERVE                                                                                            ",null,"Connecticut Housing Finance Authority"]
["DESCRIPTIVE CODES",null,"Asset Management-Multifamily Housing"]
[]
["CHFA Form HM 6-22 (Rev. 05/2012)"]
["The following descriptions provide an outline of items eligible for reimbursement from the Reserve for Replacement Escrow as promulgated in the HUD Handbook 4350.1 Chapter 4 Section 9.  As a guideline, replacement expenditures are generally capitalized and may be eligible for reimbursement from a development’s Reserve for Replacement escrow to the extent available funds meet or exceed minimum requirements.  Purchases considered as routine maintenance are expensed and only occasionally may be eligible for reimbursement due to extraordinary conditions.  Items not specifically mentioned below may be allowed only with the Pre-Approval (HM 6-21) of the Asset Manager and HUD (as required)."]
[]
["A.   CODES for ELIGIBLE ITEMS FROM REPLACEMENT RESERVES:"]
["A-1","Replacement of refrigerators, ranges, dishwashers, microwaves, garbage disposals, air-conditioners and other major appliances in the dwelling units."]
["A-2 *","Extensive replacement of unit(s) kitchen and bathroom sinks and counter tops, bathroom tubs, toilets, doors (interior & exterior), flooring and sheetrock."]
["A-3","Major roof repairs, including major replacement of gutters, downspouts and related eaves of soffits."]
["A-4","Major plumbing and sanitary system repairs."]
["A-5","Replacement or significant repair of HVAC or electrical systems, including cooling towers, water chilling units, furnaces, stokers, boilers, hot water heaters, fuel storage tanks and lighting."]
["A-6","Overhaul of elevator systems."]
["A-7","Major repaving/resurfacing/seal coating (sidewalks, parking lots, driveways and athletic courts)."]
["A-8","Repainting of entire building exterior."]
["A-9 *","Extensive replacement of siding, decks, windows (including glass panes), fencing and retaining walls."]
["A-10 *","Extensive replacement/installation of exterior (lawn) sprinkler systems."]
["A-11","Replacement of equipment or major repairs to swimming pool and fitness center."]
[]
["CODES A-12a-d REQUIRE ASSET MANAGER PRE-APPROVAL IF GREATER THAN $10,000"]
["A-12a","Would result in enhancing the mortgage security (ex. computers, computer software, unit air conditioners, and installation of gutters)."]
["A-12b","Would upgrade the property and place the property in a more favorable competitive position in rental market.  (i.e. installing handicapped accessible equipment, signage, or common area appliances, furniture and painting)."]
["A-12c","Would be necessary to comply with changes in local, state or federal laws such as smoke/carbon monoxide detectors or any fire safety equipment such as alarms, hoses, lights (excluding fire extinguishers) or security systems"]
["A-12d","Would not inordinately deplete the Reserve Funds (i.e. the improvements must be affordable)."]
[]
["*Any request for reimbursement that uses these codes requires a Capital Improvement Schedule (CIS) to be submitted showing what makes up the ‘extensive replacement’ within the budget year."]
[]
["B.  TRADITIONALLY INELIGIBLE ITEMS"]
["1.","Painting of dwelling units - separate reserve may be established."]
["2.","Replacement of range burners, bibs, oven elements, controls, valves, wiring etc."]
["3.","Replacement of dwelling unit air conditioning components such as fan motors and window unit compressors"]
["4.","Minor HVAC repairs such as valve replacement and general maintenance and cleaning of HVAC equipment"]
["5.","Minor roof repairs including minor repairs to gutters and downspouts"]
["6.","Minor paving repairs"]
["7.","Caulking and sealing"]
["8.","Window and screen repairs"]
["9.","Purchase of maintenance tools and equipment such as lawn mowers, snow blowers, and leaf blowers"]
["10","Purchase of minor office equipment (ex. staplers, calculators, electric pencil sharpeners, digital cameras, phones)"]
["11.","Inspection/recharging/replcement of fire extinguishers"]
["12.","Other items generally considered to be routine maintenance (ex. window treatments, bulbs)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"HM Codes"]
[]
[]
[null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,null,null,null,null,"A-1"]
[null,null,null,null,null,null,null,null,null,"A-2 *"]
[null,null,null,null,null,null,null,null,null,"A-3"]
[null,null,null,null,null,null,null,null,null,"A-4"]
[null,null,null,null,null,null,null,null,null,"A-5"]
[null,null,null,null,null,null,null,null,null,"A-6"]
[null,null,null,null,null,null,null,null,null,"A-7"]
[null,null,null,null,null,null,null,null,null,"A-8"]
[null,null,null,null,null,null,null,null,null,"A-9 *"]
[null,null,null,null,null,null,null,null,null,"A-10 *"]
[null,null,null,null,null,null,null,null,null,"A-11"]
[null,null,null,null,null,null,null,null,null,"A-12a"]
[null,null,null,null,null,null,null,null,null,"A-12b"]
[null,null,null,null,null,null,null,null,null,"A-12c"]
[null,null,null,null,null,null,null,null,null,"A-12d"]
[null,null,null,null,null,null,null,null,null,"25-9 A"]
[null,null,null,null,null,null,null,null,null,"25-9 B"]
[null,null,null,null,null,null,null,null,null,"25-9 C"]
[null,null,null,null,null,null,null,null,null,"25-9 D"]
[null,null,null,null,null,null,null,null,null,"25-9 E"]
[null,null,null,null,null,null,null,null,null,"25-9 F"]
[null,null,null,null,null,null,null,null,null,"25-9 G"]
[null,null,null,null,null,null,null,null,null,"25-9 H"]
[null,null,null,null,null,null,null,null,null,"25-9 I"]
[null,null,null,null,null,null,null,null,null,"26-5 A"]
[null,null,null,null,null,null,null,null,null,"26-5 B"]

{"sheet":"RR Codes HM 6-23","index":14,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,0,8,1]]}
["RESIDUAL RECEIPTS & GENERAL OPERATING             Connecticut Housing Finance Authority      "]
["DESCRIPTIVE CODES                                                                   Asset Management-Multifamily Housing "]
[]
["CHFA Form HM 6-23 (Rev. 07/2009)"]
["The following descriptions provide an outline of a number of conditions where draws from the Residual Receipt and/or General Operating Reserve Account may be deemed appropriate as promulgated in the HUD Handbook 4350.1 Chapters 25 and 26 .  Generally, releases are consistent with the Regulatory Agreement and the intent of the program under which the development was originally endorsed or approved. The request for withdrawal must be approved by HUD (as required).    "]
[]
[]
[]
[]
[]
["I.   CODES for ELIGIBLE ITEMS from RESIDUAL RECEIPTS"]
[]
["CODE","DESCRIPTION"]
["25-9 A","Reduce operating deficits when legitimate cash flow deficits exist, ie: offset increased operating expenses instead of increasing rental rates."]
["25-9 B","Make mortgage payment(s) when a mortgage default is actual or imminent."]
["25-9 C","Make repairs to the property not covered by the Replacement Reserve account."]
["25-9 D","Provide additional project amenities such as air conditioning, a sprinkler system, fire or smoke detectors, or energy saving devices."]
["25-9 E","Pay accrued, allowable distributions where insufficient surplus cash is available; provided 1.) No violations of the Regulatory Agreement 2.) No major unresolved findings 3.) Development is in acceptable physical condition."]
["25-9 F","Repay HUD/CHFA-approved Residual Receipts Notes if the development is financially solvent, well maintained, and in a stable market."]
["25-9 G","Repay Flexible Subsidy Operating Assistance or Capital Improvement Loans. "]
["25-9 H","Make enhancements to the development or retrofit units for Housing Accessibility under Section 504."]
["25-9 I","Provide for testing or abatement of lead-based paint at the development."]
[]
[]
["II. CODES for ELIGIBLE ITEMS from GENERAL OPERATING"]
[]
["CODE","DESCRIPTION"]
["26-5 A","To meet cash deficits caused by delinquent carrying charges *, or to finance the purchase of memberships or stock.  "]
["26-5 B","To make capital purchases where adequate replacement reserve funds are not available.  The GOR may be replenished with periodic payments over a reasonable term."]
[]
[]
["* Carrying Charges include:"]
["1.  Debt Service payments including principal, interest, mortgage insurance, or other required payments;"]
["2.  Taxes or assessments;"]
["3.  Fire or extended coverage insurance;"]
["4.  Water, electricity, heat, air conditioning, gas, garbage and trash collection and other utilities;"]
["5.  Required deposits to the Replacement Reserve Account;"]
["6.  Estimated cost of repairs, maintenance and replacements of the development's property; "]
["7.  The cost of all operating expenses of the development and services furnished; and"]
["8.  The cost of necessary management and administration."]