{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Calcul_A_emporter","DEVIS AURI","FACTURE AURI","PREPARATION","Feuil1","pdj"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":26,"comments":1,"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":"Calcul_A_emporter","index":0,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[]}
[null,"Repas au self","Cocktail/Petit Déjeuner au détail","Sandwich","Pizzas et Quiches","Boissons chaudes","Boissons Fraiches","Boissons alcoolisées TVA 20%","Matériel TVA 20%",null,null,null,null,null,null,null,"HT","code tva","TAUX TVA","TTC"]
[null,"Ticket Repas 1 (Entrée, Plat, Dessert)","Assortiment de Canapés salés (48 piéces)","Sandwich Jambon Beurre","Quiche loraine (8 parts)","Thermos de café avec matériel (20 personnes)","Eau de source 0,5 l (24 pièces)","ChampagneDevaux Brut 75cl","Forfait Vaisselle Jetable (assiette, gobelet, serviette, couverts)",null,null,null,null,null,null,"Forfait livraison",35,2,0.2,{"$f":"+Q2*(1+S2)","v":42}]
[null,"Ticket Repas 2 (Entrée, Plat, Dessert, Boisson)","Assortiment de Mignardises (56 piéces)","Sandwich Jambon Emmental","Quiche tomate chèvre (8 parts)","Thermos de thé avec matériel (10 personnes)","Eau de source 1,5 l (6 pièces)","Cidre 75cl","Verre cristal jetable (par 50)"]
[null,null,"Bol de crudité et sa sauce (le bol)","Sandwich Poulet","Quiche Poulet (8 parts)",null,"Eau de source 1,5 l (1 bouteille)","Crémant de Loire 75cl","Flutes jetable (par 10)",null,null,null,null,null,null,"Personnel (mise en place, service et reprise) avant 17h",35,2,0.2,{"$f":"+Q4*(1+S4)","v":42}]
[null,null,"Mini-macarons (12 piéces)","Sandwich Végétarien","Pizza Ronde  3 Fromages (1 part)",null,"Eau pétillante 1 l (6 pièces)","Vin rouge (75 cl)","Serviettes (paquet de 100)",null,null,null,null,null,null,"Personnel (mise en place, service et reprise) après 17h",48,2,0.2,57.599999999999994]
[null,null,"Pain au chocolat","Sandwich Thon","Pizza Ronde  Poulet (1 part)",null,"Jus de pamplemouse 1l","Vin Blanc (75 cl)",null,null,null,null,null,null,null,"A emporter",0,0,0,0]
[null,null,"Pain aux Raisins","Sandwich Saumon","Pizza Ronde  Végétarienne (1 part)",null,"Jus d'orange 1l","Vin Rosé (75 cl)",null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,"Croissant",null,"Pizza Carrée 3 Fromages (1 part)",null,"Lait 1l","Droit de bouchon",null,null,null,null,null,null,null,"Ticket Repas 1 (Entrée, Plat, Dessert)",15,1,0.1,16.5]
[null,null,"Chausson aux Pommes",null,"Pizza Carrée Poulet (1 part)",null,null,null,null,null,null,null,null,null,null,"Ticket Repas 2 (Entrée, Plat, Dessert, Boisson)",15.5,1,0.1,17.05]
[null,null,"Assortissement de Mini viennoisserie (la piéce)",null,"Pizza Carrée Végétarienne (1 part)",null,null,null,null,null,null,null,null,null,null,"non",0,0,0,0]
[null,null,"Mini pain au chocolat",null,"Pizza Plaque 3 Fromages (6 parts)",null,null,null,null,null,null,null,null,null,null,"Salle Premier Niveau Cantine",70,2,0.2,84]
[null,null,"Mini Croissant",null,"Pizza Plaque Poulet (6 parts)",null,null,null,null,null,null,null,null,null,null,"Rez de Jardin Cantine",70,2,0.2,84]
[null,null,"Mini Pain aux raisins",null,"Pizza Plaque Végétarienne (6 parts)",null,null,null,null,null,null,null,null,"Type de client",null,"Restaurant Club (modalités à voir avec le Responsable du Club)",70,2,0.2,84]
[null,null,"Brioche (6 parts)",null,null,null,null,null,null,null,null,null,null,"Type de client :",null,"Pause Café (boisson chaude, jus, eau)",1.6,1,0.1,1.7600000000000002]
[null,null,"Brownie (12 parts)",null,null,null,null,null,null,null,null,null,null,"Ministére :",null,"Petit Déjeuner Complet (boisson chaude, jus, viennoisserie)",4.2,1,0.1,4.620000000000001]
[null,null,"Cake (12 parts)",null,null,null,null,null,null,null,null,null,null,"Nom Prénom :",null,"Assortiment de Canapés salés (48 piéces)",{"$f":"48*0.99","v":47.519999999999996},1,0.1,52.271999999999998]
[null,null,"Cannelés",null,null,null,null,null,null,null,null,null,null,null,null,"Assortiment de Mignardises (56 piéces)",{"$f":"56*0.99","v":55.44},1,0.1,60.984000000000002]
[null,null,"Corbeille de Fruits",null,null,null,"Eau de source 1,5 l (1 bouteille)",null,null,null,null,null,null,null,null,"Mini-macarons (12 piéces)",13.2,1,0.1,14.52]
[null,null,"Pain Surprise (50 sandwichs)",null,null,null,"Jus de pamplemouse 1l",null,null,null,"Location de salle AURI TVA à 20%","Livraison et Personnel TVA 20 %",null,null,null,"Pain au chocolat",0.9,1,0.1,0.9900000000000001]
[null,null,"Pâtisserie (part individuelle)",null,null,null,"Jus d'orange 1l",null,null,null,null,null,null,null,null,"Pain aux Raisins",0.9,1,0.1,0.9900000000000001]
[null,null,"Tarte aux fruits de saison (6/8 parts)",null,null,null,null,null,null,null,"non","Forfait livraison",null,null,null,"Croissant",0.9,1,0.1,0.9900000000000001]
[null,null,"Verrine (la piéce)",null,null,null,null,null,null,null,"Salle Premier Niveau Cantine","Personnel (mise en place, service et reprise) avant 17h",null,null,null,"Chausson aux Pommes",0.9,1,0.1,0.9900000000000001]
[null,null,null,null,null,null,null,null,null,null,"Rez de Jardin Cantine","Personnel (mise en place, service et reprise) après 17h",null,null,null,"Assortissement de Mini viennoisserie (la piéce)",0.7,1,0.1,0.77]
[null,null,null,null,null,null,null,null,null,null,"Restaurant Club (modalités à voir avec le Responsable du Club)","A emporter",null,"Lieux",null,"Mini pain au chocolat",0.7,1,0.1,0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Choisir un lieu",null,"Mini Croissant",0.7,1,0.1,0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A Emporter",null,"Mini Pain aux raisins",0.7,1,0.1,0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hall Barbet de Jouy",null,"Assortiment de mini viennoisseries",0.7,1,0.1,0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Restaurant Club AURI",null,"Brioche (6 parts)",6,1,0.1,6.6000000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Salle premier niveau Cantine",null,"Brownie (12 parts)",26.4,1,0.1,29.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Salle rez de jardin Cantine",null,"Cake (12 parts)",17.55,1,0.1,19.305000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hall Gambetta",null,"Cannelés",0.85,1,0.1,0.93500000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Salle Trémouille",null,"Corbeille de fruits (10 personnes)",40,1,0.1,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Salle Sycomore",null,"Pain Surprise (50 sandwichs)",36,1,0.1,39.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Salle de Ball",null,"Pâtisserie (part individuelle)",1.5,1,0.1,1.6500000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Salle Epicéa",null,"Salade de fruits",1.8,1,0.1,1.9800000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Salle Acacia",null,"Tarte aux fruits de saison (10/12 parts)",24.7,1,0.1,27.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Salle 050 BDJ",null,"Tarte aux fruits de saison (6/8 parts)",17.489999999999998,1,0.1,19.239000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Salle 374 BDJ",null,"Sandwich Jambon Beurre",2.5499999999999998,1,0.1,2.8050000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Salle Sully*",null,"Sandwich Jambon Emmental",3.5,1,0.1,3.8500000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Autre Lieu",null,"Sandwich Poulet",3.5,1,0.1,3.8500000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandwich Végétarien",3.5,1,0.1,3.8500000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Prise en charge",null,"Sandwich Thon",4,1,0.1,4.4000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Prise en charge…",null,"Sandwich Saumon",4,1,0.1,4.4000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"par le service",null,"Verrine (la piéce)",1.9,1,0.1,{"$f":"+Q44*(1+S44)","v":2.09}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"par un organisme extérieur",null,"Bol de crudité et sa sauce (le bol)",3,1,0.1,{"$f":"+Q45*(1+S45)","v":3.3000000000000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"personnelle",null,"Quiche loraine (8 parts)",23.4,1,0.1,{"$f":"+Q46*(1+S46)","v":25.740000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quiche tomate chèvre (8 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mode de règlement",null,"Quiche Poulet (8 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Chèque",null,"Pizza Ronde  3 Fromages (1 part)",4.0999999999999996,1,0.1,4.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Espèces",null,"Pizza Ronde  Poulet (1 part)",4.0999999999999996,1,0.1,4.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Virement régie",null,"Pizza Ronde  Végétarienne (1 part)",4.0999999999999996,1,0.1,4.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Virement chorus",null,"Pizza Carrée 3 Fromages (1 part)",3.9,1,0.1,4.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Carte bleue",null,"Pizza Carrée Poulet (1 part)",3.9,1,0.1,4.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Carrée  Végétarienne (1 part)",3.9,1,0.1,4.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Plaque 3 Fromages (6 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Plaque Poulet (6 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Plaque Végétarienne (6 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Ronde (1 personne)",4.0999999999999996,1,0.1,4.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Carrée (1 part)",3.9,1,0.1,4.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Plaque (6 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thermos de café avec matériel (20 personnes)",20,1,0.1,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thermos de thé avec matériel (10 personnes)",13,1,0.1,14.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eau de source 0,5 l (24 pièces)",{"$f":"24*0.7","v":16.799999999999997},1,0.1,18.479999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eau de source 1,5 l (6 pièces)",{"$f":"1.3*6","v":7.8000000000000007},1,0.1,8.5800000000000018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eau de source 1,5 l (1 bouteille)",1.3,1,0.1,1.4300000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eau pétillante 1 l (6 pièces)",{"$f":"2.1*6","v":12.600000000000001},1,0.1,13.860000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jus de pamplemouse 1l",3.8,1,0.1,4.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jus d'orange 1l",3.8,1,0.1,4.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lait 1l",1.8,2,0.2,2.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ChampagneDevaux Brut 75cl",28.8,2,0.2,34.56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cidre 75cl",6.6,2,0.2,7.919999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crémant de Loire 75cl",12,2,0.2,14.399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vin rouge (75 cl)",15.1,2,0.2,{"$f":"+Q73*(1+S73)","v":18.119999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vin Blanc (75 cl)",15.1,2,0.2,{"$f":"+Q74*(1+S74)","v":18.119999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vin Rosé (75 cl)",15.1,2,0.2,{"$f":"+Q75*(1+S75)","v":18.119999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Droit de bouchon",5.8,2,0.2,6.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forfait Vaisselle Jetable (assiette, gobelet, serviette, couverts)",1.5,2,0.2,1.7999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verre cristal jetable (par 50)",10,2,0.2,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flutes jetable (par 10)",1.8,2,0.2,2.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviettes (paquet de 100)",10,2,0.2,{"$f":"+Q80*(1+S80)","v":12}]

{"sheet":"DEVIS AURI","index":1,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[57,5,58,6],[56,3,56,4],[57,3,57,4],[58,3,58,4],[22,3,22,5],[23,3,23,5],[25,3,25,6],[4,3,4,6],[56,5,56,6],[15,3,15,6],[16,3,16,6],[17,3,17,6],[8,3,8,6],[14,3,14,6],[9,3,11,4],[9,5,11,6],[28,2,31,6],[24,3,24,6],[5,3,7,6],[18,3,18,6],[19,3,20,6],[21,3,21,5]]}
[]
[]
[null,null,"BON DE COMMANDE PRESTATIONS ANNEXES -  2017"]
[]
[null,null,null,"Envoyer ce devis par mail à : banquet@aurirestaurant.fr"]
[null,null,null,"Merci de nous retourner ce fichier sous format excel par mail. Nous vous reverirons un fichier pdf que vous devrez signer pour confirmer votre commande"]
[]
[]
[]
[null,null,null,"DEVIS N°"]
[]
[]
[]
["Coordonnées du service \ncommanditaire",{"$f":"IF($A$18=\"Nom prénom :\",\"\",\"Indiquer le nom de la personne chargée de la mise en paiement des factures et / ou du centre chorus\")","v":""}]
[null,null,{"$f":"IF($A$18=\"Nom prénom :\",\"\",\"Ministére :\")","v":""}]
["Objet de l'événement :",null,{"$f":"IF($A$18=\"Nom Prénom :\",\"\",\"Service Payeur :\")","v":""}]
["Nombre de convives :",null,{"$f":"IF($A$18=\"Nom prénom :\",\"\",\"Adresse :\")","v":""}]
["Nom Prénom :",null,{"$f":"IF($A$18=\"Nom prénom :\",\"\",\"Code Postal :\")","v":""}]
["Adresse :",null,{"$f":"IF($A$18=\"Nom prénom :\",\"\",\"Ville :\")","v":""}]
["Code Postal :",null,{"$f":"IF($A$18=\"Nom prénom :\",\"\",\"Nom de la personne\")","v":""}]
["Ville :",null,{"$f":"IF($A$18=\"Nom prénom :\",\"\",\"Chargé du réglement\")","v":""}]
["Organisateur :",null,{"$f":"IF($A$18=\"Nom prénom :\",\"\",\"N° de téléphone :\")","v":""}]
["N° de téléphone :",null,{"$f":"IF($A$18=\"Nom prénom :\",\"\",\"Adresse mail :\")","v":""}]
["adresse mail :",null,{"$f":"IF($A$18=\"Nom prénom :\",\"\",\"Bon de commande :\")","v":""}]
[null,null,"Mode de règlement :","Mode de règlement"]
[null,null,{"$f":"IF(D25=\"Virement Chorus\",\"N° Chorus :\",\"\")","v":""}]
["VOTRE COMMANDE"]
[null,null,"INFORMATIONS SUPPLEMENTAIRES"]
["Date de l'événement :"]
["Heure de l'événement :"]
["Lieu de l'événement :","Choisir un lieu"]
[{"$f":"IF($B$31=\"A Emporter\",\"Lieu de retrait :\",\"\")","v":""},{"$f":"+IF(A32=\"Lieu de retrait :\",\" Le Café à partir de 8h00\",\"\")","v":""}]
[{"$f":"IF(B31=\"Autre Lieu\",\"Autre Lieu :\",\"\")","v":""}]
[]
[]
["Prestations commandées"]
[]
["Prestations","Gamme","Quantité","Prix Unitaire HT","Prix Total HT","code tva","Prix Total TTC"]
[{"$f":"livraisonPersonnel","v":"Livraison et Personnel TVA 20 %"},null,"",{"$f":"(IF(ISBLANK($B39),\"\",VLOOKUP($B39,tarif,2,FALSE)))","v":""},{"$f":"IFERROR(C39*D39,\"\")","v":""},{"$f":"(IF(ISBLANK($B39),\"\",VLOOKUP($B39,tarif,3,FALSE)))","v":""},{"$f":"IF(B39=0,\"\",IF(D39=0,\"\",IF(F39=0,0,IF(F39=1,E39*1.1,IF(F39=2,E39*1.2)))))","v":""}]
[{"$f":"+Calcul_A_emporter!K19","v":"Location de salle AURI TVA à 20%"},null,"","",{"$f":"IFERROR(C40*D40,\"\")","v":""},"",""]
[null,null,{"$f":"IF(B41=0,\"\",IF(A41=0,\"\",IF(ISBLANK($B41),\"\",\"Quantité à remplir\")))","v":""},"",{"$f":"IFERROR(C41*D41,\"\")","v":""},"",{"$f":"IF(B41=0,\"\",IF(D41=0,\"\",IF(F41=0,0,IF(F41=1,E41*1.1,IF(F41=2,E41*1.2)))))","v":""}]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,{"$f":"IF(B45=0,\"\",IF(A45=0,\"\",IF(ISBLANK($B45),\"\",\"Quantité à remplir\")))","v":""},"","","",""]
[null,null,{"$f":"IF(B46=0,\"\",IF(A46=0,\"\",IF(ISBLANK($B46),\"\",\"Quantité à remplir\")))","v":""},"",{"$f":"IFERROR(C46*D46,\"\")","v":""},"",{"$f":"IF(B46=0,\"\",IF(D46=0,\"\",IF(F46=0,0,IF(F46=1,E46*1.1,IF(F46=2,E46*1.2)))))","v":""}]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,{"$f":"IF(B52=0,\"\",IF(A52=0,\"\",IF(ISBLANK($B52),\"\",\"Quantité à remplir\")))","v":""},{"$f":"(IF(ISBLANK($B52),\"\",VLOOKUP($B52,tarif,2,FALSE)))","v":""},"",{"$f":"(IF(ISBLANK($B52),\"\",VLOOKUP($B52,tarif,3,FALSE)))","v":""},""]
[null,null,"",{"$f":"(IF(ISBLANK($B53),\"\",VLOOKUP($B53,tarif,2,FALSE)))","v":""},"",{"$f":"(IF(ISBLANK($B53),\"\",VLOOKUP($B53,tarif,3,FALSE)))","v":""},""]
[null,null,"",{"$f":"(IF(ISBLANK($B54),\"\",VLOOKUP($B54,tarif,2,FALSE)))","v":""},"",{"$f":"(IF(ISBLANK($B54),\"\",VLOOKUP($B54,tarif,3,FALSE)))","v":""},""]
[null,null,"",{"$f":"(IF(ISBLANK($B55),\"\",VLOOKUP($B55,tarif,2,FALSE)))","v":""},"",{"$f":"(IF(ISBLANK($B55),\"\",VLOOKUP($B55,tarif,3,FALSE)))","v":""},""]
[null,null,"",{"$f":"(IF(ISBLANK($B56),\"\",VLOOKUP($B56,tarif,2,FALSE)))","v":""},"",{"$f":"(IF(ISBLANK($B56),\"\",VLOOKUP($B56,tarif,3,FALSE)))","v":""},""]
[" TVA","MONTANT HT","TOTAL TVA","TOTAL HT",null,"TOTAL GENERAL  TTC"]
[" (1) 10%",{"$f":"SUMIF(F39:F56,1,E39:E56)","v":0},{"$f":"+B58*0.1","v":0},{"$f":"+B58","v":0},null,{"$f":"SUM(C58:E58)+SUM(C59:E59)","v":0}]
["(2) 20%",{"$f":"SUMIF(F39:F56,2,E39:E56)","v":0},{"$f":"+B59*0.2","v":0},{"$f":"+B59","v":0}]

{"sheet":"FACTURE AURI","index":2,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":true,"merged":[[0,5,0,6],[2,5,2,6],[3,5,3,6],[55,3,55,4],[55,5,55,6],[0,2,0,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[56,3,56,4],[56,5,57,6],[57,3,57,4],[1,16,2,16],[3,16,4,16],[27,0,27,6],[22,3,22,4],[9,3,9,6],[10,0,10,1],[10,3,10,6],[12,3,12,4],[12,5,12,6],[5,16,6,18],[11,3,11,6],[1,5,1,6],[20,0,21,1]]}
[null,null,"FACTURE N°"]
[null,null,"DEVIS N°",null,null,{"$f":"+'DEVIS AURI'!F10","v":0}]
[null,null,"BON DE COMMANDE",null,null,{"$f":"+'DEVIS AURI'!D24","v":0}]
[null,null,"N° CHORUS",null,null,{"$f":"+'DEVIS AURI'!D26","v":0}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"+'DEVIS AURI'!D15","v":0}]
["Coordonnées du service commanditaire",null,null,{"$f":"+'DEVIS AURI'!D16","v":0}]
["Objet de l'événement :",{"$f":"+'DEVIS AURI'!B16","v":0},null,{"$f":"+'DEVIS AURI'!D17","v":0}]
[{"$f":"+'DEVIS AURI'!A18","v":"Nom Prénom :"},{"$f":"+'DEVIS AURI'!B18","v":0},null,{"$f":"+'DEVIS AURI'!D18","v":0},null,{"$f":"+'DEVIS AURI'!D19","v":0}]
[{"$f":"+'DEVIS AURI'!A19","v":"Adresse :"},{"$f":"+'DEVIS AURI'!B19","v":0}]
[{"$f":"+'DEVIS AURI'!A20","v":"Code Postal :"},{"$f":"+'DEVIS AURI'!B20","v":0}]
[{"$f":"+'DEVIS AURI'!A21","v":"Ville :"},{"$f":"+'DEVIS AURI'!B21","v":0}]
[{"$f":"+'DEVIS AURI'!A22","v":"Organisateur :"},{"$f":"+'DEVIS AURI'!B22","v":0}]
[{"$f":"+'DEVIS AURI'!A23","v":"N° de téléphone :"},{"$f":"+'DEVIS AURI'!B23","v":0}]
[{"$f":"+'DEVIS AURI'!A24","v":"adresse mail :"},{"$f":"+'DEVIS AURI'!B24","v":0}]
[]
["Indiquer le nom de la personne Chargée de la mise\nen paiement des factures et/ou du centre chorus"]
[null,null,null,"Paris,"]
["Nom :",{"$f":"+'DEVIS AURI'!D20","v":0},null,{"$f":"TODAY()","v":"2017-09-15"}]
[{"$f":"+'DEVIS AURI'!C22","v":""},{"$f":"+'DEVIS AURI'!D22","v":0}]
[{"$f":"+'DEVIS AURI'!C23","v":""},{"$f":"+'DEVIS AURI'!D23","v":0}]
[{"$f":"+'DEVIS AURI'!C25","v":"Mode de règlement :"},{"$f":"+'DEVIS AURI'!D25","v":"Mode de règlement"}]
[null,{"$f":"IF(ISBLANK('DEVIS AURI'!E26),\"\",'DEVIS AURI'!E26)","v":""}]
["VOTRE COMMANDE"]
[]
["Date de l'événement :",{"$f":"+'DEVIS AURI'!B29","v":"00:00:00"}]
["Heure de l'événement :",{"$f":"+'DEVIS AURI'!B30","v":"00:00:00"}]
["Lieu de l'événement :",{"$f":"+'DEVIS AURI'!B31","v":"Choisir un lieu"}]
["Lieu de retrait :",{"$f":"+'DEVIS AURI'!B32","v":""}]
[]
[]
["Prestations commandées"]
["Prestations","Gamme","Quantité","Prix Unitaire HT","Prix Total HT","code tva","Prix Total TTC"]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A39),\"\",'DEVIS AURI'!A39)","v":"Livraison et Personnel TVA 20 %"},{"$f":"IF(ISBLANK('DEVIS AURI'!B39),\"\",'DEVIS AURI'!B39)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C39),\"\",'DEVIS AURI'!C39)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D39),\"\",'DEVIS AURI'!D39)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E39),\"\",'DEVIS AURI'!E39)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F39),\"\",'DEVIS AURI'!F39)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G39),\"\",'DEVIS AURI'!G39)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A40),\"\",'DEVIS AURI'!A40)","v":"Location de salle AURI TVA à 20%"},{"$f":"IF(ISBLANK('DEVIS AURI'!B40),\"\",'DEVIS AURI'!B40)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C40),\"\",'DEVIS AURI'!C40)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D40),\"\",'DEVIS AURI'!D40)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E40),\"\",'DEVIS AURI'!E40)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F40),\"\",'DEVIS AURI'!F40)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G40),\"\",'DEVIS AURI'!G40)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A41),\"\",'DEVIS AURI'!A41)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B41),\"\",'DEVIS AURI'!B41)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C41),\"\",'DEVIS AURI'!C41)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D41),\"\",'DEVIS AURI'!D41)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E41),\"\",'DEVIS AURI'!E41)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F41),\"\",'DEVIS AURI'!F41)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G41),\"\",'DEVIS AURI'!G41)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A42),\"\",'DEVIS AURI'!A42)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B42),\"\",'DEVIS AURI'!B42)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C42),\"\",'DEVIS AURI'!C42)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D42),\"\",'DEVIS AURI'!D42)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E42),\"\",'DEVIS AURI'!E42)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F42),\"\",'DEVIS AURI'!F42)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G42),\"\",'DEVIS AURI'!G42)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A43),\"\",'DEVIS AURI'!A43)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B43),\"\",'DEVIS AURI'!B43)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C43),\"\",'DEVIS AURI'!C43)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D43),\"\",'DEVIS AURI'!D43)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E43),\"\",'DEVIS AURI'!E43)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F43),\"\",'DEVIS AURI'!F43)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G43),\"\",'DEVIS AURI'!G43)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A44),\"\",'DEVIS AURI'!A44)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B44),\"\",'DEVIS AURI'!B44)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C44),\"\",'DEVIS AURI'!C44)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D44),\"\",'DEVIS AURI'!D44)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E44),\"\",'DEVIS AURI'!E44)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F44),\"\",'DEVIS AURI'!F44)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G44),\"\",'DEVIS AURI'!G44)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A45),\"\",'DEVIS AURI'!A45)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B45),\"\",'DEVIS AURI'!B45)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C45),\"\",'DEVIS AURI'!C45)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D45),\"\",'DEVIS AURI'!D45)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E45),\"\",'DEVIS AURI'!E45)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F45),\"\",'DEVIS AURI'!F45)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G45),\"\",'DEVIS AURI'!G45)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A46),\"\",'DEVIS AURI'!A46)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B46),\"\",'DEVIS AURI'!B46)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C46),\"\",'DEVIS AURI'!C46)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D46),\"\",'DEVIS AURI'!D46)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E46),\"\",'DEVIS AURI'!E46)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F46),\"\",'DEVIS AURI'!F46)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G46),\"\",'DEVIS AURI'!G46)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A47),\"\",'DEVIS AURI'!A47)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B47),\"\",'DEVIS AURI'!B47)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C47),\"\",'DEVIS AURI'!C47)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D47),\"\",'DEVIS AURI'!D47)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E47),\"\",'DEVIS AURI'!E47)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F47),\"\",'DEVIS AURI'!F47)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G47),\"\",'DEVIS AURI'!G47)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A48),\"\",'DEVIS AURI'!A48)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B48),\"\",'DEVIS AURI'!B48)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C48),\"\",'DEVIS AURI'!C48)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D48),\"\",'DEVIS AURI'!D48)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E48),\"\",'DEVIS AURI'!E48)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F48),\"\",'DEVIS AURI'!F48)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G48),\"\",'DEVIS AURI'!G48)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A49),\"\",'DEVIS AURI'!A49)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B49),\"\",'DEVIS AURI'!B49)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C49),\"\",'DEVIS AURI'!C49)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D49),\"\",'DEVIS AURI'!D49)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E49),\"\",'DEVIS AURI'!E49)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F49),\"\",'DEVIS AURI'!F49)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G49),\"\",'DEVIS AURI'!G49)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A50),\"\",'DEVIS AURI'!A50)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B50),\"\",'DEVIS AURI'!B50)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C50),\"\",'DEVIS AURI'!C50)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D50),\"\",'DEVIS AURI'!D50)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E50),\"\",'DEVIS AURI'!E50)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F50),\"\",'DEVIS AURI'!F50)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G50),\"\",'DEVIS AURI'!G50)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A51),\"\",'DEVIS AURI'!A51)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B51),\"\",'DEVIS AURI'!B51)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C51),\"\",'DEVIS AURI'!C51)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D51),\"\",'DEVIS AURI'!D51)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E51),\"\",'DEVIS AURI'!E51)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F51),\"\",'DEVIS AURI'!F51)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G51),\"\",'DEVIS AURI'!G51)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A52),\"\",'DEVIS AURI'!A52)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B52),\"\",'DEVIS AURI'!B52)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C52),\"\",'DEVIS AURI'!C52)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D52),\"\",'DEVIS AURI'!D52)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E52),\"\",'DEVIS AURI'!E52)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F52),\"\",'DEVIS AURI'!F52)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G52),\"\",'DEVIS AURI'!G52)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A53),\"\",'DEVIS AURI'!A53)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B53),\"\",'DEVIS AURI'!B53)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C53),\"\",'DEVIS AURI'!C53)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D53),\"\",'DEVIS AURI'!D53)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E53),\"\",'DEVIS AURI'!E53)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F53),\"\",'DEVIS AURI'!F53)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G53),\"\",'DEVIS AURI'!G53)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A54),\"\",'DEVIS AURI'!A54)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B54),\"\",'DEVIS AURI'!B54)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C54),\"\",'DEVIS AURI'!C54)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D54),\"\",'DEVIS AURI'!D54)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E54),\"\",'DEVIS AURI'!E54)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F54),\"\",'DEVIS AURI'!F54)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G54),\"\",'DEVIS AURI'!G54)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A55),\"\",'DEVIS AURI'!A55)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B55),\"\",'DEVIS AURI'!B55)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C55),\"\",'DEVIS AURI'!C55)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D55),\"\",'DEVIS AURI'!D55)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E55),\"\",'DEVIS AURI'!E55)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F55),\"\",'DEVIS AURI'!F55)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G55),\"\",'DEVIS AURI'!G55)","v":""}]
[{"$f":"IF(ISBLANK('DEVIS AURI'!A56),\"\",'DEVIS AURI'!A56)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!B56),\"\",'DEVIS AURI'!B56)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!C56),\"\",'DEVIS AURI'!C56)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!D56),\"\",'DEVIS AURI'!D56)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!E56),\"\",'DEVIS AURI'!E56)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!F56),\"\",'DEVIS AURI'!F56)","v":""},{"$f":"IF(ISBLANK('DEVIS AURI'!G56),\"\",'DEVIS AURI'!G56)","v":""}]
[" TVA","MONTANT HT","TOTAL TVA","TOTAL HT",null,"TOTAL GENERAL  TTC"]
[" (1) 10%",{"$f":"SUMIF(F38:F55,1,E38:E55)","v":0},{"$f":"+B57*0.1","v":0},{"$f":"C57+B57","v":0},null,{"$f":"D57+D58","v":0}]
["(2) 20%",{"$f":"SUMIF(F38:F55,2,E38:E55)","v":0},{"$f":"+B58*0.2","v":0},{"$f":"C58+B58","v":0}]

{"sheet":"PREPARATION","index":3,"n_rows":119,"n_cols":22,"rows_kept":119,"cut":false,"hidden":true,"merged":[[76,0,76,4],[77,2,77,4],[78,2,78,4],[91,0,91,4],[92,2,92,4],[80,0,80,3],[81,0,81,3],[82,0,82,3],[83,0,83,3],[84,0,84,3],[85,0,85,3],[86,0,86,3],[87,0,87,3],[88,0,88,3],[41,0,41,4],[43,2,43,4],[42,2,42,4],[1,0,1,4],[2,2,2,4],[3,2,3,4],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,0,13,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[18,0,18,3],[57,0,57,3],[58,0,58,3],[59,0,59,3],[45,0,45,3],[46,0,46,3],[52,0,52,3],[53,0,53,3],[54,0,54,3],[55,0,55,3],[56,0,56,3],[47,0,47,3],[48,0,48,3],[49,0,49,3],[50,0,50,3],[51,0,51,3],[95,0,95,3],[93,2,93,4],[96,0,96,3],[97,0,97,3],[98,0,98,3],[99,0,99,3],[100,0,100,3],[101,0,101,3],[102,0,102,3],[103,0,103,3],[104,0,104,3],[105,0,105,3],[106,0,106,3],[107,0,107,3],[108,0,108,3],[109,0,109,3],[110,0,110,3],[117,0,117,3],[118,0,118,3],[116,0,116,3],[111,0,111,3],[112,0,112,3],[113,0,113,3],[114,0,114,3],[115,0,115,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assortiment de Mignardises (56 piéces)",{"$f":"56*0.99","v":55.44},1,0.1,{"$f":"+S1*(1+U1)","v":60.984000000000002}]
["PATISSERIE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mini-macarons",1.1000000000000001,1,0.1,1.2100000000000002]
["DEVIS ","date","heure de la prestation",null,null,null,null,"00:30:00",null,null,null,null,null,null,null,null,null,"Pain au chocolat",null,1,0.1,0]
[{"$f":"+'DEVIS AURI'!$F$10","v":0},{"$f":"+'DEVIS AURI'!$B$29","v":"00:00:00"},{"$f":"('DEVIS AURI'!$B$30)-$H$3","v":-2.0833333333333332E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pain aux Raisins",null,1,0.1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Croissant",null,1,0.1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chausson aux Pommes",null,1,0.1,0]
["Assortiment de Mignardises (56 piéces)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A7,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Mini pain au chocolat",0.7,1,0.1,0.77]
["Mini-macarons(par 12)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A8,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Mini Croissant",0.7,1,0.1,0.77]
["Pain aux Raisins",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A9,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Mini Pain aux raisins",0.7,1,0.1,0.77]
["Croissant",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A10,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Assortiment de mini viennoisseries",0.7,1,0.1,0.77]
["Chausson aux Pommes",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A11,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Brioche (6 parts)",6,1,0.1,6.6000000000000005]
["Mini pain au chocolat",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A12,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Brownie (12 parts)",26.4,1,0.1,29.04]
["Mini Croissant",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A13,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Cake (12 parts)",17.55,1,0.1,19.305000000000003]
["Mini Pain aux raisins",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A14,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Cannelés",0.85,1,0.1,0.93500000000000005]
["Brioche (6 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A15,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Corbeille de fruits (10 personnes)",40,1,0.1,44]
["Brownie (12 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A16,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Pain Surprise (50 sandwichs)",36,1,0.1,39.6]
["Cake (12 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A17,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Pâtisserie (part individuelle)",1.5,1,0.1,1.6500000000000001]
["Cannelés",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A18,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Salade de fruits",1.8,1,0.1,1.9800000000000002]
["Corbeille de fruits (10 personnes)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A19,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Tarte aux fruits de saison (10/12 parts)",24.7,1,0.1,27.17]
["Salade de fruits",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A20,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Tarte aux fruits de saison (6/8 parts)",17.489999999999998,1,0.1,19.239000000000001]
["Tarte aux fruits de saison (10/12 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A21,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Sandwich Jambon Beurre",2.5499999999999998,1,0.1,2.8050000000000002]
["Tarte aux fruits de saison (6/8 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A22,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Sandwich Jambon Emmental",3.5,1,0.1,3.8500000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandwich Poulet",3.5,1,0.1,3.8500000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandwich Végétarien",3.5,1,0.1,3.8500000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandwich Thon",4,1,0.1,4.4000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandwich Saumon",4,1,0.1,4.4000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quiche loraine (8 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quiche tomate chèvre (8 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quiche Poulet (8 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Ronde  3 Fromages (1 part)",4.0999999999999996,1,0.1,4.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Ronde  Poulet (1 part)",4.0999999999999996,1,0.1,4.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Ronde  Végétarienne (1 part)",4.0999999999999996,1,0.1,4.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Carrée 3 Fromages (1 part)",3.9,1,0.1,4.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Carrée Poulet (1 part)",3.9,1,0.1,4.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Carrée  Végétarienne (1 part)",3.9,1,0.1,4.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Plaque 3 Fromages (6 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Plaque Poulet (6 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Plaque Végétarienne (6 parts)",23.4,1,0.1,25.740000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Ronde (1 personne)",4.0999999999999996,1,0.1,4.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Carrée (1 part)",3.9,1,0.1,4.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pizza Plaque (6 parts)",23.4,1,0.1,25.740000000000002]
["CHAUD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thermos de café avec matériel",20,1,0.1,22]
["DEVIS ","date","heure de la prestation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thermos de thé avec matériel",13,1,0.1,14.3]
[{"$f":"+'DEVIS AURI'!$F$10","v":0},{"$f":"+'DEVIS AURI'!$B$29","v":"00:00:00"},{"$f":"('DEVIS AURI'!$B$30)-$H$3","v":-2.0833333333333332E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eau de source 0,5 l (24 pièces)",{"$f":"24*0.7","v":16.799999999999997},1,0.1,18.479999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eau de source 1,5 l (6 pièces)",{"$f":"1.3*6","v":7.8000000000000007},1,0.1,8.5800000000000018]
["Quiche loraine (8 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A46,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Eau pétillante 1 l (6 pièces)",{"$f":"2.1*6","v":12.600000000000001},1,0.1,13.860000000000003]
["Quiche tomate chèvre (8 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A47,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Jus de pamplemouse 1l",3.8,1,0.1,4.18]
["Quiche Poulet (8 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A48,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Jus d'orange 1l",3.8,1,0.1,4.18]
["Pizza Ronde  3 Fromages (1 part)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A49,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Lait",1.8,2,0.2,2.16]
["Pizza Ronde  Poulet (1 part)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A50,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"ChampagneDevaux Brut",28.8,2,0.2,34.56]
["Pizza Ronde  Végétarienne (1 part)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A51,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Cidre",6.6,2,0.2,7.919999999999999]
["Pizza Carrée 3 Fromages (1 part)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A52,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Crémant de Loire",12,2,0.2,14.399999999999999]
["Pizza Carrée Poulet (1 part)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A53,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Vin rouge (75 cl)",15.1,2,0.2,{"$f":"+S53*(1+U53)","v":18.119999999999997}]
["Pizza Carrée  Végétarienne (1 part)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A54,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Vin Blanc (75 cl)",15.1,2,0.2,{"$f":"+S54*(1+U54)","v":18.119999999999997}]
["Pizza Plaque 3 Fromages (6 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A55,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Vin Rosé (75 cl)",15.1,2,0.2,{"$f":"+S55*(1+U55)","v":18.119999999999997}]
["Pizza Plaque Poulet (6 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A56,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Droit de bouchon",5.8,2,0.2,6.96]
["Pizza Plaque Végétarienne (6 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A57,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Forfait Vaisselle Jetable (assiette, gobelet, serviette, couverts)",1.5,2,0.2,1.7999999999999998]
["Pizza Ronde (1 personne)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A58,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Verre cristal jetable (part 100)",18,2,0.2,21.599999999999998]
["Pizza Carrée (1 part)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A59,'DEVIS AURI'!$C$39:$C$56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Serviettes (paquet de 100)",10,2,0.2,{"$f":"+S59*(1+U59)","v":12}]
["Pizza Plaque (6 parts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A60,'DEVIS AURI'!$C$39:$C$56)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["GRIGNOTE"]
["DEVIS ","date","heure de la prestation"]
[{"$f":"+'DEVIS AURI'!$F$10","v":0},{"$f":"+'DEVIS AURI'!$B$29","v":"00:00:00"},{"$f":"('DEVIS AURI'!$B$30)-$H$3","v":-2.0833333333333332E-2}]
[]
["Assortiment de Canapés salés (48 piéces)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A81,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Pain Surprise (50 sandwichs)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A82,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Sandwich Jambon Beurre",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A83,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Sandwich Jambon Emmental",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A84,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Sandwich Poulet",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A85,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Sandwich Végétarien",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A86,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Sandwich Thon",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A87,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Sandwich Saumon",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A88,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Bol de crudité et sa sauce (le bol)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A89,'DEVIS AURI'!$C$39:$C$56)","v":0}]
[]
[]
["BANQUET"]
["DEVIS ","date","heure de la prestation"]
[{"$f":"+'DEVIS AURI'!$F$10","v":0},{"$f":"+'DEVIS AURI'!$B$29","v":"00:00:00"},{"$f":"('DEVIS AURI'!$B$30)-$H$3","v":-2.0833333333333332E-2}]
[]
["Pause Café",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A96,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Petit Déjeuner Complet (boisson chaude, jus, viennoisserie)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A97,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Thermos de café avec matériel",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A98,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Thermos de thé avec matériel",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A99,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Thermos de café avec matériel (20 personnes)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A100,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Thermos de thé avec matériel (10 personnes)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A101,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Eau de source 0,5 l (24 pièces)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A102,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Eau de source 1,5 l (6 pièces)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A103,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Eau de source 1,5 l (1 bouteille)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A104,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Eau pétillante 1 l (6 pièces)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A105,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Jus de pamplemouse 1l",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A106,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Jus d'orange 1l",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A107,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Lait 1l",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A108,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["ChampagneDevaux Brut 75cl",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A109,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Cidre 75cl",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A110,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Crémant de Loire 75cl",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A111,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Vin rouge (75 cl)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A112,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Vin Blanc (75 cl)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A113,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Vin Rosé (75 cl)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A114,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Droit de bouchon",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A115,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Forfait Vaisselle Jetable (assiette, gobelet, serviette, couverts)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A116,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Flutes jetable (par 10)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A117,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Verre cristal jetable (part 50)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A118,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Serviettes (paquet de 100)",null,null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,PREPARATION!A119,'DEVIS AURI'!$C$39:$C$56)","v":0}]

{"sheet":"Feuil1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"pdj","index":5,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":true,"merged":[[44,2,44,3],[47,0,47,2],[48,0,48,2],[49,0,49,2],[30,2,30,3],[31,2,31,3],[10,0,10,3],[11,0,13,3],[14,2,14,3],[15,2,15,3],[0,0,1,3],[2,1,2,3],[3,0,5,0],[3,2,3,3],[6,0,7,0],[7,2,7,3],[5,1,6,1],[5,2,6,3]]}
["BON   DE  FABRICATION PETIT DEJEUNER"]
[]
["devis",{"$f":"+'DEVIS AURI'!F10","v":0}]
[null,"DATE :",{"$f":"+'DEVIS AURI'!B29","v":"00:00:00"}]
[null,"HEURE :",{"$f":"+'DEVIS AURI'!B30-M5","v":-2.0833333333333332E-2},null,null,null,null,null,null,null,null,null,"00:30:00"]
[null,"LIEU :",{"$f":"+'DEVIS AURI'!B31","v":"Choisir un lieu"}]
[]
[null,"A EMPORTER :",{"$f":"+'DEVIS AURI'!B32","v":""}]
[]
["Nombre :",{"$f":"+'DEVIS AURI'!B17","v":0}]
["NATURE DE LA PRESTATION"]
[]
[]
[]
["FABRICATION ET SORTIES",null,"Boissons  chaudes"]
[]
[null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,D17,'DEVIS AURI'!$C$39:$C$56)","v":0},"Thermos de café avec matériel (20 personnes)"]
[null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,D18,'DEVIS AURI'!$C$39:$C$56)","v":0},"Thermos de thé avec matériel (10 personnes)"]
[null,null,{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,D19,'DEVIS AURI'!$C$39:$C$56)","v":0},"lait 1l"]
[null,null,"XX","sucre"]
[null,null,"XX","sachet de thé"]
[null,null,"XX","agitateur"]
[{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,B23,'DEVIS AURI'!$C$39:$C$56)","v":0},"mini croissant","XX","serviette"]
[{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,B24,'DEVIS AURI'!$C$39:$C$56)","v":0},"mini pain au chocolat","XX","gobelet à café"]
[{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,B25,'DEVIS AURI'!$C$39:$C$56)","v":0},"mini pain aux raisins","XX","gobelet à thé"]
[null,null,"XX","Verre cristal"]
[null,null,null,"nappe en papier"]
[null,null,null,"ciseaux + scotch"]
[null,null,null,"nappe en tissu"]
[null,null,1,"sac poubelle"]
["BOISSON ECONOMAT",null,"RETOURS  BOISSONS"]
[]
["Eau de source 1,5 l (1 bouteille)",{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,A33,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Jus de pamplemouse 1l",{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,A34,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["Jus d'orange 1l",{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,A35,'DEVIS AURI'!$C$39:$C$56)","v":0}]
["autre",{"$f":"SUMIF('DEVIS AURI'!$B$39:$B$56,A36,'DEVIS AURI'!$C$39:$C$56)","v":0}]
[]
[]
[]
[]
["Viennoiseries"]
[null,{"$f":"+'DEVIS AURI'!B22","v":0}]
["pour le :",null,{"$f":"+'DEVIS AURI'!B29","v":"00:00:00"}]
[]
["Heure :",null,{"$f":"+'DEVIS AURI'!B30-M45","v":-3.125E-2},null,null,null,null,null,null,null,null,null,"00:45:00"]
[]
[]
["mini pain au chocolat",null,null,{"$f":"+A24","v":0}]
["mini croissant",null,null,{"$f":"+A23","v":0}]
["mini pain aux raisins",null,null,{"$f":"+A25","v":0}]
[]
[]
["Merci"]