Spreadsheet: 39832d1238095545-vlookup-with-s-ndorey_salaray_analysis_ronc
Sheet: 08-09 Placement

 |  |  | Years |  |  | 2007-10-01 00:00:00 |  | 2008-10-01 00:00:00
 | Date | Date | in Position |  |  | Base | 2007-2008 | Base | 2008-2009
Employee | of | of | at 01-01-09 | Position | Annual | Hourly | Base | Hourly | Base | % | $ | AS Degree | Engineers
Name | Hire | Service | (DOS) | Description | Hours | Rate | Salary | Rate | Salary | Increase | Increase | Incentive | Incentive
 | 2004-11-29 00:00:00 | 2008-10-01 00:00:00 | 4 | Firefighter/EMT | 2912 | 13.50963693075147 | 39340.06274234827 | 14.3201741810543 | 41700.34721523011 | 0.05999696768000011 | 2360.284472881845
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.36846399912882 | 41840.96716546311 | 15.23052826929579 | 44351.29832018934 | 0.05999696768000008 | 2510.331154726235
 | 2004-06-07 00:00:00 | 2004-06-07 00:00:00 | 4 | Firefighter/EMT | 2912 | 13.50963693075147 | 39340.06274234827 | 14.3201741810543 | 41700.34721523011 | 0.05999696768000011 | 2360.284472881845
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 3 | Firefighter/EMT | 2912 | 13.0996696687968 | 38146.23807553628 | 13.88561012653428 | 40434.89668846782 | 0.05999696768000012 | 2288.65861293154
 | 2004-11-29 00:00:00 |  | 4 | Firefighter/EMT | 2912 | 13.50963693075147 | 39340.06274234827 | 14.3201741810543 | 41700.34721523011 | 0.05999696768000011 | 2360.284472881845
 | 2004-06-07 00:00:00 | 2004-06-07 00:00:00 | 4 | Firefighter/EMT | 2912 | 13.50963693075147 | 39340.06274234827 | 14.3201741810543 | 41700.34721523011 | 0.05999696768000011 | 2360.284472881845
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.36846399912882 | 41840.96716546311 | 15.23052826929579 | 44351.29832018934 | 0.05999696768000008 | 2510.331154726235
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 3 | Firefighter/EMT | 2912 | 13.0996696687968 | 38146.23807553628 | 13.88561012653428 | 40434.89668846782 | 0.05999696768000012 | 2288.65861293154
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.36846399912882 | 41840.96716546311 | 15.23052826929579 | 44351.29832018934 | 0.05999696768000008 | 2510.331154726235
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 5 | Firefighter/EMT | 2912 | 13.93243452813626 | 40571.2493459328 | 14.76833835222457 | 43005.40128167795 | 0.05999696768000008 | 2434.151935745154
 | 2005-10-03 00:00:00 | 2005-10-03 00:00:00 | 3 | Firefighter/EMT | 2912 | 13.0996696687968 | 38146.23807553628 | 13.88561012653428 | 40434.89668846782 | 0.05999696768000012 | 2288.65861293154
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 5 | Firefighter/EMT | 2912 | 13.93243452813626 | 40571.2493459328 | 14.76833835222457 | 43005.40128167795 | 0.05999696768000008 | 2434.151935745154
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.36846399912882 | 41840.96716546311 | 15.23052826929579 | 44351.29832018934 | 0.05999696768000008 | 2510.331154726235
 | 2003-12-08 00:00:00 | 2003-12-08 00:00:00 | 5 | Firefighter/EMT | 2912 | 13.93243452813626 | 40571.2493459328 | 14.76833835222457 | 43005.40128167795 | 0.05999696768000008 | 2434.151935745154
 | 2003-03-03 00:00:00 | 2003-03-03 00:00:00 | 5 | Firefighter/EMT | 2912 | 13.93243452813626 | 40571.2493459328 | 14.76833835222457 | 43005.40128167795 | 0.05999696768000008 | 2434.151935745154
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.36846399912882 | 41840.96716546311 | 15.23052826929579 | 44351.29832018934 | 0.05999696768000008 | 2510.331154726235
 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 6 | Firefighter/EMT | 2912 | 14.36846399912882 | 41840.96716546311 | 15.23052826929579 | 44351.29832018934 | 0.05999696768000008 | 2510.331154726235
 | 2005-09-26 00:00:00 | 2005-09-26 00:00:00 | 3 | Firefighter/EMT | 2912 | 13.0996696687968 | 38146.23807553628 | 13.88561012653428 | 40434.89668846782 | 0.05999696768000012 | 2288.65861293154
 | 2001-09-24 00:00:00 | 2004-11-18 00:00:00 | 7 | Firefighter/PM | 2912 | 16.76959630093136 | 48833.06442831211 | 17.77572122820498 | 51762.90021653291 | 0.05999696767999986 | 2929.835788220793
 | 2002-08-12 00:00:00 | 2003-11-17 00:00:00 | 6 | Firefighter/PM | 2912 | 16.26070139022294 | 47351.1624483292 | 17.23629416598628 | 50192.08861135203 | 0.05999696767999982 | 2840.926163022828
 | 2002-02-04 00:00:00 | 2002-02-04 00:00:00 | 6 | Firefighter/PM | 2912 | 16.26070139022294 | 47351.1624483292 | 17.23629416598628 | 50192.08861135203 | 0.05999696767999982 | 2840.926163022828
 |  |  | 6 | Firefighter/PM | 2912 | 16.26070139022294 | 47351.1624483292 | 17.23629416598628 | 50192.08861135203 | 0.05999696767999982 | 2840.926163022828
 |  |  | 2 | Firefighter/PM | 2912 | 14.37493671428571 | 41859.815712 | 15.23738932773476 | 44371.27772236362 | 0.05999696767999996 | 2511.462010363619
 | 1999-12-06 00:00:00 | 2003-11-18 00:00:00 | 9 | Firefighter/PM | 2912 | 17.83566367956071 | 51937.4526348808 | 18.90574941689466 | 55053.54230199726 | 0.05999696767999971 | 3116.089667116459
 | 2002-10-01 00:00:00 |  | 6 | Firefighter/PM | 2912 | 16.26070139022294 | 47351.1624483292 | 17.23629416598628 | 50192.08861135203 | 0.05999696767999982 | 2840.926163022828
 |  |  | 2 | Firefighter/PM | 2912 | 14.37493671428571 | 41859.815712 | 15.23738932773476 | 44371.27772236362 | 0.05999696767999996 | 2511.462010363619
 | 2004-11-29 00:00:00 |  | 4 | Firefighter/PM | 2912 | 15.28877213560175 | 44520.9044588723 | 16.20605210328833 | 47192.02372477562 | 0.05999696767999993 | 2671.119265903326
 | 2002-05-20 00:00:00 | 2003-11-10 00:00:00 | 6 | Firefighter/PM | 2912 | 16.26070139022294 | 47351.1624483292 | 17.23629416598628 | 50192.08861135203 | 0.05999696767999982 | 2840.926163022828
 | 2003-04-28 00:00:00 | 2005-01-30 00:00:00 | 5 | Firefighter/PM | 2912 | 15.76724954835754 | 45914.23068481716 | 16.71323670991284 | 48668.9452992662 | 0.05999696767999985 | 2754.714614449033
 | 2002-08-12 00:00:00 | 2003-10-12 00:00:00 | 6 | Firefighter/PM | 2912 | 16.26070139022294 | 47351.1624483292 | 17.23629416598628 | 50192.08861135203 | 0.05999696767999982 | 2840.926163022828
 | 2000-04-17 00:00:00 | 2002-06-10 00:00:00 | 8 | Firefighter/PM | 2912 | 17.29441758676531 | 50361.34401266057 | 18.33203019976288 | 53382.87194170952 | 0.05999696767999983 | 3021.527929048949
 | 2004-11-29 00:00:00 |  | 4 | Firefighter/PM | 2912 | 15.28877213560175 | 44520.9044588723 | 16.20605210328833 | 47192.02372477562 | 0.05999696767999993 | 2671.119265903326
 | 2002-10-01 00:00:00 |  | 3 | Lieutenant | 2912 | 18.34929373093357 | 53433.14334447855 | 19.45019571385922 | 56638.96991875804 | 0.05999696768000006 | 3205.82657427949
 | 1990-07-08 00:00:00 | 2000-04-17 00:00:00 | 8 | Lieutenant | 2912 | 21.40602455447099 | 62334.34350261952 | 22.69032111782288 | 66074.21509510021 | 0.05999696768000012 | 3739.871592480689
 | 1996-05-20 00:00:00 | 2003-03-02 00:00:00 | 5 | Lieutenant | 2912 | 19.51578474934586 | 56829.96519009514 | 20.6866726562022 | 60239.59077486081 | 0.05999696768000003 | 3409.625584765665
 | 1996-05-20 00:00:00 | 2004-02-01 00:00:00 | 4 | Lieutenant | 2912 | 18.92355322753687 | 55105.38699858735 | 20.05890903892016 | 58411.54312133549 | 0.05999696767999997 | 3306.156122748136
 | 2001-09-24 00:00:00 | 2004-02-01 00:00:00 | 4 | Lieutenant | 2912 | 18.92355322753687 | 55105.38699858735 | 20.05890903892016 | 58411.54312133549 | 0.05999696767999997 | 3306.156122748136
 | 1996-07-01 00:00:00 | 2003-03-02 00:00:00 | 5 | Lieutenant | 2912 | 19.51578474934586 | 56829.96519009514 | 20.6866726562022 | 60239.59077486081 | 0.05999696768000003 | 3409.625584765665
 | 1993-03-15 00:00:00 | 1996-11-21 00:00:00 | 12 | Lieutenant/PM | 2912 | 26.94596309340291 | 78466.64452798927 | 28.56263889326558 | 83174.40445718936 | 0.05999695740169984 | 4707.759929200096
 | 1991-06-10 00:00:00 | 1999-09-05 00:00:00 | 9 | Lieutenant/PM | 2912 | 24.56652469747043 | 71537.7199190339 | 26.04044143325237 | 75829.76545363091 | 0.05999695740169984 | 4292.045534597011
 | 1998-11-02 00:00:00 | 2003-03-30 00:00:00 | 5 | Lieutenant/PM | 2912 | 21.71752884690667 | 63241.44400219223 | 23.02051450000472 | 67035.73822401375 | 0.05999695740169991 | 3794.294221821518
 | 2000-12-18 00:00:00 | 2000-12-18 00:00:00 | 1 | Paramedic | 2080 | 13.99326923076923 | 29106 | 14.83286538461538 | 30852.36 | 0.06000000000000002 | 1746.360000000001
 | 1990-07-08 00:00:00 | 2001-05-08 00:00:00 | 7 | Battalion Chief | 2912 | 25.48303429915334 | 74206.59587913453 | 27.01193908438798 | 78658.76661373778 | 0.05999696767999991 | 4452.170734603249
 | 1999-11-08 00:00:00 | 1999-11-08 00:00:00 | 9 | Battalion Chief | 2912 | 27.10302747533443 | 78924.01600817386 | 28.72912693880221 | 83659.21764579204 | 0.05999696767999969 | 4735.201637618185
 | 1991-07-23 00:00:00 | 1999-11-08 00:00:00 | 9 | Battalion Chief | 2912 | 27.10302747533443 | 78924.01600817386 | 28.72912693880221 | 83659.21764579204 | 0.05999696767999969 | 4735.201637618185
 |  |  |  |  |  |  | 1959180.510114116 |  | 2076725.485925621 |  | 117544.975811504