{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Start Here","Formula Reference","Company Information","Pt 1 Summary of Data","Pt 2 Premium and Claims","Pt 3 MLR and Rebate Calculation","Pt 4 Rebate Disbursement","Pt 5 Additional Responses","PY Rebate Liability","Attestation","Reference Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":26,"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":"Start Here","index":0,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INSTRUCTIONS FOR USING THE MLR CALCULATOR WITH THE 2017 MLR ANNUAL REPORTING FORM"]
[null,"(VERSION 3)"]
[null,"The 2017 MLR Annual Reporting Form does not automatically perform the MLR and rebate calculations.  When a completed form is submitted, CMS' Health Insurance Oversight System (HIOS) will alert companies if their submitted values do not match HIOS calculated values."]
[null,"Companies may do the MLR and rebate calculations themselves, following the 2017 MLR Annual Reporting Form Filing Instructions.  For the user's convenience, all 2017 MLR and rebate formulas are summarized on the Formula Reference tab of this file."]
[null,"Companies may also use this MLR Calculator file to perform and/or verify their MLR and rebate calculations for the 2017 MLR reporting year.  To use the MLR Calculator, please follow Steps 1−5 below.  For your convenience, you can also choose to have this MLR Calculator copy all data entered in this file to the HIOS template file you specify, or vice versa.*  You can also copy data already entered into another version of the 2017 MLR Calculator .xlsm file by entering that file's name in the box below (cell B23) and clicking on the \"Copy from HIOS Template to Calculator\" button.\n  *You may need to enable macros to use the optional MLR Calculator copy functionality; please contact your IT department for assistance."]
[]
[null,"Step 1.  Download the HIOS template file(s) from the HIOS MLR module.  You must use these template file(s) to submit MLR data through HIOS.  Do not attempt to upload the MLR Form posted on the MLR page of CCIIO's website, or this MLR Calculator file, into HIOS."]
[]
[null,"Step 2.  Make sure that this MLR Calculator file is placed in and opened from the same folder as the destination HIOS template file."]
[]
[null,"Step 3."]
[null,"(a) To ensure that the MLR Calculator functions correctly, do NOT insert or delete rows or columns anywhere in this file."]
[null,"(b) Populate \"Business in the State of\" and \"Federal Tax Exempt\" fields on the Company Information tab of this MLR Calculator file."]
[null,"(c) Populate all relevant blank cells on Parts 1, 2, and 3 of this MLR Calculator file.  Do not alter the green cells, as these contain formulas."]
[null,"(i) Optionally, populate all relevant blank cells on Parts 4 and 5, if you wish the MLR Calculator to automatically copy these data to the HIOS template.  "]
[null,"(ii) Optionally, copy the select rows (Part 3, Lines 1.8-1.9, 2.3, 4.5, 6.1, 6.4) from the 2015 and 2016 MLR Forms to the \"PY Rebate Liability\" tab, if you wish the MLR Calculator to automatically allocate the previously paid rebate liability for Part 3 Line 5.6.  "]
[]
[null,"Step 4.  Do one of the following:"]
[null,"(i) Use the calculated fields (green cells) in Parts 1, 2, 3, and 4 of this Calculator file to complete the corresponding fields of your HIOS template file.  Make sure to use \"Paste Special: Values\" option in order to avoid pasting formulas into the HIOS template file; OR "]
[null,"(ii) To have the MLR Calculator copy all data to your HIOS template file, enter the destination HIOS template filename in the box below (cell B23), and click the \"Copy from Calculator to HIOS Template\" button below it.*\n  *Please note that if you use the MLR Calculator copy functionality, all fields (both white and green cells) on all Parts (1-5) will be copied over."]
[]
[null,"MLR_Template_Alaska.xlsx"]
[]
[]
[]
[null,"Step 5.  Review the HIOS template file to ensure that it has been correctly and accurately populated before saving it.  Remember to complete any remaining Parts, as required."]
[]
[null,"Please note that the \"Copy from HIOS Template to Calculator\" button is only useful for identifying errors in a 2017 reporting year submission; it will not copy data from a prior year template into this MLR Calculator."]

{"sheet":"Formula Reference","index":1,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["2017 MLR Annual Reporting Form: Formula Resource"]
["2017 Form Line","2017 Form Calculation References"]
["Part 1 Line 1.1\n(Total direct premium earned)","Part 2 Lines 1.1 + 1.2 – 1.3 – 1.7 + 1.8 + 1.9 + 1.10 + 1.11"]
["Part 1 Line 2.1\n(Total incurred claims)","Part 2 Line 2.16\nPlease note that on the 2011 MLR Form, this line was equal to Part 2 Lines 2.16 + 2.17"]
["Part 1 Line 2.11\n(Allowable claims recovered through fraud reduction efforts)","Part 2 Line 2.17"]
["Part 1 Line 4.6\n(Total allowable quality improvement expenses)","At issuer's option, either: Part 1 Lines 4.1 + 4.2 + 4.3 + 4.4 + 4.5 or 0.8% * (Part 2 Lines 1.1 + 1.2 – 1.3 – 1.7 + 1.8)"]
["Part 1 Line 7.5\n(Life-years)","Part 1 Line 7.4 / 12"]
["Part 2 Line 2.16\n(Total incurred claims)","Column \"Total as of 12/31/YY\":\nPart 2 Lines 2.1a + 2.2a – 2.3 + 2.4a – 2.5 + 2.6a – 2.7 + 2.8a + 2.9a – 2.10 + 2.11a + 2.11b – 2.11c – 2.12a + 2.12b + 2.13 + 2.14 + 2.15\n\nAll other columns (\"3/31/YY\", \"Dual Contract\", \"Deferred PY1\", \"Deferred CY\"):\nPart 2 Lines 2.1b + 2.2b + 2.4b + 2.6b – 2.7 + 2.8b + 2.9b + 2.11a + 2.11b – 2.12a + 2.13 + 2.14 + 2.15\n"]
["Part 2 Line 2.17\n(Allowable claims recovered through fraud reduction efforts)","The lesser of: Part 2 Line 2.17a or 2.17b"]
["Part 3 Line 1.1\n(Adjusted incurred claims as reported on MLR Form for prior year(s))","Column \"PY2\":\n2015 MLR Form, Part 1 Lines 2.1 + 2.11, Columns \"3/31/YY\" + \"Deferred PY\" – \"Deferred CY\"\n\nColumn \"PY1\":\n2016 MLR Form, Part 1 Lines 2.1 + 2.11, Columns \"3/31/YY\" + \"Deferred PY\" – \"Deferred CY\""]
["Part 3 Line 1.2\n(Adjusted incurred claims as of 3/31 of the year following the MLR reporting year)","Column \"PY2\":\nAdjusted claims incurred in the 2015 MLR reporting year, restated as of 3/31/18\n\nColumn \"PY1\":\nAdjusted claims incurred in the 2016 MLR reporting year, restated as of 3/31/18\n\nColumn \"CY\":\nPart 1 Lines 2.1 + 2.11, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\"\n\nColumn \"Total\":\nPart 3 Line 1.2, Columns PY2 + PY1 + CY\n"]
["Part 3 Line 1.3\n(Quality improvement expenses)","Column \"PY2\":\n2015 MLR Form, Part 1 Lines 4.1 + 4.2 + 4.3 + 4.4 + 4.5 + 4.6, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\"\n\nColumn \"PY1\":\n2016 MLR Form, Part 1 Lines 4.1 + 4.2 + 4.3 + 4.4 + 4.5, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\"\n\nColumn \"CY\":\nPart 1 Line 4.6, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\"\n\nColumn \"Total\":\nPart 3 Line 1.3, Columns PY2 + PY1 + CY\n"]
["Part 3 Line 1.4\n(Cost-sharing reduction payments)","Column \"CY\":\nPart 2, Line 2.18, Columns \"3/31/YY\" + \"Deferred PY\" – \"Deferred CY\"\n\nColumn \"Total\":\nPart 3 Line 1.4, Columns PY2 + PY1 + CY\n"]
["Part 3 Line 1.5\n(Federal Transitional Reinsurance Program payments)","Column \"Total\":\nPart 3 Line 1.5, Columns PY2 + PY1 + CY"]
["Part 3 Line 1.6\n(Federal Risk Adjustment Program payments or charges)","Column \"CY\":\nPart 2 Line 1.10, Columns \"3/31/YY\" + \"Deferred PY\" – \"Deferred CY\"\n\nColumn \"Total\":\nPart 3 Line 1.6, Columns PY2 + PY1 + CY\n"]
["Part 3 Line 1.7\n(Federal Risk Corridors Program payments or charges)","Column \"Total\":\nPart 3 Line 1.7, Columns PY2 + PY1 + CY"]
["Part 3 Line 1.8\n(MLR numerator)","Individual, Small Group, and Large Group Columns \"PY2\", \"PY1,\" \"CY,\" and \"Total,\" except DC, MA, and VT merged markets:\nPart 3, Lines 1.2 + 1.3 – 1.4 – 1.5 – 1.6 – 1.7\nIndividual and Small Group Columns \"CY\" and \"Total\", if Business State is DC, MA, or VT:\n(Part 3, Individual Column, Lines 1.2 + 1.3 – 1.4 – 1.5 – 1.6 – 1.7) + (Part 3, Small Group Column, Lines 1.2 + 1.3 – 1.4 – 1.5 – 1.6 – 1.7)\n"]
["Part 3 Line 1.9\n(MLR numerator: Mini-Med and Student Health Plans)","Mini-Med Columns \"PY2\", \"PY1\", \"CY\", and \"Total\", except DC, MA, and VT merged markets:\nPart 3 Lines 1.2 + 1.3\nMini-Med Individual and Small Group Columns \"PY2\", \"PY1\", \"CY\", and \"Total\", if Business State is DC, MA, or VT:\n(Part 3, Mini-Med Individual Column, Lines 1.2 + 1.3) + (Part 3, Mini-Med Small Group Column, Lines 1.2 + 1.3)\n\nStudent Health Plans Columns \"PY2\", \"PY1\", \"CY\" and \"Total\":\nPart 3, Lines 1.2 + 1.3\n"]
["Part 3 Line 2.1\n(Premium earned including Federal and State high risk programs)","Columns \"PY2\" and \"PY1\":\n2015 (for \"PY2\") and 2016 (for \"PY1\") MLR Forms, respectively,\n(Part 1 Lines 1.1 + 1.2 + 1.3, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\") – (Part 3 Lines 1.5 + 1.6 + 1.7, Column \"CY\")\n\nColumn \"CY\":\n(Part 1 Lines 1.1 + 1.2 + 1.3, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\") – (Part 3 Lines 1.5 + 1.6 + 1.7, Column \"CY\") – Part 3 Line 6.1a\n\nColumn \"Total\":\nPart 3 Line 2.1, Columns PY2 + PY1 + CY\n"]
["Part 3 Line 2.2\n(Federal and State taxes and licensing or regulatory fees)","Columns \"PY2\" and \"PY1\":\n2015 (for \"PY2\") and 2016 (for \"PY1\") MLR Forms, respectively,\nFederal Tax-Exempt Issuers:\n(Part 1 Lines 3.1a + 3.1b + 3.1c + 3.1d + 3.2a + 3.2b + 3.2c + 3.3a + 3.3b, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\")\nNon Federal Tax-Exempt Issuers:\n(Part 1 Lines 3.1a + 3.1b + 3.1c + 3.1d + 3.2a, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\") + [The greater of: (Part 1 Line 3.2b, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\") or (Part 1 Line 3.2c, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\")] + (Part 1 Line 3.3a + 3.3b, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\")\n\nColumn \"CY\":\nFederal Tax-Exempt Issuers:\n(Part 1 Line 3.1a + 3.1b + 3.1c + 3.1d + 3.2a + 3.2b + 3.2c + 3.3a + 3.3b, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\") – Part 3 Line 6.1b\nNon Federal Tax-Exempt Issuers:\n(Part 1 Line 3.1a + 3.1b + 3.1c + 3.1d + 3.2a, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\") + [The greater of: (Part 1 Line 3.2b, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\") or (Part 1 Line 3.2c, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\")] + (Part 1 Lines 3.3a + 3.3b, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\") – Part 3 Line 6.1b\n\nColumn \"Total\":\nPart 3 Line 2.2, Columns PY2 + PY1 + CY\n"]
["Part 3 Line 2.3\n(MLR denominator)","Individual, Small Group, and Large Group Columns, except DC, MA, and VT merged markets:\nPart 3, Lines 2.1 – 2.2\n\nIndividual and Small Group Columns, if Business State is DC, MA, or VT:\n(Part 3, Individual Column, Lines 2.1 – 2.2) + (Part 3, Small Group Column, Lines 2.1 – 2.2)\n"]
["Part 3 Line 3.1\n(Life-years to determine credibility)","Columns \"PY2\" and \"PY1\", except DC, MA, and VT merged markets:\n2015 (for \"PY2\") and 2016 (for \"PY1\") MLR Forms, respectively,\nPart 1 Line 7.5, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\" \nColumns \"PY2\" and \"PY1\", Individual and Small Group Columns, if Business State is DC, MA, or VT:\n2015 (for \"PY2\") and 2016 (for \"PY1\") MLR Forms, respectively \n(Part 1 Line 7.5, Individual Columns \"3/31/YY\" + \"Deferred PY\" – \"Deferred CY\") + (Part 1 Line 7.5, Small Group Columns \"3/31/YY\" + \"Deferred PY\" – \"Deferred CY\")\n\nColumn \"CY\", except DC, MA, and VT merged markets:\nPart 1 Line 7.5, Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\" \nColumn \"CY\", Individual and Small Group Columns, if Business State is DC, MA, or VT:\n(Part 1 Line 7.5, Individual Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\") + (Part 1 Line 7.5, Small Group Columns \"3/31/YY\" + \"Deferred PY1\" – \"Deferred CY\")\n\nColumn \"Total\":\nPart 3 Line 3.1, Columns PY2 + PY1 + CY\n"]
["Part 3 Line 3.2\n(Base credibility factor)","Column \"Total\":\n   ● if Column \"Total\" Part 3 Line 3.1 < 1,000 or ≥ 75,000: \n      0 (zero)\n   ● if Column \"PY2\" Part 3 Line 3.1 ≥ 1,000 and Line 4.1a or 4.1b < Line 5.1, and \n         Column \"PY1\" Part 3 Line 3.1 ≥ 1,000 and Line 4.1a or 4.1b < Line 5.1, and\n         Column \"CY\"   Part 3 Line 3.1 ≥ 1,000 and Line 4.1a or 4.1b < Line 5.1:\n      0 (zero)\n   ● if 1,000 ≤ Column \"Total\" Part 3 Line 3.1 < 75,000 and none of the conditions above apply: \n      Calculate using linear interpolation and Table 1 (do not round)\n\nTable 1:\nLife-Years    Base credibility factor\n   <1,000          0.0%\n     1,000          8.3%\n     2,500          5.2%\n     5,000          3.7%\n   10,000          2.6%\n   25,000          1.6%\n   50,000          1.2%\n ≥75,000          0.0%\n\nLinear Interpolation Formula (x = life-years, y = base credibility factor) where x2 = Part 3 Line 3.1 Column \"Total\": \ny2 = y1 + [(y3 – y1) / (x3 – x1)] * (x2 – x1)\n\nLinear Interpolation Example:\nThe base credibility factor for 16,525 life-years can be calculated as follows:\n2.6% + [(1.6% – 2.6%) / (25,000 – 10,000)] x (16,525 – 10,000) = 2.6% – 0.435% = 2.165%\n(Note: do not round the base credibility factor when calculating the MLR.  Add the unrounded credibility factor multiplied by the unrounded deductible factor to the unrounded preliminary MLR from Part 3 Line 4.1 Total Column, then round the resulting credibility-adjusted MLR to 3 decimal places (e.g. 80.1%) and enter on Part 3 Line 4.3."]
["Part 3 Line 3.4\n(Deductible factor)","Column \"Total\":\n   ● if Part 3 Line 3.3 < 2,500: \n      1.000\n   ● if Part 3 Line 3.3 ≥ 10,000: \n      1.736\n   ● if 2,500 ≤ Part 3 Line 3.3 < 10,000: \n      Calculate using linear interpolation and Table 2 (do not round).\n\nTable 2:\nAverage Deductible    Deductible factor\n    <2,500                         1.000\n      2,500                         1.164\n      5,000                         1.402\n  ≥10,000                         1.736\n\nLinear Interpolation Formula (x = average health plan deductible, y = deductible factor) where x2 = Part 3 Line 3.3 Column \"Total\": \ny2 = y1 + [(y3 – y1) / (x3 – x1)] * (x2 – x1)\n\nLinear interpolation example:\nThe deductible factor for a $3,500 average deductible can be calculated as follows:\n1.164 + [(1.402 – 1.164) / (5,000 – 2,500)] x (3,500 – 2,500) = 1.164 + 0.0952 = 1.2592\n(Note: do not round the credibility factor multiplied by the deductible factor when calculating the MLR.  Add the unrounded credibility factor multiplied by the unrounded deductible factor to the unrounded preliminary MLR from Part 3 Line 4.1, then round the result to 3 decimal places (e.g. 80.1%) and enter on Part 3 Line 4.3."]
["Part 3 Line 3.5\n(Credibility adjustment)","Column \"Total\":\n   ● if Column \"Total\" Part 3 Line 3.1 < 1,000 or ≥ 75,000: \n      0 (zero)\n   ● if Column \"PY2\" Part 3 Line 3.1 ≥ 1,000 and Line 4.1a or 4.1b < Line 5.1, and \n         Column \"PY1\" Part 3 Line 3.1 ≥ 1,000 and Line 4.1a or 4.1b < Line 5.1, and\n         Column \"CY\"   Part 3 Line 3.1 ≥ 1,000 and Line 4.1a or 4.1b < Line 5.1:\n      0 (zero)\n   ● if 1,000 ≤ Column \"Total\" Part 3 Line 3.1 < 75,000 and none of the conditions above apply: \n      Part 3 Line 3.2 x 3.4 (do not round)\n"]
["Part 3 Line 4.1a\n(Preliminary MLR)","Columns \"PY2\", \"PY1\", \"CY\", \"Total\":\n   ● if Part 3 Line 3.1 < 1,000: \n      blank\n   ● if Part 3 Line 3.1 ≥ 1,000: \n      Part 3 Lines 1.8 / 2.3 (do not round)\n"]
["Part 3 Line 4.1b\n(Preliminary MLR: Mini-Med and Student Health Plans)","Columns \"PY2\", \"PY1\", \"CY\", \"Total\":\n   ● if Part 3 Line 3.1 < 1,000: \n      blank\n   ● if Part 3 Line 3.1 ≥ 1,000: \n      Part 3 Lines 1.9 / 2.3 (do not round)\n"]
["Part 3 Line 4.2\n(Credibility adjustment)\n","Part 3, Line 3.5"]
["Part 3 Line 4.3\n(Credibility-adjusted MLR)","Column \"Total\":\n   ● if Column \"Total\" Part 3 Line 3.1 < 1,000: \n      blank\n   ● if Column \"Total\" Part 3 Line 3.1 ≥ 1,000: \n      Health Insurance Coverage columns:    Part 3 Lines 4.1a + 4.2\n      Mini-Med and Student Health columns:  Part 3 Lines 4.1b + 4.2\n   (round to three decimal places, e.g. 0.801 or 80.1%)\n"]
["Part 3 Line 5.1\n(MLR standard)","Standards deviating from 80% and 85% are highlighted in bold.\n\n                      Individual market         Small Group market            Large Group market\n                      2015  2016  2017        2015  2016  2017              2015  2016  2017\nMA                  88%  88%  88%          88%  88%  88%                85%   85%   85%\nNY                   82%  82%  82%          82%  82%  82%                85%   85%   85%\nNM                  80%  80%  80%         85%  85%  85%                85%   85%   85%\nAll others         80%  80%  80%         80%  80%  80%               85%   85%   85%\n"]
["Part 3 Line 5.2\n(Credibility-adjusted MLR)\n","Part 3, Line 4.3"]
["Part 3 Line 5.3\n(Adjusted earned premium less Federal and State taxes and licensing or regulatory fees)\n","Column \"Total\":\n   ● if Column \"Total\" Part 3 Line 3.1 < 1,000: \n      blank\n   ● if Column \"Total\" Part 3 Line 3.1 ≥ 1,000: \n      Part 3 Column \"CY\", Lines 2.1 – 2.2 (if negative, set to 0 (zero))"]
["Part 3 Line 5.4\n(Rebate amount)","Column \"Total\":\n   ● if Column \"Total\" Part 3 Line 3.1 < 1,000: \n      0 (zero)\n   ● if Column \"Total\" Part 3 Line 3.1 ≥ 1,000 and Part 3 Line 5.2 ≥ Line 5.1: \n      0 (zero)\n   ● if Column \"Total\" Part 3 Line 3.1 ≥ 1,000 and Part 3 Line 5.2 < Line 5.1: \n      Part 3 (Lines 5.1 – 5.2) x Line 5.3\n"]
["Part 3 Line 5.5\n(Single-year rebate liability)","Columns \"PY2\", \"PY1\", \"CY\":\nHealth Insurance Coverage columns: Part 3 Line 2.3 x [Line 5.1 – (Line 4.1a + Line 4.2 Column \"Total\")] (if negative, set to 0 (zero))\nMini-Med and Student Health Plans columns: Part 3 Line 2.3 x [Line 5.1 – (Line 4.1b + Line 4.2 Column \"Total\")] (if negative, set to 0 (zero))\n"]
["Part 3 Line 5.6\n(Paid rebate liability)","See Form Instructions"]
["Part 3 Line 5.7\n(Unpaid rebate liability)","Columns \"PY2\", \"PY1\", \"CY\":\nPart 3 Lines 5.5 – 5.6 (if negative, set to 0 (zero))"]
["Part 3 Line 5.8\n(Limited payable rebate amount)","Column \"PY2\":\nThe lesser of: Part 3 Lines 5.8 x (2.1 – 2.2) / 2.3 Column PY2 or Line 5.4 Column Total\n(the term \"(2.1 – 2.1) / 2.3\" should yield 1.0 except in DC, MA, and VT merged markets)\n\nColumn \"PY1\":\nThe lesser of: Part 3 Line 5.8 x (2.1 – 2.2) / 2.3 Column PY1 or (Line 5.4 Column \"Total\" – Line 5.8 Column \"PY2\")\n(the term \"(2.1 – 2.1) / 2.3\" should yield 1.0 except in DC, MA, and VT merged markets)\n\nColumn \"CY\":\nThe lesser of: Part 3 Line 5.8 x (2.1 – 2.2) / 2.3 Column CY or (Line 5.4 Column \"Total\" – Line 5.8 Column \"PY2\" – Line 5.8 Column \"PY1\")\n(the term \"(2.1 – 2.1) / 2.3\" should yield 1.0 except in DC, MA, and VT merged markets)\n\nColumn \"Total\":\nPart 3 Line 5.8, Columns PY2 + PY1 + CY\n"]

{"sheet":"Company Information","index":2,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Company Information "]
[]
[null,"Line Description","Value"]
[null,"Company Name:"]
[null,"Group Affiliation:"]
[null,"Federal EIN:"]
[null,"A.M. Best Number:"]
[null,"NAIC Group Code:"]
[null,"NAIC Company Code:"]
[null,"DBA / Marketing Name:"]
[null,"HIOS Issuer ID:"]
[null,"Business in the State of:","Alaska"]
[null,"Domiciliary State:"]
[null,"Address:"]
[null,"Federal Tax Exempt:","No"]
[null,"Marketplace:"]
[null,"Merge Markets - Ind/SmGrp:"]
[null,"Not-For-Profit:"]
[null,"MLR Reporting Year:"]

{"sheet":"Pt 1 Summary of Data","index":3,"n_rows":62,"n_cols":47,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[null,"Part 1 Summary of Data"]
[]
[null,"Line Description","SHCE","1\nHealth Insurance\nINDIVIDUAL\nTotal as of 12/31/17","2\nHealth Insurance\nINDIVIDUAL\nTotal as of 3/31/18","3\nHealth Insurance\nINDIVIDUAL\nDual Contracts\n(Included in Total as of 3/31/18)","4\nHealth Insurance\nINDIVIDUAL\nDeferred PY1\n(Add)","5\nHealth Insurance\nINDIVIDUAL\nDeferred CY\n(Subtract)","6\nHealth Insurance\nSMALL GROUP\nTotal as of 12/31/17","7\nHealth Insurance\nSMALL GROUP\nTotal as of 3/31/18","8\nHealth Insurance\nSMALL GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","9\nHealth Insurance\nSMALL GROUP\nDeferred PY1\n(Add)","10\nHealth Insurance\nSMALL GROUP\nDeferred CY\n(Subtract)","11\nHealth Insurance\nLARGE GROUP\nTotal as of 12/31/17","12\nHealth Insurance\nLARGE GROUP\nTotal as of 3/31/18","13\nHealth Insurance\nLARGE GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","14\nHealth Insurance\nLARGE GROUP\nDeferred PY1\n(Add)","15\nHealth Insurance\nLARGE GROUP\nDeferred CY\n(Subtract)","16\nMini-Med\nINDIVIDUAL\nTotal as of 12/31/17","17\nMini-Med\nINDIVIDUAL\nTotal as of 3/31/18","18\nMini-Med\nINDIVIDUAL\nDual Contracts\n(Included in Total as of 3/31/18)","19\nMini-Med\nSMALL GROUP\nTotal as of 12/31/17","20\nMini-Med\nSMALL GROUP\nTotal as of 3/31/18","21\nMini-Med\nSMALL GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","22\nMini-Med\nLARGE GROUP\nTotal as of 12/31/17","23\nMini-Med\nLARGE GROUP\nTotal as of 3/31/18","24\nMini-Med\nLARGE GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","25\nExpat\nSMALL GROUP\nTotal as of 12/31/17","26\nExpat\nSMALL GROUP\nTotal as of 3/31/18","27\nExpat\nSMALL GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","28\nExpat\nSMALL GROUP\nDeferred PY1\n(Add)","29\nExpat\nSMALL GROUP\nDeferred CY\n(Subtract)","30\nExpat\nLARGE GROUP\nTotal as of 12/31/17","31\nExpat\nLARGE GROUP\nTotal as of 3/31/18","32\nExpat\nLARGE GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","33\nExpat\nLARGE GROUP\nDeferred PY1\n(Add)","34\nExpat\nLARGE GROUP\nDeferred CY\n(Subtract)","35\nStudent Health\nINDIVIDUAL\nTotal as of 12/31/17","36\nStudent Health\nINDIVIDUAL\nTotal as of 3/31/18","37\nStudent Health\nINDIVIDUAL\nDual Contracts\n(Included in Total as of 3/31/18)","38\nStudent Health\nINDIVIDUAL\nDeferred PY1\n(Add)","39\nStudent Health\nINDIVIDUAL\nDeferred CY\n(Subtract)","40\nGovernment Program Plans \nTotal as of 12/31/17","41\nOther Health Business \nTotal as of 12/31/17","42\nMedicare MLR Business\nTotal as of 12/31/17","43\nUninsured Plans\nTotal as of 12/31/17","44\nGrand Total\nTotal as of 12/31/17"]
[null,"1. Premium"]
[null,"1.1 Total direct premium earned",null,{"$f":"SUM('Pt 2 Premium and Claims'!D$5,'Pt 2 Premium and Claims'!D$6,-'Pt 2 Premium and Claims'!D$7,-'Pt 2 Premium and Claims'!D$13,'Pt 2 Premium and Claims'!D$14:'Pt 2 Premium and Claims'!D$17)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!E$5,'Pt 2 Premium and Claims'!E$6,-'Pt 2 Premium and Claims'!E$7,-'Pt 2 Premium and Claims'!E$13,'Pt 2 Premium and Claims'!E$14:'Pt 2 Premium and Claims'!E$17)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!F$5,'Pt 2 Premium and Claims'!F$6,-'Pt 2 Premium and Claims'!F$7,-'Pt 2 Premium and Claims'!F$13,'Pt 2 Premium and Claims'!F$14:'Pt 2 Premium and Claims'!F$17)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!G$5,'Pt 2 Premium and Claims'!G$6,-'Pt 2 Premium and Claims'!G$7,-'Pt 2 Premium and Claims'!G$13,'Pt 2 Premium and Claims'!G$14:'Pt 2 Premium and Claims'!G$17)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!H$5,'Pt 2 Premium and Claims'!H$6,-'Pt 2 Premium and Claims'!H$7,-'Pt 2 Premium and Claims'!H$13,'Pt 2 Premium and Claims'!H$14:'Pt 2 Premium and Claims'!H$17)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!I$5,'Pt 2 Premium and Claims'!I$6,-'Pt 2 Premium and Claims'!I$7,-'Pt 2 Premium and Claims'!I$13,'Pt 2 Premium and Claims'!I$14,'Pt 2 Premium and Claims'!I$16:'Pt 2 Premium and Claims'!I$17)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!J$5,'Pt 2 Premium and Claims'!J$6,-'Pt 2 Premium and Claims'!J$7,-'Pt 2 Premium and Claims'!J$13,'Pt 2 Premium and Claims'!J$14,'Pt 2 Premium and Claims'!J$16:'Pt 2 Premium and Claims'!J$17)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!K$5,'Pt 2 Premium and Claims'!K$6,-'Pt 2 Premium and Claims'!K$7,-'Pt 2 Premium and Claims'!K$13,'Pt 2 Premium and Claims'!K$14,'Pt 2 Premium and Claims'!K$16:'Pt 2 Premium and Claims'!K$17)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!L$5,'Pt 2 Premium and Claims'!L$6,-'Pt 2 Premium and Claims'!L$7,-'Pt 2 Premium and Claims'!L$13,'Pt 2 Premium and Claims'!L$14,'Pt 2 Premium and Claims'!L$16:'Pt 2 Premium and Claims'!L$17)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!M$5,'Pt 2 Premium and Claims'!M$6,-'Pt 2 Premium and Claims'!M$7,-'Pt 2 Premium and Claims'!M$13,'Pt 2 Premium and Claims'!M$14,'Pt 2 Premium and Claims'!M$16:'Pt 2 Premium and Claims'!M$17)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!N$5,'Pt 2 Premium and Claims'!N$6,-'Pt 2 Premium and Claims'!N$7,-'Pt 2 Premium and Claims'!N$13,'Pt 2 Premium and Claims'!N$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!O$5,'Pt 2 Premium and Claims'!O$6,-'Pt 2 Premium and Claims'!O$7,-'Pt 2 Premium and Claims'!O$13,'Pt 2 Premium and Claims'!O$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!P$5,'Pt 2 Premium and Claims'!P$6,-'Pt 2 Premium and Claims'!P$7,-'Pt 2 Premium and Claims'!P$13,'Pt 2 Premium and Claims'!P$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!Q$5,'Pt 2 Premium and Claims'!Q$6,-'Pt 2 Premium and Claims'!Q$7,-'Pt 2 Premium and Claims'!Q$13,'Pt 2 Premium and Claims'!Q$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!R$5,'Pt 2 Premium and Claims'!R$6,-'Pt 2 Premium and Claims'!R$7,-'Pt 2 Premium and Claims'!R$13,'Pt 2 Premium and Claims'!R$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!S$5,'Pt 2 Premium and Claims'!S$6,-'Pt 2 Premium and Claims'!S$7,-'Pt 2 Premium and Claims'!S$13,'Pt 2 Premium and Claims'!S$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!T$5,'Pt 2 Premium and Claims'!T$6,-'Pt 2 Premium and Claims'!T$7,-'Pt 2 Premium and Claims'!T$13,'Pt 2 Premium and Claims'!T$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!U$5,'Pt 2 Premium and Claims'!U$6,-'Pt 2 Premium and Claims'!U$7,-'Pt 2 Premium and Claims'!U$13,'Pt 2 Premium and Claims'!U$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!V$5,'Pt 2 Premium and Claims'!V$6,-'Pt 2 Premium and Claims'!V$7,-'Pt 2 Premium and Claims'!V$13,'Pt 2 Premium and Claims'!V$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!W$5,'Pt 2 Premium and Claims'!W$6,-'Pt 2 Premium and Claims'!W$7,-'Pt 2 Premium and Claims'!W$13,'Pt 2 Premium and Claims'!W$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!X$5,'Pt 2 Premium and Claims'!X$6,-'Pt 2 Premium and Claims'!X$7,-'Pt 2 Premium and Claims'!X$13,'Pt 2 Premium and Claims'!X$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!Y$5,'Pt 2 Premium and Claims'!Y$6,-'Pt 2 Premium and Claims'!Y$7,-'Pt 2 Premium and Claims'!Y$13,'Pt 2 Premium and Claims'!Y$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!Z$5,'Pt 2 Premium and Claims'!Z$6,-'Pt 2 Premium and Claims'!Z$7,-'Pt 2 Premium and Claims'!Z$13,'Pt 2 Premium and Claims'!Z$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!AA$5,'Pt 2 Premium and Claims'!AA$6,-'Pt 2 Premium and Claims'!AA$7,-'Pt 2 Premium and Claims'!AA$13,'Pt 2 Premium and Claims'!AA$14)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Pt 2 Premium and Claims'!AL$5,'Pt 2 Premium and Claims'!AL$6,-'Pt 2 Premium and Claims'!AL$7,-'Pt 2 Premium and Claims'!AL$13,'Pt 2 Premium and Claims'!AL$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!AM$5,'Pt 2 Premium and Claims'!AM$6,-'Pt 2 Premium and Claims'!AM$7,-'Pt 2 Premium and Claims'!AM$13,'Pt 2 Premium and Claims'!AM$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!AN$5,'Pt 2 Premium and Claims'!AN$6,-'Pt 2 Premium and Claims'!AN$7,-'Pt 2 Premium and Claims'!AN$13,'Pt 2 Premium and Claims'!AN$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!AO$5,'Pt 2 Premium and Claims'!AO$6,-'Pt 2 Premium and Claims'!AO$7,-'Pt 2 Premium and Claims'!AO$13,'Pt 2 Premium and Claims'!AO$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!AP$5,'Pt 2 Premium and Claims'!AP$6,-'Pt 2 Premium and Claims'!AP$7,-'Pt 2 Premium and Claims'!AP$13,'Pt 2 Premium and Claims'!AP$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!AQ$5,'Pt 2 Premium and Claims'!AQ$6,-'Pt 2 Premium and Claims'!AQ$7,-'Pt 2 Premium and Claims'!AQ$13,'Pt 2 Premium and Claims'!AQ$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!AR$5,'Pt 2 Premium and Claims'!AR$6,-'Pt 2 Premium and Claims'!AR$7,-'Pt 2 Premium and Claims'!AR$13,'Pt 2 Premium and Claims'!AR$14)","v":0},{"$f":"SUM('Pt 2 Premium and Claims'!AS$5,'Pt 2 Premium and Claims'!AS$6,-'Pt 2 Premium and Claims'!AS$7,-'Pt 2 Premium and Claims'!AS$13,'Pt 2 Premium and Claims'!AS$14)","v":0}]
[null,"1.2 Federal high risk pools","Pt 1, Ln 1.2"]
[null,"1.3 State high risk pools","Pt 1, Ln 1.3"]
[null,"1.4 Net assumed less ceded reinsurance premium earned (exclude amounts already reported in Line 1.1)","Pt 1, Ln 1.9"]
[null,"1.5 Other adjustments due to MLR calculations - premium","Pt 1, Ln 1.10"]
[null,"1.6 Risk revenue","Pt 1, Ln 1.11"]
[null,"2. Claims"]
[null,"2.1 Total incurred claims (MLR Form Part 2, Line 2.16)",null,{"$f":"'Pt 2 Premium and Claims'!D$54","v":0},{"$f":"'Pt 2 Premium and Claims'!E$54","v":0},{"$f":"'Pt 2 Premium and Claims'!F$54","v":0},{"$f":"'Pt 2 Premium and Claims'!G$54","v":0},{"$f":"'Pt 2 Premium and Claims'!H$54","v":0},{"$f":"'Pt 2 Premium and Claims'!I$54","v":0},{"$f":"'Pt 2 Premium and Claims'!J$54","v":0},{"$f":"'Pt 2 Premium and Claims'!K$54","v":0},{"$f":"'Pt 2 Premium and Claims'!L$54","v":0},{"$f":"'Pt 2 Premium and Claims'!M$54","v":0},{"$f":"'Pt 2 Premium and Claims'!N$54","v":0},{"$f":"'Pt 2 Premium and Claims'!O$54","v":0},{"$f":"'Pt 2 Premium and Claims'!P$54","v":0},{"$f":"'Pt 2 Premium and Claims'!Q$54","v":0},{"$f":"'Pt 2 Premium and Claims'!R$54","v":0},{"$f":"'Pt 2 Premium and Claims'!S$54","v":0},{"$f":"'Pt 2 Premium and Claims'!T$54","v":0},{"$f":"'Pt 2 Premium and Claims'!U$54","v":0},{"$f":"'Pt 2 Premium and Claims'!V$54","v":0},{"$f":"'Pt 2 Premium and Claims'!W$54","v":0},{"$f":"'Pt 2 Premium and Claims'!X$54","v":0},{"$f":"'Pt 2 Premium and Claims'!Y$54","v":0},{"$f":"'Pt 2 Premium and Claims'!Z$54","v":0},{"$f":"'Pt 2 Premium and Claims'!AA$54","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Pt 2 Premium and Claims'!AL$54","v":0},{"$f":"'Pt 2 Premium and Claims'!AM$54","v":0},{"$f":"'Pt 2 Premium and Claims'!AN$54","v":0},{"$f":"'Pt 2 Premium and Claims'!AO$54","v":0},{"$f":"'Pt 2 Premium and Claims'!AP$54","v":0},{"$f":"'Pt 2 Premium and Claims'!AQ$54","v":0},{"$f":"'Pt 2 Premium and Claims'!AR$54","v":0},{"$f":"'Pt 2 Premium and Claims'!AS$54","v":0}]
[null,"2.2 Prescription drugs (informational only; already included in total incurred claims above)","Pt 1, Ln 2.2"]
[null,"2.3 Pharmaceutical rebates (informational only; already excluded from total incurred claims above)","Pt 1, Ln 2.3"]
[null,"2.4 State stop loss, market stabilization and claim/census based assessments\n(informational only; already excluded from total incurred claims above)","Pt 1, Ln 2.4"]
[null,"2.5 Net assumed less ceded claims incurred (exclude amounts already reported in Line 2.1)","Pt 1, Ln 5.1"]
[null,"2.6 Other adjustments due to MLR calculations – claims incurred","Pt 1, Ln 5.2"]
[null,"2.7 Rebates paid","Pt 1, Ln 5.3"]
[null,"2.8 Estimated rebates unpaid at the end of the previous MLR reporting year","Pt 1, Ln 5.4"]
[null,"2.9 Estimated rebates unpaid at the end of the MLR reporting year","Pt 1, Ln 5.5"]
[null,"2.10 Fee-for-service and co-pay revenue (net of expenses)","Pt 1, Ln 5.6"]
[null,"2.11 Allowable claims recovered through fraud reduction efforts (MLR Form Part 2, Line 2.17)","Pt 1, Ln 4",{"$f":"'Pt 2 Premium and Claims'!D$55","v":0},{"$f":"'Pt 2 Premium and Claims'!E$55","v":0},{"$f":"'Pt 2 Premium and Claims'!F$55","v":0},{"$f":"'Pt 2 Premium and Claims'!G$55","v":0},{"$f":"'Pt 2 Premium and Claims'!H$55","v":0},{"$f":"'Pt 2 Premium and Claims'!I$55","v":0},{"$f":"'Pt 2 Premium and Claims'!J$55","v":0},{"$f":"'Pt 2 Premium and Claims'!K$55","v":0},{"$f":"'Pt 2 Premium and Claims'!L$55","v":0},{"$f":"'Pt 2 Premium and Claims'!M$55","v":0},{"$f":"'Pt 2 Premium and Claims'!N$55","v":0},{"$f":"'Pt 2 Premium and Claims'!O$55","v":0},{"$f":"'Pt 2 Premium and Claims'!P$55","v":0},{"$f":"'Pt 2 Premium and Claims'!Q$55","v":0},{"$f":"'Pt 2 Premium and Claims'!R$55","v":0},{"$f":"'Pt 2 Premium and Claims'!S$55","v":0},{"$f":"'Pt 2 Premium and Claims'!T$55","v":0},{"$f":"'Pt 2 Premium and Claims'!U$55","v":0},{"$f":"'Pt 2 Premium and Claims'!V$55","v":0},{"$f":"'Pt 2 Premium and Claims'!W$55","v":0},{"$f":"'Pt 2 Premium and Claims'!X$55","v":0},{"$f":"'Pt 2 Premium and Claims'!Y$55","v":0},{"$f":"'Pt 2 Premium and Claims'!Z$55","v":0},{"$f":"'Pt 2 Premium and Claims'!AA$55","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Pt 2 Premium and Claims'!AL$55","v":0},{"$f":"'Pt 2 Premium and Claims'!AM$55","v":0},{"$f":"'Pt 2 Premium and Claims'!AN$55","v":0},{"$f":"'Pt 2 Premium and Claims'!AO$55","v":0},{"$f":"'Pt 2 Premium and Claims'!AP$55","v":0},{"$f":"'Pt 2 Premium and Claims'!AQ$55","v":0},{"$f":"'Pt 2 Premium and Claims'!AR$55","v":0},{"$f":"'Pt 2 Premium and Claims'!AS$55","v":0}]
[null,"3. Federal and State Taxes and Licensing or Regulatory Fees"]
[null,"3.1 Federal taxes and assessments incurred by the reporting issuer during the MLR reporting year","Pt 1, Ln 1.5"]
[null,"3.1a Federal income taxes deductible from premium in MLR calculations"]
[null,"3.1b Patient Centered Outcomes Research Institute (PCORI) Fee"]
[null,"3.1c Affordable Care Act section 9010 Fee"]
[null,"3.1d Other Federal taxes and assessments deductible from premium"]
[null,"3.2 State insurance, premium and other taxes incurred by the reporting issuer during the MLR reporting year (deductible from premium in MLR calculation)","Pt 1, Ln 1.6"]
[null,"3.2a State income, excise, business, and other taxes"]
[null,"3.2b State premium taxes"]
[null,"3.2c Community benefit expenditures deductible from premium in MLR calculations","Pt 1, Ln 1.6a"]
[null,"3.3 Regulatory authority licenses and fees","Pt 1, Ln 1.7"]
[null,"3.3a Federal Transitional Reinsurance Program contributions"]
[null,"3.3b Other Federal and State regulatory authority licenses and fees"]
[null,"4. Health Care Quality Improvement Expenses Incurred"]
[null,"4.1 Improve health outcomes","Pt 1, Ln 6.1"]
[null,"4.2 Activities to prevent hospital readmission","Pt 1, Ln 6.2"]
[null,"4.3 Improve patient safety and reduce medical errors","Pt 1, Ln 6.3"]
[null,"4.4 Wellness and health promotion activities","Pt 1, Ln 6.4"]
[null,"4.5 Health information technology expenses related to improving health care quality","Pt 1, Ln 6.5"]
[null,"4.6 Total allowable quality improvement expenses"]
[null,"5. Non-Claims Costs"]
[null,"5.1 Cost containment expenses not included in quality improvement expenses in Section 4","Pt 1, Ln 8.1"]
[null,"5.2 All other claims adjustment expenses","Pt 1, Ln 8.2"]
[null,"5.3 Direct sales salaries and benefits","Pt 1, Ln 10.1"]
[null,"5.4 Agents and brokers fees and commissions","Pt 1, Ln 10.2"]
[null,"5.5 Other taxes"]
[null,"5.5a Taxes and assessments (exclude amounts reported in Section 3 or Lines 5.5c or 9)"]
[null,"5.5b Fines and penalties of regulatory authorities (exclude amounts reported in Line 3.3)"]
[null,"5.5c Federal and State employment taxes and assessments"]
[null,"5.6 Other general and administrative expenses"]
[null,"5.7 Community benefit expenditures (informational only; include amounts reported in Lines 3.2c and 5.6)","Pt 1, Ln 10.4a"]
[null,"6. Income from fees of uninsured plans","Pt 1, Ln 12"]
[null,"7. Other Indicators or information"]
[null,"7.1 Number of policies/certificates","Pt 1 Other, Ln 1"]
[null,"7.2 Number of covered lives","Pt 1 Other, Ln 2"]
[null,"7.3 Number of groups","Pt 1 Other, Ln 3"]
[null,"7.4 Member months","Pt 1 Other, Ln 4"]
[null,"7.5 Number of life-years",null,{"$f":"D$59/12","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,null,null,null,null,null,null,null,null,null,null,{"$f":"AL$59/12","v":0},0,0,0,0,0,0,0,0]
[null,"8. Net investment income and other gain / (loss)","Pt 1, Ln 13"]
[null,"9. Other Federal income taxes (exclude taxes on Lines 3.1a-d)","Pt 1, Ln 14"]

{"sheet":"Pt 2 Premium and Claims","index":4,"n_rows":58,"n_cols":47,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,"Part 2 Premium and Claims"]
[]
[null,"Line Description","SHCE","1\nHealth Insurance\nINDIVIDUAL\nTotal as of 12/31/17","2\nHealth Insurance\nINDIVIDUAL\nTotal as of 3/31/18","3\nHealth Insurance\nINDIVIDUAL\nDual Contracts\n(Included in Total as of 3/31/18)","4\nHealth Insurance\nINDIVIDUAL\nDeferred PY1\n(Add)","5\nHealth Insurance\nINDIVIDUAL\nDeferred CY\n(Subtract)","6\nHealth Insurance\nSMALL GROUP\nTotal as of 12/31/17","7\nHealth Insurance\nSMALL GROUP\nTotal as of 3/31/18","8\nHealth Insurance\nSMALL GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","9\nHealth Insurance\nSMALL GROUP\nDeferred PY1\n(Add)","10\nHealth Insurance\nSMALL GROUP\nDeferred CY\n(Subtract)","11\nHealth Insurance\nLARGE GROUP\nTotal as of 12/31/17","12\nHealth Insurance\nLARGE GROUP\nTotal as of 3/31/18","13\nHealth Insurance\nLARGE GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","14\nHealth Insurance\nLARGE GROUP\nDeferred PY1\n(Add)","15\nHealth Insurance\nLARGE GROUP\nDeferred CY\n(Subtract)","16\nMini-Med\nINDIVIDUAL\nTotal as of 12/31/17","17\nMini-Med\nINDIVIDUAL\nTotal as of 3/31/18","18\nMini-Med\nINDIVIDUAL\nDual Contracts\n(Included in Total as of 3/31/18)","19\nMini-Med\nSMALL GROUP\nTotal as of 12/31/17","20\nMini-Med\nSMALL GROUP\nTotal as of 3/31/18","21\nMini-Med\nSMALL GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","22\nMini-Med\nLARGE GROUP\nTotal as of 12/31/17","23\nMini-Med\nLARGE GROUP\nTotal as of 3/31/18","24\nMini-Med\nLARGE GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","25\nExpat\nSMALL GROUP\nTotal as of 12/31/17","26\nExpat\nSMALL GROUP\nTotal as of 3/31/18","27\nExpat\nSMALL GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","28\nExpat\nSMALL GROUP\nDeferred PY1\n(Add)","29\nExpat\nSMALL GROUP\nDeferred CY\n(Subtract)","30\nExpat\nLARGE GROUP\nTotal as of 12/31/17","31\nExpat\nLARGE GROUP\nTotal as of 3/31/18","32\nExpat\nLARGE GROUP\nDual Contracts\n(Included in Total as of 3/31/18)","33\nExpat\nLARGE GROUP\nDeferred PY1\n(Add)","34\nExpat\nLARGE GROUP\nDeferred CY\n(Subtract)","35\nStudent Health\nINDIVIDUAL\nTotal as of 12/31/17","36\nStudent Health\nINDIVIDUAL\nTotal as of 3/31/18","37\nStudent Health\nINDIVIDUAL\nDual Contracts\n(Included in Total as of 3/31/18)","38\nStudent Health\nINDIVIDUAL\nDeferred PY1\n(Add)","39\nStudent Health\nINDIVIDUAL\nDeferred CY\n(Subtract)","40\nGovernment Program Plans \nTotal as of 12/31/17","41\nOther Health Business \nTotal as of 12/31/17","42\nMedicare MLR Business\nTotal as of 12/31/17","43\nUninsured Plans\nTotal as of 12/31/17","44\nGrand Total\nTotal as of 12/31/17"]
[null,"1. Premium"]
[null,"1.1 Direct premium written"]
[null,"1.2 Unearned premium prior year","Pt 2, Ln 1.2"]
[null,"1.3 Unearned premium MLR Reporting year","Pt 2, Ln 1.3"]
[null,"1.4 Experience rating refunds (rate credits) paid"]
[null,"1.4a Experience rating refunds, with all incurred dates, paid in the MLR reporting year","Pt 2, Ln 1.5"]
[null,"1.4b Experience rating refunds associated with premium earned only in the reporting year and paid through 3/31 of the following year"]
[null,"1.5 Reserve for experience rating refunds (rate credits) MLR Reporting year","Pt 2, Ln 1.6"]
[null,"1.6 Reserve for experience rating refunds (rate credits) prior year","Pt 2, Ln 1.7"]
[null,"1.7 Premium balances written off","Pt 2, Ln 1.9"]
[null,"1.8 Group conversion charges","Pt 2, Ln 1.10"]
[null,"1.9 Federal Transitional Reinsurance Program payments - Deferred PY1 column only"]
[null,"1.10 Federal Risk Adjustment Program net payments expected from HHS / (charges payable to HHS) (as indicated by HHS as of 6/30)"]
[null,"1.11 Federal Risk Corridors Program net payments / (charges) - Deferred PY1 column only"]
[null,"1.12 Premium ceded under 100% reinsurance (informational only; already excluded from Lines 1.1-1.11)"]
[null,"1.13 Premium assumed under 100% reinsurance (informational only; already included in Lines 1.1-1.11)"]
[null,"1.14 Advance payments of the premium tax credit received from HHS (informational only; already included in Lines 1.1-1.11)"]
[null,"2. Claims"]
[null,"2.1 Claims Paid"]
[null,"2.1a  Claims paid during the MLR reporting year regardless of incurred date"]
[null,"2.1b  Claims incurred only during the MLR reporting year, paid through 3/31 of the following year"]
[null,"2.2 Direct claim liability"]
[null,"2.2a Liability as of 12/31 of MLR reporting year for all claims regardless of incurred date","Pt 2, Ln 2.2"]
[null,"2.2b Liability for claims incurred only during the MLR reporting year, calculated as of 3/31 of the following year"]
[null,"2.3 Direct claim liability prior year","Pt 2, Ln 2.3"]
[null,"2.4 Direct claim reserves"]
[null,"2.4a Reserves as of 12/31 of MLR reporting year for all claims regardless of incurred date","Pt 2, Ln 2.4"]
[null,"2.4b Reserves for claims incurred only during the MLR reporting year, calculated as of 3/31 of the following year"]
[null,"2.5 Direct claim reserves prior year","Pt 2, Ln 2.5"]
[null,"2.6 Direct contract reserves"]
[null,"2.6a Direct contract reserves 12/31 column","Pt 2, Ln 2.6"]
[null,"2.6b Direct contract reserves 3/31, dual contract, deferred columns"]
[null,"2.7 Direct contract reserves prior year","Pt 2, Ln 2.7"]
[null,"2.8 Experience rating refunds (rate credits) paid"]
[null,"2.8a Experience rating refunds, with all incurred dates, paid in the MLR reporting year","Pt 2, Ln 2.8"]
[null,"2.8b Experience rating refunds associated with premium earned only in the reporting year and paid through 3/31 of the following year"]
[null,"2.9 Reserve for experience rating refunds (rate credits)"]
[null,"2.9a Reserved in MLR reporting year regardless of incurred date","Pt 2, Ln 2.9"]
[null,"2.9b Reserves specific to the MLR reporting year through 3/31 of the following year"]
[null,"2.10 Reserve for experience rating refunds (rate credits) prior year","Pt 2, Ln 2.10"]
[null,"2.11 Incurred medical incentive pool and bonuses"]
[null,"2.11a  Paid medical incentive pools and bonuses MLR Reporting year","Pt 2, Ln 2.11a"]
[null,"2.11b  Accrued medical incentive pools and bonuses MLR Reporting year","Pt 2, Ln 2.11b"]
[null,"2.11c  Accrued medical incentive pools and bonuses prior year","Pt 2, Ln 2.11c"]
[null,"2.12 Net healthcare receivables "]
[null,"2.12a  Healthcare receivables MLR Reporting year","Pt 2, Ln 2.12a"]
[null,"2.12b  Healthcare receivables prior year","Pt 2, Ln 2.12b"]
[null,"2.13 Contingent benefit and lawsuit reserves"]
[null,"2.14 Group conversion charges","Pt 2, Ln 2.13"]
[null,"2.15 Blended rate adjustment","Pt 2, Ln 2.14"]
[null,"2.16 Total incurred claims ","Pt 2, Ln 2.15",{"$f":"D23+D26-D28+D30-D32+D34-D36+D38+D41-D43+D45+D46-D47-D49+D50+D51+D52+D53","v":0},{"$f":"E24+E27+E31+E35-E36+E39+E42+E45+E46-E49+E51+E52+E53","v":0},{"$f":"F24+F27+F31+F35-F36+F39+F42+F45+F46-F49+F51+F52+F53","v":0},{"$f":"G24+G27+G31+G35-G36+G39+G42+G45+G46-G49+G51+G52+G53","v":0},{"$f":"H24+H27+H31+H35-H36+H39+H42+H45+H46-H49+H51+H52+H53","v":0},{"$f":"I23+I26-I28+I30-I32+I34-I36+I38+I41-I43+I45+I46-I47-I49+I50+I51+I52+I53","v":0},{"$f":"J24+J27+J31+J35-J36+J39+J42+J45+J46-J49+J51+J52+J53","v":0},{"$f":"K24+K27+K31+K35-K36+K39+K42+K45+K46-K49+K51+K52+K53","v":0},{"$f":"L24+L27+L31+L35-L36+L39+L42+L45+L46-L49+L51+L52+L53","v":0},{"$f":"M24+M27+M31+M35-M36+M39+M42+M45+M46-M49+M51+M52+M53","v":0},{"$f":"N23+N26-N28+N30-N32+N34-N36+N38+N41-N43+N45+N46-N47-N49+N50+N51+N52+N53","v":0},{"$f":"O24+O27+O31+O35-O36+O39+O42+O45+O46-O49+O51+O52+O53","v":0},{"$f":"P24+P27+P31+P35-P36+P39+P42+P45+P46-P49+P51+P52+P53","v":0},{"$f":"Q24+Q27+Q31+Q35-Q36+Q39+Q42+Q45+Q46-Q49+Q51+Q52+Q53","v":0},{"$f":"R24+R27+R31+R35-R36+R39+R42+R45+R46-R49+R51+R52+R53","v":0},{"$f":"S23+S26-S28+S30-S32+S34-S36+S38+S41-S43+S45+S46-S47-S49+S50+S51+S52+S53","v":0},{"$f":"T24+T27+T31+T35-T36+T39+T42+T45+T46-T49+T51+T52+T53","v":0},{"$f":"U24+U27+U31+U35-U36+U39+U42+U45+U46-U49+U51+U52+U53","v":0},{"$f":"V23+V26-V28+V30-V32+V34-V36+V38+V41-V43+V45+V46-V47-V49+V50+V51+V52+V53","v":0},{"$f":"W24+W27+W31+W35-W36+W39+W42+W45+W46-W49+W51+W52+W53","v":0},{"$f":"X24+X27+X31+X35-X36+X39+X42+X45+X46-X49+X51+X52+X53","v":0},{"$f":"Y23+Y26-Y28+Y30-Y32+Y34-Y36+Y38+Y41-Y43+Y45+Y46-Y47-Y49+Y50+Y51+Y52+Y53","v":0},{"$f":"Z24+Z27+Z31+Z35-Z36+Z39+Z42+Z45+Z46-Z49+Z51+Z52+Z53","v":0},{"$f":"AA24+AA27+AA31+AA35-AA36+AA39+AA42+AA45+AA46-AA49+AA51+AA52+AA53","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"AL23+AL26-AL28+AL30-AL32+AL34-AL36+AL38+AL41-AL43+AL45+AL46-AL47-AL49+AL50+AL51+AL52+AL53","v":0},{"$f":"AM24+AM27+AM31+AM35-AM36+AM39+AM42+AM45+AM46-AM49+AM51+AM52+AM53","v":0},{"$f":"AN24+AN27+AN31+AN35-AN36+AN39+AN42+AN45+AN46-AN49+AN51+AN52+AN53","v":0},{"$f":"AO24+AO27+AO31+AO35-AO36+AO39+AO42+AO45+AO46-AO49+AO51+AO52+AO53","v":0},{"$f":"AP24+AP27+AP31+AP35-AP36+AP39+AP42+AP45+AP46-AP49+AP51+AP52+AP53","v":0},{"$f":"AQ23+AQ26-AQ28+AQ30-AQ32+AQ34-AQ36+AQ38+AQ41-AQ43+AQ45+AQ46-AQ47-AQ49+AQ50+AQ51+AQ52+AQ53","v":0},{"$f":"AR23+AR26-AR28+AR30-AR32+AR34-AR36+AR38+AR41-AR43+AR45+AR46-AR47-AR49+AR50+AR51+AR52+AR53","v":0},{"$f":"AS23+AS26-AS28+AS30-AS32+AS34-AS36+AS38+AS41-AS43+AS45+AS46-AS47-AS49+AS50+AS51+AS52+AS53","v":0}]
[null,"2.17 Allowable claims recovered through fraud reduction efforts (the smaller of Lines 2.17a or 2.17b)","Pt 1, Ln 4",{"$f":"MIN(MAX(0,D56),MAX(0,D57))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"MIN(MAX(0,N56),MAX(0,N57))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,"2.17a  Total fraud reduction expense","Pt 3, Col 7, Ln 1.11/2.11/3.11/5.11/6.11"]
[null,"2.17b  Total fraud recoveries that reduced paid claims in Line 2.1","Pt 2, Ln 3"]
[null,"2.18 Reconciled payments of cost-sharing reductions"]

{"sheet":"Pt 3 MLR and Rebate Calculation","index":5,"n_rows":49,"n_cols":38,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"Part 3 MLR and Rebate Calculation"]
[]
[null,"Line Description","1\nHealth Insurance Coverage\nINDIVIDUAL\nPY2","2\nHealth Insurance Coverage\nINDIVIDUAL\nPY1","3\nHealth Insurance Coverage\nINDIVIDUAL\nCY","4\nHealth Insurance Coverage\nINDIVIDUAL\nTotal ","5\nHealth Insurance Coverage\nSMALL GROUP\nPY2","6\nHealth Insurance Coverage\nSMALL GROUP\nPY1","7\nHealth Insurance Coverage\nSMALL GROUP\nCY","8\nHealth Insurance Coverage\nSMALL GROUP\nTotal","9\nHealth Insurance Coverage\nLARGE GROUP\nPY2","10\nHealth Insurance Coverage\nLARGE GROUP\nPY1","11\nHealth Insurance Coverage\nLARGE GROUP\nCY","12\nHealth Insurance Coverage\nLARGE GROUP\nTotal","13\nMini-Med Plans\nINDIVIDUAL\nPY2","14\nMini-Med Plans\nINDIVIDUAL\nPY1","15\nMini-Med Plans\nINDIVIDUAL\nCY","16\nMini-Med Plans\nINDIVIDUAL\nTotal ","17\nMini-Med Plans\nSMALL GROUP\nPY2","18\nMini-Med Plans\nSMALL GROUP\nPY1","19\nMini-Med Plans\nSMALL GROUP\nCY","20\nMini-Med Plans\nSMALL GROUP\nTotal","21\nMini-Med Plans\nLARGE GROUP\nPY2","22\nMini-Med Plans\nLARGE GROUP\nPY1","23\nMini-Med Plans\nLARGE GROUP\nCY","24\nMini-Med Plans\nLARGE GROUP\nTotal","25\nExpatriate Plans\nSMALL GROUP\nPY2","26\nExpatriate Plans\nSMALL GROUP\nPY1","27\nExpatriate Plans\nSMALL GROUP\nCY","28\nExpatriate Plans\nSMALL GROUP\nTotal ","29\nExpatriate Plans\nLARGE GROUP\nPY2","30\nExpatriate Plans\nLARGE GROUP\nPY1","31\nExpatriate Plans\nLARGE GROUP\nCY","32\nExpatriate Plans\nLARGE GROUP\nTotal","33\nStudent Health Plans\nINDIVIDUAL\nPY2","34\nStudent Health Plans\nINDIVIDUAL\nPY1","35\nStudent Health Plans\nINDIVIDUAL\nCY","36\nStudent Health Plans\nINDIVIDUAL\nTotal"]
[null,"1. Medical Loss Ratio Numerator"]
[null,"1.1 Adjusted incurred claims as reported on MLR Form for prior year(s)"]
[null,"1.2 Adjusted incurred claims as of 3/31 of the year following the MLR reporting year",null,null,{"$f":"SUM('Pt 1 Summary of Data'!$E$12,'Pt 1 Summary of Data'!$E$22)+SUM('Pt 1 Summary of Data'!$G$12,'Pt 1 Summary of Data'!$G$22)-SUM('Pt 1 Summary of Data'!$H$12,'Pt 1 Summary of Data'!$H$22)","v":0},{"$f":"SUM(C6:E6)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!$J$12,'Pt 1 Summary of Data'!$J$22)+SUM('Pt 1 Summary of Data'!$L$12,'Pt 1 Summary of Data'!$L$22)-SUM('Pt 1 Summary of Data'!$M$12,'Pt 1 Summary of Data'!$M$22)","v":0},{"$f":"SUM(G6:I6)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!$O$12,'Pt 1 Summary of Data'!$O$22)+SUM('Pt 1 Summary of Data'!$Q$12,'Pt 1 Summary of Data'!$Q$22)-SUM('Pt 1 Summary of Data'!$R$12,'Pt 1 Summary of Data'!$R$22)","v":0},{"$f":"SUM(K6:M6)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!T$12,'Pt 1 Summary of Data'!T$22)","v":0},{"$f":"SUM(O6:Q6)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!W$12,'Pt 1 Summary of Data'!W$22)","v":0},{"$f":"SUM(S6:U6)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!Z$12,'Pt 1 Summary of Data'!Z$22)","v":0},{"$f":"SUM(W6:Y6)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Pt 1 Summary of Data'!AM$12,'Pt 1 Summary of Data'!AM$22)+SUM('Pt 1 Summary of Data'!AO$12,'Pt 1 Summary of Data'!AO$22)-SUM('Pt 1 Summary of Data'!AP$12,'Pt 1 Summary of Data'!AP$22)","v":0},{"$f":"SUM(AI6:AK6)","v":0}]
[null,"1.3 Improving Health Care Quality Expenses ",null,null,{"$f":"IF(AND(SUM('Pt 1 Summary of Data'!$E$37:$E$41)+SUM('Pt 1 Summary of Data'!$G$37:$G$41)-SUM('Pt 1 Summary of Data'!$H$37:$H$41)<>0,SUM('Pt 1 Summary of Data'!$E$37:$E$41)+SUM('Pt 1 Summary of Data'!$G$37:$G$41)-SUM('Pt 1 Summary of Data'!$H$37:$H$41)<>'Pt 1 Summary of Data'!$E$42+'Pt 1 Summary of Data'!$G$42-'Pt 1 Summary of Data'!$H$42,'Pt 1 Summary of Data'!$E$42+'Pt 1 Summary of Data'!$G$42-'Pt 1 Summary of Data'!$H$42<>0.8%*(E$15+E$41-('Pt 1 Summary of Data'!$E$7+'Pt 1 Summary of Data'!$G$7-'Pt 1 Summary of Data'!$H$7))),\"Check Pt 1 Ln 4.6\",IF(E$15+E$41-('Pt 1 Summary of Data'!$E$7+'Pt 1 Summary of Data'!$G$7-'Pt 1 Summary of Data'!$H$7)<0,'Pt 1 Summary of Data'!$E$42+'Pt 1 Summary of Data'!$G$42-'Pt 1 Summary of Data'!$H$42,IF(SUM('Pt 1 Summary of Data'!$E$37:$E$41)+SUM('Pt 1 Summary of Data'!$G$37:$G$41)-SUM('Pt 1 Summary of Data'!$H$37:$H$41)=0,MIN('Pt 1 Summary of Data'!$E$42+'Pt 1 Summary of Data'!$G$42-'Pt 1 Summary of Data'!$H$42,0.8%*(E$15+E$41-('Pt 1 Summary of Data'!$E$7+'Pt 1 Summary of Data'!$G$7-'Pt 1 Summary of Data'!$H$7))),MAX(MIN('Pt 1 Summary of Data'!$E$42+'Pt 1 Summary of Data'!$G$42-'Pt 1 Summary of Data'!$H$42,0.8%*(E$15+E$41-('Pt 1 Summary of Data'!$E$7+'Pt 1 Summary of Data'!$G$7-'Pt 1 Summary of Data'!$H$7))),SUM('Pt 1 Summary of Data'!$E$37:$E$41)+SUM('Pt 1 Summary of Data'!$G$37:$G$41)-SUM('Pt 1 Summary of Data'!$H$37:$H$41)))))","v":0},0,null,null,{"$f":"IF(AND(SUM('Pt 1 Summary of Data'!$J$37:$J$41)+SUM('Pt 1 Summary of Data'!$L$37:$L$41)-SUM('Pt 1 Summary of Data'!$M$37:$M$41)<>0,SUM('Pt 1 Summary of Data'!$J$37:$J$41)+SUM('Pt 1 Summary of Data'!$L$37:$L$41)-SUM('Pt 1 Summary of Data'!$M$37:$M$41)<>'Pt 1 Summary of Data'!$J$42+'Pt 1 Summary of Data'!$L$42-'Pt 1 Summary of Data'!$M$42,'Pt 1 Summary of Data'!$J$42+'Pt 1 Summary of Data'!$L$42-'Pt 1 Summary of Data'!$M$42<>0.8%*(I$15+I$41-('Pt 1 Summary of Data'!$J$7+'Pt 1 Summary of Data'!$L$7-'Pt 1 Summary of Data'!$M$7))),\"Check Pt 1 Ln 4.6\",IF(I$15+I$41-('Pt 1 Summary of Data'!$J$7+'Pt 1 Summary of Data'!$L$7-'Pt 1 Summary of Data'!$M$7)<0,'Pt 1 Summary of Data'!$J$42+'Pt 1 Summary of Data'!$L$42-'Pt 1 Summary of Data'!$M$42,IF(SUM('Pt 1 Summary of Data'!$J$37:$J$41)+SUM('Pt 1 Summary of Data'!$L$37:$L$41)-SUM('Pt 1 Summary of Data'!$M$37:$M$41)=0,MIN('Pt 1 Summary of Data'!$J$42+'Pt 1 Summary of Data'!$L$42-'Pt 1 Summary of Data'!$M$42,0.8%*(I$15+I$41-('Pt 1 Summary of Data'!$J$7+'Pt 1 Summary of Data'!$L$7-'Pt 1 Summary of Data'!$M$7))),MAX(MIN('Pt 1 Summary of Data'!$J$42+'Pt 1 Summary of Data'!$L$42-'Pt 1 Summary of Data'!$M$42,0.8%*(I$15+I$41-('Pt 1 Summary of Data'!$J$7+'Pt 1 Summary of Data'!$L$7-'Pt 1 Summary of Data'!$M$7))),SUM('Pt 1 Summary of Data'!$J$37:$J$41)+SUM('Pt 1 Summary of Data'!$L$37:$L$41)-SUM('Pt 1 Summary of Data'!$M$37:$M$41)))))","v":0},{"$f":"SUM(G7:I7)","v":0},null,null,{"$f":"IF(AND(SUM('Pt 1 Summary of Data'!$O$37:$O$41)+SUM('Pt 1 Summary of Data'!$Q$37:$Q$41)-SUM('Pt 1 Summary of Data'!$R$37:$R$41)<>0,SUM('Pt 1 Summary of Data'!$O$37:$O$41)+SUM('Pt 1 Summary of Data'!$Q$37:$Q$41)-SUM('Pt 1 Summary of Data'!$R$37:$R$41)<>'Pt 1 Summary of Data'!$O$42+'Pt 1 Summary of Data'!$Q$42-'Pt 1 Summary of Data'!$R$42,'Pt 1 Summary of Data'!$O$42+'Pt 1 Summary of Data'!$Q$42-'Pt 1 Summary of Data'!$R$42<>0.8%*(M$15+M$41-('Pt 1 Summary of Data'!$O$7+'Pt 1 Summary of Data'!$Q$7-'Pt 1 Summary of Data'!$R$7))),\"Check Pt 1 Ln 4.6\",IF(M$15+M$41-('Pt 1 Summary of Data'!$O$7+'Pt 1 Summary of Data'!$Q$7-'Pt 1 Summary of Data'!$R$7)<0,'Pt 1 Summary of Data'!$O$42+'Pt 1 Summary of Data'!$Q$42-'Pt 1 Summary of Data'!$R$42,IF(SUM('Pt 1 Summary of Data'!$O$37:$O$41)+SUM('Pt 1 Summary of Data'!$Q$37:$Q$41)-SUM('Pt 1 Summary of Data'!$R$37:$R$41)=0,MIN('Pt 1 Summary of Data'!$O$42+'Pt 1 Summary of Data'!$Q$42-'Pt 1 Summary of Data'!$R$42,0.8%*(M$15+M$41-('Pt 1 Summary of Data'!$O$7+'Pt 1 Summary of Data'!$Q$7-'Pt 1 Summary of Data'!$R$7))),MAX(MIN('Pt 1 Summary of Data'!$O$42+'Pt 1 Summary of Data'!$Q$42-'Pt 1 Summary of Data'!$R$42,0.8%*(M$15+M$41-('Pt 1 Summary of Data'!$O$7+'Pt 1 Summary of Data'!$Q$7-'Pt 1 Summary of Data'!$R$7))),SUM('Pt 1 Summary of Data'!$O$37:$O$41)+SUM('Pt 1 Summary of Data'!$Q$37:$Q$41)-SUM('Pt 1 Summary of Data'!$R$37:$R$41)))))","v":0},{"$f":"SUM(K7:M7)","v":0},null,null,{"$f":"IF(AND(SUM('Pt 1 Summary of Data'!T$37:T$41)<>0,SUM('Pt 1 Summary of Data'!T$37:T$41)<>'Pt 1 Summary of Data'!$T$42,'Pt 1 Summary of Data'!$T$42<>0.8%*(Q$15+Q$41-'Pt 1 Summary of Data'!$T$7)),\"Check Pt 1 Ln 4.6\",IF(Q$15+Q$41-'Pt 1 Summary of Data'!$T$7<0,'Pt 1 Summary of Data'!$T$42,IF(SUM('Pt 1 Summary of Data'!T$37:T$41)=0,MIN('Pt 1 Summary of Data'!$T$42,0.8%*(Q$15+Q$41-'Pt 1 Summary of Data'!$T$7)),MAX(MIN('Pt 1 Summary of Data'!$T$42,0.8%*(Q$15+Q$41-'Pt 1 Summary of Data'!$T$7)),SUM('Pt 1 Summary of Data'!T$37:T$41)))))","v":0},{"$f":"SUM(O7:Q7)","v":0},null,null,{"$f":"IF(AND(SUM('Pt 1 Summary of Data'!W$37:W$41)<>0,SUM('Pt 1 Summary of Data'!W$37:W$41)<>'Pt 1 Summary of Data'!$W$42,'Pt 1 Summary of Data'!$W$42<>0.8%*(U$15+U$41-'Pt 1 Summary of Data'!$W$7)),\"Check Pt 1 Ln 4.6\",IF(U$15+U$41-'Pt 1 Summary of Data'!$W$7<0,'Pt 1 Summary of Data'!$W$42,IF(SUM('Pt 1 Summary of Data'!W$37:W$41)=0,MIN('Pt 1 Summary of Data'!$W$42,0.8%*(U$15+U$41-'Pt 1 Summary of Data'!$W$7)),MAX(MIN('Pt 1 Summary of Data'!$W$42,0.8%*(U$15+U$41-'Pt 1 Summary of Data'!$W$7)),SUM('Pt 1 Summary of Data'!W$37:W$41)))))","v":0},{"$f":"SUM(S7:U7)","v":0},null,null,{"$f":"IF(AND(SUM('Pt 1 Summary of Data'!Z$37:Z$41)<>0,SUM('Pt 1 Summary of Data'!Z$37:Z$41)<>'Pt 1 Summary of Data'!$Z$42,'Pt 1 Summary of Data'!$Z$42<>0.8%*(Y$15+Y$41-'Pt 1 Summary of Data'!$Z$7)),\"Check Pt 1 Ln 4.6\",IF(Y$15+Y$41-'Pt 1 Summary of Data'!$Z$7<0,'Pt 1 Summary of Data'!$Z$42,IF(SUM('Pt 1 Summary of Data'!Z$37:Z$41)=0,MIN('Pt 1 Summary of Data'!$Z$42,0.8%*(Y$15+Y$41-'Pt 1 Summary of Data'!$Z$7)),MAX(MIN('Pt 1 Summary of Data'!$Z$42,0.8%*(Y$15+Y$41-'Pt 1 Summary of Data'!$Z$7)),SUM('Pt 1 Summary of Data'!Z$37:Z$41)))))","v":0},{"$f":"SUM(W7:Y7)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(SUM('Pt 1 Summary of Data'!AM$37:AM$41)+SUM('Pt 1 Summary of Data'!AO$37:AO$41)-SUM('Pt 1 Summary of Data'!AP$37:AP$41)<>0,SUM('Pt 1 Summary of Data'!AM$37:AM$41)+SUM('Pt 1 Summary of Data'!AO$37:AO$41)-SUM('Pt 1 Summary of Data'!AP$37:AP$41)<>'Pt 1 Summary of Data'!$AM$42+'Pt 1 Summary of Data'!$AO$42-'Pt 1 Summary of Data'!$AP$42,'Pt 1 Summary of Data'!$AM$42+'Pt 1 Summary of Data'!$AO$42-'Pt 1 Summary of Data'!$AP$42<>0.8%*(AK$15+AK$41-('Pt 1 Summary of Data'!$AM$7+'Pt 1 Summary of Data'!$AO$7-'Pt 1 Summary of Data'!$AP$7))),\"Check Pt 1 Ln 4.6\",IF(AK$15+AK$41-('Pt 1 Summary of Data'!$AM$7+'Pt 1 Summary of Data'!$AO$7-'Pt 1 Summary of Data'!$AP$7)<0,'Pt 1 Summary of Data'!$AM$42+'Pt 1 Summary of Data'!$AO$42-'Pt 1 Summary of Data'!$AP$42,IF(SUM('Pt 1 Summary of Data'!AM$37:AM$41)+SUM('Pt 1 Summary of Data'!AO$37:AO$41)-SUM('Pt 1 Summary of Data'!AP$37:AP$41)=0,MIN('Pt 1 Summary of Data'!$AM$42+'Pt 1 Summary of Data'!$AO$42-'Pt 1 Summary of Data'!$AP$42,0.8%*(AK$15+AK$41-('Pt 1 Summary of Data'!$AM$7+'Pt 1 Summary of Data'!$AO$7-'Pt 1 Summary of Data'!$AP$7))),MAX(MIN('Pt 1 Summary of Data'!$AM$42+'Pt 1 Summary of Data'!$AO$42-'Pt 1 Summary of Data'!$AP$42,0.8%*(AK$15+AK$41-('Pt 1 Summary of Data'!$AM$7+'Pt 1 Summary of Data'!$AO$7-'Pt 1 Summary of Data'!$AP$7))),SUM('Pt 1 Summary of Data'!AM$37:AM$41)+SUM('Pt 1 Summary of Data'!AO$37:AO$41)-SUM('Pt 1 Summary of Data'!AP$37:AP$41)))))","v":0},{"$f":"SUM(AI7:AK7)","v":0}]
[null,"1.4 Reconciled payments of cost-sharing reductions",null,null,{"$f":"'Pt 2 Premium and Claims'!$E$58+'Pt 2 Premium and Claims'!$G$58-'Pt 2 Premium and Claims'!$H$58","v":0},0]
[null,"1.5 Federal Transitional Reinsurance Program payments expected from HHS (as indicated by HHS as of 6/30)",null,null,{"$f":"'Pt 2 Premium and Claims'!$E$15+'Pt 2 Premium and Claims'!$G$15-'Pt 2 Premium and Claims'!$H$15","v":0},0]
[null,"1.6 Federal Risk Adjustment Program net payments expected from HHS / (charges payable to HHS) (as indicated by HHS as of 6/30)",null,null,{"$f":"'Pt 2 Premium and Claims'!$E$16+'Pt 2 Premium and Claims'!$G$16-'Pt 2 Premium and Claims'!$H$16","v":0},0,null,null,{"$f":"'Pt 2 Premium and Claims'!$J$16+'Pt 2 Premium and Claims'!$L$16-'Pt 2 Premium and Claims'!$M$16","v":0},{"$f":"SUM(G10:I10)","v":0}]
[null,"1.7 Federal Risk Corridors Program net payments / (charges)",null,null,{"$f":"'Pt 2 Premium and Claims'!$E$17+'Pt 2 Premium and Claims'!$G$17-'Pt 2 Premium and Claims'!$H$17","v":0},0,null,null,{"$f":"'Pt 2 Premium and Claims'!$J$17+'Pt 2 Premium and Claims'!$L$17-'Pt 2 Premium and Claims'!$M$17","v":0},{"$f":"SUM(G11:I11)","v":0}]
[null,"1.8 MLR numerator ",{"$f":"SUM(C$6:C$7)-SUM(C$8:C$11)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),SUM(G$6:G$7)-SUM(G$10:G$11),0)","v":0},{"$f":"SUM(D$6:D$7)-SUM(D$8:D$11)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),SUM(H$6:H$7)-SUM(H$10:H$11),0)","v":0},{"$f":"SUM(E$6:E$7)-SUM(E$8:E$11)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),SUM(I$6:I$7)-SUM(I$10:I$11),0)","v":0},{"$f":"IFERROR(SUM(C$12:E$12)+C$17*MAX(0,E$31-C$31)+D$17*MAX(0,E$31-D$31),0)","v":0},{"$f":"SUM(G$6:G$7)-SUM(G$10:G$11)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),SUM(C$6:C$7)-SUM(C$8:C$11),0)","v":0},{"$f":"SUM(H$6:H$7)-SUM(H$10:H$11)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),SUM(D$6:D$7)-SUM(D$8:D$11),0)","v":0},{"$f":"SUM(I$6:I$7)-SUM(I$10:I$11)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),SUM(E$6:E$7)-SUM(E$8:E$11),0)","v":0},{"$f":"IFERROR(SUM(G$12:I$12)+G$17*MAX(0,I$31-G$31)+H$17*MAX(0,I$31-H$31),0)","v":0},{"$f":"SUM(K$6:K$7)","v":0},{"$f":"SUM(L$6:L$7)","v":0},{"$f":"SUM(M$6:M$7)","v":0},{"$f":"SUM(K$12:M$12)+K$17*MAX(0,M$31-K$31)+L$17*MAX(0,M$31-L$31)","v":0}]
[null,"1.9 MLR numerator Mini-Med and Student Health (using adjustment factor)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O$6:O$7)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),SUM(S$6:S$7),0)","v":0},{"$f":"SUM(P$6:P$7)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),SUM(T$6:T$7),0)","v":0},{"$f":"SUM(Q$6:Q$7)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),SUM(U$6:U$7),0)","v":0},{"$f":"IFERROR(SUM(R$6:R$7)+O$17*MAX(0,Q$31-O$31)+P$17*MAX(0,Q$31-P$31)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),SUM(V$6:V$7),0),0)","v":0},{"$f":"SUM(S$6:S$7)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),SUM(O$6:O$7),0)","v":0},{"$f":"SUM(T$6:T$7)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),SUM(P$6:P$7),0)","v":0},{"$f":"SUM(U$6:U$7)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),SUM(Q$6:Q$7),0)","v":0},{"$f":"IFERROR(SUM(V$6:V$7)+S$17*MAX(0,U$31-S$31)+T$17*MAX(0,U$31-T$31)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),SUM(R$6:R$7),0),0)","v":0},{"$f":"SUM(W$6:W$7)","v":0},{"$f":"SUM(X$6:X$7)","v":0},{"$f":"SUM(Y$6:Y$7)","v":0},{"$f":"SUM(Z$6:Z$7)+W$17*MAX(0,Y$31-W$31)+X$17*MAX(0,Y$31-X$31)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AI$6:AI$7)","v":0},{"$f":"SUM(AJ$6:AJ$7)","v":0},{"$f":"SUM(AK$6:AK$7)","v":0},{"$f":"SUM(AL$6:AL$7)","v":0}]
[null,"2. Medical Loss Ratio Denominator"]
[null,"2.1 Premium earned including Federal and State high risk programs and adjusted for net premium stabilization program payments / (charges)",null,null,{"$f":"SUM('Pt 1 Summary of Data'!$E$5:$E$7)+SUM('Pt 1 Summary of Data'!$G$5:$G$7)-SUM('Pt 1 Summary of Data'!$H$5:$H$7)-SUM(E$9:E$11)-$E$41","v":0},{"$f":"SUM(C15:E15)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!$J$5:$J$7)+SUM('Pt 1 Summary of Data'!$L$5:$L$7)-SUM('Pt 1 Summary of Data'!$M$5:$M$7)-SUM(I$10:I$11)-$I$41","v":0},{"$f":"SUM(G15:I15)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!$O$5:$O$7)+SUM('Pt 1 Summary of Data'!$Q$5:$Q$7)-SUM('Pt 1 Summary of Data'!$R$5:$R$7)-$M$41","v":0},{"$f":"SUM(K15:M15)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!T$5:T$7)-$Q$41","v":0},{"$f":"SUM(O15:Q15)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!W$5:W$7)-$U$41","v":0},{"$f":"SUM(S15:U15)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!Z$5:Z$7)-$Y$41","v":0},{"$f":"SUM(W15:Y15)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Pt 1 Summary of Data'!AM$5:AM$7)+SUM('Pt 1 Summary of Data'!AO$5:AO$7)-SUM('Pt 1 Summary of Data'!AP$5:AP$7)-$AK$41","v":0},{"$f":"SUM(AI15:AK15)","v":0}]
[null,"2.2 Federal and State taxes and licensing or regulatory fees",null,null,{"$f":"SUM('Pt 1 Summary of Data'!$E$25:$E$28,'Pt 1 Summary of Data'!$E$30,'Pt 1 Summary of Data'!$E$34:$E$35)+SUM('Pt 1 Summary of Data'!$G$25:$G$28,'Pt 1 Summary of Data'!$G$30,'Pt 1 Summary of Data'!$G$34:$G$35)-SUM('Pt 1 Summary of Data'!$H$25:$H$28,'Pt 1 Summary of Data'!$H$30,'Pt 1 Summary of Data'!$H$34:$H$35)+IF('Company Information'!$C$15=\"No\",IF(MAX('Pt 1 Summary of Data'!$E$31:$E$32)=0,MIN('Pt 1 Summary of Data'!$E$31:$E$32),MAX('Pt 1 Summary of Data'!$E$31:$E$32))+IF(MAX('Pt 1 Summary of Data'!$G$31:$G$32)=0,MIN('Pt 1 Summary of Data'!$G$31:$G$32),MAX('Pt 1 Summary of Data'!$G$31:$G$32))-IF(MAX('Pt 1 Summary of Data'!$H$31:$H$32)=0,MIN('Pt 1 Summary of Data'!$H$31:$H$32),MAX('Pt 1 Summary of Data'!$H$31:$H$32)),SUM('Pt 1 Summary of Data'!$E$31:$E$32)+SUM('Pt 1 Summary of Data'!$G$31:$G$32)-SUM('Pt 1 Summary of Data'!$H$31:$H$32))-$E$42","v":0},{"$f":"SUM(C16:E16)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!$J$25:$J$28,'Pt 1 Summary of Data'!$J$30,'Pt 1 Summary of Data'!$J$34:$J$35)+SUM('Pt 1 Summary of Data'!$L$25:$L$28,'Pt 1 Summary of Data'!$L$30,'Pt 1 Summary of Data'!$L$34:$L$35)-SUM('Pt 1 Summary of Data'!$M$25:$M$28,'Pt 1 Summary of Data'!$M$30,'Pt 1 Summary of Data'!$M$34:$M$35)+IF('Company Information'!$C$15=\"No\",IF(MAX('Pt 1 Summary of Data'!$J$31:$J$32)=0,MIN('Pt 1 Summary of Data'!$J$31:$J$32),MAX('Pt 1 Summary of Data'!$J$31:$J$32))+IF(MAX('Pt 1 Summary of Data'!$L$31:$L$32)=0,MIN('Pt 1 Summary of Data'!$L$31:$L$32),MAX('Pt 1 Summary of Data'!$L$31:$L$32))-IF(MAX('Pt 1 Summary of Data'!$M$31:$M$32)=0,MIN('Pt 1 Summary of Data'!$M$31:$M$32),MAX('Pt 1 Summary of Data'!$M$31:$M$32)),SUM('Pt 1 Summary of Data'!$J$31:$J$32)+SUM('Pt 1 Summary of Data'!$L$31:$L$32)-SUM('Pt 1 Summary of Data'!$M$31:$M$32))-$I$42","v":0},{"$f":"SUM(G16:I16)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!$O$25:$O$28,'Pt 1 Summary of Data'!$O$30,'Pt 1 Summary of Data'!$O$34:$O$35)+SUM('Pt 1 Summary of Data'!$Q$25:$Q$28,'Pt 1 Summary of Data'!$Q$30,'Pt 1 Summary of Data'!$Q$34:$Q$35)-SUM('Pt 1 Summary of Data'!$R$25:$R$28,'Pt 1 Summary of Data'!$R$30,'Pt 1 Summary of Data'!$R$34:$R$35)+IF('Company Information'!$C$15=\"No\",IF(MAX('Pt 1 Summary of Data'!$O$31:$O$32)=0,MIN('Pt 1 Summary of Data'!$O$31:$O$32),MAX('Pt 1 Summary of Data'!$O$31:$O$32))+IF(MAX('Pt 1 Summary of Data'!$Q$31:$Q$32)=0,MIN('Pt 1 Summary of Data'!$Q$31:$Q$32),MAX('Pt 1 Summary of Data'!$Q$31:$Q$32))-IF(MAX('Pt 1 Summary of Data'!$R$31:$R$32)=0,MIN('Pt 1 Summary of Data'!$R$31:$R$32),MAX('Pt 1 Summary of Data'!$R$31:$R$32)),SUM('Pt 1 Summary of Data'!$O$31:$O$32)+SUM('Pt 1 Summary of Data'!$Q$31:$Q$32)-SUM('Pt 1 Summary of Data'!$R$31:$R$32))-$M$42","v":0},{"$f":"SUM(K16:M16)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!T$25:T$28,'Pt 1 Summary of Data'!T$30,'Pt 1 Summary of Data'!T$34:T$35)+IF('Company Information'!$C$15=\"No\",IF(MAX('Pt 1 Summary of Data'!T$31:T$32)=0,MIN('Pt 1 Summary of Data'!T$31:T$32),MAX('Pt 1 Summary of Data'!T$31:T$32)),SUM('Pt 1 Summary of Data'!T$31:T$32))-$Q$42","v":0},{"$f":"SUM(O16:Q16)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!W$25:W$28,'Pt 1 Summary of Data'!W$30,'Pt 1 Summary of Data'!W$34:W$35)+IF('Company Information'!$C$15=\"No\",IF(MAX('Pt 1 Summary of Data'!W$31:W$32)=0,MIN('Pt 1 Summary of Data'!W$31:W$32),MAX('Pt 1 Summary of Data'!W$31:W$32)),SUM('Pt 1 Summary of Data'!W$31:W$32))-$U$42","v":0},{"$f":"SUM(S16:U16)","v":0},null,null,{"$f":"SUM('Pt 1 Summary of Data'!Z$25:Z$28,'Pt 1 Summary of Data'!Z$30,'Pt 1 Summary of Data'!Z$34:Z$35)+IF('Company Information'!$C$15=\"No\",IF(MAX('Pt 1 Summary of Data'!Z$31:Z$32)=0,MIN('Pt 1 Summary of Data'!Z$31:Z$32),MAX('Pt 1 Summary of Data'!Z$31:Z$32)),SUM('Pt 1 Summary of Data'!Z$31:Z$32))-$Y$42","v":0},{"$f":"SUM(W16:Y16)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Pt 1 Summary of Data'!AM$25:AM$28,'Pt 1 Summary of Data'!AM$30,'Pt 1 Summary of Data'!AM$34:AM$35)+SUM('Pt 1 Summary of Data'!AO$25:AO$28,'Pt 1 Summary of Data'!AO$30,'Pt 1 Summary of Data'!AO$34:AO$35)-SUM('Pt 1 Summary of Data'!AP$25:AP$28,'Pt 1 Summary of Data'!AP$30,'Pt 1 Summary of Data'!AP$34:AP$35)+IF('Company Information'!$C$15=\"No\",IF(MAX('Pt 1 Summary of Data'!AM$31:AM$32)=0,MIN('Pt 1 Summary of Data'!AM$31:AM$32),MAX('Pt 1 Summary of Data'!AM$31:AM$32))+IF(MAX('Pt 1 Summary of Data'!AO$31:AO$32)=0,MIN('Pt 1 Summary of Data'!AO$31:AO$32),MAX('Pt 1 Summary of Data'!AO$31:AO$32))-IF(MAX('Pt 1 Summary of Data'!AP$31:AP$32)=0,MIN('Pt 1 Summary of Data'!AP$31:AP$32),MAX('Pt 1 Summary of Data'!AP$31:AP$32)),SUM('Pt 1 Summary of Data'!AM$31:AM$32)+SUM('Pt 1 Summary of Data'!AO$31:AO$32)-SUM('Pt 1 Summary of Data'!AP$31:AP$32))-$AK$42","v":0},{"$f":"SUM(AI16:AK16)","v":0}]
[null,"2.3 MLR Denominator (Lines 2.1 - 2.2) ",{"$f":"C$15-C$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),G$15-G$16,0)","v":0},{"$f":"D$15-D$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),H$15-H$16,0)","v":0},{"$f":"E$15-E$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),I$15-I$16,0)","v":0},{"$f":"F$15-F$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),J$15-J$16,0)","v":0},{"$f":"G$15-G$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),C$15-C$16,0)","v":0},{"$f":"H$15-H$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),D$15-D$16,0)","v":0},{"$f":"I$15-I$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),E$15-E$16,0)","v":0},{"$f":"J$15-J$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),F$15-F$16,0)","v":0},{"$f":"K$15-K$16","v":0},{"$f":"L$15-L$16","v":0},{"$f":"M$15-M$16","v":0},{"$f":"N$15-N$16","v":0},{"$f":"O$15-O$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),S$15-S$16,0)","v":0},{"$f":"P$15-P$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),T$15-T$16,0)","v":0},{"$f":"Q$15-Q$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),U$15-U$16,0)","v":0},{"$f":"R$15-R$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),V$15-V$16,0)","v":0},{"$f":"S$15-S$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),O$15-O$16,0)","v":0},{"$f":"T$15-T$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),P$15-P$16,0)","v":0},{"$f":"U$15-U$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),Q$15-Q$16,0)","v":0},{"$f":"V$15-V$16+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),R$15-R$16,0)","v":0},{"$f":"W$15-W$16","v":0},{"$f":"X$15-X$16","v":0},{"$f":"Y$15-Y$16","v":0},{"$f":"Z$15-Z$16","v":0},null,null,null,null,null,null,null,null,{"$f":"AI$15-AI$16","v":0},{"$f":"AJ$15-AJ$16","v":0},{"$f":"AK$15-AK$16","v":0},{"$f":"AL$15-AL$16","v":0}]
[null,"3. Credibility Adjustment"]
[null,"3.1 Life-years",null,null,{"$f":"('Pt 1 Summary of Data'!$E$59+'Pt 1 Summary of Data'!$G$59-'Pt 1 Summary of Data'!$H$59)/12+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),'Pt 1 Summary of Data'!$J$59+'Pt 1 Summary of Data'!$L$59-'Pt 1 Summary of Data'!$M$59,0)/12","v":0},{"$f":"SUM(C$19:E$19)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),IF($C$19<>$G$19,$G$19,0)+IF($D$19<>$H$19,$H$19,0),0)","v":0},null,null,{"$f":"('Pt 1 Summary of Data'!$J$59+'Pt 1 Summary of Data'!$L$59-'Pt 1 Summary of Data'!$M$59)/12+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),'Pt 1 Summary of Data'!$E$59+'Pt 1 Summary of Data'!$G$59-'Pt 1 Summary of Data'!$H$59,0)/12","v":0},{"$f":"SUM(G$19:I$19)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),IF($C$19<>$G$19,$C$19,0)+IF($D$19<>$H$19,$D$19,0),0)","v":0},null,null,{"$f":"('Pt 1 Summary of Data'!$O$59+'Pt 1 Summary of Data'!$Q$59-'Pt 1 Summary of Data'!$R$59)/12","v":0},{"$f":"SUM(K$19:M$19)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!T$59/12+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),'Pt 1 Summary of Data'!W$59,0)/12","v":0},{"$f":"SUM(O$19:Q$19)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),IF($O$19<>$S$19,$S$19,0)+IF($P$19<>$T$19,$T$19,0),0)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!W$59/12+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),'Pt 1 Summary of Data'!T$59,0)/12","v":0},{"$f":"SUM(S$19:U$19)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),IF($O$19<>$S$19,$O$19,0)+IF($P$19<>$T$19,$P$19,0),0)","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!Z$59/12","v":0},{"$f":"SUM(W$19:Y$19)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"('Pt 1 Summary of Data'!AM$59+'Pt 1 Summary of Data'!AO$59-'Pt 1 Summary of Data'!AP$59)/12","v":0},{"$f":"SUM(AI19:AK19)","v":0}]
[null,"3.2 Base credibility factor ",null,null,null,{"$f":"IF(OR(F$19<1000,F$19>=75000,AND(C$19>=1000,D$19>=1000,E$19>=1000,C$26<C$31,D$26<D$31,E$26<E$31)),0,VLOOKUP(F$19,'Reference Tables'!$A$4:$B$11,2)+((F$19-VLOOKUP(F$19,'Reference Tables'!$A$4:$B$11,1))*(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(F$19,'Reference Tables'!$A$4:$A$11)),1,1)-VLOOKUP(F$19,'Reference Tables'!$A$4:$B$11,2))/(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(F$19,'Reference Tables'!$A$4:$A$11)),1,0)-VLOOKUP(F$19,'Reference Tables'!$A$4:$B$11,1))))","v":0},null,null,null,{"$f":"IF(OR(J$19<1000,J$19>=75000,AND(G$19>=1000,H$19>=1000,I$19>=1000,G$26<G$31,H$26<H$31,I$26<I$31)),0,VLOOKUP(J$19,'Reference Tables'!$A$4:$B$11,2)+((J$19-VLOOKUP(J$19,'Reference Tables'!$A$4:$B$11,1))*(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(J$19,'Reference Tables'!$A$4:$A$11)),1,1)-VLOOKUP(J$19,'Reference Tables'!$A$4:$B$11,2))/(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(J$19,'Reference Tables'!$A$4:$A$11)),1,0)-VLOOKUP(J$19,'Reference Tables'!$A$4:$B$11,1))))","v":0},null,null,null,{"$f":"IF(OR(N$19<1000,N$19>=75000,AND(K$19>=1000,L$19>=1000,M$19>=1000,K$26<K$31,L$26<L$31,M$26<M$31)),0,VLOOKUP(N$19,'Reference Tables'!$A$4:$B$11,2)+((N$19-VLOOKUP(N$19,'Reference Tables'!$A$4:$B$11,1))*(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(N$19,'Reference Tables'!$A$4:$A$11)),1,1)-VLOOKUP(N$19,'Reference Tables'!$A$4:$B$11,2))/(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(N$19,'Reference Tables'!$A$4:$A$11)),1,0)-VLOOKUP(N$19,'Reference Tables'!$A$4:$B$11,1))))","v":0},null,null,null,{"$f":"IF(OR(R$19<1000,R$19>=75000,AND(O$19>=1000,P$19>=1000,Q$19>=1000,O$27<O$31,P$27<P$31,Q$27<Q$31)),0,VLOOKUP(R$19,'Reference Tables'!$A$4:$B$11,2)+((R$19-VLOOKUP(R$19,'Reference Tables'!$A$4:$B$11,1))*(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(R$19,'Reference Tables'!$A$4:$A$11)),1,1)-VLOOKUP(R$19,'Reference Tables'!$A$4:$B$11,2))/(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(R$19,'Reference Tables'!$A$4:$A$11)),1,0)-VLOOKUP(R$19,'Reference Tables'!$A$4:$B$11,1))))","v":0},null,null,null,{"$f":"IF(OR(V$19<1000,V$19>=75000,AND(S$19>=1000,T$19>=1000,U$19>=1000,S$27<S$31,T$27<T$31,U$27<U$31)),0,VLOOKUP(V$19,'Reference Tables'!$A$4:$B$11,2)+((V$19-VLOOKUP(V$19,'Reference Tables'!$A$4:$B$11,1))*(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(V$19,'Reference Tables'!$A$4:$A$11)),1,1)-VLOOKUP(V$19,'Reference Tables'!$A$4:$B$11,2))/(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(V$19,'Reference Tables'!$A$4:$A$11)),1,0)-VLOOKUP(V$19,'Reference Tables'!$A$4:$B$11,1))))","v":0},null,null,null,{"$f":"IF(OR(Z$19<1000,Z$19>=75000,AND(W$19>=1000,X$19>=1000,Y$19>=1000,W$27<W$31,X$27<X$31,Y$27<Y$31)),0,VLOOKUP(Z$19,'Reference Tables'!$A$4:$B$11,2)+((Z$19-VLOOKUP(Z$19,'Reference Tables'!$A$4:$B$11,1))*(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(Z$19,'Reference Tables'!$A$4:$A$11)),1,1)-VLOOKUP(Z$19,'Reference Tables'!$A$4:$B$11,2))/(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(Z$19,'Reference Tables'!$A$4:$A$11)),1,0)-VLOOKUP(Z$19,'Reference Tables'!$A$4:$B$11,1))))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AL$19<1000,AL$19>=75000,AND(AI$19>=1000,AJ$19>=1000,AK$19>=1000,AI$27<AI$31,AJ$27<AJ$31,AK$27<AK$31)),0,VLOOKUP(AL$19,'Reference Tables'!$A$4:$B$11,2)+((AL$19-VLOOKUP(AL$19,'Reference Tables'!$A$4:$B$11,1))*(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(AL$19,'Reference Tables'!$A$4:$A$11)),1,1)-VLOOKUP(AL$19,'Reference Tables'!$A$4:$B$11,2))/(OFFSET(INDEX('Reference Tables'!$A$4:$A$11,MATCH(AL$19,'Reference Tables'!$A$4:$A$11)),1,0)-VLOOKUP(AL$19,'Reference Tables'!$A$4:$B$11,1))))","v":0}]
[null,"3.3 Average deductible "]
[null,"3.4 Deductible factor ",null,null,null,{"$f":"IF(F$21<2500,1,(MIN(VLOOKUP(F$21,'Reference Tables'!$A$17:$B$20,2)+((F$21-VLOOKUP(F$21,'Reference Tables'!$A$17:$B$20,1))*(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(F$21,'Reference Tables'!$A$17:$A$20)),1,1)-VLOOKUP(F$21,'Reference Tables'!$A$17:$B$20,2))/(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(F$21,'Reference Tables'!$A$17:$A$20)),1,0)-VLOOKUP(F$21,'Reference Tables'!$A$17:$B$20,1))),1.736)))","v":1},null,null,null,{"$f":"IF(J$21<2500,1,(MIN(VLOOKUP(J$21,'Reference Tables'!$A$17:$B$20,2)+((J$21-VLOOKUP(J$21,'Reference Tables'!$A$17:$B$20,1))*(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(J$21,'Reference Tables'!$A$17:$A$20)),1,1)-VLOOKUP(J$21,'Reference Tables'!$A$17:$B$20,2))/(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(J$21,'Reference Tables'!$A$17:$A$20)),1,0)-VLOOKUP(J$21,'Reference Tables'!$A$17:$B$20,1))),1.736)))","v":1},null,null,null,{"$f":"IF(N$21<2500,1,(MIN(VLOOKUP(N$21,'Reference Tables'!$A$17:$B$20,2)+((N$21-VLOOKUP(N$21,'Reference Tables'!$A$17:$B$20,1))*(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(N$21,'Reference Tables'!$A$17:$A$20)),1,1)-VLOOKUP(N$21,'Reference Tables'!$A$17:$B$20,2))/(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(N$21,'Reference Tables'!$A$17:$A$20)),1,0)-VLOOKUP(N$21,'Reference Tables'!$A$17:$B$20,1))),1.736)))","v":1},null,null,null,{"$f":"IF(R$21<2500,1,(MIN(VLOOKUP(R$21,'Reference Tables'!$A$17:$B$20,2)+((R$21-VLOOKUP(R$21,'Reference Tables'!$A$17:$B$20,1))*(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(R$21,'Reference Tables'!$A$17:$A$20)),1,1)-VLOOKUP(R$21,'Reference Tables'!$A$17:$B$20,2))/(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(R$21,'Reference Tables'!$A$17:$A$20)),1,0)-VLOOKUP(R$21,'Reference Tables'!$A$17:$B$20,1))),1.736)))","v":1},null,null,null,{"$f":"IF(V$21<2500,1,(MIN(VLOOKUP(V$21,'Reference Tables'!$A$17:$B$20,2)+((V$21-VLOOKUP(V$21,'Reference Tables'!$A$17:$B$20,1))*(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(V$21,'Reference Tables'!$A$17:$A$20)),1,1)-VLOOKUP(V$21,'Reference Tables'!$A$17:$B$20,2))/(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(V$21,'Reference Tables'!$A$17:$A$20)),1,0)-VLOOKUP(V$21,'Reference Tables'!$A$17:$B$20,1))),1.736)))","v":1},null,null,null,{"$f":"IF(Z$21<2500,1,(MIN(VLOOKUP(Z$21,'Reference Tables'!$A$17:$B$20,2)+((Z$21-VLOOKUP(Z$21,'Reference Tables'!$A$17:$B$20,1))*(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(Z$21,'Reference Tables'!$A$17:$A$20)),1,1)-VLOOKUP(Z$21,'Reference Tables'!$A$17:$B$20,2))/(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(Z$21,'Reference Tables'!$A$17:$A$20)),1,0)-VLOOKUP(Z$21,'Reference Tables'!$A$17:$B$20,1))),1.736)))","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL$21<2500,1,(MIN(VLOOKUP(AL$21,'Reference Tables'!$A$17:$B$20,2)+((AL$21-VLOOKUP(AL$21,'Reference Tables'!$A$17:$B$20,1))*(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(AL$21,'Reference Tables'!$A$17:$A$20)),1,1)-VLOOKUP(AL$21,'Reference Tables'!$A$17:$B$20,2))/(OFFSET(INDEX('Reference Tables'!$A$17:$A$20,MATCH(AL$21,'Reference Tables'!$A$17:$A$20)),1,0)-VLOOKUP(AL$21,'Reference Tables'!$A$17:$B$20,1))),1.736)))","v":1}]
[null,"3.5 Credibility adjustment (Lines 3.2 x 3.4 (do not round)) ",null,null,null,{"$f":"IF(OR(F$19<1000,F$19>=75000),0,F$20*F$22)","v":0},null,null,null,{"$f":"IF(OR(J$19<1000,J$19>=75000),0,J$20*J$22)","v":0},null,null,null,{"$f":"IF(OR(N$19<1000,N$19>=75000),0,N$20*N$22)","v":0},null,null,null,{"$f":"IF(OR(R$19<1000,R$19>=75000),0,R$20*R$22)","v":0},null,null,null,{"$f":"IF(OR(V$19<1000,V$19>=75000),0,V$20*V$22)","v":0},null,null,null,{"$f":"IF(OR(Z$19<1000,Z$19>=75000),0,Z$20*Z$22)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AL$19<1000,AL$19>=75000),0,AL$20*AL$22)","v":0}]
[null,"4. MLR Calculation (for issuers with at least 1,000 life years in the Total column of Line 3.1)"]
[null,"4.1 Preliminary MLR"]
[null,"4.1a  Preliminary MLR (Lines 1.8 / 2.3)",{"$f":"IF(C$17<=0,\"\",C$12/C$17)","v":""},{"$f":"IF(D$17<=0,\"\",D$12/D$17)","v":""},{"$f":"IF(E$17<=0,\"\",E$12/E$17)","v":""},{"$f":"IF(OR(F$19<1000,F$17<=0),\"\",F$12/F$17)","v":""},{"$f":"IF(G$17<=0,\"\",G$12/G$17)","v":""},{"$f":"IF(H$17<=0,\"\",H$12/H$17)","v":""},{"$f":"IF(I$17<=0,\"\",I$12/I$17)","v":""},{"$f":"IF(OR(J$19<1000,J$17<=0),\"\",J$12/J$17)","v":""},{"$f":"IF(K$17<=0,\"\",K$12/K$17)","v":""},{"$f":"IF(L$17<=0,\"\",L$12/L$17)","v":""},{"$f":"IF(M$17<=0,\"\",M$12/M$17)","v":""},{"$f":"IF(OR(N$19<1000,N$17<=0),\"\",N$12/N$17)","v":""}]
[null,"4.1b  Preliminary MLR: Mini-Med and Student Health  (Lines 1.9 / 2.3)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O$17<=0,\"\",O$13/O$17)","v":""},{"$f":"IF(P$17<=0,\"\",P$13/P$17)","v":""},{"$f":"IF(Q$17<=0,\"\",Q$13/Q$17)","v":""},{"$f":"IF(OR(R$19<1000,R$17<=0),\"\",R$13/R$17)","v":""},{"$f":"IF(S$17<=0,\"\",S$13/S$17)","v":""},{"$f":"IF(T$17<=0,\"\",T$13/T$17)","v":""},{"$f":"IF(U$17<=0,\"\",U$13/U$17)","v":""},{"$f":"IF(OR(V$19<1000,V$17<=0),\"\",V$13/V$17)","v":""},{"$f":"IF(W$17<=0,\"\",W$13/W$17)","v":""},{"$f":"IF(X$17<=0,\"\",X$13/X$17)","v":""},{"$f":"IF(Y$17<=0,\"\",Y$13/Y$17)","v":""},{"$f":"IF(OR(Z$19<1000,Z$17<=0),\"\",Z$13/Z$17)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AI$17<=0,\"\",AI$13/AI$17)","v":""},{"$f":"IF(AJ$17<=0,\"\",AJ$13/AJ$17)","v":""},{"$f":"IF(AK$17<=0,\"\",AK$13/AK$17)","v":""},{"$f":"IF(OR(AL$19<1000,AL$17<=0),\"\",AL$13/AL$17)","v":""}]
[null,"4.2 Credibility adjustment (Line 3.5, if applicable)",null,null,null,{"$f":"IF(F$26=\"\",\"\",F$23)","v":""},null,null,null,{"$f":"IF(J$26=\"\",\"\",J$23)","v":""},null,null,null,{"$f":"IF(N$26=\"\",\"\",N$23)","v":""},null,null,null,{"$f":"IF(R$27=\"\",\"\",R$23)","v":""},null,null,null,{"$f":"IF(V$27=\"\",\"\",V$23)","v":""},null,null,null,{"$f":"IF(Z$27=\"\",\"\",Z$23)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL$27=\"\",\"\",AL$23)","v":""}]
[null,"4.3 Credibility-adjusted MLR (Lines 4.1a or 4.1b + 4.2)",null,null,null,{"$f":"IF(F$26=\"\",\"\",ROUND(F$26+MAX(0,F$28),3))","v":""},null,null,null,{"$f":"IF(J$26=\"\",\"\",ROUND(J$26+MAX(0,J$28),3))","v":""},null,null,null,{"$f":"IF(N$26=\"\",\"\",ROUND(N$26+MAX(0,N$28),3))","v":""},null,null,null,{"$f":"IF(R$27=\"\",\"\",ROUND(R$27+MAX(0,R$28),3))","v":""},null,null,null,{"$f":"IF(V$27=\"\",\"\",ROUND(V$27+MAX(0,V$28),3))","v":""},null,null,null,{"$f":"IF(Z$27=\"\",\"\",ROUND(Z$27+MAX(0,Z$28),3))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL$27=\"\",\"\",ROUND(AL$27+MAX(0,AL$28),3))","v":""}]
[null,"5. Rebate Calculation"]
[null,"5.1 MLR standard",{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,6,FALSE)))","v":0.82},{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,4,FALSE)))","v":0.82},{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,2,FALSE)))","v":0.82},{"$f":"E$31","v":0.82},{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,7,FALSE)))","v":0.82},{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,5,FALSE)))","v":0.82},{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,3,FALSE)))","v":0.82},{"$f":"I$31","v":0.82},0.85,0.85,0.85,0.85,{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,6,FALSE)))","v":0.82},{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,4,FALSE)))","v":0.82},{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,2,FALSE)))","v":0.82},{"$f":"Q$31","v":0.82},{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,7,FALSE)))","v":0.82},{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,5,FALSE)))","v":0.82},{"$f":"IF('Company Information'!$C$12=\"\",\"Please select a State\",IF('Company Information'!$C$12=\"Grand Total\",\"\",VLOOKUP('Company Information'!$C$12,'Reference Tables'!$D$3:$R$61,3,FALSE)))","v":0.82},{"$f":"U$31","v":0.8},0.85,0.85,0.85,0.85,null,null,null,null,null,null,null,null,0.8,0.8,0.8,0.8]
[null,"5.2 Credibility-adjusted MLR (Line 4.3)",null,null,null,{"$f":"F$29","v":""},null,null,null,{"$f":"J$29","v":""},null,null,null,{"$f":"N$29","v":""},null,null,null,{"$f":"R$29","v":""},null,null,null,{"$f":"V$29","v":""},null,null,null,{"$f":"Z$29","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL$29","v":""}]
[null,"5.3 Adjusted earned premium (Lines 2.1 - 2.2 CY)",null,null,null,{"$f":"IF(F$19<1000,\"\",MAX(0,E$15-E$16))","v":""},null,null,null,{"$f":"IF(J$19<1000,\"\",MAX(0,I$15-I$16))","v":""},null,null,null,{"$f":"IF(N$19<1000,\"\",MAX(0,M$15-M$16))","v":""},null,null,null,{"$f":"IF(R$19<1000,\"\",MAX(0,Q$15-Q$16))","v":""},null,null,null,{"$f":"IF(V$19<1000,\"\",MAX(0,U$15-U$16))","v":""},null,null,null,{"$f":"IF(Z$19<1000,\"\",MAX(0,Y$15-Y$16))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL$19<1000,\"\",MAX(0,AK$15-AK$16))","v":""}]
[null,"5.4 Rebate amount if credibility-adjusted MLR is less than MLR standard (Lines (5.1 - 5.2) x 5.3)",null,null,null,{"$f":"IF(OR(F$19<1000,E$19=0,F$17<=0),0,MAX(0,SUM(F$31)-SUM(F$32))*F$33)","v":0},null,null,null,{"$f":"IF(OR(J$19<1000,I$19=0,J$17<=0),0,MAX(0,SUM(J$31)-SUM(J$32))*J$33)","v":0},null,null,null,{"$f":"IF(OR(N$19<1000,M$19=0,N$17<=0),0,MAX(0,SUM(N$31)-SUM(N$32))*N$33)","v":0},null,null,null,{"$f":"IF(OR(R$19<1000,Q$19=0,R$17<=0),0,MAX(0,SUM(R$31)-SUM(R$32))*R$33)","v":0},null,null,null,{"$f":"IF(OR(V$19<1000,U$19=0,V$17<=0),0,MAX(0,SUM(V$31)-SUM(V$32))*V$33)","v":0},null,null,null,{"$f":"IF(OR(Z$19<1000,Y$19=0,Z$17<=0),0,MAX(0,SUM(Z$31)-SUM(Z$32))*Z$33)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AL$19<1000,AK$19=0,AL$17<=0),0,MAX(0,SUM(AL$31)-SUM(AL$32))*AL$33)","v":0}]
[null,"5.5 Optional: single-year rebate liability (Line 2.3 x [Line 5.1 - (Lines 4.1a or 4.1b + 4.2)])",{"$f":"IFERROR(MAX(0,C$17*(C$31-ROUND(C$26+F$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,D$17*(D$31-ROUND(D$26+F$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,E$17*(E$31-ROUND(E$26+F$28,3))),\"\")","v":""},null,{"$f":"IFERROR(MAX(0,G$17*(G$31-ROUND(G$26+J$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,H$17*(H$31-ROUND(H$26+J$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,I$17*(I$31-ROUND(I$26+J$28,3))),\"\")","v":""},null,{"$f":"IFERROR(MAX(0,K$17*(K$31-ROUND(K$26+N$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,L$17*(L$31-ROUND(L$26+N$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,M$17*(M$31-ROUND(M$26+N$28,3))),\"\")","v":""},null,{"$f":"IFERROR(MAX(0,O$17*(O$31-ROUND(O$27+R$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,P$17*(P$31-ROUND(P$27+R$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,Q$17*(Q$31-ROUND(Q$27+R$28,3))),\"\")","v":""},null,{"$f":"IFERROR(MAX(0,S$17*(S$31-ROUND(S$27+V$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,T$17*(T$31-ROUND(T$27+V$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,U$17*(U$31-ROUND(U$27+V$28,3))),\"\")","v":""},null,{"$f":"IFERROR(MAX(0,W$17*(W$31-ROUND(W$27+Z$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,X$17*(X$31-ROUND(X$27+Z$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,Y$17*(Y$31-ROUND(Y$27+Z$28,3))),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MAX(0,AI$17*(AI$31-ROUND(AI$27+AL$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,AJ$17*(AJ$31-ROUND(AJ$27+AL$28,3))),\"\")","v":""},{"$f":"IFERROR(MAX(0,AK$17*(AK$31-ROUND(AK$27+AL$28,3))),\"\")","v":""}]
[null,"5.6 Optional: paid rebate liability (see instructions)",{"$f":"IF(OR(C$35=\"\",'PY Rebate Liability'!E$5+'PY Rebate Liability'!E$8+'PY Rebate Liability'!D$20+'PY Rebate Liability'!D$23=0),\"\",IF(SUM('PY Rebate Liability'!C$31:F$34)<>0,'PY Rebate Liability'!D$32+'PY Rebate Liability'!D$34+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM('PY Rebate Liability'!H$31:K$34)<>0),'PY Rebate Liability'!I$34,0),IFERROR('PY Rebate Liability'!F$30*'PY Rebate Liability'!D$23*MAX(0,IF('PY Rebate Liability'!D$23<=0,0,C$31-'PY Rebate Liability'!D$20/'PY Rebate Liability'!D$23-'PY Rebate Liability'!F$25))/('PY Rebate Liability'!C$23*MAX(0,IF('PY Rebate Liability'!C$23<=0,0,MAX(80%,'PY Rebate Liability'!C$27)-'PY Rebate Liability'!C$20/'PY Rebate Liability'!C$23-'PY Rebate Liability'!F$25))+'PY Rebate Liability'!D$23*MAX(0,IF('PY Rebate Liability'!D$23<=0,0,C$31-'PY Rebate Liability'!D$20/'PY Rebate Liability'!D$23-'PY Rebate Liability'!F$25))+'PY Rebate Liability'!E$23*MAX(0,IF('PY Rebate Liability'!E$23<=0,0,D$31-'PY Rebate Liability'!E$20/'PY Rebate Liability'!E$23-'PY Rebate Liability'!F$25))),0)+IFERROR('PY Rebate Liability'!F$15*'PY Rebate Liability'!E$8*MAX(0,IF('PY Rebate Liability'!E$8<=0,0,C$31-'PY Rebate Liability'!E$5/'PY Rebate Liability'!E$8-'PY Rebate Liability'!F$10))/('PY Rebate Liability'!C$8*MAX(0,IF('PY Rebate Liability'!C$8<=0,0,MAX(80%,'PY Rebate Liability'!C$12)-'PY Rebate Liability'!C$5/'PY Rebate Liability'!C$8-'PY Rebate Liability'!F$10))+'PY Rebate Liability'!D$8*MAX(0,IF('PY Rebate Liability'!D$8<=0,0,MAX(80%,'PY Rebate Liability'!D$12)-'PY Rebate Liability'!D$5/'PY Rebate Liability'!D$8-'PY Rebate Liability'!F$10))+'PY Rebate Liability'!E$8*MAX(0,IF('PY Rebate Liability'!E$8<=0,0,C$31-'PY Rebate Liability'!E$5/'PY Rebate Liability'!E$8-'PY Rebate Liability'!F$10))),0)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),IFERROR('PY Rebate Liability'!K$30*'PY Rebate Liability'!I$23*MAX(0,IF('PY Rebate Liability'!I$23<=0,0,G$31-'PY Rebate Liability'!I$20/'PY Rebate Liability'!I$23-'PY Rebate Liability'!K$25))/('PY Rebate Liability'!H$23*MAX(0,IF('PY Rebate Liability'!H$23<=0,0,MAX(80%,'PY Rebate Liability'!H$27)-'PY Rebate Liability'!H$20/'PY Rebate Liability'!H$23-'PY Rebate Liability'!K$25))+'PY Rebate Liability'!I$23*MAX(0,IF('PY Rebate Liability'!I$23<=0,0,G$31-'PY Rebate Liability'!I$20/'PY Rebate Liability'!I$23-'PY Rebate Liability'!K$25))+'PY Rebate Liability'!J$23*MAX(0,IF('PY Rebate Liability'!J$23<=0,0,H$31-'PY Rebate Liability'!J$20/'PY Rebate Liability'!J$23-'PY Rebate Liability'!K$25))),0)+IFERROR('PY Rebate Liability'!K$15*'PY Rebate Liability'!J$8*MAX(0,IF('PY Rebate Liability'!J$8<=0,0,G$31-'PY Rebate Liability'!J$5/'PY Rebate Liability'!J$8-'PY Rebate Liability'!K$10))/('PY Rebate Liability'!H$8*MAX(0,IF('PY Rebate Liability'!H$8<=0,0,MAX(80%,'PY Rebate Liability'!H$12)-'PY Rebate Liability'!H$5/'PY Rebate Liability'!H$8-'PY Rebate Liability'!K$10))+'PY Rebate Liability'!I$8*MAX(0,IF('PY Rebate Liability'!I$8<=0,0,MAX(80%,'PY Rebate Liability'!I$12)-'PY Rebate Liability'!I$5/'PY Rebate Liability'!I$8-'PY Rebate Liability'!K$10))+'PY Rebate Liability'!J$8*MAX(0,IF('PY Rebate Liability'!J$8<=0,0,G$31-'PY Rebate Liability'!J$5/'PY Rebate Liability'!J$8-'PY Rebate Liability'!K$10))),0),0)))","v":""},{"$f":"IF(OR(D$35=\"\",'PY Rebate Liability'!E$20+'PY Rebate Liability'!E$23=0),\"\",IF(SUM('PY Rebate Liability'!C$31:F$34)<>0,'PY Rebate Liability'!E$34+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM('PY Rebate Liability'!H$31:K$34)<>0),'PY Rebate Liability'!J$34,0),IFERROR('PY Rebate Liability'!F$30*'PY Rebate Liability'!E$23*MAX(0,IF('PY Rebate Liability'!E$23<=0,0,D$31-'PY Rebate Liability'!E$20/'PY Rebate Liability'!E$23-'PY Rebate Liability'!F$25))/('PY Rebate Liability'!C$23*MAX(0,IF('PY Rebate Liability'!C$23<=0,0,MAX(80%,'PY Rebate Liability'!C$27)-'PY Rebate Liability'!C$20/'PY Rebate Liability'!C$23-'PY Rebate Liability'!F$25))+'PY Rebate Liability'!D$23*MAX(0,IF('PY Rebate Liability'!D$23<=0,0,C$31-'PY Rebate Liability'!D$20/'PY Rebate Liability'!D$23-'PY Rebate Liability'!F$25))+'PY Rebate Liability'!E$23*MAX(0,IF('PY Rebate Liability'!E$23<=0,0,D$31-'PY Rebate Liability'!E$20/'PY Rebate Liability'!E$23-'PY Rebate Liability'!F$25))),0)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($C$6:$F$11,$C$15:$F$16,$C$19:$D$19)<>0),IFERROR('PY Rebate Liability'!K$30*'PY Rebate Liability'!J$23*MAX(0,IF('PY Rebate Liability'!J$23<=0,0,H$31-'PY Rebate Liability'!J$20/'PY Rebate Liability'!J$23-'PY Rebate Liability'!K$25))/('PY Rebate Liability'!H$23*MAX(0,IF('PY Rebate Liability'!H$23<=0,0,MAX(80%,'PY Rebate Liability'!H$27)-'PY Rebate Liability'!H$20/'PY Rebate Liability'!H$23-'PY Rebate Liability'!K$25))+'PY Rebate Liability'!I$23*MAX(0,IF('PY Rebate Liability'!I$23<=0,0,G$31-'PY Rebate Liability'!I$20/'PY Rebate Liability'!I$23-'PY Rebate Liability'!K$25))+'PY Rebate Liability'!J$23*MAX(0,IF('PY Rebate Liability'!J$23<=0,0,H$31-'PY Rebate Liability'!J$20/'PY Rebate Liability'!J$23-'PY Rebate Liability'!K$25))),0),0)))","v":""},null,null,{"$f":"IF(OR(G$35=\"\",'PY Rebate Liability'!J$5+'PY Rebate Liability'!J$8+'PY Rebate Liability'!I$20+'PY Rebate Liability'!I$23=0),\"\",IF(SUM('PY Rebate Liability'!H$31:K$34)<>0,'PY Rebate Liability'!I$32+'PY Rebate Liability'!I$34+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM('PY Rebate Liability'!C$31:F$34)<>0),'PY Rebate Liability'!D$34,0),IFERROR('PY Rebate Liability'!K$30*'PY Rebate Liability'!I$23*MAX(0,IF('PY Rebate Liability'!I$23<=0,0,G$31-'PY Rebate Liability'!I$20/'PY Rebate Liability'!I$23-'PY Rebate Liability'!K$25))/('PY Rebate Liability'!H$23*MAX(0,IF('PY Rebate Liability'!H$23<=0,0,MAX(80%,'PY Rebate Liability'!H$27)-'PY Rebate Liability'!H$20/'PY Rebate Liability'!H$23-'PY Rebate Liability'!K$25))+'PY Rebate Liability'!I$23*MAX(0,IF('PY Rebate Liability'!I$23<=0,0,G$31-'PY Rebate Liability'!I$20/'PY Rebate Liability'!I$23-'PY Rebate Liability'!K$25))+'PY Rebate Liability'!J$23*MAX(0,IF('PY Rebate Liability'!J$23<=0,0,H$31-'PY Rebate Liability'!J$20/'PY Rebate Liability'!J$23-'PY Rebate Liability'!K$25))),0)+IFERROR('PY Rebate Liability'!K$15*'PY Rebate Liability'!J$8*MAX(0,IF('PY Rebate Liability'!J$8<=0,0,G$31-'PY Rebate Liability'!J$5/'PY Rebate Liability'!J$8-'PY Rebate Liability'!K$10))/('PY Rebate Liability'!H$8*MAX(0,IF('PY Rebate Liability'!H$8<=0,0,MAX(80%,'PY Rebate Liability'!H$12)-'PY Rebate Liability'!H$5/'PY Rebate Liability'!H$8-'PY Rebate Liability'!K$10))+'PY Rebate Liability'!I$8*MAX(0,IF('PY Rebate Liability'!I$8<=0,0,MAX(80%,'PY Rebate Liability'!I$12)-'PY Rebate Liability'!I$5/'PY Rebate Liability'!I$8-'PY Rebate Liability'!K$10))+'PY Rebate Liability'!J$8*MAX(0,IF('PY Rebate Liability'!J$8<=0,0,G$31-'PY Rebate Liability'!J$5/'PY Rebate Liability'!J$8-'PY Rebate Liability'!K$10))),0)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),IFERROR('PY Rebate Liability'!F$30*'PY Rebate Liability'!D$23*MAX(0,IF('PY Rebate Liability'!D$23<=0,0,C$31-'PY Rebate Liability'!D$20/'PY Rebate Liability'!D$23-'PY Rebate Liability'!F$25))/('PY Rebate Liability'!C$23*MAX(0,IF('PY Rebate Liability'!C$23<=0,0,MAX(80%,'PY Rebate Liability'!C$27)-'PY Rebate Liability'!C$20/'PY Rebate Liability'!C$23-'PY Rebate Liability'!F$25))+'PY Rebate Liability'!D$23*MAX(0,IF('PY Rebate Liability'!D$23<=0,0,C$31-'PY Rebate Liability'!D$20/'PY Rebate Liability'!D$23-'PY Rebate Liability'!F$25))+'PY Rebate Liability'!E$23*MAX(0,IF('PY Rebate Liability'!E$23<=0,0,D$31-'PY Rebate Liability'!E$20/'PY Rebate Liability'!E$23-'PY Rebate Liability'!F$25))),0)+IFERROR('PY Rebate Liability'!F$15*'PY Rebate Liability'!E$8*MAX(0,IF('PY Rebate Liability'!E$8<=0,0,C$31-'PY Rebate Liability'!E$5/'PY Rebate Liability'!E$8-'PY Rebate Liability'!F$10))/('PY Rebate Liability'!C$8*MAX(0,IF('PY Rebate Liability'!C$8<=0,0,MAX(80%,'PY Rebate Liability'!C$12)-'PY Rebate Liability'!C$5/'PY Rebate Liability'!C$8-'PY Rebate Liability'!F$10))+'PY Rebate Liability'!D$8*MAX(0,IF('PY Rebate Liability'!D$8<=0,0,MAX(80%,'PY Rebate Liability'!D$12)-'PY Rebate Liability'!D$5/'PY Rebate Liability'!D$8-'PY Rebate Liability'!F$10))+'PY Rebate Liability'!E$8*MAX(0,IF('PY Rebate Liability'!E$8<=0,0,C$31-'PY Rebate Liability'!E$5/'PY Rebate Liability'!E$8-'PY Rebate Liability'!F$10))),0),0)))","v":""},{"$f":"IF(OR(H$35=\"\",'PY Rebate Liability'!J$20+'PY Rebate Liability'!J$23=0),\"\",IF(SUM('PY Rebate Liability'!H$31:K$34)<>0,'PY Rebate Liability'!J$34+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM('PY Rebate Liability'!C$31:F$34)<>0),'PY Rebate Liability'!E$34,0),IFERROR('PY Rebate Liability'!K$30*'PY Rebate Liability'!J$23*MAX(0,IF('PY Rebate Liability'!J$23<=0,0,H$31-'PY Rebate Liability'!J$20/'PY Rebate Liability'!J$23-'PY Rebate Liability'!K$25))/('PY Rebate Liability'!H$23*MAX(0,IF('PY Rebate Liability'!H$23<=0,0,MAX(80%,'PY Rebate Liability'!H$27)-'PY Rebate Liability'!H$20/'PY Rebate Liability'!H$23-'PY Rebate Liability'!K$25))+'PY Rebate Liability'!I$23*MAX(0,IF('PY Rebate Liability'!I$23<=0,0,G$31-'PY Rebate Liability'!I$20/'PY Rebate Liability'!I$23-'PY Rebate Liability'!K$25))+'PY Rebate Liability'!J$23*MAX(0,IF('PY Rebate Liability'!J$23<=0,0,H$31-'PY Rebate Liability'!J$20/'PY Rebate Liability'!J$23-'PY Rebate Liability'!K$25))),0)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($G$6:$J$11,$G$15:$J$16,$G$19:$H$19)<>0),IFERROR('PY Rebate Liability'!F$30*'PY Rebate Liability'!E$23*MAX(0,IF('PY Rebate Liability'!E$23<=0,0,D$31-'PY Rebate Liability'!E$20/'PY Rebate Liability'!E$23-'PY Rebate Liability'!F$25))/('PY Rebate Liability'!C$23*MAX(0,IF('PY Rebate Liability'!C$23<=0,0,MAX(80%,'PY Rebate Liability'!C$27)-'PY Rebate Liability'!C$20/'PY Rebate Liability'!C$23-'PY Rebate Liability'!F$25))+'PY Rebate Liability'!D$23*MAX(0,IF('PY Rebate Liability'!D$23<=0,0,C$31-'PY Rebate Liability'!D$20/'PY Rebate Liability'!D$23-'PY Rebate Liability'!F$25))+'PY Rebate Liability'!E$23*MAX(0,IF('PY Rebate Liability'!E$23<=0,0,D$31-'PY Rebate Liability'!E$20/'PY Rebate Liability'!E$23-'PY Rebate Liability'!F$25))),0),0)))","v":""},null,null,{"$f":"IF(OR(K$35=\"\",'PY Rebate Liability'!O$5+'PY Rebate Liability'!O$8+'PY Rebate Liability'!N$20+'PY Rebate Liability'!N$23=0),\"\",IF(SUM('PY Rebate Liability'!M$31:P$34)<>0,'PY Rebate Liability'!N$32+'PY Rebate Liability'!N$34,IFERROR('PY Rebate Liability'!P$30*'PY Rebate Liability'!N$23*MAX(0,IF('PY Rebate Liability'!N$23<=0,0,K$31-'PY Rebate Liability'!N$20/'PY Rebate Liability'!N$23-'PY Rebate Liability'!P$25))/('PY Rebate Liability'!M$23*MAX(0,IF('PY Rebate Liability'!M$23<=0,0,MAX(85%,'PY Rebate Liability'!M$27)-'PY Rebate Liability'!M$20/'PY Rebate Liability'!M$23-'PY Rebate Liability'!P$25))+'PY Rebate Liability'!N$23*MAX(0,IF('PY Rebate Liability'!N$23<=0,0,K$31-'PY Rebate Liability'!N$20/'PY Rebate Liability'!N$23-'PY Rebate Liability'!P$25))+'PY Rebate Liability'!O$23*MAX(0,IF('PY Rebate Liability'!O$23<=0,0,L$31-'PY Rebate Liability'!O$20/'PY Rebate Liability'!O$23-'PY Rebate Liability'!P$25))),0)+IFERROR('PY Rebate Liability'!P$15*'PY Rebate Liability'!O$8*MAX(0,IF('PY Rebate Liability'!O$8<=0,0,K$31-'PY Rebate Liability'!O$5/'PY Rebate Liability'!O$8-'PY Rebate Liability'!P$10))/('PY Rebate Liability'!M$8*MAX(0,IF('PY Rebate Liability'!M$8<=0,0,MAX(85%,'PY Rebate Liability'!M$12)-'PY Rebate Liability'!M$5/'PY Rebate Liability'!M$8-'PY Rebate Liability'!P$10))+'PY Rebate Liability'!N$8*MAX(0,IF('PY Rebate Liability'!N$8<=0,0,MAX(85%,'PY Rebate Liability'!N$12)-'PY Rebate Liability'!N$5/'PY Rebate Liability'!N$8-'PY Rebate Liability'!P$10))+'PY Rebate Liability'!O$8*MAX(0,IF('PY Rebate Liability'!O$8<=0,0,K$31-'PY Rebate Liability'!O$5/'PY Rebate Liability'!O$8-'PY Rebate Liability'!P$10))),0)))","v":""},{"$f":"IF(OR(L$35=\"\",'PY Rebate Liability'!O$20+'PY Rebate Liability'!O$23=0),\"\",IF(SUM('PY Rebate Liability'!M$31:P$34)<>0,'PY Rebate Liability'!O$34,IFERROR('PY Rebate Liability'!P$30*'PY Rebate Liability'!O$23*MAX(0,IF('PY Rebate Liability'!O$23<=0,0,L$31-'PY Rebate Liability'!O$20/'PY Rebate Liability'!O$23-'PY Rebate Liability'!P$25))/('PY Rebate Liability'!M$23*MAX(0,IF('PY Rebate Liability'!M$23<=0,0,MAX(85%,'PY Rebate Liability'!M$27)-'PY Rebate Liability'!M$20/'PY Rebate Liability'!M$23-'PY Rebate Liability'!P$25))+'PY Rebate Liability'!N$23*MAX(0,IF('PY Rebate Liability'!N$23<=0,0,K$31-'PY Rebate Liability'!N$20/'PY Rebate Liability'!N$23-'PY Rebate Liability'!P$25))+'PY Rebate Liability'!O$23*MAX(0,IF('PY Rebate Liability'!O$23<=0,0,L$31-'PY Rebate Liability'!O$20/'PY Rebate Liability'!O$23-'PY Rebate Liability'!P$25))),0)))","v":""},null,null,{"$f":"IF(OR(O$35=\"\",'PY Rebate Liability'!S$6+'PY Rebate Liability'!S$8+'PY Rebate Liability'!R$21+'PY Rebate Liability'!R$23=0),\"\",IF(SUM('PY Rebate Liability'!Q$31:T$34)<>0,'PY Rebate Liability'!R$32+'PY Rebate Liability'!R$34+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM('PY Rebate Liability'!U$31:X$34)<>0),'PY Rebate Liability'!V$34,0),IFERROR('PY Rebate Liability'!T$30*'PY Rebate Liability'!R$23*MAX(0,IF('PY Rebate Liability'!R$23<=0,0,O$31-'PY Rebate Liability'!R$21/'PY Rebate Liability'!R$23-'PY Rebate Liability'!T$25))/('PY Rebate Liability'!Q$23*MAX(0,IF('PY Rebate Liability'!Q$23<=0,0,MAX(80%,'PY Rebate Liability'!Q$27)-'PY Rebate Liability'!Q$21/'PY Rebate Liability'!Q$23/1.25-'PY Rebate Liability'!T$25))+'PY Rebate Liability'!R$23*MAX(0,IF('PY Rebate Liability'!R$23<=0,0,O$31-'PY Rebate Liability'!R$21/'PY Rebate Liability'!R$23-'PY Rebate Liability'!T$25))+'PY Rebate Liability'!S$23*MAX(0,IF('PY Rebate Liability'!S$23<=0,0,P$31-'PY Rebate Liability'!S$21/'PY Rebate Liability'!S$23-'PY Rebate Liability'!T$25))),0)+IFERROR('PY Rebate Liability'!T$15*'PY Rebate Liability'!S$8*MAX(0,IF('PY Rebate Liability'!S$8<=0,0,O$31-'PY Rebate Liability'!S$6/'PY Rebate Liability'!S$8-'PY Rebate Liability'!T$10))/('PY Rebate Liability'!Q$8*MAX(0,IF('PY Rebate Liability'!Q$8<=0,0,MAX(80%,'PY Rebate Liability'!Q$12)-'PY Rebate Liability'!Q$6/'PY Rebate Liability'!Q$8/1.5-'PY Rebate Liability'!T$10))+'PY Rebate Liability'!R$8*MAX(0,IF('PY Rebate Liability'!R$8<=0,0,MAX(80%,'PY Rebate Liability'!R$12)-'PY Rebate Liability'!R$6/'PY Rebate Liability'!R$8/1.25-'PY Rebate Liability'!T$10))+'PY Rebate Liability'!S$8*MAX(0,IF('PY Rebate Liability'!S$8<=0,0,O$31-'PY Rebate Liability'!S$6/'PY Rebate Liability'!S$8-'PY Rebate Liability'!T$10))),0)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),IFERROR('PY Rebate Liability'!X$30*'PY Rebate Liability'!V$23*MAX(0,IF('PY Rebate Liability'!V$23<=0,0,S$31-'PY Rebate Liability'!V$21/'PY Rebate Liability'!V$23-'PY Rebate Liability'!X$25))/('PY Rebate Liability'!U$23*MAX(0,IF('PY Rebate Liability'!U$23<=0,0,MAX(80%,'PY Rebate Liability'!U$27)-'PY Rebate Liability'!U$21/'PY Rebate Liability'!U$23/1.25-'PY Rebate Liability'!X$25))+'PY Rebate Liability'!V$23*MAX(0,IF('PY Rebate Liability'!V$23<=0,0,S$31-'PY Rebate Liability'!V$21/'PY Rebate Liability'!V$23-'PY Rebate Liability'!X$25))+'PY Rebate Liability'!W$23*MAX(0,IF('PY Rebate Liability'!W$23<=0,0,T$31-'PY Rebate Liability'!W$21/'PY Rebate Liability'!W$23-'PY Rebate Liability'!X$25))),0)+IFERROR('PY Rebate Liability'!X$15*'PY Rebate Liability'!W$8*MAX(0,IF('PY Rebate Liability'!W$8<=0,0,S$31-'PY Rebate Liability'!W$6/'PY Rebate Liability'!W$8-'PY Rebate Liability'!X$10))/('PY Rebate Liability'!U$8*MAX(0,IF('PY Rebate Liability'!U$8<=0,0,MAX(80%,'PY Rebate Liability'!U$12)-'PY Rebate Liability'!U$6/'PY Rebate Liability'!U$8/1.5-'PY Rebate Liability'!X$10))+'PY Rebate Liability'!V$8*MAX(0,IF('PY Rebate Liability'!V$8<=0,0,MAX(80%,'PY Rebate Liability'!V$12)-'PY Rebate Liability'!V$6/'PY Rebate Liability'!V$8/1.25-'PY Rebate Liability'!X$10))+'PY Rebate Liability'!W$8*MAX(0,IF('PY Rebate Liability'!W$8<=0,0,S$31-'PY Rebate Liability'!W$6/'PY Rebate Liability'!W$8-'PY Rebate Liability'!X$10))),0),0)))","v":""},{"$f":"IF(OR(P$35=\"\",'PY Rebate Liability'!S$21+'PY Rebate Liability'!S$23=0),\"\",IF(SUM('PY Rebate Liability'!Q$31:T$34)<>0,'PY Rebate Liability'!S$34+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM('PY Rebate Liability'!U$31:X$34)<>0),'PY Rebate Liability'!W$34,0),IFERROR('PY Rebate Liability'!T$30*'PY Rebate Liability'!S$23*MAX(0,IF('PY Rebate Liability'!S$23<=0,0,P$31-'PY Rebate Liability'!S$21/'PY Rebate Liability'!S$23-'PY Rebate Liability'!T$25))/('PY Rebate Liability'!Q$23*MAX(0,IF('PY Rebate Liability'!Q$23<=0,0,MAX(80%,'PY Rebate Liability'!Q$27)-'PY Rebate Liability'!Q$21/'PY Rebate Liability'!Q$23/1.25-'PY Rebate Liability'!T$25))+'PY Rebate Liability'!R$23*MAX(0,IF('PY Rebate Liability'!R$23<=0,0,O$31-'PY Rebate Liability'!R$21/'PY Rebate Liability'!R$23-'PY Rebate Liability'!T$25))+'PY Rebate Liability'!S$23*MAX(0,IF('PY Rebate Liability'!S$23<=0,0,P$31-'PY Rebate Liability'!S$21/'PY Rebate Liability'!S$23-'PY Rebate Liability'!T$25))),0)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($O$6:$R$7,$O$15:$R$16,$O$19:$P$19)<>0),IFERROR('PY Rebate Liability'!X$30*'PY Rebate Liability'!W$23*MAX(0,IF('PY Rebate Liability'!W$23<=0,0,T$31-'PY Rebate Liability'!W$21/'PY Rebate Liability'!W$23-'PY Rebate Liability'!X$25))/('PY Rebate Liability'!U$23*MAX(0,IF('PY Rebate Liability'!U$23<=0,0,MAX(80%,'PY Rebate Liability'!U$27)-'PY Rebate Liability'!U$21/'PY Rebate Liability'!U$23/1.25-'PY Rebate Liability'!X$25))+'PY Rebate Liability'!V$23*MAX(0,IF('PY Rebate Liability'!V$23<=0,0,S$31-'PY Rebate Liability'!V$21/'PY Rebate Liability'!V$23-'PY Rebate Liability'!X$25))+'PY Rebate Liability'!W$23*MAX(0,IF('PY Rebate Liability'!W$23<=0,0,T$31-'PY Rebate Liability'!W$21/'PY Rebate Liability'!W$23-'PY Rebate Liability'!X$25))),0),0)))","v":""},null,null,{"$f":"IF(OR(S$35=\"\",'PY Rebate Liability'!W$6+'PY Rebate Liability'!W$8+'PY Rebate Liability'!V$21+'PY Rebate Liability'!V$23=0),\"\",IF(SUM('PY Rebate Liability'!U$31:X$34)<>0,'PY Rebate Liability'!V$32+'PY Rebate Liability'!V$34+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM('PY Rebate Liability'!Q$31:T$34)<>0),'PY Rebate Liability'!R$34,0),IFERROR('PY Rebate Liability'!X$30*'PY Rebate Liability'!V$23*MAX(0,IF('PY Rebate Liability'!V$23<=0,0,S$31-'PY Rebate Liability'!V$21/'PY Rebate Liability'!V$23-'PY Rebate Liability'!X$25))/('PY Rebate Liability'!U$23*MAX(0,IF('PY Rebate Liability'!U$23<=0,0,MAX(80%,'PY Rebate Liability'!U$27)-'PY Rebate Liability'!U$21/'PY Rebate Liability'!U$23/1.25-'PY Rebate Liability'!X$25))+'PY Rebate Liability'!V$23*MAX(0,IF('PY Rebate Liability'!V$23<=0,0,S$31-'PY Rebate Liability'!V$21/'PY Rebate Liability'!V$23-'PY Rebate Liability'!X$25))+'PY Rebate Liability'!W$23*MAX(0,IF('PY Rebate Liability'!W$23<=0,0,T$31-'PY Rebate Liability'!W$21/'PY Rebate Liability'!W$23-'PY Rebate Liability'!X$25))),0)+IFERROR('PY Rebate Liability'!X$15*'PY Rebate Liability'!W$8*MAX(0,IF('PY Rebate Liability'!W$8<=0,0,S$31-'PY Rebate Liability'!W$6/'PY Rebate Liability'!W$8-'PY Rebate Liability'!X$10))/('PY Rebate Liability'!U$8*MAX(0,IF('PY Rebate Liability'!U$8<=0,0,MAX(80%,'PY Rebate Liability'!U$12)-'PY Rebate Liability'!U$6/'PY Rebate Liability'!U$8/1.5-'PY Rebate Liability'!X$10))+'PY Rebate Liability'!V$8*MAX(0,IF('PY Rebate Liability'!V$8<=0,0,MAX(80%,'PY Rebate Liability'!V$12)-'PY Rebate Liability'!V$6/'PY Rebate Liability'!V$8/1.25-'PY Rebate Liability'!X$10))+'PY Rebate Liability'!W$8*MAX(0,IF('PY Rebate Liability'!W$8<=0,0,S$31-'PY Rebate Liability'!W$6/'PY Rebate Liability'!W$8-'PY Rebate Liability'!X$10))),0)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),IFERROR('PY Rebate Liability'!T$30*'PY Rebate Liability'!R$23*MAX(0,IF('PY Rebate Liability'!R$23<=0,0,O$31-'PY Rebate Liability'!R$21/'PY Rebate Liability'!R$23-'PY Rebate Liability'!T$25))/('PY Rebate Liability'!Q$23*MAX(0,IF('PY Rebate Liability'!Q$23<=0,0,MAX(80%,'PY Rebate Liability'!Q$27)-'PY Rebate Liability'!Q$21/'PY Rebate Liability'!Q$23/1.25-'PY Rebate Liability'!T$25))+'PY Rebate Liability'!R$23*MAX(0,IF('PY Rebate Liability'!R$23<=0,0,O$31-'PY Rebate Liability'!R$21/'PY Rebate Liability'!R$23-'PY Rebate Liability'!T$25))+'PY Rebate Liability'!S$23*MAX(0,IF('PY Rebate Liability'!S$23<=0,0,P$31-'PY Rebate Liability'!S$21/'PY Rebate Liability'!S$23-'PY Rebate Liability'!T$25))),0)+IFERROR('PY Rebate Liability'!T$15*'PY Rebate Liability'!S$8*MAX(0,IF('PY Rebate Liability'!S$8<=0,0,O$31-'PY Rebate Liability'!S$6/'PY Rebate Liability'!S$8-'PY Rebate Liability'!T$10))/('PY Rebate Liability'!Q$8*MAX(0,IF('PY Rebate Liability'!Q$8<=0,0,MAX(80%,'PY Rebate Liability'!Q$12)-'PY Rebate Liability'!Q$6/'PY Rebate Liability'!Q$8/1.5-'PY Rebate Liability'!T$10))+'PY Rebate Liability'!R$8*MAX(0,IF('PY Rebate Liability'!R$8<=0,0,MAX(80%,'PY Rebate Liability'!R$12)-'PY Rebate Liability'!R$6/'PY Rebate Liability'!R$8/1.25-'PY Rebate Liability'!T$10))+'PY Rebate Liability'!S$8*MAX(0,IF('PY Rebate Liability'!S$8<=0,0,O$31-'PY Rebate Liability'!S$6/'PY Rebate Liability'!S$8-'PY Rebate Liability'!T$10))),0),0)))","v":""},{"$f":"IF(OR(T$35=\"\",'PY Rebate Liability'!W$21+'PY Rebate Liability'!W$23=0),\"\",IF(SUM('PY Rebate Liability'!U$31:X$34)<>0,'PY Rebate Liability'!W$34+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM('PY Rebate Liability'!Q$31:T$34)<>0),'PY Rebate Liability'!S$34,0),IFERROR('PY Rebate Liability'!X$30*'PY Rebate Liability'!W$23*MAX(0,IF('PY Rebate Liability'!W$23<=0,0,T$31-'PY Rebate Liability'!W$21/'PY Rebate Liability'!W$23-'PY Rebate Liability'!X$25))/('PY Rebate Liability'!U$23*MAX(0,IF('PY Rebate Liability'!U$23<=0,0,MAX(80%,'PY Rebate Liability'!U$27)-'PY Rebate Liability'!U$21/'PY Rebate Liability'!U$23/1.25-'PY Rebate Liability'!X$25))+'PY Rebate Liability'!V$23*MAX(0,IF('PY Rebate Liability'!V$23<=0,0,S$31-'PY Rebate Liability'!V$21/'PY Rebate Liability'!V$23-'PY Rebate Liability'!X$25))+'PY Rebate Liability'!W$23*MAX(0,IF('PY Rebate Liability'!W$23<=0,0,T$31-'PY Rebate Liability'!W$21/'PY Rebate Liability'!W$23-'PY Rebate Liability'!X$25))),0)+IF(AND(OR('Company Information'!$C$12=\"District of Columbia\",'Company Information'!$C$12=\"Massachusetts\",'Company Information'!$C$12=\"Vermont\"),SUM($S$6:$V$7,$S$15:$V$16,$S$19:$T$19)<>0),IFERROR('PY Rebate Liability'!T$30*'PY Rebate Liability'!S$23*MAX(0,IF('PY Rebate Liability'!S$23<=0,0,P$31-'PY Rebate Liability'!S$21/'PY Rebate Liability'!S$23-'PY Rebate Liability'!T$25))/('PY Rebate Liability'!Q$23*MAX(0,IF('PY Rebate Liability'!Q$23<=0,0,MAX(80%,'PY Rebate Liability'!Q$27)-'PY Rebate Liability'!Q$21/'PY Rebate Liability'!Q$23/1.25-'PY Rebate Liability'!T$25))+'PY Rebate Liability'!R$23*MAX(0,IF('PY Rebate Liability'!R$23<=0,0,O$31-'PY Rebate Liability'!R$21/'PY Rebate Liability'!R$23-'PY Rebate Liability'!T$25))+'PY Rebate Liability'!S$23*MAX(0,IF('PY Rebate Liability'!S$23<=0,0,P$31-'PY Rebate Liability'!S$21/'PY Rebate Liability'!S$23-'PY Rebate Liability'!T$25))),0),0)))","v":""},null,null,{"$f":"IF(OR(W$35=\"\",'PY Rebate Liability'!AA$6+'PY Rebate Liability'!AA$8+'PY Rebate Liability'!Z$21+'PY Rebate Liability'!Z$23=0),\"\",IF(SUM('PY Rebate Liability'!Y$31:AB$34)<>0,'PY Rebate Liability'!Z$32+'PY Rebate Liability'!Z$34,IFERROR('PY Rebate Liability'!AB$30*'PY Rebate Liability'!Z$23*MAX(0,IF('PY Rebate Liability'!Z$23<=0,0,W$31-'PY Rebate Liability'!Z$21/'PY Rebate Liability'!Z$23-'PY Rebate Liability'!AB$25))/('PY Rebate Liability'!Y$23*MAX(0,IF('PY Rebate Liability'!Y$23<=0,0,MAX(85%,'PY Rebate Liability'!Y$27)-'PY Rebate Liability'!Y$21/'PY Rebate Liability'!Y$23/1.25-'PY Rebate Liability'!AB$25))+'PY Rebate Liability'!Z$23*MAX(0,IF('PY Rebate Liability'!Z$23<=0,0,W$31-'PY Rebate Liability'!Z$21/'PY Rebate Liability'!Z$23-'PY Rebate Liability'!AB$25))+'PY Rebate Liability'!AA$23*MAX(0,IF('PY Rebate Liability'!AA$23<=0,0,X$31-'PY Rebate Liability'!AA$21/'PY Rebate Liability'!AA$23-'PY Rebate Liability'!AB$25))),0)+IFERROR('PY Rebate Liability'!AB$15*'PY Rebate Liability'!AA$8*MAX(0,IF('PY Rebate Liability'!AA$8<=0,0,W$31-'PY Rebate Liability'!AA$6/'PY Rebate Liability'!AA$8-'PY Rebate Liability'!AB$10))/('PY Rebate Liability'!Y$8*MAX(0,IF('PY Rebate Liability'!Y$8<=0,0,MAX(85%,'PY Rebate Liability'!Y$12)-'PY Rebate Liability'!Y$6/'PY Rebate Liability'!Y$8/1.5-'PY Rebate Liability'!AB$10))+'PY Rebate Liability'!Z$8*MAX(0,IF('PY Rebate Liability'!Z$8<=0,0,MAX(85%,'PY Rebate Liability'!Z$12)-'PY Rebate Liability'!Z$6/'PY Rebate Liability'!Z$8/1.25-'PY Rebate Liability'!AB$10))+'PY Rebate Liability'!AA$8*MAX(0,IF('PY Rebate Liability'!AA$8<=0,0,W$31-'PY Rebate Liability'!AA$6/'PY Rebate Liability'!AA$8-'PY Rebate Liability'!AB$10))),0)))","v":""},{"$f":"IF(OR(X$35=\"\",'PY Rebate Liability'!AA$21+'PY Rebate Liability'!AA$23=0),\"\",IF(SUM('PY Rebate Liability'!Y$31:AB$34)<>0,'PY Rebate Liability'!AA$34,IFERROR('PY Rebate Liability'!AB$30*'PY Rebate Liability'!AA$23*MAX(0,IF('PY Rebate Liability'!AA$23<=0,0,X$31-'PY Rebate Liability'!AA$21/'PY Rebate Liability'!AA$23-'PY Rebate Liability'!AB$25))/('PY Rebate Liability'!Y$23*MAX(0,IF('PY Rebate Liability'!Y$23<=0,0,MAX(85%,'PY Rebate Liability'!Y$27)-'PY Rebate Liability'!Y$21/'PY Rebate Liability'!Y$23/1.25-'PY Rebate Liability'!AB$25))+'PY Rebate Liability'!Z$23*MAX(0,IF('PY Rebate Liability'!Z$23<=0,0,W$31-'PY Rebate Liability'!Z$21/'PY Rebate Liability'!Z$23-'PY Rebate Liability'!AB$25))+'PY Rebate Liability'!AA$23*MAX(0,IF('PY Rebate Liability'!AA$23<=0,0,X$31-'PY Rebate Liability'!AA$21/'PY Rebate Liability'!AA$23-'PY Rebate Liability'!AB$25))),0)))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AI$35=\"\",'PY Rebate Liability'!AM$6+'PY Rebate Liability'!AM$8+'PY Rebate Liability'!AL$21+'PY Rebate Liability'!AL$23=0),\"\",IF(SUM('PY Rebate Liability'!AK$31:AN$34)<>0,'PY Rebate Liability'!AL$32+'PY Rebate Liability'!AL$34,IFERROR('PY Rebate Liability'!AN$30*'PY Rebate Liability'!AL$23*MAX(0,IF('PY Rebate Liability'!AL$23<=0,0,AI$31-'PY Rebate Liability'!AL$21/'PY Rebate Liability'!AL$23-'PY Rebate Liability'!AN$25))/('PY Rebate Liability'!AK$23*MAX(0,IF('PY Rebate Liability'!AK$23<=0,0,MAX(80%,'PY Rebate Liability'!AK$27)-'PY Rebate Liability'!AK$21/'PY Rebate Liability'!AK$23-'PY Rebate Liability'!AN$25))+'PY Rebate Liability'!AL$23*MAX(0,IF('PY Rebate Liability'!AL$23<=0,0,AI$31-'PY Rebate Liability'!AL$21/'PY Rebate Liability'!AL$23-'PY Rebate Liability'!AN$25))+'PY Rebate Liability'!AM$23*MAX(0,IF('PY Rebate Liability'!AM$23<=0,0,AJ$31-'PY Rebate Liability'!AM$21/'PY Rebate Liability'!AM$23-'PY Rebate Liability'!AN$25))),0)+IFERROR('PY Rebate Liability'!AN$15*'PY Rebate Liability'!AM$8*MAX(0,IF('PY Rebate Liability'!AM$8<=0,0,AI$31-'PY Rebate Liability'!AM$6/'PY Rebate Liability'!AM$8-'PY Rebate Liability'!AN$10))/('PY Rebate Liability'!AK$8*MAX(0,IF('PY Rebate Liability'!AK$8<=0,0,MAX(80%,'PY Rebate Liability'!AK$12)-'PY Rebate Liability'!AK$6/'PY Rebate Liability'!AK$8-'PY Rebate Liability'!AN$10))+'PY Rebate Liability'!AL$8*MAX(0,IF('PY Rebate Liability'!AL$8<=0,0,MAX(80%,'PY Rebate Liability'!AL$12)-'PY Rebate Liability'!AL$6/'PY Rebate Liability'!AL$8-'PY Rebate Liability'!AN$10))+'PY Rebate Liability'!AM$8*MAX(0,IF('PY Rebate Liability'!AM$8<=0,0,AI$31-'PY Rebate Liability'!AM$6/'PY Rebate Liability'!AM$8-'PY Rebate Liability'!AN$10))),0)))","v":""},{"$f":"IF(OR(AJ$35=\"\",'PY Rebate Liability'!AM$21+'PY Rebate Liability'!AM$23=0),\"\",IF(SUM('PY Rebate Liability'!AK$31:AN$34)<>0,'PY Rebate Liability'!AM$34,IFERROR('PY Rebate Liability'!AN$30*'PY Rebate Liability'!AM$23*MAX(0,IF('PY Rebate Liability'!AM$23<=0,0,AJ$31-'PY Rebate Liability'!AM$21/'PY Rebate Liability'!AM$23-'PY Rebate Liability'!AN$25))/('PY Rebate Liability'!AK$23*MAX(0,IF('PY Rebate Liability'!AK$23<=0,0,MAX(80%,'PY Rebate Liability'!AK$27)-'PY Rebate Liability'!AK$21/'PY Rebate Liability'!AK$23-'PY Rebate Liability'!AN$25))+'PY Rebate Liability'!AL$23*MAX(0,IF('PY Rebate Liability'!AL$23<=0,0,AI$31-'PY Rebate Liability'!AL$21/'PY Rebate Liability'!AL$23-'PY Rebate Liability'!AN$25))+'PY Rebate Liability'!AM$23*MAX(0,IF('PY Rebate Liability'!AM$23<=0,0,AJ$31-'PY Rebate Liability'!AM$21/'PY Rebate Liability'!AM$23-'PY Rebate Liability'!AN$25))),\"\")))","v":""}]
[null,"5.7 Optional: unpaid rebate liability (Lines 5.5 - 5.6)",{"$f":"IF(C$35=\"\",\"\",MAX(0,SUM(C$35)-SUM(C$36)))","v":""},{"$f":"IF(D$35=\"\",\"\",MAX(0,SUM(D$35)-SUM(D$36)))","v":""},{"$f":"IF(E$35=\"\",\"\",MAX(0,SUM(E$35)-SUM(E$36)))","v":""},null,{"$f":"IF(G$35=\"\",\"\",MAX(0,SUM(G$35)-SUM(G$36)))","v":""},{"$f":"IF(H$35=\"\",\"\",MAX(0,SUM(H$35)-SUM(H$36)))","v":""},{"$f":"IF(I$35=\"\",\"\",MAX(0,SUM(I$35)-SUM(I$36)))","v":""},null,{"$f":"IF(K$35=\"\",\"\",MAX(0,SUM(K$35)-SUM(K$36)))","v":""},{"$f":"IF(L$35=\"\",\"\",MAX(0,SUM(L$35)-SUM(L$36)))","v":""},{"$f":"IF(M$35=\"\",\"\",MAX(0,SUM(M$35)-SUM(M$36)))","v":""},null,{"$f":"IF(O$35=\"\",\"\",MAX(0,SUM(O$35)-SUM(O$36)))","v":""},{"$f":"IF(P$35=\"\",\"\",MAX(0,SUM(P$35)-SUM(P$36)))","v":""},{"$f":"IF(Q$35=\"\",\"\",MAX(0,SUM(Q$35)-SUM(Q$36)))","v":""},null,{"$f":"IF(S$35=\"\",\"\",MAX(0,SUM(S$35)-SUM(S$36)))","v":""},{"$f":"IF(T$35=\"\",\"\",MAX(0,SUM(T$35)-SUM(T$36)))","v":""},{"$f":"IF(U$35=\"\",\"\",MAX(0,SUM(U$35)-SUM(U$36)))","v":""},null,{"$f":"IF(W$35=\"\",\"\",MAX(0,SUM(W$35)-SUM(W$36)))","v":""},{"$f":"IF(X$35=\"\",\"\",MAX(0,SUM(X$35)-SUM(X$36)))","v":""},{"$f":"IF(Y$35=\"\",\"\",MAX(0,SUM(Y$35)-SUM(Y$36)))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(AI$35=\"\",\"\",MAX(0,SUM(AI$35)-SUM(AI$36)))","v":""},{"$f":"IF(AJ$35=\"\",\"\",MAX(0,SUM(AJ$35)-SUM(AJ$36)))","v":""},{"$f":"IF(AK$35=\"\",\"\",MAX(0,SUM(AK$35)-SUM(AK$36)))","v":""}]
[null,"5.8 Limited payable rebate amount (see instructions)",{"$f":"IF(C$35=\"\",\"\",MIN(F$34,SUM(C$37)*IFERROR((C$15-C$16)/C$17,1)))","v":""},{"$f":"IF(D$35=\"\",\"\",MIN(F$34-SUM(C$38),SUM(D$37)*IFERROR((D$15-D$16)/D$17,1)))","v":""},{"$f":"IF(E$35=\"\",\"\",MIN(F$34-SUM(C$38:D$38),SUM(E$37)*IFERROR((E$15-E$16)/E$17,1)))","v":""},{"$f":"IF(AND(C$38=\"\",D$38=\"\",E$38=\"\"),\"\",SUM(C$38:E$38))","v":""},{"$f":"IF(G$35=\"\",\"\",MIN(J$34,SUM(G$37)*IFERROR((G$15-G$16)/G$17,1)))","v":""},{"$f":"IF(H$35=\"\",\"\",MIN(J$34-SUM(G$38),SUM(H$37)*IFERROR((H$15-H$16)/H$17,1)))","v":""},{"$f":"IF(I$35=\"\",\"\",MIN(J$34-SUM(G$38:H$38),SUM(I$37)*IFERROR((I$15-I$16)/I$17,1)))","v":""},{"$f":"IF(AND(G$38=\"\",H$38=\"\",I$38=\"\"),\"\",SUM(G$38:I$38))","v":""},{"$f":"IF(K$35=\"\",\"\",MIN(N$34,SUM(K$37)*IFERROR((K$15-K$16)/K$17,1)))","v":""},{"$f":"IF(L$35=\"\",\"\",MIN(N$34-SUM(K$38),SUM(L$37)*IFERROR((L$15-L$16)/L$17,1)))","v":""},{"$f":"IF(M$35=\"\",\"\",MIN(N$34-SUM(K$38:L$38),SUM(M$37)*IFERROR((M$15-M$16)/M$17,1)))","v":""},{"$f":"IF(AND(K$38=\"\",L$38=\"\",M$38=\"\"),\"\",SUM(K$38:M$38))","v":""},{"$f":"IF(O$35=\"\",\"\",MIN(R$34,SUM(O$37)*IFERROR((O$15-O$16)/O$17,1)))","v":""},{"$f":"IF(P$35=\"\",\"\",MIN(R$34-SUM(O$38),SUM(P$37)*IFERROR((P$15-P$16)/P$17,1)))","v":""},{"$f":"IF(Q$35=\"\",\"\",MIN(R$34-SUM(O$38:P$38),SUM(Q$37)*IFERROR((Q$15-Q$16)/Q$17,1)))","v":""},{"$f":"IF(AND(O$38=\"\",P$38=\"\",Q$38=\"\"),\"\",SUM(O$38:Q$38))","v":""},{"$f":"IF(S$35=\"\",\"\",MIN(V$34,SUM(S$37)*IFERROR((S$15-S$16)/S$17,1)))","v":""},{"$f":"IF(T$35=\"\",\"\",MIN(V$34-SUM(S$38),SUM(T$37)*IFERROR((T$15-T$16)/T$17,1)))","v":""},{"$f":"IF(U$35=\"\",\"\",MIN(V$34-SUM(S$38:T$38),SUM(U$37)*IFERROR((U$15-U$16)/U$17,1)))","v":""},{"$f":"IF(AND(S$38=\"\",T$38=\"\",U$38=\"\"),\"\",SUM(S$38:U$38))","v":""},{"$f":"IF(W$35=\"\",\"\",MIN(Z$34,SUM(W$37)*IFERROR((W$15-W$16)/W$17,1)))","v":""},{"$f":"IF(X$35=\"\",\"\",MIN(Z$34-SUM(W$38),SUM(X$37)*IFERROR((X$15-X$16)/X$17,1)))","v":""},{"$f":"IF(Y$35=\"\",\"\",MIN(Z$34-SUM(W$38:X$38),SUM(Y$37)*IFERROR((Y$15-Y$16)/Y$17,1)))","v":""},{"$f":"IF(AND(W$38=\"\",X$38=\"\",Y$38=\"\"),\"\",SUM(W$38:Y$38))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AI$35=\"\",\"\",MIN(AL$34,SUM(AI$37)*IFERROR((AI$15-AI$16)/AI$17,1)))","v":""},{"$f":"IF(AJ$35=\"\",\"\",MIN(AL$34-SUM(AI$38),SUM(AJ$37)*IFERROR((AJ$15-AJ$16)/AJ$17,1)))","v":""},{"$f":"IF(AK$35=\"\",\"\",MIN(AL$34-SUM(AI$38:AJ$38),SUM(AK$37)*IFERROR((AK$15-AK$16)/AK$17,1)))","v":""},{"$f":"IF(AND(AI$38=\"\",AJ$38=\"\",AK$38=\"\"),\"\",SUM(AI$38:AK$38))","v":""}]
[null,"6. Temporary Adjustments"]
[null,"6.1 ACA assessments on non-calendar year policies (2017 only)"]
[null,"6.1a  Deferred portion of 2017 premium collected for 2018 ACA assessments or fees."]
[null,"6.1b  Total Federal and State taxes associated with the deferred premium on Line 6.1a."]
[null,"6.2   Reserved for future use"]
[null,"6.2a  Reserved for future use"]
[null,"6.2b  Reserved for future use"]
[null,"6.2c  Reserved for future use"]
[null,"6.2d  Reserved for future use"]
[null,"6.2e  Reserved for future use"]
[null,"6.2f  Reserved for future use"]

{"sheet":"Pt 4 Rebate Disbursement","index":6,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,2,22,10],[23,2,23,10]]}
[null,"Part 4 Rebate Disbursement"]
[]
[null,"Line Description","1\nHealth Insurance Coverage\nINDIVIDUAL","2\nHealth Insurance Coverage\nSMALL GROUP","3\nHealth Insurance Coverage\nLARGE GROUP","4\nMini-Med Plans\nINDIVIDUAL","5\nMini-Med Plans\nSMALL GROUP","6\nMini-Med Plans\nLARGE GROUP","7\nExpatriate Plans\nSMALL GROUP","8\nExpatriate Plans\nLARGE GROUP","9\nStudent Health Plans\nINDIVIDUAL"]
[null,"1. Number of policies / certificates  (from Part 1, Line 7.1)",{"$f":"'Pt 1 Summary of Data'!$E$56+'Pt 1 Summary of Data'!$G$56-'Pt 1 Summary of Data'!$H$56","v":0},{"$f":"'Pt 1 Summary of Data'!$J$56+'Pt 1 Summary of Data'!$L$56-'Pt 1 Summary of Data'!$M$56","v":0},{"$f":"'Pt 1 Summary of Data'!$O$56+'Pt 1 Summary of Data'!$Q$56-'Pt 1 Summary of Data'!$R$56","v":0},{"$f":"'Pt 1 Summary of Data'!$T$56","v":0},{"$f":"'Pt 1 Summary of Data'!$W$56","v":0},{"$f":"'Pt 1 Summary of Data'!$Z$56","v":0},null,null,{"$f":"'Pt 1 Summary of Data'!$AM$56+'Pt 1 Summary of Data'!$AO$56-'Pt 1 Summary of Data'!$AP$56","v":0}]
[null,"2. Number of policyholders/subscribers owed rebates"]
[null,"2.a Number of group policyholders being paid a rebate"]
[null,"2.b Number of subscribers being paid a rebate"]
[null,"2.c Number of group policyholders whose rebate is de minimis"]
[null,"2.d Number of subscribers whose rebate is de minimis"]
[null,"3. Total amount of rebates"]
[null,"3.a Total amount of rebates (from Part 3, Line 5.4 or 5.8)",{"$f":"IFERROR(IF(AND('Pt 3 MLR and Rebate Calculation'!$F$38<>\"\",'Pt 3 MLR and Rebate Calculation'!$F$38>0),MIN('Pt 3 MLR and Rebate Calculation'!$F$38,'Pt 3 MLR and Rebate Calculation'!$F$34),'Pt 3 MLR and Rebate Calculation'!$F$34),\"\")","v":0},{"$f":"IFERROR(IF(AND('Pt 3 MLR and Rebate Calculation'!$J$38<>\"\",'Pt 3 MLR and Rebate Calculation'!$J$38>0),MIN('Pt 3 MLR and Rebate Calculation'!$J$38,'Pt 3 MLR and Rebate Calculation'!$J$34),'Pt 3 MLR and Rebate Calculation'!$J$34),\"\")","v":0},{"$f":"IFERROR(IF(AND('Pt 3 MLR and Rebate Calculation'!$N$38<>\"\",'Pt 3 MLR and Rebate Calculation'!$N$38>0),MIN('Pt 3 MLR and Rebate Calculation'!$N$38,'Pt 3 MLR and Rebate Calculation'!$N$34),'Pt 3 MLR and Rebate Calculation'!$N$34),\"\")","v":0},{"$f":"IFERROR(IF(AND('Pt 3 MLR and Rebate Calculation'!$R$38<>\"\",'Pt 3 MLR and Rebate Calculation'!$R$38>0),MIN('Pt 3 MLR and Rebate Calculation'!$R$38,'Pt 3 MLR and Rebate Calculation'!$R$34),'Pt 3 MLR and Rebate Calculation'!$R$34),\"\")","v":0},{"$f":"IFERROR(IF(AND('Pt 3 MLR and Rebate Calculation'!$V$38<>\"\",'Pt 3 MLR and Rebate Calculation'!$V$38>0),MIN('Pt 3 MLR and Rebate Calculation'!$V$38,'Pt 3 MLR and Rebate Calculation'!$V$34),'Pt 3 MLR and Rebate Calculation'!$V$34),\"\")","v":0},{"$f":"IFERROR(IF(AND('Pt 3 MLR and Rebate Calculation'!$Z$38<>\"\",'Pt 3 MLR and Rebate Calculation'!$Z$38>0),MIN('Pt 3 MLR and Rebate Calculation'!$Z$38,'Pt 3 MLR and Rebate Calculation'!$Z$34),'Pt 3 MLR and Rebate Calculation'!$Z$34),\"\")","v":0},null,null,{"$f":"IFERROR(IF(AND('Pt 3 MLR and Rebate Calculation'!$AL$38<>\"\",'Pt 3 MLR and Rebate Calculation'!$AL$38>0),MIN('Pt 3 MLR and Rebate Calculation'!$AL$38,'Pt 3 MLR and Rebate Calculation'!$AL$34),'Pt 3 MLR and Rebate Calculation'!$AL$34),\"\")","v":0}]
[null,"3.b Amount of de minimis rebates"]
[null,"3.c Amount of rebates being paid by premium credit"]
[null,"3.d Amount of rebates being paid by lump-sum reimbursement"]
[null,"4. Prior MLR year rebates"]
[null,"4.a Total amount of rebates paid for the previous MLR reporting year"]
[null,"4.b Total amount of rebates still owed for the previous MLR reporting year"]
[null,"4.c Percentage of notices sent timely to individual policy subscribers or group policyholders owed a rebate"]
[null,"4.d Percentage of notices sent timely to subscribers of group policies owed a rebate"]
[null,"4.e Percentage of rebates paid timely to individual policy subscribers or group policyholders owed a rebate"]
[null,"4.f Percentage of rebates paid timely to subscribers of group policies owed a rebate"]
[null,"4.g Amount of unclaimed rebates from prior MLR reporting years"]
[null,"4.h Describe methods used to locate policyholders/subscribers for prior MLR reporting year's unclaimed rebates:"]
[null,"4.i Describe disbursement of prior MLR reporting year's unclaimed rebates:"]

{"sheet":"Pt 5 Additional Responses","index":7,"n_rows":61,"n_cols":3,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,"Part 5 Additional Responses"]
[]
[null,"Line Description","Tax Rate"]
[null,"1. If an amount is reported in Part 1 Line 3.2c, Community benefit expenditures, provide the state premium tax rate used to determine the reported amount:"]
[]
[null,"2. If the issuer reported amounts in Part 2 Line 2.15 Blended rate adjustment provide the affiliate(s) name(s) with whom blended rate adjustments were made. "]
[null,"Name of Affiliate"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. If the issuer reported amounts in the Dual Contract 3/31 Columns provide the affiliate(s) name(s) with whom experience is being reported. "]
[null,"Name of Affiliate"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4. If the issuer entered into any 100% assumptive reinsurance agreements with a novation during the MLR reporting year, provide the name(s) of the entity(ies) with whom the agreement was (were) made and the effective date of the novation. "]
[null,"Name of Entity with whom Agreement was made","Effective Date of Novation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5. If the Issuer novated any business in the MLR reporting year effective during the reporting year provide the name of the entity to whom the business was sold or transferred and the date of the sale or transfer."]
[null,"Name of Entity to whom business was sold or transferred","Effective Date of sale or transfer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6. If the issuer has any 100% indemnity reinsurance and administrative agreements effective prior to March 23, 2010, for which the assuming entity is responsible for 100% of the ceding entity's financial risk and takes on all of the administration of the block, report the name(s) of the entity(ies) that is (are) reporting the experience related to such business."]

{"sheet":"PY Rebate Liability","index":8,"n_rows":34,"n_cols":40,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"OPTIONAL: from Part 3 of two prior year MLR Forms"]
[]
[null,"2015 MLR Form","1\nHealth Insurance Coverage\nINDIVIDUAL\nPY2","2\nHealth Insurance Coverage\nINDIVIDUAL\nPY1","3\nHealth Insurance Coverage\nINDIVIDUAL\nCY","4\nHealth Insurance Coverage\nINDIVIDUAL\nTotal ","4A\nHealth Insurance Coverage\nINDIVIDUAL\nRC","5\nHealth Insurance Coverage\nSMALL GROUP\nPY2","6\nHealth Insurance Coverage\nSMALL GROUP\nPY1","7\nHealth Insurance Coverage\nSMALL GROUP\nCY","8\nHealth Insurance Coverage\nSMALL GROUP\nTotal","8A\nHealth Insurance Coverage\nSMALL GROUP\nRC","9\nHealth Insurance Coverage\nLARGE GROUP\nPY2","10\nHealth Insurance Coverage\nLARGE GROUP\nPY1","11\nHealth Insurance Coverage\nLARGE GROUP\nCY","12\nHealth Insurance Coverage\nLARGE GROUP\nTotal","13\nMini-Med Plans\nINDIVIDUAL\nPY2","14\nMini-Med Plans\nINDIVIDUAL\nPY1","15\nMini-Med Plans\nINDIVIDUAL\nCY","16\nMini-Med Plans\nINDIVIDUAL\nTotal ","17\nMini-Med Plans\nSMALL GROUP\nPY2","18\nMini-Med Plans\nSMALL GROUP\nPY1","19\nMini-Med Plans\nSMALL GROUP\nCY","20\nMini-Med Plans\nSMALL GROUP\nTotal","21\nMini-Med Plans\nLARGE GROUP\nPY2","22\nMini-Med Plans\nLARGE GROUP\nPY1","23\nMini-Med Plans\nLARGE GROUP\nCY","24\nMini-Med Plans\nLARGE GROUP\nTotal","25\nExpatriate Plans\nSMALL GROUP\nPY2","26\nExpatriate Plans\nSMALL GROUP\nPY1","27\nExpatriate Plans\nSMALL GROUP\nCY","28\nExpatriate Plans\nSMALL GROUP\nTotal ","29\nExpatriate Plans\nLARGE GROUP\nPY2","30\nExpatriate Plans\nLARGE GROUP\nPY1","31\nExpatriate Plans\nLARGE GROUP\nCY","32\nExpatriate Plans\nLARGE GROUP\nTotal","33\nStudent Health Plans\nINDIVIDUAL\nPY2","34\nStudent Health Plans\nINDIVIDUAL\nPY1","35\nStudent Health Plans\nINDIVIDUAL\nCY","36\nStudent Health Plans\nINDIVIDUAL\nTotal"]
[null,"1. Medical Loss Ratio Numerator"]
[null,"1.8 MLR numerator "]
[null,"1.9 MLR numerator Mini-Med and Student Health (using adjustment factor)"]
[null,"2. Medical Loss Ratio Denominator"]
[null,"2.3 MLR Denominator (Lines 2.1 - 2.2) "]
[null,"4. Credibility Adjustment"]
[null,"4.5 Credibility adjustment (Lines 4.2 x 4.4 (do not round)) "]
[null,"6. Rebate Calculation"]
[null,"6.1 MLR standard"]
[null,"6.2 Credibility-adjusted MLR (Line 5.3)"]
[null,"6.3 Adjusted earned premium (Lines 2.1 - 2.2 CY)"]
[null,"6.4 Rebate amount if credibility-adjusted MLR is less than MLR standard (Lines (6.1 - 6.2) x 6.3)"]
[]
[]
[null,"2016 MLR Form","1\nHealth Insurance Coverage\nINDIVIDUAL\nPY2","2\nHealth Insurance Coverage\nINDIVIDUAL\nPY1","3\nHealth Insurance Coverage\nINDIVIDUAL\nCY","4\nHealth Insurance Coverage\nINDIVIDUAL\nTotal ","4A\nHealth Insurance Coverage\nINDIVIDUAL\nRC","5\nHealth Insurance Coverage\nSMALL GROUP\nPY2","6\nHealth Insurance Coverage\nSMALL GROUP\nPY1","7\nHealth Insurance Coverage\nSMALL GROUP\nCY","8\nHealth Insurance Coverage\nSMALL GROUP\nTotal","8A\nHealth Insurance Coverage\nSMALL GROUP\nRC","9\nHealth Insurance Coverage\nLARGE GROUP\nPY2","10\nHealth Insurance Coverage\nLARGE GROUP\nPY1","11\nHealth Insurance Coverage\nLARGE GROUP\nCY","12\nHealth Insurance Coverage\nLARGE GROUP\nTotal","13\nMini-Med Plans\nINDIVIDUAL\nPY2","14\nMini-Med Plans\nINDIVIDUAL\nPY1","15\nMini-Med Plans\nINDIVIDUAL\nCY","16\nMini-Med Plans\nINDIVIDUAL\nTotal ","17\nMini-Med Plans\nSMALL GROUP\nPY2","18\nMini-Med Plans\nSMALL GROUP\nPY1","19\nMini-Med Plans\nSMALL GROUP\nCY","20\nMini-Med Plans\nSMALL GROUP\nTotal","21\nMini-Med Plans\nLARGE GROUP\nPY2","22\nMini-Med Plans\nLARGE GROUP\nPY1","23\nMini-Med Plans\nLARGE GROUP\nCY","24\nMini-Med Plans\nLARGE GROUP\nTotal","25\nExpatriate Plans\nSMALL GROUP\nPY2","26\nExpatriate Plans\nSMALL GROUP\nPY1","27\nExpatriate Plans\nSMALL GROUP\nCY","28\nExpatriate Plans\nSMALL GROUP\nTotal ","29\nExpatriate Plans\nLARGE GROUP\nPY2","30\nExpatriate Plans\nLARGE GROUP\nPY1","31\nExpatriate Plans\nLARGE GROUP\nCY","32\nExpatriate Plans\nLARGE GROUP\nTotal","33\nStudent Health Plans\nINDIVIDUAL\nPY2","34\nStudent Health Plans\nINDIVIDUAL\nPY1","35\nStudent Health Plans\nINDIVIDUAL\nCY","36\nStudent Health Plans\nINDIVIDUAL\nTotal"]
[null,"1. Medical Loss Ratio Numerator"]
[null,"1.8 MLR numerator "]
[null,"1.9 MLR numerator Mini-Med and Student Health (using adjustment factor)"]
[null,"2. Medical Loss Ratio Denominator"]
[null,"2.3 MLR Denominator (Lines 2.1 - 2.2) "]
[null,"4. Credibility Adjustment"]
[null,"4.5 Credibility adjustment (Lines 4.2 x 4.4 (do not round)) "]
[null,"6. Rebate Calculation"]
[null,"6.1 MLR standard"]
[null,"6.2 Credibility-adjusted MLR (Line 5.3)"]
[null,"6.3 Adjusted earned premium (Lines 2.1 - 2.2 CY)"]
[null,"6.4 Rebate amount if credibility-adjusted MLR is less than MLR standard (Lines (6.1 - 6.2) x 6.3)"]
[null,"6.5 Optional: single-year rebate liability (Line 2.3 x [Line 6.1 - (Lines 5.1a or 5.1b + 5.2)])"]
[null,"6.6 Optional: paid rebate liability (see instructions)"]
[null,"6.7 Optional: unpaid rebate liability (Lines 6.5 - 6.6)"]
[null,"6.8 Limited payable rebate amount (see instructions)"]

{"sheet":"Attestation","index":9,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Attestation Statement"]
[]
["The officers of this reporting issuer being duly sworn, each attest that he/she is the described officer of the reporting issuer, and that this MLR Reporting Form, the Company/Issuer Associations, and any supplemental submission that the issuer includes are full and true statements of all the elements included therein for the MLR reporting year, and that the MLR Reporting Form has been completed in accordance with the Department of Health and Human Services’ reporting instructions, according to the best of his/her information, knowledge and belief.  Furthermore, the scope of this attestation by the described officer includes any related electronic filings and postings for the MLR reporting year and which are required by Department of Health and Human Services under section 2718 of the Public Health Service Act and implementing regulation."]
[]
["____________________________ "]
["Chief Executive Officer/President"]
[]
["____________________________  "]
["Chief Financial Officer"]

{"sheet":"Reference Tables","index":10,"n_rows":61,"n_cols":22,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Table 3 - State and Territory Names and MLR Standards"]
["Table 1 - Base Credibility Adjustment Factors",null,null,"State or Territory Name","2017\nIndividual","2017\nSmall Group","2016\nIndividual","2016\nSmall Group","2015\nIndividual","2015\nSmall Group","2014\nIndividual","2014\nSmall Group","2013\nIndividual","2013\nSmall Group","2012\nIndividual","2012\nSmall Group","2011\nIndividual","2011\nSmall Group",null,"Table 4 - Reporting Years",null,"Table 5 - Yes/No"]
["Life Years","Base credibility factor",null,"Alaska",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2011,null,"Yes"]
[0,0,null,"Alabama",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2012,null,"No"]
[1000,8.3000000000000004E-2,null,"Arkansas",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2013]
[2500,5.1999999999999998E-2,null,"American Samoa",null,null,null,null,null,null,null,null,0.8,0.8,0.8,0.8,0.8,0.8,null,2014]
[5000,3.6999999999999998E-2,null,"Arizona",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2015]
[10000,2.5999999999999999E-2,null,"California",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2016]
[25000,1.6E-2,null,"Canada",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[50000,1.2E-2,null,"Colorado",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2018]
[75000,0,null,"Connecticut",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2019]
[null,null,null,"District of Columbia",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2020]
[null,null,null,"Delaware",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2021]
[null,null,null,"Florida",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2022]
["Table 2 - Deductible Factors",null,null,"Georgia",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.75,0.8,0.7,0.8,null,2023]
["Average Health Plan Deductible","Deductible factor",null,"Grand Total",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2024]
[0,1,null,"Guam",null,null,null,null,null,null,null,null,0.8,0.8,0.8,0.8,0.8,0.8,null,2025]
[2500,1.1639999999999999,null,"Hawaii",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2026]
[5000,1.4019999999999999,null,"Iowa",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.75,0.8,0.67,0.8,null,2027]
[10000,1.736,null,"Idaho",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2028]
[null,null,null,"Illinois",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2029]
[null,null,null,"Indiana",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2030]
[null,null,null,"Kansas",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2031]
[null,null,null,"Kentucky",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.75,0.8,null,2032]
[null,null,null,"Louisiana",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2033]
[null,null,null,"Massachusetts",0.88,0.88,0.88,0.88,0.88,0.88,0.89,0.89,0.9,0.9,0.9,0.9,0.9,0.9,null,2034]
[null,null,null,"Maryland",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2035]
[null,null,null,"Maine",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.65,0.8,0.65,0.8,null,2036]
[null,null,null,"Michigan",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2037]
[null,null,null,"Minnesota",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2038]
[null,null,null,"Missouri",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2039]
[null,null,null,"MP",null,null,null,null,null,null,null,null,0.8,0.8,0.8,0.8,0.8,0.8,null,2040]
[null,null,null,"Mississippi",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2041]
[null,null,null,"Montana",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2042]
[null,null,null,"North Carolina",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.75,0.8,null,2043]
[null,null,null,"North Dakota",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2044]
[null,null,null,"Nebraska",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2045]
[null,null,null,"New Hampshire",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.75,0.8,0.72,0.8,null,2046]
[null,null,null,"New Jersey",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2047]
[null,null,null,"New Mexico",0.8,0.85,0.8,0.85,0.8,0.85,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2048]
[null,null,null,"Nevada",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.75,0.8,null,2049]
[null,null,null,"New York",0.82,0.82,0.82,0.82,0.82,0.82,0.82,0.82,0.82,0.82,0.82,0.82,0.82,0.82,null,2050]
[null,null,null,"Ohio",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2051]
[null,null,null,"Oklahoma",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2052]
[null,null,null,"Oregon",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2053]
[null,null,null,"Other Territories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2054]
[null,null,null,"Pennsylvania",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2055]
[null,null,null,"Puerto Rico",null,null,null,null,null,null,null,null,0.8,0.8,0.8,0.8,0.8,0.8,null,2056]
[null,null,null,"Rhode Island",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2057]
[null,null,null,"South Carolina",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2058]
[null,null,null,"South Dakota",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2059]
[null,null,null,"Tennessee",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,2060]
[null,null,null,"Texas",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[null,null,null,"Utah",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[null,null,null,"Virginia",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[null,null,null,"Virgin Islands",null,null,null,null,null,null,null,null,0.8,0.8,0.8,0.8,0.8,0.8]
[null,null,null,"Vermont",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[null,null,null,"Washington",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[null,null,null,"Wisconsin",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[null,null,null,"West Virginia",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[null,null,null,"Wyoming",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]