{"text_format":"1","workbook":"xlsx","n_sheets":41,"sheets":["EAN 13","ACCUEIL","LISTE COMMANDES","DETAIL COMMANDES","COMMANDES FOURNISSEUR","RECEPTION MARCHANDISE","Produits stock zero","Produits stock mini","BASE DE DONNEES","INVENTAIRE","DETAIL INVENTAIRES","LISTE INVENTAIRES","ETIQUETTE","ETIQUETTES","PRODUITS ETIQUETTES","FAMILLES","DEMARQUE","Facture en attente","PARAMETRES","Factures","CLIENTS","FACTURATION","ENCAISSEMENT MOIS","BOUTONS FAMILLE1","Base","Utilisateurs","BOUTONS","FDC","GESTION FIDELITE","Fournisseurs","PERIODE VENTE","Encaissements","Z-CAISSE","ZED-CAISSE","LISTE TICKETS","X-CAISSE","SAUVEGARDE VENTE","TACHES A REALISER","TACHES REALISEES","Feuil1","SUJETS"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":96,"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":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,11]]}
[]
[null,"BONJOUR ET BIENVENUE SUR NLA-CAISSE"]

{"sheet":"LISTE COMMANDES","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["N° Commande","Fournisseur","Date"]
[1,"FOURNISSEUR 1",{"$f":"TODAY()","v":"2017-07-08"}]
[2,"FOURNISSEUR 1","2017-07-08"]
[3,"FOURNISSEUR 1","2017-07-08"]
[4,"FOURNISSEUR 1","2017-07-08"]
[5,"FOURNISSEUR 2","2017-07-08"]
[6,"FOURNISSEUR 1","2017-07-08"]
[7,"FOURNISSEUR 2",{"$f":"TODAY()","v":"2017-07-08"}]

{"sheet":"DETAIL COMMANDES","index":3,"n_rows":17,"n_cols":20,"rows_kept":17,"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"]
[1,"12","SUCRE EN MORCEAUX 250G",10,"FOURNISSEUR 1",{"$f":"TODAY()","v":"2017-07-08"},null,null,null,"SUCRE EN MORCEAUX 1KG",7,"3250390534624","SUCRE EN MORCEAUX 1KG",20,"FOURNISSEUR 2","2017-07-07",null,5,"FOURNISSEUR 2","2017-07-07"]
[2,"13","SEL FIN 500G",15,"FOURNISSEUR 1","2017-07-08",null,null,null,null,null,null,null,null,null,null,null,7,"FOURNISSEUR 2","2017-07-07"]
[2,"12","SUCRE EN MORCEAUX 250G",10,"FOURNISSEUR 1","2017-07-08"]
[3,"13","SEL FIN 500G",10,"FOURNISSEUR 1","2017-07-08"]
[3,"14","COCA COLA 1.5L",50,"FOURNISSEUR 1","2017-07-08"]
[4,"13","SEL FIN 500G",15,"FOURNISSEUR 1","2017-07-08"]
[4,"14","COCA COLA 1.5L",60,"FOURNISSEUR 1","2017-07-08"]
[5,"14","COCA COLA 1.5L",10,"FOURNISSEUR 1","2017-07-08"]
[5,"13","SEL FIN 500G",20,"FOURNISSEUR 1","2017-07-08"]
[5,"3410280028071","PILES LR03 X10",10,"FOURNISSEUR 2",{"$f":"TODAY()","v":"2017-07-08"}]
[6,"14","COCA COLA 1.5L",20,"FOURNISSEUR 1","2017-07-08"]
[6,"13","SEL FIN 500G",10,"FOURNISSEUR 1","2017-07-08"]
[7,"3250390534624","SUCRE EN MORCEAUX 1KG",20,"FOURNISSEUR 2","2017-07-08"]
[7,"3410280028071","PILES LR03 X10",10,"FOURNISSEUR 2","2017-07-08"]
[8,"3250390534624","SUCRE EN MORCEAUX 1KG",10,"FOURNISSEUR 2","2017-07-08"]
[8,"3410280028071","PILES LR03 X10",10,"FOURNISSEUR 2","2017-07-08"]

{"sheet":"COMMANDES FOURNISSEUR","index":4,"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  samedi 08 juillet 2017"},null,null,null,"Fournisseur"]
[null,null,null,null,"FOURNISSEUR 2"]
[]
["Gencode","Produit","Qté","Fournisseur"]

{"sheet":"RECEPTION MARCHANDISE","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["N° Facture","Gencode","Produit","Qté","Fournisseur"]
[1,12,"SUCRE EN MORCEAUX 250G",20,"FOURNISSEUR 1"]
[1,12,"SUCRE EN MORCEAUX 1KG",13,"FOURNISSEUR 1"]
[1,13,"SEL FIN 500G",10,"FOURNISSEUR 1"]
[2,3410280028071,"PILES LR03 X10",20]
[2,13,"SEL FIN 500G",20]
[2,14,"COCA COLA 1.5L",30]
[1,3410280078397,"COCA COLA 1.5L",20,"FOURNISSEUR 1"]

{"sheet":"Produits stock zero","index":6,"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":7,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Liste produits avec stock minimum"]
["Gencode","Produit","Fournisseur","Famille"]

{"sheet":"BASE DE DONNEES","index":8,"n_rows":5,"n_cols":51,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Réf","Gencode","Produit","Prix vente TTC","Code 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","Sitation promo","Stock mini","Qté","Gencode","Produit","Prix vente TTC","Code 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","Sitation promo","Stock mini","Qté"]
[3250390534624,3250390534624,"SUCRE EN MORCEAUX 1KG",1.2,1,1000,1.2,"kg","3CFKNTA*fdegce+",0.55000000000000004,"FOURNISSEUR 2","Alimentation 5.5%",null,null,"Standard",null,null,null,1,"2017-07-01","2017-07-08",0.79,null,{"$f":"IF(AND(T2<TODAY(),U2>TODAY()),\"En promo\",IF(T2=TODAY(),\"Début promo\",IF(U2=TODAY(),\"Fin promo\",IF(T2>TODAY(),\"Promo programmée\"))))","v":"Fin promo"},0,null,3250390534624,"SUCRE EN MORCEAUX 1KG",1.2,1,1000,1.2,"kg","3CFKNTA*fdegce+",0.55000000000000004,"FOURNISSEUR 2","Alimentation 5.5%",0,null,"Standard",0,null,null,1,"2017-07-01","2017-07-07",0.89,null,"Fin promo",0]
[13,13,"SEL FIN 500G",0.8,1,500,1.6,"kg",null,0,"FOURNISSEUR 1","Alimentation 5.5%",4,null,"Standard",4,null,null,null,null,null,null,null,{"$f":"IF(AND(T3<TODAY(),U3>TODAY()),\"En promo\",IF(T3=TODAY(),\"Début promo\",IF(U3=TODAY(),\"Fin promo\",IF(T3>TODAY(),\"Promo programmée\"))))","v":false},0,null,3410280028071,"PILES LR03 X10",1.89,2,1000,1.89,"U","3EBKMSA*aciahb+",0,"FOURNISSEUR 2","Bazar",17,null,"Standard",17,"GS",null,1,"2017-07-06","2017-07-15",1.5,null,"En promo",0]
[3410280078397,3410280078397,"COCA COLA 1.5L",1.9,1,1500,1.2666666666666666,"litre","3EBKMSA*ahidjh+",0.89,"FOURNISSEUR 1","Alimentation 5.5%",6,{"$f":"SUMIF(Factures!$A$5:$A$24,A4,Factures!$C$5:$C$24)","v":0},"Standard",6,"GS",null,1,null,null,null,null,{"$f":"IF(AND(T4<TODAY(),U4>TODAY()),\"En promo\",IF(T4=TODAY(),\"Début promo\",IF(U4=TODAY(),\"Fin promo\",IF(T4>TODAY(),\"Promo programmée\"))))","v":false},5]
[3410280028071,3410280028071,"PILES LR03 X10",1.89,2,1000,1.89,"U","3EBKMSA*aciahb+",0,"FOURNISSEUR 2","Bazar",null,null,"Standard",null,"GS",null,1,"2017-07-06","2017-07-15",1.5,null,{"$f":"IF(AND(T5<TODAY(),U5>TODAY()),\"En promo\",IF(T5=TODAY(),\"Début promo\",IF(U5=TODAY(),\"Fin promo\",IF(T5>TODAY(),\"Promo programmée\"))))","v":"En promo"},0]

{"sheet":"INVENTAIRE","index":9,"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  samedi 08 juillet 2017"}]
[]
["Gencode","Produit","Qté","Date","Libellé inventaire"]

{"sheet":"DETAIL INVENTAIRES","index":10,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["N° Inventaire","Gencode","Produit","Qté","Date","Libellé inventaire","N° Inventaire","Produit","N° Inventaire","Gencode","Produit","Qté","Date","Libellé inventaire"]
[1,12,{"$f":"IFERROR(VLOOKUP(B2,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"Produit inconnu"},30,{"$f":"TODAY()","v":"2017-07-08"},"Inventaire juin 2017","6",null,6,13,"SEL FIN 500G",4,"2017-07-07T02:11:13","Inventaire aout"]
[1,13,{"$f":"IFERROR(VLOOKUP(B3,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"SEL FIN 500G"},23,"2017-07-08","Inventaire juin 2017",null,null,6,15,"Produit inconnu",5,"2017-07-07T02:11:32","Inventaire aout"]
[1,14,{"$f":"IFERROR(VLOOKUP(B4,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"Produit inconnu"},3,"2017-07-08","Inventaire juin 2017",null,null,6,3410280078397,"COCA COLA 1.5L",6,"2017-07-07T02:12:45","Inventaire aout"]
[1,30,{"$f":"IFERROR(VLOOKUP(B5,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"Produit inconnu"},1,"2017-07-08","Inventaire juin 2017"]
[2,13,{"$f":"IFERROR(VLOOKUP(B6,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"SEL FIN 500G"},6,"2017-07-08","INventaire juillet 2017"]
[2,14,{"$f":"IFERROR(VLOOKUP(B7,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"Produit inconnu"},9,"2017-07-08","INventaire juillet 2017"]
[2,13,{"$f":"IFERROR(VLOOKUP(B8,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"SEL FIN 500G"},10,"2017-07-08","INventaire juillet 2017"]
[2,30,{"$f":"IFERROR(VLOOKUP(B9,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"Produit inconnu"},2,"2017-07-08","INventaire juillet 2017"]
[3,3410280028071,{"$f":"IFERROR(VLOOKUP(B10,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"PILES LR03 X10"},20,{"$f":"TODAY()","v":"2017-07-08"},"Inventaire juillet 2017"]
[3,13,{"$f":"IFERROR(VLOOKUP(B11,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"SEL FIN 500G"},10,{"$f":"TODAY()","v":"2017-07-08"},"Inventaire juillet 2017"]
[4,12,{"$f":"IFERROR(VLOOKUP(B12,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"Produit inconnu"},2,{"$f":"TODAY()","v":"2017-07-08"},"Inventaire de juin 2017"]
[4,3410280078397,{"$f":"IFERROR(VLOOKUP(B13,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"COCA COLA 1.5L"},10,{"$f":"TODAY()","v":"2017-07-08"},"Inventaire de juin 2017"]
[4,13,{"$f":"IFERROR(VLOOKUP(B14,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"SEL FIN 500G"},2,{"$f":"TODAY()","v":"2017-07-08"},"Inventaire de juin 2017"]
[5,13,{"$f":"IFERROR(VLOOKUP(B15,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"SEL FIN 500G"},1,"2017-07-07T02:09:30","Inventaire test"]
[5,3410280078397,{"$f":"IFERROR(VLOOKUP(B16,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"COCA COLA 1.5L"},10,"2017-07-07T02:09:47","Inventaire test"]
[6,13,{"$f":"IFERROR(VLOOKUP(B17,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"SEL FIN 500G"},4,"2017-07-07T02:11:13","Inventaire aout"]
[6,15,{"$f":"IFERROR(VLOOKUP(B18,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"Produit inconnu"},5,"2017-07-07T02:11:32","Inventaire aout"]
[6,3410280078397,{"$f":"IFERROR(VLOOKUP(B19,'BASE DE DONNEES'!B:C,2,FALSE),\"Produit inconnu\")","v":"COCA COLA 1.5L"},6,"2017-07-07T02:12:45","Inventaire aout"]

{"sheet":"LISTE INVENTAIRES","index":11,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,1,2]]}
["Liste des inventaires"]
[]
["N° Inventaire","Libellé inventaire","Date inventaire"]
[1,"Inventaire juin 2017",{"$f":"TODAY()","v":"2017-07-08"}]
[2,"INventaire juillet 2017","2017-07-08"]
[3,"Inventaire juillet 2017","2017-07-08"]
[4,"Inventaire de juin 2017","2017-07-08"]
[5,"Inventaire test","2017-07-08"]
[6,"Inventaire aout","2017-07-08"]

{"sheet":"ETIQUETTE","index":12,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[6,3,8,8],[9,3,11,5],[9,6,11,8],[13,3,13,8]]}
[1,null,null,null,null,null,null,null,null,null,5.5E-2]
[null,null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Don"]
[null,null,null,null,null,null,null,null,null,null,null,"Autre"]
[null,null,null,"SALADE MECHOUIA 350G",null,null,null,null,null,null,null,"Casse"]
[null,null,null,null,null,null,null,null,null,null,null,"Vol"]
[null,null,null,null,null,null,null,null,null,null,null,"Périmé"]
[null,null,null,2.9,null,null,"6BTLPBE*gaaccb+"]
[null,null," "]
[]
[null,null,null,null,null,null,"(Soit",2.9,"/ kg )"]

{"sheet":"ETIQUETTES","index":13,"n_rows":57,"n_cols":15,"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,{"$f":"IF('PRODUITS ETIQUETTES'!$B2=\"\",\"\",'PRODUITS ETIQUETTES'!$B2)","v":"SUCRE EN MORCEAUX 1KG"},null,null,null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B3=\"\",\"\",'PRODUITS ETIQUETTES'!$B3)","v":"SUCRE EN MORCEAUX 1KG"}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C2=\"\",\"\",'PRODUITS ETIQUETTES'!$C2)","v":"1,20 €"},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G2=\"\",\"\",'PRODUITS ETIQUETTES'!$G2)","v":"3CFKNTA*fdegce+"},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$C3=\"\",\"\",'PRODUITS ETIQUETTES'!$C3)","v":"0,89 €"},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$G3=\"\",\"\",'PRODUITS ETIQUETTES'!$G3)","v":"3CFKNTA*fdegce+"}]
[]
[]
[null,null,null,{"$f":"IF('PRODUITS ETIQUETTES'!H2=\"\",\"\",'PRODUITS ETIQUETTES'!H2)","v":""},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B2=\"\",\"\",\"(Soit \")","v":"(Soit "},{"$f":"(IF('PRODUITS ETIQUETTES'!$E2=\"\",\"\",'PRODUITS ETIQUETTES'!$E2))","v":1.2},{"$f":"IF('PRODUITS ETIQUETTES'!$F2=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F2&\" )\")","v":"/ kg )"},{"$f":"IF('PRODUITS ETIQUETTES'!H3=\"\",\"\",'PRODUITS ETIQUETTES'!H3)","v":"Promo"},null,null,{"$f":"IF('PRODUITS ETIQUETTES'!$B3=\"\",\"\",\"(Soit \")","v":"(Soit "},{"$f":"(IF('PRODUITS ETIQUETTES'!$E3=\"\",\"\",'PRODUITS ETIQUETTES'!$E3))","v":"0,89 €"},{"$f":"IF('PRODUITS ETIQUETTES'!$F3=\"\",\"\",\"/ \"&'PRODUITS ETIQUETTES'!$F3&\"  )\")","v":"/ kg  )"}]
[]
[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":14,"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"]
["3250390534624","SUCRE EN MORCEAUX 1KG","1,20 €",1000,1.2,"kg","3CFKNTA*fdegce+"]
["3250390534624","SUCRE EN MORCEAUX 1KG","0,89 €",null,"0,89 €","kg","3CFKNTA*fdegce+","Promo"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"FAMILLES","index":15,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Réf","FAMILLES","Taux tva","Code tva",null,"kg"]
["F1","Alimentation 5.5%",5.5E-2,{"$f":"IF(C2=5.5%,1,IF(C2=20%,2,IF(C2=10%,3,IF(C2=0%,4))))","v":1},null,"U"]
["F2","Alimentation 20%",0.2,{"$f":"IF(C3=5.5%,1,IF(C3=20%,2,IF(C3=10%,3,IF(C3=0%,4))))","v":2},null,"litre"]
["F3","Viandes",5.5E-2,{"$f":"IF(C4=5.5%,1,IF(C4=20%,2,IF(C4=10%,3,IF(C4=0%,4))))","v":1},null,"Pièce"]
["F4","Charcuterie",5.5E-2,{"$f":"IF(C5=5.5%,1,IF(C5=20%,2,IF(C5=10%,3,IF(C5=0%,4))))","v":1},null,"Botte"]
["F5","Patisserie",5.5E-2,{"$f":"IF(C6=5.5%,1,IF(C6=20%,2,IF(C6=10%,3,IF(C6=0%,4))))","v":1},null,"Lot"]
["F6","Bazar",0.2,{"$f":"IF(C7=5.5%,1,IF(C7=20%,2,IF(C7=10%,3,IF(C7=0%,4))))","v":2},null,"M"]
["F7","BOISSONS",5.5E-2,{"$f":"IF(C8=5.5%,1,IF(C8=20%,2,IF(C8=10%,3,IF(C8=0%,4))))","v":1}]
["F8","Famille8",0,4]
["F9","Famille9",0,4]
["F10","Famille10",0,4]

{"sheet":"DEMARQUE","index":16,"n_rows":10,"n_cols":26,"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":3.78}]
[12,"SUCRE EN MORCEAUX 1KG",0.95,0,"FOURNISSEUR 1","Alimentation 5.5%","Casse",1,{"$f":"TODAY()","v":"2017-07-08"},"2017-07-05","2017-07-07","Vol",{"$f":"IF(L2=\"\",\"\",L2)","v":"Vol"},{"$f":"IF(J2=\"\",\"\",\">=\"&J2)","v":">=42921"},{"$f":"IF(K2=\"\",\"\",\"<=\"&K2)","v":"<=42923"},3410280028071,"PILES LR03 X10",1.89,0,"FOURNISSEUR 2","Bazar","Vol",1,"2017-07-07",{"$f":"IF(P2=\"\",\"\",R2*W2)","v":1.89}]
[3410280028071,"PILES LR03 X10",1.89,0,"FOURNISSEUR 2","Bazar","Vol",1,{"$f":"TODAY()","v":"2017-07-08"},null,null,null,null,null,null,3410280028071,"PILES LR03 X10",1.89,0,"FOURNISSEUR 2","Bazar","Vol",1,"2017-07-07",{"$f":"IF(P3=\"\",\"\",R3*W3)","v":1.89}]
[3410280028071,"PILES LR03 X10",1.89,0,"FOURNISSEUR 2","Bazar","Vol",1,{"$f":"TODAY()","v":"2017-07-08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P4=\"\",\"\",R4*W4)","v":""}]
[3410280078397,"COCA COLA 1.5L",1.9,0.89,"FOURNISSEUR 1","Alimentation 5.5%","Périmé",1,{"$f":"TODAY()","v":"2017-07-08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P5=\"\",\"\",R5*W5)","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(P6=\"\",\"\",R6*W6)","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,""]

{"sheet":"Facture en attente","index":17,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":true,"merged":[[29,2,29,4],[1,0,2,0],[1,1,2,1],[1,2,2,4],[25,2,25,4],[26,2,26,4],[34,2,34,4],[39,1,39,5],[35,2,35,3],[35,4,35,5],[1,6,2,6],[33,1,33,5],[1,5,2,5],[24,2,24,4],[36,1,36,4],[37,2,37,4],[38,2,38,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[27,2,27,4],[28,2,28,4]]}
[]
["Code client",null,{"$f":"TODAY()","v":"2017-07-08"},null,null,{"$f":"NOW()","v":42924.082206018516}]
[]
["Réf","Produit","Qté","Prix","Remise","Montant","Montant tva","Remise","Famille","Code TVA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total TTC"]
[]
[]
[]
[]
[]
[null,null,"Mnt TVA 20%"]
[null,null,"Mnt TVA 5,5%"]
[null,null,"Mnt TVA 10%"]
[]
[]
[null,null,"Ticket N°:"]
[null,{"$f":"IF(PARAMETRES!K2=\"\",\"\",PARAMETRES!K2)","v":"Merci de votre visite et à bientôt"}]
[null,"Ancien solde","Nouveau solde",null,null,"Remise"]
[]
[null,"Vous avez été servi par Manager"]

{"sheet":"PARAMETRES","index":18,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Entreprise","Adresse","Complément adresse","CP","Ville","Tél","Fax","SIREN","Taux TVA","Enseigne","Pied de page","N° TVA","AUTO-ENTREPRENEUR","Répertoire ","FAMILLE PRINCIPALE","Devise "]
[null,null,null,null,null,null,null,null,null,null,"Merci de votre visite et à bientôt",null,"Non","C:\\Users\\TALEB\\Desktop\\Z-Caisse","BOISSONS","€"]

{"sheet":"Factures","index":19,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,1,45,5],[38,2,38,4],[39,1,39,5],[24,2,24,4],[35,2,35,3],[35,4,35,5],[27,2,27,4],[28,2,28,4],[29,2,29,4],[34,2,34,4],[33,1,33,5],[25,2,25,4],[26,2,26,4],[30,2,30,4],[1,7,2,7],[1,6,2,6],[37,2,37,4],[0,1,0,5],[36,1,36,5],[1,0,2,0],[1,1,2,1],[1,2,2,3],[1,4,2,5],[40,1,40,5],[31,2,31,4],[32,2,32,4]]}
[null,{"$f":"PARAMETRES!A2   & \"                                                                                      \" &PARAMETRES!B2 & \"                                                                       \"     &PARAMETRES!C2 &\"                                                                                                                 \" &PARAMETRES!D2 & \"          \" & PARAMETRES!E2&\"                                              \"&\"                                                Tél: \"& PARAMETRES!F2   & \"    Fax: \"&PARAMETRES!G2& \"                                                            SIREN: \"&PARAMETRES!H2  &\"                                                                                                 N° TVA: \"&PARAMETRES!L2","v":"                                                                                                                                                                                                                                                                                                                                                                                      Tél:     Fax:                                                             SIREN:                                                                                                  N° TVA: "}]
[null,2,{"$f":"TODAY()","v":"2017-07-08"},null,{"$f":"NOW()","v":42924.082204745369},null,"Manager"]
[]
["Réf","Produit","Qté","Prix","Remise","Montant","Mnt tva","Mnt remise","Famille","Code TVA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total TTC",null,null,{"$f":"SUM(F5:F24)","v":0},{"$f":"SUM(G5:G24)","v":0},{"$f":"SUM(H5:H24)","v":0}]
[null,null,"Total remise",null,null,0]
[]
[]
[]
[]
[null,null,"Mnt TVA 20%"]
[null,null,"Mnt TVA 5,5%"]
[null,null,"Mnt TVA 10%"]
[]
[]
[null,null,"Ticket N°:",null,7]
[]
[null,"Ancien solde","Nouveau solde",null,null,"Remise"]
[null,null,0,null,null,0]
[]
[null,"Vous avez été servi par Manager"]
[]
[]
[]
[]
[null,{"$f":"IF(PARAMETRES!J2=\"\",\"\",PARAMETRES!J2)","v":""}]

{"sheet":"CLIENTS","index":20,"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":"FACTURATION","index":21,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,0,43,5],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[42,1,42,5],[30,2,30,4],[31,2,31,4],[32,2,32,4],[29,2,29,4],[33,2,33,4],[0,0,2,1],[5,2,5,5],[6,1,7,1],[6,2,7,3],[0,3,1,5],[2,3,2,5],[3,3,3,5]]}
[{"$f":"PARAMETRES!A2 &\"          \" & PARAMETRES!B2 & \"               \" & PARAMETRES!C2 & \"          \" & PARAMETRES!D2 & \" \" & PARAMETRES!E2","v":"                                    "},null,null,{"$f":"IFERROR(VLOOKUP(B5,Base!A:K,2,0),\"saisir un code client valide\")","v":"CLIENT 2"},null,null,null,7]
[]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B5,Base!A:K,11,0),\"\")","v":"BAT D"}]
["SIRET:",{"$f":"IF(PARAMETRES!H2=\"\",\"\",PARAMETRES!H2)","v":""},null,{"$f":" IFERROR(VLOOKUP(B5,Base!A:K,3,0),\"\")& \"      \"&IFERROR(VLOOKUP(B5,Base!A:K,9,0),\"\")","v":"83000      TOULON"}]
["Code client:",2]
["Date:",{"$f":"TODAY()","v":"2017-07-08"},{"$f":"IFERROR(VLOOKUP(B5,Base!A:K,2,FALSE),\"saisir un code client valide\")","v":"CLIENT 2"}]
[null,"FACTURE N°","Fac- 7"]
[]
["Réf","Produit","Qté","Prix","Remise","Montant","Mnt TVA","Mnt Remise"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total TTC"]
[]
[]
[]
[]
[]
[null,null,"Mnt TVA 20%"]
[null,null,"Mnt TVA 5,5%"]
[null,null,"Mnt TVA 10%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(PARAMETRES!J2=\"\",\"\",PARAMETRES!J2)","v":""}]
[null,{"$f":"IF(PARAMETRES!K7=\"\",\"\",PARAMETRES!K7)","v":""}]

{"sheet":"ENCAISSEMENT MOIS","index":22,"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":"Alimentation 5.5%"},{"$f":"IF(FAMILLES!B3=\"\",\"\",FAMILLES!B3)","v":"Alimentation 20%"},{"$f":"IF(FAMILLES!B4=\"\",\"\",FAMILLES!B4)","v":"Viandes"},{"$f":"IF(FAMILLES!B5=\"\",\"\",FAMILLES!B5)","v":"Charcuterie"},{"$f":"IF(FAMILLES!B6=\"\",\"\",FAMILLES!B6)","v":"Patisserie"},{"$f":"IF(FAMILLES!B7=\"\",\"\",FAMILLES!B7)","v":"Bazar"},{"$f":"IF(FAMILLES!B8=\"\",\"\",FAMILLES!B8)","v":"BOISSONS"},{"$f":"IF(FAMILLES!B9=\"\",\"\",FAMILLES!B9)","v":"Famille8"},{"$f":"IF(FAMILLES!B10=\"\",\"\",FAMILLES!B10)","v":"Famille9"},{"$f":"IF(FAMILLES!B11=\"\",\"\",FAMILLES!B11)","v":"Famille10"},"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":"BOUTONS FAMILLE1","index":23,"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":"Alimentation 5.5%"},null,null,null,{"$f":"FAMILLES!B3","v":"Alimentation 20%"},null,null,null,{"$f":"FAMILLES!B4","v":"Viandes"},null,null,null,{"$f":"FAMILLES!B5","v":"Charcuterie"},null,null,null,{"$f":"FAMILLES!B6","v":"Patisserie"},null,null,null,{"$f":"FAMILLES!B7","v":"Bazar"},null,null,null,{"$f":"FAMILLES!B8","v":"BOISSONS"},null,null,null,{"$f":"FAMILLES!B9","v":"Famille8"},null,null,null,{"$f":"FAMILLES!B10","v":"Famille9"},null,null,null,{"$f":"FAMILLES!B11","v":"Famille10"}]
["CommandButton1","SUCRE EN MORCEAUX 1KG   0,79 €","SUCRE EN MORCEAUX 1KG","Famille1","CommandButton1",1,null,"Famille2","CommandButton1","SEL 500G   0,60 €","SEL 500G","Famille3","CommandButton1",1,null,"Famille4","CommandButton1","SALADE MECHOUIA 350G   2,90 DH","SALADE MECHOUIA 350G","Famille5","CommandButton1","ASSIETTE RONDE 25CM   0,99 €","ASSIETTE RONDE 25CM","Famille6","CommandButton1","COCA COLA 1.5L   1,90 €","COCA COLA 1.5L","Famille7","CommandButton1","SALADE MECHOUIA 350G   2,90 DH","SALADE MECHOUIA 350G","Famille8","CommandButton1","SALADE MECHOUIA 350G   2,90 DH","SALADE MECHOUIA 350G","Famille9","CommandButton1","SALADE MECHOUIA 350G   2,90 DH","SALADE MECHOUIA 350G","Famille10"]
["CommandButton2","SEL FIN 500G   0,80 €","SEL FIN 500G","Famille1","CommandButton2",2,null,"Famille2","CommandButton2","CILIT BANG 500ML   2,95 €","CILIT BANG 500ML","Famille3","CommandButton2",2,null,"Famille4","CommandButton2",2,null,"Famille5","CommandButton2","CILIT BANG 500ML   2,50 €","CILIT BANG 500ML","Famille6","CommandButton2","PILES LR03 X10   1,50 €","PILES LR03 X10","Famille7","CommandButton2",2,null,"Famille8","CommandButton2",2,null,"Famille9","CommandButton2",2,null,"Famille10"]
["CommandButton3",3,null,"Famille1","CommandButton3",3,null,"Famille2","CommandButton3",3,null,"Famille3","CommandButton3",3,null,"Famille4","CommandButton3",3,null,"Famille5","CommandButton3","VERRE 20CL   0,99 €","VERRE 20CL","Famille6","CommandButton3",3,null,"Famille7","CommandButton3",3,null,"Famille8","CommandButton3",3,null,"Famille9","CommandButton3",3,null,"Famille10"]
["CommandButton4",4,null,"Famille1","CommandButton4",4,null,"Famille2","CommandButton4",4,null,"Famille3","CommandButton4",4,null,"Famille4","CommandButton4",4,null,"Famille5","CommandButton4","SEL 500G   0,60 €","SEL 500G","Famille6","CommandButton4",4,null,"Famille7","CommandButton4",4,null,"Famille8","CommandButton4",4,null,"Famille9","CommandButton4",4,null,"Famille10"]
["CommandButton5",5,null,"Famille1","CommandButton5",5,null,"Famille2","CommandButton5",5,null,"Famille3","CommandButton5",5,null,"Famille4","CommandButton5",5,null,"Famille5","CommandButton5","PILES LR03 X10   1,50 €","PILES LR03 X10","Famille6","CommandButton5",5,null,"Famille7","CommandButton5",5,null,"Famille8","CommandButton5",5,null,"Famille9","CommandButton5",5,null,"Famille10"]
["CommandButton6",6,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",7,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",8,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",9,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",10,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",11,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",12,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",13,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",14,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",15,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",16,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",17,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",18,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",19,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",20,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",21,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",22,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",23,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",24,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":"Base","index":24,"n_rows":3,"n_cols":13,"rows_kept":3,"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":2}]
[1,"TALEB",83660,"00 06 00 00 00",1.4,5,0,0,"CARNOULES","2017-07-06","BAT C"]
[2,"CLIENT 2",83000,null,0,1,0,0,"TOULON",null,"BAT D"]

{"sheet":"Utilisateurs","index":25,"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,"CAISSIER 1",11111]

{"sheet":"BOUTONS","index":26,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["CommandButton1",1,null,null,"Bouton","Nom famille","Réf"]
["CommandButton2","ANANAS   2,60 €",11,null,"CommandButton1","Alimentation 5.5%","F1"]
["CommandButton3","OIGNONS RGES   2,30 €",50,null,"CommandButton2","Bazar","F2"]
["CommandButton4","OIGNONS JAUNE   1,19 €",48,null,"CommandButton3","Patisserie","F3"]
["CommandButton5",5,null,null,"CommandButton4","Charcuterie","F4"]
["CommandButton6",6,null,null,"CommandButton5",5]
["CommandButton7",7,null,null,"CommandButton6",6]
["CommandButton8",8,null,null,"CommandButton7",7]
["CommandButton9",9,null,null,"CommandButton8",8]
["CommandButton10",10,null,null,"CommandButton9",9]
["CommandButton11",11,null,null,"CommandButton10",10]
["CommandButton12",12]
["CommandButton13",13]
["CommandButton14",14]
["CommandButton15",15]
["CommandButton16",16]
["CommandButton17",17]
["CommandButton18",18]
["CommandButton19",19]
["CommandButton20",20]
["CommandButton21",21]
["CommandButton22",22]
["CommandButton23",23]
["CommandButton24",24]
["CommandButton25",25]
["CommandButton26",26]
["CommandButton27",27]
["CommandButton28",28]
["CommandButton29",29]
["CommandButton30",30]
["CommandButton31",31]
["CommandButton32",32]
["CommandButton33",33]
["CommandButton34",34]
["CommandButton35",35]
["CommandButton36",36]
["CommandButton37",37]
["CommandButton38",38]
["CommandButton39",39]
["CommandButton40",40]
["CommandButton41",41]
["CommandButton42",42]
["CommandButton43",43]
["CommandButton44",44]
["CommandButton45",45]
["CommandButton46",46]
["CommandButton47",47]
["CommandButton48",48]

{"sheet":"FDC","index":27,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,0,2,2],[4,1,4,2],[6,1,6,2],[8,1,8,2],[10,0,10,2]]}
[]
[]
["Fond de caisse "]
[]
["Date","2017-07-06T04:09:54"]
[]
["Caissier","Manager"]
[]
["Montant FDC",40]
[]
[{"$f":"Factures!B46","v":""}]

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

{"sheet":"Fournisseurs","index":29,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Rèf","Fournisseur","Adresse","Code postal","Ville","Tél","Fax","Mobile","E-mail"]
["FOUR1","FOURNISSEUR 1","Adresse 1",83000,"Toulon",4,"00 00 02 36 54",6,"mail1@neuf.fr"]
["FOUR2","FOURNISSEUR 2","Adresse 2",13000,"MARSEILLE","00 00 00 00 04","00 00 00 00 04","00 00 00 00 06","mail2@free.fr"]

{"sheet":"PERIODE VENTE","index":30,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["date debut","date fin","chiffre d'affaire","Total tva","Total tva 5,50%","Total tva 20,00%","Total tva 10,00%"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"Encaissements","index":31,"n_rows":7,"n_cols":27,"rows_kept":7,"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":"Alimentation 5.5%"},{"$f":"FAMILLES!B3","v":"Alimentation 20%"},{"$f":"FAMILLES!B4","v":"Viandes"},{"$f":"FAMILLES!B5","v":"Charcuterie"},{"$f":"FAMILLES!B6","v":"Patisserie"},{"$f":"FAMILLES!B7","v":"Bazar"},{"$f":"FAMILLES!B8","v":"BOISSONS"},{"$f":"FAMILLES!B9","v":"Famille8"},{"$f":"FAMILLES!B10","v":"Famille9"},{"$f":"FAMILLES!B11","v":"Famille10"},"CAISSIER","CA TVA 20%","Mont TVA","CA TVA 5,5%","Mont TVA","CA TVA 10%","Mont TVA","CA TVA 0,00%"]
["Ticket N°:6",{"$f":"TODAY()","v":"2017-07-08"},{"$f":"NOW()","v":42924.082204745369},7,7,0,0,0,null,{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!$I$5:$I$24,FAMILLES!B2)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!$I$5:$I$24,FAMILLES!B3)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!$I$5:$I$24,FAMILLES!B4)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!$I$5:$I$24,FAMILLES!B5)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!$I$5:$I$24,FAMILLES!B6)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!$I$5:$I$24,FAMILLES!B7)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!$I$5:$I$24,FAMILLES!B8)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!$I$5:$I$24,FAMILLES!B9)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!$I$5:$I$24,FAMILLES!B10)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!$I$5:$I$24,FAMILLES!B11)","v":0},"Manager",{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!J5:J24,2)","v":0},{"$f":"SUMIFS(Factures!$G$5:$G$24,Factures!J5:J24,2)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!J5:J24,1)","v":0},{"$f":"SUMIFS(Factures!$G$5:$G$24,Factures!J5:J24,1)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!J5:J24,3)","v":0},{"$f":"SUMIFS(Factures!$G$5:$G$24,Factures!J5:J24,3)","v":0},{"$f":"SUMIFS(Factures!$F$5:$F$24,Factures!J5:J24,4)","v":0}]
["Ticket N°:2","2017-07-06",42922.040350578704,2.7,2.7,0,0,0,null,2.7,0,0,0,0,0,0,0,0,0,"Manager",0,0,2.7,0.1404,0,0,0]
["Ticket N° 3","2017-06-07","04:09:30",6.9,"Manager",0,6.9,0,null,2.4,0,0,0,0,4.5,0,0,0,0,"Manager",4.5,0.75,2.4,0.12479999999999999,0,0,0]
["Ticket N°:4","2017-07-06",42922.19946087963,2.7,2.7,0,0,0,null,2.7,0,0,0,0,0,0,0,0,0,"CAISSIER 1",0,0,2.7,0.1404,0,0,0]
["Ticket N°:5","2017-07-07",42923.023482407407,8.4,2.4,6,0,0,null,8.4,0,0,0,0,0,0,0,0,0,"Manager",0,0,8.4,0.43680000000000002,0,0,0]
["Ticket N° 6","2017-07-07","00:38:21",7,"Manager",0,7,0,null,7,0,0,0,0,0,0,0,0,0,"Manager",0,0,7,0.36399999999999999,0,0,0]

{"sheet":"Z-CAISSE","index":32,"n_rows":4,"n_cols":31,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Date","Chiffre d'affaire","Espèces","CB","Chèques","Remise",{"$f":"IF(FAMILLES!B2=\"\",\"\",FAMILLES!B2)","v":"Alimentation 5.5%"},{"$f":"IF(FAMILLES!B3=\"\",\"\",FAMILLES!B3)","v":"Alimentation 20%"},{"$f":"IF(FAMILLES!B4=\"\",\"\",FAMILLES!B4)","v":"Viandes"},{"$f":"IF(FAMILLES!B5=\"\",\"\",FAMILLES!B5)","v":"Charcuterie"},{"$f":"IF(FAMILLES!B6=\"\",\"\",FAMILLES!B6)","v":"Patisserie"},{"$f":"IF(FAMILLES!B7=\"\",\"\",FAMILLES!B7)","v":"Bazar"},{"$f":"IF(FAMILLES!B8=\"\",\"\",FAMILLES!B8)","v":"BOISSONS"},{"$f":"IF(FAMILLES!B9=\"\",\"\",FAMILLES!B9)","v":"Famille8"},{"$f":"IF(FAMILLES!B10=\"\",\"\",FAMILLES!B10)","v":"Famille9"},{"$f":"IF(FAMILLES!B11=\"\",\"\",FAMILLES!B11)","v":"Famille10"},"NB Clients","CAISSIER","FOND DE CAISSE","ENTREE ARGENT","SORTIE ARGENT","CA TVA 20%","Mont TVA","CA TVA 5,5%","Mont TVA","CA TVA 10%","Mont TVA","CA TVA 0,00%","TOTAL ESPECES","TOTAL CB","TOTAL CHEQUES"]
[{"$f":"TODAY()","v":"2017-07-08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAISSIER 1"]
[{"$f":"TODAY()","v":"2017-07-08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAISSIER 1"]
["2017-07-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager",40,0,0,null,null,null,null,null,null,null,14.399999999999999,0,0]

{"sheet":"ZED-CAISSE","index":33,"n_rows":113,"n_cols":4,"rows_kept":113,"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],[116,0,116,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],[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],[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],[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],[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],[18,0,18,3],[3,1,3,2],[65,1,65,3],[66,1,66,3],[67,1,67,3],[68,1,68,3],[60,0,60,3],[64,1,64,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]]}
[{"$f":"\"Z-CAISSE du \"&   TEXT(B5,\"jjjj jj mmmm aaaa\" )","v":"Z-CAISSE du samedi 08 juillet 2017"}]
[{"$f":"TODAY()","v":"2017-07-08"}]
[]
[null,"Date",null,"Heure"]
["Z-CAISSE",{"$f":"TODAY()","v":"2017-07-08"},null,{"$f":"NOW()","v":42924.082206018516}]
["CAISSIER (E):","Manager"]
["Récapitulatif CA"]
["-------------------------"]
[null,"Date début",null,"Date fin"]
["Période","2017-07-07T01:15:19",null,{"$f":"B5","v":"2017-07-08"}]
["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=\"\",\"\",SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0}]
["Espèces",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$F$2,,,COUNTA('LISTE TICKETS'!$F:$F)-1,))))","v":0}]
["CB",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$G$2,,,COUNTA('LISTE TICKETS'!$G:$G)-1,))))","v":0}]
["Chèques",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$H$2,,,COUNTA('LISTE TICKETS'!$H:$H)-1,))))","v":0}]
["Remise",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$I$2,,,COUNTA('LISTE TICKETS'!$I:$I)-1,))))","v":0}]
["---------------------------------------------"]
["Analyse famille"]
["-------------------------"]
["Famille","CA TTC","%CA"]
[{"$f":"FAMILLES!B2","v":"Alimentation 5.5%"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(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":"Alimentation 20%"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(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":"Viandes"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(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":"Charcuterie"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(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":"Patisserie"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(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":"Bazar"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(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":"BOISSONS"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(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":"Famille8"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(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":"Famille9"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(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":"Famille10"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(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":"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'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$F$2,,,COUNTA('LISTE TICKETS'!$F:$F)-1,))))","v":0}]
["CB",null,{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$G$2,,,COUNTA('LISTE TICKETS'!$G:$G)-1,))))","v":0}]
["Chèque",null,{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(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(B12=\"\",0,SUMIFS('Z-CAISSE'!T:T,'Z-CAISSE'!A:A,DATE_Z>B10,DATE_Z,DATE_Z<=D10,'Z-CAISSE'!R:R,B6))","v":0}]
["Sorties",null,{"$f":"IF(B12=\"\",0,SUMIFS('Z-CAISSE'!U:U,'Z-CAISSE'!A:A,DATE_Z>B10,DATE_Z,DATE_Z<=D10,'Z-CAISSE'!R:R,B6))","v":0}]
["Fond de caisse",null,{"$f":"IF(B12=\"\",0,SUMIFS('Z-CAISSE'!S:S,'Z-CAISSE'!A:A,DATE_Z>B10,DATE_Z,DATE_Z<=D10,'Z-CAISSE'!R:R,B6))","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 20%",0.2,{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=2)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=2)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,))))","v":0}]
["TVA 5,5%",5.5E-2,{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=1)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=1)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,))))","v":0}]
["TVA 10%",0.1,{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=3)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=3)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,))))","v":0}]
["Exonérée",0,{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=4)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0}]
["---------------------------------------------"]
["CAISSIER (E):","CAISSIER 1"]
["Récapitulatif CA"]
["-------------------------"]
[null,"Date début",null,"Date fin"]
["Période","2017-07-07T01:15:19",null,{"$f":"B5","v":"2017-07-08"}]
["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=B59)*1)","v":0}]
["Chiffre d'affaire",{"$f":"IF('LISTE TICKETS'!$A$2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!$E:$E)-1,)=B59)*(OFFSET('LISTE TICKETS'!$D$2,,,COUNTA('LISTE TICKETS'!$D:$D)-1,))))","v":0}]
["Espèces",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B59)*(OFFSET('LISTE TICKETS'!$F$2,,,COUNTA('LISTE TICKETS'!$F:$F)-1,))))","v":0}]
["CB",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B59)*(OFFSET('LISTE TICKETS'!$G$2,,,COUNTA('LISTE TICKETS'!$G:$G)-1,))))","v":0}]
["Chèques",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B59)*(OFFSET('LISTE TICKETS'!$H$2,,,COUNTA('LISTE TICKETS'!$H:$H)-1,))))","v":0}]
["Remise",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B59)*(OFFSET('LISTE TICKETS'!$I$2,,,COUNTA('LISTE TICKETS'!$I:$I)-1,))))","v":0}]
["---------------------------------------------"]
["Analyse famille"]
["-------------------------"]
["Famille","CA TTC","%CA"]
[{"$f":"FAMILLES!B2","v":"Alimentation 5.5%"},{"$f":"IF($B$64=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":"Alimentation 20%"},{"$f":"IF($B$64=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":"FAMILLES!B4","v":"Viandes"},{"$f":"IF($B$64=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":"FAMILLES!B5","v":"Charcuterie"},{"$f":"IF($B$64=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":"FAMILLES!B6","v":"Patisserie"},{"$f":"IF($B$64=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":"FAMILLES!B7","v":"Bazar"},{"$f":"IF($B$64=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":"FAMILLES!B8","v":"BOISSONS"},{"$f":"IF($B$64=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":"FAMILLES!B9","v":"Famille8"},{"$f":"IF($B$64=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":"FAMILLES!B10","v":"Famille9"},{"$f":"IF($B$64=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":"FAMILLES!B11","v":"Famille10"},{"$f":"IF($B$64=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(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'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B59)*(OFFSET('LISTE TICKETS'!$F$2,,,COUNTA('LISTE TICKETS'!$F:$F)-1,))))","v":0}]
["CB",null,{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)>B10)*(OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)<=D10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B59)*(OFFSET('LISTE TICKETS'!$G$2,,,COUNTA('LISTE TICKETS'!$G:$G)-1,))))","v":0}]
["Chèque",null,{"$f":"IF(B6=\"\",0,SUMIFS('Z-CAISSE'!T:T,'Z-CAISSE'!A:A,DATE_Z>B4,DATE_Z,DATE_Z<=D4,'Z-CAISSE'!R:R,B53))","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(B12=\"\",0,SUMIFS('Z-CAISSE'!T:T,'Z-CAISSE'!A:A,DATE_Z>B10,DATE_Z,DATE_Z<=D10,'Z-CAISSE'!R:R,B59))","v":0}]
["Sorties",null,{"$f":"IF(B12=\"\",0,SUMIFS('Z-CAISSE'!U:U,'Z-CAISSE'!A:A,DATE_Z>B10,DATE_Z,DATE_Z<=D10,'Z-CAISSE'!R:R,B59))","v":0}]
["Fond de caisse",null,{"$f":"IF(B12=\"\",0,SUMIFS('Z-CAISSE'!S:S,'Z-CAISSE'!A:A,DATE_Z>B10,DATE_Z,DATE_Z<=D10,'Z-CAISSE'!R:R,B59))","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 20%",0.2,{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=2)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=2)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,))))","v":0}]
["TVA 5,5%",5.5E-2,{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=1)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=1)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,))))","v":0}]
["TVA 10%",0.1,{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=3)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=3)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,))))","v":0}]
["Exonérée",0,{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B59)*(OFFSET('SAUVEGARDE VENTE'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=4)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0}]
["---------------------------------------------"]
["le dernier Z-CAISSE a été effectué par",null,null,"Manager"]
["le ","2017-07-07T01:16:58"]

{"sheet":"LISTE TICKETS","index":34,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
["N° Ticket","Date",null,"Montant Total","CAISSIER","Mnt Esp","Mnt CB","Mnt CH","Remise","CA TVA 20%","Mont TVA","CA TVA 5,5%","Mont TVA","CA TVA 10%","Mont TVA","CA TVA 0,00%"]
["Ticket N° 1","2017-07-06","00:14:04",4.5,"Manager",0,4.5,0,0,0,0,4.5,0.23400000000000001,0,0,0]
["Ticket N° 2","2017-07-06",42922.040350578704,2.7,"Manager",2.7,0,0,0,0,0,2.7,0.1404,0,0,0]
["Ticket N° 3","2017-07-06",42922.040350578704,2.7,"Manager",2.7,0,0,0,0,0,2.7,0.1404,0,0,0]
["Ticket N° 4","2017-07-06",42922.19946087963,2.7,"CAISSIER 1",2.7,0,0,0,0,0,2.7,0.1404,0,0,0]
["Ticket N° 5","2017-07-07",42923.023482407407,8.4,"Manager",2.4,6,0,0,0,0,8.4,0.43680000000000002,0,0,0]
["Ticket N° 6","2017-07-07","00:38:21",7,"Manager",0,7,0,0,0,0,7,0.36399999999999999,0,0,0]

{"sheet":"X-CAISSE","index":35,"n_rows":58,"n_cols":20,"rows_kept":58,"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],[7,0,7,3],[6,0,6,3],[17,0,17,3],[9,1,9,2],[10,1,10,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],[21,2,21,3],[22,2,22,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],[33,0,33,3],[36,2,36,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]]}
["Date","Chiffre d'affaire","Espèces","FDC","CB","Chèques","Remise",{"$f":"IF(FAMILLES!#REF!=\"\",\"\",FAMILLES!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(FAMILLES!#REF!=\"\",\"\",FAMILLES!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(FAMILLES!#REF!=\"\",\"\",FAMILLES!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(FAMILLES!#REF!=\"\",\"\",FAMILLES!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(FAMILLES!#REF!=\"\",\"\",FAMILLES!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(FAMILLES!#REF!=\"\",\"\",FAMILLES!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(FAMILLES!#REF!=\"\",\"\",FAMILLES!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(FAMILLES!#REF!=\"\",\"\",FAMILLES!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(FAMILLES!#REF!=\"\",\"\",FAMILLES!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(FAMILLES!#REF!=\"\",\"\",FAMILLES!#REF!)","v":{"$error":"#REF!"}},"NB Clients","CAISSIER1","CAISSIER2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TALEB TALEB"]
[]
[]
["X-CAISSE ",{"$f":"TODAY()","v":"2017-07-08"},null,{"$f":"NOW()","v":42924.082206018516}]
["CAISSIER (E):","Manager"]
["Récapitulatif CA"]
["-------------------------"]
[]
["Date","2017-07-07"]
["Nb clients",{"$f":"COUNTIFS('LISTE TICKETS'!E:E,'X-CAISSE'!B6:C6,'LISTE TICKETS'!B:B,'X-CAISSE'!B10:C10)","v":2}]
["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":15.400000000000002}]
["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":2.4}]
["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":13}]
["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":"Alimentation 5.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'!A21)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":15.400000000000002},{"$f":"IF(B21=0,\"\",B21/$B$12)","v":1}]
[{"$f":"FAMILLES!B3","v":"Alimentation 20%"},{"$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":"Viandes"},{"$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":"Charcuterie"},{"$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":"Patisserie"},{"$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":"Bazar"},{"$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":"BOISSONS"},{"$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":"Famille8"},{"$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":"Famille9"},{"$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":"Famille10"},{"$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":"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":""},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":2.4},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":-2.4}]
["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":13},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":-13}]
["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}]
[{"$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":"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":15.400000000000002}]
["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":15.400000000000002}]
["---------------------------------------------"]
["Analyse TVA"]
["Libellé","Taux","CA TTC","Montant TVA",null,"Total TVA"]
["TVA 20%",0.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'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=2)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$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'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=2)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,))))","v":0},null,{"$f":"SUM(D54:D57)","v":0.80079999999999996}]
["TVA 5,5%",5.5E-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'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=1)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":15.400000000000002},{"$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'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=1)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,))))","v":0.80079999999999996}]
["TVA 10%",0.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'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=3)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$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'!$K$7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=3)*(OFFSET('SAUVEGARDE VENTE'!$H$7,,,COUNTA('SAUVEGARDE VENTE'!$H:$H)-1,))))","v":0}]
["Exonérée",0,{"$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'!K7,,,COUNTA('SAUVEGARDE VENTE'!$K:$K)-1,)=4)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0}]
["---------------------------------------------"]

{"sheet":"SAUVEGARDE VENTE","index":36,"n_rows":19,"n_cols":30,"rows_kept":19,"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","2017-07-06",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","2017-07-07",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":">=42922"},{"$f":"IF(D2=\"\",\"\",\"<=\"&D2)","v":"<=42923"},{"$f":"IF(D3=\"\",\"\",D3)","v":"Alimentation 20%"},{"$f":"IF(D4=\"\",\"\",D4)","v":""},{"$f":"IF(D5=\"\",\"\",D5)","v":"CAISSIER 1"}]
[null,null,"Famille","Alimentation 20%"]
[null,null,"Produit"]
[null,null,"Caissier","CAISSIER 1"]
["DATE","Réf","Produit","Qté","Prix","Remise","Montant","Mt tva","Remise2","Famille","Code TVA","CAISSIER","DATE","Réf","Produit","Qté","Prix","Remise","Montant","Mt tva","Remise","Famille","Code TVA","CAISSIER"]
["2017-07-06",12,"SUCRE EN MORCEAUX 1KG",3,0.6,0,1.8,9.3600000000000003E-2,0,"Alimentation 5.5%",1,"Manager"]
["2017-07-06",13,"SEL FIN 500G",1,0.8,0,0.8,4.1599999999999998E-2,0,"Alimentation 5.5%",1,"Manager"]
["2017-07-06",14,"COCA COLA 1.5L",1,1.9,0,1.9,9.8799999999999999E-2,0,"Alimentation 5.5%",1,"Manager"]
["2017-07-06",13,"SEL FIN 500G",1,0.8,0,0.8,4.1599999999999998E-2,0,"Alimentation 5.5%",1,"Manager"]
["2017-07-06",14,"COCA COLA 1.5L",1,1.9,0,1.9,9.8799999999999999E-2,0,"Alimentation 5.5%",1,"Manager"]
["2017-07-06",13,"SEL FIN 500G",3,0.8,0,2.4,0.12479999999999999,0,"Alimentation 5.5%",1,"Manager"]
["2017-07-06",3410280028071,"PILES LR03 X10",3,1.5,0,4.5,0.75,0,"Bazar",2,"Manager"]
["2017-07-06",13,"SEL FIN 500G",1,0.8,0,0.8,4.1599999999999998E-2,0,"Alimentation 5.5%",1,"CAISSIER 1"]
["2017-07-06",14,"COCA COLA 1.5L",1,1.9,0,1.9,9.8799999999999999E-2,0,"Alimentation 5.5%",1,"CAISSIER 1"]
["2017-07-07",3410280078397,"COCA COLA 1.5L",4,1.9,0,7.6,0.3952,0,"Alimentation 5.5%",1,"Manager"]
["2017-07-07",13,"SEL FIN 500G",1,0.8,0,0.8,4.1599999999999998E-2,0,"Alimentation 5.5%",1,"Manager"]
["2017-07-07",13,"SEL FIN 500G",4,0.8,0,3.2,0.16639999999999999,0,"Alimentation 5.5%",1,"Manager"]
["2017-07-07",3410280078397,"COCA COLA 1.5L",2,1.9,0,3.8,0.1976,0,"Alimentation 5.5%",1,"Manager"]

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

{"sheet":"TACHES REALISEES","index":38,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["TACHES REALISEES","DATE"]
["message important",{"$f":"TODAY()","v":"2017-07-08"}]
["Appeler le fournisseur",{"$f":"TODAY()","v":"2017-07-08"}]
["Ranger le rayon",{"$f":"TODAY()","v":"2017-07-08"}]
["revoir le z-caisse",{"$f":"TODAY()","v":"2017-07-08"}]
["Enregistrer un message",{"$f":"TODAY()","v":"2017-07-08"}]

{"sheet":"Feuil1","index":39,"n_rows":3,"n_cols":22,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Réf","Code Barre","Produit","Prix vente TTC","Code TVA","Conditionnement","PRIX UNITAIRE","Unité de vente","Chaine","Prix d'Achat HT","Fournisseur","Famille","Stock Initial","Total achat","Vendu en ","Stock","GESTION STOCK","Type démarque","Qté démarque","Début promo","Fin promo","Prix promo"]
[]
["CODE ","NOM ","CP","TEL","SOLDE","NB ACHAT","POINTS","REMISE","VILLE","DERNIER PASSAGE","ADRESSE",null,{"$f":"MAX(Base!A:A)","v":2}]

{"sheet":"SUJETS","index":40,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SUJETS"]