Spreadsheet: 39832d1238095545-vlookup-with-s-ndorey_salaray_analysis_ronc
Sheet: 10-11 Step Continuation

 |  |  | Years |  |  | 2009-10-01 00:00:00 |  | 2010-10-01 00:00:00
 | Date | Date | in Position |  |  | Base | 2009-2010 | Base | 2010-2011
Employee | of | of | at 01-01-11 | 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 | 8 | Firefighter/EMT | 2912 | 16.14431378161806 | 47012.24173207179 | 17.11292365378958 | 49832.83367983524 | 0.05999696767999971 | 2820.591947763445
 | 2004-06-07 00:00:00 | 2004-06-07 00:00:00 | 6 | Firefighter/EMT | 2912 | 15.17934120856698 | 44202.24159934706 | 16.09005565246106 | 46854.24205996662 | 0.05999696767999974 | 2652.000460619565
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 5 | Firefighter/EMT | 2912 | 14.71870462851304 | 42860.86787822997 | 15.6017822744014 | 45432.38998305688 | 0.05999696767999988 | 2571.522104826909
 | 2004-06-07 00:00:00 | 2004-06-07 00:00:00 | 6 | Firefighter/EMT | 2912 | 15.17934120856698 | 44202.24159934706 | 16.09005565246106 | 46854.24205996662 | 0.05999696767999974 | 2652.000460619565
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 16.14431378161806 | 47012.24173207179 | 17.11292365378958 | 49832.83367983524 | 0.05999696767999971 | 2820.591947763445
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 5 | Firefighter/EMT | 2912 | 14.71870462851304 | 42860.86787822997 | 15.6017822744014 | 45432.38998305688 | 0.05999696767999988 | 2571.522104826909
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 16.14431378161806 | 47012.24173207179 | 17.11292365378958 | 49832.83367983524 | 0.05999696767999971 | 2820.591947763445
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 7 | Firefighter/EMT | 2912 | 15.6543938710303 | 45585.59495244022 | 16.59361003416049 | 48320.59241947534 | 0.05999696767999973 | 2734.997467035115
 | 2005-10-03 00:00:00 | 2005-10-03 00:00:00 | 5 | Firefighter/EMT | 2912 | 14.71870462851304 | 42860.86787822997 | 15.6017822744014 | 45432.38998305688 | 0.05999696767999988 | 2571.522104826909
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 7 | Firefighter/EMT | 2912 | 15.6543938710303 | 45585.59495244022 | 16.59361003416049 | 48320.59241947534 | 0.05999696767999973 | 2734.997467035115
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 16.14431378161806 | 47012.24173207179 | 17.11292365378958 | 49832.83367983524 | 0.05999696767999971 | 2820.591947763445
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 7 | Firefighter/EMT | 2912 | 15.6543938710303 | 45585.59495244022 | 16.59361003416049 | 48320.59241947534 | 0.05999696767999973 | 2734.997467035115
 | 2003-03-03 00:00:00 | 2003-03-03 00:00:00 | 7 | Firefighter/EMT | 2912 | 15.6543938710303 | 45585.59495244022 | 16.59361003416049 | 48320.59241947534 | 0.05999696767999973 | 2734.997467035115
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 16.14431378161806 | 47012.24173207179 | 17.11292365378958 | 49832.83367983524 | 0.05999696767999971 | 2820.591947763445
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 8 | Firefighter/EMT | 2912 | 16.14431378161806 | 47012.24173207179 | 17.11292365378958 | 49832.83367983524 | 0.05999696767999971 | 2820.591947763445
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 5 | Firefighter/EMT | 2912 | 14.71870462851304 | 42860.86787822997 | 15.6017822744014 | 45432.38998305688 | 0.05999696767999988 | 2571.522104826909
 | 2004-11-29 00:00:00 |  | 6 | Firefighter/PM | 2912 | 17.17836608754972 | 50023.40204694479 | 18.20901596249965 | 53024.65448279898 | 0.05999696768000001 | 3001.252435854192
 | 2001-09-24 00:00:00 | 2004-11-18 00:00:00 | 9 | Firefighter/PM | 2912 | 18.84221060022229 | 54868.51726784731 | 19.97268610062358 | 58160.46192501586 | 0.05999696767999996 | 3291.944657168555
 | 2002-08-12 00:00:00 | 2003-11-17 00:00:00 | 8 | Firefighter/PM | 2912 | 18.27041954998593 | 53203.46172955903 | 19.36658932122648 | 56395.5081034115 | 0.05999696768000001 | 3192.04637385247
 | 2004-11-29 00:00:00 |  | 6 | Firefighter/PM | 2912 | 17.17836608754972 | 50023.40204694479 | 18.20901596249965 | 53024.65448279898 | 0.05999696768000001 | 3001.252435854192
 | 2002-02-04 00:00:00 | 2002-02-04 00:00:00 | 8 | Firefighter/PM | 2912 | 18.27041954998593 | 53203.46172955903 | 19.36658932122648 | 56395.5081034115 | 0.05999696768000001 | 3192.04637385247
 |  |  | 8 | Firefighter/PM | 2912 | 18.27041954998593 | 53203.46172955903 | 19.36658932122648 | 56395.5081034115 | 0.05999696768000001 | 3192.04637385247
 |  |  | 4 | Firefighter/PM | 2912 | 16.15158648275844 | 47033.41983779258 | 17.12063269494522 | 49855.28240768049 | 0.05999696767999999 | 2821.862569887911
 | 1999-12-06 00:00:00 | 2003-11-18 00:00:00 | 11 | Firefighter/PM | 2912 | 20.04003705362628 | 58356.58790015972 | 21.24237850903869 | 61857.80621832068 | 0.05999696767999994 | 3501.218318160958
 | 2002-10-01 00:00:00 |  | 8 | Firefighter/PM | 2912 | 18.27041954998593 | 53203.46172955903 | 19.36658932122648 | 56395.5081034115 | 0.05999696768000001 | 3192.04637385247
 |  |  | 4 | Firefighter/PM | 2912 | 16.15158648275844 | 47033.41983779258 | 17.12063269494522 | 49855.28240768049 | 0.05999696767999999 | 2821.862569887911
 | 2004-11-29 00:00:00 |  | 6 | Firefighter/PM | 2912 | 17.17836608754972 | 50023.40204694479 | 18.20901596249965 | 53024.65448279898 | 0.05999696768000001 | 3001.252435854192
 | 2002-05-20 00:00:00 | 2003-11-10 00:00:00 | 8 | Firefighter/PM | 2912 | 18.27041954998593 | 53203.46172955903 | 19.36658932122648 | 56395.5081034115 | 0.05999696768000001 | 3192.04637385247
 | 2003-04-28 00:00:00 | 2005-01-30 00:00:00 | 7 | Firefighter/PM | 2912 | 17.71598023262568 | 51588.93443740597 | 18.77888532606204 | 54684.11406949266 | 0.05999696768 | 3095.179632086685
 | 2002-08-12 00:00:00 | 2003-10-12 00:00:00 | 8 | Firefighter/PM | 2912 | 18.27041954998593 | 53203.46172955903 | 19.36658932122648 | 56395.5081034115 | 0.05999696768000001 | 3192.04637385247
 | 2000-04-17 00:00:00 | 2002-06-10 00:00:00 | 10 | Firefighter/PM | 2912 | 19.43189642316685 | 56585.68238426186 | 20.5977512848287 | 59980.65174142116 | 0.05999696767999995 | 3394.969357159302
 | 2004-11-29 00:00:00 |  | 6 | Firefighter/PM | 2912 | 17.17836608754972 | 50023.40204694479 | 18.20901596249965 | 53024.65448279898 | 0.05999696768000001 | 3001.252435854192
 | 1990-07-08 00:00:00 | 2000-04-17 00:00:00 | 10 | Lieutenant | 2912 | 24.05167158057771 | 70038.4676426423 | 25.49469894304761 | 74240.56332215463 | 0.05999696767999999 | 4202.095679512335
 | 1996-05-20 00:00:00 | 2003-03-02 00:00:00 | 7 | Lieutenant | 2912 | 21.9278102869631 | 63853.78355563655 | 23.2434124120432 | 67684.8169438698 | 0.05999696768 | 3831.033388233242
 | 1996-05-20 00:00:00 | 2004-02-01 00:00:00 | 6 | Lieutenant | 2912 | 21.26238275622431 | 61916.05858612518 | 22.53806124724928 | 65630.83435198992 | 0.05999696768 | 3714.775765864739
 | 2001-09-24 00:00:00 | 2004-02-01 00:00:00 | 6 | Lieutenant | 2912 | 21.26238275622431 | 61916.05858612518 | 22.53806124724928 | 65630.83435198992 | 0.05999696768 | 3714.775765864739
 | 1996-07-01 00:00:00 | 2003-03-02 00:00:00 | 7 | Lieutenant | 2912 | 21.9278102869631 | 63853.78355563655 | 23.2434124120432 | 67684.8169438698 | 0.05999696768 | 3831.033388233242
 | 1993-03-15 00:00:00 | 1996-11-21 00:00:00 | 13 | Lieutenant/PM | 2912 | 29.35753713366515 | 85489.14813323293 | 30.92892132689744 | 90065.01890392535 | 0.0535257500000003 | 4575.870770692418
 | 2002-10-01 00:00:00 |  | 5 | Lieutenant/PM | 2912 | 22.94314692190344 | 66810.44383658281 | 24.31966593043782 | 70818.86718943494 | 0.0599969574017 | 4008.423352852129
 | 1991-06-10 00:00:00 | 1999-09-05 00:00:00 | 11 | Lieutenant/PM | 2912 | 27.60278868864468 | 80379.32066133332 | 29.25887202576543 | 85201.83533902893 | 0.05999695740170013 | 4822.51467769561
 | 1998-11-02 00:00:00 | 2003-03-30 00:00:00 | 7 | Lieutenant/PM | 2912 | 24.40167532782672 | 71057.67855463142 | 25.86570160300046 | 75320.92306793734 | 0.05999695740170014 | 4263.244513305923
 | 2000-12-18 00:00:00 | 2000-12-18 00:00:00 | 1 | Paramedic | 2080 | 17.66617999892308 | 36745.65439776001 | 18.72615079885847 | 38950.39366162561 | 0.06000000000000004 | 2204.739263865602
 | 1990-07-08 00:00:00 | 2001-05-08 00:00:00 | 9 | Battalion Chief | 2912 | 28.63257352060814 | 83378.05409201089 | 30.35044110871929 | 88380.48450859057 | 0.05999696768000011 | 5002.430416579678
 | 1999-11-08 00:00:00 | 1999-11-08 00:00:00 | 11 | Battalion Chief | 2912 | 30.45278743922415 | 88678.51702302073 | 32.2798623429812 | 93998.95914276125 | 0.05999696768000014 | 5320.442119740517
 | 1991-07-23 00:00:00 | 1999-11-08 00:00:00 | 11 | Battalion Chief | 2912 | 30.45278743922415 | 88678.51702302073 | 32.2798623429812 | 93998.95914276125 | 0.05999696768000014 | 5320.442119740517
 |  |  |  |  |  |  |  |  |  |  | 148349.7772083315
 |  |  |  |  |  |  | 2481840.210791958 |  | 2630189.988000288