{"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:","UnitedHealthcare of Ohio",null,null,null,null,null,null,null,"To validate, select the Validate button or Ctrl + Shift + I."]
[null,"HIOS Issuer ID:",45920.0,"State:","KY",null,null,null,null,null,"To finalize, select the Finalize button or Ctrl + Shift + F."]
[null,"Effective Date of Rate Change(s):",{"$f":"MAX('Wksh 2 - Plan Product Info'!E19:BI19)","v":"1/1/2026"},"Market: ","Small Group"]
[]
[]
[null,"Market Level Calculations (Same for all Plans)"]
[]
[]
[null,"Section I: Experience Period Data"]
[null,"Experience Period:",null,"2024-01-01","to",{"$f":"EDATE(D12,12)-1","v":"12/31/2024"}]
[null,null,null,null,"Total","PMPM"]
[null,"Allowed Claims",null,null,4326758.13,{"$f":"E14/E19","v":"$925.71"}]
[null,"Reinsurance",null,null,0.0,{"$f":"E15/E19","v":"$0.00"}]
[null,"Incurred Claims in Experience Period",null,null,3604245.34,{"$f":"E16/E19","v":"$771.13"}]
[null,"Risk Adjustment",null,null,-183627.13,{"$f":"E17/E19","v":"-$39.29"}]
[null,"Experience Period Premium",null,null,4226511.95,{"$f":"E18/E19","v":"$904.26"}]
[null,"Experience Period Member Months",null,null,4674.0]
[]
[null,"Section II: Projections"]
[null,null,null,"Year 1 Trend",null,"Year 2 Trend"]
[null,"Benefit Category","Experience Period Index Rate PMPM","Cost","Utilization","Cost","Utilization","Trended EHB Allowed Claims PMPM"]
[null,"Inpatient Hospital","$64.77",1.036,1.048,1.037,1.045,{"$f":"PRODUCT(C24:G24)","v":"$76.21"}]
[null,"Outpatient Hospital","$275.51",1.036,1.048,1.037,1.045,{"$f":"PRODUCT(C25:G25)","v":"$324.16"}]
[null,"Professional","$136.87",1.036,1.048,1.037,1.045,{"$f":"PRODUCT(C26:G26)","v":"$161.04"}]
[null,"Other Medical","$0.20",1.036,1.048,1.037,1.045,{"$f":"PRODUCT(C27:G27)","v":"$0.24"}]
[null,"Capitation","$21.25",1.036,1.048,1.037,1.045,{"$f":"PRODUCT(C28:G28)","v":"$25.00"}]
[null,"Prescription Drug","$427.11",1.036,1.048,1.037,1.045,{"$f":"PRODUCT(C29:G29)","v":"$502.52"}]
[null,"Total",{"$f":"SUM(C24:C29)","v":"$925.71"},null,null,null,null,{"$f":"SUM(H24:H29)","v":"$1,089.16"}]
[]
[null,"Morbidity Adjustment",null,null,null,1.06]
[null,"Demographic Shift",null,null,null,1.0]
[null,"Plan Design Changes",null,null,null,1.002]
[null,"Other",null,null,null,1.041]
[null,"Adjusted Trended EHB Allowed Claims PMPM for",null,{"$f":"IF(C5<>\"\",C5,\"\")","v":"1/1/2026"},null,{"$f":"H30*PRODUCT(F32:F35)","v":"$1,204.25"}]
[]
[null,"Manual EHB Allowed Claims PMPM",null,null,null,1150.02]
[null,"Applied Credibility %",null,null,null,0.0]
[]
[null,null,null,null,null,null,"Projected Period Totals"]
[null,"Projected Index Rate for",null,{"$f":"IF(C5<>\"\",C5,\"\")","v":"1/1/2026"},null,{"$f":"ROUND(F39*F36+(1-F39)*F38,2)","v":"$1,150.02"},{"$f":"F42*F48","v":"$2,206,888.38"}]
[null,"Reinsurance",null,null,null,0.0,{"$f":"F43*F48","v":"$0.00"}]
[null,"Risk Adjustment Payment/Charge",null,null,null,-63.92,{"$f":"F44*F48","v":"-$122,662.48"}]
[null,"Exchange User Fees",null,null,null,0.0,{"$f":"F45*F46*F48","v":"$0.00"}]
[null,"Market Adjusted Index Rate",null,null,null,{"$f":"(F42-F43-F44)/(1-F45)","v":"$1,213.94"},{"$f":"F46*F48","v":"$2,329,550.86"}]
[]
[null,"Projected Member Months",null,null,null,{"$f":"'Wksh 2 - Plan Product Info'!D73","v":"1919"}]
[]
[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":61,"rows_kept":82,"cut":false,"hidden":false,"merged":[[6,2,7,21],[9,4,9,22],[9,23,9,60],[10,4,10,22],[10,23,10,60],[20,4,20,22],[20,23,20,60],[21,4,21,60],[58,4,58,60],[59,4,59,60],[60,4,60,60],[47,4,47,60]]}
["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,"Choice Plus Essential",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choice Essential"]
[null,"1.2","Product ID",null,"45920KY005",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45920KY006"]
[null,"1.3","Plan Name",null,"ELQM","ELQN",{"$f":"ELR3","v":"ELR3"},"ELQR",{"$f":"ELQ2","v":"ELQ2"},{"$f":"ELQ7","v":"ELQ7"},{"$f":"ELQ8","v":"ELQ8"},"ELRA","ELQH","ELQU","ELRT","ELRV",{"$f":"ELR5","v":"ELR5"},{"$f":"ELR9","v":"ELR9"},"ELRZ",{"$f":"ELR7","v":"ELR7"},"ELSB","ELRX","DW2R","ELQL","ELQQ","ELQY",{"$f":"ELQ6","v":"ELQ6"},"ELQV","ELRU","ELRW",{"$f":"ELR6","v":"ELR6"},"ELSA",{"$f":"ELR2","v":"ELR2"},{"$f":"ELR4","v":"ELR4"},{"$f":"ELR8","v":"ELR8"},"ELSC","ELRY","DDST","CT9F","DW2Z","DW2D","DW2E","DW2F","DW2G","CT8E","CT8F","CT8G","CT8H","DDSU","DDSV","DDSW","CT8M",{"$f":"CT87","v":"CT87"},{"$f":"DDT7","v":"DDT7"},{"$f":"CT89","v":"CT89"},"CT9A","CT9B","CT9C","CT9D","CT9E","DDSZ"]
[null,"1.4","Plan ID (Standard Component ID)",null,"45920KY0050003","45920KY0050012","45920KY0050037","45920KY0050046","45920KY0050047","45920KY0050048","45920KY0050049","45920KY0050050","45920KY0050051","45920KY0050052","45920KY0050053","45920KY0050054","45920KY0050055","45920KY0050056","45920KY0050057","45920KY0050058","45920KY0050059","45920KY0050061","45920KY0050060","45920KY0060034","45920KY0060035","45920KY0060036","45920KY0060037","45920KY0060042","45920KY0060043","45920KY0060044","45920KY0060045","45920KY0060046","45920KY0060047","45920KY0060048","45920KY0060049","45920KY0060050","45920KY0060067","45920KY0060008","45920KY0060009","45920KY0060025","45920KY0060038","45920KY0060039","45920KY0060040","45920KY0060041","45920KY0060051","45920KY0060052","45920KY0060053","45920KY0060054","45920KY0060055","45920KY0060056","45920KY0060057","45920KY0060058","45920KY0060059","45920KY0060060","45920KY0060061","45920KY0060062","45920KY0060063","45920KY0060064","45920KY0060065","45920KY0060066","45920KY0060068"]
[null,"1.5","Metal",null,"Gold","Silver","Gold","Gold","Gold","Gold","Silver","Bronze","Gold","Gold","Platinum","Platinum","Gold","Gold","Gold","Gold","Gold","Gold","Silver","Gold","Gold","Gold","Gold","Gold","Platinum","Platinum","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Silver","Silver","Silver","Silver","Silver","Bronze","Gold","Gold","Gold","Gold","Gold","Silver","Bronze","Gold","Gold","Platinum","Platinum","Gold","Gold","Gold","Gold","Gold","Gold","Gold"]
[null,"1.6","AV Metal Value",null,0.816,0.718,0.814,0.81,0.808,0.808,0.716,0.648,0.818,0.808,0.905,0.894,0.813,0.804,0.818,0.805,0.801,0.819,0.714,0.816,0.81,0.808,0.808,0.808,0.905,0.894,0.813,0.804,0.818,0.814,0.805,0.801,0.819,0.72,0.718,0.714,0.718,0.716,0.648,0.819,0.807,0.797,0.793,0.793,0.716,0.649,0.816,0.79,0.903,0.881,0.809,0.795,0.815,0.808,0.796,0.787,0.818]
[null,"1.7","Plan Category",null,"Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated"]
[null,"1.8","Plan Type",null,"POS","POS","POS","POS","POS","POS","POS","POS","POS","POS","POS","POS","POS","POS","POS","POS","POS","POS","POS","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO","HMO"]
[null,"1.9","Exchange Plan?",null,"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"]
[null,"1.10","Effective Date of Proposed Rates",null,"2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01","2026-01-01"]
[null,"1.11","Cumulative Rate Change %  (over 12 mos prior)",null,0.1391,0.095,0.1394,0.1447,0.1457,0.1452,0.0784,0.1009,0.0969,0.1434,0.1073,0.1202,0.1365,0.1399,0.1344,0.1411,0.1414,0.1343,0.0,0.1392,0.1447,0.1459,0.1452,0.1436,0.1071,0.1202,0.1366,0.14,0.1345,0.1395,0.1412,0.1414,0.1343,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"1.12","Product Rate Increase %",null,{"$f":"IF(SUMPRODUCT((E16:W16=\"Renewing\")*((E14:W14=\"Platinum\")+(E14:W14=\"Gold\")+(E14:W14=\"Silver\")+(E14:W14=\"Bronze\")+(E14:W14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:W20,E34:W34,E35:W35,--(E16:W16=\"Renewing\")*((E14:W14=\"Platinum\")+(E14:W14=\"Gold\")+(E14:W14=\"Silver\")+(E14:W14=\"Bronze\")+(E14:W14=\"Catastrophic\")))/SUMPRODUCT(E34:W34,E35:W35,--(E16:W16=\"Renewing\")*((E14:W14=\"Platinum\")+(E14:W14=\"Gold\")+(E14:W14=\"Silver\")+(E14:W14=\"Bronze\")+(E14:W14=\"Catastrophic\"))), 4)-1, 4))","v":"0.1304"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((X16:BI16=\"Renewing\")*((X14:BI14=\"Platinum\")+(X14:BI14=\"Gold\")+(X14:BI14=\"Silver\")+(X14:BI14=\"Bronze\")+(X14:BI14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+X20:BI20,X34:BI34,X35:BI35,--(X16:BI16=\"Renewing\")*((X14:BI14=\"Platinum\")+(X14:BI14=\"Gold\")+(X14:BI14=\"Silver\")+(X14:BI14=\"Bronze\")+(X14:BI14=\"Catastrophic\")))/SUMPRODUCT(X34:BI34,X35:BI35,--(X16:BI16=\"Renewing\")*((X14:BI14=\"Platinum\")+(X14:BI14=\"Gold\")+(X14:BI14=\"Silver\")+(X14:BI14=\"Bronze\")+(X14:BI14=\"Catastrophic\"))), 4)-1, 4))","v":"0.1394"}]
[null,"1.13","Submission Level Rate Increase %",null,{"$f":"IF(SUMPRODUCT((E16:BI16=\"Renewing\")*((E14:BI14=\"Platinum\")+(E14:BI14=\"Gold\")+(E14:BI14=\"Silver\")+(E14:BI14=\"Bronze\")+(E14:BI14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:BI20,E34:BI34,E35:BI35,--(E16:BI16=\"Renewing\")*((E14:BI14=\"Platinum\")+(E14:BI14=\"Gold\")+(E14:BI14=\"Silver\")+(E14:BI14=\"Bronze\")+(E14:BI14=\"Catastrophic\")))/SUMPRODUCT(E34:BI34,E35:BI35,--(E16:BI16=\"Renewing\")*((E14:BI14=\"Platinum\")+(E14:BI14=\"Gold\")+(E14:BI14=\"Silver\")+(E14:BI14=\"Bronze\")+(E14:BI14=\"Catastrophic\"))), 4)-1, 4))","v":"0.1309"}]
[]
["Worksheet 1 Totals",null,"Section II: Experience Period and Current Plan Level Information"]
[null,"2.1","Plan ID (Standard Component ID)","Total",{"$f":"IF(E13<>\"\",E13,\"\")","v":"45920KY0050003"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"45920KY0050012"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"45920KY0050037"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"45920KY0050046"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"45920KY0050047"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"45920KY0050048"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"45920KY0050049"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"45920KY0050050"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"45920KY0050051"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"45920KY0050052"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"45920KY0050053"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"45920KY0050054"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"45920KY0050055"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"45920KY0050056"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"45920KY0050057"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"45920KY0050058"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"45920KY0050059"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"45920KY0050061"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"45920KY0050060"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"45920KY0060034"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"45920KY0060035"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"45920KY0060036"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"45920KY0060037"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"45920KY0060042"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"45920KY0060043"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"45920KY0060044"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"45920KY0060045"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"45920KY0060046"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"45920KY0060047"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"45920KY0060048"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"45920KY0060049"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"45920KY0060050"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"45920KY0060067"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"45920KY0060008"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"45920KY0060009"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"45920KY0060025"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"45920KY0060038"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"45920KY0060039"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"45920KY0060040"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"45920KY0060041"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"45920KY0060051"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"45920KY0060052"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"45920KY0060053"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"45920KY0060054"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"45920KY0060055"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"45920KY0060056"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"45920KY0060057"},{"$f":"IF(AZ13<>\"\",AZ13,\"\")","v":"45920KY0060058"},{"$f":"IF(BA13<>\"\",BA13,\"\")","v":"45920KY0060059"},{"$f":"IF(BB13<>\"\",BB13,\"\")","v":"45920KY0060060"},{"$f":"IF(BC13<>\"\",BC13,\"\")","v":"45920KY0060061"},{"$f":"IF(BD13<>\"\",BD13,\"\")","v":"45920KY0060062"},{"$f":"IF(BE13<>\"\",BE13,\"\")","v":"45920KY0060063"},{"$f":"IF(BF13<>\"\",BF13,\"\")","v":"45920KY0060064"},{"$f":"IF(BG13<>\"\",BG13,\"\")","v":"45920KY0060065"},{"$f":"IF(BH13<>\"\",BH13,\"\")","v":"45920KY0060066"},{"$f":"IF(BI13<>\"\",BI13,\"\")","v":"45920KY0060068"}]
[{"$f":"'Wksh 1 - Market Experience'!E14","v":0},"2.2","Allowed Claims",{"$f":"SUM(E26:BI26)","v":"$4,326,758"},315389.48,437161.61,81258.94,4245.4,284179.43,220717.15,214251.71,981540.35,0.0,14800.11,0.0,49374.81,197542.68,0.0,0.0,41535.69,473305.98,0.0,129400.93,0.0,0.0,0.0,0.0,0.0,0.0,0.0,37975.13,624.36,9011.81,22062.73,261155.3,0.0,0.0,0.0,10123.84,396687.16,0.0,0.0,0.0,3580.16,0.0,0.0,0.0,0.0,0.0,384.33,0.0,0.0,18689.12,0.0,0.0,0.0,0.0,10543.13,111216.79,0.0,0.0]
[{"$f":"'Wksh 1 - Market Experience'!E15","v":0},"2.3","Reinsurance",{"$f":"SUM(E27:BI27)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"2.4","Member Cost Sharing",{"$f":"SUM(E28:BI28)","v":"$722,512"},86135.52,51224.94,27682.56,1487.49,43125.45,47435.56,37697.01,101543.3,0.0,7964.17,0.0,11467.01,26241.34,0.0,0.0,17898.06,92952.86,0.0,34216.65,0.0,0.0,0.0,0.0,0.0,0.0,0.0,5349.6,485.26,3676.49,8375.07,12133.6,0.0,0.0,0.0,2461.17,88016.97,0.0,0.0,0.0,2178.12,0.0,0.0,0.0,0.0,0.0,30.54,0.0,0.0,1210.84,0.0,0.0,0.0,0.0,3677.04,7846.17,0.0,0.0]
[null,"2.5","Cost Sharing Reduction",{"$f":"SUM(E29:BI29)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[{"$f":"'Wksh 1 - Market Experience'!E16","v":0},"2.6","Incurred Claims",{"$f":"D26-D27-D28-D29","v":"$3,604,245"},{"$f":"E26-E27-E28-E29","v":"229253.96"},{"$f":"F26-F27-F28-F29","v":"385936.67"},{"$f":"G26-G27-G28-G29","v":"53576.38"},{"$f":"H26-H27-H28-H29","v":"2757.91"},{"$f":"I26-I27-I28-I29","v":"241053.98"},{"$f":"J26-J27-J28-J29","v":"173281.59"},{"$f":"K26-K27-K28-K29","v":"176554.7"},{"$f":"L26-L27-L28-L29","v":"879997.05"},{"$f":"M26-M27-M28-M29","v":"0"},{"$f":"N26-N27-N28-N29","v":"6835.94"},{"$f":"O26-O27-O28-O29","v":"0"},{"$f":"P26-P27-P28-P29","v":"37907.8"},{"$f":"Q26-Q27-Q28-Q29","v":"171301.34"},{"$f":"R26-R27-R28-R29","v":"0"},{"$f":"S26-S27-S28-S29","v":"0"},{"$f":"T26-T27-T28-T29","v":"23637.63"},{"$f":"U26-U27-U28-U29","v":"380353.12"},{"$f":"V26-V27-V28-V29","v":"0"},{"$f":"W26-W27-W28-W29","v":"95184.28"},{"$f":"X26-X27-X28-X29","v":"0"},{"$f":"Y26-Y27-Y28-Y29","v":"0"},{"$f":"Z26-Z27-Z28-Z29","v":"0"},{"$f":"AA26-AA27-AA28-AA29","v":"0"},{"$f":"AB26-AB27-AB28-AB29","v":"0"},{"$f":"AC26-AC27-AC28-AC29","v":"0"},{"$f":"AD26-AD27-AD28-AD29","v":"0"},{"$f":"AE26-AE27-AE28-AE29","v":"32625.53"},{"$f":"AF26-AF27-AF28-AF29","v":"139.1"},{"$f":"AG26-AG27-AG28-AG29","v":"5335.32"},{"$f":"AH26-AH27-AH28-AH29","v":"13687.66"},{"$f":"AI26-AI27-AI28-AI29","v":"249021.7"},{"$f":"AJ26-AJ27-AJ28-AJ29","v":"0"},{"$f":"AK26-AK27-AK28-AK29","v":"0"},{"$f":"AL26-AL27-AL28-AL29","v":"0"},{"$f":"AM26-AM27-AM28-AM29","v":"7662.67"},{"$f":"AN26-AN27-AN28-AN29","v":"308670.19"},{"$f":"AO26-AO27-AO28-AO29","v":"0"},{"$f":"AP26-AP27-AP28-AP29","v":"0"},{"$f":"AQ26-AQ27-AQ28-AQ29","v":"0"},{"$f":"AR26-AR27-AR28-AR29","v":"1402.04"},{"$f":"AS26-AS27-AS28-AS29","v":"0"},{"$f":"AT26-AT27-AT28-AT29","v":"0"},{"$f":"AU26-AU27-AU28-AU29","v":"0"},{"$f":"AV26-AV27-AV28-AV29","v":"0"},{"$f":"AW26-AW27-AW28-AW29","v":"0"},{"$f":"AX26-AX27-AX28-AX29","v":"353.79"},{"$f":"AY26-AY27-AY28-AY29","v":"0"},{"$f":"AZ26-AZ27-AZ28-AZ29","v":"0"},{"$f":"BA26-BA27-BA28-BA29","v":"17478.28"},{"$f":"BB26-BB27-BB28-BB29","v":"0"},{"$f":"BC26-BC27-BC28-BC29","v":"0"},{"$f":"BD26-BD27-BD28-BD29","v":"0"},{"$f":"BE26-BE27-BE28-BE29","v":"0"},{"$f":"BF26-BF27-BF28-BF29","v":"6866.09"},{"$f":"BG26-BG27-BG28-BG29","v":"103370.62"},{"$f":"BH26-BH27-BH28-BH29","v":"0"},{"$f":"BI26-BI27-BI28-BI29","v":"0"}]
[{"$f":"'Wksh 1 - Market Experience'!E17","v":0},"2.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E31:BI31)","v":"-$183,627"},-35893.69,-12746.46,-5595.95,-1423.02,-14615.5,-12397.86,-4831.84,-10793.37,0.0,-3068.54,0.0,-6847.33,-7545.0,0.0,0.0,-7349.06,-20775.9,0.0,-9727.75,0.0,0.0,0.0,0.0,0.0,0.0,0.0,-1560.06,-146.08,-1089.62,-1977.27,-2010.04,0.0,0.0,0.0,-1501.13,-15994.13,0.0,0.0,0.0,-108.97,0.0,0.0,0.0,0.0,0.0,-288.41,0.0,0.0,-333.95,0.0,0.0,0.0,0.0,-1916.29,-3089.9,0.0,0.0]
[{"$f":"'Wksh 1 - Market Experience'!E18","v":0},"2.8","Premium",{"$f":"SUM(E32:BI32)","v":"$4,226,511"},826158.54,293383.03,128801.01,32753.45,336402.24,285359.17,111213.61,248429.09,0.0,70628.13,0.0,157603.76,173661.82,0.0,0.0,169151.93,478195.18,0.0,223901.83,0.0,0.0,0.0,0.0,0.0,0.0,0.0,35907.63,3362.21,25079.68,45510.42,46264.68,0.0,0.0,0.0,34551.12,368133.99,0.0,0.0,0.0,2508.21,0.0,0.0,0.0,0.0,0.0,6638.28,0.0,0.0,7686.44,0.0,0.0,0.0,0.0,44106.8,71119.7,0.0,0.0]
[{"$f":"'Wksh 1 - Market Experience'!E19","v":0},"2.9","Experience Period Member Months",{"$f":"SUM(E33:BI33)","v":"4674"},730.0,275.0,175.0,41.0,423.0,365.0,134.0,354.0,0.0,72.0,0.0,109.0,174.0,0.0,0.0,235.0,581.0,0.0,163.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,33.0,2.0,32.0,52.0,36.0,0.0,0.0,0.0,24.0,464.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,0.0,8.0,0.0,0.0,17.0,0.0,0.0,0.0,0.0,72.0,100.0,0.0,0.0]
[null,"2.10","Current Enrollment",{"$f":"SUM(E34:BI34)","v":"260"},50.0,11.0,15.0,0.0,30.0,0.0,9.0,28.0,0.0,7.0,0.0,5.0,13.0,0.0,0.0,14.0,27.0,0.0,13.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,2.0,2.0,2.0,3.0,0.0,0.0,0.0,2.0,9.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,6.0,11.0,0.0,0.0]
[null,"2.11","Current Premium PMPM",{"$f":"SUMPRODUCT(E35:BI35,E34:BI34)/D34","v":"$988.13"},1191.69,1255.38,842.21,0.0,846.7,0.0,835.62,769.23,0.0,913.8,0.0,1335.77,1119.39,0.0,0.0,776.65,931.63,0.0,1429.68,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1681.11,906.79,1167.74,1285.13,0.0,0.0,0.0,1439.63,814.77,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,581.92,0.0,0.0,0.0,0.0,0.0,0.0,0.0,714.67,703.31,0.0,0.0]
[null,"2.12","Loss Ratio",{"$f":"D30/(D31+D32)","v":"89.15%"},0.290097629927486,1.37521873931113,0.434855354155097,0.088026560758981,0.749110979526378,0.634821066765836,1.65963303675056,3.7031345708465,0.0,0.101183858575814,0.0,0.251450634642914,1.03121008456579,0.0,0.0,0.146089065045632,0.831519650855119,0.0,0.444424834228306,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.949864284431184,0.0432507392425057,0.222397109469505,0.314419241428658,5.62701899733,0.0,0.0,0.0,0.231850902224176,0.876555667398743,0.0,0.0,0.0,0.584368383321385,0.0,0.0,0.0,0.0,0.0,0.0557161012745143,0.0,0.0,2.37719194449771,0.0,0.0,0.0,0.0,0.162740151754506,1.51949028219986,0.0,0.0]
[null,null,"Per Member Per Month"]
[null,"2.13","Allowed Claims",{"$f":"D26/D33","v":"$925.71"},{"$f":"E26/E33","v":"432.0404"},{"$f":"F26/F33","v":"1589.6786"},{"$f":"G26/G33","v":"464.3368"},{"$f":"H26/H33","v":"103.5463"},{"$f":"I26/I33","v":"671.819"},{"$f":"J26/J33","v":"604.7045"},{"$f":"K26/K33","v":"1598.8934"},{"$f":"L26/L33","v":"2772.7129"},{"$f":"M26/M33","v":"0"},{"$f":"N26/N33","v":"205.5571"},{"$f":"O26/O33","v":"0"},{"$f":"P26/P33","v":"452.9799"},{"$f":"Q26/Q33","v":"1135.3028"},{"$f":"R26/R33","v":"0"},{"$f":"S26/S33","v":"0"},{"$f":"T26/T33","v":"176.7476"},{"$f":"U26/U33","v":"814.6402"},{"$f":"V26/V33","v":"0"},{"$f":"W26/W33","v":"793.8707"},{"$f":"X26/X33","v":"0"},{"$f":"Y26/Y33","v":"0"},{"$f":"Z26/Z33","v":"0"},{"$f":"AA26/AA33","v":"0"},{"$f":"AB26/AB33","v":"0"},{"$f":"AC26/AC33","v":"0"},{"$f":"AD26/AD33","v":"0"},{"$f":"AE26/AE33","v":"1150.7615"},{"$f":"AF26/AF33","v":"312.18"},{"$f":"AG26/AG33","v":"281.6191"},{"$f":"AH26/AH33","v":"424.2833"},{"$f":"AI26/AI33","v":"7254.3139"},{"$f":"AJ26/AJ33","v":"0"},{"$f":"AK26/AK33","v":"0"},{"$f":"AL26/AL33","v":"0"},{"$f":"AM26/AM33","v":"421.8267"},{"$f":"AN26/AN33","v":"854.9292"},{"$f":"AO26/AO33","v":"0"},{"$f":"AP26/AP33","v":"0"},{"$f":"AQ26/AQ33","v":"0"},{"$f":"AR26/AR33","v":"1193.3867"},{"$f":"AS26/AS33","v":"0"},{"$f":"AT26/AT33","v":"0"},{"$f":"AU26/AU33","v":"0"},{"$f":"AV26/AV33","v":"0"},{"$f":"AW26/AW33","v":"0"},{"$f":"AX26/AX33","v":"48.0412"},{"$f":"AY26/AY33","v":"0"},{"$f":"AZ26/AZ33","v":"0"},{"$f":"BA26/BA33","v":"1099.36"},{"$f":"BB26/BB33","v":"0"},{"$f":"BC26/BC33","v":"0"},{"$f":"BD26/BD33","v":"0"},{"$f":"BE26/BE33","v":"0"},{"$f":"BF26/BF33","v":"146.4324"},{"$f":"BG26/BG33","v":"1112.1679"},{"$f":"BH26/BH33","v":"0"},{"$f":"BI26/BI33","v":"0"}]
[null,"2.14","Reinsurance",{"$f":"D27/D33","v":"$0.00"},{"$f":"E27/E33","v":"0"},{"$f":"F27/F33","v":"0"},{"$f":"G27/G33","v":"0"},{"$f":"H27/H33","v":"0"},{"$f":"I27/I33","v":"0"},{"$f":"J27/J33","v":"0"},{"$f":"K27/K33","v":"0"},{"$f":"L27/L33","v":"0"},{"$f":"M27/M33","v":"0"},{"$f":"N27/N33","v":"0"},{"$f":"O27/O33","v":"0"},{"$f":"P27/P33","v":"0"},{"$f":"Q27/Q33","v":"0"},{"$f":"R27/R33","v":"0"},{"$f":"S27/S33","v":"0"},{"$f":"T27/T33","v":"0"},{"$f":"U27/U33","v":"0"},{"$f":"V27/V33","v":"0"},{"$f":"W27/W33","v":"0"},{"$f":"X27/X33","v":"0"},{"$f":"Y27/Y33","v":"0"},{"$f":"Z27/Z33","v":"0"},{"$f":"AA27/AA33","v":"0"},{"$f":"AB27/AB33","v":"0"},{"$f":"AC27/AC33","v":"0"},{"$f":"AD27/AD33","v":"0"},{"$f":"AE27/AE33","v":"0"},{"$f":"AF27/AF33","v":"0"},{"$f":"AG27/AG33","v":"0"},{"$f":"AH27/AH33","v":"0"},{"$f":"AI27/AI33","v":"0"},{"$f":"AJ27/AJ33","v":"0"},{"$f":"AK27/AK33","v":"0"},{"$f":"AL27/AL33","v":"0"},{"$f":"AM27/AM33","v":"0"},{"$f":"AN27/AN33","v":"0"},{"$f":"AO27/AO33","v":"0"},{"$f":"AP27/AP33","v":"0"},{"$f":"AQ27/AQ33","v":"0"},{"$f":"AR27/AR33","v":"0"},{"$f":"AS27/AS33","v":"0"},{"$f":"AT27/AT33","v":"0"},{"$f":"AU27/AU33","v":"0"},{"$f":"AV27/AV33","v":"0"},{"$f":"AW27/AW33","v":"0"},{"$f":"AX27/AX33","v":"0"},{"$f":"AY27/AY33","v":"0"},{"$f":"AZ27/AZ33","v":"0"},{"$f":"BA27/BA33","v":"0"},{"$f":"BB27/BB33","v":"0"},{"$f":"BC27/BC33","v":"0"},{"$f":"BD27/BD33","v":"0"},{"$f":"BE27/BE33","v":"0"},{"$f":"BF27/BF33","v":"0"},{"$f":"BG27/BG33","v":"0"},{"$f":"BH27/BH33","v":"0"},{"$f":"BI27/BI33","v":"0"}]
[null,"2.15","Member Cost Sharing",{"$f":"D28/D33","v":"$154.58"},{"$f":"E28/E33","v":"117.9939"},{"$f":"F28/F33","v":"186.2725"},{"$f":"G28/G33","v":"158.1861"},{"$f":"H28/H33","v":"36.2802"},{"$f":"I28/I33","v":"101.9514"},{"$f":"J28/J33","v":"129.9604"},{"$f":"K28/K33","v":"281.321"},{"$f":"L28/L33","v":"286.8455"},{"$f":"M28/M33","v":"0"},{"$f":"N28/N33","v":"110.6135"},{"$f":"O28/O33","v":"0"},{"$f":"P28/P33","v":"105.2019"},{"$f":"Q28/Q33","v":"150.8123"},{"$f":"R28/R33","v":"0"},{"$f":"S28/S33","v":"0"},{"$f":"T28/T33","v":"76.162"},{"$f":"U28/U33","v":"159.9877"},{"$f":"V28/V33","v":"0"},{"$f":"W28/W33","v":"209.9181"},{"$f":"X28/X33","v":"0"},{"$f":"Y28/Y33","v":"0"},{"$f":"Z28/Z33","v":"0"},{"$f":"AA28/AA33","v":"0"},{"$f":"AB28/AB33","v":"0"},{"$f":"AC28/AC33","v":"0"},{"$f":"AD28/AD33","v":"0"},{"$f":"AE28/AE33","v":"162.1091"},{"$f":"AF28/AF33","v":"242.63"},{"$f":"AG28/AG33","v":"114.8903"},{"$f":"AH28/AH33","v":"161.059"},{"$f":"AI28/AI33","v":"337.0444"},{"$f":"AJ28/AJ33","v":"0"},{"$f":"AK28/AK33","v":"0"},{"$f":"AL28/AL33","v":"0"},{"$f":"AM28/AM33","v":"102.5487"},{"$f":"AN28/AN33","v":"189.6917"},{"$f":"AO28/AO33","v":"0"},{"$f":"AP28/AP33","v":"0"},{"$f":"AQ28/AQ33","v":"0"},{"$f":"AR28/AR33","v":"726.04"},{"$f":"AS28/AS33","v":"0"},{"$f":"AT28/AT33","v":"0"},{"$f":"AU28/AU33","v":"0"},{"$f":"AV28/AV33","v":"0"},{"$f":"AW28/AW33","v":"0"},{"$f":"AX28/AX33","v":"3.8175"},{"$f":"AY28/AY33","v":"0"},{"$f":"AZ28/AZ33","v":"0"},{"$f":"BA28/BA33","v":"71.2259"},{"$f":"BB28/BB33","v":"0"},{"$f":"BC28/BC33","v":"0"},{"$f":"BD28/BD33","v":"0"},{"$f":"BE28/BE33","v":"0"},{"$f":"BF28/BF33","v":"51.07"},{"$f":"BG28/BG33","v":"78.4617"},{"$f":"BH28/BH33","v":"0"},{"$f":"BI28/BI33","v":"0"}]
[null,"2.16","Cost Sharing Reduction",{"$f":"D29/D33","v":"$0.00"},{"$f":"E29/E33","v":"0"},{"$f":"F29/F33","v":"0"},{"$f":"G29/G33","v":"0"},{"$f":"H29/H33","v":"0"},{"$f":"I29/I33","v":"0"},{"$f":"J29/J33","v":"0"},{"$f":"K29/K33","v":"0"},{"$f":"L29/L33","v":"0"},{"$f":"M29/M33","v":"0"},{"$f":"N29/N33","v":"0"},{"$f":"O29/O33","v":"0"},{"$f":"P29/P33","v":"0"},{"$f":"Q29/Q33","v":"0"},{"$f":"R29/R33","v":"0"},{"$f":"S29/S33","v":"0"},{"$f":"T29/T33","v":"0"},{"$f":"U29/U33","v":"0"},{"$f":"V29/V33","v":"0"},{"$f":"W29/W33","v":"0"},{"$f":"X29/X33","v":"0"},{"$f":"Y29/Y33","v":"0"},{"$f":"Z29/Z33","v":"0"},{"$f":"AA29/AA33","v":"0"},{"$f":"AB29/AB33","v":"0"},{"$f":"AC29/AC33","v":"0"},{"$f":"AD29/AD33","v":"0"},{"$f":"AE29/AE33","v":"0"},{"$f":"AF29/AF33","v":"0"},{"$f":"AG29/AG33","v":"0"},{"$f":"AH29/AH33","v":"0"},{"$f":"AI29/AI33","v":"0"},{"$f":"AJ29/AJ33","v":"0"},{"$f":"AK29/AK33","v":"0"},{"$f":"AL29/AL33","v":"0"},{"$f":"AM29/AM33","v":"0"},{"$f":"AN29/AN33","v":"0"},{"$f":"AO29/AO33","v":"0"},{"$f":"AP29/AP33","v":"0"},{"$f":"AQ29/AQ33","v":"0"},{"$f":"AR29/AR33","v":"0"},{"$f":"AS29/AS33","v":"0"},{"$f":"AT29/AT33","v":"0"},{"$f":"AU29/AU33","v":"0"},{"$f":"AV29/AV33","v":"0"},{"$f":"AW29/AW33","v":"0"},{"$f":"AX29/AX33","v":"0"},{"$f":"AY29/AY33","v":"0"},{"$f":"AZ29/AZ33","v":"0"},{"$f":"BA29/BA33","v":"0"},{"$f":"BB29/BB33","v":"0"},{"$f":"BC29/BC33","v":"0"},{"$f":"BD29/BD33","v":"0"},{"$f":"BE29/BE33","v":"0"},{"$f":"BF29/BF33","v":"0"},{"$f":"BG29/BG33","v":"0"},{"$f":"BH29/BH33","v":"0"},{"$f":"BI29/BI33","v":"0"}]
[null,"2.17","Incurred Claims",{"$f":"D30/D33","v":"$771.13"},{"$f":"E30/E33","v":"314.0465"},{"$f":"F30/F33","v":"1403.4061"},{"$f":"G30/G33","v":"306.1507"},{"$f":"H30/H33","v":"67.2661"},{"$f":"I30/I33","v":"569.8676"},{"$f":"J30/J33","v":"474.7441"},{"$f":"K30/K33","v":"1317.5724"},{"$f":"L30/L33","v":"2485.8674"},{"$f":"M30/M33","v":"0"},{"$f":"N30/N33","v":"94.9436"},{"$f":"O30/O33","v":"0"},{"$f":"P30/P33","v":"347.778"},{"$f":"Q30/Q33","v":"984.4905"},{"$f":"R30/R33","v":"0"},{"$f":"S30/S33","v":"0"},{"$f":"T30/T33","v":"100.5857"},{"$f":"U30/U33","v":"654.6525"},{"$f":"V30/V33","v":"0"},{"$f":"W30/W33","v":"583.9526"},{"$f":"X30/X33","v":"0"},{"$f":"Y30/Y33","v":"0"},{"$f":"Z30/Z33","v":"0"},{"$f":"AA30/AA33","v":"0"},{"$f":"AB30/AB33","v":"0"},{"$f":"AC30/AC33","v":"0"},{"$f":"AD30/AD33","v":"0"},{"$f":"AE30/AE33","v":"988.6524"},{"$f":"AF30/AF33","v":"69.55"},{"$f":"AG30/AG33","v":"166.7287"},{"$f":"AH30/AH33","v":"263.2242"},{"$f":"AI30/AI33","v":"6917.2694"},{"$f":"AJ30/AJ33","v":"0"},{"$f":"AK30/AK33","v":"0"},{"$f":"AL30/AL33","v":"0"},{"$f":"AM30/AM33","v":"319.2779"},{"$f":"AN30/AN33","v":"665.2375"},{"$f":"AO30/AO33","v":"0"},{"$f":"AP30/AP33","v":"0"},{"$f":"AQ30/AQ33","v":"0"},{"$f":"AR30/AR33","v":"467.3467"},{"$f":"AS30/AS33","v":"0"},{"$f":"AT30/AT33","v":"0"},{"$f":"AU30/AU33","v":"0"},{"$f":"AV30/AV33","v":"0"},{"$f":"AW30/AW33","v":"0"},{"$f":"AX30/AX33","v":"44.2237"},{"$f":"AY30/AY33","v":"0"},{"$f":"AZ30/AZ33","v":"0"},{"$f":"BA30/BA33","v":"1028.1341"},{"$f":"BB30/BB33","v":"0"},{"$f":"BC30/BC33","v":"0"},{"$f":"BD30/BD33","v":"0"},{"$f":"BE30/BE33","v":"0"},{"$f":"BF30/BF33","v":"95.3624"},{"$f":"BG30/BG33","v":"1033.7062"},{"$f":"BH30/BH33","v":"0"},{"$f":"BI30/BI33","v":"0"}]
[null,"2.18","Risk Adjustment Transfer Amount",{"$f":"D31/D33","v":"-$39.29"},{"$f":"E31/E33","v":"-49.1694"},{"$f":"F31/F33","v":"-46.3508"},{"$f":"G31/G33","v":"-31.9769"},{"$f":"H31/H33","v":"-34.7078"},{"$f":"I31/I33","v":"-34.552"},{"$f":"J31/J33","v":"-33.9667"},{"$f":"K31/K33","v":"-36.0585"},{"$f":"L31/L33","v":"-30.4897"},{"$f":"M31/M33","v":"0"},{"$f":"N31/N33","v":"-42.6186"},{"$f":"O31/O33","v":"0"},{"$f":"P31/P33","v":"-62.8195"},{"$f":"Q31/Q33","v":"-43.3621"},{"$f":"R31/R33","v":"0"},{"$f":"S31/S33","v":"0"},{"$f":"T31/T33","v":"-31.2726"},{"$f":"U31/U33","v":"-35.7589"},{"$f":"V31/V33","v":"0"},{"$f":"W31/W33","v":"-59.6794"},{"$f":"X31/X33","v":"0"},{"$f":"Y31/Y33","v":"0"},{"$f":"Z31/Z33","v":"0"},{"$f":"AA31/AA33","v":"0"},{"$f":"AB31/AB33","v":"0"},{"$f":"AC31/AC33","v":"0"},{"$f":"AD31/AD33","v":"0"},{"$f":"AE31/AE33","v":"-47.2745"},{"$f":"AF31/AF33","v":"-73.04"},{"$f":"AG31/AG33","v":"-34.0506"},{"$f":"AH31/AH33","v":"-38.0244"},{"$f":"AI31/AI33","v":"-55.8344"},{"$f":"AJ31/AJ33","v":"0"},{"$f":"AK31/AK33","v":"0"},{"$f":"AL31/AL33","v":"0"},{"$f":"AM31/AM33","v":"-62.5471"},{"$f":"AN31/AN33","v":"-34.4701"},{"$f":"AO31/AO33","v":"0"},{"$f":"AP31/AP33","v":"0"},{"$f":"AQ31/AQ33","v":"0"},{"$f":"AR31/AR33","v":"-36.3233"},{"$f":"AS31/AS33","v":"0"},{"$f":"AT31/AT33","v":"0"},{"$f":"AU31/AU33","v":"0"},{"$f":"AV31/AV33","v":"0"},{"$f":"AW31/AW33","v":"0"},{"$f":"AX31/AX33","v":"-36.0513"},{"$f":"AY31/AY33","v":"0"},{"$f":"AZ31/AZ33","v":"0"},{"$f":"BA31/BA33","v":"-19.6441"},{"$f":"BB31/BB33","v":"0"},{"$f":"BC31/BC33","v":"0"},{"$f":"BD31/BD33","v":"0"},{"$f":"BE31/BE33","v":"0"},{"$f":"BF31/BF33","v":"-26.6151"},{"$f":"BG31/BG33","v":"-30.899"},{"$f":"BH31/BH33","v":"0"},{"$f":"BI31/BI33","v":"0"}]
[null,"2.19","Premium",{"$f":"D32/D33","v":"$904.26"},{"$f":"E32/E33","v":"1131.724"},{"$f":"F32/F33","v":"1066.8474"},{"$f":"G32/G33","v":"736.0058"},{"$f":"H32/H33","v":"798.8646"},{"$f":"I32/I33","v":"795.2772"},{"$f":"J32/J33","v":"781.8059"},{"$f":"K32/K33","v":"829.9523"},{"$f":"L32/L33","v":"701.7771"},{"$f":"M32/M33","v":"0"},{"$f":"N32/N33","v":"980.9463"},{"$f":"O32/O33","v":"0"},{"$f":"P32/P33","v":"1445.9061"},{"$f":"Q32/Q33","v":"998.0564"},{"$f":"R32/R33","v":"0"},{"$f":"S32/S33","v":"0"},{"$f":"T32/T33","v":"719.7954"},{"$f":"U32/U33","v":"823.0554"},{"$f":"V32/V33","v":"0"},{"$f":"W32/W33","v":"1373.6309"},{"$f":"X32/X33","v":"0"},{"$f":"Y32/Y33","v":"0"},{"$f":"Z32/Z33","v":"0"},{"$f":"AA32/AA33","v":"0"},{"$f":"AB32/AB33","v":"0"},{"$f":"AC32/AC33","v":"0"},{"$f":"AD32/AD33","v":"0"},{"$f":"AE32/AE33","v":"1088.11"},{"$f":"AF32/AF33","v":"1681.105"},{"$f":"AG32/AG33","v":"783.74"},{"$f":"AH32/AH33","v":"875.2004"},{"$f":"AI32/AI33","v":"1285.13"},{"$f":"AJ32/AJ33","v":"0"},{"$f":"AK32/AK33","v":"0"},{"$f":"AL32/AL33","v":"0"},{"$f":"AM32/AM33","v":"1439.63"},{"$f":"AN32/AN33","v":"793.3922"},{"$f":"AO32/AO33","v":"0"},{"$f":"AP32/AP33","v":"0"},{"$f":"AQ32/AQ33","v":"0"},{"$f":"AR32/AR33","v":"836.07"},{"$f":"AS32/AS33","v":"0"},{"$f":"AT32/AT33","v":"0"},{"$f":"AU32/AU33","v":"0"},{"$f":"AV32/AV33","v":"0"},{"$f":"AW32/AW33","v":"0"},{"$f":"AX32/AX33","v":"829.785"},{"$f":"AY32/AY33","v":"0"},{"$f":"AZ32/AZ33","v":"0"},{"$f":"BA32/BA33","v":"452.1435"},{"$f":"BB32/BB33","v":"0"},{"$f":"BC32/BC33","v":"0"},{"$f":"BD32/BD33","v":"0"},{"$f":"BE32/BE33","v":"0"},{"$f":"BF32/BF33","v":"612.5944"},{"$f":"BG32/BG33","v":"711.197"},{"$f":"BH32/BH33","v":"0"},{"$f":"BI32/BI33","v":"0"}]
[]
[null,null,"Section III: Plan Adjustment Factors"]
[null,"3.1","Plan ID (Standard Component ID)",null,{"$f":"IF(E13<>\"\",E13,\"\")","v":"45920KY0050003"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"45920KY0050012"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"45920KY0050037"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"45920KY0050046"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"45920KY0050047"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"45920KY0050048"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"45920KY0050049"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"45920KY0050050"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"45920KY0050051"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"45920KY0050052"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"45920KY0050053"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"45920KY0050054"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"45920KY0050055"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"45920KY0050056"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"45920KY0050057"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"45920KY0050058"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"45920KY0050059"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"45920KY0050061"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"45920KY0050060"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"45920KY0060034"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"45920KY0060035"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"45920KY0060036"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"45920KY0060037"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"45920KY0060042"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"45920KY0060043"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"45920KY0060044"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"45920KY0060045"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"45920KY0060046"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"45920KY0060047"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"45920KY0060048"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"45920KY0060049"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"45920KY0060050"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"45920KY0060067"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"45920KY0060008"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"45920KY0060009"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"45920KY0060025"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"45920KY0060038"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"45920KY0060039"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"45920KY0060040"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"45920KY0060041"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"45920KY0060051"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"45920KY0060052"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"45920KY0060053"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"45920KY0060054"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"45920KY0060055"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"45920KY0060056"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"45920KY0060057"},{"$f":"IF(AZ13<>\"\",AZ13,\"\")","v":"45920KY0060058"},{"$f":"IF(BA13<>\"\",BA13,\"\")","v":"45920KY0060059"},{"$f":"IF(BB13<>\"\",BB13,\"\")","v":"45920KY0060060"},{"$f":"IF(BC13<>\"\",BC13,\"\")","v":"45920KY0060061"},{"$f":"IF(BD13<>\"\",BD13,\"\")","v":"45920KY0060062"},{"$f":"IF(BE13<>\"\",BE13,\"\")","v":"45920KY0060063"},{"$f":"IF(BF13<>\"\",BF13,\"\")","v":"45920KY0060064"},{"$f":"IF(BG13<>\"\",BG13,\"\")","v":"45920KY0060065"},{"$f":"IF(BH13<>\"\",BH13,\"\")","v":"45920KY0060066"},{"$f":"IF(BI13<>\"\",BI13,\"\")","v":"45920KY0060068"}]
[null,"3.2","Market Adjusted Index Rate",null,"$1,213.94"]
[null,"3.3","AV and Cost Sharing Design of Plan",null,0.8897,0.8063,0.87,0.8744,0.8672,0.8657,0.7813,0.7091,0.8801,0.8653,1.042,0.9971,0.8791,0.8535,0.8817,0.8514,0.8406,0.8972,0.0,0.879,0.8637,0.8565,0.855,0.855,1.0315,0.9866,0.8686,0.843,0.8718,0.8601,0.8415,0.8306,0.8867,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"3.4","Provider Network Adjustment",null,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0]
[null,"3.5","Benefits in Addition to EHB",null,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0]
[null,null,"Administrative Costs"]
[null,"3.6","Administrative Expense",null,0.0562,0.061,0.0573,0.057,0.0574,0.0576,0.0625,0.0676,0.0567,0.0575,0.0492,0.0511,0.0567,0.0582,0.0566,0.0583,0.0589,0.0557,0.0,0.0567,0.0576,0.0581,0.058,0.0581,0.0496,0.0516,0.0574,0.0588,0.0572,0.0578,0.0588,0.0595,0.0564,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"3.7","Taxes and Fees",null,0.0355,0.0385,0.0362,0.036,0.0363,0.0363,0.0395,0.0427,0.0358,0.0363,0.0311,0.0323,0.0359,0.0367,0.0358,0.0368,0.0372,0.0353,0.0,0.0359,0.0364,0.0366,0.0367,0.0367,0.0313,0.0325,0.0362,0.0371,0.0361,0.0365,0.0372,0.0376,0.0356,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"3.8","Profit & Risk Load",null,0.0762,0.0826,0.0776,0.0773,0.0778,0.0779,0.0848,0.0917,0.0769,0.078,0.0667,0.0692,0.077,0.0789,0.0768,0.079,0.0799,0.0757,0.0,0.077,0.0781,0.0786,0.0788,0.0787,0.0673,0.0699,0.0777,0.0797,0.0775,0.0784,0.0798,0.0806,0.0764,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"3.9","Catastrophic Adjustment",null,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0]
[null,"3.10","Plan Adjusted Index Rate",null,{"$f":"($E$48*PRODUCT(E49:E51)*E56)/(1-SUM(E53:E55))","v":"$1,297.97"},{"$f":"($E$48*PRODUCT(F49:F51)*F56)/(1-SUM(F53:F55))","v":"$1,196.72"},{"$f":"($E$48*PRODUCT(G49:G51)*G56)/(1-SUM(G53:G55))","v":"$1,274.13"},{"$f":"($E$48*PRODUCT(H49:H51)*H56)/(1-SUM(H53:H55))","v":"$1,279.34"},{"$f":"($E$48*PRODUCT(I49:I51)*I56)/(1-SUM(I53:I55))","v":"$1,270.64"},{"$f":"($E$48*PRODUCT(J49:J51)*J56)/(1-SUM(J53:J55))","v":"$1,268.91"},{"$f":"($E$48*PRODUCT(K49:K51)*K56)/(1-SUM(K53:K55))","v":"$1,166.32"},{"$f":"($E$48*PRODUCT(L49:L51)*L56)/(1-SUM(L53:L55))","v":"$1,078.70"},{"$f":"($E$48*PRODUCT(M49:M51)*M56)/(1-SUM(M53:M55))","v":"$1,286.29"},{"$f":"($E$48*PRODUCT(N49:N51)*N56)/(1-SUM(N53:N55))","v":"$1,268.32"},{"$f":"($E$48*PRODUCT(O49:O51)*O56)/(1-SUM(O53:O55))","v":"$1,482.91"},{"$f":"($E$48*PRODUCT(P49:P51)*P56)/(1-SUM(P53:P55))","v":"$1,428.39"},{"$f":"($E$48*PRODUCT(Q49:Q51)*Q56)/(1-SUM(Q53:Q55))","v":"$1,285.13"},{"$f":"($E$48*PRODUCT(R49:R51)*R56)/(1-SUM(R53:R55))","v":"$1,254.05"},{"$f":"($E$48*PRODUCT(S49:S51)*S56)/(1-SUM(S53:S55))","v":"$1,288.31"},{"$f":"($E$48*PRODUCT(T49:T51)*T56)/(1-SUM(T53:T55))","v":"$1,251.42"},{"$f":"($E$48*PRODUCT(U49:U51)*U56)/(1-SUM(U53:U55))","v":"$1,238.40"},{"$f":"($E$48*PRODUCT(V49:V51)*V56)/(1-SUM(V53:V55))","v":"$1,307.03"},{"$f":"($E$48*PRODUCT(W49:W51)*W56)/(1-SUM(W53:W55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(X49:X51)*X56)/(1-SUM(X53:X55))","v":"$1,284.99"},{"$f":"($E$48*PRODUCT(Y49:Y51)*Y56)/(1-SUM(Y53:Y55))","v":"$1,266.43"},{"$f":"($E$48*PRODUCT(Z49:Z51)*Z56)/(1-SUM(Z53:Z55))","v":"$1,257.70"},{"$f":"($E$48*PRODUCT(AA49:AA51)*AA56)/(1-SUM(AA53:AA55))","v":"$1,255.80"},{"$f":"($E$48*PRODUCT(AB49:AB51)*AB56)/(1-SUM(AB53:AB55))","v":"$1,255.80"},{"$f":"($E$48*PRODUCT(AC49:AC51)*AC56)/(1-SUM(AC53:AC55))","v":"$1,470.04"},{"$f":"($E$48*PRODUCT(AD49:AD51)*AD56)/(1-SUM(AD53:AD55))","v":"$1,415.69"},{"$f":"($E$48*PRODUCT(AE49:AE51)*AE56)/(1-SUM(AE53:AE55))","v":"$1,272.39"},{"$f":"($E$48*PRODUCT(AF49:AF51)*AF56)/(1-SUM(AF53:AF55))","v":"$1,241.33"},{"$f":"($E$48*PRODUCT(AG49:AG51)*AG56)/(1-SUM(AG53:AG55))","v":"$1,276.31"},{"$f":"($E$48*PRODUCT(AH49:AH51)*AH56)/(1-SUM(AH53:AH55))","v":"$1,262.07"},{"$f":"($E$48*PRODUCT(AI49:AI51)*AI56)/(1-SUM(AI53:AI55))","v":"$1,239.42"},{"$f":"($E$48*PRODUCT(AJ49:AJ51)*AJ56)/(1-SUM(AJ53:AJ55))","v":"$1,226.19"},{"$f":"($E$48*PRODUCT(AK49:AK51)*AK56)/(1-SUM(AK53:AK55))","v":"$1,294.37"},{"$f":"($E$48*PRODUCT(AL49:AL51)*AL56)/(1-SUM(AL53:AL55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AM49:AM51)*AM56)/(1-SUM(AM53:AM55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AN49:AN51)*AN56)/(1-SUM(AN53:AN55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AO49:AO51)*AO56)/(1-SUM(AO53:AO55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AP49:AP51)*AP56)/(1-SUM(AP53:AP55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AQ49:AQ51)*AQ56)/(1-SUM(AQ53:AQ55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AR49:AR51)*AR56)/(1-SUM(AR53:AR55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AS49:AS51)*AS56)/(1-SUM(AS53:AS55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AT49:AT51)*AT56)/(1-SUM(AT53:AT55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AU49:AU51)*AU56)/(1-SUM(AU53:AU55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AV49:AV51)*AV56)/(1-SUM(AV53:AV55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AW49:AW51)*AW56)/(1-SUM(AW53:AW55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AX49:AX51)*AX56)/(1-SUM(AX53:AX55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AY49:AY51)*AY56)/(1-SUM(AY53:AY55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AZ49:AZ51)*AZ56)/(1-SUM(AZ53:AZ55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BA49:BA51)*BA56)/(1-SUM(BA53:BA55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BB49:BB51)*BB56)/(1-SUM(BB53:BB55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BC49:BC51)*BC56)/(1-SUM(BC53:BC55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BD49:BD51)*BD56)/(1-SUM(BD53:BD55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BE49:BE51)*BE56)/(1-SUM(BE53:BE55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BF49:BF51)*BF56)/(1-SUM(BF53:BF55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BG49:BG51)*BG56)/(1-SUM(BG53:BG55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BH49:BH51)*BH56)/(1-SUM(BH53:BH55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BI49:BI51)*BI56)/(1-SUM(BI53:BI55))","v":"$0.00"}]
[]
[null,"3.11","Age Calibration Factor","0.6761",{"$f":"IF(D59<>\"\", D59, \"\")","v":"0.6761"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000"]
[null,"3.12","Geographic Calibration Factor","1.2862",{"$f":"IF(D60<>\"\", D60, \"\")","v":"1.2862"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000"]
[null,"3.13","Tobacco Calibration Factor","1.0000",{"$f":"IF(D61<>\"\", D61, \"\")","v":"1.0000"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000"]
[null,"3.14","Calibrated Plan Adjusted Index Rate",null,{"$f":"E57*(PRODUCT($E$59:$E$61))","v":"$1,128.72"},{"$f":"F57*(PRODUCT($E$59:$E$61))","v":"$1,040.67"},{"$f":"G57*(PRODUCT($E$59:$E$61))","v":"$1,107.98"},{"$f":"H57*(PRODUCT($E$59:$E$61))","v":"$1,112.51"},{"$f":"I57*(PRODUCT($E$59:$E$61))","v":"$1,104.95"},{"$f":"J57*(PRODUCT($E$59:$E$61))","v":"$1,103.44"},{"$f":"K57*(PRODUCT($E$59:$E$61))","v":"$1,014.23"},{"$f":"L57*(PRODUCT($E$59:$E$61))","v":"$938.04"},{"$f":"M57*(PRODUCT($E$59:$E$61))","v":"$1,118.55"},{"$f":"N57*(PRODUCT($E$59:$E$61))","v":"$1,102.93"},{"$f":"O57*(PRODUCT($E$59:$E$61))","v":"$1,289.54"},{"$f":"P57*(PRODUCT($E$59:$E$61))","v":"$1,242.13"},{"$f":"Q57*(PRODUCT($E$59:$E$61))","v":"$1,117.55"},{"$f":"R57*(PRODUCT($E$59:$E$61))","v":"$1,090.52"},{"$f":"S57*(PRODUCT($E$59:$E$61))","v":"$1,120.32"},{"$f":"T57*(PRODUCT($E$59:$E$61))","v":"$1,088.24"},{"$f":"U57*(PRODUCT($E$59:$E$61))","v":"$1,076.91"},{"$f":"V57*(PRODUCT($E$59:$E$61))","v":"$1,136.59"},{"$f":"W57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"X57*(PRODUCT($E$59:$E$61))","v":"$1,117.42"},{"$f":"Y57*(PRODUCT($E$59:$E$61))","v":"$1,101.29"},{"$f":"Z57*(PRODUCT($E$59:$E$61))","v":"$1,093.69"},{"$f":"AA57*(PRODUCT($E$59:$E$61))","v":"$1,092.04"},{"$f":"AB57*(PRODUCT($E$59:$E$61))","v":"$1,092.04"},{"$f":"AC57*(PRODUCT($E$59:$E$61))","v":"$1,278.35"},{"$f":"AD57*(PRODUCT($E$59:$E$61))","v":"$1,231.08"},{"$f":"AE57*(PRODUCT($E$59:$E$61))","v":"$1,106.47"},{"$f":"AF57*(PRODUCT($E$59:$E$61))","v":"$1,079.46"},{"$f":"AG57*(PRODUCT($E$59:$E$61))","v":"$1,109.88"},{"$f":"AH57*(PRODUCT($E$59:$E$61))","v":"$1,097.50"},{"$f":"AI57*(PRODUCT($E$59:$E$61))","v":"$1,077.80"},{"$f":"AJ57*(PRODUCT($E$59:$E$61))","v":"$1,066.30"},{"$f":"AK57*(PRODUCT($E$59:$E$61))","v":"$1,125.59"},{"$f":"AL57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AM57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AN57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AO57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AP57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AQ57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AR57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AS57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AT57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AU57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AV57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AW57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AX57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AY57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AZ57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BA57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BB57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BC57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BD57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BE57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BF57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BG57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BH57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BI57*(PRODUCT($E$59:$E$61))","v":"$0.00"}]
[]
[null,null,"Section IV: Projected Plan Level Information"]
[null,"4.1","Plan ID (Standard Component ID)","Total",{"$f":"IF(E13<>\"\",E13,\"\")","v":"45920KY0050003"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"45920KY0050012"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"45920KY0050037"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"45920KY0050046"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"45920KY0050047"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"45920KY0050048"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"45920KY0050049"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"45920KY0050050"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"45920KY0050051"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"45920KY0050052"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"45920KY0050053"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"45920KY0050054"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"45920KY0050055"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"45920KY0050056"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"45920KY0050057"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"45920KY0050058"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"45920KY0050059"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"45920KY0050061"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"45920KY0050060"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"45920KY0060034"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"45920KY0060035"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"45920KY0060036"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"45920KY0060037"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"45920KY0060042"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"45920KY0060043"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"45920KY0060044"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"45920KY0060045"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"45920KY0060046"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"45920KY0060047"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"45920KY0060048"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"45920KY0060049"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"45920KY0060050"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"45920KY0060067"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"45920KY0060008"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"45920KY0060009"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"45920KY0060025"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"45920KY0060038"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"45920KY0060039"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"45920KY0060040"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"45920KY0060041"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"45920KY0060051"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"45920KY0060052"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"45920KY0060053"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"45920KY0060054"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"45920KY0060055"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"45920KY0060056"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"45920KY0060057"},{"$f":"IF(AZ13<>\"\",AZ13,\"\")","v":"45920KY0060058"},{"$f":"IF(BA13<>\"\",BA13,\"\")","v":"45920KY0060059"},{"$f":"IF(BB13<>\"\",BB13,\"\")","v":"45920KY0060060"},{"$f":"IF(BC13<>\"\",BC13,\"\")","v":"45920KY0060061"},{"$f":"IF(BD13<>\"\",BD13,\"\")","v":"45920KY0060062"},{"$f":"IF(BE13<>\"\",BE13,\"\")","v":"45920KY0060063"},{"$f":"IF(BF13<>\"\",BF13,\"\")","v":"45920KY0060064"},{"$f":"IF(BG13<>\"\",BG13,\"\")","v":"45920KY0060065"},{"$f":"IF(BH13<>\"\",BH13,\"\")","v":"45920KY0060066"},{"$f":"IF(BI13<>\"\",BI13,\"\")","v":"45920KY0060068"}]
[null,"4.2","Allowed Claims",{"$f":"SUM(E66:BI66)","v":"$2,206,888"},547821.2,130029.8,35752.54,35752.54,35752.54,35752.54,106285.23,241968.5,35752.54,35752.54,14653.79,14653.79,35752.54,35752.54,35752.54,123403.93,212208.63,35752.54,0.0,35752.54,35752.54,35752.54,35752.54,35752.54,14653.79,14653.79,35752.54,35752.54,35752.54,35752.54,35752.54,35752.54,35752.54,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.3","Reinsurance",{"$f":"SUM(E67:BI67)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.4","Member Cost Sharing",{"$f":"SUM(E68:BI68)","v":"$337,653"},61823.05,23389.82,4737.3,4579.12,4835.83,4889.54,21820.39,67463.91,4376.23,4903.34,273.34,893.52,4412.21,5324.68,4317.84,18632.27,34339.26,3767.09,0.0,4416.56,4960.9,5217.89,5272.17,5269.83,418.33,1038.72,4786.26,5699.3,4671.54,5091.01,5751.83,6139.66,4141.13,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.5","Cost Sharing Reduction",{"$f":"SUM(E69:BI69)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.6","Incurred Claims",{"$f":"D66-D67-D68-D69","v":"$1,869,234"},{"$f":"E66-E67-E68-E69","v":"485998.15"},{"$f":"F66-F67-F68-F69","v":"106639.98"},{"$f":"G66-G67-G68-G69","v":"31015.24"},{"$f":"H66-H67-H68-H69","v":"31173.42"},{"$f":"I66-I67-I68-I69","v":"30916.71"},{"$f":"J66-J67-J68-J69","v":"30863"},{"$f":"K66-K67-K68-K69","v":"84464.84"},{"$f":"L66-L67-L68-L69","v":"174504.59"},{"$f":"M66-M67-M68-M69","v":"31376.31"},{"$f":"N66-N67-N68-N69","v":"30849.2"},{"$f":"O66-O67-O68-O69","v":"14380.45"},{"$f":"P66-P67-P68-P69","v":"13760.27"},{"$f":"Q66-Q67-Q68-Q69","v":"31340.33"},{"$f":"R66-R67-R68-R69","v":"30427.86"},{"$f":"S66-S67-S68-S69","v":"31434.7"},{"$f":"T66-T67-T68-T69","v":"104771.66"},{"$f":"U66-U67-U68-U69","v":"177869.37"},{"$f":"V66-V67-V68-V69","v":"31985.45"},{"$f":"W66-W67-W68-W69","v":"0"},{"$f":"X66-X67-X68-X69","v":"31335.98"},{"$f":"Y66-Y67-Y68-Y69","v":"30791.64"},{"$f":"Z66-Z67-Z68-Z69","v":"30534.65"},{"$f":"AA66-AA67-AA68-AA69","v":"30480.37"},{"$f":"AB66-AB67-AB68-AB69","v":"30482.71"},{"$f":"AC66-AC67-AC68-AC69","v":"14235.46"},{"$f":"AD66-AD67-AD68-AD69","v":"13615.07"},{"$f":"AE66-AE67-AE68-AE69","v":"30966.28"},{"$f":"AF66-AF67-AF68-AF69","v":"30053.24"},{"$f":"AG66-AG67-AG68-AG69","v":"31081"},{"$f":"AH66-AH67-AH68-AH69","v":"30661.53"},{"$f":"AI66-AI67-AI68-AI69","v":"30000.71"},{"$f":"AJ66-AJ67-AJ68-AJ69","v":"29612.88"},{"$f":"AK66-AK67-AK68-AK69","v":"31611.41"},{"$f":"AL66-AL67-AL68-AL69","v":"0"},{"$f":"AM66-AM67-AM68-AM69","v":"0"},{"$f":"AN66-AN67-AN68-AN69","v":"0"},{"$f":"AO66-AO67-AO68-AO69","v":"0"},{"$f":"AP66-AP67-AP68-AP69","v":"0"},{"$f":"AQ66-AQ67-AQ68-AQ69","v":"0"},{"$f":"AR66-AR67-AR68-AR69","v":"0"},{"$f":"AS66-AS67-AS68-AS69","v":"0"},{"$f":"AT66-AT67-AT68-AT69","v":"0"},{"$f":"AU66-AU67-AU68-AU69","v":"0"},{"$f":"AV66-AV67-AV68-AV69","v":"0"},{"$f":"AW66-AW67-AW68-AW69","v":"0"},{"$f":"AX66-AX67-AX68-AX69","v":"0"},{"$f":"AY66-AY67-AY68-AY69","v":"0"},{"$f":"AZ66-AZ67-AZ68-AZ69","v":"0"},{"$f":"BA66-BA67-BA68-BA69","v":"0"},{"$f":"BB66-BB67-BB68-BB69","v":"0"},{"$f":"BC66-BC67-BC68-BC69","v":"0"},{"$f":"BD66-BD67-BD68-BD69","v":"0"},{"$f":"BE66-BE67-BE68-BE69","v":"0"},{"$f":"BF66-BF67-BF68-BF69","v":"0"},{"$f":"BG66-BG67-BG68-BG69","v":"0"},{"$f":"BH66-BH67-BH68-BH69","v":"0"},{"$f":"BI66-BI67-BI68-BI69","v":"0"}]
[null,"4.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E71:BI71)","v":"-$103,894"},-25716.5,-6226.1,-1678.34,-1678.34,-1678.34,-1678.34,-5089.16,-11585.96,-1678.34,-1678.34,-649.68,-649.68,-1678.34,-1678.34,-1678.34,-5792.98,-9961.76,-1678.34,0.0,-1678.34,-1678.34,-1678.34,-1678.34,-1678.34,-649.68,-649.68,-1678.34,-1678.34,-1678.34,-1678.34,-1678.34,-1678.34,-1678.34,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.8","Premium",{"$f":"SUM(E72:BI72)","v":"$2,391,331"},616536.65,137623.16,39498.08,39659.57,39389.97,39336.08,109634.07,230842.4,39874.85,39317.91,17794.97,17140.71,39839.13,38875.61,39937.72,133902.04,227864.79,40517.89,0.0,39834.6,39259.43,38988.66,38929.8,38929.8,17640.47,16988.27,39444.04,38481.19,39565.48,39124.14,38422.04,38011.99,40125.56,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.9","Projected Member Months",{"$f":"SUM(E73:BI73)","v":"1919"},475.0,115.0,31.0,31.0,31.0,31.0,94.0,214.0,31.0,31.0,12.0,12.0,31.0,31.0,31.0,107.0,184.0,31.0,0.0,31.0,31.0,31.0,31.0,31.0,12.0,12.0,31.0,31.0,31.0,31.0,31.0,31.0,31.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.10","Loss Ratio",{"$f":"D70/(D71+D72)","v":"81.72%"},{"$f":"E70/(E71+E72)","v":"0.822582218971374"},{"$f":"F70/(F71+F72)","v":"0.811585738676345"},{"$f":"G70/(G71+G72)","v":"0.820080730327601"},{"$f":"H70/(H71+H72)","v":"0.820758569430216"},{"$f":"I70/(I71+I72)","v":"0.819818978919766"},{"$f":"J70/(J71+J72)","v":"0.819565911284108"},{"$f":"K70/(K71+K72)","v":"0.807928764776783"},{"$f":"L70/(L71+L72)","v":"0.795892654281899"},{"$f":"M70/(M71+M72)","v":"0.821444419922134"},{"$f":"N70/(N71+N72)","v":"0.819594910356308"},{"$f":"O70/(O71+O72)","v":"0.838740552069985"},{"$f":"P70/(P71+P72)","v":"0.834409372853"},{"$f":"Q70/(Q71+Q72)","v":"0.821270471601872"},{"$f":"R70/(R71+R72)","v":"0.818013257424537"},{"$f":"S70/(S71+S72)","v":"0.821620737189155"},{"$f":"T70/(T71+T72)","v":"0.817831775520014"},{"$f":"U70/(U71+U72)","v":"0.816277635056291"},{"$f":"V70/(V71+V72)","v":"0.823527821511835"},{"$f":"W70/(W71+W72)","v":"0"},{"$f":"X70/(X71+X72)","v":"0.821253969859729"},{"$f":"Y70/(Y71+Y72)","v":"0.819338662077124"},{"$f":"Z70/(Z71+Z72)","v":"0.81839689394248"},{"$f":"AA70/(AA71+AA72)","v":"0.818232896106622"},{"$f":"AB70/(AB71+AB72)","v":"0.818295712436506"},{"$f":"AC70/(AC71+AC72)","v":"0.837833908841202"},{"$f":"AD70/(AD71+AD72)","v":"0.833307525312772"},{"$f":"AE70/(AE71+AE72)","v":"0.819957792388331"},{"$f":"AF70/(AF71+AF72)","v":"0.816600888246427"},{"$f":"AG70/(AG71+AG72)","v":"0.820357514449494"},{"$f":"AH70/(AH71+AH72)","v":"0.81882427401738"},{"$f":"AI70/(AI71+AI72)","v":"0.816485819337737"},{"$f":"AJ70/(AJ71+AJ72)","v":"0.815026291055261"},{"$f":"AK70/(AK71+AK72)","v":"0.822202749639636"},{"$f":"AL70/(AL71+AL72)","v":"0"},{"$f":"AM70/(AM71+AM72)","v":"0"},{"$f":"AN70/(AN71+AN72)","v":"0"},{"$f":"AO70/(AO71+AO72)","v":"0"},{"$f":"AP70/(AP71+AP72)","v":"0"},{"$f":"AQ70/(AQ71+AQ72)","v":"0"},{"$f":"AR70/(AR71+AR72)","v":"0"},{"$f":"AS70/(AS71+AS72)","v":"0"},{"$f":"AT70/(AT71+AT72)","v":"0"},{"$f":"AU70/(AU71+AU72)","v":"0"},{"$f":"AV70/(AV71+AV72)","v":"0"},{"$f":"AW70/(AW71+AW72)","v":"0"},{"$f":"AX70/(AX71+AX72)","v":"0"},{"$f":"AY70/(AY71+AY72)","v":"0"},{"$f":"AZ70/(AZ71+AZ72)","v":"0"},{"$f":"BA70/(BA71+BA72)","v":"0"},{"$f":"BB70/(BB71+BB72)","v":"0"},{"$f":"BC70/(BC71+BC72)","v":"0"},{"$f":"BD70/(BD71+BD72)","v":"0"},{"$f":"BE70/(BE71+BE72)","v":"0"},{"$f":"BF70/(BF71+BF72)","v":"0"},{"$f":"BG70/(BG71+BG72)","v":"0"},{"$f":"BH70/(BH71+BH72)","v":"0"},{"$f":"BI70/(BI71+BI72)","v":"0"}]
[null,null,"Per Member Per Month"]
[null,"4.11","Allowed Claims",{"$f":"D66/D73","v":"$1,150.02"},{"$f":"E66/E73","v":"1153.3078"},{"$f":"F66/F73","v":"1130.6939"},{"$f":"G66/G73","v":"1153.3077"},{"$f":"H66/H73","v":"1153.3077"},{"$f":"I66/I73","v":"1153.3077"},{"$f":"J66/J73","v":"1153.3077"},{"$f":"K66/K73","v":"1130.6939"},{"$f":"L66/L73","v":"1130.6939"},{"$f":"M66/M73","v":"1153.3077"},{"$f":"N66/N73","v":"1153.3077"},{"$f":"O66/O73","v":"1221.1492"},{"$f":"P66/P73","v":"1221.1492"},{"$f":"Q66/Q73","v":"1153.3077"},{"$f":"R66/R73","v":"1153.3077"},{"$f":"S66/S73","v":"1153.3077"},{"$f":"T66/T73","v":"1153.3078"},{"$f":"U66/U73","v":"1153.3078"},{"$f":"V66/V73","v":"1153.3077"},{"$f":"W66/W73","v":"0"},{"$f":"X66/X73","v":"1153.3077"},{"$f":"Y66/Y73","v":"1153.3077"},{"$f":"Z66/Z73","v":"1153.3077"},{"$f":"AA66/AA73","v":"1153.3077"},{"$f":"AB66/AB73","v":"1153.3077"},{"$f":"AC66/AC73","v":"1221.1492"},{"$f":"AD66/AD73","v":"1221.1492"},{"$f":"AE66/AE73","v":"1153.3077"},{"$f":"AF66/AF73","v":"1153.3077"},{"$f":"AG66/AG73","v":"1153.3077"},{"$f":"AH66/AH73","v":"1153.3077"},{"$f":"AI66/AI73","v":"1153.3077"},{"$f":"AJ66/AJ73","v":"1153.3077"},{"$f":"AK66/AK73","v":"1153.3077"},{"$f":"AL66/AL73","v":"0"},{"$f":"AM66/AM73","v":"0"},{"$f":"AN66/AN73","v":"0"},{"$f":"AO66/AO73","v":"0"},{"$f":"AP66/AP73","v":"0"},{"$f":"AQ66/AQ73","v":"0"},{"$f":"AR66/AR73","v":"0"},{"$f":"AS66/AS73","v":"0"},{"$f":"AT66/AT73","v":"0"},{"$f":"AU66/AU73","v":"0"},{"$f":"AV66/AV73","v":"0"},{"$f":"AW66/AW73","v":"0"},{"$f":"AX66/AX73","v":"0"},{"$f":"AY66/AY73","v":"0"},{"$f":"AZ66/AZ73","v":"0"},{"$f":"BA66/BA73","v":"0"},{"$f":"BB66/BB73","v":"0"},{"$f":"BC66/BC73","v":"0"},{"$f":"BD66/BD73","v":"0"},{"$f":"BE66/BE73","v":"0"},{"$f":"BF66/BF73","v":"0"},{"$f":"BG66/BG73","v":"0"},{"$f":"BH66/BH73","v":"0"},{"$f":"BI66/BI73","v":"0"}]
[null,"4.12","Reinsurance",{"$f":"D67/D73","v":"$0.00"},{"$f":"E67/E73","v":"0"},{"$f":"F67/F73","v":"0"},{"$f":"G67/G73","v":"0"},{"$f":"H67/H73","v":"0"},{"$f":"I67/I73","v":"0"},{"$f":"J67/J73","v":"0"},{"$f":"K67/K73","v":"0"},{"$f":"L67/L73","v":"0"},{"$f":"M67/M73","v":"0"},{"$f":"N67/N73","v":"0"},{"$f":"O67/O73","v":"0"},{"$f":"P67/P73","v":"0"},{"$f":"Q67/Q73","v":"0"},{"$f":"R67/R73","v":"0"},{"$f":"S67/S73","v":"0"},{"$f":"T67/T73","v":"0"},{"$f":"U67/U73","v":"0"},{"$f":"V67/V73","v":"0"},{"$f":"W67/W73","v":"0"},{"$f":"X67/X73","v":"0"},{"$f":"Y67/Y73","v":"0"},{"$f":"Z67/Z73","v":"0"},{"$f":"AA67/AA73","v":"0"},{"$f":"AB67/AB73","v":"0"},{"$f":"AC67/AC73","v":"0"},{"$f":"AD67/AD73","v":"0"},{"$f":"AE67/AE73","v":"0"},{"$f":"AF67/AF73","v":"0"},{"$f":"AG67/AG73","v":"0"},{"$f":"AH67/AH73","v":"0"},{"$f":"AI67/AI73","v":"0"},{"$f":"AJ67/AJ73","v":"0"},{"$f":"AK67/AK73","v":"0"},{"$f":"AL67/AL73","v":"0"},{"$f":"AM67/AM73","v":"0"},{"$f":"AN67/AN73","v":"0"},{"$f":"AO67/AO73","v":"0"},{"$f":"AP67/AP73","v":"0"},{"$f":"AQ67/AQ73","v":"0"},{"$f":"AR67/AR73","v":"0"},{"$f":"AS67/AS73","v":"0"},{"$f":"AT67/AT73","v":"0"},{"$f":"AU67/AU73","v":"0"},{"$f":"AV67/AV73","v":"0"},{"$f":"AW67/AW73","v":"0"},{"$f":"AX67/AX73","v":"0"},{"$f":"AY67/AY73","v":"0"},{"$f":"AZ67/AZ73","v":"0"},{"$f":"BA67/BA73","v":"0"},{"$f":"BB67/BB73","v":"0"},{"$f":"BC67/BC73","v":"0"},{"$f":"BD67/BD73","v":"0"},{"$f":"BE67/BE73","v":"0"},{"$f":"BF67/BF73","v":"0"},{"$f":"BG67/BG73","v":"0"},{"$f":"BH67/BH73","v":"0"},{"$f":"BI67/BI73","v":"0"}]
[null,"4.13","Member Cost Sharing",{"$f":"D68/D73","v":"$175.95"},{"$f":"E68/E73","v":"130.1538"},{"$f":"F68/F73","v":"203.3897"},{"$f":"G68/G73","v":"152.8161"},{"$f":"H68/H73","v":"147.7135"},{"$f":"I68/I73","v":"155.9945"},{"$f":"J68/J73","v":"157.7271"},{"$f":"K68/K73","v":"232.1318"},{"$f":"L68/L73","v":"315.2519"},{"$f":"M68/M73","v":"141.1687"},{"$f":"N68/N73","v":"158.1723"},{"$f":"O68/O73","v":"22.7783"},{"$f":"P68/P73","v":"74.46"},{"$f":"Q68/Q73","v":"142.3294"},{"$f":"R68/R73","v":"171.7639"},{"$f":"S68/S73","v":"139.2852"},{"$f":"T68/T73","v":"174.1334"},{"$f":"U68/U73","v":"186.6264"},{"$f":"V68/V73","v":"121.519"},{"$f":"W68/W73","v":"0"},{"$f":"X68/X73","v":"142.4697"},{"$f":"Y68/Y73","v":"160.029"},{"$f":"Z68/Z73","v":"168.319"},{"$f":"AA68/AA73","v":"170.07"},{"$f":"AB68/AB73","v":"169.9945"},{"$f":"AC68/AC73","v":"34.8608"},{"$f":"AD68/AD73","v":"86.56"},{"$f":"AE68/AE73","v":"154.3955"},{"$f":"AF68/AF73","v":"183.8484"},{"$f":"AG68/AG73","v":"150.6948"},{"$f":"AH68/AH73","v":"164.2261"},{"$f":"AI68/AI73","v":"185.5429"},{"$f":"AJ68/AJ73","v":"198.0535"},{"$f":"AK68/AK73","v":"133.5848"},{"$f":"AL68/AL73","v":"0"},{"$f":"AM68/AM73","v":"0"},{"$f":"AN68/AN73","v":"0"},{"$f":"AO68/AO73","v":"0"},{"$f":"AP68/AP73","v":"0"},{"$f":"AQ68/AQ73","v":"0"},{"$f":"AR68/AR73","v":"0"},{"$f":"AS68/AS73","v":"0"},{"$f":"AT68/AT73","v":"0"},{"$f":"AU68/AU73","v":"0"},{"$f":"AV68/AV73","v":"0"},{"$f":"AW68/AW73","v":"0"},{"$f":"AX68/AX73","v":"0"},{"$f":"AY68/AY73","v":"0"},{"$f":"AZ68/AZ73","v":"0"},{"$f":"BA68/BA73","v":"0"},{"$f":"BB68/BB73","v":"0"},{"$f":"BC68/BC73","v":"0"},{"$f":"BD68/BD73","v":"0"},{"$f":"BE68/BE73","v":"0"},{"$f":"BF68/BF73","v":"0"},{"$f":"BG68/BG73","v":"0"},{"$f":"BH68/BH73","v":"0"},{"$f":"BI68/BI73","v":"0"}]
[null,"4.14","Cost Sharing Reduction",{"$f":"D69/D73","v":"$0.00"},{"$f":"E69/E73","v":"0"},{"$f":"F69/F73","v":"0"},{"$f":"G69/G73","v":"0"},{"$f":"H69/H73","v":"0"},{"$f":"I69/I73","v":"0"},{"$f":"J69/J73","v":"0"},{"$f":"K69/K73","v":"0"},{"$f":"L69/L73","v":"0"},{"$f":"M69/M73","v":"0"},{"$f":"N69/N73","v":"0"},{"$f":"O69/O73","v":"0"},{"$f":"P69/P73","v":"0"},{"$f":"Q69/Q73","v":"0"},{"$f":"R69/R73","v":"0"},{"$f":"S69/S73","v":"0"},{"$f":"T69/T73","v":"0"},{"$f":"U69/U73","v":"0"},{"$f":"V69/V73","v":"0"},{"$f":"W69/W73","v":"0"},{"$f":"X69/X73","v":"0"},{"$f":"Y69/Y73","v":"0"},{"$f":"Z69/Z73","v":"0"},{"$f":"AA69/AA73","v":"0"},{"$f":"AB69/AB73","v":"0"},{"$f":"AC69/AC73","v":"0"},{"$f":"AD69/AD73","v":"0"},{"$f":"AE69/AE73","v":"0"},{"$f":"AF69/AF73","v":"0"},{"$f":"AG69/AG73","v":"0"},{"$f":"AH69/AH73","v":"0"},{"$f":"AI69/AI73","v":"0"},{"$f":"AJ69/AJ73","v":"0"},{"$f":"AK69/AK73","v":"0"},{"$f":"AL69/AL73","v":"0"},{"$f":"AM69/AM73","v":"0"},{"$f":"AN69/AN73","v":"0"},{"$f":"AO69/AO73","v":"0"},{"$f":"AP69/AP73","v":"0"},{"$f":"AQ69/AQ73","v":"0"},{"$f":"AR69/AR73","v":"0"},{"$f":"AS69/AS73","v":"0"},{"$f":"AT69/AT73","v":"0"},{"$f":"AU69/AU73","v":"0"},{"$f":"AV69/AV73","v":"0"},{"$f":"AW69/AW73","v":"0"},{"$f":"AX69/AX73","v":"0"},{"$f":"AY69/AY73","v":"0"},{"$f":"AZ69/AZ73","v":"0"},{"$f":"BA69/BA73","v":"0"},{"$f":"BB69/BB73","v":"0"},{"$f":"BC69/BC73","v":"0"},{"$f":"BD69/BD73","v":"0"},{"$f":"BE69/BE73","v":"0"},{"$f":"BF69/BF73","v":"0"},{"$f":"BG69/BG73","v":"0"},{"$f":"BH69/BH73","v":"0"},{"$f":"BI69/BI73","v":"0"}]
[null,"4.15","Incurred Claims",{"$f":"D70/D73","v":"$974.07"},{"$f":"E70/E73","v":"1023.154"},{"$f":"F70/F73","v":"927.3042"},{"$f":"G70/G73","v":"1000.4916"},{"$f":"H70/H73","v":"1005.5942"},{"$f":"I70/I73","v":"997.3132"},{"$f":"J70/J73","v":"995.5806"},{"$f":"K70/K73","v":"898.5621"},{"$f":"L70/L73","v":"815.442"},{"$f":"M70/M73","v":"1012.139"},{"$f":"N70/N73","v":"995.1355"},{"$f":"O70/O73","v":"1198.3708"},{"$f":"P70/P73","v":"1146.6892"},{"$f":"Q70/Q73","v":"1010.9784"},{"$f":"R70/R73","v":"981.5439"},{"$f":"S70/S73","v":"1014.0226"},{"$f":"T70/T73","v":"979.1744"},{"$f":"U70/U73","v":"966.6814"},{"$f":"V70/V73","v":"1031.7887"},{"$f":"W70/W73","v":"0"},{"$f":"X70/X73","v":"1010.8381"},{"$f":"Y70/Y73","v":"993.2787"},{"$f":"Z70/Z73","v":"984.9887"},{"$f":"AA70/AA73","v":"983.2377"},{"$f":"AB70/AB73","v":"983.3132"},{"$f":"AC70/AC73","v":"1186.2883"},{"$f":"AD70/AD73","v":"1134.5892"},{"$f":"AE70/AE73","v":"998.9123"},{"$f":"AF70/AF73","v":"969.4594"},{"$f":"AG70/AG73","v":"1002.6129"},{"$f":"AH70/AH73","v":"989.0816"},{"$f":"AI70/AI73","v":"967.7648"},{"$f":"AJ70/AJ73","v":"955.2542"},{"$f":"AK70/AK73","v":"1019.7229"},{"$f":"AL70/AL73","v":"0"},{"$f":"AM70/AM73","v":"0"},{"$f":"AN70/AN73","v":"0"},{"$f":"AO70/AO73","v":"0"},{"$f":"AP70/AP73","v":"0"},{"$f":"AQ70/AQ73","v":"0"},{"$f":"AR70/AR73","v":"0"},{"$f":"AS70/AS73","v":"0"},{"$f":"AT70/AT73","v":"0"},{"$f":"AU70/AU73","v":"0"},{"$f":"AV70/AV73","v":"0"},{"$f":"AW70/AW73","v":"0"},{"$f":"AX70/AX73","v":"0"},{"$f":"AY70/AY73","v":"0"},{"$f":"AZ70/AZ73","v":"0"},{"$f":"BA70/BA73","v":"0"},{"$f":"BB70/BB73","v":"0"},{"$f":"BC70/BC73","v":"0"},{"$f":"BD70/BD73","v":"0"},{"$f":"BE70/BE73","v":"0"},{"$f":"BF70/BF73","v":"0"},{"$f":"BG70/BG73","v":"0"},{"$f":"BH70/BH73","v":"0"},{"$f":"BI70/BI73","v":"0"}]
[null,"4.16","Risk Adjustment Transfer Amount",{"$f":"D71/D73","v":"-$54.14"},{"$f":"E71/E73","v":"-54.14"},{"$f":"F71/F73","v":"-54.14"},{"$f":"G71/G73","v":"-54.14"},{"$f":"H71/H73","v":"-54.14"},{"$f":"I71/I73","v":"-54.14"},{"$f":"J71/J73","v":"-54.14"},{"$f":"K71/K73","v":"-54.14"},{"$f":"L71/L73","v":"-54.14"},{"$f":"M71/M73","v":"-54.14"},{"$f":"N71/N73","v":"-54.14"},{"$f":"O71/O73","v":"-54.14"},{"$f":"P71/P73","v":"-54.14"},{"$f":"Q71/Q73","v":"-54.14"},{"$f":"R71/R73","v":"-54.14"},{"$f":"S71/S73","v":"-54.14"},{"$f":"T71/T73","v":"-54.14"},{"$f":"U71/U73","v":"-54.14"},{"$f":"V71/V73","v":"-54.14"},{"$f":"W71/W73","v":"0"},{"$f":"X71/X73","v":"-54.14"},{"$f":"Y71/Y73","v":"-54.14"},{"$f":"Z71/Z73","v":"-54.14"},{"$f":"AA71/AA73","v":"-54.14"},{"$f":"AB71/AB73","v":"-54.14"},{"$f":"AC71/AC73","v":"-54.14"},{"$f":"AD71/AD73","v":"-54.14"},{"$f":"AE71/AE73","v":"-54.14"},{"$f":"AF71/AF73","v":"-54.14"},{"$f":"AG71/AG73","v":"-54.14"},{"$f":"AH71/AH73","v":"-54.14"},{"$f":"AI71/AI73","v":"-54.14"},{"$f":"AJ71/AJ73","v":"-54.14"},{"$f":"AK71/AK73","v":"-54.14"},{"$f":"AL71/AL73","v":"0"},{"$f":"AM71/AM73","v":"0"},{"$f":"AN71/AN73","v":"0"},{"$f":"AO71/AO73","v":"0"},{"$f":"AP71/AP73","v":"0"},{"$f":"AQ71/AQ73","v":"0"},{"$f":"AR71/AR73","v":"0"},{"$f":"AS71/AS73","v":"0"},{"$f":"AT71/AT73","v":"0"},{"$f":"AU71/AU73","v":"0"},{"$f":"AV71/AV73","v":"0"},{"$f":"AW71/AW73","v":"0"},{"$f":"AX71/AX73","v":"0"},{"$f":"AY71/AY73","v":"0"},{"$f":"AZ71/AZ73","v":"0"},{"$f":"BA71/BA73","v":"0"},{"$f":"BB71/BB73","v":"0"},{"$f":"BC71/BC73","v":"0"},{"$f":"BD71/BD73","v":"0"},{"$f":"BE71/BE73","v":"0"},{"$f":"BF71/BF73","v":"0"},{"$f":"BG71/BG73","v":"0"},{"$f":"BH71/BH73","v":"0"},{"$f":"BI71/BI73","v":"0"}]
[null,"4.17","Premium",{"$f":"D72/D73","v":"$1,246.13"},{"$f":"E72/E73","v":"1297.9719"},{"$f":"F72/F73","v":"1196.7231"},{"$f":"G72/G73","v":"1274.1316"},{"$f":"H72/H73","v":"1279.341"},{"$f":"I72/I73","v":"1270.6442"},{"$f":"J72/J73","v":"1268.9058"},{"$f":"K72/K73","v":"1166.3199"},{"$f":"L72/L73","v":"1078.7028"},{"$f":"M72/M73","v":"1286.2855"},{"$f":"N72/N73","v":"1268.3197"},{"$f":"O72/O73","v":"1482.9142"},{"$f":"P72/P73","v":"1428.3925"},{"$f":"Q72/Q73","v":"1285.1332"},{"$f":"R72/R73","v":"1254.0519"},{"$f":"S72/S73","v":"1288.3135"},{"$f":"T72/T73","v":"1251.4209"},{"$f":"U72/U73","v":"1238.3956"},{"$f":"V72/V73","v":"1307.0287"},{"$f":"W72/W73","v":"0"},{"$f":"X72/X73","v":"1284.9871"},{"$f":"Y72/Y73","v":"1266.4332"},{"$f":"Z72/Z73","v":"1257.6987"},{"$f":"AA72/AA73","v":"1255.8"},{"$f":"AB72/AB73","v":"1255.8"},{"$f":"AC72/AC73","v":"1470.0392"},{"$f":"AD72/AD73","v":"1415.6892"},{"$f":"AE72/AE73","v":"1272.3884"},{"$f":"AF72/AF73","v":"1241.3287"},{"$f":"AG72/AG73","v":"1276.3058"},{"$f":"AH72/AH73","v":"1262.069"},{"$f":"AI72/AI73","v":"1239.4206"},{"$f":"AJ72/AJ73","v":"1226.1932"},{"$f":"AK72/AK73","v":"1294.3729"},{"$f":"AL72/AL73","v":"0"},{"$f":"AM72/AM73","v":"0"},{"$f":"AN72/AN73","v":"0"},{"$f":"AO72/AO73","v":"0"},{"$f":"AP72/AP73","v":"0"},{"$f":"AQ72/AQ73","v":"0"},{"$f":"AR72/AR73","v":"0"},{"$f":"AS72/AS73","v":"0"},{"$f":"AT72/AT73","v":"0"},{"$f":"AU72/AU73","v":"0"},{"$f":"AV72/AV73","v":"0"},{"$f":"AW72/AW73","v":"0"},{"$f":"AX72/AX73","v":"0"},{"$f":"AY72/AY73","v":"0"},{"$f":"AZ72/AZ73","v":"0"},{"$f":"BA72/BA73","v":"0"},{"$f":"BB72/BB73","v":"0"},{"$f":"BC72/BC73","v":"0"},{"$f":"BD72/BD73","v":"0"},{"$f":"BE72/BE73","v":"0"},{"$f":"BF72/BF73","v":"0"},{"$f":"BG72/BG73","v":"0"},{"$f":"BH72/BH73","v":"0"},{"$f":"BI72/BI73","v":"0"}]

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

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