{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["DATA","Blad2","Blad3","Blad4","Blad5","Blad6","Blad7","Blad8","Blad9"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DATA","index":0,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Klik in de derde kolom om de MS Monthviewer te tonen (Vanaf rij 19)."]
[]
[null,"naam","datum","resultaat"]
[null,"Now()","NU","2014-09-27T21:00:35"]
[null,"Date()","NU","2014-09-27"]
[null,"Time()","NU","21:00:35"]
[null,"DatePart(\"d\", [C19])","8-9-2014",19]
[null,"DatePart(\"m\", [C20])","2014-10-27",10]
[null,"DatePart(\"yyyy\", [C21])","2014-04-08",2014]
[null,"Day([C22])","2014-09-27",27]
[null,"Month([C23])","2014-09-27",9]
[null,"Year([C24])","2014-09-16",2014]
[null,"DateSerial(1957, 1, 4)","2014-09-01","1957-01-04"]
[null,"Weekday([C26], vbMonday)","2014-08-25",1]
[null,"WeekdayName(Weekday([C27], vbMonday))","2014-09-27","zaterdag"]
[null,"MonthName(Month([C28]))","2014-09-18","september"]
[null,"DateValue([C29])","2012-02-27","2012-02-27"]
[null,"TimeValue([C30])","2014-09-30","00:00:00"]
[null,"Timer","2014-11-12",75635.7265625]
[null,"DateAdd(\"yyyy\", 5, [C32])","2014-09-10","2019-09-10"]
[null," DateAdd(\"q\", 1, [C33])","2014-03-18","2014-06-18"]
[null,"DateAdd(\"m\", 6, [C34])","2015-02-18","2015-08-18"]
[null,"DateAdd(\"n\", 30, [C35])","2015-02-19","2015-02-19T00:30:00"]
[null,"DateDiff(\"yyyy\", [C36], Now)","1957-10-24",57]
[null,"DateDiff(\"yyyy\", [C37], Now) - IIf(Date >= DateSerial(Year(Now), Month([C37]), Day([C37])), 0, 1)","1957-09-26",57]
[null,"Int(DateDiff(\"m\", [C38], Now)) - IIf(Date >= DateSerial(Year(Now), Month([C38]), Day([C38])), 0, 1)","2013-08-26",13]
[null,"DatePart(\"ww\", [C39], vbMonday, vbFirstFourDays)","2010-01-04",1]
[null,"DatePart(\"ww\", [C40] - Weekday([C40], vbMonday) + 4, vbMonday, vbFirstFourDays)","2010-01-04",1]
[null,"Format([C41], \"ddd dd - mmm - yyyy\")","2014-09-27","za 27 - sep - 2014"]
[null,"IIf(IsDate([C41]), \"Dit is een datum\", \"Dit is geen datum\")","test","Dit is geen datum"]

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

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

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

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

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

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

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

{"sheet":"Blad9","index":8,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Facturen overzicht dd.: 03-09-2014 21:19"]
["&nbsp;naam&nbsp;","&nbsp;factuurnr.&nbsp;","&nbsp;factuurdatum&nbsp;","&nbsp;betaald&nbsp;"]
["&nbsp;Niet betaald, te laat:&nbsp;"]
["&nbsp;Boer. R. de&nbsp;","&nbsp;2014-12-249&nbsp;","&nbsp;€ 650,00&nbsp;","&nbsp;17-04-2014&nbsp;","te laat"]
["&nbsp;Willemse, K.&nbsp;","&nbsp;2014-12-258&nbsp;","&nbsp;€ 625,00&nbsp;","&nbsp;21-04-2014&nbsp;","te laat"]
["&nbsp;Geels. O.&nbsp;","&nbsp;2014-12-267&nbsp;","&nbsp;€ 600,00&nbsp;","&nbsp;25-04-2014&nbsp;","te laat"]
["&nbsp;Mulder, S&nbsp;","&nbsp;2014-12-321&nbsp;","&nbsp;€ 450,00&nbsp;","&nbsp;19-05-2014&nbsp;","te laat"]
["&nbsp;Dorsten, I. van&nbsp;","&nbsp;2014-12-330&nbsp;","&nbsp;€ 425,00&nbsp;","&nbsp;23-05-2014&nbsp;","te laat"]
["&nbsp;Blauw, P.&nbsp;","&nbsp;2014-12-339&nbsp;","&nbsp;€ 400,00&nbsp;","&nbsp;27-05-2014&nbsp;","te laat"]
["Niet betaald, nog niet te laat:"]
["&nbsp;Koopman, L.&nbsp;","&nbsp;2014-12-357&nbsp;","&nbsp;€ 350,00&nbsp;","&nbsp;04-06-2014&nbsp;","nee"]
["&nbsp;Klerk, I.L.&nbsp;","&nbsp;2014-12-366&nbsp;","&nbsp;€ 325,00&nbsp;","&nbsp;08-06-2014&nbsp;","nee"]
["&nbsp;Haanen, L.&nbsp;","&nbsp;2014-12-384&nbsp;","&nbsp;€ 275,00&nbsp;","&nbsp;16-06-2014&nbsp;","nee"]
["&nbsp;Bouwer, J.&nbsp;","&nbsp;2014-12-411&nbsp;","&nbsp;€ 200,00&nbsp;","&nbsp;28-06-2014&nbsp;","nee"]
["&nbsp;Broeresen. T&nbsp;","&nbsp;2014-12-420&nbsp;","&nbsp;€ 175,00&nbsp;","&nbsp;02-07-2014&nbsp;","nee"]
["&nbsp;Gerards. K.&nbsp;","&nbsp;2014-12-429&nbsp;","&nbsp;€ 150,00&nbsp;","&nbsp;06-07-2014&nbsp;","nee"]
["Betaald en afgerond:"]
["&nbsp;Pietersen, A.&nbsp;","&nbsp;2014-12-213&nbsp;","&nbsp;€ 750,00&nbsp;","&nbsp;01-04-2014&nbsp;","ja"]
["&nbsp;Kruiningen, W.&nbsp;","&nbsp;2014-12-222&nbsp;","&nbsp;€ 725,00&nbsp;","&nbsp;05-04-2014&nbsp;","ja"]
["&nbsp;Jong, D. de &nbsp;","&nbsp;2014-12-231&nbsp;","&nbsp;€ 700,00&nbsp;","&nbsp;09-04-2014&nbsp;","ja"]
["&nbsp;Groen, E.&nbsp;","&nbsp;2014-12-240&nbsp;","&nbsp;€ 675,00&nbsp;","&nbsp;13-04-2014&nbsp;","ja"]
["&nbsp;Oort, K. van&nbsp;","&nbsp;2014-12-276&nbsp;","&nbsp;€ 575,00&nbsp;","&nbsp;29-04-2014&nbsp;","ja"]
["&nbsp;Wester, F.&nbsp;","&nbsp;2014-12-285&nbsp;","&nbsp;€ 550,00&nbsp;","&nbsp;03-05-2014&nbsp;","ja"]
["&nbsp;Wijk, K. van&nbsp;","&nbsp;2014-12-294&nbsp;","&nbsp;€ 525,00&nbsp;","&nbsp;07-05-2014&nbsp;","ja"]
["&nbsp;Droog, K.&nbsp;","&nbsp;2014-12-303&nbsp;","&nbsp;€ 500,00&nbsp;","&nbsp;11-05-2014&nbsp;","ja"]
["&nbsp;Huiting, I.&nbsp;","&nbsp;2014-12-312&nbsp;","&nbsp;€ 475,00&nbsp;","&nbsp;15-05-2014&nbsp;","ja"]
["&nbsp;Peters, K.&nbsp;","&nbsp;2014-12-348&nbsp;","&nbsp;€ 375,00&nbsp;","&nbsp;31-05-2014&nbsp;","ja"]
["&nbsp;Bos, P.&nbsp;","&nbsp;2014-12-375&nbsp;","&nbsp;€ 300,00&nbsp;","&nbsp;12-06-2014&nbsp;","ja"]
["&nbsp;Wagenaar - Witteman, AKT van&nbsp;","&nbsp;2014-12-393&nbsp;","&nbsp;€ 250,00&nbsp;","&nbsp;20-06-2014&nbsp;","ja"]
["&nbsp;Smit, F&nbsp;","&nbsp;2014-12-402&nbsp;","&nbsp;€ 225,00&nbsp;","&nbsp;24-06-2014&nbsp;","ja"]