{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["donnees","resultat","explications","resultat souhaité"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"donnees","index":0,"n_rows":20,"n_cols":52,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Base","Commentaires","Pays","Region","Resp","Produit","Activité","Nom produit","Ref 1","Ref 2","Nom Ref 1","Nom Ref 2","Autres","Statut","Année","Nb Heures","Interne","externe","Delta","Cout interne","Cout externe","Cout","Mag 1","Mag 2","Mag 3","Mag 4","Mag 5","Mag 6","Mag 7","Mag 8","Mag 9","Mag 10","Mag 11","Mag 12","Mag 13","Mag 14","Mag 15","Mag 16","Mag 17","Mag 18","Mag 19","Mag 20","Mag 21","Mag 22","Mag 23","Mag 24","Mag 25","Mag 26","Mag 27","Mag 28","Mag 29","Mag 30"]
["data",null,"France","MP",null,"Sac","Loisir",null,"A634","Code 1","bandoulière","lila",null,null,2014,null,null,null,{"$f":"P2-Q2-R2","v":0},null,null,{"$f":"T2+U2","v":0},5,null,null,null,200,null,null,null,null,null,null,2.2999999999999998,null,null,1,null,null,null,null,null,null,null,1]
["data",null,"France","MP",null,"Sac","Loisir",null,"A634","Code 2","bandoulière","rose",null,"Terminé",2013,100,50,50,{"$f":"P3-Q3-R3","v":0},45,45,90,{"$f":"10+10","v":20},600,40,7,500,90,1,800,500,1.6,null,84,null,null,2,null,91,null,null,9,null,null,null,null,null,null,34,null,null,45]
["data",null,"France","MP",null,"Sac","Loisir",null,"A634","Code 3","bandoulière","vert",null,"En cours",2013,20,null,20,0,null,null,90,100,300,200,1000,10,100,0.5,null,null,null,10,null,null,0.1,3,null,null,null,7,null,27,null,null,57,null,null,null,67]
["data",null,"France","MP",null,"Sac","Loisir",null,"A634","Code 3","bandoulière","vert",null,"En cours",2013,10,null,null,10,null,null,90,null,null,null,50,null,null,null,null,300,null,null,678,null,null,4,null,null,null,null,null,null,34,null,null,null,null,null,null,234]
["data",null,"France","MP",null,"Sac","Loisir",null,"A634","Code 4","bandoulière","rouge",null,"En cours",2013,40,40,40,-40,45,45,90,10,600,100,null,null,null,null,null,null,null,40,null,76,null,50,null,null,null,null,null,null,null,null,null,27,null,12]
["data",null,"France","MP",null,"Sac","Loisir",null,"A634","Code 4","bandoulière","rouge",null,"En cours",2013,20,null,null,20,null,null,90,null,null,null,300,400,500,0.9,10,null,null,null,null,null,null,60]
["data",null,"France","MP",null,"Sac","Loisir",null,"A634","Code 4","bandoulière","rouge",null,"En cours",2013,0,null,null,0,null,null,90,null,null,null,null,40,200,null,null,null,null,50,null,3,null,70,null,null,45,null,null,46,null,null,null,null,65,null,23,null,67]
["data",null,"France","MP",null,"Sac","Loisir",null,"A634","Code 4","bandoulière","rouge",null,"En cours",2013,1000,null,null,1000,null,null,90,null,null,null,null,null,null,null,null,null,null,null,56,null,0.7,80,56,null,null,null,null,null,56]
["data",null,"France","MP",null,"Vélo","Sport",null,"V_45_000","Code 5","VTT",null,null,"Terminé",2012,360,null,null,360,null,null,180,null,null,45,null,null,null,null,null,789,null,null,null,null,null,80,null,null,null,4]
["data",null,"France","MP",null,"Vélo","Sport",null,"V_45_000",null,"VTT",null,null,"Terminé",2012,80,null,null,80,null,null,180,3,null,null,null,null,null,67,null,null,null,null,null,null,null,80,null,40,null,null,67]
["data",null,"France","Paris",null,"Vélo","Sport",null,"W5_000_24",null,"BMX",null,null,"Terminé",2012,16,null,null,16,null,null,220,null,null,null,89,null,null,null,89,null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,69,null,null,null,null,12]
["data",null,"France","Paris",null,"Vélo","Sport",null,"W5_000_24",null,"BMX",null,null,"Terminé",2012,8,null,null,8,null,null,220,null,78,null,null,9,null,null,null,null,null,null,null,null,12,80,null,null,null,null,null,null,23]
["data",null,"France","Paris",null,"Vélo","Sport",null,"W5_000_24",null,"BMX",null,null,"Terminé",2013,40,null,null,40,null,null,220,null,null,null,null,null,345,null,34,null,null,23,null,null,null,80,89,null,null,null,null,8,null,null,null,null,null,23,null,null,87]
["data",null,"France","Paris",null,"Vélo","Sport",null,"W5_000_24",null,"BMX",null,null,"Terminé",2013,80,null,null,80,null,null,220,56,null,null,null,null,null,null,null,null,null,null,null,null,null,80,null,null,14,null,null,null,null,null,null,25,null,null,42]
["data",null,"France","Paris",null,"Vélo","Sport",null,"W5_000_24",null,"BMX",null,null,"Terminé",2013,60,null,null,60,null,null,220,null,null,null,null,34,null,78,null,null,null,null,null,null,null,80,null,null,null,null,56]
["data",null,"France","Paris",null,"Table","Maison",null,"DCD_1030_000",null,null,null,null,"Terminé",2012,70,null,null,70,null,null,null,null,90,null,null,null,45,null,null,null,null,null,null,null,null,80,2,null,null,null,null,null,null,null,null,null,234]
["data",null,"France","Paris",null,"Table","Maison",null,"DCD_1030_000",null,null,null,null,"Terminé",2012,130,null,null,130,null,null,null,null,null,67,67,null,null,null,23,null,31,null,null,null,null,80,null,null,null,1]
["data",null,"France","Paris",null,"Table","Maison",null,"DCD_1030_000",null,null,null,null,"Terminé",2013,180,null,null,180,null,null,null,34,null,null,null,21,null,null,null,45,null,null,null,45,null,80,null,null,null,null,null,97,null,null,null,null,null,null,null,98]
["data",null,"France","Paris",null,"Table","Maison",null,"DCD_2030_000",null,null,null,null,null,2014,null,null,null,0,null,null,null,null,null,123,null,null,null,null,null,null,null,null,null,null,null,80,null,null,89,null,null,null,null,2,null,null,null,null,null,null,867]

{"sheet":"resultat","index":1,"n_rows":130,"n_cols":16,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
["Nom Mag","base","Pays","Region","Produit","Activité","Nom produit","Ref 1","Ref 2","Nom Ref 1","Nom Ref 2","Statut","Année","Cout interne","Mag","Calcul auto"]
["Mag 1","data","France","MP","Sac","Loisir",null,"A634","Code 1","bandoulière","lila",null,2014,null,5]
["Mag 1","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,20]
["Mag 1","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,100]
["Mag 1","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,10]
["Mag 1","data","France","MP","Vélo","Sport",null,"V_45_000",null,"VTT",null,"Terminé",2012,null,3]
["Mag 1","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,56]
["Mag 1","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2013,null,34]
["Mag 2","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,600]
["Mag 2","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,300]
["Mag 2","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,600]
["Mag 2","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,78]
["Mag 2","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,90]
["Mag 3","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,40]
["Mag 3","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,200]
["Mag 3","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,100]
["Mag 3","data","France","MP","Vélo","Sport",null,"V_45_000","Code 5","VTT",null,"Terminé",2012,null,45]
["Mag 3","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,67]
["Mag 3","data","France","Paris","Table","Maison",null,"DCD_2030_000",null,null,null,null,2014,null,123]
["Mag 4","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,7]
["Mag 4","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,1000]
["Mag 4","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,50]
["Mag 4","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,300]
["Mag 4","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,89]
["Mag 4","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,67]
["Mag 5","data","France","MP","Sac","Loisir",null,"A634","Code 1","bandoulière","lila",null,2014,null,200]
["Mag 5","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,500]
["Mag 5","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,10]
["Mag 5","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,400]
["Mag 5","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,40]
["Mag 5","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,9]
["Mag 5","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,34]
["Mag 5","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2013,null,21]
["Mag 6","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,90]
["Mag 6","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,100]
["Mag 6","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,500]
["Mag 6","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,200]
["Mag 6","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,345]
["Mag 6","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,45]
["Mag 7","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,1]
["Mag 7","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,0.5]
["Mag 7","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,0.9]
["Mag 7","data","France","MP","Vélo","Sport",null,"V_45_000",null,"VTT",null,"Terminé",2012,null,67]
["Mag 7","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,78]
["Mag 8","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,800]
["Mag 8","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,10]
["Mag 8","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,89]
["Mag 8","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,34]
["Mag 8","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,23]
["Mag 9","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,500]
["Mag 9","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,300]
["Mag 9","data","France","MP","Vélo","Sport",null,"V_45_000","Code 5","VTT",null,"Terminé",2012,null,789]
["Mag 9","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2013,null,45]
["Mag 10","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,1.6]
["Mag 10","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,31]
["Mag 11","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,10]
["Mag 11","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,40]
["Mag 11","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,50]
["Mag 11","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,23]
["Mag 12","data","France","MP","Sac","Loisir",null,"A634","Code 1","bandoulière","lila",null,2014,null,2.2999999999999998]
["Mag 12","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,84]
["Mag 12","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,678]
["Mag 12","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,56]
["Mag 13","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,76]
["Mag 13","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,3]
["Mag 13","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2013,null,45]
["Mag 14","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,0.1]
["Mag 14","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,0.7]
["Mag 14","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,12]
["Mag 15","data","France","MP","Sac","Loisir",null,"A634","Code 1","bandoulière","lila",null,2014,null,1]
["Mag 15","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,2]
["Mag 15","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,3]
["Mag 15","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,4]
["Mag 15","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,50]
["Mag 15","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,60]
["Mag 15","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,70]
["Mag 15","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,80]
["Mag 15","data","France","MP","Vélo","Sport",null,"V_45_000","Code 5","VTT",null,"Terminé",2012,null,80]
["Mag 15","data","France","MP","Vélo","Sport",null,"V_45_000",null,"VTT",null,"Terminé",2012,null,80]
["Mag 15","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,80]
["Mag 15","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,80]
["Mag 15","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,80]
["Mag 15","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,80]
["Mag 15","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,80]
["Mag 15","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,80]
["Mag 15","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,80]
["Mag 15","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2013,null,80]
["Mag 15","data","France","Paris","Table","Maison",null,"DCD_2030_000",null,null,null,null,2014,null,80]
["Mag 16","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,56]
["Mag 16","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,89]
["Mag 16","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,2]
["Mag 17","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,91]
["Mag 17","data","France","MP","Vélo","Sport",null,"V_45_000",null,"VTT",null,"Terminé",2012,null,40]
["Mag 18","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,45]
["Mag 18","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,14]
["Mag 18","data","France","Paris","Table","Maison",null,"DCD_2030_000",null,null,null,null,2014,null,89]
["Mag 19","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,7]
["Mag 19","data","France","MP","Vélo","Sport",null,"V_45_000","Code 5","VTT",null,"Terminé",2012,null,4]
["Mag 19","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,1]
["Mag 20","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,9]
["Mag 20","data","France","MP","Vélo","Sport",null,"V_45_000",null,"VTT",null,"Terminé",2012,null,67]
["Mag 20","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,56]
["Mag 21","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,27]
["Mag 21","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,46]
["Mag 21","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,8]
["Mag 21","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2013,null,97]
["Mag 22","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,34]
["Mag 22","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,56]
["Mag 22","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,23]
["Mag 23","data","France","MP","Sac","Loisir",null,"A634","Code 1","bandoulière","lila",null,2014,null,1]
["Mag 23","data","France","Paris","Table","Maison",null,"DCD_2030_000",null,null,null,null,2014,null,2]
["Mag 24","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,57]
["Mag 24","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,69]
["Mag 25","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,27]
["Mag 25","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,25]
["Mag 26","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,65]
["Mag 26","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,234]
["Mag 27","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,34]
["Mag 27","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,12]
["Mag 27","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,23]
["Mag 28","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,67]
["Mag 28","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,23]
["Mag 28","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,42]
["Mag 29","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,234]
["Mag 29","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,12]
["Mag 29","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2013,null,98]
["Mag 30","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,45]
["Mag 30","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,67]
["Mag 30","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,87]
["Mag 30","data","France","Paris","Table","Maison",null,"DCD_2030_000",null,null,null,null,2014,null,867]

{"sheet":"explications","index":2,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[14,0,14,1]]}
["Je dois récupérer des données excel de la feuille \"donnees\" et en copier certaines dans la feuille \"resultat\"."]
["Une des données (Mag1, Mag2…) est en-tête de colonnes et les autres en lignes."]
["La donnée présente dans l’en-tête doit être mise en ligne, dupliquée pour chaque ligne copiée."]
[]
["Les données des colonnes (sauf en-tête colonne) Mag 1, Mag 2.. doivent être dans la même colonne Mag"]
["Les mentions d'en-tête : Mag1, Mag 2 dans la colonne « A » face aux lignes copiées"]
["Cette action est à faire pour 70 colonnes"]
[]
["Au final on a plus de lignes que dans la feuille \"donnees\"."]
[]
["Mes pbs:"]
["     dupliquer la donnée  Mag 1, Mag 2... dans la colonne « A » car le nombre de lignes est variable"]
["     de traiter les 70 colonnes car la colonne de référence dans la feuille \"donnees\" change (+ une colonne) y compris pour le filtre."]
[]
["Correspondance colonnes"]
["feuille \"Donnees\"","feuille \"resultat\""]
["A","B"]
["C ","C"]
["D","D"]
["F ","E"]
["G","F "]
["H","G"]
["I","H"]
["J","I"]
["K","J"]
["L","K"]
["N","L"]
["O","M"]
["T","N"]
["données colonne W puis X puis Y….","O"]
["en-tête colonne W puis X puis Y….","A"]

{"sheet":"resultat souhaité","index":3,"n_rows":49,"n_cols":16,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Nom Mag","base","Pays","Region","Produit","Activité","Nom produit","Ref 1","Ref 2","Nom Ref 1","Nom Ref 2","Statut","Année","Cout interne","Mag","Calcul auto"]
["Mag 1","data","France","MP","Sac","Loisir",null,"A634","Code 1","bandoulière","lila",null,2014,null,5]
["Mag 1","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,20]
["Mag 1","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,100]
["Mag 1","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,10]
["Mag 1","data","France","MP","Vélo","Sport",null,"V_45_000",null,"VTT",null,"Terminé",2012,null,3]
["Mag 1","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,56]
["Mag 1","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2013,null,34]
["Mag 2","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,600]
["Mag 2","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,300]
["Mag 2","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,600]
["Mag 2","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,78]
["Mag 2","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,90]
["Mag 3","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,40]
["Mag 3","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,200]
["Mag 3","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,45,100]
["Mag 3","data","France","MP","Vélo","Sport",null,"V_45_000","Code 5","VTT",null,"Terminé",2012,null,45]
["Mag 3","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,67]
["Mag 3","data","France","Paris","Table","Maison",null,"DCD_2030_000",null,null,null,null,2014,null,123]
["Mag 4","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,7]
["Mag 4","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,1000]
["Mag 4","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,50]
["Mag 4","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,300]
["Mag 4","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,89]
["Mag 4","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,67]
["Mag 5","data","France","MP","Sac","Loisir",null,"A634","Code 1","bandoulière","lila",null,2014,null,200]
["Mag 5","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,500]
["Mag 5","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,10]
["Mag 5","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,400]
["Mag 5","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,40]
["Mag 5","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,9]
["Mag 5","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,34]
["Mag 5","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2013,null,21]
["Mag 6","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,90]
["Mag 6","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,100]
["Mag 6","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,500]
["Mag 6","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,200]
["Mag 6","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,345]
["Mag 6","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,45]
["Mag 7","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,1]
["Mag 7","data","France","MP","Sac","Loisir",null,"A634","Code 3","bandoulière","vert","En cours",2013,null,0.5]
["Mag 7","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,0.9]
["Mag 7","data","France","MP","Vélo","Sport",null,"V_45_000",null,"VTT",null,"Terminé",2012,null,67]
["Mag 7","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,78]
["Mag 8","data","France","MP","Sac","Loisir",null,"A634","Code 2","bandoulière","rose","Terminé",2013,45,800]
["Mag 8","data","France","MP","Sac","Loisir",null,"A634","Code 4","bandoulière","rouge","En cours",2013,null,10]
["Mag 8","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2012,null,89]
["Mag 8","data","France","Paris","Vélo","Sport",null,"W5_000_24",null,"BMX",null,"Terminé",2013,null,34]
["Mag 8","data","France","Paris","Table","Maison",null,"DCD_1030_000",null,null,null,"Terminé",2012,null,23]