{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Daten","Jan","Jahr"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"Daten","index":0,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[17,3,17,4],[25,3,25,4],[31,3,31,4]]}
["Kategorien","Quelle",null,null,null,null,"Monat",66]
["Lebensmittel","Lidl",null,"Kal.-Jahr:",2015,null,"Jan",241]
["Kleidung","Netto",null,null,null,null,"Feb",66]
["Haushalt","Aldi",null,null,null,null,"Mrz",206]
["Gesundheit","Bäcker",null,"Konto","Konto-Einnahm.",null,"Apr",206]
["Auto","Kaufland","Name 1:","A","+",null,"Mai",206]
["Wohnung","Edeka","Name 2:","B",null,null,"Jun",206]
["Kosmetik","Rossmann",null,"K",null,null,"Jul",206]
["Garten","Metzen",null,"KO",null,null,"Aug",206]
["Freizeit A","Pfennigpfeiffer",null,"A+Datum",null,null,"Sep",171]
["Freizeit B","Penny",null,"B+Datum",null,null,"Okt",206]
["Freizeit A+B","Norma",null,null,null,null,"Nov",206]
["Kinder","Praktiker",null,null,null,null,"Dez",136]
["Sonstiges","McGeiz",null,null,null,null,"Jan"]
["Urlaub","Toom",null,null,null,null,"Feb"]
["Sparen","Miete",null,null,null,null,"Mrz"]
["Steuerrückerstattung","TV",null,null,null,null,"Apr"]
["Spenden","Internet",null,"Ausschluß-Kategorien",null,null,"Mai"]
["Gehalt A","Miete Kinder",null,"Auto",null,null,"Jun"]
["Gehalt B","Rundfunk Fernsehen",null,"Sonstiges",null,null,"Jul"]
["Gewinn Ebay","A Gehalt",null,"Garten",null,null,"Aug"]
["Bar","B Gehalt",null,"Freizeit A",null,null,"Sep"]
["Lotto","Kindergeld",null,"Freizeit B",null,null,"Okt"]
[null,"Energie",null,"Auto",null,null,"Nov"]
[null,"Bankgebühr",null,null,null,null,"Dez"]
[null,"Bankgebühr",null,"Kategorie-Bereich"]
[null,null,null,"Neuer Endwert","Akt. Endwert"]
[null,null,null,23,"A23",null,"Top","Left"]
[null,null,null,null,null,null,146.25,768]
[null,null,null,null,null,null,182.25,797.25]
[]
[null,null,null,"Quelle-Artikel-Bereich"]
[null,null,null,"Neuer Endwert","Akt. Endwert"]
[null,null,null,26,"B26"]
[]
[]
[]
[]
[]
[]
[]
[null,"Fixkosten"]
["Kategorie","Bezeichnung","Kosten / €","Einnahme"]
["Wohnung","Miete"]
["Wohnung","TV",2.4900000000000002]
["Wohnung","Internet"]
["Kinder","Miete",250]
["Wohnung","Rundfunk Fernsehen",53.94]
["Gehalt A","Lothar Rente",null,"+"]
["Gehalt B","Silvia Gehalt",null,"+"]
["Sonstiges","Kindergeld",184,"+"]
["Haushalt","Energie",64]
["Sonstiges","Bankgebühr"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"COUNTIF(A44:A66,\">\"\"\")-1","v":9}]
[]
["Artikelgruppe","Artikel"]
["Bankgebühr"]
["Bausparen"]
["Brot"]
["Ebay"]
["Fleisch"]
["Gemüse"]
["Getränke"]
["Gewürze"]
["Handy"]
["Internet"]
["Internet"]
["Kaffee"]
["Kfz 1"]
["Kfz 2"]
["Essen"]
["Kinder Mietzuschuss"]
["Miete"]
["Obst"]
["Paypal"]
["Reparaturem"]
["A Essen"]
["B Essen"]
["TV"]
["TV Beitrag"]
["Unfallversciherung"]

{"sheet":"Jan","index":1,"n_rows":66,"n_cols":11,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,"Bargeld Einnahmen","Saldo Vormonat:","Kontostand","Einnahmen","Ausgaben","Bargeld-Verbrauch","Bargeld Ist",{"$f":"\"Verbrauch \" &Daten!$D$7 &\" :\"","v":"Verbrauch B :"},{"$f":"\"Verbrauch \" &Daten!$D$6 &\" :\"","v":"Verbrauch A :"}]
["Datum",{"$f":"ABS(SUMIFS($F$42:$F$600,$B$42:$B$600,\"=Bar\"))","v":0},null,{"$f":"$C$2-$F$2+$E$2","v":0},{"$f":"ABS(SUMIFS($F$42:$F$600,$G$42:$G$600,\"=K\",$H$42:$H$600,\"+\"))","v":0},{"$f":"ABS(SUMIFS($F$42:$F$600,$G$42:$G$600,\"=K\",$H$42:$H$600,\"=\"))","v":0},{"$f":"SUM(I2:J2)","v":0},{"$f":" SUM($H$4:$H$28)-SUM($I$4:$I$28)-SUM($J$4:$J$28)+$B$2+H3","v":0},{"$f":"SUM($I$42:$I$600)","v":0},{"$f":"SUM($J$42:$J$600)","v":0}]
["Übertrag"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Daten!$A$2&\" :\"","v":"Lebensmittel :"},{"$f":"SUM(($B$42:$B$600=Daten!A2)*($F$42:$F$600))","v":0},{"$f":"Daten!$A$6&\" :\"","v":"Auto :"},{"$f":"SUM(($B$42:$B$600=Daten!A6)*($F$42:$F$600))","v":0},null,{"$f":"Daten!$A$10&\" :\"","v":"Freizeit A :"},{"$f":"SUM(($B$42:$B$600=Daten!A10)*($F$42:$F$600))","v":0},{"$f":"Daten!$A$14&\" :\"","v":"Sonstiges :"},{"$f":"SUM(($B$42:$B$600=Daten!A14)*($H$42:$H$600=\"\")*($F$42:$F$600))","v":0}]
[]
[null,{"$f":"Daten!$A$3&\" :\"","v":"Kleidung :"},{"$f":"SUM(($B$42:$B$600=Daten!A3)*($F$42:$F$600))","v":0},{"$f":"Daten!$A$7&\" :\"","v":"Wohnung :"},{"$f":"SUM(($B$42:$B$600=Daten!A7)*($F$42:$F$600))","v":0},null,{"$f":"Daten!$A$11&\" :\"","v":"Freizeit B :"},{"$f":"SUM(($B$42:$B$600=Daten!A11)*($F$42:$F$600))","v":0},{"$f":"Daten!$A$15&\" :\"","v":"Urlaub :"},{"$f":"SUMPRODUCT(($B$42:$B$600=Daten!A15)*($F$42:$F$600>=0)*($F$42:$F$600))","v":0}]
[]
[null,{"$f":"Daten!$A$4&\" :\"","v":"Haushalt :"},{"$f":"SUM(($B$42:$B$600=Daten!A4)*($F$42:$F$600))","v":0},{"$f":"Daten!$A$8&\" :\"","v":"Kosmetik :"},{"$f":"SUM(($B$42:$B$600=Daten!A8)*($F$42:$F$600))","v":0},null,{"$f":"Daten!$A$12&\" :\"","v":"Freizeit A+B :"},{"$f":"SUM(($B$42:$B$600=Daten!A12)*($F$42:$F$600))","v":0},"Sparen:",{"$f":"SUM(($B$42:$B$600=Daten!A16)*($F$42:$F$600))","v":0}]
[]
[null,{"$f":"Daten!$A$5&\" :\"","v":"Gesundheit :"},{"$f":"SUM(($B$42:$B$600=Daten!A5)*($F$42:$F$600))","v":0},{"$f":"Daten!$A$9&\" :\"","v":"Garten :"},{"$f":"SUM(($B$42:$B$600=Daten!A9)*($F$42:$F$600))","v":0},null,{"$f":"Daten!$A$13&\" :\"","v":"Kinder :"},{"$f":"SUM(($B$42:$B$600=Daten!A13)*($F$42:$F$600))","v":0},"Einnahmen:",{"$f":"ABS(SUMIFS($F$42:$F$600,$H$42:$H$600,\"+\"))","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(A38<>\"\",SUM(A38:G38),\"\")","v":""},"Gesamt:",{"$f":"C30+C32+C34+C36+E30+E32+E34+E36+H30+H32+H34+H36+J30+J32","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(A39<>\"\",A39-B39-C39-D39-E39-F39-G39,\"\")","v":""}]
["Datum","Kategorie","Quelle","Artikelgruppe","Artikel","Preis",{"$f":"Daten!$D$6&\"-\"&Daten!$D$7&\"-\"&Daten!$D$8&\"-\"&\" K0\"","v":"A-B-K- K0"},"Einn.",{"$f":"I$3+SUM($I$4:$I$28)-SUM($I$42:$I$600)","v":0},{"$f":"$J$3+SUM($J$4:$J$28)-SUM($J$42:$J$600)","v":0}]
["02.01.2014","Sparen","ING-DiBa AG,",null,null,50,"K",null,{"$f":"Daten!$D$7&\":    \"&ROUND(SUM($I$3:$I$28),2)-ROUND(SUM($I$42:$I$599),2)+I3&\" €\"","v":"B:    0 €"},{"$f":"Daten!$D$6&\":    \"& ROUND(SUM($J$3:$J$28),2)-ROUND(SUM($J$42:$J$599),2)+J3&\" €\"","v":"A:    0 €"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G42=Daten!$D$7,F42,0)","v":0},{"$f":"IF(G42=Daten!$D$6,F42,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G43=Daten!$D$7,F43,0)","v":0},{"$f":"IF(G43=Daten!$D$6,F43,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G44=Daten!$D$7,F44,0)","v":0},{"$f":"IF(G44=Daten!$D$6,F44,0)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G45=Daten!$D$7,F45,0)","v":0},{"$f":"IF(G45=Daten!$D$6,F45,0)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G46=Daten!$D$7,F46,0)","v":0},{"$f":"IF(G46=Daten!$D$6,F46,0)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G47=Daten!$D$7,F47,0)","v":0},{"$f":"IF(G47=Daten!$D$6,F47,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G48=Daten!$D$7,F48,0)","v":0},{"$f":"IF(G48=Daten!$D$6,F48,0)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G49=Daten!$D$7,F49,0)","v":0},{"$f":"IF(G49=Daten!$D$6,F49,0)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G50=Daten!$D$7,F50,0)","v":0},{"$f":"IF(G50=Daten!$D$6,F50,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G51=Daten!$D$7,F51,0)","v":0},{"$f":"IF(G51=Daten!$D$6,F51,0)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G52=Daten!$D$7,F52,0)","v":0},{"$f":"IF(G52=Daten!$D$6,F52,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G53=Daten!$D$7,F53,0)","v":0},{"$f":"IF(G53=Daten!$D$6,F53,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G54=Daten!$D$7,F54,0)","v":0},{"$f":"IF(G54=Daten!$D$6,F54,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G55=Daten!$D$7,F55,0)","v":0},{"$f":"IF(G55=Daten!$D$6,F55,0)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G56=Daten!$D$7,F56,0)","v":0},{"$f":"IF(G56=Daten!$D$6,F56,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G57=Daten!$D$7,F57,0)","v":0},{"$f":"IF(G57=Daten!$D$6,F57,0)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G58=Daten!$D$7,F58,0)","v":0},{"$f":"IF(G58=Daten!$D$6,F58,0)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G59=Daten!$D$7,F59,0)","v":0},{"$f":"IF(G59=Daten!$D$6,F59,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G60=Daten!$D$7,F60,0)","v":0},{"$f":"IF(G60=Daten!$D$6,F60,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G61=Daten!$D$7,F61,0)","v":0},{"$f":"IF(G61=Daten!$D$6,F61,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G62=Daten!$D$7,F62,0)","v":0},{"$f":"IF(G62=Daten!$D$6,F62,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G63=Daten!$D$7,F63,0)","v":0},{"$f":"IF(G63=Daten!$D$6,F63,0)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(G64=Daten!$D$7,F64,0)","v":0},{"$f":"IF(G64=Daten!$D$6,F64,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G65=Daten!$D$7,F65,0)","v":0},{"$f":"IF(G65=Daten!$D$6,F65,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G66=Daten!$D$7,F66,0)","v":0},{"$f":"IF(G66=Daten!$D$6,F66,0)","v":0}]

{"sheet":"Jahr","index":2,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,13,1,13],[37,1,37,3],[37,4,37,6],[37,7,37,9],[37,10,37,12],[0,0,1,0],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,1,12]]}
["Bier","Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","Gesamt"]
[]
[]
[{"$f":"Daten!A2","v":"Lebensmittel"},{"$f":"Jan!$C$30","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:M4)","v":0}]
[]
[{"$f":"Daten!A3","v":"Kleidung"},{"$f":"Jan!$C$32","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B6:M6)","v":0}]
[]
[{"$f":"Daten!A4","v":"Haushalt"},{"$f":"Jan!$C$34","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B8:M8)","v":0}]
[]
[{"$f":"Daten!A5","v":"Gesundheit"},{"$f":"Jan!$C$36","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B10:M10)","v":0}]
[]
[{"$f":"Daten!A6","v":"Auto"},{"$f":"Jan!$E$30","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B12:M12)","v":0}]
[]
[{"$f":"Daten!A7","v":"Wohnung"},{"$f":"Jan!$E$32","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B14:M14)","v":0}]
[]
[{"$f":"Daten!A8","v":"Kosmetik"},{"$f":"Jan!$E$34","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B16:M16)","v":0}]
[]
[{"$f":"Daten!A9","v":"Garten"},{"$f":"Jan!$E$36","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B18:M18)","v":0}]
[]
[{"$f":"Daten!A10","v":"Freizeit A"},{"$f":"Jan!$H$30","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B20:M20)","v":0}]
[]
[{"$f":"Daten!A11","v":"Freizeit B"},{"$f":"Jan!$H$32","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B22:M22)","v":0}]
[]
[{"$f":"Daten!A12","v":"Freizeit A+B"},{"$f":"Jan!$H$34","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B24:M24)","v":0}]
[]
[{"$f":"Daten!A13","v":"Kinder"},{"$f":"Jan!$H$36","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B26:M26)","v":0}]
[]
[{"$f":"Daten!A14","v":"Sonstiges"},{"$f":"Jan!$J$30","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B28:M28)","v":0}]
[]
[{"$f":"Daten!A15","v":"Urlaub"},{"$f":"Jan!$J$32","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B30:M30)","v":0}]
[]
["Sparen  :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B32:M32)","v":0}]
[]
["Einnahmen:",{"$f":"Jan!$E$2","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B34:M34)","v":0}]
[]
["Ausgaben:",{"$f":"SUM(B4:B31)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B36:M36)","v":0}]
[]
["Quartal :",{"$f":"SUM(B36:D36)","v":0},null,null,{"$f":"SUM(E36:G36)","v":0},null,null,{"$f":"SUM(H36:J37)","v":0},null,null,{"$f":"SUM(K36:M36)","v":0}]