{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tab 1. Project Draw","Tab 2. Admin Draw","Dropdowns"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":2,"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":"Tab 1. Project Draw","index":0,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,7],[20,0,20,7],[7,1,7,2],[7,4,7,5],[6,0,6,7],[3,0,3,7],[4,1,4,2],[4,4,4,5],[19,0,19,4]]}
[" Texas Community Resiliency Program (CRP)\n PROJECT DRAW REQUEST FORM\nConstruction",null,null,null,null,null,null,null,"Validation Type List","Yes/No List","Cost Category List","Retainage Percentage for Calculation",null,"Total HOME Project Costs",{"$f":"TOTAL_HOME_BUDGET","v":0},"Draw Request Navigation Links"]
[]
["Instructions:  This Project Draw Request Form must be submitted with each Project draw request.  \n\nSteps:\n1.  Complete Subrecipient Information. \n2.  Complete Project Draw Information and Project Draw Detail.\n3.  Save with Housing Contract System (HCS) Project Draw #, Month & Year, and City/County in the title (example: 1 Oct 22 City of ABC CRP Project Draw form)."]
["SUBRECIPIENT INFORMATION"]
["Subrecipient:","City of ABC",null,"Contract #:","708000010XX",null,"Project Budget:",0]
[]
["PROJECT DRAW INFORMATION"]
["Draw Period Start Date:",null,null,"Draw Period End Date:",null,null,"HCS Project Draw #:"]
["PROJECT DRAW DETAIL",null,null,null,null,null,null,null,null,null,"Homebuyer Closing Cost - Homebuyer Loan",1]
["Column A\nHCS Project Draw \nRequest Number","Column B\nCost Category\n(select all that apply)","Column C\nValidation Type / Supporting Documentation","Column D\nInvoice # or \nPayment Application #","Column E\nInvoice Date or\nPayment Application Date","Column F\nCost Incurred / Invoice Amount\n","Column G\nNon CDBG-CV Funds Utilized\n(if applicable)\n","Column H\nProject Draw Request Amount*",null,"Appraisal",1]
[null,null,null,null,null,0,0,{"$f":"SUM(F11-G11)","v":0},null,"Title Work",1]
[null,null,null," "," ",0,0,{"$f":"SUM(F12-G12)","v":0}," ","Tax Certificate",1]
[null,null,null,null," ",0,0,0,null,"Recording Fees",1]
[null,null,null," "," ",0,0,0,null,"Survey",1]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[null,null,null," "," ",0,0,0,null,"Insurance/Other Closing Requirements",1]
[null,null,null,null,null,0,0,0]
["Totals:",null,null,null,null,{"$f":"SUM(F11:F19)","v":0},{"$f":"SUM(G11:G19)","v":0},{"$f":"SUM(H11:H19)","v":0}]
["* Per the Construction Contract, retainage of 10% is required and must be identified in each construction draw request invoice.  \n   Retainage will be tracked by TDHCA Staff based on the AIA form submitted with each project draw."]

{"sheet":"Tab 2. Admin Draw","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,5],[3,0,3,5],[6,0,6,5],[19,0,19,4]]}
["Texas Community Resiliency Program (CRP)\nADMIN DRAW REQUEST FORM\nConstruction"]
[]
["Instructions:  This Admin Draw Request Form must be submitted with each Admin draw request. \n\nSteps:\n1.   Subrecipient Information will pre-fill from Tab 1.\n2.   Complete Admin Budget, Admin Draw Information, and Admin Draw Detail.\n3.   Save with Housing Contract System (HCS) Admin Draw #, Month & Year, and City/County in the title (example: 1 Oct 22 City of ABC CRP Admin Draw form)."]
["SUBRECIPIENT INFORMATION"]
[{"$f":"'Tab 1. Project Draw'!$A$5","v":"Subrecipient:"},{"$f":"'Tab 1. Project Draw'!$B$5","v":"City of ABC"},"Contract #:",{"$f":"'Tab 1. Project Draw'!$E$5","v":"708000010XX"},"Admin Budget :",0]
[]
["ADMIN DRAW INFORMATION"]
["Draw Period Start Date:",null,"Draw Period End Date:",null,"HCS Admin Draw #:"]
["ADMIN DRAW DETAIL"]
["Column A\nHCS Admin Draw \nRequest Number","Column B\nCost Category","Column C\nValidation Type / Supporting Documentation","Column D\nInvoice Number","Column E\nInvoice \nDate","Column F\nAdmin Draw\nRequest Amount"]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null," "," ",0]
[null,null,null," "," ",0]
[null,null,null," "," ",0]
[null,null,null," "," ",0]
[null,null,null," "," ",0]
[null,null,null," "," ",0]
[null,null,null,null,null,0]
["Total: ",null,null,null,null,{"$f":"SUM(F11:F19)","v":0}]

{"sheet":"Dropdowns","index":2,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Column1"]
["Demolition/Clearance"]
["Site improvements"]
["Rehabilitation"]
["New construction"]
["Construction contingency (10% approx.) "]
["Architect/Engineer fees"]
["Environmental Reports "]
["Soil Testing"]
["Bid Advertisement cost"]
["Printing"]
["Other Prof. fees (Appraisal, ADA, etc.)"]
["Zoning "]
["Construction Certifications (TDLR, Windstorm)"]
["Other pre-construction or construction period costs"]
["Other"]