{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["TUINBUDGET","LIJST"],"not_rendered":{"charts":2,"images":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"TUINBUDGET","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[0,1,0,6],[0,8,3,8],[0,9,3,9],[1,3,6,6],[4,8,6,9]]}
[null,"TUINBUDGET",{"$nulls":6},"Slicer om tuinbudget op type te filteren staat in deze cel.","Slicer om tuinbudget op planten te filteren staat in deze cel."]
[null,"BEGROOT BEDRAG","Cirkeldiagram met begroot bedrag versus totale kosten staat in deze cel. Grafiek met uitgaven voor planten staat in de cel rechts.","Kolomdiagram met uitgaven voor planten staat in deze cel. Slicers om het tuinbudget op type en planten te filteren staan in cel I1 en J1. Informatie staat in cel I5 rechts."]
[null,{"v":290,"d":"€ 290.00"}]
[null,"TOTALE KOSTEN",{"$f":"BudgetedAmount","v":{"v":290,"d":"€ 290.00"}}]
[null,{"$f":"SUM(GardenBudget[TOTAAL])","v":{"v":231.94,"d":"€ 231.94"}},{"$f":"TotalCosts","v":{"v":231.94,"d":"€ 231.94"}},{"$nulls":5},"INFO: als u een nieuwe rij aan de gegevenstabel wilt toevoegen, selecteert u de cel rechtsonder in de tabel, vlak boven de rij Totaal, en drukt u op de Tab-toets."]
[null,"VERSCHIL"]
[null,{"$f":"BudgetedAmount-TotalCosts","v":{"v":58.06,"d":"€ 58.06"}}]
[null,"TYPE","PLANTEN","BESCHRIJVING","AANTAL","KOSTEN","TOTAAL"]
[null,"PLANTEN","Rhododendron","Altijdgroene bloemplant",2,{"v":35,"d":"€ 35.00"},{"$f":"GardenBudget[[#This Row],[AANTAL]]*GardenBudget[[#This Row],[KOSTEN]]","v":{"v":70,"d":"€ 70.00"}}]
[null,"BLOEMEN","Petunia","Eenjarig, purper en wit",6,{"v":1.99,"d":"€ 1.99"},{"$f":"GardenBudget[[#This Row],[AANTAL]]*GardenBudget[[#This Row],[KOSTEN]]","v":{"v":11.94,"d":"€ 11.94"}}]
[null,"BOMEN","Japanse esdoorn","Loofboom",1,{"v":150,"d":"€ 150.00"},{"$f":"GardenBudget[[#This Row],[AANTAL]]*GardenBudget[[#This Row],[KOSTEN]]","v":{"v":150,"d":"€ 150.00"}}]
[{"$nulls":6},{"$f":"GardenBudget[[#This Row],[AANTAL]]*GardenBudget[[#This Row],[KOSTEN]]","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":6},{"$f":"GardenBudget[[#This Row],[AANTAL]]*GardenBudget[[#This Row],[KOSTEN]]","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":6},{"$f":"GardenBudget[[#This Row],[AANTAL]]*GardenBudget[[#This Row],[KOSTEN]]","v":{"v":0,"d":"€ 0.00"}}]
[null,"TOTAAL AANTAL PLANTEN",{"$nulls":4},{"$f":"SUBTOTAL(109,GardenBudget[TOTAAL])","v":{"v":231.94,"d":"€ 231.94"}}]

{"sheet":"LIJST","index":1,"n_rows":13,"n_cols":2,"rows_kept":13}
[null,"TUINGEDEELTEN"]
[null,"TYPE"]
[null,"PLANTEN"]
[null,"BLOEMEN"]
[null,"BOMEN"]
[null,"ZADEN"]
[null,"PLANTENVOEDSEL"]
[null,"AARDE"]
[null,"MULCH"]
[null,"KUNSTMEST/COMPOST"]
[null,"HERBICIDEN/PESTICIDEN"]
[null,"OMHEINING"]
[null,"TUINMEUBILAIR/BEELDEN"]