{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Info","PdM_wiener","Simulate"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":47,"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":"Info","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["<Alt> + F11 to open VBA editor"]
[]
["<fn> + <alt> + F11 on Mac"]

{"sheet":"PdM_wiener","index":1,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Quantity","Value","Formula"]
["MTTF",100,"Mean time to failure without maintenance"]
["mu",{"$f":"l/MTTF","v":1},"Drift parameter"]
["sigma",2,"Infinitesimal standard deviation, volatility"]
["l",100,"Failure limit"]
["c_R",1000,"Cost of renewal"]
["c_F",10000,"Cost of failure"]
["c_U",5000,"Downtime cost per unit time"]
["T_l",5,"Lead time"]
["m",90,"Maintenance limit, i.e., our decision variable"]
["Memo (pp8-10):","TPK4120/LectureNotes/Ch12Summary.pdf (ntnu.no)"]
["alpha_m",{"$f":"(l-m)/mu","v":10},{"$f":"_xlfn.FORMULATEXT(B12)","v":"=(l-m)/mu"}]
["beta_m",{"$f":"(l-m)^2/sigma^2","v":25},"=(l-m)^2/sigma^2"]
["F(T_L)",{"$f":"cdfIG(T_l,alpha_m,beta_m)","v":0.19086995720863342},"=cdfIG(T_l,alpha_m,beta_m)"]
["MTBR",{"$f":"m/mu+T_l","v":95},"=m/mu+T_l"]
["C(m)",{"$f":"(c_R+c_F*F_T_L+c_U*numint(\"iCost\",0,T_l,alpha_m,beta_m,T_l))/MTBR","v":42.586400948072736},{"$f":"_xlfn.FORMULATEXT(B16)","v":"=(c_R+c_F*F_T_L+c_U*numint(\"iCost\",0,T_l,alpha_m,beta_m,T_l))/MTBR"}]
[75,12.500933313572204]
[{"$f":"A17+1","v":76},12.348248503583841]
[{"$f":"A18+1","v":77},12.201870536667164]
[78,12.065106574800119]
[79,11.945225748474643]
[80,11.857141895726432]
[81,11.829623023215898]
[82,11.914945417619043]
[83,12.202602469849147]
[84,12.836784631892872]
[85,14.035741995192236]
[{"$f":"A27+1","v":86},16.109153137102233]
["Minimum cost:",{"$f":"MIN(B17:B28)","v":11.829623023215898}]

{"sheet":"Simulate","index":2,"n_rows":258,"n_cols":9,"rows_kept":258,"cut":false,"hidden":false,"merged":[]}
["t","Y(t)","L",null,null,null,null,"Parameter","Value"]
[0,0,100,null,null,null,null,"Time to failure",{"$f":"MAX(A:A)","v":106.5}]
[0.5,0.66775596141815186,100]
[1,1.5003038644790649,100]
[1.5,1.2515335083007813,100]
[2,1.8423210382461548,100]
[2.5,2.9332053661346436,100]
[3,1.0638569593429565,100]
[3.5,1.6818339824676514,100]
[4,4.0934543609619141,100]
[4.5,6.940157413482666,100]
[5,5.38079833984375,100]
[5.5,6.9818987846374512,100]
[6,9.9923601150512695,100]
[6.5,9.6675167083740234,100]
[7,9.2104091644287109,100]
[7.5,8.9616050720214844,100]
[8,11.480123519897461,100]
[8.5,9.4922399520874023,100]
[9,9.4925651550292969,100]
[9.5,11.185190200805664,100]
[10,13.250283241271973,100]
[10.5,14.87028694152832,100]
[11,16.063552856445313,100]
[11.5,13.407932281494141,100]
[12,10.249432563781738,100]
[12.5,13.348359107971191,100]
[13,12.040280342102051,100]
[13.5,12.19505500793457,100]
[14,13.019855499267578,100]
[14.5,13.269101142883301,100]
[15,12.958779335021973,100]
[15.5,13.911373138427734,100]
[16,15.642955780029297,100]
[16.5,15.520296096801758,100]
[17,13.667152404785156,100]
[17.5,15.642809867858887,100]
[18,16.163291931152344,100]
[18.5,19.925056457519531,100]
[19,19.820518493652344,100]
[19.5,21.185367584228516,100]
[20,20.696531295776367,100]
[20.5,21.726882934570313,100]
[21,25.29107666015625,100]
[21.5,26.27851676940918,100]
[22,25.996774673461914,100]
[22.5,24.329696655273438,100]
[23,23.772228240966797,100]
[23.5,24.496114730834961,100]
[24,25.585201263427734,100]
[24.5,25.101936340332031,100]
[25,24.972877502441406,100]
[25.5,24.597387313842773,100]
[26,24.68342399597168,100]
[26.5,25.643772125244141,100]
[27,26.935544967651367,100]
[27.5,30.815040588378906,100]
[28,34.129722595214844,100]
[28.5,32.744369506835938,100]
[29,31.09130859375,100]
[29.5,31.897634506225586,100]
[30,33.061985015869141,100]
[30.5,34.578136444091797,100]
[31,35.718433380126953,100]
[31.5,35.996742248535156,100]
[32,35.541316986083984,100]
[32.5,36.292095184326172,100]
[33,37.841045379638672,100]
[33.5,35.831520080566406,100]
[34,34.259487152099609,100]
[34.5,36.688812255859375,100]
[35,37.055488586425781,100]
[35.5,37.142326354980469,100]
[36,40.634395599365234,100]
[36.5,38.622043609619141,100]
[37,40.068180084228516,100]
[37.5,38.886959075927734,100]
[38,38.653118133544922,100]
[38.5,42.199821472167969,100]
[39,42.136333465576172,100]
[39.5,43.126998901367188,100]
[40,44.717723846435547,100]
[40.5,43.87066650390625,100]
[41,46.227596282958984,100]
[41.5,45.645519256591797,100]
[42,43.769126892089844,100]
[42.5,44.892230987548828,100]
[43,44.305980682373047,100]
[43.5,45.129890441894531,100]
[44,45.130092620849609,100]
[44.5,45.27886962890625,100]
[45,45.704998016357422,100]
[45.5,46.777652740478516,100]
[46,45.929271697998047,100]
[46.5,47.209434509277344,100]
[47,46.403915405273438,100]
[47.5,47.687492370605469,100]
[48,47.002162933349609,100]
[48.5,47.724475860595703,100]
[49,48.078777313232422,100]
[49.5,50.454643249511719,100]
[50,51.597755432128906,100]
[50.5,52.323677062988281,100]
[51,52.735694885253906,100]
[51.5,53.986156463623047,100]
[52,52.160533905029297,100]
[52.5,52.685214996337891,100]
[53,54.026309967041016,100]
[53.5,55.374786376953125,100]
[54,57.272708892822266,100]
[54.5,59.014102935791016,100]
[55,62.531654357910156,100]
[55.5,63.70526123046875,100]
[56,64.925949096679688,100]
[56.5,64.228317260742188,100]
[57,64.506744384765625,100]
[57.5,65.647499084472656,100]
[58,66.418128967285156,100]
[58.5,63.989238739013672,100]
[59,64.973297119140625,100]
[59.5,68.272300720214844,100]
[60,68.334945678710938,100]
[60.5,69.511161804199219,100]
[61,70.89306640625,100]
[61.5,71.729263305664063,100]
[62,73.524856567382813,100]
[62.5,75.795631408691406,100]
[63,75.622634887695313,100]
[63.5,76.601493835449219,100]
[64,78.020500183105469,100]
[64.5,77.541999816894531,100]
[65,78.788993835449219,100]
[65.5,77.645523071289063,100]
[66,75.905281066894531,100]
[66.5,74.524604797363281,100]
[67,73.9549560546875,100]
[67.5,73.265121459960938,100]
[68,74.62066650390625,100]
[68.5,75.879531860351563,100]
[69,77.766555786132813,100]
[69.5,77.520347595214844,100]
[70,74.756584167480469,100]
[70.5,73.8026123046875,100]
[71,76.047782897949219,100]
[71.5,77.000534057617188,100]
[72,76.714958190917969,100]
[72.5,75.544082641601563,100]
[73,79.066871643066406,100]
[73.5,76.379676818847656,100]
[74,76.457748413085938,100]
[74.5,75.012443542480469,100]
[75,76.832595825195313,100]
[75.5,79.071456909179688,100]
[76,82.172813415527344,100]
[76.5,83.485282897949219,100]
[77,85.597602844238281,100]
[77.5,85.508987426757813,100]
[78,85.665443420410156,100]
[78.5,85.117866516113281,100]
[79,84.7310791015625,100]
[79.5,84.732460021972656,100]
[80,84.718421936035156,100]
[80.5,84.775192260742188,100]
[81,85.08184814453125,100]
[81.5,84.6004638671875,100]
[82,83.694229125976563,100]
[82.5,83.917724609375,100]
[83,84.047882080078125,100]
[83.5,84.52044677734375,100]
[84,84.062553405761719,100]
[84.5,83.812309265136719,100]
[85,82.499382019042969,100]
[85.5,82.962356567382813,100]
[86,84.2696533203125,100]
[86.5,85.519088745117188,100]
[87,86.393379211425781,100]
[87.5,87.081291198730469,100]
[88,86.7822265625,100]
[88.5,89.725250244140625,100]
[89,91.837089538574219,100]
[89.5,90.357894897460938,100]
[90,90.5501708984375,100]
[90.5,90.079231262207031,100]
[91,91.953254699707031,100]
[91.5,90.617546081542969,100]
[92,88.542747497558594,100]
[92.5,87.556327819824219,100]
[93,88.439041137695313,100]
[93.5,90.592880249023438,100]
[94,89.809379577636719,100]
[94.5,89.937469482421875,100]
[95,89.047096252441406,100]
[95.5,88.147071838378906,100]
[96,87.637351989746094,100]
[96.5,87.69580078125,100]
[97,88.529220581054688,100]
[97.5,89.323089599609375,100]
[98,90.717872619628906,100]
[98.5,94.0294189453125,100]
[99,92.094039916992188,100]
[99.5,92.125892639160156,100]
[100,94.21978759765625,100]
[100.5,93.903343200683594,100]
[101,94.868217468261719,100]
[101.5,95.150093078613281,100]
[102,97.312942504882813,100]
[102.5,99.290107727050781,100]
[103,99.891387939453125,100]
[103.5,99.113563537597656,100]
[104,97.23406982421875,100]
[104.5,96.750289916992188,100]
[105,97.053092956542969,100]
[105.5,97.66778564453125,100]
[106,99.915542602539063,100]
[106.5,102.92288208007813,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]
[null,null,100]