{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Version Control","Guidance - LP Recalculation","Recalculation Approval","Summary","Ineligible Costs","Overclaimed Costs","Scratch","Ineligible Recipients"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":2},"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":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,0,11,3],[14,0,14,3],[16,0,16,3],[20,0,20,3],[17,0,17,3],[12,0,12,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EUROPEAN STRUCTURAL AND "]
["INVESTMENT FUNDS"]
[]
["2014 - 2020 PROGRAMME"]
[]
["Lead Partner Recalculation "]
["Worksheet and Guidance"]
[]
[]
[]
[]
["Version Control"]
[]
["Date","Issue","Change Made","Author"]
["2018-08-23",0.1,"First Draft","Group"]
["2019-04-26",0.2,"Further Updates","Tracey Gillon"]
["2019-08-29",0.3,"Updates","David Mckinley"]
["2019-08-29",0.4,"Guidance added","Alison McLoughlin"]
["2019-09-23",1,"First Issue","Alison Cumming"]

{"sheet":"Guidance - LP Recalculation","index":1,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,0,8,0],[11,0,19,0],[21,0,29,0],[31,0,34,0],[9,0,10,0]]}
[null,null,"LP GUIDANCE"]
[null,null,"Please note the Ineligible Costs tab, Overclaimed Costs tab and Ineligible Recipients tab are limited to 20 rows, please do not add in more rows, please start a new template."]
["RECALCULATION APPROVAL","Lead Partner:","Lead Partner name"]
[null,"Completed by:","Name of person completing template"]
[null,"Email:","Email address of person completing template"]
[null,"SI Title:","SI name"]
[null,"SI Reference:","SI reference"]
[null,"Reason for this request:","Please provide a description/explanation for this request"]
[null,"Checker/Reviewer details","For MA use only"]
["SUMMARY","Ineligible Cost Totals","These are calculated fields"]
[null,"Overclaimed Cost Totals","These are calculated fields"]
[" INELIGIBLE COSTS","Total Ineligible Costs:","This is a calculated field (Use this tab for any costs that are wholly ineligible for Structural Funds Support, as per the National Rules - DO NOT USE THIS SECTION FOR OVER-CLAIMED COSTS)"]
[null,"Claim Reference","Please enter the claim reference number in which this cost was incurred (last 4 digits eg 0001)"]
[null,"Cost Model Type","Please select relevant cost model type from drop-down menu"]
[null,"Cost Type","Please select relevant cost type from drop-down menu"]
[null,"Cost Description (as per EUMIS description)","Please enter cost description as stated in EUMIS"]
[null,"Defrayal Date","Please enter defrayal date as stated in EUMIS"]
[null,"Amount Originally Claimed","Please enter amount originally claimed for as stated in EUMIS. This is the Gross Cost which includes indirect uplift where applicable"]
[null,"Explanation of Error","Please provide a description/explanation for this error, e.g. duplicate"]
[null,"Ineligible Cost","Enter Value - This is for any costs that cannot be claimed in the future, and are considered ineligible, as per the National Rules. The ineligible value cannot be included in a future claim."]
[null,"Cost Type Totals","These are calculated fields"]
["OVER CLAIMED COSTS","Total Overclaimed Costs:","This is a calculated field (Use this tab for any costs that have been over-claimed, due to calculation errors for example - DO NOT USE THIS SECTION FOR INELIGIBLE COSTS)"]
[null,"Claim Reference","Please enter the claim reference number in which this cost was incurred (last 4 digits eg 0001)"]
[null,"Cost Model Type","Please select relevant cost model type from drop-down menu"]
[null,"Cost Type","Please select relevant cost type from drop-down menu"]
[null,"Cost Description (as per EUMIS description)","Please enter cost description as stated in EUMIS"]
[null,"Defrayal Date","Please enter defrayal date as stated in EUMIS"]
[null,"Amount Originally Claimed","Please enter amount originally claimed for as stated in EUMIS. This is the Gross Cost which includes indirect uplift where applicable"]
[null,"Explanation of Error","Please provide a description/explanation for this error, e.g. duplicate"]
[null,"Overclaimed Cost","Enter value of over-claim. This is a genuine mis-calculation, for example, apportionment calculation error.  "]
[null,"Cost Type Totals","These are calculated fields"]
["INELIGIBLE RECIPIENTS","Claim Reference","Please enter the claim reference number in which this cost was incurred (last 4 digits eg 0001)"]
[null,"Recipient","Please enter NINO (ESF) or Company Registration Number (ERDF) or Name (NRA)."]
[null,"DOB/Start Date","Recipients DOB (If applicable - ESF only) or Company Start Date (ERDF and NRA)."]
[null,"Explanation of Error","Please provide a description/explanation for this error, e.g. duplicate"]

{"sheet":"Recalculation Approval","index":2,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[6,1,6,3],[9,0,14,0],[5,1,5,9],[7,1,7,9],[8,1,8,9],[6,5,6,9],[9,1,14,9],[41,7,41,9],[39,1,39,3],[40,1,40,3],[38,0,38,9],[41,1,41,3],[39,4,39,6],[40,4,40,6],[41,4,41,6],[39,7,39,9],[40,7,40,9]]}
["LEAD PARTNER RECALCULATION WORKSHEET "]
["(Additional Irregularities or Overclaims)"]
[]
["FOR LP USE ONLY"]
[]
["Lead Partner:"]
["Completed by :",null,null,null,"Email:"]
["SI Title:"]
["SI Reference:"]
["Reason for this request:\n"]
[]
[]
[]
[]
[]
[]
[]
[]
["Eumis Claim No:",1,2,3,4,5,6,7,8,9,10]
[]
["Cost Type"]
["Staff Costs - Full Time",{"$f":"SUMPRODUCT((#REF!=B$19)*(#REF!=B$19)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=B$19)*('Overclaimed Costs'!$B$25:$B$969=$B$19)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=C$19)*(#REF!=$A22)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=C$19)*('Overclaimed Costs'!$B$25:$B$969=$A22)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=D$19)*(#REF!=$A22)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=D$19)*('Overclaimed Costs'!$B$25:$B$969=$A22)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=E$19)*(#REF!=$A22)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=E$19)*('Overclaimed Costs'!$B$25:$B$969=$A22)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=F$19)*(#REF!=$A22)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=F$19)*('Overclaimed Costs'!$B$25:$B$969=$A22)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=G$19)*(#REF!=$A22)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=G$19)*('Overclaimed Costs'!$B$25:$B$969=$A22)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=H$19)*(#REF!=$A22)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=H$19)*('Overclaimed Costs'!$B$25:$B$969=$A22)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=I$19)*(#REF!=$A22)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=I$19)*('Overclaimed Costs'!$B$25:$B$969=$A22)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=J$19)*(#REF!=$A22)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=J$19)*('Overclaimed Costs'!$B$25:$B$969=$A22)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=K$19)*(#REF!=$A22)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=K$19)*('Overclaimed Costs'!$B$25:$B$969=$A22)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}}]
["Staff Costs - Part Time",{"$f":"SUMPRODUCT((#REF!=B$19)*(#REF!=$A23)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=B$19)*('Overclaimed Costs'!$B$25:$B$969=$A23)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=C$19)*(#REF!=$A23)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=C$19)*('Overclaimed Costs'!$B$25:$B$969=$A23)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=D$19)*(#REF!=$A23)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=D$19)*('Overclaimed Costs'!$B$25:$B$969=$A23)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=E$19)*(#REF!=$A23)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=E$19)*('Overclaimed Costs'!$B$25:$B$969=$A23)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=F$19)*(#REF!=$A23)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=F$19)*('Overclaimed Costs'!$B$25:$B$969=$A23)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=G$19)*(#REF!=$A23)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=G$19)*('Overclaimed Costs'!$B$25:$B$969=$A23)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=H$19)*(#REF!=$A23)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=H$19)*('Overclaimed Costs'!$B$25:$B$969=$A23)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=I$19)*(#REF!=$A23)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=I$19)*('Overclaimed Costs'!$B$25:$B$969=$A23)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=J$19)*(#REF!=$A23)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=J$19)*('Overclaimed Costs'!$B$25:$B$969=$A23)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=K$19)*(#REF!=$A23)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=K$19)*('Overclaimed Costs'!$B$25:$B$969=$A23)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}}]
["Flat Rate Direct Costs",{"$f":"SUMPRODUCT((#REF!=B$19)*(#REF!=$A24)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=B$19)*('Overclaimed Costs'!$B$25:$B$969=$A24)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=C$19)*(#REF!=$A24)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=C$19)*('Overclaimed Costs'!$B$25:$B$969=$A24)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=D$19)*(#REF!=$A24)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=D$19)*('Overclaimed Costs'!$B$25:$B$969=$A24)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=E$19)*(#REF!=$A24)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=E$19)*('Overclaimed Costs'!$B$25:$B$969=$A24)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=F$19)*(#REF!=$A24)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=F$19)*('Overclaimed Costs'!$B$25:$B$969=$A24)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=G$19)*(#REF!=$A24)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=G$19)*('Overclaimed Costs'!$B$25:$B$969=$A24)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=H$19)*(#REF!=$A24)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=H$19)*('Overclaimed Costs'!$B$25:$B$969=$A24)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=I$19)*(#REF!=$A24)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=I$19)*('Overclaimed Costs'!$B$25:$B$969=$A24)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=J$19)*(#REF!=$A24)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=J$19)*('Overclaimed Costs'!$B$25:$B$969=$A24)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=K$19)*(#REF!=$A24)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=K$19)*('Overclaimed Costs'!$B$25:$B$969=$A24)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}}]
["Actual - Procured Costs",{"$f":"SUMPRODUCT((#REF!=B$19)*(#REF!=$A25)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=B$19)*('Overclaimed Costs'!$B$25:$B$969=$A25)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=C$19)*(#REF!=$A25)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=C$19)*('Overclaimed Costs'!$B$25:$B$969=$A25)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=D$19)*(#REF!=$A25)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=D$19)*('Overclaimed Costs'!$B$25:$B$969=$A25)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=E$19)*(#REF!=$A25)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=E$19)*('Overclaimed Costs'!$B$25:$B$969=$A25)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=F$19)*(#REF!=$A25)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=F$19)*('Overclaimed Costs'!$B$25:$B$969=$A25)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=G$19)*(#REF!=$A25)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=G$19)*('Overclaimed Costs'!$B$25:$B$969=$A25)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=H$19)*(#REF!=$A25)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=H$19)*('Overclaimed Costs'!$B$25:$B$969=$A25)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=I$19)*(#REF!=$A25)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=I$19)*('Overclaimed Costs'!$B$25:$B$969=$A25)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=J$19)*(#REF!=$A25)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=J$19)*('Overclaimed Costs'!$B$25:$B$969=$A25)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=K$19)*(#REF!=$A25)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=K$19)*('Overclaimed Costs'!$B$25:$B$969=$A25)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}}]
["Actual - Wage Subsidy Costs",{"$f":"SUMPRODUCT((#REF!=B$19)*(#REF!=$A26)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=B$19)*('Overclaimed Costs'!$B$25:$B$969=$A26)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=C$19)*(#REF!=$A26)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=C$19)*('Overclaimed Costs'!$B$25:$B$969=$A26)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=D$19)*(#REF!=$A26)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=D$19)*('Overclaimed Costs'!$B$25:$B$969=$A26)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=E$19)*(#REF!=$A26)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=E$19)*('Overclaimed Costs'!$B$25:$B$969=$A26)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=F$19)*(#REF!=$A26)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=F$19)*('Overclaimed Costs'!$B$25:$B$969=$A26)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=G$19)*(#REF!=$A26)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=G$19)*('Overclaimed Costs'!$B$25:$B$969=$A26)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=H$19)*(#REF!=$A26)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=H$19)*('Overclaimed Costs'!$B$25:$B$969=$A26)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=I$19)*(#REF!=$A26)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=I$19)*('Overclaimed Costs'!$B$25:$B$969=$A26)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=J$19)*(#REF!=$A26)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=J$19)*('Overclaimed Costs'!$B$25:$B$969=$A26)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=K$19)*(#REF!=$A26)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=K$19)*('Overclaimed Costs'!$B$25:$B$969=$A26)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}}]
["Actual - Grant Schemes",{"$f":"SUMPRODUCT((#REF!=B$19)*(#REF!=$A27)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=B$19)*('Overclaimed Costs'!$B$25:$B$969=$A27)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=C$19)*(#REF!=$A27)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=C$19)*('Overclaimed Costs'!$B$25:$B$969=$A27)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=D$19)*(#REF!=$A27)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=D$19)*('Overclaimed Costs'!$B$25:$B$969=$A27)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=E$19)*(#REF!=$A27)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=E$19)*('Overclaimed Costs'!$B$25:$B$969=$A27)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=F$19)*(#REF!=$A27)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=F$19)*('Overclaimed Costs'!$B$25:$B$969=$A27)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=G$19)*(#REF!=$A27)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=G$19)*('Overclaimed Costs'!$B$25:$B$969=$A27)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=H$19)*(#REF!=$A27)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=H$19)*('Overclaimed Costs'!$B$25:$B$969=$A27)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=I$19)*(#REF!=$A27)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=I$19)*('Overclaimed Costs'!$B$25:$B$969=$A27)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=J$19)*(#REF!=$A27)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=J$19)*('Overclaimed Costs'!$B$25:$B$969=$A27)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=K$19)*(#REF!=$A27)*#REF!)+SUMPRODUCT(('Overclaimed Costs'!$A$25:$A$969=K$19)*('Overclaimed Costs'!$B$25:$B$969=$A27)*'Overclaimed Costs'!$G$25:$G$969)","v":{"$error":"#REF!"}}]
[]
["TO BE REMOVED BY MA (Irregularities)",null,null,null,null,null,null,null,null,null,"Totals"]
[]
["Total Ineligible",{"$f":"SUMIF(#REF!,'Recalculation Approval'!B$19,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Recalculation Approval'!C$19,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Recalculation Approval'!D$19,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Recalculation Approval'!E$19,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Recalculation Approval'!F$19,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Recalculation Approval'!G$19,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Recalculation Approval'!H$19,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Recalculation Approval'!I$19,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Recalculation Approval'!J$19,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(B31:J31)","v":{"$error":"#REF!"}}]
[]
["Total Overclaims",{"$f":"SUMIF('Overclaimed Costs'!$A:$A,'Recalculation Approval'!B19,'Overclaimed Costs'!$G:$G)","v":0},{"$f":"SUMIF('Overclaimed Costs'!$A:$A,'Recalculation Approval'!C19,'Overclaimed Costs'!$G:$G)","v":0},{"$f":"SUMIF('Overclaimed Costs'!$A:$A,'Recalculation Approval'!D19,'Overclaimed Costs'!$G:$G)","v":0},{"$f":"SUMIF('Overclaimed Costs'!$A:$A,'Recalculation Approval'!E19,'Overclaimed Costs'!$G:$G)","v":0},{"$f":"SUMIF('Overclaimed Costs'!$A:$A,'Recalculation Approval'!F19,'Overclaimed Costs'!$G:$G)","v":0},{"$f":"SUMIF('Overclaimed Costs'!$A:$A,'Recalculation Approval'!G19,'Overclaimed Costs'!$G:$G)","v":0},{"$f":"SUMIF('Overclaimed Costs'!$A:$A,'Recalculation Approval'!H19,'Overclaimed Costs'!$G:$G)","v":0},{"$f":"SUMIF('Overclaimed Costs'!$A:$A,'Recalculation Approval'!I19,'Overclaimed Costs'!$G:$G)","v":0},{"$f":"SUMIF('Overclaimed Costs'!$A:$A,'Recalculation Approval'!J19,'Overclaimed Costs'!$G:$G)","v":0},{"$f":"SUM(B33:J33)","v":0}]
[null,{"$f":"SUM(B31:B33)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
["FOR MA USE ONLY"]
[]
["Please note: The irregular expenditure identified here by the lead partner will be recovered by the Scottish Government.  This form should not include any items already noted by the Scottish Government via the Verification processes"]
["Checker Name:"," ",null,null,"Reviewer Name:"]
["Position:",null,null,null,"Position:"]
["Date Complete:",null,null,null,"Date Complete:"]

{"sheet":"Summary","index":3,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Claim Ref","Amount Originally Claimed ","Sum of Ineligible Value",null,null,null,"Claim Ref","Amount Originally Claimed ","Sum of Overclaim Value"]
[null,"(blank)",0,0,null,null,null,"(blank)"]
[null,"Grand Total",0,0,null,null,null,"Grand Total"]

{"sheet":"Ineligible Costs","index":4,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[]
["Total Ineligible Costs:",null,null,{"$f":"H25","v":0}]
[]
["Claim Ref","Cost Model Type","Cost Type","Cost Description (as per EUMIS description)","Defrayal Date","Amount Originally Claimed","Explanation of Error","Ineligible Value"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F5:F24)","v":0},null,{"$f":"SUM(H5:H24)","v":0}]
[]
[]
[null,null,null,null,null,"Original Amount Claimed","Ineligible"]
[null,null,null,null,{"$f":"Scratch!C11","v":"Flat-Rate - Direct Costs"},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Costs\"),F$5:F$24)","v":0},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Costs\"),H$5:H$24)","v":0}]
[null,null,null,null,{"$f":"Scratch!C12","v":"Flat-Rate - Direct Staff Costs ERDF"},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Staff Costs ERDF\"),F$5:F$24)","v":0},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Staff Costs ERDF\"),H$5:H$24)","v":0}]
[null,null,null,null,{"$f":"Scratch!C13","v":"Flat-Rate - Direct Staff Costs ESF"},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Staff Costs ESF\"),F$5:F$24)","v":0},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Staff Costs ESF\"),H$5:H$24)","v":0}]
[null,null,null,null,{"$f":"Scratch!C14","v":"Procurement/Actual"},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Procurement/Actual\"),F$5:F$24)","v":0},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Procurement/Actual\"),H$5:H$24)","v":0}]
[null,null,null,null,{"$f":"Scratch!C15","v":"Unit-Cost"},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Unit-Cost\"),F$5:F$24)","v":0},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Unit-Cost\"),H$5:H$24)","v":0}]

{"sheet":"Overclaimed Costs","index":5,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[]
["Total Over-Claimed Costs:",null,null,{"$f":"H25","v":0}]
[]
["Claim Ref","Cost Model Type","Cost Type","Cost Description ( as per EUMIs description )","Defrayal Date","Amount Originally Claimed","Explanation of Error","Overclaim Value"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F5:F23)","v":0},null,{"$f":"SUM(H5:H23)","v":0}]
[]
[]
[null,null,null,null,null,"Original Amount Claimed","Ineligible"]
[null,null,null,null,{"$f":"Scratch!C11","v":"Flat-Rate - Direct Costs"},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Costs\"),F$5:F$24)","v":0},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Costs\"),H$5:H$24)","v":0}]
[null,null,null,null,{"$f":"Scratch!C12","v":"Flat-Rate - Direct Staff Costs ERDF"},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Staff Costs ERDF\"),F$5:F$24)","v":0},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Staff Costs ERDF\"),H$5:H$24)","v":0}]
[null,null,null,null,{"$f":"Scratch!C13","v":"Flat-Rate - Direct Staff Costs ESF"},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Staff Costs ESF\"),F$5:F$24)","v":0},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Flat-Rate - Direct Staff Costs ESF\"),H$5:H$24)","v":0}]
[null,null,null,null,{"$f":"Scratch!C14","v":"Procurement/Actual"},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Procurement/Actual\"),F$5:F$24)","v":0},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Procurement/Actual\"),H$5:H$24)","v":0}]
[null,null,null,null,{"$f":"Scratch!C15","v":"Unit-Cost"},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Unit-Cost\"),F$5:F$24)","v":0},{"$f":"SUMPRODUCT(--(B$5:B$24=\"Unit-Cost\"),H$5:H$24)","v":0}]

{"sheet":"Scratch","index":6,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Flat-Rate - Direct Costs","Consultancy Fees and Contractors' Charges"]
[null,null,"Flat-Rate - Direct Staff Costs ERDF","Contingencies"]
[null,null,"Flat-Rate - Direct Staff Costs ESF","Direct Staff Costs"]
[null,null,"Procurement/Actual","Financial Engineering Instruments"]
[null,null,"Unit-Cost","Grant Schemes"]
[null,null,null,"Main Contract Works"]
[null,null,null,"Marketing"]
[null,null,null,"Moveable Infrastructure - Fixtures and Fittings"]
[null,null,null,"Other Eligible Project Costs"]
[null,null,null,"Pre-Contract Costs"]
[null,null,null,"Project Evaluation Fees"]
[null,null,null,"Purchase of Equipment"]
[null,null,null,"Purchase of Land"]
[null,null,null,"Purchase of Real Estate"]
[null,null,null,"Purchase of Second-Hand Equipment"]
[null,null,null,"Retentions"]
[null,null,null,"Wage Subsidies"]

{"sheet":"Ineligible Recipients","index":7,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["Ineligbile Recipients to be removed from EUMIS"]
[]
["Claim Ref","Recipient ","DOB/Start Date","Explanation of Error"]