Spreadsheet: 119448d1314392392-sum-based-on-value-in-another-column-copy-formula-in-all-cells-dummy-metrics
Sheet: Dummy Metrics

Quarter | Physician | CPT Family | CPT | VOLUME |  | Example of Results:
11Q1 | Physician A | (99201 - 99205) Office/OP Visit, New Pt | 99201 | 3 |  | For 11Q1, Physician A, CPT Family (99201-99205 …),
11Q1 | Physician A | (99201 - 99205) Office/OP Visit, New Pt | 99202 | 6 |  | sum would be 76, and each distribution % as follows:
11Q1 | Physician A | (99201 - 99205) Office/OP Visit, New Pt | 99203 | 9 |  | 99201 | 0.03947368421052631
11Q1 | Physician A | (99201 - 99205) Office/OP Visit, New Pt | 99204 | 41 |  | 99202 | 0.07894736842105263
11Q1 | Physician A | (99201 - 99205) Office/OP Visit, New Pt | 99205 | 17 |  | 99203 | 0.1184210526315789
11Q1 | Physician A | (99211 - 99215) Office/OP Visit, Est Pt | 99211 | 9 |  | 99204 | 0.5394736842105263
11Q1 | Physician A | (99211 - 99215) Office/OP Visit, Est Pt | 99212 | 15 |  | 99205 | 0.2236842105263158
11Q1 | Physician A | (99211 - 99215) Office/OP Visit, Est Pt | 99213 | 54
11Q1 | Physician A | (99211 - 99215) Office/OP Visit, Est Pt | 99214 | 54
11Q1 | Physician A | (99211 - 99215) Office/OP Visit, Est Pt | 99215 | 36
11Q1 | Physician A | (99221 - 99223) Initial Hospital Care | 99221 | 0
11Q1 | Physician A | (99221 - 99223) Initial Hospital Care | 99222 | 0
11Q1 | Physician A | (99221 - 99223) Initial Hospital Care | 99223 | 63
11Q1 | Physician B | (99201 - 99205) Office/OP Visit, New Pt | 99201 | 2
11Q1 | Physician B | (99201 - 99205) Office/OP Visit, New Pt | 99202 | 1
11Q1 | Physician B | (99201 - 99205) Office/OP Visit, New Pt | 99203 | 5
11Q1 | Physician B | (99201 - 99205) Office/OP Visit, New Pt | 99204 | 45
11Q1 | Physician B | (99201 - 99205) Office/OP Visit, New Pt | 99205 | 5
11Q1 | Physician B | (99211 - 99215) Office/OP Visit, Est Pt | 99211 | 16
11Q1 | Physician B | (99211 - 99215) Office/OP Visit, Est Pt | 99212 | 18
11Q1 | Physician B | (99211 - 99215) Office/OP Visit, Est Pt | 99213 | 35
11Q1 | Physician B | (99211 - 99215) Office/OP Visit, Est Pt | 99214 | 46
11Q1 | Physician B | (99211 - 99215) Office/OP Visit, Est Pt | 99215 | 15
11Q1 | Physician B | (99221 - 99223) Initial Hospital Care | 99221 | 1
11Q1 | Physician B | (99221 - 99223) Initial Hospital Care | 99222 | 5
11Q1 | Physician B | (99221 - 99223) Initial Hospital Care | 99223 | 67
11Q1 | Physician C | (99201 - 99205) Office/OP Visit, New Pt | 99201 | 0
11Q1 | Physician C | (99201 - 99205) Office/OP Visit, New Pt | 99202 | 2
11Q1 | Physician C | (99201 - 99205) Office/OP Visit, New Pt | 99203 | 7
11Q1 | Physician C | (99201 - 99205) Office/OP Visit, New Pt | 99204 | 17
11Q1 | Physician C | (99201 - 99205) Office/OP Visit, New Pt | 99205 | 6
11Q1 | Physician C | (99211 - 99215) Office/OP Visit, Est Pt | 99211 | 1
11Q1 | Physician C | (99211 - 99215) Office/OP Visit, Est Pt | 99212 | 45
11Q1 | Physician C | (99211 - 99215) Office/OP Visit, Est Pt | 99213 | 54
11Q1 | Physician C | (99211 - 99215) Office/OP Visit, Est Pt | 99214 | 145
11Q1 | Physician C | (99211 - 99215) Office/OP Visit, Est Pt | 99215 | 17
11Q1 | Physician C | (99221 - 99223) Initial Hospital Care | 99221 | 1
11Q1 | Physician C | (99221 - 99223) Initial Hospital Care | 99222 | 4
11Q1 | Physician C | (99221 - 99223) Initial Hospital Care | 99223 | 43
11Q1 | Physician C | (99224 - 99226) Subsequent Observation Care | 99225 | 5
11Q1 | Physician C | (99224 - 99226) Subsequent Observation Care | 99226 | 18
11Q1 | Physician C | (99231 - 99233) Subsequent Hospital Care | 99231 | 24
11Q1 | Physician C | (99231 - 99233) Subsequent Hospital Care | 99232 | 172
11Q1 | Physician C | (99231 - 99233) Subsequent Hospital Care | 99233 | 68
11Q1 | Physician C | (99238 - 99239) Hospital Discharge | 99238 | 42
11Q1 | Physician C | (99238 - 99239) Hospital Discharge | 99239 | 19
11Q1 | Physician C | (99291 - 99292) Critical Care Services | 99291 | 15
11Q1 | Physician C | (99291 - 99292) Critical Care Services | 99292 | 4
11Q2 | Physician A | (99201 - 99205) Office/OP Visit, New Pt | 99201 | 3
11Q2 | Physician A | (99201 - 99205) Office/OP Visit, New Pt | 99202 | 6
11Q2 | Physician A | (99201 - 99205) Office/OP Visit, New Pt | 99203 | 9
11Q2 | Physician A | (99201 - 99205) Office/OP Visit, New Pt | 99204 | 41
11Q2 | Physician A | (99201 - 99205) Office/OP Visit, New Pt | 99205 | 17
11Q2 | Physician A | (99211 - 99215) Office/OP Visit, Est Pt | 99211 | 9
11Q2 | Physician A | (99211 - 99215) Office/OP Visit, Est Pt | 99212 | 15
11Q2 | Physician A | (99211 - 99215) Office/OP Visit, Est Pt | 99213 | 54
11Q2 | Physician A | (99211 - 99215) Office/OP Visit, Est Pt | 99214 | 54
11Q2 | Physician A | (99211 - 99215) Office/OP Visit, Est Pt | 99215 | 36
11Q2 | Physician A | (99221 - 99223) Initial Hospital Care | 99221 | 0
11Q2 | Physician A | (99221 - 99223) Initial Hospital Care | 99222 | 0
11Q2 | Physician A | (99221 - 99223) Initial Hospital Care | 99223 | 63
11Q2 | Physician B | (99201 - 99205) Office/OP Visit, New Pt | 99201 | 2
11Q2 | Physician B | (99201 - 99205) Office/OP Visit, New Pt | 99202 | 1
11Q2 | Physician B | (99201 - 99205) Office/OP Visit, New Pt | 99203 | 5
11Q2 | Physician B | (99201 - 99205) Office/OP Visit, New Pt | 99204 | 45
11Q2 | Physician B | (99201 - 99205) Office/OP Visit, New Pt | 99205 | 5
11Q2 | Physician B | (99211 - 99215) Office/OP Visit, Est Pt | 99211 | 16
11Q2 | Physician B | (99211 - 99215) Office/OP Visit, Est Pt | 99212 | 18
11Q2 | Physician B | (99211 - 99215) Office/OP Visit, Est Pt | 99213 | 35
11Q2 | Physician B | (99211 - 99215) Office/OP Visit, Est Pt | 99214 | 46
11Q2 | Physician B | (99211 - 99215) Office/OP Visit, Est Pt | 99215 | 15
11Q2 | Physician B | (99221 - 99223) Initial Hospital Care | 99221 | 1
11Q2 | Physician B | (99221 - 99223) Initial Hospital Care | 99222 | 5
11Q2 | Physician B | (99221 - 99223) Initial Hospital Care | 99223 | 67
11Q2 | Physician C | (99201 - 99205) Office/OP Visit, New Pt | 99201 | 0
11Q2 | Physician C | (99201 - 99205) Office/OP Visit, New Pt | 99202 | 2
11Q2 | Physician C | (99201 - 99205) Office/OP Visit, New Pt | 99203 | 7
11Q2 | Physician C | (99201 - 99205) Office/OP Visit, New Pt | 99204 | 17
11Q2 | Physician C | (99201 - 99205) Office/OP Visit, New Pt | 99205 | 6
11Q2 | Physician C | (99211 - 99215) Office/OP Visit, Est Pt | 99211 | 1
11Q2 | Physician C | (99211 - 99215) Office/OP Visit, Est Pt | 99212 | 45
11Q2 | Physician C | (99211 - 99215) Office/OP Visit, Est Pt | 99213 | 54
11Q2 | Physician C | (99211 - 99215) Office/OP Visit, Est Pt | 99214 | 145
11Q2 | Physician C | (99211 - 99215) Office/OP Visit, Est Pt | 99215 | 17
11Q2 | Physician C | (99221 - 99223) Initial Hospital Care | 99221 | 1
11Q2 | Physician C | (99221 - 99223) Initial Hospital Care | 99222 | 4
11Q2 | Physician C | (99221 - 99223) Initial Hospital Care | 99223 | 43
11Q2 | Physician C | (99224 - 99226) Subsequent Observation Care | 99225 | 5
11Q2 | Physician C | (99224 - 99226) Subsequent Observation Care | 99226 | 18
11Q2 | Physician C | (99231 - 99233) Subsequent Hospital Care | 99231 | 24
11Q2 | Physician C | (99231 - 99233) Subsequent Hospital Care | 99232 | 172
11Q2 | Physician C | (99231 - 99233) Subsequent Hospital Care | 99233 | 68
11Q2 | Physician C | (99238 - 99239) Hospital Discharge | 99238 | 42
11Q2 | Physician C | (99238 - 99239) Hospital Discharge | 99239 | 19
11Q2 | Physician C | (99291 - 99292) Critical Care Services | 99291 | 15
11Q2 | Physician C | (99291 - 99292) Critical Care Services | 99292 | 4