{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Solver","Plot"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":0,"defined_names":45,"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":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Parameter","Value"]
["C_PM",7000]
["C_CM",35000]
["C_EP",{"$f":"0.1*5000","v":500}]
["C_ES",{"$f":"0.005*0.2*25000000","v":25000}]
["alpha",3]
["MTTF",175000]
["tau",75793.874803160157]
["lambdaE",{"$f":"(_xlfn.GAMMA(1+1/alpha)/MTTF)^alpha*tau^(alpha-1)","v":7.6327064117845902E-7},{"$f":"_xlfn.FORMULATEXT(B9)","v":"=(GAMMA(1+1/alpha)/MTTF)^alpha*tau^(alpha-1)"}]
["C(tau)",{"$f":"C_PM/tau+lambdaE*(C_CM+C_EP+C_ES)","v":0.1385336217746172},{"$f":"_xlfn.FORMULATEXT(B10)","v":"=C_PM/tau+lambdaE*(C_CM+C_EP+C_ES)"}]
[]
[]
["Analytical",{"$f":"MTTF/_xlfn.GAMMA(1+1/alpha)*(C_PM/((alpha-1)*(C_CM+C_EP+C_ES)))^(1/alpha)","v":75793.874912782077},{"$f":"_xlfn.FORMULATEXT(B13)","v":"=MTTF/GAMMA(1+1/alpha)*(C_PM/((alpha-1)*(C_CM+C_EP+C_ES)))^(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":"Plot","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Tau","PM-Cost","Repair-Cost","Leasing-Cost","Safety-Cost","Total-Cost"]
[{"$f":"60000","v":60000},{"$f":"C_PM/A2","v":0.11666666666666667},{"$f":"(EXP(GAMMALN(1+1/alpha))/MTTF)^alpha*A2^(alpha-1)*C_CM","v":1.6740980203620737E-2},{"$f":"(EXP(GAMMALN(1+1/alpha))/MTTF)^alpha*A2^(alpha-1)*C_EP","v":2.3915686005172482E-4},{"$f":"(EXP(GAMMALN(1+1/alpha))/MTTF)^alpha*A2^(alpha-1)*C_ES","v":1.1957843002586241E-2},{"$f":"SUM(B2:E2)","v":0.14560464673292536}]
[{"$f":"A2+5000","v":65000},0.1076923076923077,1.964740037786045E-2,2.8067714825514927E-4,1.4033857412757464E-2,{"$f":"SUM(B3:E3)","v":0.14165424263118076}]
[{"$f":"A3+5000","v":70000},0.1,2.2786334166039337E-2,3.2551905951484767E-4,1.6275952975742386E-2,0.13938780620129659]
[75000,9.3333333333333338E-2,2.6157781568157405E-2,3.7368259383082009E-4,1.8684129691541002E-2,0.13854892718686257]
[80000,8.7499999999999994E-2,2.9761742584214646E-2,4.2516775120306639E-4,2.125838756015332E-2,0.13894529789557103]
[85000,8.2352941176470587E-2,3.3598217214211065E-2,4.7997453163158661E-4,2.3998726581579331E-2,0.14042985950389256]
[90000,7.7777777777777779E-2,3.7667205458146662E-2,5.3810293511638086E-4,2.6905146755819044E-2,0.14288823292685987]
[95000,7.3684210526315783E-2,4.1968707316021432E-2,5.9955296165744903E-4,2.9977648082872455E-2,0.14623011888686713]
[100000,7.0000000000000007E-2,4.6502722787835384E-2,6.6432461125479113E-4,3.3216230562739556E-2,0.15038327796182974]
[105000,6.6666666666666666E-2,5.1269251873588509E-2,7.3241788390840726E-4,3.6620894195420368E-2,0.15528923061958394]
[110000,6.363636363636363E-2,5.6268294573280815E-2,8.0383277961829731E-4,4.0191638980914865E-2,0.16090012997017761]
[null,null,null,null,null,{"$f":"MIN(F2:F12)","v":0.13854892718686257}]
[]
[]
[]
["Klikk på fanen \"Solver\" for å se oppsett for å løse numerisk"]