{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Kassa 2022","Kassa Test","Analyse","Val","Color"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":1,"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":"Kassa 2022","index":0,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["t","Kassa 2023",0,"Saldo",null,"Menü öffnen",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Erkärung zu Zellen mit Funktion"]
["Datum","Buchungstext","Betrag","Kategorie",null,"Kategoriename","Kategorie","Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez",null," linker Mausklick [F1] = Menü öffnen"]
[null,null,null,null,null,"Ausbildung",0,0,0,0,0,0,0,0,0,0,0,0,0,null," linker Mausklick = Einnahmen korrigieren"]
[null,null,null,null,null,"Einkommen",0,0,0,0,0,0,0,0,0,0,0,0,0,null," linker Mausklick = Ausgaben korrigieren"]
[null,null,null,null,null,"Essen",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"linker Mausklick = neue Buchunge eintragen"]
[null,null,null,null,null,"Freizeit",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"alle übrigen Zellen haben keine Funktion"]
[null,null,null,null,null,"Kommunikation",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Immobilien",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Mobilien",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"NonFood",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Pflege",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Spenden",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Steuern / Abgaben",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Verkehr",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Vermögen",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Versicherungen",0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Kassa Test","index":1,"n_rows":19,"n_cols":21,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Kassa Test",3203.899658203125,"Saldo",null,"Menü öffnen",9810.4990234375,0,0,0,0,2131.099853515625,0,2448.60009765625,0,0,0,0,0,null,"Erkärung zu Zellen mit Funktion"]
["Datum","Buchungstext","Betrag","Kategorie",null,"Kategoriename","Kategorie","Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez",null," linker Mausklick [F1] = Menü öffnen"]
["01.05.2022","Lohn Frau",1800,"Einkommen",null,"Ausbildung",-145,0,0,0,0,0,0,-145,0,0,0,0,0,null," linker Mausklick = Einnahmen korrigieren"]
["02.05.2022","Kosmetik",-54.700000762939453,"Pflege",null,"Einkommen",6895,0,0,0,0,5400,0,1495,0,0,0,0,0,null," linker Mausklick = Ausgaben korrigieren"]
["06.05.2022","Lohn Mann",3600,"Einkommen",null,"Essen",-288.39999389648438,0,0,0,0,-169.19999694824219,0,-119.19999694824219,0,0,0,0,0,null,"linker Mausklick = neue Buchunge eintragen"]
["09.05.2022","Krankenkasse Mann",-820,"Versicherungen",null,"Einkommen",6895,0,0,0,0,0,0,1495,0,0,0,0,0,null,"alle übrigen Zellen haben keine Funktion"]
["10.05.2022","Auto allg",-240,"Verkehr",null,"Essen",-288.39999389648438,0,0,0,0,0,0,-119.19999694824219,0,0,0,0,0]
["10.05.2022","Migros",-95,"Essen",null,"Freizeit",-45,0,0,0,0,0,0,-45,0,0,0,0,0]
["12.05.2022","Migros",-74.199996948242188,"Essen",null,"Kommunikation",0,0,0,0,0,0,0,0,0,0,0,0,0]
["13.05.2022","Miete",-1340,"Immobilien",null,"Immobilien",-1340,0,0,0,0,-1340,0,0,0,0,0,0,0]
["14.05.2022","Krankenkasse Frau",-645,"Versicherungen",null,"Mobilien",-90,0,0,0,0,0,0,-90,0,0,0,0,0]
["11.07.2022","COOP NonFood",-23,"NonFood",null,"NonFood",-23,0,0,0,0,0,0,-23,0,0,0,0,0]
["11.07.2022","Losgewinn",45,"Einkommen",null,"Pflege",-54.700000762939453,0,0,0,0,-54.700000762939453,0,0,0,0,0,0,0]
["11.07.2022","Migros",-56,"Essen",null,"Spenden",0,0,0,0,0,0,0,0,0,0,0,0,0]
["11.07.2022","Rente Frau",1450,"Einkommen",null,"Steuern / Abgaben",0,0,0,0,0,0,0,0,0,0,0,0,0]
["12.07.2022","Fest",-45,"Freizeit",null,"Verkehr",-240,0,0,0,0,-240,0,0,0,0,0,0,0]
["13.07.2022","Lidl",-63.200000762939453,"Essen",null,"Vermögen",0,0,0,0,0,0,0,0,0,0,0,0,0]
["13.07.2022","Ausbildung",-145,"Ausbildung",null,"Versicherungen",-1465,0,0,0,0,-1465,0,0,0,0,0,0,0]
["13.07.2022","Möbel",-90,"Mobilien"]

{"sheet":"Analyse","index":2,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["t","Kassa 2022",1800,"Summe"]
[]
["Datum","Buchungstext","Betrag","Kategorie"]
["01.05.2022","Lohn Frau",1800,"Einkommen"]

{"sheet":"Val","index":3,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
["Buchungstext","Kategorie","Werte ","Kat"]
["Aldi","Essen","False","Ausbildung","Schule / Kurse / Studium"]
["Aldi Nonfood","NonFood","lemrum.4953","Einkommen","Lohn / Renten / Bohni / Nebeneinkommen / Gewinnw /  Spesenentschädigung / Zinse"]
["Ausbildung","Ausbildung","Bedienanl_KassaBu","Essen","Getränke / Speisen / Notvorrat / Gastroausgaben"]
["Auto allg","Verkehr","De","Freizeit","Ferien / Vereine / Sport / Taschengeld / Feste / Glücksspiele"]
["Benzin","Verkehr",2,"Immobilien","Haus / Wohnung / Grundstücke / Mietobjekte / Betriebkosten"]
["COOP","Essen",4,"Kommunikation","Komputer / Tel / Handy / Fernsehen / Zeitungen"]
["COOP NonFood","NonFood",null,"Mobilien","Mobile Geräte, Maschinen, Werkzeuge, Möbel"]
["Fest","Freizeit",null,"NonFood","Kleider / Verbrauchsartikel / Wassr / Strom"]
["Flugticket","Verkehr",null,"Pflege","Medizin / Kosmetik / Spital / Spitex / Arzt"]
["Heizöl","Immobilien",null,"Spenden","Wohltätikeit / Vereine / Nothilfe / Parteien / Private"]
["Hypothek","Immobilien",null,"Steuern / Abgaben","Bund / Staat / Gemeinde / Umweltabgaben"]
["Kleider","NonFood",null,"Verkehr"," Fahrzeuge / Bahnticket / Flugticket / Taxi / Reisespesen / Treibstoffe"]
["Kosmetik","Pflege",null,"Vermögen","Konten / Aktien / Obligationen / Wertgegenstände: Schmuck, Bilder, Edelmetalle"]
["Krankenkasse Frau","Versicherungen",null,"Versicherungen","Krankenkasse / Auto / Gebäude: Elementar, Feuer, Wasser / Sozialversicherung"]
["Krankenkasse Mann","Versicherungen"]
["Küchengeräte","Mobilien","murmel"]
["Lidl","Essen","E:\\AA_Excel\\AE_KassaBU\\Texte\\Bedienanl_KassaBu.pdf"]
["Lohn Frau","Einkommen"]
["Lohn Mann","Einkommen"]
["Losgewinn","Einkommen"]
["Lotto","Freizeit"]
["Miete","Immobilien"]
["Migros","Essen"]
["Möbel","Mobilien"]
["Musikkurs","Freizeit"]
["Nebeneinkommen","Einkommen"]
["Neuer Buchungstext","Pflege"]
["Quatsch","Quatsch"]
["Reise","Verkehr"]
["Rente Frau","Einkommen"]
["Rente Mann","Einkommen"]
["Rückvergütung KK","Einkommen"]
["Rudern","Freizeit"]
["Schuhe","NonFood"]
["Spende","Spenden"]
["Steueren Kanton","Steuern / Abgaben"]
["Tageskarte Brienzersee","Verkehr"]
["Taschengeld","Freizeit"]
["Telefon","Kommunikation"]
["Theater","Freizeit"]
["Treibstoff","Verkehr"]
["Turnverein","Freizeit"]
["Zinsertrag","Immobilien"]
["Zusatzkasse","Pflege"]

{"sheet":"Color","index":4,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["Farbname","FarbHex# (RGB)","FarbHex&H (BGR)","FarbRGB","FarbeLong",null,15849925,null,"&HF1C5D9","#C5D9F1"]
["White","#FFFFFF","&HFFFFFF","RGB(255, 255, 255)",16777215]
["Whitesmoke","#F5F5F5","&HF5F5F5","RGB(245,245,245)",16119285]
["Gainsboro","#DCDCDC","&HDCDCDC ","RGB(220,220,229) ",14474460]
["Silver ","#C0C0C0","&HC0C0C0","RGB(192, 192, 192)",12632256]
["Almond","#EFDECD","&HEFDECD","RGB(239,222,205)",13491951]
["Yellow ","#FFFF00","&H00FFFF","RGB(255,255,000)",65535]
["Ivory","#FFFFF0","&HE0FFFF","RGB(255, 255, 240)",15794175]
["Cornsilk","#FFF8E5","&HDCF8FF","RGB(255,248,220)",15071487]
["Khaki","#F0E68C","&H8CE6F0","RGB(240,230,140)",9234160]
["Coldenrod","#EEE86B","&HAAE8EE","RGB(238,232,107)",7071982]
["Bisque","#FFE4C4","&HC4E4FF","RGB(255, 228, 196)",12903679]
["Gold","#FFD700","&H00D7FF","RGB(255,215,000)",55295]
["Green","#00FF00","&H00FF00","RGB(000,255,000)",65280]
["Chartreuse","#7FFF00","&H00FF7F","RGB(127,255,0",65407]
["Greenyellow","#ADFF2F","&H2FFFAD","RGB(173,255,47)",3145645]
["Light Green","#90EE90","&H33FF99","RGB(144,238,144)",9498256]
["Springgreen","#00FF7F","&H7FFF00","RGB(0, 255, 127)",8388352]
["LightSeagreen","#85FFD3","&HD3FF85","RGB(133, 255, 211)",13893509]
["Pale Green","#98FB98","&H98FB98","RGB(152,251,152)",10025880]
["Paleturqoise","#AFEEEE","&HEEEEAF","RGB(175,238,238)",15658671]
["Aquamarin","#7FFFD4","&HD4FF7F","RGB(127, 255, 212)",13959039]
["Blue","#0000FF","&HFF0000","RGB(0,0255",16711680]
["Powderblue","#B0E0E6","&HE6E0B0","RGB(176,224,230)",15130800]
["Light Blue","#ADD8E6","&HEED7BD","RGB(173,216,230)",15128749]
["SteelBlue","#B0C4DE","&HFFCCCC","RGB(176, 196, 222)",14599344]
["Pale Blue","#99CCFF","&HFFCC99","RGB(153, 204, 255)",16764057]
["LightSkyblue","#87CEFA","&HFF9999","RGB(135, 206, 250)",16436871]
["Control","#0078D7","&HD77800","RGB(000,120,215)",14120960]
["Dodgerblue","#1E90FF","&HCC6600","RGB(030,144,255)",16748574]
["Cornflower","#6495ED","&HED9564","RGB(100,149,237)",15570276]
["Royalblue","#4169E1","&HE16841","RGB(65,105,225",14772545]
["Bronce","#FFD966","&H66D9FF","RGB(255,217,102)",13082801]
["Lavender","#E6E6FA","&HFF99CC","RBG(230, 230, 250)",16443110]
["Cyan","#00FFFF","&HFFFF00","RGB(000, 255, 255)",16776960]
["Light Cyan","#CCFFFF","&HFFFFCC","RGB(204, 255, 255)",16777164]
["Aqua","#33CCCC","&HCCCC33","RGB(51,204,204)",13421619]
["Teal","#008080","&H808000","RGB(0,128,128)",8421376]
["Tan","#D2B48C","&H8CB4D2","RGB(210, 180, 140)",9221330]
["Red","#FF0000","&H0000FF","RGB(255,0,0)",255]
["Tomato","#FF0047","&H4763FF","RGB(255,99,71)",4676351]
["Purpur","#DC143C","&H3C14DC","RGB(220,20,60",3937500]
["Mangenta","#FF00FF","&HFF00FF","RGB(255,000 255)",16711935]
["Hotpink","#FF69B4","&HB469FF","RGB(255,105,180",11823615]
["Rose","#FF99CC","&HCC99FF","RGB(255, 153, 204)",13408767]
["LightPink","#FFB6C1","&HC1B6FF","RGB(255,182,193)",12695295]
["MistyRose","#FFE4E1","&HE1E4FF","RGB(255,228,225)",14804223]
["Oragne","#FF6600","&H0066FF","RGB(255, 204, 153)",26367]
["Coral","#FF7F50","&H7AA0FF","RGB(255, 127, 80)",5275647]
["Peru","#FF9900","&H0099FF","RGB(255,153,0)",39423]
["LightSalmon","#FFA000","&HA7A9FF","RGB(255,160,122)",8036607]
["Orchid","#DA70D6","&HD670DA","RGB(218,112,214)",14053594]
["Plum","#DDA0DD","&HDDA0DD","RGB(221,160,221)",14524637]
["Thistle","#D8BFD8","&HD8BFD8","RGB(216,191,216)",14204888]
["Rot Akz 2","#E6B8B8","&HB8B8E6","RGB(230,184,184)",12105958]
["NavajoWhite","#FFDEAD","&HADDEFF","RGB(255,222,173)",11394815]
["Wheat","#F5DEB3","&HB3DEF5","RGB(245,222,179)",11788021]
["Menue","#C5D9F1","&HF1C5D9","RGB(197,217,241)",15849925]