{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["EAN 13","ACCUEIL","BASE DE DONNEES","ETIQUETTE","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"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":78,"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":[[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],[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],[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],[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],[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],[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],[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],[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],[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],[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]]}
["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":"BASE DE DONNEES","index":2,"n_rows":1,"n_cols":22,"rows_kept":1,"cut":false,"hidden":false,"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"]

{"sheet":"ETIQUETTE","index":3,"n_rows":14,"n_cols":12,"rows_kept":14,"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,"Autre"]
[null,null,null,"DROIT COMMERCIAL ",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,"10,00 €",null,null,"9HSMCRF*abidff+"]
[null,null," "]
[]
[null,null,null,null,null,"Réf : 1","(Soit",10,"/ U )"]
[null,null,null,"Promo du 18/01/2017 au 31/01/2017"]

{"sheet":"FAMILLES","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Réf","FAMILLES","Taux tva","Code tva",null,"kg"]
["F1","LIVRES",0.2,{"$f":"IF(C2=5.5%,1,IF(C2=20%,2,IF(C2=10%,3,IF(C2=0%,4))))","v":2},null,"U"]
["F2","CHEMISES",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","VESTES",0.2,{"$f":"IF(C4=5.5%,1,IF(C4=20%,2,IF(C4=10%,3,IF(C4=0%,4))))","v":2},null,"Pièce"]
["F4","Famille4",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","Famille5",0.1,{"$f":"IF(C6=5.5%,1,IF(C6=20%,2,IF(C6=10%,3,IF(C6=0%,4))))","v":3},null,"Lot"]
["F6","Famille6",5.5E-2,{"$f":"IF(C7=5.5%,1,IF(C7=20%,2,IF(C7=10%,3,IF(C7=0%,4))))","v":1},null,"M"]
["F7","Famille7",0,4]
["F8","Famille8",5.5E-2,1]
["F9","Famille9",5.5E-2,1]
["F10","Famille10",5.5E-2,1]

{"sheet":"DEMARQUE","index":5,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Réf","Code Barre","Produit","Prix de vente TTC","Prix d'Achat HT","Fournisseur","Famille","Type démarque","Qté démarque"]

{"sheet":"Facture en attente","index":6,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":true,"merged":[[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],[29,2,29,4],[1,0,2,0],[1,1,2,1],[1,2,2,4],[25,2,25,4],[26,2,26,4]]}
[]
["Code client",null,{"$f":"TODAY()","v":"2017-02-05"},null,null,{"$f":"NOW()","v":42771.591535879626}]
[]
["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":""}]
[null,"Ancien solde","Nouveau solde",null,null,"Remise"]
[]
[null,"Vous avez été servi par Manager"]

{"sheet":"PARAMETRES","index":7,"n_rows":1,"n_cols":15,"rows_kept":1,"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"]

{"sheet":"Factures","index":8,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[40,1,40,4],[1,7,2,7],[1,6,2,6],[37,2,37,4],[0,0,0,5],[1,0,2,0],[1,1,2,1],[1,2,2,3],[1,4,2,5],[36,1,36,5],[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],[31,2,31,4],[32,2,32,4]]}
[{"$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: "}]
["Code client",null,{"$f":"TODAY()","v":"2017-02-05"},null,{"$f":"NOW()","v":42771.591535879626},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,"Mnt TVA 20%"]
[null,null,"Mnt TVA 5,5%"]
[null,null,"Mnt TVA 10%"]
[]
[]
[null,null,"Ticket N°:",null,1]
[null,{"$f":"IF(PARAMETRES!K2=\"\",\"\",PARAMETRES!K2)","v":""}]
[null,"Ancien solde","Nouveau solde",null,null,"Remise"]
[]
[]
[null,"Vous avez été servi par DAVID"]
[]
[]
[]
[]
[null,{"$f":"IF(PARAMETRES!J2=\"\",\"\",PARAMETRES!J2)","v":""}]

{"sheet":"CLIENTS","index":9,"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":10,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[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],[30,2,30,4],[31,2,31,4],[32,2,32,4],[29,2,29,4],[33,2,33,4],[43,0,43,5],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[42,1,42,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":"saisir un code client valide"},null,null,null,1]
[]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B5,Base!A:K,11,0),\"\")","v":""}]
["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":"      "}]
["Code client:"]
["Date:",{"$f":"TODAY()","v":"2017-02-05"},{"$f":"IFERROR(VLOOKUP(B5,Base!A:K,2,FALSE),\"saisir un code client valide\")","v":"saisir un code client valide"}]
[null,"FACTURE N°","Fac- 1"]
[]
["Réf","Produit","Qté","Prix","Remise","Montant","Mnt TVA","Mnt Remise"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(PARAMETRES!J2=\"\",\"\",PARAMETRES!J2)","v":""}]
[null,{"$f":"IF(PARAMETRES!K7=\"\",\"\",PARAMETRES!K7)","v":""}]

{"sheet":"ENCAISSEMENT MOIS","index":11,"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":"LIVRES"},{"$f":"IF(FAMILLES!B3=\"\",\"\",FAMILLES!B3)","v":"CHEMISES"},{"$f":"IF(FAMILLES!B4=\"\",\"\",FAMILLES!B4)","v":"VESTES"},{"$f":"IF(FAMILLES!B5=\"\",\"\",FAMILLES!B5)","v":"Famille4"},{"$f":"IF(FAMILLES!B6=\"\",\"\",FAMILLES!B6)","v":"Famille5"},{"$f":"IF(FAMILLES!B7=\"\",\"\",FAMILLES!B7)","v":"Famille6"},{"$f":"IF(FAMILLES!B8=\"\",\"\",FAMILLES!B8)","v":"Famille7"},{"$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":12,"n_rows":25,"n_cols":40,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,20,0,23],[0,24,0,27],[0,28,0,31],[0,32,0,35],[0,36,0,39],[0,0,0,3],[0,4,0,7],[0,8,0,11],[0,12,0,15],[0,16,0,19]]}
[{"$f":"FAMILLES!B2","v":"LIVRES"},null,null,null,{"$f":"FAMILLES!B3","v":"CHEMISES"},null,null,null,{"$f":"FAMILLES!B4","v":"VESTES"},null,null,null,{"$f":"FAMILLES!B5","v":"Famille4"},null,null,null,{"$f":"FAMILLES!B6","v":"Famille5"},null,null,null,{"$f":"FAMILLES!B7","v":"Famille6"},null,null,null,{"$f":"FAMILLES!B8","v":"Famille7"},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","POUR MAITRAISER LES TESTS   8,00 €",4,"Famille1","CommandButton1",1,null,"Famille2","CommandButton1",1,null,"Famille3","CommandButton1",1,null,"Famille4","CommandButton1",1,null,"Famille5","CommandButton1","LIVRE   10,00 €",1,"Famille6","CommandButton1",1,null,"Famille7","CommandButton1",1,null,"Famille8","CommandButton1",1,null,"Famille9","CommandButton1",1,null,"Famille10"]
["CommandButton2","ARCHOS   65,00 €",2,"Famille1","CommandButton2",2,null,"Famille2","CommandButton2",2,null,"Famille3","CommandButton2",2,null,"Famille4","CommandButton2",2,null,"Famille5","CommandButton2",2,null,"Famille6","CommandButton2",2,null,"Famille7","CommandButton2",2,null,"Famille8","CommandButton2",2,null,"Famille9","CommandButton2",2,null,"Famille10"]
["CommandButton3","LE FORMULAIRE MPSI MP   10,00 €",3,"Famille1","CommandButton3",3,null,"Famille2","CommandButton3",3,null,"Famille3","CommandButton3",3,null,"Famille4","CommandButton3",3,null,"Famille5","CommandButton3",3,null,"Famille6","CommandButton3",3,null,"Famille7","CommandButton3",3,null,"Famille8","CommandButton3",3,null,"Famille9","CommandButton3",3,null,"Famille10"]
["CommandButton4","PILES AA LR6   1,79 €",5,"Famille1","CommandButton4",4,null,"Famille2","CommandButton4",4,null,"Famille3","CommandButton4",4,null,"Famille4","CommandButton4",4,null,"Famille5","CommandButton4",4,null,"Famille6","CommandButton4",4,null,"Famille7","CommandButton4",4,null,"Famille8","CommandButton4",4,null,"Famille9","CommandButton4",4,null,"Famille10"]
["CommandButton5","PRODUIT Y   18,00 €",6,"Famille1","CommandButton5",5,null,"Famille2","CommandButton5",5,null,"Famille3","CommandButton5",5,null,"Famille4","CommandButton5",5,null,"Famille5","CommandButton5",5,null,"Famille6","CommandButton5",5,null,"Famille7","CommandButton5",5,null,"Famille8","CommandButton5",5,null,"Famille9","CommandButton5",5,null,"Famille10"]
["CommandButton6",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":13,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["CODE ","NOM ","CP","TEL","SOLDE","NB ACHAT","POINTS","REMISE","VILLE","DERNIER PASSAGE","ADRESSE",null,{"$f":"MAX(Base!A:A)","v":1}]
[1,"TALEB",83660,768971051,null,null,null,null,"CARNOULES",null,"BAT C LES EOUVES ROUTE DE BESSE "]

{"sheet":"Utilisateurs","index":14,"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":15,"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","LIVRES","F1"]
["CommandButton3","OIGNONS RGES   2,30 €",50,null,"CommandButton2","CHEMISES","F2"]
["CommandButton4","OIGNONS JAUNE   1,19 €",48,null,"CommandButton3","VESTES","F3"]
["CommandButton5",5,null,null,"CommandButton4",4]
["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":16,"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-01-30T23:14:11"]
[]
["Caissier","DAVID"]
[]
["Montant FDC",35]
[]
[{"$f":"Factures!B46","v":""}]

{"sheet":"GESTION FIDELITE","index":17,"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":18,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Code","Fournisseur","Adresse","Code postal","Ville","Tél","Fax","Mobile","E-mail"]

{"sheet":"PERIODE VENTE","index":19,"n_rows":12,"n_cols":7,"rows_kept":12,"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,{"$f":"SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$M$7,,,COUNTA('SAUVEGARDE VENTE'!$M:$M)-1,)>='PERIODE VENTE'!A2)*(OFFSET('SAUVEGARDE VENTE'!$M$7,,,COUNTA('SAUVEGARDE VENTE'!$M:$M)-1,)<='PERIODE VENTE'!B2)*(OFFSET('SAUVEGARDE VENTE'!$S$7,,,COUNTA('SAUVEGARDE VENTE'!$S:$S)-1,)))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$M$7,,,COUNTA('SAUVEGARDE VENTE'!$M:$M)-1,)>=A2)*(OFFSET('SAUVEGARDE VENTE'!$M$7,,,COUNTA('SAUVEGARDE VENTE'!$M:$M)-1,)<=B2)*(OFFSET('SAUVEGARDE VENTE'!$T$7,,,COUNTA('SAUVEGARDE VENTE'!$T:$T)-1,)))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$W$7,,,COUNTA('SAUVEGARDE VENTE'!$W:$W)-1,)=1)*(OFFSET('SAUVEGARDE VENTE'!$M$7,,,COUNTA('SAUVEGARDE VENTE'!$M:$M)-1,)>=A2)*(OFFSET('SAUVEGARDE VENTE'!$M$7,,,COUNTA('SAUVEGARDE VENTE'!$M:$M)-1,)<=B2)*(OFFSET('SAUVEGARDE VENTE'!$T$7,,,COUNTA('SAUVEGARDE VENTE'!$T:$T)-1,)))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$W$7,,,COUNTA('SAUVEGARDE VENTE'!$W:$W)-1,)=2)*(OFFSET('SAUVEGARDE VENTE'!$M$7,,,COUNTA('SAUVEGARDE VENTE'!$M:$M)-1,)>=A2)*(OFFSET('SAUVEGARDE VENTE'!$M$7,,,COUNTA('SAUVEGARDE VENTE'!$M:$M)-1,)<=B2)*(OFFSET('SAUVEGARDE VENTE'!$T$7,,,COUNTA('SAUVEGARDE VENTE'!$T:$T)-1,)))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$W$7,,,COUNTA('SAUVEGARDE VENTE'!$W:$W)-1,)=3)*(OFFSET('SAUVEGARDE VENTE'!$M$7,,,COUNTA('SAUVEGARDE VENTE'!$M:$M)-1,)>=A2)*(OFFSET('SAUVEGARDE VENTE'!$M$7,,,COUNTA('SAUVEGARDE VENTE'!$M:$M)-1,)<=B2)*(OFFSET('SAUVEGARDE VENTE'!$T$7,,,COUNTA('SAUVEGARDE VENTE'!$T:$T)-1,)))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$Y$7,,,COUNTA('SAUVEGARDE VENTE'!$Y:$Y)-1,)>='PERIODE VENTE'!A2)*(OFFSET('SAUVEGARDE VENTE'!$Y$7,,,COUNTA('SAUVEGARDE VENTE'!$Y:$Y)-1,)<='PERIODE VENTE'!B2)*(OFFSET('SAUVEGARDE VENTE'!$AE$7,,,COUNTA('SAUVEGARDE VENTE'!$AE:$AE)-1,)))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$Y$7,,,COUNTA('SAUVEGARDE VENTE'!$Y:$Y)-1,)>=A2)*(OFFSET('SAUVEGARDE VENTE'!$Y$7,,,COUNTA('SAUVEGARDE VENTE'!$Y:$Y)-1,)<=B2)*(OFFSET('SAUVEGARDE VENTE'!$AF$7,,,COUNTA('SAUVEGARDE VENTE'!$AF:$AF)-1,)))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$AI$7,,,COUNTA('SAUVEGARDE VENTE'!$AI:$AI)-1,)=1)*(OFFSET('SAUVEGARDE VENTE'!$Y$7,,,COUNTA('SAUVEGARDE VENTE'!$Y:$Y)-1,)>=A2)*(OFFSET('SAUVEGARDE VENTE'!$Y$7,,,COUNTA('SAUVEGARDE VENTE'!$Y:$Y)-1,)<=B2)*(OFFSET('SAUVEGARDE VENTE'!$AF$7,,,COUNTA('SAUVEGARDE VENTE'!$AF:$AF)-1,)))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$AI$7,,,COUNTA('SAUVEGARDE VENTE'!$AI:$AI)-1,)=2)*(OFFSET('SAUVEGARDE VENTE'!$Y$7,,,COUNTA('SAUVEGARDE VENTE'!$Y:$Y)-1,)>=A2)*(OFFSET('SAUVEGARDE VENTE'!$Y$7,,,COUNTA('SAUVEGARDE VENTE'!$Y:$Y)-1,)<=B2)*(OFFSET('SAUVEGARDE VENTE'!$AF$7,,,COUNTA('SAUVEGARDE VENTE'!$AF:$AF)-1,)))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$AI$7,,,COUNTA('SAUVEGARDE VENTE'!$AI:$AI)-1,)=3)*(OFFSET('SAUVEGARDE VENTE'!$Y$7,,,COUNTA('SAUVEGARDE VENTE'!$Y:$Y)-1,)>=A2)*(OFFSET('SAUVEGARDE VENTE'!$Y$7,,,COUNTA('SAUVEGARDE VENTE'!$Y:$Y)-1,)<=B2)*(OFFSET('SAUVEGARDE VENTE'!$AF$7,,,COUNTA('SAUVEGARDE VENTE'!$AF:$AF)-1,)))","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"Encaissements","index":20,"n_rows":2,"n_cols":27,"rows_kept":2,"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":"LIVRES"},{"$f":"FAMILLES!B3","v":"CHEMISES"},{"$f":"FAMILLES!B4","v":"VESTES"},{"$f":"FAMILLES!B5","v":"Famille4"},{"$f":"FAMILLES!B6","v":"Famille5"},{"$f":"FAMILLES!B7","v":"Famille6"},{"$f":"FAMILLES!B8","v":"Famille7"},{"$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°:1",{"$f":"TODAY()","v":"2017-02-05"},{"$f":"NOW()","v":42771.591535879626},75,75,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},"DAVID",{"$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}]

{"sheet":"Z-CAISSE","index":21,"n_rows":3,"n_cols":31,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Date","Chiffre d'affaire","Espèces","CB","Chèques","Remise",{"$f":"IF(FAMILLES!B2=\"\",\"\",FAMILLES!B2)","v":"LIVRES"},{"$f":"IF(FAMILLES!B3=\"\",\"\",FAMILLES!B3)","v":"CHEMISES"},{"$f":"IF(FAMILLES!B4=\"\",\"\",FAMILLES!B4)","v":"VESTES"},{"$f":"IF(FAMILLES!B5=\"\",\"\",FAMILLES!B5)","v":"Famille4"},{"$f":"IF(FAMILLES!B6=\"\",\"\",FAMILLES!B6)","v":"Famille5"},{"$f":"IF(FAMILLES!B7=\"\",\"\",FAMILLES!B7)","v":"Famille6"},{"$f":"IF(FAMILLES!B8=\"\",\"\",FAMILLES!B8)","v":"Famille7"},{"$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-02-05"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manager"]
[{"$f":"TODAY()","v":"2017-02-05"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilisateur"]

{"sheet":"ZED-CAISSE","index":22,"n_rows":117,"n_cols":4,"rows_kept":117,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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]]}
[{"$f":"\"Z-CAISSE du \"&   TEXT(B5,\"jjjj jj mmmm aaaa\" )","v":"Z-CAISSE du dimanche 05 février 2017"}]
[{"$f":"TODAY()","v":"2017-02-05"}]
[]
[null,"Date",null,"Heure"]
["Z-CAISSE",{"$f":"TODAY()","v":"2017-02-05"},null,{"$f":"NOW()","v":42771.591535879626}]
["CAISSIER (E):","Manager"]
["Récapitulatif CA"]
["-------------------------"]
[null,"Date début",null,"Date fin"]
["Période","2017-01-30T00:15:24",null,{"$f":"B5","v":"2017-02-05"}]
["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=B6)*1)","v":0}]
["Chiffre d'affaire",{"$f":"IF('SAUVEGARDE VENTE'!#REF!=\"\",\"\",SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":{"$error":"#REF!"}}]
["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":""}]
["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":""}]
["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":""}]
["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":""}]
["---------------------------------------------"]
["Analyse famille"]
["-------------------------"]
["Famille","CA TTC","%CA"]
[{"$f":"FAMILLES!B2","v":"LIVRES"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$J$3,,,COUNTA(Encaissements!$J:$J)-1,))))","v":0},{"$f":"IF(B21=0,\"\",B21/$B$12)","v":""}]
[{"$f":"FAMILLES!B3","v":"CHEMISES"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$K$3,,,COUNTA(Encaissements!$K:$K)-1,))))","v":0},""]
[{"$f":"FAMILLES!B4","v":"VESTES"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$L$3,,,COUNTA(Encaissements!$L:$L)-1,))))","v":0},""]
[{"$f":"FAMILLES!B5","v":"Famille4"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$M$3,,,COUNTA(Encaissements!$M:$M)-1,))))","v":0},""]
[{"$f":"FAMILLES!B6","v":"Famille5"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$N$3,,,COUNTA(Encaissements!$N:$N)-1,))))","v":0},""]
[{"$f":"FAMILLES!B7","v":"Famille6"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$O$3,,,COUNTA(Encaissements!$O:$O)-1,))))","v":0},""]
[{"$f":"FAMILLES!B8","v":"Famille7"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$P$3,,,COUNTA(Encaissements!$P:$P)-1,))))","v":0},""]
[{"$f":"FAMILLES!B9","v":"Famille8"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$Q$3,,,COUNTA(Encaissements!$Q:$Q)-1,))))","v":0},""]
[{"$f":"FAMILLES!B10","v":"Famille9"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$R$3,,,COUNTA(Encaissements!$R:$R)-1,))))","v":0},""]
[{"$f":"FAMILLES!B11","v":"Famille10"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$S$3,,,COUNTA(Encaissements!$S:$S)-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 ","Quantité","Montant €"]
["-------------------------","-------------------------","-------------------------"]
["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":""}]
["CB",{"$f":"IF(C39=0,\"\",SUMIFS(Encaissements!A:A,Encaissements!F:F,Encaissements!F:F>0,Encaissements!B:B,Encaissements!B:B=$B$10))","v":0},{"$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":""}]
["Chèque",{"$f":"IF(C40=0,\"\",SUMIFS(Encaissements!A:A,Encaissements!G:G,Encaissements!G:G>0,Encaissements!B:B,Encaissements!B:B=$B$10))","v":0},{"$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":""}]
[{"$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'!#REF!=\"\",\"\",SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":{"$error":"#REF!"}}]
["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":{"$error":"#REF!"}}]
["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":{"$error":"#REF!"}}]
["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":{"$error":"#REF!"}}]
[]
["Solde théorique",null,{"$f":"IF(C45=\"\",0,(C45-C46)-(C47+C48))","v":{"$error":"#REF!"}}]
["---------------------------------------------"]
["Analyse TVA"]
["Libellé","Taux","CA TTC","Montant TVA"]
["TVA 20%",0.2,{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$U$3,,,COUNTA(Encaissements!$U:$U)-1,))))","v":0},{"$f":"IF(C54=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$V$3,,,COUNTA(Encaissements!$V:$V)-1,))))","v":0}]
["TVA 5,5%",5.5E-2,{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$W$3,,,COUNTA(Encaissements!$W:$W)-1,))))","v":0},{"$f":"IF(C55=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$X$3,,,COUNTA(Encaissements!$X:$X)-1,))))","v":0}]
["TVA 10%",0.1,{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$Y$3,,,COUNTA(Encaissements!$Y:$Y)-1,))))","v":0},{"$f":"IF(C56=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$Z$3,,,COUNTA(Encaissements!$Z:$Z)-1,))))","v":0}]
["Exonérée",0,{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B6)*(OFFSET(Encaissements!$AA$3,,,COUNTA(Encaissements!$AA:$AA)-1,))))","v":0}]
["---------------------------------------------"]
["CAISSIER (E):","DAVID"]
["Récapitulatif CA"]
["-------------------------"]
[null,"Date début",null,"Date fin"]
["Période","2017-01-30T00:15:24",null,{"$f":"B5","v":"2017-02-05"}]
["Nb clients",{"$f":"SUMPRODUCT((('LISTE TICKETS'!B:B>$B$10*1)*('LISTE TICKETS'!B:B<=$D$10*1)*('LISTE TICKETS'!E:E=B59)*1)*('LISTE TICKETS'!A:A<>\"\")*1)","v":0}]
["Chiffre d'affaire",{"$f":"IF('SAUVEGARDE VENTE'!#REF!=\"\",\"\",SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B59)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":{"$error":"#REF!"}}]
["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":""}]
["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":""}]
["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":""}]
["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":""}]
["---------------------------------------------"]
["Analyse famille"]
["-------------------------"]
["Famille","CA TTC","%CA"]
[{"$f":"FAMILLES!B2","v":"LIVRES"},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$J$3,,,COUNTA(Encaissements!$J:$J)-1,))))","v":0},{"$f":"IF(B74=0,\"\",B74/$B$65)","v":""}]
[{"$f":"FAMILLES!B3","v":"CHEMISES"},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$K$3,,,COUNTA(Encaissements!$K:$K)-1,))))","v":0},""]
[{"$f":"FAMILLES!B4","v":"VESTES"},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$L$3,,,COUNTA(Encaissements!$L:$L)-1,))))","v":0},""]
[{"$f":"FAMILLES!B5","v":"Famille4"},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$M$3,,,COUNTA(Encaissements!$M:$M)-1,))))","v":0},""]
[{"$f":"FAMILLES!B6","v":"Famille5"},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$N$3,,,COUNTA(Encaissements!$N:$N)-1,))))","v":0},""]
[{"$f":"FAMILLES!B7","v":"Famille6"},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$O$3,,,COUNTA(Encaissements!$O:$O)-1,))))","v":0},""]
[{"$f":"FAMILLES!B8","v":"Famille7"},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$P$3,,,COUNTA(Encaissements!$P:$P)-1,))))","v":0},""]
[{"$f":"FAMILLES!B9","v":"Famille8"},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$Q$3,,,COUNTA(Encaissements!$Q:$Q)-1,))))","v":0},""]
[{"$f":"FAMILLES!B10","v":"Famille9"},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$R$3,,,COUNTA(Encaissements!$R:$R)-1,))))","v":0},""]
[{"$f":"FAMILLES!B11","v":"Famille10"},{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$S$3,,,COUNTA(Encaissements!$S:$S)-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 ","Quantité","Montant €"]
["-------------------------","-------------------------","-------------------------"]
["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":""}]
["CB",{"$f":"IF(C92=0,\"\",SUMIFS(Encaissements!A:A,Encaissements!F:F,Encaissements!F:F>0,Encaissements!B:B,Encaissements!B:B=$B$10))","v":0},{"$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":""}]
["Chèque",{"$f":"IF(C93=0,\"\",SUMIFS(Encaissements!A:A,Encaissements!G:G,Encaissements!G:G>0,Encaissements!B:B,Encaissements!B:B=$B$10))","v":""},{"$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":"IF('SAUVEGARDE VENTE'!#REF!=\"\",\"\",SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)>B10)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)<=D10)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B59)*(OFFSET('SAUVEGARDE VENTE'!#REF!,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":{"$error":"#REF!"}}]
["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":{"$error":"#REF!"}}]
["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":{"$error":"#REF!"}}]
["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":{"$error":"#REF!"}}]
[]
["Solde théorique",null,{"$f":"IF(C98=\"\",0,(C98-C99)-(C100+C101))","v":{"$error":"#REF!"}}]
["---------------------------------------------"]
["Analyse TVA"]
["Libellé","Taux","CA TTC","Montant TVA"]
["TVA 20%",0.2,{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$U$3,,,COUNTA(Encaissements!$U:$U)-1,))))","v":0},{"$f":"IF(C107=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$V$3,,,COUNTA(Encaissements!$V:$V)-1,))))","v":0}]
["TVA 5,5%",5.5E-2,{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$W$3,,,COUNTA(Encaissements!$W:$W)-1,))))","v":0},{"$f":"IF(C108=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$X$3,,,COUNTA(Encaissements!$X:$X)-1,))))","v":0}]
["TVA 10%",0.1,{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$Y$3,,,COUNTA(Encaissements!$Y:$Y)-1,))))","v":0},{"$f":"IF(C109=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$Z$3,,,COUNTA(Encaissements!$Z:$Z)-1,))))","v":0}]
["Exonérée",0,{"$f":"IF(B64=0,0,SUMPRODUCT((OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)>B10)*(OFFSET(Encaissements!$B$3,,,COUNTA(DATE)-1,)<=D10)*(OFFSET(Encaissements!$T$3,,,COUNTA(Encaissements!$T:$T)-1,)=B59)*(OFFSET(Encaissements!$AA$3,,,COUNTA(Encaissements!$AA:$AA)-1,))))","v":0}]
["---------------------------------------------"]
["le dernier Z-CAISSE a été effectué par",null,null,"Manager"]
["le ","2017-01-30T00:15:24"]
[]
[]
[]
["TALEB Taleb"]

{"sheet":"LISTE TICKETS","index":23,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
["N° Ticket","Date",null,"Montant Total","CAISSIER","Mnt Esp","Mnt CB","Mnt CH","Remise","CA TVA 20%","Mont TVA","CA TVA 5,5%","Mont TVA","CA TVA 10%","Mont TVA","CA TVA 0,00%"]

{"sheet":"X-CAISSE","index":24,"n_rows":63,"n_cols":20,"rows_kept":63,"cut":false,"hidden":false,"merged":[[57,0,57,3],[34,5,35,5],[34,4,35,4],[51,0,51,3],[49,2,49,3],[47,2,47,3],[46,2,46,3],[26,2,26,3],[45,0,45,1],[46,0,46,1],[47,0,47,1],[32,0,32,3],[42,0,42,3],[33,0,33,3],[36,2,36,3],[4,1,4,2],[45,2,45,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[44,2,44,3],[39,2,39,3],[38,2,38,3],[37,2,37,3],[35,2,35,3],[23,2,23,3],[24,2,24,3],[5,1,5,2],[20,2,20,3],[21,2,21,3],[22,2,22,3],[7,0,7,3],[6,0,6,3],[17,0,17,3],[9,1,9,2],[10,1,10,3],[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]]}
["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-02-05"},null,{"$f":"NOW()","v":42771.591535879626}]
["CAISSIER (E):","DAVID"]
["Récapitulatif CA"]
["-------------------------"]
[]
["Date","2017-01-30"]
["Nb clients",{"$f":"SUMPRODUCT((('LISTE TICKETS'!B:B=$B$10*1)*('LISTE TICKETS'!A:A<>\"\")*1)*('LISTE TICKETS'!E:E=B6)*1)","v":0}]
["Chiffre d'affaire",{"$f":"IF('SAUVEGARDE VENTE'!A7=\"\",\"\",SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":""}]
["Espèces",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)=B10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$F$2,,,COUNTA('LISTE TICKETS'!$F:$F)-1,))))","v":""}]
["CB",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)=B10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$G$2,,,COUNTA('LISTE TICKETS'!$G:$G)-1,))))","v":""}]
["Chèques",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)=B10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$H$2,,,COUNTA('LISTE TICKETS'!$H:$H)-1,))))","v":""}]
["Remise",{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)=B10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$I$2,,,COUNTA('LISTE TICKETS'!$I:$I)-1,))))","v":""}]
["---------------------------------------------"]
["Analyse famille"]
["-------------------------"]
["Famille","CA TTC","% CA"]
[{"$f":"FAMILLES!B2","v":"LIVRES"},{"$f":"IF(B11=0,0,SUMPRODUCT((OFFSET('SAUVEGARDE VENTE'!$A$7,,,COUNTA('SAUVEGARDE VENTE'!$A:$A)-1,)=B10)*(OFFSET('SAUVEGARDE VENTE'!$L$7,,,COUNTA('SAUVEGARDE VENTE'!$L:$L)-1,)=B6)*(OFFSET('SAUVEGARDE VENTE'!$J$7,,,COUNTA('SAUVEGARDE VENTE'!$J:$J)-1,)='X-CAISSE'!A21)*(OFFSET('SAUVEGARDE VENTE'!$G$7,,,COUNTA('SAUVEGARDE VENTE'!$G:$G)-1,))))","v":0},{"$f":"IF(B21=0,\"\",B21/$B$12)","v":""}]
[{"$f":"FAMILLES!B3","v":"CHEMISES"},{"$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":"VESTES"},{"$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":"Famille4"},{"$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":"Famille5"},{"$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":"Famille6"},{"$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":"Famille7"},{"$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 ","Quantité","Montant €"]
["-------------------------","-------------------------","-------------------------"]
["Espèces",null,{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)=B10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$F$2,,,COUNTA('LISTE TICKETS'!$F:$F)-1,))))","v":""},null,{"$f":"IF($B$12=\"\",0,SUMIFS(TOTAL_ESPECES,DATE_Z,$B$10,caissier,$B$6))","v":0},{"$f":"IF(C38=\"\",E38,E38-C38)","v":0}]
["CB",null,{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)=B10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$G$2,,,COUNTA('LISTE TICKETS'!$G:$G)-1,))))","v":""},null,{"$f":"IF($B$12=\"\",0,SUMIFS(TOTAL_CB,DATE_Z,$B$10,caissier,$B$6))","v":0},{"$f":"IF(C39=\"\",E39,E39-C39)","v":0}]
["Chèque",null,{"$f":"IF('LISTE TICKETS'!A2=\"\",\"\",SUMPRODUCT((OFFSET('LISTE TICKETS'!$B$2,,,COUNTA('LISTE TICKETS'!$B:$B)-1,)=B10)*(OFFSET('LISTE TICKETS'!$E$2,,,COUNTA('LISTE TICKETS'!E:E)-1,)=B6)*(OFFSET('LISTE TICKETS'!$H$2,,,COUNTA('LISTE TICKETS'!$H:$H)-1,))))","v":""},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":""}]
["Entrées",null,{"$f":"IF(B12=\"\",0,SUMIFS('Z-CAISSE'!T:T,'Z-CAISSE'!A:A,B10,'Z-CAISSE'!R:R,B6))","v":0}]
["Sorties",null,{"$f":"IF(B12=\"\",0,SUMIFS('Z-CAISSE'!U:U,'Z-CAISSE'!A:A,B10,'Z-CAISSE'!R:R,B6))","v":0}]
["Fond de caisse",null,{"$f":"IF(B12=\"\",0,SUMIFS('Z-CAISSE'!S:S,'Z-CAISSE'!A:A,B10,'Z-CAISSE'!R:R,B6))","v":0}]
[]
["Solde théorique",null,{"$f":"IF(C45=\"\",0,(C45-C46)-(C47-C48))","v":0}]
["---------------------------------------------"]
["Analyse TVA"]
["Libellé","Taux","CA TTC","Montant TVA",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}]
["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":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,)=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'!$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}]
["---------------------------------------------"]
[]
[]
[]
[]
["TALEB Taleb"]

{"sheet":"SAUVEGARDE VENTE","index":25,"n_rows":6,"n_cols":36,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,4,2,5],[3,4,3,5]]}
[null,null,null,"DATE DEBUT",null," "]
[null,null,null,"DATE FIN",null,null,null,null,null,null,null,null,null,null,{"$f":"AND(A7>=$E$1,A7<=$E$2,L7=$E$3)","v":false}]
[null,null,null,"Utilisateur","Manager"]
[null,null,null,"Famille","Famille2"]
[]
["DATE","Réf","Produit","Qté","Prix","Remise","Montant","Mt tva","Remise","Famille","Code TVA","CAISSIER","DATE","Réf","Produit","Qté","Prix","Remise","Montant","Mt tva","Remise","Famille","Code TVA","CAISSIER","DATE","Réf","Produit","Qté","Prix","Remise","Montant","Mt tva","Remise","Famille","Code TVA","CAISSIER"]

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

{"sheet":"TACHES REALISEES","index":27,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["TACHES REALISEES","DATE"]
["message important",{"$f":"TODAY()","v":"2017-02-05"}]

{"sheet":"Feuil1","index":28,"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":1}]