{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Bonjour","Intro","Donnees","jeu de données","Resultats","Feuil1","Sauve_encours","Bar"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Bonjour","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,3,11,9],[12,3,12,9],[10,3,10,9],[5,3,6,9],[3,3,3,9],[4,3,4,9],[8,3,8,9],[9,3,9,9]]}
[0.8,null,null,null,80]
[]
[]
[null,null,null,"Gestion de la production et des flux"]
[null,null,null,"Vincent Giard ©"]
[null,null,null,"Gestion calendaire des approvisionnements de type « période de révision calendaire T, niveau de recomplètement S »"]
[]
[]
[null,null,null,"Le menu \" Gestion T, S ...\" dans l'onglet \"Compléments\" la barre de menu vous permet de :"]
[null,null,null," - Lancer un nouveau problème en choisissant \"Nouveau problème\", restaurer la dernière saisie par \"Restaurer la saisie en cours\", ou simplement revoir les derniers résultats."]
[null,null,null," - Gérer l'affichage des pages en agrandissant le zoom (\"Affichage : Agrandir\") ou en le réduisant (\"Affichage : Réduire\") ou revenir au zoom initial (\"Affichage : Restaurer\")."]
[null,null,null," - Enregistrer une copie du programme et du problème courant par \"Enregistrer sous…\""]
[null,null,null," - Quitter en choisissant \"Quitter\""]

{"sheet":"Intro","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Donnees","index":2,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["nb_articles",1]
["Stockable",false]
["Perdu",false]
["Contrainte","Sans"]
["Valeur_contrainte",0]
["nb_periodes_decoupage",260]
["Duree_T",1]
["T_an",260]
["Duree_L",0]
["Taux_de_possession",0]
["Def_an__per_tx_pos",true]
["Cout_commande",0]
["choix_pol","Optimum"]
["Designation(i)","Univers"]
["loi(i)","Normal"]
["Def_parametre_sur_T(i)",true]
["Moyenne_saisie(i)",300]
["Ecart_type_saisi(i)",20]
["CA(i)",18]
["PV(i)",25]
["VR(i)",16]
["CR(i)",0]
["S_impose(i)",0]
["Alpha_S_impose(i)",0]
["Beta_S_impose(i)",0]
["Dispo_lors_commande(i)",0]
["cons_uni(i)",0]
["periode_decoupage","Jours ouvrables"]
["indice_cours",1]
["nb_label",1]
["Q_en_attente(i)",0]

{"sheet":"jeu de données","index":3,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["nb_articles",3,3,3]
["Stockable",true,true,true]
["Perdu",true,true,true]
["Contrainte","Finance","Finance","Finance"]
["Valeur_contrainte",1500,1500,1500]
["nb_periodes_decoupage",52,52,52]
["Duree_T",1,1,1]
["T_an",52,52,52]
["Duree_L",0,0,0]
["Taux_de_possession",0.2,0.2,0.2]
["Def_an__per_tx_pos",true,true,true]
["Cout_commande",0,0,0]
["choix_pol","Optimum","Optimum","Optimum"]
["Designation(i)","Ampoule","Tourne-vis","Marteau"]
["loi(i)","Normal","Poisson","Normal"]
["Def_parametre_sur_T(i)",true,true,true]
["Moyenne_saisie(i)",300,30,100]
["Ecart_type_saisi(i)",20,null,15]
["CA(i)",3,4,6]
["PV(i)",3.5,7,9]
["VR(i)",0,0,0]
["CR(i)",0,0,0]
["S_impose(i)"]
["Alpha_S_impose(i)"]
["Beta_S_impose(i)"]
["Dispo_lors_commande(i)"]
["cons_uni(i)",1,1,1]
["periode_decoupage","Jours ouvrables","Jours ouvrables","Jours ouvrables"]
["indice_cours"]
["nb_label",1,1,1]
["Q_en_attente(i)"]

{"sheet":"Resultats","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Politique optimale"]
["Conséquences physiques de la politique d'approvisionnement pour \"Univers\"","par période de révision calendaire",null,"par an (sur 260 périodes calendaires)"]
["Stock S de début de période",315,null,"-"]
["Stock de sécurité",15,null,"-"]
["Demande moyenne satisfaite",297.4881039387044,null,77346.907024063141]
["Rupture moyenne de stock",2.5118960612955981,null,653.09297593685551]
["Pourcentage de demandes non satisfaites",8.3729868709853262E-3,null,8.3729868709853262E-3]
["Probabilité de rupture par période de révision calendaire",0.21916976035713942,null,"-"]
["Nombre moyen annuel de périodes en rupture de stock","-",null,56.984137692856251]
["Stock résiduel moyen",17.511896061295598,null,4553.0929759368555]
["Conséquences financières de la politique d'approvisionnement"]
["Dépense d'acquisition nette moyenne",5389.8096630192704,null,1401350.5123850103]
["Coût de commande / Charges fixes calendaires",0,null,0]
["Coût de rupture",17.583272429069186,null,4571.6508315579886]
["Coût de possession",35.023792122591196,null,9106.185951873711]
["Indicateur de coût moyen",52.607064551660386,null,13677.8367834317]
["Marge nette moyenne",2047.3929354483396,null,532322.1632165683]

{"sheet":"Feuil1","index":5,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["nb_articles",3,1,3]
["Stockable",true,true,true]
["Perdu",false,false,false]
["Contrainte","Stockage","Stockage","Stockage"]
["Valeur_contrainte",100,100,100]
["nb_periodes_decoupage",52,52,52]
["Duree_T",4,4,4]
["T_an",52,52,52]
["Duree_L",2,2,2]
["Taux_de_possession",0.2,0.2,0.2]
["Def_an__per_tx_pos",true,true,true]
["Cout_commande",0,0,0]
["choix_pol","Optimum","Optimum","Optimum"]
["Designation(i)","CTR12","CTR10","CTR15"]
["loi(i)","Normal","Normal","Normal"]
["Def_parametre_sur_T(i)",false,false,false]
["Moyenne_saisie(i)",650,520,286]
["Ecart_type_saisi(i)",126,100,50]
["CA(i)",260,292.5,325]
["PV(i)",310,350,370]
["VR(i)",0,0,0]
["CR(i)",10,10,10]
["S_impose(i)"]
["Alpha_S_impose(i)"]
["Beta_S_impose(i)"]
["Dispo_lors_commande(i)"]
["cons_uni(i)",1,1,1]
["periode_decoupage","semaine","semaine","semaine"]
["indice_cours"]
["nb_label",1,1,1]
["Q_en_attente(i)"]
[]
[null,{"$f":"0.2*B19","v":52}]
[null,{"$f":"B33*B7","v":208}]
[null,650,126,310]
[null,520,100,350]
[null,286,50,370]

{"sheet":"Sauve_encours","index":6,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["nb_articles",1]
["Stockable",false]
["Perdu",false]
["Contrainte","Sans"]
["Valeur_contrainte",0]
["nb_periodes_decoupage",260]
["Duree_T",1]
["T_an",260]
["Duree_L",0]
["Taux_de_possession",0]
["Def_an__per_tx_pos",true]
["Cout_commande",0]
["choix_pol","Optimum"]
["Designation(i)","Univers"]
["loi(i)","Normal"]
["Def_parametre_sur_T(i)",true]
["Moyenne_saisie(i)",300]
["Ecart_type_saisi(i)",20]
["CA(i)",18]
["PV(i)",25]
["VR(i)",16]
["CR(i)",0]
["S_impose(i)",0]
["Alpha_S_impose(i)",0]
["Beta_S_impose(i)",0]
["Dispo_lors_commande(i)",0]
["cons_uni(i)",0]
["periode_decoupage","Jours ouvrables"]
["indice_cours",1]
["nb_label",1]
["Q_en_attente(i)",0]

{"sheet":"Bar","index":7,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[".DisplayFormulaBar ",false]
["Standard",false,null,null,null,null,2,2,null,1]
["Formatting",false,null,null,null,null,false,false,null,true]
["PivotTable",false,null,null,null,null,true,true,null,true]
["Chart",false,null,null,null,null,"Sans","Sans",null,"Sans"]
["Reviewing",false,null,null,null,null,0,0,null,0]
["Forms",false,null,null,null,null,260,260,null,52]
["Stop Recording",false,null,null,null,null,1,1,null,2]
["External Data",false,null,null,null,null,260,260,null,52]
["Full Screen",false,null,null,null,null,0,0,null,3]
["Circular Reference",false,null,null,null,null,0,0,null,0.2]
["Visual Basic",false,null,null,null,null,true,true,null,true]
["Web",false,null,null,null,null,0,0,null,0]
["Exit Design Mode",false,null,null,null,null,"Optimum","Optimum",null,"Optimum"]
["Drawing",false,null,null,null,null,null,"test","test 2","Article 1"]
["WordArt",false,null,null,null,null,null,"Poisson",null,"Poisson"]
["Picture",false,null,null,null,null,null,false,false,false]
["Shadow Settings",false,null,null,null,null,null,20,40,100]
["3-D Settings",false,null,null,null,null,null,0,0]
[".DisplayFormulas ",false,null,null,null,null,null,10,30,600]
[".DisplayGridlines ",false,null,null,null,null,null,20,60,1000]
[".DisplayHeadings ",false,null,null,null,null,null,5,12,0]
[".DisplayOutline ",false,null,null,null,null,null,12,32,140]
[".DisplayZeros ",true,null,null,null,null,null,0,0,0]
[".DisplayHorizontalScrollBar ",true,null,null,null,null,null,0,0,0]
[".DisplayVerticalScrollBar ",true,null,null,null,null,null,0,0,0]
[".DisplayWorkbookTabs ",false,null,null,null,null,null,0,0,3]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Jours ouvrables","Jours ouvrables",null,"Semaines"]
[null,null,null,null,null,null,null,2,null,1]
[null,null,null,null,null,null,1,1,null,2]
[null,null,null,null,null,null,null,null,null,4]