{"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.0 [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,"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:CL19)","v":"2024-01-01"},"Market: ","Small Group"]
[]
[]
[null,"Market Level Calculations (Same for all Plans)"]
[]
[]
[null,"Section I: Experience Period Data"]
[null,"Experience Period:",null,"2022-01-01","to",{"$f":"EDATE(D12,12)-1","v":"2022-12-31"}]
[null,null,null,null,"Total","PMPM"]
[null,"Allowed Claims",null,null,175920117.49000001,{"$f":"E14/E19","v":620.51419361779426}]
[null,"Reinsurance",null,null,0,{"$f":"E15/E19","v":0}]
[null,"Incurred Claims in Experience Period",null,null,142498734.28999999,{"$f":"E16/E19","v":502.62862747657022}]
[null,"Risk Adjustment",null,null,2204451.7400000002,{"$f":"E17/E19","v":7.7756518886658892}]
[null,"Experience Period Premium",null,null,186849109.05000001,{"$f":"E18/E19","v":659.06347656318894}]
[null,"Experience Period Member Months",null,null,{"$f":"'Wksh 2 - Plan Product Info'!D33","v":283507}]
[]
[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",104.89860448813801,1.0354292874280799,1.03194006771687,1.0354292874280799,1.03194006771686,{"$f":"PRODUCT(C24:G24)","v":119.76214099565921}]
[null,"Outpatient Hospital",215.98042504666401,1.0354292874280799,1.03194006771687,1.0354292874280799,1.03194006771686,246.58362466267084]
[null,"Professional",122.13099234264401,1.0354292874280799,1.03194006771687,1.0354292874280799,1.03194006771686,139.43626034160923]
[null,"Other Medical",11.578256095767999,1.0354292874280799,1.03194006771687,1.0354292874280799,1.03194006771686,13.218829228390923]
[null,"Capitation",4.34499700244191E-4,1.00486039991822,1.00486039991822,1.00486039991823,1.00486039991823,4.4300885566220781E-4]
[null,"Prescription Drug",159.711287527086,1.0495679170210901,1.1451651999964001,1.0495679170210901,1.1451651999964101,230.72411471901361]
[null,"Total",{"$f":"SUM(C24:C29)","v":614.3000000000003},null,null,null,null,{"$f":"SUM(H24:H29)","v":749.72541295619953}]
[]
[null,"Morbidity Adjustment",null,null,null,1.042]
[null,"Demographic Shift",null,null,null,1.01]
[null,"Plan Design Changes",null,null,null,1]
[null,"Other",null,null,null,1.1027012784555901]
[null,"Adjusted Trended EHB Allowed Claims PMPM for",null,{"$f":"IF(C5<>\"\",C5,\"\")","v":"2024-01-01"},null,{"$f":"H30*PRODUCT(F32:F35)","v":870.06000000000392}]
[]
[null,"Manual EHB Allowed Claims PMPM",null,null,null,0]
[null,"Applied Credibility %",null,null,null,1]
[]
[null,null,null,null,null,null,"Projected Period Totals"]
[null,"Projected Index Rate for",null,{"$f":"IF(C5<>\"\",C5,\"\")","v":"2024-01-01"},null,{"$f":"ROUND(F39*F36+(1-F39)*F38,2)","v":870.06},{"$f":"F42*F48","v":126280508.39999999}]
[null,"Reinsurance",null,null,null,0,{"$f":"F43*F48","v":0}]
[null,"Risk Adjustment Payment/Charge",null,null,null,41.6656475480005,{"$f":"F44*F48","v":6047352.0851167925}]
[null,"Exchange User Fees",null,null,null,0,{"$f":"F45*F46*F48","v":0}]
[null,"Market Adjusted Index Rate",null,null,null,{"$f":"(F42-F43-F44)/(1-F45)","v":828.39435245199945},{"$f":"F46*F48","v":120233156.3148832}]
[]
[null,"Projected Member Months",null,null,null,{"$f":"'Wksh 2 - Plan Product Info'!D73","v":145140}]
[]
[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":90,"rows_kept":82,"cut":false,"hidden":false,"merged":[[59,4,59,89],[60,4,60,89],[21,4,21,89],[10,83,10,89],[9,83,9,89],[20,83,20,89],[47,4,47,89],[58,4,58,89],[10,49,10,72],[9,49,9,72],[20,49,20,72],[10,73,10,82],[9,73,9,82],[20,73,20,82],[6,2,7,21],[10,5,10,14],[9,5,9,14],[20,5,20,14],[10,15,10,48],[9,15,9,48],[20,15,20,48]]}
["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":"Anthem Health Plans of Kentucky, Inc."},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":36239},"State:",{"$f":"IF('Wksh 1 - Market Experience'!E4<>\"\",'Wksh 1 - Market Experience'!E4,\"\")","v":"KY"},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":"2024-01-01"},"Market: ",{"$f":"IF('Wksh 1 - Market Experience'!E5<>\"\",'Wksh 1 - Market Experience'!E5,\"\")","v":"Small Group"},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,"Terminated Products","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,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,"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,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,"36239KY118",null,null,null,null,null,null,null,null,null,"36239KY120"]
[null,"1.3","Plan Name",null,"2022 Experience","Anthem Silver Blue Access PPO 6000/0.2/8500 (SHOP)","Anthem Silver Blue Access PPO 3200EC/0/5600 w/HSA (SHOP)","Anthem Silver Blue Access PPO 3500EC/0/6500 w/HSA (SHOP)","Anthem Silver Blue Access PPO 5000EC/0/6000 w/HSA (SHOP)","Anthem Gold Blue Access PPO 650/0.2/8500 (SHOP)","Anthem Gold Blue Access PPO 1000/0.2/7000 (SHOP)","Anthem Gold Blue Access PPO 1500/0.2/6000 (SHOP)","Anthem Gold Blue Access PPO 2000/0.2/4500 (SHOP)","Anthem Gold Blue Access PPO 2500/0.2/5000 (SHOP)","Anthem Gold Blue Access PPO 3000/0.2/5500 (SHOP)","Anthem Bronze Blue Access PPO 8000/0.5/9000","Anthem Bronze Blue Access PPO 6500/0.5/8000 w/HSA","Anthem Bronze Blue Access PPO 6500E/0.4/7500 w/HSA","Anthem Bronze Blue Access PPO 5000/0.5/7500 w/HSA","Anthem Bronze Blue Access PPO 8000E/0/8000 w/HSA","Anthem Silver Blue Access PPO 7000/0.2/8500","Anthem Silver Blue Access PPO 4000EC/0/5500 w/HSA","Anthem Silver Blue Access PPO 4500/0.2/8500","Anthem Silver Blue Access PPO 5500/0.2/8000","Anthem Silver Blue Access PPO 5000EC/0/6000 w/HSA WH","Anthem Silver Blue Access PPO 3200EC/0/6250 w/HSA","Anthem Silver Blue Access PPO 3000/0.3/6500 w/HSA","Anthem Silver Blue Access PPO 4500E/0.3/7000 w/HSA","Anthem Silver Blue Access PPO 3500E/0.2/7000 w/HSA","Anthem Gold Blue Access PPO 1500/0.2/6000 (Grp Conv)","Anthem Gold Blue Access PPO 3000/0.2/5500 WH","Anthem Gold Blue Access PPO 1000/0.2/7000 WH","Anthem Gold Blue Access PPO 1600/0.3/4800 w/HSA","Anthem Gold Blue Access PPO 0/0.5/8000","Anthem Platinum Blue Access PPO 250/0.1/2500","Anthem Platinum Blue Access PPO 500/0/3500","Anthem Platinum Blue Access PPO 0/0.1/3000","Anthem Platinum Blue Access PPO 0/0.1/5500","Anthem Gold Pathway PPO 2500/0.3/5000","Anthem Gold Blue Access PPO 1500/0.2/5500","Anthem Silver Pathway PPO 6000/0.2/8500","Anthem Gold Blue Access PPO 2950/0.2/8000","Anthem Silver Blue Access PPO 2500/0.3/8500","Anthem Platinum Blue Access PPO 15/0/3000","Anthem Silver Blue Access PPO 3000EC/0/6850 w/HSA","Anthem Silver Blue Access PPO 3000EC/0.1/6500 w/HSA","Anthem Gold Blue Access PPO 1500/0.2/3000","Anthem Gold Blue Access PPO 500/0.1/3500","Anthem Platinum Blue Access PPO 1000/0.1/2500","Anthem Bronze Pathway HMO 8000/0.5/9000","Anthem Bronze Pathway HMO 6500E/0.4/7500 w/HSA","Anthem Bronze Pathway HMO 5000/0.5/7500 w/HSA","Anthem Bronze Pathway HMO 8000E/0/8000 w/HSA","Anthem Bronze Pathway HMO 6500/0.5/8000 w/HSA","Anthem Silver Pathway HMO 7000/0.2/8500","Anthem Silver Pathway HMO 4000EC/0/5500 w/HSA","Anthem Silver Pathway HMO 4500/0.2/8500","Anthem Silver Pathway HMO 5500/0.2/8000","Anthem Silver Pathway HMO 5000EC/0/6000 w/HSA WH","Anthem Silver Pathway HMO 3200EC/0/6250 w/HSA","Anthem Silver Pathway HMO 3000/0.3/6500 w/HSA","Anthem Silver Pathway HMO 4500E/0.3/7000 w/HSA","Anthem Silver Pathway HMO 3500E/0.2/7000 w/HSA","Anthem Gold Pathway HMO 1000/0.2/7000 WH","Anthem Gold Pathway HMO 3000/0.2/5500 WH","Anthem Gold Pathway HMO 0/0.5/8000","Anthem Gold Pathway HMO 1600/0.3/4800 w/HSA","Anthem Platinum Pathway HMO 250/0.1/2500","Anthem Platinum Pathway HMO 500/0/3500","Anthem Platinum Pathway HMO 0/0.1/5500","Anthem Platinum Pathway HMO 0/0.1/3000","Anthem Silver Pathway HMO 2500/0.3/8500","Anthem Silver Pathway HMO 3000EC/0/6850 w/HSA","Anthem Silver Pathway HMO 6000/0.2/8500 (SHOP)","Anthem Silver Pathway HMO 3200EC/0/5600 w/HSA (SHOP)","Anthem Silver Pathway HMO 3500EC/0/6500 w/HSA (SHOP)","Anthem Silver Pathway HMO 5000EC/0/6000 w/HSA (SHOP)","Anthem Gold Pathway HMO 650/0.2/8500 (SHOP)","Anthem Gold Pathway HMO 1000/0.2/7000 (SHOP)","Anthem Gold Pathway HMO 2000/0.2/4500 (SHOP)","Anthem Gold Pathway HMO 2500/0.2/5000 (SHOP)","Anthem Gold Pathway HMO 3000/0.2/5500 (SHOP)","Anthem Gold Pathway HMO 1500/0.2/6000 (SHOP)","Anthem Link Silver Pathway EPO 4000EC/0.2/6900 w/HSA","Anthem Link Platinum Pathway EPO 250/2500","Anthem Link Silver Pathway EPO 5000/8700","Anthem Link Gold Pathway EPO 2800EC/4000 w/HSA","Anthem Link Silver Pathway EPO 5000EC/5500 w/HSA","Anthem Link Bronze Pathway EPO 6000EC/7000 w/HSA","Anthem Link Gold Pathway EPO 2500/0.2/5000"]
[null,"1.4","Plan ID (Standard Component ID)",null,"36239KY0470137","36239KY0980051","36239KY0980052","36239KY0980053","36239KY0980054","36239KY0980045","36239KY0980046","36239KY0980047","36239KY0980048","36239KY0980049","36239KY0980050","36239KY0990238","36239KY0990270","36239KY0990273","36239KY0990276","36239KY0990274","36239KY0990220","36239KY0990257","36239KY0990260","36239KY0990263","36239KY0990265","36239KY0990266","36239KY0990269","36239KY0990272","36239KY0990271","36239KY0990237","36239KY0990261","36239KY0990262","36239KY0990275","36239KY0990278","36239KY0990190","36239KY0990242","36239KY0990277","36239KY0990281","36239KY0990199","36239KY0990165","36239KY0990216","36239KY0990225","36239KY0990052","36239KY0990234","36239KY0990240","36239KY0990250","36239KY0990246","36239KY0990244","36239KY0990253","36239KY1170073","36239KY1170129","36239KY1170126","36239KY1170130","36239KY1170132","36239KY1170056","36239KY1170115","36239KY1170117","36239KY1170120","36239KY1170122","36239KY1170123","36239KY1170131","36239KY1170128","36239KY1170127","36239KY1170118","36239KY1170119","36239KY1170136","36239KY1170125","36239KY1170037","36239KY1170075","36239KY1170135","36239KY1170133","36239KY1170032","36239KY1170074","36239KY1180033","36239KY1180034","36239KY1180035","36239KY1180036","36239KY1180028","36239KY1180029","36239KY1180030","36239KY1180031","36239KY1180032","36239KY1180037","36239KY1200003","36239KY1200008","36239KY1200007","36239KY1200010","36239KY1200002","36239KY1200001","36239KY1200005"]
[null,"1.5","Metal",null,"Not Applicable","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Gold","Bronze","Bronze","Bronze","Bronze","Bronze","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Platinum","Platinum","Platinum","Platinum","Gold","Gold","Silver","Gold","Silver","Platinum","Silver","Silver","Gold","Gold","Platinum","Bronze","Bronze","Bronze","Bronze","Bronze","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Platinum","Platinum","Platinum","Platinum","Silver","Silver","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Gold","Silver","Platinum","Silver","Gold","Silver","Bronze","Gold"]
[null,"1.6","AV Metal Value",null,0,0.7,0.71299999999999997,0.69099999999999995,0.69499999999999995,0.80600000000000005,0.80200000000000005,0.79700000000000004,0.80700000000000005,0.79400000000000004,0.78300000000000003,0.61099999999999999,0.63200000000000001,0.64200000000000002,0.64800000000000002,0.629,0.7,0.71099999999999997,0.70099999999999996,0.70799999999999996,0.69499999999999995,0.69899999999999995,0.71799999999999997,0.68600000000000005,0.71299999999999997,0.79700000000000004,0.78300000000000003,0.80200000000000005,0.79100000000000004,0.81200000000000006,0.89500000000000002,0.88200000000000001,0.91600000000000004,0.90300000000000002,0.79200000000000004,0.81,0.69699999999999995,0.76,0.71399999999999997,0.86399999999999999,0.67,0.67100000000000004,0.80500000000000005,0.80200000000000005,0.86199999999999999,0.61099999999999999,0.64200000000000002,0.64800000000000002,0.629,0.63200000000000001,0.7,0.71099999999999997,0.70099999999999996,0.70799999999999996,0.69499999999999995,0.69899999999999995,0.71799999999999997,0.68600000000000005,0.71299999999999997,0.80200000000000005,0.78300000000000003,0.81200000000000006,0.79100000000000004,0.89500000000000002,0.88200000000000001,0.90300000000000002,0.91600000000000004,0.71399999999999997,0.67,0.7,0.71299999999999997,0.69099999999999995,0.69499999999999995,0.80600000000000005,0.80200000000000005,0.80700000000000005,0.79400000000000004,0.78300000000000003,0.79700000000000004,0.67300000000000004,0.86299999999999999,0.67400000000000004,0.76200000000000001,0.67900000000000005,0.64800000000000002,0.8]
[null,"1.7","Plan Category",null,"Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","New","New","New","New","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","New","New","New","Renewing","Renewing","Renewing","New","New","Renewing","Renewing","New","New","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Renewing","New","New","New","New","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","New","New","New","Renewing","Renewing","New","New","Renewing","Renewing","New","New","Terminated","Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","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","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","EPO","EPO","EPO","EPO","EPO","EPO","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","No","No","No","No","No","No"]
[null,"1.10","Effective Date of Proposed Rates",null,"2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01"]
[null,"1.11","Cumulative Rate Change %  (over 12 mos prior)",null,0,0.1011,0.1167,0.12790000000000001,0.13109999999999999,0.1137,0.11,0.1113,0.1082,0.1084,0.1201,9.0200000000000002E-2,0,0,0,0,8.2900000000000001E-2,0.12909999999999999,0.1027,0.1012,0.1263,0.1082,0,0,0,0.10730000000000001,0.1134,0.1021,0,0,0.1096,0.1348,0,0,0,0,0,0,0,0,0,0,0,0,0,9.2600000000000002E-2,0,0,0,0,7.6499999999999999E-2,0.12989999999999999,9.7500000000000003E-2,0,0.14449999999999999,0.1118,0,0,0,0,0.1147,0,0,0.109,0,0,0,0,0,9.7199999999999995E-2,0.121,0.11899999999999999,0.1333,0.1203,9.9500000000000005E-2,0.1138,0.10539999999999999,0.1235,0.1085,0,0,0,0,0,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.1138},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((P16:AW16=\"Renewing\")*((P14:AW14=\"Platinum\")+(P14:AW14=\"Gold\")+(P14:AW14=\"Silver\")+(P14:AW14=\"Bronze\")+(P14:AW14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+P20:AW20,P34:AW34,P35:AW35,--(P16:AW16=\"Renewing\")*((P14:AW14=\"Platinum\")+(P14:AW14=\"Gold\")+(P14:AW14=\"Silver\")+(P14:AW14=\"Bronze\")+(P14:AW14=\"Catastrophic\")))/SUMPRODUCT(P34:AW34,P35:AW35,--(P16:AW16=\"Renewing\")*((P14:AW14=\"Platinum\")+(P14:AW14=\"Gold\")+(P14:AW14=\"Silver\")+(P14:AW14=\"Bronze\")+(P14:AW14=\"Catastrophic\"))), 4)-1, 4))","v":0.1123},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,null,null,null,{"$f":"IF(SUMPRODUCT((AX16:BU16=\"Renewing\")*((AX14:BU14=\"Platinum\")+(AX14:BU14=\"Gold\")+(AX14:BU14=\"Silver\")+(AX14:BU14=\"Bronze\")+(AX14:BU14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+AX20:BU20,AX34:BU34,AX35:BU35,--(AX16:BU16=\"Renewing\")*((AX14:BU14=\"Platinum\")+(AX14:BU14=\"Gold\")+(AX14:BU14=\"Silver\")+(AX14:BU14=\"Bronze\")+(AX14:BU14=\"Catastrophic\")))/SUMPRODUCT(AX34:BU34,AX35:BU35,--(AX16:BU16=\"Renewing\")*((AX14:BU14=\"Platinum\")+(AX14:BU14=\"Gold\")+(AX14:BU14=\"Silver\")+(AX14:BU14=\"Bronze\")+(AX14:BU14=\"Catastrophic\"))), 4)-1, 4))","v":0.108},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.1157},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((CF16:CL16=\"Renewing\")*((CF14:CL14=\"Platinum\")+(CF14:CL14=\"Gold\")+(CF14:CL14=\"Silver\")+(CF14:CL14=\"Bronze\")+(CF14:CL14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+CF20:CL20,CF34:CL34,CF35:CL35,--(CF16:CL16=\"Renewing\")*((CF14:CL14=\"Platinum\")+(CF14:CL14=\"Gold\")+(CF14:CL14=\"Silver\")+(CF14:CL14=\"Bronze\")+(CF14:CL14=\"Catastrophic\")))/SUMPRODUCT(CF34:CL34,CF35:CL35,--(CF16:CL16=\"Renewing\")*((CF14:CL14=\"Platinum\")+(CF14:CL14=\"Gold\")+(CF14:CL14=\"Silver\")+(CF14:CL14=\"Bronze\")+(CF14:CL14=\"Catastrophic\"))), 4)-1, 4))","v":0}]
[null,"1.13","Submission Level Rate Increase %",null,{"$f":"IF(SUMPRODUCT((E16:CL16=\"Renewing\")*((E14:CL14=\"Platinum\")+(E14:CL14=\"Gold\")+(E14:CL14=\"Silver\")+(E14:CL14=\"Bronze\")+(E14:CL14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:CL20,E34:CL34,E35:CL35,--(E16:CL16=\"Renewing\")*((E14:CL14=\"Platinum\")+(E14:CL14=\"Gold\")+(E14:CL14=\"Silver\")+(E14:CL14=\"Bronze\")+(E14:CL14=\"Catastrophic\")))/SUMPRODUCT(E34:CL34,E35:CL35,--(E16:CL16=\"Renewing\")*((E14:CL14=\"Platinum\")+(E14:CL14=\"Gold\")+(E14:CL14=\"Silver\")+(E14:CL14=\"Bronze\")+(E14:CL14=\"Catastrophic\"))), 4)-1, 4))","v":0.1135}]
[]
["Worksheet 1 Totals",null,"Section II: Experience Period and Current Plan Level Information"]
[null,"2.1","Plan ID (Standard Component ID)","Total",{"$f":"E13","v":"36239KY0470137"},"36239KY0980051","36239KY0980052","36239KY0980053","36239KY0980054","36239KY0980045","36239KY0980046","36239KY0980047","36239KY0980048","36239KY0980049","36239KY0980050","36239KY0990238","36239KY0990270","36239KY0990273","36239KY0990276","36239KY0990274","36239KY0990220","36239KY0990257","36239KY0990260","36239KY0990263","36239KY0990265","36239KY0990266","36239KY0990269","36239KY0990272","36239KY0990271","36239KY0990237","36239KY0990261","36239KY0990262","36239KY0990275","36239KY0990278","36239KY0990190","36239KY0990242",{"$f":"AK13","v":"36239KY0990277"},"36239KY0990281","36239KY0990199","36239KY0990165","36239KY0990216","36239KY0990225","36239KY0990052","36239KY0990234","36239KY0990240","36239KY0990250","36239KY0990246","36239KY0990244","36239KY0990253","36239KY1170073","36239KY1170129","36239KY1170126","36239KY1170130","36239KY1170132","36239KY1170056","36239KY1170115","36239KY1170117","36239KY1170120","36239KY1170122","36239KY1170123","36239KY1170131","36239KY1170128","36239KY1170127","36239KY1170118","36239KY1170119","36239KY1170136","36239KY1170125","36239KY1170037",{"$f":"BQ13","v":"36239KY1170075"},"36239KY1170135","36239KY1170133","36239KY1170032","36239KY1170074","36239KY1180033","36239KY1180034","36239KY1180035","36239KY1180036","36239KY1180028","36239KY1180029","36239KY1180030","36239KY1180031","36239KY1180032","36239KY1180037","36239KY1200003","36239KY1200008","36239KY1200007","36239KY1200010","36239KY1200002","36239KY1200001","36239KY1200005"]
[{"$f":"'Wksh 1 - Market Experience'!E14","v":175920117.49000001},"2.2","Allowed Claims",{"$f":"SUM(E26:XFD26)","v":175409385.70999995},{"$f":"79372448.45","v":79372448.450000003},{"$f":"2801515.69","v":2801515.69},{"$f":"3417040.48","v":3417040.48},{"$f":"3075958.93","v":3075958.93},{"$f":"5080608.07","v":5080608.07},{"$f":"5049398.86","v":5049398.8600000003},{"$f":"10089252.14","v":10089252.140000001},{"$f":"8195405.69","v":8195405.6900000004},{"$f":"9973823.5","v":9973823.5},{"$f":"6444141.51","v":6444141.5099999998},{"$f":"13074429.98","v":13074429.98},{"$f":"83413.74","v":83413.740000000005},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"2523785.46","v":2523785.46},{"$f":"4318394.45","v":4318394.45},{"$f":"2251706.67","v":2251706.67},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"54518.28","v":54518.28},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"4810700.29","v":4810700.29},{"$f":"2344914.61","v":2344914.61},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"4178.74","v":4178.74},{"$f":"1964521.84","v":1964521.84},{"$f":"803.32","v":803.32},{"$f":"2273997.9","v":2273997.9},{"$f":"645095.28","v":645095.28},{"$f":"235910.91","v":235910.91},{"$f":"647592.57","v":647592.56999999995},{"$f":"66130.69","v":66130.69},{"$f":"892175.34","v":892175.34},{"$f":"304320.02","v":304320.02},{"$f":"144204.36","v":144204.35999999999},{"$f":"58242.57","v":58242.57},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"139011.6","v":139011.6},{"$f":"414547.81","v":414547.81},{"$f":"112167.63","v":112167.63},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"276237.58","v":276237.58},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"963.73","v":963.73},{"$f":"15227.42","v":15227.42},{"$f":"269153.12","v":269153.12},{"$f":"119616.89","v":119616.89},{"$f":"20471.2","v":20471.2},{"$f":"203005.92","v":203005.92},{"$f":"1173896.71","v":1173896.71},{"$f":"92591.68","v":92591.679999999993},{"$f":"69602.38","v":69602.38},{"$f":"132812.39","v":132812.39000000001},{"$f":"1432701.42","v":1432701.42},{"$f":"528185.54","v":528185.54},{"$f":"7095.84","v":7095.84},{"$f":"131208.75","v":131208.75},{"$f":"21148.78","v":21148.78},{"$f":"17395.24","v":17395.240000000002},{"$f":"17389","v":17389},{"$f":"2002.64","v":2002.64},{"$f":"14322.1","v":14322.1}]
[{"$f":"'Wksh 1 - Market Experience'!E15","v":0},"2.3","Reinsurance",{"$f":"SUM(E27:XFD27)","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"2.4","Member Cost Sharing",{"$f":"SUM(E28:XFD28)","v":33381767.619999994},{"$f":"14323932.82","v":14323932.82},{"$f":"746092.77","v":746092.77},{"$f":"963428.85","v":963428.85},{"$f":"581014.97","v":581014.97},{"$f":"1365839.68","v":1365839.68},{"$f":"931990.7","v":931990.7},{"$f":"1833042.78","v":1833042.78},{"$f":"1462489.96","v":1462489.96},{"$f":"1810828.45","v":1810828.45},{"$f":"1120119.38","v":1120119.3799999999},{"$f":"2643773.77","v":2643773.77},{"$f":"64070.91","v":64070.91},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"661053.77","v":661053.77},{"$f":"1003393.97","v":1003393.97},{"$f":"698891.64","v":698891.64},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"19073.21","v":19073.21},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"313766.38","v":313766.38},{"$f":"246780.01","v":246780.01},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"3536.81","v":3536.81},{"$f":"432340.82","v":432340.82},{"$f":"823.09","v":823.09},{"$f":"428574.8","v":428574.8},{"$f":"197884.13","v":197884.13},{"$f":"15855.2","v":15855.2},{"$f":"245277.92","v":245277.92},{"$f":"33363.91","v":33363.910000000003},{"$f":"120458.17","v":120458.17},{"$f":"26505.19","v":26505.19},{"$f":"25437.84","v":25437.84},{"$f":"27423.22","v":27423.22},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"67870.72","v":67870.720000000001},{"$f":"123783.88","v":123783.88},{"$f":"62083.33","v":62083.33},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"18521.55","v":18521.55},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"434.75","v":434.75},{"$f":"5791.33","v":5791.33},{"$f":"41503.83","v":41503.83},{"$f":"27302.85","v":27302.85},{"$f":"10352.97","v":10352.969999999999},{"$f":"68564.81","v":68564.81},{"$f":"51787.49","v":51787.49},{"$f":"33378.58","v":33378.58},{"$f":"23272.07","v":23272.07},{"$f":"36990.66","v":36990.660000000003},{"$f":"287864.07","v":287864.07},{"$f":"121628.82","v":121628.82},{"$f":"5542.98","v":5542.98},{"$f":"17124.1","v":17124.099999999999},{"$f":"3255.36","v":3255.36},{"$f":"6943.44","v":6943.44},{"$f":"16648.76","v":16648.759999999998},{"$f":"1718.15","v":1718.15},{"$f":"2338","v":2338}]
[null,"2.5","Cost Sharing Reduction",{"$f":"SUM(E29:XFD29)","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[{"$f":"'Wksh 1 - Market Experience'!E16","v":142498734.28999999},"2.6","Incurred Claims",{"$f":"D26-D27-D28-D29","v":142027618.08999994},65048515.630000003,2055422.92,2453611.63,2494943.96,3714768.3900000006,4117408.16,8256209.3600000003,6732915.7300000004,8162995.0499999998,5324022.13,10430656.210000001,19342.830000000002,0,0,0,0,1862731.69,3315000.4800000004,1552815.0299999998,0,0,0,0,0,0,35445.07,0,0,0,0,4496933.91,{"$f":"AJ26-AJ27-AJ28-AJ29","v":2098134.5999999996},0,0,641.92999999999984,1532181.02,-19.769999999999982,1845423.0999999999,447211.15,220055.71,402314.64999999991,32766.78,771717.16999999993,277814.83,118766.51999999999,30819.35,0,0,0,0,71140.88,290763.93,50084.3,0,0,0,0,0,0,0,0,0,0,{"$f":"BP26-BP27-BP28-BP29","v":257716.03000000003},0,0,0,528.98,9436.09,227649.28999999998,92314.040000000008,10118.230000000001,134441.11000000002,1122109.22,59213.099999999991,46330.310000000005,95821.73000000001,1144837.3499999999,406556.72000000003,1552.8600000000006,114084.65,17893.419999999998,10451.800000000003,740.2400000000016,284.49,11984.1]
[{"$f":"'Wksh 1 - Market Experience'!E17","v":2204451.7400000002},"2.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E31:XFD31)","v":2204451.7399999993},{"$f":"0","v":0},{"$f":"-213357.66","v":-213357.66},{"$f":"-148625.53","v":-148625.53},{"$f":"327878.39","v":327878.39},{"$f":"945491.37","v":945491.37},{"$f":"-215464.88","v":-215464.88},{"$f":"252605.92","v":252605.92},{"$f":"-1502.16","v":-1502.16},{"$f":"755079.01","v":755079.01},{"$f":"688533.59","v":688533.59},{"$f":"-49655.85","v":-49655.85},{"$f":"-166905.62","v":-166905.62},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-266871.05","v":-266871.05},{"$f":"564202.71","v":564202.71},{"$f":"-254607.05","v":-254607.05},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-18719.7","v":-18719.7},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"934209.65","v":934209.65},{"$f":"-326367.2","v":-326367.2},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-10007.03","v":-10007.030000000001},{"$f":"114870.35","v":114870.35},{"$f":"-522","v":-522},{"$f":"9580.35","v":9580.35},{"$f":"-180847.07","v":-180847.07},{"$f":"144177.54","v":144177.54},{"$f":"-15997.75","v":-15997.75},{"$f":"-5883.92","v":-5883.92},{"$f":"157108.41","v":157108.41},{"$f":"31358.09","v":31358.09},{"$f":"-127447.02","v":-127447.02},{"$f":"-81142.59","v":-81142.59},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-234118.8","v":-234118.8},{"$f":"-97296.99","v":-97296.99},{"$f":"-170591.1","v":-170591.1},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"169262.46","v":169262.46},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-10392.89","v":-10392.89},{"$f":"-8913.69","v":-8913.69},{"$f":"-102832.03","v":-102832.03},{"$f":"-55072.93","v":-55072.93},{"$f":"-5257.83","v":-5257.83},{"$f":"29713.21","v":29713.21},{"$f":"210600.88","v":210600.88},{"$f":"-150649.1","v":-150649.1},{"$f":"-42034.87","v":-42034.87},{"$f":"43263.78","v":43263.78},{"$f":"-121459.76","v":-121459.76},{"$f":"10668.67","v":10668.67},{"$f":"-41980.96","v":-41980.959999999999},{"$f":"-58127.34","v":-58127.34},{"$f":"-6832.57","v":-6832.57},{"$f":"-16554.54","v":-16554.54},{"$f":"70791.5","v":70791.5},{"$f":"-15722.24","v":-15722.24},{"$f":"-33182.42","v":-33182.42}]
[{"$f":"'Wksh 1 - Market Experience'!E18","v":186849109.05000001},"2.8","Premium",{"$f":"SUM(E32:XFD32)","v":186827566.22999999},{"$f":"92177924.11","v":92177924.109999999},{"$f":"3177673.61","v":3177673.61},{"$f":"3482237.68","v":3482237.68},{"$f":"2170800.91","v":2170800.91},{"$f":"4525758.9","v":4525758.9000000004},{"$f":"5836636.52","v":5836636.5199999996},{"$f":"11340309.46","v":11340309.460000001},{"$f":"9024952.1","v":9024952.0999999996},{"$f":"10466747.87","v":10466747.869999999},{"$f":"5381541","v":5381541},{"$f":"11773055.01","v":11773055.01},{"$f":"298496.04","v":298496.03999999998},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"2317752.87","v":2317752.87},{"$f":"3220297.99","v":3220297.99},{"$f":"3086605.41","v":3086605.41},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"64051.53","v":64051.53},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"3671132","v":3671132},{"$f":"2689611.18","v":2689611.18},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"21485.29","v":21485.29},{"$f":"2533746.05","v":2533746.0499999998},{"$f":"797.39","v":797.39},{"$f":"1764170.81","v":1764170.81},{"$f":"792802.14","v":792802.14},{"$f":"124055.89","v":124055.89},{"$f":"805508.56","v":805508.56},{"$f":"91563.05","v":91563.05},{"$f":"526579.38","v":526579.38},{"$f":"152264.58","v":152264.57999999999},{"$f":"267477.99","v":267477.99},{"$f":"116056.82","v":116056.82},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"354059.49","v":354059.49},{"$f":"477298.35","v":477298.35},{"$f":"268697.25","v":268697.25},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"151855.34","v":151855.34},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"12477.27","v":12477.27},{"$f":"11918.9","v":11918.9},{"$f":"158751.4","v":158751.4},{"$f":"174625.56","v":174625.56},{"$f":"51657.32","v":51657.32},{"$f":"176877.89","v":176877.89},{"$f":"205689.19","v":205689.19},{"$f":"234159.49","v":234159.49},{"$f":"140967.54","v":140967.54},{"$f":"220801.74","v":220801.74},{"$f":"1313084.23","v":1313084.23},{"$f":"569962.24","v":569962.23999999999},{"$f":"52655.95","v":52655.95},{"$f":"216946.13","v":216946.13},{"$f":"19065.22","v":19065.22},{"$f":"34327.41","v":34327.410000000003},{"$f":"7483.66","v":7483.66},{"$f":"23086.96","v":23086.959999999999},{"$f":"49025.56","v":49025.56}]
[{"$f":"'Wksh 1 - Market Experience'!E19","v":283507},"2.9","Experience Period Member Months",{"$f":"SUM(E33:XFD33)","v":283507},{"$f":"146757","v":146757},{"$f":"4872","v":4872},{"$f":"5865","v":5865},{"$f":"3592","v":3592},{"$f":"7793","v":7793},{"$f":"7662","v":7662},{"$f":"14718","v":14718},{"$f":"11968","v":11968},{"$f":"14490","v":14490},{"$f":"7978","v":7978},{"$f":"17498","v":17498},{"$f":"548","v":548},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"3581","v":3581},{"$f":"5214","v":5214},{"$f":"5073","v":5073},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"93","v":93},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"4228","v":4228},{"$f":"3095","v":3095},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"45","v":45},{"$f":"2931","v":2931},{"$f":"1","v":1},{"$f":"2601","v":2601},{"$f":"1188","v":1188},{"$f":"165","v":165},{"$f":"1337","v":1337},{"$f":"158","v":158},{"$f":"759","v":759},{"$f":"201","v":201},{"$f":"288","v":288},{"$f":"180","v":180},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"676","v":676},{"$f":"830","v":830},{"$f":"495","v":495},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"236","v":236},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"26","v":26},{"$f":"30","v":30},{"$f":"279","v":279},{"$f":"294","v":294},{"$f":"130","v":130},{"$f":"421","v":421},{"$f":"272","v":272},{"$f":"358","v":358},{"$f":"255","v":255},{"$f":"367","v":367},{"$f":"2396","v":2396},{"$f":"944","v":944},{"$f":"65","v":65},{"$f":"338","v":338},{"$f":"24","v":24},{"$f":"50","v":50},{"$f":"12","v":12},{"$f":"49","v":49},{"$f":"81","v":81}]
[null,"2.10","Current Enrollment",{"$f":"SUM(E34:XFD34)","v":11984},{"$f":"0","v":0},{"$f":"343","v":343},{"$f":"560","v":560},{"$f":"312","v":312},{"$f":"711","v":711},{"$f":"707","v":707},{"$f":"1244","v":1244},{"$f":"1335","v":1335},{"$f":"1361","v":1361},{"$f":"844","v":844},{"$f":"1493","v":1493},{"$f":"69","v":69},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"270","v":270},{"$f":"456","v":456},{"$f":"568","v":568},{"$f":"31","v":31},{"$f":"19","v":19},{"$f":"35","v":35},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"9","v":9},{"$f":"8","v":8},{"$f":"3","v":3},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"511","v":511},{"$f":"333","v":333},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"19","v":19},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"30","v":30},{"$f":"54","v":54},{"$f":"46","v":46},{"$f":"0","v":0},{"$f":"11","v":11},{"$f":"20","v":20},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"17","v":17},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"28","v":28},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"24","v":24},{"$f":"39","v":39},{"$f":"20","v":20},{"$f":"29","v":29},{"$f":"21","v":21},{"$f":"38","v":38},{"$f":"32","v":32},{"$f":"71","v":71},{"$f":"196","v":196},{"$f":"67","v":67},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"2.11","Current Premium PMPM",{"$f":"SUMPRODUCT(E35:XFD35,E34:XFD34)/D34","v":741.47525867823754},{"$f":"0","v":0},{"$f":"696.81","v":696.81},{"$f":"655.71","v":655.71},{"$f":"651.74","v":651.74},{"$f":"629.27","v":629.27},{"$f":"788.1","v":788.1},{"$f":"789.58","v":789.58},{"$f":"805.61","v":805.61},{"$f":"778.22","v":778.22},{"$f":"725.24","v":725.24},{"$f":"745.28","v":745.28},{"$f":"580.52","v":580.52},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"741.41","v":741.41},{"$f":"673.3","v":673.3},{"$f":"684.43","v":684.43},{"$f":"682.34","v":682.34},{"$f":"595.95","v":595.95000000000005},{"$f":"601.85","v":601.85},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"666.87","v":666.87},{"$f":"514.03","v":514.03},{"$f":"547.15","v":547.15},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"882.25","v":882.25},{"$f":"914.42","v":914.42},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"620.71","v":620.71},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"603.3","v":603.29999999999995},{"$f":"613.58","v":613.58000000000004},{"$f":"625.72","v":625.72},{"$f":"0","v":0},{"$f":"473.76","v":473.76},{"$f":"461.1","v":461.1},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"692.53","v":692.53},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"681.5","v":681.5},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"624.73","v":624.73},{"$f":"621.9","v":621.9},{"$f":"443.03","v":443.03},{"$f":"470.47","v":470.47},{"$f":"828.67","v":828.67},{"$f":"664.99","v":664.99},{"$f":"577.99","v":577.99},{"$f":"608.21","v":608.21},{"$f":"646.71","v":646.71},{"$f":"647.85","v":647.85},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"2.12","Loss Ratio",{"$f":"D30/(D31+D32)","v":0.75134159607046147},0.70568431929943143,0.69338861129158658,0.73602192444612957,0.99850507426063029,0.67896151824178941,0.73248219831977956,0.71217714348571393,0.74615759767821144,0.72742122448426161,0.87709336204384269,0.88972968229122384,0.14699269141325033,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.90825891176898721,0.8759413044896518,0.54831070947371585,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.78190247338349228,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.9764604348083491,{"$f":"AJ30/(AJ31+AJ32)","v":0.8878197163544661},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},5.5925723933766949E-2,0.57848355088339709,-7.1789099095827674E-2,1.0404069869642818,0.73079082423485764,0.82038883072851876,0.50957459341183675,0.38243595610739739,1.128756694631039,1.5129658554687178,0.84814466399825705,0.88271601579069592,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.59313382305871343,0.76516549835505854,0.51051131860744725,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BP30/(BP31+BP32)","v":0.8025591543041215},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.2537828994713055,3.1399103556822991,4.0710274454093458,0.77216235226276497,0.21806769858892849,0.65075944704297528,2.6954984057150342,0.70905069417110855,0.46830142156276588,0.36287104049025409,0.96073669081333979,0.70019820336468142,0.14546711519167707,0.71833219482405064,1.4627590914478872,0.588076095757185,9.4568953931234573E-3,3.8628759817073838E-2,0.75642202240212486]
[null,null,"Per Member Per Month"]
[null,"2.13","Allowed Claims",{"$f":"D26/D33","v":618.71271506523635},540.84267496610039,575.02374589490967,582.61559761295825,856.33600501113585,651.94508789939698,659.01838423388153,685.50428998505231,684.7765449532086,688.32460317460323,807.73897092003006,747.19567836324154,152.21485401459856,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},704.77114213906725,828.23061948599923,443.86096392667059,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},586.21806451612906,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1137.8193684957428,{"$f":"AJ26/AJ33","v":757.64607754442648},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},92.86088888888888,670.2565131354487,803.32,874.27831603229527,543.00949494949498,1429.763090909091,484.36243081525799,418.54867088607597,1175.461581027668,1514.0299502487562,500.70958333333328,323.56983333333335,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},205.63846153846154,499.45519277108434,226.60127272727274,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BP26/BP33","v":1170.4982203389832},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},37.066538461538464,507.58066666666667,964.706523297491,406.86017006802723,157.47076923076924,482.19933491686464,4315.796727941176,258.63597765363124,272.95050980392159,361.88662125340602,597.95551752921529,559.51858050847466,109.16676923076923,388.19156804733728,881.19916666666666,347.90480000000002,1449.0833333333333,40.870204081632657,176.81604938271605]
[null,"2.14","Reinsurance",{"$f":"D27/D33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$f":"AJ27/AJ33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BP27/BP33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2.15","Member Cost Sharing",{"$f":"D28/D33","v":117.74583209585651},97.603063703945978,153.13891009852216,164.26749360613812,161.75249721603564,175.26494033106633,121.63804489689376,124.54428454953118,122.20003008021391,124.97090752242926,140.40102531962896,151.09005429191907,116.9177189781022,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},184.60032672437868,192.44226505561949,137.76693081017149,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},205.08827956989245,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},74.211537369914851,{"$f":"AJ28/AJ33","v":79.735059773828766},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},78.595777777777784,147.50625042647562,823.09,164.77308727412534,166.56913299663299,96.092121212121214,183.45394166043383,211.16398734177218,158.7064163372859,131.86661691542287,88.325833333333335,152.35122222222222,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},100.40047337278106,149.13720481927712,125.42086868686869,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BP28/BP33","v":78.481144067796606},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},16.721153846153847,193.04433333333333,148.75924731182798,92.866836734693877,79.638230769230759,162.86178147268407,190.39518382352941,93.236256983240224,91.263019607843134,100.79198910081745,120.143601836394,128.84408898305085,85.276615384615383,50.663017751479288,135.64000000000001,138.86879999999999,1387.3966666666665,35.064285714285717,28.864197530864196]
[null,"2.16","Cost Sharing Reduction",{"$f":"D29/D33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$f":"AJ29/AJ33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BP29/BP33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2.17","Incurred Claims",{"$f":"D30/D33","v":500.96688296937975},443.23961126215448,421.88483579638751,418.34810400682011,694.58350779510022,476.68014756833065,537.38033933698773,560.96000543552111,562.57651487299472,563.35369565217388,667.3379456004011,596.1056240713225,35.297135036496357,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},520.1708154146886,635.78835443037985,306.09403311649908,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},381.12978494623655,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1063.6078311258279,{"$f":"AJ30/AJ33","v":677.9110177705976},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},14.265111111111107,522.75026270897308,-19.769999999999982,709.50522875816989,376.44036195286196,1333.6709696969697,300.90848915482417,207.38468354430378,1016.755164690382,1382.1633333333334,412.38374999999996,171.2186111111111,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},105.23798816568048,350.3179879518072,101.18040404040404,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BP30/BP33","v":1092.0170762711866},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},20.345384615384617,314.53633333333335,815.94727598566305,313.99333333333334,77.832538461538476,319.33755344418057,4125.4015441176471,165.39972067039105,181.68749019607844,261.09463215258859,477.81191569282129,430.67449152542378,23.890153846153854,337.528550295858,745.55916666666656,209.03600000000006,61.686666666666802,5.8059183673469388,147.95185185185187]
[null,"2.18","Risk Adjustment Transfer Amount",{"$f":"D31/D33","v":7.7756518886658856},0,-43.792623152709361,-25.341096334185849,91.280175389755016,121.32572436802258,-28.12123205429392,17.163060198396522,-0.12551470588235294,52.110352657004832,86.304034845826024,-2.8378014630243458,-304.57229927007296,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-74.524169226473049,108.20918872266972,-50.188655627833626,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-201.28709677419354,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},220.95781693472091,{"$f":"AJ31/AJ33","v":-105.44982229402262},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-222.37844444444445,39.191521664960767,-522,3.6833333333333336,-152.2281734006734,873.80327272727277,-11.965407629020195,-37.24,206.99395256916998,156.01039800995025,-442.52437500000002,-450.79216666666667,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-346.32958579881654,-117.22528915662652,-344.62848484848485,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BP31/BP33","v":717.21381355932203},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-399.72653846153844,-297.12299999999999,-368.57358422939069,-187.32289115646259,-40.44484615384615,70.577695961995246,774.26794117647057,-420.80754189944133,-164.84262745098042,117.88495912806539,-50.692721202003334,11.30155720338983,-645.86092307692309,-171.97437869822485,-284.69041666666664,-331.0908,5899.291666666667,-320.8620408163265,-409.65950617283949]
[null,"2.19","Premium",{"$f":"D32/D33","v":658.98748965634002},628.09899432395048,652.23185755336613,593.73191474850807,604.3432377505568,580.74668292056981,761.76409814669796,770.50614621551847,754.09024899732617,722.34284817115247,674.54763098520937,672.82289461652761,544.70080291970794,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},647.23621055571073,617.62523782125049,608.43788882318154,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},688.72612903225809,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},868.29044465468303,{"$f":"AJ32/AJ33","v":869.01815185783528},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},477.45088888888893,864.46470487888087,797.39,678.26636293733179,667.34186868686868,751.85387878787878,602.4746148092745,579.51297468354437,693.78047430830043,757.53522388059696,928.74302083333328,644.7601111111112,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},523.75664201183429,575.05825301204811,542.82272727272732,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BP32/BP33","v":643.45483050847452},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},479.89500000000004,397.29666666666668,569.00143369175623,593.96448979591833,397.36399999999998,420.13750593824233,756.2102573529412,654.07678770949713,552.81388235294116,601.6396185286103,548.03181552587648,603.77355932203386,810.09153846153845,641.85245562130183,794.38416666666672,686.54820000000007,623.63833333333332,471.16244897959183,605.25382716049376]
[]
[null,null,"Section III: Plan Adjustment Factors"]
[null,"3.1","Plan ID (Standard Component ID)",null,{"$f":"E13","v":"36239KY0470137"},"36239KY0980051","36239KY0980052","36239KY0980053","36239KY0980054","36239KY0980045","36239KY0980046","36239KY0980047","36239KY0980048","36239KY0980049","36239KY0980050","36239KY0990238","36239KY0990270","36239KY0990273","36239KY0990276","36239KY0990274","36239KY0990220","36239KY0990257","36239KY0990260","36239KY0990263","36239KY0990265","36239KY0990266","36239KY0990269","36239KY0990272","36239KY0990271","36239KY0990237","36239KY0990261","36239KY0990262","36239KY0990275","36239KY0990278","36239KY0990190","36239KY0990242",{"$f":"AK13","v":"36239KY0990277"},"36239KY0990281","36239KY0990199","36239KY0990165","36239KY0990216","36239KY0990225","36239KY0990052","36239KY0990234","36239KY0990240","36239KY0990250","36239KY0990246","36239KY0990244","36239KY0990253","36239KY1170073","36239KY1170129","36239KY1170126","36239KY1170130","36239KY1170132","36239KY1170056","36239KY1170115","36239KY1170117","36239KY1170120","36239KY1170122","36239KY1170123","36239KY1170131","36239KY1170128","36239KY1170127","36239KY1170118","36239KY1170119","36239KY1170136","36239KY1170125","36239KY1170037",{"$f":"BQ13","v":"36239KY1170075"},"36239KY1170135","36239KY1170133","36239KY1170032","36239KY1170074","36239KY1180033","36239KY1180034","36239KY1180035","36239KY1180036","36239KY1180028","36239KY1180029","36239KY1180030","36239KY1180031","36239KY1180032","36239KY1180037","36239KY1200003","36239KY1200008","36239KY1200007","36239KY1200010","36239KY1200002","36239KY1200001","36239KY1200005"]
[null,"3.2","Market Adjusted Index Rate",null,{"$f":"'Wksh 1 - Market Experience'!F46","v":828.39435245199945}]
[null,"3.3","AV and Cost Sharing Design of Plan",null,0,0.7409,0.74439999999999995,0.72409999999999997,0.70779999999999998,0.85709999999999997,0.85060000000000002,0.84770000000000001,0.85670000000000002,0.83709999999999996,0.81989999999999996,0.62290000000000001,0.56030000000000002,0.67669999999999997,0.59560000000000002,0.6583,0.72419999999999995,0.73099999999999998,0.75560000000000005,0.75249999999999995,0.70909999999999995,0.73450000000000004,0.6976,0.71399999999999997,0.75060000000000004,0.84770000000000001,0.82089999999999996,0.85140000000000005,0.7651,0.83040000000000003,0.9869,0.99550000000000005,0.99929999999999997,0.97770000000000001,0,0,0,0,0,0,0,0,0,0,0,0.62280000000000002,0.67669999999999997,0.59550000000000003,0.6583,0.56030000000000002,0.72419999999999995,0.73099999999999998,0.75549999999999995,0.75249999999999995,0.70909999999999995,0.73450000000000004,0.69750000000000001,0.71399999999999997,0.75049999999999994,0.85140000000000005,0.82079999999999997,0.83030000000000004,0.76500000000000001,0.9869,0.99539999999999995,0.97770000000000001,0.99929999999999997,0,0,0.7409,0.74429999999999996,0.72399999999999998,0.70779999999999998,0.85699999999999998,0.85060000000000002,0.85670000000000002,0.83709999999999996,0.81979999999999997,0.84770000000000001,0,0,0,0,0,0,0]
[null,"3.4","Provider Network Adjustment",null,0,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,1.0093000000000001,0,0,0,0,0,0,0,0,0,0,0,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0,0,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0.87339999999999995,0,0,0,0,0,0,0]
[null,"3.5","Benefits in Addition to EHB",null,0,1.0085,1.0085,1.0085999999999999,1.0087999999999999,1.0079,1.0079,1.0079,1.0079,1.008,1.0081,1.0095000000000001,1.0101,1.0089999999999999,1.0097,1.0091000000000001,1.0085999999999999,1.0085999999999999,1.0084,1.0084,1.0213000000000001,1.0085999999999999,1.0087999999999999,1.0086999999999999,1.0085,1.0079,1.0188999999999999,1.0184,1.0084,1.008,1.0073000000000001,1.0073000000000001,1.0073000000000001,1.0073000000000001,0,0,0,0,0,0,0,0,0,0,0,1.0094000000000001,1.0089999999999999,1.0097,1.0091000000000001,1.0101,1.0085999999999999,1.0085999999999999,1.0084,1.0084,1.0212000000000001,1.0085,1.0087999999999999,1.0086999999999999,1.0084,1.0183,1.0187999999999999,1.008,1.0083,1.0073000000000001,1.0073000000000001,1.0073000000000001,1.0072000000000001,0,0,1.0085,1.0085,1.0085999999999999,1.0086999999999999,1.0078,1.0079,1.0078,1.0079,1.008,1.0079,0,0,0,0,0,0,0]
[null,null,"Administrative Costs"]
[null,"3.6","Administrative Expense",null,0,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,0,0,0,0,0,0,0,0,0,0,0,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,0,0,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,6.7100000000000007E-2,0,0,0,0,0,0,0]
[null,"3.7","Taxes and Fees",null,0,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,0,0,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,2.8199999999999999E-2,0,0,0,0,0,0,0]
[null,"3.8","Profit & Risk Load",null,0,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,0,0,0,0,0,0,0,0,0,0,0,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,0,0,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,4.7399999999999998E-2,0,0,0,0,0,0,0]
[null,"3.9","Catastrophic Adjustment",null,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0]
[null,"3.10","Plan Adjusted Index Rate",null,{"$f":"($E$48*PRODUCT(E49:E51)*E56)/(1-SUM(E53:E55))","v":0},728.71897181880558,732.16142883239149,712.26579740774821,696.37025275705844,842.50700265022374,836.11767174691443,833.26704719005329,842.11381305617397,822.92916274562481,806.1002950727858,613.26648778622416,551.96249939111635,665.90445698518158,586.5048723126323,647.8621981888856,712.36416307511558,719.05302845610242,743.1035999232364,740.05486890184659,706.29380376777294,722.49582681396362,686.33496513608941,702.40049923573929,738.25949554217232,833.26704719005329,815.72992915732004,845.62266640759822,752.4464853113659,816.34258361482125,969.5195299222122,977.96807380439998,{"$f":"($E$48*PRODUCT(AK49:AK51)*AK56)/(1-SUM(AK53:AK55))","v":981.70115133373849},960.48155274591841,0,0,0,0,0,0,0,0,0,0,0,530.55376109839142,576.24190303265391,507.44808204294668,560.62899425163243,477.64197658595168,616.44591303854736,622.23413757412072,642.96124901920223,640.40812691853046,611.13306950815286,625.15138255272961,593.83635087682205,607.82383437282738,638.70604551808242,731.6896012746962,705.7384468768455,706.3388002212638,650.98157338100157,838.97588173393433,{"$f":"($E$48*PRODUCT(BQ49:BQ51)*BQ56)/(1-SUM(BQ53:BQ55))","v":846.20183673924237},831.15484808113058,849.43293884399782,0,0,630.59858316312761,633.49240848740169,616.27567114044234,602.54581228163477,728.90792022674668,723.5362870343356,728.65275992795091,712.05293425398804,697.40641746524375,721.06949273337216,0,0,0,0,0,0,0]
[]
[null,"3.11","Age Calibration Factor",0.67819599864360802,{"$f":"IF(D59<>\"\", D59, \"\")","v":0.67819599864360802}]
[null,"3.12","Geographic Calibration Factor",0.99990000999899997,{"$f":"IF(D60<>\"\", D60, \"\")","v":0.99990000999899997}]
[null,"3.13","Tobacco Calibration Factor",1,{"$f":"IF(D61<>\"\", D61, \"\")","v":1}]
[null,"3.14","Calibrated Plan Adjusted Index Rate",null,{"$f":"E57*(PRODUCT($E$59:$E$61))","v":0},494.16487433576447,496.49930146516812,483.00751302133142,472.22829616465845,571.32774525207617,566.99495987797923,565.06187101876674,571.06111230597787,558.05146019519771,546.63933069072596,415.87329078975733,374.30132835554446,451.56858134815985,397.72548503890351,439.33361712244209,483.07421755289067,487.61012569892711,503.91949609598981,501.85206565938626,478.95773580849635,489.94478430350489,465.42308477601841,476.31757626932404,500.63457238011176,565.06187101876674,553.16945698262998,573.44056466350526,510.25517001461321,553.58491523843281,657.45851994808118,663.18771568377235,{"$f":"AK57*(PRODUCT($E$59:$E$61))","v":665.71922077628687},651.32961288199317,0,0,0,0,0,0,0,0,0,0,0,359.78345949629613,390.76587629989382,344.1148472761721,380.17832279276809,323.90248705611072,418.02934866808152,421.95450687153777,436.01014535318404,434.27880129486567,414.42655972324286,423.932772916489,402.6971672970526,412.18247410445616,433.12457192265333,496.17934189944594,478.58113264756633,478.98824917187068,441.44895336237926,568.93319263118394,{"$f":"BQ57*(PRODUCT($E$59:$E$61))","v":573.83331638978677},563.62952926893172,576.02441779829996,0,0,427.62667318424315,429.58905770148766,417.91390283856816,408.60329855901131,494.2930055768561,490.65034970516888,494.11997418633916,482.863164517043,472.93094865843608,488.97754696105301,0,0,0,0,0,0,0]
[]
[null,null,"Section IV: Projected Plan Level Information"]
[null,"4.1","Plan ID (Standard Component ID)","Total",{"$f":"E13","v":"36239KY0470137"},"36239KY0980051","36239KY0980052","36239KY0980053","36239KY0980054","36239KY0980045","36239KY0980046","36239KY0980047","36239KY0980048","36239KY0980049","36239KY0980050","36239KY0990238","36239KY0990270","36239KY0990273","36239KY0990276","36239KY0990274","36239KY0990220","36239KY0990257","36239KY0990260","36239KY0990263","36239KY0990265","36239KY0990266","36239KY0990269","36239KY0990272","36239KY0990271","36239KY0990237","36239KY0990261","36239KY0990262","36239KY0990275","36239KY0990278","36239KY0990190","36239KY0990242",{"$f":"AK13","v":"36239KY0990277"},"36239KY0990281","36239KY0990199","36239KY0990165","36239KY0990216","36239KY0990225","36239KY0990052","36239KY0990234","36239KY0990240","36239KY0990250","36239KY0990246","36239KY0990244","36239KY0990253","36239KY1170073","36239KY1170129","36239KY1170126","36239KY1170130","36239KY1170132","36239KY1170056","36239KY1170115","36239KY1170117","36239KY1170120","36239KY1170122","36239KY1170123","36239KY1170131","36239KY1170128","36239KY1170127","36239KY1170118","36239KY1170119","36239KY1170136","36239KY1170125","36239KY1170037",{"$f":"BQ13","v":"36239KY1170075"},"36239KY1170135","36239KY1170133","36239KY1170032","36239KY1170074","36239KY1180033","36239KY1180034","36239KY1180035","36239KY1180036","36239KY1180028","36239KY1180029","36239KY1180030","36239KY1180031","36239KY1180032","36239KY1180037","36239KY1200003","36239KY1200008","36239KY1200007","36239KY1200010","36239KY1200002","36239KY1200001","36239KY1200005"]
[null,"4.2","Allowed Claims",{"$f":"SUM(E66:XFD66)","v":127282532.54999994},{"$f":"0","v":0},{"$f":"3658925.65","v":3658925.65},{"$f":"5531024.46","v":5531024.46},{"$f":"2958817.95","v":2958817.95},{"$f":"7411813.47","v":7411813.4699999997},{"$f":"7422168.72","v":7422168.7199999997},{"$f":"12608147.07","v":12608147.07},{"$f":"14143497.16","v":14143497.16},{"$f":"13913457.47","v":13913457.470000001},{"$f":"8542659.8","v":8542659.8000000007},{"$f":"15951998.92","v":15951998.92},{"$f":"547440.52","v":547440.52},{"$f":"110932.41","v":110932.41},{"$f":"113119.32","v":113119.32},{"$f":"112316.65","v":112316.65},{"$f":"112134.08","v":112134.08},{"$f":"2853747.25","v":2853747.25},{"$f":"4890433.28","v":4890433.28},{"$f":"5923927.47","v":5923927.4699999997},{"$f":"173153.8","v":173153.8},{"$f":"189945.34","v":189945.34},{"$f":"308531.55","v":308531.55},{"$f":"484014.12","v":484014.12},{"$f":"478352.72","v":478352.72},{"$f":"485157.71","v":485157.71},{"$f":"51845.66","v":51845.66},{"$f":"41607.17","v":41607.17},{"$f":"21006.16","v":21006.16},{"$f":"7454.3","v":7454.3},{"$f":"7591.8","v":7591.8},{"$f":"5287888.06","v":5287888.0599999996},{"$f":"3543900.67","v":3543900.67},{"$f":"882543.97","v":882543.97},{"$f":"875523.05","v":875523.05},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"150912.79","v":150912.79},{"$f":"31183.74","v":31183.74},{"$f":"30962.21","v":30962.21},{"$f":"30912.08","v":30912.080000000002},{"$f":"30580.49","v":30580.49},{"$f":"290494.83","v":290494.83},{"$f":"484935.6","v":484935.6},{"$f":"454724.46","v":454724.46},{"$f":"95525.33","v":95525.33},{"$f":"95990.52","v":95990.52},{"$f":"173765.53","v":173765.53},{"$f":"53964.24","v":53964.24},{"$f":"53333.11","v":53333.11},{"$f":"54091.97","v":54091.97},{"$f":"105926.31","v":105926.31},{"$f":"104904.37","v":104904.37},{"$f":"20882.79","v":20882.79},{"$f":"20504.48","v":20504.48},{"$f":"238439.81","v":238439.81},{"$f":"61816.14","v":61816.14},{"$f":"29789.96","v":29789.96},{"$f":"30028.88","v":30028.880000000001},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"230046.52","v":230046.52},{"$f":"313192.35","v":313192.34999999998},{"$f":"173351.4","v":173351.4},{"$f":"309744.76","v":309744.76},{"$f":"172660.92","v":172660.92},{"$f":"308255.26","v":308255.26},{"$f":"309105.46","v":309105.46000000002},{"$f":"604904.11","v":604904.11},{"$f":"1848369.7","v":1848369.7},{"$f":"724154.7","v":724154.7},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"4.3","Reinsurance",{"$f":"SUM(E67:XFD67)","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"4.4","Member Cost Sharing",{"$f":"SUM(E68:XFD68)","v":23184969.409999989},{"$f":"0","v":0},{"$f":"906435.68","v":906435.68},{"$f":"1279633.65","v":1279633.6499999999},{"$f":"738016.52","v":738016.52},{"$f":"1933079.51","v":1933079.51},{"$f":"1137627.47","v":1137627.47},{"$f":"1987872.7","v":1987872.7},{"$f":"2251732.58","v":2251732.58},{"$f":"2142265.02","v":2142265.02},{"$f":"1430489.54","v":1430489.54},{"$f":"2863521.6","v":2863521.6},{"$f":"181736.57","v":181736.57},{"$f":"45095.45","v":45095.45},{"$f":"33692.14","v":33692.14},{"$f":"42362.09","v":42362.09},{"$f":"34851","v":34851},{"$f":"744405.53","v":744405.53},{"$f":"1181506.86","v":1181506.8600000001},{"$f":"1414440.02","v":1414440.02},{"$f":"41514.51","v":41514.51},{"$f":"49539.76","v":49539.76},{"$f":"74186.43","v":74186.429999999993},{"$f":"143403.32","v":143403.32},{"$f":"129750.45","v":129750.45},{"$f":"118803.2","v":118803.2},{"$f":"8254.15","v":8254.15},{"$f":"7468.85","v":7468.85},{"$f":"3311.95","v":3311.95},{"$f":"1681.38","v":1681.38},{"$f":"1328.5","v":1328.5},{"$f":"378206.98","v":378206.98},{"$f":"239038.82","v":239038.82},{"$f":"53641.2","v":53641.2},{"$f":"64477.35","v":64477.35},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"50099.27","v":50099.27},{"$f":"9287.95","v":9287.9500000000007},{"$f":"11677.91","v":11677.91},{"$f":"9607.4","v":9607.4},{"$f":"12431.36","v":12431.36},{"$f":"75776.14","v":75776.14},{"$f":"117158.28","v":117158.28},{"$f":"108573.32","v":108573.32},{"$f":"22902.68","v":22902.68},{"$f":"25035.34","v":25035.34},{"$f":"41781.93","v":41781.93},{"$f":"15988.48","v":15988.48},{"$f":"14466.3","v":14466.3},{"$f":"13245.79","v":13245.79},{"$f":"16700.95","v":16700.95},{"$f":"18831.24","v":18831.240000000002},{"$f":"3654.32","v":3654.32},{"$f":"4624.95","v":4624.95},{"$f":"17053.99","v":17053.990000000002},{"$f":"4169.55","v":4169.55},{"$f":"2193.86","v":2193.86},{"$f":"1825.16","v":1825.16},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"56990.06","v":56990.06},{"$f":"72458.81","v":72458.81},{"$f":"43238.96","v":43238.96},{"$f":"80784.72","v":80784.72},{"$f":"26464.48","v":26464.48},{"$f":"48601.29","v":48601.29},{"$f":"47593.19","v":47593.19},{"$f":"101292.69","v":101292.69},{"$f":"331798.33","v":331798.33},{"$f":"115289.93","v":115289.93},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"4.5","Cost Sharing Reduction",{"$f":"SUM(E69:XFD69)","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"4.6","Incurred Claims",{"$f":"D66-D67-D68-D69","v":104097563.13999996},0,2752489.9699999997,4251390.8100000005,2220801.4300000002,5478733.96,6284541.25,10620274.370000001,11891764.58,11771192.450000001,7112170.2600000007,13088477.32,365703.95,65836.960000000006,79427.180000000008,69954.559999999998,77283.08,2109341.7199999997,3708926.42,4509487.4499999993,131639.28999999998,140405.57999999999,234345.12,340610.8,348602.26999999996,366354.51,43591.51,34138.32,17694.21,5772.92,6263.3,4909681.08,{"$f":"AJ66-AJ67-AJ68-AJ69","v":3304861.85},828902.77,811045.70000000007,0,0,0,0,0,0,0,0,0,0,0,100813.52000000002,21895.79,19284.3,21304.68,18149.13,214718.69,367777.31999999995,346151.14,72622.649999999994,70955.180000000008,131983.6,37975.759999999995,38866.81,40846.18,89225.36,86073.12999999999,17228.47,15879.529999999999,{"$f":"BP66-BP67-BP68-BP69","v":221385.82},57646.59,27596.1,28203.72,0,0,173056.46,240733.53999999998,130112.44,228960.04,146196.44,259653.97,261512.27000000002,503611.42,1516571.3699999999,608864.77,0,0,0,0,0,0,0]
[null,"4.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E71:XFD71)","v":4944919.790000001},{"$f":"0","v":0},{"$f":"130650.86","v":130650.86},{"$f":"201798.33","v":201798.33},{"$f":"105413.51","v":105413.51},{"$f":"260055.92","v":260055.92},{"$f":"298304.71","v":298304.71000000002},{"$f":"504106.46","v":504106.46},{"$f":"564459.56","v":564459.56000000006},{"$f":"558736.43","v":558736.43000000005},{"$f":"337589.3","v":337589.3},{"$f":"621263.23","v":621263.23},{"$f":"17358.66","v":17358.66},{"$f":"3125.05","v":3125.05},{"$f":"3770.12","v":3770.12},{"$f":"3320.49","v":3320.49},{"$f":"3668.35","v":3668.35},{"$f":"100122.91","v":100122.91},{"$f":"176049.48","v":176049.48},{"$f":"214049.25","v":214049.25},{"$f":"6248.45","v":6248.45},{"$f":"6664.55","v":6664.55},{"$f":"11123.53","v":11123.53},{"$f":"16167.58","v":16167.58},{"$f":"16546.9","v":16546.900000000001},{"$f":"17389.54","v":17389.54},{"$f":"2069.13","v":2069.13},{"$f":"1620.42","v":1620.42},{"$f":"839.88","v":839.88},{"$f":"274.02","v":274.02},{"$f":"297.3","v":297.3},{"$f":"233045.01","v":233045.01},{"$f":"156869.98","v":156869.98000000001},{"$f":"39345.05","v":39345.050000000003},{"$f":"38497.44","v":38497.440000000002},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"4847.58","v":4847.58},{"$f":"1052.85","v":1052.8499999999999},{"$f":"927.28","v":927.28},{"$f":"1024.43","v":1024.43},{"$f":"872.69","v":872.69},{"$f":"10324.66","v":10324.66},{"$f":"17684.42","v":17684.419999999998},{"$f":"16644.53","v":16644.53},{"$f":"3492.03","v":3492.03},{"$f":"3411.85","v":3411.85},{"$f":"6346.38","v":6346.38},{"$f":"1826.05","v":1826.05},{"$f":"1868.89","v":1868.89},{"$f":"1964.07","v":1964.07},{"$f":"4290.36","v":4290.3599999999997},{"$f":"4138.79","v":4138.79},{"$f":"828.42","v":828.42},{"$f":"763.56","v":763.56},{"$f":"10645.24","v":10645.24},{"$f":"2771.91","v":2771.91},{"$f":"1326.95","v":1326.95},{"$f":"1356.16","v":1356.16},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"8321.35","v":8321.35},{"$f":"11575.57","v":11575.57},{"$f":"6256.4","v":6256.4},{"$f":"11009.45","v":11009.45},{"$f":"7029.8","v":7029.8},{"$f":"12485.35","v":12485.35},{"$f":"12574.71","v":12574.71},{"$f":"24215.95","v":24215.95},{"$f":"72923.7","v":72923.7},{"$f":"29277.01","v":29277.01},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"4.8","Premium",{"$f":"SUM(E72:XFD72)","v":115660333.23},{"$f":"0","v":0},{"$f":"3058692.37","v":3058692.37},{"$f":"4723724.37","v":4723724.37},{"$f":"2467796.59","v":2467796.59},{"$f":"6087848.38","v":6087848.3799999999},{"$f":"6983297.5","v":6983297.5},{"$f":"11800124.56","v":11800124.560000001},{"$f":"13213352.09","v":13213352.09},{"$f":"13079602.64","v":13079602.640000001},{"$f":"7902343.56","v":7902343.5599999996},{"$f":"14543129.73","v":14543129.73},{"$f":"406257.71","v":406257.71},{"$f":"72916.81","v":72916.81},{"$f":"87968.47","v":87968.47},{"$f":"77477.2","v":77477.2},{"$f":"85593.8","v":85593.8},{"$f":"2343414.12","v":2343414.12},{"$f":"4121139.47","v":4121139.47},{"$f":"5010937.97","v":5010937.97},{"$f":"145912.23","v":145912.23000000001},{"$f":"156211.09","v":156211.09},{"$f":"260306.83","v":260306.83},{"$f":"378455.83","v":378455.83},{"$f":"387335.23","v":387335.23},{"$f":"407059.91","v":407059.91},{"$f":"48366.96","v":48366.96},{"$f":"37551.64","v":37551.64},{"$f":"19463.36","v":19463.36},{"$f":"6776.81","v":6776.81},{"$f":"7352.46","v":7352.46},{"$f":"5454910.05","v":5454910.0499999998},{"$f":"3671998.11","v":3671998.11},{"$f":"920573.53","v":920573.53},{"$f":"900741.58","v":900741.58},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"112104.25","v":112104.25},{"$f":"24461.81","v":24461.81},{"$f":"21544.27","v":21544.27},{"$f":"23801.43","v":23801.43},{"$f":"20276.07","v":20276.07},{"$f":"238563.53","v":238563.53},{"$f":"408489.26","v":408489.26},{"$f":"384072.35","v":384072.35},{"$f":"80929.15","v":80929.149999999994},{"$f":"79035.97","v":79035.97},{"$f":"146285.2","v":146285.20000000001},{"$f":"42214.71","v":42214.71},{"$f":"43205.22","v":43205.22},{"$f":"45405.53","v":45405.53},{"$f":"98958.73","v":98958.73},{"$f":"95462.63","v":95462.63},{"$f":"18828.93","v":18828.93},{"$f":"17354.69","v":17354.689999999999},{"$f":"245996.15","v":245996.15},{"$f":"64328.82","v":64328.82},{"$f":"30362.48","v":30362.48},{"$f":"31031.01","v":31031.01},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"192368.98","v":192368.98},{"$f":"267069.35","v":267069.34999999998},{"$f":"144211.3","v":144211.29999999999},{"$f":"254007.86","v":254007.86},{"$f":"162649.87","v":162649.87},{"$f":"288575.53","v":288575.53000000003},{"$f":"290640.81","v":290640.81},{"$f":"558920.42","v":558920.42000000004},{"$f":"1684279.52","v":1684279.52},{"$f":"676264.44","v":676264.44},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"4.9","Projected Member Months",{"$f":"SUM(E73:XFD73)","v":145140},{"$f":"0","v":0},{"$f":"4194","v":4194},{"$f":"6447","v":6447},{"$f":"3462","v":3462},{"$f":"8736","v":8736},{"$f":"8283","v":8283},{"$f":"14102","v":14102},{"$f":"15845","v":15845},{"$f":"15520","v":15520},{"$f":"9595","v":9595},{"$f":"18029","v":18029},{"$f":"662","v":662},{"$f":"132","v":132},{"$f":"132","v":132},{"$f":"132","v":132},{"$f":"132","v":132},{"$f":"3287","v":3287},{"$f":"5727","v":5727},{"$f":"6738","v":6738},{"$f":"197","v":197},{"$f":"221","v":221},{"$f":"360","v":360},{"$f":"551","v":551},{"$f":"551","v":551},{"$f":"551","v":551},{"$f":"58","v":58},{"$f":"46","v":46},{"$f":"23","v":23},{"$f":"9","v":9},{"$f":"9","v":9},{"$f":"5622","v":5622},{"$f":"3752","v":3752},{"$f":"937","v":937},{"$f":"937","v":937},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"214","v":214},{"$f":"43","v":43},{"$f":"43","v":43},{"$f":"43","v":43},{"$f":"43","v":43},{"$f":"392","v":392},{"$f":"665","v":665},{"$f":"605","v":605},{"$f":"128","v":128},{"$f":"131","v":131},{"$f":"237","v":237},{"$f":"72","v":72},{"$f":"72","v":72},{"$f":"72","v":72},{"$f":"137","v":137},{"$f":"137","v":137},{"$f":"27","v":27},{"$f":"27","v":27},{"$f":"297","v":297},{"$f":"77","v":77},{"$f":"37","v":37},{"$f":"37","v":37},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"309","v":309},{"$f":"427","v":427},{"$f":"237","v":237},{"$f":"427","v":427},{"$f":"226","v":226},{"$f":"404","v":404},{"$f":"404","v":404},{"$f":"795","v":795},{"$f":"2446","v":2446},{"$f":"950","v":950},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"4.10","Loss Ratio",{"$f":"D70/(D71+D72)","v":0.86312627794692676},{"$error":"#DIV/0!"},0.86302720387984078,0.86313495418465946,0.86304706716330726,0.86307759239533588,0.863071212729705,0.86314003311033405,0.86310982339492204,0.86309574718617121,0.8631344916079815,0.86310591888011845,0.86329041061373524,0.86579891654412455,0.86579900563110912,0.86579900984793001,0.8657989976714654,0.86323296684396855,0.86310526792171882,0.86306191003468125,0.86513342343107269,0.86204161653639555,0.86337106873379976,0.86312872315405709,0.86312873015698899,0.86312871886157483,0.86429201787846766,0.87149667390481889,0.87149686453984676,0.81875750798132985,0.81875771266026642,0.86317156661923422,{"$f":"AJ70/(AJ71+AJ72)","v":0.86314330301203979},0.86351362216574656,0.86351363468694053,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.86200891426837889,0.85816507059078984,0.85816510209576113,0.85816483296046941,0.85816520684900688,0.86271144484597684,0.86297520766650804,0.86382969442165758,0.86024206247768631,0.86060710883562475,0.86472013196744735,0.86228666353623307,0.86228679834166433,0.8622867830845099,0.86417575205747577,0.86417573163113526,0.87643909275665344,0.87643839774812682,{"$f":"BP70/(BP71+BP72)","v":0.86262710780985097},0.85910525861641152,0.87082980034667701,0.87083002312335422,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0.8623059217651392,0.86394376039584708,0.86472006948999702,0.86394371748773702,0.86160257148072017,0.86246333299763156,0.8624633396074185,0.86362546722990363,0.86305974900273619,0.86297519444109205,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Per Member Per Month"]
[null,"4.11","Allowed Claims",{"$f":"D66/D73","v":876.96384559735384},{"$error":"#DIV/0!"},872.4190867906533,857.92220567705908,854.65567590987871,848.421871565934,896.07252444766391,894.06800950219827,892.61578794572426,896.48566172680421,890.32410630536742,884.79665649786455,826.94942598187311,840.39704545454549,856.96454545454549,850.88371212121206,849.50060606060606,868.19204441740192,853.92583900820682,879.18187444345494,878.95329949238578,859.48117647058825,857.03208333333328,878.42852994555358,868.15375680580757,880.5040108892922,893.89068965517242,904.50369565217386,913.31130434782608,828.25555555555559,843.5333333333333,940.57062611170397,{"$f":"AJ66/AJ73","v":944.53642590618335},941.88257203842045,934.38959445037358,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},705.19995327102811,725.20325581395355,720.05139534883722,718.88558139534882,711.17418604651164,741.05823979591844,729.22646616541351,751.61067768595046,746.29164062500001,732.75206106870235,733.18789029535867,749.50333333333333,740.73763888888891,751.27736111111108,773.18474452554744,765.7253284671533,773.43666666666672,759.42518518518511,{"$f":"BP66/BP73","v":802.82764309764309},802.80701298701297,805.13405405405399,811.59135135135136,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},744.48711974110029,733.47154566744723,731.44050632911387,725.3975644028103,763.98637168141602,763.00806930693068,765.11252475247534,760.88567295597477,755.67035977105479,762.26810526315785,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"4.12","Reinsurance",{"$f":"D67/D73","v":0},{"$error":"#DIV/0!"},0,0,0,0,0,0,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":"AJ67/AJ73","v":0},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP67/BP73","v":0},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"4.13","Member Cost Sharing",{"$f":"D68/D73","v":159.74210700013774},{"$error":"#DIV/0!"},216.12677157844541,198.48513261982316,213.17634893125361,221.27741643772893,137.34485935047687,140.96388455538221,142.10997664878511,138.0325399484536,149.08697655028661,158.8286427422486,274.52654078549853,341.63219696969696,255.24348484848485,320.9249242424242,264.02272727272725,226.46958624885914,206.30467260345733,209.91986049272782,210.7335532994924,224.16180995475113,206.07341666666665,260.26010889292195,235.48176043557169,215.61379310344827,142.31293103448274,162.36630434782609,143.99782608695651,186.82000000000002,147.61111111111111,67.272675204553536,{"$f":"AJ68/AJ73","v":63.709706823027723},57.247812166488792,68.812540021344716,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},234.108738317757,215.99883720930234,271.57930232558141,223.42790697674417,289.10139534883723,193.30647959183673,176.17786466165413,179.46003305785126,178.9271875,191.10946564885495,176.29506329113923,222.0622222222222,200.92083333333332,183.96930555555556,121.90474452554746,137.45430656934309,135.34518518518519,171.29444444444445,{"$f":"BP68/BP73","v":57.42084175084176},54.150000000000006,59.293513513513517,49.328648648648652,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},184.43385113268607,169.69276346604215,182.44286919831222,189.19138173302107,117.09946902654868,120.30022277227722,117.80492574257427,127.41218867924529,135.6493581357318,121.35782105263158,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"4.14","Cost Sharing Reduction",{"$f":"D69/D73","v":0},{"$error":"#DIV/0!"},0,0,0,0,0,0,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":"AJ69/AJ73","v":0},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP69/BP73","v":0},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"4.15","Incurred Claims",{"$f":"D70/D73","v":717.22173859721613},{"$error":"#DIV/0!"},656.29231521220788,659.43707305723603,641.47932697862507,627.1444551282051,758.72766509718701,753.10412494681611,750.5058112969391,758.45312177835058,741.2371297550809,725.96801375561597,552.42288519637464,498.76484848484853,601.72106060606063,529.95878787878792,585.47787878787881,641.72245816854263,647.62116640474937,669.26201395072712,668.21974619289324,635.31936651583703,650.95866666666666,618.16842105263152,632.67199637023589,664.8902177858439,751.57775862068968,742.13739130434783,769.31347826086949,641.43555555555554,695.92222222222222,873.29795090715049,{"$f":"AJ70/AJ73","v":880.82671908315569},884.63475987193169,865.57705442902886,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},471.09121495327111,509.20441860465121,448.47209302325581,495.45767441860465,422.07279069767446,547.75176020408162,553.0486015037593,572.15064462809914,567.36445312499995,541.64259541984734,556.89282700421938,527.44111111111101,539.81680555555556,567.3080555555556,651.28,628.2710218978101,638.09148148148154,588.13074074074075,{"$f":"BP70/BP73","v":745.40680134680133},748.65701298701299,745.84054054054047,762.26270270270277,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},560.05326860841421,563.77878220140508,548.99763713080165,536.2061826697892,646.8869026548673,642.70784653465341,647.30759900990108,633.47348427672955,620.02100163532293,640.91028421052636,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"4.16","Risk Adjustment Transfer Amount",{"$f":"D71/D73","v":34.069999931101016},{"$error":"#DIV/0!"},31.151850262279446,31.30112145183806,30.448731946851531,29.768305860805864,36.014090305444888,35.747160686427456,35.623828337014835,36.001058634020623,35.183877019280871,34.459106439625046,26.22154078549849,23.674621212121213,28.561515151515152,25.15522727272727,27.790530303030302,30.46027076361424,30.740261917234157,31.76747551202137,31.718020304568526,30.156334841628961,30.898694444444445,29.342250453720506,30.030671506352089,31.559963702359347,35.674655172413793,35.226521739130433,36.516521739130432,30.446666666666665,33.033333333333331,41.452331910352193,{"$f":"AJ71/AJ73","v":41.809696162046912},41.990448239060832,41.08584845250801,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},22.652242990654205,24.484883720930231,21.564651162790696,23.823953488372094,20.29511627906977,26.338418367346939,26.593112781954886,27.511619834710743,27.281484375000002,26.044656488549617,26.777974683544304,25.361805555555556,25.956805555555558,27.278749999999999,31.316496350364961,30.210145985401461,30.682222222222222,28.279999999999998,{"$f":"BP71/BP73","v":35.842558922558922},35.998831168831167,35.863513513513517,36.652972972972975,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},26.929935275080908,27.109063231850115,26.39831223628692,25.783255269320843,31.105309734513273,30.904331683168319,31.125519801980197,30.460314465408807,29.813450531479965,30.817905263157893,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"4.17","Premium",{"$f":"D72/D73","v":796.88806138900372},{"$error":"#DIV/0!"},729.30194802098242,732.70115867845516,712.82397169266312,696.86909111721616,843.08795122540141,836.76957594667431,833.91303818239192,842.7579020618557,823.58974048983839,806.65204559321091,613.68234138972809,552.40007575757579,666.42780303030304,586.94848484848478,648.43787878787884,712.93401886218442,719.59830103020784,743.68328435737601,740.67121827411177,706.8375113122172,723.07452777777769,686.85268602540839,702.96774954627949,738.76571687840283,833.91310344827582,816.34,846.23304347826092,752.97888888888895,816.94,970.27926894343648,{"$f":"AJ72/AJ73","v":978.67753464818759},982.46908217716123,961.30371398078967,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},523.85163551401865,568.87930232558142,501.02953488372094,553.52162790697673,471.53651162790698,608.58043367346943,614.26956390977443,634.8303305785123,632.25898437499995,603.3280152671756,617.23713080168784,586.31541666666669,600.07249999999999,630.63236111111109,722.32649635036489,696.80751824817526,697.36777777777775,642.76629629629622,{"$f":"BP72/BP73","v":828.26986531986529},835.43922077922082,820.60756756756757,838.67594594594595,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},622.5533333333334,625.45515222482425,608.48649789029525,594.86618266978917,719.68969026548666,714.29586633663371,719.40794554455442,703.04455345911958,688.58524938675384,711.85730526315785,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Wksh 3 - Rating Areas","index":2,"n_rows":13,"n_cols":3,"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."]
["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.1088]
["Rating Area 2",1.0913999999999999]
["Rating Area 3",0.95420000000000005]
["Rating Area 4",0.99609999999999999]
["Rating Area 5",0.94879999999999998]
["Rating Area 6",1.1555]
["Rating Area 7",1.0426]
["Rating Area 8",1.1057999999999999]

{"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]]}
["REBUILD",null,"Product-Plan Data Collection"]
[]
[null,null,"Company Legal Name:",{"$f":"IF('Wksh 1 - Market Experience'!C3<>\"\", 'Wksh 1 - Market Experience'!C3,\"\")","v":"Anthem Health Plans of Kentucky, Inc."},null,null,null,null,null,null,null,null,null,"State:",{"$f":"IF('Wksh 1 - Market Experience'!E4=\"\",\"\",'Wksh 1 - Market Experience'!E4)","v":"KY"}]
[null,null,"HIOS Issuer ID:",{"$f":"IF('Wksh 1 - Market Experience'!C4<>\"\", 'Wksh 1 - Market Experience'!C4,\"\")","v":36239},null,null,null,null,null,null,null,null,null,"Market: ",{"$f":"IF('Wksh 1 - Market Experience'!E5=\"\",\"\",'Wksh 1 - Market Experience'!E5)","v":"Small Group"}]
[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,"Rating Area 1","AL","New","Platinum","Yes"]
[null,"1.2","Product ID",null,null,null,null,null,null,null,"Rating Area 2","AK","Renewing","Gold","No"]
[null,"1.3","Plan Name",null,null,null,null,null,null,null,"Rating Area 3","AZ","Terminated","Silver"]
[null,"1.4","Plan ID (Standard Component ID)",null,null,null,null,null,null,null,"Rating Area 4","AR",null,"Bronze"]
[null,"1.5","Metal",null,null,null,null,null,null,null,"Rating Area 5","CA",null,"Catastrophic"]
[null,"1.6","AV Metal Value",null,null,null,null,null,null,null,"Rating Area 6","CO",null,"Not Applicable"]
[null,"1.7","Plan Category",null,null,null,null,null,null,null,"Rating Area 7","CT"]
[null,"1.8","Plan Type",null,null,null,null,null,null,null,"Rating Area 8","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":828.39435245199945},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!"}}]