{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DOB"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"DOB","index":0,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":false,"merged":[[52,0,53,1],[32,0,32,2],[25,0,25,1],[55,0,55,3],[16,1,16,3],[17,1,17,3],[20,0,20,2],[21,0,21,2],[35,0,35,2],[36,0,36,2],[19,0,19,3],[23,0,23,2],[24,0,24,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[34,0,34,2],[38,0,38,3],[39,0,39,2],[40,0,42,3],[0,0,5,3],[6,0,8,3],[9,0,11,3],[14,1,14,3],[15,1,15,3],[22,0,22,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[33,0,33,2]]}
["                                                                                                                               Texas General Land Office\n                                                                                                                    Community Development and Revitalization\n                                                                                                                                         Duplication Of Benefits (DOB) Calculation Form"]
[]
[]
[]
[]
[]
["The DOB Calculation Form must document the total DOB amount per household/property. All DOB calculated must follow the latest Clarification of Duplication of Benefits requirements under the Stafford Act for Community Development Block Grant  (CDBG) Disaster Recovery Grantees (71060 Federal Register/Vol. 76, No. 221/ Wednesday, November 16, 2011/Notices and 42 U.S.C. 5155 Section 312 of the Robert T. Stafford Disaster Assistance and Emergency Relief Act, as amended)."]
[]
[]
["Subrecipient or State Representative must first determine the applicant's total post-disaster recovery need (based on actual bid and program caps). Then the Subrecipient or State Representative must reduce the determined need by funding previously received for the same purposes. The applicant will need to pay back funds or take a reduction in scope to proceed with assistance."]
[]
[]
[]
["Subrecipient/State Representative:",null,"Contract #:"]
["Applicant ID:"]
["Applicant Name:"]
["Co-Applicant Name:"]
["Applicant Address:"]
[]
["Calculation of Eligible Award"]
["1. Identify Applicant's Total Need Prior to Any Assistance (ex: Recon Cost, Acquisition payoff amount)",null,null,0]
["2. Identify All Potentially Duplicative Assistance"]
["       a. FEMA Housing Repair",null,null,0]
["       b. SBA",null,null,0]
["       c. Insurance",null,null,0]
["       d. Other (ex: nonprofit, charity, etc.). Please provide funding source:",null,null,0]
["       Received Assistance Total",null,null,{"$f":"SUM(D23:D26)","v":0}]
["3. Expenditures (Receipts/Support Documentation)"]
["       a.Receipts or confirmation of repairs with Inspection Report",null,null,0]
["       b. Forced Mortgage Payoff",null,null,0]
["       c. Contractor Fraud",null,null,0]
["       Expenditure Total",null,null,{"$f":"SUM(D29:D31)","v":0}]
["4. Deduct Assistance Determined to be Duplicative (Received Assistance Total Minus Expenditure Total)",null,null,{"$f":"MAX(0,D27-D32)","v":0}]
["5. Funding Adjustments"]
["       a. Applicant Provided Funding",null,null,0]
["       Total Adjustments",null,null,{"$f":"SUM(D35:D35)","v":0}]
["6. Maximum Eligible Award (Item 1 minus Item 4 plus Item 5)",null,null,{"$f":"D21-D33+D36","v":0}]
[]
["Exception Acknowledgment"]
["Applicant owes funding or is taking a reduction in scope of work (YES/NO):",null,null,{"$f":"IF(D37<D21, \"Yes\", \"No\")","v":"No"}]
["The Stafford Act has been explained to me and I understand that a gap exists between funding sources I have received and the CDBG benefit that I\nwould otherwise qualify for. To utilize multiple federal funding sources without resulting in a Duplication of Benefit, I understand an exception to the\nstandard specifications will need to be made to the home in order to provide a solution while still maintaining a safe sanitary home. If an exception is needed the following items were lessened from the original scope of work."]
[]
[]
["Original Project Cost","Items/Scope Removed, Changed, or Reduced","Description of Change","Cost"]
[]
[]
[]
[]
[]
[]
[null,null,"Total",{"$f":"SUM(D45:D50)","v":0}]
[]
["I/We confirm I/we have no other option to pay the Gap owed and I/we are opting for a lesser option as described above. Please Initial (Applicant and Co-Applicant (If Applicable)):",null,"Applicant:"]
[null,null,"Co-Applicant (If Applicable):"]
[]
["Under penalties of perjury, I/we certify that the information presented in this document is true and accurate to the best of my knowledge and belief. I/We further understand that providing false representations herein constitutes an act of fraud. False, misleading or incomplete information may result in my ineligibility to participate in this program or any other programs that will accept this document Additionally, if I/we receive future funding for the same purpose of the CDBG-DR funds, I/we will agree to repay the assistance that was duplicated. Warning: Any person who knowingly makes a false claim or statement to HUD may be subject to civil or criminal penalties under 18 U.S.C. 287, 1001 and 31 U.S.C. 3729."]
["Signature of Applicant:",null,"Date:"]
["Signature of Co-Applicant:",null,"Date:"]
["Signature of Builder:",null,"Date:"]
["Signature of Subrecipient or State Representative:",null,"Date:"]
[]
["DOB Calculation Form"]
["April 2019"]