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

{"sheet":"Wksh 1 - Market Experience","index":0,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[29,3,29,6],[111,0,111,14],[49,1,49,16],[7,1,8,16],[21,3,21,4],[21,5,21,6],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3]]}
["Press TAB and directional arrow keys to read through the document. If macros are disabled, press and hold the ALT key and press the F, then I, and then N key. After that, select the Enable All Content option by pressing enter. (note that you can also press the C key to select \"Enable All Content\")  Instructions can be found in cells K1 through K4. If screen reader fails to announce a cell after performing a dropdown selection, please press F2 and then ESC to force the screen reader to resume.","Unified Rate Review v6.1 [assistive technology users, please reference cell A1 for instructions]",null,null,null,null,null,null,null,null,"To add a product to Worksheet 2 - Plan Product Info, select the Add Product button or Ctrl + Shift + P."]
[null,null,null,null,null,null,null,null,null,null,"To add a plan to Worksheet 2 - Plan Product Info, select the Add Plan button or Ctrl + Shift + L."]
[null,"Company Legal Name:","Anthem Health Plans of Kentucky, Inc.",null,null,null,null,null,null,null,"To validate, select the Validate button or Ctrl + Shift + I."]
[null,"HIOS Issuer ID:",36239,"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:CA19)","v":"00:00:00"},"Market: ","Small Group"]
[]
[]
[null,"Market Level Calculations (Same for all Plans)"]
[]
[]
[null,"Section I: Experience Period Data"]
[null,"Experience Period:",null,"2023-01-01","to",{"$f":"EDATE(D12,12)-1","v":"12/31/2023"}]
[null,null,null,null,"Total","PMPM"]
[null,"Allowed Claims",null,null,196790764.62,{"$f":"E14/E19","v":714.51409999999998}]
[null,"Reinsurance",null,null,0,{"$f":"E15/E19","v":0}]
[null,"Incurred Claims in Experience Period",null,null,162570402.13999999,{"$f":"E16/E19","v":590.26570000000004}]
[null,"Risk Adjustment",null,null,293308.63,{"$f":"E17/E19","v":1.0649999999999999}]
[null,"Experience Period Premium",null,null,192819928.22999999,{"$f":"E18/E19","v":700.09670000000006}]
[null,"Experience Period Member Months",null,null,{"$f":"'Wksh 2 - Plan Product Info'!D33","v":275419}]
[]
[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",124.50807452815199,1.03321033435127,1.02863557945355,1.03321033435126,1.02863557945355,{"$f":"PRODUCT(C24:G24)","v":140.63650000000001}]
[null,"Outpatient Hospital",259.52338529945598,1.03321033435127,1.02863557945355,1.03321033435126,1.02863557945355,293.1413]
[null,"Professional",134.29928574408299,1.03321033435127,1.02863557945355,1.03321033435126,1.02863557945355,151.696]
[null,"Other Medical",7.1040287345951496,1.03321033435127,1.02863557945355,1.03321033435126,1.02863557945355,8.0243000000000002]
[null,"Capitation",2.4195404576925102E-2,1.00756015985125,1,1.00756015985124,1,2.46E-2]
[null,"Prescription Drug",182.401030289137,1.0366563554007999,1.09933509953719,1.0366563554007999,1.09933509953719,236.89570000000001]
[null,"Total",{"$f":"SUM(C24:C29)","v":707.86},null,null,null,null,{"$f":"SUM(H24:H29)","v":830.41840000000002}]
[]
[null,"Morbidity Adjustment",null,null,null,1.0389999999999999]
[null,"Demographic Shift",null,null,null,1.012]
[null,"Plan Design Changes",null,null,null,1.0009999999999999]
[null,"Other",null,null,null,1.1189642256621]
[null,"Adjusted Trended EHB Allowed Claims PMPM for",null,{"$f":"IF(C5<>\"\",C5,\"\")","v":"1/1/2025"},null,{"$f":"H30*PRODUCT(F32:F35)","v":978.01}]
[]
[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":"1/1/2025"},null,{"$f":"ROUND(F39*F36+(1-F39)*F38,2)","v":978.01},{"$f":"F42*F48","v":171254441.05000001}]
[null,"Reinsurance",null,null,null,0,{"$f":"F43*F48","v":0}]
[null,"Risk Adjustment Payment/Charge",null,null,null,-0.50687907313540903,{"$f":"F44*F48","v":-88757.060100000002}]
[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":978.51689999999996},{"$f":"F46*F48","v":171343198.1101}]
[]
[null,"Projected Member Months",null,null,null,{"$f":"'Wksh 2 - Plan Product Info'!D73","v":175105}]
[]
[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":79,"rows_kept":82,"cut":false,"hidden":false,"merged":[[59,4,59,78],[60,4,60,78],[21,4,21,78],[10,75,10,78],[9,75,9,78],[20,75,20,78],[47,4,47,78],[58,4,58,78],[10,40,10,64],[9,40,9,64],[20,40,20,64],[10,65,10,74],[9,65,9,74],[20,65,20,74],[6,2,7,21],[10,5,10,14],[9,5,9,14],[20,5,20,14],[10,15,10,39],[9,15,9,39],[20,15,20,39]]}
["Press TAB and directional arrow keys to read through the document. If macros are disabled, press and hold the ALT key and press the F, then I, and then N key. After that, select the Enable All Content option by pressing enter. (note that you can also press the C key to select \"Enable All Content\")  Instructions can be found in cells P1 through P6. If screen reader fails to announce a cell after performing a dropdown selection, please press F2 and then ESC to force the screen reader to resume.",null,"Product-Plan Data Collection [assistive technology users, please reference cell A1 for instructions]",null,null,null,null,null,null,null,null,null,null,null,null,"To add a product to Worksheet 2 - Plan Product Info, select the Add Product button or Ctrl + Shift + P."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To add a plan to Worksheet 2 - Plan Product Info, select the Add Plan button or Ctrl + Shift + L."]
[null,null,"Company Legal Name:",{"$f":"IF('Wksh 1 - Market Experience'!C3<>\"\", 'Wksh 1 - Market Experience'!C3,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"To validate, select the Validate button or Ctrl + Shift + I."]
[null,null,"HIOS Issuer ID:",{"$f":"IF('Wksh 1 - Market Experience'!C4<>\"\", 'Wksh 1 - Market Experience'!C4,\"\")","v":""},"State:",{"$f":"IF('Wksh 1 - Market Experience'!E4<>\"\",'Wksh 1 - Market Experience'!E4,\"\")","v":""},null,null,null,null,null,null,null,null,null,"To finalize, select the Finalize button or Ctrl + Shift + F."]
[null,null,"Effective Date of Rate Change(s):",{"$f":"IF('Wksh 1 - Market Experience'!C5<>\"\", 'Wksh 1 - Market Experience'!C5,\"\")","v":"00:00:00"},"Market: ",{"$f":"IF('Wksh 1 - Market Experience'!E5<>\"\",'Wksh 1 - Market Experience'!E5,\"\")","v":""},null,null,null,null,null,null,null,null,null,"To remove a product, navigate to the corresponding Product Name/Product ID field and select the Remove Product button or Ctrl + Shift + Q."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To remove a plan, navigate to the corresponding Plan Name/Plan ID field and select the Remove Plan button or Ctrl + Shift + A."]
[null,null,"Product/Plan Level Calculations"]
[]
[null,"Field #","Section I: General Product and Plan Information"]
[null,"1.1","Product Name",null,"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,"HMO Off Exchange",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"36239KY117",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36239KY118",null,null,null,null,null,null,null,null,null,"36239KY120"]
[null,"1.3","Plan Name",null,"2023 Experience","Anthem Silver Blue Access PPO 5000EC/0%/6000 w/HSA (SHOP)","Anthem Silver Blue Access PPO 3300EC/0%/5600 w/HSA (SHOP)","Anthem Silver Blue Access PPO 6000/20%/8500 (SHOP)","Anthem Silver Blue Access PPO 3500EC/0%/6500 w/HSA (SHOP)","Anthem Gold Blue Access PPO 3000/20%/5500 (SHOP)","Anthem Gold Blue Access PPO 650/20%/8500 (SHOP)","Anthem Gold Blue Access PPO 1000/20%/7000 (SHOP)","Anthem Gold Blue Access PPO 1500/20%/6000 (SHOP)","Anthem Gold Blue Access PPO 2500/20%/5000 (SHOP)","Anthem Gold Blue Access PPO 2000/20%/4500 (SHOP)","Anthem Bronze Blue Access PPO 6500E/40%/7500 w/HSA","Anthem Bronze Blue Access PPO 8000EC/50%/9000","Anthem Bronze Blue Access PPO 8000E/0%/8000 w/HSA","Anthem Silver Blue Access PPO 5000EC/0%/6000 w/HSA WH","Anthem Silver Blue Access PPO 4000EC/0%/5500 w/HSA","Anthem Silver Blue Access PPO 7000/20%/8500","Anthem Silver Blue Access PPO 3000/30%/7000 w/HSA","Anthem Silver Blue Access PPO 4500E/30%/7000 w/HSA","Anthem Silver Blue Access PPO 4500/20%/8500","Anthem Silver Blue Access PPO 5500/20%/8000","Anthem Silver Blue Access PPO 3500E/20%/7000 w/HSA","Anthem Silver Blue Access PPO 3000/6500","Anthem Gold Blue Access PPO 1500/20%/6000 (Grp Conv)","Anthem Gold Blue Access PPO 1000/20%/7000 WH","Anthem Gold Blue Access PPO 1650/30%/4800 w/HSA","Anthem Gold Blue Access PPO 3000/20%/5500 WH","Anthem Gold Blue Access PPO 0/50%/8000","Anthem Gold Blue Access PPO 2000/4500","Anthem Gold Blue Access PPO 1000/5000","Anthem Gold Blue Access PPO 2000/30%/5500","Anthem Gold Blue Access PPO 3000/30%/5400","Anthem Platinum Blue Access PPO 0/10%/5500","Anthem Platinum Blue Access PPO 250/10%/2500","Anthem Platinum Blue Access PPO 500/0%/3500","Anthem Silver Blue Access PPO 3000EC/0%/6250 w/HSA","Anthem Bronze Pathway HMO 6500E/40%/7500 w/HSA","Anthem Bronze Pathway HMO 8000EC/50%/9000","Anthem Bronze Pathway HMO 8000E/0%/8000 w/HSA","Anthem Silver Pathway HMO 3000/30%/7000 w/HSA","Anthem Silver Pathway HMO 4000EC/0%/5500 w/HSA","Anthem Silver Pathway HMO 5000EC/0%/6000 w/HSA WH","Anthem Silver Pathway HMO 4500E/30%/7000 w/HSA","Anthem Silver Pathway HMO 4500/20%/8500","Anthem Silver Pathway HMO 5500/20%/8000","Anthem Silver Pathway HMO 3500E/20%/7000 w/HSA","Anthem Silver Pathway HMO 7000/20%/8500","Anthem Silver Pathway HMO 3000/6500","Anthem Gold Pathway HMO 0/50%/8000","Anthem Gold Pathway HMO 1650/30%/4800 w/HSA","Anthem Gold Pathway HMO 3000/20%/5500 WH","Anthem Gold Pathway HMO 1000/20%/7000 WH","Anthem Gold Pathway HMO 2000/30%/5500","Anthem Gold Pathway HMO 1000/5000","Anthem Gold Pathway HMO 2000/4500","Anthem Gold Pathway HMO 1500/20%/6000 (Grp Conv)","Anthem Gold Pathway HMO 3000/30%/5400","Anthem Platinum Pathway HMO 0/10%/5500","Anthem Platinum Pathway HMO 250/10%/2500","Anthem Platinum Pathway HMO 500/0%/3500","Anthem Silver Pathway HMO 3000EC/0%/6250 w/HSA","Anthem Silver Pathway HMO 6000/20%/8500 (SHOP)","Anthem Silver Pathway HMO 3300EC/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 2500/20%/5000 (SHOP)","Anthem Gold Pathway HMO 2000/20%/4500 (SHOP)","Anthem Gold Pathway HMO 3000/20%/5500 (SHOP)","Anthem Gold Pathway HMO 1500/20%/6000 (SHOP)","Anthem Gold Pathway HMO 650/20%/8500 (SHOP)","Anthem Gold Pathway HMO 1000/20%/7000 (SHOP)","Anthem Link Gold Pathway EPO 1000/6000","Anthem Link Silver Pathway EPO 5000EC/5750 w/HSA","Anthem Link Bronze Pathway EPO 6000EC/7000 w/HSA","Anthem Link Platinum Pathway EPO 250/2500"]
[null,"1.4","Plan ID (Standard Component ID)",null,"36239KY0470137","36239KY0980054","36239KY0980052","36239KY0980051","36239KY0980053","36239KY0980050","36239KY0980045","36239KY0980046","36239KY0980047","36239KY0980049","36239KY0980048","36239KY0990273","36239KY0990238","36239KY0990274","36239KY0990265","36239KY0990257","36239KY0990220","36239KY0990269","36239KY0990272","36239KY0990260","36239KY0990263","36239KY0990271","36239KY0990284","36239KY0990237","36239KY0990262","36239KY0990275","36239KY0990261","36239KY0990278","36239KY0990282","36239KY0990283","36239KY0990286","36239KY0990285","36239KY0990281","36239KY0990190","36239KY0990242","36239KY0990266","36239KY1170129","36239KY1170073","36239KY1170130","36239KY1170131","36239KY1170115","36239KY1170122","36239KY1170128","36239KY1170117","36239KY1170120","36239KY1170127","36239KY1170056","36239KY1170138","36239KY1170136","36239KY1170125","36239KY1170119","36239KY1170118","36239KY1170141","36239KY1170139","36239KY1170137","36239KY1170142","36239KY1170140","36239KY1170135","36239KY1170037","36239KY1170075","36239KY1170123","36239KY1180033","36239KY1180034","36239KY1180035","36239KY1180036","36239KY1180031","36239KY1180030","36239KY1180032","36239KY1180037","36239KY1180028","36239KY1180029","36239KY1200005","36239KY1200002","36239KY1200001","36239KY1200008"]
[null,"1.5","Metal",null,"Not Applicable","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Gold","Bronze","Bronze","Bronze","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Platinum","Platinum","Platinum","Silver","Bronze","Bronze","Bronze","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Platinum","Platinum","Platinum","Silver","Silver","Silver","Silver","Silver","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Silver","Bronze","Platinum"]
[null,"1.6","AV Metal Value",null,0,0.69,0.70899999999999996,0.70299999999999996,0.68799999999999994,0.79300000000000004,0.81699999999999995,0.81299999999999994,0.80700000000000005,0.80400000000000005,0.81599999999999995,0.63300000000000001,0.60199999999999998,0.62,0.69,0.70599999999999996,0.70299999999999996,0.70699999999999996,0.68100000000000005,0.70399999999999996,0.71,0.70799999999999996,0.71199999999999997,0.80700000000000005,0.81299999999999994,0.79300000000000004,0.79300000000000004,0.81699999999999995,0.79,0.79300000000000004,0.80100000000000005,0.78800000000000003,0.91600000000000004,0.91200000000000003,0.90200000000000002,0.68899999999999995,0.63300000000000001,0.60199999999999998,0.62,0.70699999999999996,0.70599999999999996,0.69,0.68100000000000005,0.70399999999999996,0.71,0.70799999999999996,0.70299999999999996,0.71199999999999997,0.81699999999999995,0.79300000000000004,0.79300000000000004,0.81299999999999994,0.80100000000000005,0.79300000000000004,0.79,0.80700000000000005,0.78800000000000003,0.91600000000000004,0.91200000000000003,0.90200000000000002,0.68899999999999995,0.70299999999999996,0.70899999999999996,0.68799999999999994,0.69,0.80400000000000005,0.81599999999999995,0.79300000000000004,0.80700000000000005,0.81699999999999995,0.81299999999999994,0.77300000000000002,0.69199999999999995,0.64400000000000002,0.86299999999999999]
[null,"1.7","Plan Category",null,"Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","New","Renewing","Renewing","Renewing","Renewing","Renewing","New","New","New","New","Renewing","Renewing","Renewing","Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","New","Renewing","Renewing","Renewing","Renewing","New","New","New","New","New","Renewing","Renewing","Renewing","Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","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","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","EPO","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","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","No","No"]
[null,"1.10","Effective Date of Proposed Rates",null,"2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01","2025-01-01"]
[null,"1.11","Cumulative Rate Change %  (over 12 mos prior)",null,0,0.19009999999999999,0.1719,0.1643,0.17130000000000001,0.17319999999999999,0.16289999999999999,0.15479999999999999,0.16550000000000001,0.1726,0.1646,0,0.2412,0.2394,0.1847,0.18559999999999999,0.16819999999999999,0.24479999999999999,0,0.15989999999999999,0.15679999999999999,0.16,0,0.157,0.16869999999999999,0.19489999999999999,0.17330000000000001,0.17280000000000001,0,0,0,0,0.151,0.15939999999999999,0.1512,0,0,0.2349,0,0.25469999999999998,0.18160000000000001,0.19409999999999999,0,0.15809999999999999,0.13469999999999999,0,0.19939999999999999,0,0,0.19259999999999999,0.18099999999999999,0,0,0,0,0,0,0,0.17929999999999999,0.11840000000000001,0,0.1802,0.16919999999999999,0.21929999999999999,0.18099999999999999,0.17069999999999999,0.1666,0.183,0.1608,0.14960000000000001,0.1547,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},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((P16:AN16=\"Renewing\")*((P14:AN14=\"Platinum\")+(P14:AN14=\"Gold\")+(P14:AN14=\"Silver\")+(P14:AN14=\"Bronze\")+(P14:AN14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+P20:AN20,P34:AN34,P35:AN35,--(P16:AN16=\"Renewing\")*((P14:AN14=\"Platinum\")+(P14:AN14=\"Gold\")+(P14:AN14=\"Silver\")+(P14:AN14=\"Bronze\")+(P14:AN14=\"Catastrophic\")))/SUMPRODUCT(P34:AN34,P35:AN35,--(P16:AN16=\"Renewing\")*((P14:AN14=\"Platinum\")+(P14:AN14=\"Gold\")+(P14:AN14=\"Silver\")+(P14:AN14=\"Bronze\")+(P14:AN14=\"Catastrophic\"))), 4)-1, 4))","v":0},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((AO16:BM16=\"Renewing\")*((AO14:BM14=\"Platinum\")+(AO14:BM14=\"Gold\")+(AO14:BM14=\"Silver\")+(AO14:BM14=\"Bronze\")+(AO14:BM14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+AO20:BM20,AO34:BM34,AO35:BM35,--(AO16:BM16=\"Renewing\")*((AO14:BM14=\"Platinum\")+(AO14:BM14=\"Gold\")+(AO14:BM14=\"Silver\")+(AO14:BM14=\"Bronze\")+(AO14:BM14=\"Catastrophic\")))/SUMPRODUCT(AO34:BM34,AO35:BM35,--(AO16:BM16=\"Renewing\")*((AO14:BM14=\"Platinum\")+(AO14:BM14=\"Gold\")+(AO14:BM14=\"Silver\")+(AO14:BM14=\"Bronze\")+(AO14:BM14=\"Catastrophic\"))), 4)-1, 4))","v":0},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((BN16:BW16=\"Renewing\")*((BN14:BW14=\"Platinum\")+(BN14:BW14=\"Gold\")+(BN14:BW14=\"Silver\")+(BN14:BW14=\"Bronze\")+(BN14:BW14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+BN20:BW20,BN34:BW34,BN35:BW35,--(BN16:BW16=\"Renewing\")*((BN14:BW14=\"Platinum\")+(BN14:BW14=\"Gold\")+(BN14:BW14=\"Silver\")+(BN14:BW14=\"Bronze\")+(BN14:BW14=\"Catastrophic\")))/SUMPRODUCT(BN34:BW34,BN35:BW35,--(BN16:BW16=\"Renewing\")*((BN14:BW14=\"Platinum\")+(BN14:BW14=\"Gold\")+(BN14:BW14=\"Silver\")+(BN14:BW14=\"Bronze\")+(BN14:BW14=\"Catastrophic\"))), 4)-1, 4))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((BX16:CA16=\"Renewing\")*((BX14:CA14=\"Platinum\")+(BX14:CA14=\"Gold\")+(BX14:CA14=\"Silver\")+(BX14:CA14=\"Bronze\")+(BX14:CA14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+BX20:CA20,BX34:CA34,BX35:CA35,--(BX16:CA16=\"Renewing\")*((BX14:CA14=\"Platinum\")+(BX14:CA14=\"Gold\")+(BX14:CA14=\"Silver\")+(BX14:CA14=\"Bronze\")+(BX14:CA14=\"Catastrophic\")))/SUMPRODUCT(BX34:CA34,BX35:CA35,--(BX16:CA16=\"Renewing\")*((BX14:CA14=\"Platinum\")+(BX14:CA14=\"Gold\")+(BX14:CA14=\"Silver\")+(BX14:CA14=\"Bronze\")+(BX14:CA14=\"Catastrophic\"))), 4)-1, 4))","v":0}]
[null,"1.13","Submission Level Rate Increase %",null,{"$f":"IF(SUMPRODUCT((E16:CA16=\"Renewing\")*((E14:CA14=\"Platinum\")+(E14:CA14=\"Gold\")+(E14:CA14=\"Silver\")+(E14:CA14=\"Bronze\")+(E14:CA14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:CA20,E34:CA34,E35:CA35,--(E16:CA16=\"Renewing\")*((E14:CA14=\"Platinum\")+(E14:CA14=\"Gold\")+(E14:CA14=\"Silver\")+(E14:CA14=\"Bronze\")+(E14:CA14=\"Catastrophic\")))/SUMPRODUCT(E34:CA34,E35:CA35,--(E16:CA16=\"Renewing\")*((E14:CA14=\"Platinum\")+(E14:CA14=\"Gold\")+(E14:CA14=\"Silver\")+(E14:CA14=\"Bronze\")+(E14:CA14=\"Catastrophic\"))), 4)-1, 4))","v":0}]
[]
["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":0},0,0,0,0,0,0,0,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":"AK13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BQ13","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$f":"'Wksh 1 - Market Experience'!E14","v":0},"2.2","Allowed Claims",{"$f":"SUM(E26:XFD26)","v":196078770.13999999},{"$f":"74994602.67","v":0},{"$f":"7361924.28","v":0},{"$f":"4020450.83","v":0},{"$f":"3267525.01","v":0},{"$f":"3621468.29","v":0},{"$f":"14873042.51","v":0},{"$f":"6300447.34","v":0},{"$f":"11166711.17","v":0},{"$f":"13377532.53","v":0},{"$f":"9040100.3","v":0},{"$f":"14407724.86","v":0},{"$f":"0","v":0},{"$f":"721123.63","v":0},{"$f":"0","v":0},{"$f":"353720.52","v":0},{"$f":"5022710.94","v":0},{"$f":"2197454.11","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"5722905.37","v":0},{"$f":"216292.68","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"163781.97","v":0},{"$f":"74818.85","v":0},{"$f":"0","v":0},{"$f":"85325.92","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"8320589.68","v":0},{"$f":"2923056.7","v":0},{"$f":"643280","v":0},{"$f":"0","v":0},{"$f":"86388.78","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"247651.68","v":0},{"$f":"23676.48","v":0},{"$f":"0","v":0},{"$f":"381919.65","v":0},{"$f":"134.86","v":0},{"$f":"0","v":0},{"$f":"35784.67","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"168331.27","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"78400.39","v":0},{"$f":"75411.2","v":0},{"$f":"25166.53","v":0},{"$f":"79022.92","v":0},{"$f":"139003.92","v":0},{"$f":"26517.62","v":0},{"$f":"201539.38","v":0},{"$f":"665274.62","v":0},{"$f":"162537.33","v":0},{"$f":"3280625.89","v":0},{"$f":"632787.03","v":0},{"$f":"531888.28","v":0},{"$f":"151262.99","v":0},{"$f":"70894.34","v":0},{"$f":"74584.07","v":0},{"$f":"-539.66","v":0},{"$f":"63915.74","v":0}]
[{"$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}]
[null,"2.4","Member Cost Sharing",{"$f":"SUM(E28:XFD28)","v":34182173.369999997},{"$f":"13120560.45","v":0},{"$f":"1475255.86","v":0},{"$f":"1147056.66","v":0},{"$f":"688134.89","v":0},{"$f":"629193.78","v":0},{"$f":"2847803.33","v":0},{"$f":"1008320.43","v":0},{"$f":"2033266.92","v":0},{"$f":"2206174.42","v":0},{"$f":"1534215.59","v":0},{"$f":"2303379.6","v":0},{"$f":"0","v":0},{"$f":"127123.85","v":0},{"$f":"0","v":0},{"$f":"54224.62","v":0},{"$f":"859200.35","v":0},{"$f":"537339.33","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"1201423.33","v":0},{"$f":"103716.74","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"41315.45","v":0},{"$f":"12096.39","v":0},{"$f":"0","v":0},{"$f":"23284.13","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"481100.2","v":0},{"$f":"305990.85","v":0},{"$f":"125986.94","v":0},{"$f":"0","v":0},{"$f":"47444.55","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"99385.61","v":0},{"$f":"11313.73","v":0},{"$f":"0","v":0},{"$f":"121914.54","v":0},{"$f":"457.47","v":0},{"$f":"0","v":0},{"$f":"19728.19","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"45648.67","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"1642.46","v":0},{"$f":"4056.98","v":0},{"$f":"20516.07","v":0},{"$f":"29713.94","v":0},{"$f":"48172.51","v":0},{"$f":"16570.77","v":0},{"$f":"57257.99","v":0},{"$f":"100102.23","v":0},{"$f":"44691.93","v":0},{"$f":"417120.57","v":0},{"$f":"110781.83","v":0},{"$f":"53464.33","v":0},{"$f":"39490.53","v":0},{"$f":"12075.75","v":0},{"$f":"5823.86","v":0},{"$f":"670.44","v":0},{"$f":"7964.31","v":0}]
[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":"'Wksh 1 - Market Experience'!E16","v":0},"2.6","Incurred Claims",{"$f":"D26-D27-D28-D29","v":161896596.77000001},0,0,0,0,0,0,0,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":"AJ26-AJ27-AJ28-AJ29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP26-BP27-BP28-BP29","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"'Wksh 1 - Market Experience'!E17","v":0},"2.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E31:XFD31)","v":293308.63},{"$f":"0","v":0},{"$f":"1256115.26","v":0},{"$f":"-327401.48","v":0},{"$f":"250791.53","v":0},{"$f":"46024.49","v":0},{"$f":"-198503.68","v":0},{"$f":"-585996.91","v":0},{"$f":"-479038.62","v":0},{"$f":"-129447.89","v":0},{"$f":"-18983.3","v":0},{"$f":"-151830.58","v":0},{"$f":"0","v":0},{"$f":"-31094.3","v":0},{"$f":"0","v":0},{"$f":"261840.87","v":0},{"$f":"167148.54","v":0},{"$f":"-392029.67","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-137299.2","v":0},{"$f":"-165531.93","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-71752.64","v":0},{"$f":"-24867.79","v":0},{"$f":"0","v":0},{"$f":"-11261.02","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"1281351.42","v":0},{"$f":"-343343.06","v":0},{"$f":"262105.8","v":0},{"$f":"0","v":0},{"$f":"-98671.27","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"-217914.38","v":0},{"$f":"-32576.67","v":0},{"$f":"0","v":0},{"$f":"-223874.38","v":0},{"$f":"-3697.26","v":0},{"$f":"0","v":0},{"$f":"-146114.27","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"15193.49","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"64278.45","v":0},{"$f":"-7886.75","v":0},{"$f":"-65563.5","v":0},{"$f":"-115508.43","v":0},{"$f":"-1132.22","v":0},{"$f":"41601.63","v":0},{"$f":"-13386.67","v":0},{"$f":"64428.32","v":0},{"$f":"-104477.37","v":0},{"$f":"566854.46","v":0},{"$f":"-18046.17","v":0},{"$f":"268120.64","v":0},{"$f":"-53291.74","v":0},{"$f":"-76671.99","v":0},{"$f":"54499.47","v":0},{"$f":"-18423.05","v":0},{"$f":"-41427.55","v":0}]
[{"$f":"'Wksh 1 - Market Experience'!E18","v":0},"2.8","Premium",{"$f":"SUM(E32:XFD32)","v":192767133.43000001},{"$f":"84135086.1","v":0},{"$f":"5399873","v":0},{"$f":"4525060.25","v":0},{"$f":"2716599.23","v":0},{"$f":"2259316.83","v":0},{"$f":"13368044.87","v":0},{"$f":"6470865.97","v":0},{"$f":"11486032.67","v":0},{"$f":"13071348.71","v":0},{"$f":"7398135.13","v":0},{"$f":"13804604.74","v":0},{"$f":"0","v":0},{"$f":"477159.62","v":0},{"$f":"0","v":0},{"$f":"170837.22","v":0},{"$f":"3620494.66","v":0},{"$f":"2110736.02","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"5010606.71","v":0},{"$f":"407826.71","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"188715.41","v":0},{"$f":"66117.58","v":0},{"$f":"0","v":0},{"$f":"102169.12","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"5716727.53","v":0},{"$f":"3753369.97","v":0},{"$f":"481065.73","v":0},{"$f":"0","v":0},{"$f":"163794.98","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"388606.81","v":0},{"$f":"50695.85","v":0},{"$f":"0","v":0},{"$f":"473532.84","v":0},{"$f":"5109.74","v":0},{"$f":"0","v":0},{"$f":"189319.77","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"134174.42","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"221700.84","v":0},{"$f":"41072.01","v":0},{"$f":"106086.54","v":0},{"$f":"165545.99","v":0},{"$f":"222167.33","v":0},{"$f":"54189.09","v":0},{"$f":"186506.96","v":0},{"$f":"444786.78","v":0},{"$f":"246296.93","v":0},{"$f":"1633123.48","v":0},{"$f":"559547.06","v":0},{"$f":"193044.65","v":0},{"$f":"286798.78","v":0},{"$f":"132169.21","v":0},{"$f":"23816.05","v":0},{"$f":"24729.73","v":0},{"$f":"79523.81","v":0}]
[{"$f":"'Wksh 1 - Market Experience'!E19","v":0},"2.9","Experience Period Member Months",{"$f":"SUM(E33:XFD33)","v":275419},{"$f":"124122","v":0},{"$f":"8902","v":0},{"$f":"7151","v":0},{"$f":"3988","v":0},{"$f":"3580","v":0},{"$f":"18425","v":0},{"$f":"8423","v":0},{"$f":"14925","v":0},{"$f":"16867","v":0},{"$f":"10545","v":0},{"$f":"18300","v":0},{"$f":"0","v":0},{"$f":"853","v":0},{"$f":"0","v":0},{"$f":"324","v":0},{"$f":"5639","v":0},{"$f":"2956","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"7784","v":0},{"$f":"589","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"261","v":0},{"$f":"111","v":0},{"$f":"0","v":0},{"$f":"177","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"6595","v":0},{"$f":"4227","v":0},{"$f":"737","v":0},{"$f":"0","v":0},{"$f":"296","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"657","v":0},{"$f":"101","v":0},{"$f":"0","v":0},{"$f":"786","v":0},{"$f":"12","v":0},{"$f":"0","v":0},{"$f":"312","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"205","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"340","v":0},{"$f":"44","v":0},{"$f":"239","v":0},{"$f":"282","v":0},{"$f":"383","v":0},{"$f":"129","v":0},{"$f":"399","v":0},{"$f":"763","v":0},{"$f":"404","v":0},{"$f":"2629","v":0},{"$f":"890","v":0},{"$f":"224","v":0},{"$f":"439","v":0},{"$f":"212","v":0},{"$f":"36","v":0},{"$f":"45","v":0},{"$f":"111","v":0}]
[null,"2.10","Current Enrollment",{"$f":"SUM(E34:XFD34)","v":14266},{"$f":"0","v":0},{"$f":"686","v":0},{"$f":"648","v":0},{"$f":"301","v":0},{"$f":"343","v":0},{"$f":"1796","v":0},{"$f":"598","v":0},{"$f":"1227","v":0},{"$f":"1750","v":0},{"$f":"1094","v":0},{"$f":"1578","v":0},{"$f":"0","v":0},{"$f":"105","v":0},{"$f":"15","v":0},{"$f":"26","v":0},{"$f":"485","v":0},{"$f":"287","v":0},{"$f":"57","v":0},{"$f":"0","v":0},{"$f":"863","v":0},{"$f":"87","v":0},{"$f":"15","v":0},{"$f":"0","v":0},{"$f":"78","v":0},{"$f":"70","v":0},{"$f":"66","v":0},{"$f":"86","v":0},{"$f":"26","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"8","v":0},{"$f":"684","v":0},{"$f":"411","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"36","v":0},{"$f":"0","v":0},{"$f":"10","v":0},{"$f":"49","v":0},{"$f":"8","v":0},{"$f":"0","v":0},{"$f":"82","v":0},{"$f":"4","v":0},{"$f":"0","v":0},{"$f":"16","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"1","v":0},{"$f":"19","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"34","v":0},{"$f":"6","v":0},{"$f":"0","v":0},{"$f":"31","v":0},{"$f":"41","v":0},{"$f":"5","v":0},{"$f":"30","v":0},{"$f":"58","v":0},{"$f":"69","v":0},{"$f":"222","v":0},{"$f":"90","v":0},{"$f":"20","v":0},{"$f":"45","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":828.80420000000004},{"$f":"0","v":0},{"$f":"717.9","v":0},{"$f":"715.38","v":0},{"$f":"811.62","v":0},{"$f":"726.79","v":0},{"$f":"843.8","v":0},{"$f":"912.06","v":0},{"$f":"873.88","v":0},{"$f":"872.44","v":0},{"$f":"843.7","v":0},{"$f":"869.6","v":0},{"$f":"0","v":0},{"$f":"646.71","v":0},{"$f":"572.16","v":0},{"$f":"559.09","v":0},{"$f":"722.88","v":0},{"$f":"763.18","v":0},{"$f":"625.27","v":0},{"$f":"0","v":0},{"$f":"746.69","v":0},{"$f":"891.39","v":0},{"$f":"992.65","v":0},{"$f":"0","v":0},{"$f":"863.76","v":0},{"$f":"733.41","v":0},{"$f":"794.19","v":0},{"$f":"856.3","v":0},{"$f":"783.2","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"797.84","v":0},{"$f":"1005.96","v":0},{"$f":"1022.1","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"516.05","v":0},{"$f":"0","v":0},{"$f":"543.17","v":0},{"$f":"708.34","v":0},{"$f":"589.79","v":0},{"$f":"0","v":0},{"$f":"711.69","v":0},{"$f":"481.98","v":0},{"$f":"0","v":0},{"$f":"779.59","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"418.91","v":0},{"$f":"641.21","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"742.57","v":0},{"$f":"1102.8","v":0},{"$f":"0","v":0},{"$f":"617.89","v":0},{"$f":"687.63","v":0},{"$f":"381.82","v":0},{"$f":"618.01","v":0},{"$f":"633.68","v":0},{"$f":"763.45","v":0},{"$f":"690.83","v":0},{"$f":"700.99","v":0},{"$f":"943.13","v":0},{"$f":"732.1","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.838579851172646},0,0,0,0,0,0,0,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":"AJ30/(AJ31+AJ32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP30/(BP31+BP32)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Per Member Per Month"]
[null,"2.13","Allowed Claims",{"$f":"D26/D33","v":711.92899999999997},0,0,0,0,0,0,0,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":"AJ26/AJ33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP26/BP33","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"2.14","Reinsurance",{"$f":"D27/D33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ27/AJ33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP27/BP33","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"2.15","Member Cost Sharing",{"$f":"D28/D33","v":124.1097},0,0,0,0,0,0,0,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":"AJ28/AJ33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP28/BP33","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"2.16","Cost Sharing Reduction",{"$f":"D29/D33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ29/AJ33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP29/BP33","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"2.17","Incurred Claims",{"$f":"D30/D33","v":587.8193},0,0,0,0,0,0,0,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":"AJ30/AJ33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP30/BP33","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"2.18","Risk Adjustment Transfer Amount",{"$f":"D31/D33","v":1.0649999999999999},0,0,0,0,0,0,0,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":"AJ31/AJ33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP31/BP33","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"2.19","Premium",{"$f":"D32/D33","v":699.90499999999997},0,0,0,0,0,0,0,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":"AJ32/AJ33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP32/BP33","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Section III: Plan Adjustment Factors"]
[null,"3.1","Plan ID (Standard Component ID)",null,{"$f":"E13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AK13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BQ13","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"3.2","Market Adjusted Index Rate",null,{"$f":"'Wksh 1 - Market Experience'!F46","v":0}]
[null,"3.3","AV and Cost Sharing Design of Plan",null,0,0.7298,0.752,0.74919999999999998,0.73560000000000003,0.83169999999999999,0.86219999999999997,0.8579,0.85589999999999999,0.84699999999999998,0.86470000000000002,0.72289999999999999,0.67290000000000005,0.70669999999999999,0.73080000000000001,0.74670000000000003,0.73580000000000001,0.74839999999999995,0.72689999999999999,0.76139999999999997,0.76019999999999999,0.7591,0.80920000000000003,0.85589999999999999,0.85829999999999995,0.7964,0.83230000000000004,0.84099999999999997,0.84930000000000005,0.8659,0.84319999999999995,0.82350000000000001,0.97919999999999996,0.99080000000000001,0.99570000000000003,0,0.72289999999999999,0.67279999999999995,0.70669999999999999,0.74839999999999995,0.74670000000000003,0.73080000000000001,0.7268,0.76139999999999997,0.76019999999999999,0.7591,0.73580000000000001,0.80920000000000003,0.84099999999999997,0.7964,0.83230000000000004,0.85829999999999995,0.84319999999999995,0.8659,0.84919999999999995,0.85589999999999999,0.82350000000000001,0.97919999999999996,0.99080000000000001,0.99570000000000003,0,0.74919999999999998,0.752,0.73560000000000003,0.7298,0.84699999999999998,0.86460000000000004,0.83160000000000001,0.85589999999999999,0.86219999999999997,0.8579,0,0,0,0]
[null,"3.4","Provider Network Adjustment",null,0,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,1.0084,0,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0.87009999999999998,0,0,0,0]
[null,"3.5","Benefits in Addition to EHB",null,0,1.0074000000000001,1.0072000000000001,1.0073000000000001,1.0073000000000001,1.0068999999999999,1.0066999999999999,1.0066999999999999,1.0067999999999999,1.0067999999999999,1.0066999999999999,1.0074000000000001,1.0077,1.0075000000000001,1.0182,1.0073000000000001,1.0073000000000001,1.0073000000000001,1.0074000000000001,1.0072000000000001,1.0072000000000001,1.0072000000000001,1.0069999999999999,1.0067999999999999,1.016,1.0069999999999999,1.0164,1.0067999999999999,1.0067999999999999,1.0066999999999999,1.0067999999999999,1.0068999999999999,1.0063,1.0063,1.0063,0,1.0074000000000001,1.0077,1.0075000000000001,1.0072000000000001,1.0073000000000001,1.0181,1.0074000000000001,1.0072000000000001,1.0072000000000001,1.0072000000000001,1.0073000000000001,1.0068999999999999,1.0067999999999999,1.0069999999999999,1.0163,1.0159,1.0067999999999999,1.0066999999999999,1.0067999999999999,1.0066999999999999,1.0068999999999999,1.0063,1.0063,1.0063,0,1.0072000000000001,1.0072000000000001,1.0073000000000001,1.0073000000000001,1.0067999999999999,1.0066999999999999,1.0067999999999999,1.0066999999999999,1.0066999999999999,1.0066999999999999,0,0,0,0]
[null,null,"Administrative Costs"]
[null,"3.6","Administrative Expense",null,0,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,0,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,0,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,5.7599999999999998E-2,0,0,0,0]
[null,"3.7","Taxes and Fees",null,0,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,0,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,0,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,2.81E-2,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,4.7399999999999998E-2,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,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]
[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,1,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,0,1,1,1,1,1,1,1,1,1,1,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},0,0,0,0,0,0,0,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":"($E$48*PRODUCT(AK49:AK51)*AK56)/(1-SUM(AK53:AK55))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"($E$48*PRODUCT(BQ49:BQ51)*BQ56)/(1-SUM(BQ53:BQ55))","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"3.11","Age Calibration Factor",0.67195269453030504,{"$f":"IF(D59<>\"\", D59, \"\")","v":0}]
[null,"3.12","Geographic Calibration Factor",0.99990000999899997,{"$f":"IF(D60<>\"\", D60, \"\")","v":0}]
[null,"3.13","Tobacco Calibration Factor",1,{"$f":"IF(D61<>\"\", D61, \"\")","v":0}]
[null,"3.14","Calibrated Plan Adjusted Index Rate",null,{"$f":"E57*(PRODUCT($E$59:$E$61))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AK57*(PRODUCT($E$59:$E$61))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BQ57*(PRODUCT($E$59:$E$61))","v":0},0,0,0,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":0},0,0,0,0,0,0,0,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":"AK13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BQ13","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"4.2","Allowed Claims",{"$f":"SUM(E66:XFD66)","v":172430497.22999999},{"$f":"0","v":0},{"$f":"7565384.27","v":0},{"$f":"7408987.04","v":0},{"$f":"3617039.06","v":0},{"$f":"3948928.3","v":0},{"$f":"21488730.66","v":0},{"$f":"7189688.16","v":0},{"$f":"14545779.18","v":0},{"$f":"20813654.19","v":0},{"$f":"13905123.84","v":0},{"$f":"19029042.78","v":0},{"$f":"2080551.92","v":0},{"$f":"1100393.99","v":0},{"$f":"177318.18","v":0},{"$f":"300278.31","v":0},{"$f":"6573843.17","v":0},{"$f":"3202189.38","v":0},{"$f":"560854.62","v":0},{"$f":"530595.06","v":0},{"$f":"10145504.3","v":0},{"$f":"1116790.19","v":0},{"$f":"46698.48","v":0},{"$f":"284188.41","v":0},{"$f":"798691.2","v":0},{"$f":"807203.9","v":0},{"$f":"623430.11","v":0},{"$f":"969383.41","v":0},{"$f":"310598.1","v":0},{"$f":"68599.09","v":0},{"$f":"68939.12","v":0},{"$f":"69941.2","v":0},{"$f":"69343.72","v":0},{"$f":"174962.83","v":0},{"$f":"8684188.43","v":0},{"$f":"4981281.8","v":0},{"$f":"0","v":0},{"$f":"109353.35","v":0},{"$f":"329306.88","v":0},{"$f":"35204.58","v":0},{"$f":"97703.18","v":0},{"$f":"553508.67","v":0},{"$f":"77252.06","v":0},{"$f":"57910.94","v":0},{"$f":"799591.6","v":0},{"$f":"38909.92","v":0},{"$f":"58508.12","v":0},{"$f":"154663.02","v":0},{"$f":"23236.82","v":0},{"$f":"22835.5","v":0},{"$f":"9835.87","v":0},{"$f":"160105.48","v":0},{"$f":"115143.25","v":0},{"$f":"7637.75","v":0},{"$f":"7528.33","v":0},{"$f":"7491.19","v":0},{"$f":"7654.45","v":0},{"$f":"7572.5","v":0},{"$f":"32518.67","v":0},{"$f":"357819.34","v":0},{"$f":"63270.33","v":0},{"$f":"0","v":0},{"$f":"281122.92","v":0},{"$f":"390777.06","v":0},{"$f":"47579.41","v":0},{"$f":"286244.94","v":0},{"$f":"587335.29","v":0},{"$f":"660489.92","v":0},{"$f":"2268353.23","v":0},{"$f":"907084.5","v":0},{"$f":"199731.22","v":0},{"$f":"409090.54","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}]
[null,"4.4","Member Cost Sharing",{"$f":"SUM(E68:XFD68)","v":29532511.870000001},{"$f":"0","v":0},{"$f":"1831850.68","v":0},{"$f":"1617874.75","v":0},{"$f":"847417.77","v":0},{"$f":"924517.48","v":0},{"$f":"3621532.31","v":0},{"$f":"1043398.31","v":0},{"$f":"2161451.51","v":0},{"$f":"3116030.28","v":0},{"$f":"2189334.86","v":0},{"$f":"2748878.96","v":0},{"$f":"581448.88","v":0},{"$f":"342721.47","v":0},{"$f":"51688.44","v":0},{"$f":"72708.14","v":0},{"$f":"1477660.27","v":0},{"$f":"787061.54","v":0},{"$f":"135239.71","v":0},{"$f":"135121.63","v":0},{"$f":"2297874.98","v":0},{"$f":"252212.29","v":0},{"$f":"10724.81","v":0},{"$f":"51400.54","v":0},{"$f":"119572.75","v":0},{"$f":"119947.65","v":0},{"$f":"123443.45","v":0},{"$f":"163371.83","v":0},{"$f":"51645.78","v":0},{"$f":"9461.64","v":0},{"$f":"8648.18","v":0},{"$f":"11222.5","v":0},{"$f":"11993.53","v":0},{"$f":"12692.11","v":0},{"$f":"592128.24","v":0},{"$f":"326083.99","v":0},{"$f":"0","v":0},{"$f":"30560.82","v":0},{"$f":"102563.75","v":0},{"$f":"10262.17","v":0},{"$f":"23559.31","v":0},{"$f":"124416.99","v":0},{"$f":"18705.49","v":0},{"$f":"14747.63","v":0},{"$f":"181101.05","v":0},{"$f":"8787.29","v":0},{"$f":"13437.02","v":0},{"$f":"38014.4","v":0},{"$f":"4202.79","v":0},{"$f":"3797.05","v":0},{"$f":"1947.57","v":0},{"$f":"26982.85","v":0},{"$f":"17109.88","v":0},{"$f":"1225.52","v":0},{"$f":"944.4","v":0},{"$f":"1033.23","v":0},{"$f":"1145.95","v":0},{"$f":"1309.72","v":0},{"$f":"2358.96","v":0},{"$f":"24397.78","v":0},{"$f":"4141.79","v":0},{"$f":"0","v":0},{"$f":"65862.87","v":0},{"$f":"85332.63","v":0},{"$f":"11139.22","v":0},{"$f":"69310.16","v":0},{"$f":"92474.81","v":0},{"$f":"95412.41","v":0},{"$f":"382289.43","v":0},{"$f":"135800.41","v":0},{"$f":"28985.85","v":0},{"$f":"60789.41","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}]
[null,"4.6","Incurred Claims",{"$f":"D66-D67-D68-D69","v":142897985.36000001},0,0,0,0,0,0,0,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":"AJ66-AJ67-AJ68-AJ69","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP66-BP67-BP68-BP69","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"4.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E71:XFD71)","v":-73543.710000000006},{"$f":"0","v":0},{"$f":"-2949.25","v":0},{"$f":"-2978.86","v":0},{"$f":"-1424.65","v":0},{"$f":"-1555.71","v":0},{"$f":"-9190.63","v":0},{"$f":"-3161.56","v":0},{"$f":"-6370.32","v":0},{"$f":"-9103.4","v":0},{"$f":"-6026.43","v":0},{"$f":"-8374.28","v":0},{"$f":"-771.12","v":0},{"$f":"-389.74","v":0},{"$f":"-64.62","v":0},{"$f":"-117.06","v":0},{"$f":"-2621.4","v":0},{"$f":"-1242.31","v":0},{"$f":"-218.93","v":0},{"$f":"-203.43","v":0},{"$f":"-4036.71","v":0},{"$f":"-444.73","v":0},{"$f":"-18.5","v":0},{"$f":"-119.74","v":0},{"$f":"-349.33","v":0},{"$f":"-353.51","v":0},{"$f":"-257.19","v":0},{"$f":"-414.6","v":0},{"$f":"-133.2","v":0},{"$f":"-30.42","v":0},{"$f":"-31.01","v":0},{"$f":"-30.2","v":0},{"$f":"-29.5","v":0},{"$f":"-83.47","v":0},{"$f":"-4162.44","v":0},{"$f":"-2394.57","v":0},{"$f":"0","v":0},{"$f":"-40.94","v":0},{"$f":"-117.82","v":0},{"$f":"-12.96","v":0},{"$f":"-38.53","v":0},{"$f":"-222.96","v":0},{"$f":"-30.42","v":0},{"$f":"-22.43","v":0},{"$f":"-321.37","v":0},{"$f":"-15.65","v":0},{"$f":"-23.42","v":0},{"$f":"-60.61","v":0},{"$f":"-9.89","v":0},{"$f":"-9.89","v":0},{"$f":"-4.1","v":0},{"$f":"-69.17","v":0},{"$f":"-50.94","v":0},{"$f":"-3.33","v":0},{"$f":"-3.42","v":0},{"$f":"-3.36","v":0},{"$f":"-3.38","v":0},{"$f":"-3.25","v":0},{"$f":"-15.67","v":0},{"$f":"-173.25","v":0},{"$f":"-30.72","v":0},{"$f":"0","v":0},{"$f":"-111.85","v":0},{"$f":"-158.71","v":0},{"$f":"-18.93","v":0},{"$f":"-112.72","v":0},{"$f":"-257.13","v":0},{"$f":"-293.61","v":0},{"$f":"-980","v":0},{"$f":"-400.76","v":0},{"$f":"-88.72","v":0},{"$f":"-180.98","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":164931455.34999999},{"$f":"0","v":0},{"$f":"6617511.72","v":0},{"$f":"6683933.88","v":0},{"$f":"3196582.2","v":0},{"$f":"3490484.73","v":0},{"$f":"20621916.72","v":0},{"$f":"7094027.71","v":0},{"$f":"14294143.43","v":0},{"$f":"20426751.75","v":0},{"$f":"13522451.28","v":0},{"$f":"18790291.32","v":0},{"$f":"1730221.27","v":0},{"$f":"874174.76","v":0},{"$f":"145160.38","v":0},{"$f":"262722.69","v":0},{"$f":"5881935.07","v":0},{"$f":"2787605.6","v":0},{"$f":"491095.02","v":0},{"$f":"456166.61","v":0},{"$f":"9058030.25","v":0},{"$f":"997591.69","v":0},{"$f":"41798.42","v":0},{"$f":"268217.92","v":0},{"$f":"784172.14","v":0},{"$f":"793568.78","v":0},{"$f":"577289.32","v":0},{"$f":"930737.67","v":0},{"$f":"298952.41","v":0},{"$f":"68167.48","v":0},{"$f":"69497.1","v":0},{"$f":"67684.79","v":0},{"$f":"66107.32","v":0},{"$f":"187422.84","v":0},{"$f":"9339848.36","v":0},{"$f":"5372437.89","v":0},{"$f":"0","v":0},{"$f":"90682.04","v":0},{"$f":"261857.32","v":0},{"$f":"29091.62","v":0},{"$f":"85798.58","v":0},{"$f":"495370.09","v":0},{"$f":"67315.24","v":0},{"$f":"49860.69","v":0},{"$f":"713921","v":0},{"$f":"35006.58","v":0},{"$f":"52064.5","v":0},{"$f":"134840.46","v":0},{"$f":"22195.98","v":0},{"$f":"22239.81","v":0},{"$f":"9362.32","v":0},{"$f":"153883.66","v":0},{"$f":"112821.41","v":0},{"$f":"7432.97","v":0},{"$f":"7632.01","v":0},{"$f":"7485.98","v":0},{"$f":"7544.57","v":0},{"$f":"7259.73","v":0},{"$f":"34509.46","v":0},{"$f":"385056.34","v":0},{"$f":"68228.04","v":0},{"$f":"0","v":0},{"$f":"248142.5","v":0},{"$f":"352204.79","v":0},{"$f":"41807.82","v":0},{"$f":"250319.67","v":0},{"$f":"571569.43","v":0},{"$f":"652039.37","v":0},{"$f":"2176588.64","v":0},{"$f":"890259.27","v":0},{"$f":"196740.54","v":0},{"$f":"401622.4","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":175105},{"$f":"0","v":0},{"$f":"7903","v":0},{"$f":"7748","v":0},{"$f":"3719","v":0},{"$f":"4136","v":0},{"$f":"21623","v":0},{"$f":"7176","v":0},{"$f":"14531","v":0},{"$f":"20813","v":0},{"$f":"13923","v":0},{"$f":"18953","v":0},{"$f":"2086","v":0},{"$f":"1132","v":0},{"$f":"179","v":0},{"$f":"310","v":0},{"$f":"6866","v":0},{"$f":"3302","v":0},{"$f":"572","v":0},{"$f":"547","v":0},{"$f":"10371","v":0},{"$f":"1144","v":0},{"$f":"48","v":0},{"$f":"289","v":0},{"$f":"799","v":0},{"$f":"799","v":0},{"$f":"632","v":0},{"$f":"966","v":0},{"$f":"310","v":0},{"$f":"70","v":0},{"$f":"70","v":0},{"$f":"70","v":0},{"$f":"70","v":0},{"$f":"167","v":0},{"$f":"8225","v":0},{"$f":"4708","v":0},{"$f":"0","v":0},{"$f":"128","v":0},{"$f":"397","v":0},{"$f":"42","v":0},{"$f":"117","v":0},{"$f":"677","v":0},{"$f":"93","v":0},{"$f":"70","v":0},{"$f":"957","v":0},{"$f":"47","v":0},{"$f":"70","v":0},{"$f":"187","v":0},{"$f":"28","v":0},{"$f":"27","v":0},{"$f":"12","v":0},{"$f":"187","v":0},{"$f":"133","v":0},{"$f":"9","v":0},{"$f":"9","v":0},{"$f":"9","v":0},{"$f":"9","v":0},{"$f":"9","v":0},{"$f":"36","v":0},{"$f":"397","v":0},{"$f":"70","v":0},{"$f":"0","v":0},{"$f":"338","v":0},{"$f":"478","v":0},{"$f":"58","v":0},{"$f":"350","v":0},{"$f":"689","v":0},{"$f":"770","v":0},{"$f":"2672","v":0},{"$f":"1062","v":0},{"$f":"233","v":0},{"$f":"478","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.86679482918627704},0,0,0,0,0,0,0,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":"AJ70/(AJ71+AJ72)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP70/(BP71+BP72)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Per Member Per Month"]
[null,"4.11","Allowed Claims",{"$f":"D66/D73","v":984.72630000000004},0,0,0,0,0,0,0,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":"AJ66/AJ73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP66/BP73","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"4.12","Reinsurance",{"$f":"D67/D73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ67/AJ73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP67/BP73","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"4.13","Member Cost Sharing",{"$f":"D68/D73","v":168.65600000000001},0,0,0,0,0,0,0,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":"AJ68/AJ73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP68/BP73","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"4.14","Cost Sharing Reduction",{"$f":"D69/D73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ69/AJ73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP69/BP73","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"4.15","Incurred Claims",{"$f":"D70/D73","v":816.07029999999997},0,0,0,0,0,0,0,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":"AJ70/AJ73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP70/BP73","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"4.16","Risk Adjustment Transfer Amount",{"$f":"D71/D73","v":-0.42},0,0,0,0,0,0,0,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":"AJ71/AJ73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP71/BP73","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"4.17","Premium",{"$f":"D72/D73","v":941.90030000000002},0,0,0,0,0,0,0,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":"AJ72/AJ73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP72/BP73","v":0},0,0,0,0,0,0,0,0,0,0,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.0888]
["Rating Area 2",1.0656000000000001]
["Rating Area 3",0.99450000000000005]
["Rating Area 4",0.99790000000000001]
["Rating Area 5",0.94389999999999996]
["Rating Area 6",1.1345000000000001]
["Rating Area 7",1.0281]
["Rating Area 8",1.081]

{"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":""},null,null,null,null,null,null,null,null,null,"State:",{"$f":"IF('Wksh 1 - Market Experience'!E4=\"\",\"\",'Wksh 1 - Market Experience'!E4)","v":""}]
[null,null,"HIOS Issuer ID:",{"$f":"IF('Wksh 1 - Market Experience'!C4<>\"\", 'Wksh 1 - Market Experience'!C4,\"\")","v":""},null,null,null,null,null,null,null,null,null,"Market: ",{"$f":"IF('Wksh 1 - Market Experience'!E5=\"\",\"\",'Wksh 1 - Market Experience'!E5)","v":""}]
[null,null,"Effective Date of Rate Change(s):",{"$f":"IF('Wksh 1 - Market Experience'!#REF!<>\"\", 'Wksh 1 - Market Experience'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[]
[null,null,"Product/Plan Level Calculations"]
[]
[null,"Field #","Section I: General Product and Plan Information"]
[null,"1.1","Product Name",null,null,null,null,null,null,null,"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":0},null,null,null,null,null,null,"PA"]
[null,"3.3","AV and Cost Sharing Design of Plan",null,null,null,null,null,null,null,null,"RI"]
[null,"3.4","Provider Network Adjustment",null,null,null,null,null,null,null,null,"SC"]
[null,"3.5","Benefits in Addition to EHB",null,null,null,null,null,null,null,null,"SD"]
[null,null,"Administrative Costs",null,null,null,null,null,null,null,null,"TN"]
[null,"3.6","Administrative Expense",null,null,null,null,null,null,null,null,"TX"]
[null,"3.7","Taxes and Fees",null,null,null,null,null,null,null,null,"UT"]
[null,"3.8","Profit & Risk Load",null,null,null,null,null,null,null,null,"VT"]
[null,"3.9","Catastrophic Adjustment",null,null,null,null,null,null,null,null,"VA"]
[null,"3.10","Plan Adjusted Index Rate",null,{"$f":"($E$48*PRODUCT(E49:E51)*E56)/(1-SUM(E53:E55))","v":0},null,null,null,null,null,null,"WA"]
[null,null,null,null,null,null,null,null,null,null,null,"WV"]
[null,"3.11","Age Calibration Factor",null,{"$f":"IF(D59<>\"\", D59, \"\")","v":""},null,null,null,null,null,null,"WI"]
[null,"3.12","Geographic Calibration Factor",null,{"$f":"IF(D60<>\"\", D60, \"\")","v":""},null,null,null,null,null,null,"WY"]
[null,"3.13","Tobacco Calibration Factor",null,{"$f":"IF(D61<>\"\", D61, \"\")","v":""}]
[null,"3.14","Calibrated Plan Adjusted Index Rate",null,{"$f":"E57*(PRODUCT($E$59:$E$61))","v":0}]
[]
[null,null,"Section IV: Projected Plan Level Information"]
[null,"4.1","Plan ID (Standard Component ID)","Total",{"$f":"IF(E13<>\"\",E13,\"\")","v":""}]
[null,"4.2","Allowed Claims",{"$f":"SUM(E66:XFD66)","v":0}]
[null,"4.3","Reinsurance",{"$f":"SUM(E67:XFD67)","v":0}]
[null,"4.4","Member Cost Sharing",{"$f":"SUM(E68:XFD68)","v":0}]
[null,"4.5","Cost Sharing Reduction",{"$f":"SUM(E69:XFD69)","v":0}]
[null,"4.6","Incurred Claims",{"$f":"D66-D67-D68-D69","v":0},{"$f":"E66-E67-E68-E69","v":0}]
[null,"4.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E71:XFD71)","v":0}]
[null,"4.8","Premium",{"$f":"SUM(E72:XFD72)","v":0}]
[null,"4.9","Projected Member Months",{"$f":"SUM(E73:XFD73)","v":0}]
[null,"4.10","Loss Ratio",{"$f":"D70/(D71+D72)","v":{"$error":"#DIV/0!"}},{"$f":"E70/(E71+E72)","v":{"$error":"#DIV/0!"}}]
[null,null,"Per Member Per Month"]
[null,"4.11","Allowed Claims",{"$f":"D66/D73","v":{"$error":"#DIV/0!"}},{"$f":"E66/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.12","Reinsurance",{"$f":"D67/D73","v":{"$error":"#DIV/0!"}},{"$f":"E67/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.13","Member Cost Sharing",{"$f":"D68/D73","v":{"$error":"#DIV/0!"}},{"$f":"E68/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.14","Cost Sharing Reduction",{"$f":"D69/D73","v":{"$error":"#DIV/0!"}},{"$f":"E69/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.15","Incurred Claims",{"$f":"D70/D73","v":{"$error":"#DIV/0!"}},{"$f":"E70/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.16","Risk Adjustment Transfer Amount",{"$f":"D71/D73","v":{"$error":"#DIV/0!"}},{"$f":"E71/E73","v":{"$error":"#DIV/0!"}}]
[null,"4.17","Premium",{"$f":"D72/D73","v":{"$error":"#DIV/0!"}},{"$f":"E72/E73","v":{"$error":"#DIV/0!"}}]