{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Accueil","Consultation","Mvt","Article","Param"],"not_rendered":{"images":1,"macros":1,"defined_names":11,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":15,"n_cols":2,"rows_kept":15}
{"$rows_empty":14}
[null,{"$f":"HYPERLINK(\"http://philippe.tulliez.be\",\"© Philippe Tulliez\")","v":"© Philippe Tulliez"}]

{"sheet":"Consultation","index":1,"n_rows":11,"n_cols":13,"rows_kept":11,"merged":[[0,3,0,8],[6,3,6,6]]}
["Qté","RefSto",null,"Consultation des mouvements de stock",{"$nulls":8},"Nbre sélectionné"]
[{"$f":"VLOOKUP($E$3,T_CriteriaMvt[],2,FALSE)","v":">0"},{"$f":"IF(LEN(E2),E2,\"\")","v":"R03"},null,"Ref","R03",null,null,"Libellé",{"$f":"IF(LEN($E$2),VLOOKUP($B$2,T_Article[],MATCH(H2,T_Article[#Headers],0),0),\"\")","v":"Article 3"},{"$nulls":3},{"$f":"DCOUNTA(T_Mvt[#All],T_Mvt[[#Headers],[RefSto]],Consultation!areaCriteria)","v":2}]
[{"$nulls":3},"Type de Mvt","Achat",null,null,"Prix",{"$f":"IF(LEN($E$2),VLOOKUP($B$2,T_Article[],MATCH(H3,T_Article[#Headers],0),0),\"\")","v":22}]
[]
[]
[]
[{"$nulls":3},{"$f":"IF(NumberRowsToExport,NumberRowsToExport & \" mouvements pour cet article \",\"Pas de mouvement de ventes\")","v":"2 mouvements pour cet article "}]
[]
[{"$nulls":3},"Date","Tiers","Qté","Prix"]
[{"$nulls":3},"2012-01-01","F01",8,{"v":11,"d":"11.0"}]
[{"$nulls":3},"2012-02-01","F02",15,{"v":10,"d":"10.0"}]

{"sheet":"Mvt","index":2,"n_rows":34,"n_cols":6,"rows_kept":34}
["Date","RefSto","Qté","Prix","Tiers","Stock"]
["2012-01-01","R03",8,{"v":11,"d":"11.0"},"F01",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":13}]
["2012-01-05","R01",10,9.5,"F02",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":20}]
["2012-01-24","R02",-1,7.5,"C01",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":24}]
["2012-02-01","R03",15,{"v":10,"d":"10.0"},"F02",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":28}]
["2012-02-03","R03",-7,{"v":22,"d":"22.0"},"C07",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":21}]
["2012-02-04","R02",-4,7.5,"C07",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":20}]
["2012-02-06","R01",-4,12.2,"C04",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":16}]
["2012-02-24","R01",-5,12.5,"C07",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":11}]
["2012-02-29","R03",-7,{"v":22,"d":"22.0"},"C03",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":14}]
["2012-03-01","R01",12,{"v":12,"d":"12.0"},"F01",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":23}]
["2012-03-12","R01",-7,{"v":15,"d":"15.0"},"C01",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":16}]
["2012-03-14","R03",-1,{"v":22,"d":"22.0"},"C01",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":13}]
["2012-03-21","R01",-6,{"v":15,"d":"15.0"},"C04",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":10}]
["2012-03-26","R02",-5,7.7,"C07",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":15}]
["2012-04-07","R02",-1,7.7,"C03",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":14}]
["2012-04-13","R02",-6,7.7,"C04",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":8}]
["2012-04-21","R02",-2,7.7,"C07",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":6}]
["2012-05-03","R02",15,3.2,"F01",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":21}]
["2012-05-05","R02",-7,7.7,"C04",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":14}]
["2012-05-05","R03",-5,{"v":22,"d":"22.0"},"C07",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":8}]
["2012-05-08","R02",-4,7.7,"C01",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":10}]
["2012-05-23","R02",-4,7.7,"C07",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":6}]
["2012-06-01","R02",-6,7.7,"C04",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":0}]
["2012-06-03","R02",20,{"v":3,"d":"3.0"},"F01",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":20}]
["2012-06-05","R01",10,{"v":14,"d":"14.0"},"F04",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":20}]
["2012-06-12","R01",-5,{"v":15,"d":"15.0"},"C03",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":15}]
["2012-06-25","R02",-6,7.7,"C07",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":14}]
["2012-06-26","R03",-2,{"v":22,"d":"22.0"},"C01",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":6}]
["2012-06-26","R02",-6,7.7,"C03",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":8}]
["2012-07-07","R02",-5,7.7,"C07",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":3}]
["2012-07-08","R03",-5,{"v":22,"d":"22.0"},"C03",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":1}]
["2012-07-12","R01",-6,{"v":15,"d":"15.0"},"C03",{"$f":"VLOOKUP(T_Mvt[[#This Row],[RefSto]],T_Article[],5,FALSE)+SUMIF($B$2:T_Mvt[[#This Row],[RefSto]],T_Mvt[[#This Row],[RefSto]],$C$2:T_Mvt[Qté])","v":9}]
["Total",null,{"$f":"SUBTOTAL(109,T_Mvt[Qté])","v":-27},null,{"$f":"SUBTOTAL(103,T_Mvt[Tiers])","v":32}]

{"sheet":"Article","index":3,"n_rows":6,"n_cols":7,"rows_kept":6}
["Ref","Libellé","Prix","Tva","StockD","Min","Max"]
["R01","Article 1",15,2,10,7,12]
["R02","Article 2",7.7,1,25,5,15]
["R03","Article 3",22,1,5,3,7]
["R04","Article 4",15,1,0,2,5]
["R05","Article 5",13,2,0,2,6]

{"sheet":"Param","index":4,"n_rows":4,"n_cols":5,"rows_kept":4}
["Date de test","2012-07-18",null,"Mvt stock","Critères"]
[{"$nulls":3},"Vente","<0"]
[{"$nulls":3},"Achat",">0"]
[{"$nulls":3},"Achat/Vente","<>"]