{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Home","Article","Order","Po","Booking","Supplier","Customer","Config","Inventaires"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":16,"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":"Home","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Article","index":1,"n_rows":7,"n_cols":22,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,"Nr Article","Nom","Description","Prix unité","Stock","Valeur Stock","stock min.","Flag","Statuts","Vide","1","2","22","4","5","6","7","8","9","10",">10"]
[null,"ART-00001","Eau Crystal","RAS",250,{"$f":"SUMIFS(Tableau5[Nombre],Tableau5[Nr Article],Tableau3[[#This Row],[Nr Article]],Tableau5[Type],\"Entrée\")-SUMIFS(Tableau5[Nombre],Tableau5[Nr Article],Tableau3[[#This Row],[Nr Article]],Tableau5[Type],\"Sortie\")","v":15},{"$f":"E6*F6","v":3750},5,{"$f":"IF(F6<H6,1,\"\")","v":""},"Active"]
[null,"ART-00002","Jus Pulp Orange","RAS",500,{"$f":"SUMIFS(Tableau5[Nombre],Tableau5[Nr Article],Tableau3[[#This Row],[Nr Article]],Tableau5[Type],\"Entrée\")-SUMIFS(Tableau5[Nombre],Tableau5[Nr Article],Tableau3[[#This Row],[Nr Article]],Tableau5[Type],\"Sortie\")","v":0},{"$f":"E7*F7","v":0},5,{"$f":"IF(F7<H7,1,\"\")","v":1},"Active"]

{"sheet":"Order","index":2,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Nr commande","Date","Nr  article","nom","nombre","prix","prix total","fournisseur","Contrôle","Chek"]
[" ","ORD-00001","2022-07-20T16:06:40","ART-00001","Eau Crystal",20,250,{"$f":"F6*G6","v":5000},"Joachim1",{"$f":"IFERROR(INDEX(Tableau5[Nombre],MATCH(1,(Tableau2[[#This Row],[Nr commande]]=Tableau5[Nr Bon de commande])*(Tableau2[[#This Row],[Nr  article]]=Tableau5[Nr Article]),0)),\"\")","v":20},{"$f":"IF(Tableau2[[#This Row],[Contrôle]]=Tableau2[[#This Row],[nombre]],\"Close\",\"Open\")","v":"Close"}]
[null,"ORD-00001","2022-07-20T16:06:40","ART-00002","Jus Pulp Orange",24,500,{"$f":"F7*G7","v":12000},"Joachim1",{"$f":"IFERROR(INDEX(Tableau5[Nombre],MATCH(1,(Tableau2[[#This Row],[Nr commande]]=Tableau5[Nr Bon de commande])*(Tableau2[[#This Row],[Nr  article]]=Tableau5[Nr Article]),0)),\"\")","v":10},{"$f":"IF(Tableau2[[#This Row],[Contrôle]]=Tableau2[[#This Row],[nombre]],\"Close\",\"Open\")","v":"Open"}]

{"sheet":"Po","index":3,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[43,1,49,4],[5,4,6,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,"BON DE COMMANDE"]
[]
[]
[]
[]
[null,"Com Nr.","ORD-00001",null,null,"Date:",{"$f":"IFERROR(INDEX(Tableau2[Date],MATCH(Po!C11,Tableau2[Nr commande],0)),\"\")","v":"2022-07-20T16:06:40"}]
[null,"Le numéro suivant doit apparaitre sur toute la"]
[null,"correspondance annexe, les papiers de livraison et les factures"]
[]
[null,"Shopping adress",null,null,null,"Fournisseur:"]
[null,{"$f":"Config!C27","v":"PHONE AFFAIRES"},null,null,null,{"$f":"IFERROR(INDEX(Tableau2[fournisseur],MATCH(Po!C11,Tableau2[Nr commande],0)),\"\")","v":"Joachim1"}]
[null,{"$f":"Config!C28","v":"17, avenue des trois martyrs"},null,null,null,{"$f":"IFERROR(INDEX(Tableau15[Adress],MATCH(Po!$F$16,Tableau1[Nom],0)),\"\")","v":"adress1"}]
[null,{"$f":"CONCATENATE(Config!C31,\"-\",Config!C29,\",\",Config!C30)","v":"Congo-122,Brazzaville"},null,null,null,{"$f":"IFERROR(INDEX(Tableau1[Group],MATCH(Po!$F$16,Tableau1[Nom],0)),\"\")","v":"Fr-111,Paris"}]
[null,{"$f":"Config!C32","v":65686565},null,null,null,{"$f":"IFERROR(INDEX(Tableau1[Téléphone],MATCH(Po!$F$16,Tableau1[Nom],0)),\"\")","v":111111}]
[null,{"$f":"Config!C33","v":"phone_affaires@gmail.com"},null,null,null,{"$f":"IFERROR(INDEX(Tableau1[Mail],MATCH(Po!$F$16,Tableau1[Nom],0)),\"\")","v":"joachim@gmail.com"}]
[]
[null,"Nr","Nr Article","Nom","Nombre","PU","Total"]
[null,{"$f":"IF(C23<>\"\",ROW()-22,\"\")","v":1},{"$f":"INDEX(Tableau2[Nr  article],SMALL(IF(Tableau2[Nr commande]=Po!$C$11,ROW(Tableau2[Nr  article])-5),ROW()-22))","v":"ART-00001"},{"$f":"INDEX(Tableau2[nom],SMALL(IF(Tableau2[Nr commande]=Po!$C$11,ROW(Tableau2[nom])-5),ROW()-22))","v":"Eau Crystal"},{"$f":"INDEX(Tableau2[nombre],SMALL(IF(Tableau2[Nr commande]=Po!$C$11,ROW(Tableau2[nombre])-5),ROW()-22))","v":20},{"$f":"INDEX(Tableau2[prix],SMALL(IF(Tableau2[Nr commande]=Po!$C$11,ROW(Tableau2[prix])-5),ROW()-22))","v":250},{"$f":"INDEX(Tableau2[prix total],SMALL(IF(Tableau2[Nr commande]=Po!$C$11,ROW(Tableau2[prix total])-5),ROW()-22))","v":5000}]
[null,{"$f":"IF(C24<>\"\",ROW()-22,\"\")","v":2},{"$f":"IFERROR(INDEX(Tableau2[Nr  article],SMALL(IF(Tableau2[Nr commande]=Po!$C$11,ROW(Tableau2[Nr  article])-5),ROW()-22)),\"\")","v":"ART-00002"},{"$f":"IFERROR(INDEX(Tableau2[nom],SMALL(IF(Tableau2[Nr commande]=Po!$C$11,ROW(Tableau2[nom])-5),ROW()-22)),\"\")","v":"Jus Pulp Orange"},{"$f":"IFERROR(INDEX(Tableau2[nombre],SMALL(IF(Tableau2[Nr commande]=Po!$C$11,ROW(Tableau2[nombre])-5),ROW()-22)),\"\")","v":24},{"$f":"IFERROR(INDEX(Tableau2[prix],SMALL(IF(Tableau2[Nr commande]=Po!$C$11,ROW(Tableau2[prix])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau2[prix total],SMALL(IF(Tableau2[Nr commande]=Po!$C$11,ROW(Tableau2[prix total])-5),ROW()-22)),\"\")","v":12000}]
[null,{"$f":"IF(C25<>\"\",ROW()-22,\"\")","v":""}]
[null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Test"]
[null,null,null,null,null,"Total:",{"$f":"SUM(G23:G42)","v":17000}]
[null,null,null,null,null,"TVA 21%",{"$f":"G45*0.21","v":3570}]
[null,null,null,null,null,"Total: TTC :",{"$f":"G45+G46","v":20570}]

{"sheet":"Booking","index":4,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Type","Nr Facture","Nr Bon de commande","Fournisseur","Client","Nr Article","Nombre","Banking"]
[null,"Entrée","FACT-00002","ORD-00001",null,"Joachim1","ART-00001",20,{"$f":"IF(Tableau5[Type]=\"Sortie\",COUNTIFS(Tableau5[Type],\"Sortie\",Tableau5[Nombre],\">\"&Tableau5[[#This Row],[Nombre]])+1,\"\")","v":""}]
[null,"Entrée","FACT-00002","ORD-00001",null,"Joachim1","ART-00002",10,{"$f":"IF(Tableau5[Type]=\"Sortie\",COUNTIFS(Tableau5[Type],\"Sortie\",Tableau5[Nombre],\">\"&Tableau5[[#This Row],[Nombre]])+1,\"\")","v":""}]
[null,"Sortie","FACT-00004","ORD-00001",null,"Belle1","ART-00001",5,{"$f":"IF(Tableau5[Type]=\"Sortie\",COUNTIFS(Tableau5[Type],\"Sortie\",Tableau5[Nombre],\">\"&Tableau5[[#This Row],[Nombre]])+1,\"\")","v":2}]
[null,"Sortie","FACT-00004","ORD-00001",null,"Belle1","ART-00002",10,{"$f":"IF(Tableau5[Type]=\"Sortie\",COUNTIFS(Tableau5[Type],\"Sortie\",Tableau5[Nombre],\">\"&Tableau5[[#This Row],[Nombre]])+1,\"\")","v":1}]

{"sheet":"Supplier","index":5,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Nom","Adress","Cp","Ville","Pays","Téléphone","Mail","Group"]
[null,"Joachim1","adress1",111,"Paris","France",111111,"joachim@gmail.com",{"$f":"CONCATENATE(LEFT(F6,2),\"-\",D6,\",\",E6)","v":"Fr-111,Paris"}]
[null,"Joachim2","adress2",112,"Paris","France",111112,"joachim@gmail.com",{"$f":"CONCATENATE(LEFT(F7,2),\"-\",D7,\",\",E7)","v":"Fr-112,Paris"}]
[null,"Joachim3","adress3",113,"Paris","France",111113,"joachim@gmail.com","Fr-113,Paris"]
[null,"Joachim4","adress4",114,"Paris","France",111114,"joachim@gmail.com","Fr-114,Paris"]
[null,"Joachim5","adress5",115,"Paris","France",111115,"joachim@gmail.com","Fr-115,Paris"]
[null,"Joachim6","adress6",116,"Paris","France",111116,"joachim@gmail.com","Fr-116,Paris"]
[null,"Joachim7","adress7",117,"Paris","France",111117,"joachim@gmail.com","Fr-117,Paris"]
[null,"Joachim8","adress8",118,"Paris","France",111118,"joachim@gmail.com","Fr-118,Paris"]
[null,"Joachim9","adress9",119,"Paris","France",111119,"joachim@gmail.com","Fr-119,Paris"]
[null,"Joachim10","adress10",120,"Paris","France",111120,"joachim@gmail.com","Fr-120,Paris"]
[null,"Joachim11","adress11",121,"Paris","France",111121,"joachim@gmail.com","Fr-121,Paris"]
[null,"Joachim12","adress12",122,"Paris","France",111122,"joachim@gmail.com","Fr-122,Paris"]
[null,"Joachim13","adress13",123,"Paris","France",111123,"joachim@gmail.com","Fr-123,Paris"]
[null,"Joachim14","adress14",124,"Paris","France",111124,"joachim@gmail.com","Fr-124,Paris"]

{"sheet":"Customer","index":6,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Nom","Adress","Cp","Ville","Pays","Téléphone","Mail","Group"]
[null,"Belle1","adress1",1000,"Paris","Belgique",444555,"joachim@gmail.com",{"$f":"CONCATENATE(LEFT(F6,2),\"-\",D6,\",\",E6)","v":"Be-1000,Paris"}]
[null,"Belle2","adress2",1001,"Paris","Belgique",444556,"joachim@gmail.com",{"$f":"CONCATENATE(LEFT(F7,2),\"-\",D7,\",\",E7)","v":"Be-1001,Paris"}]
[null,"Belle3","adress3",1002,"Paris","Belgique",444557,"joachim@gmail.com","Be-1002,Paris"]
[null,"Belle4","adress4",1003,"Paris","Belgique",444558,"joachim@gmail.com","Be-1003,Paris"]
[null,"Belle5","adress5",1004,"Paris","Belgique",444559,"joachim@gmail.com","Be-1004,Paris"]
[null,"Belle6","adress6",1005,"Paris","Belgique",444560,"joachim@gmail.com","Be-1005,Paris"]
[null,"Belle7","adress7",1006,"Paris","Belgique",444561,"joachim@gmail.com","Be-1006,Paris"]
[null,"Belle8","adress8",1007,"Paris","Belgique",444562,"joachim@gmail.com","Be-1007,Paris"]
[null,"Belle9","adress9",1008,"Paris","Belgique",444563,"joachim@gmail.com","Be-1008,Paris"]
[null,"Belle10","adress10",1009,"Paris","Belgique",444564,"joachim@gmail.com","Be-1009,Paris"]
[null,"Belle11","adress11",1010,"Paris","Belgique",444565,"joachim@gmail.com","Be-1010,Paris"]
[null,"Belle12","adress12",1011,"Paris","Belgique",444566,"joachim@gmail.com","Be-1011,Paris"]
[null,"Belle13","adress13",1012,"Paris","Belgique",444567,"joachim@gmail.com","Be-1012,Paris"]
[null,"Belle14","adress14",1013,"Paris","Belgique",444568,"joachim@gmail.com","Be-1013,Paris"]

{"sheet":"Config","index":7,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[50,2,50,3],[51,2,51,3],[34,2,40,5],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3]]}
[]
[]
[]
[]
[]
[null,"Items Navig",null,null,null,null,null,null,"Nav Color"]
[]
[null,"Page1","Home",null,null,null,null,null,"Background"]
[null,"Page2","Articles"]
[null,"Page3","Commandes",null,null,null,null,null,"Page"]
[null,"Page4","Bon"]
[null,"Page5","Booking"]
[null,"Page6","Fournisseur"]
[null,"Page7","Client"]
[null,"Page8","Config"]
[]
[null," Suffixe"]
[]
[null,"Article","ART-",3,{"$f":"C19&TEXT(D19,\"00000\")","v":"ART-00003"}]
[null,"Order","ORD-",2,{"$f":"C20&TEXT(D20,\"00000\")","v":"ORD-00002"}]
[null,"Booking","BOO-",1,{"$f":"C21&TEXT(D21,\"00000\")","v":"BOO-00001"}]
[]
[]
[]
[null,"Bon de commande "]
[]
[null,"Entreprise","PHONE AFFAIRES"]
[null,"Adresse","17, avenue des trois martyrs"]
[null,"CodePostal",122]
[null,"Ville","Brazzaville"]
[null,"Pays","Congo"]
[null,"Tél.:",65686565]
[null,"Email.:","phone_affaires@gmail.com"]
[]
[null,"Condition","1.Veuillez envoyer deux copies de votre facture       2. Entrez cette commande conormément aux tarifs, aux conditions, à la méthode de livraison et aux spécifications repertoriées ci-dessus.                            3. Veuillez nous informer immédiatement si vous n'êtes pas en mesure de d'expédier la commande telle que spécifiée."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tableau de bord"]
[]
[null,"Widget 1","Valeur de stock",null,{"$f":"SUM(Tableau3[Valeur Stock])","v":3750}]
[null,"Widget 2","Articles en commande",null,{"$f":"COUNTIF(Tableau2[Chek],\"Open\")","v":1}]
[null,"Widget 3","Articles critiques",null,{"$f":"COUNTIF(Tableau3[Flag],1)","v":1}]
[null,"Widget 4","Nombre d'articles en stock",null,{"$f":"COUNTIF(Tableau3[Statuts],\"Active\")","v":2}]
[null,"Widget 5","Volume du stock",null,{"$f":"SUM(Tableau3[Stock])","v":15}]
[null,"Widget 6","Top 3 articles vendus",null,{"$f":"IFERROR(INDEX(Tableau5[Nr Article],MATCH(1,Tableau5[Banking],0)),\"\")","v":"ART-00002"},{"$f":"IFERROR(INDEX(Tableau5[Nr Article],MATCH(2,Tableau5[Banking],0)),\"\")","v":"ART-00001"}]

{"sheet":"Inventaires","index":8,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,8,6,11],[1,0,1,7],[1,8,1,15],[10,1,10,2],[10,3,10,4],[10,5,10,6],[5,0,5,1],[6,0,6,1]]}
[]
["SUIVI DES INVENTAIRES DU STOCK",null,null,null,null,null,null,null,"SUIVI DES DÉCAISSEMENTS"]
[]
["Période du :","2022-07-20","au ","2022-07-31"]
[]
["Reste après décaissement :",null,{"$f":"G9-M7","v":17200},null,"Manquant",{"$f":"G9-C7","v":-18800}]
["Total réel encaissé:",null,50000,null,"Excédent",{"$f":"C7-G9","v":18800},null,null,"Total général des décaissements :",null,null,null,{"$f":"SUM(O12:O65538)","v":14000}]
[]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G13:G65541)","v":31200}]
[]
[null,"Début",null,"Fin",null,"Cacul",null,null,"Date","Montant","Motif",null,null,"Num. Cmde","Total"]
[null,"Stock Init.","Date Init.","Reste","Date Contrôle","Vendu","Sous-Total",null,"2022-08-22",5000,"Motif1",null,null,null,{"$f":"SUM(J12:M12)","v":5000}]
["Article 2",20,"2022-07-20",5,"2022-07-22",{"$f":"B13-D13","v":15},{"$f":"F13*600","v":9000},null,"2022-08-23",9000,"Motif2",null,null,null,{"$f":"SUM(J13:M13)","v":9000}]
["Article 2",40,"2022-07-20",3,"2022-07-22",{"$f":"B14-D14","v":37},{"$f":"F14*600","v":22200},null,null,null,null,null,null,null,{"$f":"SUM(J14:M14)","v":0}]
["Article 2",null,null,null,null,null,{"$f":"F15*600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(J15:M15)","v":0}]
["Article 2",null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"SUM(J16:M16)","v":0}]