{"text_format":"3","workbook":"xlsb","n_sheets":6,"sheets":["OLT BI Freq","Scenario1","Scenario2","Scenario3","Scenario4","Scenario5"],"not_rendered":{"charts":12,"macros":1,"defined_names":213},"read":"bin_skipped_in_rows","date_system":"1900","formulas":"cached_only","passed_over":{"ids":[37,38,1024],"n":981}}

{"sheet":"OLT BI Freq","index":0,"n_rows":44,"n_cols":13,"rows_kept":44,"hidden":true,"read":"bin_skipped_in_rows","flags":["formulas_cached_only","records_skipped"],"rows_in_doubt":{"n":9,"rows":[4,13,36,37,38,40,41,42,43]},"rows_in_doubt_other":2}
[]
[{"$nulls":6},"OLT BI Frequency 3yrCDF- SOLM Trend"]
[]
[{"$nulls":10},"Smoother:",3]
[{"$nulls":5},"# Points",23,{"$nulls":3},"# Param:",{"v":7.124216633390694,"d":"7.12"}]
[{"$nulls":10},"Std Error:",{"v":1.2409264870406063,"d":"1.24"}]
[{"$nulls":10},"GCV:",0.31144292709197524]
[]
[]
[{"$nulls":5},"Ultimate",{"$nulls":4},"Smoothing"]
["3Yr CDF","Index","Weights",null,"Year","Severity",null,"Trend",null,null,"Spline","Trend","Error"]
[null,"X","w",null,null,"Y","log(Y)",null,null,"log(Y)","Y_hat"]
[]
[1,1,{"v":1,"d":"1.000"},null,1997,{"v":23.703383573120384,"d":"23.70"},3.1656178047492043,null,null,3.1989394065288743,{"v":24.50652494868813,"d":"25"},null,{"v":-0.8031413755677477,"d":"-0.80"}]
[{"v":0.9999612545763771,"d":"1.000"},2,{"v":1,"d":"1.000"},null,1998,{"v":23.703383573120384,"d":"23.70"},3.1656178047492043,{"v":0,"d":"0.0%"},null,3.189312862646482,{"v":24.271743690011608,"d":"24"},{"v":-0.009580357034222886,"d":"-0.958%"},{"v":-0.568360116891224,"d":"-0.57"}]
[{"v":1.000157112832486,"d":"1.000"},3,{"v":1,"d":"1.000"},null,1999,{"v":23.703383573120384,"d":"23.70"},3.1656178047492043,{"v":0,"d":"0.0%"},null,3.1672627260654593,{"v":23.742405859523767,"d":"24"},{"v":-0.021808809340124746,"d":"-2.181%"},{"v":-0.03902228640338379,"d":"-0.04"}]
[{"v":1.0004484330649963,"d":"1.000"},4,{"v":1,"d":"1.000"},null,2000,{"v":23.703383573120384,"d":"23.70"},3.1656178047492043,{"v":0,"d":"0.0%"},null,3.115008451147982,{"v":22.533620787653796,"d":"23"},{"v":-0.050912492989209523,"d":"-5.091%"},{"v":1.1697627854665882,"d":"1.17"}]
[{"v":1.0011975718050607,"d":"1.001"},5,{"v":1,"d":"1.000"},null,2001,{"v":23.703383573120384,"d":"23.70"},3.1656178047492043,{"v":0,"d":"0.0%"},null,3.0158991928361623,{"v":20.407432910306856,"d":"20"},{"v":-0.09435624648977325,"d":"-9.436%"},{"v":3.295950662813528,"d":"3.30"}]
[{"v":1.0019755920685938,"d":"1.002"},6,{"v":1,"d":"1.000"},null,2002,{"v":18.354132761902985,"d":"18.35"},2.9098547677749855,{"v":-0.22567456644811856,"d":"-22.6%"},null,2.872756945238878,{"v":17.6857095820877,"d":"18"},{"v":-0.13336921601954832,"d":"-13.337%"},{"v":0.6684231798152851,"d":"0.67"}]
[{"v":1.004023122321638,"d":"1.004"},7,{"v":1,"d":"1.000"},null,2003,{"v":12.653656167386703,"d":"12.65"},2.537946198503682,{"v":-0.3105827264336104,"d":"-31.1%"},null,2.726547126008868,{"v":15.280035789935054,"d":"15"},{"v":-0.13602359469869063,"d":"-13.602%"},{"v":-2.6263796225483507,"d":"-2.63"}]
[{"v":1.0051691312948396,"d":"1.005"},8,{"v":1,"d":"1.000"},null,2004,{"v":13.024298314955841,"d":"13.02"},2.5668167140159768,{"v":0.029291308588297538,"d":"2.9%"},null,2.6243189847184465,{"v":13.795176260519716,"d":"14"},{"v":-0.09717644315947305,"d":"-9.718%"},{"v":-0.7708779455638748,"d":"-0.77"}]
[{"v":1.0086479488426041,"d":"1.009"},9,{"v":1,"d":"1.000"},null,2005,{"v":13.757103784129608,"d":"13.76"},2.62155532954647,{"v":0.05626448745667045,"d":"5.6%"},null,2.570076873262869,{"v":13.06682889209863,"d":"13"},{"v":-0.0527972498985414,"d":"-5.280%"},{"v":0.6902748920309776,"d":"0.69"}]
[{"v":1.011398663186485,"d":"1.011"},10,{"v":1,"d":"1.000"},null,2006,{"v":12.563841136387252,"d":"12.56"},2.5308229372465116,{"v":-0.08673792583573592,"d":"-8.7%"},null,2.5474289460912094,{"v":12.774218321684103,"d":"13"},{"v":-0.02239338808450042,"d":"-2.239%"},{"v":-0.210377185296851,"d":"-0.21"}]
[{"v":1.0139178943086786,"d":"1.014"},11,{"v":1,"d":"1.000"},null,2007,{"v":13.060393964478806,"d":"13.06"},2.5695842891267544,{"v":0.03952237398588587,"d":"4.0%"},null,2.547305887962949,{"v":12.77264644700541,"d":"13"},{"v":-0.0001230505569193019,"d":"-0.012%"},{"v":0.2877475174733952,"d":"0.29"}]
[{"v":1.0161940649956143,"d":"1.016"},12,{"v":1,"d":"1.000"},null,2008,{"v":12.559083343822827,"d":"12.56"},2.5304441761970127,{"v":-0.03838403512324551,"d":"-3.8%"},null,2.561045762641384,{"v":12.949352185924837,"d":"13"},{"v":0.013834700557366242,"d":"1.383%"},{"v":-0.3902688421020102,"d":"-0.39"}]
[{"v":1.0207713105755947,"d":"1.021"},13,{"v":1,"d":"1.000"},null,2009,{"v":13.308375225641726,"d":"13.31"},2.5883935532533138,{"v":0.0596613511755566,"d":"6.0%"},null,2.582314745521257,{"v":13.227721558844376,"d":"13"},{"v":0.021496779832902213,"d":"2.150%"},{"v":0.08065366679734964,"d":"0.08"}]
[{"v":1.0297986417792344,"d":"1.030"},14,{"v":1,"d":"1.000"},null,2010,{"v":13.927774181152756,"d":"13.93"},2.633884989034103,{"v":0.0465420417601099,"d":"4.7%"},null,2.599554059948319,{"v":13.457735353484074,"d":"13"},{"v":0.017388769004281324,"d":"1.739%"},{"v":0.47003882766868266,"d":"0.47"}]
[{"v":1.0402742700476586,"d":"1.040"},15,{"v":1,"d":"1.000"},null,2011,{"v":14.116477546858336,"d":"14.12"},2.6473427354234493,{"v":0.013548709452866792,"d":"1.4%"},null,2.6027629611333025,{"v":13.500989258044243,"d":"14"},{"v":0.003214055219845857,"d":"0.321%"},{"v":0.6154882888140936,"d":"0.62"}]
[{"v":1.0599619445231259,"d":"1.060"},16,{"v":1,"d":"1.000"},null,2012,{"v":12.448757359593717,"d":"12.45"},2.5216208074549193,{"v":-0.11813996669698779,"d":"-11.8%"},null,2.592384165307249,{"v":13.361589897170067,"d":"13"},{"v":-0.01032512197512625,"d":"-1.033%"},{"v":-0.9128325375763495,"d":"-0.91"}]
[{"v":1.098100174461487,"d":"1.098"},17,{"v":1,"d":"1.000"},null,2013,{"v":13.540090952091054,"d":"13.54"},{"v":2.60565498475042,"d":"2.6057"},{"v":0.0876660666581548,"d":"8.8%"},null,2.57674298138977,{"v":13.154224757880735,"d":"13"},{"v":-0.015519495874757427,"d":"-1.552%"},{"v":0.385866194210319,"d":"0.39"}]
[{"v":1.1684427920529554,"d":"1.168"},18,{"v":1,"d":"1.000"},null,2014,{"v":13.393651566639281,"d":"13.39"},2.5947808310117577,{"v":-0.010815243853968148,"d":"-1.1%"},null,2.5525224042027785,{"v":12.839449252093962,"d":"13"},{"v":-0.02392961284914874,"d":"-2.393%"},{"v":0.5542023145453197,"d":"0.55"}]
[{"v":1.317560981633456,"d":"1.318"},19,{"v":1,"d":"1.000"},null,2015,{"v":12.22121946323227,"d":"12.22"},2.503173741173051,{"v":-0.08753640465959922,"d":"-8.8%"},null,2.521246710923675,{"v":12.44410119362926,"d":"12"},{"v":-0.030791667983751325,"d":"-3.079%"},{"v":-0.2228817303969901,"d":"-0.22"}]
[{"v":1.7035877797173586,"d":"1.704"},20,{"v":1,"d":"1.000"},null,2016,{"v":11.474276807488627,"d":"11.47"},2.4401077306480183,{"v":-0.061118504416914465,"d":"-6.1%"},null,2.494433108776861,{"v":12.114863761634963,"d":"12"},{"v":-0.02645730911950872,"d":"-2.646%"},{"v":-0.640586954146336,"d":"-0.64"}]
[{"v":2.821919221172013,"d":"2.822"},21,{"v":1,"d":"1.000"},null,2017,{"v":11.958489934726114,"d":"11.96"},2.481441480912782,{"v":0.04219988199356206,"d":"4.2%"},null,2.4789122033021544,{"v":11.92828181234516,"d":"12"},{"v":-0.015401076971304106,"d":"-1.540%"},{"v":0.030208122380953384,"d":"0.03"}]
[{"v":6.817390625527301,"d":"6.817"},22,{"v":1,"d":"1.000"},null,2018,{"v":12.230861157465007,"d":"12.23"},2.5039623607496013,{"v":0.022776389345611214,"d":"2.3%"},null,2.4685787553362912,{"v":11.805656196787126,"d":"12"},{"v":-0.01028024131951033,"d":"-1.028%"},{"v":0.42520496067788116,"d":"0.43"}]
[{"v":41.847550807195695,"d":"41.848"},23,{"v":1,"d":"1.000"},null,2019,{"v":11.550351589146151,"d":"11.55"},2.4467158771232107,{"v":-0.0556387289135003,"d":"-5.6%"},null,2.4568372667008473,{"v":11.66785082201925,"d":"12"},{"v":-0.01167282635296285,"d":"-1.167%"},{"v":-0.11749923287309905,"d":"-0.12"}]
[null,24,null,null,2020,{"$nulls":4},2.444533478644424,{"v":11.52517160578131,"d":"12"},{"v":-0.012228405934765707,"d":"-1.223%"}]
[null,25,null,null,2021,{"$nulls":4},2.432229690588,{"v":11.384237128917976,"d":"11"},{"v":-0.012228405934766151,"d":"-1.223%"}]
[null,26,null,null,2022,{"$nulls":4},2.4199259025315767,{"v":11.245026056047935,"d":"11"},{"v":-0.012228405934765707,"d":"-1.223%"}]
[]
[{"$nulls":4},"All Year Avg:",{"v":-0.030773167820090874,"d":"-3.1%"},"All Year Avg:",{"v":-0.03165575293534595,"d":"-3.2%"},{"$nulls":3},{"v":-0.03165575293534573,"d":"-3.2%"}]
[{"$nulls":4},"10 Year Avg:",{"v":-0.018542837540997947,"d":"-1.9%"},null,{"v":-0.020854207740252706,"d":"-2.1%"},{"$nulls":3},{"v":-0.018429906096497972,"d":"-1.8%"}]
[{"$nulls":4},"5 Year Avg:",{"v":-0.011228062271094297,"d":"-1.1%"},null,{"v":-0.004894094500615731,"d":"-0.5%"},{"$nulls":3},{"v":-0.015348319481336747,"d":"-1.5%"}]
[{"$nulls":4},"3 Year Avg:",{"v":-0.01150846635921321,"d":"-1.2%"},null,{"v":-0.017212937061297118,"d":"-1.7%"},{"$nulls":3},{"v":-0.01097677893827187,"d":"-1.1%"}]

{"sheet":"Scenario1","index":1,"n_rows":61,"n_cols":15,"rows_kept":61,"read":"bin_skipped_in_rows","flags":["formulas_cached_only","records_skipped"],"rows_in_doubt":{"n":10,"rows":[4,13,48,49,50,52,53,54,55,56]},"rows_in_doubt_other":4}
["SCHEDULE P P&C INDUSTRY COMM AUTO LIABILITY ULR"]
["Direct and assumed"]
[]
[{"$nulls":8},"Smoother:",1e-07]
[{"$nulls":3},"# Points",{"v":35,"d":"35.000"},{"$nulls":3},"# Param:",{"v":34.999953275594194,"d":"35.00"}]
[{"$nulls":8},"Std Error:",{"v":2.5604219817501374e-05,"d":"0.00"}]
[{"$nulls":8},"GCV:",{"v":0.0037457574629264825,"d":"0.00"}]
[]
[]
[{"$nulls":8},"Smoothing","Smoothed"]
["Index","Weights","Year","Loss Ratio",null,"Trend",null,null,"Spline","Trend","Error","LL","UL","10Yr"]
["X","w",null,"Y","log(Y)",null,null,"log(Y)","Y_hat"]
[]
[1,{"v":1,"d":"1.000"},1987,{"v":0.7450000110583505,"d":"74.5%"},-0.29437104575915424,null,null,-0.2943710418048796,{"v":0.7450000140042851,"d":"74.5%"},null,{"v":-2.945934607367917e-09,"d":"-0.00"},{"v":0.7449498297334427,"d":"0.74"},{"v":0.7450501982751274,"d":"0.75"}]
[2,{"v":1,"d":"1.000"},1988,{"v":0.801367175137667,"d":"80.1%"},-0.22143604101792005,{"v":0.07566062180219446,"d":"7.6%"},null,-0.22143603825608552,{"v":0.8013671773509106,"d":"80.1%"},{"v":0.0756606205195336,"d":"7.6%"},{"v":-2.21324358840036e-09,"d":"-0.00"},{"v":0.8013169930800682,"d":"0.80"},{"v":0.8014173616217529,"d":"0.80"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[3,{"v":1,"d":"1.000"},1989,{"v":0.8247732156286547,"d":"82.5%"},-0.1926468205837632,{"v":0.0292076356720834,"d":"2.9%"},null,-0.19264683951234574,{"v":0.8247732000168669,"d":"82.5%"},{"v":0.029207613348140704,"d":"2.9%"},{"v":1.5611787751446116e-08,"d":"0.00"},{"v":0.8247230157460246,"d":"0.82"},{"v":0.8248233842877093,"d":"0.82"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[4,{"v":1,"d":"1.000"},1990,{"v":0.7874039734631337,"d":"78.7%"},-0.23901385417696003,{"v":-0.04530850597159308,"d":"-4.5%"},null,-0.23901384371083204,{"v":0.7874039817042046,"d":"78.7%"},{"v":-0.04530847790871251,"d":"-4.5%"},{"v":-8.241070825754093e-09,"d":"-0.00"},{"v":0.7873537974333622,"d":"0.79"},{"v":0.7874541659750469,"d":"0.79"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[5,{"v":1,"d":"1.000"},1991,{"v":0.7502089577689091,"d":"75.0%"},-0.287403500897894,{"v":-0.04723752603207576,"d":"-4.7%"},null,-0.2874035035248977,{"v":0.7502089557981074,"d":"75.0%"},{"v":-0.04723753850672019,"d":"-4.7%"},{"v":1.9708016330000078e-09,"d":"0.00"},{"v":0.7501587715272651,"d":"0.75"},{"v":0.7502591400689498,"d":"0.75"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[6,{"v":1,"d":"1.000"},1992,{"v":0.7419076607544931,"d":"74.2%"},-0.29853048998137116,{"v":-0.01106531310836878,"d":"-1.1%"},null,-0.29853048208679345,{"v":0.7419076666115408,"d":"74.2%"},{"v":-0.011065302703211932,"d":"-1.1%"},{"v":-5.857047735702281e-09,"d":"-0.00"},{"v":0.7418574823406985,"d":"0.74"},{"v":0.7419578508823832,"d":"0.74"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[7,{"v":1,"d":"1.000"},1993,{"v":0.7817679864681769,"d":"78.2%"},-0.24619727495468952,{"v":0.053726801625349596,"d":"5.4%"},null,-0.24619726106190204,{"v":0.7817679973291135,"d":"78.2%"},{"v":0.05372680794582396,"d":"5.4%"},{"v":-1.0860936594525583e-08,"d":"-0.00"},{"v":0.7817178130582711,"d":"0.78"},{"v":0.7818181815999559,"d":"0.78"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[8,{"v":1,"d":"1.000"},1994,{"v":0.838942500784609,"d":"83.9%"},-0.17561310789726567,{"v":0.0731348882354872,"d":"7.3%"},null,-0.17561314686322926,{"v":0.8389424680944066,"d":"83.9%"},{"v":0.07313483151091882,"d":"7.3%"},{"v":3.2690202322882556e-08,"d":"0.00"},{"v":0.8388922838235643,"d":"0.84"},{"v":0.838992652365249,"d":"0.84"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[9,{"v":1,"d":"1.000"},1995,{"v":0.8412886820413054,"d":"84.1%"},-0.17282041745618484,{"v":0.002796593633654476,"d":"0.3%"},null,-0.1728203868548608,{"v":0.8412887077858533,"d":"84.1%"},{"v":0.002796663395495891,"d":"0.3%"},{"v":-2.5744547937911477e-08,"d":"-0.00"},{"v":0.8412385235150109,"d":"0.84"},{"v":0.8413388920566957,"d":"0.84"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[10,{"v":1,"d":"1.000"},1996,{"v":0.870885312173737,"d":"87.1%"},-0.1382449845379159,{"v":0.03518011208782501,"d":"3.5%"},null,-0.13824499152005096,{"v":0.8708853060930981,"d":"87.1%"},{"v":0.03518007318217631,"d":"3.5%"},{"v":6.080638881300615e-09,"d":"0.00"},{"v":0.8708351218222558,"d":"0.87"},{"v":0.8709354903639405,"d":"0.87"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[11,{"v":1,"d":"1.000"},1997,{"v":0.9050712397881788,"d":"90.5%"},-0.0997416203823223,{"v":0.039254224565015816,"d":"3.9%"},null,-0.09974163497765796,{"v":0.9050712265783604,"d":"90.5%"},{"v":0.039254216652965024,"d":"3.9%"},{"v":1.320981846131275e-08,"d":"0.00"},{"v":0.905021042307518,"d":"0.91"},{"v":0.9051214108492027,"d":"0.91"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.013390276908656018,"d":"1.3%"}]
[12,{"v":1,"d":"1.000"},1998,{"v":0.9367919018673363,"d":"93.7%"},-0.06529411119869982,{"v":0.035047696451586896,"d":"3.5%"},null,-0.06529407213062502,{"v":0.9367919384659931,"d":"93.7%"},{"v":0.0350477519957777,"d":"3.5%"},{"v":-3.659865677185792e-08,"d":"-0.00"},{"v":0.9367417541951507,"d":"0.94"},{"v":0.9368421227368354,"d":"0.94"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.020291535917592363,"d":"2.0%"}]
[13,{"v":1,"d":"1.000"},1999,{"v":1.0009400901415864,"d":"100.1%"},0.000939648533595079,{"v":0.06847645474558606,"d":"6.8%"},null,0.0009396130787950301,{"v":1.0009400546534561,"d":"100.1%"},{"v":0.06847637511965177,"d":"6.8%"},{"v":3.548813021225783e-08,"d":"0.00"},{"v":1.000889870382614,"d":"1.00"},{"v":1.0009902389242984,"d":"1.00"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.030985143279761207,"d":"3.1%"}]
[14,{"v":1,"d":"1.000"},2000,{"v":0.9586438907550607,"d":"95.9%"},-0.04223560699654608,{"v":-0.04225647449143799,"d":"-4.2%"},null,-0.04223560292069122,{"v":0.9586438946623541,"d":"95.9%"},{"v":-0.04225643663120837,"d":"-4.2%"},{"v":-3.9072933777362095e-09,"d":"-0.00"},{"v":0.9585937103915118,"d":"0.96"},{"v":0.9586940789331965,"d":"0.96"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.03370406565177442,"d":"3.4%"}]
[15,{"v":1,"d":"1.000"},2001,{"v":0.8423531339695072,"d":"84.2%"},-0.17155595364932777,{"v":-0.1213075657259538,"d":"-12.1%"},null,-0.17155595958665282,{"v":0.8423531289681828,"d":"84.2%"},{"v":-0.12130757452445917,"d":"-12.1%"},{"v":5.0013243546587205e-09,"d":"0.00"},{"v":0.8423029446973405,"d":"0.84"},{"v":0.8424033132390252,"d":"0.84"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02338653895861631,"d":"2.3%"}]
[16,{"v":1,"d":"1.000"},2002,{"v":0.7247393531178832,"d":"72.5%"},-0.32194320170858354,{"v":-0.13962526654038843,"d":"-14.0%"},null,-0.3219431871857965,{"v":0.7247393636431185,"d":"72.5%"},{"v":-0.13962524893702477,"d":"-14.0%"},{"v":-1.0525235349945206e-08,"d":"-0.00"},{"v":0.7246891793722762,"d":"0.72"},{"v":0.7247895479139609,"d":"0.72"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.002740792757875976,"d":"0.3%"}]
[17,{"v":1,"d":"1.000"},2003,{"v":0.6572212360542009,"d":"65.7%"},-0.41973458041624134,{"v":-0.09316193024873598,"d":"-9.3%"},null,-0.4197345863628935,{"v":0.6572212321459349,"d":"65.7%"},{"v":-0.09316194881120243,"d":"-9.3%"},{"v":3.908266044128084e-09,"d":"0.00"},{"v":0.6571710478750925,"d":"0.66"},{"v":0.6572714164167772,"d":"0.66"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.019021347423696322,"d":"-1.9%"}]
[18,{"v":1,"d":"1.000"},2004,{"v":0.6260785610578213,"d":"62.6%"},-0.4682794188586372,{"v":-0.04738537540775878,"d":"-4.7%"},null,-0.4682794109407351,{"v":0.6260785660150501,"d":"62.6%"},{"v":-0.047385362200181635,"d":"-4.7%"},{"v":-4.9572287386112635e-09,"d":"-0.00"},{"v":0.6260283817442077,"d":"0.63"},{"v":0.6261287502858924,"d":"0.63"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.036309420341507304,"d":"-3.6%"}]
[19,{"v":1,"d":"1.000"},2005,{"v":0.6258254937639587,"d":"62.6%"},-0.46868371069926984,{"v":-0.0004042101256990227,"d":"-0.0%"},null,-0.4686837184672452,{"v":0.6258254889025617,"d":"62.6%"},{"v":-0.00040422580523580276,"d":"-0.0%"},{"v":4.861396951660879e-09,"d":"0.00"},{"v":0.6257753046317194,"d":"0.63"},{"v":0.6258756731734041,"d":"0.63"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.049772495518247695,"d":"-5.0%"}]
[20,{"v":1,"d":"1.000"},2006,{"v":0.636365703567735,"d":"63.6%"},-0.45198187528474987,{"v":0.01684209082053112,"d":"1.7%"},null,-0.4519818709471975,{"v":0.6363657063280046,"d":"63.6%"},{"v":0.016842103129941277,"d":"1.7%"},{"v":-2.760269568469198e-09,"d":"-0.00"},{"v":0.6363155220571622,"d":"0.64"},{"v":0.636415890598847,"d":"0.64"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.05665236670415785,"d":"-5.7%"}]
[21,{"v":1,"d":"1.000"},2007,{"v":0.6584626382906333,"d":"65.8%"},-0.4178474970080855,{"v":0.03472364176606879,"d":"3.5%"},null,-0.4178474875747214,{"v":0.6584626445021512,"d":"65.8%"},{"v":0.03472364703882569,"d":"3.5%"},{"v":-6.211517855625459e-09,"d":"-0.00"},{"v":0.6584124602313088,"d":"0.66"},{"v":0.6585128287729936,"d":"0.66"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.05574153640657786,"d":"-5.6%"}]
[22,{"v":1,"d":"1.000"},2008,{"v":0.6718992974568828,"d":"67.2%"},-0.39764680466324287,{"v":0.02040610717280944,"d":"2.0%"},null,-0.3976468533545646,{"v":0.6718992647412187,"d":"67.2%"},{"v":0.02040604786202671,"d":"2.0%"},{"v":3.2715664066707006e-08,"d":"0.00"},{"v":0.6718490804703764,"d":"0.67"},{"v":0.6719494490120611,"d":"0.67"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.0479484578496302,"d":"-4.8%"}]
[23,{"v":1,"d":"1.000"},2009,{"v":0.6625147381996628,"d":"66.3%"},-0.4117124750300923,{"v":-0.01396721099834497,"d":"-1.4%"},null,-0.41171240075089405,{"v":0.6625147874107282,"d":"66.3%"},{"v":-0.01396708974537264,"d":"-1.4%"},{"v":-4.92110654448652e-08,"d":"-0.00"},{"v":0.6624646031398859,"d":"0.66"},{"v":0.6625649716815706,"d":"0.66"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.03269359496604318,"d":"-3.3%"}]
[24,{"v":1,"d":"1.000"},2010,{"v":0.7443167099141158,"d":"74.4%"},-0.2952886493589221,{"v":0.12347192748759683,"d":"12.3%"},null,-0.29528869012538395,{"v":0.7443166795709577,"d":"74.4%"},{"v":0.1234717982370348,"d":"12.3%"},{"v":3.034315809724575e-08,"d":"0.00"},{"v":0.7442664953001153,"d":"0.74"},{"v":0.7443668638418001,"d":"0.74"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.008830733720889938,"d":"-0.9%"}]
[25,{"v":1,"d":"1.000"},2011,{"v":0.7947571977470933,"d":"79.5%"},-0.22971862261431414,{"v":0.06776750697804124,"d":"6.8%"},null,-0.22971863282439073,{"v":0.7947571896325615,"d":"79.5%"},{"v":0.06776753960515691,"d":"6.8%"},{"v":8.114531824254811e-09,"d":"0.00"},{"v":0.7947070053617191,"d":"0.79"},{"v":0.7948073739034038,"d":"0.79"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.01361440422258875,"d":"1.4%"}]
[26,{"v":1,"d":"1.000"},2012,{"v":0.7934612135391687,"d":"79.3%"},-0.23135062043824137,{"v":-0.0016306668396315338,"d":"-0.2%"},null,-0.23135059903103886,{"v":0.7934612305249537,"d":"79.3%"},{"v":-0.0016306352739092755,"d":"-0.2%"},{"v":-1.6985785000755982e-08,"d":"-0.00"},{"v":0.7934110462541113,"d":"0.79"},{"v":0.793511414795796,"d":"0.79"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02685963305366168,"d":"2.7%"}]
[27,{"v":1,"d":"1.000"},2013,{"v":0.805573898439145,"d":"80.6%"},-0.21620033825269938,{"v":0.015265629489245702,"d":"1.5%"},null,-0.21620035090724346,{"v":0.8055738882449747,"d":"80.6%"},{"v":0.015265594907525992,"d":"1.5%"},{"v":1.019417028569336e-08,"d":"0.00"},{"v":0.8055237039741323,"d":"0.81"},{"v":0.805624072515817,"d":"0.81"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.03323720478471781,"d":"3.3%"}]
[28,{"v":1,"d":"1.000"},2014,{"v":0.8147364110873347,"d":"81.5%"},-0.20489064003217244,{"v":0.011373894643238458,"d":"1.1%"},null,-0.20489063395843543,{"v":0.8147364160358295,"d":"81.5%"},{"v":0.011373913584533213,"d":"1.1%"},{"v":-4.94849472509884e-09,"d":"-0.00"},{"v":0.8146862317649871,"d":"0.81"},{"v":0.8147866003066718,"d":"0.81"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.034379598394197686,"d":"3.4%"}]
[29,{"v":1,"d":"1.000"},2015,{"v":0.8357028771245523,"d":"83.6%"},-0.17948213920868264,{"v":0.02573404815581526,"d":"2.6%"},null,-0.17948213374798513,{"v":0.8357028816880729,"d":"83.6%"},{"v":0.025734047526999815,"d":"2.6%"},{"v":-4.563520672462573e-09,"d":"-0.00"},{"v":0.8356526974172306,"d":"0.84"},{"v":0.8357530659589153,"d":"0.84"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.033626232652777865,"d":"3.4%"}]
[30,{"v":1,"d":"1.000"},2016,{"v":0.8602455877795842,"d":"86.0%"},-0.15053736331556852,{"v":0.029367746990984767,"d":"2.9%"},null,-0.15053737301802425,{"v":0.8602455794330894,"d":"86.0%"},{"v":0.02936773138252402,"d":"2.9%"},{"v":8.346494717592634e-09,"d":"0.00"},{"v":0.8601953951622471,"d":"0.86"},{"v":0.8602957637039318,"d":"0.86"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.032033812045587196,"d":"3.2%"}]
[31,{"v":1,"d":"1.000"},2017,{"v":0.8530171275758617,"d":"85.3%"},-0.15897565247063403,{"v":-0.008402786723242794,"d":"-0.8%"},null,-0.15897566107257133,{"v":0.8530171202382618,"d":"85.3%"},{"v":-0.008402785631971832,"d":"-0.8%"},{"v":7.337599861045874e-09,"d":"0.00"},{"v":0.8529669359674195,"d":"0.85"},{"v":0.8530673045091042,"d":"0.85"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.028551095678875704,"d":"2.9%"}]
[32,{"v":1,"d":"1.000"},2018,{"v":0.8387874631541138,"d":"83.9%"},-0.17579792623426732,{"v":-0.016681569410202046,"d":"-1.7%"},null,-0.17579786971756936,{"v":0.8387875105596129,"d":"83.9%"},{"v":-0.01668150537784563,"d":"-1.7%"},{"v":-4.740549908177627e-08,"d":"-0.00"},{"v":0.8387373262887705,"d":"0.84"},{"v":0.8388376948304552,"d":"0.84"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02230724829964803,"d":"2.2%"}]
[33,{"v":1,"d":"1.000"},2019,{"v":0.8247440051646806,"d":"82.5%"},-0.19268223756954414,{"v":-0.016742570205597995,"d":"-1.7%"},null,-0.1926823598139221,{"v":0.8247439043443688,"d":"82.5%"},{"v":-0.01674274597373837,"d":"-1.7%"},{"v":1.0082031176583683e-07,"d":"0.00"},{"v":0.8246937200735265,"d":"0.82"},{"v":0.8247940886152112,"d":"0.82"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.011490820145839464,"d":"1.1%"}]
[34,{"v":1,"d":"1.000"},2020,{"v":0.6976704609922191,"d":"69.8%"},-0.3600084066253155,{"v":-0.1540763477839262,"d":"-15.4%"},null,-0.36000828721762285,{"v":0.6976705442994441,"d":"69.8%"},{"v":-0.15407614336469921,"d":"-15.4%"},{"v":-8.33072250072675e-08,"d":"-0.00"},{"v":0.6976203600286017,"d":"0.70"},{"v":0.6977207285702864,"d":"0.70"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.003226466022373309,"d":"-0.3%"}]
[35,{"v":1,"d":"1.000"},2021,{"v":0.736092444690874,"d":"73.6%"},-0.3063995639412508,{"v":0.05507182236727015,"d":"5.5%"},null,-0.30639960593599386,{"v":0.7360924137788616,"d":"73.6%"},{"v":0.05507165207612186,"d":"5.5%"},{"v":3.0912012394246347e-08,"d":"0.00"},{"v":0.7360422295080192,"d":"0.74"},{"v":0.736142598049704,"d":"0.74"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[36,null,2022,{"$nulls":4},-0.18279968634789445,{"v":0.8329349872764835,"d":"83.3%"},{"v":0.13156306420883124,"d":"13.2%"},null,{"v":0.8328848030056412,"d":"0.83"},{"v":0.8329851715473259,"d":"0.83"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[37,null,2023,{"$nulls":4},-0.059199766759795075,{"v":0.9425184664893215,"d":"94.3%"},{"v":0.13156306420883124,"d":"13.2%"},null,{"v":0.9424682822184791,"d":"0.94"},{"v":0.9425686507601638,"d":"0.94"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[38,null,2024,{"$nulls":4},0.0644001528283043,{"v":1.0665190840140653,"d":"106.7%"},{"v":0.13156306420883124,"d":"13.2%"},null,{"v":1.066468899743223,"d":"1.07"},{"v":1.0665692682849075,"d":"1.07"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[]
[null,null,"All Year Avg:",{"v":-0.0005228423216879774,"d":"-0.1%"},"All Year Avg:",{"v":-0.0015697630836787324,"d":"-0.2%"},{"$nulls":3},{"v":-0.0015697630836787324,"d":"-0.2%"}]
[null,null,"10 Year Avg:",{"v":-0.02607053487153088,"d":"-2.6%"},null,{"v":0.005495615434960799,"d":"0.5%"},{"$nulls":3},{"v":0.005495615337681059,"d":"0.5%"}]
[null,null,"5 Year Avg:",{"v":0.03298929736361167,"d":"3.3%"},null,{"v":0.014751016218908175,"d":"1.5%"},{"$nulls":3},{"v":0.014751016331640221,"d":"1.5%"}]
[null,null,"3 Year Avg:",{"v":0.03784797141153584,"d":"3.8%"},null,{"v":0.01073454052503875,"d":"1.1%"},{"$nulls":3},{"v":0.010734540582190144,"d":"1.1%"}]
[null,null,"Linear 10Yr",{"v":-0.009808730957903489,"d":"-1.0%"}]
[]
[null,null,"10 Yr",{"v":-0.009760782256432732,"d":"-1.0%"}]
[null,null,"8 Yr",{"v":-0.020693026514171486,"d":"-2.1%"}]
[null,null,"6 Yr",{"v":-0.0391911685426205,"d":"-3.9%"}]

{"sheet":"Scenario2","index":2,"n_rows":61,"n_cols":15,"rows_kept":61,"read":"bin_skipped_in_rows","flags":["formulas_cached_only","records_skipped"],"rows_in_doubt":{"n":10,"rows":[4,13,48,49,50,52,53,54,55,56]},"rows_in_doubt_other":4}
["SCHEDULE P P&C INDUSTRY COMM AUTO LIABILITY ULR"]
["Direct and assumed"]
[]
[{"$nulls":8},"Smoother:",10]
[{"$nulls":3},"# Points",{"v":33,"d":"33.000"},{"$nulls":3},"# Param:",{"v":7.53269373620237,"d":"7.53"}]
[{"$nulls":8},"Std Error:",{"v":0.048503712525080726,"d":"0.05"}]
[{"$nulls":8},"GCV:",0.00925479804660447]
[]
[]
[{"$nulls":8},"Smoothing","Smoothed"]
["Index","Weights","Year","Loss Ratio",null,"Trend",null,null,"Spline","Trend","Error","LL","UL","10Yr"]
["X","w",null,"Y","log(Y)",null,null,"log(Y)","Y_hat"]
[]
[1,{"v":1,"d":"1.000"},1987,{"v":0.7450000110583505,"d":"74.5%"},-0.29437104575915424,null,null,-0.2595689997046609,{"v":0.7713839808908142,"d":"77.1%"},null,{"v":-0.026383969832463716,"d":"-0.03"},{"v":0.6763167043416559,"d":"0.68"},{"v":0.8664512574399724,"d":"0.87"}]
[2,{"v":1,"d":"1.000"},1988,{"v":0.801367175137667,"d":"80.1%"},-0.22143604101792005,{"v":0.07566062180219446,"d":"7.6%"},null,-0.25402616763609215,{"v":0.7756715042912538,"d":"77.6%"},{"v":0.0055582219836718405,"d":"0.6%"},{"v":0.02569567084641322,"d":"0.03"},{"v":0.6806042277420955,"d":"0.68"},{"v":0.870738780840412,"d":"0.87"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[3,{"v":1,"d":"1.000"},1989,{"v":0.8247732156286547,"d":"82.5%"},-0.1926468205837632,{"v":0.0292076356720834,"d":"2.9%"},null,-0.2514203713960032,{"v":0.7776953819418595,"d":"77.8%"},{"v":0.0026091942780017696,"d":"0.3%"},{"v":0.04707783368679519,"d":"0.05"},{"v":0.6826281053927012,"d":"0.68"},{"v":0.8727626584910178,"d":"0.87"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[4,{"v":1,"d":"1.000"},1990,{"v":0.7874039734631337,"d":"78.7%"},-0.23901385417696003,{"v":-0.04530850597159308,"d":"-4.5%"},null,-0.25153641252479086,{"v":0.777605142527729,"d":"77.8%"},{"v":-0.00011603439627627665,"d":"-0.0%"},{"v":0.009798830935404679,"d":"0.01"},{"v":0.6825378659785708,"d":"0.68"},{"v":0.8726724190768873,"d":"0.87"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[5,{"v":1,"d":"1.000"},1991,{"v":0.7502089577689091,"d":"75.0%"},-0.287403500897894,{"v":-0.04723752603207576,"d":"-4.7%"},null,-0.24948897775926934,{"v":0.7791988692994478,"d":"77.9%"},{"v":0.0020495321912843423,"d":"0.2%"},{"v":-0.02898991153053876,"d":"-0.03"},{"v":0.6841315927502896,"d":"0.68"},{"v":0.8742661458486061,"d":"0.87"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[6,{"v":1,"d":"1.000"},1992,{"v":0.7419076607544931,"d":"74.2%"},-0.29853048998137116,{"v":-0.01106531310836878,"d":"-1.1%"},null,-0.23921026615183738,{"v":0.7872493330807881,"d":"78.7%"},{"v":0.010331719023897179,"d":"1.0%"},{"v":-0.045341672326295046,"d":"-0.05"},{"v":0.6921820565316299,"d":"0.69"},{"v":0.8823166096299464,"d":"0.88"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[7,{"v":1,"d":"1.000"},1993,{"v":0.7817679864681769,"d":"78.2%"},-0.24619727495468952,{"v":0.053726801625349596,"d":"5.4%"},null,-0.21794007272216318,{"v":0.8041736321592662,"d":"80.4%"},{"v":0.021498016406374276,"d":"2.1%"},{"v":-0.02240564569108927,"d":"-0.02"},{"v":0.7091063556101079,"d":"0.71"},{"v":0.8992409087084244,"d":"0.90"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[8,{"v":1,"d":"1.000"},1994,{"v":0.838942500784609,"d":"83.9%"},-0.17561310789726567,{"v":0.0731348882354872,"d":"7.3%"},null,-0.1879757361680702,{"v":0.8286348128445901,"d":"82.9%"},{"v":0.030417785049285717,"d":"3.0%"},{"v":0.010307687940018906,"d":"0.01"},{"v":0.7335675362954318,"d":"0.73"},{"v":0.9237020893937483,"d":"0.92"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[9,{"v":1,"d":"1.000"},1995,{"v":0.8412886820413054,"d":"84.1%"},-0.17282041745618484,{"v":0.002796593633654476,"d":"0.3%"},null,-0.15428103526219616,{"v":0.8570311311951109,"d":"85.7%"},{"v":0.03426879719552223,"d":"3.4%"},{"v":-0.015742449153805516,"d":"-0.02"},{"v":0.7619638546459526,"d":"0.76"},{"v":0.9520984077442691,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[10,{"v":1,"d":"1.000"},1996,{"v":0.870885312173737,"d":"87.1%"},-0.1382449845379159,{"v":0.03518011208782501,"d":"3.5%"},null,-0.12177551663289975,{"v":0.8853470918929852,"d":"88.5%"},{"v":0.03303959409081014,"d":"3.3%"},{"v":-0.014461779719248224,"d":"-0.01"},{"v":0.790279815343827,"d":"0.79"},{"v":0.9804143684421435,"d":"0.98"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[11,{"v":1,"d":"1.000"},1997,{"v":0.9050712397881788,"d":"90.5%"},-0.0997416203823223,{"v":0.039254224565015816,"d":"3.9%"},null,-0.09668313304870953,{"v":0.9078436262043025,"d":"90.8%"},{"v":0.025409847185714263,"d":"2.5%"},{"v":-0.002772386416123651,"d":"-0.00"},{"v":0.8127763496551442,"d":"0.81"},{"v":1.0029109027534606,"d":"1.00"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.013390276908656018,"d":"1.3%"}]
[12,{"v":1,"d":"1.000"},1998,{"v":0.9367919018673363,"d":"93.7%"},-0.06529411119869982,{"v":0.035047696451586896,"d":"3.5%"},null,-0.0866857662972818,{"v":0.9169651917334917,"d":"91.7%"},{"v":0.010047507374509435,"d":"1.0%"},{"v":0.019826710133844627,"d":"0.02"},{"v":0.8218979151843334,"d":"0.82"},{"v":1.0120324682826498,"d":"1.01"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.020291535917592363,"d":"2.0%"}]
[13,{"v":1,"d":"1.000"},1999,{"v":1.0009400901415864,"d":"100.1%"},0.000939648533595079,{"v":0.06847645474558606,"d":"6.8%"},null,-0.09958716086862138,{"v":0.9052110474487749,"d":"90.5%"},{"v":-0.012818528326572487,"d":"-1.3%"},{"v":0.09572904269281146,"d":"0.10"},{"v":0.8101437708996166,"d":"0.81"},{"v":1.0002783239979331,"d":"1.00"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.030985143279761207,"d":"3.1%"}]
[14,{"v":1,"d":"1.000"},2000,{"v":0.9586438907550607,"d":"95.9%"},-0.04223560699654608,{"v":-0.04225647449143799,"d":"-4.2%"},null,-0.14014047887835068,{"v":0.8692361175067052,"d":"86.9%"},{"v":-0.03974203589699954,"d":"-4.0%"},{"v":0.08940777324835558,"d":"0.09"},{"v":0.7741688409575469,"d":"0.77"},{"v":0.9643033940558634,"d":"0.96"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.03370406565177442,"d":"3.4%"}]
[15,{"v":1,"d":"1.000"},2001,{"v":0.8423531339695072,"d":"84.2%"},-0.17155595364932777,{"v":-0.1213075657259538,"d":"-12.1%"},null,-0.20440881969893807,{"v":0.815129062242482,"d":"81.5%"},{"v":-0.06224667173221288,"d":"-6.2%"},{"v":0.027224071727025123,"d":"0.03"},{"v":0.7200617856933238,"d":"0.72"},{"v":0.9101963387916403,"d":"0.91"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02338653895861631,"d":"2.3%"}]
[16,{"v":1,"d":"1.000"},2002,{"v":0.7247393531178832,"d":"72.5%"},-0.32194320170858354,{"v":-0.13962526654038843,"d":"-14.0%"},null,-0.27970529665320093,{"v":0.7560065062769458,"d":"75.6%"},{"v":-0.0725315274649706,"d":"-7.3%"},{"v":-0.03126715315906259,"d":"-0.03"},{"v":0.6609392297277875,"d":"0.66"},{"v":0.851073782826104,"d":"0.85"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.002740792757875976,"d":"0.3%"}]
[17,{"v":1,"d":"1.000"},2003,{"v":0.6572212360542009,"d":"65.7%"},-0.41973458041624134,{"v":-0.09316193024873598,"d":"-9.3%"},null,-0.35022504921354247,{"v":0.7045295180622121,"d":"70.5%"},{"v":-0.06809066825130772,"d":"-6.8%"},{"v":-0.04730828200801118,"d":"-0.05"},{"v":0.6094622415130538,"d":"0.61"},{"v":0.7995967946113703,"d":"0.80"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.019021347423696322,"d":"-1.9%"}]
[18,{"v":1,"d":"1.000"},2004,{"v":0.6260785610578213,"d":"62.6%"},-0.4682794188586372,{"v":-0.04738537540775878,"d":"-4.7%"},null,-0.40359002160860924,{"v":0.6679178970490305,"d":"66.8%"},{"v":-0.051966056885566436,"d":"-5.2%"},{"v":-0.04183933599120915,"d":"-0.04"},{"v":0.5728506204998722,"d":"0.57"},{"v":0.7629851735981887,"d":"0.76"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.036309420341507304,"d":"-3.6%"}]
[19,{"v":1,"d":"1.000"},2005,{"v":0.6258254937639587,"d":"62.6%"},-0.46868371069926984,{"v":-0.0004042101256990227,"d":"-0.0%"},null,-0.43383824851898534,{"v":0.6480170647285396,"d":"64.8%"},{"v":-0.029795327252669868,"d":"-3.0%"},{"v":-0.02219157096458091,"d":"-0.02"},{"v":0.5529497881793813,"d":"0.55"},{"v":0.7430843412776978,"d":"0.74"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.049772495518247695,"d":"-5.0%"}]
[20,{"v":1,"d":"1.000"},2006,{"v":0.636365703567735,"d":"63.6%"},-0.45198187528474987,{"v":0.01684209082053112,"d":"1.7%"},null,-0.4410596409983069,{"v":0.6433543351338996,"d":"64.3%"},{"v":-0.007195380875645974,"d":"-0.7%"},{"v":-0.006988631566164583,"d":"-0.01"},{"v":0.5482870585847414,"d":"0.55"},{"v":0.7384216116830579,"d":"0.74"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.05665236670415785,"d":"-5.7%"}]
[21,{"v":1,"d":"1.000"},2007,{"v":0.6584626382906333,"d":"65.8%"},-0.4178474970080855,{"v":0.03472364176606879,"d":"3.5%"},null,-0.42892733477117323,{"v":0.6512072475854698,"d":"65.1%"},{"v":0.012206201190726018,"d":"1.2%"},{"v":0.007255390705163567,"d":"0.01"},{"v":0.5561399710363115,"d":"0.56"},{"v":0.746274524134628,"d":"0.75"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.05574153640657786,"d":"-5.6%"}]
[22,{"v":1,"d":"1.000"},2008,{"v":0.6718992974568828,"d":"67.2%"},-0.39764680466324287,{"v":0.02040610717280944,"d":"2.0%"},null,-0.40223870825490093,{"v":0.6688210735222712,"d":"66.9%"},{"v":0.027047957469929162,"d":"2.7%"},{"v":0.003078223934611657,"d":"0.00"},{"v":0.5737537969731129,"d":"0.57"},{"v":0.7638883500714294,"d":"0.76"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.0479484578496302,"d":"-4.8%"}]
[23,{"v":1,"d":"1.000"},2009,{"v":0.6625147381996628,"d":"66.3%"},-0.4117124750300923,{"v":-0.01396721099834497,"d":"-1.4%"},null,-0.36515798952751505,{"v":0.6940869837404618,"d":"69.4%"},{"v":0.03777678547885843,"d":"3.8%"},{"v":-0.03157224554079907,"d":"-0.03"},{"v":0.5990197071913036,"d":"0.60"},{"v":0.7891542602896201,"d":"0.79"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.03269359496604318,"d":"-3.3%"}]
[24,{"v":1,"d":"1.000"},2010,{"v":0.7443167099141158,"d":"74.4%"},-0.2952886493589221,{"v":0.12347192748759683,"d":"12.3%"},null,-0.3221345238899201,{"v":0.7246007076673422,"d":"72.5%"},{"v":0.043962391806342094,"d":"4.4%"},{"v":0.019716002246773612,"d":"0.02"},{"v":0.6295334311181839,"d":"0.63"},{"v":0.8196679842165004,"d":"0.82"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.008830733720889938,"d":"-0.9%"}]
[25,{"v":1,"d":"1.000"},2011,{"v":0.7947571977470933,"d":"79.5%"},-0.22971862261431414,{"v":0.06776750697804124,"d":"6.8%"},null,-0.28019732604115044,{"v":0.7556346203552802,"d":"75.6%"},{"v":0.042828984790593605,"d":"4.3%"},{"v":0.03912257739181313,"d":"0.04"},{"v":0.6605673438061219,"d":"0.66"},{"v":0.8507018969044384,"d":"0.85"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.01361440422258875,"d":"1.4%"}]
[26,{"v":1,"d":"1.000"},2012,{"v":0.7934612135391687,"d":"79.3%"},-0.23135062043824137,{"v":-0.0016306668396315338,"d":"-0.2%"},null,-0.24452028207943574,{"v":0.7830801057113901,"d":"78.3%"},{"v":0.03632110628177121,"d":"3.6%"},{"v":0.010381107827778568,"d":"0.01"},{"v":0.6880128291622318,"d":"0.69"},{"v":0.8781473822605483,"d":"0.88"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02685963305366168,"d":"2.7%"}]
[27,{"v":1,"d":"1.000"},2013,{"v":0.805573898439145,"d":"80.6%"},-0.21620033825269938,{"v":0.015265629489245702,"d":"1.5%"},null,-0.21624510560501398,{"v":0.8055378358358377,"d":"80.6%"},{"v":0.028678713659882726,"d":"2.9%"},{"v":3.606260330724087e-05,"d":"0.00"},{"v":0.7104705592866795,"d":"0.71"},{"v":0.900605112384996,"d":"0.90"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.03323720478471781,"d":"3.3%"}]
[28,{"v":1,"d":"1.000"},2014,{"v":0.8147364110873347,"d":"81.5%"},-0.20489064003217244,{"v":0.011373894643238458,"d":"1.1%"},null,-0.19479347492905788,{"v":0.823004611591376,"d":"82.3%"},{"v":0.021683371008159424,"d":"2.2%"},{"v":-0.008268200504041201,"d":"-0.01"},{"v":0.7279373350422177,"d":"0.73"},{"v":0.9180718881405342,"d":"0.92"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.034379598394197686,"d":"3.4%"}]
[29,{"v":1,"d":"1.000"},2015,{"v":0.8357028771245523,"d":"83.6%"},-0.17948213920868264,{"v":0.02573404815581526,"d":"2.6%"},null,-0.17953287559695003,{"v":0.8356604776545093,"d":"83.6%"},{"v":0.015377636874551515,"d":"1.5%"},{"v":4.2399470042919774e-05,"d":"0.00"},{"v":0.7405932011053511,"d":"0.74"},{"v":0.9307277542036676,"d":"0.93"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.033626232652777865,"d":"3.4%"}]
[30,{"v":1,"d":"1.000"},2016,{"v":0.8602455877795842,"d":"86.0%"},-0.15053736331556852,{"v":0.029367746990984767,"d":"2.9%"},null,-0.17050234576526999,{"v":0.8432411115805796,"d":"84.3%"},{"v":0.009071428084462152,"d":"0.9%"},{"v":0.01700447619900458,"d":"0.02"},{"v":0.7481738350314213,"d":"0.75"},{"v":0.9383083881297378,"d":"0.94"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.032033812045587196,"d":"3.2%"}]
[31,{"v":1,"d":"1.000"},2017,{"v":0.8530171275758617,"d":"85.3%"},-0.15897565247063403,{"v":-0.008402786723242794,"d":"-0.8%"},null,-0.16757307754226952,{"v":0.8457148122706506,"d":"84.6%"},{"v":0.0029335627213837867,"d":"0.3%"},{"v":0.007302315305211082,"d":"0.01"},{"v":0.7506475357214923,"d":"0.75"},{"v":0.9407820888198088,"d":"0.94"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.028551095678875704,"d":"2.9%"}]
[32,{"v":1,"d":"1.000"},2018,{"v":0.8387874631541138,"d":"83.9%"},-0.17579792623426732,{"v":-0.016681569410202046,"d":"-1.7%"},null,-0.16914112818188837,{"v":0.8443897277896264,"d":"84.4%"},{"v":-0.0015668218905454667,"d":"-0.2%"},{"v":-0.0056022646355126104,"d":"-0.01"},{"v":0.7493224512404681,"d":"0.75"},{"v":0.9394570043387847,"d":"0.94"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02230724829964803,"d":"2.2%"}]
[33,{"v":1,"d":"1.000"},2019,{"v":0.8247440051646806,"d":"82.5%"},-0.19268223756954414,{"v":-0.016742570205597995,"d":"-1.7%"},null,-0.17280759019333447,{"v":0.8412994735415755,"d":"84.1%"},{"v":-0.0036597487467550094,"d":"-0.4%"},{"v":-0.016555468376894922,"d":"-0.02"},{"v":0.7462321969924173,"d":"0.75"},{"v":0.9363667500907338,"d":"0.94"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.011490820145839464,"d":"1.1%"}]
[34,0,2020,{"v":0.6976704609922191,"d":"69.8%"},-0.3600084066253155,{"v":-0.1540763477839262,"d":"-15.4%"},null,-0.17680529632771738,{"v":0.8379429192045501,"d":"83.8%"},{"v":-0.0039897259449069855,"d":"-0.4%"},{"v":-0.14027245821233103,"d":"-0.14"},{"v":0.7428756426553919,"d":"0.74"},{"v":0.9330101957537084,"d":"0.93"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.003226466022373309,"d":"-0.3%"}]
[35,0,2021,{"v":0.736092444690874,"d":"73.6%"},-0.3063995639412508,{"v":0.05507182236727015,"d":"5.5%"},null,-0.1808030024621003,{"v":0.8345997565994485,"d":"83.5%"},{"v":-0.0039897259449070965,"d":"-0.4%"},{"v":-0.09850731190857454,"d":"-0.10"},{"v":0.7395324800502903,"d":"0.74"},{"v":0.9296670331486068,"d":"0.93"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[36,null,2022,{"$nulls":4},-0.1848007085964832,{"v":0.8312699322969307,"d":"83.1%"},{"v":-0.0039897259449068745,"d":"-0.4%"},null,{"v":0.7362026557477724,"d":"0.74"},{"v":0.9263372088460889,"d":"0.93"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[37,null,2023,{"$nulls":4},-0.18879841473086612,{"v":0.8279533930808245,"d":"82.8%"},{"v":-0.0039897259449070965,"d":"-0.4%"},null,{"v":0.7328861165316662,"d":"0.73"},{"v":0.9230206696299827,"d":"0.92"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[38,null,2024,{"$nulls":4},-0.19279612086524903,{"v":0.8246500859472761,"d":"82.5%"},{"v":-0.0039897259449070965,"d":"-0.4%"},null,{"v":0.7295828093981178,"d":"0.73"},{"v":0.9197173624964343,"d":"0.92"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[]
[null,null,"All Year Avg:",{"v":-0.0005228423216879774,"d":"-0.1%"},"All Year Avg:",{"v":-0.0015697630836787324,"d":"-0.2%"},{"$nulls":3},{"v":-0.0001518276959913134,"d":"-0.0%"}]
[null,null,"10 Year Avg:",{"v":-0.02607053487153088,"d":"-2.6%"},null,{"v":0.005495615434960799,"d":"0.5%"},{"$nulls":3},{"v":0.008787957517121026,"d":"0.9%"}]
[null,null,"5 Year Avg:",{"v":0.03298929736361167,"d":"3.3%"},null,{"v":0.014751016218908175,"d":"1.5%"},{"$nulls":3},{"v":0.01998272190257544,"d":"2.0%"}]
[null,null,"3 Year Avg:",{"v":0.03784797141153584,"d":"3.8%"},null,{"v":0.01073454052503875,"d":"1.1%"},{"$nulls":3},{"v":0.018693349123965586,"d":"1.9%"}]
[null,null,"Linear 10Yr",{"v":-0.009808730957903489,"d":"-1.0%"}]
[]
[null,null,"10 Yr",{"v":-0.009760782256432732,"d":"-1.0%"}]
[null,null,"8 Yr",{"v":-0.020693026514171486,"d":"-2.1%"}]
[null,null,"6 Yr",{"v":-0.0391911685426205,"d":"-3.9%"}]

{"sheet":"Scenario3","index":3,"n_rows":61,"n_cols":15,"rows_kept":61,"read":"bin_skipped_in_rows","flags":["formulas_cached_only","records_skipped"],"rows_in_doubt":{"n":10,"rows":[4,13,48,49,50,52,53,54,55,56]},"rows_in_doubt_other":4}
["SCHEDULE P P&C INDUSTRY COMM AUTO LIABILITY ULR"]
["Direct and assumed"]
[]
[{"$nulls":8},"Smoother:",0.5100552006324093]
[{"$nulls":3},"# Points",{"v":34,"d":"34.000"},{"$nulls":3},"# Param:",{"v":15.269151658807406,"d":"15.27"}]
[{"$nulls":8},"Std Error:",{"v":0.02482775829498164,"d":"0.02"}]
[{"$nulls":8},"GCV:",0.00558939277920834]
[]
[]
[{"$nulls":8},"Smoothing","Smoothed"]
["Index","Weights","Year","Loss Ratio",null,"Trend",null,null,"Spline","Trend","Error","LL","UL","10Yr"]
["X","w",null,"Y","log(Y)",null,null,"log(Y)","Y_hat"]
[]
[1,{"v":1,"d":"1.000"},1987,{"v":0.7450000110583505,"d":"74.5%"},-0.29437104575915424,null,null,-0.2771653962948699,{"v":0.7579291280734497,"d":"75.8%"},null,{"v":-0.012929117015099245,"d":"-0.01"},{"v":0.7092667218152857,"d":"0.71"},{"v":0.8065915343316137,"d":"0.81"}]
[2,{"v":1,"d":"1.000"},1988,{"v":0.801367175137667,"d":"80.1%"},-0.22143604101792005,{"v":0.07566062180219446,"d":"7.6%"},null,-0.23238465798693914,{"v":0.792641168902475,"d":"79.3%"},{"v":0.04579853121261945,"d":"4.6%"},{"v":0.00872600623519193,"d":"0.01"},{"v":0.7439787626443111,"d":"0.74"},{"v":0.841303575160639,"d":"0.84"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.010956161059296754,"d":"1.1%"}]
[3,{"v":1,"d":"1.000"},1989,{"v":0.8247732156286547,"d":"82.5%"},-0.1926468205837632,{"v":0.0292076356720834,"d":"2.9%"},null,-0.21775924394661142,{"v":0.8043190630411484,"d":"80.4%"},{"v":0.014732888722955195,"d":"1.5%"},{"v":0.02045415258750627,"d":"0.02"},{"v":0.7556566567829844,"d":"0.76"},{"v":0.8529814692993124,"d":"0.85"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.010956161059296754,"d":"1.1%"}]
[4,{"v":1,"d":"1.000"},1990,{"v":0.7874039734631337,"d":"78.7%"},-0.23901385417696003,{"v":-0.04530850597159308,"d":"-4.5%"},null,-0.24092832360390576,{"v":0.7858979547027071,"d":"78.6%"},{"v":-0.022902737464397194,"d":"-2.3%"},{"v":0.001506018760426664,"d":"0.00"},{"v":0.7372355484445431,"d":"0.74"},{"v":0.834560360960871,"d":"0.83"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.010956161059296754,"d":"1.1%"}]
[5,{"v":1,"d":"1.000"},1991,{"v":0.7502089577689091,"d":"75.0%"},-0.287403500897894,{"v":-0.04723752603207576,"d":"-4.7%"},null,-0.27250475377703504,{"v":0.761469809308909,"d":"76.1%"},{"v":-0.031083100862679958,"d":"-3.1%"},{"v":-0.011260851539999894,"d":"-0.01"},{"v":0.712807403050745,"d":"0.71"},{"v":0.8101322155670729,"d":"0.81"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.010956161059296754,"d":"1.1%"}]
[6,{"v":1,"d":"1.000"},1992,{"v":0.7419076607544931,"d":"74.2%"},-0.29853048998137116,{"v":-0.01106531310836878,"d":"-1.1%"},null,-0.27726164625020555,{"v":0.7578561809393606,"d":"75.8%"},{"v":-0.0047455963787034205,"d":"-0.5%"},{"v":-0.015948520184867476,"d":"-0.02"},{"v":0.7091937746811966,"d":"0.71"},{"v":0.8065185871975246,"d":"0.81"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.010956161059296754,"d":"1.1%"}]
[7,{"v":1,"d":"1.000"},1993,{"v":0.7817679864681769,"d":"78.2%"},-0.24619727495468952,{"v":0.053726801625349596,"d":"5.4%"},null,-0.245769765914506,{"v":0.7821022707994136,"d":"78.2%"},{"v":0.03199299612493767,"d":"3.2%"},{"v":-0.00033428433123672274,"d":"-0.00"},{"v":0.7334398645412497,"d":"0.73"},{"v":0.8307646770575776,"d":"0.83"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.010956161059296754,"d":"1.1%"}]
[8,{"v":1,"d":"1.000"},1994,{"v":0.838942500784609,"d":"83.9%"},-0.17561310789726567,{"v":0.0731348882354872,"d":"7.3%"},null,-0.20140731724835376,{"v":0.8175793495524718,"d":"81.8%"},{"v":0.04536117599658129,"d":"4.5%"},{"v":0.021363151232137167,"d":"0.02"},{"v":0.7689169432943078,"d":"0.77"},{"v":0.8662417558106358,"d":"0.87"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.010956161059296754,"d":"1.1%"}]
[9,{"v":1,"d":"1.000"},1995,{"v":0.8412886820413054,"d":"84.1%"},-0.17282041745618484,{"v":0.002796593633654476,"d":"0.3%"},null,-0.166632561994654,{"v":0.8465105943644954,"d":"84.7%"},{"v":0.03538646717026306,"d":"3.5%"},{"v":-0.0052219123231900255,"d":"-0.01"},{"v":0.7978481881063314,"d":"0.80"},{"v":0.8951730006226594,"d":"0.90"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.010956161059296754,"d":"1.1%"}]
[10,{"v":1,"d":"1.000"},1996,{"v":0.870885312173737,"d":"87.1%"},-0.1382449845379159,{"v":0.03518011208782501,"d":"3.5%"},null,-0.1323511401464461,{"v":0.8760333305938619,"d":"87.6%"},{"v":0.03487580241276267,"d":"3.5%"},{"v":-0.005148018420124911,"d":"-0.01"},{"v":0.8273709243356979,"d":"0.83"},{"v":0.9246957368520259,"d":"0.92"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.010956161059296754,"d":"1.1%"}]
[11,{"v":1,"d":"1.000"},1997,{"v":0.9050712397881788,"d":"90.5%"},-0.0997416203823223,{"v":0.039254224565015816,"d":"3.9%"},null,-0.09105383283459476,{"v":0.91296856189078,"d":"91.3%"},{"v":0.04216190184439639,"d":"4.2%"},{"v":-0.00789732210260119,"d":"-0.01"},{"v":0.864306155632616,"d":"0.86"},{"v":0.961630968148944,"d":"0.96"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.013390276908656018,"d":"1.3%"}]
[12,{"v":1,"d":"1.000"},1998,{"v":0.9367919018673363,"d":"93.7%"},-0.06529411119869982,{"v":0.035047696451586896,"d":"3.5%"},null,-0.0477957542685089,{"v":0.9533284804670253,"d":"95.3%"},{"v":0.04420734761409406,"d":"4.4%"},{"v":-0.016536578599689045,"d":"-0.02"},{"v":0.9046660742088614,"d":"0.90"},{"v":1.0019908867251894,"d":"1.00"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.020291535917592363,"d":"2.0%"}]
[13,{"v":1,"d":"1.000"},1999,{"v":1.0009400901415864,"d":"100.1%"},0.000939648533595079,{"v":0.06847645474558606,"d":"6.8%"},null,-0.026631057533023805,{"v":0.973720422076449,"d":"97.4%"},{"v":0.02139025742673062,"d":"2.1%"},{"v":0.027219668065137315,"d":"0.03"},{"v":0.9250580158182851,"d":"0.93"},{"v":1.022382828334613,"d":"1.02"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.030985143279761207,"d":"3.1%"}]
[14,{"v":1,"d":"1.000"},2000,{"v":0.9586438907550607,"d":"95.9%"},-0.04223560699654608,{"v":-0.04225647449143799,"d":"-4.2%"},null,-0.06831486884245194,{"v":0.9339663503708965,"d":"93.4%"},{"v":-0.04082698771047377,"d":"-4.1%"},{"v":0.024677540384164254,"d":"0.02"},{"v":0.8853039441127325,"d":"0.89"},{"v":0.9826287566290605,"d":"0.98"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.03370406565177442,"d":"3.4%"}]
[15,{"v":1,"d":"1.000"},2001,{"v":0.8423531339695072,"d":"84.2%"},-0.17155595364932777,{"v":-0.1213075657259538,"d":"-12.1%"},null,-0.1747621623926532,{"v":0.8396566989630483,"d":"84.0%"},{"v":-0.10097756880683761,"d":"-10.1%"},{"v":0.002696435006458886,"d":"0.00"},{"v":0.7909942927048843,"d":"0.79"},{"v":0.8883191052212123,"d":"0.89"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.02338653895861631,"d":"2.3%"}]
[16,{"v":1,"d":"1.000"},2002,{"v":0.7247393531178832,"d":"72.5%"},-0.32194320170858354,{"v":-0.13962526654038843,"d":"-14.0%"},null,-0.3037443366690979,{"v":0.7380495345341779,"d":"73.8%"},{"v":-0.12101036596784409,"d":"-12.1%"},{"v":-0.013310181416294697,"d":"-0.01"},{"v":0.6893871282760139,"d":"0.69"},{"v":0.7867119407923419,"d":"0.79"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.002740792757875976,"d":"0.3%"}]
[17,{"v":1,"d":"1.000"},2003,{"v":0.6572212360542009,"d":"65.7%"},-0.41973458041624134,{"v":-0.09316193024873598,"d":"-9.3%"},null,-0.4062671068370815,{"v":0.6661322151907374,"d":"66.6%"},{"v":-0.09744240186917985,"d":"-9.7%"},{"v":-0.00891097913653649,"d":"-0.01"},{"v":0.6174698089325734,"d":"0.62"},{"v":0.7147946214489014,"d":"0.71"},{"v":0.011490820145839464,"d":"1.1%"},{"v":-0.019021347423696322,"d":"-1.9%"}]
[18,{"v":1,"d":"1.000"},2004,{"v":0.6260785610578213,"d":"62.6%"},-0.4682794188586372,{"v":-0.04738537540775878,"d":"-4.7%"},null,-0.46047597113204597,{"v":0.6309832442123753,"d":"63.1%"},{"v":-0.05276575757306334,"d":"-5.3%"},{"v":-0.004904683154553946,"d":"-0.00"},{"v":0.5823208379542113,"d":"0.58"},{"v":0.6796456504705393,"d":"0.68"},{"v":0.011490820145839464,"d":"1.1%"},{"v":-0.036309420341507304,"d":"-3.6%"}]
[19,{"v":1,"d":"1.000"},2005,{"v":0.6258254937639587,"d":"62.6%"},-0.46868371069926984,{"v":-0.0004042101256990227,"d":"-0.0%"},null,-0.47061563136050083,{"v":0.6246176157002068,"d":"62.5%"},{"v":-0.010088427181793702,"d":"-1.0%"},{"v":0.0012078780637518882,"d":"0.00"},{"v":0.5759552094420428,"d":"0.58"},{"v":0.6732800219583708,"d":"0.67"},{"v":0.011490820145839464,"d":"1.1%"},{"v":-0.049772495518247695,"d":"-5.0%"}]
[20,{"v":1,"d":"1.000"},2006,{"v":0.636365703567735,"d":"63.6%"},-0.45198187528474987,{"v":0.01684209082053112,"d":"1.7%"},null,-0.4548996511865549,{"v":0.6345116372435201,"d":"63.5%"},{"v":0.0158401256938967,"d":"1.6%"},{"v":0.0018540663242149202,"d":"0.00"},{"v":0.5858492309853561,"d":"0.59"},{"v":0.6831740435016841,"d":"0.68"},{"v":0.011490820145839464,"d":"1.1%"},{"v":-0.05665236670415785,"d":"-5.7%"}]
[21,{"v":1,"d":"1.000"},2007,{"v":0.6584626382906333,"d":"65.8%"},-0.4178474970080855,{"v":0.03472364176606879,"d":"3.5%"},null,-0.4306129330834634,{"v":0.6501104983469987,"d":"65.0%"},{"v":0.02458404257366187,"d":"2.5%"},{"v":0.008352139943634596,"d":"0.01"},{"v":0.6014480920888348,"d":"0.60"},{"v":0.6987729046051627,"d":"0.70"},{"v":0.011490820145839464,"d":"1.1%"},{"v":-0.05574153640657786,"d":"-5.6%"}]
[22,{"v":1,"d":"1.000"},2008,{"v":0.6718992974568828,"d":"67.2%"},-0.39764680466324287,{"v":0.02040610717280944,"d":"2.0%"},null,-0.4064241682101236,{"v":0.6660275997661281,"d":"66.6%"},{"v":0.024483686172736663,"d":"2.4%"},{"v":0.005871697690754685,"d":"0.01"},{"v":0.6173651935079641,"d":"0.62"},{"v":0.7146900060242921,"d":"0.71"},{"v":0.011490820145839464,"d":"1.1%"},{"v":-0.0479484578496302,"d":"-4.8%"}]
[23,{"v":1,"d":"1.000"},2009,{"v":0.6625147381996628,"d":"66.3%"},-0.4117124750300923,{"v":-0.01396721099834497,"d":"-1.4%"},null,-0.37049548174578456,{"v":0.6903921691597203,"d":"69.0%"},{"v":0.03658192153320328,"d":"3.7%"},{"v":-0.02787743096005757,"d":"-0.03"},{"v":0.6417297629015564,"d":"0.64"},{"v":0.7390545754178843,"d":"0.74"},{"v":0.011490820145839464,"d":"1.1%"},{"v":-0.03269359496604318,"d":"-3.3%"}]
[24,{"v":1,"d":"1.000"},2010,{"v":0.7443167099141158,"d":"74.4%"},-0.2952886493589221,{"v":0.12347192748759683,"d":"12.3%"},null,-0.30881345101712065,{"v":0.7343177434778931,"d":"73.4%"},{"v":0.06362409117651913,"d":"6.4%"},{"v":0.009998966436222667,"d":"0.01"},{"v":0.6856553372197292,"d":"0.69"},{"v":0.7829801497360571,"d":"0.78"},{"v":0.011490820145839464,"d":"1.1%"},{"v":-0.008830733720889938,"d":"-0.9%"}]
[25,{"v":1,"d":"1.000"},2011,{"v":0.7947571977470933,"d":"79.5%"},-0.22971862261431414,{"v":0.06776750697804124,"d":"6.8%"},null,-0.2539497444531671,{"v":0.7757307858417295,"d":"77.6%"},{"v":0.05639662493744857,"d":"5.6%"},{"v":0.019026411905363805,"d":"0.02"},{"v":0.7270683795835655,"d":"0.73"},{"v":0.8243931920998935,"d":"0.82"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.01361440422258875,"d":"1.4%"}]
[26,{"v":1,"d":"1.000"},2012,{"v":0.7934612135391687,"d":"79.3%"},-0.23135062043824137,{"v":-0.0016306668396315338,"d":"-0.2%"},null,-0.22634880218122672,{"v":0.7974399043725411,"d":"79.7%"},{"v":0.027985377049662308,"d":"2.8%"},{"v":-0.0039786908333724336,"d":"-0.00"},{"v":0.7487774981143771,"d":"0.75"},{"v":0.8461023106307051,"d":"0.85"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.02685963305366168,"d":"2.7%"}]
[27,{"v":1,"d":"1.000"},2013,{"v":0.805573898439145,"d":"80.6%"},-0.21620033825269938,{"v":0.015265629489245702,"d":"1.5%"},null,-0.21199883598774713,{"v":0.808965639211868,"d":"80.9%"},{"v":0.01445342122475779,"d":"1.4%"},{"v":-0.003391740772723084,"d":"-0.00"},{"v":0.7603032329537041,"d":"0.76"},{"v":0.857628045470032,"d":"0.86"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.03323720478471781,"d":"3.3%"}]
[28,{"v":1,"d":"1.000"},2014,{"v":0.8147364110873347,"d":"81.5%"},-0.20489064003217244,{"v":0.011373894643238458,"d":"1.1%"},null,-0.19688075565676272,{"v":0.8212885614889744,"d":"82.1%"},{"v":0.015232936579496759,"d":"1.5%"},{"v":-0.0065521504016397,"d":"-0.01"},{"v":0.7726261552308105,"d":"0.77"},{"v":0.8699509677471384,"d":"0.87"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.034379598394197686,"d":"3.4%"}]
[29,{"v":1,"d":"1.000"},2015,{"v":0.8357028771245523,"d":"83.6%"},-0.17948213920868264,{"v":0.02573404815581526,"d":"2.6%"},null,-0.1767187666179787,{"v":0.8380154292992199,"d":"83.8%"},{"v":0.02036661484718616,"d":"2.0%"},{"v":-0.002312552174667637,"d":"-0.00"},{"v":0.7893530230410559,"d":"0.79"},{"v":0.8866778355573839,"d":"0.89"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.033626232652777865,"d":"3.4%"}]
[30,{"v":1,"d":"1.000"},2016,{"v":0.8602455877795842,"d":"86.0%"},-0.15053736331556852,{"v":0.029367746990984767,"d":"2.9%"},null,-0.15998223479514703,{"v":0.8521589276096566,"d":"85.2%"},{"v":0.016877372200967855,"d":"1.7%"},{"v":0.00808666016992754,"d":"0.01"},{"v":0.8034965213514926,"d":"0.80"},{"v":0.9008213338678206,"d":"0.90"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.032033812045587196,"d":"3.2%"}]
[31,{"v":1,"d":"1.000"},2017,{"v":0.8530171275758617,"d":"85.3%"},-0.15897565247063403,{"v":-0.008402786723242794,"d":"-0.8%"},null,-0.15828348764726982,{"v":0.8536077604093517,"d":"85.4%"},{"v":0.0017001908361848894,"d":"0.2%"},{"v":-0.0005906328334900346,"d":"-0.00"},{"v":0.8049453541511877,"d":"0.80"},{"v":0.9022701666675157,"d":"0.90"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.028551095678875704,"d":"2.9%"}]
[32,{"v":1,"d":"1.000"},2018,{"v":0.8387874631541138,"d":"83.9%"},-0.17579792623426732,{"v":-0.016681569410202046,"d":"-1.7%"},null,-0.17201908995325643,{"v":0.84196309997886,"d":"84.2%"},{"v":-0.013641699350187997,"d":"-1.4%"},{"v":-0.0031756368247461975,"d":"-0.00"},{"v":0.793300693720696,"d":"0.79"},{"v":0.890625506237024,"d":"0.89"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.02230724829964803,"d":"2.2%"}]
[33,{"v":1,"d":"1.000"},2019,{"v":0.8247440051646806,"d":"82.5%"},-0.19268223756954414,{"v":-0.016742570205597995,"d":"-1.7%"},null,-0.20063885409426468,{"v":0.8182078706248594,"d":"81.8%"},{"v":-0.02821409792732843,"d":"-2.8%"},{"v":0.006536134539821159,"d":"0.01"},{"v":0.7695454643666955,"d":"0.77"},{"v":0.8668702768830234,"d":"0.87"},{"v":0.011490820145839464,"d":"1.1%"},{"v":0.011490820145839464,"d":"1.1%"}]
[34,0,2020,{"v":0.6976704609922191,"d":"69.8%"},-0.3600084066253155,{"v":-0.1540763477839262,"d":"-15.4%"},null,-0.24615796622960928,{"v":0.7817987173750259,"d":"78.2%"},{"v":-0.04449865927350238,"d":"-4.4%"},{"v":-0.08412825638280685,"d":"-0.08"},{"v":0.733136311116862,"d":"0.73"},{"v":0.8304611236331899,"d":"0.83"},{"v":0.011490820145839464,"d":"1.1%"},{"v":-0.003226466022373309,"d":"-0.3%"}]
[35,{"v":1,"d":"1.000"},2021,{"v":0.736092444690874,"d":"73.6%"},-0.3063995639412508,{"v":0.05507182236727015,"d":"5.5%"},null,-0.3014267123982866,{"v":0.7397620397537624,"d":"74.0%"},{"v":-0.053769182127090476,"d":"-5.4%"},{"v":-0.003669595062888442,"d":"-0.00"},{"v":0.6910996334955984,"d":"0.69"},{"v":0.7884244460119264,"d":"0.79"},{"v":0.011490820145839464,"d":"1.1%"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[36,null,2022,{"$nulls":4},-0.3583203975725194,{"v":0.6988491295679831,"d":"69.9%"},{"v":-0.05530550094108322,"d":"-5.5%"},null,{"v":0.6501867233098191,"d":"0.65"},{"v":0.747511535826147,"d":"0.75"},{"v":0.011490820145839464,"d":"1.1%"}]
[37,null,2023,{"$nulls":4},-0.4152140827467522,{"v":0.6601989283749858,"d":"66.0%"},{"v":-0.05530550094108311,"d":"-5.5%"},null,{"v":0.6115365221168219,"d":"0.61"},{"v":0.7088613346331498,"d":"0.71"},{"v":0.011490820145839464,"d":"1.1%"}]
[38,null,2024,{"$nulls":4},-0.47210776792098497,{"v":0.623686295920441,"d":"62.4%"},{"v":-0.05530550094108311,"d":"-5.5%"},null,{"v":0.575023889662277,"d":"0.58"},{"v":0.672348702178605,"d":"0.67"},{"v":0.011490820145839464,"d":"1.1%"}]
[]
[null,null,"All Year Avg:",{"v":-0.0005228423216879774,"d":"-0.1%"},"All Year Avg:",{"v":-0.0015697630836787324,"d":"-0.2%"},{"$nulls":3},{"v":-0.0010601799897169695,"d":"-0.1%"}]
[null,null,"10 Year Avg:",{"v":-0.02607053487153088,"d":"-2.6%"},null,{"v":0.005495615434960799,"d":"0.5%"},{"$nulls":3},{"v":0.006775702115092042,"d":"0.7%"}]
[null,null,"5 Year Avg:",{"v":0.03298929736361167,"d":"3.3%"},null,{"v":0.014751016218908175,"d":"1.5%"},{"$nulls":3},{"v":0.016920589548157894,"d":"1.7%"}]
[null,null,"3 Year Avg:",{"v":0.03784797141153584,"d":"3.8%"},null,{"v":0.01073454052503875,"d":"1.1%"},{"$nulls":3},{"v":0.013364855090487904,"d":"1.3%"}]
[null,null,"Linear 10Yr",{"v":-0.009808730957903489,"d":"-1.0%"}]
[]
[null,null,"10 Yr",{"v":0.011490820145839464,"d":"1.1%"}]
[null,null,"8 Yr",{"v":-0.020693026514171486,"d":"-2.1%"}]
[null,null,"6 Yr",{"v":-0.0391911685426205,"d":"-3.9%"}]

{"sheet":"Scenario4","index":4,"n_rows":61,"n_cols":15,"rows_kept":61,"read":"bin_skipped_in_rows","flags":["formulas_cached_only","records_skipped"],"rows_in_doubt":{"n":10,"rows":[4,13,48,49,50,52,53,54,55,56]},"rows_in_doubt_other":4}
["SCHEDULE P P&C INDUSTRY COMM AUTO LIABILITY ULR"]
["Direct and assumed"]
[]
[{"$nulls":8},"Smoother:",300]
[{"$nulls":3},"# Points",{"v":35,"d":"35.000"},{"$nulls":3},"# Param:",{"v":3.9685510464854494,"d":"4.0"}]
[{"$nulls":8},"Std Error:",{"v":0.07982055123804753,"d":"0.08"}]
[{"$nulls":8},"GCV:",0.014328927833145445]
[]
[]
[{"$nulls":8},"Smoothing","Smoothed"]
["Index","Weights","Year","Loss Ratio",null,"Trend",null,null,"Spline","Trend","Error","LL","UL","10Yr"]
["X","w",null,"Y","log(Y)",null,null,"log(Y)","Y_hat"]
[]
[1,{"v":1,"d":"1.000"},1987,{"v":0.7450000110583505,"d":"74.5%"},-0.29437104575915424,null,null,-0.24344021340567762,{"v":0.7839263429174959,"d":"78.4%"},null,{"v":-0.0389263318591454,"d":"-0.04"},{"v":0.6274780624909226,"d":"0.63"},{"v":0.9403746233440691,"d":"0.94"}]
[2,{"v":1,"d":"1.000"},1988,{"v":0.801367175137667,"d":"80.1%"},-0.22143604101792005,{"v":0.07566062180219446,"d":"7.6%"},null,-0.2354590995509233,{"v":0.7902079822092062,"d":"79.0%"},{"v":0.008013047843668852,"d":"0.8%"},{"v":0.011159192928460793,"d":"0.01"},{"v":0.6337597017826331,"d":"0.63"},{"v":0.9466562626357793,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[3,{"v":1,"d":"1.000"},1989,{"v":0.8247732156286547,"d":"82.5%"},-0.1926468205837632,{"v":0.0292076356720834,"d":"2.9%"},null,-0.22763996454927365,{"v":0.7964109443973837,"d":"79.6%"},{"v":0.007849784269244875,"d":"0.8%"},{"v":0.028362271231270997,"d":"0.03"},{"v":0.6399626639708105,"d":"0.64"},{"v":0.9528592248239569,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[4,{"v":1,"d":"1.000"},1990,{"v":0.7874039734631337,"d":"78.7%"},-0.23901385417696003,{"v":-0.04530850597159308,"d":"-4.5%"},null,-0.2200941842660004,{"v":0.8024432168778712,"d":"80.2%"},{"v":0.007574321426549346,"d":"0.8%"},{"v":-0.015039243414737502,"d":"-0.02"},{"v":0.645994936451298,"d":"0.65"},{"v":0.9588914973044445,"d":"0.96"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[5,{"v":1,"d":"1.000"},1991,{"v":0.7502089577689091,"d":"75.0%"},-0.287403500897894,{"v":-0.04723752603207576,"d":"-4.7%"},null,-0.2128580923638849,{"v":0.8082708288811518,"d":"80.8%"},{"v":0.007262335677724829,"d":"0.7%"},{"v":-0.0580618711122427,"d":"-0.06"},{"v":0.6518225484545785,"d":"0.65"},{"v":0.964719109307725,"d":"0.96"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[6,{"v":1,"d":"1.000"},1992,{"v":0.7419076607544931,"d":"74.2%"},-0.29853048998137116,{"v":-0.01106531310836878,"d":"-1.1%"},null,-0.2060320396969373,{"v":0.8138070017355116,"d":"81.4%"},{"v":0.006849403265021037,"d":"0.7%"},{"v":-0.07189934098101847,"d":"-0.07"},{"v":0.6573587213089385,"d":"0.66"},{"v":0.9702552821620847,"d":"0.97"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[7,{"v":1,"d":"1.000"},1993,{"v":0.7817679864681769,"d":"78.2%"},-0.24619727495468952,{"v":0.053726801625349596,"d":"5.4%"},null,-0.19994393253824191,{"v":0.818776658520059,"d":"81.9%"},{"v":0.006106677349726919,"d":"0.6%"},{"v":-0.037008672051882074,"d":"-0.04"},{"v":0.6623283780934859,"d":"0.66"},{"v":0.9752249389466321,"d":"0.98"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[8,{"v":1,"d":"1.000"},1994,{"v":0.838942500784609,"d":"83.9%"},-0.17561310789726567,{"v":0.0731348882354872,"d":"7.3%"},null,-0.19519433968981997,{"v":0.8226747641611668,"d":"82.3%"},{"v":0.004760890043145061,"d":"0.5%"},{"v":0.016267736623442164,"d":"0.02"},{"v":0.6662264837345937,"d":"0.67"},{"v":0.9791230445877399,"d":"0.98"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[9,{"v":1,"d":"1.000"},1995,{"v":0.8412886820413054,"d":"84.1%"},-0.17282041745618484,{"v":0.002796593633654476,"d":"0.3%"},null,-0.192527124724893,{"v":0.8248719434756119,"d":"82.5%"},{"v":0.002670775147315174,"d":"0.3%"},{"v":0.01641673856569348,"d":"0.02"},{"v":0.6684236630490388,"d":"0.67"},{"v":0.981320223902185,"d":"0.98"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[10,{"v":1,"d":"1.000"},1996,{"v":0.870885312173737,"d":"87.1%"},-0.1382449845379159,{"v":0.03518011208782501,"d":"3.5%"},null,-0.19265738549889258,{"v":0.82476450201566,"d":"82.5%"},{"v":-0.0001302522904332859,"d":"-0.0%"},{"v":0.04612081015807701,"d":"0.05"},{"v":0.6683162215890868,"d":"0.67"},{"v":0.9812127824422332,"d":"0.98"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[11,{"v":1,"d":"1.000"},1997,{"v":0.9050712397881788,"d":"90.5%"},-0.0997416203823223,{"v":0.039254224565015816,"d":"3.9%"},null,-0.19621531961067964,{"v":0.8218352583777596,"d":"82.2%"},{"v":-0.0035516121641286924,"d":"-0.4%"},{"v":0.08323598141041921,"d":"0.08"},{"v":0.6653869779511865,"d":"0.67"},{"v":0.9782835388043327,"d":"0.98"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.013390276908656018,"d":"1.3%"}]
[12,{"v":1,"d":"1.000"},1998,{"v":0.9367919018673363,"d":"93.7%"},-0.06529411119869982,{"v":0.035047696451586896,"d":"3.5%"},null,-0.20364566354225908,{"v":0.8157513704337811,"d":"81.6%"},{"v":-0.007402807170852732,"d":"-0.7%"},{"v":0.1210405314335552,"d":"0.12"},{"v":0.6593030900072079,"d":"0.66"},{"v":0.9721996508603543,"d":"0.97"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.020291535917592363,"d":"2.0%"}]
[13,{"v":1,"d":"1.000"},1999,{"v":1.0009400901415864,"d":"100.1%"},0.000939648533595079,{"v":0.06847645474558606,"d":"6.8%"},null,-0.2150716766921816,{"v":0.8064836320265608,"d":"80.6%"},{"v":-0.011360984171307154,"d":"-1.1%"},{"v":0.19445645811502554,"d":"0.19"},{"v":0.6500353515999877,"d":"0.65"},{"v":0.9629319124531339,"d":"0.96"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.030985143279761207,"d":"3.1%"}]
[14,{"v":1,"d":"1.000"},2000,{"v":0.9586438907550607,"d":"95.9%"},-0.04223560699654608,{"v":-0.04225647449143799,"d":"-4.2%"},null,-0.23013556777353728,{"v":0.7944258966527282,"d":"79.4%"},{"v":-0.01495099825340962,"d":"-1.5%"},{"v":0.1642179941023325,"d":"0.16"},{"v":0.637977616226155,"d":"0.64"},{"v":0.9508741770793014,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.03370406565177442,"d":"3.4%"}]
[15,{"v":1,"d":"1.000"},2001,{"v":0.8423531339695072,"d":"84.2%"},-0.17155595364932777,{"v":-0.1213075657259538,"d":"-12.1%"},null,-0.24781826949162464,{"v":0.7805017713740976,"d":"78.1%"},{"v":-0.017527280187238592,"d":"-1.8%"},{"v":0.061851362595409576,"d":"0.06"},{"v":0.6240534909475244,"d":"0.62"},{"v":0.9369500518006708,"d":"0.94"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02338653895861631,"d":"2.3%"}]
[16,{"v":1,"d":"1.000"},2002,{"v":0.7247393531178832,"d":"72.5%"},-0.32194320170858354,{"v":-0.13962526654038843,"d":"-14.0%"},null,-0.26652078483831065,{"v":0.7660400815414903,"d":"76.6%"},{"v":-0.018528708534699456,"d":"-1.9%"},{"v":-0.0413007284236071,"d":"-0.04"},{"v":0.6095918011149171,"d":"0.61"},{"v":0.9224883619680635,"d":"0.92"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.002740792757875976,"d":"0.3%"}]
[17,{"v":1,"d":"1.000"},2003,{"v":0.6572212360542009,"d":"65.7%"},-0.41973458041624134,{"v":-0.09316193024873598,"d":"-9.3%"},null,-0.2844010463569757,{"v":0.7524648109144008,"d":"75.2%"},{"v":-0.0177213581302067,"d":"-1.8%"},{"v":-0.09524357486019985,"d":"-0.10"},{"v":0.5960165304878275,"d":"0.60"},{"v":0.908913091340974,"d":"0.91"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.019021347423696322,"d":"-1.9%"}]
[18,{"v":1,"d":"1.000"},2004,{"v":0.6260785610578213,"d":"62.6%"},-0.4682794188586372,{"v":-0.04738537540775878,"d":"-4.7%"},null,-0.2997729648608324,{"v":0.7409864315437139,"d":"74.1%"},{"v":-0.015254373632088147,"d":"-1.5%"},{"v":-0.11490787048589257,"d":"-0.11"},{"v":0.5845381511171408,"d":"0.58"},{"v":0.897434711970287,"d":"0.90"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.036309420341507304,"d":"-3.6%"}]
[19,{"v":1,"d":"1.000"},2005,{"v":0.6258254937639587,"d":"62.6%"},-0.46868371069926984,{"v":-0.0004042101256990227,"d":"-0.0%"},null,-0.3113755972781519,{"v":0.7324387222086096,"d":"73.2%"},{"v":-0.011535581450927035,"d":"-1.2%"},{"v":-0.10661322844465093,"d":"-0.11"},{"v":0.5759904417820365,"d":"0.58"},{"v":0.8888870026351827,"d":"0.89"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.049772495518247695,"d":"-5.0%"}]
[20,{"v":1,"d":"1.000"},2006,{"v":0.636365703567735,"d":"63.6%"},-0.45198187528474987,{"v":0.01684209082053112,"d":"1.7%"},null,-0.3184850380169113,{"v":0.7272499589757666,"d":"72.7%"},{"v":-0.007084228448759111,"d":"-0.7%"},{"v":-0.09088425540803158,"d":"-0.09"},{"v":0.5708016785491934,"d":"0.57"},{"v":0.8836982394023398,"d":"0.88"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.05665236670415785,"d":"-5.7%"}]
[21,{"v":1,"d":"1.000"},2007,{"v":0.6584626382906333,"d":"65.8%"},-0.4178474970080855,{"v":0.03472364176606879,"d":"3.5%"},null,-0.32089473467672613,{"v":0.7254996169224388,"d":"72.5%"},{"v":-0.002406795671453743,"d":"-0.2%"},{"v":-0.06703697863180547,"d":"-0.07"},{"v":0.5690513364958656,"d":"0.57"},{"v":0.881947897349012,"d":"0.88"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.05574153640657786,"d":"-5.6%"}]
[22,{"v":1,"d":"1.000"},2008,{"v":0.6718992974568828,"d":"67.2%"},-0.39764680466324287,{"v":0.02040610717280944,"d":"2.0%"},null,-0.31883605053766945,{"v":0.7269947299313609,"d":"72.7%"},{"v":0.002060804684176576,"d":"0.2%"},{"v":-0.05509543247447812,"d":"-0.06"},{"v":0.5705464495047878,"d":"0.57"},{"v":0.883443010357934,"d":"0.88"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.0479484578496302,"d":"-4.8%"}]
[23,{"v":1,"d":"1.000"},2009,{"v":0.6625147381996628,"d":"66.3%"},-0.4117124750300923,{"v":-0.01396721099834497,"d":"-1.4%"},null,-0.31287374812465674,{"v":0.7313422400698258,"d":"73.1%"},{"v":0.005980112316461117,"d":"0.6%"},{"v":-0.06882750187016307,"d":"-0.07"},{"v":0.5748939596432527,"d":"0.57"},{"v":0.887790520496399,"d":"0.89"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.03269359496604318,"d":"-3.3%"}]
[24,{"v":1,"d":"1.000"},2010,{"v":0.7443167099141158,"d":"74.4%"},-0.2952886493589221,{"v":0.12347192748759683,"d":"12.3%"},null,-0.3038564980213483,{"v":0.7379667585425771,"d":"73.8%"},{"v":0.009058027978964711,"d":"0.9%"},{"v":0.006349951371538709,"d":"0.01"},{"v":0.5815184781160039,"d":"0.58"},{"v":0.8944150389691503,"d":"0.89"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.008830733720889938,"d":"-0.9%"}]
[25,{"v":1,"d":"1.000"},2011,{"v":0.7947571977470933,"d":"79.5%"},-0.22971862261431414,{"v":0.06776750697804124,"d":"6.8%"},null,-0.29289163626312054,{"v":0.7461029868244974,"d":"74.6%"},{"v":0.011025196172776974,"d":"1.1%"},{"v":0.04865421092259592,"d":"0.05"},{"v":0.5896547063979243,"d":"0.59"},{"v":0.9025512672510705,"d":"0.90"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.01361440422258875,"d":"1.4%"}]
[26,{"v":1,"d":"1.000"},2012,{"v":0.7934612135391687,"d":"79.3%"},-0.23135062043824137,{"v":-0.0016306668396315338,"d":"-0.2%"},null,-0.2810872735067981,{"v":0.7549624443849541,"d":"75.5%"},{"v":0.011874309199811028,"d":"1.2%"},{"v":0.038498769154214574,"d":"0.04"},{"v":0.5985141639583809,"d":"0.60"},{"v":0.9114107248115273,"d":"0.91"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02685963305366168,"d":"2.7%"}]
[27,{"v":1,"d":"1.000"},2013,{"v":0.805573898439145,"d":"80.6%"},-0.21620033825269938,{"v":0.015265629489245702,"d":"1.5%"},null,-0.26937874454458116,{"v":0.7638538953591182,"d":"76.4%"},{"v":0.011777342092039733,"d":"1.2%"},{"v":0.04172000308002677,"d":"0.04"},{"v":0.6074056149325451,"d":"0.61"},{"v":0.9203021757856913,"d":"0.92"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.03323720478471781,"d":"3.3%"}]
[28,{"v":1,"d":"1.000"},2014,{"v":0.8147364110873347,"d":"81.5%"},-0.20489064003217244,{"v":0.011373894643238458,"d":"1.1%"},null,-0.2585262185952177,{"v":0.772188785078588,"d":"77.2%"},{"v":0.010911628218576164,"d":"1.1%"},{"v":0.04254762600874673,"d":"0.04"},{"v":0.6157405046520148,"d":"0.62"},{"v":0.9286370655051612,"d":"0.93"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.034379598394197686,"d":"3.4%"}]
[29,{"v":1,"d":"1.000"},2015,{"v":0.8357028771245523,"d":"83.6%"},-0.17948213920868264,{"v":0.02573404815581526,"d":"2.6%"},null,-0.24911426162367742,{"v":0.7794909023999497,"d":"77.9%"},{"v":0.00945638872574217,"d":"0.9%"},{"v":0.0562119747246026,"d":"0.06"},{"v":0.6230426219733765,"d":"0.62"},{"v":0.9359391828265229,"d":"0.94"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.033626232652777865,"d":"3.4%"}]
[30,{"v":1,"d":"1.000"},2016,{"v":0.8602455877795842,"d":"86.0%"},-0.15053736331556852,{"v":0.029367746990984767,"d":"2.9%"},null,-0.24154002134884162,{"v":0.7854173696974329,"d":"78.5%"},{"v":0.007602997391292776,"d":"0.8%"},{"v":0.07482821808215123,"d":"0.07"},{"v":0.6289690892708597,"d":"0.63"},{"v":0.9418656501240061,"d":"0.94"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.032033812045587196,"d":"3.2%"}]
[31,{"v":1,"d":"1.000"},2017,{"v":0.8530171275758617,"d":"85.3%"},-0.15897565247063403,{"v":-0.008402786723242794,"d":"-0.8%"},null,-0.23596555286389276,{"v":0.7898078800837569,"d":"79.0%"},{"v":0.005590034745495132,"d":"0.6%"},{"v":0.06320924749210477,"d":"0.06"},{"v":0.6333595996571837,"d":"0.63"},{"v":0.9462561605103301,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.028551095678875704,"d":"2.9%"}]
[32,{"v":1,"d":"1.000"},2018,{"v":0.8387874631541138,"d":"83.9%"},-0.17579792623426732,{"v":-0.016681569410202046,"d":"-1.7%"},null,-0.2322692264537126,{"v":0.7927326699688526,"d":"79.3%"},{"v":0.003703166249475087,"d":"0.4%"},{"v":0.04605479318526118,"d":"0.05"},{"v":0.6362843895422794,"d":"0.64"},{"v":0.9491809503954258,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02230724829964803,"d":"2.2%"}]
[33,{"v":1,"d":"1.000"},2019,{"v":0.8247440051646806,"d":"82.5%"},-0.19268223756954414,{"v":-0.016742570205597995,"d":"-1.7%"},null,-0.230076393758835,{"v":0.7944729074133106,"d":"79.4%"},{"v":0.0021952387108334914,"d":"0.2%"},{"v":0.030271097751370046,"d":"0.03"},{"v":0.6380246269867373,"d":"0.64"},{"v":0.9509211878398838,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.011490820145839464,"d":"1.1%"}]
[34,{"v":1,"d":"1.000"},2020,{"v":0.6976704609922191,"d":"69.8%"},-0.3600084066253155,{"v":-0.1540763477839262,"d":"-15.4%"},null,-0.22882336794342822,{"v":0.7954690264270288,"d":"79.5%"},{"v":0.001253811180247144,"d":"0.1%"},{"v":-0.09779856543480969,"d":"-0.10"},{"v":0.6390207460004556,"d":"0.64"},{"v":0.951917306853602,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.003226466022373309,"d":"-0.3%"}]
[35,{"v":1,"d":"1.000"},2021,{"v":0.736092444690874,"d":"73.6%"},-0.3063995639412508,{"v":0.05507182236727015,"d":"5.5%"},null,-0.22790487167927403,{"v":0.7961999974017177,"d":"79.6%"},{"v":0.0009189182110234118,"d":"0.1%"},{"v":-0.06010755271084367,"d":"-0.06"},{"v":0.6397517169751445,"d":"0.64"},{"v":0.9526482778282908,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[36,null,2022,{"$nulls":4},-0.2270299835774877,{"v":0.7968968881123305,"d":"79.7%"},{"v":0.0008752709280168691,"d":"0.1%"},null,{"v":0.6404486076857574,"d":"0.64"},{"v":0.9533451685389036,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[37,null,2023,{"$nulls":4},-0.22615509547570134,{"v":0.7975943887911224,"d":"79.8%"},{"v":0.0008752709280170912,"d":"0.1%"},null,{"v":0.6411461083645493,"d":"0.64"},{"v":0.9540426692176955,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[38,null,2024,{"$nulls":4},-0.22528020737391502,{"v":0.7982924999719807,"d":"79.8%"},{"v":0.0008752709280168691,"d":"0.1%"},null,{"v":0.6418442195454075,"d":"0.64"},{"v":0.9547407803985539,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[]
[null,null,"All Year Avg:",{"v":-0.0005228423216879774,"d":"-0.1%"},"All Year Avg:",{"v":-0.0015697630836787324,"d":"-0.2%"},{"$nulls":3},{"v":-0.0015697630836783993,"d":"-0.2%"}]
[null,null,"10 Year Avg:",{"v":-0.02607053487153088,"d":"-2.6%"},null,{"v":0.005495615434960799,"d":"0.5%"},{"$nulls":3},{"v":0.0027261795309494463,"d":"0.3%"}]
[null,null,"5 Year Avg:",{"v":0.03298929736361167,"d":"3.3%"},null,{"v":0.014751016218908175,"d":"1.5%"},{"$nulls":3},{"v":0.007078463343275221,"d":"0.7%"}]
[null,null,"3 Year Avg:",{"v":0.03784797141153584,"d":"3.8%"},null,{"v":0.01073454052503875,"d":"1.1%"},{"$nulls":3},{"v":0.0077494377758671185,"d":"0.8%"}]
[null,null,"Linear 10Yr",{"v":-0.009808730957903489,"d":"-1.0%"}]
[]
[null,null,"10 Yr",{"v":-0.009760782256432732,"d":"-1.0%"}]
[null,null,"8 Yr",{"v":-0.020693026514171486,"d":"-2.1%"}]
[null,null,"6 Yr",{"v":-0.0391911685426205,"d":"-3.9%"}]

{"sheet":"Scenario5","index":5,"n_rows":61,"n_cols":15,"rows_kept":61,"read":"bin_skipped_in_rows","flags":["formulas_cached_only","records_skipped"],"rows_in_doubt":{"n":10,"rows":[4,13,48,49,50,52,53,54,55,56]},"rows_in_doubt_other":4}
["SCHEDULE P P&C INDUSTRY COMM AUTO LIABILITY ULR"]
["Direct and assumed"]
[]
[{"$nulls":8},"Smoother:",10]
[{"$nulls":3},"# Points",{"v":33.82399289487445,"d":"33.824"},{"$nulls":3},"# Param:",{"v":7.84257041050225,"d":"7.84"}]
[{"$nulls":8},"Std Error:",{"v":0.03895151718861307,"d":"0.04"}]
[{"$nulls":8},"GCV:",0.007474463876102315]
[]
[]
[{"$nulls":8},"Smoothing","Smoothed"]
["Index","Weights","Year","Loss Ratio",null,"Trend",null,null,"Spline","Trend","Error","LL","UL","10Yr"]
["X","w",null,"Y","log(Y)",null,null,"log(Y)","Y_hat"]
[]
[1,{"v":1,"d":"1.000"},1987,{"v":0.7450000110583505,"d":"74.5%"},-0.29437104575915424,null,null,-0.25956910744235867,{"v":0.7713838977836844,"d":"77.1%"},null,{"v":-0.026383886725333983,"d":"-0.03"},{"v":0.6950389240940028,"d":"0.70"},{"v":0.8477288714733661,"d":"0.85"}]
[2,{"v":1,"d":"1.000"},1988,{"v":0.801367175137667,"d":"80.1%"},-0.22143604101792005,{"v":0.07566062180219446,"d":"7.6%"},null,-0.2540264182611026,{"v":0.7756713098885992,"d":"77.6%"},{"v":0.005558078302170033,"d":"0.6%"},{"v":0.02569586524906775,"d":"0.03"},{"v":0.6993263361989176,"d":"0.70"},{"v":0.8520162835782809,"d":"0.85"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[3,{"v":1,"d":"1.000"},1989,{"v":0.8247732156286547,"d":"82.5%"},-0.1926468205837632,{"v":0.0292076356720834,"d":"2.9%"},null,-0.2514207499574732,{"v":0.7776950875364083,"d":"77.8%"},{"v":0.002609066007739358,"d":"0.3%"},{"v":0.04707812809224643,"d":"0.05"},{"v":0.7013501138467266,"d":"0.70"},{"v":0.8540400612260899,"d":"0.85"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[4,{"v":1,"d":"1.000"},1990,{"v":0.7874039734631337,"d":"78.7%"},-0.23901385417696003,{"v":-0.04530850597159308,"d":"-4.5%"},null,-0.25153686610332243,{"v":0.7776047898228103,"d":"77.8%"},{"v":-0.00011610940463047115,"d":"-0.0%"},{"v":0.009799183640323395,"d":"0.01"},{"v":0.7012598161331287,"d":"0.70"},{"v":0.853949763512492,"d":"0.85"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[5,{"v":1,"d":"1.000"},1991,{"v":0.7502089577689091,"d":"75.0%"},-0.287403500897894,{"v":-0.04723752603207576,"d":"-4.7%"},null,-0.24948937849276287,{"v":0.7791985570484253,"d":"77.9%"},{"v":0.002049585144631383,"d":"0.2%"},{"v":-0.028989599279516276,"d":"-0.03"},{"v":0.7028535833587437,"d":"0.70"},{"v":0.855543530738107,"d":"0.86"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[6,{"v":1,"d":"1.000"},1992,{"v":0.7419076607544931,"d":"74.2%"},-0.29853048998137116,{"v":-0.01106531310836878,"d":"-1.1%"},null,-0.2392103680086728,{"v":0.7872492528940664,"d":"78.7%"},{"v":0.010332020988510049,"d":"1.0%"},{"v":-0.04534159213957334,"d":"-0.05"},{"v":0.7109042792043848,"d":"0.71"},{"v":0.8635942265837481,"d":"0.86"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[7,{"v":1,"d":"1.000"},1993,{"v":0.7817679864681769,"d":"78.2%"},-0.24619727495468952,{"v":0.053726801625349596,"d":"5.4%"},null,-0.2179394755283779,{"v":0.804174112406905,"d":"80.4%"},{"v":0.02149873048544637,"d":"2.1%"},{"v":-0.02240612593872804,"d":"-0.02"},{"v":0.7278291387172233,"d":"0.73"},{"v":0.8805190860965866,"d":"0.88"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[8,{"v":1,"d":"1.000"},1994,{"v":0.838942500784609,"d":"83.9%"},-0.17561310789726567,{"v":0.0731348882354872,"d":"7.3%"},null,-0.1879738820912423,{"v":0.8286363491986196,"d":"82.9%"},{"v":0.030419080164740375,"d":"3.0%"},{"v":0.010306151585989354,"d":"0.01"},{"v":0.752291375508938,"d":"0.75"},{"v":0.9049813228883012,"d":"0.90"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[9,{"v":1,"d":"1.000"},1995,{"v":0.8412886820413054,"d":"84.1%"},-0.17282041745618484,{"v":0.002796593633654476,"d":"0.3%"},null,-0.15427727782802894,{"v":0.8570343514392155,"d":"85.7%"},{"v":0.0342707657805017,"d":"3.4%"},{"v":-0.01574566939791011,"d":"-0.02"},{"v":0.7806893777495338,"d":"0.78"},{"v":0.9333793251288971,"d":"0.93"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[10,{"v":1,"d":"1.000"},1996,{"v":0.870885312173737,"d":"87.1%"},-0.1382449845379159,{"v":0.03518011208782501,"d":"3.5%"},null,-0.12176931690747698,{"v":0.8853525808188737,"d":"88.5%"},{"v":0.03304211707745841,"d":"3.3%"},{"v":-0.0144672686451367,"d":"-0.01"},{"v":0.8090076071291921,"d":"0.81"},{"v":0.9616975545085553,"d":"0.96"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.010956161059296754,"d":"1.1%"}]
[11,{"v":1,"d":"1.000"},1997,{"v":0.9050712397881788,"d":"90.5%"},-0.0997416203823223,{"v":0.039254224565015816,"d":"3.9%"},null,-0.09667444436414331,{"v":0.9078515142054742,"d":"90.8%"},{"v":0.025412399392105378,"d":"2.5%"},{"v":-0.0027802744172953364,"d":"-0.00"},{"v":0.8315065405157925,"d":"0.83"},{"v":0.9841964878951558,"d":"0.98"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.013390276908656018,"d":"1.3%"}]
[12,{"v":1,"d":"1.000"},1998,{"v":0.9367919018673363,"d":"93.7%"},-0.06529411119869982,{"v":0.035047696451586896,"d":"3.5%"},null,-0.08667565500205361,{"v":0.9169744634861339,"d":"91.7%"},{"v":0.010048944279884564,"d":"1.0%"},{"v":0.019817438381202424,"d":"0.02"},{"v":0.8406294897964522,"d":"0.84"},{"v":0.9933194371758155,"d":"0.99"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.020291535917592363,"d":"2.0%"}]
[13,{"v":1,"d":"1.000"},1999,{"v":1.0009400901415864,"d":"100.1%"},0.000939648533595079,{"v":0.06847645474558606,"d":"6.8%"},null,-0.09957865742356377,{"v":0.9052187448939097,"d":"90.5%"},{"v":-0.012820115565194135,"d":"-1.3%"},{"v":0.09572134524767661,"d":"0.10"},{"v":0.8288737712042281,"d":"0.83"},{"v":0.9815637185835914,"d":"0.98"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.030985143279761207,"d":"3.1%"}]
[14,{"v":1,"d":"1.000"},2000,{"v":0.9586438907550607,"d":"95.9%"},-0.04223560699654608,{"v":-0.04225647449143799,"d":"-4.2%"},null,-0.14013953847848973,{"v":0.8692369349366136,"d":"86.9%"},{"v":-0.03974929834391927,"d":"-4.0%"},{"v":0.08940695581844715,"d":"0.09"},{"v":0.792891961246932,"d":"0.79"},{"v":0.9455819086262952,"d":"0.95"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.03370406565177442,"d":"3.4%"}]
[15,{"v":1,"d":"1.000"},2001,{"v":0.8423531339695072,"d":"84.2%"},-0.17155595364932777,{"v":-0.1213075657259538,"d":"-12.1%"},null,-0.20442507336474838,{"v":0.8151158135147826,"d":"81.5%"},{"v":-0.06226279538590662,"d":"-6.2%"},{"v":0.0272373204547246,"d":"0.03"},{"v":0.738770839825101,"d":"0.74"},{"v":0.8914607872044642,"d":"0.89"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02338653895861631,"d":"2.3%"}]
[16,{"v":1,"d":"1.000"},2002,{"v":0.7247393531178832,"d":"72.5%"},-0.32194320170858354,{"v":-0.13962526654038843,"d":"-14.0%"},null,-0.27975198475358426,{"v":0.7559712105932408,"d":"75.6%"},{"v":-0.07255975401398485,"d":"-7.3%"},{"v":-0.031231857475357616,"d":"-0.03"},{"v":0.6796262369035592,"d":"0.68"},{"v":0.8323161842829224,"d":"0.83"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.002740792757875976,"d":"0.3%"}]
[17,{"v":1,"d":"1.000"},2003,{"v":0.6572212360542009,"d":"65.7%"},-0.41973458041624134,{"v":-0.09316193024873598,"d":"-9.3%"},null,-0.3503171754264314,{"v":0.704464615415508,"d":"70.4%"},{"v":-0.06813301149036288,"d":"-6.8%"},{"v":-0.04724337936130707,"d":"-0.05"},{"v":0.6281196417258263,"d":"0.63"},{"v":0.7808095891051896,"d":"0.78"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.019021347423696322,"d":"-1.9%"}]
[18,{"v":1,"d":"1.000"},2004,{"v":0.6260785610578213,"d":"62.6%"},-0.4682794188586372,{"v":-0.04738537540775878,"d":"-4.7%"},null,-0.4037394340496305,{"v":0.6678181092605847,"d":"66.8%"},{"v":-0.05202036461875148,"d":"-5.2%"},{"v":-0.04173954820276338,"d":"-0.04"},{"v":0.5914731355709031,"d":"0.59"},{"v":0.7441630829502663,"d":"0.74"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.036309420341507304,"d":"-3.6%"}]
[19,{"v":1,"d":"1.000"},2005,{"v":0.6258254937639587,"d":"62.6%"},-0.46868371069926984,{"v":-0.0004042101256990227,"d":"-0.0%"},null,-0.4340442296515765,{"v":0.6478835991857721,"d":"64.8%"},{"v":-0.029850208909255715,"d":"-3.0%"},{"v":-0.022058105421813412,"d":"-0.02"},{"v":0.5715386254960905,"d":"0.57"},{"v":0.7242285728754537,"d":"0.72"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.049772495518247695,"d":"-5.0%"}]
[20,{"v":1,"d":"1.000"},2006,{"v":0.636365703567735,"d":"63.6%"},-0.45198187528474987,{"v":0.01684209082053112,"d":"1.7%"},null,-0.4412939783485572,{"v":0.6432035908469306,"d":"64.3%"},{"v":-0.007223532660377785,"d":"-0.7%"},{"v":-0.0068378872791955425,"d":"-0.01"},{"v":0.566858617157249,"d":"0.57"},{"v":0.7195485645366122,"d":"0.72"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.05665236670415785,"d":"-5.7%"}]
[21,{"v":1,"d":"1.000"},2007,{"v":0.6584626382906333,"d":"65.8%"},-0.4178474970080855,{"v":0.03472364176606879,"d":"3.5%"},null,-0.42911419302246356,{"v":0.6510855755060284,"d":"65.1%"},{"v":0.012254260970028685,"d":"1.2%"},{"v":0.007377062784604926,"d":"0.01"},{"v":0.5747406018163468,"d":"0.57"},{"v":0.72743054919571,"d":"0.73"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.05574153640657786,"d":"-5.6%"}]
[22,{"v":1,"d":"1.000"},2008,{"v":0.6718992974568828,"d":"67.2%"},-0.39764680466324287,{"v":0.02040610717280944,"d":"2.0%"},null,-0.4022324594348213,{"v":0.6688252528778831,"d":"66.9%"},{"v":0.027246306843869528,"d":"2.7%"},{"v":0.003074044578999735,"d":"0.00"},{"v":0.5924802791882015,"d":"0.59"},{"v":0.7451702265675647,"d":"0.75"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.0479484578496302,"d":"-4.8%"}]
[23,{"v":1,"d":"1.000"},2009,{"v":0.6625147381996628,"d":"66.3%"},-0.4117124750300923,{"v":-0.01396721099834497,"d":"-1.4%"},null,-0.3647269543156093,{"v":0.6943862241575247,"d":"69.4%"},{"v":0.0382177125783687,"d":"3.8%"},{"v":-0.031871485957861934,"d":"-0.03"},{"v":0.6180412504678431,"d":"0.62"},{"v":0.7707311978472063,"d":"0.77"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.03269359496604318,"d":"-3.3%"}]
[24,{"v":1,"d":"1.000"},2010,{"v":0.7443167099141158,"d":"74.4%"},-0.2952886493589221,{"v":0.12347192748759683,"d":"12.3%"},null,-0.32096545782170216,{"v":0.725448309122197,"d":"72.5%"},{"v":0.04473315265198252,"d":"4.5%"},{"v":0.01886840079191876,"d":"0.02"},{"v":0.6491033354325154,"d":"0.65"},{"v":0.8017932828118787,"d":"0.80"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.008830733720889938,"d":"-0.9%"}]
[25,{"v":1,"d":"1.000"},2011,{"v":0.7947571977470933,"d":"79.5%"},-0.22971862261431414,{"v":0.06776750697804124,"d":"6.8%"},null,-0.2779437437703691,{"v":0.7573394253765805,"d":"75.7%"},{"v":0.043960563217759985,"d":"4.4%"},{"v":0.0374177723705128,"d":"0.04"},{"v":0.6809944516868989,"d":"0.68"},{"v":0.8336843990662621,"d":"0.83"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.01361440422258875,"d":"1.4%"}]
[26,{"v":0.9990009990009991,"d":"0.999"},2012,{"v":0.7934612135391687,"d":"79.3%"},-0.23135062043824137,{"v":-0.0016306668396315338,"d":"-0.2%"},null,-0.2409251387406668,{"v":0.7859004576841984,"d":"78.6%"},{"v":0.037712327327229955,"d":"3.8%"},{"v":0.007560755854970291,"d":"0.01"},{"v":0.7095554839945167,"d":"0.71"},{"v":0.86224543137388,"d":"0.86"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02685963305366168,"d":"2.7%"}]
[27,{"v":0.998003992015968,"d":"0.998"},2013,{"v":0.805573898439145,"d":"80.6%"},-0.21620033825269938,{"v":0.015265629489245702,"d":"1.5%"},null,-0.21137059853771814,{"v":0.8094740213978509,"d":"80.9%"},{"v":0.02999561010960128,"d":"3.0%"},{"v":-0.0039001229587058983,"d":"-0.00"},{"v":0.7331290477081692,"d":"0.73"},{"v":0.8858189950875325,"d":"0.89"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.03323720478471781,"d":"3.3%"}]
[28,{"v":0.9950248756218907,"d":"0.995"},2014,{"v":0.8147364110873347,"d":"81.5%"},-0.20489064003217244,{"v":0.011373894643238458,"d":"1.1%"},null,-0.18937999838270578,{"v":0.8274720089190715,"d":"82.7%"},{"v":0.02223417558248575,"d":"2.2%"},{"v":-0.012735597831736722,"d":"-0.01"},{"v":0.7511270352293898,"d":"0.75"},{"v":0.9038169826087531,"d":"0.90"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.034379598394197686,"d":"3.4%"}]
[29,{"v":0.9900990099009901,"d":"0.990"},2015,{"v":0.8357028771245523,"d":"83.6%"},-0.17948213920868264,{"v":0.02573404815581526,"d":"2.6%"},null,-0.17547236214669118,{"v":0.8390605866864203,"d":"83.9%"},{"v":0.014004797313309725,"d":"1.4%"},{"v":-0.003357709561867983,"d":"-0.00"},{"v":0.7627156129967386,"d":"0.76"},{"v":0.9154055603761019,"d":"0.92"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.033626232652777865,"d":"3.4%"}]
[30,{"v":0.9803921568627451,"d":"0.980"},2016,{"v":0.8602455877795842,"d":"86.0%"},-0.15053736331556852,{"v":0.029367746990984767,"d":"2.9%"},null,-0.17134211491618936,{"v":0.8425332809570457,"d":"84.3%"},{"v":0.004138788456671039,"d":"0.4%"},{"v":0.017712306822538437,"d":"0.02"},{"v":0.7661883072673641,"d":"0.77"},{"v":0.9188782546467273,"d":"0.92"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.032033812045587196,"d":"3.2%"}]
[31,{"v":0.9523809523809523,"d":"0.952"},2017,{"v":0.8530171275758617,"d":"85.3%"},-0.15897565247063403,{"v":-0.008402786723242794,"d":"-0.8%"},null,-0.17886563118070445,{"v":0.8362182535078191,"d":"83.6%"},{"v":-0.007495285458698153,"d":"-0.7%"},{"v":0.01679887406804259,"d":"0.02"},{"v":0.7598732798181375,"d":"0.76"},{"v":0.9125632271975007,"d":"0.91"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.028551095678875704,"d":"2.9%"}]
[32,{"v":0.9090909090909091,"d":"0.909"},2018,{"v":0.8387874631541138,"d":"83.9%"},-0.17579792623426732,{"v":-0.016681569410202046,"d":"-1.7%"},null,-0.19830995173396287,{"v":0.8201156174817866,"d":"82.0%"},{"v":-0.019256499076029665,"d":"-1.9%"},{"v":0.01867184567232716,"d":"0.02"},{"v":0.743770643792105,"d":"0.74"},{"v":0.8964605911714683,"d":"0.90"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.02230724829964803,"d":"2.2%"}]
[33,{"v":0.8333333333333334,"d":"0.833"},2019,{"v":0.8247440051646806,"d":"82.5%"},-0.19268223756954414,{"v":-0.016742570205597995,"d":"-1.7%"},null,-0.22799822336154613,{"v":0.7961256742616842,"d":"79.6%"},{"v":-0.02925190388858212,"d":"-2.9%"},{"v":0.02861833090299637,"d":"0.03"},{"v":0.7197807005720026,"d":"0.72"},{"v":0.8724706479513659,"d":"0.87"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":0.011490820145839464,"d":"1.1%"}]
[34,{"v":0.6666666666666666,"d":"0.667"},2020,{"v":0.6976704609922191,"d":"69.8%"},-0.3600084066253155,{"v":-0.1540763477839262,"d":"-15.4%"},null,-0.2640830139167898,{"v":0.7679097898112871,"d":"76.8%"},{"v":-0.035441495435458936,"d":"-3.5%"},{"v":-0.07023932881906803,"d":"-0.07"},{"v":0.6915648161216055,"d":"0.69"},{"v":0.8442547635009687,"d":"0.84"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.003226466022373309,"d":"-0.3%"}]
[35,{"v":0.5,"d":"0.500"},2021,{"v":0.736092444690874,"d":"73.6%"},-0.3063995639412508,{"v":0.05507182236727015,"d":"5.5%"},null,-0.30147963844367404,{"v":0.7397228881105504,"d":"74.0%"},{"v":-0.036706006453783524,"d":"-3.7%"},{"v":-0.0036304434196764435,"d":"-0.00"},{"v":0.6633779144208688,"d":"0.66"},{"v":0.816067861800232,"d":"0.82"},{"v":-0.009760782256432732,"d":"-1.0%"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[36,null,2022,{"$nulls":4},-0.3389172623497048,{"v":0.7125414006516292,"d":"71.3%"},{"v":-0.036745500099841455,"d":"-3.7%"},null,{"v":0.6361964269619476,"d":"0.64"},{"v":0.7888863743413108,"d":"0.79"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[37,null,2023,{"$nulls":4},-0.37635488625573554,{"v":0.6863587105428436,"d":"68.6%"},{"v":-0.036745500099841455,"d":"-3.7%"},null,{"v":0.610013736853162,"d":"0.61"},{"v":0.7627036842325252,"d":"0.76"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[38,null,2024,{"$nulls":4},-0.4137925101617663,{"v":0.6611381164760645,"d":"66.1%"},{"v":-0.036745500099841455,"d":"-3.7%"},null,{"v":0.5847931427863828,"d":"0.58"},{"v":0.7374830901657461,"d":"0.74"},{"v":-0.009760782256432732,"d":"-1.0%"}]
[]
[null,null,"All Year Avg:",{"v":-0.0005228423216879774,"d":"-0.1%"},"All Year Avg:",{"v":-0.0015697630836787324,"d":"-0.2%"},{"$nulls":3},{"v":-0.00145215663327114,"d":"-0.1%"}]
[null,null,"10 Year Avg:",{"v":-0.02607053487153088,"d":"-2.6%"},null,{"v":0.005495615434960799,"d":"0.5%"},{"$nulls":3},{"v":0.005600396586765477,"d":"0.6%"}]
[null,null,"5 Year Avg:",{"v":0.03298929736361167,"d":"3.3%"},null,{"v":0.014751016218908175,"d":"1.5%"},{"$nulls":3},{"v":0.014755113938464737,"d":"1.5%"}]
[null,null,"3 Year Avg:",{"v":0.03784797141153584,"d":"3.8%"},null,{"v":0.01073454052503875,"d":"1.1%"},{"$nulls":3},{"v":0.012104469141748675,"d":"1.2%"}]
[null,null,"Linear 10Yr",{"v":-0.009808730957903489,"d":"-1.0%"}]
[]
[null,null,"10 Yr",{"v":-0.009760782256432732,"d":"-1.0%"}]
[null,null,"8 Yr",{"v":-0.020693026514171486,"d":"-2.1%"}]
[null,null,"6 Yr",{"v":-0.0391911685426205,"d":"-3.9%"}]