Spreadsheet: 39826d1238092511-vlookup-with-s-help-please
Sheet: 09-12 Step Plan

IAFF Step Pan for October 1, 2009 - September 30, 2012
Firefighter/EMT
 |  |  |  |  |  |  |  |  | Increase | Increase
 |  |  |  |  |  | Increase | Increase | Increase | Between | Between
 |  |  | Year | Year | Year | Between | Between | Between | 09-10 vs. | 10-11 vs.
 |  |  | 09-10 | 10-11 | 11-12 | Steps | Steps | Steps | 10-11 | 11-12
FF/EMT | 1 | FF/EMT1 | 39076.07737032982 | 40163.5646035461 | 41281.31660646278 |  |  |  | 0.02783 | 0.02783
FF/EMT | 2 | FF/EMT2 | 40299.00228771166 | 41420.52352137867 | 42573.25669097864 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 3 | FF/EMT3 | 41560.19986330788 | 42716.82022550374 | 43905.62933237951 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 4 | FF/EMT4 | 42860.86787822997 | 44053.6858312811 | 45279.69990796566 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 5 | FF/EMT5 | 44202.24159934706 | 45432.38998305688 | 46696.77339628535 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 6 | FF/EMT6 | 45585.59495244022 | 46854.24205996662 | 48158.1956164955 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 7 | FF/EMT7 | 47012.24173207179 | 48320.59241947534 | 49665.35450650934 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 8 | FF/EMT8 | 48483.53684931871 | 49832.83367983524 | 51219.68144114506 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 9 | FF/EMT9 | 50000.87761855499 | 51392.40204267936 | 52822.65259152713 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 10 | FF/EMT10 | 51565.70508450529 | 53000.77865700706 | 54475.79032703157 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 11 | FF/EMT11 | 53179.50539082997 | 54659.49102585675 | 56180.66466110635 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 12 | FF/EMT12 | 54843.81119154139 | 56370.11445700197 | 57938.89474234033 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 13 | FF/EMT13 | 56560.20310659187 | 58134.2735590483 | 59752.15039219661 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 14 | FF/EMT14 | 58330.31122301577 | 59953.64378435227 | 61622.1536908708 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 15 | FF/EMT15 | 60155.81664305127 | 61829.95302022736 | 63550.68061278029 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
Top Out | 16 | 0.025 | 61659.71205912755 | 63375.70184573304 | 65139.4476280998 | 0.025 | 0.025 | 0.025 | 0.02783 | 0.02783
Firefighter/Paramedic
 |  |  |  |  |  |  |  |  | Increase | Increase
 |  |  |  |  |  | Increase | Increase | Increase | Between | Between | Firefighter/Paramedic Pay Differential
 |  |  | Year | Year | Year | Between | Between | Between | 09-10 vs. | 10-11 vs.
 |  |  | 09-10 | 10-11 | 11-12 | Steps | Steps | Steps | 10-11 | 11-12 |  |  | Year |  | Year |  | Year
 |  |  |  |  |  |  |  |  |  |  |  |  | 09-10 |  | 10-11 |  | 11-12
FF/PM | 1 | FF/PM1 | 44222.15385435123 | 45452.85639611782 | 46717.80938962178 |  |  |  | 0.02783 | 0.02783 | FF/PM | 1 | 5146.076484021411 | 0.1316937837759731 | 5289.291792571727 | 0.1316937837759731 | 5436.492783159003 | 0.1316937837759732
FF/PM | 2 | FF/PM2 | 45606.13038137701 | 46875.34898989073 | 48179.88995227939 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 2 | 5307.128093665349 | 0.1316937837759732 | 5454.825468512056 | 0.1316937837759732 | 5606.633261300747 | 0.1316937837759732
FF/PM | 3 | FF/PM3 | 47033.41983779258 | 48342.35991187835 | 49687.72778822592 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 3 | 5473.219974484695 | 0.1316937837759731 | 5625.539686374606 | 0.1316937837759732 | 5782.098455846412 | 0.1316937837759732
FF/PM | 4 | FF/PM4 | 48505.37774503614 | 49855.28240768049 | 51242.75491708624 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 4 | 5644.509866806169 | 0.1316937837759731 | 5801.596576399388 | 0.1316937837759732 | 5963.055009120581 | 0.1316937837759731
FF/PM | 5 | FF/PM5 | 50023.40204694479 | 51415.55332591126 | 52846.44817497137 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 5 | 5821.160447597729 | 0.131693783775973 | 5983.163342854379 | 0.1316937837759731 | 6149.674778686021 | 0.1316937837759732
FF/PM | 6 | FF/PM6 | 51588.93443740597 | 53024.65448279898 | 54500.33061705528 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 6 | 6003.339484965749 | 0.131693783775973 | 6170.412422832356 | 0.1316937837759733 | 6342.135000559778 | 0.1316937837759732
FF/PM | 7 | FF/PM7 | 53203.46172955903 | 54684.11406949266 | 56205.97296404664 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 7 | 6191.219997487235 | 0.1316937837759729 | 6363.521650017319 | 0.1316937837759733 | 6540.618457537297 | 0.1316937837759732
FF/PM | 8 | FF/PM8 | 54868.51726784731 | 56395.5081034115 | 57964.99509392944 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 8 | 6384.980418528598 | 0.131693783775973 | 6562.67442357626 | 0.1316937837759733 | 6745.313652784382 | 0.1316937837759731
FF/PM | 9 | FF/PM9 | 56585.68238426186 | 58160.46192501586 | 59779.06758038906 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 9 | 6584.804765706867 | 0.131693783775973 | 6768.0598823365 | 0.1316937837759732 | 6956.414988861921 | 0.1316937837759731
FF/PM | 10 | FF/PM10 | 58356.58790015972 | 59980.65174142116 | 61649.91327938491 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 10 | 6790.882815654426 | 0.1316937837759729 | 6979.873084414103 | 0.1316937837759732 | 7174.122952353348 | 0.1316937837759732
FF/PM | 11 | FF/PM11 | 60182.91567508312 | 61857.80621832068 | 63579.30896537654 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 11 | 7003.410284253143 | 0.1316937837759728 | 7198.315192463924 | 0.1316937837759732 | 7398.644304270194 | 0.1316937837759731
FF/PM | 12 | FF/PM12 | 62066.40020405051 | 63793.70812172924 | 65569.08701875697 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 12 | 7222.589012509125 | 0.1316937837759727 | 7423.593664727276 | 0.1316937837759732 | 7630.192276416637 | 0.1316937837759732
FF/PM | 13 | FF/PM13 | 64008.83026483648 | 65790.19601110688 | 67621.13716609598 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 13 | 7448.627158244606 | 0.1316937837759727 | 7655.922452058578 | 0.1316937837759731 | 7868.986773899371 | 0.1316937837759732
FF/PM | 14 | FF/PM14 | 66012.0506168048 | 67849.16598547048 | 69737.40827484612 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 14 | 7681.73939378903 | 0.1316937837759727 | 7895.522201118205 | 0.1316937837759732 | 8115.254583975322 | 0.1316937837759731
FF/PM | 15 | FF/PM15 | 68077.96375290833 | 69972.57348415176 | 71919.9102042157 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 15 | 7922.147109857055 | 0.1316937837759727 | 8142.620463924395 | 0.1316937837759731 | 8369.22959143541 | 0.1316937837759731
Top Out | 16 | 0.025 | 69779.91284673104 | 71721.88782125554 | 73717.90795932109 | 0.025 | 0.025 | 0.025 | 0.02783 | 0.02783 |  | Top Out | 8120.200787603484 | 0.1316937837759728 | 8346.185975522501 | 0.131693783775973 | 8578.460331221293 | 0.131693783775973
IAFF Step Pan for October 1, 2009 - September 30, 2012
Lieutenant/EMT
 |  |  |  |  |  |  |  |  | Increase | Increase
 |  |  |  |  |  | Increase | Increase | Increase | Between | Between
 |  |  | Year | Year | Year | Between | Between | Between | 09-10 vs. | 10-11 vs.
 |  |  | 09-10 | 10-11 | 11-12 | Steps | Steps | Steps | 10-11 | 11-12
LT/EMT | 1 | LT/EMT1 | 54735.61087031027 | 56258.90292083101 | 57824.58818911773 |  |  |  | 0.02783 | 0.02783
LT/EMT | 2 | LT/EMT2 | 56448.6165481075 | 58019.58154664133 | 59634.26650108436 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 3 | LT/EMT3 | 58215.23245159708 | 59835.36237072502 | 61500.5805055023 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 4 | LT/EMT4 | 60037.13636640226 | 61707.96987147923 | 63425.3026730025 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 5 | LT/EMT5 | 61916.05858612518 | 63639.18249657704 | 65410.26094545679 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 6 | LT/EMT6 | 63853.78355563655 | 65630.83435198992 | 67457.3404720058 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 7 | LT/EMT7 | 65852.15156579376 | 67684.8169438698 | 69568.4853994177 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 8 | LT/EMT8 | 67913.06050119684 | 69803.08097494514 | 71745.70071847788 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 9 | LT/EMT9 | 70038.4676426423 | 71987.63819713703 | 73991.05416816336 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 10 | LT/EMT10 | 72230.39152598643 | 74240.56332215463 | 76306.6781994102 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 11 | LT/EMT11 | 74490.9138591837 | 76563.99599188479 | 78694.77200033894 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 12 | LT/EMT12 | 76822.18149932071 | 78960.14281044682 | 81157.60358486154 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
Top Out | 13 | 0.025 | 78742.73603680372 | 80934.14638070799 | 83186.54367448308 | 0.025 | 0.025 | 0.025 | 0.02783 | 0.02783
Lieutenant/Paramedic
 |  |  |  |  |  |  |  |  | Increase | Increase
 |  |  |  |  |  | Increase | Increase | Increase | Between | Between | Lieutenant/Paramedic Pay Differential
 |  |  | Year | Year | Year | Between | Between | Between | 09-10 vs. | 10-11 vs.
 |  |  | 09-10 | 10-11 | 11-12 | Steps | Steps | Steps | 10-11 | 11-12 |  |  | Year |  | Year |  | Year
 |  |  |  |  |  |  |  |  |  |  |  |  | 09-10 |  | 10-11 |  | 11-12
LT/PM | 1 | LT/PM1 | 60910.80926931898 | 62605.95709128413 | 64348.28087713457 |  |  |  | 0.02783 | 0.02783 | LT/PM | 1 | 6175.19839900871 | 0.1128186623081659 | 6347.054170453121 | 0.1128186623081659 | 6523.692688016832 | 0.1128186623081659
LT/PM | 2 | LT/PM2 | 62817.0733471035 | 64565.27249835338 | 66362.12403198256 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 2 | 6368.456798995998 | 0.1128186515176785 | 6545.690951712051 | 0.1128186515176784 | 6727.857530898196 | 0.1128186515176784
LT/PM | 3 | LT/PM3 | 64782.99584640372 | 66585.90662080912 | 68438.99240206624 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 3 | 6567.763394806643 | 0.112818640727191 | 6750.544250084102 | 0.1128186407271909 | 6938.411896563943 | 0.1128186407271909
LT/PM | 4 | LT/PM4 | 66810.44383658281 | 68669.7784885549 | 70580.85842389139 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 4 | 6773.307470180553 | 0.1128186299367037 | 6961.808617075672 | 0.1128186299367036 | 7155.555750888889 | 0.1128186299367036
LT/PM | 5 | LT/PM5 | 68901.34281878806 | 70818.86718943494 | 72789.75626331691 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 5 | 6985.284232662882 | 0.1128186191462165 | 7179.684692857896 | 0.1128186191462165 | 7379.495317860128 | 0.1128186191462165
LT/PM | 6 | LT/PM6 | 71057.67855463142 | 73035.21374880683 | 75067.78374743611 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 6 | 7203.894998994867 | 0.1128186083557293 | 7404.379396816905 | 0.1128186083557294 | 7610.443275430312 | 0.1128186083557293
LT/PM | 7 | LT/PM7 | 73281.49895210037 | 75320.92306793734 | 77417.10435691803 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 7 | 7429.347386306617 | 0.1128185975652422 | 7636.106124067548 | 0.1128185975652424 | 7848.618957500337 | 0.1128185975652423
LT/PM | 8 | LT/PM8 | 75574.91601049031 | 77678.16592306228 | 79839.9492807011 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 8 | 7661.855509293469 | 0.1128185867747551 | 7875.084948117132 | 0.1128185867747555 | 8094.24856222322 | 0.1128185867747553
LT/PM | 9 | LT/PM9 | 77940.10782620547 | 80109.18102700877 | 82338.61953499043 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 9 | 7901.64018356317 | 0.1128185759842685 | 8121.542829871745 | 0.1128185759842687 | 8347.565366827068 | 0.1128185759842685
LT/PM | 10 | LT/PM10 | 80379.32066133332 | 82616.27715533823 | 84915.4881485713 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 10 | 8148.929135346887 | 0.1128185651937818 | 8375.713833183603 | 0.112818565193782 | 8608.809949161092 | 0.1128185651937818
LT/PM | 11 | LT/PM11 | 82894.87107695719 | 85201.83533902893 | 87573.00241651411 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 11 | 8403.957217773495 | 0.1128185544032952 | 8637.839347144138 | 0.1128185544032953 | 8878.230416175167 | 0.1128185544032954
LT/PM | 12 | LT/PM12 | 85489.14813323293 | 87868.31112578082 | 90313.68622441131 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 12 | 8666.96663391222 | 0.1128185436128087 | 8908.168315333998 | 0.1128185436128087 | 9156.082639549772 | 0.1128185436128091
Top Out | 13 | 0.025 | 87626.37683656375 | 90065.01890392535 | 92571.5283800216 | 0.025 | 0.025 | 0.025 | 0.02783 | 0.02783 |  | Top Out | 8883.640799760033 | 0.1128185436128088 | 9130.87252321736 | 0.1128185436128089 | 9384.984705538518 | 0.1128185436128091
IAFF Step Pan for October 1, 2009 - September 30, 2012
Battalion Chief
 |  |  |  |  |  |  |  |  | Increase | Increase
 |  |  |  |  |  | Increase | Increase | Increase | Between | Between
 |  |  | Year | Year | Year | Between | Between | Between | 09-10 vs. | 10-11 vs.
 |  |  | 09-10 | 10-11 | 11-12 | Steps | Steps | Steps | 10-11 | 11-12
BC | 1 | BC1 | 67199.868334951 | 69070.04067071268 | 70992.25990257862 |  |  |  | 0.02783 | 0.02783
BC | 2 | BC2 | 69302.95541436163 | 71231.65666354331 | 73214.03366848972 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 3 | BC3 | 71471.86070700949 | 73460.92259048557 | 75505.34006617877 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 4 | BC4 | 73708.64405969606 | 75759.95562387741 | 77868.35518888991 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 5 | BC5 | 76015.42978418831 | 78130.93919508228 | 80305.3232328814 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 6 | BC6 | 78394.40867471427 | 80576.12506813157 | 82818.55862877767 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 7 | BC7 | 80847.84008859812 | 83097.83547826382 | 85410.44823962389 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 8 | BC8 | 83378.05409201089 | 85698.46533739156 | 88083.45362773116 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 9 | BC9 | 85987.45367287446 | 88380.48450859057 | 90840.11339246463 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 10 | BC10 | 88678.51702302073 | 91146.44015177141 | 93683.0455811952 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 11 | BC11 | 91453.79989177319 | 93998.95914276125 | 96614.95017570429 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 12 | BC12 | 94315.93801318613 | 96940.7505680931 | 99638.61165640313 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
Top Out | 13 | 0.025 | 96673.83646351578 | 99364.26933229543 | 102129.5769478132 | 0.025 | 0.025 | 0.025 | 0.02783 | 0.02783