{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Articles unitaires","Magasins"],"not_rendered":{"macros":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Articles unitaires","index":0,"n_rows":36,"n_cols":11,"rows_kept":36}
[null,{"$f":"filtrecol(B3:B1000,B2)","v":"Paris"},{"$f":"filtrecol(C3:C1000,C2)","v":"Etoile,Beaubourg"},{"$f":"filtrecol(D3:D1000,D2)","v":"A,B,C"},{"$nulls":4},"Total  coût",null,"Total  PV HT"]
["Période","Ville","Quartier","Nom Magasin","Article vendu","Taille","PV HT",null,{"$f":"Magasins!E1","v":{"v":4350,"d":"4,350"}},null,{"$f":"SUBTOTAL(9,Tableau4[PV HT])","v":373}]
["2018-08-31","Paris","Etoile","A","Chemise","S",99]
["2018-08-31","Paris","Etoile","B","Jean","S",130]
["2018-08-31","Paris","Beaubourg","C","Chemise","M",99]
["2018-08-31","Paris","Marais","D","T-shirt","M",55]
["2018-08-31","Paris","Marais","E","Jean","XL",130]
["2018-08-31","Lyon","Confluence","F","Chemise","M",99]
["2018-08-31","Lyon","Guillotière","G","Chemise","M",99]
["2018-08-31","Lyon","Guillotière","H","Chemise","XL",99]
["2018-08-31","Lyon","Part Dieu","I","Chausettes","XL",15]
["2018-08-31","Lyon","Part Dieu","J","Jean","L",130]
["2018-08-31","Lyon","Part Dieu","K","Jean","L",130]
["2018-08-31","Nantes","Malakoff","L","T-shirt","M",55]
["2018-08-31","Nantes","Malakoff","M","T-shirt","L",55]
["2018-08-31","Nantes","Hauts Pavés","N","Chausettes","S",15]
["2018-08-31","Nantes","Hauts Pavés","P","Chausettes","S",15]
["2018-08-31","Nantes","Hauts Pavés","Q","T-shirt","M",55]
["2018-08-31","Paris","Marais","D","T-shirt","XL",55]
["2018-08-31","Paris","Etoile","A","Chausettes","XL",15]
["2018-08-31","Paris","Etoile","B","Chausettes","S",15]
["2018-08-31","Paris","Beaubourg","C","Chausettes","S",15]
["2018-08-31","Paris","Marais","D","Chemise","S",99]
["2018-08-31","Paris","Marais","E","Chemise","M",99]
["2018-08-31","Lyon","Confluence","F","Chemise","M",99]
["2018-08-31","Lyon","Guillotière","G","Chemise","M",99]
["2018-08-31","Lyon","Guillotière","H","Chemise","XL",99]
["2018-08-31","Lyon","Part Dieu","I","Jean","S",130]
["2018-08-31","Lyon","Part Dieu","J","Jean","XL",130]
["2018-08-31","Lyon","Part Dieu","K","Jean","L",130]
["2018-08-31","Nantes","Malakoff","L","Jean","L",130]
["2018-08-31","Nantes","Malakoff","M","T-shirt","M",55]
["2018-08-31","Nantes","Hauts Pavés","N","T-shirt","M",55]
["2018-08-31","Nantes","Hauts Pavés","P","T-shirt","L",55]
["2018-08-31","Nantes","Hauts Pavés","Q","T-shirt","M",55]
["2018-08-31","Paris","Marais","D","T-shirt","XL",55]

{"sheet":"Magasins","index":1,"n_rows":18,"n_cols":11,"rows_kept":18}
[null,{"$f":"filtrecol(B3:B1000,OtreTablo[[#Headers],[Ville]])","v":"Paris"},{"$f":"filtrecol(C3:C1000,OtreTablo[[#Headers],[Quartier]])","v":"Etoile,Beaubourg"},{"$f":"filtrecol(D3:D1000,OtreTablo[[#Headers],[Nom Magasin]])","v":"A,B,C"},{"$f":"SUBTOTAL(9,OtreTablo[Coût])","v":{"v":4350,"d":"4,350"}},{"$nulls":5},"http://boisgontierjacques.free.fr"]
["Période","Ville","Quartier","Nom Magasin","Coût"]
["2018-08-31","Paris","Etoile","A",{"v":1500,"d":"1,500"}]
["2018-08-31","Paris","Etoile","B",{"v":2000,"d":"2,000"}]
["2018-08-31","Paris","Beaubourg","C",850]
["2018-08-31","Paris","Marais","D",{"v":1300,"d":"1,300"}]
["2018-08-31","Paris","Marais","E",{"v":1800,"d":"1,800"}]
["2018-08-31","Lyon","Confluence","F",{"v":1000,"d":"1,000"}]
["2018-08-31","Lyon","Guillotière","G",{"v":1200,"d":"1,200"}]
["2018-08-31","Lyon","Guillotière","H",{"v":1100,"d":"1,100"}]
["2018-08-31","Lyon","Part Dieu","I",{"v":1350,"d":"1,350"}]
["2018-08-31","Lyon","Part Dieu","J",{"v":1400,"d":"1,400"}]
["2018-08-31","Lyon","Part Dieu","K",{"v":1420,"d":"1,420"}]
["2018-08-31","Nantes","Malakoff","L",890]
["2018-08-31","Nantes","Malakoff","M",{"v":1460,"d":"1,460"}]
["2018-08-31","Nantes","Hauts Pavés","N",900]
["2018-08-31","Nantes","Hauts Pavés","P",{"v":1300,"d":"1,300"}]
["2018-08-31","Nantes","Hauts Pavés","Q",{"v":1110,"d":"1,110"}]