{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Weihnachtsbudget","Listeneintrag","Listeninfo"],"not_rendered":{"charts":1,"images":3,"defined_names":13,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Weihnachtsbudget","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"merged":[[0,1,1,3],[0,4,1,4],[2,1,2,2],[13,4,19,4]]}
[null,"Budget für Weihnachtseinkäufe",null,null,"In dieser Zelle befindet sich eine Lichterkette.","ZU \"LISTENEINTRAG\" >"]
[{"$nulls":5},"ZU \"LISTENINFO\" >"]
[null,"SUMMEN",null,"In dieser Zelle befindet sich ein gruppiertes Balkendiagramm, das die Kostenzuteilung und die bis zum aktuellen Datum ausgegebene Gesamtsumme darstellt."]
[null,"KOSTENZUTEILUNG",{"$f":"SUM(Geschenkdaten[KOSTEN])","v":{"v":377,"d":"377.00 €"}}]
[null,"BIS HEUTE AUSGEGEBEN",{"$f":"SUMIF(Geschenkdaten[GEKAUFT],\"Gekauft\",Geschenkdaten[KOSTEN])","v":{"v":233,"d":"233.00 €"}}]
[null,"DIFFERENZ",{"$f":"C4-C5","v":{"v":144,"d":"144.00 €"}}]
[null,"Um den Bericht unten zu aktualisieren, aktualisieren Sie ihn.",null,null,"In dieser Zelle befindet sich ein Datenschnitt zum Filtern der Tabellendaten nach dem Verpackungsstatus.","In dieser Zelle befindet sich ein Datenschnitt zum Filtern der Tabellendaten nach \"Gekauft\"."]
[null,"AUFSCHLÜSSELUNG",null,"In dieser Zelle befindet sich ein Datenschnitt zum Filtern der Tabellendaten nach \"Für\"."]
[null,null,"Geschenkkosten"]
[null,"Name 3",{"v":71,"d":"71.00 €"}]
[null,"Gekauft"]
[null,"Puzzle",{"v":16,"d":"16.00 €"}]
[null,"Spielzeugeisenbahn",{"v":26,"d":"26.00 €"}]
[null,"Nicht gekauft",null,null,"In dieser Zelle befindet sich ein Datenschnitt zum Filtern der Tabellendaten nach dem Lieferstatus.","In dieser Zelle befindet sich ein Datenschnitt zum Filtern der Tabellendaten nach der Geschenkkategorie."]
[null,"Fahrrad",{"v":29,"d":"29.00 €"}]
[]
[null,"Name 2",{"v":59,"d":"59.00 €"}]
[null,"Gekauft"]
[null,"Puppenhaus",{"v":36,"d":"36.00 €"}]
[null,"Socken",{"v":23,"d":"23.00 €"}]
[]
[null,"Name 4",{"v":44,"d":"44.00 €"}]
[null,"Gekauft"]
[null,"Fotoalbum",{"v":30,"d":"30.00 €"}]
[null,"Materialien für das Sammelalbum",{"v":14,"d":"14.00 €"}]
[]
[null,"Name 5",{"v":118,"d":"118.00 €"}]
[null,"Gekauft"]
[null,"Xbox-Spiel",{"v":49,"d":"49.00 €"}]
[null,"Nicht gekauft"]
[null,"Geschenkkarte",{"v":32,"d":"32.00 €"}]
[null,"Hemd",{"v":37,"d":"37.00 €"}]
[]
[null,"Name 1",{"v":39,"d":"39.00 €"}]
[null,"Gekauft"]
[null,"Sweatshirt",{"v":39,"d":"39.00 €"}]
[]
[null,"Name 6",{"v":46,"d":"46.00 €"}]
[null,"Nicht gekauft"]
[null,"Socken",{"v":46,"d":"46.00 €"}]
[]
[null,"Grand Total",{"v":377,"d":"377.00 €"}]

{"sheet":"Listeneintrag","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,1,1,2],[0,3,1,6]]}
[null,"Einkaufsliste",null,"In dieser Zelle befindet sich eine Lichterkette.",{"$nulls":3},"ZU \"LISTENINFO\" >"]
[{"$nulls":7},"< ZU \"WEIHNACHTSBUDGET\""]
[null,"FÜR","GESCHENKKATEGORIE","GESCHENK","KOSTEN","GEKAUFT","LIEFERSTATUS","VERPACKUNGSSTATUS"]
[null,"Name 3","Geschenk von der Familie","Spielzeugeisenbahn",{"v":26,"d":"26.00 €"},"Gekauft","Angekommen","Verpackt"]
[null,"Name 2","Allgemeines Geschenk","Socken",{"v":23,"d":"23.00 €"},"Gekauft","Angekommen","Verpackt"]
[null,"Name 3","Allgemeines Geschenk","Puzzle",{"v":16,"d":"16.00 €"},"Gekauft","Angekommen","Unverpackt"]
[null,"Name 4","Allgemeines Geschenk","Materialien für das Sammelalbum",{"v":14,"d":"14.00 €"},"Gekauft","Unterwegs","Unverpackt"]
[null,"Name 5","Allgemeines Geschenk","Xbox-Spiel",{"v":49,"d":"49.00 €"},"Gekauft","Unterwegs","Unverpackt"]
[null,"Name 5","Allgemeines Geschenk","Hemd",{"v":37,"d":"37.00 €"},"Nicht gekauft","Unterwegs","Unverpackt"]
[null,"Name 1","Allgemeines Geschenk","Sweatshirt",{"v":39,"d":"39.00 €"},"Gekauft","Unterwegs","Unverpackt"]
[null,"Name 2","Allgemeines Geschenk","Puppenhaus",{"v":36,"d":"36.00 €"},"Gekauft","Angekommen","Unverpackt"]
[null,"Name 3","Allgemeines Geschenk","Fahrrad",{"v":29,"d":"29.00 €"},"Nicht gekauft"]
[null,"Name 4","Allgemeines Geschenk","Fotoalbum",{"v":30,"d":"30.00 €"},"Gekauft","Angekommen"]
[null,"Name 5","Allgemeines Geschenk","Geschenkkarte",{"v":32,"d":"32.00 €"},"Nicht gekauft"]
[null,"Name 6","Allgemeines Geschenk","Socken",{"v":46,"d":"46.00 €"},"Nicht gekauft"]

{"sheet":"Listeninfo","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,1,1,1],[0,2,1,3]]}
[null,"Listeninfo","In dieser Zelle befindet sich eine Lichterkette.",null,"< ZU \"LISTENEINTRAG\""]
[{"$nulls":4},"< ZU \"WEIHNACHTSBUDGET\""]
[null,"PERSONEN",null,"GESCHENKKATEGORIEN"]
[null,"Name 1",null,"Für Nikolausstiefel"]
[null,"Name 2",null,"Allgemeines Geschenk"]
[null,"Name 3",null,"Geschenk von Ehepartner"]
[null,"Name 4",null,"Geschenk von der Familie"]
[null,"Name 5",null,"Besonderes Geschenk"]
[null,"Name 6"]