{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Invités","Menu Chaud","Buffet froid","Base de données"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"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":"Invités","index":0,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["Liste des invités"]
["N°","Lien familial","Famille","Nom","Enfant","Apéro","Repas","Soirée",null,null,"Adulte","Enfant"]
[{"$f":"ROW()-2","v":1},"Amie(e) marié",null,null,null,"þ",null,null,null,"Apéro",{"$f":"SUMPRODUCT((Tableau1[Apéro]<>\"\")*(Tableau1[Enfant]=\"\"))","v":2},{"$f":"SUMPRODUCT((Tableau1[Apéro]<>\"\")*(Tableau1[Enfant]<>\"\"))","v":1}]
[{"$f":"ROW()-2","v":2},"Famille mariée",null,null,"þ",null,"þ","þ",null,"Repas",{"$f":"SUMPRODUCT((Tableau1[Repas]<>\"\")*(Tableau1[Enfant]=\"\"))","v":3},{"$f":"SUMPRODUCT((Tableau1[Repas]<>\"\")*(Tableau1[Enfant]<>\"\"))","v":4}]
[3,"Famille marié",null,null,"þ",null,null,"þ",null,"Soirée",{"$f":"SUMPRODUCT((Tableau1[Soirée]<>\"\")*(Tableau1[Enfant]=\"\"))","v":1},{"$f":"SUMPRODUCT((Tableau1[Soirée]<>\"\")*(Tableau1[Enfant]<>\"\"))","v":2}]
[4,"En commun",null,null,null,null,"þ",null,null,"Famille marié",{"$f":"SUMPRODUCT((Tableau1[Lien familial]=$J6)*(Tableau1[Enfant]=\"\"))","v":1},{"$f":"SUMPRODUCT((Tableau1[Lien familial]=$J6)*(Tableau1[Enfant]<>\"\"))","v":2}]
[{"$f":"ROW()-2","v":5},"En commun",null,null,"þ",null,"þ",null,null,"Famille mariée",{"$f":"SUMPRODUCT((Tableau1[Lien familial]=$J7)*(Tableau1[Enfant]=\"\"))","v":1},{"$f":"SUMPRODUCT((Tableau1[Lien familial]=$J7)*(Tableau1[Enfant]<>\"\"))","v":2}]
[6,"Amie(e) mariée",null,null,"þ","þ",null,null,null,"En commun",{"$f":"SUMPRODUCT((Tableau1[Lien familial]=$J8)*(Tableau1[Enfant]=\"\"))","v":1},{"$f":"SUMPRODUCT((Tableau1[Lien familial]=$J8)*(Tableau1[Enfant]<>\"\"))","v":1}]
[7,"Amie(e) mariée",null,null,null,"þ",null,"þ",null,"Amie(e) marié",{"$f":"SUMPRODUCT((Tableau1[Lien familial]=$J9)*(Tableau1[Enfant]=\"\"))","v":1},{"$f":"SUMPRODUCT((Tableau1[Lien familial]=$J9)*(Tableau1[Enfant]<>\"\"))","v":0}]
[8,"Famille marié",null,null,null,null,"þ",null,null,"Amie(e) mariée",{"$f":"SUMPRODUCT((Tableau1[Lien familial]=$J10)*(Tableau1[Enfant]=\"\"))","v":1},{"$f":"SUMPRODUCT((Tableau1[Lien familial]=$J10)*(Tableau1[Enfant]<>\"\"))","v":1}]
[9,"Famille mariée",null,null,null,null,"þ"]
[10,"Famille mariée",null,null,"þ",null,"þ"]
[11,"Famille marié",null,null,"þ",null,"þ"]

{"sheet":"Menu Chaud","index":1,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,9,32,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[32,6,32,8],[29,9,29,10],[30,9,30,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[31,9,31,10],[26,6,26,8],[27,6,27,8],[28,6,28,8],[29,6,29,8],[30,6,30,8],[31,6,31,8],[31,4,31,5],[32,4,32,5],[18,6,18,8],[19,6,19,8],[20,6,20,8],[21,6,21,8],[22,6,22,8],[23,6,23,8],[24,6,24,8],[25,6,25,8],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[30,1,30,2],[31,1,31,2],[32,1,32,2],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[23,1,23,2],[17,6,17,8],[17,9,17,10],[9,0,9,1],[10,0,10,1],[14,0,14,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[17,4,17,5],[18,9,18,10],[19,1,19,2],[18,1,18,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[6,0,6,1],[8,0,8,1],[16,0,16,10],[17,0,17,2],[0,0,0,10],[1,0,1,1],[3,0,3,1],[4,0,4,1],[5,0,5,1]]}
["Nom de la fête"]
["Lieu",null,null,"Date"]
["Le calcul est automatique si vous faites votre liste d'invités"]
["Invités",null,"Nbre adulte","Nbre enfant","Début","Fin"]
["Vin d'honneur",null,{"$f":"Invités!K3","v":2},{"$f":"Invités!L3","v":1}]
["Repas",null,{"$f":"Invités!K4","v":3},{"$f":"Invités!L4","v":4}]
["Soirée",null,{"$f":"Invités!K5","v":1},{"$f":"Invités!L5","v":2}]
[]
["Divers",null,"Qui","Quoi","Budget"]
["Sono"]
["Déco"]
["Fleurs"]
["Nappage"]
["Service"]
["Vaisselle"]
[]
["Menu Chaud"]
["Quoi et Qui fait quoi",null,null,"Qui","Quoi",null,"Quant/pers",null,null,"Quant/Total"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]

{"sheet":"Buffet froid","index":2,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,1,46,2],[46,4,46,5],[46,6,46,8],[46,9,46,10],[47,1,47,2],[47,4,47,5],[47,6,47,8],[47,9,47,10],[44,1,44,2],[44,4,44,5],[44,6,44,8],[44,9,44,10],[45,1,45,2],[45,4,45,5],[42,1,42,2],[42,4,42,5],[42,6,42,8],[42,9,42,10],[43,1,43,2],[43,4,43,5],[43,6,43,8],[43,9,43,10],[45,6,45,8],[45,9,45,10],[40,1,40,2],[40,4,40,5],[40,6,40,8],[40,9,40,10],[41,1,41,2],[41,4,41,5],[41,6,41,8],[41,9,41,10],[38,1,38,2],[38,4,38,5],[38,6,38,8],[38,9,38,10],[39,1,39,2],[39,4,39,5],[39,6,39,8],[39,9,39,10],[36,1,36,2],[36,4,36,5],[36,6,36,8],[36,9,36,10],[37,1,37,2],[37,4,37,5],[37,6,37,8],[37,9,37,10],[34,1,34,2],[34,4,34,5],[34,6,34,8],[34,9,34,10],[35,1,35,2],[35,4,35,5],[35,6,35,8],[35,9,35,10],[32,1,32,2],[32,4,32,5],[32,6,32,8],[32,9,32,10],[33,1,33,2],[33,4,33,5],[33,6,33,8],[33,9,33,10],[30,1,30,2],[30,4,30,5],[30,6,30,8],[30,9,30,10],[31,1,31,2],[31,4,31,5],[31,6,31,8],[31,9,31,10],[28,1,28,2],[28,4,28,5],[28,6,28,8],[28,9,28,10],[29,1,29,2],[29,4,29,5],[29,6,29,8],[29,9,29,10],[26,1,26,2],[26,4,26,5],[26,6,26,8],[26,9,26,10],[27,1,27,2],[27,4,27,5],[27,6,27,8],[27,9,27,10],[24,9,24,10],[25,1,25,2],[25,4,25,5],[25,6,25,8],[25,9,25,10],[22,1,22,2],[22,4,22,5],[22,6,22,8],[22,9,22,10],[23,1,23,2],[23,4,23,5],[23,6,23,8],[23,9,23,10],[8,3,8,6],[9,3,9,6],[10,3,10,6],[10,0,10,1],[21,1,21,2],[21,4,21,5],[21,6,21,8],[24,1,24,2],[24,4,24,5],[24,6,24,8],[21,9,21,10],[18,1,18,2],[18,4,18,5],[18,6,18,8],[18,9,18,10],[19,1,19,2],[14,0,14,1],[19,6,19,8],[19,9,19,10],[0,0,0,9],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[8,0,8,1],[9,0,9,1],[17,9,17,10],[20,1,20,2],[20,4,20,5],[20,6,20,8],[20,9,20,10],[16,0,16,10],[17,0,17,2],[19,4,19,5],[11,3,11,6],[12,3,12,6],[13,3,13,6],[14,3,14,6],[17,4,17,5],[17,6,17,8],[11,0,11,1],[12,0,12,1],[13,0,13,1]]}
["Nom de la fête"]
["Lieu",null,"Date"]
[]
["Invités",null,"Nbre adulte","Nbre enfant","Début","Fin"]
["Vin d'honneur",null,{"$f":"Invités!K3","v":2},{"$f":"Invités!L3","v":1}]
["Repas",null,{"$f":"Invités!K4","v":3},{"$f":"Invités!L4","v":4}]
["Soirée",null,{"$f":"Invités!K5","v":1},{"$f":"Invités!L5","v":2}]
[]
["Divers",null,"Qui","Quoi",null,null,null,"Budget"]
["Sono"]
["Déco"]
["Fleurs"]
["Nappage"]
["Service"]
["Vaisselle"]
[]
["Buffet froid"]
["Quoi et Qui fait quoi",null,null,"Qui","Quoi",null,"Quant/pers",null,null,"Quant/Total"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]

{"sheet":"Base de données","index":3,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Apéro / Boisson","Traiteur","Champagne",null,"Apéro","Traiteur","Tomate crevette",null,"Parents","Famille marié"]
["Apéro / Zak","Nous","Mousseux",null,"Apéro / Zak","Nous","Orange crabe",null,"Frère ou Sœur","Famille mariée"]
["Chips, etc","Papa","Sangria",null,"Chips, etc","Papa","Citron crabe",null,"Grands-parents","En commun"]
["Entrée 1","Maman","Poisson",null,"Plat poisson","Maman","Pêche au thon",null,"Arr. Grands-parents","Amie(e) marié"]
["Entrée 2","Ami","Crustacé",null,"Plat viande","Ami","Saumon belle-vue",null,"Oncle ou Tante","Amie(e) mariée"]
["Trou Normand",null,"Viande",null,"Crustacé",null,"Saumon fumé",null,"Parrain ou Marraine"]
["Plat",null,"Roue de brie",null,"Légume",null,"Gambas",null,"Cousin ou Cousine"]
["Fromages",null,"Chocolat",null,"Fromages",null,"Queue de scampi",null,"Ami(e)"]
["Gateau",null,"Glacé",null,"Gateau",null,"Terrine de poisson",null,"Collègue"]
["Dessert",null,"Fruit",null,"Dessert",null,"Roulade de jambon",null,"Autres"]
["Tarte",null,"Vin blanc",null,"Tarte",null,"Roti en fine tranche"]
["Café",null,"Vin rouge",null,"Café",null,"Cuisse de poulet"]
["Eau et soda",null,"Liquoreux",null,"Eau et soda",null,"Une terrine pâté"]
["Biére",null,null,null,"Biére",null,"Jambon de Parme melon"]
["Vin",null,null,null,"Vin"]