{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Instructions","Cost Eligibility Conditions","General Information","Beneficiaries List","Work Packages List","BE 001","Estim costs of the project","Proposal Budget","BE-WP Overview","Country List","BBE-WP Person Months","Operations","EGR","Depreciation Costs","Comments","Referential","UpdateParameters","BE xxx"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":42,"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":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,1,4,3],[5,1,5,3],[6,1,6,4],[43,0,43,2]]}
["XXXX","XXXX",{"$f":"CurrentVersion","v":"[ Version LUMP SUM II - JUST - v1_000, of 20/07/2023 00:00 ]"},null,null,"XXXX"]
[]
[]
[null,"ANNEX 1 to Part B\nDetailed Estimation of Costs for Lump Sums"]
[]
[]
[null,"Instructions"]
[]
[1,null,"This workbook (Detailed Budget Table) enables you to present the detailed estimation of costs of your lump sum project and to calculate the lump sum breakdown per beneficiary and per Work Package (WP). It must be uploaded in the Portal as a mandatory annex to the application.  \nPlease note that if you do not upload the Excel workbook as an annex, the application cannot be submitted (the system will not allow you to submit). This annex is essential for the application assessment process and must be fully and properly completed according to the instructions provided below."]
[2,null,"Please note that the Lump sum scheme is designed in a way that lump sum for a WP will normally be paid only when the entire WP has been completed. Please take this into consideration while structuring your proposal. WPs should be designed in a way that enables   to clearly identify whether the action has been completed.\nThe WPs with a long duration may be split along the reporting periods. In this way, the relevant WPs can be completed and paid at the end of each reporting period. This may be relevant for the cash flow in your project. The effectiveness of the work plan remains essential. The use of lump sum funding should not lead to the subdivision of the project into many small WPs."]
[3,null,"We strongly recommend having a clear plan of the project activities, the structure of the WPs, the costs needed to implement the activities, as well as a clear breakdown of the activities between the Beneficiaries and the Affiliated Entities (if applicable) before starting to fill in the workbook. Please note that any deletion or adjustment of the data already filled in may cause errors in the table."]
[4,null,"We recommend using Excel 2010 or more recent."]
[5,null,"The currency used in this workbook is EURO. "]
[6,null,"You should start filling the workbook from the sheet ‘General information'.\nYou can customize the categories of Employees that correspond to your organization (example: Senior Staff, Junior Staff, Researcher, Expert) in rows 14-18 of sheet ‘General information'."]
[7,null,"After filling the sheet ‘General information’ you have to fill in only the following sheets: ‘Beneficiaries List' – ‘Work Package list’ – ‘BE XXX’ (one sheet per Participating Organization)."]
[8,null,"The information in this workbook must correspond to the information in the application. For example, the list of Beneficiaries and the list of WPs must be the same. It is recommended filling in in this workbook only when you have a clear structure of WPs in the application."]
[9,null,"The sequence of filling Excel sheets: \n1. fill in the sheet 'Beneficiaries list' where you have to enter all participants in the project including Affiliated Entities (if any). In the ‘Beneficiaries list’ you can add as many Beneficiaries and as many Affiliated Entities (if applicable) as you need, but the list must correspond to the list provided in the application.\nTo add Beneficiaries, please double-click on 'Add a Beneficiary'; to add an Affiliated Entity, please, double-click on 'Add an Affiliated Entity'.\n\nNOTE: the costs of associated partners cannot appear in any part of this budget.\n\nTo delete Beneficiary or Affiliated Entity from the ‘Beneficiaries list’, double-click on the ‘Remove this Beneficiary‘/ ‘Remove this Affiliated Entity’ button next to it.\n\n2. fill in the sheet 'Work Packages list', where you must enter all the WPs (copy/enter WPs from Section ‘WORK PACKAGES, DELIVERABLES AND TIMING’ (Part A of the application) in the same order).\nTo add a WP, please double-click on 'Add a Work Package'. \nTo delete a WP, please double-click the 'Remove this Work Package' button next to it."]
[10,null,"Once you have completed the ‘Beneficiaries List' and ‘Work Package list’ sheets, or each time you add or remove a Beneficiary or a WP, 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 workbook is ready to be filled in Beneficiary by Beneficiary  (BE XXX) for all the WPs concerned.\nFor each Beneficiary workbook you have to enter all the related costs of each WP.\n\nThis sheet includes separate sections for the various cost categories (refer to the sheet 'Cost Eligibility Conditions') for each WP 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.\nIf the Beneficiary has an Affiliated Entity, columns for this entity are generated automatically in the ‘BE XXX'. Enter the cost estimations of the Affiliated Entity in the same way as for the main Beneficiary.\n\nUse whole numbers for the costs per unit (no Euro cents). The number of direct personnel cost units can be a fraction (e.g., 0,25 units).\n\n"]
[11,null,"You have to estimate the eligible costs of your project using the same methodology as if these costs were declared under an actual cost-based grant agreement.\nFor additional information on eligible costs, please refer to the Call Conditions and to the sheet ‘Cost Eligibility Conditions’."]
[12,null,"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 (Effort). To calculate the personnel effort, you must add up all the days needed to implement the activities of one WP for each Beneficiary and divide this total by 17,92 (1 year = 215 productive days; 1 month=215 /12 = 17,92 days). 1 unit person/month corresponds to 1-month full time for 1 person.\n\n\n\n\n\n\n\n\n\nIf the application involves staff in different positions with different daily rates, e.g. experts, managers, etc., please indicate the effort of different positions in the draft budget table separately.\n\nA personnel category can contain more than one employee (e.g., two experts in the same organisation and working on the same W P). In this case, the cost per unit is the average monthly personnel cost of all employees concerned, and the number of units is the combined number of person-months. No more detailed information is required in this sheet."]
[13,null,"In section 'B. PURCHASE COSTS', complete the categories 'B.1 Travel and subsistence per travel or day', and 'B.2 Other goods, works and services', if applicable. \n\nA category can contain more than one item (e.g., several travels, or several services). In this case, the cost per unit is the average cost of all items, and the number of units is the number of items. No more detailed information is required in this sheet.\nThe travel information (i.e. number of travels, participants, countries planned, travel duration) should be reflected in the application (WP)."]
[14,null,"Indirect costs will be calculated automatically in each 'BE XXX' sheet."]
[15,null,"The summary tables 'BE-WP Overview', 'Estim costs of the project' will be produced automatically. You do not have to fill anything in these sheets. These sheets will be used while assessing the application."]
[16,null,"The amount calculated in the 'BE-WP Overview' sheet of this workbook under the heading 'Maximum EU Grant Amount' must be identical to the Requested Grant Amount in the application part A 'section 5 - Budget'."]
[17,null,"If you have any comment, you can use the ‘Comments’ sheet.\nThe breakdown of the cost must be specified in the sheet ’Comments’ in the following cases:\n1. If personnel costs are included in the category of employees 'Other' under the category 'A.1 Employees (or equivalent) person months’;\n2. If any costs are included under the category 'B.2 Other goods, works and services';"]

{"sheet":"Cost Eligibility Conditions","index":1,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"         Cost Eligibility Conditions "]
[]
[]
[null,null,null,"1. Cost estimation and eligible cost categories"]
[]
[null,null,null,"To define and justify the lump sum the applicant shall provide a breakdown of the lump sum contributions (a Detailed Budget Table) showing the share per WP and, within each WP, the share assigned to each beneficiary and affiliated entity (if any). A detailed description of the activities covered by each WP and all related resources must be provided in the application.\nThe estimated eligible costs for the project shall be broken down by the following cost categories and for related sub-categories:\n      A. Personnel costs: \n               A.1 Employees (or equivalent) person months\n      B. Purchase costs: \n              B.1 Travel and subsistence per travel or day\n              B.2 Other goods, works and services \n      C. Indirect costs\n\nFollowing the results of the assessment, the overall lump sum will be fixed in the grant agreement. The breakdown of lump sum shares per beneficiary and per WP will be also included in the grant agreement. The Detailed Budget Table will not become part of the lump sum grant agreement, it will be used for cost planning, estimation and determination of lump sums."]
[]
[null,null,null,"2. Eligible and ineligible costs and contributions"]
[]
[null,null,null,"2.1. General eligibility conditions"]
[]
[null,null,null,"Since the Detailed Budget Table (this workbook) serves as the basis for fixing the lump sums for the grants (and since lump sums must be reliable proxies for the actual costs of a project), it may contain only the costs that would be considered eligible for actual costs grant and must exclude ineligible costs. \nIn order to be eligible, costs must: \n− be attributed to the beneficiary and affiliated entity, if any;\n− be related to the duration of the implementation period of the project (except costs relating to the submission of the project’s Final Report);\n− be estimated in eligible cost categories;\n− be connected to the project and necessary for its implementation, i.e. to achieve the project’s objectives; \n− be established in accordance with the beneficiary’s usual cost accounting practices; \n− comply with the applicable national and EU law, accounting and public procurement rules under the applicable national law; \n− be reasonable, justified and must comply with the principle of sound financial management, in particular regarding economy and efficiency. "]
[]
[null,null,null,"2.2. Ineligible costs and contributions"]
[]
[null,null,null,"The following costs or contributions are ineligible:\n1. Costs related to return on capital and dividends paid by the beneficiary;\n2. Debt and debt service charges;\n3. Provisions for future losses or debts;\n4. Interest owed;\n5. Currency exchange losses;\n6. Bank costs charged by the beneficiary’s bank for transfers from the Granting Authority;\n7. Excessive or reckless expenditure;\n8. Deductible or refundable VAT (including VAT paid by public bodies acting as public authority);\n9. Costs incurred or contributions made for the activities implemented during a suspension of the Grant Agreement;\n10. In-kind contributions by third parties;\n11. Any costs incurred before the project start date and after the project end date;\n12. Costs or contributions for personnel of a national (or regional/local) administration, for activities that are part of the administration’s normal activities (i.e., not undertaken only because of the grant).\n\nDouble funding\nThere is a strict prohibition of double funding from the EU budget. Any project may receive only ONE grant from the EU budget and under no circumstances shall the same costs be financed twice by the EU budget."]
[]
[null,null,null,"3. Specific eligibility conditions for each cost category "]
[]
[null,null,null,"3.1. Direct costs "]
[]
[null,null,null,"Direct costs are specific costs that are directly linked to the performance of the project.  The applicant must ensure that the costs that are directly linked to the project do not include costs that are only indirectly linked to the project (see Section Indirect costs). \nFor each direct cost category, specific eligibility conditions are as follows:"]
[]
[null,null,null,"3.1.1 A. Personnel costs "]
[]
[null,null,null,"Personnel costs are eligible  if they: \n   Personnel costs are eligible if they: \n   1. fulfil general eligibility conditions (Section 2); \n   2. are related to the personnel working for the applicant(s) under an employment contract (or an equivalent appointing act); The salary costs should not exceed the average rates corresponding to the applicant's usual policy on remuneration and must be not significantly different from the costs of staff performing similar tasks under an employment contract with the applicant. \n   3. are paid in accordance with national law, the collective labour agreement and the employment contract/equivalent appointing act. \n\nIn this workbook personnel costs must be encoded into person-months. The cost per unit (person-month cost unit) is the average monthly personnel cost of all employees (or employees in the same or similar position) concerned.\nThe average monthly personnel cost is calculated based on the costs actually incurred for a person for the last 12 months of full-time work."]
[]
[null,null,null,"Personnel costs must be limited to gross salaries and other labour-related costs, such as employers’ social security contributions etc., if they arise from the national law or employment contract (or an equivalent appointing act). \nGenerally, for calculating average monthly personnel cost the applicant may include, for each person concerned, the following: \n− fixed salary; \n− fixed complements, if they are unconditional entitlements for the person (e.g. family allowance and contributions to medical insurance schemes set out in national law, complementary pension plan contributions set out in the collective labour agreement); \n− variable complements, e.g. bonuses, if: \n− they are paid based on objective conditions set out, at least, in the internal rules of the applicant; \n− they are paid in a consistent manner, e.g. not just for projects supported by EU grants, and \n− where applicable, subject to the specific eligibility conditions for supplementary payments (see specific cases below); \n− social security contributions (mandatory employer and employee contributions); \n− taxes linked to the remuneration (e.g. income tax withholding); \n− other costs and payments linked to the remuneration if they are justified and registered as personnel costs in accordance with the applicant’s usual remuneration practices (e.g. benefits in kind like company car made available for the private use, lunch vouchers, accrual for unconditional severance payments mandatory under national law). "]
[null,null,null,"The applicant may NOT include: \n− any part of the remuneration which has not been an actual cost for you (for example, salaries reimbursed by a social security scheme or a private insurance in case of long sick leave or maternity leave); \n− payments of dividends to employees (profit distribution in the form of dividends); \n− variable complements based on commercial targets or fund-raising targets (because neither incurred in connection with the work of the project, nor necessary for its implementation); \n− arbitrary bonuses (i.e. bonuses which are not paid based on objective conditions set out, at least, in the internal rules of the beneficiary or bonuses that are not paid in a consistent manner) \n− bonuses that depend on budget availability on the specific project (e.g. paid only if there are remaining funds in the budget of a project). \nThe cost of any work to be performed by external experts must not be included in personnel costs but under purchase costs."]
[]
[null,null,null,"3.1.2 B. Purchase costs "]
[]
[null,null,null,"The implementation of a project may require the buying of goods or services in order to carry out specialised tasks that beneficiaries cannot do themselves (i.e. translations, production of documents, website creation, informatics support, accountancy, catering, expert analysis, research, etc.). Please note that the project management and coordination of activities are core activities and may not be sub-contracted.\nPurchase costs for the project (including related duties, taxes, and charges, such as non- deductible or non-refundable value-added tax (VAT) cover the following sub-categories: \n− B.1 Travel, accommodation and subsistence\n− B.2 Other goods, works or services "]
[null,null,null,"Purchase costs are eligible if they: \n   1. fulfil general eligibility conditions; \n   2. are based either on the best value for money (considering the quality of the service, good or work proposed, i.e. the best price-quality ratio) or on the lowest price; \n   3. are purchased specifically for the project; \n   4. are not subject to conflict of interests. \n\n The applicants are free to choose between best value for money and lowest price. "]
[null,null,null,"The beneficiaries that are “contracting authorities/entities” within the meaning of the EU Directives on public procurement must comply with the applicable national law on public procurement and follow the principles of transparency, non-discrimination, mutual acknowledgement, proportionality, and equal standing when procuring products and services. \nThe beneficiaries that fall outside the scope of the EU Directives on public procurement must follow the principles of transparency, non-discrimination, mutual acknowledgement, proportionality, and equal standing when procuring products and services. \n\nPurchases between beneficiaries are not accepted. No project participant shall be contracted as a service provider neither by the Coordinator, nor by any other project Beneficiary (to avoid any conflict of interest in the procurement of services and goods). Any expenses based on such contracts shall be deemed ineligible."]
[null,null,null,"Costs for travel, accommodation and subsistence must be calculated using unit costs fixed by the authorising Decision C(2021)35. These costs cannot be indicated under any other cost type and category. If a particular instance of travel, accommodation or subsistence in the action is not covered by one of the unit costs mentioned in Decision C(2021)35, actual costs may be used. When unit costs are available, their use is mandatory in line with eligibility criteria. \nThe methodology for calculating of each travel and person travelling is set out in the authorising Decision.","Decision C(2021)35"]
[null,null,null,"All unit costs are an amount to cover a return trip. However, the calculation of the distance should be done on the basis of the 1-way distance between the points. For calculating the distance between two points for rail or air travel, applicants can use distance calculators. \nThe start and end point will normally be the place of employment of the person. ","Distance calculators"]
[null,null,null,"Where the end point of travel is different from the start, the amount to be declared will be the theoretical cost of travelling to the same starting point, unless the different end point is necessary for the implementation of the action. In that case, the unit cost can be calculated using the longer of the distances (e.g. if travel from Dublin – Brussels – Athens is justified for the action, the unit cost to be applied can be calculated on basis of the longer flight from Brussels – Athens). Where the trip involves 3 journeys and is necessary for the implementation of the action (e.g. Madrid – Brussels – Berlin – Madrid), the unit costs can be calculated on the basis of 2 separate return flights: Madrid – Brussels and Berlin – Madrid."]
[null,null,null,"When calculating the accommodation costs, amount per unit depending on country must be multiplied by nights spent on travel:\n\n                                                   amount per unit (depending on country) X nights spent on travel\n"]
[null,null,null,"Subsistence unit costs are for a 24-hour period. The amount of unit costs should be calculated by rounding up or down to the nearest full number of days, except for the first day where any amount of hours will be rounded up to 1 full day. The formula for calculating the subsistence is:\n\n                                                  amount per unit (depending on country) X days spent on travel\n"]
[null,null,null,"If no Beneficiary’s personnel costs are foreseen, no travel, accommodation and subsistence costs can be included for those personnel. \nTravel and subsistence costs may also be eligible for persons that participate in the project on an ad-hoc basis (e.g. attending specific meetings), if this complies with the general and specific eligibility conditions, in particular being necessary for the implementation of the action. "]
[]
[null,null,null," 3.2. C. Indirect costs "]
[]
[null,null,null,"Indirect costs are costs that cannot be identified as specific costs directly linked to the performance of the project. Indirect costs will be calculated automatically by applying a flat rate of 7% to the eligible direct costs that are within the limits of the project budget ceiling. \n\nCosts must be calculated according to the applicable accounting rules of the country in which the applicant is established and according to the applicant’s usual cost accounting practices. If a beneficiary always charges a particular cost as an indirect cost, it must do so also for EU grants, and should not charge it as a direct cost. \n\nTo avoid double funding of the same costs, the applicant may not charge costs which, according to the usual applicant's accounting practice, are indirect costs to direct cost categories."]

{"sheet":"General Information","index":2,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,2,17,3],[0,0,0,4],[10,0,10,4],[11,0,11,4],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3]]}
["FILL IN THE VALUES BELOW BEFORE STARTING:"]
[]
[]
["Call title",":",null,"Social Innovations for the Upskilling of Vulnerable Youth, Especially Young People not in Employment, Education, or Training (NEETs)"]
["Insert the acronym of your application",":"]
["Maximum grant amount for the EU contribution as stipulated in the call ",":",null,200000000]
["Maximum cofinancing rate as stipulated in the call",":",null,0.8]
[]
[]
[]
["You can customize here the categories of Employees that correspond to your organisation (example: Senior Staff, Junior Staff, Expert…).\nPlease, note that this definition is common to all Work Packages for all Beneficiaries.\n"]
["A. DIRECT PERSONNEL COSTS"]
[null,null,null,"A1. Employees (or equivalent) person months (you can change the types based on your structure)"]
[null,null,"Lead project manager"]
[null,null,"Expert/advisor/trainer"]
[null,null,"Researcher"]
[null,null,"Project manager"]
[null,null,"Other"]

{"sheet":"Beneficiaries List","index":3,"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/AE name","Acronym","Country",null,{"$f":"IF(E4=1,\"APPLY CHANGES\",\"All is coherent\")","v":"APPLY CHANGES"},"Add a Beneficiary"]
[{"$f":"IF(J6=INT(J6),\"BE \"&TEXT(J6,\"000\"),\"BE \"&TEXT(INT(J6),\"000\")&\" / AE \"&TEXT((J6-INT(J6))*(10 ^ (LEN(J6)-LEN(INT(J6))-1)),\"000\"))","v":"BE 001"},null,null,null,null,{"$f":"IF(I6=\"D\",\"TO BE REMOVED\",\"Remove this \"&IF(I6=\"B\",\"Beneficiary\",\"Affiliated Entity\"))","v":"Remove this Beneficiary"},{"$f":"IF(I6=\"D\",IF(J6=INT(J6),\"UNDO DELETE this Beneficiary\",IF(OFFSET(I6,INT(-1*(J6-INT(J6))*(10^(LEN(J6)-LEN(INT(J6))-1))),0)=\"D\",\"\",\"UNDO DELETE this Affiliated Entity\")),IF(OR(OFFSET(I6,1,0)=\"T\",OFFSET(I6,1,0)=\"D\"),\"\",\"Add an Affiliated Entity\"))","v":"Add an Affiliated Entity"},"T","B",1,1]

{"sheet":"Work Packages List","index":4,"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 Nr","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":5,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,13,33,13],[9,14,9,16],[10,15,10,16],[16,14,16,16],[17,15,17,16],[21,15,21,16],[29,14,29,16],[31,14,31,16],[33,14,33,16],[8,14,8,16],[2,16,3,16],[2,17,2,19],[2,20,3,20],[3,17,3,19],[6,14,6,16]]}
[1,{"$f":"IF(ISERROR(MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0))","v":9},{"$f":"COUNTIF(E:E,\"GT\")","v":1},{"$f":"IF(ISERROR(MATCH(\"ENDWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"ENDWP\" & TEXT(A1,\"000\"),A:A,0))","v":34},null,{"$f":"COUNTA(A:A)","v":35},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'!C\" & 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))*0.07,2),IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"V\",ROUND(OFFSET(T10,0,-2),2)*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))*0.07,2),IF(OFFSET(T11,0,COLUMN($M11)-COLUMN(T11))=\"V\",ROUND(OFFSET(T11,0,-2),2)*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":"Lead project manager"},null,null,{"$f":"IF(OFFSET(T12,ROW(T$2)-ROW(T12),0)=\"TT\",\"TT\",IF(OFFSET(T12,0,COLUMN($M12)-COLUMN(T12))=\"%\",ROUND((OFFSET(T12,-2,0))*0.07,2),IF(OFFSET(T12,0,COLUMN($M12)-COLUMN(T12))=\"V\",ROUND(OFFSET(T12,0,-2),2)*OFFSET(T12,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T12,0,COLUMN($B12)-COLUMN(T12)),$A:$A,0),$C12+COLUMN($E12)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T12,0,COLUMN($B12)-COLUMN(T12)),$A:$A,0),$C12+COLUMN($E12)+1),TRUE),INDIRECT(ADDRESS(ROW(T12),$C12+COLUMN($E12)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T12,0,COLUMN($B12)-COLUMN(T12)),$A:$A,0),COLUMN(T12))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T12,0,COLUMN($B12)-COLUMN(T12)),$A:$A,0),COLUMN(T12)),TRUE)))))","v":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,{"$f":"IF(OFFSET(T13,ROW(T$2)-ROW(T13),0)=\"TT\",\"TT\",IF(OFFSET(T13,0,COLUMN($M13)-COLUMN(T13))=\"%\",ROUND((OFFSET(T13,-2,0))*0.07,2),IF(OFFSET(T13,0,COLUMN($M13)-COLUMN(T13))=\"V\",ROUND(OFFSET(T13,0,-2),2)*OFFSET(T13,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T13,0,COLUMN($B13)-COLUMN(T13)),$A:$A,0),$C13+COLUMN($E13)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T13,0,COLUMN($B13)-COLUMN(T13)),$A:$A,0),$C13+COLUMN($E13)+1),TRUE),INDIRECT(ADDRESS(ROW(T13),$C13+COLUMN($E13)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T13,0,COLUMN($B13)-COLUMN(T13)),$A:$A,0),COLUMN(T13))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T13,0,COLUMN($B13)-COLUMN(T13)),$A:$A,0),COLUMN(T13)),TRUE)))))","v":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":"Project manager"},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",4,"WPRow.M",null,null,null,"TTA","TC",null,null,null,"T",null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,WPLabels,2,0))","v":"B. Purchase costs"},null,null,null,null,{"$f":"IF(OFFSET(T17,ROW(T$2)-ROW(T17),0)=\"TT\",\"TT\",IF(OFFSET(T17,0,COLUMN($M17)-COLUMN(T17))=\"%\",ROUND((OFFSET(T17,-2,0))*0.07,2),IF(OFFSET(T17,0,COLUMN($M17)-COLUMN(T17))=\"V\",ROUND(OFFSET(T17,0,-2),2)*OFFSET(T17,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T17,0,COLUMN($B17)-COLUMN(T17)),$A:$A,0),$C17+COLUMN($E17)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T17,0,COLUMN($B17)-COLUMN(T17)),$A:$A,0),$C17+COLUMN($E17)+1),TRUE),INDIRECT(ADDRESS(ROW(T17),$C17+COLUMN($E17)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T17,0,COLUMN($B17)-COLUMN(T17)),$A:$A,0),COLUMN(T17))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T17,0,COLUMN($B17)-COLUMN(T17)),$A:$A,0),COLUMN(T17)),TRUE)))))","v":0},0]
["WP001","WP001",6,"WPRow.N",null,null,null,null,null,"TC","T3",null,"T",null,null,{"$f":"IF($D18=\"\",\"\",VLOOKUP($D18,WPLabels,2,0))","v":"B.1 Travel and subsistence per travel or  day"},null,null,null,{"$f":"IF(OFFSET(T18,ROW(T$2)-ROW(T18),0)=\"TT\",\"TT\",IF(OFFSET(T18,0,COLUMN($M18)-COLUMN(T18))=\"%\",ROUND((OFFSET(T18,-2,0))*0.07,2),IF(OFFSET(T18,0,COLUMN($M18)-COLUMN(T18))=\"V\",ROUND(OFFSET(T18,0,-2),2)*OFFSET(T18,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T18,0,COLUMN($B18)-COLUMN(T18)),$A:$A,0),$C18+COLUMN($E18)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T18,0,COLUMN($B18)-COLUMN(T18)),$A:$A,0),$C18+COLUMN($E18)+1),TRUE),INDIRECT(ADDRESS(ROW(T18),$C18+COLUMN($E18)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T18,0,COLUMN($B18)-COLUMN(T18)),$A:$A,0),COLUMN(T18))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T18,0,COLUMN($B18)-COLUMN(T18)),$A:$A,0),COLUMN(T18)),TRUE)))))","v":0},0]
["WP001","WP001",7,"WPRow.O",null,null,null,null,null,null,null,"T3","V",null,null,null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,WPLabels,2,0))","v":"Travel"},null,null,{"$f":"IF(OFFSET(T19,ROW(T$2)-ROW(T19),0)=\"TT\",\"TT\",IF(OFFSET(T19,0,COLUMN($M19)-COLUMN(T19))=\"%\",ROUND((OFFSET(T19,-2,0))*0.07,2),IF(OFFSET(T19,0,COLUMN($M19)-COLUMN(T19))=\"V\",ROUND(OFFSET(T19,0,-2),2)*OFFSET(T19,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T19,0,COLUMN($B19)-COLUMN(T19)),$A:$A,0),$C19+COLUMN($E19)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T19,0,COLUMN($B19)-COLUMN(T19)),$A:$A,0),$C19+COLUMN($E19)+1),TRUE),INDIRECT(ADDRESS(ROW(T19),$C19+COLUMN($E19)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T19,0,COLUMN($B19)-COLUMN(T19)),$A:$A,0),COLUMN(T19))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T19,0,COLUMN($B19)-COLUMN(T19)),$A:$A,0),COLUMN(T19)),TRUE)))))","v":0},0]
["WP001","WP001",7,"WPRow.P",null,null,null,null,null,null,null,"T3","V",null,null,null,{"$f":"IF($D20=\"\",\"\",VLOOKUP($D20,WPLabels,2,0))","v":"Accommodation"},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))*0.07,2),IF(OFFSET(T20,0,COLUMN($M20)-COLUMN(T20))=\"V\",ROUND(OFFSET(T20,0,-2),2)*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",7,"WPRow.Q",null,null,null,null,null,null,null,"T3","V",null,null,null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,WPLabels,2,0))","v":"Subsistence"},null,null,0,0]
["WP001","WP001",6,"WPRow.S",null,null,null,null,null,"TC","T4",null,"T",null,null,{"$f":"IF($D22=\"\",\"\",VLOOKUP($D22,WPLabels,2,0))","v":"B.2 Other goods, works and services"},null,null,null,{"$f":"IF(OFFSET(T22,ROW(T$2)-ROW(T22),0)=\"TT\",\"TT\",IF(OFFSET(T22,0,COLUMN($M22)-COLUMN(T22))=\"%\",ROUND((OFFSET(T22,-2,0))*0.07,2),IF(OFFSET(T22,0,COLUMN($M22)-COLUMN(T22))=\"V\",ROUND(OFFSET(T22,0,-2),2)*OFFSET(T22,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T22,0,COLUMN($B22)-COLUMN(T22)),$A:$A,0),$C22+COLUMN($E22)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T22,0,COLUMN($B22)-COLUMN(T22)),$A:$A,0),$C22+COLUMN($E22)+1),TRUE),INDIRECT(ADDRESS(ROW(T22),$C22+COLUMN($E22)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T22,0,COLUMN($B22)-COLUMN(T22)),$A:$A,0),COLUMN(T22))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T22,0,COLUMN($B22)-COLUMN(T22)),$A:$A,0),COLUMN(T22)),TRUE)))))","v":0},0]
["WP001","WP001",7,"WPRow.T",null,null,null,null,null,null,null,"T4","V",null,null,null,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,WPLabels,2,0))","v":"Consumables and supplies"},null,null,{"$f":"IF(OFFSET(T23,ROW(T$2)-ROW(T23),0)=\"TT\",\"TT\",IF(OFFSET(T23,0,COLUMN($M23)-COLUMN(T23))=\"%\",ROUND((OFFSET(T23,-2,0))*0.07,2),IF(OFFSET(T23,0,COLUMN($M23)-COLUMN(T23))=\"V\",ROUND(OFFSET(T23,0,-2),2)*OFFSET(T23,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T23,0,COLUMN($B23)-COLUMN(T23)),$A:$A,0),$C23+COLUMN($E23)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T23,0,COLUMN($B23)-COLUMN(T23)),$A:$A,0),$C23+COLUMN($E23)+1),TRUE),INDIRECT(ADDRESS(ROW(T23),$C23+COLUMN($E23)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T23,0,COLUMN($B23)-COLUMN(T23)),$A:$A,0),COLUMN(T23))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T23,0,COLUMN($B23)-COLUMN(T23)),$A:$A,0),COLUMN(T23)),TRUE)))))","v":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,{"$f":"IF(OFFSET(T24,ROW(T$2)-ROW(T24),0)=\"TT\",\"TT\",IF(OFFSET(T24,0,COLUMN($M24)-COLUMN(T24))=\"%\",ROUND((OFFSET(T24,-2,0))*0.07,2),IF(OFFSET(T24,0,COLUMN($M24)-COLUMN(T24))=\"V\",ROUND(OFFSET(T24,0,-2),2)*OFFSET(T24,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T24,0,COLUMN($B24)-COLUMN(T24)),$A:$A,0),$C24+COLUMN($E24)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T24,0,COLUMN($B24)-COLUMN(T24)),$A:$A,0),$C24+COLUMN($E24)+1),TRUE),INDIRECT(ADDRESS(ROW(T24),$C24+COLUMN($E24)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T24,0,COLUMN($B24)-COLUMN(T24)),$A:$A,0),COLUMN(T24))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T24,0,COLUMN($B24)-COLUMN(T24)),$A:$A,0),COLUMN(T24)),TRUE)))))","v":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,"Expert services",null,null,0,0]
["WP001","WP001",7,"WPRow.W1",null,null,null,null,null,null,null,"T4","V",null,null,null,"Research, evaluation and studies",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",null,null,0,0]
["WP001","WP001",2,"WPRow.1",null,"GT","TTA",null,null,null,null,null,"T",null,{"$f":"IF($D30=\"\",\"\",VLOOKUP($D30,WPLabels,2,0))","v":"TOTAL DIRECT COSTS (A+B)"},null,null,null,null,{"$f":"IF(OFFSET(T30,ROW(T$2)-ROW(T30),0)=\"TT\",\"TT\",IF(OFFSET(T30,0,COLUMN($M30)-COLUMN(T30))=\"%\",ROUND((OFFSET(T30,-2,0))*0.07,2),IF(OFFSET(T30,0,COLUMN($M30)-COLUMN(T30))=\"V\",ROUND(OFFSET(T30,0,-2),2)*OFFSET(T30,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),$C30+COLUMN($E30)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),$C30+COLUMN($E30)+1),TRUE),INDIRECT(ADDRESS(ROW(T30),$C30+COLUMN($E30)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),COLUMN(T30))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),COLUMN(T30)),TRUE)))))","v":0},0]
["WP001","WP001",1]
["WP001","WP001",2,"WPRow.2",null,"GT",null,null,null,null,null,null,"%",null,{"$f":"IF($D32=\"\",\"\",VLOOKUP($D32,WPLabels,2,0))","v":"C. Indirect costs 7% (rounded to zero decimals)"},null,null,null,null,{"$f":"IF(OFFSET(T32,ROW(T$2)-ROW(T32),0)=\"TT\",\"TT\",IF(OFFSET(T32,0,COLUMN($M32)-COLUMN(T32))=\"%\",ROUND((OFFSET(T32,-2,0))*0.07,2),IF(OFFSET(T32,0,COLUMN($M32)-COLUMN(T32))=\"V\",ROUND(OFFSET(T32,0,-2),2)*OFFSET(T32,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),$C32+COLUMN($E32)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),$C32+COLUMN($E32)+1),TRUE),INDIRECT(ADDRESS(ROW(T32),$C32+COLUMN($E32)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),COLUMN(T32))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),COLUMN(T32)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U32,ROW(U$2)-ROW(U32),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q32)+1) & \":\" & ADDRESS(2,COLUMN(U32)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U32), COLUMN($Q32)+1) & \":\" & ADDRESS(ROW(U32),COLUMN(U32)-1),TRUE)),IF(OFFSET(U32,ROW(U$2)-ROW(U32),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U32,ROW(U$2)-ROW(U32),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U32)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U32), MATCH(INT(OFFSET(U32,ROW(U$2)-ROW(U32),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U32),COLUMN(U32)-1),TRUE)),IF(OFFSET(U32,0,COLUMN($M32)-COLUMN(U32))=\"V\",OFFSET(U32,0,-2)*OFFSET(U32,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($D34=\"\",\"\",VLOOKUP($D34,WPLabels,2,0))","v":"TOTAL COSTS (A+B+C)"},null,null,null,null,{"$f":"IF(OFFSET(T34,ROW(T$2)-ROW(T34),0)=\"TT\",\"TT\",IF(OFFSET(T34,0,COLUMN($M34)-COLUMN(T34))=\"%\",ROUND((OFFSET(T34,-2,0))*0.07,2),IF(OFFSET(T34,0,COLUMN($M34)-COLUMN(T34))=\"V\",ROUND(OFFSET(T34,0,-2),2)*OFFSET(T34,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),$C34+COLUMN($E34)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),$C34+COLUMN($E34)+1),TRUE),INDIRECT(ADDRESS(ROW(T34),$C34+COLUMN($E34)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),COLUMN(T34))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),COLUMN(T34)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U34,ROW(U$2)-ROW(U34),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q34)+1) & \":\" & ADDRESS(2,COLUMN(U34)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U34), COLUMN($Q34)+1) & \":\" & ADDRESS(ROW(U34),COLUMN(U34)-1),TRUE)),IF(OFFSET(U34,ROW(U$2)-ROW(U34),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U34,ROW(U$2)-ROW(U34),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U34)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U34), MATCH(INT(OFFSET(U34,ROW(U$2)-ROW(U34),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U34),COLUMN(U34)-1),TRUE)),IF(OFFSET(U34,0,COLUMN($M34)-COLUMN(U34))=\"V\",OFFSET(U34,0,-2)*OFFSET(U34,0,-1),\"TOTAL\")))","v":0}]
["x"]

{"sheet":"Estim costs of the project","index":6,"n_rows":35,"n_cols":22,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,13,33,13],[9,14,9,16],[10,15,10,16],[16,14,16,16],[17,15,17,16],[21,15,21,16],[29,14,29,16],[31,14,31,16],[33,14,33,16],[8,14,8,16],[2,20,3,20],[2,16,3,16],[2,17,2,19],[2,21,3,21],[3,17,3,19],[6,14,6,16]]}
[1,{"$f":"IF(ISERROR(MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"STARTWP\" & TEXT(A1,\"000\"),A:A,0))","v":9},{"$f":"COUNTIF(E:E,\"GT\")","v":1},{"$f":"IF(ISERROR(MATCH(\"ENDWP\" & TEXT(A1,\"000\"),A:A,0)),\"N\",MATCH(\"ENDWP\" & TEXT(A1,\"000\"),A:A,0))","v":34},null,{"$f":"COUNTA(A:A)","v":35},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)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'!C\" & 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)-OFFSET(T10,-19,0))*0.07,2),IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"V\",ROUND(OFFSET(T10,0,-2),2)*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},{"$f":"INDIRECT(\"'\"& MID(OFFSET(S11,ROW(S$3)-ROW(S11),IF(OFFSET(S11,ROW(S$2)-ROW(S11),2)=\"T\",0,IF(OFFSET(S11,ROW(S$2)-ROW(S11),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(S11),MATCH(INDIRECT(ADDRESS(2,COLUMN(S11)+IF(OFFSET(S11,ROW(S$2)-ROW(S11),2)=\"T\",1,IF(OFFSET(S11,ROW(S$2)-ROW(S11),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(S11,ROW(S$3)-ROW(S11),IF(OFFSET(S11,ROW(S$2)-ROW(S11),2)=\"T\",0,IF(OFFSET(S11,ROW(S$2)-ROW(S11),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(S11,ROW(S$2)-ROW(S11),2)=\"T\",1,IF(OFFSET(S11,ROW(S$2)-ROW(S11),1)=\"T\",0,-1))),TRUE)","v":0},0,0,0]
["WP001","WP001",7,"WPRow.C",null,null,null,null,null,null,null,"T1","V",null,null,null,{"$f":"EMP_TYPE1","v":"Lead 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"},{"$f":"INDIRECT(\"'\"& MID(OFFSET(R13,ROW(R$3)-ROW(R13),IF(OFFSET(R13,ROW(R$2)-ROW(R13),2)=\"T\",0,IF(OFFSET(R13,ROW(R$2)-ROW(R13),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R13),MATCH(INDIRECT(ADDRESS(2,COLUMN(R13)+IF(OFFSET(R13,ROW(R$2)-ROW(R13),2)=\"T\",1,IF(OFFSET(R13,ROW(R$2)-ROW(R13),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R13,ROW(R$3)-ROW(R13),IF(OFFSET(R13,ROW(R$2)-ROW(R13),2)=\"T\",0,IF(OFFSET(R13,ROW(R$2)-ROW(R13),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R13,ROW(R$2)-ROW(R13),2)=\"T\",1,IF(OFFSET(R13,ROW(R$2)-ROW(R13),1)=\"T\",0,-1))),TRUE)","v":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"},{"$f":"INDIRECT(\"'\"& MID(OFFSET(R14,ROW(R$3)-ROW(R14),IF(OFFSET(R14,ROW(R$2)-ROW(R14),2)=\"T\",0,IF(OFFSET(R14,ROW(R$2)-ROW(R14),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R14),MATCH(INDIRECT(ADDRESS(2,COLUMN(R14)+IF(OFFSET(R14,ROW(R$2)-ROW(R14),2)=\"T\",1,IF(OFFSET(R14,ROW(R$2)-ROW(R14),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R14,ROW(R$3)-ROW(R14),IF(OFFSET(R14,ROW(R$2)-ROW(R14),2)=\"T\",0,IF(OFFSET(R14,ROW(R$2)-ROW(R14),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R14,ROW(R$2)-ROW(R14),2)=\"T\",1,IF(OFFSET(R14,ROW(R$2)-ROW(R14),1)=\"T\",0,-1))),TRUE)","v":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":"Project manager"},{"$f":"INDIRECT(\"'\"& MID(OFFSET(R15,ROW(R$3)-ROW(R15),IF(OFFSET(R15,ROW(R$2)-ROW(R15),2)=\"T\",0,IF(OFFSET(R15,ROW(R$2)-ROW(R15),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R15),MATCH(INDIRECT(ADDRESS(2,COLUMN(R15)+IF(OFFSET(R15,ROW(R$2)-ROW(R15),2)=\"T\",1,IF(OFFSET(R15,ROW(R$2)-ROW(R15),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R15,ROW(R$3)-ROW(R15),IF(OFFSET(R15,ROW(R$2)-ROW(R15),2)=\"T\",0,IF(OFFSET(R15,ROW(R$2)-ROW(R15),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R15,ROW(R$2)-ROW(R15),2)=\"T\",1,IF(OFFSET(R15,ROW(R$2)-ROW(R15),1)=\"T\",0,-1))),TRUE)","v":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"},{"$f":"INDIRECT(\"'\"& MID(OFFSET(R16,ROW(R$3)-ROW(R16),IF(OFFSET(R16,ROW(R$2)-ROW(R16),2)=\"T\",0,IF(OFFSET(R16,ROW(R$2)-ROW(R16),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R16),MATCH(INDIRECT(ADDRESS(2,COLUMN(R16)+IF(OFFSET(R16,ROW(R$2)-ROW(R16),2)=\"T\",1,IF(OFFSET(R16,ROW(R$2)-ROW(R16),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R16,ROW(R$3)-ROW(R16),IF(OFFSET(R16,ROW(R$2)-ROW(R16),2)=\"T\",0,IF(OFFSET(R16,ROW(R$2)-ROW(R16),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R16,ROW(R$2)-ROW(R16),2)=\"T\",1,IF(OFFSET(R16,ROW(R$2)-ROW(R16),1)=\"T\",0,-1))),TRUE)","v":0},0,0,0,0]
["WP001","WP001",4,"WPRow.M",null,null,null,"TTA","TC",null,null,null,"T",null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,WPLabels,2,0))","v":"B. 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($D18=\"\",\"\",VLOOKUP($D18,WPLabels,2,0))","v":"B.1 Travel and subsistence per travel or  day"},null,null,{"$f":"INDIRECT(\"'\"& MID(OFFSET(S18,ROW(S$3)-ROW(S18),IF(OFFSET(S18,ROW(S$2)-ROW(S18),2)=\"T\",0,IF(OFFSET(S18,ROW(S$2)-ROW(S18),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(S18),MATCH(INDIRECT(ADDRESS(2,COLUMN(S18)+IF(OFFSET(S18,ROW(S$2)-ROW(S18),2)=\"T\",1,IF(OFFSET(S18,ROW(S$2)-ROW(S18),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(S18,ROW(S$3)-ROW(S18),IF(OFFSET(S18,ROW(S$2)-ROW(S18),2)=\"T\",0,IF(OFFSET(S18,ROW(S$2)-ROW(S18),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(S18,ROW(S$2)-ROW(S18),2)=\"T\",1,IF(OFFSET(S18,ROW(S$2)-ROW(S18),1)=\"T\",0,-1))),TRUE)","v":0},0,0,0]
["WP001","WP001",7,"WPRow.O",null,null,null,null,null,null,null,"T3","V",null,null,null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,WPLabels,2,0))","v":"Travel"},{"$f":"INDIRECT(\"'\"& MID(OFFSET(R19,ROW(R$3)-ROW(R19),IF(OFFSET(R19,ROW(R$2)-ROW(R19),2)=\"T\",0,IF(OFFSET(R19,ROW(R$2)-ROW(R19),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R19),MATCH(INDIRECT(ADDRESS(2,COLUMN(R19)+IF(OFFSET(R19,ROW(R$2)-ROW(R19),2)=\"T\",1,IF(OFFSET(R19,ROW(R$2)-ROW(R19),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R19,ROW(R$3)-ROW(R19),IF(OFFSET(R19,ROW(R$2)-ROW(R19),2)=\"T\",0,IF(OFFSET(R19,ROW(R$2)-ROW(R19),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R19,ROW(R$2)-ROW(R19),2)=\"T\",1,IF(OFFSET(R19,ROW(R$2)-ROW(R19),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($D20=\"\",\"\",VLOOKUP($D20,WPLabels,2,0))","v":"Accommodation"},{"$f":"INDIRECT(\"'\"& MID(OFFSET(R20,ROW(R$3)-ROW(R20),IF(OFFSET(R20,ROW(R$2)-ROW(R20),2)=\"T\",0,IF(OFFSET(R20,ROW(R$2)-ROW(R20),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R20),MATCH(INDIRECT(ADDRESS(2,COLUMN(R20)+IF(OFFSET(R20,ROW(R$2)-ROW(R20),2)=\"T\",1,IF(OFFSET(R20,ROW(R$2)-ROW(R20),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R20,ROW(R$3)-ROW(R20),IF(OFFSET(R20,ROW(R$2)-ROW(R20),2)=\"T\",0,IF(OFFSET(R20,ROW(R$2)-ROW(R20),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R20,ROW(R$2)-ROW(R20),2)=\"T\",1,IF(OFFSET(R20,ROW(R$2)-ROW(R20),1)=\"T\",0,-1))),TRUE)","v":0},0,0,0,0]
["WP001","WP001",7,"WPRow.Q",null,null,null,null,null,null,null,"T3","V",null,null,null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,WPLabels,2,0))","v":"Subsistence"},{"$f":"INDIRECT(\"'\"& MID(OFFSET(R21,ROW(R$3)-ROW(R21),IF(OFFSET(R21,ROW(R$2)-ROW(R21),2)=\"T\",0,IF(OFFSET(R21,ROW(R$2)-ROW(R21),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R21),MATCH(INDIRECT(ADDRESS(2,COLUMN(R21)+IF(OFFSET(R21,ROW(R$2)-ROW(R21),2)=\"T\",1,IF(OFFSET(R21,ROW(R$2)-ROW(R21),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R21,ROW(R$3)-ROW(R21),IF(OFFSET(R21,ROW(R$2)-ROW(R21),2)=\"T\",0,IF(OFFSET(R21,ROW(R$2)-ROW(R21),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R21,ROW(R$2)-ROW(R21),2)=\"T\",1,IF(OFFSET(R21,ROW(R$2)-ROW(R21),1)=\"T\",0,-1))),TRUE)","v":0},0,0,0,0]
["WP001","WP001",6,"WPRow.S",null,null,null,null,null,"TC","T4",null,"T",null,null,{"$f":"IF($D22=\"\",\"\",VLOOKUP($D22,WPLabels,2,0))","v":"B.2 Other goods, works and services"},null,null,0,0,0,0]
["WP001","WP001",7,"WPRow.T",null,null,null,null,null,null,null,"T4","V",null,null,null,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,WPLabels,2,0))","v":"Consumables and supplies"},{"$f":"INDIRECT(\"'\"& MID(OFFSET(R23,ROW(R$3)-ROW(R23),IF(OFFSET(R23,ROW(R$2)-ROW(R23),2)=\"T\",0,IF(OFFSET(R23,ROW(R$2)-ROW(R23),1)=\"T\",-1,-2))),1,6) & \"'!\" & ADDRESS(ROW(R23),MATCH(INDIRECT(ADDRESS(2,COLUMN(R23)+IF(OFFSET(R23,ROW(R$2)-ROW(R23),2)=\"T\",1,IF(OFFSET(R23,ROW(R$2)-ROW(R23),1)=\"T\",0,-1))),TRUE),INDIRECT(\"'\"& MID(OFFSET(R23,ROW(R$3)-ROW(R23),IF(OFFSET(R23,ROW(R$2)-ROW(R23),2)=\"T\",0,IF(OFFSET(R23,ROW(R$2)-ROW(R23),1)=\"T\",-1,-2))),1,6) & \"'!2:2\",TRUE),0)-IF(OFFSET(R23,ROW(R$2)-ROW(R23),2)=\"T\",1,IF(OFFSET(R23,ROW(R$2)-ROW(R23),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,{"$f":"IF(OFFSET(T25,ROW(T$2)-ROW(T25),0)=\"TT\",\"TT\",IF(OFFSET(T25,0,COLUMN($M25)-COLUMN(T25))=\"%\",ROUND((OFFSET(T25,-2,0)-OFFSET(T25,-19,0))*0.07,2),IF(OFFSET(T25,0,COLUMN($M25)-COLUMN(T25))=\"V\",ROUND(OFFSET(T25,0,-2),2)*OFFSET(T25,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T25,0,COLUMN($B25)-COLUMN(T25)),$A:$A,0),$C25+COLUMN($E25)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T25,0,COLUMN($B25)-COLUMN(T25)),$A:$A,0),$C25+COLUMN($E25)+1),TRUE),INDIRECT(ADDRESS(ROW(T25),$C25+COLUMN($E25)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T25,0,COLUMN($B25)-COLUMN(T25)),$A:$A,0),COLUMN(T25))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T25,0,COLUMN($B25)-COLUMN(T25)),$A:$A,0),COLUMN(T25)),TRUE)))))","v":0},0,0]
["WP001","WP001",7,"WPRow.W",null,null,null,null,null,null,null,"T4","V",null,null,null,"Expert services",0,0,0,0,0]
["WP001","WP001",7,"WPRow.W1",null,null,null,null,null,null,null,"T4","V",null,null,null,"Research, evaluation and studies",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",0,0,0,0,0]
["WP001","WP001",2,"WPRow.1",null,"GT","TTA",null,null,null,null,null,"T",null,{"$f":"IF($D30=\"\",\"\",VLOOKUP($D30,WPLabels,2,0))","v":"TOTAL DIRECT COSTS (A+B)"},null,null,null,null,{"$f":"IF(OFFSET(T30,ROW(T$2)-ROW(T30),0)=\"TT\",\"TT\",IF(OFFSET(T30,0,COLUMN($M30)-COLUMN(T30))=\"%\",ROUND((OFFSET(T30,-2,0)-OFFSET(T30,-19,0))*0.07,2),IF(OFFSET(T30,0,COLUMN($M30)-COLUMN(T30))=\"V\",ROUND(OFFSET(T30,0,-2),2)*OFFSET(T30,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),$C30+COLUMN($E30)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),$C30+COLUMN($E30)+1),TRUE),INDIRECT(ADDRESS(ROW(T30),$C30+COLUMN($E30)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),COLUMN(T30))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),COLUMN(T30)),TRUE)))))","v":0},0,0]
["WP001","WP001",1]
["WP001","WP001",2,"WPRow.2",null,"GT",null,null,null,null,null,null,"%",null,{"$f":"IF($D32=\"\",\"\",VLOOKUP($D32,WPLabels,2,0))","v":"C. Indirect costs 7% (rounded to zero decimals)"},null,null,null,null,{"$f":"IF(OFFSET(T32,ROW(T$2)-ROW(T32),0)=\"TT\",\"TT\",IF(OFFSET(T32,0,COLUMN($M32)-COLUMN(T32))=\"%\",ROUND((OFFSET(T32,-2,0)-OFFSET(T32,-19,0))*0.07,2),IF(OFFSET(T32,0,COLUMN($M32)-COLUMN(T32))=\"V\",ROUND(OFFSET(T32,0,-2),2)*OFFSET(T32,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),$C32+COLUMN($E32)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),$C32+COLUMN($E32)+1),TRUE),INDIRECT(ADDRESS(ROW(T32),$C32+COLUMN($E32)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),COLUMN(T32))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),COLUMN(T32)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U32,ROW(U$2)-ROW(U32),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q32)+1) & \":\" & ADDRESS(2,COLUMN(U32)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U32), COLUMN($Q32)+1) & \":\" & ADDRESS(ROW(U32),COLUMN(U32)-1),TRUE)),IF(OFFSET(U32,ROW(U$2)-ROW(U32),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U32,ROW(U$2)-ROW(U32),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U32)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U32), MATCH(INT(OFFSET(U32,ROW(U$2)-ROW(U32),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U32),COLUMN(U32)-1),TRUE)),IF(OFFSET(U32,0,COLUMN($M32)-COLUMN(U32))=\"V\",OFFSET(U32,0,-2)*OFFSET(U32,0,-1),\"TOTAL\")))","v":0},{"$f":"IF(OFFSET(V32,ROW(V$2)-ROW(V32),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q32)+1) & \":\" & ADDRESS(2,COLUMN(V32)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(V32), COLUMN($Q32)+1) & \":\" & ADDRESS(ROW(V32),COLUMN(V32)-1),TRUE)),IF(OFFSET(V32,ROW(V$2)-ROW(V32),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(V32,ROW(V$2)-ROW(V32),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(V32)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(V32), MATCH(INT(OFFSET(V32,ROW(V$2)-ROW(V32),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(V32),COLUMN(V32)-1),TRUE)),IF(OFFSET(V32,0,COLUMN($M32)-COLUMN(V32))=\"V\",OFFSET(V32,0,-2)*OFFSET(V32,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($D34=\"\",\"\",VLOOKUP($D34,WPLabels,2,0))","v":"TOTAL COSTS (A+B+C)"},null,null,null,null,{"$f":"IF(OFFSET(T34,ROW(T$2)-ROW(T34),0)=\"TT\",\"TT\",IF(OFFSET(T34,0,COLUMN($M34)-COLUMN(T34))=\"%\",ROUND((OFFSET(T34,-2,0)-OFFSET(T34,-19,0))*0.07,2),IF(OFFSET(T34,0,COLUMN($M34)-COLUMN(T34))=\"V\",ROUND(OFFSET(T34,0,-2),2)*OFFSET(T34,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),$C34+COLUMN($E34)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),$C34+COLUMN($E34)+1),TRUE),INDIRECT(ADDRESS(ROW(T34),$C34+COLUMN($E34)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),COLUMN(T34))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),COLUMN(T34)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U34,ROW(U$2)-ROW(U34),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q34)+1) & \":\" & ADDRESS(2,COLUMN(U34)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U34), COLUMN($Q34)+1) & \":\" & ADDRESS(ROW(U34),COLUMN(U34)-1),TRUE)),IF(OFFSET(U34,ROW(U$2)-ROW(U34),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U34,ROW(U$2)-ROW(U34),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U34)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U34), MATCH(INT(OFFSET(U34,ROW(U$2)-ROW(U34),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U34),COLUMN(U34)-1),TRUE)),IF(OFFSET(U34,0,COLUMN($M34)-COLUMN(U34))=\"V\",OFFSET(U34,0,-2)*OFFSET(U34,0,-1),\"TOTAL\")))","v":0},{"$f":"IF(OFFSET(V34,ROW(V$2)-ROW(V34),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q34)+1) & \":\" & ADDRESS(2,COLUMN(V34)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(V34), COLUMN($Q34)+1) & \":\" & ADDRESS(ROW(V34),COLUMN(V34)-1),TRUE)),IF(OFFSET(V34,ROW(V$2)-ROW(V34),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(V34,ROW(V$2)-ROW(V34),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(V34)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(V34), MATCH(INT(OFFSET(V34,ROW(V$2)-ROW(V34),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(V34),COLUMN(V34)-1),TRUE)),IF(OFFSET(V34,0,COLUMN($M34)-COLUMN(V34))=\"V\",OFFSET(V34,0,-2)*OFFSET(V34,0,-1),\"TOTAL\")))","v":0}]
["x"]

{"sheet":"Proposal Budget","index":7,"n_rows":10,"n_cols":34,"rows_kept":10,"cut":false,"hidden":true,"merged":[[4,6,6,6],[4,7,5,7],[4,13,6,13],[4,14,5,14],[4,30,6,30],[4,18,5,18],[4,26,6,26],[4,28,6,28],[5,19,5,25]]}
[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,null,null,null,null,null,null,null,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(AK3)","v":37},null,null,"WPRow.A","WPRow.B","WPRow.C","WPRow.D","WPRow.E","WPRow.F","WPRow.G","WPRow.M","WPRow.N","WPRow.O","WPRow.P","WPRow.Q","WPRow.S","WPRow.T","WPRow.U","WPRow.V","WPRow.W","WPRow.W1","WPRow.X","WPRow.Y","WPRow.1",null,"WPRow.2",null,"WPRow.3",null,{"$f":"IF((OFFSET(AG2,C2-2,-2)*COFINPERCENT)>IF(MAXSUB=0,OFFSET(AG2,C2-2,-2),MAXSUB),IF(MAXSUB=0,OFFSET(AG2,C2-2,-2),MAXSUB)/OFFSET(AG2,C2-2,-2),COFINPERCENT)","v":0.8}]
[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"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"IF(AND(AE3=0,D3<>\"T\"),\"No budget defined\",ROUND(AE3*AG$2,0))","v":{"$error":"#N/A"}}]
[]
[null,"X\nX\nX\nX\nX\nX\nX\nX\nZ",null,null,null,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":"Lead project manager"},{"$f":"EMP_TYPE2","v":"Expert/advisor/trainer"},{"$f":"EMP_TYPE3","v":"Researcher"},{"$f":"EMP_TYPE4","v":"Project manager"},{"$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":"B.\n Purchase costs"},"B.1\n Travel and subsistence per travel or  day","Travel","Accommodation","Subsistence","B.2\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 ",{"$f":"IF(W2=\"\",\"\",SUBSTITUTE(VLOOKUP(W2,WPLabels,2,0),VLOOKUP(W2,WPLabels,3,0),VLOOKUP(W2,WPLabels,3,0)&\"\n\"))","v":"Expert services"},"Research, evaluation and studies","Please leave row empty","Other","TOTAL DIRECT COSTS\n (A+B)",null,{"$f":"IF(AC2=\"\",\"\",SUBSTITUTE(VLOOKUP(AC2,WPLabels,2,0),VLOOKUP(AC2,WPLabels,3,0),VLOOKUP(AC2,WPLabels,3,0)&\"\n\"))","v":"C.\n Indirect costs 7% (rounded to zero decimals)"},null,{"$f":"IF(AE2=\"\",\"\",SUBSTITUTE(VLOOKUP(AE2,WPLabels,2,0),VLOOKUP(AE2,WPLabels,3,0),VLOOKUP(AE2,WPLabels,3,0)&\"\n\"))","v":"TOTAL COSTS\n (A+B+C)"},null,{"$f":"\"MAX EU\nCONTRIBUTION\n=\n\"&TEXT(COFINPERCENT,\"0,00%\")&\"\nof \"&TEXT(INDIRECT(\"Ae\"&MATCH(\"TT\",A:A,0),TRUE),\"###.###.##0 €\")&IF(MAXSUB=0,\"\",\"\"\n)","v":"MAX EU\nCONTRIBUTION\n=\n80,00%\nof ..0 €"}]
[null,"X\nX"]
[null,"X\nX",null,null,"BE/AE name","BE/AE name acronym",null,null,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,null,0,null,0,null,{"$f":"IF(AND(AE9=0,D9<>\"T\"),\"No budget defined\",ROUND(AE9*AG$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,null,0,null,0,null,{"$f":"IF(AND(AE10=0,D10<>\"T\"),\"No budget defined\",ROUND(AE10*AG$2,0))","v":"No budget defined"}]

{"sheet":"BE-WP Overview","index":8,"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":"ROUNDDOWN(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($AG1)-1),0)=0,0,ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",E1),TRUE),0) / ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(E1,0,EGR!$D$3-COLUMN(E1))),TRUE),0) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A1,'Proposal Budget'!$A:$A,0)-1,COLUMN($AG1)-1),0))))),0)","v":{"$error":"#N/A"}}]
[null,null,"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",999999999,999999999.99000001,999999999.99000001]
[null,{"$f":"ADDRESS(E3,COLUMN(C1))","v":"$C$7"},{"$f":"MATCH(\"TT\",A:A,0)","v":8},{"$f":"MATCH(\"TT\",4:4,0)","v":6},{"$f":"MATCH(\"HE\",A:A,0)+1","v":7}]
[null,null,"O",{"$f":"INDIRECT(\"'Proposal Budget'!Ag\" & MATCH(\"TT\",'Proposal Budget'!A:A,0),TRUE)","v":"No budget defined"},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\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":"ROUNDDOWN(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),0) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A7,'Proposal Budget'!$A:$A,0)-1,COLUMN($AG7)-1),0)=0,0,ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",E7),TRUE),0) / ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(E7,0,EGR!$D$3-COLUMN(E7))),TRUE),0) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A7,'Proposal Budget'!$A:$A,0)-1,COLUMN($AG7)-1),0))))),0)","v":{"$error":"#VALUE!"}},{"$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),0) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A7,'Proposal Budget'!$A:$A,0)-1,COLUMN($AG7)-1),0)=0,0,ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",F7),TRUE),0) / ROUND(INDIRECT(\"EGR!\"&CELL(\"address\",OFFSET(F7,0,EGR!$D$3-COLUMN(F7))),TRUE),0) * ROUND(OFFSET(INDIRECT(\"'Proposal Budget'!A1\",TRUE),MATCH($A7,'Proposal Budget'!$A:$A,0)-1,COLUMN($AG7)-1),0)))))","v":{"$error":"#VALUE!"}}]
["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":"ROUNDDOWN(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($AG8)-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($AG8)-1),2))))),0)","v":{"$error":"#VALUE!"}},{"$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($AG8)-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($AG8)-1),2)))))","v":{"$error":"#VALUE!"}}]

{"sheet":"Country List","index":9,"n_rows":248,"n_cols":3,"rows_kept":248,"cut":false,"hidden":true,"merged":[[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],[246,0,247,0],[185,0,216,0],[217,0,230,0],[231,0,238,0],[239,0,242,0],[243,0,244,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":"BBE-WP Person Months","index":10,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"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"]
["HE","X\nX\nX","BE NR/AE","Acronym",{"$f":"IF(OFFSET(E6,-2,0)=\"TT\",IF($C4=\"O\",\"Maximum\nGrant\nAmount\",IF($C4=\"PM\",\"Total\nfor project\",\"\")),INDIRECT(\"'Work Packages List'!A\" & MATCH(OFFSET(E6,-2,0),'Work Packages List'!$J:$J,0),TRUE) & \"\n\" & INDIRECT(\"'Work Packages List'!B\" & MATCH(OFFSET(E6,-2,0),'Work Packages List'!$J:$J,0),TRUE))","v":"WP 001\n"},{"$f":"IF(OFFSET(F6,-2,0)=\"TT\",IF($C4=\"O\",\"Maximum\nGrant\nAmount\",IF($C4=\"PM\",\"Total\nfor project\",\"\")),INDIRECT(\"'Work Packages List'!A\" & MATCH(OFFSET(F6,-2,0),'Work Packages List'!$J:$J,0),TRUE) & \"\n\" & INDIRECT(\"'Work Packages List'!B\" & MATCH(OFFSET(F6,-2,0),'Work Packages List'!$J:$J,0),TRUE))","v":"Total\nfor project"}]
[1,{"$f":"IF(OFFSET(B7,-1,-1)=\"HE\",1,IF(OFFSET(B7,0,-1)=\"TT\",3,IF(OFFSET(B7,-1,0)=1,2,1)))","v":1},{"$f":"IF(OFFSET(C7,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A7,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"IF(OFFSET(C7,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A7,'Beneficiaries List'!J:J,0),TRUE))","v":""},{"$f":"IF(OFFSET(E7,ROW(E$4)-ROW(E7),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(E7),COLUMN($D7)+1)&\":\"&ADDRESS(ROW(E7),COLUMN(E7)-1),TRUE)),IF($A7=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(E7))&\":\"&ADDRESS(ROW(E7)-1,COLUMN(E7)),TRUE)),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":11,"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":34},{"$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":"Update from BENEFICIARIES LIST"},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},4,{"$f":"OFFSET(C7,0,D$19)","v":"Update from WORK PACKAGES LIST"},null,null,2,"Update from WORK PACKAGES LIST",null,"CONVERT TO .XLSX"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C9,0,D$19)=\"\",\"\",H9)","v":3},4,{"$f":"OFFSET(C9,0,D$19)","v":"Update DETAILED SUMMARY TABLE"},null,null,3,"Update DETAILED SUMMARY TABLE"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C11,0,D$19)=\"\",\"\",H11)","v":4},4,{"$f":"OFFSET(C11,0,D$19)","v":"Update BE-WP Person Months"},null,null,4,"Update BE-WP Person Months"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C13,0,D$19)=\"\",\"\",H13)","v":5},4,{"$f":"OFFSET(C13,0,D$19)","v":"Update TECHNICAL CALCULATIONS"},null,null,5,"Update TECHNICAL CALCULATIONS"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C15,0,D$19)=\"\",\"\",H15)","v":6},4,{"$f":"OFFSET(C15,0,D$19)","v":"Update PROPOSAL BUDGET"},null,null,6,"Update PROPOSAL BUDGET"]
[]
["X\nX",null,{"$f":"IF(OFFSET(C17,0,D$19)=\"\",\"\",H17)","v":7},4,{"$f":"OFFSET(C17,0,D$19)","v":"Update BE-WP Overview"},null,null,7,"Update BE-WP Overview"]
[]
["X\nX",null,"BW",{"$f":"MATCH(C19,4:4,0)-3","v":6}]

{"sheet":"EGR","index":12,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"IF(OFFSET(B1,-1,-1)=\"HE\",1,IF(OFFSET(B1,0,-1)=\"TT\",3,IF(OFFSET(B1,-1,0)=1,2,1)))","v":{"$error":"#REF!"}},{"$f":"IF(OFFSET(C1,0,-2)=\"TT\",\"TOTAL\",\"\"&INDIRECT(\"'Beneficiaries List'!B\" & MATCH(A1,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(C1,0,-2)=\"TT\",\"Consortium\",\"\"&INDIRECT(\"'Beneficiaries List'!C\" & MATCH(A1,'Beneficiaries List'!J:J,0),TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(E1,ROW(E$4)-ROW(E1),0)=\"TT\",SUM(INDIRECT(ADDRESS(ROW(E1),COLUMN($D1)+1) & \":\" & ADDRESS(ROW(E1),COLUMN(E1)-1),TRUE)),IF($A1=\"TT\",SUM(INDIRECT(ADDRESS(MATCH(\"HE\",$A:$A,0)+1,COLUMN(E1))&\":\"&ADDRESS(ROW(E1)-1,COLUMN(E1)),TRUE)),INDIRECT(CELL(\"address\",OFFSET(INDIRECT(\"'BE \" & TEXT(INT($A1),\"000\") & \"'!A1\",TRUE),MATCH(\"ENDWP\" & TEXT(OFFSET(E1,ROW(E$4)-ROW(E1),0),\"000\"),INDIRECT(\"'BE \" & TEXT(INT($A1),\"000\") & \"'!A:A\",TRUE),0)-1,MATCH($A1,INDIRECT(\"'BE \" & TEXT(INT($A1),\"000\") & \"'!2:2\",TRUE),0))),TRUE)))","v":{"$error":"#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":13,"n_rows":210,"n_cols":12,"rows_kept":210,"cut":false,"hidden":true,"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":"Comments","index":14,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["COMMENTS"]
[]
["nr","BE ref","WP ref","Comments"]

{"sheet":"Referential","index":15,"n_rows":44,"n_cols":4,"rows_kept":44,"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 20/07/2023 00:00 ]"}]
["CURRENT VERSION",1]
["DATE OF VERSION","2023-07-20"]
["BUILD",0]
["DO NOT CHANGE","ANYTHING BELOW"]
["CurrentFileName","Detailed_Budget_Table_SI+_Ls_2024-02-07_SKKILS.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_SI+_Ls_2024-02-07_SKKILS.xlsm]BE xxx'!$N$1"}]
["SheetBEBenCell",{"$f":"CELL(\"address\",'BE xxx'!S2)","v":"'[Detailed_Budget_Table_SI+_Ls_2024-02-07_SKKILS.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'!Ag\" & 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":"Lead project manager"}]
["WPRow.D",{"$f":"EMP_TYPE2","v":"Expert/advisor/trainer"}]
["WPRow.E",{"$f":"EMP_TYPE3","v":"Researcher"}]
["WPRow.F",{"$f":"EMP_TYPE4","v":"Project manager"}]
["WPRow.G",{"$f":"EMP_OTHER","v":"Other"}]
["WPRow.M","B. Purchase costs","B."]
["WPRow.N","B.1 Travel and subsistence per travel or  day","B.1"]
["WPRow.O","Travel"]
["WPRow.P","Accommodation"]
["WPRow.Q","Subsistence"]
["WPRow.S","B.2 Other goods, works and services","B.2"]
["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","Expert services"]
["WPRow.W1","Research, evaluation and studies"]
["WPRow.X","Please leave row empty"]
["WPRow.Y","Other"]
["WPRow.1","TOTAL DIRECT COSTS (A+B)","TOTAL DIRECT COSTS"]
["WPRow.2","C. Indirect costs 7% (rounded to zero decimals)","C."]
["WPRow.3","TOTAL COSTS (A+B+C)","TOTAL COSTS"]

{"sheet":"UpdateParameters","index":16,"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":17,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":true,"merged":[[2,20,3,20],[3,17,3,19],[2,17,2,19],[2,16,3,16],[17,15,17,16],[6,14,6,16],[29,14,29,16],[8,14,8,16],[9,13,33,13],[9,14,9,16],[10,15,10,16],[16,14,16,16],[31,14,31,16],[33,14,33,16],[21,15,21,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":35},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'!C\" & 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))*0.07,2),IF(OFFSET(T10,0,COLUMN($M10)-COLUMN(T10))=\"V\",ROUND(OFFSET(T10,0,-2),2)*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))*0.07,2),IF(OFFSET(T11,0,COLUMN($M11)-COLUMN(T11))=\"V\",ROUND(OFFSET(T11,0,-2),2)*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":"Lead project manager"},null,null,{"$f":"IF(OFFSET(T12,ROW(T$2)-ROW(T12),0)=\"TT\",\"TT\",IF(OFFSET(T12,0,COLUMN($M12)-COLUMN(T12))=\"%\",ROUND((OFFSET(T12,-2,0))*0.07,2),IF(OFFSET(T12,0,COLUMN($M12)-COLUMN(T12))=\"V\",ROUND(OFFSET(T12,0,-2),2)*OFFSET(T12,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T12,0,COLUMN($B12)-COLUMN(T12)),$A:$A,0),$C12+COLUMN($E12)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T12,0,COLUMN($B12)-COLUMN(T12)),$A:$A,0),$C12+COLUMN($E12)+1),TRUE),INDIRECT(ADDRESS(ROW(T12),$C12+COLUMN($E12)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T12,0,COLUMN($B12)-COLUMN(T12)),$A:$A,0),COLUMN(T12))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T12,0,COLUMN($B12)-COLUMN(T12)),$A:$A,0),COLUMN(T12)),TRUE)))))","v":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,{"$f":"IF(OFFSET(T13,ROW(T$2)-ROW(T13),0)=\"TT\",\"TT\",IF(OFFSET(T13,0,COLUMN($M13)-COLUMN(T13))=\"%\",ROUND((OFFSET(T13,-2,0))*0.07,2),IF(OFFSET(T13,0,COLUMN($M13)-COLUMN(T13))=\"V\",ROUND(OFFSET(T13,0,-2),2)*OFFSET(T13,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T13,0,COLUMN($B13)-COLUMN(T13)),$A:$A,0),$C13+COLUMN($E13)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T13,0,COLUMN($B13)-COLUMN(T13)),$A:$A,0),$C13+COLUMN($E13)+1),TRUE),INDIRECT(ADDRESS(ROW(T13),$C13+COLUMN($E13)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T13,0,COLUMN($B13)-COLUMN(T13)),$A:$A,0),COLUMN(T13))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T13,0,COLUMN($B13)-COLUMN(T13)),$A:$A,0),COLUMN(T13)),TRUE)))))","v":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":"Project manager"},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",4,"WPRow.M",null,null,null,"TTA","TC",null,null,null,"T",null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,WPLabels,2,0))","v":"B. Purchase costs"},null,null,null,null,{"$f":"IF(OFFSET(T17,ROW(T$2)-ROW(T17),0)=\"TT\",\"TT\",IF(OFFSET(T17,0,COLUMN($M17)-COLUMN(T17))=\"%\",ROUND((OFFSET(T17,-2,0))*0.07,2),IF(OFFSET(T17,0,COLUMN($M17)-COLUMN(T17))=\"V\",ROUND(OFFSET(T17,0,-2),2)*OFFSET(T17,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T17,0,COLUMN($B17)-COLUMN(T17)),$A:$A,0),$C17+COLUMN($E17)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T17,0,COLUMN($B17)-COLUMN(T17)),$A:$A,0),$C17+COLUMN($E17)+1),TRUE),INDIRECT(ADDRESS(ROW(T17),$C17+COLUMN($E17)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T17,0,COLUMN($B17)-COLUMN(T17)),$A:$A,0),COLUMN(T17))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T17,0,COLUMN($B17)-COLUMN(T17)),$A:$A,0),COLUMN(T17)),TRUE)))))","v":0},0]
["WP001","WP001",6,"WPRow.N",null,null,null,null,null,"TC","T3",null,"T",null,null,{"$f":"IF($D18=\"\",\"\",VLOOKUP($D18,WPLabels,2,0))","v":"B.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($D19=\"\",\"\",VLOOKUP($D19,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($D20=\"\",\"\",VLOOKUP($D20,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($D21=\"\",\"\",VLOOKUP($D21,WPLabels,2,0))","v":"Subsistence"},null,null,0,0]
["WP001","WP001",6,"WPRow.S",null,null,null,null,null,"TC","T4",null,"T",null,null,{"$f":"IF($D22=\"\",\"\",VLOOKUP($D22,WPLabels,2,0))","v":"B.2 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($D23=\"\",\"\",VLOOKUP($D23,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,{"$f":"IF(OFFSET(T24,ROW(T$2)-ROW(T24),0)=\"TT\",\"TT\",IF(OFFSET(T24,0,COLUMN($M24)-COLUMN(T24))=\"%\",ROUND((OFFSET(T24,-2,0))*0.07,2),IF(OFFSET(T24,0,COLUMN($M24)-COLUMN(T24))=\"V\",ROUND(OFFSET(T24,0,-2),2)*OFFSET(T24,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T24,0,COLUMN($B24)-COLUMN(T24)),$A:$A,0),$C24+COLUMN($E24)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T24,0,COLUMN($B24)-COLUMN(T24)),$A:$A,0),$C24+COLUMN($E24)+1),TRUE),INDIRECT(ADDRESS(ROW(T24),$C24+COLUMN($E24)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T24,0,COLUMN($B24)-COLUMN(T24)),$A:$A,0),COLUMN(T24))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T24,0,COLUMN($B24)-COLUMN(T24)),$A:$A,0),COLUMN(T24)),TRUE)))))","v":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,"Expert services",null,null,0,0]
["WP001","WP001",7,"WPRow.W1",null,null,null,null,null,null,null,"T4","V",null,null,null,"Research, evaluation and studies",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",null,null,0,0]
["WP001","WP001",2,"WPRow.1",null,"GT","TTA",null,null,null,null,null,"T",null,{"$f":"IF($D30=\"\",\"\",VLOOKUP($D30,WPLabels,2,0))","v":"TOTAL DIRECT COSTS (A+B)"},null,null,null,null,{"$f":"IF(OFFSET(T30,ROW(T$2)-ROW(T30),0)=\"TT\",\"TT\",IF(OFFSET(T30,0,COLUMN($M30)-COLUMN(T30))=\"%\",ROUND((OFFSET(T30,-2,0))*0.07,2),IF(OFFSET(T30,0,COLUMN($M30)-COLUMN(T30))=\"V\",ROUND(OFFSET(T30,0,-2),2)*OFFSET(T30,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),$C30+COLUMN($E30)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),$C30+COLUMN($E30)+1),TRUE),INDIRECT(ADDRESS(ROW(T30),$C30+COLUMN($E30)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),COLUMN(T30))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T30,0,COLUMN($B30)-COLUMN(T30)),$A:$A,0),COLUMN(T30)),TRUE)))))","v":0},0]
["WP001","WP001",1]
["WP001","WP001",2,"WPRow.2",null,"GT",null,null,null,null,null,null,"%",null,{"$f":"IF($D32=\"\",\"\",VLOOKUP($D32,WPLabels,2,0))","v":"C. Indirect costs 7% (rounded to zero decimals)"},null,null,null,null,{"$f":"IF(OFFSET(T32,ROW(T$2)-ROW(T32),0)=\"TT\",\"TT\",IF(OFFSET(T32,0,COLUMN($M32)-COLUMN(T32))=\"%\",ROUND((OFFSET(T32,-2,0))*0.07,2),IF(OFFSET(T32,0,COLUMN($M32)-COLUMN(T32))=\"V\",ROUND(OFFSET(T32,0,-2),2)*OFFSET(T32,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),$C32+COLUMN($E32)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),$C32+COLUMN($E32)+1),TRUE),INDIRECT(ADDRESS(ROW(T32),$C32+COLUMN($E32)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),COLUMN(T32))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T32,0,COLUMN($B32)-COLUMN(T32)),$A:$A,0),COLUMN(T32)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U32,ROW(U$2)-ROW(U32),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q32)+1) & \":\" & ADDRESS(2,COLUMN(U32)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U32), COLUMN($Q32)+1) & \":\" & ADDRESS(ROW(U32),COLUMN(U32)-1),TRUE)),IF(OFFSET(U32,ROW(U$2)-ROW(U32),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U32,ROW(U$2)-ROW(U32),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U32)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U32), MATCH(INT(OFFSET(U32,ROW(U$2)-ROW(U32),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U32),COLUMN(U32)-1),TRUE)),IF(OFFSET(U32,0,COLUMN($M32)-COLUMN(U32))=\"V\",OFFSET(U32,0,-2)*OFFSET(U32,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($D34=\"\",\"\",VLOOKUP($D34,WPLabels,2,0))","v":"TOTAL COSTS (A+B+C)"},null,null,null,null,{"$f":"IF(OFFSET(T34,ROW(T$2)-ROW(T34),0)=\"TT\",\"TT\",IF(OFFSET(T34,0,COLUMN($M34)-COLUMN(T34))=\"%\",ROUND((OFFSET(T34,-2,0))*0.07,2),IF(OFFSET(T34,0,COLUMN($M34)-COLUMN(T34))=\"V\",ROUND(OFFSET(T34,0,-2),2)*OFFSET(T34,0,-1),SUMIF(INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),$C34+COLUMN($E34)+1)&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),$C34+COLUMN($E34)+1),TRUE),INDIRECT(ADDRESS(ROW(T34),$C34+COLUMN($E34)),TRUE),INDIRECT(ADDRESS(MATCH(\"START\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),COLUMN(T34))&\":\"&ADDRESS(MATCH(\"END\"&OFFSET(T34,0,COLUMN($B34)-COLUMN(T34)),$A:$A,0),COLUMN(T34)),TRUE)))))","v":0},{"$f":"IF(OFFSET(U34,ROW(U$2)-ROW(U34),0)=\"TT\",SUMIF(INDIRECT(ADDRESS(2,COLUMN($Q34)+1) & \":\" & ADDRESS(2,COLUMN(U34)-1),TRUE),\"TBE\",INDIRECT(ADDRESS(ROW(U34), COLUMN($Q34)+1) & \":\" & ADDRESS(ROW(U34),COLUMN(U34)-1),TRUE)),IF(OFFSET(U34,ROW(U$2)-ROW(U34),0)=\"TBE\",SUMIF(INDIRECT(ADDRESS(2,MATCH(INT(OFFSET(U34,ROW(U$2)-ROW(U34),-2)),$2:$2,0)) & \":\" & ADDRESS(2,COLUMN(U34)-1),TRUE),\"T\",INDIRECT(ADDRESS(ROW(U34), MATCH(INT(OFFSET(U34,ROW(U$2)-ROW(U34),-2)),$2:$2,0)) & \":\" & ADDRESS(ROW(U34),COLUMN(U34)-1),TRUE)),IF(OFFSET(U34,0,COLUMN($M34)-COLUMN(U34))=\"V\",OFFSET(U34,0,-2)*OFFSET(U34,0,-1),\"TOTAL\")))","v":0}]
["x"]