{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Version Control","Admin Check Approval","Admin Check Summary","Delivery Agent Payments","F - (FT) Staff Costs","F - (PT) Staff Costs","Unit Costs","F - Direct Costs","A - Procured","A - WS - Reimbursement","A - Wage Subsidies","A - Grant - Stage 1","A - Grant - Stage 2","A - Graduate Placement - Stage1","A - Graduate Placement - Stage2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":15,"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":"Version Control","index":0,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[13,0,13,3],[14,0,14,3],[16,0,16,3],[17,0,17,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["European Structural and Invesment Funds "]
["2014 - 2020 Programme"]
[]
["Verification Cost Check Template"]
["ERDF & ESF Use"]
["Version Control"]
[]
["Date","Issue","Change Made","Author"]
["2016-07-01",1,"First issue at Designation","David Anderson"]
["2017-02-27",2,"Second issue","David Anderson"]
["2017-12-12",2.1,"MCS Review Changes - adding version control","Tracey Gillon"]
["2018-03-01",3,"Issue","Tracey Gillon"]
["2018-05-02",4,"Expanding Explanation of Ineligible Columns","Kayleigh McLean"]
["2018-11-25",4.0999999999999996,"Adding Part Time Staff Tab, removing 'Notes for Use', clarifying eligible column, cosmetic changes","Kayleigh McLean"]
["2019-02-15",5,"Issue","Kayleigh McLean"]
["2019-07-24",5.0999999999999996,"Additional sample requirement added to admin check approval with reviewer sign off. Formulas updated in Admin Check Summary to remove “n/a” and “0” options. Employment evidence and NI/Pension apportionment columns added to staff cost tabs. Treatment of errors columns added to all tabs.\nPricing schedule column added to Procurement tab.\n","Iain Aitchison"]
["2019-09-23",6,"Issue","Tracey Gillon"]
["2020-03-16",6.1,"Update for Pricing Schedule - additional column and change to name under Procured tab","Pauline Taylor"]
["2020-03-18",7,"Issue","Tracey Gillon"]
["2020-03-23",7.1,"Adding in new columns to Summary tab for Article Check Completion","Kayleigh McLean"]
["2020-03-23",7.2,"Adding in link to NMW and NLW to Wage Subsidies tab and changing order of Wage Subsidies and WS - Reimbursement tabs","Kayleigh McLean"]
["2020-03-24",7.3,"Adding Unit Cost Tab","Kayleigh McLean"]
["2020-03-25",7.4,"Correcting Formulas in PT Staff Costs and Direct Costs","Kayleigh McLean"]
["2020-03-30",8,"Issue","Tracey Gillon"]
["2020-07-27",8.1,"Adding SPCM check columns at each tab, and sign-off box in admin check approval tab","Tracey Gillon"]
["2020-08-13",9,"Issue","Tracey Gillon"]
["2020-10-02",9.1,"Update to procured cost tab - update to column headings","Pauline Taylor, Tracey Gillon"]
["2020-10-09",10,"Issue","Tracey Gillon"]
["2020-10-13",11,"Fixing the total formulas on the bottom of each tab.  Figures had a rounding formula which did not give true overclaim/underclaim figures","Kayleigh McLean"]
["2020-11-26",12,"Adding in a Total Rejected Costs column in the Admin Check Summary to allow staff to enter the figure in the article check","Kayleigh McLean"]
["2021-05-03",13,"Adding in Net Correction to Procured tab, updating Grant Stage 1 and 2 in line with updated DI and updating the formulas on the Summary and Admin Check Approval tabs to take account of the new columns","Kayleigh McLean, Tracey Gillon, Simon Macken"]
["2021-06-14",14,"Adding Graduate Placement Tabs","Tracey Gillon/Kayleigh McLean"]

{"sheet":"Admin Check Approval","index":1,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,29,12],[25,1,25,4],[25,5,25,7],[25,8,25,12],[24,0,24,12],[20,5,20,7],[21,5,21,7],[22,5,22,7],[13,10,13,12],[14,10,14,12],[20,8,20,12],[21,8,21,12],[22,8,22,12],[15,5,15,7],[15,8,15,12],[16,5,16,7],[16,8,16,12],[17,5,17,7],[17,8,17,12],[10,5,10,9],[9,5,9,9],[9,10,9,12],[10,10,10,12],[12,10,12,12],[0,0,0,7],[2,1,2,7],[3,1,3,7],[19,0,19,12],[10,0,10,1],[14,0,14,1],[10,2,10,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[4,1,4,7],[6,1,6,7],[7,1,7,7],[14,5,14,9],[13,5,13,9],[12,5,12,9],[20,1,20,4],[21,1,21,4],[22,1,22,4],[9,0,9,1],[12,0,12,1],[13,0,13,1],[9,2,9,4],[15,0,16,1],[15,2,16,4]]}
["European Structural Funds - Artice 125 (5)(a) Administrative Verification"]
[]
["SI Lead Partner"]
["SI Project Reference"]
["SI Title"]
[]
["Claim Reference"]
["Date Submitted"]
[]
["Number of Items Claimed",null,null,null,null,"Number of Items Selected",null,null,null,null,{"$f":"'Admin Check Summary'!F15","v":0}]
["Amount Claimed (£)",null,null,null,null,"Amount Selected (£)",null,null,null,null,{"$f":"'Admin Check Summary'!E15","v":0}]
[]
["Eligible Items",null,{"$f":"'Admin Check Summary'!M15","v":0},null,null,"Eligible Items (%)",null,null,null,null,{"$f":"IF(ISERROR(C13/K10),\"TBC\",(C13/K10))","v":"TBC"}]
["Ineligible Items",null,{"$f":"K10-C13","v":0},null,null,"Error Rate (%)",null,null,null,null,{"$f":"IF(ISERROR(K15/K11),\"TBC\",K15/K11)","v":"TBC"}]
["Eligible Expenditure (£)",null,{"$f":"K11-K15","v":0},null,null,"Ineligible Exp/Audit Trail/Other-Overclaim (£)",null,null,null,null,{"$f":"'Admin Check Summary'!K15","v":0}]
["Additional Verification Checks Required (Y/N)",null,null,null,null,"Reviewer Name:"]
[null,null,null,null,null,"Position:"]
[null,null,null,null,null,"Date Complete:"]
[]
["A representative of The Scottish Government has checked the evidence provided by this Lead Partner to verify the costs included within the Verification and recorded the findings on this report in accordance with agreed procedures.  A review of this check has also been completed.  The name of the SG Representatives, for the purpose of segregation of duties is shown here."]
["Checker Name:",null,null,null,null,"Reviewer Name:"]
["Position:",null,null,null,null,"Position:"]
["Date Complete:",null,null,null,null,"Date Complete:"]
[]
["As the Senior Portfolio and Compliance Manager, I confirm that I have undertaken all necessary checks (as detailed in the MA Claims Process Desk Instruction) for this claim. "]
["SPCM Name:",null,null,null,null,"Date Complete:"]
["Comments:"]

{"sheet":"Admin Check Summary","index":2,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["European Structural Funds - Artice 125 (5)(a) Administrative Verification - Operation(s) Summary Sheet"]
[]
[]
["Operation Title","Operation Reference","Risk Rating Level","Amount Claimed (£)","Amount Selected\n(£)","Items Selected","Amount Selected (%)","Ineligible Expenditure\n(£)","Audit trail\n(£)","Other – Overclaim (£)","Total Ineligible Exp/Audit/Other\n(£)","Total Expenditure Rejected (£)","Items Verified as Eligible for Payment","Items Rejected","Error Rate","Revised Total Claim Expenditure (£)"]
[null,null,null,null,{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,A5,'F - (FT) Staff Costs'!F:F)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,A5,'F - (PT) Staff Costs'!F:F)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A5,'F - Direct Costs'!F:F)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,A5,'A - Procured'!F:F)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!B:B,A5,'A - Wage Subsidies'!F:F)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,A5,'A - Grant - Stage 1'!F:F)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,A5,'A - Graduate Placement - Stage1'!F:F))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIF('F - (FT) Staff Costs'!$B:$B,A5)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIF('F - (PT) Staff Costs'!$B:$B,A5)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIF('F - Direct Costs'!$B:$B,$A5)\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIF('A - Procured'!$B:$B,A5)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIF('A - Wage Subsidies'!$B:$B,A5)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIF('A - Grant - Stage 1'!$B:$B,A5)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIF('A - Graduate Placement - Stage1'!$B:$B,A5))))))))","v":0},{"$f":"IF(ISERROR(E5/D5),\"0%\",E5/D5)","v":"0%"},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A5,'F - (FT) Staff Costs'!U:U)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A5,'F - (PT) Staff Costs'!AB:AB)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A5,'F - Direct Costs'!Q:Q)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A5,'A - Procured'!AA:AA)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A5,'A - Wage Subsidies'!AC:AC)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A5,'A - Grant - Stage 1'!AA:AA)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A5,'A - Graduate Placement - Stage1'!AB:AB))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A5,'F - (FT) Staff Costs'!V:V)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A5,'F - (PT) Staff Costs'!AC:AC)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A5,'F - Direct Costs'!R:R)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A5,'A - Procured'!AB:AB)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A5,'A - Wage Subsidies'!AD:AD)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A5,'A - Grant - Stage 1'!AB:AB)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A5,'A - Graduate Placement - Stage1'!AC:AC))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A5,'F - (FT) Staff Costs'!W:W)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A5,'F - (PT) Staff Costs'!AD:AD)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A5,'F - Direct Costs'!S:S)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A5,'A - Procured'!AC:AC)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A5,'A - Wage Subsidies'!AE:AE)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A5,'A - Grant - Stage 1'!AC:AC)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A5,'A - Graduate Placement - Stage1'!AD:AD))))))))","v":0},{"$f":"SUM(H5:J5)","v":0},{"$f":"SUMIFS('F - (FT) Staff Costs'!F:F,'F - (FT) Staff Costs'!S:S,\"Yes\",'F - (FT) Staff Costs'!B:B,A5)\n+SUMIFS('F - (PT) Staff Costs'!F:F,'F - (PT) Staff Costs'!Z:Z,\"Yes\",'F - (PT) Staff Costs'!B:B,A5)\n+SUMIFS('F - Direct Costs'!F:F,'F - Direct Costs'!O:O,\"Yes\",'F - Direct Costs'!B:B,A5)\n+SUMIFS('A - Procured'!F:F,'A - Procured'!Y:Y,\"Yes\",'A - Procured'!B:B,A5)\n+SUMIFS('A - Wage Subsidies'!F:F,'A - Wage Subsidies'!AA:AA,\"Yes\",'A - Wage Subsidies'!B:B,A5)\n+SUMIFS('A - Grant - Stage 1'!F:F,'A - Grant - Stage 1'!Y:Y,\"Yes\",'A - Grant - Stage 1'!B:B,A5)\n+SUMIFS('A - Graduate Placement - Stage1'!F:F,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\",'A - Graduate Placement - Stage1'!B:B,A5)","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A5,'F - (FT) Staff Costs'!S:S,\"No\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A5,'F - (PT) Staff Costs'!Z:Z,\"No\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A5,'F - Direct Costs'!O:O,\"No\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A5,'A - Procured'!Y:Y,\"No\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A5,'A - Wage Subsidies'!AA:AA,\"No\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A5,'A - Grant - Stage 1'!Y:Y,\"No\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A5,'A - Graduate Placement - Stage1'!Z:Z,\"No\"))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A5,'F - (FT) Staff Costs'!S:S,\"Yes\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A5,'F - (PT) Staff Costs'!Z:Z,\"Yes\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A5,'F - Direct Costs'!O:O,\"Yes\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A5,'A - Procured'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A5,'A - Wage Subsidies'!AA:AA,\"Yes\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A5,'A - Grant - Stage 1'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A5,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\"))))))))","v":0},{"$f":"IF(ISERROR(SUM(H5:J5)/E5),\"TBC\",SUM(H5:J5)/E5)","v":"TBC"},{"$f":"D5-L5","v":0}]
[null,null,null,null,{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,A6,'F - (FT) Staff Costs'!F:F)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,A6,'F - (PT) Staff Costs'!F:F)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A6,'F - Direct Costs'!F:F)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,A6,'A - Procured'!F:F)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!B:B,A6,'A - Wage Subsidies'!F:F)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,A6,'A - Grant - Stage 1'!F:F)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,A6,'A - Graduate Placement - Stage1'!F:F))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIF('F - (FT) Staff Costs'!$B:$B,A6)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIF('F - (PT) Staff Costs'!$B:$B,A6)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIF('F - Direct Costs'!$B:$B,$A6)\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIF('A - Procured'!$B:$B,A6)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIF('A - Wage Subsidies'!$B:$B,A6)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIF('A - Grant - Stage 1'!$B:$B,A6)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIF('A - Graduate Placement - Stage1'!$B:$B,A6))))))))","v":0},"0%",{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A6,'F - (FT) Staff Costs'!U:U)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A6,'F - (PT) Staff Costs'!AB:AB)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A6,'F - Direct Costs'!Q:Q)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A6,'A - Procured'!AA:AA)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A6,'A - Wage Subsidies'!AC:AC)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A6,'A - Grant - Stage 1'!AA:AA)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A6,'A - Graduate Placement - Stage1'!AB:AB))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A6,'F - (FT) Staff Costs'!V:V)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A6,'F - (PT) Staff Costs'!AC:AC)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A6,'F - Direct Costs'!R:R)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A6,'A - Procured'!AB:AB)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A6,'A - Wage Subsidies'!AD:AD)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A6,'A - Grant - Stage 1'!AB:AB)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A6,'A - Graduate Placement - Stage1'!AC:AC))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A6,'F - (FT) Staff Costs'!W:W)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A6,'F - (PT) Staff Costs'!AD:AD)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A6,'F - Direct Costs'!S:S)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A6,'A - Procured'!AC:AC)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A6,'A - Wage Subsidies'!AE:AE)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A6,'A - Grant - Stage 1'!AC:AC)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A6,'A - Graduate Placement - Stage1'!AD:AD))))))))","v":0},{"$f":"SUM(H6:J6)","v":0},{"$f":"SUMIFS('F - (FT) Staff Costs'!F:F,'F - (FT) Staff Costs'!S:S,\"Yes\",'F - (FT) Staff Costs'!B:B,A6)\n+SUMIFS('F - (PT) Staff Costs'!F:F,'F - (PT) Staff Costs'!Z:Z,\"Yes\",'F - (PT) Staff Costs'!B:B,A6)\n+SUMIFS('F - Direct Costs'!F:F,'F - Direct Costs'!O:O,\"Yes\",'F - Direct Costs'!B:B,A6)\n+SUMIFS('A - Procured'!F:F,'A - Procured'!Y:Y,\"Yes\",'A - Procured'!B:B,A6)\n+SUMIFS('A - Wage Subsidies'!F:F,'A - Wage Subsidies'!AA:AA,\"Yes\",'A - Wage Subsidies'!B:B,A6)\n+SUMIFS('A - Grant - Stage 1'!F:F,'A - Grant - Stage 1'!Y:Y,\"Yes\",'A - Grant - Stage 1'!B:B,A6)\n+SUMIFS('A - Graduate Placement - Stage1'!F:F,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\",'A - Graduate Placement - Stage1'!B:B,A6)","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A6,'F - (FT) Staff Costs'!S:S,\"No\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A6,'F - (PT) Staff Costs'!Z:Z,\"No\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A6,'F - Direct Costs'!O:O,\"No\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A6,'A - Procured'!Y:Y,\"No\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A6,'A - Wage Subsidies'!AA:AA,\"No\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A6,'A - Grant - Stage 1'!Y:Y,\"No\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A6,'A - Graduate Placement - Stage1'!Z:Z,\"No\"))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A6,'F - (FT) Staff Costs'!S:S,\"Yes\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A6,'F - (PT) Staff Costs'!Z:Z,\"Yes\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A6,'F - Direct Costs'!O:O,\"Yes\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A6,'A - Procured'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A6,'A - Wage Subsidies'!AA:AA,\"Yes\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A6,'A - Grant - Stage 1'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A6,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\"))))))))","v":0},"TBC",0]
[null,null,null,null,{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,A7,'F - (FT) Staff Costs'!F:F)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,A7,'F - (PT) Staff Costs'!F:F)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A7,'F - Direct Costs'!F:F)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,A7,'A - Procured'!F:F)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!B:B,A7,'A - Wage Subsidies'!F:F)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,A7,'A - Grant - Stage 1'!F:F)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,A7,'A - Graduate Placement - Stage1'!F:F))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIF('F - (FT) Staff Costs'!$B:$B,A7)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIF('F - (PT) Staff Costs'!$B:$B,A7)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIF('F - Direct Costs'!$B:$B,$A7)\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIF('A - Procured'!$B:$B,A7)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIF('A - Wage Subsidies'!$B:$B,A7)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIF('A - Grant - Stage 1'!$B:$B,A7)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIF('A - Graduate Placement - Stage1'!$B:$B,A7))))))))","v":0},"0%",{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A7,'F - (FT) Staff Costs'!U:U)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A7,'F - (PT) Staff Costs'!AB:AB)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A7,'F - Direct Costs'!Q:Q)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A7,'A - Procured'!AA:AA)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A7,'A - Wage Subsidies'!AC:AC)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A7,'A - Grant - Stage 1'!AA:AA)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A7,'A - Graduate Placement - Stage1'!AB:AB))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A7,'F - (FT) Staff Costs'!V:V)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A7,'F - (PT) Staff Costs'!AC:AC)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A7,'F - Direct Costs'!R:R)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A7,'A - Procured'!AB:AB)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A7,'A - Wage Subsidies'!AD:AD)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A7,'A - Grant - Stage 1'!AB:AB)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A7,'A - Graduate Placement - Stage1'!AC:AC))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A7,'F - (FT) Staff Costs'!W:W)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A7,'F - (PT) Staff Costs'!AD:AD)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A7,'F - Direct Costs'!S:S)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A7,'A - Procured'!AC:AC)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A7,'A - Wage Subsidies'!AE:AE)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A7,'A - Grant - Stage 1'!AC:AC)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A7,'A - Graduate Placement - Stage1'!AD:AD))))))))","v":0},0,{"$f":"SUMIFS('F - (FT) Staff Costs'!F:F,'F - (FT) Staff Costs'!S:S,\"Yes\",'F - (FT) Staff Costs'!B:B,A7)\n+SUMIFS('F - (PT) Staff Costs'!F:F,'F - (PT) Staff Costs'!Z:Z,\"Yes\",'F - (PT) Staff Costs'!B:B,A7)\n+SUMIFS('F - Direct Costs'!F:F,'F - Direct Costs'!O:O,\"Yes\",'F - Direct Costs'!B:B,A7)\n+SUMIFS('A - Procured'!F:F,'A - Procured'!Y:Y,\"Yes\",'A - Procured'!B:B,A7)\n+SUMIFS('A - Wage Subsidies'!F:F,'A - Wage Subsidies'!AA:AA,\"Yes\",'A - Wage Subsidies'!B:B,A7)\n+SUMIFS('A - Grant - Stage 1'!F:F,'A - Grant - Stage 1'!Y:Y,\"Yes\",'A - Grant - Stage 1'!B:B,A7)\n+SUMIFS('A - Graduate Placement - Stage1'!F:F,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\",'A - Graduate Placement - Stage1'!B:B,A7)","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A7,'F - (FT) Staff Costs'!S:S,\"No\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A7,'F - (PT) Staff Costs'!Z:Z,\"No\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A7,'F - Direct Costs'!O:O,\"No\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A7,'A - Procured'!Y:Y,\"No\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A7,'A - Wage Subsidies'!AA:AA,\"No\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A7,'A - Grant - Stage 1'!Y:Y,\"No\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A7,'A - Graduate Placement - Stage1'!Z:Z,\"No\"))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A7,'F - (FT) Staff Costs'!S:S,\"Yes\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A7,'F - (PT) Staff Costs'!Z:Z,\"Yes\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A7,'F - Direct Costs'!O:O,\"Yes\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A7,'A - Procured'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A7,'A - Wage Subsidies'!AA:AA,\"Yes\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A7,'A - Grant - Stage 1'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A7,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\"))))))))","v":0},"TBC",0]
[null,null,null,null,{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,A8,'F - (FT) Staff Costs'!F:F)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,A8,'F - (PT) Staff Costs'!F:F)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A8,'F - Direct Costs'!F:F)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,A8,'A - Procured'!F:F)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!B:B,A8,'A - Wage Subsidies'!F:F)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,A8,'A - Grant - Stage 1'!F:F)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,A8,'A - Graduate Placement - Stage1'!F:F))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIF('F - (FT) Staff Costs'!$B:$B,A8)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIF('F - (PT) Staff Costs'!$B:$B,A8)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIF('F - Direct Costs'!$B:$B,$A8)\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIF('A - Procured'!$B:$B,A8)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIF('A - Wage Subsidies'!$B:$B,A8)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIF('A - Grant - Stage 1'!$B:$B,A8)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIF('A - Graduate Placement - Stage1'!$B:$B,A8))))))))","v":0},"0%",{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A8,'F - (FT) Staff Costs'!U:U)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A8,'F - (PT) Staff Costs'!AB:AB)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A8,'F - Direct Costs'!Q:Q)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A8,'A - Procured'!AA:AA)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A8,'A - Wage Subsidies'!AC:AC)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A8,'A - Grant - Stage 1'!AA:AA)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A8,'A - Graduate Placement - Stage1'!AB:AB))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A8,'F - (FT) Staff Costs'!V:V)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A8,'F - (PT) Staff Costs'!AC:AC)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A8,'F - Direct Costs'!R:R)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A8,'A - Procured'!AB:AB)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A8,'A - Wage Subsidies'!AD:AD)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A8,'A - Grant - Stage 1'!AB:AB)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A8,'A - Graduate Placement - Stage1'!AC:AC))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A8,'F - (FT) Staff Costs'!W:W)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A8,'F - (PT) Staff Costs'!AD:AD)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A8,'F - Direct Costs'!S:S)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A8,'A - Procured'!AC:AC)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A8,'A - Wage Subsidies'!AE:AE)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A8,'A - Grant - Stage 1'!AC:AC)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A8,'A - Graduate Placement - Stage1'!AD:AD))))))))","v":0},0,{"$f":"SUMIFS('F - (FT) Staff Costs'!F:F,'F - (FT) Staff Costs'!S:S,\"Yes\",'F - (FT) Staff Costs'!B:B,A8)\n+SUMIFS('F - (PT) Staff Costs'!F:F,'F - (PT) Staff Costs'!Z:Z,\"Yes\",'F - (PT) Staff Costs'!B:B,A8)\n+SUMIFS('F - Direct Costs'!F:F,'F - Direct Costs'!O:O,\"Yes\",'F - Direct Costs'!B:B,A8)\n+SUMIFS('A - Procured'!F:F,'A - Procured'!Y:Y,\"Yes\",'A - Procured'!B:B,A8)\n+SUMIFS('A - Wage Subsidies'!F:F,'A - Wage Subsidies'!AA:AA,\"Yes\",'A - Wage Subsidies'!B:B,A8)\n+SUMIFS('A - Grant - Stage 1'!F:F,'A - Grant - Stage 1'!Y:Y,\"Yes\",'A - Grant - Stage 1'!B:B,A8)\n+SUMIFS('A - Graduate Placement - Stage1'!F:F,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\",'A - Graduate Placement - Stage1'!B:B,A8)","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A8,'F - (FT) Staff Costs'!S:S,\"No\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A8,'F - (PT) Staff Costs'!Z:Z,\"No\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A8,'F - Direct Costs'!O:O,\"No\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A8,'A - Procured'!Y:Y,\"No\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A8,'A - Wage Subsidies'!AA:AA,\"No\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A8,'A - Grant - Stage 1'!Y:Y,\"No\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A8,'A - Graduate Placement - Stage1'!Z:Z,\"No\"))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A8,'F - (FT) Staff Costs'!S:S,\"Yes\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A8,'F - (PT) Staff Costs'!Z:Z,\"Yes\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A8,'F - Direct Costs'!O:O,\"Yes\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A8,'A - Procured'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A8,'A - Wage Subsidies'!AA:AA,\"Yes\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A8,'A - Grant - Stage 1'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A8,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\"))))))))","v":0},"TBC",0]
[null,null,null,null,{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,A9,'F - (FT) Staff Costs'!F:F)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,A9,'F - (PT) Staff Costs'!F:F)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A9,'F - Direct Costs'!F:F)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,A9,'A - Procured'!F:F)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!B:B,A9,'A - Wage Subsidies'!F:F)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,A9,'A - Grant - Stage 1'!F:F)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,A9,'A - Graduate Placement - Stage1'!F:F))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIF('F - (FT) Staff Costs'!$B:$B,A9)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIF('F - (PT) Staff Costs'!$B:$B,A9)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIF('F - Direct Costs'!$B:$B,$A9)\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIF('A - Procured'!$B:$B,A9)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIF('A - Wage Subsidies'!$B:$B,A9)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIF('A - Grant - Stage 1'!$B:$B,A9)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIF('A - Graduate Placement - Stage1'!$B:$B,A9))))))))","v":0},"0%",{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A9,'F - (FT) Staff Costs'!U:U)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A9,'F - (PT) Staff Costs'!AB:AB)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A9,'F - Direct Costs'!Q:Q)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A9,'A - Procured'!AA:AA)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A9,'A - Wage Subsidies'!AC:AC)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A9,'A - Grant - Stage 1'!AA:AA)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A9,'A - Graduate Placement - Stage1'!AB:AB))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A9,'F - (FT) Staff Costs'!V:V)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A9,'F - (PT) Staff Costs'!AC:AC)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A9,'F - Direct Costs'!R:R)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A9,'A - Procured'!AB:AB)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A9,'A - Wage Subsidies'!AD:AD)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A9,'A - Grant - Stage 1'!AB:AB)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A9,'A - Graduate Placement - Stage1'!AC:AC))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A9,'F - (FT) Staff Costs'!W:W)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A9,'F - (PT) Staff Costs'!AD:AD)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A9,'F - Direct Costs'!S:S)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A9,'A - Procured'!AC:AC)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A9,'A - Wage Subsidies'!AE:AE)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A9,'A - Grant - Stage 1'!AC:AC)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A9,'A - Graduate Placement - Stage1'!AD:AD))))))))","v":0},0,{"$f":"SUMIFS('F - (FT) Staff Costs'!F:F,'F - (FT) Staff Costs'!S:S,\"Yes\",'F - (FT) Staff Costs'!B:B,A9)\n+SUMIFS('F - (PT) Staff Costs'!F:F,'F - (PT) Staff Costs'!Z:Z,\"Yes\",'F - (PT) Staff Costs'!B:B,A9)\n+SUMIFS('F - Direct Costs'!F:F,'F - Direct Costs'!O:O,\"Yes\",'F - Direct Costs'!B:B,A9)\n+SUMIFS('A - Procured'!F:F,'A - Procured'!Y:Y,\"Yes\",'A - Procured'!B:B,A9)\n+SUMIFS('A - Wage Subsidies'!F:F,'A - Wage Subsidies'!AA:AA,\"Yes\",'A - Wage Subsidies'!B:B,A9)\n+SUMIFS('A - Grant - Stage 1'!F:F,'A - Grant - Stage 1'!Y:Y,\"Yes\",'A - Grant - Stage 1'!B:B,A9)\n+SUMIFS('A - Graduate Placement - Stage1'!F:F,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\",'A - Graduate Placement - Stage1'!B:B,A9)","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A9,'F - (FT) Staff Costs'!S:S,\"No\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A9,'F - (PT) Staff Costs'!Z:Z,\"No\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A9,'F - Direct Costs'!O:O,\"No\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A9,'A - Procured'!Y:Y,\"No\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A9,'A - Wage Subsidies'!AA:AA,\"No\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A9,'A - Grant - Stage 1'!Y:Y,\"No\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A9,'A - Graduate Placement - Stage1'!Z:Z,\"No\"))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A9,'F - (FT) Staff Costs'!S:S,\"Yes\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A9,'F - (PT) Staff Costs'!Z:Z,\"Yes\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A9,'F - Direct Costs'!O:O,\"Yes\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A9,'A - Procured'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A9,'A - Wage Subsidies'!AA:AA,\"Yes\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A9,'A - Grant - Stage 1'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A9,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\"))))))))","v":0},"TBC",0]
[null,null,null,null,{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,A10,'F - (FT) Staff Costs'!F:F)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,A10,'F - (PT) Staff Costs'!F:F)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A10,'F - Direct Costs'!F:F)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,A10,'A - Procured'!F:F)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!B:B,A10,'A - Wage Subsidies'!F:F)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,A10,'A - Grant - Stage 1'!F:F)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,A10,'A - Graduate Placement - Stage1'!F:F))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIF('F - (FT) Staff Costs'!$B:$B,A10)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIF('F - (PT) Staff Costs'!$B:$B,A10)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIF('F - Direct Costs'!$B:$B,$A10)\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIF('A - Procured'!$B:$B,A10)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIF('A - Wage Subsidies'!$B:$B,A10)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIF('A - Grant - Stage 1'!$B:$B,A10)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIF('A - Graduate Placement - Stage1'!$B:$B,A10))))))))","v":0},"0%",{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A10,'F - (FT) Staff Costs'!U:U)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A10,'F - (PT) Staff Costs'!AB:AB)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A10,'F - Direct Costs'!Q:Q)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A10,'A - Procured'!AA:AA)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A10,'A - Wage Subsidies'!AC:AC)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A10,'A - Grant - Stage 1'!AA:AA)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A10,'A - Graduate Placement - Stage1'!AB:AB))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A10,'F - (FT) Staff Costs'!V:V)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A10,'F - (PT) Staff Costs'!AC:AC)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A10,'F - Direct Costs'!R:R)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A10,'A - Procured'!AB:AB)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A10,'A - Wage Subsidies'!AD:AD)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A10,'A - Grant - Stage 1'!AB:AB)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A10,'A - Graduate Placement - Stage1'!AC:AC))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A10,'F - (FT) Staff Costs'!W:W)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A10,'F - (PT) Staff Costs'!AD:AD)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A10,'F - Direct Costs'!S:S)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A10,'A - Procured'!AC:AC)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A10,'A - Wage Subsidies'!AE:AE)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A10,'A - Grant - Stage 1'!AC:AC)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A10,'A - Graduate Placement - Stage1'!AD:AD))))))))","v":0},0,{"$f":"SUMIFS('F - (FT) Staff Costs'!F:F,'F - (FT) Staff Costs'!S:S,\"Yes\",'F - (FT) Staff Costs'!B:B,A10)\n+SUMIFS('F - (PT) Staff Costs'!F:F,'F - (PT) Staff Costs'!Z:Z,\"Yes\",'F - (PT) Staff Costs'!B:B,A10)\n+SUMIFS('F - Direct Costs'!F:F,'F - Direct Costs'!O:O,\"Yes\",'F - Direct Costs'!B:B,A10)\n+SUMIFS('A - Procured'!F:F,'A - Procured'!Y:Y,\"Yes\",'A - Procured'!B:B,A10)\n+SUMIFS('A - Wage Subsidies'!F:F,'A - Wage Subsidies'!AA:AA,\"Yes\",'A - Wage Subsidies'!B:B,A10)\n+SUMIFS('A - Grant - Stage 1'!F:F,'A - Grant - Stage 1'!Y:Y,\"Yes\",'A - Grant - Stage 1'!B:B,A10)\n+SUMIFS('A - Graduate Placement - Stage1'!F:F,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\",'A - Graduate Placement - Stage1'!B:B,A10)","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A10,'F - (FT) Staff Costs'!S:S,\"No\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A10,'F - (PT) Staff Costs'!Z:Z,\"No\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A10,'F - Direct Costs'!O:O,\"No\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A10,'A - Procured'!Y:Y,\"No\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A10,'A - Wage Subsidies'!AA:AA,\"No\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A10,'A - Grant - Stage 1'!Y:Y,\"No\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A10,'A - Graduate Placement - Stage1'!Z:Z,\"No\"))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A10,'F - (FT) Staff Costs'!S:S,\"Yes\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A10,'F - (PT) Staff Costs'!Z:Z,\"Yes\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A10,'F - Direct Costs'!O:O,\"Yes\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A10,'A - Procured'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A10,'A - Wage Subsidies'!AA:AA,\"Yes\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A10,'A - Grant - Stage 1'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A10,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\"))))))))","v":0},"TBC",0]
[null,null,null,null,{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,A11,'F - (FT) Staff Costs'!F:F)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,A11,'F - (PT) Staff Costs'!F:F)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A11,'F - Direct Costs'!F:F)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,A11,'A - Procured'!F:F)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!B:B,A11,'A - Wage Subsidies'!F:F)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,A11,'A - Grant - Stage 1'!F:F)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,A11,'A - Graduate Placement - Stage1'!F:F))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIF('F - (FT) Staff Costs'!$B:$B,A11)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIF('F - (PT) Staff Costs'!$B:$B,A11)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIF('F - Direct Costs'!$B:$B,$A11)\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIF('A - Procured'!$B:$B,A11)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIF('A - Wage Subsidies'!$B:$B,A11)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIF('A - Grant - Stage 1'!$B:$B,A11)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIF('A - Graduate Placement - Stage1'!$B:$B,A11))))))))","v":0},"0%",{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A11,'F - (FT) Staff Costs'!U:U)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A11,'F - (PT) Staff Costs'!AB:AB)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A11,'F - Direct Costs'!Q:Q)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A11,'A - Procured'!AA:AA)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A11,'A - Wage Subsidies'!AC:AC)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A11,'A - Grant - Stage 1'!AA:AA)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A11,'A - Graduate Placement - Stage1'!AB:AB))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A11,'F - (FT) Staff Costs'!V:V)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A11,'F - (PT) Staff Costs'!AC:AC)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A11,'F - Direct Costs'!R:R)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A11,'A - Procured'!AB:AB)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A11,'A - Wage Subsidies'!AD:AD)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A11,'A - Grant - Stage 1'!AB:AB)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A11,'A - Graduate Placement - Stage1'!AC:AC))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A11,'F - (FT) Staff Costs'!W:W)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A11,'F - (PT) Staff Costs'!AD:AD)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A11,'F - Direct Costs'!S:S)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A11,'A - Procured'!AC:AC)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A11,'A - Wage Subsidies'!AE:AE)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A11,'A - Grant - Stage 1'!AC:AC)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A11,'A - Graduate Placement - Stage1'!AD:AD))))))))","v":0},0,{"$f":"SUMIFS('F - (FT) Staff Costs'!F:F,'F - (FT) Staff Costs'!S:S,\"Yes\",'F - (FT) Staff Costs'!B:B,A11)\n+SUMIFS('F - (PT) Staff Costs'!F:F,'F - (PT) Staff Costs'!Z:Z,\"Yes\",'F - (PT) Staff Costs'!B:B,A11)\n+SUMIFS('F - Direct Costs'!F:F,'F - Direct Costs'!O:O,\"Yes\",'F - Direct Costs'!B:B,A11)\n+SUMIFS('A - Procured'!F:F,'A - Procured'!Y:Y,\"Yes\",'A - Procured'!B:B,A11)\n+SUMIFS('A - Wage Subsidies'!F:F,'A - Wage Subsidies'!AA:AA,\"Yes\",'A - Wage Subsidies'!B:B,A11)\n+SUMIFS('A - Grant - Stage 1'!F:F,'A - Grant - Stage 1'!Y:Y,\"Yes\",'A - Grant - Stage 1'!B:B,A11)\n+SUMIFS('A - Graduate Placement - Stage1'!F:F,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\",'A - Graduate Placement - Stage1'!B:B,A11)","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A11,'F - (FT) Staff Costs'!S:S,\"No\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A11,'F - (PT) Staff Costs'!Z:Z,\"No\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A11,'F - Direct Costs'!O:O,\"No\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A11,'A - Procured'!Y:Y,\"No\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A11,'A - Wage Subsidies'!AA:AA,\"No\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A11,'A - Grant - Stage 1'!Y:Y,\"No\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A11,'A - Graduate Placement - Stage1'!Z:Z,\"No\"))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A11,'F - (FT) Staff Costs'!S:S,\"Yes\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A11,'F - (PT) Staff Costs'!Z:Z,\"Yes\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A11,'F - Direct Costs'!O:O,\"Yes\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A11,'A - Procured'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A11,'A - Wage Subsidies'!AA:AA,\"Yes\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A11,'A - Grant - Stage 1'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A11,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\"))))))))","v":0},"TBC",0]
[null,null,null,null,{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,A12,'F - (FT) Staff Costs'!F:F)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,A12,'F - (PT) Staff Costs'!F:F)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A12,'F - Direct Costs'!F:F)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,A12,'A - Procured'!F:F)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!B:B,A12,'A - Wage Subsidies'!F:F)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,A12,'A - Grant - Stage 1'!F:F)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,A12,'A - Graduate Placement - Stage1'!F:F))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIF('F - (FT) Staff Costs'!$B:$B,A12)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIF('F - (PT) Staff Costs'!$B:$B,A12)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIF('F - Direct Costs'!$B:$B,$A12)\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIF('A - Procured'!$B:$B,A12)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIF('A - Wage Subsidies'!$B:$B,A12)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIF('A - Grant - Stage 1'!$B:$B,A12)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIF('A - Graduate Placement - Stage1'!$B:$B,A12))))))))","v":0},"0%",{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A12,'F - (FT) Staff Costs'!U:U)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A12,'F - (PT) Staff Costs'!AB:AB)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A12,'F - Direct Costs'!Q:Q)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A12,'A - Procured'!AA:AA)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A12,'A - Wage Subsidies'!AC:AC)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A12,'A - Grant - Stage 1'!AA:AA)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A12,'A - Graduate Placement - Stage1'!AB:AB))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A12,'F - (FT) Staff Costs'!V:V)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A12,'F - (PT) Staff Costs'!AC:AC)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A12,'F - Direct Costs'!R:R)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A12,'A - Procured'!AB:AB)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A12,'A - Wage Subsidies'!AD:AD)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A12,'A - Grant - Stage 1'!AB:AB)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A12,'A - Graduate Placement - Stage1'!AC:AC))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A12,'F - (FT) Staff Costs'!W:W)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A12,'F - (PT) Staff Costs'!AD:AD)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A12,'F - Direct Costs'!S:S)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A12,'A - Procured'!AC:AC)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A12,'A - Wage Subsidies'!AE:AE)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A12,'A - Grant - Stage 1'!AC:AC)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A12,'A - Graduate Placement - Stage1'!AD:AD))))))))","v":0},0,{"$f":"SUMIFS('F - (FT) Staff Costs'!F:F,'F - (FT) Staff Costs'!S:S,\"Yes\",'F - (FT) Staff Costs'!B:B,A12)\n+SUMIFS('F - (PT) Staff Costs'!F:F,'F - (PT) Staff Costs'!Z:Z,\"Yes\",'F - (PT) Staff Costs'!B:B,A12)\n+SUMIFS('F - Direct Costs'!F:F,'F - Direct Costs'!O:O,\"Yes\",'F - Direct Costs'!B:B,A12)\n+SUMIFS('A - Procured'!F:F,'A - Procured'!Y:Y,\"Yes\",'A - Procured'!B:B,A12)\n+SUMIFS('A - Wage Subsidies'!F:F,'A - Wage Subsidies'!AA:AA,\"Yes\",'A - Wage Subsidies'!B:B,A12)\n+SUMIFS('A - Grant - Stage 1'!F:F,'A - Grant - Stage 1'!Y:Y,\"Yes\",'A - Grant - Stage 1'!B:B,A12)\n+SUMIFS('A - Graduate Placement - Stage1'!F:F,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\",'A - Graduate Placement - Stage1'!B:B,A12)","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A12,'F - (FT) Staff Costs'!S:S,\"No\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A12,'F - (PT) Staff Costs'!Z:Z,\"No\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A12,'F - Direct Costs'!O:O,\"No\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A12,'A - Procured'!Y:Y,\"No\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A12,'A - Wage Subsidies'!AA:AA,\"No\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A12,'A - Grant - Stage 1'!Y:Y,\"No\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A12,'A - Graduate Placement - Stage1'!Z:Z,\"No\"))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A12,'F - (FT) Staff Costs'!S:S,\"Yes\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A12,'F - (PT) Staff Costs'!Z:Z,\"Yes\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A12,'F - Direct Costs'!O:O,\"Yes\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A12,'A - Procured'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A12,'A - Wage Subsidies'!AA:AA,\"Yes\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A12,'A - Grant - Stage 1'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A12,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\"))))))))","v":0},"TBC",0]
[null,null,null,null,{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,A13,'F - (FT) Staff Costs'!F:F)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,A13,'F - (PT) Staff Costs'!F:F)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A13,'F - Direct Costs'!F:F)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,A13,'A - Procured'!F:F)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!B:B,A13,'A - Wage Subsidies'!F:F)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,A13,'A - Grant - Stage 1'!F:F)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,A13,'A - Graduate Placement - Stage1'!F:F))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIF('F - (FT) Staff Costs'!$B:$B,A13)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIF('F - (PT) Staff Costs'!$B:$B,A13)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIF('F - Direct Costs'!$B:$B,$A13)\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIF('A - Procured'!$B:$B,A13)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIF('A - Wage Subsidies'!$B:$B,A13)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIF('A - Grant - Stage 1'!$B:$B,A13)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIF('A - Graduate Placement - Stage1'!$B:$B,A13))))))))","v":0},"0%",{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A13,'F - (FT) Staff Costs'!U:U)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A13,'F - (PT) Staff Costs'!AB:AB)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A13,'F - Direct Costs'!Q:Q)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A13,'A - Procured'!AA:AA)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A13,'A - Wage Subsidies'!AC:AC)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A13,'A - Grant - Stage 1'!AA:AA)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A13,'A - Graduate Placement - Stage1'!AB:AB))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A13,'F - (FT) Staff Costs'!V:V)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A13,'F - (PT) Staff Costs'!AC:AC)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A13,'F - Direct Costs'!R:R)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A13,'A - Procured'!AB:AB)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A13,'A - Wage Subsidies'!AD:AD)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A13,'A - Grant - Stage 1'!AB:AB)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A13,'A - Graduate Placement - Stage1'!AC:AC))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A13,'F - (FT) Staff Costs'!W:W)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A13,'F - (PT) Staff Costs'!AD:AD)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A13,'F - Direct Costs'!S:S)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A13,'A - Procured'!AC:AC)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A13,'A - Wage Subsidies'!AE:AE)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A13,'A - Grant - Stage 1'!AC:AC)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A13,'A - Graduate Placement - Stage1'!AD:AD))))))))","v":0},0,{"$f":"SUMIFS('F - (FT) Staff Costs'!F:F,'F - (FT) Staff Costs'!S:S,\"Yes\",'F - (FT) Staff Costs'!B:B,A13)\n+SUMIFS('F - (PT) Staff Costs'!F:F,'F - (PT) Staff Costs'!Z:Z,\"Yes\",'F - (PT) Staff Costs'!B:B,A13)\n+SUMIFS('F - Direct Costs'!F:F,'F - Direct Costs'!O:O,\"Yes\",'F - Direct Costs'!B:B,A13)\n+SUMIFS('A - Procured'!F:F,'A - Procured'!Y:Y,\"Yes\",'A - Procured'!B:B,A13)\n+SUMIFS('A - Wage Subsidies'!F:F,'A - Wage Subsidies'!AA:AA,\"Yes\",'A - Wage Subsidies'!B:B,A13)\n+SUMIFS('A - Grant - Stage 1'!F:F,'A - Grant - Stage 1'!Y:Y,\"Yes\",'A - Grant - Stage 1'!B:B,A13)\n+SUMIFS('A - Graduate Placement - Stage1'!F:F,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\",'A - Graduate Placement - Stage1'!B:B,A13)","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A13,'F - (FT) Staff Costs'!S:S,\"No\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A13,'F - (PT) Staff Costs'!Z:Z,\"No\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A13,'F - Direct Costs'!O:O,\"No\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A13,'A - Procured'!Y:Y,\"No\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A13,'A - Wage Subsidies'!AA:AA,\"No\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A13,'A - Grant - Stage 1'!Y:Y,\"No\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A13,'A - Graduate Placement - Stage1'!Z:Z,\"No\"))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A13,'F - (FT) Staff Costs'!S:S,\"Yes\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A13,'F - (PT) Staff Costs'!Z:Z,\"Yes\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A13,'F - Direct Costs'!O:O,\"Yes\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A13,'A - Procured'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A13,'A - Wage Subsidies'!AA:AA,\"Yes\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A13,'A - Grant - Stage 1'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A13,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\"))))))))","v":0},"TBC",0]
[null,null,null,null,{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,A14,'F - (FT) Staff Costs'!F:F)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,A14,'F - (PT) Staff Costs'!F:F)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A14,'F - Direct Costs'!F:F)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,A14,'A - Procured'!F:F)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!B:B,A14,'A - Wage Subsidies'!F:F)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,A14,'A - Grant - Stage 1'!F:F)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,A14,'A - Graduate Placement - Stage1'!F:F))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIF('F - (FT) Staff Costs'!$B:$B,A14)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIF('F - (PT) Staff Costs'!$B:$B,A14)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIF('F - Direct Costs'!$B:$B,$A14)\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIF('A - Procured'!$B:$B,A14)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIF('A - Wage Subsidies'!$B:$B,A14)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIF('A - Grant - Stage 1'!$B:$B,A14)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIF('A - Graduate Placement - Stage1'!$B:$B,A14))))))))","v":0},"0%",{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A14,'F - (FT) Staff Costs'!U:U)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A14,'F - (PT) Staff Costs'!AB:AB)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A14,'F - Direct Costs'!Q:Q)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A14,'A - Procured'!AA:AA)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A14,'A - Wage Subsidies'!AC:AC)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A14,'A - Grant - Stage 1'!AA:AA)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A14,'A - Graduate Placement - Stage1'!AB:AB))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A14,'F - (FT) Staff Costs'!V:V)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A14,'F - (PT) Staff Costs'!AC:AC)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A14,'F - Direct Costs'!R:R)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A14,'A - Procured'!AB:AB)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A14,'A - Wage Subsidies'!AD:AD)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A14,'A - Grant - Stage 1'!AB:AB)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A14,'A - Graduate Placement - Stage1'!AC:AC))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,SUMIF('F - (FT) Staff Costs'!$B:$B,$A14,'F - (FT) Staff Costs'!W:W)\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,SUMIF('F - (PT) Staff Costs'!$B:$B,$A14,'F - (PT) Staff Costs'!AD:AD)\n+IF(ISERROR('F - Direct Costs'!$A$1),0,SUMIF('F - Direct Costs'!$B:$B,$A14,'F - Direct Costs'!S:S)\n+IF(ISERROR('A - Procured'!$A$1),0,SUMIF('A - Procured'!$B:$B,$A14,'A - Procured'!AC:AC)\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,SUMIF('A - Wage Subsidies'!$B:$B,$A14,'A - Wage Subsidies'!AE:AE)\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,SUMIF('A - Grant - Stage 1'!$B:$B,$A14,'A - Grant - Stage 1'!AC:AC)\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,SUMIF('A - Graduate Placement - Stage1'!$B:$B,$A14,'A - Graduate Placement - Stage1'!AD:AD))))))))","v":0},0,{"$f":"SUMIFS('F - (FT) Staff Costs'!F:F,'F - (FT) Staff Costs'!S:S,\"Yes\",'F - (FT) Staff Costs'!B:B,A14)\n+SUMIFS('F - (PT) Staff Costs'!F:F,'F - (PT) Staff Costs'!Z:Z,\"Yes\",'F - (PT) Staff Costs'!B:B,A14)\n+SUMIFS('F - Direct Costs'!F:F,'F - Direct Costs'!O:O,\"Yes\",'F - Direct Costs'!B:B,A14)\n+SUMIFS('A - Procured'!F:F,'A - Procured'!Y:Y,\"Yes\",'A - Procured'!B:B,A14)\n+SUMIFS('A - Wage Subsidies'!F:F,'A - Wage Subsidies'!AA:AA,\"Yes\",'A - Wage Subsidies'!B:B,A14)\n+SUMIFS('A - Grant - Stage 1'!F:F,'A - Grant - Stage 1'!Y:Y,\"Yes\",'A - Grant - Stage 1'!B:B,A14)\n+SUMIFS('A - Graduate Placement - Stage1'!F:F,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\",'A - Graduate Placement - Stage1'!B:B,A14)","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A14,'F - (FT) Staff Costs'!S:S,\"No\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A14,'F - (PT) Staff Costs'!Z:Z,\"No\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A14,'F - Direct Costs'!O:O,\"No\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A14,'A - Procured'!Y:Y,\"No\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A14,'A - Wage Subsidies'!AA:AA,\"No\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A14,'A - Grant - Stage 1'!Y:Y,\"No\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A14,'A - Graduate Placement - Stage1'!Z:Z,\"No\"))))))))","v":0},{"$f":"IF(ISERROR('F - (FT) Staff Costs'!$A$1),0,COUNTIFS('F - (FT) Staff Costs'!$B:$B,A14,'F - (FT) Staff Costs'!S:S,\"Yes\")\n+IF(ISERROR('F - (PT) Staff Costs'!$A$1),0,COUNTIFS('F - (PT) Staff Costs'!$B:$B,A14,'F - (PT) Staff Costs'!Z:Z,\"Yes\")\n+IF(ISERROR('F - Direct Costs'!$A$1),0,COUNTIFS('F - Direct Costs'!$B:$B,$A14,'F - Direct Costs'!O:O,\"Yes\")\n+IF(ISERROR('A - Procured'!$A$1),0,COUNTIFS('A - Procured'!$B:$B,A14,'A - Procured'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Wage Subsidies'!$A$1),0,COUNTIFS('A - Wage Subsidies'!$B:$B,A14,'A - Wage Subsidies'!AA:AA,\"Yes\")\n+IF(ISERROR('A - Grant - Stage 1'!$A$1),0,COUNTIFS('A - Grant - Stage 1'!$B:$B,A14,'A - Grant - Stage 1'!Y:Y,\"Yes\")\n+IF(ISERROR('A - Graduate Placement - Stage1'!$A$1),0,COUNTIFS('A - Graduate Placement - Stage1'!$B:$B,A14,'A - Graduate Placement - Stage1'!Z:Z,\"Yes\"))))))))","v":0},"TBC",0]
["Total",null,null,{"$f":"SUM(D5:D14)","v":0},{"$f":"SUM(E5:E14)","v":0},{"$f":"SUM(F5:F14)","v":0},null,{"$f":"SUM(H5:H14)","v":0},0,0,0,{"$f":"SUM(L5:L14)","v":0},0,0,null,{"$f":"SUM(P5:P14)","v":0}]

{"sheet":"Delivery Agent Payments","index":3,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[[9,1,9,2],[9,9,9,11],[7,9,7,11],[8,9,8,11],[8,1,8,2],[7,1,7,2],[2,1,2,2],[3,1,3,2],[6,1,6,2],[5,1,5,2],[0,0,0,7],[4,1,4,2],[6,9,6,11],[2,9,2,11],[3,9,3,11],[4,9,4,11],[5,9,5,11]]}
["Payments to Delivery Agent or for Challenge Fund (Previous Claim Only/if applicable):"]
[]
["Operation","Delivery Agent",null,"Operation Reference","Payment Made by MA (£)","Date Paid by MA","Amount Received by DA","Date Received by DA","Satisfactory ","Comments"]

{"sheet":"F - (FT) Staff Costs","index":4,"n_rows":56,"n_cols":31,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,7,1,12]]}
["Flat Rate - Staff Costs Full Time"]
[null,null,null,null,null,null,null,"Eligible Staff Costs"]
["Item No","Operation Title","Description","Flat Rate (%)","Defrayal Date From Claim","Amount Claimed/Verified (£)","Evidence of Employment (Objective ID)","Basic (£)","Other Staff Costs (£)","Other Staff Costs Checked? (Y/N)","Employer's NI (£)","Employer's Pension (£)","NI/Pension Correctly Apportioned? (Y/N)","Net (£)","BACs Total (£)","Defrayal Date","Project Split (%)","Eligible Cost Item (Y/N)","Cost to be Rejected (Y/N)","Actual Expenditure Found (£)","Ineligible Expenditure (£)","Irregular Exp/Audit Trail (£)","Overclaim (£)","Underclaim (£)","Documents Viewed","Comments","Categorisation of Error","Justification","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,null,null,null,null,1000,null,700,100,null,100,100,null,null,null,null,null,null,null,{"$f":"IF(AND(Q4>0,Q4<=1),ROUND(SUM(H4:I4,K4:L4)*(1+D4/100)*Q4,2),ROUND(SUM(H4:I4,K4:L4)*(1+D4/100),2))","v":1000},null,null,{"$f":"ROUND(IF(F4>T4,F4-T4-(U4+V4),0),2)","v":0},{"$f":"ROUND(IF(T4>F4,T4-F4,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q5>0,Q5<=1),ROUND(SUM(H5:I5,K5:L5)*(1+D5/100)*Q5,2),ROUND(SUM(H5:I5,K5:L5)*(1+D5/100),2))","v":0},null,null,{"$f":"ROUND(IF(F5>T5,F5-T5-(U5+V5),0),2)","v":0},{"$f":"ROUND(IF(T5>F5,T5-F5,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"ROUND(IF(F36>T36,F36-T36-(U36+V36),0),2)","v":0},{"$f":"ROUND(IF(T36>F36,T36-F36,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q50>0,Q50<=1),ROUND(SUM(H50:I50,K50:L50)*(1+D50/100)*Q50,2),ROUND(SUM(H50:I50,K50:L50)*(1+D50/100),2))","v":0},null,null,{"$f":"ROUND(IF(F50>T50,F50-T50-(U50+V50),0),2)","v":0},{"$f":"ROUND(IF(T50>F50,T50-F50,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
["Totals",null,null,null,null,{"$f":"SUM(F4:F55)","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T4:T55)","v":1000},{"$f":"SUM(U4:U55)","v":0},{"$f":"SUM(V4:V55)","v":0},{"$f":"SUM(W4:W55)","v":0},{"$f":"SUM(X4:X55)","v":0}]

{"sheet":"F - (PT) Staff Costs","index":5,"n_rows":56,"n_cols":38,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,4,0,7],[1,7,1,12]]}
["Flat Rate - Staff Costs Part Time"]
[null,null,null,null,null,null,null,"Eligible Staff Costs"]
["Item No","Operation Title","Description","Flat Rate (%)","Defrayal Date From Claim","Amount Claimed/Verified (£)","Employment Evidence (Objective ID)","Basic (£)","Other Staff Costs (£)","Other Staff Costs Checked? (Y/N)","Employers NI (£)","Employers Super (£)","NI/Pension Correctly Apportioned? (Y/N)","Salary payments per year","Total Salary(£) ","Net (£)","Hours per year","Hourly rate (£)","ESIF Hours on Timesheet","Total Hours on Timesheet","ESIFHours Worked\n(%)","Timesheet Correct","BACs Total (£)","Defrayal Date","Eligible Cost Item (Y/N)","Cost to be Rejected (Y/N)","Actual Expenditure Found (£)","Ineligible Expenditure (£)","Irregular Exp/Audit Trail (£)","Other – Overclaim (£)","Underclaim (£)","Documents Viewed","Comments","Categorisation of Error","Justification","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H4:I4,K4:L4)*N4","v":0},null,null,{"$f":"IF(ISERROR(O4/Q4),\"-\",ROUND(O4/Q4,2))","v":"-"},null,null,{"$f":"IFERROR(S4/T4,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(MIN(SUM(H4:L4)*(1+D4/100),R4*S4*(1+D4/100)),0)","v":0},null,null,{"$f":"ROUND(IF(F4>AA4,F4-AA4-(AB4+AC4),0),2)","v":0},{"$f":"ROUND(IF(AA4>F4,AA4-F4,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"-",null,null,0,null,null,null,null,null,{"$f":"IFERROR(MIN(SUM(H55:L55)*(1+D55/100),R55*S55*(1+D55/100)),0)","v":0},null,null,0,0]
["Totals",null,null,null,null,{"$f":"SUM(F4:F55)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA4:AA55)","v":0},{"$f":"SUM(AB4:AB55)","v":0},{"$f":"SUM(AC4:AC55)","v":0},{"$f":"SUM(AD4:AD55)","v":0},{"$f":"SUM(AE4:AE55)","v":0}]

{"sheet":"Unit Costs","index":6,"n_rows":56,"n_cols":22,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Unit Costs"]
[]
["Item No","Milestone","Defrayal Date From Claim","Check Type","Number of Units","Value of Unit","Total Value of Units (£)","Date Achieved","Eligible (Y/N)","Actual Units Found ","Actual Units Found (£)","Ineligible Expenditure (£)","Docs Missing/ Incomplete (£)","Other - Overclaim (£)","Underclaim (£)","Documents Viewed","Comments","Categorisation of Error","Justification of Error","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,null,null,null,null,null,{"$f":"E4*F4","v":0},null,null,null,{"$f":"J4*F4","v":0},null,null,{"$f":"IF(G4>K4,G4-K4-(L4+M4),0)","v":0},{"$f":"IF(J4>E4,J4-E4,0)","v":0}]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,{"$f":"E51*F51","v":0},null,null,null,{"$f":"J51*F51","v":0},null,null,{"$f":"IF(G51>K51,G51-K51-(L51+M51),0)","v":0},{"$f":"IF(J51>E51,J51-E51,0)","v":0}]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,0,null,null,null,0,null,null,0,0]
["Totals",null,null,null,{"$f":"SUM(E4:E55)","v":0},{"$f":"SUM(F4:F55)","v":0},{"$f":"SUM(G4:G55)","v":0},null,null,{"$f":"SUM(J4:J55)","v":0},0,{"$f":"SUM(L4:L55)","v":0},0,0,0]

{"sheet":"F - Direct Costs","index":7,"n_rows":56,"n_cols":27,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Flat Rate - Direct Costs"]
[]
["Item No","Operation Title","Description","Flat Rate (%)","Defrayal Date From Claim","Amount Claimed/Verified (£)","Invoice Ref","Date of Invoice","Amount on Invoice /Petty Cash (£)","Batch Supplier Payment","BACS Total (£)","Defrayal Date","Apportionment Rate","Eligible Cost Item (Y/N)","Cost to be Rejected (Y/N)","Actual Expenditure Found (£)","Ineligible Expenditure (£)","Irregular Exp/Audit Trail (£)","Other – Overclaim (£)","Underclaim (£)","Documents Viewed","Comments","Categorisation of Error","Justification","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M4>0,M4<=1),ROUND(ROUND(I4*M4*(1+D4/100),2),2),ROUND(I4*(1+D4/100),2))","v":0},null,null,{"$f":"ROUND(IF(F4>P4,F4-P4-(Q4+R4),0),2)","v":0},{"$f":"ROUND(IF(P4>F4,P4-F4,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M5>0,M5<=1),ROUND(ROUND(I5*M5*(1+D5/100),2),2),ROUND(I5*(1+D5/100),2))","v":0},null,null,{"$f":"ROUND(IF(F5>P5,F5-P5-(Q5+R5),0),2)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"ROUND(IF(F35>P35,F35-P35-(Q35+R35),0),2)","v":0},{"$f":"ROUND(IF(P35>F35,P35-F35,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
["Totals",null,null,null,null,{"$f":"SUM(F4:F55)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(P4:P55)","v":0},{"$f":"SUM(Q4:Q55)","v":0},{"$f":"SUM(R4:R55)","v":0},{"$f":"SUM(S4:S55)","v":0},0]

{"sheet":"A - Procured","index":8,"n_rows":56,"n_cols":37,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,6,1,17]]}
["Actual - Procured"]
[null,null,null,null,null,null,"Invoice/Pricing Schedule"]
["Item No","Operation Title","Description","Flat Rate %","Defrayal Date from Claim","Amount Claimed/Verified (£)","Pricing Schedule Saved to eRDM (Objective ID)","Invoice Ref","Date of Invoice","Amount on Invoice /Petty Cash (£)","Is the activity detailed in-line with the activity approved in the operation application (Y/N)","Pricing Schedule Checked Against Invoice Costs (Y/N)","Comparison of Pricing Schedule Calculation Against Invoice - Does it Match (Y/N) ","Difference Between Pricing Schedule and Invoice (£)","Outcome/Bonus Payments Included in Invoice (Y/N)","Additional Delivery Check Required (Y/N)","Additional Delivery Check Sample, if required (Objective ID)","Outcomes/\nBonus Payments Eligible (Y/N)","Batch Supplier Payment","BACS Total (£)","Defrayal Date","Approved Apportionment Rate (e.g. H&I/LUPS Split)","Net Correction Applied if Applicable (%)","Eligible Cost Item (Y/N)","Cost to be Rejected (Y/N)","Actual Expenditure Found (£)","Ineligible Expenditure (£)","Irregular Exp/Audit Trail (£)","Other – Overclaim (£)","Underclaim (£)","Documents Viewed","Comments","Categorisation of Error","Justification","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(F4>Z4,F4-Z4-(AA4+AB4),0),2)","v":0},{"$f":"ROUND(IF(Z4>F4,Z4-F4,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["Totals",null,null,null,null,{"$f":"SUM(F4:F55)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z4:Z55)","v":0},{"$f":"SUM(AA4:AA55)","v":0},{"$f":"SUM(AB4:AB55)","v":0},{"$f":"SUM(AC4:AC55)","v":0},{"$f":"SUM(AD4:AD55)","v":0}]

{"sheet":"A - WS - Reimbursement","index":9,"n_rows":56,"n_cols":27,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,6,1,14],[0,0,0,2]]}
["Actual - Wage Sub - Reimbursement"]
[null,null,null,null,null,null,"Invoice - Council Paying Employer"]
["Item No","Operation Title","Description","Flat Rate %","Defrayal Date from Claim","Amount Claimed/Verified (£)","Invoice Ref","Date of Invoice","Amount on Invoice","Batch Supplier Payment","BACS Total (£)","Defrayal Date","Eligible Cost Item (Y/N)","Cost to be Rejected (Y/N)","Invoiced Expenditure Found (£)","Actual Expenditure Found (£)","Ineligible Expenditure (£)","Irregular Exp/Audit Trail (£)","Other – Overclaim (£)","Underclaim (£)","Documents Viewed","Comments","Categorisation of Error","Justification","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(F4>P4,F4-P4-(Q4+R4),0),2)","v":0},{"$f":"ROUND(IF(P4>F4,P4-F4,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F5>P5,F5-P5-(Q5+R5),0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36>P36,F36-P36-(Q36+R36),0)","v":0},{"$f":"ROUND(IF(P36>F36,P36-F36,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F40>P40,F40-P40-(Q40+R40),0)","v":0},{"$f":"ROUND(IF(P40>F40,P40-F40,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F43>P43,F43-P43-(Q43+R43),0)","v":0},{"$f":"ROUND(IF(P43>F43,P43-F43,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["Totals",null,null,null,null,{"$f":"SUM(F4:F55)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O55)","v":0},0,0,0,0,0]

{"sheet":"A - Wage Subsidies","index":10,"n_rows":56,"n_cols":39,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,2],[3,12,3,23],[2,0,2,2]]}
["Actual - Wage Subsidies"]
[]
["National Minimum Wage and National Living Wage rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Wage Subsidy payment to Participant"]
["Item No","Operation Title","Description","Flat Rate %","Defrayal Date from Claim","Amount Claimed/Verified (£)","NI Number","Employer","DOB","Start Date","Age at Start Date","End Date (if applicable)","Rate Paid","Hours Claimed","Eligible Basic \n(£)","Eligible Employer's NI (£)","Eligible Employer's Pension (£)","NI/Pension Correctly Apportioned? (Y/N)","Actual Basic \n(£)","Actual Employer's NI (£)","Actual Employer's Pension (£)","Net \n(£)","BACs Total (£)","Defrayal Date","Subsidy %","Eligible Cost Item (Y/N)","Cost to be Rejected (Y/N)","Wage Subsidy Expenditure Found (£)","Ineligible Expenditure (£)","Irregular Exp/Audit Trail (£)","Other – Overclaim \n(£)","Underclaim","Documents Viewed","Comments","Categorisation of Error","Justification","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(YEARFRAC(I6,J6),0)","v":0},null,null,null,{"$f":"M6*N6","v":0},null,null,null,null,null,null,null,null,null,0.5,null,null,{"$f":"ROUND(SUM(O6:Q6)*Y6,2)","v":0},null,null,{"$f":"ROUND(IF(F6>AB6,F6-AB6-(AC6+AD6),0),2)","v":0},{"$f":"ROUND(IF(AB6>F6,AB6-F6,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,{"$f":"ROUND(IF(F7>AB7,F7-AB7-(AC7+AD7),0),2)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"M20*N20","v":0},null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(YEARFRAC(I33,J33),0)","v":0},null,null,null,{"$f":"M33*N33","v":0},null,null,null,null,null,null,null,null,null,1.5,null,null,{"$f":"ROUND(SUM(O33:Q33)*Y33,2)","v":0},null,null,{"$f":"ROUND(IF(F33>AB33,F33-AB33-(AC33+AD33),0),2)","v":0},{"$f":"ROUND(IF(AB33>F33,AB33-F33,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,{"$f":"ROUND(SUM(O38:Q38)*Y38,2)","v":0},null,null,0,{"$f":"ROUND(IF(AB38>F38,AB38-F38,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,0.5,null,null,0,null,null,0,0]
["Totals",null,null,null,null,{"$f":"SUM(F6:F55)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB6:AB55)","v":0},{"$f":"SUM(AC6:AC55)","v":0},{"$f":"SUM(AD6:AD55)","v":0},{"$f":"SUM(AE6:AE55)","v":0},{"$f":"SUM(AF6:AF55)","v":0}]

{"sheet":"A - Grant - Stage 1","index":11,"n_rows":56,"n_cols":37,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,6,1,19]]}
["Actual - Grant - Stage 1 Check"]
[null,null,null,null,null,null,"Award Documentation Check"]
["Item No","Operation Title","Description","Flat Rate %","Defrayal Date from Claim","Amount Claimed/Verified (£)","Recipient's Business Type","SME Eligibility Status Confirmed","Application Examined","ERDF/ESF Acknowledged","Award Letter or Equivalent Viewed","Grant Award Date","Grant Award Amount","Grant Award Maximum %","Grant Start Date (from award letter)","Grant End Date (from award letter)","Grant Award Terms & Conditions Considered","Grant Acceptance Viewed","State Aid Assessed and Recipient Notified","State Aid Compliance Template Assessed","Recipient Claim Form(s) Provided","GFM BACS Total","GFM Defrayal Date","Grant Eligibility","Cost to be Rejected (Y/N)","Actual Expenditure Found (£)","Ineligible Expenditure \n(£)","Irregular Exp/Audit Trail (£)","Other – Overclaim \n(£)","Underclaim \n(£)","Documents Viewed","Comments","Categorisation of Error","Justification","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(F4>Z4,F4-Z4-(AA4+AB4),0),2)","v":0},{"$f":"ROUND(IF(Z4>F4,Z4-F4,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(F5>Z5,F5-Z5-(AA5+AB5),0),2)","v":0},{"$f":"ROUND(IF(Z5>F5,Z5-F5,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(F11>Z11,F11-Z11-(AA11+AB11),0),2)","v":0},{"$f":"ROUND(IF(Z11>F11,Z11-F11,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(F19>Z19,F19-Z19-(AA19+AB19),0),2)","v":0},{"$f":"ROUND(IF(Z19>F19,Z19-F19,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["Totals",null,null,null,null,{"$f":"SUM(F4:F55)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z4:Z55)","v":0},{"$f":"SUM(AA4:AA55)","v":0},{"$f":"SUM(AB4:AB55)","v":0},{"$f":"SUM(AC4:AC55)","v":0},{"$f":"SUM(AD4:AD55)","v":0}]

{"sheet":"A - Grant - Stage 2","index":12,"n_rows":56,"n_cols":23,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,2],[0,0,0,1],[2,3,2,9]]}
["Actual - Grant - Stage 2"]
[]
["Claim Details",null,null,"Recipient Documentation Check"]
["Item No (from GS1)","Description","Amount Claimed/Verified (£)","Supplier Name","Invoice Ref","Recipient Invoice Date(s)","Amount on Invoice/ Petty Cash","Recipient BACS Total","Recipient Defrayal Date","Amount Eligible to be Claimed","Eligible Cost Item (Y/N)","Actual Expenditure Found (£)","Ineligible Expenditure \n(£)","Irregular Exp/Audit Trail (£)","Other – Overclaim\n(£) ","Underclaim\n(£)","Documents Viewed","Comments","Categorisation of Error","Justification","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,{"$f":"IF('A - Grant - Stage 1'!E4=\"Y\",'A - Grant - Stage 1'!C4,\"\")","v":""},{"$f":"IF('A - Grant - Stage 1'!E4=\"Y\",'A - Grant - Stage 1'!F4,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(C5>L5,C5-L5-(M5+N5),0),0)","v":0},{"$f":"ROUND(IF(L5>C5,L5-C5,0),2)","v":0}]
[null,{"$f":"IF('A - Grant - Stage 1'!E5=\"Y\",'A - Grant - Stage 1'!C5,\"\")","v":""},{"$f":"IF('A - Grant - Stage 1'!E5=\"Y\",'A - Grant - Stage 1'!F5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"IF('A - Grant - Stage 1'!E6=\"Y\",'A - Grant - Stage 1'!C6,\"\")","v":""},{"$f":"IF('A - Grant - Stage 1'!E6=\"Y\",'A - Grant - Stage 1'!F6,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"IF('A - Grant - Stage 1'!E7=\"Y\",'A - Grant - Stage 1'!C7,\"\")","v":""},{"$f":"IF('A - Grant - Stage 1'!E7=\"Y\",'A - Grant - Stage 1'!F7,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(C39>L39,C39-L39-(M39+N39),0),0)","v":0},{"$f":"ROUND(IF(L39>C39,L39-C39,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(C42>L42,C42-L42-(M42+N42),0),0)","v":0},{"$f":"ROUND(IF(L42>C42,L42-C42,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["Totals",null,{"$f":"SUM(C5:C55)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(L5:L55)","v":0},0,0,{"$f":"SUM(O5:O55)","v":0},{"$f":"SUM(P5:P55)","v":0}]

{"sheet":"A - Graduate Placement - Stage1","index":13,"n_rows":56,"n_cols":38,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Actual - Graduate Placement - Stage 1 Check"]
[]
["Item No","Operation Title","Description","Flat Rate %","Defrayal Date from Claim","Amount Claimed/Verified (£)","Name of Graduate Placement Beneficiary Organisation (GPBO)","Confirmation of GPBO Business Type","GPBO SME Eligibility Status","Signed and Dated application from GPBO requesting Graduate Placement","Signed and dated Graduate Placement award letter/Contract from Graduate Placement Scheme Manager (GPSM)","State Aid Notification (Di Minimis/GBER)","Signed and dated acceptance from GPBO","Evidence of ERDF/ESF acknowledgement at both GPSM & GPBO level","Name of Graduate","Qualification Certificate for Graduate","Job Description for Graduate","Terms and Conditions of Graduate Placement (Contract of Employment)","Evidence for staff working 100% on Graduate Placement","Invoice Ref","Invoice Date(s)","Amount on Invoice","GPBO BACS Total","GPBO Defrayal Date","Eligible Cost Item (Y/N)","Cost to be Rejected (Y/N)","Actual Expenditure Found (£)","Ineligible Expenditure \n(£)","Irregular Exp/Audit Trail (£)","Other – Overclaim \n(£)","Underclaim \n(£)","Documents Viewed","Comments","Categorisation of Error","Justification of Error","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(F4>AA4,F4-AA4-(AB4+AC4),0),2)","v":0},{"$f":"ROUND(IF(AA4>F4,AA4-F4,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(F5>AA5,F5-AA5-(AB5+AC5),0),2)","v":0},{"$f":"ROUND(IF(AA5>F5,AA5-F5,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["Totals",null,null,null,null,{"$f":"SUM(F4:F55)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA4:AA55)","v":0},{"$f":"SUBTOTAL(109,AB4:AB55)","v":0},0,{"$f":"SUBTOTAL(109,AD4:AD55)","v":0},{"$f":"SUBTOTAL(109,AE4:AE55)","v":0}]

{"sheet":"A - Graduate Placement - Stage2","index":14,"n_rows":56,"n_cols":25,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,2],[2,3,2,12],[2,13,2,24],[0,0,0,2]]}
["Actual - Graduate Placement - Stage 2"]
[]
[null,null,null,"GPBO Final Defrayal "]
["Item No","Description","Amount Claimed/Verified (£)","Payslips of the Graduate for the duration of their placement (Y/N)","Basic (£)","Other Staff Costs (£)","Other Staff Costs Checked? (Y/N)","Employer's NI (£)","Employer's Pension (£)","NI/Pension Correctly Apportioned? (Y/N)","Net (£)","BACs Total (£)","Defrayal Date","Actual Expenditure Found (£)","Ineligible Expenditure \n(£)","Irregular Exp/Audit Trail (£)","Other – Overclaim\n(£) ","Underclaim\n(£)","Documents Viewed","Comments","Categorisation of Error","Justification of Error","Further Action Taken","Reviewer Check (If Applicable)","SPCM Check (If Applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E5:F5,H5:I5),2)","v":0},null,null,{"$f":"ROUND(IF(C5>N5,C5-N5-(O5+P5),0),0)","v":0},{"$f":"ROUND(IF(N5>C5,N5-C5,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E6:F6,H6:I6),2)","v":0},null,null,{"$f":"ROUND(IF(C6>N6,C6-N6-(O6+P6),0),0)","v":0},{"$f":"ROUND(IF(N6>C6,N6-C6,0),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0]
["Totals",null,{"$f":"SUM(C4:C55)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N5:N55)","v":0},{"$f":"SUM(O5:O55)","v":0},0,0,0]