Spreadsheet: 216912d1361919168-formula-formatting-issue-gross-charges-2012-sam-smith
Sheet: GrossChgs

Physician | Revenue | Facility Name | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | Rollup
[NAME] | ADJCHG | Elm COMCARE |  |  |  |  |  |  |  | 0.04 |  |  |  |  | 0.04
[NAME] | ADJCHG | Santa Fe COMCARE | 28 |  | 32 | 28 | 28 | 32 | 28 | 28 | 28 | 30 | 26 | 43 | 331
[NAME] | ADJCHG Total |  | 28 | 0 | 32 | 28 | 28 | 32 | 28 | 28.04 | 28 | 30 | 26 | 43 | 331.04
[NAME] | COMP | Salina Regional Health Center IP |  |  |  |  | 110 |  | 266 | 156 |  |  |  |  | 532
 | COMP Total |  |  |  |  |  | 110 |  | 266 | 156 |  |  |  |  | 532
[NAME] | CONS | Elm COMCARE |  | 785 |  | 85 | 510 |  | 386 |  |  | 85 | 255 |  | 2106
[NAME] | CONS | Salina Regional Health Center OP |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
[NAME] | CONS | Santa Fe COMCARE | 16386 | 30333 | 38029 | 25462 | 8241 | 45516 | 57865 | 38570 | 28161 | 38621 | 30943 | 32171 | 390298
[NAME] | CONS Total |  | 16386 | 31118 | 38029 | 25547 | 8751 | 45516 | 58251 | 38570 | 28161 | 38706 | 31198 | 32171 | 392404
[NAME] | HOME Total | Salina Regional Health Center IP | 0 | 0 | 340 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 510
[NAME] | [NAME] | Salina Regional Health Center IP |  | 6436 | 2100 | 3898 | 6244 | 3694 | 4466 | 6169 | 3719 | 4143 | 3979 | 4958 | 49806
[NAME] | [NAME] | Salina Regional Health Center OP |  |  | 146 |  | 241 | 146 | 146 |  |  |  | 241 |  | 920
[NAME] | HOSP Total |  | 0 | 6436 | 2246 | 3898 | 6485 | 3840 | 4612 | 6169 | 3719 | 4143 | 4220 | 4958 | 50726
[NAME] | IMAG | Elm COMCARE | 482 | 607 | 232 | 955 |  | 478 | 1376.91 | 2382 | 1426 | 1426 | 359.53 | 1890 | 11614.44
[NAME] | IMAG | Imaging COMCARE | 17168.2 | 31382.8 | 38400.4 | 27696.8 | 26584 | 24283 | 29996 | 23085 | 26808 | 26816 | 14418 | 24151 | 310789.2
[NAME] | IMAG | Santa Fe COMCARE |  |  |  |  |  |  |  |  |  |  | 568.47 |  | 568.47
[NAME] | IMAG Total |  | 17650.2 | 31989.8 | 38632.4 | 28651.8 | 26584 | 24761 | 31372.91 | 25467 | 28234 | 28242 | 15346 | 26041 | 322972.11
[NAME] | INJEC | Elm COMCARE | 0 | 102 |  | 16 |  | 16 | 84 | 39 | 52 | 2649 | 185 |  | 3143
[NAME] | INJEC | Imaging COMCARE |  | 102 |  |  |  |  | 102 |  |  |  |  | 204 | 408
[NAME] | INJEC | Immunization Clinic COMCARE |  |  |  | 219 | 657 | 438 | 876 | 438 | 1095 | 454 | 227 | 227 | 4631
[NAME] | INJEC | Minneapolis COMCARE | 0 |  |  |  |  |  |  |  | 84 |  | 43 |  | 127
[NAME] | INJEC | Santa Fe COMCARE | 1974 | 2083 | 5617 | 2719 | 1466 | 3662 | 8861.02 | 5730 | 5266.01 | 7860 | 8021 | 4979 | 58238.03
[NAME] | INJEC Total |  | 1974 | 2287 | 5617 | 2954 | 2123 | 4116 | 9923.02 | 6207 | 6497.01 | 10963 | 8476 | 5410 | 66547.03
[NAME] | LAB | COMCARE PA |  | 3 |  | 71 |  |  | -71 |  |  |  |  |  | 3
[NAME] | LAB | Elm COMCARE | 3890 | 5277 | 7007 | 6282 | 1701 | 11608 | 10106 | 6502 | 7680 | 10199 | 7834 | 6961 | 85047
[NAME] | LAB | Minneapolis COMCARE | 148 |  | 39 | 3 | 3 | 3 | 9 | 99 | 15 | 6 | 99 | 3 | 427
[NAME] | LAB | Salina Regional Health Center OP |  |  |  |  |  |  | 3 |  |  |  |  |  | 3
[NAME] | LAB | Santa Fe COMCARE | 6398.5 | 10054 | 14083 | 9194 | 2001 | 16316 | 20720.48 | 11629.99 | 10292 | 13978.54 | 12049.57 | 10831.73 | 137548.81
[NAME] | LAB Total |  | 10436.5 | 15334 | 21129 | 15550 | 3705 | 27927 | 30767.48 | 18230.99 | 17987 | 24183.54 | 19982.57 | 17795.73 | 223028.81
[NAME] | MISC | Imaging COMCARE |  |  | 0 |  |  |  | 5 |  |  | 5 |  |  | 10
[NAME] | MISC | Santa Fe COMCARE | 143.56 | 204.31 | 131.39 | 326.25 | 145.73 | 72.66 | 253.76 | 74.28 | 87.2 | 22.19 | 125.45 | 216.88 | 1803.66
[NAME] | MISC Total |  | 143.56 | 204.31 | 131.39 | 326.25 | 145.73 | 72.66 | 258.76 | 74.28 | 87.2 | 27.19 | 125.45 | 216.88 | 1813.66
[NAME] | PHYSM | Elm COMCARE |  |  |  |  |  |  |  | 212 | 212 | 212 |  | 702 | 1338
[NAME] | PHYSM | Imaging COMCARE |  | 680 | 617 | 1509 | 702 |  | 212 | 487 | 699 | 1252 | 1186 | 914 | 8258
[NAME] | PHYSM | Santa Fe COMCARE |  |  |  |  |  |  |  |  |  |  | 178 |  | 178
[NAME] | PHYSM Total |  | 0 | 680 | 617 | 1509 | 702 | 0 | 212 | 699 | 911 | 1464 | 1364 | 1616 | 9774
[NAME] | PROC | Salina Regional Health Center IP |  |  |  |  |  |  | 388 | 888 |  | 388 |  |  | 1664
[NAME] | PROC | Salina Regional Health Center OP |  |  |  | 500 |  |  |  |  |  |  |  |  | 500
[NAME] | PROC | Salina Surgical Hospital |  | 475 | 500 |  |  |  | 6025 | 2812.5 |  |  |  | 2437.5 | 12250
[NAME] | PROC | Santa Fe COMCARE | 2096 | 2515 | 9604 | 5771 | 2338 | 11117 | 14400 | 11002 | 3432 | 7230 | 1325 | 8102 | 78932
[NAME] | PROC Total |  | 2096 | 2990 | 10104 | 6271 | 2338 | 11117 | 20813 | 14702.5 | 3432 | 7618 | 1325 | 10539.5 | 93346
[NAME] | RADIO | Elm COMCARE |  | 288 | 90 | 68 |  |  | 136 | 50 | 118 |  | 68 |  | 818
[NAME] | RADIO | Imaging COMCARE |  |  |  |  |  |  |  | 50 |  | 50 | 50 |  | 150
[NAME] | RADIO | Santa Fe COMCARE | 1096 | 1958 | 2107 | 1331 | 136 | 1179 | 2389 | 1942 | 1229 | 1582 | 1748 | 1441 | 18138
[NAME] | RADIO Total |  | 1096 | 2246 | 2197 | 1399 | 136 | 1179 | 2525 | 2042 | 1347 | 1632 | 1866 | 1441 | 19106
[NAME] | TEST | Santa Fe COMCARE | 42 | 42 | 117 | 224 | 64 | 224 | 96 | 266 | 109 | 170 | 181 | 96 | 1631
[NAME] | TEST Total |  | 42 | 42 | 117 | 224 | 64 | 224 | 96 | 266 | 109 | 170 | 181 | 96 | 1631
[NAME] Total |  |  | 49852.26 | 93327.11 | 119191.79 | 86358.05 | 51171.73 | 118784.66 | 159125.17 | 112611.81 | 90512.21 | 117178.73 | 84110.02 | 100498.11 | 1182721.65