Spreadsheet: 798267d1664388163-max-value-formula-calculating-pay-range-maxvalueformula
Sheet: Lookup Table

 | Grade Name | (YOE) | [NAME]
 | Ambulatory | 0 | 47.36
 | Ambulatory | 0.5 | 47.99
 | Ambulatory | 1 | 48.62
 | Ambulatory | 1.5 | 49.25
 | Ambulatory | 2 | 49.89
 | Ambulatory | 2.5 | 50.52
 | Ambulatory | 3 | 51.15
 | Ambulatory | 3.5 | 51.78
 | Ambulatory | 4 | 52.41
 | Ambulatory | 4.5 | 53.04
 | Ambulatory | 5 | 53.67
 | Ambulatory | 5.5 | 54.3
 | Ambulatory | 6 | 54.94
 | Ambulatory | 6.5 | 55.57
 | Ambulatory | 7 | 56.2
 | Ambulatory | 7.5 | 56.83
 | Ambulatory | 8 | 57.46
 | Ambulatory | 8.5 | 58.09
 | Ambulatory | 9 | 58.72
 | Ambulatory | 9.5 | 59.36
 | Ambulatory | 10 | 59.99
 | Ambulatory | 10.5 | 60.62
 | Ambulatory | 11 | 61.25
 | Ambulatory | 11.5 | 61.88
 | Ambulatory | 12 | 62.51
 | Ambulatory | 12.5 | 63.14
 | Ambulatory | 13 | 63.77
 | Ambulatory | 13.5 | 64.41
 | Ambulatory | 14 | 65.04
 | Ambulatory | 14.5 | 65.67
 | Ambulatory | 15 | 66.3
 | Surgical Salary Based Includes Inpatient Work | 0 | 48.87
 | Surgical Salary Based Includes Inpatient Work | 0.5 | 49.52
 | Surgical Salary Based Includes Inpatient Work | 1 | 50.17
 | Surgical Salary Based Includes Inpatient Work | 1.5 | 50.82
 | Surgical Salary Based Includes Inpatient Work | 2 | 51.48
 | Surgical Salary Based Includes Inpatient Work | 2.5 | 52.13
 | Surgical Salary Based Includes Inpatient Work | 3 | 52.78
 | Surgical Salary Based Includes Inpatient Work | 3.5 | 53.43
 | Surgical Salary Based Includes Inpatient Work | 4 | 54.08
 | Surgical Salary Based Includes Inpatient Work | 4.5 | 54.73
 | Surgical Salary Based Includes Inpatient Work | 5 | 55.38
 | Surgical Salary Based Includes Inpatient Work | 5.5 | 56.03
 | Surgical Salary Based Includes Inpatient Work | 6 | 56.69
 | Surgical Salary Based Includes Inpatient Work | 6.5 | 57.34
 | Surgical Salary Based Includes Inpatient Work | 7 | 57.99
 | Surgical Salary Based Includes Inpatient Work | 7.5 | 58.64
 | Surgical Salary Based Includes Inpatient Work | 8 | 59.29
 | Surgical Salary Based Includes Inpatient Work | 8.5 | 59.94
 | Surgical Salary Based Includes Inpatient Work | 9 | 60.59
 | Surgical Salary Based Includes Inpatient Work | 9.5 | 61.25
 | Surgical Salary Based Includes Inpatient Work | 10 | 61.9
 | Surgical Salary Based Includes Inpatient Work | 10.5 | 62.55
 | Surgical Salary Based Includes Inpatient Work | 11 | 63.2
 | Surgical Salary Based Includes Inpatient Work | 11.5 | 63.85
 | Surgical Salary Based Includes Inpatient Work | 12 | 64.5
 | Surgical Salary Based Includes Inpatient Work | 12.5 | 65.15
 | Surgical Salary Based Includes Inpatient Work | 13 | 65.8
 | Surgical Salary Based Includes Inpatient Work | 13.5 | 66.46
 | Surgical Salary Based Includes Inpatient Work | 14 | 67.11
 | Surgical Salary Based Includes Inpatient Work | 14.5 | 67.76
 | Surgical Salary Based Includes Inpatient Work | 15 | 68.41
 | Medical Based Includes Inpatient Work | 0 | 48.29
 | Medical Based Includes Inpatient Work | 0.5 | 48.93
 | Medical Based Includes Inpatient Work | 1 | 49.58
 | Medical Based Includes Inpatient Work | 1.5 | 50.22
 | Medical Based Includes Inpatient Work | 2 | 50.86
 | Medical Based Includes Inpatient Work | 2.5 | 51.51
 | Medical Based Includes Inpatient Work | 3 | 52.15
 | Medical Based Includes Inpatient Work | 3.5 | 52.79
 | Medical Based Includes Inpatient Work | 4 | 53.44
 | Medical Based Includes Inpatient Work | 4.5 | 54.08
 | Medical Based Includes Inpatient Work | 5 | 54.72
 | Medical Based Includes Inpatient Work | 5.5 | 55.37
 | Medical Based Includes Inpatient Work | 6 | 56.01
 | Medical Based Includes Inpatient Work | 6.5 | 56.65
 | Medical Based Includes Inpatient Work | 7 | 57.3
 | Medical Based Includes Inpatient Work | 7.5 | 57.94
 | Medical Based Includes Inpatient Work | 8 | 58.58
 | Medical Based Includes Inpatient Work | 8.5 | 59.23
 | Medical Based Includes Inpatient Work | 9 | 59.87
 | Medical Based Includes Inpatient Work | 9.5 | 60.52
 | Medical Based Includes Inpatient Work | 10 | 61.16
 | Medical Based Includes Inpatient Work | 10.5 | 61.8
 | Medical Based Includes Inpatient Work | 11 | 62.45
 | Medical Based Includes Inpatient Work | 11.5 | 63.09
 | Medical Based Includes Inpatient Work | 12 | 63.74
 | Medical Based Includes Inpatient Work | 12.5 | 64.38
 | Medical Based Includes Inpatient Work | 13 | 65.02
 | Medical Based Includes Inpatient Work | 13.5 | 65.67
 | Medical Based Includes Inpatient Work | 14 | 66.31
 | Medical Based Includes Inpatient Work | 14.5 | 66.96
 | Medical Based Includes Inpatient Work | 15 | 67.6
 | Trauma / Critical Care / CT Surgery | 0 | 53.08
 | Trauma / Critical Care / CT Surgery | 0.5 | 53.79
 | Trauma / Critical Care / CT Surgery | 1 | 54.49
 | Trauma / Critical Care / CT Surgery | 1.5 | 55.2
 | Trauma / Critical Care / CT Surgery | 2 | 55.91
 | Trauma / Critical Care / CT Surgery | 2.5 | 56.62
 | Trauma / Critical Care / CT Surgery | 3 | 57.32
 | Trauma / Critical Care / CT Surgery | 3.5 | 58.03
 | Trauma / Critical Care / CT Surgery | 4 | 58.74
 | Trauma / Critical Care / CT Surgery | 4.5 | 59.45
 | Trauma / Critical Care / CT Surgery | 5 | 60.15
 | Trauma / Critical Care / CT Surgery | 5.5 | 60.86
 | Trauma / Critical Care / CT Surgery | 6 | 61.57
 | Trauma / Critical Care / CT Surgery | 6.5 | 62.28
 | Trauma / Critical Care / CT Surgery | 7 | 62.98
 | Trauma / Critical Care / CT Surgery | 7.5 | 63.69
 | Trauma / Critical Care / CT Surgery | 8 | 64.4
 | Trauma / Critical Care / CT Surgery | 8.5 | 65.11
 | Trauma / Critical Care / CT Surgery | 9 | 65.81
 | Trauma / Critical Care / CT Surgery | 9.5 | 66.52
 | Trauma / Critical Care / CT Surgery | 10 | 67.23
 | Trauma / Critical Care / CT Surgery | 10.5 | 67.94
 | Trauma / Critical Care / CT Surgery | 11 | 68.65
 | Trauma / Critical Care / CT Surgery | 11.5 | 69.35
 | Trauma / Critical Care / CT Surgery | 12 | 70.06
 | Trauma / Critical Care / CT Surgery | 12.5 | 70.77
 | Trauma / Critical Care / CT Surgery | 13 | 71.48
 | Trauma / Critical Care / CT Surgery | 13.5 | 72.19
 | Trauma / Critical Care / CT Surgery | 14 | 72.89
 | Trauma / Critical Care / CT Surgery | 14.5 | 73.6
 | Trauma / Critical Care / CT Surgery | 15 | 74.31
 | Primary Care (Productivity) | 0 | 45.67
 | Primary Care (Productivity) | 0.5 | 46.13
 | Primary Care (Productivity) | 1 | 46.58
 | Primary Care (Productivity) | 1.5 | 47.04
 | Primary Care (Productivity) | 2 | 47.5
 | Primary Care (Productivity) | 2.5 | 47.96
 | Primary Care (Productivity) | 3 | 48.41
 | Primary Care (Productivity) | 3.5 | 48.87
 | Primary Care (Productivity) | 4 | 49.33
 | Primary Care (Productivity) | 4.5 | 49.79
 | Primary Care (Productivity) | 5 | 50.24
 | Primary Care (Productivity) | 5.5 | 50.7
 | Primary Care (Productivity) | 6 | 51.16
 | Primary Care (Productivity) | 6.5 | 51.62
 | Primary Care (Productivity) | 7 | 52.07
 | Primary Care (Productivity) | 7.5 | 52.53
 | Primary Care (Productivity) | 8 | 52.99
 | Primary Care (Productivity) | 8.5 | 53.44
 | Primary Care (Productivity) | 9 | 53.9
 | Primary Care (Productivity) | 9.5 | 54.36
 | Primary Care (Productivity) | 10 | 54.81
 | Primary Care (Productivity) | 10.5 | 55.27
 | Primary Care (Productivity) | 11 | 55.73
 | Primary Care (Productivity) | 11.5 | 56.18
 | Primary Care (Productivity) | 12 | 56.64
 | Primary Care (Productivity) | 12.5 | 57.1
 | Primary Care (Productivity) | 13 | 57.55
 | Primary Care (Productivity) | 13.5 | 58.01
 | Primary Care (Productivity) | 14 | 58.47
 | Primary Care (Productivity) | 14.5 | 58.92
 | Primary Care (Productivity) | 15 | 59.38