{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Intro","Examples"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Intro","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["<Alt> + F11 to open VBA editor"]
[]
["<fn> + <alt> + F11 on Mac"]
[]
[]
["Modules:"]
["CallBackLib","Library functions for implementation of the CallBack functionality"]
["numLib","Simple library of numerical routines"]
["statLib","Statistical functions"]

{"sheet":"Examples","index":1,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[17,2,27,2]]}
["Quantity","Value","Formula","Comment"]
["MTTF",10000,null,"Midlere tid til svikt (uten vedlikehold)"]
["alpha",3,null,"Assumption, higher alpha gives lower standard deviation"]
["t",7500,null,"Alder på komponenten"]
["x",{"$f":"10","v":10},{"$f":"_xlfn.FORMULATEXT(B5)","v":"=10"},"x er varigheten av flyturen"]
["lambda",{"$f":"_xlfn.GAMMA(1+1/alpha)/MTTF","v":8.9297951156924933E-5},{"$f":"_xlfn.FORMULATEXT(B6)","v":"=GAMMA(1+1/alpha)/MTTF"},"Since the Weibull was specified in terms of alpha and MTTF, we need to calculate lambda"]
["Variance",{"$f":"(_xlfn.GAMMA(2/alpha+1)-(_xlfn.GAMMA(1/alpha+1))^2)/(lambda^2)","v":13209336.072631933},"=(GAMMA(2/alpha+1)-(GAMMA(1/alpha+1))^2)/(lambda^2)","Variance"]
["SD",{"$f":"SQRT(variance)","v":3634.4650325229341},"=SQRT(variance)","Standard deviation"]
["R(x)",{"$f":"Rw(x,alpha,lambda)","v":1},"=Rw(x,alpha,lambda)","Sannsynlighet for at ny enhet overlever flyturen uten svikt"]
["RC(x)",{"$f":"1-Rw(x,alpha,lambda)","v":0},"=1-Rw(x,alpha,lambda)","Sannsynlighet for at ny enhet IKKE overlever flyturen uten svikt"]
["R(t)",{"$f":"Rw(t,alpha,lambda)","v":0.74051767587661743},"=Rw(t,alpha,lambda)","Sannsynlighet for at vi ikke har hatt svikt de første  t timene, dvs før flyturen"]
["MRL(t)",{"$f":"MRLw(t,alpha,MTTF)","v":4075.684814453125},"=MRLw(t,alpha,MTTF)","Forventet tid til svikt vra nå av, gitt at alder nå er t timer"]
["E(T|t)",{"$f":"t+MRL","v":11575.684814453125},"=t+MRL","Forventet levetid for en enhet som har overlevd  t timer"]
["R(x|t)",{"$f":"Rw(x+t,alpha,lambda)/_xlfn.SINGLE(Rw(t,alpha,lambda))","v":0.99879747179310718},"=Rw(x+t,alpha,lambda)/@Rw(t,alpha,lambda)","Sannsynlighet for at vi overlever nye x timer gitt at vi har overlevd t timer"]
["RC(x|t)",{"$f":"1-Rw(x+t,alpha,lambda)/Rw(t,alpha,lambda)","v":1.2025282068928167E-3},"=1-@Rw(x+t,alpha,lambda)/@Rw(t,alpha,lambda)","Sannsynlighet for at vi IKKE overlever nye x timer gitt at vi har overlevd t timer"]
["R(1|t)",{"$f":"Rw(1+t,alpha,lambda)/Rw(t,alpha,lambda)","v":0.99987982766981987},"=@Rw(1+t,alpha,lambda)/@Rw(t,alpha,lambda)","Sannsynlighet for at vi overlever en time gitt at vi har overlevd t timer"]
["z(t)Dt",{"$f":"alpha*lambda^alpha*t^(alpha-1)","v":1.2016230907872312E-4},"=alpha*lambda^alpha*t^(alpha-1)","Sannsynlighet for svikt neste time gitt at vi har overlevd t timer (Dt=1)"]
[1E-4,2.1362188280661892E-20,"<-- Feilrate, dvs forventet antall svikt per time på \"siste tur\" dersom man bytter ut enheten ved verdien gitt i kolonne A"]
[{"$f":"1000+A18","v":1000.0001},2.136219255309976E-6]
[{"$f":"1000+A19","v":2000.0001},8.5448761667523078E-6,null,"2.1a) Sett alpha = 1 og les av R(x)","=",0.99900048971176103]
[3000.0001000000002,1.9225970734327021E-5,null,"2.1b) Sett alpha = 1, t = 3000 og les av R(x|t)","=",0.99900048971176147]
[4000.0001000000002,3.4179502958034114E-5,null,"2.1c) Sett alpha = 1, t = 3000 og les av RC(x|t)","=",1E-3]
[5000.0001000000002,5.3405472837873579E-5]
[6000.0001000000002,7.6903880373845417E-5,null,"2.2a) Sett alpha = 3 og les av R(x)","=",1]
[7000.0001000000002,1.0467472556594964E-4,null,"2.2b) Sett alpha = 3, t = 3000 og les av R(x|t)","=",0.99980000000000002]
[8000.0001000000002,1.3671800841418626E-4,null,"2.2c) Sett alpha = 3, t = 3000 og les av RC(x|t)","=",2.0000000000000001E-4]
[9000.0001000000011,1.7303372891855524E-4]
[10000.000100000001,2.1362188707905661E-4,null,"2.3a) Sett alpha = 3, t = 7500 og les av RC(x|t)","=",1.1999999999999999E-3]
[null,null,null,"2.3b) Les av RC(x)","=",{"$f":"0%","v":0}]
["C = Komplementær, dvs 1-R i denne sammenhengen"]