{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","InputSheet","Verify"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":2,"defined_names":102,"comments":2,"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":"Introduction","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Program:","MarkovGeneral.xlsm"]
[null,"Nedlasting:","https://jvatn.folk.ntnu.no/eLearning/commonFiles/MarkovGeneral.xlsm"]
[null,"Utvikler:","Jørn Vatn"]
[null,"Kontakt:","jorn.vatn@ntnu.no"]
[null,"Sist oppdatert:","2026-03-02"]
[null,"Rettigheter:","Programmet kan benyttes i egen virksomhet"]
[null,"Begrensininger:","Det er ikke tilllat å bruke programmet i salgsøyemed. Det er heller ikke tillat å kopiere innebygget funksjoner for å bruke disse i andre applikasjoner."]
[null,"Ansvar:","Utvikler og NTNU fraskriver seg alt ansvar ved eventuelle feil og mangler i programmet"]
[null,"Primærbruk:","Progrmmet er utviklet for bruk i emnet PK6018-Industriell sikkerhet og pålitelighet"]
[]
[null,"Merknad 1:","Denne excel-filea har innebygget kode, dvs. at denne fila kan utføre spesielle beregninger som ikke finnes i «blanke» Excel-filer."]
[null,null,"Det er alltid en risiko forbundet med Excel-filer som har innebygget kode eller makroer. "]
[null,null,"En fil som har innebygget kode og/eller makroer betegnes i Excel som en makrofil. Slike filer har etternavn .xlsm"]
[null,null,"For å bruke denne fila anbefales at du lagrer den på PC eller Mac på et eget klarert område. Se følgende lenke for hvordan du kan opprette et slikt klarert område (gjelder PC):"]
[null,null,"Legge til, fjerne eller endre en klarert plassering i Microsoft Office - Støtte for Microsoft"]
[null,null,"Du kan f.eks. lage en mappe under \"Dokumenter\" som heter NTNU hvor du legger filene du bruker. I \"klareringssenteret\" sier du at dette er et område du stoler på."]
[]
[null,"Merknad 2:","Dersom du har en jobb-PC kan det hende at firmaet du jobber i har svært strenge regler for å laste ned Excel-filer. "]
[null,null,"Dersom du ikke får lastet ned og kjørt makroene i denne fila, anbefales at du kontakter dataansvarlig i firmaet du arbeider i."]

{"sheet":"InputSheet","index":1,"n_rows":41,"n_cols":19,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Parameters","Value","Comment",null,null,null,"A-Matrix==>",null,null,"To -->"]
["nDim",4,"Dim. of problem=r+1 ",null,"ni","Pi(t)","Pi",null,null,0,1,2,3,4,5,6,7,8,9]
["MaxTime",50,"For time dep. solut.",null,5.8049334938914399E-7,5.0929697863466572E-6,5.8049336075782776E-6,"From",0,null,{"$f":"mu","v":0.1},0,0]
["Initial state",3,"Initial state",null,5.8798676036531106E-5,5.5784778669476509E-4,5.8216508477926254E-4,"¯",1,{"$f":"lambda","v":1E-3},null,{"$f":"mu","v":0.1},0]
["State2Follow",0,"State to plot",null,2.9691271483898163E-3,2.8896545991301537E-2,2.9109090566635132E-2,null,2,0,{"$f":"2*lambda","v":2E-3},null,{"$f":"mu","v":0.1}]
["lambda",1E-3,"Failure rate",null,2.9109087772667408E-3,0.97052651643753052,0.97030293941497803,null,3,0,0,{"$f":"3*lambda","v":3.0000000000000001E-3}]
["mu",0.1,"Repair rate",null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,9]
[]
[null,null,null,null,null,null,"t","P0(t)"]
[null,null,null,null,null,null,0,0]
["Open VBA Module:",null,null,null,null,null,2,6.5975807039819756E-9]
["Windows PC",null,"Press <Alt> + F11 ",null,null,null,4,4.6495649996813881E-8]
["Mac",null,"Press <fn> + <alt> + F11 ",null,null,null,6,1.3628397255160962E-7]
[null,null,null,null,null,null,8,2.7995736218144884E-7]
[null,null,null,null,null,null,10,4.7400166636180074E-7]
["Modules:",null,null,null,null,null,12,7.1083900365920272E-7]
["mLib","Library of matrix functions",null,null,null,null,14,9.8110228918812936E-7]
["MarkovLib","Utility functions, Markov",null,null,null,null,16,1.2750847417919431E-6]
["WSlib","Utility functions, Worksheet R/W",null,null,null,null,18,1.583613652655913E-6]
["ButFunctions","Functions \"behind\" the buttons",null,null,null,null,20,1.8985340375365922E-6]
[null,null,null,null,null,null,22,2.2129279386717826E-6]
[null,null,null,null,null,null,24,2.5211681986547774E-6]
[null,null,null,null,null,null,26,2.8188633223180659E-6]
[null,null,null,null,null,null,28,3.1027498152980115E-6]
[null,null,null,null,null,null,30,3.3705484838719713E-6]
[null,null,null,null,null,null,32,3.6208152778272051E-6]
[null,null,null,null,null,null,34,3.8527941796928644E-6]
[null,null,null,null,null,null,36,4.0662816900294274E-6]
[null,null,null,null,null,null,38,4.2615070015017409E-6]
[null,null,null,null,null,null,40,4.4390226321411319E-6]
[null,null,null,null,null,null,42,4.5996143853699323E-6]
[null,null,null,null,null,null,44,4.7442322284041438E-6]
[null,null,null,null,null,null,46,4.8739266276243143E-6]
[null,null,null,null,null,null,48,4.9898008001036942E-6]
[null,null,null,null,null,null,50,5.0929697863466572E-6]
[null,null,null,null,null,null,"Average",{"$f":"AVERAGE(H15:H40)","v":2.5369127817108905E-6}]

{"sheet":"Verify","index":2,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,"To -->"]
[null,null,0,1,2,3,4,5,6,7,8,9]
["From",0,{"$f":"ShowFormula(InputSheet!J3)","v":""},{"$f":"ShowFormula(InputSheet!K3)","v":"=mu"},{"$f":"ShowFormula(InputSheet!L3)","v":"0"},{"$f":"ShowFormula(InputSheet!M3)","v":"0"},{"$f":"ShowFormula(InputSheet!N3)","v":""},{"$f":"ShowFormula(InputSheet!O3)","v":""},{"$f":"ShowFormula(InputSheet!P3)","v":""},{"$f":"ShowFormula(InputSheet!Q3)","v":""},{"$f":"ShowFormula(InputSheet!R3)","v":""},{"$f":"ShowFormula(InputSheet!S3)","v":""}]
["¯",1,{"$f":"ShowFormula(InputSheet!J4)","v":"=lambda"},{"$f":"ShowFormula(InputSheet!K4)","v":""},{"$f":"ShowFormula(InputSheet!L4)","v":"=mu"},{"$f":"ShowFormula(InputSheet!M4)","v":"0"},{"$f":"ShowFormula(InputSheet!N4)","v":""},{"$f":"ShowFormula(InputSheet!O4)","v":""},{"$f":"ShowFormula(InputSheet!P4)","v":""},{"$f":"ShowFormula(InputSheet!Q4)","v":""},{"$f":"ShowFormula(InputSheet!R4)","v":""},{"$f":"ShowFormula(InputSheet!S4)","v":""}]
[null,2,{"$f":"ShowFormula(InputSheet!J5)","v":"0"},{"$f":"ShowFormula(InputSheet!K5)","v":"=2*lambda"},{"$f":"ShowFormula(InputSheet!L5)","v":""},{"$f":"ShowFormula(InputSheet!M5)","v":"=mu"},{"$f":"ShowFormula(InputSheet!N5)","v":""},{"$f":"ShowFormula(InputSheet!O5)","v":""},{"$f":"ShowFormula(InputSheet!P5)","v":""},{"$f":"ShowFormula(InputSheet!Q5)","v":""},{"$f":"ShowFormula(InputSheet!R5)","v":""},{"$f":"ShowFormula(InputSheet!S5)","v":""}]
[null,3,{"$f":"ShowFormula(InputSheet!J6)","v":"0"},{"$f":"ShowFormula(InputSheet!K6)","v":"0"},{"$f":"ShowFormula(InputSheet!L6)","v":"=3*lambda"},{"$f":"ShowFormula(InputSheet!M6)","v":""},{"$f":"ShowFormula(InputSheet!N6)","v":""},{"$f":"ShowFormula(InputSheet!O6)","v":""},{"$f":"ShowFormula(InputSheet!P6)","v":""},{"$f":"ShowFormula(InputSheet!Q6)","v":""},{"$f":"ShowFormula(InputSheet!R6)","v":""},{"$f":"ShowFormula(InputSheet!S6)","v":""}]
[null,4,{"$f":"ShowFormula(InputSheet!J7)","v":""},{"$f":"ShowFormula(InputSheet!K7)","v":""},{"$f":"ShowFormula(InputSheet!L7)","v":""},{"$f":"ShowFormula(InputSheet!M7)","v":""},{"$f":"ShowFormula(InputSheet!N7)","v":""},{"$f":"ShowFormula(InputSheet!O7)","v":""},{"$f":"ShowFormula(InputSheet!P7)","v":""},{"$f":"ShowFormula(InputSheet!Q7)","v":""},{"$f":"ShowFormula(InputSheet!R7)","v":""},{"$f":"ShowFormula(InputSheet!S7)","v":""}]
[null,5,{"$f":"ShowFormula(InputSheet!J8)","v":""},{"$f":"ShowFormula(InputSheet!K8)","v":""},{"$f":"ShowFormula(InputSheet!L8)","v":""},{"$f":"ShowFormula(InputSheet!M8)","v":""},{"$f":"ShowFormula(InputSheet!N8)","v":""},{"$f":"ShowFormula(InputSheet!O8)","v":""},{"$f":"ShowFormula(InputSheet!P8)","v":""},{"$f":"ShowFormula(InputSheet!Q8)","v":""},{"$f":"ShowFormula(InputSheet!R8)","v":""},{"$f":"ShowFormula(InputSheet!S8)","v":""}]
[null,6,{"$f":"ShowFormula(InputSheet!J9)","v":""},{"$f":"ShowFormula(InputSheet!K9)","v":""},{"$f":"ShowFormula(InputSheet!L9)","v":""},{"$f":"ShowFormula(InputSheet!M9)","v":""},{"$f":"ShowFormula(InputSheet!N9)","v":""},{"$f":"ShowFormula(InputSheet!O9)","v":""},{"$f":"ShowFormula(InputSheet!P9)","v":""},{"$f":"ShowFormula(InputSheet!Q9)","v":""},{"$f":"ShowFormula(InputSheet!R9)","v":""},{"$f":"ShowFormula(InputSheet!S9)","v":""}]
[null,7,{"$f":"ShowFormula(InputSheet!J10)","v":""},{"$f":"ShowFormula(InputSheet!K10)","v":""},{"$f":"ShowFormula(InputSheet!L10)","v":""},{"$f":"ShowFormula(InputSheet!M10)","v":""},{"$f":"ShowFormula(InputSheet!N10)","v":""},{"$f":"ShowFormula(InputSheet!O10)","v":""},{"$f":"ShowFormula(InputSheet!P10)","v":""},{"$f":"ShowFormula(InputSheet!Q10)","v":""},{"$f":"ShowFormula(InputSheet!R10)","v":""},{"$f":"ShowFormula(InputSheet!S10)","v":""}]
[null,8,{"$f":"ShowFormula(InputSheet!J11)","v":""},{"$f":"ShowFormula(InputSheet!K11)","v":""},{"$f":"ShowFormula(InputSheet!L11)","v":""},{"$f":"ShowFormula(InputSheet!M11)","v":""},{"$f":"ShowFormula(InputSheet!N11)","v":""},{"$f":"ShowFormula(InputSheet!O11)","v":""},{"$f":"ShowFormula(InputSheet!P11)","v":""},{"$f":"ShowFormula(InputSheet!Q11)","v":""},{"$f":"ShowFormula(InputSheet!R11)","v":""},{"$f":"ShowFormula(InputSheet!S11)","v":""}]
[null,9]