{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["When to use this form","CDO Submission Form 12","Backfilling Data","CDO Data "],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":6,"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":"When to use this form","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["This CDO FORM 12 is to be used: \n- for eligible disasters occurring up to 31 October 2018\n- by local governments and State agencies  \n- to seek reimbursement of the actual extraordinary costs of Counter Disaster Operations (CDO) undertaken in direct response to the eligible disaster \n- to meet the eligibility requirements for funding under the Queensland Disaster Relief and Recovery Arrangements Guidelines.  "]
[]
[]
["What are CDO activities? "]
["Counter Disaster Operations (CDO) are the activities undertaken by local and state government agencies to alleviate personal hardship and distress, by addressing the immediate emergency needs of individuals and for the protection of the general public."]
["CDO activities are undertaken immediately before, during and immediately after a disaster event."]
["More information:"]
["Queensland Disaster Relief and Recovery Arrangements Guidelines (QDRRA) October 2017 "]
["Commonwealth Natural Disaster Relief and Recovery Arrangements (NDRRA) Determination 2017"]
["http://qldreconstruction.org.au/ndrra"]

{"sheet":"CDO Submission Form 12","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,11],[0,9,0,12],[0,0,0,8],[24,1,24,11],[2,4,2,10],[2,1,2,3],[4,4,4,10],[25,2,25,4]]}
["Counter Disaster Operations ",null,null,null,null,null,null,null,null,"FORM 12 CDO "]
["Version: 18 October 2018"]
[null,"NDRRA Event: "]
[]
[null,"Local Government/State Agency: "]
[]
[null,"Organisation Ref.","Activity start date","Activity end date ","CDO Activity undertaken to assist individuals or the general public \n(select from drop down list)","Activity Location\n","Cost Type \n(select from drop down list)","General Ledger/ Report Ref.","External Service Provider","Reference / Invoice #","Value \n($ excl. GST)","Justification \n"]
[null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Insert additional lines above as required",null,null,null,null,null,null,null,"Total:",{"$f":"SUM(K8:K22)","v":0}]
[]
[null,"I certify that \n-  the CDO activities completed were directly related to the activated eligible disaster and comply with the Queensland Disaster Relief and Recovery Arrangements (QDRRA), and the Natural Disaster Relief and Recovery Arrangements (NDRRA) Determination \n- all relevant evidence of the expenditures undertaken provided with this submission relate to the activated eligible disaster  \n- no ordinary wages / salaries have been included in this submission nor any other costs that are ineligible under the QDRRA Guidelines \n- all claimed amounts exclude GST.  "]
[null,"Accountable Officer:",null,null,null,null,"Signature:",null,null,"Date:"," ______/______/______"]
[]
[null,"This information is being collected for the purposes of funding, management and reporting of reconstruction activities.  This information is collected pursuant to Part 2, Division 2 of the Queensland Reconstruction Authority Act 2011.  The information may be disclosed to the Commonwealth Government and Queensland Government agencies, departments and statutory authorities as required."]

{"sheet":"Backfilling Data","index":2,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,1,1,5],[1,6,1,8]]}
[" Staff details supporting backfilling costs claimed in Form 12"]
[null,"Deployee Details",null,null,null,null,"Backfilling Staff Details"]
["Organisation Ref.\n(from Form 12)","\nName or ID number of staff deployee undertaking eligible CDO activities\n","CDO duties undertaken","Location/s of CDO deployment"," Date from","Date to","Name or ID number of staff member backfilling for the CDO deployee ","Date from\n","Date to\n"]

{"sheet":"CDO Data ","index":3,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["CDO Activity",null,null,"Cost Type"]
[]
["Cleaning / refilling potable water / septic tanks to make residences safe and habitable","A",null,"Aircraft hire "]
["Construction of temporary barrier to protect the community (to protect the general public)","B",null,"Aircraft standby charges "]
["Counselling - Personal or psychological first aid counselling for members of the impacted community or disaster response personnel","A",null,"Catering "]
["Damage assessments of residential properties ","A",null,"Contractor costs / service providers  "]
["Disaster Coordination Centre/Disaster Management Group (establishment and operation)","B",null,"Hire of additional plant and equipment  "]
["Evacuation and care of companion animals where owner has been evacuated from residence","A",null,"Hire of buildings, including rent and power costs"]
["Evacuation centre, place of refuge, cyclone shelter (establishment, operation and de-commissioning)","A",null,"Publication/printing costs "]
["Evacuation of threatened/impacted individuals ","A",null,"Purchase of asset to meet CDO operational requirements - provide details in Justification cell"]
["Firefighting activities ","B",null,"Purchase of operational consumables required / exhausted during activity- e.g. ropes, sandbags, tarps, PPE"]
["Instructing/advising residents e.g. evacuations, health and safety, access","A",null,"Repairs and additional servicing to internal plant and equipment "]
["Operational activities to protect and maintain public safety  ","B",null,"Repairs to assets directly damaged while undertaking CDO activity"]
["Reconnaissance activities to inform emergency response for the community ","B",null,"Replacement of damaged or lost equipment / or uninsured stolen equipment"]
["Removal / trimming of disaster damaged trees threatening residential properties to make them safe and habitable","A",null,"Staffing - backfilling costs- please complete backfilling data tab"]
["Removal of hazardous materials (e.g. asbestos) from event damaged residences to make them safe and habitable ","A",null,"Staffing - extraordinary wages, overtime, allowances"]
["Residential clean up operations (green waste, damaged household materials/goods) to prevent displacement of residents","A",null,"Transportation costs - equipment, materials, medical, resupply "]
["Resupply to isolated community - in accordance with the Queensland Resupply Guidelines ","B",null,"Travel, accommodation, meals "]
["Resupply to isolated individuals - in accordance with the Queensland Resupply Guidelines ","A",null,"Other - provide details of cost in Justification cell "]
["Sandbagging operations to prevent inundation of residential properties","A"]
["Search and rescue operations","A"]
["Tarping residences to make them safe and habitable ","A"]
["Temporary accommodation assessment of needs for persons displaced by the disaster ","A"]
["Temporary accommodation for disaster displaced persons ","A"]
["Temporary dump sites for residential related debris - establishment, operation and decommissioning","A"]
["Vector control in residential areas to protect the community ","B"]
["Other - please specify in Justification cell"]