{"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 Kentucky, Ltd.",null,null,null,null,null,null,null,"To validate, select the Validate button or Ctrl + Shift + I."]
[null,"HIOS Issuer ID:",23671.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:BL19)","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,1.730738289E7,{"$f":"E14/E19","v":"$867.15"}]
[null,"Reinsurance",null,null,0.0,{"$f":"E15/E19","v":"$0.00"}]
[null,"Incurred Claims in Experience Period",null,null,1.460516626E7,{"$f":"E16/E19","v":"$731.76"}]
[null,"Risk Adjustment",null,null,-733190.38,{"$f":"E17/E19","v":"-$36.73"}]
[null,"Experience Period Premium",null,null,1.687570986E7,{"$f":"E18/E19","v":"$845.52"}]
[null,"Experience Period Member Months",null,null,19959.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","$161.56",1.035,1.048,1.037,1.045,{"$f":"PRODUCT(C24:G24)","v":"$189.90"}]
[null,"Outpatient Hospital","$413.22",1.035,1.048,1.037,1.045,{"$f":"PRODUCT(C25:G25)","v":"$485.71"}]
[null,"Professional","$138.32",1.035,1.048,1.037,1.045,{"$f":"PRODUCT(C26:G26)","v":"$162.59"}]
[null,"Other Medical","$1.07",1.035,1.048,1.037,1.045,{"$f":"PRODUCT(C27:G27)","v":"$1.26"}]
[null,"Capitation","$21.09",1.035,1.048,1.037,1.045,{"$f":"PRODUCT(C28:G28)","v":"$24.79"}]
[null,"Prescription Drug","$131.88",1.035,1.048,1.037,1.045,{"$f":"PRODUCT(C29:G29)","v":"$155.02"}]
[null,"Total",{"$f":"SUM(C24:C29)","v":"$867.14"},null,null,null,null,{"$f":"SUM(H24:H29)","v":"$1,019.26"}]
[]
[null,"Morbidity Adjustment",null,null,null,1.06]
[null,"Demographic Shift",null,null,null,1.0]
[null,"Plan Design Changes",null,null,null,1.001]
[null,"Other",null,null,null,0.958]
[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,036.08"}]
[]
[null,"Manual EHB Allowed Claims PMPM",null,null,null,1011.64]
[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,011.64"},{"$f":"F42*F48","v":"$9,279,773.72"}]
[null,"Reinsurance",null,null,null,0.0,{"$f":"F43*F48","v":"$0.00"}]
[null,"Risk Adjustment Payment/Charge",null,null,null,-57.13,{"$f":"F44*F48","v":"-$524,053.49"}]
[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,068.77"},{"$f":"F46*F48","v":"$9,803,827.21"}]
[]
[null,"Projected Member Months",null,null,null,{"$f":"'Wksh 2 - Plan Product Info'!D73","v":"9173"}]
[]
[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":64,"rows_kept":82,"cut":false,"hidden":false,"merged":[[6,2,7,21],[9,5,9,25],[9,26,9,63],[10,5,10,25],[10,26,10,63],[20,5,20,25],[20,26,20,63],[21,4,21,63],[58,4,58,63],[59,4,59,63],[60,4,60,63],[47,4,47,63]]}
["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","Choice Plus Essential",null,null,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,"23671KY002","23671KY007",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23671KY008"]
[null,"1.3","Plan Name",null,"CC-BU","ELQK","ELQJ","ELRK","ELQP","ELQX",{"$f":"ELQ4","v":"ELQ4"},"ELQZ",{"$f":"ELQ9","v":"ELQ9"},"ELQE","ELQT","ELRO","ELRQ","ELRN","ELRM","ELRL","ELRJ","ELRI","ELRS","CC-B7","CM-S8","DW2R","ELQG","ELQO","ELQW",{"$f":"ELQ5","v":"ELQ5"},"ELQS","ELRH","ELRP","ELRG","ELRF","ELRE","ELRD","ELRC","ELRB","ELRR","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,"23671KY0020058","23671KY0070003","23671KY0070012","23671KY0070037","23671KY0070046","23671KY0070047","23671KY0070048","23671KY0070049","23671KY0070050","23671KY0070051","23671KY0070052","23671KY0070053","23671KY0070054","23671KY0070055","23671KY0070056","23671KY0070057","23671KY0070058","23671KY0070059","23671KY0070061","23671KY0070006","23671KY0070028","23671KY0070060","23671KY0080034","23671KY0080035","23671KY0080036","23671KY0080037","23671KY0080042","23671KY0080043","23671KY0080044","23671KY0080045","23671KY0080046","23671KY0080047","23671KY0080048","23671KY0080049","23671KY0080050","23671KY0080067","23671KY0080009","23671KY0080010","23671KY0080025","23671KY0080038","23671KY0080039","23671KY0080040","23671KY0080041","23671KY0080051","23671KY0080052","23671KY0080053","23671KY0080054","23671KY0080055","23671KY0080056","23671KY0080057","23671KY0080058","23671KY0080059","23671KY0080060","23671KY0080061","23671KY0080062","23671KY0080063","23671KY0080064","23671KY0080065","23671KY0080066","23671KY0080068"]
[null,"1.5","Metal",null,"Gold","Gold","Silver","Gold","Gold","Gold","Gold","Silver","Bronze","Gold","Gold","Platinum","Platinum","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Silver","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.798,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.815,0.72,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,"Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Terminated","Terminated","Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","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","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","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","2026-01-01","2026-01-01","2026-01-01"]
[null,"1.11","Cumulative Rate Change %  (over 12 mos prior)",null,0.0,0.1409,0.0977,0.1413,0.1464,0.1476,0.1469,0.0816,0.1042,0.0992,0.1453,0.1088,0.1217,0.1383,0.1418,0.1361,0.143,0.1433,0.1359,0.0,0.0,0.0,0.1409,0.1464,0.1476,0.1471,0.1453,0.1088,0.1217,0.1383,0.142,0.1362,0.1414,0.1431,0.1435,0.1362,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,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: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:Z16=\"Renewing\")*((F14:Z14=\"Platinum\")+(F14:Z14=\"Gold\")+(F14:Z14=\"Silver\")+(F14:Z14=\"Bronze\")+(F14:Z14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+F20:Z20,F34:Z34,F35:Z35,--(F16:Z16=\"Renewing\")*((F14:Z14=\"Platinum\")+(F14:Z14=\"Gold\")+(F14:Z14=\"Silver\")+(F14:Z14=\"Bronze\")+(F14:Z14=\"Catastrophic\")))/SUMPRODUCT(F34:Z34,F35:Z35,--(F16:Z16=\"Renewing\")*((F14:Z14=\"Platinum\")+(F14:Z14=\"Gold\")+(F14:Z14=\"Silver\")+(F14:Z14=\"Bronze\")+(F14:Z14=\"Catastrophic\"))), 4)-1, 4))","v":"0.1349"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((AA16:BL16=\"Renewing\")*((AA14:BL14=\"Platinum\")+(AA14:BL14=\"Gold\")+(AA14:BL14=\"Silver\")+(AA14:BL14=\"Bronze\")+(AA14:BL14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+AA20:BL20,AA34:BL34,AA35:BL35,--(AA16:BL16=\"Renewing\")*((AA14:BL14=\"Platinum\")+(AA14:BL14=\"Gold\")+(AA14:BL14=\"Silver\")+(AA14:BL14=\"Bronze\")+(AA14:BL14=\"Catastrophic\")))/SUMPRODUCT(AA34:BL34,AA35:BL35,--(AA16:BL16=\"Renewing\")*((AA14:BL14=\"Platinum\")+(AA14:BL14=\"Gold\")+(AA14:BL14=\"Silver\")+(AA14:BL14=\"Bronze\")+(AA14:BL14=\"Catastrophic\"))), 4)-1, 4))","v":"0.14"}]
[null,"1.13","Submission Level Rate Increase %",null,{"$f":"IF(SUMPRODUCT((E16:BL16=\"Renewing\")*((E14:BL14=\"Platinum\")+(E14:BL14=\"Gold\")+(E14:BL14=\"Silver\")+(E14:BL14=\"Bronze\")+(E14:BL14=\"Catastrophic\")))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:BL20,E34:BL34,E35:BL35,--(E16:BL16=\"Renewing\")*((E14:BL14=\"Platinum\")+(E14:BL14=\"Gold\")+(E14:BL14=\"Silver\")+(E14:BL14=\"Bronze\")+(E14:BL14=\"Catastrophic\")))/SUMPRODUCT(E34:BL34,E35:BL35,--(E16:BL16=\"Renewing\")*((E14:BL14=\"Platinum\")+(E14:BL14=\"Gold\")+(E14:BL14=\"Silver\")+(E14:BL14=\"Bronze\")+(E14:BL14=\"Catastrophic\"))), 4)-1, 4))","v":"0.1354"}]
[]
["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":"23671KY0020058"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"23671KY0070003"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"23671KY0070012"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"23671KY0070037"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"23671KY0070046"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"23671KY0070047"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"23671KY0070048"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"23671KY0070049"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"23671KY0070050"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"23671KY0070051"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"23671KY0070052"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"23671KY0070053"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"23671KY0070054"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"23671KY0070055"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"23671KY0070056"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"23671KY0070057"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"23671KY0070058"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"23671KY0070059"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"23671KY0070061"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"23671KY0070006"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"23671KY0070028"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"23671KY0070060"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"23671KY0080034"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"23671KY0080035"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"23671KY0080036"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"23671KY0080037"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"23671KY0080042"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"23671KY0080043"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"23671KY0080044"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"23671KY0080045"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"23671KY0080046"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"23671KY0080047"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"23671KY0080048"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"23671KY0080049"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"23671KY0080050"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"23671KY0080067"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"23671KY0080009"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"23671KY0080010"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"23671KY0080025"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"23671KY0080038"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"23671KY0080039"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"23671KY0080040"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"23671KY0080041"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"23671KY0080051"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"23671KY0080052"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"23671KY0080053"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"23671KY0080054"},{"$f":"IF(AZ13<>\"\",AZ13,\"\")","v":"23671KY0080055"},{"$f":"IF(BA13<>\"\",BA13,\"\")","v":"23671KY0080056"},{"$f":"IF(BB13<>\"\",BB13,\"\")","v":"23671KY0080057"},{"$f":"IF(BC13<>\"\",BC13,\"\")","v":"23671KY0080058"},{"$f":"IF(BD13<>\"\",BD13,\"\")","v":"23671KY0080059"},{"$f":"IF(BE13<>\"\",BE13,\"\")","v":"23671KY0080060"},{"$f":"IF(BF13<>\"\",BF13,\"\")","v":"23671KY0080061"},{"$f":"IF(BG13<>\"\",BG13,\"\")","v":"23671KY0080062"},{"$f":"IF(BH13<>\"\",BH13,\"\")","v":"23671KY0080063"},{"$f":"IF(BI13<>\"\",BI13,\"\")","v":"23671KY0080064"},{"$f":"IF(BJ13<>\"\",BJ13,\"\")","v":"23671KY0080065"},{"$f":"IF(BK13<>\"\",BK13,\"\")","v":"23671KY0080066"},{"$f":"IF(BL13<>\"\",BL13,\"\")","v":"23671KY0080068"}]
[{"$f":"'Wksh 1 - Market Experience'!E14","v":0},"2.2","Allowed Claims",{"$f":"SUM(E26:BL26)","v":"$17,307,382"},0.0,5175982.07,445871.37,334486.84,680654.44,1656716.21,794854.13,375127.27,162007.07,250787.23,555755.38,294471.31,2383697.96,127184.77,95057.16,518672.11,190475.69,371720.57,0.0,1431.89,855.95,174581.24,282.38,290635.26,0.0,485.98,0.0,15974.15,7340.01,0.0,31489.4,1283043.77,249405.7,0.0,30835.53,0.0,10894.4,33580.14,79187.53,372564.66,47252.99,3869.89,0.0,7065.03,1397.69,0.0,56063.29,0.0,2732.09,0.0,0.0,91260.47,19932.83,0.0,129.34,5659.99,20782.11,55127.6,0.0,0.0]
[{"$f":"'Wksh 1 - Market Experience'!E15","v":0},"2.3","Reinsurance",{"$f":"SUM(E27:BL27)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"2.4","Member Cost Sharing",{"$f":"SUM(E28:BL28)","v":"$2,702,216"},0.0,885895.93,69875.26,60408.55,185523.28,104575.02,182750.76,55726.58,70933.81,82354.7,125163.76,34904.42,63084.15,37421.61,19615.05,114013.88,56578.3,80983.93,0.0,1133.95,772.19,73826.13,67.58,76976.08,0.0,345.55,0.0,5365.88,1578.81,0.0,8347.52,70780.64,66344.93,0.0,10372.57,0.0,4719.06,17115.51,43902.17,9593.74,19864.95,1175.81,0.0,2588.28,309.84,0.0,12913.35,0.0,2259.85,0.0,0.0,9071.33,1782.02,0.0,10.0,3041.05,5420.9,22727.95,0.0,0.0]
[null,"2.5","Cost Sharing Reduction",{"$f":"SUM(E29:BL29)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[{"$f":"'Wksh 1 - Market Experience'!E16","v":0},"2.6","Incurred Claims",{"$f":"D26-D27-D28-D29","v":"$14,605,166"},{"$f":"E26-E27-E28-E29","v":"0"},{"$f":"F26-F27-F28-F29","v":"4290086.14"},{"$f":"G26-G27-G28-G29","v":"375996.11"},{"$f":"H26-H27-H28-H29","v":"274078.29"},{"$f":"I26-I27-I28-I29","v":"495131.16"},{"$f":"J26-J27-J28-J29","v":"1552141.19"},{"$f":"K26-K27-K28-K29","v":"612103.37"},{"$f":"L26-L27-L28-L29","v":"319400.69"},{"$f":"M26-M27-M28-M29","v":"91073.26"},{"$f":"N26-N27-N28-N29","v":"168432.53"},{"$f":"O26-O27-O28-O29","v":"430591.62"},{"$f":"P26-P27-P28-P29","v":"259566.89"},{"$f":"Q26-Q27-Q28-Q29","v":"2320613.81"},{"$f":"R26-R27-R28-R29","v":"89763.16"},{"$f":"S26-S27-S28-S29","v":"75442.11"},{"$f":"T26-T27-T28-T29","v":"404658.23"},{"$f":"U26-U27-U28-U29","v":"133897.39"},{"$f":"V26-V27-V28-V29","v":"290736.64"},{"$f":"W26-W27-W28-W29","v":"0"},{"$f":"X26-X27-X28-X29","v":"297.94"},{"$f":"Y26-Y27-Y28-Y29","v":"83.76"},{"$f":"Z26-Z27-Z28-Z29","v":"100755.11"},{"$f":"AA26-AA27-AA28-AA29","v":"214.8"},{"$f":"AB26-AB27-AB28-AB29","v":"213659.18"},{"$f":"AC26-AC27-AC28-AC29","v":"0"},{"$f":"AD26-AD27-AD28-AD29","v":"140.43"},{"$f":"AE26-AE27-AE28-AE29","v":"0"},{"$f":"AF26-AF27-AF28-AF29","v":"10608.27"},{"$f":"AG26-AG27-AG28-AG29","v":"5761.2"},{"$f":"AH26-AH27-AH28-AH29","v":"0"},{"$f":"AI26-AI27-AI28-AI29","v":"23141.88"},{"$f":"AJ26-AJ27-AJ28-AJ29","v":"1212263.13"},{"$f":"AK26-AK27-AK28-AK29","v":"183060.77"},{"$f":"AL26-AL27-AL28-AL29","v":"0"},{"$f":"AM26-AM27-AM28-AM29","v":"20462.96"},{"$f":"AN26-AN27-AN28-AN29","v":"0"},{"$f":"AO26-AO27-AO28-AO29","v":"6175.34"},{"$f":"AP26-AP27-AP28-AP29","v":"16464.63"},{"$f":"AQ26-AQ27-AQ28-AQ29","v":"35285.36"},{"$f":"AR26-AR27-AR28-AR29","v":"362970.92"},{"$f":"AS26-AS27-AS28-AS29","v":"27388.04"},{"$f":"AT26-AT27-AT28-AT29","v":"2694.08"},{"$f":"AU26-AU27-AU28-AU29","v":"0"},{"$f":"AV26-AV27-AV28-AV29","v":"4476.75"},{"$f":"AW26-AW27-AW28-AW29","v":"1087.85"},{"$f":"AX26-AX27-AX28-AX29","v":"0"},{"$f":"AY26-AY27-AY28-AY29","v":"43149.94"},{"$f":"AZ26-AZ27-AZ28-AZ29","v":"0"},{"$f":"BA26-BA27-BA28-BA29","v":"472.24"},{"$f":"BB26-BB27-BB28-BB29","v":"0"},{"$f":"BC26-BC27-BC28-BC29","v":"0"},{"$f":"BD26-BD27-BD28-BD29","v":"82189.14"},{"$f":"BE26-BE27-BE28-BE29","v":"18150.81"},{"$f":"BF26-BF27-BF28-BF29","v":"0"},{"$f":"BG26-BG27-BG28-BG29","v":"119.34"},{"$f":"BH26-BH27-BH28-BH29","v":"2618.94"},{"$f":"BI26-BI27-BI28-BI29","v":"15361.21"},{"$f":"BJ26-BJ27-BJ28-BJ29","v":"32399.65"},{"$f":"BK26-BK27-BK28-BK29","v":"0"},{"$f":"BL26-BL27-BL28-BL29","v":"0"}]
[{"$f":"'Wksh 1 - Market Experience'!E17","v":0},"2.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E31:BL31)","v":"-$733,190"},0.0,-241929.66,-13536.09,-14737.85,-40285.75,-22184.68,-57160.01,-6613.95,-12094.98,-16642.96,-25634.75,-25158.82,-42362.39,-8707.38,-3634.91,-34069.71,-13566.34,-21857.97,0.0,0.0,0.0,-26168.83,-64.09,-21034.31,0.0,-26.7,0.0,-2334.56,-874.43,0.0,-2624.18,-15664.53,-19202.88,0.0,-1778.84,0.0,-3333.72,-5145.29,-8834.86,-1991.28,-4747.34,-1298.87,0.0,-256.22,-156.52,0.0,-2342.99,0.0,-605.26,0.0,0.0,-5641.23,-820.41,0.0,-93.34,-280.95,-1600.89,-6089.65,0.0,0.0]
[{"$f":"'Wksh 1 - Market Experience'!E18","v":0},"2.8","Premium",{"$f":"SUM(E32:BL32)","v":"$16,875,709"},0.0,5568451.04,311557.73,339218.4,927249.87,510620.65,1315641.67,152232.05,278388.03,383067.96,590030.44,579076.02,975047.36,200416.24,83664.05,784176.29,312253.9,503100.87,0.0,0.0,0.0,602323.32,1475.09,484142.96,0.0,614.54,0.0,53734.08,20126.63,0.0,60400.2,360547.63,441989.22,0.0,40943.17,0.0,76731.73,118428.17,203350.38,45832.86,109268.76,29895.93,0.0,5897.44,3602.53,0.0,53928.24,0.0,13931.16,0.0,0.0,129843.22,18883.34,0.0,2148.28,6466.68,36847.38,140164.35,0.0,0.0]
[{"$f":"'Wksh 1 - Market Experience'!E19","v":0},"2.9","Experience Period Member Months",{"$f":"SUM(E33:BL33)","v":"19959"},0.0,6246.0,337.0,466.0,1150.0,603.0,1496.0,252.0,449.0,498.0,702.0,559.0,949.0,273.0,93.0,968.0,396.0,558.0,0.0,0.0,0.0,802.0,2.0,537.0,0.0,1.0,0.0,48.0,28.0,0.0,95.0,371.0,620.0,0.0,44.0,0.0,142.0,161.0,277.0,54.0,154.0,60.0,0.0,10.0,6.0,0.0,49.0,0.0,20.0,0.0,0.0,189.0,18.0,0.0,5.0,6.0,52.0,213.0,0.0,0.0]
[null,"2.10","Current Enrollment",{"$f":"SUM(E34:BL34)","v":"1358"},0.0,443.0,23.0,23.0,56.0,38.0,96.0,22.0,24.0,40.0,29.0,56.0,72.0,0.0,8.0,52.0,29.0,38.0,0.0,0.0,0.0,71.0,0.0,3.0,0.0,0.0,0.0,4.0,0.0,0.0,11.0,11.0,61.0,0.0,29.0,0.0,11.0,10.0,24.0,6.0,10.0,5.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,19.0,1.0,0.0,5.0,6.0,4.0,18.0,0.0,0.0]
[null,"2.11","Current Premium PMPM",{"$f":"SUMPRODUCT(E35:BL35,E34:BL34)/D34","v":"$897.28"},0.0,952.53,943.86,849.27,858.05,833.49,944.22,628.61,629.47,760.49,1008.52,1045.68,1047.49,0.0,1026.93,936.66,849.93,924.53,0.0,0.0,0.0,767.18,0.0,694.66,0.0,0.0,0.0,1119.46,0.0,0.0,674.61,1308.71,851.0,0.0,901.21,0.0,569.91,598.41,762.83,974.99,805.28,553.54,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,653.4,1231.31,0.0,429.66,1077.78,710.02,689.58,0.0,0.0]
[null,"2.12","Loss Ratio",{"$f":"D30/(D31+D32)","v":"90.48%"},0.0,0.805419866727354,1.26164029565101,0.84466785451393,0.558231329582982,3.17777822546525,0.486382431667697,2.19341338748411,0.3420038938305,0.459664406085829,0.762925067694971,0.468602329012351,2.48810036040358,0.468226455470029,0.942683002716261,0.539467644717901,0.448285794025034,0.604136996099059,0.0,0.0,0.0,0.174875162389171,0.15223245924876,0.461358646615648,0.0,0.238891535111595,0.0,0.206388503238941,0.299248917006888,0.0,0.400544724264496,3.51499719760116,0.432986482013586,0.0,0.522489724706129,0.0,0.0841349785913814,0.145340849385185,0.181401257853358,8.27914778618836,0.262032796722433,0.0942082857468565,0.0,0.793578339437214,0.315683935914289,0.0,0.836478256866062,0.0,0.0354377565492762,0.0,0.0,0.661737706457038,1.00486521289735,0.0,0.0580746883120675,0.42338414382781,0.435822403876244,0.241653719903904,0.0,0.0]
[null,null,"Per Member Per Month"]
[null,"2.13","Allowed Claims",{"$f":"D26/D33","v":"$867.15"},{"$f":"E26/E33","v":"0"},{"$f":"F26/F33","v":"828.6875"},{"$f":"G26/G33","v":"1323.0604"},{"$f":"H26/H33","v":"717.7829"},{"$f":"I26/I33","v":"591.8734"},{"$f":"J26/J33","v":"2747.4564"},{"$f":"K26/K33","v":"531.3196"},{"$f":"L26/L33","v":"1488.6003"},{"$f":"M26/M33","v":"360.8175"},{"$f":"N26/N33","v":"503.5888"},{"$f":"O26/O33","v":"791.6743"},{"$f":"P26/P33","v":"526.7823"},{"$f":"Q26/Q33","v":"2511.7997"},{"$f":"R26/R33","v":"465.8783"},{"$f":"S26/S33","v":"1022.12"},{"$f":"T26/T33","v":"535.8183"},{"$f":"U26/U33","v":"480.9992"},{"$f":"V26/V33","v":"666.1659"},{"$f":"W26/W33","v":"0"},{"$f":"X26/X33","v":"0"},{"$f":"Y26/Y33","v":"0"},{"$f":"Z26/Z33","v":"217.6823"},{"$f":"AA26/AA33","v":"141.19"},{"$f":"AB26/AB33","v":"541.2202"},{"$f":"AC26/AC33","v":"0"},{"$f":"AD26/AD33","v":"485.98"},{"$f":"AE26/AE33","v":"0"},{"$f":"AF26/AF33","v":"332.7948"},{"$f":"AG26/AG33","v":"262.1432"},{"$f":"AH26/AH33","v":"0"},{"$f":"AI26/AI33","v":"331.4674"},{"$f":"AJ26/AJ33","v":"3458.339"},{"$f":"AK26/AK33","v":"402.2673"},{"$f":"AL26/AL33","v":"0"},{"$f":"AM26/AM33","v":"700.8075"},{"$f":"AN26/AN33","v":"0"},{"$f":"AO26/AO33","v":"76.7211"},{"$f":"AP26/AP33","v":"208.5723"},{"$f":"AQ26/AQ33","v":"285.8756"},{"$f":"AR26/AR33","v":"6899.3456"},{"$f":"AS26/AS33","v":"306.8376"},{"$f":"AT26/AT33","v":"64.4982"},{"$f":"AU26/AU33","v":"0"},{"$f":"AV26/AV33","v":"706.503"},{"$f":"AW26/AW33","v":"232.9483"},{"$f":"AX26/AX33","v":"0"},{"$f":"AY26/AY33","v":"1144.1488"},{"$f":"AZ26/AZ33","v":"0"},{"$f":"BA26/BA33","v":"136.6045"},{"$f":"BB26/BB33","v":"0"},{"$f":"BC26/BC33","v":"0"},{"$f":"BD26/BD33","v":"482.8596"},{"$f":"BE26/BE33","v":"1107.3794"},{"$f":"BF26/BF33","v":"0"},{"$f":"BG26/BG33","v":"25.868"},{"$f":"BH26/BH33","v":"943.3317"},{"$f":"BI26/BI33","v":"399.656"},{"$f":"BJ26/BJ33","v":"258.815"},{"$f":"BK26/BK33","v":"0"},{"$f":"BL26/BL33","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"},{"$f":"BJ27/BJ33","v":"0"},{"$f":"BK27/BK33","v":"0"},{"$f":"BL27/BL33","v":"0"}]
[null,"2.15","Member Cost Sharing",{"$f":"D28/D33","v":"$135.39"},{"$f":"E28/E33","v":"0"},{"$f":"F28/F33","v":"141.8341"},{"$f":"G28/G33","v":"207.345"},{"$f":"H28/H33","v":"129.6321"},{"$f":"I28/I33","v":"161.3246"},{"$f":"J28/J33","v":"173.4246"},{"$f":"K28/K33","v":"122.1596"},{"$f":"L28/L33","v":"221.1372"},{"$f":"M28/M33","v":"157.9818"},{"$f":"N28/N33","v":"165.3709"},{"$f":"O28/O33","v":"178.296"},{"$f":"P28/P33","v":"62.4408"},{"$f":"Q28/Q33","v":"66.4743"},{"$f":"R28/R33","v":"137.0755"},{"$f":"S28/S33","v":"210.9145"},{"$f":"T28/T33","v":"117.7829"},{"$f":"U28/U33","v":"142.8745"},{"$f":"V28/V33","v":"145.1325"},{"$f":"W28/W33","v":"0"},{"$f":"X28/X33","v":"0"},{"$f":"Y28/Y33","v":"0"},{"$f":"Z28/Z33","v":"92.0525"},{"$f":"AA28/AA33","v":"33.79"},{"$f":"AB28/AB33","v":"143.3447"},{"$f":"AC28/AC33","v":"0"},{"$f":"AD28/AD33","v":"345.55"},{"$f":"AE28/AE33","v":"0"},{"$f":"AF28/AF33","v":"111.7892"},{"$f":"AG28/AG33","v":"56.3861"},{"$f":"AH28/AH33","v":"0"},{"$f":"AI28/AI33","v":"87.8686"},{"$f":"AJ28/AJ33","v":"190.7834"},{"$f":"AK28/AK33","v":"107.008"},{"$f":"AL28/AL33","v":"0"},{"$f":"AM28/AM33","v":"235.7402"},{"$f":"AN28/AN33","v":"0"},{"$f":"AO28/AO33","v":"33.2328"},{"$f":"AP28/AP33","v":"106.3075"},{"$f":"AQ28/AQ33","v":"158.4916"},{"$f":"AR28/AR33","v":"177.6619"},{"$f":"AS28/AS33","v":"128.9932"},{"$f":"AT28/AT33","v":"19.5968"},{"$f":"AU28/AU33","v":"0"},{"$f":"AV28/AV33","v":"258.828"},{"$f":"AW28/AW33","v":"51.64"},{"$f":"AX28/AX33","v":"0"},{"$f":"AY28/AY33","v":"263.5378"},{"$f":"AZ28/AZ33","v":"0"},{"$f":"BA28/BA33","v":"112.9925"},{"$f":"BB28/BB33","v":"0"},{"$f":"BC28/BC33","v":"0"},{"$f":"BD28/BD33","v":"47.9965"},{"$f":"BE28/BE33","v":"99.0011"},{"$f":"BF28/BF33","v":"0"},{"$f":"BG28/BG33","v":"2"},{"$f":"BH28/BH33","v":"506.8417"},{"$f":"BI28/BI33","v":"104.2481"},{"$f":"BJ28/BJ33","v":"106.704"},{"$f":"BK28/BK33","v":"0"},{"$f":"BL28/BL33","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"},{"$f":"BJ29/BJ33","v":"0"},{"$f":"BK29/BK33","v":"0"},{"$f":"BL29/BL33","v":"0"}]
[null,"2.17","Incurred Claims",{"$f":"D30/D33","v":"$731.76"},{"$f":"E30/E33","v":"0"},{"$f":"F30/F33","v":"686.8534"},{"$f":"G30/G33","v":"1115.7155"},{"$f":"H30/H33","v":"588.1508"},{"$f":"I30/I33","v":"430.5488"},{"$f":"J30/J33","v":"2574.0318"},{"$f":"K30/K33","v":"409.16"},{"$f":"L30/L33","v":"1267.4631"},{"$f":"M30/M33","v":"202.8358"},{"$f":"N30/N33","v":"338.2179"},{"$f":"O30/O33","v":"613.3784"},{"$f":"P30/P33","v":"464.3415"},{"$f":"Q30/Q33","v":"2445.3254"},{"$f":"R30/R33","v":"328.8028"},{"$f":"S30/S33","v":"811.2055"},{"$f":"T30/T33","v":"418.0354"},{"$f":"U30/U33","v":"338.1247"},{"$f":"V30/V33","v":"521.0334"},{"$f":"W30/W33","v":"0"},{"$f":"X30/X33","v":"0"},{"$f":"Y30/Y33","v":"0"},{"$f":"Z30/Z33","v":"125.6298"},{"$f":"AA30/AA33","v":"107.4"},{"$f":"AB30/AB33","v":"397.8756"},{"$f":"AC30/AC33","v":"0"},{"$f":"AD30/AD33","v":"140.43"},{"$f":"AE30/AE33","v":"0"},{"$f":"AF30/AF33","v":"221.0056"},{"$f":"AG30/AG33","v":"205.7571"},{"$f":"AH30/AH33","v":"0"},{"$f":"AI30/AI33","v":"243.5987"},{"$f":"AJ30/AJ33","v":"3267.5556"},{"$f":"AK30/AK33","v":"295.2593"},{"$f":"AL30/AL33","v":"0"},{"$f":"AM30/AM33","v":"465.0673"},{"$f":"AN30/AN33","v":"0"},{"$f":"AO30/AO33","v":"43.4883"},{"$f":"AP30/AP33","v":"102.2648"},{"$f":"AQ30/AQ33","v":"127.384"},{"$f":"AR30/AR33","v":"6721.6837"},{"$f":"AS30/AS33","v":"177.8444"},{"$f":"AT30/AT33","v":"44.9013"},{"$f":"AU30/AU33","v":"0"},{"$f":"AV30/AV33","v":"447.675"},{"$f":"AW30/AW33","v":"181.3083"},{"$f":"AX30/AX33","v":"0"},{"$f":"AY30/AY33","v":"880.611"},{"$f":"AZ30/AZ33","v":"0"},{"$f":"BA30/BA33","v":"23.612"},{"$f":"BB30/BB33","v":"0"},{"$f":"BC30/BC33","v":"0"},{"$f":"BD30/BD33","v":"434.8632"},{"$f":"BE30/BE33","v":"1008.3783"},{"$f":"BF30/BF33","v":"0"},{"$f":"BG30/BG33","v":"23.868"},{"$f":"BH30/BH33","v":"436.49"},{"$f":"BI30/BI33","v":"295.4079"},{"$f":"BJ30/BJ33","v":"152.111"},{"$f":"BK30/BK33","v":"0"},{"$f":"BL30/BL33","v":"0"}]
[null,"2.18","Risk Adjustment Transfer Amount",{"$f":"D31/D33","v":"-$36.73"},{"$f":"E31/E33","v":"0"},{"$f":"F31/F33","v":"-38.7335"},{"$f":"G31/G33","v":"-40.1664"},{"$f":"H31/H33","v":"-31.6263"},{"$f":"I31/I33","v":"-35.0311"},{"$f":"J31/J33","v":"-36.7905"},{"$f":"K31/K33","v":"-38.2086"},{"$f":"L31/L33","v":"-26.2458"},{"$f":"M31/M33","v":"-26.9376"},{"$f":"N31/N33","v":"-33.4196"},{"$f":"O31/O33","v":"-36.5167"},{"$f":"P31/P33","v":"-45.0068"},{"$f":"Q31/Q33","v":"-44.639"},{"$f":"R31/R33","v":"-31.8952"},{"$f":"S31/S33","v":"-39.0851"},{"$f":"T31/T33","v":"-35.196"},{"$f":"U31/U33","v":"-34.2584"},{"$f":"V31/V33","v":"-39.172"},{"$f":"W31/W33","v":"0"},{"$f":"X31/X33","v":"0"},{"$f":"Y31/Y33","v":"0"},{"$f":"Z31/Z33","v":"-32.6295"},{"$f":"AA31/AA33","v":"-32.045"},{"$f":"AB31/AB33","v":"-39.17"},{"$f":"AC31/AC33","v":"0"},{"$f":"AD31/AD33","v":"-26.7"},{"$f":"AE31/AE33","v":"0"},{"$f":"AF31/AF33","v":"-48.6367"},{"$f":"AG31/AG33","v":"-31.2296"},{"$f":"AH31/AH33","v":"0"},{"$f":"AI31/AI33","v":"-27.6229"},{"$f":"AJ31/AJ33","v":"-42.2225"},{"$f":"AK31/AK33","v":"-30.9724"},{"$f":"AL31/AL33","v":"0"},{"$f":"AM31/AM33","v":"-40.4282"},{"$f":"AN31/AN33","v":"0"},{"$f":"AO31/AO33","v":"-23.4769"},{"$f":"AP31/AP33","v":"-31.9583"},{"$f":"AQ31/AQ33","v":"-31.8948"},{"$f":"AR31/AR33","v":"-36.8756"},{"$f":"AS31/AS33","v":"-30.8269"},{"$f":"AT31/AT33","v":"-21.6478"},{"$f":"AU31/AU33","v":"0"},{"$f":"AV31/AV33","v":"-25.622"},{"$f":"AW31/AW33","v":"-26.0867"},{"$f":"AX31/AX33","v":"0"},{"$f":"AY31/AY33","v":"-47.8161"},{"$f":"AZ31/AZ33","v":"0"},{"$f":"BA31/BA33","v":"-30.263"},{"$f":"BB31/BB33","v":"0"},{"$f":"BC31/BC33","v":"0"},{"$f":"BD31/BD33","v":"-29.8478"},{"$f":"BE31/BE33","v":"-45.5783"},{"$f":"BF31/BF33","v":"0"},{"$f":"BG31/BG33","v":"-18.668"},{"$f":"BH31/BH33","v":"-46.825"},{"$f":"BI31/BI33","v":"-30.7863"},{"$f":"BJ31/BJ33","v":"-28.5899"},{"$f":"BK31/BK33","v":"0"},{"$f":"BL31/BL33","v":"0"}]
[null,"2.19","Premium",{"$f":"D32/D33","v":"$845.52"},{"$f":"E32/E33","v":"0"},{"$f":"F32/F33","v":"891.5227"},{"$f":"G32/G33","v":"924.5036"},{"$f":"H32/H33","v":"727.9365"},{"$f":"I32/I33","v":"806.3042"},{"$f":"J32/J33","v":"846.8004"},{"$f":"K32/K33","v":"879.4396"},{"$f":"L32/L33","v":"604.0954"},{"$f":"M32/M33","v":"620.0179"},{"$f":"N32/N33","v":"769.2128"},{"$f":"O32/O33","v":"840.4992"},{"$f":"P32/P33","v":"1035.9142"},{"$f":"Q32/Q33","v":"1027.4472"},{"$f":"R32/R33","v":"734.1254"},{"$f":"S32/S33","v":"899.6134"},{"$f":"T32/T33","v":"810.0995"},{"$f":"U32/U33","v":"788.5199"},{"$f":"V32/V33","v":"901.6145"},{"$f":"W32/W33","v":"0"},{"$f":"X32/X33","v":"0"},{"$f":"Y32/Y33","v":"0"},{"$f":"Z32/Z33","v":"751.0266"},{"$f":"AA32/AA33","v":"737.545"},{"$f":"AB32/AB33","v":"901.5698"},{"$f":"AC32/AC33","v":"0"},{"$f":"AD32/AD33","v":"614.54"},{"$f":"AE32/AE33","v":"0"},{"$f":"AF32/AF33","v":"1119.46"},{"$f":"AG32/AG33","v":"718.8082"},{"$f":"AH32/AH33","v":"0"},{"$f":"AI32/AI33","v":"635.7916"},{"$f":"AJ32/AJ33","v":"971.8265"},{"$f":"AK32/AK33","v":"712.8858"},{"$f":"AL32/AL33","v":"0"},{"$f":"AM32/AM33","v":"930.5266"},{"$f":"AN32/AN33","v":"0"},{"$f":"AO32/AO33","v":"540.3643"},{"$f":"AP32/AP33","v":"735.5787"},{"$f":"AQ32/AQ33","v":"734.1169"},{"$f":"AR32/AR33","v":"848.7567"},{"$f":"AS32/AS33","v":"709.5374"},{"$f":"AT32/AT33","v":"498.2655"},{"$f":"AU32/AU33","v":"0"},{"$f":"AV32/AV33","v":"589.744"},{"$f":"AW32/AW33","v":"600.4217"},{"$f":"AX32/AX33","v":"0"},{"$f":"AY32/AY33","v":"1100.5763"},{"$f":"AZ32/AZ33","v":"0"},{"$f":"BA32/BA33","v":"696.558"},{"$f":"BB32/BB33","v":"0"},{"$f":"BC32/BC33","v":"0"},{"$f":"BD32/BD33","v":"687.0012"},{"$f":"BE32/BE33","v":"1049.0744"},{"$f":"BF32/BF33","v":"0"},{"$f":"BG32/BG33","v":"429.656"},{"$f":"BH32/BH33","v":"1077.78"},{"$f":"BI32/BI33","v":"708.6035"},{"$f":"BJ32/BJ33","v":"658.0486"},{"$f":"BK32/BK33","v":"0"},{"$f":"BL32/BL33","v":"0"}]
[]
[null,null,"Section III: Plan Adjustment Factors"]
[null,"3.1","Plan ID (Standard Component ID)",null,{"$f":"IF(E13<>\"\",E13,\"\")","v":"23671KY0020058"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"23671KY0070003"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"23671KY0070012"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"23671KY0070037"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"23671KY0070046"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"23671KY0070047"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"23671KY0070048"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"23671KY0070049"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"23671KY0070050"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"23671KY0070051"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"23671KY0070052"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"23671KY0070053"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"23671KY0070054"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"23671KY0070055"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"23671KY0070056"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"23671KY0070057"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"23671KY0070058"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"23671KY0070059"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"23671KY0070061"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"23671KY0070006"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"23671KY0070028"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"23671KY0070060"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"23671KY0080034"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"23671KY0080035"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"23671KY0080036"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"23671KY0080037"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"23671KY0080042"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"23671KY0080043"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"23671KY0080044"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"23671KY0080045"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"23671KY0080046"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"23671KY0080047"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"23671KY0080048"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"23671KY0080049"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"23671KY0080050"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"23671KY0080067"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"23671KY0080009"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"23671KY0080010"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"23671KY0080025"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"23671KY0080038"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"23671KY0080039"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"23671KY0080040"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"23671KY0080041"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"23671KY0080051"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"23671KY0080052"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"23671KY0080053"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"23671KY0080054"},{"$f":"IF(AZ13<>\"\",AZ13,\"\")","v":"23671KY0080055"},{"$f":"IF(BA13<>\"\",BA13,\"\")","v":"23671KY0080056"},{"$f":"IF(BB13<>\"\",BB13,\"\")","v":"23671KY0080057"},{"$f":"IF(BC13<>\"\",BC13,\"\")","v":"23671KY0080058"},{"$f":"IF(BD13<>\"\",BD13,\"\")","v":"23671KY0080059"},{"$f":"IF(BE13<>\"\",BE13,\"\")","v":"23671KY0080060"},{"$f":"IF(BF13<>\"\",BF13,\"\")","v":"23671KY0080061"},{"$f":"IF(BG13<>\"\",BG13,\"\")","v":"23671KY0080062"},{"$f":"IF(BH13<>\"\",BH13,\"\")","v":"23671KY0080063"},{"$f":"IF(BI13<>\"\",BI13,\"\")","v":"23671KY0080064"},{"$f":"IF(BJ13<>\"\",BJ13,\"\")","v":"23671KY0080065"},{"$f":"IF(BK13<>\"\",BK13,\"\")","v":"23671KY0080066"},{"$f":"IF(BL13<>\"\",BL13,\"\")","v":"23671KY0080068"}]
[null,"3.2","Market Adjusted Index Rate",null,"$1,068.77"]
[null,"3.3","AV and Cost Sharing Design of Plan",null,0.0,0.8851,0.8022,0.8655,0.8699,0.8627,0.8612,0.7773,0.7054,0.8755,0.8608,1.0366,0.9919,0.8745,0.8491,0.8772,0.847,0.8362,0.8925,0.0,0.0,0.0,0.8744,0.8592,0.8521,0.8505,0.8506,1.0262,0.9815,0.8641,0.8386,0.8673,0.8556,0.8372,0.8263,0.8821,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,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,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,1.0,1.0,1.0]
[null,null,"Administrative Costs"]
[null,"3.6","Administrative Expense",null,0.0,0.0714,0.0773,0.0727,0.0724,0.0729,0.0731,0.0793,0.0855,0.072,0.0729,0.0626,0.0649,0.072,0.0738,0.0719,0.0739,0.0747,0.0708,0.0,0.0,0.0,0.072,0.0731,0.0736,0.0738,0.0738,0.0632,0.0655,0.0728,0.0746,0.0726,0.0734,0.0747,0.0755,0.0716,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,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.0,0.0373,0.0404,0.038,0.0378,0.0381,0.0381,0.0414,0.0447,0.0376,0.0382,0.0327,0.034,0.0377,0.0386,0.0376,0.0387,0.0391,0.0371,0.0,0.0,0.0,0.0377,0.0382,0.0385,0.0385,0.0385,0.033,0.0343,0.038,0.039,0.0379,0.0383,0.039,0.0394,0.0374,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,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.0,0.0763,0.0826,0.0777,0.0774,0.0779,0.078,0.0847,0.0915,0.077,0.0781,0.067,0.0695,0.0771,0.0789,0.0769,0.0791,0.0799,0.0758,0.0,0.0,0.0,0.0771,0.0782,0.0787,0.0788,0.0788,0.0675,0.0701,0.0778,0.0797,0.0776,0.0785,0.0798,0.0807,0.0765,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,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,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":"$0.00"},{"$f":"($E$48*PRODUCT(F49:F51)*F56)/(1-SUM(F53:F55))","v":"$1,160.70"},{"$f":"($E$48*PRODUCT(G49:G51)*G56)/(1-SUM(G53:G55))","v":"$1,072.11"},{"$f":"($E$48*PRODUCT(H49:H51)*H56)/(1-SUM(H53:H55))","v":"$1,139.75"},{"$f":"($E$48*PRODUCT(I49:I51)*I56)/(1-SUM(I53:I55))","v":"$1,144.42"},{"$f":"($E$48*PRODUCT(J49:J51)*J56)/(1-SUM(J53:J55))","v":"$1,136.76"},{"$f":"($E$48*PRODUCT(K49:K51)*K56)/(1-SUM(K53:K55))","v":"$1,135.21"},{"$f":"($E$48*PRODUCT(L49:L51)*L56)/(1-SUM(L53:L55))","v":"$1,045.50"},{"$f":"($E$48*PRODUCT(M49:M51)*M56)/(1-SUM(M53:M55))","v":"$968.66"},{"$f":"($E$48*PRODUCT(N49:N51)*N56)/(1-SUM(N53:N55))","v":"$1,150.37"},{"$f":"($E$48*PRODUCT(O49:O51)*O56)/(1-SUM(O53:O55))","v":"$1,134.68"},{"$f":"($E$48*PRODUCT(P49:P51)*P56)/(1-SUM(P53:P55))","v":"$1,322.53"},{"$f":"($E$48*PRODUCT(Q49:Q51)*Q56)/(1-SUM(Q53:Q55))","v":"$1,274.79"},{"$f":"($E$48*PRODUCT(R49:R51)*R56)/(1-SUM(R53:R55))","v":"$1,149.34"},{"$f":"($E$48*PRODUCT(S49:S51)*S56)/(1-SUM(S53:S55))","v":"$1,122.16"},{"$f":"($E$48*PRODUCT(T49:T51)*T56)/(1-SUM(T53:T55))","v":"$1,152.32"},{"$f":"($E$48*PRODUCT(U49:U51)*U56)/(1-SUM(U53:U55))","v":"$1,119.94"},{"$f":"($E$48*PRODUCT(V49:V51)*V56)/(1-SUM(V53:V55))","v":"$1,108.40"},{"$f":"($E$48*PRODUCT(W49:W51)*W56)/(1-SUM(W53:W55))","v":"$1,168.54"},{"$f":"($E$48*PRODUCT(X49:X51)*X56)/(1-SUM(X53:X55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(Y49:Y51)*Y56)/(1-SUM(Y53:Y55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(Z49:Z51)*Z56)/(1-SUM(Z53:Z55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(AA49:AA51)*AA56)/(1-SUM(AA53:AA55))","v":"$1,149.20"},{"$f":"($E$48*PRODUCT(AB49:AB51)*AB56)/(1-SUM(AB53:AB55))","v":"$1,132.99"},{"$f":"($E$48*PRODUCT(AC49:AC51)*AC56)/(1-SUM(AC53:AC55))","v":"$1,125.43"},{"$f":"($E$48*PRODUCT(AD49:AD51)*AD56)/(1-SUM(AD53:AD55))","v":"$1,123.73"},{"$f":"($E$48*PRODUCT(AE49:AE51)*AE56)/(1-SUM(AE53:AE55))","v":"$1,123.87"},{"$f":"($E$48*PRODUCT(AF49:AF51)*AF56)/(1-SUM(AF53:AF55))","v":"$1,311.46"},{"$f":"($E$48*PRODUCT(AG49:AG51)*AG56)/(1-SUM(AG53:AG55))","v":"$1,263.70"},{"$f":"($E$48*PRODUCT(AH49:AH51)*AH56)/(1-SUM(AH53:AH55))","v":"$1,138.19"},{"$f":"($E$48*PRODUCT(AI49:AI51)*AI56)/(1-SUM(AI53:AI55))","v":"$1,111.03"},{"$f":"($E$48*PRODUCT(AJ49:AJ51)*AJ56)/(1-SUM(AJ53:AJ55))","v":"$1,141.70"},{"$f":"($E$48*PRODUCT(AK49:AK51)*AK56)/(1-SUM(AK53:AK55))","v":"$1,129.22"},{"$f":"($E$48*PRODUCT(AL49:AL51)*AL56)/(1-SUM(AL53:AL55))","v":"$1,109.45"},{"$f":"($E$48*PRODUCT(AM49:AM51)*AM56)/(1-SUM(AM53:AM55))","v":"$1,097.87"},{"$f":"($E$48*PRODUCT(AN49:AN51)*AN56)/(1-SUM(AN53:AN55))","v":"$1,157.47"},{"$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"},{"$f":"($E$48*PRODUCT(BJ49:BJ51)*BJ56)/(1-SUM(BJ53:BJ55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BK49:BK51)*BK56)/(1-SUM(BK53:BK55))","v":"$0.00"},{"$f":"($E$48*PRODUCT(BL49:BL51)*BL56)/(1-SUM(BL53:BL55))","v":"$0.00"}]
[]
[null,"3.11","Age Calibration Factor","0.6952",{"$f":"IF(D59<>\"\", D59, \"\")","v":"0.6952"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","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.4077",{"$f":"IF(D60<>\"\", D60, \"\")","v":"1.4077"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000"]
[null,"3.13","Tobacco Calibration Factor","1.0000",{"$f":"IF(D61<>\"\", D61, \"\")","v":"1.0000"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000"]
[null,"3.14","Calibrated Plan Adjusted Index Rate",null,{"$f":"E57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"F57*(PRODUCT($E$59:$E$61))","v":"$1,135.90"},{"$f":"G57*(PRODUCT($E$59:$E$61))","v":"$1,049.20"},{"$f":"H57*(PRODUCT($E$59:$E$61))","v":"$1,115.40"},{"$f":"I57*(PRODUCT($E$59:$E$61))","v":"$1,119.96"},{"$f":"J57*(PRODUCT($E$59:$E$61))","v":"$1,112.47"},{"$f":"K57*(PRODUCT($E$59:$E$61))","v":"$1,110.95"},{"$f":"L57*(PRODUCT($E$59:$E$61))","v":"$1,023.16"},{"$f":"M57*(PRODUCT($E$59:$E$61))","v":"$947.97"},{"$f":"N57*(PRODUCT($E$59:$E$61))","v":"$1,125.79"},{"$f":"O57*(PRODUCT($E$59:$E$61))","v":"$1,110.43"},{"$f":"P57*(PRODUCT($E$59:$E$61))","v":"$1,294.28"},{"$f":"Q57*(PRODUCT($E$59:$E$61))","v":"$1,247.55"},{"$f":"R57*(PRODUCT($E$59:$E$61))","v":"$1,124.78"},{"$f":"S57*(PRODUCT($E$59:$E$61))","v":"$1,098.18"},{"$f":"T57*(PRODUCT($E$59:$E$61))","v":"$1,127.70"},{"$f":"U57*(PRODUCT($E$59:$E$61))","v":"$1,096.01"},{"$f":"V57*(PRODUCT($E$59:$E$61))","v":"$1,084.72"},{"$f":"W57*(PRODUCT($E$59:$E$61))","v":"$1,143.57"},{"$f":"X57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"Y57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"Z57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"AA57*(PRODUCT($E$59:$E$61))","v":"$1,124.65"},{"$f":"AB57*(PRODUCT($E$59:$E$61))","v":"$1,108.78"},{"$f":"AC57*(PRODUCT($E$59:$E$61))","v":"$1,101.38"},{"$f":"AD57*(PRODUCT($E$59:$E$61))","v":"$1,099.72"},{"$f":"AE57*(PRODUCT($E$59:$E$61))","v":"$1,099.85"},{"$f":"AF57*(PRODUCT($E$59:$E$61))","v":"$1,283.44"},{"$f":"AG57*(PRODUCT($E$59:$E$61))","v":"$1,236.70"},{"$f":"AH57*(PRODUCT($E$59:$E$61))","v":"$1,113.87"},{"$f":"AI57*(PRODUCT($E$59:$E$61))","v":"$1,087.29"},{"$f":"AJ57*(PRODUCT($E$59:$E$61))","v":"$1,117.30"},{"$f":"AK57*(PRODUCT($E$59:$E$61))","v":"$1,105.09"},{"$f":"AL57*(PRODUCT($E$59:$E$61))","v":"$1,085.75"},{"$f":"AM57*(PRODUCT($E$59:$E$61))","v":"$1,074.41"},{"$f":"AN57*(PRODUCT($E$59:$E$61))","v":"$1,132.74"},{"$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"},{"$f":"BJ57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BK57*(PRODUCT($E$59:$E$61))","v":"$0.00"},{"$f":"BL57*(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":"23671KY0020058"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"23671KY0070003"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"23671KY0070012"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"23671KY0070037"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"23671KY0070046"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"23671KY0070047"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"23671KY0070048"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"23671KY0070049"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"23671KY0070050"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"23671KY0070051"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"23671KY0070052"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"23671KY0070053"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"23671KY0070054"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"23671KY0070055"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"23671KY0070056"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"23671KY0070057"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"23671KY0070058"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"23671KY0070059"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"23671KY0070061"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"23671KY0070006"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"23671KY0070028"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"23671KY0070060"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"23671KY0080034"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"23671KY0080035"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"23671KY0080036"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"23671KY0080037"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"23671KY0080042"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"23671KY0080043"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"23671KY0080044"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"23671KY0080045"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"23671KY0080046"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"23671KY0080047"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"23671KY0080048"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"23671KY0080049"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"23671KY0080050"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"23671KY0080067"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"23671KY0080009"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"23671KY0080010"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"23671KY0080025"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"23671KY0080038"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"23671KY0080039"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"23671KY0080040"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"23671KY0080041"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"23671KY0080051"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"23671KY0080052"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"23671KY0080053"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"23671KY0080054"},{"$f":"IF(AZ13<>\"\",AZ13,\"\")","v":"23671KY0080055"},{"$f":"IF(BA13<>\"\",BA13,\"\")","v":"23671KY0080056"},{"$f":"IF(BB13<>\"\",BB13,\"\")","v":"23671KY0080057"},{"$f":"IF(BC13<>\"\",BC13,\"\")","v":"23671KY0080058"},{"$f":"IF(BD13<>\"\",BD13,\"\")","v":"23671KY0080059"},{"$f":"IF(BE13<>\"\",BE13,\"\")","v":"23671KY0080060"},{"$f":"IF(BF13<>\"\",BF13,\"\")","v":"23671KY0080061"},{"$f":"IF(BG13<>\"\",BG13,\"\")","v":"23671KY0080062"},{"$f":"IF(BH13<>\"\",BH13,\"\")","v":"23671KY0080063"},{"$f":"IF(BI13<>\"\",BI13,\"\")","v":"23671KY0080064"},{"$f":"IF(BJ13<>\"\",BJ13,\"\")","v":"23671KY0080065"},{"$f":"IF(BK13<>\"\",BK13,\"\")","v":"23671KY0080066"},{"$f":"IF(BL13<>\"\",BL13,\"\")","v":"23671KY0080068"}]
[null,"4.2","Allowed Claims",{"$f":"SUM(E66:BL66)","v":"$9,279,773"},0.0,2161084.6,480043.47,189409.75,189409.75,189409.75,415089.44,480043.47,151124.8,189409.75,189409.75,277358.45,373367.15,189409.75,189409.75,189409.75,189409.75,189409.75,189409.75,0.0,0.0,0.0,189409.75,189409.75,189409.75,189409.75,189409.75,216552.94,216552.94,189409.75,189409.75,189409.75,341542.04,189409.75,189409.75,189409.75,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,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:BL67)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.4","Member Cost Sharing",{"$f":"SUM(E68:BL68)","v":"$1,187,811"},0.0,240514.35,85658.49,24808.49,23968.98,25331.36,56138.1,97882.54,41943.96,22892.26,25689.65,4695.23,22150.09,23083.21,27925.77,22582.35,28315.58,30370.95,19659.45,0.0,0.0,0.0,23106.25,25995.14,27358.99,27647.1,27634.65,5812.32,14996.61,25068.31,29913.93,24459.5,48119.29,30192.69,32250.96,21644.55,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,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:BL69)","v":"$0"},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,"4.6","Incurred Claims",{"$f":"D66-D67-D68-D69","v":"$8,091,962"},{"$f":"E66-E67-E68-E69","v":"0"},{"$f":"F66-F67-F68-F69","v":"1920570.25"},{"$f":"G66-G67-G68-G69","v":"394384.98"},{"$f":"H66-H67-H68-H69","v":"164601.26"},{"$f":"I66-I67-I68-I69","v":"165440.77"},{"$f":"J66-J67-J68-J69","v":"164078.39"},{"$f":"K66-K67-K68-K69","v":"358951.34"},{"$f":"L66-L67-L68-L69","v":"382160.93"},{"$f":"M66-M67-M68-M69","v":"109180.84"},{"$f":"N66-N67-N68-N69","v":"166517.49"},{"$f":"O66-O67-O68-O69","v":"163720.1"},{"$f":"P66-P67-P68-P69","v":"272663.22"},{"$f":"Q66-Q67-Q68-Q69","v":"351217.06"},{"$f":"R66-R67-R68-R69","v":"166326.54"},{"$f":"S66-S67-S68-S69","v":"161483.98"},{"$f":"T66-T67-T68-T69","v":"166827.4"},{"$f":"U66-U67-U68-U69","v":"161094.17"},{"$f":"V66-V67-V68-V69","v":"159038.8"},{"$f":"W66-W67-W68-W69","v":"169750.3"},{"$f":"X66-X67-X68-X69","v":"0"},{"$f":"Y66-Y67-Y68-Y69","v":"0"},{"$f":"Z66-Z67-Z68-Z69","v":"0"},{"$f":"AA66-AA67-AA68-AA69","v":"166303.5"},{"$f":"AB66-AB67-AB68-AB69","v":"163414.61"},{"$f":"AC66-AC67-AC68-AC69","v":"162050.76"},{"$f":"AD66-AD67-AD68-AD69","v":"161762.65"},{"$f":"AE66-AE67-AE68-AE69","v":"161775.1"},{"$f":"AF66-AF67-AF68-AF69","v":"210740.62"},{"$f":"AG66-AG67-AG68-AG69","v":"201556.33"},{"$f":"AH66-AH67-AH68-AH69","v":"164341.44"},{"$f":"AI66-AI67-AI68-AI69","v":"159495.82"},{"$f":"AJ66-AJ67-AJ68-AJ69","v":"164950.25"},{"$f":"AK66-AK67-AK68-AK69","v":"293422.75"},{"$f":"AL66-AL67-AL68-AL69","v":"159217.06"},{"$f":"AM66-AM67-AM68-AM69","v":"157158.79"},{"$f":"AN66-AN67-AN68-AN69","v":"167765.2"},{"$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"},{"$f":"BJ66-BJ67-BJ68-BJ69","v":"0"},{"$f":"BK66-BK67-BK68-BK69","v":"0"},{"$f":"BL66-BL67-BL68-BL69","v":"0"}]
[null,"4.7","Risk Adjustment Transfer Amount",{"$f":"SUM(E71:BL71)","v":"-$456,998"},0.0,-106863.9,-24212.52,-9366.16,-9366.16,-9366.16,-20525.84,-24212.52,-7622.46,-9366.16,-9366.16,-12953.2,-17437.0,-9366.16,-9366.16,-9366.16,-9366.16,-9366.16,-9366.16,0.0,0.0,0.0,-9366.16,-9366.16,-9366.16,-9366.16,-9366.16,-10113.46,-10113.46,-9366.16,-9366.16,-9366.16,-16888.98,-9366.16,-9366.16,-9366.16,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,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:BL72)","v":"$10,518,630"},0.0,2489695.78,521046.02,214272.85,215150.08,213711.31,467704.72,508113.38,148205.43,216268.91,213319.53,343858.92,446175.49,216075.01,210966.5,216635.58,210548.88,208379.8,219685.06,0.0,0.0,0.0,216050.3,213001.84,211581.06,211262.1,211286.94,266225.84,256531.19,213978.98,208874.25,214639.13,382804.43,208577.26,206399.1,217604.98,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,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:BL73)","v":"9173"},0.0,2145.0,486.0,188.0,188.0,188.0,412.0,486.0,153.0,188.0,188.0,260.0,350.0,188.0,188.0,188.0,188.0,188.0,188.0,0.0,0.0,0.0,188.0,188.0,188.0,188.0,188.0,203.0,203.0,188.0,188.0,188.0,339.0,188.0,188.0,188.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,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":"80.42%"},{"$f":"E70/(E71+E72)","v":"0"},{"$f":"F70/(F71+F72)","v":"0.8060032544134"},{"$f":"G70/(G71+G72)","v":"0.793797076887931"},{"$f":"H70/(H71+H72)","v":"0.8032986136275"},{"$f":"I70/(I71+I72)","v":"0.80395382690737"},{"$f":"J70/(J71+J72)","v":"0.802947317320719"},{"$f":"K70/(K71+K72)","v":"0.802701907567728"},{"$f":"L70/(L71+L72)","v":"0.789750466655505"},{"$f":"M70/(M71+M72)","v":"0.776629203380751"},{"$f":"N70/(N71+N72)","v":"0.804810424221041"},{"$f":"O70/(O71+O72)","v":"0.802732997253245"},{"$f":"P70/(P71+P72)","v":"0.823990652080599"},{"$f":"Q70/(Q71+Q72)","v":"0.819187145991954"},{"$f":"R70/(R71+R72)","v":"0.804641600976446"},{"$f":"S70/(S71+S72)","v":"0.801010454645067"},{"$f":"T70/(T71+T72)","v":"0.804881877895929"},{"$f":"U70/(U71+U72)","v":"0.800735619838523"},{"$f":"V70/(V71+V72)","v":"0.799135174855352"},{"$f":"W70/(W71+W72)","v":"0.807109109071985"},{"$f":"X70/(X71+X72)","v":"0"},{"$f":"Y70/(Y71+Y72)","v":"0"},{"$f":"Z70/(Z71+Z72)","v":"0"},{"$f":"AA70/(AA71+AA72)","v":"0.804626324980717"},{"$f":"AB70/(AB71+AB72)","v":"0.802485153878731"},{"$f":"AC70/(AC71+AC72)","v":"0.801378929050233"},{"$f":"AD70/(AD71+AD72)","v":"0.801217944253857"},{"$f":"AE70/(AE71+AE72)","v":"0.801181037434582"},{"$f":"AF70/(AF71+AF72)","v":"0.822844331070603"},{"$f":"AG70/(AG71+AG72)","v":"0.817945729797933"},{"$f":"AH70/(AH71+AH72)","v":"0.803182518084644"},{"$f":"AI70/(AI71+AI72)","v":"0.799445375874231"},{"$f":"AJ70/(AJ71+AJ72)","v":"0.803565369566193"},{"$f":"AK70/(AK71+AK72)","v":"0.801886747334664"},{"$f":"AL70/(AL71+AL72)","v":"0.79923789387238"},{"$f":"AM70/(AM71+AM72)","v":"0.797626985619765"},{"$f":"AN70/(AN71+AN72)","v":"0.8056384491614"},{"$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"},{"$f":"BJ70/(BJ71+BJ72)","v":"0"},{"$f":"BK70/(BK71+BK72)","v":"0"},{"$f":"BL70/(BL71+BL72)","v":"0"}]
[null,null,"Per Member Per Month"]
[null,"4.11","Allowed Claims",{"$f":"D66/D73","v":"$1,011.64"},{"$f":"E66/E73","v":"0"},{"$f":"F66/F73","v":"1007.4986"},{"$f":"G66/G73","v":"987.7438"},{"$f":"H66/H73","v":"1007.4987"},{"$f":"I66/I73","v":"1007.4987"},{"$f":"J66/J73","v":"1007.4987"},{"$f":"K66/K73","v":"1007.4986"},{"$f":"L66/L73","v":"987.7438"},{"$f":"M66/M73","v":"987.7438"},{"$f":"N66/N73","v":"1007.4987"},{"$f":"O66/O73","v":"1007.4987"},{"$f":"P66/P73","v":"1066.7633"},{"$f":"Q66/Q73","v":"1066.7633"},{"$f":"R66/R73","v":"1007.4987"},{"$f":"S66/S73","v":"1007.4987"},{"$f":"T66/T73","v":"1007.4987"},{"$f":"U66/U73","v":"1007.4987"},{"$f":"V66/V73","v":"1007.4987"},{"$f":"W66/W73","v":"1007.4987"},{"$f":"X66/X73","v":"0"},{"$f":"Y66/Y73","v":"0"},{"$f":"Z66/Z73","v":"0"},{"$f":"AA66/AA73","v":"1007.4987"},{"$f":"AB66/AB73","v":"1007.4987"},{"$f":"AC66/AC73","v":"1007.4987"},{"$f":"AD66/AD73","v":"1007.4987"},{"$f":"AE66/AE73","v":"1007.4987"},{"$f":"AF66/AF73","v":"1066.7633"},{"$f":"AG66/AG73","v":"1066.7633"},{"$f":"AH66/AH73","v":"1007.4987"},{"$f":"AI66/AI73","v":"1007.4987"},{"$f":"AJ66/AJ73","v":"1007.4987"},{"$f":"AK66/AK73","v":"1007.4986"},{"$f":"AL66/AL73","v":"1007.4987"},{"$f":"AM66/AM73","v":"1007.4987"},{"$f":"AN66/AN73","v":"1007.4987"},{"$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"},{"$f":"BJ66/BJ73","v":"0"},{"$f":"BK66/BK73","v":"0"},{"$f":"BL66/BL73","v":"0"}]
[null,"4.12","Reinsurance",{"$f":"D67/D73","v":"$0.00"},{"$f":"E67/E73","v":"0"},{"$f":"F67/F73","v":"0"},{"$f":"G67/G73","v":"0"},{"$f":"H67/H73","v":"0"},{"$f":"I67/I73","v":"0"},{"$f":"J67/J73","v":"0"},{"$f":"K67/K73","v":"0"},{"$f":"L67/L73","v":"0"},{"$f":"M67/M73","v":"0"},{"$f":"N67/N73","v":"0"},{"$f":"O67/O73","v":"0"},{"$f":"P67/P73","v":"0"},{"$f":"Q67/Q73","v":"0"},{"$f":"R67/R73","v":"0"},{"$f":"S67/S73","v":"0"},{"$f":"T67/T73","v":"0"},{"$f":"U67/U73","v":"0"},{"$f":"V67/V73","v":"0"},{"$f":"W67/W73","v":"0"},{"$f":"X67/X73","v":"0"},{"$f":"Y67/Y73","v":"0"},{"$f":"Z67/Z73","v":"0"},{"$f":"AA67/AA73","v":"0"},{"$f":"AB67/AB73","v":"0"},{"$f":"AC67/AC73","v":"0"},{"$f":"AD67/AD73","v":"0"},{"$f":"AE67/AE73","v":"0"},{"$f":"AF67/AF73","v":"0"},{"$f":"AG67/AG73","v":"0"},{"$f":"AH67/AH73","v":"0"},{"$f":"AI67/AI73","v":"0"},{"$f":"AJ67/AJ73","v":"0"},{"$f":"AK67/AK73","v":"0"},{"$f":"AL67/AL73","v":"0"},{"$f":"AM67/AM73","v":"0"},{"$f":"AN67/AN73","v":"0"},{"$f":"AO67/AO73","v":"0"},{"$f":"AP67/AP73","v":"0"},{"$f":"AQ67/AQ73","v":"0"},{"$f":"AR67/AR73","v":"0"},{"$f":"AS67/AS73","v":"0"},{"$f":"AT67/AT73","v":"0"},{"$f":"AU67/AU73","v":"0"},{"$f":"AV67/AV73","v":"0"},{"$f":"AW67/AW73","v":"0"},{"$f":"AX67/AX73","v":"0"},{"$f":"AY67/AY73","v":"0"},{"$f":"AZ67/AZ73","v":"0"},{"$f":"BA67/BA73","v":"0"},{"$f":"BB67/BB73","v":"0"},{"$f":"BC67/BC73","v":"0"},{"$f":"BD67/BD73","v":"0"},{"$f":"BE67/BE73","v":"0"},{"$f":"BF67/BF73","v":"0"},{"$f":"BG67/BG73","v":"0"},{"$f":"BH67/BH73","v":"0"},{"$f":"BI67/BI73","v":"0"},{"$f":"BJ67/BJ73","v":"0"},{"$f":"BK67/BK73","v":"0"},{"$f":"BL67/BL73","v":"0"}]
[null,"4.13","Member Cost Sharing",{"$f":"D68/D73","v":"$129.49"},{"$f":"E68/E73","v":"0"},{"$f":"F68/F73","v":"112.1279"},{"$f":"G68/G73","v":"176.252"},{"$f":"H68/H73","v":"131.9601"},{"$f":"I68/I73","v":"127.4946"},{"$f":"J68/J73","v":"134.7413"},{"$f":"K68/K73","v":"136.2575"},{"$f":"L68/L73","v":"201.4044"},{"$f":"M68/M73","v":"274.1435"},{"$f":"N68/N73","v":"121.7673"},{"$f":"O68/O73","v":"136.6471"},{"$f":"P68/P73","v":"18.0586"},{"$f":"Q68/Q73","v":"63.286"},{"$f":"R68/R73","v":"122.783"},{"$f":"S68/S73","v":"148.5413"},{"$f":"T68/T73","v":"120.1189"},{"$f":"U68/U73","v":"150.6148"},{"$f":"V68/V73","v":"161.5476"},{"$f":"W68/W73","v":"104.5715"},{"$f":"X68/X73","v":"0"},{"$f":"Y68/Y73","v":"0"},{"$f":"Z68/Z73","v":"0"},{"$f":"AA68/AA73","v":"122.9056"},{"$f":"AB68/AB73","v":"138.272"},{"$f":"AC68/AC73","v":"145.5265"},{"$f":"AD68/AD73","v":"147.059"},{"$f":"AE68/AE73","v":"146.9928"},{"$f":"AF68/AF73","v":"28.6321"},{"$f":"AG68/AG73","v":"73.8749"},{"$f":"AH68/AH73","v":"133.3421"},{"$f":"AI68/AI73","v":"159.1166"},{"$f":"AJ68/AJ73","v":"130.1037"},{"$f":"AK68/AK73","v":"141.9448"},{"$f":"AL68/AL73","v":"160.5994"},{"$f":"AM68/AM73","v":"171.5477"},{"$f":"AN68/AN73","v":"115.1306"},{"$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"},{"$f":"BJ68/BJ73","v":"0"},{"$f":"BK68/BK73","v":"0"},{"$f":"BL68/BL73","v":"0"}]
[null,"4.14","Cost Sharing Reduction",{"$f":"D69/D73","v":"$0.00"},{"$f":"E69/E73","v":"0"},{"$f":"F69/F73","v":"0"},{"$f":"G69/G73","v":"0"},{"$f":"H69/H73","v":"0"},{"$f":"I69/I73","v":"0"},{"$f":"J69/J73","v":"0"},{"$f":"K69/K73","v":"0"},{"$f":"L69/L73","v":"0"},{"$f":"M69/M73","v":"0"},{"$f":"N69/N73","v":"0"},{"$f":"O69/O73","v":"0"},{"$f":"P69/P73","v":"0"},{"$f":"Q69/Q73","v":"0"},{"$f":"R69/R73","v":"0"},{"$f":"S69/S73","v":"0"},{"$f":"T69/T73","v":"0"},{"$f":"U69/U73","v":"0"},{"$f":"V69/V73","v":"0"},{"$f":"W69/W73","v":"0"},{"$f":"X69/X73","v":"0"},{"$f":"Y69/Y73","v":"0"},{"$f":"Z69/Z73","v":"0"},{"$f":"AA69/AA73","v":"0"},{"$f":"AB69/AB73","v":"0"},{"$f":"AC69/AC73","v":"0"},{"$f":"AD69/AD73","v":"0"},{"$f":"AE69/AE73","v":"0"},{"$f":"AF69/AF73","v":"0"},{"$f":"AG69/AG73","v":"0"},{"$f":"AH69/AH73","v":"0"},{"$f":"AI69/AI73","v":"0"},{"$f":"AJ69/AJ73","v":"0"},{"$f":"AK69/AK73","v":"0"},{"$f":"AL69/AL73","v":"0"},{"$f":"AM69/AM73","v":"0"},{"$f":"AN69/AN73","v":"0"},{"$f":"AO69/AO73","v":"0"},{"$f":"AP69/AP73","v":"0"},{"$f":"AQ69/AQ73","v":"0"},{"$f":"AR69/AR73","v":"0"},{"$f":"AS69/AS73","v":"0"},{"$f":"AT69/AT73","v":"0"},{"$f":"AU69/AU73","v":"0"},{"$f":"AV69/AV73","v":"0"},{"$f":"AW69/AW73","v":"0"},{"$f":"AX69/AX73","v":"0"},{"$f":"AY69/AY73","v":"0"},{"$f":"AZ69/AZ73","v":"0"},{"$f":"BA69/BA73","v":"0"},{"$f":"BB69/BB73","v":"0"},{"$f":"BC69/BC73","v":"0"},{"$f":"BD69/BD73","v":"0"},{"$f":"BE69/BE73","v":"0"},{"$f":"BF69/BF73","v":"0"},{"$f":"BG69/BG73","v":"0"},{"$f":"BH69/BH73","v":"0"},{"$f":"BI69/BI73","v":"0"},{"$f":"BJ69/BJ73","v":"0"},{"$f":"BK69/BK73","v":"0"},{"$f":"BL69/BL73","v":"0"}]
[null,"4.15","Incurred Claims",{"$f":"D70/D73","v":"$882.15"},{"$f":"E70/E73","v":"0"},{"$f":"F70/F73","v":"895.3707"},{"$f":"G70/G73","v":"811.4917"},{"$f":"H70/H73","v":"875.5386"},{"$f":"I70/I73","v":"880.0041"},{"$f":"J70/J73","v":"872.7574"},{"$f":"K70/K73","v":"871.2411"},{"$f":"L70/L73","v":"786.3394"},{"$f":"M70/M73","v":"713.6003"},{"$f":"N70/N73","v":"885.7313"},{"$f":"O70/O73","v":"870.8516"},{"$f":"P70/P73","v":"1048.7047"},{"$f":"Q70/Q73","v":"1003.4773"},{"$f":"R70/R73","v":"884.7156"},{"$f":"S70/S73","v":"858.9573"},{"$f":"T70/T73","v":"887.3798"},{"$f":"U70/U73","v":"856.8839"},{"$f":"V70/V73","v":"845.9511"},{"$f":"W70/W73","v":"902.9271"},{"$f":"X70/X73","v":"0"},{"$f":"Y70/Y73","v":"0"},{"$f":"Z70/Z73","v":"0"},{"$f":"AA70/AA73","v":"884.5931"},{"$f":"AB70/AB73","v":"869.2266"},{"$f":"AC70/AC73","v":"861.9721"},{"$f":"AD70/AD73","v":"860.4396"},{"$f":"AE70/AE73","v":"860.5059"},{"$f":"AF70/AF73","v":"1038.1311"},{"$f":"AG70/AG73","v":"992.8883"},{"$f":"AH70/AH73","v":"874.1566"},{"$f":"AI70/AI73","v":"848.382"},{"$f":"AJ70/AJ73","v":"877.3949"},{"$f":"AK70/AK73","v":"865.5538"},{"$f":"AL70/AL73","v":"846.8993"},{"$f":"AM70/AM73","v":"835.951"},{"$f":"AN70/AN73","v":"892.3681"},{"$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"},{"$f":"BJ70/BJ73","v":"0"},{"$f":"BK70/BK73","v":"0"},{"$f":"BL70/BL73","v":"0"}]
[null,"4.16","Risk Adjustment Transfer Amount",{"$f":"D71/D73","v":"-$49.82"},{"$f":"E71/E73","v":"0"},{"$f":"F71/F73","v":"-49.82"},{"$f":"G71/G73","v":"-49.82"},{"$f":"H71/H73","v":"-49.82"},{"$f":"I71/I73","v":"-49.82"},{"$f":"J71/J73","v":"-49.82"},{"$f":"K71/K73","v":"-49.82"},{"$f":"L71/L73","v":"-49.82"},{"$f":"M71/M73","v":"-49.82"},{"$f":"N71/N73","v":"-49.82"},{"$f":"O71/O73","v":"-49.82"},{"$f":"P71/P73","v":"-49.82"},{"$f":"Q71/Q73","v":"-49.82"},{"$f":"R71/R73","v":"-49.82"},{"$f":"S71/S73","v":"-49.82"},{"$f":"T71/T73","v":"-49.82"},{"$f":"U71/U73","v":"-49.82"},{"$f":"V71/V73","v":"-49.82"},{"$f":"W71/W73","v":"-49.82"},{"$f":"X71/X73","v":"0"},{"$f":"Y71/Y73","v":"0"},{"$f":"Z71/Z73","v":"0"},{"$f":"AA71/AA73","v":"-49.82"},{"$f":"AB71/AB73","v":"-49.82"},{"$f":"AC71/AC73","v":"-49.82"},{"$f":"AD71/AD73","v":"-49.82"},{"$f":"AE71/AE73","v":"-49.82"},{"$f":"AF71/AF73","v":"-49.82"},{"$f":"AG71/AG73","v":"-49.82"},{"$f":"AH71/AH73","v":"-49.82"},{"$f":"AI71/AI73","v":"-49.82"},{"$f":"AJ71/AJ73","v":"-49.82"},{"$f":"AK71/AK73","v":"-49.82"},{"$f":"AL71/AL73","v":"-49.82"},{"$f":"AM71/AM73","v":"-49.82"},{"$f":"AN71/AN73","v":"-49.82"},{"$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"},{"$f":"BJ71/BJ73","v":"0"},{"$f":"BK71/BK73","v":"0"},{"$f":"BL71/BL73","v":"0"}]
[null,"4.17","Premium",{"$f":"D72/D73","v":"$1,146.69"},{"$f":"E72/E73","v":"0"},{"$f":"F72/F73","v":"1160.6973"},{"$f":"G72/G73","v":"1072.1112"},{"$f":"H72/H73","v":"1139.7492"},{"$f":"I72/I73","v":"1144.4153"},{"$f":"J72/J73","v":"1136.7623"},{"$f":"K72/K73","v":"1135.2056"},{"$f":"L72/L73","v":"1045.5008"},{"$f":"M72/M73","v":"968.6629"},{"$f":"N72/N73","v":"1150.3665"},{"$f":"O72/O73","v":"1134.6784"},{"$f":"P72/P73","v":"1322.5343"},{"$f":"Q72/Q73","v":"1274.7871"},{"$f":"R72/R73","v":"1149.3352"},{"$f":"S72/S73","v":"1122.1622"},{"$f":"T72/T73","v":"1152.3169"},{"$f":"U72/U73","v":"1119.9409"},{"$f":"V72/V73","v":"1108.4032"},{"$f":"W72/W73","v":"1168.5376"},{"$f":"X72/X73","v":"0"},{"$f":"Y72/Y73","v":"0"},{"$f":"Z72/Z73","v":"0"},{"$f":"AA72/AA73","v":"1149.2037"},{"$f":"AB72/AB73","v":"1132.9885"},{"$f":"AC72/AC73","v":"1125.4312"},{"$f":"AD72/AD73","v":"1123.7346"},{"$f":"AE72/AE73","v":"1123.8667"},{"$f":"AF72/AF73","v":"1311.4573"},{"$f":"AG72/AG73","v":"1263.7004"},{"$f":"AH72/AH73","v":"1138.1861"},{"$f":"AI72/AI73","v":"1111.0332"},{"$f":"AJ72/AJ73","v":"1141.6975"},{"$f":"AK72/AK73","v":"1129.2166"},{"$f":"AL72/AL73","v":"1109.4535"},{"$f":"AM72/AM73","v":"1097.8676"},{"$f":"AN72/AN73","v":"1157.4733"},{"$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"},{"$f":"BJ72/BJ73","v":"0"},{"$f":"BK72/BK73","v":"0"},{"$f":"BL72/BL73","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!"}}]