{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Ventes Année N","Solution1","Solution2","Solution3","Feuil2"],"not_rendered":{"charts":3,"macros":1,"defined_names":5,"pivot_tables":4},"read":"whole","date_system":"1900"}

{"sheet":"Ventes Année N","index":0,"n_rows":52,"n_cols":8,"rows_kept":52}
["Date commande","Vendeur","Client","Produit","Catégorie","Prix unitaire ","Quantité","Montant"]
["2019-01-05","Garnier","FOLIE","Kona","Café",1.6,85,{"$f":"F2*G2","v":136}]
["2019-01-05","Garnier","FOLIE","Merida","Café",1.55,100,155]
["2019-01-06","Katz","BOTTO","Ecuador","Café",1.6,100,160]
["2019-01-06","Katz","BOTTO","Jamaican Blue","Café",5.49,100,549]
["2019-01-06","Katz","BOTTO","Russian Blend","Thé",2,28,56]
["2019-01-08","Garnier","FAMIL","Darjeeling","Thé",3.09,30,92.69999999999999]
["2019-01-08","Garnier","FAMIL","Merida","Café",1.55,100,155]
["2019-01-08","Garnier","FOLIE","Tanzania","Café",1.45,80,116]
["2019-01-23","Langston","GALER","Celebes","Café",1.45,95,137.75]
["2019-01-23","Langston","GALER","India","Café",1.45,130,188.5]
["2019-01-30","Garnier","CACTU","Darjeeling","Thé",3.09,20,61.8]
["2019-01-30","Garnier","CACTU","Haiti","Café",1.45,100,145]
["2019-02-02","Hubert","BLOND","Celebes","Café",1.45,100,145]
["2019-02-02","Hubert","BLOND","India","Café",1.45,200,290]
["2019-02-02","Hubert","BLOND","India","Café",1.45,90,130.5]
["2019-02-10","Hubert","BLOND","Ecuador","Café",1.6,100,160]
["2019-02-10","Hubert","BLOND","Haiti","Café",1.45,20,29]
["2019-02-14","Hubert","BLOND","Kona","Café",1.6,100,160]
["2019-02-14","Hubert","BLOND","Merida","Café",1.55,100,155]
["2019-02-24","Garnier","FOLIE","Assam","Thé",1.48,20,29.6]
["2019-02-24","Garnier","FOLIE","India","Café",1.45,100,145]
["2019-02-27","Langston","GALER","Celebes","Café",1.45,100,145]
["2019-02-27","Langston","GALER","Celebes","Café",1.45,100,145]
["2019-02-27","Garnier","CACTU","Lapsang Souchong","Thé",1.54,20,30.8]
["2019-02-28","Langston","GALER","Russian Blend","Thé",2,20,40]
["2019-03-02","Langston","COMER","Keemun","Thé",1.48,15,22.2]
["2019-03-23","Garnier","FOLIE","Jamaican Blue","Café",5.49,100,549]
["2019-03-30","Langston","COMER","Celebes","Café",1.45,100,145]
["2019-04-13","Ziegler","ANTON","Russian Blend","Thé",2,20,40]
["2019-04-27","Hubert","BLOND","Kona","Café",1.6,120,192]
["2019-04-27","Hubert","BLOND","Kona","Café",1.6,150,240]
["2019-04-27","Hubert","BLOND","Russian Blend","Thé",2,20,40]
["2019-05-08","Garnier","FOLIE","Haiti","Café",1.45,20,{"$f":"F34*G34","v":29}]
["2019-05-12","Hubert","BLOND","Darjeeling","Thé",3.09,20,61.8]
["2019-05-12","Hubert","BLOND","Lapsang Souchong","Thé",1.54,20,30.8]
["2019-05-12","Hubert","BLOND","Pluma","Café",1.6,100,160]
["2019-05-22","Langston","GALER","India","Café",1.45,65,94.25]
["2019-05-22","Langston","GALER","Haiti","Café",1.45,100,145]
["2019-05-22","Langston","GALER","Russian Blend","Thé",2,20,40]
["2019-06-01","Hubert","BLOND","Ecuador","Café",1.6,70,112]
["2019-06-01","Hubert","BLOND","Tanzania","Café",1.45,60,87]
["2019-06-02","Garnier","FOLIE","Merida","Café",1.55,100,155]
["2019-06-02","Garnier","FOLIE","Merida","Café",1.55,100,155]
["2019-06-02","Garnier","FOLIE","Russian Blend","Thé",2,20,40]
["2019-06-12","Hubert","BLOND","India","Café",1.45,100,145]
["2019-06-12","Garnier","FOLIE","Darjeeling","Thé",3.09,20,61.8]
["2019-06-15","Hubert","BLOND","India","Café",1.45,300,435]
["2019-06-15","Hubert","BLOND","India","Café",1.45,150,217.5]
["2019-06-15","Ziegler","ANTON","Keemun","Thé",1.48,20,29.6]
["2019-06-15","Ziegler","ANTON","Pi Lo Chun","Thé",1.69,20,33.8]
["2019-06-23","Hubert","BLOND","Tanzania","Café",1.45,250,362.5]

{"sheet":"Solution1","index":1,"n_rows":9,"n_cols":11,"rows_kept":9}
[{"$nulls":9},"PowerPivot Data","Nom connexion"]
[]
["Étiquettes de lignes","Somme de Montant","Somme de Quantité",{"$nulls":6},{"$f":"CUBESET(\"PowerPivot Data\",Segment_Catégorie1,\"Catégorie\")","v":"Catégorie"},"Jeu"]
["Garnier",316.7,130,{"$nulls":6},{"$f":"IFERROR(CUBERANKEDMEMBER($J$1,$J$3,ROW(J1)),\"\")","v":"Thé"},"1ère valeur"]
["Hubert",132.6,60]
["Katz",56,28]
["Langston",102.2,55]
["Ziegler",103.4,60,null,{"$f":"VLOOKUP(J4,Infos[],2,0)","v":"blabbla Thé"}]
["Total général",710.9,333]

{"sheet":"Solution2","index":2,"n_rows":11,"n_cols":14,"rows_kept":11}
[{"$nulls":12},"Catégorie","Thé"]
[]
["Étiquettes de lignes","Somme de Montant","Somme de Quantité"]
["Garnier",316.70000000000005,130]
["Hubert",132.6,60]
["Katz",56,28]
["Langston",102.2,55]
["Ziegler",103.4,60]
["Total général",710.9000000000001,333]
[]
[{"$nulls":4},{"$f":"VLOOKUP(N1,Infos[],2,0)","v":"blabbla Thé"}]

{"sheet":"Solution3","index":3,"n_rows":8,"n_cols":9,"rows_kept":8}
["Étiquettes de lignes","Somme de Montant","Somme de Quantité",{"$nulls":5},"Café"]
["Garnier",1740,885]
["Hubert",3020.5,2010]
["Katz",709,200]
["Langston",1000.5,690]
["Total général",6470,3785]
[]
[{"$nulls":5},{"$f":"VLOOKUP(I1,Infos[],2,0)","v":"Blibli Café"}]

{"sheet":"Feuil2","index":4,"n_rows":3,"n_cols":2,"rows_kept":3}
["Breuvage","Détail"]
["Thé","blabbla Thé"]
["Café","Blibli Café"]