{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Contents","A. Front Page","B. Supp Telehealth Data","C. Expenditures Data","D. Member Months Data","E. Summary","Reference Tables","Payer Names","System Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Contents","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Primary Care and Behavioral Health Expenditures"]
["Data Submission Workbook: 2024 Reporting Cycle"]
[]
["CHIA Submissions Portal"]
["PCBH Data Specifications"]
[]
[]
["This workbook contains the following tabs:"]
[]
["Tab Name","Contents"]
["A. Front Page","Payer Data Entry: Overview of File and Data Verification"]
["B. Supp Telehealth Data","Payer Data Entry: Telehealth Expenditures"]
["C. Expenditures Data","Payer Data Entry: Physician Group PCBH Expenditures Data"]
["D. Member Month Data","Payer Data Entry: Physician Group Member Month Data"]
["E. Summary","Automated Calculation"]
["Reference Tables","Lookup Tables for Data Element Response Codes"]

{"sheet":"A. Front Page","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[8,1,8,2],[15,1,15,2]]}
["Primary Care and Behavioral Health Expenditures"]
["A. File Overview and Payer Verification "]
[]
[]
[null,"I verify that the information in this workbook is accurate."]
["Contact Name:",null,"[Input Required]"]
["Contact Email:",null,"[Input Required]"]
[]
[null,"Table A.1: File Overview",null,"[Input Required]"]
[null,"Payer Name  *",{"$f":"IF(ISBLANK(iPayer), \"\",INDEX(PayersList,iPayer,2))","v":"Select Payer:"}]
[null,"Payer OrgID",{"$f":"IF(VLOOKUP(C10, 'Payer Names'!B1:D22, 3, FALSE)=0, \"\", VLOOKUP(C10, 'Payer Names'!B1:D22, 3, FALSE))","v":""}]
[null,"Submission Year    *"]
[null,"Reporting Year    *"]
[null,"Claims Paid Through Date   *"]
[]
[null,"Table A.2: Additional Data Confirmation                                                                                                                                                                                                                                ",null,"[Input Required]"]
[null,"Does the data include Massachusetts residents only?   *"]
[null,"Is the data limited only to members  for whom the payer is the primary payer?    *"]
[null,"File Comments (including any internal methods used to allocate non-claims payments) "]

{"sheet":"B. Supp Telehealth Data","index":2,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Primary Care and Behavioral Health Expenditures"]
["B. Telehealth Supplemental Data"]
["Reporting Year","Insurance Category","Service Type","Telehealth Expenditures "]

{"sheet":"C. Expenditures Data","index":3,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Primary Care and Behavioral Health Expenditures"]
["C. Physician Group Primary Care and Behavioral Health Expenditure Data"]
["Submission Type","Reporting Year","Physician Group OrgID ","Insurance Category Code ","Product Type","PCP Type","Age Group","MassHealth ACO Indicator","GIC Indicator ","Service Type","Spending Service Category","Provider Type","Expenditures: Incurred Expenses","Expenditures: Member Cost Share"]

{"sheet":"D. Member Months Data","index":4,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Primary Care and Behavioral Health Expenditures"]
["D. Physician Group Membership Data"]
["Submission Type","Reporting Year","Physician Group OrgID ","Insurance Category Code ","Product Type","PCP Type","Age Group","MassHealth ACO Indicator","GIC Indicator ","Member Months","MH Member Months","SUD Member Months"]

{"sheet":"E. Summary","index":5,"n_rows":113,"n_cols":13,"rows_kept":113,"cut":false,"hidden":false,"merged":[[60,0,60,9],[87,0,87,9],[0,0,0,12],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,12],[33,0,33,9]]}
["Data Check - Expenditures and Member Month Row Match"]
["Counts the unique records based on columns A:I"]
["Expenditures Data: ",null,{"$f":"ROWS(_xlfn.UNIQUE('C. Expenditures Data'!A4:I10001))-1","v":0}]
["Member Month Data: ",null,{"$f":"ROWS(_xlfn.UNIQUE('D. Member Months Data'!A4:I10001))-1","v":0}]
[]
["Data Summary - Service Type"]
["Year","Insurance Category ","Code","Member Months  ","Total Expenses","Total PMPM ","MH PMPM","SUD PMPM","PC PMPM","Mental Health","Substance Use Disorder","Primary Care","All Other Services"]
[2021,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A8,'D. Member Months Data'!D:D,C8)","v":0},{"$f":"SUM(J8:M8)","v":0},{"$f":"IFERROR(E8/D8,\"0\")","v":"0"},{"$f":"IFERROR(J8/D8,\"0\")","v":"0"},{"$f":"IFERROR(K8/D8,\"0\")","v":"0"},{"$f":"IFERROR(L8/D8,\"0\")","v":"0"},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A8,'C. Expenditures Data'!D:D,'E. Summary'!C8,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A8,'C. Expenditures Data'!D:D,'E. Summary'!C8,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A8,'C. Expenditures Data'!D:D,'E. Summary'!C8,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A8,'C. Expenditures Data'!D:D,'E. Summary'!C8,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A8,'C. Expenditures Data'!D:D,'E. Summary'!C8,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A8,'C. Expenditures Data'!D:D,'E. Summary'!C8,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A8,'C. Expenditures Data'!D:D,'E. Summary'!C8,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A8,'C. Expenditures Data'!D:D,'E. Summary'!C8,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2021,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A9,'D. Member Months Data'!D:D,C9)","v":0},0,"0","0",{"$f":"IFERROR(K9/D9,\"0\")","v":"0"},{"$f":"IFERROR(L9/D9,\"0\")","v":"0"},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A9,'C. Expenditures Data'!D:D,'E. Summary'!C9,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A9,'C. Expenditures Data'!D:D,'E. Summary'!C9,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A9,'C. Expenditures Data'!D:D,'E. Summary'!C9,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A9,'C. Expenditures Data'!D:D,'E. Summary'!C9,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A9,'C. Expenditures Data'!D:D,'E. Summary'!C9,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A9,'C. Expenditures Data'!D:D,'E. Summary'!C9,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A9,'C. Expenditures Data'!D:D,'E. Summary'!C9,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A9,'C. Expenditures Data'!D:D,'E. Summary'!C9,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2021,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A10,'D. Member Months Data'!D:D,C10)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A10,'C. Expenditures Data'!D:D,'E. Summary'!C10,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A10,'C. Expenditures Data'!D:D,'E. Summary'!C10,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A10,'C. Expenditures Data'!D:D,'E. Summary'!C10,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A10,'C. Expenditures Data'!D:D,'E. Summary'!C10,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A10,'C. Expenditures Data'!D:D,'E. Summary'!C10,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A10,'C. Expenditures Data'!D:D,'E. Summary'!C10,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A10,'C. Expenditures Data'!D:D,'E. Summary'!C10,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A10,'C. Expenditures Data'!D:D,'E. Summary'!C10,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2021,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A11,'D. Member Months Data'!D:D,C11)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A11,'C. Expenditures Data'!D:D,'E. Summary'!C11,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A11,'C. Expenditures Data'!D:D,'E. Summary'!C11,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A11,'C. Expenditures Data'!D:D,'E. Summary'!C11,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A11,'C. Expenditures Data'!D:D,'E. Summary'!C11,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A11,'C. Expenditures Data'!D:D,'E. Summary'!C11,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A11,'C. Expenditures Data'!D:D,'E. Summary'!C11,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A11,'C. Expenditures Data'!D:D,'E. Summary'!C11,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A11,'C. Expenditures Data'!D:D,'E. Summary'!C11,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2021,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A12,'D. Member Months Data'!D:D,C12)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A12,'C. Expenditures Data'!D:D,'E. Summary'!C12,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A12,'C. Expenditures Data'!D:D,'E. Summary'!C12,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A12,'C. Expenditures Data'!D:D,'E. Summary'!C12,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A12,'C. Expenditures Data'!D:D,'E. Summary'!C12,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A12,'C. Expenditures Data'!D:D,'E. Summary'!C12,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A12,'C. Expenditures Data'!D:D,'E. Summary'!C12,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A12,'C. Expenditures Data'!D:D,'E. Summary'!C12,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A12,'C. Expenditures Data'!D:D,'E. Summary'!C12,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2021,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A13,'D. Member Months Data'!D:D,C13)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A13,'C. Expenditures Data'!D:D,'E. Summary'!C13,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A13,'C. Expenditures Data'!D:D,'E. Summary'!C13,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A13,'C. Expenditures Data'!D:D,'E. Summary'!C13,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A13,'C. Expenditures Data'!D:D,'E. Summary'!C13,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A13,'C. Expenditures Data'!D:D,'E. Summary'!C13,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A13,'C. Expenditures Data'!D:D,'E. Summary'!C13,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A13,'C. Expenditures Data'!D:D,'E. Summary'!C13,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A13,'C. Expenditures Data'!D:D,'E. Summary'!C13,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2021,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A14,'D. Member Months Data'!D:D,C14)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A14,'C. Expenditures Data'!D:D,'E. Summary'!C14,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A14,'C. Expenditures Data'!D:D,'E. Summary'!C14,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A14,'C. Expenditures Data'!D:D,'E. Summary'!C14,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A14,'C. Expenditures Data'!D:D,'E. Summary'!C14,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A14,'C. Expenditures Data'!D:D,'E. Summary'!C14,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A14,'C. Expenditures Data'!D:D,'E. Summary'!C14,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A14,'C. Expenditures Data'!D:D,'E. Summary'!C14,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A14,'C. Expenditures Data'!D:D,'E. Summary'!C14,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2021,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A15,'D. Member Months Data'!D:D,C15)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A15,'C. Expenditures Data'!D:D,'E. Summary'!C15,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A15,'C. Expenditures Data'!D:D,'E. Summary'!C15,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A15,'C. Expenditures Data'!D:D,'E. Summary'!C15,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A15,'C. Expenditures Data'!D:D,'E. Summary'!C15,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A15,'C. Expenditures Data'!D:D,'E. Summary'!C15,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A15,'C. Expenditures Data'!D:D,'E. Summary'!C15,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A15,'C. Expenditures Data'!D:D,'E. Summary'!C15,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A15,'C. Expenditures Data'!D:D,'E. Summary'!C15,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2022,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A16,'D. Member Months Data'!D:D,C16)","v":0},{"$f":"SUM(J16:M16)","v":0},{"$f":"IFERROR(E16/D16,\"0\")","v":"0"},{"$f":"IFERROR(J16/D16,\"0\")","v":"0"},{"$f":"IFERROR(K16/D16,\"0\")","v":"0"},{"$f":"IFERROR(L16/D16,\"0\")","v":"0"},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A16,'C. Expenditures Data'!D:D,'E. Summary'!C16,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A16,'C. Expenditures Data'!D:D,'E. Summary'!C16,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A16,'C. Expenditures Data'!D:D,'E. Summary'!C16,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A16,'C. Expenditures Data'!D:D,'E. Summary'!C16,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A16,'C. Expenditures Data'!D:D,'E. Summary'!C16,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A16,'C. Expenditures Data'!D:D,'E. Summary'!C16,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A16,'C. Expenditures Data'!D:D,'E. Summary'!C16,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A16,'C. Expenditures Data'!D:D,'E. Summary'!C16,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2022,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A17,'D. Member Months Data'!D:D,C17)","v":0},0,"0","0",{"$f":"IFERROR(K17/D17,\"0\")","v":"0"},{"$f":"IFERROR(L17/D17,\"0\")","v":"0"},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A17,'C. Expenditures Data'!D:D,'E. Summary'!C17,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A17,'C. Expenditures Data'!D:D,'E. Summary'!C17,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A17,'C. Expenditures Data'!D:D,'E. Summary'!C17,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A17,'C. Expenditures Data'!D:D,'E. Summary'!C17,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A17,'C. Expenditures Data'!D:D,'E. Summary'!C17,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A17,'C. Expenditures Data'!D:D,'E. Summary'!C17,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A17,'C. Expenditures Data'!D:D,'E. Summary'!C17,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A17,'C. Expenditures Data'!D:D,'E. Summary'!C17,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2022,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A18,'D. Member Months Data'!D:D,C18)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A18,'C. Expenditures Data'!D:D,'E. Summary'!C18,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A18,'C. Expenditures Data'!D:D,'E. Summary'!C18,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A18,'C. Expenditures Data'!D:D,'E. Summary'!C18,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A18,'C. Expenditures Data'!D:D,'E. Summary'!C18,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A18,'C. Expenditures Data'!D:D,'E. Summary'!C18,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A18,'C. Expenditures Data'!D:D,'E. Summary'!C18,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A18,'C. Expenditures Data'!D:D,'E. Summary'!C18,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A18,'C. Expenditures Data'!D:D,'E. Summary'!C18,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2022,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A19,'D. Member Months Data'!D:D,C19)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A19,'C. Expenditures Data'!D:D,'E. Summary'!C19,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A19,'C. Expenditures Data'!D:D,'E. Summary'!C19,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A19,'C. Expenditures Data'!D:D,'E. Summary'!C19,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A19,'C. Expenditures Data'!D:D,'E. Summary'!C19,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A19,'C. Expenditures Data'!D:D,'E. Summary'!C19,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A19,'C. Expenditures Data'!D:D,'E. Summary'!C19,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A19,'C. Expenditures Data'!D:D,'E. Summary'!C19,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A19,'C. Expenditures Data'!D:D,'E. Summary'!C19,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2022,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A20,'D. Member Months Data'!D:D,C20)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A20,'C. Expenditures Data'!D:D,'E. Summary'!C20,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A20,'C. Expenditures Data'!D:D,'E. Summary'!C20,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A20,'C. Expenditures Data'!D:D,'E. Summary'!C20,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A20,'C. Expenditures Data'!D:D,'E. Summary'!C20,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A20,'C. Expenditures Data'!D:D,'E. Summary'!C20,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A20,'C. Expenditures Data'!D:D,'E. Summary'!C20,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A20,'C. Expenditures Data'!D:D,'E. Summary'!C20,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A20,'C. Expenditures Data'!D:D,'E. Summary'!C20,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2022,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A21,'D. Member Months Data'!D:D,C21)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A21,'C. Expenditures Data'!D:D,'E. Summary'!C21,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A21,'C. Expenditures Data'!D:D,'E. Summary'!C21,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A21,'C. Expenditures Data'!D:D,'E. Summary'!C21,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A21,'C. Expenditures Data'!D:D,'E. Summary'!C21,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A21,'C. Expenditures Data'!D:D,'E. Summary'!C21,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A21,'C. Expenditures Data'!D:D,'E. Summary'!C21,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A21,'C. Expenditures Data'!D:D,'E. Summary'!C21,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A21,'C. Expenditures Data'!D:D,'E. Summary'!C21,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2022,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A22,'D. Member Months Data'!D:D,C22)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A22,'C. Expenditures Data'!D:D,'E. Summary'!C22,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A22,'C. Expenditures Data'!D:D,'E. Summary'!C22,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A22,'C. Expenditures Data'!D:D,'E. Summary'!C22,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A22,'C. Expenditures Data'!D:D,'E. Summary'!C22,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A22,'C. Expenditures Data'!D:D,'E. Summary'!C22,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A22,'C. Expenditures Data'!D:D,'E. Summary'!C22,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A22,'C. Expenditures Data'!D:D,'E. Summary'!C22,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A22,'C. Expenditures Data'!D:D,'E. Summary'!C22,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2022,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A23,'D. Member Months Data'!D:D,C23)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A23,'C. Expenditures Data'!D:D,'E. Summary'!C23,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A23,'C. Expenditures Data'!D:D,'E. Summary'!C23,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A23,'C. Expenditures Data'!D:D,'E. Summary'!C23,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A23,'C. Expenditures Data'!D:D,'E. Summary'!C23,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A23,'C. Expenditures Data'!D:D,'E. Summary'!C23,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A23,'C. Expenditures Data'!D:D,'E. Summary'!C23,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A23,'C. Expenditures Data'!D:D,'E. Summary'!C23,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A23,'C. Expenditures Data'!D:D,'E. Summary'!C23,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2023,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A24,'D. Member Months Data'!D:D,C24)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A24,'C. Expenditures Data'!D:D,'E. Summary'!C24,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A24,'C. Expenditures Data'!D:D,'E. Summary'!C24,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A24,'C. Expenditures Data'!D:D,'E. Summary'!C24,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A24,'C. Expenditures Data'!D:D,'E. Summary'!C24,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A24,'C. Expenditures Data'!D:D,'E. Summary'!C24,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A24,'C. Expenditures Data'!D:D,'E. Summary'!C24,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A24,'C. Expenditures Data'!D:D,'E. Summary'!C24,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A24,'C. Expenditures Data'!D:D,'E. Summary'!C24,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2023,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A25,'D. Member Months Data'!D:D,C25)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A25,'C. Expenditures Data'!D:D,'E. Summary'!C25,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A25,'C. Expenditures Data'!D:D,'E. Summary'!C25,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A25,'C. Expenditures Data'!D:D,'E. Summary'!C25,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A25,'C. Expenditures Data'!D:D,'E. Summary'!C25,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A25,'C. Expenditures Data'!D:D,'E. Summary'!C25,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A25,'C. Expenditures Data'!D:D,'E. Summary'!C25,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A25,'C. Expenditures Data'!D:D,'E. Summary'!C25,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A25,'C. Expenditures Data'!D:D,'E. Summary'!C25,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2023,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A26,'D. Member Months Data'!D:D,C26)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A26,'C. Expenditures Data'!D:D,'E. Summary'!C26,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A26,'C. Expenditures Data'!D:D,'E. Summary'!C26,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A26,'C. Expenditures Data'!D:D,'E. Summary'!C26,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A26,'C. Expenditures Data'!D:D,'E. Summary'!C26,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A26,'C. Expenditures Data'!D:D,'E. Summary'!C26,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A26,'C. Expenditures Data'!D:D,'E. Summary'!C26,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A26,'C. Expenditures Data'!D:D,'E. Summary'!C26,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A26,'C. Expenditures Data'!D:D,'E. Summary'!C26,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2023,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A27,'D. Member Months Data'!D:D,C27)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A27,'C. Expenditures Data'!D:D,'E. Summary'!C27,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A27,'C. Expenditures Data'!D:D,'E. Summary'!C27,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A27,'C. Expenditures Data'!D:D,'E. Summary'!C27,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A27,'C. Expenditures Data'!D:D,'E. Summary'!C27,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A27,'C. Expenditures Data'!D:D,'E. Summary'!C27,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A27,'C. Expenditures Data'!D:D,'E. Summary'!C27,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A27,'C. Expenditures Data'!D:D,'E. Summary'!C27,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A27,'C. Expenditures Data'!D:D,'E. Summary'!C27,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2023,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A28,'D. Member Months Data'!D:D,C28)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A28,'C. Expenditures Data'!D:D,'E. Summary'!C28,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A28,'C. Expenditures Data'!D:D,'E. Summary'!C28,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A28,'C. Expenditures Data'!D:D,'E. Summary'!C28,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A28,'C. Expenditures Data'!D:D,'E. Summary'!C28,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A28,'C. Expenditures Data'!D:D,'E. Summary'!C28,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A28,'C. Expenditures Data'!D:D,'E. Summary'!C28,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A28,'C. Expenditures Data'!D:D,'E. Summary'!C28,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A28,'C. Expenditures Data'!D:D,'E. Summary'!C28,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2023,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A29,'D. Member Months Data'!D:D,C29)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A29,'C. Expenditures Data'!D:D,'E. Summary'!C29,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A29,'C. Expenditures Data'!D:D,'E. Summary'!C29,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A29,'C. Expenditures Data'!D:D,'E. Summary'!C29,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A29,'C. Expenditures Data'!D:D,'E. Summary'!C29,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A29,'C. Expenditures Data'!D:D,'E. Summary'!C29,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A29,'C. Expenditures Data'!D:D,'E. Summary'!C29,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A29,'C. Expenditures Data'!D:D,'E. Summary'!C29,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A29,'C. Expenditures Data'!D:D,'E. Summary'!C29,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2023,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A30,'D. Member Months Data'!D:D,C30)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A30,'C. Expenditures Data'!D:D,'E. Summary'!C30,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A30,'C. Expenditures Data'!D:D,'E. Summary'!C30,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A30,'C. Expenditures Data'!D:D,'E. Summary'!C30,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A30,'C. Expenditures Data'!D:D,'E. Summary'!C30,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A30,'C. Expenditures Data'!D:D,'E. Summary'!C30,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A30,'C. Expenditures Data'!D:D,'E. Summary'!C30,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A30,'C. Expenditures Data'!D:D,'E. Summary'!C30,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A30,'C. Expenditures Data'!D:D,'E. Summary'!C30,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[2023,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A31,'D. Member Months Data'!D:D,C31)","v":0},0,"0","0","0","0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A31,'C. Expenditures Data'!D:D,'E. Summary'!C31,'C. Expenditures Data'!J:J,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A31,'C. Expenditures Data'!D:D,'E. Summary'!C31,'C. Expenditures Data'!J:J,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A31,'C. Expenditures Data'!D:D,'E. Summary'!C31,'C. Expenditures Data'!J:J,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A31,'C. Expenditures Data'!D:D,'E. Summary'!C31,'C. Expenditures Data'!J:J,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A31,'C. Expenditures Data'!D:D,'E. Summary'!C31,'C. Expenditures Data'!J:J,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A31,'C. Expenditures Data'!D:D,'E. Summary'!C31,'C. Expenditures Data'!J:J,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A31,'C. Expenditures Data'!D:D,'E. Summary'!C31,'C. Expenditures Data'!J:J,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A31,'C. Expenditures Data'!D:D,'E. Summary'!C31,'C. Expenditures Data'!J:J,\"4\")","v":0}]
[]
[]
["Data Summary- Mental Health Services"]
["Year","Insurance Category ","Code","Member Months  ","MH Expenses","MH PMPM ","Facility","Professional Physician","Professional Other","No Provider"]
[2021,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A36,'D. Member Months Data'!D:D,C36)","v":0},{"$f":"SUM(G36:J36)","v":0},{"$f":"IFERROR(E36/D36,\"0\")","v":"0"},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A36,'C. Expenditures Data'!D:D,'E. Summary'!C36,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A36,'C. Expenditures Data'!D:D,'E. Summary'!C36,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A36,'C. Expenditures Data'!D:D,'E. Summary'!C36,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A36,'C. Expenditures Data'!D:D,'E. Summary'!C36,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A36,'C. Expenditures Data'!D:D,'E. Summary'!C36,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A36,'C. Expenditures Data'!D:D,'E. Summary'!C36,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A36,'C. Expenditures Data'!D:D,'E. Summary'!C36,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A36,'C. Expenditures Data'!D:D,'E. Summary'!C36,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A37,'D. Member Months Data'!D:D,C37)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A37,'C. Expenditures Data'!D:D,'E. Summary'!C37,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A37,'C. Expenditures Data'!D:D,'E. Summary'!C37,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A37,'C. Expenditures Data'!D:D,'E. Summary'!C37,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A37,'C. Expenditures Data'!D:D,'E. Summary'!C37,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A37,'C. Expenditures Data'!D:D,'E. Summary'!C37,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A37,'C. Expenditures Data'!D:D,'E. Summary'!C37,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A37,'C. Expenditures Data'!D:D,'E. Summary'!C37,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A37,'C. Expenditures Data'!D:D,'E. Summary'!C37,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A38,'D. Member Months Data'!D:D,C38)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A38,'C. Expenditures Data'!D:D,'E. Summary'!C38,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A38,'C. Expenditures Data'!D:D,'E. Summary'!C38,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A38,'C. Expenditures Data'!D:D,'E. Summary'!C38,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A38,'C. Expenditures Data'!D:D,'E. Summary'!C38,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A38,'C. Expenditures Data'!D:D,'E. Summary'!C38,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A38,'C. Expenditures Data'!D:D,'E. Summary'!C38,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A38,'C. Expenditures Data'!D:D,'E. Summary'!C38,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A38,'C. Expenditures Data'!D:D,'E. Summary'!C38,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A39,'D. Member Months Data'!D:D,C39)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A39,'C. Expenditures Data'!D:D,'E. Summary'!C39,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A39,'C. Expenditures Data'!D:D,'E. Summary'!C39,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A39,'C. Expenditures Data'!D:D,'E. Summary'!C39,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A39,'C. Expenditures Data'!D:D,'E. Summary'!C39,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A39,'C. Expenditures Data'!D:D,'E. Summary'!C39,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A39,'C. Expenditures Data'!D:D,'E. Summary'!C39,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A39,'C. Expenditures Data'!D:D,'E. Summary'!C39,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A39,'C. Expenditures Data'!D:D,'E. Summary'!C39,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A40,'D. Member Months Data'!D:D,C40)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A40,'C. Expenditures Data'!D:D,'E. Summary'!C40,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A40,'C. Expenditures Data'!D:D,'E. Summary'!C40,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A40,'C. Expenditures Data'!D:D,'E. Summary'!C40,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A40,'C. Expenditures Data'!D:D,'E. Summary'!C40,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A40,'C. Expenditures Data'!D:D,'E. Summary'!C40,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A40,'C. Expenditures Data'!D:D,'E. Summary'!C40,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A40,'C. Expenditures Data'!D:D,'E. Summary'!C40,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A40,'C. Expenditures Data'!D:D,'E. Summary'!C40,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A41,'D. Member Months Data'!D:D,C41)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A41,'C. Expenditures Data'!D:D,'E. Summary'!C41,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A41,'C. Expenditures Data'!D:D,'E. Summary'!C41,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A41,'C. Expenditures Data'!D:D,'E. Summary'!C41,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A41,'C. Expenditures Data'!D:D,'E. Summary'!C41,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A41,'C. Expenditures Data'!D:D,'E. Summary'!C41,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A41,'C. Expenditures Data'!D:D,'E. Summary'!C41,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A41,'C. Expenditures Data'!D:D,'E. Summary'!C41,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A41,'C. Expenditures Data'!D:D,'E. Summary'!C41,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A42,'D. Member Months Data'!D:D,C42)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A42,'C. Expenditures Data'!D:D,'E. Summary'!C42,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A42,'C. Expenditures Data'!D:D,'E. Summary'!C42,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A42,'C. Expenditures Data'!D:D,'E. Summary'!C42,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A42,'C. Expenditures Data'!D:D,'E. Summary'!C42,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A42,'C. Expenditures Data'!D:D,'E. Summary'!C42,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A42,'C. Expenditures Data'!D:D,'E. Summary'!C42,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A42,'C. Expenditures Data'!D:D,'E. Summary'!C42,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A42,'C. Expenditures Data'!D:D,'E. Summary'!C42,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A43,'D. Member Months Data'!D:D,C43)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A43,'C. Expenditures Data'!D:D,'E. Summary'!C43,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A43,'C. Expenditures Data'!D:D,'E. Summary'!C43,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A43,'C. Expenditures Data'!D:D,'E. Summary'!C43,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A43,'C. Expenditures Data'!D:D,'E. Summary'!C43,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A43,'C. Expenditures Data'!D:D,'E. Summary'!C43,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A43,'C. Expenditures Data'!D:D,'E. Summary'!C43,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A43,'C. Expenditures Data'!D:D,'E. Summary'!C43,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A43,'C. Expenditures Data'!D:D,'E. Summary'!C43,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A44,'D. Member Months Data'!D:D,C44)","v":0},{"$f":"SUM(G44:J44)","v":0},{"$f":"IFERROR(E44/D44,\"0\")","v":"0"},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A44,'C. Expenditures Data'!D:D,'E. Summary'!C44,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A44,'C. Expenditures Data'!D:D,'E. Summary'!C44,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A44,'C. Expenditures Data'!D:D,'E. Summary'!C44,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A44,'C. Expenditures Data'!D:D,'E. Summary'!C44,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A44,'C. Expenditures Data'!D:D,'E. Summary'!C44,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A44,'C. Expenditures Data'!D:D,'E. Summary'!C44,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A44,'C. Expenditures Data'!D:D,'E. Summary'!C44,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A44,'C. Expenditures Data'!D:D,'E. Summary'!C44,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A45,'D. Member Months Data'!D:D,C45)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A45,'C. Expenditures Data'!D:D,'E. Summary'!C45,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A45,'C. Expenditures Data'!D:D,'E. Summary'!C45,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A45,'C. Expenditures Data'!D:D,'E. Summary'!C45,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A45,'C. Expenditures Data'!D:D,'E. Summary'!C45,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A45,'C. Expenditures Data'!D:D,'E. Summary'!C45,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A45,'C. Expenditures Data'!D:D,'E. Summary'!C45,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A45,'C. Expenditures Data'!D:D,'E. Summary'!C45,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A45,'C. Expenditures Data'!D:D,'E. Summary'!C45,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A46,'D. Member Months Data'!D:D,C46)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A46,'C. Expenditures Data'!D:D,'E. Summary'!C46,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A46,'C. Expenditures Data'!D:D,'E. Summary'!C46,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A46,'C. Expenditures Data'!D:D,'E. Summary'!C46,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A46,'C. Expenditures Data'!D:D,'E. Summary'!C46,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A46,'C. Expenditures Data'!D:D,'E. Summary'!C46,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A46,'C. Expenditures Data'!D:D,'E. Summary'!C46,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A46,'C. Expenditures Data'!D:D,'E. Summary'!C46,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A46,'C. Expenditures Data'!D:D,'E. Summary'!C46,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A47,'D. Member Months Data'!D:D,C47)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A47,'C. Expenditures Data'!D:D,'E. Summary'!C47,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A47,'C. Expenditures Data'!D:D,'E. Summary'!C47,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A47,'C. Expenditures Data'!D:D,'E. Summary'!C47,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A47,'C. Expenditures Data'!D:D,'E. Summary'!C47,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A47,'C. Expenditures Data'!D:D,'E. Summary'!C47,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A47,'C. Expenditures Data'!D:D,'E. Summary'!C47,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A47,'C. Expenditures Data'!D:D,'E. Summary'!C47,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A47,'C. Expenditures Data'!D:D,'E. Summary'!C47,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A48,'D. Member Months Data'!D:D,C48)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A48,'C. Expenditures Data'!D:D,'E. Summary'!C48,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A48,'C. Expenditures Data'!D:D,'E. Summary'!C48,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A48,'C. Expenditures Data'!D:D,'E. Summary'!C48,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A48,'C. Expenditures Data'!D:D,'E. Summary'!C48,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A48,'C. Expenditures Data'!D:D,'E. Summary'!C48,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A48,'C. Expenditures Data'!D:D,'E. Summary'!C48,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A48,'C. Expenditures Data'!D:D,'E. Summary'!C48,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A48,'C. Expenditures Data'!D:D,'E. Summary'!C48,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A49,'D. Member Months Data'!D:D,C49)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A49,'C. Expenditures Data'!D:D,'E. Summary'!C49,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A49,'C. Expenditures Data'!D:D,'E. Summary'!C49,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A49,'C. Expenditures Data'!D:D,'E. Summary'!C49,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A49,'C. Expenditures Data'!D:D,'E. Summary'!C49,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A49,'C. Expenditures Data'!D:D,'E. Summary'!C49,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A49,'C. Expenditures Data'!D:D,'E. Summary'!C49,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A49,'C. Expenditures Data'!D:D,'E. Summary'!C49,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A49,'C. Expenditures Data'!D:D,'E. Summary'!C49,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A50,'D. Member Months Data'!D:D,C50)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A50,'C. Expenditures Data'!D:D,'E. Summary'!C50,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A50,'C. Expenditures Data'!D:D,'E. Summary'!C50,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A50,'C. Expenditures Data'!D:D,'E. Summary'!C50,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A50,'C. Expenditures Data'!D:D,'E. Summary'!C50,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A50,'C. Expenditures Data'!D:D,'E. Summary'!C50,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A50,'C. Expenditures Data'!D:D,'E. Summary'!C50,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A50,'C. Expenditures Data'!D:D,'E. Summary'!C50,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A50,'C. Expenditures Data'!D:D,'E. Summary'!C50,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A51,'D. Member Months Data'!D:D,C51)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A51,'C. Expenditures Data'!D:D,'E. Summary'!C51,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A51,'C. Expenditures Data'!D:D,'E. Summary'!C51,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A51,'C. Expenditures Data'!D:D,'E. Summary'!C51,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A51,'C. Expenditures Data'!D:D,'E. Summary'!C51,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A51,'C. Expenditures Data'!D:D,'E. Summary'!C51,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A51,'C. Expenditures Data'!D:D,'E. Summary'!C51,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A51,'C. Expenditures Data'!D:D,'E. Summary'!C51,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A51,'C. Expenditures Data'!D:D,'E. Summary'!C51,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A52,'D. Member Months Data'!D:D,C52)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A52,'C. Expenditures Data'!D:D,'E. Summary'!C52,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A52,'C. Expenditures Data'!D:D,'E. Summary'!C52,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A52,'C. Expenditures Data'!D:D,'E. Summary'!C52,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A52,'C. Expenditures Data'!D:D,'E. Summary'!C52,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A52,'C. Expenditures Data'!D:D,'E. Summary'!C52,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A52,'C. Expenditures Data'!D:D,'E. Summary'!C52,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A52,'C. Expenditures Data'!D:D,'E. Summary'!C52,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A52,'C. Expenditures Data'!D:D,'E. Summary'!C52,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A53,'D. Member Months Data'!D:D,C53)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A53,'C. Expenditures Data'!D:D,'E. Summary'!C53,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A53,'C. Expenditures Data'!D:D,'E. Summary'!C53,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A53,'C. Expenditures Data'!D:D,'E. Summary'!C53,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A53,'C. Expenditures Data'!D:D,'E. Summary'!C53,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A53,'C. Expenditures Data'!D:D,'E. Summary'!C53,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A53,'C. Expenditures Data'!D:D,'E. Summary'!C53,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A53,'C. Expenditures Data'!D:D,'E. Summary'!C53,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A53,'C. Expenditures Data'!D:D,'E. Summary'!C53,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A54,'D. Member Months Data'!D:D,C54)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A54,'C. Expenditures Data'!D:D,'E. Summary'!C54,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A54,'C. Expenditures Data'!D:D,'E. Summary'!C54,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A54,'C. Expenditures Data'!D:D,'E. Summary'!C54,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A54,'C. Expenditures Data'!D:D,'E. Summary'!C54,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A54,'C. Expenditures Data'!D:D,'E. Summary'!C54,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A54,'C. Expenditures Data'!D:D,'E. Summary'!C54,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A54,'C. Expenditures Data'!D:D,'E. Summary'!C54,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A54,'C. Expenditures Data'!D:D,'E. Summary'!C54,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A55,'D. Member Months Data'!D:D,C55)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A55,'C. Expenditures Data'!D:D,'E. Summary'!C55,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A55,'C. Expenditures Data'!D:D,'E. Summary'!C55,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A55,'C. Expenditures Data'!D:D,'E. Summary'!C55,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A55,'C. Expenditures Data'!D:D,'E. Summary'!C55,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A55,'C. Expenditures Data'!D:D,'E. Summary'!C55,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A55,'C. Expenditures Data'!D:D,'E. Summary'!C55,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A55,'C. Expenditures Data'!D:D,'E. Summary'!C55,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A55,'C. Expenditures Data'!D:D,'E. Summary'!C55,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A56,'D. Member Months Data'!D:D,C56)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A56,'C. Expenditures Data'!D:D,'E. Summary'!C56,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A56,'C. Expenditures Data'!D:D,'E. Summary'!C56,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A56,'C. Expenditures Data'!D:D,'E. Summary'!C56,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A56,'C. Expenditures Data'!D:D,'E. Summary'!C56,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A56,'C. Expenditures Data'!D:D,'E. Summary'!C56,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A56,'C. Expenditures Data'!D:D,'E. Summary'!C56,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A56,'C. Expenditures Data'!D:D,'E. Summary'!C56,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A56,'C. Expenditures Data'!D:D,'E. Summary'!C56,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A57,'D. Member Months Data'!D:D,C57)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A57,'C. Expenditures Data'!D:D,'E. Summary'!C57,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A57,'C. Expenditures Data'!D:D,'E. Summary'!C57,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A57,'C. Expenditures Data'!D:D,'E. Summary'!C57,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A57,'C. Expenditures Data'!D:D,'E. Summary'!C57,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A57,'C. Expenditures Data'!D:D,'E. Summary'!C57,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A57,'C. Expenditures Data'!D:D,'E. Summary'!C57,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A57,'C. Expenditures Data'!D:D,'E. Summary'!C57,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A57,'C. Expenditures Data'!D:D,'E. Summary'!C57,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A58,'D. Member Months Data'!D:D,C58)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A58,'C. Expenditures Data'!D:D,'E. Summary'!C58,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A58,'C. Expenditures Data'!D:D,'E. Summary'!C58,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A58,'C. Expenditures Data'!D:D,'E. Summary'!C58,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A58,'C. Expenditures Data'!D:D,'E. Summary'!C58,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A58,'C. Expenditures Data'!D:D,'E. Summary'!C58,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A58,'C. Expenditures Data'!D:D,'E. Summary'!C58,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A58,'C. Expenditures Data'!D:D,'E. Summary'!C58,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A58,'C. Expenditures Data'!D:D,'E. Summary'!C58,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A59,'D. Member Months Data'!D:D,C59)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A59,'C. Expenditures Data'!D:D,'E. Summary'!C59,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A59,'C. Expenditures Data'!D:D,'E. Summary'!C59,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A59,'C. Expenditures Data'!D:D,'E. Summary'!C59,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A59,'C. Expenditures Data'!D:D,'E. Summary'!C59,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A59,'C. Expenditures Data'!D:D,'E. Summary'!C59,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A59,'C. Expenditures Data'!D:D,'E. Summary'!C59,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A59,'C. Expenditures Data'!D:D,'E. Summary'!C59,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A59,'C. Expenditures Data'!D:D,'E. Summary'!C59,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[]
["Data Summary- Substance Use Disorder Services"]
["Year","Insurance Category ","Code","Member Months  ","SUD Expenses","SUD PMPM ","Facility","Professional Physician","Professional Other","No Provider"]
[2021,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A63,'D. Member Months Data'!D:D,C63)","v":0},{"$f":"SUM(G63:J63)","v":0},{"$f":"IFERROR(E63/D63,\"0\")","v":"0"},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A63,'C. Expenditures Data'!D:D,'E. Summary'!C63,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A63,'C. Expenditures Data'!D:D,'E. Summary'!C63,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A63,'C. Expenditures Data'!D:D,'E. Summary'!C63,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A63,'C. Expenditures Data'!D:D,'E. Summary'!C63,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A63,'C. Expenditures Data'!D:D,'E. Summary'!C63,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A63,'C. Expenditures Data'!D:D,'E. Summary'!C63,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A63,'C. Expenditures Data'!D:D,'E. Summary'!C63,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A63,'C. Expenditures Data'!D:D,'E. Summary'!C63,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A64,'D. Member Months Data'!D:D,C64)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A64,'C. Expenditures Data'!D:D,'E. Summary'!C64,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A64,'C. Expenditures Data'!D:D,'E. Summary'!C64,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A64,'C. Expenditures Data'!D:D,'E. Summary'!C64,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A64,'C. Expenditures Data'!D:D,'E. Summary'!C64,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A64,'C. Expenditures Data'!D:D,'E. Summary'!C64,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A64,'C. Expenditures Data'!D:D,'E. Summary'!C64,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A64,'C. Expenditures Data'!D:D,'E. Summary'!C64,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A64,'C. Expenditures Data'!D:D,'E. Summary'!C64,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A65,'D. Member Months Data'!D:D,C65)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A65,'C. Expenditures Data'!D:D,'E. Summary'!C65,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A65,'C. Expenditures Data'!D:D,'E. Summary'!C65,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A65,'C. Expenditures Data'!D:D,'E. Summary'!C65,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A65,'C. Expenditures Data'!D:D,'E. Summary'!C65,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A65,'C. Expenditures Data'!D:D,'E. Summary'!C65,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A65,'C. Expenditures Data'!D:D,'E. Summary'!C65,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A65,'C. Expenditures Data'!D:D,'E. Summary'!C65,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A65,'C. Expenditures Data'!D:D,'E. Summary'!C65,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A66,'D. Member Months Data'!D:D,C66)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A66,'C. Expenditures Data'!D:D,'E. Summary'!C66,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A66,'C. Expenditures Data'!D:D,'E. Summary'!C66,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A66,'C. Expenditures Data'!D:D,'E. Summary'!C66,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A66,'C. Expenditures Data'!D:D,'E. Summary'!C66,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A66,'C. Expenditures Data'!D:D,'E. Summary'!C66,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A66,'C. Expenditures Data'!D:D,'E. Summary'!C66,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A66,'C. Expenditures Data'!D:D,'E. Summary'!C66,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A66,'C. Expenditures Data'!D:D,'E. Summary'!C66,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A67,'D. Member Months Data'!D:D,C67)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A67,'C. Expenditures Data'!D:D,'E. Summary'!C67,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A67,'C. Expenditures Data'!D:D,'E. Summary'!C67,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A67,'C. Expenditures Data'!D:D,'E. Summary'!C67,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A67,'C. Expenditures Data'!D:D,'E. Summary'!C67,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A67,'C. Expenditures Data'!D:D,'E. Summary'!C67,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A67,'C. Expenditures Data'!D:D,'E. Summary'!C67,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A67,'C. Expenditures Data'!D:D,'E. Summary'!C67,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A67,'C. Expenditures Data'!D:D,'E. Summary'!C67,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A68,'D. Member Months Data'!D:D,C68)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A68,'C. Expenditures Data'!D:D,'E. Summary'!C68,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A68,'C. Expenditures Data'!D:D,'E. Summary'!C68,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A68,'C. Expenditures Data'!D:D,'E. Summary'!C68,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A68,'C. Expenditures Data'!D:D,'E. Summary'!C68,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A68,'C. Expenditures Data'!D:D,'E. Summary'!C68,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A68,'C. Expenditures Data'!D:D,'E. Summary'!C68,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A68,'C. Expenditures Data'!D:D,'E. Summary'!C68,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A68,'C. Expenditures Data'!D:D,'E. Summary'!C68,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A69,'D. Member Months Data'!D:D,C69)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A69,'C. Expenditures Data'!D:D,'E. Summary'!C69,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A69,'C. Expenditures Data'!D:D,'E. Summary'!C69,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A69,'C. Expenditures Data'!D:D,'E. Summary'!C69,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A69,'C. Expenditures Data'!D:D,'E. Summary'!C69,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A69,'C. Expenditures Data'!D:D,'E. Summary'!C69,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A69,'C. Expenditures Data'!D:D,'E. Summary'!C69,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A69,'C. Expenditures Data'!D:D,'E. Summary'!C69,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A69,'C. Expenditures Data'!D:D,'E. Summary'!C69,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A70,'D. Member Months Data'!D:D,C70)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A70,'C. Expenditures Data'!D:D,'E. Summary'!C70,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A70,'C. Expenditures Data'!D:D,'E. Summary'!C70,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A70,'C. Expenditures Data'!D:D,'E. Summary'!C70,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A70,'C. Expenditures Data'!D:D,'E. Summary'!C70,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A70,'C. Expenditures Data'!D:D,'E. Summary'!C70,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A70,'C. Expenditures Data'!D:D,'E. Summary'!C70,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A70,'C. Expenditures Data'!D:D,'E. Summary'!C70,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A70,'C. Expenditures Data'!D:D,'E. Summary'!C70,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A71,'D. Member Months Data'!D:D,C71)","v":0},{"$f":"SUM(G71:J71)","v":0},{"$f":"IFERROR(E71/D71,\"0\")","v":"0"},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A71,'C. Expenditures Data'!D:D,'E. Summary'!C71,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A71,'C. Expenditures Data'!D:D,'E. Summary'!C71,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A71,'C. Expenditures Data'!D:D,'E. Summary'!C71,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A71,'C. Expenditures Data'!D:D,'E. Summary'!C71,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A71,'C. Expenditures Data'!D:D,'E. Summary'!C71,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A71,'C. Expenditures Data'!D:D,'E. Summary'!C71,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A71,'C. Expenditures Data'!D:D,'E. Summary'!C71,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A71,'C. Expenditures Data'!D:D,'E. Summary'!C71,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A72,'D. Member Months Data'!D:D,C72)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A72,'C. Expenditures Data'!D:D,'E. Summary'!C72,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A72,'C. Expenditures Data'!D:D,'E. Summary'!C72,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A72,'C. Expenditures Data'!D:D,'E. Summary'!C72,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A72,'C. Expenditures Data'!D:D,'E. Summary'!C72,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A72,'C. Expenditures Data'!D:D,'E. Summary'!C72,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A72,'C. Expenditures Data'!D:D,'E. Summary'!C72,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A72,'C. Expenditures Data'!D:D,'E. Summary'!C72,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A72,'C. Expenditures Data'!D:D,'E. Summary'!C72,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A73,'D. Member Months Data'!D:D,C73)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A73,'C. Expenditures Data'!D:D,'E. Summary'!C73,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A73,'C. Expenditures Data'!D:D,'E. Summary'!C73,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A73,'C. Expenditures Data'!D:D,'E. Summary'!C73,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A73,'C. Expenditures Data'!D:D,'E. Summary'!C73,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A73,'C. Expenditures Data'!D:D,'E. Summary'!C73,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A73,'C. Expenditures Data'!D:D,'E. Summary'!C73,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A73,'C. Expenditures Data'!D:D,'E. Summary'!C73,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A73,'C. Expenditures Data'!D:D,'E. Summary'!C73,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A74,'D. Member Months Data'!D:D,C74)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A74,'C. Expenditures Data'!D:D,'E. Summary'!C74,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A74,'C. Expenditures Data'!D:D,'E. Summary'!C74,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A74,'C. Expenditures Data'!D:D,'E. Summary'!C74,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A74,'C. Expenditures Data'!D:D,'E. Summary'!C74,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A74,'C. Expenditures Data'!D:D,'E. Summary'!C74,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A74,'C. Expenditures Data'!D:D,'E. Summary'!C74,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A74,'C. Expenditures Data'!D:D,'E. Summary'!C74,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A74,'C. Expenditures Data'!D:D,'E. Summary'!C74,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A75,'D. Member Months Data'!D:D,C75)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A75,'C. Expenditures Data'!D:D,'E. Summary'!C75,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A75,'C. Expenditures Data'!D:D,'E. Summary'!C75,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A75,'C. Expenditures Data'!D:D,'E. Summary'!C75,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A75,'C. Expenditures Data'!D:D,'E. Summary'!C75,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A75,'C. Expenditures Data'!D:D,'E. Summary'!C75,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A75,'C. Expenditures Data'!D:D,'E. Summary'!C75,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A75,'C. Expenditures Data'!D:D,'E. Summary'!C75,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A75,'C. Expenditures Data'!D:D,'E. Summary'!C75,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A76,'D. Member Months Data'!D:D,C76)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A76,'C. Expenditures Data'!D:D,'E. Summary'!C76,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A76,'C. Expenditures Data'!D:D,'E. Summary'!C76,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A76,'C. Expenditures Data'!D:D,'E. Summary'!C76,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A76,'C. Expenditures Data'!D:D,'E. Summary'!C76,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A76,'C. Expenditures Data'!D:D,'E. Summary'!C76,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A76,'C. Expenditures Data'!D:D,'E. Summary'!C76,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A76,'C. Expenditures Data'!D:D,'E. Summary'!C76,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A76,'C. Expenditures Data'!D:D,'E. Summary'!C76,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A77,'D. Member Months Data'!D:D,C77)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A77,'C. Expenditures Data'!D:D,'E. Summary'!C77,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A77,'C. Expenditures Data'!D:D,'E. Summary'!C77,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A77,'C. Expenditures Data'!D:D,'E. Summary'!C77,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A77,'C. Expenditures Data'!D:D,'E. Summary'!C77,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A77,'C. Expenditures Data'!D:D,'E. Summary'!C77,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A77,'C. Expenditures Data'!D:D,'E. Summary'!C77,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A77,'C. Expenditures Data'!D:D,'E. Summary'!C77,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A77,'C. Expenditures Data'!D:D,'E. Summary'!C77,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A78,'D. Member Months Data'!D:D,C78)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A78,'C. Expenditures Data'!D:D,'E. Summary'!C78,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A78,'C. Expenditures Data'!D:D,'E. Summary'!C78,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A78,'C. Expenditures Data'!D:D,'E. Summary'!C78,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A78,'C. Expenditures Data'!D:D,'E. Summary'!C78,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A78,'C. Expenditures Data'!D:D,'E. Summary'!C78,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A78,'C. Expenditures Data'!D:D,'E. Summary'!C78,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A78,'C. Expenditures Data'!D:D,'E. Summary'!C78,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A78,'C. Expenditures Data'!D:D,'E. Summary'!C78,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A79,'D. Member Months Data'!D:D,C79)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A79,'C. Expenditures Data'!D:D,'E. Summary'!C79,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A79,'C. Expenditures Data'!D:D,'E. Summary'!C79,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A79,'C. Expenditures Data'!D:D,'E. Summary'!C79,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A79,'C. Expenditures Data'!D:D,'E. Summary'!C79,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A79,'C. Expenditures Data'!D:D,'E. Summary'!C79,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A79,'C. Expenditures Data'!D:D,'E. Summary'!C79,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A79,'C. Expenditures Data'!D:D,'E. Summary'!C79,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A79,'C. Expenditures Data'!D:D,'E. Summary'!C79,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A80,'D. Member Months Data'!D:D,C80)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A80,'C. Expenditures Data'!D:D,'E. Summary'!C80,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A80,'C. Expenditures Data'!D:D,'E. Summary'!C80,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A80,'C. Expenditures Data'!D:D,'E. Summary'!C80,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A80,'C. Expenditures Data'!D:D,'E. Summary'!C80,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A80,'C. Expenditures Data'!D:D,'E. Summary'!C80,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A80,'C. Expenditures Data'!D:D,'E. Summary'!C80,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A80,'C. Expenditures Data'!D:D,'E. Summary'!C80,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A80,'C. Expenditures Data'!D:D,'E. Summary'!C80,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A81,'D. Member Months Data'!D:D,C81)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A81,'C. Expenditures Data'!D:D,'E. Summary'!C81,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A81,'C. Expenditures Data'!D:D,'E. Summary'!C81,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A81,'C. Expenditures Data'!D:D,'E. Summary'!C81,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A81,'C. Expenditures Data'!D:D,'E. Summary'!C81,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A81,'C. Expenditures Data'!D:D,'E. Summary'!C81,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A81,'C. Expenditures Data'!D:D,'E. Summary'!C81,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A81,'C. Expenditures Data'!D:D,'E. Summary'!C81,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A81,'C. Expenditures Data'!D:D,'E. Summary'!C81,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A82,'D. Member Months Data'!D:D,C82)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A82,'C. Expenditures Data'!D:D,'E. Summary'!C82,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A82,'C. Expenditures Data'!D:D,'E. Summary'!C82,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A82,'C. Expenditures Data'!D:D,'E. Summary'!C82,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A82,'C. Expenditures Data'!D:D,'E. Summary'!C82,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A82,'C. Expenditures Data'!D:D,'E. Summary'!C82,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A82,'C. Expenditures Data'!D:D,'E. Summary'!C82,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A82,'C. Expenditures Data'!D:D,'E. Summary'!C82,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A82,'C. Expenditures Data'!D:D,'E. Summary'!C82,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A83,'D. Member Months Data'!D:D,C83)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A83,'C. Expenditures Data'!D:D,'E. Summary'!C83,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A83,'C. Expenditures Data'!D:D,'E. Summary'!C83,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A83,'C. Expenditures Data'!D:D,'E. Summary'!C83,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A83,'C. Expenditures Data'!D:D,'E. Summary'!C83,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A83,'C. Expenditures Data'!D:D,'E. Summary'!C83,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A83,'C. Expenditures Data'!D:D,'E. Summary'!C83,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A83,'C. Expenditures Data'!D:D,'E. Summary'!C83,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A83,'C. Expenditures Data'!D:D,'E. Summary'!C83,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A84,'D. Member Months Data'!D:D,C84)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A84,'C. Expenditures Data'!D:D,'E. Summary'!C84,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A84,'C. Expenditures Data'!D:D,'E. Summary'!C84,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A84,'C. Expenditures Data'!D:D,'E. Summary'!C84,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A84,'C. Expenditures Data'!D:D,'E. Summary'!C84,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A84,'C. Expenditures Data'!D:D,'E. Summary'!C84,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A84,'C. Expenditures Data'!D:D,'E. Summary'!C84,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A84,'C. Expenditures Data'!D:D,'E. Summary'!C84,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A84,'C. Expenditures Data'!D:D,'E. Summary'!C84,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A85,'D. Member Months Data'!D:D,C85)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A85,'C. Expenditures Data'!D:D,'E. Summary'!C85,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A85,'C. Expenditures Data'!D:D,'E. Summary'!C85,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A85,'C. Expenditures Data'!D:D,'E. Summary'!C85,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A85,'C. Expenditures Data'!D:D,'E. Summary'!C85,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A85,'C. Expenditures Data'!D:D,'E. Summary'!C85,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A85,'C. Expenditures Data'!D:D,'E. Summary'!C85,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A85,'C. Expenditures Data'!D:D,'E. Summary'!C85,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A85,'C. Expenditures Data'!D:D,'E. Summary'!C85,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A86,'D. Member Months Data'!D:D,C86)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A86,'C. Expenditures Data'!D:D,'E. Summary'!C86,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A86,'C. Expenditures Data'!D:D,'E. Summary'!C86,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A86,'C. Expenditures Data'!D:D,'E. Summary'!C86,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A86,'C. Expenditures Data'!D:D,'E. Summary'!C86,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A86,'C. Expenditures Data'!D:D,'E. Summary'!C86,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A86,'C. Expenditures Data'!D:D,'E. Summary'!C86,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A86,'C. Expenditures Data'!D:D,'E. Summary'!C86,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A86,'C. Expenditures Data'!D:D,'E. Summary'!C86,'C. Expenditures Data'!J:J,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[]
["Data Summary- Primary Care Services"]
["Year","Insurance Category ","Code","Member Months  ","PC Expenses","PC PMPM","Facility","Professional Physician","Professional Other","No Provider"]
[2021,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A90,'D. Member Months Data'!D:D,C90)","v":0},{"$f":"SUM(G90:J90)","v":0},{"$f":"IFERROR(E90/D90,\"0\")","v":"0"},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A90,'C. Expenditures Data'!D:D,'E. Summary'!C90,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A90,'C. Expenditures Data'!D:D,'E. Summary'!C90,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A90,'C. Expenditures Data'!D:D,'E. Summary'!C90,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A90,'C. Expenditures Data'!D:D,'E. Summary'!C90,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A90,'C. Expenditures Data'!D:D,'E. Summary'!C90,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A90,'C. Expenditures Data'!D:D,'E. Summary'!C90,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A90,'C. Expenditures Data'!D:D,'E. Summary'!C90,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A90,'C. Expenditures Data'!D:D,'E. Summary'!C90,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A91,'D. Member Months Data'!D:D,C91)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A91,'C. Expenditures Data'!D:D,'E. Summary'!C91,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A91,'C. Expenditures Data'!D:D,'E. Summary'!C91,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A91,'C. Expenditures Data'!D:D,'E. Summary'!C91,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A91,'C. Expenditures Data'!D:D,'E. Summary'!C91,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A91,'C. Expenditures Data'!D:D,'E. Summary'!C91,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A91,'C. Expenditures Data'!D:D,'E. Summary'!C91,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A91,'C. Expenditures Data'!D:D,'E. Summary'!C91,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A91,'C. Expenditures Data'!D:D,'E. Summary'!C91,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A92,'D. Member Months Data'!D:D,C92)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A92,'C. Expenditures Data'!D:D,'E. Summary'!C92,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A92,'C. Expenditures Data'!D:D,'E. Summary'!C92,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A92,'C. Expenditures Data'!D:D,'E. Summary'!C92,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A92,'C. Expenditures Data'!D:D,'E. Summary'!C92,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A92,'C. Expenditures Data'!D:D,'E. Summary'!C92,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A92,'C. Expenditures Data'!D:D,'E. Summary'!C92,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A92,'C. Expenditures Data'!D:D,'E. Summary'!C92,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A92,'C. Expenditures Data'!D:D,'E. Summary'!C92,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A93,'D. Member Months Data'!D:D,C93)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A93,'C. Expenditures Data'!D:D,'E. Summary'!C93,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A93,'C. Expenditures Data'!D:D,'E. Summary'!C93,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A93,'C. Expenditures Data'!D:D,'E. Summary'!C93,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A93,'C. Expenditures Data'!D:D,'E. Summary'!C93,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A93,'C. Expenditures Data'!D:D,'E. Summary'!C93,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A93,'C. Expenditures Data'!D:D,'E. Summary'!C93,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A93,'C. Expenditures Data'!D:D,'E. Summary'!C93,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A93,'C. Expenditures Data'!D:D,'E. Summary'!C93,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A94,'D. Member Months Data'!D:D,C94)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A94,'C. Expenditures Data'!D:D,'E. Summary'!C94,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A94,'C. Expenditures Data'!D:D,'E. Summary'!C94,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A94,'C. Expenditures Data'!D:D,'E. Summary'!C94,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A94,'C. Expenditures Data'!D:D,'E. Summary'!C94,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A94,'C. Expenditures Data'!D:D,'E. Summary'!C94,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A94,'C. Expenditures Data'!D:D,'E. Summary'!C94,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A94,'C. Expenditures Data'!D:D,'E. Summary'!C94,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A94,'C. Expenditures Data'!D:D,'E. Summary'!C94,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A95,'D. Member Months Data'!D:D,C95)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A95,'C. Expenditures Data'!D:D,'E. Summary'!C95,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A95,'C. Expenditures Data'!D:D,'E. Summary'!C95,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A95,'C. Expenditures Data'!D:D,'E. Summary'!C95,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A95,'C. Expenditures Data'!D:D,'E. Summary'!C95,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A95,'C. Expenditures Data'!D:D,'E. Summary'!C95,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A95,'C. Expenditures Data'!D:D,'E. Summary'!C95,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A95,'C. Expenditures Data'!D:D,'E. Summary'!C95,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A95,'C. Expenditures Data'!D:D,'E. Summary'!C95,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A96,'D. Member Months Data'!D:D,C96)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A96,'C. Expenditures Data'!D:D,'E. Summary'!C96,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A96,'C. Expenditures Data'!D:D,'E. Summary'!C96,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A96,'C. Expenditures Data'!D:D,'E. Summary'!C96,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A96,'C. Expenditures Data'!D:D,'E. Summary'!C96,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A96,'C. Expenditures Data'!D:D,'E. Summary'!C96,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A96,'C. Expenditures Data'!D:D,'E. Summary'!C96,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A96,'C. Expenditures Data'!D:D,'E. Summary'!C96,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A96,'C. Expenditures Data'!D:D,'E. Summary'!C96,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A97,'D. Member Months Data'!D:D,C97)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A97,'C. Expenditures Data'!D:D,'E. Summary'!C97,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A97,'C. Expenditures Data'!D:D,'E. Summary'!C97,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A97,'C. Expenditures Data'!D:D,'E. Summary'!C97,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A97,'C. Expenditures Data'!D:D,'E. Summary'!C97,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A97,'C. Expenditures Data'!D:D,'E. Summary'!C97,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A97,'C. Expenditures Data'!D:D,'E. Summary'!C97,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A97,'C. Expenditures Data'!D:D,'E. Summary'!C97,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A97,'C. Expenditures Data'!D:D,'E. Summary'!C97,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A98,'D. Member Months Data'!D:D,C98)","v":0},{"$f":"SUM(G98:J98)","v":0},{"$f":"IFERROR(E98/D98,\"0\")","v":"0"},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A98,'C. Expenditures Data'!D:D,'E. Summary'!C98,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A98,'C. Expenditures Data'!D:D,'E. Summary'!C98,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A98,'C. Expenditures Data'!D:D,'E. Summary'!C98,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A98,'C. Expenditures Data'!D:D,'E. Summary'!C98,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A98,'C. Expenditures Data'!D:D,'E. Summary'!C98,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A98,'C. Expenditures Data'!D:D,'E. Summary'!C98,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A98,'C. Expenditures Data'!D:D,'E. Summary'!C98,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A98,'C. Expenditures Data'!D:D,'E. Summary'!C98,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A99,'D. Member Months Data'!D:D,C99)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A99,'C. Expenditures Data'!D:D,'E. Summary'!C99,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A99,'C. Expenditures Data'!D:D,'E. Summary'!C99,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A99,'C. Expenditures Data'!D:D,'E. Summary'!C99,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A99,'C. Expenditures Data'!D:D,'E. Summary'!C99,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A99,'C. Expenditures Data'!D:D,'E. Summary'!C99,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A99,'C. Expenditures Data'!D:D,'E. Summary'!C99,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A99,'C. Expenditures Data'!D:D,'E. Summary'!C99,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A99,'C. Expenditures Data'!D:D,'E. Summary'!C99,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A100,'D. Member Months Data'!D:D,C100)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A100,'C. Expenditures Data'!D:D,'E. Summary'!C100,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A100,'C. Expenditures Data'!D:D,'E. Summary'!C100,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A100,'C. Expenditures Data'!D:D,'E. Summary'!C100,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A100,'C. Expenditures Data'!D:D,'E. Summary'!C100,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A100,'C. Expenditures Data'!D:D,'E. Summary'!C100,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A100,'C. Expenditures Data'!D:D,'E. Summary'!C100,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A100,'C. Expenditures Data'!D:D,'E. Summary'!C100,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A100,'C. Expenditures Data'!D:D,'E. Summary'!C100,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A101,'D. Member Months Data'!D:D,C101)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A101,'C. Expenditures Data'!D:D,'E. Summary'!C101,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A101,'C. Expenditures Data'!D:D,'E. Summary'!C101,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A101,'C. Expenditures Data'!D:D,'E. Summary'!C101,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A101,'C. Expenditures Data'!D:D,'E. Summary'!C101,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A101,'C. Expenditures Data'!D:D,'E. Summary'!C101,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A101,'C. Expenditures Data'!D:D,'E. Summary'!C101,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A101,'C. Expenditures Data'!D:D,'E. Summary'!C101,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A101,'C. Expenditures Data'!D:D,'E. Summary'!C101,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A102,'D. Member Months Data'!D:D,C102)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A102,'C. Expenditures Data'!D:D,'E. Summary'!C102,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A102,'C. Expenditures Data'!D:D,'E. Summary'!C102,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A102,'C. Expenditures Data'!D:D,'E. Summary'!C102,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A102,'C. Expenditures Data'!D:D,'E. Summary'!C102,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A102,'C. Expenditures Data'!D:D,'E. Summary'!C102,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A102,'C. Expenditures Data'!D:D,'E. Summary'!C102,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A102,'C. Expenditures Data'!D:D,'E. Summary'!C102,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A102,'C. Expenditures Data'!D:D,'E. Summary'!C102,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A103,'D. Member Months Data'!D:D,C103)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A103,'C. Expenditures Data'!D:D,'E. Summary'!C103,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A103,'C. Expenditures Data'!D:D,'E. Summary'!C103,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A103,'C. Expenditures Data'!D:D,'E. Summary'!C103,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A103,'C. Expenditures Data'!D:D,'E. Summary'!C103,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A103,'C. Expenditures Data'!D:D,'E. Summary'!C103,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A103,'C. Expenditures Data'!D:D,'E. Summary'!C103,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A103,'C. Expenditures Data'!D:D,'E. Summary'!C103,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A103,'C. Expenditures Data'!D:D,'E. Summary'!C103,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A104,'D. Member Months Data'!D:D,C104)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A104,'C. Expenditures Data'!D:D,'E. Summary'!C104,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A104,'C. Expenditures Data'!D:D,'E. Summary'!C104,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A104,'C. Expenditures Data'!D:D,'E. Summary'!C104,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A104,'C. Expenditures Data'!D:D,'E. Summary'!C104,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A104,'C. Expenditures Data'!D:D,'E. Summary'!C104,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A104,'C. Expenditures Data'!D:D,'E. Summary'!C104,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A104,'C. Expenditures Data'!D:D,'E. Summary'!C104,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A104,'C. Expenditures Data'!D:D,'E. Summary'!C104,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2022,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A105,'D. Member Months Data'!D:D,C105)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A105,'C. Expenditures Data'!D:D,'E. Summary'!C105,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A105,'C. Expenditures Data'!D:D,'E. Summary'!C105,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A105,'C. Expenditures Data'!D:D,'E. Summary'!C105,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A105,'C. Expenditures Data'!D:D,'E. Summary'!C105,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A105,'C. Expenditures Data'!D:D,'E. Summary'!C105,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A105,'C. Expenditures Data'!D:D,'E. Summary'!C105,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A105,'C. Expenditures Data'!D:D,'E. Summary'!C105,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A105,'C. Expenditures Data'!D:D,'E. Summary'!C105,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A106,'D. Member Months Data'!D:D,C106)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A106,'C. Expenditures Data'!D:D,'E. Summary'!C106,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A106,'C. Expenditures Data'!D:D,'E. Summary'!C106,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A106,'C. Expenditures Data'!D:D,'E. Summary'!C106,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A106,'C. Expenditures Data'!D:D,'E. Summary'!C106,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A106,'C. Expenditures Data'!D:D,'E. Summary'!C106,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A106,'C. Expenditures Data'!D:D,'E. Summary'!C106,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A106,'C. Expenditures Data'!D:D,'E. Summary'!C106,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A106,'C. Expenditures Data'!D:D,'E. Summary'!C106,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A107,'D. Member Months Data'!D:D,C107)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A107,'C. Expenditures Data'!D:D,'E. Summary'!C107,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A107,'C. Expenditures Data'!D:D,'E. Summary'!C107,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A107,'C. Expenditures Data'!D:D,'E. Summary'!C107,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A107,'C. Expenditures Data'!D:D,'E. Summary'!C107,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A107,'C. Expenditures Data'!D:D,'E. Summary'!C107,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A107,'C. Expenditures Data'!D:D,'E. Summary'!C107,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A107,'C. Expenditures Data'!D:D,'E. Summary'!C107,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A107,'C. Expenditures Data'!D:D,'E. Summary'!C107,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Commercial - Full Claims",3,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A108,'D. Member Months Data'!D:D,C108)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A108,'C. Expenditures Data'!D:D,'E. Summary'!C108,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A108,'C. Expenditures Data'!D:D,'E. Summary'!C108,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A108,'C. Expenditures Data'!D:D,'E. Summary'!C108,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A108,'C. Expenditures Data'!D:D,'E. Summary'!C108,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A108,'C. Expenditures Data'!D:D,'E. Summary'!C108,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A108,'C. Expenditures Data'!D:D,'E. Summary'!C108,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A108,'C. Expenditures Data'!D:D,'E. Summary'!C108,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A108,'C. Expenditures Data'!D:D,'E. Summary'!C108,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Commercial - Partial Claims",4,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A109,'D. Member Months Data'!D:D,C109)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A109,'C. Expenditures Data'!D:D,'E. Summary'!C109,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A109,'C. Expenditures Data'!D:D,'E. Summary'!C109,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A109,'C. Expenditures Data'!D:D,'E. Summary'!C109,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A109,'C. Expenditures Data'!D:D,'E. Summary'!C109,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A109,'C. Expenditures Data'!D:D,'E. Summary'!C109,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A109,'C. Expenditures Data'!D:D,'E. Summary'!C109,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A109,'C. Expenditures Data'!D:D,'E. Summary'!C109,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A109,'C. Expenditures Data'!D:D,'E. Summary'!C109,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A110,'D. Member Months Data'!D:D,C110)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A110,'C. Expenditures Data'!D:D,'E. Summary'!C110,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A110,'C. Expenditures Data'!D:D,'E. Summary'!C110,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A110,'C. Expenditures Data'!D:D,'E. Summary'!C110,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A110,'C. Expenditures Data'!D:D,'E. Summary'!C110,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A110,'C. Expenditures Data'!D:D,'E. Summary'!C110,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A110,'C. Expenditures Data'!D:D,'E. Summary'!C110,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A110,'C. Expenditures Data'!D:D,'E. Summary'!C110,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A110,'C. Expenditures Data'!D:D,'E. Summary'!C110,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A111,'D. Member Months Data'!D:D,C111)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A111,'C. Expenditures Data'!D:D,'E. Summary'!C111,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A111,'C. Expenditures Data'!D:D,'E. Summary'!C111,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A111,'C. Expenditures Data'!D:D,'E. Summary'!C111,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A111,'C. Expenditures Data'!D:D,'E. Summary'!C111,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A111,'C. Expenditures Data'!D:D,'E. Summary'!C111,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A111,'C. Expenditures Data'!D:D,'E. Summary'!C111,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A111,'C. Expenditures Data'!D:D,'E. Summary'!C111,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A111,'C. Expenditures Data'!D:D,'E. Summary'!C111,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A112,'D. Member Months Data'!D:D,C112)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A112,'C. Expenditures Data'!D:D,'E. Summary'!C112,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A112,'C. Expenditures Data'!D:D,'E. Summary'!C112,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A112,'C. Expenditures Data'!D:D,'E. Summary'!C112,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A112,'C. Expenditures Data'!D:D,'E. Summary'!C112,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A112,'C. Expenditures Data'!D:D,'E. Summary'!C112,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A112,'C. Expenditures Data'!D:D,'E. Summary'!C112,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A112,'C. Expenditures Data'!D:D,'E. Summary'!C112,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A112,'C. Expenditures Data'!D:D,'E. Summary'!C112,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2023,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A113,'D. Member Months Data'!D:D,C113)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A113,'C. Expenditures Data'!D:D,'E. Summary'!C113,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A113,'C. Expenditures Data'!D:D,'E. Summary'!C113,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"1\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A113,'C. Expenditures Data'!D:D,'E. Summary'!C113,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A113,'C. Expenditures Data'!D:D,'E. Summary'!C113,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"2\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A113,'C. Expenditures Data'!D:D,'E. Summary'!C113,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A113,'C. Expenditures Data'!D:D,'E. Summary'!C113,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"3\")","v":0},{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A113,'C. Expenditures Data'!D:D,'E. Summary'!C113,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")+SUMIFS('C. Expenditures Data'!N:N,'C. Expenditures Data'!B:B,'E. Summary'!A113,'C. Expenditures Data'!D:D,'E. Summary'!C113,'C. Expenditures Data'!J:J,\"3\",'C. Expenditures Data'!L:L,\"4\")","v":0}]

{"sheet":"Reference Tables","index":6,"n_rows":70,"n_cols":2,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Primary Care and Behavioral Health Expenditures"]
["Reference Tables"]
[]
["Insurance Category Code","Definition"]
[1,"Medicare & Medicare Advantage"]
[2,"Medicaid (e.g., ACO, MCO)"]
[3,"Commercial – Full Claims"]
[4,"Commercial – Partial Claims"]
[5,"SCO"]
[6,"OneCare"]
[7,"PACE"]
[8,"Other"]
[]
[]
["Product Type Code","Definition"]
[1,"HMO"]
[2,"PPO"]
[3,"Indemnity"]
[4,"Other"]
[5,"POS"]
[]
[]
["PCP Type Code","Definition"]
[1,"Data for members required to select a PCP as part of plan design"]
[2,"Data for members who are attributed to a PCP during reporting period pursuant to payer-provider risk contract"]
[3,"Data for members who are attributed to a PCP by payer’s own attribution methodology"]
[4,"Data for members who are not attributed to a PCP"]
[]
["Age Group Code","Age Group Definition "]
[1,"0-17"]
[2,"18-64"]
[3,"65+"]
[]
["Service Type Code","Service Type Definition "]
[1,"Mental Health"]
[2,"Substance Use Disorders"]
[3,"Primary Care "]
[4,"All Other Services "]
[]
["Service Category Code","Service Category Definition"]
[11,"MH Inpatient"]
[12,"MH Emergency Department-Observation"]
[13,"MH Outpatient: PC Provider"]
[14,"MH Outpatient: Non-PC Provider"]
[15,"MH Prescription Drugs "]
[21,"SUD Inpatient"]
[22,"SUD Emergency Department-Observation"]
[23,"SUD Outpatient: PC Provider"]
[24,"SUD Outpatient: Non-PC Provider"]
[25,"SUD Prescription Drugs "]
[31,"PC Office Type Visits"]
[32,"PC Home-Nursing Facility Visits "]
[33,"PC Behavioral Health Screening"]
[34,"PC Preventive Visits"]
[35,"PC Other Primary Care Visits"]
[36,"PC Immunizations and Injections"]
[37,"PC Obstetric Visits "]
[41,"Other Medical"]
[42,"Other Prescription Drugs"]
[51,"Non-Claims: Incentive Programs"]
[52,"Non-Claims: Capitation "]
[53,"Non-Claims: Risk Settlements"]
[54,"Non-Claims: Care Management "]
[55,"Non-Claims: Other"]
[]
["Provider Type Code","Provider Type Definition"]
[1,"Facility"]
[2,"Professional Physician"]
[3,"Professional Other"]
[4,"No Provider"]

{"sheet":"Payer Names","index":7,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Id","Name","ShortName","Id"]
[null,"Select Payer:"]
[290,"Aetna Health Inc.","Aetna",290]
[3735,"AllWays Health Partners","AllWays",3735]
[291,"Blue Cross Blue Shield of Massachusetts","BCBSMA",291]
[11226,"BMC HealthNet Plan","BMCHP",11226]
["00001","CHIA","CHIA","00001"]
[11726,"CIGNA - EAST ","Cigna-East",11726]
[11474,"CIGNA - WEST ","Cigna-West",11474]
[10728,"Commonwealth Care Alliance","CCA",10728]
[8026,"Fallon Community Health Plan","Fallon",8026]
[300,"Harvard Pilgrim Health Care","HPHC",300]
[302,"Health Plans Inc.","HPI",302]
[301,"Health New England","HNE",301]
[11227,"Tufts Public Plans ","THPP",11227]
[308,"Tufts Health Plan","THP",308]
[12103,"Tufts Medicare Advantage","Tufts Med Adv",12103]
[310,"UniCare Life and Health Insurance Company","UniCare",310]
[312,"United Healthcare Insurance Company","United ",312]
[10926,"United Medicare Advantage","United Med Adv",10926]
[12814,"United Senior Care Options (SCO)","United SCO",12814]
[3156,"MassHealth ","MassHealth",3156]

{"sheet":"System Data","index":8,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[true,"OnSaveFlag"]
[{"$f":"TODAY()","v":"2024-06-12"},"CurrentDate"]
[1,"iPayer"]
[{"$f":"'A. Front Page'!C12","v":0},"vYear"]
[{"$f":"IF(ISBLANK(iPayer),\"\",INDEX(PayersList,iPayer,3))","v":0},"vPayerShortName"]
[{"$f":"IF(ISBLANK(iPayer),\"\",INDEX(PayersList,iPayer,1))","v":0},"vPayerOrgID"]
[{"$f":"IF(ISBLANK(iPayer),\"\",INDEX(PayersList,iPayer,2))","v":"Select Payer:"},"vPayerName"]
[null,"FilingTypeID"]
[{"$f":"TEXT(A2,\"MMDDYYYY\")","v":"06122024"},"CurrentDateFormat"]
[{"$f":"\"Payer\"&\"_\"&A5&\"_\"&A4&\"_\"&A9&\".xlsm\"","v":"Payer_0_0_06122024.xlsm"},"vFileName"]
[]
[]
[]
[]
[{"$f":"IF(AND(A16=TRUE,A17=TRUE,A18=TRUE,A25=TRUE), TRUE, FALSE)","v":false},"cfAllFrontPageWorkSheet"]
[{"$f":"IF('A. Front Page'!B6=\"\", FALSE, TRUE)","v":false},"vContactName"]
[{"$f":"IF('A. Front Page'!B7=\"\", FALSE, TRUE)","v":false},"vContactEmail"]
[{"$f":"IF(AND(A19=TRUE, A20=TRUE,A21=TRUE,A22=TRUE,A23)=TRUE, TRUE, FALSE)","v":false},"cfFrontPageTableA1RequiredFields"]
[{"$f":"IF(OR('A. Front Page'!C10=\"\",'A. Front Page'!C10=\"Select Payer:\"), FALSE, TRUE)","v":false},"vPayerName"]
[{"$f":"IF('A. Front Page'!C11=\"\", FALSE, TRUE)","v":false},"vPayerOrgID"]
[{"$f":"IF('A. Front Page'!C12=\"\",FALSE, TRUE)","v":false},"vSubmissionYear"]
[{"$f":"IF('A. Front Page'!C13=\"\", FALSE, TRUE)","v":false},"vReportingYear"]
[{"$f":"IF('A. Front Page'!C14=\"\", FALSE, TRUE)","v":false},"vClaimsPaidThroughDate"]
[]
[{"$f":"IF(AND(A26=TRUE, A27=TRUE),TRUE, FALSE)","v":false},"cfFrontPageTableA2RequiredFields"]
[{"$f":"IF('A. Front Page'!C17=\"\", FALSE, TRUE)","v":false},"vTable2Q1DoesTheDataIncludeMassachusettsResidentsOnly"]
[{"$f":"IF('A. Front Page'!C18=\"\", FALSE, TRUE)","v":false},"vTable2Q2IstheDataLimitedOnlyToMembers forwhomthepayeristheprimarypayer"]