{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["juli"],"not_rendered":{"charts":1,"images":0,"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":"juli","index":0,"n_rows":100,"n_cols":11,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,9,0,10]]}
["datum","INKOMSTEN",null,"groep","Opmerking","UITGAVEN",null,null,null,"Totaal juli 2014"]
["2014-07-01","Beginsaldo",100,"Auto",null,"Tanken",35,{"$f":"IF(C2+G2=0,\"\",H1+C2-G2)","v":65},null,"Inkomsten:","Uitgaven:"]
["2014-07-02","Salaris",1600,"Auto","incasso","Wegenbel",70,{"$f":"IF(C3+G3=0,\"\",H2+C3-G3)","v":1595},null,{"$f":"SUM(C:C)","v":2092},{"$f":"SUM(G:G)","v":1795}]
["2014-07-03",null,null,"Huis","incasso","Huur",700,{"$f":"IF(C4+G4=0,\"\",H3+C4-G4)","v":895}]
["2014-07-06",null,null,"Huishouden",null,"Opname",80,{"$f":"IF(C5+G5=0,\"\",H4+C5-G5)","v":815},null,"Saldo vandaag:",{"$f":"VLOOKUP(TODAY(),A:H,8,1)","v":360.5}]
["2014-07-07",null,null,"Auto",null,"Tanken",30,{"$f":"IF(C6+G6=0,\"\",H5+C6-G6)","v":785}]
["2014-07-08",null,null,"Huishouden",null,"Supermarkt",60,{"$f":"IF(C7+G7=0,\"\",H6+C7-G7)","v":725},null,"Totaal per groep:"]
["2014-07-09",null,null,"Kleding",null,"Kleedgeld dochter",45,{"$f":"IF(C8+G8=0,\"\",H7+C8-G8)","v":680},null,"Huis",{"$f":"SUMIF(D:D,J8,G:G)","v":700}]
["2014-07-10",null,null,"Auto",null,"Garage",400,{"$f":"IF(C9+G9=0,\"\",H8+C9-G9)","v":280},null,"Auto",{"$f":"SUMIF(D:D,J9,G:G)","v":535}]
["2014-07-12",null,null,"Abonn","incasso","ComputerIdee",71.5,{"$f":"IF(C10+G10=0,\"\",H9+C10-G10)","v":208.5},null,"Kleding",{"$f":"SUMIF(D:D,J10,G:G)","v":240}]
["2014-07-12",null,null,"Kleding",null,"Jurk",80,{"$f":"IF(C11+G11=0,\"\",H10+C11-G11)","v":128.5},null,"Huishouden",{"$f":"SUMIF(D:D,J11,G:G)","v":220}]
["2014-07-15",null,null,"Huishouden",null,"Supermarkt",55,{"$f":"IF(C12+G12=0,\"\",H11+C12-G12)","v":73.5},null,"Abonn",{"$f":"SUMIF(D:D,J12,G:G)","v":100}]
["2014-07-15","VT Bel",392,"Kleding",null,"Broek",80,{"$f":"IF(C13+G13=0,\"\",H12+C13-G13)","v":385.5}]
["2014-08-02",null,null,"Huishouden",null,"Supermarkt",25,{"$f":"IF(C14+G14=0,\"\",H13+C14-G14)","v":360.5}]
["2014-08-03",null,null,"Kleding",null,"Fietsreparatie",35,{"$f":"IF(C15+G15=0,\"\",H14+C15-G15)","v":325.5}]
["2014-08-04",null,null,"Abonn","incasso","Krant",28.5,{"$f":"IF(C16+G16=0,\"\",H15+C16-G16)","v":297}]
["2014-08-05",null,null,null,null,null,null,{"$f":"IF(C17+G17=0,\"\",H16+C17-G17)","v":""}]
["2014-08-06",null,null,null,null,null,null,{"$f":"IF(C18+G18=0,\"\",H17+C18-G18)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C19+G19=0,\"\",H18+C19-G19)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C20+G20=0,\"\",H19+C20-G20)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C21+G21=0,\"\",H20+C21-G21)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C22+G22=0,\"\",H21+C22-G22)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C23+G23=0,\"\",H22+C23-G23)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C24+G24=0,\"\",H23+C24-G24)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C25+G25=0,\"\",H24+C25-G25)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C26+G26=0,\"\",H25+C26-G26)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C27+G27=0,\"\",H26+C27-G27)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C28+G28=0,\"\",H27+C28-G28)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C29+G29=0,\"\",H28+C29-G29)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C30+G30=0,\"\",H29+C30-G30)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C31+G31=0,\"\",H30+C31-G31)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C32+G32=0,\"\",H31+C32-G32)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C33+G33=0,\"\",H32+C33-G33)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C34+G34=0,\"\",H33+C34-G34)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C35+G35=0,\"\",H34+C35-G35)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C36+G36=0,\"\",H35+C36-G36)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C37+G37=0,\"\",H36+C37-G37)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C38+G38=0,\"\",H37+C38-G38)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C39+G39=0,\"\",H38+C39-G39)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C40+G40=0,\"\",H39+C40-G40)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C41+G41=0,\"\",H40+C41-G41)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C42+G42=0,\"\",H41+C42-G42)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C43+G43=0,\"\",H42+C43-G43)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C44+G44=0,\"\",H43+C44-G44)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C45+G45=0,\"\",H44+C45-G45)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C46+G46=0,\"\",H45+C46-G46)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C47+G47=0,\"\",H46+C47-G47)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C48+G48=0,\"\",H47+C48-G48)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C49+G49=0,\"\",H48+C49-G49)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C50+G50=0,\"\",H49+C50-G50)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C51+G51=0,\"\",H50+C51-G51)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C52+G52=0,\"\",H51+C52-G52)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C53+G53=0,\"\",H52+C53-G53)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C54+G54=0,\"\",H53+C54-G54)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C55+G55=0,\"\",H54+C55-G55)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C56+G56=0,\"\",H55+C56-G56)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C57+G57=0,\"\",H56+C57-G57)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C58+G58=0,\"\",H57+C58-G58)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C59+G59=0,\"\",H58+C59-G59)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C60+G60=0,\"\",H59+C60-G60)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C61+G61=0,\"\",H60+C61-G61)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C62+G62=0,\"\",H61+C62-G62)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C63+G63=0,\"\",H62+C63-G63)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C64+G64=0,\"\",H63+C64-G64)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C65+G65=0,\"\",H64+C65-G65)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C66+G66=0,\"\",H65+C66-G66)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C67+G67=0,\"\",H66+C67-G67)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C68+G68=0,\"\",H67+C68-G68)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C69+G69=0,\"\",H68+C69-G69)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C70+G70=0,\"\",H69+C70-G70)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C71+G71=0,\"\",H70+C71-G71)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C72+G72=0,\"\",H71+C72-G72)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C73+G73=0,\"\",H72+C73-G73)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C74+G74=0,\"\",H73+C74-G74)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C75+G75=0,\"\",H74+C75-G75)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C76+G76=0,\"\",H75+C76-G76)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C77+G77=0,\"\",H76+C77-G77)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C78+G78=0,\"\",H77+C78-G78)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C79+G79=0,\"\",H78+C79-G79)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C80+G80=0,\"\",H79+C80-G80)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C81+G81=0,\"\",H80+C81-G81)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C82+G82=0,\"\",H81+C82-G82)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C83+G83=0,\"\",H82+C83-G83)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C84+G84=0,\"\",H83+C84-G84)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C85+G85=0,\"\",H84+C85-G85)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C86+G86=0,\"\",H85+C86-G86)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C87+G87=0,\"\",H86+C87-G87)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C88+G88=0,\"\",H87+C88-G88)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C89+G89=0,\"\",H88+C89-G89)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C90+G90=0,\"\",H89+C90-G90)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C91+G91=0,\"\",H90+C91-G91)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C92+G92=0,\"\",H91+C92-G92)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C93+G93=0,\"\",H92+C93-G93)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C94+G94=0,\"\",H93+C94-G94)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C95+G95=0,\"\",H94+C95-G95)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C96+G96=0,\"\",H95+C96-G96)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C97+G97=0,\"\",H96+C97-G97)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C98+G98=0,\"\",H97+C98-G98)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C99+G99=0,\"\",H98+C99-G99)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C100+G100=0,\"\",H99+C100-G100)","v":""}]