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

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"OVER DEZE SJABLOON"]
[]
[null,"Gebruik deze werkmap om projectparameters, projectgegevens en projecttotalen bij te houden tijdens het plannen van Projectplanning voor advocatenkantoren."]
[null,"Voer de bedrijfsnaam in op het werkblad Projectgegevens om deze op alle werkbladen automatisch bij te werken."]
[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,"Opmerking:  "]
[null,"Kolom A van elk werkblad bevat aanvullende instructies. Deze tekst is opzettelijk verborgen. Als u tekst wilt verwijderen, selecteert u kolom A en drukt u op Verwijderen. 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. Als u meer wilt weten over een draaitabel op het werkblad Projecttotalen, drukt u in een tabel op Shift en F10 en selecteert u de optie Opties voor draaitabel en vervolgens Alt-tekst."]

{"sheet":"PROJECTPARAMETERS","index":1,"n_rows":19,"n_cols":9,"rows_kept":19}
["Voer op dit werkblad de projectparameters in. Voer in de cel rechts de naam van het Bedrijfsnaam in. Nuttige instructies zijn te vinden in de cellen in deze kolom.","Bedrijfsnaam"]
["De titel van dit werkblad staat in de cel rechts.","Projectplanning voor advocatenkantoren"]
["De vertrouwelijkheidsboodschap staat in de cel rechts.",{"$f":"B1&\" - vertrouwelijk\"","v":"Bedrijfsnaam - vertrouwelijk"}]
["De tip staat in de cel rechts.","Gearceerde cellen worden voor u berekend. U hoeft ze niet in te vullen."]
["Voer de parameters in in de tabel die in de cel rechts begint. De volgende aanwijzing staat in cel A12.","PROJECTTYPE","BEHEREND VENNOOT","BEDRIJFSJURIST","ADVOCAAT VERDEDIGING","ADVOCAAT INTELLECTUEEL EIGENDOM","ADVOCAAT FAILLISSEMENTEN","PERSONEEL ADMINISTRATIE","TOTAAL"]
[null,"Fusering",{"v":0.1,"d":"10%"},{"v":0.4,"d":"40%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"$f":"SUM(Parameters[[#This Row],[BEHEREND VENNOOT]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
[null,"Overname",{"v":0.1,"d":"10%"},{"v":0.4,"d":"40%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0.4,"d":"40%"},{"$f":"SUM(Parameters[[#This Row],[BEHEREND VENNOOT]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
[null,"Verdediging van productaansprakelijkheid",{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.3,"d":"30%"},{"$f":"SUM(Parameters[[#This Row],[BEHEREND VENNOOT]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
[null,"Octrooiaanvraag",{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0,"d":"0%"},{"v":0.3,"d":"30%"},{"$f":"SUM(Parameters[[#This Row],[BEHEREND VENNOOT]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
[null,"Rechtszaak werknemer",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.4,"d":"40%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.3,"d":"30%"},{"$f":"SUM(Parameters[[#This Row],[BEHEREND VENNOOT]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
[null,"Faillissement",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.4,"d":"40%"},{"v":0.3,"d":"30%"},{"$f":"SUM(Parameters[[#This Row],[BEHEREND VENNOOT]:[PERSONEEL ADMINISTRATIE]])","v":{"v":1,"d":"100%"}}]
["Voer de samengestelde tarieven in in de cellen C12 tot en met H12 rechts. De volgende aanwijzing staat in cel A14.","Samengestelde tarieven",{"v":350,"d":"€ 350"},{"v":250,"d":"€ 250"},{"v":300,"d":"€ 300"},{"v":275,"d":"€ 275"},{"v":225,"d":"€ 225"},{"v":125,"d":"€ 125"}]
[]
["Een kolomdiagram met de gepland versus werkelijke kosten staat in de cel rechts, en een kolomdiagram met het aantal gepland versus werkelijk aantal uren in cel F14."]
[null,null,"BEHEREND VENNOOT","BEDRIJF","ADVOCAAT VERDEDIGING","INTELLECTUEEL EIGENDOM","FAILLISSEMENT","PERSONEEL ADMINISTRATIE"]
[null,"GEPLANDE KOSTEN",{"$f":"SUBTOTAL(109,Details[BEHEREND VENNOOT])","v":{"v":78750,"d":"€ 78,750.00"}},{"$f":"SUBTOTAL(109,Details[BEDRIJFSJURIST])","v":{"v":66250,"d":"€ 66,250.00"}},{"$f":"SUBTOTAL(109,Details[ADVOCAAT VERDEDIGING])","v":{"v":105000,"d":"€ 105,000.00"}},{"$f":"SUBTOTAL(109,Details[ADVOCAAT INTELLECTUEEL EIGENDOM])","v":{"v":35750,"d":"€ 35,750.00"}},{"$f":"SUBTOTAL(109,Details[ADVOCAAT FAILLISSEMENTEN])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Details[PERSONEEL ADMINISTRATIE])","v":{"v":66250,"d":"€ 66,250.00"}}]
[null,"WERKELIJKE KOSTEN",{"$f":"SUBTOTAL(109,Details[BEHEREND VENNOOT 2])","v":{"v":79275,"d":"€ 79,275.00"}},{"$f":"SUBTOTAL(109,Details[BEDRIJFSJURIST 2])","v":{"v":67375,"d":"€ 67,375.00"}},{"$f":"SUBTOTAL(109,Details[ADVOCAAT VERDEDIGING 2])","v":{"v":105600,"d":"€ 105,600.00"}},{"$f":"SUBTOTAL(109,Details[ADVOCAAT INTELLECTUEEL EIGENDOM 2])","v":{"v":34650,"d":"€ 34,650.00"}},{"$f":"SUBTOTAL(109,Details[ADVOCAAT FAILLISSEMENTEN 2])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Details[PERSONEEL ADMINISTRATIE 2])","v":{"v":67000,"d":"€ 67,000.00"}}]
[null,"GEPLAND AANTAL UREN",{"$f":"C16/$C$12","v":{"v":225,"d":"225.00"}},{"$f":"D16/$C$12","v":{"v":189.28571428571428,"d":"189.29"}},{"v":300,"d":"300.00"},{"v":102.14285714285714,"d":"102.14"},{"v":0,"d":"0.00"},{"v":189.28571428571428,"d":"189.29"}]
[null,"WERKELIJK AANTAL UREN",{"$f":"C17/$C$12","v":{"v":226.5,"d":"226.50"}},{"$f":"D17/$C$12","v":{"v":192.5,"d":"192.50"}},{"$f":"E17/$C$12","v":{"v":301.7142857142857,"d":"301.71"}},{"$f":"F17/$C$12","v":{"v":99,"d":"99.00"}},{"$f":"G17/$C$12","v":{"v":0,"d":"0.00"}},{"$f":"H17/$C$12","v":{"v":191.42857142857142,"d":"191.43"}}]

{"sheet":"PROJECTGEGEVENS","index":2,"n_rows":10,"n_cols":25,"rows_kept":10,"merged":[[1,24,8,28]]}
["Voer op dit werkblad de projectgegevens in. De bedrijfsnaam wordt automatisch bijgewerkt in de cel rechts. Nuttige instructies zijn te vinden in de cellen in deze kolom. Druk op de pijl-omlaag om aan de slag te gaan.",{"$f":"PROJECTPARAMETERS!B1","v":"Bedrijfsnaam"}]
["De titel van dit werkblad staat in de cel rechts en de tip staat in cel Y2.",{"$f":"PROJECTPARAMETERS!B2","v":"Projectplanning voor advocatenkantoren"},{"$nulls":22},"INFORMATIE:\nAls u een rij aan de tabel wilt toevoegen, selecteert u de laatste cel rechtsonder in de tabel (niet de rij met totalen) en drukt u op Tab. U kunt ook in de tabel 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."]
["De vertrouwelijkheidsboodschap staat in de cel rechts.",{"$f":"PROJECTPARAMETERS!B3","v":"Bedrijfsnaam - vertrouwelijk"}]
["Voer de gegevens in in de tabel Gegevens die in de cel rechts begint. De projecttype in de tabel Gegevens rechts worden automatisch bijgewerkt op basis van de tabel Parameters op het werkblad Projectparameters.","PROJECTNAAM","PROJECTTYPE","GESCHATTE BEGINDATUM","GESCHATTE EINDDATUM","WERKELIJKE BEGINDATUM","WERKELIJKE EINDDATUM","GESCHATTE WERKUREN","WERKELIJKE WERKUREN","GESCHATTE DUUR","WERKELIJKE DUUR","BEHEREND VENNOOT","BEDRIJFSJURIST","ADVOCAAT VERDEDIGING","ADVOCAAT INTELLECTUEEL EIGENDOM","ADVOCAAT FAILLISSEMENTEN","PERSONEEL ADMINISTRATIE","BEHEREND VENNOOT 2","BEDRIJFSJURIST 2","ADVOCAAT VERDEDIGING 2","ADVOCAAT INTELLECTUEEL EIGENDOM 2","ADVOCAAT FAILLISSEMENTEN 2","PERSONEEL ADMINISTRATIE 2"]
[null,"Project 1","Fusering",{"$f":"TODAY()","v":"2019-02-20"},{"$f":"TODAY()+60","v":"2019-04-21"},{"$f":"TODAY()+10","v":"2019-03-02"},{"$f":"TODAY()+65","v":"2019-04-26"},200,220,{"$f":"DAYS360(Details[[#This Row],[GESCHATTE BEGINDATUM]],Details[[#This Row],[GESCHATTE EINDDATUM]],FALSE)","v":61},{"$f":"DAYS360(Details[[#This Row],[WERKELIJKE BEGINDATUM]],Details[[#This Row],[WERKELIJKE EINDDATUM]],FALSE)","v":54},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":7000,"d":"€ 7,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":20000,"d":"€ 20,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":12500,"d":"€ 12,500"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":7700,"d":"€ 7,700"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":22000,"d":"€ 22,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":13750,"d":"€ 13,750"}}]
[null,"Project 2","Overname",{"$f":"TODAY()+30","v":"2019-03-22"},{"$f":"TODAY()+100","v":"2019-05-31"},{"$f":"TODAY()+40","v":"2019-04-01"},{"$f":"TODAY()+110","v":"2019-06-10"},400,390,{"$f":"DAYS360(Details[[#This Row],[GESCHATTE BEGINDATUM]],Details[[#This Row],[GESCHATTE EINDDATUM]],FALSE)","v":69},{"$f":"DAYS360(Details[[#This Row],[WERKELIJKE BEGINDATUM]],Details[[#This Row],[WERKELIJKE EINDDATUM]],FALSE)","v":69},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":14000,"d":"€ 14,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":40000,"d":"€ 40,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":11000,"d":"€ 11,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":20000,"d":"€ 20,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":13650,"d":"€ 13,650"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":39000,"d":"€ 39,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":10725,"d":"€ 10,725"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":19500,"d":"€ 19,500"}}]
[null,"Project 3","Verdediging van productaansprakelijkheid",{"$f":"TODAY()+150","v":"2019-07-20"},{"$f":"TODAY()+150","v":"2019-07-20"},{"$f":"TODAY()+150","v":"2019-07-20"},{"$f":"TODAY()+170","v":"2019-08-09"},500,500,{"$f":"DAYS360(Details[[#This Row],[GESCHATTE BEGINDATUM]],Details[[#This Row],[GESCHATTE EINDDATUM]],FALSE)","v":0},{"$f":"DAYS360(Details[[#This Row],[WERKELIJKE BEGINDATUM]],Details[[#This Row],[WERKELIJKE EINDDATUM]],FALSE)","v":19},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":35000,"d":"€ 35,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":75000,"d":"€ 75,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":18750,"d":"€ 18,750"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":35000,"d":"€ 35,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":75000,"d":"€ 75,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":18750,"d":"€ 18,750"}}]
[null,"Project 4","Octrooiaanvraag",{"$f":"TODAY()+200","v":"2019-09-08"},{"$f":"TODAY()+230","v":"2019-10-08"},{"$f":"TODAY()+230","v":"2019-10-08"},{"$f":"TODAY()+230","v":"2019-10-08"},150,145,{"$f":"DAYS360(Details[[#This Row],[GESCHATTE BEGINDATUM]],Details[[#This Row],[GESCHATTE EINDDATUM]],FALSE)","v":30},{"$f":"DAYS360(Details[[#This Row],[WERKELIJKE BEGINDATUM]],Details[[#This Row],[WERKELIJKE EINDDATUM]],FALSE)","v":0},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":5250,"d":"€ 5,250"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":24750,"d":"€ 24,750"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":5625,"d":"€ 5,625"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":5075,"d":"€ 5,075"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":23925,"d":"€ 23,925"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":5437.5,"d":"€ 5,438"}}]
[null,"Project 5","Rechtszaak werknemer",{"$f":"TODAY()+220","v":"2019-09-28"},{"$f":"TODAY()+250","v":"2019-10-28"},{"$f":"TODAY()+230","v":"2019-10-08"},{"$f":"TODAY()+259","v":"2019-11-06"},250,255,{"$f":"DAYS360(Details[[#This Row],[GESCHATTE BEGINDATUM]],Details[[#This Row],[GESCHATTE EINDDATUM]],FALSE)","v":30},{"$f":"DAYS360(Details[[#This Row],[WERKELIJKE BEGINDATUM]],Details[[#This Row],[WERKELIJKE EINDDATUM]],FALSE)","v":28},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":17500,"d":"€ 17,500"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":6250,"d":"€ 6,250"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":30000,"d":"€ 30,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Details[[#This Row],[GESCHATTE WERKUREN]]","v":{"v":9375,"d":"€ 9,375"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEHEREND VENNOOT]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":17850,"d":"€ 17,850"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[BEDRIJFSJURIST]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":6375,"d":"€ 6,375"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT VERDEDIGING]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":30600,"d":"€ 30,600"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT INTELLECTUEEL EIGENDOM]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADVOCAAT FAILLISSEMENTEN]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":0,"d":"€ 0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECTTYPE]],Parameters[PROJECTTYPE],0),MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*INDEX(PROJECTPARAMETERS!$B$12:$H$12,1,MATCH(Details[[#Headers],[PERSONEEL ADMINISTRATIE]],Parameters[#Headers],0))*Details[[#This Row],[WERKELIJKE WERKUREN]]","v":{"v":9562.5,"d":"€ 9,563"}}]
[null,"TOTAAL",{"$nulls":5},{"$f":"SUBTOTAL(109,Details[GESCHATTE WERKUREN])","v":1500},{"$f":"SUBTOTAL(109,Details[WERKELIJKE WERKUREN])","v":1510},{"$f":"SUBTOTAL(109,Details[GESCHATTE DUUR])","v":190},{"$f":"SUBTOTAL(109,Details[WERKELIJKE DUUR])","v":170}]

{"sheet":"PROJECTTOTALEN","index":3,"n_rows":11,"n_cols":16,"rows_kept":11,"merged":[[3,2,3,7],[3,8,3,13],[3,15,14,19]]}
["Op dit werkblad kunt u de projecttotalen aflezen. De bedrijfsnaam wordt automatisch bijgewerkt in de cel rechts. Nuttige instructies zijn te vinden in de cellen in deze kolom. Druk op de pijl-omlaag om aan de slag te gaan.",{"$f":"PROJECTPARAMETERS!B1","v":"Bedrijfsnaam"}]
["De titel van dit werkblad staat in de cel rechts.",{"$f":"PROJECTPARAMETERS!B2","v":"Projectplanning voor advocatenkantoren"}]
["De vertrouwelijkheidsboodschap staat in de cel rechts.",{"$f":"PROJECTPARAMETERS!B3","v":"Bedrijfsnaam - vertrouwelijk"}]
["Het label Geschat staat in cel C4, het label Werkelijk in cel I4 en de tip in cel P4.",null,"GESCHAT",{"$nulls":5},"WERKELIJK",{"$nulls":6},"INFORMATIE: \nDeze draaitabel wordt niet automatisch bijgewerkt.  Als u deze draaitabel wilt vernieuwen, klikt u op een van de cellen binnen de draaitabel en klikt u op het tabblad Hulpmiddelen voor draaitabellen - Analyseren op Vernieuwen.  Of druk in de draaitabel op Shift + F10 en klik op Vernieuwen."]
["De draaitabel die in de cel rechts begint, wordt automatisch bijgewerkt.","PROJECTNAAM","BEHEREND VENNOOT ","BEDRIJF ","ADVOCAAT VERDEDIGING ","INTELLECTUEEL EIGENDOM ","FAILLISSEMENT ","PERSONEEL ADMINISTRATIE ","BEHEREND VENNOOT  ","BEDRIJF","ADVOCAAT VERDEDIGING  ","FAILLISSEMENT","INTELLECTUEEL EIGENDOM","PERSONEEL ADMINISTRATIE  "]
[null,"Project 1",{"v":7000,"d":"€ 7,000.00"},{"v":20000,"d":"€ 20,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":12500,"d":"€ 12,500.00"},{"v":7700,"d":"€ 7,700.00"},{"v":22000,"d":"€ 22,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":13750,"d":"€ 13,750.00"}]
[null,"Project 2",{"v":14000,"d":"€ 14,000.00"},{"v":40000,"d":"€ 40,000.00"},{"v":0,"d":"€ 0.00"},{"v":11000,"d":"€ 11,000.00"},{"v":0,"d":"€ 0.00"},{"v":20000,"d":"€ 20,000.00"},{"v":13650,"d":"€ 13,650.00"},{"v":39000,"d":"€ 39,000.00"},{"v":0,"d":"€ 0.00"},{"v":10725,"d":"€ 10,725.00"},{"v":0,"d":"€ 0.00"},{"v":19500,"d":"€ 19,500.00"}]
[null,"Project 3",{"v":35000,"d":"€ 35,000.00"},{"v":0,"d":"€ 0.00"},{"v":75000,"d":"€ 75,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":18750,"d":"€ 18,750.00"},{"v":35000,"d":"€ 35,000.00"},{"v":0,"d":"€ 0.00"},{"v":75000,"d":"€ 75,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":18750,"d":"€ 18,750.00"}]
[null,"Project 4",{"v":5250,"d":"€ 5,250.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":24750,"d":"€ 24,750.00"},{"v":0,"d":"€ 0.00"},{"v":5625,"d":"€ 5,625.00"},{"v":5075,"d":"€ 5,075.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":23925,"d":"€ 23,925.00"},{"v":0,"d":"€ 0.00"},{"v":5437.5,"d":"€ 5,437.50"}]
[null,"Project 5",{"v":17500,"d":"€ 17,500.00"},{"v":6250,"d":"€ 6,250.00"},{"v":30000,"d":"€ 30,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":9375,"d":"€ 9,375.00"},{"v":17850,"d":"€ 17,850.00"},{"v":6375,"d":"€ 6,375.00"},{"v":30600,"d":"€ 30,600.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":9562.5,"d":"€ 9,562.50"}]
[null,"Eindtotaal",{"v":78750,"d":"€ 78,750.00"},{"v":66250,"d":"€ 66,250.00"},{"v":105000,"d":"€ 105,000.00"},{"v":35750,"d":"€ 35,750.00"},{"v":0,"d":"€ 0.00"},{"v":66250,"d":"€ 66,250.00"},{"v":79275,"d":"€ 79,275.00"},{"v":67375,"d":"€ 67,375.00"},{"v":105600,"d":"€ 105,600.00"},{"v":34650,"d":"€ 34,650.00"},{"v":0,"d":"€ 0.00"},{"v":67000,"d":"€ 67,000.00"}]