{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["test"],"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":"test","index":0,"n_rows":20,"n_cols":31,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"split",24]
[]
["naam","product","verworven","bedrag","trouw","kwartaal","deel",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,"maxi",3.125,{"$f":"SUMPRODUCT(($A$18:$A$20=$B$4)*(B$18:B$20))","v":75},{"$f":"SUMPRODUCT(($A$18:$A$20=$B$4)*(C$18:C$20))","v":20},10,{"$f":"$D4/$E$1","v":3.125},{"$f":"H3*$G4","v":3.125},{"$f":"I3*$G4","v":6.25},9.375,12.5,15.625,18.75,21.875,25,28.125,31.25,34.375,37.5,40.625,43.75,46.875,50,53.125,56.25,59.375,62.5,65.625,68.75,71.875,75]
[]
[]
[]
[null,null,null,null,null,"doel 1:","- Indien in B4 (keuzemenu) classic wordt geselecteerd moet excel automatisch in cel D4 automatisch de waarde uit cel b18 worden ingevuld"]
[null,null,null,null,null,null,"- Indien in B4 (keuzemenu) comfort wordt geselecteerd moet excel automatisch in cel D4 automatisch de waarde uit cel B19 worden ingevuld"]
[null,null,null,null,null,null,"- …"]
[]
[]
[null,null,null,null,null,"doel 2:","- Indien cel H4 'groen' wordt ingekleurd moet het bedrag in van cel H4 worden ingevuld in C4"]
[null,null,null,null,null,null,"- Indien cel G4 'groen' wordt ingekleurd moet het bedrag van cel I4 worden ingevuld in C4"]
[null,null,null,null,null,null,"- …"]
[]
["product","bedrag","trouw","kwartaal"]
["classic",20,5,5]
["comfort",50,12,5]
["maxi",75,20,10]