{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Blad1","index":0,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ecxel 2013",null,null,null,null,null,null,null,null,null,"Week","gemid.",null,null,"datum van  cel (b10) gebruiken",50,"cel (q2) handmatig invullen"]
[null,null,null,null,null,null,null,null,null,null,null,"week1",116.8]
[null,null,null,100,null,"D4 tot D8 handmatig ingegeven",null,null,null,null,null,"week2",120.8,null,null,"dag 1",50]
[null,null,null,103,null,null,null,null,null,null,null,"week3",110.8,null,null,"dag 2","bedrag uit q2, op andere datum"]
[null,null,null,101,null,null,null,null,null,null,null,null,null,null,null,"dag 3"]
[null,null,null,150,null,null,null,null,null,null,null,null,null,null,null,"dag 4"]
[null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,"dag 5"]
[]
[null,"2019-01-14",{"$f":"WEEKNUM(B10)","v":3},{"$f":"AVERAGE(D4:D8)","v":110.8}]
[null,null,null,null,null,null,null,null,null,"Dit werkt perfect en moet zo blijven"]
[null,"In het gele vak een datum invullen"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"datum van cel (b10) gebruiken",75,"cel (q14) is handmatig in te vullen"]
[]
[null,"Een aanvulling in hetzelfde werkblad (blad1)",null,null,null,null,null,null,null,null,null,null,null,null,null,"dag 1",75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dag 2","bedrag uit q14, op andere datum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dag 3"]
[null,"Ik heb een simpele macro gemaakt om na dag 5 de inhoud van de cellen q4:q8 en de cellen q16:q20 leeg te maken.",null,null,null,null,null,null,null,null,null,null,null,null,null,"dag 4"]
[null,"Hopelijk zal dat geen invloed hebben op deze nieuwe programma code.",null,null,null,null,null,null,null,null,null,null,null,null,null,"dag 5"]
[]
[null,"De getallen in D4:D8 hebben niets te maken met de getallen uit de kolom Q, maar staan wel op één blad"]
[null,"In dit voorbeeld zijn er twee groepen op basis van  Q2 en Q14 , in het eindprogramma zijn er een 7 -tal, die ik waarschijnlijk zelf zal kunnen uitbreiden."]