{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home","Begroting","Kostensoorten","Gegevens","Rapportage","Grafiek"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Home","index":0,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum start"]
[null,"Begroting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum nu",{"$f":"TODAY()","v":"2018-04-24"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verschil",{"$f":"S2-S1","v":"2018-04-24"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"*","info@terzake-excel.nl",null,null,"Check 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(","0317 200 009",null,null,"Check 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check 7"]

{"sheet":"Begroting","index":1,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Ter Zake Excel begroting"]
[]
[null,"Maximaal budget (aanpassen naar eigen budget)"]
[null,"Totaal uitgaven",null,null,null,null,{"$f":"SUM(G9:G61)","v":0}]
[null,"Over/tekort",null,null,null,null,{"$f":"G4-G5","v":0},null,"*","info@terzake-excel.nl"]
[null,null,null,null,null,null,null,null,"(","0317 200 009"]
[null,"Kostenpost","Kostensoort","Stuksprijs","Aantal","Omschrijving","Prijs"]
[null,null,null,null,null,null,{"$f":"D9*E9","v":0}]
[null,null,null,null,null,null,{"$f":"D10*E10","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"D26*E26","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"D58*E58","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]

{"sheet":"Kostensoorten","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Ter Zake Excel begroting"]
[]
[null,"Kostensoorten","Omschrijving"]

{"sheet":"Gegevens","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Controle"]
["Datum start","2017-09-08"]
["Datum nu",{"$f":"TODAY()","v":"2018-04-24"}]
["Verschil",{"$f":"B3-B2","v":228}]
["Check 1"]
["Check 2"]
["Check 3"]
["Check 4"]
["Check 5"]
["Check 6"]
["Check 7"]

{"sheet":"Rapportage","index":4,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Ter Zake Excel begroting"]
[]
[null,"Kostensoorten","Kosten"]
[null,{"$f":"IF(Kostensoorten!B6=\"\",\"\",Kostensoorten!B6)","v":""},{"$f":"SUMIFS(Begroting!G:G,Begroting!C:C,B5,Begroting!C:C,\"<>\"&\"\")","v":0}]
[null,{"$f":"IF(Kostensoorten!B7=\"\",\"\",Kostensoorten!B7)","v":""},{"$f":"SUMIFS(Begroting!G:G,Begroting!C:C,B6,Begroting!C:C,\"<>\"&\"\")","v":0}]
[null,{"$f":"IF(Kostensoorten!B8=\"\",\"\",Kostensoorten!B8)","v":""},{"$f":"SUMIFS(Begroting!G:G,Begroting!C:C,B7,Begroting!C:C,\"<>\"&\"\")","v":0}]
[null,{"$f":"IF(Kostensoorten!B9=\"\",\"\",Kostensoorten!B9)","v":""},{"$f":"SUMIFS(Begroting!G:G,Begroting!C:C,B8,Begroting!C:C,\"<>\"&\"\")","v":0},null,"*","info@terzake-excel.nl"]
[null,{"$f":"IF(Kostensoorten!B10=\"\",\"\",Kostensoorten!B10)","v":""},{"$f":"SUMIFS(Begroting!G:G,Begroting!C:C,B9,Begroting!C:C,\"<>\"&\"\")","v":0},null,"(","0317 200 009"]

{"sheet":"Grafiek","index":5,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Ter Zake Excel begroting"]
[]
[]
[null,null,"Begroting per kostensoort"]
[]
[]
[null,null,null,null,null,null,null,null,null,"*","info@terzake-excel.nl"]
[null,null,null,null,null,null,null,null,null,"(","0317 200 009"]
[]
[]
[]
[]
[null,"Overhead",5000]
[null,"productiekosten",14000]
[null,"servicekosten",8000]
[null,"Advieskosten",3000]