{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Bepaal uw positie","totaal positie","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Bepaal uw positie","index":0,"n_rows":98,"n_cols":8,"rows_kept":98,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
["Uitgaven per maand:","Kleurcode","Kosten per periode",null,null,null,"Eigen positie: per maand","Persoonlijke toelichting"]
["Huur/hypotheek/schulden",null,"per mnd","per kwrt","half jaar","per jaar",null,{"$f":"SUM(G3:G11)","v":0}]
["Huur woning",{"$nulls":5},{"$f":"IF(C3>0,C3,IF(D3>0,D3/3,IF(E3>0,E3/6,IF(F3>0,F3/12,0))))","v":0}]
["Service kosten of erfpacht",{"$nulls":5},0]
["Hypotheek woning",{"$nulls":5},0]
["Vereniging van eigenaren",{"$nulls":5},0]
["Aflossing schuld krediet bank",{"$nulls":5},0]
["Aflossing schuld Friesland",{"$nulls":5},0]
["Aflossing schuld kerk en minima",{"$nulls":5},0]
["Aflossing schuld ",{"$nulls":5},0]
["Aflossing schuld …",{"$nulls":5},0]
["Woonlasten",{"$nulls":6},{"$f":"SUM(G13:G20)","v":0}]
["Gas",{"$nulls":5},{"$f":"IF(C13>0,C13,IF(D13>0,D13/3,IF(E13>0,E13/6,IF(F13>0,F13/12,0))))","v":0}]
["Electra",{"$nulls":5},0]
["Water",{"$nulls":5},0]
["TV/Netflix",{"$nulls":5},0]
["Muziekdiensten (Spotify ed)",{"$nulls":5},0]
["Telefonie",{"$nulls":5},0]
["Internet",{"$nulls":5},0]
["Overig",{"$nulls":5},0]
["Verzekeringen",{"$nulls":6},{"$f":"SUM(G22:G33)","v":0}]
["Opstalverzekering",{"$nulls":5},{"$f":"IF(C22>0,C22,IF(D22>0,D22/3,IF(E22>0,E22/6,IF(F22>0,F22/12,0))))","v":0}]
["Inboedelverzekering",{"$nulls":5},0]
["WA verzekering",{"$nulls":5},0]
["Autoverzekeringen",{"$nulls":5},0]
["Brommerverzekering",{"$nulls":5},0]
["Uitvaartverzekering",{"$nulls":5},0]
["Overlijdensrisicoverzekering",{"$nulls":5},0]
["Ziektekostenverzekering",{"$nulls":5},0]
["Reisverzekering",{"$nulls":5},0]
["Rechtsbijstandverzekering",{"$nulls":5},0]
["Huisdierenverzekering",{"$nulls":5},0]
["Pensioenverzekering",{"$nulls":5},0]
["Overig",{"$nulls":5},0]
["Belastingen",{"$nulls":6},{"$f":"SUM(G36:G40)","v":0}]
["Fiscale bijtelling auto",{"$nulls":5},{"$f":"IF(C36>0,C36,IF(D36>0,D36/3,IF(E36>0,E36/6,IF(F36>0,F36/12,0))))","v":0}]
["Gemeentelijke belastingen (riool, afvalstoffen enz.)",{"$nulls":5},0]
["Waterschapsbelasting",{"$nulls":5},0]
["Alimentatie (ex-partner)",{"$nulls":5},0]
["Overig",{"$nulls":5},0]
["Kinderen",{"$nulls":6},{"$f":"SUM(G42:G48)","v":0}]
["Opvang",{"$nulls":5},{"$f":"IF(C42>0,C42,IF(D42>0,D42/3,IF(E42>0,E42/6,IF(F42>0,F42/12,0))))","v":0}]
["Schoolgeld",{"$nulls":5},0]
["Studieboeken en studiegeld",{"$nulls":5},0]
["Sporten van de kinderen",{"$nulls":5},0]
["Allimentatie kind(eren)",{"$nulls":5},0]
["Zakgeld",{"$nulls":5},0]
["Overig",{"$nulls":5},0]
["Leefgeld",{"$nulls":6},{"$f":"SUM(G50:G57)","v":0}]
["Boodschappen",{"$nulls":5},{"$f":"IF(C50>0,C50,IF(D50>0,D50/3,IF(E50>0,E50/6,IF(F50>0,F50/12,0))))","v":0}]
["Persoonlijke verzorging (kapper, toiletart, pedicure enz.)",{"$nulls":5},0]
["Dokter / tandarts / alternatief / therapeut",{"$nulls":5},0]
["Bankkosten",{"$nulls":5},0]
["Lidmaatschap en abonnementen (sport/krant/etc.)",{"$nulls":5},0]
["Eten halen/bezorgen + uitstapjes",{"$nulls":5},0]
["Zakgeld (volwassenen)",{"$nulls":5},0]
["Overig",{"$nulls":5},0]
["Auto('s)",{"$nulls":6},{"$f":"SUM(G59:G62)","v":0}]
["Wegenbelasting auto('s)",{"$nulls":5},{"$f":"IF(C59>0,C59,IF(D59>0,D59/3,IF(E59>0,E59/6,IF(F59>0,F59/12,0))))","v":0}]
["Lening auto",{"$nulls":5},0]
["Brandstof",{"$nulls":5},0]
["Pechhulp",{"$nulls":5},0]
["Overige transportkosten/middelen",{"$nulls":6},{"$f":"SUM(G64:G67)","v":0}]
["OV-chipkaart",{"$nulls":5},{"$f":"IF(C64>0,C64,IF(D64>0,D64/3,IF(E64>0,E64/6,IF(F64>0,F64/12,0))))","v":0}]
["Boot / taxi en busdiensten",{"$nulls":5},0]
["Brommer (brandstof)",{"$nulls":5},0]
["Overig",{"$nulls":5},0]
["Hobby/sport volwassenen",{"$nulls":6},{"$f":"SUM(G69:G72)","v":0}]
["Lidmaatschap …..",{"$nulls":5},{"$f":"IF(C69>0,C69,IF(D69>0,D69/3,IF(E69>0,E69/6,IF(F69>0,F69/12,0))))","v":0}]
["Overige abonnementen",{"$nulls":5},0]
["Recreatie/caravan/boot stalling enz.",{"$nulls":5},0]
["Overig",{"$nulls":5},0]
["Huisdieren",{"$nulls":6},{"$f":"SUM(G74:G77)","v":0}]
["Voeding",{"$nulls":5},{"$f":"IF(C74>0,C74,IF(D74>0,D74/3,IF(E74>0,E74/6,IF(F74>0,F74/12,0))))","v":0}]
["Verzorging en training",{"$nulls":5},0]
["Gezondheid (waar onder dierenarts)",{"$nulls":5},0]
["Overig",{"$nulls":5},0]
["Reserveringen en budgetten",{"$nulls":6},{"$f":"SUM(G79:G86)","v":0}]
["Kleding, schoenen","50 pp",{"$nulls":4},{"$f":"IF(C79>0,C79,IF(D79>0,D79/3,IF(E79>0,E79/6,IF(F79>0,F79/12,0))))","v":0}]
["Inventaris/witgoed",35.0,{"$nulls":4},0]
["Onderhoud huis en tuin",0.01,{"$nulls":4},0]
["Ziektekosten (niet vergoed)",385.0,{"$nulls":4},0]
["Auto('s) (onderhoud/afschrijf/sparen)",600.0,{"$nulls":4},0]
["Recreatie en vakanties",0.08,{"$nulls":4},0]
["Overige reserveringen",{"$nulls":5},0]
["Sparen",{"$nulls":5},0]
[]
["Inkomsten",{"$nulls":6},{"$f":"SUM(G89:G98)","v":0}]
["Salaris 1",{"$nulls":5},{"$f":"IF(C89>0,C89,IF(D89>0,D89/3,IF(E89>0,E89/6,IF(F89>0,F89/12,0))))","v":0}]
["Salaris 2",{"$nulls":5},0]
["Uitkering(en)",{"$nulls":5},0]
["Alimentatie",{"$nulls":5},0]
["Vakantiegeld en bonussen",{"$nulls":5},0]
["Voorlopige aanslag",{"$nulls":5},0]
["Huurtoeslag",{"$nulls":5},0]
["Zorgtoeslag",{"$nulls":5},0]
["Kindertoeslag / bijslag",{"$nulls":5},0]
["Kind gebonden budget",{"$nulls":5},0]

{"sheet":"totaal positie","index":1,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[19,1,19,3],[27,1,27,4],[28,1,28,3],[29,1,29,3],[30,1,30,3],[33,4,37,4],[7,1,7,3],[8,1,8,3],[9,1,9,3],[11,1,11,3],[13,1,13,3],[15,1,15,3],[18,1,18,3]]}
[null,"Postitie per maand"]
[null,"Totaal huur/hypotheek/schulden",null,null,{"$f":"+'Bepaal uw positie'!H2","v":0}]
[null,"Totaal woonlasten en reserveringen onderhoud en inventaris",null,null,{"$f":"SUM('Bepaal uw positie'!G13:G20)+'Bepaal uw positie'!G81+'Bepaal uw positie'!G80","v":0}]
[null,"Totaal verzekeringen en reservering ziektekosten",null,null,{"$f":"SUM('Bepaal uw positie'!G22:G34)+'Bepaal uw positie'!G82","v":0}]
[null,"Totaal belastingen",null,null,{"$f":"+'Bepaal uw positie'!H35","v":0}]
[null,"Totaal kinderen",null,null,{"$f":"SUM('Bepaal uw positie'!G42:G48)","v":0}]
[null,"Totaal leefgeld en reserveringen (kleding, vakantie, overig en sparen) ",null,null,{"$f":"SUM('Bepaal uw positie'!G50:G57)+'Bepaal uw positie'!G79+'Bepaal uw positie'!G84+'Bepaal uw positie'!G85+'Bepaal uw positie'!G86","v":0}]
[null,"Totaal auto('s) + overige transportkosten en reservering auto",null,null,{"$f":"+'Bepaal uw positie'!H58+'Bepaal uw positie'!H63+'Bepaal uw positie'!G83","v":0}]
[null,"Totaal hobby",null,null,{"$f":"+'Bepaal uw positie'!H68","v":0}]
[null,"Totaal huisdieren",null,null,{"$f":"+'Bepaal uw positie'!H73","v":0}]
[]
[null,"Totale uitgaven per maand",null,null,{"$f":"SUM(E2:E10)","v":0}]
[{"$nulls":4}," "]
[null,"Totaal inkomsten per maand",null,null,{"$f":"SUM('Bepaal uw positie'!G89:G98)","v":0}]
[]
[null,"Blijft over om te besteden",null,null,{"$f":"E14-E12","v":0}]
[]
[null,"Reserveringen (informatief)"]
[null,"Totaal reserveringen en budgetten",null,null,{"$f":"+'Bepaal uw positie'!H78","v":0}]
[null,"Totaal vaste lasten rekening",null,null,{"$f":"SUM('Bepaal uw positie'!G3:G40)","v":0}]
[]
[null,"Potentieel spaargeld","Sparen","Restant","Uw positie"]
[null,2021.0,{"$f":"'Bepaal uw positie'!G86*12","v":0},{"$f":"E16*12","v":0},{"$f":"SUM(C23:D23)","v":0}]
[null,2022.0,{"$f":"'Bepaal uw positie'!G86*24","v":0},{"$f":"E16*24","v":0},0]
[null,2023.0,{"$f":"'Bepaal uw positie'!G86*36","v":0},{"$f":"E16*36","v":0},0]
[null,2024.0,{"$f":"'Bepaal uw positie'!G86*48","v":0},{"$f":"E16*48","v":0},0]
[]
[null,"Totale uitgaven per kleurcode"]
[null,"Vaste lasten (niet beinvloedbaar)",null,null,{"$f":"+'Bepaal uw positie'!G3+'Bepaal uw positie'!G4+'Bepaal uw positie'!G5+'Bepaal uw positie'!G6+'Bepaal uw positie'!G13+'Bepaal uw positie'!G14+'Bepaal uw positie'!G15+'Bepaal uw positie'!G37+'Bepaal uw positie'!G38+'Bepaal uw positie'!G39+'Bepaal uw positie'!G43+'Bepaal uw positie'!G44+'Bepaal uw positie'!G46","v":0}]
[null,"Vaste lasten (beinvloedbaar dmv opzeggen of bezuinigen)",null,null,{"$f":"+'Bepaal uw positie'!G7+SUM('Bepaal uw positie'!G7:G11,'Bepaal uw positie'!G16:G19,'Bepaal uw positie'!G22:G33,'Bepaal uw positie'!G36,'Bepaal uw positie'!G42)+'Bepaal uw positie'!G52+'Bepaal uw positie'!G53","v":0}]
[null,"Variabele uitgaven (beinvloedbaar)",null,null,{"$f":"+SUM('Bepaal uw positie'!G20,'Bepaal uw positie'!G34,'Bepaal uw positie'!G40,'Bepaal uw positie'!G45,'Bepaal uw positie'!G47:G48,'Bepaal uw positie'!G50:G51,'Bepaal uw positie'!G54:G57,'Bepaal uw positie'!G59:G62,'Bepaal uw positie'!G64:G67,'Bepaal uw positie'!G69:G72,'Bepaal uw positie'!G79:G86)","v":0}]
[]
[{"$nulls":4},"aantal punten"]
[null," 1 punt:      Kan mijn papieren niet vinden, geen inzicht/overzicht",null,null,".."]
[null," 2 punten:   Kan de belangrijkste papieren vinden, weinig inzicht"]
[null," 3 punten:   Kan de belangrijkste papieren vinden, enig inzicht"]
[null," 4 punten:   Kan alle papieren vinden, redelijk inzicht"]
[null," 5 punten:   Kan alle papieren vinden, volledig inzicht"]

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