{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Accueil","Article","Order","Po","Booking","Fournisseur","Client","Config","Gamme","Liste"],"not_rendered":{"images":8,"macros":1,"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Article","index":1,"n_rows":7,"n_cols":28,"rows_kept":7}
[]
[]
[]
[{"$nulls":17},1,2,3,4,5,6,7,8,9,10]
[null," Nr Article","Gamme","Description","Prix unité","Stock","Valeur Stock","stock mini","Flag","Statuts","Compo","Caractéristique ","Fournisseur","Marque ","Couleur","Ref"," ","1","2","3","4","5","6","7","8","9","10",">10"]
[{"$nulls":5},{"$f":"SUMIFS(Tableau5[Nombre],Tableau5[REF],Tableau3[Ref],Tableau5[[ Type]],\"Entrée\")-SUMIFS(Tableau5[Nombre],Tableau5[REF],Tableau3[Ref],Tableau5[[ Type]],\"Sortie\")","v":0},{"$f":"E6*F6","v":0},null,{"$f":"IF(F6<H6,1,\"\")","v":""}]
[{"$nulls":9}," "]

{"sheet":"Order","index":2,"n_rows":12,"n_cols":11,"rows_kept":12}
[]
[]
[]
[]
[null," Nr commande","Date","Nr article","Nom","Nombre","Prix","Prix Total","Fournisseur","Contrôle","Check"]
[{"$nulls":7},{"$f":"F6*G6","v":0},null,{"$f":"IFERROR( INDEX(Tableau5[Nombre],MATCH(1,(Tableau4[[#This Row],[ Nr commande]]=Tableau5[Nr Bon de commande])*(Tableau4[[#This Row],[Nr article]]=Tableau5[REF]),0)),\"\")","v":0},{"$f":"IF(Tableau4[[#This Row],[Contrôle]]=Tableau4[[#This Row],[Nombre]],\"FERMER\",\"OUVERT\")","v":"FERMER"}]
[null,"ORD-00001","2019-12-01T12:15:10","ART-00001","test",44,{"v":1.5,"d":"€1.50"},{"v":66,"d":"€66.00"},"supp4",{"$f":"IFERROR( INDEX(Tableau5[Nombre],MATCH(1,(Tableau4[[#This Row],[ Nr commande]]=Tableau5[Nr Bon de commande])*(Tableau4[[#This Row],[Nr article]]=Tableau5[REF]),0)),\"\")","v":""},{"$f":"IF(Tableau4[[#This Row],[Contrôle]]=Tableau4[[#This Row],[Nombre]],\"FERMER\",\"OUVERT\")","v":"OUVERT"}]
[null,"ORD-00001","2019-12-01T12:15:10","art5",null,2,{"v":0,"d":"€0.00"},0,"supp4",{"$f":"IFERROR( INDEX(Tableau5[Nombre],MATCH(1,(Tableau4[[#This Row],[ Nr commande]]=Tableau5[Nr Bon de commande])*(Tableau4[[#This Row],[Nr article]]=Tableau5[REF]),0)),\"\")","v":""},{"$f":"IF(Tableau4[[#This Row],[Contrôle]]=Tableau4[[#This Row],[Nombre]],\"FERMER\",\"OUVERT\")","v":"OUVERT"}]
[null,"ORD-00001","2019-12-01T12:15:10","ART-00001","test",7,{"v":1.5,"d":"€1.50"},{"v":10.5,"d":"€10.50"},"supp4",{"$f":"IFERROR( INDEX(Tableau5[Nombre],MATCH(1,(Tableau4[[#This Row],[ Nr commande]]=Tableau5[Nr Bon de commande])*(Tableau4[[#This Row],[Nr article]]=Tableau5[REF]),0)),\"\")","v":""},{"$f":"IF(Tableau4[[#This Row],[Contrôle]]=Tableau4[[#This Row],[Nombre]],\"FERMER\",\"OUVERT\")","v":"OUVERT"}]
[null,"ORD-00003","2019-12-01T17:34:10","ART-00001","test",5,{"v":1.5,"d":"€1.50"},{"v":7.5,"d":"€7.50"},"supp1",{"$f":"IFERROR( INDEX(Tableau5[Nombre],MATCH(1,(Tableau4[[#This Row],[ Nr commande]]=Tableau5[Nr Bon de commande])*(Tableau4[[#This Row],[Nr article]]=Tableau5[REF]),0)),\"\")","v":""},{"$f":"IF(Tableau4[[#This Row],[Contrôle]]=Tableau4[[#This Row],[Nombre]],\"FERMER\",\"OUVERT\")","v":"OUVERT"}]
[null,"ORD-00004","2019-12-01T17:36:09","ART-00002","tttt",7,{"v":2,"d":"€2.00"},{"v":14,"d":"€14.00"},"supp2",{"$f":"IFERROR( INDEX(Tableau5[Nombre],MATCH(1,(Tableau4[[#This Row],[ Nr commande]]=Tableau5[Nr Bon de commande])*(Tableau4[[#This Row],[Nr article]]=Tableau5[REF]),0)),\"\")","v":""},{"$f":"IF(Tableau4[[#This Row],[Contrôle]]=Tableau4[[#This Row],[Nombre]],\"FERMER\",\"OUVERT\")","v":"OUVERT"}]
[null,"ORD-00004","2019-12-01T17:36:09","ART-00001","test",9,{"v":1.5,"d":"€1.50"},{"v":13.5,"d":"€13.50"},"supp2",{"$f":"IFERROR( INDEX(Tableau5[Nombre],MATCH(1,(Tableau4[[#This Row],[ Nr commande]]=Tableau5[Nr Bon de commande])*(Tableau4[[#This Row],[Nr article]]=Tableau5[REF]),0)),\"\")","v":""},{"$f":"IF(Tableau4[[#This Row],[Contrôle]]=Tableau4[[#This Row],[Nombre]],\"FERMER\",\"OUVERT\")","v":"OUVERT"}]

{"sheet":"Po","index":3,"n_rows":48,"n_cols":7,"rows_kept":48,"merged":[[44,1,49,4]]}
{"$rows_empty":10}
[null,"Nr. Com","ORD-00004",null,null,"Date:",{"$f":"IFERROR(INDEX(Tableau4[Date],MATCH(Po!C11,Tableau4[[ Nr commande]],0)),\"\")","v":"2019-12-01T17:36:09"}]
[]
[]
[]
[null,"schipping adress:",{"$nulls":3},"Fournisseur:"]
[null,{"$f":"Config!C27","v":" Di Falco"},{"$nulls":3},{"$f":"IFERROR(INDEX(Tableau4[Fournisseur],MATCH(Po!C11,Tableau4[[ Nr commande]],0)),\"\")","v":"supp2"}]
[null,{"$f":"Config!C28","v":"Rue du chien qui fume"},{"$nulls":3},{"$f":"IFERROR(INDEX(Tableau1[Adresse],MATCH(Po!$F$16,Tableau1[[ Nom]],0)),\"\")","v":"adresse2"}]
[null,{"$f":"CONCATENATE(LEFT(Config!C31,2),\"-\",Config!C29,\",\",Config!C30)","v":"Fr-43200,Yssingeaux"},{"$nulls":3},{"$f":"IFERROR(INDEX(Tableau1[Groupe],MATCH(Po!$F$16,Tableau1[[ Nom]],0)),\"\")","v":"Fr -43201,Yssingeaux"}]
[null,{"$f":"Config!C32","v":"06 79 40 03 29"},{"$nulls":3},{"$f":"IFERROR(INDEX(Tableau1[Téléphone],MATCH(Po!$F$16,Tableau1[[ Nom]],0)),\"\")","v":"5 71 54 55 56"}]
[null,{"$f":"Config!C33","v":"djspyd@hotmail.fr"},{"$nulls":3},{"$f":"IFERROR(INDEX(Tableau1[Mail],MATCH(Po!$F$16,Tableau1[[ Nom]],0)),\"\")","v":"excelderien@gmail.com"}]
[]
[null,"Nr.","Nr Article","Nom","Nombre","Prix unité","Total"]
[null,{"$f":"IF(C23<>\"\",ROW()-22,\"\")","v":1},{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":"ART-00002"},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":"tttt"},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":{"v":2,"d":"2.00 €"}},{"$f":"IFERROR(F23*E23,\"\")","v":""}]
[null,{"$f":"IF(C24<>\"\",ROW()-22,\"\")","v":2},{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":"ART-00001"},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":"test"},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":9},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":{"v":1.5,"d":"1.50 €"}},{"$f":"IFERROR(F24*E24,\"\")","v":{"v":13.5,"d":"13.50 €"}}]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[null,"",{"$f":"IFERROR(INDEX(Tableau4[Nr article],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nom],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Nombre],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau4[Prix],SMALL(IF(Tableau4[[ Nr commande]]=Po!$C$11,ROW(Tableau4[Nr article])-5),ROW()-22)),\"\")","v":""},""]
[]
[null,{"$f":"Config!C35","v":"1.Veuillez envoyer deux copies de votre facture.\n2.Entrez cette commande conformément aux tarifs, aux conditions, à la méthode de livraison et auxspécification\nrépertoriés ci-dessus.\n3. Veuillez nous informer immédiatement si vous n'êtes pas en mesure d'expédier la commande telle que spécifiée."}]
[{"$nulls":5},"Total:",{"$f":"SUM(G23:G43)","v":{"v":13.5,"d":"13.50 €"}}]
[{"$nulls":5},20,{"$f":"G46*F47/100","v":{"v":2.7,"d":"2.70 €"}}]
[{"$nulls":5},"Total: TTC",{"$f":"SUM(G46:G47)","v":{"v":16.2,"d":"16.20 €"}}]

{"sheet":"Booking","index":4,"n_rows":12,"n_cols":10,"rows_kept":12}
[]
[]
[]
[]
[null," Type","Nr Facture","Nr Bon de commande","Fournisseur","Client","REF","Nombre","Date","Ranking"]
[{"$nulls":9},{"$f":"IF(Tableau5[[ Type]]=\"Sortie\",COUNTIFS(Tableau5[[ Type]],\"Sortie\",Tableau5[Nombre],\">\"&Tableau5[[#This Row],[Nombre]])+1,\"\")","v":""}]
[null,"Entrée",null,null,"",null,12,10,"2019-12-22T22:59:32",{"$f":"IF(Tableau5[[ Type]]=\"Sortie\",COUNTIFS(Tableau5[[ Type]],\"Sortie\",Tableau5[Nombre],\">\"&Tableau5[[#This Row],[Nombre]])+1,\"\")","v":""}]
[null,"Sortie",{"$nulls":3},"",12,1,"2019-12-22T23:02:39",{"$f":"IF(Tableau5[[ Type]]=\"Sortie\",COUNTIFS(Tableau5[[ Type]],\"Sortie\",Tableau5[Nombre],\">\"&Tableau5[[#This Row],[Nombre]])+1,\"\")","v":1}]
[]
[]
[]
[{"$nulls":7}," "]

{"sheet":"Fournisseur","index":5,"n_rows":22,"n_cols":9,"rows_kept":22}
[]
[]
[]
[]
[null," Nom","Adresse","Cp","Ville","Pays","Téléphone","Mail","Groupe"]
[null,"supp1","adresse1",43200,"Yssingeaux","France","04 71 54 55 56","excelderien@gmail.com",{"$f":"CONCATENATE(LEFT(F6,2),\" -\",D6,\",\",E6)","v":"Fr -43200,Yssingeaux"}]
[null,"supp2","adresse2",43201,"Yssingeaux","France","5 71 54 55 56","excelderien@gmail.com","Fr -43201,Yssingeaux"]
[null,"supp3","adresse3",43202,"Yssingeaux","France","6 71 54 55 56","excelderien@gmail.com","Fr -43202,Yssingeaux"]
[null,"supp4","adresse4",43203,"Yssingeaux","France","7 71 54 55 56","excelderien@gmail.com","Fr -43203,Yssingeaux"]
[null,"supp5","adresse5",43204,"Yssingeaux","France","8 71 54 55 56","excelderien@gmail.com","Fr -43204,Yssingeaux"]
[null,"supp6","adresse6",43205,"Yssingeaux","France","9 71 54 55 56","excelderien@gmail.com","Fr -43205,Yssingeaux"]
[null,"supp7","adresse7",43206,"Yssingeaux","France","10 71 54 55 56","excelderien@gmail.com","Fr -43206,Yssingeaux"]
[null,"supp8","adresse8",43207,"Yssingeaux","France","11 71 54 55 56","excelderien@gmail.com","Fr -43207,Yssingeaux"]
[null,"supp9","adresse9",43208,"Yssingeaux","France","12 71 54 55 56","excelderien@gmail.com","Fr -43208,Yssingeaux"]
[null,"supp10","adresse10",43209,"Yssingeaux","France","13 71 54 55 56","excelderien@gmail.com","Fr -43209,Yssingeaux"]
[null,"supp11","adresse11",43210,"Yssingeaux","France","14 71 54 55 56","excelderien@gmail.com","Fr -43210,Yssingeaux"]
[null,"supp12","adresse12",43211,"Yssingeaux","France","15 71 54 55 56","excelderien@gmail.com","Fr -43211,Yssingeaux"]
[null,"supp13","adresse13",43212,"Yssingeaux","France","16 71 54 55 56","excelderien@gmail.com","Fr -43212,Yssingeaux"]
[null,"supp14","adresse14",43213,"Yssingeaux","France","17 71 54 55 56","excelderien@gmail.com","Fr -43213,Yssingeaux"]
[null,"supp15","adresse15",43214,"Yssingeaux","France","18 71 54 55 56","excelderien@gmail.com","Fr -43214,Yssingeaux"]
[null,"supp16","adresse16",43215,"Yssingeaux","France","19 71 54 55 56","excelderien@gmail.com","Fr -43215,Yssingeaux"]
[null,"supp17","adresse17",43216,"Yssingeaux","France","20 71 54 55 56","excelderien@gmail.com","Fr -43216,Yssingeaux"]

{"sheet":"Client","index":6,"n_rows":25,"n_cols":9,"rows_kept":25}
[" "]
[]
[]
[]
[null," Nom","Adresse","Cp","Ville","Pays","Téléphone","Mail","Groupe"]
[null," ","adresse1",43200,"Yssingeaux","France","04 71 54 55 56","excelderien@gmail.com",{"$f":"CONCATENATE(LEFT(F6,2),\" -\",D6,\",\",E6)","v":"Fr -43200,Yssingeaux"}]
[null,"Custom2","adresse2",43201,"Yssingeaux","France","5 71 54 55 56","excelderien@gmail.com",{"$f":"CONCATENATE(LEFT(F7,2),\" -\",D7,\",\",E7)","v":"Fr -43201,Yssingeaux"}]
[null,"Custom3","adresse3",43202,"Yssingeaux","France","6 71 54 55 56","excelderien@gmail.com","Fr -43202,Yssingeaux"]
[null,"Custom4","adresse4",43203,"Yssingeaux","France","7 71 54 55 56","excelderien@gmail.com","Fr -43203,Yssingeaux"]
[null,"Custom5","adresse5",43204,"Yssingeaux","France","8 71 54 55 56","excelderien@gmail.com","Fr -43204,Yssingeaux"]
[null,"Custom6","adresse6",43205,"Yssingeaux","France","9 71 54 55 56","excelderien@gmail.com","Fr -43205,Yssingeaux"]
[null,"Custom7","adresse7",43206,"Yssingeaux","France","10 71 54 55 56","excelderien@gmail.com","Fr -43206,Yssingeaux"]
[null,"Custom8","adresse8",43207,"Yssingeaux","France","11 71 54 55 56","excelderien@gmail.com","Fr -43207,Yssingeaux"]
[null,"Custom9","adresse9",43208,"Yssingeaux","France","12 71 54 55 56","excelderien@gmail.com","Fr -43208,Yssingeaux"]
[null,"Custom10","adresse10",43209,"Yssingeaux","France","13 71 54 55 56","excelderien@gmail.com","Fr -43209,Yssingeaux"]
[null,"Custom11","adresse11",43210,"Yssingeaux","France","14 71 54 55 56","excelderien@gmail.com","Fr -43210,Yssingeaux"]
[null,"Custom12","adresse12",43211,"Yssingeaux","France","15 71 54 55 56","excelderien@gmail.com","Fr -43211,Yssingeaux"]
[null,"Custom13","adresse13",43212,"Yssingeaux","France","16 71 54 55 56","excelderien@gmail.com","Fr -43212,Yssingeaux"]
[null,"Custom14","adresse14",43213,"Yssingeaux","France","17 71 54 55 56","excelderien@gmail.com","Fr -43213,Yssingeaux"]
[null,"Custom15","adresse15",43214,"Yssingeaux","France","18 71 54 55 56","excelderien@gmail.com","Fr -43214,Yssingeaux"]
[null,"Custom16","adresse16",43215,"Yssingeaux","France","19 71 54 55 56","excelderien@gmail.com","Fr -43215,Yssingeaux"]
[null,"Custom17","adresse17",43216,"Yssingeaux","France","20 71 54 55 56","excelderien@gmail.com","Fr -43216,Yssingeaux"]
[null,"Custom18","adresse18",43217,"Yssingeaux","France","21 71 54 55 56","excelderien@gmail.com",{"$f":"CONCATENATE(LEFT(F23,2),\" -\",D23,\",\",E23)","v":"Fr -43217,Yssingeaux"}]
[null,"Custom19","adresse19",43218,"Yssingeaux","France","22 71 54 55 56","excelderien@gmail.com",{"$f":"CONCATENATE(LEFT(F24,2),\" -\",D24,\",\",E24)","v":"Fr -43218,Yssingeaux"}]
[null,"Custom20","adresse20",43219,"Yssingeaux","France","23 71 54 55 56","excelderien@gmail.com","Fr -43219,Yssingeaux"]

{"sheet":"Config","index":7,"n_rows":52,"n_cols":9,"rows_kept":52,"merged":[[34,2,40,5]]}
[]
[]
[]
[]
[]
[null,"Nav Items",{"$nulls":6},"Nav Color"]
[]
[null,"Page1","Accueil",{"$nulls":5},"Background"]
[null,"Page2","Article"]
[null,"Page3","Commande",{"$nulls":5},"Page"]
[null,"Page4","Bon"]
[null,"Page5","Booking"]
[null,"Page6","Fournisseur"]
[null,"Page7","Client"]
[null,"Page8","Config"]
[]
[null,"Suffixe"]
[{"$nulls":5}," "]
[null,"Article","ART-",3,{"$f":"C19&TEXT(D19,\"00000\")","v":"ART-00003"}]
[null,"Ordeer","ORD-",5,{"$f":"C20&TEXT(D20,\"00000\")","v":"ORD-00005"}]
[null,"Booking","BOO-",1,{"$f":"C21&TEXT(D21,\"00000\")","v":"BOO-00001"}]
[]
[]
[]
[null,"Bon de commande"]
[]
[null,"Entreprise"," Di Falco"]
[null,"Adresse","Rue du chien qui fume"]
[null,"Code postal",43200]
[null,"Ville","Yssingeaux"]
[null,"Pays","France"]
[null,"Tel","06 79 40 03 29"]
[null,"Mail","djspyd@hotmail.fr"]
[]
[null,"condition","1.Veuillez envoyer deux copies de votre facture.\n2.Entrez cette commande conformément aux tarifs, aux conditions, à la méthode de livraison et auxspécification\nrépertoriés ci-dessus.\n3. Veuillez nous informer immédiatement si vous n'êtes pas en mesure d'expédier la commande telle que spécifiée."]
{"$rows_empty":9}
[null,"Tableau de bord"]
[]
[null,"Widget1","Valeur du stock",{"$f":"SUM(Tableau3[Valeur Stock])","v":{"v":0,"d":"0.00 €"}}]
[null,"Widget2","Article en commande",{"$f":"COUNTIF(Tableau4[Check],\"OUVERT\")","v":6}]
[null,"Widget3","Article Critique",{"$f":"COUNTIF(Tableau3[Flag],1)","v":0}]
[null,"Widget4","Nombre d'article en stock",{"$f":"COUNTIF(Tableau3[Statuts],\"Active\")","v":0}]
[null,"Widget5","Volume du stock",{"$f":"SUM(Tableau3[Stock])","v":0}]
[null,"Widget6","Top 3 article vendue",{"$f":"IFERROR(INDEX(Tableau5[REF],MATCH(1,Tableau5[Ranking],0)),\"\")","v":12},{"$f":"IFERROR(INDEX(Tableau5[REF],MATCH(2,Tableau5[Ranking],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tableau5[REF],MATCH(3,Tableau5[Ranking],0)),\"\")","v":""}]

{"sheet":"Gamme","index":8,"n_rows":26,"n_cols":21,"rows_kept":26}
[]
[null,"Gourmande","Siempre","Cool_n_Fruit","Coricancha","Instinct_Gourmand","So_Fifty","Dark_Story","Classique","Fraîcheur","Fruitée","Équilibre","Cocktail","KIT COMPLET","MOD BOX","CLEARO","CHARGEUR ACCU","RANGEMENT ","ACCESSOIRES","PYREX","ACCU "]
[null,"ANIS","AMERICAN","BERY KISS","CHERIMOYA","HONEY & MILK","CAFÉ EXPRESSO","BLACK RAFT","AMBER SKY","CHLOROPHYLLE","ANANAS","POMME CAMOMILLE","BLACK RAFT","AMNIS","PUNK 85","GS AIR M","NITECORE","POCHETTE","DRIP","ELLO DURO",18650]
[null,"BARBE A PAPA","BROWN DIAMOND","BLUE FLASH","PITAJAYA","LEMON & PIE","FRAISE MÛRE","COFFEE ROCK","AMERICAN","ICE ROCKET","CASSIS","THÉ ROUGE","DRAGON OIL","ENDURA T20S","PUNK 220","GS TURBO","XTAR","ETUI",null,"ELLO LONG",21700]
[null,"BUBBLE GUM","CALIFORNIA","GOLDEN DRIZZ","MANGO","VANILLA & POPCORN","FRAISE RHUBARBE","CRISPY BREW","BRITISH","MENTHE","CERISE","THÉ VERT","FORT DE France","EGO AIO PRO BOX","PICO","GS DRIVE",null,"BOITIER",null,"MELO 4"]
[null,"CAFÉ","FR4","GRINGO LEMON",null,null,"FRAMBOISE CASSIS","D'NIGHT","BROWN DIAMOND","MENTHE FRAÎCHE","CITRON","THÉ VERT MENTHE","GREEN TEMPTATION","VECO PLUS SOLO","PICO 25","NAUTILUS",null,"BOITE ACCUS",null,"MELO 5"]
[null,"CAFÉ EXPRESSO","FR-K","LADY PIMIKO",null,null,"FRUIT ROUGES","DRAGON OIL","CALIFORNIA","MENTHE GLACIALE","FRAISE","TILLEUL CITRON","LEMON ICE","TANCE MAX","MELO 60","GS TANK",null,"PROTECTION ACCUS",null,"VECO +"]
[null,"CANDY BANANE","FR-M","TROPIC MOON",null,null,"MENTHE GLACIALE","FORT DE France","CAVENDISH","MENTHOCALYPTUS","FRAISE MÛRE","VERVEINE MENTHE","MOJITO","ISTICK TRIM","AEGIS LEGEND 200","MELO 3",null,"SKIN AIO",null,"SKY SOLO"]
[null,"CANDY COLA","FR-MINT",{"$nulls":3},"MENTHOCALYPTUS","GREEDY KING","CORDOVAN","PIN EUCALYPTUS","FRAMBOISE ",null,"PURPLE BLOOD","COOL FIRE",null,"MELO 4",{"$nulls":3},"TFV12 "]
[null,"CANDY FRAISE","FR-ONE",{"$nulls":3},"NOISETTE","ICE ROCKET","FR4",null,"FRAMBOISE #2",null,"SWEET JOKER","EGO AIO",null,"MELO 5",{"$nulls":3},"TFV 12 PRINCE"]
[null,"CANDY VIOLETTE","FR-W",{"$nulls":3},"POMME FUJI","LEMON ICE","FR5",null,"FRAMBOISE CASSIS",null,"TROPICAL CLOUD","ISTICK BASIC",null,"HELLO",{"$nulls":3},"TFV8 X BABY"]
[null,"CARAMEL","MALAWIA",{"$nulls":4},"POMME CANNELLE","FR-K",null,"FRUIT ROUGES",null,"VANILLA CUSTARD","ADEPT",null,"ROTOR"]
[null,"CHOCO-NOISETTE","USA-MIX",{"$nulls":4},"PURPLE BLOOD","FR-M",null,"GRENADINE",null,null,"ISTICK PICO 25",null,"TV12"]
[null,"ENERGY DRINK",{"$nulls":5},"RUBY SKIN","FR-MINT",null,"LIMETTE",null,null,"STICK PRINCE",null,"TV8 X BABY"]
[null,"NOISETTE",{"$nulls":5},"SUMMER FEELING","FR-ONE",null,"MANGUE",null,null,"ISTICK MELO 60",null,"ZLIDE"]
[null,"RÉGLISSE",{"$nulls":5},"SUNNY FIZZ","FR-W",null,"MELON",null,null,"MAG KIT"]
[{"$nulls":7},"SWEET JOKER","GOLD",null,"MÛRE",null,null,"AEGIS LEGEND"]
[{"$nulls":7},"TROPICAL CLOUD","KENTUCKY",null,"MYRTILLE",null,null,"ISTICK PICO S"]
[{"$nulls":7},"VANILLA CUSTARD","LATAKIA",null,"NOIX DE COCO",null,null,"TERROS"]
[{"$nulls":7},"YELLOW TWIST","MALAWIA",null,"ORANGE SANGUINE",null,null,"ALFAPOD"]
[{"$nulls":8},"MYTHIC EDEN",null,"PASSION"]
[{"$nulls":8},"ORIENTAL",null,"PÊCHE"]
[{"$nulls":8},"ROYAL",null,"POIRE"]
[{"$nulls":8},"SAHARIAN",null,"POMME ROUGE"]
[{"$nulls":8},"USA-MIX",null,"POMME VERTE"]
[{"$nulls":8},"VIRGINIA"]

{"sheet":"Liste","index":9,"n_rows":44,"n_cols":10,"rows_kept":44}
[]
[null,"Caracteristique",null,"Compo",null,"Couleur",null,"Marque",null,"mode"]
[null,"0 Mg",null,"76/24 PG/VG",null,"jaune",null,"p",null,"VIR"]
[null,"03 Mg",null,"64/36 PG/VG",null,"Rouge",null,"ASPIRE",null,"CH"]
[null,"06 Mg",null,"50/50 PG/VG",null,"Vert",null,"ELEAF",null,"ES"]
[null,"11 Mg",null,"70/30",null,"Silver",null,"GEEK VAP",null,"CB"]
[null,"16 Mg",null,"20/80",{"$nulls":3},"INNOKIN"]
[null,"19,6 Mg",null,"25/75",{"$nulls":3},"JOYETECH"]
[null,"12Mg",null,"60/40",{"$nulls":3},"SMOK"]
[null,"18 MG",null,"30/70",{"$nulls":3},"TESLA"]
[null,"0.12 Ohm",{"$nulls":5},"VAPORESSO"]
[null,"0.13 Ohm",{"$nulls":5},"NITECORE"]
[null,"0.15 Ohm",{"$nulls":5},"XTAR"]
[null,"0.17 Ohm",{"$nulls":5},"COIL MASTER"]
[null,"0.18 Ohm",{"$nulls":5},"REVOLUTE"]
[null,"0.20 Ohm",{"$nulls":5},"VDLV"]
[null,"0.25 Ohm",{"$nulls":5},"TAKLOPE"]
[null,"0.30 Ohm",{"$nulls":5},"EFEST"]
[null,"0.35 Ohm"]
[null,"0.40 Ohm"]
[null,"0.48 Ohm"]
[null,"0.50 Ohm"]
[null,"0.60 Ohm"]
[null,"0.75 Ohm"]
[null,"0.80 Ohm"]
[null,"1.00 Ohm"]
[null,"1.20 Ohm"]
[null,"1.30 Ohm"]
[null,"1.40 Ohm"]
[null,"1.50 Ohm"]
[null,"1.60 Ohm"]
[null,"1.70 Ohm"]
[null,"1.80 Ohm"]
[null,"10 ML"]
[null,"50 ML"]
[null,"3500 MAH"]
[null,"3700 MAH"]
[null,"D22"]
[null,"D25"]
[null,"WORLD"]
[null,"VATE"]
[null,"510"]
[null,"810"]
[null,"vchhdf"]