{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Wksh 1 - Market Experience","Wksh 2 - Plan Product Info","Wksh 3 - Rating Areas","PlanTemplate"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Wksh 1 - Market Experience","index":0,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[29,3,29,6],[111,0,111,14],[49,1,49,16],[7,1,8,16],[21,3,21,4],[21,5,21,6],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3]]}
["Press TAB and directional arrow keys to read through the document. If macros are disabled, press and hold the ALT key and press the F, then I, and then N key. After that, select the Enable All Content option by pressing enter. (note that you can also press the C key to select \"Enable All Content\")  Instructions can be found in cells K1 through K4. If screen reader fails to announce a cell after performing a dropdown selection, please press F2 and then ESC to force the screen reader to resume.","Unified Rate Review v6.1 [assistive technology users, please reference cell A1 for instructions]",null,null,null,null,null,null,null,null,"To add a product to Worksheet 2 - Plan Product Info, select the Add Product button or Ctrl + Shift + P."]
[null,null,null,null,null,null,null,null,null,null,"To add a plan to Worksheet 2 - Plan Product Info, select the Add Plan button or Ctrl + Shift + L."]
[null,"Company Legal Name:","Anthem Health Plans of Kentucky, Inc.",null,null,null,null,null,null,null,"To validate, select the Validate button or Ctrl + Shift + I."]
[null,"HIOS Issuer ID:",36239.0,"State:","KY",null,null,null,null,null,"To finalize, select the Finalize button or Ctrl + Shift + F."]
[null,"Effective Date of Rate Change(s):",{"$f":"MAX('Wksh 2 - Plan Product Info'!E19:CF19)","v":"1/1/2026"},"Market: ","Small Group"]
[]
[]
[null,"Market Level Calculations (Same for all Plans)"]
[]
[]
[null,"Section I: Experience Period Data"]
[null,"Experience Period:",null,"2024-01-01","to",{"$f":"EDATE(D12,12)-1","v":"12/31/2024"}]
[null,null,null,null,"Total","PMPM"]
[null,"Allowed Claims",null,null,2.3953660688E8,{"$f":"E14/E19","v":"$814.43"}]
[null,"Reinsurance",null,null,0.0,{"$f":"E15/E19","v":"$0.00"}]
[null,"Incurred Claims in Experience Period",null,null,1.9538586651E8,{"$f":"E16/E19","v":"$664.32"}]
[null,"Risk Adjustment",null,null,3402233.62,{"$f":"E17/E19","v":"$11.57"}]
[null,"Experience Period Premium",null,null,2.2004066142E8,{"$f":"E18/E19","v":"$748.14"}]
[null,"Experience Period Member Months",null,null,294115.0]
[]
[null,"Section II: Projections"]
[null,null,null,"Year 1 Trend",null,"Year 2 Trend"]
[null,"Benefit Category","Experience Period Index Rate PMPM","Cost","Utilization","Cost","Utilization","Trended EHB Allowed Claims PMPM"]
[null,"Inpatient Hospital","$106.83",1.03927207586853,1.03209996942402,1.03927207586852,1.03209996942402,{"$f":"PRODUCT(C24:G24)","v":"$122.92"}]
[null,"Outpatient Hospital","$297.68",1.03927207586853,1.03209996942402,1.03927207586852,1.03209996942402,{"$f":"PRODUCT(C25:G25)","v":"$342.50"}]
[null,"Professional","$161.14",1.03927207586853,1.03209996942402,1.03927207586852,1.03209996942402,{"$f":"PRODUCT(C26:G26)","v":"$185.40"}]
[null,"Other Medical","$11.92",1.03927207586853,1.03209996942402,1.03927207586852,1.03209996942402,{"$f":"PRODUCT(C27:G27)","v":"$13.72"}]
[null,"Capitation","$0.03",1.00656866392087,1.0,1.00656866392087,1.0,{"$f":"PRODUCT(C28:G28)","v":"$0.03"}]
[null,"Prescription Drug","$236.71",1.06014520889956,1.07543980509739,1.06014520889956,1.0754398050974,{"$f":"PRODUCT(C29:G29)","v":"$307.70"}]
[null,"Total",{"$f":"SUM(C24:C29)","v":"$814.32"},null,null,null,null,{"$f":"SUM(H24:H29)","v":"$972.26"}]
[]
[null,"Morbidity Adjustment",null,null,null,1.077]
[null,"Demographic Shift",null,null,null,1.004]
[null,"Plan Design Changes",null,null,null,1.009]
[null,"Other",null,null,null,1.08673957284501]
[null,"Adjusted Trended EHB Allowed Claims PMPM for",null,{"$f":"IF(C5<>\"\",C5,\"\")","v":"1/1/2026"},null,{"$f":"H30*PRODUCT(F32:F35)","v":"$1,152.78"}]
[]
[null,"Manual EHB Allowed Claims PMPM",null,null,null,0.0]
[null,"Applied Credibility %",null,null,null,1.0]
[]
[null,null,null,null,null,null,"Projected Period Totals"]
[null,"Projected Index Rate for",null,{"$f":"IF(C5<>\"\",C5,\"\")","v":"1/1/2026"},null,{"$f":"ROUND(F39*F36+(1-F39)*F38,2)","v":"$1,152.78"},{"$f":"F42*F48","v":"$195,134,528.94"}]
[null,"Reinsurance",null,null,null,0.0,{"$f":"F43*F48","v":"$0.00"}]
[null,"Risk Adjustment Payment/Charge",null,null,null,0.216789112369023,{"$f":"F44*F48","v":"$36,696.54"}]
[null,"Exchange User Fees",null,null,null,0.0,{"$f":"F45*F46*F48","v":"$0.00"}]
[null,"Market Adjusted Index Rate",null,null,null,{"$f":"(F42-F43-F44)/(1-F45)","v":"$1,152.56"},{"$f":"F46*F48","v":"$195,097,832.40"}]
[]
[null,"Projected Member Months",null,null,null,{"$f":"'Wksh 2 - Plan Product Info'!D73","v":"169273"}]
[]
[null,"Information Not Releasable to the Public Unless Authorized by Law:  This information has not been publically disclosed and may be privileged and confidential. It is for internal government use only and must not be disseminated, distributed, or copied to persons not authorized to receive the information.  Unauthorized disclosure may result in prosecution to the full extent of the law.  "]

{"sheet":"Wksh 2 - Plan Product Info","index":1,"n_rows":82,"n_cols":84,"rows_kept":82,"cut":false,"hidden":false,"merged":[[6,2,7,21],[9,5,9,14],[9,15,9,45],[9,46,9,72],[9,73,9,82],[10,5,10,14],[10,15,10,45],[10,46,10,72],[10,73,10,82],[20,5,20,14],[20,15,20,45],[20,46,20,72],[20,73,20,82],[21,4,21,83],[58,4,58,83],[59,4,59,83],[60,4,60,83],[47,4,47,83]]}
["Press TAB and directional arrow keys to read through the document. If macros are disabled, press and hold the ALT key and press the F, then I, and then N key. After that, select the Enable All Content option by pressing enter. (note that you can also press the C key to select \"Enable All Content\")  Instructions can be found in cells P1 through P6. If screen reader fails to announce a cell after performing a dropdown selection, please press F2 and then ESC to force the screen reader to resume.",null,"Product-Plan Data Collection [assistive technology users, please reference cell A1 for instructions]",null,null,null,null,null,null,null,null,null,null,null,null,"To add a product to Worksheet 2 - Plan Product Info, select the Add Product button or Ctrl + Shift + P."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To add a plan to Worksheet 2 - Plan Product Info, select the Add Plan button or Ctrl + Shift + L."]
[null,null,"Company Legal Name:",{"$f":"IF('Wksh 1 - Market Experience'!C3<>\"\", 'Wksh 1 - Market Experience'!C3,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"To validate, select the Validate button or Ctrl + Shift + I."]
[null,null,"HIOS Issuer ID:",{"$f":"IF('Wksh 1 - Market Experience'!C4<>\"\", 'Wksh 1 - Market Experience'!C4,\"\")","v":""},"State:",{"$f":"IF('Wksh 1 - Market Experience'!E4<>\"\",'Wksh 1 - Market Experience'!E4,\"\")","v":""},null,null,null,null,null,null,null,null,null,"To finalize, select the Finalize button or Ctrl + Shift + F."]
[null,null,"Effective Date of Rate Change(s):",{"$f":"IF('Wksh 1 - Market Experience'!C5<>\"\", 'Wksh 1 - Market Experience'!C5,\"\")","v":"00:00:00"},"Market: ",{"$f":"IF('Wksh 1 - Market Experience'!E5<>\"\",'Wksh 1 - Market Experience'!E5,\"\")","v":""},null,null,null,null,null,null,null,null,null,"To remove a product, navigate to the corresponding Product Name/Product ID field and select the Remove Product button or Ctrl + Shift + Q."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To remove a plan, navigate to the corresponding Plan Name/Plan ID field and select the Remove Plan button or Ctrl + Shift + A."]
[null,null,"Product/Plan Level Calculations"]
[]
[null,"Field #","Section I: General Product and Plan Information"]
[null,"1.1","Product Name",null,"PPO","PPO On Exchange",null,null,null,null,null,null,null,null,null,"PPO Off Exchange",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO Off Exchange",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO ON Exchange",null,null,null,null,null,null,null,null,null,"EPO Off Exchange"]
[null,"1.2","Product ID",null,"36239KY047","36239KY098",null,null,null,null,null,null,null,null,null,"36239KY099",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36239KY117",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36239KY118",null,null,null,null,null,null,null,null,null,"36239KY120"]
[null,"1.3","Plan Name",null,"2024 Experience","Anthem Silver Blue Access PPO 3400EC/0%/5600 w/HSA (SHOP)","Anthem Silver Blue Access PPO 6000/20%/8500 (SHOP)","Anthem Silver Blue Access PPO 5000EC/0%/6000 w/HSA (SHOP)","Anthem Silver Blue Access PPO 3500EC/0%/6500 w/HSA (SHOP)","Anthem Gold Blue Access PPO 1500/20%/6000 (SHOP)","Anthem Gold Blue Access PPO 2500/20%/5000 (SHOP)","Anthem Gold Blue Access PPO 650/20%/9400 (SHOP)","Anthem Gold Blue Access PPO 1000/20%/7100 (SHOP)","Anthem Gold Blue Access PPO 3000/20%/5500 (SHOP)","Anthem Gold Blue Access PPO 2000/20%/4900 (SHOP)","Anthem Bronze Blue Access PPO 8000EC/50%/9000","Anthem Bronze Blue Access PPO 6500E/40%/7500 w/HSA","Anthem Bronze Blue Access PPO 8000E/0%/8000 w/HSA","Anthem Silver Blue Access PPO 5500/20%/8200","Anthem Virtual Access Plus Silver Blue Access PPO 3000/6800","Anthem Silver Blue Access PPO 4000EC/0%/5500 w/HSA","Anthem Silver Blue Access PPO 4500/20%/8500","Anthem Silver Blue Access PPO 7000/20%/8500","Anthem Silver Blue Access PPO 3000/30%/7000 w/HSA","Anthem Silver Blue Access PPO 5000EC/0%/6000 w/HSA WH","Anthem Silver Blue Access PPO 4500E/30%/7000 w/HSA","Anthem Silver Blue Access PPO 3500E/20%/7000 w/HSA","Anthem Gold Blue Access PPO 1000/20%/7100 WH","Anthem Gold Blue Access PPO 3000/20%/5500 WH","Anthem Virtual Access Plus Gold Blue Access PPO 2000/4500","Anthem Gold Blue Access PPO 1500/20%/6000 (Grp Conv)","Anthem Virtual Access Plus Gold Blue Access PPO 1000/5000","Anthem Gold Blue Access PPO 1700/30%/4800 w/HSA","Anthem Gold Blue Access PPO 2000/30%/5500","Anthem Gold Blue Access PPO 3000/30%/5400","Anthem Gold Blue Access PPO 0/50%/8700","Anthem Clear Choice Gold Blue Access PPO 30/8300","Anthem Clear Choice Gold Blue Access PPO 40/10150","Anthem Platinum Blue Access PPO 0/10%/5500","Anthem Platinum Blue Access PPO 500/0%/3500","Anthem Platinum Blue Access PPO 250/10%/2500","Anthem Clear Choice Platinum Blue Access PPO 20/3600","Anthem Bronze Blue Access PPO 5000/50%/7500 w/HSA","Anthem Platinum Blue Access PPO 0/10%/3000","Anthem Bronze Blue Access PPO 6500/50%/8000 w/HSA","Anthem Silver Blue Access PPO 3000EC/0%/6250 w/HSA","Anthem Bronze Pathway HMO 8000E/0%/8000 w/HSA","Anthem Bronze Pathway HMO 8000EC/50%/9000","Anthem Bronze Pathway HMO 6500E/40%/7500 w/HSA","Anthem Silver Pathway HMO 3500E/20%/7000 w/HSA","Anthem Virtual Access Plus Silver Pathway HMO 3000/6800","Anthem Silver Pathway HMO 4000EC/0%/5500 w/HSA","Anthem Silver Pathway HMO 4500E/30%/7000 w/HSA","Anthem Silver Pathway HMO 3000/30%/7000 w/HSA","Anthem Silver Pathway HMO 5000EC/0%/6000 w/HSA WH","Anthem Silver Pathway HMO 4500/20%/8500","Anthem Silver Pathway HMO 5500/20%/8200","Anthem Silver Pathway HMO 7000/20%/8500","Anthem Gold Pathway HMO 1000/20%/7100 WH","Anthem Gold Pathway HMO 2000/30%/5500","Anthem Gold Pathway HMO 1700/30%/4800 w/HSA","Anthem Virtual Access Plus Gold Pathway HMO 1000/5000","Anthem Virtual Access Plus Gold Pathway HMO 2000/4500","Anthem Gold Pathway HMO 1500/20%/6000 (Grp Conv)","Anthem Gold Pathway HMO 3000/20%/5500 WH","Anthem Gold Pathway HMO 0/50%/8700","Anthem Gold Pathway HMO 3000/30%/5400","Anthem Platinum Pathway HMO 250/10%/2500","Anthem Platinum Pathway HMO 500/0%/3500","Anthem Platinum Pathway HMO 0/10%/5500","Anthem Bronze Pathway HMO 6500/50%/8000 w/HSA","Anthem Bronze Pathway HMO 5000/50%/7500 w/HSA","Anthem Silver Pathway HMO 3200EC/0%/6250 w/HSA","Anthem Silver Pathway HMO 3400EC/0%/5600 w/HSA (SHOP)","Anthem Silver Pathway HMO 3500EC/0%/6500 w/HSA (SHOP)","Anthem Silver Pathway HMO 6000/20%/8500 (SHOP)","Anthem Silver Pathway HMO 5000EC/0%/6000 w/HSA (SHOP)","Anthem Gold Pathway HMO 650/20%/9400 (SHOP)","Anthem Gold Pathway HMO 2000/20%/4900 (SHOP)","Anthem Gold Pathway HMO 1500/20%/6000 (SHOP)","Anthem Gold Pathway HMO 2500/20%/5000 (SHOP)","Anthem Gold Pathway HMO 1000/20%/7100 (SHOP)","Anthem Gold Pathway HMO 3000/20%/5500 (SHOP)","Anthem Link Gold Pathway EPO 1000/6000"]
[null,"1.4","Plan ID (Standard Component ID)",null,"36239KY0470001","36239KY0980052","36239KY0980051","36239KY0980054","36239KY0980053","36239KY0980047","36239KY0980049","36239KY0980045","36239KY0980046","36239KY0980050","36239KY0980048","36239KY0990238","36239KY0990273","36239KY0990274","36239KY0990263","36239KY0990284","36239KY0990257","36239KY0990260","36239KY0990220","36239KY0990269","36239KY0990265","36239KY0990272","36239KY0990271","36239KY0990262","36239KY0990261","36239KY0990282","36239KY0990237","36239KY0990283","36239KY0990275","36239KY0990286","36239KY0990285","36239KY0990278","36239KY0990289","36239KY0990287","36239KY0990281","36239KY0990242","36239KY0990190","36239KY0990288","36239KY0990276","36239KY0990277","36239KY0990270","36239KY0990266","36239KY1170130","36239KY1170073","36239KY1170129","36239KY1170127","36239KY1170138","36239KY1170115","36239KY1170128","36239KY1170131","36239KY1170122","36239KY1170117","36239KY1170120","36239KY1170056","36239KY1170118","36239KY1170141","36239KY1170125","36239KY1170139","36239KY1170137","36239KY1170142","36239KY1170119","36239KY1170136","36239KY1170140","36239KY1170037","36239KY1170075","36239KY1170135","36239KY1170132","36239KY1170126","36239KY1170123","36239KY1180034","36239KY1180035","36239KY1180033","36239KY1180036","36239KY1180028","36239KY1180030","36239KY1180037","36239KY1180031","36239KY1180029","36239KY1180032","36239KY1200005"]
[null,"1.5","Metal",null,"Not Applicable","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Gold","Bronze","Bronze","Bronze","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Platinum","Platinum","Platinum","Platinum","Bronze","Platinum","Bronze","Silver","Bronze","Bronze","Bronze","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Platinum","Platinum","Platinum","Bronze","Bronze","Silver","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Gold","Gold"]
[null,"1.6","AV Metal Value",null,0.0,0.719,0.715,0.702,0.7,0.816,0.813,0.82,0.82,0.802,0.819,0.614,0.644,0.631,0.719,0.72,0.718,0.717,0.715,0.718,0.702,0.693,0.719,0.82,0.802,0.801,0.816,0.803,0.801,0.81,0.798,0.82,0.82,0.783,0.917,0.906,0.916,0.881,0.648,0.916,0.632,0.689,0.631,0.614,0.644,0.719,0.72,0.718,0.693,0.718,0.702,0.717,0.719,0.715,0.82,0.81,0.801,0.803,0.801,0.816,0.802,0.82,0.798,0.916,0.906,0.917,0.632,0.648,0.699,0.719,0.7,0.715,0.702,0.82,0.819,0.816,0.813,0.82,0.802,0.783]
[null,"1.7","Plan Category",null,"Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","New","New","Renewing","Renewing","Renewing","New","Terminated","Terminated","Terminated","Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Terminated","Terminated","Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Terminated"]
[null,"1.8","Plan Type",null,"PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","PPO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","EPO"]
[null,"1.9","Exchange Plan?",null,"No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No"]
[null,"1.10","Effective Date of Proposed Rates",null,"2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01"]
[null,"1.11","Cumulative Rate Change %  (over 12 mos prior)",null,0.0,0.1676,0.1986,0.1689,0.1679,0.1804,0.1901,0.1721,0.1847,0.1886,0.1757,0.147,0.1721,0.1372,0.1963,0.1588,0.1669,0.189,0.1967,0.1624,0.1862,0.2,0.1774,0.1899,0.1815,0.1613,0.1954,0.0,0.1609,0.0,0.1865,0.1806,0.0,0.0,0.1736,0.1847,0.1745,0.0,0.0,0.0,0.0,0.0,0.0,0.1411,0.175,0.1975,0.1383,0.1687,0.2006,0.1818,0.1554,0.2008,0.183,0.2005,0.2064,0.0,0.0,0.0,0.0,0.0,0.2269,0.2081,0.0,0.1738,0.1605,0.211,0.0,0.0,0.0,0.1577,0.0,0.2077,0.1701,0.1867,0.1899,0.1949,0.1863,0.1944,0.1821,0.0]
[null,"1.12","Product Rate Increase %",null,{"$f":"IF(SUMPRODUCT((E16:E16=\"Renewing\")*((E14:E14=\"Platinum\")+(E14:E14=\"Gold\")+(E14:E14=\"Silver\")+(E14:E14=\"Bronze\")+(E14:E14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:E20,E34:E34,E35:E35,--(E16:E16=\"Renewing\")*((E14:E14=\"Platinum\")+(E14:E14=\"Gold\")+(E14:E14=\"Silver\")+(E14:E14=\"Bronze\")+(E14:E14=\"Catastrophic\")))/SUMPRODUCT(E34:E34,E35:E35,--(E16:E16=\"Renewing\")*((E14:E14=\"Platinum\")+(E14:E14=\"Gold\")+(E14:E14=\"Silver\")+(E14:E14=\"Bronze\")+(E14:E14=\"Catastrophic\"))), 4)-1, 4))","v":"0"},{"$f":"IF(SUMPRODUCT((F16:O16=\"Renewing\")*((F14:O14=\"Platinum\")+(F14:O14=\"Gold\")+(F14:O14=\"Silver\")+(F14:O14=\"Bronze\")+(F14:O14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+F20:O20,F34:O34,F35:O35,--(F16:O16=\"Renewing\")*((F14:O14=\"Platinum\")+(F14:O14=\"Gold\")+(F14:O14=\"Silver\")+(F14:O14=\"Bronze\")+(F14:O14=\"Catastrophic\")))/SUMPRODUCT(F34:O34,F35:O35,--(F16:O16=\"Renewing\")*((F14:O14=\"Platinum\")+(F14:O14=\"Gold\")+(F14:O14=\"Silver\")+(F14:O14=\"Bronze\")+(F14:O14=\"Catastrophic\"))), 4)-1, 4))","v":"0.1808"},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((P16:AT16=\"Renewing\")*((P14:AT14=\"Platinum\")+(P14:AT14=\"Gold\")+(P14:AT14=\"Silver\")+(P14:AT14=\"Bronze\")+(P14:AT14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+P20:AT20,P34:AT34,P35:AT35,--(P16:AT16=\"Renewing\")*((P14:AT14=\"Platinum\")+(P14:AT14=\"Gold\")+(P14:AT14=\"Silver\")+(P14:AT14=\"Bronze\")+(P14:AT14=\"Catastrophic\")))/SUMPRODUCT(P34:AT34,P35:AT35,--(P16:AT16=\"Renewing\")*((P14:AT14=\"Platinum\")+(P14:AT14=\"Gold\")+(P14:AT14=\"Silver\")+(P14:AT14=\"Bronze\")+(P14:AT14=\"Catastrophic\"))), 4)-1, 4))","v":"0.1791"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((AU16:BU16=\"Renewing\")*((AU14:BU14=\"Platinum\")+(AU14:BU14=\"Gold\")+(AU14:BU14=\"Silver\")+(AU14:BU14=\"Bronze\")+(AU14:BU14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+AU20:BU20,AU34:BU34,AU35:BU35,--(AU16:BU16=\"Renewing\")*((AU14:BU14=\"Platinum\")+(AU14:BU14=\"Gold\")+(AU14:BU14=\"Silver\")+(AU14:BU14=\"Bronze\")+(AU14:BU14=\"Catastrophic\")))/SUMPRODUCT(AU34:BU34,AU35:BU35,--(AU16:BU16=\"Renewing\")*((AU14:BU14=\"Platinum\")+(AU14:BU14=\"Gold\")+(AU14:BU14=\"Silver\")+(AU14:BU14=\"Bronze\")+(AU14:BU14=\"Catastrophic\"))), 4)-1, 4))","v":"0.1795"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((BV16:CE16=\"Renewing\")*((BV14:CE14=\"Platinum\")+(BV14:CE14=\"Gold\")+(BV14:CE14=\"Silver\")+(BV14:CE14=\"Bronze\")+(BV14:CE14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+BV20:CE20,BV34:CE34,BV35:CE35,--(BV16:CE16=\"Renewing\")*((BV14:CE14=\"Platinum\")+(BV14:CE14=\"Gold\")+(BV14:CE14=\"Silver\")+(BV14:CE14=\"Bronze\")+(BV14:CE14=\"Catastrophic\")))/SUMPRODUCT(BV34:CE34,BV35:CE35,--(BV16:CE16=\"Renewing\")*((BV14:CE14=\"Platinum\")+(BV14:CE14=\"Gold\")+(BV14:CE14=\"Silver\")+(BV14:CE14=\"Bronze\")+(BV14:CE14=\"Catastrophic\"))), 4)-1, 4))","v":"0.186"},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((CF16:CF16=\"Renewing\")*((CF14:CF14=\"Platinum\")+(CF14:CF14=\"Gold\")+(CF14:CF14=\"Silver\")+(CF14:CF14=\"Bronze\")+(CF14:CF14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+CF20:CF20,CF34:CF34,CF35:CF35,--(CF16:CF16=\"Renewing\")*((CF14:CF14=\"Platinum\")+(CF14:CF14=\"Gold\")+(CF14:CF14=\"Silver\")+(CF14:CF14=\"Bronze\")+(CF14:CF14=\"Catastrophic\")))/SUMPRODUCT(CF34:CF34,CF35:CF35,--(CF16:CF16=\"Renewing\")*((CF14:CF14=\"Platinum\")+(CF14:CF14=\"Gold\")+(CF14:CF14=\"Silver\")+(CF14:CF14=\"Bronze\")+(CF14:CF14=\"Catastrophic\"))), 4)-1, 4))","v":"0"}]
[null,"1.13","Submission Level Rate Increase %",null,{"$f":"IF(SUMPRODUCT((E16:CF16=\"Renewing\")*((E14:CF14=\"Platinum\")+(E14:CF14=\"Gold\")+(E14:CF14=\"Silver\")+(E14:CF14=\"Bronze\")+(E14:CF14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:CF20,E34:CF34,E35:CF35,--(E16:CF16=\"Renewing\")*((E14:CF14=\"Platinum\")+(E14:CF14=\"Gold\")+(E14:CF14=\"Silver\")+(E14:CF14=\"Bronze\")+(E14:CF14=\"Catastrophic\")))/SUMPRODUCT(E34:CF34,E35:CF35,--(E16:CF16=\"Renewing\")*((E14:CF14=\"Platinum\")+(E14:CF14=\"Gold\")+(E14:CF14=\"Silver\")+(E14:CF14=\"Bronze\")+(E14:CF14=\"Catastrophic\"))), 4)-1, 4))","v":"0.1804"}]
[]
["Worksheet 1 Totals",null,"Section II: Experience Period and Current Plan Level Information"]
[null,"2.1","Plan ID (Standard Component ID)","Total",{"$f":"IF(E13<>\"\",E13,\"\")","v":"36239KY0470001"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"36239KY0980052"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"36239KY0980051"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"36239KY0980054"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"36239KY0980053"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"36239KY0980047"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"36239KY0980049"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"36239KY0980045"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"36239KY0980046"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"36239KY0980050"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"36239KY0980048"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"36239KY0990238"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"36239KY0990273"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"36239KY0990274"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"36239KY0990263"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"36239KY0990284"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"36239KY0990257"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"36239KY0990260"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"36239KY0990220"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"36239KY0990269"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"36239KY0990265"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"36239KY0990272"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"36239KY0990271"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"36239KY0990262"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"36239KY0990261"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"36239KY0990282"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"36239KY0990237"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"36239KY0990283"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"36239KY0990275"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"36239KY0990286"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"36239KY0990285"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"36239KY0990278"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"36239KY0990289"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"36239KY0990287"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"36239KY0990281"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"36239KY0990242"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"36239KY0990190"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"36239KY0990288"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"36239KY0990276"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"36239KY0990277"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"36239KY0990270"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"36239KY0990266"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"36239KY1170130"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"36239KY1170073"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"36239KY1170129"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"36239KY1170127"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"36239KY1170138"},{"$f":"IF(AZ13<>\"\",AZ13,\"\")","v":"36239KY1170115"},{"$f":"IF(BA13<>\"\",BA13,\"\")","v":"36239KY1170128"},{"$f":"IF(BB13<>\"\",BB13,\"\")","v":"36239KY1170131"},{"$f":"IF(BC13<>\"\",BC13,\"\")","v":"36239KY1170122"},{"$f":"IF(BD13<>\"\",BD13,\"\")","v":"36239KY1170117"},{"$f":"IF(BE13<>\"\",BE13,\"\")","v":"36239KY1170120"},{"$f":"IF(BF13<>\"\",BF13,\"\")","v":"36239KY1170056"},{"$f":"IF(BG13<>\"\",BG13,\"\")","v":"36239KY1170118"},{"$f":"IF(BH13<>\"\",BH13,\"\")","v":"36239KY1170141"},{"$f":"IF(BI13<>\"\",BI13,\"\")","v":"36239KY1170125"},{"$f":"IF(BJ13<>\"\",BJ13,\"\")","v":"36239KY1170139"},{"$f":"IF(BK13<>\"\",BK13,\"\")","v":"36239KY1170137"},{"$f":"IF(BL13<>\"\",BL13,\"\")","v":"36239KY1170142"},{"$f":"IF(BM13<>\"\",BM13,\"\")","v":"36239KY1170119"},{"$f":"IF(BN13<>\"\",BN13,\"\")","v":"36239KY1170136"},{"$f":"IF(BO13<>\"\",BO13,\"\")","v":"36239KY1170140"},{"$f":"IF(BP13<>\"\",BP13,\"\")","v":"36239KY1170037"},{"$f":"IF(BQ13<>\"\",BQ13,\"\")","v":"36239KY1170075"},{"$f":"IF(BR13<>\"\",BR13,\"\")","v":"36239KY1170135"},{"$f":"IF(BS13<>\"\",BS13,\"\")","v":"36239KY1170132"},{"$f":"IF(BT13<>\"\",BT13,\"\")","v":"36239KY1170126"},{"$f":"IF(BU13<>\"\",BU13,\"\")","v":"36239KY1170123"},{"$f":"IF(BV13<>\"\",BV13,\"\")","v":"36239KY1180034"},{"$f":"IF(BW13<>\"\",BW13,\"\")","v":"36239KY1180035"},{"$f":"IF(BX13<>\"\",BX13,\"\")","v":"36239KY1180033"},{"$f":"IF(BY13<>\"\",BY13,\"\")","v":"36239KY1180036"},{"$f":"IF(BZ13<>\"\",BZ13,\"\")","v":"36239KY1180028"},{"$f":"IF(CA13<>\"\",CA13,\"\")","v":"36239KY1180030"},{"$f":"IF(CB13<>\"\",CB13,\"\")","v":"36239KY1180037"},{"$f":"IF(CC13<>\"\",CC13,\"\")","v":"36239KY1180031"},{"$f":"IF(CD13<>\"\",CD13,\"\")","v":"36239KY1180029"},{"$f":"IF(CE13<>\"\",CE13,\"\")","v":"36239KY1180032"},{"$f":"IF(CF13<>\"\",CF13,\"\")","v":"36239KY1200005"}]
[{"$f":"'Wksh 1 - Market Experience'!E14","v":0},"2.2","Allowed Claims",{"$f":"SUM(E26:CF26)","v":"$238,623,028"},7.929208302E7,6040537.88,2996633.12,5709841.96,4841859.98,1.804824431E7,1.244574207E7,7255735.28,1.064855461E7,2.196280164E7,1.765647951E7,950441.6,9020.58,137295.51,1250635.99,0.0,6204672.53,8874365.51,2987524.34,2287306.55,165060.02,142121.14,276754.13,509378.44,447354.08,0.0,679917.26,0.0,1062193.53,0.0,0.0,146171.63,0.0,0.0,86503.55,4134392.27,1.002648488E7,0.0,639039.91,34059.19,2049976.0,764171.69,0.0,76906.61,0.0,0.0,0.0,349175.44,0.0,34040.13,94042.17,500132.36,54562.21,168873.85,0.0,0.0,-417.49,0.0,0.0,0.0,48778.71,4375.16,0.0,84088.59,99003.36,-41.27,28890.03,82006.05,3779.05,251782.62,4110.61,177286.6,269699.39,519075.04,394379.89,622870.44,466233.07,246450.35,3267345.96,12245.36]
[{"$f":"'Wksh 1 - Market Experience'!E15","v":0},"2.3","Reinsurance",{"$f":"SUM(E27:CF27)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"2.4","Member Cost Sharing",{"$f":"SUM(E28:CF28)","v":"$44,104,253"},1.751861222E7,1132167.76,702584.26,1393902.35,750913.41,2982935.22,2142770.26,1110668.8,2020054.21,3331835.57,2409224.57,269128.74,9802.7,67682.82,281129.35,0.0,954286.53,1895789.15,655069.7,270460.81,64152.35,21916.91,39068.68,101830.86,127785.3,0.0,154618.42,0.0,186849.1,0.0,0.0,43864.38,0.0,0.0,18649.46,360403.11,722689.27,0.0,192184.05,6375.87,511161.8,171644.73,0.0,35179.38,0.0,0.0,0.0,85822.13,0.0,22211.07,29854.97,174618.61,12034.59,59827.51,0.0,0.0,11.32,0.0,0.0,0.0,20031.89,493.63,0.0,15879.55,9593.75,237.06,24343.06,34655.96,5215.24,87456.95,4907.31,57124.52,52353.3,55964.75,91020.92,90100.7,75486.24,50971.73,380735.94,5908.68]
[null,"2.5","Cost Sharing Reduction",{"$f":"SUM(E29:CF29)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[{"$f":"'Wksh 1 - Market Experience'!E16","v":0},"2.6","Incurred Claims",{"$f":"D26-D27-D28-D29","v":"$194,518,774"},{"$f":"E26-E27-E28-E29","v":"61773470.8"},{"$f":"F26-F27-F28-F29","v":"4908370.12"},{"$f":"G26-G27-G28-G29","v":"2294048.86"},{"$f":"H26-H27-H28-H29","v":"4315939.61"},{"$f":"I26-I27-I28-I29","v":"4090946.57"},{"$f":"J26-J27-J28-J29","v":"15065309.09"},{"$f":"K26-K27-K28-K29","v":"10302971.81"},{"$f":"L26-L27-L28-L29","v":"6145066.48"},{"$f":"M26-M27-M28-M29","v":"8628500.4"},{"$f":"N26-N27-N28-N29","v":"18630966.07"},{"$f":"O26-O27-O28-O29","v":"15247254.94"},{"$f":"P26-P27-P28-P29","v":"681312.86"},{"$f":"Q26-Q27-Q28-Q29","v":"-782.12"},{"$f":"R26-R27-R28-R29","v":"69612.69"},{"$f":"S26-S27-S28-S29","v":"969506.64"},{"$f":"T26-T27-T28-T29","v":"0"},{"$f":"U26-U27-U28-U29","v":"5250386"},{"$f":"V26-V27-V28-V29","v":"6978576.36"},{"$f":"W26-W27-W28-W29","v":"2332454.64"},{"$f":"X26-X27-X28-X29","v":"2016845.74"},{"$f":"Y26-Y27-Y28-Y29","v":"100907.67"},{"$f":"Z26-Z27-Z28-Z29","v":"120204.23"},{"$f":"AA26-AA27-AA28-AA29","v":"237685.45"},{"$f":"AB26-AB27-AB28-AB29","v":"407547.58"},{"$f":"AC26-AC27-AC28-AC29","v":"319568.78"},{"$f":"AD26-AD27-AD28-AD29","v":"0"},{"$f":"AE26-AE27-AE28-AE29","v":"525298.84"},{"$f":"AF26-AF27-AF28-AF29","v":"0"},{"$f":"AG26-AG27-AG28-AG29","v":"875344.43"},{"$f":"AH26-AH27-AH28-AH29","v":"0"},{"$f":"AI26-AI27-AI28-AI29","v":"0"},{"$f":"AJ26-AJ27-AJ28-AJ29","v":"102307.25"},{"$f":"AK26-AK27-AK28-AK29","v":"0"},{"$f":"AL26-AL27-AL28-AL29","v":"0"},{"$f":"AM26-AM27-AM28-AM29","v":"67854.09"},{"$f":"AN26-AN27-AN28-AN29","v":"3773989.16"},{"$f":"AO26-AO27-AO28-AO29","v":"9303795.61"},{"$f":"AP26-AP27-AP28-AP29","v":"0"},{"$f":"AQ26-AQ27-AQ28-AQ29","v":"446855.86"},{"$f":"AR26-AR27-AR28-AR29","v":"27683.32"},{"$f":"AS26-AS27-AS28-AS29","v":"1538814.2"},{"$f":"AT26-AT27-AT28-AT29","v":"592526.96"},{"$f":"AU26-AU27-AU28-AU29","v":"0"},{"$f":"AV26-AV27-AV28-AV29","v":"41727.23"},{"$f":"AW26-AW27-AW28-AW29","v":"0"},{"$f":"AX26-AX27-AX28-AX29","v":"0"},{"$f":"AY26-AY27-AY28-AY29","v":"0"},{"$f":"AZ26-AZ27-AZ28-AZ29","v":"263353.31"},{"$f":"BA26-BA27-BA28-BA29","v":"0"},{"$f":"BB26-BB27-BB28-BB29","v":"11829.06"},{"$f":"BC26-BC27-BC28-BC29","v":"64187.2"},{"$f":"BD26-BD27-BD28-BD29","v":"325513.75"},{"$f":"BE26-BE27-BE28-BE29","v":"42527.62"},{"$f":"BF26-BF27-BF28-BF29","v":"109046.34"},{"$f":"BG26-BG27-BG28-BG29","v":"0"},{"$f":"BH26-BH27-BH28-BH29","v":"0"},{"$f":"BI26-BI27-BI28-BI29","v":"-428.81"},{"$f":"BJ26-BJ27-BJ28-BJ29","v":"0"},{"$f":"BK26-BK27-BK28-BK29","v":"0"},{"$f":"BL26-BL27-BL28-BL29","v":"0"},{"$f":"BM26-BM27-BM28-BM29","v":"28746.82"},{"$f":"BN26-BN27-BN28-BN29","v":"3881.53"},{"$f":"BO26-BO27-BO28-BO29","v":"0"},{"$f":"BP26-BP27-BP28-BP29","v":"68209.04"},{"$f":"BQ26-BQ27-BQ28-BQ29","v":"89409.61"},{"$f":"BR26-BR27-BR28-BR29","v":"-278.33"},{"$f":"BS26-BS27-BS28-BS29","v":"4546.97"},{"$f":"BT26-BT27-BT28-BT29","v":"47350.09"},{"$f":"BU26-BU27-BU28-BU29","v":"-1436.19"},{"$f":"BV26-BV27-BV28-BV29","v":"164325.67"},{"$f":"BW26-BW27-BW28-BW29","v":"-796.7"},{"$f":"BX26-BX27-BX28-BX29","v":"120162.08"},{"$f":"BY26-BY27-BY28-BY29","v":"217346.09"},{"$f":"BZ26-BZ27-BZ28-BZ29","v":"463110.29"},{"$f":"CA26-CA27-CA28-CA29","v":"303358.97"},{"$f":"CB26-CB27-CB28-CB29","v":"532769.74"},{"$f":"CC26-CC27-CC28-CC29","v":"390746.83"},{"$f":"CD26-CD27-CD28-CD29","v":"195478.62"},{"$f":"CE26-CE27-CE28-CE29","v":"2886610.02"},{"$f":"CF26-CF27-CF28-CF29","v":"6336.68"}]
[{"$f":"'Wksh 1 - Market Experience'!E17","v":0},"2.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E31:CF31)","v":"$3,402,233"},0.0,19131.89,640593.38,377764.3,229906.55,738609.69,-30194.29,-143658.04,-1127959.58,488084.71,560723.3,69237.07,-6122.38,10229.85,229010.14,0.0,994164.4,-697313.63,95970.68,181241.94,-84979.33,69455.67,-13044.32,-46340.11,-51462.59,0.0,-199969.19,0.0,233795.84,0.0,0.0,-128364.44,0.0,0.0,-20474.77,476957.92,1429628.96,0.0,-122501.07,-166469.68,634855.05,310453.53,0.0,-107289.07,0.0,0.0,0.0,-163003.19,0.0,-24545.49,-13143.58,-269075.85,-55003.14,-138312.14,0.0,0.0,-4282.51,0.0,0.0,0.0,-98879.1,-6278.91,0.0,10647.03,-15187.38,-12841.18,-14696.74,-76371.56,-25493.65,-30584.46,3808.22,-131947.14,4667.18,20823.74,-249695.17,-243697.73,129428.3,-41186.2,33204.47,-29792.58]
[{"$f":"'Wksh 1 - Market Experience'!E18","v":0},"2.8","Premium",{"$f":"SUM(E32:CF32)","v":"$220,003,736"},7.835536288E7,4994121.61,2822614.39,5406409.41,2752972.58,1.805538789E7,1.142283657E7,6583370.9,1.235708162E7,1.68340217E7,1.560414004E7,874499.57,39198.42,161338.39,1084393.71,0.0,3969072.16,7701911.37,2666056.47,1059577.83,180833.71,59183.09,174272.19,635142.97,846296.24,0.0,769609.06,0.0,910758.37,0.0,0.0,301120.11,0.0,0.0,205434.65,4752811.19,8246216.6,0.0,652311.28,278992.45,1302439.33,723080.68,0.0,223488.15,0.0,0.0,0.0,369423.72,0.0,61061.04,65676.68,712693.79,97219.9,260002.56,0.0,0.0,4569.76,0.0,0.0,0.0,129086.53,9503.11,0.0,279819.43,101959.1,16653.24,39527.65,123592.47,29742.1,319574.91,7574.57,225980.36,199236.24,228514.64,597358.28,682578.53,400628.08,358830.74,1622376.79,54195.06]
[{"$f":"'Wksh 1 - Market Experience'!E19","v":0},"2.9","Experience Period Member Months",{"$f":"SUM(E33:CF33)","v":"294115"},111624.0,7504.0,3715.0,7961.0,4117.0,22187.0,14367.0,7726.0,14984.0,21367.0,19069.0,1367.0,64.0,259.0,1263.0,0.0,5765.0,10732.0,3674.0,1713.0,321.0,97.0,178.0,902.0,1080.0,0.0,964.0,0.0,1174.0,0.0,0.0,383.0,0.0,0.0,237.0,4989.0,8736.0,0.0,1065.0,252.0,2242.0,1000.0,0.0,437.0,0.0,0.0,0.0,540.0,0.0,114.0,105.0,1029.0,195.0,367.0,0.0,0.0,11.0,0.0,0.0,0.0,212.0,18.0,0.0,410.0,106.0,14.0,74.0,276.0,48.0,501.0,20.0,367.0,361.0,257.0,820.0,1048.0,648.0,507.0,2473.0,79.0]
[null,"2.10","Current Enrollment",{"$f":"SUM(E34:CF34)","v":"14100"},0.0,623.0,278.0,522.0,315.0,1583.0,1063.0,547.0,1087.0,1364.0,1457.0,144.0,330.0,11.0,150.0,17.0,441.0,1011.0,292.0,282.0,33.0,29.0,38.0,81.0,104.0,20.0,80.0,0.0,119.0,0.0,48.0,43.0,0.0,0.0,67.0,323.0,711.0,0.0,0.0,0.0,0.0,0.0,0.0,57.0,33.0,3.0,13.0,39.0,2.0,2.0,21.0,110.0,24.0,47.0,2.0,0.0,0.0,0.0,0.0,0.0,1.0,3.0,0.0,33.0,7.0,3.0,0.0,0.0,0.0,35.0,0.0,27.0,26.0,17.0,24.0,104.0,47.0,41.0,166.0,0.0]
[null,"2.11","Current Premium PMPM",{"$f":"SUMPRODUCT(E35:CF35,E34:CF34)/D34","v":"$962.53"},0.0,816.12,936.56,895.35,853.22,990.04,977.96,1076.43,1024.79,983.9,1024.33,782.26,921.67,741.67,991.25,919.09,891.09,901.15,883.45,784.29,865.32,890.4,1011.68,826.42,1068.79,913.38,998.16,0.0,952.54,0.0,912.94,832.73,0.0,0.0,1097.62,1194.54,1149.49,0.0,0.0,0.0,0.0,0.0,0.0,653.95,711.96,597.66,597.33,782.58,571.4,959.72,1052.45,783.6,606.2,825.72,622.43,0.0,0.0,0.0,0.0,0.0,1834.75,621.72,0.0,873.5,1249.05,1347.2,0.0,0.0,0.0,747.02,0.0,624.86,674.65,1191.11,1069.13,801.75,863.17,893.18,797.34,0.0]
[null,"2.12","Loss Ratio",{"$f":"D30/(D31+D32)","v":"87.07%"},0.788375786027628,0.979078779878177,0.662405784565447,0.74616355358387,1.3714758096819,0.801602161853636,0.904353139226276,0.954245416464112,0.768403831507383,1.075560075029,0.943234385549714,0.721931131125734,-0.0236461196684972,0.405743452284642,0.738163391252432,0.0,1.05785527982168,0.996285100020604,0.844472017590413,1.62541393098532,1.05271840473017,0.934432437004213,1.47422061706825,0.692163044180866,0.402057436798253,0.0,0.922159539148831,0.0,0.764790712709012,0.0,0.0,0.592207769504758,0.0,0.0,0.366858423567316,0.721635904113556,0.961548585320744,0.0,0.8434262903314,0.246024160265518,0.794310981276888,0.573301739088056,0.0,0.359101208030219,0.0,0.0,0.0,1.27580967842685,0.0,0.323945825819411,1.22184299041937,0.733770482771729,1.00736342627904,0.896096340204923,0.0,0.0,-1.49281114012185,0.0,0.0,0.0,0.951647326502122,1.20387382916692,0.0,0.234825872839157,1.03040034241571,-0.073013016584209,0.183117332389348,1.00273565248954,-0.338050347773894,0.568619724285007,-0.0699916277116595,1.27786839587116,1.06592665292225,1.85735661714013,0.872565887131367,1.21392810986491,0.737179750576722,0.615400535453876,1.74356287410501,0.259673606944868]
[null,null,"Per Member Per Month"]
[null,"2.13","Allowed Claims",{"$f":"D26/D33","v":"$811.33"},{"$f":"E26/E33","v":"710.3498"},{"$f":"F26/F33","v":"804.9757"},{"$f":"G26/G33","v":"806.6307"},{"$f":"H26/H33","v":"717.2267"},{"$f":"I26/I33","v":"1176.0651"},{"$f":"J26/J33","v":"813.4603"},{"$f":"K26/K33","v":"866.2729"},{"$f":"L26/L33","v":"939.1322"},{"$f":"M26/M33","v":"710.6617"},{"$f":"N26/N33","v":"1027.8842"},{"$f":"O26/O33","v":"925.9258"},{"$f":"P26/P33","v":"695.2755"},{"$f":"Q26/Q33","v":"140.9466"},{"$f":"R26/R33","v":"530.0985"},{"$f":"S26/S33","v":"990.2106"},{"$f":"T26/T33","v":"0"},{"$f":"U26/U33","v":"1076.2658"},{"$f":"V26/V33","v":"826.907"},{"$f":"W26/W33","v":"813.1531"},{"$f":"X26/X33","v":"1335.2636"},{"$f":"Y26/Y33","v":"514.2057"},{"$f":"Z26/Z33","v":"1465.1664"},{"$f":"AA26/AA33","v":"1554.7985"},{"$f":"AB26/AB33","v":"564.7211"},{"$f":"AC26/AC33","v":"414.2167"},{"$f":"AD26/AD33","v":"0"},{"$f":"AE26/AE33","v":"705.3084"},{"$f":"AF26/AF33","v":"0"},{"$f":"AG26/AG33","v":"904.7645"},{"$f":"AH26/AH33","v":"0"},{"$f":"AI26/AI33","v":"0"},{"$f":"AJ26/AJ33","v":"381.6492"},{"$f":"AK26/AK33","v":"0"},{"$f":"AL26/AL33","v":"0"},{"$f":"AM26/AM33","v":"364.9939"},{"$f":"AN26/AN33","v":"828.7016"},{"$f":"AO26/AO33","v":"1147.7203"},{"$f":"AP26/AP33","v":"0"},{"$f":"AQ26/AQ33","v":"600.0375"},{"$f":"AR26/AR33","v":"135.1555"},{"$f":"AS26/AS33","v":"914.3515"},{"$f":"AT26/AT33","v":"764.1717"},{"$f":"AU26/AU33","v":"0"},{"$f":"AV26/AV33","v":"175.9877"},{"$f":"AW26/AW33","v":"0"},{"$f":"AX26/AX33","v":"0"},{"$f":"AY26/AY33","v":"0"},{"$f":"AZ26/AZ33","v":"646.6212"},{"$f":"BA26/BA33","v":"0"},{"$f":"BB26/BB33","v":"298.5976"},{"$f":"BC26/BC33","v":"895.6397"},{"$f":"BD26/BD33","v":"486.0373"},{"$f":"BE26/BE33","v":"279.8062"},{"$f":"BF26/BF33","v":"460.1467"},{"$f":"BG26/BG33","v":"0"},{"$f":"BH26/BH33","v":"0"},{"$f":"BI26/BI33","v":"-37.9536"},{"$f":"BJ26/BJ33","v":"0"},{"$f":"BK26/BK33","v":"0"},{"$f":"BL26/BL33","v":"0"},{"$f":"BM26/BM33","v":"230.0883"},{"$f":"BN26/BN33","v":"243.0644"},{"$f":"BO26/BO33","v":"0"},{"$f":"BP26/BP33","v":"205.0941"},{"$f":"BQ26/BQ33","v":"933.994"},{"$f":"BR26/BR33","v":"-2.9479"},{"$f":"BS26/BS33","v":"390.4058"},{"$f":"BT26/BT33","v":"297.1234"},{"$f":"BU26/BU33","v":"78.7302"},{"$f":"BV26/BV33","v":"502.5601"},{"$f":"BW26/BW33","v":"205.5305"},{"$f":"BX26/BX33","v":"483.0698"},{"$f":"BY26/BY33","v":"747.0897"},{"$f":"BZ26/BZ33","v":"2019.7472"},{"$f":"CA26/CA33","v":"480.9511"},{"$f":"CB26/CB33","v":"594.342"},{"$f":"CC26/CC33","v":"719.4955"},{"$f":"CD26/CD33","v":"486.0954"},{"$f":"CE26/CE33","v":"1321.2074"},{"$f":"CF26/CF33","v":"155.0046"}]
[null,"2.14","Reinsurance",{"$f":"D27/D33","v":"$0.00"},{"$f":"E27/E33","v":"0"},{"$f":"F27/F33","v":"0"},{"$f":"G27/G33","v":"0"},{"$f":"H27/H33","v":"0"},{"$f":"I27/I33","v":"0"},{"$f":"J27/J33","v":"0"},{"$f":"K27/K33","v":"0"},{"$f":"L27/L33","v":"0"},{"$f":"M27/M33","v":"0"},{"$f":"N27/N33","v":"0"},{"$f":"O27/O33","v":"0"},{"$f":"P27/P33","v":"0"},{"$f":"Q27/Q33","v":"0"},{"$f":"R27/R33","v":"0"},{"$f":"S27/S33","v":"0"},{"$f":"T27/T33","v":"0"},{"$f":"U27/U33","v":"0"},{"$f":"V27/V33","v":"0"},{"$f":"W27/W33","v":"0"},{"$f":"X27/X33","v":"0"},{"$f":"Y27/Y33","v":"0"},{"$f":"Z27/Z33","v":"0"},{"$f":"AA27/AA33","v":"0"},{"$f":"AB27/AB33","v":"0"},{"$f":"AC27/AC33","v":"0"},{"$f":"AD27/AD33","v":"0"},{"$f":"AE27/AE33","v":"0"},{"$f":"AF27/AF33","v":"0"},{"$f":"AG27/AG33","v":"0"},{"$f":"AH27/AH33","v":"0"},{"$f":"AI27/AI33","v":"0"},{"$f":"AJ27/AJ33","v":"0"},{"$f":"AK27/AK33","v":"0"},{"$f":"AL27/AL33","v":"0"},{"$f":"AM27/AM33","v":"0"},{"$f":"AN27/AN33","v":"0"},{"$f":"AO27/AO33","v":"0"},{"$f":"AP27/AP33","v":"0"},{"$f":"AQ27/AQ33","v":"0"},{"$f":"AR27/AR33","v":"0"},{"$f":"AS27/AS33","v":"0"},{"$f":"AT27/AT33","v":"0"},{"$f":"AU27/AU33","v":"0"},{"$f":"AV27/AV33","v":"0"},{"$f":"AW27/AW33","v":"0"},{"$f":"AX27/AX33","v":"0"},{"$f":"AY27/AY33","v":"0"},{"$f":"AZ27/AZ33","v":"0"},{"$f":"BA27/BA33","v":"0"},{"$f":"BB27/BB33","v":"0"},{"$f":"BC27/BC33","v":"0"},{"$f":"BD27/BD33","v":"0"},{"$f":"BE27/BE33","v":"0"},{"$f":"BF27/BF33","v":"0"},{"$f":"BG27/BG33","v":"0"},{"$f":"BH27/BH33","v":"0"},{"$f":"BI27/BI33","v":"0"},{"$f":"BJ27/BJ33","v":"0"},{"$f":"BK27/BK33","v":"0"},{"$f":"BL27/BL33","v":"0"},{"$f":"BM27/BM33","v":"0"},{"$f":"BN27/BN33","v":"0"},{"$f":"BO27/BO33","v":"0"},{"$f":"BP27/BP33","v":"0"},{"$f":"BQ27/BQ33","v":"0"},{"$f":"BR27/BR33","v":"0"},{"$f":"BS27/BS33","v":"0"},{"$f":"BT27/BT33","v":"0"},{"$f":"BU27/BU33","v":"0"},{"$f":"BV27/BV33","v":"0"},{"$f":"BW27/BW33","v":"0"},{"$f":"BX27/BX33","v":"0"},{"$f":"BY27/BY33","v":"0"},{"$f":"BZ27/BZ33","v":"0"},{"$f":"CA27/CA33","v":"0"},{"$f":"CB27/CB33","v":"0"},{"$f":"CC27/CC33","v":"0"},{"$f":"CD27/CD33","v":"0"},{"$f":"CE27/CE33","v":"0"},{"$f":"CF27/CF33","v":"0"}]
[null,"2.15","Member Cost Sharing",{"$f":"D28/D33","v":"$149.96"},{"$f":"E28/E33","v":"156.9431"},{"$f":"F28/F33","v":"150.8752"},{"$f":"G28/G33","v":"189.1209"},{"$f":"H28/H33","v":"175.0914"},{"$f":"I28/I33","v":"182.3933"},{"$f":"J28/J33","v":"134.4452"},{"$f":"K28/K33","v":"149.1453"},{"$f":"L28/L33","v":"143.7573"},{"$f":"M28/M33","v":"134.8141"},{"$f":"N28/N33","v":"155.9337"},{"$f":"O28/O33","v":"126.3425"},{"$f":"P28/P33","v":"196.8754"},{"$f":"Q28/Q33","v":"153.1672"},{"$f":"R28/R33","v":"261.3236"},{"$f":"S28/S33","v":"222.5886"},{"$f":"T28/T33","v":"0"},{"$f":"U28/U33","v":"165.5311"},{"$f":"V28/V33","v":"176.6483"},{"$f":"W28/W33","v":"178.2988"},{"$f":"X28/X33","v":"157.8872"},{"$f":"Y28/Y33","v":"199.8516"},{"$f":"Z28/Z33","v":"225.9475"},{"$f":"AA28/AA33","v":"219.487"},{"$f":"AB28/AB33","v":"112.8945"},{"$f":"AC28/AC33","v":"118.3197"},{"$f":"AD28/AD33","v":"0"},{"$f":"AE28/AE33","v":"160.3926"},{"$f":"AF28/AF33","v":"0"},{"$f":"AG28/AG33","v":"159.156"},{"$f":"AH28/AH33","v":"0"},{"$f":"AI28/AI33","v":"0"},{"$f":"AJ28/AJ33","v":"114.5284"},{"$f":"AK28/AK33","v":"0"},{"$f":"AL28/AL33","v":"0"},{"$f":"AM28/AM33","v":"78.6897"},{"$f":"AN28/AN33","v":"72.2395"},{"$f":"AO28/AO33","v":"82.7254"},{"$f":"AP28/AP33","v":"0"},{"$f":"AQ28/AQ33","v":"180.4545"},{"$f":"AR28/AR33","v":"25.3011"},{"$f":"AS28/AS33","v":"227.9937"},{"$f":"AT28/AT33","v":"171.6447"},{"$f":"AU28/AU33","v":"0"},{"$f":"AV28/AV33","v":"80.502"},{"$f":"AW28/AW33","v":"0"},{"$f":"AX28/AX33","v":"0"},{"$f":"AY28/AY33","v":"0"},{"$f":"AZ28/AZ33","v":"158.9299"},{"$f":"BA28/BA33","v":"0"},{"$f":"BB28/BB33","v":"194.8339"},{"$f":"BC28/BC33","v":"284.333"},{"$f":"BD28/BD33","v":"169.6974"},{"$f":"BE28/BE33","v":"61.7158"},{"$f":"BF28/BF33","v":"163.0177"},{"$f":"BG28/BG33","v":"0"},{"$f":"BH28/BH33","v":"0"},{"$f":"BI28/BI33","v":"1.0291"},{"$f":"BJ28/BJ33","v":"0"},{"$f":"BK28/BK33","v":"0"},{"$f":"BL28/BL33","v":"0"},{"$f":"BM28/BM33","v":"94.49"},{"$f":"BN28/BN33","v":"27.4239"},{"$f":"BO28/BO33","v":"0"},{"$f":"BP28/BP33","v":"38.7306"},{"$f":"BQ28/BQ33","v":"90.5071"},{"$f":"BR28/BR33","v":"16.9329"},{"$f":"BS28/BS33","v":"328.9603"},{"$f":"BT28/BT33","v":"125.5651"},{"$f":"BU28/BU33","v":"108.6508"},{"$f":"BV28/BV33","v":"174.5648"},{"$f":"BW28/BW33","v":"245.3655"},{"$f":"BX28/BX33","v":"155.6526"},{"$f":"BY28/BY33","v":"145.023"},{"$f":"BZ28/BZ33","v":"217.7617"},{"$f":"CA28/CA33","v":"111.0011"},{"$f":"CB28/CB33","v":"85.974"},{"$f":"CC28/CC33","v":"116.4911"},{"$f":"CD28/CD33","v":"100.536"},{"$f":"CE28/CE33","v":"153.9571"},{"$f":"CF28/CF33","v":"74.7934"}]
[null,"2.16","Cost Sharing Reduction",{"$f":"D29/D33","v":"$0.00"},{"$f":"E29/E33","v":"0"},{"$f":"F29/F33","v":"0"},{"$f":"G29/G33","v":"0"},{"$f":"H29/H33","v":"0"},{"$f":"I29/I33","v":"0"},{"$f":"J29/J33","v":"0"},{"$f":"K29/K33","v":"0"},{"$f":"L29/L33","v":"0"},{"$f":"M29/M33","v":"0"},{"$f":"N29/N33","v":"0"},{"$f":"O29/O33","v":"0"},{"$f":"P29/P33","v":"0"},{"$f":"Q29/Q33","v":"0"},{"$f":"R29/R33","v":"0"},{"$f":"S29/S33","v":"0"},{"$f":"T29/T33","v":"0"},{"$f":"U29/U33","v":"0"},{"$f":"V29/V33","v":"0"},{"$f":"W29/W33","v":"0"},{"$f":"X29/X33","v":"0"},{"$f":"Y29/Y33","v":"0"},{"$f":"Z29/Z33","v":"0"},{"$f":"AA29/AA33","v":"0"},{"$f":"AB29/AB33","v":"0"},{"$f":"AC29/AC33","v":"0"},{"$f":"AD29/AD33","v":"0"},{"$f":"AE29/AE33","v":"0"},{"$f":"AF29/AF33","v":"0"},{"$f":"AG29/AG33","v":"0"},{"$f":"AH29/AH33","v":"0"},{"$f":"AI29/AI33","v":"0"},{"$f":"AJ29/AJ33","v":"0"},{"$f":"AK29/AK33","v":"0"},{"$f":"AL29/AL33","v":"0"},{"$f":"AM29/AM33","v":"0"},{"$f":"AN29/AN33","v":"0"},{"$f":"AO29/AO33","v":"0"},{"$f":"AP29/AP33","v":"0"},{"$f":"AQ29/AQ33","v":"0"},{"$f":"AR29/AR33","v":"0"},{"$f":"AS29/AS33","v":"0"},{"$f":"AT29/AT33","v":"0"},{"$f":"AU29/AU33","v":"0"},{"$f":"AV29/AV33","v":"0"},{"$f":"AW29/AW33","v":"0"},{"$f":"AX29/AX33","v":"0"},{"$f":"AY29/AY33","v":"0"},{"$f":"AZ29/AZ33","v":"0"},{"$f":"BA29/BA33","v":"0"},{"$f":"BB29/BB33","v":"0"},{"$f":"BC29/BC33","v":"0"},{"$f":"BD29/BD33","v":"0"},{"$f":"BE29/BE33","v":"0"},{"$f":"BF29/BF33","v":"0"},{"$f":"BG29/BG33","v":"0"},{"$f":"BH29/BH33","v":"0"},{"$f":"BI29/BI33","v":"0"},{"$f":"BJ29/BJ33","v":"0"},{"$f":"BK29/BK33","v":"0"},{"$f":"BL29/BL33","v":"0"},{"$f":"BM29/BM33","v":"0"},{"$f":"BN29/BN33","v":"0"},{"$f":"BO29/BO33","v":"0"},{"$f":"BP29/BP33","v":"0"},{"$f":"BQ29/BQ33","v":"0"},{"$f":"BR29/BR33","v":"0"},{"$f":"BS29/BS33","v":"0"},{"$f":"BT29/BT33","v":"0"},{"$f":"BU29/BU33","v":"0"},{"$f":"BV29/BV33","v":"0"},{"$f":"BW29/BW33","v":"0"},{"$f":"BX29/BX33","v":"0"},{"$f":"BY29/BY33","v":"0"},{"$f":"BZ29/BZ33","v":"0"},{"$f":"CA29/CA33","v":"0"},{"$f":"CB29/CB33","v":"0"},{"$f":"CC29/CC33","v":"0"},{"$f":"CD29/CD33","v":"0"},{"$f":"CE29/CE33","v":"0"},{"$f":"CF29/CF33","v":"0"}]
[null,"2.17","Incurred Claims",{"$f":"D30/D33","v":"$661.37"},{"$f":"E30/E33","v":"553.4067"},{"$f":"F30/F33","v":"654.1005"},{"$f":"G30/G33","v":"617.5098"},{"$f":"H30/H33","v":"542.1354"},{"$f":"I30/I33","v":"993.6717"},{"$f":"J30/J33","v":"679.0151"},{"$f":"K30/K33","v":"717.1276"},{"$f":"L30/L33","v":"795.3749"},{"$f":"M30/M33","v":"575.8476"},{"$f":"N30/N33","v":"871.9505"},{"$f":"O30/O33","v":"799.5834"},{"$f":"P30/P33","v":"498.4"},{"$f":"Q30/Q33","v":"-12.2206"},{"$f":"R30/R33","v":"268.7749"},{"$f":"S30/S33","v":"767.622"},{"$f":"T30/T33","v":"0"},{"$f":"U30/U33","v":"910.7348"},{"$f":"V30/V33","v":"650.2587"},{"$f":"W30/W33","v":"634.8543"},{"$f":"X30/X33","v":"1177.3764"},{"$f":"Y30/Y33","v":"314.3541"},{"$f":"Z30/Z33","v":"1239.2189"},{"$f":"AA30/AA33","v":"1335.3115"},{"$f":"AB30/AB33","v":"451.8266"},{"$f":"AC30/AC33","v":"295.897"},{"$f":"AD30/AD33","v":"0"},{"$f":"AE30/AE33","v":"544.9158"},{"$f":"AF30/AF33","v":"0"},{"$f":"AG30/AG33","v":"745.6085"},{"$f":"AH30/AH33","v":"0"},{"$f":"AI30/AI33","v":"0"},{"$f":"AJ30/AJ33","v":"267.1208"},{"$f":"AK30/AK33","v":"0"},{"$f":"AL30/AL33","v":"0"},{"$f":"AM30/AM33","v":"286.3042"},{"$f":"AN30/AN33","v":"756.462"},{"$f":"AO30/AO33","v":"1064.9949"},{"$f":"AP30/AP33","v":"0"},{"$f":"AQ30/AQ33","v":"419.583"},{"$f":"AR30/AR33","v":"109.8544"},{"$f":"AS30/AS33","v":"686.3578"},{"$f":"AT30/AT33","v":"592.527"},{"$f":"AU30/AU33","v":"0"},{"$f":"AV30/AV33","v":"95.4857"},{"$f":"AW30/AW33","v":"0"},{"$f":"AX30/AX33","v":"0"},{"$f":"AY30/AY33","v":"0"},{"$f":"AZ30/AZ33","v":"487.6913"},{"$f":"BA30/BA33","v":"0"},{"$f":"BB30/BB33","v":"103.7637"},{"$f":"BC30/BC33","v":"611.3067"},{"$f":"BD30/BD33","v":"316.3399"},{"$f":"BE30/BE33","v":"218.0904"},{"$f":"BF30/BF33","v":"297.129"},{"$f":"BG30/BG33","v":"0"},{"$f":"BH30/BH33","v":"0"},{"$f":"BI30/BI33","v":"-38.9827"},{"$f":"BJ30/BJ33","v":"0"},{"$f":"BK30/BK33","v":"0"},{"$f":"BL30/BL33","v":"0"},{"$f":"BM30/BM33","v":"135.5982"},{"$f":"BN30/BN33","v":"215.6406"},{"$f":"BO30/BO33","v":"0"},{"$f":"BP30/BP33","v":"166.3635"},{"$f":"BQ30/BQ33","v":"843.4869"},{"$f":"BR30/BR33","v":"-19.8807"},{"$f":"BS30/BS33","v":"61.4455"},{"$f":"BT30/BT33","v":"171.5583"},{"$f":"BU30/BU33","v":"-29.9206"},{"$f":"BV30/BV33","v":"327.9953"},{"$f":"BW30/BW33","v":"-39.835"},{"$f":"BX30/BX33","v":"327.4171"},{"$f":"BY30/BY33","v":"602.0667"},{"$f":"BZ30/BZ33","v":"1801.9856"},{"$f":"CA30/CA33","v":"369.95"},{"$f":"CB30/CB33","v":"508.3681"},{"$f":"CC30/CC33","v":"603.0044"},{"$f":"CD30/CD33","v":"385.5594"},{"$f":"CE30/CE33","v":"1167.2503"},{"$f":"CF30/CF33","v":"80.2111"}]
[null,"2.18","Risk Adjustment Transfer Amount",{"$f":"D31/D33","v":"$11.57"},{"$f":"E31/E33","v":"0"},{"$f":"F31/F33","v":"2.5496"},{"$f":"G31/G33","v":"172.4343"},{"$f":"H31/H33","v":"47.4519"},{"$f":"I31/I33","v":"55.8432"},{"$f":"J31/J33","v":"33.2902"},{"$f":"K31/K33","v":"-2.1016"},{"$f":"L31/L33","v":"-18.5941"},{"$f":"M31/M33","v":"-75.2776"},{"$f":"N31/N33","v":"22.8429"},{"$f":"O31/O33","v":"29.405"},{"$f":"P31/P33","v":"50.6489"},{"$f":"Q31/Q33","v":"-95.6622"},{"$f":"R31/R33","v":"39.4975"},{"$f":"S31/S33","v":"181.3224"},{"$f":"T31/T33","v":"0"},{"$f":"U31/U33","v":"172.4483"},{"$f":"V31/V33","v":"-64.9752"},{"$f":"W31/W33","v":"26.1216"},{"$f":"X31/X33","v":"105.8038"},{"$f":"Y31/Y33","v":"-264.7331"},{"$f":"Z31/Z33","v":"716.0378"},{"$f":"AA31/AA33","v":"-73.2827"},{"$f":"AB31/AB33","v":"-51.3748"},{"$f":"AC31/AC33","v":"-47.6505"},{"$f":"AD31/AD33","v":"0"},{"$f":"AE31/AE33","v":"-207.4369"},{"$f":"AF31/AF33","v":"0"},{"$f":"AG31/AG33","v":"199.1447"},{"$f":"AH31/AH33","v":"0"},{"$f":"AI31/AI33","v":"0"},{"$f":"AJ31/AJ33","v":"-335.1552"},{"$f":"AK31/AK33","v":"0"},{"$f":"AL31/AL33","v":"0"},{"$f":"AM31/AM33","v":"-86.3914"},{"$f":"AN31/AN33","v":"95.6019"},{"$f":"AO31/AO33","v":"163.648"},{"$f":"AP31/AP33","v":"0"},{"$f":"AQ31/AQ33","v":"-115.0245"},{"$f":"AR31/AR33","v":"-660.594"},{"$f":"AS31/AS33","v":"283.1646"},{"$f":"AT31/AT33","v":"310.4535"},{"$f":"AU31/AU33","v":"0"},{"$f":"AV31/AV33","v":"-245.5127"},{"$f":"AW31/AW33","v":"0"},{"$f":"AX31/AX33","v":"0"},{"$f":"AY31/AY33","v":"0"},{"$f":"AZ31/AZ33","v":"-301.8578"},{"$f":"BA31/BA33","v":"0"},{"$f":"BB31/BB33","v":"-215.3113"},{"$f":"BC31/BC33","v":"-125.177"},{"$f":"BD31/BD33","v":"-261.4926"},{"$f":"BE31/BE33","v":"-282.0674"},{"$f":"BF31/BF33","v":"-376.8723"},{"$f":"BG31/BG33","v":"0"},{"$f":"BH31/BH33","v":"0"},{"$f":"BI31/BI33","v":"-389.3191"},{"$f":"BJ31/BJ33","v":"0"},{"$f":"BK31/BK33","v":"0"},{"$f":"BL31/BL33","v":"0"},{"$f":"BM31/BM33","v":"-466.4108"},{"$f":"BN31/BN33","v":"-348.8283"},{"$f":"BO31/BO33","v":"0"},{"$f":"BP31/BP33","v":"25.9684"},{"$f":"BQ31/BQ33","v":"-143.2772"},{"$f":"BR31/BR33","v":"-917.2271"},{"$f":"BS31/BS33","v":"-198.6046"},{"$f":"BT31/BT33","v":"-276.7086"},{"$f":"BU31/BU33","v":"-531.1177"},{"$f":"BV31/BV33","v":"-61.0468"},{"$f":"BW31/BW33","v":"190.411"},{"$f":"BX31/BX33","v":"-359.529"},{"$f":"BY31/BY33","v":"12.9285"},{"$f":"BZ31/BZ33","v":"81.0262"},{"$f":"CA31/CA33","v":"-304.5063"},{"$f":"CB31/CB33","v":"-232.536"},{"$f":"CC31/CC33","v":"199.735"},{"$f":"CD31/CD33","v":"-81.2351"},{"$f":"CE31/CE33","v":"13.4268"},{"$f":"CF31/CF33","v":"-377.1213"}]
[null,"2.19","Premium",{"$f":"D32/D33","v":"$748.02"},{"$f":"E32/E33","v":"701.958"},{"$f":"F32/F33","v":"665.5279"},{"$f":"G32/G33","v":"759.7885"},{"$f":"H32/H33","v":"679.1118"},{"$f":"I32/I33","v":"668.6841"},{"$f":"J32/J33","v":"813.7823"},{"$f":"K32/K33","v":"795.0746"},{"$f":"L32/L33","v":"852.106"},{"$f":"M32/M33","v":"824.6851"},{"$f":"N32/N33","v":"787.8514"},{"$f":"O32/O33","v":"818.2988"},{"$f":"P32/P33","v":"639.7217"},{"$f":"Q32/Q33","v":"612.4753"},{"$f":"R32/R33","v":"622.9281"},{"$f":"S32/S33","v":"858.5857"},{"$f":"T32/T33","v":"0"},{"$f":"U32/U33","v":"688.4774"},{"$f":"V32/V33","v":"717.6585"},{"$f":"W32/W33","v":"725.655"},{"$f":"X32/X33","v":"618.551"},{"$f":"Y32/Y33","v":"563.3449"},{"$f":"Z32/Z33","v":"610.1349"},{"$f":"AA32/AA33","v":"979.0572"},{"$f":"AB32/AB33","v":"704.1496"},{"$f":"AC32/AC33","v":"783.6076"},{"$f":"AD32/AD33","v":"0"},{"$f":"AE32/AE33","v":"798.3496"},{"$f":"AF32/AF33","v":"0"},{"$f":"AG32/AG33","v":"775.7737"},{"$f":"AH32/AH33","v":"0"},{"$f":"AI32/AI33","v":"0"},{"$f":"AJ32/AJ33","v":"786.2144"},{"$f":"AK32/AK33","v":"0"},{"$f":"AL32/AL33","v":"0"},{"$f":"AM32/AM33","v":"866.8129"},{"$f":"AN32/AN33","v":"952.6581"},{"$f":"AO32/AO33","v":"943.9351"},{"$f":"AP32/AP33","v":"0"},{"$f":"AQ32/AQ33","v":"612.4989"},{"$f":"AR32/AR33","v":"1107.1129"},{"$f":"AS32/AS33","v":"580.9274"},{"$f":"AT32/AT33","v":"723.0807"},{"$f":"AU32/AU33","v":"0"},{"$f":"AV32/AV33","v":"511.4145"},{"$f":"AW32/AW33","v":"0"},{"$f":"AX32/AX33","v":"0"},{"$f":"AY32/AY33","v":"0"},{"$f":"AZ32/AZ33","v":"684.118"},{"$f":"BA32/BA33","v":"0"},{"$f":"BB32/BB33","v":"535.6232"},{"$f":"BC32/BC33","v":"625.4922"},{"$f":"BD32/BD33","v":"692.6082"},{"$f":"BE32/BE33","v":"498.5636"},{"$f":"BF32/BF33","v":"708.4538"},{"$f":"BG32/BG33","v":"0"},{"$f":"BH32/BH33","v":"0"},{"$f":"BI32/BI33","v":"415.4327"},{"$f":"BJ32/BJ33","v":"0"},{"$f":"BK32/BK33","v":"0"},{"$f":"BL32/BL33","v":"0"},{"$f":"BM32/BM33","v":"608.8987"},{"$f":"BN32/BN33","v":"527.9506"},{"$f":"BO32/BO33","v":"0"},{"$f":"BP32/BP33","v":"682.4864"},{"$f":"BQ32/BQ33","v":"961.8783"},{"$f":"BR32/BR33","v":"1189.5171"},{"$f":"BS32/BS33","v":"534.1574"},{"$f":"BT32/BT33","v":"447.7988"},{"$f":"BU32/BU33","v":"619.6271"},{"$f":"BV32/BV33","v":"637.8741"},{"$f":"BW32/BW33","v":"378.7285"},{"$f":"BX32/BX33","v":"615.7503"},{"$f":"BY32/BY33","v":"551.9009"},{"$f":"BZ32/BZ33","v":"889.162"},{"$f":"CA32/CA33","v":"728.4857"},{"$f":"CB32/CB33","v":"651.3154"},{"$f":"CC32/CC33","v":"618.2532"},{"$f":"CD32/CD33","v":"707.7529"},{"$f":"CE32/CE33","v":"656.0359"},{"$f":"CF32/CF33","v":"686.0134"}]
[]
[null,null,"Section III: Plan Adjustment Factors"]
[null,"3.1","Plan ID (Standard Component ID)",null,{"$f":"IF(E13<>\"\",E13,\"\")","v":"36239KY0470001"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"36239KY0980052"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"36239KY0980051"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"36239KY0980054"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"36239KY0980053"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"36239KY0980047"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"36239KY0980049"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"36239KY0980045"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"36239KY0980046"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"36239KY0980050"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"36239KY0980048"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"36239KY0990238"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"36239KY0990273"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"36239KY0990274"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"36239KY0990263"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"36239KY0990284"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"36239KY0990257"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"36239KY0990260"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"36239KY0990220"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"36239KY0990269"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"36239KY0990265"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"36239KY0990272"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"36239KY0990271"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"36239KY0990262"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"36239KY0990261"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"36239KY0990282"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"36239KY0990237"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"36239KY0990283"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"36239KY0990275"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"36239KY0990286"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"36239KY0990285"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"36239KY0990278"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"36239KY0990289"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"36239KY0990287"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"36239KY0990281"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"36239KY0990242"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"36239KY0990190"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"36239KY0990288"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"36239KY0990276"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"36239KY0990277"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"36239KY0990270"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"36239KY0990266"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"36239KY1170130"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"36239KY1170073"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"36239KY1170129"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"36239KY1170127"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"36239KY1170138"},{"$f":"IF(AZ13<>\"\",AZ13,\"\")","v":"36239KY1170115"},{"$f":"IF(BA13<>\"\",BA13,\"\")","v":"36239KY1170128"},{"$f":"IF(BB13<>\"\",BB13,\"\")","v":"36239KY1170131"},{"$f":"IF(BC13<>\"\",BC13,\"\")","v":"36239KY1170122"},{"$f":"IF(BD13<>\"\",BD13,\"\")","v":"36239KY1170117"},{"$f":"IF(BE13<>\"\",BE13,\"\")","v":"36239KY1170120"},{"$f":"IF(BF13<>\"\",BF13,\"\")","v":"36239KY1170056"},{"$f":"IF(BG13<>\"\",BG13,\"\")","v":"36239KY1170118"},{"$f":"IF(BH13<>\"\",BH13,\"\")","v":"36239KY1170141"},{"$f":"IF(BI13<>\"\",BI13,\"\")","v":"36239KY1170125"},{"$f":"IF(BJ13<>\"\",BJ13,\"\")","v":"36239KY1170139"},{"$f":"IF(BK13<>\"\",BK13,\"\")","v":"36239KY1170137"},{"$f":"IF(BL13<>\"\",BL13,\"\")","v":"36239KY1170142"},{"$f":"IF(BM13<>\"\",BM13,\"\")","v":"36239KY1170119"},{"$f":"IF(BN13<>\"\",BN13,\"\")","v":"36239KY1170136"},{"$f":"IF(BO13<>\"\",BO13,\"\")","v":"36239KY1170140"},{"$f":"IF(BP13<>\"\",BP13,\"\")","v":"36239KY1170037"},{"$f":"IF(BQ13<>\"\",BQ13,\"\")","v":"36239KY1170075"},{"$f":"IF(BR13<>\"\",BR13,\"\")","v":"36239KY1170135"},{"$f":"IF(BS13<>\"\",BS13,\"\")","v":"36239KY1170132"},{"$f":"IF(BT13<>\"\",BT13,\"\")","v":"36239KY1170126"},{"$f":"IF(BU13<>\"\",BU13,\"\")","v":"36239KY1170123"},{"$f":"IF(BV13<>\"\",BV13,\"\")","v":"36239KY1180034"},{"$f":"IF(BW13<>\"\",BW13,\"\")","v":"36239KY1180035"},{"$f":"IF(BX13<>\"\",BX13,\"\")","v":"36239KY1180033"},{"$f":"IF(BY13<>\"\",BY13,\"\")","v":"36239KY1180036"},{"$f":"IF(BZ13<>\"\",BZ13,\"\")","v":"36239KY1180028"},{"$f":"IF(CA13<>\"\",CA13,\"\")","v":"36239KY1180030"},{"$f":"IF(CB13<>\"\",CB13,\"\")","v":"36239KY1180037"},{"$f":"IF(CC13<>\"\",CC13,\"\")","v":"36239KY1180031"},{"$f":"IF(CD13<>\"\",CD13,\"\")","v":"36239KY1180029"},{"$f":"IF(CE13<>\"\",CE13,\"\")","v":"36239KY1180032"},{"$f":"IF(CF13<>\"\",CF13,\"\")","v":"36239KY1200005"}]
[null,"3.2","Market Adjusted Index Rate",null,"$1,152.56"]
[null,"3.3","AV and Cost Sharing Design of Plan",null,0.0,0.7461,0.7628,0.7273,0.7314,0.8642,0.8572,0.865,0.8651,0.8428,0.8668,0.6588,0.7151,0.6998,0.7696,0.8061,0.743,0.7733,0.7493,0.7422,0.7281,0.732,0.7629,0.8654,0.8433,0.8502,0.8642,0.8671,0.7913,0.8533,0.8347,0.8443,0.9414,0.9128,0.987,1.0018,0.9992,0.9878,0.0,0.0,0.0,0.0,0.6998,0.6588,0.7151,0.7629,0.8061,0.743,0.7319,0.7422,0.728,0.7733,0.7696,0.7492,0.8654,0.8533,0.7913,0.8671,0.8502,0.8642,0.8432,0.8443,0.8347,0.9991,1.0017,0.987,0.0,0.0,0.0,0.7461,0.7314,0.7628,0.7273,0.865,0.8668,0.8642,0.8572,0.8651,0.8427,0.0]
[null,"3.4","Provider Network Adjustment",null,0.0,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,0.0,0.0,0.0,0.0,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.0,0.0,0.0,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.8701,0.0]
[null,"3.5","Benefits in Addition to EHB",null,0.0,1.0046,1.0045,1.0047,1.0047,1.004,1.004,1.004,1.004,1.0041,1.0039,1.0052,1.0048,1.0049,1.0044,1.0042,1.0046,1.0044,1.0046,1.0046,1.0146,1.0047,1.0045,1.0122,1.0126,1.004,1.004,1.0039,1.0043,1.004,1.0041,1.004,1.0045,1.0046,1.0035,1.0034,1.0034,1.0043,0.0,0.0,0.0,0.0,1.0049,1.0052,1.0048,1.0045,1.0042,1.0046,1.0046,1.0046,1.0145,1.0044,1.0044,1.0045,1.0122,1.004,1.0043,1.0039,1.004,1.0039,1.0125,1.004,1.0041,1.0034,1.0034,1.0034,0.0,0.0,0.0,1.0046,1.0046,1.0045,1.0047,1.0039,1.0039,1.0039,1.004,1.0039,1.004,0.0]
[null,null,"Administrative Costs"]
[null,"3.6","Administrative Expense",null,0.0,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0,0.0,0.0,0.0,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0,0.0,0.0,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0494,0.0]
[null,"3.7","Taxes and Fees",null,0.0,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0,0.0,0.0,0.0,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0,0.0,0.0,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0281,0.0]
[null,"3.8","Profit & Risk Load",null,0.0,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0,0.0,0.0,0.0,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0,0.0,0.0,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0474,0.0]
[null,"3.9","Catastrophic Adjustment",null,0.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,0.0,0.0,0.0,0.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,0.0,0.0,0.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,0.0]
[null,"3.10","Plan Adjusted Index Rate",null,{"$f":"($E$48*PRODUCT(E49:E51)*E56)/(1-SUM(E53:E55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(F49:F51)*F56)/(1-SUM(F53:F55))","v":"$995.47"},{"$f":"($E$48*PRODUCT(G49:G51)*G56)/(1-SUM(G53:G55))","v":"$1,017.65"},{"$f":"($E$48*PRODUCT(H49:H51)*H56)/(1-SUM(H53:H55))","v":"$970.49"},{"$f":"($E$48*PRODUCT(I49:I51)*I56)/(1-SUM(I53:I55))","v":"$975.96"},{"$f":"($E$48*PRODUCT(J49:J51)*J56)/(1-SUM(J53:J55))","v":"$1,152.36"},{"$f":"($E$48*PRODUCT(K49:K51)*K56)/(1-SUM(K53:K55))","v":"$1,143.03"},{"$f":"($E$48*PRODUCT(L49:L51)*L56)/(1-SUM(L53:L55))","v":"$1,153.43"},{"$f":"($E$48*PRODUCT(M49:M51)*M56)/(1-SUM(M53:M55))","v":"$1,153.56"},{"$f":"($E$48*PRODUCT(N49:N51)*N56)/(1-SUM(N53:N55))","v":"$1,123.94"},{"$f":"($E$48*PRODUCT(O49:O51)*O56)/(1-SUM(O53:O55))","v":"$1,155.71"},{"$f":"($E$48*PRODUCT(P49:P51)*P56)/(1-SUM(P53:P55))","v":"$879.52"},{"$f":"($E$48*PRODUCT(Q49:Q51)*Q56)/(1-SUM(Q53:Q55))","v":"$954.30"},{"$f":"($E$48*PRODUCT(R49:R51)*R56)/(1-SUM(R53:R55))","v":"$933.98"},{"$f":"($E$48*PRODUCT(S49:S51)*S56)/(1-SUM(S53:S55))","v":"$1,026.62"},{"$f":"($E$48*PRODUCT(T49:T51)*T56)/(1-SUM(T53:T55))","v":"$1,075.10"},{"$f":"($E$48*PRODUCT(U49:U51)*U56)/(1-SUM(U53:U55))","v":"$991.34"},{"$f":"($E$48*PRODUCT(V49:V51)*V56)/(1-SUM(V53:V55))","v":"$1,031.56"},{"$f":"($E$48*PRODUCT(W49:W51)*W56)/(1-SUM(W53:W55))","v":"$999.74"},{"$f":"($E$48*PRODUCT(X49:X51)*X56)/(1-SUM(X53:X55))","v":"$990.27"},{"$f":"($E$48*PRODUCT(Y49:Y51)*Y56)/(1-SUM(Y53:Y55))","v":"$981.13"},{"$f":"($E$48*PRODUCT(Z49:Z51)*Z56)/(1-SUM(Z53:Z55))","v":"$976.76"},{"$f":"($E$48*PRODUCT(AA49:AA51)*AA56)/(1-SUM(AA53:AA55))","v":"$1,017.79"},{"$f":"($E$48*PRODUCT(AB49:AB51)*AB56)/(1-SUM(AB53:AB55))","v":"$1,163.38"},{"$f":"($E$48*PRODUCT(AC49:AC51)*AC56)/(1-SUM(AC53:AC55))","v":"$1,134.12"},{"$f":"($E$48*PRODUCT(AD49:AD51)*AD56)/(1-SUM(AD53:AD55))","v":"$1,133.69"},{"$f":"($E$48*PRODUCT(AE49:AE51)*AE56)/(1-SUM(AE53:AE55))","v":"$1,152.36"},{"$f":"($E$48*PRODUCT(AF49:AF51)*AF56)/(1-SUM(AF53:AF55))","v":"$1,156.11"},{"$f":"($E$48*PRODUCT(AG49:AG51)*AG56)/(1-SUM(AG53:AG55))","v":"$1,055.47"},{"$f":"($E$48*PRODUCT(AH49:AH51)*AH56)/(1-SUM(AH53:AH55))","v":"$1,137.82"},{"$f":"($E$48*PRODUCT(AI49:AI51)*AI56)/(1-SUM(AI53:AI55))","v":"$1,113.13"},{"$f":"($E$48*PRODUCT(AJ49:AJ51)*AJ56)/(1-SUM(AJ53:AJ55))","v":"$1,125.82"},{"$f":"($E$48*PRODUCT(AK49:AK51)*AK56)/(1-SUM(AK53:AK55))","v":"$1,255.93"},{"$f":"($E$48*PRODUCT(AL49:AL51)*AL56)/(1-SUM(AL53:AL55))","v":"$1,217.89"},{"$f":"($E$48*PRODUCT(AM49:AM51)*AM56)/(1-SUM(AM53:AM55))","v":"$1,315.45"},{"$f":"($E$48*PRODUCT(AN49:AN51)*AN56)/(1-SUM(AN53:AN55))","v":"$1,335.04"},{"$f":"($E$48*PRODUCT(AO49:AO51)*AO56)/(1-SUM(AO53:AO55))","v":"$1,331.58"},{"$f":"($E$48*PRODUCT(AP49:AP51)*AP56)/(1-SUM(AP53:AP55))","v":"$1,317.57"},{"$f":"($E$48*PRODUCT(AQ49:AQ51)*AQ56)/(1-SUM(AQ53:AQ55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AR49:AR51)*AR56)/(1-SUM(AR53:AR55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AS49:AS51)*AS56)/(1-SUM(AS53:AS55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AT49:AT51)*AT56)/(1-SUM(AT53:AT55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AU49:AU51)*AU56)/(1-SUM(AU53:AU55))","v":"$805.88"},{"$f":"($E$48*PRODUCT(AV49:AV51)*AV56)/(1-SUM(AV53:AV55))","v":"$758.90"},{"$f":"($E$48*PRODUCT(AW49:AW51)*AW56)/(1-SUM(AW53:AW55))","v":"$823.42"},{"$f":"($E$48*PRODUCT(AX49:AX51)*AX56)/(1-SUM(AX53:AX55))","v":"$878.20"},{"$f":"($E$48*PRODUCT(AY49:AY51)*AY56)/(1-SUM(AY53:AY55))","v":"$927.65"},{"$f":"($E$48*PRODUCT(AZ49:AZ51)*AZ56)/(1-SUM(AZ53:AZ55))","v":"$855.38"},{"$f":"($E$48*PRODUCT(BA49:BA51)*BA56)/(1-SUM(BA53:BA55))","v":"$842.60"},{"$f":"($E$48*PRODUCT(BB49:BB51)*BB56)/(1-SUM(BB53:BB55))","v":"$854.46"},{"$f":"($E$48*PRODUCT(BC49:BC51)*BC56)/(1-SUM(BC53:BC55))","v":"$846.37"},{"$f":"($E$48*PRODUCT(BD49:BD51)*BD56)/(1-SUM(BD53:BD55))","v":"$890.08"},{"$f":"($E$48*PRODUCT(BE49:BE51)*BE56)/(1-SUM(BE53:BE55))","v":"$885.83"},{"$f":"($E$48*PRODUCT(BF49:BF51)*BF56)/(1-SUM(BF53:BF55))","v":"$862.43"},{"$f":"($E$48*PRODUCT(BG49:BG51)*BG56)/(1-SUM(BG53:BG55))","v":"$1,003.83"},{"$f":"($E$48*PRODUCT(BH49:BH51)*BH56)/(1-SUM(BH53:BH55))","v":"$981.77"},{"$f":"($E$48*PRODUCT(BI49:BI51)*BI56)/(1-SUM(BI53:BI55))","v":"$910.71"},{"$f":"($E$48*PRODUCT(BJ49:BJ51)*BJ56)/(1-SUM(BJ53:BJ55))","v":"$997.55"},{"$f":"($E$48*PRODUCT(BK49:BK51)*BK56)/(1-SUM(BK53:BK55))","v":"$978.21"},{"$f":"($E$48*PRODUCT(BL49:BL51)*BL56)/(1-SUM(BL53:BL55))","v":"$994.22"},{"$f":"($E$48*PRODUCT(BM49:BM51)*BM56)/(1-SUM(BM53:BM55))","v":"$978.37"},{"$f":"($E$48*PRODUCT(BN49:BN51)*BN56)/(1-SUM(BN53:BN55))","v":"$971.42"},{"$f":"($E$48*PRODUCT(BO49:BO51)*BO56)/(1-SUM(BO53:BO55))","v":"$960.47"},{"$f":"($E$48*PRODUCT(BP49:BP51)*BP56)/(1-SUM(BP53:BP55))","v":"$1,148.84"},{"$f":"($E$48*PRODUCT(BQ49:BQ51)*BQ56)/(1-SUM(BQ53:BQ55))","v":"$1,151.83"},{"$f":"($E$48*PRODUCT(BR49:BR51)*BR56)/(1-SUM(BR53:BR55))","v":"$1,134.93"},{"$f":"($E$48*PRODUCT(BS49:BS51)*BS56)/(1-SUM(BS53:BS55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BT49:BT51)*BT56)/(1-SUM(BT53:BT55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BU49:BU51)*BU56)/(1-SUM(BU53:BU55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BV49:BV51)*BV56)/(1-SUM(BV53:BV55))","v":"$858.95"},{"$f":"($E$48*PRODUCT(BW49:BW51)*BW56)/(1-SUM(BW53:BW55))","v":"$842.02"},{"$f":"($E$48*PRODUCT(BX49:BX51)*BX56)/(1-SUM(BX53:BX55))","v":"$878.09"},{"$f":"($E$48*PRODUCT(BY49:BY51)*BY56)/(1-SUM(BY53:BY55))","v":"$837.39"},{"$f":"($E$48*PRODUCT(BZ49:BZ51)*BZ56)/(1-SUM(BZ53:BZ55))","v":"$995.14"},{"$f":"($E$48*PRODUCT(CA49:CA51)*CA56)/(1-SUM(CA53:CA55))","v":"$997.21"},{"$f":"($E$48*PRODUCT(CB49:CB51)*CB56)/(1-SUM(CB53:CB55))","v":"$994.22"},{"$f":"($E$48*PRODUCT(CC49:CC51)*CC56)/(1-SUM(CC53:CC55))","v":"$986.26"},{"$f":"($E$48*PRODUCT(CD49:CD51)*CD56)/(1-SUM(CD53:CD55))","v":"$995.25"},{"$f":"($E$48*PRODUCT(CE49:CE51)*CE56)/(1-SUM(CE53:CE55))","v":"$969.58"},{"$f":"($E$48*PRODUCT(CF49:CF51)*CF56)/(1-SUM(CF53:CF55))","v":"$0.00"}]
[]
[null,"3.11","Age Calibration Factor","0.6739",{"$f":"IF(D59<>\"\", D59, \"\")","v":"0.6739"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000"]
[null,"3.12","Geographic Calibration Factor","0.9999",{"$f":"IF(D60<>\"\", D60, \"\")","v":"0.9999"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000"]
[null,"3.13","Tobacco Calibration Factor","1.0000",{"$f":"IF(D61<>\"\", D61, \"\")","v":"1.0000"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000"]
[null,"3.14","Calibrated Plan Adjusted Index Rate",null,{"$f":"E57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"F57*(PRODUCT($E$59:$E$61))","v":"$670.83"},{"$f":"G57*(PRODUCT($E$59:$E$61))","v":"$685.78"},{"$f":"H57*(PRODUCT($E$59:$E$61))","v":"$653.99"},{"$f":"I57*(PRODUCT($E$59:$E$61))","v":"$657.68"},{"$f":"J57*(PRODUCT($E$59:$E$61))","v":"$776.55"},{"$f":"K57*(PRODUCT($E$59:$E$61))","v":"$770.26"},{"$f":"L57*(PRODUCT($E$59:$E$61))","v":"$777.27"},{"$f":"M57*(PRODUCT($E$59:$E$61))","v":"$777.36"},{"$f":"N57*(PRODUCT($E$59:$E$61))","v":"$757.40"},{"$f":"O57*(PRODUCT($E$59:$E$61))","v":"$778.81"},{"$f":"P57*(PRODUCT($E$59:$E$61))","v":"$592.69"},{"$f":"Q57*(PRODUCT($E$59:$E$61))","v":"$643.08"},{"$f":"R57*(PRODUCT($E$59:$E$61))","v":"$629.39"},{"$f":"S57*(PRODUCT($E$59:$E$61))","v":"$691.82"},{"$f":"T57*(PRODUCT($E$59:$E$61))","v":"$724.49"},{"$f":"U57*(PRODUCT($E$59:$E$61))","v":"$668.04"},{"$f":"V57*(PRODUCT($E$59:$E$61))","v":"$695.15"},{"$f":"W57*(PRODUCT($E$59:$E$61))","v":"$673.71"},{"$f":"X57*(PRODUCT($E$59:$E$61))","v":"$667.32"},{"$f":"Y57*(PRODUCT($E$59:$E$61))","v":"$661.16"},{"$f":"Z57*(PRODUCT($E$59:$E$61))","v":"$658.22"},{"$f":"AA57*(PRODUCT($E$59:$E$61))","v":"$685.87"},{"$f":"AB57*(PRODUCT($E$59:$E$61))","v":"$783.98"},{"$f":"AC57*(PRODUCT($E$59:$E$61))","v":"$764.26"},{"$f":"AD57*(PRODUCT($E$59:$E$61))","v":"$763.97"},{"$f":"AE57*(PRODUCT($E$59:$E$61))","v":"$776.55"},{"$f":"AF57*(PRODUCT($E$59:$E$61))","v":"$779.08"},{"$f":"AG57*(PRODUCT($E$59:$E$61))","v":"$711.26"},{"$f":"AH57*(PRODUCT($E$59:$E$61))","v":"$766.75"},{"$f":"AI57*(PRODUCT($E$59:$E$61))","v":"$750.12"},{"$f":"AJ57*(PRODUCT($E$59:$E$61))","v":"$758.67"},{"$f":"AK57*(PRODUCT($E$59:$E$61))","v":"$846.34"},{"$f":"AL57*(PRODUCT($E$59:$E$61))","v":"$820.71"},{"$f":"AM57*(PRODUCT($E$59:$E$61))","v":"$886.45"},{"$f":"AN57*(PRODUCT($E$59:$E$61))","v":"$899.66"},{"$f":"AO57*(PRODUCT($E$59:$E$61))","v":"$897.32"},{"$f":"AP57*(PRODUCT($E$59:$E$61))","v":"$887.88"},{"$f":"AQ57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AR57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AS57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AT57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AU57*(PRODUCT($E$59:$E$61))","v":"$543.07"},{"$f":"AV57*(PRODUCT($E$59:$E$61))","v":"$511.40"},{"$f":"AW57*(PRODUCT($E$59:$E$61))","v":"$554.89"},{"$f":"AX57*(PRODUCT($E$59:$E$61))","v":"$591.80"},{"$f":"AY57*(PRODUCT($E$59:$E$61))","v":"$625.12"},{"$f":"AZ57*(PRODUCT($E$59:$E$61))","v":"$576.42"},{"$f":"BA57*(PRODUCT($E$59:$E$61))","v":"$567.81"},{"$f":"BB57*(PRODUCT($E$59:$E$61))","v":"$575.80"},{"$f":"BC57*(PRODUCT($E$59:$E$61))","v":"$570.35"},{"$f":"BD57*(PRODUCT($E$59:$E$61))","v":"$599.81"},{"$f":"BE57*(PRODUCT($E$59:$E$61))","v":"$596.94"},{"$f":"BF57*(PRODUCT($E$59:$E$61))","v":"$581.17"},{"$f":"BG57*(PRODUCT($E$59:$E$61))","v":"$676.46"},{"$f":"BH57*(PRODUCT($E$59:$E$61))","v":"$661.60"},{"$f":"BI57*(PRODUCT($E$59:$E$61))","v":"$613.71"},{"$f":"BJ57*(PRODUCT($E$59:$E$61))","v":"$672.23"},{"$f":"BK57*(PRODUCT($E$59:$E$61))","v":"$659.19"},{"$f":"BL57*(PRODUCT($E$59:$E$61))","v":"$669.98"},{"$f":"BM57*(PRODUCT($E$59:$E$61))","v":"$659.30"},{"$f":"BN57*(PRODUCT($E$59:$E$61))","v":"$654.62"},{"$f":"BO57*(PRODUCT($E$59:$E$61))","v":"$647.24"},{"$f":"BP57*(PRODUCT($E$59:$E$61))","v":"$774.18"},{"$f":"BQ57*(PRODUCT($E$59:$E$61))","v":"$776.19"},{"$f":"BR57*(PRODUCT($E$59:$E$61))","v":"$764.80"},{"$f":"BS57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BT57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BU57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BV57*(PRODUCT($E$59:$E$61))","v":"$578.83"},{"$f":"BW57*(PRODUCT($E$59:$E$61))","v":"$567.42"},{"$f":"BX57*(PRODUCT($E$59:$E$61))","v":"$591.72"},{"$f":"BY57*(PRODUCT($E$59:$E$61))","v":"$564.30"},{"$f":"BZ57*(PRODUCT($E$59:$E$61))","v":"$670.60"},{"$f":"CA57*(PRODUCT($E$59:$E$61))","v":"$672.00"},{"$f":"CB57*(PRODUCT($E$59:$E$61))","v":"$669.98"},{"$f":"CC57*(PRODUCT($E$59:$E$61))","v":"$664.62"},{"$f":"CD57*(PRODUCT($E$59:$E$61))","v":"$670.68"},{"$f":"CE57*(PRODUCT($E$59:$E$61))","v":"$653.38"},{"$f":"CF57*(PRODUCT($E$59:$E$61))","v":"$0.00"}]
[]
[null,null,"Section IV: Projected Plan Level Information"]
[null,"4.1","Plan ID (Standard Component ID)","Total",{"$f":"IF(E13<>\"\",E13,\"\")","v":"36239KY0470001"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"36239KY0980052"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"36239KY0980051"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"36239KY0980054"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"36239KY0980053"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"36239KY0980047"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"36239KY0980049"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"36239KY0980045"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"36239KY0980046"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"36239KY0980050"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"36239KY0980048"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"36239KY0990238"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"36239KY0990273"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"36239KY0990274"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"36239KY0990263"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"36239KY0990284"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"36239KY0990257"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"36239KY0990260"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"36239KY0990220"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"36239KY0990269"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"36239KY0990265"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"36239KY0990272"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"36239KY0990271"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"36239KY0990262"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"36239KY0990261"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"36239KY0990282"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"36239KY0990237"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"36239KY0990283"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"36239KY0990275"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"36239KY0990286"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"36239KY0990285"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"36239KY0990278"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"36239KY0990289"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"36239KY0990287"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"36239KY0990281"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"36239KY0990242"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"36239KY0990190"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"36239KY0990288"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"36239KY0990276"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"36239KY0990277"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"36239KY0990270"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"36239KY0990266"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"36239KY1170130"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"36239KY1170073"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"36239KY1170129"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"36239KY1170127"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"36239KY1170138"},{"$f":"IF(AZ13<>\"\",AZ13,\"\")","v":"36239KY1170115"},{"$f":"IF(BA13<>\"\",BA13,\"\")","v":"36239KY1170128"},{"$f":"IF(BB13<>\"\",BB13,\"\")","v":"36239KY1170131"},{"$f":"IF(BC13<>\"\",BC13,\"\")","v":"36239KY1170122"},{"$f":"IF(BD13<>\"\",BD13,\"\")","v":"36239KY1170117"},{"$f":"IF(BE13<>\"\",BE13,\"\")","v":"36239KY1170120"},{"$f":"IF(BF13<>\"\",BF13,\"\")","v":"36239KY1170056"},{"$f":"IF(BG13<>\"\",BG13,\"\")","v":"36239KY1170118"},{"$f":"IF(BH13<>\"\",BH13,\"\")","v":"36239KY1170141"},{"$f":"IF(BI13<>\"\",BI13,\"\")","v":"36239KY1170125"},{"$f":"IF(BJ13<>\"\",BJ13,\"\")","v":"36239KY1170139"},{"$f":"IF(BK13<>\"\",BK13,\"\")","v":"36239KY1170137"},{"$f":"IF(BL13<>\"\",BL13,\"\")","v":"36239KY1170142"},{"$f":"IF(BM13<>\"\",BM13,\"\")","v":"36239KY1170119"},{"$f":"IF(BN13<>\"\",BN13,\"\")","v":"36239KY1170136"},{"$f":"IF(BO13<>\"\",BO13,\"\")","v":"36239KY1170140"},{"$f":"IF(BP13<>\"\",BP13,\"\")","v":"36239KY1170037"},{"$f":"IF(BQ13<>\"\",BQ13,\"\")","v":"36239KY1170075"},{"$f":"IF(BR13<>\"\",BR13,\"\")","v":"36239KY1170135"},{"$f":"IF(BS13<>\"\",BS13,\"\")","v":"36239KY1170132"},{"$f":"IF(BT13<>\"\",BT13,\"\")","v":"36239KY1170126"},{"$f":"IF(BU13<>\"\",BU13,\"\")","v":"36239KY1170123"},{"$f":"IF(BV13<>\"\",BV13,\"\")","v":"36239KY1180034"},{"$f":"IF(BW13<>\"\",BW13,\"\")","v":"36239KY1180035"},{"$f":"IF(BX13<>\"\",BX13,\"\")","v":"36239KY1180033"},{"$f":"IF(BY13<>\"\",BY13,\"\")","v":"36239KY1180036"},{"$f":"IF(BZ13<>\"\",BZ13,\"\")","v":"36239KY1180028"},{"$f":"IF(CA13<>\"\",CA13,\"\")","v":"36239KY1180030"},{"$f":"IF(CB13<>\"\",CB13,\"\")","v":"36239KY1180037"},{"$f":"IF(CC13<>\"\",CC13,\"\")","v":"36239KY1180031"},{"$f":"IF(CD13<>\"\",CD13,\"\")","v":"36239KY1180029"},{"$f":"IF(CE13<>\"\",CE13,\"\")","v":"36239KY1180032"},{"$f":"IF(CF13<>\"\",CF13,\"\")","v":"36239KY1200005"}]
[null,"4.2","Allowed Claims",{"$f":"SUM(E66:CF66)","v":"$195,933,670"},0.0,8315106.9,3814423.63,6963416.41,4186488.88,2.228210995E7,1.495777739E7,7700923.9,1.530393342E7,1.911694395E7,2.05479387E7,1915542.19,4537100.28,150447.66,2062858.33,233297.83,5892120.42,1.393256708E7,3995379.03,3866040.97,445010.1,395286.67,523012.53,1150221.95,1470851.17,274386.19,1126069.99,80565.87,1640428.66,82119.09,669117.4,607018.37,80097.42,79031.21,990625.49,4809991.68,1.060182764E7,535905.37,0.0,0.0,0.0,0.0,40256.37,644361.04,385571.79,35089.55,151612.23,441816.12,23167.09,23301.02,240640.94,1288252.59,280490.17,546513.33,24133.99,8922.4,11392.42,8753.65,8706.56,8932.85,12018.13,35990.22,8846.57,417587.18,88587.48,37695.39,0.0,0.0,0.0,395715.95,54917.83,314829.92,294749.05,203392.4,287640.66,1244053.35,562032.97,490554.95,1977161.01,0.0]
[null,"4.3","Reinsurance",{"$f":"SUM(E67:CF67)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.4","Member Cost Sharing",{"$f":"SUM(E68:CF68)","v":"$33,223,929"},0.0,1806582.03,855037.52,1664294.67,970742.8,3201568.83,2248211.45,1101476.19,2187942.57,3081961.9,2932360.98,590661.01,1242958.96,42979.0,451974.86,42105.27,1308548.72,3022979.89,941960.98,944681.38,106359.85,99007.77,118423.35,164442.66,237125.1,37198.91,161797.54,9926.74,326503.36,12599.87,110204.82,100611.58,6137.0,7308.58,68705.82,299366.99,684443.9,29607.01,0.0,0.0,0.0,0.0,11500.2,198689.93,105629.12,7945.17,27362.77,98120.52,5802.68,5693.69,57514.5,279515.01,61455.75,128847.41,3450.34,1369.0,2267.49,1078.56,1180.36,1283.5,1937.52,5965.28,1457.05,26959.03,5513.56,2614.4,0.0,0.0,0.0,85975.24,12734.08,70571.97,70446.64,29091.56,41048.7,178749.79,84475.72,70132.69,318750.47,0.0]
[null,"4.5","Cost Sharing Reduction",{"$f":"SUM(E69:CF69)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.6","Incurred Claims",{"$f":"D66-D67-D68-D69","v":"$162,709,741"},{"$f":"E66-E67-E68-E69","v":"0"},{"$f":"F66-F67-F68-F69","v":"6508524.87"},{"$f":"G66-G67-G68-G69","v":"2959386.11"},{"$f":"H66-H67-H68-H69","v":"5299121.74"},{"$f":"I66-I67-I68-I69","v":"3215746.08"},{"$f":"J66-J67-J68-J69","v":"19080541.12"},{"$f":"K66-K67-K68-K69","v":"12709565.94"},{"$f":"L66-L67-L68-L69","v":"6599447.71"},{"$f":"M66-M67-M68-M69","v":"13115990.85"},{"$f":"N66-N67-N68-N69","v":"16034982.05"},{"$f":"O66-O67-O68-O69","v":"17615577.72"},{"$f":"P66-P67-P68-P69","v":"1324881.18"},{"$f":"Q66-Q67-Q68-Q69","v":"3294141.32"},{"$f":"R66-R67-R68-R69","v":"107468.66"},{"$f":"S66-S67-S68-S69","v":"1610883.47"},{"$f":"T66-T67-T68-T69","v":"191192.56"},{"$f":"U66-U67-U68-U69","v":"4583571.7"},{"$f":"V66-V67-V68-V69","v":"10909587.19"},{"$f":"W66-W67-W68-W69","v":"3053418.05"},{"$f":"X66-X67-X68-X69","v":"2921359.59"},{"$f":"Y66-Y67-Y68-Y69","v":"338650.25"},{"$f":"Z66-Z67-Z68-Z69","v":"296278.9"},{"$f":"AA66-AA67-AA68-AA69","v":"404589.18"},{"$f":"AB66-AB67-AB68-AB69","v":"985779.29"},{"$f":"AC66-AC67-AC68-AC69","v":"1233726.07"},{"$f":"AD66-AD67-AD68-AD69","v":"237187.28"},{"$f":"AE66-AE67-AE68-AE69","v":"964272.45"},{"$f":"AF66-AF67-AF68-AF69","v":"70639.13"},{"$f":"AG66-AG67-AG68-AG69","v":"1313925.3"},{"$f":"AH66-AH67-AH68-AH69","v":"69519.22"},{"$f":"AI66-AI67-AI68-AI69","v":"558912.58"},{"$f":"AJ66-AJ67-AJ68-AJ69","v":"506406.79"},{"$f":"AK66-AK67-AK68-AK69","v":"73960.42"},{"$f":"AL66-AL67-AL68-AL69","v":"71722.63"},{"$f":"AM66-AM67-AM68-AM69","v":"921919.67"},{"$f":"AN66-AN67-AN68-AN69","v":"4510624.69"},{"$f":"AO66-AO67-AO68-AO69","v":"9917383.74"},{"$f":"AP66-AP67-AP68-AP69","v":"506298.36"},{"$f":"AQ66-AQ67-AQ68-AQ69","v":"0"},{"$f":"AR66-AR67-AR68-AR69","v":"0"},{"$f":"AS66-AS67-AS68-AS69","v":"0"},{"$f":"AT66-AT67-AT68-AT69","v":"0"},{"$f":"AU66-AU67-AU68-AU69","v":"28756.17"},{"$f":"AV66-AV67-AV68-AV69","v":"445671.11"},{"$f":"AW66-AW67-AW68-AW69","v":"279942.67"},{"$f":"AX66-AX67-AX68-AX69","v":"27144.38"},{"$f":"AY66-AY67-AY68-AY69","v":"124249.46"},{"$f":"AZ66-AZ67-AZ68-AZ69","v":"343695.6"},{"$f":"BA66-BA67-BA68-BA69","v":"17364.41"},{"$f":"BB66-BB67-BB68-BB69","v":"17607.33"},{"$f":"BC66-BC67-BC68-BC69","v":"183126.44"},{"$f":"BD66-BD67-BD68-BD69","v":"1008737.58"},{"$f":"BE66-BE67-BE68-BE69","v":"219034.42"},{"$f":"BF66-BF67-BF68-BF69","v":"417665.92"},{"$f":"BG66-BG67-BG68-BG69","v":"20683.65"},{"$f":"BH66-BH67-BH68-BH69","v":"7553.4"},{"$f":"BI66-BI67-BI68-BI69","v":"9124.93"},{"$f":"BJ66-BJ67-BJ68-BJ69","v":"7675.09"},{"$f":"BK66-BK67-BK68-BK69","v":"7526.2"},{"$f":"BL66-BL67-BL68-BL69","v":"7649.35"},{"$f":"BM66-BM67-BM68-BM69","v":"10080.61"},{"$f":"BN66-BN67-BN68-BN69","v":"30024.94"},{"$f":"BO66-BO67-BO68-BO69","v":"7389.52"},{"$f":"BP66-BP67-BP68-BP69","v":"390628.15"},{"$f":"BQ66-BQ67-BQ68-BQ69","v":"83073.92"},{"$f":"BR66-BR67-BR68-BR69","v":"35080.99"},{"$f":"BS66-BS67-BS68-BS69","v":"0"},{"$f":"BT66-BT67-BT68-BT69","v":"0"},{"$f":"BU66-BU67-BU68-BU69","v":"0"},{"$f":"BV66-BV67-BV68-BV69","v":"309740.71"},{"$f":"BW66-BW67-BW68-BW69","v":"42183.75"},{"$f":"BX66-BX67-BX68-BX69","v":"244257.95"},{"$f":"BY66-BY67-BY68-BY69","v":"224302.41"},{"$f":"BZ66-BZ67-BZ68-BZ69","v":"174300.84"},{"$f":"CA66-CA67-CA68-CA69","v":"246591.96"},{"$f":"CB66-CB67-CB68-CB69","v":"1065303.56"},{"$f":"CC66-CC67-CC68-CC69","v":"477557.25"},{"$f":"CD66-CD67-CD68-CD69","v":"420422.26"},{"$f":"CE66-CE67-CE68-CE69","v":"1658410.54"},{"$f":"CF66-CF67-CF68-CF69","v":"0"}]
[null,"4.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E71:CF71)","v":"$30,469"},0.0,1218.39,553.99,991.99,601.98,3571.86,2379.22,1235.41,2455.3,3001.73,3297.62,248.02,616.66,20.12,301.56,35.79,858.04,2042.26,571.6,546.88,63.39,55.46,75.74,184.54,230.95,44.4,180.51,13.22,245.97,13.01,104.63,94.8,13.85,13.43,172.58,844.38,1856.52,94.78,0.0,0.0,0.0,0.0,5.42,83.94,52.73,5.11,23.4,64.73,3.27,3.32,34.49,189.99,41.25,78.67,3.9,1.42,1.72,1.45,1.42,1.44,1.9,5.66,1.39,73.57,15.65,6.61,0.0,0.0,0.0,58.34,7.95,46.01,42.25,32.83,46.44,200.65,89.95,79.19,312.36,0.0]
[null,"4.8","Premium",{"$f":"SUM(E72:CF72)","v":"$185,886,817"},0.0,7435741.53,3380658.42,6053618.98,3673508.04,2.179830947E7,1.452033906E7,7539480.81,1.498381982E7,1.831937725E7,2.012504457E7,1513277.13,3762881.04,122387.21,1840290.79,218320.08,5236890.7,1.246314851E7,3488831.29,3337432.6,386642.2,338029.34,462234.22,1126537.39,1408907.82,271040.94,1101902.7,80954.71,1501408.58,79671.26,638017.88,578854.96,84169.94,81623.24,1052649.65,5153289.4,1.132969151E7,578610.46,0.0,0.0,0.0,0.0,32847.02,509260.48,320057.86,31430.97,142026.2,392869.15,20106.56,20387.84,209521.05,1152107.69,250101.36,476763.01,23949.97,8784.1,10865.01,8925.61,8752.47,8895.68,11672.52,34766.42,8593.53,446604.34,95047.64,40620.91,0.0,0.0,0.0,353530.72,48553.78,279338.95,256394.02,198858.05,281567.53,1216731.28,545128.59,479888.3,1894275.29,0.0]
[null,"4.9","Projected Member Months",{"$f":"SUM(E73:CF73)","v":"169273"},0.0,7467.0,3321.0,6236.0,3763.0,18912.0,12700.0,6535.0,12986.0,16296.0,17407.0,1720.0,3942.0,131.0,1792.0,203.0,5281.0,12078.0,3489.0,3369.0,394.0,346.0,454.0,968.0,1242.0,239.0,956.0,70.0,1422.0,70.0,573.0,514.0,67.0,67.0,800.0,3859.0,8506.0,439.0,0.0,0.0,0.0,0.0,41.0,675.0,391.0,36.0,154.0,462.0,24.0,24.0,249.0,1302.0,284.0,556.0,24.0,9.0,12.0,9.0,9.0,9.0,12.0,36.0,9.0,391.0,83.0,36.0,0.0,0.0,0.0,414.0,58.0,320.0,308.0,201.0,284.0,1231.0,556.0,485.0,1965.0,0.0]
[null,"4.10","Loss Ratio",{"$f":"D70/(D71+D72)","v":"87.52%"},{"$f":"E70/(E71+E72)","v":"0"},{"$f":"F70/(F71+F72)","v":"0.87515933123383"},{"$f":"G70/(G71+G72)","v":"0.875244069626492"},{"$f":"H70/(H71+H72)","v":"0.875220846765651"},{"$f":"I70/(I71+I72)","v":"0.875244906248072"},{"$f":"J70/(J71+J72)","v":"0.875178652300278"},{"$f":"K70/(K71+K72)","v":"0.875150622284191"},{"$f":"L70/(L71+L72)","v":"0.875175184619267"},{"$f":"M70/(M71+M72)","v":"0.875200191173322"},{"$f":"N70/(N71+N72)","v":"0.87515830054073"},{"$f":"O70/(O71+O72)","v":"0.875162870032666"},{"$f":"P70/(P71+P72)","v":"0.875361192379261"},{"$f":"Q70/(Q71+Q72)","v":"0.875287188298268"},{"$f":"R70/(R71+R72)","v":"0.877959350963705"},{"$f":"S70/(S71+S72)","v":"0.875198394690709"},{"$f":"T70/(T71+T72)","v":"0.875600733792959"},{"$f":"U70/(U71+U72)","v":"0.875103394134939"},{"$f":"V70/(V71+V72)","v":"0.875204189915499"},{"$f":"W70/(W71+W72)","v":"0.875054599957645"},{"$f":"X70/(X71+X72)","v":"0.8751880014553"},{"$f":"Y70/(Y71+Y72)","v":"0.875731457618702"},{"$f":"Z70/(Z71+Z72)","v":"0.876344928846254"},{"$f":"AA70/(AA71+AA72)","v":"0.875147011758086"},{"$f":"AB70/(AB71+AB72)","v":"0.874909117993292"},{"$f":"AC70/(AC71+AC72)","v":"0.875517795880387"},{"$f":"AD70/(AD71+AD72)","v":"0.874954285613527"},{"$f":"AE70/(AE71+AE72)","v":"0.874954305855"},{"$f":"AF70/(AF71+AF72)","v":"0.872433443710368"},{"$f":"AG70/(AG71+AG72)","v":"0.874985062310103"},{"$f":"AH70/(AH71+AH72)","v":"0.872433417536485"},{"$f":"AI70/(AI71+AI72)","v":"0.875870340320701"},{"$f":"AJ70/(AJ71+AJ72)","v":"0.874699023970577"},{"$f":"AK70/(AK71+AK72)","v":"0.878558924467525"},{"$f":"AL70/(AL71+AL72)","v":"0.878558985808706"},{"$f":"AM70/(AM71+AM72)","v":"0.875665087352876"},{"$f":"AN70/(AN71+AN72)","v":"0.875146995117383"},{"$f":"AO70/(AO71+AO72)","v":"0.87520113878033"},{"$f":"AP70/(AP71+AP72)","v":"0.874881243515265"},{"$f":"AQ70/(AQ71+AQ72)","v":"0"},{"$f":"AR70/(AR71+AR72)","v":"0"},{"$f":"AS70/(AS71+AS72)","v":"0"},{"$f":"AT70/(AT71+AT72)","v":"0"},{"$f":"AU70/(AU71+AU72)","v":"0.875313066548482"},{"$f":"AV70/(AV71+AV72)","v":"0.874989677907927"},{"$f":"AW70/(AW71+AW72)","v":"0.874518615582196"},{"$f":"AX70/(AX71+AX72)","v":"0.863478525312316"},{"$f":"AY70/(AY71+AY72)","v":"0.874690671427445"},{"$f":"AZ70/(AZ71+AZ72)","v":"0.874690673148368"},{"$f":"BA70/(BA71+BA72)","v":"0.863478706682254"},{"$f":"BB70/(BB71+BB72)","v":"0.863478585818561"},{"$f":"BC70/(BC71+BC72)","v":"0.873880213331511"},{"$f":"BD70/(BD71+BD72)","v":"0.875414050994184"},{"$f":"BE70/(BE71+BE72)","v":"0.875638180956055"},{"$f":"BF70/(BF71+BF72)","v":"0.875900613385977"},{"$f":"BG70/(BG71+BG72)","v":"0.863478427494179"},{"$f":"BH70/(BH71+BH72)","v":"0.859755597847367"},{"$f":"BI70/(BI71+BI72)","v":"0.839712590632141"},{"$f":"BJ70/(BJ71+BJ72)","v":"0.859755619431257"},{"$f":"BK70/(BK71+BK72)","v":"0.859754920383967"},{"$f":"BL70/(BL71+BL72)","v":"0.859755741183664"},{"$f":"BM70/(BM71+BM72)","v":"0.863478442612138"},{"$f":"BN70/(BN71+BN72)","v":"0.863478399911653"},{"$f":"BO70/(BO71+BO72)","v":"0.859754366532789"},{"$f":"BP70/(BP71+BP72)","v":"0.874518621258884"},{"$f":"BQ70/(BQ71+BQ72)","v":"0.873880127649695"},{"$f":"BR70/(BR71+BR72)","v":"0.863478499302935"},{"$f":"BS70/(BS71+BS72)","v":"0"},{"$f":"BT70/(BT71+BT72)","v":"0"},{"$f":"BU70/(BU71+BU72)","v":"0"},{"$f":"BV70/(BV71+BV72)","v":"0.875990648579456"},{"$f":"BW70/(BW71+BW72)","v":"0.8686624220348"},{"$f":"BX70/(BX71+BX72)","v":"0.874270218411184"},{"$f":"BY70/(BY71+BY72)","v":"0.874690659008572"},{"$f":"BZ70/(BZ71+BZ72)","v":"0.876364165114057"},{"$f":"CA70/(CA71+CA72)","v":"0.875638236270736"},{"$f":"CB70/(CB71+CB72)","v":"0.87540110809649"},{"$f":"CC70/(CC71+CC72)","v":"0.875900606754862"},{"$f":"CD70/(CD71+CD72)","v":"0.875939034954222"},{"$f":"CE70/(CE71+CE72)","v":"0.875341154050065"},{"$f":"CF70/(CF71+CF72)","v":"0"}]
[null,null,"Per Member Per Month"]
[null,"4.11","Allowed Claims",{"$f":"D66/D73","v":"$1,157.50"},{"$f":"E66/E73","v":"0"},{"$f":"F66/F73","v":"1113.5807"},{"$f":"G66/G73","v":"1148.5768"},{"$f":"H66/H73","v":"1116.6479"},{"$f":"I66/I73","v":"1112.5402"},{"$f":"J66/J73","v":"1178.1996"},{"$f":"K66/K73","v":"1177.7777"},{"$f":"L66/L73","v":"1178.4122"},{"$f":"M66/M73","v":"1178.4948"},{"$f":"N66/N73","v":"1173.1065"},{"$f":"O66/O73","v":"1180.4411"},{"$f":"P66/P73","v":"1113.6873"},{"$f":"Q66/Q73","v":"1150.964"},{"$f":"R66/R73","v":"1148.4554"},{"$f":"S66/S73","v":"1151.1486"},{"$f":"T66/T73","v":"1149.2504"},{"$f":"U66/U73","v":"1115.7206"},{"$f":"V66/V73","v":"1153.5492"},{"$f":"W66/W73","v":"1145.1359"},{"$f":"X66/X73","v":"1147.5337"},{"$f":"Y66/Y73","v":"1129.4673"},{"$f":"Z66/Z73","v":"1142.447"},{"$f":"AA66/AA73","v":"1152.01"},{"$f":"AB66/AB73","v":"1188.2458"},{"$f":"AC66/AC73","v":"1184.2602"},{"$f":"AD66/AD73","v":"1148.0594"},{"$f":"AE66/AE73","v":"1177.8975"},{"$f":"AF66/AF73","v":"1150.941"},{"$f":"AG66/AG73","v":"1153.6067"},{"$f":"AH66/AH73","v":"1173.1299"},{"$f":"AI66/AI73","v":"1167.7442"},{"$f":"AJ66/AJ73","v":"1180.9696"},{"$f":"AK66/AK73","v":"1195.4839"},{"$f":"AL66/AL73","v":"1179.5703"},{"$f":"AM66/AM73","v":"1238.2819"},{"$f":"AN66/AN73","v":"1246.4347"},{"$f":"AO66/AO73","v":"1246.394"},{"$f":"AP66/AP73","v":"1220.7412"},{"$f":"AQ66/AQ73","v":"0"},{"$f":"AR66/AR73","v":"0"},{"$f":"AS66/AS73","v":"0"},{"$f":"AT66/AT73","v":"0"},{"$f":"AU66/AU73","v":"981.8627"},{"$f":"AV66/AV73","v":"954.6089"},{"$f":"AW66/AW73","v":"986.1171"},{"$f":"AX66/AX73","v":"974.7097"},{"$f":"AY66/AY73","v":"984.495"},{"$f":"AZ66/AZ73","v":"956.3119"},{"$f":"BA66/BA73","v":"965.2954"},{"$f":"BB66/BB73","v":"970.8758"},{"$f":"BC66/BC73","v":"966.4295"},{"$f":"BD66/BD73","v":"989.4413"},{"$f":"BE66/BE73","v":"987.6414"},{"$f":"BF66/BF73","v":"982.9376"},{"$f":"BG66/BG73","v":"1005.5829"},{"$f":"BH66/BH73","v":"991.3778"},{"$f":"BI66/BI73","v":"949.3683"},{"$f":"BJ66/BJ73","v":"972.6278"},{"$f":"BK66/BK73","v":"967.3956"},{"$f":"BL66/BL73","v":"992.5389"},{"$f":"BM66/BM73","v":"1001.5108"},{"$f":"BN66/BN73","v":"999.7283"},{"$f":"BO66/BO73","v":"982.9522"},{"$f":"BP66/BP73","v":"1067.9979"},{"$f":"BQ66/BQ73","v":"1067.319"},{"$f":"BR66/BR73","v":"1047.0942"},{"$f":"BS66/BS73","v":"0"},{"$f":"BT66/BT73","v":"0"},{"$f":"BU66/BU73","v":"0"},{"$f":"BV66/BV73","v":"955.8356"},{"$f":"BW66/BW73","v":"946.8591"},{"$f":"BX66/BX73","v":"983.8435"},{"$f":"BY66/BY73","v":"956.9774"},{"$f":"BZ66/BZ73","v":"1011.9025"},{"$f":"CA66/CA73","v":"1012.8192"},{"$f":"CB66/CB73","v":"1010.6039"},{"$f":"CC66/CC73","v":"1010.8507"},{"$f":"CD66/CD73","v":"1011.4535"},{"$f":"CE66/CE73","v":"1006.1888"},{"$f":"CF66/CF73","v":"0"}]
[null,"4.12","Reinsurance",{"$f":"D67/D73","v":"$0.00"},{"$f":"E67/E73","v":"0"},{"$f":"F67/F73","v":"0"},{"$f":"G67/G73","v":"0"},{"$f":"H67/H73","v":"0"},{"$f":"I67/I73","v":"0"},{"$f":"J67/J73","v":"0"},{"$f":"K67/K73","v":"0"},{"$f":"L67/L73","v":"0"},{"$f":"M67/M73","v":"0"},{"$f":"N67/N73","v":"0"},{"$f":"O67/O73","v":"0"},{"$f":"P67/P73","v":"0"},{"$f":"Q67/Q73","v":"0"},{"$f":"R67/R73","v":"0"},{"$f":"S67/S73","v":"0"},{"$f":"T67/T73","v":"0"},{"$f":"U67/U73","v":"0"},{"$f":"V67/V73","v":"0"},{"$f":"W67/W73","v":"0"},{"$f":"X67/X73","v":"0"},{"$f":"Y67/Y73","v":"0"},{"$f":"Z67/Z73","v":"0"},{"$f":"AA67/AA73","v":"0"},{"$f":"AB67/AB73","v":"0"},{"$f":"AC67/AC73","v":"0"},{"$f":"AD67/AD73","v":"0"},{"$f":"AE67/AE73","v":"0"},{"$f":"AF67/AF73","v":"0"},{"$f":"AG67/AG73","v":"0"},{"$f":"AH67/AH73","v":"0"},{"$f":"AI67/AI73","v":"0"},{"$f":"AJ67/AJ73","v":"0"},{"$f":"AK67/AK73","v":"0"},{"$f":"AL67/AL73","v":"0"},{"$f":"AM67/AM73","v":"0"},{"$f":"AN67/AN73","v":"0"},{"$f":"AO67/AO73","v":"0"},{"$f":"AP67/AP73","v":"0"},{"$f":"AQ67/AQ73","v":"0"},{"$f":"AR67/AR73","v":"0"},{"$f":"AS67/AS73","v":"0"},{"$f":"AT67/AT73","v":"0"},{"$f":"AU67/AU73","v":"0"},{"$f":"AV67/AV73","v":"0"},{"$f":"AW67/AW73","v":"0"},{"$f":"AX67/AX73","v":"0"},{"$f":"AY67/AY73","v":"0"},{"$f":"AZ67/AZ73","v":"0"},{"$f":"BA67/BA73","v":"0"},{"$f":"BB67/BB73","v":"0"},{"$f":"BC67/BC73","v":"0"},{"$f":"BD67/BD73","v":"0"},{"$f":"BE67/BE73","v":"0"},{"$f":"BF67/BF73","v":"0"},{"$f":"BG67/BG73","v":"0"},{"$f":"BH67/BH73","v":"0"},{"$f":"BI67/BI73","v":"0"},{"$f":"BJ67/BJ73","v":"0"},{"$f":"BK67/BK73","v":"0"},{"$f":"BL67/BL73","v":"0"},{"$f":"BM67/BM73","v":"0"},{"$f":"BN67/BN73","v":"0"},{"$f":"BO67/BO73","v":"0"},{"$f":"BP67/BP73","v":"0"},{"$f":"BQ67/BQ73","v":"0"},{"$f":"BR67/BR73","v":"0"},{"$f":"BS67/BS73","v":"0"},{"$f":"BT67/BT73","v":"0"},{"$f":"BU67/BU73","v":"0"},{"$f":"BV67/BV73","v":"0"},{"$f":"BW67/BW73","v":"0"},{"$f":"BX67/BX73","v":"0"},{"$f":"BY67/BY73","v":"0"},{"$f":"BZ67/BZ73","v":"0"},{"$f":"CA67/CA73","v":"0"},{"$f":"CB67/CB73","v":"0"},{"$f":"CC67/CC73","v":"0"},{"$f":"CD67/CD73","v":"0"},{"$f":"CE67/CE73","v":"0"},{"$f":"CF67/CF73","v":"0"}]
[null,"4.13","Member Cost Sharing",{"$f":"D68/D73","v":"$196.27"},{"$f":"E68/E73","v":"0"},{"$f":"F68/F73","v":"241.9421"},{"$f":"G68/G73","v":"257.4639"},{"$f":"H68/H73","v":"266.885"},{"$f":"I68/I73","v":"257.9704"},{"$f":"J68/J73","v":"169.2877"},{"$f":"K68/K73","v":"177.0245"},{"$f":"L68/L73","v":"168.5503"},{"$f":"M68/M73","v":"168.4847"},{"$f":"N68/N73","v":"189.1238"},{"$f":"O68/O73","v":"168.4587"},{"$f":"P68/P73","v":"343.4076"},{"$f":"Q68/Q73","v":"315.3118"},{"$f":"R68/R73","v":"328.084"},{"$f":"S68/S73","v":"252.2181"},{"$f":"T68/T73","v":"207.4151"},{"$f":"U68/U73","v":"247.7843"},{"$f":"V68/V73","v":"250.2881"},{"$f":"W68/W73","v":"269.9802"},{"$f":"X68/X73","v":"280.4041"},{"$f":"Y68/Y73","v":"269.9489"},{"$f":"Z68/Z73","v":"286.1496"},{"$f":"AA68/AA73","v":"260.8444"},{"$f":"AB68/AB73","v":"169.8788"},{"$f":"AC68/AC73","v":"190.922"},{"$f":"AD68/AD73","v":"155.644"},{"$f":"AE68/AE73","v":"169.2443"},{"$f":"AF68/AF73","v":"141.8106"},{"$f":"AG68/AG73","v":"229.6086"},{"$f":"AH68/AH73","v":"179.9981"},{"$f":"AI68/AI73","v":"192.3295"},{"$f":"AJ68/AJ73","v":"195.7424"},{"$f":"AK68/AK73","v":"91.597"},{"$f":"AL68/AL73","v":"109.0833"},{"$f":"AM68/AM73","v":"85.8823"},{"$f":"AN68/AN73","v":"77.5763"},{"$f":"AO68/AO73","v":"80.466"},{"$f":"AP68/AP73","v":"67.4419"},{"$f":"AQ68/AQ73","v":"0"},{"$f":"AR68/AR73","v":"0"},{"$f":"AS68/AS73","v":"0"},{"$f":"AT68/AT73","v":"0"},{"$f":"AU68/AU73","v":"280.4927"},{"$f":"AV68/AV73","v":"294.3555"},{"$f":"AW68/AW73","v":"270.1512"},{"$f":"AX68/AX73","v":"220.6992"},{"$f":"AY68/AY73","v":"177.6803"},{"$f":"AZ68/AZ73","v":"212.3821"},{"$f":"BA68/BA73","v":"241.7783"},{"$f":"BB68/BB73","v":"237.2371"},{"$f":"BC68/BC73","v":"230.9819"},{"$f":"BD68/BD73","v":"214.6813"},{"$f":"BE68/BE73","v":"216.3935"},{"$f":"BF68/BF73","v":"231.7399"},{"$f":"BG68/BG73","v":"143.7642"},{"$f":"BH68/BH73","v":"152.1111"},{"$f":"BI68/BI73","v":"188.9575"},{"$f":"BJ68/BJ73","v":"119.84"},{"$f":"BK68/BK73","v":"131.1511"},{"$f":"BL68/BL73","v":"142.6111"},{"$f":"BM68/BM73","v":"161.46"},{"$f":"BN68/BN73","v":"165.7022"},{"$f":"BO68/BO73","v":"161.8944"},{"$f":"BP68/BP73","v":"68.9489"},{"$f":"BQ68/BQ73","v":"66.4284"},{"$f":"BR68/BR73","v":"72.6222"},{"$f":"BS68/BS73","v":"0"},{"$f":"BT68/BT73","v":"0"},{"$f":"BU68/BU73","v":"0"},{"$f":"BV68/BV73","v":"207.6697"},{"$f":"BW68/BW73","v":"219.5531"},{"$f":"BX68/BX73","v":"220.5374"},{"$f":"BY68/BY73","v":"228.7229"},{"$f":"BZ68/BZ73","v":"144.7341"},{"$f":"CA68/CA73","v":"144.5377"},{"$f":"CB68/CB73","v":"145.207"},{"$f":"CC68/CC73","v":"151.9347"},{"$f":"CD68/CD73","v":"144.6035"},{"$f":"CE68/CE73","v":"162.214"},{"$f":"CF68/CF73","v":"0"}]
[null,"4.14","Cost Sharing Reduction",{"$f":"D69/D73","v":"$0.00"},{"$f":"E69/E73","v":"0"},{"$f":"F69/F73","v":"0"},{"$f":"G69/G73","v":"0"},{"$f":"H69/H73","v":"0"},{"$f":"I69/I73","v":"0"},{"$f":"J69/J73","v":"0"},{"$f":"K69/K73","v":"0"},{"$f":"L69/L73","v":"0"},{"$f":"M69/M73","v":"0"},{"$f":"N69/N73","v":"0"},{"$f":"O69/O73","v":"0"},{"$f":"P69/P73","v":"0"},{"$f":"Q69/Q73","v":"0"},{"$f":"R69/R73","v":"0"},{"$f":"S69/S73","v":"0"},{"$f":"T69/T73","v":"0"},{"$f":"U69/U73","v":"0"},{"$f":"V69/V73","v":"0"},{"$f":"W69/W73","v":"0"},{"$f":"X69/X73","v":"0"},{"$f":"Y69/Y73","v":"0"},{"$f":"Z69/Z73","v":"0"},{"$f":"AA69/AA73","v":"0"},{"$f":"AB69/AB73","v":"0"},{"$f":"AC69/AC73","v":"0"},{"$f":"AD69/AD73","v":"0"},{"$f":"AE69/AE73","v":"0"},{"$f":"AF69/AF73","v":"0"},{"$f":"AG69/AG73","v":"0"},{"$f":"AH69/AH73","v":"0"},{"$f":"AI69/AI73","v":"0"},{"$f":"AJ69/AJ73","v":"0"},{"$f":"AK69/AK73","v":"0"},{"$f":"AL69/AL73","v":"0"},{"$f":"AM69/AM73","v":"0"},{"$f":"AN69/AN73","v":"0"},{"$f":"AO69/AO73","v":"0"},{"$f":"AP69/AP73","v":"0"},{"$f":"AQ69/AQ73","v":"0"},{"$f":"AR69/AR73","v":"0"},{"$f":"AS69/AS73","v":"0"},{"$f":"AT69/AT73","v":"0"},{"$f":"AU69/AU73","v":"0"},{"$f":"AV69/AV73","v":"0"},{"$f":"AW69/AW73","v":"0"},{"$f":"AX69/AX73","v":"0"},{"$f":"AY69/AY73","v":"0"},{"$f":"AZ69/AZ73","v":"0"},{"$f":"BA69/BA73","v":"0"},{"$f":"BB69/BB73","v":"0"},{"$f":"BC69/BC73","v":"0"},{"$f":"BD69/BD73","v":"0"},{"$f":"BE69/BE73","v":"0"},{"$f":"BF69/BF73","v":"0"},{"$f":"BG69/BG73","v":"0"},{"$f":"BH69/BH73","v":"0"},{"$f":"BI69/BI73","v":"0"},{"$f":"BJ69/BJ73","v":"0"},{"$f":"BK69/BK73","v":"0"},{"$f":"BL69/BL73","v":"0"},{"$f":"BM69/BM73","v":"0"},{"$f":"BN69/BN73","v":"0"},{"$f":"BO69/BO73","v":"0"},{"$f":"BP69/BP73","v":"0"},{"$f":"BQ69/BQ73","v":"0"},{"$f":"BR69/BR73","v":"0"},{"$f":"BS69/BS73","v":"0"},{"$f":"BT69/BT73","v":"0"},{"$f":"BU69/BU73","v":"0"},{"$f":"BV69/BV73","v":"0"},{"$f":"BW69/BW73","v":"0"},{"$f":"BX69/BX73","v":"0"},{"$f":"BY69/BY73","v":"0"},{"$f":"BZ69/BZ73","v":"0"},{"$f":"CA69/CA73","v":"0"},{"$f":"CB69/CB73","v":"0"},{"$f":"CC69/CC73","v":"0"},{"$f":"CD69/CD73","v":"0"},{"$f":"CE69/CE73","v":"0"},{"$f":"CF69/CF73","v":"0"}]
[null,"4.15","Incurred Claims",{"$f":"D70/D73","v":"$961.23"},{"$f":"E70/E73","v":"0"},{"$f":"F70/F73","v":"871.6385"},{"$f":"G70/G73","v":"891.113"},{"$f":"H70/H73","v":"849.7629"},{"$f":"I70/I73","v":"854.5698"},{"$f":"J70/J73","v":"1008.9119"},{"$f":"K70/K73","v":"1000.7532"},{"$f":"L70/L73","v":"1009.8619"},{"$f":"M70/M73","v":"1010.0101"},{"$f":"N70/N73","v":"983.9827"},{"$f":"O70/O73","v":"1011.9824"},{"$f":"P70/P73","v":"770.2798"},{"$f":"Q70/Q73","v":"835.6523"},{"$f":"R70/R73","v":"820.3715"},{"$f":"S70/S73","v":"898.9305"},{"$f":"T70/T73","v":"941.8353"},{"$f":"U70/U73","v":"867.9363"},{"$f":"V70/V73","v":"903.2611"},{"$f":"W70/W73","v":"875.1556"},{"$f":"X70/X73","v":"867.1296"},{"$f":"Y70/Y73","v":"859.5184"},{"$f":"Z70/Z73","v":"856.2974"},{"$f":"AA70/AA73","v":"891.1656"},{"$f":"AB70/AB73","v":"1018.367"},{"$f":"AC70/AC73","v":"993.3382"},{"$f":"AD70/AD73","v":"992.4154"},{"$f":"AE70/AE73","v":"1008.6532"},{"$f":"AF70/AF73","v":"1009.1304"},{"$f":"AG70/AG73","v":"923.9981"},{"$f":"AH70/AH73","v":"993.1317"},{"$f":"AI70/AI73","v":"975.4146"},{"$f":"AJ70/AJ73","v":"985.2272"},{"$f":"AK70/AK73","v":"1103.8869"},{"$f":"AL70/AL73","v":"1070.487"},{"$f":"AM70/AM73","v":"1152.3996"},{"$f":"AN70/AN73","v":"1168.8584"},{"$f":"AO70/AO73","v":"1165.928"},{"$f":"AP70/AP73","v":"1153.2992"},{"$f":"AQ70/AQ73","v":"0"},{"$f":"AR70/AR73","v":"0"},{"$f":"AS70/AS73","v":"0"},{"$f":"AT70/AT73","v":"0"},{"$f":"AU70/AU73","v":"701.37"},{"$f":"AV70/AV73","v":"660.2535"},{"$f":"AW70/AW73","v":"715.9659"},{"$f":"AX70/AX73","v":"754.0106"},{"$f":"AY70/AY73","v":"806.8147"},{"$f":"AZ70/AZ73","v":"743.9299"},{"$f":"BA70/BA73","v":"723.5171"},{"$f":"BB70/BB73","v":"733.6388"},{"$f":"BC70/BC73","v":"735.4476"},{"$f":"BD70/BD73","v":"774.76"},{"$f":"BE70/BE73","v":"771.248"},{"$f":"BF70/BF73","v":"751.1977"},{"$f":"BG70/BG73","v":"861.8188"},{"$f":"BH70/BH73","v":"839.2667"},{"$f":"BI70/BI73","v":"760.4108"},{"$f":"BJ70/BJ73","v":"852.7878"},{"$f":"BK70/BK73","v":"836.2444"},{"$f":"BL70/BL73","v":"849.9278"},{"$f":"BM70/BM73","v":"840.0508"},{"$f":"BN70/BN73","v":"834.0261"},{"$f":"BO70/BO73","v":"821.0578"},{"$f":"BP70/BP73","v":"999.049"},{"$f":"BQ70/BQ73","v":"1000.8906"},{"$f":"BR70/BR73","v":"974.4719"},{"$f":"BS70/BS73","v":"0"},{"$f":"BT70/BT73","v":"0"},{"$f":"BU70/BU73","v":"0"},{"$f":"BV70/BV73","v":"748.166"},{"$f":"BW70/BW73","v":"727.306"},{"$f":"BX70/BX73","v":"763.3061"},{"$f":"BY70/BY73","v":"728.2546"},{"$f":"BZ70/BZ73","v":"867.1684"},{"$f":"CA70/CA73","v":"868.2815"},{"$f":"CB70/CB73","v":"865.3969"},{"$f":"CC70/CC73","v":"858.9159"},{"$f":"CD70/CD73","v":"866.85"},{"$f":"CE70/CE73","v":"843.9748"},{"$f":"CF70/CF73","v":"0"}]
[null,"4.16","Risk Adjustment Transfer Amount",{"$f":"D71/D73","v":"$0.18"},{"$f":"E71/E73","v":"0"},{"$f":"F71/F73","v":"0.1632"},{"$f":"G71/G73","v":"0.1668"},{"$f":"H71/H73","v":"0.1591"},{"$f":"I71/I73","v":"0.16"},{"$f":"J71/J73","v":"0.1889"},{"$f":"K71/K73","v":"0.1873"},{"$f":"L71/L73","v":"0.189"},{"$f":"M71/M73","v":"0.1891"},{"$f":"N71/N73","v":"0.1842"},{"$f":"O71/O73","v":"0.1894"},{"$f":"P71/P73","v":"0.1442"},{"$f":"Q71/Q73","v":"0.1564"},{"$f":"R71/R73","v":"0.1536"},{"$f":"S71/S73","v":"0.1683"},{"$f":"T71/T73","v":"0.1763"},{"$f":"U71/U73","v":"0.1625"},{"$f":"V71/V73","v":"0.1691"},{"$f":"W71/W73","v":"0.1638"},{"$f":"X71/X73","v":"0.1623"},{"$f":"Y71/Y73","v":"0.1609"},{"$f":"Z71/Z73","v":"0.1603"},{"$f":"AA71/AA73","v":"0.1668"},{"$f":"AB71/AB73","v":"0.1906"},{"$f":"AC71/AC73","v":"0.186"},{"$f":"AD71/AD73","v":"0.1858"},{"$f":"AE71/AE73","v":"0.1888"},{"$f":"AF71/AF73","v":"0.1889"},{"$f":"AG71/AG73","v":"0.173"},{"$f":"AH71/AH73","v":"0.1859"},{"$f":"AI71/AI73","v":"0.1826"},{"$f":"AJ71/AJ73","v":"0.1844"},{"$f":"AK71/AK73","v":"0.2067"},{"$f":"AL71/AL73","v":"0.2004"},{"$f":"AM71/AM73","v":"0.2157"},{"$f":"AN71/AN73","v":"0.2188"},{"$f":"AO71/AO73","v":"0.2183"},{"$f":"AP71/AP73","v":"0.2159"},{"$f":"AQ71/AQ73","v":"0"},{"$f":"AR71/AR73","v":"0"},{"$f":"AS71/AS73","v":"0"},{"$f":"AT71/AT73","v":"0"},{"$f":"AU71/AU73","v":"0.1322"},{"$f":"AV71/AV73","v":"0.1244"},{"$f":"AW71/AW73","v":"0.1349"},{"$f":"AX71/AX73","v":"0.1419"},{"$f":"AY71/AY73","v":"0.1519"},{"$f":"AZ71/AZ73","v":"0.1401"},{"$f":"BA71/BA73","v":"0.1363"},{"$f":"BB71/BB73","v":"0.1383"},{"$f":"BC71/BC73","v":"0.1385"},{"$f":"BD71/BD73","v":"0.1459"},{"$f":"BE71/BE73","v":"0.1452"},{"$f":"BF71/BF73","v":"0.1415"},{"$f":"BG71/BG73","v":"0.1625"},{"$f":"BH71/BH73","v":"0.1578"},{"$f":"BI71/BI73","v":"0.1433"},{"$f":"BJ71/BJ73","v":"0.1611"},{"$f":"BK71/BK73","v":"0.1578"},{"$f":"BL71/BL73","v":"0.16"},{"$f":"BM71/BM73","v":"0.1583"},{"$f":"BN71/BN73","v":"0.1572"},{"$f":"BO71/BO73","v":"0.1544"},{"$f":"BP71/BP73","v":"0.1882"},{"$f":"BQ71/BQ73","v":"0.1886"},{"$f":"BR71/BR73","v":"0.1836"},{"$f":"BS71/BS73","v":"0"},{"$f":"BT71/BT73","v":"0"},{"$f":"BU71/BU73","v":"0"},{"$f":"BV71/BV73","v":"0.1409"},{"$f":"BW71/BW73","v":"0.1371"},{"$f":"BX71/BX73","v":"0.1438"},{"$f":"BY71/BY73","v":"0.1372"},{"$f":"BZ71/BZ73","v":"0.1633"},{"$f":"CA71/CA73","v":"0.1635"},{"$f":"CB71/CB73","v":"0.163"},{"$f":"CC71/CC73","v":"0.1618"},{"$f":"CD71/CD73","v":"0.1633"},{"$f":"CE71/CE73","v":"0.159"},{"$f":"CF71/CF73","v":"0"}]
[null,"4.17","Premium",{"$f":"D72/D73","v":"$1,098.15"},{"$f":"E72/E73","v":"0"},{"$f":"F72/F73","v":"995.8138"},{"$f":"G72/G73","v":"1017.964"},{"$f":"H72/H73","v":"970.7535"},{"$f":"I72/I73","v":"976.2179"},{"$f":"J72/J73","v":"1152.6179"},{"$f":"K72/K73","v":"1143.3338"},{"$f":"L72/L73","v":"1153.7079"},{"$f":"M72/M73","v":"1153.8441"},{"$f":"N72/N73","v":"1124.164"},{"$f":"O72/O73","v":"1156.1466"},{"$f":"P72/P73","v":"879.8123"},{"$f":"Q72/Q73","v":"954.5614"},{"$f":"R72/R73","v":"934.2535"},{"$f":"S72/S73","v":"1026.948"},{"$f":"T72/T73","v":"1075.4684"},{"$f":"U72/U73","v":"991.6475"},{"$f":"V72/V73","v":"1031.8884"},{"$f":"W72/W73","v":"999.9516"},{"$f":"X72/X73","v":"990.63"},{"$f":"Y72/Y73","v":"981.3254"},{"$f":"Z72/Z73","v":"976.9634"},{"$f":"AA72/AA73","v":"1018.137"},{"$f":"AB72/AB73","v":"1163.7783"},{"$f":"AC72/AC73","v":"1134.3863"},{"$f":"AD72/AD73","v":"1134.0625"},{"$f":"AE72/AE73","v":"1152.6179"},{"$f":"AF72/AF73","v":"1156.4959"},{"$f":"AG72/AG73","v":"1055.8429"},{"$f":"AH72/AH73","v":"1138.1609"},{"$f":"AI72/AI73","v":"1113.4692"},{"$f":"AJ72/AJ73","v":"1126.177"},{"$f":"AK72/AK73","v":"1256.2678"},{"$f":"AL72/AL73","v":"1218.2573"},{"$f":"AM72/AM73","v":"1315.8121"},{"$f":"AN72/AN73","v":"1335.395"},{"$f":"AO72/AO73","v":"1331.9647"},{"$f":"AP72/AP73","v":"1318.0193"},{"$f":"AQ72/AQ73","v":"0"},{"$f":"AR72/AR73","v":"0"},{"$f":"AS72/AS73","v":"0"},{"$f":"AT72/AT73","v":"0"},{"$f":"AU72/AU73","v":"801.1468"},{"$f":"AV72/AV73","v":"754.46"},{"$f":"AW72/AW73","v":"818.5623"},{"$f":"AX72/AX73","v":"873.0825"},{"$f":"AY72/AY73","v":"922.2481"},{"$f":"AZ72/AZ73","v":"850.3661"},{"$f":"BA72/BA73","v":"837.7733"},{"$f":"BB72/BB73","v":"849.4933"},{"$f":"BC72/BC73","v":"841.45"},{"$f":"BD72/BD73","v":"884.8753"},{"$f":"BE72/BE73","v":"880.6386"},{"$f":"BF72/BF73","v":"857.4874"},{"$f":"BG72/BG73","v":"997.9154"},{"$f":"BH72/BH73","v":"976.0111"},{"$f":"BI72/BI73","v":"905.4175"},{"$f":"BJ72/BJ73","v":"991.7344"},{"$f":"BK72/BK73","v":"972.4967"},{"$f":"BL72/BL73","v":"988.4089"},{"$f":"BM72/BM73","v":"972.71"},{"$f":"BN72/BN73","v":"965.7339"},{"$f":"BO72/BO73","v":"954.8367"},{"$f":"BP72/BP73","v":"1142.2106"},{"$f":"BQ72/BQ73","v":"1145.1523"},{"$f":"BR72/BR73","v":"1128.3586"},{"$f":"BS72/BS73","v":"0"},{"$f":"BT72/BT73","v":"0"},{"$f":"BU72/BU73","v":"0"},{"$f":"BV72/BV73","v":"853.9389"},{"$f":"BW72/BW73","v":"837.1341"},{"$f":"BX72/BX73","v":"872.9342"},{"$f":"BY72/BY73","v":"832.4481"},{"$f":"BZ72/BZ73","v":"989.3435"},{"$f":"CA72/CA73","v":"991.435"},{"$f":"CB72/CB73","v":"988.4088"},{"$f":"CC72/CC73","v":"980.4471"},{"$f":"CD72/CD73","v":"989.4604"},{"$f":"CE72/CE73","v":"964.0078"},{"$f":"CF72/CF73","v":"0"}]

{"sheet":"Wksh 3 - Rating Areas","index":2,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Rating Area Data Collection [assistive technology users, please reference cell A2 for instructions]",null,"Specify the total number of Rating Areas in your State by selecting the Create Rating Areas button or Ctrl + Shift + R.",null,null,null,null,null,null,null,null,null,null,"generated"]
["Press TAB and directional arrow keys to read through the document. If macros are disabled, press and hold the ALT key and press the F, then I, and then N key. After that, select the Enable All Content option by pressing enter. (note that you can also press the C key to select \"Enable All Content\")  Instructions can be found in cells C1 through C4. If screen reader fails to announce a cell after performing a dropdown selection, please press F2 and then ESC to force the screen reader to resume.",null,"Select only the Rating Areas you are offering plans within and add a factor for each area."]
[null,null,"To validate, select the Validate button or Ctrl + Shift + I."]
[null,null,"To finalize, select the Finalize button or Ctrl + Shift + F."]
["Rating Area","Rating Factor"]
["Rating Area 1",1.1174]
["Rating Area 2",1.0763]
["Rating Area 3",0.9733]
["Rating Area 4",0.9868]
["Rating Area 5",0.9636]
["Rating Area 6",1.16]
["Rating Area 7",1.0234]
["Rating Area 8",1.0621]

{"sheet":"PlanTemplate","index":3,"n_rows":82,"n_cols":15,"rows_kept":82,"cut":false,"hidden":true,"merged":[[4,6,4,8],[9,3,21,3],[46,3,50,3],[52,3,56,3]]}
[null,null,"Product-Plan Data Collection"]
[]
[null,null,"Company Legal Name:",{"$f":"IF('Wksh 1 - Market Experience'!C3<>\"\", 'Wksh 1 - Market Experience'!C3,\"\")","v":""},null,null,null,null,null,null,null,null,null,"State:",{"$f":"IF('Wksh 1 - Market Experience'!E4=\"\",\"\",'Wksh 1 - Market Experience'!E4)","v":""}]
[null,null,"HIOS Issuer ID:",{"$f":"IF('Wksh 1 - Market Experience'!C4<>\"\", 'Wksh 1 - Market Experience'!C4,\"\")","v":""},null,null,null,null,null,null,null,null,null,"Market: ",{"$f":"IF('Wksh 1 - Market Experience'!E5=\"\",\"\",'Wksh 1 - Market Experience'!E5)","v":""}]
[null,null,"Effective Date of Rate Change(s):",{"$f":"IF('Wksh 1 - Market Experience'!#REF!<>\"\", 'Wksh 1 - Market Experience'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[]
[null,null,"Product/Plan Level Calculations"]
[]
[null,"Field #","Section I: General Product and Plan Information"]
[null,"1.1","Product Name",null,null,null,null,null,null,null,null,"AL","New","Platinum","Yes"]
[null,"1.2","Product ID",null,null,null,null,null,null,null,null,"AK","Renewing","Gold","No"]
[null,"1.3","Plan Name",null,null,null,null,null,null,null,null,"AZ","Terminated","Silver"]
[null,"1.4","Plan ID (Standard Component ID)",null,null,null,null,null,null,null,null,"AR",null,"Bronze"]
[null,"1.5","Metal",null,null,null,null,null,null,null,null,"CA",null,"Catastrophic"]
[null,"1.6","AV Metal Value",null,null,null,null,null,null,null,null,"CO",null,"Not Applicable"]
[null,"1.7","Plan Category",null,null,null,null,null,null,null,null,"CT"]
[null,"1.8","Plan Type",null,null,null,null,null,null,null,null,"DC"]
[null,"1.9","Exchange Plan?",null,null,null,null,null,null,null,null,"DE"]
[null,"1.10","Effective Date of Proposed Rates",null,null,null,null,null,null,null,null,"FL"]
[null,"1.11","Cumulative Rate Change %  (over 12 mos prior)",null,null,null,null,null,null,null,null,"GA"]
[null,"1.12","Product Rate Increase %",null,null,null,null,null,null,null,null,"HI"]
[null,"1.13","Submission Level Rate Increase %",null,null,null,null,null,null,null,null,"ID"]
[null,null,null,null,null,null,null,null,null,null,null,"IL"]
[null,null,"Section II: Experience Period and Current Plan Level Information",null,null,null,null,null,null,null,null,"IN"]
[null,"2.1","Plan ID (Standard Component ID)","Total",{"$f":"IF(E13<>\"\",E13,\"\")","v":""},null,null,null,null,null,null,"IA"]
[null,"2.2","Allowed Claims",{"$f":"SUM(E26:XFD26)","v":0},null,null,null,null,null,null,null,"KS"]
[null,"2.3","Reinsurance",{"$f":"SUM(E27:XFD27)","v":0},null,null,null,null,null,null,null,"KY"]
[null,"2.4","Member Cost Sharing",{"$f":"SUM(E28:XFD28)","v":0},null,null,null,null,null,null,null,"LA"]
[null,"2.5","Cost Sharing Reduction",{"$f":"SUM(E29:XFD29)","v":0},null,null,null,null,null,null,null,"ME"]
[null,"2.6","Incurred Claims",{"$f":"D26-D27-D28-D29","v":0},{"$f":"E26-E27-E28-E29","v":0},null,null,null,null,null,null,"MD"]
[null,"2.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E31:XFD31)","v":0},null,null,null,null,null,null,null,"MA"]
[null,"2.8","Premium",{"$f":"SUM(E32:XFD32)","v":0},null,null,null,null,null,null,null,"MI"]
[null,"2.9","Experience Period Member Months",{"$f":"SUM(E33:XFD33)","v":0},null,null,null,null,null,null,null,"MN"]
[null,"2.10","Current Enrollment",{"$f":"SUM(E34:XFD34)","v":0},null,null,null,null,null,null,null,"MS"]
[null,"2.11","Current Premium PMPM",{"$f":"SUMPRODUCT(E35:XFD35,E34:XFD34)/D34","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"MO"]
[null,"2.12","Loss Ratio",{"$f":"D30/(D31+D32)","v":{"$error":"#DIV/0!"}},{"$f":"E30/(E31+E32)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"MT"]
[null,null,"Per Member Per Month",null,null,null,null,null,null,null,null,"NE"]
[null,"2.13","Allowed Claims",{"$f":"D26/D33","v":{"$error":"#DIV/0!"}},{"$f":"E26/E33","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"NV"]
[null,"2.14","Reinsurance",{"$f":"D27/D33","v":{"$error":"#DIV/0!"}},{"$f":"E27/E33","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"NH"]
[null,"2.15","Member Cost Sharing",{"$f":"D28/D33","v":{"$error":"#DIV/0!"}},{"$f":"E28/E33","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"NJ"]
[null,"2.16","Cost Sharing Reduction",{"$f":"D29/D33","v":{"$error":"#DIV/0!"}},{"$f":"E29/E33","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"NM"]
[null,"2.17","Incurred Claims",{"$f":"D30/D33","v":{"$error":"#DIV/0!"}},{"$f":"E30/E33","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"NY"]
[null,"2.18","Risk Adjustment Transfer Amount",{"$f":"D31/D33","v":{"$error":"#DIV/0!"}},{"$f":"E31/E33","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"NC"]
[null,"2.19","Premium",{"$f":"D32/D33","v":{"$error":"#DIV/0!"}},{"$f":"E32/E33","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"ND"]
[null,null,null,null,null,null,null,null,null,null,null,"OH"]
[null,null,"Section III: Plan Adjustment Factors",null,null,null,null,null,null,null,null,"OK"]
[null,"3.1","Plan ID (Standard Component ID)",null,{"$f":"IF(E13<>\"\",E13,\"\")","v":""},null,null,null,null,null,null,"OR"]
[null,"3.2","Market Adjusted Index Rate",null,{"$f":"'Wksh 1 - Market Experience'!F46","v":0},null,null,null,null,null,null,"PA"]
[null,"3.3","AV and Cost Sharing Design of Plan",null,null,null,null,null,null,null,null,"RI"]
[null,"3.4","Provider Network Adjustment",null,null,null,null,null,null,null,null,"SC"]
[null,"3.5","Benefits in Addition to EHB",null,null,null,null,null,null,null,null,"SD"]
[null,null,"Administrative Costs",null,null,null,null,null,null,null,null,"TN"]
[null,"3.6","Administrative Expense",null,null,null,null,null,null,null,null,"TX"]
[null,"3.7","Taxes and Fees",null,null,null,null,null,null,null,null,"UT"]
[null,"3.8","Profit & Risk Load",null,null,null,null,null,null,null,null,"VT"]
[null,"3.9","Catastrophic Adjustment",null,null,null,null,null,null,null,null,"VA"]
[null,"3.10","Plan Adjusted Index Rate",null,{"$f":"($E$48*PRODUCT(E49:E51)*E56)/(1-SUM(E53:E55))","v":0},null,null,null,null,null,null,"WA"]
[null,null,null,null,null,null,null,null,null,null,null,"WV"]
[null,"3.11","Age Calibration Factor",null,{"$f":"IF(D59<>\"\", D59, \"\")","v":""},null,null,null,null,null,null,"WI"]
[null,"3.12","Geographic Calibration Factor",null,{"$f":"IF(D60<>\"\", D60, \"\")","v":""},null,null,null,null,null,null,"WY"]
[null,"3.13","Tobacco Calibration Factor",null,{"$f":"IF(D61<>\"\", D61, \"\")","v":""}]
[null,"3.14","Calibrated Plan Adjusted Index Rate",null,{"$f":"E57*(PRODUCT($E$59:$E$61))","v":0}]
[]
[null,null,"Section IV: Projected Plan Level Information"]
[null,"4.1","Plan ID (Standard Component ID)","Total",{"$f":"IF(E13<>\"\",E13,\"\")","v":""}]
[null,"4.2","Allowed Claims",{"$f":"SUM(E66:XFD66)","v":0}]
[null,"4.3","Reinsurance",{"$f":"SUM(E67:XFD67)","v":0}]
[null,"4.4","Member Cost Sharing",{"$f":"SUM(E68:XFD68)","v":0}]
[null,"4.5","Cost Sharing Reduction",{"$f":"SUM(E69:XFD69)","v":0}]
[null,"4.6","Incurred Claims",{"$f":"D66-D67-D68-D69","v":0},{"$f":"E66-E67-E68-E69","v":0}]
[null,"4.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E71:XFD71)","v":0}]
[null,"4.8","Premium",{"$f":"SUM(E72:XFD72)","v":0}]
[null,"4.9","Projected Member Months",{"$f":"SUM(E73:XFD73)","v":0}]
[null,"4.10","Loss Ratio",{"$f":"D70/(D71+D72)","v":{"$error":"#DIV/0!"}},{"$f":"E70/(E71+E72)","v":{"$error":"#DIV/0!"}}]
[null,null,"Per Member Per Month"]
[null,"4.11","Allowed Claims",{"$f":"D66/D73","v":{"$error":"#DIV/0!"}},{"$f":"E66/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.12","Reinsurance",{"$f":"D67/D73","v":{"$error":"#DIV/0!"}},{"$f":"E67/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.13","Member Cost Sharing",{"$f":"D68/D73","v":{"$error":"#DIV/0!"}},{"$f":"E68/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.14","Cost Sharing Reduction",{"$f":"D69/D73","v":{"$error":"#DIV/0!"}},{"$f":"E69/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.15","Incurred Claims",{"$f":"D70/D73","v":{"$error":"#DIV/0!"}},{"$f":"E70/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.16","Risk Adjustment Transfer Amount",{"$f":"D71/D73","v":{"$error":"#DIV/0!"}},{"$f":"E71/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.17","Premium",{"$f":"D72/D73","v":{"$error":"#DIV/0!"}},{"$f":"E72/E73","v":{"$error":"#DIV/0!"}}]