{"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 v8.2 [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 Insurance Company",null,null,null,null,null,null,null,"To validate, select the Validate button or Ctrl + Shift + I."]
[null,"HIOS Issuer ID:",28773.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:G19)","v":"1/1/2027"},"Market: ","Small Group"]
[]
[]
[null,"Market Level Calculations (Same for all Plans)"]
[]
[]
[null,"Section I: Experience Period Data"]
[null,"Experience Period:",null,"2025-01-01","to",{"$f":"EDATE(D12,12)-1","v":"12/31/2025"}]
[null,null,null,null,"Total","PMPM"]
[null,"Allowed Claims",null,null,1707211.83,{"$f":"IF(OR(E19=0,E19=\"\"), 0, E14/E19)","v":"$682.34"}]
[null,"Reinsurance",null,null,0.0,{"$f":"IF(OR(E19=0,E19=\"\"), 0, E15/E19)","v":"$0.00"}]
[null,"Incurred Claims in Experience Period",null,null,1366803.31,{"$f":"IF(OR(E19=0,E19=\"\"), 0, E16/E19)","v":"$546.28"}]
[null,"Risk Adjustment",null,null,-304570.8,{"$f":"IF(OR(E19=0,E19=\"\"), 0, E17/E19)","v":"-$121.73"}]
[null,"Experience Period Premium",null,null,2200656.06,{"$f":"IF(OR(E19=0,E19=\"\"), 0, E18/E19)","v":"$879.56"}]
[null,"Experience Period Member Months",null,null,{"$f":"'Wksh 2 - Plan Product Info'!D35","v":2502.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",57.49,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C24:G24)","v":"$71.21"}]
[null,"Outpatient Hospital",355.14,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C25:G25)","v":"$439.87"}]
[null,"Professional",130.36,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C26:G26)","v":"$161.46"}]
[null,"Other Medical",2.51,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C27:G27)","v":"$3.11"}]
[null,"Capitation",24.52,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C28:G28)","v":"$30.37"}]
[null,"Prescription Drug",112.32,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C29:G29)","v":"$139.12"}]
[null,"Total",{"$f":"SUM(C24:C29)","v":"$682.34"},null,null,null,null,{"$f":"SUM(H24:H29)","v":"$845.13"}]
[]
[null,"Morbidity Adjustment",null,null,null,1.04000000101709]
[null,"Demographic Shift",null,null,null,1.00006200184059]
[null,"Plan Design Changes",null,null,null,1.0020253901334]
[null,"Other",null,null,null,1.09038057300477]
[null,"Adjusted Trended EHB Allowed Claims PMPM for",null,{"$f":"IF(C5<>\"\",C5,\"\")","v":"1/1/2027"},null,{"$f":"H30*PRODUCT(F32:F35)","v":"$960.37"}]
[]
[null,"Manual EHB Allowed Claims PMPM",null,null,null,926.18]
[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/2027"},null,{"$f":"ROUND(F39*F36+(1-F39)*F38,2)","v":"$926.18"},{"$f":"F42*F48","v":"$866,904.48"}]
[null,"Reinsurance",null,null,null,0.0,{"$f":"F43*F48","v":"$0.00"}]
[null,"Risk Adjustment Payment/Charge",null,null,null,-194.45,{"$f":"F44*F48","v":"-$182,005.20"}]
[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,120.63"},{"$f":"F46*F48","v":"$1,048,909.68"}]
[]
[null,"Projected Member Months",null,null,null,{"$f":"'Wksh 2 - Plan Product Info'!D80","v":"936"}]
[]
[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":91,"n_cols":16,"rows_kept":91,"cut":false,"hidden":false,"merged":[[6,2,7,21],[9,4,9,6],[10,4,10,6],[20,4,20,6],[21,4,21,6],[63,4,63,6],[64,4,64,6],[65,4,65,6],[51,4,51,6]]}
["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,"1.2","Product ID",null,"28773KY009"]
[null,"1.3","Plan Name",null,"FA1P","FA1V","FA1R"]
[null,"1.4","Plan ID (Standard Component ID)",null,"28773KY0090002","28773KY0090004","28773KY0090005"]
[null,"1.5","Metal",null,"Gold","Gold","Silver"]
[null,"1.6","AV Metal Value",null,0.814,0.816,0.719]
[null,"1.7","Plan Category",null,"Renewing","Renewing","Renewing"]
[null,"1.8","Plan Type",null,"POS","POS","POS"]
[null,"1.9","Exchange Plan?",null,"No","No","No"]
[null,"1.10","Effective Date of Proposed Rates",null,"2027-01-01","2027-01-01","2027-01-01"]
[null,"1.11","Cumulative Rate Change %  (over 12 mos prior)",null,0.1057,0.114,0.1105]
[null,"1.12","Product Rate Increase %",null,{"$f":"IF(SUMPRODUCT((E16:G16=\"Renewing\")*((E14:G14=\"Platinum\")+(E14:G14=\"Gold\")+(E14:G14=\"Silver\")+(E14:G14=\"Bronze\")+(E14:G14=\"Catastrophic\")))=0, 0, IF(SUMPRODUCT(E36:G36,E37:G37,--((E16:G16=\"Renewing\")*((E14:G14=\"Platinum\")+(E14:G14=\"Gold\")+(E14:G14=\"Silver\")+(E14:G14=\"Bronze\")+(E14:G14=\"Catastrophic\"))))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:G20,E36:G36,E37:G37,--((E16:G16=\"Renewing\")*((E14:G14=\"Platinum\")+(E14:G14=\"Gold\")+(E14:G14=\"Silver\")+(E14:G14=\"Bronze\")+(E14:G14=\"Catastrophic\"))))/SUMPRODUCT(E36:G36,E37:G37,--((E16:G16=\"Renewing\")*((E14:G14=\"Platinum\")+(E14:G14=\"Gold\")+(E14:G14=\"Silver\")+(E14:G14=\"Bronze\")+(E14:G14=\"Catastrophic\")))), 4)-1, 4)))","v":"0.1084"}]
[null,"1.13","Submission Level Rate Increase %",null,{"$f":"IF(SUMPRODUCT((E16:G16=\"Renewing\")*((E14:G14=\"Platinum\")+(E14:G14=\"Gold\")+(E14:G14=\"Silver\")+(E14:G14=\"Bronze\")+(E14:G14=\"Catastrophic\")))=0, 0, IF(SUMPRODUCT(E36:G36,E37:G37,--((E16:G16=\"Renewing\")*((E14:G14=\"Platinum\")+(E14:G14=\"Gold\")+(E14:G14=\"Silver\")+(E14:G14=\"Bronze\")+(E14:G14=\"Catastrophic\"))))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:G20,E36:G36,E37:G37,--((E16:G16=\"Renewing\")*((E14:G14=\"Platinum\")+(E14:G14=\"Gold\")+(E14:G14=\"Silver\")+(E14:G14=\"Bronze\")+(E14:G14=\"Catastrophic\"))))/SUMPRODUCT(E36:G36,E37:G37,--((E16:G16=\"Renewing\")*((E14:G14=\"Platinum\")+(E14:G14=\"Gold\")+(E14:G14=\"Silver\")+(E14:G14=\"Bronze\")+(E14:G14=\"Catastrophic\")))), 4)-1, 4)))","v":"0.1084"}]
[]
["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":"28773KY0090002"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"28773KY0090004"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"28773KY0090005"}]
[{"$f":"'Wksh 1 - Market Experience'!E14","v":0},"2.2","Allowed Claims",{"$f":"SUM(E26:G26)","v":"$1,707,211"},1227818.13,212519.99,266873.71]
[{"$f":"'Wksh 1 - Market Experience'!E15","v":0},"2.3","Reinsurance",{"$f":"SUM(E27:G27)","v":"$0"},0.0,0.0,0.0]
[null,"2.4","Member Cost Sharing",{"$f":"SUM(E28:G28)","v":"$340,408"},224198.66,53267.86,62942.0000000001]
[null,"2.5","Federal Cost-Sharing Reduction (CSR) Payments",{"$f":"SUM(E29:G29)","v":"$0"},0.0,0.0,0.0]
[null,"2.6","Issuer CSR Payments",{"$f":"SUM(E30:G30)","v":"$0"},0.0,0.0,0.0]
[null,"2.7","Recoveries from CSR Load",{"$f":"SUM(E31:G31)","v":"$0"},0.0,0.0,0.0]
[{"$f":"'Wksh 1 - Market Experience'!E16","v":0},"2.8","Incurred Claims",{"$f":"D26-D27-D28-D29","v":"$1,366,803"},{"$f":"E26-E27-E28-E29","v":"1003619.47"},{"$f":"F26-F27-F28-F29","v":"159252.13"},{"$f":"G26-G27-G28-G29","v":"203931.71"}]
[{"$f":"'Wksh 1 - Market Experience'!E17","v":0},"2.9","Risk Adjustment Transfer Amount",{"$f":"SUM(E33:G33)","v":"-$304,570"},-195406.48,-48383.31,-60781.01]
[{"$f":"'Wksh 1 - Market Experience'!E18","v":0},"2.10","Premium",{"$f":"SUM(E34:G34)","v":"$2,200,656"},1411896.5,349590.38,439169.18]
[{"$f":"'Wksh 1 - Market Experience'!E19","v":{"$error":"#REF!"}},"2.11","Experience Period Member Months",{"$f":"SUM(E35:G35)","v":"2502"},1671.0,365.0,466.0]
[null,"2.12","Current Enrollment",{"$f":"SUM(E36:G36)","v":"134"},89.0,25.0,20.0]
[null,"2.13","Current Premium PMPM",{"$f":"IF(OR(D36=0,D36=\"\"), 0, SUMPRODUCT(E37:G37,E36:G36)/D36)","v":"$953.55"},850.89797752809,1137.184,1180.806]
[null,"2.14","Loss Ratio",{"$f":"IF(OR(D33+D34=0,D33+D34=\"\"), 0, D32/(D33+D34))","v":"72.09%"},0.825012497841947,0.528713120844076,0.538948429598103]
[null,null,"Per Member Per Month"]
[null,"2.15","Allowed Claims",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D26/D35)","v":"$682.34"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E26/E35)","v":"734.7804"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F26/F35)","v":"582.2465"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G26/G35)","v":"572.6904"}]
[null,"2.16","Reinsurance",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D27/D35)","v":"$0.00"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E27/E35)","v":"0"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F27/F35)","v":"0"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G27/G35)","v":"0"}]
[null,"2.17","Member Cost Sharing",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D28/D35)","v":"$136.05"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E28/E35)","v":"134.1704"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F28/F35)","v":"145.9393"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G28/G35)","v":"135.0687"}]
[null,"2.18","Federal CSR Payments",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D29/D35)","v":"$0.00"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E29/E35)","v":"0"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F29/F35)","v":"0"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G29/G35)","v":"0"}]
[null,"2.19","Issuer CSR Payments",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D30/D35)","v":"$0.00"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E30/E35)","v":"0"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F30/F35)","v":"0"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G30/G35)","v":"0"}]
[null,"2.20","Recoveries from CSR Load",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D31/D35)","v":"$0.00"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E31/E35)","v":"0"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F31/F35)","v":"0"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G31/G35)","v":"0"}]
[null,"2.21","Incurred Claims",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D32/D35)","v":"$546.28"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E32/E35)","v":"600.6101"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F32/F35)","v":"436.3072"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G32/G35)","v":"437.6217"}]
[null,"2.22","Risk Adjustment Transfer Amount",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D33/D35)","v":"-$121.73"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E33/E35)","v":"-116.9398"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F33/F35)","v":"-132.557"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G33/G35)","v":"-130.4314"}]
[null,"2.23","Premium",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D34/D35)","v":"$879.56"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E34/E35)","v":"844.9411"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F34/F35)","v":"957.7819"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G34/G35)","v":"942.4231"}]
[]
[null,null,"Section III: Plan Adjustment Factors"]
[null,"3.1","Plan ID (Standard Component ID)",null,{"$f":"IF(E13<>\"\",E13,\"\")","v":"28773KY0090002"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"28773KY0090004"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"28773KY0090005"}]
[null,"3.2","Market Adjusted Index Rate",null,{"$f":"'Wksh 1 - Market Experience'!F46","v":"$1,120.63"}]
[null,"3.3","AV and Cost Sharing Design of Plan",null,0.8252,0.8098,0.7434]
[null,"3.4","CSR Load Factor",null,1.0,1.0,1.0]
[null,"3.5","Provider Network Adjustment",null,1.0,1.0,1.0]
[null,"3.6","Benefits in Addition to EHB",null,1.0,1.0,1.0]
[null,null,"Administrative Costs"]
[null,"3.7","Administrative Expense",null,0.077,0.0783,0.0841]
[null,"3.8","Taxes and Fees",null,0.0786,0.0789,0.0804]
[null,"3.9","Profit & Risk Load",null,0.0453,0.046,0.0495]
[null,"3.10","Catastrophic Adjustment",null,1.0,1.0,1.0]
[null,"3.11","Plan Adjusted Index Rate",null,{"$f":"($E$52*PRODUCT(E53:E56)*E61)/(1-SUM(E58:E60))","v":"$1,157.23"},{"$f":"($E$52*PRODUCT(F53:F56)*F61)/(1-SUM(F58:F60))","v":"$1,138.91"},{"$f":"($E$52*PRODUCT(G53:G56)*G61)/(1-SUM(G58:G60))","v":"$1,059.89"}]
[]
[null,"3.12","Age Calibration Factor","0.7897",{"$f":"IF(D64<>\"\", D64, \"\")","v":"0.7897"},"0.0000","0.0000"]
[null,"3.13","Geographic Calibration Factor","1.3975",{"$f":"IF(D65<>\"\", D65, \"\")","v":"1.3975"},"0.0000","0.0000"]
[null,"3.14","Tobacco Calibration Factor","1.0000",{"$f":"IF(D66<>\"\", D66, \"\")","v":"1.0000"},"0.0000","0.0000"]
[null,"3.15","Calibrated Plan Adjusted Index Rate",null,{"$f":"E62*(PRODUCT($E$64:$E$66))","v":"$1,277.13"},{"$f":"F62*(PRODUCT($E$64:$E$66))","v":"$1,256.91"},{"$f":"G62*(PRODUCT($E$64:$E$66))","v":"$1,169.70"}]
[]
[null,null,"Section IV: Projected Plan Level Information"]
[null,"4.1","Plan ID (Standard Component ID)","Total",{"$f":"IF(E13<>\"\",E13,\"\")","v":"28773KY0090002"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"28773KY0090004"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"28773KY0090005"}]
[null,"4.2","Allowed Claims",{"$f":"SUM(E71:G71)","v":"$866,912"},615070.7763,180900.6894,70941.4468]
[null,"4.3","Reinsurance",{"$f":"SUM(E72:G72)","v":"$0"},0.0,0.0,0.0]
[null,"4.4","Member Cost Sharing",{"$f":"SUM(E73:G73)","v":"$160,225"},108337.9263,34654.0794,17233.8368]
[null,"4.5","Federal CSR Payments",{"$f":"SUM(E74:G74)","v":"$0"},0.0,0.0,0.0]
[null,"4.6","Issuer CSR Payments",{"$f":"SUM(E75:G75)","v":"$0"},0.0,0.0,0.0]
[null,"4.7","Recoveries from CSR Load",{"$f":"SUM(E76:G76)","v":"$0"},0.0,0.0,0.0]
[null,"4.8","Incurred Claims",{"$f":"D71-D72-D73-D74","v":"$706,687"},{"$f":"E71-E72-E73-E74","v":"506732.85"},{"$f":"F71-F72-F73-F74","v":"146246.61"},{"$f":"G71-G72-G73-G74","v":"53707.61"}]
[null,"4.9","Risk Adjustment Transfer Amount",{"$f":"SUM(E78:G78)","v":"-$148,365"},-105092.13,-30909.45,-12363.78]
[null,"4.10","Premium",{"$f":"SUM(E79:G79)","v":"$1,072,004"},767244.64,222088.11,82671.7]
[null,"4.11","Projected Member Months",{"$f":"SUM(E80:G80)","v":"936"},663.0,195.0,78.0]
[null,"4.12","Loss Ratio",{"$f":"IF(OR(D78+D79=0,D78+D79=\"\"), 0, D77/(D78+D79))","v":"76.51%"},{"$f":"IF(OR(E78+E79=0,E78+E79=\"\"), 0, E77/(E78+E79))","v":"0.765281173667982"},{"$f":"IF(OR(F78+F79=0,F78+F79=\"\"), 0, F77/(F78+F79))","v":"0.764973506980329"},{"$f":"IF(OR(G78+G79=0,G78+G79=\"\"), 0, G77/(G78+G79))","v":"0.763891322627664"}]
[null,null,"Per Member Per Month"]
[null,"4.13","Allowed Claims",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D71/D80)","v":"$926.19"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E71/E80)","v":"927.7086"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F71/F80)","v":"927.6958"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G71/G80)","v":"909.5057"}]
[null,"4.14","Reinsurance",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D72/D80)","v":"$0.00"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E72/E80)","v":"0"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F72/F80)","v":"0"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G72/G80)","v":"0"}]
[null,"4.15","Member Cost Sharing",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D73/D80)","v":"$171.18"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E73/E80)","v":"163.4056"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F73/F80)","v":"177.7132"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G73/G80)","v":"220.9466"}]
[null,"4.16","Federal CSR Payments",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D74/D80)","v":"$0.00"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E74/E80)","v":"0"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F74/F80)","v":"0"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G74/G80)","v":"0"}]
[null,"4.17","Issuer CSR Payments",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D75/D80)","v":"$0.00"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E75/E80)","v":"0"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F75/F80)","v":"0"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G75/G80)","v":"0"}]
[null,"4.18","Recoveries from CSR Load",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D76/D80)","v":"$0.00"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E76/E80)","v":"0"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F76/F80)","v":"0"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G76/G80)","v":"0"}]
[null,"4.19","Incurred Claims",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D77/D80)","v":"$755.01"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E77/E80)","v":"764.3029"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F77/F80)","v":"749.9826"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G77/G80)","v":"688.5591"}]
[null,"4.20","Risk Adjustment Transfer Amount",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D78/D80)","v":"-$158.51"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E78/E80)","v":"-158.51"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F78/F80)","v":"-158.51"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G78/G80)","v":"-158.51"}]
[null,"4.21","Premium",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D79/D80)","v":"$1,145.30"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E79/E80)","v":"1157.2317"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F79/F80)","v":"1138.9134"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G79/G80)","v":"1059.8936"}]

{"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":91,"n_cols":15,"rows_kept":91,"cut":false,"hidden":true,"merged":[[4,6,4,8],[9,3,21,3],[57,3,61,3],[50,3,55,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",0,null,null,null,null,null,null,null,"KY"]
[null,"2.4","Member Cost Sharing",0,null,null,null,null,null,null,null,"LA"]
[null,"2.5","Federal Cost-Sharing Reduction (CSR) Payments",0,null,null,null,null,null,null,null,"ME"]
[null,"2.6","Issuer CSR Payments",0,null,null,null,null,null,null,null,"MD"]
[null,"2.7","Recoveries from CSR Load",0,null,null,null,null,null,null,null,"MA"]
[null,"2.8","Incurred Claims",{"$f":"D26-D27-D28-D29","v":0},{"$f":"E26-E27-E28-E29","v":0},null,null,null,null,null,null,"MI"]
[null,"2.9","Risk Adjustment Transfer Amount",{"$f":"SUM(E33:XFD33)","v":0},null,null,null,null,null,null,null,"MN"]
[null,"2.10","Premium",{"$f":"SUM(E34:XFD34)","v":0},null,null,null,null,null,null,null,"MS"]
[null,"2.11","Experience Period Member Months",{"$f":"SUM(E35:XFD35)","v":0},null,null,null,null,null,null,null,"MO"]
[null,"2.12","Current Enrollment",{"$f":"SUM(E36:XFD36)","v":0},null,null,null,null,null,null,null,"MT"]
[null,"2.13","Current Premium PMPM",{"$f":"IF(OR(D36=0,D36=\"\"), 0, SUMPRODUCT(E37:XFD37,E36:XFD36)/D36)","v":0},null,null,null,null,null,null,null,"NE"]
[null,"2.14","Loss Ratio",{"$f":"IF(OR(D33+D34=0,D33+D34=\"\"), 0, D32/(D33+D34))","v":0},{"$f":"IF(OR(E33+E34=0,E33+E34=\"\"), 0, E32/(E33+E34))","v":0},null,null,null,null,null,null,"NV"]
[null,null,"Per Member Per Month",null,null,null,null,null,null,null,null,"NH"]
[null,"2.15","Allowed Claims",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D26/D35)","v":0},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E26/E35)","v":0},null,null,null,null,null,null,"NJ"]
[null,"2.16","Reinsurance",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D27/D35)","v":0},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E27/E35)","v":0},null,null,null,null,null,null,"NM"]
[null,"2.17","Member Cost Sharing",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D28/D35)","v":0},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E28/E35)","v":0},null,null,null,null,null,null,"NY"]
[null,"2.18","Federal CSR Payments",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D29/D35)","v":0},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E29/E35)","v":0},null,null,null,null,null,null,"NC"]
[null,"2.19","Issuer CSR Payments",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D30/D35)","v":0},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E30/E35)","v":0},null,null,null,null,null,null,"ND"]
[null,"2.20","Recoveries from CSR Load",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D31/D35)","v":0},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E31/E35)","v":0},null,null,null,null,null,null,"OH"]
[null,"2.21","Incurred Claims",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D32/D35)","v":0},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E32/E35)","v":0},null,null,null,null,null,null,"OK"]
[null,"2.22","Risk Adjustment Transfer Amount",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D33/D35)","v":0},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E33/E35)","v":0},null,null,null,null,null,null,"OR"]
[null,"2.23","Premium",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D34/D35)","v":0},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E34/E35)","v":0},null,null,null,null,null,null,"PA"]
[null,null,null,null,null,null,null,null,null,null,null,"RI"]
[null,null,"Section III: Plan Adjustment Factors",null,null,null,null,null,null,null,null,"SC"]
[null,"3.1","Plan ID (Standard Component ID)",null,{"$f":"IF(E13<>\"\",E13,\"\")","v":""},null,null,null,null,null,null,"SD"]
[null,"3.2","Market Adjusted Index Rate",null,{"$f":"'Wksh 1 - Market Experience'!F46","v":0},null,null,null,null,null,null,"TN"]
[null,"3.3","AV and Cost Sharing Design of Plan",null,null,null,null,null,null,null,null,"TX"]
[null,"3.4","CSR Load Factor",null,null,null,null,null,null,null,null,"UT"]
[null,"3.5","Provider Network Adjustment",null,null,null,null,null,null,null,null,"VT"]
[null,"3.6","Benefits in Addition to EHB",null,null,null,null,null,null,null,null,"VA"]
[null,null,"Administrative Costs",null,null,null,null,null,null,null,null,"WA"]
[null,"3.7","Administrative Expense",null,null,null,null,null,null,null,null,"WV"]
[null,"3.8","Taxes and Fees",null,null,null,null,null,null,null,null,"WI"]
[null,"3.9","Profit & Risk Load",null,null,null,null,null,null,null,null,"WY"]
[null,"3.10","Catastrophic Adjustment"]
[null,"3.11","Plan Adjusted Index Rate",null,{"$f":"($E$52*PRODUCT(E53:E56)*E61)/(1-SUM(E58:E60))","v":0}]
[]
[null,"3.12","Age Calibration Factor",null,{"$f":"IF(D64<>\"\", D64, \"\")","v":""}]
[null,"3.13","Geographic Calibration Factor",null,{"$f":"IF(D65<>\"\", D65, \"\")","v":""}]
[null,"3.14","Tobacco Calibration Factor",null,{"$f":"IF(D66<>\"\", D66, \"\")","v":""}]
[null,"3.15","Calibrated Plan Adjusted Index Rate",null,{"$f":"E62*(PRODUCT($E$64:$E$66))","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(E71:XFD71)","v":0}]
[null,"4.3","Reinsurance",0]
[null,"4.4","Member Cost Sharing",0]
[null,"4.5","Federal CSR Payments",0]
[null,"4.6","Issuer CSR Payments",0]
[null,"4.7","Recoveries from CSR Load",0]
[null,"4.8","Incurred Claims",{"$f":"D71-D72-D73-D74","v":0},{"$f":"E71-E72-E73-E74","v":0}]
[null,"4.9","Risk Adjustment Transfer Amount",{"$f":"SUM(E78:XFD78)","v":0}]
[null,"4.10","Premium",{"$f":"SUM(E79:XFD79)","v":0}]
[null,"4.11","Projected Member Months",{"$f":"SUM(E80:XFD80)","v":0}]
[null,"4.12","Loss Ratio",{"$f":"IF(OR(D78+D79=0,D78+D79=\"\"), 0, D77/(D78+D79))","v":0},{"$f":"IF(OR(E78+E79=0,E78+E79=\"\"), 0, E77/(E78+E79))","v":0}]
[null,null,"Per Member Per Month"]
[null,"4.13","Allowed Claims",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D71/D80)","v":0},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E71/E80)","v":0}]
[null,"4.14","Reinsurance",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D72/D80)","v":0},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E72/E80)","v":0}]
[null,"4.15","Member Cost Sharing",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D73/D80)","v":0},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E73/E80)","v":0}]
[null,"4.16","Federal CSR Payments",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D74/D80)","v":0},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E74/E80)","v":0}]
[null,"4.17","Issuer CSR Payments",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D75/D80)","v":0},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E75/E80)","v":0}]
[null,"4.18","Recoveries from CSR Load",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D76/D80)","v":0},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E76/E80)","v":0}]
[null,"4.15","Incurred Claims",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D77/D80)","v":0},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E77/E80)","v":0}]
[null,"4.16","Risk Adjustment Transfer Amount",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D78/D80)","v":0},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E78/E80)","v":0}]
[null,"4.17","Premium",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D79/D80)","v":0},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E79/E80)","v":0}]