{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["RSVP-tracker","RSVP-overzicht"],"not_rendered":{"charts":2,"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"RSVP-tracker","index":0,"n_rows":15,"n_cols":15,"rows_kept":15,"merged":[[0,3,0,4],[0,5,0,7]]}
[{"$nulls":5},"RSVP-OVERZICHT"]
[null,"TROUWDATUM",null,"tracker voor bruiloftsuitnodigingen"]
[null,{"$f":"TODAY()+283","v":"2023-05-13"},null,"NAAM VAN GAST","VERZONDEN?","RSVP","AANTAL","GAST","RELATIE","ADRES","PLAATS","PROVINCIE","POSTCODE","TELEFOON","E-MAILADRES CONTACTPERSOON"]
[null,"RESTERENDE DAGEN",null,"Naam 1","Ja","Ja",1,"Partner 1","Broer","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[null,{"$f":"ResterendeDagen","v":283},null,"Naam 2","Ja","Nee",3,"Partner 1","Vriend","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[null,"AANWEZIG",null,"Naam 3","Ja","Ja",1,"Anders","Vriend","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[null,{"$f":"TotaalAanwezig","v":12},null,"Naam 4","Ja","Nee",2,"Partner 2","Vriend","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[null,"NIET AANWEZIG",null,"Naam 5","Ja","Ja",2,"Partner 2","Vriend","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[null,{"$f":"TotaalNietAanwezig","v":6},null,"Naam 6","Ja","Voorlopig",null,"Anders","Vriend","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[null,"OPENSTAAND",null,"Naam 7","Ja","Ja",2,"Partner 2","Vriend","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[null,{"$f":"OpenstaandRSVP","v":1},null,"Naam 8","Ja","Nee",1,"Anders","Vriend","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[{"$nulls":3},"Naam 9","Ja","Ja",4,"Partner 1","Vriend","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[{"$nulls":3},"Naam 10","Ja","Ja",2,"Partner 1","Vriend","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[{"$nulls":3},"Naam 11","Ja",null,null,"Partner 2","Broer","Adres","Plaats","Provincie","POSTCODE","Telefoon","iemand@example.com"]
[{"$nulls":3},"TOTAAL:",{"$f":"COUNTIF('RSVP-tracker'!$E$4:$E$14,\"Ja\")","v":11},{"$f":"COUNTA('RSVP-tracker'!$F$4:$F$14)","v":10},{"$f":"SUBTOTAL(109,tblGenodigden[AANTAL])","v":18}]

{"sheet":"RSVP-overzicht","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},"RSVP-TRACKER"]
[null,"TROUWDATUM",null,"rsvp-overzicht",{"$nulls":10},"notities"]
[null,{"$f":"TrouwDatum","v":"2023-05-13"},null,"JA","Gegroepeerd staafdiagram met gasten die met Ja hebben gereageerd, staan in deze cel."]
[null,"RESTERENDE DAGEN",{"$nulls":3},"ANDERS",{"$f":"IFERROR(SUMIFS(tblGenodigden[AANTAL],tblGenodigden[GAST],\"=Anders\",tblGenodigden[RSVP],\"Ja\"),0)","v":1},{"$f":"tblGenodigden[[#Totals],[VERZONDEN?]]","v":11}]
[null,{"$f":"ResterendeDagen","v":283},{"$nulls":3},"PARTNER 2",{"$f":"IFERROR(SUMIFS(tblGenodigden[AANTAL],tblGenodigden[GAST],\"=PARTNER 2\",tblGenodigden[RSVP],\"Ja\"),0)","v":4},{"$f":"tblGenodigden[[#Totals],[VERZONDEN?]]","v":11}]
[null,"AANWEZIG",{"$nulls":3},"PARTNER 1",{"$f":"IFERROR(SUMIFS(tblGenodigden[AANTAL],tblGenodigden[GAST],\"=PARTNER 1\",tblGenodigden[RSVP],\"Ja\"),0)","v":7},{"$f":"tblGenodigden[[#Totals],[VERZONDEN?]]","v":11}]
[null,{"$f":"TotaalAanwezig","v":12}]
[null,"NIET AANWEZIG",null,"NEE","Gegroepeerd staafdiagram met gasten die met Nee hebben gereageerd, staan in deze cel."]
[null,{"$f":"TotaalNietAanwezig","v":6},{"$nulls":3},"ANDERS",{"$f":"IFERROR(SUMIFS(tblGenodigden[AANTAL],tblGenodigden[GAST],\"=Anders\",tblGenodigden[RSVP],\"Nee\"),0)","v":1},{"$f":"tblGenodigden[[#Totals],[VERZONDEN?]]","v":11}]
[null,"OPENSTAAND",{"$nulls":3},"PARTNER 2",{"$f":"IFERROR(SUMIFS(tblGenodigden[AANTAL],tblGenodigden[GAST],\"=PARTNER 2\",tblGenodigden[RSVP],\"Nee\"),0)","v":2},{"$f":"tblGenodigden[[#Totals],[VERZONDEN?]]","v":11}]
[null,{"$f":"OpenstaandRSVP","v":1},{"$nulls":3},"PARTNER 1",{"$f":"IFERROR(SUMIFS(tblGenodigden[AANTAL],tblGenodigden[GAST],\"=PARTNER 1\",tblGenodigden[RSVP],\"Nee\"),0)","v":3},{"$f":"tblGenodigden[[#Totals],[VERZONDEN?]]","v":11}]