Spreadsheet: 39826d1238092511-vlookup-with-s-help-please
Sheet: 10-11 Step Proposal

 |  |  | Years |  |  | 2009-10-01 00:00:00 | 2009-2010 | 2010-10-01 00:00:00 |  |  |  | 2010-04-01 00:00:00 |  |  |  | 2010-10-01 00:00:00
 | Date | Date | in Position |  |  | Base | Proposed | Proposed | 2010-2011 |  |  | Proposed | 2010-2011 |  |  | Base | 2010-2011
Employee | of | of | at 01-01-11 | Position | Annual | Hourly | Base | Hourly | Proposed | % | $ | Hourly | Proposed | % | $ | Hourly | Base | % | $ | AS Degree | Engineers
Name | Hire | Service | (DOS) | Description | Hours | Rate | Salary | Rate | Salary | Increase | Increase | Rate | Salary | Increase | Increase | Rate | Salary | Increase | Increase | Incentive | Incentive
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245 | 15.70718288201167 | 45739.31655241799 | -0.02707646206084681 | -1272.925179653801 | 16.64956622572758 | 48483.53684931871 | 0.09317063278051355 | 4132.238529129369
 | 2004-06-07 00:00:00 | 2004-06-07 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.3201741810543 | 41700.34721523011 | 15.17934120856698 | 44202.24159934706 | 0.05999696768000016 | 2501.894384116946 | 14.76833835222457 | 43005.40128167795 | -0.02707646206084683 | -1196.840317669106 | 15.6543938710303 | 45585.59495244022 | 0.09317063278051349 | 3885.247737210113
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 5 | Firefighter/EMT | 2912 | 13.88561012653428 | 40434.89668846782 | 14.71870462851304 | 42860.86787822997 | 0.05999696768000006 | 2425.971189762146 | 14.3201741810543 | 41700.34721523011 | -0.02707646206084672 | -1160.520662999857 | 15.17934120856698 | 44202.24159934706 | 0.09317063278051342 | 3767.344910879234
 | 2004-06-07 00:00:00 | 2004-06-07 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.3201741810543 | 41700.34721523011 | 15.17934120856698 | 44202.24159934706 | 0.05999696768000016 | 2501.894384116946 | 14.76833835222457 | 43005.40128167795 | -0.02707646206084683 | -1196.840317669106 | 15.6543938710303 | 45585.59495244022 | 0.09317063278051349 | 3885.247737210113
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245 | 15.70718288201167 | 45739.31655241799 | -0.02707646206084681 | -1272.925179653801 | 16.64956622572758 | 48483.53684931871 | 0.09317063278051355 | 4132.238529129369
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 5 | Firefighter/EMT | 2912 | 13.88561012653428 | 40434.89668846782 | 14.71870462851304 | 42860.86787822997 | 0.05999696768000006 | 2425.971189762146 | 14.3201741810543 | 41700.34721523011 | -0.02707646206084672 | -1160.520662999857 | 15.17934120856698 | 44202.24159934706 | 0.09317063278051342 | 3767.344910879234
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245 | 15.70718288201167 | 45739.31655241799 | -0.02707646206084681 | -1272.925179653801 | 16.64956622572758 | 48483.53684931871 | 0.09317063278051355 | 4132.238529129369
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 7 | Firefighter/EMT | 2912 | 14.76833835222457 | 43005.40128167795 | 15.6543938710303 | 45585.59495244022 | 0.05999696768000026 | 2580.193670762274 | 15.23052826929579 | 44351.29832018934 | -0.02707646206084686 | -1234.29663225088 | 16.14431378161806 | 47012.24173207179 | 0.09317063278051356 | 4006.840450393844
 | 2005-10-03 00:00:00 | 2005-10-03 00:00:00 | 5 | Firefighter/EMT | 2912 | 13.88561012653428 | 40434.89668846782 | 14.71870462851304 | 42860.86787822997 | 0.05999696768000006 | 2425.971189762146 | 14.3201741810543 | 41700.34721523011 | -0.02707646206084672 | -1160.520662999857 | 15.17934120856698 | 44202.24159934706 | 0.09317063278051342 | 3767.344910879234
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 7 | Firefighter/EMT | 2912 | 14.76833835222457 | 43005.40128167795 | 15.6543938710303 | 45585.59495244022 | 0.05999696768000026 | 2580.193670762274 | 15.23052826929579 | 44351.29832018934 | -0.02707646206084686 | -1234.29663225088 | 16.14431378161806 | 47012.24173207179 | 0.09317063278051356 | 4006.840450393844
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245 | 15.70718288201167 | 45739.31655241799 | -0.02707646206084681 | -1272.925179653801 | 16.64956622572758 | 48483.53684931871 | 0.09317063278051355 | 4132.238529129369
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 7 | Firefighter/EMT | 2912 | 14.76833835222457 | 43005.40128167795 | 15.6543938710303 | 45585.59495244022 | 0.05999696768000026 | 2580.193670762274 | 15.23052826929579 | 44351.29832018934 | -0.02707646206084686 | -1234.29663225088 | 16.14431378161806 | 47012.24173207179 | 0.09317063278051356 | 4006.840450393844
 | 2003-03-03 00:00:00 | 2003-03-03 00:00:00 | 7 | Firefighter/EMT | 2912 | 14.76833835222457 | 43005.40128167795 | 15.6543938710303 | 45585.59495244022 | 0.05999696768000026 | 2580.193670762274 | 15.23052826929579 | 44351.29832018934 | -0.02707646206084686 | -1234.29663225088 | 16.14431378161806 | 47012.24173207179 | 0.09317063278051356 | 4006.840450393844
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245 | 15.70718288201167 | 45739.31655241799 | -0.02707646206084681 | -1272.925179653801 | 16.64956622572758 | 48483.53684931871 | 0.09317063278051355 | 4132.238529129369
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 15.23052826929579 | 44351.29832018934 | 16.14431378161806 | 47012.24173207179 | 0.05999696768000026 | 2660.94341188245 | 15.70718288201167 | 45739.31655241799 | -0.02707646206084681 | -1272.925179653801 | 16.64956622572758 | 48483.53684931871 | 0.09317063278051355 | 4132.238529129369
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 5 | Firefighter/EMT | 2912 | 13.88561012653428 | 40434.89668846782 | 14.71870462851304 | 42860.86787822997 | 0.05999696768000006 | 2425.971189762146 | 14.3201741810543 | 41700.34721523011 | -0.02707646206084672 | -1160.520662999857 | 15.17934120856698 | 44202.24159934706 | 0.09317063278051342 | 3767.344910879234
 | 2004-11-29 00:00:00 |  | 6 | Firefighter/PM | 2912 | 16.20605210328833 | 47192.02372477562 | 17.17836608754972 | 50023.40204694479 | 0.05999696768000014 | 2831.378322169163 | 16.71323670991284 | 48668.9452992662 | -0.02707646206084684 | -1354.456747678589 | 17.71598023262568 | 51588.93443740597 | 0.09317063278051349 | 4396.91071263035
 | 2001-09-24 00:00:00 | 2004-11-18 00:00:00 | 9 | Firefighter/PM | 2912 | 17.77572122820498 | 51762.90021653291 | 18.84221060022229 | 54868.51726784731 | 0.05999696768000024 | 3105.617051314402 | 18.33203019976288 | 53382.87194170952 | -0.02707646206084689 | -1485.64532613779 | 19.43189642316685 | 56585.68238426186 | 0.09317063278051357 | 4822.782167728954
 | 2002-08-12 00:00:00 | 2003-11-17 00:00:00 | 8 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997 | 17.77572122820498 | 51762.90021653291 | -0.02707646206084683 | -1440.561513026121 | 18.84221060022229 | 54868.51726784731 | 0.09317063278051359 | 4676.428656495278
 | 2004-11-29 00:00:00 |  | 6 | Firefighter/PM | 2912 | 16.20605210328833 | 47192.02372477562 | 17.17836608754972 | 50023.40204694479 | 0.05999696768000014 | 2831.378322169163 | 16.71323670991284 | 48668.9452992662 | -0.02707646206084684 | -1354.456747678589 | 17.71598023262568 | 51588.93443740597 | 0.09317063278051349 | 4396.91071263035
 | 2002-02-04 00:00:00 | 2002-02-04 00:00:00 | 8 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997 | 17.77572122820498 | 51762.90021653291 | -0.02707646206084683 | -1440.561513026121 | 18.84221060022229 | 54868.51726784731 | 0.09317063278051359 | 4676.428656495278
 |  |  | 8 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997 | 17.77572122820498 | 51762.90021653291 | -0.02707646206084683 | -1440.561513026121 | 18.84221060022229 | 54868.51726784731 | 0.09317063278051359 | 4676.428656495278
 |  |  | 4 | Firefighter/PM | 2912 | 15.23738932773476 | 44371.27772236362 | 16.15158648275844 | 47033.41983779258 | 0.05999696768000005 | 2662.142115428956 | 15.71425866413555 | 45759.92122996271 | -0.02707646206084676 | -1273.498607829868 | 16.65706653332285 | 48505.37774503614 | 0.0931706327805134 | 4134.100022672515
 | 1999-12-06 00:00:00 | 2003-11-18 00:00:00 | 11 | Firefighter/PM | 2912 | 18.90574941689466 | 55053.54230199726 | 20.04003705362628 | 58356.58790015972 | 0.05999696768000035 | 3303.045598162462 | 19.4974237506458 | 56776.49796188057 | -0.02707646206084693 | -1580.089938279154 | 20.66721005325656 | 60182.91567508312 | 0.09317063278051362 | 5129.373373085858
 | 2002-10-01 00:00:00 |  | 8 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997 | 17.77572122820498 | 51762.90021653291 | -0.02707646206084683 | -1440.561513026121 | 18.84221060022229 | 54868.51726784731 | 0.09317063278051359 | 4676.428656495278
 |  |  | 4 | Firefighter/PM | 2912 | 15.23738932773476 | 44371.27772236362 | 16.15158648275844 | 47033.41983779258 | 0.05999696768000005 | 2662.142115428956 | 15.71425866413555 | 45759.92122996271 | -0.02707646206084676 | -1273.498607829868 | 16.65706653332285 | 48505.37774503614 | 0.0931706327805134 | 4134.100022672515
 | 2004-11-29 00:00:00 |  | 6 | Firefighter/PM | 2912 | 16.20605210328833 | 47192.02372477562 | 17.17836608754972 | 50023.40204694479 | 0.05999696768000014 | 2831.378322169163 | 16.71323670991284 | 48668.9452992662 | -0.02707646206084684 | -1354.456747678589 | 17.71598023262568 | 51588.93443740597 | 0.09317063278051349 | 4396.91071263035
 | 2002-05-20 00:00:00 | 2003-11-10 00:00:00 | 8 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997 | 17.77572122820498 | 51762.90021653291 | -0.02707646206084683 | -1440.561513026121 | 18.84221060022229 | 54868.51726784731 | 0.09317063278051359 | 4676.428656495278
 | 2003-04-28 00:00:00 | 2005-01-30 00:00:00 | 7 | Firefighter/PM | 2912 | 16.71323670991284 | 48668.9452992662 | 17.71598023262568 | 51588.93443740597 | 0.05999696768000028 | 2919.989138139776 | 17.23629416598628 | 50192.08861135203 | -0.0270764620608469 | -1396.845826053941 | 18.27041954998593 | 53203.46172955903 | 0.09317063278051355 | 4534.516430292832
 | 2002-08-12 00:00:00 | 2003-10-12 00:00:00 | 8 | Firefighter/PM | 2912 | 17.23629416598628 | 50192.08861135203 | 18.27041954998593 | 53203.46172955903 | 0.05999696768000026 | 3011.373118206997 | 17.77572122820498 | 51762.90021653291 | -0.02707646206084683 | -1440.561513026121 | 18.84221060022229 | 54868.51726784731 | 0.09317063278051359 | 4676.428656495278
 | 2000-04-17 00:00:00 | 2002-06-10 00:00:00 | 10 | Firefighter/PM | 2912 | 18.33203019976288 | 53382.87194170952 | 19.43189642316685 | 56585.68238426186 | 0.05999696768000031 | 3202.810442552342 | 18.90574941689466 | 55053.54230199726 | -0.02707646206084697 | -1532.140082264603 | 20.04003705362628 | 58356.58790015972 | 0.0931706327805136 | 4973.715958450201
 | 2004-11-29 00:00:00 |  | 6 | Firefighter/PM | 2912 | 16.20605210328833 | 47192.02372477562 | 17.17836608754972 | 50023.40204694479 | 0.05999696768000014 | 2831.378322169163 | 16.71323670991284 | 48668.9452992662 | -0.02707646206084684 | -1354.456747678589 | 17.71598023262568 | 51588.93443740597 | 0.09317063278051349 | 4396.91071263035
 | 1990-07-08 00:00:00 | 2000-04-17 00:00:00 | 10 | Lieutenant | 2912 | 22.69032111782288 | 66074.21509510021 | 24.05167158057771 | 70038.4676426423 | 0.05999696767999983 | 3964.252547542084 | 23.40043740752626 | 68142.07373071647 | -0.02707646206084649 | -1896.393911925828 | 24.80439269436347 | 72230.39152598643 | 0.09317063278051312 | 6156.176430886218
 | 1996-05-20 00:00:00 | 2003-03-02 00:00:00 | 7 | Lieutenant | 2912 | 20.6866726562022 | 60239.59077486081 | 21.9278102869631 | 63853.78355563655 | 0.05999696767999993 | 3614.192780775746 | 21.33408276365071 | 62124.84900775085 | -0.02707646206084654 | -1728.934547885699 | 22.6140630377039 | 65852.15156579376 | 0.09317063278051323 | 5612.560790932948
 | 1996-05-20 00:00:00 | 2004-02-01 00:00:00 | 6 | Lieutenant | 2912 | 20.05890903892016 | 58411.54312133549 | 21.26238275622431 | 61916.05858612518 | 0.05999696768000001 | 3504.515464789692 | 20.6866726562022 | 60239.59077486081 | -0.0270764620608466 | -1676.467811264374 | 21.9278102869631 | 63853.78355563655 | 0.09317063278051325 | 5442.240434301064
 | 2001-09-24 00:00:00 | 2004-02-01 00:00:00 | 6 | Lieutenant | 2912 | 20.05890903892016 | 58411.54312133549 | 21.26238275622431 | 61916.05858612518 | 0.05999696768000001 | 3504.515464789692 | 20.6866726562022 | 60239.59077486081 | -0.0270764620608466 | -1676.467811264374 | 21.9278102869631 | 63853.78355563655 | 0.09317063278051325 | 5442.240434301064
 | 1996-07-01 00:00:00 | 2003-03-02 00:00:00 | 7 | Lieutenant | 2912 | 20.6866726562022 | 60239.59077486081 | 21.9278102869631 | 63853.78355563655 | 0.05999696767999993 | 3614.192780775746 | 21.33408276365071 | 62124.84900775085 | -0.02707646206084654 | -1728.934547885699 | 22.6140630377039 | 65852.15156579376 | 0.09317063278051323 | 5612.560790932948
 | 1993-03-15 00:00:00 | 1996-11-21 00:00:00 | 13 | Lieutenant/PM | 2912 | 27.6958692462923 | 80650.37124520319 | 29.35753713366515 | 85489.14813323293 | 0.05999695740169989 | 4838.776888029737 | 28.56263889326558 | 83174.40445718936 | -0.02707646206084649 | -2314.743676043567 | 30.09147556200678 | 87626.37683656375 | 0.0864968813367424 | 6976.005591360561
 | 2002-10-01 00:00:00 |  | 5 | Lieutenant/PM | 2912 | 21.64454035617465 | 63028.90151718057 | 22.94314692190344 | 66810.44383658281 | 0.05999695740170015 | 3781.542319402237 | 22.32192767471609 | 65001.45338877324 | -0.0270764620608468 | -1808.99044780957 | 23.66117541853986 | 68901.34281878806 | 0.09317061158057413 | 5872.44130160749
 | 1991-06-10 00:00:00 | 1999-09-05 00:00:00 | 11 | Lieutenant/PM | 2912 | 26.04044143325237 | 75829.76545363091 | 27.60278868864468 | 80379.32066133332 | 0.0599969574017001 | 4549.555207702404 | 26.85540282794302 | 78202.93303497009 | -0.02707646206084674 | -2176.387626363226 | 28.46664528741662 | 82894.87107695719 | 0.09317061158057406 | 7065.105623326279
 | 1998-11-02 00:00:00 | 2003-03-30 00:00:00 | 7 | Lieutenant/PM | 2912 | 23.02051450000472 | 67035.73822401375 | 24.40167532782672 | 71057.67855463142 | 0.05999695740170004 | 4021.940330617668 | 23.74096429159172 | 69133.6880171151 | -0.02707646206084675 | -1923.990537516322 | 25.16534991486963 | 73281.49895210037 | 0.09317061158057398 | 6245.760728086621
 | 2000-12-18 00:00:00 | 2000-12-18 00:00:00 | 1 | Paramedic | 2080 | 14.83286538461538 | 30852.36 | 15.72283730769231 | 32703.5016 | 0.06000000000000009 | 1851.141600000003 | 16.19452242692308 | 33684.606648 | 0.02999999999999993 | 981.1050479999976 | 15.72283730769231 | 32703.5016 | 0.06000000000000009 | 1851.141600000003
 | 1990-07-08 00:00:00 | 2001-05-08 00:00:00 | 9 | Battalion Chief | 2912 | 27.01193908438798 | 78658.76661373778 | 28.63257352060814 | 83378.05409201089 | 0.05999696768000026 | 4719.287478273109 | 27.85730472997298 | 81120.47137368131 | -0.02707646206084694 | -2257.582718329577 | 29.52865854150908 | 85987.45367287446 | 0.09317063278051346 | 7328.687059136675
 | 1999-11-08 00:00:00 | 1999-11-08 00:00:00 | 11 | Battalion Chief | 2912 | 28.72912693880221 | 83659.21764579204 | 30.45278743922415 | 88678.51702302073 | 0.05999696768000019 | 5019.299377228686 | 29.62823369547897 | 86277.41652123476 | -0.02707646206084673 | -2401.100501785972 | 31.40583787492211 | 91453.79989177319 | 0.0931706327805135 | 7794.582245981146
 | 1991-07-23 00:00:00 | 1999-11-08 00:00:00 | 11 | Battalion Chief | 2912 | 28.72912693880221 | 83659.21764579204 | 30.45278743922415 | 88678.51702302073 | 0.05999696768000019 | 5019.299377228686 | 29.62823369547897 | 86277.41652123476 | -0.02707646206084673 | -2401.100501785972 | 31.40583787492211 | 91453.79989177319 | 0.0931706327805135 | 7794.582245981146
 |  |  |  |  |  |  |  |  |  |  | 140246.1187577273 |  |  |  | -65223.40494339046 |  |  |  | 216229.5561355188
 |  |  |  |  |  |  | 2337551.93923647 |  | 2477798.057994199 |  |  |  | 2412574.653050807 |  |  |  | 2553781.495371989