{"text_format":"1","workbook":"xlsx","n_sheets":38,"sheets":["EAN 13","ACCUEIL","BASE DE DONNEES","Base","Facture","LISTE COMMANDES","DETAIL COMMANDES","COMMANDES FOURNISSEUR","RECEPTION MARCHANDISE","Produits stock zero","Produits stock mini","PARAMETRES","BOUTONS FAMILLE1","INVENTAIRE","DETAIL INVENTAIRES","LISTE INVENTAIRES","ETIQUETTES","PRODUITS ETIQUETTES","DEMARQUE","CLIENTS","ENCAISSEMENT MOIS","LISTE TICKETS","ZED-CAISSE","Utilisateurs","FDC","GESTION FIDELITE","Fournisseurs","BOUTONS","FAMILLES","Encaissements","Z-CAISSE","PERIODE VENTE","X-CAISSE","SAUVEGARDE VENTE","TACHES A REALISER","LISTE RECEPTIONS","PRELEVEMENT","LISTE PRELEVEMENTS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":127,"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":"EAN 13","index":0,"n_rows":37,"n_cols":28,"rows_kept":37,"cut":false,"hidden":true,"merged":[[35,14,35,19],[35,20,35,26],[36,14,36,19],[36,20,36,26],[33,14,33,19],[33,20,33,26],[34,14,34,19],[34,20,34,26],[31,14,31,19],[31,20,31,26],[32,14,32,19],[32,20,32,26],[29,14,29,19],[29,20,29,26],[30,14,30,19],[30,20,30,26],[27,14,27,19],[27,20,27,26],[28,14,28,19],[28,20,28,26],[25,14,25,19],[25,20,25,26],[26,14,26,19],[26,20,26,26],[23,14,23,19],[23,20,23,26],[24,14,24,19],[24,20,24,26],[21,14,21,19],[21,20,21,26],[22,14,22,19],[22,20,22,26],[19,14,19,19],[19,20,19,26],[20,14,20,19],[20,20,20,26],[17,14,17,19],[17,20,17,26],[18,14,18,19],[18,20,18,26],[16,14,16,19],[13,14,13,19],[13,20,13,26],[14,14,14,19],[14,20,14,26],[15,14,15,19],[15,20,15,26],[35,0,35,5],[35,6,35,12],[31,0,31,5],[31,6,31,12],[32,0,32,5],[32,6,32,12],[29,0,29,5],[36,0,36,5],[36,6,36,12],[33,0,33,5],[33,6,33,12],[34,0,34,5],[34,6,34,12],[29,6,29,12],[30,0,30,5],[30,6,30,12],[27,0,27,5],[27,6,27,12],[28,0,28,5],[28,6,28,12],[25,0,25,5],[25,6,25,12],[26,0,26,5],[26,6,26,12],[23,0,23,5],[23,6,23,12],[24,0,24,5],[24,6,24,12],[21,0,21,5],[21,6,21,12],[22,0,22,5],[22,6,22,12],[19,0,19,5],[19,6,19,12],[20,0,20,5],[20,6,20,12],[17,0,17,5],[17,6,17,12],[18,0,18,5],[18,6,18,12],[15,0,15,5],[15,6,15,12],[16,0,16,5],[16,6,16,12],[13,0,13,5],[13,6,13,12],[14,0,14,5],[14,6,14,12],[12,14,12,26],[16,20,16,26],[12,0,12,12],[8,0,8,12],[10,16,10,17],[10,18,10,22],[8,16,8,23],[5,21,5,26],[6,14,6,20],[7,7,7,12],[6,7,6,12],[5,7,5,12],[10,2,10,5],[10,6,10,11],[10,0,10,1],[6,21,6,26],[2,7,2,12],[3,0,3,6],[4,0,4,6],[4,7,4,12],[5,0,5,6],[6,0,6,6],[5,14,5,20],[1,0,1,26],[0,0,0,26],[2,21,2,26],[3,14,3,20],[3,21,3,26],[4,14,4,20],[4,21,4,26],[3,7,3,12],[2,14,2,20],[2,0,2,6]]}
["Les codes EAN 13 et EAN 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La police EAN13.TTF est à copier dans Windows\\Fonts"]
["Le code EAN 13 utilisé sur les articles de consommation courante permet le codage de 12 chiffres, le treizième chiffre étant une clé de contrôle.\nLe code EAN 8 ressemble beaucoup à l'EAN 13, mais ne comporte que 7 chiffres, plus un chiffre de contrôle."]
["Code",null,null,null,null,null,null,"Code Barre EAN 13",null,null,null,null,null,null,"Code",null,null,null,null,null,null,"Code Barre EAN 8"]
[532164863567,null,null,null,null,null,null,{"$f":"_EAN13(A4)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,6435124,null,null,null,null,null,null,{"$f":"_EAN8(O4)","v":{"$error":"#NAME?"}}]
[3600480831605,null,null,null,null,null,null,{"$f":"_EAN13(A5)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,8946478,null,null,null,null,null,null,{"$f":"_EAN8(O5)","v":{"$error":"#NAME?"}}]
[3600500831608,null,null,null,null,null,null,{"$f":"_EAN13(A6)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,4568795,null,null,null,null,null,null,{"$f":"_EAN8(O6)","v":{"$error":"#NAME?"}}]
[3600010836605,null,null,null,null,null,null,{"$f":"_EAN13(A7)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,4568486,null,null,null,null,null,null,{"$f":"_EAN8(O7)","v":{"$error":"#NAME?"}}]
[]
["Structure d'un code EAN 13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Structure d'un code EAN 8"]
[]
["Code pays",null,"Code fabricant",null,null,null,"Code article",null,null,null,null,null,"Clé",null,null,null,"Code pays",null,"Code article",null,null,null,null,"Clé"]
[]
["Liste des codes pays ou système",null,null,null,null,null,null,null,null,null,null,null,null,null,"Liste des codes pays ou système"]
["00 à 13 UCC (Etats-Unis et Canada)",null,null,null,null,null,"628 EAN Arabie Saoudite",null,null,null,null,null,null,null,"489 HKANA (Hong Kong)",null,null,null,null,null,"80 à 83 INDICOD (Italie)"]
["20 à 29 Codification interne en magasin",null,null,null,null,null,"64 EAN Finlande",null,null,null,null,null,null,null,"50 E Centre UK",null,null,null,null,null,"84 AECOC (Espagne)"]
["30 à 37 GENCOD-EAN France",null,null,null,null,null,"690 - 693 Article Numbering Centre of China - ANCC (Chine)",null,null,null,null,null,null,null,"520 HELLCAN-EAN HELLAS (Grèce)",null,null,null,null,null,"850 Camera de Comercio de la Republica de Cuba (Cuba)"]
["380 BCCI (Bulgarie)",null,null,null,null,null,"70 EAN Norge (Norvège)",null,null,null,null,null,null,null,"528 EAN Liban",null,null,null,null,null,"858 EAN Slovaquie"]
["383 SANA (Slovénie)",null,null,null,null,null,"729 Israeli Bar Code Association – EAN Israël",null,null,null,null,null,null,null,"529 EAN Chypre",null,null,null,null,null,"859 EAN République Tchèque"]
["385 CRO-EAN (Croatie)",null,null,null,null,null,"73 EAN Suède",null,null,null,null,null,null,null,"531 EAN-MAC (FYR Macédonie)",null,null,null,null,null,"860 EAN YU (Yougoslavie)"]
["387 EAN-BIH (Bosnie-Herzégovine)",null,null,null,null,null,"740 EAN Guatemala",null,null,null,null,null,null,null,"535 EAN Malte",null,null,null,null,null,"867 EAN DPR Korea (Corée du Nord)"]
["400 à 440 CCG (Allemagne)",null,null,null,null,null,"741 EAN El Salvador",null,null,null,null,null,null,null,"539 EAN Irlande",null,null,null,null,null,"869 Union of Chambers of Commerce of Turkey (Turquie)"]
["45 + 49 Distribution Code Center – DCC (Japon)",null,null,null,null,null,"742 ICCC (Honduras)",null,null,null,null,null,null,null,"54 ICODIF/EAN Belgique. Luxembourg",null,null,null,null,null,"87 EAN Nederland (Hollande)"]
["460 à 469 UNISCAN - EAN Russie (Fédération de Russie)",null,null,null,null,null,"743 EAN Nicaragua",null,null,null,null,null,null,null,"560 CODIPOR (Portugal)",null,null,null,null,null,"880 EAN Korea (Corée du Sud)"]
["471 CAN (Taiwan)",null,null,null,null,null,"744 EAN Costa Rica Panama",null,null,null,null,null,null,null,"569 EAN Islande",null,null,null,null,null,"885 EAN Thaï lande"]
["474 EAN Estonie",null,null,null,null,null,"746 746 EAN République Dominicaine",null,null,null,null,null,null,null,"57 EAN Danemark",null,null,null,null,null,"888 SANC (Singapour)"]
["475 EAN Lettonie",null,null,null,null,null,"750 AMECE (Mexique)",null,null,null,null,null,null,null,"590 EAN Pologne",null,null,null,null,null,"890 EAN Inde"]
["476 EAN Azerbaï djan",null,null,null,null,null,"759 EAN Venezuela",null,null,null,null,null,null,null,"594 EAN Roumanie",null,null,null,null,null,"893 EAN Vietnam"]
["477 EAN Lituanie",null,null,null,null,null,"76 EAN (Schweiz, Suisse, Svizzera)",null,null,null,null,null,null,null,"599 H.A.P.M.H. (Hongrie)",null,null,null,null,null,"899 EAN Indonésie"]
["478 EAN Ouzbékistan",null,null,null,null,null,"770 IAC (Colombie)",null,null,null,null,null,null,null,"600 - 601 EAN Afrique du Sud",null,null,null,null,null,"90 - 91 EAN Autriche"]
["479 EAN Sri Lanka",null,null,null,null,null,"773 EAN Uruguay",null,null,null,null,null,null,null,"609 EAN Ile Maurice",null,null,null,null,null,"93 EAN Australie"]
["480 PANC (Philippines)",null,null,null,null,null,"775 APC - EAN Peru (Pérou)",null,null,null,null,null,null,null,"611 EAN Maroc",null,null,null,null,null,"94 EAN Nouvelle Zélande"]
["481 EAN Biélorussie",null,null,null,null,null,"777 EAN Bolivie",null,null,null,null,null,null,null,"613 EAN Algérie",null,null,null,null,null,"955 Malaysian Article Numbering Council (MANC) - Malaisie"]
["482 EAN Ukraine",null,null,null,null,null,"779 CODIGO - EAN Argentine",null,null,null,null,null,null,null,"619 Tunicode (Tunisie)",null,null,null,null,null,"977 Publications sérielles (ISSN)"]
["484 EAN Moldavie",null,null,null,null,null,"780 EAN Chili",null,null,null,null,null,null,null,"621 EAN Syrie",null,null,null,null,null,"978 - 979 Livres (ISBN)"]
["485 EAN Arménie",null,null,null,null,null,"784 EAN Paraguay",null,null,null,null,null,null,null,"622 EAN Egypte",null,null,null,null,null,"980 Reçus de remboursement"]
["486 EAN Georgie",null,null,null,null,null,"786 ECOP (Equateur)",null,null,null,null,null,null,null,"625 EAN Jordanie",null,null,null,null,null,"981 - 982 Coupons (monnaie courante)"]
["487 EAN Kazakhstan",null,null,null,null,null,"789 EAN Brésil",null,null,null,null,null,null,null,"626 EAN Iran",null,null,null,null,null,"99 Coupons"]

{"sheet":"ACCUEIL","index":1,"n_rows":2,"n_cols":18,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Laissez vide↓","Gencode","Désignation","Prix vente TTC","Laissez vide↓","Conditionnement","Laissez vide↓","Unité de vente: les unitées de vente sont Kg,litre, Botte, U, Pièce, lot          ","Laissez vide↓","Prix d'Achat HT","Fournisseur","Famille de produits","Qté en Stock ","Laissez vide↓","Type vente (Standard ou Vrac)","Laissez vide↓","Gestion stock:           Si vous voulez que le stock du produit soit géré mettez GS sinon laissez vide     ","Stock minimum"]

{"sheet":"BASE DE DONNEES","index":2,"n_rows":1,"n_cols":52,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Réf","Gencode","Produit","Prix vente TTC","Taux TVA","Conditionnement","PRIX UNITAIRE","Unité de vente","Chaine","Prix d'Achat HT","Fournisseur","Famille","Stock Initial","Total achat","Type vente","Stock","GESTION STOCK","Type démarque","Qté démarque","Date début","Date fin","Prix promo","Inventaire","Situation promo","Stock mini","Qté","Gencode","Produit","Prix vente TTC","Taux TVA","Conditionnement","PRIX UNITAIRE","Unité de vente","Chaine","Prix d'Achat HT","Fournisseur","Famille","Stock Initial","Total achat","Type vente","Stock","GESTION STOCK","Type démarque","Qté démarque","Date début","Date fin","Prix promo","Inventaire","Situation promo","Stock mini","Qté",{"$f":"COUNT(A:A)","v":0}]

{"sheet":"Base","index":3,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["CODE ","NOM ","CP","TEL","SOLDE","NB ACHAT","POINTS","REMISE","VILLE","DERNIER PASSAGE","ADRESSE",null,{"$f":"MAX(Base!A:A)","v":1}]
[1,"TALEB",83660,null,null,null,null,null,"CARNOULES"]

{"sheet":"Facture","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,11,5],[0,1,0,5],[6,1,6,5],[1,1,1,5],[2,1,2,5],[3,1,3,5],[4,1,4,5],[5,1,5,5],[10,1,10,3]]}
[null,"La source bleue"]
[null,null,null,null,null,null,"Manager"]
[]
[]
[]
[]
[]
[null,"Client","Ancien solde","Nouveau solde","Remise"]
[null,null,null,null,null,{"$f":"G2","v":"Manager"},"Total ticket","Total tva","Total remise"]
[null,null,"Ticket N°:",1,"Date","Heure",{"$f":"SUM(F14:F100)","v":0},{"$f":"SUM(G14:G100)","v":0},{"$f":"SUM(H14:H100)","v":0}]
[null,"Vous avez été servi par Manager",null,null,{"$f":"TODAY()","v":"2018-01-22"},{"$f":"NOW()","v":43122.985230671293},{"$f":"FAMILLES!$A14","v":0},{"$f":"FAMILLES!$A15","v":0},{"$f":"FAMILLES!$A16","v":0}]
[null,null,null,null,null,null,{"$f":"SUMIF($J$14:$J$90,$G$11,$G$14:$G$90)","v":0},{"$f":"SUMIF($J$14:$J$90,$H$11,$G$14:$G$90)","v":0},{"$f":"SUMIF($J$14:$J$90,$I$11,$G$14:$G$90)","v":0}]
["Réf","Produit","Qté","Prix","% Remise","Montant","Mnt tva","Mnt remise","Famille","Taux TVA"]

{"sheet":"LISTE COMMANDES","index":5,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["N° Commande","Fournisseur","Date"]

{"sheet":"DETAIL COMMANDES","index":6,"n_rows":2,"n_cols":23,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["N° Commande","Gencode","Produit","Qté","Fournisseur","Date","N° Commande","Fournisseur","Date","Produit","N° Commande","Gencode","Produit","Qté","Fournisseur","Date",null,"N° Commande","Fournisseur","Date",null,"FOURNISSEUR 2",{"$f":"COUNTIF(E:E,V1)","v":0}]
[null,null,null,null,null,null,null,null,null,"OURLET MAIN"]

{"sheet":"COMMANDES FOURNISSEUR","index":7,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,2,3]]}
[{"$f":"\"Commande du \" & \" \" &TEXT(TODAY(),\"jjjj jj mmmm aaaa\")","v":"Commande du  lundi 22 janvier 2018"},null,null,null,"Fournisseur"]
[null,null,null,null,"FOURNISSEUR 1"]
[]
["Gencode","Produit","Qté","Fournisseur"]

{"sheet":"RECEPTION MARCHANDISE","index":8,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["N° Facture","Gencode","Produit","Qté","Fournisseur","Date","N° Facture","Fournisseur","Date","Produit","N° Facture","Gencode","Produit","Qté","Fournisseur","Date"]
[null,null,null,null,null,null,null,null,null,"SAUCE TOMATE 180G"]

{"sheet":"Produits stock zero","index":9,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Liste produits en rupture de stock"]
["Gencode","Produit","Fournisseur","Famille"]

{"sheet":"Produits stock mini","index":10,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Liste produits avec stock minimum"]
["Gencode","Produit","Fournisseur","Famille","Qté"]

{"sheet":"PARAMETRES","index":11,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Entreprise","Adresse","Complément adresse","CP","Ville","Tél","Fax","SIRET","Taux TVA","Enseigne","Pied de page","N° TVA","AUTO-ENTREPRENEUR","Répertoire Z-caisse","FAMILLE PRINCIPALE","Devise ","Répertoire tickets de caisse"]
["La source Bleue","65 Mail de la Planquette","bat A la marjolaine",83130,"La Garde","04 94 23 46 80","06 19 06 45 24",null,null,null,"Merci de votre visite et à très bientôt",null,"Non",null,null,"€"]

{"sheet":"BOUTONS FAMILLE1","index":12,"n_rows":25,"n_cols":40,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,7],[0,8,0,11],[0,12,0,15],[0,16,0,19],[0,20,0,23],[0,24,0,27],[0,28,0,31],[0,32,0,35],[0,36,0,39]]}
[{"$f":"FAMILLES!B2","v":"FAMILLE 1"},null,null,null,{"$f":"FAMILLES!B3","v":"FAMILLE 2"},null,null,null,{"$f":"FAMILLES!B4","v":"FAMILLE 3"},null,null,null,{"$f":"FAMILLES!B5","v":"FAMILLE 4"},null,null,null,{"$f":"FAMILLES!B6","v":"FAMILLE 5"},null,null,null,{"$f":"FAMILLES!B7","v":"FAMILLE 6"},null,null,null,{"$f":"FAMILLES!B8","v":"FAMILLE 7"},null,null,null,{"$f":"FAMILLES!B9","v":"FAMILLE 8"},null,null,null,{"$f":"FAMILLES!B10","v":"FAMILLE 9"},null,null,null,{"$f":"FAMILLES!B11","v":"FAMILLE 10"}]
["CommandButton1","1,4",null,"Famille1","CommandButton1",1,null,"Famille2","CommandButton1",1,null,"Famille3","CommandButton1","CRISTALINE 50CL 0,60 €","CRISTALINE 50CL","Famille4","CommandButton1",1,null,"Famille5","CommandButton1",1,null,"Famille6","CommandButton1","SUCRE EN MORCEAUX 1KG   1,90 €","SUCRE EN MORCEAUX 1KG","Famille7","CommandButton1",1,null,"Famille8","CommandButton1",1,null,"Famille9","CommandButton1",1,null,"Famille10"]
["CommandButton2","1,4",null,"Famille1","CommandButton2",2,null,"Famille2","CommandButton2",2,null,"Famille3","CommandButton2",2,null,"Famille4","CommandButton2",2,null,"Famille5","CommandButton2",2,null,"Famille6","CommandButton2",2,null,"Famille7","CommandButton2",2,null,"Famille8","CommandButton2",2,null,"Famille9","CommandButton2",2,null,"Famille10"]
["CommandButton3","1,4",null,"Famille1","CommandButton3",3,null,"Famille2","CommandButton3",3,null,"Famille3","CommandButton3",3,null,"Famille4","CommandButton3",3,null,"Famille5","CommandButton3",3,null,"Famille6","CommandButton3",3,null,"Famille7","CommandButton3",3,null,"Famille8","CommandButton3",3,null,"Famille9","CommandButton3",3,null,"Famille10"]
["CommandButton4","1,4",null,"Famille1","CommandButton4",4,null,"Famille2","CommandButton4",4,null,"Famille3","CommandButton4",4,null,"Famille4","CommandButton4",4,null,"Famille5","CommandButton4",4,null,"Famille6","CommandButton4",4,null,"Famille7","CommandButton4",4,null,"Famille8","CommandButton4",4,null,"Famille9","CommandButton4",4,null,"Famille10"]
["CommandButton5","1,4",null,"Famille1","CommandButton5",5,null,"Famille2","CommandButton5",5,null,"Famille3","CommandButton5",5,null,"Famille4","CommandButton5",5,null,"Famille5","CommandButton5",5,null,"Famille6","CommandButton5",5,null,"Famille7","CommandButton5",5,null,"Famille8","CommandButton5",5,null,"Famille9","CommandButton5",5,null,"Famille10"]
["CommandButton6","1,4",null,"Famille1","CommandButton6",6,null,"Famille2","CommandButton6",6,null,"Famille3","CommandButton6",6,null,"Famille4","CommandButton6",6,null,"Famille5","CommandButton6",6,null,"Famille6","CommandButton6",6,null,"Famille7","CommandButton6",6,null,"Famille8","CommandButton6",6,null,"Famille9","CommandButton6",6,null,"Famille10"]
["CommandButton7","1,4",null,"Famille1","CommandButton7",7,null,"Famille2","CommandButton7",7,null,"Famille3","CommandButton7",7,null,"Famille4","CommandButton7",7,null,"Famille5","CommandButton7",7,null,"Famille6","CommandButton7",7,null,"Famille7","CommandButton7",7,null,"Famille8","CommandButton7",7,null,"Famille9","CommandButton7",7,null,"Famille10"]
["CommandButton8","1,4",null,"Famille1","CommandButton8",8,null,"Famille2","CommandButton8",8,null,"Famille3","CommandButton8",8,null,"Famille4","CommandButton8",8,null,"Famille5","CommandButton8",8,null,"Famille6","CommandButton8",8,null,"Famille7","CommandButton8",8,null,"Famille8","CommandButton8",8,null,"Famille9","CommandButton8",8,null,"Famille10"]
["CommandButton9","1,4",null,"Famille1","CommandButton9",9,null,"Famille2","CommandButton9",9,null,"Famille3","CommandButton9",9,null,"Famille4","CommandButton9",9,null,"Famille5","CommandButton9",9,null,"Famille6","CommandButton9",9,null,"Famille7","CommandButton9",9,null,"Famille8","CommandButton9",9,null,"Famille9","CommandButton9",9,null,"Famille10"]
["CommandButton10","1,4",null,"Famille1","CommandButton10",10,null,"Famille2","CommandButton10",10,null,"Famille3","CommandButton10",10,null,"Famille4","CommandButton10",10,null,"Famille5","CommandButton10",10,null,"Famille6","CommandButton10",10,null,"Famille7","CommandButton10",10,null,"Famille8","CommandButton10",10,null,"Famille9","CommandButton10",10,null,"Famille10"]
["CommandButton11","1,4",null,"Famille1","CommandButton11",11,null,"Famille2","CommandButton11",11,null,"Famille3","CommandButton11",11,null,"Famille4","CommandButton11",11,null,"Famille5","CommandButton11",11,null,"Famille6","CommandButton11",11,null,"Famille7","CommandButton11",11,null,"Famille8","CommandButton11",11,null,"Famille9","CommandButton11",11,null,"Famille10"]
["CommandButton12","1,4",null,"Famille1","CommandButton12",12,null,"Famille2","CommandButton12",12,null,"Famille3","CommandButton12",12,null,"Famille4","CommandButton12",12,null,"Famille5","CommandButton12",12,null,"Famille6","CommandButton12",12,null,"Famille7","CommandButton12",12,null,"Famille8","CommandButton12",12,null,"Famille9","CommandButton12",12,null,"Famille10"]
["CommandButton13","1,4",null,"Famille1","CommandButton13",13,null,"Famille2","CommandButton13",13,null,"Famille3","CommandButton13",13,null,"Famille4","CommandButton13",13,null,"Famille5","CommandButton13",13,null,"Famille6","CommandButton13",13,null,"Famille7","CommandButton13",13,null,"Famille8","CommandButton13",13,null,"Famille9","CommandButton13",13,null,"Famille10"]
["CommandButton14","1,4",null,"Famille1","CommandButton14",14,null,"Famille2","CommandButton14",14,null,"Famille3","CommandButton14",14,null,"Famille4","CommandButton14",14,null,"Famille5","CommandButton14",14,null,"Famille6","CommandButton14",14,null,"Famille7","CommandButton14",14,null,"Famille8","CommandButton14",14,null,"Famille9","CommandButton14",14,null,"Famille10"]
["CommandButton15","1,4",null,"Famille1","CommandButton15",15,null,"Famille2","CommandButton15",15,null,"Famille3","CommandButton15",15,null,"Famille4","CommandButton15",15,null,"Famille5","CommandButton15",15,null,"Famille6","CommandButton15",15,null,"Famille7","CommandButton15",15,null,"Famille8","CommandButton15",15,null,"Famille9","CommandButton15",15,null,"Famille10"]
["CommandButton16","1,4",null,"Famille1","CommandButton16",16,null,"Famille2","CommandButton16",16,null,"Famille3","CommandButton16",16,null,"Famille4","CommandButton16",16,null,"Famille5","CommandButton16",16,null,"Famille6","CommandButton16",16,null,"Famille7","CommandButton16",16,null,"Famille8","CommandButton16",16,null,"Famille9","CommandButton16",16,null,"Famille10"]
["CommandButton17","1,4",null,"Famille1","CommandButton17",17,null,"Famille2","CommandButton17",17,null,"Famille3","CommandButton17",17,null,"Famille4","CommandButton17",17,null,"Famille5","CommandButton17",17,null,"Famille6","CommandButton17",17,null,"Famille7","CommandButton17",17,null,"Famille8","CommandButton17",17,null,"Famille9","CommandButton17",17,null,"Famille10"]
["CommandButton18","1,4",null,"Famille1","CommandButton18",18,null,"Famille2","CommandButton18",18,null,"Famille3","CommandButton18",18,null,"Famille4","CommandButton18",18,null,"Famille5","CommandButton18",18,null,"Famille6","CommandButton18",18,null,"Famille7","CommandButton18",18,null,"Famille8","CommandButton18",18,null,"Famille9","CommandButton18",18,null,"Famille10"]
["CommandButton19","1,4",null,"Famille1","CommandButton19",19,null,"Famille2","CommandButton19",19,null,"Famille3","CommandButton19",19,null,"Famille4","CommandButton19",19,null,"Famille5","CommandButton19",19,null,"Famille6","CommandButton19",19,null,"Famille7","CommandButton19",19,null,"Famille8","CommandButton19",19,null,"Famille9","CommandButton19",19,null,"Famille10"]
["CommandButton20","1,4",null,"Famille1","CommandButton20",20,null,"Famille2","CommandButton20",20,null,"Famille3","CommandButton20",20,null,"Famille4","CommandButton20",20,null,"Famille5","CommandButton20",20,null,"Famille6","CommandButton20",20,null,"Famille7","CommandButton20",20,null,"Famille8","CommandButton20",20,null,"Famille9","CommandButton20",20,null,"Famille10"]
["CommandButton21","1,4",null,"Famille1","CommandButton21",21,null,"Famille2","CommandButton21",21,null,"Famille3","CommandButton21",21,null,"Famille4","CommandButton21",21,null,"Famille5","CommandButton21",21,null,"Famille6","CommandButton21",21,null,"Famille7","CommandButton21",21,null,"Famille8","CommandButton21",21,null,"Famille9","CommandButton21",21,null,"Famille10"]
["CommandButton22","1,4",null,"Famille1","CommandButton22",22,null,"Famille2","CommandButton22",22,null,"Famille3","CommandButton22",22,null,"Famille4","CommandButton22",22,null,"Famille5","CommandButton22",22,null,"Famille6","CommandButton22",22,null,"Famille7","CommandButton22",22,null,"Famille8","CommandButton22",22,null,"Famille9","CommandButton22",22,null,"Famille10"]
["CommandButton23","1,4",null,"Famille1","CommandButton23",23,null,"Famille2","CommandButton23",23,null,"Famille3","CommandButton23",23,null,"Famille4","CommandButton23",23,null,"Famille5","CommandButton23",23,null,"Famille6","CommandButton23",23,null,"Famille7","CommandButton23",23,null,"Famille8","CommandButton23",23,null,"Famille9","CommandButton23",23,null,"Famille10"]
["CommandButton24","1,4",null,"Famille1","CommandButton24",24,null,"Famille2","CommandButton24",24,null,"Famille3","CommandButton24",24,null,"Famille4","CommandButton24",24,null,"Famille5","CommandButton24",24,null,"Famille6","CommandButton24",24,null,"Famille7","CommandButton24",24,null,"Famille8","CommandButton24",24,null,"Famille9","CommandButton24",24,null,"Famille10"]

{"sheet":"INVENTAIRE","index":13,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,1,4]]}
[{"$f":"\"Inventaire du \" & \" \" &TEXT(TODAY(),\"jjjj jj mmmm aaaa\")","v":"Inventaire du  lundi 22 janvier 2018"}]
[]
["Gencode","Produit","Qté","Date","Libellé inventaire"]

{"sheet":"DETAIL INVENTAIRES","index":14,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["N° Inventaire","Gencode","Produit","Qté","Date","Libellé inventaire","N° Inventaire","Produit","N° Inventaire","Gencode","Produit","Qté","Date","Libellé inventaire"]

{"sheet":"LISTE INVENTAIRES","index":15,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,1,2]]}
["Liste des inventaires"]
[]
["N° Inventaire","Libellé inventaire","Date inventaire"]

{"sheet":"ETIQUETTES","index":16,"n_rows":57,"n_cols":52,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,3,56,4],[56,9,56,10],[28,3,28,4],[28,9,28,10],[35,9,35,10],[35,3,35,4],[42,9,42,10],[42,3,42,4],[29,3,31,8],[29,9,31,14],[32,3,34,5],[32,6,34,8],[32,9,34,11],[32,12,34,14],[36,3,38,8],[36,9,38,14],[12,3,12,4],[12,9,12,10],[20,3,20,4],[20,9,20,10],[6,3,8,8],[6,9,8,14],[9,3,11,5],[9,6,11,8],[9,9,11,11],[9,12,11,14],[14,3,16,8],[14,9,16,14],[17,3,19,5],[17,6,19,8],[17,9,19,11],[17,12,19,14],[39,3,41,5],[21,3,21,8],[21,9,21,14],[22,3,24,8],[22,9,24,14],[25,3,27,5],[25,6,27,8],[25,9,27,11],[25,12,27,14],[39,6,41,8],[39,9,41,11],[39,12,41,14],[53,3,55,5],[53,6,55,8],[53,9,55,11],[53,12,55,14],[43,3,45,8],[43,9,45,14],[46,3,48,5],[46,6,48,8],[46,9,48,11],[46,12,48,14],[50,3,52,8],[50,9,52,14],[49,3,49,4],[49,9,49,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$F1048535=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F1048535&\"  )\")","v":""}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B2=\"\",\"\",'PRODUITS ETIQUETTES'!$B2)","v":""},null,null,null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B3=\"\",\"\",'PRODUITS ETIQUETTES'!$B3)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C2=\"\",\"\",'PRODUITS ETIQUETTES'!$C2)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G2=\"\",\"\",'PRODUITS ETIQUETTES'!$G2)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C3=\"\",\"\",'PRODUITS ETIQUETTES'!$C3)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G3=\"\",\"\",'PRODUITS ETIQUETTES'!$G3)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H2=\"\",\"\",'PRODUITS ETIQUETTES'!H2)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B2=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E2=\"\",\"\",'PRODUITS ETIQUETTES'!$E2))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F2=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F2&\" )\")","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!H3=\"\",\"\",'PRODUITS ETIQUETTES'!H3)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B3=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E3=\"\",\"\",'PRODUITS ETIQUETTES'!$E3))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F3=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F3&\"  )\")","v":""}]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B4=\"\",\"\",'PRODUITS ETIQUETTES'!$B4)","v":""},null,null,null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B5=\"\",\"\",'PRODUITS ETIQUETTES'!$B5)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C4=\"\",\"\",'PRODUITS ETIQUETTES'!$C4)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G4=\"\",\"\",'PRODUITS ETIQUETTES'!$G4)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C5=\"\",\"\",'PRODUITS ETIQUETTES'!$C5)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G5=\"\",\"\",'PRODUITS ETIQUETTES'!$G5)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H4=\"\",\"\",'PRODUITS ETIQUETTES'!H4)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B4=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E4=\"\",\"\",'PRODUITS ETIQUETTES'!$E4))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F4=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F4&\" )\")","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!H5=\"\",\"\",'PRODUITS ETIQUETTES'!H5)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B5=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E5=\"\",\"\",'PRODUITS ETIQUETTES'!$E5))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F5=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F5&\" )\")","v":""}]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B6=\"\",\"\",'PRODUITS ETIQUETTES'!$B6)","v":""},null,null,null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B7=\"\",\"\",'PRODUITS ETIQUETTES'!$B7)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C6=\"\",\"\",'PRODUITS ETIQUETTES'!$C6)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G6=\"\",\"\",'PRODUITS ETIQUETTES'!$G6)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C7=\"\",\"\",'PRODUITS ETIQUETTES'!$C7)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G7=\"\",\"\",'PRODUITS ETIQUETTES'!$G7)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H6=\"\",\"\",'PRODUITS ETIQUETTES'!H6)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B6=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E6=\"\",\"\",'PRODUITS ETIQUETTES'!$E6))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F6=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F6&\" )\")","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!H7=\"\",\"\",'PRODUITS ETIQUETTES'!H7)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B7=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E7=\"\",\"\",'PRODUITS ETIQUETTES'!$E7))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F7=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F7&\" )\")","v":""}]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B8=\"\",\"\",'PRODUITS ETIQUETTES'!$B8)","v":""},null,null,null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B9=\"\",\"\",'PRODUITS ETIQUETTES'!$B9)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C8=\"\",\"\",'PRODUITS ETIQUETTES'!$C8)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G8=\"\",\"\",'PRODUITS ETIQUETTES'!$G8)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C9=\"\",\"\",'PRODUITS ETIQUETTES'!$C9)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G9=\"\",\"\",'PRODUITS ETIQUETTES'!$G9)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H8=\"\",\"\",'PRODUITS ETIQUETTES'!H8)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B8=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E8=\"\",\"\",'PRODUITS ETIQUETTES'!$E8))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F8=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F8&\" )\")","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!H9=\"\",\"\",'PRODUITS ETIQUETTES'!H9)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B9=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E9=\"\",\"\",'PRODUITS ETIQUETTES'!$E9))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F9=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F9&\" )\")","v":""}]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B10=\"\",\"\",'PRODUITS ETIQUETTES'!$B10)","v":""},null,null,null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B11=\"\",\"\",'PRODUITS ETIQUETTES'!$B11)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C10=\"\",\"\",'PRODUITS ETIQUETTES'!$C10)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G10=\"\",\"\",'PRODUITS ETIQUETTES'!$G10)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C11=\"\",\"\",'PRODUITS ETIQUETTES'!$C11)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G11=\"\",\"\",'PRODUITS ETIQUETTES'!$G11)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H10=\"\",\"\",'PRODUITS ETIQUETTES'!H10)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B10=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E10=\"\",\"\",'PRODUITS ETIQUETTES'!$E10))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F10=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F10&\" )\")","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!H11=\"\",\"\",'PRODUITS ETIQUETTES'!H11)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B11=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E11=\"\",\"\",'PRODUITS ETIQUETTES'!$E11))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F11=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F11&\"  )\")","v":""}]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B12=\"\",\"\",'PRODUITS ETIQUETTES'!$B12)","v":""},null,null,null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B13=\"\",\"\",'PRODUITS ETIQUETTES'!$B13)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C12=\"\",\"\",'PRODUITS ETIQUETTES'!$C12)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G12=\"\",\"\",'PRODUITS ETIQUETTES'!$G12)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C13=\"\",\"\",'PRODUITS ETIQUETTES'!$C13)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G13=\"\",\"\",'PRODUITS ETIQUETTES'!$G13)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H12=\"\",\"\",'PRODUITS ETIQUETTES'!H12)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B12=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E12=\"\",\"\",'PRODUITS ETIQUETTES'!$E12))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F12=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F12&\" )\")","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!H13=\"\",\"\",'PRODUITS ETIQUETTES'!H13)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B13=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E13=\"\",\"\",'PRODUITS ETIQUETTES'!$E13))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F13=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F13&\"  )\")","v":""}]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B14=\"\",\"\",'PRODUITS ETIQUETTES'!$B14)","v":""},null,null,null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B15=\"\",\"\",'PRODUITS ETIQUETTES'!$B15)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C14=\"\",\"\",'PRODUITS ETIQUETTES'!$C14)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G14=\"\",\"\",'PRODUITS ETIQUETTES'!$G14)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C15=\"\",\"\",'PRODUITS ETIQUETTES'!$C15)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G15=\"\",\"\",'PRODUITS ETIQUETTES'!$G15)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H14=\"\",\"\",'PRODUITS ETIQUETTES'!H14)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B14=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E14=\"\",\"\",'PRODUITS ETIQUETTES'!$E14))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F14=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F14&\" )\")","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!H15=\"\",\"\",'PRODUITS ETIQUETTES'!H15)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B15=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E15=\"\",\"\",'PRODUITS ETIQUETTES'!$E15))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F15=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F15&\"  )\")","v":""}]

{"sheet":"PRODUITS ETIQUETTES","index":17,"n_rows":57,"n_cols":15,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Gencode","Produit","Prix vente TTC","Conditionnement","Prix unitaire","Unité de vente","Chaine","PROMOTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H8=\"\",\"\",'PRODUITS ETIQUETTES'!H8)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B10=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E10=\"\",\"\",'PRODUITS ETIQUETTES'!$E10))","v":""}]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B12=\"\",\"\",'PRODUITS ETIQUETTES'!$B12)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C12=\"\",\"\",'PRODUITS ETIQUETTES'!$C12)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G12=\"\",\"\",'PRODUITS ETIQUETTES'!$G12)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H10=\"\",\"\",'PRODUITS ETIQUETTES'!H10)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B12=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E12=\"\",\"\",'PRODUITS ETIQUETTES'!$E12))","v":""}]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B14=\"\",\"\",'PRODUITS ETIQUETTES'!$B14)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C14=\"\",\"\",'PRODUITS ETIQUETTES'!$C14)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G14=\"\",\"\",'PRODUITS ETIQUETTES'!$G14)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H12=\"\",\"\",'PRODUITS ETIQUETTES'!H12)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B14=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E14=\"\",\"\",'PRODUITS ETIQUETTES'!$E14))","v":""}]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B16=\"\",\"\",'PRODUITS ETIQUETTES'!$B16)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C16=\"\",\"\",'PRODUITS ETIQUETTES'!$C16)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G16=\"\",\"\",'PRODUITS ETIQUETTES'!$G16)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C17=\"\",\"\",'PRODUITS ETIQUETTES'!$C17)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G17=\"\",\"\",'PRODUITS ETIQUETTES'!$G17)","v":""}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H14=\"\",\"\",'PRODUITS ETIQUETTES'!H14)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B16=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E16=\"\",\"\",'PRODUITS ETIQUETTES'!$E16))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F16=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F16&\" )\")","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!H15=\"\",\"\",'PRODUITS ETIQUETTES'!H15)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B17=\"\",\"\",\"(Soit \")","v":""},{"$f":"(IF('PRODUITS ETIQUETTES'!$E17=\"\",\"\",'PRODUITS ETIQUETTES'!$E17))","v":""},{"$f":"IF('PRODUITS ETIQUETTES'!$F17=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F17&\"  )\")","v":""}]

{"sheet":"DEMARQUE","index":18,"n_rows":10,"n_cols":51,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Gencode","Produit","Prix de vente TTC","Prix d'Achat HT","Fournisseur","Famille","Type ","Qté ","Date","Date début","Date fin","Type","Type ","Date","Date","Gencode","Produit","Prix de vente TTC","Prix d'Achat HT","Fournisseur","Famille","Type ","Qté ","Date","Total",{"$f":"SUM(Y:Y)","v":0},"Produit","Prix de vente TTC","Prix d'Achat HT","Fournisseur","Famille","Type ","Qté ","Date","Date début","Date fin","Type","Type ","Date","Date","Gencode","Produit","Prix de vente TTC","Prix d'Achat HT","Fournisseur","Famille","Type ","Qté ","Date","Total",{"$f":"SUM(AX:AX)","v":0}]
[null,null,null,null,null,null,null,null,null,"2017-09-12","2017-09-13",null,{"$f":"IF(L2=\"\",\"\",L2)","v":""},{"$f":"IF(J2=\"\",\"\",\">=\"&J2)","v":">=42990"},{"$f":"IF(K2=\"\",\"\",\"<=\"&K2)","v":"<=42991"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P3=\"\",\"\",R3*W3)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P4=\"\",\"\",R4*W4)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CLIENTS","index":19,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["N° client","SOCIETÉ","ADRESSE","CODE POSTALE","VILLE","Client","Tél",{"$f":"MAX(A2:A9988)","v":0}]

{"sheet":"ENCAISSEMENT MOIS","index":20,"n_rows":2,"n_cols":28,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["CAISSIER","Date","CA TTC","Espèces"," CB"," Chèque","Remise","NB Clients",{"$f":"IF(FAMILLES!B2=\"\",\"\",FAMILLES!B2)","v":"FAMILLE 1"},{"$f":"IF(FAMILLES!B3=\"\",\"\",FAMILLES!B3)","v":"FAMILLE 2"},{"$f":"IF(FAMILLES!B4=\"\",\"\",FAMILLES!B4)","v":"FAMILLE 3"},{"$f":"IF(FAMILLES!B5=\"\",\"\",FAMILLES!B5)","v":"FAMILLE 4"},{"$f":"IF(FAMILLES!B6=\"\",\"\",FAMILLES!B6)","v":"FAMILLE 5"},{"$f":"IF(FAMILLES!B7=\"\",\"\",FAMILLES!B7)","v":"FAMILLE 6"},{"$f":"IF(FAMILLES!B8=\"\",\"\",FAMILLES!B8)","v":"FAMILLE 7"},{"$f":"IF(FAMILLES!B9=\"\",\"\",FAMILLES!B9)","v":"FAMILLE 8"},{"$f":"IF(FAMILLES!B10=\"\",\"\",FAMILLES!B10)","v":"FAMILLE 9"},{"$f":"IF(FAMILLES!B11=\"\",\"\",FAMILLES!B11)","v":"FAMILLE 10"},"CA TVA 20%","Mont TVA","CA TVA 5,5%","Mont TVA","CA TVA 10%","Mont TVA","CA TVA 0,00%","FDC","ENTREE ARGENT","SORTIE ARGENT"]
["TALEB","2016-02-07",{"$f":"SUMIFS(Encaissements!D:D,DATE,$B$2,Encaissements!T:T,$A$2)","v":0},{"$f":"SUMIFS(Encaissements!E:E,DATE,B2,Encaissements!T:T,A2)","v":0},{"$f":"SUMIFS(Encaissements!F:F,DATE,B2,Encaissements!T:T,A2)","v":0},{"$f":"SUMIFS(Encaissements!G:G,DATE,B2,Encaissements!T:T,A2)","v":0},{"$f":"SUMIFS(Encaissements!H:H,DATE,B2,Encaissements!T:T,A2)","v":0},{"$f":"SUMPRODUCT((('LISTE TICKETS'!B:B=B2*1)*('LISTE TICKETS'!A:A<>\"\")*1)*('LISTE TICKETS'!E:E=A2)*1)","v":0},{"$f":"IF(I1=\"\",\"\",SUMIFS(Encaissements!J:J,DATE,$B$2,Encaissements!$T:$T,$A$2))","v":0},{"$f":"IF(J1=\"\",\"\",SUMIFS(Encaissements!K:K,DATE,$B$2,Encaissements!$T:$T,$A$2))","v":0},{"$f":"IF(K1=\"\",\"\",SUMIFS(Encaissements!L:L,DATE,$B$2,Encaissements!$T:$T,$A$2))","v":0},{"$f":"IF(L1=\"\",\"\",SUMIFS(Encaissements!M:M,DATE,$B$2,Encaissements!$T:$T,$A$2))","v":0},{"$f":"IF(M1=\"\",\"\",SUMIFS(Encaissements!N:N,DATE,$B$2,Encaissements!$T:$T,$A$2))","v":0},{"$f":"IF(N1=\"\",\"\",SUMIFS(Encaissements!O:O,DATE,B2,Encaissements!T:T,A2))","v":0},{"$f":"IF(O1=\"\",\"\",SUMIFS(Encaissements!P:P,DATE,B2,Encaissements!T:T,A2))","v":0},{"$f":"IF(P1=\"\",\"\",SUMIFS(Encaissements!Q:Q,DATE,B2,Encaissements!T:T,A2))","v":0},{"$f":"IF(Q1=\"\",\"\",SUMIFS(Encaissements!R:R,DATE,B2,Encaissements!T:T,A2))","v":0},{"$f":"IF(R1=\"\",\"\",SUMIFS(Encaissements!S:S,DATE,B2,Encaissements!T:T,A2))","v":0},{"$f":"SUMIFS('LISTE TICKETS'!J:J,'LISTE TICKETS'!E:E,A2,'LISTE TICKETS'!B:B,B2)","v":0},{"$f":"SUMIFS('LISTE TICKETS'!K:K,'LISTE TICKETS'!E:E,A2,'LISTE TICKETS'!B:B,B2)","v":0},{"$f":"SUMIFS('LISTE TICKETS'!L:L,'LISTE TICKETS'!E:E,A2,'LISTE TICKETS'!B:B,B2)","v":0},{"$f":"SUMIFS('LISTE TICKETS'!M:M,'LISTE TICKETS'!E:E,A2,'LISTE TICKETS'!B:B,B2)","v":0},{"$f":"SUMIFS('LISTE TICKETS'!N:N,'LISTE TICKETS'!E:E,A2,'LISTE TICKETS'!B:B,B2)","v":0},{"$f":"SUMIFS('LISTE TICKETS'!O:O,'LISTE TICKETS'!E:E,A2,'LISTE TICKETS'!B:B,B2)","v":0},{"$f":"SUMIFS('LISTE TICKETS'!P:P,'LISTE TICKETS'!E:E,A2,'LISTE TICKETS'!B:B,B2)","v":0},{"$f":"SUMIFS('Z-CAISSE'!S:S,caissier,A2,DATE_Z,B2)","v":0},{"$f":"SUMIFS('Z-CAISSE'!T:T,caissier,A2,DATE_Z,B2)","v":0},{"$f":"SUMIFS('Z-CAISSE'!U:U,caissier,A2,DATE_Z,B2)","v":0}]

{"sheet":"LISTE TICKETS","index":21,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
["N° Ticket","Date",null,"Montant Total","CAISSIER","Mnt Esp","Mnt CB","Mnt CH","Remise",{"$f":"\"CA TVA \"&FAMILLES!A14","v":"CA TVA "},"Mont TVA",{"$f":"\"CA TVA  \"&FAMILLES!A15","v":"CA TVA  "},"Mont TVA",{"$f":"\"CA TVA  \"&FAMILLES!A16","v":"CA TVA  "},"Mont TVA","CA TVA 0,00%"]

{"sheet":"ZED-CAISSE","index":22,"n_rows":115,"n_cols":4,"rows_kept":115,"cut":false,"hidden":false,"merged":[[0,0,0,3],[112,1,112,2],[111,0,111,2],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[63,1,63,3],[88,2,88,3],[90,2,90,3],[82,2,82,3],[83,2,83,3],[84,0,84,3],[85,0,85,3],[86,0,86,3],[89,2,89,3],[77,2,77,3],[79,2,79,3],[80,2,80,3],[81,2,81,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[2,0,2,3],[100,2,100,3],[98,2,98,3],[99,2,99,3],[91,2,91,3],[92,2,92,3],[94,0,94,3],[95,0,95,3],[96,0,96,3],[38,2,38,3],[39,2,39,3],[29,2,29,3],[30,2,30,3],[31,0,31,3],[7,0,7,3],[4,1,4,2],[5,1,5,2],[6,0,6,3],[10,1,10,3],[9,1,9,2],[17,0,17,3],[32,0,32,3],[11,1,11,3],[16,0,16,3],[103,0,103,3],[104,0,104,3],[97,2,97,3],[102,2,102,3],[110,0,110,3],[99,0,99,1],[100,0,100,1],[102,0,102,1],[97,0,97,1],[98,0,98,1],[18,0,18,3],[3,1,3,2],[114,1,114,2],[72,2,72,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[49,2,49,3],[50,0,50,3],[51,0,51,3],[57,0,57,3],[62,1,62,2],[58,1,58,2],[59,0,59,3],[45,0,45,1],[46,0,46,1],[47,0,47,1],[71,0,71,3],[78,2,78,3],[65,1,65,3],[66,1,66,3],[67,1,67,3],[68,1,68,3],[69,0,69,3],[70,0,70,3],[28,2,28,3],[19,2,19,3],[20,2,20,3],[33,0,33,3],[41,0,41,3],[35,2,35,3],[37,2,37,3],[21,2,21,3],[22,2,22,3],[43,0,43,3],[27,2,27,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[42,0,42,3],[36,2,36,3],[60,0,60,3],[64,1,64,3]]}
[{"$f":"\"Z-CAISSE du \"&   TEXT(B5,\"jjjj jj mmmm aaaa\" )","v":"Z-CAISSE du lundi 22 janvier 2018"}]
[{"$f":"TODAY()","v":"2018-01-22"}]
["La source bleue"]
[null,"Date",null,"Heure"]
["Z-CAISSE",{"$f":"TODAY()","v":"2018-01-22"},null,{"$f":"NOW()","v":43122.985230671293}]
["CAISSIER (E):",{"$f":"Utilisateurs!B2","v":"Manager"}]
["Récapitulatif CA"]
["-------------------------"]
[null,"Date début",null,"Date fin"]
["Période",{"$f":"B113","v":"2017-09-17T23:38:34"},null,{"$f":"NOW()","v":"2018-01-22T23:38:43.930"}]
["Nb clients",{"$f":"SUMPRODUCT((('LISTE TICKETS'!$B:$B>$B$10*1)*('LISTE TICKETS'!$B:$B<=$D$10*1)*('LISTE TICKETS'!$A:$A<>\"\")*1)*('LISTE TICKETS'!E:E=$B$6)*1)","v":0}]
["Chiffre d'affaire",{"$f":"IF('SAUVEGARDE VENTE'!$A$7=\"\",0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0}]
["Espèces",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!$E:$E)-1,)=$B$6)*(OFFSET('LISTE TICKETS'!F$2,,,COUNTA('LISTE TICKETS'!$F:$F)-1,))))","v":0}]
["CB",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!$E:$E)-1,)=$B$6)*(OFFSET('LISTE TICKETS'!G$2,,,COUNTA('LISTE TICKETS'!$G:$G)-1,))))","v":0}]
["Chèques",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!$E:$E)-1,)=$B$6)*(OFFSET('LISTE TICKETS'!H$2,,,COUNTA('LISTE TICKETS'!$H:$H)-1,))))","v":0}]
["Remise",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!$E:$E)-1,)=$B$6)*(OFFSET('LISTE TICKETS'!$I$2,,,COUNTA('LISTE TICKETS'!$I:$I)-1,))))","v":0}]
["---------------------------------------------"]
["Analyse famille"]
["-------------------------"]
["Famille","CA TTC","%CA"]
[{"$f":"FAMILLES!B2","v":"FAMILLE 1"},{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A21)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B21=0,\"\",B21/$B$12)","v":""}]
[{"$f":"FAMILLES!B3","v":"FAMILLE 2"},{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A22)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B22=0,\"\",B22/$B$12)","v":""}]
[{"$f":"FAMILLES!B4","v":"FAMILLE 3"},{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A23)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B23=0,\"\",B23/$B$12)","v":""}]
[{"$f":"FAMILLES!B5","v":"FAMILLE 4"},{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A24)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B24=0,\"\",B24/$B$12)","v":""}]
[{"$f":"FAMILLES!B6","v":"FAMILLE 5"},{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A25)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B25=0,\"\",B25/$B$12)","v":""}]
[{"$f":"FAMILLES!B7","v":"FAMILLE 6"},{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A26)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B26=0,\"\",B26/$B$12)","v":""}]
[{"$f":"FAMILLES!B8","v":"FAMILLE 7"},{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A27)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B27=0,\"\",B27/$B$12)","v":""}]
[{"$f":"FAMILLES!B9","v":"FAMILLE 8"},{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A28)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B28=0,\"\",B28/$B$12)","v":""}]
[{"$f":"FAMILLES!B10","v":"FAMILLE 9"},{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A29)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B29=0,\"\",B29/$B$12)","v":""}]
[{"$f":"FAMILLES!B11","v":"FAMILLE 10"},{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A30)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B30=0,\"\",B30/$B$12)","v":""}]
[{"$f":"IF(H14>0,H13,IF(I14>0,I13,IF(J14>0,J13,IF(K14>0,K13,IF(L14>0,L13,IF(M14>0,M13,IF(N14>0,N13,IF(O14>0,O13,IF(P14>0,P13,IF(Q14>0,Q13,\"\"))))))))))","v":""}]
["---------------------------------------------"]
["Solde Tiroir"]
["-------------------------"]
[{"$f":"IF(H18>0,H17,IF(I18>0,I17,IF(J18>0,J17,IF(K18>0,K17,IF(L18>0,L17,IF(M18>0,M17,IF(N18>0,N17,IF(O18>0,O17,IF(P18>0,P17,IF(Q18>0,Q17,\"\"))))))))))","v":""}]
["Paiements ",null,"Montant "]
["-------------------------",null,"-------------------------"]
["Espèces",null,{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!$E:$E)-1,)=$B$6)*(OFFSET('LISTE TICKETS'!$F$2,,,COUNTA('LISTE TICKETS'!$F:$F)-1,))))","v":0}]
["CB",null,{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!$E:$E)-1,)=$B$6)*(OFFSET('LISTE TICKETS'!$G$2,,,COUNTA('LISTE TICKETS'!$G:$G)-1,))))","v":0}]
["Chèque",null,{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!$E:$E)-1,)=$B$6)*(OFFSET('LISTE TICKETS'!$H$2,,,COUNTA('LISTE TICKETS'!$H:$H)-1,))))","v":0}]
[{"$f":"IF(H25>0,H24,IF(I25>0,I24,IF(J25>0,J24,IF(K25>0,K24,IF(L25>0,L24,IF(M25>0,M24,IF(N25>0,N24,IF(O25>0,O24,IF(P25>0,P24,IF(Q25>0,Q24,\"\"))))))))))","v":""}]
["---------------------------------------------"]
["Point comptable"]
["-------------------------"]
["Chiffre d'affaire TTC",null,{"$f":"B12","v":0}]
["Entrées",null,{"$f":"IF($B$12=0,0,SUMIFS('Z-CAISSE'!T:T,'Z-CAISSE'!A:A,DATE_Z>$B$10,DATE_Z,DATE_Z<=$D$10,'Z-CAISSE'!R:R,$B$6))","v":0}]
["Sorties",null,{"$f":"IF($B$12=0,0,SUMIFS('Z-CAISSE'!U:U,'Z-CAISSE'!A:A,DATE_Z>$B$10,DATE_Z,DATE_Z<=$D$10,'Z-CAISSE'!R:R,$B$6))","v":0}]
["Fond de caisse",null,{"$f":"IF($B$12=0,0,SUMIFS('Z-CAISSE'!S:S,'Z-CAISSE'!A:A,DATE_Z>$B$10,DATE_Z,DATE_Z<=$D$10,'Z-CAISSE'!R:R,$B$6))","v":0}]
[]
["Solde théorique",null,{"$f":"IF(C45=0,0,(C45-C46)-(C47+C48))","v":0}]
["---------------------------------------------"]
["Analyse TVA"]
["Libellé","Taux","CA TTC","Montant TVA"]
["TVA 0,055",5.5E-2,{"$f":"IF(B54<>\"\",IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B54)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,)))),\"\")","v":0},{"$f":"IF(B54<>\"\",IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B54)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,)))),\"\")","v":0}]
["TVA 0,2",0.2,{"$f":"IF(B55<>\"\",IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B55)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,)))),\"\")","v":0},{"$f":"IF(B55<>\"\",IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B55)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,)))),\"\")","v":0}]
[null,null,{"$f":"IF(B56<>\"\",IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B56)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,)))),\"\")","v":""},{"$f":"IF(B56<>\"\",IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B56)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,)))),\"\")","v":""}]
["Exonérée",0,{"$f":"IF($B$12=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B57)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0}]
["---------------------------------------------"]
["CAISSIER (E):",{"$f":"Utilisateurs!B3","v":"Taleb"}]
["Récapitulatif CA"]
["-------------------------"]
[null,"Date début",null,"Date fin"]
["Période","2017-09-12T14:22:59",null,{"$f":"NOW()","v":"2018-01-22T23:38:43.930"}]
["Nb clients",{"$f":"SUMPRODUCT((('LISTE TICKETS'!B:B>$B$10*1)*('LISTE TICKETS'!B:B<=$D$10*1)*('LISTE TICKETS'!A:A<>\"\")*1)*('LISTE TICKETS'!E:E=$B$59)*1)","v":0}]
["Chiffre d'affaire",{"$f":"IF('SAUVEGARDE VENTE'!$A$7=\"\",0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0}]
["Espèces",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=$B$59)*(OFFSET('LISTE TICKETS'!$F$2,,,COUNTA('LISTE TICKETS'!$F:$F)-1,))))","v":0}]
["CB",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=$B$59)*(OFFSET('LISTE TICKETS'!$G$2,,,COUNTA('LISTE TICKETS'!$G:$G)-1,))))","v":0}]
["Chèques",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=$B$59)*(OFFSET('LISTE TICKETS'!$H$2,,,COUNTA('LISTE TICKETS'!$H:$H)-1,))))","v":0}]
["Remise",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!$E:$E)-1,)=$B$59)*(OFFSET('LISTE TICKETS'!$I$2,,,COUNTA('LISTE TICKETS'!$I:$I)-1,))))","v":0}]
["---------------------------------------------"]
["Analyse famille"]
["-------------------------"]
["Famille","CA TTC","%CA"]
[{"$f":"FAMILLES!B2","v":"FAMILLE 1"},{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)=A74)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B74=0,\"\",B74/$B$65)","v":""}]
[{"$f":"FAMILLES!B3","v":"FAMILLE 2"},{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)=A75)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B75=0,\"\",B75/$B$65)","v":""}]
[{"$f":"FAMILLES!B4","v":"FAMILLE 3"},{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)=A76)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B76=0,\"\",B76/$B$65)","v":""}]
[{"$f":"FAMILLES!B5","v":"FAMILLE 4"},{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)=A77)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B77=0,\"\",B77/$B$65)","v":""}]
[{"$f":"FAMILLES!B6","v":"FAMILLE 5"},{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)=A78)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B78=0,\"\",B78/$B$65)","v":""}]
[{"$f":"FAMILLES!B7","v":"FAMILLE 6"},{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)=A79)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B79=0,\"\",B79/$B$65)","v":""}]
[{"$f":"FAMILLES!B8","v":"FAMILLE 7"},{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)=A80)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B80=0,\"\",B80/$B$65)","v":""}]
[{"$f":"FAMILLES!B9","v":"FAMILLE 8"},{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)=A81)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B81=0,\"\",B81/$B$65)","v":""}]
[{"$f":"FAMILLES!B10","v":"FAMILLE 9"},{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)=A82)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B82=0,\"\",B82/$B$65)","v":""}]
[{"$f":"FAMILLES!B11","v":"FAMILLE 10"},{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)=A83)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B83=0,\"\",B83/$B$65)","v":""}]
[{"$f":"IF(H67>0,H66,IF(I67>0,I66,IF(J67>0,J66,IF(K67>0,K66,IF(L67>0,L66,IF(M67>0,M66,IF(N67>0,N66,IF(O67>0,O66,IF(P67>0,P66,IF(Q67>0,Q66,\"\"))))))))))","v":""}]
["---------------------------------------------"]
["Solde Tiroir"]
["-------------------------"]
[{"$f":"IF(H71>0,H70,IF(I71>0,I70,IF(J71>0,J70,IF(K71>0,K70,IF(L71>0,L70,IF(M71>0,M70,IF(N71>0,N70,IF(O71>0,O70,IF(P71>0,P70,IF(Q71>0,Q70,\"\"))))))))))","v":""}]
["Paiements ",null,"Montant "]
["-------------------------",null,"-------------------------"]
["Espèces",null,{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=$B$59)*(OFFSET('LISTE TICKETS'!$F$2,,,COUNTA('LISTE TICKETS'!$F:$F)-1,))))","v":0}]
["CB",null,{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=$B$59)*(OFFSET('LISTE TICKETS'!$G$2,,,COUNTA('LISTE TICKETS'!$G:$G)-1,))))","v":0}]
["Chèque",null,{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>$B$10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=$D$10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=$B$59)*(OFFSET('LISTE TICKETS'!$H$2,,,COUNTA('LISTE TICKETS'!$H:$H)-1,))))","v":0}]
[{"$f":"IF(H78>0,H77,IF(I78>0,I77,IF(J78>0,J77,IF(K78>0,K77,IF(L78>0,L77,IF(M78>0,M77,IF(N78>0,N77,IF(O78>0,O77,IF(P78>0,P77,IF(Q78>0,Q77,\"\"))))))))))","v":""}]
["---------------------------------------------"]
["Point comptable"]
["-------------------------"]
["Chiffre d'affaire TTC",null,{"$f":"B65","v":0}]
["Entrées",null,{"$f":"IF($B$65=0,0,SUMIFS('Z-CAISSE'!T:T,'Z-CAISSE'!A:A,DATE_Z>$B$10,DATE_Z,DATE_Z<=$D$10,'Z-CAISSE'!R:R,$B$59))","v":0}]
["Sorties",null,{"$f":"IF($B$65=0,0,SUMIFS('Z-CAISSE'!U:U,'Z-CAISSE'!A:A,DATE_Z>$B$10,DATE_Z,DATE_Z<=$D$10,'Z-CAISSE'!R:R,$B$59))","v":0}]
["Fond de caisse",null,{"$f":"IF($B$65=0,0,SUMIFS('Z-CAISSE'!S:S,'Z-CAISSE'!A:A,DATE_Z>$B$10,DATE_Z,DATE_Z<=$D$10,'Z-CAISSE'!R:R,$B$59))","v":0}]
[]
["Solde théorique",null,{"$f":"IF(C98=0,0,(C98-C99)-(C100+C101))","v":0}]
["---------------------------------------------"]
["Analyse TVA"]
["Libellé","Taux","CA TTC","Montant TVA"]
["TVA  0,055",5.5E-2,{"$f":"IF(B107<>\"\",IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B107)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,)))),\"\")","v":0},{"$f":"IF(B107<>\"\",IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B107)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,)))),\"\")","v":0}]
["TVA  0,2",0.2,{"$f":"IF(B108<>\"\",IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B108)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,)))),\"\")","v":0},{"$f":"IF(B108<>\"\",IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B108)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,)))),\"\")","v":0}]
[null,null,{"$f":"IF(B109<>\"\",IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B109)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,)))),\"\")","v":""},{"$f":"IF(B109<>\"\",IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B109)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,)))),\"\")","v":""}]
["Exonérée",0,{"$f":"IF($B$65=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>$B$10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=$D$10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=$B$59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B110)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0}]
["---------------------------------------------"]
["le dernier Z-CAISSE a été effectué par",null,null,"Manager"]
[null,"2017-09-17T23:38:34"]
[]
[null,"La devise utilisée est le €"]

{"sheet":"Utilisateurs","index":23,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["code","Utilisateur","MDP",{"$f":"COUNT(A:A)","v":2}]
[1,"Manager",22222]
[2,"Taleb",11111]

{"sheet":"FDC","index":24,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,1,4,2],[6,1,6,2],[8,1,8,2],[2,0,2,2]]}
[]
[]
["La source bleue"]
[]
["Date","2017-09-14T16:10:19"]
[]
["Caissier","TALEB"]
[]
["Montant FDC",35]

{"sheet":"GESTION FIDELITE","index":25,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["OBJECTIF","TOTAL POINTS","MONTANT REMISE"]
[100,100,2.5]

{"sheet":"Fournisseurs","index":26,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Rèf","Fournisseur","Adresse","Code postal","Ville","Tél","Fax","Mobile","E-mail"]

{"sheet":"BOUTONS","index":27,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Bouton","Nom famille","Réf"]
[null,null,null,null,"CommandButton1",1]
[null,null,null,null,"CommandButton2",2]
[null,null,null,null,"CommandButton3",3]
[null,null,null,null,"CommandButton4",4]
[null,null,null,null,"CommandButton5",5]
[null,null,null,null,"CommandButton6",6]
[null,null,null,null,"CommandButton7",7]
[null,null,null,null,"CommandButton8",8]
[null,null,null,null,"CommandButton9",9]
[null,null,null,null,"CommandButton10",10]

{"sheet":"FAMILLES","index":28,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Réf","FAMILLES","Taux tva","Taux tva","kg","Taux tva",null,null,null,null,0]
["F1","FAMILLE 1",{"$f":"VALUE(F2)","v":0},0,"litre",0,null,null,null,null,0]
["F2","FAMILLE 2",{"$f":"VALUE(F3)","v":0},0,"U",0,null,null,null,null,0]
["F3","FAMILLE 3",{"$f":"VALUE(F4)","v":0},0,"Pièce",0,null,null,null,null,0]
["F4","FAMILLE 4",{"$f":"VALUE(F5)","v":0},0,"Botte",0,null,null,null,null,0]
["F5","FAMILLE 5",{"$f":"VALUE(F6)","v":0},0,"Lot",0,null,null,null,null,0]
["F6","FAMILLE 6",{"$f":"VALUE(F7)","v":0},0,null,0,null,null,null,null,0]
["F7","FAMILLE 7",{"$f":"VALUE(F8)","v":0},0,null,0,null,null,null,null,0]
["F8","FAMILLE 8",{"$f":"VALUE(F9)","v":0},0,null,0,null,null,null,null,0]
["F9","FAMILLE 9",{"$f":"VALUE(F10)","v":0},0,null,0,null,null,null,null,0]
["F10","FAMILLE 10",{"$f":"VALUE(F11)","v":0},0,null,0]
[]
["Différents taux de TVA"]

{"sheet":"Encaissements","index":29,"n_rows":1,"n_cols":27,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["N° Ticket","Date","Heure","Montant Total","Mnt Espèces","Mnt CB","Mnt Chèque","Mnt Remise",1,{"$f":"FAMILLES!B2","v":"FAMILLE 1"},{"$f":"FAMILLES!B3","v":"FAMILLE 2"},{"$f":"FAMILLES!B4","v":"FAMILLE 3"},{"$f":"FAMILLES!B5","v":"FAMILLE 4"},{"$f":"FAMILLES!B6","v":"FAMILLE 5"},{"$f":"FAMILLES!B7","v":"FAMILLE 6"},{"$f":"FAMILLES!B8","v":"FAMILLE 7"},{"$f":"FAMILLES!B9","v":"FAMILLE 8"},{"$f":"FAMILLES!B10","v":"FAMILLE 9"},{"$f":"FAMILLES!B11","v":"FAMILLE 10"},"CAISSIER",{"$f":"\"CA TVA  \"&FAMILLES!A14","v":"CA TVA  "},"Mont TVA",{"$f":"\"CA TVA  \"&FAMILLES!A15","v":"CA TVA  "},"Mont TVA",{"$f":"\"CA TVA  \"&FAMILLES!A16","v":"CA TVA  "},"Mont TVA","CA TVA 0,00%"]

{"sheet":"Z-CAISSE","index":30,"n_rows":9,"n_cols":31,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Date","Chiffre d'affaire","Espèces","CB","Chèques","Remise",{"$f":"IF(FAMILLES!$B$2=\"\",\"\",FAMILLES!$B$2)","v":"FAMILLE 1"},{"$f":"IF(FAMILLES!$B$3=\"\",\"\",FAMILLES!$B$3)","v":"FAMILLE 2"},{"$f":"IF(FAMILLES!$B$4=\"\",\"\",FAMILLES!$B$4)","v":"FAMILLE 3"},{"$f":"IF(FAMILLES!$B$5=\"\",\"\",FAMILLES!$B$5)","v":"FAMILLE 4"},{"$f":"IF(FAMILLES!$B$6=\"\",\"\",FAMILLES!$B$6)","v":"FAMILLE 5"},{"$f":"IF(FAMILLES!$B$7=\"\",\"\",FAMILLES!$B$7)","v":"FAMILLE 6"},{"$f":"IF(FAMILLES!$B$8=\"\",\"\",FAMILLES!$B$8)","v":"FAMILLE 7"},{"$f":"IF(FAMILLES!$B$9=\"\",\"\",FAMILLES!$B$9)","v":"FAMILLE 8"},{"$f":"IF(FAMILLES!$B$10=\"\",\"\",FAMILLES!$B$10)","v":"FAMILLE 9"},{"$f":"IF(FAMILLES!$B$11=\"\",\"\",FAMILLES!$B$11)","v":"FAMILLE 10"},"NB Clients","CAISSIER","FOND DE CAISSE","ENTREE ARGENT","SORTIE ARGENT",{"$f":"\"CA TVA  \"&FAMILLES!$A$14","v":"CA TVA  "},"Mont TVA",{"$f":"\"CA TVA  \"&FAMILLES!$A$15","v":"CA TVA  "},"Mont TVA",{"$f":"\"CA TVA  \"&FAMILLES!$A$16","v":"CA TVA  "},"Mont TVA","CA TVA 0,00%","TOTAL ESPECES","TOTAL CB","TOTAL CHEQUES"]
["2018-01-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilisateur"]
["Date","Chiffre d'affaire","Espèces","CB","Chèques","Remise",{"$f":"IF(FAMILLES!$B$2=\"\",\"\",FAMILLES!$B$2)","v":"FAMILLE 1"},{"$f":"IF(FAMILLES!$B$3=\"\",\"\",FAMILLES!$B$3)","v":"FAMILLE 2"},{"$f":"IF(FAMILLES!$B$4=\"\",\"\",FAMILLES!$B$4)","v":"FAMILLE 3"},{"$f":"IF(FAMILLES!$B$5=\"\",\"\",FAMILLES!$B$5)","v":"FAMILLE 4"},{"$f":"IF(FAMILLES!$B$6=\"\",\"\",FAMILLES!$B$6)","v":"FAMILLE 5"},{"$f":"IF(FAMILLES!$B$7=\"\",\"\",FAMILLES!$B$7)","v":"FAMILLE 6"},{"$f":"IF(FAMILLES!$B$8=\"\",\"\",FAMILLES!$B$8)","v":"FAMILLE 7"},{"$f":"IF(FAMILLES!$B$9=\"\",\"\",FAMILLES!$B$9)","v":"FAMILLE 8"},{"$f":"IF(FAMILLES!$B$10=\"\",\"\",FAMILLES!$B$10)","v":"FAMILLE 9"},{"$f":"IF(FAMILLES!$B$11=\"\",\"\",FAMILLES!$B$11)","v":"FAMILLE 10"},"NB Clients","CAISSIER","FOND DE CAISSE","ENTREE ARGENT","SORTIE ARGENT",{"$f":"\"CA TVA  \"&FAMILLES!$A$14","v":"CA TVA  "},"Mont TVA",{"$f":"\"CA TVA  \"&FAMILLES!$A$15","v":"CA TVA  "},"Mont TVA",{"$f":"\"CA TVA  \"&FAMILLES!$A$16","v":"CA TVA  "},"Mont TVA","CA TVA 0,00%","TOTAL ESPECES","TOTAL CB","TOTAL CHEQUES"]
["2017-09-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager",0,0,0,null,null,null,null,null,null,null,0,0,0]
["2018-01-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager",0,0,0,null,null,null,null,null,null,null,0,0,0]
["2018-01-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager",0,0,0,null,null,null,null,null,null,null,0,0,0]
["2018-01-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager",0,0,0,null,null,null,null,null,null,null,0,0,0]
["2018-01-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager",0,0,0,null,null,null,null,null,null,null,0,0,0]

{"sheet":"PERIODE VENTE","index":31,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["date debut","date fin","chiffre d'affaire","Total tva",{"$f":"\"Total tva \"& FAMILLES!A14","v":"Total tva "},{"$f":"\"Total tva \"&FAMILLES!A15","v":"Total tva "},{"$f":"\"Total tva \"&FAMILLES!A16","v":"Total tva "}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"X-CAISSE","index":32,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[[62,0,62,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[18,0,18,3],[31,0,31,3],[16,0,16,3],[41,0,41,3],[43,0,43,3],[50,0,50,3],[60,0,60,1],[27,2,27,3],[25,2,25,3],[19,2,19,3],[21,2,21,3],[22,2,22,3],[7,0,7,3],[6,0,6,3],[17,0,17,3],[9,1,9,2],[10,1,10,3],[33,0,33,3],[36,2,36,3],[4,1,4,2],[45,2,45,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[44,2,44,3],[39,2,39,3],[38,2,38,3],[37,2,37,3],[35,2,35,3],[23,2,23,3],[24,2,24,3],[5,1,5,2],[20,2,20,3],[1,0,1,3],[2,0,2,3],[59,0,59,3],[57,0,57,3],[34,5,35,5],[34,4,35,4],[51,0,51,3],[49,2,49,3],[47,2,47,3],[46,2,46,3],[26,2,26,3],[45,0,45,1],[46,0,46,1],[47,0,47,1],[32,0,32,3],[42,0,42,3]]}
["Date","Chiffre d'affaire","Espèces","FDC","CB","Chèques","Remise",{"$f":"SUM(F1:F4)","v":0}]
[{"$f":"\"X-CAISSE du \"&B6& \" du  \"&   TEXT(B10,\"jjjj jj mmmm aaaa\" )","v":"X-CAISSE du Manager du  samedi 20 janvier 2018"}]
["La source bleue"]
[null,null,"Date","Heure"]
["X-CAISSE ","2018-01-20",null,43120.903923611113]
["CAISSIER (E):","Manager"]
["Récapitulatif CA"]
["-------------------------"]
[]
["Date","2018-01-20"]
["Nb clients",{"$f":"COUNTIFS('LISTE TICKETS'!E:E,'X-CAISSE'!B6:C6,'LISTE TICKETS'!B:B,'X-CAISSE'!B10:C10)","v":0}]
["Chiffre d'affaire",{"$f":"IF('SAUVEGARDE VENTE'!$A$7=\"\",\"\",SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":""}]
["Espèces",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMIFS('LISTE TICKETS'!F:F,'LISTE TICKETS'!$E:$E,'X-CAISSE'!$B$6,'LISTE TICKETS'!$B:$B,'X-CAISSE'!$B$10))","v":0}]
["CB",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMIFS('LISTE TICKETS'!G:G,'LISTE TICKETS'!$E:$E,'X-CAISSE'!$B$6,'LISTE TICKETS'!$B:$B,'X-CAISSE'!$B$10))","v":0}]
["Chèques",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMIFS('LISTE TICKETS'!H:H,'LISTE TICKETS'!$E:$E,'X-CAISSE'!$B$6,'LISTE TICKETS'!$B:$B,'X-CAISSE'!$B$10))","v":0}]
["Remise",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMIFS('LISTE TICKETS'!I:I,'LISTE TICKETS'!$E:$E,'X-CAISSE'!$B$6,'LISTE TICKETS'!$B:$B,'X-CAISSE'!$B$10))","v":0}]
["---------------------------------------------"]
["Analyse famille"]
["-------------------------"]
["Famille","CA TTC","% CA"]
[{"$f":"FAMILLES!B2","v":"FAMILLE 1"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A21)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B21=0,\"\",B21/$B$12)","v":""}]
[{"$f":"FAMILLES!B3","v":"FAMILLE 2"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A22)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},""]
[{"$f":"FAMILLES!B4","v":"FAMILLE 3"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A23)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},""]
[{"$f":"FAMILLES!B5","v":"FAMILLE 4"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A24)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},""]
[{"$f":"FAMILLES!B6","v":"FAMILLE 5"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A25)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},""]
[{"$f":"FAMILLES!B7","v":"FAMILLE 6"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A26)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},""]
[{"$f":"FAMILLES!B8","v":"FAMILLE 7"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A27)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},""]
[{"$f":"FAMILLES!B9","v":"FAMILLE 8"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A28)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},""]
[{"$f":"FAMILLES!B10","v":"FAMILLE 9"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A29)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},""]
[{"$f":"FAMILLES!B11","v":"FAMILLE 10"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A30)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},""]
[{"$f":"FAMILLES!B12","v":0}]
["---------------------------------------------"]
["Solde Tiroir"]
["-------------------------"]
[null,null,null,null,"Montant CAISSE","DIFF"]
["Paiements ",null,"Montant "]
["-------------------------",null,"-------------------------"]
["Espèces",null,{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMIFS('LISTE TICKETS'!F:F,'LISTE TICKETS'!$E:$E,'X-CAISSE'!$B$6,'LISTE TICKETS'!$B:$B,'X-CAISSE'!$B$10))","v":0},null,{"$f":"IF($B$12=\"\",0,SUMIFS(TOTAL_ESPECES,DATE_Z,$B$10,caissier,$B$6))","v":0},{"$f":"IF(C38=\"\",E38,E38-C38)","v":0}]
["CB",null,{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMIFS('LISTE TICKETS'!G:G,'LISTE TICKETS'!$E:$E,'X-CAISSE'!$B$6,'LISTE TICKETS'!$B:$B,'X-CAISSE'!$B$10))","v":0},null,{"$f":"IF($B$12=\"\",0,SUMIFS(TOTAL_CB,DATE_Z,$B$10,caissier,$B$6))","v":0},{"$f":"IF(C39=\"\",E39,E39-C39)","v":0}]
["Chèque",null,{"$f":"IF('LISTE TICKETS'!$A$2=\"\",0,SUMIFS('LISTE TICKETS'!H:H,'LISTE TICKETS'!$E:$E,'X-CAISSE'!$B$6,'LISTE TICKETS'!$B:$B,'X-CAISSE'!$B$10))","v":0},null,{"$f":"IF($B$12=\"\",0,SUMIFS(TOTAL_CHEQUES,DATE_Z,$B$10,caissier,$B$6))","v":0},{"$f":"IF(C40=\"\",E40,E40-C40)","v":0}]
[]
["---------------------------------------------"]
["Point comptable"]
["-------------------------"]
["Chiffre d'affaire TTC",null,{"$f":"IF('SAUVEGARDE VENTE'!$A$7=\"\",\"\",SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":""}]
["Entrées",null,{"$f":"IF(B12=\"\",0,SUMIFS('Z-CAISSE'!T:T,'Z-CAISSE'!A:A,B10,'Z-CAISSE'!R:R,B6))","v":0}]
["Sorties",null,{"$f":"IF(B12=\"\",0,SUMIFS('Z-CAISSE'!U:U,'Z-CAISSE'!A:A,B10,'Z-CAISSE'!R:R,B6))","v":0}]
["Fond de caisse",null,{"$f":"IF(B12=\"\",0,SUMIFS('Z-CAISSE'!S:S,'Z-CAISSE'!A:A,B10,'Z-CAISSE'!R:R,B6))","v":0}]
[]
["Solde théorique",null,{"$f":"IF(C45=\"\",0,(C45-C46)-(C47-C48))","v":0}]
["---------------------------------------------"]
["Analyse TVA"]
["Libellé","Taux","CA TTC","Montant TVA","Total TVA"]
[null,null,{"$f":"IF(B54<>\"\",IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!A7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!L7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!K7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B54)*(OFFSET('SAUVEGARDE VENTE'!G7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,)))),\"\")","v":""},{"$f":"IF(B54<>\"\",IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!A7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!L7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!K7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B54)*(OFFSET('SAUVEGARDE VENTE'!H7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,)))),\"\")","v":""},{"$f":"SUM(D54:D56)","v":0}]
[null,null,{"$f":"IF(B55<>\"\",IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!A7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!L7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!K7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B55)*(OFFSET('SAUVEGARDE VENTE'!G7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,)))),\"\")","v":""},{"$f":"IF(B55<>\"\",IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!A7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!L7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!K7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B55)*(OFFSET('SAUVEGARDE VENTE'!H7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,)))),\"\")","v":""}]
[null,null,{"$f":"IF(B56<>\"\",IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!A7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!L7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!K7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B56)*(OFFSET('SAUVEGARDE VENTE'!G7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,)))),\"\")","v":""},{"$f":"IF(B56<>\"\",IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!A7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!L7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!K7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B56)*(OFFSET('SAUVEGARDE VENTE'!H7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,)))),\"\")","v":""}]
["Exonérée",0,{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!A7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!L7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!K7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=B57)*(OFFSET('SAUVEGARDE VENTE'!G7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0}]
["---------------------------------------------"]
[]
["La devise utilisée est le  €"]

{"sheet":"SAUVEGARDE VENTE","index":33,"n_rows":64,"n_cols":30,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[4,3,4,5]]}
[null,null,"Date début",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE","DATE","Famille","Produit","CAISSIER",{"$f":"SUM(P:P)","v":0}]
[null,null,"Date fin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D1=\"\",\"\",\">=\"&D1)","v":""},{"$f":"IF(D2=\"\",\"\",\"<=\"&D2)","v":""},{"$f":"IF(D3=\"\",\"\",D3)","v":""},{"$f":"IF(D4=\"\",\"\",D4)","v":""},{"$f":"IF(D5=\"\",\"\",D5)","v":""}]
[null,null,"Famille",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(J:J,Y4)","v":0},{"$f":"COUNTIF(B:B,Z4)","v":2},{"$f":"COUNTIF(L:L,AA4)","v":0}]
[null,null,"Produit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Utilisateur"]
[null,null,"Caissier"]
["DATE","Réf","Produit","Qté","Prix","Remise","Montant","Mt tva","Montant Remise","Famille","Taux TVA","CAISSIER","DATE","Réf","Produit","Qté","Prix","Remise","Montant","Mt tva","Montant Remise","Famille","Taux TVA","CAISSIER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2017-09-17",3,"OURLET JEANS",1,8,0,8,1.3332999999999999,0,"VESTE",0.2,"Manager"]
["2017-09-17",2,"OURLET MACHINE",1,7,0,7,1.1667000000000001,0,"VESTE",0.2,"Manager"]
["2017-09-17",1,"OURLET MAIN",1,9,0,9,1.5,0,"VESTE",0.2,"Manager"]
["2017-09-17",3,"OURLET JEANS",1,8,0,8,1.3332999999999999,0,"VESTE",0.2,"Manager"]
["2017-09-17",1,"OURLET MAIN",1,9,0,9,1.5,0,"VESTE",0.2,"Manager"]
["2017-09-17",2,"OURLET MACHINE",1,7,0,7,1.1667000000000001,0,"VESTE",0.2,"Manager"]
["2017-09-17",1,"OURLET MAIN",1,9,0,9,1.5,0,"VESTE",0.2,"Manager"]
["2018-01-15",1,"OURLET MAIN",1,9,0,9,1.5,0,"VESTE",0.2,"Manager"]
["2018-01-19",3268840001008,"CRISTALINE 50CL",1,0.6,0,0.6,3.1300000000000001E-2,0,"ALIMENTATION 5,5",5.5E-2,"Manager"]
["2018-01-19",3268840001008,"CRISTALINE 50CL",2,0.6,0,1.2,6.2600000000000003E-2,0,"ALIMENTATION 5,5",5.5E-2,"Manager"]

{"sheet":"TACHES A REALISER","index":34,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Tâche à réaliser"]

{"sheet":"LISTE RECEPTIONS","index":35,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["N° BL/Facture","Fournisseur","Date"]

{"sheet":"PRELEVEMENT","index":36,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[15,1,15,2],[17,1,17,2],[1,0,1,3],[3,0,3,3],[5,2,5,3],[6,2,6,3],[13,1,13,2],[14,1,14,2]]}
[]
[]
[]
["Prélèvements "]
[]
["Utilisateur:",null,"Manager"]
["Date",null,"2017-09-14"]

{"sheet":"LISTE PRELEVEMENTS","index":37,"n_rows":2,"n_cols":15,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"CAISSIER","DATE",null,null,null,null,null,"esp","cb","che"]
["CAISSIER","DATE"," PRELEVEMENT Espèces"," PRELEVEMENT CB"," PRELEVEMENT Chèques","Manager","2017-09-12","CAISSIER","DATE"," PRELEVEMENT Espèces"," PRELEVEMENT CB"," PRELEVEMENT Chèques",{"$f":"SUM(J:J)","v":0},{"$f":"SUM(K:K)","v":0},{"$f":"SUM(L:L)","v":0}]