{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Solver","Analytical","Plot"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":0,"defined_names":43,"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":"Solver","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Parameter","Value"]
["C_PM",7000]
["C_CM",35000]
["alpha",3]
["MTTF",175]
["tau",90.962673882930616]
["lambdaE",{"$f":"(_xlfn.GAMMA(1+1/alpha)/MTTF)^alpha*tau^(alpha-1)","v":1.0993520079138704E-3},{"$f":"_xlfn.FORMULATEXT(B7)","v":"=(GAMMA(1+1/alpha)/MTTF)^alpha*tau^(alpha-1)"}]
["C(tau)",{"$f":"C_PM/tau+lambdaE*C_CM","v":115.43196223275109},{"$f":"_xlfn.FORMULATEXT(B8)","v":"=C_PM/tau+lambdaE*C_CM"}]
[]
[]
["Analytical",{"$f":"MTTF/_xlfn.GAMMA(1+1/alpha)*(C_PM/((alpha-1)*C_CM))^(1/alpha)","v":90.962674435251643},{"$f":"_xlfn.FORMULATEXT(B11)","v":"=MTTF/GAMMA(1+1/alpha)*(C_PM/((alpha-1)*C_CM))^(1/alpha)"}]
[]
["Problemløseren/Solveren må innstalleresl. Dersom denne er innstallert, klikk på \"Data\" fra topp-menyen"]
[]
[]
["Klikk på fanen \"Plot\" for å se oppsett for å løse grafisk"]

{"sheet":"Analytical","index":1,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Kostnadsligning"]
[]
["C(t) =CPM/t + lE (t) ´ CCM"]
[]
["= 7000/t + 35000´0.71 t2/ (175000)3"]
[]
[]
["Deriver C(t) mht t, og sett C’(t) = 0"]
["C’(t) = -CPM/t2 + lE ’ (t) ´ CCM"]
[]
["= -7000/t2 + 35000 ´ 0.71 ´ 2 ´t/ (175000)3 = 0"]
["Þ 7000 = 35000 ´ 0.71 ´ 2 ´t 3/ (175000)3 "]
["Þt 3 = (1750003 ´ 7000 )/( 35000´0.71 ´2)"]
["Þt = [(1750003 ´ 7000 )/( 35000´0.71 ´2)]1/3 = 175000 [7000 /( 35000´0.71 ´2)]1/3 = 91051"]

{"sheet":"Plot","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Tau","PM-Cost","Failure-Cost","Total-Cost"]
[{"$f":"70","v":70},{"$f":"C_PM/A2","v":100},{"$f":"(EXP(GAMMALN(1+1/alpha))/MTTF)^alpha*A2^(alpha-1)*C_CM","v":22.786334166039339},{"$f":"B2+C2","v":122.78633416603934}]
[{"$f":"A2+5","v":75},93.333333333333329,26.157781568157407,{"$f":"B3+C3","v":119.49111490149073}]
[{"$f":"A3+5","v":80},87.5,29.761742584214652,117.26174258421466]
[85,82.352941176470594,33.598217214211068,115.95115839068166]
[90,77.777777777777771,37.667205458146668,115.44498323592444]
[95,73.684210526315795,41.968707316021437,115.65291784233723]
[100,70,46.502722787835395,116.5027227878354]
[105,66.666666666666671,51.269251873588516,117.93591854025519]
[110,63.636363636363633,56.268294573280826,119.90465820964445]
[115,60.869565217391305,61.499850886912306,122.36941610430361]
[120,58.333333333333336,66.963920814482961,{"$f":"B12+C12","v":125.29725414781629}]
[null,null,null,{"$f":"MIN(D2:D12)","v":115.44498323592444}]
[]
[]
[]
["Klikk på fanen \"Solver\" for å se oppsett for å løse numerisk"]