{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Budgetoverzicht YTD","Maandelijkse onkosten","1000-Kantoor","2000-Winkel","3000-Personeel","4000-Uitrusting","5000-Overige"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Budgetoverzicht YTD","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,0,1,5]]}
[]
["2006 Werkelijk versus Budget YTD"]
[]
["Accountnummer","Account","YTD Werkelijk","YTD Budget","Restbudget €","Restbudget %"]
[1000,"Kantoor",{"$f":"'Maandelijkse onkosten'!O5","v":0},{"v":50000,"d":"€ 50,000.00"},{"$f":"SUM(D5-C5)","v":{"v":50000,"d":"€ 50,000.00"}},{"$f":"SUM(Tabel1[Restbudget €]/Tabel1[YTD Budget])","v":{"v":1,"d":"100.00%"}}]
[2000,"Winkel",{"$f":"'Maandelijkse onkosten'!O6","v":0},{"v":75000,"d":"€ 75,000.00"},{"$f":"SUM(D6-C6)","v":{"v":75000,"d":"€ 75,000.00"}},{"$f":"SUM(Tabel1[Restbudget €]/Tabel1[YTD Budget])","v":{"v":1,"d":"100.00%"}}]
[3000,"Personeel",{"$f":"'Maandelijkse onkosten'!O7","v":0},{"v":100000,"d":"€ 100,000.00"},{"$f":"SUM(D7-C7)","v":{"v":100000,"d":"€ 100,000.00"}},{"$f":"SUM(Tabel1[Restbudget €]/Tabel1[YTD Budget])","v":{"v":1,"d":"100.00%"}}]
[4000,"Apparatuur",{"$f":"'Maandelijkse onkosten'!O8","v":0},{"v":25000,"d":"€ 25,000.00"},{"$f":"SUM(D8-C8)","v":{"v":25000,"d":"€ 25,000.00"}},{"$f":"SUM(Tabel1[Restbudget €]/Tabel1[YTD Budget])","v":{"v":1,"d":"100.00%"}}]
[5000,"Overige",{"$f":"'Maandelijkse onkosten'!O9","v":0},{"v":50000,"d":"€ 50,000.00"},{"$f":"SUM(D9-C9)","v":{"v":50000,"d":"€ 50,000.00"}},{"$f":"SUM(Tabel1[Restbudget €]/Tabel1[YTD Budget])","v":{"v":1,"d":"100.00%"}}]
["Totaal",null,{"$f":"SUBTOTAL(109,Tabel1[YTD Werkelijk])","v":0},{"$f":"SUBTOTAL(109,Tabel1[YTD Budget])","v":{"v":300000,"d":"€ 300,000.00"}},{"$f":"SUBTOTAL(109,Tabel1[Restbudget €])","v":{"v":300000,"d":"€ 300,000.00"}},{"$f":"Tabel1[[#Totals],[Restbudget €]]/Tabel1[[#Totals],[YTD Budget]]","v":{"v":1,"d":"100.00%"}}]

{"sheet":"Maandelijkse onkosten","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"merged":[[1,0,1,14]]}
[]
["2006 Maandelijkse onkosten"]
[]
["Accountnummer","Account","Jan-06","Feb-06","Mrt-06","Apr-06","Mei-06","Jun-06","Jul-06","Aug-06","Sep-06","Okt-06","Nov-06","Dec-06","2006 Totaal"]
[1000,"Kantoor",{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUMIF('1000-Kantoor'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-yy\")),'1000-Kantoor'!$E:$E)","v":0},{"$f":"SUM(Tabel2[Jan-06]+Tabel2[Feb-06]+Tabel2[Mrt-06]+Tabel2[Apr-06]+Tabel2[Mei-06]+Tabel2[Jun-06]+Tabel2[Jul-06]+Tabel2[Aug-06]+Tabel2[Sep-06]+Tabel2[Okt-06]+Tabel2[Nov-06]+Tabel2[Dec-06])","v":0}]
[2000,"Winkel",{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUMIF('2000-Winkel'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-yy\")),'2000-Winkel'!$E:$E)","v":0},{"$f":"SUM(Tabel2[Jan-06]+Tabel2[Feb-06]+Tabel2[Mrt-06]+Tabel2[Apr-06]+Tabel2[Mei-06]+Tabel2[Jun-06]+Tabel2[Jul-06]+Tabel2[Aug-06]+Tabel2[Sep-06]+Tabel2[Okt-06]+Tabel2[Nov-06]+Tabel2[Dec-06])","v":0}]
[3000,"Personeel",{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Personeel'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-yy\")),'3000-Personeel'!$E:$E)","v":0},{"$f":"SUM(Tabel2[Jan-06]+Tabel2[Feb-06]+Tabel2[Mrt-06]+Tabel2[Apr-06]+Tabel2[Mei-06]+Tabel2[Jun-06]+Tabel2[Jul-06]+Tabel2[Aug-06]+Tabel2[Sep-06]+Tabel2[Okt-06]+Tabel2[Nov-06]+Tabel2[Dec-06])","v":0}]
[4000,"Apparatuur",{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUMIF('4000-Uitrusting'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-yy\")),'4000-Uitrusting'!$E:$E)","v":0},{"$f":"SUM(Tabel2[Jan-06]+Tabel2[Feb-06]+Tabel2[Mrt-06]+Tabel2[Apr-06]+Tabel2[Mei-06]+Tabel2[Jun-06]+Tabel2[Jul-06]+Tabel2[Aug-06]+Tabel2[Sep-06]+Tabel2[Okt-06]+Tabel2[Nov-06]+Tabel2[Dec-06])","v":0}]
[5000,"Overige",{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUMIF('5000-Overige'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-yy\")),'5000-Overige'!$E:$E)","v":0},{"$f":"SUM(Tabel2[Jan-06]+Tabel2[Feb-06]+Tabel2[Mrt-06]+Tabel2[Apr-06]+Tabel2[Mei-06]+Tabel2[Jun-06]+Tabel2[Jul-06]+Tabel2[Aug-06]+Tabel2[Sep-06]+Tabel2[Okt-06]+Tabel2[Nov-06]+Tabel2[Dec-06])","v":0}]
["Totaal",null,{"$f":"SUBTOTAL(109,Tabel2[Jan-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Feb-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Mrt-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Apr-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Mei-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Jun-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Jul-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Aug-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Sep-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Okt-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Nov-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[Dec-06])","v":0},{"$f":"SUBTOTAL(109,Tabel2[2006 Totaal])","v":0}]

{"sheet":"1000-Kantoor","index":2,"n_rows":6,"n_cols":10,"rows_kept":6}
["Grootboek - uitgaven","Factuurdatum","Factuurnr.","Verzocht door","Bedrag op cheque","Naam van begunstigde","Chequegebruik","Methode van verdeling","Bestandsdatum","Samengesteld sleutelveld"]
[1000,{"v":38732,"d":"3873200.00%"},1,"David Daniels",{"v":100,"d":"€ 100.00"},"Consolidated Messenger ","Blanco cd's","Krediet",{"v":38737,"d":"3873700.00%"},{"$f":"TEXT(B2,\"mmm-yy\")","v":"Jan-06"}]
[1000,"2006-02-07",5,"David Daniels",{"v":50,"d":"€ 50.00"},"Consolidated Messenger ","Printerinkt","Krediet",{"v":38758,"d":"3875800.00%"},{"$f":"TEXT(B3,\"mmm-yy\")","v":"Feb-06"}]
[1000,"2006-02-15",10,"David Daniels",{"v":275,"d":"€ 275.00"},"Acme","Kantoor algemeen","Krediet",{"v":38758,"d":"3875800.00%"},{"$f":"TEXT(B4,\"mmm-yy\")","v":"Feb-06"}]
[1000,{"$nulls":8},{"$f":"TEXT(B5,\"mmm-yy\")","v":"Jan-00"}]
["Totaal",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabel3[Bedrag op cheque])","v":{"v":425,"d":"€ 425.00"}}]

{"sheet":"2000-Winkel","index":3,"n_rows":5,"n_cols":10,"rows_kept":5}
["Grootboek - uitgaven","Factuurdatum","Factuurnr.","Verzocht door","Bedrag op cheque","Naam van begunstigde","Chequegebruik","Methode van verdeling","Bestandsdatum","Samengesteld sleutelveld"]
[2000,{"v":38734,"d":"3873400.00%"},2,"Marc Faeber",{"v":550,"d":"€ 550.00"},"Fabrikam, Inc. ","Winkelruit vervangen","Krediet",{"v":38737,"d":"3873700.00%"},{"$f":"TEXT(B2,\"mmm-yy\")","v":"Jan-06"}]
[2000,"2006-01-19",3,"Marc Faeber",{"v":355.27,"d":"€ 355.27"},"A. Datum Corporation ","Nieuwe kassa","Krediet",{"v":38737,"d":"3873700.00%"},{"$f":"TEXT(B3,\"mmm-yy\")","v":"Jan-06"}]
[2000,{"$nulls":8},{"$f":"TEXT(B4,\"mmm-yy\")","v":"Jan-00"}]
["Totaal",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabel4[Bedrag op cheque])","v":{"v":905.27,"d":"€ 905.27"}}]

{"sheet":"3000-Personeel","index":4,"n_rows":5,"n_cols":10,"rows_kept":5}
["Grootboek - uitgaven","Factuurdatum","Factuurnr.","Verzocht door","Bedrag op cheque","Naam van begunstigde","Chequegebruik","Methode van verdeling","Bestandsdatum","Samengesteld sleutelveld"]
[3000,{"v":38758,"d":"3875800.00%"},6,"Robert O'Hara",{"v":2500,"d":"€ 2,500.00"},"Grafisch ontwerpinstituut ","ingehuurd ontwerper","Controle",{"v":38768,"d":"3876800.00%"},{"$f":"TEXT(B2,\"mmm-yy\")","v":"Feb-06"}]
[3000,"2006-02-15",11,"Sandeep Kaliyath",{"v":15000,"d":"€ 15,000.00"},"Noordenwind","ingehuurde schrijver","Controle",{"v":38768,"d":"3876800.00%"},{"$f":"TEXT(B3,\"mmm-yy\")","v":"Feb-06"}]
[3000,{"$nulls":8},{"$f":"TEXT(B4,\"mmm-yy\")","v":"Jan-00"}]
["Totaal",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabel5[Bedrag op cheque])","v":{"v":17500,"d":"€ 17,500.00"}}]

{"sheet":"4000-Uitrusting","index":5,"n_rows":4,"n_cols":10,"rows_kept":4}
["Grootboek - uitgaven","Factuurdatum","Factuurnr.","Verzocht door","Bedrag op cheque","Naam van begunstigde","Chequegebruik","Methode van verdeling","Bestandsdatum","Samengesteld sleutelveld"]
[4000,{"v":38742,"d":"3874200.00%"},5,"Robert Walters",{"v":1854,"d":"€ 1,854.00"},"Trey Research ","Nieuwe laptop","Krediet",{"v":38742,"d":"3874200.00%"},{"$f":"TEXT(B2,\"mmm-yy\")","v":"Jan-06"}]
[4000,{"$nulls":8},{"$f":"TEXT(B3,\"mmm-yy\")","v":"Jan-00"}]
["Totaal",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabel6[Bedrag op cheque])","v":{"v":1854,"d":"€ 1,854.00"}}]

{"sheet":"5000-Overige","index":6,"n_rows":4,"n_cols":10,"rows_kept":4}
["Grootboek - uitgaven","Factuurdatum","Factuurnr.","Verzocht door","Bedrag op cheque","Naam van begunstigde","Chequegebruik","Methode van verdeling","Bestandsdatum","Samengesteld sleutelveld"]
[5000,{"v":38740,"d":"3874000.00%"},4,"Bob Gage",{"v":35.6,"d":"€ 35.60"},"Bob Gage","Taxikosten","Controle",{"v":38740,"d":"3874000.00%"},{"$f":"TEXT(B2,\"mmm-yy\")","v":"Jan-06"}]
[5000,{"$nulls":8},{"$f":"TEXT(B3,\"mmm-yy\")","v":"Jan-00"}]
["Totaal",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabel7[Bedrag op cheque])","v":{"v":35.6,"d":"€ 35.60"}}]