{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Beneficiaries List","Work Packages List","BE 001","Estim costs of the project","Proposal Budget","BE-WP Overview","BE-WP Person Months","Depreciation Costs","Any comments","BE XXX","Country List","EGR","Referential","Operations","UpdateParameters"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":40,"comments":5,"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":"Instructions","index":0,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,2,0,3],[1,2,1,3],[3,1,3,3],[43,1,43,2],[42,0,42,2],[41,0,41,2],[36,4,36,5],[29,3,29,5],[37,4,37,5],[30,3,30,5],[15,1,16,1],[20,1,22,1]]}
["XXXX","XXXX",{"$f":"CurrentVersion","v":"[ Version LUMP SUM II - EUBA-EUAA-2026-EAC - v1_001, of 18/12/2025 ]"},null,null,"XXXX","XXXX","XXXX","XXXX"]
[null,null,"ANNEX 1 to Part B\nDetailed Estimation of Costs for Lump Sums"]
[]
[null,"Instructions"]
[]
[null,1,"This workbook for Lump Sum calculation must be uploaded in the Submission system as a mandatory document in annex to the application.  \nPlease note that if you do not upload the fully completed Excel workbook as an annex, the application cannot be submitted (the system will not allow you to submit).\n"]
[null,2,"According to the Lump sum scheme, the lump sum for a Work Package (WP) will normally be paid only when the entire Work Package has been completed. Please take this into consideration while structuring your proposal. Work Packages should be designed in a way that enables the evaluator to clearly identify whether the action has been completed.\n"]
[null,3,"We recommend using Excel 2010 or more recent.\n"]
[null,4,"The only currency used in this worksheet is EURO.\n"]
[null,5,"THE FIRST THING YOU NEED TO DO is to set the relevant Maximum Grant Amount  (in row 34 of this sheet), and the maximum co-financing rate (in row 35, both in column E) applicable for the call. \nThis data can be found in the Call document (section 6 & 10).\n"]
[null,6,"You then have to fill in only the following sheets: ‘Beneficiaries List' – ‘Work Package list’ – ‘BE XXX’ (one sheet per Participating Organisation) – ‘Depreciation costs’ (if your budget includes the purchase of equipment).\nThe final tab \"Any comments\" must be used to provide key information required for a full evaluation of your detailed budget (see point 18 below).\n"]
[null,7,"You first need to start filling in the sheet 'Beneficiaries list' where you are asked to enter all participants in the project including any Affiliated Entities.\nTo add beneficiaries, please double-click on 'Add a Beneficiary'; to add an affiliated entity, please, double-click on 'Add an Affiliated Entity'.\nNOTE: the costs of Associated Partners cannot appear in any part of this budget.\n"]
[null,8,"Then you can fill in the sheet 'Work Packages list', where you are asked to enter all the Work Packages.\nTo add a work package, please double-click on 'Add a Work Package'.\n"]
[null,9,"Once you have completed the ‘Beneficiaries List' and ‘Work Package list’ sheets, or each time you add or remove a beneficiary or a work-package, you must double-click on one of the “Apply changes” buttons to generate the related sheets in the Excel workbook.\n\nAt this stage your spreadsheet is ready to be edited Beneficiary by Beneficiary  (BE XXX) for all the workpackages concerned.\nYou are requested to enter for each Beneficiary Spreadsheet, all the related costs of each WorkPackage.\n"]
[null,10,"You have to complete a ‘BE XXX’ sheet per Beneficiary. This sheet includes separate sections for the various costs categories for each Work Package of the project.\nComplete only the number of units and the cost per unit for each cost category. The total cost per cost category will be automatically calculated.\nIf the Beneficiary does not contribute to a specific WP or cost category, then leave it blank.\n"]
[null,11,"You have to estimate the eligible costs of your proposal using the same methodology as if these costs were declared under an actual cost-based grant agreement. Make sure the budget table is consistent with the work packages described in application form part B.\nFor additional information, please refer to the Annotated Model Grant Agreement."]
[null,null,"EU Grants AGA — Annotated Grant Agreement. "]
[null,12,"In each ‘BE XXX’ sheet, for section “A. DIRECT PERSONNEL COSTS”, you have to encode your costs using the following unit: 1 unit is 1 person-month\nYou can customize the categories of Employees that correspond to your organisation in rows    45 to 49    below.\n"]
[null,13,"In each ‘BE XXX’ sheet, for section 'C2. Equipment',  use the ‘Depreciation costs’ sheet as a tool to calculate the depreciation costs to be charged for the whole duration of the project.\nThis amount is NOT automatically transferred to the respective ‘BE XXX’ sheet. You have to add manually the depreciation costs in the dedicated section of the ‘BE XXX’ sheet. If you have several items in the ‘Depreciation costs’ sheet for one single section (same Beneficiary, same Work Package and same “Resource type”), you must add only the total of these items to the relevant cell in the ‘BE XXX’ sheet.\n"]
[null,14,"Indirect costs will be calculated automatically in each 'BE XXX' sheet.\n"]
[null,15,"The summary tables ‘BE-WP Overview’, 'Estim costs of the project’, ‘Proposal Budget’, and ‘BE-WP Person Months' will be produced automatically.\n"]
[]
[]
[null,16,"The amount calculated in the 'BE-WP Overview' sheet of this Excel workbook under the heading 'Max TOTAL EU Contribution' must be copied exactly       into the Requested Grant Amount in the “Section 3 - Budget”, of the application form Part A.\n"]
[null,17,"The ‘Estim costs of the project’, Proposal Budget' and ‘BE-WP person months' sheets are there for your information and will be used during evaluation of your application.\n"]
[null,18,"If you have any comment, you can use the ‘Any comments’ sheet.\nIf you use the category 'other' in sections ‘A.1 Staff costs’ and / or  'C.3 Other goods, works and services', you should specify the breakdown of the cost, in the 'Any comments' sheet.\n"]
[null,19,"The format of this Excel workbook is .xlsm because it uses macros.\nMake sure you do not disable them when filling in the different sections.\n\nHowever, this format cannot be uploaded to the submission system for security reasons. Only XLSX format is allowed.\nTherefore, please save a copy as an .xlsx document to upload it to the proposal submission tool.\n\nTo save this workbook as .xlsx document:\n- double-click on the button 'Create XLSX Document' in cell E37 of this Instructions sheet.\nOR\n-  in Excel, click on “File” and then “Save as”; in the “Save as” dialog box, choose “.xlsx” from the “Save as type” dropdown list.\n"]
[null,null,null,null,"XXXXXXXXXXXXXXXXXXXXXXXXXXX"]
[]
[]
[null,null,null,"FILL IN THE VALUES BELOW BEFORE STARTING:"]
[null,null,"Insert the name of your call",":"]
[null,null,"Insert the acronym of your project",":"]
[null,null,"Maximum grant amount as stipulated in the call ",":","TYPE HERE THE MAXIMUM GRANT AMOUNT"]
[null,null,"Maximum co-financing rate as stipulated in the call",":","TYPE HERE THE MAXIMUM CO-FINANCING RATE"]
[]
[null,"X\nX\nX","The document which will be created with format .XLSX\nwill be saved in the same folder\nwhere this workbook .XLSM is currently placed.",null,"Create XLSX document"]
[null,null,null,null,"Double-Click to activate"]
[]
[]
[]
["You can customize here the categories of employees that correspond to your organisation (example: Senior Staff, Junior Staff, Project manager, Trainer …).\nPlease, note that this definition is common to all Work Packages for all Beneficiaries.\n",null,null,"X\nX\nX"]
["A. DIRECT PERSONNEL COSTS"]
[null,"A1. Employees (or equivalent) person months (you can change the types based on your structure)"]
[null,null,"Type 1"]
[null,null,"Type 2"]
[null,null,"Type 3"]
[null,null,"Type 4"]
[null,null,"Other"]

{"sheet":"Beneficiaries List","index":1,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,0,3,3],[3,5,3,6]]}
["XXX","XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX","XXXXXXXXXXXXXXX","XXXX",null,{"$f":"COUNTA(A:A)","v":6},{"$f":"COUNTA(A:A)","v":6}]
[{"$f":"IF(J2=INT(J2),\"BE \"&TEXT(J2,\"000\"),\"BE \"&TEXT(INT(J2),\"000\")&\" / AE \"&TEXT((J2-INT(J2))*(10 ^ (LEN(J2)-LEN(INT(J2))-1)),\"000\"))","v":"BE 000 / AE 001"},null,null,null,null,{"$f":"IF(I2=\"D\",\"TO BE REMOVED\",\"Remove this \"&IF(I2=\"B\",\"Beneficiary\",\"Affiliated Entity\"))","v":"Remove this Affiliated Entity"},{"$f":"IF(I2=\"D\",IF(J2=INT(J2),\"UNDO DELETE this Beneficiary\",IF(OFFSET(I2,INT(-1*(J2-INT(J2))*(10^(LEN(J2)-LEN(INT(J2))-1))),0)=\"D\",\"\",\"UNDO DELETE this Affiliated Entity\")),IF(OR(OFFSET(I2,1,0)=\"T\",OFFSET(I2,1,0)=\"D\"),\"\",\"Add an Affiliated Entity\"))","v":"Add an Affiliated Entity"},"T",null,{"$f":"OFFSET(J2,-1,0)+0.01","v":0.01}]
["ALL ABOVE IS HIDDEN",null,null,null,null,null,"UNDO DELETE this Affiliated Entity"]
["List of Beneficiaries and Affiliated Entities",null,null,null,1,"Actions (double-click to activate)",null,null,null,null,null,null,{"$f":"F1","v":6}]
["BE NR/AE","BE/TP name","Acronym","Country",null,{"$f":"IF(E4=1,\"APPLY CHANGES\",\"All is coherent\")","v":"APPLY CHANGES"},"Add a Beneficiary"]
[{"$f":"IF(J6=INT(J6),\"BE \"&TEXT(J6,\"000\"),\"BE \"&TEXT(INT(J6),\"000\")&\" / AE \"&TEXT((J6-INT(J6))*(10 ^ (LEN(J6)-LEN(INT(J6))-1)),\"000\"))","v":"BE 001"},null,null,null,null,{"$f":"IF(I6=\"D\",\"TO BE REMOVED\",\"Remove this \"&IF(I6=\"B\",\"Beneficiary\",\"Affiliated Entity\"))","v":"Remove this Beneficiary"},{"$f":"IF(I6=\"D\",IF(J6=INT(J6),\"UNDO DELETE this Beneficiary\",IF(OFFSET(I6,INT(-1*(J6-INT(J6))*(10^(LEN(J6)-LEN(INT(J6))-1))),0)=\"D\",\"\",\"UNDO DELETE this Affiliated Entity\")),IF(OR(OFFSET(I6,1,0)=\"T\",OFFSET(I6,1,0)=\"D\"),\"\",\"Add an Affiliated Entity\"))","v":"Add an Affiliated Entity"},"T","B",1,1]

{"sheet":"Work Packages List","index":2,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,3,3,4],[3,0,3,1]]}
["XXX","XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",".",null,null,".",{"$f":"COUNTA(A:A)","v":6},"."]
[{"$f":"\"WP \"&TEXT(J2,\"000\")","v":"WP 000"},null,null,{"$f":"IF(I2=\"D\",\"TO BE REMOVED\",\"Remove this Work Package\")","v":"Remove this Work Package"},{"$f":"IF(I2=\"D\",\"UNDO DELETE this Work Package\",\"\")","v":""},null,null,null,"W"]
["ALL ABOVE IS HIDDEN"]
["List of Work Packages",null,null,"Actions (double-click to activate)",null,null,null,null,1,null,null,null,{"$f":"G1","v":6}]
["WP Nbr","WP Label",null,{"$f":"IF(I4=1,\"APPLY CHANGES\",\"All is coherent\")","v":"APPLY CHANGES"},"Add a Work Package"]
[{"$f":"\"WP \"&TEXT(J6,\"000\")","v":"WP 001"},null,null,{"$f":"IF(I6=\"D\",\"TO BE REMOVED\",\"Remove this Work Package\")","v":"Remove this Work Package"},{"$f":"IF(I6=\"D\",\"UNDO DELETE this Work Package\",\"\")","v":""},null,null,null,"W",1]

{"sheet":"BE 001","index":3,"n_rows":39,"n_cols":21,"rows_kept":39,"cut":false,"hidden":false,"merged":[[36,14,36,16],[9,13,38,13],[9,14,9,16],[10,15,10,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,14,20,16],[21,14,21,16],[22,15,22,16],[38,14,38,16],[26,15,26,16],[27,15,27,16],[32,14,32,16],[33,15,33,16],[34,14,34,16],[8,14,8,16],[2,16,3,16],[2,17,2,19],[2,20,3,20],[3,17,3,19],[6,14,6,16]]}
[1,{"$f":"IF(ISERROR(MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0))","v":9},{"$f":"COUNTIF(E:E,\"GT\")","v":1},{"$f":"IF(ISERROR(MATCH(\"ENDWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"ENDWP\" & TEXT(A1,\"000\"),A:A,0))","v":39},null,{"$f":"COUNTA(A:A)","v":39},null,"TBE",{"$f":"MATCH(H1,2:2,0)","v":21},{"$f":"MATCH(\"BE\",2:2,0)","v":18},{"$f":"COUNTIF(2:2,\"TP\")","v":0},null,null,1,"XX","XX","TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)XXX","X.XXX,XX","XXXXXXXXX,XX","XXXXXXXXXXX,XX","XXXXXXXXXXXXXX,XX"]
[{"$f":"INDIRECT(\"'\"& MID(OFFSET(A2,ROW(A$3)-ROW(A2),IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",0,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(A2),MATCH(INDIRECT(ADDRESS(2,COLUMN(A2)+IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",1,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(A2,ROW(A$3)-ROW(A2),IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",0,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",1,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",0,-1))),TRUE)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,99,null,null,null,{"$f":"IF(OFFSET(R2,0,1)=\"\",\"TT\",IF(INT(OFFSET(R2,0,1))=OFFSET(R2,0,1),\"BE\",\"TP\"))","v":"BE"},1,{"$f":"IF(OFFSET(T2,0,-2)=\"TT\",\"E\",\"T\")","v":"T"},"TBE"]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"&IF(OFFSET(Q3,-2,-3)=\"C\",\"DETAILED\",INDIRECT(\"'Beneficiaries List'!A\" & MATCH(OFFSET(Q3,-2,-3),'Beneficiaries List'!$J:$J,0),TRUE))","v":"BE 001"},{"$f":"\"\"&INDIRECT(\"'Beneficiaries List'!A\" & MATCH(OFFSET(R3,-1,1),'Beneficiaries List'!$K:$K,0),TRUE)","v":"BE 001"},null,null,{"$f":"IF(U2=\"TBE\",\"BE \" & TEXT(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U3,-1,-2)),2:2,0)),TRUE),\"000\"),\"PROJECT\")","v":"BE 001"}]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(OFFSET(R4,-2,1),'Beneficiaries List'!$K:$K,0),TRUE)","v":""}]
["X",null,null,null,0,1,2,3,4,5,6,7,null,null,null,null,{"$f":"\"\"&IF(OFFSET(Q5,-4,-3)=\"C\",\"CONSOLIDATION\",INDIRECT(\"'Beneficiaries List'!B\" & MATCH(OFFSET(Q5,-4,-3),'Beneficiaries List'!$J:$J,0),TRUE))","v":""},{"$f":"IF(OFFSET(R5,-3,0)=\"TT\",\"BE+TP\nTOTAL COSTS\",\"UNITS\")","v":"UNITS"},{"$f":"IF(OFFSET(S5,0,-1)=\"UNITS\",\"COST\nPER UNIT\",\"\")","v":"COST\nPER UNIT"},{"$f":"IF(OFFSET(T5,0,-2)=\"UNITS\",IF(OFFSET(T5,-3,-2)=\"BE\",\"BENEFICIARY\",\"AFFILIATED ENTITY\") & \"\nTOTAL COSTS\",\"\")","v":"BENEFICIARY\nTOTAL COSTS"},"BE+AE TOTAL COSTS"]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,-1,-2]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total WORK PACKAGES: ",null,null,{"$f":"SUMIF($E:$E,\"GT\",R:R)","v":0},null,{"$f":"SUMIF($E:$E,\"GT\",T:T)","v":0},{"$f":"IF(OFFSET(U7,ROW(U$2)-ROW(U7),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q7)+1) & \":\" & ADDRESS(2,COLUMN(U7)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U7), COLUMN($Q7)+1) & \":\" & ADDRESS(ROW(U7),COLUMN(U7)-1),TRUE)),IF(OFFSET(U7,ROW(U$2)-ROW(U7),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U7,ROW(U$2)-ROW(U7),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U7)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U7), MATCH(INT(OFFSET(U7,ROW(U$2)-ROW(U7),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U7),COLUMN(U7)-1),TRUE)),IF(OFFSET(U7,0,COLUMN($M7)-COLUMN(U7))=\"V\",OFFSET(U7,0,-2)*OFFSET(U7,0,-1),\"TOTAL\")))","v":0}]
["X"]
[{"$f":"IF(ISNUMBER(OFFSET(A9,0,13)),\"START\",IF(AND(OFFSET(A9,0,2)=0,OFFSET(A9,0,4)=\"GT\"),\"END\",\"\"))&OFFSET(A9,0,1)","v":"STARTWP001"},{"$f":"IF(ISNUMBER(OFFSET(B9,0,12)),\"WP\" & TEXT(OFFSET(B9,0,12),\"000\"),OFFSET(B9,-1,0))","v":"WP001"},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"\"\"&VLOOKUP(OFFSET(N9,1,0),'Work Packages List'!A:B,2,FALSE)","v":""}]
[{"$f":"IF(ISNUMBER(OFFSET(A10,0,12)),\"START\",IF(AND(OFFSET(A10,0,2)=0,OFFSET(A10,0,4)=\"GT\"),\"END\",\"\"))&OFFSET(A10,0,1)","v":"WP001"},{"$f":"IF(ISNUMBER(OFFSET(B10,0,11)),\"WP\" & TEXT(OFFSET(B10,0,11),\"000\"),OFFSET(B10,-1,0))","v":"WP001"},4,"WPRow.A",null,null,null,"TTA","TA",null,null,null,"T",{"$f":"\"WP \" & TEXT(OFFSET(N10,-1,0),\"000\")","v":"WP 001"},"A. DIRECT PERSONNEL COSTS",null,null,{"$f":"IF(OFFSET(R10,ROW(R$2)-ROW(R10),0)=\"TT\",\"TT\",IF(OFFSET(R10,0,COLUMN($M10)-COLUMN(R10))=\"%\",ROUND(OFFSET(R10,-2,0)*0.07,2),IF(OFFSET(R10,0,COLUMN($M10)-COLUMN(R10))=\"V\",\"x\",SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),$C10+COLUMN($E10)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),$C10+COLUMN($E10)+1),TRUE),INDIRECT(ADDRESS(ROW(R10),$C10+COLUMN($E10)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),COLUMN(R10))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),COLUMN(R10)),TRUE)))))","v":0},null,{"$f":"IF(OFFSET(T10,ROW(T$2)-ROW(T10),0)=\"TT\",\"TT\",IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"%\",ROUND((OFFSET(T10,-2,0)-OFFSET(T10,-21,0))*0.07,2),IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"V\",ROUND(OFFSET(T10,0,-2)*OFFSET(T10,0,-1),2),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),$C10+COLUMN($E10)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),$C10+COLUMN($E10)+1),TRUE),INDIRECT(ADDRESS(ROW(T10),$C10+COLUMN($E10)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),COLUMN(T10))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),COLUMN(T10)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U10,ROW(U$2)-ROW(U10),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q10)+1) & \":\" & ADDRESS(2,COLUMN(U10)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U10), COLUMN($Q10)+1) & \":\" & ADDRESS(ROW(U10),COLUMN(U10)-1),TRUE)),IF(OFFSET(U10,ROW(U$2)-ROW(U10),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U10,ROW(U$2)-ROW(U10),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U10)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U10), MATCH(INT(OFFSET(U10,ROW(U$2)-ROW(U10),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U10),COLUMN(U10)-1),TRUE)),IF(OFFSET(U10,0,COLUMN($M10)-COLUMN(U10))=\"V\",OFFSET(U10,0,-2)*OFFSET(U10,0,-1),\"TOTAL\")))","v":0}]
["WP001","WP001",6,"WPRow.B",null,null,null,null,null,"TA","T1",null,"T",null,null,"A1. Employees (or equivalent) person months",null,{"$f":"IF(OFFSET(R11,ROW(R$2)-ROW(R11),0)=\"TT\",\"TT\",IF(OFFSET(R11,0,COLUMN($M11)-COLUMN(R11))=\"%\",ROUND(OFFSET(R11,-2,0)*0.07,2),IF(OFFSET(R11,0,COLUMN($M11)-COLUMN(R11))=\"V\",\"x\",SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),$C11+COLUMN($E11)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),$C11+COLUMN($E11)+1),TRUE),INDIRECT(ADDRESS(ROW(R11),$C11+COLUMN($E11)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),COLUMN(R11))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),COLUMN(R11)),TRUE)))))","v":0},null,0,0]
["WP001","WP001",7,"WPRow.C",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE1","v":"Type 1"},null,null,0,0]
["WP001","WP001",7,"WPRow.D",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE2","v":"Type 2"},null,null,0,0]
["WP001","WP001",7,"WPRow.E",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE3","v":"Type 3"},null,null,0,0]
["WP001","WP001",7,"WPRow.F",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE4","v":"Type 4"},null,null,0,0]
["WP001","WP001",7,"WPRow.G",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_OTHER","v":"Other"},null,null,0,0]
["WP001","WP001",6,"WPRow.H",null,null,null,null,null,"TA",null,null,"V",null,null,"A.2 Natural persons under direct contract ",null,null,null,0,0]
["WP001","WP001",6,"WPRow.I",null,null,null,null,null,"TA",null,null,"V",null,null,"A.3 Seconded persons",null,null,null,0,0]
["WP001","WP001",6,"WPRow.J",null,null,null,null,null,"TA",null,null,"V",null,null,"A.4 SME Owners without salary",null,null,null,0,0]
["WP001","WP001",6,"WPRow.K",null,null,null,null,null,"TA",null,null,"V",null,null,"A.5 Volunteers ",null,null,null,0,0]
["WP001","WP001",4,"WPRow.L",null,null,null,"TTA","TB",null,null,null,"V",null,"B. Subcontracting costs (please specify details under worksheet \"Comments\")",null,null,null,null,0,0]
["WP001","WP001",4,"WPRow.M",null,null,null,"TTA","TC",null,null,null,"T",null,"C. Purchase costs",null,null,null,null,0,0]
["WP001","WP001",6,"WPRow.N",null,null,null,null,null,"TC","T3",null,"T",null,null,"C.1 Travel and subsistence per travel or  day",null,null,null,0,0]
["WP001","WP001",7,"WPRow.O",null,null,null,null,null,null,null,"T3","V",null,null,null,"Travel",null,null,0,0]
["WP001","WP001",7,"WPRow.P",null,null,null,null,null,null,null,"T3","V",null,null,null,"Accommodation",null,null,0,0]
["WP001","WP001",7,"WPRow.Q",null,null,null,null,null,null,null,"T3","V",null,null,null,"Subsistence",null,null,0,0]
["WP001","WP001",5,"WPRow.R",null,null,null,null,null,"TC",null,null,"V",null,null,"C.2 Equipment (please refer to the Depreciation Cost sheet)",null,null,null,0,0]
["WP001","WP001",6,"WPRow.S",null,null,null,null,null,"TC","T4",null,"T",null,null,"C.3 Other goods, works and services",null,null,null,0,0]
["WP001","WP001",7,"WPRow.T",null,null,null,null,null,null,null,"T4","V",null,null,null,"Consumables",null,null,0,0]
["WP001","WP001",7,"WPRow.U",null,null,null,null,null,null,null,"T4","V",null,null,null,"Services for meetings, seminars and events (rentals, translations, interpretation, ...)",null,null,0,0]
["WP001","WP001",7,"WPRow.V",null,null,null,null,null,null,null,"T4","V",null,null,null,"Services for communication/promotion/dissemination (translation, printing, graphic designer, ...)",null,null,0,0]
["WP001","WP001",7,"WPRow.0",null,null,null,null,null,null,null,"T4","V",null,null,null,"Other (please specify details under worksheet \"Comments\")",null,null,0,0]
["WP001","WP001",4,"WPRow.1",null,null,null,"TTA","TD",null,null,null,"T",null,"D. Other cost categories",null,null,null,null,0,0]
["WP001","WP001",5,"WPRow.2",null,null,null,null,null,"TD",null,null,"V",null,null,"D.1 Financial support to third parties",null,null,null,0,0]
["WP001","WP001",2,"WPRow.3",null,"GT","TTA",null,null,null,null,null,"T",null,"TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)",null,null,null,null,0,0]
["WP001","WP001",1]
["WP001","WP001",2,"WPRow.4",null,"GT",null,null,null,null,null,null,"%",null,"E. Indirect costs 7%",null,null,null,null,{"$f":"IF(OFFSET(T37,ROW(T$2)-ROW(T37),0)=\"TT\",\"TT\",IF(OFFSET(T37,0,COLUMN($M37)-COLUMN(T37))=\"%\",ROUND((OFFSET(T37,-2,0)-OFFSET(T37,-21,0))*0.07,2),IF(OFFSET(T37,0,COLUMN($M37)-COLUMN(T37))=\"V\",ROUND(OFFSET(T37,0,-2)*OFFSET(T37,0,-1),2),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),$C37+COLUMN($E37)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),$C37+COLUMN($E37)+1),TRUE),INDIRECT(ADDRESS(ROW(T37),$C37+COLUMN($E37)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),COLUMN(T37))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),COLUMN(T37)),TRUE)))))","v":0},0]
["WP001","WP001",1]
["ENDWP001","WP001",0,"WPRow.5","GT",null,null,null,null,null,null,null,"T",null,{"$f":"\"TOTAL COSTS (A+B+C+D+E) - \" & OFFSET(O39,-26,0)","v":"TOTAL COSTS (A+B+C+D+E) - "},null,null,null,null,{"$f":"IF(OFFSET(T39,ROW(T$2)-ROW(T39),0)=\"TT\",\"TT\",IF(OFFSET(T39,0,COLUMN($M39)-COLUMN(T39))=\"%\",ROUND((OFFSET(T39,-2,0)-OFFSET(T39,-21,0))*0.07,2),IF(OFFSET(T39,0,COLUMN($M39)-COLUMN(T39))=\"V\",ROUND(OFFSET(T39,0,-2)*OFFSET(T39,0,-1),2),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),$C39+COLUMN($E39)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),$C39+COLUMN($E39)+1),TRUE),INDIRECT(ADDRESS(ROW(T39),$C39+COLUMN($E39)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),COLUMN(T39))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),COLUMN(T39)),TRUE)))))","v":0},0]

{"sheet":"Estim costs of the project","index":4,"n_rows":39,"n_cols":22,"rows_kept":39,"cut":false,"hidden":false,"merged":[[36,14,36,16],[2,16,3,16],[2,17,2,19],[26,15,26,16],[27,15,27,16],[32,14,32,16],[33,15,33,16],[34,14,34,16],[2,21,3,21],[3,17,3,19],[6,14,6,16],[8,14,8,16],[9,13,38,13],[9,14,9,16],[10,15,10,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,14,20,16],[21,14,21,16],[22,15,22,16],[38,14,38,16],[2,20,3,20]]}
[1,{"$f":"IF(ISERROR(MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0))","v":9},{"$f":"COUNTIF(E:E,\"GT\")","v":1},{"$f":"IF(ISERROR(MATCH(\"ENDWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"ENDWP\" & TEXT(A1,\"000\"),A:A,0))","v":39},null,{"$f":"COUNTA(A:A)","v":39},null,"TT",{"$f":"MATCH(H1,2:2,0)","v":22},{"$f":"MATCH(\"BE\",2:2,0)","v":18},{"$f":"COUNTIF(2:2,\"TP\")","v":0},null,null,"C","XX","XX","TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)XXX","X.XXX,XX","XXXXXXXXX,XX","XXXXXXXXXXX,XX","XXXXXXXXXXXXXX,XX","XXXXXXXXXXXXXX,XX"]
[{"$f":"INDIRECT(\"'\"& MID(OFFSET(A2,ROW(A$3)-ROW(A2),IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",0,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(A2),MATCH(INDIRECT(ADDRESS(2,COLUMN(A2)+IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",1,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(A2,ROW(A$3)-ROW(A2),IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",0,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",1,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",0,-1))),TRUE)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,99,null,null,null,{"$f":"IF(OFFSET(R2,0,1)=\"\",\"TT\",IF(INT(OFFSET(R2,0,1))=OFFSET(R2,0,1),\"BE\",\"TP\"))","v":"BE"},1,{"$f":"IF(OFFSET(T2,0,-2)=\"TT\",\"E\",\"T\")","v":"T"},"TBE","TT"]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"&IF(OFFSET(Q3,-2,-3)=\"C\",\"DETAILED\",INDIRECT(\"'Beneficiaries List'!A\" & MATCH(OFFSET(Q3,-2,-3),'Beneficiaries List'!$J:$J,0),TRUE))","v":"DETAILED"},{"$f":"\"\"&INDIRECT(\"'Beneficiaries List'!A\" & MATCH(OFFSET(R3,-1,1),'Beneficiaries List'!$K:$K,0),TRUE)","v":"BE 001"},null,null,{"$f":"IF(U2=\"TBE\",\"BE \" & TEXT(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U3,-1,-2)),2:2,0)),TRUE),\"000\"),\"PROJECT\")","v":"BE 001"},{"$f":"IF(V2=\"TBE\",\"BE \" & TEXT(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(V3,-1,-2)),2:2,0)),TRUE),\"000\"),\"PROJECT\")","v":"PROJECT"}]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(OFFSET(R4,-2,1),'Beneficiaries List'!$K:$K,0),TRUE)","v":""}]
["X",null,null,null,0,1,2,3,4,5,6,7,null,null,null,null,{"$f":"\"\"&IF(OFFSET(Q5,-4,-3)=\"C\",\"CONSOLIDATION\",INDIRECT(\"'Beneficiaries List'!B\" & MATCH(OFFSET(Q5,-4,-3),'Beneficiaries List'!$J:$J,0),TRUE))","v":"CONSOLIDATION"},{"$f":"IF(OFFSET(R5,-3,0)=\"TT\",\"BE+TP\nTOTAL COSTS\",\"UNITS\")","v":"UNITS"},{"$f":"IF(OFFSET(S5,0,-1)=\"UNITS\",\"COST\nPER UNIT\",\"\")","v":"COST\nPER UNIT"},{"$f":"IF(OFFSET(T5,0,-2)=\"UNITS\",IF(OFFSET(T5,-3,-2)=\"BE\",\"BENEFICIARY\",\"AFFILIATED ENTITY\") & \"\nTOTAL COSTS\",\"\")","v":"BENEFICIARY\nTOTAL COSTS"},"BE+AE TOTAL COSTS","BE+AE TOTAL COSTS"]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,-1,-2]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total WORK PACKAGES: ",null,null,{"$f":"SUMIF($E:$E,\"GT\",R:R)","v":0},null,{"$f":"SUMIF($E:$E,\"GT\",T:T)","v":0},{"$f":"IF(OFFSET(U7,ROW(U$2)-ROW(U7),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q7)+1) & \":\" & ADDRESS(2,COLUMN(U7)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U7), COLUMN($Q7)+1) & \":\" & ADDRESS(ROW(U7),COLUMN(U7)-1),TRUE)),IF(OFFSET(U7,ROW(U$2)-ROW(U7),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U7,ROW(U$2)-ROW(U7),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U7)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U7), MATCH(INT(OFFSET(U7,ROW(U$2)-ROW(U7),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U7),COLUMN(U7)-1),TRUE)),IF(OFFSET(U7,0,COLUMN($M7)-COLUMN(U7))=\"V\",OFFSET(U7,0,-2)*OFFSET(U7,0,-1),\"TOTAL\")))","v":0},{"$f":"IF(OFFSET(V7,ROW(V$2)-ROW(V7),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q7)+1) & \":\" & ADDRESS(2,COLUMN(V7)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(V7), COLUMN($Q7)+1) & \":\" & ADDRESS(ROW(V7),COLUMN(V7)-1),TRUE)),IF(OFFSET(V7,ROW(V$2)-ROW(V7),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(V7,ROW(V$2)-ROW(V7),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(V7)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(V7), MATCH(INT(OFFSET(V7,ROW(V$2)-ROW(V7),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(V7),COLUMN(V7)-1),TRUE)),IF(OFFSET(V7,0,COLUMN($M7)-COLUMN(V7))=\"V\",OFFSET(V7,0,-2)*OFFSET(V7,0,-1),\"TOTAL\")))","v":0}]
["X"]
[{"$f":"IF(ISNUMBER(OFFSET(A9,0,13)),\"START\",IF(AND(OFFSET(A9,0,2)=0,OFFSET(A9,0,4)=\"GT\"),\"END\",\"\"))&OFFSET(A9,0,1)","v":"STARTWP001"},{"$f":"IF(ISNUMBER(OFFSET(B9,0,12)),\"WP\" & TEXT(OFFSET(B9,0,12),\"000\"),OFFSET(B9,-1,0))","v":"WP001"},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"\"\"&VLOOKUP(OFFSET(N9,1,0),'Work Packages List'!A:B,2,FALSE)","v":""}]
[{"$f":"IF(ISNUMBER(OFFSET(A10,0,12)),\"START\",IF(AND(OFFSET(A10,0,2)=0,OFFSET(A10,0,4)=\"GT\"),\"END\",\"\"))&OFFSET(A10,0,1)","v":"WP001"},{"$f":"IF(ISNUMBER(OFFSET(B10,0,11)),\"WP\" & TEXT(OFFSET(B10,0,11),\"000\"),OFFSET(B10,-1,0))","v":"WP001"},4,"WPRow.A",null,null,null,"TTA","TA",null,null,null,"T",{"$f":"\"WP \" & TEXT(OFFSET(N10,-1,0),\"000\")","v":"WP 001"},"A. DIRECT PERSONNEL COSTS",null,null,{"$f":"IF(OFFSET(R10,ROW(R$2)-ROW(R10),0)=\"TT\",\"TT\",IF(OFFSET(R10,0,COLUMN($M10)-COLUMN(R10))=\"%\",ROUND(OFFSET(R10,-2,0)*0.07,2),IF(OFFSET(R10,0,COLUMN($M10)-COLUMN(R10))=\"V\",\"x\",SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),$C10+COLUMN($E10)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),$C10+COLUMN($E10)+1),TRUE),INDIRECT(ADDRESS(ROW(R10),$C10+COLUMN($E10)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),COLUMN(R10))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),COLUMN(R10)),TRUE)))))","v":0},null,{"$f":"IF(OFFSET(T10,ROW(T$2)-ROW(T10),0)=\"TT\",\"TT\",IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"%\",ROUND((OFFSET(T10,-2,0)-OFFSET(T10,-21,0))*0.07,2),IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"V\",ROUND(OFFSET(T10,0,-2)*OFFSET(T10,0,-1),2),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),$C10+COLUMN($E10)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),$C10+COLUMN($E10)+1),TRUE),INDIRECT(ADDRESS(ROW(T10),$C10+COLUMN($E10)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),COLUMN(T10))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),COLUMN(T10)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U10,ROW(U$2)-ROW(U10),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q10)+1) & \":\" & ADDRESS(2,COLUMN(U10)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U10), COLUMN($Q10)+1) & \":\" & ADDRESS(ROW(U10),COLUMN(U10)-1),TRUE)),IF(OFFSET(U10,ROW(U$2)-ROW(U10),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U10,ROW(U$2)-ROW(U10),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U10)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U10), MATCH(INT(OFFSET(U10,ROW(U$2)-ROW(U10),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U10),COLUMN(U10)-1),TRUE)),IF(OFFSET(U10,0,COLUMN($M10)-COLUMN(U10))=\"V\",OFFSET(U10,0,-2)*OFFSET(U10,0,-1),\"TOTAL\")))","v":0},0]
["WP001","WP001",6,"WPRow.B",null,null,null,null,null,"TA","T1",null,"T",null,null,"A1. Employees (or equivalent) person months",null,{"$f":"IF(OFFSET(R11,ROW(R$2)-ROW(R11),0)=\"TT\",\"TT\",IF(OFFSET(R11,0,COLUMN($M11)-COLUMN(R11))=\"%\",ROUND(OFFSET(R11,-2,0)*0.07,2),IF(OFFSET(R11,0,COLUMN($M11)-COLUMN(R11))=\"V\",\"x\",SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),$C11+COLUMN($E11)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),$C11+COLUMN($E11)+1),TRUE),INDIRECT(ADDRESS(ROW(R11),$C11+COLUMN($E11)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),COLUMN(R11))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),COLUMN(R11)),TRUE)))))","v":0},null,0,0,0]
["WP001","WP001",7,"WPRow.C",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE1","v":"Type 1"},{"$f":"INDIRECT(\"'\"& MID(OFFSET(R12,ROW(R$3)-ROW(R12),IF(OFFSET(R12,ROW(R$2)-ROW(R12),2)=\"T\",0,IF(OFFSET(R12,ROW(R$2)-ROW(R12),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R12),MATCH(INDIRECT(ADDRESS(2,COLUMN(R12)+IF(OFFSET(R12,ROW(R$2)-ROW(R12),2)=\"T\",1,IF(OFFSET(R12,ROW(R$2)-ROW(R12),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R12,ROW(R$3)-ROW(R12),IF(OFFSET(R12,ROW(R$2)-ROW(R12),2)=\"T\",0,IF(OFFSET(R12,ROW(R$2)-ROW(R12),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R12,ROW(R$2)-ROW(R12),2)=\"T\",1,IF(OFFSET(R12,ROW(R$2)-ROW(R12),1)=\"T\",0,-1))),TRUE)","v":0},0,0,0,0]
["WP001","WP001",7,"WPRow.D",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE2","v":"Type 2"},0,0,0,0,0]
["WP001","WP001",7,"WPRow.E",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE3","v":"Type 3"},0,0,0,0,0]
["WP001","WP001",7,"WPRow.F",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE4","v":"Type 4"},0,0,0,0,0]
["WP001","WP001",7,"WPRow.G",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_OTHER","v":"Other"},0,0,0,0,0]
["WP001","WP001",6,"WPRow.H",null,null,null,null,null,"TA",null,null,"V",null,null,"A.2 Natural persons under direct contract ",null,0,0,0,0,0]
["WP001","WP001",6,"WPRow.I",null,null,null,null,null,"TA",null,null,"V",null,null,"A.3 Seconded persons",null,0,0,0,0,0]
["WP001","WP001",6,"WPRow.J",null,null,null,null,null,"TA",null,null,"V",null,null,"A.4 SME Owners without salary",null,0,0,0,0,0]
["WP001","WP001",6,"WPRow.K",null,null,null,null,null,"TA",null,null,"V",null,null,"A.5 Volunteers ",null,0,0,0,0,0]
["WP001","WP001",4,"WPRow.L",null,null,null,"TTA","TB",null,null,null,"V",null,"B. Subcontracting costs (please specify details under worksheet \"Comments\")",null,null,0,0,0,0,0]
["WP001","WP001",4,"WPRow.M",null,null,null,"TTA","TC",null,null,null,"T",null,"C. Purchase costs",null,null,null,null,0,0,0]
["WP001","WP001",6,"WPRow.N",null,null,null,null,null,"TC","T3",null,"T",null,null,"C.1 Travel and subsistence per travel or  day",null,null,null,0,0,0]
["WP001","WP001",7,"WPRow.O",null,null,null,null,null,null,null,"T3","V",null,null,null,"Travel",{"$f":"INDIRECT(\"'\"& MID(OFFSET(R24,ROW(R$3)-ROW(R24),IF(OFFSET(R24,ROW(R$2)-ROW(R24),2)=\"T\",0,IF(OFFSET(R24,ROW(R$2)-ROW(R24),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R24),MATCH(INDIRECT(ADDRESS(2,COLUMN(R24)+IF(OFFSET(R24,ROW(R$2)-ROW(R24),2)=\"T\",1,IF(OFFSET(R24,ROW(R$2)-ROW(R24),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R24,ROW(R$3)-ROW(R24),IF(OFFSET(R24,ROW(R$2)-ROW(R24),2)=\"T\",0,IF(OFFSET(R24,ROW(R$2)-ROW(R24),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R24,ROW(R$2)-ROW(R24),2)=\"T\",1,IF(OFFSET(R24,ROW(R$2)-ROW(R24),1)=\"T\",0,-1))),TRUE)","v":0},0,0,0,0]
["WP001","WP001",7,"WPRow.P",null,null,null,null,null,null,null,"T3","V",null,null,null,"Accommodation",0,0,0,0,0]
["WP001","WP001",7,"WPRow.Q",null,null,null,null,null,null,null,"T3","V",null,null,null,"Subsistence",0,0,0,0,0]
["WP001","WP001",5,"WPRow.R",null,null,null,null,null,"TC",null,null,"V",null,null,"C.2 Equipment (please refer to the Depreciation Cost sheet)",null,0,0,0,0,0]
["WP001","WP001",6,"WPRow.S",null,null,null,null,null,"TC","T4",null,"T",null,null,"C.3 Other goods, works and services",null,null,null,0,0,0]
["WP001","WP001",7,"WPRow.T",null,null,null,null,null,null,null,"T4","V",null,null,null,"Consumables",{"$f":"INDIRECT(\"'\"& MID(OFFSET(R29,ROW(R$3)-ROW(R29),IF(OFFSET(R29,ROW(R$2)-ROW(R29),2)=\"T\",0,IF(OFFSET(R29,ROW(R$2)-ROW(R29),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R29),MATCH(INDIRECT(ADDRESS(2,COLUMN(R29)+IF(OFFSET(R29,ROW(R$2)-ROW(R29),2)=\"T\",1,IF(OFFSET(R29,ROW(R$2)-ROW(R29),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R29,ROW(R$3)-ROW(R29),IF(OFFSET(R29,ROW(R$2)-ROW(R29),2)=\"T\",0,IF(OFFSET(R29,ROW(R$2)-ROW(R29),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R29,ROW(R$2)-ROW(R29),2)=\"T\",1,IF(OFFSET(R29,ROW(R$2)-ROW(R29),1)=\"T\",0,-1))),TRUE)","v":0},0,0,0,0]
["WP001","WP001",7,"WPRow.U",null,null,null,null,null,null,null,"T4","V",null,null,null,"Services for meetings, seminars and events (rentals, translations, interpretation, ...)",0,0,0,0,0]
["WP001","WP001",7,"WPRow.V",null,null,null,null,null,null,null,"T4","V",null,null,null,"Services for communication/promotion/dissemination (translation, printing, graphic designer, ...)",0,0,0,0,0]
["WP001","WP001",7,"WPRow.0",null,null,null,null,null,null,null,"T4","V",null,null,null,"Other (please specify details under worksheet \"Comments\")",0,0,0,0,0]
["WP001","WP001",4,"WPRow.1",null,null,null,"TTA","TD",null,null,null,"T",null,"D. Other cost categories",null,null,null,null,0,0,0]
["WP001","WP001",5,"WPRow.2",null,null,null,null,null,"TD",null,null,"V",null,null,"D.1 Financial support to third parties",null,{"$f":"INDIRECT(\"'\"& MID(OFFSET(R34,ROW(R$3)-ROW(R34),IF(OFFSET(R34,ROW(R$2)-ROW(R34),2)=\"T\",0,IF(OFFSET(R34,ROW(R$2)-ROW(R34),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R34),MATCH(INDIRECT(ADDRESS(2,COLUMN(R34)+IF(OFFSET(R34,ROW(R$2)-ROW(R34),2)=\"T\",1,IF(OFFSET(R34,ROW(R$2)-ROW(R34),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R34,ROW(R$3)-ROW(R34),IF(OFFSET(R34,ROW(R$2)-ROW(R34),2)=\"T\",0,IF(OFFSET(R34,ROW(R$2)-ROW(R34),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R34,ROW(R$2)-ROW(R34),2)=\"T\",1,IF(OFFSET(R34,ROW(R$2)-ROW(R34),1)=\"T\",0,-1))),TRUE)","v":0},{"$f":"INDIRECT(\"'\"& MID(OFFSET(S34,ROW(S$3)-ROW(S34),IF(OFFSET(S34,ROW(S$2)-ROW(S34),2)=\"T\",0,IF(OFFSET(S34,ROW(S$2)-ROW(S34),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(S34),MATCH(INDIRECT(ADDRESS(2,COLUMN(S34)+IF(OFFSET(S34,ROW(S$2)-ROW(S34),2)=\"T\",1,IF(OFFSET(S34,ROW(S$2)-ROW(S34),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(S34,ROW(S$3)-ROW(S34),IF(OFFSET(S34,ROW(S$2)-ROW(S34),2)=\"T\",0,IF(OFFSET(S34,ROW(S$2)-ROW(S34),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(S34,ROW(S$2)-ROW(S34),2)=\"T\",1,IF(OFFSET(S34,ROW(S$2)-ROW(S34),1)=\"T\",0,-1))),TRUE)","v":0},0,0,0]
["WP001","WP001",2,"WPRow.3",null,"GT","TTA",null,null,null,null,null,"T",null,"TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)",null,null,null,null,0,0,0]
["WP001","WP001",1]
["WP001","WP001",2,"WPRow.4",null,"GT",null,null,null,null,null,null,"%",null,"E. Indirect costs 7%",null,null,null,null,{"$f":"IF(OFFSET(T37,ROW(T$2)-ROW(T37),0)=\"TT\",\"TT\",IF(OFFSET(T37,0,COLUMN($M37)-COLUMN(T37))=\"%\",ROUND((OFFSET(T37,-2,0)-OFFSET(T37,-21,0))*0.07,2),IF(OFFSET(T37,0,COLUMN($M37)-COLUMN(T37))=\"V\",ROUND(OFFSET(T37,0,-2)*OFFSET(T37,0,-1),2),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),$C37+COLUMN($E37)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),$C37+COLUMN($E37)+1),TRUE),INDIRECT(ADDRESS(ROW(T37),$C37+COLUMN($E37)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),COLUMN(T37))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),COLUMN(T37)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U37,ROW(U$2)-ROW(U37),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q37)+1) & \":\" & ADDRESS(2,COLUMN(U37)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U37), COLUMN($Q37)+1) & \":\" & ADDRESS(ROW(U37),COLUMN(U37)-1),TRUE)),IF(OFFSET(U37,ROW(U$2)-ROW(U37),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U37,ROW(U$2)-ROW(U37),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U37)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U37), MATCH(INT(OFFSET(U37,ROW(U$2)-ROW(U37),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U37),COLUMN(U37)-1),TRUE)),IF(OFFSET(U37,0,COLUMN($M37)-COLUMN(U37))=\"V\",OFFSET(U37,0,-2)*OFFSET(U37,0,-1),\"TOTAL\")))","v":0},{"$f":"IF(OFFSET(V37,ROW(V$2)-ROW(V37),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q37)+1) & \":\" & ADDRESS(2,COLUMN(V37)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(V37), COLUMN($Q37)+1) & \":\" & ADDRESS(ROW(V37),COLUMN(V37)-1),TRUE)),IF(OFFSET(V37,ROW(V$2)-ROW(V37),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(V37,ROW(V$2)-ROW(V37),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(V37)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(V37), MATCH(INT(OFFSET(V37,ROW(V$2)-ROW(V37),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(V37),COLUMN(V37)-1),TRUE)),IF(OFFSET(V37,0,COLUMN($M37)-COLUMN(V37))=\"V\",OFFSET(V37,0,-2)*OFFSET(V37,0,-1),\"TOTAL\")))","v":0}]
["WP001","WP001",1]
["ENDWP001","WP001",0,"WPRow.5","GT",null,null,null,null,null,null,null,"T",null,{"$f":"\"TOTAL COSTS (A+B+C+D+E) - \" & OFFSET(O39,-26,0)","v":"TOTAL COSTS (A+B+C+D+E) - "},null,null,null,null,{"$f":"IF(OFFSET(T39,ROW(T$2)-ROW(T39),0)=\"TT\",\"TT\",IF(OFFSET(T39,0,COLUMN($M39)-COLUMN(T39))=\"%\",ROUND((OFFSET(T39,-2,0)-OFFSET(T39,-21,0))*0.07,2),IF(OFFSET(T39,0,COLUMN($M39)-COLUMN(T39))=\"V\",ROUND(OFFSET(T39,0,-2)*OFFSET(T39,0,-1),2),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),$C39+COLUMN($E39)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),$C39+COLUMN($E39)+1),TRUE),INDIRECT(ADDRESS(ROW(T39),$C39+COLUMN($E39)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),COLUMN(T39))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),COLUMN(T39)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U39,ROW(U$2)-ROW(U39),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q39)+1) & \":\" & ADDRESS(2,COLUMN(U39)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U39), COLUMN($Q39)+1) & \":\" & ADDRESS(ROW(U39),COLUMN(U39)-1),TRUE)),IF(OFFSET(U39,ROW(U$2)-ROW(U39),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U39,ROW(U$2)-ROW(U39),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U39)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U39), MATCH(INT(OFFSET(U39,ROW(U$2)-ROW(U39),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U39),COLUMN(U39)-1),TRUE)),IF(OFFSET(U39,0,COLUMN($M39)-COLUMN(U39))=\"V\",OFFSET(U39,0,-2)*OFFSET(U39,0,-1),\"TOTAL\")))","v":0},{"$f":"IF(OFFSET(V39,ROW(V$2)-ROW(V39),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q39)+1) & \":\" & ADDRESS(2,COLUMN(V39)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(V39), COLUMN($Q39)+1) & \":\" & ADDRESS(ROW(V39),COLUMN(V39)-1),TRUE)),IF(OFFSET(V39,ROW(V$2)-ROW(V39),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(V39,ROW(V$2)-ROW(V39),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(V39)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(V39), MATCH(INT(OFFSET(V39,ROW(V$2)-ROW(V39),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(V39),COLUMN(V39)-1),TRUE)),IF(OFFSET(V39,0,COLUMN($M39)-COLUMN(V39))=\"V\",OFFSET(V39,0,-2)*OFFSET(V39,0,-1),\"TOTAL\")))","v":0}]

{"sheet":"Proposal Budget","index":5,"n_rows":10,"n_cols":43,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,6,6,6],[4,7,5,7],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,39,6,39],[4,24,5,24],[4,33,6,33],[4,34,5,34],[4,35,6,35],[4,37,6,37],[5,25,5,32],[4,16,5,16],[4,17,6,17],[4,18,6,18],[4,19,5,19],[4,23,5,23]]}
[null,null,"XXXXXX",null,"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX","XXXXXXXXXXXXXXX",9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,9999999999.9899998,"XX",9999999999.9899998,"XX",9999999999.9899998,"XX","XXXXXXXXXXXXXXXXXX","CHECK"]
[null,{"$f":"MATCH(\"HE\",A:A,0)","v":8},{"$f":"MATCH(\"TT\",A:A,0)","v":10},{"$f":"COLUMN(AT3)","v":46},null,null,"WPRow.A","WPRow.B","WPRow.C","WPRow.D","WPRow.E","WPRow.F","WPRow.G","WPRow.H","WPRow.I","WPRow.J","WPRow.K","WPRow.L","WPRow.M","WPRow.N","WPRow.O","WPRow.P","WPRow.Q","WPRow.R","WPRow.S","WPRow.T","WPRow.U","WPRow.V","WPRow.W","WPRow.X","WPRow.Y","WPRow.Z","WPRow.0","WPRow.1","WPRow.2","WPRow.3",null,"WPRow.4",null,"WPRow.5",null,{"$f":"IF((OFFSET(AP2,C2-2,-2)*COFINPERCENT)>IF(MAXSUB=0,OFFSET(AP2,C2-2,-2),MAXSUB),IF(MAXSUB=0,OFFSET(AP2,C2-2,-2),MAXSUB)/OFFSET(AP2,C2-2,-2),COFINPERCENT)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(A3=\"TT\",3,IF(B2=1,2,1))","v":1},{"$f":"MATCH(A3,INDIRECT(\"'Estim costs of the project'!2:2\",TRUE),0)+IF(A3=\"TT\",0,1)","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(D3,0,-3)=\"TT\",\"\",\"\"&INDIRECT(\"'Beneficiaries List'!I\" & MATCH(A3,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(E3,0,-4)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A3,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(F3,0,-5)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A3,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"SUMIF(INDIRECT(\"'Estim costs of the project'!D:D\",TRUE),G$2,OFFSET(INDIRECT(\"'Estim costs of the project'!A1\",TRUE),0,$C3-1,1048500,1))","v":{"$error":"#N/A"}},{"$f":"SUMIF(INDIRECT(\"'Estim costs of the project'!D:D\",TRUE),H$2,OFFSET(INDIRECT(\"'Estim costs of the project'!A1\",TRUE),0,$C3-1,1048500,1))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"IF(AND(AN3=0,D3<>\"T\"),\"No budget defined\",IF(A3<>\"TT\",ROUND(AN3*AP$2,2),SUM(INDIRECT(CELL(\"address\",OFFSET(AP3,-1*(ROW(AP3)-B$2-1),0))&\":\"&CELL(\"address\",OFFSET(AP3,-1,0)),TRUE))))","v":{"$error":"#N/A"}}]
[]
[null,"X\nX\nX\nX\nX\nX\nX\nX\nZ",null,null,"Click here to go to the column\nMax TOTAL EU Contribution\n",null,"A.\nDIRECT PERSONNEL COSTS","A1.\nEmployees (or equivalent) person months",{"$f":"EMP_TYPE1","v":"Type 1"},{"$f":"EMP_TYPE2","v":"Type 2"},{"$f":"EMP_TYPE3","v":"Type 3"},{"$f":"EMP_TYPE4","v":"Type 4"},{"$f":"EMP_OTHER","v":"Other"},"A.2\nNatural persons under direct contract ","A.3\nSeconded persons","A.4\nSME Owners without salary","A.5\nVolunteers ","B.\nSubcontracting costs","C.\nPurchase costs\n","C.1\nTravel and subsistence per travel or  day","Travel","Accommodation","Subsistence","C.2\nEquipment \n\n(please refer to the Depreciation Cost sheet)","C.3\nOther goods, works and services","Consumables","Services for meetings, seminars and events","Services for communication/promotion/dissemination",null,null,null,null,"Other ","D.\nOther cost categories","D.1\nFinancial support to third parties","TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)",null,"E.\nIndirect costs\n7% ",null,"TOTAL COSTS (A+B+C+D+E) ",null,{"$f":"IF(OR(ISERROR(COFINPERCENT+1),ISERROR(MAXSUB+1)),\"To make the calculaton working, please, set\n- in sheet Instructions -\nthe relevant maximum grant amount and the maximum % of co-financing rate\napplicable for the call.\",\"Max TOTAL EU\nContribution\n=\n\n\"&TEXT(COFINPERCENT,\"00 %\")&\"\nof \"&TEXT(INDIRECT(\"AN\"&MATCH(\"TT\",A:A,0),TRUE),\"###.###.##0,00 €\")&IF(MAXSUB=0,\"\",\"\nor\n\"&TEXT(MAXSUB,\"###.###.###.##0,00 €\")))","v":"To make the calculaton working, please, set\n- in sheet Instructions -\nthe relevant maximum grant amount and the maximum % of co-financing rate\napplicable for the call."}]
[null,"X\nX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISERROR(COFINPERCENT+1),ISERROR(MAXSUB+1)),\"See instruction n° 5\nin sheet Instructions\",\"\")","v":"See instruction n° 5\nin sheet Instructions"}]
[null,"X\nX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max TOTAL EU\nContribution"]
["HE"]
[1,{"$f":"IF(A9=\"TT\",3,IF(B8=1,2,1))","v":1},{"$f":"MATCH(A9,INDIRECT(\"'Estim costs of the project'!2:2\",TRUE),0)+IF(A9=\"TT\",0,1)","v":20},{"$f":"IF(OFFSET(D9,0,-3)=\"TT\",\"\",\"\"&INDIRECT(\"'Beneficiaries List'!I\" & MATCH(A9,'Beneficiaries List'!J:J,0),TRUE))","v":"B"},{"$f":"IF(OFFSET(E9,0,-4)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A9,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"IF(OFFSET(F9,0,-5)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A9,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"SUMIF(INDIRECT(\"'Estim costs of the project'!D:D\",TRUE),G$2,OFFSET(INDIRECT(\"'Estim costs of the project'!A1\",TRUE),0,$C9-1,1048500,1))","v":0},{"$f":"SUMIF(INDIRECT(\"'Estim costs of the project'!D:D\",TRUE),H$2,OFFSET(INDIRECT(\"'Estim costs of the project'!A1\",TRUE),0,$C9-1,1048500,1))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,null,{"$f":"IF(AND(AN9=0,D9<>\"T\"),\"No budget defined\",IF(A9<>\"TT\",ROUND(AN9*AP$2,2),SUM(INDIRECT(CELL(\"address\",OFFSET(AP9,-1*(ROW(AP9)-B$2-1),0))&\":\"&CELL(\"address\",OFFSET(AP9,-1,0)),TRUE))))","v":"No budget defined"}]
["TT",{"$f":"IF(A10=\"TT\",3,IF(B9=1,2,1))","v":3},{"$f":"MATCH(A10,INDIRECT(\"'Estim costs of the project'!2:2\",TRUE),0)+IF(A10=\"TT\",0,1)","v":22},{"$f":"IF(OFFSET(D10,0,-3)=\"TT\",\"\",\"\"&INDIRECT(\"'Beneficiaries List'!I\" & MATCH(A10,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"IF(OFFSET(E10,0,-4)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A10,'Beneficiaries List'!J:J,0),TRUE))","v":"TOTAL"},{"$f":"IF(OFFSET(F10,0,-5)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A10,'Beneficiaries List'!J:J,0),TRUE))","v":"Consortium"},{"$f":"SUMIF(INDIRECT(\"'Estim costs of the project'!D:D\",TRUE),G$2,OFFSET(INDIRECT(\"'Estim costs of the project'!A1\",TRUE),0,$C10-1,1048500,1))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,null,{"$f":"IF(AND(AN10=0,D10<>\"T\"),\"No budget defined\",IF(A10<>\"TT\",ROUND(AN10*AP$2,2),SUM(INDIRECT(CELL(\"address\",OFFSET(AP10,-1*(ROW(AP10)-B$2-1),0))&\":\"&CELL(\"address\",OFFSET(AP10,-1,0)),TRUE))))","v":"No budget defined"}]

{"sheet":"BE-WP Overview","index":6,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IF(OFFSET(B1,-1,-1)=\"HE\",1,IF(OFFSET(B1,0,-1)=\"TT\",3,IF(OFFSET(B1,-1,0)=1,2,1)))","v":{"$error":"#REF!"}},{"$f":"IF(OFFSET(C1,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A1,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(C1,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A1,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(StatusBudget=0,\"No budget defined\",IF(OFFSET(E1,ROW(E$4)-ROW(E1),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(E1),COLUMN($D1)+1)&\":\"&ADDRESS(ROW(E1),COLUMN(E1)-1),TRUE)),IF($A1=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(E1))&\":\"&ADDRESS(ROW(E1)-1,COLUMN(E1)),TRUE)),IF(ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(E1,0,EGR!$D$3-COLUMN(E1))),TRUE),2) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A1,'Proposal Budget'!$A:$A,0)-1,COLUMN($AP1)-1),2)=0,0,ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",E1),TRUE),2) / ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(E1,0,EGR!$D$3-COLUMN(E1))),TRUE),2) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A1,'Proposal Budget'!$A:$A,0)-1,COLUMN($AP1)-1),2)))))","v":"No budget defined"}]
[null,null,"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",999999999,999999999.99000001,999999999.99000001]
[null,{"$f":"ADDRESS(E3,COLUMN(C1))","v":"$C$7"},{"$f":"MATCH(\"TT\",A:A,0)","v":8},{"$f":"MATCH(\"TT\",4:4,0)","v":6},{"$f":"MATCH(\"HE\",A:A,0)+1","v":7}]
[null,null,"O",{"$f":"INDIRECT(\"'Proposal Budget'!AN\" & MATCH(\"TT\",'Proposal Budget'!A:A,0),TRUE)","v":0},1,"TT"]
[null,null,"Your Requested EU Grant Amount :",{"$f":"MyRequetedEUContribution","v":"No budget defined"},{"$f":"IF(ISERROR(D5),\"\",\"EUR\")","v":"EUR"}]
["HE","X\nX\nX","BE NR/AE","Acronym",{"$f":"IF(OFFSET(E6,-2,0)=\"TT\",IF($C4=\"O\",\"Maximum\nGrant\nAmount\",IF($C4=\"PM\",\"Total\nfor project\",\"\")),INDIRECT(\"'Work Packages List'!A\" & MATCH(OFFSET(E6,-2,0),'Work Packages List'!$J:$J,0),TRUE) & \"\n\" & INDIRECT(\"'Work Packages List'!B\" & MATCH(OFFSET(E6,-2,0),'Work Packages List'!$J:$J,0),TRUE))","v":"WP 001\n"},{"$f":"IF(OFFSET(F6,-2,0)=\"TT\",IF($C4=\"O\",\"Maximum\nGrant\nAmount\",IF($C4=\"PM\",\"Total\nfor project\",\"\")),INDIRECT(\"'Work Packages List'!A\" & MATCH(OFFSET(F6,-2,0),'Work Packages List'!$J:$J,0),TRUE) & \"\n\" & INDIRECT(\"'Work Packages List'!B\" & MATCH(OFFSET(F6,-2,0),'Work Packages List'!$J:$J,0),TRUE))","v":"Maximum\nGrant\nAmount"}]
[1,{"$f":"IF(OFFSET(B7,-1,-1)=\"HE\",1,IF(OFFSET(B7,0,-1)=\"TT\",3,IF(OFFSET(B7,-1,0)=1,2,1)))","v":1},{"$f":"IF(OFFSET(C7,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A7,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"IF(OFFSET(C7,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A7,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"IF(StatusBudget=0,\"No budget defined\",IF(OFFSET(E7,ROW(E$4)-ROW(E7),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(E7),COLUMN($D7)+1)&\":\"&ADDRESS(ROW(E7),COLUMN(E7)-1),TRUE)),IF($A7=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(E7))&\":\"&ADDRESS(ROW(E7)-1,COLUMN(E7)),TRUE)),IF(ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(E7,0,EGR!$D$3-COLUMN(E7))),TRUE),2) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A7,'Proposal Budget'!$A:$A,0)-1,COLUMN($AP7)-1),2)=0,0,ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",E7),TRUE),2) / ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(E7,0,EGR!$D$3-COLUMN(E7))),TRUE),2) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A7,'Proposal Budget'!$A:$A,0)-1,COLUMN($AP7)-1),2)))))","v":"No budget defined"},{"$f":"IF(StatusBudget=0,\"No budget defined\",IF(OFFSET(F7,ROW(F$4)-ROW(F7),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(F7),COLUMN($D7)+1)&\":\"&ADDRESS(ROW(F7),COLUMN(F7)-1),TRUE)),IF($A7=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(F7))&\":\"&ADDRESS(ROW(F7)-1,COLUMN(F7)),TRUE)),IF(ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(F7,0,EGR!$D$3-COLUMN(F7))),TRUE),2) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A7,'Proposal Budget'!$A:$A,0)-1,COLUMN($AP7)-1),2)=0,0,ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",F7),TRUE),2) / ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(F7,0,EGR!$D$3-COLUMN(F7))),TRUE),2) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A7,'Proposal Budget'!$A:$A,0)-1,COLUMN($AP7)-1),2)))))","v":"No budget defined"}]
["TT",3,{"$f":"IF(OFFSET(C8,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A8,'Beneficiaries List'!J:J,0),TRUE))","v":"TOTAL"},{"$f":"IF(OFFSET(C8,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A8,'Beneficiaries List'!J:J,0),TRUE))","v":"Consortium"},{"$f":"IF(StatusBudget=0,\"No budget defined\",IF(OFFSET(E8,ROW(E$4)-ROW(E8),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(E8),COLUMN($D8)+1)&\":\"&ADDRESS(ROW(E8),COLUMN(E8)-1),TRUE)),IF($A8=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(E8))&\":\"&ADDRESS(ROW(E8)-1,COLUMN(E8)),TRUE)),IF(ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(E8,0,EGR!$D$3-COLUMN(E8))),TRUE),2) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A8,'Proposal Budget'!$A:$A,0)-1,COLUMN($AP8)-1),2)=0,0,ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",E8),TRUE),2) / ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(E8,0,EGR!$D$3-COLUMN(E8))),TRUE),2) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A8,'Proposal Budget'!$A:$A,0)-1,COLUMN($AP8)-1),2)))))","v":"No budget defined"},{"$f":"IF(StatusBudget=0,\"No budget defined\",IF(OFFSET(F8,ROW(F$4)-ROW(F8),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(F8),COLUMN($D8)+1)&\":\"&ADDRESS(ROW(F8),COLUMN(F8)-1),TRUE)),IF($A8=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(F8))&\":\"&ADDRESS(ROW(F8)-1,COLUMN(F8)),TRUE)),IF(ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(F8,0,EGR!$D$3-COLUMN(F8))),TRUE),2) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A8,'Proposal Budget'!$A:$A,0)-1,COLUMN($AP8)-1),2)=0,0,ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",F8),TRUE),2) / ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(F8,0,EGR!$D$3-COLUMN(F8))),TRUE),2) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A8,'Proposal Budget'!$A:$A,0)-1,COLUMN($AP8)-1),2)))))","v":"No budget defined"}]

{"sheet":"BE-WP Person Months","index":7,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[4,2,4,4]]}
[null,{"$f":"IF(OFFSET(B1,-1,-1)=\"HE\",1,IF(OFFSET(B1,0,-1)=\"TT\",3,IF(OFFSET(B1,-1,0)=1,2,1)))","v":{"$error":"#REF!"}},{"$f":"IF(OFFSET(C1,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A1,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(C1,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A1,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(E1,ROW(E$4)-ROW(E1),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(E1),COLUMN($D1)+1)&\":\"&ADDRESS(ROW(E1),COLUMN(E1)-1),TRUE)),IF($A1=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(E1))&\":\"&ADDRESS(ROW(E1)-1,COLUMN(E1)),TRUE)),INDIRECT(CELL(\"address\",OFFSET(INDIRECT(\"'BE \" & TEXT(INT($A1),\"000\") & \"'!A1\",TRUE),MATCH(\"STARTWP\" & TEXT(OFFSET(E1,ROW(E$4)-ROW(E1),0),\"000\"),INDIRECT(\"'BE \" & TEXT(INT($A1),\"000\") & \"'!A:A\",TRUE),0),MATCH($A1,INDIRECT(\"'BE \" & TEXT(INT($A1),\"000\") & \"'!2:2\",TRUE),0)-2)),TRUE)))","v":{"$error":"#N/A"}}]
[null,null,"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",999999999,999999999.99000001,999999999.99000001]
[null,{"$f":"ADDRESS(E3,COLUMN(C1))","v":"$C$7"},{"$f":"MATCH(\"TT\",A:A,0)","v":8},{"$f":"MATCH(\"TT\",4:4,0)","v":6},{"$f":"MATCH(\"HE\",A:A,0)+1","v":7}]
[null,null,"PM",null,1,"TT"]
["X\nX",null,"TOTAL PERSON/MONTHS FOR ALL BENEFICIARIES PER WP\n(INCLUDING LINKED THIRD PARTIES)"]
["HE","X\nX\nX","BE NR/AE","Acronym",{"$f":"IF(OFFSET(E6,-2,0)=\"TT\",IF($C4=\"O\",\"Maximum\nGrant\nAmount\",IF($C4=\"PM\",\"Total\nfor project\",\"\")),INDIRECT(\"'Work Packages List'!A\" & MATCH(OFFSET(E6,-2,0),'Work Packages List'!$J:$J,0),TRUE) & \"\n\" & INDIRECT(\"'Work Packages List'!B\" & MATCH(OFFSET(E6,-2,0),'Work Packages List'!$J:$J,0),TRUE))","v":"WP 001\n"},{"$f":"IF(OFFSET(F6,-2,0)=\"TT\",IF($C4=\"O\",\"Maximum\nGrant\nAmount\",IF($C4=\"PM\",\"Total\nfor project\",\"\")),INDIRECT(\"'Work Packages List'!A\" & MATCH(OFFSET(F6,-2,0),'Work Packages List'!$J:$J,0),TRUE) & \"\n\" & INDIRECT(\"'Work Packages List'!B\" & MATCH(OFFSET(F6,-2,0),'Work Packages List'!$J:$J,0),TRUE))","v":"Total\nfor project"}]
[1,{"$f":"IF(OFFSET(B7,-1,-1)=\"HE\",1,IF(OFFSET(B7,0,-1)=\"TT\",3,IF(OFFSET(B7,-1,0)=1,2,1)))","v":1},{"$f":"IF(OFFSET(C7,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A7,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"IF(OFFSET(C7,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A7,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"IF(OFFSET(E7,ROW(E$4)-ROW(E7),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(E7),COLUMN($D7)+1)&\":\"&ADDRESS(ROW(E7),COLUMN(E7)-1),TRUE)),IF($A7=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(E7))&\":\"&ADDRESS(ROW(E7)-1,COLUMN(E7)),TRUE)),INDIRECT(CELL(\"address\",OFFSET(INDIRECT(\"'BE \" & TEXT(INT($A7),\"000\") & \"'!A1\",TRUE),MATCH(\"STARTWP\" & TEXT(OFFSET(E7,ROW(E$4)-ROW(E7),0),\"000\"),INDIRECT(\"'BE \" & TEXT(INT($A7),\"000\") & \"'!A:A\",TRUE),0),MATCH($A7,INDIRECT(\"'BE \" & TEXT(INT($A7),\"000\") & \"'!2:2\",TRUE),0)-2)),TRUE)))","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["TT",3,{"$f":"IF(OFFSET(C8,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A8,'Beneficiaries List'!J:J,0),TRUE))","v":"TOTAL"},{"$f":"IF(OFFSET(C8,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A8,'Beneficiaries List'!J:J,0),TRUE))","v":"Consortium"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Depreciation Costs","index":8,"n_rows":210,"n_cols":12,"rows_kept":210,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["TOOL:   DEPRECIATION COSTS LIST"]
[]
["BE nr","Beneficiary name","WP nr","Work Package name","Resource type","Short name of the investments","Date of purchase","Purchase cost","% used for the project","% use for lifetime of the investment","Charged \ndepreciation costs \nper investment","Justification: Needed info for depreciation"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+H4*I4*J4","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+H70*I70*J70","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+H134*I134*J134","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+H198*I198*J198","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Any comments","index":9,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Any comments"]
[]
["nr","BE ref","WP ref","Comments"]

{"sheet":"BE XXX","index":10,"n_rows":39,"n_cols":21,"rows_kept":39,"cut":false,"hidden":true,"merged":[[36,14,36,16],[9,13,38,13],[9,14,9,16],[10,15,10,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,14,20,16],[21,14,21,16],[22,15,22,16],[38,14,38,16],[26,15,26,16],[27,15,27,16],[32,14,32,16],[33,15,33,16],[34,14,34,16],[8,14,8,16],[2,16,3,16],[2,17,2,19],[2,20,3,20],[3,17,3,19],[6,14,6,16]]}
[1,{"$f":"IF(ISERROR(MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0))","v":9},{"$f":"COUNTIF(E:E,\"GT\")","v":1},{"$f":"IF(ISERROR(MATCH(\"ENDWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"ENDWP\" & TEXT(A1,\"000\"),A:A,0))","v":39},null,{"$f":"COUNTA(A:A)","v":39},null,"TBE",{"$f":"MATCH(H1,2:2,0)","v":21},{"$f":"MATCH(\"BE\",2:2,0)","v":18},{"$f":"COUNTIF(2:2,\"TP\")","v":0},null,null,"C","XX","XX","TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)XXX","X.XXX,XX","XXXXXXXXX,XX","XXXXXXXXXXX,XX","XXXXXXXXXXXXXX,XX"]
[{"$f":"INDIRECT(\"'\"& MID(OFFSET(A2,ROW(A$3)-ROW(A2),IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",0,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(A2),MATCH(INDIRECT(ADDRESS(2,COLUMN(A2)+IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",1,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(A2,ROW(A$3)-ROW(A2),IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",0,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(A2,ROW(A$2)-ROW(A2),2)=\"T\",1,IF(OFFSET(A2,ROW(A$2)-ROW(A2),1)=\"T\",0,-1))),TRUE)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,99,null,null,null,{"$f":"IF(OFFSET(R2,0,1)=\"\",\"TT\",IF(INT(OFFSET(R2,0,1))=OFFSET(R2,0,1),\"BE\",\"TP\"))","v":"BE"},0,{"$f":"IF(OFFSET(T2,0,-2)=\"TT\",\"E\",\"T\")","v":"T"},"TBE"]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"&IF(OFFSET(Q3,-2,-3)=\"C\",\"DETAILED\",INDIRECT(\"'Beneficiaries List'!A\" & MATCH(OFFSET(Q3,-2,-3),'Beneficiaries List'!$J:$J,0),TRUE))","v":"DETAILED"},{"$f":"\"\"&INDIRECT(\"'Beneficiaries List'!A\" & MATCH(OFFSET(R3,-1,1),'Beneficiaries List'!$K:$K,0),TRUE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(U2=\"TBE\",\"BE \" & TEXT(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U3,-1,-2)),2:2,0)),TRUE),\"000\"),\"PROJECT\")","v":"BE 000"}]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(OFFSET(R4,-2,1),'Beneficiaries List'!$K:$K,0),TRUE)","v":{"$error":"#N/A"}}]
["X",null,null,null,0,1,2,3,4,5,6,7,null,null,null,null,{"$f":"\"\"&IF(OFFSET(Q5,-4,-3)=\"C\",\"CONSOLIDATION\",INDIRECT(\"'Beneficiaries List'!B\" & MATCH(OFFSET(Q5,-4,-3),'Beneficiaries List'!$J:$J,0),TRUE))","v":"CONSOLIDATION"},{"$f":"IF(OFFSET(R5,-3,0)=\"TT\",\"BE+TP\nTOTAL COSTS\",\"UNITS\")","v":"UNITS"},{"$f":"IF(OFFSET(S5,0,-1)=\"UNITS\",\"COST\nPER UNIT\",\"\")","v":"COST\nPER UNIT"},{"$f":"IF(OFFSET(T5,0,-2)=\"UNITS\",IF(OFFSET(T5,-3,-2)=\"BE\",\"BENEFICIARY\",\"AFFILIATED ENTITY\") & \"\nTOTAL COSTS\",\"\")","v":"BENEFICIARY\nTOTAL COSTS"},"BE+AE TOTAL COSTS"]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,-1,-2]
["X",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total WORK PACKAGES: ",null,null,{"$f":"SUMIF($E:$E,\"GT\",R:R)","v":0},null,{"$f":"SUMIF($E:$E,\"GT\",T:T)","v":0},{"$f":"IF(OFFSET(U7,ROW(U$2)-ROW(U7),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q7)+1) & \":\" & ADDRESS(2,COLUMN(U7)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U7), COLUMN($Q7)+1) & \":\" & ADDRESS(ROW(U7),COLUMN(U7)-1),TRUE)),IF(OFFSET(U7,ROW(U$2)-ROW(U7),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U7,ROW(U$2)-ROW(U7),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U7)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U7), MATCH(INT(OFFSET(U7,ROW(U$2)-ROW(U7),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U7),COLUMN(U7)-1),TRUE)),IF(OFFSET(U7,0,COLUMN($M7)-COLUMN(U7))=\"V\",OFFSET(U7,0,-2)*OFFSET(U7,0,-1),\"TOTAL\")))","v":0}]
["X"]
[{"$f":"IF(ISNUMBER(OFFSET(A9,0,13)),\"START\",IF(AND(OFFSET(A9,0,2)=0,OFFSET(A9,0,4)=\"GT\"),\"END\",\"\"))&OFFSET(A9,0,1)","v":"STARTWP001"},{"$f":"IF(ISNUMBER(OFFSET(B9,0,12)),\"WP\" & TEXT(OFFSET(B9,0,12),\"000\"),OFFSET(B9,-1,0))","v":"WP001"},null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"\"\"&VLOOKUP(OFFSET(N9,1,0),'Work Packages List'!A:B,2,FALSE)","v":""}]
[{"$f":"IF(ISNUMBER(OFFSET(A10,0,12)),\"START\",IF(AND(OFFSET(A10,0,2)=0,OFFSET(A10,0,4)=\"GT\"),\"END\",\"\"))&OFFSET(A10,0,1)","v":"WP001"},{"$f":"IF(ISNUMBER(OFFSET(B10,0,11)),\"WP\" & TEXT(OFFSET(B10,0,11),\"000\"),OFFSET(B10,-1,0))","v":"WP001"},4,"WPRow.A",null,null,null,"TTA","TA",null,null,null,"T",{"$f":"\"WP \" & TEXT(OFFSET(N10,-1,0),\"000\")","v":"WP 001"},"A. DIRECT PERSONNEL COSTS",null,null,{"$f":"IF(OFFSET(R10,ROW(R$2)-ROW(R10),0)=\"TT\",\"TT\",IF(OFFSET(R10,0,COLUMN($M10)-COLUMN(R10))=\"%\",ROUND(OFFSET(R10,-2,0)*0.07,2),IF(OFFSET(R10,0,COLUMN($M10)-COLUMN(R10))=\"V\",\"x\",SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),$C10+COLUMN($E10)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),$C10+COLUMN($E10)+1),TRUE),INDIRECT(ADDRESS(ROW(R10),$C10+COLUMN($E10)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),COLUMN(R10))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R10,0,COLUMN($B10)-COLUMN(R10)),$A:$A,0),COLUMN(R10)),TRUE)))))","v":0},null,{"$f":"IF(OFFSET(T10,ROW(T$2)-ROW(T10),0)=\"TT\",\"TT\",IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"%\",ROUND((OFFSET(T10,-2,0)-OFFSET(T10,-21,0))*0.07,2),IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"V\",ROUND(OFFSET(T10,0,-2)*OFFSET(T10,0,-1),2),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),$C10+COLUMN($E10)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),$C10+COLUMN($E10)+1),TRUE),INDIRECT(ADDRESS(ROW(T10),$C10+COLUMN($E10)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),COLUMN(T10))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T10,0,COLUMN($B10)-COLUMN(T10)),$A:$A,0),COLUMN(T10)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U10,ROW(U$2)-ROW(U10),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q10)+1) & \":\" & ADDRESS(2,COLUMN(U10)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U10), COLUMN($Q10)+1) & \":\" & ADDRESS(ROW(U10),COLUMN(U10)-1),TRUE)),IF(OFFSET(U10,ROW(U$2)-ROW(U10),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U10,ROW(U$2)-ROW(U10),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U10)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U10), MATCH(INT(OFFSET(U10,ROW(U$2)-ROW(U10),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U10),COLUMN(U10)-1),TRUE)),IF(OFFSET(U10,0,COLUMN($M10)-COLUMN(U10))=\"V\",OFFSET(U10,0,-2)*OFFSET(U10,0,-1),\"TOTAL\")))","v":0}]
["WP001","WP001",6,"WPRow.B",null,null,null,null,null,"TA","T1",null,"T",null,null,"A1. Employees (or equivalent) person months",null,{"$f":"IF(OFFSET(R11,ROW(R$2)-ROW(R11),0)=\"TT\",\"TT\",IF(OFFSET(R11,0,COLUMN($M11)-COLUMN(R11))=\"%\",ROUND(OFFSET(R11,-2,0)*0.07,2),IF(OFFSET(R11,0,COLUMN($M11)-COLUMN(R11))=\"V\",\"x\",SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),$C11+COLUMN($E11)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),$C11+COLUMN($E11)+1),TRUE),INDIRECT(ADDRESS(ROW(R11),$C11+COLUMN($E11)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),COLUMN(R11))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(R11,0,COLUMN($B11)-COLUMN(R11)),$A:$A,0),COLUMN(R11)),TRUE)))))","v":0},null,0,0]
["WP001","WP001",7,"WPRow.C",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE1","v":"Type 1"},null,null,0,0]
["WP001","WP001",7,"WPRow.D",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE2","v":"Type 2"},null,null,0,0]
["WP001","WP001",7,"WPRow.E",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE3","v":"Type 3"},null,null,0,0]
["WP001","WP001",7,"WPRow.F",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE4","v":"Type 4"},null,null,0,0]
["WP001","WP001",7,"WPRow.G",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_OTHER","v":"Other"},null,null,0,0]
["WP001","WP001",6,"WPRow.H",null,null,null,null,null,"TA",null,null,"V",null,null,"A.2 Natural persons under direct contract ",null,null,null,0,0]
["WP001","WP001",6,"WPRow.I",null,null,null,null,null,"TA",null,null,"V",null,null,"A.3 Seconded persons",null,null,null,0,0]
["WP001","WP001",6,"WPRow.J",null,null,null,null,null,"TA",null,null,"V",null,null,"A.4 SME Owners without salary",null,null,null,0,0]
["WP001","WP001",6,"WPRow.K",null,null,null,null,null,"TA",null,null,"V",null,null,"A.5 Volunteers ",null,null,null,0,0]
["WP001","WP001",4,"WPRow.L",null,null,null,"TTA","TB",null,null,null,"V",null,"B. Subcontracting costs (please specify details under worksheet \"Comments\")",null,null,null,null,0,0]
["WP001","WP001",4,"WPRow.M",null,null,null,"TTA","TC",null,null,null,"T",null,"C. Purchase costs",null,null,null,null,0,0]
["WP001","WP001",6,"WPRow.N",null,null,null,null,null,"TC","T3",null,"T",null,null,"C.1 Travel and subsistence per travel or  day",null,null,null,0,0]
["WP001","WP001",7,"WPRow.O",null,null,null,null,null,null,null,"T3","V",null,null,null,"Travel",null,null,0,0]
["WP001","WP001",7,"WPRow.P",null,null,null,null,null,null,null,"T3","V",null,null,null,"Accommodation",null,null,0,0]
["WP001","WP001",7,"WPRow.Q",null,null,null,null,null,null,null,"T3","V",null,null,null,"Subsistence",null,null,0,0]
["WP001","WP001",5,"WPRow.R",null,null,null,null,null,"TC",null,null,"V",null,null,"C.2 Equipment (please refer to the Depreciation Cost sheet)",null,null,null,0,0]
["WP001","WP001",6,"WPRow.S",null,null,null,null,null,"TC","T4",null,"T",null,null,"C.3 Other goods, works and services",null,null,null,0,0]
["WP001","WP001",7,"WPRow.T",null,null,null,null,null,null,null,"T4","V",null,null,null,"Consumables",null,null,0,0]
["WP001","WP001",7,"WPRow.U",null,null,null,null,null,null,null,"T4","V",null,null,null,"Services for meetings, seminars and events (rentals, translations, interpretation, ...)",null,null,0,0]
["WP001","WP001",7,"WPRow.V",null,null,null,null,null,null,null,"T4","V",null,null,null,"Services for communication/promotion/dissemination (translation, printing, graphic designer, ...)",null,null,0,0]
["WP001","WP001",7,"WPRow.0",null,null,null,null,null,null,null,"T4","V",null,null,null,"Other (please specify details under worksheet \"Comments\")",null,null,0,0]
["WP001","WP001",4,"WPRow.1",null,null,null,"TTA","TD",null,null,null,"T",null,"D. Other cost categories",null,null,null,null,0,0]
["WP001","WP001",5,"WPRow.2",null,null,null,null,null,"TD",null,null,"V",null,null,"D.1 Financial support to third parties",null,null,null,0,0]
["WP001","WP001",2,"WPRow.3",null,"GT","TTA",null,null,null,null,null,"T",null,"TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)",null,null,null,null,0,0]
["WP001","WP001",1]
["WP001","WP001",2,"WPRow.4",null,"GT",null,null,null,null,null,null,"%",null,"E. Indirect costs 7%",null,null,null,null,{"$f":"IF(OFFSET(T37,ROW(T$2)-ROW(T37),0)=\"TT\",\"TT\",IF(OFFSET(T37,0,COLUMN($M37)-COLUMN(T37))=\"%\",ROUND((OFFSET(T37,-2,0)-OFFSET(T37,-21,0))*0.07,2),IF(OFFSET(T37,0,COLUMN($M37)-COLUMN(T37))=\"V\",ROUND(OFFSET(T37,0,-2)*OFFSET(T37,0,-1),2),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),$C37+COLUMN($E37)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),$C37+COLUMN($E37)+1),TRUE),INDIRECT(ADDRESS(ROW(T37),$C37+COLUMN($E37)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),COLUMN(T37))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T37,0,COLUMN($B37)-COLUMN(T37)),$A:$A,0),COLUMN(T37)),TRUE)))))","v":0},0]
["WP001","WP001",1]
["ENDWP001","WP001",0,"WPRow.5","GT",null,null,null,null,null,null,null,"T",null,{"$f":"\"TOTAL COSTS (A+B+C+D+E) - \" & OFFSET(O39,-26,0)","v":"TOTAL COSTS (A+B+C+D+E) - "},null,null,null,null,{"$f":"IF(OFFSET(T39,ROW(T$2)-ROW(T39),0)=\"TT\",\"TT\",IF(OFFSET(T39,0,COLUMN($M39)-COLUMN(T39))=\"%\",ROUND((OFFSET(T39,-2,0)-OFFSET(T39,-21,0))*0.07,2),IF(OFFSET(T39,0,COLUMN($M39)-COLUMN(T39))=\"V\",ROUND(OFFSET(T39,0,-2)*OFFSET(T39,0,-1),2),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),$C39+COLUMN($E39)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),$C39+COLUMN($E39)+1),TRUE),INDIRECT(ADDRESS(ROW(T39),$C39+COLUMN($E39)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),COLUMN(T39))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T39,0,COLUMN($B39)-COLUMN(T39)),$A:$A,0),COLUMN(T39)),TRUE)))))","v":0},0]

{"sheet":"Country List","index":11,"n_rows":249,"n_cols":8,"rows_kept":249,"cut":false,"hidden":true,"merged":[]}
["Group","ListOfCountries","Country","ISO Code",null,"Group","Country","ISO Code"]
[{"$f":"MID(B2,1,1)","v":"A"},"Andorra (AD)","Andorra","AD",null,{"$f":"MID(H2,1,1)","v":"A"},"Andorra","AD"]
[{"$f":"MID(B3,1,1)","v":"A"},"Afghanistan (AF)","Afghanistan","AF",null,"A","United Arab Emirates","AE"]
["A","Aland Islands (AX)","Aland Islands","AX",null,"A","Afghanistan","AF"]
["A","Albania (AL)","Albania","AL",null,"A","Antigua and Barbuda","AG"]
["A","Algeria (DZ)","Algeria","DZ",null,"A","Anguilla","AI"]
["A","American Samoa (AS)","American Samoa","AS",null,"A","Albania","AL"]
["A","Angola (AO)","Angola","AO",null,"A","Armenia","AM"]
["A","Anguilla (AI)","Anguilla","AI",null,"A","Netherlands Antilles","AN"]
["A","Antarctica (AQ)","Antarctica","AQ",null,"A","Angola","AO"]
["A","Antigua and Barbuda (AG)","Antigua and Barbuda","AG",null,"A","Antarctica","AQ"]
["A","Argentina (AR)","Argentina","AR",null,"A","Argentina","AR"]
["A","Armenia (AM)","Armenia","AM",null,"A","American Samoa","AS"]
["A","Aruba (AW)","Aruba","AW",null,"A","Austria","AT"]
["A","Australia (AU)","Australia","AU",null,"A","Australia","AU"]
["A","Austria (AT)","Austria","AT",null,"A","Aruba","AW"]
["A","Azerbaijan (AZ)","Azerbaijan","AZ",null,"A","Aland Islands","AX"]
["B","Bahamas (BS)","Bahamas","BS",null,"A","Azerbaijan","AZ"]
["B","Bahrain (BH)","Bahrain","BH",null,"B","Bosnia and Herzegovina","BA"]
["B","Bangladesh (BD)","Bangladesh","BD",null,"B","Barbados","BB"]
["B","Barbados (BB)","Barbados","BB",null,"B","Bangladesh","BD"]
["B","Belarus (BY)","Belarus","BY",null,"B","Belgium","BE"]
["B","Belgium (BE)","Belgium","BE",null,"B","Burkina Faso","BF"]
["B","Belize (BZ)","Belize","BZ",null,"B","Bulgaria","BG"]
["B","Benin (BJ)","Benin","BJ",null,"B","Bahrain","BH"]
["B","Bermuda (BM)","Bermuda","BM",null,"B","Burundi","BI"]
["B","Bhutan (BT)","Bhutan","BT",null,"B","Benin","BJ"]
["B","Bolivia (BO)","Bolivia","BO",null,"B","Saint-Barthélemy","BL"]
["B","Bosnia and Herzegovina (BA)","Bosnia and Herzegovina","BA",null,"B","Bermuda","BM"]
["B","Botswana (BW)","Botswana","BW",null,"B","Brunei Darussalam","BN"]
["B","Bouvet Island (BV)","Bouvet Island","BV",null,"B","Bolivia","BO"]
["B","Brazil (BR)","Brazil","BR",null,"B","Brazil","BR"]
["B","British Indian Ocean Territory (IO)","British Indian Ocean Territory","IO",null,"B","Bahamas","BS"]
["B","British Virgin Islands (VG)","British Virgin Islands","VG",null,"B","Bhutan","BT"]
["B","Brunei Darussalam (BN)","Brunei Darussalam","BN",null,"B","Bouvet Island","BV"]
["B","Bulgaria (BG)","Bulgaria","BG",null,"B","Botswana","BW"]
["B","Burkina Faso (BF)","Burkina Faso","BF",null,"B","Belarus","BY"]
["B","Burundi (BI)","Burundi","BI",null,"B","Belize","BZ"]
["C","Cambodia (KH)","Cambodia","KH",null,"C","Canada","CA"]
["C","Cameroon (CM)","Cameroon","CM",null,"C","Cocos (Keeling) Islands","CC"]
["C","Canada (CA)","Canada","CA",null,"C","Congo, (Kinshasa)","CD"]
["C","Cape Verde (CV)","Cape Verde","CV",null,"C","Central African Republic","CF"]
["C","Cayman Islands  (KY)","Cayman Islands ","KY",null,"C","Congo (Brazzaville)","CG"]
["C","Central African Republic (CF)","Central African Republic","CF",null,"C","Switzerland","CH"]
["C","Chad (TD)","Chad","TD",null,"C","Côte d'Ivoire","CI"]
["C","Chile (CL)","Chile","CL",null,"C","Cook Islands ","CK"]
["C","China (CN)","China","CN",null,"C","Chile","CL"]
["C","Christmas Island (CX)","Christmas Island","CX",null,"C","Cameroon","CM"]
["C","Cocos (Keeling) Islands (CC)","Cocos (Keeling) Islands","CC",null,"C","China","CN"]
["C","Colombia (CO)","Colombia","CO",null,"C","Colombia","CO"]
["C","Comoros (KM)","Comoros","KM",null,"C","Costa Rica","CR"]
["C","Congo (Brazzaville) (CG)","Congo (Brazzaville)","CG",null,"C","Cuba","CU"]
["C","Congo, (Kinshasa) (CD)","Congo, (Kinshasa)","CD",null,"C","Cape Verde","CV"]
["C","Cook Islands  (CK)","Cook Islands ","CK",null,"C","Christmas Island","CX"]
["C","Costa Rica (CR)","Costa Rica","CR",null,"C","Cyprus","CY"]
["C","Côte d'Ivoire (CI)","Côte d'Ivoire","CI",null,"C","Czech Republic","CZ"]
["C","Croatia (HR)","Croatia","HR",null,"D","Germany","DE"]
["C","Cuba (CU)","Cuba","CU",null,"D","Djibouti","DJ"]
["C","Cyprus (CY)","Cyprus","CY",null,"D","Denmark","DK"]
["C","Czech Republic (CZ)","Czech Republic","CZ",null,"D","Dominica","DM"]
["D","Denmark (DK)","Denmark","DK",null,"D","Dominican Republic","DO"]
["D","Djibouti (DJ)","Djibouti","DJ",null,"D","Algeria","DZ"]
["D","Dominica (DM)","Dominica","DM",null,"E","Ecuador","EC"]
["D","Dominican Republic (DO)","Dominican Republic","DO",null,"E","Estonia","EE"]
["E","Ecuador (EC)","Ecuador","EC",null,"E","Egypt","EG"]
["E","Egypt (EG)","Egypt","EG",null,{"$f":"MID(H66,1,1)","v":"E"},"Western Sahara","EH"]
[{"$f":"MID(B67,1,1)","v":"E"},"El Salvador (SV)","El Salvador","SV",null,"E","Eritrea","ER"]
["E","Equatorial Guinea (GQ)","Equatorial Guinea","GQ",null,"E","Spain","ES"]
["E","Eritrea (ER)","Eritrea","ER",null,"E","Ethiopia","ET"]
["E","Estonia (EE)","Estonia","EE",null,"F","Finland","FI"]
["E","Ethiopia (ET)","Ethiopia","ET",null,"F","Fiji","FJ"]
["F","Falkland Islands (Malvinas)  (FK)","Falkland Islands (Malvinas) ","FK",null,"F","Falkland Islands (Malvinas) ","FK"]
["F","Faroe Islands (FO)","Faroe Islands","FO",null,"F","Micronesia, Federated States of","FM"]
["F","Fiji (FJ)","Fiji","FJ",null,"F","Faroe Islands","FO"]
["F","Finland (FI)","Finland","FI",null,"F","France","FR"]
["F","France (FR)","France","FR",null,"G","Gabon","GA"]
["F","French Guiana (GF)","French Guiana","GF",null,"G","United Kingdom","GB"]
["F","French Polynesia (PF)","French Polynesia","PF",null,"G","Grenada","GD"]
["F","French Southern Territories (TF)","French Southern Territories","TF",null,"G","Georgia","GE"]
["G","Gabon (GA)","Gabon","GA",null,"G","French Guiana","GF"]
["G","Gambia (GM)","Gambia","GM",null,"G","Guernsey","GG"]
["G","Georgia (GE)","Georgia","GE",null,"G","Ghana","GH"]
["G","Germany (DE)","Germany","DE",null,"G","Gibraltar ","GI"]
["G","Ghana (GH)","Ghana","GH",null,"G","Greenland","GL"]
["G","Gibraltar  (GI)","Gibraltar ","GI",null,"G","Gambia","GM"]
["G","Greece (GR)","Greece","GR",null,"G","Guinea","GN"]
["G","Greenland (GL)","Greenland","GL",null,"G","Guadeloupe","GP"]
["G","Grenada (GD)","Grenada","GD",null,"G","Equatorial Guinea","GQ"]
["G","Guadeloupe (GP)","Guadeloupe","GP",null,"G","Greece","GR"]
["G","Guam (GU)","Guam","GU",null,"G","South Georgia and the South Sandwich Islands","GS"]
["G","Guatemala (GT)","Guatemala","GT",null,"G","Guatemala","GT"]
["G","Guernsey (GG)","Guernsey","GG",null,"G","Guam","GU"]
["G","Guinea (GN)","Guinea","GN",null,"G","Guinea-Bissau","GW"]
["G","Guinea-Bissau (GW)","Guinea-Bissau","GW",null,"G","Guyana","GY"]
["G","Guyana (GY)","Guyana","GY",null,"H","Hong Kong, SAR China","HK"]
["H","Haiti (HT)","Haiti","HT",null,"H","Heard and Mcdonald Islands","HM"]
["H","Heard and Mcdonald Islands (HM)","Heard and Mcdonald Islands","HM",null,"H","Honduras","HN"]
["H","Holy See (Vatican City State) (VA)","Holy See (Vatican City State)","VA",null,"H","Croatia","HR"]
["H","Honduras (HN)","Honduras","HN",null,"H","Haiti","HT"]
["H","Hong Kong, SAR China (HK)","Hong Kong, SAR China","HK",null,"H","Hungary","HU"]
["H","Hungary (HU)","Hungary","HU",null,"I","Indonesia","ID"]
["I","Iceland (IS)","Iceland","IS",null,"I","Ireland","IE"]
["I","India (IN)","India","IN",null,"I","Israel","IL"]
["I","Indonesia (ID)","Indonesia","ID",null,"I","Isle of Man ","IM"]
["I","Iran, Islamic Republic of (IR)","Iran, Islamic Republic of","IR",null,"I","India","IN"]
["I","Iraq (IQ)","Iraq","IQ",null,"I","British Indian Ocean Territory","IO"]
["I","Ireland (IE)","Ireland","IE",null,"I","Iraq","IQ"]
["I","Isle of Man  (IM)","Isle of Man ","IM",null,"I","Iran, Islamic Republic of","IR"]
["I","Israel (IL)","Israel","IL",null,"I","Iceland","IS"]
["I","Italy (IT)","Italy","IT",null,"I","Italy","IT"]
["J","Jamaica (JM)","Jamaica","JM",null,"J","Jersey","JE"]
["J","Japan (JP)","Japan","JP",null,"J","Jamaica","JM"]
["J","Jersey (JE)","Jersey","JE",null,"J","Jordan","JO"]
["J","Jordan (JO)","Jordan","JO",null,"J","Japan","JP"]
["K","Kazakhstan (KZ)","Kazakhstan","KZ",null,"K","Kenya","KE"]
["K","Kenya (KE)","Kenya","KE",null,"K","Kyrgyzstan","KG"]
["K","Kiribati (KI)","Kiribati","KI",null,"K","Cambodia","KH"]
["K","Korea (North) (KP)","Korea (North)","KP",null,"K","Kiribati","KI"]
["K","Korea (South) (KR)","Korea (South)","KR",null,"K","Comoros","KM"]
["K","Kosovo (XK)","Kosovo","XK",null,"K","Saint Kitts and Nevis","KN"]
["K","Kuwait (KW)","Kuwait","KW",null,"K","Korea (North)","KP"]
["K","Kyrgyzstan (KG)","Kyrgyzstan","KG",null,"K","Korea (South)","KR"]
["L","Lao PDR (LA)","Lao PDR","LA",null,"K","Kuwait","KW"]
["L","Latvia (LV)","Latvia","LV",null,"K","Cayman Islands ","KY"]
["L","Lebanon (LB)","Lebanon","LB",null,"K","Kazakhstan","KZ"]
["L","Lesotho (LS)","Lesotho","LS",null,"L","Lao PDR","LA"]
["L","Liberia (LR)","Liberia","LR",null,"L","Lebanon","LB"]
["L","Libya (LY)","Libya","LY",null,"L","Saint Lucia","LC"]
["L","Liechtenstein (LI)","Liechtenstein","LI",null,"L","Liechtenstein","LI"]
["L","Lithuania (LT)","Lithuania","LT",null,{"$f":"MID(H130,1,1)","v":"L"},"Sri Lanka","LK"]
["L","Luxembourg (LU)","Luxembourg","LU",null,"L","Liberia","LR"]
[{"$f":"MID(B132,1,1)","v":"M"},"Macao, SAR China (MO)","Macao, SAR China","MO",null,"L","Lesotho","LS"]
["M","Macedonia, Republic of (MK)","Macedonia, Republic of","MK",null,"L","Lithuania","LT"]
["M","Madagascar (MG)","Madagascar","MG",null,"L","Luxembourg","LU"]
["M","Malawi (MW)","Malawi","MW",null,"L","Latvia","LV"]
["M","Malaysia (MY)","Malaysia","MY",null,"L","Libya","LY"]
["M","Maldives (MV)","Maldives","MV",null,"M","Morocco","MA"]
["M","Mali (ML)","Mali","ML",null,"M","Monaco","MC"]
["M","Malta (MT)","Malta","MT",null,"M","Moldova","MD"]
["M","Marshall Islands (MH)","Marshall Islands","MH",null,"M","Montenegro","ME"]
["M","Martinique (MQ)","Martinique","MQ",null,"M","Saint-Martin (French part)","MF"]
["M","Mauritania (MR)","Mauritania","MR",null,"M","Madagascar","MG"]
["M","Mauritius (MU)","Mauritius","MU",null,"M","Marshall Islands","MH"]
["M","Mayotte (YT)","Mayotte","YT",null,"M","Macedonia, Republic of","MK"]
["M","Mexico (MX)","Mexico","MX",null,"M","Mali","ML"]
["M","Micronesia, Federated States of (FM)","Micronesia, Federated States of","FM",null,"M","Myanmar","MM"]
["M","Moldova (MD)","Moldova","MD",null,"M","Mongolia","MN"]
["M","Monaco (MC)","Monaco","MC",null,"M","Macao, SAR China","MO"]
["M","Mongolia (MN)","Mongolia","MN",null,"M","Northern Mariana Islands","MP"]
["M","Montenegro (ME)","Montenegro","ME",null,"M","Martinique","MQ"]
["M","Montserrat (MS)","Montserrat","MS",null,"M","Mauritania","MR"]
["M","Morocco (MA)","Morocco","MA",null,"M","Montserrat","MS"]
["M","Mozambique (MZ)","Mozambique","MZ",null,"M","Malta","MT"]
["M","Myanmar (MM)","Myanmar","MM",null,"M","Mauritius","MU"]
["N","Namibia (NA)","Namibia","NA",null,"M","Maldives","MV"]
["N","Nauru (NR)","Nauru","NR",null,"M","Malawi","MW"]
["N","Nepal (NP)","Nepal","NP",null,"M","Mexico","MX"]
["N","Netherlands (NL)","Netherlands","NL",null,"M","Malaysia","MY"]
["N","Netherlands Antilles (AN)","Netherlands Antilles","AN",null,"M","Mozambique","MZ"]
["N","New Caledonia (NC)","New Caledonia","NC",null,"N","Namibia","NA"]
["N","New Zealand (NZ)","New Zealand","NZ",null,"N","New Caledonia","NC"]
["N","Nicaragua (NI)","Nicaragua","NI",null,"N","Niger","NE"]
["N","Niger (NE)","Niger","NE",null,"N","Norfolk Island","NF"]
["N","Nigeria (NG)","Nigeria","NG",null,"N","Nigeria","NG"]
["N","Niue  (NU)","Niue ","NU",null,"N","Nicaragua","NI"]
["N","Norfolk Island (NF)","Norfolk Island","NF",null,"N","Netherlands","NL"]
["N","Northern Mariana Islands (MP)","Northern Mariana Islands","MP",null,"N","Norway","NO"]
["N","Norway (NO)","Norway","NO",null,"N","Nepal","NP"]
["O","Oman (OM)","Oman","OM",null,"N","Nauru","NR"]
["P","Pakistan (PK)","Pakistan","PK",null,"N","Niue ","NU"]
["P","Palau (PW)","Palau","PW",null,"N","New Zealand","NZ"]
["P","Palestinian Territory (PS)","Palestinian Territory","PS",null,"O","Oman","OM"]
["P","Panama (PA)","Panama","PA",null,"P","Panama","PA"]
["P","Papua New Guinea (PG)","Papua New Guinea","PG",null,"P","Peru","PE"]
["P","Paraguay (PY)","Paraguay","PY",null,"P","French Polynesia","PF"]
["P","Peru (PE)","Peru","PE",null,"P","Papua New Guinea","PG"]
["P","Philippines (PH)","Philippines","PH",null,"P","Philippines","PH"]
["P","Pitcairn (PN)","Pitcairn","PN",null,"P","Pakistan","PK"]
["P","Poland (PL)","Poland","PL",null,"P","Poland","PL"]
["P","Portugal (PT)","Portugal","PT",null,"P","Saint Pierre and Miquelon ","PM"]
["P","Puerto Rico (PR)","Puerto Rico","PR",null,"P","Pitcairn","PN"]
["Q","Qatar (QA)","Qatar","QA",null,"P","Puerto Rico","PR"]
["R","Réunion (RE)","Réunion","RE",null,"P","Palestinian Territory","PS"]
["R","Romania (RO)","Romania","RO",null,"P","Portugal","PT"]
["R","Russian Federation (RU)","Russian Federation","RU",null,"P","Palau","PW"]
["R","Rwanda (RW)","Rwanda","RW",null,"P","Paraguay","PY"]
["S","Saint Helena (SH)","Saint Helena","SH",null,"Q","Qatar","QA"]
["S","Saint Kitts and Nevis (KN)","Saint Kitts and Nevis","KN",null,"R","Réunion","RE"]
["S","Saint Lucia (LC)","Saint Lucia","LC",null,"R","Romania","RO"]
["S","Saint Pierre and Miquelon  (PM)","Saint Pierre and Miquelon ","PM",null,"R","Serbia","RS"]
["S","Saint Vincent and Grenadines (VC)","Saint Vincent and Grenadines","VC",null,"R","Russian Federation","RU"]
["S","Saint-Barthélemy (BL)","Saint-Barthélemy","BL",null,"R","Rwanda","RW"]
["S","Saint-Martin (French part) (MF)","Saint-Martin (French part)","MF",null,"S","Saudi Arabia","SA"]
["S","Samoa (WS)","Samoa","WS",null,{"$f":"MID(H194,1,1)","v":"S"},"Solomon Islands","SB"]
["S","San Marino (SM)","San Marino","SM",null,"S","Seychelles","SC"]
[{"$f":"MID(B196,1,1)","v":"S"},"Sao Tome and Principe (ST)","Sao Tome and Principe","ST",null,"S","Sudan","SD"]
["S","Saudi Arabia (SA)","Saudi Arabia","SA",null,"S","Sweden","SE"]
["S","Senegal (SN)","Senegal","SN",null,"S","Singapore","SG"]
["S","Serbia (RS)","Serbia","RS",null,"S","Saint Helena","SH"]
["S","Seychelles (SC)","Seychelles","SC",null,"S","Slovenia","SI"]
["S","Sierra Leone (SL)","Sierra Leone","SL",null,"S","Svalbard and Jan Mayen Islands ","SJ"]
["S","Singapore (SG)","Singapore","SG",null,"S","Slovakia","SK"]
["S","Slovakia (SK)","Slovakia","SK",null,"S","Sierra Leone","SL"]
["S","Slovenia (SI)","Slovenia","SI",null,"S","San Marino","SM"]
["S","Solomon Islands (SB)","Solomon Islands","SB",null,"S","Senegal","SN"]
["S","Somalia (SO)","Somalia","SO",null,"S","Somalia","SO"]
["S","South Africa (ZA)","South Africa","ZA",null,"S","Suriname","SR"]
["S","South Georgia and the South Sandwich Islands (GS)","South Georgia and the South Sandwich Islands","GS",null,"S","South Sudan","SS"]
["S","South Sudan (SS)","South Sudan","SS",null,"S","Sao Tome and Principe","ST"]
["S","Spain (ES)","Spain","ES",null,"S","El Salvador","SV"]
["S","Sri Lanka (LK)","Sri Lanka","LK",null,"S","Syrian Arab Republic (Syria)","SY"]
["S","Sudan (SD)","Sudan","SD",null,"S","Swaziland","SZ"]
["S","Suriname (SR)","Suriname","SR",null,"T","Turks and Caicos Islands ","TC"]
["S","Svalbard and Jan Mayen Islands  (SJ)","Svalbard and Jan Mayen Islands ","SJ",null,"T","Chad","TD"]
["S","Swaziland (SZ)","Swaziland","SZ",null,"T","French Southern Territories","TF"]
["S","Sweden (SE)","Sweden","SE",null,"T","Togo","TG"]
["S","Switzerland (CH)","Switzerland","CH",null,"T","Thailand","TH"]
["S","Syrian Arab Republic (Syria) (SY)","Syrian Arab Republic (Syria)","SY",null,"T","Tajikistan","TJ"]
["T","Taiwan, Republic of China (TW)","Taiwan, Republic of China","TW",null,"T","Tokelau ","TK"]
["T","Tajikistan (TJ)","Tajikistan","TJ",null,"T","Timor-Leste","TL"]
["T","Tanzania, United Republic of (TZ)","Tanzania, United Republic of","TZ",null,"T","Turkmenistan","TM"]
["T","Thailand (TH)","Thailand","TH",null,"T","Tunisia","TN"]
["T","Timor-Leste (TL)","Timor-Leste","TL",null,"T","Tonga","TO"]
["T","Togo (TG)","Togo","TG",null,"T","Turkey","TR"]
["T","Tokelau  (TK)","Tokelau ","TK",null,"T","Trinidad and Tobago","TT"]
["T","Tonga (TO)","Tonga","TO",null,"T","Tuvalu","TV"]
["T","Trinidad and Tobago (TT)","Trinidad and Tobago","TT",null,"T","Taiwan, Republic of China","TW"]
["T","Tunisia (TN)","Tunisia","TN",null,"T","Tanzania, United Republic of","TZ"]
["T","Turkey (TR)","Turkey","TR",null,"U","Ukraine","UA"]
["T","Turkmenistan (TM)","Turkmenistan","TM",null,"U","Uganda","UG"]
["T","Turks and Caicos Islands  (TC)","Turks and Caicos Islands ","TC",null,"U","US Minor Outlying Islands","UM"]
["T","Tuvalu (TV)","Tuvalu","TV",null,"U","United States of America","US"]
["U","Uganda (UG)","Uganda","UG",null,"U","Uruguay","UY"]
["U","Ukraine (UA)","Ukraine","UA",null,"U","Uzbekistan","UZ"]
["U","United Arab Emirates (AE)","United Arab Emirates","AE",null,"V","Holy See (Vatican City State)","VA"]
["U","United Kingdom (GB)","United Kingdom","GB",null,"V","Saint Vincent and Grenadines","VC"]
["U","United States of America (US)","United States of America","US",null,"V","Venezuela (Bolivarian Republic)","VE"]
["U","Uruguay (UY)","Uruguay","UY",null,"V","British Virgin Islands","VG"]
["U","US Minor Outlying Islands (UM)","US Minor Outlying Islands","UM",null,"V","Virgin Islands, US","VI"]
["U","Uzbekistan (UZ)","Uzbekistan","UZ",null,"V","Viet Nam","VN"]
["V","Vanuatu (VU)","Vanuatu","VU",null,"V","Vanuatu","VU"]
["V","Venezuela (Bolivarian Republic) (VE)","Venezuela (Bolivarian Republic)","VE",null,"W","Wallis and Futuna Islands ","WF"]
["V","Viet Nam (VN)","Viet Nam","VN",null,"W","Samoa","WS"]
["V","Virgin Islands, US (VI)","Virgin Islands, US","VI",null,{"$f":"MID(H244,1,1)","v":"X"},"Kosovo","XK"]
["W","Wallis and Futuna Islands  (WF)","Wallis and Futuna Islands ","WF",null,"Y","Yemen","YE"]
["W","Western Sahara (EH)","Western Sahara","EH",null,{"$f":"MID(H246,1,1)","v":"Y"},"Mayotte","YT"]
["Y","Yemen (YE)","Yemen","YE",null,{"$f":"MID(H247,1,1)","v":"Z"},"South Africa","ZA"]
["Z","Zambia (ZM)","Zambia","ZM",null,{"$f":"MID(H248,1,1)","v":"Z"},"Zambia","ZM"]
["Z","Zimbabwe (ZW)","Zimbabwe","ZW",null,{"$f":"MID(H249,1,1)","v":"Z"},"Zimbabwe","ZW"]

{"sheet":"EGR","index":12,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"IF(OFFSET(B1,-1,-1)=\"HE\",1,IF(OFFSET(B1,0,-1)=\"TT\",3,IF(OFFSET(B1,-1,0)=1,2,1)))","v":{"$error":"#REF!"}},{"$f":"IF(OFFSET(C1,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A1,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(C1,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A1,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(E1,ROW(E$4)-ROW(E1),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(E1),COLUMN($D1)+1) & \":\" & ADDRESS(ROW(E1),COLUMN(E1)-1),TRUE)),IF($A1=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(E1))&\":\"&ADDRESS(ROW(E1)-1,COLUMN(E1)),TRUE)),INDIRECT(CELL(\"address\",OFFSET(INDIRECT(\"'BE \" & TEXT(INT($A1),\"000\") & \"'!A1\",TRUE),MATCH(\"ENDWP\" & TEXT(OFFSET(E1,ROW(E$4)-ROW(E1),0),\"000\"),INDIRECT(\"'BE \" & TEXT(INT($A1),\"000\") & \"'!A:A\",TRUE),0)-1,MATCH($A1,INDIRECT(\"'BE \" & TEXT(INT($A1),\"000\") & \"'!2:2\",TRUE),0))),TRUE)))","v":{"$error":"#N/A"}}]
[null,null,"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",999999999.99000001,999999999.99000001,999999999.99000001]
[null,{"$f":"ADDRESS(E3,COLUMN(C1))","v":"$C$7"},{"$f":"MATCH(\"TT\",A:A,0)","v":8},{"$f":"MATCH(\"TT\",4:4,0)","v":6},{"$f":"MATCH(\"HE\",A:A,0)+1","v":7}]
[null,null,"O",null,1,"TT"]
[null,null,"Total of the budget",{"$f":"TotalBudget","v":0},{"$f":"IF(D5=\"N/A\",\"\",\"EUR\")","v":"EUR"}]
["HE","X\nX\nX","BE NR/EA","Acronym",{"$f":"IF(OFFSET(E6,-2,0)=\"TT\",IF($C4=\"O\",\"Maximum\nGrant\nAmount\",IF($C4=\"PM\",\"Total\nfor project\",\"\")),INDIRECT(\"'Work Packages List'!A\" & MATCH(OFFSET(E6,-2,0),'Work Packages List'!$J:$J,0),TRUE) & \"\n\" & INDIRECT(\"'Work Packages List'!B\" & MATCH(OFFSET(E6,-2,0),'Work Packages List'!$J:$J,0),TRUE))","v":"WP 001\n"},{"$f":"IF(OFFSET(F6,-2,0)=\"TT\",IF($C4=\"O\",\"Maximum\nGrant\nAmount\",IF($C4=\"PM\",\"Total\nfor project\",\"\")),INDIRECT(\"'Work Packages List'!A\" & MATCH(OFFSET(F6,-2,0),'Work Packages List'!$J:$J,0),TRUE) & \"\n\" & INDIRECT(\"'Work Packages List'!B\" & MATCH(OFFSET(F6,-2,0),'Work Packages List'!$J:$J,0),TRUE))","v":"Maximum\nGrant\nAmount"}]
[1,{"$f":"IF(OFFSET(B7,-1,-1)=\"HE\",1,IF(OFFSET(B7,0,-1)=\"TT\",3,IF(OFFSET(B7,-1,0)=1,2,1)))","v":1},{"$f":"IF(OFFSET(C7,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A7,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"IF(OFFSET(C7,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A7,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"IF(OFFSET(E7,ROW(E$4)-ROW(E7),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(E7),COLUMN($D7)+1) & \":\" & ADDRESS(ROW(E7),COLUMN(E7)-1),TRUE)),IF($A7=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(E7))&\":\"&ADDRESS(ROW(E7)-1,COLUMN(E7)),TRUE)),INDIRECT(CELL(\"address\",OFFSET(INDIRECT(\"'BE \" & TEXT(INT($A7),\"000\") & \"'!A1\",TRUE),MATCH(\"ENDWP\" & TEXT(OFFSET(E7,ROW(E$4)-ROW(E7),0),\"000\"),INDIRECT(\"'BE \" & TEXT(INT($A7),\"000\") & \"'!A:A\",TRUE),0)-1,MATCH($A7,INDIRECT(\"'BE \" & TEXT(INT($A7),\"000\") & \"'!2:2\",TRUE),0))),TRUE)))","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["TT",3,{"$f":"IF(OFFSET(C8,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A8,'Beneficiaries List'!J:J,0),TRUE))","v":"TOTAL"},{"$f":"IF(OFFSET(C8,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A8,'Beneficiaries List'!J:J,0),TRUE))","v":"Consortium"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Referential","index":13,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Name","Value",null,{"$f":"\"[ Version LUMP SUM II - EUBA-EUAA-2026-EAC - v\" & B2 & \"_\" & TEXT(B4,\"000\") & \", of \" & TEXT(DAY(B3),\"00\")&\"/\"&TEXT(MONTH(B3),\"00\") & \"/\"&TEXT(YEAR(B3),\"0000\") & \" ]\"","v":"[ Version LUMP SUM II - EUBA-EUAA-2026-EAC - v1_001, of 18/12/2025 ]"}]
["CURRENT VERSION",1]
["DATE OF VERSION","2025-12-18"]
["BUILD",1]
["DO NOT CHANGE","ANYTHING BELOW"]
["CurrentFileName","db-LSII_euaa-2026-eac_en.xlsm"]
["LastIDBeneficiaire",1,null,"<init = 1"]
["LastIDWorkPackages",1,null,"<init = 1"]
["SheetBEBenNumCell",{"$f":"CELL(\"address\",'BE XXX'!N1)","v":"[db-LSII_euaa-2026-eac_en.xlsm]BE XXX!$N$1"}]
["SheetBEBenCell",{"$f":"CELL(\"address\",'BE XXX'!S2)","v":"[db-LSII_euaa-2026-eac_en.xlsm]BE XXX!$S$2"}]
["NbrColForWP",3]
["Total Budget",{"$f":"OFFSET(INDIRECT(\"'Estim costs of the project'!A1\",TRUE),6,MATCH(\"TT\",INDIRECT(\"'Estim costs of the project'!2:2\",TRUE),0)-1)","v":0}]
["MyRequestedEUContribution",{"$f":"INDIRECT(\"'Proposal Budget'!AP\" & MATCH(\"TT\",'Proposal Budget'!A:A,0),TRUE)","v":"No budget defined"}]
["PRORATA",{"$f":"MyRequetedEUContribution/TotalBudget","v":{"$error":"#VALUE!"}}]
["ColumnForWPNumber",{"$f":"CELL(\"col\",'BE XXX'!N9)","v":14}]
["ProtectionMode",1,null,"<init = 1"]
["File Status",1,null,"<init = 1"]
["Password for workbook","Detailed budget table"]

{"sheet":"Operations","index":14,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":true,"merged":[[2,2,2,4]]}
[null,"XXX","STEP","Status",null,"XXX","XXX"]
["X"]
["X\nX",null,"TASKS IN PROGRESS",null,null,null,null,null,{"$f":"MATCH(\"TOTAL\",'Proposal Budget'!E:E,0)","v":10},{"$f":"MATCH(\"CHECK\",'Proposal Budget'!1:1,0)","v":43},{"$f":"IF(ISNUMBER(OFFSET('Proposal Budget'!A1,I3-1,J3-2)),1,0)","v":0}]
[null,null,null,null,null,null,null,null,"BW","P","X"]
["X\nX",null,{"$f":"IF(OFFSET(C5,0,D$19)=\"\",\"\",H5)","v":1},1,{"$f":"OFFSET(C5,0,D$19)","v":"CHECK VALIDITY"},null,null,1,"Update from BENEFICIARIES LIST","PRINT TO PDF","CHECK VALIDITY"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C7,0,D$19)=\"\",\"\",H7)","v":2},0,{"$f":"OFFSET(C7,0,D$19)","v":"CONVERT TO .XLSX"},null,null,2,"Update from WORK PACKAGES LIST",null,"CONVERT TO .XLSX"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C9,0,D$19)=\"\",\"\",H9)","v":""},null,{"$f":"OFFSET(C9,0,D$19)","v":0},null,null,3,"Update DETAILED SUMMARY TABLE"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C11,0,D$19)=\"\",\"\",H11)","v":""},null,{"$f":"OFFSET(C11,0,D$19)","v":0},null,null,4,"Update BE-WP Person Months"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C13,0,D$19)=\"\",\"\",H13)","v":""},null,{"$f":"OFFSET(C13,0,D$19)","v":0},null,null,5,"Update TECHNICAL CALCULATIONS"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C15,0,D$19)=\"\",\"\",H15)","v":""},null,{"$f":"OFFSET(C15,0,D$19)","v":0},null,null,6,"Update PROPOSAL BUDGET"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C17,0,D$19)=\"\",\"\",H17)","v":""},null,{"$f":"OFFSET(C17,0,D$19)","v":0},null,null,7,"Update BE-WP Overview"]
[]
["X\nX",null,"X",{"$f":"MATCH(C19,4:4,0)-3","v":8}]

{"sheet":"UpdateParameters","index":15,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["XXXXXX\nX\nX",null,null,"XXXXXX\nX\nX"]
[null,"Maximum Grant Amount of this Action ",200000]
[null,"Cofinancing Percentage",0.8]
["X\nX\nX"]
[null,"Double-Click to apply the changes -->","APPLY CHANGES"]
["X\nX\nX\nX"]
[]
["X\nX\nX"]