{"text_format":"3","workbook":"xlsx","n_sheets":18,"sheets":["General Instructions","Audited Financial Requirements","Plan Benefit Packages (PBP)","Changes","Index","County Grouping Table","Jurat","DSNP Rev-Exp Instructions","DSNP Rev-Exp Summary","StartSum","DSNP Rev-Exp Rest of Florida","DSNP Rev-Exp Region 9","DSNP Rev-Exp Region 10","DSNP Rev-Exp Region 11","EndSum","DSNP Admin Summary","DSNP Subcap Summary","Notes"],"not_rendered":{"images":1,"macros":1,"defined_names":19,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"General Instructions","index":0,"n_rows":52,"n_cols":2,"rows_kept":52,"merged":[[5,0,10,14],[13,1,15,14],[17,1,18,14],[20,1,26,14],[28,1,30,14],[32,1,34,14],[36,1,38,14],[41,1,42,14],[45,1,46,14],[48,1,49,14],[51,1,52,14]]}
["DUAL SPECIAL NEEDS PLAN (DSNP)"]
["FINANCIAL REPORT - GENERAL INSTRUCTIONS"]
["This template contains predetermined formulas in certain cells which are locked by the Agency. Please only fill out the cells shadowed in light blue color in each tab."]
[]
["Annual DSNP Financial Report"]
["Annual DSNP Financial Reports are due to the Agency by July 1st following the end of the reporting calendar year, allowing for three months of runout.  However, the first DSNP Financial Report is due to the Agency on January 4, 2019 for the calendar year 2017 reporting period, with claims paid through March 31. Effective with the calendar year 2019 reporting period, the Annual DSNP Financial Report is required to be examined by an independent certified public accountant. If a DSNP Plan’s revenue or medical expense across the State of Florida during the calendar year is less than $250,000, the Agency will waive the examination requirement for the plan and the plan will just submit an unaudited report. Refer to the Audited Financial Requirements tab for more detailed instructions."]
[]
[]
[]
[]
[]
[]
["General Instructions"]
["1.","Revenue and expenses should be reported using Generally Accepted Accounting Principles (GAAP). Amounts reported shall only include revenue and expenses for Medicaid covered services and Medicare Cost Sharing that is covered by Medicaid provided to dual eligible members who are enrolled in a Medicare Advantage DSNP Plan at the time of service."]
[]
[]
[]
["2.","Enrolled DSNP eligible members consist of QMB, QMB Plus, SLMB, SLMB Plus, QI, QDWI, and FBDE. This report only captures enrolled DSNP eligible members that receive a capitation rate as defined below in 3."]
[]
[]
["3.","This report is split into two populations, members who receive the QMB capitation rate (defined as QMB only members) and members who receive the Full Dual capitation rate (defined as QMB Plus, SLMB Plus, and FBDE members). All other DSNP eligible members are not captured in this report. In order to determine the eligibility type, the plan should refer to the “Medicaid Dual Status Code” field of their plan specific Monthly Membership Report (MMR) file provided by Centers for Medicare & Medicaid Services (CMS). The plan should use CMS designated flags displayed in their MMRs to designate between eligibility types. QMB only members are designated a value of 01 in the “Medicaid Dual Status Code” field, while Full Duals are designated a value of 02, 04, 08, or 10. For definitions of the field categories please refer to the Centers for Medicare & Medicaid Service's Plan Communication User Guide for Medicare Advantage Prescription Drug Plans."]
{"$rows_empty":7}
["4.","\"Medicaid Only\" refers to costs attributable to Medicaid for services only covered by Medicaid. These costs are only associated with Full Dual eligible members, as these members are eligible for full Medicaid benefits. These are costs for benefits that would not be paid by Medicare, but rather are exclusive benefits to the MMA program (i.e. behavioral health, hospice facility costs, adult dental, home health)."]
[]
[]
[]
["5.","\"Medicare Cost Sharing\" refers to costs attributable to Medicaid when Medicare is the primary payer (i.e. hospital, physician, pharmacy services).This includes all deductibles, copays, and coinsurance amounts attributable to the individual member that are covered by Medicaid for dual eligibles. This cost sharing may also be referred to as Medicare crossover services."]
[]
[]
[]
["6.","The Plan shall enter the number of Plan Benefit Packages (PBP) that the Plan offers to Medicaid recipients it serves under the DSNP contract held with the Agency in the \"Plan Benefit Packages (PBP)\" tab. This tab will populate the template with the correct number of \"DSNP Rev-Exp Rest of Florida\", \"DSNP Rev-Exp Region 9\",  \"DSNP Rev-Exp Region 10\", and \"DSNP Rev-Exp Region 11\" tabs that the Plan will be required to submit at a PBP level."]
[]
[]
[]
["7.","DSNP Administative Expense Schedule"]
[null,"The Plan shall report all administrative expenses on an aggregate plan level divided by Region 9, Region 10, Region 11, and Rest of Florida, as defined in \"County Grouping Table\" tab."]
[]
[]
["8.","DSNP Subcapitation Schedules"]
[null,"For each type of service that the DSNP Plan subcapitates with another entity to provide, the five vendors with the highest total paid shall be listed individually, with all others combined for that type of service. The Plan should report the subcapitation schedule at an aggregrated plan level."]
[]
[]
["9.","The Plan shall submit reports that are specific to the operations of the Plan and the Plan's specified PBP rather than to a parent or umbrella organization."]
[]
[]
["10.","Refer to the Instructions tabs for the DSNP Revenue and Expense Schedule for more detailed instructions listing the type of revenue or expense to be reported on each line of the reports.  "]

{"sheet":"Audited Financial Requirements","index":1,"n_rows":36,"n_cols":2,"rows_kept":36,"merged":[[4,0,9,14],[12,1,13,14],[15,1,15,15],[17,1,20,14],[23,1,23,15],[25,1,25,15],[27,1,27,15],[30,1,32,14],[35,1,36,14]]}
["DUAL SPECIAL NEEDS PLAN (DSNP)"]
["FINANCIAL REPORT - AUDITED FINANCIAL REQUIREMENTS"]
[]
["Annual Audited DSNP Financial Report"]
["Effective with the calendar year 2019 reporting period, the Annual DSNP Financial Report is required to be examined by an independent certified public accountant. The Plan shall contract with independent certified public accountants to perform an Examination in accordance with Attestation standards, including but not limited to: annual premium revenue, medical and administrative costs, and income or losses reported by each prepaid plan. The Annual Audited DSNP Financial Report submission will require 4 items to be submitted: an Attestation, Examination, Jurat, and the Annual Audited DSNP Financial Report. Annual Audited DSNP Financial Report submission are due to the Agency by September 15th following the end of the reporting calendar year."]
[]
[]
[]
[]
[]
[]
["Attestation"]
["1.","The Attestation must be on the plan’s letterhead, signed by the official referenced on the Attestation itself, and it must include the official’s specific title. The official can consist of the CEO, CFO, State President, or an equivalent title."]
[]
[]
["2.","The Attestation submitted by the Managed Care Plan must list the name(s) and reporting period(s) of the report(s) being submitted. "]
[]
["3.","The Attestation must use the following naming convention: “FPXXXYYYYMMDDA”, where FPXXX stands for the Agency contract number, YYYY stands for the four-digit year in which the report(s) are being submitted, MM stands for the two-digit month in which the report(s) are being submitted, DD stands for the two-digit day on which the report/Attestation is submitted to the Agency, and A stands for the Attestation. If multiple batches of reports and Attestations are submitted in one day, a two-digit numeric indicator will be added after the “A”."]
[]
[]
[]
[]
["Examination Report"]
["1.","The Examination shall be completed by the independent third party auditors."]
[]
["2.","The Examination Report shall be a PDF document printed on the audit firm's letter head, and contain the auditors' opinion."]
[]
["3.","A copy of the corrected/approved DSNP Rev-Exp Summary tab must be included in the Examination Report PDF."]
[]
["Jurat"]
["1.","The Jurat page must be submitted as a PDF file and named DSNP-FPXXYYYY-Jurat.pdf where FPXX is the Agency contract number, and YYYY are the four digits of the calendar year being reported. This jurat page must be signed only by the Managed Care Plan’s CEO. Delegate signatures will not be accepted. "]
[]
[]
[]
["Annual Audited DSNP Financial Report"]
["1.","The Annual Audited DSNP Financial Report shall be submitted in Excel format and contain any corrections outlined by the independent auditor."]

{"sheet":"Plan Benefit Packages (PBP)","index":2,"n_rows":17,"n_cols":3,"rows_kept":17}
["DUAL SPECIAL NEEDS PLAN (DSNP) - Plan Benefit Packages (PBP)"]
[]
["Instructions:  In the yellow fields below, please enter the number of Plan Benefit Packages (PBP) that the Plan offers to Medicaid recipients it serves under the DSNP contract held with the Agency.  Please divide by Rest of Florida, Region 9, Region 10, "]
["                           and Region 11, as defined in \"County Grouping Table\" tab. After entering the correct number of PBPs, press the \"Populate Template with PBPs\" button to populate the template with the correct number of "]
["                          \"DSNP Rev-Exp Rest of Florida\", \"DSNP Rev-Exp Region 9\", \"DSNP Rev-Exp Region 10\" , and \"DSNP Rev-Exp Region 11\" tabs that the Plan will be required to submit at a PBP level. "]
["                           Once PBP sheets are populated, please add the correct PBP identifier in cell C4 of each sheet that aligns with the Plan's financials."]
[]
["1.)","# of Plan Benefit Packages (PBP) - Rest of Florida",0]
[]
[]
["2.)","# of Plan Benefit Packages (PBP) - Region 9",0]
[]
["3.)","# of Plan Benefit Packages (PBP) - Region 10",0]
[]
["4.)","# of Plan Benefit Packages (PBP) - Region 11",0]
[]
["3.)"]

{"sheet":"Changes","index":3,"n_rows":8,"n_cols":3,"rows_kept":8}
["DSNP FINANCIAL REPORT - CHANGE LOG"]
[]
["Current Version:",null,"DSNP Financial Report Template_09142023 version"]
["Previous Version:",null,"DSNP Financial Report_08292023"]
[]
["Changes effective September 2023 with the current version:"]
["1. Replaced \"South Florida\" tabs with \"Region 9\", \"Region 10\", and \"Region 11\" tabs when populating new tabs due to regions split;"]
["2. Updated all relevant tabs to replace \"South Florida\" with \"Region 9\", \"Region 10\", and \"Region 11\"."]

{"sheet":"Index","index":4,"n_rows":18,"n_cols":3,"rows_kept":18}
["DSNP REVENUE AND EXPENSE STATEMENT - INDEX"]
[]
[]
["Section","Tab Name","Description"]
["General","General Instructions","Provides general instructions for the completion of the DSNP Revenue and Expense Statement.  Additional instructions can be found on the schedule-specific instructions."]
["General","Plan Benefit Packages (PBP)","Populates the template with the correct number of  \"DSNP Rev-Exp Rest of Florida\", \"DSNP Rev-Exp Region 9\",  \"DSNP Rev-Exp Region 10\", and \"DSNP Rev-Exp Region 11\"  tabs that the Plan will be required to submit at a PBP level."]
["General","Index","Listing of all tabs contained within the DSNP Revenue and Expense Statement."]
["General","County Grouping Table","Table 1 describes how the plan should separate the counties by Rest of Florida, Region 9, Region 10, and Region 11."]
["General","Jurat","Jurat Page."]
["DSNP","DSNP Rev-Exp Instructions","Detailed instructions for completion of the DSNP Rev-Exp Schedules."]
["DSNP","DSNP Rev-Exp - Summary","Summary of DSNP data reported on the DSNP Rev-Exp Regional Schedules."]
["DSNP","DSNP Rev-Exp - Rest of Florida - ##","DSNP Revenue and Expense information for Rest of Florida"]
["DSNP","DSNP Rev-Exp - Region 9 - ##","DSNP Revenue and Expense information for Region 9."]
["DSNP","DSNP Rev-Exp - Region 10 - ##","DSNP Revenue and Expense information for Region 10."]
["DSNP","DSNP Rev-Exp - Region 11 - ##","DSNP Revenue and Expense information for Region 11."]
["DSNP","DSNP Admin Summary","Summary of Administrative Expense for the DSNP Plan."]
["DSNP","DSNP Subcap Summary","Summary of Subcapitated DSNP data."]
["Notes","Notes","Notes section."]

{"sheet":"County Grouping Table","index":5,"n_rows":16,"n_cols":4,"rows_kept":16,"merged":[[1,1,1,3],[2,1,2,3],[3,1,3,3],[5,1,12,1],[13,1,15,1]]}
[]
[null,"Table 1"]
[null,"Dual Special Needs Plan Program"]
[null,"Grouping by County"]
[null,"Group","Region","Counties"]
[null,"Rest of Florida",1,"Escambia, Okaloosa, Santa Rosa, and Walton"]
[null,null,2,"Bay, Calhoun, Franklin, Gadsden, Gulf, Holmes, Jackson, Jefferson, Leon, Liberty, Madison, Taylor, Wakulla, and Washington"]
[null,null,3,"Alachua, Bradford, Citrus, Columbia, Dixie, Gilchrist, Hamilton, Hernando, Lafayette, Lake, Levy, Marion, Putnam, Sumter, Suwannee, and Union"]
[null,null,4,"Baker, Clay, Duval, Flagler, Nassau, St. Johns, and Volusia"]
[null,null,5,"Pasco and Pinellas"]
[null,null,6,"Hardee, Highlands, Hillsborough, Manatee, and Polk"]
[null,null,7,"Brevard, Orange, Osceola, and Seminole"]
[null,null,8,"Charlotte, Collier, DeSoto, Glades, Hendry, Lee, and Sarasota"]
[null,"South Florida",9,"Indian River, Martin, Okeechobee, Palm Beach, and St. Lucie"]
[null,null,10,"Broward"]
[null,null,11,"Miami-Dade and Monroe"]

{"sheet":"Jurat","index":6,"n_rows":40,"n_cols":8,"rows_kept":40,"merged":[[0,2,0,5],[1,2,1,6],[2,2,2,5],[3,2,3,6],[3,7,3,8],[4,2,4,5],[5,2,5,6],[7,2,7,4],[10,2,10,4],[11,2,11,6],[12,2,12,6],[13,2,13,5],[15,1,15,2],[15,4,15,7],[16,1,16,2],[16,4,16,7],[17,1,17,2],[17,4,17,7],[18,1,18,2],[18,4,18,7],[19,1,19,2],[19,4,19,7],[20,1,20,2],[20,4,20,7],[21,1,21,2],[21,4,21,7],[22,1,22,2],[22,4,22,7],[23,1,23,2],[23,4,23,7],[24,1,24,2],[24,4,24,7],[27,2,27,6],[32,3,32,4]]}
[null,null,"HEALTH PLAN NAME"]
[]
[null,null,"ADDRESS"]
[{"$nulls":7},"(street, city, zip)"]
[null,null,"PARENT COMPANY NAME"]
[]
[]
[null,"CONTACT PERSON:"]
[null,"TELEPHONE:"]
[null,"FAX:"]
[null,"E-MAIL ADDRESS:"]
[null,null,"PRESIDENT, C.E.O."]
[]
[null,null,"OFFICERS AND DIRECTORS"]
[null,"Name:",null,null,"Title:"]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
[]
[]
[null,null,"Company Filing Status:      (1) For-Profit     (2) Not-For-Profit"]
[]
[]
[]
[{"$nulls":3},"FOR THE YEAR ENDING"]
[]
[]
[null,"-----------------------------------------------------------------------------"]
[null,"CEO/PRESIDENT'S SIGNATURE "]
[]
[null,"AUTHORITY GRANTED BY :"]
[null,"AGENCY FOR HEALTH CARE ADMINISTRATION  "]
[null," "]

{"sheet":"DSNP Rev-Exp Instructions","index":7,"n_rows":90,"n_cols":4,"rows_kept":90,"merged":[[13,0,13,2],[14,0,15,2],[14,3,15,3],[16,0,18,0],[19,0,20,2],[19,3,20,3],[21,0,67,0],[68,0,71,0],[72,0,72,2],[73,0,79,0],[80,0,85,0]]}
["DUAL SPECIAL NEEDS PLAN REVENUE AND EXPENSE SCHEDULE - INSTRUCTIONS"]
["ANNUAL"]
[]
["Coverage:","Reported for DSNP experience, by region and by eligibility group. Summary report aggregates all contracted regions."]
["Reporting Period:"]
["August 1","Annual Revenue & Expense Schedule includes quarters 1-4 of prior calendar year, all paid through March."]
[]
["Health Plan:","Name or D/B/A of the reporting managed care plan."]
["PBP Identifier:","Specific Plan Benefit Package (PBP) ID"]
["Reporting Period:","Based upon the reporting periods identified above."]
["Paid Through:","Based on the paid through timeframes identified above."]
["Region:","Applicable only for Regional reports."]
[]
["MEMBER MONTHS",null,null,"Number of members enrolled in each month.  Year-to-Date is the sum of the member months over the individual months of the period."]
["REVENUES"]
[]
["Revenues","1.1","Capitation","Monthly premium payments earned on behalf of Medicaid recipients "]
[null,"1.2","Other Revenue","Plan-related revenue earned from other sources not listed in line 1.1. -- does not include investment gains.  Report details of this income, including the type and amount, in the notes section of this report."]
[null,"1.3","Total Revenue","Sum of lines 1.1 and 1.2 (Direct business, not increased for reinsurance assumed and not reduced by reinsurance ceded)"]
["BENEFIT EXPENSES"]
[]
["Benefit Expenses","2.01","Inpatient Facility","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.02","Skilled Nursing Facility","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.03","Home Health","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.04","Ambulance","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.05","DME/Prosthetics/Diabetes FFS","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.06","DME/Prosthetics/Diabetes Subcapitation","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.07","OP Facility - Emergency","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.08","OP Facility - Surgery","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.09","OP Facility - Other","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.10","Hospital Services Subcapitation","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.11","Mental Health FFS (excluding codes H2017, H2030, & T1017)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.11.1","Mental Health FFS (only codes H2017, H2030, & T1017)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.12","Mental Health Subcapitation","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.13","Professional FFS - Primary Care","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.14","Professional FFS - Specialty Care","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.15","Professional FFS - Other Professional","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.16","Professional Services Subcapitation - Primary Care","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.17","Professional Services Subcapitation - Specialty Care","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.18","Professional Services Subcapitation - Other Professional","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.19","Part B Rx FFS","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.20","Pharmacy Subcapitation","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.21","OTC Pharmacy Subcapitation","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.22","Other Medicare Part B","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.23","Transportation FFS (Non-Covered)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.24","Transportation Subcapitation (Non-Covered)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.25","Dental FFS (Non-Covered)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.26","Dental Subcapitation (Non-Covered)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.27","Vision FFS (Non-Covered)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.28","Vision Subcapitation (Non-Covered)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.29","Hearing FFS (Non-Covered)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.30","Hearing Subcapitation (Non-Covered)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.31","Suppl. Ben. Chpt 4 (Non-Covered)","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.32","Other Non-Covered FFS","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.33","Other Non-Covered Subcapitation","See the Centers for Medicare & Medicaid Services (CMS) Bid Pricing Tool (BPT) instructions for covered service descriptions."]
[null,"2.34","COB/Subrg. (outside claim system)","Expenses incurred for Subcapitated payments to providers for Medicaid covered services."]
[null,"2.35","Other Medicaid Expenses","Other Medicaid expenses not included in lines 2.01 through 2.34."]
[null,"2.36","Ending IBNP for Inpatient Hospital Services","Estimated amount for Inpatient Hospital Services incurred but not paid (IBNP).  Amounts should be \"Best Estimate\" and should not include margin or LAE. "]
[null,"2.37","Ending IBNP for Outpatient Hospital Services","Estimated amount for Outpatient Hospital Services incurred but not paid (IBNP).  Amounts should be \"Best Estimate\" and should not include margin or LAE. "]
[null,"2.38","Ending IBNP for Mental Health & Substance Abuse","Estimated amount for MH & SA Services incurred but not paid (IBNP).  Amounts should be \"Best Estimate\" and should not include margin or LAE. "]
[null,"2.39","Ending IBNP for Professional Services","Estimated amount for Professional Services incurred but not paid (IBNP).  Amounts should be \"Best Estimate\" and should not include margin or LAE. "]
[null,"2.40","Ending IBNP for Prescription Drugs","Estimated amount for Prescription Drugs incurred but not paid (IBNP).  Amounts should be \"Best Estimate\" and should not include margin or LAE. "]
[null,"2.41","Ending IBNP for Transportation","Estimated amount for Transportation Services incurred but not paid (IBNP).  Amounts should be \"Best Estimate\" and should not include margin or LAE. "]
[null,"2.42","Ending IBNP for Dental Services","Estimated amount for Dental Services incurred but not paid (IBNP).  Amounts should be \"Best Estimate\" and should not include margin or LAE. "]
[null,"2.43","Ending IBNP for Vision Services","Estimated amount for Vision Services incurred but not paid (IBNP).  Amounts should be \"Best Estimate\" and should not include margin or LAE. "]
[null,"2.44","Ending IBNP for Hearing Services","Estimated amount for Hearing Services incurred but not paid (IBNP).  Amounts should be \"Best Estimate\" and should not include margin or LAE. "]
[null,"2.45","Ending IBNP for Other Services","Estimated amount for Other Services incurred but not paid (IBNP).  Amounts should be \"Best Estimate\" and should not include margin or LAE. "]
[null,"2.46","Subtotal Benefit Expense before Reinsurance","Sum of lines 2.01 through 2.45."]
["Totals After Reinsurance","3.1","Reinsurance Premiums","Amounts incurred by plans to authorized companies assuming risk."]
[null,"3.2","Reinsurance Recoveries","Amounts recovered and changes in accrued amounts recoverable from reinsurers on paid losses and on losses included in IBNP.  Reported as a negative amount."]
[null,"3.3","Net cost of Reinsurance","Sum of Line 3.1 and line 3.2"]
[null,"3.4","Grand Total Medical Benefit Expense Net of Reinsurance","Sum of line 2.36 plus line 3.3"]
["Administrative Expenses, Government-Mandated Assessments, Taxes, and Fees "]
["Administrative Expenses","4.1","Salaries & Benefits","Direct salary, benefit, and payroll tax expenses.  Reported separately for direct health plan expenses and corporate allocations."]
[null,"4.2","Administrative Services","Non-salary/benefit-related expenses for accounting, actuarial, risk management, legal, investment services, underwriting, etc.  Includes payments to parent company or other contracted entities.  Reported separately for direct health plan expenses and corporate allocations."]
[null,"4.3","Information Systems","Claims processing, pharmacy benefits management, and other information systems expenses.  Includes payments to parent company or contracted entities.  Reported separately for direct health plan expenses and corporate allocations."]
[null,"4.4","Marketing Expenses","Market research, marketing campaigns/advertising, public relations.  Reported separately for direct health plan expenses and corporate allocations."]
[null,"4.5","General  Administration","Direct & Allocated overhead, rent, utilities, supplies, insurance, and other operating expenses not specifically identified in lines 4.1 through 4.4.  Reported separately for direct health plan expenses and corporate allocations."]
[null,"4.6","Compliance/Regulatory","Expenses associated with fines, penalties, liquidated damages, or other compliance matters as identified/levied by governmental or other regulatory entities.  Reported separately for direct health plan expenses and corporate allocations."]
[null,"4.7","Total Administrative Expenses ","Sum of lines 4.1 through 4.6"]
["Government-Mandated Assessments, Taxes, and Fees Other Than Income Taxes","5.1","State Premium tax","Amounts paid or payable on premium revenue in 1.3"]
[null,"5.2","Department of Insurance Assessments","Amounts paid or payable related to premium revenue in 1.3"]
[null,"5.3","Other 1","Additional assessments, taxes, and fees not reported on lines 5.1 through 5.2, as needed.  Additional information to be provided in the Notes section."]
[null,"5.4","Other 2","Additional assessments, taxes, and fees not reported on lines 5.1 through 5.2, as needed.  Additional information to be provided in the Notes section."]
[null,"5.5","Other 3","Additional assessments, taxes, and fees not reported on lines 5.1 through 5.2, as needed.  Additional information to be provided in the Notes section."]
[null,"5.6","Total ","Sum of lines 5.1 through 5.5"]
[null,"6","Grand Total Expenses","Sum of lines 3.4 and 4.7 and 5.6"]
[null,"7","Underwriting Gain / (Loss)  --- AKA Pre-tax Earnings from Operations","Line 1.3 minus line 6"]
[null,"8","Income Tax Expense","Domestic federal, state, and local taxes based on income from operations. "]
[null,"9","Net Underwriting Gain (Loss) from Operations","Line 7 minus line 8"]

{"sheet":"DSNP Rev-Exp Summary","index":8,"n_rows":85,"n_cols":23,"rows_kept":85,"merged":[[6,3,6,6],[6,7,6,10],[6,11,6,14],[6,15,6,18],[6,19,6,22],[7,5,7,6],[7,9,7,10],[7,13,7,14],[7,17,7,18],[7,21,7,22],[8,5,8,6],[8,9,8,10],[8,13,8,14],[8,17,8,18],[8,21,8,22],[9,0,9,2],[9,5,9,6],[9,9,9,10],[9,13,9,14],[9,17,9,18],[9,21,9,22],[10,0,12,0],[10,5,10,6],[10,9,10,10],[10,13,10,14],[10,17,10,18],[10,21,10,22],[11,5,11,6],[11,9,11,10],[11,13,11,14],[11,17,11,18],[11,21,11,22],[12,5,12,6],[12,9,12,10],[12,13,12,14],[12,17,12,18],[12,21,12,22],[13,0,14,2],[13,3,13,6],[13,7,13,10],[13,11,13,14],[13,15,13,18],[13,19,13,22],[15,0,61,0],[62,0,65,0],[66,0,67,2],[66,3,66,6],[66,7,66,10],[66,11,66,14],[66,15,66,18],[66,19,66,22],[68,0,74,0],[75,0,80,0]]}
["DUAL SPECIAL NEEDS PLAN -- REVENUE AND EXPENSE SCHEDULE - SUMMARY"]
[]
["Health Plan:"]
["Reporting Period:"]
["Paid Through:"]
["Statewide"]
[{"$nulls":3},"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual"]
["MEMBER MONTHS",null,null,{"$f":"SUM(E9:G9)","v":0},{"$f":"SUM(StartSum:EndSum!E10)","v":0},{"$f":"SUM(StartSum:EndSum!F10)","v":0},null,{"$f":"SUM(I9:K9)","v":0},{"$f":"SUM(StartSum:EndSum!I10)","v":0},{"$f":"SUM(StartSum:EndSum!J10)","v":0},null,{"$f":"SUM(M9:O9)","v":0},{"$f":"SUM(StartSum:EndSum!M10)","v":0},{"$f":"SUM(StartSum:EndSum!N10)","v":0},null,{"$f":"SUM(Q9:S9)","v":0},{"$f":"SUM(StartSum:EndSum!Q10)","v":0},{"$f":"SUM(StartSum:EndSum!R10)","v":0},null,{"$f":"SUM(U9:W9)","v":0},{"$f":"SUM(StartSum:EndSum!U10)","v":0},{"$f":"SUM(StartSum:EndSum!V10)","v":0}]
["REVENUES"]
["Revenues",1.1,"Capitation",{"$f":"SUM(E11:G11)","v":0},{"$f":"SUM(StartSum:EndSum!E12)","v":0},{"$f":"SUM(StartSum:EndSum!F12)","v":0},null,{"$f":"SUM(I11:K11)","v":0},{"$f":"SUM(StartSum:EndSum!I12)","v":0},{"$f":"SUM(StartSum:EndSum!J12)","v":0},null,{"$f":"SUM(M11:O11)","v":0},{"$f":"SUM(StartSum:EndSum!M12)","v":0},{"$f":"SUM(StartSum:EndSum!N12)","v":0},null,{"$f":"SUM(Q11:S11)","v":0},{"$f":"SUM(StartSum:EndSum!Q12)","v":0},{"$f":"SUM(StartSum:EndSum!R12)","v":0},null,{"$f":"SUM(U11:W11)","v":0},{"$f":"SUM(StartSum:EndSum!U12)","v":0},{"$f":"SUM(StartSum:EndSum!V12)","v":0}]
[null,"1.2","Other Revenue",{"$f":"SUM(E12:G12)","v":0},{"$f":"SUM(StartSum:EndSum!E13)","v":0},{"$f":"SUM(StartSum:EndSum!F13)","v":0},null,{"$f":"SUM(I12:K12)","v":0},{"$f":"SUM(StartSum:EndSum!I13)","v":0},{"$f":"SUM(StartSum:EndSum!J13)","v":0},null,{"$f":"SUM(M12:O12)","v":0},{"$f":"SUM(StartSum:EndSum!M13)","v":0},{"$f":"SUM(StartSum:EndSum!N13)","v":0},null,{"$f":"SUM(Q12:S12)","v":0},{"$f":"SUM(StartSum:EndSum!Q13)","v":0},{"$f":"SUM(StartSum:EndSum!R13)","v":0},null,{"$f":"SUM(U12:W12)","v":0},{"$f":"SUM(StartSum:EndSum!U13)","v":0},{"$f":"SUM(StartSum:EndSum!V13)","v":0}]
[null,"1.3","Total Revenue",{"$f":"SUM(E13:G13)","v":0},{"$f":"SUM(StartSum:EndSum!E14)","v":0},{"$f":"SUM(StartSum:EndSum!F14)","v":0},null,{"$f":"SUM(I13:K13)","v":0},{"$f":"SUM(StartSum:EndSum!I14)","v":0},{"$f":"SUM(StartSum:EndSum!J14)","v":0},null,{"$f":"SUM(M13:O13)","v":0},{"$f":"SUM(StartSum:EndSum!M14)","v":0},{"$f":"SUM(StartSum:EndSum!N14)","v":0},null,{"$f":"SUM(Q13:S13)","v":0},{"$f":"SUM(StartSum:EndSum!Q14)","v":0},{"$f":"SUM(StartSum:EndSum!R14)","v":0},null,{"$f":"SUM(U13:W13)","v":0},{"$f":"SUM(StartSum:EndSum!U14)","v":0},{"$f":"SUM(StartSum:EndSum!V14)","v":0}]
["BENEFIT EXPENSES",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only"]
["Benefit Expenses","2.01","Inpatient Facility",{"$f":"SUM(E16:G16)","v":0},{"$f":"SUM(StartSum:EndSum!E17)","v":0},{"$f":"SUM(StartSum:EndSum!F17)","v":0},{"$f":"SUM(StartSum:EndSum!G17)","v":0},{"$f":"SUM(I16:K16)","v":0},{"$f":"SUM(StartSum:EndSum!I17)","v":0},{"$f":"SUM(StartSum:EndSum!J17)","v":0},{"$f":"SUM(StartSum:EndSum!K17)","v":0},{"$f":"SUM(M16:O16)","v":0},{"$f":"SUM(StartSum:EndSum!M17)","v":0},{"$f":"SUM(StartSum:EndSum!N17)","v":0},{"$f":"SUM(StartSum:EndSum!O17)","v":0},{"$f":"SUM(Q16:S16)","v":0},{"$f":"SUM(StartSum:EndSum!Q17)","v":0},{"$f":"SUM(StartSum:EndSum!R17)","v":0},{"$f":"SUM(StartSum:EndSum!S17)","v":0},{"$f":"SUM(U16:W16)","v":0},{"$f":"SUM(StartSum:EndSum!U17)","v":0},{"$f":"SUM(StartSum:EndSum!V17)","v":0},{"$f":"SUM(StartSum:EndSum!W17)","v":0}]
[null,"2.02","Skilled Nursing Facility",{"$f":"SUM(E17:G17)","v":0},{"$f":"SUM(StartSum:EndSum!E18)","v":0},{"$f":"SUM(StartSum:EndSum!F18)","v":0},{"$f":"SUM(StartSum:EndSum!G18)","v":0},{"$f":"SUM(I17:K17)","v":0},{"$f":"SUM(StartSum:EndSum!I18)","v":0},{"$f":"SUM(StartSum:EndSum!J18)","v":0},{"$f":"SUM(StartSum:EndSum!K18)","v":0},{"$f":"SUM(M17:O17)","v":0},{"$f":"SUM(StartSum:EndSum!M18)","v":0},{"$f":"SUM(StartSum:EndSum!N18)","v":0},{"$f":"SUM(StartSum:EndSum!O18)","v":0},{"$f":"SUM(Q17:S17)","v":0},{"$f":"SUM(StartSum:EndSum!Q18)","v":0},{"$f":"SUM(StartSum:EndSum!R18)","v":0},{"$f":"SUM(StartSum:EndSum!S18)","v":0},{"$f":"SUM(U17:W17)","v":0},{"$f":"SUM(StartSum:EndSum!U18)","v":0},{"$f":"SUM(StartSum:EndSum!V18)","v":0},{"$f":"SUM(StartSum:EndSum!W18)","v":0}]
[null,"2.03","Home Health",{"$f":"SUM(E18:G18)","v":0},{"$f":"SUM(StartSum:EndSum!E19)","v":0},{"$f":"SUM(StartSum:EndSum!F19)","v":0},{"$f":"SUM(StartSum:EndSum!G19)","v":0},{"$f":"SUM(I18:K18)","v":0},{"$f":"SUM(StartSum:EndSum!I19)","v":0},{"$f":"SUM(StartSum:EndSum!J19)","v":0},{"$f":"SUM(StartSum:EndSum!K19)","v":0},{"$f":"SUM(M18:O18)","v":0},{"$f":"SUM(StartSum:EndSum!M19)","v":0},{"$f":"SUM(StartSum:EndSum!N19)","v":0},{"$f":"SUM(StartSum:EndSum!O19)","v":0},{"$f":"SUM(Q18:S18)","v":0},{"$f":"SUM(StartSum:EndSum!Q19)","v":0},{"$f":"SUM(StartSum:EndSum!R19)","v":0},{"$f":"SUM(StartSum:EndSum!S19)","v":0},{"$f":"SUM(U18:W18)","v":0},{"$f":"SUM(StartSum:EndSum!U19)","v":0},{"$f":"SUM(StartSum:EndSum!V19)","v":0},{"$f":"SUM(StartSum:EndSum!W19)","v":0}]
[null,"2.04","Ambulance",0,{"$f":"SUM(StartSum:EndSum!E20)","v":0},{"$f":"SUM(StartSum:EndSum!F20)","v":0},{"$f":"SUM(StartSum:EndSum!G20)","v":0},0,{"$f":"SUM(StartSum:EndSum!I20)","v":0},{"$f":"SUM(StartSum:EndSum!J20)","v":0},{"$f":"SUM(StartSum:EndSum!K20)","v":0},0,{"$f":"SUM(StartSum:EndSum!M20)","v":0},{"$f":"SUM(StartSum:EndSum!N20)","v":0},{"$f":"SUM(StartSum:EndSum!O20)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q20)","v":0},{"$f":"SUM(StartSum:EndSum!R20)","v":0},{"$f":"SUM(StartSum:EndSum!S20)","v":0},0,{"$f":"SUM(StartSum:EndSum!U20)","v":0},{"$f":"SUM(StartSum:EndSum!V20)","v":0},{"$f":"SUM(StartSum:EndSum!W20)","v":0}]
[null,"2.05","DME/Prosthetics/Diabetes FFS",0,{"$f":"SUM(StartSum:EndSum!E21)","v":0},{"$f":"SUM(StartSum:EndSum!F21)","v":0},{"$f":"SUM(StartSum:EndSum!G21)","v":0},0,{"$f":"SUM(StartSum:EndSum!I21)","v":0},{"$f":"SUM(StartSum:EndSum!J21)","v":0},{"$f":"SUM(StartSum:EndSum!K21)","v":0},0,{"$f":"SUM(StartSum:EndSum!M21)","v":0},{"$f":"SUM(StartSum:EndSum!N21)","v":0},{"$f":"SUM(StartSum:EndSum!O21)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q21)","v":0},{"$f":"SUM(StartSum:EndSum!R21)","v":0},{"$f":"SUM(StartSum:EndSum!S21)","v":0},0,{"$f":"SUM(StartSum:EndSum!U21)","v":0},{"$f":"SUM(StartSum:EndSum!V21)","v":0},{"$f":"SUM(StartSum:EndSum!W21)","v":0}]
[null,"2.06","DME/Prosthetics/Diabetes Subcapitation",0,{"$f":"SUM(StartSum:EndSum!E22)","v":0},{"$f":"SUM(StartSum:EndSum!F22)","v":0},{"$f":"SUM(StartSum:EndSum!G22)","v":0},0,{"$f":"SUM(StartSum:EndSum!I22)","v":0},{"$f":"SUM(StartSum:EndSum!J22)","v":0},{"$f":"SUM(StartSum:EndSum!K22)","v":0},0,{"$f":"SUM(StartSum:EndSum!M22)","v":0},{"$f":"SUM(StartSum:EndSum!N22)","v":0},{"$f":"SUM(StartSum:EndSum!O22)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q22)","v":0},{"$f":"SUM(StartSum:EndSum!R22)","v":0},{"$f":"SUM(StartSum:EndSum!S22)","v":0},0,{"$f":"SUM(StartSum:EndSum!U22)","v":0},{"$f":"SUM(StartSum:EndSum!V22)","v":0},{"$f":"SUM(StartSum:EndSum!W22)","v":0}]
[null,"2.07","OP Facility - Emergency",0,{"$f":"SUM(StartSum:EndSum!E23)","v":0},{"$f":"SUM(StartSum:EndSum!F23)","v":0},{"$f":"SUM(StartSum:EndSum!G23)","v":0},0,{"$f":"SUM(StartSum:EndSum!I23)","v":0},{"$f":"SUM(StartSum:EndSum!J23)","v":0},{"$f":"SUM(StartSum:EndSum!K23)","v":0},0,{"$f":"SUM(StartSum:EndSum!M23)","v":0},{"$f":"SUM(StartSum:EndSum!N23)","v":0},{"$f":"SUM(StartSum:EndSum!O23)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q23)","v":0},{"$f":"SUM(StartSum:EndSum!R23)","v":0},{"$f":"SUM(StartSum:EndSum!S23)","v":0},0,{"$f":"SUM(StartSum:EndSum!U23)","v":0},{"$f":"SUM(StartSum:EndSum!V23)","v":0},{"$f":"SUM(StartSum:EndSum!W23)","v":0}]
[null,"2.08","OP Facility - Surgery",0,{"$f":"SUM(StartSum:EndSum!E24)","v":0},{"$f":"SUM(StartSum:EndSum!F24)","v":0},{"$f":"SUM(StartSum:EndSum!G24)","v":0},0,{"$f":"SUM(StartSum:EndSum!I24)","v":0},{"$f":"SUM(StartSum:EndSum!J24)","v":0},{"$f":"SUM(StartSum:EndSum!K24)","v":0},0,{"$f":"SUM(StartSum:EndSum!M24)","v":0},{"$f":"SUM(StartSum:EndSum!N24)","v":0},{"$f":"SUM(StartSum:EndSum!O24)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q24)","v":0},{"$f":"SUM(StartSum:EndSum!R24)","v":0},{"$f":"SUM(StartSum:EndSum!S24)","v":0},0,{"$f":"SUM(StartSum:EndSum!U24)","v":0},{"$f":"SUM(StartSum:EndSum!V24)","v":0},{"$f":"SUM(StartSum:EndSum!W24)","v":0}]
[null,"2.09","OP Facility - Other",0,{"$f":"SUM(StartSum:EndSum!E25)","v":0},{"$f":"SUM(StartSum:EndSum!F25)","v":0},{"$f":"SUM(StartSum:EndSum!G25)","v":0},0,{"$f":"SUM(StartSum:EndSum!I25)","v":0},{"$f":"SUM(StartSum:EndSum!J25)","v":0},{"$f":"SUM(StartSum:EndSum!K25)","v":0},0,{"$f":"SUM(StartSum:EndSum!M25)","v":0},{"$f":"SUM(StartSum:EndSum!N25)","v":0},{"$f":"SUM(StartSum:EndSum!O25)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q25)","v":0},{"$f":"SUM(StartSum:EndSum!R25)","v":0},{"$f":"SUM(StartSum:EndSum!S25)","v":0},0,{"$f":"SUM(StartSum:EndSum!U25)","v":0},{"$f":"SUM(StartSum:EndSum!V25)","v":0},{"$f":"SUM(StartSum:EndSum!W25)","v":0}]
[null,"2.10","Hospital Services Subcapitation",0,{"$f":"SUM(StartSum:EndSum!E26)","v":0},{"$f":"SUM(StartSum:EndSum!F26)","v":0},{"$f":"SUM(StartSum:EndSum!G26)","v":0},0,{"$f":"SUM(StartSum:EndSum!I26)","v":0},{"$f":"SUM(StartSum:EndSum!J26)","v":0},{"$f":"SUM(StartSum:EndSum!K26)","v":0},0,{"$f":"SUM(StartSum:EndSum!M26)","v":0},{"$f":"SUM(StartSum:EndSum!N26)","v":0},{"$f":"SUM(StartSum:EndSum!O26)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q26)","v":0},{"$f":"SUM(StartSum:EndSum!R26)","v":0},{"$f":"SUM(StartSum:EndSum!S26)","v":0},0,{"$f":"SUM(StartSum:EndSum!U26)","v":0},{"$f":"SUM(StartSum:EndSum!V26)","v":0},{"$f":"SUM(StartSum:EndSum!W26)","v":0}]
[null,"2.11","Mental Health FFS (excluding H2017, H2030, T1017)",0,{"$f":"SUM(StartSum:EndSum!E27)","v":0},{"$f":"SUM(StartSum:EndSum!F27)","v":0},{"$f":"SUM(StartSum:EndSum!G27)","v":0},0,{"$f":"SUM(StartSum:EndSum!I27)","v":0},{"$f":"SUM(StartSum:EndSum!J27)","v":0},{"$f":"SUM(StartSum:EndSum!K27)","v":0},0,{"$f":"SUM(StartSum:EndSum!M27)","v":0},{"$f":"SUM(StartSum:EndSum!N27)","v":0},{"$f":"SUM(StartSum:EndSum!O27)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q27)","v":0},{"$f":"SUM(StartSum:EndSum!R27)","v":0},{"$f":"SUM(StartSum:EndSum!S27)","v":0},0,{"$f":"SUM(StartSum:EndSum!U27)","v":0},{"$f":"SUM(StartSum:EndSum!V27)","v":0},{"$f":"SUM(StartSum:EndSum!W27)","v":0}]
[null,"2.11.1","Mental Health FFS (only codes H2017, H2030, & T1017)",{"$f":"SUM(E27:G27)","v":0},{"$f":"SUM(StartSum:EndSum!E28)","v":0},{"$f":"SUM(StartSum:EndSum!F28)","v":0},{"$f":"SUM(StartSum:EndSum!G28)","v":0},{"$f":"SUM(I27:K27)","v":0},{"$f":"SUM(StartSum:EndSum!I28)","v":0},{"$f":"SUM(StartSum:EndSum!J28)","v":0},{"$f":"SUM(StartSum:EndSum!K28)","v":0},{"$f":"SUM(M27:O27)","v":0},{"$f":"SUM(StartSum:EndSum!M28)","v":0},{"$f":"SUM(StartSum:EndSum!N28)","v":0},{"$f":"SUM(StartSum:EndSum!O28)","v":0},{"$f":"SUM(Q27:S27)","v":0},{"$f":"SUM(StartSum:EndSum!Q28)","v":0},{"$f":"SUM(StartSum:EndSum!R28)","v":0},{"$f":"SUM(StartSum:EndSum!S28)","v":0},{"$f":"SUM(U27:W27)","v":0},{"$f":"SUM(StartSum:EndSum!U28)","v":0},{"$f":"SUM(StartSum:EndSum!V28)","v":0},{"$f":"SUM(StartSum:EndSum!W28)","v":0}]
[null,"2.12","Mental Health Subcapitation",0,{"$f":"SUM(StartSum:EndSum!E29)","v":0},{"$f":"SUM(StartSum:EndSum!F29)","v":0},{"$f":"SUM(StartSum:EndSum!G29)","v":0},0,{"$f":"SUM(StartSum:EndSum!I29)","v":0},{"$f":"SUM(StartSum:EndSum!J29)","v":0},{"$f":"SUM(StartSum:EndSum!K29)","v":0},0,{"$f":"SUM(StartSum:EndSum!M29)","v":0},{"$f":"SUM(StartSum:EndSum!N29)","v":0},{"$f":"SUM(StartSum:EndSum!O29)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q29)","v":0},{"$f":"SUM(StartSum:EndSum!R29)","v":0},{"$f":"SUM(StartSum:EndSum!S29)","v":0},0,{"$f":"SUM(StartSum:EndSum!U29)","v":0},{"$f":"SUM(StartSum:EndSum!V29)","v":0},{"$f":"SUM(StartSum:EndSum!W29)","v":0}]
[null,"2.13","Professional FFS - Primary Care",0,{"$f":"SUM(StartSum:EndSum!E30)","v":0},{"$f":"SUM(StartSum:EndSum!F30)","v":0},{"$f":"SUM(StartSum:EndSum!G30)","v":0},0,{"$f":"SUM(StartSum:EndSum!I30)","v":0},{"$f":"SUM(StartSum:EndSum!J30)","v":0},{"$f":"SUM(StartSum:EndSum!K30)","v":0},0,{"$f":"SUM(StartSum:EndSum!M30)","v":0},{"$f":"SUM(StartSum:EndSum!N30)","v":0},{"$f":"SUM(StartSum:EndSum!O30)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q30)","v":0},{"$f":"SUM(StartSum:EndSum!R30)","v":0},{"$f":"SUM(StartSum:EndSum!S30)","v":0},0,{"$f":"SUM(StartSum:EndSum!U30)","v":0},{"$f":"SUM(StartSum:EndSum!V30)","v":0},{"$f":"SUM(StartSum:EndSum!W30)","v":0}]
[null,"2.14","Professional FFS - Specialty Care",0,{"$f":"SUM(StartSum:EndSum!E31)","v":0},{"$f":"SUM(StartSum:EndSum!F31)","v":0},{"$f":"SUM(StartSum:EndSum!G31)","v":0},0,{"$f":"SUM(StartSum:EndSum!I31)","v":0},{"$f":"SUM(StartSum:EndSum!J31)","v":0},{"$f":"SUM(StartSum:EndSum!K31)","v":0},0,{"$f":"SUM(StartSum:EndSum!M31)","v":0},{"$f":"SUM(StartSum:EndSum!N31)","v":0},{"$f":"SUM(StartSum:EndSum!O31)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q31)","v":0},{"$f":"SUM(StartSum:EndSum!R31)","v":0},{"$f":"SUM(StartSum:EndSum!S31)","v":0},0,{"$f":"SUM(StartSum:EndSum!U31)","v":0},{"$f":"SUM(StartSum:EndSum!V31)","v":0},{"$f":"SUM(StartSum:EndSum!W31)","v":0}]
[null,"2.15","Professional FFS - Other Professional",0,{"$f":"SUM(StartSum:EndSum!E32)","v":0},{"$f":"SUM(StartSum:EndSum!F32)","v":0},{"$f":"SUM(StartSum:EndSum!G32)","v":0},0,{"$f":"SUM(StartSum:EndSum!I32)","v":0},{"$f":"SUM(StartSum:EndSum!J32)","v":0},{"$f":"SUM(StartSum:EndSum!K32)","v":0},0,{"$f":"SUM(StartSum:EndSum!M32)","v":0},{"$f":"SUM(StartSum:EndSum!N32)","v":0},{"$f":"SUM(StartSum:EndSum!O32)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q32)","v":0},{"$f":"SUM(StartSum:EndSum!R32)","v":0},{"$f":"SUM(StartSum:EndSum!S32)","v":0},0,{"$f":"SUM(StartSum:EndSum!U32)","v":0},{"$f":"SUM(StartSum:EndSum!V32)","v":0},{"$f":"SUM(StartSum:EndSum!W32)","v":0}]
[null,"2.16","Professional Services Subcapitation - Primary Care",0,{"$f":"SUM(StartSum:EndSum!E33)","v":0},{"$f":"SUM(StartSum:EndSum!F33)","v":0},{"$f":"SUM(StartSum:EndSum!G33)","v":0},0,{"$f":"SUM(StartSum:EndSum!I33)","v":0},{"$f":"SUM(StartSum:EndSum!J33)","v":0},{"$f":"SUM(StartSum:EndSum!K33)","v":0},0,{"$f":"SUM(StartSum:EndSum!M33)","v":0},{"$f":"SUM(StartSum:EndSum!N33)","v":0},{"$f":"SUM(StartSum:EndSum!O33)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q33)","v":0},{"$f":"SUM(StartSum:EndSum!R33)","v":0},{"$f":"SUM(StartSum:EndSum!S33)","v":0},0,{"$f":"SUM(StartSum:EndSum!U33)","v":0},{"$f":"SUM(StartSum:EndSum!V33)","v":0},{"$f":"SUM(StartSum:EndSum!W33)","v":0}]
[null,"2.17","Professional Services Subcapitation - Specialty Care",0,{"$f":"SUM(StartSum:EndSum!E34)","v":0},{"$f":"SUM(StartSum:EndSum!F34)","v":0},{"$f":"SUM(StartSum:EndSum!G34)","v":0},0,{"$f":"SUM(StartSum:EndSum!I34)","v":0},{"$f":"SUM(StartSum:EndSum!J34)","v":0},{"$f":"SUM(StartSum:EndSum!K34)","v":0},0,{"$f":"SUM(StartSum:EndSum!M34)","v":0},{"$f":"SUM(StartSum:EndSum!N34)","v":0},{"$f":"SUM(StartSum:EndSum!O34)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q34)","v":0},{"$f":"SUM(StartSum:EndSum!R34)","v":0},{"$f":"SUM(StartSum:EndSum!S34)","v":0},0,{"$f":"SUM(StartSum:EndSum!U34)","v":0},{"$f":"SUM(StartSum:EndSum!V34)","v":0},{"$f":"SUM(StartSum:EndSum!W34)","v":0}]
[null,"2.18","Professional Services Subcapitation - Other Professional",0,{"$f":"SUM(StartSum:EndSum!E35)","v":0},{"$f":"SUM(StartSum:EndSum!F35)","v":0},{"$f":"SUM(StartSum:EndSum!G35)","v":0},0,{"$f":"SUM(StartSum:EndSum!I35)","v":0},{"$f":"SUM(StartSum:EndSum!J35)","v":0},{"$f":"SUM(StartSum:EndSum!K35)","v":0},0,{"$f":"SUM(StartSum:EndSum!M35)","v":0},{"$f":"SUM(StartSum:EndSum!N35)","v":0},{"$f":"SUM(StartSum:EndSum!O35)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q35)","v":0},{"$f":"SUM(StartSum:EndSum!R35)","v":0},{"$f":"SUM(StartSum:EndSum!S35)","v":0},0,{"$f":"SUM(StartSum:EndSum!U35)","v":0},{"$f":"SUM(StartSum:EndSum!V35)","v":0},{"$f":"SUM(StartSum:EndSum!W35)","v":0}]
[null,"2.19","Part B Rx FFS",0,{"$f":"SUM(StartSum:EndSum!E36)","v":0},{"$f":"SUM(StartSum:EndSum!F36)","v":0},{"$f":"SUM(StartSum:EndSum!G36)","v":0},0,{"$f":"SUM(StartSum:EndSum!I36)","v":0},{"$f":"SUM(StartSum:EndSum!J36)","v":0},{"$f":"SUM(StartSum:EndSum!K36)","v":0},0,{"$f":"SUM(StartSum:EndSum!M36)","v":0},{"$f":"SUM(StartSum:EndSum!N36)","v":0},{"$f":"SUM(StartSum:EndSum!O36)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q36)","v":0},{"$f":"SUM(StartSum:EndSum!R36)","v":0},{"$f":"SUM(StartSum:EndSum!S36)","v":0},0,{"$f":"SUM(StartSum:EndSum!U36)","v":0},{"$f":"SUM(StartSum:EndSum!V36)","v":0},{"$f":"SUM(StartSum:EndSum!W36)","v":0}]
[null,"2.20","Pharmacy Subcapitation",0,{"$f":"SUM(StartSum:EndSum!E37)","v":0},{"$f":"SUM(StartSum:EndSum!F37)","v":0},{"$f":"SUM(StartSum:EndSum!G37)","v":0},0,{"$f":"SUM(StartSum:EndSum!I37)","v":0},{"$f":"SUM(StartSum:EndSum!J37)","v":0},{"$f":"SUM(StartSum:EndSum!K37)","v":0},0,{"$f":"SUM(StartSum:EndSum!M37)","v":0},{"$f":"SUM(StartSum:EndSum!N37)","v":0},{"$f":"SUM(StartSum:EndSum!O37)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q37)","v":0},{"$f":"SUM(StartSum:EndSum!R37)","v":0},{"$f":"SUM(StartSum:EndSum!S37)","v":0},0,{"$f":"SUM(StartSum:EndSum!U37)","v":0},{"$f":"SUM(StartSum:EndSum!V37)","v":0},{"$f":"SUM(StartSum:EndSum!W37)","v":0}]
[null,"2.21","OTC Pharmacy Subcapitation",0,{"$f":"SUM(StartSum:EndSum!E38)","v":0},{"$f":"SUM(StartSum:EndSum!F38)","v":0},{"$f":"SUM(StartSum:EndSum!G38)","v":0},0,{"$f":"SUM(StartSum:EndSum!I38)","v":0},{"$f":"SUM(StartSum:EndSum!J38)","v":0},{"$f":"SUM(StartSum:EndSum!K38)","v":0},0,{"$f":"SUM(StartSum:EndSum!M38)","v":0},{"$f":"SUM(StartSum:EndSum!N38)","v":0},{"$f":"SUM(StartSum:EndSum!O38)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q38)","v":0},{"$f":"SUM(StartSum:EndSum!R38)","v":0},{"$f":"SUM(StartSum:EndSum!S38)","v":0},0,{"$f":"SUM(StartSum:EndSum!U38)","v":0},{"$f":"SUM(StartSum:EndSum!V38)","v":0},{"$f":"SUM(StartSum:EndSum!W38)","v":0}]
[null,"2.22","Other Medicare Part B",0,{"$f":"SUM(StartSum:EndSum!E39)","v":0},{"$f":"SUM(StartSum:EndSum!F39)","v":0},{"$f":"SUM(StartSum:EndSum!G39)","v":0},0,{"$f":"SUM(StartSum:EndSum!I39)","v":0},{"$f":"SUM(StartSum:EndSum!J39)","v":0},{"$f":"SUM(StartSum:EndSum!K39)","v":0},0,{"$f":"SUM(StartSum:EndSum!M39)","v":0},{"$f":"SUM(StartSum:EndSum!N39)","v":0},{"$f":"SUM(StartSum:EndSum!O39)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q39)","v":0},{"$f":"SUM(StartSum:EndSum!R39)","v":0},{"$f":"SUM(StartSum:EndSum!S39)","v":0},0,{"$f":"SUM(StartSum:EndSum!U39)","v":0},{"$f":"SUM(StartSum:EndSum!V39)","v":0},{"$f":"SUM(StartSum:EndSum!W39)","v":0}]
[null,"2.23","Transportation FFS (Non-Covered)",0,{"$f":"SUM(StartSum:EndSum!E40)","v":0},{"$f":"SUM(StartSum:EndSum!F40)","v":0},{"$f":"SUM(StartSum:EndSum!G40)","v":0},0,{"$f":"SUM(StartSum:EndSum!I40)","v":0},{"$f":"SUM(StartSum:EndSum!J40)","v":0},{"$f":"SUM(StartSum:EndSum!K40)","v":0},0,{"$f":"SUM(StartSum:EndSum!M40)","v":0},{"$f":"SUM(StartSum:EndSum!N40)","v":0},{"$f":"SUM(StartSum:EndSum!O40)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q40)","v":0},{"$f":"SUM(StartSum:EndSum!R40)","v":0},{"$f":"SUM(StartSum:EndSum!S40)","v":0},0,{"$f":"SUM(StartSum:EndSum!U40)","v":0},{"$f":"SUM(StartSum:EndSum!V40)","v":0},{"$f":"SUM(StartSum:EndSum!W40)","v":0}]
[null,"2.24","Transportation Subcapitation (Non-Covered)",0,{"$f":"SUM(StartSum:EndSum!E41)","v":0},{"$f":"SUM(StartSum:EndSum!F41)","v":0},{"$f":"SUM(StartSum:EndSum!G41)","v":0},0,{"$f":"SUM(StartSum:EndSum!I41)","v":0},{"$f":"SUM(StartSum:EndSum!J41)","v":0},{"$f":"SUM(StartSum:EndSum!K41)","v":0},0,{"$f":"SUM(StartSum:EndSum!M41)","v":0},{"$f":"SUM(StartSum:EndSum!N41)","v":0},{"$f":"SUM(StartSum:EndSum!O41)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q41)","v":0},{"$f":"SUM(StartSum:EndSum!R41)","v":0},{"$f":"SUM(StartSum:EndSum!S41)","v":0},0,{"$f":"SUM(StartSum:EndSum!U41)","v":0},{"$f":"SUM(StartSum:EndSum!V41)","v":0},{"$f":"SUM(StartSum:EndSum!W41)","v":0}]
[null,"2.25","Dental FFS (Non-Covered)",0,{"$f":"SUM(StartSum:EndSum!E42)","v":0},{"$f":"SUM(StartSum:EndSum!F42)","v":0},{"$f":"SUM(StartSum:EndSum!G42)","v":0},0,{"$f":"SUM(StartSum:EndSum!I42)","v":0},{"$f":"SUM(StartSum:EndSum!J42)","v":0},{"$f":"SUM(StartSum:EndSum!K42)","v":0},0,{"$f":"SUM(StartSum:EndSum!M42)","v":0},{"$f":"SUM(StartSum:EndSum!N42)","v":0},{"$f":"SUM(StartSum:EndSum!O42)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q42)","v":0},{"$f":"SUM(StartSum:EndSum!R42)","v":0},{"$f":"SUM(StartSum:EndSum!S42)","v":0},0,{"$f":"SUM(StartSum:EndSum!U42)","v":0},{"$f":"SUM(StartSum:EndSum!V42)","v":0},{"$f":"SUM(StartSum:EndSum!W42)","v":0}]
[null,"2.26","Dental Subcapitation (Non-Covered)",0,{"$f":"SUM(StartSum:EndSum!E43)","v":0},{"$f":"SUM(StartSum:EndSum!F43)","v":0},{"$f":"SUM(StartSum:EndSum!G43)","v":0},0,{"$f":"SUM(StartSum:EndSum!I43)","v":0},{"$f":"SUM(StartSum:EndSum!J43)","v":0},{"$f":"SUM(StartSum:EndSum!K43)","v":0},0,{"$f":"SUM(StartSum:EndSum!M43)","v":0},{"$f":"SUM(StartSum:EndSum!N43)","v":0},{"$f":"SUM(StartSum:EndSum!O43)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q43)","v":0},{"$f":"SUM(StartSum:EndSum!R43)","v":0},{"$f":"SUM(StartSum:EndSum!S43)","v":0},0,{"$f":"SUM(StartSum:EndSum!U43)","v":0},{"$f":"SUM(StartSum:EndSum!V43)","v":0},{"$f":"SUM(StartSum:EndSum!W43)","v":0}]
[null,"2.27","Vision FFS (Non-Covered)",0,{"$f":"SUM(StartSum:EndSum!E44)","v":0},{"$f":"SUM(StartSum:EndSum!F44)","v":0},{"$f":"SUM(StartSum:EndSum!G44)","v":0},0,{"$f":"SUM(StartSum:EndSum!I44)","v":0},{"$f":"SUM(StartSum:EndSum!J44)","v":0},{"$f":"SUM(StartSum:EndSum!K44)","v":0},0,{"$f":"SUM(StartSum:EndSum!M44)","v":0},{"$f":"SUM(StartSum:EndSum!N44)","v":0},{"$f":"SUM(StartSum:EndSum!O44)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q44)","v":0},{"$f":"SUM(StartSum:EndSum!R44)","v":0},{"$f":"SUM(StartSum:EndSum!S44)","v":0},0,{"$f":"SUM(StartSum:EndSum!U44)","v":0},{"$f":"SUM(StartSum:EndSum!V44)","v":0},{"$f":"SUM(StartSum:EndSum!W44)","v":0}]
[null,"2.28","Vision Subcapitation (Non-Covered)",0,{"$f":"SUM(StartSum:EndSum!E45)","v":0},{"$f":"SUM(StartSum:EndSum!F45)","v":0},{"$f":"SUM(StartSum:EndSum!G45)","v":0},0,{"$f":"SUM(StartSum:EndSum!I45)","v":0},{"$f":"SUM(StartSum:EndSum!J45)","v":0},{"$f":"SUM(StartSum:EndSum!K45)","v":0},0,{"$f":"SUM(StartSum:EndSum!M45)","v":0},{"$f":"SUM(StartSum:EndSum!N45)","v":0},{"$f":"SUM(StartSum:EndSum!O45)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q45)","v":0},{"$f":"SUM(StartSum:EndSum!R45)","v":0},{"$f":"SUM(StartSum:EndSum!S45)","v":0},0,{"$f":"SUM(StartSum:EndSum!U45)","v":0},{"$f":"SUM(StartSum:EndSum!V45)","v":0},{"$f":"SUM(StartSum:EndSum!W45)","v":0}]
[null,"2.29","Hearing FFS (Non-Covered)",0,{"$f":"SUM(StartSum:EndSum!E46)","v":0},{"$f":"SUM(StartSum:EndSum!F46)","v":0},{"$f":"SUM(StartSum:EndSum!G46)","v":0},0,{"$f":"SUM(StartSum:EndSum!I46)","v":0},{"$f":"SUM(StartSum:EndSum!J46)","v":0},{"$f":"SUM(StartSum:EndSum!K46)","v":0},0,{"$f":"SUM(StartSum:EndSum!M46)","v":0},{"$f":"SUM(StartSum:EndSum!N46)","v":0},{"$f":"SUM(StartSum:EndSum!O46)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q46)","v":0},{"$f":"SUM(StartSum:EndSum!R46)","v":0},{"$f":"SUM(StartSum:EndSum!S46)","v":0},0,{"$f":"SUM(StartSum:EndSum!U46)","v":0},{"$f":"SUM(StartSum:EndSum!V46)","v":0},{"$f":"SUM(StartSum:EndSum!W46)","v":0}]
[null,"2.30","Hearing Subcapitation (Non-Covered)",0,{"$f":"SUM(StartSum:EndSum!E47)","v":0},{"$f":"SUM(StartSum:EndSum!F47)","v":0},{"$f":"SUM(StartSum:EndSum!G47)","v":0},0,{"$f":"SUM(StartSum:EndSum!I47)","v":0},{"$f":"SUM(StartSum:EndSum!J47)","v":0},{"$f":"SUM(StartSum:EndSum!K47)","v":0},0,{"$f":"SUM(StartSum:EndSum!M47)","v":0},{"$f":"SUM(StartSum:EndSum!N47)","v":0},{"$f":"SUM(StartSum:EndSum!O47)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q47)","v":0},{"$f":"SUM(StartSum:EndSum!R47)","v":0},{"$f":"SUM(StartSum:EndSum!S47)","v":0},0,{"$f":"SUM(StartSum:EndSum!U47)","v":0},{"$f":"SUM(StartSum:EndSum!V47)","v":0},{"$f":"SUM(StartSum:EndSum!W47)","v":0}]
[null,"2.31","Suppl. Ben. Chpt 4 (Non-Covered)",0,{"$f":"SUM(StartSum:EndSum!E48)","v":0},{"$f":"SUM(StartSum:EndSum!F48)","v":0},{"$f":"SUM(StartSum:EndSum!G48)","v":0},0,{"$f":"SUM(StartSum:EndSum!I48)","v":0},{"$f":"SUM(StartSum:EndSum!J48)","v":0},{"$f":"SUM(StartSum:EndSum!K48)","v":0},0,{"$f":"SUM(StartSum:EndSum!M48)","v":0},{"$f":"SUM(StartSum:EndSum!N48)","v":0},{"$f":"SUM(StartSum:EndSum!O48)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q48)","v":0},{"$f":"SUM(StartSum:EndSum!R48)","v":0},{"$f":"SUM(StartSum:EndSum!S48)","v":0},0,{"$f":"SUM(StartSum:EndSum!U48)","v":0},{"$f":"SUM(StartSum:EndSum!V48)","v":0},{"$f":"SUM(StartSum:EndSum!W48)","v":0}]
[null,"2.32","Other Non-Covered FFS",0,{"$f":"SUM(StartSum:EndSum!E49)","v":0},{"$f":"SUM(StartSum:EndSum!F49)","v":0},{"$f":"SUM(StartSum:EndSum!G49)","v":0},0,{"$f":"SUM(StartSum:EndSum!I49)","v":0},{"$f":"SUM(StartSum:EndSum!J49)","v":0},{"$f":"SUM(StartSum:EndSum!K49)","v":0},0,{"$f":"SUM(StartSum:EndSum!M49)","v":0},{"$f":"SUM(StartSum:EndSum!N49)","v":0},{"$f":"SUM(StartSum:EndSum!O49)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q49)","v":0},{"$f":"SUM(StartSum:EndSum!R49)","v":0},{"$f":"SUM(StartSum:EndSum!S49)","v":0},0,{"$f":"SUM(StartSum:EndSum!U49)","v":0},{"$f":"SUM(StartSum:EndSum!V49)","v":0},{"$f":"SUM(StartSum:EndSum!W49)","v":0}]
[null,"2.33","Other Non-Covered Subcapitation",0,{"$f":"SUM(StartSum:EndSum!E50)","v":0},{"$f":"SUM(StartSum:EndSum!F50)","v":0},{"$f":"SUM(StartSum:EndSum!G50)","v":0},0,{"$f":"SUM(StartSum:EndSum!I50)","v":0},{"$f":"SUM(StartSum:EndSum!J50)","v":0},{"$f":"SUM(StartSum:EndSum!K50)","v":0},0,{"$f":"SUM(StartSum:EndSum!M50)","v":0},{"$f":"SUM(StartSum:EndSum!N50)","v":0},{"$f":"SUM(StartSum:EndSum!O50)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q50)","v":0},{"$f":"SUM(StartSum:EndSum!R50)","v":0},{"$f":"SUM(StartSum:EndSum!S50)","v":0},0,{"$f":"SUM(StartSum:EndSum!U50)","v":0},{"$f":"SUM(StartSum:EndSum!V50)","v":0},{"$f":"SUM(StartSum:EndSum!W50)","v":0}]
[null,"2.34","COB/Subrg. (outside claim system)",0,{"$f":"SUM(StartSum:EndSum!E51)","v":0},{"$f":"SUM(StartSum:EndSum!F51)","v":0},{"$f":"SUM(StartSum:EndSum!G51)","v":0},0,{"$f":"SUM(StartSum:EndSum!I51)","v":0},{"$f":"SUM(StartSum:EndSum!J51)","v":0},{"$f":"SUM(StartSum:EndSum!K51)","v":0},0,{"$f":"SUM(StartSum:EndSum!M51)","v":0},{"$f":"SUM(StartSum:EndSum!N51)","v":0},{"$f":"SUM(StartSum:EndSum!O51)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q51)","v":0},{"$f":"SUM(StartSum:EndSum!R51)","v":0},{"$f":"SUM(StartSum:EndSum!S51)","v":0},0,{"$f":"SUM(StartSum:EndSum!U51)","v":0},{"$f":"SUM(StartSum:EndSum!V51)","v":0},{"$f":"SUM(StartSum:EndSum!W51)","v":0}]
[null,"2.35","Other Medicaid Expenses",0,{"$f":"SUM(StartSum:EndSum!E52)","v":0},{"$f":"SUM(StartSum:EndSum!F52)","v":0},{"$f":"SUM(StartSum:EndSum!G52)","v":0},0,{"$f":"SUM(StartSum:EndSum!I52)","v":0},{"$f":"SUM(StartSum:EndSum!J52)","v":0},{"$f":"SUM(StartSum:EndSum!K52)","v":0},0,{"$f":"SUM(StartSum:EndSum!M52)","v":0},{"$f":"SUM(StartSum:EndSum!N52)","v":0},{"$f":"SUM(StartSum:EndSum!O52)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q52)","v":0},{"$f":"SUM(StartSum:EndSum!R52)","v":0},{"$f":"SUM(StartSum:EndSum!S52)","v":0},0,{"$f":"SUM(StartSum:EndSum!U52)","v":0},{"$f":"SUM(StartSum:EndSum!V52)","v":0},{"$f":"SUM(StartSum:EndSum!W52)","v":0}]
[null,"2.36","Ending IBNP for Inpatient Hospital Services",{"$f":"SUM(E52:G52)","v":0},{"$f":"SUM(StartSum:EndSum!E53)","v":0},{"$f":"SUM(StartSum:EndSum!F53)","v":0},{"$f":"SUM(StartSum:EndSum!G53)","v":0},{"$f":"SUM(I52:K52)","v":0},{"$f":"SUM(StartSum:EndSum!I53)","v":0},{"$f":"SUM(StartSum:EndSum!J53)","v":0},{"$f":"SUM(StartSum:EndSum!K53)","v":0},{"$f":"SUM(M52:O52)","v":0},{"$f":"SUM(StartSum:EndSum!M53)","v":0},{"$f":"SUM(StartSum:EndSum!N53)","v":0},{"$f":"SUM(StartSum:EndSum!O53)","v":0},{"$f":"SUM(Q52:S52)","v":0},{"$f":"SUM(StartSum:EndSum!Q53)","v":0},{"$f":"SUM(StartSum:EndSum!R53)","v":0},{"$f":"SUM(StartSum:EndSum!S53)","v":0},{"$f":"SUM(U52:W52)","v":0},{"$f":"SUM(StartSum:EndSum!U53)","v":0},{"$f":"SUM(StartSum:EndSum!V53)","v":0},{"$f":"SUM(StartSum:EndSum!W53)","v":0}]
[null,"2.37","Ending IBNP for Outpatient Hospital Services",0,{"$f":"SUM(StartSum:EndSum!E54)","v":0},{"$f":"SUM(StartSum:EndSum!F54)","v":0},{"$f":"SUM(StartSum:EndSum!G54)","v":0},0,{"$f":"SUM(StartSum:EndSum!I54)","v":0},{"$f":"SUM(StartSum:EndSum!J54)","v":0},{"$f":"SUM(StartSum:EndSum!K54)","v":0},0,{"$f":"SUM(StartSum:EndSum!M54)","v":0},{"$f":"SUM(StartSum:EndSum!N54)","v":0},{"$f":"SUM(StartSum:EndSum!O54)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q54)","v":0},{"$f":"SUM(StartSum:EndSum!R54)","v":0},{"$f":"SUM(StartSum:EndSum!S54)","v":0},0,{"$f":"SUM(StartSum:EndSum!U54)","v":0},{"$f":"SUM(StartSum:EndSum!V54)","v":0},{"$f":"SUM(StartSum:EndSum!W54)","v":0}]
[null,"2.38","Ending IBNP for Mental Health & Substance Abuse",0,{"$f":"SUM(StartSum:EndSum!E55)","v":0},{"$f":"SUM(StartSum:EndSum!F55)","v":0},{"$f":"SUM(StartSum:EndSum!G55)","v":0},0,{"$f":"SUM(StartSum:EndSum!I55)","v":0},{"$f":"SUM(StartSum:EndSum!J55)","v":0},{"$f":"SUM(StartSum:EndSum!K55)","v":0},0,{"$f":"SUM(StartSum:EndSum!M55)","v":0},{"$f":"SUM(StartSum:EndSum!N55)","v":0},{"$f":"SUM(StartSum:EndSum!O55)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q55)","v":0},{"$f":"SUM(StartSum:EndSum!R55)","v":0},{"$f":"SUM(StartSum:EndSum!S55)","v":0},0,{"$f":"SUM(StartSum:EndSum!U55)","v":0},{"$f":"SUM(StartSum:EndSum!V55)","v":0},{"$f":"SUM(StartSum:EndSum!W55)","v":0}]
[null,"2.39","Ending IBNP for Professional Services",0,{"$f":"SUM(StartSum:EndSum!E56)","v":0},{"$f":"SUM(StartSum:EndSum!F56)","v":0},{"$f":"SUM(StartSum:EndSum!G56)","v":0},0,{"$f":"SUM(StartSum:EndSum!I56)","v":0},{"$f":"SUM(StartSum:EndSum!J56)","v":0},{"$f":"SUM(StartSum:EndSum!K56)","v":0},0,{"$f":"SUM(StartSum:EndSum!M56)","v":0},{"$f":"SUM(StartSum:EndSum!N56)","v":0},{"$f":"SUM(StartSum:EndSum!O56)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q56)","v":0},{"$f":"SUM(StartSum:EndSum!R56)","v":0},{"$f":"SUM(StartSum:EndSum!S56)","v":0},0,{"$f":"SUM(StartSum:EndSum!U56)","v":0},{"$f":"SUM(StartSum:EndSum!V56)","v":0},{"$f":"SUM(StartSum:EndSum!W56)","v":0}]
[null,"2.40","Ending IBNP for Prescription Drugs",0,{"$f":"SUM(StartSum:EndSum!E57)","v":0},{"$f":"SUM(StartSum:EndSum!F57)","v":0},{"$f":"SUM(StartSum:EndSum!G57)","v":0},0,{"$f":"SUM(StartSum:EndSum!I57)","v":0},{"$f":"SUM(StartSum:EndSum!J57)","v":0},{"$f":"SUM(StartSum:EndSum!K57)","v":0},0,{"$f":"SUM(StartSum:EndSum!M57)","v":0},{"$f":"SUM(StartSum:EndSum!N57)","v":0},{"$f":"SUM(StartSum:EndSum!O57)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q57)","v":0},{"$f":"SUM(StartSum:EndSum!R57)","v":0},{"$f":"SUM(StartSum:EndSum!S57)","v":0},0,{"$f":"SUM(StartSum:EndSum!U57)","v":0},{"$f":"SUM(StartSum:EndSum!V57)","v":0},{"$f":"SUM(StartSum:EndSum!W57)","v":0}]
[null,"2.41","Ending IBNP for Transportation",0,{"$f":"SUM(StartSum:EndSum!E58)","v":0},{"$f":"SUM(StartSum:EndSum!F58)","v":0},{"$f":"SUM(StartSum:EndSum!G58)","v":0},0,{"$f":"SUM(StartSum:EndSum!I58)","v":0},{"$f":"SUM(StartSum:EndSum!J58)","v":0},{"$f":"SUM(StartSum:EndSum!K58)","v":0},0,{"$f":"SUM(StartSum:EndSum!M58)","v":0},{"$f":"SUM(StartSum:EndSum!N58)","v":0},{"$f":"SUM(StartSum:EndSum!O58)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q58)","v":0},{"$f":"SUM(StartSum:EndSum!R58)","v":0},{"$f":"SUM(StartSum:EndSum!S58)","v":0},0,{"$f":"SUM(StartSum:EndSum!U58)","v":0},{"$f":"SUM(StartSum:EndSum!V58)","v":0},{"$f":"SUM(StartSum:EndSum!W58)","v":0}]
[null,"2.42","Ending IBNP for Dental Services",0,{"$f":"SUM(StartSum:EndSum!E59)","v":0},{"$f":"SUM(StartSum:EndSum!F59)","v":0},{"$f":"SUM(StartSum:EndSum!G59)","v":0},0,{"$f":"SUM(StartSum:EndSum!I59)","v":0},{"$f":"SUM(StartSum:EndSum!J59)","v":0},{"$f":"SUM(StartSum:EndSum!K59)","v":0},0,{"$f":"SUM(StartSum:EndSum!M59)","v":0},{"$f":"SUM(StartSum:EndSum!N59)","v":0},{"$f":"SUM(StartSum:EndSum!O59)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q59)","v":0},{"$f":"SUM(StartSum:EndSum!R59)","v":0},{"$f":"SUM(StartSum:EndSum!S59)","v":0},0,{"$f":"SUM(StartSum:EndSum!U59)","v":0},{"$f":"SUM(StartSum:EndSum!V59)","v":0},{"$f":"SUM(StartSum:EndSum!W59)","v":0}]
[null,"2.43","Ending IBNP for Vision Services",0,{"$f":"SUM(StartSum:EndSum!E60)","v":0},{"$f":"SUM(StartSum:EndSum!F60)","v":0},{"$f":"SUM(StartSum:EndSum!G60)","v":0},0,{"$f":"SUM(StartSum:EndSum!I60)","v":0},{"$f":"SUM(StartSum:EndSum!J60)","v":0},{"$f":"SUM(StartSum:EndSum!K60)","v":0},0,{"$f":"SUM(StartSum:EndSum!M60)","v":0},{"$f":"SUM(StartSum:EndSum!N60)","v":0},{"$f":"SUM(StartSum:EndSum!O60)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q60)","v":0},{"$f":"SUM(StartSum:EndSum!R60)","v":0},{"$f":"SUM(StartSum:EndSum!S60)","v":0},0,{"$f":"SUM(StartSum:EndSum!U60)","v":0},{"$f":"SUM(StartSum:EndSum!V60)","v":0},{"$f":"SUM(StartSum:EndSum!W60)","v":0}]
[null,"2.44","Ending IBNP for Hearing Services",0,{"$f":"SUM(StartSum:EndSum!E61)","v":0},{"$f":"SUM(StartSum:EndSum!F61)","v":0},{"$f":"SUM(StartSum:EndSum!G61)","v":0},0,{"$f":"SUM(StartSum:EndSum!I61)","v":0},{"$f":"SUM(StartSum:EndSum!J61)","v":0},{"$f":"SUM(StartSum:EndSum!K61)","v":0},0,{"$f":"SUM(StartSum:EndSum!M61)","v":0},{"$f":"SUM(StartSum:EndSum!N61)","v":0},{"$f":"SUM(StartSum:EndSum!O61)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q61)","v":0},{"$f":"SUM(StartSum:EndSum!R61)","v":0},{"$f":"SUM(StartSum:EndSum!S61)","v":0},0,{"$f":"SUM(StartSum:EndSum!U61)","v":0},{"$f":"SUM(StartSum:EndSum!V61)","v":0},{"$f":"SUM(StartSum:EndSum!W61)","v":0}]
[null,"2.45","Ending IBNP for Other Services",0,{"$f":"SUM(StartSum:EndSum!E62)","v":0},{"$f":"SUM(StartSum:EndSum!F62)","v":0},{"$f":"SUM(StartSum:EndSum!G62)","v":0},0,{"$f":"SUM(StartSum:EndSum!I62)","v":0},{"$f":"SUM(StartSum:EndSum!J62)","v":0},{"$f":"SUM(StartSum:EndSum!K62)","v":0},0,{"$f":"SUM(StartSum:EndSum!M62)","v":0},{"$f":"SUM(StartSum:EndSum!N62)","v":0},{"$f":"SUM(StartSum:EndSum!O62)","v":0},0,{"$f":"SUM(StartSum:EndSum!Q62)","v":0},{"$f":"SUM(StartSum:EndSum!R62)","v":0},{"$f":"SUM(StartSum:EndSum!S62)","v":0},0,{"$f":"SUM(StartSum:EndSum!U62)","v":0},{"$f":"SUM(StartSum:EndSum!V62)","v":0},{"$f":"SUM(StartSum:EndSum!W62)","v":0}]
[null,"2.46","Subtotal Benefit Expense before Reinsurance",{"$f":"SUM(D16:D61)","v":0},{"$f":"SUM(E16:E61)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S16:S61)","v":0},{"$f":"SUM(T16:T61)","v":0},0,0,0]
["Totals After Reinsurance","3.1","Reinsurance Premiums",{"$f":"SUM(E63:G63)","v":0},{"$f":"SUM(StartSum:EndSum!E64)","v":0},{"$f":"SUM(StartSum:EndSum!F64)","v":0},{"$f":"SUM(StartSum:EndSum!G64)","v":0},{"$f":"SUM(I63:K63)","v":0},{"$f":"SUM(StartSum:EndSum!I64)","v":0},{"$f":"SUM(StartSum:EndSum!J64)","v":0},{"$f":"SUM(StartSum:EndSum!K64)","v":0},{"$f":"SUM(M63:O63)","v":0},{"$f":"SUM(StartSum:EndSum!M64)","v":0},{"$f":"SUM(StartSum:EndSum!N64)","v":0},{"$f":"SUM(StartSum:EndSum!O64)","v":0},{"$f":"SUM(Q63:S63)","v":0},{"$f":"SUM(StartSum:EndSum!Q64)","v":0},{"$f":"SUM(StartSum:EndSum!R64)","v":0},{"$f":"SUM(StartSum:EndSum!S64)","v":0},{"$f":"SUM(U63:W63)","v":0},{"$f":"SUM(StartSum:EndSum!U64)","v":0},{"$f":"SUM(StartSum:EndSum!V64)","v":0},{"$f":"SUM(StartSum:EndSum!W64)","v":0}]
[null,"3.2","Reinsurance Recoveries",{"$f":"SUM(E64:G64)","v":0},{"$f":"SUM(StartSum:EndSum!E65)","v":0},{"$f":"SUM(StartSum:EndSum!F65)","v":0},{"$f":"SUM(StartSum:EndSum!G65)","v":0},{"$f":"SUM(I64:K64)","v":0},{"$f":"SUM(StartSum:EndSum!I65)","v":0},{"$f":"SUM(StartSum:EndSum!J65)","v":0},{"$f":"SUM(StartSum:EndSum!K65)","v":0},{"$f":"SUM(M64:O64)","v":0},{"$f":"SUM(StartSum:EndSum!M65)","v":0},{"$f":"SUM(StartSum:EndSum!N65)","v":0},{"$f":"SUM(StartSum:EndSum!O65)","v":0},{"$f":"SUM(Q64:S64)","v":0},{"$f":"SUM(StartSum:EndSum!Q65)","v":0},{"$f":"SUM(StartSum:EndSum!R65)","v":0},{"$f":"SUM(StartSum:EndSum!S65)","v":0},{"$f":"SUM(U64:W64)","v":0},{"$f":"SUM(StartSum:EndSum!U65)","v":0},{"$f":"SUM(StartSum:EndSum!V65)","v":0},{"$f":"SUM(StartSum:EndSum!W65)","v":0}]
[null,"3.3","Net cost of Reinsurance",{"$f":"SUM(D63:D64)","v":0},{"$f":"SUM(E63:E64)","v":0},{"$f":"SUM(F63:F64)","v":0},0,{"$f":"SUM(H63:H64)","v":0},{"$f":"SUM(I63:I64)","v":0},{"$f":"SUM(J63:J64)","v":0},0,{"$f":"SUM(L63:L64)","v":0},{"$f":"SUM(M63:M64)","v":0},{"$f":"SUM(N63:N64)","v":0},0,{"$f":"SUM(P63:P64)","v":0},{"$f":"SUM(Q63:Q64)","v":0},{"$f":"SUM(R63:R64)","v":0},0,0,{"$f":"SUM(U63:U64)","v":0},{"$f":"SUM(V63:V64)","v":0},{"$f":"SUM(W63:W64)","v":0}]
[null,"3.4","Grand Total Medical Benefit Expense Net of Reinsurance",{"$f":"SUM(D62,D65)","v":0},{"$f":"SUM(E62,E65)","v":0},{"$f":"SUM(F62,F65)","v":0},0,{"$f":"SUM(H62,H65)","v":0},{"$f":"SUM(I62,I65)","v":0},0,0,{"$f":"SUM(L62,L65)","v":0},{"$f":"SUM(M62,M65)","v":0},0,0,{"$f":"SUM(P62,P65)","v":0},{"$f":"SUM(Q62,Q65)","v":0},0,0,0,0,0,0]
["Administrative Expenses, Government-Mandated Assessments, Taxes, and Fees ",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate"]
["Administrative Expenses","4.1","Salaries & Benefits",{"$f":"SUM(E69:F69)","v":0},{"$f":"'DSNP Admin Summary'!E100","v":0},{"$f":"'DSNP Admin Summary'!F100","v":0},null,{"$f":"SUM(I69:J69)","v":0},{"$f":"'DSNP Admin Summary'!I100","v":0},{"$f":"'DSNP Admin Summary'!J100","v":0},null,{"$f":"SUM(M69:N69)","v":0},{"$f":"'DSNP Admin Summary'!M100","v":0},{"$f":"'DSNP Admin Summary'!N100","v":0},null,{"$f":"SUM(Q69:R69)","v":0},{"$f":"'DSNP Admin Summary'!Q100","v":0},{"$f":"'DSNP Admin Summary'!R100","v":0},null,{"$f":"SUM(U69:V69)","v":0},{"$f":"'DSNP Admin Summary'!U100","v":0},{"$f":"'DSNP Admin Summary'!V100","v":0}]
[null,"4.2","Administrative Services",0,{"$f":"'DSNP Admin Summary'!E101","v":0},{"$f":"'DSNP Admin Summary'!F101","v":0},null,0,{"$f":"'DSNP Admin Summary'!I101","v":0},{"$f":"'DSNP Admin Summary'!J101","v":0},null,0,{"$f":"'DSNP Admin Summary'!M101","v":0},{"$f":"'DSNP Admin Summary'!N101","v":0},null,0,{"$f":"'DSNP Admin Summary'!Q101","v":0},{"$f":"'DSNP Admin Summary'!R101","v":0},null,0,{"$f":"'DSNP Admin Summary'!U101","v":0},{"$f":"'DSNP Admin Summary'!V101","v":0}]
[null,"4.3","Information Systems",0,{"$f":"'DSNP Admin Summary'!E102","v":0},{"$f":"'DSNP Admin Summary'!F102","v":0},null,0,{"$f":"'DSNP Admin Summary'!I102","v":0},{"$f":"'DSNP Admin Summary'!J102","v":0},null,0,{"$f":"'DSNP Admin Summary'!M102","v":0},{"$f":"'DSNP Admin Summary'!N102","v":0},null,0,{"$f":"'DSNP Admin Summary'!Q102","v":0},{"$f":"'DSNP Admin Summary'!R102","v":0},null,0,{"$f":"'DSNP Admin Summary'!U102","v":0},{"$f":"'DSNP Admin Summary'!V102","v":0}]
[null,"4.4","Marketing Expenses",0,{"$f":"'DSNP Admin Summary'!E103","v":0},{"$f":"'DSNP Admin Summary'!F103","v":0},null,0,{"$f":"'DSNP Admin Summary'!I103","v":0},{"$f":"'DSNP Admin Summary'!J103","v":0},null,0,{"$f":"'DSNP Admin Summary'!M103","v":0},{"$f":"'DSNP Admin Summary'!N103","v":0},null,0,{"$f":"'DSNP Admin Summary'!Q103","v":0},{"$f":"'DSNP Admin Summary'!R103","v":0},null,0,{"$f":"'DSNP Admin Summary'!U103","v":0},{"$f":"'DSNP Admin Summary'!V103","v":0}]
[null,"4.5","General  Administration",0,{"$f":"'DSNP Admin Summary'!E104","v":0},{"$f":"'DSNP Admin Summary'!F104","v":0},null,0,{"$f":"'DSNP Admin Summary'!I104","v":0},{"$f":"'DSNP Admin Summary'!J104","v":0},null,0,{"$f":"'DSNP Admin Summary'!M104","v":0},{"$f":"'DSNP Admin Summary'!N104","v":0},null,0,{"$f":"'DSNP Admin Summary'!Q104","v":0},{"$f":"'DSNP Admin Summary'!R104","v":0},null,0,{"$f":"'DSNP Admin Summary'!U104","v":0},{"$f":"'DSNP Admin Summary'!V104","v":0}]
[null,"4.6","Compliance/Regulatory",0,{"$f":"'DSNP Admin Summary'!E105","v":0},{"$f":"'DSNP Admin Summary'!F105","v":0},null,0,{"$f":"'DSNP Admin Summary'!I105","v":0},{"$f":"'DSNP Admin Summary'!J105","v":0},null,0,{"$f":"'DSNP Admin Summary'!M105","v":0},{"$f":"'DSNP Admin Summary'!N105","v":0},null,0,{"$f":"'DSNP Admin Summary'!Q105","v":0},{"$f":"'DSNP Admin Summary'!R105","v":0},null,0,{"$f":"'DSNP Admin Summary'!U105","v":0},{"$f":"'DSNP Admin Summary'!V105","v":0}]
[null,"4.7","Total Administrative Expenses ",{"$f":"SUM(D69:D74)","v":0},{"$f":"'DSNP Admin Summary'!E106","v":0},{"$f":"'DSNP Admin Summary'!F106","v":0},null,{"$f":"SUM(H69:H74)","v":0},{"$f":"'DSNP Admin Summary'!I106","v":0},{"$f":"'DSNP Admin Summary'!J106","v":0},null,{"$f":"SUM(L69:L74)","v":0},{"$f":"'DSNP Admin Summary'!M106","v":0},{"$f":"'DSNP Admin Summary'!N106","v":0},null,{"$f":"SUM(P69:P74)","v":0},{"$f":"'DSNP Admin Summary'!Q106","v":0},{"$f":"'DSNP Admin Summary'!R106","v":0},null,{"$f":"SUM(T69:T74)","v":0},{"$f":"'DSNP Admin Summary'!U106","v":0},{"$f":"'DSNP Admin Summary'!V106","v":0}]
["Government-Mandated Assessments, Taxes, and Fees Other Than Income Taxes","5.1","State Premium tax",{"$f":"'DSNP Admin Summary'!D107","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!H107","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!L107","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!P107","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!T107","v":0}]
[null,"5.2","Department of Insurance Assessments",{"$f":"'DSNP Admin Summary'!D108","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!H108","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!L108","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!P108","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!T108","v":0}]
[null,"5.3","Other 1",{"$f":"'DSNP Admin Summary'!D109","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!H109","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!L109","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!P109","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!T109","v":0}]
[null,"5.4","Other 2",{"$f":"'DSNP Admin Summary'!D110","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!H110","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!L110","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!P110","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!T110","v":0}]
[null,"5.5","Other 3",{"$f":"'DSNP Admin Summary'!D111","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!H111","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!L111","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!P111","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!T111","v":0}]
[null,"5.6","Total ",{"$f":"SUM(D76:D80)","v":0},{"$nulls":3},{"$f":"SUM(H76:H80)","v":0},{"$nulls":3},{"$f":"SUM(L76:L80)","v":0},{"$nulls":3},{"$f":"SUM(P76:P80)","v":0},{"$nulls":3},{"$f":"SUM(T76:T80)","v":0}]
[null,"6","Grand Total Expenses",{"$f":"SUM(D66,D75,D81)","v":0},{"$nulls":3},{"$f":"SUM(H66,H75,H81)","v":0},{"$nulls":3},{"$f":"SUM(L66,L75,L81)","v":0},{"$nulls":3},{"$f":"SUM(P66,P75,P81)","v":0},{"$nulls":3},{"$f":"SUM(T66,T75,T81)","v":0}]
[null,"7","Underwriting Gain / (Loss)  --- AKA Pre-tax Earnings from Operations",{"$f":"D13-D82","v":0},{"$nulls":3},{"$f":"H13-H82","v":0},{"$nulls":3},{"$f":"L13-L82","v":0},{"$nulls":3},{"$f":"P13-P82","v":0},{"$nulls":3},{"$f":"T13-T82","v":0}]
[null,"8","Income Tax Expense",{"$f":"'DSNP Admin Summary'!D115","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!H115","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!L115","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!P115","v":0},{"$nulls":3},{"$f":"'DSNP Admin Summary'!T115","v":0}]
[null,"9","Net Underwriting Gain (Loss) from Operations",{"$f":"D83-D84","v":0},{"$nulls":3},{"$f":"H83-H84","v":0},{"$nulls":3},{"$f":"L83-L84","v":0},{"$nulls":3},{"$f":"P83-P84","v":0},{"$nulls":3},{"$f":"T83-T84","v":0}]

{"sheet":"StartSum","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"DSNP Rev-Exp Rest of Florida","index":10,"n_rows":67,"n_cols":23,"rows_kept":67,"hidden":true,"merged":[[7,3,7,6],[7,7,7,10],[7,11,7,14],[7,15,7,18],[7,19,7,22],[8,5,8,6],[8,9,8,10],[8,13,8,14],[8,17,8,18],[8,21,8,22],[9,5,9,6],[9,9,9,10],[9,13,9,14],[9,17,9,18],[9,21,9,22],[10,0,10,2],[10,5,10,6],[10,9,10,10],[10,13,10,14],[10,17,10,18],[10,21,10,22],[11,0,13,0],[11,5,11,6],[11,9,11,10],[11,13,11,14],[11,17,11,18],[11,21,11,22],[12,5,12,6],[12,9,12,10],[12,13,12,14],[12,17,12,18],[12,21,12,22],[13,5,13,6],[13,9,13,10],[13,13,13,14],[13,17,13,18],[13,21,13,22],[14,0,15,2],[14,3,14,6],[14,7,14,10],[14,11,14,14],[14,15,14,18],[14,19,14,22],[16,0,62,0],[63,0,66,0]]}
["DUAL SPECIAL NEEDS PLAN -- REVENUE AND EXPENSE SCHEDULE - REST OF FLORIDA"]
[]
["Health Plan:",null,{"$f":"'DSNP Rev-Exp Summary'!C3","v":0}]
["PBP Identifier:"]
["Reporting Period:",null,{"$f":"IF('DSNP Rev-Exp Summary'!C4=0,\"\",'DSNP Rev-Exp Summary'!C4)","v":""}]
["Paid Through:",null,{"$f":"IF('DSNP Rev-Exp Summary'!C5=0,\"\",'DSNP Rev-Exp Summary'!C5)","v":""}]
["Rest of Florida"]
[{"$nulls":3},"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual"]
["MEMBER MONTHS",null,null,{"$f":"SUM(E10:G10)","v":0},{"$nulls":3},{"$f":"SUM(I10:K10)","v":0},{"$nulls":3},{"$f":"SUM(M10:O10)","v":0},{"$nulls":3},{"$f":"SUM(Q10:S10)","v":0},{"$nulls":3},{"$f":"SUM(U10:V10)","v":0},{"$f":"E10+I10+M10+Q10","v":0},{"$f":"F10+J10+N10+R10","v":0}]
["REVENUES"]
["Revenues","1.1","Capitation",{"$f":"SUM(E12:G12)","v":0},{"$nulls":3},{"$f":"SUM(I12:K12)","v":0},{"$nulls":3},{"$f":"SUM(M12:O12)","v":0},{"$nulls":3},{"$f":"SUM(Q12:S12)","v":0},{"$nulls":3},{"$f":"SUM(U12:W12)","v":0},{"$f":"E12+I12+M12+Q12","v":0},{"$f":"F12+J12+N12+R12","v":0}]
[null,"1.2","Other Revenue",{"$f":"SUM(E13:G13)","v":0},{"$nulls":3},{"$f":"SUM(I13:K13)","v":0},{"$nulls":3},{"$f":"SUM(M13:O13)","v":0},{"$nulls":3},{"$f":"SUM(Q13:S13)","v":0},{"$nulls":3},{"$f":"SUM(U13:W13)","v":0},{"$f":"E13+I13+M13+Q13","v":0},{"$f":"F13+J13+N13+R13","v":0}]
[null,"1.3","Total Revenue",{"$f":"SUM(D12:D13)","v":0},{"$f":"SUM(E12:E13)","v":0},{"$f":"SUM(F12:G13)","v":0},null,{"$f":"SUM(H12:H13)","v":0},{"$f":"SUM(I12:I13)","v":0},{"$f":"SUM(J12:K13)","v":0},null,{"$f":"SUM(L12:L13)","v":0},{"$f":"SUM(M12:M13)","v":0},{"$f":"SUM(N12:O13)","v":0},null,{"$f":"SUM(P12:P13)","v":0},{"$f":"SUM(Q12:Q13)","v":0},{"$f":"SUM(R12:S13)","v":0},null,{"$f":"SUM(T12:T13)","v":0},{"$f":"SUM(U12:U13)","v":0},{"$f":"SUM(V12:W13)","v":0}]
["BENEFIT EXPENSES",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only"]
["Benefit Expenses","2.01","Inpatient Facility",{"$f":"SUM(E17:G17)","v":0},{"$nulls":3},{"$f":"SUM(I17:K17)","v":0},{"$nulls":3},{"$f":"SUM(M17:O17)","v":0},{"$nulls":3},{"$f":"SUM(Q17:S17)","v":0},{"$nulls":3},{"$f":"SUM(U17:W17)","v":0},{"$f":"E17+I17+M17+Q17","v":0},{"$f":"F17+J17+N17+R17","v":0},{"$f":"G17+K17+O17+S17","v":0}]
[null,"2.02","Skilled Nursing Facility",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.03","Home Health",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.04","Ambulance",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.05","DME/Prosthetics/Diabetes FFS",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.06","DME/Prosthetics/Diabetes Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(U22:W22)","v":0},{"$f":"E22+I22+M22+Q22","v":0},{"$f":"F22+J22+N22+R22","v":0},{"$f":"G22+K22+O22+S22","v":0}]
[null,"2.07","OP Facility - Emergency",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.08","OP Facility - Surgery",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.09","OP Facility - Other",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.10","Hospital Services Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.11","Mental Health FFS (excluding codes H2017, H2030, T1017)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.11.1","Mental Health FFS (only codes H2017, H2030, & T1017)",{"$f":"SUM(E28:G28)","v":0},{"$nulls":3},{"$f":"SUM(I28:K28)","v":0},{"$nulls":3},{"$f":"SUM(M28:O28)","v":0},{"$nulls":3},{"$f":"SUM(Q28:S28)","v":0},{"$nulls":3},{"$f":"SUM(U28:W28)","v":0},{"$f":"E28+I28+M28+Q28","v":0},{"$f":"F28+J28+N28+R28","v":0},{"$f":"G28+K28+O28+S28","v":0}]
[null,"2.12","Mental Health Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.13","Professional FFS - Primary Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.14","Professional FFS - Specialty Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.15","Professional FFS - Other Professional",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.16","Professional Services Subcapitation - Primary Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.17","Professional Services Subcapitation - Specialty Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.18","Professional Services Subcapitation - Other Professional",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.19","Part B Rx FFS",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.20","Pharmacy Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.21","OTC Pharmacy Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.22","Other Medicare Part B",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.23","Transportation FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.24","Transportation Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.25","Dental FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.26","Dental Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.27","Vision FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.28","Vision Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.29","Hearing FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.30","Hearing Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.31","Suppl. Ben. Chpt 4 (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.32","Other Non-Covered FFS",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.33","Other Non-Covered Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.34","COB/Subrg. (outside claim system)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.35","Other Medicaid Expenses",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.36","Ending IBNP for Inpatient Hospital Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.37","Ending IBNP for Outpatient Hospital Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.38","Ending IBNP for Mental Health & Substance Abuse",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.39","Ending IBNP for Professional Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.40","Ending IBNP for Prescription Drugs",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.41","Ending IBNP for Transportation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.42","Ending IBNP for Dental Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.43","Ending IBNP for Vision Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.44","Ending IBNP for Hearing Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.45","Ending IBNP for Other Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.46","Subtotal Benefit Expense before Reinsurance",{"$f":"SUM(D17:D62)","v":0},{"$f":"SUM(E17:E62)","v":0},{"$f":"SUM(F17:F62)","v":0},{"$f":"SUM(G17:G62)","v":0},{"$f":"SUM(H17:H62)","v":0},{"$f":"SUM(I17:I62)","v":0},0,0,{"$f":"SUM(L17:L62)","v":0},{"$f":"SUM(M17:M62)","v":0},0,0,0,0,0,0,0,0,0,0]
["Totals After Reinsurance","3.1","Reinsurance Premiums",{"$f":"SUM(E64:G64)","v":0},{"$nulls":3},{"$f":"SUM(I64:K64)","v":0},{"$nulls":3},{"$f":"SUM(M64:O64)","v":0},{"$nulls":3},{"$f":"SUM(Q64:S64)","v":0},{"$nulls":3},{"$f":"SUM(U64:W64)","v":0},{"$f":"E64+I64+M64+Q64","v":0},0,0]
[null,"3.2","Reinsurance Recoveries",{"$f":"SUM(E65:G65)","v":0},{"$nulls":3},{"$f":"SUM(I65:K65)","v":0},{"$nulls":3},{"$f":"SUM(M65:O65)","v":0},{"$nulls":3},{"$f":"SUM(Q65:S65)","v":0},{"$nulls":3},{"$f":"SUM(U65:W65)","v":0},0,0,0]
[null,"3.3","Net cost of Reinsurance",{"$f":"SUM(D64:D65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U66:W66)","v":0},0,0,0]
[null,"3.4","Grand Total Medical Benefit Expense Net of Reinsurance",{"$f":"SUM(D63,D66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U67:W67)","v":0},0,0,0]

{"sheet":"DSNP Rev-Exp Region 9","index":11,"n_rows":67,"n_cols":23,"rows_kept":67,"hidden":true,"merged":[[7,3,7,6],[7,7,7,10],[7,11,7,14],[7,15,7,18],[7,19,7,22],[8,5,8,6],[8,9,8,10],[8,13,8,14],[8,17,8,18],[8,21,8,22],[9,5,9,6],[9,9,9,10],[9,13,9,14],[9,17,9,18],[9,21,9,22],[10,0,10,2],[10,5,10,6],[10,9,10,10],[10,13,10,14],[10,17,10,18],[10,21,10,22],[11,0,13,0],[11,5,11,6],[11,9,11,10],[11,13,11,14],[11,17,11,18],[11,21,11,22],[12,5,12,6],[12,9,12,10],[12,13,12,14],[12,17,12,18],[12,21,12,22],[13,5,13,6],[13,9,13,10],[13,13,13,14],[13,17,13,18],[13,21,13,22],[14,0,15,2],[14,3,14,6],[14,7,14,10],[14,11,14,14],[14,15,14,18],[14,19,14,22],[16,0,62,0],[63,0,66,0]]}
["DUAL SPECIAL NEEDS PLAN -- REVENUE AND EXPENSE SCHEDULE - REGION 9"]
[]
["Health Plan:",null,{"$f":"'DSNP Rev-Exp Summary'!C3","v":0}]
["PBP Identifier:"]
["Reporting Period:",null,{"$f":"IF('DSNP Rev-Exp Summary'!C4=0,\"\",'DSNP Rev-Exp Summary'!C4)","v":""}]
["Paid Through:",null,{"$f":"IF('DSNP Rev-Exp Summary'!C5=0,\"\",'DSNP Rev-Exp Summary'!C5)","v":""}]
["Region 9"]
[{"$nulls":3},"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual"]
["MEMBER MONTHS",null,null,{"$f":"SUM(E10:G10)","v":0},{"$nulls":3},{"$f":"SUM(I10:K10)","v":0},{"$nulls":3},{"$f":"SUM(M10:O10)","v":0},{"$nulls":3},{"$f":"SUM(Q10:S10)","v":0},{"$nulls":3},{"$f":"SUM(U10:V10)","v":0},{"$f":"E10+I10+M10+Q10","v":0},{"$f":"F10+J10+N10+R10","v":0}]
["REVENUES"]
["Revenues","1.1","Capitation",{"$f":"SUM(E12:G12)","v":0},{"$nulls":3},{"$f":"SUM(I12:K12)","v":0},{"$nulls":3},{"$f":"SUM(M12:O12)","v":0},{"$nulls":3},{"$f":"SUM(Q12:S12)","v":0},{"$nulls":3},{"$f":"SUM(U12:W12)","v":0},{"$f":"E12+I12+M12+Q12","v":0},{"$f":"F12+J12+N12+R12","v":0}]
[null,"1.2","Other Revenue",{"$f":"SUM(E13:G13)","v":0},{"$nulls":3},{"$f":"SUM(I13:K13)","v":0},{"$nulls":3},{"$f":"SUM(M13:O13)","v":0},{"$nulls":3},{"$f":"SUM(Q13:S13)","v":0},{"$nulls":3},{"$f":"SUM(U13:W13)","v":0},{"$f":"E13+I13+M13+Q13","v":0},{"$f":"F13+J13+N13+R13","v":0}]
[null,"1.3","Total Revenue",{"$f":"SUM(D12:D13)","v":0},{"$f":"SUM(E12:E13)","v":0},{"$f":"SUM(F12:G13)","v":0},null,{"$f":"SUM(H12:H13)","v":0},{"$f":"SUM(I12:I13)","v":0},{"$f":"SUM(J12:K13)","v":0},null,{"$f":"SUM(L12:L13)","v":0},{"$f":"SUM(M12:M13)","v":0},{"$f":"SUM(N12:O13)","v":0},null,{"$f":"SUM(P12:P13)","v":0},{"$f":"SUM(Q12:Q13)","v":0},{"$f":"SUM(R12:S13)","v":0},null,{"$f":"SUM(T12:T13)","v":0},{"$f":"SUM(U12:U13)","v":0},{"$f":"SUM(V12:W13)","v":0}]
["BENEFIT EXPENSES",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only"]
["Benefit Expenses","2.01","Inpatient Facility",{"$f":"SUM(E17:G17)","v":0},{"$nulls":3},{"$f":"SUM(I17:K17)","v":0},{"$nulls":3},{"$f":"SUM(M17:O17)","v":0},{"$nulls":3},{"$f":"SUM(Q17:S17)","v":0},{"$nulls":3},{"$f":"SUM(U17:W17)","v":0},{"$f":"E17+I17+M17+Q17","v":0},0,0]
[null,"2.02","Skilled Nursing Facility",{"$f":"SUM(E18:G18)","v":0},{"$nulls":3},{"$f":"SUM(I18:K18)","v":0},{"$nulls":3},{"$f":"SUM(M18:O18)","v":0},{"$nulls":3},{"$f":"SUM(Q18:S18)","v":0},{"$nulls":3},{"$f":"SUM(U18:W18)","v":0},0,0,0]
[null,"2.03","Home Health",{"$f":"SUM(E19:G19)","v":0},{"$nulls":3},{"$f":"SUM(I19:K19)","v":0},{"$nulls":3},{"$f":"SUM(M19:O19)","v":0},{"$nulls":3},{"$f":"SUM(Q19:S19)","v":0},{"$nulls":3},0,{"$f":"E19+I19+M19+Q19","v":0},0,0]
[null,"2.04","Ambulance",{"$f":"SUM(E20:G20)","v":0},{"$nulls":3},{"$f":"SUM(I20:K20)","v":0},{"$nulls":3},{"$f":"SUM(M20:O20)","v":0},{"$nulls":3},{"$f":"SUM(Q20:S20)","v":0},{"$nulls":3},0,0,0,0]
[null,"2.05","DME/Prosthetics/Diabetes FFS",{"$f":"SUM(E21:G21)","v":0},{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(M21:O21)","v":0},{"$nulls":3},{"$f":"SUM(Q21:S21)","v":0},{"$nulls":3},0,0,0,0]
[null,"2.06","DME/Prosthetics/Diabetes Subcapitation",{"$f":"SUM(E22:G22)","v":0},{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(Q22:S22)","v":0},{"$nulls":3},0,0,0,0]
[null,"2.07","OP Facility - Emergency",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.08","OP Facility - Surgery",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.09","OP Facility - Other",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.10","Hospital Services Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.11","Mental Health FFS (excluding codes H2017, H2030, & T1017)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.11.1","Mental Health FFS (only codes H2017, H2030, & T1017)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.12","Mental Health Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.13","Professional FFS - Primary Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.14","Professional FFS - Specialty Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.15","Professional FFS - Other Professional",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.16","Professional Services Subcapitation - Primary Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.17","Professional Services Subcapitation - Specialty Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.18","Professional Services Subcapitation - Other Professional",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.19","Part B Rx FFS",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.20","Pharmacy Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.21","OTC Pharmacy Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.22","Other Medicare Part B",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.23","Transportation FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.24","Transportation Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.25","Dental FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.26","Dental Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.27","Vision FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.28","Vision Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.29","Hearing FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.30","Hearing Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.31","Suppl. Ben. Chpt 4 (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.32","Other Non-Covered FFS",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$f":"E49+I49+M49+Q49","v":0},0,0]
[null,"2.33","Other Non-Covered Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.34","COB/Subrg. (outside claim system)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$f":"E51+I51+M51+Q51","v":0},{"$f":"F51+J51+N51+R51","v":0},{"$f":"G51+K51+O51+S51","v":0}]
[null,"2.35","Other Medicaid Expenses",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.36","Ending IBNP for Inpatient Hospital Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(U53:W53)","v":0},0,0,0]
[null,"2.37","Ending IBNP for Outpatient Hospital Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.38","Ending IBNP for Mental Health & Substance Abuse",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.39","Ending IBNP for Professional Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.40","Ending IBNP for Prescription Drugs",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.41","Ending IBNP for Transportation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.42","Ending IBNP for Dental Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.43","Ending IBNP for Vision Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.44","Ending IBNP for Hearing Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.45","Ending IBNP for Other Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.46","Subtotal Benefit Expense before Reinsurance",{"$f":"SUM(D17:D62)","v":0},{"$f":"SUM(E17:E62)","v":0},{"$f":"SUM(F17:F62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Totals After Reinsurance","3.1","Reinsurance Premiums",{"$f":"SUM(E64:G64)","v":0},{"$nulls":3},{"$f":"SUM(I64:K64)","v":0},{"$nulls":3},{"$f":"SUM(M64:O64)","v":0},{"$nulls":3},{"$f":"SUM(Q64:S64)","v":0},{"$nulls":3},{"$f":"SUM(U64:W64)","v":0},{"$f":"E64+I64+M64+Q64","v":0},{"$f":"F64+J64+N64+R64","v":0},0]
[null,"3.2","Reinsurance Recoveries",{"$f":"SUM(E65:G65)","v":0},{"$nulls":3},{"$f":"SUM(I65:K65)","v":0},{"$nulls":3},{"$f":"SUM(M65:O65)","v":0},{"$nulls":3},{"$f":"SUM(Q65:S65)","v":0},{"$nulls":3},{"$f":"SUM(U65:W65)","v":0},0,0,0]
[null,"3.3","Net cost of Reinsurance",{"$f":"SUM(D64:D65)","v":0},{"$f":"SUM(E64:E65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R64:R65)","v":0},0,{"$f":"SUM(U66:W66)","v":0},{"$f":"E66+I66+M66+Q66","v":0},0,0]
[null,"3.4","Grand Total Medical Benefit Expense Net of Reinsurance",{"$f":"SUM(D63,D66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q63,Q66)","v":0},0,0,{"$f":"SUM(U67:W67)","v":0},{"$f":"E67+I67+M67+Q67","v":0},0,0]

{"sheet":"DSNP Rev-Exp Region 10","index":12,"n_rows":67,"n_cols":23,"rows_kept":67,"hidden":true,"merged":[[7,3,7,6],[7,7,7,10],[7,11,7,14],[7,15,7,18],[7,19,7,22],[8,5,8,6],[8,9,8,10],[8,13,8,14],[8,17,8,18],[8,21,8,22],[9,5,9,6],[9,9,9,10],[9,13,9,14],[9,17,9,18],[9,21,9,22],[10,0,10,2],[10,5,10,6],[10,9,10,10],[10,13,10,14],[10,17,10,18],[10,21,10,22],[11,0,13,0],[11,5,11,6],[11,9,11,10],[11,13,11,14],[11,17,11,18],[11,21,11,22],[12,5,12,6],[12,9,12,10],[12,13,12,14],[12,17,12,18],[12,21,12,22],[13,5,13,6],[13,9,13,10],[13,13,13,14],[13,17,13,18],[13,21,13,22],[14,0,15,2],[14,3,14,6],[14,7,14,10],[14,11,14,14],[14,15,14,18],[14,19,14,22],[16,0,62,0],[63,0,66,0]]}
["DUAL SPECIAL NEEDS PLAN -- REVENUE AND EXPENSE SCHEDULE - REGION 10"]
[]
["Health Plan:",null,{"$f":"'DSNP Rev-Exp Summary'!C3","v":0}]
["PBP Identifier:"]
["Reporting Period:",null,{"$f":"IF('DSNP Rev-Exp Summary'!C4=0,\"\",'DSNP Rev-Exp Summary'!C4)","v":""}]
["Paid Through:",null,{"$f":"IF('DSNP Rev-Exp Summary'!C5=0,\"\",'DSNP Rev-Exp Summary'!C5)","v":""}]
["Region 10"]
[{"$nulls":3},"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual"]
["MEMBER MONTHS",null,null,{"$f":"SUM(E10:G10)","v":0},{"$nulls":3},{"$f":"SUM(I10:K10)","v":0},{"$nulls":3},{"$f":"SUM(M10:O10)","v":0},{"$nulls":3},{"$f":"SUM(Q10:S10)","v":0},{"$nulls":3},{"$f":"SUM(U10:V10)","v":0},{"$f":"E10+I10+M10+Q10","v":0},{"$f":"F10+J10+N10+R10","v":0}]
["REVENUES"]
["Revenues","1.1","Capitation",{"$f":"SUM(E12:G12)","v":0},{"$nulls":3},{"$f":"SUM(I12:K12)","v":0},{"$nulls":3},{"$f":"SUM(M12:O12)","v":0},{"$nulls":3},{"$f":"SUM(Q12:S12)","v":0},{"$nulls":3},{"$f":"SUM(U12:W12)","v":0},{"$f":"E12+I12+M12+Q12","v":0},{"$f":"F12+J12+N12+R12","v":0}]
[null,"1.2","Other Revenue",{"$f":"SUM(E13:G13)","v":0},{"$nulls":3},{"$f":"SUM(I13:K13)","v":0},{"$nulls":3},{"$f":"SUM(M13:O13)","v":0},{"$nulls":3},{"$f":"SUM(Q13:S13)","v":0},{"$nulls":3},{"$f":"SUM(U13:W13)","v":0},{"$f":"E13+I13+M13+Q13","v":0},{"$f":"F13+J13+N13+R13","v":0}]
[null,"1.3","Total Revenue",{"$f":"SUM(D12:D13)","v":0},{"$f":"SUM(E12:E13)","v":0},{"$f":"SUM(F12:G13)","v":0},null,{"$f":"SUM(H12:H13)","v":0},{"$f":"SUM(I12:I13)","v":0},{"$f":"SUM(J12:K13)","v":0},null,{"$f":"SUM(L12:L13)","v":0},{"$f":"SUM(M12:M13)","v":0},{"$f":"SUM(N12:O13)","v":0},null,{"$f":"SUM(P12:P13)","v":0},{"$f":"SUM(Q12:Q13)","v":0},{"$f":"SUM(R12:S13)","v":0},null,{"$f":"SUM(T12:T13)","v":0},{"$f":"SUM(U12:U13)","v":0},{"$f":"SUM(V12:W13)","v":0}]
["BENEFIT EXPENSES",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only"]
["Benefit Expenses","2.01","Inpatient Facility",{"$f":"SUM(E17:G17)","v":0},{"$nulls":3},{"$f":"SUM(I17:K17)","v":0},{"$nulls":3},{"$f":"SUM(M17:O17)","v":0},{"$nulls":3},{"$f":"SUM(Q17:S17)","v":0},{"$nulls":3},{"$f":"SUM(U17:W17)","v":0},{"$f":"E17+I17+M17+Q17","v":0},0,0]
[null,"2.02","Skilled Nursing Facility",{"$f":"SUM(E18:G18)","v":0},{"$nulls":3},{"$f":"SUM(I18:K18)","v":0},{"$nulls":3},{"$f":"SUM(M18:O18)","v":0},{"$nulls":3},{"$f":"SUM(Q18:S18)","v":0},{"$nulls":3},{"$f":"SUM(U18:W18)","v":0},0,0,0]
[null,"2.03","Home Health",{"$f":"SUM(E19:G19)","v":0},{"$nulls":3},{"$f":"SUM(I19:K19)","v":0},{"$nulls":3},{"$f":"SUM(M19:O19)","v":0},{"$nulls":3},{"$f":"SUM(Q19:S19)","v":0},{"$nulls":3},0,{"$f":"E19+I19+M19+Q19","v":0},0,0]
[null,"2.04","Ambulance",{"$f":"SUM(E20:G20)","v":0},{"$nulls":3},{"$f":"SUM(I20:K20)","v":0},{"$nulls":3},{"$f":"SUM(M20:O20)","v":0},{"$nulls":3},{"$f":"SUM(Q20:S20)","v":0},{"$nulls":3},0,0,0,0]
[null,"2.05","DME/Prosthetics/Diabetes FFS",{"$f":"SUM(E21:G21)","v":0},{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(M21:O21)","v":0},{"$nulls":3},{"$f":"SUM(Q21:S21)","v":0},{"$nulls":3},0,0,0,0]
[null,"2.06","DME/Prosthetics/Diabetes Subcapitation",{"$f":"SUM(E22:G22)","v":0},{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(Q22:S22)","v":0},{"$nulls":3},0,0,0,0]
[null,"2.07","OP Facility - Emergency",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.08","OP Facility - Surgery",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.09","OP Facility - Other",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.10","Hospital Services Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.11","Mental Health FFS (excluding codes H2017, H2030, & T1017)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.11.1","Mental Health FFS (only codes H2017, H2030, & T1017)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.12","Mental Health Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.13","Professional FFS - Primary Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.14","Professional FFS - Specialty Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.15","Professional FFS - Other Professional",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.16","Professional Services Subcapitation - Primary Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.17","Professional Services Subcapitation - Specialty Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.18","Professional Services Subcapitation - Other Professional",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.19","Part B Rx FFS",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.20","Pharmacy Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.21","OTC Pharmacy Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.22","Other Medicare Part B",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.23","Transportation FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.24","Transportation Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.25","Dental FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.26","Dental Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.27","Vision FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.28","Vision Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.29","Hearing FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.30","Hearing Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.31","Suppl. Ben. Chpt 4 (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.32","Other Non-Covered FFS",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$f":"E49+I49+M49+Q49","v":0},0,0]
[null,"2.33","Other Non-Covered Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.34","COB/Subrg. (outside claim system)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$f":"E51+I51+M51+Q51","v":0},{"$f":"F51+J51+N51+R51","v":0},{"$f":"G51+K51+O51+S51","v":0}]
[null,"2.35","Other Medicaid Expenses",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.36","Ending IBNP for Inpatient Hospital Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(U53:W53)","v":0},0,0,0]
[null,"2.37","Ending IBNP for Outpatient Hospital Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.38","Ending IBNP for Mental Health & Substance Abuse",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.39","Ending IBNP for Professional Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.40","Ending IBNP for Prescription Drugs",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.41","Ending IBNP for Transportation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.42","Ending IBNP for Dental Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.43","Ending IBNP for Vision Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.44","Ending IBNP for Hearing Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.45","Ending IBNP for Other Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.46","Subtotal Benefit Expense before Reinsurance",{"$f":"SUM(D17:D62)","v":0},{"$f":"SUM(E17:E62)","v":0},{"$f":"SUM(F17:F62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Totals After Reinsurance","3.1","Reinsurance Premiums",{"$f":"SUM(E64:G64)","v":0},{"$nulls":3},{"$f":"SUM(I64:K64)","v":0},{"$nulls":3},{"$f":"SUM(M64:O64)","v":0},{"$nulls":3},{"$f":"SUM(Q64:S64)","v":0},{"$nulls":3},{"$f":"SUM(U64:W64)","v":0},{"$f":"E64+I64+M64+Q64","v":0},{"$f":"F64+J64+N64+R64","v":0},0]
[null,"3.2","Reinsurance Recoveries",{"$f":"SUM(E65:G65)","v":0},{"$nulls":3},{"$f":"SUM(I65:K65)","v":0},{"$nulls":3},{"$f":"SUM(M65:O65)","v":0},{"$nulls":3},{"$f":"SUM(Q65:S65)","v":0},{"$nulls":3},{"$f":"SUM(U65:W65)","v":0},0,0,0]
[null,"3.3","Net cost of Reinsurance",{"$f":"SUM(D64:D65)","v":0},{"$f":"SUM(E64:E65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R64:R65)","v":0},0,{"$f":"SUM(U66:W66)","v":0},{"$f":"E66+I66+M66+Q66","v":0},0,0]
[null,"3.4","Grand Total Medical Benefit Expense Net of Reinsurance",{"$f":"SUM(D63,D66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q63,Q66)","v":0},0,0,{"$f":"SUM(U67:W67)","v":0},{"$f":"E67+I67+M67+Q67","v":0},0,0]

{"sheet":"DSNP Rev-Exp Region 11","index":13,"n_rows":67,"n_cols":23,"rows_kept":67,"hidden":true,"merged":[[7,3,7,6],[7,7,7,10],[7,11,7,14],[7,15,7,18],[7,19,7,22],[8,5,8,6],[8,9,8,10],[8,13,8,14],[8,17,8,18],[8,21,8,22],[9,5,9,6],[9,9,9,10],[9,13,9,14],[9,17,9,18],[9,21,9,22],[10,0,10,2],[10,5,10,6],[10,9,10,10],[10,13,10,14],[10,17,10,18],[10,21,10,22],[11,0,13,0],[11,5,11,6],[11,9,11,10],[11,13,11,14],[11,17,11,18],[11,21,11,22],[12,5,12,6],[12,9,12,10],[12,13,12,14],[12,17,12,18],[12,21,12,22],[13,5,13,6],[13,9,13,10],[13,13,13,14],[13,17,13,18],[13,21,13,22],[14,0,15,2],[14,3,14,6],[14,7,14,10],[14,11,14,14],[14,15,14,18],[14,19,14,22],[16,0,62,0],[63,0,66,0]]}
["DUAL SPECIAL NEEDS PLAN -- REVENUE AND EXPENSE SCHEDULE - REGION 11"]
[]
["Health Plan:",null,{"$f":"'DSNP Rev-Exp Summary'!C3","v":0}]
["PBP Identifier:"]
["Reporting Period:",null,{"$f":"IF('DSNP Rev-Exp Summary'!C4=0,\"\",'DSNP Rev-Exp Summary'!C4)","v":""}]
["Paid Through:",null,{"$f":"IF('DSNP Rev-Exp Summary'!C5=0,\"\",'DSNP Rev-Exp Summary'!C5)","v":""}]
["Region 11"]
[{"$nulls":3},"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual",null,"DSNP \nTotal","QMB","Full Dual"]
["MEMBER MONTHS",null,null,{"$f":"SUM(E10:G10)","v":0},{"$nulls":3},{"$f":"SUM(I10:K10)","v":0},{"$nulls":3},{"$f":"SUM(M10:O10)","v":0},{"$nulls":3},{"$f":"SUM(Q10:S10)","v":0},{"$nulls":3},{"$f":"SUM(U10:V10)","v":0},{"$f":"E10+I10+M10+Q10","v":0},{"$f":"F10+J10+N10+R10","v":0}]
["REVENUES"]
["Revenues","1.1","Capitation",{"$f":"SUM(E12:G12)","v":0},{"$nulls":3},{"$f":"SUM(I12:K12)","v":0},{"$nulls":3},{"$f":"SUM(M12:O12)","v":0},{"$nulls":3},{"$f":"SUM(Q12:S12)","v":0},{"$nulls":3},{"$f":"SUM(U12:W12)","v":0},{"$f":"E12+I12+M12+Q12","v":0},{"$f":"F12+J12+N12+R12","v":0}]
[null,"1.2","Other Revenue",{"$f":"SUM(E13:G13)","v":0},{"$nulls":3},{"$f":"SUM(I13:K13)","v":0},{"$nulls":3},{"$f":"SUM(M13:O13)","v":0},{"$nulls":3},{"$f":"SUM(Q13:S13)","v":0},{"$nulls":3},{"$f":"SUM(U13:W13)","v":0},{"$f":"E13+I13+M13+Q13","v":0},{"$f":"F13+J13+N13+R13","v":0}]
[null,"1.3","Total Revenue",{"$f":"SUM(D12:D13)","v":0},{"$f":"SUM(E12:E13)","v":0},{"$f":"SUM(F12:G13)","v":0},null,{"$f":"SUM(H12:H13)","v":0},{"$f":"SUM(I12:I13)","v":0},{"$f":"SUM(J12:K13)","v":0},null,{"$f":"SUM(L12:L13)","v":0},{"$f":"SUM(M12:M13)","v":0},{"$f":"SUM(N12:O13)","v":0},null,{"$f":"SUM(P12:P13)","v":0},{"$f":"SUM(Q12:Q13)","v":0},{"$f":"SUM(R12:S13)","v":0},null,{"$f":"SUM(T12:T13)","v":0},{"$f":"SUM(U12:U13)","v":0},{"$f":"SUM(V12:W13)","v":0}]
["BENEFIT EXPENSES",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only","DSNP \nTotal","QMB Medicare Cost Sharing","Full Dual Medicare Cost Sharing","Full Dual Medicaid Only"]
["Benefit Expenses","2.01","Inpatient Facility",{"$f":"SUM(E17:G17)","v":0},{"$nulls":3},{"$f":"SUM(I17:K17)","v":0},{"$nulls":3},{"$f":"SUM(M17:O17)","v":0},{"$nulls":3},{"$f":"SUM(Q17:S17)","v":0},{"$nulls":3},{"$f":"SUM(U17:W17)","v":0},{"$f":"E17+I17+M17+Q17","v":0},0,0]
[null,"2.02","Skilled Nursing Facility",{"$f":"SUM(E18:G18)","v":0},{"$nulls":3},{"$f":"SUM(I18:K18)","v":0},{"$nulls":3},{"$f":"SUM(M18:O18)","v":0},{"$nulls":3},{"$f":"SUM(Q18:S18)","v":0},{"$nulls":3},{"$f":"SUM(U18:W18)","v":0},0,0,0]
[null,"2.03","Home Health",{"$f":"SUM(E19:G19)","v":0},{"$nulls":3},{"$f":"SUM(I19:K19)","v":0},{"$nulls":3},{"$f":"SUM(M19:O19)","v":0},{"$nulls":3},{"$f":"SUM(Q19:S19)","v":0},{"$nulls":3},0,{"$f":"E19+I19+M19+Q19","v":0},0,0]
[null,"2.04","Ambulance",{"$f":"SUM(E20:G20)","v":0},{"$nulls":3},{"$f":"SUM(I20:K20)","v":0},{"$nulls":3},{"$f":"SUM(M20:O20)","v":0},{"$nulls":3},{"$f":"SUM(Q20:S20)","v":0},{"$nulls":3},0,0,0,0]
[null,"2.05","DME/Prosthetics/Diabetes FFS",{"$f":"SUM(E21:G21)","v":0},{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(M21:O21)","v":0},{"$nulls":3},{"$f":"SUM(Q21:S21)","v":0},{"$nulls":3},0,0,0,0]
[null,"2.06","DME/Prosthetics/Diabetes Subcapitation",{"$f":"SUM(E22:G22)","v":0},{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(Q22:S22)","v":0},{"$nulls":3},0,0,0,0]
[null,"2.07","OP Facility - Emergency",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.08","OP Facility - Surgery",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.09","OP Facility - Other",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.10","Hospital Services Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.11","Mental Health FFS (excluding codes H2017, H2030, & T1017)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.11.1","Mental Health FFS (only codes H2017, H2030, & T1017)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.12","Mental Health Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.13","Professional FFS - Primary Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.14","Professional FFS - Specialty Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.15","Professional FFS - Other Professional",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.16","Professional Services Subcapitation - Primary Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.17","Professional Services Subcapitation - Specialty Care",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.18","Professional Services Subcapitation - Other Professional",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.19","Part B Rx FFS",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.20","Pharmacy Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.21","OTC Pharmacy Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.22","Other Medicare Part B",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.23","Transportation FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.24","Transportation Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.25","Dental FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.26","Dental Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.27","Vision FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.28","Vision Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.29","Hearing FFS (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.30","Hearing Subcapitation (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.31","Suppl. Ben. Chpt 4 (Non-Covered)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.32","Other Non-Covered FFS",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$f":"E49+I49+M49+Q49","v":0},0,0]
[null,"2.33","Other Non-Covered Subcapitation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.34","COB/Subrg. (outside claim system)",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$f":"E51+I51+M51+Q51","v":0},{"$f":"F51+J51+N51+R51","v":0},{"$f":"G51+K51+O51+S51","v":0}]
[null,"2.35","Other Medicaid Expenses",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.36","Ending IBNP for Inpatient Hospital Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(U53:W53)","v":0},0,0,0]
[null,"2.37","Ending IBNP for Outpatient Hospital Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.38","Ending IBNP for Mental Health & Substance Abuse",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.39","Ending IBNP for Professional Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.40","Ending IBNP for Prescription Drugs",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.41","Ending IBNP for Transportation",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.42","Ending IBNP for Dental Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.43","Ending IBNP for Vision Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.44","Ending IBNP for Hearing Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.45","Ending IBNP for Other Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0,0]
[null,"2.46","Subtotal Benefit Expense before Reinsurance",{"$f":"SUM(D17:D62)","v":0},{"$f":"SUM(E17:E62)","v":0},{"$f":"SUM(F17:F62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Totals After Reinsurance","3.1","Reinsurance Premiums",{"$f":"SUM(E64:G64)","v":0},{"$nulls":3},{"$f":"SUM(I64:K64)","v":0},{"$nulls":3},{"$f":"SUM(M64:O64)","v":0},{"$nulls":3},{"$f":"SUM(Q64:S64)","v":0},{"$nulls":3},{"$f":"SUM(U64:W64)","v":0},{"$f":"E64+I64+M64+Q64","v":0},{"$f":"F64+J64+N64+R64","v":0},0]
[null,"3.2","Reinsurance Recoveries",{"$f":"SUM(E65:G65)","v":0},{"$nulls":3},{"$f":"SUM(I65:K65)","v":0},{"$nulls":3},{"$f":"SUM(M65:O65)","v":0},{"$nulls":3},{"$f":"SUM(Q65:S65)","v":0},{"$nulls":3},{"$f":"SUM(U65:W65)","v":0},0,0,0]
[null,"3.3","Net cost of Reinsurance",{"$f":"SUM(D64:D65)","v":0},{"$f":"SUM(E64:E65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R64:R65)","v":0},0,{"$f":"SUM(U66:W66)","v":0},{"$f":"E66+I66+M66+Q66","v":0},0,0]
[null,"3.4","Grand Total Medical Benefit Expense Net of Reinsurance",{"$f":"SUM(D63,D66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q63,Q66)","v":0},0,0,{"$f":"SUM(U67:W67)","v":0},{"$f":"E67+I67+M67+Q67","v":0},0,0]

{"sheet":"EndSum","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"DSNP Admin Summary","index":15,"n_rows":116,"n_cols":22,"rows_kept":116,"merged":[[7,0,7,6],[8,0,8,22],[9,0,10,2],[9,3,9,6],[9,7,9,10],[9,11,9,14],[9,15,9,18],[9,19,9,22],[11,0,17,0],[18,0,23,0],[30,0,30,22],[31,0,32,2],[31,3,31,6],[31,7,31,10],[31,11,31,14],[31,15,31,18],[31,19,31,22],[33,0,39,0],[40,0,45,0],[52,0,52,22],[53,0,54,2],[53,3,53,6],[53,7,53,10],[53,11,53,14],[53,15,53,18],[53,19,53,22],[55,0,61,0],[62,0,67,0],[74,0,74,22],[75,0,76,2],[75,3,75,6],[75,7,75,10],[75,11,75,14],[75,15,75,18],[75,19,75,22],[77,0,83,0],[84,0,89,0],[96,0,96,22],[97,0,98,2],[97,3,97,6],[97,7,97,10],[97,11,97,14],[97,15,97,18],[97,19,97,22],[99,0,105,0],[106,0,111,0]]}
["DUAL SPECIAL NEEDS PLAN -- ADMINISTRATIVE EXPENSE SCHEDULE - PLAN SUMMARY"]
[]
["Health Plan:",null,{"$f":"'DSNP Rev-Exp Summary'!C3","v":0}]
["Reporting Period:",null,{"$f":"'DSNP Rev-Exp Summary'!C4","v":0}]
["Paid Through:",null,{"$f":"'DSNP Rev-Exp Summary'!C5","v":0}]
["Statewide"]
[]
["Note: Refer to the Instructions tabs for the DSNP Revenue and Expense Schedule for a detailed explaination of each category."]
["SOUTH FLORIDA -  REGION 9"]
["Administrative Expenses, Government-Mandated Assessments, Taxes, and Fees ",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate"]
["Administrative Expenses","4.1","Salaries & Benefits",{"$f":"E12+F12","v":0},{"$nulls":3},{"$f":"I12+J12","v":0},{"$nulls":3},{"$f":"M12+N12","v":0},{"$nulls":3},{"$f":"Q12+R12","v":0},{"$nulls":3},{"$f":"U12+V12","v":0},{"$f":"E12+I12+M12+Q12","v":0},0]
[null,"4.2","Administrative Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.3","Information Systems",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.4","Marketing Expenses",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.5","General  Administration",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.6","Compliance/Regulatory",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.7","Total Administrative Expenses ",{"$f":"SUM(D12:D17)","v":0},{"$f":"SUM(E12:E17)","v":0},{"$f":"SUM(F12:F17)","v":0},null,{"$f":"SUM(H12:H17)","v":0},{"$f":"SUM(I12:I17)","v":0},{"$f":"SUM(J12:J17)","v":0},null,{"$f":"SUM(L12:L17)","v":0},{"$f":"SUM(M12:M17)","v":0},{"$f":"SUM(N12:N17)","v":0},null,{"$f":"SUM(P12:P17)","v":0},{"$f":"SUM(Q12:Q17)","v":0},{"$f":"SUM(R12:R17)","v":0},null,{"$f":"SUM(T12:T17)","v":0},{"$f":"SUM(U12:U17)","v":0},{"$f":"SUM(V12:V17)","v":0}]
["Government-Mandated Assessments, Taxes, and Fees Other Than Income Taxes","5.1","State Premium tax",{"$nulls":16},{"$f":"D19+H19+L19+P19","v":0}]
[null,"5.2","Department of Insurance Assessments",{"$nulls":16},{"$f":"D20+H20+L20+P20","v":0}]
[null,"5.3","Other 1",{"$nulls":16},{"$f":"D21+H21+L21+P21","v":0}]
[null,"5.4","Other 2",{"$nulls":16},{"$f":"D22+H22+L22+P22","v":0}]
[null,"5.5","Other 3",{"$nulls":16},{"$f":"D23+H23+L23+P23","v":0}]
[null,"5.6","Total ",{"$f":"SUM(D19:D23)","v":0},{"$nulls":3},{"$f":"SUM(H19:H23)","v":0},{"$nulls":3},{"$f":"SUM(L19:L23)","v":0},{"$nulls":3},{"$f":"SUM(P19:P23)","v":0},{"$nulls":3},{"$f":"SUM(T19:T23)","v":0}]
[null,"6","Grand Total Expenses"]
[null,"7","Underwriting Gain / (Loss)  --- AKA Pre-tax Earnings from Operations"]
[null,"8","Income Tax Expense",{"$nulls":16},{"$f":"D27+H27+L27+P27","v":0}]
[null,"9","Net Underwriting Gain (Loss) from Operations"]
[]
[]
["SOUTH FLORIDA - REGION 10"]
["Administrative Expenses, Government-Mandated Assessments, Taxes, and Fees ",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate"]
["Administrative Expenses","4.1","Salaries & Benefits",{"$f":"E34+F34","v":0},{"$nulls":3},{"$f":"I34+J34","v":0},{"$nulls":3},{"$f":"M34+N34","v":0},{"$nulls":3},{"$f":"Q34+R34","v":0},{"$nulls":3},{"$f":"U34+V34","v":0},{"$f":"E34+I34+M34+Q34","v":0},{"$f":"F34+J34+N34+R34","v":0}]
[null,"4.2","Administrative Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.3","Information Systems",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.4","Marketing Expenses",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.5","General  Administration",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.6","Compliance/Regulatory",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.7","Total Administrative Expenses ",{"$f":"SUM(D34:D39)","v":0},{"$f":"SUM(E34:E39)","v":0},{"$f":"SUM(F34:F39)","v":0},null,{"$f":"SUM(H34:H39)","v":0},{"$f":"SUM(I34:I39)","v":0},{"$f":"SUM(J34:J39)","v":0},null,{"$f":"SUM(L34:L39)","v":0},{"$f":"SUM(M34:M39)","v":0},{"$f":"SUM(N34:N39)","v":0},null,{"$f":"SUM(P34:P39)","v":0},{"$f":"SUM(Q34:Q39)","v":0},{"$f":"SUM(R34:R39)","v":0},null,{"$f":"SUM(T34:T39)","v":0},{"$f":"SUM(U34:U39)","v":0},{"$f":"SUM(V34:V39)","v":0}]
["Government-Mandated Assessments, Taxes, and Fees Other Than Income Taxes","5.1","State Premium tax",{"$nulls":16},{"$f":"D41+H41+L41+P41","v":0}]
[null,"5.2","Department of Insurance Assessments",{"$nulls":16},{"$f":"D42+H42+L42+P42","v":0}]
[null,"5.3","Other 1",{"$nulls":16},{"$f":"D43+H43+L43+P43","v":0}]
[null,"5.4","Other 2",{"$nulls":16},{"$f":"D44+H44+L44+P44","v":0}]
[null,"5.5","Other 3",{"$nulls":16},{"$f":"D45+H45+L45+P45","v":0}]
[null,"5.6","Total ",{"$f":"SUM(D41:D45)","v":0},{"$nulls":3},{"$f":"SUM(H41:H45)","v":0},{"$nulls":3},{"$f":"SUM(L41:L45)","v":0},{"$nulls":3},{"$f":"SUM(P41:P45)","v":0},{"$nulls":3},{"$f":"SUM(T41:T45)","v":0}]
[null,"6","Grand Total Expenses"]
[null,"7","Underwriting Gain / (Loss)  --- AKA Pre-tax Earnings from Operations"]
[null,"8","Income Tax Expense",{"$nulls":16},{"$f":"D49+H49+L49+P49","v":0}]
[null,"9","Net Underwriting Gain (Loss) from Operations"]
[]
[]
["SOUTH FLORIDA - REGION 11"]
["Administrative Expenses, Government-Mandated Assessments, Taxes, and Fees ",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate"]
["Administrative Expenses","4.1","Salaries & Benefits",{"$f":"E56+F56","v":0},{"$nulls":3},{"$f":"I56+J56","v":0},{"$nulls":3},{"$f":"M56+N56","v":0},{"$nulls":3},{"$f":"Q56+R56","v":0},{"$nulls":3},{"$f":"U56+V56","v":0},{"$f":"E56+I56+M56+Q56","v":0},{"$f":"F56+J56+N56+R56","v":0}]
[null,"4.2","Administrative Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.3","Information Systems",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.4","Marketing Expenses",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.5","General  Administration",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.6","Compliance/Regulatory",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.7","Total Administrative Expenses ",{"$f":"SUM(D56:D61)","v":0},{"$f":"SUM(E56:E61)","v":0},{"$f":"SUM(F56:F61)","v":0},null,{"$f":"SUM(H56:H61)","v":0},{"$f":"SUM(I56:I61)","v":0},{"$f":"SUM(J56:J61)","v":0},null,{"$f":"SUM(L56:L61)","v":0},{"$f":"SUM(M56:M61)","v":0},{"$f":"SUM(N56:N61)","v":0},null,{"$f":"SUM(P56:P61)","v":0},{"$f":"SUM(Q56:Q61)","v":0},{"$f":"SUM(R56:R61)","v":0},null,{"$f":"SUM(T56:T61)","v":0},{"$f":"SUM(U56:U61)","v":0},{"$f":"SUM(V56:V61)","v":0}]
["Government-Mandated Assessments, Taxes, and Fees Other Than Income Taxes","5.1","State Premium tax",{"$nulls":16},{"$f":"D63+H63+L63+P63","v":0}]
[null,"5.2","Department of Insurance Assessments",{"$nulls":16},{"$f":"D64+H64+L64+P64","v":0}]
[null,"5.3","Other 1",{"$nulls":16},{"$f":"D65+H65+L65+P65","v":0}]
[null,"5.4","Other 2",{"$nulls":16},{"$f":"D66+H66+L66+P66","v":0}]
[null,"5.5","Other 3",{"$nulls":16},{"$f":"D67+H67+L67+P67","v":0}]
[null,"5.6","Total ",{"$f":"SUM(D63:D67)","v":0},{"$nulls":3},{"$f":"SUM(H63:H67)","v":0},{"$nulls":3},{"$f":"SUM(L63:L67)","v":0},{"$nulls":3},{"$f":"SUM(P63:P67)","v":0},{"$nulls":3},{"$f":"SUM(T63:T67)","v":0}]
[null,"6","Grand Total Expenses"]
[null,"7","Underwriting Gain / (Loss)  --- AKA Pre-tax Earnings from Operations"]
[null,"8","Income Tax Expense",{"$nulls":16},{"$f":"D71+H71+L71+P71","v":0}]
[null,"9","Net Underwriting Gain (Loss) from Operations"]
[]
[]
["REST OF FLORIDA"]
["Administrative Expenses, Government-Mandated Assessments, Taxes, and Fees ",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate"]
["Administrative Expenses","4.1","Salaries & Benefits",{"$f":"E78+F78","v":0},{"$nulls":3},{"$f":"I78+J78","v":0},{"$nulls":3},{"$f":"M78+N78","v":0},{"$nulls":3},{"$f":"Q78+R78","v":0},{"$nulls":3},{"$f":"U78+V78","v":0},{"$f":"E78+I78+M78+Q78","v":0},0]
[null,"4.2","Administrative Services",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.3","Information Systems",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.4","Marketing Expenses",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.5","General  Administration",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.6","Compliance/Regulatory",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,0,0]
[null,"4.7","Total Administrative Expenses ",{"$f":"SUM(D78:D83)","v":0},{"$f":"SUM(E78:E83)","v":0},{"$f":"SUM(F78:F83)","v":0},null,{"$f":"SUM(H78:H83)","v":0},{"$f":"SUM(I78:I83)","v":0},{"$f":"SUM(J78:J83)","v":0},null,{"$f":"SUM(L78:L83)","v":0},{"$f":"SUM(M78:M83)","v":0},{"$f":"SUM(N78:N83)","v":0},null,{"$f":"SUM(P78:P83)","v":0},{"$f":"SUM(Q78:Q83)","v":0},{"$f":"SUM(R78:R83)","v":0},null,{"$f":"SUM(T78:T83)","v":0},{"$f":"SUM(U78:U83)","v":0},{"$f":"SUM(V78:V83)","v":0}]
["Government-Mandated Assessments, Taxes, and Fees Other Than Income Taxes","5.1","State Premium tax",{"$nulls":16},{"$f":"D85+H85+L85+P85","v":0}]
[null,"5.2","Department of Insurance Assessments",{"$nulls":16},{"$f":"D86+H86+L86+P86","v":0}]
[null,"5.3","Other 1",{"$nulls":16},{"$f":"D87+H87+L87+P87","v":0}]
[null,"5.4","Other 2",{"$nulls":16},{"$f":"D88+H88+L88+P88","v":0}]
[null,"5.5","Other 3",{"$nulls":16},{"$f":"D89+H89+L89+P89","v":0}]
[null,"5.6","Total ",{"$f":"SUM(D85:D89)","v":0},{"$nulls":3},{"$f":"SUM(H85:H89)","v":0},{"$nulls":3},{"$f":"SUM(L85:L89)","v":0},{"$nulls":3},{"$f":"SUM(P85:P89)","v":0},{"$nulls":3},{"$f":"SUM(T85:T89)","v":0}]
[null,"6","Grand Total Expenses"]
[null,"7","Underwriting Gain / (Loss)  --- AKA Pre-tax Earnings from Operations"]
[null,"8","Income Tax Expense",{"$nulls":16},{"$f":"D93+H93+L93+P93","v":0}]
[null,"9","Net Underwriting Gain (Loss) from Operations"]
[]
[]
["PLAN TOTAL"]
["Administrative Expenses, Government-Mandated Assessments, Taxes, and Fees ",null,null,"JANUARY - MARCH (Q1)",{"$nulls":3},"APRIL - JUNE (Q2)",{"$nulls":3},"JULY - SEPTEMBER (Q3)",{"$nulls":3},"OCTOBER - DECEMBER (Q4)",{"$nulls":3},"TOTAL (TO DATE)"]
[{"$nulls":3},"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate",null,"Total","Health Plan","Corporate"]
["Administrative Expenses","4.1","Salaries & Benefits",{"$f":"E100+F100","v":0},{"$f":"E78+E56+E34+E12","v":0},{"$f":"F78+F56+F34+F12","v":0},null,{"$f":"I100+J100","v":0},{"$f":"I78+I56+I34+I12","v":0},{"$f":"J78+J56+J34+J12","v":0},null,{"$f":"M100+N100","v":0},{"$f":"M78+M56+M34+M12","v":0},{"$f":"N78+N56+N34+N12","v":0},null,{"$f":"Q100+R100","v":0},{"$f":"Q78+Q56+Q34+Q12","v":0},{"$f":"R78+R56+R34+R12","v":0},null,{"$f":"U100+V100","v":0},{"$f":"E100+I100+M100+Q100","v":0},{"$f":"F100+J100+N100+R100","v":0}]
[null,"4.2","Administrative Services",0,{"$f":"E79+E57+E35+E13","v":0},{"$f":"F79+F57+F35+F13","v":0},null,0,{"$f":"I79+I57+I35+I13","v":0},0,null,0,{"$f":"M79+M57+M35+M13","v":0},0,null,0,{"$f":"Q79+Q57+Q35+Q13","v":0},0,null,0,{"$f":"E101+I101+M101+Q101","v":0},0]
[null,"4.3","Information Systems",0,0,{"$f":"F80+F58+F36+F14","v":0},null,0,{"$f":"I80+I58+I36+I14","v":0},0,null,0,0,0,null,0,{"$f":"Q80+Q58+Q36+Q14","v":0},0,null,0,0,0]
[null,"4.4","Marketing Expenses",0,0,{"$f":"F81+F59+F37+F15","v":0},null,0,{"$f":"I81+I59+I37+I15","v":0},0,null,0,0,0,null,0,{"$f":"Q81+Q59+Q37+Q15","v":0},0,null,0,0,0]
[null,"4.5","General  Administration",0,0,{"$f":"F82+F60+F38+F16","v":0},null,0,{"$f":"I82+I60+I38+I16","v":0},0,null,0,0,0,null,0,{"$f":"Q82+Q60+Q38+Q16","v":0},0,null,0,0,0]
[null,"4.6","Compliance/Regulatory",0,0,{"$f":"F83+F61+F39+F17","v":0},null,0,{"$f":"I83+I61+I39+I17","v":0},0,null,0,0,0,null,0,{"$f":"Q83+Q61+Q39+Q17","v":0},0,null,0,0,0]
[null,"4.7","Total Administrative Expenses ",{"$f":"SUM(D100:D105)","v":0},0,{"$f":"F84+F62+F40+F18","v":0},null,{"$f":"SUM(H100:H105)","v":0},{"$f":"I84+I62+I40+I18","v":0},0,null,{"$f":"SUM(L100:L105)","v":0},0,0,null,{"$f":"SUM(P100:P105)","v":0},{"$f":"Q84+Q62+Q40+Q18","v":0},0,null,{"$f":"SUM(T100:T105)","v":0},{"$f":"SUM(U100:U105)","v":0},{"$f":"SUM(V100:V105)","v":0}]
["Government-Mandated Assessments, Taxes, and Fees Other Than Income Taxes","5.1","State Premium tax",{"$f":"D85+D63+D41+D19","v":0},{"$nulls":3},{"$f":"H85+H63+H41+H19","v":0},{"$nulls":3},{"$f":"L85+L63+L41+L19","v":0},{"$nulls":3},{"$f":"P85+P63+P41+P19","v":0},{"$nulls":3},{"$f":"T85+T63+T41+T19","v":0}]
[null,"5.2","Department of Insurance Assessments",{"$f":"D86+D64+D42+D20","v":0},{"$nulls":3},{"$f":"H86+H64+H42+H20","v":0},{"$nulls":3},{"$f":"L86+L64+L42+L20","v":0},{"$nulls":3},{"$f":"P86+P64+P42+P20","v":0},{"$nulls":3},0]
[null,"5.3","Other 1",{"$f":"D87+D65+D43+D21","v":0},{"$nulls":3},{"$f":"H87+H65+H43+H21","v":0},{"$nulls":3},{"$f":"L87+L65+L43+L21","v":0},{"$nulls":3},{"$f":"P87+P65+P43+P21","v":0},{"$nulls":3},0]
[null,"5.4","Other 2",{"$f":"D88+D66+D44+D22","v":0},{"$nulls":3},{"$f":"H88+H66+H44+H22","v":0},{"$nulls":3},{"$f":"L88+L66+L44+L22","v":0},{"$nulls":3},{"$f":"P88+P66+P44+P22","v":0},{"$nulls":3},0]
[null,"5.5","Other 3",{"$f":"D89+D67+D45+D23","v":0},{"$nulls":3},{"$f":"H89+H67+H45+H23","v":0},{"$nulls":3},{"$f":"L89+L67+L45+L23","v":0},{"$nulls":3},{"$f":"P89+P67+P45+P23","v":0},{"$nulls":3},0]
[null,"5.6","Total ",{"$f":"SUM(D107:D111)","v":0},{"$nulls":3},{"$f":"SUM(H107:H111)","v":0},{"$nulls":3},{"$f":"SUM(L107:L111)","v":0},{"$nulls":3},{"$f":"SUM(P107:P111)","v":0},{"$nulls":3},{"$f":"SUM(T107:T111)","v":0}]
[null,"6","Grand Total Expenses"]
[null,"7","Underwriting Gain / (Loss)  --- AKA Pre-tax Earnings from Operations"]
[null,"8","Income Tax Expense",{"$f":"D93+D71+D49+D27","v":0},{"$nulls":3},{"$f":"H93+H71+H49+H27","v":0},{"$nulls":3},{"$f":"L93+L71+L49+L27","v":0},{"$nulls":3},{"$f":"P93+P71+P49+P27","v":0},{"$nulls":3},{"$f":"D115+H115+L115+P115","v":0}]
[null,"9","Net Underwriting Gain (Loss) from Operations"]

{"sheet":"DSNP Subcap Summary","index":16,"n_rows":104,"n_cols":14,"rows_kept":104,"merged":[[7,0,8,2],[7,3,8,4],[7,5,8,6],[7,7,8,8],[7,9,8,10],[7,11,8,11],[7,12,8,13],[11,0,17,0],[18,0,24,0],[25,0,46,0],[47,0,53,0],[54,0,60,0],[61,0,67,0],[68,0,74,0],[75,0,81,0],[82,0,88,0],[89,0,95,0],[96,0,102,0]]}
["DUAL SPECIAL NEEDS PLAN -- SUBCAPITATION SCHEDULE - PLAN SUMMARY"]
[]
["Health Plan:",null,{"$f":"'DSNP Rev-Exp Summary'!C3","v":0}]
["Reporting Period:",null,{"$f":"'DSNP Rev-Exp Summary'!C4","v":0}]
["Paid Through:",null,{"$f":"'DSNP Rev-Exp Summary'!C5","v":0}]
["Statewide"]
[]
[{"$nulls":3},"JANUARY - MARCH (Q1)",null,"APRIL - JUNE (Q2)",null,"JULY - SEPTEMBER (Q3)",null,"OCTOBER - DECEMBER (Q4)",null,"Prior Year Adjustments","TOTAL (TO DATE)"]
[]
[{"$nulls":3},"MM","Amount","MM","Amount","MM","Amount","MM","Amount","Amount","MM","Amount"]
["DSNP EXPENSES"]
["DME / Prosthetics / Diabetes","1.1","Vendor #1",{"$nulls":9},{"$f":"D12+F12+H12+J12","v":0},{"$f":"E12+G12+I12+K12+L12","v":0}]
[null,"1.2","Vendor #2",{"$nulls":9},{"$f":"D13+F13+H13+J13","v":0},0]
[null,"1.3","Vendor #3",{"$nulls":9},0,0]
[null,"1.4","Vendor #4",{"$nulls":9},0,0]
[null,"1.5","Vendor #5",{"$nulls":9},0,0]
[null,"1.6","All Others",{"$nulls":9},0,0]
[null,"1.7","Total Subcap DME / Prosthetics / Diabetes",null,{"$f":"SUM(E12:E17)","v":0},null,{"$f":"SUM(G12:G17)","v":0},null,{"$f":"SUM(I12:I17)","v":0},null,{"$f":"SUM(K12:K17)","v":0},{"$f":"SUM(L12:L17)","v":0},null,{"$f":"SUM(N12:N17)","v":0}]
["Hospital Services","2.01","Vendor #1",{"$nulls":9},{"$f":"D19+F19+H19+J19","v":0},{"$f":"E19+G19+I19+K19+L19","v":0}]
[null,"2.02","Vendor #2",{"$nulls":9},{"$f":"D20+F20+H20+J20","v":0},0]
[null,"2.03","Vendor #3",{"$nulls":9},0,0]
[null,"2.04","Vendor #4",{"$nulls":9},0,0]
[null,"2.05","Vendor #5",{"$nulls":9},0,0]
[null,"2.06","All Others",{"$nulls":9},0,0]
[null,"2.07","Total Subcap Hospital Services",null,{"$f":"SUM(E19:E24)","v":0},null,{"$f":"SUM(G19:G24)","v":0},null,{"$f":"SUM(I19:I24)","v":0},null,{"$f":"SUM(K19:K24)","v":0},{"$f":"SUM(L19:L24)","v":0},null,{"$f":"SUM(N19:N24)","v":0}]
["Professional Services",3.01,"Primary Care - Vendor #1",{"$nulls":9},{"$f":"D26+F26+H26+J26","v":0},{"$f":"E26+G26+I26+K26+L26","v":0}]
[null,3.02,"Primary Care - Vendor #2",{"$nulls":9},0,0]
[null,3.03,"Primary Care - Vendor #3",{"$nulls":9},0,0]
[null,3.04,"Primary Care - Vendor #4",{"$nulls":9},0,0]
[null,3.05,"Primary Care - Vendor #5",{"$nulls":9},0,0]
[null,3.06,"Primary Care - All Others",{"$nulls":9},0,0]
[null,3.07,"Subtotal Primary Care",null,{"$f":"SUM(E26:E31)","v":0},null,{"$f":"SUM(G26:G31)","v":0},null,{"$f":"SUM(I26:I31)","v":0},null,{"$f":"SUM(K26:K31)","v":0},{"$f":"SUM(L26:L31)","v":0},null,{"$f":"SUM(N26:N31)","v":0}]
[null,3.08,"Specialty Care - Vendor #1",{"$nulls":9},{"$f":"D33+F33+H33+J33","v":0},{"$f":"E33+G33+I33+K33+L33","v":0}]
[null,3.09,"Specialty Care - Vendor #2",{"$nulls":9},0,0]
[null,3.1,"Specialty Care - Vendor #3",{"$nulls":9},0,0]
[null,3.11,"Specialty Care - Vendor #4",{"$nulls":9},0,0]
[null,3.12,"Specialty Care - Vendor #5",{"$nulls":9},0,0]
[null,3.13,"Specialty Care - All Others",{"$nulls":9},0,0]
[null,3.14,"Subtotal Specialty Care",null,{"$f":"SUM(E33:E38)","v":0},null,{"$f":"SUM(G33:G38)","v":0},null,{"$f":"SUM(I33:I38)","v":0},null,{"$f":"SUM(K33:K38)","v":0},{"$f":"SUM(L33:L38)","v":0},null,{"$f":"SUM(N33:N38)","v":0}]
[null,3.15,"Other Professional - Vendor #1",{"$nulls":9},{"$f":"D40+F40+H40+J40","v":0},{"$f":"E40+G40+I40+K40+L40","v":0}]
[null,3.16,"Other Professional - Vendor #2",{"$nulls":9},0,0]
[null,3.17,"Other Professional - Vendor #3",{"$nulls":9},0,0]
[null,3.18,"Other Professional - Vendor #4",{"$nulls":9},0,0]
[null,3.19,"Other Professional - Vendor #5",{"$nulls":9},0,0]
[null,3.2,"Other Professional - All Others",{"$nulls":9},0,0]
[null,3.21,"Subtotal Other Professional",null,{"$f":"SUM(E40:E45)","v":0},null,{"$f":"SUM(G40:G45)","v":0},null,{"$f":"SUM(I40:I45)","v":0},null,{"$f":"SUM(K40:K45)","v":0},{"$f":"SUM(L40:L45)","v":0},{"$f":"SUM(M40:M45)","v":0},{"$f":"SUM(N40:N45)","v":0}]
[null,3.22,"Total Subcap Professional Services",null,{"$f":"E32+E39+E46","v":0},null,{"$f":"G32+G39+G46","v":0},null,{"$f":"I32+I39+I46","v":0},null,{"$f":"K32+K39+K46","v":0},{"$f":"L32+L39+L46","v":0},null,{"$f":"N32+N39+N46","v":0}]
["Mental Health","4.1","Vendor #1",{"$nulls":9},{"$f":"D48+F48+H48+J48","v":0},{"$f":"E48+G48+I48+K48+L48","v":0}]
[null,"4.2","Vendor #2",{"$nulls":9},0,0]
[null,"4.3","Vendor #3",{"$nulls":9},0,0]
[null,"4.4","Vendor #4",{"$nulls":9},0,0]
[null,"4.5","Vendor #5",{"$nulls":9},0,0]
[null,"4.6","All Others",{"$nulls":9},0,0]
[null,"4.7","Total Subcap Mental Health Services",null,{"$f":"SUM(E48:E53)","v":0},null,{"$f":"SUM(G48:G53)","v":0},null,{"$f":"SUM(I48:I53)","v":0},null,{"$f":"SUM(K48:K53)","v":0},{"$f":"SUM(L48:L53)","v":0},null,{"$f":"SUM(N48:N53)","v":0}]
["Dental","5.1","Vendor #1",{"$nulls":9},{"$f":"D55+F55+H55+J55","v":0},{"$f":"E55+G55+I55+K55+L55","v":0}]
[null,"5.2","Vendor #2",{"$nulls":9},0,0]
[null,"5.3","Vendor #3",{"$nulls":9},0,0]
[null,"5.4","Vendor #4",{"$nulls":9},0,0]
[null,"5.5","Vendor #5",{"$nulls":9},0,0]
[null,"5.6","All Others",{"$nulls":9},0,0]
[null,"5.7","Total Subcap Dental Services",null,{"$f":"SUM(E55:E60)","v":0},null,{"$f":"SUM(G55:G60)","v":0},null,{"$f":"SUM(I55:I60)","v":0},null,{"$f":"SUM(K55:K60)","v":0},{"$f":"SUM(L55:L60)","v":0},null,{"$f":"SUM(N55:N60)","v":0}]
["Transportation","6.1","Vendor #1",{"$nulls":9},{"$f":"D62+F62+H62+J62","v":0},{"$f":"E62+G62+I62+K62+L62","v":0}]
[null,"6.2","Vendor #2",{"$nulls":9},0,0]
[null,"6.3","Vendor #3",{"$nulls":9},0,0]
[null,"6.4","Vendor #4",{"$nulls":9},0,0]
[null,"6.5","Vendor #5",{"$nulls":9},0,0]
[null,"6.6","All Others",{"$nulls":9},0,0]
[null,"6.7","Total Subcap Transp. Services",null,{"$f":"SUM(E62:E67)","v":0},null,{"$f":"SUM(G62:G67)","v":0},null,{"$f":"SUM(I62:I67)","v":0},null,{"$f":"SUM(K62:K67)","v":0},{"$f":"SUM(L62:L67)","v":0},null,{"$f":"SUM(N62:N67)","v":0}]
["Pharmacy","7.1","Vendor #1",{"$nulls":9},{"$f":"D69+F69+H69+J69","v":0},{"$f":"E69+G69+I69+K69+L69","v":0}]
[null,"7.2","Vendor #2",{"$nulls":9},0,0]
[null,"7.3","Vendor #3",{"$nulls":9},0,0]
[null,"7.4","Vendor #4",{"$nulls":9},0,0]
[null,"7.5","Vendor #5",{"$nulls":9},0,0]
[null,"7.6","All Others",{"$nulls":9},0,0]
[null,"7.7","Total Subcap Pharmacy Services",null,{"$f":"SUM(E69:E74)","v":0},null,{"$f":"SUM(G69:G74)","v":0},null,{"$f":"SUM(I69:I74)","v":0},null,{"$f":"SUM(K69:K74)","v":0},{"$f":"SUM(L69:L74)","v":0},null,{"$f":"SUM(N69:N74)","v":0}]
["OTC Pharmacy",8.1,"Service Type, Vendor #1",{"$nulls":9},{"$f":"D76+F76+H76+J76","v":0},{"$f":"E76+G76+I76+K76+L76","v":0}]
[null,8.2,"Service Type, Vendor #2",{"$nulls":9},0,0]
[null,8.3,"Service Type, Vendor #3",{"$nulls":9},0,0]
[null,8.4,"Service Type, Vendor #4",{"$nulls":9},0,0]
[null,8.5,"Service Type, Vendor #5",{"$nulls":9},0,0]
[null,8.6,"All Others",{"$nulls":9},0,0]
[null,8.7,"Total Subcap OTC Pharmacy",null,{"$f":"SUM(E76:E81)","v":0},null,{"$f":"SUM(G76:G81)","v":0},null,{"$f":"SUM(I76:I81)","v":0},null,{"$f":"SUM(K76:K81)","v":0},{"$f":"SUM(L76:L81)","v":0},null,{"$f":"SUM(N76:N81)","v":0}]
["Vision (Non-Covered)",9.1,"Service Type, Vendor #1",{"$nulls":9},{"$f":"D83+F83+H83+J83","v":0},{"$f":"E83+G83+I83+K83+L83","v":0}]
[null,9.2,"Service Type, Vendor #2",{"$nulls":9},0,0]
[null,9.3,"Service Type, Vendor #3",{"$nulls":9},0,0]
[null,9.4,"Service Type, Vendor #4",{"$nulls":9},0,0]
[null,9.5,"Service Type, Vendor #5",{"$nulls":9},0,0]
[null,9.6,"All Others",{"$nulls":9},0,0]
[null,9.7,"Total Subcap Vision (Non-Covered)",null,{"$f":"SUM(E83:E88)","v":0},null,{"$f":"SUM(G83:G88)","v":0},null,{"$f":"SUM(I83:I88)","v":0},null,{"$f":"SUM(K83:K88)","v":0},{"$f":"SUM(L83:L88)","v":0},null,{"$f":"SUM(N83:N88)","v":0}]
["Hearing (Non-Covered)",10.1,"Service Type, Vendor #1",{"$nulls":9},{"$f":"D90+F90+H90+J90","v":0},{"$f":"E90+G90+I90+K90+L90","v":0}]
[null,10.2,"Service Type, Vendor #2",{"$nulls":9},0,0]
[null,10.3,"Service Type, Vendor #3",{"$nulls":9},0,0]
[null,10.4,"Service Type, Vendor #4",{"$nulls":9},0,0]
[null,10.5,"Service Type, Vendor #5",{"$nulls":9},0,0]
[null,10.6,"All Others",{"$nulls":9},0,0]
[null,10.7,"Total Subcap Hearing (Non-Covered)",null,{"$f":"SUM(E90:E95)","v":0},null,{"$f":"SUM(G90:G95)","v":0},null,{"$f":"SUM(I90:I95)","v":0},null,{"$f":"SUM(K90:K95)","v":0},{"$f":"SUM(L90:L95)","v":0},null,{"$f":"SUM(N90:N95)","v":0}]
["Other Services",11.1,"Service Type, Vendor #1",{"$nulls":9},{"$f":"D97+F97+H97+J97","v":0},{"$f":"E97+G97+I97+K97+L97","v":0}]
[null,11.2,"Service Type, Vendor #2",{"$nulls":9},0,0]
[null,11.3,"Service Type, Vendor #3",{"$nulls":9},0,0]
[null,11.4,"Service Type, Vendor #4",{"$nulls":9},0,0]
[null,11.5,"Service Type, Vendor #5",{"$nulls":9},0,0]
[null,11.6,"All Others",{"$nulls":9},0,0]
[null,11.7,"Total Subcap Other Services",null,{"$f":"SUM(E97:E102)","v":0},null,{"$f":"SUM(G97:G102)","v":0},null,{"$f":"SUM(I97:I102)","v":0},null,{"$f":"SUM(K97:K102)","v":0},{"$f":"SUM(L97:L102)","v":0},null,{"$f":"SUM(N97:N102)","v":0}]
[null,"12.0","Grand Total, Subcap Services",null,{"$f":"E18+E25+E47+E54+E61+E68+E75+E82+E89+E96+E103","v":0},null,{"$f":"G18+G25+G47+G54+G61+G68+G75+G82+G89+G96+G103","v":0},null,{"$f":"I18+I25+I47+I54+I61+I68+I75+I82+I89+I96+I103","v":0},null,{"$f":"K18+K25+K47+K54+K61+K68+K75+K82+K89+K96+K103","v":0},{"$f":"L18+L25+L47+L54+L61+L68+L75+L82+L89+L96+L103","v":0},null,{"$f":"N18+N25+N47+N54+N61+N68+N75+N82+N89+N96+N103","v":0}]

{"sheet":"Notes","index":17,"n_rows":16,"n_cols":6,"rows_kept":16}
["Notes - Other Revenue"]
[]
[]
["DSNP Rev-Exp Line 1.2 - Other Revenue (add rows as needed)"]
["Description ","Q1","Q2","Q3","Q4","Total (To Date)"]
[{"$nulls":5},{"$f":"SUM(B6:E6)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
["1.2 Other Revenue (Total)",{"$f":"SUM(B6:B12)","v":0},{"$f":"SUM(C6:C12)","v":0},{"$f":"SUM(D6:D12)","v":0},{"$f":"SUM(E6:E12)","v":0},{"$f":"SUM(F6:F12)","v":0}]
[]
[]
["Additional Notes - Report as Needed"]