{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["BEGIN","PROJECTPARAMETERS","PROJECTGEGEVENS","PROJECTTOTALEN"],"not_rendered":{"charts":2,"defined_names":3,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"BEGIN","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"OVER DEZE SJABLOON"]
[null,"In deze werkmap kunt u de projectparameters, projectgegevens en projecttotalen bijhouden voor het evenement dat u wilt organiseren."]
[null,"Voer de gegevens in op het werkblad Projectparameters om de kolomdiagrammen bij te werken. Voer tevens de gegevens in op het werkblad Projectgegevens. De draaitabel op het werkblad Projecttotalen wordt automatisch bijgewerkt."]
[null,"Voer de bedrijfsnaam in op het werkblad Projectparameters om deze op alle werkbladen automatisch bij te werken."]
[null,"Opmerking:  "]
[null,"In kolom A van elk werkblad in deze werkmap staan aanvullende instructies. Deze tekst is opzettelijk verborgen. Als u tekst wilt verwijderen, selecteert u kolom A en drukt u op Delete. Als u de tekst zichtbaar wilt maken, selecteert u kolom A en wijzigt u de tekenkleur."]
[null,"Als u meer wilt weten over een tabel op een werkblad, drukt u in een tabel op Shift en F10 en selecteert u de optie Tabel en vervolgens Alternatieve tekst."]

{"sheet":"PROJECTPARAMETERS","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"merged":[[23,1,42,3]]}
[null,"Bedrijfsnaam"]
[null,"Tracker voor evenementenbeheerproject"]
[null,{"$f":"B1&\" Vertrouwelijk\"","v":"Bedrijfsnaam Vertrouwelijk"}]
[null,"Gearceerde cellen worden voor u berekend. U hoeft ze niet in te vullen."]
[null,"PROJECTTYPE","ACCOUNTMANAGER","PROJECTMANAGER","STRATEGIEMANAGER","ONTWERPDESKUNDIGE","PERSONEEL EVENEMENT","PERSONEEL ADMINISTRATIE","Totaal"]
[null,"Ontwikkeling van evenementstrategie",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.6,"d":"60%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNTMANAGER]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
[null,"Evenementen organiseren",{"v":0.2,"d":"20%"},{"v":0.5,"d":"50%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNTMANAGER]:[PERSONEEL ADMINISTRATIE]])","v":{"v":0.9999999999999999,"d":"100%"}}]
[null,"Evenementen ontwerpen",{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNTMANAGER]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
[null,"Logistiek van evenementen",{"v":0.2,"d":"20%"},{"v":0.6,"d":"60%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNTMANAGER]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
[null,"Personeel evenement",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.1,"d":"10%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNTMANAGER]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
[null,"Beoordeling door leerling/student",{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0.2,"d":"20%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNTMANAGER]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
[null,"Samengestelde tarieven",{"v":180,"d":"€ 180"},{"v":120,"d":"€ 120"},{"v":150,"d":"€ 150"},{"v":100,"d":"€ 100"},{"v":80,"d":"€ 80"},{"v":60,"d":"€ 60"}]
[]
[{"$nulls":5},"Deze cel bevat een kolomdiagram met het aantal geplande versus werkelijke uren."]
[null,null,"ACCOUNTMANAGER","PROJECTMANAGER","STRATEGIEMANAGER","ONTWERPDESKUNDIGE","PERSONEEL EVENEMENT","PERSONEEL ADMINISTRATIE"]
[null,"GEPLANDE KOSTEN",{"$f":"SUBTOTAL(109,Projectgegevens[ACCOUNTMANAGER])","v":{"v":54000,"d":"kr54,000.00"}},{"$f":"SUBTOTAL(109,Projectgegevens[PROJECTMANAGER])","v":{"v":52200,"d":"kr52,200.00"}},{"$f":"SUBTOTAL(109,Projectgegevens[STRATEGIEMANAGER])","v":{"v":24000,"d":"kr24,000.00"}},{"$f":"SUBTOTAL(109,Projectgegevens[ONTWERPDESKUNDIGE])","v":{"v":29000,"d":"kr29,000.00"}},{"$f":"SUBTOTAL(109,Projectgegevens[PERSONEEL EVENEMENT])","v":{"v":13200,"d":"kr13,200.00"}},{"$f":"SUBTOTAL(109,Projectgegevens[PERSONEEL ADMINISTRATIE])","v":{"v":9000,"d":"kr9,000.00"}}]
[null,"WERKELIJKE KOSTEN",{"$f":"SUBTOTAL(109,Projectgegevens[[ACCOUNTMANAGER ]])","v":{"v":54360,"d":"kr54,360.00"}},{"$f":"SUBTOTAL(109,Projectgegevens[[PROJECTMANAGER ]])","v":{"v":51540,"d":"kr51,540.00"}},{"$f":"SUBTOTAL(109,Projectgegevens[[STRATEGIEMANAGER ]])","v":{"v":25650,"d":"kr25,650.00"}},{"$f":"SUBTOTAL(109,Projectgegevens[[ONTWERPDESKUNDIGE ]])","v":{"v":28900,"d":"kr28,900.00"}},{"$f":"SUBTOTAL(109,Projectgegevens[[PERSONEEL EVENEMENT ]])","v":{"v":13400,"d":"kr13,400.00"}},{"$f":"SUBTOTAL(109,Projectgegevens[[PERSONEEL ADMINISTRATIE ]])","v":{"v":9060,"d":"kr9,060.00"}}]
[null,"GEPLAND AANTAL UREN",{"$f":"C16/$C$12","v":{"v":300,"d":"300.00"}},{"$f":"D16/$C$12","v":{"v":290,"d":"290.00"}},{"v":133.33333333333334,"d":"133.33"},{"v":161.11111111111111,"d":"161.11"},{"v":73.33333333333333,"d":"73.33"},{"v":50,"d":"50.00"}]
[null,"WERKELIJK AANTAL UREN",{"$f":"C17/$C$12","v":{"v":302,"d":"302.00"}},{"$f":"D17/$C$12","v":{"v":286.3333333333333,"d":"286.33"}},{"$f":"E17/$C$12","v":{"v":142.5,"d":"142.50"}},{"$f":"F17/$C$12","v":{"v":160.55555555555554,"d":"160.56"}},{"$f":"G17/$C$12","v":{"v":74.44444444444444,"d":"74.44"}},{"$f":"H17/$C$12","v":{"v":50.333333333333336,"d":"50.33"}}]

{"sheet":"PROJECTGEGEVENS","index":2,"n_rows":10,"n_cols":23,"rows_kept":10}
[null,{"$f":"PROJECTPARAMETERS!B1","v":"Bedrijfsnaam"}]
[null,"Tracker voor evenementenbeheerproject"]
[null,{"$f":"PROJECTPARAMETERS!B3","v":"Bedrijfsnaam Vertrouwelijk"}]
["Typ de projectgegevens in de tabel die in de cel rechts begint.\nINFORMATIE\nAls u een rij aan de tabel rechts wilt toevoegen, selecteert u de laatste cel rechtsonder in de tabel (niet de rij met totalen) en drukt u op Tab. U kunt ook op Shift+F10 drukken op de plek waar u de rij wilt invoegen. Kies dan voor Invoegen > Tabelrijen boven/onder.\nZorg ervoor dat u ongebruikte rijen verwijdert. De draaitabel Projecttotalen gebruikt alle cellen in de berekening. Wanneer er ongebruikte cellen voorkomen, kunnen de resultaten onjuist zijn.","PROJECTNAAM","PROJECTTYPE","GESCHATTE BEGINDATUM","GESCHATTE EINDDATUM","WERKELIJKE BEGINDATUM","WERKELIJKE EINDDATUM","GESCHATTE WERKUREN","WERKELIJKE WERKUREN","GESCHATTE DUUR","WERKELIJKE DUUR","ACCOUNTMANAGER","PROJECTMANAGER","STRATEGIEMANAGER","ONTWERPDESKUNDIGE","PERSONEEL EVENEMENT","PERSONEEL ADMINISTRATIE","ACCOUNTMANAGER ","PROJECTMANAGER ","STRATEGIEMANAGER ","ONTWERPDESKUNDIGE ","PERSONEEL EVENEMENT ","PERSONEEL ADMINISTRATIE "]
[null,"Project 1","Ontwikkeling van evenementstrategie",{"$f":"DATE(YEAR(TODAY()),6,9)","v":"2022-06-09"},{"$f":" DATE(YEAR(TODAY()),8,7)","v":"2022-08-07"},{"$f":"DATE(YEAR(TODAY()),6,29)","v":"2022-06-29"},{"$f":"DATE(YEAR(TODAY()),9,3)","v":"2022-09-03"},200,220,{"$f":"DAYS360(Projectgegevens[[#This Row],[GESCHATTE BEGINDATUM]],Projectgegevens[[#This Row],[GESCHATTE EINDDATUM]],FALSE)","v":58},{"$f":"DAYS360(Projectgegevens[[#This Row],[WERKELIJKE BEGINDATUM]],Projectgegevens[[#This Row],[WERKELIJKE EINDDATUM]],FALSE)","v":64},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":7200,"d":"€ 7,200"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":2400,"d":"€ 2,400"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":18000,"d":"€ 18,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":1200,"d":"€ 1,200"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":7920,"d":"€ 7,920"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":2640,"d":"€ 2,640"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":19800,"d":"€ 19,800"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":1320,"d":"€ 1,320"}}]
[null,"Project 2","Evenementen organiseren",{"$f":"DATE(YEAR(TODAY())+1,6,25)","v":"2023-06-25"},{"$f":"DATE(YEAR(TODAY())+1,7,27)","v":"2023-07-27"},{"$f":"DATE(YEAR(TODAY()),7,15)","v":"2022-07-15"},{"$f":"DATE(YEAR(TODAY())+1,8,25)","v":"2023-08-25"},400,390,{"$f":"DAYS360(Projectgegevens[[#This Row],[GESCHATTE BEGINDATUM]],Projectgegevens[[#This Row],[GESCHATTE EINDDATUM]],FALSE)","v":32},{"$f":"DAYS360(Projectgegevens[[#This Row],[WERKELIJKE BEGINDATUM]],Projectgegevens[[#This Row],[WERKELIJKE EINDDATUM]],FALSE)","v":400},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":14400,"d":"€ 14,400"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":24000,"d":"€ 24,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":6000,"d":"€ 6,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":4000,"d":"€ 4,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":2400,"d":"€ 2,400"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":14040,"d":"€ 14,040"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":23400,"d":"€ 23,400"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":5850,"d":"€ 5,850"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":3900,"d":"€ 3,900"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":2340,"d":"€ 2,340"}}]
[null,"Project 3","Evenementen ontwerpen",{"$f":"DATE(YEAR(TODAY())+2,7,12)","v":"2024-07-12"},{"$f":"DATE(YEAR(TODAY())+2,9,19)","v":"2024-09-19"},"2025-08-07","2025-10-10",500,500,{"$f":"DAYS360(Projectgegevens[[#This Row],[GESCHATTE BEGINDATUM]],Projectgegevens[[#This Row],[GESCHATTE EINDDATUM]],FALSE)","v":67},{"$f":"DAYS360(Projectgegevens[[#This Row],[WERKELIJKE BEGINDATUM]],Projectgegevens[[#This Row],[WERKELIJKE EINDDATUM]],FALSE)","v":63},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":18000,"d":"€ 18,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":12000,"d":"€ 12,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":25000,"d":"€ 25,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":3000,"d":"€ 3,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":18000,"d":"€ 18,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":12000,"d":"€ 12,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":25000,"d":"€ 25,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":3000,"d":"€ 3,000"}}]
[null,"Project 4","Logistiek van evenementen",{"$f":"DATE(YEAR(TODAY())+3,7,30)","v":"2025-07-30"},{"$f":"DATE(YEAR(TODAY())+3,9,28)","v":"2025-09-28"},{"$f":"DATE(YEAR(TODAY())+3,9,14)","v":"2025-09-14"},{"$f":"DATE(YEAR(TODAY())+3,11,13)","v":"2025-11-13"},150,145,{"$f":"DAYS360(Projectgegevens[[#This Row],[GESCHATTE BEGINDATUM]],Projectgegevens[[#This Row],[GESCHATTE EINDDATUM]],FALSE)","v":58},{"$f":"DAYS360(Projectgegevens[[#This Row],[WERKELIJKE BEGINDATUM]],Projectgegevens[[#This Row],[WERKELIJKE EINDDATUM]],FALSE)","v":59},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":5400,"d":"€ 5,400"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":10800,"d":"€ 10,800"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":1200,"d":"€ 1,200"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":900,"d":"€ 900"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":5220,"d":"€ 5,220"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":10440,"d":"€ 10,440"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":1160,"d":"€ 1,160"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":870,"d":"€ 870"}}]
[null,"Project 5","Personeel evenement",{"$f":"DATE(YEAR(TODAY())+4,8,11)","v":"2026-08-11"},{"$f":"DATE(YEAR(TODAY())+4,8,21)","v":"2026-08-21"},{"$f":"DATE(YEAR(TODAY())+4,9,14)","v":"2026-09-14"},{"$f":"DATE(YEAR(TODAY())+4,9,25)","v":"2026-09-25"},250,255,{"$f":"DAYS360(Projectgegevens[[#This Row],[GESCHATTE BEGINDATUM]],Projectgegevens[[#This Row],[GESCHATTE EINDDATUM]],FALSE)","v":10},{"$f":"DAYS360(Projectgegevens[[#This Row],[WERKELIJKE BEGINDATUM]],Projectgegevens[[#This Row],[WERKELIJKE EINDDATUM]],FALSE)","v":11},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":9000,"d":"€ 9,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":3000,"d":"€ 3,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":12000,"d":"€ 12,000"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":1500,"d":"€ 1,500"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ACCOUNTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":9180,"d":"€ 9,180"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PROJECTMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":3060,"d":"€ 3,060"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[STRATEGIEMANAGER]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[ONTWERPDESKUNDIGE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL EVENEMENT]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":12240,"d":"€ 12,240"}},{"$f":"INDEX(Parameters[],MATCH(Projectgegevens[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Projectgegevens[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Projectgegevens[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":1530,"d":"€ 1,530"}}]
[null,"TOTAAL",{"$nulls":5},{"$f":"SUBTOTAL(109,Projectgegevens[GESCHATTE WERKUREN])","v":1500},{"$f":"SUBTOTAL(109,Projectgegevens[WERKELIJKE WERKUREN])","v":1510},{"$f":"SUBTOTAL(109,Projectgegevens[GESCHATTE DUUR])","v":225},{"$f":"SUBTOTAL(109,Projectgegevens[WERKELIJKE DUUR])","v":597}]

{"sheet":"PROJECTTOTALEN","index":3,"n_rows":10,"n_cols":14,"rows_kept":10}
[null,{"$f":"PROJECTPARAMETERS!B1","v":"Bedrijfsnaam"}]
[null,"Tracker voor evenementenbeheerproject"]
[null,{"$f":"PROJECTPARAMETERS!B3","v":"Bedrijfsnaam Vertrouwelijk"}]
["De draaitabel in de cel rechts wordt automatisch bijgewerkt.\nINFORMATIE\nAls u de draaitabel rechts wilt vernieuwen, klikt u op een van de cellen binnen de draaitabel en klikt u op het tabblad Hulpmiddelen voor draaitabellen - Analyseren op Vernieuwen. U kunt ook op Shift+F10 drukken wanneer u een cel van de draaitabel hebt geselecteerd. Klik vervolgens op Vernieuwen.","PROJECTNAAM","ACCOUNTMANAGER - GESCHAT","PROJECTMANAGER - GESCHAT","STRATEGIEMANAGER - GESCHAT","ONTWERPDESKUNDIGE - GESCHAT","PERSONEEL EVENEMENT - GESCHAT","PERSONEEL ADMINISTRATIE - GESCHAT","ACCOUNTMANAGER - WERKELIJK","PROJECTMANAGER - WERKELIJK","STRATEGIEMANAGER - WERKELIJK","ONTWERPDESKUNDIGE - WERKELIJK","PERSONEEL EVENEMENT - WERKELIJK","PERSONEEL ADMINISTRATIE - WERKELIJK"]
[null,"Project 1",{"v":7200,"d":"€ 7,200.00"},{"v":2400,"d":"€ 2,400.00"},{"v":18000,"d":"€ 18,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":1200,"d":"€ 1,200.00"},{"v":7920,"d":"€ 7,920.00"},{"v":2640,"d":"€ 2,640.00"},{"v":19800,"d":"€ 19,800.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":1320,"d":"€ 1,320.00"}]
[null,"Project 2",{"v":14400,"d":"€ 14,400.00"},{"v":24000,"d":"€ 24,000.00"},{"v":6000,"d":"€ 6,000.00"},{"v":4000,"d":"€ 4,000.00"},{"v":0,"d":"€ 0.00"},{"v":2400,"d":"€ 2,400.00"},{"v":14040,"d":"€ 14,040.00"},{"v":23400,"d":"€ 23,400.00"},{"v":5850,"d":"€ 5,850.00"},{"v":3900,"d":"€ 3,900.00"},{"v":0,"d":"€ 0.00"},{"v":2340,"d":"€ 2,340.00"}]
[null,"Project 3",{"v":18000,"d":"€ 18,000.00"},{"v":12000,"d":"€ 12,000.00"},{"v":0,"d":"€ 0.00"},{"v":25000,"d":"€ 25,000.00"},{"v":0,"d":"€ 0.00"},{"v":3000,"d":"€ 3,000.00"},{"v":18000,"d":"€ 18,000.00"},{"v":12000,"d":"€ 12,000.00"},{"v":0,"d":"€ 0.00"},{"v":25000,"d":"€ 25,000.00"},{"v":0,"d":"€ 0.00"},{"v":3000,"d":"€ 3,000.00"}]
[null,"Project 4",{"v":5400,"d":"€ 5,400.00"},{"v":10800,"d":"€ 10,800.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":1200,"d":"€ 1,200.00"},{"v":900,"d":"€ 900.00"},{"v":5220,"d":"€ 5,220.00"},{"v":10440,"d":"€ 10,440.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":1160,"d":"€ 1,160.00"},{"v":870,"d":"€ 870.00"}]
[null,"Project 5",{"v":9000,"d":"€ 9,000.00"},{"v":3000,"d":"€ 3,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":12000,"d":"€ 12,000.00"},{"v":1500,"d":"€ 1,500.00"},{"v":9180,"d":"€ 9,180.00"},{"v":3060,"d":"€ 3,060.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":12240,"d":"€ 12,240.00"},{"v":1530,"d":"€ 1,530.00"}]
[null,"Eindtotaal",{"v":54000,"d":"€ 54,000.00"},{"v":52200,"d":"€ 52,200.00"},{"v":24000,"d":"€ 24,000.00"},{"v":29000,"d":"€ 29,000.00"},{"v":13200,"d":"€ 13,200.00"},{"v":9000,"d":"€ 9,000.00"},{"v":54360,"d":"€ 54,360.00"},{"v":51540,"d":"€ 51,540.00"},{"v":25650,"d":"€ 25,650.00"},{"v":28900,"d":"€ 28,900.00"},{"v":13400,"d":"€ 13,400.00"},{"v":9060,"d":"€ 9,060.00"}]