{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["BD","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Aout","Septembre","Octobre","Novembre","Décembre"],"not_rendered":{"macros":1,"defined_names":6},"read":"whole","date_system":"1904"}

{"sheet":"BD","index":0,"n_rows":19,"n_cols":55,"rows_kept":19,"merged":[[3,24,3,26],[3,27,3,33]]}
[null,2017,{"$nulls":46},{"$f":"COLUMN(AW:AW)","v":49}]
[null,{"$f":"TODAY()","v":"2017-12-19"},{"$nulls":4},"LISTE 2017"]
[]
[{"$nulls":5},1,{"$nulls":18},"Offre",null,null,"Cde client"]
["numéro unique","Status","N°","Date Promise","Article","Commentaire","n°","Config","Site de Production","Gestionnaire","Typologie","Status","Reception ","planning ","Revue","Réunion ","Reunion Prod","Notation","Fin de fabrication","CTL","Notation","Accord Expe ","Bilan - cloture","Transfert à la production","Client","EDP","Offre","Commande","Qté","Prix","CA","Quantité annuelle","CA annuel","Date de livraison demandée","DLivPromise","SLivrPlanS0","prom-mois","prom-année","DlivRéelle","MlivRéelle","AlivRéelle","bilan","à J","à J+7","à J+14"," retard","Resp"," rebut","AAA","D (90%)","C(+-10%)","Q(0NC)","Total","Total","aa"]
["00291-0029-00291-0029 (00.SE1202DF)",1,123456,"2017-02-15","00291-0029 (00.SE1202DF)",0,1,"A","F","BBB","A","Série0","2016-11-24","2016-11-24","X","1904-01-01","X",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 1","EDP1",123,"CDE A",200,8.98,1796,400,3592,"2017-02-03","2017-02-03",5,1,2017,"1904-01-01",null,null,0,1,1,1,0,0,0,0,0,0,0,"0/3",0,53]
["238934-00291-0025 (00.1670-113)",1,456788,"2017-02-15","00291-0025 (00.1670-113)","VIS",1,"A","F","BBB","A","Série0","2016-06-09","std by","2016-09-13","X","1904-01-01",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 1","EDPX",456,"CDE A",300,4.61,1383,720,3319.2000000000003,"2016-07-18","2017-02-15",7,1,2017,"1904-01-01",null,null,0,1,1,1,"","","",0,0,0,0,"0/3",0,53]
["240965-PN3320",1,111452,"2017-03-24","PN3320",0,1,"B","F","AAA","A","Série0","2016-12-05","2016-12-05","1904-01-01","1904-01-01","1904-01-01",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 3","EDP1",7844,"CDE A",10,240.77,2407.7000000000003,76,18298.52,"2017-03-24","2017-03-24",12,3,2017,"1904-01-01",null,null,0,1,1,1,"","","",0,0,0,0,"0/3",0,53]
["238687-PN5850",1,124554,"2017-12-31","PN5850","LAME ",2,"B","F","AAA","A","Série0","2016-12-19","1904-01-01","1904-01-01","1904-01-01","1904-01-01",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 1","EDPX",999,"CDE A",0,0,0,0,0,"2017-12-31","2017-12-31",52,12,2017,"1904-01-01",null,null,0,1,1,1,0,0,0,0,0,0,0,"0/3",0,53]
["239234-15501-0002",2,101112,"2016-10-20","15501-0002","etrier + ctt",3,"A","F","AAA","A","Série0","2016-07-15","2558-12-31","2016-07-19","x","x",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 2","EDP1",1222,"CDE A",2000,2.31,4620,10000,23100,"2016-10-18","2016-10-20",42,11,2016,"1904-01-01",null,null,0,1,1,1,"","","",0,0,0,0,"0/3",0,53]
["240340-00291-0028 (1408-8-050)",2,111214,"2017-02-08","00291-0028 (1408-8-050)",0,3,"A","F","BBB","A","Série0","2016-09-29","2016-09-29","2016-10-12","2016-11-14","X",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 1","EDPX","AAAB","CDE A",50,14.06,703,10,140.6,"2017-01-13","2017-02-08",6,1,2017,"1904-01-01",null,null,0,1,1,1,0,0,0,0,0,0,0,"0/3",0,53]
["240737-S15-TW22040405",2,201017,"2017-02-15","S15-TW22040405","piece L",1,"A","F","AAA","B","Série0","2016-12-30","ENR","2016-12-07","2016-12-07","2016-12-07",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 1","EDP Y",11369,"CDE A",20,55.35,1107,20,22140,"2017-02-15","2017-02-15",7,1,2017,"1904-01-01",null,null,0,1,1,1,"","","",0,0,0,0,"0/3",0,53]
["240737-S15-TW22040406",2,240737,"2017-02-15","S15-TW22040406","piece de liaison",1,"B","F","AAA","B","Série0","2016-12-30","ENR","2016-12-07","2016-12-07","2016-12-07",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 2","EDP1",11369,"CDE A",10,63.5,635,10,6350,"2017-02-15","2017-02-15",7,2,2017,"1904-01-01",null,null,0,1,1,1,"","","",0,0,0,0,"0/3",0,53]
["240347-S01-7.874.7250",2,201017,"2017-02-22","S01-7.874.7250","Cylindre",1,"B","F","AAA","B","Série0","2016-12-30","ENR","2017-01-10","1904-01-01","1904-01-01",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 3","EDP1","BBB","CDE A","2+2",540.6,2162.4,4,2162.4,"2017-02-22","2017-02-22",8,2,2017,"1904-01-01",null,null,0,1,1,1,"","","",0,0,0,0,"0/3",0,53]
["240404-S01-EIVBG16664",2,240404,"2017-02-24","S01-EIVBG16664","VIS",2,"B","F","AAA","A","Série0","2016-11-07","ENR","2016-11-09","2016-11-14","X",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 1","EDP Y",11254,"CDE A",18,68.36,1230.48,18,1230.48,"2017-02-24","2017-02-22",8,2,2017,"1904-01-01",null,null,0,1,1,1,0,0,0,0,0,0,0,"0/3",0,53]
["240404-S01-EIVBG16665",2,201017,"2017-02-24","S01-EIVBG16665",null,2,"C","F","AAA","A","Série0","2016-11-07","ENR","2016-11-09","2016-11-14","X",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 2","EDP1",11254,"CDE A",23,52.6,1209.8,23,1209.8,"2017-02-24","2017-02-22",8,2,2017,"1904-01-01",null,null,0,1,1,1,0,0,0,0,0,0,0,"0/3",0,53]
["240404-S01-EIVBG16666",2,240404,"2017-02-24","S01-EIVBG16666","Cylindre",3,"C","F","AAA","A","Série0","2016-11-07","ENR","2016-11-09","2016-11-14","X",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 2","EDP Y","devis 11292","CDE A",18,190.67,3432.06,18,3432.06,"2017-02-24","2017-02-22",8,2,2017,"1904-01-01",null,null,0,1,1,1,0,0,0,0,0,0,0,"0/3",0,53]
["240404-S01-EIVBG16667",2,240404,"2017-02-24","S01-EIVBG16667","VIS",1,"C","F","AAA","A","Série0","2016-11-07","ENR","2016-11-09","2016-11-14","X",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 2","EDP Y",11254,"CDE A",23,245.59,5648.57,23,5648.57,"2017-02-24","2017-02-22",8,2,2017,"1904-01-01",null,null,0,1,1,1,0,0,0,0,0,0,0,"0/3",0,53]
["00291-0030-00291-0030 (00.1408-5-050)",2,201017,"2017-04-28","00291-0030 (00.1408-5-050)","VIS",1,"C","F","BBB","A","Série0","2016-12-21","2016-12-22","2017-01-24","2017-01-19","X",{"v":0,"d":"0%"},"1904-01-01","1904-01-01",{"v":0,"d":"0%"},0,0,0,"CLIENT 3","EDP Y","ACV","CDE A",70,6.84,478.8,210,1436.3999999999999,"2017-03-06","2017-04-28",17,4,2017,"1904-01-01",null,null,0,1,1,1,0,0,0,0,0,0,0,"0/3",0,53]

{"sheet":"Janvier","index":1,"n_rows":5,"n_cols":12,"rows_kept":5}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]
[1,123456,41319,"00291-0029 (00.SE1202DF)",0,1,"CLIENT 1",200,8.98,1796,"2017-02-03","2017-02-03"]
[2,111214,41312,"00291-0028 (1408-8-050)",0,3,"CLIENT 1",50,14.06,703,"2017-01-13","2017-02-08"]
[1,456788,41319,"00291-0025 (00.1670-113)","VIS",1,"CLIENT 1",300,4.61,1383,"2016-07-18","2017-02-15"]
[2,201017,41319,"S15-TW22040405","piece L",1,"CLIENT 1",20,55.35,1107,"2017-02-15","2017-02-15"]

{"sheet":"Février","index":2,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]

{"sheet":"Mars","index":3,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]

{"sheet":"Avril","index":4,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]

{"sheet":"Mai","index":5,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]

{"sheet":"Juin","index":6,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]

{"sheet":"Juillet","index":7,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]

{"sheet":"Aout","index":8,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]

{"sheet":"Septembre","index":9,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]

{"sheet":"Octobre","index":10,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]

{"sheet":"Novembre","index":11,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]

{"sheet":"Décembre","index":12,"n_rows":1,"n_cols":12,"rows_kept":1}
["Status","N°","Date Promise","Article","Commentaire","IPA n°","Client","Qté","Prix","CA","Date de livraison demandée","DLivPromise"]