{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["INSTRUCTIONS","Self-assessment form","History of changes","Countries","YearsList","CallsList","TopicsList"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":23,"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":106,"n_cols":13,"rows_kept":106,"cut":false,"hidden":false,"merged":[[104,1,104,20],[99,2,99,20],[103,2,103,20],[105,2,105,20],[100,3,100,20],[101,3,101,20],[102,3,102,20],[94,3,94,20],[95,3,95,20],[96,3,96,20],[97,3,97,20],[98,3,98,20],[89,3,89,20],[90,3,90,20],[91,3,91,20],[92,2,92,20],[93,3,93,20],[86,1,86,20],[87,2,87,20],[88,3,88,20],[84,3,84,20],[85,3,85,20],[79,3,79,20],[80,3,80,20],[81,3,81,20],[82,3,82,20],[83,3,83,20],[74,3,74,20],[75,3,75,20],[76,3,76,20],[77,3,77,20],[78,2,78,20],[69,4,69,20],[70,4,70,20],[71,3,71,20],[73,2,73,20],[72,3,72,20],[65,1,65,20],[66,2,66,20],[67,3,67,20],[64,2,64,20],[68,3,68,20],[59,1,59,20],[60,1,60,20],[63,1,63,20],[61,2,61,20],[62,2,62,20],[55,1,55,20],[56,1,56,20],[57,1,57,20],[53,1,54,20],[52,1,52,20],[50,1,50,20],[51,1,51,20],[48,1,48,20],[49,1,49,20],[44,1,44,20],[45,1,45,20],[46,1,47,20],[27,1,27,20],[28,1,28,20],[29,1,32,20],[25,1,25,20],[40,1,42,20],[39,1,39,20],[33,1,33,20],[34,1,34,20],[35,1,38,20],[20,1,21,20],[17,1,17,20],[18,1,18,20],[19,1,19,20],[22,1,24,20],[16,1,16,20],[14,1,14,20],[15,16,15,20],[11,1,12,20],[10,1,10,7],[10,8,10,11],[10,12,10,20],[15,11,15,14],[7,1,8,20],[4,1,4,20],[1,1,2,20],[6,1,6,20],[9,1,9,20]]}
[]
[null,"Annex 8 - Mid-cap self-assessment form"]
[]
[]
[null,"This 'macro-enabled' excel file is designed to fill in Annex 8 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,"GENERAL INSTRUCTIONS"]
[null,"All participants claiming the mid-cap status must fill in Annex 8. The mid-cap status will be taken into consideration when assessing your proposal against the award criterion 5 (both for Research actions and Development actions) and, for Developement actions, when you are claiming the mid-cap bonus. "]
[]
[null,"All blue cells need to be filled in, some of them taking the form of drop down menu. You are only allowed to fill in blue cells (other cells are protected)."]
[null,"If you need the structure of the form to be adapted, please contact us at: ",null,null,null,null,null,null,"DEFIS-EDF-proposals@ec.europa.eu ",null,null,null,"and explain the type of adaptations that you think are needed."]
[null,"Important: all mid-caps concerned must provide the form duly completed both in pdf and excel formats."]
[]
[]
[null,"GUIDANCE TO FILL IN SOME OF THE BLUE CELLS"]
[null,"Exchange rate: please use official exchange rate at the day of the closure of the accounting period from:",null,null,null,null,null,null,null,null,null,"http://ec.europa.eu/budg/inforeuro"]
[null,"Share or vote quota: please provide the highest value between the % of shares owned in the entity or the % of voting rights in the entity."]
[]
[null,"Articles mentioned below in definitions of turnover and balance sheet refer to the following source:"]
[null,"Directive 2013/34/EU of the European Parliament and of the Council of 26 June 2013 on the annual financial statements, consolidated financial statements and related reports of certain types of undertakings"]
[null,"Definition of turnover: \"'net turnover' means the amounts derived from the sale of products and the provision of services after deducting sales rebates and value added tax and other taxes directly linked to turnover\" (Article 2)"]
[]
[null,"Definition of balance sheet: \"The balance sheet total [...] shall consist of the assets in A to E under \"Assets\" in the layout set out in Annex III or of the assets in A to E in the layout set out in Annex IV.\" (Article 3.11). \"For the presentation of the balance sheet, Member States shall prescribe one or both of the layouts set out in Annexes III and IV. If a Member State prescribes both layouts, it shall permit undertakings to choose which of the prescribed layouts to adopt\" (Article 10)."]
[]
[]
[null,"To fill in correctly cells \"Definition of relation\" and \"Direction\" (choice lists), please refer to the definitions below."]
[]
[null,"DEFINITION OF LINKED COMPANIES"]
[null,"UPSTREAM"]
[null,"An enterprise has a majority of the shareholders' or members' voting rights in your organisation; and or has the right to appoint or remove a majority of the members of the administrative, management or supervisory body of your organisation; and or has the right to exercise a dominant influence over your organisation pursuant to a contract entered into with you or to a provision in your memorandum or articles of association; and or an enterprise, which is a shareholder in or a member of your organisation, controls alone, pursuant to an agreement with other shareholders in or members of your organisation, a majority of shareholders' or members' voting rights in your organisation. "]
[]
[]
[]
[]
[null,"DOWNSTREAM"]
[null,"Your organisation has a majority of the shareholders' or members' voting rights another (or several other) enterprise(s); and or has the right to appoint or remove a majority of the members of the administrative, management or supervisory body of another (or several other) enterprise(s); and or has the right to exercise a dominant influence over another (or several other) enterprise(s) pursuant to a contract entered into with that (these) enterprise(s) or to a provision in its (their) memorandum or articles of association and or your organisation, which is a shareholder in or member of another (or several other) enterprise(s), controls alone, pursuant to an agreement with other shareholders in or members of that (these) enterprise(s), a majority of shareholders' or members' voting rights in that (these) enterprise(s). "]
[]
[]
[]
[]
[null,"Please note that enterprises which have one or other of such relationships through a natural person or group of natural persons acting jointly are also considered linked enterprises if they engage in their activity or in part of their activity in the same relevant market or in adjacent markets. An ‘adjacent market’ is considered to be the market for a product or service situated directly upstream or downstream of the relevant market."]
[]
[]
[]
[null,"DEFINITION OF PARTNER COMPANY"]
[null,"UPSTREAM*"]
[null,"An enterprise (or several enterprises), which is (are) not classified as an upstream linked enterprise (see above) hold(s), either solely or jointly with one or more linked enterprises, 25 % or more of the capital or voting rights of your organisation"]
[]
[]
[null,"DOWNSTREAM*"]
[null,"Your organisation holds, either solely or jointly with one or more linked enterprises, 25 % or more of the capital or voting rights of another (or several other) enterprise(s) "]
[]
[null,"* Please disregard partner organisations for calculation purposes in the following cases:"]
[null,"1) If your partners are public investment corporations, venture capital companies, individuals or groups of individuals with a regulare venture capital investment activity who invest equity capital in unquoted businesses (\"business angels\"), provided the total investment of those business angels in your organisation is less than EUR 1 250 000"]
[]
[null,"2) If your partners are universities or non-profit research centres "]
[null,"3) If your partners are institutional investors, including regional development funds "]
[null,"4) If your partners are autonomous local authorities with an annual budget of less than EUR 10 million and fewer than 5 000 inhabitants"]
[]
[null,"LIST OF ASSETS IN ARTICLE 9"]
[null,"A. Subscribed capital unpaid"]
[null,null,"of which there has been called"]
[null,null,"(unless national law provides that called-up capital be shown under \"Liabilities\". In that case, the part of the capital called but not yet paid must appear as an asset either under A or under D (II) (5))."]
[null,"B. Formation expenses"]
[null,null,"as defined by national law, and in so far as national law permits their being shown as an asset. National law may also provide for formation expenses to be shown as the first item under \"Intangible assets\"."]
[null,"C. Fixed assets"]
[null,null,"I. Intangible assets"]
[null,null,null,"1. Costs of research and development, in so far as national law permits their being shown as assets."]
[null,null,null,"2. Concessions, patents, licences, trade marks and similar rights and assets, if they were: "]
[null,null,null,null,"(a) acquired for valuable consideration and need not be shown under C (I) (3) ; or"]
[null,null,null,null,"(b) created by the undertaking itself, in so far as national law permits their being shown as assets."]
[null,null,null,"3. Goodwill, to the extent that it was acquired for valuable consideration."]
[null,null,null,"4. Payments on account."]
[null,null,"II. Tangible assets"]
[null,null,null,"1. Land and buildings."]
[null,null,null,"2. Plant and machinery."]
[null,null,null,"3. Other fixtures and fittings, tools and equipment."]
[null,null,null,"4. Payments on account and tangible assets in course of construction."]
[null,null,"III. Financial assets"]
[null,null,null,"1. Shares in affiliated undertakings."]
[null,null,null,"2. Loans to affiliated undertakings."]
[null,null,null,"3. Participating interests."]
[null,null,null,"4. Loans to undertakings with which the company is linked by virtue of participating interests."]
[null,null,null,"5. Investments held as fixed assets."]
[null,null,null,"6. Other loans."]
[null,null,null,"7. Own shares (with an indication of their nominal value or, in the absence of a nominal value, their accounting par value) to the extent that national law permits their being shown in the balance sheet."]
[null,"D. Current assets"]
[null,null,"I. Stocks"]
[null,null,null,"1. Raw materials and consumables."]
[null,null,null,"2. Work in progress."]
[null,null,null,"3. Finished goods and goods for resale."]
[null,null,null,"4. Payments on account."]
[null,null,"II. Debtors (Amounts becoming due and payable after more than one year must be shown separately for each item.)"]
[null,null,null,"1. Trade debtors."]
[null,null,null,"2. Amounts owed by affiliated undertakings."]
[null,null,null,"3. Amounts owed by undertakings with which the company is linked by virtue of participating interests."]
[null,null,null,"4. Other debtors."]
[null,null,null,"5. Subscribed capital called but not paid (unless national law provides that called-up capital be shown as an asset under A)."]
[null,null,null,"6. Prepayments and accrued income (unless national law provides for such items to be shown as an asset under E)."]
[null,null,"III. Investments"]
[null,null,null,"1. Shares in affiliated undertakings."]
[null,null,null,"2. Own shares (with an indication of their nominal value or, in the absence of a nominal value, their accounting par value) to the extent that national law permits their being shown in the balance sheet."]
[null,null,null,"3. Other investments."]
[null,null,"IV. Cash at bank and in hand"]
[null,"E. Prepayments and accrued income"]
[null,null,"(unless national law provides for such items to be shown as an asset under D (II) (6))."]

{"sheet":"Self-assessment form","index":1,"n_rows":56,"n_cols":16,"rows_kept":56,"cut":false,"hidden":false,"merged":[[52,1,53,15],[39,1,39,5],[38,1,38,5],[50,1,50,5],[50,6,50,9],[50,10,50,11],[47,1,47,5],[47,6,47,15],[46,1,46,5],[46,6,46,15],[44,1,44,5],[44,6,44,15],[38,12,38,14],[39,12,39,14],[43,1,43,5],[43,6,43,15],[56,1,57,9],[56,10,57,15],[55,10,55,15],[55,1,55,9],[37,12,37,14],[37,1,37,5],[41,1,41,5],[41,6,42,15],[50,12,50,14],[48,1,48,5],[48,6,48,11],[48,12,48,14],[49,1,49,5],[49,6,49,9],[49,10,49,11],[49,12,49,14],[14,6,14,15],[15,6,15,15],[17,1,17,15],[19,6,19,15],[20,6,20,15],[19,1,19,5],[21,6,21,15],[22,6,22,15],[23,6,23,15],[27,6,28,15],[29,6,29,15],[30,6,30,15],[31,6,31,15],[25,1,25,15],[32,6,32,15],[29,1,29,5],[30,1,30,5],[31,1,31,5],[36,6,36,11],[37,6,37,11],[34,6,34,15],[34,1,34,5],[36,12,36,14],[45,1,45,5],[1,1,2,15],[4,1,6,15],[8,1,9,15],[11,1,11,15],[13,6,13,15],[13,1,13,5],[39,10,39,11],[39,6,39,9],[38,10,38,11],[38,6,38,9],[45,6,45,15],[42,1,42,5],[36,1,36,5],[14,1,14,5],[15,1,15,5],[22,1,22,5],[23,1,23,5],[32,1,32,5],[20,1,20,5],[21,1,21,5],[27,1,28,5]]}
[]
[null,"Mid-cap self-assessment form (Annex 8)"]
[]
[]
[]
[]
[]
[]
[null,"Note: please use the Validate Annex 8 button above to ensure all the required fields have been filled-in. "]
[]
[]
[null,"Reference"]
[]
[null,"Call identifier:"]
[null,"Topic identifier:"]
[null,"Proposal acronym:"]
[]
[null,"Entity"]
[]
[null,"Legal name"]
[null,"PIC (9 digits)"]
[null,"Last accounting period (year):"]
[null,"Financial year date (closing date: dd/mm/yyyy):"]
[null,"Accounting period (duration in months):"]
[]
[null,"SELF-ASSESSMENT RESULTS"]
[]
[null,"Self-assessment result",null,null,null,null,{"$f":"IF(AND(G30<250,G31<=50000000,G32<=43000000),\"SME\",IF(G30<=3000,\"MIDCAP\",\"LARGE COMPANY\"))","v":"SME"}]
[]
[null,"Number of employees:",null,null,null,null,{"$f":"P38+P49","v":0}]
[null,"Annual turnover (P&L account):",null,null,null,null,{"$f":"P39+P50","v":0}]
[null,"Annual balance sheet (Assets):",null,null,null,null,{"$f":"P40+P51","v":0}]
[null,"Autonomous:",null,null,null,null,{"$f":"IF(G42=\"\",\"Yes\",\"No\")","v":"Yes"}]
[]
[null,"Participant's legal name",null,null,null,null,{"$f":"IF(G20=\"\",\"\",G20)","v":""}]
[]
[null,"Place of establishment",null,null,null,null,null,null,null,null,null,null,"Exchange rate (1 EUR =)",null,null,1]
[null,"Staff Headcount",null,null,null,null,null,null,null,null,null,null,"Staff Number",null,null,{"$f":"G38","v":0}]
[null,"Annual turnover (Local currency)",null,null,null,null,null,null,null,null,null,null,"Turnover (in EUR)",null,null,{"$f":"K39*1/$P$37","v":0}]
[null,"Annual balance sheet (Local currency)",null,null,null,null,null,null,null,null,null,null,"Balance sheet (in EUR)",null,null,{"$f":"K40*1/$P$37","v":0}]
[]
[null,"LINKED/PARTNER Enterprise"]
[null,"Organisation name"]
[null,"Definition of relation"]
[null,"Direction"]
[null,{"$f":"IF(ISBLANK(G44),\"----------------\",IF(OR(G44=\"Partner\",G44=\"Linked\"),\"Shares or vote quota in relation with the participant (%)\",IF(G44=\"Linked to Partner\",\"Share or vote quota in relation with the Partner\",\"Share or vote quota in relation with the Linked entity\")))","v":"----------------"}]
[null,{"$f":"IF(ISBLANK(G44),\"----------------\",IF(OR(G44=\"Linked\",G44=\"Partner\"),\"----------------\",IF(G44=\"Linked to Partner\",\"Share or vote quota of the Partner in relation with the participant\",\"Share or vote quota of the Linked entity in relation with the participant\")))","v":"----------------"}]
[null,"Exchange rate (1 EUR =)",null,null,null,null,1]
[null,"Staff Headcount",null,null,null,null,null,null,null,null,null,null,"Contribution to Staff",null,null,{"$f":"IF(OR(G44=\"Linked\", G44=\"Linked to Linked\"),G49, IF(G44=\"Linked to Partner\", G49*G47,G49*G46))","v":0}]
[null,"Annual turnover (Local currency)",null,null,null,null,null,null,null,null,null,null,"Contribution to Turnover (in EUR)",null,null,{"$f":"IF(OR(G44=\"Linked\", G44=\"Linked to Linked\"),K50/G48,IF(G44=\"Linked to Partner\",K50*G47/G48,K50*G46/G48))","v":0}]
[null,"Annual balance sheet (Local currency)",null,null,null,null,null,null,null,null,null,null,"Contribution to Balance sheet (in EUR)",null,null,{"$f":"IF(OR(G44=\"Linked\", G44=\"Linked to Linked\"),K51/G48,IF(G44=\"Linked to Partner\",K51*G47/G48,K50*G46/G48))","v":0}]
[]
[]
[]
[]
[null,"DATE",null,null,null,null,null,null,null,null,"NAME"]

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

{"sheet":"Countries","index":3,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Countries"]
["Austria"]
["Belgium"]
["Bulgaria"]
["Croatia"]
["Cyprus"]
["Czech Republic"]
["Denmark"]
["Estonia"]
["Finland"]
["France"]
["Germany"]
["Greece"]
["Hungary"]
["Ireland"]
["Italy"]
["Latvia"]
["Lithuania"]
["Luxembourg"]
["Malta"]
["Netherlands"]
["Norway"]
["Poland"]
["Portugal"]
["Romania"]
["Slovakia"]
["Slovenia"]
["Spain"]
["Sweden"]

{"sheet":"YearsList","index":4,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Years","Months"]
[{"$f":"YEAR(TODAY())-1","v":2020},0]
[{"$f":"YEAR(TODAY())-2","v":2019},{"$f":"B2+1","v":1}]
[{"$f":"YEAR(TODAY())-3","v":2018},{"$f":"B3+1","v":2}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]

{"sheet":"CallsList","index":5,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Calls"]
["EDF-2021-AIR-D"]
["EDF-2021-AIR-R"]
["EDF-2021-AIRDEF-D"]
["EDF-2021-C4ISR-D"]
["EDF-2021-CYBER-D"]
["EDF-2021-CYBER-R"]
["EDF-2021-DIGIT-D"]
["EDF-2021-DIGIT-R"]
["EDF-2021-DIS-R"]
["EDF-2021-ENERENV-D"]
["EDF-2021-GROUND-D"]
["EDF-2021-GROUND-R"]
["EDF-2021-MATCOMP-R"]
["EDF-2021-MCBRN-D"]
["EDF-2021-MCBRN-R"]
["EDF-2021-NAVAL-D"]
["EDF-2021-NAVAL-R"]
["EDF-2021-OPEN-D"]
["EDF-2021-OPEN-R"]
["EDF-2021-OPEN-RDIS"]
["EDF-2021-PROTMOB-D"]
["EDF-2021-SENS-R"]
["EDF-2021-SPACE-D"]

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