{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Overzicht","Activa","Passiva","Categorieën"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Overzicht","index":0,"n_rows":12,"n_cols":4,"rows_kept":12}
[null,"Balans"]
[null,null,{"$f":"\"FY-\"&YEAR(TODAY())-1","v":"FY-2022"},{"$f":"\"FY-\"&YEAR(TODAY())","v":"FY-2023"}]
[null,"Type activa","Vorig jaar","Dit jaar"]
[null,"Huidige activa",{"$f":"SUMIFS(Activa[Vorig jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Vorig jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":600},{"$f":"SUMIFS(Activa[Dit jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Dit jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":600}]
[null,"Vaste activa",{"$f":"SUMIFS(Activa[Vorig jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Vorig jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":{"v":-100,"d":"-100 "}},{"$f":"SUMIFS(Activa[Dit jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Dit jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":{"v":-85,"d":"-85 "}}]
[null,"Overige activa",{"$f":"SUMIFS(Activa[Vorig jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Vorig jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":0},{"$f":"SUMIFS(Activa[Dit jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Dit jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":0}]
[null,"Huidige passiva",{"$f":"SUMIFS(Activa[Vorig jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Vorig jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":500},{"$f":"SUMIFS(Activa[Dit jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Dit jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":350}]
[null,"Langlopende schulden",{"$f":"SUMIFS(Activa[Vorig jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Vorig jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":0},{"$f":"SUMIFS(Activa[Dit jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Dit jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":0}]
[null,"Eigen vermogen",{"$f":"SUMIFS(Activa[Vorig jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Vorig jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":0},{"$f":"SUMIFS(Activa[Dit jaar],Activa[Type activa],Dashboard[[#This Row],[Type activa]])+SUMIFS(Passiva[Dit jaar],Passiva[Type passiva],Dashboard[[#This Row],[Type activa]])","v":350}]
[null,"Totaal activa",{"$f":"Activa[[#Totals],[Vorig jaar]]","v":500},{"$f":"Activa[[#Totals],[Dit jaar]]","v":515}]
[null,"Totaal passiva en aandelenkapitaal",{"$f":"Passiva[[#Totals],[Vorig jaar]]","v":500},{"$f":"Passiva[[#Totals],[Dit jaar]]","v":700}]
[null,"Saldo",{"$f":"C10-C11","v":0},{"$f":"D10-D11","v":{"v":-185,"d":"-185 "}}]

{"sheet":"Activa","index":1,"n_rows":14,"n_cols":5,"rows_kept":14}
[null,"Activa"]
[{"$nulls":3},{"$f":"FY_YEAR","v":"FY-2022"},{"$f":"FY_YEAR_2","v":"FY-2023"}]
[null,"Type activa","Beschrijving","Vorig jaar","Dit jaar"]
[null,"Huidige activa","Contant geld",600,600]
[null,"Huidige activa","Investeringen"]
[null,"Huidige activa","Overzichten"]
[null,"Huidige activa","Debiteuren"]
[null,"Huidige activa","Vooruitbetaalde kosten"]
[null,"Vaste activa","Onroerend goed en apparatuur"]
[null,"Vaste activa","Huurverbeteringen"]
[null,"Vaste activa","Vermogens- en andere investeringen"]
[null,"Vaste activa","Minus samengevoegde afschrijving (negatieve waarde)",{"v":-100,"d":"-100 "},{"v":-85,"d":"-85 "}]
[null,"Overige activa","Liefdadigheid"]
[null,"Totaal activa",null,{"$f":"SUBTOTAL(109,Activa[Vorig jaar])","v":500},{"$f":"SUBTOTAL(109,Activa[Dit jaar])","v":515}]

{"sheet":"Passiva","index":2,"n_rows":12,"n_cols":5,"rows_kept":12}
[null,"Passiva"]
[{"$nulls":3},{"$f":"FY_YEAR","v":"FY-2022"},{"$f":"FY_YEAR_2","v":"FY-2023"}]
[null,"Type passiva","Beschrijving","Vorig jaar","Dit jaar"]
[null,"Huidige passiva","Crediteuren",null,350]
[null,"Huidige passiva","Opgebouwde salarissen"]
[null,"Huidige passiva","Opgebouwde compensatie",500]
[null,"Huidige passiva","Verrekenbare belasting "]
[null,"Huidige passiva","Inkomsten uit vermogen"]
[null,"Langlopende schulden","Hypotheekbetalingen"]
[null,"Eigen vermogen","Investeringskapitaal",null,350]
[null,"Eigen vermogen","Opgebouwde ingehouden winsten"]
[null,"Totaal passiva en aandelenkapitaal",null,{"$f":"SUBTOTAL(109,Passiva[Vorig jaar])","v":500},{"$f":"SUBTOTAL(109,Passiva[Dit jaar])","v":700}]

{"sheet":"Categorieën","index":3,"n_rows":9,"n_cols":2,"rows_kept":9}
[null,"Categorieën"]
[]
[null,"Categorieën"]
[null,"Huidige activa"]
[null,"Vaste activa"]
[null,"Overige activa"]
[null,"Huidige passiva"]
[null,"Langlopende schulden"]
[null,"Eigen vermogen"]