{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["InputSheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":1,"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":"InputSheet","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Parameters","Value","Comment",null,null,null,null,null,null,null,"VBA:"]
["lambda",0.01,"Failure rate",null,null,null,null,null,null,null,"sparePartLibAnalytic",null,"Module for analytic solution"]
["mu",0.1,"Repair rate",null,null,null,null,null,null,null,"sparePartLibMarkov"]
["s",3,"# of spares"]
["m",20,"# of repair men"]
["c_U",10000,"Unavailability cost per time unit"]
["c_S",2,"Cost per spare per time unit"]
["c_M",0.25,"Cost per repair man per unit (prepardeness cost)"]
["infty",4,"How large is \"infinity\"?"]
[]
["Parameters","Value"]
["Markov:"]
["EBO =",3.9289898268179968E-6,null,null,"Exercise 2: Set c_M=0 and run What-If (Markov)"]
["Cost =",{"$f":"EBO*c_U+s*c_S+c_M*m","v":11.03928989826818},null,null,"Exercise 3: Just run What-If (Markov)",null,null,null,null,null,"Exercises 1"]
["Analytic:"]
["EBO =",{"$f":"EBOanalytic(lambda,mu,s)","v":3.9492733776569366E-6},null,null,"Markov, What if",null,null,null,null,null,"Analytic, What if"]
["Cost =",{"$f":"Cost(lambda,mu,c_U,c_S,s)","v":6.0394926071166992},null,null,"Min=",{"$f":"MIN(F20:I24)","v":6.3630428411997855},null,null,null,null,"Min=",{"$f":"MIN(L20:L24)","v":5.5859308242797852}]
[]
["Probability","Value",null,null,"m¯ \\ s®",1,2,3,4,null,"s¯",{"$f":"B17","v":6.0394926071166992}]
["P-4",-1.725568798960353E-9,null,null,1,113.31099933385849,15.354651493951678,7.360238372348249,8.3605988212657394,null,1,50.374237060546875]
["P-3",3.7139871178482053E-9,null,null,2,52.623436376452446,7.0062641361728311,6.6249621072929585,8.5068205150682843,null,2,5.5859308242797852]
["P-2",7.6345450850112684E-8,null,null,3,51.163830809295177,6.3630428411997855,6.8038112453796202,8.7520041647985636,null,3,6.0394926071166992]
["P-1",3.7720592445111834E-6,null,null,4,51.374738544225693,6.5864903980400413,7.0403053445552359,9.0005791358859142,null,4,8.0011167526245117]
["P0",1.5080782759469002E-4,null,null,5,51.624230973422527,6.835872087161988,7.2888878652302083,9.2508029152809286,null,5,10.000442504882813]
["P1",4.5241871848702431E-3]
["P2",9.0483725070953369E-2]
["P3",0.90483742952346802]