{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Cover","Overview of the costs incurred","Coordinator","B2 or Affiliated","B3 or Affiliated","B4 or Affiliated","B5 or Affiliated","B6 or Affiliated","B7 or Affiliated","B8 or Affiliated","B9 or Affiliated","B10 or Affiliated","B11 or Affiliated","B12 or Affiliated","B13 or Affiliated","B14 or Affiliated","B15 or Affiliated","Hourly Rate Calculation ","do_not_delete_this_sheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":94,"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":"Cover","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,1,2,5],[23,1,24,4],[22,2,22,4],[21,2,21,4],[21,0,21,1],[22,0,22,1],[10,0,10,5],[12,0,12,5],[19,0,19,1],[20,0,20,1],[15,0,15,5],[16,0,16,5],[17,0,17,3],[19,2,19,4],[20,2,20,4]]}
[]
[]
[null,"\nEUROPEAN CLIMATE, INFRASTRUCTURE AND\nENVIRONMENT EXECUTIVE AGENCY (CINEA)\n\nCINEA.D - Natural resources, climate, sustainable blue economy and clean energy\nD.3 - Sustainable Blue Economy\n\n"]
[]
[]
[]
[]
[]
[]
[]
["European Maritime and Fisheries Fund (EMFF) "]
[]
["Model Financial Statement"]
[]
[]
[]
[]
["Please enter information in cells marked in green:"]
[]
["Project Number:"]
["Project Full Name:"]
["Coordinator:"]
["Reporting Period*:"]
[null,"*Please carefully fill in the reporting dates according to the Grant Agreement.\n"]
[]
[null,"For good follow-up of your statement, please always save this file with project "]
[null,"number and acronym as follows: \"Financial_statement_project_number_acronym\"."]

{"sheet":"Overview of the costs incurred","index":1,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,11,2,11],[0,0,0,1],[0,2,0,3],[0,5,0,6],[1,9,2,9],[1,10,2,10],[0,33,0,36],[1,14,2,14],[1,33,2,33],[1,34,2,34],[1,30,2,30],[1,31,2,31],[1,20,2,20],[1,19,2,19],[1,16,2,16],[0,25,0,32],[1,32,2,32],[1,23,2,23],[1,22,2,22],[1,36,2,36],[1,35,2,35],[1,28,2,28],[9,25,9,36],[19,0,19,1],[1,8,2,8],[1,1,2,1],[1,0,2,0],[1,7,2,7],[1,2,1,6],[18,12,18,15],[1,21,18,21],[1,15,2,15],[1,17,2,17],[18,22,18,23],[8,24,9,24],[7,11,8,11],[13,11,14,11],[18,0,18,1],[1,12,2,12],[1,13,2,13],[0,21,0,23],[0,24,7,24],[1,29,2,29],[1,27,2,27],[1,25,2,25]]}
["OVERVIEW OF COSTS INCURRED FOR PERIOD N°",null,null,{"$f":" IF(#REF!=\"\", \"\",#REF!)","v":{"$error":"#REF!"}},"TO"]
["Number of Beneficiary or Affiliated entity","Name of Beneficiary or Affiliated entity","Direct eligible cost",null,null,null,null,"Subtotal of direct eligible costs","Indirect eligible costs","Total eligible costs ","Requested Funding from the EU"]
[null,null,"Staff \nCosts","Sub-contracting","Travel costs and Subsistence ","Equipment ","Other Specific \nCosts"]
[1,{"$f":"Coordinator!F4","v":0},{"$f":"Coordinator!K34","v":0},{"$f":"Coordinator!K61","v":0},{"$f":"Coordinator!K88","v":0},{"$f":"Coordinator!K116","v":0},{"$f":"Coordinator!K143","v":0},{"$f":"SUM(C4:G4)","v":0},{"$f":"H4*0.07","v":0},{"$f":"SUM(H4:I4)","v":0}]
[2,{"$f":"'B2 or Affiliated'!F4","v":0},{"$f":"'B2 or Affiliated'!K34","v":0},{"$f":"'B2 or Affiliated'!K61","v":0},{"$f":"'B2 or Affiliated'!K88","v":0},{"$f":"'B2 or Affiliated'!K116","v":0},{"$f":"'B2 or Affiliated'!K143","v":0},0,0,{"$f":"SUM(H5:I5)","v":0}]
[3,{"$f":"'B3 or Affiliated'!F4","v":0},{"$f":"'B3 or Affiliated'!K34","v":0},{"$f":"'B3 or Affiliated'!K61","v":0},{"$f":"'B3 or Affiliated'!K88","v":0},{"$f":"'B3 or Affiliated'!K116","v":0},{"$f":"'B3 or Affiliated'!K143","v":0},0,0,0]
[4,{"$f":"'B4 or Affiliated'!F4","v":0},{"$f":"'B4 or Affiliated'!K34","v":0},{"$f":"'B4 or Affiliated'!K61","v":0},{"$f":"'B4 or Affiliated'!K88","v":0},{"$f":"'B4 or Affiliated'!K116","v":0},{"$f":"'B4 or Affiliated'!K143","v":0},0,0,0]
[5,{"$f":"'B5 or Affiliated'!F4","v":0},{"$f":"'B5 or Affiliated'!K34","v":0},{"$f":"'B5 or Affiliated'!K61","v":0},{"$f":"'B5 or Affiliated'!K88","v":0},{"$f":"'B5 or Affiliated'!K116","v":0},{"$f":"'B5 or Affiliated'!K143","v":0},0,0,0]
[6,{"$f":"'B6 or Affiliated'!F4","v":0},{"$f":"'B6 or Affiliated'!K34","v":0},{"$f":"'B6 or Affiliated'!K61","v":0},{"$f":"'B6 or Affiliated'!K88","v":0},{"$f":"'B6 or Affiliated'!K116","v":0},{"$f":"'B6 or Affiliated'!K143","v":0},0,0,0]
[7,{"$f":"'B7 or Affiliated'!F4","v":0},{"$f":"'B7 or Affiliated'!K34","v":0},{"$f":"'B7 or Affiliated'!K61","v":0},{"$f":"'B7 or Affiliated'!K88","v":0},{"$f":"'B7 or Affiliated'!K116","v":0},{"$f":"'B7 or Affiliated'!K143","v":0},0,0,0]
[8,{"$f":"'B8 or Affiliated'!F4","v":0},{"$f":"'B8 or Affiliated'!K34","v":0},{"$f":"'B8 or Affiliated'!K61","v":0},{"$f":"'B8 or Affiliated'!K88","v":0},{"$f":"'B8 or Affiliated'!K116","v":0},{"$f":"'B8 or Affiliated'!K143","v":0},0,0,0]
[9,{"$f":"'B9 or Affiliated'!F4","v":0},{"$f":"'B9 or Affiliated'!K34","v":0},{"$f":"'B9 or Affiliated'!K61","v":0},{"$f":"'B9 or Affiliated'!K88","v":0},{"$f":"'B9 or Affiliated'!K116","v":0},{"$f":"'B9 or Affiliated'!K143","v":0},0,0,0]
[10,{"$f":"'B10 or Affiliated'!F4","v":0},{"$f":"'B10 or Affiliated'!K34","v":0},{"$f":"'B10 or Affiliated'!K61","v":0},{"$f":"'B10 or Affiliated'!K88","v":0},{"$f":"'B10 or Affiliated'!K116","v":0},{"$f":"'B10 or Affiliated'!K143","v":0},0,0,0]
[11,{"$f":"'B11 or Affiliated'!F4","v":0},{"$f":"'B11 or Affiliated'!K34","v":0},{"$f":"'B11 or Affiliated'!K61","v":0},{"$f":"'B11 or Affiliated'!K88","v":0},{"$f":"'B11 or Affiliated'!K116","v":0},{"$f":"'B11 or Affiliated'!K143","v":0},0,0,0]
[12,{"$f":"'B12 or Affiliated'!F4","v":0},{"$f":"'B12 or Affiliated'!K34","v":0},{"$f":"'B12 or Affiliated'!K61","v":0},{"$f":"'B12 or Affiliated'!K88","v":0},{"$f":"'B12 or Affiliated'!K116","v":0},{"$f":"'B12 or Affiliated'!K143","v":0},0,0,0]
[13,{"$f":"'B13 or Affiliated'!F4","v":0},{"$f":"'B13 or Affiliated'!K34","v":0},{"$f":"'B13 or Affiliated'!K61","v":0},{"$f":"'B13 or Affiliated'!K88","v":0},{"$f":"'B13 or Affiliated'!K116","v":0},{"$f":"'B13 or Affiliated'!K143","v":0},0,0,0]
[14,{"$f":"'B14 or Affiliated'!F4","v":0},{"$f":"'B14 or Affiliated'!K34","v":0},{"$f":"'B14 or Affiliated'!K61","v":0},{"$f":"'B14 or Affiliated'!K88","v":0},{"$f":"'B14 or Affiliated'!K116","v":0},{"$f":"'B14 or Affiliated'!K143","v":0},0,0,0]
[15,{"$f":"'B15 or Affiliated'!F4","v":0},{"$f":"'B15 or Affiliated'!K34","v":0},{"$f":"'B15 or Affiliated'!K61","v":0},{"$f":"'B15 or Affiliated'!K88","v":0},{"$f":"'B15 or Affiliated'!K116","v":0},{"$f":"'B15 or Affiliated'!K143","v":0},0,0,0]
["TOTAL",null,{"$f":"SUM(C4:C18)","v":0},{"$f":"SUM(D4:D18)","v":0},0,0,0,0,0,0,{"$f":"SUM(K4:K18)","v":0}]

{"sheet":"Coordinator","index":2,"n_rows":189,"n_cols":25,"rows_kept":189,"cut":false,"hidden":false,"merged":[[12,6,12,7],[11,6,11,7],[11,3,11,5],[22,6,22,7],[22,3,22,5],[21,6,21,7],[21,3,21,5],[20,6,20,7],[19,6,19,7],[19,3,19,5],[14,6,14,7],[13,6,13,7],[13,3,13,5],[15,6,15,7],[17,6,17,7],[16,6,16,7],[18,6,18,7],[28,6,28,7],[28,3,28,5],[27,6,27,7],[27,3,27,5],[26,6,26,7],[26,3,26,5],[25,6,25,7],[24,6,24,7],[23,3,23,5],[23,6,23,7],[102,2,102,3],[103,2,103,3],[105,2,105,3],[106,2,106,3],[113,2,113,3],[86,3,86,5],[86,8,86,9],[55,2,55,4],[50,2,50,4],[51,2,51,4],[71,3,71,5],[57,2,57,4],[58,2,58,4],[97,2,97,3],[98,2,98,3],[94,2,94,3],[84,3,84,5],[84,8,84,9],[85,3,85,5],[85,8,85,9],[78,8,78,9],[79,3,79,5],[79,8,79,9],[82,8,82,9],[140,6,140,9],[114,2,114,3],[119,1,119,10],[107,2,107,3],[108,2,108,3],[109,2,109,3],[110,2,110,3],[111,2,111,3],[112,2,112,3],[130,2,130,3],[131,2,131,3],[141,6,141,9],[121,2,121,3],[138,6,138,9],[139,6,139,9],[136,6,136,9],[137,6,137,9],[134,6,134,9],[135,6,135,9],[132,6,132,9],[127,6,127,9],[128,6,128,9],[124,6,124,9],[123,6,123,9],[126,2,126,3],[127,2,127,3],[128,2,128,3],[121,6,121,9],[133,6,133,9],[129,6,129,9],[130,6,130,9],[126,6,126,9],[125,6,125,9],[124,2,124,3],[125,2,125,3],[56,7,56,9],[42,7,42,9],[43,7,43,9],[44,7,44,9],[50,7,50,9],[51,7,51,9],[83,3,83,5],[83,8,83,9],[80,3,80,5],[80,8,80,9],[81,3,81,5],[81,8,81,9],[82,3,82,5],[76,8,76,9],[77,3,77,5],[77,8,77,9],[78,3,78,5],[76,3,76,5],[41,2,41,4],[42,2,42,4],[54,2,54,4],[52,2,52,4],[53,2,53,4],[47,2,47,4],[43,2,43,4],[48,2,48,4],[49,2,49,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[40,2,40,4],[30,3,30,5],[31,3,31,5],[14,3,14,5],[15,3,15,5],[17,3,17,5],[20,3,20,5],[16,3,16,5],[18,3,18,5],[24,3,24,5],[25,3,25,5],[39,2,39,4],[33,6,33,7],[32,6,32,7],[32,3,32,5],[31,6,31,7],[30,6,30,7],[29,6,29,7],[29,3,29,5],[9,1,9,10],[144,1,144,10],[100,2,100,3],[40,7,40,9],[39,7,39,9],[41,7,41,9],[48,7,48,9],[37,1,37,10],[47,7,47,9],[45,7,45,9],[46,7,46,9],[49,7,49,9],[71,8,71,9],[68,3,68,5],[68,8,68,9],[69,3,69,5],[69,8,69,9],[164,2,164,8],[165,2,165,8],[149,2,149,8],[150,2,150,8],[151,2,151,8],[152,2,152,8],[53,7,53,9],[146,1,146,10],[95,2,95,3],[96,2,96,3],[91,1,91,10],[93,2,93,3],[87,8,87,9],[57,7,57,9],[66,3,66,5],[66,8,66,9],[132,2,132,3],[59,7,59,9],[60,7,60,9],[64,1,64,10],[67,3,67,5],[122,2,122,3],[123,2,123,3],[67,8,67,9],[148,2,148,8],[122,6,122,9],[58,7,58,9],[129,2,129,3],[99,2,99,3],[52,7,52,9],[74,8,74,9],[75,3,75,5],[75,8,75,9],[136,2,136,3],[137,2,137,3],[138,2,138,3],[101,2,101,3],[142,6,142,9],[70,3,70,5],[72,3,72,5],[72,8,72,9],[73,3,73,5],[73,8,73,9],[74,3,74,5],[56,2,56,4],[70,8,70,9],[54,7,54,9],[55,7,55,9],[188,2,188,11],[182,2,182,8],[174,1,174,10],[59,2,59,4],[133,2,133,3],[134,2,134,3],[139,2,139,3],[140,2,140,3],[141,2,141,3],[135,2,135,3],[154,2,154,8],[153,2,153,8],[158,2,158,8],[159,2,159,8],[160,2,160,8],[155,2,155,8],[156,2,156,8],[157,2,157,8],[168,2,168,8],[161,2,161,8],[162,2,162,8],[163,2,163,8],[166,2,166,8],[167,2,167,8]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff /In-house consultants","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person-hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description",null,"Date of the invoice\nAND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$f":"F102*G102*(H102/I102)*J102","v":{"$error":"#DIV/0!"}}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H4","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J4","v":0}]
[]
[null,"Statement by the beneficiary\nI certify that:\n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred."]
[]
[null,null,null,"Date:"]
[]
[null,null,null,"Name of the Legal Representative of the Coordinator or his/her Authorised Representative"]
[]
[null,null,null,"Signature of the Name of the Legal Representative of the Coordinator or his/her Authorised Representative"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records\n - representatives or the Court of Auditors and reflect the costs actually incurred.\n - are available for the purposes of audit by the EASME and its authorised\n"]

{"sheet":"B2 or Affiliated","index":3,"n_rows":179,"n_cols":25,"rows_kept":179,"cut":false,"hidden":false,"merged":[[126,2,126,3],[127,2,127,3],[128,2,128,3],[129,2,129,3],[130,2,130,3],[131,2,131,3],[132,2,132,3],[133,2,133,3],[125,2,125,3],[121,6,121,9],[122,6,122,9],[101,2,101,3],[93,2,93,3],[95,2,95,3],[58,7,58,9],[59,7,59,9],[91,1,91,10],[94,2,94,3],[98,2,98,3],[71,3,71,5],[72,3,72,5],[79,3,79,5],[78,8,78,9],[114,2,114,3],[119,1,119,10],[82,3,82,5],[82,8,82,9],[83,3,83,5],[83,8,83,9],[84,3,84,5],[84,8,84,9],[71,8,71,9],[74,3,74,5],[74,8,74,9],[81,3,81,5],[81,8,81,9],[85,3,85,5],[73,8,73,9],[79,8,79,9],[78,3,78,5],[76,3,76,5],[80,3,80,5],[80,8,80,9],[125,6,125,9],[149,2,149,8],[150,2,150,8],[139,6,139,9],[134,6,134,9],[123,6,123,9],[124,6,124,9],[132,6,132,9],[133,6,133,9],[126,6,126,9],[140,6,140,9],[130,6,130,9],[127,6,127,9],[128,6,128,9],[129,6,129,9],[135,6,135,9],[138,2,138,3],[139,2,139,3],[140,2,140,3],[141,2,141,3],[138,6,138,9],[137,6,137,9],[136,6,136,9],[134,2,134,3],[64,1,64,10],[67,3,67,5],[122,2,122,3],[123,2,123,3],[124,2,124,3],[121,2,121,3],[108,2,108,3],[109,2,109,3],[110,2,110,3],[87,8,87,9],[86,8,86,9],[103,2,103,3],[104,2,104,3],[105,2,105,3],[102,2,102,3],[99,2,99,3],[86,3,86,5],[96,2,96,3],[97,2,97,3],[100,2,100,3],[69,8,69,9],[111,2,111,3],[112,2,112,3],[113,2,113,3],[68,3,68,5],[66,3,66,5],[77,3,77,5],[77,8,77,9],[70,8,70,9],[53,7,53,9],[56,7,56,9],[24,3,24,5],[25,3,25,5],[26,3,26,5],[27,3,27,5],[41,7,41,9],[42,7,42,9],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[69,3,69,5],[59,2,59,4],[55,7,55,9],[55,2,55,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[27,6,27,7],[106,2,106,3],[85,8,85,9],[75,3,75,5],[75,8,75,9],[72,8,72,9],[76,8,76,9],[43,7,43,9],[44,7,44,9],[45,7,45,9],[46,7,46,9],[45,2,45,4],[46,2,46,4],[43,2,43,4],[44,2,44,4],[52,7,52,9],[51,7,51,9],[68,8,68,9],[54,7,54,9],[57,7,57,9],[67,8,67,9],[66,8,66,9],[60,7,60,9],[73,3,73,5],[33,6,33,7],[37,1,37,10],[70,3,70,5],[21,3,21,5],[22,3,22,5],[156,2,156,8],[157,2,157,8],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[23,3,23,5],[107,2,107,3],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[28,6,28,7],[29,3,29,5],[29,6,29,7],[30,3,30,5],[30,6,30,7],[28,3,28,5],[31,3,31,5],[31,6,31,7],[32,3,32,5],[32,6,32,7],[9,1,9,10],[11,6,11,7],[11,3,11,5],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[13,3,13,5],[14,3,14,5],[39,7,39,9],[40,7,40,9],[39,2,39,4],[40,2,40,4],[49,7,49,9],[50,7,50,9],[47,7,47,9],[48,7,48,9],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[42,2,42,4],[41,2,41,4],[136,2,136,3],[137,2,137,3],[135,2,135,3],[154,2,154,8],[155,2,155,8],[162,2,162,8],[163,2,163,8],[141,6,141,9],[142,6,142,9],[144,1,144,10],[151,2,151,8],[187,2,187,11],[181,1,181,8],[170,2,172,6],[170,7,172,10],[146,1,146,10],[148,2,148,8],[167,2,167,8],[168,2,168,8],[152,2,152,8],[153,2,153,8],[166,2,166,8],[158,2,158,8],[159,2,159,8],[160,2,160,8],[161,2,161,8],[164,2,164,8],[165,2,165,8]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In-house consultants","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person-hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description",null,"Date of the invoice\nAND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement.Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[null,null,"Statement by the beneficiary\nI certify that: \n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred."]
[]
[]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H5","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J5","v":0}]
[null,null,"Name of the Legal Representative or his/her Authorised Representative\n"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative"]

{"sheet":"B3 or Affiliated","index":4,"n_rows":179,"n_cols":25,"rows_kept":179,"cut":false,"hidden":false,"merged":[[123,2,123,3],[139,6,139,9],[135,6,135,9],[133,6,133,9],[134,6,134,9],[121,6,121,9],[130,6,130,9],[140,6,140,9],[122,6,122,9],[123,6,123,9],[133,2,133,3],[140,2,140,3],[134,2,134,3],[135,2,135,3],[136,2,136,3],[137,2,137,3],[138,2,138,3],[139,2,139,3],[124,6,124,9],[125,2,125,3],[131,2,131,3],[132,2,132,3],[126,6,126,9],[127,6,127,9],[126,2,126,3],[130,2,130,3],[132,6,132,9],[128,6,128,9],[59,2,59,4],[53,2,53,4],[54,2,54,4],[163,2,163,8],[164,2,164,8],[57,2,57,4],[58,2,58,4],[66,3,66,5],[66,8,66,9],[64,1,64,10],[77,3,77,5],[77,8,77,9],[78,3,78,5],[84,3,84,5],[101,2,101,3],[102,2,102,3],[96,2,96,3],[97,2,97,3],[111,2,111,3],[107,2,107,3],[165,2,165,8],[166,2,166,8],[55,2,55,4],[167,2,167,8],[122,2,122,3],[129,6,129,9],[94,2,94,3],[127,2,127,3],[128,2,128,3],[129,2,129,3],[125,6,125,9],[124,2,124,3],[150,2,150,8],[151,2,151,8],[146,1,146,10],[148,2,148,8],[56,2,56,4],[154,2,154,8],[152,2,152,8],[60,7,60,9],[67,3,67,5],[59,7,59,9],[57,7,57,9],[58,7,58,9],[31,6,31,7],[32,3,32,5],[41,2,41,4],[42,2,42,4],[45,2,45,4],[43,7,43,9],[40,2,40,4],[44,2,44,4],[43,2,43,4],[18,6,18,7],[17,3,17,5],[18,3,18,5],[20,6,20,7],[21,6,21,7],[22,6,22,7],[22,3,22,5],[44,7,44,9],[32,6,32,7],[33,6,33,7],[39,2,39,4],[30,6,30,7],[23,3,23,5],[28,3,28,5],[24,3,24,5],[25,3,25,5],[26,3,26,5],[27,3,27,5],[29,6,29,7],[30,3,30,5],[19,6,19,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[19,3,19,5],[48,2,48,4],[31,3,31,5],[56,7,56,9],[49,2,49,4],[50,2,50,4],[51,2,51,4],[52,2,52,4],[47,7,47,9],[47,2,47,4],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,3,29,5],[21,3,21,5],[20,3,20,5],[46,2,46,4],[45,7,45,9],[46,7,46,9],[41,7,41,9],[42,7,42,9],[37,1,37,10],[40,7,40,9],[39,7,39,9],[110,2,110,3],[112,2,112,3],[119,1,119,10],[121,2,121,3],[74,3,74,5],[98,2,98,3],[85,8,85,9],[100,2,100,3],[86,3,86,5],[86,8,86,9],[93,2,93,3],[83,3,83,5],[80,3,80,5],[81,3,81,5],[95,2,95,3],[87,8,87,9],[91,1,91,10],[99,2,99,3],[75,3,75,5],[75,8,75,9],[76,3,76,5],[76,8,76,9],[113,2,113,3],[108,2,108,3],[109,2,109,3],[72,3,72,5],[71,8,71,9],[72,8,72,9],[73,3,73,5],[69,3,69,5],[69,8,69,9],[70,3,70,5],[70,8,70,9],[73,8,73,9],[85,3,85,5],[103,2,103,3],[104,2,104,3],[105,2,105,3],[106,2,106,3],[82,3,82,5],[82,8,82,9],[78,8,78,9],[79,3,79,5],[79,8,79,9],[9,1,9,10],[11,6,11,7],[11,3,11,5],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[16,3,16,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[187,2,187,11],[181,1,181,8],[170,1,172,10],[168,2,168,8],[160,2,160,8],[161,2,161,8],[114,2,114,3],[48,7,48,9],[49,7,49,9],[54,7,54,9],[55,7,55,9],[50,7,50,9],[51,7,51,9],[52,7,52,9],[53,7,53,9],[84,8,84,9],[67,8,67,9],[80,8,80,9],[81,8,81,9],[83,8,83,9],[71,3,71,5],[74,8,74,9],[68,3,68,5],[68,8,68,9],[153,2,153,8],[138,6,138,9],[136,6,136,9],[137,6,137,9],[162,2,162,8],[155,2,155,8],[156,2,156,8],[157,2,157,8],[158,2,158,8],[159,2,159,8],[149,2,149,8],[144,1,144,10],[141,6,141,9],[142,6,142,9],[141,2,141,3]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In-house consultants ","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person-hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier ",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[null,"Statement by the beneficiary\nI certify that:\n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred."]
[]
[]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H6","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J6","v":0}]
[null,null,"Name of the Legal Representative or his/her Authorised Representative"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative"]

{"sheet":"B4 or Affiliated","index":5,"n_rows":178,"n_cols":25,"rows_kept":178,"cut":false,"hidden":false,"merged":[[104,2,104,3],[105,2,105,3],[106,2,106,3],[137,2,137,3],[138,2,138,3],[108,2,108,3],[109,2,109,3],[149,2,149,8],[150,2,150,8],[146,1,146,10],[148,2,148,8],[129,6,129,9],[139,2,139,3],[140,2,140,3],[135,2,135,3],[131,2,131,3],[132,2,132,3],[133,2,133,3],[134,2,134,3],[124,2,124,3],[126,2,126,3],[127,2,127,3],[130,2,130,3],[129,2,129,3],[56,2,56,4],[138,6,138,9],[121,6,121,9],[123,6,123,9],[137,6,137,9],[135,6,135,9],[134,6,134,9],[136,6,136,9],[122,2,122,3],[136,2,136,3],[98,2,98,3],[103,2,103,3],[72,3,72,5],[85,3,85,5],[84,3,84,5],[64,1,64,10],[86,8,86,9],[126,6,126,9],[127,6,127,9],[128,2,128,3],[121,2,121,3],[80,8,80,9],[81,3,81,5],[94,2,94,3],[81,8,81,9],[82,8,82,9],[83,3,83,5],[83,8,83,9],[84,8,84,9],[125,2,125,3],[97,2,97,3],[86,3,86,5],[95,2,95,3],[96,2,96,3],[122,6,122,9],[93,2,93,3],[119,1,119,10],[110,2,110,3],[112,2,112,3],[113,2,113,3],[114,2,114,3],[101,2,101,3],[124,6,124,9],[85,8,85,9],[99,2,99,3],[100,2,100,3],[111,2,111,3],[123,2,123,3],[74,8,74,9],[75,8,75,9],[75,3,75,5],[79,8,79,9],[76,3,76,5],[76,8,76,9],[77,3,77,5],[77,8,77,9],[78,3,78,5],[78,8,78,9],[67,8,67,9],[58,7,58,9],[48,7,48,9],[49,7,49,9],[53,7,53,9],[54,7,54,9],[44,2,44,4],[52,2,52,4],[55,7,55,9],[48,2,48,4],[49,2,49,4],[50,2,50,4],[51,2,51,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[50,7,50,9],[51,7,51,9],[57,7,57,9],[58,2,58,4],[59,7,59,9],[60,7,60,9],[54,2,54,4],[55,2,55,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[52,7,52,9],[57,2,57,4],[73,3,73,5],[79,3,79,5],[80,3,80,5],[82,3,82,5],[46,7,46,9],[69,3,69,5],[68,3,68,5],[72,8,72,9],[71,8,71,9],[71,3,71,5],[73,8,73,9],[74,3,74,5],[70,3,70,5],[70,8,70,9],[67,3,67,5],[68,8,68,9],[66,3,66,5],[66,8,66,9],[69,8,69,9],[13,3,13,5],[14,3,14,5],[15,3,15,5],[11,3,11,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[30,3,30,5],[23,3,23,5],[24,3,24,5],[25,3,25,5],[26,3,26,5],[30,6,30,7],[31,3,31,5],[31,6,31,7],[28,6,28,7],[29,3,29,5],[29,6,29,7],[32,6,32,7],[164,2,164,8],[140,6,140,9],[151,2,151,8],[152,2,152,8],[153,2,153,8],[154,2,154,8],[141,2,141,3],[141,6,141,9],[142,6,142,9],[144,1,144,10],[37,1,37,10],[39,7,39,9],[40,7,40,9],[39,2,39,4],[40,2,40,4],[107,2,107,3],[42,7,42,9],[43,7,43,9],[47,7,47,9],[44,7,44,9],[45,7,45,9],[56,7,56,9],[53,2,53,4],[160,2,160,8],[9,1,9,10],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[27,3,27,5],[28,3,28,5],[41,7,41,9],[33,6,33,7],[32,3,32,5],[186,2,186,11],[180,1,180,8],[170,1,172,9],[166,2,166,8],[167,2,167,8],[168,2,168,8],[163,2,163,8],[59,2,59,4],[87,8,87,9],[91,1,91,10],[128,6,128,9],[139,6,139,9],[132,6,132,9],[133,6,133,9],[102,2,102,3],[125,6,125,9],[155,2,155,8],[156,2,156,8],[157,2,157,8],[158,2,158,8],[161,2,161,8],[162,2,162,8],[165,2,165,8],[159,2,159,8]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff ","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof man-hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description\n",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period ","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[null,"Statement by the beneficiary\nI certify that:\n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred."]
[]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H7","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J7","v":0}]
[null,null,"Name of the Legal Representative or his/her Authorised Representative\n"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative"]

{"sheet":"B5 or Affiliated","index":6,"n_rows":179,"n_cols":25,"rows_kept":179,"cut":false,"hidden":false,"merged":[[168,2,168,8],[164,2,164,8],[165,2,165,8],[166,2,166,8],[139,2,139,3],[140,2,140,3],[57,2,57,4],[58,2,58,4],[59,7,59,9],[60,7,60,9],[59,2,59,4],[66,3,66,5],[93,2,93,3],[84,3,84,5],[86,8,86,9],[87,8,87,9],[78,8,78,9],[91,1,91,10],[122,2,122,3],[123,2,123,3],[125,6,125,9],[94,2,94,3],[113,2,113,3],[98,2,98,3],[19,3,19,5],[18,3,18,5],[16,3,16,5],[17,3,17,5],[27,3,27,5],[22,3,22,5],[15,3,15,5],[21,3,21,5],[23,3,23,5],[20,3,20,5],[24,3,24,5],[25,3,25,5],[26,3,26,5],[43,2,43,4],[72,3,72,5],[70,3,70,5],[37,1,37,10],[39,7,39,9],[44,7,44,9],[45,7,45,9],[40,7,40,9],[42,7,42,9],[72,8,72,9],[71,8,71,9],[56,2,56,4],[50,7,50,9],[54,7,54,9],[55,2,55,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[58,7,58,9],[32,3,32,5],[32,6,32,7],[33,6,33,7],[41,7,41,9],[69,3,69,5],[69,8,69,9],[67,3,67,5],[48,7,48,9],[49,7,49,9],[53,7,53,9],[68,8,68,9],[46,7,46,9],[51,7,51,9],[52,7,52,9],[47,7,47,9],[67,8,67,9],[56,7,56,9],[57,7,57,9],[66,8,66,9],[43,7,43,9],[55,7,55,9],[40,2,40,4],[41,2,41,4],[42,2,42,4],[135,2,135,3],[121,6,121,9],[138,6,138,9],[99,2,99,3],[100,2,100,3],[102,2,102,3],[135,6,135,9],[136,6,136,9],[140,6,140,9],[105,2,105,3],[106,2,106,3],[109,2,109,3],[107,2,107,3],[103,2,103,3],[104,2,104,3],[96,2,96,3],[101,2,101,3],[111,2,111,3],[114,2,114,3],[112,2,112,3],[122,6,122,9],[123,6,123,9],[95,2,95,3],[134,6,134,9],[124,6,124,9],[129,6,129,9],[133,6,133,9],[128,6,128,9],[127,6,127,9],[126,6,126,9],[124,2,124,3],[130,6,130,9],[132,6,132,9],[97,2,97,3],[9,1,9,10],[11,6,11,7],[11,3,11,5],[12,6,12,7],[13,6,13,7],[13,3,13,5],[14,6,14,7],[15,6,15,7],[16,6,16,7],[14,3,14,5],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,3,28,5],[28,6,28,7],[29,3,29,5],[29,6,29,7],[30,3,30,5],[30,6,30,7],[31,3,31,5],[31,6,31,7],[75,3,75,5],[75,8,75,9],[73,3,73,5],[73,8,73,9],[74,3,74,5],[74,8,74,9],[68,3,68,5],[70,8,70,9],[76,3,76,5],[76,8,76,9],[77,3,77,5],[77,8,77,9],[78,3,78,5],[79,8,79,9],[81,3,81,5],[132,2,132,3],[133,2,133,3],[141,2,141,3],[125,2,125,3],[126,2,126,3],[127,2,127,3],[128,2,128,3],[129,2,129,3],[134,2,134,3],[85,3,85,5],[85,8,85,9],[81,8,81,9],[82,3,82,5],[82,8,82,9],[84,8,84,9],[83,8,83,9],[79,3,79,5],[80,3,80,5],[80,8,80,9],[167,2,167,8],[154,2,154,8],[155,2,155,8],[156,2,156,8],[157,2,157,8],[151,2,151,8],[152,2,152,8],[153,2,153,8],[136,2,136,3],[146,1,146,10],[148,2,148,8],[149,2,149,8],[162,2,162,8],[163,2,163,8],[158,2,158,8],[141,6,141,9],[139,6,139,9],[137,6,137,9],[138,2,138,3],[160,2,160,8],[161,2,161,8],[159,2,159,8],[142,6,142,9],[144,1,144,10],[187,2,187,11],[181,1,181,8],[170,1,172,9],[83,3,83,5],[64,1,64,10],[39,2,39,4],[52,2,52,4],[53,2,53,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[71,3,71,5],[121,2,121,3],[54,2,54,4],[51,2,51,4],[108,2,108,3],[86,3,86,5],[119,1,119,10],[110,2,110,3],[150,2,150,8],[137,2,137,3],[130,2,130,3],[131,2,131,3]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In-house consultants ","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person-hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF FUNDING PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[null,"Statement by the beneficiary\nI certify that \n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred."]
[]
[]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H8","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J8","v":0}]
[null,null,"Name of the Legal Representative or his/her Authorised Representative \n"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative "]

{"sheet":"B6 or Affiliated","index":7,"n_rows":179,"n_cols":25,"rows_kept":179,"cut":false,"hidden":false,"merged":[[159,2,159,8],[152,2,152,8],[158,2,158,8],[161,2,161,8],[162,2,162,8],[163,2,163,8],[155,2,155,8],[111,2,111,3],[114,2,114,3],[112,2,112,3],[113,2,113,3],[127,2,127,3],[128,2,128,3],[126,2,126,3],[125,2,125,3],[130,6,130,9],[125,6,125,9],[123,6,123,9],[124,6,124,9],[128,6,128,9],[123,2,123,3],[124,2,124,3],[153,2,153,8],[154,2,154,8],[87,8,87,9],[83,3,83,5],[83,8,83,9],[79,3,79,5],[79,8,79,9],[81,3,81,5],[81,8,81,9],[82,3,82,5],[84,3,84,5],[80,8,80,9],[82,8,82,9],[73,8,73,9],[74,3,74,5],[66,3,66,5],[66,8,66,9],[85,3,85,5],[85,8,85,9],[86,3,86,5],[86,8,86,9],[71,3,71,5],[71,8,71,9],[69,3,69,5],[69,8,69,9],[70,3,70,5],[72,3,72,5],[72,8,72,9],[70,8,70,9],[50,2,50,4],[51,7,51,9],[59,7,59,9],[58,2,58,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[107,2,107,3],[95,2,95,3],[96,2,96,3],[97,2,97,3],[105,2,105,3],[93,2,93,3],[56,7,56,9],[57,7,57,9],[58,7,58,9],[60,7,60,9],[64,1,64,10],[59,2,59,4],[67,3,67,5],[68,3,68,5],[68,8,68,9],[67,8,67,9],[73,3,73,5],[24,3,24,5],[25,3,25,5],[22,3,22,5],[21,6,21,7],[22,6,22,7],[23,6,23,7],[39,7,39,9],[26,3,26,5],[55,7,55,9],[27,3,27,5],[24,6,24,7],[25,6,25,7],[26,6,26,7],[30,3,30,5],[30,6,30,7],[29,6,29,7],[27,6,27,7],[31,3,31,5],[31,6,31,7],[28,3,28,5],[28,6,28,7],[29,3,29,5],[43,7,43,9],[47,7,47,9],[18,3,18,5],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[23,3,23,5],[9,1,9,10],[11,6,11,7],[11,3,11,5],[12,6,12,7],[13,6,13,7],[13,3,13,5],[42,7,42,9],[32,3,32,5],[32,6,32,7],[33,6,33,7],[37,1,37,10],[39,2,39,4],[40,7,40,9],[41,7,41,9],[40,2,40,4],[41,2,41,4],[42,2,42,4],[15,3,15,5],[16,3,16,5],[17,3,17,5],[21,3,21,5],[20,3,20,5],[14,3,14,5],[19,3,19,5],[104,2,104,3],[99,2,99,3],[43,2,43,4],[54,7,54,9],[52,7,52,9],[53,7,53,9],[48,7,48,9],[51,2,51,4],[52,2,52,4],[77,3,77,5],[77,8,77,9],[46,7,46,9],[53,2,53,4],[54,2,54,4],[49,7,49,9],[50,7,50,9],[48,2,48,4],[49,2,49,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[44,7,44,9],[45,7,45,9],[108,2,108,3],[106,2,106,3],[74,8,74,9],[75,3,75,5],[75,8,75,9],[76,3,76,5],[76,8,76,9],[80,3,80,5],[122,6,122,9],[84,8,84,9],[98,2,98,3],[101,2,101,3],[102,2,102,3],[119,1,119,10],[103,2,103,3],[121,2,121,3],[122,2,122,3],[78,3,78,5],[78,8,78,9],[110,2,110,3],[109,2,109,3],[91,1,91,10],[94,2,94,3],[100,2,100,3],[150,2,150,8],[121,6,121,9],[127,6,127,9],[126,6,126,9],[129,6,129,9],[141,2,141,3],[131,2,131,3],[134,2,134,3],[134,6,134,9],[132,6,132,9],[133,2,133,3],[135,6,135,9],[136,6,136,9],[141,6,141,9],[135,2,135,3],[139,6,139,9],[136,2,136,3],[137,2,137,3],[138,2,138,3],[132,2,132,3],[133,6,133,9],[151,2,151,8],[148,2,148,8],[187,2,187,11],[181,1,181,8],[170,1,173,10],[129,2,129,3],[130,2,130,3],[160,2,160,8],[156,2,156,8],[157,2,157,8],[139,2,139,3],[140,2,140,3],[149,2,149,8],[137,6,137,9],[138,6,138,9],[140,6,140,9],[146,1,146,10],[142,6,142,9],[144,1,144,10],[168,2,168,8],[164,2,164,8],[165,2,165,8],[166,2,166,8],[167,2,167,8]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In-house consultants","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person-hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[null,"Statement by the beneficiary\nI certify that:\n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred."]
[]
[]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H9","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J9","v":0}]
[null,null,"Name of the Legal Representative or his/her Authorised Representative \n"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative "]

{"sheet":"B7 or Affiliated","index":8,"n_rows":179,"n_cols":25,"rows_kept":179,"cut":false,"hidden":false,"merged":[[159,2,159,8],[163,2,163,8],[125,6,125,9],[149,2,149,8],[126,6,126,9],[127,6,127,9],[132,6,132,9],[129,6,129,9],[130,6,130,9],[128,6,128,9],[127,2,127,3],[128,2,128,3],[129,2,129,3],[130,2,130,3],[131,2,131,3],[136,6,136,9],[133,6,133,9],[134,6,134,9],[135,6,135,9],[140,6,140,9],[141,6,141,9],[139,6,139,9],[137,6,137,9],[138,6,138,9],[19,3,19,5],[22,3,22,5],[45,7,45,9],[46,7,46,9],[45,2,45,4],[46,2,46,4],[47,7,47,9],[14,3,14,5],[122,6,122,9],[15,3,15,5],[16,3,16,5],[20,3,20,5],[21,3,21,5],[41,7,41,9],[42,7,42,9],[43,7,43,9],[44,7,44,9],[51,7,51,9],[52,7,52,9],[17,3,17,5],[27,3,27,5],[24,3,24,5],[25,3,25,5],[23,3,23,5],[26,3,26,5],[18,3,18,5],[48,7,48,9],[47,2,47,4],[48,2,48,4],[49,7,49,9],[50,7,50,9],[49,2,49,4],[50,2,50,4],[28,3,28,5],[28,6,28,7],[29,3,29,5],[29,6,29,7],[44,2,44,4],[30,3,30,5],[30,6,30,7],[31,3,31,5],[31,6,31,7],[39,7,39,9],[40,7,40,9],[32,3,32,5],[32,6,32,7],[41,2,41,4],[42,2,42,4],[53,7,53,9],[54,7,54,9],[55,7,55,9],[56,7,56,9],[67,3,67,5],[67,8,67,9],[58,7,58,9],[58,2,58,4],[55,2,55,4],[56,2,56,4],[57,7,57,9],[68,3,68,5],[68,8,68,9],[59,7,59,9],[60,7,60,9],[64,1,64,10],[66,3,66,5],[66,8,66,9],[59,2,59,4],[69,3,69,5],[69,8,69,9],[70,3,70,5],[70,8,70,9],[71,3,71,5],[71,8,71,9],[72,3,72,5],[72,8,72,9],[73,3,73,5],[73,8,73,9],[74,3,74,5],[74,8,74,9],[75,8,75,9],[76,3,76,5],[76,8,76,9],[77,3,77,5],[77,8,77,9],[78,3,78,5],[78,8,78,9],[85,3,85,5],[85,8,85,9],[79,3,79,5],[79,8,79,9],[80,3,80,5],[80,8,80,9],[86,8,86,9],[81,3,81,5],[81,8,81,9],[82,3,82,5],[82,8,82,9],[95,2,95,3],[96,2,96,3],[97,2,97,3],[93,2,93,3],[94,2,94,3],[84,3,84,5],[84,8,84,9],[83,3,83,5],[83,8,83,9],[87,8,87,9],[91,1,91,10],[121,6,121,9],[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[114,2,114,3],[119,1,119,10],[121,2,121,3],[112,2,112,3],[113,2,113,3],[110,2,110,3],[111,2,111,3],[123,6,123,9],[124,6,124,9],[9,1,9,10],[11,6,11,7],[11,3,11,5],[12,6,12,7],[13,6,13,7],[13,3,13,5],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[33,6,33,7],[37,1,37,10],[26,6,26,7],[27,6,27,7],[158,2,158,8],[142,6,142,9],[144,1,144,10],[146,1,146,10],[148,2,148,8],[152,2,152,8],[153,2,153,8],[150,2,150,8],[151,2,151,8],[141,2,141,3],[132,2,132,3],[133,2,133,3],[134,2,134,3],[135,2,135,3],[137,2,137,3],[187,2,187,11],[181,1,181,8],[170,2,172,9],[168,2,168,8],[164,2,164,8],[165,2,165,8],[166,2,166,8],[167,2,167,8],[138,2,138,3],[139,2,139,3],[136,2,136,3],[160,2,160,8],[161,2,161,8],[162,2,162,8],[154,2,154,8],[155,2,155,8],[156,2,156,8],[157,2,157,8],[39,2,39,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[57,2,57,4],[40,2,40,4],[43,2,43,4],[140,2,140,3],[122,2,122,3],[123,2,123,3],[124,2,124,3],[125,2,125,3],[126,2,126,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[86,3,86,5],[75,3,75,5]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In-house consultants","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person -hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the FinalStatement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[null,null,"Statement by the beneficiary\nI certify that: \n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred.\n"]
[]
[]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H10","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J10","v":0}]
[null,null,"Name of the Legal Representative or his/her Authorised Representative \n"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative"]

{"sheet":"B8 or Affiliated","index":9,"n_rows":188,"n_cols":25,"rows_kept":188,"cut":false,"hidden":false,"merged":[[85,3,85,5],[85,8,85,9],[173,1,173,9],[86,3,86,5],[86,8,86,9],[87,8,87,9],[91,1,91,10],[93,2,93,3],[94,2,94,3],[97,2,97,3],[126,6,126,9],[132,6,132,9],[130,6,130,9],[130,2,130,3],[121,6,121,9],[114,2,114,3],[119,1,119,10],[112,2,112,3],[113,2,113,3],[124,6,124,9],[125,6,125,9],[124,2,124,3],[125,2,125,3],[110,2,110,3],[68,3,68,5],[68,8,68,9],[69,3,69,5],[69,8,69,9],[82,3,82,5],[82,8,82,9],[84,3,84,5],[84,8,84,9],[78,3,78,5],[78,8,78,9],[81,3,81,5],[81,8,81,9],[79,3,79,5],[79,8,79,9],[80,3,80,5],[80,8,80,9],[83,3,83,5],[83,8,83,9],[70,3,70,5],[70,8,70,9],[71,3,71,5],[71,8,71,9],[72,3,72,5],[72,8,72,9],[57,7,57,9],[67,3,67,5],[67,8,67,9],[58,7,58,9],[59,7,59,9],[60,7,60,9],[64,1,64,10],[57,2,57,4],[58,2,58,4],[59,2,59,4],[66,3,66,5],[66,8,66,9],[55,7,55,9],[56,7,56,9],[55,2,55,4],[56,2,56,4],[45,2,45,4],[53,7,53,9],[54,7,54,9],[53,2,53,4],[54,2,54,4],[51,7,51,9],[52,7,52,9],[51,2,51,4],[52,2,52,4],[49,2,49,4],[50,2,50,4],[45,7,45,9],[46,7,46,9],[47,7,47,9],[48,7,48,9],[48,2,48,4],[33,6,33,7],[31,3,31,5],[37,1,37,10],[39,7,39,9],[40,7,40,9],[43,7,43,9],[44,7,44,9],[41,7,41,9],[42,7,42,9],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[44,2,44,4],[26,3,26,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[144,1,144,10],[128,2,128,3],[129,2,129,3],[129,6,129,9],[131,2,131,3],[132,2,132,3],[135,2,135,3],[136,2,136,3],[27,3,27,5],[30,3,30,5],[30,6,30,7],[43,2,43,4],[31,6,31,7],[32,3,32,5],[32,6,32,7],[23,3,23,5],[49,7,49,9],[50,7,50,9],[16,6,16,7],[17,6,17,7],[127,6,127,9],[128,6,128,9],[126,2,126,3],[127,2,127,3],[17,3,17,5],[16,3,16,5],[24,3,24,5],[25,3,25,5],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,3,29,5],[29,6,29,7],[28,3,28,5],[9,1,9,10],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[11,3,11,5],[13,3,13,5],[15,3,15,5],[14,3,14,5],[73,3,73,5],[73,8,73,9],[139,6,139,9],[98,2,98,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[76,3,76,5],[76,8,76,9],[77,3,77,5],[77,8,77,9],[74,3,74,5],[74,8,74,9],[75,3,75,5],[75,8,75,9],[138,6,138,9],[95,2,95,3],[96,2,96,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[122,6,122,9],[123,6,123,9],[111,2,111,3],[154,2,154,8],[163,2,163,8],[164,2,164,8],[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[141,6,141,9],[142,6,142,9],[122,2,122,3],[123,2,123,3],[155,2,155,8],[151,2,151,8],[133,2,133,3],[134,2,134,3],[140,6,140,9],[156,2,156,8],[152,2,152,8],[153,2,153,8],[133,6,133,9],[136,6,136,9],[137,6,137,9],[134,6,134,9],[135,6,135,9],[187,2,187,11],[46,2,46,4],[47,2,47,4],[141,2,141,3],[121,2,121,3],[137,2,137,3],[138,2,138,3],[139,2,139,3],[167,2,167,8],[168,2,168,8],[157,2,157,8],[158,2,158,8],[159,2,159,8],[160,2,160,8],[161,2,161,8],[162,2,162,8],[140,2,140,3],[165,2,165,8],[166,2,166,8],[149,2,149,8],[150,2,150,8],[146,1,146,10],[148,2,148,8]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In house consultants","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person -hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description ",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H11","v":0}]
[]
[null,"Statement by the beneficiary\nI certify that: \n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred.\n \n"]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J11","v":0}]
[]
[null,null,"Name of the Legal Representative or his/her Authorised Representative \n"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative \n"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"\n - \n - are available for the purposes of audit by the EASME and its authorised\n"]

{"sheet":"B9 or Affiliated","index":10,"n_rows":179,"n_cols":25,"rows_kept":179,"cut":false,"hidden":false,"merged":[[150,2,150,8],[151,2,151,8],[125,6,125,9],[149,2,149,8],[126,6,126,9],[127,6,127,9],[132,6,132,9],[129,6,129,9],[130,6,130,9],[135,6,135,9],[133,2,133,3],[134,2,134,3],[133,6,133,9],[134,6,134,9],[142,6,142,9],[144,1,144,10],[146,1,146,10],[148,2,148,8],[141,2,141,3],[140,6,140,9],[141,6,141,9],[123,6,123,9],[124,6,124,9],[128,6,128,9],[124,2,124,3],[125,2,125,3],[126,2,126,3],[127,2,127,3],[128,2,128,3],[19,3,19,5],[22,3,22,5],[55,2,55,4],[56,2,56,4],[67,3,67,5],[67,8,67,9],[59,7,59,9],[60,7,60,9],[64,1,64,10],[58,7,58,9],[58,2,58,4],[68,3,68,5],[68,8,68,9],[69,3,69,5],[69,8,69,9],[70,3,70,5],[14,3,14,5],[122,6,122,9],[15,3,15,5],[16,3,16,5],[20,3,20,5],[21,3,21,5],[41,7,41,9],[42,7,42,9],[43,7,43,9],[44,7,44,9],[46,7,46,9],[46,2,46,4],[47,7,47,9],[48,7,48,9],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[66,3,66,5],[66,8,66,9],[51,7,51,9],[52,7,52,9],[53,7,53,9],[54,7,54,9],[13,3,13,5],[17,3,17,5],[27,3,27,5],[24,3,24,5],[25,3,25,5],[23,3,23,5],[26,3,26,5],[18,3,18,5],[45,7,45,9],[45,2,45,4],[18,6,18,7],[41,2,41,4],[31,6,31,7],[23,6,23,7],[24,6,24,7],[32,3,32,5],[32,6,32,7],[33,6,33,7],[29,6,29,7],[28,6,28,7],[29,3,29,5],[42,2,42,4],[43,2,43,4],[44,2,44,4],[70,8,70,9],[71,3,71,5],[71,8,71,9],[72,3,72,5],[72,8,72,9],[73,3,73,5],[73,8,73,9],[74,3,74,5],[74,8,74,9],[75,3,75,5],[75,8,75,9],[76,3,76,5],[76,8,76,9],[77,3,77,5],[77,8,77,9],[78,3,78,5],[78,8,78,9],[85,3,85,5],[85,8,85,9],[79,3,79,5],[79,8,79,9],[80,3,80,5],[80,8,80,9],[86,3,86,5],[86,8,86,9],[81,3,81,5],[81,8,81,9],[82,3,82,5],[82,8,82,9],[84,3,84,5],[84,8,84,9],[83,3,83,5],[83,8,83,9],[95,2,95,3],[96,2,96,3],[97,2,97,3],[93,2,93,3],[94,2,94,3],[98,2,98,3],[101,2,101,3],[121,6,121,9],[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[114,2,114,3],[119,1,119,10],[103,2,103,3],[111,2,111,3],[9,1,9,10],[11,6,11,7],[11,3,11,5],[12,6,12,7],[13,6,13,7],[99,2,99,3],[100,2,100,3],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[55,7,55,9],[56,7,56,9],[49,7,49,9],[50,7,50,9],[37,1,37,10],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,3,28,5],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[57,7,57,9],[30,3,30,5],[30,6,30,7],[31,3,31,5],[57,2,57,4],[40,2,40,4],[139,6,139,9],[137,6,137,9],[138,6,138,9],[39,7,39,9],[40,7,40,9],[87,8,87,9],[91,1,91,10],[112,2,112,3],[113,2,113,3],[110,2,110,3],[139,2,139,3],[136,6,136,9],[105,2,105,3],[102,2,102,3],[59,2,59,4],[39,2,39,4],[51,2,51,4],[52,2,52,4],[160,2,160,8],[161,2,161,8],[162,2,162,8],[163,2,163,8],[152,2,152,8],[153,2,153,8],[154,2,154,8],[155,2,155,8],[156,2,156,8],[157,2,157,8],[159,2,159,8],[53,2,53,4],[54,2,54,4],[104,2,104,3],[187,2,187,11],[181,2,181,8],[170,1,172,9],[135,2,135,3],[136,2,136,3],[121,2,121,3],[122,2,122,3],[123,2,123,3],[132,2,132,3],[158,2,158,8],[168,2,168,8],[164,2,164,8],[165,2,165,8],[166,2,166,8],[167,2,167,8],[129,2,129,3],[130,2,130,3],[131,2,131,3],[140,2,140,3],[137,2,137,3],[138,2,138,3]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In-house consultants","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person-hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description ",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period ","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[null,"Statement by the beneficiary\nI certify that: \n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred."]
[]
[]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H12","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J12","v":0}]
[null,null,"Name of the Legal Representative or his/her Authorised Representative \n"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative \n"]

{"sheet":"B10 or Affiliated","index":11,"n_rows":179,"n_cols":25,"rows_kept":179,"cut":false,"hidden":false,"merged":[[136,2,136,3],[94,2,94,3],[126,2,126,3],[127,2,127,3],[128,2,128,3],[113,2,113,3],[95,2,95,3],[96,2,96,3],[99,2,99,3],[100,2,100,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[112,2,112,3],[130,6,130,9],[128,6,128,9],[131,2,131,3],[129,2,129,3],[130,2,130,3],[132,2,132,3],[133,2,133,3],[134,2,134,3],[114,2,114,3],[123,2,123,3],[124,2,124,3],[119,1,119,10],[121,6,121,9],[129,6,129,9],[137,2,137,3],[141,6,141,9],[142,6,142,9],[141,2,141,3],[152,2,152,8],[151,2,151,8],[168,2,168,8],[161,2,161,8],[162,2,162,8],[163,2,163,8],[149,2,149,8],[150,2,150,8],[139,6,139,9],[140,6,140,9],[144,1,144,10],[87,8,87,9],[91,1,91,10],[135,6,135,9],[132,6,132,9],[133,6,133,9],[109,2,109,3],[110,2,110,3],[111,2,111,3],[125,2,125,3],[93,2,93,3],[106,2,106,3],[97,2,97,3],[122,6,122,9],[123,6,123,9],[124,6,124,9],[125,6,125,9],[126,6,126,9],[134,6,134,9],[107,2,107,3],[108,2,108,3],[127,6,127,9],[121,2,121,3],[122,2,122,3],[102,2,102,3],[82,8,82,9],[84,3,84,5],[84,8,84,9],[83,3,83,5],[83,8,83,9],[85,3,85,5],[85,8,85,9],[86,3,86,5],[86,8,86,9],[78,8,78,9],[81,3,81,5],[81,8,81,9],[79,3,79,5],[79,8,79,9],[80,3,80,5],[80,8,80,9],[76,8,76,9],[77,3,77,5],[77,8,77,9],[73,8,73,9],[74,3,74,5],[74,8,74,9],[75,8,75,9],[67,8,67,9],[58,7,58,9],[59,7,59,9],[60,7,60,9],[64,1,64,10],[66,3,66,5],[66,8,66,9],[71,3,71,5],[71,8,71,9],[72,3,72,5],[72,8,72,9],[70,8,70,9],[56,7,56,9],[55,2,55,4],[56,2,56,4],[57,7,57,9],[54,7,54,9],[53,2,53,4],[54,2,54,4],[55,7,55,9],[52,7,52,9],[47,7,47,9],[46,7,46,9],[39,2,39,4],[40,2,40,4],[23,3,23,5],[27,6,27,7],[29,3,29,5],[29,6,29,7],[27,3,27,5],[28,6,28,7],[26,3,26,5],[24,3,24,5],[25,3,25,5],[30,6,30,7],[31,6,31,7],[32,3,32,5],[32,6,32,7],[33,6,33,7],[31,3,31,5],[30,3,30,5],[41,2,41,4],[42,2,42,4],[39,7,39,9],[37,1,37,10],[28,3,28,5],[22,3,22,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[21,3,21,5],[9,1,9,10],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[17,6,17,7],[15,6,15,7],[16,6,16,7],[14,3,14,5],[16,3,16,5],[17,3,17,5],[11,3,11,5],[13,3,13,5],[15,3,15,5],[40,7,40,9],[45,7,45,9],[41,7,41,9],[42,7,42,9],[44,2,44,4],[45,2,45,4],[43,2,43,4],[68,8,68,9],[69,3,69,5],[69,8,69,9],[68,3,68,5],[43,7,43,9],[44,7,44,9],[51,2,51,4],[52,2,52,4],[53,7,53,9],[50,7,50,9],[49,2,49,4],[50,2,50,4],[51,7,51,9],[48,7,48,9],[48,2,48,4],[49,7,49,9],[47,2,47,4],[46,2,46,4],[57,2,57,4],[58,2,58,4],[59,2,59,4],[101,2,101,3],[70,3,70,5],[67,3,67,5],[75,3,75,5],[98,2,98,3],[73,3,73,5],[76,3,76,5],[78,3,78,5],[82,3,82,5],[187,2,187,11],[181,2,181,8],[170,1,172,9],[139,2,139,3],[140,2,140,3],[135,2,135,3],[157,2,157,8],[158,2,158,8],[159,2,159,8],[160,2,160,8],[164,2,164,8],[138,6,138,9],[136,6,136,9],[137,6,137,9],[156,2,156,8],[153,2,153,8],[154,2,154,8],[155,2,155,8],[146,1,146,10],[148,2,148,8],[165,2,165,8],[166,2,166,8],[167,2,167,8],[138,2,138,3]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In house consultants ","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person -hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description  ",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period ","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[null,"Statement by the beneficiary\nI certify that: \n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred."]
[]
[]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H13","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J13","v":0}]
[null,null,"Name of the Legal Representative or his/her Authorised Representative  \n"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative "]

{"sheet":"B11 or Affiliated","index":12,"n_rows":179,"n_cols":25,"rows_kept":179,"cut":false,"hidden":false,"merged":[[150,2,150,8],[151,2,151,8],[125,6,125,9],[149,2,149,8],[126,6,126,9],[127,6,127,9],[132,6,132,9],[129,6,129,9],[130,6,130,9],[128,6,128,9],[127,2,127,3],[128,2,128,3],[129,2,129,3],[130,2,130,3],[131,2,131,3],[136,6,136,9],[133,6,133,9],[134,6,134,9],[135,6,135,9],[140,6,140,9],[141,6,141,9],[144,1,144,10],[146,1,146,10],[19,3,19,5],[22,3,22,5],[45,7,45,9],[46,7,46,9],[45,2,45,4],[46,2,46,4],[47,7,47,9],[14,3,14,5],[122,6,122,9],[15,3,15,5],[16,3,16,5],[20,3,20,5],[21,3,21,5],[41,7,41,9],[42,7,42,9],[43,7,43,9],[44,7,44,9],[17,3,17,5],[27,3,27,5],[24,3,24,5],[25,3,25,5],[23,3,23,5],[26,3,26,5],[18,3,18,5],[48,7,48,9],[47,2,47,4],[48,2,48,4],[49,7,49,9],[50,7,50,9],[49,2,49,4],[50,2,50,4],[51,7,51,9],[52,7,52,9],[53,7,53,9],[54,7,54,9],[55,7,55,9],[56,7,56,9],[67,3,67,5],[67,8,67,9],[68,3,68,5],[68,8,68,9],[58,7,58,9],[59,2,59,4],[66,3,66,5],[66,8,66,9],[59,7,59,9],[60,7,60,9],[64,1,64,10],[69,3,69,5],[69,8,69,9],[70,3,70,5],[70,8,70,9],[71,3,71,5],[71,8,71,9],[72,3,72,5],[72,8,72,9],[73,3,73,5],[73,8,73,9],[85,3,85,5],[85,8,85,9],[86,3,86,5],[86,8,86,9],[81,3,81,5],[81,8,81,9],[82,3,82,5],[82,8,82,9],[95,2,95,3],[87,8,87,9],[91,1,91,10],[97,2,97,3],[93,2,93,3],[94,2,94,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[121,6,121,9],[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[114,2,114,3],[119,1,119,10],[121,2,121,3],[112,2,112,3],[113,2,113,3],[110,2,110,3],[111,2,111,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[124,6,124,9],[9,1,9,10],[11,6,11,7],[11,3,11,5],[12,6,12,7],[13,6,13,7],[13,3,13,5],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,3,28,5],[28,6,28,7],[96,2,96,3],[29,3,29,5],[29,6,29,7],[30,3,30,5],[30,6,30,7],[31,3,31,5],[31,6,31,7],[39,7,39,9],[40,7,40,9],[39,2,39,4],[32,3,32,5],[32,6,32,7],[33,6,33,7],[37,1,37,10],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[57,7,57,9],[84,3,84,5],[84,8,84,9],[83,3,83,5],[83,8,83,9],[79,3,79,5],[79,8,79,9],[80,3,80,5],[80,8,80,9],[56,2,56,4],[74,3,74,5],[74,8,74,9],[75,3,75,5],[75,8,75,9],[76,3,76,5],[76,8,76,9],[77,3,77,5],[77,8,77,9],[78,3,78,5],[78,8,78,9],[156,2,156,8],[157,2,157,8],[158,2,158,8],[159,2,159,8],[122,2,122,3],[123,2,123,3],[124,2,124,3],[125,2,125,3],[126,2,126,3],[139,6,139,9],[137,6,137,9],[138,6,138,9],[142,6,142,9],[136,2,136,3],[140,2,140,3],[141,2,141,3],[132,2,132,3],[133,2,133,3],[134,2,134,3],[135,2,135,3],[137,2,137,3],[138,2,138,3],[139,2,139,3],[123,6,123,9],[187,2,187,11],[181,2,181,8],[170,1,172,9],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[57,2,57,4],[58,2,58,4],[55,2,55,4],[160,2,160,8],[161,2,161,8],[162,2,162,8],[163,2,163,8],[168,2,168,8],[164,2,164,8],[165,2,165,8],[166,2,166,8],[167,2,167,8],[148,2,148,8],[152,2,152,8],[153,2,153,8],[154,2,154,8],[155,2,155,8]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In-house consultants ","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person -hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description ",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period ","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[null,"Statement by the beneficiary\nI certify that:\n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records  are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred.\n"]
[]
[]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H14","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J14","v":0}]
[null,null,"Name of the Legal Representative or his/her Authorised Representative  \n"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative  "]

{"sheet":"B12 or Affiliated","index":13,"n_rows":189,"n_cols":25,"rows_kept":189,"cut":false,"hidden":false,"merged":[[156,2,156,8],[152,2,152,8],[153,2,153,8],[95,2,95,3],[85,8,85,9],[82,3,82,5],[86,3,86,5],[87,8,87,9],[91,1,91,10],[86,8,86,9],[138,6,138,9],[83,3,83,5],[83,8,83,9],[136,6,136,9],[137,6,137,9],[129,2,129,3],[130,2,130,3],[134,6,134,9],[135,6,135,9],[131,2,131,3],[132,2,132,3],[121,6,121,9],[106,2,106,3],[107,2,107,3],[79,8,79,9],[80,3,80,5],[77,8,77,9],[122,6,122,9],[123,6,123,9],[124,6,124,9],[125,6,125,9],[126,6,126,9],[122,2,122,3],[123,2,123,3],[124,2,124,3],[125,2,125,3],[126,2,126,3],[101,2,101,3],[110,2,110,3],[111,2,111,3],[97,2,97,3],[102,2,102,3],[112,2,112,3],[113,2,113,3],[121,2,121,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[72,8,72,9],[73,3,73,5],[73,8,73,9],[74,8,74,9],[82,8,82,9],[84,3,84,5],[84,8,84,9],[57,7,57,9],[67,3,67,5],[67,8,67,9],[58,7,58,9],[59,7,59,9],[60,7,60,9],[66,3,66,5],[66,8,66,9],[57,2,57,4],[58,2,58,4],[71,8,71,9],[80,8,80,9],[75,8,75,9],[76,3,76,5],[76,8,76,9],[78,3,78,5],[78,8,78,9],[19,6,19,7],[20,6,20,7],[21,6,21,7],[46,2,46,4],[31,6,31,7],[32,3,32,5],[32,6,32,7],[33,6,33,7],[31,3,31,5],[37,1,37,10],[39,7,39,9],[39,2,39,4],[40,2,40,4],[40,7,40,9],[43,7,43,9],[44,7,44,9],[41,7,41,9],[42,7,42,9],[45,7,45,9],[46,7,46,9],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[9,1,9,10],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[17,3,17,5],[15,3,15,5],[14,3,14,5],[16,3,16,5],[11,3,11,5],[13,3,13,5],[18,3,18,5],[26,6,26,7],[30,3,30,5],[30,6,30,7],[28,3,28,5],[24,3,24,5],[25,3,25,5],[26,3,26,5],[23,3,23,5],[27,6,27,7],[28,6,28,7],[29,3,29,5],[29,6,29,7],[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[27,3,27,5],[81,3,81,5],[81,8,81,9],[79,3,79,5],[161,2,161,8],[98,2,98,3],[99,2,99,3],[100,2,100,3],[41,2,41,4],[42,2,42,4],[59,2,59,4],[74,3,74,5],[70,3,70,5],[68,3,68,5],[72,3,72,5],[64,1,64,10],[68,8,68,9],[69,3,69,5],[69,8,69,9],[49,7,49,9],[108,2,108,3],[146,1,146,10],[148,2,148,8],[149,2,149,8],[136,2,136,3],[140,6,140,9],[127,6,127,9],[128,6,128,9],[127,2,127,3],[128,2,128,3],[165,2,165,8],[166,2,166,8],[129,6,129,9],[130,6,130,9],[157,2,157,8],[158,2,158,8],[159,2,159,8],[160,2,160,8],[134,2,134,3],[154,2,154,8],[155,2,155,8],[151,2,151,8],[139,6,139,9],[135,2,135,3],[141,6,141,9],[142,6,142,9],[144,1,144,10],[133,2,133,3],[162,2,162,8],[163,2,163,8],[132,6,132,9],[133,6,133,9],[164,2,164,8],[150,2,150,8],[50,7,50,9],[49,2,49,4],[50,2,50,4],[47,7,47,9],[48,7,48,9],[47,2,47,4],[48,2,48,4],[55,7,55,9],[56,7,56,9],[55,2,55,4],[56,2,56,4],[53,7,53,9],[54,7,54,9],[53,2,53,4],[54,2,54,4],[51,7,51,9],[52,7,52,9],[51,2,51,4],[52,2,52,4],[188,2,188,11],[182,2,182,8],[170,2,173,9],[43,2,43,4],[44,2,44,4],[45,2,45,4],[77,3,77,5],[75,3,75,5],[70,8,70,9],[71,3,71,5],[114,2,114,3],[119,1,119,10],[85,3,85,5],[96,2,96,3],[93,2,93,3],[94,2,94,3],[109,2,109,3],[167,2,167,8],[168,2,168,8],[141,2,141,3],[137,2,137,3],[138,2,138,3],[139,2,139,3],[140,2,140,3]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In house consultants","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person -hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description ",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period ","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[null,null,"Statement by the beneficiary\nI certify that: \n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred."]
[]
[]
[]
[]
[null,null,"Date:",null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H15","v":0}]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J15","v":0}]
[null,null,"Name of the Legal Representative or his/her Authorised Representative  \n"]
[]
[null,null,"Signature of the Legal Representative or his/her Authorised Representative  "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"\n"]

{"sheet":"B13 or Affiliated","index":14,"n_rows":181,"n_cols":25,"rows_kept":181,"cut":false,"hidden":false,"merged":[[173,1,173,9],[19,3,19,5],[22,3,22,5],[122,6,122,9],[20,3,20,5],[21,3,21,5],[41,7,41,9],[42,7,42,9],[43,7,43,9],[44,7,44,9],[46,7,46,9],[46,2,46,4],[47,7,47,9],[48,7,48,9],[47,2,47,4],[48,2,48,4],[49,7,49,9],[50,7,50,9],[49,2,49,4],[50,2,50,4],[27,3,27,5],[24,3,24,5],[25,3,25,5],[23,3,23,5],[26,3,26,5],[18,3,18,5],[45,7,45,9],[45,2,45,4],[29,3,29,5],[29,6,29,7],[30,3,30,5],[30,6,30,7],[31,3,31,5],[31,6,31,7],[39,7,39,9],[40,7,40,9],[39,2,39,4],[32,3,32,5],[32,6,32,7],[33,6,33,7],[37,1,37,10],[40,2,40,4],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[51,7,51,9],[52,7,52,9],[53,7,53,9],[54,7,54,9],[55,7,55,9],[56,7,56,9],[55,2,55,4],[56,2,56,4],[67,3,67,5],[67,8,67,9],[58,7,58,9],[59,2,59,4],[59,7,59,9],[60,7,60,9],[64,1,64,10],[68,3,68,5],[68,8,68,9],[66,3,66,5],[66,8,66,9],[69,3,69,5],[69,8,69,9],[70,3,70,5],[70,8,70,9],[71,3,71,5],[71,8,71,9],[82,3,82,5],[82,8,82,9],[84,3,84,5],[84,8,84,9],[72,3,72,5],[72,8,72,9],[73,3,73,5],[73,8,73,9],[74,3,74,5],[74,8,74,9],[75,3,75,5],[75,8,75,9],[76,3,76,5],[76,8,76,9],[133,2,133,3],[134,2,134,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[123,2,123,3],[83,3,83,5],[83,8,83,9],[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[114,2,114,3],[119,1,119,10],[133,6,133,9],[126,6,126,9],[93,2,93,3],[94,2,94,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[85,3,85,5],[85,8,85,9],[130,6,130,9],[123,6,123,9],[124,6,124,9],[128,6,128,9],[124,2,124,3],[125,2,125,3],[126,2,126,3],[127,2,127,3],[128,2,128,3],[125,6,125,9],[9,1,9,10],[11,6,11,7],[11,3,11,5],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[13,3,13,5],[17,3,17,5],[16,3,16,5],[15,3,15,5],[14,3,14,5],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,3,28,5],[28,6,28,7],[121,6,121,9],[121,2,121,3],[122,2,122,3],[95,2,95,3],[96,2,96,3],[97,2,97,3],[77,3,77,5],[77,8,77,9],[78,3,78,5],[78,8,78,9],[79,3,79,5],[79,8,79,9],[80,3,80,5],[80,8,80,9],[86,3,86,5],[86,8,86,9],[81,3,81,5],[81,8,81,9],[139,6,139,9],[137,6,137,9],[138,6,138,9],[139,2,139,3],[136,6,136,9],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[57,7,57,9],[87,8,87,9],[91,1,91,10],[112,2,112,3],[113,2,113,3],[110,2,110,3],[111,2,111,3],[102,2,102,3],[135,6,135,9],[137,2,137,3],[138,2,138,3],[134,6,134,9],[127,6,127,9],[132,6,132,9],[129,6,129,9],[162,2,162,8],[142,6,142,9],[144,1,144,10],[146,1,146,10],[148,2,148,8],[152,2,152,8],[153,2,153,8],[150,2,150,8],[151,2,151,8],[149,2,149,8],[154,2,154,8],[155,2,155,8],[156,2,156,8],[157,2,157,8],[158,2,158,8],[159,2,159,8],[160,2,160,8],[161,2,161,8],[140,6,140,9],[141,6,141,9],[187,2,187,11],[181,2,181,8],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[57,2,57,4],[58,2,58,4],[129,2,129,3],[163,2,163,8],[168,2,168,8],[164,2,164,8],[165,2,165,8],[166,2,166,8],[167,2,167,8],[130,2,130,3],[131,2,131,3],[140,2,140,3],[132,2,132,3],[141,2,141,3],[135,2,135,3],[136,2,136,3]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In-house consultants","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person -hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description\n  ",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period ","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H16","v":0}]
[]
[null,"Statement by the beneficiary\nI certify that: \n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred.\n\n"]
[]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J16","v":0}]
[null,null,null,"Date:"]
[]
[null,null,null,"Name of the Legal Representative or his/her Authorised Representative  \n"]
[]
[null,null,null,"Signature of the Legal Representative or his/her Authorised Representative  "]

{"sheet":"B14 or Affiliated","index":15,"n_rows":181,"n_cols":25,"rows_kept":181,"cut":false,"hidden":false,"merged":[[173,1,173,9],[104,2,104,3],[105,2,105,3],[106,2,106,3],[156,2,156,8],[152,2,152,8],[136,6,136,9],[137,6,137,9],[137,2,137,3],[138,2,138,3],[139,2,139,3],[155,2,155,8],[121,6,121,9],[153,2,153,8],[154,2,154,8],[136,2,136,3],[134,6,134,9],[135,6,135,9],[140,2,140,3],[148,2,148,8],[149,2,149,8],[150,2,150,8],[151,2,151,8],[131,2,131,3],[132,2,132,3],[95,2,95,3],[96,2,96,3],[86,3,86,5],[86,8,86,9],[87,8,87,9],[91,1,91,10],[93,2,93,3],[94,2,94,3],[103,2,103,3],[123,2,123,3],[122,6,122,9],[123,6,123,9],[124,6,124,9],[125,6,125,9],[127,2,127,3],[107,2,107,3],[108,2,108,3],[126,2,126,3],[112,2,112,3],[113,2,113,3],[121,2,121,3],[84,8,84,9],[83,3,83,5],[83,8,83,9],[77,8,77,9],[78,3,78,5],[78,8,78,9],[81,3,81,5],[81,8,81,9],[79,3,79,5],[79,8,79,9],[80,3,80,5],[80,8,80,9],[77,3,77,5],[82,8,82,9],[84,3,84,5],[58,7,58,9],[59,7,59,9],[60,7,60,9],[64,1,64,10],[58,2,58,4],[59,2,59,4],[74,8,74,9],[75,3,75,5],[75,8,75,9],[71,8,71,9],[72,3,72,5],[72,8,72,9],[73,3,73,5],[73,8,73,9],[56,7,56,9],[55,2,55,4],[56,2,56,4],[57,7,57,9],[57,2,57,4],[54,7,54,9],[53,2,53,4],[54,2,54,4],[55,7,55,9],[52,7,52,9],[51,2,51,4],[52,2,52,4],[53,7,53,9],[50,7,50,9],[49,2,49,4],[50,2,50,4],[51,7,51,9],[47,7,47,9],[48,7,48,9],[48,2,48,4],[49,7,49,9],[47,2,47,4],[40,7,40,9],[43,7,43,9],[44,7,44,9],[41,7,41,9],[42,7,42,9],[26,6,26,7],[27,6,27,7],[45,2,45,4],[46,2,46,4],[45,7,45,9],[46,7,46,9],[28,3,28,5],[31,6,31,7],[32,3,32,5],[32,6,32,7],[29,3,29,5],[27,3,27,5],[24,3,24,5],[26,3,26,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[37,1,37,10],[39,7,39,9],[28,6,28,7],[25,3,25,5],[23,3,23,5],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[29,6,29,7],[30,3,30,5],[30,6,30,7],[33,6,33,7],[31,3,31,5],[9,1,9,10],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[11,3,11,5],[13,3,13,5],[17,6,17,7],[18,6,18,7],[14,3,14,5],[16,3,16,5],[15,6,15,7],[16,6,16,7],[18,3,18,5],[17,3,17,5],[15,3,15,5],[138,6,138,9],[114,2,114,3],[119,1,119,10],[85,8,85,9],[66,3,66,5],[66,8,66,9],[68,3,68,5],[68,8,68,9],[69,3,69,5],[69,8,69,9],[70,3,70,5],[102,2,102,3],[97,2,97,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[71,3,71,5],[74,3,74,5],[82,3,82,5],[67,8,67,9],[70,8,70,9],[67,3,67,5],[76,3,76,5],[76,8,76,9],[133,2,133,3],[129,2,129,3],[130,2,130,3],[166,2,166,8],[167,2,167,8],[165,2,165,8],[101,2,101,3],[139,6,139,9],[109,2,109,3],[110,2,110,3],[129,6,129,9],[130,6,130,9],[135,2,135,3],[160,2,160,8],[128,2,128,3],[141,2,141,3],[141,6,141,9],[142,6,142,9],[144,1,144,10],[146,1,146,10],[132,6,132,9],[140,6,140,9],[133,6,133,9],[134,2,134,3],[187,2,187,11],[181,2,181,8],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[85,3,85,5],[43,2,43,4],[44,2,44,4],[168,2,168,8],[161,2,161,8],[162,2,162,8],[163,2,163,8],[164,2,164,8],[158,2,158,8],[159,2,159,8],[111,2,111,3],[124,2,124,3],[125,2,125,3],[127,6,127,9],[128,6,128,9],[126,6,126,9],[122,2,122,3],[157,2,157,8]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In-house consultants ","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person -hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest  cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description ",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period ","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H17","v":0}]
[]
[null,"Statement by the beneficiary\nI certify that: \n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred.\n"]
[]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J17","v":0}]
[null,null,null,"Date:"]
[]
[null,null,null,"Name of the Legal Representative or his/her Authorised Representative  \n"]
[]
[null,null,null,"Signature of the Legal Representative or his/her Authorised Representative  "]

{"sheet":"B15 or Affiliated","index":16,"n_rows":188,"n_cols":25,"rows_kept":188,"cut":false,"hidden":false,"merged":[[128,6,128,9],[127,2,127,3],[128,2,128,3],[129,2,129,3],[130,2,130,3],[131,2,131,3],[136,6,136,9],[133,6,133,9],[134,6,134,9],[135,6,135,9],[19,3,19,5],[22,3,22,5],[45,7,45,9],[46,7,46,9],[45,2,45,4],[46,2,46,4],[47,7,47,9],[14,3,14,5],[122,6,122,9],[15,3,15,5],[16,3,16,5],[20,3,20,5],[21,3,21,5],[41,7,41,9],[42,7,42,9],[43,7,43,9],[44,7,44,9],[17,3,17,5],[27,3,27,5],[24,3,24,5],[25,3,25,5],[23,3,23,5],[26,3,26,5],[18,3,18,5],[48,7,48,9],[47,2,47,4],[48,2,48,4],[49,7,49,9],[50,7,50,9],[49,2,49,4],[50,2,50,4],[51,7,51,9],[52,7,52,9],[67,3,67,5],[67,8,67,9],[68,3,68,5],[68,8,68,9],[58,7,58,9],[59,2,59,4],[66,3,66,5],[66,8,66,9],[59,7,59,9],[60,7,60,9],[64,1,64,10],[85,8,85,9],[86,3,86,5],[86,8,86,9],[81,3,81,5],[81,8,81,9],[82,3,82,5],[82,8,82,9],[95,2,95,3],[87,8,87,9],[91,1,91,10],[99,2,99,3],[100,2,100,3],[101,2,101,3],[121,6,121,9],[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[114,2,114,3],[119,1,119,10],[121,2,121,3],[112,2,112,3],[113,2,113,3],[110,2,110,3],[111,2,111,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[26,6,26,7],[27,6,27,7],[28,3,28,5],[28,6,28,7],[96,2,96,3],[97,2,97,3],[93,2,93,3],[94,2,94,3],[98,2,98,3],[85,3,85,5],[74,3,74,5],[75,3,75,5],[76,3,76,5],[77,3,77,5],[78,3,78,5],[69,3,69,5],[70,3,70,5],[71,3,71,5],[72,3,72,5],[73,3,73,5],[53,7,53,9],[54,7,54,9],[55,7,55,9],[56,7,56,9],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[9,1,9,10],[11,6,11,7],[11,3,11,5],[12,6,12,7],[13,6,13,7],[13,3,13,5],[14,6,14,7],[15,6,15,7],[16,6,16,7],[29,3,29,5],[29,6,29,7],[30,3,30,5],[30,6,30,7],[31,3,31,5],[31,6,31,7],[39,7,39,9],[40,7,40,9],[39,2,39,4],[32,3,32,5],[32,6,32,7],[33,6,33,7],[37,1,37,10],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[57,7,57,9],[84,3,84,5],[84,8,84,9],[83,3,83,5],[83,8,83,9],[79,3,79,5],[79,8,79,9],[80,3,80,5],[80,8,80,9],[56,2,56,4],[74,8,74,9],[75,8,75,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[69,8,69,9],[70,8,70,9],[71,8,71,9],[72,8,72,9],[73,8,73,9],[157,2,157,8],[158,2,158,8],[122,2,122,3],[123,2,123,3],[124,2,124,3],[125,2,125,3],[126,2,126,3],[139,6,139,9],[137,6,137,9],[138,6,138,9],[142,6,142,9],[132,2,132,3],[133,2,133,3],[134,2,134,3],[135,2,135,3],[123,6,123,9],[124,6,124,9],[125,6,125,9],[149,2,149,8],[126,6,126,9],[127,6,127,9],[132,6,132,9],[129,6,129,9],[130,6,130,9],[138,2,138,3],[139,2,139,3],[152,2,152,8],[153,2,153,8],[150,2,150,8],[151,2,151,8],[154,2,154,8],[155,2,155,8],[156,2,156,8],[140,6,140,9],[141,6,141,9],[144,1,144,10],[146,1,146,10],[148,2,148,8],[187,2,187,11],[181,2,181,8],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[57,2,57,4],[58,2,58,4],[55,2,55,4],[173,1,173,9],[159,2,159,8],[136,2,136,3],[160,2,160,8],[161,2,161,8],[162,2,162,8],[163,2,163,8],[168,2,168,8],[164,2,164,8],[165,2,165,8],[166,2,166,8],[167,2,167,8],[140,2,140,3],[141,2,141,3],[137,2,137,3]]}
[]
[null,null,"Reporiting period N°:"]
[null,null,"For the period from",null,null,"to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Name of the Beneficiary/Affiliated entity:"]
[null,null,"My organisation can not claim the VAT back :"]
[]
[]
[null,null,null,null,null,"STAFF COSTS  (1)"]
[]
[null,"Copies of timesheets and justification for labour rate and overhead rate calculations for the three highest cost items must be attached to the Financial Statement. Copies of other timesheets and justification for labour rate and overhead rate calculations may be requested by the EASME at anytime.\nThe cost of staff assigned to the action, comprising actual salaries plus social security charges and other statutory costs included in the remuneration, provided that this does not exceed the average rates corresponding to the beneficiary's usual policy on remuneration. EASME will not accept any specific bonuses paid out only for the participation in EU projects."]
[]
[null,"Line N°","Staff/In-house consultants","Name",null,null,"Category name (e.g. senior expert, engineer, etc.)",null,"Number\nof person -hours","Hourly \nrate","Staff costs\namount"]
[null,null,null,null,null,null,null,null,"A","B","AxB "]
[null,1,null,null,null,null,null,null,null,null,{"$f":"J14*I14","v":0}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"J15*I15","v":0}]
[null,3,null,null,null,null,null,null,null,null,{"$f":"J16*I16","v":0}]
[null,4,null,null,null,null,null,null,null,null,{"$f":"J17*I17","v":0}]
[null,5,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I33)","v":0},null,{"$f":"SUM(K14:K33)","v":0}]
[]
[null,null,null,null,null,"SUBCONTRACTING  (2)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime.\nIf the beneficiaries have to conclude contracts in order to carry out the action and they constitute costs of the action under an item of eligible direct costs in the estimated budget, they shall seek competitive offers from potential contractors and award the contract to the bid offering best value for money; in doing so, they shall observe the principle of transparency and equal treatment of potential contractors and shall take care to avoid any conflict of interests."]
[]
[null,"Line N°","Name of Subcontractor",null,null,"Date of the invoice","Invoice number","Description of the work undertaken",null,null,"Amount"]
[null,1]
[null,{"$f":"B41+1","v":2}]
[null,{"$f":"B42+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(K41:K60)","v":0}]
[]
[null,null,null,null,null,"TRAVEL AND SUBSISTENCE  (3)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of other invoices may be requested by the EASME at anytime. \nTravel and subsistence allowances for staff taking part in the action, provided that they are in line with the beneficiary's usual practices on travel costs or do not exceed the scales approved annually by the Commission."]
[]
[null,"Line N°","Name","Destination (city, country)",null,null,"Date\n(dd/mm/yy)","Duration\n(days)","Purpose",null,"Amount"]
[null,1]
[null,{"$f":"B68+1","v":2}]
[null,{"$f":"B69+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(K68:K87)","v":0}]
[]
[null,null,null,null,null,"EQUIPMENT AND INFRASTRUCTURE (4)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASMEat anytime.\nThe purchase cost of equipment (new or second-hand), provided that it is depreciated in accordance with the tax and accounting rules applicable to the beneficiary and generally accepted for items of the same kind. Only the portion of the equipment's depreciation corresponding to the correct reporting period and the rate of actual use for the purposes of the action may be taken into account by the EASME, except where the nature and/or the context of its use justifies different treatment by the EASME."]
[]
[null,"Line N°","Description  ",null,"Date of the invoice AND invoice number","Quantity","Unit cost","Period in months used for the project during the correct reporting period ","Depreciation in months","% Allocation\nto project","Amount"]
[null,null,null,null,null,"A","B","C","D","E","AxBx(C/D)xE"]
[null,1,null,null,null,null,null,null,null,null,{"$f":"F96*G96*(H96/I96)*J96","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,{"$f":"F97*G97*(H97/I97)*J97","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUMIF(I96:I115,\">0\",K96:K115)","v":0}]
[]
[null,null,null,null,null,"OTHER SPECIFIC COSTS (5)"]
[]
[null,"Copies of invoices for the three highest cost items must be attached to the Financial Statement. Copies of the other invoices may be requested by the EASME at anytime."]
[]
[null,"Line N°","Name of supplier",null,"Date of the invoice","Invoice number","Description",null,null,null,"Amount"]
[null,1]
[null,{"$f":"B123+1","v":2}]
[null,{"$f":"B124+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(K123:K142)","v":0}]
[]
[null,"REVENUES OTHER THAN EMFF PROGRAMME AND OWN FUNDING (6)"]
[]
[null,"To be completed only at the Final Statement. Revenues from the action (3rd parties, sales or other contributions), excluding financial contribution of the EMFF programme and own funding."]
[]
[null,"Line N°","Sources of revenue (3rd parties, sales or other contributions)",null,null,null,null,null,null,"Date of funding\n(dd/mm/yy)","Amount"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(K150:K169)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Total direct eligible costs",{"$f":"+'Overview of the costs incurred'!H18","v":0}]
[]
[null,"Statement by the beneficiary\nI certify that:\n - the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n - the costs were incurred and fall within the definition of eligible costs,\n - where necessary, authorisations have been obtained from the EASME, and\n - all the documents supporting the allowable costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors and reflect the costs actually incurred.\n\n"]
[]
[null,null,null,null,null,null,null,null,null,"Total eligible costs",{"$f":"+'Overview of the costs incurred'!J18","v":0}]
[null,null,null,"Date:"]
[]
[null,null,null,"Name of the Legal Representative or his/her Authorised Representative  \n"]
[]
[null,null,null,"Signature of the Legal Representative or his/her Authorised Representative  "]
[]
[]
[]
[]
[]
[]
[null,null,"\n\n - are available for the purposes of audit by the EASME and its authorised\n"]

{"sheet":"Hourly Rate Calculation ","index":17,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,1,2,3],[0,0,0,8]]}
["HOURLY RATE CALCULATION TEMPLATE\n(This is for information purpose only, and it is not required to submit this worksheet with your financial statement)"]
[]
[null,"  ANNUAL WORKED HOURS "]
[null,"(1) Calendar days per year minus weekends",null,null,261]
[null,"(2) Annual holidays (in n° of days)"]
[null,"(3) Statutory holidays (in nº of days)"]
[null,"(4) Others (i.e. illness etc.) (in n° of days) PLEASE SPECIFY"]
[null,"(5) Productive days per year: (1) - (2) - (3) - (4)",null,null,{"$f":"E4-E5-E6-E7","v":261}]
[null,"(6) Working hours per day"]
[null,"(7) Annual working hours: (1) x (6)",null,null,{"$f":"E4*E9","v":0}]
[null,"(8) Productive hours per year: (5) x (6)",null,null,{"$f":"ROUND(E8*E9,0)","v":0},"(A) "]
[null,"(9) Productive hours per month",null,null,{"$f":"E11/12","v":0},"(A)/ 12",null,null,null,null,null,null,null,null,null,null,null,"Staff"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In-house"]
[]
[]
["Staff / in-house consultant","Staff Name","Staff Category"," Salary cost per year (Staff) - Hourly rate as per contract (in-house consultant)"," Social charges per year (Staff)","%","Other Costs per year (Staff)"," Total annual cost per employee","Hourly Labour rate \n(Total annual costs per person / A)"]
[null,null,null,null,null,{"$f":"E17/D17","v":{"$error":"#DIV/0!"}},null,{"$f":"G17+E17+D17","v":0},{"$f":"H17/$E$11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"E18/D18","v":{"$error":"#DIV/0!"}},null,{"$f":"G18+E18+D18","v":0},{"$f":"H18/$E$11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]

{"sheet":"do_not_delete_this_sheet","index":18,"n_rows":161,"n_cols":1,"rows_kept":161,"cut":false,"hidden":false,"merged":[]}
["EUR"]
["BGN"]
["CYP"]
["CZK"]
["DKK"]
["EEK"]
["HUF"]
["LVL"]
["LTL"]
["PLN"]
["RON"]
["SEK"]
["GBP"]
["AED"]
["AFN"]
["ALL"]
["AMD"]
["ANG"]
["AOA"]
["ARS"]
["AUD"]
["AWG"]
["AZN"]
["BAM"]
["BBD"]
["BDT"]
["BHD"]
["BIF"]
["BMD"]
["BND"]
["BOB"]
["BRL"]
["BSD"]
["BTN"]
["BWP"]
["BYR"]
["BZD"]
["CAD"]
["CDF"]
["CHF"]
["CLP"]
["CNY"]
["COP"]
["CRC"]
["CSD"]
["CUC"]
["CVE"]
["DJF"]
["DOP"]
["DZD"]
["EGP"]
["ERN"]
["ETB"]
["FJD"]
["FKP"]
["GEL"]
["GHS"]
["GIP"]
["GMD"]
["GNF"]
["GTQ"]
["GYD"]
["HKD"]
["HNL"]
["HRK"]
["HTG"]
["IDR"]
["ILS"]
["INR"]
["IQD"]
["IRR"]
["ISK"]
["JMD"]
["JOD"]
["JPY"]
["KES"]
["KGS"]
["KHR"]
["KMF"]
["KPW"]
["KRW"]
["KWD"]
["KYD"]
["KZT"]
["LAK"]
["LBP"]
["LKR"]
["LRD"]
["LSL"]
["LYD"]
["MAD"]
["MDL"]
["MGA"]
["MKD"]
["MMK"]
["MNT"]
["MOP"]
["MRO"]
["MUR"]
["MVR"]
["MWK"]
["MXN"]
["MYR"]
["MZN"]
["NAD"]
["NGN"]
["NIO"]
["NOK"]
["NPR"]
["NZD"]
["OMR"]
["PAB"]
["PEN"]
["PGK"]
["PHP"]
["PKR"]
["PYG"]
["QAR"]
["RSD"]
["RUB"]
["RWF"]
["SAR"]
["SBD"]
["SCR"]
["SDG"]
["SGD"]
["SHP"]
["SLL"]
["SOS"]
["SRD"]
["STD"]
["SVC"]
["SYP"]
["SZL"]
["THB"]
["TJS"]
["TMT"]
["TND"]
["TOP"]
["TRY"]
["TTD"]
["TWD"]
["TZS"]
["UAH"]
["UGX"]
["USD"]
["UYU"]
["UZS"]
["VEF"]
["VND"]
["VUV"]
["WST"]
["XAF"]
["XCD"]
["XOF"]
["XPF"]
["YER"]
["YUM"]
["ZAR"]
["ZMK"]
["ZWL"]