{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Contents","A. Front Page","B. Zip Code","C. Physician Group","D.1 Summary","D.2 Summary Trends","Reference Tables","Payer Names","System Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"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":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Total Medical Expenses and Alternative Payment Methods"]
["DRAFT Data Submission Workbook: 2019 Reporting Cycle"]
[]
["CHIA Submissions Portal"]
["TME/APM Data Specification Manual "]
[]
["This workbook contains the following tabs:"]
[]
["Tab Name","Contents"]
["A. Front Page","Payer Data Entry: Overview of File and Data Verification"]
["B. Zip Code","Payer Data Entry: Zip Code Records"]
["C. Physician Group","Payer Data Entry: Physician Group Records"]
["D.1 Summary","Automated Calculation"]
["D.2 Summary Trends","Automated Calculation"]
["Reference Tables","Lookup Tables for Data Element Response Codes"]

{"sheet":"A. Front Page","index":1,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[34,1,34,4],[8,1,8,2],[20,1,20,2]]}
["Total Medical Expenses and Alternative Payment Methods"]
["A. File Overview and Payer Verification"]
[]
[]
[null,"I verify that the information in this workbook is accurate."]
["Contact Name:","CHIA Test ","[Input Required]"]
["Contact Email:","Erin.Bonney@state.ma.us ","[Input Required]"]
[]
[null,"Table A.1: File Overview",null,"[Input Required]"]
[null,"Payer Name  *",{"$f":"IF(ISBLANK(iPayer), \"\",INDEX(PayersList,iPayer,2))","v":"CHIA"}]
[null,"Payer OrgID",{"$f":"IF(ISBLANK(iPayer), \"\",INDEX(PayersList,iPayer,1))","v":"00001"}]
[null,"Submission Year    *",2019]
[null,"Preliminary Data: Reporting Year    *",2018]
[null,"Preliminary Data: Claims Paid Through Date   *","2019-04-01"]
[null,"Final Data: Reporting Year   *",2017]
[null,"Final Data: Claims Paid Through Date   *","2019-04-01"]
[null,"Final Resubmission Included?  *","Y"]
[null,"Final Resubmission Data: Reporting Year  *",2016]
[null,"Final Resubmission Data: Claims Paid Through Date  *","2018-12-31"]
[]
[null,"Table A.2: Additional Data Confirmation                                                                                                                                                                                                                                ",null,"[Input Required]"]
[null,"Health Status Adjustment Tool  *","Example Risk Tool "]
[null,"Health Status Adjustment Tool Version  *",1]
[null,"Is the Risk Adjustment Tool concurrent?  *","Y"]
[null,"Does the Risk Adjustment Tool use truncation?  *","N"]
[null,"Is the Risk Adjustment Tool based on all-encounter diagnosis-based inputs?  *","Y"]
[null,"Is pharmacy data an input in your risk adjustment tool?  *","N"]
[null,"Are IBNR Factors applied to Prelim data?  *","Y"]
[null,"Does the data include Massachusetts zip codes only?  *","Y"]
[null,"Does the data include Massachusetts residents only?   *","Y"]
[null,"Is the data limited only to members  for whom the payer is the primary payer? *","Y"]
[null,"Zip Code File Comments "]
[null,"Physician File Comments"]
[]
[null,"Table A.3: Commercial Partial Member Months by Carved-Out Benefits"]
[null,"Carved-Out Benefit","Commercial Partial MM CY 2016","Commercial Partial MM CY 2017","Commercial Partial MM CY 2018"]
[null,"Pharmacy Only",20000,21000,22000]
[null,"Behavioral Health Only",0,0,0]
[null,"Pharmacy and Behavioral Health",0,0,0]
[null,"Other Services (not pharmacy and behavioral health)",10000,10000,10000]
[null,"Pharmacy and Other",0,0,0]
[null,"Behavioral Health and Other",0,0,0]
[null,"Pharmacy, Behavioral Health, and Other",0,0,0]

{"sheet":"B. Zip Code","index":2,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Total Medical Expenses and Alternative Payment Methods",null,null,null,null,null,null,null,null,""]
["B. Zip Code TME and APM Records"]
["[All columns must be filled in*]"]
["Submission Type *","Reporting Year   *","Zip Code  *","Insurance Category     Code *","Product Type    Code *","PCP Type Indicator  *","Payment Method    Code  *","Member Months *","HSA Score *","Claims: Hospital Inpatient  *","Claims: Hospital Outpatient  *","Claims: Professional Physician  *","Claims: Professional Other  *","Claims: Pharmacy   *","Claims: Other  *","Total Non-Claims Payments   *"]
["F",2016,"02114",1,1,1,5,20740,0.50249999999999995,6156550,2826744.1199999996,4411205.79,2310470.37,4370704.75,1981872.76,25729.99]
["F",2016,"02114",2,1,1,5,4515340,2.1117197552397147,459129198,428304598.18000001,282237759.61999995,75536873.020000011,507273864.62000006,169391362.82000005,225225369.97999993]
["F",2016,"01095",3,1,1,"1A",1281073,0.41249999999999998,66732012,67975128.489999995,100462632.48,29423088.960000001,111864210.73,97358016.299999997,661660.12]
["F",2016,"01095",3,2,2,2,407587,0.67999999999999994,19074608,32444896.160000004,18578466.039999999,2944202.08,32534382.23,8123214.0600000005,5589337.4100000001]
["F",2016,"02134",3,1,1,5,155106,0.35599999999999998,8026843,17790988.810000002,14511843.459999997,3717336.2800000003,14149304.859999999,2814996.42,0]
["F",2016,"02445",3,1,1,5,6731200,0.74564207239062097,622756852,831061686.13999975,1088318928.01,169477526.54999998,596103527.36000013,129086284.45,86302277.723700002]
["F",2016,"02445",4,1,1,"1A",1169626,0.51249999999999996,64508401,62898427.5,87730850.280000001,24540203.120000001,21875184.27,66209045.100000001,436988.56]
["F",2016,"02169",4,2,2,2,179,1.65,0,825,1958.8899999999999,0,374.05,0,0]
["F",2016,"01002",4,1,1,5,553957,0.5,54872333,71572341,96171347,3847317,49663276,12285060,0]
["F",2016,"01453",5,1,1,5,554,6.1,235091,224066.23,92075.38,17023.060000000001,390941.46,472909.19,0]
["F",2016,"02139",5,1,1,"1A",176359,0.73,56579170,41353349.329999998,5709090.3899999997,2249902.81,75265952.519999996,252989504.06999999,61044343.780000001]
["F",2016,"01095",6,2,2,2,32422,1.6647222222222224,19504180,12027162.459799999,5228848.3101000004,3118472.1498999996,20527641.6899,12552408.449899999,0]
["F",2017,"02114",1,1,1,5,21703,0.47250000000000003,6819544,2814428.3600000003,4531671.6000000006,2660013.33,5174793.84,2106673.44,29446.41]
["F",2017,"02114",2,1,1,5,4033838,2.1880826765743127,417320842,418993241.44000006,253336193.46000001,75536875.019999996,528461936.87999988,162311398.70000002,238146630.51999998]
["F",2017,"01095",3,1,1,"1A",1294701,0.41,68400509,68867471.420000002,104366363.84999999,31318940.98,120794735.75,97325065.199999988,728910.24]
["F",2017,"01095",3,2,2,2,840361,0.72256848101166904,40551116,78258036.920000002,37192982.179999992,6667885.9199999999,61553722.650000006,14006299.870000001,8657053.6799999997]
["F",2017,"02134",3,1,1,5,189098,0.34399999999999997,14577129,22520606.129999999,19088676.5,4920454.3899999997,17427404.629999999,3173190.22,0]
["F",2017,"02445",3,1,1,5,5754914,0.84374203644214296,548743208,760756362.38999999,959314732.94999957,156961507.42000002,511151990.96999997,102539236.59000002,123803389.08600004]
["F",2017,"02445",4,1,1,"1A",1211978,0.50750000000000006,64384691,65172998.780000001,93082208.989999995,27260599.280000001,25864498,73310903.060000002,526204.17000000004]
["F",2017,"02169",4,2,2,2,75,0.96833333333333327,24182,10200.56,12752.99,378.25,2221.7200000000003,22.009999999999998,0]
["F",2017,"01002",4,1,1,5,593902,0.5,62780515,83533206,109142909,3733367,54102782,13682122,0]
["F",2017,"01453",5,1,1,5,4030,5.73,1646133,1574370.06,620897.46,103878.77,2322837.02,2863552.32,0]
["F",2017,"02139",5,1,1,"1A",192989,1.21,62415887,42098912.280000001,5223467.43,1867890.32,86420522.700000003,278468783.83999997,58880670.579999998]
["F",2017,"01095",6,2,2,2,38641,1.7131481481481476,19912600,13212999.8299,6425525.8632000005,3938421.2719999985,23651298.479999997,15984914.955499995,0]
["P",2018,"02114",1,1,1,5,21920.03,0.47722500000000001,6887739.4400000004,2842572.6436000005,4576988.3160000006,2686613.4632999999,5226541.7784000002,2127740.1743999999,29740.874100000001]
["P",2018,"02114",2,1,1,5,4235529.9000000004,2.2974868104030284,438186884.10000002,439942903.51200008,262643003.13300008,76988201.11500001,554885033.72399986,170426968.63500002,250053962.046]
["P",2018,"01095",3,1,1,"1A",1359436.05,0.43049999999999999,71820534.450000003,72310844.991000012,109584682.0425,32884888.029000003,126834462.03750001,102191318.45999999,765355.75199999998]
["P",2018,"01095",3,2,2,2,882379.05,0.75869690506225251,42578671.800000004,82170938.766000003,39052631.288999997,7001280.216,64631408.782500006,14706614.863500001,9089906.3640000001]
["P",2018,"02134",3,1,1,5,198552.9,0.36119999999999997,15305985.450000001,23646636.436500002,20043110.324999999,5166477.1095000003,18298774.861499999,3331849.7310000001,0]
["P",2018,"02445",3,1,1,5,6042659.7000000002,0.88592913826425013,576180368.39999998,798794180.50950003,1007280469.5974996,164809582.79100004,536709590.51849997,107666198.41950002,129993558.54030004]
["P",2018,"02445",4,1,1,"1A",1260457.1200000001,0.52780000000000005,66960078.640000001,67779918.73120001,96805497.349600002,28351023.251200002,26899077.920000002,76243339.182400003,547252.33680000005]
["P",2018,"02169",4,2,2,2,78,1.0070666666666666,24109.280000000002,10420.342400000001,13263.1096,393.38,2310.5888000000004,22.8904,0]
["P",2018,"01002",4,1,1,5,617658.08000000007,0.52,65291735.600000001,86874534.24000001,113508625.36,3882701.68,56266893.280000001,14229406.880000001,0]
["P",2018,"01453",5,1,1,5,664.8,7.3199999999999994,282109.2,268879.47600000002,110490.45600000001,20427.672000000002,469129.75200000004,567491.02799999993,0]
["P",2018,"02139",5,1,1,"1A",211630.8,0.876,67895004,49624019.195999995,6850908.4679999994,2699883.372,90319143.023999989,303587404.884,73253212.535999998]
["P",2018,"01095",6,2,2,2,46372.2,2.0557777777777773,23895073.199999999,15855599.795879999,7710631.03584,4726105.526399998,28381558.175999995,19181897.946599994,0]

{"sheet":"C. Physician Group","index":3,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Total Medical Expenses and Alternative Payment Methods"]
["C. Physician Group TME and APM Records"]
["[All columns must be filled in*]"]
["Submission Type  *","Reporting Year  *","Physician Group OrgID   *","Local Practice Group       OrgID   *","Insurance Category       Code   *","Product Type Code  *","PCP Type Indicator  *","Payment Method      Code  *","Risk Type     Code  *","Pediatric Indicator  *","MassHealth ACO           Indicator   *","Member Months  *","HSA Score  *","Claims: Hospital Inpatient  *","Claims: Hospital Outpatient  *","Claims: Professional Physician  *","Claims: Professional Other  *","Claims: Pharmacy   *","Claims:      Other  *","Non-Claims: Incentive Programs   *","Non-Claims: Capitation   *","Non-Claims: Risk Settlements   *","Non-Claims: Care Management *","Non-Claims: Other   *"]
["F",2016,12345,11111,1,1,1,5,2,0,0,20740,0.50249999999999995,6156550,2826744.1199999996,4411205.79,2310470.37,4370704.75,1981888.76,25729.99]
["F",2016,23456,11112,2,1,1,5,1,0,1,4515450,2.1117197552397147,459129198,428304598.18000001,282237759.61999995,75536873.020000011,507273864.62000006,169391362.82000005,225225369.97999993]
["F",2016,34567,11113,3,1,1,"1A",1,0,0,1281073,0.41249999999999998,66732012,67975128.489999995,100462632.48,29423087.960000001,111864210.73,97358016.299999997,661651.12]
["F",2016,45678,11114,3,2,2,2,1,0,0,407587,0.67999999999999994,19074608,32444896.160000004,18578466.039999999,2944202.08,32534382.23,8123214.0600000005,5589337.4100000001]
["F",2016,12345,11111,3,1,1,5,1,0,0,155106,0.35599999999999998,8026843,17790988.810000002,14511843.459999997,3717336.2800000003,14149304.859999999,2814996.42,0]
["F",2016,23456,11112,3,1,1,5,1,0,1,6731200,0.74564207239062097,622756852,831061686.13999975,1088318928.01,169477526.54999998,596103527.36000013,129086284.45,86302277.723700002]
["F",2016,34567,11113,4,1,1,"1A",2,0,0,1169626,0.51249999999999996,64508401,62898427.5,87730850.280000001,24540203.120000001,21875184.27,66209045.100000001,436988.56]
["F",2016,45678,11114,4,2,2,2,2,0,0,175,1.65,0,900,1958.8899999999999,0,374.05,0,0]
["F",2016,12345,11111,4,1,1,5,2,0,0,553957,0.5,54872333,71572341,96171347,3847317,49663276,12285060,0]
["F",2016,23456,11112,5,1,1,5,3,1,1,554,6.1,235091,224066.23,92075.38,17023.060000000001,390941.46,472909.19,0]
["F",2016,34567,11113,5,1,1,"1A",3,0,0,176359,0.73,56579170,41353349.329999998,5709090.3899999997,2249902.81,75265952.519999996,252989504.06999999,61044343.780000001]
["F",2016,45678,11114,6,2,2,2,1,1,0,32422,1.6647222222222224,19504180,12027162.459799999,5228848.3101000004,3118472.1498999996,20527641.6899,12552408.449899999,0]
["F",2017,12345,11111,1,1,1,5,2,0,0,21703,0.47250000000000003,6819544,2814428.3600000003,4531671.6000000006,2660013.33,5174793.84,2106673.44,29446.41]
["F",2017,23456,11112,2,1,1,5,1,0,1,4033838,2.1880826765743127,417320842,418993241.44000006,253336193.46000001,75536875.019999996,528461936.87999988,162311398.70000002,238146630.51999998]
["F",2017,34567,11113,3,1,1,"1A",1,0,0,1294701,0.41,68400509,68867471.420000002,104366363.84999999,31318940.98,120794725.75,97325065.199999988,728910.24]
["F",2017,45678,11114,3,2,2,2,1,0,0,840361,0.72256848101166904,40551116,78258036.920000002,37192982.179999992,6667885.9199999999,61553722.650000006,14006310.869999999,8657053.6799999997]
["F",2017,12345,11111,3,1,1,5,1,0,0,189098,0.34399999999999997,14577129,22520606.129999999,19088676.5,4920454.3899999997,17427404.629999999,3173190.22,0]
["F",2017,23456,11112,3,1,1,5,1,0,1,5754914,0.84374203644214296,548743208,760756362.38999999,959314732.94999957,156961507.42000002,511151990.96999997,102539236.59000002,123803389.08600004]
["F",2017,34567,11113,4,1,1,"1A",2,0,0,1211978,0.50750000000000006,64384691,65172998.780000001,93082208.989999995,27260599.280000001,25864498,73310903.060000002,526204.17000000004]
["F",2017,45678,11114,4,2,2,2,2,0,0,75,0.96833333333333327,23182,10019.560000000001,12752.99,378.25,2221.7200000000003,22.009999999999998,0]
["F",2017,12345,11111,4,1,1,5,2,0,0,593902,0.5,62780515,83533206,109142909,3733367,54102782,13682122,0]
["F",2017,23456,11112,5,1,1,5,3,1,1,4030,5.73,1646133,1574370.06,620887.46,103878.77,2322837.02,2863553.32,0]
["F",2017,34567,11113,5,1,1,"1A",3,0,0,192989,1.21,62415887,42098912.280000001,5223467.43,1867890.32,86420522.700000003,278468783.83999997,58880670.579999998]
["F",2017,45678,11114,6,2,2,2,1,1,0,38641,1.7131481481481476,19912561,13212989.8299,6425525.8632000005,3938421.2719999985,23651298.479999997,15984914.955499995,0]
["P",2018,12345,11111,1,1,1,5,2,0,0,21920.03,0.47722500000000001,6887739.4400000004,2842572.6436000005,4576988.3160000006,2686613.4632999999,5226541.7784000002,2127740.1743999999,29740.874100000001]
["P",2018,23456,11112,2,1,1,5,1,0,1,4235529.9000000004,2.2974868104030284,438186884.10000002,439942903.51200008,262643003.13300008,76988201.11500001,554885033.72399986,170426968.63500002,250053962.046]
["P",2018,34567,11113,3,1,1,"1A",1,0,0,1359436.05,0.43049999999999999,71820534.450000003,72310844.991000012,109584682.0425,32884888.029000003,126834462.03750001,102191318.45999999,765355.75199999998]
["P",2018,45678,11114,3,2,2,2,1,0,0,882379.05,0.75869690506225251,42578671.800000004,82170938.766000003,39052631.288999997,7001280.216,64631408.782500006,14706614.863500001,9089906.3640000001]
["P",2018,12345,11111,3,1,1,5,1,0,0,198552.9,0.36119999999999997,15305985.450000001,23646636.436500002,20043110.324999999,5166477.1095000003,18298774.861499999,3331849.7310000001,0]
["P",2018,23456,11112,3,1,1,5,1,0,1,6042659.7000000002,0.88592913826425013,576180368.39999998,798794180.50950003,1007280469.5974996,164809582.79100004,536709590.51849997,107666198.41950002,129993558.54030004]
["P",2018,34567,11113,4,1,1,"1A",2,0,0,1260457.1200000001,0.52780000000000005,66960078.640000001,67779918.73120001,96805497.349600002,28351023.251200002,26899077.920000002,76243339.182400003,547252.33680000005]
["P",2018,45678,11114,4,2,2,2,2,0,0,78,1.0070666666666666,24109.280000000002,10420.342400000001,13263.1096,393.38,2310.5888000000004,22.8904,0]
["P",2018,12345,11111,4,1,1,5,2,0,0,617658.08000000007,0.52,65291735.600000001,86874534.24000001,113508625.36,3882701.68,56266893.280000001,14229406.880000001,0]
["P",2018,23456,11112,5,1,1,5,3,1,1,664.8,7.3199999999999994,282109.2,268879.47600000002,110490.45600000001,20427.672000000002,469129.75200000004,567491.02799999993,0]
["P",2018,34567,11113,5,1,1,"1A",3,0,0,211630.8,0.876,67895004,49624019.195999995,6850908.4679999994,2699883.372,90319143.023999989,303587404.884,73253212.535999998]
["P",2018,45678,11114,6,2,2,2,1,1,0,46369.2,2.0557777777777773,23895073.199999999,15855599.795879999,7710631.03584,4726105.526399998,28381558.175999995,19181897.946599994,0]

{"sheet":"D.1 Summary","index":4,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,1,2,16],[27,1,27,16]]}
[]
["Table A: Zip Code TME&APM Summary "]
[null,"TME and APM Data Summary - Zip Code"]
[null,"Year","Insurance Category ","Code","Member Months  ","Wtd Member Months "," Average HSA ","Total Expenses","TME PMPM ","HSA TME PMPM"," Inpatient","Outpatient","Prof. Physician","Prof. Other","Rx ","Other","Non-Claims "]
[null,2016,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,D5)","v":20740},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,D5)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,D5)),\"0\")","v":10421.849999999999},{"$f":"IFERROR(F5/E5,\"0\")","v":0.50249999999999995},{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,'D.1 Summary'!D5)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,'D.1 Summary'!D5)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,'D.1 Summary'!D5)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,'D.1 Summary'!D5)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,'D.1 Summary'!D5)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,'D.1 Summary'!D5)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,'D.1 Summary'!D5))","v":22083277.780000001},{"$f":"IFERROR(H5/E5,\"0\")","v":1064.7674918032787},{"$f":"IFERROR(H5/F5,\"0\")","v":2118.94028219558},{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,D5)","v":6156550},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,D5)","v":2826744.1199999996},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,D5)","v":4411205.79},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,D5)","v":2310470.37},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,D5)","v":4370704.75},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,D5)","v":1981872.76},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B5,'B. Zip Code'!D:D,D5)","v":25729.99}]
[null,2016,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,D6)","v":4515340},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,D6)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,D6)),\"0\")","v":9535132.6796240937},{"$f":"IFERROR(F6/E6,\"0\")","v":2.1117197552397147},{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,'D.1 Summary'!D6)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,'D.1 Summary'!D6)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,'D.1 Summary'!D6)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,'D.1 Summary'!D6)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,'D.1 Summary'!D6)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,'D.1 Summary'!D6)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!P:P,'D.1 Summary'!D6))","v":1921873656.2600002},{"$f":"IFERROR(H6/E6,\"0\")","v":425.63210218056673},{"$f":"IFERROR(H6/F6,\"0\")","v":201.55709635450683},{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,D6)","v":459129198},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,D6)","v":428304598.18000001},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,D6)","v":282237759.61999995},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,D6)","v":75536873.020000011},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,D6)","v":507273864.62000006},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,D6)","v":169391362.82000005},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B6,'B. Zip Code'!D:D,D6)","v":225225369.97999993}]
[null,2016,"Commercial - Full Claims",3,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,D7)","v":8574966},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,D7)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,D7)),\"0\")","v":4703673.4174797777},0.54853551809765522,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,'D.1 Summary'!D7)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,'D.1 Summary'!D7)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,'D.1 Summary'!D7)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,'D.1 Summary'!D7)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,'D.1 Summary'!D7)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,'D.1 Summary'!D7)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!P:P,'D.1 Summary'!D7))","v":4085330974.8700004},476.42532633598785,868.5405240270519,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,D7)","v":716590315},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,D7)","v":949272699.59999979},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,D7)","v":1221871869.99},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,D7)","v":205562153.86999997},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,D7)","v":754651425.18000007},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,D7)","v":237382511.23000002},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B7,'B. Zip Code'!D:D,D7)","v":92553275.253700003}]
[null,2016,"Commercial - Partial Claims",4,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,D8)","v":1723762},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,D8)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,D8)),\"0\")","v":1529838.7749999997},0.88749999999999984,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,'D.1 Summary'!D8)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,'D.1 Summary'!D8)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,'D.1 Summary'!D8)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,'D.1 Summary'!D8)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,'D.1 Summary'!D8)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,'D.1 Summary'!D8)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!P:P,'D.1 Summary'!D8))","v":616176943.21000004},357.4605677639953,402.77247071999477,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,D8)","v":119380734},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,D8)","v":134471593.5},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,D8)","v":183904156.17000002},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,D8)","v":28387520.120000001},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,D8)","v":71538834.319999993},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,D8)","v":78494105.099999994},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B8,'B. Zip Code'!D:D,D8)","v":436988.56}]
[null,2016,"Medicare and Medicaid Dual Eligibles ages 65 and over",5,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,D9)","v":176913},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,D9)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,D9)),\"0\")","v":604157.89500000002},3.415,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,'D.1 Summary'!D9)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,'D.1 Summary'!D9)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,'D.1 Summary'!D9)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,'D.1 Summary'!D9)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,'D.1 Summary'!D9)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,'D.1 Summary'!D9)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!P:P,'D.1 Summary'!D9))","v":435579075.44},2462.108920429816,720.96893716832085,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,D9)","v":56814261},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,D9)","v":41577415.559999995},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,D9)","v":5801165.7699999996},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,D9)","v":2266925.87},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,D9)","v":75656893.979999989},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,D9)","v":253462413.25999999},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B9,'B. Zip Code'!D:D,D9)","v":61044343.780000001}]
[null,2016,"Medicare and Medicaid Dual Eligibles afes 21-64",6,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,D10)","v":32422},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,D10)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,D10)),\"0\")","v":53973.623888888898},1.6647222222222224,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,'D.1 Summary'!D10)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,'D.1 Summary'!D10)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,'D.1 Summary'!D10)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,'D.1 Summary'!D10)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,'D.1 Summary'!D10)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,'D.1 Summary'!D10)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!P:P,'D.1 Summary'!D10))","v":72958713.059599996},2250.2841607427054,1351.7475352367326,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,D10)","v":19504180},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,D10)","v":12027162.459799999},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,D10)","v":5228848.3101000004},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,D10)","v":3118472.1498999996},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,D10)","v":20527641.6899},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,D10)","v":12552408.449899999},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B10,'B. Zip Code'!D:D,D10)","v":0}]
[null,2016,"Other",7,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,D11)","v":0},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,D11)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,D11)),\"0\")","v":"0"},"0",{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,'D.1 Summary'!D11)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,'D.1 Summary'!D11)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,'D.1 Summary'!D11)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,'D.1 Summary'!D11)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,'D.1 Summary'!D11)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,'D.1 Summary'!D11)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!P:P,'D.1 Summary'!D11))","v":0},"0","0",{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,D11)","v":0},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,D11)","v":0},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,D11)","v":0},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,D11)","v":0},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,D11)","v":0},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,D11)","v":0},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B11,'B. Zip Code'!D:D,D11)","v":0}]
[null,2017,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,D12)","v":21703},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,D12)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,D12)),\"0\")","v":10254.667500000001},0.47250000000000009,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,'D.1 Summary'!D12)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,'D.1 Summary'!D12)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,'D.1 Summary'!D12)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,'D.1 Summary'!D12)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,'D.1 Summary'!D12)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,'D.1 Summary'!D12)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!P:P,'D.1 Summary'!D12))","v":24107124.57},1110.7738363359904,2350.8440980655878,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,D12)","v":6819544},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,D12)","v":2814428.3600000003},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,D12)","v":4531671.6000000006},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,D12)","v":2660013.33},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,D12)","v":5174793.84},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,D12)","v":2106673.44},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B12,'B. Zip Code'!D:D,D12)","v":29446.41}]
[null,2017,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,D13)","v":4033838},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,D13)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,D13)),\"0\")","v":8826371.0479071718},2.1880826765743127,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,'D.1 Summary'!D13)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,'D.1 Summary'!D13)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,'D.1 Summary'!D13)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,'D.1 Summary'!D13)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,'D.1 Summary'!D13)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,'D.1 Summary'!D13)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!P:P,'D.1 Summary'!D13))","v":1855960487.5},460.09792349122597,210.27446924974544,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,D13)","v":417320842},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,D13)","v":418993241.44000006},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,D13)","v":253336193.46000001},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,D13)","v":75536875.019999996},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,D13)","v":528461936.87999988},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,D13)","v":162311398.70000002},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B13,'B. Zip Code'!D:D,D13)","v":238146630.51999998}]
[null,2017,"Commercial - Full Claims",3,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,D14)","v":8079074},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,D14)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,D14)),\"0\")","v":4686490.0933719091},0.58007762936345297,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,'D.1 Summary'!D14)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,'D.1 Summary'!D14)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,'D.1 Summary'!D14)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,'D.1 Summary'!D14)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,'D.1 Summary'!D14)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,'D.1 Summary'!D14)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!P:P,'D.1 Summary'!D14))","v":3850477628.9299998},476.59888112548538,821.61224118999428,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,D14)","v":672271962},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,D14)","v":930402476.86000001},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,D14)","v":1119962755.4799995},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,D14)","v":199868788.71000001},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,D14)","v":710927854},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,D14)","v":217043791.88},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B14,'B. Zip Code'!D:D,D14)","v":133189353.00600004}]
[null,2017,"Commercial - Partial Claims",4,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,D15)","v":1805955},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,D15)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,D15)),\"0\")","v":1189422.0291666668},0.65861111111111115,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,'D.1 Summary'!D15)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,'D.1 Summary'!D15)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,'D.1 Summary'!D15)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,'D.1 Summary'!D15)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,'D.1 Summary'!D15)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,'D.1 Summary'!D15)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!P:P,'D.1 Summary'!D15))","v":676100557.6400001},374.37287066399779,568.42780868426485,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,D15)","v":127189388},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,D15)","v":148716405.34},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,D15)","v":202237870.97999999},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,D15)","v":30994344.530000001},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,D15)","v":79969501.719999999},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,D15)","v":86993047.070000008},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B15,'B. Zip Code'!D:D,D15)","v":526204.17000000004}]
[null,2017,"Medicare and Medicaid Dual Eligibles ages 65 and over",5,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,D16)","v":197019},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,D16)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,D16)),\"0\")","v":683655.93},3.47,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,'D.1 Summary'!D16)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,'D.1 Summary'!D16)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,'D.1 Summary'!D16)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,'D.1 Summary'!D16)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,'D.1 Summary'!D16)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,'D.1 Summary'!D16)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!P:P,'D.1 Summary'!D16))","v":485627132.19999999},2464.8746171689022,710.33850638873264,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,D16)","v":64062020},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,D16)","v":43673282.340000004},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,D16)","v":5844364.8899999997},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,D16)","v":1971769.09},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,D16)","v":88743359.719999999},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,D16)","v":281332336.15999997},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B16,'B. Zip Code'!D:D,D16)","v":58880670.579999998}]
[null,2017,"Medicare and Medicaid Dual Eligibles afes 21-64",6,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,D17)","v":38641},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,D17)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,D17)),\"0\")","v":66197.757592592578},1.7131481481481479,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,'D.1 Summary'!D17)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,'D.1 Summary'!D17)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,'D.1 Summary'!D17)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,'D.1 Summary'!D17)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,'D.1 Summary'!D17)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,'D.1 Summary'!D17)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!P:P,'D.1 Summary'!D17))","v":83125760.400599986},2151.2321213374394,1255.7186742214003,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,D17)","v":19912600},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,D17)","v":13212999.8299},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,D17)","v":6425525.8632000005},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,D17)","v":3938421.2719999985},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,D17)","v":23651298.479999997},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,D17)","v":15984914.955499995},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B17,'B. Zip Code'!D:D,D17)","v":0}]
[null,2017,"Other",7,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,D18)","v":0},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,D18)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,D18)),\"0\")","v":"0"},"0",{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,'D.1 Summary'!D18)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,'D.1 Summary'!D18)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,'D.1 Summary'!D18)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,'D.1 Summary'!D18)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,'D.1 Summary'!D18)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,'D.1 Summary'!D18)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!P:P,'D.1 Summary'!D18))","v":0},"0","0",{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,D18)","v":0},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,D18)","v":0},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,D18)","v":0},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,D18)","v":0},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,D18)","v":0},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,D18)","v":0},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B18,'B. Zip Code'!D:D,D18)","v":0}]
[null,2018,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,D19)","v":21920.03},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,D19)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,D19)),\"0\")","v":10460.78631675},0.47722500000000001,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,'D.1 Summary'!D19)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,'D.1 Summary'!D19)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,'D.1 Summary'!D19)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,'D.1 Summary'!D19)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,'D.1 Summary'!D19)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,'D.1 Summary'!D19)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!P:P,'D.1 Summary'!D19))","v":24348195.815700002},1110.7738363359906,2327.5684139263253,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,D19)","v":6887739.4400000004},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,D19)","v":2842572.6436000005},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,D19)","v":4576988.3160000006},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,D19)","v":2686613.4632999999},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,D19)","v":5226541.7784000002},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,D19)","v":2127740.1743999999},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B19,'B. Zip Code'!D:D,D19)","v":29740.874100000001}]
[null,2018,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,D20)","v":4235529.9000000004},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,D20)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,D20)),\"0\")","v":9731074.0803176593},2.2974868104030284,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,'D.1 Summary'!D20)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,'D.1 Summary'!D20)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,'D.1 Summary'!D20)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,'D.1 Summary'!D20)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,'D.1 Summary'!D20)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,'D.1 Summary'!D20)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!P:P,'D.1 Summary'!D20))","v":1943072994.2190001},458.75558432936572,199.67713514267797,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,D20)","v":438186884.10000002},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,D20)","v":439942903.51200008},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,D20)","v":262643003.13300008},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,D20)","v":76988201.11500001},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,D20)","v":554885033.72399986},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,D20)","v":170426968.63500002},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B20,'B. Zip Code'!D:D,D20)","v":250053962.046}]
[null,2018,"Commercial - Full Claims",3,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,D21)","v":8483027.6999999993},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,D21)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,D21)),\"0\")","v":5166855.3279425297},0.60908151083162565,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,'D.1 Summary'!D21)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,'D.1 Summary'!D21)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,'D.1 Summary'!D21)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,'D.1 Summary'!D21)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,'D.1 Summary'!D21)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,'D.1 Summary'!D21)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!P:P,'D.1 Summary'!D21))","v":4043001499.8765001},476.59887988771987,782.48784672019178,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,D21)","v":705885560.10000002},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,D21)","v":976922600.70300007},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,D21)","v":1175960893.2539997},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,D21)","v":209862228.14550003},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,D21)","v":746474236.20000005},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,D21)","v":227895981.47400004},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B21,'B. Zip Code'!D:D,D21)","v":139848820.65630004}]
[null,2018,"Commercial - Partial Claims",4,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,D22)","v":1878193.2000000002},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,D22)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,D22)),\"0\")","v":1286478.8667466666},0.68495555555555543,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,'D.1 Summary'!D22)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,'D.1 Summary'!D22)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,'D.1 Summary'!D22)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,'D.1 Summary'!D22)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,'D.1 Summary'!D22)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,'D.1 Summary'!D22)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!P:P,'D.1 Summary'!D22))","v":703143351.70560002},374.37221671636331,546.56424592792246,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,D22)","v":132275923.52000001},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,D22)","v":154664873.3136},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,D22)","v":210327385.81919998},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,D22)","v":32234118.3112},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,D22)","v":83168281.788800001},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,D22)","v":90472768.952800006},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B22,'B. Zip Code'!D:D,D22)","v":547252.33680000005}]
[null,2018,"Medicare and Medicaid Dual Eligibles ages 65 and over",5,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,D23)","v":212295.59999999998},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,D23)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,D23)),\"0\")","v":869987.36879999982},4.0979999999999999,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,'D.1 Summary'!D23)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,'D.1 Summary'!D23)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,'D.1 Summary'!D23)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,'D.1 Summary'!D23)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,'D.1 Summary'!D23)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,'D.1 Summary'!D23)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!P:P,'D.1 Summary'!D23))","v":522694890.528},2462.108920429816,600.80744764026747,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,D23)","v":68177113.200000003},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,D23)","v":49892898.671999998},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,D23)","v":6961398.9239999996},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,D23)","v":2720311.0439999998},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,D23)","v":90788272.775999993},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,D23)","v":304154895.912},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B23,'B. Zip Code'!D:D,D23)","v":73253212.535999998}]
[null,2018,"Medicare and Medicaid Dual Eligibles afes 21-64",6,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,D24)","v":46372.2},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,D24)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,D24)),\"0\")","v":95330.938266666635},2.0557777777777773,{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,'D.1 Summary'!D24)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,'D.1 Summary'!D24)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,'D.1 Summary'!D24)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,'D.1 Summary'!D24)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,'D.1 Summary'!D24)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,'D.1 Summary'!D24)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!P:P,'D.1 Summary'!D24))","v":99750865.680719987},2151.091940445353,1046.3640397799254,{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,D24)","v":23895073.199999999},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,D24)","v":15855599.795879999},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,D24)","v":7710631.03584},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,D24)","v":4726105.526399998},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,D24)","v":28381558.175999995},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,D24)","v":19181897.946599994},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B24,'B. Zip Code'!D:D,D24)","v":0}]
[null,2018,"Other",7,{"$f":"SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,D25)","v":0},{"$f":"IFERROR((SUMIFS('B. Zip Code'!H:H,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,D25)*AVERAGEIFS('B. Zip Code'!I:I,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,D25)),\"0\")","v":"0"},"0",{"$f":"(SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,'D.1 Summary'!D25)+SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,'D.1 Summary'!D25)+SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,'D.1 Summary'!D25)+SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,'D.1 Summary'!D25)+SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,'D.1 Summary'!D25)+SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,'D.1 Summary'!D25)+SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!P:P,'D.1 Summary'!D25))","v":0},"0","0",{"$f":"SUMIFS('B. Zip Code'!J:J,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,D25)","v":0},{"$f":"SUMIFS('B. Zip Code'!K:K,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,D25)","v":0},{"$f":"SUMIFS('B. Zip Code'!L:L,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,D25)","v":0},{"$f":"SUMIFS('B. Zip Code'!M:M,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,D25)","v":0},{"$f":"SUMIFS('B. Zip Code'!N:N,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,D25)","v":0},{"$f":"SUMIFS('B. Zip Code'!O:O,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,D25)","v":0},{"$f":"SUMIFS('B. Zip Code'!P:P,'B. Zip Code'!B:B,'D.1 Summary'!B25,'B. Zip Code'!D:D,D25)","v":0}]
[]
["Table B: Physician Group TME&APM Summary  "]
[null,"TME and APM Data Summary - Physician Group"]
[null,"Year","Insurance Category ","Code","Member Months  ","Wtd Member Months "," Average HSA ","Total Expenses","TME PMPM ","HSA TME PMPM"," Inpatient","Outpatient","Prof. Physician","Prof. Other","Rx ","Other","Non-Claims "]
[null,2016,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)","v":20740},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)),\"0\")","v":10421.849999999999},{"$f":"IFERROR(F30/E30,\"0\")","v":0.50249999999999995},{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30))","v":22083293.780000001},{"$f":"IFERROR(H30/E30,\"0\")","v":1064.7682632594021},{"$f":"IFERROR(H30/F30,\"0\")","v":2118.9418174316465},{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)","v":6156550},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)","v":2826744.1199999996},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)","v":4411205.79},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)","v":2310470.37},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)","v":4370704.75},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)","v":1981888.76},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B30,'C. Physician Group'!E:E,'D.1 Summary'!D30))","v":25729.99}]
[null,2016,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)","v":4515450},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)),\"0\")","v":9535364.9687971696},{"$f":"IFERROR(F31/E31,\"0\")","v":2.1117197552397147},{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31))","v":2147099026.2400002},{"$f":"IFERROR(H31/E31,\"0\")","v":475.50056500238077},{"$f":"IFERROR(H31/F31,\"0\")","v":225.17219144374755},{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)","v":459129198},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)","v":428304598.18000001},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)","v":282237759.61999995},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)","v":75536873.020000011},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)","v":507273864.62000006},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)","v":169391362.82000005},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B31,'C. Physician Group'!E:E,'D.1 Summary'!D31))","v":225225369.97999993}]
[null,2016,"Commercial - Full Claims",3,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)","v":8574966},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)),\"0\")","v":4703673.4174797777},0.54853551809765522,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32))","v":4177884240.1237001},487.21875283513663,888.21732916189694,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)","v":716590315},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)","v":949272699.59999979},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)","v":1221871869.99},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)","v":205562152.86999997},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)","v":754651425.18000007},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)","v":237382511.23000002},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B32,'C. Physician Group'!E:E,'D.1 Summary'!D32))","v":92553266.253700003}]
[null,2016,"Commercial - Partial Claims",4,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)","v":1723758},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)),\"0\")","v":1529835.2249999996},0.88749999999999973,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33))","v":616614006.76999998},357.71494999298045,403.05909858364004,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)","v":119380734},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)","v":134471668.5},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)","v":183904156.17000002},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)","v":28387520.120000001},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)","v":71538834.319999993},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)","v":78494105.099999994},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B33,'C. Physician Group'!E:E,'D.1 Summary'!D33))","v":436988.56}]
[null,2016,"Medicare and Medicaid Dual Eligibles ages 65 and over",5,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)","v":176913},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)),\"0\")","v":604157.89500000002},3.415,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34))","v":496623419.22000003},2807.1618208950163,822.00931797804287,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)","v":56814261},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)","v":41577415.559999995},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)","v":5801165.7699999996},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)","v":2266925.87},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)","v":75656893.979999989},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)","v":253462413.25999999},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B34,'C. Physician Group'!E:E,'D.1 Summary'!D34))","v":61044343.780000001}]
[null,2016,"Medicare and Medicaid Dual Eligibles afes 21-64",6,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)","v":32422},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)),\"0\")","v":53973.623888888898},1.6647222222222224,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35))","v":72958713.059599996},2250.2841607427054,1351.7475352367326,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)","v":19504180},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)","v":12027162.459799999},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)","v":5228848.3101000004},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)","v":3118472.1498999996},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)","v":20527641.6899},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)","v":12552408.449899999},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B35,'C. Physician Group'!E:E,'D.1 Summary'!D35))","v":0}]
[null,2016,"Other",7,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)","v":0},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)),\"0\")","v":"0"},"0",{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36))","v":0},"0",{"$f":"IFERROR(H36/F36,\"0\")","v":"0"},{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)","v":0},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)","v":0},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)","v":0},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)","v":0},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)","v":0},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)","v":0},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B36,'C. Physician Group'!E:E,'D.1 Summary'!D36))","v":0}]
[null,2017,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)","v":21703},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)),\"0\")","v":10254.667500000001},0.47250000000000009,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37))","v":24136570.98},1112.1306261807124,2353.7156109644702,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)","v":6819544},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)","v":2814428.3600000003},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)","v":4531671.6000000006},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)","v":2660013.33},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)","v":5174793.84},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)","v":2106673.44},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B37,'C. Physician Group'!E:E,'D.1 Summary'!D37))","v":29446.41}]
[null,2017,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)","v":4033838},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)),\"0\")","v":8826371.0479071718},2.1880826765743127,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38))","v":2094107118.02},519.13515565573039,237.255731336667,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)","v":417320842},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)","v":418993241.44000006},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)","v":253336193.46000001},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)","v":75536875.019999996},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)","v":528461936.87999988},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)","v":162311398.70000002},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B38,'C. Physician Group'!E:E,'D.1 Summary'!D38))","v":238146630.51999998}]
[null,2017,"Commercial - Full Claims",3,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)","v":8079074},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)),\"0\")","v":4686490.0933719091},0.58007762936345297,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39))","v":3983666982.9359999},493.084601395655,850.03209300924152,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)","v":672271962},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)","v":930402476.86000001},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)","v":1119962755.4799995},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)","v":199868788.71000001},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)","v":710927844},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)","v":217043802.88},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B39,'C. Physician Group'!E:E,'D.1 Summary'!D39))","v":133189353.00600004}]
[null,2017,"Commercial - Partial Claims",4,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)","v":1805955},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)),\"0\")","v":1189422.0291666668},0.65861111111111115,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40))","v":676625580.81000006},374.66358841167141,568.86921901392532,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)","v":127188388},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)","v":148716224.34},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)","v":202237870.97999999},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)","v":30994344.530000001},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)","v":79969501.719999999},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)","v":86993047.070000008},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B40,'C. Physician Group'!E:E,'D.1 Summary'!D40))","v":526204.17000000004}]
[null,2017,"Medicare and Medicaid Dual Eligibles ages 65 and over",5,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)","v":197019},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)),\"0\")","v":683655.93},3.47,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41))","v":544507793.77999997},2763.7324003268718,796.46466868209563,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)","v":64062020},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)","v":43673282.340000004},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)","v":5844354.8899999997},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)","v":1971769.09},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)","v":88743359.719999999},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)","v":281332337.15999997},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B41,'C. Physician Group'!E:E,'D.1 Summary'!D41))","v":58880670.579999998}]
[null,2017,"Medicare and Medicaid Dual Eligibles afes 21-64",6,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)","v":38641},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)),\"0\")","v":66197.757592592578},1.7131481481481479,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42))","v":83125711.400599986},2151.2308532543152,1255.7179340150583,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)","v":19912561},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)","v":13212989.8299},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)","v":6425525.8632000005},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)","v":3938421.2719999985},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)","v":23651298.479999997},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)","v":15984914.955499995},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B42,'C. Physician Group'!E:E,'D.1 Summary'!D42))","v":0}]
[null,2017,"Other",7,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)","v":0},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)),\"0\")","v":"0"},"0",{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43))","v":0},"0","0",{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)","v":0},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)","v":0},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)","v":0},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)","v":0},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)","v":0},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)","v":0},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B43,'C. Physician Group'!E:E,'D.1 Summary'!D43))","v":0}]
[null,2018,"Medicare & Medicare Advantage ",1,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)","v":21920.03},{"$f":"(SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)*SUMIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44))","v":10460.78631675},0.47722500000000001,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44))","v":24377936.689800002},1112.1306261807124,2330.4114960044267,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)","v":6887739.4400000004},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)","v":2842572.6436000005},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)","v":4576988.3160000006},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)","v":2686613.4632999999},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)","v":5226541.7784000002},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)","v":2127740.1743999999},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B44,'C. Physician Group'!E:E,'D.1 Summary'!D44))","v":29740.874100000001}]
[null,2018,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)","v":4235529.9000000004},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)),\"0\")","v":9731074.0803176593},2.2974868104030284,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45))","v":2193126956.2650003},517.79281649387019,225.37357522546046,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)","v":438186884.10000002},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)","v":439942903.51200008},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)","v":262643003.13300008},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)","v":76988201.11500001},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)","v":554885033.72399986},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)","v":170426968.63500002},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B45,'C. Physician Group'!E:E,'D.1 Summary'!D45))","v":250053962.046}]
[null,2018,"Commercial - Full Claims",3,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)","v":8483027.6999999993},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)),\"0\")","v":5166855.3279425297},0.60908151083162565,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46))","v":4182850320.5328002},493.0846000341129,809.55437205911358,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)","v":705885560.10000002},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)","v":976922600.70300007},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)","v":1175960893.2539997},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)","v":209862228.14550003},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)","v":746474236.20000005},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)","v":227895981.47400004},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B46,'C. Physician Group'!E:E,'D.1 Summary'!D46))","v":139848820.65630004}]
[null,2018,"Commercial - Partial Claims",4,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)","v":1878193.2000000002},{"$f":"(SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)*SUMIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47))","v":3859436.6002400001},2.0548666666666664,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47))","v":703690604.0424},374.66358841167136,182.32987788907863,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)","v":132275923.52000001},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)","v":154664873.3136},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)","v":210327385.81919998},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)","v":32234118.3112},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)","v":83168281.788800001},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)","v":90472768.952800006},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B47,'C. Physician Group'!E:E,'D.1 Summary'!D47))","v":547252.33680000005}]
[null,2018,"Medicare and Medicaid Dual Eligibles ages 65 and over",5,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)","v":212295.59999999998},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)),\"0\")","v":869987.36879999982},4.0979999999999999,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48))","v":595948103.06400001},2807.1618208950167,685.00776498170251,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)","v":68177113.200000003},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)","v":49892898.671999998},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)","v":6961398.9239999996},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)","v":2720311.0439999998},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)","v":90788272.775999993},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)","v":304154895.912},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B48,'C. Physician Group'!E:E,'D.1 Summary'!D48))","v":73253212.535999998}]
[null,2018,"Medicare and Medicaid Dual Eligibles afes 21-64",6,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)","v":46369.2},{"$f":"(SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)*SUMIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49))","v":95324.770933333304},2.0557777777777773,{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49))","v":99750865.680719987},2151.2311120467893,1046.4317375646476,{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)","v":23895073.199999999},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)","v":15855599.795879999},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)","v":7710631.03584},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)","v":4726105.526399998},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)","v":28381558.175999995},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)","v":19181897.946599994},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B49,'C. Physician Group'!E:E,'D.1 Summary'!D49))","v":0}]
[null,2018,"Other",7,{"$f":"SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)","v":0},{"$f":"IFERROR((SUMIFS('C. Physician Group'!L:L,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)*AVERAGEIFS('C. Physician Group'!M:M,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)),\"0\")","v":"0"},"0",{"$f":"(SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50))","v":0},"0","0",{"$f":"SUMIFS('C. Physician Group'!N:N,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)","v":0},{"$f":"SUMIFS('C. Physician Group'!O:O,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)","v":0},{"$f":"SUMIFS('C. Physician Group'!P:P,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)","v":0},{"$f":"SUMIFS('C. Physician Group'!Q:Q,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)","v":0},{"$f":"SUMIFS('C. Physician Group'!R:R,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)","v":0},{"$f":"SUMIFS('C. Physician Group'!S:S,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)","v":0},{"$f":"(SUMIFS('C. Physician Group'!T:T,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!U:U,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!V:V,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!W:W,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50)+SUMIFS('C. Physician Group'!X:X,'C. Physician Group'!B:B,'D.1 Summary'!B50,'C. Physician Group'!E:E,'D.1 Summary'!D50))","v":0}]

{"sheet":"D.2 Summary Trends","index":5,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[[45,1,45,8],[2,1,2,16],[27,1,27,8]]}
[]
["Table C: Zip Code and Physician Group TME&APM Comparison "]
[null,"Percent Difference in Zip Code and Physician Group TME-APM"]
[null,"Year","Insurance Category ","Code","Member Months  ","Wtd Member Months "," Average HSA ","Total Expenses","TME PMPM ","HSA TME PMPM"," Inpatient","Outpatient","Prof. Physician","Prof. Other","Rx ","Other","Non-Claims "]
[null,2016,"Medicare & Medicare Advantage ",1,{"$f":"'D.1 Summary'!E30-'D.1 Summary'!E5","v":0},{"$f":"'D.1 Summary'!F30-'D.1 Summary'!F5","v":0},{"$f":"IFERROR((('D.1 Summary'!G30-'D.1 Summary'!G5)/'D.1 Summary'!G5),\"---\")","v":0},{"$f":"'D.1 Summary'!H30-'D.1 Summary'!H5","v":16},{"$f":"'D.1 Summary'!I30-'D.1 Summary'!I5","v":7.7145612340245862E-4},{"$f":"'D.1 Summary'!J30-'D.1 Summary'!J5","v":1.535236066501966E-3},{"$f":"'D.1 Summary'!K30-'D.1 Summary'!K5","v":0},{"$f":"'D.1 Summary'!L30-'D.1 Summary'!L5","v":0},{"$f":"'D.1 Summary'!M30-'D.1 Summary'!M5","v":0},{"$f":"'D.1 Summary'!N30-'D.1 Summary'!N5","v":0},{"$f":"'D.1 Summary'!O30-'D.1 Summary'!O5","v":0},{"$f":"'D.1 Summary'!P30-'D.1 Summary'!P5","v":16},{"$f":"'D.1 Summary'!Q30-'D.1 Summary'!Q5","v":0}]
[null,2016,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"'D.1 Summary'!E31-'D.1 Summary'!E6","v":110},{"$f":"'D.1 Summary'!F31-'D.1 Summary'!F6","v":232.28917307592928},{"$f":"IFERROR((('D.1 Summary'!G31-'D.1 Summary'!G6)/'D.1 Summary'!G6),\"---\")","v":0},{"$f":"'D.1 Summary'!H31-'D.1 Summary'!H6","v":225225369.98000002},{"$f":"'D.1 Summary'!I31-'D.1 Summary'!I6","v":49.868462821814035},{"$f":"'D.1 Summary'!J31-'D.1 Summary'!J6","v":23.615095089240725},{"$f":"'D.1 Summary'!K31-'D.1 Summary'!K6","v":0},{"$f":"'D.1 Summary'!L31-'D.1 Summary'!L6","v":0},{"$f":"'D.1 Summary'!M31-'D.1 Summary'!M6","v":0},{"$f":"'D.1 Summary'!N31-'D.1 Summary'!N6","v":0},{"$f":"'D.1 Summary'!O31-'D.1 Summary'!O6","v":0},{"$f":"'D.1 Summary'!P31-'D.1 Summary'!P6","v":0},{"$f":"'D.1 Summary'!Q31-'D.1 Summary'!Q6","v":0}]
[null,2016,"Commercial - Full Claims",3,{"$f":"'D.1 Summary'!E32-'D.1 Summary'!E7","v":0},{"$f":"'D.1 Summary'!F32-'D.1 Summary'!F7","v":0},{"$f":"IFERROR((('D.1 Summary'!G32-'D.1 Summary'!G7)/'D.1 Summary'!G7),\"---\")","v":0},{"$f":"'D.1 Summary'!H32-'D.1 Summary'!H7","v":92553265.25369978},{"$f":"'D.1 Summary'!I32-'D.1 Summary'!I7","v":10.793426499148779},{"$f":"'D.1 Summary'!J32-'D.1 Summary'!J7","v":19.67680513484504},{"$f":"'D.1 Summary'!K32-'D.1 Summary'!K7","v":0},{"$f":"'D.1 Summary'!L32-'D.1 Summary'!L7","v":0},{"$f":"'D.1 Summary'!M32-'D.1 Summary'!M7","v":0},{"$f":"'D.1 Summary'!N32-'D.1 Summary'!N7","v":-1},{"$f":"'D.1 Summary'!O32-'D.1 Summary'!O7","v":0},{"$f":"'D.1 Summary'!P32-'D.1 Summary'!P7","v":0},{"$f":"'D.1 Summary'!Q32-'D.1 Summary'!Q7","v":-9}]
[null,2016,"Commercial - Partial Claims",4,{"$f":"'D.1 Summary'!E33-'D.1 Summary'!E8","v":-4},{"$f":"'D.1 Summary'!F33-'D.1 Summary'!F8","v":-3.5500000000465661},{"$f":"IFERROR((('D.1 Summary'!G33-'D.1 Summary'!G8)/'D.1 Summary'!G8),\"---\")","v":-1.250955520704402E-16},{"$f":"'D.1 Summary'!H33-'D.1 Summary'!H8","v":437063.55999994278},{"$f":"'D.1 Summary'!I33-'D.1 Summary'!I8","v":0.2543822289851505},{"$f":"'D.1 Summary'!J33-'D.1 Summary'!J8","v":0.28662786364526482},{"$f":"'D.1 Summary'!K33-'D.1 Summary'!K8","v":0},{"$f":"'D.1 Summary'!L33-'D.1 Summary'!L8","v":75},{"$f":"'D.1 Summary'!M33-'D.1 Summary'!M8","v":0},{"$f":"'D.1 Summary'!N33-'D.1 Summary'!N8","v":0},{"$f":"'D.1 Summary'!O33-'D.1 Summary'!O8","v":0},{"$f":"'D.1 Summary'!P33-'D.1 Summary'!P8","v":0},{"$f":"'D.1 Summary'!Q33-'D.1 Summary'!Q8","v":0}]
[null,2016,"Medicare and Medicaid Dual Eligibles ages 65 and over",5,{"$f":"'D.1 Summary'!E34-'D.1 Summary'!E9","v":0},{"$f":"'D.1 Summary'!F34-'D.1 Summary'!F9","v":0},{"$f":"IFERROR((('D.1 Summary'!G34-'D.1 Summary'!G9)/'D.1 Summary'!G9),\"---\")","v":0},{"$f":"'D.1 Summary'!H34-'D.1 Summary'!H9","v":61044343.780000031},{"$f":"'D.1 Summary'!I34-'D.1 Summary'!I9","v":345.05290046520031},{"$f":"'D.1 Summary'!J34-'D.1 Summary'!J9","v":101.04038080972202},{"$f":"'D.1 Summary'!K34-'D.1 Summary'!K9","v":0},{"$f":"'D.1 Summary'!L34-'D.1 Summary'!L9","v":0},{"$f":"'D.1 Summary'!M34-'D.1 Summary'!M9","v":0},{"$f":"'D.1 Summary'!N34-'D.1 Summary'!N9","v":0},{"$f":"'D.1 Summary'!O34-'D.1 Summary'!O9","v":0},{"$f":"'D.1 Summary'!P34-'D.1 Summary'!P9","v":0},{"$f":"'D.1 Summary'!Q34-'D.1 Summary'!Q9","v":0}]
[null,2016,"Medicare and Medicaid Dual Eligibles afes 21-64",6,{"$f":"'D.1 Summary'!E35-'D.1 Summary'!E10","v":0},{"$f":"'D.1 Summary'!F35-'D.1 Summary'!F10","v":0},{"$f":"IFERROR((('D.1 Summary'!G35-'D.1 Summary'!G10)/'D.1 Summary'!G10),\"---\")","v":0},{"$f":"'D.1 Summary'!H35-'D.1 Summary'!H10","v":0},{"$f":"'D.1 Summary'!I35-'D.1 Summary'!I10","v":0},{"$f":"'D.1 Summary'!J35-'D.1 Summary'!J10","v":0},{"$f":"'D.1 Summary'!K35-'D.1 Summary'!K10","v":0},{"$f":"'D.1 Summary'!L35-'D.1 Summary'!L10","v":0},{"$f":"'D.1 Summary'!M35-'D.1 Summary'!M10","v":0},{"$f":"'D.1 Summary'!N35-'D.1 Summary'!N10","v":0},{"$f":"'D.1 Summary'!O35-'D.1 Summary'!O10","v":0},{"$f":"'D.1 Summary'!P35-'D.1 Summary'!P10","v":0},{"$f":"'D.1 Summary'!Q35-'D.1 Summary'!Q10","v":0}]
[null,2016,"Other",7,{"$f":"'D.1 Summary'!E36-'D.1 Summary'!E11","v":0},{"$f":"'D.1 Summary'!F36-'D.1 Summary'!F11","v":0},{"$f":"IFERROR((('D.1 Summary'!G36-'D.1 Summary'!G11)/'D.1 Summary'!G11),\"---\")","v":"---"},{"$f":"'D.1 Summary'!H36-'D.1 Summary'!H11","v":0},{"$f":"'D.1 Summary'!I36-'D.1 Summary'!I11","v":0},{"$f":"'D.1 Summary'!J36-'D.1 Summary'!J11","v":0},{"$f":"'D.1 Summary'!K36-'D.1 Summary'!K11","v":0},{"$f":"'D.1 Summary'!L36-'D.1 Summary'!L11","v":0},{"$f":"'D.1 Summary'!M36-'D.1 Summary'!M11","v":0},{"$f":"'D.1 Summary'!N36-'D.1 Summary'!N11","v":0},{"$f":"'D.1 Summary'!O36-'D.1 Summary'!O11","v":0},{"$f":"'D.1 Summary'!P36-'D.1 Summary'!P11","v":0},{"$f":"'D.1 Summary'!Q36-'D.1 Summary'!Q11","v":0}]
[null,2017,"Medicare & Medicare Advantage ",1,{"$f":"'D.1 Summary'!E37-'D.1 Summary'!E12","v":0},{"$f":"'D.1 Summary'!F37-'D.1 Summary'!F12","v":0},{"$f":"IFERROR((('D.1 Summary'!G37-'D.1 Summary'!G12)/'D.1 Summary'!G12),\"---\")","v":0},{"$f":"'D.1 Summary'!H37-'D.1 Summary'!H12","v":29446.410000000149},{"$f":"'D.1 Summary'!I37-'D.1 Summary'!I12","v":1.3567898447220159},{"$f":"'D.1 Summary'!J37-'D.1 Summary'!J12","v":2.871512898882429},{"$f":"'D.1 Summary'!K37-'D.1 Summary'!K12","v":0},{"$f":"'D.1 Summary'!L37-'D.1 Summary'!L12","v":0},{"$f":"'D.1 Summary'!M37-'D.1 Summary'!M12","v":0},{"$f":"'D.1 Summary'!N37-'D.1 Summary'!N12","v":0},{"$f":"'D.1 Summary'!O37-'D.1 Summary'!O12","v":0},{"$f":"'D.1 Summary'!P37-'D.1 Summary'!P12","v":0},{"$f":"'D.1 Summary'!Q37-'D.1 Summary'!Q12","v":0}]
[null,2017,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"'D.1 Summary'!E38-'D.1 Summary'!E13","v":0},{"$f":"'D.1 Summary'!F38-'D.1 Summary'!F13","v":0},{"$f":"IFERROR((('D.1 Summary'!G38-'D.1 Summary'!G13)/'D.1 Summary'!G13),\"---\")","v":0},{"$f":"'D.1 Summary'!H38-'D.1 Summary'!H13","v":238146630.51999998},{"$f":"'D.1 Summary'!I38-'D.1 Summary'!I13","v":59.037232164504417},{"$f":"'D.1 Summary'!J38-'D.1 Summary'!J13","v":26.981262086921561},{"$f":"'D.1 Summary'!K38-'D.1 Summary'!K13","v":0},{"$f":"'D.1 Summary'!L38-'D.1 Summary'!L13","v":0},{"$f":"'D.1 Summary'!M38-'D.1 Summary'!M13","v":0},{"$f":"'D.1 Summary'!N38-'D.1 Summary'!N13","v":0},{"$f":"'D.1 Summary'!O38-'D.1 Summary'!O13","v":0},{"$f":"'D.1 Summary'!P38-'D.1 Summary'!P13","v":0},{"$f":"'D.1 Summary'!Q38-'D.1 Summary'!Q13","v":0}]
[null,2017,"Commercial - Full Claims",3,{"$f":"'D.1 Summary'!E39-'D.1 Summary'!E14","v":0},{"$f":"'D.1 Summary'!F39-'D.1 Summary'!F14","v":0},{"$f":"IFERROR((('D.1 Summary'!G39-'D.1 Summary'!G14)/'D.1 Summary'!G14),\"---\")","v":0},{"$f":"'D.1 Summary'!H39-'D.1 Summary'!H14","v":133189354.00600004},{"$f":"'D.1 Summary'!I39-'D.1 Summary'!I14","v":16.485720270169622},{"$f":"'D.1 Summary'!J39-'D.1 Summary'!J14","v":28.419851819247242},{"$f":"'D.1 Summary'!K39-'D.1 Summary'!K14","v":0},{"$f":"'D.1 Summary'!L39-'D.1 Summary'!L14","v":0},{"$f":"'D.1 Summary'!M39-'D.1 Summary'!M14","v":0},{"$f":"'D.1 Summary'!N39-'D.1 Summary'!N14","v":0},{"$f":"'D.1 Summary'!O39-'D.1 Summary'!O14","v":-10},{"$f":"'D.1 Summary'!P39-'D.1 Summary'!P14","v":11},{"$f":"'D.1 Summary'!Q39-'D.1 Summary'!Q14","v":0}]
[null,2017,"Commercial - Partial Claims",4,{"$f":"'D.1 Summary'!E40-'D.1 Summary'!E15","v":0},{"$f":"'D.1 Summary'!F40-'D.1 Summary'!F15","v":0},{"$f":"IFERROR((('D.1 Summary'!G40-'D.1 Summary'!G15)/'D.1 Summary'!G15),\"---\")","v":0},{"$f":"'D.1 Summary'!H40-'D.1 Summary'!H15","v":525023.16999995708},{"$f":"'D.1 Summary'!I40-'D.1 Summary'!I15","v":0.29071774767362513},{"$f":"'D.1 Summary'!J40-'D.1 Summary'!J15","v":0.44141032966047078},{"$f":"'D.1 Summary'!K40-'D.1 Summary'!K15","v":-1000},{"$f":"'D.1 Summary'!L40-'D.1 Summary'!L15","v":-181},{"$f":"'D.1 Summary'!M40-'D.1 Summary'!M15","v":0},{"$f":"'D.1 Summary'!N40-'D.1 Summary'!N15","v":0},{"$f":"'D.1 Summary'!O40-'D.1 Summary'!O15","v":0},{"$f":"'D.1 Summary'!P40-'D.1 Summary'!P15","v":0},{"$f":"'D.1 Summary'!Q40-'D.1 Summary'!Q15","v":0}]
[null,2017,"Medicare and Medicaid Dual Eligibles ages 65 and over",5,{"$f":"'D.1 Summary'!E41-'D.1 Summary'!E16","v":0},{"$f":"'D.1 Summary'!F41-'D.1 Summary'!F16","v":0},{"$f":"IFERROR((('D.1 Summary'!G41-'D.1 Summary'!G16)/'D.1 Summary'!G16),\"---\")","v":0},{"$f":"'D.1 Summary'!H41-'D.1 Summary'!H16","v":58880661.579999983},{"$f":"'D.1 Summary'!I41-'D.1 Summary'!I16","v":298.85778315796961},{"$f":"'D.1 Summary'!J41-'D.1 Summary'!J16","v":86.126162293362995},{"$f":"'D.1 Summary'!K41-'D.1 Summary'!K16","v":0},{"$f":"'D.1 Summary'!L41-'D.1 Summary'!L16","v":0},{"$f":"'D.1 Summary'!M41-'D.1 Summary'!M16","v":-10},{"$f":"'D.1 Summary'!N41-'D.1 Summary'!N16","v":0},{"$f":"'D.1 Summary'!O41-'D.1 Summary'!O16","v":0},{"$f":"'D.1 Summary'!P41-'D.1 Summary'!P16","v":1},{"$f":"'D.1 Summary'!Q41-'D.1 Summary'!Q16","v":0}]
[null,2017,"Medicare and Medicaid Dual Eligibles ages 21-64",6,{"$f":"'D.1 Summary'!E42-'D.1 Summary'!E17","v":0},{"$f":"'D.1 Summary'!F42-'D.1 Summary'!F17","v":0},{"$f":"IFERROR((('D.1 Summary'!G42-'D.1 Summary'!G17)/'D.1 Summary'!G17),\"---\")","v":0},{"$f":"'D.1 Summary'!H42-'D.1 Summary'!H17","v":-49},{"$f":"'D.1 Summary'!I42-'D.1 Summary'!I17","v":-1.2680831241596024E-3},{"$f":"'D.1 Summary'!J42-'D.1 Summary'!J17","v":-7.4020634201588109E-4},{"$f":"'D.1 Summary'!K42-'D.1 Summary'!K17","v":-39},{"$f":"'D.1 Summary'!L42-'D.1 Summary'!L17","v":-10},{"$f":"'D.1 Summary'!M42-'D.1 Summary'!M17","v":0},{"$f":"'D.1 Summary'!N42-'D.1 Summary'!N17","v":0},{"$f":"'D.1 Summary'!O42-'D.1 Summary'!O17","v":0},{"$f":"'D.1 Summary'!P42-'D.1 Summary'!P17","v":0},{"$f":"'D.1 Summary'!Q42-'D.1 Summary'!Q17","v":0}]
[null,2017,"Other",7,{"$f":"'D.1 Summary'!E43-'D.1 Summary'!E18","v":0},{"$f":"'D.1 Summary'!F43-'D.1 Summary'!F18","v":0},{"$f":"IFERROR((('D.1 Summary'!G43-'D.1 Summary'!G18)/'D.1 Summary'!G18),\"---\")","v":"---"},{"$f":"'D.1 Summary'!H43-'D.1 Summary'!H18","v":0},{"$f":"'D.1 Summary'!I43-'D.1 Summary'!I18","v":0},{"$f":"'D.1 Summary'!J43-'D.1 Summary'!J18","v":0},{"$f":"'D.1 Summary'!K43-'D.1 Summary'!K18","v":0},{"$f":"'D.1 Summary'!L43-'D.1 Summary'!L18","v":0},{"$f":"'D.1 Summary'!M43-'D.1 Summary'!M18","v":0},{"$f":"'D.1 Summary'!N43-'D.1 Summary'!N18","v":0},{"$f":"'D.1 Summary'!O43-'D.1 Summary'!O18","v":0},{"$f":"'D.1 Summary'!P43-'D.1 Summary'!P18","v":0},{"$f":"'D.1 Summary'!Q43-'D.1 Summary'!Q18","v":0}]
[null,2018,"Medicare & Medicare Advantage ",1,{"$f":"'D.1 Summary'!E44-'D.1 Summary'!E19","v":0},{"$f":"'D.1 Summary'!F44-'D.1 Summary'!F19","v":0},{"$f":"IFERROR((('D.1 Summary'!G44-'D.1 Summary'!G19)/'D.1 Summary'!G19),\"---\")","v":0},{"$f":"'D.1 Summary'!H44-'D.1 Summary'!H19","v":29740.874099999666},{"$f":"'D.1 Summary'!I44-'D.1 Summary'!I19","v":1.3567898447217885},{"$f":"'D.1 Summary'!J44-'D.1 Summary'!J19","v":2.8430820781013608},{"$f":"'D.1 Summary'!K44-'D.1 Summary'!K19","v":0},{"$f":"'D.1 Summary'!L44-'D.1 Summary'!L19","v":0},{"$f":"'D.1 Summary'!M44-'D.1 Summary'!M19","v":0},{"$f":"'D.1 Summary'!N44-'D.1 Summary'!N19","v":0},{"$f":"'D.1 Summary'!O44-'D.1 Summary'!O19","v":0},{"$f":"'D.1 Summary'!P44-'D.1 Summary'!P19","v":0},{"$f":"'D.1 Summary'!Q44-'D.1 Summary'!Q19","v":0}]
[null,2018,"Medicaid & Medicaid Managed Care (MCO)",2,{"$f":"'D.1 Summary'!E45-'D.1 Summary'!E20","v":0},{"$f":"'D.1 Summary'!F45-'D.1 Summary'!F20","v":0},{"$f":"IFERROR((('D.1 Summary'!G45-'D.1 Summary'!G20)/'D.1 Summary'!G20),\"---\")","v":0},{"$f":"'D.1 Summary'!H45-'D.1 Summary'!H20","v":250053962.04600024},{"$f":"'D.1 Summary'!I45-'D.1 Summary'!I20","v":59.037232164504474},{"$f":"'D.1 Summary'!J45-'D.1 Summary'!J20","v":25.696440082782487},{"$f":"'D.1 Summary'!K45-'D.1 Summary'!K20","v":0},{"$f":"'D.1 Summary'!L45-'D.1 Summary'!L20","v":0},{"$f":"'D.1 Summary'!M45-'D.1 Summary'!M20","v":0},{"$f":"'D.1 Summary'!N45-'D.1 Summary'!N20","v":0},{"$f":"'D.1 Summary'!O45-'D.1 Summary'!O20","v":0},{"$f":"'D.1 Summary'!P45-'D.1 Summary'!P20","v":0},{"$f":"'D.1 Summary'!Q45-'D.1 Summary'!Q20","v":0}]
[null,2018,"Commercial - Full Claims",3,{"$f":"'D.1 Summary'!E46-'D.1 Summary'!E21","v":0},{"$f":"'D.1 Summary'!F46-'D.1 Summary'!F21","v":0},{"$f":"IFERROR((('D.1 Summary'!G46-'D.1 Summary'!G21)/'D.1 Summary'!G21),\"---\")","v":0},{"$f":"'D.1 Summary'!H46-'D.1 Summary'!H21","v":139848820.65630007},{"$f":"'D.1 Summary'!I46-'D.1 Summary'!I21","v":16.485720146393021},{"$f":"'D.1 Summary'!J46-'D.1 Summary'!J21","v":27.066525338921792},{"$f":"'D.1 Summary'!K46-'D.1 Summary'!K21","v":0},{"$f":"'D.1 Summary'!L46-'D.1 Summary'!L21","v":0},{"$f":"'D.1 Summary'!M46-'D.1 Summary'!M21","v":0},{"$f":"'D.1 Summary'!N46-'D.1 Summary'!N21","v":0},{"$f":"'D.1 Summary'!O46-'D.1 Summary'!O21","v":0},{"$f":"'D.1 Summary'!P46-'D.1 Summary'!P21","v":0},{"$f":"'D.1 Summary'!Q46-'D.1 Summary'!Q21","v":0}]
[null,2018,"Commercial - Partial Claims",4,{"$f":"'D.1 Summary'!E47-'D.1 Summary'!E22","v":0},{"$f":"'D.1 Summary'!F47-'D.1 Summary'!F22","v":2572957.7334933337},{"$f":"IFERROR((('D.1 Summary'!G47-'D.1 Summary'!G22)/'D.1 Summary'!G22),\"---\")","v":2.0000000000000004},{"$f":"'D.1 Summary'!H47-'D.1 Summary'!H22","v":547252.33679997921},{"$f":"'D.1 Summary'!I47-'D.1 Summary'!I22","v":0.29137169530804385},{"$f":"'D.1 Summary'!J47-'D.1 Summary'!J22","v":-364.23436803884385},{"$f":"'D.1 Summary'!K47-'D.1 Summary'!K22","v":0},{"$f":"'D.1 Summary'!L47-'D.1 Summary'!L22","v":0},{"$f":"'D.1 Summary'!M47-'D.1 Summary'!M22","v":0},{"$f":"'D.1 Summary'!N47-'D.1 Summary'!N22","v":0},{"$f":"'D.1 Summary'!O47-'D.1 Summary'!O22","v":0},{"$f":"'D.1 Summary'!P47-'D.1 Summary'!P22","v":0},{"$f":"'D.1 Summary'!Q47-'D.1 Summary'!Q22","v":0}]
[null,2018,"Medicare and Medicaid Dual Eligibles ages 65 and over",5,{"$f":"'D.1 Summary'!E48-'D.1 Summary'!E23","v":0},{"$f":"'D.1 Summary'!F48-'D.1 Summary'!F23","v":0},{"$f":"IFERROR((('D.1 Summary'!G48-'D.1 Summary'!G23)/'D.1 Summary'!G23),\"---\")","v":0},{"$f":"'D.1 Summary'!H48-'D.1 Summary'!H23","v":73253212.536000013},{"$f":"'D.1 Summary'!I48-'D.1 Summary'!I23","v":345.05290046520076},{"$f":"'D.1 Summary'!J48-'D.1 Summary'!J23","v":84.200317341435039},{"$f":"'D.1 Summary'!K48-'D.1 Summary'!K23","v":0},{"$f":"'D.1 Summary'!L48-'D.1 Summary'!L23","v":0},{"$f":"'D.1 Summary'!M48-'D.1 Summary'!M23","v":0},{"$f":"'D.1 Summary'!N48-'D.1 Summary'!N23","v":0},{"$f":"'D.1 Summary'!O48-'D.1 Summary'!O23","v":0},{"$f":"'D.1 Summary'!P48-'D.1 Summary'!P23","v":0},{"$f":"'D.1 Summary'!Q48-'D.1 Summary'!Q23","v":0}]
[null,2018,"Medicare and Medicaid Dual Eligibles afes 21-64",6,{"$f":"'D.1 Summary'!E49-'D.1 Summary'!E24","v":-3},{"$f":"'D.1 Summary'!F49-'D.1 Summary'!F24","v":-6.1673333333310438},{"$f":"IFERROR((('D.1 Summary'!G49-'D.1 Summary'!G24)/'D.1 Summary'!G24),\"---\")","v":0},{"$f":"'D.1 Summary'!H49-'D.1 Summary'!H24","v":0},{"$f":"'D.1 Summary'!I49-'D.1 Summary'!I24","v":0.13917160143637375},{"$f":"'D.1 Summary'!J49-'D.1 Summary'!J24","v":6.7697784722213328E-2},{"$f":"'D.1 Summary'!K49-'D.1 Summary'!K24","v":0},{"$f":"'D.1 Summary'!L49-'D.1 Summary'!L24","v":0},{"$f":"'D.1 Summary'!M49-'D.1 Summary'!M24","v":0},{"$f":"'D.1 Summary'!N49-'D.1 Summary'!N24","v":0},{"$f":"'D.1 Summary'!O49-'D.1 Summary'!O24","v":0},{"$f":"'D.1 Summary'!P49-'D.1 Summary'!P24","v":0},{"$f":"'D.1 Summary'!Q49-'D.1 Summary'!Q24","v":0}]
[null,2018,"Other",7,{"$f":"'D.1 Summary'!E50-'D.1 Summary'!E25","v":0},{"$f":"'D.1 Summary'!F50-'D.1 Summary'!F25","v":0},{"$f":"IFERROR((('D.1 Summary'!G50-'D.1 Summary'!G25)/'D.1 Summary'!G25),\"---\")","v":"---"},{"$f":"'D.1 Summary'!H50-'D.1 Summary'!H25","v":0},{"$f":"'D.1 Summary'!I50-'D.1 Summary'!I25","v":0},{"$f":"'D.1 Summary'!J50-'D.1 Summary'!J25","v":0},{"$f":"'D.1 Summary'!K50-'D.1 Summary'!K25","v":0},{"$f":"'D.1 Summary'!L50-'D.1 Summary'!L25","v":0},{"$f":"'D.1 Summary'!M50-'D.1 Summary'!M25","v":0},{"$f":"'D.1 Summary'!N50-'D.1 Summary'!N25","v":0},{"$f":"'D.1 Summary'!O50-'D.1 Summary'!O25","v":0},{"$f":"'D.1 Summary'!P50-'D.1 Summary'!P25","v":0},{"$f":"'D.1 Summary'!Q50-'D.1 Summary'!Q25","v":0}]
[]
["Table D: Zip Code TME&APM Year-to-Year Comparison "]
[null,"Percent Change in Zip Code TME-APM by Calendar Year"]
[null,"Year","Insurance Category ",null,"Member Months ","Wtd Member Months","Total Expenses","TME PMPM","HSA TME PMPM"]
[null,"2016-2017","Medicare & Medicare Advantage ",null,{"$f":"IFERROR((('D.1 Summary'!E12-'D.1 Summary'!E5)/'D.1 Summary'!E5),\"---\")","v":4.6432015429122467E-2},{"$f":"IFERROR((('D.1 Summary'!F12-'D.1 Summary'!F5)/'D.1 Summary'!F5),\"---\")","v":-1.6041537730824871E-2},{"$f":"IFERROR((('D.1 Summary'!G12-'D.1 Summary'!G5)/'D.1 Summary'!G5),\"---\")","v":-5.9701492537313161E-2},{"$f":"IFERROR((('D.1 Summary'!H12-'D.1 Summary'!H5)/'D.1 Summary'!H5),\"---\")","v":9.1646122924420287E-2},{"$f":"IFERROR((('D.1 Summary'!I12-'D.1 Summary'!I5)/'D.1 Summary'!I5),\"---\")","v":4.3207878609062139E-2}]
[null,"2016-2017","Medicaid & Medicaid Managed Care (MCO)",null,{"$f":"IFERROR((('D.1 Summary'!E13-'D.1 Summary'!E6)/'D.1 Summary'!E6),\"---\")","v":-0.1066369309952296},{"$f":"IFERROR((('D.1 Summary'!F13-'D.1 Summary'!F6)/'D.1 Summary'!F6),\"---\")","v":-7.4331596164518565E-2},{"$f":"IFERROR((('D.1 Summary'!G13-'D.1 Summary'!G6)/'D.1 Summary'!G6),\"---\")","v":3.6161484564948602E-2},{"$f":"IFERROR((('D.1 Summary'!H13-'D.1 Summary'!H6)/'D.1 Summary'!H6),\"---\")","v":-3.4296306911385847E-2},{"$f":"IFERROR((('D.1 Summary'!I13-'D.1 Summary'!I6)/'D.1 Summary'!I6),\"---\")","v":8.0975615171145474E-2}]
[null,"2016-2017","Commercial - Full Claims",null,{"$f":"IFERROR((('D.1 Summary'!E14-'D.1 Summary'!E7)/'D.1 Summary'!E7),\"---\")","v":-5.7830200143067625E-2},{"$f":"IFERROR((('D.1 Summary'!F14-'D.1 Summary'!F7)/'D.1 Summary'!F7),\"---\")","v":-3.6531711670312775E-3},{"$f":"IFERROR((('D.1 Summary'!G14-'D.1 Summary'!G7)/'D.1 Summary'!G7),\"---\")","v":5.7502404539248715E-2},{"$f":"IFERROR((('D.1 Summary'!H14-'D.1 Summary'!H7)/'D.1 Summary'!H7),\"---\")","v":-5.7486981442788444E-2},{"$f":"IFERROR((('D.1 Summary'!I14-'D.1 Summary'!I7)/'D.1 Summary'!I7),\"---\")","v":3.6428539773961202E-4}]
[null,"2016-2017","Commercial - Partial Claims",null,{"$f":"IFERROR((('D.1 Summary'!E15-'D.1 Summary'!E8)/'D.1 Summary'!E8),\"---\")","v":4.7682336656684622E-2},{"$f":"IFERROR((('D.1 Summary'!F15-'D.1 Summary'!F8)/'D.1 Summary'!F8),\"---\")","v":-0.22251805314147105},{"$f":"IFERROR((('D.1 Summary'!G15-'D.1 Summary'!G8)/'D.1 Summary'!G8),\"---\")","v":-0.25790297339593099},{"$f":"IFERROR((('D.1 Summary'!H15-'D.1 Summary'!H8)/'D.1 Summary'!H8),\"---\")","v":9.7250660042268774E-2},{"$f":"IFERROR((('D.1 Summary'!I15-'D.1 Summary'!I8)/'D.1 Summary'!I8),\"---\")","v":4.7312359530431974E-2}]
[null,"2016-2017","Medicare and Medicaid Dual Eligibles ages 65 and over",null,{"$f":"IFERROR((('D.1 Summary'!E16-'D.1 Summary'!E9)/'D.1 Summary'!E9),\"---\")","v":0.11364908175204762},{"$f":"IFERROR((('D.1 Summary'!F16-'D.1 Summary'!F9)/'D.1 Summary'!F9),\"---\")","v":0.13158486491350085},{"$f":"IFERROR((('D.1 Summary'!G16-'D.1 Summary'!G9)/'D.1 Summary'!G9),\"---\")","v":1.6105417276720397E-2},{"$f":"IFERROR((('D.1 Summary'!H16-'D.1 Summary'!H9)/'D.1 Summary'!H9),\"---\")","v":0.11490004819318736},{"$f":"IFERROR((('D.1 Summary'!I16-'D.1 Summary'!I9)/'D.1 Summary'!I9),\"---\")","v":1.1233039757653929E-3}]
[null,"2016-2017","Medicare and Medicaid Dual Eligibles afes 21-64",null,{"$f":"IFERROR((('D.1 Summary'!E17-'D.1 Summary'!E10)/'D.1 Summary'!E10),\"---\")","v":0.19181420023440873},{"$f":"IFERROR((('D.1 Summary'!F17-'D.1 Summary'!F10)/'D.1 Summary'!F10),\"---\")","v":0.22648347142427397},{"$f":"IFERROR((('D.1 Summary'!G17-'D.1 Summary'!G10)/'D.1 Summary'!G10),\"---\")","v":2.9089493297735945E-2},{"$f":"IFERROR((('D.1 Summary'!H17-'D.1 Summary'!H10)/'D.1 Summary'!H10),\"---\")","v":0.13935343586302745},{"$f":"IFERROR((('D.1 Summary'!I17-'D.1 Summary'!I10)/'D.1 Summary'!I10),\"---\")","v":-4.4017569484457425E-2}]
[null,"2016-2017","Other",null,{"$f":"IFERROR((('D.1 Summary'!E18-'D.1 Summary'!E11)/'D.1 Summary'!E11),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!F18-'D.1 Summary'!F11)/'D.1 Summary'!F11),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!G18-'D.1 Summary'!G11)/'D.1 Summary'!G11),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!H18-'D.1 Summary'!H11)/'D.1 Summary'!H11),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!I18-'D.1 Summary'!I11)/'D.1 Summary'!I11),\"---\")","v":"---"}]
[null,"2017-2018","Medicare & Medicare Advantage ",null,{"$f":"IFERROR((('D.1 Summary'!E19-'D.1 Summary'!E12)/'D.1 Summary'!E12),\"---\")","v":9.9999999999999464E-3},{"$f":"IFERROR((('D.1 Summary'!F19-'D.1 Summary'!F12)/'D.1 Summary'!F12),\"---\")","v":2.0099999999999861E-2},{"$f":"IFERROR((('D.1 Summary'!G19-'D.1 Summary'!G12)/'D.1 Summary'!G12),\"---\")","v":9.9999999999998371E-3},{"$f":"IFERROR((('D.1 Summary'!H19-'D.1 Summary'!H12)/'D.1 Summary'!H12),\"---\")","v":1.0000000000000071E-2},{"$f":"IFERROR((('D.1 Summary'!I19-'D.1 Summary'!I12)/'D.1 Summary'!I12),\"---\")","v":2.0469844355827568E-16}]
[null,"2017-2018","Medicaid & Medicaid Managed Care (MCO)",null,{"$f":"IFERROR((('D.1 Summary'!E20-'D.1 Summary'!E13)/'D.1 Summary'!E13),\"---\")","v":5.0000000000000093E-2},{"$f":"IFERROR((('D.1 Summary'!F20-'D.1 Summary'!F13)/'D.1 Summary'!F13),\"---\")","v":0.10250000000000027},{"$f":"IFERROR((('D.1 Summary'!G20-'D.1 Summary'!G13)/'D.1 Summary'!G13),\"---\")","v":5.0000000000000037E-2},{"$f":"IFERROR((('D.1 Summary'!H20-'D.1 Summary'!H13)/'D.1 Summary'!H13),\"---\")","v":4.693661708086342E-2},{"$f":"IFERROR((('D.1 Summary'!I20-'D.1 Summary'!I13)/'D.1 Summary'!I13),\"---\")","v":-2.9175075420349089E-3}]
[null,"2017-2018","Commercial - Full Claims",null,{"$f":"IFERROR((('D.1 Summary'!E21-'D.1 Summary'!E14)/'D.1 Summary'!E14),\"---\")","v":4.9999999999999906E-2},{"$f":"IFERROR((('D.1 Summary'!F21-'D.1 Summary'!F14)/'D.1 Summary'!F14),\"---\")","v":0.10249999999999998},{"$f":"IFERROR((('D.1 Summary'!G21-'D.1 Summary'!G14)/'D.1 Summary'!G14),\"---\")","v":5.0000000000000044E-2},{"$f":"IFERROR((('D.1 Summary'!H21-'D.1 Summary'!H14)/'D.1 Summary'!H14),\"---\")","v":4.9999997273065658E-2},{"$f":"IFERROR((('D.1 Summary'!I21-'D.1 Summary'!I14)/'D.1 Summary'!I14),\"---\")","v":-2.5970801685781084E-9}]
[null,"2017-2018","Commercial - Partial Claims",null,{"$f":"IFERROR((('D.1 Summary'!E22-'D.1 Summary'!E15)/'D.1 Summary'!E15),\"---\")","v":4.0000000000000105E-2},{"$f":"IFERROR((('D.1 Summary'!F22-'D.1 Summary'!F15)/'D.1 Summary'!F15),\"---\")","v":8.1599999999999839E-2},{"$f":"IFERROR((('D.1 Summary'!G22-'D.1 Summary'!G15)/'D.1 Summary'!G15),\"---\")","v":3.9999999999999751E-2},{"$f":"IFERROR((('D.1 Summary'!H22-'D.1 Summary'!H15)/'D.1 Summary'!H15),\"---\")","v":3.9998183347157157E-2},{"$f":"IFERROR((('D.1 Summary'!I22-'D.1 Summary'!I15)/'D.1 Summary'!I15),\"---\")","v":-1.7467815798610411E-6}]
[null,"2017-2018","Medicare and Medicaid Dual Eligibles ages 65 and over",null,{"$f":"IFERROR((('D.1 Summary'!E23-'D.1 Summary'!E16)/'D.1 Summary'!E16),\"---\")","v":7.753871454022189E-2},{"$f":"IFERROR((('D.1 Summary'!F23-'D.1 Summary'!F16)/'D.1 Summary'!F16),\"---\")","v":0.2725514847797777},{"$f":"IFERROR((('D.1 Summary'!G23-'D.1 Summary'!G16)/'D.1 Summary'!G16),\"---\")","v":0.18097982708933708},{"$f":"IFERROR((('D.1 Summary'!H23-'D.1 Summary'!H16)/'D.1 Summary'!H16),\"---\")","v":7.6329669143638534E-2},{"$f":"IFERROR((('D.1 Summary'!I23-'D.1 Summary'!I16)/'D.1 Summary'!I16),\"---\")","v":-1.1220435797512764E-3}]
[null,"2017-2018","Medicare and Medicaid Dual Eligibles afes 21-64",null,{"$f":"IFERROR((('D.1 Summary'!E24-'D.1 Summary'!E17)/'D.1 Summary'!E17),\"---\")","v":0.20007763774229437},{"$f":"IFERROR((('D.1 Summary'!F24-'D.1 Summary'!F17)/'D.1 Summary'!F17),\"---\")","v":0.44009316529075321},{"$f":"IFERROR((('D.1 Summary'!G24-'D.1 Summary'!G17)/'D.1 Summary'!G17),\"---\")","v":0.1999999999999999},{"$f":"IFERROR((('D.1 Summary'!H24-'D.1 Summary'!H17)/'D.1 Summary'!H17),\"---\")","v":0.1999994369976314},{"$f":"IFERROR((('D.1 Summary'!I24-'D.1 Summary'!I17)/'D.1 Summary'!I17),\"---\")","v":-6.5163071291088632E-5}]
[null,"2017-2018","Other",null,{"$f":"IFERROR((('D.1 Summary'!E25-'D.1 Summary'!E18)/'D.1 Summary'!E18),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!F25-'D.1 Summary'!F18)/'D.1 Summary'!F18),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!G25-'D.1 Summary'!G18)/'D.1 Summary'!G18),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!H25-'D.1 Summary'!H18)/'D.1 Summary'!H18),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!I25-'D.1 Summary'!I18)/'D.1 Summary'!I18),\"---\")","v":"---"}]
[]
["Table E: Physician Group TME&APM Year-to-Year Comparison "]
[null,"Percent Change in Physician Group TME-APM by Calendar Year"]
[null,"Year","Insurance Category ",null,"Member Months ","Wtd Member Months","Total Expenses","TME PMPM","HSA TME PMPM"]
[null,"2016-2017","Medicare & Medicare Advantage ",null,{"$f":"IFERROR((('D.1 Summary'!E37-'D.1 Summary'!E30)/'D.1 Summary'!E30),\"---\")","v":4.6432015429122467E-2},{"$f":"IFERROR((('D.1 Summary'!F37-'D.1 Summary'!F30)/'D.1 Summary'!F30),\"---\")","v":-1.6041537730824871E-2},{"$f":"IFERROR((('D.1 Summary'!G37-'D.1 Summary'!G30)/'D.1 Summary'!G30),\"---\")","v":-5.9701492537313161E-2},{"$f":"IFERROR((('D.1 Summary'!H37-'D.1 Summary'!H30)/'D.1 Summary'!H30),\"---\")","v":9.2978756722404077E-2},{"$f":"IFERROR((('D.1 Summary'!I37-'D.1 Summary'!I30)/'D.1 Summary'!I30),\"---\")","v":4.4481381118861997E-2}]
[null,"2016-2017","Medicaid & Medicaid Managed Care (MCO)",null,{"$f":"IFERROR((('D.1 Summary'!E38-'D.1 Summary'!E31)/'D.1 Summary'!E31),\"---\")","v":-0.10665869403935377},{"$f":"IFERROR((('D.1 Summary'!F38-'D.1 Summary'!F31)/'D.1 Summary'!F31),\"---\")","v":-7.4354146192626883E-2},{"$f":"IFERROR((('D.1 Summary'!G38-'D.1 Summary'!G31)/'D.1 Summary'!G31),\"---\")","v":3.6161484564948602E-2},{"$f":"IFERROR((('D.1 Summary'!H38-'D.1 Summary'!H31)/'D.1 Summary'!H31),\"---\")","v":-2.4680700597587105E-2},{"$f":"IFERROR((('D.1 Summary'!I38-'D.1 Summary'!I31)/'D.1 Summary'!I31),\"---\")","v":9.1765591599520274E-2}]
[null,"2016-2017","Commercial - Full Claims",null,{"$f":"IFERROR((('D.1 Summary'!E39-'D.1 Summary'!E32)/'D.1 Summary'!E32),\"---\")","v":-5.7830200143067625E-2},{"$f":"IFERROR((('D.1 Summary'!F39-'D.1 Summary'!F32)/'D.1 Summary'!F32),\"---\")","v":-3.6531711670312775E-3},{"$f":"IFERROR((('D.1 Summary'!G39-'D.1 Summary'!G32)/'D.1 Summary'!G32),\"---\")","v":5.7502404539248715E-2},{"$f":"IFERROR((('D.1 Summary'!H39-'D.1 Summary'!H32)/'D.1 Summary'!H32),\"---\")","v":-4.648698863469463E-2},{"$f":"IFERROR((('D.1 Summary'!I39-'D.1 Summary'!I32)/'D.1 Summary'!I32),\"---\")","v":1.2039455637503424E-2}]
[null,"2016-2017","Commercial - Partial Claims",null,{"$f":"IFERROR((('D.1 Summary'!E40-'D.1 Summary'!E33)/'D.1 Summary'!E33),\"---\")","v":4.7684767815435812E-2},{"$f":"IFERROR((('D.1 Summary'!F40-'D.1 Summary'!F33)/'D.1 Summary'!F33),\"---\")","v":-0.22251624898579056},{"$f":"IFERROR((('D.1 Summary'!G40-'D.1 Summary'!G33)/'D.1 Summary'!G33),\"---\")","v":-0.25790297339593088},{"$f":"IFERROR((('D.1 Summary'!H40-'D.1 Summary'!H33)/'D.1 Summary'!H33),\"---\")","v":9.7324376970218077E-2},{"$f":"IFERROR((('D.1 Summary'!I40-'D.1 Summary'!I33)/'D.1 Summary'!I33),\"---\")","v":4.7380290980356149E-2}]
[null,"2016-2017","Medicare and Medicaid Dual Eligibles ages 65 and over",null,{"$f":"IFERROR((('D.1 Summary'!E41-'D.1 Summary'!E34)/'D.1 Summary'!E34),\"---\")","v":0.11364908175204762},{"$f":"IFERROR((('D.1 Summary'!F41-'D.1 Summary'!F34)/'D.1 Summary'!F34),\"---\")","v":0.13158486491350085},{"$f":"IFERROR((('D.1 Summary'!G41-'D.1 Summary'!G34)/'D.1 Summary'!G34),\"---\")","v":1.6105417276720397E-2},{"$f":"IFERROR((('D.1 Summary'!H41-'D.1 Summary'!H34)/'D.1 Summary'!H34),\"---\")","v":9.6419888202629381E-2},{"$f":"IFERROR((('D.1 Summary'!I41-'D.1 Summary'!I34)/'D.1 Summary'!I34),\"---\")","v":-1.5470935891504008E-2}]
[null,"2016-2017","Medicare and Medicaid Dual Eligibles afes 21-64",null,{"$f":"IFERROR((('D.1 Summary'!E42-'D.1 Summary'!E35)/'D.1 Summary'!E35),\"---\")","v":0.19181420023440873},{"$f":"IFERROR((('D.1 Summary'!F42-'D.1 Summary'!F35)/'D.1 Summary'!F35),\"---\")","v":0.22648347142427397},{"$f":"IFERROR((('D.1 Summary'!G42-'D.1 Summary'!G35)/'D.1 Summary'!G35),\"---\")","v":2.9089493297735945E-2},{"$f":"IFERROR((('D.1 Summary'!H42-'D.1 Summary'!H35)/'D.1 Summary'!H35),\"---\")","v":0.13935276425030368},{"$f":"IFERROR((('D.1 Summary'!I42-'D.1 Summary'!I35)/'D.1 Summary'!I35),\"---\")","v":-4.4018133005787878E-2}]
[null,"2016-2017","Other",null,{"$f":"IFERROR((('D.1 Summary'!E43-'D.1 Summary'!E36)/'D.1 Summary'!E36),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!F43-'D.1 Summary'!F36)/'D.1 Summary'!F36),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!G43-'D.1 Summary'!G36)/'D.1 Summary'!G36),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!H43-'D.1 Summary'!H36)/'D.1 Summary'!H36),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!I43-'D.1 Summary'!I36)/'D.1 Summary'!I36),\"---\")","v":"---"}]
[null,"2017-2018","Medicare & Medicare Advantage ",null,{"$f":"IFERROR((('D.1 Summary'!E44-'D.1 Summary'!E37)/'D.1 Summary'!E37),\"---\")","v":9.9999999999999464E-3},{"$f":"IFERROR((('D.1 Summary'!F44-'D.1 Summary'!F37)/'D.1 Summary'!F37),\"---\")","v":2.0099999999999861E-2},{"$f":"IFERROR((('D.1 Summary'!G44-'D.1 Summary'!G37)/'D.1 Summary'!G37),\"---\")","v":9.9999999999998371E-3},{"$f":"IFERROR((('D.1 Summary'!H44-'D.1 Summary'!H37)/'D.1 Summary'!H37),\"---\")","v":1.0000000000000051E-2},{"$f":"IFERROR((('D.1 Summary'!I44-'D.1 Summary'!I37)/'D.1 Summary'!I37),\"---\")","v":0}]
[null,"2017-2018","Medicaid & Medicaid Managed Care (MCO)",null,{"$f":"IFERROR((('D.1 Summary'!E45-'D.1 Summary'!E38)/'D.1 Summary'!E38),\"---\")","v":5.0000000000000093E-2},{"$f":"IFERROR((('D.1 Summary'!F45-'D.1 Summary'!F38)/'D.1 Summary'!F38),\"---\")","v":0.10250000000000027},{"$f":"IFERROR((('D.1 Summary'!G45-'D.1 Summary'!G38)/'D.1 Summary'!G38),\"---\")","v":5.0000000000000037E-2},{"$f":"IFERROR((('D.1 Summary'!H45-'D.1 Summary'!H38)/'D.1 Summary'!H38),\"---\")","v":4.7284991962887095E-2},{"$f":"IFERROR((('D.1 Summary'!I45-'D.1 Summary'!I38)/'D.1 Summary'!I38),\"---\")","v":-2.5857219401075986E-3}]
[null,"2017-2018","Commercial - Full Claims",null,{"$f":"IFERROR((('D.1 Summary'!E46-'D.1 Summary'!E39)/'D.1 Summary'!E39),\"---\")","v":4.9999999999999906E-2},{"$f":"IFERROR((('D.1 Summary'!F46-'D.1 Summary'!F39)/'D.1 Summary'!F39),\"---\")","v":0.10249999999999998},{"$f":"IFERROR((('D.1 Summary'!G46-'D.1 Summary'!G39)/'D.1 Summary'!G39),\"---\")","v":5.0000000000000044E-2},{"$f":"IFERROR((('D.1 Summary'!H46-'D.1 Summary'!H39)/'D.1 Summary'!H39),\"---\")","v":4.9999997100661345E-2},{"$f":"IFERROR((('D.1 Summary'!I46-'D.1 Summary'!I39)/'D.1 Summary'!I39),\"---\")","v":-2.7612748402536901E-9}]
[null,"2017-2018","Commercial - Partial Claims",null,{"$f":"IFERROR((('D.1 Summary'!E47-'D.1 Summary'!E40)/'D.1 Summary'!E40),\"---\")","v":4.0000000000000105E-2},{"$f":"IFERROR((('D.1 Summary'!F47-'D.1 Summary'!F40)/'D.1 Summary'!F40),\"---\")","v":2.2447999999999997},{"$f":"IFERROR((('D.1 Summary'!G47-'D.1 Summary'!G40)/'D.1 Summary'!G40),\"---\")","v":2.1199999999999997},{"$f":"IFERROR((('D.1 Summary'!H47-'D.1 Summary'!H40)/'D.1 Summary'!H40),\"---\")","v":3.9999999999999911E-2},{"$f":"IFERROR((('D.1 Summary'!I47-'D.1 Summary'!I40)/'D.1 Summary'!I40),\"---\")","v":-1.517185566438066E-16}]
[null,"2017-2018","Medicare and Medicaid Dual Eligibles ages 65 and over",null,{"$f":"IFERROR((('D.1 Summary'!E48-'D.1 Summary'!E41)/'D.1 Summary'!E41),\"---\")","v":7.753871454022189E-2},{"$f":"IFERROR((('D.1 Summary'!F48-'D.1 Summary'!F41)/'D.1 Summary'!F41),\"---\")","v":0.2725514847797777},{"$f":"IFERROR((('D.1 Summary'!G48-'D.1 Summary'!G41)/'D.1 Summary'!G41),\"---\")","v":0.18097982708933708},{"$f":"IFERROR((('D.1 Summary'!H48-'D.1 Summary'!H41)/'D.1 Summary'!H41),\"---\")","v":9.4471208441111329E-2},{"$f":"IFERROR((('D.1 Summary'!I48-'D.1 Summary'!I41)/'D.1 Summary'!I41),\"---\")","v":1.5714046903748145E-2}]
[null,"2017-2018","Medicare and Medicaid Dual Eligibles afes 21-64",null,{"$f":"IFERROR((('D.1 Summary'!E49-'D.1 Summary'!E42)/'D.1 Summary'!E42),\"---\")","v":0.19999999999999993},{"$f":"IFERROR((('D.1 Summary'!F49-'D.1 Summary'!F42)/'D.1 Summary'!F42),\"---\")","v":0.43999999999999989},{"$f":"IFERROR((('D.1 Summary'!G49-'D.1 Summary'!G42)/'D.1 Summary'!G42),\"---\")","v":0.1999999999999999},{"$f":"IFERROR((('D.1 Summary'!H49-'D.1 Summary'!H42)/'D.1 Summary'!H42),\"---\")","v":0.20000014435966684},{"$f":"IFERROR((('D.1 Summary'!I49-'D.1 Summary'!I42)/'D.1 Summary'!I42),\"---\")","v":1.2029972224992142E-7}]
[null,"2017-2018","Other",null,{"$f":"IFERROR((('D.1 Summary'!E50-'D.1 Summary'!E43)/'D.1 Summary'!E43),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!F50-'D.1 Summary'!F43)/'D.1 Summary'!F43),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!G50-'D.1 Summary'!G43)/'D.1 Summary'!G43),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!H50-'D.1 Summary'!H43)/'D.1 Summary'!H43),\"---\")","v":"---"},{"$f":"IFERROR((('D.1 Summary'!I50-'D.1 Summary'!I43)/'D.1 Summary'!I43),\"---\")","v":"---"}]

{"sheet":"Reference Tables","index":6,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Total Medical Expenses and Alternative Payment Methods"]
["Reference Tables"]
[]
["Insurance Category Code","Definition"]
[1,"Medicare & Medicare Advantage"]
[2,"Medicaid & Medicaid Managed Care (MCO)"]
[3,"Commercial – Full Claims"]
[4,"Commercial – Partial Claims"]
[5,"Medicare and Medicaid Dual Eligibles, 65 and over (e.g., SCO)"]
[6,"Medicare and Medicaid Dual Eligibles, 21 – 64 (e.g., OneCare)"]
[7,"Other (e.g., PACE)"]
[]
[]
["Product Type Code","Definition"]
[1,"HMO"]
[2,"PPO"]
[3,"Indemnity"]
[4,"Other"]
[5,"POS"]
[]
[]
["PCP Indicator","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"]
[]
[]
["Payment Method Code","Definition"]
["1A","Global Budget/Payment (Full Benefits: budget includes comprehensive services)"]
["1B","Global Budget/Payment (Partial Benefits: certain services carved-out and not part of the budget)"]
[2,"Limited Budget"]
[3,"Bundled Payments"]
[4,"Other,  non-FFS based"]
[5,"Fee for Service"]
[]
[]
["Risk Type Code","Definition"]
[1,"No Risk"]
[2,"Shared Savings Only"]
[3,"Upside and Downside Risk"]

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

{"sheet":"System Data","index":8,"n_rows":83,"n_cols":2,"rows_kept":83,"cut":false,"hidden":true,"merged":[]}
[true,"OnSaveFlag"]
[5,"iPayer"]
[{"$f":"INDEX(PayersList,iPayer,1)","v":"00001"},"vPayerOrgID"]
[{"$f":"INDEX(PayersList,iPayer,3)","v":"CHIA"},"vPayerShortName"]
[{"$f":"'A. Front Page'!C12","v":2019},"vFiscalYear"]
[{"$f":"IF(PayerName=\"Select Payer:\", FALSE,TRUE)","v":true},"cfPayerNameSelected"]
[{"$f":"IF(ContactName=\"\", FALSE,TRUE)","v":true},"cfRequiredContactName"]
[{"$f":"IF(ContactEmail=\"\", FALSE, TRUE)","v":true},"cfRequiredContactEmail"]
[{"$f":"IF(AND(cfPayerNameSelected=TRUE,cfRequiredContactName=TRUE,cfRequiredContactEmail=TRUE), TRUE, FALSE)","v":true},"cfRequiredFieldsSelected"]
[{"$f":"INDEX(PayersList,iPayer,1)&\"_\"&INDEX(PayersList,iPayer,3)&\"_\"&FiscalYear&\".xlsm\"","v":"00001_CHIA_2019.xlsm"},"vFileName"]
[]
[]
["Tab B. ZipCode "]
[{"$f":"IF(AND(A15=TRUE,A16=TRUE,A17=TRUE,A18=TRUE,A19=TRUE,A20=TRUE,A21=TRUE,A22=TRUE,A23=TRUE,A24=TRUE,A25=TRUE,A26=TRUE,A27=TRUE,A28=TRUE), TRUE,FALSE)","v":true},"cfZipCodeTabRequiredFieldS"]
[{"$f":"IF(Submission_Type=\"\",FALSE,TRUE)","v":true},"vSubmissionType"]
[{"$f":"IF('B. Zip Code'!B5<>\"\", TRUE, FALSE)","v":true},"vReportingYear"]
[{"$f":"IF('B. Zip Code'!C5<>\"\", TRUE, FALSE)","v":true},"vZipCode"]
[{"$f":"IF('B. Zip Code'!D5<>\"\", TRUE, FALSE)","v":true},"vInsuranceCategory"]
[{"$f":"IF('B. Zip Code'!E5<>\"\", TRUE, FALSE)","v":true},"VProductTypeCode"]
[{"$f":"IF('B. Zip Code'!F5<>\"\", TRUE, FALSE)","v":true},"vPCPTypeIndicator"]
[{"$f":"IF('B. Zip Code'!G5<>\"\", TRUE, FALSE)","v":true},"vPaymentMethodCode"]
[{"$f":"IF('B. Zip Code'!H5<> \"\", TRUE, FALSE)","v":true},"vMemberMonths"]
[{"$f":"IF('B. Zip Code'!I5<>\"\", TRUE, FALSE)","v":true},"vHSAScore"]
[{"$f":"IF('B. Zip Code'!J5<>\"\", TRUE, FALSE)","v":true},"vClaimsHospitalInpatient"]
[{"$f":"IF('B. Zip Code'!K5<>\"\", TRUE, FALSE)","v":true},"vClaimsHospitalOutpatient"]
[{"$f":"IF('B. Zip Code'!L5<>\"\", TRUE, FALSE)","v":true},"vClaimsProfessional"]
[{"$f":"IF('B. Zip Code'!M5<>\"\", TRUE, FALSE)","v":true},"vClaimsProfessionalOther"]
[{"$f":"IF('B. Zip Code'!N5<>\"\", TRUE, FALSE)","v":true},"vClaimsPharmacy"]
[{"$f":"IF('B. Zip Code'!O5<>\"\", TRUE, FALSE)","v":true},"vClaimsOther"]
[{"$f":"IF('B. Zip Code'!P5<>\"\", TRUE, FALSE)","v":true},"vTotalNon-ClaimsPayment"]
[]
["Tab C. Physician Group"]
[{"$f":"IF(AND(A34=TRUE,A35=TRUE,A36=TRUE, A37=TRUE,A38=TRUE,A39=TRUE,A40=TRUE,A41=TRUE,A42=TRUE,A43=TRUE,A44=TRUE,A45=TRUE,A46=TRUE,A47=TRUE,A48=TRUE,A49=TRUE,A50=TRUE,A51=TRUE,A52=TRUE,A53=TRUE,A54=TRUE,A55=TRUE,A56=TRUE, A57=TRUE), TRUE, FALSE)","v":false},"cfPhysicianGroupRequiredFields"]
[{"$f":"IF('C. Physician Group'!A5<>\"\", TRUE, FALSE)","v":true},"vSubmissionType"]
[{"$f":"IF('C. Physician Group'!B5<>\"\", TRUE, FALSE)","v":true},"vReportingYear"]
[{"$f":"IF('C. Physician Group'!C5<> \"\", TRUE, FALSE)","v":true},"vPhysicianGroupOrgID"]
[{"$f":"IF('C. Physician Group'!D5<> \"\", TRUE, FALSE)","v":true},"vLocalPracticeGroupOrgID"]
[{"$f":"IF('C. Physician Group'!E5<> \"\", TRUE, FALSE)","v":true},"vInsuranceCategoryCode"]
[{"$f":"IF('C. Physician Group'!F5<> \"\", TRUE, FALSE)","v":true},"vProductTypeCode"]
[{"$f":"IF('C. Physician Group'!G5<>\"\", TRUE, FALSE)","v":true},"vPCPTypeIndicator"]
[{"$f":"IF('C. Physician Group'!H5<>\"\", TRUE, FALSE)","v":true},"vPaymentMethodCode"]
[{"$f":"IF('C. Physician Group'!I5<>\"\", TRUE, FALSE)","v":true},"vRiskTYpeCode"]
[{"$f":"IF('C. Physician Group'!J5<>\"\", TRUE, FALSE)","v":true},"vPediatricIndicator"]
[{"$f":"IF('C. Physician Group'!K5<>\"\", TRUE, FALSE)","v":true},"vMassHealthACOIndicator "]
[{"$f":"IF('C. Physician Group'!L5<>\"\", TRUE, FALSE)","v":true},"vMemberMonths"]
[{"$f":"IF('C. Physician Group'!M5<>\"\", TRUE, FALSE)","v":true},"vHSAScore"]
[{"$f":"IF('C. Physician Group'!N5<>\"\", TRUE, FALSE)","v":true},"vClaimsHospitalInpatient"]
[{"$f":"IF('C. Physician Group'!O5<>\"\", TRUE, FALSE)","v":true},"vClaimsHospitalOutpatient"]
[{"$f":"IF('C. Physician Group'!P5<>\"\", TRUE, FALSE)","v":true},"vClaimsProfessionalPhysician"]
[{"$f":"IF('C. Physician Group'!Q5<>\"\", TRUE, FALSE)","v":true},"vClaimsProfessionalOther"]
[{"$f":"IF('C. Physician Group'!R5<>\"\", TRUE, FALSE)","v":true},"vClaimsPharmacy"]
[{"$f":"IF('C. Physician Group'!S5<>\"\", TRUE, FALSE)","v":true},"vClaimsOther"]
[{"$f":"IF('C. Physician Group'!T5<>\"\", TRUE, FALSE)","v":true},"vNonClaimsIncentivePrograms "]
[{"$f":"IF('C. Physician Group'!U5<>\"\", TRUE, FALSE)","v":false},"vNonClaimsCapitation "]
[{"$f":"IF('C. Physician Group'!V5<>\"\", TRUE, FALSE)","v":false},"vNon-ClaimsRiskSettlements "]
[{"$f":"IF('C. Physician Group'!W5<>\"\", TRUE, FALSE)","v":false},"vNon-ClaimsCareManagement "]
[{"$f":"IF('C. Physician Group'!X5<>\"\", TRUE, FALSE)","v":false},"vNon-ClaimsOther "]
[]
["A. Front Page"]
[{"$f":"IF(AND(A61=TRUE,A62=TRUE,A63=TRUE,A64=TRUE,A65=TRUE,A66=TRUE,A67=TRUE,A68=TRUE,A69=TRUE), TRUE, FALSE)","v":true},"cfFrontPageTableARequiredFields"]
[{"$f":"IF(PayerName=\"Select Payer:\", FALSE,TRUE)","v":true},"vPayerName"]
[{"$f":"IF(FiscalYear<>\"\", TRUE, FALSE)","v":true},"vSubmissionYear"]
[{"$f":"IF('A. Front Page'!C13<>\"\", TRUE, FALSE)","v":true},"vPreliminaryData:ReportingYear"]
[{"$f":"IF('A. Front Page'!C14<>\"\", TRUE, FALSE)","v":true},"vPreliminaryData:ClaimsPaidThroughDate"]
[{"$f":"IF('A. Front Page'!C15<>\"\", TRUE, FALSE)","v":true},"vFinalData:ReportingYear"]
[{"$f":"IF('A. Front Page'!C16<>\"\", TRUE, FALSE)","v":true},"vFinalData:ClaimsPaidThroughDate "]
[{"$f":"IF('A. Front Page'!C17<>\"\", TRUE, FALSE)","v":true},"vFinalResubmissionIncluded?"]
[{"$f":"IF('A. Front Page'!C18<>\"\", TRUE, FALSE)","v":true},"vFinalResubmissionData:ReportingYear"]
[{"$f":"IF('A. Front Page'!C19<>\"\", TRUE, FALSE)","v":true},"vFinalResubmissionData:ClaimsPaidThroughDate"]
[]
[{"$f":"IF(AND(A72=TRUE,A73=TRUE,A74=TRUE,A75=TRUE,A76=TRUE,A77=TRUE,A78=TRUE,A79=TRUE,A80=TRUE,A81=TRUE,A82=TRUE,A83=TRUE), TRUE, FALSE)","v":false},"cfFrontPageTableBRequiredFields"]
[{"$f":"IF('A. Front Page'!C22<>\"\", TRUE, FALSE)","v":true},"vHealthStatus AdjustmentTool"]
[{"$f":"IF('A. Front Page'!C23<>\"\", TRUE, FALSE)","v":true},"vHealthStatusAdjustmentToolVersion"]
[{"$f":"IF('A. Front Page'!C24<>\"\", TRUE, FALSE)","v":true},"vRiskAdjustmentToolconcurrent"]
[{"$f":"IF('A. Front Page'!C25<>\"\", TRUE, FALSE)","v":true},"vRiskAdjustmentToolusetruncation"]
[{"$f":"IF('A. Front Page'!C26<>\"\", TRUE, FALSE)","v":true},"vAdjustmentToolBasedOnAll-encounterDiagnosis-basedInputs"]
[{"$f":"IF('A. Front Page'!C27<>\"\", TRUE, FALSE)","v":true},"vPharmacyDataanInputInYourRiskAdjustmentTool"]
[{"$f":"IF('A. Front Page'!C28<>\"\", TRUE, FALSE)","v":true},"vIBNRFactorsappliedtoPrelimdata"]
[{"$f":"IF('A. Front Page'!C29<>\"\", TRUE, FALSE)","v":true},"vDataIncludeMassachusettsZipCodesOnly"]
[{"$f":"IF('A. Front Page'!C30<>\"\", TRUE, FALSE)","v":true},"vDataIncludeMassachusettsResidentsOnly? "]
[{"$f":"IF('A. Front Page'!C31<>\"\", TRUE, FALSE)","v":true},"vIsthedatalimitedonlytomembersforwhomthepayeristheprimarypayer"]
[{"$f":"IF('A. Front Page'!C32<>\"\", TRUE, FALSE)","v":false},"vZipCodeFileComments"]
[{"$f":"IF('A. Front Page'!C33<>\"\", TRUE, FALSE)","v":false},"vPhysicianFileComments "]