Spreadsheet: 39826d1238092511-vlookup-with-s-help-please
Sheet: 09-10 Step Continuation

 |  |  | Years |  |  | 2008-10-01 00:00:00 |  | 2009-10-01 00:00:00
 | Date | Date | in Position |  |  | Base | 2008-2009 | Base | 2009-2010
Employee | of | of | at 01-01-10 | Position | Annual | Hourly | Base | Hourly | Base | % | $ | AS Degree | Engineers
Name | Hire | Service | (DOS) | Description | Hours | Rate | Salary | Rate | Salary | Increase | Increase | Incentive | Incentive
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 7 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245
 | 2004-06-07 00:00:00 | 2004-06-07 00:00:00 | 5 | Firefighter/EMT | 2912 | 14.3201741810543 | 41700.34721523011 | 15.17934120856698 | 44202.24159934706 | 0.05999696768000016 | 2501.894384116946
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 4 | Firefighter/EMT | 2912 | 13.88561012653428 | 40434.89668846782 | 14.71870462851304 | 42860.86787822997 | 0.05999696768000006 | 2425.971189762146
 | 2004-06-07 00:00:00 | 2004-06-07 00:00:00 | 5 | Firefighter/EMT | 2912 | 14.3201741810543 | 41700.34721523011 | 15.17934120856698 | 44202.24159934706 | 0.05999696768000016 | 2501.894384116946
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 7 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 4 | Firefighter/EMT | 2912 | 13.88561012653428 | 40434.89668846782 | 14.71870462851304 | 42860.86787822997 | 0.05999696768000006 | 2425.971189762146
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 7 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.76833835222457 | 43005.40128167795 | 15.6543938710303 | 45585.59495244022 | 0.05999696768000026 | 2580.193670762274
 | 2005-10-03 00:00:00 | 2005-10-03 00:00:00 | 4 | Firefighter/EMT | 2912 | 13.88561012653428 | 40434.89668846782 | 14.71870462851304 | 42860.86787822997 | 0.05999696768000006 | 2425.971189762146
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.76833835222457 | 43005.40128167795 | 15.6543938710303 | 45585.59495244022 | 0.05999696768000026 | 2580.193670762274
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 7 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.76833835222457 | 43005.40128167795 | 15.6543938710303 | 45585.59495244022 | 0.05999696768000026 | 2580.193670762274
 | 2003-03-03 00:00:00 | 2003-03-03 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.76833835222457 | 43005.40128167795 | 15.6543938710303 | 45585.59495244022 | 0.05999696768000026 | 2580.193670762274
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 7 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 7 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 4 | Firefighter/EMT | 2912 | 13.88561012653428 | 40434.89668846782 | 14.71870462851304 | 42860.86787822997 | 0.05999696768000006 | 2425.971189762146
 | 2004-11-29 00:00:00 |  | 5 | Firefighter/PM | 2912 | 16.20605210328833 | 47192.02372477562 | 17.17836608754972 | 50023.40204694479 | 0.05999696768000014 | 2831.378322169163
 | 2001-09-24 00:00:00 | 2004-11-18 00:00:00 | 8 | Firefighter/PM | 2912 | 17.77572122820498 | 51762.90021653291 | 18.84221060022229 | 54868.51726784731 | 0.05999696768000024 | 3105.617051314402
 | 2002-08-12 00:00:00 | 2003-11-17 00:00:00 | 7 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997
 | 2004-11-29 00:00:00 |  | 5 | Firefighter/PM | 2912 | 16.20605210328833 | 47192.02372477562 | 17.17836608754972 | 50023.40204694479 | 0.05999696768000014 | 2831.378322169163
 | 2002-02-04 00:00:00 | 2002-02-04 00:00:00 | 7 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997
 |  |  | 7 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997
 |  |  | 3 | Firefighter/PM | 2912 | 15.23738932773476 | 44371.27772236362 | 16.15158648275844 | 47033.41983779258 | 0.05999696768000005 | 2662.142115428956
 | 1999-12-06 00:00:00 | 2003-11-18 00:00:00 | 10 | Firefighter/PM | 2912 | 18.90574941689466 | 55053.54230199726 | 20.04003705362628 | 58356.58790015972 | 0.05999696768000035 | 3303.045598162462
 | 2002-10-01 00:00:00 |  | 7 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997
 |  |  | 3 | Firefighter/PM | 2912 | 15.23738932773476 | 44371.27772236362 | 16.15158648275844 | 47033.41983779258 | 0.05999696768000005 | 2662.142115428956
 | 2004-11-29 00:00:00 |  | 5 | Firefighter/PM | 2912 | 16.20605210328833 | 47192.02372477562 | 17.17836608754972 | 50023.40204694479 | 0.05999696768000014 | 2831.378322169163
 | 2002-05-20 00:00:00 | 2003-11-10 00:00:00 | 7 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997
 | 2003-04-28 00:00:00 | 2005-01-30 00:00:00 | 6 | Firefighter/PM | 2912 | 16.71323670991284 | 48668.9452992662 | 17.71598023262568 | 51588.93443740597 | 0.05999696768000028 | 2919.989138139776
 | 2002-08-12 00:00:00 | 2003-10-12 00:00:00 | 7 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997
 | 2000-04-17 00:00:00 | 2002-06-10 00:00:00 | 9 | Firefighter/PM | 2912 | 18.33203019976288 | 53382.87194170952 | 19.43189642316685 | 56585.68238426186 | 0.05999696768000031 | 3202.810442552342
 | 2004-11-29 00:00:00 |  | 5 | Firefighter/PM | 2912 | 16.20605210328833 | 47192.02372477562 | 17.17836608754972 | 50023.40204694479 | 0.05999696768000014 | 2831.378322169163
 | 1990-07-08 00:00:00 | 2000-04-17 00:00:00 | 9 | Lieutenant | 2912 | 22.69032111782288 | 66074.21509510021 | 24.05167158057771 | 70038.4676426423 | 0.05999696767999983 | 3964.252547542084
 | 1996-05-20 00:00:00 | 2003-03-02 00:00:00 | 6 | Lieutenant | 2912 | 20.6866726562022 | 60239.59077486081 | 21.9278102869631 | 63853.78355563655 | 0.05999696767999993 | 3614.192780775746
 | 1996-05-20 00:00:00 | 2004-02-01 00:00:00 | 5 | Lieutenant | 2912 | 20.05890903892016 | 58411.54312133549 | 21.26238275622431 | 61916.05858612518 | 0.05999696768000001 | 3504.515464789692
 | 2001-09-24 00:00:00 | 2004-02-01 00:00:00 | 5 | Lieutenant | 2912 | 20.05890903892016 | 58411.54312133549 | 21.26238275622431 | 61916.05858612518 | 0.05999696768000001 | 3504.515464789692
 | 1996-07-01 00:00:00 | 2003-03-02 00:00:00 | 6 | Lieutenant | 2912 | 20.6866726562022 | 60239.59077486081 | 21.9278102869631 | 63853.78355563655 | 0.05999696767999993 | 3614.192780775746
 | 1993-03-15 00:00:00 | 1996-11-21 00:00:00 | 13 | Lieutenant/PM | 2912 | 28.56263889326558 | 83174.40445718936 | 30.09147556200678 | 87626.37683656375 | 0.05352574999999984 | 4451.972379374391
 | 2002-10-01 00:00:00 |  | 4 | Lieutenant/PM | 2912 | 21.64454035617465 | 63028.90151718057 | 22.94314692190344 | 66810.44383658281 | 0.05999695740170015 | 3781.542319402237
 | 1991-06-10 00:00:00 | 1999-09-05 00:00:00 | 10 | Lieutenant/PM | 2912 | 26.04044143325237 | 75829.76545363091 | 27.60278868864468 | 80379.32066133332 | 0.0599969574017001 | 4549.555207702404
 | 1998-11-02 00:00:00 | 2003-03-30 00:00:00 | 6 | Lieutenant/PM | 2912 | 23.02051450000472 | 67035.73822401375 | 24.40167532782672 | 71057.67855463142 | 0.05999695740170004 | 4021.940330617668
 | 2000-12-18 00:00:00 | 2000-12-18 00:00:00 | 1 | Paramedic | 2080 | 15.72283730769231 | 32703.5016 | 16.66620754615385 | 34665.71169600001 | 0.06000000000000007 | 1962.210096000003
 | 1990-07-08 00:00:00 | 2001-05-08 00:00:00 | 8 | Battalion Chief | 2912 | 27.7636813491065 | 80847.84008859812 | 28.63257352060814 | 83378.05409201089 | 0.03129599999999999 | 2530.214003412766
 | 1999-11-08 00:00:00 | 1999-11-08 00:00:00 | 10 | Battalion Chief | 2912 | 29.52865854150908 | 85987.45367287446 | 30.45278743922415 | 88678.51702302073 | 0.03129599999999993 | 2691.063350146273
 | 1991-07-23 00:00:00 | 1999-11-08 00:00:00 | 10 | Battalion Chief | 2912 | 29.52865854150908 | 85987.45367287446 | 30.45278743922415 | 88678.51702302073 | 0.03129599999999993 | 2691.063350146273
 |  |  |  |  |  |  |  |  |  |  | 133124.8372160468
 |  |  |  |  |  |  | 2348772.659577481 |  | 2481897.496793529