{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","ProgramStartDateValid","I_State, program, and plan info","StateValidation","II_Reconciliation","Revenue+Exp Storage","III_Plan Rev Exp Detailed (Mo)","III_Plan Rev Exp Detailed (Qt)"],"not_rendered":{"images":1,"macros":1,"defined_names":35},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"merged":[[3,1,3,3],[6,1,6,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[12,1,12,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[23,1,23,3],[26,1,26,3],[29,1,29,3]]}
["Column A is blank. All information begins in column B, row 1.","Reporting Template for COVID-19 Risk Corridor Reconciliation"]
[null,"Instructions"]
[null,"Overview"]
[null,"Regulations at 42 C.F.R. § 438.6 outline provisions related to payments to Medicaid Managed Care Organizations (MCOs), Prepaid Inpatient Health Plans (PIHPs), and Prepaid Ambulatory Health Plans (PAHPs)—collectively referred to as “managed care plans.” The purpose of this template is to collect and analyze reconciliations for one and two-sided risk corridors that states implemented to reduce uncertainty associated with the COVID-19 Public Health Emergency. \n\nTo submit this information to the Centers for Medicare & Medicaid Services (CMS), states should complete one (1) template with information for all applicable plans within a program during a particular rating period. States are not expected to report risk corridor reconciliation results in this document for rating periods that end after December 31, 2021. If states have multiple programs that used different COVID-19-related risk corridors or have completed multiple reconciliations, they should submit one (1) template per reconciliation. Consistent with the Managed Care Program Annual Report (MCPAR) required by 42 C.F.R. § 438.66(e), this template defines a program as a group of plans that have a specified set of benefits, eligibility criteria, and capitation rate cells that are articulated in a contract between the state and managed care plans.\n\nInformation that states submit in this template will assist CMS in helping oversee the performance of state Medicaid managed care plans. Questions regarding the completion of this template should be sent to: ManagedCareTA@cms.hhs.gov."]
[]
[null,"Organization"]
[null,"This template is dynamic and contains formulas to help states submit the information to CMS efficiently and accurately. It includes three tabs (Tabs I, II, and III), which states should fill out in succession. When opening a new file, states will only see this current \"Instructions\" tab and Tab I. States will use macro-enabled buttons to unhide tabs II and III as they proceed through the reporting process (see “Inputting Information”). \n\nIn Tab I (\"State, program, and plan information\"), states should provide general information about the program, the managed care plans (up to 40 plans) and the COVID-19 related risk corridors that have been implemented. Information entered here will determine the layout of the subsequent Tabs II and III. In Tab II (\"Risk corridor reconciliation information\"), states should provide details on the risk corridor structure and report on plan-level revenue and expenses that are eligible for reconciliations according to the risk corridor. Information entered here will feed into the imbedded formulas that will calculate the final reconciliation amounts. In Tab III (\"Detailed plan revenue and expenses\"), states should provide detailed breakdowns on plan-level revenue and expenses by month or quarter; states also have the option of reporting specific revenue/expense sources eligible for reconciliations.",null,null," "]
[]
[null,"Inputting information"]
[null,"A description of how to input information is provided below. Subsequent sections/tabs provide further instructions on how each item should be reported in the “Item Instructions” column. The types of data to be entered (for example, free text, numerical or drop-down list of set values) are specified in the “Data Format” columns. Cells are color coded based on their contents, as follows: "]
[null,"BEIGE: Cell is a required data entry item. States must follow instructions and input the type of data as specified."]
[]
[null,"BLUE: Cell is an optional data entry item. States may follow instructions and input the type of data as specified. These items will also have \"(Optional)\" in the description."]
[]
[null,"GREY: Cell contains a formula and is automatically filled once input data is entered. Grey cells are locked for data entry; states should not attempt to change anything. "]
[null,"\n\n\n"]
[null,"GREEN: Cell contains example data, for reference only. States can refer to the example before they complete the relevant items."]
[null,"\n\n\n"]
[null,"WHITE: Cell contains instructions, for reference only. States should not attempt to change anything."]
[null,"\n\n\n"]
[null,"NOTE: This template requires the use of macros. You may not use this file in \"read-only\" mode but must save this file. If you have not already enabled content on this file, please do so now. The image on the right shows prompts you may receive and circles the items that a user must select to enable full functionality. \n\nNOTE: The template is dynamic and all information in the first tab “I_State, program, and plan info” must be completed before entering data in subsequent tabs."]
[]
[null,"Tab I. State, Program, and Plan Information"]
[null,"I.A. State and Program Information\nStates should use this section to report their contact information, date of report submission, program information, and other related information. All items are required.\n\nI.B Plan Information\nStates should use this section to report information of applicable plans (up to 40 plans) for the risk corridor. All items are required.\n              \nI.C Risk Corridor Information\nStates must enter all information in this section to determine the layout of the subsequent Tabs II and III. Only information on programs with risk corridors that are specific to the COVID-19 Public Health Emergency should be provided in this template.\n\nI.D Covered Providers - Optional\nIf the risk corridor covers a specific program, states may use this section to report the types of provider covered under the program. States can enter \"N/A\" if the risk corridor is \"state-based\", meaning the risk corridor applies uniformly to all managed care programs within the state. \n\nAfter completing Tab 1, please click the \"Proceed to Tab II\" button. This will allow the layout of Tabs II and III to match information provided in Tab I. "]
[]
[null,"Tab II. Risk Corridor Reconciliation Information"]
[null,"II.A. Risk Corridor Features\nStates should use this section to describe key features of the risk corridor being reported on, such as number of bands and target methodology. \nAfter completing this section, please click the \"Continue Tab II\" button to complete the remaining Tab II items. This will allow the layout of the subsequent sections to match features described in Section II.A. \n\nII.B. Risk Corridor Band Boundaries\nStates should use this section to specify the risk corridor band boundaries as well as the risk sharing percentages in line with the state’s design of the risk corridor. An example is provided to illustrate how states should complete this section to ensure that the formula-driven reconciliation amounts are calculated correctly. \n                     \nII.C. Eligible Revenue and Expenses for Determining Reconciliations\nStates should use Items II.C.1 and II.C.2 in this section to report the risk corridor target and actuals in terms of the eligible revenue and expense for determining reconciliation amounts for each plan in the risk corridor. \n\nAfter completing Items II.C.1 and II.C.2, please proceed to review item II.C.3, sections II.D through II.G and item II.H.1, which have been pre-populated with formulas to automatically calculate the reconciliation amount according to the risk corridor being reported on. No data entry is allowed with these items.\n\nII.H. Federal Share of Reconciliation\nAfter confirming the reconciliation amounts as calculated, states should use items II.H.2 through II.H.4 to report the federal and non-federal shares of the gross reconciliation payment. If the state has not established the final federal share amount, please provide an estimate. Please contact ManagedCareTA@cms.hhs.gov, if the total reconciliation amounts shown in items II.G.1 and II.H.1 is not as expected.\n\n \nClick the \"Proceed to Tab III\" button. This will allow the layout of Tab III to match information provided in Tab II."]
[]
[null,"Tab III. Detailed Plan Revenue and Expenses"]
[null,"III.A Monthly/Quarterly Plan Revenue and Expenses\nStates should use this section to report a monthly or quarterly (per item I.C.3) breakdown of plan revenue and expenses that are eligible for the risk corridor reconciliation. For quality assurance, the template automatically compares annual revenue and expenses as reported in Tab II. This is the last required item in this template. \n\nIII.B Revenue Sources by Plan (Annual) - Optional\nStates may report annual breakdown by revenue sources (per item II.A.5). This section is optional, but states are highly encouraged to provide additional detail that will assist in the CMS review of the reconciliation results.\n\nIII.C  Expense Sources by Plan (Annual) - Optional\nStates may report annual breakdown by expense sources (per item II.A.6). This section is optional, but states are highly encouraged to provide additional detail that will assist in the CMS review of the reconciliation results."]
[null,"End of worksheet"]

{"sheet":"ProgramStartDateValid","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"hidden":true}
["N/A","2000-01-01"]
[null,"2022-01-01"]

{"sheet":"I_State, program, and plan info","index":2,"n_rows":47,"n_cols":45,"rows_kept":47,"merged":[[3,1,3,3],[19,1,19,3],[26,1,26,3],[33,1,33,3]]}
["Column A is blank. All information begins in column B, row 2."]
[null,"I. State, program, and plan information"]
[null,"A. State and program information"]
[null,"States should use this section to report their contact information, date of report submission, program information, and other related information. (All items in this section require input.)",{"$nulls":3},"Input state/program-level data in this column "]
[null,"#","Item","Item Instructions","Data Format",{"$f":"IF(F8=\"\",\"[State]\",F8)","v":"[State]"}]
[null,"I.A.1","Contact name","Enter the name of the individual(s) filling out this document.","Free text"]
[null,"I.A.2","Contact email address","Enter the email address(es) of the individual(s) filling out this document.","Free text"]
[null,"I.A.3","State or territory","Enter the state or territory represented in this document.","Drop down list of set values (select one)"]
[null,"I.A.4","State-based or program-based risk corridor","Indicate if the COVID-19 risk corridor that the state is reporting on applies to all programs and plans in the state or is limited to one program and the plans under that program. If the state is reporting on a single risk corridor state-wide across all programs, choose \"State\". If the state is reporting on a risk corridor that applies to one program, choose “Program”.\n\nWe do not expect risk corridors structures (i.e., the number of risk corridor bands or risk sharing percentages for plans and states) to vary for a particular risk corridor, although the state may set different risk corridor targets (for example, different Medical Loss Ratio (MLR) targets) for each plan. The state can enter specific targets for plans in the “II_Reconciliation” tab. ","Drop down list of set values (select one)"]
[null,"I.A.5","Risk corridor title","If the risk corridor that the state is reporting on has a title, indicate the name of the risk corridor.","Free text"]
[null,"I.A.6","Program name(s) for a state-based risk corridor","If the state selected “State” in item I.A.4, indicate the program name(s) that the risk corridor applies to.","Free text"]
[null,"I.A.7","Program name for a program-based risk corridor","If the state selected “Program” in item I.A.4, indicate the program name that the risk corridor applies to.","Free text"]
[null,"I.A.8","Program start date","If the state selected “Program” in item I.A.4, indicate what year the state implemented the program. ","Free text"]
[null,"I.A.9","Plan type","Indicate the managed care plan type (MCO, PIHP, or PAHP) that contracts with the state for the risk corridor that the state is reporting on. ","Drop down list of set values or free text (select one)"]
[null,"I.A.10","Rating period start date","Enter the rating period start date for the risk corridor reconciliation results that the state is reporting on in this document. ","Date (MM/DD/YYYY)"]
[null,"I.A.11","Rating period end date","Enter the rating period end date for the risk corridor reconciliation results that the state is reporting on in this document. States are not expected to report risk corridor reconciliation results in this document for rating periods that end after December 31, 2021.","Date (MM/DD/YYYY)"]
[null,"I.A.12","Date of report submission","Enter the date on which the state is submitting this document to CMS.","Date (MM/DD/YYYY)"]
[]
[null,"B. Plan information"]
[null,"States should use this section to report plan names for the program specified above in I.A.4. (All items in this section require input.)",{"$nulls":3},"Input plan-level data in beige cells in these columns >>"]
[null,"#","Item","Item Instructions","Data Format","Plan 1","Plan 2","Plan 3","Plan 4","Plan 5","Plan 6","Plan 7","Plan 8","Plan 9","Plan 10","Plan 11","Plan 12","Plan 13","Plan 14","Plan 15","Plan 16","Plan 17","Plan 18","Plan 19","Plan 20","Plan 21","Plan 22","Plan 23","Plan 24","Plan 25","Plan 26","Plan 27","Plan 28","Plan 29","Plan 30","Plan 31","Plan 32","Plan 33","Plan 34","Plan 35","Plan 36","Plan 37","Plan 38","Plan 39","Plan 40"]
[null,"I.B.1","Plan names","Enter the names of the plans that contract with the state for the risk corridor that the state is reporting on. Leave any remaining fields blank. \n\nThis response will affect the layout of Tab 2 and Tab 3. ","Free text"]
[null,"I.B.2","Plan parent company","For each plan entered for item I.B.1, enter the plan's parent company name. Leave any remaining fields blank. If your plan parent company name is the same as the plan name, please enter it here. ","Free text"]
[null,"I.B.3","Member months covered by the plan","For each plan entered for item I.B.1, indicate how many member months the plan covered for the rating period entered in I.A.12 and I.A.13.","Numeric"]
[]
[null,"C. Risk corridor targets and monthly/quarterly expenditure and revenue data"]
[null,"States should enter information in this section to obtain instructions on which tabs to use in completing this template. After entering the information below, the template will return a list of tabs to complete based on the responses provided. (All items in this section require input.)",{"$nulls":3},"Input state/program-level data in this column "]
[null,"#","Item","Item Instructions","Data Format","Input state/program-level data in this column "]
[null,"1.C.1","If the risk corridor is implemented at the state level, does the risk corridor target differ by plan? ","Indicate whether the state-based risk corridor that the state is reporting on has risk corridor targets that vary by plan. For example, this could include unique MLR targets for each plan based on enrollment of beneficiaries from different rate cells. Enter N/A if the state is reporting on a program-based risk corridor per item I.A.4.","Drop down list of set values (select one) "]
[null,"I.C.2","If the risk corridor is implemented at the program level, does the risk corridor target differ by plan? ","Indicate whether the program-based risk corridor that the state is reporting on has risk corridor targets that vary by plan. For example, this could include unique MLR targets for each plan based on enrollment of beneficiaries from different rate cells. Enter N/A if the state is reporting on a state-based risk corridor per item I.A.4. ","Drop down list of set values (select one) "]
[null,"I.C.3","Does your state use monthly or quarterly expenditure and revenue data?","Indicate whether the state uses monthly or quarterly expenditure and revenue data for the risk corridor it is reporting on. \n\nThis response will affect the layout of Tab 3. ","Drop down list of set values (select one) "]
[]
[null,"D. Covered providers (Optional)"]
[null,"If the risk corridor covers a specific program per item I.A.4, complete items I.D.1 - I.D.12. Indicate whether the program specified in I.A.8 covers each 42 C.F.R. § 438.68 provider type specified. The state can reference its model contract for the program for this information. These questions also appear in the Network Adequacy and Access Assurances Report (NAAAR) template that is available on Medicaid.gov. If the state is reporting on a state-based risk corridor per item I.A.4, enter N/A for these items. (This section is optional.)",{"$nulls":3},"Input state/program-level data in this column "]
[null,"#","Item","Item Instructions","Data Format","Input state/program-level data in this column "]
[null,"I.D.1","Adult primary care","Indicate whether the program covers adult primary care providers.","Drop down list of set values (select one)",""]
[null,"I.D.2","Pediatric primary care","Indicate whether the program covers pediatric primary care providers. ","Drop down list of set values (select one)",""]
[null,"I.D.3","OB/GYN","Indicate whether the program covers Ob/Gyn providers. ","Drop down list of set values (select one)",""]
[null,"I.D.4","Adult behavioral health","Indicate whether the program covers adult behavioral health providers. ","Drop down list of set values (select one)",""]
[null,"I.D.5","Pediatric behavioral health","Indicate whether the program covers pediatric behavioral health providers. ","Drop down list of set values (select one)",""]
[null,"I.D.6","Adult specialist","Indicate whether the program covers adult specialist providers. ","Drop down list of set values (select one)",""]
[null,"I.D.7","Pediatric specialist","Indicate whether the program covers pediatric specialist providers. ","Drop down list of set values (select one)",""]
[null,"I.D.8","Hospital","Indicate whether the program covers hospital providers. ","Drop down list of set values (select one)",""]
[null,"I.D.9","Pharmacy","Indicate whether the program covers pharmacy providers. ","Drop down list of set values (select one)",""]
[null,"I.D.10","Pediatric dental","Indicate whether the program covers pediatric dental providers. ","Drop down list of set values (select one)",""]
[null,"I.D.11","LTSS","Indicate whether the program covers long-term services and supports (LTSS) providers. ","Drop down list of set values (select one)",""]
[null,"I.D.12","Other","Provide (1) any notes for items I.D.1 - 11 and/or (2) other provider types covered under the program not listed in items I.D.1 - 11, such as adult dental services.","Free text"]

{"sheet":"StateValidation","index":3,"n_rows":56,"n_cols":1,"rows_kept":56,"hidden":true}
["Alabama"]
["Alaska"]
["American Samoa"]
["Arizona"]
["Arkansas"]
["California"]
["Colorado"]
["Connecticut"]
["Delaware"]
["District of Columbia"]
["Florida"]
["Georgia"]
["Guam"]
["Hawaii"]
["Idaho"]
["Illinois"]
["Indiana"]
["Iowa"]
["Kansas"]
["Kentucky"]
["Louisiana"]
["Maine"]
["Maryland"]
["Massachusetts"]
["Michigan"]
["Minnesota"]
["Mississippi"]
["Missouri"]
["Montana"]
["Nebraska"]
["Nevada"]
["New Hampshire"]
["New Jersey"]
["New Mexico"]
["New York"]
["North Carolina"]
["North Dakota"]
["Northern Mariana Islands"]
["Ohio"]
["Oklahoma"]
["Oregon"]
["Pennsylvania"]
["Puerto Rico"]
["Rhode Island"]
["South Carolina"]
["South Dakota"]
["Tennessee"]
["Texas"]
["U.S. Virgin Islands"]
["Utah"]
["Vermont"]
["Virginia"]
["Washington"]
["West Virginia"]
["Wisconsin"]
["Wyoming"]

{"sheet":"II_Reconciliation","index":4,"n_rows":231,"n_cols":94,"rows_kept":231,"hidden":true,"merged":[[4,2,4,4],[5,5,5,7],[6,5,6,7],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[9,5,9,7],[10,5,10,7],[11,5,11,7],[12,5,12,7],[14,1,14,7],[30,5,30,7],[47,1,47,2],[48,1,48,3],[53,1,53,4],[54,1,54,3],[69,1,69,3],[70,54,70,63],[70,64,70,73],[70,74,70,83],[70,84,70,93],[84,1,84,3],[116,1,116,4],[132,5,132,7],[149,1,149,2],[150,1,150,3],[162,1,162,3],[177,1,177,3],[178,54,178,63],[178,64,178,73],[178,74,178,83],[178,84,178,93],[192,1,192,3],[228,5,228,8]]}
["Column A is blank. All information begins in column B, row 2.","II. Reconciliation"]
[null,"A. Risk Corridor Features"]
[null,"Use this section to report on the risk corridor’s features, including the risk corridor's structure, bands, and target methodology. "]
[]
[null,"Program  Names",{"$f":"IF('I_State, program, and plan info'!F9=\"State\",'I_State, program, and plan info'!F11,'I_State, program, and plan info'!F12)","v":0}]
[null,"#","Risk corridor features","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F10","v":0},{"$nulls":47},"Revenue sources Go Here:"]
[null,"II.A.1","Risk corridor structure","Indicate whether the risk corridor is one-sided, two-sided symmetric, or two-sided asymmetric. \n\nA one-sided risk corridor is defined as a risk corridor that addresses plan profits and losses, but not both. \n\nA two-sided symmetric risk corridor is defined as a risk corridor that addresses plan profits and losses, with an equal number of bands and symmetrical risk sharing percentages on either side of the risk corridor's target. \n\nA two-sided asymmetric risk corridor is defined as a risk corridor that addresses plan profits and losses, but does not have an equal number of bands and/or symmetrical risk sharing percentages on either side of the risk corridor's target.\n\nThis response will affect the layout of this tab. ","Drop down list of set values (select one)"]
[null,"II.A.2","Number of bands in risk corridor","In cell F9, indicate the number bands in the risk corridor, exclusive of the neutral zone. For example, if a state has a risk corridor with a neutral zone and two bands on each side, enter “4” in cell F9. \n\nIf the risk corridor is One-Sided or Two-Sided asymmetric per item II.A.1, also indicate how many bands are above or below the neutral zone in cells G9 and H9, respectively. For example, if a risk corridor has a neutral zone with two bands above the neutral zone and one band below the neutral zone, enter “2” in cell G9 and “1” in cell H9. If a risk corridor is One-Sided with 3 bands above the neutral zone, enter \"3\" in cell G9 and leave cell H9 blank.\n\nThis response will affect the layout of this tab.","Drop down list of set values (select one)","Number of Bands - Cell F9","(If Asymmetric or One-Sided) Bands Above Neutral Zone, Cell G9","(If Asymmetric or One-Sided) Bands Below Neutral Zone, Cell H9"]
[]
[null,"II.A.3","Risk corridor target methodology","Indicate whether the risk corridor's target methodology uses Medical Loss Ratio (MLR) or a target ratio. An MLR target methodology compares a plan’s actual MLR against a target MLR. A target ratio methodology compares a plan's actual medical expenses to the plan’s expected medical expenses set in the program’s rate certification. Please contact ManagedCareTA@mathematica-mpr.com if the risk corridor's target methodology uses neither MLR nor a target ratio. \n\nThis response will affect the layout of this tab.","Drop down list of set values (select one)"]
[null,"II.A.4","Risk corridor target","Describe the target of the risk corridor. For example, this might be “85% MLR” or “a match between a plan’s actual medical expenses and the plan’s expected medical expenses set in the program’s rate certification.”","Free text"]
[null,"II.A.5","State's revenue sources (Optional)","Describe the sources of revenue eligible for inclusion in the risk corridor in cell F12. These might include premium revenue for medical costs, care management, etc. Please list up to 10 revenue sources per program, separate them by commas and omit leading spaces. \n\nThis response will affect the layout of Tab III.","Free text"]
[null,"II.A.6","State's expense sources (Optional)","Describe the sources of expenses eligible for inclusion in the risk corridor in cell F13. These might include claims, quality improvement activities, etc. Please list up to 10 expense sources per program, separate them by commas, and omit leading spaces. \n\nThis response will affect the layout of Tab III.","Free text"]
[]
[null,"B. Risk Corridor Band Boundaries\nA target ratio based risk corridor assumes that a plan's risk corridor actuals (i.e., the plan's expenses that are eligible for the risk corridor) should match the risk corridor's target (i.e., the plan's revenue that is eligible for the risk corridor), and that deviations in the plan's risk corridor actuals from that target can trigger a reconciliation. Use this section to specify the risk corridor's band boundaries as well as the state and plan risk sharing percentages as specified in the state’s design of the risk corridor (for example, one-sided, two-sided symmetric, two-sided asymmetric). For example, for a one-sided risk corridor, only populate the rows corresponding to the bands above or below the neutral zone. For a two-sided risk corridor, enter information for bands above and below the neutral zone. States may use the example provided in rows 31-44 (colored green) as reference for completing this section. This section must be completed accurately for the reconciliation amounts to be calculated properly at the end of this tab. \n\nPlease complete this section by populating columns F and G with the plan share and state share of each band under the risk corridor. For example, if the second band above the neutral zone has a plan share of 25% and a state share of 75%, enter 25% and 75% in columns F and G. In column H, enter the band limits of the risk corridor.\n\nThe target for the risk corridor should be equated to 100% with bands beginning above and below 100% for the reconciliation of actual expenditures. For example, if the second band above the neutral zone has a band limit of 4% or 104% compared to the target of the risk corridor, enter 104% in column H. For the highest and lowest bands above and below the neutral zone that the state enters for its risk corridor, enter '999%' in column H for the final band above the state's neutral zone. Enter '1%' in column H for the final band below the state's neutral zone. This will allow formulas pre-populated in Sections II.D through II.G to work properly to calculate the reconciliation amounts. For example, if the risk corridor has two bands above the neutral zone and two bands below the neutral zone, enter '999%' in column H for the second band above the neutral zone and '1%' in column H for the second band for the neutral zone."]
[null,"#","Risk corridor bands","Item instructions","Data format","Plan share","State share","Band limit"]
[{"$nulls":53},"Expense sources Go Here:"]
[null,null,"Fifth band above neutral zone","Indicate band information for the fifth band above the neutral zone.","Numeric"]
[null,null,"Fourth band above neutral zone","Indicate band information for the fourth band above the neutral zone.","Numeric"]
[null,null,"Third band above neutral zone","Indicate band information for the third band above the neutral zone.","Numeric"]
[null,null,"Second band above neutral zone","Indicate band information for the second band above the neutral zone.","Numeric"]
[null,null,"First band above neutral zone","Indicate band information for the first band above the neutral zone.","Numeric"]
[null,null,"Neutral zone high","Indicate band information for the upper limit of the neutral zone.","Numeric"]
[null,null,"Neutral zone low","Indicate band information for the lower limit of the neutral zone.","Numeric"]
[null,null,"First band below neutral zone","Indicate band information for the first band below the neutral zone.","Numeric"]
[null,null,"Second band below neutral zone","Indicate band information for the second band below the neutral zone.","Numeric"]
[null,null,"Third band below neutral zone","Indicate band information for the third band below the neutral zone.","Numeric"]
[null,null,"Fourth band below neutral zone","Indicate band information for the fourth band below the neutral zone.","Numeric"]
[null,null,"Fifth band below neutral zone","Indicate band information for the fifth band below the neutral zone.","Numeric"]
[]
[{"$nulls":5},"EXAMPLE"]
[null,"Example","Risk corridor band boundaries as percentage","Item instructions","Example risk corridor bands are displayed in columns F:H. ","Plan share","State share","Band limit"]
[null,null,"Fifth band above neutral zone","Indicate band information for the fifth band above the neutral zone.","Numeric",{"v":0.1,"d":"10%"},{"v":0.9,"d":"90%"},{"v":9.99,"d":"999%"}]
[null,null,"Fourth band above neutral zone","Indicate band information for the fourth band above the neutral zone.","Numeric",{"v":0.15,"d":"15%"},{"v":0.85,"d":"85%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=8,999%,130%),IF($G$9=4,999%,130%))","v":{"v":1.3,"d":"130%"}}]
[null,null,"Third band above neutral zone","Indicate band information for the third band above the neutral zone.","Numeric",{"v":0.2,"d":"20%"},{"v":0.8,"d":"80%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=6,999%,125%),IF($G$9=3,999%,125%))","v":{"v":1.25,"d":"125%"}}]
[null,null,"Second band above neutral zone","Indicate band information for the second band above the neutral zone.","Numeric",{"v":0.25,"d":"25%"},{"v":0.75,"d":"75%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=4,999%,120%),IF($G$9=2,999%,120%))","v":{"v":1.2,"d":"120%"}}]
[null,null,"First band above neutral zone","Indicate band information for the first band above the neutral zone.","Numeric",{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=2,999%,115%),IF($G$9=1,999%,115%))","v":{"v":1.15,"d":"115%"}}]
[null,null,"Neutral zone high","Indicate band information for the upper limit of the neutral zone.","Numeric",{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":1.1,"d":"110%"}]
[null,null,"Neutral zone low","Indicate band information for the lower limit of the neutral zone.","Numeric",{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":0.9,"d":"90%"}]
[null,null,"First band below neutral zone","Indicate band information for the first band below the neutral zone.","Numeric",{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=2,1%,85%),IF($H$9=1,1%,85%))","v":{"v":0.85,"d":"85%"}}]
[null,null,"Second band below neutral zone","Indicate band information for the second band below the neutral zone.","Numeric",{"v":0.25,"d":"25%"},{"v":0.75,"d":"75%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=4,1%,80%),IF($H$9=2,1%,80%))","v":{"v":0.8,"d":"80%"}}]
[null,null,"Third band below neutral zone","Indicate band information for the third band below the neutral zone.","Numeric",{"v":0.2,"d":"20%"},{"v":0.8,"d":"80%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=6,1%,75%),IF($H$9=3,1%,75%))","v":{"v":0.75,"d":"75%"}}]
[null,null,"Fourth band below neutral zone","Indicate band information for the fourth band below the neutral zone.","Numeric",{"v":0.15,"d":"15%"},{"v":0.85,"d":"85%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=8,1%,70%),IF($H$9=4,1%,70%))","v":{"v":0.7,"d":"70%"}}]
[null,null,"Fifth band below neutral zone","Indicate band information for the fifth band below the neutral zone.","Numeric",{"v":0.1,"d":"10%"},{"v":0.9,"d":"90%"},{"v":0.01,"d":"1%"}]
[]
[null,"C-F. Risk Corridor Revenue and Expenses by Plan (Target Ratio)"]
[null,"Use this section to report eligible revenue and expenses for each plan in the risk corridor. "]
[null,"Use this section to report eligible revenue and expenses for each plan in the risk corridor. ",null,{"$f":"$F$6","v":0}]
[null,"C. Eligible Revenue and Expenses for Determining Reconciliations"]
[null,"#","Category","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"II.C.1","Risk Corridor Target - Eligible plan revenue for the risk corridor","Enter the amount of revenue (in dollars) that is eligible for reconciliation in the risk corridor for the rating period specified in items I.A.12 and I.A.13. This should be consistent with the parameters of the risk corridor and program. Enter the value as positive. For example, if the total revenue for the plan is $100, and the eligible revenue for the risk corridor is total revenue less $15 for administrative expenses, enter “$85”. Complete this item for each plan. ","Numeric"]
[null,"II.C.2","Risk Corridor Actuals - Eligible plan expenses for the risk corridor","Enter the amount of expenses (in dollars) that are eligible for reconciliation in the risk corridor for the rating period specified in items I.A.12 and I.A.13. This should be consistent with the parameters of the risk corridor and program. Enter the value as positive. For example, if eligible expenses include for the risk corridor include $85 of medical claims and $5 of quality improvement expenses, enter “$90”. Complete this item for each plan. ","Numeric"]
[null,"II.C.3","Difference between eligible plan expenses and eligible plan revenue","N/A. Do not complete this row. This field calculates the difference between II.C.1 and II.C.2","Formula",{"$f":"F52-F51","v":0}]
[null,"II.D through II.G are pre-populated with formulas to automatically calculate once information is provided in II.A-II.C. No data entry is allowed. States should only review II.D through II.G for accuracy and completeness. Please contact ManagedCareTA@mathematica-mpr.com if the final reconciliation calculation in II.G appear to be incorrect."]
[null,"D. Band Boundaries in Dollars"]
[null,"#","Category","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,null,"Fifth band above neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the fifth band of the risk corridor - High","Formula",{"$f":"F$51*$H18","v":0}]
[null,null,"Fourth band above neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the fourth band of the risk corridor - High","Formula",0]
[null,null,"Third band above neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the third band of the risk corridor - High","Formula",0]
[null,null,"Second band above neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the second band of the risk corridor - High","Formula",0]
[null,null,"First band above neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the first band of the risk corridor - High","Formula",0]
[null,null,"Neutral zone high","N/A. Do not complete this row. This field calculates the boundary in dollars of the neutral zone of the risk corridor - High","Formula",0]
[null,null,"Neutral zone low","N/A. Do not complete this row. This field calculates the boundary in dollars of the neutral zone of the risk corridor - Low","Formula",0]
[null,null,"First band below neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the first band of the risk corridor -Low","Formula",0]
[null,null,"Second band below neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the second band of the risk corridor -Low","Formula",0]
[null,null,"Third band below neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the third band of the risk corridor -Low","Formula",0]
[null,null,"Fourth band below neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the fourth band of the risk corridor -Low","Formula",0]
[null,null,"Fifth band below neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the fifth band of the risk corridor -Low","Formula",0]
[]
[null,"E. Eligible Expenses by Band",{"$nulls":52},"Plan 1","Plan 2","Plan 3","Plan 4","Plan 5","Plan 6","Plan 7","Plan 8","Plan 9","Plan 10","Plan 11","Plan 12","Plan 13","Plan 14","Plan 15","Plan 16","Plan 17","Plan 18","Plan 19","Plan 20","Plan 21","Plan 22","Plan 23","Plan 24","Plan 25","Plan 26","Plan 27","Plan 28","Plan 29","Plan 30","Plan 31","Plan 32","Plan 33","Plan 34","Plan 35","Plan 36","Plan 37","Plan 38","Plan 39","Plan 40"]
[null,"#","Category","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F22","v":0},{"$nulls":48},"Target Ratio w Plan Var Program 1 Helper Cells (Plan Band Boundaries in Dollars Minus Total Revenue):",{"$nulls":9},"Target Ratio w Plan Var Program 1 Helper Cells (Plan Band Boundaries in Dollars Minus Total Revenue):",{"$nulls":9},"Target Ratio w Plan Var Program 1 Helper Cells (Plan Band Boundaries in Dollars Minus Total Revenue):",{"$nulls":9},"Target Ratio w Plan Var Program 1 Helper Cells (Plan Band Boundaries in Dollars Minus Total Revenue):"]
[null,null,"Fifth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the fifth band of the risk corridor - High","Formula",{"$f":"IF($H18>0,IF(F$53-F73-F74-F75-F76-F77>0,F$53-BC72+(BC72-BC73),0),0)","v":0},{"$nulls":47},"Fifth Band Above Neutral Zone",{"$f":"IF($H18>0,F57-F$51,0)","v":0},{"$f":"IF($H18>0,G57-G$51,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Fourth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the fourth band of the risk corridor - High","Formula",{"$f":"IF($H19>0,IF(F$53-F74-F75-F76-F77>0,IF($H18>0,IF(F$53>BC73,BC73-BC74,F$53-BC74),F$53-BC73+(BC73-BC74)),0),0)","v":0},{"$nulls":47},"Fourth Band Above Neutral Zone",{"$f":"IF($H19>0,F58-F$51,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Third band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the third band of the risk corridor - High","Formula",{"$f":"IF($H20>0,IF(F$53-F77-F76-F75>0,IF($H19>0,IF(F$53>BC74,BC74-BC75,F$53-BC75),F$53-BC74+(BC74-BC75)),0),0)","v":0},{"$nulls":47},"Third Band Above Neutral Zone",{"$f":"IF($H20>0,F59-F$51,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Second band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the second band of the risk corridor - High","Formula",{"$f":"IF($H21>0,IF(F$53-F77-F76>0,IF($H20>0,IF(F$53>BC75,BC75-BC76,F$53-BC76),F$53-BC75+(BC75-BC76)),0),0)","v":0},{"$nulls":47},"Second Band Above Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"First band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the first band of the risk corridor - High","Formula",{"$f":"IF($H22>0,IF(F$53-F77>0,IF($H21>0,IF(F$53>BC76,BC76-BC77,F$53-BC77),F$53-BC76+(BC76-BC77)),0),0)","v":0},{"$nulls":47},"First Band Above Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Neutral zone high","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the neutral zone of the risk corridor - High","Formula",{"$f":"IF(F$53<=0,0,IF(F$53>=BC77,BC77,F$53))","v":0},{"$nulls":47},"Neutral Zone High",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Neutral zone low","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the neutral zone of the risk corridor - Low","Formula",{"$f":"IF(F$53>=0,0,IF(F$53<=BC78,BC78,F$53))","v":0},{"$nulls":47},"Neutral Zone Low",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($H24>0,AB63-AB$51,0)","v":0},{"$f":"IF($H24>0,AC63-AC$51,0)","v":0},{"$f":"IF($H24>0,AD63-AD$51,0)","v":0},{"$f":"IF($H24>0,AE63-AE$51,0)","v":0},{"$f":"IF($H24>0,AF63-AF$51,0)","v":0},{"$f":"IF($H24>0,AG63-AG$51,0)","v":0},{"$f":"IF($H24>0,AH63-AH$51,0)","v":0},{"$f":"IF($H24>0,AI63-AI$51,0)","v":0},{"$f":"IF($H24>0,AJ63-AJ$51,0)","v":0},{"$f":"IF($H24>0,AK63-AK$51,0)","v":0},{"$f":"IF($H24>0,AL63-AL$51,0)","v":0},{"$f":"IF($H24>0,AM63-AM$51,0)","v":0},{"$f":"IF($H24>0,AN63-AN$51,0)","v":0},{"$f":"IF($H24>0,AO63-AO$51,0)","v":0},{"$f":"IF($H24>0,AP63-AP$51,0)","v":0},{"$f":"IF($H24>0,AQ63-AQ$51,0)","v":0},{"$f":"IF($H24>0,AR63-AR$51,0)","v":0},{"$f":"IF($H24>0,AS63-AS$51,0)","v":0}]
[null,null,"First band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the first band of the risk corridor -Low","Formula",{"$f":"IF($H25>0,IF(F$53-F78<0,IF($H26>0,IF(F53<BC79,BC79-BC78,F53-BC78),F$53-BC79+(BC79-BC78)),0),0)","v":0},{"$nulls":47},"First Band Below Neutral Zone",0,{"$f":"IF($H25>0,G64-G$51,0)","v":0},{"$f":"IF($H25>0,H64-H$51,0)","v":0},{"$f":"IF($H25>0,I64-I$51,0)","v":0},{"$f":"IF($H25>0,J64-J$51,0)","v":0},{"$f":"IF($H25>0,K64-K$51,0)","v":0},{"$f":"IF($H25>0,L64-L$51,0)","v":0},{"$f":"IF($H25>0,M64-M$51,0)","v":0},{"$f":"IF($H25>0,N64-N$51,0)","v":0},{"$f":"IF($H25>0,O64-O$51,0)","v":0},{"$f":"IF($H25>0,P64-P$51,0)","v":0},{"$f":"IF($H25>0,Q64-Q$51,0)","v":0},{"$f":"IF($H25>0,R64-R$51,0)","v":0},{"$f":"IF($H25>0,S64-S$51,0)","v":0},{"$f":"IF($H25>0,T64-T$51,0)","v":0},{"$f":"IF($H25>0,U64-U$51,0)","v":0},{"$f":"IF($H25>0,V64-V$51,0)","v":0},{"$f":"IF($H25>0,W64-W$51,0)","v":0},{"$f":"IF($H25>0,X64-X$51,0)","v":0},{"$f":"IF($H25>0,Y64-Y$51,0)","v":0},{"$f":"IF($H25>0,Z64-Z$51,0)","v":0},{"$f":"IF($H25>0,AA64-AA$51,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Second band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the second band of the risk corridor -Low","Formula",{"$f":"IF($H26>0,IF(F$53-F79-F78<0,IF($H27>0,IF(F53<BC80,BC80-BC79,F53-BC79),F$53-BC80+(BC80-BC79)),0),0)","v":0},{"$nulls":47},"Second Band Below Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Third band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the third band of the risk corridor - High","Formula",{"$f":"IF($H27>0,IF(F$53-F80-F79-F78<0,IF($H28>0,IF(F53<BC81,BC81-BC80,F53-BC80),F$53-BC81+(BC81-BC80)),0),0)","v":0},{"$nulls":47},"Third Band Below Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Fourth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the fourth band of the risk corridor - High","Formula",{"$f":"IF($H28>0,IF(F$53-F81-F80-F79-F78<0,IF($H29>0,IF(F53<BC82,BC82-BC81,F53-BC81),F$53-BC82+(BC82-BC81)),0),0)","v":0},{"$nulls":47},"Fourth Band Below Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Fifth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the fifth band of the risk corridor - High","Formula",{"$f":"IF($H29>0,IF(F$53-F82-F81-F80-F79-F78<0,F$53-BC83+(BC83-BC82),0),0)","v":0},{"$nulls":47},"Fifth Band Below Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"Check (Expect Zero Value)",{"$f":"IF($F$7=\"One-Sided\",IF(F53>0,IF(F61>0,F53-SUM(F72:F83),0),IF(F64>0,F53-SUM(F72:F83),0)),F53-SUM(F72:F83))","v":0}]
[null,"F. Share Calculations by Band"]
[null,"#","Category","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,null,"Plan share in fifth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$72*$F$18","v":0}]
[null,null,"State share in fifth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$72*$G$18","v":0}]
[null,null,"Plan share in fourth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$73*$F$19","v":0}]
[null,null,"State share in fourth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$73*$G$19","v":0}]
[null,null,"Plan share in third band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$74*$F$20","v":0}]
[null,null,"State share in third band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$74*$G$20","v":0}]
[null,null,"Plan share in second band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$75*$F$21","v":0}]
[null,null,"State share in second band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$75*$G$21","v":0}]
[null,null,"Plan share in first band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$76*$F$22","v":0}]
[null,null,"State share in first band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$76*$G$22","v":0}]
[null,null,"Plan share in first band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$79*$F$25","v":0}]
[null,null,"State share in first band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$79*$G$25","v":0}]
[null,null,"Plan share in second band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$80*$F$26","v":0}]
[null,null,"State share in second band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$80*$G$26","v":0}]
[null,null,"Plan share in third band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$81*$F$27","v":0}]
[null,null,"State share in third band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$81*$G$27","v":0}]
[null,null,"Plan share in fourth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$82*$F$28","v":0}]
[null,null,"State share in fourth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$82*$G$28","v":0}]
[null,null,"Plan share in fifth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$83*$F$29","v":0}]
[null,null,"State share in fifth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$83*$G$29","v":0}]
[]
[]
[{"$nulls":4},"Check (Expect Zero Value)",{"$f":"F72+F73+F74+F75+F76+F80+F79+F81+F82+F83-SUM(F87:F106)","v":0}]
[null,"G. Risk Corridor Reconciliations "]
[]
[]
[null,"#","Risk corridor reconciliations","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"II.G.1","Total Reconciliation","N/A. Do not complete this row. Positive Values represent payments to the plan from the Medicaid program. Negative Values represent payments to the Medicaid program from the plan.","Formula",{"$f":"F88+F90+F92+F94+F96+F98+F100+F102+F104+F106","v":0}]
[]
[{"$nulls":12},{"$f":"'I_State, program, and plan info'!K22","v":0},{"$f":"'I_State, program, and plan info'!L22","v":0},{"$f":"'I_State, program, and plan info'!M22","v":0},{"$f":"'I_State, program, and plan info'!N22","v":0},{"$f":"'I_State, program, and plan info'!O22","v":0}]
[null,"B. Risk Corridor Band Boundaries\nUse this section to specify the risk corridor's band boundaries as well as the state and plan risk sharing percentages in line with the state’s design of the risk corridor (for example, one-sided, two-sided symmetric, two-sided asymmetric). For example, for a one-sided risk corridor, only populate the rows corresponding to the bands above or below the neutral zone. For a Two-Sided risk corridor, enter information for bands above and below the neutral zone. States may use the example provided in cells 133-146 (colored green) as reference for completing this section. \n\nPlease complete this section by populating columns F and G with the plan share and state share of each band under the risk corridor. For example, if the second band above the neutral zone has a plan share of 25% and a state share of 75%, enter 25% and 75% in columns F and G. \n\nStarting in column H, enter the band limits for each plan. This allows the state to report on risk corridor bands that vary by plan due to varying MLR targets. For example, if the first band above the neutral zone has a band limit of 86% MLR for plan 1 compared to a target of 85% MLR, enter “86%”. As another example, if the first band above the neutral zone has a band limit of 87% MLR for plan 2 compared to a target of 86% MLR, enter “87%”.\n\nFor the highest and lowest bands above and below the neutral zone that the state enters for its risk corridor, enter '999%' in column H for the final band above the state's neutral zone. Enter '1%' in column H for the final band below the state's neutral zone. This will allow formulas pre-populated in Sections II.D through II.G to work properly to calculate the reconciliation amounts. For example, if the risk corridor has two bands above the neutral zone and two bands below the neutral zone, enter '999%' in column H for the second band above the neutral zone and '1%' in column H for the second band for the neutral zone. ",{"$nulls":5},{"$f":"'I_State, program, and plan info'!F22","v":0},{"$nulls":4},"Band limit","Band limit","Band limit","Band limit","Band limit"]
[null,"#","Risk corridor bands","Item instructions","Data format","Plan share","State share","Band limit"]
[]
[null,null,"Fifth band above neutral zone","Indicate band information for the fifth band above the neutral zone.","Numeric"]
[null,null,"Fourth band above neutral zone","Indicate band information for the fourth band above the neutral zone.","Numeric"]
[null,null,"Third band above neutral zone","Indicate band information for the third band above the neutral zone.","Numeric"]
[null,null,"Second band above neutral zone","Indicate band information for the second band above the neutral zone.","Numeric"]
[null,null,"First band above neutral zone","Indicate band information for the first band above the neutral zone.","Numeric"]
[null,null,"Neutral zone high","Indicate band information for the upper limit of the neutral zone.","Numeric"]
[null,null,"Neutral zone low","Indicate band information for the lower limit of the neutral zone.","Numeric"]
[null,null,"First band below neutral zone","Indicate band information for the first band below the neutral zone.","Numeric"]
[null,null,"Second band below neutral zone","Indicate band information for the second band below the neutral zone.","Numeric"]
[null,null,"Third band below neutral zone","Indicate band information for the third band below the neutral zone.","Numeric"]
[null,null,"Fourth band below neutral zone","Indicate band information for the fourth band below the neutral zone.","Numeric"]
[null,null,"Fifth band below neutral zone","Indicate band information for the fifth band below the neutral zone.","Numeric"]
[]
[{"$nulls":5},"EXAMPLE"]
[null,"Example","Risk corridor band boundaries as percentage","Item instructions","Example risk corridor bands are displayed in columns F:H. ","Plan share","State share","Band limit"]
[null,null,"Fifth band above neutral zone","Indicate band information for the fifth band above the neutral zone.","Numeric",{"v":0.1,"d":"10%"},{"v":0.9,"d":"90%"},{"v":9.99,"d":"999%"}]
[null,null,"Fourth band above neutral zone","Indicate band information for the fourth band above the neutral zone.","Numeric",{"v":0.15,"d":"15%"},{"v":0.85,"d":"85%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=8,999%,130%),IF($G$9=4,999%,130%))","v":{"v":1.3,"d":"130%"}}]
[null,null,"Third band above neutral zone","Indicate band information for the third band above the neutral zone.","Numeric",{"v":0.2,"d":"20%"},{"v":0.8,"d":"80%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=6,999%,125%),IF($G$9=3,999%,125%))","v":{"v":1.25,"d":"125%"}}]
[null,null,"Second band above neutral zone","Indicate band information for the second band above the neutral zone.","Numeric",{"v":0.25,"d":"25%"},{"v":0.75,"d":"75%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=4,999%,120%),IF($G$9=2,999%,120%))","v":{"v":1.2,"d":"120%"}}]
[null,null,"First band above neutral zone","Indicate band information for the first band above the neutral zone.","Numeric",{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=2,999%,115%),IF($G$9=1,999%,115%))","v":{"v":1.15,"d":"115%"}}]
[null,null,"Neutral zone high","Indicate band information for the upper limit of the neutral zone.","Numeric",{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":1.1,"d":"110%"}]
[null,null,"Neutral zone low","Indicate band information for the lower limit of the neutral zone.","Numeric",{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":0.9,"d":"90%"}]
[null,null,"First band below neutral zone","Indicate band information for the first band below the neutral zone.","Numeric",{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=2,1%,85%),IF($H$9=1,1%,85%))","v":{"v":0.85,"d":"85%"}}]
[null,null,"Second band below neutral zone","Indicate band information for the second band below the neutral zone.","Numeric",{"v":0.25,"d":"25%"},{"v":0.75,"d":"75%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=4,1%,80%),IF($H$9=2,1%,80%))","v":{"v":0.8,"d":"80%"}}]
[null,null,"Third band below neutral zone","Indicate band information for the third band below the neutral zone.","Numeric",{"v":0.2,"d":"20%"},{"v":0.8,"d":"80%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=6,1%,75%),IF($H$9=3,1%,75%))","v":{"v":0.75,"d":"75%"}}]
[null,null,"Fourth band below neutral zone","Indicate band information for the fourth band below the neutral zone.","Numeric",{"v":0.15,"d":"15%"},{"v":0.85,"d":"85%"},{"$f":"IF($F$7=\"Two-Sided Symmetric\",IF($F$9=8,1%,70%),IF($H$9=4,1%,70%))","v":{"v":0.7,"d":"70%"}}]
[null,null,"Fifth band below neutral zone","Indicate band information for the fifth band below the neutral zone.","Numeric",{"v":0.1,"d":"10%"},{"v":0.9,"d":"90%"},{"v":0.01,"d":"1%"}]
[]
[null,"C-F. Risk Corridor Revenue and Expenses by Plan (MLR)"]
[null,"Use this section to report MLR details, including eligible revenue and expenses for the risk corridor. "]
[null,"Please list all revenue and expense for plans participating in: ",null,{"$f":"$F$6","v":0}]
[null,"C. Formula Values for Determining Risk Corridor Results"]
[null,"#","Category","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"II.C.1","MLR denominator","Enter the total plan revenue that is included within the MLR denominator of the risk corridor, expressed in dollars, for the rating period specified in items I.A.12 and I.A.13. This should be consistent with the parameters of the risk corridor and program. Enter the value as positive. For example, if the plan’s revenue included in the MLR calculation for the risk corridor is $100, enter “$100”.","Numeric"]
[null,"II.C.2","MLR target expressed as a percentage","Enter plan’s the MLR target of the risk corridor expressed as a percentage. For example, if the plan’s target MLR for the risk corridor is 87%, enter “87%”.","Percentage"]
[null,"II.C.3","MLR numerator - actual","Enter the plan’s actual MLR numerator for the risk corridor expressed in dollars for the rating period specified in items I.A.12 and I.A.13. For example, if the plan’s numerator for the risk corridor’s MLR calculation is $85, enter “$85”.","Numeric"]
[null,"II.C.4","MLR numerator target","N/A. Do not complete this row. This field multiplies the MLR denominator in II.C.1 and the MLR target expressed as a percentage in II.C.2.","Formula",{"$f":"F153*F154","v":0}]
[null,"II.C.5","Difference between MLR numerator target and MLR numerator actual ","N/A. Do not complete this row. This field calculates the difference between II.C.3 and II.C.4","Formula",{"$f":"F155-F156","v":0}]
[]
[]
[]
[]
[]
[null,"D. Band Boundaries in Dollars"]
[null,"#","Category","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,null,"Fifth band above neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the fifth band of the risk corridor - High","Formula",{"$f":"F$153*H120","v":0}]
[null,null,"Fourth band above neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the fourth band of the risk corridor - High","Formula",0]
[null,null,"Third band above neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the third band of the risk corridor - High","Formula",0]
[null,null,"Second band above neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the second band of the risk corridor - High","Formula",0]
[null,null,"First band above neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the first band of the risk corridor - High","Formula",0]
[null,null,"Neutral zone high","N/A. Do not complete this row. This field calculates the boundary in dollars of the neutral zone of the risk corridor - High","Formula",0]
[null,null,"Neutral zone low","N/A. Do not complete this row. This field calculates the boundary in dollars of the neutral zone of the risk corridor - Low","Formula",0]
[null,null,"First band below neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the first band of the risk corridor -Low","Formula",0]
[null,null,"Second band below neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the second band of the risk corridor -Low","Formula",0]
[null,null,"Third band below neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the third band of the risk corridor -Low","Formula",0]
[null,null,"Fourth band below neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the fourth band of the risk corridor -Low","Formula",0]
[null,null,"Fifth band below neutral zone","N/A. Do not complete this row. This field calculates the boundary in dollars of the fifth band of the risk corridor -Low","Formula",0]
[]
[null,"E. Eligible Expenses by Band",{"$nulls":52},"Plan 1","Plan 2","Plan 3","Plan 4","Plan 5","Plan 6","Plan 7","Plan 8","Plan 9","Plan 10","Plan 11","Plan 12","Plan 13","Plan 14","Plan 15","Plan 16","Plan 17","Plan 18","Plan 19","Plan 20","Plan 21","Plan 22","Plan 23","Plan 24","Plan 25","Plan 26","Plan 27","Plan 28","Plan 29","Plan 30","Plan 31","Plan 32","Plan 33","Plan 34","Plan 35","Plan 36","Plan 37","Plan 38","Plan 39","Plan 40"]
[null,"#","Category","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F22","v":0},{"$nulls":48},"MLR Helper Cells (Plan Band Boundaries in Dollars Minus Total Revenue):",{"$nulls":9},"MLR Helper Cells (Plan Band Boundaries in Dollars Minus Total Revenue):",{"$nulls":9},"MLR Helper Cells (Plan Band Boundaries in Dollars Minus Total Revenue):",{"$nulls":9},"MLR Helper Cells (Plan Band Boundaries in Dollars Minus Total Revenue):"]
[null,null,"Fifth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the fifth band of the risk corridor - High","Formula",{"$f":"IF(H$120>0,IF(F$157-F181-F182-F183-F184-F185>0,F$157-BC180+(BC180-BC181),0),0)","v":0},{"$nulls":47},"Fifth Band Above Neutral Zone",{"$f":"IF(H120>0,F165-F$156,0)","v":0},{"$f":"IF(I120>0,G165-G$156,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Fourth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the fourth band of the risk corridor - High","Formula",{"$f":"IF(H$121>0,IF(F$157-F182-F183-F184-F185>0,IF(H$120>0,IF(F$157>BC181,BC181-BC182,F$157-BC182),F$157-BC181+(BC181-BC182)),0),0)","v":0},{"$nulls":47},"Fourth Band Above Neutral Zone",{"$f":"IF(H121>0,F166-F$156,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Third band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the third band of the risk corridor - High","Formula",{"$f":"IF(H$122>0,IF(F$157-F183-F184-F185>0,IF(H$121>0,IF(F$157>BC182,BC182-BC183,F$157-BC183),F$157-BC182+(BC182-BC183)),0),0)","v":0},{"$nulls":47},"Third Band Above Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Second band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the second band of the risk corridor - High","Formula",{"$f":"IF(H$123>0,IF(F$157-F184-F185>0,IF(H$122>0,IF(F$157>BC183,BC183-BC184,F$157-BC184),F$157-BC183+(BC183-BC184)),0),0)","v":0},{"$nulls":47},"Second Band Above Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"First band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the first band of the risk corridor - High","Formula",{"$f":"IF($H124>0,IF(F$157-F185>0,IF($H123>0,IF(F$157>BC184,BC184-BC185,F$157-BC185),F$157-BC184+(BC184-BC185)),0),0)","v":0},{"$nulls":47},"First Band Above Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Neutral zone high","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the neutral zone of the risk corridor - High","Formula",{"$f":"IF(F$157<=0,0,IF(F$157>=BC185,BC185,F$157))","v":0},{"$nulls":47},"Neutral Zone High",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Neutral zone low","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the neutral zone of the risk corridor - Low","Formula",{"$f":"IF(F$157>=0,0,IF(F$157<=BC186,BC186,F$157))","v":0},{"$nulls":47},"Neutral Zone Low",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AD126>0,AB171-AB$156,0)","v":0},{"$f":"IF(AE126>0,AC171-AC$156,0)","v":0},{"$f":"IF(AF126>0,AD171-AD$156,0)","v":0},{"$f":"IF(AG126>0,AE171-AE$156,0)","v":0},{"$f":"IF(AH126>0,AF171-AF$156,0)","v":0},{"$f":"IF(AI126>0,AG171-AG$156,0)","v":0},{"$f":"IF(AJ126>0,AH171-AH$156,0)","v":0},{"$f":"IF(AK126>0,AI171-AI$156,0)","v":0},{"$f":"IF(AL126>0,AJ171-AJ$156,0)","v":0},{"$f":"IF(AM126>0,AK171-AK$156,0)","v":0},{"$f":"IF(AN126>0,AL171-AL$156,0)","v":0},{"$f":"IF(AO126>0,AM171-AM$156,0)","v":0},{"$f":"IF(AP126>0,AN171-AN$156,0)","v":0},{"$f":"IF(AQ126>0,AO171-AO$156,0)","v":0},{"$f":"IF(AR126>0,AP171-AP$156,0)","v":0},{"$f":"IF(AS126>0,AQ171-AQ$156,0)","v":0},{"$f":"IF(AT126>0,AR171-AR$156,0)","v":0},{"$f":"IF(AU126>0,AS171-AS$156,0)","v":0}]
[null,null,"First band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the first band of the risk corridor -Low","Formula",{"$f":"IF(H$127>0,IF(F$157-F186<0,IF(H$128>0,IF(F$157<BC187,BC187-BC186,F$157-BC186),F$157-BC187+(BC187-BC186)),0),0)","v":0},{"$nulls":47},"First Band Below Neutral Zone",0,{"$f":"IF(I127>0,G172-G$156,0)","v":0},{"$f":"IF(J127>0,H172-H$156,0)","v":0},{"$f":"IF(K127>0,I172-I$156,0)","v":0},{"$f":"IF(L127>0,J172-J$156,0)","v":0},{"$f":"IF(M127>0,K172-K$156,0)","v":0},{"$f":"IF(N127>0,L172-L$156,0)","v":0},{"$f":"IF(O127>0,M172-M$156,0)","v":0},{"$f":"IF(P127>0,N172-N$156,0)","v":0},{"$f":"IF(Q127>0,O172-O$156,0)","v":0},{"$f":"IF(R127>0,P172-P$156,0)","v":0},{"$f":"IF(S127>0,Q172-Q$156,0)","v":0},{"$f":"IF(T127>0,R172-R$156,0)","v":0},{"$f":"IF(U127>0,S172-S$156,0)","v":0},{"$f":"IF(V127>0,T172-T$156,0)","v":0},{"$f":"IF(W127>0,U172-U$156,0)","v":0},{"$f":"IF(X127>0,V172-V$156,0)","v":0},{"$f":"IF(Y127>0,W172-W$156,0)","v":0},{"$f":"IF(Z127>0,X172-X$156,0)","v":0},{"$f":"IF(AA127>0,Y172-Y$156,0)","v":0},{"$f":"IF(AB127>0,Z172-Z$156,0)","v":0},{"$f":"IF(AC127>0,AA172-AA$156,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Second band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the second band of the risk corridor -Low","Formula",{"$f":"IF(H$128>0,IF(F$157-F187-F186<0,IF(H$129>0,IF(F$157<BC188,BC188-BC187,F$157-BC187),F$157-BC188+(BC188-BC187)),0),0)","v":0},{"$nulls":47},"Second Band Below Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Third band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the third band of the risk corridor - High","Formula",{"$f":"IF(H$129>0,IF(F$157-F188-F187-F186<0,IF(H$130>0,IF(F$157<BC189,BC189-BC188,F$157-BC188),F$157-BC189+(BC189-BC188)),0),0)","v":0},{"$nulls":47},"Third Band Below Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Fourth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the fourth band of the risk corridor - High","Formula",{"$f":"IF(H$130>0,IF(F$157-F189-F188-F187-F186<0,IF(H$131>0,IF(F$157<BC190,BC190-BC189,F$157-BC189),F$157-BC190+(BC190-BC189)),0),0)","v":0},{"$nulls":47},"Fourth Band Below Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,"Fifth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of expenses that fall into the fifth band of the risk corridor - High","Formula",{"$f":"IF(H$131>0,IF(F$157-F190-F189-F188-F187-F186<0,F$157-BC191+(BC191-BC190),0),0)","v":0},{"$nulls":47},"Fifth Band Below Neutral Zone",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"Check (Expect Zero Value)",{"$f":"IF($F$7=\"One-Sided\",IF(F157>0,IF(F124>0,F157-SUM(F180:F191),0),IF(F127>0,F157-SUM(F180:F191),0)),F157-SUM(F180:F191))","v":0}]
[null,"F. Share Calculations by Band"]
[null,"#","Category","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,null,"Plan share in fifth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$180*$F$120","v":0}]
[null,null,"State share in fifth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$180*$G$120","v":0}]
[null,null,"Plan share in fourth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$181*$F$121","v":0}]
[null,null,"State share in fourth band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$181*$G$121","v":0}]
[null,null,"Plan share in third band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$182*$F$122","v":0}]
[null,null,"State share in third band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$182*$G$122","v":0}]
[null,null,"Plan share in second band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$183*$F$123","v":0}]
[null,null,"State share in second band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$183*$G$123","v":0}]
[null,null,"Plan share in first band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$184*$F$124","v":0}]
[null,null,"State share in first band above neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$184*$G$124","v":0}]
[null,null,"Plan share in first band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$187*$F$127","v":0}]
[null,null,"State share in first band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$187*$G$127","v":0}]
[null,null,"Plan share in second band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$188*$F$128","v":0}]
[null,null,"State share in second band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$188*$G$128","v":0}]
[null,null,"Plan share in third band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$189*$F$129","v":0}]
[null,null,"State share in third band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$189*$G$129","v":0}]
[null,null,"Plan share in fourth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$190*$F$130","v":0}]
[null,null,"State share in fourth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$190*$G$130","v":0}]
[null,null,"Plan share in fifth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the plan share in the band. ","Formula",{"$f":"F$191*$F$131","v":0}]
[null,null,"State share in fifth band below neutral zone","N/A. Do not complete this row. This field calculates the dollar amount of the state share in the band. ","Formula",{"$f":"F$191*$G$131","v":0}]
[]
[]
[{"$nulls":4},"Check (Expect Zero Value)",{"$f":"F180+F181+F182+F183+F184+F188+F187+F189+F190+F191-SUM(F195:F214)","v":0}]
[null,"G. Risk Corridor Reconciliations "]
[]
[]
[null,"#","Risk corridor reconciliations","Item instructions","Data format",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"II.G.1","Total Reconciliation","N/A. Do not complete this row. Positive Values represent payments to the plan from the Medicaid program. Negative Values represent payments to the Medicaid program from the plan.","Formula",{"$f":"F196+F198+F200+F202+F204+F206+F208+F210+F212+F214","v":0}]
[]
[null,"H. Federal Share of Risk Corridor Reconciliations "]
[null,"#","Risk corridor Reconciliations","Item instructions","Data format","TOTAL"]
[null,"II.H.1","Total Reconciliation - Gross","N/A. Do not complete this row. This is the sum of all reconciliation across plans.","Formula",{"$f":"SUM(F114:AS114)+SUM(F222:AS222)","v":0}]
[null,"II.H.2","Total Reconciliation - Nonfederal Share","Enter the Nonfederal share of the reconciliation payment in this field. II.H.2 and II.H3 should sum to the total gross reconciliation amount included for all plans under II.H.1. If the state has not established the final nonfederal share amount, please provide an estimate.","Numeric"]
[null,"II.H.3","Total Reconciliation - Federal Share","Enter the Federal share of the reconciliation payment in this field. II.H.2 and II.H.3 should sum to the total gross reconciliation amount included for all plans under II.H.1. If the state has not established the final federal share amount, please provide an estimate.","Numeric"]
[null,"II.H.4","Description of Federal Share Allocation","Please describe whether the state has claimed the federal share of the expenditures under II.H.3 under Form 64, and any additional details that may be relevant. For example, if the state has not yet claimed the federal share, please describe the anticipated submission period.","Free Text"]
[]
[null,"Please contact ManagedCareTA@cms.hhs.gov, if the total reconciliation amounts shown in items II.G.1 and II.H.1 is not as expected."]

{"sheet":"Revenue+Exp Storage","index":5,"n_rows":101,"n_cols":4,"rows_kept":101,"hidden":true}
["Programs Revenue Formulas","Programs Revenue Value Only After Macro, Removed Dup","Programs Expense Formulas","Programs Expense Value Only After Macro, Removed Dup"]
[{"$f":"TRIM((TRANSPOSE(II_Reconciliation!BB7:BK7)))","v":""},"Rev A",{"$f":"TRIM((TRANSPOSE(II_Reconciliation!BB18:BK18)))","v":""},"Exp A"]
["","B","","B"]
["","C","","C"]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
["",null,""]
{"$rows_empty":10}
[{"$f":"TRIM((TRANSPOSE(II_Reconciliation!AA9:AJ9)))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"TRIM((TRANSPOSE(II_Reconciliation!AA10:AJ10)))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"TRIM((TRANSPOSE(II_Reconciliation!AA11:AJ11)))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"TRIM((TRANSPOSE(II_Reconciliation!AA12:AJ12)))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"TRIM((TRANSPOSE(II_Reconciliation!AA13:AJ13)))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
{"$rows_empty":20}
[null,null,{"$f":"TRIM(TRANSPOSE(II_Reconciliation!BD30:BM30))","v":""}]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"III_Plan Rev Exp Detailed (Mo)","index":6,"n_rows":59,"n_cols":3,"rows_kept":59,"hidden":true,"merged":[[3,1,3,7]]}
["Column A is blank. All information begins in column B, row 2."]
[null,"III. Detailed Plan Revenue and Expenses (Mo)"]
[null,"A. Monthly Plan Revenue and Expenses"]
[null,"States should use this section to report a monthly breakdown of plan revenue and expenses for each plan included in the risk corridor. Please enter both revenue and expenses as positive numbers. This is the last required item in this workbook.\n\nThe data format for all data entry fields in this tab (including the required rows 8-19 and the required rows 26-37) is numeric. \n\nAfter completing Tab II, states must click 'Proceed to Tab III' (row 233 in Tab II) in order for Tab III to work correctly."]
[]
[null,"Revenue"]
[null,"Enter the plan's total revenue eligible under the risk corridor for each month of the rating period that the state is reporting on. ",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"Month 1"]
[null,"Month 2"]
[null,"Month 3"]
[null,"Month 4"]
[null,"Month 5"]
[null,"Month 6"]
[null,"Month 7"]
[null,"Month 8"]
[null,"Month 9"]
[null,"Month 10"]
[null,"Month 11"]
[null,"Month 12"," "]
[null,"Annual revenue. Do not complete this row. ",{"$f":"SUM(C8:C19)","v":0}]
[null,"Annual revenue reported in Tab II. Do not complete this row. ",{"$f":"IF(II_Reconciliation!$F$10=\"Target Ratio\",II_Reconciliation!F$51,II_Reconciliation!F$153)","v":0}]
[null,"Difference from annual revenue reported in Tab II. Do not complete this row. ",{"$f":"C20-C21","v":0}]
[]
[null,"Expense"]
[null,"Enter the plan's total expenses eligible under the risk corridor for each month of the rating period that the state is reporting on. ",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"Month 1"]
[null,"Month 2"]
[null,"Month 3"]
[null,"Month 4"]
[null,"Month 5"]
[null,"Month 6"]
[null,"Month 7"]
[null,"Month 8"]
[null,"Month 9"]
[null,"Month 10"]
[null,"Month 11"]
[null,"Month 12"]
[null,"Annual expenses. Do not complete this row. ",{"$f":"SUM(C26:C37)","v":0}]
[null,"Annual expenses reported in Tab II. Do not complete this row. ",{"$f":"IF(II_Reconciliation!$F$10=\"Target Ratio\",II_Reconciliation!F$52,II_Reconciliation!F$155)","v":0}]
[null,"Difference from annual expenses reported in Tab II. Do not complete this row. ",{"$f":"C38-C39","v":0}]
[]
[null,"B. Revenue Sources by Plan (Annual) - Optional"]
[null,"States should use this section of the tab to report by the revenue sources they identified and entered in II.A.5. This section is optional. If you provided revenue sources, please enter the revenue by source in the table below."]
[]
[null,null,{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"Revenue source #1"]
[null,"Total annual revenue. Do not complete this row. ",{"$f":"SUM(C46:C46)","v":0}]
[null,"Annual revenue reported in Tab II. Do not complete this row. ",{"$f":"IF(II_Reconciliation!$F$10=\"Target Ratio\",II_Reconciliation!F$51,II_Reconciliation!F$153)","v":0}]
[null,"Difference from annual revenue reported in Tab II. Do not complete this row. ",{"$f":"C47-C48","v":0}]
[]
[null,"C. Expense Sources by Plan (Annual) - Optional"]
[null,"States should use this section of the tab to report by the expense sources they identified and entered in II.A.6. This section is optional. If you provided expense sources, please enter the expense by source in the table below."]
[]
[null,null,{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"Expense source #1"]
[null,"Total annual expenses. Do not complete this row. ",{"$f":"SUM(C55:C55)","v":0}]
[null,"Annual expenses reported in Tab II. Do not complete this row. ",{"$f":"IF(II_Reconciliation!$F$10=\"Target Ratio\",II_Reconciliation!F$52,II_Reconciliation!F$155)","v":0}]
[null,"Difference from annual expenses reported in Tab II. Do not complete this row. ",{"$f":"C56-C57","v":0}]
[null,"End of worksheet"]

{"sheet":"III_Plan Rev Exp Detailed (Qt)","index":7,"n_rows":43,"n_cols":3,"rows_kept":43,"hidden":true,"merged":[[3,1,3,7]]}
["Column A is blank. All information begins in column B, row 2."]
[null,"III. Detailed Plan Revenue and Expenses (Qt)"]
[null,"A. Quarterly Plan Revenue and Expenses"]
[null,"States should use this section to report a quarterly breakdown of plan revenue and expenses for each plan included in the risk corridor. Please enter both revenue and expenses as positive numbers. This is the last required item in this workbook.\n\nThe data format for all data entry fields in this tab (including the required rows 8-11 and the required rows 18-21) is numeric. \n\nAfter completing Tab II, states must click 'Proceed to Tab III' (row 233 in Tab II) in order for Tab III to work correctly."]
[]
[null,"Revenue"]
[null,"Enter the plan's total revenue eligible under the risk corridor for each quarter of the rating period that the state is reporting on. ",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"Quarter 1"]
[null,"Quarter 2"]
[null,"Quarter 3"]
[null,"Quarter 4"]
[null,"Total annual revenue. Do not complete this row. ",{"$f":"SUM(C8:C11)","v":0}]
[null,"Annual revenue reported in Tab II. Do not complete this row. ",{"$f":"IF(II_Reconciliation!$F$10=\"Target Ratio\",II_Reconciliation!F$51,II_Reconciliation!F$153)","v":0}]
[null,"Difference from annual revenue reported in Tab II. Do not complete this row. ",{"$f":"C12-C13","v":0}]
[]
[null,"Expense"]
[null,"Enter the plan's total expenses eligible under the risk corridor for each quarter of the rating period that the state is reporting on. ",{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"Quarter 1"]
[null,"Quarter 2"]
[null,"Quarter 3"]
[null,"Quarter 4"]
[null,"Total annual expenses. Do not complete this row. ",{"$f":"SUM(C18:C21)","v":0}]
[null,"Annual expenses reported in Tab II. Do not complete this row. ",{"$f":"IF(II_Reconciliation!$F$10=\"Target Ratio\",II_Reconciliation!F$52,II_Reconciliation!F$155)","v":0}]
[null,"Difference from annual expenses reported in Tab II. Do not complete this row. ",{"$f":"C22-C23","v":0}]
[]
[null,"B. Revenue Sources by Plan (Annual) - Optional"]
[null,"States may use this section of the tab to report by the revenue sources they identified and entered in II.A.5. This section is optional."]
[]
[null,null,{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"Revenue source #1"]
[null,"Total annual revenue. Do not complete this row. ",{"$f":"SUM(C30:C30)","v":0}]
[null,"Annual revenue reported in Tab II. Do not complete this row. ",{"$f":"IF(II_Reconciliation!$F$10=\"Target Ratio\",II_Reconciliation!F$51,II_Reconciliation!F$153)","v":0}]
[null,"Difference from annual revenue reported in Tab II. Do not complete this row. ",{"$f":"C31-C32","v":0}]
[]
[null,"C. Expense Sources by Plan (Annual) - Optional"]
[null,"States should use this section of the tab to report by the expense sources they identified and entered in II.A.6. This section is optional."]
[]
[null,null,{"$f":"'I_State, program, and plan info'!F22","v":0}]
[null,"Expense source #1"]
[null,"Total annual expenses. Do not complete this row. ",{"$f":"SUM(C39:C39)","v":0}]
[null,"Annual expenses reported in Tab II. Do not complete this row. ",{"$f":"IF(II_Reconciliation!$F$10=\"Target Ratio\",II_Reconciliation!F$52,II_Reconciliation!F$155)","v":0}]
[null,"Difference from annual expenses reported in Tab II. Do not complete this row. ",{"$f":"C40-C41","v":0}]
[null,"End of worksheet"]