{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["graph nas","graph ","survival data","loss data","survival data 2","survival data 3"],"not_rendered":{"charts":4,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"graph nas","index":0,"reason":"not_a_worksheet"},{"sheet":"graph ","index":1,"reason":"not_a_worksheet"}],"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":"survival data","index":2,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,6,4,10]]}
[null,"Tool to plot net survival and estimate median survival time"]
[]
[null,"Plotting functional survival",null,null,null,null,null,null,null,"Developed by Albert Kilian"]
[]
[null,"Location/Brand:","A",null,null,"Data description:"]
[]
[null,null,"years*","survival (%)","95% CI low","95% CI high"]
[null,null,0,100,100,100,{"$f":"D8-E8","v":0},{"$f":"F8-D8","v":0},null,"Decimal year calculator"]
[null,null,null,null,null,null,0,{"$f":"F9-D9","v":0},null,"Months","in years"]
[null,null,null,null,null,null,0,{"$f":"F10-D10","v":0},null,0,{"$f":"J10/12","v":0}]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"F12-D12","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,"This tool was developed as part of the NetWorks Project"]
[null,null,"* since distribution",null,null,null,null,null,null,null,null,null,null,null,"with funding from USAID/PMI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooperative Agreement No. GHS-A‐00‐09-00014-00"]
[null,"Median survival calculator",null,null,null,null,null,null,null,"Formula for median survival"]
[]
[null,null,"time (yrs)",null,"survival (%)","95% CI low","95% CI high"]
[null,"t1",null,"p1"]
[null,"t2",null,"p2",null,null,null,null,null,"tm=","median survival"]
[null,null,null,null,null,null,null,null,null,"t1=","first time point (years since distribution) "]
[null,null,"tm","95% CI low","95% CI high",null,null,null,null,"t2=","second time point"]
[null,null,{"$f":"IF( AND(C19>0, C20>0,E19>0, E20>0), C19+((C20-C19)*(E19-50)/(E19-E20)), \" \")","v":" "},{"$f":"IF(AND(C19>0, C20>0, F19>0, F20>0), C19+((C20-C19)*(F19-50)/(F19-F20)), \" \")","v":" "},{"$f":"IF(AND(C19>0, C20>0, G19>0, G20>0), C19+((C20-C19)*(G19-50)/(G19-G20)), \" \")","v":" "},null,null,null,null,"p1=","functional survival at t1"]
[]
[null,null,null,null,null,null,null,null,null,"p2=","functional survival at t2"]

{"sheet":"loss data","index":3,"n_rows":89,"n_cols":28,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Years",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,"loss fraction (from original cohort)"]
[null,"1-year",null,{"$f":"1-D35","v":0.49972509303912782},{"$f":"(1-E35)-D5","v":0.46015359828790248},{"$f":"(1-F35)-(SUM($D5:E5))","v":4.0070355645161371E-2},{"$f":"(1-G35)-(SUM($D5:F5))","v":5.0953027808109397E-5},{"$f":"(1-H35)-(SUM($D5:G5))","v":0},{"$f":"(1-I35)-(SUM($D5:H5))","v":0},{"$f":"(1-J35)-(SUM($D5:I5))","v":0},{"$f":"(1-K35)-(SUM($D5:J5))","v":0},{"$f":"(1-L35)-(SUM($D5:K5))","v":0},{"$f":"(1-M35)-(SUM($D5:L5))","v":0},{"$f":"(1-N35)-(SUM($D5:M5))","v":0},{"$f":"(1-O35)-(SUM($D5:N5))","v":0}]
[null,"1.5-year",null,{"$f":"1-D38","v":0.25776256590296431},{"$f":"(1-E38)-D6","v":0.46009618212075498},{"$f":"(1-F38)-(SUM($D6:E6))","v":0.24016158253866349},{"$f":"(1-G38)-(SUM($D6:F6))","v":4.0752435608756188E-2},{"$f":"(1-H38)-(SUM($D6:G6))","v":1.2262580955900715E-3},{"$f":"(1-I38)-(SUM($D6:H6))","v":9.7573326540700833E-7},{"$f":"(1-J38)-(SUM($D6:I6))","v":5.5511151231257827E-15},{"$f":"(1-K38)-(SUM($D6:J6))","v":0},{"$f":"(1-L38)-(SUM($D6:K6))","v":0},{"$f":"(1-M38)-(SUM($D6:L6))","v":0},{"$f":"(1-N38)-(SUM($D6:M6))","v":0},{"$f":"(1-O38)-(SUM($D6:N6))","v":0}]
[null,"2-year",null,{"$f":"1-D41","v":0.15494212965124654},{"$f":"(1-E41)-D7","v":0.34615799196912156},{"$f":"(1-F41)-(SUM($D7:E7))","v":0.30769538251518269},{"$f":"(1-G41)-(SUM($D7:F7))","v":0.15037705280190306},{"$f":"(1-H41)-(SUM($D7:G7))","v":3.7241130087306673E-2},{"$f":"(1-I41)-(SUM($D7:H7))","v":3.5181496754236319E-3},{"$f":"(1-J41)-(SUM($D7:I7))","v":6.8105522330608181E-5},{"$f":"(1-K41)-(SUM($D7:J7))","v":5.7777472028952559E-8},{"$f":"(1-L41)-(SUM($D7:K7))","v":1.3211653993039363E-14},{"$f":"(1-M41)-(SUM($D7:L7))","v":0},{"$f":"(1-N41)-(SUM($D7:M7))","v":0},{"$f":"(1-O41)-(SUM($D7:N7))","v":0}]
[null,"2.5-year",null,{"$f":"1-D44","v":0.10160111606463995},{"$f":"(1-E44)-D8","v":0.25247838944001721},{"$f":"(1-F44)-(SUM($D8:E8))","v":0.28428043459395114},{"$f":"(1-G44)-(SUM($D8:F8))","v":0.21195868574512977},{"$f":"(1-H44)-(SUM($D8:G8))","v":0.10780426421881284},{"$f":"(1-I44)-(SUM($D8:H8))","v":3.5081590399094531E-2},{"$f":"(1-J44)-(SUM($D8:I8))","v":6.3084865037302817E-3},{"$f":"(1-K44)-(SUM($D8:J8))","v":4.7790423922744463E-4},{"$f":"(1-L44)-(SUM($D8:K8))","v":9.114455220005091E-6},{"$f":"(1-M44)-(SUM($D8:L8))","v":1.4340083120956137E-8},{"$f":"(1-N44)-(SUM($D8:M8))","v":9.3702823278363212E-14},{"$f":"(1-O44)-(SUM($D8:N8))","v":0}]
[null,"3-year",null,{"$f":"1-D47","v":7.2151272714110148E-2},{"$f":"(1-E47)-D9","v":0.18966156336075068},{"$f":"(1-F47)-(SUM($D9:E9))","v":0.24090527738072431},{"$f":"(1-G47)-(SUM($D9:F9))","v":0.2200659025527435},{"$f":"(1-H47)-(SUM($D9:G9))","v":0.15396012520352798},{"$f":"(1-I47)-(SUM($D9:H9))","v":8.1974076907253002E-2},{"$f":"(1-J47)-(SUM($D9:I9))","v":3.1752360893920417E-2},{"$f":"(1-K47)-(SUM($D9:J9))","v":8.2141885160528227E-3},{"$f":"(1-L47)-(SUM($D9:K9))","v":1.2297081483182426E-3},{"$f":"(1-M47)-(SUM($D9:L9))","v":8.3816365333944098E-5},{"$f":"(1-N47)-(SUM($D9:M9))","v":1.7034721538911057E-6},{"$f":"(1-O47)-(SUM($D9:N9))","v":4.4848897928773113E-9}]
[null,"3.5-year",null,{"$f":"1-D50","v":5.331466472353863E-2},{"$f":"(1-E50)-D10","v":0.14515458831353023},{"$f":"(1-F50)-(SUM($D10:E10))","v":0.19848613714812213},{"$f":"(1-G50)-(SUM($D10:F10))","v":0.20445067818480533},{"$f":"(1-H50)-(SUM($D10:G10))","v":0.17118206586276496},{"$f":"(1-I50)-(SUM($D10:H10))","v":0.11827057452349965},{"$f":"(1-J50)-(SUM($D10:I10))","v":6.6691220411243646E-2},{"$f":"(1-K50)-(SUM($D10:J10))","v":2.9773557835181319E-2},{"$f":"(1-L50)-(SUM($D10:K10))","v":9.9934743766533218E-3},{"$f":"(1-M50)-(SUM($D10:L10))","v":2.3267425986889245E-3},{"$f":"(1-N50)-(SUM($D10:M10))","v":3.3184468191094219E-4},{"$f":"(1-O50)-(SUM($D10:N10))","v":2.3825958880174802E-5}]
[null,"4-year",null,{"$f":"1-D53","v":4.1232092107261975E-2},{"$f":"(1-E53)-D11","v":0.11477847359538151},{"$f":"(1-F53)-(SUM($D11:E11))","v":0.16434344645219079},{"$f":"(1-G53)-(SUM($D11:F11))","v":0.18216540082607158},{"$f":"(1-H53)-(SUM($D11:G11))","v":0.16965359580596306},{"$f":"(1-I53)-(SUM($D11:H11))","v":0.13596855257312912},{"$f":"(1-J53)-(SUM($D11:I11))","v":9.3993988043841958E-2},{"$f":"(1-K53)-(SUM($D11:J11))","v":5.5463332088263484E-2},{"$f":"(1-L53)-(SUM($D11:K11))","v":2.7342491001610347E-2},{"$f":"(1-M53)-(SUM($D11:L11))","v":1.0887708415804442E-2},{"$f":"(1-N53)-(SUM($D11:M11))","v":3.3317993770681786E-3},{"$f":"(1-O53)-(SUM($D11:N11))","v":7.2868000486081552E-4},{"$f":"(1-P53)-(SUM($D11:O11))","v":1.0233443057083846E-4},{"$f":"(1-Q53)-(SUM($D11:P11))","v":7.8484466413675236E-6},{"$f":"(1-R53)-(SUM($D11:Q11))","v":2.5455955088293791E-7},{"$f":"(1-S53)-(SUM($D11:R11))","v":2.2692893120179747E-9}]
[null,"4.5-year",null,{"$f":"1-D56","v":3.2728226796986393E-2},{"$f":"(1-E56)-D12","v":9.2528844432244406E-2},{"$f":"(1-F56)-(SUM($D12:E12))","v":0.13677454515914711},{"$f":"(1-G56)-(SUM($D12:F12))","v":0.15938661238118501},{"$f":"(1-H56)-(SUM($D12:G12))","v":0.1593897890566629},{"$f":"(1-I56)-(SUM($D12:H12))","v":0.14071199760995812},{"$f":"(1-J56)-(SUM($D12:I12))","v":0.11061400149298539},{"$f":"(1-K56)-(SUM($D12:J12))","v":7.7312768220580308E-2},{"$f":"(1-L56)-(SUM($D12:K12))","v":4.7631345716765527E-2},{"$f":"(1-M56)-(SUM($D12:L12))","v":2.5473243570926951E-2},{"$f":"(1-N56)-(SUM($D12:M12))","v":1.1559486022759913E-2},{"$f":"(1-O56)-(SUM($D12:N12))","v":4.3101781386805094E-3},{"$f":"(1-P56)-(SUM($D12:O12))","v":1.2626617393386441E-3},{"$f":"(1-Q56)-(SUM($D12:P12))","v":2.7291629295667086E-4},{"$f":"(1-R56)-(SUM($D12:Q12))","v":3.9799835721998633E-5},{"$f":"(1-S56)-(SUM($D12:R12))","v":3.4370433642516574E-6}]
[null,"5-year",null,{"$f":"1-D59","v":2.6730711611143487E-2},{"$f":"(1-E59)-D13","v":7.639855515462568E-2},{"$f":"(1-F59)-(SUM($D13:E13))","v":0.11546773747402794},{"$f":"(1-G59)-(SUM($D13:F13))","v":0.13928760146092278},{"$f":"(1-H59)-(SUM($D13:G13))","v":0.14620787250930789},{"$f":"(1-I59)-(SUM($D13:H13))","v":0.13769959175466906},{"$f":"(1-J59)-(SUM($D13:I13))","v":0.11774318329731959},{"$f":"(1-K59)-(SUM($D13:J13))","v":9.1673287731939834E-2},{"$f":"(1-L59)-(SUM($D13:K13))","v":6.4818763080916719E-2},{"$f":"(1-M59)-(SUM($D13:L13))","v":4.1327303006670868E-2},{"$f":"(1-N59)-(SUM($D13:M13))","v":2.3491873856363865E-2},{"$f":"(1-O59)-(SUM($D13:N13))","v":1.1714602056360435E-2},{"$f":"(1-P59)-(SUM($D13:O13))","v":5.0130489794698585E-3},{"$f":"(1-Q59)-(SUM($D13:P13))","v":1.7871512188543104E-3},{"$f":"(1-R59)-(SUM($D13:Q13))","v":5.0995797352160199E-4},{"$f":"(1-S59)-(SUM($D13:R13))","v":1.1029542879237297E-4},{"$f":"(1-T59)-(SUM($D13:S13))","v":1.6767605720779954E-5},{"$f":"(1-U59)-(SUM($D13:T13))","v":1.6103165539904651E-6},{"$f":"(1-V59)-(SUM($D13:U13))","v":8.361712677817934E-8}]
[null,"5.5-year",null,{"$f":"1-D62","v":2.2183380361085026E-2},{"$f":"(1-E62)-D14","v":6.3924997631907732E-2},{"$f":"(1-F62)-(SUM($D14:E14))","v":9.824459692658738E-2},{"$f":"(1-G62)-(SUM($D14:F14))","v":0.12161186736645135},{"$f":"(1-H62)-(SUM($D14:G14))","v":0.13231553194536927},{"$f":"(1-I62)-(SUM($D14:H14))","v":0.13064513792335297},{"$f":"(1-J62)-(SUM($D14:I14))","v":0.11867431871749445},{"$f":"(1-K62)-(SUM($D14:J14))","v":9.9707490129001819E-2},{"$f":"(1-L62)-(SUM($D14:K14))","v":7.7528760453676515E-2},{"$f":"(1-M62)-(SUM($D14:L14))","v":5.563587492776767E-2},{"$f":"(1-N62)-(SUM($D14:M14))","v":3.6639440465921824E-2},{"$f":"(1-O62)-(SUM($D14:N14))","v":2.1955786511327124E-2},{"$f":"(1-P62)-(SUM($D14:O14))","v":1.1832674453105652E-2},{"$f":"(1-Q62)-(SUM($D14:P14))","v":5.6471722895429233E-3},{"$f":"(1-R62)-(SUM($D14:Q14))","v":2.338849473228044E-3},{"$f":"(1-S62)-(SUM($D14:R14))","v":8.1866250211748426E-4},{"$f":"(1-T62)-(SUM($D14:S14))","v":2.3389703694509656E-4},{"$f":"(1-U62)-(SUM($D14:T14))","v":5.2079050383957437E-5},{"$f":"(1-V62)-(SUM($D14:U14))","v":8.4895636667248198E-6}]
[null,"6-year",null,{"$f":"1-D65","v":1.8328996773055106E-2},{"$f":"(1-E65)-D15","v":5.3169566563636361E-2},{"$f":"(1-F65)-(SUM($D15:E15))","v":8.2825501073922281E-2},{"$f":"(1-G65)-(SUM($D15:F15))","v":0.1046842008621609},{"$f":"(1-H65)-(SUM($D15:G15))","v":0.11723929240029518},{"$f":"(1-I65)-(SUM($D15:H15))","v":0.12024653987817191},{"$f":"(1-J65)-(SUM($D15:I15))","v":0.11466239596082928},{"$f":"(1-K65)-(SUM($D15:J15))","v":0.10238640345947281},{"$f":"(1-L65)-(SUM($D15:K15))","v":8.5866825625417142E-2},{"$f":"(1-M65)-(SUM($D15:L15))","v":6.7654056253792061E-2},{"$f":"(1-N65)-(SUM($D15:M15))","v":4.9992711610575946E-2},{"$f":"(1-O65)-(SUM($D15:N15))","v":3.4529061143536377E-2},{"$f":"(1-P65)-(SUM($D15:O15))","v":2.2178808071373846E-2},{"$f":"(1-Q65)-(SUM($D15:P15))","v":1.3159125117541248E-2},{"$f":"(1-R65)-(SUM($D15:Q15))","v":7.1493257290250467E-3},{"$f":"(1-S65)-(SUM($D15:R15))","v":3.5177592957298387E-3},{"$f":"(1-T65)-(SUM($D15:S15))","v":1.5460421392182733E-3},{"$f":"(1-U65)-(SUM($D15:T15))","v":5.9647067370227624E-4},{"$f":"(1-V65)-(SUM($D15:U15))","v":1.9763561005381458E-4},{"$f":"(1-W65)-(SUM($D15:V15))","v":5.4699669230884318E-5},{"$f":"(1-X65)-(SUM($D15:W15))","v":1.2203371445140831E-5},{"$f":"(1-Y65)-(SUM($D15:X15))","v":2.0954333186384844E-6},{"$f":"(1-Z65)-(SUM($D15:Y15))","v":2.605640356811989E-7}]
[null,"6.5-year",null,{"$f":"1-D68","v":1.5608112580499878E-2},{"$f":"(1-E68)-D16","v":4.5499291062302105E-2},{"$f":"(1-F68)-(SUM($D16:E16))","v":7.1583425998859473E-2},{"$f":"(1-G68)-(SUM($D16:F16))","v":9.1856474892770157E-2},{"$f":"(1-H68)-(SUM($D16:G16))","v":0.10502776260490054},{"$f":"(1-I68)-(SUM($D16:H16))","v":0.11064572788106675},{"$f":"(1-J68)-(SUM($D16:I16))","v":0.10909774002022443},{"$f":"(1-K68)-(SUM($D16:J16))","v":0.10148938117906914},{"$f":"(1-L68)-(SUM($D16:K16))","v":8.9429017762409746E-2},{"$f":"(1-M68)-(SUM($D16:L16))","v":7.4758869643796633E-2},{"$f":"(1-N68)-(SUM($D16:M16))","v":5.9281160077222506E-2},{"$f":"(1-O68)-(SUM($D16:N16))","v":4.4525810740768001E-2},{"$f":"(1-P68)-(SUM($D16:O16))","v":3.1594966880642561E-2},{"$f":"(1-Q68)-(SUM($D16:P16))","v":2.1101812735493608E-2},{"$f":"(1-R68)-(SUM($D16:Q16))","v":1.3200687194709015E-2},{"$f":"(1-S68)-(SUM($D16:R16))","v":7.687214640427209E-3},{"$f":"(1-T68)-(SUM($D16:S16))","v":4.1353808057223995E-3},{"$f":"(1-U68)-(SUM($D16:T16))","v":2.0358812105397694E-3},{"$f":"(1-V68)-(SUM($D16:U16))","v":9.0671614681814283E-4},{"$f":"(1-W68)-(SUM($D16:V16))","v":3.6018038592011692E-4},{"$f":"(1-X68)-(SUM($D16:W16))","v":1.2540321093623685E-4},{"$f":"(1-Y68)-(SUM($D16:X16))","v":3.7446606388935599E-5},{"$f":"(1-Z68)-(SUM($D16:Y16))","v":9.3331888876280189E-6},{"$f":"(1-AA68)-(SUM($D16:Z16))","v":1.8760007196583217E-6}]
[null,"7-year",null,{"$f":"1-D71","v":1.3520919366915907E-2},{"$f":"(1-E71)-D17","v":3.9563614365595523E-2},{"$f":"(1-F71)-(SUM($D17:E17))","v":6.271982137230514E-2},{"$f":"(1-G71)-(SUM($D17:F17))","v":8.1419705901526807E-2},{"$f":"(1-H71)-(SUM($D17:G17))","v":9.4573911864879845E-2},{"$f":"(1-I71)-(SUM($D17:H17))","v":0.10167136741614335},{"$f":"(1-J71)-(SUM($D17:I17))","v":0.10280036602367071},{"$f":"(1-K71)-(SUM($D17:J17))","v":9.8593056397358936E-2},{"$f":"(1-L71)-(SUM($D17:K17))","v":9.0104971369573961E-2},{"$f":"(1-M71)-(SUM($D17:L17))","v":7.865063321837451E-2},{"$f":"(1-N71)-(SUM($D17:M17))","v":6.5622018842944496E-2},{"$f":"(1-O71)-(SUM($D17:N17))","v":5.2317784846907078E-2},{"$f":"(1-P71)-(SUM($D17:O17))","v":3.9807483444931013E-2},{"$f":"(1-Q71)-(SUM($D17:P17))","v":2.884727720100877E-2},{"$f":"(1-R71)-(SUM($D17:Q17))","v":1.9853415868137603E-2},{"$f":"(1-S71)-(SUM($D17:R17))","v":1.2929038449434382E-2},{"$f":"(1-T71)-(SUM($D17:S17))","v":7.9308933765203093E-3},{"$f":"(1-U71)-(SUM($D17:T17))","v":4.5571397311590101E-3},{"$f":"(1-V71)-(SUM($D17:U17))","v":2.4364793840484511E-3},{"$f":"(1-W71)-(SUM($D17:V17))","v":1.2023291091535215E-3},{"$f":"(1-X71)-(SUM($D17:W17))","v":5.4230982150815787E-4},{"$f":"(1-Y71)-(SUM($D17:X17))","v":2.2096998601206508E-4},{"$f":"(1-Z71)-(SUM($D17:Y17))","v":8.0185669347643262E-5},{"$f":"(1-AA71)-(SUM($D17:Z17))","v":2.5468209658874308E-5},{"$f":"(1-AB71)-(SUM($D17:AA17))","v":8.838762883933704E-6}]
[]
[null,"Nets"]
[null,"1-year",100,{"$f":"C20-($C20*D5)","v":50.02749069608722},{"$f":"D20-($C20*E5)","v":4.0121308672969747},5.095302780837585E-3,2.6645352591003757E-14,2.6645352591003757E-14,2.6645352591003757E-14,2.6645352591003757E-14]
[null,"1.5-year",100,74.223743409703573,{"$f":"D21-($C21*E6)","v":28.214125197628078},4.1979669437617311,0.12272338288611273,9.7573327105582308E-5,5.6488147492927965E-13,9.7699626167013776E-15]
[null,"2-year",100,84.50578703487534,{"$f":"D22-($C22*E7)","v":49.889987837963183},19.120449586444913,4.0827443062546074,0.35863129752394007,6.8163299815768852E-3,5.7777485160670494E-6]
[null,"2.5-year",100,89.839888393536,64.592049449534272,36.16400599013916,14.968137415626181,4.1877109937448971,0.67955195383544398,4.8703303462415803E-2]
[null,"3-year",100,92.784872728588979,73.818716392513906,49.728188654441475,27.721598399167124,12.325585878814326,4.1281781880890271,0.95294209869698543,{"$f":"J24-($C24*K9)","v":0.13152324709170315},8.5524322598788949E-3,1.7079572648448504E-4,4.4851109537447087E-7,2.2116086739742968E-11]
[null,"3.5-year",100,94.668533527646133,80.153074696293118,60.304460981480901,39.859393163000362,22.741186576723866,10.9141291243739,4.2450070832495364,1.2676512997314044,0.26830386206607226,3.562960219717981E-2,2.4451340060855919E-3,6.2538118068111714E-5]
[null,"4-year",100,95.876790789273798,84.398943429735652,67.964598784516568,49.748058701909414,32.782699121313108,19.185843864000198,9.7864450596160015,4.2401118507896527,1.505862750628618,0.41709190904817373,8.3911971341355862E-2,1.104397085527431E-2,{"$f":"O26-($C26*P11)","v":8.105277981904635E-4}]
[null,"4.5-year",100,96.727177320301365,87.47429287707692,73.796838361162202,57.858177123043703,41.919198217377414,27.847998456381603,16.786598307083064,9.0553214850250328,4.2921869133484805,1.7448625562557853,0.58891395397979407,0.15789614011174313,{"$f":"O27-($C27*P12)","v":3.1629966177878721E-2}]
[null,"5-year",100,97.326928838885649,89.687073323423078,78.140299576020283,64.21153942992801,49.590752178997221,35.820793003530312,24.046474673798354,14.879145900604371,8.3972695925126999,4.2645392918456135,1.915351906209227,0.74389170057318355,{"$f":"O28-($C28*P13)","v":0.2425868026261977},{"$f":"P28-($C28*Q13)","v":6.3871680740766656E-2},{"$f":"Q28-($C28*R13)","v":1.2875883388606457E-2}]
[null,"5.5-year",100,97.781661963891494,91.389162200700724,81.564702508041989,69.403515771396854,56.171962576859926,43.107448784524628,31.240016912775182,21.269267899875,13.516391854507349,7.9528043617305819,4.2888603151383995,2.093281664005687,{"$f":"O29-($C29*P14)","v":0.91001421869512189},{"$f":"P29-($C29*Q14)","v":0.34529698974082956},{"$f":"Q29-($C29*R14)","v":0.11141204241802516}]
[null,"6-year",100,{"$f":"C30-($C$30*D15)","v":98.167100322694495},{"$f":"D30-($C$30*E15)","v":92.850143666330865},84.56759355893864,74.099173472722555,62.375244232693035,50.350590244875846,38.884350648792918,28.645710302845636,20.059027740303922,13.293622114924716,8.2943509538671218,4.8414448395134837,2.6235640323760991,1.3076515206219743,0.59271894771946965,0.24094301814648578,8.633880422465845E-2]
[null,"6.5-year",100,{"$f":"C31-($C$30*D16)","v":98.439188741950005},{"$f":"D31-($C$30*E16)","v":93.889259635719796},{"$f":"E31-($C$30*F16)","v":86.730917035833855},{"$f":"F31-($C$30*G16)","v":77.545269546556838},{"$f":"G31-($C$30*H16)","v":67.042493286066787},{"$f":"H31-($C$30*I16)","v":55.977920497960113},{"$f":"I31-($C$30*J16)","v":45.068146495937668},{"$f":"J31-($C$30*K16)","v":34.919208378030753},{"$f":"K31-($C$30*L16)","v":25.97630660178978},{"$f":"L31-($C$30*M16)","v":18.500419637410118},{"$f":"M31-($C$30*N16)","v":12.572303629687868},{"$f":"N31-($C$30*O16)","v":8.1197225556110677},{"$f":"O31-($C$30*P16)","v":4.9602258675468116},{"$f":"P31-($C$30*Q16)","v":2.8500445939974508},{"$f":"Q31-($C$30*R16)","v":1.5299758745265493},{"$f":"R31-($C$30*S16)","v":0.76125441048382836},{"$f":"S31-($C$30*T16)","v":0.34771632991158841}]
[null,"7-year",100,{"$f":"C32-($C$32*D17)","v":98.647908063308407},{"$f":"D32-($C$32*E17)","v":94.69154662674886},88.419564489518351,80.277593899365669,70.820202712877688,60.653065971263352,50.373029368896283,40.51372372916039,31.503226592202992,23.638163270365542,17.075961386071093,11.844182901380385,7.8634345568872845,4.978706836786408,2.9933652499726477,1.7004614050292095,0.90737206737717857,0.45165809426127757,0.20801015585643245,8.7777244941080301E-2,3.3546262790264514E-2,1.1449264189058006E-2]
[]
[null,"Net decay"]
[null,"1-year",null,{"$f":"IF(D$3<$C$36, EXP($C$37-($C$37/(1-((D$3/$C$36)*(D$3/$C$36))))), 0)","v":0.50027490696087218},{"$f":"IF(E$3<$C$36, EXP($C$37-($C$37/(1-((E$3/$C$36)*(E$3/$C$36))))), 0)","v":4.0121308672969647E-2},5.0953027808341335E-5,2.2085469522606488E-16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"L",4.76]
[null,"k",15]
[null,"1.5-year",null,{"$f":"IF(D$3<$C$39, EXP($C$40-($C$40/(1-((D$3/$C$39)*(D$3/$C$39))))), 0)","v":0.74223743409703569},{"$f":"IF(E$3<$C$39, EXP($C$40-($C$40/(1-((E$3/$C$39)*(E$3/$C$39))))), 0)","v":0.28214125197628076},4.1979669437617245E-2,1.2272338288610723E-3,9.75733270989041E-7,5.5409026406196464E-15,3.2013811509136462E-83,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AA$3<$C$36, EXP($C$37-($C$37/(1-((AA$3/$C$36)*(AA$3/$C$36))))), 0)","v":0}]
[null,"L",7.28]
[null,"k",15.5]
[null,"2-year",null,{"$f":"IF(D$3<$C42, EXP($C43-($C43/(1-((D$3/$C42)*(D$3/$C42))))), 0)","v":0.84505787034875346},{"$f":"IF(E$3<$C42, EXP($C43-($C43/(1-((E$3/$C42)*(E$3/$C42))))), 0)","v":0.49889987837963196},0.19120449586444924,4.0827443062546112E-2,3.5863129752394477E-3,6.8163299815832051E-5,5.7777485194191946E-8,1.318034173887496E-14,3.7735672257791167E-38,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"L",9.8000000000000007]
[null,"k",16]
[null,"2.5-year",null,{"$f":"IF(D$3<$C45, EXP($C46-($C46/(1-((D$3/$C45)*(D$3/$C45))))), 0)","v":0.89839888393536005},{"$f":"IF(E$3<$C45, EXP($C46-($C46/(1-((E$3/$C45)*(E$3/$C45))))), 0)","v":0.64592049449534283},{"$f":"IF(F$3<$C45, EXP($C46-($C46/(1-((F$3/$C45)*(F$3/$C45))))), 0)","v":0.3616400599013917},{"$f":"IF(G$3<$C45, EXP($C46-($C46/(1-((G$3/$C45)*(G$3/$C45))))), 0)","v":0.14968137415626198},{"$f":"IF(H$3<$C45, EXP($C46-($C46/(1-((H$3/$C45)*(H$3/$C45))))), 0)","v":4.1877109937449128E-2},{"$f":"IF(I$3<$C45, EXP($C46-($C46/(1-((I$3/$C45)*(I$3/$C45))))), 0)","v":6.7955195383545726E-3},{"$f":"IF(J$3<$C45, EXP($C46-($C46/(1-((J$3/$C45)*(J$3/$C45))))), 0)","v":4.8703303462426358E-4},{"$f":"IF(K$3<$C45, EXP($C46-($C46/(1-((K$3/$C45)*(K$3/$C45))))), 0)","v":9.1287953967975624E-6},{"$f":"IF(L$3<$C45, EXP($C46-($C46/(1-((L$3/$C45)*(L$3/$C45))))), 0)","v":1.4340176854569906E-8},{"$f":"IF(M$3<$C45, EXP($C46-($C46/(1-((M$3/$C45)*(M$3/$C45))))), 0)","v":9.3703914872399391E-14},{"$f":"IF(N$3<$C45, EXP($C46-($C46/(1-((N$3/$C45)*(N$3/$C45))))), 0)","v":3.1611679236557932E-26},{"$f":"IF(O$3<$C45, EXP($C46-($C46/(1-((O$3/$C45)*(O$3/$C45))))), 0)","v":1.6357125111222063E-94},{"$f":"IF(P$3<$C45, EXP($C46-($C46/(1-((P$3/$C45)*(P$3/$C45))))), 0)","v":0},{"$f":"IF(Q$3<$C45, EXP($C46-($C46/(1-((Q$3/$C45)*(Q$3/$C45))))), 0)","v":0},{"$f":"IF(R$3<$C45, EXP($C46-($C46/(1-((R$3/$C45)*(R$3/$C45))))), 0)","v":0},{"$f":"IF(S$3<$C45, EXP($C46-($C46/(1-((S$3/$C45)*(S$3/$C45))))), 0)","v":0},{"$f":"IF(T$3<$C45, EXP($C46-($C46/(1-((T$3/$C45)*(T$3/$C45))))), 0)","v":0},{"$f":"IF(U$3<$C45, EXP($C46-($C46/(1-((U$3/$C45)*(U$3/$C45))))), 0)","v":0},{"$f":"IF(V$3<$C45, EXP($C46-($C46/(1-((V$3/$C45)*(V$3/$C45))))), 0)","v":0},{"$f":"IF(W$3<$C45, EXP($C46-($C46/(1-((W$3/$C45)*(W$3/$C45))))), 0)","v":0},{"$f":"IF(X$3<$C45, EXP($C46-($C46/(1-((X$3/$C45)*(X$3/$C45))))), 0)","v":0},{"$f":"IF(Y$3<$C45, EXP($C46-($C46/(1-((Y$3/$C45)*(Y$3/$C45))))), 0)","v":0},{"$f":"IF(Z$3<$C45, EXP($C46-($C46/(1-((Z$3/$C45)*(Z$3/$C45))))), 0)","v":0},{"$f":"IF(AA$3<$C45, EXP($C46-($C46/(1-((AA$3/$C45)*(AA$3/$C45))))), 0)","v":0}]
[null,"L",{"$f":"(C42+C48)/2","v":12.45}]
[null,"k",16.5]
[null,"3-year",null,{"$f":"IF(D$3<$C48, EXP($C49-($C49/(1-((D$3/$C48)*(D$3/$C48))))), 0)","v":0.92784872728588985},{"$f":"IF(E$3<$C48, EXP($C49-($C49/(1-((E$3/$C48)*(E$3/$C48))))), 0)","v":0.73818716392513917},0.49728188654441485,0.27721598399167136,0.12325585878814335,4.1281781880890406E-2,9.5294209869699366E-3,1.3152324709171312E-3,8.5524322598874754E-5,1.7079572650050901E-6,4.4851111019229707E-9,2.212710071243364E-13,7.1721736556977069E-22,6.2117532000253288E-46,0,0,0,0,0,0,0,0,0,0]
[null,"L",15.1]
[null,"k",17]
[null,"3.5-year",null,{"$f":"IF(D$3<$C51, EXP($C52-($C52/(1-((D$3/$C51)*(D$3/$C51))))), 0)","v":0.94668533527646137},{"$f":"IF(E$3<$C51, EXP($C52-($C52/(1-((E$3/$C51)*(E$3/$C51))))), 0)","v":0.80153074696293114},{"$f":"IF(F$3<$C51, EXP($C52-($C52/(1-((F$3/$C51)*(F$3/$C51))))), 0)","v":0.60304460981480901},{"$f":"IF(G$3<$C51, EXP($C52-($C52/(1-((G$3/$C51)*(G$3/$C51))))), 0)","v":0.39859393163000367},{"$f":"IF(H$3<$C51, EXP($C52-($C52/(1-((H$3/$C51)*(H$3/$C51))))), 0)","v":0.22741186576723871},{"$f":"IF(I$3<$C51, EXP($C52-($C52/(1-((I$3/$C51)*(I$3/$C51))))), 0)","v":0.109141291243739},{"$f":"IF(J$3<$C51, EXP($C52-($C52/(1-((J$3/$C51)*(J$3/$C51))))), 0)","v":4.2450070832495412E-2},{"$f":"IF(K$3<$C51, EXP($C52-($C52/(1-((K$3/$C51)*(K$3/$C51))))), 0)","v":1.26765129973141E-2},{"$f":"IF(L$3<$C51, EXP($C52-($C52/(1-((L$3/$C51)*(L$3/$C51))))), 0)","v":2.6830386206607554E-3},{"$f":"IF(M$3<$C51, EXP($C52-($C52/(1-((M$3/$C51)*(M$3/$C51))))), 0)","v":3.5629602197181096E-4},{"$f":"IF(N$3<$C51, EXP($C52-($C52/(1-((N$3/$C51)*(N$3/$C51))))), 0)","v":2.44513400608834E-5},{"$f":"IF(O$3<$C51, EXP($C52-($C52/(1-((O$3/$C51)*(O$3/$C51))))), 0)","v":6.2538118077754353E-7},{"$f":"IF(P$3<$C51, EXP($C52-($C52/(1-((P$3/$C51)*(P$3/$C51))))), 0)","v":3.2877712253996247E-9},{"$f":"IF(Q$3<$C51, EXP($C52-($C52/(1-((Q$3/$C51)*(Q$3/$C51))))), 0)","v":1.0627821053812053E-12},{"$f":"IF(R$3<$C51, EXP($C52-($C52/(1-((R$3/$C51)*(R$3/$C51))))), 0)","v":1.1939566244333482E-18},{"$f":"IF(S$3<$C51, EXP($C52-($C52/(1-((S$3/$C51)*(S$3/$C51))))), 0)","v":6.2072680202759221E-31},{"$f":"IF(T$3<$C51, EXP($C52-($C52/(1-((T$3/$C51)*(T$3/$C51))))), 0)","v":1.1798135083720723E-70},{"$f":"IF(U$3<$C51, EXP($C52-($C52/(1-((U$3/$C51)*(U$3/$C51))))), 0)","v":0},{"$f":"IF(V$3<$C51, EXP($C52-($C52/(1-((V$3/$C51)*(V$3/$C51))))), 0)","v":0},{"$f":"IF(W$3<$C51, EXP($C52-($C52/(1-((W$3/$C51)*(W$3/$C51))))), 0)","v":0},{"$f":"IF(X$3<$C51, EXP($C52-($C52/(1-((X$3/$C51)*(X$3/$C51))))), 0)","v":0},{"$f":"IF(Y$3<$C51, EXP($C52-($C52/(1-((Y$3/$C51)*(Y$3/$C51))))), 0)","v":0},{"$f":"IF(Z$3<$C51, EXP($C52-($C52/(1-((Z$3/$C51)*(Z$3/$C51))))), 0)","v":0},{"$f":"IF(AA$3<$C51, EXP($C52-($C52/(1-((AA$3/$C51)*(AA$3/$C51))))), 0)","v":0}]
[null,"L",{"$f":"(C48+C54)/2","v":17.899999999999999}]
[null,"k",17.5]
[null,"4-year",null,{"$f":"IF(D$3<$C54, EXP($C55-($C55/(1-((D$3/$C54)*(D$3/$C54))))), 0)","v":0.95876790789273802},{"$f":"IF(E$3<$C54, EXP($C55-($C55/(1-((E$3/$C54)*(E$3/$C54))))), 0)","v":0.84398943429735651},0.67964598784516572,0.49748058701909409,0.32782699121313114,0.19185843864000196,9.786445059615996E-2,4.2401118507896511E-2,1.5058627506286199E-2,4.1709190904817648E-3,8.3911971341355733E-4,1.1043970855276172E-4,8.1052779818888126E-6,2.5683134054785333E-7,2.2717896561943192E-9,2.5003456083488541E-12,6.3658684693159496E-17,5.7584816439595408E-25,1.5336390839521831E-42,1.7578781920993952E-110,0,0,0,0]
[null,"L",20.7]
[null,"k",18]
[null,"4.5-year",null,{"$f":"IF(D$3<$C57, EXP($C58-($C58/(1-((D$3/$C57)*(D$3/$C57))))), 0)","v":0.96727177320301361},{"$f":"IF(E$3<$C57, EXP($C58-($C58/(1-((E$3/$C57)*(E$3/$C57))))), 0)","v":0.8747429287707692},{"$f":"IF(F$3<$C57, EXP($C58-($C58/(1-((F$3/$C57)*(F$3/$C57))))), 0)","v":0.73796838361162209},{"$f":"IF(G$3<$C57, EXP($C58-($C58/(1-((G$3/$C57)*(G$3/$C57))))), 0)","v":0.57858177123043708},{"$f":"IF(H$3<$C57, EXP($C58-($C58/(1-((H$3/$C57)*(H$3/$C57))))), 0)","v":0.41919198217377418},{"$f":"IF(I$3<$C57, EXP($C58-($C58/(1-((I$3/$C57)*(I$3/$C57))))), 0)","v":0.27847998456381606},{"$f":"IF(J$3<$C57, EXP($C58-($C58/(1-((J$3/$C57)*(J$3/$C57))))), 0)","v":0.16786598307083062},{"$f":"IF(K$3<$C57, EXP($C58-($C58/(1-((K$3/$C57)*(K$3/$C57))))), 0)","v":9.0553214850250349E-2},{"$f":"IF(L$3<$C57, EXP($C58-($C58/(1-((L$3/$C57)*(L$3/$C57))))), 0)","v":4.2921869133484836E-2},{"$f":"IF(M$3<$C57, EXP($C58-($C58/(1-((M$3/$C57)*(M$3/$C57))))), 0)","v":1.7448625562557881E-2},{"$f":"IF(N$3<$C57, EXP($C58-($C58/(1-((N$3/$C57)*(N$3/$C57))))), 0)","v":5.8891395397979163E-3},{"$f":"IF(O$3<$C57, EXP($C58-($C58/(1-((O$3/$C57)*(O$3/$C57))))), 0)","v":1.5789614011175082E-3},{"$f":"IF(P$3<$C57, EXP($C58-($C58/(1-((P$3/$C57)*(P$3/$C57))))), 0)","v":3.1629966177876398E-4},{"$f":"IF(Q$3<$C57, EXP($C58-($C58/(1-((Q$3/$C57)*(Q$3/$C57))))), 0)","v":4.3383368822159297E-5},{"$f":"IF(R$3<$C57, EXP($C58-($C58/(1-((R$3/$C57)*(R$3/$C57))))), 0)","v":3.5835331001257199E-6},{"$f":"IF(S$3<$C57, EXP($C58-($C58/(1-((S$3/$C57)*(S$3/$C57))))), 0)","v":1.4648973588640926E-7},{"$f":"IF(T$3<$C57, EXP($C58-($C58/(1-((T$3/$C57)*(T$3/$C57))))), 0)","v":2.1611942675557337E-9},{"$f":"IF(U$3<$C57, EXP($C58-($C58/(1-((U$3/$C57)*(U$3/$C57))))), 0)","v":6.6944719580316497E-12},{"$f":"IF(V$3<$C57, EXP($C58-($C58/(1-((V$3/$C57)*(V$3/$C57))))), 0)","v":1.5806584650278782E-15},{"$f":"IF(W$3<$C57, EXP($C58-($C58/(1-((W$3/$C57)*(W$3/$C57))))), 0)","v":3.3485162257759106E-21},{"$f":"IF(X$3<$C57, EXP($C58-($C58/(1-((X$3/$C57)*(X$3/$C57))))), 0)","v":2.7842557074544495E-31},{"$f":"IF(Y$3<$C57, EXP($C58-($C58/(1-((Y$3/$C57)*(Y$3/$C57))))), 0)","v":5.0269544315256723E-54},{"$f":"IF(Z$3<$C57, EXP($C58-($C58/(1-((Z$3/$C57)*(Z$3/$C57))))), 0)","v":9.7536008866354684E-153},{"$f":"IF(AA$3<$C57, EXP($C58-($C58/(1-((AA$3/$C57)*(AA$3/$C57))))), 0)","v":0}]
[null,"L",{"$f":"(C54+C60)/2","v":23.6}]
[null,"k",18.5]
[null,"5-year",null,{"$f":"IF(D$3<$C60, EXP($C61-($C61/(1-((D$3/$C60)*(D$3/$C60))))), 0)","v":0.97326928838885651},0.89687073323423083,0.78140299576020289,0.64211539429928011,0.49590752178997216,0.3582079300353031,0.24046474673798357,0.14879145900604371,8.3972695925126989E-2,4.2645392918456135E-2,1.9153519062092242E-2,7.4389170057318973E-3,2.4258680262619634E-3,6.3871680740768965E-4,1.2875883388604231E-4,1.8463405093658432E-5,1.6957993729567521E-6,8.548281891064491E-8,1.8656922004889885E-9,1.2016412101961364E-11,1.1775829958106232E-14,5.0226147918095454E-19,6.3775397471356708E-26,2.2548535334137624E-38]
[null,"L",26.5]
[null,"k",19]
[null,"5.5-year",null,{"$f":"IF(D$3<$C63, EXP($C64-($C64/(1-((D$3/$C63)*(D$3/$C63))))), 0)","v":0.97781661963891497},{"$f":"IF(E$3<$C63, EXP($C64-($C64/(1-((E$3/$C63)*(E$3/$C63))))), 0)","v":0.91389162200700724},{"$f":"IF(F$3<$C63, EXP($C64-($C64/(1-((F$3/$C63)*(F$3/$C63))))), 0)","v":0.81564702508041986},{"$f":"IF(G$3<$C63, EXP($C64-($C64/(1-((G$3/$C63)*(G$3/$C63))))), 0)","v":0.69403515771396851},{"$f":"IF(H$3<$C63, EXP($C64-($C64/(1-((H$3/$C63)*(H$3/$C63))))), 0)","v":0.56171962576859924},{"$f":"IF(I$3<$C63, EXP($C64-($C64/(1-((I$3/$C63)*(I$3/$C63))))), 0)","v":0.43107448784524627},{"$f":"IF(J$3<$C63, EXP($C64-($C64/(1-((J$3/$C63)*(J$3/$C63))))), 0)","v":0.31240016912775181},{"$f":"IF(K$3<$C63, EXP($C64-($C64/(1-((K$3/$C63)*(K$3/$C63))))), 0)","v":0.21269267899875005},{"$f":"IF(L$3<$C63, EXP($C64-($C64/(1-((L$3/$C63)*(L$3/$C63))))), 0)","v":0.13516391854507348},{"$f":"IF(M$3<$C63, EXP($C64-($C64/(1-((M$3/$C63)*(M$3/$C63))))), 0)","v":7.9528043617305852E-2},{"$f":"IF(N$3<$C63, EXP($C64-($C64/(1-((N$3/$C63)*(N$3/$C63))))), 0)","v":4.2888603151383965E-2},{"$f":"IF(O$3<$C63, EXP($C64-($C64/(1-((O$3/$C63)*(O$3/$C63))))), 0)","v":2.0932816640056823E-2},{"$f":"IF(P$3<$C63, EXP($C64-($C64/(1-((P$3/$C63)*(P$3/$C63))))), 0)","v":9.1001421869511771E-3},{"$f":"IF(Q$3<$C63, EXP($C64-($C64/(1-((Q$3/$C63)*(Q$3/$C63))))), 0)","v":3.4529698974083401E-3},{"$f":"IF(R$3<$C63, EXP($C64-($C64/(1-((R$3/$C63)*(R$3/$C63))))), 0)","v":1.1141204241802056E-3},{"$f":"IF(S$3<$C63, EXP($C64-($C64/(1-((S$3/$C63)*(S$3/$C63))))), 0)","v":2.954579220627391E-4},{"$f":"IF(T$3<$C63, EXP($C64-($C64/(1-((T$3/$C63)*(T$3/$C63))))), 0)","v":6.1560885117634676E-5},{"$f":"IF(U$3<$C63, EXP($C64-($C64/(1-((U$3/$C63)*(U$3/$C63))))), 0)","v":9.4818347337096045E-6},{"$f":"IF(V$3<$C63, EXP($C64-($C64/(1-((V$3/$C63)*(V$3/$C63))))), 0)","v":9.9227106697320452E-7},{"$f":"IF(W$3<$C63, EXP($C64-($C64/(1-((W$3/$C63)*(W$3/$C63))))), 0)","v":6.2573632722956097E-8},{"$f":"IF(X$3<$C63, EXP($C64-($C64/(1-((X$3/$C63)*(X$3/$C63))))), 0)","v":1.9926910036113336E-9},{"$f":"IF(Y$3<$C63, EXP($C64-($C64/(1-((Y$3/$C63)*(Y$3/$C63))))), 0)","v":2.4436298239054225E-11},{"$f":"IF(Z$3<$C63, EXP($C64-($C64/(1-((Z$3/$C63)*(Z$3/$C63))))), 0)","v":7.4455748298630075E-14},{"$f":"IF(AA$3<$C63, EXP($C64-($C64/(1-((AA$3/$C63)*(AA$3/$C63))))), 0)","v":2.6440816721890679E-17}]
[null,"L",29.5]
[null,"k",19.5]
[null,"6-year",null,{"$f":"IF(D$3<$C66, EXP($C67-($C67/(1-((D$3/$C66)*(D$3/$C66))))), 0)","v":0.98167100322694489},0.92850143666330853,0.84567593558938625,0.74099173472722535,0.62375244232693017,0.50350590244875826,0.38884350648792904,0.28645710302845617,0.20059027740303909,0.13293622114924697,8.2943509538671023E-2,4.8414448395134646E-2,2.6235640323760769E-2,1.3076515206219544E-2,5.9271894771945281E-3,2.4094301814646239E-3,8.6338804224635017E-4,2.6691736854410027E-4,6.9281758490250754E-5,1.4582089259363861E-5,2.3787178142723256E-6,2.8328449564698688E-7,2.2720459927738556E-8,1.0977133099112501E-9]
[null,"L",34.5]
[null,"k",22]
[null,"6.5-year",null,{"$f":"IF(D$3<$C69, EXP($C70-($C70/(1-((D$3/$C69)*(D$3/$C69))))), 0)","v":0.98439188741950012},{"$f":"IF(E$3<$C69, EXP($C70-($C70/(1-((E$3/$C69)*(E$3/$C69))))), 0)","v":0.93889259635719802},{"$f":"IF(F$3<$C69, EXP($C70-($C70/(1-((F$3/$C69)*(F$3/$C69))))), 0)","v":0.86730917035833854},{"$f":"IF(G$3<$C69, EXP($C70-($C70/(1-((G$3/$C69)*(G$3/$C69))))), 0)","v":0.77545269546556839},{"$f":"IF(H$3<$C69, EXP($C70-($C70/(1-((H$3/$C69)*(H$3/$C69))))), 0)","v":0.67042493286066784},{"$f":"IF(I$3<$C69, EXP($C70-($C70/(1-((I$3/$C69)*(I$3/$C69))))), 0)","v":0.5597792049796011},{"$f":"IF(J$3<$C69, EXP($C70-($C70/(1-((J$3/$C69)*(J$3/$C69))))), 0)","v":0.45068146495937672},{"$f":"IF(K$3<$C69, EXP($C70-($C70/(1-((K$3/$C69)*(K$3/$C69))))), 0)","v":0.34919208378030753},{"$f":"IF(L$3<$C69, EXP($C70-($C70/(1-((L$3/$C69)*(L$3/$C69))))), 0)","v":0.25976306601789778},{"$f":"IF(M$3<$C69, EXP($C70-($C70/(1-((M$3/$C69)*(M$3/$C69))))), 0)","v":0.18500419637410112},{"$f":"IF(N$3<$C69, EXP($C70-($C70/(1-((N$3/$C69)*(N$3/$C69))))), 0)","v":0.12572303629687859},{"$f":"IF(O$3<$C69, EXP($C70-($C70/(1-((O$3/$C69)*(O$3/$C69))))), 0)","v":8.1197225556110642E-2},{"$f":"IF(P$3<$C69, EXP($C70-($C70/(1-((P$3/$C69)*(P$3/$C69))))), 0)","v":4.9602258675468122E-2},{"$f":"IF(Q$3<$C69, EXP($C70-($C70/(1-((Q$3/$C69)*(Q$3/$C69))))), 0)","v":2.8500445939974469E-2},{"$f":"IF(R$3<$C69, EXP($C70-($C70/(1-((R$3/$C69)*(R$3/$C69))))), 0)","v":1.5299758745265511E-2},{"$f":"IF(S$3<$C69, EXP($C70-($C70/(1-((S$3/$C69)*(S$3/$C69))))), 0)","v":7.6125441048382541E-3},{"$f":"IF(T$3<$C69, EXP($C70-($C70/(1-((T$3/$C69)*(T$3/$C69))))), 0)","v":3.477163299115806E-3},{"$f":"IF(U$3<$C69, EXP($C70-($C70/(1-((U$3/$C69)*(U$3/$C69))))), 0)","v":1.4412820885760531E-3},{"$f":"IF(V$3<$C69, EXP($C70-($C70/(1-((V$3/$C69)*(V$3/$C69))))), 0)","v":5.3456594175795404E-4},{"$f":"IF(W$3<$C69, EXP($C70-($C70/(1-((W$3/$C69)*(W$3/$C69))))), 0)","v":1.7438555583782503E-4},{"$f":"IF(X$3<$C69, EXP($C70-($C70/(1-((X$3/$C69)*(X$3/$C69))))), 0)","v":4.8982344901572315E-5},{"$f":"IF(Y$3<$C69, EXP($C70-($C70/(1-((Y$3/$C69)*(Y$3/$C69))))), 0)","v":1.1535738512670548E-5},{"$f":"IF(Z$3<$C69, EXP($C70-($C70/(1-((Z$3/$C69)*(Z$3/$C69))))), 0)","v":2.2025496250708823E-6},{"$f":"IF(AA$3<$C69, EXP($C70-($C70/(1-((AA$3/$C69)*(AA$3/$C69))))), 0)","v":3.2654890531650029E-7}]
[null,"L",{"$f":"(C66+C72)/2","v":38.25}]
[null,"k",23]
[null,"7-year",null,{"$f":"IF(D$3<$C72, EXP($C73-($C73/(1-((D$3/$C72)*(D$3/$C72))))), 0)","v":0.98647908063308409},0.94691546626748857,0.88419564489518343,0.80277593899365662,0.70820202712877678,0.60653065971263342,0.50373029368896272,0.40513723729160378,0.31503226592202982,0.23638163270365534,0.17075961386071081,0.11844182901380375,7.8634345568872721E-2,4.9787068367863944E-2,2.9933652499726321E-2,1.7004614050291966E-2,9.0737206737716795E-3,4.5165809426126746E-3,2.0801015585642062E-3,8.7777244941069125E-4,3.3546262790251185E-4,1.1449264189049945E-4,3.4306972542805295E-5,8.8387628839399653E-6]
[null,"L",42]
[null,"k",24]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U89-($C$32*V81)","v":0},{"$f":"V89-($C$32*W81)","v":0},{"$f":"W89-($C$32*X81)","v":0}]

{"sheet":"survival data 2","index":4,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,6,4,10]]}
[null,"Tool to plot net survival and estimate median survival time"]
[]
[null,"Plotting functional survival",null,null,null,null,null,null,null,"Developed by Albert Kilian"]
[]
[null,"Location/Brand:","B",null,null,"Data description:"]
[]
[null,null,"years*","survival (%)","95% CI low","95% CI high"]
[null,null,0,100,100,100,{"$f":"D8-E8","v":0},{"$f":"F8-D8","v":0},null,"Decimal year calculator"]
[null,null,null,null,null,null,0,0,null,"Months","in years"]
[null,null,null,null,null,null,0,0,null,0,{"$f":"J10/12","v":0}]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,"This tool was developed as part of the NetWorks Project"]
[null,null,"* since distribution",null,null,null,null,null,null,null,null,null,null,null,"with funding from USAID/PMI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooperative Agreement No. GHS-A‐00‐09-00014-00"]
[null,"Median survival calculator",null,null,null,null,null,null,null,"Formula for median survival"]
[]
[null,null,"time (yrs)",null,"survival (%)","95% CI low","95% CI high"]
[null,"t1",null,"p1"]
[null,"t2",null,"p2",null,null,null,null,null,"tm=","median survival"]
[null,null,null,null,null,null,null,null,null,"t1=","first time point (years since distribution) "]
[null,null,"tm","95% CI low","95% CI high",null,null,null,null,"t2=","second time point"]
[null,null,{"$f":"IF( AND(C19>0, C20>0,E19>0, E20>0), C19+((C20-C19)*(E19-50)/(E19-E20)), \" \")","v":" "},{"$f":"IF(AND(C19>0, C20>0, F19>0, F20>0), C19+((C20-C19)*(F19-50)/(F19-F20)), \" \")","v":" "},{"$f":"IF(AND(C19>0, C20>0, G19>0, G20>0), C19+((C20-C19)*(G19-50)/(G19-G20)), \" \")","v":" "},null,null,null,null,"p1=","functional survival at t1"]
[]
[null,null,null,null,null,null,null,null,null,"p2=","functional survival at t2"]

{"sheet":"survival data 3","index":5,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,6,4,10]]}
[null,"Tool to plot net survival and estimate median survival time"]
[]
[null,"Plotting functional survival",null,null,null,null,null,null,null,"Developed by Albert Kilian"]
[]
[null,"Location/Brand:","C",null,null,"Data description:"]
[]
[null,null,"years*","survival (%)","95% CI low","95% CI high"]
[null,null,0,100,100,100,{"$f":"D8-E8","v":0},{"$f":"F8-D8","v":0},null,"Decimal year calculator"]
[null,null,null,null,null,null,0,0,null,"Months","in years"]
[null,null,null,null,null,null,0,0,null,0,{"$f":"J10/12","v":0}]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,"This tool was developed as part of the NetWorks Project"]
[null,null,"* since distribution",null,null,null,null,null,null,null,null,null,null,null,"with funding from USAID/PMI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooperative Agreement No. GHS-A‐00‐09-00014-00"]
[null,"Median survival calculator",null,null,null,null,null,null,null,"Formula for median survival"]
[]
[null,null,"time (yrs)",null,"survival (%)","95% CI low","95% CI high"]
[null,"t1",null,"p1"]
[null,"t2",null,"p2",null,null,null,null,null,"tm=","median survival"]
[null,null,null,null,null,null,null,null,null,"t1=","first time point (years since distribution) "]
[null,null,"tm","95% CI low","95% CI high",null,null,null,null,"t2=","second time point"]
[null,null,{"$f":"IF( AND(C19>0, C20>0,E19>0, E20>0), C19+((C20-C19)*(E19-50)/(E19-E20)), \" \")","v":" "},{"$f":"IF(AND(C19>0, C20>0, F19>0, F20>0), C19+((C20-C19)*(F19-50)/(F19-F20)), \" \")","v":" "},{"$f":"IF(AND(C19>0, C20>0, G19>0, G20>0), C19+((C20-C19)*(G19-50)/(G19-G20)), \" \")","v":" "},null,null,null,null,"p1=","functional survival at t1"]
[]
[null,null,null,null,null,null,null,null,null,"p2=","functional survival at t2"]