{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Suivi des réponses","Résumé des réponses"],"not_rendered":{"charts":2,"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"Suivi des réponses","index":0,"n_rows":15,"n_cols":15,"rows_kept":15,"merged":[[0,3,0,4],[0,5,0,7]]}
[{"$nulls":5},"RÉSUMÉ RÉPONSES"]
[null,"DATE DU MARIAGE",null,"suivi des invitations au mariage"]
[null,{"$f":"TODAY()+283","v":"2023-05-13"},null,"NOM DE L’INVITÉ","ENVOYÉE ?","RÉPONSE","GROUPE","INVITÉ","RELATION","ADRESSE","VILLE","DÉPARTEMENT","CODE POSTAL","TÉLÉPHONE","ADRESSE DE COURRIER"]
[null,"NOMBRE DE JOURS RESTANTS",null,"Nom 1","Oui","Oui",1,"Conjoint 1","Frère","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[null,{"$f":"JoursRestants","v":283},null,"Nom 2","Oui","Non",3,"Conjoint 1","Ami","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[null,"PRÉSENCE CONFIRMÉE",null,"Nom 3","Oui","Oui",1,"Autre","Ami","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[null,{"$f":"TotalParticipants","v":12},null,"Nom 4","Oui","Non",2,"Conjoint 2","Ami","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[null,"ABSENCE CONFIRMÉE",null,"Nom 5","Oui","Oui",2,"Conjoint 2","Ami","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[null,{"$f":"TotalNonParticipants","v":6},null,"Nom 6","Oui","Provisoire",null,"Autre","Ami","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[null,"SANS RÉPONSE",null,"Nom 7","Oui","Oui",2,"Conjoint 2","Ami","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[null,{"$f":"SansRéponses","v":1},null,"Nom 8","Oui","Non",1,"Autre","Ami","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[{"$nulls":3},"Nom 9","Oui","Oui",4,"Conjoint 1","Ami","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[{"$nulls":3},"Nom de 10","Oui","Oui",2,"Conjoint 1","Ami","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[{"$nulls":3},"Nom 11","Oui",null,null,"Conjoint 2","Frère","Adresse","Ville","Département","Code postal","Téléphone","xyz@example.com"]
[{"$nulls":3},"TOTAUX :",{"$f":"COUNTIF('Suivi des réponses'!$E$4:$E$14,\"Oui\")","v":11},{"$f":"COUNTA('Suivi des réponses'!$F$4:$F$14)","v":10},{"$f":"SUBTOTAL(109,tblInvitations[GROUPE])","v":18}]

{"sheet":"Résumé des réponses","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},"SUIVI RÉPONSES"]
[null,"DATE DU MARIAGE",null,"resume des reponses",{"$nulls":10},"notes"]
[null,{"$f":"DateMariage","v":"2023-05-13"},null,"OUI","Un graphique à barres groupées affichant les types d’invités ayant accepté l’invitation se trouve dans cette cellule."]
[null,"NOMBRE DE JOURS RESTANTS",{"$nulls":3},"AUTRE",{"$f":"IFERROR(SUMIFS(tblInvitations[GROUPE],tblInvitations[INVITÉ],\"=Autre\",tblInvitations[RÉPONSE],\"Oui\"),0)","v":1},{"$f":"tblInvitations[[#Totals],[ENVOYÉE ?]]","v":11}]
[null,{"$f":"JoursRestants","v":283},{"$nulls":3},"CONJOINT 2",{"$f":"IFERROR(SUMIFS(tblInvitations[GROUPE],tblInvitations[INVITÉ],\"=Conjoint 2\",tblInvitations[RÉPONSE],\"Oui\"),0)","v":4},{"$f":"tblInvitations[[#Totals],[ENVOYÉE ?]]","v":11}]
[null,"PRÉSENCE CONFIRMÉE",{"$nulls":3},"CONJOINT 1",{"$f":"IFERROR(SUMIFS(tblInvitations[GROUPE],tblInvitations[INVITÉ],\"=Conjoint 1\",tblInvitations[RÉPONSE],\"Oui\"),0)","v":7},{"$f":"tblInvitations[[#Totals],[ENVOYÉE ?]]","v":11}]
[null,{"$f":"TotalParticipants","v":12}]
[null,"ABSENCE CONFIRMÉE",null,"NON","Un graphique à barres groupées affichant les types d’invités ayant décliné l’invitation se trouve dans cette cellule."]
[null,{"$f":"TotalNonParticipants","v":6},{"$nulls":3},"AUTRE",{"$f":"IFERROR(SUMIFS(tblInvitations[GROUPE],tblInvitations[INVITÉ],\"=Autre\",tblInvitations[RÉPONSE],\"Non\"),0)","v":1},{"$f":"tblInvitations[[#Totals],[ENVOYÉE ?]]","v":11}]
[null,"SANS RÉPONSE",{"$nulls":3},"CONJOINT 2",{"$f":"IFERROR(SUMIFS(tblInvitations[GROUPE],tblInvitations[INVITÉ],\"=Conjoint 2\",tblInvitations[RÉPONSE],\"Non\"),0)","v":2},{"$f":"tblInvitations[[#Totals],[ENVOYÉE ?]]","v":11}]
[null,{"$f":"SansRéponses","v":1},{"$nulls":3},"CONJOINT 1",{"$f":"IFERROR(SUMIFS(tblInvitations[GROUPE],tblInvitations[INVITÉ],\"=Conjoint 1\",tblInvitations[RÉPONSE],\"Non\"),0)","v":3},{"$f":"tblInvitations[[#Totals],[ENVOYÉE ?]]","v":11}]