{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["HHR bankzeit.de","HHRRechner"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":2,"defined_names":8,"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":"HHR bankzeit.de","index":0,"n_rows":34,"n_cols":40,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,0,3,9],[10,0,33,0],[14,3,33,35],[31,39,32,53]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Vielen Dank für die Nutzung dieses selbst \"gebauten\" Haushaltsrechners.\n\nZur Anwendung:\nMan gibt in die linke Tabelle seine detaillierten Einnahmen und Ausgaben in die dafür vorgesehenen Felder ein. Dabei können die einzelnen vorbeschrifteten Positionen und auch der Zahlungsmodus (siehe Zeichenerklärung) überschrieben werden. Es werden Summen für die einzelnen Bereiche gebildet und die Gesamtsummen von Einkommen und Ausgaben gegenübergestellt.\nAlle eingegebenen Werte werden in die rechte Tabelle übernommen, die als Modellrechnung dienen kann. Während die „Beschriftungen“ dort nicht veränderbar sind, können mit den Werten für Einkommen und Ausgaben Veränderungen simuliert und die Auswirkungen auf das frei verfügbare Einkommen betrachtet werden. Ein Klick auf den RESET-Button setzt alles wieder auf Standardwerte ohne Zahlen zurück.\n\nTrotz jahrzehntelanger Erfahrung und größtmöglicher Sorgfalt, kann bei diesem kleinen kosten- und werbefreien Tool natürlich keinerlei Haftung für Vollständigkeit, Richtigkeit, Fehlerfreiheit und Aktualität übernommen werden."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 1.0"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand: März 2021  | www.bankzeit.de | info@bankzeit.de"]

{"sheet":"HHRRechner","index":1,"n_rows":66,"n_cols":16,"rows_kept":66,"cut":false,"hidden":false,"merged":[[62,9,62,13],[62,14,65,14],[63,10,63,11],[64,10,64,11],[65,10,65,11],[52,9,52,13],[52,14,58,14],[53,10,53,11],[54,10,54,11],[55,10,55,11],[56,10,56,11],[57,10,57,11],[58,10,58,11],[59,9,59,13],[59,14,61,14],[60,10,60,11],[61,10,61,11],[43,9,43,13],[43,14,51,14],[44,10,44,11],[45,10,45,11],[46,10,46,11],[47,10,47,11],[48,10,48,11],[49,10,49,11],[50,10,50,11],[51,10,51,11],[20,10,20,11],[21,10,21,11],[22,10,22,11],[23,10,23,11],[28,10,28,11],[29,10,29,11],[40,9,40,13],[40,14,42,14],[41,10,41,11],[42,10,42,11],[10,9,11,13],[12,9,12,13],[12,14,18,14],[13,10,13,11],[14,10,14,11],[15,10,15,11],[16,10,16,11],[17,10,17,11],[18,10,18,11],[1,9,2,13],[3,9,3,13],[4,9,5,13],[5,14,9,14],[6,10,6,11],[7,10,7,11],[8,10,8,11],[9,10,9,11],[60,2,60,3],[1,1,2,5],[3,1,3,5],[9,2,9,3],[14,2,14,3],[17,2,17,3],[18,2,18,3],[16,2,16,3],[15,2,15,3],[5,6,9,6],[6,2,6,3],[7,2,7,3],[8,2,8,3],[4,1,5,5],[10,1,11,5],[12,6,18,6],[12,1,12,5],[43,1,43,5],[28,2,28,3],[58,2,58,3],[57,2,57,3],[41,2,41,3],[42,2,42,3],[50,2,50,3],[49,2,49,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[29,2,29,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[52,1,52,5],[51,2,51,3],[62,6,65,6],[35,1,35,5],[40,1,40,5],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[62,1,62,5],[40,6,42,6],[63,2,63,3],[59,1,59,5],[64,2,64,3],[65,2,65,3],[52,6,58,6],[43,6,51,6],[61,2,61,3],[59,6,61,6],[19,6,29,6],[35,6,39,6],[13,2,13,3],[30,1,30,5],[30,6,34,6],[30,9,30,13],[30,14,34,14],[31,2,31,3],[31,10,31,11],[32,2,32,3],[32,10,32,11],[33,2,33,3],[33,10,33,11],[34,2,34,3],[34,10,34,11],[19,1,19,5],[35,9,35,13],[35,14,39,14],[36,10,36,11],[37,10,37,11],[38,10,38,11],[39,10,39,11],[19,9,19,13],[19,14,29,14]]}
[]
[null,"Haushaltsrechner",null,null,null,null,{"$f":"TODAY()","v":"2021-03-09"},null,null,"Modellrechnung",null,null,null,null,{"$f":"TODAY()+31","v":"2021-04-09"}]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-03-09"},null,null,null,null,null,null,null,{"$f":"TODAY()+31","v":"2021-04-09"}]
[null,{"$f":"IF(OR(G4=\"\",G4=0),\"\",IF(G4>0,\"Noch frei verfügbar: \",\"Unterdeckung !  \"))","v":""},null,null,null,null,{"$f":"IF(G6-G12=0,\"\",G6-G12)","v":""},{"$f":"G6-G12","v":0},null,{"$f":"IF(OR(O4=\"\",O4=0),\"\",IF(O4>0,\"Noch frei verfügbar: \",\"Unterdeckung !  \"))","v":""},null,null,null,null,{"$f":"IF(O6-O12=0,\"\",O6-O12)","v":""},{"$f":"O6-O12","v":0}]
[null,"Einkünfte",null,null,null,null,"Monat",null,null,"Einkünfte",null,null,null,null,"Monat"]
[null,null,null,null,null,null,{"$f":"SUM(B7:B10)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(J7:J10)","v":0}]
[null,{"$f":"IF(E7=\"2M\",F7/2,IF(E7=\"J\",F7/12,IF(E7=\"Vj\",F7/3,IF(E7=\"Hj\",F7/6,IF(E7=\"2j\",F7/24,F7)))))","v":0},"Gehalt",null,"M",null,null,null,null,{"$f":"IF(M7=\"2M\",N7/2,IF(M7=\"J\",N7/12,IF(M7=\"Vj\",N7/3,IF(M7=\"Hj\",N7/6,IF(M7=\"2j\",N7/24,N7)))))","v":0},{"$f":"IF(C7=\"\",\"\",C7)","v":"Gehalt"},null,{"$f":"IF(E7=\"\",\"\",E7)","v":"M"},{"$f":"IF(F7=\"\",0,F7)","v":0}]
[null,0,"Gehalt",null,"M",null,null,null,null,0,{"$f":"IF(C8=\"\",\"\",C8)","v":"Gehalt"},null,{"$f":"IF(E8=\"\",\"\",E8)","v":"M"},{"$f":"IF(F8=\"\",0,F8)","v":0}]
[null,0,"Kindergeld",null,"M",null,null,null,null,0,"Kindergeld",null,"M",{"$f":"IF(F9=\"\",0,F9)","v":0}]
[null,0,null,null,"M",null,null,null,null,0,"",null,"M",{"$f":"IF(F10=\"\",0,F10)","v":0}]
[null,"Ausgaben",null,null,null,null,"Monat",null,null,"Ausgaben",null,null,null,null,"Monat"]
[null,null,null,null,null,null,{"$f":"G13+G20+G31+G36+G41+G44+G53+G63+G60","v":0},null,null,null,null,null,null,null,{"$f":"O13+O20+G31+O36+O41+O44+O53+O63+O60","v":0}]
[null,"Lebenshaltungskosten",null,null,null,null,{"$f":"SUM(B14:B19)","v":0},null,null,"Lebenshaltungskosten",null,null,null,null,{"$f":"SUM(J14:J19)","v":0}]
[null,{"$f":"IF(E14=\"2M\",F14/2,IF(E14=\"J\",F14/12,IF(E14=\"Vj\",F14/3,IF(E14=\"Hj\",F14/6,IF(E14=\"2j\",F14/24,F14)))))","v":0},"Lebensmittel",null,"M",null,null,null,null,{"$f":"IF(M14=\"2M\",N14/2,IF(M14=\"J\",N14/12,IF(M14=\"Vj\",N14/3,IF(M14=\"Hj\",N14/6,IF(M14=\"2j\",N14/24,N14)))))","v":0},{"$f":"IF(C14=\"\",\"\",C14)","v":"Lebensmittel"},null,{"$f":"IF(E14=\"\",\"\",E14)","v":"M"},{"$f":"IF(F14=\"\",0,F14)","v":0}]
[null,{"$f":"IF(E15=\"2M\",F15/2,IF(E15=\"J\",F15/12,IF(E15=\"Vj\",F15/3,IF(E15=\"Hj\",F15/6,IF(E15=\"2j\",F15/24,F15)))))","v":0},"Getränke",null,"M",null,null,null,null,{"$f":"IF(M15=\"2M\",N15/2,IF(M15=\"J\",N15/12,IF(M15=\"Vj\",N15/3,IF(M15=\"Hj\",N15/6,IF(M15=\"2j\",N15/24,N15)))))","v":0},"Getränke",null,"M",{"$f":"IF(F15=\"\",0,F15)","v":0}]
[null,0,"Kleidung",null,"J",null,null,null,null,0,"Kleidung",null,"J",{"$f":"IF(F16=\"\",0,F16)","v":0}]
[null,{"$f":"IF(E17=\"2M\",F17/2,IF(E17=\"J\",F17/12,IF(E17=\"Vj\",F17/3,IF(E17=\"Hj\",F17/6,IF(E17=\"2j\",F17/24,F17)))))","v":0},"Essen gehen",null,"M",null,null,null,null,0,"Essen gehen",null,"M",{"$f":"IF(F17=\"\",0,F17)","v":0}]
[null,0,"Feiern",null,"M",null,null,null,null,0,"Feiern",null,"M",{"$f":"IF(F18=\"\",0,F18)","v":0}]
[null,0,null,null,"M",null,null,null,null,0,"",null,"M",{"$f":"IF(F19=\"\",0,F19)","v":0}]
[null,"Nebenkosten Wohnen",null,null,null,null,{"$f":"SUM(B21:B30)","v":0},null,null,"Nebenkosten Wohnen",null,null,null,null,{"$f":"SUM(J21:J30)","v":0}]
[null,{"$f":"IF(E21=\"2M\",F21/2,IF(E21=\"J\",F21/12,IF(E21=\"Vj\",F21/3,IF(E21=\"Hj\",F21/6,IF(E21=\"2j\",F21/24,F21)))))","v":0},"Miete kalt",null,"M",null,null,null,null,{"$f":"IF(M21=\"2M\",N21/2,IF(M21=\"J\",N21/12,IF(M21=\"Vj\",N21/3,IF(M21=\"Hj\",N21/6,IF(M21=\"2j\",N21/24,N21)))))","v":0},{"$f":"IF(C21=\"\",\"\",C21)","v":"Miete kalt"},null,{"$f":"IF(E21=\"\",\"\",E21)","v":"M"},{"$f":"IF(F21=\"\",0,F21)","v":0}]
[null,0,"Nebenkosten",null,"M",null,null,null,null,0,"Nebenkosten",null,"M",{"$f":"IF(F22=\"\",0,F22)","v":0}]
[null,0,"Strom",null,"M",null,null,null,null,0,"Strom",null,"M",{"$f":"IF(F23=\"\",0,F23)","v":0}]
[null,0,"Gas",null,"M",null,null,null,null,0,"Gas",null,"M",{"$f":"IF(F24=\"\",0,F24)","v":0}]
[null,0,"Wasser/Abwasser",null,"M",null,null,null,null,0,"Wasser/Abwasser",null,"M",{"$f":"IF(F25=\"\",0,F25)","v":0}]
[null,0,"Müllabfuhr",null,"M",null,null,null,null,0,"Müllabfuhr",null,"M",{"$f":"IF(F26=\"\",0,F26)","v":0}]
[null,0,"Schornsteinfeger",null,"J",null,null,null,null,0,"Schornsteinfeger",null,"J",{"$f":"IF(F27=\"\",0,F27)","v":0}]
[null,0,"Grundsteuern",null,"VJ",null,null,null,null,0,"Grundsteuern",null,"VJ",{"$f":"IF(F28=\"\",0,F28)","v":0}]
[null,0,"Gebäudeversicherung",null,"J",null,null,null,null,0,"Gebäudeversicherung",null,"J",{"$f":"IF(F29=\"\",0,F29)","v":0}]
[null,0,"Garten",null,"J",null,null,null,null,0,"Garten",null,"J",{"$f":"IF(F30=\"\",0,F30)","v":0}]
[null,"Kredite",null,null,null,null,{"$f":"SUM(B32:B35)","v":0},null,null,"Kredite",null,null,null,null,{"$f":"SUM(J32:J35)","v":0}]
[null,{"$f":"IF(E32=\"2M\",F32/2,IF(E32=\"J\",F32/12,IF(E32=\"Vj\",F32/3,IF(E32=\"Hj\",F32/6,IF(E32=\"2j\",F32/24,F32)))))","v":0},"Baufinanzierung",null,"M",null,null,null,null,{"$f":"IF(M32=\"2M\",N32/2,IF(M32=\"J\",N32/12,IF(M32=\"Vj\",N32/3,IF(M32=\"Hj\",N32/6,IF(M32=\"2j\",N32/24,N32)))))","v":0},{"$f":"IF(C32=\"\",\"\",C32)","v":"Baufinanzierung"},null,{"$f":"IF(E32=\"\",\"\",E32)","v":"M"},{"$f":"IF(F32=\"\",0,F32)","v":0}]
[null,0,"Baufinanzierung",null,"M",null,null,null,null,0,"Baufinanzierung",null,"M",{"$f":"IF(F33=\"\",0,F33)","v":0}]
[null,0,"Ratenkredit",null,"M",null,null,null,null,0,"Ratenkredit",null,"M",{"$f":"IF(F34=\"\",0,F34)","v":0}]
[null,0,"Ratenkredit",null,"M",null,null,null,null,0,"Ratenkredit",null,"M",{"$f":"IF(F35=\"\",0,F35)","v":0}]
[null,"Auto",null,null,null,null,{"$f":"SUM(B37:B40)","v":0},null,null,"Auto",null,null,null,null,{"$f":"SUM(J37:J40)","v":0}]
[null,{"$f":"IF(E37=\"2M\",F37/2,IF(E37=\"J\",F37/12,IF(E37=\"Vj\",F37/3,IF(E37=\"Hj\",F37/6,IF(E37=\"2j\",F37/24,F37)))))","v":0},"Kfz-Versicherung",null,"J",null,null,null,null,{"$f":"IF(M37=\"2M\",N37/2,IF(M37=\"J\",N37/12,IF(M37=\"Vj\",N37/3,IF(M37=\"Hj\",N37/6,IF(M37=\"2j\",N37/24,N37)))))","v":0},{"$f":"IF(C37=\"\",\"\",C37)","v":"Kfz-Versicherung"},null,{"$f":"IF(E37=\"\",\"\",E37)","v":"J"},{"$f":"IF(F37=\"\",0,F37)","v":0}]
[null,0,"Kfz-Steuer",null,"J",null,null,null,null,0,"Kfz-Steuer",null,"J",{"$f":"IF(F38=\"\",0,F38)","v":0}]
[null,0,"Inspektion Reparatur",null,"J",null,null,null,null,0,"Inspektion Reparatur",null,"J",{"$f":"IF(F39=\"\",0,F39)","v":0}]
[null,0,"Tanken",null,"M",null,null,null,null,0,"Tanken",null,"M",{"$f":"IF(F40=\"\",0,F40)","v":0}]
[null,"ÖPNV",null,null,null,null,{"$f":"SUM(B42:B43)","v":0},null,null,"ÖPNV",null,null,null,null,{"$f":"SUM(J42:J43)","v":0}]
[null,0,"Fahrkarte",null,"M",null,null,null,null,{"$f":"IF(M42=\"2M\",N42/2,IF(M42=\"J\",N42/12,IF(M42=\"Vj\",N42/3,IF(M42=\"Hj\",N42/6,IF(M42=\"2j\",N42/24,N42)))))","v":0},{"$f":"IF(C42=\"\",\"\",C42)","v":"Fahrkarte"},null,{"$f":"IF(E42=\"\",\"\",E42)","v":"M"},{"$f":"IF(F42=\"\",0,F42)","v":0}]
[null,0,null,null,"M",null,null,null,null,0,"",null,"M",{"$f":"IF(F43=\"\",0,F43)","v":0}]
[null,"Kommunikation",null,null,null,null,{"$f":"SUM(B45:B52)","v":0},null,null,"Kommunikation",null,null,null,null,{"$f":"SUM(J45:J52)","v":0}]
[null,{"$f":"IF(E45=\"2M\",F45/2,IF(E45=\"J\",F45/12,IF(E45=\"Vj\",F45/3,IF(E45=\"Hj\",F45/6,IF(E45=\"2j\",F45/24,F45)))))","v":0},"Telefon Internet",null,"M",null,null,null,null,{"$f":"IF(M45=\"2M\",N45/2,IF(M45=\"J\",N45/12,IF(M45=\"Vj\",N45/3,IF(M45=\"Hj\",N45/6,IF(M45=\"2j\",N45/24,N45)))))","v":0},{"$f":"IF(C45=\"\",\"\",C45)","v":"Telefon Internet"},null,{"$f":"IF(E45=\"\",\"\",E45)","v":"M"},{"$f":"IF(F45=\"\",0,F45)","v":0}]
[null,0,"Handy",null,"M",null,null,null,null,0,"Handy",null,"M",{"$f":"IF(F46=\"\",0,F46)","v":0}]
[null,0,"Streaming Spiele",null,"M",null,null,null,null,0,"Streaming Spiele",null,"M",{"$f":"IF(F47=\"\",0,F47)","v":0}]
[null,0,"Rundfunkgebühren",null,"VJ",null,null,null,null,0,"Rundfunkgebühren",null,"VJ",{"$f":"IF(F48=\"\",0,F48)","v":0}]
[null,0,"Zeitung papierhaft digital",null,"M",null,null,null,null,0,"Zeitung papierhaft digital",null,"M",{"$f":"IF(F49=\"\",0,F49)","v":0}]
[null,0,"Bücher / Hörbuch",null,"J",null,null,null,null,0,"Bücher / Hörbuch",null,"J",{"$f":"IF(F50=\"\",0,F50)","v":0}]
[null,0,"Zeitschriften",null,"M",null,null,null,null,0,"Zeitschriften",null,"M",{"$f":"IF(F51=\"\",0,F51)","v":0}]
[null,0,null,null,"M",null,null,null,null,0,"",null,"M",{"$f":"IF(F52=\"\",0,F52)","v":0}]
[null,"Versicherungen   ",null,null,null,null,{"$f":"SUM(B54:B59)","v":0},null,null,"Versicherungen   ",null,null,null,null,{"$f":"SUM(J54:J59)","v":0}]
[null,{"$f":"IF(E54=\"2M\",F54/2,IF(E54=\"J\",F54/12,IF(E54=\"Vj\",F54/3,IF(E54=\"Hj\",F54/6,IF(E54=\"2j\",F54/24,F54)))))","v":0},"Privathaftpflichtvers.",null,"J",null,null,null,null,{"$f":"IF(M54=\"2M\",N54/2,IF(M54=\"J\",N54/12,IF(M54=\"Vj\",N54/3,IF(M54=\"Hj\",N54/6,IF(M54=\"2j\",N54/24,N54)))))","v":0},{"$f":"IF(C54=\"\",\"\",C54)","v":"Privathaftpflichtvers."},null,{"$f":"IF(E54=\"\",\"\",E54)","v":"J"},0]
[null,0,"Hausratversicherung",null,"J",null,null,null,null,0,"Hausratversicherung",null,"J",0]
[null,0,"Rechtsschutzversicherung",null,"J",null,null,null,null,0,"Rechtsschutzversicherung",null,"J",0]
[null,0,"Berufsunfähigkeitsvers.",null,"M",null,null,null,null,0,"Berufsunfähigkeitsvers.",null,"M",0]
[null,0,"Tierhaftpflichtversicherung",null,"J",null,null,null,null,0,"Tierhaftpflichtversicherung",null,"J",0]
[null,0,null,null,"M",null,null,null,null,0,"",null,"M",0]
[null,"Urlaub Reisen ",null,null,null,null,{"$f":"SUM(B61:B62)","v":0},null,null,"Urlaub Reisen ",null,null,null,null,{"$f":"SUM(J61:J62)","v":0}]
[null,{"$f":"IF(E61=\"2M\",F61/2,IF(E61=\"J\",F61/12,IF(E61=\"Vj\",F61/3,IF(E61=\"Hj\",F61/6,IF(E61=\"2j\",F61/24,F61)))))","v":0},"Urlaubsreisen",null,"J",null,null,null,null,{"$f":"IF(M61=\"2M\",N61/2,IF(M61=\"J\",N61/12,IF(M61=\"Vj\",N61/3,IF(M61=\"Hj\",N61/6,IF(M61=\"2j\",N61/24,N61)))))","v":0},{"$f":"IF(C61=\"\",\"\",C61)","v":"Urlaubsreisen"},null,{"$f":"IF(E61=\"\",\"\",E61)","v":"J"},{"$f":"IF(F61=\"\",0,F61)","v":0}]
[null,0,"Kurztripps",null,"M",null,null,null,null,0,"Kurztripps",null,"M",{"$f":"IF(F62=\"\",0,F62)","v":0}]
[null,"Sparen | Sonstiges",null,null,null,null,{"$f":"SUM(B64:B66)","v":0},null,null,"Sparen | Sonstiges",null,null,null,null,{"$f":"SUM(J64:J66)","v":0}]
[null,{"$f":"IF(E64=\"2M\",F64/2,IF(E64=\"J\",F64/12,IF(E64=\"Vj\",F64/3,IF(E64=\"Hj\",F64/6,IF(E64=\"2j\",F64/24,F64)))))","v":0},"Sparkonto",null,"M",null,null,null,null,{"$f":"IF(M64=\"2M\",N64/2,IF(M64=\"J\",N64/12,IF(M64=\"Vj\",N64/3,IF(M64=\"Hj\",N64/6,IF(M64=\"2j\",N64/24,N64)))))","v":0},{"$f":"IF(C64=\"\",\"\",C64)","v":"Sparkonto"},null,{"$f":"IF(E64=\"\",\"\",E64)","v":"M"},{"$f":"IF(F64=\"\",0,F64)","v":0}]
[null,0,"Bausparkonto",null,"M",null,null,null,null,0,"Bausparkonto",null,"M",{"$f":"IF(F65=\"\",0,F65)","v":0}]
[null,0,"Weiterbildung",null,"M",null,null,null,null,0,"Weiterbildung",null,"M",{"$f":"IF(F66=\"\",0,F66)","v":0}]