{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Zu- oder Absage-Tracker","Zu- oder Absage-Übersicht"],"not_rendered":{"charts":2,"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"Zu- oder Absage-Tracker","index":0,"n_rows":15,"n_cols":15,"rows_kept":15,"merged":[[0,3,0,4],[0,5,0,7]]}
[{"$nulls":5},"ZU-/ABSAGE-ÜBERSICHT"]
[null,"HOCHZEITSDATUM",null,"Hochzeitseinladungstracker"]
[null,{"$f":"TODAY()+283","v":"2023-05-13"},null,"NAME DES GASTS","ABGESCHICKT?","ZU-/ABSAGE","ANZAHL","GAST","BEZIEHUNG","ADRESSE","ORT","BUNDESLAND","PLZ","TELEFON","KONTAKT-E-MAIL-ADRESSE"]
[null,"VERBLEIBENDE TAGE",null,"Name 1","Ja","Ja",1,"Verlobter 1","Bruder","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[null,{"$f":"VerbleibendeTage","v":283},null,"Name 2","Ja","Nein",3,"Verlobter 1","Freund","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[null,"ZUSAGE",null,"Name 3","Ja","Ja",1,"Sonstige","Freund","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[null,{"$f":"GesamtzahlZusagen","v":12},null,"Name 4","Ja","Nein",2,"Verlobter 2","Freund","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[null,"ABSAGE",null,"Name 5","Ja","Ja",2,"Verlobter 2","Freund","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[null,{"$f":"GesamtzahlAbsagen","v":6},null,"Name 6","Ja","Mit Vorbehalt",null,"Sonstige","Freund","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[null,"AUSSTEHEND",null,"Name 7","Ja","Ja",2,"Verlobter 2","Freund","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[null,{"$f":"AusstehendeZuoderAbsage","v":1},null,"Name 8","Ja","Nein",1,"Sonstige","Freund","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[{"$nulls":3},"Name 9","Ja","Ja",4,"Verlobter 1","Freund","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[{"$nulls":3},"Name 10","Ja","Ja",2,"Verlobter 1","Freund","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[{"$nulls":3},"Name 11","Ja",null,null,"Verlobter 2","Bruder","Adresse","Ort","Bundesland","PLZ","Telefon","jemand@example.com"]
[{"$nulls":3},"GESAMT:",{"$f":"COUNTIF('Zu- oder Absage-Tracker'!$E$4:$E$14,\"Ja\")","v":11},{"$f":"COUNTA('Zu- oder Absage-Tracker'!$F$4:$F$14)","v":10},{"$f":"SUBTOTAL(109,tblInvites[ANZAHL])","v":18}]

{"sheet":"Zu- oder Absage-Übersicht","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"merged":[[0,3,0,4],[0,5,0,8],[2,3,6,3],[2,4,6,4],[7,3,11,3],[7,4,11,4]]}
[{"$nulls":3},"ZU-/ABSAGE-TRACKER"]
[null,"HOCHZEITSDATUM",null,"Zu- oder Absage-Übersicht",{"$nulls":10},"Anmerkungen"]
[null,{"$f":"Hochzeitsdatum","v":"2023-05-13"},null,"JA","Diese Zelle enthält ein gruppiertes Balkendiagramm für Gäste mit \"Ja\" für Zu-/Absage."]
[null,"VERBLEIBENDE TAGE",{"$nulls":3},"SONSTIGE",{"$f":"IFERROR(SUMIFS(tblInvites[ANZAHL],tblInvites[GAST],\"=Sonstige\",tblInvites[ZU-/ABSAGE],\"Ja\"),0)","v":1},{"$f":"tblInvites[[#Totals],[ABGESCHICKT?]]","v":11}]
[null,{"$f":"VerbleibendeTage","v":283},{"$nulls":3},"VERLOBTER 2",{"$f":"IFERROR(SUMIFS(tblInvites[ANZAHL],tblInvites[GAST],\"=Verlobter 2\",tblInvites[ZU-/ABSAGE],\"Ja\"),0)","v":4},{"$f":"tblInvites[[#Totals],[ABGESCHICKT?]]","v":11}]
[null,"ZUSAGE",{"$nulls":3},"VERLOBTER 1",{"$f":"IFERROR(SUMIFS(tblInvites[ANZAHL],tblInvites[GAST],\"=Verlobter 1\",tblInvites[ZU-/ABSAGE],\"Ja\"),0)","v":7},{"$f":"tblInvites[[#Totals],[ABGESCHICKT?]]","v":11}]
[null,{"$f":"GesamtzahlZusagen","v":12}]
[null,"ABSAGE",null,"NEIN","Diese Zelle enthält ein gruppiertes Balkendiagramm für Gäste mit \"Nein\" für Zu-/Absage."]
[null,{"$f":"GesamtzahlAbsagen","v":6},{"$nulls":3},"SONSTIGE",{"$f":"IFERROR(SUMIFS(tblInvites[ANZAHL],tblInvites[GAST],\"=Sonstige\",tblInvites[ZU-/ABSAGE],\"Nein\"),0)","v":1},{"$f":"tblInvites[[#Totals],[ABGESCHICKT?]]","v":11}]
[null,"AUSSTEHEND",{"$nulls":3},"VERLOBTER 2",{"$f":"IFERROR(SUMIFS(tblInvites[ANZAHL],tblInvites[GAST],\"=Verlobter 2\",tblInvites[ZU-/ABSAGE],\"Nein\"),0)","v":2},{"$f":"tblInvites[[#Totals],[ABGESCHICKT?]]","v":11}]
[null,{"$f":"AusstehendeZuoderAbsage","v":1},{"$nulls":3},"VERLOBTER 1",{"$f":"IFERROR(SUMIFS(tblInvites[ANZAHL],tblInvites[GAST],\"=Verlobter 1\",tblInvites[ZU-/ABSAGE],\"Nein\"),0)","v":3},{"$f":"tblInvites[[#Totals],[ABGESCHICKT?]]","v":11}]