{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Front","Input_Scen","Input_Res","Input_Data","Input_Lists","Calc_TransProfile","Calc_TransProb","Calc_Matrix","Output"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":1,"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":"Front","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Modelling Antibiotic Resistance"]
[]
["This workbook has been produced by the Antibiotic Resistance Working Party for the Institute and Faculty of Actuaries and is compliant with TAS 300"]
[]
["The workbook requires macros to be enabled for it to run. Cells have been locked and protected to ensure only inputs are changed, however there is no password if the user needs to explore/change the formulas"]
[]
["Purpose","The purpose of this workbook is to investigate the impact of antibiotic resistance on mortality and morbidity over time. The workbook has been designed to be simple, minimal and flexible so that users can tailor the inputs towards their own investigations, data or georgraphy. This model has been designed to capture at a very high level the interaction of varying resistance over time to both mortality and morbidity, it is not intended to fully capture the intricate dynamics that antibiotic resistance is likely to have or model pandemic type risks."]
["Users","The intended users of this workbook are members of the Institute & Faculty of Actuaries"]
["Data","The model has been pre-populated with patrameters informed by data collected by the working party. The analysis completed on the available data accompanies this model and is available to the user. Further analysis on the limitations and availability of data is considered in detail in the Sessional Research paper on Antibiotic Resistance produced by the working party and published in August 2019"]
["Assumptions","A detailed assessment of the modelling and data assumptions are contaiened within the Sessional Research paper produced by the working party and published in August 2019."]
["Limitations","This model is for illustrative purposes only and users should not rely on the output without fully assessing the model's limited capabilities and ensuring the data input is sufficient for their needs. The Antibiotic Resistance Working Party has made a best endeavour to explore this topic and provide this tool as a useful starting point so that users can consider the application of varying resistance to antibiotics in their own risk analysis. The working party makes no representation as to the accuracy or completeness of the model and it is for the user to ensure the results produced are of sufficient quality for their purposes."]
[]
["Written by:","Ross Hamilton (ARN 9052944)"]
["Checked by:","Sheridan Fitzgibbon (ARN 9033326)"]

{"sheet":"Input_Scen","index":1,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Input Scenario"]
["This worksheet allows the user to input a custom resistance profile and contains the resistance profiles used within the working party study"]
[]
["Instructions"]
["The following cells are inputs -->","Inputs"]
["General inputs are not expected to be updated"]
["User inputs allow different scenarios to be run"]
["Scalar adjustments allow the user to explore varying infection / mortality rates for example to incorporate additional bacteria from available data"]
["Note that the expected number of deaths from the infection is set as proportionate to the infection rate, any mortality scalar input will be compounded with the infection rate scalar"]
["Inputs have not been restricted (except those that require look up lists), users should ensure inputs and outputs are reasonable based on their own expectations"]
[]
["General Inputs",null,null,null,null,null,null,"Input Reference"]
["Starting Year",2017,"--->  Updates the projection period throughout workbook",null,null,null,null,"[Input_Scen_1]"]
["Days in a year",365,"--->  Number of days assumed in a year, would not expect users to update",null,null,null,null,"[Input_Scen_2]"]
["Assume deaths occur X through a year",0.5,"--->  Deaths are assumed to occur half way through a year - would not expect a user to update",null,null,null,null,"[Input_Scen_3]"]
[]
["User inputs to select age group, resistance profile and parameters where insufficient data was available to the working party",null,null,null,null,null,null,"Input Reference"]
["Age Group","1-14 yrs","--->  Defined by data availability",null,null,null,null,"[Input_Scen_4]"]
["Resistance Profile","100% Resistance by 2050","--->  Use pre-populated scenarios or user can define custom resistance profile in \"Input_Res\"",null,null,null,null,"[Input_Scen_5]"]
["Relative mortality rate of resistance against susceptible infection",2.5,"--->  Relative increase in mortality rate of resistant infection compared to susceptible infection",null,null,null,null,"[Input_Scen_6]"]
["Average hospitalised days with susceptible infection",10,"--->  Average number of hospitalised days with susceptible infection until recovery or death",null,null,null,null,"[Input_Scen_7]"]
["Average hospitalised days with resistant infection",12,"--->  Average number of hospitalised days with resistant infection until recovery or death",null,null,null,null,"[Input_Scen_8]"]
[]
["Scalars to adjust infection and mortality rates over time (adjustments are applied cumulatively eg. a 2% scalar input in the next 10 years will give a scalar of 1.02^10 in 10 years' time)",null,null,null,null,null,null,"Input Reference"]
[]
["Year","Infection Rate Scalar","Infection Mortality Rate Scalar"]
[{"$f":"B13","v":2017},0,0,null,null,null,null,"[Input_Scen_9]"]
[{"$f":"A27+1","v":2018},0,0,null,null,null,null,"[Input_Scen_10]"]
[{"$f":"A28+1","v":2019},0,0,null,null,null,null,"[Input_Scen_11]"]
[2020,0,0,null,null,null,null,"[Input_Scen_12]"]
[2021,0,0,null,null,null,null,"[Input_Scen_13]"]
[2022,0,0,null,null,null,null,"[Input_Scen_14]"]
[2023,0,0,null,null,null,null,"[Input_Scen_15]"]
[2024,0,0,null,null,null,null,"[Input_Scen_16]"]
[2025,0,0,null,null,null,null,"[Input_Scen_17]"]
[2026,0,0,null,null,null,null,"[Input_Scen_18]"]
[2027,0,0,null,null,null,null,"[Input_Scen_19]"]
[2028,0,0,null,null,null,null,"[Input_Scen_20]"]
[2029,0,0,null,null,null,null,"[Input_Scen_21]"]
[2030,0,0,null,null,null,null,"[Input_Scen_22]"]
[2031,0,0,null,null,null,null,"[Input_Scen_23]"]
[2032,0,0,null,null,null,null,"[Input_Scen_24]"]
[2033,0,0,null,null,null,null,"[Input_Scen_25]"]
[2034,0,0,null,null,null,null,"[Input_Scen_26]"]
[2035,0,0,null,null,null,null,"[Input_Scen_27]"]
[2036,0,0,null,null,null,null,"[Input_Scen_28]"]
[2037,0,0,null,null,null,null,"[Input_Scen_29]"]
[2038,0,0,null,null,null,null,"[Input_Scen_30]"]
[2039,0,0,null,null,null,null,"[Input_Scen_31]"]
[2040,0,0,null,null,null,null,"[Input_Scen_32]"]
[2041,0,0,null,null,null,null,"[Input_Scen_33]"]
[2042,0,0,null,null,null,null,"[Input_Scen_34]"]
[2043,0,0,null,null,null,null,"[Input_Scen_35]"]
[2044,0,0,null,null,null,null,"[Input_Scen_36]"]
[2045,0,0,null,null,null,null,"[Input_Scen_37]"]
[2046,0,0,null,null,null,null,"[Input_Scen_38]"]
[2047,0,0,null,null,null,null,"[Input_Scen_39]"]
[2048,0,0,null,null,null,null,"[Input_Scen_40]"]
[2049,0,0,null,null,null,null,"[Input_Scen_41]"]
[2050,0,0,null,null,null,null,"[Input_Scen_42]"]

{"sheet":"Input_Res","index":2,"n_rows":47,"n_cols":39,"rows_kept":47,"cut":false,"hidden":false,"merged":[[10,11,10,17],[10,18,10,24],[10,25,10,31],[10,32,10,38],[10,4,10,10]]}
["Input Resistance Profiles"]
["This worksheet allows the user to input a custom resistance profile and contains the resistance profiles used within the working party study"]
["The \"Selected Profile\" is populated based on user inputs on 'Input_Scen' and linked through below. The selected profile is displayed in column B"]
[]
["Key","Input"]
[]
["Scenario",{"$f":"Input_Scen!B18","v":"1-14 yrs"}]
["Age Group",{"$f":"Input_Scen!B19","v":"100% Resistance by 2050"}]
["Lookup Name",{"$f":"B8&\"_\"&B7","v":"100% Resistance by 2050_1-14 yrs"},null,null,"User input resistance profile --->",null,null,null,null,null,null,"Pre-populated resistance profiles by scenario, age group and year --->"]
["Match",{"$f":"MATCH(B9,$E$13:$AM$13,0)","v":30}]
[null,null,null,"Scenario","Custom Profile",null,null,null,null,null,null,"Linear Extrapolation",null,null,null,null,null,null,"+40% increase in resistance by 2050",null,null,null,null,null,null,"+100% increase in resistance by 2050",null,null,null,null,null,null,"100% resistance by 2050"]
[null,null,null,"Age Group","<1 yr","1-14 yrs","15-44 yrs","45-64 yrs","65-74 yrs","75-84 yrs","85+ yrs","<1 yr","1-14 yrs","15-44 yrs","45-64 yrs","65-74 yrs","75-84 yrs","85+ yrs","<1 yr","1-14 yrs","15-44 yrs","45-64 yrs","65-74 yrs","75-84 yrs","85+ yrs","<1 yr","1-14 yrs","15-44 yrs","45-64 yrs","65-74 yrs","75-84 yrs","85+ yrs","<1 yr","1-14 yrs","15-44 yrs","45-64 yrs","65-74 yrs","75-84 yrs","85+ yrs"]
["Year","Selected Profile",null,"Profile Name",{"$f":"E11&\"_\"&E12","v":"Custom Profile_<1 yr"},{"$f":"E11&\"_\"&F12","v":"Custom Profile_1-14 yrs"},{"$f":"E11&\"_\"&G12","v":"Custom Profile_15-44 yrs"},{"$f":"E11&\"_\"&H12","v":"Custom Profile_45-64 yrs"},{"$f":"E11&\"_\"&I12","v":"Custom Profile_65-74 yrs"},{"$f":"E11&\"_\"&J12","v":"Custom Profile_75-84 yrs"},{"$f":"E11&\"_\"&K12","v":"Custom Profile_85+ yrs"},{"$f":"L11&\"_\"&L12","v":"Linear Extrapolation_<1 yr"},{"$f":"L11&\"_\"&M12","v":"Linear Extrapolation_1-14 yrs"},{"$f":"L11&\"_\"&N12","v":"Linear Extrapolation_15-44 yrs"},{"$f":"L11&\"_\"&O12","v":"Linear Extrapolation_45-64 yrs"},{"$f":"L11&\"_\"&P12","v":"Linear Extrapolation_65-74 yrs"},{"$f":"L11&\"_\"&Q12","v":"Linear Extrapolation_75-84 yrs"},{"$f":"L11&\"_\"&R12","v":"Linear Extrapolation_85+ yrs"},{"$f":"S11&\"_\"&S12","v":"+40% increase in resistance by 2050_<1 yr"},{"$f":"S11&\"_\"&T12","v":"+40% increase in resistance by 2050_1-14 yrs"},{"$f":"S11&\"_\"&U12","v":"+40% increase in resistance by 2050_15-44 yrs"},{"$f":"S11&\"_\"&V12","v":"+40% increase in resistance by 2050_45-64 yrs"},{"$f":"S11&\"_\"&W12","v":"+40% increase in resistance by 2050_65-74 yrs"},{"$f":"S11&\"_\"&X12","v":"+40% increase in resistance by 2050_75-84 yrs"},{"$f":"S11&\"_\"&Y12","v":"+40% increase in resistance by 2050_85+ yrs"},{"$f":"Z11&\"_\"&Z12","v":"+100% increase in resistance by 2050_<1 yr"},{"$f":"Z11&\"_\"&AA12","v":"+100% increase in resistance by 2050_1-14 yrs"},{"$f":"Z11&\"_\"&AB12","v":"+100% increase in resistance by 2050_15-44 yrs"},{"$f":"Z11&\"_\"&AC12","v":"+100% increase in resistance by 2050_45-64 yrs"},{"$f":"Z11&\"_\"&AD12","v":"+100% increase in resistance by 2050_65-74 yrs"},{"$f":"Z11&\"_\"&AE12","v":"+100% increase in resistance by 2050_75-84 yrs"},{"$f":"Z11&\"_\"&AF12","v":"+100% increase in resistance by 2050_85+ yrs"},{"$f":"AG11&\"_\"&AG12","v":"100% resistance by 2050_<1 yr"},{"$f":"AG11&\"_\"&AH12","v":"100% resistance by 2050_1-14 yrs"},{"$f":"AG11&\"_\"&AI12","v":"100% resistance by 2050_15-44 yrs"},{"$f":"AG11&\"_\"&AJ12","v":"100% resistance by 2050_45-64 yrs"},{"$f":"AG11&\"_\"&AK12","v":"100% resistance by 2050_65-74 yrs"},{"$f":"AG11&\"_\"&AL12","v":"100% resistance by 2050_75-84 yrs"},{"$f":"AG11&\"_\"&AM12","v":"100% resistance by 2050_85+ yrs"}]
[{"$f":"Input_Scen!B13","v":2017},{"$f":"INDEX($E$14:$AM$47,MATCH(A14,$D$14:$D$47,0),$B$10)","v":11.537465764588235},null,{"$f":"A14","v":2017},null,null,null,null,null,null,null,12.523014002249056,8.7850266778021933,12.35870454805513,12.35870454805513,13.949008311952412,13.949008311952412,13.949008311952412,8.9870589309098037,8.6974221092235293,9.9769625453882345,9.9769625453882345,10.561791036345099,10.561791036345099,10.561791036345099,9.1438099587745096,9.1019533701176467,10.441007314941176,10.441007314941176,10.746008321862746,10.746008321862746,10.746008321862746,11.562483003147058,11.537465764588235,12.802127823588235,12.802127823588235,13.073127174058826,13.073127174058826,13.073127174058826]
[{"$f":"A14+1","v":2018},{"$f":"INDEX($E$14:$AM$47,MATCH(A15,$D$14:$D$47,0),$B$10)","v":14.225810197117648},null,{"$f":"A15","v":2018},null,null,null,null,null,null,null,13.304609290764802,9.0952702297757924,12.901315489881426,12.901315489881426,14.59725494889517,14.59725494889517,14.59725494889517,9.0915596161529404,8.7985549244470587,10.09297373777647,10.09297373777647,10.68460256002353,10.68460256002353,10.68460256002353,9.4050616718823523,9.3547854081764701,10.731035295911765,10.731035295911765,11.053037131058824,11.053037131058824,11.053037131058824,14.242407760627451,14.225810197117648,15.453276313205881,15.453276313205881,15.707274835450983,15.707274835450983,15.707274835450983]
[{"$f":"A15+1","v":2019},16.914154629647058,null,2019,null,null,null,null,null,null,null,14.086204579280547,9.4055137817493915,13.443926431707723,13.443926431707723,15.245501585837928,15.245501585837928,15.245501585837928,9.1960603013960771,8.899687739670588,10.208984930164705,10.208984930164705,10.807414083701961,10.807414083701961,10.807414083701961,9.666313384990195,9.6076174462352935,11.021063276882353,11.021063276882353,11.360065940254902,11.360065940254902,11.360065940254902,16.922332518107844,16.914154629647058,18.10442480282353,18.10442480282353,18.341422496843141,18.341422496843141,18.341422496843141]
[2020,19.60249906217647,null,2020,null,null,null,null,null,null,null,14.867799867796293,9.7157573337229906,13.986537373534247,13.986537373534247,15.893748222780914,15.893748222780914,15.893748222780914,9.3005609866392138,9.0008205548941174,10.324996122552941,10.324996122552941,10.930225607380391,10.930225607380391,10.930225607380391,9.9275650980980377,9.8604494842941168,11.311091257852942,11.311091257852942,11.66709474945098,11.66709474945098,11.66709474945098,19.602257275588236,19.60249906217647,20.755573292441177,20.755573292441177,20.975570158235296,20.975570158235296,20.975570158235296]
[2021,22.290843494705882,null,2021,null,null,null,null,null,null,null,15.649395156312039,10.026000885696703,14.529148315360544,14.529148315360544,16.541994859723673,16.541994859723673,16.541994859723673,9.4050616718823505,9.1019533701176467,10.441007314941176,10.441007314941176,11.053037131058822,11.053037131058822,11.053037131058822,10.18881681120588,10.11328152235294,11.60111923882353,11.60111923882353,11.974123558647058,11.974123558647058,11.974123558647058,22.282182033068629,22.290843494705882,23.406721782058824,23.406721782058824,23.609717819627452,23.609717819627452,23.609717819627452]
[2022,24.979187927235294,null,2022,null,null,null,null,null,null,null,16.430990444827785,10.336244437670302,15.071759257186841,15.071759257186841,17.190241496666658,17.190241496666658,17.190241496666658,9.5095623571254873,9.2030861853411761,10.557018507329412,10.557018507329412,11.175848654737253,11.175848654737253,11.175848654737253,10.450068524313723,10.366113560411764,11.891147219794119,11.891147219794119,12.281152367843136,12.281152367843136,12.281152367843136,24.962106790549022,24.979187927235294,26.057870271676471,26.057870271676471,26.243865481019608,26.243865481019608,26.243865481019608]
[2023,27.667532359764706,null,2023,null,null,null,null,null,null,null,17.212585733343531,10.646487989643902,15.614370199013365,15.614370199013365,17.838488133609417,17.838488133609417,17.838488133609417,9.614063042368624,9.3042190005647054,10.673029699717647,10.673029699717647,11.298660178415684,11.298660178415684,11.298660178415684,10.711320237421566,10.618945598470587,12.181175200764708,12.181175200764708,12.588181177039214,12.588181177039214,12.588181177039214,27.642031548029415,27.667532359764706,28.709018761294118,28.709018761294118,28.878013142411763,28.878013142411763,28.878013142411763]
[2024,30.355876792294119,null,2024,null,null,null,null,null,null,null,17.994181021859276,10.956731541617501,16.156981140839662,16.156981140839662,18.486734770552403,18.486734770552403,18.486734770552403,9.7185637276117607,9.4053518157882348,10.789040892105882,10.789040892105882,11.421471702094115,11.421471702094115,11.421471702094115,10.972571950529408,10.87177763652941,12.471203181735296,12.471203181735296,12.895209986235292,12.895209986235292,12.895209986235292,30.321956305509808,30.355876792294119,31.360167250911765,31.360167250911765,31.512160803803919,31.512160803803919,31.512160803803919]
[2025,33.044221224823531,null,2025,null,null,null,null,null,null,null,18.775776310375022,11.266975093591213,16.699592082665959,16.699592082665959,19.134981407495161,19.134981407495161,19.134981407495161,9.8230644128548974,9.5064846310117641,10.905052084494118,10.905052084494118,11.544283225772546,11.544283225772546,11.544283225772546,11.233823663637251,11.124609674588234,12.761231162705885,12.761231162705885,13.20223879543137,13.20223879543137,13.20223879543137,33.001881062990201,33.044221224823531,34.011315740529412,34.011315740529412,34.146308465196078,34.146308465196078,34.146308465196078]
[2026,35.732565657352943,null,2026,null,null,null,null,null,null,null,19.557371598890995,11.577218645564813,17.242203024492483,17.242203024492483,19.783228044437919,19.783228044437919,19.783228044437919,9.9275650980980341,9.6076174462352935,11.021063276882353,11.021063276882353,11.667094749450976,11.667094749450976,11.667094749450976,11.495075376745094,11.377441712647057,13.051259143676473,13.051259143676473,13.509267604627448,13.509267604627448,13.509267604627448,35.681805820470593,35.732565657352943,36.662464230147059,36.662464230147059,36.780456126588234,36.780456126588234,36.780456126588234]
[2027,38.420910089882355,null,2027,null,null,null,null,null,null,null,20.338966887406741,11.887462197538412,17.784813966318779,17.784813966318779,20.431474681380905,20.431474681380905,20.431474681380905,10.032065783341171,9.7087502614588228,11.137074469270589,11.137074469270589,11.789906273129407,11.789906273129407,11.789906273129407,11.756327089852936,11.63027375070588,13.341287124647062,13.341287124647062,13.816296413823526,13.816296413823526,13.816296413823526,38.361730577950986,38.420910089882355,39.313612719764706,39.313612719764706,39.41460378798039,39.41460378798039,39.41460378798039]
[2028,41.109254522411767,null,2028,null,null,null,null,null,null,null,21.120562175922487,12.197705749512011,18.327424908145076,18.327424908145076,21.079721318323664,21.079721318323664,21.079721318323664,10.136566468584308,9.8098830766823522,11.253085661658824,11.253085661658824,11.912717796807838,11.912717796807838,11.912717796807838,12.017578802960779,11.883105788764704,13.63131510561765,13.63131510561765,14.123325223019604,14.123325223019604,14.123325223019604,41.041655335431379,41.109254522411767,41.964761209382353,41.964761209382353,42.048751449372546,42.048751449372546,42.048751449372546]
[2029,43.797598954941179,null,2029,null,null,null,null,null,null,null,21.902157464438233,12.50794930148561,18.8700358499716,18.8700358499716,21.727967955266649,21.727967955266649,21.727967955266649,10.241067153827444,9.9110158919058815,11.36909685404706,11.36909685404706,12.035529320486269,12.035529320486269,12.035529320486269,12.278830516068622,12.135937826823527,13.921343086588239,13.921343086588239,14.430354032215682,14.430354032215682,14.430354032215682,43.721580092911772,43.797598954941179,44.615909698999999,44.615909698999999,44.682899110764701,44.682899110764701,44.682899110764701]
[2030,46.485943387470591,null,2030,null,null,null,null,null,null,null,22.683752752953978,12.818192853459323,19.412646791797897,19.412646791797897,22.376214592209408,22.376214592209408,22.376214592209408,10.345567839070581,10.012148707129411,11.485108046435295,11.485108046435295,12.1583408441647,12.1583408441647,12.1583408441647,12.540082229176464,12.388769864882351,14.211371067558828,14.211371067558828,14.73738284141176,14.73738284141176,14.73738284141176,46.401504850392165,46.485943387470591,47.267058188617646,47.267058188617646,47.317046772156857,47.317046772156857,47.317046772156857]
[2031,49.174287820000004,null,2031,null,null,null,null,null,null,null,23.465348041469724,13.128436405432922,19.955257733624194,19.955257733624194,23.024461229152394,23.024461229152394,23.024461229152394,10.450068524313718,10.11328152235294,11.60111923882353,11.60111923882353,12.281152367843131,12.281152367843131,12.281152367843131,12.801333942284307,12.641601902941174,14.501399048529416,14.501399048529416,15.044411650607838,15.044411650607838,15.044411650607838,49.081429607872558,49.174287820000004,49.918206678235293,49.918206678235293,49.951194433549013,49.951194433549013,49.951194433549013]
[2032,51.862632252529416,null,2032,null,null,null,null,null,null,null,24.24694332998547,13.438679957406521,20.497868675450718,20.497868675450718,23.672707866095152,23.672707866095152,23.672707866095152,10.554569209556854,10.21441433757647,11.717130431211766,11.717130431211766,12.403963891521562,12.403963891521562,12.403963891521562,13.06258565539215,12.894433940999997,14.791427029500005,14.791427029500005,15.351440459803916,15.351440459803916,15.351440459803916,51.76135436535295,51.862632252529416,52.56935516785294,52.56935516785294,52.585342094941169,52.585342094941169,52.585342094941169]
[2033,54.550976685058828,null,2033,null,null,null,null,null,null,null,25.028538618501216,13.74892350938012,21.040479617277015,21.040479617277015,24.32095450303791,24.32095450303791,24.32095450303791,10.659069894799991,10.315547152799999,11.833141623600001,11.833141623600001,12.526775415199992,12.526775415199992,12.526775415199992,13.323837368499992,13.147265979058821,15.081455010470593,15.081455010470593,15.658469268999994,15.658469268999994,15.658469268999994,54.441279122833343,54.550976685058828,55.220503657470587,55.220503657470587,55.219489756333324,55.219489756333324,55.219489756333324]
[2034,57.23932111758824,null,2034,null,null,null,null,null,null,null,25.810133907016962,14.059167061353833,21.583090559103312,21.583090559103312,24.969201139980896,24.969201139980896,24.969201139980896,10.763570580043128,10.416679968023528,11.949152815988237,11.949152815988237,12.649586938878423,12.649586938878423,12.649586938878423,13.585089081607835,13.400098017117644,15.371482991441182,15.371482991441182,15.965498078196072,15.965498078196072,15.965498078196072,57.121203880313736,57.23932111758824,57.871652147088234,57.871652147088234,57.85363741772548,57.85363741772548,57.85363741772548]
[2035,59.927665550117652,null,2035,null,null,null,null,null,null,null,26.591729195532707,14.369410613327432,22.125701500929836,22.125701500929836,25.617447776923655,25.617447776923655,25.617447776923655,10.868071265286265,10.517812783247058,12.065164008376472,12.065164008376472,12.772398462556854,12.772398462556854,12.772398462556854,13.846340794715678,13.652930055176467,15.66151097241177,15.66151097241177,16.27252688739215,16.27252688739215,16.27252688739215,59.801128637794129,59.927665550117652,60.522800636705881,60.522800636705881,60.487785079117636,60.487785079117636,60.487785079117636]
[2036,62.616009982647064,null,2036,null,null,null,null,null,null,null,27.373324484048453,14.679654165301031,22.668312442756132,22.668312442756132,26.26569441386664,26.26569441386664,26.26569441386664,10.972571950529401,10.618945598470587,12.181175200764708,12.181175200764708,12.895209986235285,12.895209986235285,12.895209986235285,14.10759250782352,13.905762093235291,15.951538953382359,15.951538953382359,16.57955569658823,16.57955569658823,16.57955569658823,62.481053395274522,62.616009982647064,63.173949126323528,63.173949126323528,63.121932740509791,63.121932740509791,63.121932740509791]
[2037,65.304354415176476,null,2037,null,null,null,null,null,null,null,28.154919772564199,14.98989771727463,23.210923384582429,23.210923384582429,26.913941050809399,26.913941050809399,26.913941050809399,11.077072635772538,10.720078413694116,12.297186393152943,12.297186393152943,13.018021509913716,13.018021509913716,13.018021509913716,14.368844220931363,14.158594131294114,16.241566934352946,16.241566934352946,16.88658450578431,16.88658450578431,16.88658450578431,65.160978152754907,65.304354415176476,65.825097615941175,65.825097615941175,65.756080401901954,65.756080401901954,65.756080401901954]
[2038,67.992698847705881,null,2038,null,null,null,null,null,null,null,28.936515061079945,15.300141269248343,23.753534326408953,23.753534326408953,27.562187687752385,27.562187687752385,27.562187687752385,11.181573321015675,10.821211228917646,12.413197585541178,12.413197585541178,13.140833033592147,13.140833033592147,13.140833033592147,14.630095934039206,14.411426169352938,16.531594915323534,16.531594915323534,17.193613314980389,17.193613314980389,17.193613314980389,67.8409029102353,67.992698847705881,68.476246105558829,68.476246105558829,68.390228063294117,68.390228063294117,68.390228063294117]
[2039,70.681043280235286,null,2039,null,null,null,null,null,null,null,29.71811034959569,15.610384821221942,24.29614526823525,24.29614526823525,28.210434324695143,28.210434324695143,28.210434324695143,11.286074006258811,10.922344044141175,12.529208777929414,12.529208777929414,13.263644557270577,13.263644557270577,13.263644557270577,14.891347647147049,14.664258207411761,16.821622896294123,16.821622896294123,17.500642124176469,17.500642124176469,17.500642124176469,70.520827667715693,70.681043280235286,71.127394595176469,71.127394595176469,71.02437572468628,71.02437572468628,71.02437572468628]
[2040,73.369387712764691,null,2040,null,null,null,null,null,null,null,30.499705638111436,15.920628373195541,24.838756210061547,24.838756210061547,28.858680961638129,28.858680961638129,28.858680961638129,11.390574691501948,11.023476859364704,12.645219970317649,12.645219970317649,13.386456080949008,13.386456080949008,13.386456080949008,15.152599360254891,14.917090245470584,17.111650877264712,17.111650877264712,17.807670933372549,17.807670933372549,17.807670933372549,73.200752425196086,73.369387712764691,73.778543084794109,73.778543084794109,73.658523386078443,73.658523386078443,73.658523386078443]
[2041,76.057732145294096,null,2041,null,null,null,null,null,null,null,31.281300926627182,16.23087192516914,25.381367151888071,25.381367151888071,29.506927598580887,29.506927598580887,29.506927598580887,11.495075376745085,11.124609674588234,12.761231162705885,12.761231162705885,13.509267604627439,13.509267604627439,13.509267604627439,15.413851073362734,15.169922283529408,17.4016788582353,17.4016788582353,18.114699742568629,18.114699742568629,18.114699742568629,75.880677182676479,76.057732145294096,76.429691574411748,76.429691574411748,76.292671047470606,76.292671047470606,76.292671047470606]
[2042,78.746076577823501,null,2042,null,null,null,null,null,null,null,32.062896215142928,16.541115477142853,25.923978093714368,25.923978093714368,30.155174235523646,30.155174235523646,30.155174235523646,11.599576061988222,11.225742489811763,12.87724235509412,12.87724235509412,13.63207912830587,13.63207912830587,13.63207912830587,15.675102786470577,15.422754321588231,17.691706839205889,17.691706839205889,18.421728551764708,18.421728551764708,18.421728551764708,78.560601940156872,78.746076577823501,79.080840064029388,79.080840064029388,78.926818708862768,78.926818708862768,78.926818708862768]
[2043,81.434421010352906,null,2043,null,null,null,null,null,null,null,32.844491503658674,16.851359029116452,26.466589035540665,26.466589035540665,30.803420872466631,30.803420872466631,30.803420872466631,11.704076747231358,11.326875305035292,12.993253547482356,12.993253547482356,13.754890651984301,13.754890651984301,13.754890651984301,15.936354499578419,15.675586359647054,17.981734820176477,17.981734820176477,18.728757360960788,18.728757360960788,18.728757360960788,81.240526697637264,81.434421010352906,81.731988553647028,81.731988553647028,81.560966370254931,81.560966370254931,81.560966370254931]
[2044,84.122765442882312,null,2044,null,null,null,null,null,null,null,33.626086792174419,17.161602581090051,27.009199977367189,27.009199977367189,31.45166750940939,31.45166750940939,31.45166750940939,11.808577432474495,11.428008120258822,13.109264739870591,13.109264739870591,13.877702175662732,13.877702175662732,13.877702175662732,16.197606212686264,15.928418397705878,18.271762801147066,18.271762801147066,19.035786170156868,19.035786170156868,19.035786170156868,83.920451455117657,84.122765442882312,84.383137043264668,84.383137043264668,84.195114031647094,84.195114031647094,84.195114031647094]
[2045,86.811109875411717,null,2045,null,null,null,null,null,null,null,34.407682080690165,17.47184613306365,27.551810919193485,27.551810919193485,32.099914146352376,32.099914146352376,32.099914146352376,11.913078117717632,11.529140935482351,13.225275932258826,13.225275932258826,14.000513699341163,14.000513699341163,14.000513699341163,16.458857925794106,16.181250435764703,18.561790782117654,18.561790782117654,19.342814979352948,19.342814979352948,19.342814979352948,86.60037621259805,86.811109875411717,87.034285532882308,87.034285532882308,86.829261693039257,86.829261693039257,86.829261693039257]
[2046,89.499454307941122,null,2046,null,null,null,null,null,null,null,35.189277369205911,17.782089685037363,28.094421861019782,28.094421861019782,32.748160783295134,32.748160783295134,32.748160783295134,12.017578802960768,11.63027375070588,13.341287124647062,13.341287124647062,14.123325223019593,14.123325223019593,14.123325223019593,16.720109638901949,16.434082473823526,18.851818763088243,18.851818763088243,19.649843788549028,19.649843788549028,19.649843788549028,89.280300970078443,89.499454307941122,89.685434022499948,89.685434022499948,89.46340935443142,89.46340935443142,89.46340935443142]
[2047,92.187798740470527,null,2047,null,null,null,null,null,null,null,35.970872657721657,18.092333237010962,28.637032802846306,28.637032802846306,33.39640742023812,33.39640742023812,33.39640742023812,12.122079488203905,11.73140656592941,13.457298317035297,13.457298317035297,14.246136746698024,14.246136746698024,14.246136746698024,16.981361352009792,16.68691451188235,19.141846744058832,19.141846744058832,19.956872597745107,19.956872597745107,19.956872597745107,91.960225727558836,92.187798740470527,92.336582512117587,92.336582512117587,92.097557015823583,92.097557015823583,92.097557015823583]
[2048,94.876143172999932,null,2048,null,null,null,null,null,null,null,36.752467946237402,18.402576788984561,29.179643744672603,29.179643744672603,34.044654057180878,34.044654057180878,34.044654057180878,12.226580173447042,11.832539381152939,13.573309509423533,13.573309509423533,14.368948270376455,14.368948270376455,14.368948270376455,17.242613065117634,16.939746549941173,19.43187472502942,19.43187472502942,20.263901406941187,20.263901406941187,20.263901406941187,94.640150485039229,94.876143172999932,94.987731001735227,94.987731001735227,94.731704677215745,94.731704677215745,94.731704677215745]
[2049,97.564487605529337,null,2049,null,null,null,null,null,null,null,37.534063234753148,18.71282034095816,29.7222546864989,29.7222546864989,34.692900694123637,34.692900694123637,34.692900694123637,12.331080858690179,11.933672196376468,13.689320701811768,13.689320701811768,14.491759794054886,14.491759794054886,14.491759794054886,17.503864778225477,17.192578587999996,19.721902706000009,19.721902706000009,20.570930216137267,20.570930216137267,20.570930216137267,97.320075242519621,97.564487605529337,97.638879491352867,97.638879491352867,97.365852338607908,97.365852338607908,97.365852338607908]
[2050,100,null,2050,null,null,null,null,null,null,null,38.315658523268894,19.023063892931759,30.264865628325424,30.264865628325424,35.341147331066622,35.341147331066622,35.341147331066622,12.435581543933333,12.0348050116,13.805331894199998,13.805331894199998,14.614571317733335,14.614571317733335,14.614571317733335,17.765116491333334,17.192578588,19.721902705999998,19.721902705999998,20.877959025333336,20.877959025333336,20.877959025333336,100,100,100,100,100,100,100]

{"sheet":"Input_Data","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Input Observation Data"]
["This worksheet can be used to input different observations from available data.The user can update the inputs based on their own data analysis."]
["The pre-populated data has been on data analysis from the Office for National Statistics and Public Heath England"]
[]
["Key","Input"]
[]
["Input Reference","[Input_Data_1]","[Input_Data_2]","[Input_Data_3]","[Input_Data_4]"]
[]
["Age Group","Population","Total deaths in a year (including caused by infection)","Reported Infections in a year","Deaths caused by infection in a year"]
[{"$f":"Input_Lists!A5","v":"<1 yr"},668198.5,2579,536.3125,49.5]
[{"$f":"Input_Lists!A6","v":"1-14 yrs"},9075507.25,943,202.0625,7.8125]
[{"$f":"Input_Lists!A7","v":"15-44 yrs"},21385762.75,13821,2785.75,137.0625]
[{"$f":"Input_Lists!A8","v":"45-64 yrs"},13820413.75,57381,6242.25,758]
[{"$f":"Input_Lists!A9","v":"65-74 yrs"},5221386.25,79027,7014.0625,1001.8125]
[{"$f":"Input_Lists!A10","v":"75-84 yrs"},3103747.75,139112,9757.125,1683.5625]
[{"$f":"Input_Lists!A11","v":"85+ yrs"},1284191,192618,7580.5625,1783.9375]
[]
["Total",{"$f":"SUM(B10:B16)","v":54559207.25},{"$f":"SUM(C10:C16)","v":485481},{"$f":"SUM(D10:D16)","v":34118.125},{"$f":"SUM(E10:E16)","v":5421.6875}]

{"sheet":"Input_Lists","index":4,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Lists"]
["This worksheet is used to define any drop down lists used in the look up tables, users are not expected to update this worksheet"]
[]
["Age Groups"]
["<1 yr"]
["1-14 yrs"]
["15-44 yrs"]
["45-64 yrs"]
["65-74 yrs"]
["75-84 yrs"]
["85+ yrs"]
[]
["Resistance Profiles"]
["Custom Profile"]
["Linear Extrapolation"]
["+40% increase in resistance by 2050"]
["+100% increase in resistance by 2050"]
["100% Resistance by 2050"]

{"sheet":"Calc_TransProfile","index":5,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Calculation - Transition Profiles"]
["This worksheet calculates the transition profile over time by combining the initial observation data, resistance profiles and user input adjustments"]
[]
["User inputs from 'Input_Scen'"]
[]
[{"$f":"Input_Scen!A18","v":"Age Group"},{"$f":"Input_Scen!B18","v":"1-14 yrs"}]
[{"$f":"Input_Scen!A19","v":"Resistance Profile"},{"$f":"Input_Scen!B19","v":"100% Resistance by 2050"}]
[{"$f":"Input_Scen!A20","v":"Relative mortality rate of resistance against susceptible infection"},{"$f":"Input_Scen!B20","v":2.5}]
[{"$f":"Input_Scen!A21","v":"Average hospitalised days with susceptible infection"},{"$f":"Input_Scen!B21","v":10}]
[{"$f":"Input_Scen!A22","v":"Average hospitalised days with resistant infection"},{"$f":"Input_Scen!B22","v":12}]
[{"$f":"Input_Scen!A14","v":"Days in a year"},{"$f":"Input_Scen!B14","v":365}]
[{"$f":"Input_Scen!A15","v":"Assume deaths occur X through a year"},{"$f":"Input_Scen!B15","v":0.5}]
[]
["Import data for selected age group"]
[]
["Match Input_Data",{"$f":"MATCH(B6,Input_Data!A10:A16,0)","v":2}]
[]
["Age Group",{"$f":"B6","v":"1-14 yrs"}]
["Population",{"$f":"INDEX(Input_Data!$B$10:$E$16,$B$16,MATCH($A19,Input_Data!$B$9:$E$9,0))","v":9075507.25}]
["Total deaths in a year (including caused by infection)",{"$f":"INDEX(Input_Data!$B$10:$E$16,$B$16,MATCH($A20,Input_Data!$B$9:$E$9,0))","v":943}]
["Reported Infections in a year",{"$f":"INDEX(Input_Data!$B$10:$E$16,$B$16,MATCH($A21,Input_Data!$B$9:$E$9,0))","v":202.0625}]
["Deaths caused by infection in a year",{"$f":"INDEX(Input_Data!$B$10:$E$16,$B$16,MATCH($A22,Input_Data!$B$9:$E$9,0))","v":7.8125}]
["Implied case fatality rate",{"$f":"B22/B21","v":3.8663779771110421E-2}]
[]
[]
["Calculate impact of resistance profile over time"]
[]
["Year","Resistance Profile","Infection Rate Scalar","Mortality Rate Scalar","Total Infections","Total Deaths from Infection","Resistant Infections","Susceptible Infections","Susceptible Deaths","Resistant Deaths","Total Deaths","Deaths from other causes","Susceptible Bed Days","Resistant Bed Days","Total Potential Bed Days","Average Holding Time in H"]
[{"$f":"Input_Scen!B13","v":2017},{"$f":"Input_Res!B14","v":11.537465764588235},{"$f":"Input_Scen!B27","v":0},{"$f":"Input_Scen!C27","v":0},{"$f":"B21*(1+C29)","v":202.0625},{"$f":"E29*$B$23*(1+D29)","v":7.8124999999999991},{"$f":"E29*B29/100","v":23.312891760571102},{"$f":"E29-G29","v":178.74960823942891},{"$f":"H29*F29/(H29+$B$8*G29)","v":5.8915347755369627},{"$f":"F29-I29","v":1.9209652244630364},{"$f":"$B$20+F29-$B$22","v":943},{"$f":"K29-F29","v":935.1875},{"$f":"$B$9*H29","v":1787.496082394289},{"$f":"$B$10*G29","v":279.75470112685321},{"$f":"$B$19*$B$11","v":3312560146.25},{"$f":"O29-M29-N29-K29*$B$11*$B$12","v":3312385981.4992166}]
[{"$f":"A29+1","v":2018},{"$f":"Input_Res!B15","v":14.225810197117648},{"$f":"Input_Scen!B28","v":0},{"$f":"Input_Scen!C28","v":0},{"$f":"E29*(1+C30)","v":202.0625},{"$f":"I30+J30","v":8.0810624176906281},{"$f":"E30*B30/100","v":28.745027729550849},{"$f":"E30-G30","v":173.31747227044914},{"$f":"I29/H29*H30*(1+D30)","v":5.7124931637432086},{"$f":"J29/G29*G30*(1+D29)","v":2.3685692539474203},{"$f":"$B$20+F30-$B$22","v":943.26856241769065},935.1875,{"$f":"$B$9*H30","v":1733.1747227044914},{"$f":"$B$10*G30","v":344.94033275461015},{"$f":"$B$19*$B$11","v":3312560146.25},{"$f":"O30-M30-N30-K30*$B$11*$B$12","v":3312385921.622303}]
[{"$f":"A30+1","v":2019},{"$f":"Input_Res!B16","v":16.914154629647058},{"$f":"Input_Scen!B29","v":0},{"$f":"Input_Scen!C29","v":0},{"$f":"E30*(1+C31)","v":202.0625},{"$f":"I31+J31","v":8.3496248353812579},34.177163698530585,167.88533630146941,{"$f":"I30/H30*H31*(1+D31)","v":5.5334515519494554},{"$f":"J30/G30*G31*(1+D30)","v":2.816173283431803},943.53712483538129,935.1875,1678.853363014694,410.12596438236699,3312560146.25,3312385861.7453904]
[2020,{"$f":"Input_Res!B17","v":19.60249906217647},{"$f":"Input_Scen!B30","v":0},{"$f":"Input_Scen!C30","v":0},202.0625,8.6181872530718877,39.609299667510328,162.45320033248967,5.3544099401557022,3.2637773129161864,943.80568725307194,935.1875,1624.5320033248968,475.31159601012394,3312560146.25,3312385801.8684769]
[2021,{"$f":"Input_Res!B18","v":22.290843494705882},{"$f":"Input_Scen!B31","v":0},{"$f":"Input_Scen!C31","v":0},202.0625,8.8867496707625193,45.041435636490078,157.02106436350994,5.1753683283619489,3.7113813424005704,944.07424967076247,935.1875,1570.2106436350994,540.497227637881,3312560146.25,3312385741.9915638]
[2022,{"$f":"Input_Res!B19","v":24.979187927235294},{"$f":"Input_Scen!B32","v":0},{"$f":"Input_Scen!C32","v":0},202.0625,9.1553120884531474,50.473571605469814,151.58892839453017,4.9963267165681948,4.1589853718849534,944.34281208845312,935.1875,1515.8892839453017,605.68285926563772,3312560146.25,3312385682.1146502]
[2023,{"$f":"Input_Res!B20","v":27.667532359764706},{"$f":"Input_Scen!B33","v":0},{"$f":"Input_Scen!C33","v":0},202.0625,9.423874506143779,55.905707574449565,146.15679242555044,4.8172851047744416,4.6065894013693374,944.61137450614376,935.1875,1461.5679242555043,670.86849089339478,3312560146.25,3312385622.2377381]
[2024,{"$f":"Input_Res!B21","v":30.355876792294119},{"$f":"Input_Scen!B34","v":0},{"$f":"Input_Scen!C34","v":0},202.0625,9.6924369238344106,61.337843543429308,140.7246564565707,4.6382434929806893,5.0541934308537204,944.87993692383441,935.1875,1407.2465645657071,736.05412252115173,3312560146.25,3312385562.3608246]
[2025,{"$f":"Input_Res!B22","v":33.044221224823531},{"$f":"Input_Scen!B35","v":0},{"$f":"Input_Scen!C35","v":0},202.0625,9.9609993415250386,66.769979512409051,135.29252048759093,4.4592018811869352,5.5017974603381044,945.14849934152505,935.1875,1352.9252048759095,801.23975414890856,3312560146.25,3312385502.483911]
[2026,{"$f":"Input_Res!B23","v":35.732565657352943},{"$f":"Input_Scen!B36","v":0},{"$f":"Input_Scen!C36","v":0},202.0625,10.22956175921567,72.202115481388788,129.86038451861123,4.2801602693931828,5.9494014898224874,945.4170617592157,935.1875,1298.6038451861123,866.42538577666551,3312560146.25,3312385442.606998]
[2027,{"$f":"Input_Res!B24","v":38.420910089882355},{"$f":"Input_Scen!B37","v":0},{"$f":"Input_Scen!C37","v":0},202.0625,10.4981241769063,77.634251450368538,124.42824854963146,4.1011186575994287,6.3970055193068713,945.68562417690634,935.1875,1244.2824854963146,931.61101740442246,3312560146.25,3312385382.7300849]
[2028,{"$f":"Input_Res!B25","v":41.109254522411767},{"$f":"Input_Scen!B38","v":0},{"$f":"Input_Scen!C38","v":0},202.0625,10.76668659459693,83.066387419348288,118.99611258065171,3.9220770458056746,6.8446095487912553,945.95418659459688,935.1875,1189.9611258065172,996.7966490321794,3312560146.25,3312385322.8531718]
[2029,{"$f":"Input_Res!B26","v":43.797598954941179},{"$f":"Input_Scen!B39","v":0},{"$f":"Input_Scen!C39","v":0},202.0625,11.035249012287558,88.49852338832801,113.56397661167199,3.7430354340119223,7.2922135782756365,946.22274901228752,935.1875,1135.6397661167198,1061.9822806599361,3312560146.25,3312385262.9762583]
[2030,{"$f":"Input_Res!B27","v":46.485943387470591},{"$f":"Input_Scen!B40","v":0},{"$f":"Input_Scen!C40","v":0},202.0625,11.30381142997819,93.930659357307761,108.13184064269224,3.5639938222181686,7.7398176077600205,946.49131142997817,935.1875,1081.3184064269224,1127.1679122876931,3312560146.25,3312385203.0993447]
[2031,{"$f":"Input_Res!B28","v":49.174287820000004},{"$f":"Input_Scen!B41","v":0},{"$f":"Input_Scen!C41","v":0},202.0625,11.572373847668821,99.362795326287511,102.69970467371249,3.384952210424415,8.1874216372444053,946.75987384766881,935.1875,1026.9970467371249,1192.3535439154502,3312560146.25,3312385143.2224321]
[2032,{"$f":"Input_Res!B29","v":51.862632252529416},{"$f":"Input_Scen!B42","v":0},{"$f":"Input_Scen!C42","v":0},202.0625,11.840936265359449,104.79493129526725,97.267568704732753,3.2059105986306617,8.6350256667287884,947.02843626535946,935.1875,972.67568704732753,1257.539175543207,3312560146.25,3312385083.3455191]
[2033,{"$f":"Input_Res!B30","v":54.550976685058828},{"$f":"Input_Scen!B43","v":0},{"$f":"Input_Scen!C43","v":0},202.0625,12.109498683050079,110.227067264247,91.835432735753002,3.0268689868369081,9.0826296962131714,947.29699868305011,935.1875,918.35432735753,1322.7248071709639,3312560146.25,3312385023.468606]
[2034,{"$f":"Input_Res!B31","v":57.23932111758824},{"$f":"Input_Scen!B44","v":0},{"$f":"Input_Scen!C44","v":0},202.0625,12.378061100740711,115.65920323322675,86.403296766773252,2.8478273750431544,9.5302337256975562,947.56556110074075,935.1875,864.03296766773246,1387.9104387987209,3312560146.25,3312384963.5916924]
[2035,{"$f":"Input_Res!B32","v":59.927665550117652},{"$f":"Input_Scen!B45","v":0},{"$f":"Input_Scen!C45","v":0},202.0625,12.646623518431339,121.09133920220647,80.97116079779353,2.6687857632494016,9.9778377551819375,947.83412351843128,935.1875,809.71160797793527,1453.0960704264776,3312560146.25,3312384903.7147799]
[2036,{"$f":"Input_Res!B33","v":62.616009982647064},{"$f":"Input_Scen!B46","v":0},{"$f":"Input_Scen!C46","v":0},202.0625,12.915185936121969,126.52347517118622,75.53902482881378,2.489744151455648,10.425441784666321,948.10268593612193,935.1875,755.39024828813785,1518.2817020542348,3312560146.25,3312384843.8378663]
[2037,{"$f":"Input_Res!B34","v":65.304354415176476},{"$f":"Input_Scen!B47","v":0},{"$f":"Input_Scen!C47","v":0},202.0625,13.183748353812598,131.95561114016596,70.106888859834044,2.3107025396618948,10.873045814150704,948.37124835381258,935.1875,701.06888859834044,1583.4673336819915,3312560146.25,3312384783.9609528]
[2038,{"$f":"Input_Res!B35","v":67.992698847705881},{"$f":"Input_Scen!B48","v":0},{"$f":"Input_Scen!C48","v":0},202.0625,13.452310771503228,137.38774710914569,64.674752890854307,2.131660927868142,11.320649843635087,948.63981077150322,935.1875,646.74752890854302,1648.6529653097482,3312560146.25,3312384724.0840397]
[2039,{"$f":"Input_Res!B36","v":70.681043280235286},{"$f":"Input_Scen!B49","v":0},{"$f":"Input_Scen!C49","v":0},202.0625,13.720873189193858,142.81988307812543,59.242616921874571,1.9526193160743885,11.76825387311947,948.90837318919387,935.1875,592.42616921874571,1713.8385969375051,3312560146.25,3312384664.2071266]
[2040,{"$f":"Input_Res!B37","v":73.369387712764691},{"$f":"Input_Scen!B50","v":0},{"$f":"Input_Scen!C50","v":0},202.0625,13.989435606884488,148.25201904710514,53.810480952894864,1.7735777042806364,12.215857902603851,949.17693560688451,935.1875,538.10480952894864,1779.0242285652616,3312560146.25,3312384604.3302135]
[2041,{"$f":"Input_Res!B38","v":76.057732145294096},{"$f":"Input_Scen!B51","v":0},{"$f":"Input_Scen!C51","v":0},202.0625,14.257998024575118,153.68415501608487,48.378344983915127,1.5945360924868832,12.663461932088234,949.44549802457516,935.1875,483.78344983915127,1844.2098601930184,3312560146.25,3312384544.4533005]
[2042,{"$f":"Input_Res!B39","v":78.746076577823501},{"$f":"Input_Scen!B52","v":0},{"$f":"Input_Scen!C52","v":0},202.0625,14.526560442265746,159.11629098506461,42.946209014935391,1.41549448069313,13.111065961572615,949.71406044226569,935.1875,429.46209014935391,1909.3954918207753,3312560146.25,3312384484.5763879]
[2043,{"$f":"Input_Res!B40","v":81.434421010352906},{"$f":"Input_Scen!B53","v":0},{"$f":"Input_Scen!C53","v":0},202.0625,14.795122859956376,164.54842695404434,37.514073045955655,1.236452868899377,13.558669991056998,949.98262285995634,935.1875,375.14073045955655,1974.5811234485323,3312560146.25,3312384424.6994743]
[2044,{"$f":"Input_Res!B41","v":84.122765442882312},{"$f":"Input_Scen!B54","v":0},{"$f":"Input_Scen!C54","v":0},202.0625,15.063685277647005,169.98056292302408,32.081937076975919,1.0574112571056238,14.006274020541381,950.25118527764698,935.1875,320.81937076975919,2039.766755076289,3312560146.25,3312384364.8225608]
[2045,{"$f":"Input_Res!B42","v":86.811109875411717},{"$f":"Input_Scen!B55","v":0},{"$f":"Input_Scen!C55","v":0},202.0625,15.332247695337633,175.41269889200379,26.649801107996211,0.87836964531187156,14.453878050025763,950.51974769533763,935.1875,266.49801107996211,2104.9523867040452,3312560146.25,3312384304.9456477]
[2046,{"$f":"Input_Res!B43","v":89.499454307941122},{"$f":"Input_Scen!B56","v":0},{"$f":"Input_Scen!C56","v":0},202.0625,15.600810113028263,180.84483486098353,21.217665139016475,0.69932803351811834,14.901482079510146,950.78831011302827,935.1875,212.17665139016475,2170.1380183318024,3312560146.25,3312384245.0687346]
[2047,{"$f":"Input_Res!B44","v":92.187798740470527},{"$f":"Input_Scen!B57","v":0},{"$f":"Input_Scen!C57","v":0},202.0625,15.869372530718895,186.27697082996326,15.785529170036739,0.52028642172436523,15.349086108994529,951.05687253071892,935.1875,157.85529170036739,2235.3236499595591,3312560146.25,3312384185.1918216]
[2048,{"$f":"Input_Res!B45","v":94.876143172999932},{"$f":"Input_Scen!B58","v":0},{"$f":"Input_Scen!C58","v":0},202.0625,16.137934948409523,191.709106798943,10.353393201057003,0.34124480993061207,15.79669013847891,951.32543494840957,935.1875,103.53393201057003,2300.5092815873159,3312560146.25,3312384125.314908]
[2049,{"$f":"Input_Res!B46","v":97.564487605529337},{"$f":"Input_Scen!B59","v":0},{"$f":"Input_Scen!C59","v":0},202.0625,16.406497366100155,197.14124276792271,4.9212572320772949,0.16220319813685985,16.244294167963293,951.59399736610021,935.1875,49.212572320772949,2365.6949132150726,3312560146.25,3312384065.4379954]
[2050,{"$f":"Input_Res!B47","v":100},{"$f":"Input_Scen!B60","v":0},{"$f":"Input_Scen!C60","v":0},202.0625,16.649802163305445,202.0625,0,0,16.649802163305445,951.83730216330548,935.1875,0,2424.75,3312560146.25,3312384011.1923552]

{"sheet":"Calc_TransProb","index":6,"n_rows":39,"n_cols":36,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,1,3,7],[3,9,3,11],[3,13,3,19],[3,21,3,23],[3,25,3,35]]}
["Calculation - Transition Probabilities"]
["This worksheet converts the annual observations of state transitions into daily transition probabilities"]
[]
[null,"Number of transitions in a year",null,null,null,null,null,null,null,"Holding time in state t(i)",null,null,null,"Daily Transition rates σ(i)",null,null,null,null,null,null,null,"Total daily transition rate out of state λ(i)",null,null,null,"Probability of transition from i to j given you are in state i:  Pr(X(t+1) = j | X(t) = i)"]
["Year","HS","HR","SD","RD","SH","RH","HD",null,"H","S","R",null,"HS","HR","SD","RD","SH","RH","HD",null,"H","R","S",null,"HS","HR","HH","HD","SH","SS","SD","RH","RR","RD","DD"]
[{"$f":"Calc_TransProfile!A29","v":2017},{"$f":"Calc_TransProfile!H29","v":178.74960823942891},{"$f":"Calc_TransProfile!G29","v":23.312891760571102},{"$f":"Calc_TransProfile!I29","v":5.8915347755369627},{"$f":"Calc_TransProfile!J29","v":1.9209652244630364},{"$f":"B6-D6","v":172.85807346389194},{"$f":"C6-E6","v":21.391926536108066},{"$f":"Calc_TransProfile!L29","v":935.1875},null,{"$f":"Calc_TransProfile!P29","v":3312385981.4992166},{"$f":"Calc_TransProfile!M29","v":1787.496082394289},{"$f":"Calc_TransProfile!N29","v":279.75470112685321},null,{"$f":"B6/J6","v":5.3964003361264433E-8},{"$f":"C6/J6","v":7.0380963724582216E-9},{"$f":"D6/K6","v":3.2959707344619497E-3},{"$f":"E6/L6","v":6.8666056967957275E-3},{"$f":"F6/K6","v":9.6704029265538047E-2},{"$f":"G6/L6","v":7.6466727636537613E-2},{"$f":"H6/J6","v":2.8233047272369069E-7},null,{"$f":"N6+O6+T6","v":3.4333257245741336E-7},{"$f":"Q6+S6","v":8.3333333333333343E-2},{"$f":"P6+R6","v":9.9999999999999992E-2},null,{"$f":"(1-AB6)*N6/V6","v":5.3963994099300873E-8},{"$f":"(1-AB6)*O6/V6","v":7.0380951644938732E-9},{"$f":"EXP(-V6)","v":0.99999965666748647},{"$f":"(1-AB6)*T6/V6","v":2.8233042426667511E-7},{"$f":"(1-AE6)*R6/X6","v":9.202605111234724E-2},{"$f":"EXP(-X6)","v":0.90483741803595963},{"$f":"(1-AE6)*P6/X6","v":3.1365308516931364E-3},{"$f":"(1-AH6)*S6/W6","v":7.3367303634713596E-2},{"$f":"EXP(-W6)","v":0.92004441462932329},{"$f":"(1-AH6)*Q6/W6","v":6.5882817359631096E-3},1]
[{"$f":"Calc_TransProfile!A30","v":2018},{"$f":"Calc_TransProfile!H30","v":173.31747227044914},{"$f":"Calc_TransProfile!G30","v":28.745027729550849},{"$f":"Calc_TransProfile!I30","v":5.7124931637432086},{"$f":"Calc_TransProfile!J30","v":2.3685692539474203},{"$f":"B7-D7","v":167.60497910670594},{"$f":"C7-E7","v":26.376458475603428},{"$f":"Calc_TransProfile!L30","v":935.1875},null,{"$f":"Calc_TransProfile!P30","v":3312385921.622303},{"$f":"Calc_TransProfile!M30","v":1733.1747227044914},{"$f":"Calc_TransProfile!N30","v":344.94033275461015},null,{"$f":"B7/J7","v":5.232405775519166E-8},{"$f":"C7/J7","v":8.6780430812459301E-9},3.2959707344619497E-3,6.8666056967957283E-3,{"$f":"F7/K7","v":9.6704029265538061E-2},7.6466727636537613E-2,{"$f":"H7/J7","v":2.8233047782728601E-7},null,{"$f":"N7+O7+T7","v":3.4333257866372361E-7},{"$f":"Q7+S7","v":8.3333333333333343E-2},{"$f":"P7+R7","v":0.1},null,{"$f":"(1-AB7)*N7/V7","v":5.2324048776362885E-8},{"$f":"(1-AB7)*O7/V7","v":8.6780415920903435E-9},{"$f":"EXP(-V7)","v":0.99999965666748025},{"$f":"(1-AB7)*T7/V7","v":2.823304293792656E-7},{"$f":"(1-AE7)*R7/X7","v":9.2026051112347351E-2},{"$f":"EXP(-X7)","v":0.90483741803595952},{"$f":"(1-AE7)*P7/X7","v":3.1365308516931398E-3},{"$f":"(1-AH7)*S7/W7","v":7.3367303634713596E-2},{"$f":"EXP(-W7)","v":0.92004441462932329},{"$f":"(1-AH7)*Q7/W7","v":6.5882817359631096E-3},1]
[{"$f":"Calc_TransProfile!A31","v":2019},{"$f":"Calc_TransProfile!H31","v":167.88533630146941},{"$f":"Calc_TransProfile!G31","v":34.177163698530585},{"$f":"Calc_TransProfile!I31","v":5.5334515519494554},{"$f":"Calc_TransProfile!J31","v":2.816173283431803},162.35188474951994,31.360990415098783,{"$f":"Calc_TransProfile!L31","v":935.1875},null,{"$f":"Calc_TransProfile!P31","v":3312385861.7453904},{"$f":"Calc_TransProfile!M31","v":1678.853363014694},{"$f":"Calc_TransProfile!N31","v":410.12596438236699},null,5.0684112089829368E-8,1.031798984932319E-8,3.2959707344619497E-3,6.8666056967957283E-3,9.6704029265538047E-2,7.6466727636537613E-2,2.8233048293088144E-7,null,3.4333258487003402E-7,8.3333333333333343E-2,9.9999999999999992E-2,null,5.0684103394030855E-8,1.0317988079080858E-8,0.99999965666747404,2.8233043449185605E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A32","v":2020},{"$f":"Calc_TransProfile!H32","v":162.45320033248967},{"$f":"Calc_TransProfile!G32","v":39.609299667510328},{"$f":"Calc_TransProfile!I32","v":5.3544099401557022},{"$f":"Calc_TransProfile!J32","v":3.2637773129161864},157.09879039233397,36.345522354594138,{"$f":"Calc_TransProfile!L32","v":935.1875},null,{"$f":"Calc_TransProfile!P32","v":3312385801.8684769},{"$f":"Calc_TransProfile!M32","v":1624.5320033248968},{"$f":"Calc_TransProfile!N32","v":475.31159601012394},null,4.9044166365177568E-8,1.1957936676690016E-8,3.2959707344619497E-3,6.8666056967957275E-3,9.6704029265538047E-2,7.6466727636537599E-2,2.8233048803447714E-7,null,3.4333259107634469E-7,8.3333333333333329E-2,9.9999999999999992E-2,null,4.9044157952304789E-8,1.1957934625465426E-8,0.99999965666746782,2.8233043960444654E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A33","v":2021},{"$f":"Calc_TransProfile!H33","v":157.02106436350994},{"$f":"Calc_TransProfile!G33","v":45.041435636490078},{"$f":"Calc_TransProfile!I33","v":5.1753683283619489},{"$f":"Calc_TransProfile!J33","v":3.7113813424005704},151.84569603514799,41.330054294089507,{"$f":"Calc_TransProfile!L33","v":935.1875},null,{"$f":"Calc_TransProfile!P33","v":3312385741.9915638},{"$f":"Calc_TransProfile!M33","v":1570.2106436350994},{"$f":"Calc_TransProfile!N33","v":540.497227637881},null,4.7404220581236235E-8,1.3597883563346407E-8,3.2959707344619497E-3,6.8666056967957266E-3,9.6704029265538061E-2,7.6466727636537599E-2,2.8233049313807299E-7,null,3.4333259728265562E-7,8.3333333333333329E-2,0.1,null,4.7404212451184653E-8,1.3597881231244045E-8,0.9999996566674616,2.8233044471703693E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931398E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631087E-3,1]
[{"$f":"Calc_TransProfile!A34","v":2022},{"$f":"Calc_TransProfile!H34","v":151.58892839453017},{"$f":"Calc_TransProfile!G34","v":50.473571605469814},{"$f":"Calc_TransProfile!I34","v":4.9963267165681948},{"$f":"Calc_TransProfile!J34","v":4.1589853718849534},146.59260167796197,46.314586233584862,{"$f":"Calc_TransProfile!L34","v":935.1875},null,{"$f":"Calc_TransProfile!P34","v":3312385682.1146502},{"$f":"Calc_TransProfile!M34","v":1515.8892839453017},{"$f":"Calc_TransProfile!N34","v":605.68285926563772},null,4.5764274738005368E-8,1.5237830509292363E-8,3.2959707344619497E-3,6.8666056967957283E-3,9.6704029265538047E-2,7.6466727636537613E-2,2.8233049824166906E-7,null,3.4333260348896677E-7,8.3333333333333343E-2,9.9999999999999992E-2,null,4.5764266875871823E-8,1.5237827891489304E-8,0.99999965666745549,2.8233044973833115E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A35","v":2023},{"$f":"Calc_TransProfile!H35","v":146.15679242555044},{"$f":"Calc_TransProfile!G35","v":55.905707574449565},{"$f":"Calc_TransProfile!I35","v":4.8172851047744416},{"$f":"Calc_TransProfile!J35","v":4.6065894013693374},141.33950732077599,51.299118173080231,{"$f":"Calc_TransProfile!L35","v":935.1875},null,{"$f":"Calc_TransProfile!P35","v":3312385622.2377381},{"$f":"Calc_TransProfile!M35","v":1461.5679242555043},{"$f":"Calc_TransProfile!N35","v":670.86849089339478},null,4.4124328835484967E-8,1.687777751452789E-8,3.2959707344619497E-3,6.8666056967957275E-3,9.6704029265538061E-2,7.6466727636537613E-2,2.8233050334526517E-7,null,3.4333260969527803E-7,8.3333333333333343E-2,0.1,null,4.4124321256493903E-8,1.6877774615525722E-8,0.99999965666744928,2.8233045485092159E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931398E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A36","v":2024},{"$f":"Calc_TransProfile!H36","v":140.7246564565707},{"$f":"Calc_TransProfile!G36","v":61.337843543429308},{"$f":"Calc_TransProfile!I36","v":4.6382434929806893},{"$f":"Calc_TransProfile!J36","v":5.0541934308537204},136.08641296359002,56.283650112575586,{"$f":"Calc_TransProfile!L36","v":935.1875},null,{"$f":"Calc_TransProfile!P36","v":3312385562.3608246},{"$f":"Calc_TransProfile!M36","v":1407.2465645657071},{"$f":"Calc_TransProfile!N36","v":736.05412252115173},null,4.2484382873675046E-8,1.8517724579052993E-8,3.2959707344619497E-3,6.8666056967957266E-3,9.6704029265538047E-2,7.6466727636537599E-2,2.8233050844886161E-7,null,3.4333261590158965E-7,8.3333333333333329E-2,9.9999999999999992E-2,null,4.2484375577721927E-8,1.8517721398956182E-8,0.99999965666744306,2.8233045996351203E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631087E-3,1]
[{"$f":"Calc_TransProfile!A37","v":2025},{"$f":"Calc_TransProfile!H37","v":135.29252048759093},{"$f":"Calc_TransProfile!G37","v":66.769979512409051},{"$f":"Calc_TransProfile!I37","v":4.4592018811869352},{"$f":"Calc_TransProfile!J37","v":5.5017974603381044},130.83331860640399,61.268182052070948,{"$f":"Calc_TransProfile!L37","v":935.1875},null,{"$f":"Calc_TransProfile!P37","v":3312385502.483911},{"$f":"Calc_TransProfile!M37","v":1352.9252048759095},{"$f":"Calc_TransProfile!N37","v":801.23975414890856},null,4.0844436852575578E-8,2.0157671702867674E-8,3.2959707344619497E-3,6.8666056967957283E-3,9.6704029265538033E-2,7.6466727636537613E-2,2.823305135524582E-7,null,3.4333262210790144E-7,8.3333333333333343E-2,9.9999999999999978E-2,null,4.0844429839555896E-8,2.0157668241780699E-8,0.99999965666743684,2.8233046507610253E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931368E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A38","v":2026},{"$f":"Calc_TransProfile!H38","v":129.86038451861123},{"$f":"Calc_TransProfile!G38","v":72.202115481388788},{"$f":"Calc_TransProfile!I38","v":4.2801602693931828},{"$f":"Calc_TransProfile!J38","v":5.9494014898224874},125.58022424921805,66.252713991566296,{"$f":"Calc_TransProfile!L38","v":935.1875},null,{"$f":"Calc_TransProfile!P38","v":3312385442.606998},{"$f":"Calc_TransProfile!M38","v":1298.6038451861123},{"$f":"Calc_TransProfile!N38","v":866.42538577666551},null,3.9204490772186584E-8,2.179761888597193E-8,3.2959707344619501E-3,6.8666056967957275E-3,9.6704029265538047E-2,7.6466727636537599E-2,2.8233051865605501E-7,null,3.4333262831421354E-7,8.3333333333333329E-2,9.9999999999999992E-2,null,3.9204484041995821E-8,2.1797615143999255E-8,0.99999965666743063,2.8233047018869297E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931368E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A39","v":2027},{"$f":"Calc_TransProfile!H39","v":124.42824854963146},{"$f":"Calc_TransProfile!G39","v":77.634251450368538},{"$f":"Calc_TransProfile!I39","v":4.1011186575994287},{"$f":"Calc_TransProfile!J39","v":6.3970055193068713},120.32712989203203,71.237245931061665,{"$f":"Calc_TransProfile!L39","v":935.1875},null,{"$f":"Calc_TransProfile!P39","v":3312385382.7300849},{"$f":"Calc_TransProfile!M39","v":1244.2824854963146},{"$f":"Calc_TransProfile!N39","v":931.61101740442246},null,3.7564544632508029E-8,2.3437566128365774E-8,3.2959707344619501E-3,6.8666056967957283E-3,9.6704029265538047E-2,7.6466727636537599E-2,2.8233052375965192E-7,null,3.4333263452052574E-7,8.3333333333333329E-2,9.9999999999999992E-2,null,3.7564538185041697E-8,2.3437562105611867E-8,0.99999965666742441,2.8233047530128336E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931368E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A40","v":2028},{"$f":"Calc_TransProfile!H40","v":118.99611258065171},{"$f":"Calc_TransProfile!G40","v":83.066387419348288},{"$f":"Calc_TransProfile!I40","v":3.9220770458056746},{"$f":"Calc_TransProfile!J40","v":6.8446095487912553},115.07403553484603,76.221777870557034,{"$f":"Calc_TransProfile!L40","v":935.1875},null,{"$f":"Calc_TransProfile!P40","v":3312385322.8531718},{"$f":"Calc_TransProfile!M40","v":1189.9611258065172},{"$f":"Calc_TransProfile!N40","v":996.7966490321794},null,3.5924598433539927E-8,2.5077513430049204E-8,3.2959707344619492E-3,6.8666056967957283E-3,9.6704029265538033E-2,7.6466727636537613E-2,2.8233052886324905E-7,null,3.4333264072683816E-7,8.3333333333333343E-2,9.9999999999999978E-2,null,3.5924592268693517E-8,2.5077509126618532E-8,0.99999965666741819,2.8233048041387386E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931368E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A41","v":2029},{"$f":"Calc_TransProfile!H41","v":113.56397661167199},{"$f":"Calc_TransProfile!G41","v":88.49852338832801},{"$f":"Calc_TransProfile!I41","v":3.7430354340119223},{"$f":"Calc_TransProfile!J41","v":7.2922135782756365},109.82094117766007,81.206309810052375,{"$f":"Calc_TransProfile!L41","v":935.1875},null,{"$f":"Calc_TransProfile!P41","v":3312385262.9762583},{"$f":"Calc_TransProfile!M41","v":1135.6397661167198},{"$f":"Calc_TransProfile!N41","v":1061.9822806599361},null,3.4284652175282292E-8,2.671746079102222E-8,3.2959707344619501E-3,6.8666056967957275E-3,9.6704029265538061E-2,7.6466727636537613E-2,2.8233053396684643E-7,null,3.4333264693315095E-7,8.3333333333333343E-2,0.1,null,3.4284646292951293E-8,2.6717456207019236E-8,0.99999965666741197,2.823304855264643E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931403E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A42","v":2030},{"$f":"Calc_TransProfile!H42","v":108.13184064269224},{"$f":"Calc_TransProfile!G42","v":93.930659357307761},{"$f":"Calc_TransProfile!I42","v":3.5639938222181686},{"$f":"Calc_TransProfile!J42","v":7.7398176077600205},104.56784682047407,86.190841749547744,{"$f":"Calc_TransProfile!L42","v":935.1875},null,{"$f":"Calc_TransProfile!P42","v":3312385203.0993447},{"$f":"Calc_TransProfile!M42","v":1081.3184064269224},{"$f":"Calc_TransProfile!N42","v":1127.1679122876931},null,3.2644705857735097E-8,2.8357408211284839E-8,3.2959707344619501E-3,6.8666056967957275E-3,9.6704029265538061E-2,7.6466727636537613E-2,2.8233053907044398E-7,null,3.433326531394639E-7,8.3333333333333343E-2,0.1,null,3.2644700257815014E-8,2.8357403346814E-8,0.99999965666740576,2.823304906390548E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931403E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A43","v":2031},{"$f":"Calc_TransProfile!H43","v":102.69970467371249},{"$f":"Calc_TransProfile!G43","v":99.362795326287511},{"$f":"Calc_TransProfile!I43","v":3.384952210424415},{"$f":"Calc_TransProfile!J43","v":8.1874216372444053},99.314752463288073,91.175373689043113,{"$f":"Calc_TransProfile!L43","v":935.1875},null,{"$f":"Calc_TransProfile!P43","v":3312385143.2224321},{"$f":"Calc_TransProfile!M43","v":1026.9970467371249},{"$f":"Calc_TransProfile!N43","v":1192.3535439154502},null,3.1004759480898335E-8,2.9997355690837046E-8,3.2959707344619497E-3,6.8666056967957275E-3,9.6704029265538047E-2,7.6466727636537599E-2,2.8233054417404158E-7,null,3.4333265934577696E-7,8.3333333333333329E-2,9.9999999999999992E-2,null,3.1004754163284692E-8,2.9997350546002817E-8,0.99999965666739954,2.8233049575164524E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A44","v":2032},{"$f":"Calc_TransProfile!H44","v":97.267568704732753},{"$f":"Calc_TransProfile!G44","v":104.79493129526725},{"$f":"Calc_TransProfile!I44","v":3.2059105986306617},{"$f":"Calc_TransProfile!J44","v":8.6350256667287884},94.061658106102087,96.159905628538453,{"$f":"Calc_TransProfile!L44","v":935.1875},null,{"$f":"Calc_TransProfile!P44","v":3312385083.3455191},{"$f":"Calc_TransProfile!M44","v":972.67568704732753},{"$f":"Calc_TransProfile!N44","v":1257.539175543207},null,2.9364813044772019E-8,3.1637303229678855E-8,3.2959707344619497E-3,6.8666056967957283E-3,9.6704029265538047E-2,7.6466727636537599E-2,2.8233054927763945E-7,null,3.4333266555209033E-7,8.3333333333333329E-2,9.9999999999999992E-2,null,2.9364807999864723E-8,3.1637297794355233E-8,0.99999965666739343,2.823305007729394E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A45","v":2033},{"$f":"Calc_TransProfile!H45","v":91.835432735753002},{"$f":"Calc_TransProfile!G45","v":110.227067264247},{"$f":"Calc_TransProfile!I45","v":3.0268689868369081},{"$f":"Calc_TransProfile!J45","v":9.0826296962131714},88.8085637489161,101.14443756803382,{"$f":"Calc_TransProfile!L45","v":935.1875},null,{"$f":"Calc_TransProfile!P45","v":3312385023.468606},{"$f":"Calc_TransProfile!M45","v":918.35432735753},{"$f":"Calc_TransProfile!N45","v":1322.7248071709639},null,2.7724866549356137E-8,3.3277250827810264E-8,3.2959707344619497E-3,6.8666056967957275E-3,9.6704029265538061E-2,7.6466727636537613E-2,2.8233055438123752E-7,null,3.4333267175840391E-7,8.3333333333333343E-2,0.1,null,2.7724861787076597E-8,3.3277245111801834E-8,0.99999965666738722,2.823305058855299E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931398E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A46","v":2034},{"$f":"Calc_TransProfile!H46","v":86.403296766773252},{"$f":"Calc_TransProfile!G46","v":115.65920323322675},{"$f":"Calc_TransProfile!I46","v":2.8478273750431544},{"$f":"Calc_TransProfile!J46","v":9.5302337256975562},83.555469391730099,106.12896950752919,{"$f":"Calc_TransProfile!L46","v":935.1875},null,{"$f":"Calc_TransProfile!P46","v":3312384963.5916924},{"$f":"Calc_TransProfile!M46","v":864.03296766773246},{"$f":"Calc_TransProfile!N46","v":1387.9104387987209},null,2.6084919994650695E-8,3.4917198485231292E-8,3.2959707344619501E-3,6.8666056967957283E-3,9.6704029265538061E-2,7.6466727636537613E-2,2.8233055948483581E-7,null,3.4333267796471781E-7,8.3333333333333343E-2,0.1,null,2.6084915514894422E-8,3.4917192488642497E-8,0.999999656667381,2.8233051099812029E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931403E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A47","v":2035},{"$f":"Calc_TransProfile!H47","v":80.97116079779353},{"$f":"Calc_TransProfile!G47","v":121.09133920220647},{"$f":"Calc_TransProfile!I47","v":2.6687857632494016},{"$f":"Calc_TransProfile!J47","v":9.9778377551819375},78.302375034544127,111.11350144702453,{"$f":"Calc_TransProfile!L47","v":935.1875},null,{"$f":"Calc_TransProfile!P47","v":3312384903.7147799},{"$f":"Calc_TransProfile!M47","v":809.71160797793527},{"$f":"Calc_TransProfile!N47","v":1453.0960704264776},null,2.4444973380655683E-8,3.6557146201941907E-8,3.2959707344619497E-3,6.8666056967957283E-3,9.6704029265538047E-2,7.6466727636537613E-2,2.8233056458843421E-7,null,3.4333268417103177E-7,8.3333333333333343E-2,9.9999999999999992E-2,null,2.444496918331821E-8,3.6557139924877203E-8,0.99999965666737478,2.8233051611071079E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A48","v":2036},{"$f":"Calc_TransProfile!H48","v":75.53902482881378},{"$f":"Calc_TransProfile!G48","v":126.52347517118622},{"$f":"Calc_TransProfile!I48","v":2.489744151455648},{"$f":"Calc_TransProfile!J48","v":10.425441784666321},73.049280677358126,116.0980333865199,{"$f":"Calc_TransProfile!L48","v":935.1875},null,{"$f":"Calc_TransProfile!P48","v":3312384843.8378663},{"$f":"Calc_TransProfile!M48","v":755.39024828813785},{"$f":"Calc_TransProfile!N48","v":1518.2817020542348},null,2.2805026707371097E-8,3.8197093977942155E-8,3.2959707344619492E-3,6.8666056967957266E-3,9.6704029265538033E-2,7.6466727636537599E-2,2.8233056969203281E-7,null,3.4333269037734604E-7,8.3333333333333329E-2,9.9999999999999978E-2,null,2.2805022792347939E-8,3.8197087420505965E-8,0.99999965666736856,2.8233052122330123E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931368E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631087E-3,1]
[{"$f":"Calc_TransProfile!A49","v":2037},{"$f":"Calc_TransProfile!H49","v":70.106888859834044},{"$f":"Calc_TransProfile!G49","v":131.95561114016596},{"$f":"Calc_TransProfile!I49","v":2.3107025396618948},{"$f":"Calc_TransProfile!J49","v":10.873045814150704},67.796186320172154,121.08256532601526,{"$f":"Calc_TransProfile!L49","v":935.1875},null,{"$f":"Calc_TransProfile!P49","v":3312384783.9609528},{"$f":"Calc_TransProfile!M49","v":701.06888859834044},{"$f":"Calc_TransProfile!N49","v":1583.4673336819915},null,2.1165079974796939E-8,3.9837041813232009E-8,3.2959707344619497E-3,6.8666056967957275E-3,9.6704029265538061E-2,7.6466727636537613E-2,2.8233057479563168E-7,null,3.4333269658366063E-7,8.3333333333333343E-2,0.1,null,2.1165076341983619E-8,3.9837034975528757E-8,0.99999965666736235,2.8233052633589167E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931398E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A50","v":2038},{"$f":"Calc_TransProfile!H50","v":64.674752890854307},{"$f":"Calc_TransProfile!G50","v":137.38774710914569},{"$f":"Calc_TransProfile!I50","v":2.131660927868142},{"$f":"Calc_TransProfile!J50","v":11.320649843635087},62.543091962986168,126.06709726551061,{"$f":"Calc_TransProfile!L50","v":935.1875},null,{"$f":"Calc_TransProfile!P50","v":3312384724.0840397},{"$f":"Calc_TransProfile!M50","v":646.74752890854302},{"$f":"Calc_TransProfile!N50","v":1648.6529653097482},null,1.9525133182933197E-8,4.1476989707811483E-8,3.2959707344619505E-3,6.8666056967957283E-3,9.6704029265538061E-2,7.6466727636537613E-2,2.8233057989923066E-7,null,3.4333270278997532E-7,8.3333333333333343E-2,0.1,null,1.9525129832225249E-8,4.1476982589945619E-8,0.99999965666735613,2.8233053144848217E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931407E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A51","v":2039},{"$f":"Calc_TransProfile!H51","v":59.242616921874571},{"$f":"Calc_TransProfile!G51","v":142.81988307812543},{"$f":"Calc_TransProfile!I51","v":1.9526193160743885},{"$f":"Calc_TransProfile!J51","v":11.76825387311947},57.289997605800181,131.05162920500595,{"$f":"Calc_TransProfile!L51","v":935.1875},null,{"$f":"Calc_TransProfile!P51","v":3312384664.2071266},{"$f":"Calc_TransProfile!M51","v":592.42616921874571},{"$f":"Calc_TransProfile!N51","v":1713.8385969375051},null,1.7885186331779875E-8,4.3116937661680577E-8,3.2959707344619497E-3,6.8666056967957275E-3,9.6704029265538047E-2,7.6466727636537599E-2,2.823305850028298E-7,null,3.4333270899629023E-7,8.3333333333333329E-2,9.9999999999999992E-2,null,1.7885183263072833E-8,4.3116930263756523E-8,0.99999965666734991,2.8233053656107261E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A52","v":2040},{"$f":"Calc_TransProfile!H52","v":53.810480952894864},{"$f":"Calc_TransProfile!G52","v":148.25201904710514},{"$f":"Calc_TransProfile!I52","v":1.7735777042806364},{"$f":"Calc_TransProfile!J52","v":12.215857902603851},52.03690324861423,136.03616114450128,{"$f":"Calc_TransProfile!L52","v":935.1875},null,{"$f":"Calc_TransProfile!P52","v":3312384604.3302135},{"$f":"Calc_TransProfile!M52","v":538.10480952894864},{"$f":"Calc_TransProfile!N52","v":1779.0242285652616},null,1.6245239421336976E-8,4.475688567483929E-8,3.2959707344619497E-3,6.8666056967957283E-3,9.6704029265538061E-2,7.6466727636537599E-2,2.8233059010642914E-7,null,3.433327152026054E-7,8.3333333333333329E-2,0.1,null,1.6245236634526377E-8,4.475687799696147E-8,0.99999965666734369,2.82330541673663E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931398E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A53","v":2041},{"$f":"Calc_TransProfile!H53","v":48.378344983915127},{"$f":"Calc_TransProfile!G53","v":153.68415501608487},{"$f":"Calc_TransProfile!I53","v":1.5945360924868832},{"$f":"Calc_TransProfile!J53","v":12.663461932088234},46.783808891428244,141.02069308399663,{"$f":"Calc_TransProfile!L53","v":935.1875},null,{"$f":"Calc_TransProfile!P53","v":3312384544.4533005},{"$f":"Calc_TransProfile!M53","v":483.78344983915127},{"$f":"Calc_TransProfile!N53","v":1844.2098601930184},null,1.4605292451604478E-8,4.6396833747287636E-8,3.2959707344619497E-3,6.8666056967957283E-3,9.6704029265538047E-2,7.6466727636537613E-2,2.8233059521002865E-7,null,3.4333272140892079E-7,8.3333333333333343E-2,9.9999999999999992E-2,null,1.4605289946585856E-8,4.6396825789560474E-8,0.99999965666733748,2.8233054678625345E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A54","v":2042},{"$f":"Calc_TransProfile!H54","v":42.946209014935391},{"$f":"Calc_TransProfile!G54","v":159.11629098506461},{"$f":"Calc_TransProfile!I54","v":1.41549448069313},{"$f":"Calc_TransProfile!J54","v":13.111065961572615},41.530714534242264,146.00522502349199,{"$f":"Calc_TransProfile!L54","v":935.1875},null,{"$f":"Calc_TransProfile!P54","v":3312384484.5763879},{"$f":"Calc_TransProfile!M54","v":429.46209014935391},{"$f":"Calc_TransProfile!N54","v":1909.3954918207753},null,1.2965345422582388E-8,4.8036781879025608E-8,3.2959707344619497E-3,6.8666056967957275E-3,9.6704029265538061E-2,7.6466727636537599E-2,2.8233060031362837E-7,null,3.4333272761523638E-7,8.3333333333333329E-2,0.1,null,1.296534319505873E-8,4.8036773626020034E-8,0.99999965666733137,2.8233055180754766E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931398E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A55","v":2043},{"$f":"Calc_TransProfile!H55","v":37.514073045955655},{"$f":"Calc_TransProfile!G55","v":164.54842695404434},{"$f":"Calc_TransProfile!I55","v":1.236452868899377},{"$f":"Calc_TransProfile!J55","v":13.558669991056998},36.277620177056278,150.98975696298734,{"$f":"Calc_TransProfile!L55","v":935.1875},null,{"$f":"Calc_TransProfile!P55","v":3312384424.6994743},{"$f":"Calc_TransProfile!M55","v":375.14073045955655},{"$f":"Calc_TransProfile!N55","v":1974.5811234485323},null,1.1325398334270705E-8,4.9676730070053227E-8,3.2959707344619501E-3,6.8666056967957275E-3,9.6704029265538047E-2,7.6466727636537599E-2,2.823306054172283E-7,null,3.4333273382155224E-7,8.3333333333333329E-2,9.9999999999999992E-2,null,1.1325396388860416E-8,4.9676721536876828E-8,0.99999965666732515,2.823305569201381E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931368E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A56","v":2044},{"$f":"Calc_TransProfile!H56","v":32.081937076975919},{"$f":"Calc_TransProfile!G56","v":169.98056292302408},{"$f":"Calc_TransProfile!I56","v":1.0574112571056238},{"$f":"Calc_TransProfile!J56","v":14.006274020541381},31.024525819870295,155.9742889024827,{"$f":"Calc_TransProfile!L56","v":935.1875},null,{"$f":"Calc_TransProfile!P56","v":3312384364.8225608},{"$f":"Calc_TransProfile!M56","v":320.81937076975919},{"$f":"Calc_TransProfile!N56","v":2039.766755076289},null,9.6854511866694239E-9,5.1316678320370491E-8,3.2959707344619497E-3,6.8666056967957275E-3,9.6704029265538047E-2,7.6466727636537599E-2,2.8233061052082839E-7,null,3.4333274002786831E-7,8.3333333333333329E-2,9.9999999999999992E-2,null,9.6854495232680543E-9,5.1316669507127691E-8,0.99999965666731894,2.8233056203272855E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A57","v":2045},{"$f":"Calc_TransProfile!H57","v":26.649801107996211},{"$f":"Calc_TransProfile!G57","v":175.41269889200379},{"$f":"Calc_TransProfile!I57","v":0.87836964531187156},{"$f":"Calc_TransProfile!J57","v":14.453878050025763},25.77143146268434,160.95882084197802,{"$f":"Calc_TransProfile!L57","v":935.1875},null,{"$f":"Calc_TransProfile!P57","v":3312384304.9456477},{"$f":"Calc_TransProfile!M57","v":266.49801107996211},{"$f":"Calc_TransProfile!N57","v":2104.9523867040452},null,8.0455039797785496E-9,5.2956626629977375E-8,3.2959707344619497E-3,6.8666056967957283E-3,9.6704029265538047E-2,7.6466727636537613E-2,2.8233061562442869E-7,null,3.433327462341846E-7,8.3333333333333343E-2,9.9999999999999992E-2,null,8.0455025982816514E-9,5.295661753677257E-8,0.99999965666731272,2.8233056714531904E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A58","v":2046},{"$f":"Calc_TransProfile!H58","v":21.217665139016475},{"$f":"Calc_TransProfile!G58","v":180.84483486098353},{"$f":"Calc_TransProfile!I58","v":0.69932803351811834},{"$f":"Calc_TransProfile!J58","v":14.901482079510146},20.518337105498357,165.94335278147338,{"$f":"Calc_TransProfile!L58","v":935.1875},null,{"$f":"Calc_TransProfile!P58","v":3312384245.0687346},{"$f":"Calc_TransProfile!M58","v":212.17665139016475},{"$f":"Calc_TransProfile!N58","v":2170.1380183318024},null,6.4055567135980599E-9,5.4596574998873912E-8,3.2959707344619497E-3,6.8666056967957275E-3,9.6704029265538061E-2,7.6466727636537599E-2,2.8233062072802915E-7,null,3.4333275244050115E-7,8.3333333333333329E-2,0.1,null,6.4055556139011873E-9,5.4596565625811512E-8,0.9999996566673065,2.8233057225790949E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931398E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A59","v":2047},{"$f":"Calc_TransProfile!H59","v":15.785529170036739},{"$f":"Calc_TransProfile!G59","v":186.27697082996326},{"$f":"Calc_TransProfile!I59","v":0.52028642172436523},{"$f":"Calc_TransProfile!J59","v":15.349086108994529},15.265242748312374,170.92788472096873,{"$f":"Calc_TransProfile!L59","v":935.1875},null,{"$f":"Calc_TransProfile!P59","v":3312384185.1918216},{"$f":"Calc_TransProfile!M59","v":157.85529170036739},{"$f":"Calc_TransProfile!N59","v":2235.3236499595591},null,4.7656093881279629E-9,5.6236523427060102E-8,3.2959707344619497E-3,6.8666056967957283E-3,9.6704029265538061E-2,7.6466727636537613E-2,2.8233062583162976E-7,null,3.4333275864681785E-7,8.3333333333333343E-2,0.1,null,4.7656085701266754E-9,5.6236513774244517E-8,0.99999965666730029,2.8233057737049993E-7,9.2026051112347351E-2,0.90483741803595952,3.1365308516931398E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A60","v":2048},{"$f":"Calc_TransProfile!H60","v":10.353393201057003},{"$f":"Calc_TransProfile!G60","v":191.709106798943},{"$f":"Calc_TransProfile!I60","v":0.34124480993061207},{"$f":"Calc_TransProfile!J60","v":15.79669013847891},10.01214839112639,175.91241666046409,{"$f":"Calc_TransProfile!L60","v":935.1875},null,{"$f":"Calc_TransProfile!P60","v":3312384125.314908},{"$f":"Calc_TransProfile!M60","v":103.53393201057003},{"$f":"Calc_TransProfile!N60","v":2300.5092815873159},null,3.1256620033682558E-9,5.787647191453595E-8,3.2959707344619497E-3,6.8666056967957275E-3,9.6704029265538047E-2,7.6466727636537613E-2,2.8233063093523065E-7,null,3.4333276485313488E-7,8.3333333333333343E-2,9.9999999999999992E-2,null,3.1256614669581139E-9,5.7876461982071565E-8,0.99999965666729407,2.8233058248309037E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931364E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631096E-3,1]
[{"$f":"Calc_TransProfile!A61","v":2049},{"$f":"Calc_TransProfile!H61","v":4.9212572320772949},{"$f":"Calc_TransProfile!G61","v":197.14124276792271},{"$f":"Calc_TransProfile!I61","v":0.16220319813685985},{"$f":"Calc_TransProfile!J61","v":16.244294167963293},4.7590540339404352,180.89694859995942,{"$f":"Calc_TransProfile!L61","v":935.1875},null,{"$f":"Calc_TransProfile!P61","v":3312384065.4379954},{"$f":"Calc_TransProfile!M61","v":49.212572320772949},{"$f":"Calc_TransProfile!N61","v":2365.6949132150726},null,1.4857145593189413E-9,5.9516420461301425E-8,3.2959707344619501E-3,6.8666056967957283E-3,9.6704029265538047E-2,7.6466727636537599E-2,2.8233063603883158E-7,null,3.4333277105945196E-7,8.3333333333333329E-2,9.9999999999999992E-2,null,1.4857143043955106E-9,5.9516410249292656E-8,0.99999965666728785,2.8233058759568082E-7,9.202605111234724E-2,0.90483741803595963,3.1365308516931368E-3,7.3367303634713596E-2,0.92004441462932329,6.5882817359631104E-3,1]
[{"$f":"Calc_TransProfile!A62","v":2050},{"$f":"Calc_TransProfile!H62","v":0},{"$f":"Calc_TransProfile!G62","v":202.0625},{"$f":"Calc_TransProfile!I62","v":0},{"$f":"Calc_TransProfile!J62","v":16.649802163305445},0,185.41269783669455,{"$f":"Calc_TransProfile!L62","v":935.1875},null,{"$f":"Calc_TransProfile!P62","v":3312384011.1923552},{"$f":"Calc_TransProfile!M62","v":0},{"$f":"Calc_TransProfile!N62","v":2424.75},null,0,6.1002136019628886E-8,{"$error":"#DIV/0!"},6.8666056967957292E-3,{"$error":"#DIV/0!"},7.6466727636537599E-2,2.8233064066245193E-7,null,3.433327766820808E-7,8.3333333333333329E-2,{"$error":"#DIV/0!"},null,0,6.1002125539990382E-8,0.9999996566672823,2.8233059216049373E-7,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},7.3367303634713596E-2,0.92004441462932329,6.5882817359631113E-3,1]

{"sheet":"Calc_Matrix","index":7,"n_rows":312,"n_cols":13,"rows_kept":312,"cut":false,"hidden":false,"merged":[[5,0,5,5],[5,7,5,12]]}
["Matrix Calculations"]
["This worksheet calculates the 1 year transition matrix based on the user inputs and data "]
[]
[{"$f":"Input_Scen!A14","v":"Days in a year"},{"$f":"Input_Scen!B14","v":365}]
[]
["Daily Transition Probability Matrix in Year X",null,null,null,null,null,null,"Transition Probability Matrix For Year X"]
[]
["Year",{"$f":"Input_Scen!B13","v":2017},null,null,null,null,null,null,"Qx",{"$f":"L12","v":1.0388009505209066E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B8,[1]TransProb!$A$12:$A$45)","v":1}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A12&B11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666748647},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A12&C11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":5.3963994099300873E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A12&D11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.0380951644938732E-9},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A12&E11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233042426667511E-7},{"$f":"SUM(B12:E12)","v":1},null,"H",{"$f":"powermatrix(B12:E15,$B$4)","v":0.99989546487479697},5.6701398044611598E-7,8.8016171239673952E-8,1.0388009505209066E-4,{"$f":"SUM(I12:L12)","v":1.0000000000000007}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A13&B11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A13&C11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A13&D11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A13&E11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B13:E13)","v":1},null,"S",0.96694209568571776,5.483270061085725E-7,8.511543862572929E-8,3.3057270871838115E-2,{"$f":"SUM(I13:L13)","v":1.0000000000000007}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A14&B11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A14&C11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A14&D11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A14&E11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B14:E14)","v":1},null,"R",0.91750807699834236,5.2029429585948346E-7,8.0764052381848605E-8,8.2491321943310145E-2,{"$f":"SUM(I14:L14)","v":1.0000000000000007}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A15&B11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A15&C11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A15&D11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B9,MATCH(A15&E11,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B15:E15)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I15:L15)","v":1}]
[]
["Year",{"$f":"B8+1","v":2018},null,null,null,null,null,null,"Qx",{"$f":"L21","v":1.0390856523715773E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B17,[1]TransProb!$A$12:$A$45)","v":2}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A21&B20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666748025},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A21&C20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":5.2324048776362885E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A21&D20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":8.6780415920903435E-9},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A21&E20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.823304293792656E-7},{"$f":"SUM(B21:E21)","v":1},null,"H",{"$f":"powermatrix(B21:E24,$B$4)","v":0.99989543312732532},5.4978262354765495E-7,1.0852481438028885E-7,1.0390856523715773E-4,{"$f":"SUM(I21:L21)","v":1.0000000000000004}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A22&B20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A22&C20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A22&D20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A22&E20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931398E-3},{"$f":"SUM(B22:E22)","v":1},null,"S",0.96694206580842157,5.3166354029313557E-7,1.0494818231153527E-7,3.3057297579856287E-2,{"$f":"SUM(I22:L22)","v":1.0000000000000004}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A23&B20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A23&C20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A23&D20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A23&E20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B23:E23)","v":1},null,"R",0.91750804879718095,5.0448273437549261E-7,9.9582865439559316E-8,8.2491347137219784E-2,{"$f":"SUM(I23:L23)","v":1.0000000000000004}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A24&B20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A24&C20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A24&D20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B18,MATCH(A24&E20,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B24:E24)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I24:L24)","v":1}]
[]
["Year",{"$f":"B17+1","v":2019},null,null,null,null,null,null,"Qx",{"$f":"L30","v":1.0393703542233593E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B26,[1]TransProb!$A$12:$A$45)","v":3}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A30&B29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666747404},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A30&C29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":5.0684103394030855E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A30&D29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.0317988079080858E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A30&E29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233043449185605E-7},{"$f":"SUM(B30:E30)","v":1},null,"H",{"$f":"powermatrix(B30:E33,$B$4)","v":0.99989540137985222},5.3255126708998076E-7,1.2903345700293084E-7,1.0393703542233593E-4,{"$f":"SUM(I30:L30)","v":0.99999999999999867}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A31&B29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A31&C29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A31&D29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A31&E29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B31:E31)","v":1},null,"S",0.96694203593112382,5.1500007487556239E-7,1.2478092553023598E-7,3.3057324287874626E-2,{"$f":"SUM(I31:L31)","v":0.99999999999999889}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A32&B29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A32&C29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A32&D29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A32&E29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B32:E32)","v":1},null,"R",0.9175080205960181,4.8867117326390096E-7,1.1840167806014442E-7,8.2491372331129506E-2,{"$f":"SUM(I32:L32)","v":0.99999999999999889}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A33&B29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A33&C29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A33&D29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B27,MATCH(A33&E29,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B33:E33)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I33:L33)","v":1}]
[]
["Year",{"$f":"B26+1","v":2020},null,null,null,null,null,null,"Qx",{"$f":"L39","v":1.0396550560762239E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B35,[1]TransProb!$A$12:$A$45)","v":4}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A39&B38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666746782},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A39&C38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.9044157952304789E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A39&D38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.1957934625465426E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A39&E38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233043960444654E-7},{"$f":"SUM(B39:E39)","v":1},null,"H",{"$f":"powermatrix(B39:E42,$B$4)","v":0.99989536963238179},5.1531991107309035E-7,1.4954209910759988E-7,1.0396550560762239E-4,{"$f":"SUM(I39:L39)","v":0.99999999999999967}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A40&B38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A40&C38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A40&D38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A40&E38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B40:E40)","v":1},null,"S",0.96694200605382863,4.9833660985585022E-7,1.4461366828183125E-7,3.3057350995893034E-2,{"$f":"SUM(I40:L40)","v":0.99999999999999978}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A41&B38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A41&C38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A41&D38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A41&E38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},1,null,"R",0.91750799239485736,4.7285961252470497E-7,1.372204902436037E-7,8.2491397525039395E-2,{"$f":"SUM(I41:L41)","v":0.99999999999999956}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A42&B38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A42&C38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A42&D38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B36,MATCH(A42&E38,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I42:L42)","v":1}]
[]
["Year",{"$f":"B35+1","v":2021},null,null,null,null,null,null,"Qx",{"$f":"L48","v":1.0399397579301531E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B44,[1]TransProb!$A$12:$A$45)","v":5}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A48&B47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.9999996566674616},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A48&C47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.7404212451184653E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A48&D47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.3597881231244045E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A48&E47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233044471703693E-7},{"$f":"SUM(B48:E48)","v":1},null,"H",{"$f":"powermatrix(B48:E51,$B$4)","v":0.99989533788490936},4.9808855549698285E-7,1.7005074069429689E-7,1.0399397579301531E-4,{"$f":"SUM(I48:L48)","v":0.99999999999999856}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A49&B47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A49&C47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A49&D47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A49&E47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931398E-3},{"$f":"SUM(B49:E49)","v":1},null,"S",0.96694197617653144,4.8167314523399801E-7,1.6444641056632204E-7,3.3057377703911581E-2,{"$f":"SUM(I49:L49)","v":0.99999999999999889}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A50&B47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A50&C47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A50&D47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A50&E47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631087E-3},{"$f":"SUM(B50:E50)","v":1},null,"R",0.9175079641936954,4.5704805215790405E-7,1.5603930198993822E-7,8.2491422718949353E-2,{"$f":"SUM(I50:L50)","v":0.999999999999999}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A51&B47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A51&C47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A51&D47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B45,MATCH(A51&E47,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B51:E51)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I51:L51)","v":1}]
[]
["Year",{"$f":"B44+1","v":2022},null,null,null,null,null,null,"Qx",{"$f":"L57","v":1.0402244594488282E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B53,[1]TransProb!$A$12:$A$45)","v":6}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A57&B56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666745549},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A57&C56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.5764266875871823E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A57&D56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.5237827891489304E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A57&E56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233044973833115E-7},{"$f":"SUM(B57:E57)","v":0.99999999999999989},null,"H",{"$f":"powermatrix(B57:E60,$B$4)","v":0.99989530613747424},4.8085720020618538E-7,1.905593817014052E-7,1.0402244594488282E-4,{"$f":"SUM(I57:L57)","v":1.0000000000000011}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A58&B56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A58&C56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A58&D56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A58&E56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B58:E58)","v":1},null,"S",0.96694194629926922,4.6500968085965629E-7,1.8427915232412229E-7,3.305740441189868E-2,{"$f":"SUM(I58:L58)","v":1.0000000000000011}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A59&B56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A59&C56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A59&D56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A59&E56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B59:E59)","v":1},null,"R",0.91750793599256575,4.4123649202083545E-7,1.7485811324260803E-7,8.2491447912829668E-2,{"$f":"SUM(I59:L59)","v":1.0000000000000007}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A60&B56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A60&C56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A60&D56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B54,MATCH(A60&E56,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B60:E60)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I60:L60)","v":1}]
[]
["Year",{"$f":"B53+1","v":2023},null,null,null,null,null,null,"Qx",{"$f":"L66","v":1.0405091613048604E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B62,[1]TransProb!$A$12:$A$45)","v":7}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A66&B65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666744928},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A66&C65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.4124321256493903E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A66&D65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.6877774615525722E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A66&E65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233045485092159E-7},{"$f":"SUM(B66:E66)","v":1},null,"H",{"$f":"powermatrix(B66:E69,$B$4)","v":0.99989527439000125},4.636258455172206E-7,2.1106802224552414E-7,1.0405091613048604E-4,{"$f":"SUM(I66:L66)","v":0.99999999999999956}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A67&B65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A67&C65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A67&D65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A67&E65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931398E-3},{"$f":"SUM(B67:E67)","v":1},null,"S",0.96694191642197136,4.4834621703891725E-7,2.0411189366798877E-7,3.3057431119917484E-2,{"$f":"SUM(I67:L67)","v":0.99999999999999956}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A68&B65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A68&C65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A68&D65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A68&E65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},1,null,"R",0.91750790779140301,4.254249324039425E-7,1.9367692410860525E-7,8.2491473106739877E-2,{"$f":"SUM(I68:L68)","v":0.99999999999999933}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A69&B65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A69&C65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A69&D65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B63,MATCH(A69&E65,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I69:L69)","v":1}]
[]
["Year",{"$f":"B62+1","v":2024},null,null,null,null,null,null,"Qx",{"$f":"L75","v":1.0407938631619601E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B71,[1]TransProb!$A$12:$A$45)","v":8}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A75&B74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666744306},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A75&C74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.2484375577721927E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A75&D74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.8517721398956182E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A75&E74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233045996351203E-7},{"$f":"SUM(B75:E75)","v":1},null,"H",{"$f":"powermatrix(B75:E78,$B$4)","v":0.9998952426425296},4.4639449126904064E-7,2.3157666227166988E-7,1.0407938631619601E-4,{"$f":"SUM(I75:L75)","v":0.99999999999999933}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A76&B74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A76&C74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A76&D74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A76&E74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B76:E76)","v":1},null,"S",0.96694188654467506,4.3168275361604012E-7,2.2394463454474966E-7,3.3057457827936405E-2,{"$f":"SUM(I76:L76)","v":0.99999999999999967}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A77&B74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A77&C74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A77&D74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A77&E74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631087E-3},{"$f":"SUM(B77:E77)","v":1},null,"R",0.91750787959024183,4.0961337315944631E-7,2.1249573453747675E-7,8.2491498300650223E-2,{"$f":"SUM(I77:L77)","v":0.99999999999999978}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A78&B74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A78&C74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A78&D74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B72,MATCH(A78&E74,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B78:E78)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I78:L78)","v":1}]
[]
["Year",{"$f":"B71+1","v":2025},null,null,null,null,null,null,"Qx",{"$f":"L84","v":1.041078565020164E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B80,[1]TransProb!$A$12:$A$45)","v":9}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A84&B83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666743684},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A84&C83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.0844429839555896E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A84&D83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.0157668241780699E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A84&E83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233046507610253E-7},{"$f":"SUM(B84:E84)","v":1},null,"H",{"$f":"powermatrix(B84:E87,$B$4)","v":0.99989521089505884},4.2916313746164498E-7,2.5208530177984325E-7,1.041078565020164E-4,{"$f":"SUM(I84:L84)","v":1}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A85&B83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A85&C83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A85&D83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A85&E83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931368E-3},{"$f":"SUM(B85:E85)","v":1},null,"S",0.96694185666737931,4.1501929059102432E-7,2.4377737495440568E-7,3.3057484535955445E-2,{"$f":"SUM(I85:L85)","v":1.0000000000000002}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A86&B83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A86&C83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A86&D83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A86&E83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B86:E86)","v":1},null,"R",0.91750785138908064,3.9380181428734657E-7,2.3131454452922287E-7,8.2491523494560695E-2,{"$f":"SUM(I86:L86)","v":1.0000000000000002}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A87&B83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A87&C83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A87&D83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B81,MATCH(A87&E83,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B87:E87)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I87:L87)","v":1}]
[]
["Year",{"$f":"B80+1","v":2026},null,null,null,null,null,null,"Qx",{"$f":"L93","v":1.041363266879455E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B89,[1]TransProb!$A$12:$A$45)","v":10}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A93&B92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666743063},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A93&C92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.9204484041995821E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A93&D92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.1797615143999255E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A93&E92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233047018869297E-7},{"$f":"SUM(B93:E93)","v":1},null,"H",{"$f":"powermatrix(B93:E96,$B$4)","v":0.99989517914758719},4.1193178409503484E-7,2.7259394077004107E-7,1.041363266879455E-4,{"$f":"SUM(I93:L93)","v":1}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A94&B92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A94&C92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A94&D92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A94&E92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931368E-3},{"$f":"SUM(B94:E94)","v":1},null,"S",0.96694182679008234,3.9835582796387101E-7,2.63610114896954E-7,3.3057511243974616E-2,{"$f":"SUM(I94:L94)","v":0.99999999999999978}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A95&B92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A95&C92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A95&D92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A95&E92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},1,null,"R",0.91750782318791879,3.7799025578764433E-7,2.5013335408384114E-7,8.2491548688471292E-2,{"$f":"SUM(I95:L95)","v":0.99999999999999989}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A96&B92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A96&C92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A96&D92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B90,MATCH(A96&E92,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I96:L96)","v":1}]
[]
["Year",{"$f":"B89+1","v":2027},null,null,null,null,null,null,"Qx",{"$f":"L102","v":1.0416479687398119E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B98,[1]TransProb!$A$12:$A$45)","v":11}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A102&B101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666742441},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A102&C101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.7564538185041697E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A102&D101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.3437562105611867E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A102&E101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233047530128336E-7},{"$f":"SUM(B102:E102)","v":1},null,"H",{"$f":"powermatrix(B102:E105,$B$4)","v":0.99989514740011576},3.9470043116920943E-7,2.9310257924226692E-7,1.0416479687398119E-4,{"$f":"SUM(I102:L102)","v":1}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A103&B101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A103&C101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A103&D101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A103&E101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931368E-3},{"$f":"SUM(B103:E103)","v":1},null,"S",0.96694179691278614,3.8169236573457945E-7,2.8344285437239764E-7,3.3057537951993905E-2,{"$f":"SUM(I103:L103)","v":1.0000000000000002}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A104&B101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A104&C101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A104&D101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A104&E101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},{"$f":"SUM(B104:E104)","v":1},null,"R",0.9175077949867575,3.6217869766033901E-7,2.6895216320133454E-7,8.2491573882381999E-2,{"$f":"SUM(I104:L104)","v":1.0000000000000004}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A105&B101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A105&C101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A105&D101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B99,MATCH(A105&E101,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B105:E105)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I105:L105)","v":1}]
[]
["Year",{"$f":"B98+1","v":2028},null,null,null,null,null,null,"Qx",{"$f":"L111","v":1.0419326706012805E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B107,[1]TransProb!$A$12:$A$45)","v":12}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A111&B110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666741819},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A111&C110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.5924592268693517E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A111&D110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.5077509126618532E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A111&E110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233048041387386E-7},{"$f":"SUM(B111:E111)","v":1},null,"H",{"$f":"powermatrix(B111:E114,$B$4)","v":0.999895115652644},3.7746907868416936E-7,3.1361121719651941E-7,1.0419326706012805E-4,{"$f":"SUM(I111:L111)","v":1}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A112&B110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A112&C110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A112&D110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A112&E110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931368E-3},{"$f":"SUM(B112:E112)","v":1},null,"S",0.96694176703548917,3.6502890390315044E-7,3.0327559338073575E-7,3.3057564660013333E-2,{"$f":"SUM(I112:L112)","v":0.99999999999999978}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A113&B110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A113&C110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A113&D110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A113&E110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B113:E113)","v":1},null,"R",0.91750776678559531,3.4636713990543099E-7,2.877709718817016E-7,8.2491599076292832E-2,{"$f":"SUM(I113:L113)","v":0.99999999999999978}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A114&B110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A114&C110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A114&D110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B108,MATCH(A114&E110,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B114:E114)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I114:L114)","v":1}]
[]
["Year",{"$f":"B107+1","v":2029},null,null,null,null,null,null,"Qx",{"$f":"L120","v":1.0422173724638114E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B116,[1]TransProb!$A$12:$A$45)","v":13}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A120&B119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666741197},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A120&C119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.4284646292951293E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A120&D119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.6717456207019236E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A120&E119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.823304855264643E-7},{"$f":"SUM(B120:E120)","v":1},null,"H",{"$f":"powermatrix(B120:E123,$B$4)","v":0.99989508390517168},3.602377266399135E-7,3.3411985463279743E-7,1.0422173724638114E-4,{"$f":"SUM(I120:L120)","v":0.99999999999999933}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A121&B119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A121&C119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A121&D119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A121&E119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931403E-3},{"$f":"SUM(B121:E121)","v":1},null,"S",0.96694173715819198,3.4836544246958254E-7,3.2310833192196727E-7,3.3057591368032872E-2,{"$f":"SUM(I121:L121)","v":0.99999999999999922}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A122&B119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A122&C119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A122&D119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A122&E119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},1,null,"R",0.91750773858443291,3.3055558252291926E-7,3.0658978012494217E-7,8.2491624270203762E-2,{"$f":"SUM(I122:L122)","v":0.99999999999999933}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A123&B119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A123&C119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A123&D119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B117,MATCH(A123&E119,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I123:L123)","v":1}]
[]
["Year",{"$f":"B116+1","v":2030},null,null,null,null,null,null,"Qx",{"$f":"L129","v":1.0425020743274471E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B125,[1]TransProb!$A$12:$A$45)","v":14}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A129&B128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666740576},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A129&C128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.2644700257815014E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A129&D128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8357403346814E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A129&E128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.823304906390548E-7},{"$f":"SUM(B129:E129)","v":1},null,"H",{"$f":"powermatrix(B129:E132,$B$4)","v":0.99989505215770091},3.4300637503644378E-7,3.5462849155110269E-7,1.0425020743274471E-4,{"$f":"SUM(I129:L129)","v":1.0000000000000002}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A130&B128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A130&C128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A130&D128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A130&E128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931403E-3},{"$f":"SUM(B130:E130)","v":1},null,"S",0.96694170728089623,3.3170198143387778E-7,3.4294106999609305E-7,3.3057618076052543E-2,{"$f":"SUM(I130:L130)","v":1.0000000000000002}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A131&B128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A131&C128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A131&D128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A131&E128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B131:E131)","v":1},null,"R",0.91750771038327195,3.1474402551280562E-7,3.2540858793105656E-7,8.249164946411483E-2,{"$f":"SUM(I131:L131)","v":1.0000000000000002}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A132&B128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A132&C128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A132&D128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B126,MATCH(A132&E128,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B132:E132)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I132:L132)","v":1}]
[]
["Year",{"$f":"B125+1","v":2031},null,null,null,null,null,null,"Qx",{"$f":"L138","v":1.0427867761921683E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B134,[1]TransProb!$A$12:$A$45)","v":15}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A138&B137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666739954},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A138&C137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1004754163284692E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A138&D137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.9997350546002817E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A138&E137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233049575164524E-7},{"$f":"SUM(B138:E138)","v":1},null,"H",{"$f":"powermatrix(B138:E141,$B$4)","v":0.99989502041022971},3.2577502387375964E-7,3.7513712795143438E-7,1.0427867761921683E-4,{"$f":"SUM(I138:L138)","v":1.0000000000000007}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A139&B137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A139&C137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A139&D137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A139&E137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B139:E139)","v":1},null,"S",0.96694167740360004,3.1503852079603571E-7,3.6277380760311324E-7,3.3057644784072332E-2,{"$f":"SUM(I139:L139)","v":1.0000000000000007}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A140&B137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A140&C137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A140&D137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A140&E137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},{"$f":"SUM(B140:E140)","v":1},null,"R",0.91750768218211098,2.989324688750898E-7,3.4422739530004494E-7,8.2491674658026024E-2,{"$f":"SUM(I140:L140)","v":1.0000000000000011}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A141&B137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A141&C137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A141&D137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B135,MATCH(A141&E137,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B141:E141)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I141:L141)","v":1}]
[]
["Year",{"$f":"B134+1","v":2032},null,null,null,null,null,null,"Qx",{"$f":"L147","v":1.0430714777206897E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B143,[1]TransProb!$A$12:$A$45)","v":16}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A147&B146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666739343},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A147&C146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.9364807999864723E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A147&D146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1637297794355233E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A147&E146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.823305007729394E-7},{"$f":"SUM(B147:E147)","v":1},null,"H",{"$f":"powermatrix(B147:E150,$B$4)","v":0.99989498866279114},3.0854367305209726E-7,3.9564576370586613E-7,1.0430714777206897E-4,{"$f":"SUM(I147:L147)","v":1}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A148&B146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A148&C146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A148&D146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A148&E146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B148:E148)","v":1},null,"S",0.96694164752633394,2.9837506045957994E-7,3.8260654461931652E-7,3.305767149206057E-2,{"$f":"SUM(I148:L148)","v":0.99999999999999956}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A149&B146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A149&C146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A149&D146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A149&E146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},1,null,"R",0.91750765398097756,2.8312091251822734E-7,3.6304620211452086E-7,8.2491699851907407E-2,{"$f":"SUM(I149:L149)","v":0.99999999999999956}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A150&B146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A150&C146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A150&D146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B144,MATCH(A150&E146,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I150:L150)","v":1}]
[]
["Year",{"$f":"B143+1","v":2033},null,null,null,null,null,null,"Qx",{"$f":"L156","v":1.0433561795874804E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B152,[1]TransProb!$A$12:$A$45)","v":17}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A156&B155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666738722},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A156&C155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.7724861787076597E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A156&D155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.3277245111801834E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A156&E155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.823305058855299E-7},{"$f":"SUM(B156:E156)","v":0.99999999999999989},null,"H",{"$f":"powermatrix(B156:E159,$B$4)","v":0.9998949569153186},2.9131232277655434E-7,4.1615439906361842E-7,1.0433561795874804E-4,{"$f":"SUM(I156:L156)","v":0.99999999999999922}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A157&B155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A157&C155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A157&D155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A157&E155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931398E-3},{"$f":"SUM(B157:E157)","v":1},null,"S",0.96694161764903697,2.8171160062284962E-7,4.0243928128571108E-7,3.3057698200080601E-2,{"$f":"SUM(I157:L157)","v":0.99999999999999944}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A158&B155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A158&C155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A158&D155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A158&E155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B158:E158)","v":1},null,"R",0.91750762577981526,2.6730935663041779E-7,3.8186500860317085E-7,8.2491725045818864E-2,{"$f":"SUM(I158:L158)","v":0.99999999999999933}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A159&B155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A159&C155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A159&D155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B153,MATCH(A159&E155,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B159:E159)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I159:L159)","v":1}]
[]
["Year",{"$f":"B152+1","v":2034},null,null,null,null,null,null,"Qx",{"$f":"L165","v":1.0436408814553676E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B161,[1]TransProb!$A$12:$A$45)","v":18}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A165&B164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.999999656667381},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A165&C164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.6084915514894422E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A165&D164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.4917192488642497E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A165&E164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233051099812029E-7},{"$f":"SUM(B165:E165)","v":1},null,"H",{"$f":"powermatrix(B165:E168,$B$4)","v":0.99989492516784761},2.7408097294179747E-7,4.3666303390339742E-7,1.0436408814553676E-4,{"$f":"SUM(I165:L165)","v":1}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A166&B164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A166&C164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A166&D164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A166&E164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931403E-3},{"$f":"SUM(B166:E166)","v":1},null,"S",0.966941587771741,2.6504814118398227E-7,4.2227201748499978E-7,3.3057724908100765E-2,{"$f":"SUM(I166:L166)","v":1.0000000000000004}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A167&B164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A167&C164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A167&D164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A167&E164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B167:E167)","v":1},null,"R",0.9175075975786543,2.5149780111500612E-7,4.0068381465469477E-7,8.2491750239730405E-2,{"$f":"SUM(I167:L167)","v":1.0000000000000004}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A168&B164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A168&C164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A168&D164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B162,MATCH(A168&E164,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B168:E168)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I168:L168)","v":1}]
[]
["Year",{"$f":"B161+1","v":2035},null,null,null,null,null,null,"Qx",{"$f":"L174","v":1.0439255833243251E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B170,[1]TransProb!$A$12:$A$45)","v":19}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A174&B173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666737478},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A174&C173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.444496918331821E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A174&D173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.6557139924877203E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A174&E173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233051611071079E-7},{"$f":"SUM(B174:E174)","v":0.99999999999999989},null,"H",{"$f":"powermatrix(B174:E177,$B$4)","v":0.99989489342037552},2.5684962354782532E-7,4.5717166822520205E-7,1.0439255833243251E-4,{"$f":"SUM(I174:L174)","v":0.99999999999999967}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A175&B173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A175&C173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A175&D173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A175&E173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B175:E175)","v":1},null,"S",0.96694155789444325,2.4838468214297677E-7,4.421047532171819E-7,3.3057751616121046E-2,{"$f":"SUM(I175:L175)","v":0.99999999999999967}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A176&B173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A176&C173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A176&D173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A176&E173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},1,null,"R",0.91750756937749123,2.356862459719913E-7,4.1950262026909172E-7,8.249177543364207E-2,{"$f":"SUM(I176:L176)","v":0.99999999999999956}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A177&B173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A177&C173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A177&D173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B171,MATCH(A177&E173,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I177:L177)","v":1}]
[]
["Year",{"$f":"B170+1","v":2036},null,null,null,null,null,null,"Qx",{"$f":"L183","v":1.0442102851943846E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B179,[1]TransProb!$A$12:$A$45)","v":20}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A183&B182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666736856},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A183&C182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.2805022792347939E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A183&D182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.8197087420505965E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A183&E182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233052122330123E-7},{"$f":"SUM(B183:E183)","v":0.99999999999999989},null,"H",{"$f":"powermatrix(B183:E186,$B$4)","v":0.99989486167290487},2.39618274594639E-7,4.7768030202903217E-7,1.0442102851943846E-4,{"$f":"SUM(I183:L183)","v":1.0000000000000009}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A184&B182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A184&C182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A184&D182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A184&E182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931368E-3},{"$f":"SUM(B184:E184)","v":1},null,"S",0.96694152801714739,2.3172122349983409E-7,4.6193748848225706E-7,3.3057778324141453E-2,{"$f":"SUM(I184:L184)","v":1.0000000000000009}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A185&B182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A185&C182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A185&D182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A185&E182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631087E-3},{"$f":"SUM(B185:E185)","v":1},null,"R",0.91750754117633027,2.1987469120137427E-7,4.3832142544636159E-7,8.2491800627553874E-2,{"$f":"SUM(I185:L185)","v":1.0000000000000009}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A186&B182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A186&C182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A186&D182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B180,MATCH(A186&E182,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B186:E186)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I186:L186)","v":1}]
[]
["Year",{"$f":"B179+1","v":2037},null,null,null,null,null,null,"Qx",{"$f":"L192","v":1.0444949870655339E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B188,[1]TransProb!$A$12:$A$45)","v":21}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A192&B191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666736235},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A192&C191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.1165076341983619E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A192&D191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.9837034975528757E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A192&E191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233052633589167E-7},{"$f":"SUM(B192:E192)","v":1},null,"H",{"$f":"powermatrix(B192:E195,$B$4)","v":0.99989482992543266},2.2238692608223863E-7,4.9818893531488899E-7,1.0444949870655339E-4,{"$f":"SUM(I192:L192)","v":1.0000000000000007}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A193&B191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A193&C191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A193&D191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A193&E191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931398E-3},{"$f":"SUM(B193:E193)","v":1},null,"S",0.9669414981398502,2.1505776525455433E-7,4.8177022328022652E-7,3.305780503216197E-2,{"$f":"SUM(I193:L193)","v":1.0000000000000007}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A194&B191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A194&C191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A194&D191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A194&E191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B194:E194)","v":1},null,"R",0.91750751297516775,2.040631368031553E-7,4.5714023018650534E-7,8.2491825821465761E-2,{"$f":"SUM(I194:L194)","v":1.0000000000000007}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A195&B191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A195&C191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A195&D191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B189,MATCH(A195&E191,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B195:E195)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I195:L195)","v":1}]
[]
["Year",{"$f":"B188+1","v":2038},null,null,null,null,null,null,"Qx",{"$f":"L201","v":1.0447796889377487E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B197,[1]TransProb!$A$12:$A$45)","v":22}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A201&B200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666735613},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A201&C200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.9525129832225249E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A201&D200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.1476982589945619E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A201&E200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233053144848217E-7},{"$f":"SUM(B201:E201)","v":1},null,"H",{"$f":"powermatrix(B201:E204,$B$4)","v":0.99989479817795979},2.0515557801062335E-7,5.1869756808277055E-7,1.0447796889377487E-4,{"$f":"SUM(I201:L201)","v":0.99999999999999967}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A202&B200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A202&C200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A202&D200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A202&E200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931407E-3},{"$f":"SUM(B202:E202)","v":1},null,"S",0.96694146826255212,1.9839430740713663E-7,5.0160295761108856E-7,3.3057831740182626E-2,{"$f":"SUM(I202:L202)","v":0.99999999999999978}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A203&B200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A203&C200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A203&D200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A203&E200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},1,null,"R",0.91750748477400446,1.8825158277733334E-7,4.7595903448952165E-7,8.2491851015377801E-2,{"$f":"SUM(I203:L203)","v":0.99999999999999956}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A204&B200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A204&C200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A204&D200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B198,MATCH(A204&E200,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I204:L204)","v":1}]
[]
["Year",{"$f":"B197+1","v":2039},null,null,null,null,null,null,"Qx",{"$f":"L210","v":1.0450643908110767E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B206,[1]TransProb!$A$12:$A$45)","v":23}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A210&B209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666734991},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A210&C209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.7885183263072833E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A210&D209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.3116930263756523E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A210&E209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233053656107261E-7},{"$f":"SUM(B210:E210)","v":1},null,"H",{"$f":"powermatrix(B210:E213,$B$4)","v":0.99989476643048902},1.8792423037979469E-7,5.3920620033267897E-7,1.0450643908110767E-4,{"$f":"SUM(I210:L210)","v":1.0000000000000009}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A211&B209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A211&C209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A211&D209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A211&E209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B211:E211)","v":1},null,"S",0.96694143838525592,1.8173084995758267E-7,5.2143569147484495E-7,3.3057858448203407E-2,{"$f":"SUM(I211:L211)","v":1.0000000000000007}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A212&B209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A212&C209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A212&D209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A212&E209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},{"$f":"SUM(B212:E212)","v":1},null,"R",0.91750745657284338,1.7244002912390999E-7,4.9477783835541172E-7,8.2491876209289938E-2,{"$f":"SUM(I212:L212)","v":1.0000000000000009}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A213&B209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A213&C209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A213&D209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B207,MATCH(A213&E209,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B213:E213)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I213:L213)","v":1}]
[]
["Year",{"$f":"B206+1","v":2040},null,null,null,null,null,null,"Qx",{"$f":"L219","v":1.0453490926854652E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B215,[1]TransProb!$A$12:$A$45)","v":24}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A219&B218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666734369},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A219&C218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.6245236634526377E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A219&D218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.475687799696147E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A219&E218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.82330541673663E-7},{"$f":"SUM(B219:E219)","v":1},null,"H",{"$f":"powermatrix(B219:E222,$B$4)","v":0.99989473468301671},1.7069288318975172E-7,5.5971483206461171E-7,1.0453490926854652E-4,{"$f":"SUM(I219:L219)","v":1.0000000000000004}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A220&B218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A220&C218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A220&D218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A220&E218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931398E-3},{"$f":"SUM(B220:E220)","v":1},null,"S",0.96694140850795851,1.6506739290589125E-7,5.4126842487149296E-7,3.3057885156224313E-2,{"$f":"SUM(I220:L220)","v":1.0000000000000004}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A221&B218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A221&C218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A221&D218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A221&E218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},{"$f":"SUM(B221:E221)","v":1},null,"R",0.91750742837168076,1.5662847584288425E-7,5.1359664178417361E-7,8.2491901403202214E-2,{"$f":"SUM(I221:L221)","v":1.0000000000000007}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A222&B218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A222&C218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A222&D218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B216,MATCH(A222&E218,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B222:E222)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I222:L222)","v":1}]
[]
["Year",{"$f":"B215+1","v":2041},null,null,null,null,null,null,"Qx",{"$f":"L228","v":1.0456337945609561E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B224,[1]TransProb!$A$12:$A$45)","v":25}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A228&B227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666733748},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A228&C227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.4605289946585856E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A228&D227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.6396825789560474E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A228&E227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233054678625345E-7},{"$f":"SUM(B228:E228)","v":1},null,"H",{"$f":"powermatrix(B228:E231,$B$4)","v":0.99989470293554339},1.5346153644049394E-7,5.8022346327856961E-7,1.0456337945609561E-4,{"$f":"SUM(I228:L228)","v":0.99999999999999922}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A229&B227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A229&C227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A229&D227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A229&E227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B229:E229)","v":1},null,"S",0.96694137863066021,1.4840393625206222E-7,5.6110115780103416E-7,3.305791186424533E-2,{"$f":"SUM(I229:L229)","v":0.99999999999999956}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A230&B227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A230&C227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A230&D227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A230&E227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},1,null,"R",0.91750740017051702,1.4081692293425594E-7,5.3241544477580805E-7,8.2491926597114615E-2,{"$f":"SUM(I230:L230)","v":0.99999999999999922}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A231&B227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A231&C227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A231&D227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B225,MATCH(A231&E227,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I231:L231)","v":1}]
[]
["Year",{"$f":"B224+1","v":2042},null,null,null,null,null,null,"Qx",{"$f":"L237","v":1.0459184960993261E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B233,[1]TransProb!$A$12:$A$45)","v":26}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A237&B236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666733137},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A237&C236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.296534319505873E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A237&D236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.8036773626020034E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A237&E236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233055180754766E-7},{"$f":"SUM(B237:E237)","v":1},null,"H",{"$f":"powermatrix(B237:E240,$B$4)","v":0.99989467118810538},1.3623019008797451E-7,6.0073209378031807E-7,1.0459184960993261E-4,{"$f":"SUM(I237:L237)","v":0.99999999999999922}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A238&B236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A238&C236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A238&D236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A238&E236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931398E-3},{"$f":"SUM(B238:E238)","v":1},null,"S",0.96694134875339466,1.3174047995349996E-7,5.8093389007563457E-7,3.305793857223472E-2,{"$f":"SUM(I238:L238)","v":0.99999999999999944}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A239&B236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A239&C236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A239&D236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A239&E236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},{"$f":"SUM(B239:E239)","v":1},null,"R",0.91750737196938448,1.2500537035760695E-7,5.5123424715208397E-7,8.2491951790997164E-2,{"$f":"SUM(I239:L239)","v":0.99999999999999911}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A240&B236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A240&C236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A240&D236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B234,MATCH(A240&E236,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B240:E240)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I240:L240)","v":1}]
[]
["Year",{"$f":"B233+1","v":2043},null,null,null,null,null,null,"Qx",{"$f":"L246","v":1.0462031979769032E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B242,[1]TransProb!$A$12:$A$45)","v":27}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A246&B245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666732515},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A246&C245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.1325396388860416E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A246&D245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.9676721536876828E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A246&E245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.823305569201381E-7},{"$f":"SUM(B246:E246)","v":1},null,"H",{"$f":"powermatrix(B246:E249,$B$4)","v":0.99989463944063539},1.1899884422586046E-7,6.2124072395169901E-7,1.0462031979769032E-4,{"$f":"SUM(I246:L246)","v":1.0000000000000013}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A247&B245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A247&C245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A247&D245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A247&E245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931368E-3},{"$f":"SUM(B247:E247)","v":1},null,"S",0.96694131887609924,1.15077024100785E-7,6.0076662206455257E-7,3.3057965280255987E-2,{"$f":"SUM(I247:L247)","v":1.0000000000000016}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A248&B245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A248&C245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A248&D245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A248&E245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},{"$f":"SUM(B248:E248)","v":1},null,"R",0.91750734376822396,1.0919381819888714E-7,5.7005304926338224E-7,8.2491976984909759E-2,{"$f":"SUM(I248:L248)","v":1.0000000000000011}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A249&B245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A249&C245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A249&D245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B243,MATCH(A249&E245,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B249:E249)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I249:L249)","v":1}]
[]
["Year",{"$f":"B242+1","v":2044},null,null,null,null,null,null,"Qx",{"$f":"L255","v":1.0464878998555477E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B251,[1]TransProb!$A$12:$A$45)","v":28}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A255&B254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666731894},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A255&C254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.6854495232680543E-9},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A255&D254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":5.1316669507127691E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A255&E254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233056203272855E-7},{"$f":"SUM(B255:E255)","v":1},null,"H",{"$f":"powermatrix(B255:E258,$B$4)","v":0.99989460769316363},1.0176749880453239E-7,6.4174935360510194E-7,1.0464878998555477E-4,{"$f":"SUM(I255:L255)","v":1.0000000000000016}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A256&B254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A256&C254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A256&D254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A256&E254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B256:E256)","v":1},null,"S",0.96694128899880183,9.8413568645932997E-8,6.2059935358636017E-7,3.3057991988277378E-2,{"$f":"SUM(I256:L256)","v":1.0000000000000013}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A257&B254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A257&C254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A257&D254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A257&E254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},1,null,"R",0.91750731556706133,9.3382266412565271E-8,5.8887185093755074E-7,8.2492002178822549E-2,{"$f":"SUM(I257:L257)","v":1.0000000000000011}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A258&B254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A258&C254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A258&D254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B252,MATCH(A258&E254,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I258:L258)","v":1}]
[]
["Year",{"$f":"B251+1","v":2045},null,null,null,null,null,null,"Qx",{"$f":"L264","v":1.0467726017352982E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B260,[1]TransProb!$A$12:$A$45)","v":29}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A264&B263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666731272},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A264&C263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":8.0455025982816514E-9},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A264&D263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":5.295661753677257E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A264&E263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233056714531904E-7},{"$f":"SUM(B264:E264)","v":1},null,"H",{"$f":"powermatrix(B264:E267,$B$4)","v":0.99989457594568898},8.4536153823990484E-8,6.622579827405313E-7,1.0467726017352982E-4,{"$f":"SUM(I264:L264)","v":0.99999999999999911}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A265&B263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A265&C263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A265&D263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A265&E263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B265:E265)","v":1},null,"S",0.96694125912150208,8.1750113588944192E-8,6.4043208464106213E-7,3.3058018696298895E-2,{"$f":"SUM(I265:L265)","v":0.99999999999999911}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A266&B263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A266&C263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A266&D263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A266&E263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B266:E266)","v":1},null,"R",0.91750728736589682,7.7570714998641556E-8,6.0769065217459233E-7,8.2492027372735366E-2,{"$f":"SUM(I266:L266)","v":0.99999999999999933}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A267&B263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A267&C263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A267&D263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B261,MATCH(A267&E263,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B267:E267)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I267:L267)","v":1}]
[]
["Year",{"$f":"B260+1","v":2046},null,null,null,null,null,null,"Qx",{"$f":"L273","v":1.0470573036161087E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B269,[1]TransProb!$A$12:$A$45)","v":30}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A273&B272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.9999996566673065},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A273&C272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.4055556139011873E-9},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A273&D272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":5.4596565625811512E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A273&E272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233057225790949E-7},{"$f":"SUM(B273:E273)","v":1},null,"H",{"$f":"powermatrix(B273:E276,$B$4)","v":0.99989454419821733},6.7304809284234295E-8,6.8276661135798636E-7,1.0470573036161087E-4,{"$f":"SUM(I273:L273)","v":0.99999999999999956}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A274&B272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A274&C272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A274&D272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A274&E272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931398E-3},{"$f":"SUM(B274:E274)","v":1},null,"S",0.966941229244205,6.5086658929818066E-8,6.6026481522865719E-7,3.3058045404320537E-2,{"$f":"SUM(I274:L274)","v":0.99999999999999978}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A275&B272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A275&C272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A275&D272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A275&E272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},1,null,"R",0.91750725916473452,6.1759163957115506E-8,6.265094529745071E-7,8.2492052566648363E-2,{"$f":"SUM(I275:L275)","v":0.99999999999999989}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A276&B272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A276&C272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A276&D272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B270,MATCH(A276&E272,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I276:L276)","v":1}]
[]
["Year",{"$f":"B269+1","v":2047},null,null,null,null,null,null,"Qx",{"$f":"L282","v":1.0473420054980282E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B278,[1]TransProb!$A$12:$A$45)","v":31}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A282&B281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666730029},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A282&C281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":4.7656085701266754E-9},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A282&D281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":5.6236513774244517E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A282&E281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233057737049993E-7},{"$f":"SUM(B282:E282)","v":1},null,"H",{"$f":"powermatrix(B282:E285,$B$4)","v":0.99989451245074557},5.0073465185264503E-8,7.0327523945746679E-7,1.0473420054980282E-4,{"$f":"SUM(I282:L282)","v":1}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A283&B281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.2026051112347351E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A283&C281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595952},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A283&D281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A283&E281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931398E-3},{"$f":"SUM(B283:E283)","v":1},null,"S",0.96694119936690781,4.8423204668555384E-8,6.8009754534914502E-7,3.3058072112342296E-2,{"$f":"SUM(I283:L283)","v":1.0000000000000002}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A284&B281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A284&C281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A284&D281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A284&E281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B284:E284)","v":1},null,"R",0.91750723096357178,4.5947613287987835E-8,6.4532825333729454E-7,8.2492077760561514E-2,{"$f":"SUM(I284:L284)","v":1}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A285&B281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A285&C281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A285&D281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B279,MATCH(A285&E281,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B285:E285)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I285:L285)","v":1}]
[]
["Year",{"$f":"B278+1","v":2048},null,null,null,null,null,null,"Qx",{"$f":"L291","v":1.047626707381035E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B287,[1]TransProb!$A$12:$A$45)","v":32}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A291&B290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666729407},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A291&C290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1256614669581139E-9},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A291&D290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":5.7876461982071565E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A291&E290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233058248309037E-7},{"$f":"SUM(B291:E291)","v":1},null,"H",{"$f":"powermatrix(B291:E294,$B$4)","v":0.99989448070327491},3.284212152708112E-8,7.2378386703897028E-7,1.047626707381035E-4,{"$f":"SUM(I291:L291)","v":1.0000000000000016}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A292&B290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A292&C290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A292&D290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A292&E290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931364E-3},{"$f":"SUM(B292:E292)","v":1},null,"S",0.96694116948961173,3.1759750805156043E-8,6.9993027500252383E-7,3.3058098820364167E-2,{"$f":"SUM(I292:L292)","v":1.0000000000000018}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A293&B290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A293&C290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A293&D290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A293&E290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631096E-3},{"$f":"SUM(B293:E293)","v":1},null,"R",0.91750720276241049,3.0136062991258491E-8,6.6414705326295294E-7,8.2492102954474719E-2,{"$f":"SUM(I293:L293)","v":1.0000000000000013}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A294&B290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A294&C290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A294&D290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B288,MATCH(A294&E290,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},{"$f":"SUM(B294:E294)","v":1},null,"D",0,0,0,1,{"$f":"SUM(I294:L294)","v":1}]
[]
["Year",{"$f":"B287+1","v":2049},null,null,null,null,null,null,"Qx",{"$f":"L300","v":1.0479114092651049E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B296,[1]TransProb!$A$12:$A$45)","v":33}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A300&B299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.99999965666728785},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A300&C299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1.4857143043955106E-9},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A300&D299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":5.9516410249292656E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A300&E299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233058759568082E-7},{"$f":"SUM(B300:E300)","v":1},null,"H",{"$f":"powermatrix(B300:E303,$B$4)","v":0.99989444895580137},1.5610778309684065E-8,7.4429249410250083E-7,1.0479114092651049E-4,{"$f":"SUM(I300:L300)","v":1.0000000000000002}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A301&B299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":9.202605111234724E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A301&C299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.90483741803595963},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A301&D299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A301&E299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":3.1365308516931368E-3},{"$f":"SUM(B301:E301)","v":1},null,"S",0.96694113961231276,1.5096297339620048E-8,7.1976300418879753E-7,3.3058125528386204E-2,{"$f":"SUM(I301:L301)","v":1.0000000000000004}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A302&B299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A302&C299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A302&D299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A302&E299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631104E-3},1,null,"R",0.9175071745612462,1.4324513066927423E-8,6.8296585275148569E-7,8.2492128148388064E-2,{"$f":"SUM(I302:L302)","v":1}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A303&B299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A303&C299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A303&D299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B297,MATCH(A303&E299,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I303:L303)","v":1}]
[]
["Year",{"$f":"B296+1","v":2050},null,null,null,null,null,null,"Qx",{"$f":"L309","v":1.048169335404849E-4},"Pr(D[365] | H[0] )"]
["Match Year",{"$f":"MATCH(B305,[1]TransProb!$A$12:$A$45)","v":34}]
[]
[null,"H","S","R","D",null,null,null,"H","S","R","D"]
["H",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A309&B308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.9999996566672823},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A309&C308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A309&D308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.1002125539990382E-8},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A309&E308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":2.8233059216049373E-7},{"$f":"SUM(B309:E309)","v":1},null,"H",{"$f":"powermatrix(B309:E312,$B$4)","v":0.99989442019412422},0,7.6287233570088858E-7,1.048169335404849E-4,{"$f":"SUM(I309:L309)","v":1.0000000000000004}]
["S",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A310&B308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A310&C308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A310&D308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A310&E308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"SUM(B310:E310)","v":0},null,"S",0,0,0,0,{"$f":"SUM(I310:L310)","v":0}]
["R",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A311&B308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":7.3367303634713596E-2},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A311&C308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A311&D308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0.92004441462932329},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A311&E308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":6.5882817359631113E-3},1,null,"R",0.91750714901235431,0,7.0001479089646372E-7,8.2492150972855269E-2,{"$f":"SUM(I311:L311)","v":1.0000000000000004}]
["D",{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A312&B308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A312&C308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A312&D308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":0},{"$f":"IFERROR(INDEX(Calc_TransProb!$Z$6:$AJ$39,B306,MATCH(A312&E308,Calc_TransProb!$Z$5:$AJ$5,0)),0)","v":1},1,null,"D",0,0,0,1,{"$f":"SUM(I312:L312)","v":1}]

{"sheet":"Output","index":8,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Output Results"]
["This worksheet reproduces the projected number of infections, deaths and days spent in hospital with the infection alongside the matrix results on the variance to qx"]
[]
["Scenario Inputs"]
[{"$f":"Input_Scen!A18","v":"Age Group"},{"$f":"Input_Scen!B18","v":"1-14 yrs"}]
[{"$f":"Input_Scen!A19","v":"Resistance Profile"},{"$f":"Input_Scen!B19","v":"100% Resistance by 2050"}]
[{"$f":"Input_Scen!A20","v":"Relative mortality rate of resistance against susceptible infection"},{"$f":"Input_Scen!B20","v":2.5}]
[{"$f":"Input_Scen!A21","v":"Average hospitalised days with susceptible infection"},{"$f":"Input_Scen!B21","v":10}]
[{"$f":"Input_Scen!A22","v":"Average hospitalised days with resistant infection"},{"$f":"Input_Scen!B22","v":12}]
[]
["Scenario Results"]
[]
["Year","Average Infections","Average Deaths","Average Bed Days","qx","Annual Variance in qx","Cumulative Variance in qx"]
[{"$f":"Input_Scen!B13","v":2017},{"$f":"Calc_TransProfile!E29","v":202.0625},{"$f":"Calc_TransProfile!K29","v":943},{"$f":"Calc_TransProb!K6+Calc_TransProb!L6","v":2067.2507835211422},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A14,Calc_Matrix!$B$8:$B$312,0))","v":1.0388009505209066E-4}]
[{"$f":"A14+1","v":2018},{"$f":"Calc_TransProfile!E30","v":202.0625},{"$f":"Calc_TransProfile!K30","v":943.26856241769065},{"$f":"Calc_TransProb!K7+Calc_TransProb!L7","v":2078.1150554591013},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A15,Calc_Matrix!$B$8:$B$312,0))","v":1.0390856523715773E-4},{"$f":"E15/E14-1","v":2.7406776103555686E-4},{"$f":"E15/E$14-1","v":2.7406776103555686E-4}]
[{"$f":"A15+1","v":2019},{"$f":"Calc_TransProfile!E31","v":202.0625},{"$f":"Calc_TransProfile!K31","v":943.53712483538129},{"$f":"Calc_TransProb!K8+Calc_TransProb!L8","v":2088.9793273970608},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A16,Calc_Matrix!$B$8:$B$312,0))","v":1.0393703542233593E-4},{"$f":"E16/E15-1","v":2.7399266954764023E-4},{"$f":"E16/E$14-1","v":5.4813552314048053E-4}]
[2020,{"$f":"Calc_TransProfile!E32","v":202.0625},{"$f":"Calc_TransProfile!K32","v":943.80568725307194},{"$f":"Calc_TransProb!K9+Calc_TransProb!L9","v":2099.8435993350208},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A17,Calc_Matrix!$B$8:$B$312,0))","v":1.0396550560762239E-4},2.7391761916994994E-4,8.2220328628790362E-4]
[2021,{"$f":"Calc_TransProfile!E33","v":202.0625},{"$f":"Calc_TransProfile!K33","v":944.07424967076247},{"$f":"Calc_TransProb!K10+Calc_TransProb!L10","v":2110.7078712729804},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A18,Calc_Matrix!$B$8:$B$312,0))","v":1.0399397579301531E-4},2.7384260987850517E-4,1.0962710504600626E-3]
[2022,{"$f":"Calc_TransProfile!E34","v":202.0625},{"$f":"Calc_TransProfile!K34","v":944.34281208845312},{"$f":"Calc_TransProb!K11+Calc_TransProb!L11","v":2121.5721432109394},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A19,Calc_Matrix!$B$8:$B$312,0))","v":1.0402244594488282E-4},2.737673182546807E-4,1.3703384919003803E-3]
[2023,{"$f":"Calc_TransProfile!E35","v":202.0625},{"$f":"Calc_TransProfile!K35","v":944.61137450614376},{"$f":"Calc_TransProb!K12+Calc_TransProb!L12","v":2132.436415148899},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A20,Calc_Matrix!$B$8:$B$312,0))","v":1.0405091613048604E-4},2.736927145350343E-4,1.6444062580971419E-3]
[2024,{"$f":"Calc_TransProfile!E36","v":202.0625},{"$f":"Calc_TransProfile!K36","v":944.87993692383441},{"$f":"Calc_TransProb!K13+Calc_TransProb!L13","v":2143.3006870868589},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A21,Calc_Matrix!$B$8:$B$312,0))","v":1.0407938631619601E-4},2.7361782835488846E-4,1.918474025321304E-3]
[2025,{"$f":"Calc_TransProfile!E37","v":202.0625},{"$f":"Calc_TransProfile!K37","v":945.14849934152505},{"$f":"Calc_TransProb!K14+Calc_TransProb!L14","v":2154.164959024818},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A22,Calc_Matrix!$B$8:$B$312,0))","v":1.041078565020164E-4},2.7354298317927572E-4,2.1925417936086156E-3]
[2026,{"$f":"Calc_TransProfile!E38","v":202.0625},{"$f":"Calc_TransProfile!K38","v":945.4170617592157},{"$f":"Calc_TransProb!K15+Calc_TransProb!L15","v":2165.0292309627775},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A23,Calc_Matrix!$B$8:$B$312,0))","v":1.041363266879455E-4},2.7346817892226483E-4,2.4666095629424234E-3]
[2027,{"$f":"Calc_TransProfile!E39","v":202.0625},{"$f":"Calc_TransProfile!K39","v":945.68562417690634},{"$f":"Calc_TransProb!K16+Calc_TransProb!L16","v":2175.8935029007371},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A24,Calc_Matrix!$B$8:$B$312,0))","v":1.0416479687398119E-4},2.7339341554655228E-4,2.7406773333020773E-3]
[2028,{"$f":"Calc_TransProfile!E40","v":202.0625},{"$f":"Calc_TransProfile!K40","v":945.95418659459688},{"$f":"Calc_TransProb!K17+Calc_TransProb!L17","v":2186.7577748386966},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A25,Calc_Matrix!$B$8:$B$312,0))","v":1.0419326706012805E-4},2.7331869308300227E-4,3.0147451047319862E-3]
[2029,{"$f":"Calc_TransProfile!E41","v":202.0625},{"$f":"Calc_TransProfile!K41","v":946.22274901228752},{"$f":"Calc_TransProb!K18+Calc_TransProb!L18","v":2197.6220467766561},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A26,Calc_Matrix!$B$8:$B$312,0))","v":1.0422173724638114E-4},2.7324401140682575E-4,3.2888128771846326E-3]
[2030,{"$f":"Calc_TransProfile!E42","v":202.0625},{"$f":"Calc_TransProfile!K42","v":946.49131142997817},{"$f":"Calc_TransProb!K19+Calc_TransProb!L19","v":2208.4863187146157},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A27,Calc_Matrix!$B$8:$B$312,0))","v":1.0425020743274471E-4},2.7316937057264568E-4,3.5628806507008726E-3]
[2031,{"$f":"Calc_TransProfile!E43","v":202.0625},{"$f":"Calc_TransProfile!K43","v":946.75987384766881},{"$f":"Calc_TransProb!K20+Calc_TransProb!L20","v":2219.3505906525752},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A28,Calc_Matrix!$B$8:$B$312,0))","v":1.0427867761921683E-4},2.7309477048742536E-4,3.8369484252618324E-3]
[2032,{"$f":"Calc_TransProfile!E44","v":202.0625},{"$f":"Calc_TransProfile!K44","v":947.02843626535946},{"$f":"Calc_TransProb!K21+Calc_TransProb!L21","v":2230.2148625905347},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A29,Calc_Matrix!$B$8:$B$312,0))","v":1.0430714777206897E-4},2.7301988769079522E-4,4.1110158761807902E-3]
[2033,{"$f":"Calc_TransProfile!E45","v":202.0625},{"$f":"Calc_TransProfile!K45","v":947.29699868305011},{"$f":"Calc_TransProb!K22+Calc_TransProb!L22","v":2241.0791345284938},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A30,Calc_Matrix!$B$8:$B$312,0))","v":1.0433561795874804E-4},2.7294569247815481E-4,4.3850836527339343E-3]
[2034,{"$f":"Calc_TransProfile!E46","v":202.0625},{"$f":"Calc_TransProfile!K46","v":947.56556110074075},{"$f":"Calc_TransProb!K23+Calc_TransProb!L23","v":2251.9434064664533},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A31,Calc_Matrix!$B$8:$B$312,0))","v":1.0436408814553676E-4},2.7287121450680907E-4,4.6591514303429005E-3]
[2035,{"$f":"Calc_TransProfile!E47","v":202.0625},{"$f":"Calc_TransProfile!K47","v":947.83412351843128},{"$f":"Calc_TransProb!K24+Calc_TransProb!L24","v":2262.8076784044129},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A32,Calc_Matrix!$B$8:$B$312,0))","v":1.0439255833243251E-4},2.7279677714475703E-4,4.9332192089819316E-3]
[2036,{"$f":"Calc_TransProfile!E48","v":202.0625},{"$f":"Calc_TransProfile!K48","v":948.10268593612193},{"$f":"Calc_TransProb!K25+Calc_TransProb!L25","v":2273.6719503423728},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A33,Calc_Matrix!$B$8:$B$312,0))","v":1.0442102851943846E-4},2.7272238041420316E-4,5.2072869886821138E-3]
[2037,{"$f":"Calc_TransProfile!E49","v":202.0625},{"$f":"Calc_TransProfile!K49","v":948.37124835381258},{"$f":"Calc_TransProb!K26+Calc_TransProb!L26","v":2284.5362222803319},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A34,Calc_Matrix!$B$8:$B$312,0))","v":1.0444949870655339E-4},2.7264802423987433E-4,5.4813547694310127E-3]
[2038,{"$f":"Calc_TransProfile!E50","v":202.0625},{"$f":"Calc_TransProfile!K50","v":948.63981077150322},{"$f":"Calc_TransProb!K27+Calc_TransProb!L27","v":2295.400494218291},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A35,Calc_Matrix!$B$8:$B$312,0))","v":1.0447796889377487E-4},2.7257370857736163E-4,5.7554225512059798E-3]
[2039,{"$f":"Calc_TransProfile!E51","v":202.0625},{"$f":"Calc_TransProfile!K51","v":948.90837318919387},{"$f":"Calc_TransProb!K28+Calc_TransProb!L28","v":2306.264766156251},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A36,Calc_Matrix!$B$8:$B$312,0))","v":1.0450643908110767E-4},2.7249943346197014E-4,6.0294903340523121E-3]
[2040,{"$f":"Calc_TransProfile!E52","v":202.0625},{"$f":"Calc_TransProfile!K52","v":949.17693560688451},{"$f":"Calc_TransProb!K29+Calc_TransProb!L29","v":2317.12903809421},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A37,Calc_Matrix!$B$8:$B$312,0))","v":1.0453490926854652E-4},2.7242519876469196E-4,6.3035581179196054E-3]
[2041,{"$f":"Calc_TransProfile!E53","v":202.0625},{"$f":"Calc_TransProfile!K53","v":949.44549802457516},{"$f":"Calc_TransProb!K30+Calc_TransProb!L30","v":2327.9933100321696},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A38,Calc_Matrix!$B$8:$B$312,0))","v":1.0456337945609561E-4},2.7235100454281458E-4,6.5776259028480499E-3]
[2042,{"$f":"Calc_TransProfile!E54","v":202.0625},{"$f":"Calc_TransProfile!K54","v":949.71406044226569},{"$f":"Calc_TransProb!K31+Calc_TransProb!L31","v":2338.8575819701291},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A39,Calc_Matrix!$B$8:$B$312,0))","v":1.0459184960993261E-4},2.7227652726113938E-4,6.8516933632476462E-3]
[{"$f":"A39+1","v":2043},{"$f":"Calc_TransProfile!E55","v":202.0625},{"$f":"Calc_TransProfile!K55","v":949.98262285995634},{"$f":"Calc_TransProb!K32+Calc_TransProb!L32","v":2349.7218539080886},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A40,Calc_Matrix!$B$8:$B$312,0))","v":1.0462031979769032E-4},2.7220273724859467E-4,7.1257611501844842E-3]
[2044,{"$f":"Calc_TransProfile!E56","v":202.0625},{"$f":"Calc_TransProfile!K56","v":950.25118527764698},{"$f":"Calc_TransProb!K33+Calc_TransProb!L33","v":2360.5861258460482},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A41,Calc_Matrix!$B$8:$B$312,0))","v":1.0464878998555477E-4},2.721286641018672E-4,7.3998289381489446E-3]
[2045,{"$f":"Calc_TransProfile!E57","v":202.0625},{"$f":"Calc_TransProfile!K57","v":950.51974769533763},{"$f":"Calc_TransProb!K34+Calc_TransProb!L34","v":2371.4503977840072},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A42,Calc_Matrix!$B$8:$B$312,0))","v":1.0467726017352982E-4},2.7205463129553742E-4,7.6738967271778868E-3]
[2046,{"$f":"Calc_TransProfile!E58","v":202.0625},{"$f":"Calc_TransProfile!K58","v":950.78831011302827},{"$f":"Calc_TransProb!K35+Calc_TransProb!L35","v":2382.3146697219672},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A43,Calc_Matrix!$B$8:$B$312,0))","v":1.0470573036161087E-4},2.7198063871614053E-4,7.947964517227124E-3]
[2047,{"$f":"Calc_TransProfile!E59","v":202.0625},{"$f":"Calc_TransProfile!K59","v":951.05687253071892},{"$f":"Calc_TransProb!K36+Calc_TransProb!L36","v":2393.1789416599267},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A44,Calc_Matrix!$B$8:$B$312,0))","v":1.0473420054980282E-4},2.7190668642140814E-4,8.2220323083441738E-3]
[2048,{"$f":"Calc_TransProfile!E60","v":202.0625},{"$f":"Calc_TransProfile!K60","v":951.32543494840957},{"$f":"Calc_TransProb!K37+Calc_TransProb!L37","v":2404.0432135978858},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A45,Calc_Matrix!$B$8:$B$312,0))","v":1.047626707381035E-4},2.7183277431075403E-4,8.4961001005079417E-3]
[2049,{"$f":"Calc_TransProfile!E61","v":202.0625},{"$f":"Calc_TransProfile!K61","v":951.59399736610021},{"$f":"Calc_TransProb!K38+Calc_TransProb!L38","v":2414.9074855358454},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A46,Calc_Matrix!$B$8:$B$312,0))","v":1.0479114092651049E-4},2.7175890234953926E-4,8.7701678936948912E-3]
[2050,{"$f":"Calc_TransProfile!E62","v":202.0625},{"$f":"Calc_TransProfile!K62","v":951.83730216330548},{"$f":"Calc_TransProb!K39+Calc_TransProb!L39","v":2424.75},{"$f":"INDEX(Calc_Matrix!$J$8:$J$312,MATCH($A47,Calc_Matrix!$B$8:$B$312,0))","v":1.048169335404849E-4},2.4613353520508419E-4,9.0184600613281152E-3]