{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Info","PdM_DigitalTwin","Simulate"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":78,"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_DigitalTwin","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,6,4,9]]}
["Quantity","Value","Formula/Comment"]
["MTTF",{"$f":"L/mu","v":100},"Mean time to failure without maintenance",null,null,null,"Standardverdier"]
["m",1,"Drift parameter"]
["s",2,"Infinitesimal standard deviation, volatility"]
["L",100,"Failure limit"]
["cR",1000,"Cost of renewal"]
["cF",7000,"Cost of failure"]
["cU",2000,"Downtime cost per unit time"]
["TL",4,"Lead time"]
["mL",81,"Maintenance limit, i.e., our decision variable"]
["alpha_m",{"$f":"(L-m_L)/mu","v":19},{"$f":"_xlfn.FORMULATEXT(B11)","v":"=(L-m_L)/mu"}]
["beta_m",{"$f":"(L-m_L)^2/sigma^2","v":90.25},"=(L-m_L)^2/sigma^2"]
["F(T_L)",{"$f":"cdfIG(T_L,alpha_m,beta_m)","v":1.4823651872575283E-4},"=cdfIG(T_L,alpha_m,beta_m)"]
["MTBR",{"$f":"m_L/mu+T_L","v":85},"=m_L/mu+T_L"]
["C(mL)",{"$f":"(c_R+c_F*F_T_L+c_U*numint(\"iCost\",0,T_L,alpha_m,beta_m,T_L))/MTBR","v":11.777968866483528},{"$f":"_xlfn.FORMULATEXT(B15)","v":"=(c_R+c_F*F_T_L+c_U*numint(\"iCost\",0,T_L,alpha_m,beta_m,T_L))/MTBR"}]
[80,11.909572316762066,{"$f":"IF(B16=minCost,\"<--\",\"\")","v":""}]
[{"$f":"A16+1","v":81},11.777968866483528,""]
[{"$f":"A17+1","v":82},11.662387555779153,""]
[83,11.578812844644505,""]
[84,11.559352315750651,"<--"]
[85,11.663725050270893,""]
[86,11.994627376811373,""]
[87,12.714819593743963,""]
[88,14.060833491384983,""]
[89,16.345454480058404,""]
[90,19.940349253568243,""]
[{"$f":"A26+1","v":91},25.23347939315595,""]
["Minimum cost:",{"$f":"MIN(B16:B27)","v":11.559352315750651}]

{"sheet":"Simulate","index":2,"n_rows":365,"n_cols":9,"rows_kept":365,"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.56293624639511108,100]
[1,4.2255211621522903E-2,100]
[1.5,-8.4218993782997131E-2,100]
[2,-0.64292573928833008,100]
[2.5,-0.15053048729896545,100]
[3,2.0220425128936768,100]
[3.5,4.0461511611938477,100]
[4,4.0434918403625488,100]
[4.5,3.1299762725830078,100]
[5,0.43226715922355652,100]
[5.5,-2.3156561851501465,100]
[6,-1.5854036808013916,100]
[6.5,-2.194753885269165,100]
[7,-1.2533490657806396,100]
[7.5,-0.18645012378692627,100]
[8,-0.20402774214744568,100]
[8.5,0.99878084659576416,100]
[9,1.6888082027435303,100]
[9.5,1.8057849407196045,100]
[10,1.7618800401687622,100]
[10.5,-1.8819702863693237,100]
[11,-3.8704662322998047,100]
[11.5,-1.8260211944580078,100]
[12,-0.73401153087615967,100]
[12.5,-0.78016871213912964,100]
[13,0.47195792198181152,100]
[13.5,4.0012588500976563,100]
[14,4.741671085357666,100]
[14.5,6.9549126625061035,100]
[15,8.183349609375,100]
[15.5,7.7253847122192383,100]
[16,8.2223453521728516,100]
[16.5,8.3933172225952148,100]
[17,9.196385383605957,100]
[17.5,11.600253105163574,100]
[18,11.690179824829102,100]
[18.5,8.6403360366821289,100]
[19,9.7053127288818359,100]
[19.5,14.049369812011719,100]
[20,14.699102401733398,100]
[20.5,15.972554206848145,100]
[21,15.74626636505127,100]
[21.5,16.747163772583008,100]
[22,19.67329216003418,100]
[22.5,20.307991027832031,100]
[23,19.828571319580078,100]
[23.5,20.981681823730469,100]
[24,21.650749206542969,100]
[24.5,22.01024055480957,100]
[25,22.704618453979492,100]
[25.5,22.204128265380859,100]
[26,22.6300048828125,100]
[26.5,24.497001647949219,100]
[27,26.443313598632813,100]
[27.5,29.949396133422852,100]
[28,28.101900100708008,100]
[28.5,29.711700439453125,100]
[29,28.841842651367188,100]
[29.5,29.816293716430664,100]
[30,32.132896423339844,100]
[30.5,32.04254150390625,100]
[31,31.121896743774414,100]
[31.5,31.682022094726563,100]
[32,31.294599533081055,100]
[32.5,28.845155715942383,100]
[33,31.836084365844727,100]
[33.5,30.465841293334961,100]
[34,30.943761825561523,100]
[34.5,32.381988525390625,100]
[35,33.656600952148438,100]
[35.5,35.493965148925781,100]
[36,35.024105072021484,100]
[36.5,34.767730712890625,100]
[37,35.926376342773438,100]
[37.5,32.548614501953125,100]
[38,32.686607360839844,100]
[38.5,34.441719055175781,100]
[39,35.869976043701172,100]
[39.5,38.273914337158203,100]
[40,38.119735717773438,100]
[40.5,39.431861877441406,100]
[41,40.567592620849609,100]
[41.5,42.347377777099609,100]
[42,43.589862823486328,100]
[42.5,43.820480346679688,100]
[43,42.711601257324219,100]
[43.5,46.216403961181641,100]
[44,48.280975341796875,100]
[44.5,49.627948760986328,100]
[45,50.232028961181641,100]
[45.5,50.893203735351563,100]
[46,51.185401916503906,100]
[46.5,52.32916259765625,100]
[47,51.283378601074219,100]
[47.5,48.872222900390625,100]
[48,49.303028106689453,100]
[48.5,50.955669403076172,100]
[49,50.839275360107422,100]
[49.5,52.017799377441406,100]
[50,54.140613555908203,100]
[50.5,53.256790161132813,100]
[51,55.418613433837891,100]
[51.5,56.913181304931641,100]
[52,57.001514434814453,100]
[52.5,58.236526489257813,100]
[53,57.416378021240234,100]
[53.5,58.240715026855469,100]
[54,56.8782958984375,100]
[54.5,56.100418090820313,100]
[55,54.47662353515625,100]
[55.5,54.088226318359375,100]
[56,55.027553558349609,100]
[56.5,55.841461181640625,100]
[57,54.899551391601563,100]
[57.5,54.443996429443359,100]
[58,55.005664825439453,100]
[58.5,55.250926971435547,100]
[59,57.037448883056641,100]
[59.5,57.997940063476563,100]
[60,58.8721923828125,100]
[60.5,61.157417297363281,100]
[61,63.586223602294922,100]
[61.5,63.153205871582031,100]
[62,65.653396606445313,100]
[62.5,67.554519653320313,100]
[63,66.856124877929688,100]
[63.5,66.648612976074219,100]
[64,67.231155395507813,100]
[64.5,66.360519409179688,100]
[65,67.166542053222656,100]
[65.5,69.080924987792969,100]
[66,69.09912109375,100]
[66.5,69.059829711914063,100]
[67,71.687110900878906,100]
[67.5,74.574050903320313,100]
[68,74.880287170410156,100]
[68.5,72.314300537109375,100]
[69,73.878883361816406,100]
[69.5,75.010490417480469,100]
[70,76.363250732421875,100]
[70.5,75.11859130859375,100]
[71,75.754768371582031,100]
[71.5,72.889678955078125,100]
[72,71.109268188476563,100]
[72.5,71.608734130859375,100]
[73,72.07281494140625,100]
[73.5,70.71502685546875,100]
[74,69.947059631347656,100]
[74.5,68.615859985351563,100]
[75,67.011795043945313,100]
[75.5,68.021614074707031,100]
[76,68.418960571289063,100]
[76.5,69.514785766601563,100]
[77,68.598915100097656,100]
[77.5,68.942855834960938,100]
[78,69.41845703125,100]
[78.5,71.153915405273438,100]
[79,70.935218811035156,100]
[79.5,72.108589172363281,100]
[80,72.010971069335938,100]
[80.5,71.205902099609375,100]
[81,73.015068054199219,100]
[81.5,74.675048828125,100]
[82,74.506866455078125,100]
[82.5,75.83416748046875,100]
[83,73.615211486816406,100]
[83.5,74.802597045898438,100]
[84,74.425552368164063,100]
[84.5,77.157363891601563,100]
[85,77.278244018554688,100]
[85.5,80.257942199707031,100]
[86,82.488639831542969,100]
[86.5,81.464935302734375,100]
[87,83.971969604492188,100]
[87.5,83.147354125976563,100]
[88,85.096321105957031,100]
[88.5,85.967308044433594,100]
[89,85.836936950683594,100]
[89.5,87.937934875488281,100]
[90,85.190956115722656,100]
[90.5,86.689605712890625,100]
[91,87.1463623046875,100]
[91.5,86.298072814941406,100]
[92,86.030441284179688,100]
[92.5,85.514259338378906,100]
[93,85.28875732421875,100]
[93.5,85.752815246582031,100]
[94,85.571052551269531,100]
[94.5,84.671821594238281,100]
[95,85.969268798828125,100]
[95.5,89.378509521484375,100]
[96,88.277626037597656,100]
[96.5,89.741683959960938,100]
[97,89.613800048828125,100]
[97.5,88.468826293945313,100]
[98,91.13037109375,100]
[98.5,90.538665771484375,100]
[99,90.862358093261719,100]
[99.5,94.329872131347656,100]
[100,92.242286682128906,100]
[100.5,95.080802917480469,100]
[101,94.842910766601563,100]
[101.5,93.063629150390625,100]
[102,92.676361083984375,100]
[102.5,90.738739013671875,100]
[103,91.770652770996094,100]
[103.5,94.314903259277344,100]
[104,96.122169494628906,100]
[104.5,97.150947570800781,100]
[105,98.476066589355469,100]
[105.5,98.016990661621094,100]
[106,99.769233703613281,100]
[106.5,101.11997222900391,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]
[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]
[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]
[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]