{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Toelichting","Totaaloverzicht kosten","Naam Penvoerder","Naam Participant 2","Naam Participant 3","Naam Participant 4","Naam Participant 5","Naam Participant 6","Naam Participant 7","Naam Participant 8","Naam Participant 9","Naam Participant 10","Naam Participant 11","Naam Participant 12","Naam Participant 13","Naam Participant 14","Naam Participant 15","Naam Participant 16","Naam Participant 17","Naam Participant 18","Naam Participant 19","Naam Participant 20","Leeg rekenblad","Sheet1"],"not_rendered":{"charts":0,"images":52,"macros":1,"external_links":0,"defined_names":4,"comments":20,"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":"Toelichting","index":0,"n_rows":48,"n_cols":17,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["Toelichting opstellen van projectbegroting (of opgave kostenrealisatie voor rapportage)."]
["Voor een uitgebreide uitleg over de rapportage, verwijzen wij naar de Handreiking onderzoeksuitvraag en projectplan. Deze kunt u downloaden van onze website"]
[]
["Voor het opstellen van uw projectbegroting of opgave van uw kostenrealisatie over een bepaalde projectperiode is deze spreadsheet benodigd. Hierin moeten alle lichtgeel gekleurde velden ingevuld worden."]
["In het geval van een projectbegroting geeft u de begrote kosten op. In het geval van een opgave kostenrealisatie geeft u de gerealiseerde kosten voor de betreffende projectperiode op."]
[]
["Het spreadsheet is opgebouwd uit een aantal werkbladen ( de lichtgele velden zijn dus de invoervelden):"]
["- ","Het eerste werkblad is deze korte 'Toelichting'"]
["-","Het tweede werkblad 'Totaaloverzicht kosten' wordt automatisch gegenereerd op basis van de ingevoerde gegevens"]
[null,"- Hierin moet u in de lichtgele velden aangeven:"]
[null,null,"- de naam van het project"]
[null,null,"- de begin- en einddatum van de rapportage periode."]
[null,null,"- de verdeling van de subsidie en in-cash gelden aan de verschillende projectpartners (dus welke partner ontvangt hoeveel uit deze middelen)."]
["-","In de volgende werkbladen is het de bedoeling dat iedere participant zijn eigen werkblad in de lichtgele velden invult, te beginnen met de Penvoerder in het derde werkblad, daarna Participant 2 in het vierde werkblad, "]
[null,"Participant 3 in het vijfde werkblad, enzovoorts. De naam van de betreffende participant dient op de tab van het betreffende werkblad vermeld te worden; waar nu dus 'Naam participant' staat."]
["-","Achtereenvolgens dient u op uw werkblad aan te geven:"]
[null,"- Bovenaan in kolom C:"]
[null,null,"- de naam van de penvoerder / participant"]
[null,null,"- de begin- en einddatum van de projectactiviteiten "]
[null,"- In cel D8:"]
[null,null,"- in het pull-down menu in het lichtgele veld selecteert u de te hanteren tarieven / kostenmethodiek. Voor meer informatie hierover verwijzen wij u naar deze",null,null,null,null,null,null,null,null,null,null,null,null,null,"link naar de toelichting"]
[]
[null,"- Onder 1: PERSONELE KOSTEN (medewerkers in loondienst en conform kostenmethodiek)"]
[null,null,"- de namen van de medewerkers"]
[null,null,"- per medewerker, het bijbehorende aantal uren begroot"]
[null,null,"- per medewerker, het bijbehorende uurtarief conform de gekozen kostenmethodiek:"]
[null,null," (berekening voor loonkosten o.b.v. brutoloonkosten incl. werkgeverslasten zoals pensioen en sociale lasten, uitgaande van 1650 productieve uren per jaar)."]
[]
[null,"- Onder 2: KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,"- De naam van derden die is ingehuurd"]
[null,null,"- De bijbehorende kosten van inhuur"]
[]
[null,"- Onder 3: OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,null,"- 3a. De kostenposten en bijbehorende kosten voor te verbruiken materialen en hulpmiddelen (o.b.v. hist. aanschafprijzen)"]
[null,null,"- 3b. De kostenposten en bijbehorende kosten voor verspreidingen en overdracht van kennis"]
[]
[null,"- Tenslotte bij FINANCIERING dient u in te voeren: "]
[null,null,"- De bijdrage participant in natura"]
[null,null,"- De bijdrage participant in cash"]
[null,null,"- De penvoerder geeft in het pull-down menu in D59 aan om welke type onderzoek het gaat"]
[]
["- Op het werkblad 'Totaaloverzicht kosten' dienen uiteraard de 'Totaal projectkosten' (4) gelijk te zijn aan de 'Totale projectfinanciering' (5) "]

{"sheet":"Totaaloverzicht kosten","index":1,"n_rows":30,"n_cols":23,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,0,6,1],[5,2,5,10],[24,0,24,4]]}
["Naam project:"]
["Datum aanvang project:","2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7500]
["Datum einde project:","2022-12-31"]
[]
["KOSTEN"]
["Posten",null,"Participanten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaal"]
[null,null,"Penvoerder","Participant 2","Participant 3","Participant 4","Participant 5","Participant 6","Participant 7","Participant 8","Participant 9","Participant 10","Participant 11","Participant 12","Participant 13","Participant 14","Participant 15","Participant 16","Participant 17","Participant 18","Participant 19","Participant 20"]
["Omschrijving","Eenheid",{"$f":"+'Naam Penvoerder'!$C1","v":"Naam penvoerder"},{"$f":"+'Naam Participant 2'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 3'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 4'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 5'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 6'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 7'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 8'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 9'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 10'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 11'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 12'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 13'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 14'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 15'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 16'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 17'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 18'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 19'!C1","v":"Naam Participant"},{"$f":"+'Naam Participant 20'!C1","v":"Naam Participant"}]
["Totale tijdsbesteding (in uren)","Uren",{"$f":"+'Naam Penvoerder'!$C21","v":0},{"$f":"+'Naam Participant 2'!$C21","v":0},{"$f":"+'Naam Participant 3'!$C21","v":0},{"$f":"+'Naam Participant 4'!$C21","v":0},{"$f":"+'Naam Participant 5'!$C21","v":0},{"$f":"+'Naam Participant 6'!$C21","v":0},{"$f":"+'Naam Participant 7'!$C21","v":0},{"$f":"+'Naam Participant 8'!$C21","v":0},{"$f":"+'Naam Participant 9'!$C21","v":0},{"$f":"+'Naam Participant 10'!$C21","v":0},{"$f":"+'Naam Participant 11'!$C21","v":0},{"$f":"+'Naam Participant 12'!$C21","v":0},{"$f":"+'Naam Participant 13'!$C21","v":0},{"$f":"+'Naam Participant 14'!$C21","v":0},{"$f":"+'Naam Participant 15'!$C21","v":0},{"$f":"+'Naam Participant 16'!$C21","v":0},{"$f":"+'Naam Participant 17'!$C21","v":0},{"$f":"+'Naam Participant 18'!$C21","v":0},{"$f":"+'Naam Participant 19'!$C21","v":0},{"$f":"+'Naam Participant 20'!$C21","v":0},{"$f":"SUM(C9:V9)","v":0}]
["1. TOTAAL PERSONELE KOSTEN (Σ a x b)","Euro",{"$f":"+'Naam Penvoerder'!$G21","v":0},{"$f":"+'Naam Participant 2'!$G21","v":0},{"$f":"+'Naam Participant 3'!$G21","v":0},{"$f":"+'Naam Participant 4'!$G21","v":0},{"$f":"+'Naam Participant 5'!$G21","v":0},{"$f":"+'Naam Participant 6'!$G21","v":0},{"$f":"+'Naam Participant 7'!$G21","v":0},{"$f":"+'Naam Participant 8'!$G21","v":0},{"$f":"+'Naam Participant 9'!$G21","v":0},{"$f":"+'Naam Participant 10'!$G21","v":0},{"$f":"+'Naam Participant 11'!$G21","v":0},{"$f":"+'Naam Participant 12'!$G21","v":0},{"$f":"+'Naam Participant 13'!$G21","v":0},{"$f":"+'Naam Participant 14'!$G21","v":0},{"$f":"+'Naam Participant 15'!$G21","v":0},{"$f":"+'Naam Participant 16'!$G21","v":0},{"$f":"+'Naam Participant 17'!$G21","v":0},{"$f":"+'Naam Participant 18'!$G21","v":0},{"$f":"+'Naam Participant 19'!$G21","v":0},{"$f":"+'Naam Participant 20'!$G21","v":0},0]
[" - TOTAAL DIRECTE PERSONELE KOSTEN (Σ a x b)","Euro",{"$f":"+'Naam Penvoerder'!E21","v":0},{"$f":"+'Naam Participant 2'!$E21","v":0},{"$f":"+'Naam Participant 3'!$E21","v":0},{"$f":"+'Naam Participant 4'!$E21","v":0},{"$f":"+'Naam Participant 5'!$E21","v":0},{"$f":"+'Naam Participant 6'!$E21","v":0},{"$f":"+'Naam Participant 7'!$E21","v":0},{"$f":"+'Naam Participant 8'!$E21","v":0},{"$f":"+'Naam Participant 9'!$E21","v":0},{"$f":"+'Naam Participant 10'!$E21","v":0},{"$f":"+'Naam Participant 11'!$E21","v":0},{"$f":"+'Naam Participant 12'!$E21","v":0},{"$f":"+'Naam Participant 13'!$E21","v":0},{"$f":"+'Naam Participant 14'!$E21","v":0},{"$f":"+'Naam Participant 15'!$E21","v":0},{"$f":"+'Naam Participant 16'!$E21","v":0},{"$f":"+'Naam Participant 17'!$E21","v":0},{"$f":"+'Naam Participant 18'!$E21","v":0},{"$f":"+'Naam Participant 19'!$E21","v":0},{"$f":"+'Naam Participant 20'!$E21","v":0},{"$f":"SUM(C11:V11)","v":0}]
[" - TOTAAL OPSLAG 50% VOOR ALGEMENE KOSTEN","Euro",{"$f":"+'Naam Penvoerder'!$F21","v":0},{"$f":"+'Naam Participant 2'!$F21","v":0},{"$f":"+'Naam Participant 3'!$F21","v":0},{"$f":"+'Naam Participant 4'!$F21","v":0},{"$f":"+'Naam Participant 5'!$F21","v":0},{"$f":"+'Naam Participant 6'!$F21","v":0},{"$f":"+'Naam Participant 7'!$F21","v":0},{"$f":"+'Naam Participant 8'!$F21","v":0},{"$f":"+'Naam Participant 9'!$F21","v":0},{"$f":"+'Naam Participant 10'!$F21","v":0},{"$f":"+'Naam Participant 11'!$F21","v":0},{"$f":"+'Naam Participant 12'!$F21","v":0},{"$f":"+'Naam Participant 13'!$F21","v":0},{"$f":"+'Naam Participant 14'!$F21","v":0},{"$f":"+'Naam Participant 15'!$F21","v":0},{"$f":"+'Naam Participant 16'!$F21","v":0},{"$f":"+'Naam Participant 17'!$F21","v":0},{"$f":"+'Naam Participant 18'!$F21","v":0},{"$f":"+'Naam Participant 19'!$F21","v":0},{"$f":"+'Naam Participant 20'!$F21","v":0},{"$f":"SUM(C12:V12)","v":0}]
["2. TOTAAL KOSTEN VAN INHUUR DERDEN ","Euro",{"$f":"+'Naam Penvoerder'!$G30","v":0},{"$f":"+'Naam Participant 2'!$G30","v":0},{"$f":"+'Naam Participant 3'!$G30","v":0},{"$f":"+'Naam Participant 4'!$G30","v":0},{"$f":"+'Naam Participant 5'!$G30","v":0},{"$f":"+'Naam Participant 6'!$G30","v":0},{"$f":"+'Naam Participant 7'!$G30","v":0},{"$f":"+'Naam Participant 8'!$G30","v":0},{"$f":"+'Naam Participant 9'!$G30","v":0},{"$f":"+'Naam Participant 10'!$G30","v":0},{"$f":"+'Naam Participant 11'!$G30","v":0},{"$f":"+'Naam Participant 12'!$G30","v":0},{"$f":"+'Naam Participant 13'!$G30","v":0},{"$f":"+'Naam Participant 14'!$G30","v":0},{"$f":"+'Naam Participant 15'!$G30","v":0},{"$f":"+'Naam Participant 16'!$A31","v":0},{"$f":"+'Naam Participant 17'!$G30","v":0},{"$f":"+'Naam Participant 18'!$G30","v":0},{"$f":"+'Naam Participant 19'!$G30","v":0},{"$f":"+'Naam Participant 20'!$G30","v":0},0]
["3. TOTAAL OVERIGE PROJECTGERELATEERDE KOSTEN             ","Euro",{"$f":"+'Naam Penvoerder'!$G51","v":0},{"$f":"+'Naam Participant 2'!$G51","v":0},{"$f":"+'Naam Participant 3'!$G51","v":0},{"$f":"+'Naam Participant 4'!$G51","v":0},{"$f":"+'Naam Participant 5'!$G51","v":0},{"$f":"+'Naam Participant 6'!$G51","v":0},{"$f":"+'Naam Participant 7'!$G51","v":0},{"$f":"+'Naam Participant 8'!$G51","v":0},{"$f":"+'Naam Participant 9'!$G51","v":0},{"$f":"+'Naam Participant 10'!$G51","v":0},{"$f":"+'Naam Participant 11'!$G51","v":0},{"$f":"+'Naam Participant 12'!$G51","v":0},{"$f":"+'Naam Participant 13'!$G51","v":0},{"$f":"+'Naam Participant 14'!$G51","v":0},{"$f":"+'Naam Participant 15'!$G51","v":0},{"$f":"+'Naam Participant 16'!$G51","v":0},{"$f":"+'Naam Participant 17'!$G51","v":0},{"$f":"+'Naam Participant 18'!$G51","v":0},{"$f":"+'Naam Participant 19'!$G51","v":0},{"$f":"+'Naam Participant 20'!$G51","v":0},0]
["4. TOTAAL BEGROTE PROJECTKOSTEN (gelijk aan totaal 5) of gerealiseerde kosten","Euro",{"$f":"+'Naam Penvoerder'!$G53","v":0},{"$f":"+'Naam Participant 2'!$G53","v":0},{"$f":"+'Naam Participant 3'!$G53","v":0},{"$f":"+'Naam Participant 4'!$G53","v":0},{"$f":"+'Naam Participant 5'!$G53","v":0},{"$f":"+'Naam Participant 6'!$G53","v":0},{"$f":"+'Naam Participant 7'!$G53","v":0},{"$f":"+'Naam Participant 8'!$G53","v":0},{"$f":"+'Naam Participant 9'!$G53","v":0},{"$f":"+'Naam Participant 10'!$G53","v":0},{"$f":"+'Naam Participant 11'!$G53","v":0},{"$f":"+'Naam Participant 12'!$G53","v":0},{"$f":"+'Naam Participant 13'!$G53","v":0},{"$f":"+'Naam Participant 14'!$G53","v":0},{"$f":"+'Naam Participant 15'!$G53","v":0},{"$f":"+'Naam Participant 16'!$G53","v":0},{"$f":"+'Naam Participant 17'!$G53","v":0},{"$f":"+'Naam Participant 18'!$G53","v":0},{"$f":"+'Naam Participant 19'!$G53","v":0},{"$f":"+'Naam Participant 20'!$G53","v":0},0]
[]
["FINANCIERING"]
["Bijdrage participant in natura","Euro",{"$f":"+'Naam Penvoerder'!$G56","v":0},{"$f":"+'Naam Participant 2'!$G56","v":0},{"$f":"+'Naam Participant 3'!$G56","v":0},{"$f":"+'Naam Participant 4'!$G56","v":0},{"$f":"+'Naam Participant 5'!$G56","v":0},{"$f":"+'Naam Participant 6'!$G56","v":0},{"$f":"+'Naam Participant 7'!$G56","v":0},{"$f":"+'Naam Participant 8'!$G56","v":0},{"$f":"+'Naam Participant 9'!$G56","v":0},{"$f":"+'Naam Participant 10'!$G56","v":0},{"$f":"+'Naam Participant 11'!$G56","v":0},{"$f":"+'Naam Participant 12'!$G56","v":0},{"$f":"+'Naam Participant 13'!$G56","v":0},{"$f":"+'Naam Participant 14'!$G56","v":0},{"$f":"+'Naam Participant 15'!$G56","v":0},{"$f":"+'Naam Participant 16'!$G56","v":0},{"$f":"+'Naam Participant 17'!$G56","v":0},{"$f":"+'Naam Participant 18'!$G56","v":0},{"$f":"+'Naam Participant 19'!$G56","v":0},{"$f":"+'Naam Participant 20'!$G56","v":0},{"$f":"SUM(C18:V18)","v":0}]
["Bijdrage participant in cash","Euro",{"$f":"+'Naam Penvoerder'!$G57","v":0},{"$f":"+'Naam Participant 2'!$G57","v":0},{"$f":"+'Naam Participant 3'!$G57","v":0},{"$f":"+'Naam Participant 4'!$G57","v":0},{"$f":"+'Naam Participant 5'!$G57","v":0},{"$f":"+'Naam Participant 6'!$G57","v":0},{"$f":"+'Naam Participant 7'!$G57","v":0},{"$f":"+'Naam Participant 8'!$G57","v":0},{"$f":"+'Naam Participant 9'!$G57","v":0},{"$f":"+'Naam Participant 10'!$G57","v":0},{"$f":"+'Naam Participant 11'!$G57","v":0},{"$f":"+'Naam Participant 12'!$G57","v":0},{"$f":"+'Naam Participant 13'!$G57","v":0},{"$f":"+'Naam Participant 14'!$G57","v":0},{"$f":"+'Naam Participant 15'!$G57","v":0},{"$f":"+'Naam Participant 16'!$G57","v":0},{"$f":"+'Naam Participant 17'!$G57","v":0},{"$f":"+'Naam Participant 18'!$G57","v":0},{"$f":"+'Naam Participant 19'!$G57","v":0},{"$f":"+'Naam Participant 20'!$G57","v":0},{"$f":"SUM(C19:V19)","v":0}]
["Totale bijdrage participant","Euro",{"$f":"+C18+C19","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+M18+M19","v":0},0,0,0,0,0,0,0,0,0,0]
["Maximale Subsidiebijdrage","Euro",{"$f":"+'Naam Penvoerder'!G59","v":0},{"$f":"+'Naam Participant 2'!$G59","v":0},{"$f":"+'Naam Participant 3'!$G59","v":0},{"$f":"+'Naam Participant 4'!$G59","v":0},{"$f":"+'Naam Participant 5'!$G59","v":0},{"$f":"+'Naam Participant 6'!$G59","v":0},{"$f":"+'Naam Participant 7'!$G59","v":0},{"$f":"+'Naam Participant 8'!$G59","v":0},{"$f":"+'Naam Participant 9'!$G59","v":0},{"$f":"+'Naam Participant 10'!$G59","v":0},{"$f":"+'Naam Participant 11'!$G59","v":0},{"$f":"+'Naam Participant 12'!$G59","v":0},{"$f":"+'Naam Participant 13'!$G59","v":0},{"$f":"+'Naam Participant 14'!$G59","v":0},{"$f":"+'Naam Participant 15'!$G59","v":0},{"$f":"+'Naam Participant 16'!$G59","v":0},{"$f":"+'Naam Participant 17'!$G59","v":0},{"$f":"+'Naam Participant 18'!$G59","v":0},{"$f":"+'Naam Participant 19'!$G59","v":0},{"$f":"+'Naam Participant 20'!$G59","v":0},{"$f":"SUM(C21:V21)","v":0}]
["5. TOTAAL PROJECTFINANCIERING (gelijk aan totaal 4)","EURO",{"$f":"+'Naam Penvoerder'!$G$60","v":0},{"$f":"+'Naam Participant 2'!$G60","v":0},{"$f":"+'Naam Participant 3'!$G60","v":0},{"$f":"+'Naam Participant 4'!$G60","v":0},{"$f":"+'Naam Participant 5'!$G60","v":0},{"$f":"+'Naam Participant 6'!$G60","v":0},{"$f":"+'Naam Participant 7'!$G60","v":0},{"$f":"+'Naam Participant 8'!$G60","v":0},{"$f":"+'Naam Participant 9'!$G60","v":0},{"$f":"+'Naam Participant 10'!$G60","v":0},{"$f":"+'Naam Participant 11'!$G60","v":0},{"$f":"+'Naam Participant 12'!$G60","v":0},{"$f":"+'Naam Participant 13'!$G60","v":0},{"$f":"+'Naam Participant 14'!$G60","v":0},{"$f":"+'Naam Participant 15'!$G60","v":0},{"$f":"+'Naam Participant 16'!$G60","v":0},{"$f":"+'Naam Participant 17'!$G60","v":0},{"$f":"+'Naam Participant 18'!$G60","v":0},{"$f":"+'Naam Participant 19'!$G60","v":0},{"$f":"+'Naam Participant 20'!$G60","v":0},{"$f":"SUM(W20+W21)","v":0}]
[null,null,{"$f":"+C20+C21","v":0},{"$f":"+D20+D21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["FINANCIEEL OVERZICHT VERDELING VAN DE SUBSIDIE- EN CASHBIJDRAGEN"]
[null,{"$f":"+B8","v":"Eenheid"},{"$f":"+C8","v":"Naam penvoerder"},"Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Naam Participant","Totaal project"]
["Dekkingsplan"]
["Verdeling subsidie aan (totaal is gelijk aan bedrag uit cel W21): ","Euro"]
["Verdeling cashbijdrage aan: (totaal is gelijk aan bedrag uit cel W19)","Euro"]
["Totaal","Èuro"]

{"sheet":"Naam Penvoerder","index":2,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[47,1,47,4],[48,1,48,4],[1,2,1,3],[2,2,2,3],[24,1,24,4],[25,1,25,4],[26,1,26,4],[43,1,43,4],[44,1,44,4],[45,1,45,4],[46,1,46,4],[6,2,6,4],[39,1,39,4],[38,1,38,4],[27,1,27,4],[28,1,28,4],[0,2,0,3],[42,1,42,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4]]}
["Naam organisatie:",null,"Naam penvoerder"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef eerst juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,0,{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,0,{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,{"$f":"+IF(LEFT($D$8,1)=\"W\",E13*0.5,0)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage","Geef juiste type onderzoek aan:","Industrieel (R&D) onderzoek",null,{"$f":"+VLOOKUP($D$59,$Z$3:$AA$5,2,)","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 2","index":3,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[48,1,48,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[35,1,35,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[0,2,0,3],[43,1,43,4],[44,1,44,4],[1,2,1,3],[42,1,42,4],[2,2,2,3],[25,1,25,4],[24,1,24,4],[33,1,33,4],[36,1,36,4],[6,2,6,4],[34,1,34,4],[39,1,39,4],[37,1,37,4],[38,1,38,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef eerst juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,0,{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,0,{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 3","index":4,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[48,1,48,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[35,1,35,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[0,2,0,3],[43,1,43,4],[44,1,44,4],[1,2,1,3],[42,1,42,4],[2,2,2,3],[25,1,25,4],[24,1,24,4],[33,1,33,4],[36,1,36,4],[6,2,6,4],[34,1,34,4],[39,1,39,4],[37,1,37,4],[38,1,38,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef eerst juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,0,{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,0,{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 4","index":5,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,3],[37,1,37,4],[38,1,38,4],[39,1,39,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[2,2,2,3],[25,1,25,4],[26,1,26,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[33,1,33,4],[42,1,42,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[43,1,43,4],[44,1,44,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef eerst juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,0,{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,0,{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 5","index":6,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,3],[37,1,37,4],[38,1,38,4],[39,1,39,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[2,2,2,3],[25,1,25,4],[26,1,26,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[33,1,33,4],[42,1,42,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[43,1,43,4],[44,1,44,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef eerst juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 6","index":7,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,3],[37,1,37,4],[38,1,38,4],[39,1,39,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[2,2,2,3],[25,1,25,4],[26,1,26,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[33,1,33,4],[42,1,42,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[43,1,43,4],[44,1,44,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef eerst juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 7","index":8,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,3],[37,1,37,4],[38,1,38,4],[39,1,39,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[2,2,2,3],[25,1,25,4],[26,1,26,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[33,1,33,4],[42,1,42,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[43,1,43,4],[44,1,44,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef eerst juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 8","index":9,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,3],[37,1,37,4],[38,1,38,4],[39,1,39,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[2,2,2,3],[25,1,25,4],[26,1,26,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[33,1,33,4],[42,1,42,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[43,1,43,4],[44,1,44,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef eerst juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 9","index":10,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,3],[37,1,37,4],[38,1,38,4],[39,1,39,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[2,2,2,3],[25,1,25,4],[26,1,26,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[33,1,33,4],[42,1,42,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[43,1,43,4],[44,1,44,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 10","index":11,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,3],[37,1,37,4],[38,1,38,4],[39,1,39,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[2,2,2,3],[25,1,25,4],[26,1,26,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[33,1,33,4],[42,1,42,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[43,1,43,4],[44,1,44,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 11","index":12,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[37,1,37,4],[34,1,34,4],[35,1,35,4],[28,1,28,4],[33,1,33,4],[0,2,0,3],[25,1,25,4],[26,1,26,4],[36,1,36,4],[2,2,2,3],[27,1,27,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[47,1,47,4],[48,1,48,4],[38,1,38,4],[39,1,39,4],[45,1,45,4],[43,1,43,4],[44,1,44,4],[46,1,46,4],[42,1,42,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 12","index":13,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,1,46,4],[0,2,0,3],[2,2,2,3],[25,1,25,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[47,1,47,4],[48,1,48,4],[42,1,42,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[33,1,33,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[43,1,43,4],[44,1,44,4],[45,1,45,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 13","index":14,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,1,46,4],[0,2,0,3],[2,2,2,3],[25,1,25,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[47,1,47,4],[48,1,48,4],[42,1,42,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[33,1,33,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[43,1,43,4],[44,1,44,4],[45,1,45,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 14","index":15,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,1,46,4],[0,2,0,3],[2,2,2,3],[25,1,25,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[47,1,47,4],[48,1,48,4],[42,1,42,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[33,1,33,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[43,1,43,4],[44,1,44,4],[45,1,45,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 15","index":16,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,1,46,4],[0,2,0,3],[2,2,2,3],[25,1,25,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[47,1,47,4],[48,1,48,4],[42,1,42,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[33,1,33,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[43,1,43,4],[44,1,44,4],[45,1,45,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 16","index":17,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,1,46,4],[0,2,0,3],[2,2,2,3],[25,1,25,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[47,1,47,4],[48,1,48,4],[42,1,42,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[33,1,33,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[43,1,43,4],[44,1,44,4],[45,1,45,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 17","index":18,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,1,46,4],[0,2,0,3],[2,2,2,3],[25,1,25,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[47,1,47,4],[48,1,48,4],[42,1,42,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[33,1,33,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[43,1,43,4],[44,1,44,4],[45,1,45,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 18","index":19,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,1,46,4],[0,2,0,3],[2,2,2,3],[25,1,25,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[47,1,47,4],[48,1,48,4],[42,1,42,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[33,1,33,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[43,1,43,4],[44,1,44,4],[45,1,45,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 19","index":20,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,1,46,4],[0,2,0,3],[2,2,2,3],[25,1,25,4],[1,2,1,3],[6,2,6,4],[24,1,24,4],[47,1,47,4],[48,1,48,4],[42,1,42,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[35,1,35,4],[33,1,33,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[43,1,43,4],[44,1,44,4],[45,1,45,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Naam Participant 20","index":21,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,3],[1,2,1,3],[2,2,2,3],[6,2,6,4],[24,1,24,4],[25,1,25,4],[43,1,43,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[42,1,42,4],[44,1,44,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4]]}
["Naam organisatie:",null,"Naam Participant"]
["Aanvang projectactiviteiten:",null,"2022-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type onderzoek","Subsidie bijdrage"]
["Einde projectactiviteiten:",null,"2022-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Experimentele ontwikkeling",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrieel (R&D) onderzoek",0.5]
[null,"KOSTEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netwerkactiviteit",0.5]
[1,"PERSONELE KOSTEN"]
[null,null,"DIRECTE PERSONELE KOSTEN",null,null,"OPSLAG 50%\n\n\n(alg. Kosten)","TOTAAL PERSONELE KOSTEN PER MEDEWERKER\n(incl. 50% alg. kosten)"]
[null,null,"Geef juiste type te hanteren tarief aan:","Integrale kostensystematiek (IKS)"]
[null,null,"Totale Tijdsbesteding","Tarief","Kosten"]
[null,null,"Aantal uren (max. 1650 p.j.)","Euro / uur","Euro","Euro","Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariefmethodiek"]
[null,"Naam medewerker 1",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C11*D11","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E11*0.5,0)","v":0},{"$f":"+E11+F11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrale kostensystematiek (IKS)"]
[null,"Naam medewerker 2",null,{"$f":"+IF(LEFT($D$8,1)=\"A\",60,0)","v":0},{"$f":"+C12*D12","v":0},{"$f":"+IF(LEFT($D$8,1)=\"W\",E12*0.5,0)","v":0},{"$f":"+E12+F12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkelijke loonkosten plus vaste-opslag 50%"]
[null,"Naam medewerker 3",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-in vast uurtarief van 60 euro"]
[null,"Naam medewerker 4",null,0,0,0,0]
[null,"Naam medewerker 5",null,0,0,0,0]
[null,"Naam medewerker 6",null,0,0,0,0]
[null,"Naam medewerker 7",null,0,0,0,0]
[null,"Naam medewerker 8",null,0,0,0,0]
[null,"Naam medewerker 9",null,0,0,0,0]
[null,"Naam medewerker 10",null,0,0,0,0]
[null,"TOTAAL",{"$f":"SUM(C11:C20)","v":0},null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"SUM(G11:G20)","v":0}]
[]
[2,"KOSTEN VAN INHUUR VAN DERDEN"]
[null,null,null,null,null,null,"Euro"]
[null,"Naam derde partij 1"]
[null,"Naam derde partij 2"]
[null,"Naam derde partij 3"]
[null,"Naam derde partij 4"]
[null,"Naam derde partij 5"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G29)","v":0}]
[]
[3,"OVERIGE PROJECTGERELATEERDE KOSTEN"]
[null,"a. Kosten voor te gebruiken materialen en hulpmiddelen (o.b.v. historische aanschafprijzen)",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G34:G40)","v":0}]
[null,"b. Kosten voor verspreidingen en overdracht van kennis",null,null,null,null,"Euro"]
[null,"Kostenpost 1 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 2 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 3 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 4 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 5 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 6 (conform opgegeven post uit projectplan)"]
[null,"Kostenpost 7 (conform opgegeven post uit projectplan)"]
[null,"TOTAAL",null,null,null,null,{"$f":"SUM(G43:G49)","v":0}]
[null,"TOTAAL",null,null,null,null,{"$f":"+G41+G50","v":0}]
[]
[4,"TOTAAL BEGROTE PROJECTKOSTEN (of totaal gerealiseerde projectkosten in geval een opgave kostenrealisatie)",null,null,null,null,{"$f":"+G21+G30+G51","v":0}]
[]
[null,"FINANCIERING"]
[null,"Bijdrage participant in natura"]
[null,"Bijdrage participant in cash"]
[null,"Totale bijdrage participant",null,null,null,null,{"$f":"+G56+G57","v":0}]
[null,"Maximale subsidiebijdrage",null,null,null,{"$f":"+'Naam Penvoerder'!$F59","v":0.5},{"$f":"+G53*F59","v":0}]
[5,"TOTAAL PROJECTFINANCIERING ",null,null,null,null,{"$f":"+G59+G58","v":0}]

{"sheet":"Leeg rekenblad","index":22,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":23,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}