{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CRF Note","summary","Cost details"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"CRF Note","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["CRF 9"]
["Catchment Restoration Fund - Cost Statement"]
["This worksheet (CRF 9) is used for recording your project expenditure. It it same as the CRF 3 claim form - the appendix 1."]
["You just need to fill in either this worksheet or appendix 1"]
["All the project costs should be included even they are funded by your own contribution or benefit in kind by another organisation."]
["Please ensure the 'summary' sheet, the actual total is matched to your 'cost details' sheet total"]
[]
[]
["In regarding to staff cost, we also have other templates to help you fill the rel;evant information"]
["- manpower rate calculation model"]
["- timesheet"]

{"sheet":"summary","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[32,1,32,3]]}
["Organisation name :",null,null,null,"Claim No :"]
["Project name :",null,null,null,"Period :"]
["Scheme No :",null,null,null,"Grant Rate :"]
[]
["Summary",{"$f":"\"Total of Claim No. \" & +F1","v":"Total of Claim No. "},"Last Accumulated Total","Accumulated Claims Total","Approved Budget","Variance"]
["Direct Costs : ",{"$f":"SUM(D14:D19)","v":0},null,{"$f":"+C6+B6","v":0},null,{"$f":"+E6-D6","v":0}]
["External Expertise :",{"$f":"SUM(D21:D23)","v":0},null,{"$f":"+C7+B7","v":0},null,{"$f":"+E7-D7","v":0}]
["Indirect Costs :",{"$f":"SUM(D25:D28)","v":0},null,{"$f":"+C8+B8","v":0},null,{"$f":"+E8-D8","v":0}]
["Others :",{"$f":"SUM(D30:D31)","v":0},null,{"$f":"+C9+B9","v":0},null,{"$f":"+E9-D9","v":0}]
["total",{"$f":"SUM(B6:B9)","v":0},{"$f":"SUM(C6:C9)","v":0},{"$f":"SUM(D6:D9)","v":0},{"$f":"SUM(E6:E9)","v":0},{"$f":"SUM(F6:F9)","v":0}]
[]
["Summary by Expenses or budget Type","Expenditures","3 months estimated costs in advance (if required)",{"$f":"\"Total of Claim No. \" & +F1","v":"Total of Claim No. "}]
["Direct Costs : "]
["Staff salaries/costs",{"$f":"SUMPRODUCT((A14='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,{"$f":"+B14+C14","v":0}]
["Material, equipment and machinery",{"$f":"SUMPRODUCT((A15='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,0]
["Travel , accommodation and subsistence",{"$f":"SUMPRODUCT((A16='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,0]
["Meetings and conferences",{"$f":"SUMPRODUCT((A17='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,0]
["Compensation payments",{"$f":"SUMPRODUCT((A18='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,0]
["Others Direct costs",{"$f":"SUMPRODUCT((A19='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,0]
["External Expertise :"]
["Contractors",{"$f":"SUMPRODUCT((A21='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,{"$f":"+B21+C21","v":0}]
["Professional fees (Audit, consultancy etc)",{"$f":"SUMPRODUCT((A22='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,{"$f":"+B22+C22","v":0}]
["Others External costs",{"$f":"SUMPRODUCT((A23='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,{"$f":"+B23+C23","v":0}]
["Indirect Costs :"]
["Rent",{"$f":"SUMPRODUCT((A25='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,{"$f":"+B25+C25","v":0}]
["Utilities",{"$f":"SUMPRODUCT((A26='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,{"$f":"+B26+C26","v":0}]
["Insurance",{"$f":"SUMPRODUCT((A27='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,{"$f":"+B27+C27","v":0}]
["Others indirect costs",{"$f":"SUMPRODUCT((A28='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,{"$f":"+B28+C28","v":0}]
["Others :"]
["Irrecoverable VAT ",{"$f":"SUMPRODUCT((A30='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,{"$f":"+B30+C30","v":0}]
["Others",{"$f":"SUMPRODUCT((A31='Cost details'!$H$6:$H$51)*('Cost details'!$M$6:$M$51))","v":0},null,{"$f":"+B31+C31","v":0}]
["total",{"$f":"SUM(B13:B30)","v":0},{"$f":"SUM(C13:C30)","v":0},{"$f":"SUM(D13:D30)","v":0}]
["© Environment Agency 2012","Appendix 1 - project expenditure summary",null,null,null,"CRF9 ver 1"]

{"sheet":"Cost details","index":2,"n_rows":132,"n_cols":14,"rows_kept":132,"cut":false,"hidden":false,"merged":[[51,0,51,8],[1,12,1,13],[0,0,0,2],[1,0,1,2],[0,3,0,10],[1,3,1,10],[2,0,2,2],[2,4,2,10],[2,11,2,12]]}
["Organisation name :",null,null,{"$f":"+summary!B1","v":0},null,null,null,null,null,null,null,"Claim No :",{"$f":"+summary!F1","v":0}]
["Project name :",null,null,{"$f":"+summary!B2","v":0},null,null,null,null,null,null,null,"Period :",{"$f":"+summary!F2","v":0}]
["Scheme No :",null,null,{"$f":"+summary!B3","v":0}]
["Ref","your ref","Date ","Invoice No, ref or type of docurement","Supplier or employee Name","Description of expenditure",null,"Budget Heading / Exp Type","amount or unit or hour","rate per unit (if applicable)","Gross Amount","VAT","Net Amount £","evidence attached  (Y/N)"]
[]
["INV-1",null,null,null,null,null,{"$f":"IF(M6<>0,IF(ISBLANK(H6),\"***\",\"\"),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(J6),I6,I6*J6)","v":0},null,{"$f":"+K6-L6","v":0}]
["INV-2",null,null,null,null,null,{"$f":"IF(M7<>0,IF(ISBLANK(H7),\"***\",\"\"),\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(J7),I7,I7*J7)","v":0},null,{"$f":"+K7-L7","v":0}]
["INV-3",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-3",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-3",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-4",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-5",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-6",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-10",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-11",null,null,null,null,null,"",null,null,null,0,null,{"$f":"+K15-L15","v":0}]
["INV-12",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-13",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-14",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-15",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-16",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-17",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-18",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-19",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-20",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-21",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-22",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-23",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-24",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-25",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-26",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J30),I30,I30*J30)","v":0},null,{"$f":"+K30-L30","v":0}]
["INV-27",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-28",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-29",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-30",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-31",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-32",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-33",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-34",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-35",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-36",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-37",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-38",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-39",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-40",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-41",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-42",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-43",null,null,null,null,null,null,null,null,null,0,null,0]
["INV-44",null,null,null,null,null,"",null,null,null,0,null,0]
["INV-27",null,null,null,null,null,null,null,null,null,0,null,{"$f":"+K49-L49","v":0}]
["INV-28",null,null,null,null,null,null,null,null,null,0,null,{"$f":"+K50-L50","v":0}]
["Please do not use this row for data entry. You can insert extra rows at row 48 for addition records. Please make sure you have copied the last row formula to the new inserted rows."]
["© Environment Agency 2012",null,null,null,null,null,null,null,null,"total",{"$f":"SUM(K5:K51)","v":0},{"$f":"SUM(L5:L51)","v":0},{"$f":"SUM(M5:M51)","v":0},{"$f":"IF((+M52-summary!$B$32)<>0,\"*** expenditure type on column H missed\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Staff salaries/costs"]
["Material, equipment and machinery"]
["Travel , accommodation and subsistence"]
["Meetings and conferences"]
["Compensation payments"]
["Others Direct costs"]
["Contractors"]
["Professional fees (Audit, consultancy etc)"]
["Others External costs"]
["Rent"]
["Utilities"]
["Insurance"]
["Others indirect costs"]
["Irrecoverable VAT "]
["Others"]