{"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 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:AY19)","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,9273705.99000001,{"$f":"IF(OR(E19=0,E19=\"\"), 0, E14/E19)","v":"$752.31"}]
[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,7571381.12,{"$f":"IF(OR(E19=0,E19=\"\"), 0, E16/E19)","v":"$614.21"}]
[null,"Risk Adjustment",null,null,-1657047.35,{"$f":"IF(OR(E19=0,E19=\"\"), 0, E17/E19)","v":"-$134.42"}]
[null,"Experience Period Premium",null,null,1.197288548E7,{"$f":"IF(OR(E19=0,E19=\"\"), 0, E18/E19)","v":"$971.27"}]
[null,"Experience Period Member Months",null,null,{"$f":"'Wksh 2 - Plan Product Info'!D35","v":12327.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",65.18,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C24:G24)","v":"$80.73"}]
[null,"Outpatient Hospital",383.82,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C25:G25)","v":"$475.39"}]
[null,"Professional",126.77,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C26:G26)","v":"$157.01"}]
[null,"Other Medical",1.27,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C27:G27)","v":"$1.57"}]
[null,"Capitation",24.95,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C28:G28)","v":"$30.90"}]
[null,"Prescription Drug",150.32,1.023,1.08,1.038,1.08,{"$f":"PRODUCT(C29:G29)","v":"$186.18"}]
[null,"Total",{"$f":"SUM(C24:C29)","v":"$752.31"},null,null,null,null,{"$f":"SUM(H24:H29)","v":"$931.79"}]
[]
[null,"Morbidity Adjustment",null,null,null,1.03999999988683]
[null,"Demographic Shift",null,null,null,0.999995870442433]
[null,"Plan Design Changes",null,null,null,1.00275144035059]
[null,"Other",null,null,null,1.04978192074561]
[null,"Adjusted Trended EHB Allowed Claims PMPM for",null,{"$f":"IF(C5<>\"\",C5,\"\")","v":"1/1/2027"},null,{"$f":"H30*PRODUCT(F32:F35)","v":"$1,020.10"}]
[]
[null,"Manual EHB Allowed Claims PMPM",null,null,null,1044.12]
[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":"$1,044.12"},{"$f":"F42*F48","v":"$7,696,208.52"}]
[null,"Reinsurance",null,null,null,0.0,{"$f":"F43*F48","v":"$0.00"}]
[null,"Risk Adjustment Payment/Charge",null,null,null,-218.51,{"$f":"F44*F48","v":"-$1,610,637.21"}]
[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,262.63"},{"$f":"F46*F48","v":"$9,306,845.73"}]
[]
[null,"Projected Member Months",null,null,null,{"$f":"'Wksh 2 - Plan Product Info'!D80","v":"7371"}]
[]
[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":51,"rows_kept":91,"cut":false,"hidden":false,"merged":[[6,2,7,21],[9,4,9,24],[9,25,9,50],[10,4,10,24],[10,25,10,50],[20,4,20,24],[20,25,20,50],[21,4,21,50],[63,4,63,50],[64,4,64,50],[65,4,65,50],[51,4,51,50]]}
["Press TAB and directional arrow keys to read through the document. If macros are disabled, press and hold the ALT key and press the F, then I, and then N key. After that, select the Enable All Content option by pressing enter. (note that you can also press the C key to select \"Enable All Content\")  Instructions can be found in cells P1 through P6. If screen reader fails to announce a cell after performing a dropdown selection, please press F2 and then ESC to force the screen reader to resume.",null,"Product-Plan Data Collection [assistive technology users, please reference cell A1 for instructions]",null,null,null,null,null,null,null,null,null,null,null,null,"To add a product to Worksheet 2 - Plan Product Info, select the Add Product button or Ctrl + Shift + P."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To add a plan to Worksheet 2 - Plan Product Info, select the Add Plan button or Ctrl + Shift + L."]
[null,null,"Company Legal Name:",{"$f":"IF('Wksh 1 - Market Experience'!C3<>\"\", 'Wksh 1 - Market Experience'!C3,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"To validate, select the Validate button or Ctrl + Shift + I."]
[null,null,"HIOS Issuer ID:",{"$f":"IF('Wksh 1 - Market Experience'!C4<>\"\", 'Wksh 1 - Market Experience'!C4,\"\")","v":""},"State:",{"$f":"IF('Wksh 1 - Market Experience'!E4<>\"\",'Wksh 1 - Market Experience'!E4,\"\")","v":""},null,null,null,null,null,null,null,null,null,"To finalize, select the Finalize button or Ctrl + Shift + F."]
[null,null,"Effective Date of Rate Change(s):",{"$f":"IF('Wksh 1 - Market Experience'!C5<>\"\", 'Wksh 1 - Market Experience'!C5,\"\")","v":"00:00:00"},"Market: ",{"$f":"IF('Wksh 1 - Market Experience'!E5<>\"\",'Wksh 1 - Market Experience'!E5,\"\")","v":""},null,null,null,null,null,null,null,null,null,"To remove a product, navigate to the corresponding Product Name/Product ID field and select the Remove Product button or Ctrl + Shift + Q."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To remove a plan, navigate to the corresponding Plan Name/Plan ID field and select the Remove Plan button or Ctrl + Shift + A."]
[null,null,"Product/Plan Level Calculations"]
[]
[null,"Field #","Section I: General Product and Plan Information"]
[null,"1.1","Product Name",null,"Choice Plus Essential",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choice Essential"]
[null,"1.2","Product ID",null,"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,"FA-17","FA-18","FA1T","FA1S","FA2L","FA-12","FA-16","FA1W","FA1U","FA1O","FA1Y","FA-14","FA2A","FA2C","FA2O","FA2N","FA2M","FA2K","FA2J","FA2Q","DW2R","FA1Q","FA1Z","FA-15","FA1X","FA-13","FA-19","FA2B","FA2I","FA2H","FA2G","FA2F","FA2E","FA2D","FA2P","DDST","DW2Z","DW2D","DW2E","DW2F","DW2G","CT-87","DDT-7","CT9A","CT9B","CT9C","CT9D"]
[null,"1.4","Plan ID (Standard Component ID)",null,"23671KY0070062","23671KY0070063","23671KY0070003","23671KY0070012","23671KY0070037","23671KY0070046","23671KY0070047","23671KY0070048","23671KY0070049","23671KY0070050","23671KY0070051","23671KY0070052","23671KY0070053","23671KY0070054","23671KY0070055","23671KY0070056","23671KY0070057","23671KY0070058","23671KY0070059","23671KY0070061","23671KY0070060","23671KY0080034","23671KY0080035","23671KY0080036","23671KY0080037","23671KY0080042","23671KY0080043","23671KY0080044","23671KY0080045","23671KY0080046","23671KY0080047","23671KY0080048","23671KY0080049","23671KY0080050","23671KY0080067","23671KY0080009","23671KY0080025","23671KY0080038","23671KY0080039","23671KY0080040","23671KY0080041","23671KY0080059","23671KY0080060","23671KY0080062","23671KY0080063","23671KY0080064","23671KY0080065"]
[null,"1.5","Metal",null,"Platinum","Gold","Gold","Silver","Gold","Gold","Gold","Gold","Silver","Bronze","Gold","Gold","Platinum","Platinum","Gold","Gold","Gold","Gold","Gold","Gold","Silver","Gold","Gold","Gold","Gold","Gold","Platinum","Platinum","Gold","Gold","Gold","Gold","Gold","Gold","Gold","Silver","Silver","Silver","Silver","Bronze","Gold","Platinum","Platinum","Gold","Gold","Gold","Gold"]
[null,"1.6","AV Metal Value",null,0.914,0.799,0.814,0.684,0.819,0.817,0.816,0.816,0.712,0.647,0.812,0.814,0.917,0.914,0.819,0.81,0.816,0.811,0.807,0.812,0.714,0.814,0.817,0.816,0.816,0.814,0.917,0.914,0.819,0.81,0.816,0.819,0.811,0.807,0.812,0.72,0.714,0.712,0.709,0.64,0.794,0.903,0.881,0.795,0.815,0.808,0.796]
[null,"1.7","Plan Category",null,"New","New","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Terminated","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Renewing","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated","Terminated"]
[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","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"]
[null,"1.10","Effective Date of Proposed Rates",null,"2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01","2027-01-01"]
[null,"1.11","Cumulative Rate Change %  (over 12 mos prior)",null,0.0,0.0,0.1019,0.0303,0.1111,0.1109,0.1099,0.1097,0.0983,0.0901,0.1175,0.1097,0.1133,0.1089,0.1128,0.1093,0.1005,0.1084,0.1087,0.0868,0.0,0.1025,0.1116,0.1106,0.1104,0.1104,0.1138,0.1094,0.1136,0.1097,0.1011,0.1117,0.1089,0.1093,0.0871,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:Y16=\"Renewing\")*((E14:Y14=\"Platinum\")+(E14:Y14=\"Gold\")+(E14:Y14=\"Silver\")+(E14:Y14=\"Bronze\")+(E14:Y14=\"Catastrophic\")))=0, 0, IF(SUMPRODUCT(E36:Y36,E37:Y37,--((E16:Y16=\"Renewing\")*((E14:Y14=\"Platinum\")+(E14:Y14=\"Gold\")+(E14:Y14=\"Silver\")+(E14:Y14=\"Bronze\")+(E14:Y14=\"Catastrophic\"))))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:Y20,E36:Y36,E37:Y37,--((E16:Y16=\"Renewing\")*((E14:Y14=\"Platinum\")+(E14:Y14=\"Gold\")+(E14:Y14=\"Silver\")+(E14:Y14=\"Bronze\")+(E14:Y14=\"Catastrophic\"))))/SUMPRODUCT(E36:Y36,E37:Y37,--((E16:Y16=\"Renewing\")*((E14:Y14=\"Platinum\")+(E14:Y14=\"Gold\")+(E14:Y14=\"Silver\")+(E14:Y14=\"Bronze\")+(E14:Y14=\"Catastrophic\")))), 4)-1, 4)))","v":"0.1048"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT((Z16:AY16=\"Renewing\")*((Z14:AY14=\"Platinum\")+(Z14:AY14=\"Gold\")+(Z14:AY14=\"Silver\")+(Z14:AY14=\"Bronze\")+(Z14:AY14=\"Catastrophic\")))=0, 0, IF(SUMPRODUCT(Z36:AY36,Z37:AY37,--((Z16:AY16=\"Renewing\")*((Z14:AY14=\"Platinum\")+(Z14:AY14=\"Gold\")+(Z14:AY14=\"Silver\")+(Z14:AY14=\"Bronze\")+(Z14:AY14=\"Catastrophic\"))))=0, 0, ROUND(ROUND(SUMPRODUCT(1+Z20:AY20,Z36:AY36,Z37:AY37,--((Z16:AY16=\"Renewing\")*((Z14:AY14=\"Platinum\")+(Z14:AY14=\"Gold\")+(Z14:AY14=\"Silver\")+(Z14:AY14=\"Bronze\")+(Z14:AY14=\"Catastrophic\"))))/SUMPRODUCT(Z36:AY36,Z37:AY37,--((Z16:AY16=\"Renewing\")*((Z14:AY14=\"Platinum\")+(Z14:AY14=\"Gold\")+(Z14:AY14=\"Silver\")+(Z14:AY14=\"Bronze\")+(Z14:AY14=\"Catastrophic\")))), 4)-1, 4)))","v":"0.1106"}]
[null,"1.13","Submission Level Rate Increase %",null,{"$f":"IF(SUMPRODUCT((E16:AY16=\"Renewing\")*((E14:AY14=\"Platinum\")+(E14:AY14=\"Gold\")+(E14:AY14=\"Silver\")+(E14:AY14=\"Bronze\")+(E14:AY14=\"Catastrophic\")))=0, 0, IF(SUMPRODUCT(E36:AY36,E37:AY37,--((E16:AY16=\"Renewing\")*((E14:AY14=\"Platinum\")+(E14:AY14=\"Gold\")+(E14:AY14=\"Silver\")+(E14:AY14=\"Bronze\")+(E14:AY14=\"Catastrophic\"))))=0, 0, ROUND(ROUND(SUMPRODUCT(1+E20:AY20,E36:AY36,E37:AY37,--((E16:AY16=\"Renewing\")*((E14:AY14=\"Platinum\")+(E14:AY14=\"Gold\")+(E14:AY14=\"Silver\")+(E14:AY14=\"Bronze\")+(E14:AY14=\"Catastrophic\"))))/SUMPRODUCT(E36:AY36,E37:AY37,--((E16:AY16=\"Renewing\")*((E14:AY14=\"Platinum\")+(E14:AY14=\"Gold\")+(E14:AY14=\"Silver\")+(E14:AY14=\"Bronze\")+(E14:AY14=\"Catastrophic\")))), 4)-1, 4)))","v":"0.1057"}]
[]
["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":"23671KY0070062"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"23671KY0070063"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"23671KY0070003"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"23671KY0070012"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"23671KY0070037"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"23671KY0070046"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"23671KY0070047"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"23671KY0070048"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"23671KY0070049"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"23671KY0070050"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"23671KY0070051"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"23671KY0070052"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"23671KY0070053"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"23671KY0070054"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"23671KY0070055"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"23671KY0070056"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"23671KY0070057"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"23671KY0070058"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"23671KY0070059"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"23671KY0070061"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"23671KY0070060"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"23671KY0080034"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"23671KY0080035"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"23671KY0080036"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"23671KY0080037"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"23671KY0080042"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"23671KY0080043"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"23671KY0080044"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"23671KY0080045"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"23671KY0080046"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"23671KY0080047"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"23671KY0080048"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"23671KY0080049"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"23671KY0080050"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"23671KY0080067"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"23671KY0080009"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"23671KY0080025"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"23671KY0080038"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"23671KY0080039"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"23671KY0080040"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"23671KY0080041"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"23671KY0080059"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"23671KY0080060"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"23671KY0080062"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"23671KY0080063"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"23671KY0080064"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"23671KY0080065"}]
[{"$f":"'Wksh 1 - Market Experience'!E14","v":0},"2.2","Allowed Claims",{"$f":"SUM(E26:AY26)","v":"$9,277,972"},0.0,0.0,2852188.94,137325.91,219776.98,369014.27,1136141.73,710351.56,106350.85,17916.42,86672.75,164424.58,269290.22,953047.87,0.0,94265.68,143298.31,150277.58,139025.72,0.0,263727.07,0.0,0.0,0.0,0.0,0.0,226961.29,16921.48,0.0,17440.46,240967.21,403329.44,0.0,267347.04,0.0,13634.02,143687.28,45887.65,12849.94,4959.78,0.0,522.75,1249.23,21343.96,39884.0,171.91,7719.06]
[{"$f":"'Wksh 1 - Market Experience'!E15","v":0},"2.3","Reinsurance",{"$f":"SUM(E27:AY27)","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]
[null,"2.4","Member Cost Sharing",{"$f":"SUM(E28:AY28)","v":"$1,703,151"},0.0,0.0,578386.98,45580.74,48066.25,76455.85,76433.1000000001,126600.09,30293.34,11086.6,24390.64,49999.26,28556.74,38567.35,0.0,23175.79,33893.87,53401.92,35271.18,0.0,112767.02,0.0,0.0,0.0,0.0,0.0,22344.33,1529.7,0.0,3902.41,6280.45000000001,107197.47,0.0,51067.1,0.0,6990.9,61857.76,7937.65,9590.21,3451.96,0.0,105.21,486.93,11019.27,12211.38,69.18,4183.05]
[null,"2.5","Federal Cost-Sharing Reduction (CSR) Payments",{"$f":"SUM(E29:AY29)","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]
[null,"2.6","Issuer CSR Payments",{"$f":"SUM(E30:AY30)","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]
[null,"2.7","Recoveries from CSR Load",{"$f":"SUM(E31:AY31)","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]
[{"$f":"'Wksh 1 - Market Experience'!E16","v":0},"2.8","Incurred Claims",{"$f":"D26-D27-D28-D29","v":"$7,574,821"},{"$f":"E26-E27-E28-E29","v":"0"},{"$f":"F26-F27-F28-F29","v":"0"},{"$f":"G26-G27-G28-G29","v":"2273801.96"},{"$f":"H26-H27-H28-H29","v":"91745.17"},{"$f":"I26-I27-I28-I29","v":"171710.73"},{"$f":"J26-J27-J28-J29","v":"292558.42"},{"$f":"K26-K27-K28-K29","v":"1059708.63"},{"$f":"L26-L27-L28-L29","v":"583751.47"},{"$f":"M26-M27-M28-M29","v":"76057.51"},{"$f":"N26-N27-N28-N29","v":"6829.82"},{"$f":"O26-O27-O28-O29","v":"62282.11"},{"$f":"P26-P27-P28-P29","v":"114425.32"},{"$f":"Q26-Q27-Q28-Q29","v":"240733.48"},{"$f":"R26-R27-R28-R29","v":"914480.52"},{"$f":"S26-S27-S28-S29","v":"0"},{"$f":"T26-T27-T28-T29","v":"71089.89"},{"$f":"U26-U27-U28-U29","v":"109404.44"},{"$f":"V26-V27-V28-V29","v":"96875.66"},{"$f":"W26-W27-W28-W29","v":"103754.54"},{"$f":"X26-X27-X28-X29","v":"0"},{"$f":"Y26-Y27-Y28-Y29","v":"150960.05"},{"$f":"Z26-Z27-Z28-Z29","v":"0"},{"$f":"AA26-AA27-AA28-AA29","v":"0"},{"$f":"AB26-AB27-AB28-AB29","v":"0"},{"$f":"AC26-AC27-AC28-AC29","v":"0"},{"$f":"AD26-AD27-AD28-AD29","v":"0"},{"$f":"AE26-AE27-AE28-AE29","v":"204616.96"},{"$f":"AF26-AF27-AF28-AF29","v":"15391.78"},{"$f":"AG26-AG27-AG28-AG29","v":"0"},{"$f":"AH26-AH27-AH28-AH29","v":"13538.05"},{"$f":"AI26-AI27-AI28-AI29","v":"234686.76"},{"$f":"AJ26-AJ27-AJ28-AJ29","v":"296131.97"},{"$f":"AK26-AK27-AK28-AK29","v":"0"},{"$f":"AL26-AL27-AL28-AL29","v":"216279.94"},{"$f":"AM26-AM27-AM28-AM29","v":"0"},{"$f":"AN26-AN27-AN28-AN29","v":"6643.12"},{"$f":"AO26-AO27-AO28-AO29","v":"81829.52"},{"$f":"AP26-AP27-AP28-AP29","v":"37950"},{"$f":"AQ26-AQ27-AQ28-AQ29","v":"3259.73"},{"$f":"AR26-AR27-AR28-AR29","v":"1507.82"},{"$f":"AS26-AS27-AS28-AS29","v":"0"},{"$f":"AT26-AT27-AT28-AT29","v":"417.54"},{"$f":"AU26-AU27-AU28-AU29","v":"762.3"},{"$f":"AV26-AV27-AV28-AV29","v":"10324.69"},{"$f":"AW26-AW27-AW28-AW29","v":"27672.62"},{"$f":"AX26-AX27-AX28-AX29","v":"102.73"},{"$f":"AY26-AY27-AY28-AY29","v":"3536.01"}]
[{"$f":"'Wksh 1 - Market Experience'!E17","v":0},"2.9","Risk Adjustment Transfer Amount",{"$f":"SUM(E33:AY33)","v":"-$1,659,162"},0.0,0.0,-532765.91,-24474.49,-31677.2,-79190.35,-56219.06,-117594.25,-18836.34,-11275.94,-18645.08,-37649.18,-70872.35,-86015.61,0.0,-13500.43,-46947.97,-52430.8,-49450.35,0.0,-92379.36,0.0,0.0,0.0,0.0,0.0,-55481.9,-1650.71,0.0,-6442.7,-19503.82,-96504.98,0.0,-40460.69,0.0,-5754.8,-48267.1,-12723.97,-7370.61,-4601.81,0.0,-245.75,-681.65,-6506.08,-9844.87,-393.06,-2803.32]
[{"$f":"'Wksh 1 - Market Experience'!E18","v":0},"2.10","Premium",{"$f":"SUM(E34:AY34)","v":"$11,988,168"},0.0,0.0,3849464.64,176838.77,228881.5,572184.64,406207.1,849669.42,136100.75,81473.52,134718.76,272031.64,512083.45,621500.08,0.0,97546.46,339219.42,378835.27,357300.23,0.0,667480.89,0.0,0.0,0.0,0.0,0.0,400880.8,11927.12,0.0,46551.28,140923.57,697290.33,0.0,292346.02,0.0,41580.93,348750.72,91936.22,53255.82,33250.08,0.0,1775.66,4925.24,47009.28,71133.48,2840.06,20255.23]
[{"$f":"'Wksh 1 - Market Experience'!E19","v":{"$error":"#REF!"}},"2.11","Experience Period Member Months",{"$f":"SUM(E35:AY35)","v":"12327"},0.0,0.0,3737.0,170.0,227.0,617.0,440.0,814.0,188.0,137.0,184.0,242.0,453.0,589.0,0.0,86.0,383.0,369.0,326.0,0.0,811.0,0.0,0.0,0.0,0.0,0.0,392.0,8.0,0.0,48.0,102.0,806.0,0.0,308.0,0.0,73.0,421.0,112.0,60.0,56.0,0.0,2.0,4.0,60.0,66.0,4.0,32.0]
[null,"2.12","Current Enrollment",{"$f":"SUM(E36:AY36)","v":"924"},0.0,0.0,275.0,11.0,17.0,42.0,38.0,68.0,16.0,5.0,16.0,14.0,33.0,61.0,0.0,8.0,21.0,35.0,26.0,0.0,58.0,0.0,0.0,0.0,0.0,0.0,28.0,1.0,0.0,3.0,7.0,59.0,0.0,30.0,0.0,0.0,30.0,10.0,3.0,4.0,0.0,0.0,0.0,5.0,0.0,0.0,0.0]
[null,"2.13","Current Premium PMPM",{"$f":"IF(OR(D36=0,D36=\"\"), 0, SUMPRODUCT(E37:AY37,E36:AY36)/D36)","v":"$1,014.54"},0.0,0.0,1072.61854545455,1158.69181818182,1058.85647058824,983.481428571429,908.896052631579,1105.42367647059,760.665,648.754,730.69,1289.94,1262.47060606061,932.782786885246,0.0,1252.04125,1000.58857142857,1037.21285714286,1121.48230769231,0.0,824.073793103448,0.0,0.0,0.0,0.0,0.0,919.155357142857,1490.89,0.0,1211.43,1497.59857142857,952.116440677966,0.0,1109.06833333333,0.0,0.0,851.428333333333,679.456,992.916666666667,666.795,0.0,0.0,0.0,783.488,0.0,0.0,0.0]
[null,"2.14","Loss Ratio",{"$f":"IF(OR(D33+D34=0,D33+D34=\"\"), 0, D32/(D33+D34))","v":"73.34%"},0.0,0.0,0.685561802593991,0.602143560157276,0.870725080538305,0.593431660232819,3.02784240855773,0.797392800523477,0.648598411060952,0.0972942372087471,0.536573924424555,0.488199159612882,0.54561972715555,1.70776291607486,0.0,0.845844711522959,0.374324758713176,0.296796364339006,0.337029658741462,0.0,0.262492867998456,0.0,0.0,0.0,0.0,0.0,0.592407677036609,1.49777792049947,0.0,0.337535011212065,1.93285491034202,0.492908107696035,0.0,0.858644447455515,0.0,0.18542667042184,0.272326058904642,0.479092564597016,0.0710409737691077,0.0526321484683019,0.0,0.272918014785183,0.179635638692711,0.254910476209287,0.451513258336255,0.0419820187985288,0.202614498928771]
[null,null,"Per Member Per Month"]
[null,"2.15","Allowed Claims",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D26/D35)","v":"$752.65"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E26/E35)","v":"0"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F26/F35)","v":"0"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G26/G35)","v":"763.2296"},{"$f":"IF(OR(H35=0,H35=\"\"), 0, H26/H35)","v":"807.7995"},{"$f":"IF(OR(I35=0,I35=\"\"), 0, I26/I35)","v":"968.1805"},{"$f":"IF(OR(J35=0,J35=\"\"), 0, J26/J35)","v":"598.0782"},{"$f":"IF(OR(K35=0,K35=\"\"), 0, K26/K35)","v":"2582.1403"},{"$f":"IF(OR(L35=0,L35=\"\"), 0, L26/L35)","v":"872.6678"},{"$f":"IF(OR(M35=0,M35=\"\"), 0, M26/M35)","v":"565.696"},{"$f":"IF(OR(N35=0,N35=\"\"), 0, N26/N35)","v":"130.7768"},{"$f":"IF(OR(O35=0,O35=\"\"), 0, O26/O35)","v":"471.0476"},{"$f":"IF(OR(P35=0,P35=\"\"), 0, P26/P35)","v":"679.4404"},{"$f":"IF(OR(Q35=0,Q35=\"\"), 0, Q26/Q35)","v":"594.4596"},{"$f":"IF(OR(R35=0,R35=\"\"), 0, R26/R35)","v":"1618.0779"},{"$f":"IF(OR(S35=0,S35=\"\"), 0, S26/S35)","v":"0"},{"$f":"IF(OR(T35=0,T35=\"\"), 0, T26/T35)","v":"1096.1126"},{"$f":"IF(OR(U35=0,U35=\"\"), 0, U26/U35)","v":"374.147"},{"$f":"IF(OR(V35=0,V35=\"\"), 0, V26/V35)","v":"407.2563"},{"$f":"IF(OR(W35=0,W35=\"\"), 0, W26/W35)","v":"426.4593"},{"$f":"IF(OR(X35=0,X35=\"\"), 0, X26/X35)","v":"0"},{"$f":"IF(OR(Y35=0,Y35=\"\"), 0, Y26/Y35)","v":"325.1875"},{"$f":"IF(OR(Z35=0,Z35=\"\"), 0, Z26/Z35)","v":"0"},{"$f":"IF(OR(AA35=0,AA35=\"\"), 0, AA26/AA35)","v":"0"},{"$f":"IF(OR(AB35=0,AB35=\"\"), 0, AB26/AB35)","v":"0"},{"$f":"IF(OR(AC35=0,AC35=\"\"), 0, AC26/AC35)","v":"0"},{"$f":"IF(OR(AD35=0,AD35=\"\"), 0, AD26/AD35)","v":"0"},{"$f":"IF(OR(AE35=0,AE35=\"\"), 0, AE26/AE35)","v":"578.9829"},{"$f":"IF(OR(AF35=0,AF35=\"\"), 0, AF26/AF35)","v":"2115.185"},{"$f":"IF(OR(AG35=0,AG35=\"\"), 0, AG26/AG35)","v":"0"},{"$f":"IF(OR(AH35=0,AH35=\"\"), 0, AH26/AH35)","v":"363.3429"},{"$f":"IF(OR(AI35=0,AI35=\"\"), 0, AI26/AI35)","v":"2362.4236"},{"$f":"IF(OR(AJ35=0,AJ35=\"\"), 0, AJ26/AJ35)","v":"500.4087"},{"$f":"IF(OR(AK35=0,AK35=\"\"), 0, AK26/AK35)","v":"0"},{"$f":"IF(OR(AL35=0,AL35=\"\"), 0, AL26/AL35)","v":"868.0099"},{"$f":"IF(OR(AM35=0,AM35=\"\"), 0, AM26/AM35)","v":"0"},{"$f":"IF(OR(AN35=0,AN35=\"\"), 0, AN26/AN35)","v":"186.7674"},{"$f":"IF(OR(AO35=0,AO35=\"\"), 0, AO26/AO35)","v":"341.3"},{"$f":"IF(OR(AP35=0,AP35=\"\"), 0, AP26/AP35)","v":"409.7112"},{"$f":"IF(OR(AQ35=0,AQ35=\"\"), 0, AQ26/AQ35)","v":"214.1657"},{"$f":"IF(OR(AR35=0,AR35=\"\"), 0, AR26/AR35)","v":"88.5675"},{"$f":"IF(OR(AS35=0,AS35=\"\"), 0, AS26/AS35)","v":"0"},{"$f":"IF(OR(AT35=0,AT35=\"\"), 0, AT26/AT35)","v":"261.375"},{"$f":"IF(OR(AU35=0,AU35=\"\"), 0, AU26/AU35)","v":"312.3075"},{"$f":"IF(OR(AV35=0,AV35=\"\"), 0, AV26/AV35)","v":"355.7327"},{"$f":"IF(OR(AW35=0,AW35=\"\"), 0, AW26/AW35)","v":"604.303"},{"$f":"IF(OR(AX35=0,AX35=\"\"), 0, AX26/AX35)","v":"42.9775"},{"$f":"IF(OR(AY35=0,AY35=\"\"), 0, AY26/AY35)","v":"241.2206"}]
[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"},{"$f":"IF(OR(H35=0,H35=\"\"), 0, H27/H35)","v":"0"},{"$f":"IF(OR(I35=0,I35=\"\"), 0, I27/I35)","v":"0"},{"$f":"IF(OR(J35=0,J35=\"\"), 0, J27/J35)","v":"0"},{"$f":"IF(OR(K35=0,K35=\"\"), 0, K27/K35)","v":"0"},{"$f":"IF(OR(L35=0,L35=\"\"), 0, L27/L35)","v":"0"},{"$f":"IF(OR(M35=0,M35=\"\"), 0, M27/M35)","v":"0"},{"$f":"IF(OR(N35=0,N35=\"\"), 0, N27/N35)","v":"0"},{"$f":"IF(OR(O35=0,O35=\"\"), 0, O27/O35)","v":"0"},{"$f":"IF(OR(P35=0,P35=\"\"), 0, P27/P35)","v":"0"},{"$f":"IF(OR(Q35=0,Q35=\"\"), 0, Q27/Q35)","v":"0"},{"$f":"IF(OR(R35=0,R35=\"\"), 0, R27/R35)","v":"0"},{"$f":"IF(OR(S35=0,S35=\"\"), 0, S27/S35)","v":"0"},{"$f":"IF(OR(T35=0,T35=\"\"), 0, T27/T35)","v":"0"},{"$f":"IF(OR(U35=0,U35=\"\"), 0, U27/U35)","v":"0"},{"$f":"IF(OR(V35=0,V35=\"\"), 0, V27/V35)","v":"0"},{"$f":"IF(OR(W35=0,W35=\"\"), 0, W27/W35)","v":"0"},{"$f":"IF(OR(X35=0,X35=\"\"), 0, X27/X35)","v":"0"},{"$f":"IF(OR(Y35=0,Y35=\"\"), 0, Y27/Y35)","v":"0"},{"$f":"IF(OR(Z35=0,Z35=\"\"), 0, Z27/Z35)","v":"0"},{"$f":"IF(OR(AA35=0,AA35=\"\"), 0, AA27/AA35)","v":"0"},{"$f":"IF(OR(AB35=0,AB35=\"\"), 0, AB27/AB35)","v":"0"},{"$f":"IF(OR(AC35=0,AC35=\"\"), 0, AC27/AC35)","v":"0"},{"$f":"IF(OR(AD35=0,AD35=\"\"), 0, AD27/AD35)","v":"0"},{"$f":"IF(OR(AE35=0,AE35=\"\"), 0, AE27/AE35)","v":"0"},{"$f":"IF(OR(AF35=0,AF35=\"\"), 0, AF27/AF35)","v":"0"},{"$f":"IF(OR(AG35=0,AG35=\"\"), 0, AG27/AG35)","v":"0"},{"$f":"IF(OR(AH35=0,AH35=\"\"), 0, AH27/AH35)","v":"0"},{"$f":"IF(OR(AI35=0,AI35=\"\"), 0, AI27/AI35)","v":"0"},{"$f":"IF(OR(AJ35=0,AJ35=\"\"), 0, AJ27/AJ35)","v":"0"},{"$f":"IF(OR(AK35=0,AK35=\"\"), 0, AK27/AK35)","v":"0"},{"$f":"IF(OR(AL35=0,AL35=\"\"), 0, AL27/AL35)","v":"0"},{"$f":"IF(OR(AM35=0,AM35=\"\"), 0, AM27/AM35)","v":"0"},{"$f":"IF(OR(AN35=0,AN35=\"\"), 0, AN27/AN35)","v":"0"},{"$f":"IF(OR(AO35=0,AO35=\"\"), 0, AO27/AO35)","v":"0"},{"$f":"IF(OR(AP35=0,AP35=\"\"), 0, AP27/AP35)","v":"0"},{"$f":"IF(OR(AQ35=0,AQ35=\"\"), 0, AQ27/AQ35)","v":"0"},{"$f":"IF(OR(AR35=0,AR35=\"\"), 0, AR27/AR35)","v":"0"},{"$f":"IF(OR(AS35=0,AS35=\"\"), 0, AS27/AS35)","v":"0"},{"$f":"IF(OR(AT35=0,AT35=\"\"), 0, AT27/AT35)","v":"0"},{"$f":"IF(OR(AU35=0,AU35=\"\"), 0, AU27/AU35)","v":"0"},{"$f":"IF(OR(AV35=0,AV35=\"\"), 0, AV27/AV35)","v":"0"},{"$f":"IF(OR(AW35=0,AW35=\"\"), 0, AW27/AW35)","v":"0"},{"$f":"IF(OR(AX35=0,AX35=\"\"), 0, AX27/AX35)","v":"0"},{"$f":"IF(OR(AY35=0,AY35=\"\"), 0, AY27/AY35)","v":"0"}]
[null,"2.17","Member Cost Sharing",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D28/D35)","v":"$138.16"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E28/E35)","v":"0"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F28/F35)","v":"0"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G28/G35)","v":"154.7731"},{"$f":"IF(OR(H35=0,H35=\"\"), 0, H28/H35)","v":"268.122"},{"$f":"IF(OR(I35=0,I35=\"\"), 0, I28/I35)","v":"211.7456"},{"$f":"IF(OR(J35=0,J35=\"\"), 0, J28/J35)","v":"123.9155"},{"$f":"IF(OR(K35=0,K35=\"\"), 0, K28/K35)","v":"173.7116"},{"$f":"IF(OR(L35=0,L35=\"\"), 0, L28/L35)","v":"155.5284"},{"$f":"IF(OR(M35=0,M35=\"\"), 0, M28/M35)","v":"161.1348"},{"$f":"IF(OR(N35=0,N35=\"\"), 0, N28/N35)","v":"80.9241"},{"$f":"IF(OR(O35=0,O35=\"\"), 0, O28/O35)","v":"132.5578"},{"$f":"IF(OR(P35=0,P35=\"\"), 0, P28/P35)","v":"206.6085"},{"$f":"IF(OR(Q35=0,Q35=\"\"), 0, Q28/Q35)","v":"63.0392"},{"$f":"IF(OR(R35=0,R35=\"\"), 0, R28/R35)","v":"65.4794"},{"$f":"IF(OR(S35=0,S35=\"\"), 0, S28/S35)","v":"0"},{"$f":"IF(OR(T35=0,T35=\"\"), 0, T28/T35)","v":"269.4859"},{"$f":"IF(OR(U35=0,U35=\"\"), 0, U28/U35)","v":"88.4957"},{"$f":"IF(OR(V35=0,V35=\"\"), 0, V28/V35)","v":"144.7207"},{"$f":"IF(OR(W35=0,W35=\"\"), 0, W28/W35)","v":"108.1938"},{"$f":"IF(OR(X35=0,X35=\"\"), 0, X28/X35)","v":"0"},{"$f":"IF(OR(Y35=0,Y35=\"\"), 0, Y28/Y35)","v":"139.0469"},{"$f":"IF(OR(Z35=0,Z35=\"\"), 0, Z28/Z35)","v":"0"},{"$f":"IF(OR(AA35=0,AA35=\"\"), 0, AA28/AA35)","v":"0"},{"$f":"IF(OR(AB35=0,AB35=\"\"), 0, AB28/AB35)","v":"0"},{"$f":"IF(OR(AC35=0,AC35=\"\"), 0, AC28/AC35)","v":"0"},{"$f":"IF(OR(AD35=0,AD35=\"\"), 0, AD28/AD35)","v":"0"},{"$f":"IF(OR(AE35=0,AE35=\"\"), 0, AE28/AE35)","v":"57.0008"},{"$f":"IF(OR(AF35=0,AF35=\"\"), 0, AF28/AF35)","v":"191.2125"},{"$f":"IF(OR(AG35=0,AG35=\"\"), 0, AG28/AG35)","v":"0"},{"$f":"IF(OR(AH35=0,AH35=\"\"), 0, AH28/AH35)","v":"81.3002"},{"$f":"IF(OR(AI35=0,AI35=\"\"), 0, AI28/AI35)","v":"61.573"},{"$f":"IF(OR(AJ35=0,AJ35=\"\"), 0, AJ28/AJ35)","v":"132.9993"},{"$f":"IF(OR(AK35=0,AK35=\"\"), 0, AK28/AK35)","v":"0"},{"$f":"IF(OR(AL35=0,AL35=\"\"), 0, AL28/AL35)","v":"165.8023"},{"$f":"IF(OR(AM35=0,AM35=\"\"), 0, AM28/AM35)","v":"0"},{"$f":"IF(OR(AN35=0,AN35=\"\"), 0, AN28/AN35)","v":"95.7658"},{"$f":"IF(OR(AO35=0,AO35=\"\"), 0, AO28/AO35)","v":"146.9305"},{"$f":"IF(OR(AP35=0,AP35=\"\"), 0, AP28/AP35)","v":"70.8719"},{"$f":"IF(OR(AQ35=0,AQ35=\"\"), 0, AQ28/AQ35)","v":"159.8368"},{"$f":"IF(OR(AR35=0,AR35=\"\"), 0, AR28/AR35)","v":"61.6421"},{"$f":"IF(OR(AS35=0,AS35=\"\"), 0, AS28/AS35)","v":"0"},{"$f":"IF(OR(AT35=0,AT35=\"\"), 0, AT28/AT35)","v":"52.605"},{"$f":"IF(OR(AU35=0,AU35=\"\"), 0, AU28/AU35)","v":"121.7325"},{"$f":"IF(OR(AV35=0,AV35=\"\"), 0, AV28/AV35)","v":"183.6545"},{"$f":"IF(OR(AW35=0,AW35=\"\"), 0, AW28/AW35)","v":"185.0209"},{"$f":"IF(OR(AX35=0,AX35=\"\"), 0, AX28/AX35)","v":"17.295"},{"$f":"IF(OR(AY35=0,AY35=\"\"), 0, AY28/AY35)","v":"130.7203"}]
[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"},{"$f":"IF(OR(H35=0,H35=\"\"), 0, H29/H35)","v":"0"},{"$f":"IF(OR(I35=0,I35=\"\"), 0, I29/I35)","v":"0"},{"$f":"IF(OR(J35=0,J35=\"\"), 0, J29/J35)","v":"0"},{"$f":"IF(OR(K35=0,K35=\"\"), 0, K29/K35)","v":"0"},{"$f":"IF(OR(L35=0,L35=\"\"), 0, L29/L35)","v":"0"},{"$f":"IF(OR(M35=0,M35=\"\"), 0, M29/M35)","v":"0"},{"$f":"IF(OR(N35=0,N35=\"\"), 0, N29/N35)","v":"0"},{"$f":"IF(OR(O35=0,O35=\"\"), 0, O29/O35)","v":"0"},{"$f":"IF(OR(P35=0,P35=\"\"), 0, P29/P35)","v":"0"},{"$f":"IF(OR(Q35=0,Q35=\"\"), 0, Q29/Q35)","v":"0"},{"$f":"IF(OR(R35=0,R35=\"\"), 0, R29/R35)","v":"0"},{"$f":"IF(OR(S35=0,S35=\"\"), 0, S29/S35)","v":"0"},{"$f":"IF(OR(T35=0,T35=\"\"), 0, T29/T35)","v":"0"},{"$f":"IF(OR(U35=0,U35=\"\"), 0, U29/U35)","v":"0"},{"$f":"IF(OR(V35=0,V35=\"\"), 0, V29/V35)","v":"0"},{"$f":"IF(OR(W35=0,W35=\"\"), 0, W29/W35)","v":"0"},{"$f":"IF(OR(X35=0,X35=\"\"), 0, X29/X35)","v":"0"},{"$f":"IF(OR(Y35=0,Y35=\"\"), 0, Y29/Y35)","v":"0"},{"$f":"IF(OR(Z35=0,Z35=\"\"), 0, Z29/Z35)","v":"0"},{"$f":"IF(OR(AA35=0,AA35=\"\"), 0, AA29/AA35)","v":"0"},{"$f":"IF(OR(AB35=0,AB35=\"\"), 0, AB29/AB35)","v":"0"},{"$f":"IF(OR(AC35=0,AC35=\"\"), 0, AC29/AC35)","v":"0"},{"$f":"IF(OR(AD35=0,AD35=\"\"), 0, AD29/AD35)","v":"0"},{"$f":"IF(OR(AE35=0,AE35=\"\"), 0, AE29/AE35)","v":"0"},{"$f":"IF(OR(AF35=0,AF35=\"\"), 0, AF29/AF35)","v":"0"},{"$f":"IF(OR(AG35=0,AG35=\"\"), 0, AG29/AG35)","v":"0"},{"$f":"IF(OR(AH35=0,AH35=\"\"), 0, AH29/AH35)","v":"0"},{"$f":"IF(OR(AI35=0,AI35=\"\"), 0, AI29/AI35)","v":"0"},{"$f":"IF(OR(AJ35=0,AJ35=\"\"), 0, AJ29/AJ35)","v":"0"},{"$f":"IF(OR(AK35=0,AK35=\"\"), 0, AK29/AK35)","v":"0"},{"$f":"IF(OR(AL35=0,AL35=\"\"), 0, AL29/AL35)","v":"0"},{"$f":"IF(OR(AM35=0,AM35=\"\"), 0, AM29/AM35)","v":"0"},{"$f":"IF(OR(AN35=0,AN35=\"\"), 0, AN29/AN35)","v":"0"},{"$f":"IF(OR(AO35=0,AO35=\"\"), 0, AO29/AO35)","v":"0"},{"$f":"IF(OR(AP35=0,AP35=\"\"), 0, AP29/AP35)","v":"0"},{"$f":"IF(OR(AQ35=0,AQ35=\"\"), 0, AQ29/AQ35)","v":"0"},{"$f":"IF(OR(AR35=0,AR35=\"\"), 0, AR29/AR35)","v":"0"},{"$f":"IF(OR(AS35=0,AS35=\"\"), 0, AS29/AS35)","v":"0"},{"$f":"IF(OR(AT35=0,AT35=\"\"), 0, AT29/AT35)","v":"0"},{"$f":"IF(OR(AU35=0,AU35=\"\"), 0, AU29/AU35)","v":"0"},{"$f":"IF(OR(AV35=0,AV35=\"\"), 0, AV29/AV35)","v":"0"},{"$f":"IF(OR(AW35=0,AW35=\"\"), 0, AW29/AW35)","v":"0"},{"$f":"IF(OR(AX35=0,AX35=\"\"), 0, AX29/AX35)","v":"0"},{"$f":"IF(OR(AY35=0,AY35=\"\"), 0, AY29/AY35)","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"},{"$f":"IF(OR(H35=0,H35=\"\"), 0, H30/H35)","v":"0"},{"$f":"IF(OR(I35=0,I35=\"\"), 0, I30/I35)","v":"0"},{"$f":"IF(OR(J35=0,J35=\"\"), 0, J30/J35)","v":"0"},{"$f":"IF(OR(K35=0,K35=\"\"), 0, K30/K35)","v":"0"},{"$f":"IF(OR(L35=0,L35=\"\"), 0, L30/L35)","v":"0"},{"$f":"IF(OR(M35=0,M35=\"\"), 0, M30/M35)","v":"0"},{"$f":"IF(OR(N35=0,N35=\"\"), 0, N30/N35)","v":"0"},{"$f":"IF(OR(O35=0,O35=\"\"), 0, O30/O35)","v":"0"},{"$f":"IF(OR(P35=0,P35=\"\"), 0, P30/P35)","v":"0"},{"$f":"IF(OR(Q35=0,Q35=\"\"), 0, Q30/Q35)","v":"0"},{"$f":"IF(OR(R35=0,R35=\"\"), 0, R30/R35)","v":"0"},{"$f":"IF(OR(S35=0,S35=\"\"), 0, S30/S35)","v":"0"},{"$f":"IF(OR(T35=0,T35=\"\"), 0, T30/T35)","v":"0"},{"$f":"IF(OR(U35=0,U35=\"\"), 0, U30/U35)","v":"0"},{"$f":"IF(OR(V35=0,V35=\"\"), 0, V30/V35)","v":"0"},{"$f":"IF(OR(W35=0,W35=\"\"), 0, W30/W35)","v":"0"},{"$f":"IF(OR(X35=0,X35=\"\"), 0, X30/X35)","v":"0"},{"$f":"IF(OR(Y35=0,Y35=\"\"), 0, Y30/Y35)","v":"0"},{"$f":"IF(OR(Z35=0,Z35=\"\"), 0, Z30/Z35)","v":"0"},{"$f":"IF(OR(AA35=0,AA35=\"\"), 0, AA30/AA35)","v":"0"},{"$f":"IF(OR(AB35=0,AB35=\"\"), 0, AB30/AB35)","v":"0"},{"$f":"IF(OR(AC35=0,AC35=\"\"), 0, AC30/AC35)","v":"0"},{"$f":"IF(OR(AD35=0,AD35=\"\"), 0, AD30/AD35)","v":"0"},{"$f":"IF(OR(AE35=0,AE35=\"\"), 0, AE30/AE35)","v":"0"},{"$f":"IF(OR(AF35=0,AF35=\"\"), 0, AF30/AF35)","v":"0"},{"$f":"IF(OR(AG35=0,AG35=\"\"), 0, AG30/AG35)","v":"0"},{"$f":"IF(OR(AH35=0,AH35=\"\"), 0, AH30/AH35)","v":"0"},{"$f":"IF(OR(AI35=0,AI35=\"\"), 0, AI30/AI35)","v":"0"},{"$f":"IF(OR(AJ35=0,AJ35=\"\"), 0, AJ30/AJ35)","v":"0"},{"$f":"IF(OR(AK35=0,AK35=\"\"), 0, AK30/AK35)","v":"0"},{"$f":"IF(OR(AL35=0,AL35=\"\"), 0, AL30/AL35)","v":"0"},{"$f":"IF(OR(AM35=0,AM35=\"\"), 0, AM30/AM35)","v":"0"},{"$f":"IF(OR(AN35=0,AN35=\"\"), 0, AN30/AN35)","v":"0"},{"$f":"IF(OR(AO35=0,AO35=\"\"), 0, AO30/AO35)","v":"0"},{"$f":"IF(OR(AP35=0,AP35=\"\"), 0, AP30/AP35)","v":"0"},{"$f":"IF(OR(AQ35=0,AQ35=\"\"), 0, AQ30/AQ35)","v":"0"},{"$f":"IF(OR(AR35=0,AR35=\"\"), 0, AR30/AR35)","v":"0"},{"$f":"IF(OR(AS35=0,AS35=\"\"), 0, AS30/AS35)","v":"0"},{"$f":"IF(OR(AT35=0,AT35=\"\"), 0, AT30/AT35)","v":"0"},{"$f":"IF(OR(AU35=0,AU35=\"\"), 0, AU30/AU35)","v":"0"},{"$f":"IF(OR(AV35=0,AV35=\"\"), 0, AV30/AV35)","v":"0"},{"$f":"IF(OR(AW35=0,AW35=\"\"), 0, AW30/AW35)","v":"0"},{"$f":"IF(OR(AX35=0,AX35=\"\"), 0, AX30/AX35)","v":"0"},{"$f":"IF(OR(AY35=0,AY35=\"\"), 0, AY30/AY35)","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"},{"$f":"IF(OR(H35=0,H35=\"\"), 0, H31/H35)","v":"0"},{"$f":"IF(OR(I35=0,I35=\"\"), 0, I31/I35)","v":"0"},{"$f":"IF(OR(J35=0,J35=\"\"), 0, J31/J35)","v":"0"},{"$f":"IF(OR(K35=0,K35=\"\"), 0, K31/K35)","v":"0"},{"$f":"IF(OR(L35=0,L35=\"\"), 0, L31/L35)","v":"0"},{"$f":"IF(OR(M35=0,M35=\"\"), 0, M31/M35)","v":"0"},{"$f":"IF(OR(N35=0,N35=\"\"), 0, N31/N35)","v":"0"},{"$f":"IF(OR(O35=0,O35=\"\"), 0, O31/O35)","v":"0"},{"$f":"IF(OR(P35=0,P35=\"\"), 0, P31/P35)","v":"0"},{"$f":"IF(OR(Q35=0,Q35=\"\"), 0, Q31/Q35)","v":"0"},{"$f":"IF(OR(R35=0,R35=\"\"), 0, R31/R35)","v":"0"},{"$f":"IF(OR(S35=0,S35=\"\"), 0, S31/S35)","v":"0"},{"$f":"IF(OR(T35=0,T35=\"\"), 0, T31/T35)","v":"0"},{"$f":"IF(OR(U35=0,U35=\"\"), 0, U31/U35)","v":"0"},{"$f":"IF(OR(V35=0,V35=\"\"), 0, V31/V35)","v":"0"},{"$f":"IF(OR(W35=0,W35=\"\"), 0, W31/W35)","v":"0"},{"$f":"IF(OR(X35=0,X35=\"\"), 0, X31/X35)","v":"0"},{"$f":"IF(OR(Y35=0,Y35=\"\"), 0, Y31/Y35)","v":"0"},{"$f":"IF(OR(Z35=0,Z35=\"\"), 0, Z31/Z35)","v":"0"},{"$f":"IF(OR(AA35=0,AA35=\"\"), 0, AA31/AA35)","v":"0"},{"$f":"IF(OR(AB35=0,AB35=\"\"), 0, AB31/AB35)","v":"0"},{"$f":"IF(OR(AC35=0,AC35=\"\"), 0, AC31/AC35)","v":"0"},{"$f":"IF(OR(AD35=0,AD35=\"\"), 0, AD31/AD35)","v":"0"},{"$f":"IF(OR(AE35=0,AE35=\"\"), 0, AE31/AE35)","v":"0"},{"$f":"IF(OR(AF35=0,AF35=\"\"), 0, AF31/AF35)","v":"0"},{"$f":"IF(OR(AG35=0,AG35=\"\"), 0, AG31/AG35)","v":"0"},{"$f":"IF(OR(AH35=0,AH35=\"\"), 0, AH31/AH35)","v":"0"},{"$f":"IF(OR(AI35=0,AI35=\"\"), 0, AI31/AI35)","v":"0"},{"$f":"IF(OR(AJ35=0,AJ35=\"\"), 0, AJ31/AJ35)","v":"0"},{"$f":"IF(OR(AK35=0,AK35=\"\"), 0, AK31/AK35)","v":"0"},{"$f":"IF(OR(AL35=0,AL35=\"\"), 0, AL31/AL35)","v":"0"},{"$f":"IF(OR(AM35=0,AM35=\"\"), 0, AM31/AM35)","v":"0"},{"$f":"IF(OR(AN35=0,AN35=\"\"), 0, AN31/AN35)","v":"0"},{"$f":"IF(OR(AO35=0,AO35=\"\"), 0, AO31/AO35)","v":"0"},{"$f":"IF(OR(AP35=0,AP35=\"\"), 0, AP31/AP35)","v":"0"},{"$f":"IF(OR(AQ35=0,AQ35=\"\"), 0, AQ31/AQ35)","v":"0"},{"$f":"IF(OR(AR35=0,AR35=\"\"), 0, AR31/AR35)","v":"0"},{"$f":"IF(OR(AS35=0,AS35=\"\"), 0, AS31/AS35)","v":"0"},{"$f":"IF(OR(AT35=0,AT35=\"\"), 0, AT31/AT35)","v":"0"},{"$f":"IF(OR(AU35=0,AU35=\"\"), 0, AU31/AU35)","v":"0"},{"$f":"IF(OR(AV35=0,AV35=\"\"), 0, AV31/AV35)","v":"0"},{"$f":"IF(OR(AW35=0,AW35=\"\"), 0, AW31/AW35)","v":"0"},{"$f":"IF(OR(AX35=0,AX35=\"\"), 0, AX31/AX35)","v":"0"},{"$f":"IF(OR(AY35=0,AY35=\"\"), 0, AY31/AY35)","v":"0"}]
[null,"2.21","Incurred Claims",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D32/D35)","v":"$614.49"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E32/E35)","v":"0"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F32/F35)","v":"0"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G32/G35)","v":"608.4565"},{"$f":"IF(OR(H35=0,H35=\"\"), 0, H32/H35)","v":"539.6775"},{"$f":"IF(OR(I35=0,I35=\"\"), 0, I32/I35)","v":"756.4349"},{"$f":"IF(OR(J35=0,J35=\"\"), 0, J32/J35)","v":"474.1628"},{"$f":"IF(OR(K35=0,K35=\"\"), 0, K32/K35)","v":"2408.4287"},{"$f":"IF(OR(L35=0,L35=\"\"), 0, L32/L35)","v":"717.1394"},{"$f":"IF(OR(M35=0,M35=\"\"), 0, M32/M35)","v":"404.5612"},{"$f":"IF(OR(N35=0,N35=\"\"), 0, N32/N35)","v":"49.8527"},{"$f":"IF(OR(O35=0,O35=\"\"), 0, O32/O35)","v":"338.4897"},{"$f":"IF(OR(P35=0,P35=\"\"), 0, P32/P35)","v":"472.8319"},{"$f":"IF(OR(Q35=0,Q35=\"\"), 0, Q32/Q35)","v":"531.4205"},{"$f":"IF(OR(R35=0,R35=\"\"), 0, R32/R35)","v":"1552.5985"},{"$f":"IF(OR(S35=0,S35=\"\"), 0, S32/S35)","v":"0"},{"$f":"IF(OR(T35=0,T35=\"\"), 0, T32/T35)","v":"826.6266"},{"$f":"IF(OR(U35=0,U35=\"\"), 0, U32/U35)","v":"285.6513"},{"$f":"IF(OR(V35=0,V35=\"\"), 0, V32/V35)","v":"262.5357"},{"$f":"IF(OR(W35=0,W35=\"\"), 0, W32/W35)","v":"318.2655"},{"$f":"IF(OR(X35=0,X35=\"\"), 0, X32/X35)","v":"0"},{"$f":"IF(OR(Y35=0,Y35=\"\"), 0, Y32/Y35)","v":"186.1406"},{"$f":"IF(OR(Z35=0,Z35=\"\"), 0, Z32/Z35)","v":"0"},{"$f":"IF(OR(AA35=0,AA35=\"\"), 0, AA32/AA35)","v":"0"},{"$f":"IF(OR(AB35=0,AB35=\"\"), 0, AB32/AB35)","v":"0"},{"$f":"IF(OR(AC35=0,AC35=\"\"), 0, AC32/AC35)","v":"0"},{"$f":"IF(OR(AD35=0,AD35=\"\"), 0, AD32/AD35)","v":"0"},{"$f":"IF(OR(AE35=0,AE35=\"\"), 0, AE32/AE35)","v":"521.982"},{"$f":"IF(OR(AF35=0,AF35=\"\"), 0, AF32/AF35)","v":"1923.9725"},{"$f":"IF(OR(AG35=0,AG35=\"\"), 0, AG32/AG35)","v":"0"},{"$f":"IF(OR(AH35=0,AH35=\"\"), 0, AH32/AH35)","v":"282.0427"},{"$f":"IF(OR(AI35=0,AI35=\"\"), 0, AI32/AI35)","v":"2300.8506"},{"$f":"IF(OR(AJ35=0,AJ35=\"\"), 0, AJ32/AJ35)","v":"367.4094"},{"$f":"IF(OR(AK35=0,AK35=\"\"), 0, AK32/AK35)","v":"0"},{"$f":"IF(OR(AL35=0,AL35=\"\"), 0, AL32/AL35)","v":"702.2076"},{"$f":"IF(OR(AM35=0,AM35=\"\"), 0, AM32/AM35)","v":"0"},{"$f":"IF(OR(AN35=0,AN35=\"\"), 0, AN32/AN35)","v":"91.0016"},{"$f":"IF(OR(AO35=0,AO35=\"\"), 0, AO32/AO35)","v":"194.3694"},{"$f":"IF(OR(AP35=0,AP35=\"\"), 0, AP32/AP35)","v":"338.8393"},{"$f":"IF(OR(AQ35=0,AQ35=\"\"), 0, AQ32/AQ35)","v":"54.3288"},{"$f":"IF(OR(AR35=0,AR35=\"\"), 0, AR32/AR35)","v":"26.9254"},{"$f":"IF(OR(AS35=0,AS35=\"\"), 0, AS32/AS35)","v":"0"},{"$f":"IF(OR(AT35=0,AT35=\"\"), 0, AT32/AT35)","v":"208.77"},{"$f":"IF(OR(AU35=0,AU35=\"\"), 0, AU32/AU35)","v":"190.575"},{"$f":"IF(OR(AV35=0,AV35=\"\"), 0, AV32/AV35)","v":"172.0782"},{"$f":"IF(OR(AW35=0,AW35=\"\"), 0, AW32/AW35)","v":"419.2821"},{"$f":"IF(OR(AX35=0,AX35=\"\"), 0, AX32/AX35)","v":"25.6825"},{"$f":"IF(OR(AY35=0,AY35=\"\"), 0, AY32/AY35)","v":"110.5003"}]
[null,"2.22","Risk Adjustment Transfer Amount",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D33/D35)","v":"-$134.60"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E33/E35)","v":"0"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F33/F35)","v":"0"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G33/G35)","v":"-142.5651"},{"$f":"IF(OR(H35=0,H35=\"\"), 0, H33/H35)","v":"-143.9676"},{"$f":"IF(OR(I35=0,I35=\"\"), 0, I33/I35)","v":"-139.5471"},{"$f":"IF(OR(J35=0,J35=\"\"), 0, J33/J35)","v":"-128.3474"},{"$f":"IF(OR(K35=0,K35=\"\"), 0, K33/K35)","v":"-127.7706"},{"$f":"IF(OR(L35=0,L35=\"\"), 0, L33/L35)","v":"-144.4647"},{"$f":"IF(OR(M35=0,M35=\"\"), 0, M33/M35)","v":"-100.1933"},{"$f":"IF(OR(N35=0,N35=\"\"), 0, N33/N35)","v":"-82.3061"},{"$f":"IF(OR(O35=0,O35=\"\"), 0, O33/O35)","v":"-101.332"},{"$f":"IF(OR(P35=0,P35=\"\"), 0, P33/P35)","v":"-155.5751"},{"$f":"IF(OR(Q35=0,Q35=\"\"), 0, Q33/Q35)","v":"-156.4511"},{"$f":"IF(OR(R35=0,R35=\"\"), 0, R33/R35)","v":"-146.0367"},{"$f":"IF(OR(S35=0,S35=\"\"), 0, S33/S35)","v":"0"},{"$f":"IF(OR(T35=0,T35=\"\"), 0, T33/T35)","v":"-156.9817"},{"$f":"IF(OR(U35=0,U35=\"\"), 0, U33/U35)","v":"-122.5796"},{"$f":"IF(OR(V35=0,V35=\"\"), 0, V33/V35)","v":"-142.0889"},{"$f":"IF(OR(W35=0,W35=\"\"), 0, W33/W35)","v":"-151.6882"},{"$f":"IF(OR(X35=0,X35=\"\"), 0, X33/X35)","v":"0"},{"$f":"IF(OR(Y35=0,Y35=\"\"), 0, Y33/Y35)","v":"-113.908"},{"$f":"IF(OR(Z35=0,Z35=\"\"), 0, Z33/Z35)","v":"0"},{"$f":"IF(OR(AA35=0,AA35=\"\"), 0, AA33/AA35)","v":"0"},{"$f":"IF(OR(AB35=0,AB35=\"\"), 0, AB33/AB35)","v":"0"},{"$f":"IF(OR(AC35=0,AC35=\"\"), 0, AC33/AC35)","v":"0"},{"$f":"IF(OR(AD35=0,AD35=\"\"), 0, AD33/AD35)","v":"0"},{"$f":"IF(OR(AE35=0,AE35=\"\"), 0, AE33/AE35)","v":"-141.5355"},{"$f":"IF(OR(AF35=0,AF35=\"\"), 0, AF33/AF35)","v":"-206.3388"},{"$f":"IF(OR(AG35=0,AG35=\"\"), 0, AG33/AG35)","v":"0"},{"$f":"IF(OR(AH35=0,AH35=\"\"), 0, AH33/AH35)","v":"-134.2229"},{"$f":"IF(OR(AI35=0,AI35=\"\"), 0, AI33/AI35)","v":"-191.2139"},{"$f":"IF(OR(AJ35=0,AJ35=\"\"), 0, AJ33/AJ35)","v":"-119.7332"},{"$f":"IF(OR(AK35=0,AK35=\"\"), 0, AK33/AK35)","v":"0"},{"$f":"IF(OR(AL35=0,AL35=\"\"), 0, AL33/AL35)","v":"-131.3659"},{"$f":"IF(OR(AM35=0,AM35=\"\"), 0, AM33/AM35)","v":"0"},{"$f":"IF(OR(AN35=0,AN35=\"\"), 0, AN33/AN35)","v":"-78.8329"},{"$f":"IF(OR(AO35=0,AO35=\"\"), 0, AO33/AO35)","v":"-114.6487"},{"$f":"IF(OR(AP35=0,AP35=\"\"), 0, AP33/AP35)","v":"-113.6069"},{"$f":"IF(OR(AQ35=0,AQ35=\"\"), 0, AQ33/AQ35)","v":"-122.8435"},{"$f":"IF(OR(AR35=0,AR35=\"\"), 0, AR33/AR35)","v":"-82.1752"},{"$f":"IF(OR(AS35=0,AS35=\"\"), 0, AS33/AS35)","v":"0"},{"$f":"IF(OR(AT35=0,AT35=\"\"), 0, AT33/AT35)","v":"-122.875"},{"$f":"IF(OR(AU35=0,AU35=\"\"), 0, AU33/AU35)","v":"-170.4125"},{"$f":"IF(OR(AV35=0,AV35=\"\"), 0, AV33/AV35)","v":"-108.4347"},{"$f":"IF(OR(AW35=0,AW35=\"\"), 0, AW33/AW35)","v":"-149.1647"},{"$f":"IF(OR(AX35=0,AX35=\"\"), 0, AX33/AX35)","v":"-98.265"},{"$f":"IF(OR(AY35=0,AY35=\"\"), 0, AY33/AY35)","v":"-87.6038"}]
[null,"2.23","Premium",{"$f":"IF(OR(D35=0,D35=\"\"), 0, D34/D35)","v":"$972.51"},{"$f":"IF(OR(E35=0,E35=\"\"), 0, E34/E35)","v":"0"},{"$f":"IF(OR(F35=0,F35=\"\"), 0, F34/F35)","v":"0"},{"$f":"IF(OR(G35=0,G35=\"\"), 0, G34/G35)","v":"1030.0949"},{"$f":"IF(OR(H35=0,H35=\"\"), 0, H34/H35)","v":"1040.2281"},{"$f":"IF(OR(I35=0,I35=\"\"), 0, I34/I35)","v":"1008.2885"},{"$f":"IF(OR(J35=0,J35=\"\"), 0, J34/J35)","v":"927.3657"},{"$f":"IF(OR(K35=0,K35=\"\"), 0, K34/K35)","v":"923.198"},{"$f":"IF(OR(L35=0,L35=\"\"), 0, L34/L35)","v":"1043.8199"},{"$f":"IF(OR(M35=0,M35=\"\"), 0, M34/M35)","v":"723.9402"},{"$f":"IF(OR(N35=0,N35=\"\"), 0, N34/N35)","v":"594.6972"},{"$f":"IF(OR(O35=0,O35=\"\"), 0, O34/O35)","v":"732.1672"},{"$f":"IF(OR(P35=0,P35=\"\"), 0, P34/P35)","v":"1124.0977"},{"$f":"IF(OR(Q35=0,Q35=\"\"), 0, Q34/Q35)","v":"1130.427"},{"$f":"IF(OR(R35=0,R35=\"\"), 0, R34/R35)","v":"1055.1784"},{"$f":"IF(OR(S35=0,S35=\"\"), 0, S34/S35)","v":"0"},{"$f":"IF(OR(T35=0,T35=\"\"), 0, T34/T35)","v":"1134.2612"},{"$f":"IF(OR(U35=0,U35=\"\"), 0, U34/U35)","v":"885.6904"},{"$f":"IF(OR(V35=0,V35=\"\"), 0, V34/V35)","v":"1026.6538"},{"$f":"IF(OR(W35=0,W35=\"\"), 0, W34/W35)","v":"1096.013"},{"$f":"IF(OR(X35=0,X35=\"\"), 0, X34/X35)","v":"0"},{"$f":"IF(OR(Y35=0,Y35=\"\"), 0, Y34/Y35)","v":"823.0344"},{"$f":"IF(OR(Z35=0,Z35=\"\"), 0, Z34/Z35)","v":"0"},{"$f":"IF(OR(AA35=0,AA35=\"\"), 0, AA34/AA35)","v":"0"},{"$f":"IF(OR(AB35=0,AB35=\"\"), 0, AB34/AB35)","v":"0"},{"$f":"IF(OR(AC35=0,AC35=\"\"), 0, AC34/AC35)","v":"0"},{"$f":"IF(OR(AD35=0,AD35=\"\"), 0, AD34/AD35)","v":"0"},{"$f":"IF(OR(AE35=0,AE35=\"\"), 0, AE34/AE35)","v":"1022.6551"},{"$f":"IF(OR(AF35=0,AF35=\"\"), 0, AF34/AF35)","v":"1490.89"},{"$f":"IF(OR(AG35=0,AG35=\"\"), 0, AG34/AG35)","v":"0"},{"$f":"IF(OR(AH35=0,AH35=\"\"), 0, AH34/AH35)","v":"969.8183"},{"$f":"IF(OR(AI35=0,AI35=\"\"), 0, AI34/AI35)","v":"1381.6036"},{"$f":"IF(OR(AJ35=0,AJ35=\"\"), 0, AJ34/AJ35)","v":"865.1245"},{"$f":"IF(OR(AK35=0,AK35=\"\"), 0, AK34/AK35)","v":"0"},{"$f":"IF(OR(AL35=0,AL35=\"\"), 0, AL34/AL35)","v":"949.1754"},{"$f":"IF(OR(AM35=0,AM35=\"\"), 0, AM34/AM35)","v":"0"},{"$f":"IF(OR(AN35=0,AN35=\"\"), 0, AN34/AN35)","v":"569.6018"},{"$f":"IF(OR(AO35=0,AO35=\"\"), 0, AO34/AO35)","v":"828.3865"},{"$f":"IF(OR(AP35=0,AP35=\"\"), 0, AP34/AP35)","v":"820.8591"},{"$f":"IF(OR(AQ35=0,AQ35=\"\"), 0, AQ34/AQ35)","v":"887.597"},{"$f":"IF(OR(AR35=0,AR35=\"\"), 0, AR34/AR35)","v":"593.7514"},{"$f":"IF(OR(AS35=0,AS35=\"\"), 0, AS34/AS35)","v":"0"},{"$f":"IF(OR(AT35=0,AT35=\"\"), 0, AT34/AT35)","v":"887.83"},{"$f":"IF(OR(AU35=0,AU35=\"\"), 0, AU34/AU35)","v":"1231.31"},{"$f":"IF(OR(AV35=0,AV35=\"\"), 0, AV34/AV35)","v":"783.488"},{"$f":"IF(OR(AW35=0,AW35=\"\"), 0, AW34/AW35)","v":"1077.78"},{"$f":"IF(OR(AX35=0,AX35=\"\"), 0, AX34/AX35)","v":"710.015"},{"$f":"IF(OR(AY35=0,AY35=\"\"), 0, AY34/AY35)","v":"632.9759"}]
[]
[null,null,"Section III: Plan Adjustment Factors"]
[null,"3.1","Plan ID (Standard Component ID)",null,{"$f":"IF(E13<>\"\",E13,\"\")","v":"23671KY0070062"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"23671KY0070063"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"23671KY0070003"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"23671KY0070012"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"23671KY0070037"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"23671KY0070046"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"23671KY0070047"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"23671KY0070048"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"23671KY0070049"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"23671KY0070050"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"23671KY0070051"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"23671KY0070052"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"23671KY0070053"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"23671KY0070054"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"23671KY0070055"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"23671KY0070056"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"23671KY0070057"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"23671KY0070058"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"23671KY0070059"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"23671KY0070061"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"23671KY0070060"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"23671KY0080034"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"23671KY0080035"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"23671KY0080036"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"23671KY0080037"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"23671KY0080042"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"23671KY0080043"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"23671KY0080044"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"23671KY0080045"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"23671KY0080046"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"23671KY0080047"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"23671KY0080048"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"23671KY0080049"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"23671KY0080050"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"23671KY0080067"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"23671KY0080009"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"23671KY0080025"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"23671KY0080038"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"23671KY0080039"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"23671KY0080040"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"23671KY0080041"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"23671KY0080059"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"23671KY0080060"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"23671KY0080062"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"23671KY0080063"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"23671KY0080064"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"23671KY0080065"}]
[null,"3.2","Market Adjusted Index Rate",null,{"$f":"'Wksh 1 - Market Experience'!F46","v":"$1,262.63"}]
[null,"3.3","AV and Cost Sharing Design of Plan",null,0.959,0.8213,0.7944,0.6591,0.7849,0.7887,0.7812,0.7796,0.6932,0.6215,0.7998,0.7786,0.9448,0.8991,0.7947,0.768,0.7861,0.7654,0.7557,0.7876,0.0,0.7852,0.7795,0.772,0.7704,0.7704,0.9357,0.8901,0.7856,0.7589,0.7776,0.7763,0.7568,0.7471,0.7786,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","CSR Load Factor",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]
[null,"3.5","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]
[null,"3.6","Benefits in Addition to EHB",null,1.0,1.0,1.0001,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0009,1.0,1.0001,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,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.7","Administrative Expense",null,0.0616,0.07,0.0718,0.0832,0.0725,0.0723,0.0728,0.0729,0.08,0.087,0.0715,0.073,0.0624,0.065,0.0718,0.0738,0.0725,0.074,0.0748,0.0723,0.0,0.0725,0.0729,0.0735,0.0736,0.0736,0.0629,0.0655,0.0725,0.0745,0.0731,0.0732,0.0747,0.0754,0.073,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","Taxes and Fees",null,0.0349,0.0396,0.0407,0.0471,0.0411,0.0409,0.0412,0.0413,0.0453,0.0493,0.0405,0.0413,0.0353,0.0368,0.0407,0.0418,0.041,0.0419,0.0423,0.041,0.0,0.0411,0.0413,0.0416,0.0417,0.0417,0.0356,0.0371,0.041,0.0422,0.0414,0.0414,0.0423,0.0427,0.0413,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","Profit & Risk Load",null,0.0749,0.085,0.0873,0.1011,0.0881,0.0878,0.0885,0.0886,0.0972,0.1057,0.0868,0.0886,0.0758,0.079,0.0873,0.0897,0.088,0.0899,0.0908,0.0879,0.0,0.0881,0.0886,0.0893,0.0895,0.0895,0.0764,0.0796,0.0881,0.0905,0.0888,0.0889,0.0907,0.0917,0.0887,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.10","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]
[null,"3.11","Plan Adjusted Index Rate",null,{"$f":"($E$52*PRODUCT(E53:E56)*E61)/(1-SUM(E58:E60))","v":"$1,461.34"},{"$f":"($E$52*PRODUCT(F53:F56)*F61)/(1-SUM(F58:F60))","v":"$1,287.56"},{"$f":"($E$52*PRODUCT(G53:G56)*G61)/(1-SUM(G58:G60))","v":"$1,253.60"},{"$f":"($E$52*PRODUCT(H53:H56)*H61)/(1-SUM(H58:H60))","v":"$1,082.75"},{"$f":"($E$52*PRODUCT(I53:I56)*I61)/(1-SUM(I58:I60))","v":"$1,241.44"},{"$f":"($E$52*PRODUCT(J53:J56)*J61)/(1-SUM(J58:J60))","v":"$1,246.35"},{"$f":"($E$52*PRODUCT(K53:K56)*K61)/(1-SUM(K58:K60))","v":"$1,236.82"},{"$f":"($E$52*PRODUCT(L53:L56)*L61)/(1-SUM(L58:L60))","v":"$1,234.75"},{"$f":"($E$52*PRODUCT(M53:M56)*M61)/(1-SUM(M58:M60))","v":"$1,125.73"},{"$f":"($E$52*PRODUCT(N53:N56)*N61)/(1-SUM(N58:N60))","v":"$1,035.26"},{"$f":"($E$52*PRODUCT(O53:O56)*O61)/(1-SUM(O58:O60))","v":"$1,260.42"},{"$f":"($E$52*PRODUCT(P53:P56)*P61)/(1-SUM(P58:P60))","v":"$1,234.44"},{"$f":"($E$52*PRODUCT(Q53:Q56)*Q61)/(1-SUM(Q58:Q60))","v":"$1,443.35"},{"$f":"($E$52*PRODUCT(R53:R56)*R61)/(1-SUM(R58:R60))","v":"$1,385.92"},{"$f":"($E$52*PRODUCT(S53:S56)*S61)/(1-SUM(S58:S60))","v":"$1,253.95"},{"$f":"($E$52*PRODUCT(T53:T56)*T61)/(1-SUM(T58:T60))","v":"$1,220.21"},{"$f":"($E$52*PRODUCT(U53:U56)*U61)/(1-SUM(U58:U60))","v":"$1,243.02"},{"$f":"($E$52*PRODUCT(V53:V56)*V61)/(1-SUM(V58:V60))","v":"$1,216.84"},{"$f":"($E$52*PRODUCT(W53:W56)*W61)/(1-SUM(W58:W60))","v":"$1,204.61"},{"$f":"($E$52*PRODUCT(X53:X56)*X61)/(1-SUM(X58:X60))","v":"$1,244.93"},{"$f":"($E$52*PRODUCT(Y53:Y56)*Y61)/(1-SUM(Y58:Y60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(Z53:Z56)*Z61)/(1-SUM(Z58:Z60))","v":"$1,241.91"},{"$f":"($E$52*PRODUCT(AA53:AA56)*AA61)/(1-SUM(AA58:AA60))","v":"$1,234.60"},{"$f":"($E$52*PRODUCT(AB53:AB56)*AB61)/(1-SUM(AB58:AB60))","v":"$1,225.18"},{"$f":"($E$52*PRODUCT(AC53:AC56)*AC61)/(1-SUM(AC58:AC60))","v":"$1,223.25"},{"$f":"($E$52*PRODUCT(AD53:AD56)*AD61)/(1-SUM(AD58:AD60))","v":"$1,223.25"},{"$f":"($E$52*PRODUCT(AE53:AE56)*AE61)/(1-SUM(AE58:AE60))","v":"$1,431.88"},{"$f":"($E$52*PRODUCT(AF53:AF56)*AF61)/(1-SUM(AF58:AF60))","v":"$1,374.26"},{"$f":"($E$52*PRODUCT(AG53:AG56)*AG61)/(1-SUM(AG58:AG60))","v":"$1,242.39"},{"$f":"($E$52*PRODUCT(AH53:AH56)*AH61)/(1-SUM(AH58:AH60))","v":"$1,208.64"},{"$f":"($E$52*PRODUCT(AI53:AI56)*AI61)/(1-SUM(AI58:AI60))","v":"$1,232.36"},{"$f":"($E$52*PRODUCT(AJ53:AJ56)*AJ61)/(1-SUM(AJ58:AJ60))","v":"$1,230.61"},{"$f":"($E$52*PRODUCT(AK53:AK56)*AK61)/(1-SUM(AK58:AK60))","v":"$1,206.06"},{"$f":"($E$52*PRODUCT(AL53:AL56)*AL61)/(1-SUM(AL58:AL60))","v":"$1,193.76"},{"$f":"($E$52*PRODUCT(AM53:AM56)*AM61)/(1-SUM(AM58:AM60))","v":"$1,233.48"},{"$f":"($E$52*PRODUCT(AN53:AN56)*AN61)/(1-SUM(AN58:AN60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AO53:AO56)*AO61)/(1-SUM(AO58:AO60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AP53:AP56)*AP61)/(1-SUM(AP58:AP60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AQ53:AQ56)*AQ61)/(1-SUM(AQ58:AQ60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AR53:AR56)*AR61)/(1-SUM(AR58:AR60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AS53:AS56)*AS61)/(1-SUM(AS58:AS60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AT53:AT56)*AT61)/(1-SUM(AT58:AT60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AU53:AU56)*AU61)/(1-SUM(AU58:AU60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AV53:AV56)*AV61)/(1-SUM(AV58:AV60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AW53:AW56)*AW61)/(1-SUM(AW58:AW60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AX53:AX56)*AX61)/(1-SUM(AX58:AX60))","v":"$0.00"},{"$f":"($E$52*PRODUCT(AY53:AY56)*AY61)/(1-SUM(AY58:AY60))","v":"$0.00"}]
[]
[null,"3.12","Age Calibration Factor","0.6973",{"$f":"IF(D64<>\"\", D64, \"\")","v":"0.6973"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","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","Geographic Calibration Factor","1.4153",{"$f":"IF(D65<>\"\", D65, \"\")","v":"1.4153"},"0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","0.0000","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","Tobacco Calibration Factor","1.0000",{"$f":"IF(D66<>\"\", D66, \"\")","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"]
[null,"3.15","Calibrated Plan Adjusted Index Rate",null,{"$f":"E62*(PRODUCT($E$64:$E$66))","v":"$1,442.17"},{"$f":"F62*(PRODUCT($E$64:$E$66))","v":"$1,270.67"},{"$f":"G62*(PRODUCT($E$64:$E$66))","v":"$1,237.17"},{"$f":"H62*(PRODUCT($E$64:$E$66))","v":"$1,068.55"},{"$f":"I62*(PRODUCT($E$64:$E$66))","v":"$1,225.16"},{"$f":"J62*(PRODUCT($E$64:$E$66))","v":"$1,230.01"},{"$f":"K62*(PRODUCT($E$64:$E$66))","v":"$1,220.61"},{"$f":"L62*(PRODUCT($E$64:$E$66))","v":"$1,218.57"},{"$f":"M62*(PRODUCT($E$64:$E$66))","v":"$1,110.97"},{"$f":"N62*(PRODUCT($E$64:$E$66))","v":"$1,021.68"},{"$f":"O62*(PRODUCT($E$64:$E$66))","v":"$1,243.90"},{"$f":"P62*(PRODUCT($E$64:$E$66))","v":"$1,218.25"},{"$f":"Q62*(PRODUCT($E$64:$E$66))","v":"$1,424.43"},{"$f":"R62*(PRODUCT($E$64:$E$66))","v":"$1,367.75"},{"$f":"S62*(PRODUCT($E$64:$E$66))","v":"$1,237.51"},{"$f":"T62*(PRODUCT($E$64:$E$66))","v":"$1,204.21"},{"$f":"U62*(PRODUCT($E$64:$E$66))","v":"$1,226.72"},{"$f":"V62*(PRODUCT($E$64:$E$66))","v":"$1,200.89"},{"$f":"W62*(PRODUCT($E$64:$E$66))","v":"$1,188.81"},{"$f":"X62*(PRODUCT($E$64:$E$66))","v":"$1,228.60"},{"$f":"Y62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"Z62*(PRODUCT($E$64:$E$66))","v":"$1,225.63"},{"$f":"AA62*(PRODUCT($E$64:$E$66))","v":"$1,218.41"},{"$f":"AB62*(PRODUCT($E$64:$E$66))","v":"$1,209.11"},{"$f":"AC62*(PRODUCT($E$64:$E$66))","v":"$1,207.21"},{"$f":"AD62*(PRODUCT($E$64:$E$66))","v":"$1,207.21"},{"$f":"AE62*(PRODUCT($E$64:$E$66))","v":"$1,413.10"},{"$f":"AF62*(PRODUCT($E$64:$E$66))","v":"$1,356.24"},{"$f":"AG62*(PRODUCT($E$64:$E$66))","v":"$1,226.10"},{"$f":"AH62*(PRODUCT($E$64:$E$66))","v":"$1,192.79"},{"$f":"AI62*(PRODUCT($E$64:$E$66))","v":"$1,216.20"},{"$f":"AJ62*(PRODUCT($E$64:$E$66))","v":"$1,214.47"},{"$f":"AK62*(PRODUCT($E$64:$E$66))","v":"$1,190.24"},{"$f":"AL62*(PRODUCT($E$64:$E$66))","v":"$1,178.11"},{"$f":"AM62*(PRODUCT($E$64:$E$66))","v":"$1,217.31"},{"$f":"AN62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AO62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AP62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AQ62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AR62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AS62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AT62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AU62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AV62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AW62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AX62*(PRODUCT($E$64:$E$66))","v":"$0.00"},{"$f":"AY62*(PRODUCT($E$64:$E$66))","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":"23671KY0070062"},{"$f":"IF(F13<>\"\",F13,\"\")","v":"23671KY0070063"},{"$f":"IF(G13<>\"\",G13,\"\")","v":"23671KY0070003"},{"$f":"IF(H13<>\"\",H13,\"\")","v":"23671KY0070012"},{"$f":"IF(I13<>\"\",I13,\"\")","v":"23671KY0070037"},{"$f":"IF(J13<>\"\",J13,\"\")","v":"23671KY0070046"},{"$f":"IF(K13<>\"\",K13,\"\")","v":"23671KY0070047"},{"$f":"IF(L13<>\"\",L13,\"\")","v":"23671KY0070048"},{"$f":"IF(M13<>\"\",M13,\"\")","v":"23671KY0070049"},{"$f":"IF(N13<>\"\",N13,\"\")","v":"23671KY0070050"},{"$f":"IF(O13<>\"\",O13,\"\")","v":"23671KY0070051"},{"$f":"IF(P13<>\"\",P13,\"\")","v":"23671KY0070052"},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":"23671KY0070053"},{"$f":"IF(R13<>\"\",R13,\"\")","v":"23671KY0070054"},{"$f":"IF(S13<>\"\",S13,\"\")","v":"23671KY0070055"},{"$f":"IF(T13<>\"\",T13,\"\")","v":"23671KY0070056"},{"$f":"IF(U13<>\"\",U13,\"\")","v":"23671KY0070057"},{"$f":"IF(V13<>\"\",V13,\"\")","v":"23671KY0070058"},{"$f":"IF(W13<>\"\",W13,\"\")","v":"23671KY0070059"},{"$f":"IF(X13<>\"\",X13,\"\")","v":"23671KY0070061"},{"$f":"IF(Y13<>\"\",Y13,\"\")","v":"23671KY0070060"},{"$f":"IF(Z13<>\"\",Z13,\"\")","v":"23671KY0080034"},{"$f":"IF(AA13<>\"\",AA13,\"\")","v":"23671KY0080035"},{"$f":"IF(AB13<>\"\",AB13,\"\")","v":"23671KY0080036"},{"$f":"IF(AC13<>\"\",AC13,\"\")","v":"23671KY0080037"},{"$f":"IF(AD13<>\"\",AD13,\"\")","v":"23671KY0080042"},{"$f":"IF(AE13<>\"\",AE13,\"\")","v":"23671KY0080043"},{"$f":"IF(AF13<>\"\",AF13,\"\")","v":"23671KY0080044"},{"$f":"IF(AG13<>\"\",AG13,\"\")","v":"23671KY0080045"},{"$f":"IF(AH13<>\"\",AH13,\"\")","v":"23671KY0080046"},{"$f":"IF(AI13<>\"\",AI13,\"\")","v":"23671KY0080047"},{"$f":"IF(AJ13<>\"\",AJ13,\"\")","v":"23671KY0080048"},{"$f":"IF(AK13<>\"\",AK13,\"\")","v":"23671KY0080049"},{"$f":"IF(AL13<>\"\",AL13,\"\")","v":"23671KY0080050"},{"$f":"IF(AM13<>\"\",AM13,\"\")","v":"23671KY0080067"},{"$f":"IF(AN13<>\"\",AN13,\"\")","v":"23671KY0080009"},{"$f":"IF(AO13<>\"\",AO13,\"\")","v":"23671KY0080025"},{"$f":"IF(AP13<>\"\",AP13,\"\")","v":"23671KY0080038"},{"$f":"IF(AQ13<>\"\",AQ13,\"\")","v":"23671KY0080039"},{"$f":"IF(AR13<>\"\",AR13,\"\")","v":"23671KY0080040"},{"$f":"IF(AS13<>\"\",AS13,\"\")","v":"23671KY0080041"},{"$f":"IF(AT13<>\"\",AT13,\"\")","v":"23671KY0080059"},{"$f":"IF(AU13<>\"\",AU13,\"\")","v":"23671KY0080060"},{"$f":"IF(AV13<>\"\",AV13,\"\")","v":"23671KY0080062"},{"$f":"IF(AW13<>\"\",AW13,\"\")","v":"23671KY0080063"},{"$f":"IF(AX13<>\"\",AX13,\"\")","v":"23671KY0080064"},{"$f":"IF(AY13<>\"\",AY13,\"\")","v":"23671KY0080065"}]
[null,"4.2","Allowed Claims",{"$f":"SUM(E71:AY71)","v":"$7,696,647"},180147.2275,144203.2177,1961030.9845,274614.6761,144203.2177,144203.2177,144203.2177,365176.4937,240033.5688,114931.3274,144203.2177,144337.466,180147.2275,393271.1663,144203.2177,144203.2177,144203.2177,144203.2177,144203.2177,144203.2177,0.0,144203.2177,144203.2177,144203.2177,144203.2177,144203.2177,180147.2275,180147.2275,144203.2177,144203.2177,144203.2177,310192.533,144203.2177,144203.2177,144203.2177,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(E72:AY72)","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]
[null,"4.4","Member Cost Sharing",{"$f":"SUM(E73:AY73)","v":"$1,598,120"},15934.9775,25005.6577,393219.3345,88797.1361,30291.4177,29737.8477,30827.1377,78653.7337,69216.9388,41605.4774,28130.6877,31229.246,18357.9175,57160.0563,28862.8377,32737.8777,30112.8477,33112.8777,34523.6077,29898.5577,0.0,30237.8477,31077.1477,32166.4377,32398.5877,32398.5877,19917.0275,27733.6575,30184.2777,34059.3177,31345.0077,67848.123,34362.8877,35773.6177,31202.1477,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","Federal CSR Payments",{"$f":"SUM(E74:AY74)","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]
[null,"4.6","Issuer CSR Payments",{"$f":"SUM(E75:AY75)","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]
[null,"4.7","Recoveries from CSR Load",{"$f":"SUM(E76:AY76)","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]
[null,"4.8","Incurred Claims",{"$f":"D71-D72-D73-D74","v":"$6,098,527"},{"$f":"E71-E72-E73-E74","v":"164212.25"},{"$f":"F71-F72-F73-F74","v":"119197.56"},{"$f":"G71-G72-G73-G74","v":"1567811.65"},{"$f":"H71-H72-H73-H74","v":"185817.54"},{"$f":"I71-I72-I73-I74","v":"113911.8"},{"$f":"J71-J72-J73-J74","v":"114465.37"},{"$f":"K71-K72-K73-K74","v":"113376.08"},{"$f":"L71-L72-L73-L74","v":"286522.76"},{"$f":"M71-M72-M73-M74","v":"170816.63"},{"$f":"N71-N72-N73-N74","v":"73325.85"},{"$f":"O71-O72-O73-O74","v":"116072.53"},{"$f":"P71-P72-P73-P74","v":"113108.22"},{"$f":"Q71-Q72-Q73-Q74","v":"161789.31"},{"$f":"R71-R72-R73-R74","v":"336111.11"},{"$f":"S71-S72-S73-S74","v":"115340.38"},{"$f":"T71-T72-T73-T74","v":"111465.34"},{"$f":"U71-U72-U73-U74","v":"114090.37"},{"$f":"V71-V72-V73-V74","v":"111090.34"},{"$f":"W71-W72-W73-W74","v":"109679.61"},{"$f":"X71-X72-X73-X74","v":"114304.66"},{"$f":"Y71-Y72-Y73-Y74","v":"0"},{"$f":"Z71-Z72-Z73-Z74","v":"113965.37"},{"$f":"AA71-AA72-AA73-AA74","v":"113126.07"},{"$f":"AB71-AB72-AB73-AB74","v":"112036.78"},{"$f":"AC71-AC72-AC73-AC74","v":"111804.63"},{"$f":"AD71-AD72-AD73-AD74","v":"111804.63"},{"$f":"AE71-AE72-AE73-AE74","v":"160230.2"},{"$f":"AF71-AF72-AF73-AF74","v":"152413.57"},{"$f":"AG71-AG72-AG73-AG74","v":"114018.94"},{"$f":"AH71-AH72-AH73-AH74","v":"110143.9"},{"$f":"AI71-AI72-AI73-AI74","v":"112858.21"},{"$f":"AJ71-AJ72-AJ73-AJ74","v":"242344.41"},{"$f":"AK71-AK72-AK73-AK74","v":"109840.33"},{"$f":"AL71-AL72-AL73-AL74","v":"108429.6"},{"$f":"AM71-AM72-AM73-AM74","v":"113001.07"},{"$f":"AN71-AN72-AN73-AN74","v":"0"},{"$f":"AO71-AO72-AO73-AO74","v":"0"},{"$f":"AP71-AP72-AP73-AP74","v":"0"},{"$f":"AQ71-AQ72-AQ73-AQ74","v":"0"},{"$f":"AR71-AR72-AR73-AR74","v":"0"},{"$f":"AS71-AS72-AS73-AS74","v":"0"},{"$f":"AT71-AT72-AT73-AT74","v":"0"},{"$f":"AU71-AU72-AU73-AU74","v":"0"},{"$f":"AV71-AV72-AV73-AV74","v":"0"},{"$f":"AW71-AW72-AW73-AW74","v":"0"},{"$f":"AX71-AX72-AX73-AX74","v":"0"},{"$f":"AY71-AY72-AY73-AY74","v":"0"}]
[null,"4.9","Risk Adjustment Transfer Amount",{"$f":"SUM(E78:AY78)","v":"-$1,276,214"},-28394.96,-24066.46,-327234.6,-46747.8,-24066.46,-24066.46,-24066.46,-60945.28,-40861.04,-19564.82,-24066.46,-24066.46,-28394.96,-61984.12,-24066.46,-24066.46,-24066.46,-24066.46,-24066.46,-24066.46,0.0,-24066.46,-24066.46,-24066.46,-24066.46,-24066.46,-28394.96,-28394.96,-24066.46,-24066.46,-24066.46,-51768.86,-24066.46,-24066.46,-24066.46,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","Premium",{"$f":"SUM(E79:AY79)","v":"$9,221,037"},239658.94,178970.36,2369310.74,292341.72,172559.59,173243.11,171918.43,434633.61,265672.29,116984.0,175198.9,171586.53,236710.2,496158.7,174299.27,169609.01,172780.12,169141.23,167440.42,173044.8,0.0,172625.55,171608.87,170299.52,170032.06,170032.06,234828.06,225378.07,172691.85,168000.98,171298.02,367951.94,167641.82,165932.94,171453.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]
[null,"4.11","Projected Member Months",{"$f":"SUM(E80:AY80)","v":"7371"},164.0,139.0,1890.0,270.0,139.0,139.0,139.0,352.0,236.0,113.0,139.0,139.0,164.0,358.0,139.0,139.0,139.0,139.0,139.0,139.0,0.0,139.0,139.0,139.0,139.0,139.0,164.0,164.0,139.0,139.0,139.0,299.0,139.0,139.0,139.0,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.12","Loss Ratio",{"$f":"IF(OR(D78+D79=0,D78+D79=\"\"), 0, D77/(D78+D79))","v":"76.76%"},{"$f":"IF(OR(E78+E79=0,E78+E79=\"\"), 0, E77/(E78+E79))","v":"0.777284655907742"},{"$f":"IF(OR(F78+F79=0,F78+F79=\"\"), 0, F77/(F78+F79))","v":"0.769493602162373"},{"$f":"IF(OR(G78+G79=0,G78+G79=\"\"), 0, G77/(G78+G79))","v":"0.767753767496642"},{"$f":"IF(OR(H78+H79=0,H78+H79=\"\"), 0, H77/(H78+H79))","v":"0.756604805200389"},{"$f":"IF(OR(I78+I79=0,I78+I79=\"\"), 0, I77/(I78+I79))","v":"0.767118317190836"},{"$f":"IF(OR(J78+J79=0,J78+J79=\"\"), 0, J77/(J78+J79))","v":"0.767314254610222"},{"$f":"IF(OR(K78+K79=0,K78+K79=\"\"), 0, K77/(K78+K79))","v":"0.766821571603003"},{"$f":"IF(OR(L78+L79=0,L78+L79=\"\"), 0, L77/(L78+L79))","v":"0.76674259536015"},{"$f":"IF(OR(M78+M79=0,M78+M79=\"\"), 0, M77/(M78+M79))","v":"0.759822428815284"},{"$f":"IF(OR(N78+N79=0,N78+N79=\"\"), 0, N77/(N78+N79))","v":"0.752683917068487"},{"$f":"IF(OR(O78+O79=0,O78+O79=\"\"), 0, O77/(O78+O79))","v":"0.768018633193509"},{"$f":"IF(OR(P78+P79=0,P78+P79=\"\"), 0, P77/(P78+P79))","v":"0.766731062424252"},{"$f":"IF(OR(Q78+Q79=0,Q78+Q79=\"\"), 0, Q77/(Q78+Q79))","v":"0.776656139032363"},{"$f":"IF(OR(R78+R79=0,R78+R79=\"\"), 0, R77/(R78+R79))","v":"0.774138158894517"},{"$f":"IF(OR(S78+S79=0,S78+S79=\"\"), 0, S77/(S78+S79))","v":"0.767744276366794"},{"$f":"IF(OR(T78+T79=0,T78+T79=\"\"), 0, T77/(T78+T79))","v":"0.765860842756981"},{"$f":"IF(OR(U78+U79=0,U78+U79=\"\"), 0, U77/(U78+U79))","v":"0.767181508410189"},{"$f":"IF(OR(V78+V79=0,V78+V79=\"\"), 0, V77/(V78+V79))","v":"0.765745415277929"},{"$f":"IF(OR(W78+W79=0,W78+W79=\"\"), 0, W77/(W78+W79))","v":"0.76498975127701"},{"$f":"IF(OR(X78+X79=0,X78+X79=\"\"), 0, X77/(X78+X79))","v":"0.767256904594319"},{"$f":"IF(OR(Y78+Y79=0,Y78+Y79=\"\"), 0, Y77/(Y78+Y79))","v":"0"},{"$f":"IF(OR(Z78+Z79=0,Z78+Z79=\"\"), 0, Z77/(Z78+Z79))","v":"0.767138315131036"},{"$f":"IF(OR(AA78+AA79=0,AA78+AA79=\"\"), 0, AA77/(AA78+AA79))","v":"0.766735950700548"},{"$f":"IF(OR(AB78+AB79=0,AB78+AB79=\"\"), 0, AB77/(AB78+AB79))","v":"0.766152195679965"},{"$f":"IF(OR(AC78+AC79=0,AC78+AC79=\"\"), 0, AC77/(AC78+AC79))","v":"0.765965611075486"},{"$f":"IF(OR(AD78+AD79=0,AD78+AD79=\"\"), 0, AD77/(AD78+AD79))","v":"0.765965611075486"},{"$f":"IF(OR(AE78+AE79=0,AE78+AE79=\"\"), 0, AE77/(AE78+AE79))","v":"0.776184633181404"},{"$f":"IF(OR(AF78+AF79=0,AF78+AF79=\"\"), 0, AF77/(AF78+AF79))","v":"0.773739281504896"},{"$f":"IF(OR(AG78+AG79=0,AG78+AG79=\"\"), 0, AG77/(AG78+AG79))","v":"0.767156540346168"},{"$f":"IF(OR(AH78+AH79=0,AH78+AH79=\"\"), 0, AH77/(AH78+AH79))","v":"0.765236164333615"},{"$f":"IF(OR(AI78+AI79=0,AI78+AI79=\"\"), 0, AI77/(AI78+AI79))","v":"0.766535449328935"},{"$f":"IF(OR(AJ78+AJ79=0,AJ78+AJ79=\"\"), 0, AJ77/(AJ78+AJ79))","v":"0.766468623178698"},{"$f":"IF(OR(AK78+AK79=0,AK78+AK79=\"\"), 0, AK77/(AK78+AK79))","v":"0.765036075828053"},{"$f":"IF(OR(AL78+AL79=0,AL78+AL79=\"\"), 0, AL77/(AL78+AL79))","v":"0.764307396645071"},{"$f":"IF(OR(AM78+AM79=0,AM78+AM79=\"\"), 0, AM77/(AM78+AM79))","v":"0.76669480794443"},{"$f":"IF(OR(AN78+AN79=0,AN78+AN79=\"\"), 0, AN77/(AN78+AN79))","v":"0"},{"$f":"IF(OR(AO78+AO79=0,AO78+AO79=\"\"), 0, AO77/(AO78+AO79))","v":"0"},{"$f":"IF(OR(AP78+AP79=0,AP78+AP79=\"\"), 0, AP77/(AP78+AP79))","v":"0"},{"$f":"IF(OR(AQ78+AQ79=0,AQ78+AQ79=\"\"), 0, AQ77/(AQ78+AQ79))","v":"0"},{"$f":"IF(OR(AR78+AR79=0,AR78+AR79=\"\"), 0, AR77/(AR78+AR79))","v":"0"},{"$f":"IF(OR(AS78+AS79=0,AS78+AS79=\"\"), 0, AS77/(AS78+AS79))","v":"0"},{"$f":"IF(OR(AT78+AT79=0,AT78+AT79=\"\"), 0, AT77/(AT78+AT79))","v":"0"},{"$f":"IF(OR(AU78+AU79=0,AU78+AU79=\"\"), 0, AU77/(AU78+AU79))","v":"0"},{"$f":"IF(OR(AV78+AV79=0,AV78+AV79=\"\"), 0, AV77/(AV78+AV79))","v":"0"},{"$f":"IF(OR(AW78+AW79=0,AW78+AW79=\"\"), 0, AW77/(AW78+AW79))","v":"0"},{"$f":"IF(OR(AX78+AX79=0,AX78+AX79=\"\"), 0, AX77/(AX78+AX79))","v":"0"},{"$f":"IF(OR(AY78+AY79=0,AY78+AY79=\"\"), 0, AY77/(AY78+AY79))","v":"0"}]
[null,null,"Per Member Per Month"]
[null,"4.13","Allowed Claims",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D71/D80)","v":"$1,044.18"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E71/E80)","v":"1098.4587"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F71/F80)","v":"1037.4332"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G71/G80)","v":"1037.5825"},{"$f":"IF(OR(H80=0,H80=\"\"), 0, H71/H80)","v":"1017.0914"},{"$f":"IF(OR(I80=0,I80=\"\"), 0, I71/I80)","v":"1037.4332"},{"$f":"IF(OR(J80=0,J80=\"\"), 0, J71/J80)","v":"1037.4332"},{"$f":"IF(OR(K80=0,K80=\"\"), 0, K71/K80)","v":"1037.4332"},{"$f":"IF(OR(L80=0,L80=\"\"), 0, L71/L80)","v":"1037.4332"},{"$f":"IF(OR(M80=0,M80=\"\"), 0, M71/M80)","v":"1017.0914"},{"$f":"IF(OR(N80=0,N80=\"\"), 0, N71/N80)","v":"1017.0914"},{"$f":"IF(OR(O80=0,O80=\"\"), 0, O71/O80)","v":"1037.4332"},{"$f":"IF(OR(P80=0,P80=\"\"), 0, P71/P80)","v":"1038.399"},{"$f":"IF(OR(Q80=0,Q80=\"\"), 0, Q71/Q80)","v":"1098.4587"},{"$f":"IF(OR(R80=0,R80=\"\"), 0, R71/R80)","v":"1098.5228"},{"$f":"IF(OR(S80=0,S80=\"\"), 0, S71/S80)","v":"1037.4332"},{"$f":"IF(OR(T80=0,T80=\"\"), 0, T71/T80)","v":"1037.4332"},{"$f":"IF(OR(U80=0,U80=\"\"), 0, U71/U80)","v":"1037.4332"},{"$f":"IF(OR(V80=0,V80=\"\"), 0, V71/V80)","v":"1037.4332"},{"$f":"IF(OR(W80=0,W80=\"\"), 0, W71/W80)","v":"1037.4332"},{"$f":"IF(OR(X80=0,X80=\"\"), 0, X71/X80)","v":"1037.4332"},{"$f":"IF(OR(Y80=0,Y80=\"\"), 0, Y71/Y80)","v":"0"},{"$f":"IF(OR(Z80=0,Z80=\"\"), 0, Z71/Z80)","v":"1037.4332"},{"$f":"IF(OR(AA80=0,AA80=\"\"), 0, AA71/AA80)","v":"1037.4332"},{"$f":"IF(OR(AB80=0,AB80=\"\"), 0, AB71/AB80)","v":"1037.4332"},{"$f":"IF(OR(AC80=0,AC80=\"\"), 0, AC71/AC80)","v":"1037.4332"},{"$f":"IF(OR(AD80=0,AD80=\"\"), 0, AD71/AD80)","v":"1037.4332"},{"$f":"IF(OR(AE80=0,AE80=\"\"), 0, AE71/AE80)","v":"1098.4587"},{"$f":"IF(OR(AF80=0,AF80=\"\"), 0, AF71/AF80)","v":"1098.4587"},{"$f":"IF(OR(AG80=0,AG80=\"\"), 0, AG71/AG80)","v":"1037.4332"},{"$f":"IF(OR(AH80=0,AH80=\"\"), 0, AH71/AH80)","v":"1037.4332"},{"$f":"IF(OR(AI80=0,AI80=\"\"), 0, AI71/AI80)","v":"1037.4332"},{"$f":"IF(OR(AJ80=0,AJ80=\"\"), 0, AJ71/AJ80)","v":"1037.4332"},{"$f":"IF(OR(AK80=0,AK80=\"\"), 0, AK71/AK80)","v":"1037.4332"},{"$f":"IF(OR(AL80=0,AL80=\"\"), 0, AL71/AL80)","v":"1037.4332"},{"$f":"IF(OR(AM80=0,AM80=\"\"), 0, AM71/AM80)","v":"1037.4332"},{"$f":"IF(OR(AN80=0,AN80=\"\"), 0, AN71/AN80)","v":"0"},{"$f":"IF(OR(AO80=0,AO80=\"\"), 0, AO71/AO80)","v":"0"},{"$f":"IF(OR(AP80=0,AP80=\"\"), 0, AP71/AP80)","v":"0"},{"$f":"IF(OR(AQ80=0,AQ80=\"\"), 0, AQ71/AQ80)","v":"0"},{"$f":"IF(OR(AR80=0,AR80=\"\"), 0, AR71/AR80)","v":"0"},{"$f":"IF(OR(AS80=0,AS80=\"\"), 0, AS71/AS80)","v":"0"},{"$f":"IF(OR(AT80=0,AT80=\"\"), 0, AT71/AT80)","v":"0"},{"$f":"IF(OR(AU80=0,AU80=\"\"), 0, AU71/AU80)","v":"0"},{"$f":"IF(OR(AV80=0,AV80=\"\"), 0, AV71/AV80)","v":"0"},{"$f":"IF(OR(AW80=0,AW80=\"\"), 0, AW71/AW80)","v":"0"},{"$f":"IF(OR(AX80=0,AX80=\"\"), 0, AX71/AX80)","v":"0"},{"$f":"IF(OR(AY80=0,AY80=\"\"), 0, AY71/AY80)","v":"0"}]
[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"},{"$f":"IF(OR(H80=0,H80=\"\"), 0, H72/H80)","v":"0"},{"$f":"IF(OR(I80=0,I80=\"\"), 0, I72/I80)","v":"0"},{"$f":"IF(OR(J80=0,J80=\"\"), 0, J72/J80)","v":"0"},{"$f":"IF(OR(K80=0,K80=\"\"), 0, K72/K80)","v":"0"},{"$f":"IF(OR(L80=0,L80=\"\"), 0, L72/L80)","v":"0"},{"$f":"IF(OR(M80=0,M80=\"\"), 0, M72/M80)","v":"0"},{"$f":"IF(OR(N80=0,N80=\"\"), 0, N72/N80)","v":"0"},{"$f":"IF(OR(O80=0,O80=\"\"), 0, O72/O80)","v":"0"},{"$f":"IF(OR(P80=0,P80=\"\"), 0, P72/P80)","v":"0"},{"$f":"IF(OR(Q80=0,Q80=\"\"), 0, Q72/Q80)","v":"0"},{"$f":"IF(OR(R80=0,R80=\"\"), 0, R72/R80)","v":"0"},{"$f":"IF(OR(S80=0,S80=\"\"), 0, S72/S80)","v":"0"},{"$f":"IF(OR(T80=0,T80=\"\"), 0, T72/T80)","v":"0"},{"$f":"IF(OR(U80=0,U80=\"\"), 0, U72/U80)","v":"0"},{"$f":"IF(OR(V80=0,V80=\"\"), 0, V72/V80)","v":"0"},{"$f":"IF(OR(W80=0,W80=\"\"), 0, W72/W80)","v":"0"},{"$f":"IF(OR(X80=0,X80=\"\"), 0, X72/X80)","v":"0"},{"$f":"IF(OR(Y80=0,Y80=\"\"), 0, Y72/Y80)","v":"0"},{"$f":"IF(OR(Z80=0,Z80=\"\"), 0, Z72/Z80)","v":"0"},{"$f":"IF(OR(AA80=0,AA80=\"\"), 0, AA72/AA80)","v":"0"},{"$f":"IF(OR(AB80=0,AB80=\"\"), 0, AB72/AB80)","v":"0"},{"$f":"IF(OR(AC80=0,AC80=\"\"), 0, AC72/AC80)","v":"0"},{"$f":"IF(OR(AD80=0,AD80=\"\"), 0, AD72/AD80)","v":"0"},{"$f":"IF(OR(AE80=0,AE80=\"\"), 0, AE72/AE80)","v":"0"},{"$f":"IF(OR(AF80=0,AF80=\"\"), 0, AF72/AF80)","v":"0"},{"$f":"IF(OR(AG80=0,AG80=\"\"), 0, AG72/AG80)","v":"0"},{"$f":"IF(OR(AH80=0,AH80=\"\"), 0, AH72/AH80)","v":"0"},{"$f":"IF(OR(AI80=0,AI80=\"\"), 0, AI72/AI80)","v":"0"},{"$f":"IF(OR(AJ80=0,AJ80=\"\"), 0, AJ72/AJ80)","v":"0"},{"$f":"IF(OR(AK80=0,AK80=\"\"), 0, AK72/AK80)","v":"0"},{"$f":"IF(OR(AL80=0,AL80=\"\"), 0, AL72/AL80)","v":"0"},{"$f":"IF(OR(AM80=0,AM80=\"\"), 0, AM72/AM80)","v":"0"},{"$f":"IF(OR(AN80=0,AN80=\"\"), 0, AN72/AN80)","v":"0"},{"$f":"IF(OR(AO80=0,AO80=\"\"), 0, AO72/AO80)","v":"0"},{"$f":"IF(OR(AP80=0,AP80=\"\"), 0, AP72/AP80)","v":"0"},{"$f":"IF(OR(AQ80=0,AQ80=\"\"), 0, AQ72/AQ80)","v":"0"},{"$f":"IF(OR(AR80=0,AR80=\"\"), 0, AR72/AR80)","v":"0"},{"$f":"IF(OR(AS80=0,AS80=\"\"), 0, AS72/AS80)","v":"0"},{"$f":"IF(OR(AT80=0,AT80=\"\"), 0, AT72/AT80)","v":"0"},{"$f":"IF(OR(AU80=0,AU80=\"\"), 0, AU72/AU80)","v":"0"},{"$f":"IF(OR(AV80=0,AV80=\"\"), 0, AV72/AV80)","v":"0"},{"$f":"IF(OR(AW80=0,AW80=\"\"), 0, AW72/AW80)","v":"0"},{"$f":"IF(OR(AX80=0,AX80=\"\"), 0, AX72/AX80)","v":"0"},{"$f":"IF(OR(AY80=0,AY80=\"\"), 0, AY72/AY80)","v":"0"}]
[null,"4.15","Member Cost Sharing",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D73/D80)","v":"$216.81"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E73/E80)","v":"97.1645"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F73/F80)","v":"179.8968"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G73/G80)","v":"208.0526"},{"$f":"IF(OR(H80=0,H80=\"\"), 0, H73/H80)","v":"328.8783"},{"$f":"IF(OR(I80=0,I80=\"\"), 0, I73/I80)","v":"217.9239"},{"$f":"IF(OR(J80=0,J80=\"\"), 0, J73/J80)","v":"213.9414"},{"$f":"IF(OR(K80=0,K80=\"\"), 0, K73/K80)","v":"221.778"},{"$f":"IF(OR(L80=0,L80=\"\"), 0, L73/L80)","v":"223.4481"},{"$f":"IF(OR(M80=0,M80=\"\"), 0, M73/M80)","v":"293.2921"},{"$f":"IF(OR(N80=0,N80=\"\"), 0, N73/N80)","v":"368.1901"},{"$f":"IF(OR(O80=0,O80=\"\"), 0, O73/O80)","v":"202.379"},{"$f":"IF(OR(P80=0,P80=\"\"), 0, P73/P80)","v":"224.6708"},{"$f":"IF(OR(Q80=0,Q80=\"\"), 0, Q73/Q80)","v":"111.9385"},{"$f":"IF(OR(R80=0,R80=\"\"), 0, R73/R80)","v":"159.665"},{"$f":"IF(OR(S80=0,S80=\"\"), 0, S73/S80)","v":"207.6463"},{"$f":"IF(OR(T80=0,T80=\"\"), 0, T73/T80)","v":"235.5243"},{"$f":"IF(OR(U80=0,U80=\"\"), 0, U73/U80)","v":"216.6392"},{"$f":"IF(OR(V80=0,V80=\"\"), 0, V73/V80)","v":"238.2221"},{"$f":"IF(OR(W80=0,W80=\"\"), 0, W73/W80)","v":"248.3713"},{"$f":"IF(OR(X80=0,X80=\"\"), 0, X73/X80)","v":"215.0975"},{"$f":"IF(OR(Y80=0,Y80=\"\"), 0, Y73/Y80)","v":"0"},{"$f":"IF(OR(Z80=0,Z80=\"\"), 0, Z73/Z80)","v":"217.5385"},{"$f":"IF(OR(AA80=0,AA80=\"\"), 0, AA73/AA80)","v":"223.5766"},{"$f":"IF(OR(AB80=0,AB80=\"\"), 0, AB73/AB80)","v":"231.4132"},{"$f":"IF(OR(AC80=0,AC80=\"\"), 0, AC73/AC80)","v":"233.0834"},{"$f":"IF(OR(AD80=0,AD80=\"\"), 0, AD73/AD80)","v":"233.0834"},{"$f":"IF(OR(AE80=0,AE80=\"\"), 0, AE73/AE80)","v":"121.4453"},{"$f":"IF(OR(AF80=0,AF80=\"\"), 0, AF73/AF80)","v":"169.1077"},{"$f":"IF(OR(AG80=0,AG80=\"\"), 0, AG73/AG80)","v":"217.1531"},{"$f":"IF(OR(AH80=0,AH80=\"\"), 0, AH73/AH80)","v":"245.0311"},{"$f":"IF(OR(AI80=0,AI80=\"\"), 0, AI73/AI80)","v":"225.5037"},{"$f":"IF(OR(AJ80=0,AJ80=\"\"), 0, AJ73/AJ80)","v":"226.9168"},{"$f":"IF(OR(AK80=0,AK80=\"\"), 0, AK73/AK80)","v":"247.215"},{"$f":"IF(OR(AL80=0,AL80=\"\"), 0, AL73/AL80)","v":"257.3642"},{"$f":"IF(OR(AM80=0,AM80=\"\"), 0, AM73/AM80)","v":"224.4759"},{"$f":"IF(OR(AN80=0,AN80=\"\"), 0, AN73/AN80)","v":"0"},{"$f":"IF(OR(AO80=0,AO80=\"\"), 0, AO73/AO80)","v":"0"},{"$f":"IF(OR(AP80=0,AP80=\"\"), 0, AP73/AP80)","v":"0"},{"$f":"IF(OR(AQ80=0,AQ80=\"\"), 0, AQ73/AQ80)","v":"0"},{"$f":"IF(OR(AR80=0,AR80=\"\"), 0, AR73/AR80)","v":"0"},{"$f":"IF(OR(AS80=0,AS80=\"\"), 0, AS73/AS80)","v":"0"},{"$f":"IF(OR(AT80=0,AT80=\"\"), 0, AT73/AT80)","v":"0"},{"$f":"IF(OR(AU80=0,AU80=\"\"), 0, AU73/AU80)","v":"0"},{"$f":"IF(OR(AV80=0,AV80=\"\"), 0, AV73/AV80)","v":"0"},{"$f":"IF(OR(AW80=0,AW80=\"\"), 0, AW73/AW80)","v":"0"},{"$f":"IF(OR(AX80=0,AX80=\"\"), 0, AX73/AX80)","v":"0"},{"$f":"IF(OR(AY80=0,AY80=\"\"), 0, AY73/AY80)","v":"0"}]
[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"},{"$f":"IF(OR(H80=0,H80=\"\"), 0, H74/H80)","v":"0"},{"$f":"IF(OR(I80=0,I80=\"\"), 0, I74/I80)","v":"0"},{"$f":"IF(OR(J80=0,J80=\"\"), 0, J74/J80)","v":"0"},{"$f":"IF(OR(K80=0,K80=\"\"), 0, K74/K80)","v":"0"},{"$f":"IF(OR(L80=0,L80=\"\"), 0, L74/L80)","v":"0"},{"$f":"IF(OR(M80=0,M80=\"\"), 0, M74/M80)","v":"0"},{"$f":"IF(OR(N80=0,N80=\"\"), 0, N74/N80)","v":"0"},{"$f":"IF(OR(O80=0,O80=\"\"), 0, O74/O80)","v":"0"},{"$f":"IF(OR(P80=0,P80=\"\"), 0, P74/P80)","v":"0"},{"$f":"IF(OR(Q80=0,Q80=\"\"), 0, Q74/Q80)","v":"0"},{"$f":"IF(OR(R80=0,R80=\"\"), 0, R74/R80)","v":"0"},{"$f":"IF(OR(S80=0,S80=\"\"), 0, S74/S80)","v":"0"},{"$f":"IF(OR(T80=0,T80=\"\"), 0, T74/T80)","v":"0"},{"$f":"IF(OR(U80=0,U80=\"\"), 0, U74/U80)","v":"0"},{"$f":"IF(OR(V80=0,V80=\"\"), 0, V74/V80)","v":"0"},{"$f":"IF(OR(W80=0,W80=\"\"), 0, W74/W80)","v":"0"},{"$f":"IF(OR(X80=0,X80=\"\"), 0, X74/X80)","v":"0"},{"$f":"IF(OR(Y80=0,Y80=\"\"), 0, Y74/Y80)","v":"0"},{"$f":"IF(OR(Z80=0,Z80=\"\"), 0, Z74/Z80)","v":"0"},{"$f":"IF(OR(AA80=0,AA80=\"\"), 0, AA74/AA80)","v":"0"},{"$f":"IF(OR(AB80=0,AB80=\"\"), 0, AB74/AB80)","v":"0"},{"$f":"IF(OR(AC80=0,AC80=\"\"), 0, AC74/AC80)","v":"0"},{"$f":"IF(OR(AD80=0,AD80=\"\"), 0, AD74/AD80)","v":"0"},{"$f":"IF(OR(AE80=0,AE80=\"\"), 0, AE74/AE80)","v":"0"},{"$f":"IF(OR(AF80=0,AF80=\"\"), 0, AF74/AF80)","v":"0"},{"$f":"IF(OR(AG80=0,AG80=\"\"), 0, AG74/AG80)","v":"0"},{"$f":"IF(OR(AH80=0,AH80=\"\"), 0, AH74/AH80)","v":"0"},{"$f":"IF(OR(AI80=0,AI80=\"\"), 0, AI74/AI80)","v":"0"},{"$f":"IF(OR(AJ80=0,AJ80=\"\"), 0, AJ74/AJ80)","v":"0"},{"$f":"IF(OR(AK80=0,AK80=\"\"), 0, AK74/AK80)","v":"0"},{"$f":"IF(OR(AL80=0,AL80=\"\"), 0, AL74/AL80)","v":"0"},{"$f":"IF(OR(AM80=0,AM80=\"\"), 0, AM74/AM80)","v":"0"},{"$f":"IF(OR(AN80=0,AN80=\"\"), 0, AN74/AN80)","v":"0"},{"$f":"IF(OR(AO80=0,AO80=\"\"), 0, AO74/AO80)","v":"0"},{"$f":"IF(OR(AP80=0,AP80=\"\"), 0, AP74/AP80)","v":"0"},{"$f":"IF(OR(AQ80=0,AQ80=\"\"), 0, AQ74/AQ80)","v":"0"},{"$f":"IF(OR(AR80=0,AR80=\"\"), 0, AR74/AR80)","v":"0"},{"$f":"IF(OR(AS80=0,AS80=\"\"), 0, AS74/AS80)","v":"0"},{"$f":"IF(OR(AT80=0,AT80=\"\"), 0, AT74/AT80)","v":"0"},{"$f":"IF(OR(AU80=0,AU80=\"\"), 0, AU74/AU80)","v":"0"},{"$f":"IF(OR(AV80=0,AV80=\"\"), 0, AV74/AV80)","v":"0"},{"$f":"IF(OR(AW80=0,AW80=\"\"), 0, AW74/AW80)","v":"0"},{"$f":"IF(OR(AX80=0,AX80=\"\"), 0, AX74/AX80)","v":"0"},{"$f":"IF(OR(AY80=0,AY80=\"\"), 0, AY74/AY80)","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"},{"$f":"IF(OR(H80=0,H80=\"\"), 0, H75/H80)","v":"0"},{"$f":"IF(OR(I80=0,I80=\"\"), 0, I75/I80)","v":"0"},{"$f":"IF(OR(J80=0,J80=\"\"), 0, J75/J80)","v":"0"},{"$f":"IF(OR(K80=0,K80=\"\"), 0, K75/K80)","v":"0"},{"$f":"IF(OR(L80=0,L80=\"\"), 0, L75/L80)","v":"0"},{"$f":"IF(OR(M80=0,M80=\"\"), 0, M75/M80)","v":"0"},{"$f":"IF(OR(N80=0,N80=\"\"), 0, N75/N80)","v":"0"},{"$f":"IF(OR(O80=0,O80=\"\"), 0, O75/O80)","v":"0"},{"$f":"IF(OR(P80=0,P80=\"\"), 0, P75/P80)","v":"0"},{"$f":"IF(OR(Q80=0,Q80=\"\"), 0, Q75/Q80)","v":"0"},{"$f":"IF(OR(R80=0,R80=\"\"), 0, R75/R80)","v":"0"},{"$f":"IF(OR(S80=0,S80=\"\"), 0, S75/S80)","v":"0"},{"$f":"IF(OR(T80=0,T80=\"\"), 0, T75/T80)","v":"0"},{"$f":"IF(OR(U80=0,U80=\"\"), 0, U75/U80)","v":"0"},{"$f":"IF(OR(V80=0,V80=\"\"), 0, V75/V80)","v":"0"},{"$f":"IF(OR(W80=0,W80=\"\"), 0, W75/W80)","v":"0"},{"$f":"IF(OR(X80=0,X80=\"\"), 0, X75/X80)","v":"0"},{"$f":"IF(OR(Y80=0,Y80=\"\"), 0, Y75/Y80)","v":"0"},{"$f":"IF(OR(Z80=0,Z80=\"\"), 0, Z75/Z80)","v":"0"},{"$f":"IF(OR(AA80=0,AA80=\"\"), 0, AA75/AA80)","v":"0"},{"$f":"IF(OR(AB80=0,AB80=\"\"), 0, AB75/AB80)","v":"0"},{"$f":"IF(OR(AC80=0,AC80=\"\"), 0, AC75/AC80)","v":"0"},{"$f":"IF(OR(AD80=0,AD80=\"\"), 0, AD75/AD80)","v":"0"},{"$f":"IF(OR(AE80=0,AE80=\"\"), 0, AE75/AE80)","v":"0"},{"$f":"IF(OR(AF80=0,AF80=\"\"), 0, AF75/AF80)","v":"0"},{"$f":"IF(OR(AG80=0,AG80=\"\"), 0, AG75/AG80)","v":"0"},{"$f":"IF(OR(AH80=0,AH80=\"\"), 0, AH75/AH80)","v":"0"},{"$f":"IF(OR(AI80=0,AI80=\"\"), 0, AI75/AI80)","v":"0"},{"$f":"IF(OR(AJ80=0,AJ80=\"\"), 0, AJ75/AJ80)","v":"0"},{"$f":"IF(OR(AK80=0,AK80=\"\"), 0, AK75/AK80)","v":"0"},{"$f":"IF(OR(AL80=0,AL80=\"\"), 0, AL75/AL80)","v":"0"},{"$f":"IF(OR(AM80=0,AM80=\"\"), 0, AM75/AM80)","v":"0"},{"$f":"IF(OR(AN80=0,AN80=\"\"), 0, AN75/AN80)","v":"0"},{"$f":"IF(OR(AO80=0,AO80=\"\"), 0, AO75/AO80)","v":"0"},{"$f":"IF(OR(AP80=0,AP80=\"\"), 0, AP75/AP80)","v":"0"},{"$f":"IF(OR(AQ80=0,AQ80=\"\"), 0, AQ75/AQ80)","v":"0"},{"$f":"IF(OR(AR80=0,AR80=\"\"), 0, AR75/AR80)","v":"0"},{"$f":"IF(OR(AS80=0,AS80=\"\"), 0, AS75/AS80)","v":"0"},{"$f":"IF(OR(AT80=0,AT80=\"\"), 0, AT75/AT80)","v":"0"},{"$f":"IF(OR(AU80=0,AU80=\"\"), 0, AU75/AU80)","v":"0"},{"$f":"IF(OR(AV80=0,AV80=\"\"), 0, AV75/AV80)","v":"0"},{"$f":"IF(OR(AW80=0,AW80=\"\"), 0, AW75/AW80)","v":"0"},{"$f":"IF(OR(AX80=0,AX80=\"\"), 0, AX75/AX80)","v":"0"},{"$f":"IF(OR(AY80=0,AY80=\"\"), 0, AY75/AY80)","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"},{"$f":"IF(OR(H80=0,H80=\"\"), 0, H76/H80)","v":"0"},{"$f":"IF(OR(I80=0,I80=\"\"), 0, I76/I80)","v":"0"},{"$f":"IF(OR(J80=0,J80=\"\"), 0, J76/J80)","v":"0"},{"$f":"IF(OR(K80=0,K80=\"\"), 0, K76/K80)","v":"0"},{"$f":"IF(OR(L80=0,L80=\"\"), 0, L76/L80)","v":"0"},{"$f":"IF(OR(M80=0,M80=\"\"), 0, M76/M80)","v":"0"},{"$f":"IF(OR(N80=0,N80=\"\"), 0, N76/N80)","v":"0"},{"$f":"IF(OR(O80=0,O80=\"\"), 0, O76/O80)","v":"0"},{"$f":"IF(OR(P80=0,P80=\"\"), 0, P76/P80)","v":"0"},{"$f":"IF(OR(Q80=0,Q80=\"\"), 0, Q76/Q80)","v":"0"},{"$f":"IF(OR(R80=0,R80=\"\"), 0, R76/R80)","v":"0"},{"$f":"IF(OR(S80=0,S80=\"\"), 0, S76/S80)","v":"0"},{"$f":"IF(OR(T80=0,T80=\"\"), 0, T76/T80)","v":"0"},{"$f":"IF(OR(U80=0,U80=\"\"), 0, U76/U80)","v":"0"},{"$f":"IF(OR(V80=0,V80=\"\"), 0, V76/V80)","v":"0"},{"$f":"IF(OR(W80=0,W80=\"\"), 0, W76/W80)","v":"0"},{"$f":"IF(OR(X80=0,X80=\"\"), 0, X76/X80)","v":"0"},{"$f":"IF(OR(Y80=0,Y80=\"\"), 0, Y76/Y80)","v":"0"},{"$f":"IF(OR(Z80=0,Z80=\"\"), 0, Z76/Z80)","v":"0"},{"$f":"IF(OR(AA80=0,AA80=\"\"), 0, AA76/AA80)","v":"0"},{"$f":"IF(OR(AB80=0,AB80=\"\"), 0, AB76/AB80)","v":"0"},{"$f":"IF(OR(AC80=0,AC80=\"\"), 0, AC76/AC80)","v":"0"},{"$f":"IF(OR(AD80=0,AD80=\"\"), 0, AD76/AD80)","v":"0"},{"$f":"IF(OR(AE80=0,AE80=\"\"), 0, AE76/AE80)","v":"0"},{"$f":"IF(OR(AF80=0,AF80=\"\"), 0, AF76/AF80)","v":"0"},{"$f":"IF(OR(AG80=0,AG80=\"\"), 0, AG76/AG80)","v":"0"},{"$f":"IF(OR(AH80=0,AH80=\"\"), 0, AH76/AH80)","v":"0"},{"$f":"IF(OR(AI80=0,AI80=\"\"), 0, AI76/AI80)","v":"0"},{"$f":"IF(OR(AJ80=0,AJ80=\"\"), 0, AJ76/AJ80)","v":"0"},{"$f":"IF(OR(AK80=0,AK80=\"\"), 0, AK76/AK80)","v":"0"},{"$f":"IF(OR(AL80=0,AL80=\"\"), 0, AL76/AL80)","v":"0"},{"$f":"IF(OR(AM80=0,AM80=\"\"), 0, AM76/AM80)","v":"0"},{"$f":"IF(OR(AN80=0,AN80=\"\"), 0, AN76/AN80)","v":"0"},{"$f":"IF(OR(AO80=0,AO80=\"\"), 0, AO76/AO80)","v":"0"},{"$f":"IF(OR(AP80=0,AP80=\"\"), 0, AP76/AP80)","v":"0"},{"$f":"IF(OR(AQ80=0,AQ80=\"\"), 0, AQ76/AQ80)","v":"0"},{"$f":"IF(OR(AR80=0,AR80=\"\"), 0, AR76/AR80)","v":"0"},{"$f":"IF(OR(AS80=0,AS80=\"\"), 0, AS76/AS80)","v":"0"},{"$f":"IF(OR(AT80=0,AT80=\"\"), 0, AT76/AT80)","v":"0"},{"$f":"IF(OR(AU80=0,AU80=\"\"), 0, AU76/AU80)","v":"0"},{"$f":"IF(OR(AV80=0,AV80=\"\"), 0, AV76/AV80)","v":"0"},{"$f":"IF(OR(AW80=0,AW80=\"\"), 0, AW76/AW80)","v":"0"},{"$f":"IF(OR(AX80=0,AX80=\"\"), 0, AX76/AX80)","v":"0"},{"$f":"IF(OR(AY80=0,AY80=\"\"), 0, AY76/AY80)","v":"0"}]
[null,"4.19","Incurred Claims",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D77/D80)","v":"$827.37"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E77/E80)","v":"1001.2942"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F77/F80)","v":"857.5364"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G77/G80)","v":"829.53"},{"$f":"IF(OR(H80=0,H80=\"\"), 0, H77/H80)","v":"688.2131"},{"$f":"IF(OR(I80=0,I80=\"\"), 0, I77/I80)","v":"819.5094"},{"$f":"IF(OR(J80=0,J80=\"\"), 0, J77/J80)","v":"823.4919"},{"$f":"IF(OR(K80=0,K80=\"\"), 0, K77/K80)","v":"815.6553"},{"$f":"IF(OR(L80=0,L80=\"\"), 0, L77/L80)","v":"813.9851"},{"$f":"IF(OR(M80=0,M80=\"\"), 0, M77/M80)","v":"723.7993"},{"$f":"IF(OR(N80=0,N80=\"\"), 0, N77/N80)","v":"648.9013"},{"$f":"IF(OR(O80=0,O80=\"\"), 0, O77/O80)","v":"835.0542"},{"$f":"IF(OR(P80=0,P80=\"\"), 0, P77/P80)","v":"813.7282"},{"$f":"IF(OR(Q80=0,Q80=\"\"), 0, Q77/Q80)","v":"986.5202"},{"$f":"IF(OR(R80=0,R80=\"\"), 0, R77/R80)","v":"938.8578"},{"$f":"IF(OR(S80=0,S80=\"\"), 0, S77/S80)","v":"829.7869"},{"$f":"IF(OR(T80=0,T80=\"\"), 0, T77/T80)","v":"801.9089"},{"$f":"IF(OR(U80=0,U80=\"\"), 0, U77/U80)","v":"820.794"},{"$f":"IF(OR(V80=0,V80=\"\"), 0, V77/V80)","v":"799.2111"},{"$f":"IF(OR(W80=0,W80=\"\"), 0, W77/W80)","v":"789.0619"},{"$f":"IF(OR(X80=0,X80=\"\"), 0, X77/X80)","v":"822.3357"},{"$f":"IF(OR(Y80=0,Y80=\"\"), 0, Y77/Y80)","v":"0"},{"$f":"IF(OR(Z80=0,Z80=\"\"), 0, Z77/Z80)","v":"819.8947"},{"$f":"IF(OR(AA80=0,AA80=\"\"), 0, AA77/AA80)","v":"813.8566"},{"$f":"IF(OR(AB80=0,AB80=\"\"), 0, AB77/AB80)","v":"806.02"},{"$f":"IF(OR(AC80=0,AC80=\"\"), 0, AC77/AC80)","v":"804.3499"},{"$f":"IF(OR(AD80=0,AD80=\"\"), 0, AD77/AD80)","v":"804.3499"},{"$f":"IF(OR(AE80=0,AE80=\"\"), 0, AE77/AE80)","v":"977.0134"},{"$f":"IF(OR(AF80=0,AF80=\"\"), 0, AF77/AF80)","v":"929.351"},{"$f":"IF(OR(AG80=0,AG80=\"\"), 0, AG77/AG80)","v":"820.2801"},{"$f":"IF(OR(AH80=0,AH80=\"\"), 0, AH77/AH80)","v":"792.4022"},{"$f":"IF(OR(AI80=0,AI80=\"\"), 0, AI77/AI80)","v":"811.9296"},{"$f":"IF(OR(AJ80=0,AJ80=\"\"), 0, AJ77/AJ80)","v":"810.5164"},{"$f":"IF(OR(AK80=0,AK80=\"\"), 0, AK77/AK80)","v":"790.2182"},{"$f":"IF(OR(AL80=0,AL80=\"\"), 0, AL77/AL80)","v":"780.0691"},{"$f":"IF(OR(AM80=0,AM80=\"\"), 0, AM77/AM80)","v":"812.9573"},{"$f":"IF(OR(AN80=0,AN80=\"\"), 0, AN77/AN80)","v":"0"},{"$f":"IF(OR(AO80=0,AO80=\"\"), 0, AO77/AO80)","v":"0"},{"$f":"IF(OR(AP80=0,AP80=\"\"), 0, AP77/AP80)","v":"0"},{"$f":"IF(OR(AQ80=0,AQ80=\"\"), 0, AQ77/AQ80)","v":"0"},{"$f":"IF(OR(AR80=0,AR80=\"\"), 0, AR77/AR80)","v":"0"},{"$f":"IF(OR(AS80=0,AS80=\"\"), 0, AS77/AS80)","v":"0"},{"$f":"IF(OR(AT80=0,AT80=\"\"), 0, AT77/AT80)","v":"0"},{"$f":"IF(OR(AU80=0,AU80=\"\"), 0, AU77/AU80)","v":"0"},{"$f":"IF(OR(AV80=0,AV80=\"\"), 0, AV77/AV80)","v":"0"},{"$f":"IF(OR(AW80=0,AW80=\"\"), 0, AW77/AW80)","v":"0"},{"$f":"IF(OR(AX80=0,AX80=\"\"), 0, AX77/AX80)","v":"0"},{"$f":"IF(OR(AY80=0,AY80=\"\"), 0, AY77/AY80)","v":"0"}]
[null,"4.20","Risk Adjustment Transfer Amount",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D78/D80)","v":"-$173.14"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E78/E80)","v":"-173.14"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F78/F80)","v":"-173.14"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G78/G80)","v":"-173.14"},{"$f":"IF(OR(H80=0,H80=\"\"), 0, H78/H80)","v":"-173.14"},{"$f":"IF(OR(I80=0,I80=\"\"), 0, I78/I80)","v":"-173.14"},{"$f":"IF(OR(J80=0,J80=\"\"), 0, J78/J80)","v":"-173.14"},{"$f":"IF(OR(K80=0,K80=\"\"), 0, K78/K80)","v":"-173.14"},{"$f":"IF(OR(L80=0,L80=\"\"), 0, L78/L80)","v":"-173.14"},{"$f":"IF(OR(M80=0,M80=\"\"), 0, M78/M80)","v":"-173.14"},{"$f":"IF(OR(N80=0,N80=\"\"), 0, N78/N80)","v":"-173.14"},{"$f":"IF(OR(O80=0,O80=\"\"), 0, O78/O80)","v":"-173.14"},{"$f":"IF(OR(P80=0,P80=\"\"), 0, P78/P80)","v":"-173.14"},{"$f":"IF(OR(Q80=0,Q80=\"\"), 0, Q78/Q80)","v":"-173.14"},{"$f":"IF(OR(R80=0,R80=\"\"), 0, R78/R80)","v":"-173.14"},{"$f":"IF(OR(S80=0,S80=\"\"), 0, S78/S80)","v":"-173.14"},{"$f":"IF(OR(T80=0,T80=\"\"), 0, T78/T80)","v":"-173.14"},{"$f":"IF(OR(U80=0,U80=\"\"), 0, U78/U80)","v":"-173.14"},{"$f":"IF(OR(V80=0,V80=\"\"), 0, V78/V80)","v":"-173.14"},{"$f":"IF(OR(W80=0,W80=\"\"), 0, W78/W80)","v":"-173.14"},{"$f":"IF(OR(X80=0,X80=\"\"), 0, X78/X80)","v":"-173.14"},{"$f":"IF(OR(Y80=0,Y80=\"\"), 0, Y78/Y80)","v":"0"},{"$f":"IF(OR(Z80=0,Z80=\"\"), 0, Z78/Z80)","v":"-173.14"},{"$f":"IF(OR(AA80=0,AA80=\"\"), 0, AA78/AA80)","v":"-173.14"},{"$f":"IF(OR(AB80=0,AB80=\"\"), 0, AB78/AB80)","v":"-173.14"},{"$f":"IF(OR(AC80=0,AC80=\"\"), 0, AC78/AC80)","v":"-173.14"},{"$f":"IF(OR(AD80=0,AD80=\"\"), 0, AD78/AD80)","v":"-173.14"},{"$f":"IF(OR(AE80=0,AE80=\"\"), 0, AE78/AE80)","v":"-173.14"},{"$f":"IF(OR(AF80=0,AF80=\"\"), 0, AF78/AF80)","v":"-173.14"},{"$f":"IF(OR(AG80=0,AG80=\"\"), 0, AG78/AG80)","v":"-173.14"},{"$f":"IF(OR(AH80=0,AH80=\"\"), 0, AH78/AH80)","v":"-173.14"},{"$f":"IF(OR(AI80=0,AI80=\"\"), 0, AI78/AI80)","v":"-173.14"},{"$f":"IF(OR(AJ80=0,AJ80=\"\"), 0, AJ78/AJ80)","v":"-173.14"},{"$f":"IF(OR(AK80=0,AK80=\"\"), 0, AK78/AK80)","v":"-173.14"},{"$f":"IF(OR(AL80=0,AL80=\"\"), 0, AL78/AL80)","v":"-173.14"},{"$f":"IF(OR(AM80=0,AM80=\"\"), 0, AM78/AM80)","v":"-173.14"},{"$f":"IF(OR(AN80=0,AN80=\"\"), 0, AN78/AN80)","v":"0"},{"$f":"IF(OR(AO80=0,AO80=\"\"), 0, AO78/AO80)","v":"0"},{"$f":"IF(OR(AP80=0,AP80=\"\"), 0, AP78/AP80)","v":"0"},{"$f":"IF(OR(AQ80=0,AQ80=\"\"), 0, AQ78/AQ80)","v":"0"},{"$f":"IF(OR(AR80=0,AR80=\"\"), 0, AR78/AR80)","v":"0"},{"$f":"IF(OR(AS80=0,AS80=\"\"), 0, AS78/AS80)","v":"0"},{"$f":"IF(OR(AT80=0,AT80=\"\"), 0, AT78/AT80)","v":"0"},{"$f":"IF(OR(AU80=0,AU80=\"\"), 0, AU78/AU80)","v":"0"},{"$f":"IF(OR(AV80=0,AV80=\"\"), 0, AV78/AV80)","v":"0"},{"$f":"IF(OR(AW80=0,AW80=\"\"), 0, AW78/AW80)","v":"0"},{"$f":"IF(OR(AX80=0,AX80=\"\"), 0, AX78/AX80)","v":"0"},{"$f":"IF(OR(AY80=0,AY80=\"\"), 0, AY78/AY80)","v":"0"}]
[null,"4.21","Premium",{"$f":"IF(OR(D80=0,D80=\"\"), 0, D79/D80)","v":"$1,250.99"},{"$f":"IF(OR(E80=0,E80=\"\"), 0, E79/E80)","v":"1461.335"},{"$f":"IF(OR(F80=0,F80=\"\"), 0, F79/F80)","v":"1287.5565"},{"$f":"IF(OR(G80=0,G80=\"\"), 0, G79/G80)","v":"1253.6036"},{"$f":"IF(OR(H80=0,H80=\"\"), 0, H79/H80)","v":"1082.7471"},{"$f":"IF(OR(I80=0,I80=\"\"), 0, I79/I80)","v":"1241.4359"},{"$f":"IF(OR(J80=0,J80=\"\"), 0, J79/J80)","v":"1246.3533"},{"$f":"IF(OR(K80=0,K80=\"\"), 0, K79/K80)","v":"1236.8232"},{"$f":"IF(OR(L80=0,L80=\"\"), 0, L79/L80)","v":"1234.7546"},{"$f":"IF(OR(M80=0,M80=\"\"), 0, M79/M80)","v":"1125.73"},{"$f":"IF(OR(N80=0,N80=\"\"), 0, N79/N80)","v":"1035.2566"},{"$f":"IF(OR(O80=0,O80=\"\"), 0, O79/O80)","v":"1260.4237"},{"$f":"IF(OR(P80=0,P80=\"\"), 0, P79/P80)","v":"1234.4355"},{"$f":"IF(OR(Q80=0,Q80=\"\"), 0, Q79/Q80)","v":"1443.3549"},{"$f":"IF(OR(R80=0,R80=\"\"), 0, R79/R80)","v":"1385.9182"},{"$f":"IF(OR(S80=0,S80=\"\"), 0, S79/S80)","v":"1253.9516"},{"$f":"IF(OR(T80=0,T80=\"\"), 0, T79/T80)","v":"1220.2087"},{"$f":"IF(OR(U80=0,U80=\"\"), 0, U79/U80)","v":"1243.0224"},{"$f":"IF(OR(V80=0,V80=\"\"), 0, V79/V80)","v":"1216.8434"},{"$f":"IF(OR(W80=0,W80=\"\"), 0, W79/W80)","v":"1204.6073"},{"$f":"IF(OR(X80=0,X80=\"\"), 0, X79/X80)","v":"1244.9266"},{"$f":"IF(OR(Y80=0,Y80=\"\"), 0, Y79/Y80)","v":"0"},{"$f":"IF(OR(Z80=0,Z80=\"\"), 0, Z79/Z80)","v":"1241.9104"},{"$f":"IF(OR(AA80=0,AA80=\"\"), 0, AA79/AA80)","v":"1234.5962"},{"$f":"IF(OR(AB80=0,AB80=\"\"), 0, AB79/AB80)","v":"1225.1764"},{"$f":"IF(OR(AC80=0,AC80=\"\"), 0, AC79/AC80)","v":"1223.2522"},{"$f":"IF(OR(AD80=0,AD80=\"\"), 0, AD79/AD80)","v":"1223.2522"},{"$f":"IF(OR(AE80=0,AE80=\"\"), 0, AE79/AE80)","v":"1431.8784"},{"$f":"IF(OR(AF80=0,AF80=\"\"), 0, AF79/AF80)","v":"1374.2565"},{"$f":"IF(OR(AG80=0,AG80=\"\"), 0, AG79/AG80)","v":"1242.3874"},{"$f":"IF(OR(AH80=0,AH80=\"\"), 0, AH79/AH80)","v":"1208.6401"},{"$f":"IF(OR(AI80=0,AI80=\"\"), 0, AI79/AI80)","v":"1232.3599"},{"$f":"IF(OR(AJ80=0,AJ80=\"\"), 0, AJ79/AJ80)","v":"1230.6085"},{"$f":"IF(OR(AK80=0,AK80=\"\"), 0, AK79/AK80)","v":"1206.0563"},{"$f":"IF(OR(AL80=0,AL80=\"\"), 0, AL79/AL80)","v":"1193.7622"},{"$f":"IF(OR(AM80=0,AM80=\"\"), 0, AM79/AM80)","v":"1233.4802"},{"$f":"IF(OR(AN80=0,AN80=\"\"), 0, AN79/AN80)","v":"0"},{"$f":"IF(OR(AO80=0,AO80=\"\"), 0, AO79/AO80)","v":"0"},{"$f":"IF(OR(AP80=0,AP80=\"\"), 0, AP79/AP80)","v":"0"},{"$f":"IF(OR(AQ80=0,AQ80=\"\"), 0, AQ79/AQ80)","v":"0"},{"$f":"IF(OR(AR80=0,AR80=\"\"), 0, AR79/AR80)","v":"0"},{"$f":"IF(OR(AS80=0,AS80=\"\"), 0, AS79/AS80)","v":"0"},{"$f":"IF(OR(AT80=0,AT80=\"\"), 0, AT79/AT80)","v":"0"},{"$f":"IF(OR(AU80=0,AU80=\"\"), 0, AU79/AU80)","v":"0"},{"$f":"IF(OR(AV80=0,AV80=\"\"), 0, AV79/AV80)","v":"0"},{"$f":"IF(OR(AW80=0,AW80=\"\"), 0, AW79/AW80)","v":"0"},{"$f":"IF(OR(AX80=0,AX80=\"\"), 0, AX79/AX80)","v":"0"},{"$f":"IF(OR(AY80=0,AY80=\"\"), 0, AY79/AY80)","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":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}]