{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["INSTRUCTIONS","Call & Topic","CallsList","TopicsList","Participants","Eligible countries","Activities & WP","Memory","Indirect costs","A2 template - 1","A2 template - 2","A1 template","Eligible activities","PESCO","History of changes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":43,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[20,1,21,1],[14,1,14,3],[0,1,0,3],[6,1,6,3],[7,1,7,3],[2,1,2,3],[12,1,12,3],[8,1,8,3],[10,1,10,3],[4,1,4,2]]}
["v1.00\nJune 2021","EUROPEAN DEFENCE FUND"]
[]
[null,"This 'macro-enabled' excel file is designed to generate Annex 1 and Annex 2 to the Submission form in a user friendly way.\nMake sure you save this file on your computer and enable the macros in order to use the file properly."]
[]
[null,"In case you encounter any issue with the use of this file, please contact us at :",null,"DEFIS-EDF-proposals@ec.europa.eu "]
[]
[null,"Annex 1 aims at providing all the necessary information for:\n- the calculation of the applicable increase in the funding rate (so-called \"bonus\"). This is only relevant for Development actions.\n- the partial assessment of the award criterion 5. This is relevant for both Research actions and Development actions.\nIn addition, for the calls leading to actions implemented through \"actual costs\", Annex 1 is also designed to inform about subcontracting costs in more details."]
[null,"Annex 2 aims at providing all the necessary budget information for each beneficiary and, if any, for each affiliated entity and associated partner."]
[null,"The layout of Annex 1 and Annex 2 depends on various parameters, the first of which being the type of call you are applying for: \"thematic calls\" leading to actions implemented through \"actual costs\"* grants or \"open calls\" leading to actions implemented through \"lump sums\"* grants. The layout also depends on the \"Research\" or \"Development\" nature of the calls. The type and nature of each call is mentioned in the document Call texts and conditions for the calls and is also reminded for convenience in the sheet \"Call & Topic\" once you have selected a call."]
[]
[null,"* this only applies to the direct costs, without prejudice to the choice by each applicant of the applicable regime for its indirect costs (see the sheet \"Indirect costs\" and the relevant section of the Guide for applicants)."]
[]
[null,"In order to generate and complete the right layout for Annex 1 and right Annex 2, you will need to follow carefully the following steps."]
[]
[null,"Step 1: you need to provide the general information requested in the sheets \"Call & Topic\", \"Participants\", \"Activities & WP\", \"Indirect costs\" and \"PESCO\". Only coloured cells need to be filled in. Once you have provided this information, you need to press the button \"End of Step 1\" below."]
[null,"\nIf you are applying for a call \nwhich actions will be implemented through \"actual costs\" grants\n\n\n",null,"\nIf you are applying for a call \nwhich actions will be implemented through \"lump sums\" grants\n                                                       \n                                                      EDF-2021-OPEN-RDIS\n                                                 EDF-2021-OPEN-R\n                                                  EDF-2021-OPEN-D\n\n\n\n\n\n"]
[null,"Step 2: New sheets should have been generated: \n- one sheet \"A2 - Summary per activity\"; \n- one sheet \"A2 - Summary per applicant\"; \n- sheets named \"A1 - [activity x]\" and \"A1 - Summary award\".\nYou are requested to provide cost information in each of the blue cells of the sheets which have a blue tab. All other white cells and sheets are automatically filled in based on the information provided during Step 1 and in the blue cells of Step 2.\n\nOnce you have finished, you need to press the button \"Validation and Export\": this will perform a final consistency and completeness check and save the entire Workbook in your active folder both as  Excel files (with and without macros) and as a PDF file. All files will be named \"[topic ID]_[acronym of proposal]_[timestamp]_An1&2\". You will need to provide the xls and pdf files with your application.",null,"Step 2: New sheets should have been generated: \n- one detailed sheet per beneficiary; \n- one detailed sheet per affiliated entity (if any); \n- one simplified sheet per associated partner (if any). \nCorresponding sheets have been automatically labelled \"A2 - [short name of the participant]\". These sheets constitute the first part of the Annex 2 to the Submisison form. \nYou are requested to provide the cost details for each beneficiary and, if any, each affiliated entity, using the detailed sheets generated. You are also requested to provide cost estimates for the associated partners, if any. These costs details need to be provided per work package. Only cells coloured in blue need to be filled in. \n\nOnce you have provided this information, you need to press the button \"End of Step 2\" below. "]
[]
[]
[]
[null,"Important information: if you need to modify any of the information listed below, you will need to press again the button \"End of Step 1\", otherwise the generated sheets will not be up-to-date. Other information can still be modified without impact.\nSheet \"Call & Topic\": reference to the call and/or to the topic you are applying for.\nSheet \"Participants\": deletion and/or addition of participants and/or modification of shortname and/or of PIC number and/or place of establishment and/or size of the entity.\nSheet \"Activities & WP\": deletion and/or addition of work packages and/or change in corresponding activity.\nSheet \"Indirect costs\": regime for the indirect costs of any beneficiary or affiliated entity.\n\nThe information listed below can be modified without the need to repress the button \"End of Step 1\".\nSheet \"Call & Topic\": acronym of your proposal. \nSheet \"Participants\": name of the participants.\nSheet \"Activities & WP\": name of the work packages.\nSheet \"PESCO\": answer(s) to the question(s).",null,"Step 3: New sheets should have been generated:\n- one sheet \"A2 - Summary per WP\";\n- one sheet \"A2 - Summary per activity\"; \n- one sheet \"A2 - Summary per applicant\"; \n- sheets named \"A1 - [activity x]\" and \"A1 - Summary award\".\nThese budget summary sheets consitute the second part of the Annex 2 to the Submission form. \nYou need to provide additional information only in the blue cells of the sheet \"A2 - Summary per WP\". All other white cells and sheets are automatically filled in based on the information provided during Step 1 and in the blue cells of Step 2.\n\nOnce you have finished, you need to press the button \"Validation and Export\": this will perform a final consistency and completeness check and save the entire Workbook in your active folder as Excel files (with and without macros) and as a PDF file. All files will be named \"[topic ID]_[acronym of proposal]_[timestamp]_An1&2\". You will need to provide the xls and pdf files with your application."]
[]
[]
[null,null,null,"Important information 1: if you are in Step 2 or in Step 3 and you need to modify any of the information listed below, you will need to press again the button \"End of Step 1\", otherwise the generated sheets will not be up-to-date. You will then be back to Step 2. Other information can still be modified without impact. "]
[null,null,null,"Sheet \"Call & Topic\": reference to the call you are applying for (unless it is implemented through lump sums as well).\nSheet \"Participants\": deletion and/or addition of participants and/or modification of shortname and/or of PIC number.\nSheet \"Activities & WP\": deletion and/or addition of work packages."]
[]
[null,null,null,"Important information 2: if you are in Step 3 and you need to modify any of the information listed below, you will need to press again the button \"End of Step 2\", otherwise the generated sheets will not be up-to-date. You will then be back to Step 3."]
[null,null,null,"Sheet \"Participants\": country of establishment and/or status of the entity.\nSheets \"A2 - [short name of the participant]\": information in sections \"C. DIRECT COSTS FOR SUBCONTRACTING\", with the exception of the \"description of tasks subcontracted\"."]
[]
[null,null,null,"Important information 3: The information listed below can be modified at any Step without the need to repress any button."]
[null,null,null,"Sheet \"Call & Topic\": acronym of your proposal. \nSheet \"Participants\": name of the participants.\nSheet \"Activities & WP\": name of the work packages.\nSheet \"PESCO\": answer(s) to the question(s)."]

{"sheet":"Call & Topic","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,1]]}
[]
[]
["Acronym of your proposal:"]
[]
[]
[]
["Call you are applying for:"]
[null,{"$f":"IF(B7=\"\",\"\",IF(OR(RIGHT(B7,1)=\"R\", RIGHT(B7,4)=\"RDIS\"), \"You are applying for a call for Research actions.\",\"You are applying for a call for Development actions.\"))","v":""}]
[{"$f":"IF(ISNUMBER(SEARCH(\"OPEN\", B7)), \"Actions under this call will be implemented through \"\"lump sums\"\" grants.\", IF(B7=\"\",\"\",\"Actions under this call will be implemented through \"\"actual costs\"\" grants.\"))","v":""}]
[]
["Topic for which you are submitting this proposal:"]

{"sheet":"CallsList","index":2,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Calls","Forms of Union funding","Budget for the call"]
["EDF-2021-MCBRN-R","actual costs",18500000]
["EDF-2021-MCBRN-D","actual costs",50000000]
["EDF-2021-C4ISR-D","actual costs",70000000]
["EDF-2021-SENS-R","actual costs",38000000]
["EDF-2021-CYBER-R","actual costs",13500000]
["EDF-2021-CYBER-D","actual costs",20000000]
["EDF-2021-SPACE-D","actual costs",50000000]
["EDF-2021-DIGIT-R","actual costs",18500000]
["EDF-2021-DIGIT-D","actual costs",40000000]
["EDF-2021-ENERENV-D","actual costs",133000000]
["EDF-2021-MATCOMP-R","actual costs",40000000]
["EDF-2021-AIR-R","actual costs",40000000]
["EDF-2021-AIR-D","actual costs",150000000]
["EDF-2021-AIRDEF-D","actual costs",100000000]
["EDF-2021-GROUND-R","actual costs",10000000]
["EDF-2021-GROUND-D","actual costs",150000000]
["EDF-2021-PROTMOB-D","actual costs",50000000]
["EDF-2021-NAVAL-R","actual costs",43500000]
["EDF-2021-NAVAL-D","actual costs",60000000]
["EDF-2021-DIS-RDIS","actual costs",60000000]
["EDF-2021-OPEN-RDIS","lump sum",10000000]
["EDF-2021-OPEN-R","lump sum",17500000]
["EDF-2021-OPEN-D","lump sum",36000000]

{"sheet":"TopicsList","index":3,"n_rows":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["List of topics","Budget for the topic"]
["EDF-2021-MCBRN-R-CBRNDIM"]
["EDF-2021-MCBRN-D-MCM"]
["EDF-2021-C4ISR-D-HAPS"]
["EDF-2021-C4ISR-D-COMS"]
["EDF-2021-SENS-R-IRD"]
["EDF-2021-SENS-R-RADAR"]
["EDF-2021-CYBER-R-CDAI"]
["EDF-2021-CYBER-D-IECTE"]
["EDF-2021-SPACE-D-SGNS"]
["EDF-2021-SPACE-D-EPW"]
["EDF-2021-DIGIT-R-FL"]
["EDF-2021-DIGIT-D-MDOC "]
["EDF-2021-ENERENV-D-EEMC"]
["EDF-2021-ENERENV-D-NGES"]
["EDF-2021-ENERENV-D-PES"]
["EDF-2021-MATCOMP-R-PHE"]
["EDF-2021-MATCOMP-R-RF"]
["EDF-2021-AIR-R-NGRT"]
["EDF-2021-AIR-D-EPE"]
["EDF-2021-AIR-D-CAC"]
["EDF-2021-AIRDEF-D-EATMI"]
["EDF-2021-GROUND-R-IW"]
["EDF-2021-GROUND-D-FMGV"]
["EDF-2021-GROUND-D-UGVT"]
["EDF-2021-GROUND-D-3CA"]
["EDF-2021-PROTMOB-D-SS"]
["EDF-2021-PROTMOB-D-DMM"]
["EDF-2021-NAVAL-R-DSSDA",29000000]
["EDF-2021-NAVAL-R-SSHM",14500000]
["EDF-2021-NAVAL-D-MMPC"]
["EDF-2021-DIS-RDIS-QSENS"]
["EDF-2021-DIS-RDIS-NLOS"]
["EDF-2021-DIS-RDIS-OTHR"]
["EDF-2021-DIS-RDIS-AMD"]
["EDF-2021-OPEN-RDIS-OPEN",4000000]
["EDF-2021-OPEN-R-SME",4000000]
["EDF-2021-OPEN-D-SME",4000000]

{"sheet":"Participants","index":4,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["List of participants"]
["ID","Name of the legal entity","Short name","PIC number\n(or national registration number for AP)","Country of establishment","Size of the legal entity \n(according to self-assessment or as validated by REA)"]

{"sheet":"Eligible countries","index":5,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Countries","Countries where the members of the consortium are established","Countries where the non-SMEs in the consortium are established (bonus)","Countries where the participants which are SMEs are established","Countries where the participants which are mid-caps are established","Countries where the non SMEs and non mid-caps in the consortium are established (award)","Countries","Country coefficient"]
["Austria",0,0,0,0,0,"Austria",1.0669999999999999]
["Belgium",0,0,0,0,0,"Belgium",1]
["Bulgaria",0,0,0,0,0,"Bulgaria",0.62]
["Croatia",1,0,1,0,0,"Croatia",0.83899999999999997]
["Cyprus",0,0,0,0,0,"Cyprus",0.82599999999999996]
["Czech Republic",0,0,0,0,0,"Czech Republic",0.81779999999999997]
["Denmark",0,0,0,0,0,"Denmark",1.35]
["Estonia",0,0,0,0,0,"Estonia",0.79400000000000004]
["Finland",0,0,0,0,0,"Finland",1.208]
["France",0,0,0,0,0,"France",1.157]
["Germany",0,0,0,0,0,"Germany",0.97]
["Greece",0,0,0,0,0,"Greece",0.88700000000000001]
["Hungary",0,0,0,0,0,"Hungary",0.77400000000000002]
["Ireland",0,0,0,0,0,"Ireland",1.1559999999999999]
["Italy",0,0,0,0,0,"Italy",1.044]
["Latvia",0,0,0,0,0,"Latvia",0.77700000000000002]
["Lithuania",0,0,0,0,0,"Lithuania",0.72499999999999998]
["Luxembourg",0,0,0,0,0,"Luxembourg",1]
["Malta",0,0,0,0,0,"Malta",0.84399999999999997]
["Netherlands",0,0,0,0,0,"Netherlands",1.079]
["Norway",0,0,0,0,0,"Norway",1.306]
["Poland",0,0,0,0,0,"Poland",0.755]
["Portugal",0,0,0,0,0,"Portugal",0.84199999999999997]
["Romania",0,0,0,0,0,"Romania",0.68799999999999994]
["Slovakia",0,0,0,0,0,"Slovakia",0.80400000000000005]
["Slovenia",0,0,0,0,0,"Slovenia",0.86099999999999999]
["Spain",0,0,0,0,0,"Spain",0.95399999999999996]
["Sweden",0,0,0,0,0,"Sweden",1.218]

{"sheet":"Activities & WP","index":6,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Work packages and corresponding eligible activities"]
["ID","Title","Corresponding eligible activity"]
["WP1","General management and coordination of the project","Studies"]

{"sheet":"Memory","index":7,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Has Step1 already been fully completed"]
["Call when last completed End of Step 1"]
["List of Participants changed since End of Step 1"]
["List of WP changed since End of Step 1"]
["Indirect costs up to date"]
["Call when added COO"]
["Call when added WP2"]
["Call when imported list of BE/AE Indirect costs"]
["Current call"]
["Topic when last completed end of step 1"]
["Has Step2 already been fully completed"]
["Call when last completed End of Step 2"]
["List of Participants changed since End of Step 2"]
["List of WP changed since End of Step 2"]
["Topic when last completed end of step 2"]

{"sheet":"Indirect costs","index":8,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,6,1,6]]}
["List of beneficiaries (BE) and affiliated entities (AE)",null,null,null,null,null,"Regime for the indirect costs"]
["ID","Name of the legal entity","Short name","PIC number","Country of establishment","Size of the legal entity"]

{"sheet":"A2 template - 1","index":9,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":true,"merged":[[41,0,41,1],[47,0,47,1],[24,0,24,1],[1,1,1,2],[2,0,2,6],[3,0,3,6],[7,0,7,4],[9,0,9,6],[13,0,13,4],[15,0,15,6],[19,0,19,4],[21,0,21,5],[23,0,23,6],[1,3,1,4],[1,5,1,6],[39,0,39,1],[40,0,40,1],[25,0,25,1],[28,0,28,5],[30,0,30,6],[31,1,31,5],[32,1,32,5],[26,0,26,1],[33,1,33,5],[55,0,55,5],[58,0,58,5],[60,0,60,5],[16,0,16,1],[17,0,17,1],[18,0,18,1],[53,0,53,5],[50,0,50,5],[42,0,42,5],[44,0,44,6],[45,0,45,1],[46,0,46,1],[48,0,48,5],[35,0,35,5],[37,0,37,6],[38,0,38,6]]}
["List of WP"]
["Ref WP",null,null,"Corresponding eligible activity"]
["A. DIRECT PERSONNEL COSTS"]
[{"$f":"\"A.1 Employees (or equivalent) for \" &A2","v":"A.1 Employees (or equivalent) for Ref WP"}]
["Position","Staff category","Annual staff costs","Actual annual productive time (days equivalent)","Daily rate","Direct days used in the action ","Personnel cost"]
[null,null,null,null,{"$f":"IFERROR(C6/D6,0)","v":0},null,{"$f":"+F6*E6","v":0}]
[null,null,null,null,{"$f":"IFERROR(C7/D7,0)","v":0},null,{"$f":"+F7*E7","v":0}]
[{"$f":"\"A.1 Total employees (or equivalent) for \" &A2","v":"A.1 Total employees (or equivalent) for Ref WP"},null,null,null,null,{"$f":"SUM(F6:F7)","v":0},{"$f":"SUMIF(G6:G7,\"<>#DIV/0!\")","v":0}]
[]
[{"$f":"\"A.2 Natural persons under direct contract and seconded persons for \" &A2","v":"A.2 Natural persons under direct contract and seconded persons for Ref WP"}]
["Position","Equivalent staff category","Annual staff costs","Actual annual productive time (days equivalent)","Daily rate","Direct days used in the action","Personnel cost"]
[null,null,null,null,{"$f":"IFERROR(+C12/D12,0)","v":0},null,{"$f":"+F12*E12","v":0}]
[null,null,null,null,{"$f":"IFERROR(+C13/D13,0)","v":0},null,{"$f":"+F13*E13","v":0}]
[{"$f":"\"A.2 Total natural persons under direct contract and seconded persons for \" &A2","v":"A.2 Total natural persons under direct contract and seconded persons for Ref WP"},null,null,null,null,{"$f":"SUM(F12:F13)","v":0},{"$f":"SUMIF(G12:G13,\"<>#DIV/0!\")","v":0}]
[]
[{"$f":"\"A.3 SME owners and natural person beneficiaries for \" &A2","v":"A.3 SME owners and natural person beneficiaries for Ref WP"}]
["Position",null,"Place of establishment","Country coefficient","Cost equivalent amount","Units: Actual months of work in the action","Personnel cost"]
[null,null,null,{"$f":"IF(C18=\"\",0,VLOOKUP(C18,'Eligible countries'!$G$2:$H$29,2,0))","v":0},5080,null,{"$f":"+F18*E18*D18","v":0}]
[null,null,null,null,5080,null,{"$f":"+F19*E19*D19","v":0}]
[{"$f":"\"A.3 Total SME owners and natural person beneficiaries for \" &A2","v":"A.3 Total SME owners and natural person beneficiaries for Ref WP"},null,null,null,null,{"$f":"SUM(F18:F19)","v":0},{"$f":"SUM(G18:G19)","v":0}]
[]
[{"$f":"\"A. TOTAL DIRECT PERSONNEL COSTS FOR \" &A2","v":"A. TOTAL DIRECT PERSONNEL COSTS FOR Ref WP"},null,null,null,null,null,{"$f":"+G14+G8+G20","v":0}]
[]
["B. TRAVEL COSTS AND SUBSISTENCE COSTS"]
["Description of costs (project meetings, technical meetings, national or international, conference, etc.)",null,"Number of trips","Number of persons \nper trip","Transportation costs/person/trip","Hotel costs+daily allowance/person/trip","Travel and subsistence costs"]
[null,null,null,null,null,null,{"$f":"C26*D26*(E26+F26)","v":0}]
[null,null,null,null,null,null,{"$f":"C27*D27*(E27+F27)","v":0}]
[]
[{"$f":"\"B. TOTAL TRAVEL AND SUBSISTENCE COSTS FOR \" &A2","v":"B. TOTAL TRAVEL AND SUBSISTENCE COSTS FOR Ref WP"},null,null,null,null,null,{"$f":"SUM(G26:G27)","v":0}]
[]
["C. DIRECT COSTS FOR SUBCONTRACTING"]
["Sub-contractor short name","Description of tasks subcontracted and reason for subcontracting",null,null,null,null,"Costs for subcontracting"]
[]
[]
[]
[{"$f":"\"C. TOTAL DIRECT COSTS FOR SUBCONTRACTING FOR \" &A2","v":"C. TOTAL DIRECT COSTS FOR SUBCONTRACTING FOR Ref WP"},null,null,null,null,null,{"$f":"SUM(G33:G34)","v":0}]
[]
["E. OTHER DIRECT COSTS"]
["E.1 Equipment"]
["Description of equipment",null,"Total cost of equipment","Period of use in the action \n(in months)","Service life \n(in months)","Usage rate for the action \n(100% or less if also used for other purposes)","Total amount payable for depreciation (for the action)"]
[null,null,null,null,null,null,{"$f":"IF(E41=0,0,C41/E41*D41*F41)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(E42=0,0,C42/E42*D42*F42)","v":0}]
[{"$f":"\"E.1 Total equipment for \" &A2","v":"E.1 Total equipment for Ref WP"},null,null,null,null,null,{"$f":"SUM(G41:G42)","v":0}]
[]
["E.2 Other goods and services"]
["Description of goods and services",null,"Cost per unit","Quantity",null,null,"Other goods and services costs for the action"]
[null,null,null,null,null,null,{"$f":"C47*D47","v":0}]
[null,null,null,null,null,null,{"$f":"C48*D48","v":0}]
[{"$f":"\"E.2 Total other goods and services for \" &A2","v":"E.2 Total other goods and services for Ref WP"},null,null,null,null,null,{"$f":"SUM(G47:G48)","v":0}]
[]
[{"$f":"\"E. TOTAL OTHER DIRECT COSTS FOR \" &A2","v":"E. TOTAL OTHER DIRECT COSTS FOR Ref WP"},null,null,null,null,null,{"$f":"+G49+G43","v":0}]
[]
[]
[{"$f":"\"TOTAL DIRECT ELIGIBLE COSTS FOR \" &A2","v":"TOTAL DIRECT ELIGIBLE COSTS FOR Ref WP"},null,null,null,null,null,{"$f":"G51+G36+G29+G22","v":0}]
[]
[{"$f":"\"TOTAL INDIRECT ELIGIBLE COSTS FOR \" &A2","v":"TOTAL INDIRECT ELIGIBLE COSTS FOR Ref WP"}]
[]
[]
["TOTAL DIRECT ELIGIBLE COSTS FOR THE ENTIRE ACTION"]
[]
["TOTAL INDIRECT ELIGIBLE COSTS FOR THE ENTIRE ACTION"]

{"sheet":"A2 template - 2","index":10,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":true,"merged":[[9,13,12,13],[9,11,12,11],[1,15,2,15],[3,13,6,13],[3,14,6,14],[1,13,1,14],[3,15,7,15],[3,11,6,11],[3,12,6,12],[20,8,20,13],[20,1,20,7],[23,5,24,5],[23,8,25,8],[1,0,5,0],[3,2,5,2],[3,6,6,6],[4,7,6,7],[4,4,5,4],[1,1,1,6],[3,5,5,5],[3,3,5,3],[1,7,1,12],[4,8,6,8],[3,9,6,9],[3,10,6,10],[23,9,25,9],[21,1,21,2],[20,0,24,0],[20,14,20,15],[20,16,21,16],[22,3,24,3],[22,4,24,4],[22,6,24,6],[22,7,25,7],[22,10,25,10],[22,11,25,11],[22,12,25,12],[22,13,25,13],[22,14,25,14],[22,15,25,15],[22,16,26,16]]}
["Activities"]
[null,"Estimated eligible costs (per budget category)",null,null,null,null,null,"EU contribution",null,null,null,null,null,"Subcontracting and other direct costs checks",null,"Estimated costs of associated partners"]
[null,"A. Direct personnel costs","B. Direct travel and subsistence costs","C. Direct costs for subcontracting","E. Other direct costs","F. Indirect costs","Total eligible costs","Baseline funding rate","Increase in the  baseline funding rate (bonus)","Maximum eligible funding rate %","Maximum eligible EU contribution","Requested EU contribution","Corresponding EU funding rate ","Percentage of subcontracting ","Percentage of direct cost of travel / subsistence and other direct costs"]
[null,"A.1  Employees (or equivalent)",null,"Only for beneficiaries and affiliated entities","E.1 Equipment","Depends on calls and/or on beneficiaries or linked third parties",null,"For research actions: 100%.","Not applicable to research actions.","Cannot exceed 100%.",null,"Cannot exceed i.\n\nThe total for the entire action cannot exceed the budget indicated in the call (or the ceiling for the topic if any). If this total exceeds this value, it will appear in red.","Provided for information.","You must report these values in Section 4.1 of the submission form.\nWhere subcontracting costs represent more than 30% of total eligible costs (will appear in orange), you must in adition provide a justification in Section 4.1 of the submission form.","You must report these values in Section 4.2 of the submission form.\nWhere direct cost of travel + subsistance + other direct costs represent more than 15% of direct personnel costs (will appear in orange), you must in adition provide a justification in Section 4.2 of the submission form.","Provided for information."]
[null,"A.2 Natural persons under direct contract and seconded persons",null,null,"E.2 Other goods and services",null,null,"For development actions, depends on eligible activities:\n- Integrating knowledge: 65%\n- Studies: 90%\n- Design: 65%\n- Protoyping: 20%\n- Testing: 45%\n- Qualification, certification: 70%\n- Increase efficiency: 65%","For development actions, depends on various parameters.\nCannot exceed 10% for studies, qualification and certification\nCannot exceed 35% for other activities."]
[null,"A.3. SME owners and natural person beneficiaries"]
["Cost form","Actual for A.1 and A.2\nUnit for A.3","Actual ","Actual ","Actual ","Flat-rate or Actual"]
["Cost formula","a","b","c","e","f = flat-rate * (a + b + e)\n or\nf = actual cost","g = a+ b + c + e + f","h0 = values as above","h1 = values as calculated in Annex 1 to the submission form","h = h0 + h1","i = g * h","j","k = j / g","l = c/g","m = (b + e)/a"]
[]
[null,null,null,null,null,"Flat-rate",null,null,null,null,null,"Cannot exceed i.\n\nThe total for the entire action cannot exceed the budget indicated in the call (or the ceiling for the topic if any). If the total exceeds this value, it will appear in red.\n\nYou must report these values in e-Grants Part A Section 3 (Budget).",null,"You must report these values in Section 4.1 of the submission form.\n\nBe aware that for the calls EDF-2021-OPEN-X, the limit of 30% is strict (will appear in red if above)."]
[null,null,null,null,null,"f = flat-rate * (a + b + e)"]
[]
[]
[]
[]
[]
[]
["Template for actual costs with 2 columns for A"]
[]
["Activities"]
[null,"Estimated eligible costs (per budget category)",null,null,null,null,null,null,"EU contribution",null,null,null,null,null,"Subcontracting and other direct costs checks",null,"Estimated costs of associated partners"]
[null,"A. Direct personnel costs",null,"B. Direct travel and subsistence costs","C. Direct costs for subcontracting","E. Other direct costs","F. Indirect costs","Total eligible costs","Baseline funding rate","Increase in the  baseline funding rate (bonus)","Maximum eligible funding rate %","Maximum eligible EU contribution","Requested EU contribution","Corresponding EU funding rate ","Percentage of subcontracting ","Percentage of direct cost of travel / subsistence and other direct costs"]
[null,"A.1  Employees (or equivalent)",null,null,"Only for beneficiaries and affiliated entities","E.1 Equipment","Depends on calls and/or on beneficiaries or linked third parties",null,"For research actions: 100%.","Not applicable to research actions.","Cannot exceed 100%.",null,"Cannot exceed i.\n\nThe total for the entire action cannot exceed the budget indicated in the call (or the ceiling for the topic if any). If this total exceeds this value, it will appear in red.","Provided for information.","You must report these values in Section 4.1 of the submission form.\nWhere subcontracting costs represent more than 30% of total eligible costs (will appear in orange), you must in adition provide a justification in Section 4.1 of the submission form.","You must report these values in Section 4.2 of the submission form.\nWhere direct cost of travel + subsistance + other direct costs represent more than 15% of direct personnel costs (will appear in orange), you must in adition provide a justification in Section 4.2 of the submission form.","Provided for information."]
[null,"A.2 Natural persons under direct contract and seconded persons",null,null,null,"E.2 Other goods and services",null,null,"For development actions, depends on eligible activities:\n- Integrating knowledge: 65%\n- Studies: 90%\n- Design: 65%\n- Protoyping: 20%\n- Testing: 45%\n- Qualification, certification: 70%\n- Increase efficiency: 65%","For development actions, depends on various parameters.\nCannot exceed 10% for studies, qualification and certification\nCannot exceed 35% for other activities."]
[null,null,"A.3. SME owners and natural person beneficiaries"]
["Cost form","Actual","Unit","Actual ","Actual ","Actual ","Flat-rate or Actual"]
["Cost formula","a1 + a2","a3","b","c","e","f = flat-rate * (a + b + e)\n or\nf = actual cost","g = a+ b + c + e + f","h0 = values as above","h1 = values as calculated in Annex 1 to the submission form","h = h0 + h1","i = g * h","j","k = j / g","l = c/g","m = (b + e)/a"]

{"sheet":"A1 template","index":11,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":true,"merged":[[0,8,0,9],[3,1,3,6],[4,1,4,5],[21,1,21,6],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[5,1,5,5],[0,0,0,1],[0,4,0,7],[0,2,0,3],[15,1,15,5],[16,1,16,5],[17,1,17,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[25,1,25,5],[22,1,22,5],[23,1,23,5],[24,1,24,5],[19,1,19,5],[18,1,18,5],[31,1,31,5],[32,1,32,5],[33,1,33,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[29,1,29,5],[30,1,30,5],[35,1,35,6],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[36,1,36,4],[36,5,36,6],[41,1,41,5],[42,1,42,5],[43,1,43,5],[44,1,44,5],[45,1,45,5]]}
["Activity:",null,null,null,"Total eligible costs for this activity:"]
["ID","Name ","Short name","PIC Number","Country of establishment ","Size","Total costs allocated to the entity for this activity","Total direct costs for subcontracting for this activity \n(only for BE and AE)","Is an SME established in a country other than those where the non-SMEs in the consortium are established?\n(for the SME bonus)","Is an SME or a mid-cap established in a country other than those where the non-SMEs and non-mid-caps in the consortium are established?\n(for the award criterion 5)"]
[]
[null,{"$f":"\"INCREASE IN THE FUNDING RATE FOR THE ACTIVITY \" & $C$1 & \" (BONUS)\"","v":"INCREASE IN THE FUNDING RATE FOR THE ACTIVITY  (BONUS)"}]
[null,"Total costs allocated to SMEs for this activity"]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G5/$I$1,0)","v":0}]
[null,"Eligible to SME bonus?",null,null,null,null,{"$f":"IF(G6>=10%,\"YES\",\"NO\")","v":"NO"}]
[null,"Total costs allocated to cross-border SMEs for this activity"]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G8/$I$1,0)","v":0}]
[null,"Contribution to the bonus",null,null,null,null,{"$f":"IF(G7=\"YES\",2*G9,0%)","v":0}]
[null,"Total costs allocated to non cross-border SMEs for this activity",null,null,null,null,{"$f":"G5-G8","v":0}]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G11/$I$1,0)","v":0}]
[null,"Contribution to the bonus",null,null,null,null,{"$f":"IF(G7=\"YES\",MIN(G12,5%),0%)","v":0}]
[null,"Total costs allocated to mid-caps"]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G14/$I$1,0)","v":0}]
[null,"Eligible to mid-cap bonus?",null,null,null,null,{"$f":"IF(G15>=15%,\"YES\",\"NO\")","v":"NO"}]
[null,"Contribution to the bonus",null,null,null,null,{"$f":"IF(G16=\"YES\",10%,0%)","v":0}]
[null,"Eligible to PESCO bonus?",null,null,null,null,{"$f":"IF(PESCO!$C$4=\"YES\",\"YES\",\"NO\")","v":"NO"}]
[null,"Contribution to the bonus",null,null,null,null,{"$f":"IF(G18=\"YES\",10%,0%)","v":0}]
[null,{"$f":"\"TOTAL INCREASE IN THE FUNDING RATE (BONUS)\" & CHAR(10) & \"FOR THE ACTIVITY \" &$C$1","v":"TOTAL INCREASE IN THE FUNDING RATE (BONUS)\nFOR THE ACTIVITY "},null,null,null,null,{"$f":"IF(OR($C$1=\"STUDIES\", $C$1=\"QUALIFICATION\",$C$1=\"CERTIFICATION\"),MIN(10%,G13+G10+G17+G19),MIN(35%,G13+G10+G17+G19))","v":0}]
[]
[null,{"$f":"\"PARTICIPATION OF SMES AND MIDCAPS IN THE ACTIVITY \" & $C$1 & \" (AWARD)\"","v":"PARTICIPATION OF SMES AND MIDCAPS IN THE ACTIVITY  (AWARD)"}]
[null,"Total costs allocated to SMEs in this activity",null,null,null,null,{"$f":"G5","v":0}]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G23/$I$1,0)","v":0}]
[null,"Total costs allocated to cross-border SMEs in this activity"]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G25/$I$1,0)","v":0}]
[null,"Total costs allocated to non cross-border SMEs in this activity",null,null,null,null,{"$f":"G23-G25","v":0}]
[null,"Corresponding share",null,null,null,null,{"$f":"G24-G26","v":0}]
[null,"Total costs allocated to mid-caps in this activity",null,null,null,null,{"$f":"G14","v":0}]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G29/$I$1,0)","v":0}]
[null,"Total costs allocated to cross-border mid-caps in this activity"]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G31/$I$1,0)","v":0}]
[null,"Total costs allocated to non cross-border mid-caps in this activity",null,null,null,null,{"$f":"G29-G31","v":0}]
[null,"Corresponding share",null,null,null,null,{"$f":"G30-G32","v":0}]
[]
[null,"PARTICIPATION OF SMES AND MIDCAPS IN THE ENTIRE ACTION (AWARD)"]
[null,"Total eligible costs for the entire action:"]
[null,"Total costs allocated to SMEs in the entire action"]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G38/F37,0)","v":0}]
[null,"Total costs allocated to cross-border SMEs in the entire action"]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G40/F37,0)","v":0}]
[null,"Total costs allocated to non cross-border SMEs in the entire action",null,null,null,null,{"$f":"G38-G40","v":0}]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G42/F37,0)","v":0}]
[null,"Total costs allocated to mid-caps in the entire action"]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G44/F37,0)","v":0}]
[null,"Total costs allocated to cross-border mid-caps in the entire action"]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G46/F37,0)","v":0}]
[null,"Total costs allocated to non cross-border mid-caps in the entire action",null,null,null,null,{"$f":"G44-G46","v":0}]
[null,"Corresponding share",null,null,null,null,{"$f":"IFERROR(G48/F37,0)","v":0}]

{"sheet":"Eligible activities","index":12,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Eligible activities","Covered","Eligible activities for dev","Baseline funding rate"]
["Generating knowledge",0]
["Integrating knowledge",0,"Integrating knowledge",0.65]
["Studies",1,"Studies",0.9]
["Design",0,"Design",0.65]
["Prototyping",0,"Prototyping",0.2]
["Testing",0,"Testing",0.45]
["Qualification",0,"Qualification",0.7]
["Certification",0,"Certification",0.7]
["Increasing efficiency",0,"Increasing efficiency",0.65]

{"sheet":"PESCO","index":13,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,2,6,5],[8,2,8,10]]}
[]
[]
[]
[null,"Is your project developed in the context of a project of the Permanent Structured Cooperation (PESCO)?"]
[]
[]
[null,{"$f":"IF(C4=\"YES\",\"Please provide a reference to one of the PESCO projects included in the list adopted by the Council at the time of the submission of your proposal:\",\"\")","v":""}]
[]
[null,{"$f":"IF(C4=\"YES\",\"And provide a justification that this action is developed in the context of that PESCO project:\",\"\")","v":""}]

{"sheet":"History of changes","index":14,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Version","Publication Date","Change","Page"]
["v1.00","2021-06-30"]