{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Geldoverzicht","Uitgaven","Maandoverzicht","Grafiekgegevens"],"not_rendered":{"charts":2,"defined_names":8,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Geldoverzicht","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[0,1,1,5],[2,1,2,2],[2,3,2,4],[3,1,18,1],[19,1,20,1],[21,1,22,1]]}
[null,"Persoonlijke geldtracker"]
[{"$nulls":6},"Uitgaven >"]
[{"$nulls":3},"Geldoverzicht"]
[null,"Deze cel bevat een kolomgrafiek met het percentage beschikbare geld.",null,"Rekening","Beginbedrag","Totaal uitgaven","Resterend bedrag"]
[{"$nulls":3},"Lopende rekening",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(Uitgaven[Rekening],\"=\" &Tabel_Geldoverzicht[[#This Row],[Rekening]],Uitgaven[Bedrag])","v":{"v":496,"d":"496.00"}},{"$f":"Tabel_Geldoverzicht[[#This Row],[Beginbedrag]]-Tabel_Geldoverzicht[[#This Row],[Totaal uitgaven]]","v":{"v":2504,"d":"2504.00"}}]
[{"$nulls":3},"Spaarrekening",{"v":500,"d":"500.00"},{"$f":"SUMIF(Uitgaven[Rekening],\"=\" &Tabel_Geldoverzicht[[#This Row],[Rekening]],Uitgaven[Bedrag])","v":{"v":450,"d":"450.00"}},{"$f":"Tabel_Geldoverzicht[[#This Row],[Beginbedrag]]-Tabel_Geldoverzicht[[#This Row],[Totaal uitgaven]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Overig",{"v":200,"d":"200.00"},{"$f":"SUMIF(Uitgaven[Rekening],\"=\" &Tabel_Geldoverzicht[[#This Row],[Rekening]],Uitgaven[Bedrag])","v":{"v":30,"d":"30.00"}},{"$f":"Tabel_Geldoverzicht[[#This Row],[Beginbedrag]]-Tabel_Geldoverzicht[[#This Row],[Totaal uitgaven]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3},"Totaal",{"$f":"SUBTOTAL(109,Tabel_Geldoverzicht[Beginbedrag])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,Tabel_Geldoverzicht[Totaal uitgaven])","v":{"v":976,"d":"976.00"}},{"$f":"SUBTOTAL(109,Tabel_Geldoverzicht[Resterend bedrag])","v":{"v":2724,"d":"2724.00"}}]
{"$rows_empty":11}
[null,"Contanten\nResterend:"]
[]
[null,{"$f":"Tabel_Geldoverzicht[[#Totals],[Resterend bedrag]]/Tabel_Geldoverzicht[[#Totals],[Beginbedrag]]","v":{"v":0.7362162162162162,"d":"74%"}}]

{"sheet":"Uitgaven","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,1,1,3],[2,1,2,2],[3,5,6,6],[7,5,14,6]]}
[null,"Persoonlijke geldtracker"]
[{"$nulls":4},"< Geldoverzicht","Maandoverzicht >"]
[null,"Uitgaven"]
[null,"Datum","Beschrijving","Bedrag","Rekening","Deze cel bevat een tabelslicer om tabelgegevens te filteren op Rekeningtype."]
[null,{"$f":"TODAY()+105","v":"2023-03-23"},"Geldautomaatopname",{"v":40,"d":"40.00"},"Lopende rekening"]
[null,{"$f":"TODAY()+106","v":"2023-03-24"},"Lunch",{"v":5,"d":"5.00"},"Lopende rekening"]
[null,{"$f":"TODAY()+107","v":"2023-03-25"},"Afbetaling auto",{"v":230,"d":"230.00"},"Spaarrekening"]
[null,{"$f":"TODAY()+135","v":"2023-04-22"},"Betaling elektriciteit",{"v":70,"d":"70.00"},"Lopende rekening","Deze cel bevat een tabelslicer om tabelgegevens te filteren op Beschrijving."]
[null,{"$f":"TODAY()+139","v":"2023-04-26"},"Etentje",{"v":53,"d":"53.00"},"Lopende rekening"]
[null,{"$f":"TODAY()+162","v":"2023-05-19"},"Geldopname",{"v":100,"d":"100.00"},"Spaarrekening"]
[null,{"$f":"TODAY()+167","v":"2023-05-24"},"Afbetaling auto",{"v":230,"d":"230.00"},"Lopende rekening"]
[null,{"$f":"TODAY()+198","v":"2023-06-24"},"Betaling elektriciteit",{"v":70,"d":"70.00"},"Spaarrekening"]
[null,{"$f":"TODAY()+212","v":"2023-07-08"},"Geldautomaatopname",{"v":30,"d":"30.00"},"Lopende rekening"]
[null,{"$f":"TODAY()+225","v":"2023-07-21"},"Geldautomaatopname",{"v":50,"d":"50.00"},"Spaarrekening"]
[null,{"$f":"TODAY()+232","v":"2023-07-28"},"Geldautomaatopname",{"v":30,"d":"30.00"},"Overig"]
[null,{"$f":"TODAY()+283","v":"2023-09-17"},"Betaling elektriciteit",{"v":68,"d":"68.00"},"Lopende rekening"]

{"sheet":"Maandoverzicht","index":2,"n_rows":37,"n_cols":6,"rows_kept":37,"merged":[[0,1,1,4],[2,1,2,5],[3,1,3,6],[4,1,16,4],[4,5,8,6],[9,5,16,6],[17,1,17,5]]}
[null,"Maandoverzicht"]
[{"$nulls":5},"< Uitgaven"]
[null,"Selecteer eerst de draaigrafiek om deze gegevens bij te werken.  Klik eenmaal met de rechtermuisknop om het snelmenu weer te geven.  Selecteer Vernieuwen of Alles vernieuwen om de grafiek bij te werken."]
[null,"Rekeningoverzicht"]
[null,"Deze cel bevat het kolomdiagram Rekeningoverzicht waarin lopende rekeningen, spaargeld en andere gegevens voor elke maand worden vergeleken.",{"$nulls":3},"Deze cel bevat een tabelslicer om de grafiek te filteren op Rekeningtype."]
[]
[]
[]
[]
[{"$nulls":5},"Deze cel bevat een tabelslicer om de grafiek te filteren op beschrijving."]
{"$rows_empty":7}
[null,"Uitgavenoverzicht"]
[null,"Details"]
[null,null,"Lopende rekening","Spaarrekening","Overig","Eindtotaal"]
[null,"mrt",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"Geldautomaatopname",{"v":40,"d":"40.00"},null,null,{"v":40,"d":"40.00"}]
[null,"Afbetaling auto",null,{"v":230,"d":"230.00"},null,{"v":230,"d":"230.00"}]
[null,"Lunch",{"v":5,"d":"5.00"},null,null,{"v":5,"d":"5.00"}]
[null,"apr",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"Etentje",{"v":53,"d":"53.00"},null,null,{"v":53,"d":"53.00"}]
[null,"Betaling elektriciteit",{"v":70,"d":"70.00"},null,null,{"v":70,"d":"70.00"}]
[null,"mei",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"Afbetaling auto",{"v":230,"d":"230.00"},null,null,{"v":230,"d":"230.00"}]
[null,"Geldopname",null,{"v":100,"d":"100.00"},null,{"v":100,"d":"100.00"}]
[null,"jun",null,{"v":70,"d":"70.00"},null,{"v":70,"d":"70.00"}]
[null,"Betaling elektriciteit",null,{"v":70,"d":"70.00"},null,{"v":70,"d":"70.00"}]
[null,"jul",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":110,"d":"110.00"}]
[null,"Geldautomaatopname",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":110,"d":"110.00"}]
[null,"sep",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"Betaling elektriciteit",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"Eindtotaal",{"v":496,"d":"496.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":976,"d":"976.00"}]

{"sheet":"Grafiekgegevens","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,0,2]]}
[null,"Draaigrafiekgegevens"]
[null,"Deze draaitabel is de gegevensbron voor de draaigrafiek Rekeningoverzicht op het blad Maandoverzicht"]
[null,"Som van Bedrag","Kolomlabels"]
[null,"Rijlabels","Lopende rekening","Spaarrekening","Overig","Eindtotaal"]
[null,"mrt",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"apr",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"mei",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"jun",null,{"v":70,"d":"70.00"},null,{"v":70,"d":"70.00"}]
[null,"jul",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":110,"d":"110.00"}]
[null,"sep",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"Eindtotaal",{"v":496,"d":"496.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":976,"d":"976.00"}]