{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Uitgaven","Categorie"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Uitgaven","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[0,1,0,5],[1,1,1,6]]}
[null,"UITGAVENBUDGET",{"$nulls":4},{"$f":"TODAY()","v":"2018-06-19"}]
[null,"Bedrijfsnaam"]
[null,"Uitgaven","Categorie","Budget","Werkelijk","Verschil (€)","Verschil (%)"]
[null,"Reclame","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Schulden","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Voordelen","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Benodigdheden","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Portokosten","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Huur of hypotheek","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Verkoopuitgaven","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Belasting","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Gas, water en elektra","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Overige","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Verzekering","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Rente","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Telefoon","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Onderhoud en reparaties","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Juridische kosten","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Afschrijving","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Verzending","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Opslag","Exploiteren",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Winkel","Persoonlijk",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Verkopers","Persoonlijk",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Overige","Persoonlijk",null,null,{"$f":"IFERROR(SUM(Uitgaven[Budget]-Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]/Uitgaven[Budget]),\"\")","v":""}]
[null,"Totale uitgaven",null,{"$f":"IFERROR(SUM(Uitgaven[Budget]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Werkelijk]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[Verschil (€)]), \"\")","v":0},{"$f":"IFERROR(SUM(Uitgaven[[#Totals],[Verschil (€)]]/Uitgaven[[#Totals],[Budget]]),\"\")","v":""}]

{"sheet":"Categorie","index":1,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"Categorie zoeken"]
[null,"Categorie"]
[null,"Exploiteren"]
[null,"Persoonlijk"]