{"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","Country List","BE-WP Person Months","Operations","EGR","Depreciation Costs","Any comments","Referential","UpdateParameters","BE xxx"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":41,"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":[[1,2,1,3],[3,1,3,3],[43,1,43,2],[42,0,42,2],[36,4,36,5],[29,3,29,5],[37,4,37,5],[30,3,30,5],[15,1,16,1],[41,0,41,2],[20,1,22,1]]}
["XXXX","XXXX",{"$f":"CurrentVersion","v":"[ Version LUMP SUM II - JUST - v1_000, of 25/11/2022 00:00 ]"},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 % of co-financing (in row 35, both in column E) applicable for the call. \nThis data can be found on the Portal under Topic Conditions and in the Call document.\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) and the last column of the ‘Proposal Budget’ sheet with the Requested  EU Grant Amount \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.\nFor additional information, please refer to the Annotated Model Grant Agreement."]
[null,null,"Annotaded Grant Agreement in Reference-documents"]
[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\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."]
[]
[]
[null,16,"The amount calculated in the 'BE-WP Overview' sheet of this Excel workbook under the heading 'Maximum EU Grant Amount' must be identical to the             Requested Grant Amount in the “Section 3 - Budget”, in the application form.\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,20,"The format of this Excel workbook is .xlsm because it uses macros.\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 for the EU contribution as stipulated in the call ",":","TYPE HERE THE MAXIMUM EU CONTRIBUTION"]
[null,null,"Maximum cofinancing rate as stipulated in the call",":","TYPE HERE THE 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, …).\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,"Project manager"]
[null,null,"Expert/advisor/trainer"]
[null,null,"Researcher"]
[null,null,"Administrative/financial personnel"]
[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"},"B","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":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[36,14,36,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],[38,14,38,16],[9,13,40,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],[40,14,40,16],[26,15,26,16],[27,15,27,16],[34,14,34,16],[35,15,35,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":41},null,{"$f":"COUNTA(A:A)","v":41},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","XXXXXX","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"},{"$f":"IF($D10=\"\",\"\",VLOOKUP($D10,WPLabels,2,0))","v":"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,0),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,-19,0))*0.07,0),IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"V\",ROUND(OFFSET(T10,0,-2),0)*OFFSET(T10,0,-1),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,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,WPLabels,2,0))","v":"A.1 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,0),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,{"$f":"IF(OFFSET(T11,ROW(T$2)-ROW(T11),0)=\"TT\",\"TT\",IF(OFFSET(T11,0,COLUMN($M11)-COLUMN(T11))=\"%\",ROUND((OFFSET(T11,-2,0)-OFFSET(T11,-19,0))*0.07,0),IF(OFFSET(T11,0,COLUMN($M11)-COLUMN(T11))=\"V\",ROUND(OFFSET(T11,0,-2),0)*OFFSET(T11,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T11,0,COLUMN($B11)-COLUMN(T11)),$A:$A,0),$C11+COLUMN($E11)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T11,0,COLUMN($B11)-COLUMN(T11)),$A:$A,0),$C11+COLUMN($E11)+1),TRUE),INDIRECT(ADDRESS(ROW(T11),$C11+COLUMN($E11)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T11,0,COLUMN($B11)-COLUMN(T11)),$A:$A,0),COLUMN(T11))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T11,0,COLUMN($B11)-COLUMN(T11)),$A:$A,0),COLUMN(T11)),TRUE)))))","v":0},0]
["WP001","WP001",7,"WPRow.C",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE1","v":"Project manager"},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":"Expert/advisor/trainer"},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":"Researcher"},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":"Administrative/financial personnel"},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,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,WPLabels,2,0))","v":"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,{"$f":"IF($D18=\"\",\"\",VLOOKUP($D18,WPLabels,2,0))","v":"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,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,WPLabels,2,0))","v":"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,{"$f":"IF($D20=\"\",\"\",VLOOKUP($D20,WPLabels,2,0))","v":"A.5 Volunteers "},null,null,null,0,0]
["WP001","WP001",4,"WPRow.L",null,null,null,"TTA","TB",null,null,null,"V",null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,WPLabels,2,0))","v":"B. Subcontracting costs"},null,null,null,null,0,0]
["WP001","WP001",4,"WPRow.M",null,null,null,"TTA","TC",null,null,null,"T",null,{"$f":"IF($D22=\"\",\"\",VLOOKUP($D22,WPLabels,2,0))","v":"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,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,WPLabels,2,0))","v":"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,{"$f":"IF($D24=\"\",\"\",VLOOKUP($D24,WPLabels,2,0))","v":"Travel"},null,null,0,0]
["WP001","WP001",7,"WPRow.P",null,null,null,null,null,null,null,"T3","V",null,null,null,{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,WPLabels,2,0))","v":"Accommodation"},null,null,0,0]
["WP001","WP001",7,"WPRow.Q",null,null,null,null,null,null,null,"T3","V",null,null,null,{"$f":"IF($D26=\"\",\"\",VLOOKUP($D26,WPLabels,2,0))","v":"Subsistence"},null,null,0,0]
["WP001","WP001",5,"WPRow.R",null,null,null,null,null,"TC",null,null,"V",null,null,{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,WPLabels,2,0))","v":"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,{"$f":"IF($D28=\"\",\"\",VLOOKUP($D28,WPLabels,2,0))","v":"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,{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,WPLabels,2,0))","v":"Consumables and supplies"},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 (rental of rooms, translations, interpretations, speakers’ fees/trainers)",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 ",null,null,0,0]
["WP001","WP001",7,"WPRow.W",null,null,null,null,null,null,null,"T4","V",null,null,null,"IT services including virtual events software",null,null,0,0]
["WP001","WP001",7,"WPRow.X",null,null,null,null,null,null,null,"T4","V",null,null,null,"Please leave row empty",null,null,0,0]
["WP001","WP001",7,"WPRow.Y",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.Z",null,null,null,"TTA","TD",null,null,null,"T",null,{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,WPLabels,2,0))","v":"D. Other cost categories"},null,null,null,null,0,0]
["WP001","WP001",5,"WPRow.0",null,null,null,null,null,"TD",null,null,"V",null,null,{"$f":"IF($D36=\"\",\"\",VLOOKUP($D36,WPLabels,2,0))","v":"D.1 Financial support to third parties"},null,null,null,0,0]
["WP001","WP001",2,"WPRow.1",null,"GT","TTA",null,null,null,null,null,"T",null,{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,WPLabels,2,0))","v":"TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)"},null,null,null,null,0,0]
["WP001","WP001",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["WP001","WP001",2,"WPRow.2",null,"GT",null,null,null,null,null,null,"%",null,{"$f":"IF($D39=\"\",\"\",VLOOKUP($D39,WPLabels,2,0))","v":"E. Indirect costs 7% (rounded to zero decimals)"},null,null,null,null,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}]
["WP001","WP001",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["ENDWP001","WP001",0,"WPRow.3","GT",null,null,null,null,null,null,null,"T",null,{"$f":"IF($D41=\"\",\"\",VLOOKUP($D41,WPLabels,2,0))","v":"TOTAL COSTS (A+B+C+D+E)"},null,null,null,null,0,{"$f":"IF(OFFSET(U41,ROW(U$2)-ROW(U41),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q41)+1) & \":\" & ADDRESS(2,COLUMN(U41)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U41), COLUMN($Q41)+1) & \":\" & ADDRESS(ROW(U41),COLUMN(U41)-1),TRUE)),IF(OFFSET(U41,ROW(U$2)-ROW(U41),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U41,ROW(U$2)-ROW(U41),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U41)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U41), MATCH(INT(OFFSET(U41,ROW(U$2)-ROW(U41),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U41),COLUMN(U41)-1),TRUE)),IF(OFFSET(U41,0,COLUMN($M41)-COLUMN(U41))=\"V\",OFFSET(U41,0,-2)*OFFSET(U41,0,-1),\"TOTAL\")))","v":0}]

{"sheet":"Estim costs of the project","index":4,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,21,3,21],[3,17,3,19],[6,14,6,16],[8,14,8,16],[9,13,40,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],[40,14,40,16],[2,20,3,20],[38,14,38,16],[2,16,3,16],[2,17,2,19],[26,15,26,16],[27,15,27,16],[34,14,34,16],[35,15,35,16],[36,14,36,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":41},null,{"$f":"COUNTA(A:A)","v":42},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","XXXXXX","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"},{"$f":"IF($D10=\"\",\"\",VLOOKUP($D10,WPLabels,2,0))","v":"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,0),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)*0.07,0),IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"V\",ROUND(OFFSET(T10,0,-2),0)*OFFSET(T10,0,-1),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,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,WPLabels,2,0))","v":"A.1 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,0),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":"Project manager"},{"$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":"Expert/advisor/trainer"},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":"Researcher"},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":"Administrative/financial personnel"},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,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,WPLabels,2,0))","v":"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,{"$f":"IF($D18=\"\",\"\",VLOOKUP($D18,WPLabels,2,0))","v":"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,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,WPLabels,2,0))","v":"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,{"$f":"IF($D20=\"\",\"\",VLOOKUP($D20,WPLabels,2,0))","v":"A.5 Volunteers "},null,0,0,0,0,0]
["WP001","WP001",4,"WPRow.L",null,null,null,"TTA","TB",null,null,null,"V",null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,WPLabels,2,0))","v":"B. Subcontracting costs"},null,null,0,0,0,0,0]
["WP001","WP001",4,"WPRow.M",null,null,null,"TTA","TC",null,null,null,"T",null,{"$f":"IF($D22=\"\",\"\",VLOOKUP($D22,WPLabels,2,0))","v":"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,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,WPLabels,2,0))","v":"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,{"$f":"IF($D24=\"\",\"\",VLOOKUP($D24,WPLabels,2,0))","v":"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,{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,WPLabels,2,0))","v":"Accommodation"},0,0,0,0,0]
["WP001","WP001",7,"WPRow.Q",null,null,null,null,null,null,null,"T3","V",null,null,null,{"$f":"IF($D26=\"\",\"\",VLOOKUP($D26,WPLabels,2,0))","v":"Subsistence"},0,0,0,0,0]
["WP001","WP001",5,"WPRow.R",null,null,null,null,null,"TC",null,null,"V",null,null,{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,WPLabels,2,0))","v":"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,{"$f":"IF($D28=\"\",\"\",VLOOKUP($D28,WPLabels,2,0))","v":"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,{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,WPLabels,2,0))","v":"Consumables and supplies"},{"$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 (rental of rooms, translations, interpretations, speakers’ fees/trainers)",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 ",0,0,0,0,0]
["WP001","WP001",7,"WPRow.W",null,null,null,null,null,null,null,"T4","V",null,null,null,"IT services including virtual events software",0,0,0,0,0]
["WP001","WP001",7,"WPRow.X",null,null,null,null,null,null,null,"T4","V",null,null,null,"Please leave row empty",0,0,0,0,0]
["WP001","WP001",7,"WPRow.Y",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.Z",null,null,null,"TTA","TD",null,null,null,"T",null,{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,WPLabels,2,0))","v":"D. Other cost categories"},null,null,null,null,0,0,0]
["WP001","WP001",5,"WPRow.0",null,null,null,null,null,"TD",null,null,"V",null,null,{"$f":"IF($D36=\"\",\"\",VLOOKUP($D36,WPLabels,2,0))","v":"D.1 Financial support to third parties"},null,{"$f":"INDIRECT(\"'\"& MID(OFFSET(R36,ROW(R$3)-ROW(R36),IF(OFFSET(R36,ROW(R$2)-ROW(R36),2)=\"T\",0,IF(OFFSET(R36,ROW(R$2)-ROW(R36),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R36),MATCH(INDIRECT(ADDRESS(2,COLUMN(R36)+IF(OFFSET(R36,ROW(R$2)-ROW(R36),2)=\"T\",1,IF(OFFSET(R36,ROW(R$2)-ROW(R36),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R36,ROW(R$3)-ROW(R36),IF(OFFSET(R36,ROW(R$2)-ROW(R36),2)=\"T\",0,IF(OFFSET(R36,ROW(R$2)-ROW(R36),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R36,ROW(R$2)-ROW(R36),2)=\"T\",1,IF(OFFSET(R36,ROW(R$2)-ROW(R36),1)=\"T\",0,-1))),TRUE)","v":0},{"$f":"INDIRECT(\"'\"& MID(OFFSET(S36,ROW(S$3)-ROW(S36),IF(OFFSET(S36,ROW(S$2)-ROW(S36),2)=\"T\",0,IF(OFFSET(S36,ROW(S$2)-ROW(S36),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(S36),MATCH(INDIRECT(ADDRESS(2,COLUMN(S36)+IF(OFFSET(S36,ROW(S$2)-ROW(S36),2)=\"T\",1,IF(OFFSET(S36,ROW(S$2)-ROW(S36),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(S36,ROW(S$3)-ROW(S36),IF(OFFSET(S36,ROW(S$2)-ROW(S36),2)=\"T\",0,IF(OFFSET(S36,ROW(S$2)-ROW(S36),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(S36,ROW(S$2)-ROW(S36),2)=\"T\",1,IF(OFFSET(S36,ROW(S$2)-ROW(S36),1)=\"T\",0,-1))),TRUE)","v":0},0,0,0]
["WP001","WP001",2,"WPRow.1",null,"GT","TTA",null,null,null,null,null,"T",null,{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,WPLabels,2,0))","v":"TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)"},null,null,null,null,0,0,0]
["WP001","WP001",1]
["WP001","WP001",2,"WPRow.2",null,"GT",null,null,null,null,null,null,"%",null,{"$f":"IF($D39=\"\",\"\",VLOOKUP($D39,WPLabels,2,0))","v":"E. Indirect costs 7% (rounded to zero decimals)"},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)*0.07,0),IF(OFFSET(T39,0,COLUMN($M39)-COLUMN(T39))=\"V\",ROUND(OFFSET(T39,0,-2),0)*OFFSET(T39,0,-1),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}]
["WP001","WP001",1]
["ENDWP001","WP001",0,"WPRow.3","GT",null,null,null,null,null,null,null,"T",null,{"$f":"IF($D41=\"\",\"\",VLOOKUP($D41,WPLabels,2,0))","v":"TOTAL COSTS (A+B+C+D+E)"},null,null,null,null,{"$f":"IF(OFFSET(T41,ROW(T$2)-ROW(T41),0)=\"TT\",\"TT\",IF(OFFSET(T41,0,COLUMN($M41)-COLUMN(T41))=\"%\",ROUND(OFFSET(T41,-2,0)*0.07,0),IF(OFFSET(T41,0,COLUMN($M41)-COLUMN(T41))=\"V\",ROUND(OFFSET(T41,0,-2),0)*OFFSET(T41,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T41,0,COLUMN($B41)-COLUMN(T41)),$A:$A,0),$C41+COLUMN($E41)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T41,0,COLUMN($B41)-COLUMN(T41)),$A:$A,0),$C41+COLUMN($E41)+1),TRUE),INDIRECT(ADDRESS(ROW(T41),$C41+COLUMN($E41)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T41,0,COLUMN($B41)-COLUMN(T41)),$A:$A,0),COLUMN(T41))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T41,0,COLUMN($B41)-COLUMN(T41)),$A:$A,0),COLUMN(T41)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U41,ROW(U$2)-ROW(U41),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q41)+1) & \":\" & ADDRESS(2,COLUMN(U41)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U41), COLUMN($Q41)+1) & \":\" & ADDRESS(ROW(U41),COLUMN(U41)-1),TRUE)),IF(OFFSET(U41,ROW(U$2)-ROW(U41),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U41,ROW(U$2)-ROW(U41),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U41)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U41), MATCH(INT(OFFSET(U41,ROW(U$2)-ROW(U41),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U41),COLUMN(U41)-1),TRUE)),IF(OFFSET(U41,0,COLUMN($M41)-COLUMN(U41))=\"V\",OFFSET(U41,0,-2)*OFFSET(U41,0,-1),\"TOTAL\")))","v":0},{"$f":"IF(OFFSET(V41,ROW(V$2)-ROW(V41),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q41)+1) & \":\" & ADDRESS(2,COLUMN(V41)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(V41), COLUMN($Q41)+1) & \":\" & ADDRESS(ROW(V41),COLUMN(V41)-1),TRUE)),IF(OFFSET(V41,ROW(V$2)-ROW(V41),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(V41,ROW(V$2)-ROW(V41),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(V41)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(V41), MATCH(INT(OFFSET(V41,ROW(V$2)-ROW(V41),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(V41),COLUMN(V41)-1),TRUE)),IF(OFFSET(V41,0,COLUMN($M41)-COLUMN(V41))=\"V\",OFFSET(V41,0,-2)*OFFSET(V41,0,-1),\"TOTAL\")))","v":0}]
["x"]

{"sheet":"Proposal Budget","index":5,"n_rows":10,"n_cols":41,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,16,5,16],[4,17,6,17],[4,18,6,18],[4,19,5,19],[4,23,5,23],[4,37,6,37],[4,24,5,24],[4,31,6,31],[4,32,5,32],[4,33,6,33],[4,35,6,35],[5,25,5,30],[4,6,6,6],[4,7,5,7],[4,13,5,13],[4,14,5,14],[4,15,5,15]]}
[null,null,"XXXXXX",null,"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX","XXXXXXXXXXXXXXX",999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,999999999.99000001,null,null,null,null,null,null,999999999.99000001,999999999.99000001,999999999.99000001,"XX",999999999.99000001,"XX",999999999.99000001,"XX","XXXXXXXXXXXXXXXXXX","CHECK"]
[null,{"$f":"MATCH(\"HE\",A:A,0)","v":8},{"$f":"MATCH(\"TT\",A:A,0)","v":10},{"$f":"COLUMN(AR3)","v":44},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",null,"WPRow.2",null,"WPRow.3",null,{"$f":"IF((OFFSET(AN2,C2-2,-2)*COFINPERCENT)>IF(MAXSUB=0,OFFSET(AN2,C2-2,-2),MAXSUB),IF(MAXSUB=0,OFFSET(AN2,C2-2,-2),MAXSUB)/OFFSET(AN2,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"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"IF(AND(AL3=0,D3<>\"T\"),\"No budget defined\",ROUND(AL3*AN$2,0))","v":{"$error":"#N/A"}}]
[]
[null,"X\nX\nX\nX\nX\nX\nX\nX\nZ",null,null,"Click here to go to the column\nRequested EU Grant Amount\n",null,{"$f":"IF(G2=\"\",\"\",SUBSTITUTE(VLOOKUP(G2,WPLabels,2,0),VLOOKUP(G2,WPLabels,3,0),VLOOKUP(G2,WPLabels,3,0)&\"\n\"))","v":"A.\n DIRECT PERSONNEL COSTS"},{"$f":"IF(H2=\"\",\"\",SUBSTITUTE(VLOOKUP(H2,WPLabels,2,0),VLOOKUP(H2,WPLabels,3,0),VLOOKUP(H2,WPLabels,3,0)&\"\n\"))","v":"A.1\n Employees (or equivalent) person months"},{"$f":"EMP_TYPE1","v":"Project manager"},{"$f":"EMP_TYPE2","v":"Expert/advisor/trainer"},{"$f":"EMP_TYPE3","v":"Researcher"},{"$f":"EMP_TYPE4","v":"Administrative/financial personnel"},{"$f":"EMP_OTHER","v":"Other"},{"$f":"IF(N2=\"\",\"\",SUBSTITUTE(VLOOKUP(N2,WPLabels,2,0),VLOOKUP(N2,WPLabels,3,0),VLOOKUP(N2,WPLabels,3,0)&\"\n\"))","v":"A.2\n Natural persons under direct contract "},"A.3\n Seconded persons","A.4\n SME Owners without salary","A.5\n Volunteers ","B.\n Subcontracting costs","C.\n Purchase costs","C.1\n Travel and subsistence per travel or  day","Travel","Accommodation","Subsistence","C.2\n Equipment (please refer to the Depreciation Cost sheet)","C.3\n Other goods, works and services","Consumables and supplies","Services for Meetings, Seminars (rental of rooms, translations, interpretations, speakers’ fees/trainers)","Services for communication / promotion / dissemination ","IT services including virtual events software","Please leave row empty","Other (please specify details under worksheet \"Comments\")","D.\n Other cost categories","D.1\n Financial support to third parties","TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING\n (A+B+C+D)",null,{"$f":"IF(AJ2=\"\",\"\",SUBSTITUTE(VLOOKUP(AJ2,WPLabels,2,0),VLOOKUP(AJ2,WPLabels,3,0),VLOOKUP(AJ2,WPLabels,3,0)&\"\n\"))","v":"E.\n Indirect costs 7% (rounded to zero decimals)"},null,{"$f":"IF(AL2=\"\",\"\",SUBSTITUTE(VLOOKUP(AL2,WPLabels,2,0),VLOOKUP(AL2,WPLabels,3,0),VLOOKUP(AL2,WPLabels,3,0)&\"\n\"))","v":"TOTAL COSTS\n (A+B+C+D+E)"},null,{"$f":"\"MAX EU\nCONTRIBUTION\n=\n\n\"&TEXT(COFINPERCENT,\"00 %\")&\"\nof \"&TEXT(INDIRECT(\"AL\"&MATCH(\"TT\",A:A,0),TRUE),\"###.###.##0 €\")&IF(MAXSUB=0,\"\",\"\nor\n\"&TEXT(MAXSUB,\"###.###.###.##0 €\"))","v":"MAX EU\nCONTRIBUTION\n=\n\nTYPE HERE THE CO-FINANCING RATE\nof 0 €\nor\nTYPE HERE THE MAXIMUM EU CONTRIBUTION"}]
[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,{"$f":"IF(AG3=\"\",\"\",SUBSTITUTE(VLOOKUP(AG3,WPLabels,2,0),VLOOKUP(AG3,WPLabels,3,0),VLOOKUP(AG3,WPLabels,3,0)&\"\n\"))","v":{"$error":"#N/A"}}]
[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,"Max 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,null,0,null,0,null,{"$f":"IF(AND(AL9=0,D9<>\"T\"),\"No budget defined\",ROUND(AL9*AN$2,0))","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,null,0,null,0,null,"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($AN1)-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($AN1)-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'!AL\" & 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(D5=\"N/A\",\"\",\"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\",\"\")),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($AN7)-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($AN7)-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($AN7)-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($AN7)-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($AN8)-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($AN8)-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($AN8)-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($AN8)-1),2)))))","v":"No budget defined"}]

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

{"sheet":"BE-WP Person Months","index":8,"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)),INT(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":"#REF!"}}]
[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\",\"\")),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"}]
[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)),INT(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":0},0]
["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"},0,0]

{"sheet":"Operations","index":9,"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":41},{"$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},4,{"$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},2,{"$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":"EGR","index":10,"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":"#REF!"}}]
[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":0},0]
["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"},0,0]

{"sheet":"Depreciation Costs","index":11,"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":12,"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":"Referential","index":13,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Name","Value",null,{"$f":"\"[ Version LUMP SUM II - \" & DG_Programme & \" - v\" & B2 & \"_\" & TEXT(B4,\"000\") & \", of \" & TEXT(DAY(B3),\"00\")&\"/\"&TEXT(MONTH(B3),\"00\") & \"/\"&TEXT(YEAR(B3),\"0000\") & \" \" & TEXT(HOUR(B3),\"00\") & \":\" & TEXT(MINUTE(B3),\"00\")& \" ]\"","v":"[ Version LUMP SUM II - JUST - v1_000, of 25/11/2022 00:00 ]"}]
["CURRENT VERSION",1]
["DATE OF VERSION","2022-11-25"]
["BUILD",0]
["DO NOT CHANGE","ANYTHING BELOW"]
["CurrentFileName","Tpl_Detailed Budget Table (JUST LSII).xlsm"]
["DG/PROGRAMME (for version)","JUST"]
["LastIDBeneficiaire",1,"<init = 1"]
["LastIDWorkPackages",1,"<init = 1"]
["SheetBEBenNumCell",{"$f":"CELL(\"address\",'BE xxx'!N1)","v":"'[detailed-budget-table_just-lsii_en.xlsm]BE xxx'!$N$1"}]
["SheetBEBenCell",{"$f":"CELL(\"address\",'BE xxx'!S2)","v":"'[detailed-budget-table_just-lsii_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'!AN\" & 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,"<init = 1"]
["File Status",1,"<init = 1"]
["Password for workbook","Detailed budget table"]
[]
["Code WorkPackage","Libelle","Structure"]
["WPRow.A","A. DIRECT PERSONNEL COSTS","A."]
["WPRow.B","A.1 Employees (or equivalent) person months","A.1"]
["WPRow.C",{"$f":"EMP_TYPE1","v":"Project manager"}]
["WPRow.D",{"$f":"EMP_TYPE2","v":"Expert/advisor/trainer"}]
["WPRow.E",{"$f":"EMP_TYPE3","v":"Researcher"}]
["WPRow.F",{"$f":"EMP_TYPE4","v":"Administrative/financial personnel"}]
["WPRow.G",{"$f":"EMP_OTHER","v":"Other"}]
["WPRow.H","A.2 Natural persons under direct contract ","A.2"]
["WPRow.I","A.3 Seconded persons","A.3"]
["WPRow.J","A.4 SME Owners without salary","A.4"]
["WPRow.K","A.5 Volunteers ","A.5"]
["WPRow.L","B. Subcontracting costs","B."]
["WPRow.M","C. Purchase costs","C."]
["WPRow.N","C.1 Travel and subsistence per travel or  day","C.1"]
["WPRow.O","Travel"]
["WPRow.P","Accommodation"]
["WPRow.Q","Subsistence"]
["WPRow.R","C.2 Equipment (please refer to the Depreciation Cost sheet)","C.2"]
["WPRow.S","C.3 Other goods, works and services","C.3"]
["WPRow.T","Consumables and supplies"]
["WPRow.U","Services for Meetings, Seminars (rental of rooms, translations, interpretations, speakers’ fees/trainers)"]
["WPRow.V","Services for communication / promotion / dissemination "]
["WPRow.W","IT services including virtual events software"]
["WPRow.X","Please leave row empty"]
["WPRow.Y","Other (please specify details under worksheet \"Comments\")"]
["WPRow.Z","D. Other cost categories","D."]
["WPRow.0","D.1 Financial support to third parties","D.1"]
["WPRow.1","TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)","TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING"]
["WPRow.2","E. Indirect costs 7% (rounded to zero decimals)","E."]
["WPRow.3","TOTAL COSTS (A+B+C+D+E)","TOTAL COSTS"]

{"sheet":"UpdateParameters","index":14,"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 ",100000]
[null,"Cofinancing Percentage",0.8]
["X\nX\nX"]
[null,"Double-Click to apply the changes -->","APPLY CHANGES"]
["X\nX\nX\nX"]
[]
["X\nX\nX"]

{"sheet":"BE xxx","index":15,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":true,"merged":[[36,14,36,16],[8,14,8,16],[9,13,40,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],[38,14,38,16],[40,14,40,16],[26,15,26,16],[27,15,27,16],[34,14,34,16],[2,20,3,20],[35,15,35,16],[3,17,3,19],[2,17,2,19],[2,16,3,16],[22,15,22,16],[6,14,6,16]]}
[0,{"$f":"IF(ISERROR(MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0))","v":"N"},{"$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":"N"},null,{"$f":"COUNTA(A:A)","v":42},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","XXXXXX","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"},{"$f":"IF($D10=\"\",\"\",VLOOKUP($D10,WPLabels,2,0))","v":"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,0),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,-19,0))*0.07,0),IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"V\",ROUND(OFFSET(T10,0,-2),0)*OFFSET(T10,0,-1),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,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,WPLabels,2,0))","v":"A.1 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,0),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":"Project manager"},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":"Expert/advisor/trainer"},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":"Researcher"},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":"Administrative/financial personnel"},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,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,WPLabels,2,0))","v":"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,{"$f":"IF($D18=\"\",\"\",VLOOKUP($D18,WPLabels,2,0))","v":"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,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,WPLabels,2,0))","v":"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,{"$f":"IF($D20=\"\",\"\",VLOOKUP($D20,WPLabels,2,0))","v":"A.5 Volunteers "},null,null,null,{"$f":"IF(OFFSET(T20,ROW(T$2)-ROW(T20),0)=\"TT\",\"TT\",IF(OFFSET(T20,0,COLUMN($M20)-COLUMN(T20))=\"%\",ROUND((OFFSET(T20,-2,0)-OFFSET(T20,-19,0))*0.07,0),IF(OFFSET(T20,0,COLUMN($M20)-COLUMN(T20))=\"V\",ROUND(OFFSET(T20,0,-2),0)*OFFSET(T20,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T20,0,COLUMN($B20)-COLUMN(T20)),$A:$A,0),$C20+COLUMN($E20)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T20,0,COLUMN($B20)-COLUMN(T20)),$A:$A,0),$C20+COLUMN($E20)+1),TRUE),INDIRECT(ADDRESS(ROW(T20),$C20+COLUMN($E20)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T20,0,COLUMN($B20)-COLUMN(T20)),$A:$A,0),COLUMN(T20))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T20,0,COLUMN($B20)-COLUMN(T20)),$A:$A,0),COLUMN(T20)),TRUE)))))","v":0},0]
["WP001","WP001",4,"WPRow.L",null,null,null,"TTA","TB",null,null,null,"V",null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,WPLabels,2,0))","v":"B. Subcontracting costs"},null,null,null,null,{"$f":"IF(OFFSET(T21,ROW(T$2)-ROW(T21),0)=\"TT\",\"TT\",IF(OFFSET(T21,0,COLUMN($M21)-COLUMN(T21))=\"%\",ROUND((OFFSET(T21,-2,0)-OFFSET(T21,-19,0))*0.07,0),IF(OFFSET(T21,0,COLUMN($M21)-COLUMN(T21))=\"V\",ROUND(OFFSET(T21,0,-2),0)*OFFSET(T21,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T21,0,COLUMN($B21)-COLUMN(T21)),$A:$A,0),$C21+COLUMN($E21)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T21,0,COLUMN($B21)-COLUMN(T21)),$A:$A,0),$C21+COLUMN($E21)+1),TRUE),INDIRECT(ADDRESS(ROW(T21),$C21+COLUMN($E21)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T21,0,COLUMN($B21)-COLUMN(T21)),$A:$A,0),COLUMN(T21))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T21,0,COLUMN($B21)-COLUMN(T21)),$A:$A,0),COLUMN(T21)),TRUE)))))","v":0},0]
["WP001","WP001",4,"WPRow.M",null,null,null,"TTA","TC",null,null,null,"T",null,{"$f":"IF($D22=\"\",\"\",VLOOKUP($D22,WPLabels,2,0))","v":"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,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,WPLabels,2,0))","v":"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,{"$f":"IF($D24=\"\",\"\",VLOOKUP($D24,WPLabels,2,0))","v":"Travel"},null,null,0,0]
["WP001","WP001",7,"WPRow.P",null,null,null,null,null,null,null,"T3","V",null,null,null,{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,WPLabels,2,0))","v":"Accommodation"},null,null,0,0]
["WP001","WP001",7,"WPRow.Q",null,null,null,null,null,null,null,"T3","V",null,null,null,{"$f":"IF($D26=\"\",\"\",VLOOKUP($D26,WPLabels,2,0))","v":"Subsistence"},null,null,0,0]
["WP001","WP001",5,"WPRow.R",null,null,null,null,null,"TC",null,null,"V",null,null,{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,WPLabels,2,0))","v":"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,{"$f":"IF($D28=\"\",\"\",VLOOKUP($D28,WPLabels,2,0))","v":"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,{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,WPLabels,2,0))","v":"Consumables and supplies"},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 (rental of rooms, translations, interpretations, speakers’ fees/trainers)",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 ",null,null,0,0]
["WP001","WP001",7,"WPRow.W",null,null,null,null,null,null,null,"T4","V",null,null,null,"IT services including virtual events software",null,null,0,0]
["WP001","WP001",7,"WPRow.X",null,null,null,null,null,null,null,"T4","V",null,null,null,"Please leave row empty",null,null,0,0]
["WP001","WP001",7,"WPRow.Y",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.Z",null,null,null,"TTA","TD",null,null,null,"T",null,{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,WPLabels,2,0))","v":"D. Other cost categories"},null,null,null,null,0,0]
["WP001","WP001",5,"WPRow.0",null,null,null,null,null,"TD",null,null,"V",null,null,{"$f":"IF($D36=\"\",\"\",VLOOKUP($D36,WPLabels,2,0))","v":"D.1 Financial support to third parties"},null,null,null,0,0]
["WP001","WP001",2,"WPRow.1",null,"GT","TTA",null,null,null,null,null,"T",null,{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,WPLabels,2,0))","v":"TOTAL DIRECT COSTS INCLUDING SUBCONTRACTING (A+B+C+D)"},null,null,null,null,0,0]
["WP001","WP001",1]
["WP001","WP001",2,"WPRow.2",null,"GT",null,null,null,null,null,null,"%",null,{"$f":"IF($D39=\"\",\"\",VLOOKUP($D39,WPLabels,2,0))","v":"E. Indirect costs 7% (rounded to zero decimals)"},null,null,null,null,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}]
["WP001","WP001",1]
["ENDWP001","WP001",0,"WPRow.3","GT",null,null,null,null,null,null,null,"T",null,{"$f":"IF($D41=\"\",\"\",VLOOKUP($D41,WPLabels,2,0))","v":"TOTAL COSTS (A+B+C+D+E)"},null,null,null,null,0,{"$f":"IF(OFFSET(U41,ROW(U$2)-ROW(U41),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q41)+1) & \":\" & ADDRESS(2,COLUMN(U41)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U41), COLUMN($Q41)+1) & \":\" & ADDRESS(ROW(U41),COLUMN(U41)-1),TRUE)),IF(OFFSET(U41,ROW(U$2)-ROW(U41),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U41,ROW(U$2)-ROW(U41),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U41)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U41), MATCH(INT(OFFSET(U41,ROW(U$2)-ROW(U41),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U41),COLUMN(U41)-1),TRUE)),IF(OFFSET(U41,0,COLUMN($M41)-COLUMN(U41))=\"V\",OFFSET(U41,0,-2)*OFFSET(U41,0,-1),\"TOTAL\")))","v":0}]
["x"]