{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"Feuil1","index":0,"n_rows":8,"n_cols":56,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,40,2,45],[2,47,3,47],[2,54,2,55],[0,0,0,55],[1,0,1,9],[1,10,1,20],[1,21,1,39],[1,40,1,53],[1,54,1,55]]}
["CONTRACTUALISATION"]
["REFERENTIEL entreprise",null,null,null,null,null,null,null,null,null,"INFORMATIONS ACHATS",null,null,null,null,null,null,null,null,null,null,"CONSOMMATIONS ET PREVISIONS SAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUANTITE ACHAT CIBLE",null,null,null,null,null,null,null,null,null,null,null,null,null,"VALEUR CIBLE"]
[{"$f":"\"Nb Art: \" & SUMPRODUCT((SUBTOTAL(3,OFFSET(A5:A1999,ROW(A5:A1999)-MIN(ROW(A5:A1999)),,1)))*(A5:A1999<>\"\"))","v":"Nb Art: 4"},null,null,{"$f":"INDEX($D$5:$D$1999,MODE(IF($D$5:$D$1999<>\"\",MATCH($D$5:$D$1999,$D$5:$D$1999,0))))","v":"ROB1"},null,null,{"$f":"SUMPRODUCT((SUBTOTAL(3,OFFSET(A5:A1999,ROW(A5:A1999)-MIN(ROW(A5:A1999)),,1)))*(G5:G1999=\"oui\"))/SUMPRODUCT((SUBTOTAL(3,OFFSET(A5:A1999,ROW(A5:A1999)-MIN(ROW(A5:A1999)),,1)))*(G5:G1999<>\"\"))","v":0.25},{"$f":"\"Nb CC: \" & SUMPRODUCT((SUBTOTAL(3,OFFSET(A5:A1999,ROW(A5:A1999)-MIN(ROW(A5:A1999)),,1)))*(H5:H1999<>\"-\")*(H5:H1999<>\"\")*1) & \" / (\"  & SUMPRODUCT((SUBTOTAL(3,OFFSET(A5:A1999,ROW(A5:A1999)-MIN(ROW(A5:A1999)),,1)))*(H5:H1999<>\"\")*1)-SUMPRODUCT((SUBTOTAL(3,OFFSET(A5:A1999,ROW(A5:A1999)-MIN(ROW(A5:A1999)),,1)))*(H5:H1999<>\"-\")*(H5:H1999<>\"\")*1) & \")\"","v":"Nb CC: 0 / (4)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-01",null,null,null,null,null,null,null,"PREVISIONS CONSOLIDEES",null,null,null,null,null,null,"Quantité Provision pour risque totale sur 5 ans (nulle par défaut)",null,"2015-07-01","2015-07-01",null,null,null,{"$f":"SUBTOTAL(109,BC4:BC1999)","v":1600}]
["Article","Lib. Article","Cat.","Domaine","PF","Pilote","SEN","N° contrat","Début de validité","Fin de validité","Code Art. Fourn. (ext. ME80FN)","Lib. Art. Fourn. (ext. ME80FN)","Réf. Catalogue","Date dernier achat (ext. ME80FN)","Dernière quantité commandée (ext. ME80FN)","Delai fourn.  Max. SAS","PU SAS","PU dernier achat","PU avec revalo. à 2016","PU choisit par le CAL","PMP unitaire","Conso 2004","Conso 2005","Conso 2006","Conso 2007","Conso 2008","Conso 2009","Conso 2010","Conso 2011","Conso 2012","Conso 2013","Conso 2014","Conso du 01/01/15 -01/07/15","Total conso. 2012-2014","Prevision SAS 2014","Prevision SAS 2015","Prevision SAS 2016","Prevision SAS 2017","Total prev. 2015-2017","Rapport prév.(2015-17)/ conso.(2012-14)","Prév. Consolidées 2015","Prév. Consolidées 2016","Prév. Consolidées 2017","Prév. Consolidées 2018","Prév. Consolidées 2019","Prév. Consolidées 2020","Qu. Totale prév. 2016-2020",null,"Explication si provision pour risque","Stock à date","Cde fourn. en cours","Date livraison des Cdes fourn. en cours","PC SEN (+Qté cible SSN)","QUANTITE ACHAT CIBLE sur 5ans","VC estimée sur 5 ans","dont: Valorisation pour risque"]
["Art1",11,3,"ROB1",null,null,"oui","-","-","-",null,null,""," ",null,40,10,null,null,null,null,"","","","","","","","",9,"",20,8,29,5.3857660606446398,19.401717123024898,15.160908138169599,36.920099153314297,71.482724414508795,2.4649215315347859,20,20,20,20,20,20,100,null,null,26,0,"-",14,100,1000,0]
["Art2",22,3,"ROB1",null,null,"non","-","-","-",null,null,""," ",null,50,10,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,0,0,null,0,null,null,0,0,0,0,0,0,0,0,0,null,null,0,0,"-","0",20,200,0]
["Art3",33,3,"ROB2",null,null,"non","-","-","-",null,null,""," ",null,60,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,0,0,"-","0",0,0,0]
["Art4",44,3,"ROB2",null,null,"non","-","-","-",null,null,""," ",null,80,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,4,null,null,4,0,0,0,0,0,0,0,0,null,null,0,0,"-","0",20,400,0]

{"sheet":"Feuil2","index":1,"n_rows":8,"n_cols":70,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,45],[1,1,1,9],[1,11,1,21],[1,23,1,33],[1,35,1,45],[1,59,1,69],[2,7,3,7],[2,19,3,19],[2,31,3,31],[2,43,3,43],[2,55,3,55],[2,67,3,67],[1,47,1,57]]}
["CONTRACTUALISATION"]
[null,2015,null,2016,null,null,null,null,null,null,null," 2016 : Début du contrat",null,null,null,null,null,null,null,null,null,null,null,2017,null,null,null,null,null,null,null,null,null,null,null,2018,null,null,null,null,null,null,null,null,null,null,null,2019,null,null,null,null,null,null,null,null,null,null,null,2020]
[null,"2015-07-01",{"$f":"SUMPRODUCT(C5:C2000,Feuil1!$Q5:$Q2000)","v":120},"2015-07-01",{"$f":"SUBTOTAL(109,E5:E2000)","v":0},"30 jours",null,"Date livraison des Cde fourn. en cours",null,{"$f":"SUMPRODUCT(J5:J2000,Feuil1!$Q5:$Q2000)","v":0},null,{"$f":"SUMPRODUCT(L5:L2000,Feuil1!$Q5:$Q2000)","v":140},{"$f":"SUMPRODUCT(M5:M2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUMPRODUCT(N5:N2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUMPRODUCT(O5:O2000,Feuil1!$Q5:$Q2000)","v":400},{"$f":"SUBTOTAL(109,P5:P2000)","v":4395.6000000000004},"1iere Cde",{"$f":"F3","v":"30 jours"},null,"Date livraison des Cde fourn. en cours",null,{"$f":"SUMPRODUCT(V5:V2000,Feuil1!$Q5:$Q2000)","v":400},null,{"$f":"SUMPRODUCT(X5:X2000,Feuil1!$Q5:$Q2000)","v":340},{"$f":"SUMPRODUCT(Y5:Y2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUMPRODUCT(Z5:Z2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUMPRODUCT(AA5:AA2000,Feuil1!$Q5:$Q2000)","v":0},{"$f":"SUBTOTAL(109,AB5:AB2000)","v":0},null,{"$f":"R3","v":"30 jours"},null,"Date livraison des Cde fourn. en cours",null,{"$f":"SUMPRODUCT(AH5:AH2000,Feuil1!$Q5:$Q2000)","v":0},null,{"$f":"SUMPRODUCT(AJ5:AJ2000,Feuil1!$Q5:$Q2000)","v":140},{"$f":"SUMPRODUCT(AK5:AK2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUMPRODUCT(AL5:AL2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUMPRODUCT(AM5:AM2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUBTOTAL(109,AN5:AN2001)","v":2197.8000000000002},null,{"$f":"AD3","v":"30 jours"},null,"Date livraison des Cde fourn. en cours",null,{"$f":"SUMPRODUCT(AT5:AT2000,Feuil1!$Q5:$Q2000)","v":200},null,{"$f":"SUMPRODUCT(AV5:AV2000,Feuil1!$Q5:$Q2000)","v":140},{"$f":"SUMPRODUCT(AW5:AW2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUMPRODUCT(AX5:AX2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUMPRODUCT(AY5:AY2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUBTOTAL(109,AZ5:AZ2000)","v":2197.8000000000002},null,{"$f":"AP3","v":"30 jours"},null,"Date livraison des Cde fourn. en cours",null,{"$f":"SUMPRODUCT(BF5:BF2000,Feuil1!$Q5:$Q2000)","v":200},null,{"$f":"SUMPRODUCT(BH5:BH2000,Feuil1!$Q5:$Q2000)","v":140},{"$f":"SUMPRODUCT(BI5:BI2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUMPRODUCT(BJ5:BJ2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUMPRODUCT(BK5:BK2000,Feuil1!$Q5:$Q2000)","v":200},{"$f":"SUBTOTAL(109,BL5:BL2000)","v":2197.8000000000002},null,{"$f":"BB3","v":"30 jours"},null,"Date livraison des Cde fourn. en cours",null,{"$f":"SUMPRODUCT(BR5:BR2000,Feuil1!$Q5:$Q2000)","v":200}]
["Article","Stock à date ","Prév. Conso. Restante  Consolidées ","Qté Cde fourn. en cours","Valeur Cde fourn. 2016","Délai interne","Délai fourn.",null,"Taux de service","Qté livrée entre 01/07/2015 et le 31/12/2015",null,"Stock janvier","Prév. Conso. Consolidées","Prév. Conso. + retard N-x","Qté Cde fourn. ","Valeur Cde fourn. ","Date de Cde fourn.","Délai interne","Délai fourn.",null,"Taux de service","Qté livrée durant 2016",null,"Stock janvier","Prév. Conso. Consolidées","Prév. Conso. + retard N-x","Qté Cde fourn. ","Valeur Cde fourn. ","Date de Cde fourn.","Délai interne","Délai fourn.",null,"Taux de service","Qté livrée durant 2017",null,"Stock janvier","Prév. Conso. Consolidées","Prév. Conso. + retard N-x","Qté Cde fourn. ","Valeur Cde fourn. ","Date de Cde fourn.","Délai interne","Délai fourn.",null,"Taux de service","Qté livrée durant 2018",null,"Stock janvier","Prév. Conso. Consolidées","Prév. Conso. + retard N-x","Qté Cde fourn.","Valeur Cde fourn. ","Date de Cde fourn.","Délai interne","Délai fourn.",null,"Taux de service","Qté livrée durant 2019",null,"Stock janvier","Prév. Conso. Consolidées","Prév. Conso. + retard N-x","Qté Cde fourn. ","Valeur Cde fourn. ","Date de Cde fourn.","Délai interne","Délai fourn.",null,"Taux de service","Qté livrée durant 2020"]
["Art1",26,12,0,0,30,70,"-",1,0,null,14,20,20,40,4395.6000000000004,"2016-01-01",30,70,"2016-04-10",0.7,40,null,34,20,20,0,0,"2017-09-22",30,70,"2017-12-31",1,0,null,14,20,20,20,2197.8000000000002,"2018-09-22",30,70,"2018-12-31",0.7,20,null,14,20,20,20,2197.8000000000002,"2019-09-22",30,70,"2019-12-31",0.7,20,null,14,20,20,20,2197.8000000000002,"2020-09-22",30,70,"2020-12-31",0.7,20]
["Art2",0,0,0,0,30,60,"-",1,0,null,0,0,0,0,0,"2016-01-01",30,60,"2016-03-31",1,0,null,0,0,0,0,0,"2017-10-02","1900-01-30",60,"2017-12-31",1,0,null,0,0,0,0,0,"2018-10-02","1900-01-30",60,"2018-12-31",1,0,null,0,0,0,0,0,"2019-10-02","1900-01-30",60,"2019-12-31",1,0,null,0,0,0,0,0,"2020-10-02","1900-01-30",60,"2020-12-31",1,0]
["Art3",0,0,0,0,30,60,"-",1,0,null,0,0,0,0,0,"2016-01-01",30,60,"2016-03-31",1,0,null,0,0,0,0,0,"2017-10-02","1900-01-30",60,"2017-12-31",1,0,null,0,0,0,0,0,"2018-10-02","1900-01-30",60,"2018-12-31",1,0,null,0,0,0,0,0,"2019-10-02","1900-01-30",60,"2019-12-31",1,0,null,0,0,0,0,0,"2020-10-02","1900-01-30",60,"2020-12-31",1,0]
["Art4",0,0,0,0,30,70,"-",1,0,null,0,0,0,0,0,"2016-01-01",30,70,"2016-04-10",1,0,null,0,0,0,0,0,"2017-09-22","1900-01-30",70,"2017-12-31",1,0,null,0,0,0,0,0,"2018-09-22","1900-01-30",70,"2018-12-31",1,0,null,0,0,0,0,0,"2019-09-22","1900-01-30",70,"2019-12-31",1,0,null,0,0,0,0,0,"2020-09-22","1900-01-30",70,"2020-12-31",1,0]