{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Welcome","Gantt chart","Example of a Gantt chart","List of deliverable types","Validations","Total project budget","Ex. of individual project","Ex. of collaboration project","List of subsidy rates","Deliverables","Milestones"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Welcome","index":0,"n_rows":42,"n_cols":2,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,1,6,7],[8,1,9,7],[11,1,11,7],[15,1,17,7],[18,1,20,7],[33,1,36,7],[37,1,40,7],[41,1,43,7],[44,1,46,7],[12,1,14,7],[21,1,24,7],[25,1,25,7],[26,1,26,7],[27,1,28,7],[29,1,30,7],[32,1,32,7]]}
[]
[]
[]
[]
[null,"If a yellow bar appears at the top, which asks you to accept macros or ActiveX-objects, you are advised to accept. Otherwise the application form will not work."]
[]
[]
[]
[null,"What type of project are you applying for?"]
[]
[]
[null,"Collaboration projects"]
[null,"Collaboration projects in general have higher rates than individual projects. To achieve an increased rate for collaboration projects, the project must be one of the following: \n \n\n\n\nI samarbejdsprojekter er det et krav, at projektets resultater formidles bredt gennem konferencer, publikationer, open access-samlinger, gratis software eller open source-software. (Dette gælder dog ikke fortrolige oplysninger.)\n"]
[]
[]
[null,"• A collaboration between companies of which at least one is a SME, and where no individual company holds more than 70 percent of the total GUDP subsidy, or;"]
[]
[]
[null,"• A collaboration between companies (regardless of size) and a research and knowledge dissemination institution, where the latter contributes with a co-financing of at least 10 percent of the GUDP subsidy."]
[]
[]
[null,"In collaboration projects, it is a requirement, that the project results are widely disseminated through conferences, publications, open access archives, free software or open source-software. (However, this does not apply to information that is confidential.)"]
[]
[]
[]
[null,"Individual projects"]
[null,"An individual project is either: "]
[null,"• A project with a single participant – main applicant – which is a company (regardless of size), or;"]
[]
[null,"• A project with several participants, but where one of the participants holds more than 70 percent of the total GUDP subsidy."]
[]
[]
[null,"Please notice the following:"]
[null,"For individual projects, it can sometimes be necessary with external assistance, e.g., with help from experts. These are not co-applicants of the project, but are hired to carry out project-specific work, that the project participants themselves cannot carry out, due to lack of specific competences"]
[]
[]
[]
[null,"For both collaboration and individual projects, it applies, that a sub-budget has to be made for each activity type, for each participant. There are three different acitivity types: 1) Applied research, 2) Development, 3) Demonstration "]
[]
[]
[]
[null,"Example: An individual project, with one participant, that includes the activity types 'Development' and 'Demonstration', has to make two sub-budgets – one for each activity type.  "]

{"sheet":"Gantt chart","index":1,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[[3,2,3,5],[3,6,3,9],[3,10,3,13],[3,14,3,17]]}
[]
["Gantt chart"]
[]
[null,null,"20XX",null,null,null,"20XX",null,null,null,"20XX",null,null,null,"20XX",null,null,null,"Acticity type (F/U/D)"]
[null,"Involved project participants","Jan","Apr","Jul","Oct","Jan","Apr","Jul ","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","and deliverable type, see list on sheet \"List of deliverable types\"","Number of hours","WP budget"]
["WP 1: Name of WP1"]
["1.1 "]
["1.2"]
["1.3"]
["Etc."]
[]
["Milestones:"]
["M1.1:"]
["M 1.2:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of hours:","Total budget:"]
["WP 2"]
["2.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["2.2"]
["2.3"]
[]
["Milestones:"]
["M2.1:"]
["M 2.2:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of hours:","Total budget:"]
["WP 3"]
["3.1"]
["3.2"]
["3.3"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of hours:","Total budget:"]
["WP 4"]
["4.1"]
["4.2"]
["4.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of hours:","Total budget:"]
["WP 5"]
["5.1"]
["5.2"]
["5.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of hours:","Total budget:"]
[]
["Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of hours:","Total budget:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checklist for mandatory information in Gantt chart  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Involved project participants for each work package "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Acticity type for each work package (Research, Development or Demonstration)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Total number of hours for each work package"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Total budget for each work package\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Total number of hours"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Total budget"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Milestones in each workpackage. Each milestone must be assigned a delivery type according to the list of abbreviations in \"List of deliverable types\""]

{"sheet":"Example of a Gantt chart","index":2,"n_rows":62,"n_cols":21,"rows_kept":62,"cut":false,"hidden":false,"merged":[[4,2,4,5],[4,6,4,9],[4,10,4,13],[4,14,4,17]]}
[]
[]
["Example of Gantt chart"]
[]
[null,null,2022,null,null,null,2023,null,null,null,2024,null,null,null,2025,null,null,null,"Activity type (F/U/D)"]
[null,"Involved project participants","Jan","Apr","Jul","Oct","Jan","Apr","Jul ","Oct","Jan","Apr","Jul","Oct","Jan","Apr","Jul","Oct","and delivery type, see Sheet \"List of deliverable types\"","Number of hours","WP budget"]
["WP 1: Planning of research project","Name of responsible (Resp.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U","No. of hours company 1: 100"]
["1.1: Selection of xxxx","Participant 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of hours company 2: 225"]
["1.2: Meetings with relevant professionals","Participant 2"]
["1.3: Total assessment of xxxx","Participant 3"]
[null,"Participant 4"]
["Milestones:"]
["M 1.1: Research set-up",null,"x"]
["M 1.2: Meetings with professionals conducted",null,"x"]
["M 1.3: Internal research-protocol prepared",null,null,null,"UF1","UF3",null,null,null,null,null,null,null,null,null,null,null,null,"UF1 and UF3",null,"Total budget: 210.843 DKK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of hours: 325","(incl. OH)"]
["WP 2: First study","Name of responsible (Resp.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F","No. of hours company 1: 160"]
["2.1: Locate suitable herds","Participant 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of hours company 2: 310"]
["2.2: Take samples","Participant 2"]
["2.3: Analysis and assessment of xxxx","Participant 3"]
["2.4: Processing of results","Participant 4"]
[]
["Milestones:"]
["M 2.1:  Signed agreements with herds",null,null,null,"x"]
["M 2.2: Research report",null,null,null,null,null,"FV4",null,null,null,null,null,null,null,null,null,null,null,"FV4"]
["M 2.3: Manuscript",null,null,null,null,null,null,"FV1",null,null,null,null,null,null,null,null,null,null,"FV1",null,"Total budget: 192.378 DKK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of hours: 470","(incl. OH)"]
["WP 3: Test of xxxx","Name of responsible (Resp.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F","No. of hours company 1: 1269"]
["3.1: Visit herds","Participant 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of hours company 2: 800"]
["3.2: Conducting experiments","Participant 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of hours company 3: 200"]
["3.3: Analysis and assessment of xxxx","Participant 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of hours company 4: 854"]
["3.4: Publication","Participant 4"]
[]
["Milestones:"]
["M 3.1: Experiments on-site with herds",null,null,null,null,null,null,"x"]
["M 3.2: Research report",null,null,null,null,null,null,null,null,null,"FV4",null,null,null,null,null,null,null,"FV4"]
["M 3.3: Preparation of publication",null,null,null,null,null,null,null,null,null,null,"FV1",null,null,null,null,null,null,"FV1","Total number of hours: 3.123","Total budget: 2.019.307 DKK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(incl. OH)"]
["WP 4: Development of xxxx","Name of responsible (Resp.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U","No. of hours company 1: 617"]
["4.1 Ongoing evaluation of xxxx","Participant 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of hours company 2: 300"]
["4.2 Formulation of xxxx","Participant 2"]
[null,"Participant 3"]
["Milestones:","Participant 4"]
["M 4.1: Concept of prototype",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UP3, UP4",null,null,"UP3 and UP4",null,"Total budget: 620.732 DKK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of hours: 917","(incl. OH)"]
["WP 5: Development of xxxx","Name of responsible (Resp.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U, D","No. of hours company 1: 767"]
["5.1: Preparation of final experiments","Participant 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of hours company 2: 1736"]
["5.2. Conduct experiments","Participant 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of hours company 3: 320"]
["5.3: Conduct test of xxxx","Participant 3"]
["5.4: Statistical calculations","Participant 4"]
["5.5: Conduct meetings"]
[]
["Milestones:"]
["M 5.1: Workshop ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UF5",null,null,"UF5"]
["M 5.2: Try-outs of experiments",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["M 5.3: Statistical calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UF2",null,null,"UF2"]
["M 5.4: Publication of xxxx",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UF4","UF4"]
["M 5.5: Manuscript",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UF4",null,"UF4"]
["M 5.6: Meetings conducted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,"Total budget: 2.011.386 DKK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of hours: 2823","(incl. OH)"]
[]
["Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total accumulated no. of hours: 7.658","Totalt accumulated budget: 5.054.646 DKK"]

{"sheet":"List of deliverable types","index":3,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[25,4,25,5],[2,2,2,3],[8,2,8,3],[17,2,17,3],[20,4,20,5],[20,2,20,3],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[20,0,20,1],[1,6,1,7],[19,4,19,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[0,0,0,7],[2,6,2,7],[16,4,16,5],[17,4,17,5],[18,4,18,5],[16,0,16,1],[1,0,1,1],[8,0,8,1],[2,0,2,1],[17,0,17,1],[1,2,1,3],[1,4,1,5],[2,4,2,5],[11,4,11,5],[12,4,12,5],[3,4,3,5]]}
["List of deliverable types and abbrevations to be used when completing the Gantt chart for research, development and demonstration projects"]
["APPLIED RESEARCH",null,"DEVELOPMENT",null,"DEMONSTRATION",null,"NETVÆRK"]
["Scientific production",null,"New products, processes etc.",null,"New products, processes etc.",null,"Leveringstyper"]
["International journal (peer reviewed)","FV1","New or significantly improved product","UP1",null,null,"Potentielle udviklingsarbejder konkretiserede","N1"]
["Danish journal (peer reviewed)","FV2","New or significantly improved production process","UP2",null,null,"Analyser, udredninger, strategier udarbejdet","N2"]
["Proceedings (whole, not single papers) and working papers","FV3","New concepts etc.","UP3",null,null,"Mindre udredninger/ notater udarbejdet","N3"]
["Research report","FV4","Prototypes","UP4",null,null,"Kronikker, avisinterview, debatartikler","N4"]
["Conference presentation incl. paper/abstract/poster (scientific conference)","FV5","Pilot plant","UP5",null,null,"Artikler i fagtidsskrifter eller fagspecifikke aviser","N5"]
["Commercialization and application",null,"Commercialization and application",null,"Commercialization and application",null,"Nyhedsbreve","N6"]
["Patents","FK1","Patents","UK1",null,null,"Hjemmesider tilknyttet til netværket/partnerskabet","N7"]
["-           Novelty study",null,"-           Novelty study",null,null,null,"Andet (beskrives særskilt)","N8"]
["-           Submission of application",null,"-           Submission of application"]
["-           Patent approval",null,"-           Patent approval"]
["-           Agreement on commercial application",null,"-           Agreement on commercial application"]
["Strategic method development and authority procedure","FK2","Trademark protection","UK2"]
["Other type of commercialization","FK3","Certification/test (not required by law)","UK3"]
[null,null,"Other kinds of commercialization, including changes in technical standards, changes in advisory standards etc.","UK4"]
["Software programs",null,"Software programs",null,"Software programs"]
["Internal application","FS1","Internal application","US1"]
["External application","FS2","External application","US2"]
["Communication and dissemination",null,"Communication and dissemination",null,"Communication and dissemination"]
["Major reports and analyses, more than 50 pages","FF1","Major reports and analyses, more than 50 pages","UF1","Dissemination via practical showcasing","DF1"]
["Minor reports/briefs incl. teaching material (research level)","FF2","Minor reports/briefs incl. Teaching material (advisory level)","UF2","Technical manuals, fact sheets etc. incl. teaching material  (end-user level)","DF2"]
["Articles in subject specific journals and newspapers","FF3","Technical manuals, fact sheets etc.","UF3","Articles in subject-specific journals and newspapers","DF3"]
["Thematic issues in relation to the project","FF4","Articles in subject-specific journals and newspapers","UF4","Thematic meetings / Workshops / Meetings / Open house arrangements / Presentations / Video / Podcast  /Training (end-user level)","DF4"]
["Thematic meetings / Workshops / Meetings / Open house arrangements  / Presentations / Video / Podcast / Presentation at non-scientific conferences / Training (research level)","FF5","Thematic meetings / Workshops / Meetings / Open house arrangements / Presentations at such events  /  Video / Podcast / Training (advisory level)","UF5"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]

{"sheet":"Validations","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Company size",null,"Activity type:"]
[null,"Individual","Collaboration","Individual","Collaboration"]
[null,"Public research and knowledge dissemination organization","Public research and knowledge dissemination organization","Research","Research"]
[null,"Private research and knowledge dissemination organization","Private research and knowledge dissemination organization","Development","Development"]
[null,"Small company","Small company","Demonstration","Demonstration"]
[null,"Medium-sized company","Medium-sized company"]
[null,"Large company","Large company"]

{"sheet":"Total project budget","index":5,"n_rows":333,"n_cols":17,"rows_kept":333,"cut":false,"hidden":true,"merged":[[302,4,302,5],[318,4,318,5],[14,10,17,13],[222,4,222,5],[238,4,238,5],[254,4,254,5],[270,4,270,5],[286,4,286,5],[142,4,142,5],[158,4,158,5],[174,4,174,5],[190,4,190,5],[206,4,206,5],[62,4,62,5],[78,4,78,5],[94,4,94,5],[1,3,1,4],[3,9,3,11],[4,9,4,11],[110,4,110,5],[126,4,126,5],[46,4,46,5],[14,4,14,5],[30,4,30,5]]}
["Project title:"]
[null,null,null,"Total project budget is filled in automatically"]
[null,"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours"]
["Salary",{"$f":"B20+B36+B52+B68+B84+B100+B116+B132+B148+B164+B180+B196+B212+B228+B244+B260+B276+B292+B308+B324","v":0},{"$f":"C20+C36+C52+C68+C84+C100+C116+C132+C148+C164+C180+C196+C212+C228+C244+C260+C276+C292+C308+C324","v":0},0,0,0,0,null,null,"Journal no.: 34009-22-XXXX"]
["External assistance",{"$f":"B21+B37+B53+B69+B85+B101+B117+B133+B149+B165+B181+B197+B213+B229+B245+B261+B277+B293+B309+B325","v":0},0,0,0,0,0,null,null,"Approved from: XX-XX-XXXX"]
["Other costs",{"$f":"B22+B38+B54+B70+B86+B102+B118+B134+B150+B166+B182+B198+B214+B230+B246+B262+B278+B294+B310+B326","v":0},0,0,0,0,0]
["Apparatus/equipment",{"$f":"B23+B39+B55+B71+B87+B103+B119+B135+B151+B167+B183+B199+B215+B231+B247+B263+B279+B295+B311+B327","v":0},0,0,0,0,0]
["Scrap value",{"$f":"B24+B40+B56+B72+B88+B104+B120+B136+B152+B168+B184+B200+B216+B232+B248+B264+B280+B296+B312+B328","v":0},0,0,0,0,0]
["Income, if any",{"$f":"B25+B41+B57+B73+B89+B105+B121+B137+B153+B169+B185+B201+B217+B233+B249+B265+B281+B297+B313+B329","v":0},0,0,0,0,0]
["Audit costs",{"$f":"B26+B42+B58+B74+B90+B106+B122+B138+B154+B170+B186+B202+B218+B234+B250+B266+B282+B298+B314+B330","v":0},0,{"$f":"D26+D42+D58+D74+D90+D106+D122+D138+D154+D170+D186+D202+D218+D234+D250+D266+D282+D298+D314+D330","v":0},0,0,0]
["Total excl. OH",{"$f":"B27+B43+B59+B75+B91+B107+B123+B139+B155+B171+B187+B203+B219+B235+B251+B267+B283+B299+B315+B331","v":0},0,0,0,0,0]
["OH",{"$f":"B28+B44+B60+B76+B92+B108+B124+B140+B156+B172+B188+B204+B220+B236+B252+B268+B284+B300+B316+B332","v":0},0,0,0,0,0]
["Total",{"$f":"B29+B45+B61+B77+B93+B109+B125+B141+B157+B173+B189+B205+B221+B237+B253+B269+B285+B301+B317+B333","v":0},0,0,0,0,0]
[]
["Company name:",null,"Main applicant","Company size:",null,null,null,null,null,null,"Use this button to ensure, that you have filled in the data correctly. Red circles mark an error. Remember to look in the budget template to the left and in the grant percentage to the right."]
["Activity type:",null,{"$f":"IF(IF(G16=\"\",E16,G16)=\"\",0,IF(G16=\"\",E16,G16))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B16,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E15,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E15=\"\",0,IF(LEFT(E15,6)=\"Public\",B27*0.44,B20*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E15=\"\",\"\",IF(E15=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E15=\"\",\"\",IF(LEFT(E15,6)=\"Public\",B27*0.44-B28,B20*0.3-B28))","v":""}]
[]
[{"$f":"IF(B29>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q29=\"\",\"\",IF(RIGHT(E15,10)=\"Virksomhed\",IF(SUM(Q20:Q28)/COUNT(Q20:Q28)<>Q29,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$16=\"\",IF(E20=\"\",B20*$E$16,E20),IF(E20=\"\",B20*$G$16,E20)),0)","v":0},{"$f":"IFERROR(B20-C20-F20,0)","v":0},null,null,null,{"$f":"IF(B20=\"\",0,B20)","v":0},{"$f":"IF($E$15<>\"Public research and knowledge dissemination organization\",0,IF(B20=\"\",0,B20))","v":0},null,null,null,null,null,null,{"$f":"A20","v":"Salary"},{"$f":"IFERROR(C20/B20,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B21-C21-F21,0)","v":0},null,null,null,{"$f":"IF(B21=\"\",0,B21)","v":0},0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B20:B26)","v":0},0,0,0,0,{"$f":"SUM(G20:G26)","v":0},0,0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$16=\"\",IF(E28=\"\",B28*$E$16,E28),IF(E28=\"\",B28*$G$16,E28)),0)","v":0},{"$f":"IFERROR(B28-C28-F28,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B20:B26)+B28","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 2","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G32=\"\",E32,G32)=\"\",0,IF(G32=\"\",E32,G32))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B32,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E31,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E31=\"\",0,IF(LEFT(E31,6)=\"Public\",B43*0.44,B36*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E31=\"\",\"\",IF(E31=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E31=\"\",\"\",IF(LEFT(E31,6)=\"Public\",B43*0.44-B44,B36*0.3-B44))","v":""}]
[]
[{"$f":"IF(B45>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q45=\"\",\"\",IF(RIGHT(E31,10)=\"Virksomhed\",IF(SUM(Q36:Q44)/COUNT(Q36:Q44)<>Q45,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$32=\"\",IF(E36=\"\",B36*$E$32,E36),IF(E36=\"\",B36*$G$32,E36)),0)","v":0},{"$f":"IFERROR(B36-C36-F36,0)","v":0},null,null,null,{"$f":"IF(B36=\"\",0,B36)","v":0},{"$f":"IF($E$31<>\"Public research and knowledge dissemination organization\",0,IF(B36=\"\",0,B36))","v":0},null,null,null,null,null,null,{"$f":"A36","v":"Salary"},{"$f":"IFERROR(C36/B36,\"\")","v":""}]
["External assistance",null,{"$f":"IFERROR(IF($G$32=\"\",IF(E37=\"\",B37*$E$32,E37),IF(E37=\"\",B37*$G$32,E37)),0)","v":0},{"$f":"IFERROR(B37-C37-F37,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B36:B42)","v":0},{"$f":"SUM(C36:C42)","v":0},{"$f":"SUM(D36:D42)","v":0},{"$f":"SUM(E36:E42)","v":0},{"$f":"SUM(F36:F42)","v":0},{"$f":"SUM(G36:G42)","v":0},{"$f":"SUM(H36:H42)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$32=\"\",IF(E44=\"\",B44*$E$32,E44),IF(E44=\"\",B44*$G$32,E44)),0)","v":0},{"$f":"IFERROR(B44-C44-F44,0)","v":0},null,null,null,{"$f":"IF(B44=\"\",0,B44)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B36:B42)+B44","v":0},{"$f":"SUM(C36:C42)+C44","v":0},{"$f":"SUM(D36:D42)+D44","v":0},{"$f":"SUM(E36:E42)+E44","v":0},{"$f":"SUM(F36:F42)+F44","v":0},{"$f":"SUM(G36:G42)+G44","v":0},{"$f":"SUM(H36:H42)+H44","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 3","Company size:","Private research and knowledge dissemination organization"]
["Activity type:","Research",{"$f":"IF(IF(G48=\"\",E48,G48)=\"\",0,IF(G48=\"\",E48,G48))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B48,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E47,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E47=\"\",0,IF(LEFT(E47,6)=\"Public\",B59*0.44,B52*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E47=\"\",\"\",IF(E47=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":0.3},"OH remaining amount",{"$f":"IF(E47=\"\",\"\",IF(LEFT(E47,6)=\"Public\",B59*0.44-B60,B52*0.3-B60))","v":0}]
[]
[{"$f":"IF(B61>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q61=\"\",\"\",IF(RIGHT(E47,10)=\"Virksomhed\",IF(SUM(Q52:Q60)/COUNT(Q52:Q60)<>Q61,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$48=\"\",IF(E52=\"\",B52*$E$48,E52),IF(E52=\"\",B52*$G$48,E52)),0)","v":0},{"$f":"IFERROR(B52-C52-F52,0)","v":0},null,null,null,{"$f":"IF(B52=\"\",0,B52)","v":0},{"$f":"IF($E$47<>\"Public research and knowledge dissemination organization\",0,IF(B52=\"\",0,B52))","v":0},null,null,null,null,null,null,{"$f":"A52","v":"Salary"},{"$f":"IFERROR(C52/B52,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B53-C53-F53,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B52:B58)","v":0},{"$f":"SUM(C52:C58)","v":0},{"$f":"SUM(D52:D58)","v":0},{"$f":"SUM(E52:E58)","v":0},{"$f":"SUM(F52:F58)","v":0},{"$f":"SUM(G52:G58)","v":0},{"$f":"SUM(H52:H58)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$48=\"\",IF(E60=\"\",B60*$E$48,E60),IF(E60=\"\",B60*$G$48,E60)),0)","v":0},{"$f":"IFERROR(B60-C60-F60,0)","v":0},null,null,null,{"$f":"IF(B60=\"\",0,B60)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B52:B58)+B60","v":0},{"$f":"SUM(C52:C58)+C60","v":0},{"$f":"SUM(D52:D58)+D60","v":0},{"$f":"SUM(E52:E58)+E60","v":0},{"$f":"SUM(F52:F58)+F60","v":0},{"$f":"SUM(G52:G58)+G60","v":0},{"$f":"SUM(H52:H58)+H60","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 4","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G64=\"\",E64,G64)=\"\",0,IF(G64=\"\",E64,G64))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B64,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E63,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E63=\"\",0,IF(LEFT(E63,6)=\"Public\",B75*0.44,B68*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E63=\"\",\"\",IF(E63=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E63=\"\",\"\",IF(LEFT(E63,6)=\"Public\",B75*0.44-B76,B68*0.3-B76))","v":""}]
[]
[{"$f":"IF(B77>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q77=\"\",\"\",IF(RIGHT(E63,10)=\"Virksomhed\",IF(SUM(Q68:Q76)/COUNT(Q68:Q76)<>Q77,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$64=\"\",IF(E68=\"\",B68*$E$64,E68),IF(E68=\"\",B68*$G$64,E68)),0)","v":0},{"$f":"IFERROR(B68-C68,-F680)","v":0},null,null,null,{"$f":"IF(B68=\"\",0,B68)","v":0},{"$f":"IF($E$63<>\"Public research and knowledge dissemination organization\",0,IF(B68=\"\",0,B68))","v":0},null,null,null,null,null,null,{"$f":"A68","v":"Salary"},{"$f":"IFERROR(C68/B68,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B69-C69,-F681)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B68:B74)","v":0},{"$f":"SUM(C68:C74)","v":0},{"$f":"SUM(D68:D74)","v":0},{"$f":"SUM(E68:E74)","v":0},{"$f":"SUM(F68:F74)","v":0},{"$f":"SUM(G68:G74)","v":0},{"$f":"SUM(H68:H74)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$64=\"\",IF(E76=\"\",B76*$E$64,E76),IF(E76=\"\",B76*$G$64,E76)),0)","v":0},{"$f":"IFERROR(B76-C76-F76,0)","v":0},null,null,null,{"$f":"IF(B76=\"\",0,B76)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B68:B74)+B76","v":0},{"$f":"SUM(C68:C74)+C76","v":0},{"$f":"SUM(D68:D74)+D76","v":0},{"$f":"SUM(E68:E74)+E76","v":0},{"$f":"SUM(F68:F74)+F76","v":0},{"$f":"SUM(G68:G74)+G76","v":0},{"$f":"SUM(H68:H74)+H76","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 5","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G80=\"\",E80,G80)=\"\",0,IF(G80=\"\",E80,G80))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B80,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E79,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E79=\"\",0,IF(LEFT(E79,6)=\"Public\",B91*0.44,B84*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E79=\"\",\"\",IF(E79=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E79=\"\",\"\",IF(LEFT(E79,6)=\"Public\",B91*0.44-B92,B84*0.3-B92))","v":""}]
[]
[{"$f":"IF(B93>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q93=\"\",\"\",IF(RIGHT(E79,10)=\"Virksomhed\",IF(SUM(Q84:Q92)/COUNT(Q84:Q92)<>Q93,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$80=\"\",IF(E84=\"\",B84*$E$80,E84),IF(E84=\"\",B84*$G$80,E84)),0)","v":0},{"$f":"IFERROR(B84-C84-F84,0)","v":0},null,null,null,{"$f":"IF(B84=\"\",0,B84)","v":0},{"$f":"IF($E$79<>\"Public research and knowledge dissemination organization\",0,IF(B84=\"\",0,B84))","v":0},null,null,null,null,null,null,{"$f":"A84","v":"Salary"},{"$f":"IFERROR(C84/B84,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B85-C85-F85,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B84:B90)","v":0},{"$f":"SUM(C84:C90)","v":0},{"$f":"SUM(D84:D90)","v":0},{"$f":"SUM(E84:E90)","v":0},{"$f":"SUM(F84:F90)","v":0},{"$f":"SUM(G84:G90)","v":0},{"$f":"SUM(H84:H90)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$80=\"\",IF(E92=\"\",B92*$E$80,E92),IF(E92=\"\",B92*$G$80,E92)),0)","v":0},{"$f":"IFERROR(B92-C92-F92,0)","v":0},null,null,null,{"$f":"IF(B92=\"\",0,B92)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B84:B90)+B92","v":0},{"$f":"SUM(C84:C90)+C92","v":0},{"$f":"SUM(D84:D90)+D92","v":0},{"$f":"SUM(E84:E90)+E92","v":0},{"$f":"SUM(F84:F90)+F92","v":0},{"$f":"SUM(G84:G90)+G92","v":0},{"$f":"SUM(H84:H90)+H92","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 6","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G96=\"\",E96,G96)=\"\",0,IF(G96=\"\",E96,G96))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B96,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E95,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E95=\"\",0,IF(LEFT(E95,6)=\"Public\",B107*0.44,B100*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E95=\"\",\"\",IF(E95=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E95=\"\",\"\",IF(LEFT(E95,6)=\"Public\",B107*0.44-B108,B100*0.3-B108))","v":""}]
[]
[{"$f":"IF(B109>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q109=\"\",\"\",IF(RIGHT(E95,10)=\"Virksomhed\",IF(SUM(Q100:Q108)/COUNT(Q100:Q108)<>Q109,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$96=\"\",IF(E100=\"\",B100*$E$96,E100),IF(E100=\"\",B100*$G$96,E100)),0)","v":0},{"$f":"IFERROR(B100-C100-F100,0)","v":0},null,null,null,{"$f":"IF(B100=\"\",0,B100)","v":0},{"$f":"IF($E$95<>\"Public research and knowledge dissemination organization\",0,IF(B100=\"\",0,B100))","v":0},null,null,null,null,null,null,{"$f":"A100","v":"Salary"},{"$f":"IFERROR(C100/B100,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B101-C101-F101,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B100:B106)","v":0},{"$f":"SUM(C100:C106)","v":0},{"$f":"SUM(D100:D106)","v":0},{"$f":"SUM(E100:E106)","v":0},{"$f":"SUM(F100:F106)","v":0},{"$f":"SUM(G100:G106)","v":0},{"$f":"SUM(H100:H106)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$96=\"\",IF(E108=\"\",B108*$E$96,E108),IF(E108=\"\",B108*$G$96,E108)),0)","v":0},{"$f":"IFERROR(B108-C108-F108,0)","v":0},null,null,null,{"$f":"IF(B108=\"\",0,B108)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B100:B106)+B108","v":0},{"$f":"SUM(C100:C106)+C108","v":0},{"$f":"SUM(D100:D106)+D108","v":0},{"$f":"SUM(E100:E106)+E108","v":0},{"$f":"SUM(F100:F106)+F108","v":0},{"$f":"SUM(G100:G106)+G108","v":0},{"$f":"SUM(H100:H106)+H108","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 7","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G112=\"\",E112,G112)=\"\",0,IF(G112=\"\",E112,G112))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B112,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E111,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E111=\"\",0,IF(LEFT(E111,6)=\"Public\",B123*0.44,B116*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E111=\"\",\"\",IF(E111=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E111=\"\",\"\",IF(LEFT(E111,6)=\"Public\",B123*0.44-B124,B116*0.3-B124))","v":""}]
[]
[{"$f":"IF(B125>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q125=\"\",\"\",IF(RIGHT(E111,10)=\"Virksomhed\",IF(SUM(Q116:Q124)/COUNT(Q116:Q124)<>Q125,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$112=\"\",IF(E116=\"\",B116*$E$112,E116),IF(E116=\"\",B116*$G$112,E116)),0)","v":0},{"$f":"IFERROR(B116-C116-F116,0)","v":0},null,null,null,{"$f":"IF(B116=\"\",0,B116)","v":0},{"$f":"IF($E$111<>\"Public research and knowledge dissemination organization\",0,IF(B116=\"\",0,B116))","v":0},null,null,null,null,null,null,{"$f":"A116","v":"Salary"},{"$f":"IFERROR(C116/B116,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B117-C117-F117,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B116:B122)","v":0},{"$f":"SUM(C116:C122)","v":0},{"$f":"SUM(D116:D122)","v":0},{"$f":"SUM(E116:E122)","v":0},{"$f":"SUM(F116:F122)","v":0},{"$f":"SUM(G116:G122)","v":0},{"$f":"SUM(H116:H122)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$112=\"\",IF(E124=\"\",B124*$E$112,E124),IF(E124=\"\",B124*$G$112,E124)),0)","v":0},{"$f":"IFERROR(B124-C124-F124,0)","v":0},null,null,null,{"$f":"IF(B124=\"\",0,B124)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B116:B122)+B124","v":0},{"$f":"SUM(C116:C122)+C124","v":0},{"$f":"SUM(D116:D122)+D124","v":0},{"$f":"SUM(E116:E122)+E124","v":0},{"$f":"SUM(F116:F122)+F124","v":0},{"$f":"SUM(G116:G122)+G124","v":0},{"$f":"SUM(H116:H122)+H124","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 8","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G128=\"\",E128,G128)=\"\",0,IF(G128=\"\",E128,G128))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B128,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E127,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E127=\"\",0,IF(LEFT(E127,6)=\"Public\",B139*0.44,B132*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E127=\"\",\"\",IF(E127=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E127=\"\",\"\",IF(LEFT(E127,6)=\"Public\",B139*0.44-B140,B132*0.3-B140))","v":""}]
[]
[{"$f":"IF(B141>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q141=\"\",\"\",IF(RIGHT(E127,10)=\"Virksomhed\",IF(SUM(Q132:Q140)/COUNT(Q132:Q140)<>Q141,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$128=\"\",IF(E132=\"\",B132*$E$128,E132),IF(E132=\"\",B132*$G$128,E132)),0)","v":0},{"$f":"IFERROR(B132-C132-F132,0)","v":0},null,null,null,{"$f":"IF(B132=\"\",0,B132)","v":0},{"$f":"IF($E$127<>\"Public research and knowledge dissemination organization\",0,IF(B132=\"\",0,B132))","v":0},null,null,null,null,null,null,{"$f":"A132","v":"Salary"},{"$f":"IFERROR(C132/B132,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B133-C133-F133,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B132:B138)","v":0},{"$f":"SUM(C132:C138)","v":0},{"$f":"SUM(D132:D138)","v":0},{"$f":"SUM(E132:E138)","v":0},{"$f":"SUM(F132:F138)","v":0},{"$f":"SUM(G132:G138)","v":0},{"$f":"SUM(H132:H138)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$128=\"\",IF(E140=\"\",B140*$E$128,E140),IF(E140=\"\",B140*$G$128,E140)),0)","v":0},{"$f":"IFERROR(B140-C140-F140,0)","v":0},null,null,null,{"$f":"IF(B140=\"\",0,B140)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B132:B138)+B140","v":0},{"$f":"SUM(C132:C138)+C140","v":0},{"$f":"SUM(D132:D138)+D140","v":0},{"$f":"SUM(E132:E138)+E140","v":0},{"$f":"SUM(F132:F138)+F140","v":0},{"$f":"SUM(G132:G138)+G140","v":0},{"$f":"SUM(H132:H138)+H140","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 9","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G144=\"\",E144,G144)=\"\",0,IF(G144=\"\",E144,G144))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B144,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E143,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E143=\"\",0,IF(LEFT(E143,6)=\"Public\",B155*0.44,B148*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E143=\"\",\"\",IF(E143=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E143=\"\",\"\",IF(LEFT(E143,6)=\"Public\",B155*0.44-B156,B148*0.3-B156))","v":""}]
[]
[{"$f":"IF(B157>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q157=\"\",\"\",IF(RIGHT(E143,10)=\"Virksomhed\",IF(SUM(Q148:Q156)/COUNT(Q148:Q156)<>Q157,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$144=\"\",IF(E148=\"\",B148*$E$144,E148),IF(E148=\"\",B148*$G$144,E148)),0)","v":0},{"$f":"IFERROR(B148-C148-F148,0)","v":0},null,null,null,{"$f":"IF(B148=\"\",0,B148)","v":0},{"$f":"IF($E$143<>\"Public research and knowledge dissemination organization\",0,IF(B148=\"\",0,B148))","v":0},null,null,null,null,null,null,{"$f":"A148","v":"Salary"},{"$f":"IFERROR(C148/B148,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B149-C149-F149,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B148:B154)","v":0},{"$f":"SUM(C148:C154)","v":0},{"$f":"SUM(D148:D154)","v":0},{"$f":"SUM(E148:E154)","v":0},{"$f":"SUM(F148:F154)","v":0},{"$f":"SUM(G148:G154)","v":0},{"$f":"SUM(H148:H154)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$144=\"\",IF(E156=\"\",B156*$E$144,E156),IF(E156=\"\",B156*$G$144,E156)),0)","v":0},{"$f":"IFERROR(B156-C156-F156,0)","v":0},null,null,null,{"$f":"IF(B156=\"\",0,B156)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B148:B154)+B156","v":0},{"$f":"SUM(C148:C154)+C156","v":0},{"$f":"SUM(D148:D154)+D156","v":0},{"$f":"SUM(E148:E154)+E156","v":0},{"$f":"SUM(F148:F154)+F156","v":0},{"$f":"SUM(G148:G154)+G156","v":0},{"$f":"SUM(H148:H154)+H156","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 10","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G160=\"\",E160,G160)=\"\",0,IF(G160=\"\",E160,G160))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B160,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E159,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E159=\"\",0,IF(LEFT(E159,6)=\"Public\",B171*0.44,B164*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E159=\"\",\"\",IF(E159=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E159=\"\",\"\",IF(LEFT(E159,6)=\"Public\",B171*0.44-B172,B164*0.3-B172))","v":""}]
[]
[{"$f":"IF(B173>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q173=\"\",\"\",IF(RIGHT(E159,10)=\"Virksomhed\",IF(SUM(Q164:Q172)/COUNT(Q164:Q172)<>Q173,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$160=\"\",IF(E164=\"\",B164*$E$160,E164),IF(E164=\"\",B164*$G$160,E164)),0)","v":0},{"$f":"IFERROR(B164-C164-F164,0)","v":0},null,null,null,{"$f":"IF(B164=\"\",0,B164)","v":0},{"$f":"IF($E$159<>\"Public research and knowledge dissemination organization\",0,IF(B164=\"\",0,B164))","v":0},null,null,null,null,null,null,{"$f":"A164","v":"Salary"},{"$f":"IFERROR(C164/B164,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B165-C165-F165,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B164:B170)","v":0},{"$f":"SUM(C164:C170)","v":0},{"$f":"SUM(D164:D170)","v":0},{"$f":"SUM(E164:E170)","v":0},{"$f":"SUM(F164:F170)","v":0},{"$f":"SUM(G164:G170)","v":0},{"$f":"SUM(H164:H170)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$160=\"\",IF(E172=\"\",B172*$E$160,E172),IF(E172=\"\",B172*$G$160,E172)),0)","v":0},{"$f":"IFERROR(B172-C172-F172,0)","v":0},null,null,null,{"$f":"IF(B172=\"\",0,B172)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B164:B170)+B172","v":0},{"$f":"SUM(C164:C170)+C172","v":0},{"$f":"SUM(D164:D170)+D172","v":0},{"$f":"SUM(E164:E170)+E172","v":0},{"$f":"SUM(F164:F170)+F172","v":0},{"$f":"SUM(G164:G170)+G172","v":0},{"$f":"SUM(H164:H170)+H172","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 11","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G176=\"\",E176,G176)=\"\",0,IF(G176=\"\",E176,G176))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B176,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E175,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E175=\"\",0,IF(LEFT(E175,6)=\"Public\",B187*0.44,B180*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E175=\"\",\"\",IF(E175=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E175=\"\",\"\",IF(LEFT(E175,6)=\"Public\",B187*0.44-B188,B180*0.3-B188))","v":""}]
[]
[{"$f":"IF(B189>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q189=\"\",\"\",IF(RIGHT(E175,10)=\"Virksomhed\",IF(SUM(Q180:Q188)/COUNT(Q180:Q188)<>Q189,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$176=\"\",IF(E180=\"\",B180*$E$176,E180),IF(E180=\"\",B180*$G$176,E180)),0)","v":0},{"$f":"IFERROR(B180-C180-F180,0)","v":0},null,null,null,{"$f":"IF(B180=\"\",0,B180)","v":0},{"$f":"IF($E$175<>\"Public research and knowledge dissemination organization\",0,IF(B180=\"\",0,B180))","v":0},null,null,null,null,null,null,{"$f":"A180","v":"Salary"},{"$f":"IFERROR(C180/B180,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B181-C181-F181,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B180:B186)","v":0},{"$f":"SUM(C180:C186)","v":0},{"$f":"SUM(D180:D186)","v":0},{"$f":"SUM(E180:E186)","v":0},{"$f":"SUM(F180:F186)","v":0},{"$f":"SUM(G180:G186)","v":0},{"$f":"SUM(H180:H186)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$176=\"\",IF(E188=\"\",B188*$E$176,E188),IF(E188=\"\",B188*$G$176,E188)),0)","v":0},{"$f":"IFERROR(B188-C188-F188,0)","v":0},null,null,null,{"$f":"IF(B188=\"\",0,B188)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B180:B186)+B188","v":0},{"$f":"SUM(C180:C186)+C188","v":0},{"$f":"SUM(D180:D186)+D188","v":0},{"$f":"SUM(E180:E186)+E188","v":0},{"$f":"SUM(F180:F186)+F188","v":0},{"$f":"SUM(G180:G186)+G188","v":0},{"$f":"SUM(H180:H186)+H188","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 12","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G192=\"\",E192,G192)=\"\",0,IF(G192=\"\",E192,G192))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B192,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E191,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E191=\"\",0,IF(LEFT(E191,6)=\"Public\",B203*0.44,B196*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E191=\"\",\"\",IF(E191=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E191=\"\",\"\",IF(LEFT(E191,6)=\"Public\",B203*0.44-B204,B196*0.3-B204))","v":""}]
[]
[{"$f":"IF(B205>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q205=\"\",\"\",IF(RIGHT(E191,10)=\"Virksomhed\",IF(SUM(Q196:Q204)/COUNT(Q196:Q204)<>Q205,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$192=\"\",IF(E196=\"\",B196*$E$192,E196),IF(E196=\"\",B196*$G$192,E196)),0)","v":0},{"$f":"IFERROR(B196-C196-F196,0)","v":0},null,null,null,{"$f":"IF(B196=\"\",0,B196)","v":0},{"$f":"IF($E$191<>\"Public research and knowledge dissemination organization\",0,IF(B196=\"\",0,B196))","v":0},null,null,null,null,null,null,{"$f":"A196","v":"Salary"},{"$f":"IFERROR(C196/B196,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B197-C197-F197,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B196:B202)","v":0},{"$f":"SUM(C196:C202)","v":0},{"$f":"SUM(D196:D202)","v":0},{"$f":"SUM(E196:E202)","v":0},{"$f":"SUM(F196:F202)","v":0},{"$f":"SUM(G196:G202)","v":0},{"$f":"SUM(H196:H202)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$192=\"\",IF(E204=\"\",B204*$E$192,E204),IF(E204=\"\",B204*$G$192,E204)),0)","v":0},{"$f":"IFERROR(B204-C204-F204,0)","v":0},null,null,null,{"$f":"IF(B204=\"\",0,B204)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B196:B202)+B204","v":0},{"$f":"SUM(C196:C202)+C204","v":0},{"$f":"SUM(D196:D202)+D204","v":0},{"$f":"SUM(E196:E202)+E204","v":0},{"$f":"SUM(F196:F202)+F204","v":0},{"$f":"SUM(G196:G202)+G204","v":0},{"$f":"SUM(H196:H202)+H204","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 13","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G208=\"\",E208,G208)=\"\",0,IF(G208=\"\",E208,G208))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B208,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E207,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E207=\"\",0,IF(LEFT(E207,6)=\"Public\",B219*0.44,B212*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E207=\"\",\"\",IF(E207=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E207=\"\",\"\",IF(LEFT(E207,6)=\"Public\",B219*0.44-B220,B212*0.3-B220))","v":""}]
[]
[{"$f":"IF(B221>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q221=\"\",\"\",IF(RIGHT(E207,10)=\"Virksomhed\",IF(SUM(Q212:Q220)/COUNT(Q212:Q220)<>Q221,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$208=\"\",IF(E212=\"\",B212*$E$208,E212),IF(E212=\"\",B212*$G$208,E212)),0)","v":0},{"$f":"IFERROR(B212-C212-F212,0)","v":0},null,null,null,{"$f":"IF(B212=\"\",0,B212)","v":0},{"$f":"IF($E$207<>\"Public research and knowledge dissemination organization\",0,IF(B212=\"\",0,B212))","v":0},null,null,null,null,null,null,{"$f":"A212","v":"Salary"},{"$f":"IFERROR(C212/B212,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B213-C213-F213,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B212:B218)","v":0},{"$f":"SUM(C212:C218)","v":0},{"$f":"SUM(D212:D218)","v":0},{"$f":"SUM(E212:E218)","v":0},{"$f":"SUM(F212:F218)","v":0},{"$f":"SUM(G212:G218)","v":0},{"$f":"SUM(H212:H218)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$208=\"\",IF(E220=\"\",B220*$E$208,E220),IF(E220=\"\",B220*$G$208,E220)),0)","v":0},{"$f":"IFERROR(B220-C220-F220,0)","v":0},null,null,null,{"$f":"IF(B220=\"\",0,B220)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B212:B218)+B220","v":0},{"$f":"SUM(C212:C218)+C220","v":0},{"$f":"SUM(D212:D218)+D220","v":0},{"$f":"SUM(E212:E218)+E220","v":0},{"$f":"SUM(F212:F218)+F220","v":0},{"$f":"SUM(G212:G218)+G220","v":0},{"$f":"SUM(H212:H218)+H220","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 14","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G224=\"\",E224,G224)=\"\",0,IF(G224=\"\",E224,G224))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B224,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E223,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E223=\"\",0,IF(LEFT(E223,6)=\"Public\",B235*0.44,B228*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E223=\"\",\"\",IF(E223=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E223=\"\",\"\",IF(LEFT(E223,6)=\"Public\",B235*0.44-B236,B228*0.3-B236))","v":""}]
[]
[{"$f":"IF(B237>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q237=\"\",\"\",IF(RIGHT(E223,10)=\"Virksomhed\",IF(SUM(Q228:Q236)/COUNT(Q228:Q236)<>Q237,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$224=\"\",IF(E228=\"\",B228*$E$224,E228),IF(E228=\"\",B228*$G$224,E228)),0)","v":0},{"$f":"IFERROR(B228-C228-F228,0)","v":0},null,null,null,{"$f":"IF(B228=\"\",0,B228)","v":0},{"$f":"IF($E$223<>\"Public research and knowledge dissemination organization\",0,IF(B228=\"\",0,B228))","v":0},null,null,null,null,null,null,{"$f":"A228","v":"Salary"},{"$f":"IFERROR(C228/B228,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B229-C229-F229,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B228:B234)","v":0},{"$f":"SUM(C228:C234)","v":0},{"$f":"SUM(D228:D234)","v":0},{"$f":"SUM(E228:E234)","v":0},{"$f":"SUM(F228:F234)","v":0},{"$f":"SUM(G228:G234)","v":0},{"$f":"SUM(H228:H234)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$224=\"\",IF(E236=\"\",B236*$E$224,E236),IF(E236=\"\",B236*$G$224,E236)),0)","v":0},{"$f":"IFERROR(B236-C236-F236,0)","v":0},null,null,null,{"$f":"IF(B236=\"\",0,B236)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B228:B234)+B236","v":0},{"$f":"SUM(C228:C234)+C236","v":0},{"$f":"SUM(D228:D234)+D236","v":0},{"$f":"SUM(E228:E234)+E236","v":0},{"$f":"SUM(F228:F234)+F236","v":0},{"$f":"SUM(G228:G234)+G236","v":0},{"$f":"SUM(H228:H234)+H236","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 15","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G240=\"\",E240,G240)=\"\",0,IF(G240=\"\",E240,G240))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B240,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E239,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E239=\"\",0,IF(LEFT(E239,6)=\"Public\",B251*0.44,B244*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E239=\"\",\"\",IF(E239=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E239=\"\",\"\",IF(LEFT(E239,6)=\"Public\",B251*0.44-B252,B244*0.3-B252))","v":""}]
[]
[{"$f":"IF(B253>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q253=\"\",\"\",IF(RIGHT(E239,10)=\"Virksomhed\",IF(SUM(Q244:Q252)/COUNT(Q244:Q252)<>Q253,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$240=\"\",IF(E244=\"\",B244*$E$240,E244),IF(E244=\"\",B244*$G$240,E244)),0)","v":0},{"$f":"IFERROR(B244-C244-F244,0)","v":0},null,null,null,{"$f":"IF(B244=\"\",0,B244)","v":0},{"$f":"IF($E$239<>\"Public research and knowledge dissemination organization\",0,IF(B244=\"\",0,B244))","v":0},null,null,null,null,null,null,{"$f":"A244","v":"Salary"},{"$f":"IFERROR(C244/B244,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B245-C245-F245,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B244:B250)","v":0},{"$f":"SUM(C244:C250)","v":0},{"$f":"SUM(D244:D250)","v":0},{"$f":"SUM(E244:E250)","v":0},{"$f":"SUM(F244:F250)","v":0},{"$f":"SUM(G244:G250)","v":0},{"$f":"SUM(H244:H250)","v":0},0,null,null,null,null,null,null,"Total excl. OH",{"$f":"IFERROR(C251/B251,\"\")","v":""}]
["OH",null,{"$f":"IFERROR(IF($G$240=\"\",IF(E252=\"\",B252*$E$240,E252),IF(E252=\"\",B252*$G$240,E252)),0)","v":0},{"$f":"IFERROR(B252-C252-F252,0)","v":0},null,null,null,{"$f":"IF(B252=\"\",0,B252)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B244:B250)+B252","v":0},{"$f":"SUM(C244:C250)+C252","v":0},{"$f":"SUM(D244:D250)+D252","v":0},{"$f":"SUM(E244:E250)+E252","v":0},{"$f":"SUM(F244:F250)+F252","v":0},{"$f":"SUM(G244:G250)+G252","v":0},{"$f":"SUM(H244:H250)+H252","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 16","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G256=\"\",E256,G256)=\"\",0,IF(G256=\"\",E256,G256))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B256,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E255,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E255=\"\",0,IF(LEFT(E255,6)=\"Public\",B267*0.44,B260*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E255=\"\",\"\",IF(E255=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E255=\"\",\"\",IF(LEFT(E255,6)=\"Public\",B267*0.44-B268,B260*0.3-B268))","v":""}]
[]
[{"$f":"IF(B269>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q269=\"\",\"\",IF(RIGHT(E255,10)=\"Virksomhed\",IF(SUM(Q260:Q268)/COUNT(Q260:Q268)<>Q269,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$256=\"\",IF(E260=\"\",B260*$E$256,E260),IF(E260=\"\",B260*$G$256,E260)),0)","v":0},{"$f":"IFERROR(B260-C260-F260,0)","v":0},null,null,null,{"$f":"IF(B260=\"\",0,B260)","v":0},{"$f":"IF($E$255<>\"Public research and knowledge dissemination organization\",0,IF(B260=\"\",0,B260))","v":0},null,null,null,null,null,null,{"$f":"A260","v":"Salary"},{"$f":"IFERROR(C260/B260,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B261-C261-F261,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B260:B266)","v":0},{"$f":"SUM(C260:C266)","v":0},{"$f":"SUM(D260:D266)","v":0},{"$f":"SUM(E260:E266)","v":0},{"$f":"SUM(F260:F266)","v":0},{"$f":"SUM(G260:G266)","v":0},{"$f":"SUM(H260:H266)","v":0},0,null,null,null,null,null,null,"Total excl. OH",{"$f":"IFERROR(C267/B267,\"\")","v":""}]
["OH",null,{"$f":"IFERROR(IF($G$256=\"\",IF(E268=\"\",B268*$E$256,E268),IF(E268=\"\",B268*$G$256,E268)),0)","v":0},{"$f":"IFERROR(B268-C268-F268,0)","v":0},null,null,null,{"$f":"IF(B268=\"\",0,B268)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B260:B266)+B268","v":0},{"$f":"SUM(C260:C266)+C268","v":0},{"$f":"SUM(D260:D266)+D268","v":0},{"$f":"SUM(E260:E266)+E268","v":0},{"$f":"SUM(F260:F266)+F268","v":0},{"$f":"SUM(G260:G266)+G268","v":0},{"$f":"SUM(H260:H266)+H268","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 17","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G272=\"\",E272,G272)=\"\",0,IF(G272=\"\",E272,G272))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B272,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E271,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E271=\"\",0,IF(LEFT(E271,6)=\"Public\",B283*0.44,B276*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E271=\"\",\"\",IF(E271=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E271=\"\",\"\",IF(LEFT(E271,6)=\"Public\",B283*0.44-B284,B276*0.3-B284))","v":""}]
[]
[{"$f":"IF(B285>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q285=\"\",\"\",IF(RIGHT(E271,10)=\"Virksomhed\",IF(SUM(Q276:Q284)/COUNT(Q276:Q284)<>Q285,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$272=\"\",IF(E276=\"\",B276*$E$272,E276),IF(E276=\"\",B276*$G$272,E276)),0)","v":0},{"$f":"IFERROR(B276-C276-F276,0)","v":0},null,null,null,{"$f":"IF(B276=\"\",0,B276)","v":0},{"$f":"IF($E$271<>\"Public research and knowledge dissemination organization\",0,IF(B276=\"\",0,B276))","v":0},null,null,null,null,null,null,{"$f":"A276","v":"Salary"},{"$f":"IFERROR(C276/B276,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B277-C277-F277,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B276:B282)","v":0},{"$f":"SUM(C276:C282)","v":0},{"$f":"SUM(D276:D282)","v":0},{"$f":"SUM(E276:E282)","v":0},{"$f":"SUM(F276:F282)","v":0},{"$f":"SUM(G276:G282)","v":0},{"$f":"SUM(H276:H282)","v":0},0,null,null,null,null,null,null,"Total excl. OH",{"$f":"IFERROR(C283/B283,\"\")","v":""}]
["OH",null,{"$f":"IFERROR(IF($G$272=\"\",IF(E284=\"\",B284*$E$272,E284),IF(E284=\"\",B284*$G$272,E284)),0)","v":0},{"$f":"IFERROR(B284-C284-F284,0)","v":0},null,null,null,{"$f":"IF(B284=\"\",0,B284)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B276:B282)+B284","v":0},{"$f":"SUM(C276:C282)+C284","v":0},{"$f":"SUM(D276:D282)+D284","v":0},{"$f":"SUM(E276:E282)+E284","v":0},{"$f":"SUM(F276:F282)+F284","v":0},{"$f":"SUM(G276:G282)+G284","v":0},{"$f":"SUM(H276:H282)+H284","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 18","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G288=\"\",E288,G288)=\"\",0,IF(G288=\"\",E288,G288))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B288,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E287,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E287=\"\",0,IF(LEFT(E287,6)=\"Public\",B299*0.44,B292*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E287=\"\",\"\",IF(E287=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E287=\"\",\"\",IF(LEFT(E287,6)=\"Public\",B299*0.44-B300,B292*0.3-B300))","v":""}]
[]
[{"$f":"IF(B301>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q301=\"\",\"\",IF(RIGHT(E287,10)=\"Virksomhed\",IF(SUM(Q292:Q300)/COUNT(Q292:Q300)<>Q301,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$288=\"\",IF(E292=\"\",B292*$E$288,E292),IF(E292=\"\",B292*$G$288,E292)),0)","v":0},{"$f":"IFERROR(B292-C292-F292,0)","v":0},null,null,null,{"$f":"IF(B292=\"\",0,B292)","v":0},{"$f":"IF($E$287<>\"Public research and knowledge dissemination organization\",0,IF(B292=\"\",0,B292))","v":0},null,null,null,null,null,null,{"$f":"A292","v":"Salary"},{"$f":"IFERROR(C292/B292,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B293-C293-F293,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B292:B298)","v":0},{"$f":"SUM(C292:C298)","v":0},{"$f":"SUM(D292:D298)","v":0},{"$f":"SUM(E292:E298)","v":0},{"$f":"SUM(F292:F298)","v":0},{"$f":"SUM(G292:G298)","v":0},{"$f":"SUM(H292:H298)","v":0},0,null,null,null,null,null,null,"Total excl. OH",{"$f":"IFERROR(C299/B299,\"\")","v":""}]
["OH",null,{"$f":"IFERROR(IF($G$288=\"\",IF(E300=\"\",B300*$E$288,E300),IF(E300=\"\",B300*$G$288,E300)),0)","v":0},{"$f":"IFERROR(B300-C300-F300,0)","v":0},null,null,null,{"$f":"IF(B300=\"\",0,B300)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B292:B298)+B300","v":0},{"$f":"SUM(C292:C298)+C300","v":0},{"$f":"SUM(D292:D298)+D300","v":0},{"$f":"SUM(E292:E298)+E300","v":0},{"$f":"SUM(F292:F298)+F300","v":0},{"$f":"SUM(G292:G298)+G300","v":0},{"$f":"SUM(H292:H298)+H300","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 19","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G304=\"\",E304,G304)=\"\",0,IF(G304=\"\",E304,G304))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B304,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E303,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E303=\"\",0,IF(LEFT(E303,6)=\"Public\",B315*0.44,B308*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E303=\"\",\"\",IF(E303=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E303=\"\",\"\",IF(LEFT(E303,6)=\"Public\",B315*0.44-B316,B308*0.3-B316))","v":""}]
[]
[{"$f":"IF(B317>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q317=\"\",\"\",IF(RIGHT(E303,10)=\"Virksomhed\",IF(SUM(Q308:Q316)/COUNT(Q308:Q316)<>Q317,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$304=\"\",IF(E308=\"\",B308*$E$304,E308),IF(E308=\"\",B308*$G$304,E308)),0)","v":0},{"$f":"IFERROR(B308-C308-F308,0)","v":0},null,null,null,{"$f":"IF(B308=\"\",0,B308)","v":0},{"$f":"IF($E$303<>\"Public research and knowledge dissemination organization\",0,IF(B308=\"\",0,B308))","v":0},null,null,null,null,null,null,{"$f":"A308","v":"Salary"},{"$f":"IFERROR(C308/B308,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B309-C309-F309,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B308:B314)","v":0},{"$f":"SUM(C308:C314)","v":0},{"$f":"SUM(D308:D314)","v":0},{"$f":"SUM(E308:E314)","v":0},{"$f":"SUM(F308:F314)","v":0},{"$f":"SUM(G308:G314)","v":0},{"$f":"SUM(H308:H314)","v":0},0,null,null,null,null,null,null,"Total excl. OH",{"$f":"IFERROR(C315/B315,\"\")","v":""}]
["OH",null,{"$f":"IFERROR(IF($G$304=\"\",IF(E316=\"\",B316*$E$304,E316),IF(E316=\"\",B316*$G$304,E316)),0)","v":0},{"$f":"IFERROR(B316-C316-F316,0)","v":0},null,null,null,{"$f":"IF(B316=\"\",0,B316)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B308:B314)+B316","v":0},{"$f":"SUM(C308:C314)+C316","v":0},{"$f":"SUM(D308:D314)+D316","v":0},{"$f":"SUM(E308:E314)+E316","v":0},{"$f":"SUM(F308:F314)+F316","v":0},{"$f":"SUM(G308:G314)+G316","v":0},{"$f":"SUM(H308:H314)+H316","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 20","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G320=\"\",E320,G320)=\"\",0,IF(G320=\"\",E320,G320))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B320,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E319,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E319=\"\",0,IF(LEFT(E319,6)=\"Public\",B331*0.44,B324*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E319=\"\",\"\",IF(E319=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH remaining amount",{"$f":"IF(E319=\"\",\"\",IF(LEFT(E319,6)=\"Public\",B331*0.44-B332,B324*0.3-B332))","v":""}]
[]
[{"$f":"IF(B333>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                   GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q333=\"\",\"\",IF(RIGHT(E319,10)=\"Virksomhed\",IF(SUM(Q324:Q332)/COUNT(Q324:Q332)<>Q333,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary",null,{"$f":"IFERROR(IF($G$320=\"\",IF(E324=\"\",B324*$E$320,E324),IF(E324=\"\",B324*$G$320,E324)),0)","v":0},{"$f":"IFERROR(B324-C324-F324,0)","v":0},null,null,null,{"$f":"IF(B324=\"\",0,B324)","v":0},{"$f":"IF($E$319<>\"Public research and knowledge dissemination organization\",0,IF(B324=\"\",0,B324))","v":0},null,null,null,null,null,null,{"$f":"A324","v":"Salary"},{"$f":"IFERROR(C324/B324,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B325-C325-F325,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B324:B330)","v":0},{"$f":"SUM(C324:C330)","v":0},{"$f":"SUM(D324:D330)","v":0},{"$f":"SUM(E324:E330)","v":0},{"$f":"SUM(F324:F330)","v":0},{"$f":"SUM(G324:G330)","v":0},{"$f":"SUM(H324:H330)","v":0},0,null,null,null,null,null,null,"Total excl. OH",{"$f":"IFERROR(C331/B331,\"\")","v":""}]
["OH",null,{"$f":"IFERROR(IF($G$320=\"\",IF(E332=\"\",B332*$E$320,E332),IF(E332=\"\",B332*$G$320,E332)),0)","v":0},{"$f":"IFERROR(B332-C332-F332,0)","v":0},null,null,null,{"$f":"IF(B332=\"\",0,B332)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B324:B330)+B332","v":0},{"$f":"SUM(C324:C330)+C332","v":0},{"$f":"SUM(D324:D330)+D332","v":0},{"$f":"SUM(E324:E330)+E332","v":0},{"$f":"SUM(F324:F330)+F332","v":0},{"$f":"SUM(G324:G330)+G332","v":0},{"$f":"SUM(H324:H330)+H332","v":0},0,null,null,null,null,null,null,"Total",""]

{"sheet":"Ex. of individual project","index":6,"n_rows":333,"n_cols":17,"rows_kept":333,"cut":false,"hidden":true,"merged":[[318,4,318,5],[142,4,142,5],[158,4,158,5],[174,4,174,5],[190,4,190,5],[206,4,206,5],[222,4,222,5],[238,4,238,5],[254,4,254,5],[270,4,270,5],[286,4,286,5],[302,4,302,5],[126,4,126,5],[1,3,1,4],[3,9,3,11],[4,9,4,11],[14,4,14,5],[14,10,17,13],[30,4,30,5],[46,4,46,5],[62,4,62,5],[78,4,78,5],[94,4,94,5],[110,4,110,5]]}
["Project title:","Example of budget for a company with two acitvity types",null,null,null,null,null,"Individual"]
[null,null,null,"Total project budget is filled in automatically"]
[null,"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours"]
["Salary ",{"$f":"B20+B36+B52+B68+B84+B100+B116+B132+B148+B164+B180+B196+B212+B228+B244+B260+B276+B292+B308+B324","v":950000},{"$f":"C20+C36+C52+C68+C84+C100+C116+C132+C148+C164+C180+C196+C212+C228+C244+C260+C276+C292+C308+C324","v":452500},497500,0,0,3043,null,null,"Journal no: 34009-22-XXXX"]
["External assistance",16700,{"$f":"C21+C37+C53+C69+C85+C101+C117+C133+C149+C165+C181+C197+C213+C229+C245+C261+C277+C293+C309+C325","v":7515},9185,0,0,0,null,null,"Approved from: XX-XX-XXXX"]
["Other costs",150000,80000,70000,0,0,0]
["Apparatus/equipment",50000,22500,27500,0,0,0]
["Scrap value",-10000,-4500,-5500,0,0,0]
["Income, if any",0,0,0,0,0,0]
["Audit costs",36000,20700,15300,0,0,0]
["Total excl. OH",1192700,578715,613985,0,0,3043]
["OH",285000,135750,149250,0,0,0]
["Total",1477700,714465,763235,0,0,3043]
[]
["Company name:","The Little Green Company","Main applicant","Company size:","Small company",null,null,null,null,null,"Use this button to ensure, that you have filled in the data correctly. Red circles mark an error. Remember to look in the budget-template to the left and in the grant percentage to the right."]
["Activity type:","Development",{"$f":"IF(IF(G16=\"\",E16,G16)=\"\",0,IF(G16=\"\",E16,G16))","v":0.45},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B16,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E15,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":0.45},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E15=\"\",0,IF(LEFT(E15,6)=\"Public\",B27*0.44,B20*0.3)),2)","v":255000}]
["OH-percentage",{"$f":"IF(E15=\"\",\"\",IF(E15=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":0.3},"OH residual amount",{"$f":"IF(E15=\"\",\"\",IF(LEFT(E15,6)=\"Public\",B27*0.44-B28,B20*0.3-B28))","v":0}]
[]
[null,"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q29=\"\",\"\",IF(RIGHT(E15,10)=\"Virksomhed\",IF(SUM(Q20:Q28)/COUNT(Q20:Q28)<>Q29,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",850000,{"$f":"IFERROR(IF($G$16=\"\",IF(E20=\"\",B20*$E$16,E20),IF(E20=\"\",B20*$G$16,E20)),0)","v":382500},{"$f":"IFERROR(B20-C20-F20,0)","v":467500},null,null,2730,{"$f":"IF(B20=\"\",0,B20)","v":850000},{"$f":"IF($E$15<>\"Public research and knowledge dissemination organization\",0,IF(B20=\"\",0,B20))","v":0},null,null,null,null,null,null,{"$f":"A20","v":"Salary "},{"$f":"IFERROR(C20/B20,\"\")","v":0.45}]
["External assistance",16700,7515,{"$f":"IFERROR(B21-C21-F21,0)","v":9185},null,null,null,{"$f":"IF(B21=\"\",0,B21)","v":16700},0,null,null,null,null,null,null,"External assistance",0.45]
["Other costs",100000,45000,55000,null,null,null,100000,0,null,null,null,null,null,null,"Other costs",0.45]
["Apparatus/equipment",50000,22500,27500,null,null,null,50000,0,null,null,null,null,null,null,"Apparatus/equipment",0.45]
["Scrap value",-10000,-4500,-5500,null,null,null,-10000,0,null,null,null,null,null,null,"Scrap value",0.45]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",18000,8100,9900,null,null,null,18000,0,null,null,null,null,null,null,"Audit costs",0.45]
["Total excl. OH",{"$f":"SUM(B20:B26)","v":1024700},461115,563585,0,0,{"$f":"SUM(G20:G26)","v":2730},1024700,0,null,null,null,null,null,null,"Total excl. OH",0.45]
["OH",{"$f":"B20*0.3","v":255000},{"$f":"IFERROR(IF($G$16=\"\",IF(E28=\"\",B28*$E$16,E28),IF(E28=\"\",B28*$G$16,E28)),0)","v":114750},{"$f":"IFERROR(B28-C28-F28,0)","v":140250},null,null,null,255000,0,null,null,null,null,null,null,"OH",0.45]
["Total",{"$f":"SUM(B20:B26)+B28","v":1279700},575865,703835,0,0,2730,1279700,0,null,null,null,null,null,null,"Total",0.45]
[]
["Company name:","The Little Green Company","Participant 2","Company size:","Small company"]
["Activity type:","Demonstration",{"$f":"IF(IF(G32=\"\",E32,G32)=\"\",0,IF(G32=\"\",E32,G32))","v":0.7},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B32,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E31,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":0.7},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E31=\"\",0,IF(LEFT(E31,6)=\"Public\",B43*0.44,B36*0.3)),2)","v":30000}]
["OH-percentage",{"$f":"IF(E31=\"\",\"\",IF(E31=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":0.3},"OH residual amount",{"$f":"IF(E31=\"\",\"\",IF(LEFT(E31,6)=\"Public\",B43*0.44-B44,B36*0.3-B44))","v":0}]
[]
[null,"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q45=\"\",\"\",IF(RIGHT(E31,10)=\"Virksomhed\",IF(SUM(Q36:Q44)/COUNT(Q36:Q44)<>Q45,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",100000,{"$f":"IFERROR(IF($G$32=\"\",IF(E36=\"\",B36*$E$32,E36),IF(E36=\"\",B36*$G$32,E36)),0)","v":70000},{"$f":"IFERROR(B36-C36-F36,0)","v":30000},null,null,313,{"$f":"IF(B36=\"\",0,B36)","v":100000},{"$f":"IF($E$31<>\"Public research and knowledge dissemination organization\",0,IF(B36=\"\",0,B36))","v":0},null,null,null,null,null,null,{"$f":"A36","v":"Salary "},{"$f":"IFERROR(C36/B36,\"\")","v":0.7}]
["External assistance",null,{"$f":"IFERROR(IF($G$32=\"\",IF(E37=\"\",B37*$E$32,E37),IF(E37=\"\",B37*$G$32,E37)),0)","v":0},{"$f":"IFERROR(B37-C37-F37,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",50000,35000,15000,null,null,null,50000,0,null,null,null,null,null,null,"Other costs",0.7]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",18000,12600,5400,null,null,null,18000,0,null,null,null,null,null,null,"Audit costs",0.7]
["Total excl. OH",{"$f":"SUM(B36:B42)","v":168000},{"$f":"SUM(C36:C42)","v":117600},{"$f":"SUM(D36:D42)","v":50400},{"$f":"SUM(E36:E42)","v":0},{"$f":"SUM(F36:F42)","v":0},{"$f":"SUM(G36:G42)","v":313},{"$f":"SUM(H36:H42)","v":168000},0,null,null,null,null,null,null,"Total excl. OH",0.7]
["OH",{"$f":"B36*0.3","v":30000},{"$f":"IFERROR(IF($G$32=\"\",IF(E44=\"\",B44*$E$32,E44),IF(E44=\"\",B44*$G$32,E44)),0)","v":21000},{"$f":"IFERROR(B44-C44-F44,0)","v":9000},null,null,null,{"$f":"IF(B44=\"\",0,B44)","v":30000},0,null,null,null,null,null,null,"OH",0.7]
["Total",{"$f":"SUM(B36:B42)+B44","v":198000},{"$f":"SUM(C36:C42)+C44","v":138600},{"$f":"SUM(D36:D42)+D44","v":59400},{"$f":"SUM(E36:E42)+E44","v":0},{"$f":"SUM(F36:F42)+F44","v":0},{"$f":"SUM(G36:G42)+G44","v":313},{"$f":"SUM(H36:H42)+H44","v":198000},0,null,null,null,null,null,null,"Total",0.7]
[]
["Company name:",null,"Participant 3","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G48=\"\",E48,G48)=\"\",0,IF(G48=\"\",E48,G48))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B48,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E47,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E47=\"\",0,IF(LEFT(E47,6)=\"Public\",B59*0.44,B52*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E47=\"\",\"\",IF(E47=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E47=\"\",\"\",IF(LEFT(E47,6)=\"Public\",B59*0.44-B60,B52*0.3-B60))","v":""}]
[]
[{"$f":"IF(B61>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q61=\"\",\"\",IF(RIGHT(E47,10)=\"Virksomhed\",IF(SUM(Q52:Q60)/COUNT(Q52:Q60)<>Q61,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$48=\"\",IF(E52=\"\",B52*$E$48,E52),IF(E52=\"\",B52*$G$48,E52)),0)","v":0},{"$f":"IFERROR(B52-C52-F52,0)","v":0},null,null,null,{"$f":"IF(B52=\"\",0,B52)","v":0},{"$f":"IF($E$47<>\"Public research and knowledge dissemination organization\",0,IF(B52=\"\",0,B52))","v":0},null,null,null,null,null,null,{"$f":"A52","v":"Salary "},{"$f":"IFERROR(C52/B52,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B53-C53-F53,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B52:B58)","v":0},{"$f":"SUM(C52:C58)","v":0},{"$f":"SUM(D52:D58)","v":0},{"$f":"SUM(E52:E58)","v":0},{"$f":"SUM(F52:F58)","v":0},{"$f":"SUM(G52:G58)","v":0},{"$f":"SUM(H52:H58)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$48=\"\",IF(E60=\"\",B60*$E$48,E60),IF(E60=\"\",B60*$G$48,E60)),0)","v":0},{"$f":"IFERROR(B60-C60-F60,0)","v":0},null,null,null,{"$f":"IF(B60=\"\",0,B60)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B52:B58)+B60","v":0},{"$f":"SUM(C52:C58)+C60","v":0},{"$f":"SUM(D52:D58)+D60","v":0},{"$f":"SUM(E52:E58)+E60","v":0},{"$f":"SUM(F52:F58)+F60","v":0},{"$f":"SUM(G52:G58)+G60","v":0},{"$f":"SUM(H52:H58)+H60","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 4","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G64=\"\",E64,G64)=\"\",0,IF(G64=\"\",E64,G64))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B64,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E63,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E63=\"\",0,IF(LEFT(E63,6)=\"Public\",B75*0.44,B68*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E63=\"\",\"\",IF(E63=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E63=\"\",\"\",IF(LEFT(E63,6)=\"Public\",B75*0.44-B76,B68*0.3-B76))","v":""}]
[]
[{"$f":"IF(B77>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q77=\"\",\"\",IF(RIGHT(E63,10)=\"Virksomhed\",IF(SUM(Q68:Q76)/COUNT(Q68:Q76)<>Q77,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$64=\"\",IF(E68=\"\",B68*$E$64,E68),IF(E68=\"\",B68*$G$64,E68)),0)","v":0},{"$f":"IFERROR(B68-C68-F68,0)","v":0},null,null,null,{"$f":"IF(B68=\"\",0,B68)","v":0},{"$f":"IF($E$63<>\"Public research and knowledge dissemination organization\",0,IF(B68=\"\",0,B68))","v":0},null,null,null,null,null,null,{"$f":"A68","v":"Salary "},{"$f":"IFERROR(C68/B68,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B69-C69-F69,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B68:B74)","v":0},{"$f":"SUM(C68:C74)","v":0},{"$f":"SUM(D68:D74)","v":0},{"$f":"SUM(E68:E74)","v":0},{"$f":"SUM(F68:F74)","v":0},{"$f":"SUM(G68:G74)","v":0},{"$f":"SUM(H68:H74)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$64=\"\",IF(E76=\"\",B76*$E$64,E76),IF(E76=\"\",B76*$G$64,E76)),0)","v":0},{"$f":"IFERROR(B76-C76-F76,0)","v":0},null,null,null,{"$f":"IF(B76=\"\",0,B76)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B68:B74)+B76","v":0},{"$f":"SUM(C68:C74)+C76","v":0},{"$f":"SUM(D68:D74)+D76","v":0},{"$f":"SUM(E68:E74)+E76","v":0},{"$f":"SUM(F68:F74)+F76","v":0},{"$f":"SUM(G68:G74)+G76","v":0},{"$f":"SUM(H68:H74)+H76","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 5","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G80=\"\",E80,G80)=\"\",0,IF(G80=\"\",E80,G80))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B80,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E79,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E79=\"\",0,IF(LEFT(E79,6)=\"Public\",B91*0.44,B84*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E79=\"\",\"\",IF(E79=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E79=\"\",\"\",IF(LEFT(E79,6)=\"Public\",B91*0.44-B92,B84*0.3-B92))","v":""}]
[]
[{"$f":"IF(B93>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q93=\"\",\"\",IF(RIGHT(E79,10)=\"Virksomhed\",IF(SUM(Q84:Q92)/COUNT(Q84:Q92)<>Q93,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$80=\"\",IF(E84=\"\",B84*$E$80,E84),IF(E84=\"\",B84*$G$80,E84)),0)","v":0},{"$f":"IFERROR(B84-C84-F84,0)","v":0},null,null,null,{"$f":"IF(B84=\"\",0,B84)","v":0},{"$f":"IF($E$79<>\"Public research and knowledge dissemination organization\",0,IF(B84=\"\",0,B84))","v":0},null,null,null,null,null,null,{"$f":"A84","v":"Salary "},{"$f":"IFERROR(C84/B84,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B85-C85-F85,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B84:B90)","v":0},{"$f":"SUM(C84:C90)","v":0},{"$f":"SUM(D84:D90)","v":0},{"$f":"SUM(E84:E90)","v":0},{"$f":"SUM(F84:F90)","v":0},{"$f":"SUM(G84:G90)","v":0},{"$f":"SUM(H84:H90)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$80=\"\",IF(E92=\"\",B92*$E$80,E92),IF(E92=\"\",B92*$G$80,E92)),0)","v":0},{"$f":"IFERROR(B92-C92-F92,0)","v":0},null,null,null,{"$f":"IF(B92=\"\",0,B92)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B84:B90)+B92","v":0},{"$f":"SUM(C84:C90)+C92","v":0},{"$f":"SUM(D84:D90)+D92","v":0},{"$f":"SUM(E84:E90)+E92","v":0},{"$f":"SUM(F84:F90)+F92","v":0},{"$f":"SUM(G84:G90)+G92","v":0},{"$f":"SUM(H84:H90)+H92","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 6","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G96=\"\",E96,G96)=\"\",0,IF(G96=\"\",E96,G96))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B96,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E95,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E95=\"\",0,IF(LEFT(E95,6)=\"Public\",B107*0.44,B100*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E95=\"\",\"\",IF(E95=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E95=\"\",\"\",IF(LEFT(E95,6)=\"Public\",B107*0.44-B108,B100*0.3-B108))","v":""}]
[]
[{"$f":"IF(B109>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q109=\"\",\"\",IF(RIGHT(E95,10)=\"Virksomhed\",IF(SUM(Q100:Q108)/COUNT(Q100:Q108)<>Q109,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$96=\"\",IF(E100=\"\",B100*$E$96,E100),IF(E100=\"\",B100*$G$96,E100)),0)","v":0},{"$f":"IFERROR(B100-C100-F100,0)","v":0},null,null,null,{"$f":"IF(B100=\"\",0,B100)","v":0},{"$f":"IF($E$95<>\"Public research and knowledge dissemination organization\",0,IF(B100=\"\",0,B100))","v":0},null,null,null,null,null,null,{"$f":"A100","v":"Salary "},{"$f":"IFERROR(C100/B100,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B101-C101-F101,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B100:B106)","v":0},{"$f":"SUM(C100:C106)","v":0},{"$f":"SUM(D100:D106)","v":0},{"$f":"SUM(E100:E106)","v":0},{"$f":"SUM(F100:F106)","v":0},{"$f":"SUM(G100:G106)","v":0},{"$f":"SUM(H100:H106)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$96=\"\",IF(E108=\"\",B108*$E$96,E108),IF(E108=\"\",B108*$G$96,E108)),0)","v":0},{"$f":"IFERROR(B108-C108-F108,0)","v":0},null,null,null,{"$f":"IF(B108=\"\",0,B108)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B100:B106)+B108","v":0},{"$f":"SUM(C100:C106)+C108","v":0},{"$f":"SUM(D100:D106)+D108","v":0},{"$f":"SUM(E100:E106)+E108","v":0},{"$f":"SUM(F100:F106)+F108","v":0},{"$f":"SUM(G100:G106)+G108","v":0},{"$f":"SUM(H100:H106)+H108","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 7","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G112=\"\",E112,G112)=\"\",0,IF(G112=\"\",E112,G112))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B112,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E111,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E111=\"\",0,IF(LEFT(E111,6)=\"Public\",B123*0.44,B116*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E111=\"\",\"\",IF(E111=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E111=\"\",\"\",IF(LEFT(E111,6)=\"Public\",B123*0.44-B124,B116*0.3-B124))","v":""}]
[]
[{"$f":"IF(B125>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specifikation af delbudget:",null,null,null,null,null,{"$f":"IF(Q125=\"\",\"\",IF(RIGHT(E111,10)=\"Virksomhed\",IF(SUM(Q116:Q124)/COUNT(Q116:Q124)<>Q125,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$112=\"\",IF(E116=\"\",B116*$E$112,E116),IF(E116=\"\",B116*$G$112,E116)),0)","v":0},{"$f":"IFERROR(B116-C116-F116,0)","v":0},null,null,null,{"$f":"IF(B116=\"\",0,B116)","v":0},{"$f":"IF($E$111<>\"Public research and knowledge dissemination organization\",0,IF(B116=\"\",0,B116))","v":0},null,null,null,null,null,null,{"$f":"A116","v":"Salary "},{"$f":"IFERROR(C116/B116,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B117-C117-F117,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B116:B122)","v":0},{"$f":"SUM(C116:C122)","v":0},{"$f":"SUM(D116:D122)","v":0},{"$f":"SUM(E116:E122)","v":0},{"$f":"SUM(F116:F122)","v":0},{"$f":"SUM(G116:G122)","v":0},{"$f":"SUM(H116:H122)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$112=\"\",IF(E124=\"\",B124*$E$112,E124),IF(E124=\"\",B124*$G$112,E124)),0)","v":0},{"$f":"IFERROR(B124-C124-F124,0)","v":0},null,null,null,{"$f":"IF(B124=\"\",0,B124)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B116:B122)+B124","v":0},{"$f":"SUM(C116:C122)+C124","v":0},{"$f":"SUM(D116:D122)+D124","v":0},{"$f":"SUM(E116:E122)+E124","v":0},{"$f":"SUM(F116:F122)+F124","v":0},{"$f":"SUM(G116:G122)+G124","v":0},{"$f":"SUM(H116:H122)+H124","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 8","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G128=\"\",E128,G128)=\"\",0,IF(G128=\"\",E128,G128))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B128,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E127,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E127=\"\",0,IF(LEFT(E127,6)=\"Public\",B139*0.44,B132*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E127=\"\",\"\",IF(E127=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E127=\"\",\"\",IF(LEFT(E127,6)=\"Public\",B139*0.44-B140,B132*0.3-B140))","v":""}]
[]
[{"$f":"IF(B141>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q141=\"\",\"\",IF(RIGHT(E127,10)=\"Virksomhed\",IF(SUM(Q132:Q140)/COUNT(Q132:Q140)<>Q141,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$128=\"\",IF(E132=\"\",B132*$E$128,E132),IF(E132=\"\",B132*$G$128,E132)),0)","v":0},{"$f":"IFERROR(B132-C132-F132,0)","v":0},null,null,null,{"$f":"IF(B132=\"\",0,B132)","v":0},{"$f":"IF($E$127<>\"Public research and knowledge dissemination organization\",0,IF(B132=\"\",0,B132))","v":0},null,null,null,null,null,null,{"$f":"A132","v":"Salary "},{"$f":"IFERROR(C132/B132,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B133-C133-F133,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B132:B138)","v":0},{"$f":"SUM(C132:C138)","v":0},{"$f":"SUM(D132:D138)","v":0},{"$f":"SUM(E132:E138)","v":0},{"$f":"SUM(F132:F138)","v":0},{"$f":"SUM(G132:G138)","v":0},{"$f":"SUM(H132:H138)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$128=\"\",IF(E140=\"\",B140*$E$128,E140),IF(E140=\"\",B140*$G$128,E140)),0)","v":0},{"$f":"IFERROR(B140-C140-F140,0)","v":0},null,null,null,{"$f":"IF(B140=\"\",0,B140)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B132:B138)+B140","v":0},{"$f":"SUM(C132:C138)+C140","v":0},{"$f":"SUM(D132:D138)+D140","v":0},{"$f":"SUM(E132:E138)+E140","v":0},{"$f":"SUM(F132:F138)+F140","v":0},{"$f":"SUM(G132:G138)+G140","v":0},{"$f":"SUM(H132:H138)+H140","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 9","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G144=\"\",E144,G144)=\"\",0,IF(G144=\"\",E144,G144))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B144,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E143,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E143=\"\",0,IF(LEFT(E143,6)=\"Public\",B155*0.44,B148*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E143=\"\",\"\",IF(E143=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E143=\"\",\"\",IF(LEFT(E143,6)=\"Public\",B155*0.44-B156,B148*0.3-B156))","v":""}]
[]
[{"$f":"IF(B157>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q157=\"\",\"\",IF(RIGHT(E143,10)=\"Virksomhed\",IF(SUM(Q148:Q156)/COUNT(Q148:Q156)<>Q157,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$144=\"\",IF(E148=\"\",B148*$E$144,E148),IF(E148=\"\",B148*$G$144,E148)),0)","v":0},{"$f":"IFERROR(B148-C148-F148,0)","v":0},null,null,null,{"$f":"IF(B148=\"\",0,B148)","v":0},{"$f":"IF($E$143<>\"Public research and knowledge dissemination organization\",0,IF(B148=\"\",0,B148))","v":0},null,null,null,null,null,null,{"$f":"A148","v":"Salary "},{"$f":"IFERROR(C148/B148,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B149-C149-F149,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B148:B154)","v":0},{"$f":"SUM(C148:C154)","v":0},{"$f":"SUM(D148:D154)","v":0},{"$f":"SUM(E148:E154)","v":0},{"$f":"SUM(F148:F154)","v":0},{"$f":"SUM(G148:G154)","v":0},{"$f":"SUM(H148:H154)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$144=\"\",IF(E156=\"\",B156*$E$144,E156),IF(E156=\"\",B156*$G$144,E156)),0)","v":0},{"$f":"IFERROR(B156-C156-F156,0)","v":0},null,null,null,{"$f":"IF(B156=\"\",0,B156)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B148:B154)+B156","v":0},{"$f":"SUM(C148:C154)+C156","v":0},{"$f":"SUM(D148:D154)+D156","v":0},{"$f":"SUM(E148:E154)+E156","v":0},{"$f":"SUM(F148:F154)+F156","v":0},{"$f":"SUM(G148:G154)+G156","v":0},{"$f":"SUM(H148:H154)+H156","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 10","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G160=\"\",E160,G160)=\"\",0,IF(G160=\"\",E160,G160))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B160,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E159,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E159=\"\",0,IF(LEFT(E159,6)=\"Public\",B171*0.44,B164*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E159=\"\",\"\",IF(E159=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E159=\"\",\"\",IF(LEFT(E159,6)=\"Public\",B171*0.44-B172,B164*0.3-B172))","v":""}]
[]
[{"$f":"IF(B173>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q173=\"\",\"\",IF(RIGHT(E159,10)=\"Virksomhed\",IF(SUM(Q164:Q172)/COUNT(Q164:Q172)<>Q173,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$160=\"\",IF(E164=\"\",B164*$E$160,E164),IF(E164=\"\",B164*$G$160,E164)),0)","v":0},{"$f":"IFERROR(B164-C164-F164,0)","v":0},null,null,null,{"$f":"IF(B164=\"\",0,B164)","v":0},{"$f":"IF($E$159<>\"Public research and knowledge dissemination organization\",0,IF(B164=\"\",0,B164))","v":0},null,null,null,null,null,null,{"$f":"A164","v":"Salary "},{"$f":"IFERROR(C164/B164,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B165-C165-F165,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B164:B170)","v":0},{"$f":"SUM(C164:C170)","v":0},{"$f":"SUM(D164:D170)","v":0},{"$f":"SUM(E164:E170)","v":0},{"$f":"SUM(F164:F170)","v":0},{"$f":"SUM(G164:G170)","v":0},{"$f":"SUM(H164:H170)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$160=\"\",IF(E172=\"\",B172*$E$160,E172),IF(E172=\"\",B172*$G$160,E172)),0)","v":0},{"$f":"IFERROR(B172-C172-F172,0)","v":0},null,null,null,{"$f":"IF(B172=\"\",0,B172)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B164:B170)+B172","v":0},{"$f":"SUM(C164:C170)+C172","v":0},{"$f":"SUM(D164:D170)+D172","v":0},{"$f":"SUM(E164:E170)+E172","v":0},{"$f":"SUM(F164:F170)+F172","v":0},{"$f":"SUM(G164:G170)+G172","v":0},{"$f":"SUM(H164:H170)+H172","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 11","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G176=\"\",E176,G176)=\"\",0,IF(G176=\"\",E176,G176))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B176,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E175,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E175=\"\",0,IF(LEFT(E175,6)=\"Public\",B187*0.44,B180*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E175=\"\",\"\",IF(E175=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E175=\"\",\"\",IF(LEFT(E175,6)=\"Public\",B187*0.44-B188,B180*0.3-B188))","v":""}]
[]
[{"$f":"IF(B189>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q189=\"\",\"\",IF(RIGHT(E175,10)=\"Virksomhed\",IF(SUM(Q180:Q188)/COUNT(Q180:Q188)<>Q189,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$176=\"\",IF(E180=\"\",B180*$E$176,E180),IF(E180=\"\",B180*$G$176,E180)),0)","v":0},{"$f":"IFERROR(B180-C180-F180,0)","v":0},null,null,null,{"$f":"IF(B180=\"\",0,B180)","v":0},{"$f":"IF($E$175<>\"Public research and knowledge dissemination organization\",0,IF(B180=\"\",0,B180))","v":0},null,null,null,null,null,null,{"$f":"A180","v":"Salary "},{"$f":"IFERROR(C180/B180,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B181-C181-F181,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B180:B186)","v":0},{"$f":"SUM(C180:C186)","v":0},{"$f":"SUM(D180:D186)","v":0},{"$f":"SUM(E180:E186)","v":0},{"$f":"SUM(F180:F186)","v":0},{"$f":"SUM(G180:G186)","v":0},{"$f":"SUM(H180:H186)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$176=\"\",IF(E188=\"\",B188*$E$176,E188),IF(E188=\"\",B188*$G$176,E188)),0)","v":0},{"$f":"IFERROR(B188-C188-F188,0)","v":0},null,null,null,{"$f":"IF(B188=\"\",0,B188)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B180:B186)+B188","v":0},{"$f":"SUM(C180:C186)+C188","v":0},{"$f":"SUM(D180:D186)+D188","v":0},{"$f":"SUM(E180:E186)+E188","v":0},{"$f":"SUM(F180:F186)+F188","v":0},{"$f":"SUM(G180:G186)+G188","v":0},{"$f":"SUM(H180:H186)+H188","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 12","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G192=\"\",E192,G192)=\"\",0,IF(G192=\"\",E192,G192))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B192,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E191,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E191=\"\",0,IF(LEFT(E191,6)=\"Public\",B203*0.44,B196*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E191=\"\",\"\",IF(E191=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E191=\"\",\"\",IF(LEFT(E191,6)=\"Public\",B203*0.44-B204,B196*0.3-B204))","v":""}]
[]
[{"$f":"IF(B205>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q205=\"\",\"\",IF(RIGHT(E191,10)=\"Virksomhed\",IF(SUM(Q196:Q204)/COUNT(Q196:Q204)<>Q205,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$192=\"\",IF(E196=\"\",B196*$E$192,E196),IF(E196=\"\",B196*$G$192,E196)),0)","v":0},{"$f":"IFERROR(B196-C196-F196,0)","v":0},null,null,null,{"$f":"IF(B196=\"\",0,B196)","v":0},{"$f":"IF($E$191<>\"Public research and knowledge dissemination organization\",0,IF(B196=\"\",0,B196))","v":0},null,null,null,null,null,null,{"$f":"A196","v":"Salary "},{"$f":"IFERROR(C196/B196,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B197-C197-F197,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B196:B202)","v":0},{"$f":"SUM(C196:C202)","v":0},{"$f":"SUM(D196:D202)","v":0},{"$f":"SUM(E196:E202)","v":0},{"$f":"SUM(F196:F202)","v":0},{"$f":"SUM(G196:G202)","v":0},{"$f":"SUM(H196:H202)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$192=\"\",IF(E204=\"\",B204*$E$192,E204),IF(E204=\"\",B204*$G$192,E204)),0)","v":0},{"$f":"IFERROR(B204-C204-F204,0)","v":0},null,null,null,{"$f":"IF(B204=\"\",0,B204)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B196:B202)+B204","v":0},{"$f":"SUM(C196:C202)+C204","v":0},{"$f":"SUM(D196:D202)+D204","v":0},{"$f":"SUM(E196:E202)+E204","v":0},{"$f":"SUM(F196:F202)+F204","v":0},{"$f":"SUM(G196:G202)+G204","v":0},{"$f":"SUM(H196:H202)+H204","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 13","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G208=\"\",E208,G208)=\"\",0,IF(G208=\"\",E208,G208))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B208,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E207,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E207=\"\",0,IF(LEFT(E207,6)=\"Public\",B219*0.44,B212*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E207=\"\",\"\",IF(E207=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E207=\"\",\"\",IF(LEFT(E207,6)=\"Public\",B219*0.44-B220,B212*0.3-B220))","v":""}]
[]
[{"$f":"IF(B221>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q221=\"\",\"\",IF(RIGHT(E207,10)=\"Virksomhed\",IF(SUM(Q212:Q220)/COUNT(Q212:Q220)<>Q221,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$208=\"\",IF(E212=\"\",B212*$E$208,E212),IF(E212=\"\",B212*$G$208,E212)),0)","v":0},{"$f":"IFERROR(B212-C212-F212,0)","v":0},null,null,null,{"$f":"IF(B212=\"\",0,B212)","v":0},{"$f":"IF($E$207<>\"Public research and knowledge dissemination organization\",0,IF(B212=\"\",0,B212))","v":0},null,null,null,null,null,null,{"$f":"A212","v":"Salary "},{"$f":"IFERROR(C212/B212,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B213-C213-F213,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B212:B218)","v":0},{"$f":"SUM(C212:C218)","v":0},{"$f":"SUM(D212:D218)","v":0},{"$f":"SUM(E212:E218)","v":0},{"$f":"SUM(F212:F218)","v":0},{"$f":"SUM(G212:G218)","v":0},{"$f":"SUM(H212:H218)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$208=\"\",IF(E220=\"\",B220*$E$208,E220),IF(E220=\"\",B220*$G$208,E220)),0)","v":0},{"$f":"IFERROR(B220-C220-F220,0)","v":0},null,null,null,{"$f":"IF(B220=\"\",0,B220)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B212:B218)+B220","v":0},{"$f":"SUM(C212:C218)+C220","v":0},{"$f":"SUM(D212:D218)+D220","v":0},{"$f":"SUM(E212:E218)+E220","v":0},{"$f":"SUM(F212:F218)+F220","v":0},{"$f":"SUM(G212:G218)+G220","v":0},{"$f":"SUM(H212:H218)+H220","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 14","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G224=\"\",E224,G224)=\"\",0,IF(G224=\"\",E224,G224))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B224,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E223,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E223=\"\",0,IF(LEFT(E223,6)=\"Public\",B235*0.44,B228*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E223=\"\",\"\",IF(E223=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E223=\"\",\"\",IF(LEFT(E223,6)=\"Public\",B235*0.44-B236,B228*0.3-B236))","v":""}]
[]
[{"$f":"IF(B237>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q237=\"\",\"\",IF(RIGHT(E223,10)=\"Virksomhed\",IF(SUM(Q228:Q236)/COUNT(Q228:Q236)<>Q237,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$224=\"\",IF(E228=\"\",B228*$E$224,E228),IF(E228=\"\",B228*$G$224,E228)),0)","v":0},{"$f":"IFERROR(B228-C228-F228,0)","v":0},null,null,null,{"$f":"IF(B228=\"\",0,B228)","v":0},{"$f":"IF($E$223<>\"Public research and knowledge dissemination organization\",0,IF(B228=\"\",0,B228))","v":0},null,null,null,null,null,null,{"$f":"A228","v":"Salary "},{"$f":"IFERROR(C228/B228,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B229-C229-F229,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B228:B234)","v":0},{"$f":"SUM(C228:C234)","v":0},{"$f":"SUM(D228:D234)","v":0},{"$f":"SUM(E228:E234)","v":0},{"$f":"SUM(F228:F234)","v":0},{"$f":"SUM(G228:G234)","v":0},{"$f":"SUM(H228:H234)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$224=\"\",IF(E236=\"\",B236*$E$224,E236),IF(E236=\"\",B236*$G$224,E236)),0)","v":0},{"$f":"IFERROR(B236-C236-F236,0)","v":0},null,null,null,{"$f":"IF(B236=\"\",0,B236)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B228:B234)+B236","v":0},{"$f":"SUM(C228:C234)+C236","v":0},{"$f":"SUM(D228:D234)+D236","v":0},{"$f":"SUM(E228:E234)+E236","v":0},{"$f":"SUM(F228:F234)+F236","v":0},{"$f":"SUM(G228:G234)+G236","v":0},{"$f":"SUM(H228:H234)+H236","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 15","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G240=\"\",E240,G240)=\"\",0,IF(G240=\"\",E240,G240))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B240,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E239,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E239=\"\",0,IF(LEFT(E239,6)=\"Public\",B251*0.44,B244*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E239=\"\",\"\",IF(E239=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E239=\"\",\"\",IF(LEFT(E239,6)=\"Public\",B251*0.44-B252,B244*0.3-B252))","v":""}]
[]
[{"$f":"IF(B253>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q253=\"\",\"\",IF(RIGHT(E239,10)=\"Virksomhed\",IF(SUM(Q244:Q252)/COUNT(Q244:Q252)<>Q253,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$240=\"\",IF(E244=\"\",B244*$E$240,E244),IF(E244=\"\",B244*$G$240,E244)),0)","v":0},{"$f":"IFERROR(B244-C244-F244,0)","v":0},null,null,null,{"$f":"IF(B244=\"\",0,B244)","v":0},{"$f":"IF($E$239<>\"Public research and knowledge dissemination organization\",0,IF(B244=\"\",0,B244))","v":0},null,null,null,null,null,null,{"$f":"A244","v":"Salary "},{"$f":"IFERROR(C244/B244,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B245-C245-F245,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B244:B250)","v":0},{"$f":"SUM(C244:C250)","v":0},{"$f":"SUM(D244:D250)","v":0},{"$f":"SUM(E244:E250)","v":0},{"$f":"SUM(F244:F250)","v":0},{"$f":"SUM(G244:G250)","v":0},{"$f":"SUM(H244:H250)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$240=\"\",IF(E252=\"\",B252*$E$240,E252),IF(E252=\"\",B252*$G$240,E252)),0)","v":0},{"$f":"IFERROR(B252-C252-F252,0)","v":0},null,null,null,{"$f":"IF(B252=\"\",0,B252)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B244:B250)+B252","v":0},{"$f":"SUM(C244:C250)+C252","v":0},{"$f":"SUM(D244:D250)+D252","v":0},{"$f":"SUM(E244:E250)+E252","v":0},{"$f":"SUM(F244:F250)+F252","v":0},{"$f":"SUM(G244:G250)+G252","v":0},{"$f":"SUM(H244:H250)+H252","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 16","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G256=\"\",E256,G256)=\"\",0,IF(G256=\"\",E256,G256))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B256,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E255,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E255=\"\",0,IF(LEFT(E255,6)=\"Public\",B267*0.44,B260*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E255=\"\",\"\",IF(E255=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E255=\"\",\"\",IF(LEFT(E255,6)=\"Public\",B267*0.44-B268,B260*0.3-B268))","v":""}]
[]
[{"$f":"IF(B269>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q269=\"\",\"\",IF(RIGHT(E255,10)=\"Virksomhed\",IF(SUM(Q260:Q268)/COUNT(Q260:Q268)<>Q269,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$256=\"\",IF(E260=\"\",B260*$E$256,E260),IF(E260=\"\",B260*$G$256,E260)),0)","v":0},{"$f":"IFERROR(B260-C260-F260,0)","v":0},null,null,null,{"$f":"IF(B260=\"\",0,B260)","v":0},{"$f":"IF($E$255<>\"Public research and knowledge dissemination organization\",0,IF(B260=\"\",0,B260))","v":0},null,null,null,null,null,null,{"$f":"A260","v":"Salary "},{"$f":"IFERROR(C260/B260,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B261-C261-F261,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B260:B266)","v":0},{"$f":"SUM(C260:C266)","v":0},{"$f":"SUM(D260:D266)","v":0},{"$f":"SUM(E260:E266)","v":0},{"$f":"SUM(F260:F266)","v":0},{"$f":"SUM(G260:G266)","v":0},{"$f":"SUM(H260:H266)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$256=\"\",IF(E268=\"\",B268*$E$256,E268),IF(E268=\"\",B268*$G$256,E268)),0)","v":0},{"$f":"IFERROR(B268-C268-F268,0)","v":0},null,null,null,{"$f":"IF(B268=\"\",0,B268)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B260:B266)+B268","v":0},{"$f":"SUM(C260:C266)+C268","v":0},{"$f":"SUM(D260:D266)+D268","v":0},{"$f":"SUM(E260:E266)+E268","v":0},{"$f":"SUM(F260:F266)+F268","v":0},{"$f":"SUM(G260:G266)+G268","v":0},{"$f":"SUM(H260:H266)+H268","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 17","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G272=\"\",E272,G272)=\"\",0,IF(G272=\"\",E272,G272))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B272,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E271,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E271=\"\",0,IF(LEFT(E271,6)=\"Public\",B283*0.44,B276*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E271=\"\",\"\",IF(E271=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E271=\"\",\"\",IF(LEFT(E271,6)=\"Public\",B283*0.44-B284,B276*0.3-B284))","v":""}]
[]
[{"$f":"IF(B285>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q285=\"\",\"\",IF(RIGHT(E271,10)=\"Virksomhed\",IF(SUM(Q276:Q284)/COUNT(Q276:Q284)<>Q285,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$272=\"\",IF(E276=\"\",B276*$E$272,E276),IF(E276=\"\",B276*$G$272,E276)),0)","v":0},{"$f":"IFERROR(B276-C276-F276,0)","v":0},null,null,null,{"$f":"IF(B276=\"\",0,B276)","v":0},{"$f":"IF($E$271<>\"Public research and knowledge dissemination organization\",0,IF(B276=\"\",0,B276))","v":0},null,null,null,null,null,null,{"$f":"A276","v":"Salary "},{"$f":"IFERROR(C276/B276,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B277-C277-F277,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B276:B282)","v":0},{"$f":"SUM(C276:C282)","v":0},{"$f":"SUM(D276:D282)","v":0},{"$f":"SUM(E276:E282)","v":0},{"$f":"SUM(F276:F282)","v":0},{"$f":"SUM(G276:G282)","v":0},{"$f":"SUM(H276:H282)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$272=\"\",IF(E284=\"\",B284*$E$272,E284),IF(E284=\"\",B284*$G$272,E284)),0)","v":0},{"$f":"IFERROR(B284-C284-F284,0)","v":0},null,null,null,{"$f":"IF(B284=\"\",0,B284)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B276:B282)+B284","v":0},{"$f":"SUM(C276:C282)+C284","v":0},{"$f":"SUM(D276:D282)+D284","v":0},{"$f":"SUM(E276:E282)+E284","v":0},{"$f":"SUM(F276:F282)+F284","v":0},{"$f":"SUM(G276:G282)+G284","v":0},{"$f":"SUM(H276:H282)+H284","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 18","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G288=\"\",E288,G288)=\"\",0,IF(G288=\"\",E288,G288))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B288,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E287,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E287=\"\",0,IF(LEFT(E287,6)=\"Public\",B299*0.44,B292*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E287=\"\",\"\",IF(E287=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E287=\"\",\"\",IF(LEFT(E287,6)=\"Public\",B299*0.44-B300,B292*0.3-B300))","v":""}]
[]
[{"$f":"IF(B301>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q301=\"\",\"\",IF(RIGHT(E287,10)=\"Virksomhed\",IF(SUM(Q292:Q300)/COUNT(Q292:Q300)<>Q301,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$288=\"\",IF(E292=\"\",B292*$E$288,E292),IF(E292=\"\",B292*$G$288,E292)),0)","v":0},{"$f":"IFERROR(B292-C292-F292,0)","v":0},null,null,null,{"$f":"IF(B292=\"\",0,B292)","v":0},{"$f":"IF($E$287<>\"Public research and knowledge dissemination organization\",0,IF(B292=\"\",0,B292))","v":0},null,null,null,null,null,null,{"$f":"A292","v":"Salary "},{"$f":"IFERROR(C292/B292,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B293-C293-F293,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B292:B298)","v":0},{"$f":"SUM(C292:C298)","v":0},{"$f":"SUM(D292:D298)","v":0},{"$f":"SUM(E292:E298)","v":0},{"$f":"SUM(F292:F298)","v":0},{"$f":"SUM(G292:G298)","v":0},{"$f":"SUM(H292:H298)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$288=\"\",IF(E300=\"\",B300*$E$288,E300),IF(E300=\"\",B300*$G$288,E300)),0)","v":0},{"$f":"IFERROR(B300-C300-F300,0)","v":0},null,null,null,{"$f":"IF(B300=\"\",0,B300)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B292:B298)+B300","v":0},{"$f":"SUM(C292:C298)+C300","v":0},{"$f":"SUM(D292:D298)+D300","v":0},{"$f":"SUM(E292:E298)+E300","v":0},{"$f":"SUM(F292:F298)+F300","v":0},{"$f":"SUM(G292:G298)+G300","v":0},{"$f":"SUM(H292:H298)+H300","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 19","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G304=\"\",E304,G304)=\"\",0,IF(G304=\"\",E304,G304))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B304,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E303,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E303=\"\",0,IF(LEFT(E303,6)=\"Public\",B315*0.44,B308*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E303=\"\",\"\",IF(E303=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E303=\"\",\"\",IF(LEFT(E303,6)=\"Public\",B315*0.44-B316,B308*0.3-B316))","v":""}]
[]
[{"$f":"IF(B317>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q317=\"\",\"\",IF(RIGHT(E303,10)=\"Virksomhed\",IF(SUM(Q308:Q316)/COUNT(Q308:Q316)<>Q317,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$304=\"\",IF(E308=\"\",B308*$E$304,E308),IF(E308=\"\",B308*$G$304,E308)),0)","v":0},{"$f":"IFERROR(B308-C308-F308,0)","v":0},null,null,null,{"$f":"IF(B308=\"\",0,B308)","v":0},{"$f":"IF($E$303<>\"Public research and knowledge dissemination organization\",0,IF(B308=\"\",0,B308))","v":0},null,null,null,null,null,null,{"$f":"A308","v":"Salary "},{"$f":"IFERROR(C308/B308,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B309-C309-F309,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B308:B314)","v":0},{"$f":"SUM(C308:C314)","v":0},{"$f":"SUM(D308:D314)","v":0},{"$f":"SUM(E308:E314)","v":0},{"$f":"SUM(F308:F314)","v":0},{"$f":"SUM(G308:G314)","v":0},{"$f":"SUM(H308:H314)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$304=\"\",IF(E316=\"\",B316*$E$304,E316),IF(E316=\"\",B316*$G$304,E316)),0)","v":0},{"$f":"IFERROR(B316-C316-F316,0)","v":0},null,null,null,{"$f":"IF(B316=\"\",0,B316)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B308:B314)+B316","v":0},{"$f":"SUM(C308:C314)+C316","v":0},{"$f":"SUM(D308:D314)+D316","v":0},{"$f":"SUM(E308:E314)+E316","v":0},{"$f":"SUM(F308:F314)+F316","v":0},{"$f":"SUM(G308:G314)+G316","v":0},{"$f":"SUM(H308:H314)+H316","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 20","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G320=\"\",E320,G320)=\"\",0,IF(G320=\"\",E320,G320))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B320,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E319,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E319=\"\",0,IF(LEFT(E319,6)=\"Public\",B331*0.44,B324*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E319=\"\",\"\",IF(E319=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E319=\"\",\"\",IF(LEFT(E319,6)=\"Public\",B331*0.44-B332,B324*0.3-B332))","v":""}]
[]
[{"$f":"IF(B333>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget:",null,null,null,null,null,{"$f":"IF(Q333=\"\",\"\",IF(RIGHT(E319,10)=\"Virksomhed\",IF(SUM(Q324:Q332)/COUNT(Q324:Q332)<>Q333,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$320=\"\",IF(E324=\"\",B324*$E$320,E324),IF(E324=\"\",B324*$G$320,E324)),0)","v":0},{"$f":"IFERROR(B324-C324-F324,0)","v":0},null,null,null,{"$f":"IF(B324=\"\",0,B324)","v":0},{"$f":"IF($E$319<>\"Public research and knowledge dissemination organization\",0,IF(B324=\"\",0,B324))","v":0},null,null,null,null,null,null,{"$f":"A324","v":"Salary "},{"$f":"IFERROR(C324/B324,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B325-C325-F325,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B324:B330)","v":0},{"$f":"SUM(C324:C330)","v":0},{"$f":"SUM(D324:D330)","v":0},{"$f":"SUM(E324:E330)","v":0},{"$f":"SUM(F324:F330)","v":0},{"$f":"SUM(G324:G330)","v":0},{"$f":"SUM(H324:H330)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$320=\"\",IF(E332=\"\",B332*$E$320,E332),IF(E332=\"\",B332*$G$320,E332)),0)","v":0},{"$f":"IFERROR(B332-C332-F332,0)","v":0},null,null,null,{"$f":"IF(B332=\"\",0,B332)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B324:B330)+B332","v":0},{"$f":"SUM(C324:C330)+C332","v":0},{"$f":"SUM(D324:D330)+D332","v":0},{"$f":"SUM(E324:E330)+E332","v":0},{"$f":"SUM(F324:F330)+F332","v":0},{"$f":"SUM(G324:G330)+G332","v":0},{"$f":"SUM(H324:H330)+H332","v":0},0,null,null,null,null,null,null,"Total",""]

{"sheet":"Ex. of collaboration project","index":7,"n_rows":333,"n_cols":17,"rows_kept":333,"cut":false,"hidden":true,"merged":[[318,4,318,5],[142,4,142,5],[158,4,158,5],[174,4,174,5],[190,4,190,5],[206,4,206,5],[222,4,222,5],[238,4,238,5],[254,4,254,5],[270,4,270,5],[286,4,286,5],[302,4,302,5],[126,4,126,5],[1,3,1,4],[3,9,3,11],[4,9,4,11],[14,4,14,5],[14,10,17,13],[30,4,30,5],[46,4,46,5],[62,4,62,5],[78,4,78,5],[94,4,94,5],[110,4,110,5]]}
["Project title:","Example of collaboration project with 3 participants",null,null,null,null,null,"Collaboration"]
[null,null,null,"Total project budget is filled in automatically"]
[null,"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours"]
["Salary ",{"$f":"B20+B36+B52+B68+B84+B100+B116+B132+B148+B164+B180+B196+B212+B228+B244+B260+B276+B292+B308+B324","v":2900000},{"$f":"C20+C36+C52+C68+C84+C100+C116+C132+C148+C164+C180+C196+C212+C228+C244+C260+C276+C292+C308+C324","v":2410000},430000,1750000,60000,7769,null,null,"Journal no: 34009-22-XXXX"]
["External assistance",30000,{"$f":"C21+C37+C53+C69+C85+C101+C117+C133+C149+C165+C181+C197+C213+C229+C245+C261+C277+C293+C309+C325","v":18000},12000,0,0,0,null,null,"Approved from: XX-XX-XXXX"]
["Other costs",400000,145000,55000,50000,200000,0]
["Apparatus/equipment",50000,30000,20000,0,0,0]
["Scrap value",-10000,-6000,-4000,0,0,0]
["Income, if any",0,0,0,0,0,0]
["Audit costs",52000,29800,17400,0,4800,0]
["Total excl. OH",3422000,2626800,530400,1800000,264800,7769]
["OH",1225000,990000,129000,792000,106000,0]
["Total",4647000,3616800,659400,2592000,370800,7769]
[]
["Company name:","The Little Green Company","Main applicant","Company size:","Small company",null,null,null,null,null,"Use this button to ensure, that you have filled in the data correctly. Red circles mark an error. Remember to look in the budget-template to the left and in the grant percentage to the right."]
["Activity type:","Development",{"$f":"IF(IF(G16=\"\",E16,G16)=\"\",0,IF(G16=\"\",E16,G16))","v":0.6},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B16,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E15,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":0.6},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E15=\"\",0,IF(LEFT(E15,6)=\"Public\",B27*0.44,B20*0.3)),2)","v":255000}]
["OH-percentage",{"$f":"IF(E15=\"\",\"\",IF(E15=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":0.3},"OH residual amount",{"$f":"IF(E15=\"\",\"\",IF(LEFT(E15,6)=\"Public\",B27*0.44-B28,B20*0.3-B28))","v":0}]
[]
[null,"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q29=\"\",\"\",IF(RIGHT(E15,10)=\"Virksomhed\",IF(SUM(Q20:Q28)/COUNT(Q20:Q28)<>Q29,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",850000,{"$f":"IFERROR(IF($G$16=\"\",IF(E20=\"\",B20*$E$16,E20),IF(E20=\"\",B20*$G$16,E20)),0)","v":510000},{"$f":"IFERROR(B20-C20-F20,0)","v":340000},null,null,2730,{"$f":"IF(B20=\"\",0,B20)","v":850000},{"$f":"IF($E$15<>\"Public research and knowledge dissemination organization\",0,IF(B20=\"\",0,B20))","v":0},null,null,null,null,null,null,{"$f":"A20","v":"Salary "},{"$f":"IFERROR(C20/B20,\"\")","v":0.6}]
["External assistance",30000,18000,{"$f":"IFERROR(B21-C21-F21,0)","v":12000},null,null,null,{"$f":"IF(B21=\"\",0,B21)","v":30000},0,null,null,null,null,null,null,"External assistance",0.6]
["Other costs",100000,60000,40000,null,null,null,100000,0,null,null,null,null,null,null,"Other costs",0.6]
["Apparatus/equipment",50000,30000,20000,null,null,null,50000,0,null,null,null,null,null,null,"Apparatus/equipment",0.6]
["Scrap value",-10000,-6000,-4000,null,null,null,-10000,0,null,null,null,null,null,null,"Scrap value",0.6]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",18000,10800,7200,null,null,null,18000,0,null,null,null,null,null,null,"Audit costs",0.6]
["Total excl. OH",{"$f":"SUM(B20:B26)","v":1038000},622800,415200,0,0,{"$f":"SUM(G20:G26)","v":2730},1038000,0,null,null,null,null,null,null,"Total excl. OH",0.6]
["OH",{"$f":"B20*0.3","v":255000},{"$f":"IFERROR(IF($G$16=\"\",IF(E28=\"\",B28*$E$16,E28),IF(E28=\"\",B28*$G$16,E28)),0)","v":153000},{"$f":"IFERROR(B28-C28-F28,0)","v":102000},null,null,null,255000,0,null,null,null,null,null,null,"OH",0.6]
["Total",{"$f":"SUM(B20:B26)+B28","v":1293000},775800,517200,0,0,2730,1293000,0,null,null,null,null,null,null,"Total",0.6]
[]
["Company name:","The Little Green Company","Participant 2","Company size:","Small company"]
["Activity type:","Demonstration",{"$f":"IF(IF(G32=\"\",E32,G32)=\"\",0,IF(G32=\"\",E32,G32))","v":0.7},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B32,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E31,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":0.7},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E31=\"\",0,IF(LEFT(E31,6)=\"Public\",B43*0.44,B36*0.3)),2)","v":30000}]
["OH-percentage",{"$f":"IF(E31=\"\",\"\",IF(E31=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":0.3},"OH residual amount",{"$f":"IF(E31=\"\",\"\",IF(LEFT(E31,6)=\"Public\",B43*0.44-B44,B36*0.3-B44))","v":0}]
[]
[null,"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q45=\"\",\"\",IF(RIGHT(E31,10)=\"Virksomhed\",IF(SUM(Q36:Q44)/COUNT(Q36:Q44)<>Q45,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",100000,{"$f":"IFERROR(IF($G$32=\"\",IF(E36=\"\",B36*$E$32,E36),IF(E36=\"\",B36*$G$32,E36)),0)","v":70000},{"$f":"IFERROR(B36-C36-F36,0)","v":30000},null,null,313,{"$f":"IF(B36=\"\",0,B36)","v":100000},{"$f":"IF($E$31<>\"Public research and knowledge dissemination organization\",0,IF(B36=\"\",0,B36))","v":0},null,null,null,null,null,null,{"$f":"A36","v":"Salary "},{"$f":"IFERROR(C36/B36,\"\")","v":0.7}]
["External assistance",null,{"$f":"IFERROR(IF($G$32=\"\",IF(E37=\"\",B37*$E$32,E37),IF(E37=\"\",B37*$G$32,E37)),0)","v":0},{"$f":"IFERROR(B37-C37-F37,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",50000,35000,15000,null,null,null,50000,0,null,null,null,null,null,null,"Other costs",0.7]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",18000,12600,5400,null,null,null,18000,0,null,null,null,null,null,null,"Audit costs",0.7]
["Total excl. OH",{"$f":"SUM(B36:B42)","v":168000},{"$f":"SUM(C36:C42)","v":117600},{"$f":"SUM(D36:D42)","v":50400},{"$f":"SUM(E36:E42)","v":0},{"$f":"SUM(F36:F42)","v":0},{"$f":"SUM(G36:G42)","v":313},{"$f":"SUM(H36:H42)","v":168000},0,null,null,null,null,null,null,"Total excl. OH",0.7]
["OH",{"$f":"B36*0.3","v":30000},{"$f":"IFERROR(IF($G$32=\"\",IF(E44=\"\",B44*$E$32,E44),IF(E44=\"\",B44*$G$32,E44)),0)","v":21000},{"$f":"IFERROR(B44-C44-F44,0)","v":9000},null,null,null,{"$f":"IF(B44=\"\",0,B44)","v":30000},0,null,null,null,null,null,null,"OH",0.7]
["Total",{"$f":"SUM(B36:B42)+B44","v":198000},{"$f":"SUM(C36:C42)+C44","v":138600},{"$f":"SUM(D36:D42)+D44","v":59400},{"$f":"SUM(E36:E42)+E44","v":0},{"$f":"SUM(F36:F42)+F44","v":0},{"$f":"SUM(G36:G42)+G44","v":313},{"$f":"SUM(H36:H42)+H44","v":198000},0,null,null,null,null,null,null,"Total",0.7]
[]
["Company name:","Green University","Participant 3","Company size:","Public research and knowledge dissemination organization"]
["Activity type:","Research",{"$f":"IF(IF(G48=\"\",E48,G48)=\"\",0,IF(G48=\"\",E48,G48))","v":0.9},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B48,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E47,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":0.9},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E47=\"\",0,IF(LEFT(E47,6)=\"Public\",B59*0.44,B52*0.3)),2)","v":880000}]
["OH-percentage",{"$f":"IF(E47=\"\",\"\",IF(E47=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":0.44},"OH residual amount",{"$f":"IF(E47=\"\",\"\",IF(LEFT(E47,6)=\"Public\",B59*0.44-B60,B52*0.3-B60))","v":0}]
[]
[null,"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q61=\"\",\"\",IF(RIGHT(E47,10)=\"Virksomhed\",IF(SUM(Q52:Q60)/COUNT(Q52:Q60)<>Q61,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",1750000,{"$f":"IFERROR(IF($G$48=\"\",IF(E52=\"\",B52*$E$48,E52),IF(E52=\"\",B52*$G$48,E52)),0)","v":1750000},{"$f":"IFERROR(B52-C52-F52,0)","v":0},1750000,0,4200,{"$f":"IF(B52=\"\",0,B52)","v":1750000},{"$f":"IF($E$47<>\"Public research and knowledge dissemination organization\",0,IF(B52=\"\",0,B52))","v":1750000},null,null,null,null,null,null,{"$f":"A52","v":"Salary "},{"$f":"IFERROR(C52/B52,\"\")","v":1}]
["External assistance",null,0,{"$f":"IFERROR(B53-C53-F53,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",250000,50000,0,50000,200000,null,250000,250000,null,null,null,null,null,null,"Other costs",0.2]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B52:B58)","v":2000000},{"$f":"SUM(C52:C58)","v":1800000},{"$f":"SUM(D52:D58)","v":0},{"$f":"SUM(E52:E58)","v":1800000},{"$f":"SUM(F52:F58)","v":200000},{"$f":"SUM(G52:G58)","v":4200},{"$f":"SUM(H52:H58)","v":2000000},2000000,null,null,null,null,null,null,"Total excl. OH",0.9]
["OH",{"$f":"SUM(B52:B58)*0.44","v":880000},{"$f":"IFERROR(IF($G$48=\"\",IF(E60=\"\",B60*$E$48,E60),IF(E60=\"\",B60*$G$48,E60)),0)","v":792000},{"$f":"IFERROR(B60-C60-F60,0)","v":0},792000,88000,null,{"$f":"IF(B60=\"\",0,B60)","v":880000},880000,null,null,null,null,null,null,"OH",0.9]
["Total",{"$f":"SUM(B52:B58)+B60","v":2880000},{"$f":"SUM(C52:C58)+C60","v":2592000},{"$f":"SUM(D52:D58)+D60","v":0},{"$f":"SUM(E52:E58)+E60","v":2592000},{"$f":"SUM(F52:F58)+F60","v":288000},{"$f":"SUM(G52:G58)+G60","v":4200},{"$f":"SUM(H52:H58)+H60","v":2880000},2880000,null,null,null,null,null,null,"Total",0.9]
[]
["Company name:","Green Knowledge Organization ","Participant 4","Company size:","Private research and knowledge dissemination organization"]
["Activity type:","Development",{"$f":"IF(IF(G64=\"\",E64,G64)=\"\",0,IF(G64=\"\",E64,G64))","v":0.4},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B64,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E63,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":0.4},"Manual subsidy rate:",null,{"$f":"ROUIND(IF(E63=\"\",0,IF(LEFT(E63,6)=\"Public\",B75*0.44,B68*0.3)),2)","v":{"$error":"#NAME?"}}]
["OH-percentage",{"$f":"IF(E63=\"\",\"\",IF(E63=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":0.3},"OH residual amount",{"$f":"IF(E63=\"\",\"\",IF(LEFT(E63,6)=\"Public\",B75*0.44-B76,B68*0.3-B76))","v":0}]
[]
[null,"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q77=\"\",\"\",IF(RIGHT(E63,10)=\"Virksomhed\",IF(SUM(Q68:Q76)/COUNT(Q68:Q76)<>Q77,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",200000,{"$f":"IFERROR(IF($G$64=\"\",IF(E68=\"\",B68*$E$64,E68),IF(E68=\"\",B68*$G$64,E68)),0)","v":80000},{"$f":"IFERROR(B68-C68-F68,0)","v":60000},null,60000,526,{"$f":"IF(B68=\"\",0,B68)","v":200000},{"$f":"IF($E$63<>\"Public research and knowledge dissemination organization\",0,IF(B68=\"\",0,B68))","v":0},null,null,null,null,null,null,{"$f":"A68","v":"Salary "},{"$f":"IFERROR(C68/B68,\"\")","v":0.4}]
["External assistance",null,0,{"$f":"IFERROR(B69-C69-F69,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",16000,6400,4800,null,4800,null,16000,0,null,null,null,null,null,null,"Audit costs",0.4]
["Total excl. OH",{"$f":"SUM(B68:B74)","v":216000},{"$f":"SUM(C68:C74)","v":86400},{"$f":"SUM(D68:D74)","v":64800},{"$f":"SUM(E68:E74)","v":0},{"$f":"SUM(F68:F74)","v":64800},{"$f":"SUM(G68:G74)","v":526},{"$f":"SUM(H68:H74)","v":216000},0,null,null,null,null,null,null,"Total excl. OH",0.4]
["OH",{"$f":"B68*0.3","v":60000},{"$f":"IFERROR(IF($G$64=\"\",IF(E76=\"\",B76*$E$64,E76),IF(E76=\"\",B76*$G$64,E76)),0)","v":24000},{"$f":"IFERROR(B76-C76-F76,0)","v":18000},null,18000,null,{"$f":"IF(B76=\"\",0,B76)","v":60000},0,null,null,null,null,null,null,"OH",0.4]
["Total",{"$f":"SUM(B68:B74)+B76","v":276000},{"$f":"SUM(C68:C74)+C76","v":110400},{"$f":"SUM(D68:D74)+D76","v":82800},{"$f":"SUM(E68:E74)+E76","v":0},{"$f":"SUM(F68:F74)+F76","v":82800},{"$f":"SUM(G68:G74)+G76","v":526},{"$f":"SUM(H68:H74)+H76","v":276000},0,null,null,null,null,null,null,"Total",0.4]
[]
["Company name:",null,"Participant 5","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G80=\"\",E80,G80)=\"\",0,IF(G80=\"\",E80,G80))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B80,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E79,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E79=\"\",0,IF(LEFT(E79,6)=\"Public\",B91*0.44,B84*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E79=\"\",\"\",IF(E79=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E79=\"\",\"\",IF(LEFT(E79,6)=\"Public\",B91*0.44-B92,B84*0.3-B92))","v":""}]
[]
[{"$f":"IF(B93>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q93=\"\",\"\",IF(RIGHT(E79,10)=\"Virksomhed\",IF(SUM(Q84:Q92)/COUNT(Q84:Q92)<>Q93,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$80=\"\",IF(E84=\"\",B84*$E$80,E84),IF(E84=\"\",B84*$G$80,E84)),0)","v":0},{"$f":"IFERROR(B84-C84-F84,0)","v":0},null,null,null,{"$f":"IF(B84=\"\",0,B84)","v":0},{"$f":"IF($E$79<>\"Public research and knowledge dissemination organization\",0,IF(B84=\"\",0,B84))","v":0},null,null,null,null,null,null,{"$f":"A84","v":"Salary "},{"$f":"IFERROR(C84/B84,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B85-C85-F85,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B84:B90)","v":0},{"$f":"SUM(C84:C90)","v":0},{"$f":"SUM(D84:D90)","v":0},{"$f":"SUM(E84:E90)","v":0},{"$f":"SUM(F84:F90)","v":0},{"$f":"SUM(G84:G90)","v":0},{"$f":"SUM(H84:H90)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$80=\"\",IF(E92=\"\",B92*$E$80,E92),IF(E92=\"\",B92*$G$80,E92)),0)","v":0},{"$f":"IFERROR(B92-C92-F92,0)","v":0},null,null,null,{"$f":"IF(B92=\"\",0,B92)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B84:B90)+B92","v":0},{"$f":"SUM(C84:C90)+C92","v":0},{"$f":"SUM(D84:D90)+D92","v":0},{"$f":"SUM(E84:E90)+E92","v":0},{"$f":"SUM(F84:F90)+F92","v":0},{"$f":"SUM(G84:G90)+G92","v":0},{"$f":"SUM(H84:H90)+H92","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 6","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G96=\"\",E96,G96)=\"\",0,IF(G96=\"\",E96,G96))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B96,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E95,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E95=\"\",0,IF(LEFT(E95,6)=\"Public\",B107*0.44,B100*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E95=\"\",\"\",IF(E95=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E95=\"\",\"\",IF(LEFT(E95,6)=\"Public\",B107*0.44-B108,B100*0.3-B108))","v":""}]
[]
[{"$f":"IF(B109>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q109=\"\",\"\",IF(RIGHT(E95,10)=\"Virksomhed\",IF(SUM(Q100:Q108)/COUNT(Q100:Q108)<>Q109,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$96=\"\",IF(E100=\"\",B100*$E$96,E100),IF(E100=\"\",B100*$G$96,E100)),0)","v":0},{"$f":"IFERROR(B100-C100-F100,0)","v":0},null,null,null,{"$f":"IF(B100=\"\",0,B100)","v":0},{"$f":"IF($E$95<>\"Public research and knowledge dissemination organization\",0,IF(B100=\"\",0,B100))","v":0},null,null,null,null,null,null,{"$f":"A100","v":"Salary "},{"$f":"IFERROR(C100/B100,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B101-C101-F101,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B100:B106)","v":0},{"$f":"SUM(C100:C106)","v":0},{"$f":"SUM(D100:D106)","v":0},{"$f":"SUM(E100:E106)","v":0},{"$f":"SUM(F100:F106)","v":0},{"$f":"SUM(G100:G106)","v":0},{"$f":"SUM(H100:H106)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$96=\"\",IF(E108=\"\",B108*$E$96,E108),IF(E108=\"\",B108*$G$96,E108)),0)","v":0},{"$f":"IFERROR(B108-C108-F108,0)","v":0},null,null,null,{"$f":"IF(B108=\"\",0,B108)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B100:B106)+B108","v":0},{"$f":"SUM(C100:C106)+C108","v":0},{"$f":"SUM(D100:D106)+D108","v":0},{"$f":"SUM(E100:E106)+E108","v":0},{"$f":"SUM(F100:F106)+F108","v":0},{"$f":"SUM(G100:G106)+G108","v":0},{"$f":"SUM(H100:H106)+H108","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 7","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G112=\"\",E112,G112)=\"\",0,IF(G112=\"\",E112,G112))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B112,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E111,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E111=\"\",0,IF(LEFT(E111,6)=\"Public\",B123*0.44,B116*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E111=\"\",\"\",IF(E111=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E111=\"\",\"\",IF(LEFT(E111,6)=\"Public\",B123*0.44-B124,B116*0.3-B124))","v":""}]
[]
[{"$f":"IF(B125>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q125=\"\",\"\",IF(RIGHT(E111,10)=\"Virksomhed\",IF(SUM(Q116:Q124)/COUNT(Q116:Q124)<>Q125,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$112=\"\",IF(E116=\"\",B116*$E$112,E116),IF(E116=\"\",B116*$G$112,E116)),0)","v":0},{"$f":"IFERROR(B116-C116-F116,0)","v":0},null,null,null,{"$f":"IF(B116=\"\",0,B116)","v":0},{"$f":"IF($E$111<>\"Public research and knowledge dissemination organization\",0,IF(B116=\"\",0,B116))","v":0},null,null,null,null,null,null,{"$f":"A116","v":"Salary "},{"$f":"IFERROR(C116/B116,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B117-C117-F117,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B116:B122)","v":0},{"$f":"SUM(C116:C122)","v":0},{"$f":"SUM(D116:D122)","v":0},{"$f":"SUM(E116:E122)","v":0},{"$f":"SUM(F116:F122)","v":0},{"$f":"SUM(G116:G122)","v":0},{"$f":"SUM(H116:H122)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$112=\"\",IF(E124=\"\",B124*$E$112,E124),IF(E124=\"\",B124*$G$112,E124)),0)","v":0},{"$f":"IFERROR(B124-C124-F124,0)","v":0},null,null,null,{"$f":"IF(B124=\"\",0,B124)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B116:B122)+B124","v":0},{"$f":"SUM(C116:C122)+C124","v":0},{"$f":"SUM(D116:D122)+D124","v":0},{"$f":"SUM(E116:E122)+E124","v":0},{"$f":"SUM(F116:F122)+F124","v":0},{"$f":"SUM(G116:G122)+G124","v":0},{"$f":"SUM(H116:H122)+H124","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 8","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G128=\"\",E128,G128)=\"\",0,IF(G128=\"\",E128,G128))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B128,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E127,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E127=\"\",0,IF(LEFT(E127,6)=\"Public\",B139*0.44,B132*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E127=\"\",\"\",IF(E127=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E127=\"\",\"\",IF(LEFT(E127,6)=\"Public\",B139*0.44-B140,B132*0.3-B140))","v":""}]
[]
[{"$f":"IF(B141>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q141=\"\",\"\",IF(RIGHT(E127,10)=\"Virksomhed\",IF(SUM(Q132:Q140)/COUNT(Q132:Q140)<>Q141,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$128=\"\",IF(E132=\"\",B132*$E$128,E132),IF(E132=\"\",B132*$G$128,E132)),0)","v":0},{"$f":"IFERROR(B132-C132-F132,0)","v":0},null,null,null,{"$f":"IF(B132=\"\",0,B132)","v":0},{"$f":"IF($E$127<>\"Public research and knowledge dissemination organization\",0,IF(B132=\"\",0,B132))","v":0},null,null,null,null,null,null,{"$f":"A132","v":"Salary "},{"$f":"IFERROR(C132/B132,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B133-C133-F133,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B132:B138)","v":0},{"$f":"SUM(C132:C138)","v":0},{"$f":"SUM(D132:D138)","v":0},{"$f":"SUM(E132:E138)","v":0},{"$f":"SUM(F132:F138)","v":0},{"$f":"SUM(G132:G138)","v":0},{"$f":"SUM(H132:H138)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$128=\"\",IF(E140=\"\",B140*$E$128,E140),IF(E140=\"\",B140*$G$128,E140)),0)","v":0},{"$f":"IFERROR(B140-C140-F140,0)","v":0},null,null,null,{"$f":"IF(B140=\"\",0,B140)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B132:B138)+B140","v":0},{"$f":"SUM(C132:C138)+C140","v":0},{"$f":"SUM(D132:D138)+D140","v":0},{"$f":"SUM(E132:E138)+E140","v":0},{"$f":"SUM(F132:F138)+F140","v":0},{"$f":"SUM(G132:G138)+G140","v":0},{"$f":"SUM(H132:H138)+H140","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 9","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G144=\"\",E144,G144)=\"\",0,IF(G144=\"\",E144,G144))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B144,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E143,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E143=\"\",0,IF(LEFT(E143,6)=\"Public\",B155*0.44,B148*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E143=\"\",\"\",IF(E143=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E143=\"\",\"\",IF(LEFT(E143,6)=\"Public\",B155*0.44-B156,B148*0.3-B156))","v":""}]
[]
[{"$f":"IF(B157>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q157=\"\",\"\",IF(RIGHT(E143,10)=\"Virksomhed\",IF(SUM(Q148:Q156)/COUNT(Q148:Q156)<>Q157,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$144=\"\",IF(E148=\"\",B148*$E$144,E148),IF(E148=\"\",B148*$G$144,E148)),0)","v":0},{"$f":"IFERROR(B148-C148-F148,0)","v":0},null,null,null,{"$f":"IF(B148=\"\",0,B148)","v":0},{"$f":"IF($E$143<>\"Public research and knowledge dissemination organization\",0,IF(B148=\"\",0,B148))","v":0},null,null,null,null,null,null,{"$f":"A148","v":"Salary "},{"$f":"IFERROR(C148/B148,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B149-C149-F149,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B148:B154)","v":0},{"$f":"SUM(C148:C154)","v":0},{"$f":"SUM(D148:D154)","v":0},{"$f":"SUM(E148:E154)","v":0},{"$f":"SUM(F148:F154)","v":0},{"$f":"SUM(G148:G154)","v":0},{"$f":"SUM(H148:H154)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$144=\"\",IF(E156=\"\",B156*$E$144,E156),IF(E156=\"\",B156*$G$144,E156)),0)","v":0},{"$f":"IFERROR(B156-C156-F156,0)","v":0},null,null,null,{"$f":"IF(B156=\"\",0,B156)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B148:B154)+B156","v":0},{"$f":"SUM(C148:C154)+C156","v":0},{"$f":"SUM(D148:D154)+D156","v":0},{"$f":"SUM(E148:E154)+E156","v":0},{"$f":"SUM(F148:F154)+F156","v":0},{"$f":"SUM(G148:G154)+G156","v":0},{"$f":"SUM(H148:H154)+H156","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 10","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G160=\"\",E160,G160)=\"\",0,IF(G160=\"\",E160,G160))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B160,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E159,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E159=\"\",0,IF(LEFT(E159,6)=\"Public\",B171*0.44,B164*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E159=\"\",\"\",IF(E159=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E159=\"\",\"\",IF(LEFT(E159,6)=\"Public\",B171*0.44-B172,B164*0.3-B172))","v":""}]
[]
[{"$f":"IF(B173>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q173=\"\",\"\",IF(RIGHT(E159,10)=\"Virksomhed\",IF(SUM(Q164:Q172)/COUNT(Q164:Q172)<>Q173,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$160=\"\",IF(E164=\"\",B164*$E$160,E164),IF(E164=\"\",B164*$G$160,E164)),0)","v":0},{"$f":"IFERROR(B164-C164-F164,0)","v":0},null,null,null,{"$f":"IF(B164=\"\",0,B164)","v":0},{"$f":"IF($E$159<>\"Public research and knowledge dissemination organization\",0,IF(B164=\"\",0,B164))","v":0},null,null,null,null,null,null,{"$f":"A164","v":"Salary "},{"$f":"IFERROR(C164/B164,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B165-C165-F165,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B164:B170)","v":0},{"$f":"SUM(C164:C170)","v":0},{"$f":"SUM(D164:D170)","v":0},{"$f":"SUM(E164:E170)","v":0},{"$f":"SUM(F164:F170)","v":0},{"$f":"SUM(G164:G170)","v":0},{"$f":"SUM(H164:H170)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$160=\"\",IF(E172=\"\",B172*$E$160,E172),IF(E172=\"\",B172*$G$160,E172)),0)","v":0},{"$f":"IFERROR(B172-C172-F172,0)","v":0},null,null,null,{"$f":"IF(B172=\"\",0,B172)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B164:B170)+B172","v":0},{"$f":"SUM(C164:C170)+C172","v":0},{"$f":"SUM(D164:D170)+D172","v":0},{"$f":"SUM(E164:E170)+E172","v":0},{"$f":"SUM(F164:F170)+F172","v":0},{"$f":"SUM(G164:G170)+G172","v":0},{"$f":"SUM(H164:H170)+H172","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 11","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G176=\"\",E176,G176)=\"\",0,IF(G176=\"\",E176,G176))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B176,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E175,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E175=\"\",0,IF(LEFT(E175,6)=\"Public\",B187*0.44,B180*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E175=\"\",\"\",IF(E175=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E175=\"\",\"\",IF(LEFT(E175,6)=\"Public\",B187*0.44-B188,B180*0.3-B188))","v":""}]
[]
[{"$f":"IF(B189>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q189=\"\",\"\",IF(RIGHT(E175,10)=\"Virksomhed\",IF(SUM(Q180:Q188)/COUNT(Q180:Q188)<>Q189,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$176=\"\",IF(E180=\"\",B180*$E$176,E180),IF(E180=\"\",B180*$G$176,E180)),0)","v":0},{"$f":"IFERROR(B180-C180-F180,0)","v":0},null,null,null,{"$f":"IF(B180=\"\",0,B180)","v":0},{"$f":"IF($E$175<>\"Public research and knowledge dissemination organization\",0,IF(B180=\"\",0,B180))","v":0},null,null,null,null,null,null,{"$f":"A180","v":"Salary "},{"$f":"IFERROR(C180/B180,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B181-C181-F181,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B180:B186)","v":0},{"$f":"SUM(C180:C186)","v":0},{"$f":"SUM(D180:D186)","v":0},{"$f":"SUM(E180:E186)","v":0},{"$f":"SUM(F180:F186)","v":0},{"$f":"SUM(G180:G186)","v":0},{"$f":"SUM(H180:H186)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$176=\"\",IF(E188=\"\",B188*$E$176,E188),IF(E188=\"\",B188*$G$176,E188)),0)","v":0},{"$f":"IFERROR(B188-C188-F188,0)","v":0},null,null,null,{"$f":"IF(B188=\"\",0,B188)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B180:B186)+B188","v":0},{"$f":"SUM(C180:C186)+C188","v":0},{"$f":"SUM(D180:D186)+D188","v":0},{"$f":"SUM(E180:E186)+E188","v":0},{"$f":"SUM(F180:F186)+F188","v":0},{"$f":"SUM(G180:G186)+G188","v":0},{"$f":"SUM(H180:H186)+H188","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 12","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G192=\"\",E192,G192)=\"\",0,IF(G192=\"\",E192,G192))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B192,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E191,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E191=\"\",0,IF(LEFT(E191,6)=\"Public\",B203*0.44,B196*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E191=\"\",\"\",IF(E191=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E191=\"\",\"\",IF(LEFT(E191,6)=\"Public\",B203*0.44-B204,B196*0.3-B204))","v":""}]
[]
[{"$f":"IF(B205>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q205=\"\",\"\",IF(RIGHT(E191,10)=\"Virksomhed\",IF(SUM(Q196:Q204)/COUNT(Q196:Q204)<>Q205,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$192=\"\",IF(E196=\"\",B196*$E$192,E196),IF(E196=\"\",B196*$G$192,E196)),0)","v":0},{"$f":"IFERROR(B196-C196-F196,0)","v":0},null,null,null,{"$f":"IF(B196=\"\",0,B196)","v":0},{"$f":"IF($E$191<>\"Public research and knowledge dissemination organization\",0,IF(B196=\"\",0,B196))","v":0},null,null,null,null,null,null,{"$f":"A196","v":"Salary "},{"$f":"IFERROR(C196/B196,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B197-C197-F197,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B196:B202)","v":0},{"$f":"SUM(C196:C202)","v":0},{"$f":"SUM(D196:D202)","v":0},{"$f":"SUM(E196:E202)","v":0},{"$f":"SUM(F196:F202)","v":0},{"$f":"SUM(G196:G202)","v":0},{"$f":"SUM(H196:H202)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$192=\"\",IF(E204=\"\",B204*$E$192,E204),IF(E204=\"\",B204*$G$192,E204)),0)","v":0},{"$f":"IFERROR(B204-C204-F204,0)","v":0},null,null,null,{"$f":"IF(B204=\"\",0,B204)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B196:B202)+B204","v":0},{"$f":"SUM(C196:C202)+C204","v":0},{"$f":"SUM(D196:D202)+D204","v":0},{"$f":"SUM(E196:E202)+E204","v":0},{"$f":"SUM(F196:F202)+F204","v":0},{"$f":"SUM(G196:G202)+G204","v":0},{"$f":"SUM(H196:H202)+H204","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 13","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G208=\"\",E208,G208)=\"\",0,IF(G208=\"\",E208,G208))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B208,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E207,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E207=\"\",0,IF(LEFT(E207,6)=\"Public\",B219*0.44,B212*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E207=\"\",\"\",IF(E207=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E207=\"\",\"\",IF(LEFT(E207,6)=\"Public\",B219*0.44-B220,B212*0.3-B220))","v":""}]
[]
[{"$f":"IF(B221>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q221=\"\",\"\",IF(RIGHT(E207,10)=\"Virksomhed\",IF(SUM(Q212:Q220)/COUNT(Q212:Q220)<>Q221,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$208=\"\",IF(E212=\"\",B212*$E$208,E212),IF(E212=\"\",B212*$G$208,E212)),0)","v":0},{"$f":"IFERROR(B212-C212-F212,0)","v":0},null,null,null,{"$f":"IF(B212=\"\",0,B212)","v":0},{"$f":"IF($E$207<>\"Public research and knowledge dissemination organization\",0,IF(B212=\"\",0,B212))","v":0},null,null,null,null,null,null,{"$f":"A212","v":"Salary "},{"$f":"IFERROR(C212/B212,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B213-C213-F213,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B212:B218)","v":0},{"$f":"SUM(C212:C218)","v":0},{"$f":"SUM(D212:D218)","v":0},{"$f":"SUM(E212:E218)","v":0},{"$f":"SUM(F212:F218)","v":0},{"$f":"SUM(G212:G218)","v":0},{"$f":"SUM(H212:H218)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$208=\"\",IF(E220=\"\",B220*$E$208,E220),IF(E220=\"\",B220*$G$208,E220)),0)","v":0},{"$f":"IFERROR(B220-C220-F220,0)","v":0},null,null,null,{"$f":"IF(B220=\"\",0,B220)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B212:B218)+B220","v":0},{"$f":"SUM(C212:C218)+C220","v":0},{"$f":"SUM(D212:D218)+D220","v":0},{"$f":"SUM(E212:E218)+E220","v":0},{"$f":"SUM(F212:F218)+F220","v":0},{"$f":"SUM(G212:G218)+G220","v":0},{"$f":"SUM(H212:H218)+H220","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 14","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G224=\"\",E224,G224)=\"\",0,IF(G224=\"\",E224,G224))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B224,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E223,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E223=\"\",0,IF(LEFT(E223,6)=\"Public\",B235*0.44,B228*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E223=\"\",\"\",IF(E223=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E223=\"\",\"\",IF(LEFT(E223,6)=\"Public\",B235*0.44-B236,B228*0.3-B236))","v":""}]
[]
[{"$f":"IF(B237>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q237=\"\",\"\",IF(RIGHT(E223,10)=\"Virksomhed\",IF(SUM(Q228:Q236)/COUNT(Q228:Q236)<>Q237,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$224=\"\",IF(E228=\"\",B228*$E$224,E228),IF(E228=\"\",B228*$G$224,E228)),0)","v":0},{"$f":"IFERROR(B228-C228-F228,0)","v":0},null,null,null,{"$f":"IF(B228=\"\",0,B228)","v":0},{"$f":"IF($E$223<>\"Public research and knowledge dissemination organization\",0,IF(B228=\"\",0,B228))","v":0},null,null,null,null,null,null,{"$f":"A228","v":"Salary "},{"$f":"IFERROR(C228/B228,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B229-C229-F229,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B228:B234)","v":0},{"$f":"SUM(C228:C234)","v":0},{"$f":"SUM(D228:D234)","v":0},{"$f":"SUM(E228:E234)","v":0},{"$f":"SUM(F228:F234)","v":0},{"$f":"SUM(G228:G234)","v":0},{"$f":"SUM(H228:H234)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$224=\"\",IF(E236=\"\",B236*$E$224,E236),IF(E236=\"\",B236*$G$224,E236)),0)","v":0},{"$f":"IFERROR(B236-C236-F236,0)","v":0},null,null,null,{"$f":"IF(B236=\"\",0,B236)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B228:B234)+B236","v":0},{"$f":"SUM(C228:C234)+C236","v":0},{"$f":"SUM(D228:D234)+D236","v":0},{"$f":"SUM(E228:E234)+E236","v":0},{"$f":"SUM(F228:F234)+F236","v":0},{"$f":"SUM(G228:G234)+G236","v":0},{"$f":"SUM(H228:H234)+H236","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 15","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G240=\"\",E240,G240)=\"\",0,IF(G240=\"\",E240,G240))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B240,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E239,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E239=\"\",0,IF(LEFT(E239,6)=\"Public\",B251*0.44,B244*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E239=\"\",\"\",IF(E239=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E239=\"\",\"\",IF(LEFT(E239,6)=\"Public\",B251*0.44-B252,B244*0.3-B252))","v":""}]
[]
[{"$f":"IF(B253>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q253=\"\",\"\",IF(RIGHT(E239,10)=\"Virksomhed\",IF(SUM(Q244:Q252)/COUNT(Q244:Q252)<>Q253,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$240=\"\",IF(E244=\"\",B244*$E$240,E244),IF(E244=\"\",B244*$G$240,E244)),0)","v":0},{"$f":"IFERROR(B244-C244-F244,0)","v":0},null,null,null,{"$f":"IF(B244=\"\",0,B244)","v":0},{"$f":"IF($E$239<>\"Public research and knowledge dissemination organization\",0,IF(B244=\"\",0,B244))","v":0},null,null,null,null,null,null,{"$f":"A244","v":"Salary "},{"$f":"IFERROR(C244/B244,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B245-C245-F245,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B244:B250)","v":0},{"$f":"SUM(C244:C250)","v":0},{"$f":"SUM(D244:D250)","v":0},{"$f":"SUM(E244:E250)","v":0},{"$f":"SUM(F244:F250)","v":0},{"$f":"SUM(G244:G250)","v":0},{"$f":"SUM(H244:H250)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$240=\"\",IF(E252=\"\",B252*$E$240,E252),IF(E252=\"\",B252*$G$240,E252)),0)","v":0},{"$f":"IFERROR(B252-C252-F252,0)","v":0},null,null,null,{"$f":"IF(B252=\"\",0,B252)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B244:B250)+B252","v":0},{"$f":"SUM(C244:C250)+C252","v":0},{"$f":"SUM(D244:D250)+D252","v":0},{"$f":"SUM(E244:E250)+E252","v":0},{"$f":"SUM(F244:F250)+F252","v":0},{"$f":"SUM(G244:G250)+G252","v":0},{"$f":"SUM(H244:H250)+H252","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 16","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G256=\"\",E256,G256)=\"\",0,IF(G256=\"\",E256,G256))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B256,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E255,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E255=\"\",0,IF(LEFT(E255,6)=\"Public\",B267*0.44,B260*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E255=\"\",\"\",IF(E255=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E255=\"\",\"\",IF(LEFT(E255,6)=\"Public\",B267*0.44-B268,B260*0.3-B268))","v":""}]
[]
[{"$f":"IF(B269>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q269=\"\",\"\",IF(RIGHT(E255,10)=\"Virksomhed\",IF(SUM(Q260:Q268)/COUNT(Q260:Q268)<>Q269,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$256=\"\",IF(E260=\"\",B260*$E$256,E260),IF(E260=\"\",B260*$G$256,E260)),0)","v":0},{"$f":"IFERROR(B260-C260-F260,0)","v":0},null,null,null,{"$f":"IF(B260=\"\",0,B260)","v":0},{"$f":"IF($E$255<>\"Public research and knowledge dissemination organization\",0,IF(B260=\"\",0,B260))","v":0},null,null,null,null,null,null,{"$f":"A260","v":"Salary "},{"$f":"IFERROR(C260/B260,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B261-C261-F261,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B260:B266)","v":0},{"$f":"SUM(C260:C266)","v":0},{"$f":"SUM(D260:D266)","v":0},{"$f":"SUM(E260:E266)","v":0},{"$f":"SUM(F260:F266)","v":0},{"$f":"SUM(G260:G266)","v":0},{"$f":"SUM(H260:H266)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$256=\"\",IF(E268=\"\",B268*$E$256,E268),IF(E268=\"\",B268*$G$256,E268)),0)","v":0},{"$f":"IFERROR(B268-C268-F268,0)","v":0},null,null,null,{"$f":"IF(B268=\"\",0,B268)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B260:B266)+B268","v":0},{"$f":"SUM(C260:C266)+C268","v":0},{"$f":"SUM(D260:D266)+D268","v":0},{"$f":"SUM(E260:E266)+E268","v":0},{"$f":"SUM(F260:F266)+F268","v":0},{"$f":"SUM(G260:G266)+G268","v":0},{"$f":"SUM(H260:H266)+H268","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 17","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G272=\"\",E272,G272)=\"\",0,IF(G272=\"\",E272,G272))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B272,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E271,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E271=\"\",0,IF(LEFT(E271,6)=\"Public\",B283*0.44,B276*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E271=\"\",\"\",IF(E271=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E271=\"\",\"\",IF(LEFT(E271,6)=\"Public\",B283*0.44-B284,B276*0.3-B284))","v":""}]
[]
[{"$f":"IF(B285>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q285=\"\",\"\",IF(RIGHT(E271,10)=\"Virksomhed\",IF(SUM(Q276:Q284)/COUNT(Q276:Q284)<>Q285,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$272=\"\",IF(E276=\"\",B276*$E$272,E276),IF(E276=\"\",B276*$G$272,E276)),0)","v":0},{"$f":"IFERROR(B276-C276-F276,0)","v":0},null,null,null,{"$f":"IF(B276=\"\",0,B276)","v":0},{"$f":"IF($E$271<>\"Public research and knowledge dissemination organization\",0,IF(B276=\"\",0,B276))","v":0},null,null,null,null,null,null,{"$f":"A276","v":"Salary "},{"$f":"IFERROR(C276/B276,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B277-C277-F277,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B276:B282)","v":0},{"$f":"SUM(C276:C282)","v":0},{"$f":"SUM(D276:D282)","v":0},{"$f":"SUM(E276:E282)","v":0},{"$f":"SUM(F276:F282)","v":0},{"$f":"SUM(G276:G282)","v":0},{"$f":"SUM(H276:H282)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$272=\"\",IF(E284=\"\",B284*$E$272,E284),IF(E284=\"\",B284*$G$272,E284)),0)","v":0},{"$f":"IFERROR(B284-C284-F284,0)","v":0},null,null,null,{"$f":"IF(B284=\"\",0,B284)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B276:B282)+B284","v":0},{"$f":"SUM(C276:C282)+C284","v":0},{"$f":"SUM(D276:D282)+D284","v":0},{"$f":"SUM(E276:E282)+E284","v":0},{"$f":"SUM(F276:F282)+F284","v":0},{"$f":"SUM(G276:G282)+G284","v":0},{"$f":"SUM(H276:H282)+H284","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 18","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G288=\"\",E288,G288)=\"\",0,IF(G288=\"\",E288,G288))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B288,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E287,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E287=\"\",0,IF(LEFT(E287,6)=\"Public\",B299*0.44,B292*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E287=\"\",\"\",IF(E287=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E287=\"\",\"\",IF(LEFT(E287,6)=\"Public\",B299*0.44-B300,B292*0.3-B300))","v":""}]
[]
[{"$f":"IF(B301>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q301=\"\",\"\",IF(RIGHT(E287,10)=\"Virksomhed\",IF(SUM(Q292:Q300)/COUNT(Q292:Q300)<>Q301,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$288=\"\",IF(E292=\"\",B292*$E$288,E292),IF(E292=\"\",B292*$G$288,E292)),0)","v":0},{"$f":"IFERROR(B292-C292-F292,0)","v":0},null,null,null,{"$f":"IF(B292=\"\",0,B292)","v":0},{"$f":"IF($E$287<>\"Public research and knowledge dissemination organization\",0,IF(B292=\"\",0,B292))","v":0},null,null,null,null,null,null,{"$f":"A292","v":"Salary "},{"$f":"IFERROR(C292/B292,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B293-C293-F293,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B292:B298)","v":0},{"$f":"SUM(C292:C298)","v":0},{"$f":"SUM(D292:D298)","v":0},{"$f":"SUM(E292:E298)","v":0},{"$f":"SUM(F292:F298)","v":0},{"$f":"SUM(G292:G298)","v":0},{"$f":"SUM(H292:H298)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$288=\"\",IF(E300=\"\",B300*$E$288,E300),IF(E300=\"\",B300*$G$288,E300)),0)","v":0},{"$f":"IFERROR(B300-C300-F300,0)","v":0},null,null,null,{"$f":"IF(B300=\"\",0,B300)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B292:B298)+B300","v":0},{"$f":"SUM(C292:C298)+C300","v":0},{"$f":"SUM(D292:D298)+D300","v":0},{"$f":"SUM(E292:E298)+E300","v":0},{"$f":"SUM(F292:F298)+F300","v":0},{"$f":"SUM(G292:G298)+G300","v":0},{"$f":"SUM(H292:H298)+H300","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 19","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G304=\"\",E304,G304)=\"\",0,IF(G304=\"\",E304,G304))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B304,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E303,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E303=\"\",0,IF(LEFT(E303,6)=\"Public\",B315*0.44,B308*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E303=\"\",\"\",IF(E303=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E303=\"\",\"\",IF(LEFT(E303,6)=\"Public\",B315*0.44-B316,B308*0.3-B316))","v":""}]
[]
[{"$f":"IF(B317>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q317=\"\",\"\",IF(RIGHT(E303,10)=\"Virksomhed\",IF(SUM(Q308:Q316)/COUNT(Q308:Q316)<>Q317,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$304=\"\",IF(E308=\"\",B308*$E$304,E308),IF(E308=\"\",B308*$G$304,E308)),0)","v":0},{"$f":"IFERROR(B308-C308-F308,0)","v":0},null,null,null,{"$f":"IF(B308=\"\",0,B308)","v":0},{"$f":"IF($E$303<>\"Public research and knowledge dissemination organization\",0,IF(B308=\"\",0,B308))","v":0},null,null,null,null,null,null,{"$f":"A308","v":"Salary "},{"$f":"IFERROR(C308/B308,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B309-C309-F309,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B308:B314)","v":0},{"$f":"SUM(C308:C314)","v":0},{"$f":"SUM(D308:D314)","v":0},{"$f":"SUM(E308:E314)","v":0},{"$f":"SUM(F308:F314)","v":0},{"$f":"SUM(G308:G314)","v":0},{"$f":"SUM(H308:H314)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$304=\"\",IF(E316=\"\",B316*$E$304,E316),IF(E316=\"\",B316*$G$304,E316)),0)","v":0},{"$f":"IFERROR(B316-C316-F316,0)","v":0},null,null,null,{"$f":"IF(B316=\"\",0,B316)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B308:B314)+B316","v":0},{"$f":"SUM(C308:C314)+C316","v":0},{"$f":"SUM(D308:D314)+D316","v":0},{"$f":"SUM(E308:E314)+E316","v":0},{"$f":"SUM(F308:F314)+F316","v":0},{"$f":"SUM(G308:G314)+G316","v":0},{"$f":"SUM(H308:H314)+H316","v":0},0,null,null,null,null,null,null,"Total",""]
[]
["Company name:",null,"Participant 20","Company size:"]
["Activity type:",null,{"$f":"IF(IF(G320=\"\",E320,G320)=\"\",0,IF(G320=\"\",E320,G320))","v":0},"Maximum subsidy rate:",{"$f":"_xlfn.IFNA(VLOOKUP(B320,'List of subsidy rates'!$A:$K,MATCH(CONCATENATE(E319,\" - \",$H$1),'List of subsidy rates'!$A$1:$K$1,0),FALSE),\"\")","v":""},"Manual subsidy rate:",null,{"$f":"ROUND(IF(E319=\"\",0,IF(LEFT(E319,6)=\"Public\",B331*0.44,B324*0.3)),2)","v":0}]
["OH-percentage",{"$f":"IF(E319=\"\",\"\",IF(E319=\"Public research and knowledge dissemination organization\",0.44,0.3))","v":""},"OH residual amount",{"$f":"IF(E319=\"\",\"\",IF(LEFT(E319,6)=\"Public\",B331*0.44-B332,B324*0.3-B332))","v":""}]
[]
[{"$f":"IF(B333>0,\"Ja\",\"\")","v":""},"Costs","Of which:                                          GUDP","Of which:                               Independent financing","Of which:                                                           GUDP - manual","Of which:                                                                Other public funding - manual","No. of hours",null,null,"Specification of sub-budget",null,null,null,null,null,{"$f":"IF(Q333=\"\",\"\",IF(RIGHT(E319,10)=\"Virksomhed\",IF(SUM(Q324:Q332)/COUNT(Q324:Q332)<>Q333,1,\"\"),\"\"))","v":""},"subsidy rate"]
["Salary ",null,{"$f":"IFERROR(IF($G$320=\"\",IF(E324=\"\",B324*$E$320,E324),IF(E324=\"\",B324*$G$320,E324)),0)","v":0},{"$f":"IFERROR(B324-C324-F324,0)","v":0},null,null,null,{"$f":"IF(B324=\"\",0,B324)","v":0},{"$f":"IF($E$319<>\"Public research and knowledge dissemination organization\",0,IF(B324=\"\",0,B324))","v":0},null,null,null,null,null,null,{"$f":"A324","v":"Salary "},{"$f":"IFERROR(C324/B324,\"\")","v":""}]
["External assistance",null,0,{"$f":"IFERROR(B325-C325-F325,0)","v":0},null,null,null,0,0,null,null,null,null,null,null,"External assistance",""]
["Other costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Other costs",""]
["Apparatus/equipment",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Apparatus/equipment",""]
["Scrap value",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Scrap value",""]
["Income, if any",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Income, if any",""]
["Audit costs",null,0,0,null,null,null,0,0,null,null,null,null,null,null,"Audit costs",""]
["Total excl. OH",{"$f":"SUM(B324:B330)","v":0},{"$f":"SUM(C324:C330)","v":0},{"$f":"SUM(D324:D330)","v":0},{"$f":"SUM(E324:E330)","v":0},{"$f":"SUM(F324:F330)","v":0},{"$f":"SUM(G324:G330)","v":0},{"$f":"SUM(H324:H330)","v":0},0,null,null,null,null,null,null,"Total excl. OH",""]
["OH",null,{"$f":"IFERROR(IF($G$320=\"\",IF(E332=\"\",B332*$E$320,E332),IF(E332=\"\",B332*$G$320,E332)),0)","v":0},{"$f":"IFERROR(B332-C332-F332,0)","v":0},null,null,null,{"$f":"IF(B332=\"\",0,B332)","v":0},0,null,null,null,null,null,null,"OH",""]
["Total",{"$f":"SUM(B324:B330)+B332","v":0},{"$f":"SUM(C324:C330)+C332","v":0},{"$f":"SUM(D324:D330)+D332","v":0},{"$f":"SUM(E324:E330)+E332","v":0},{"$f":"SUM(F324:F330)+F332","v":0},{"$f":"SUM(G324:G330)+G332","v":0},{"$f":"SUM(H324:H330)+H332","v":0},0,null,null,null,null,null,null,"Total",""]

{"sheet":"List of subsidy rates","index":8,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"Public research and knowledge dissemination organization - Individual","Public research and knowledge dissemination organization - Collaboration","Private research and knowledge dissemination organization - Individual","Private research and knowledge dissemination organization - Collaboration","Small company - Individual","Small company - Collaboration","Medium-sized company - Individual","Medium-sized company - Collaboration","Large company - Individual","Large company - Collaboration"]
["Research",0.5,0.9,0.5,0.65,0.9,0.8,0.6,0.75,0.5,0.65]
["Development",0.25,0.9,0.25,0.4,0.45,0.6,0.35,0.5,0.25,0.4]
["Demonstration",0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7]
["*Companies are not allowed co-financing with other public funds"]
["*Public research and knowledge dissemination organizations are not allowed co-financing with own funds"]

{"sheet":"Deliverables","index":9,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,"Acronym:",null,null,null,"Org RDD 9","Individual"]
[null,null,null,null,"Delete red-highlighted text."]
["Work package","Task","Deliverable no.","Type of\ndeliverable 2\n(from the application's  Gantt-chart)","Title of deliverable","Type (e.g. video, scientific article, press release, field day)","Target group - who is the communication material aimed at?","Through which communication channel will you reach the target group?","When? (Expected delivery date)","Responsible project participant"]
[1,1,"D1.1.1","FV1","E.g. \"Impact of rooting areas on hygiene in pig pens\"","\"Peer reviewed scientific article\"","Research community","Scientific journal of cows and pigs"]
[1,1,"D1.1.2","FV5","E.g. \"Influence of feed additives on the gastrointestinal flora\"","Presentation at scientific conference","Research community","Cow and pig scientific conference"]
[2,1,"D.2.1.1","FF3","E.g. \"The Economy of extracting Grass Protein\"","Popular science article","Primary producers & advisors","Økologisk Landbrug [Organic Agriculture] (newspaper)"]
[2,1,"D2.1.2","FF5","E.g. \"Recommendations for improved cow-calf systems\"","Presentation","Primary producers & advisors","Økologi-Kongressen [The Orgainc Congress]"]
[2,2,"D2.2.1","UP1","E.g. \"Green manure extracted from grass, a new product\"","Internal report","Project participants","Project meeting"]
[3,1,"D3.1.1","UF2","E.g. \"Recommendations for the prevention of diarrhea in piglets\"","Report on the prevention of diarrhea in piglets","Primary producers & advisors","DCA report"]
[3,1,"D3.1.2","DF2","E.g. \"Guidance on the use of mechanical weed treatment in fruit orchards\"","Book","Primary producers & advisors","Website, social media, direct mail"]

{"sheet":"Milestones","index":10,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,"Acronym:",null,null,"Org RDD 9",null,"Individuel"]
[null,null,null,"Delete red-highlighted text."]
["Work package","Task","Milestone no.\n","Title (from application and if changed)","Responsible project participant\n(from application and if changed)","Date milestone is expected to be reached according to application","Planned date for milestone, if changed","Actual date where milestone is reached","Fulfilled (OK) or Changes (D)"]
[1,"1.1","M.1.1.2","Eg. \"Experiments brought\", \"Experiment results collected\", \"Manufacturers interviewed\"; \"Experimental protocol prepared\", \"Internal workshop held\" etc."]
[1,1,"M1.1.2"]
[1,2,"M1.2.1"]
[2,1,"M2.1.1"]