{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Status Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Instructions","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Fill in header &  Columns A- H from POP or MSAR approved DDIR"]
["Fill in columns I-X with current status / closeout data"]
["Sign & date then send to ERFO coordinator"]
["Repeat for each unit & disaster"]

{"sheet":"Status Report","index":1,"n_rows":21,"n_cols":24,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,12,1,15],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[0,0,0,21],[1,3,1,4],[1,17,1,18],[2,0,3,0],[2,1,3,1],[2,2,2,7],[2,8,2,11],[2,12,2,15],[2,16,3,16],[2,17,3,17]]}
["ERFO DISASTER REPAIR STATUS/CLOSEOUT REPORT  (Rev. Oct 2022)                          "]
["Disaster #:",null,"Total ER & PR:",{"$f":"F18","v":0},null,null,"Applicant:",null,null,null,null,"Sub-Applicant Unit:  ",null,null,null,null,"            Date:"]
["DDIR Report Name","FACILITY NAME","APPROVED PROGRAM OF PROJECT AMOUNT",null,null,null,null,null,"EMERGENCY REPAIRS\n OBLIGATIONS/ FINAL EXPENDITURES TO DATE BY UNIT",null,null,null,"PERMANENT REPAIRS\n OBLIGATIONS/ FINAL EXPENDITURES TO DATE BY UNIT",null,null,null,"TOTAL REPAIR OBLIGATION/ EXPENDITURE TO DATE","Design Phase Complete?","Contract Awarded?","CN Phase Complete?","(Anticipated/ Actual) Construction Completion Date","Does DDIR need to be revised?","DDIR Report Name","Comments/\nJustification"]
[null,null,"Applicant         Amount","Federal Lands Highway Division Office Amount"," Tribal Transportation Program Amount","TOTAL","Approved Method of Emergency Repairs","Approved Method of Permanent Repairs","ERFO funds used","Non-ERFO funds used","TOTAL","Method of Emergency Repairs Used","ERFO funds used","Non-ERFO funds used","TOTAL","Method of Permanent Repairs Used"]
[null,null,null,null,null,{"$f":"SUM(C5:E5)","v":0},null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,{"$f":"A5","v":0}]
[null,null,null,null,null,{"$f":"SUM(C6:E6)","v":0},null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,{"$f":"A6","v":0}]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,{"$f":"I5+J5","v":0},null,null,null,{"$f":"M5+N5","v":0},null,{"$f":"K5+O5","v":0},null,null,null,null,null,0]
[null,"Total",{"$f":"SUM(C5:C17)","v":0},{"$f":"SUM(D5:D17)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q5:Q17)","v":0}]
["The submitted expenditures are the actual costs incurred to complete only approved eligible repairs.  Include comments or justifications to explain any deviations or issues for each site."]
[]
["Digitally Sign Below"]