Spreadsheet: 867991d1714718623-excel-formula-to-lookup-multiple-lookups-rows-and-column-value-book1-1-
Sheet: DataSh

 |  | Provider Class | VVIP | VIP | A+ | A | A3 | B | B3 | MB1 | MB2 | MB3 | MB4 | InterNational | Reimb | Referral | Grand Total
Out-Patient | CONSULTATION | Amount | 5567462.559999999 | 7726737.96 | 600 | 9244296.68000001 | 3208857.7 | 11028993.31999713 | 1186822.74 | 2345803.12 | 3032813.57 | 2777633.55 | 10689546.48 | 38.01 | 246944.76 | 12690 | 57069240.44999713 | 4076374.317856938
Out-Patient | CONSULTATION | Counts | 18451 | 37579 | 4 | 58954 | 21504 | 85570 | 15809 | 28697 | 43546 | 48450 | 252519 | 1 | 1355 | 62 | 612501 | 43750.07142857143
Out-Patient | CONSULTATION | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 131.6707142857143
Out-Patient | CONSULTATION | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93.1741180014353
Out-Patient | LABORATORY | Amount | 6401949.100000001 | 8519181.919999987 |  | 11640442.36000014 | 3906066.869999999 | 13571944.80999982 | 1344822.689999999 | 2904898.41 | 4247309.24 | 3468463.800000001 | 14879242.29999996 | 311.52 | 235960.57 | 66785 | 71187378.58999988 | 5475952.19923076
Out-Patient | LABORATORY | Counts | 6478 | 10520 |  | 16668 | 6330 | 23838 | 3711 | 7263 | 13349 | 13336 | 77182 | 1 | 525 | 43 | 179244 | 13788
Out-Patient | LABORATORY | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 579.2623076923077
Out-Patient | LABORATORY | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 397.1534812322861
Out-Patient | RADIOLOGY | Amount | 3726075.649999999 | 6480489.630000006 | 520 | 8479793.860000225 | 2512324.46 | 9940997.919999719 | 1675630.209999999 | 2419806.5 | 4217310.629999999 | 2286730.660000004 | 7052372.289999966 | 329.47 | 223128.58 | 29000 | 49044509.85999991 | 3503179.275714279
Out-Patient | RADIOLOGY | Counts | 5543 | 8529 | 2 | 13697 | 5857 | 16399 | 3470 | 6531 | 11753 | 9387 | 41449 | 1 | 452 | 17 | 123087 | 8791.92857142857
Out-Patient | RADIOLOGY | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 535.8078571428571
Out-Patient | RADIOLOGY | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 398.4540191896781
Out-Patient | MEDICATION | Amount | 7245827.709999992 | 11870815.42000015 |  | 13185154.4199995 | 3881142.43999998 | 18881044.08000027 | 1423645.41 | 2590507.459999977 | 4918480.660000029 | 4985393.169999972 | 40655404.72999857 | 1011.42 | 354111.1999999999 | 409409.6899999999 | 110401947.8099984 | 8492457.523846032
Out-Patient | MEDICATION | Counts | 14913 | 26379 |  | 44654 | 16175 | 60574 | 10450 | 19922 | 36528 | 37145 | 251990 | 9 | 1242 | 29 | 520010 | 40000.76923076923
Out-Patient | MEDICATION | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1307.262307692308
Out-Patient | MEDICATION | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 212.3073552623958
Out-Patient | DENTAL | Amount | 1083573.95 | 1550628.869999999 |  | 3452389.209999998 | 737018.2000000001 | 4409400.269999977 | 2757839.06 | 3922627.97 | 1527105.040000002 | 1349666.83 | 7018643.719999978 |  | 573673.7800000001 |  | 28382566.89999995 | 2580233.35454545
Out-Patient | DENTAL | Counts | 1256 | 1747 |  | 4556 | 1151 | 6702 | 4601 | 7116 | 3349 | 3320 | 20707 |  | 424 |  | 54929 | 4993.545454545455
Out-Patient | DENTAL | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 682.8627272727273
Out-Patient | DENTAL | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 516.7137013235259
Out-Patient | OPTICAL | Amount | 3289.61 | 4159 |  | 73782.19999999998 | 7229.85 | 1460055.08 | 1120950 | 180236.2 | 1369782.9 | 603609 | 3867420.500000001 |  | 556548.6300000002 |  | 9247062.97 | 840642.0881818183
Out-Patient | OPTICAL | Counts | 4 | 9 |  | 78 | 19 | 1663 | 1995 | 288 | 2848 | 1463 | 8885 |  | 792 |  | 18044 | 1640.363636363636
Out-Patient | OPTICAL | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 609.8381818181819
Out-Patient | OPTICAL | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 512.4730087563734
Out-Patient | ROOM AND BOARD | Amount | 27165 | 31864 |  | 40364.50999999999 | 5510 | 43787.04999999997 | 6325.699999999996 | 8038 | 4997 | 40891.5 | 5165 | 38.01 | 6909.63 |  | 221055.4 | 18421.28333333333
Out-Patient | ROOM AND BOARD | Counts | 199 | 176 |  | 204 | 54 | 173 | 46 | 37 | 66 | 441 | 35 | 1 | 13 |  | 1445 | 120.4166666666667
Out-Patient | ROOM AND BOARD | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 175.9083333333333
Out-Patient | ROOM AND BOARD | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 152.9795155709342
Out-Patient | PACKAGE DEAL | Amount |  | 37825.35 |  | 4283.48 | 3165 | 50842.33 | 68226.95 | 19162.35 | 19578 | 22675 | 48255 |  | 41973.17 |  | 315986.6299999999 | 31598.66299999999
Out-Patient | PACKAGE DEAL | Counts |  | 8 |  | 4 | 4 | 18 | 78 | 4 | 6 | 8 | 19 |  | 11 |  | 160 | 16
Out-Patient | PACKAGE DEAL | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2753.304000000001
Out-Patient | PACKAGE DEAL | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1974.9164375
Out-Patient | OTHER SERVICES | Amount | 4191210.929999981 | 6095733.429999973 |  | 6378160.689999995 | 2494165.13 | 7170124.849999936 | 1823195.980000004 | 2133696.389999998 | 3550268.740000001 | 2651768.399999999 | 9839770.119999986 | 171.14 | 2394498.34 | 335450 | 49058214.13999987 | 3773708.77999999
Out-Patient | OTHER SERVICES | Counts | 7740 | 8065 |  | 15181 | 6123 | 17475 | 4266 | 9434 | 20660 | 14275 | 84775 | 3 | 1748 | 23 | 189768 | 14597.53846153846
Out-Patient | OTHER SERVICES | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1513.392307692308
Out-Patient | OTHER SERVICES | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 258.5167896589513
In-Patient | CONSULTATION | Amount | 334618.23 | 329667.95 |  | 571506.7 | 336382.5 | 606414.2400000006 | 34796.58 | 46671.17000000001 | 188904.73 | 54921.83 | 109244.23 | 264 | 123727.54 | 1120 | 2738239.700000001 | 210633.8230769231
In-Patient | CONSULTATION | Counts | 196 | 562 |  | 951 | 310 | 1168 | 52 | 73 | 322 | 217 | 156 | 1 | 105 | 1 | 4114 | 316.4615384615385
In-Patient | CONSULTATION | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 762.3107692307693
In-Patient | CONSULTATION | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 665.590593096743
In-Patient | LABORATORY | Amount | 933531.8399999999 | 2763510.73 |  | 4267861.780000003 | 750679.77 | 4110457.980000009 | 453414.9200000004 | 641594.01 | 1620713.39 | 642886.9700000001 | 562261.85 | 6897.690000000001 | 142148.07 | 3590 | 16899549.00000001 | 1299965.307692308
In-Patient | LABORATORY | Counts | 251 | 771 |  | 1276 | 468 | 1825 | 195 | 264 | 849 | 375 | 205 | 2 | 111 | 1 | 6593 | 507.1538461538461
In-Patient | LABORATORY | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2611.207692307692
In-Patient | LABORATORY | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2563.256332473838
In-Patient | RADIOLOGY | Amount | 264504.71 | 736025.7100000001 |  | 1403010.35 | 266606.5 | 1358114.509999999 | 86987.86 | 232293.45 | 393488.25 | 191883 | 240830.06 | 642.47 | 58398.99999999999 |  | 5232785.869999997 | 436065.4891666665
In-Patient | RADIOLOGY | Counts | 149 | 437 |  | 662 | 196 | 725 | 85 | 127 | 424 | 198 | 142 | 1 | 71 |  | 3217 | 268.0833333333333
In-Patient | RADIOLOGY | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1393.58
In-Patient | RADIOLOGY | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1626.60424930059
In-Patient | MEDICATION | Amount | 1328210.94 | 2810001.060000001 |  | 3912079.310000001 | 485916.3900000003 | 3853459.569999988 | 221430.83 | 336121.22 | 836843.210000001 | 281836.7199999998 | 218401.2799999999 | 11963.27 | 186426.0499999999 | 3672.54 | 14486362.38999999 | 1114335.568461538
In-Patient | MEDICATION | Counts | 388 | 1327 |  | 2180 | 737 | 2597 | 213 | 388 | 1418 | 489 | 194 | 2 | 120 | 1 | 10054 | 773.3846153846154
In-Patient | MEDICATION | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1914.184615384616
In-Patient | MEDICATION | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1440.855618659239
In-Patient | DENTAL | Amount | 9975 | 17674 |  | 248045.07 | 21385.26 | 40970.01 |  | 80 | 18388.84 | 100 | 8894.18 |  | 6875.9 |  | 372388.2600000001 | 37238.82600000001
In-Patient | DENTAL | Counts | 2 | 11 |  | 140 | 9 | 26 |  | 1 | 19 | 1 | 4 |  | 8 |  | 221 | 22.1
In-Patient | DENTAL | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1654.878
In-Patient | DENTAL | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1685.014751131222
In-Patient | OPTICAL | Amount |  | 6988.820000000001 |  | 11042.61 | 1718.3 | 310.37 |  | 5880 | 45.59 |  |  |  | 8030.62 |  | 34016.31 | 4859.472857142857
In-Patient | OPTICAL | Counts |  | 8 |  | 8 | 1 | 2 |  | 1 | 3 |  |  |  | 8 |  | 31 | 4.428571428571429
In-Patient | OPTICAL | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1575.208571428572
In-Patient | OPTICAL | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1097.300322580645
In-Patient | ROOM AND BOARD | Amount | 2238433.120000001 | 2252784.250000001 |  | 2440369.83 | 747272.4 | 2460608.250000018 | 707418.07 | 452798.61 | 691582.73 | 635971.8 | 2001062.93 | 18004.8 | 117227.46 |  | 14763534.25000002 | 1230294.520833335
In-Patient | ROOM AND BOARD | Counts | 436 | 788 |  | 1046 | 457 | 1778 | 135 | 135 | 365 | 238 | 264 | 2 | 47 |  | 5691 | 474.25
In-Patient | ROOM AND BOARD | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3798.546666666667
In-Patient | ROOM AND BOARD | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2594.189817255319
In-Patient | PACKAGE DEAL | Amount | 720115.56 | 1223135.73 |  | 1646130.55 | 617985 | 3079149.929999999 | 830109.3 | 1173857.46 | 1419677.82 | 1259625 | 811490.6500000001 |  | 669568.29 |  | 13450845.29 | 1222804.117272727
In-Patient | PACKAGE DEAL | Counts | 40 | 93 |  | 147 | 48 | 264 | 111 | 117 | 191 | 150 | 62 |  | 62 |  | 1285 | 116.8181818181818
In-Patient | PACKAGE DEAL | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11283.73272727273
In-Patient | PACKAGE DEAL | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10467.58388326848
In-Patient | OTHER SERVICES | Amount | 6945308.150000001 | 14943472.78999999 |  | 21367307.38000004 | 7478688.499999998 | 23191932.33000002 | 2883600.17 | 8250699.939999999 | 9635839.61 | 3790821.860000001 | 5190996.060000001 | 116755.12 | 2805438.149999999 | 45250 | 106646110.0600001 | 8203546.927692313
In-Patient | OTHER SERVICES | Counts | 539 | 1353 |  | 2297 | 856 | 2996 | 424 | 948 | 1505 | 758 | 457 | 2 | 319 | 1 | 12455 | 958.0769230769231
In-Patient | OTHER SERVICES | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15415.31153846154
In-Patient | OTHER SERVICES | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8562.513854676841
TOTAL | CONSULTATION | Amount | 5902080.789999999 | 8056405.91 | 600 | 9815803.38000001 | 3545240.2 | 11635407.55999713 | 1221619.32 | 2392474.29 | 3221718.3 | 2832555.38 | 10798790.71 | 302.01 | 370672.3 | 13810 | 59807480.14999713 | 4271962.867856937
TOTAL | CONSULTATION | Counts | 18647 | 38141 | 4 | 59905 | 21814 | 86738 | 15861 | 28770 | 43868 | 48667 | 252675 | 2 | 1460 | 63 | 616615 | 44043.92857142857
TOTAL | CONSULTATION | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 149.785
TOTAL | CONSULTATION | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 96.99322940570231
TOTAL | LABORATORY | Amount | 7335480.940000001 | 11282692.64999999 |  | 15908304.14000014 | 4656746.639999999 | 17682402.78999983 | 1798237.609999999 | 3546492.42 | 5868022.630000001 | 4111350.770000001 | 15441504.14999996 | 7209.210000000001 | 378108.64 | 70375 | 88086927.58999991 | 6775917.50692307
TOTAL | LABORATORY | Counts | 6729 | 11291 |  | 17944 | 6798 | 25663 | 3906 | 7527 | 14198 | 13711 | 77387 | 3 | 636 | 44 | 185837 | 14295.15384615385
TOTAL | LABORATORY | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 830.0992307692309
TOTAL | LABORATORY | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474.0010201951168
TOTAL | RADIOLOGY | Amount | 3990580.359999998 | 7216515.340000006 | 520 | 9882804.210000224 | 2778930.96 | 11299112.42999972 | 1762618.069999999 | 2652099.95 | 4610798.879999999 | 2478613.660000004 | 7293202.349999965 | 971.94 | 281527.58 | 29000 | 54277295.72999991 | 3876949.694999993
TOTAL | RADIOLOGY | Counts | 5692 | 8966 | 2 | 14359 | 6053 | 17124 | 3555 | 6658 | 12177 | 9585 | 41591 | 2 | 523 | 17 | 126304 | 9021.714285714286
TOTAL | RADIOLOGY | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 572.1514285714286
TOTAL | RADIOLOGY | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 429.7353664967056
TOTAL | MEDICATION | Amount | 8574038.649999991 | 14680816.48000015 |  | 17097233.7299995 | 4367058.829999981 | 22734503.65000026 | 1645076.24 | 2926628.679999977 | 5755323.87000003 | 5267229.889999972 | 40873806.00999857 | 12974.69 | 540537.2499999998 | 413082.2299999999 | 124888310.1999984 | 9606793.092307571
TOTAL | MEDICATION | Counts | 15301 | 27706 |  | 46834 | 16912 | 63171 | 10663 | 20310 | 37946 | 37634 | 252184 | 11 | 1362 | 30 | 530064 | 40774.15384615384
TOTAL | MEDICATION | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1397.795384615385
TOTAL | MEDICATION | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 235.6098701288871
TOTAL | DENTAL | Amount | 1093548.95 | 1568302.869999999 |  | 3700434.279999997 | 758403.4600000001 | 4450370.279999977 | 2757839.06 | 3922707.97 | 1545493.880000002 | 1349766.83 | 7027537.899999978 |  | 580549.6800000002 |  | 28754955.15999995 | 2614086.832727268
TOTAL | DENTAL | Counts | 1258 | 1758 |  | 4696 | 1160 | 6728 | 4601 | 7117 | 3368 | 3321 | 20711 |  | 432 |  | 55150 | 5013.636363636364
TOTAL | DENTAL | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 687.6136363636364
TOTAL | DENTAL | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 521.3953791477779
TOTAL | OPTICAL | Amount | 3289.61 | 11147.82 |  | 84824.80999999998 | 8948.15 | 1460365.45 | 1120950 | 186116.2 | 1369828.49 | 603609 | 3867420.500000001 |  | 564579.2500000002 |  | 9281079.280000001 | 843734.4800000001
TOTAL | OPTICAL | Counts | 4 | 17 |  | 86 | 20 | 1665 | 1995 | 289 | 2851 | 1463 | 8885 |  | 800 |  | 18075 | 1643.181818181818
TOTAL | OPTICAL | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 638.9990909090909
TOTAL | OPTICAL | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 513.4760320885201
TOTAL | ROOM AND BOARD | Amount | 2265598.120000001 | 2284648.250000001 |  | 2480734.339999999 | 752782.4 | 2504395.300000018 | 713743.7699999999 | 460836.61 | 696579.73 | 676863.3 | 2006227.93 | 18042.81 | 124137.09 |  | 14984589.65000002 | 1248715.804166668
TOTAL | ROOM AND BOARD | Counts | 635 | 964 |  | 1250 | 511 | 1951 | 181 | 172 | 431 | 679 | 299 | 3 | 60 |  | 7136 | 594.6666666666666
TOTAL | ROOM AND BOARD | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2892.330833333333
TOTAL | ROOM AND BOARD | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2099.858415078478
TOTAL | PACKAGE DEAL | Amount | 720115.56 | 1260961.08 |  | 1650414.03 | 621150 | 3129992.259999999 | 898336.25 | 1193019.81 | 1439255.82 | 1282300 | 859745.6500000001 |  | 711541.4600000001 |  | 13766831.92 | 1251530.174545455
TOTAL | PACKAGE DEAL | Counts | 40 | 101 |  | 151 | 52 | 282 | 189 | 121 | 197 | 158 | 81 |  | 73 |  | 1445 | 131.3636363636364
TOTAL | PACKAGE DEAL | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10441.61909090909
TOTAL | PACKAGE DEAL | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9527.219321799308
TOTAL | OTHER SERVICES | Amount | 11136519.07999998 | 21039206.21999997 |  | 27745468.07000004 | 9972853.629999999 | 30362057.17999995 | 4706796.150000004 | 10384396.33 | 13186108.35 | 6442590.26 | 15030766.17999999 | 116926.26 | 5199936.489999999 | 380700 | 155704324.1999999 | 11977255.7076923
TOTAL | OTHER SERVICES | Counts | 8279 | 9418 |  | 17478 | 6979 | 20471 | 4690 | 10382 | 22165 | 15033 | 85232 | 5 | 2067 | 24 | 202223 | 15555.61538461538
TOTAL | OTHER SERVICES | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4080.450769230769
TOTAL | OTHER SERVICES | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 769.9634769536597