{"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: 2022 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":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[20,1,20,3],[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(ISBLANK(iPayer), \"\",INDEX(PayersList,iPayer,1))","v":0}]
[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) "]
[]
[null,"Table A.3: Substance Use Disorder Expenditures by Insurance Category                                                                                                                                                                                                                               "]
[null,"Insurance Category","CY2020 Expenses*","CY2021 Expenses"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"* Only for payers who are resubmitting 2020 data for the 2022 data collection cycle "]

{"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","Spending Service Category","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","Pediatric Indicator","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":11,"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","Pediatric Indicator","MassHealth ACO Indicator","GIC Indicator ","Member Months","BH Member Months"]

{"sheet":"E. Summary","index":5,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":false,"merged":[[5,0,5,10],[25,0,25,9],[45,0,45,9],[0,0,0,10],[2,0,2,1],[3,0,3,1],[1,0,1,1]]}
["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 ","BH PMPM","PC PMPM","Behavioral Health","Primary Care","All Other Services"]
[2020,"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(I8:K8)","v":0},{"$f":"IFERROR(E8/D8,\"0\")","v":"0"},{"$f":"IFERROR(I8/D8,\"0\")","v":"0"},{"$f":"IFERROR(J8/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}]
[2020,"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","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}]
[2020,"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",{"$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}]
[2020,"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",{"$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}]
[2020,"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",{"$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}]
[2020,"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",{"$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}]
[2020,"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",{"$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}]
[2020,"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",{"$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}]
[2021,"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},0,"0","0","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}]
[2021,"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","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}]
[2021,"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",{"$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}]
[2021,"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",{"$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}]
[2021,"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",{"$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}]
[2021,"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",{"$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}]
[2021,"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",{"$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}]
[2021,"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",{"$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}]
[]
[]
["Data Summary- Behavioral Health Services"]
["Year","Insurance Category ","Code","Member Months  ","BH Expenses","BH PMPM ","Facility","Professional Physician","Professional Other","No Provider"]
[2020,"Medicare & Medicare Advantage ",1,{"$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},{"$f":"SUM(G28:J28)","v":0},{"$f":"IFERROR(E28/D28,\"0\")","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,\"1\",'C. Expenditures Data'!L:L,\"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\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"Medicaid & Medicaid Managed Care (MCO)",2,{"$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,{"$f":"IFERROR(E29/D29,\"0\")","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,\"1\",'C. Expenditures Data'!L:L,\"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\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"Commercial - Full Claims",3,{"$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",{"$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\",'C. Expenditures Data'!L:L,\"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\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"Commercial - Partial Claims",4,{"$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",{"$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\",'C. Expenditures Data'!L:L,\"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\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"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,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"SCO",5,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A32,'D. Member Months Data'!D:D,C32)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A32,'C. Expenditures Data'!D:D,'E. Summary'!C32,'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'!A32,'C. Expenditures Data'!D:D,'E. Summary'!C32,'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'!A32,'C. Expenditures Data'!D:D,'E. Summary'!C32,'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'!A32,'C. Expenditures Data'!D:D,'E. Summary'!C32,'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'!A32,'C. Expenditures Data'!D:D,'E. Summary'!C32,'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'!A32,'C. Expenditures Data'!D:D,'E. Summary'!C32,'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'!A32,'C. Expenditures Data'!D:D,'E. Summary'!C32,'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'!A32,'C. Expenditures Data'!D:D,'E. Summary'!C32,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"OneCare",6,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A33,'D. Member Months Data'!D:D,C33)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A33,'C. Expenditures Data'!D:D,'E. Summary'!C33,'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'!A33,'C. Expenditures Data'!D:D,'E. Summary'!C33,'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'!A33,'C. Expenditures Data'!D:D,'E. Summary'!C33,'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'!A33,'C. Expenditures Data'!D:D,'E. Summary'!C33,'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'!A33,'C. Expenditures Data'!D:D,'E. Summary'!C33,'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'!A33,'C. Expenditures Data'!D:D,'E. Summary'!C33,'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'!A33,'C. Expenditures Data'!D:D,'E. Summary'!C33,'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'!A33,'C. Expenditures Data'!D:D,'E. Summary'!C33,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"PACE",7,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A34,'D. Member Months Data'!D:D,C34)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A34,'C. Expenditures Data'!D:D,'E. Summary'!C34,'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'!A34,'C. Expenditures Data'!D:D,'E. Summary'!C34,'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'!A34,'C. Expenditures Data'!D:D,'E. Summary'!C34,'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'!A34,'C. Expenditures Data'!D:D,'E. Summary'!C34,'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'!A34,'C. Expenditures Data'!D:D,'E. Summary'!C34,'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'!A34,'C. Expenditures Data'!D:D,'E. Summary'!C34,'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'!A34,'C. Expenditures Data'!D:D,'E. Summary'!C34,'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'!A34,'C. Expenditures Data'!D:D,'E. Summary'!C34,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"Other ",8,{"$f":"SUMIFS('D. Member Months Data'!J:J,'D. Member Months Data'!B:B,'E. Summary'!A35,'D. Member Months Data'!D:D,C35)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A35,'C. Expenditures Data'!D:D,'E. Summary'!C35,'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'!A35,'C. Expenditures Data'!D:D,'E. Summary'!C35,'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'!A35,'C. Expenditures Data'!D:D,'E. Summary'!C35,'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'!A35,'C. Expenditures Data'!D:D,'E. Summary'!C35,'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'!A35,'C. Expenditures Data'!D:D,'E. Summary'!C35,'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'!A35,'C. Expenditures Data'!D:D,'E. Summary'!C35,'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'!A35,'C. Expenditures Data'!D:D,'E. Summary'!C35,'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'!A35,'C. Expenditures Data'!D:D,'E. Summary'!C35,'C. Expenditures Data'!J:J,\"1\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[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},0,"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}]
[]
[]
["Data Summary- Primary Care Services"]
["Year","Insurance Category ","Code","Member Months  ","PC Expenses","PC PMPM","Facility","Professional Physician","Professional Other","No Provider"]
[2020,"Medicare & Medicare Advantage ",1,{"$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},{"$f":"SUM(G48:J48)","v":0},{"$f":"IFERROR(E48/D48,\"0\")","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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"Medicaid & Medicaid Managed Care (MCO)",2,{"$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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"Commercial - Full Claims",3,{"$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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"Commercial - Partial Claims",4,{"$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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"SCO",5,{"$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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"OneCare",6,{"$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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"PACE",7,{"$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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2020,"Other ",8,{"$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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'C. Expenditures Data'!L:L,\"4\")","v":0}]
[2021,"Medicare & Medicare Advantage ",1,{"$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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"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'!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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"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'!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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"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'!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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"2\",'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,\"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'!A60,'D. Member Months Data'!D:D,C60)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A60,'C. Expenditures Data'!D:D,'E. Summary'!C60,'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'!A60,'C. Expenditures Data'!D:D,'E. Summary'!C60,'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'!A60,'C. Expenditures Data'!D:D,'E. Summary'!C60,'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'!A60,'C. Expenditures Data'!D:D,'E. Summary'!C60,'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'!A60,'C. Expenditures Data'!D:D,'E. Summary'!C60,'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'!A60,'C. Expenditures Data'!D:D,'E. Summary'!C60,'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'!A60,'C. Expenditures Data'!D:D,'E. Summary'!C60,'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'!A60,'C. Expenditures Data'!D:D,'E. Summary'!C60,'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'!A61,'D. Member Months Data'!D:D,C61)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A61,'C. Expenditures Data'!D:D,'E. Summary'!C61,'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'!A61,'C. Expenditures Data'!D:D,'E. Summary'!C61,'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'!A61,'C. Expenditures Data'!D:D,'E. Summary'!C61,'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'!A61,'C. Expenditures Data'!D:D,'E. Summary'!C61,'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'!A61,'C. Expenditures Data'!D:D,'E. Summary'!C61,'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'!A61,'C. Expenditures Data'!D:D,'E. Summary'!C61,'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'!A61,'C. Expenditures Data'!D:D,'E. Summary'!C61,'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'!A61,'C. Expenditures Data'!D:D,'E. Summary'!C61,'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'!A62,'D. Member Months Data'!D:D,C62)","v":0},0,"0",{"$f":"SUMIFS('C. Expenditures Data'!M:M,'C. Expenditures Data'!B:B,'E. Summary'!A62,'C. Expenditures Data'!D:D,'E. Summary'!C62,'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'!A62,'C. Expenditures Data'!D:D,'E. Summary'!C62,'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'!A62,'C. Expenditures Data'!D:D,'E. Summary'!C62,'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'!A62,'C. Expenditures Data'!D:D,'E. Summary'!C62,'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'!A62,'C. Expenditures Data'!D:D,'E. Summary'!C62,'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'!A62,'C. Expenditures Data'!D:D,'E. Summary'!C62,'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'!A62,'C. Expenditures Data'!D:D,'E. Summary'!C62,'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'!A62,'C. Expenditures Data'!D:D,'E. Summary'!C62,'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'!A63,'D. Member Months Data'!D:D,C63)","v":0},0,"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}]

{"sheet":"Reference Tables","index":6,"n_rows":58,"n_cols":2,"rows_kept":58,"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","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"]
[]
["Service Type Code","Service Type Definition "]
[1,"Behavioral Health"]
[2,"Primary Care"]
[3,"All Other Services "]
[]
["Service Category Code","Service Category Definitions"]
[11,"BH Inpatient"]
[12,"BH Emergency Department-Observation"]
[13,"BH Outpatient "]
[14,"BH Prescription Drugs "]
[21,"PC Office Types"]
[22,"PC Home-Nursing Facility Visits "]
[23,"PC Preventive Visits"]
[24,"PC Other Primary Care Visits"]
[25,"PC Immunizations and Injections"]
[26,"PC Obstetric Visits "]
[31,"Other Medical"]
[32,"Other "]
[33,"Other Prescription Drugs"]
[41,"Non-Claims: Incentive Programs"]
[42,"Non-Claims: Capitation "]
[43,"Non-Claims: Risk Settlements"]
[44,"Non-Claims: Care Management "]
[45,"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":"2022-10-05"},"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":"10052022"},"CurrentDateFormat"]
[{"$f":"\"Payer\"&\"_\"&A5&\"_\"&A4&\"_\"&A9&\".xlsm\"","v":"Payer_0_0_10052022.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":true},"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"]