Spreadsheet: 39563d1237842127-concatenate-formatting-tips-help-me-response
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 | 39207.84788117846 | 40299.00228771166 | 41420.52352137867 |  |  |  | 0.02783 | 0.02783
FF/EMT | 2 | FF/EMT2 | 40434.89668846782 | 41560.19986330788 | 42716.82022550374 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 3 | FF/EMT3 | 41700.34721523011 | 42860.86787822997 | 44053.6858312811 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 4 | FF/EMT4 | 43005.40128167795 | 44202.24159934706 | 45432.38998305688 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 5 | FF/EMT5 | 44351.29832018934 | 45585.59495244022 | 46854.24205996662 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 6 | FF/EMT6 | 45739.31655241799 | 47012.24173207179 | 48320.59241947534 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 7 | FF/EMT7 | 47170.77420324246 | 48483.53684931871 | 49832.83367983524 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 8 | FF/EMT8 | 48647.03075270714 | 50000.87761855499 | 51392.40204267936 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 9 | FF/EMT9 | 50169.48822714386 | 51565.70508450529 | 53000.77865700706 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 10 | FF/EMT10 | 51739.59253070055 | 53179.50539082997 | 54659.49102585675 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 11 | FF/EMT11 | 53358.83481854136 | 54843.81119154139 | 56370.11445700197 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 12 | FF/EMT12 | 55028.75291302243 | 56560.20310659187 | 58134.2735590483 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 13 | FF/EMT13 | 56750.93276418838 | 58330.31122301577 | 59953.64378435227 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 14 | FF/EMT14 | 58527.00995597642 | 60155.81664305127 | 61829.95302022736 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
FF/EMT | 15 | FF/EMT15 | 60358.67125955866 | 62038.45308071221 | 63764.9832299484 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
 | Top Out | 0.025 | 61867.63804104763 | 63589.41440773002 | 65359.1078106971 | 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 | 44371.27772236362 | 45606.130381377 | 46875.34898989072 |  |  |  | 0.02783 | 0.02783 | FF/PM | 1 | 5163.429841185163 | 0.1316937837759732 | 5307.128093665342 | 0.131693783775973 | 5454.825468512048 | 0.131693783775973
FF/PM | 2 | FF/PM2 | 45759.92122996271 | 47033.41983779257 | 48342.35991187834 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 2 | 5325.024541494888 | 0.131693783775973 | 5473.219974484688 | 0.1316937837759729 | 5625.539686374599 | 0.131693783775973
FF/PM | 3 | FF/PM3 | 47192.02372477562 | 48505.37774503613 | 49855.28240768048 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 3 | 5491.676509545512 | 0.131693783775973 | 5644.509866806162 | 0.131693783775973 | 5801.596576399381 | 0.131693783775973
FF/PM | 4 | FF/PM4 | 48668.9452992662 | 50023.40204694478 | 51415.55332591125 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 4 | 5663.544017588247 | 0.131693783775973 | 5821.160447597722 | 0.1316937837759728 | 5983.163342854372 | 0.131693783775973
FF/PM | 5 | FF/PM5 | 50192.08861135203 | 51588.93443740597 | 53024.65448279897 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 5 | 5840.790291162688 | 0.131693783775973 | 6003.339484965742 | 0.1316937837759728 | 6170.412422832349 | 0.1316937837759731
FF/PM | 6 | FF/PM6 | 51762.90021653291 | 53203.46172955902 | 54684.11406949265 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 6 | 6023.583664114914 | 0.1316937837759729 | 6191.219997487227 | 0.1316937837759728 | 6363.521650017312 | 0.1316937837759731
FF/PM | 7 | FF/PM7 | 53382.87194170952 | 54868.5172678473 | 56395.50810341149 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 7 | 6212.097738467055 | 0.1316937837759729 | 6384.98041852859 | 0.1316937837759729 | 6562.674423576253 | 0.1316937837759731
FF/PM | 8 | FF/PM8 | 55053.54230199726 | 56585.68238426185 | 58160.46192501586 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 8 | 6406.511549290117 | 0.1316937837759729 | 6584.80476570686 | 0.1316937837759728 | 6768.059882336493 | 0.1316937837759731
FF/PM | 9 | FF/PM9 | 56776.49796188057 | 58356.58790015971 | 59980.65174142116 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 9 | 6607.009734736705 | 0.131693783775973 | 6790.882815654419 | 0.1316937837759727 | 6979.873084414096 | 0.131693783775973
FF/PM | 10 | FF/PM10 | 58553.37524209558 | 60182.91567508311 | 61857.80621832067 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 10 | 6813.782711395026 | 0.131693783775973 | 7003.410284253136 | 0.1316937837759727 | 7198.315192463917 | 0.131693783775973
FF/PM | 11 | FF/PM11 | 60385.8616736722 | 62066.40020405051 | 63793.70812172924 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 11 | 7027.026855130847 | 0.131693783775973 | 7222.589012509117 | 0.1316937837759726 | 7423.593664727268 | 0.131693783775973
FF/PM | 12 | FF/PM12 | 62275.69760061145 | 64008.83026483647 | 65790.19601110688 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 12 | 7246.944687589021 | 0.131693783775973 | 7448.627158244599 | 0.1316937837759725 | 7655.922452058578 | 0.1316937837759731
FF/PM | 13 | FF/PM13 | 64224.67783272018 | 66012.05061680479 | 67849.16598547048 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 13 | 7473.745068531804 | 0.131693783775973 | 7681.739393789016 | 0.1316937837759724 | 7895.522201118205 | 0.1316937837759732
FF/PM | 14 | FF/PM14 | 66234.65335017299 | 68077.96375290831 | 69972.57348415176 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 14 | 7707.643394196566 | 0.1316937837759728 | 7922.14710985704 | 0.1316937837759725 | 8142.620463924395 | 0.1316937837759731
FF/PM | 15 | FF/PM15 | 68307.53306142 | 70208.53170651934 | 72162.43514391177 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783 | FF/PM | 15 | 7948.861801861349 | 0.1316937837759729 | 8170.078625807131 | 0.1316937837759725 | 8397.451913963378 | 0.1316937837759731
 | Top Out | 0.025 | 70015.2213879555 | 71963.74499918232 | 73966.49602250957 | 0.025 | 0.025 | 0.025 | 0.02783 | 0.02783 |  | Top Out | 8147.583346907879 | 0.1316937837759729 | 8374.330591452308 | 0.1316937837759725 | 8607.388211812467 | 0.1316937837759732
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 | 54920.18772375539 | 56448.61654810751 | 58019.58154664134 |  |  |  | 0.02783 | 0.02783
LT/EMT | 2 | LT/EMT2 | 56638.96991875804 | 58215.23245159708 | 59835.36237072503 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 3 | LT/EMT3 | 58411.54312133549 | 60037.13636640226 | 61707.96987147924 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 4 | LT/EMT4 | 60239.59077486081 | 61916.05858612519 | 63639.18249657705 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 5 | LT/EMT5 | 62124.84900775085 | 63853.78355563656 | 65630.83435198992 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 6 | LT/EMT6 | 64069.10828229743 | 65852.15156579376 | 67684.8169438698 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 7 | LT/EMT7 | 66074.21509510021 | 67913.06050119684 | 69803.08097494514 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 8 | LT/EMT8 | 68142.07373071647 | 70038.4676426423 | 71987.63819713703 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 9 | LT/EMT9 | 70274.64807019297 | 72230.39152598643 | 74240.56332215463 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 10 | LT/EMT10 | 72473.96345619773 | 74490.9138591837 | 76563.99599188479 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 11 | LT/EMT11 | 74742.10861652289 | 76822.18149932071 | 78960.14281044682 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
LT/EMT | 12 | LT/EMT12 | 77081.23764778559 | 79226.40849152344 | 81431.27943984256 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
 | Top Out | 0.025 | 79008.26858898022 | 81207.06870381153 | 83467.06142583862 | 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 | 61116.20983646283 | 62817.07395621159 | 64565.27312441295 |  |  |  | 0.02783 | 0.02783 | LT/PM | 1 | 6196.022112707433 | 0.1128186623081658 | 6368.457408104077 | 0.1128186623081657 | 6545.691577771613 | 0.1128186623081657
LT/PM | 2 | LT/PM2 | 63028.90212834267 | 64782.99647457444 | 66585.90726646184 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 2 | 6389.932209584629 | 0.1128186515176783 | 6567.764022977361 | 0.1128186515176782 | 6750.544895736813 | 0.112818651517678
LT/PM | 3 | LT/PM3 | 65001.45401906226 | 66810.44448441276 | 68669.77915441396 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 3 | 6589.910897726775 | 0.112818640727191 | 6773.308118010493 | 0.1128186407271907 | 6961.809282934722 | 0.1128186407271907
LT/PM | 4 | LT/PM4 | 67035.73887402829 | 68901.3434868925 | 70818.8678761327 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 4 | 6796.148099167483 | 0.1128186299367036 | 6985.284900767307 | 0.1128186299367034 | 7179.685379555653 | 0.1128186299367033
LT/PM | 5 | LT/PM5 | 69133.68868747249 | 71057.67924364484 | 73035.21445699547 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 5 | 7008.839679721634 | 0.1128186191462162 | 7203.895688008284 | 0.1128186191462162 | 7404.380105005548 | 0.1128186191462161
LT/PM | 6 | LT/PM6 | 71297.29591729875 | 73281.49966267716 | 75320.92379828946 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 6 | 7228.187635001319 | 0.1128186083557292 | 7429.348096883405 | 0.1128186083557292 | 7636.106854419661 | 0.1128186083557291
LT/PM | 7 | LT/PM7 | 73528.61537735356 | 75574.91674330531 | 77678.16667627149 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 7 | 7454.400282253351 | 0.112818597565242 | 7661.856242108464 | 0.1128185975652421 | 7875.085701326345 | 0.1128185975652421
LT/PM | 8 | LT/PM8 | 75829.76618891707 | 77940.10858195463 | 80109.18180379042 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 8 | 7687.692458200603 | 0.1128185867747552 | 7901.640939312332 | 0.1128185867747553 | 8121.543606653388 | 0.1128185867747552
LT/PM | 9 | LT/PM9 | 78202.93379326776 | 80379.32144073439 | 82616.27795643003 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 9 | 7928.28572307479 | 0.1128185759842685 | 8148.929914747961 | 0.1128185759842685 | 8375.714634275399 | 0.1128185759842685
LT/PM | 10 | LT/PM10 | 80650.37202723253 | 82894.8718807504 | 85201.83616519168 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 10 | 8176.408571034801 | 0.1128185651937818 | 8403.958021566708 | 0.1128185651937819 | 8637.84017330689 | 0.1128185651937816
LT/PM | 11 | LT/PM11 | 83174.40526369307 | 85489.14896218164 | 87868.31197779915 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 11 | 8432.29664717018 | 0.1128185544032951 | 8666.967462860935 | 0.1128185544032953 | 8908.169167352331 | 0.1128185544032949
LT/PM | 12 | LT/PM12 | 85777.43061908156 | 88164.6165132106 | 90618.23779077323 | 0.03129599 | 0.03129599 | 0.03129599 | 0.02783 | 0.02783 | LT/PM | 12 | 8696.192971295968 | 0.1128185436128087 | 8938.208021687155 | 0.1128185436128089 | 9186.958350930669 | 0.1128185436128084
 | Top Out | 0.025 | 87921.8663845586 | 90368.73192604085 | 92883.69373554256 | 0.025 | 0.025 | 0.025 | 0.02783 | 0.02783 |  | Top Out | 8913.597795578375 | 0.1128185436128088 | 9161.663222229326 | 0.1128185436128089 | 9416.632309703942 | 0.1128185436128085
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 | 67426.4765713801 | 69302.95541436161 | 71231.6566635433 |  |  |  | 0.02783 | 0.02783
BC | 2 | BC2 | 69536.65558215801 | 71471.86070700947 | 73460.92259048554 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 3 | BC3 | 71712.87475525723 | 73708.64405969605 | 75759.95562387738 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 4 | BC4 | 73957.20088359776 | 76015.4297841883 | 78130.93919508225 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 5 | BC5 | 76271.76544245084 | 78394.40867471426 | 80576.12506813154 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 6 | BC6 | 78658.76661373778 | 80847.84008859811 | 83097.83547826379 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 7 | BC7 | 81120.47137368131 | 83378.05409201088 | 85698.46533739154 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 8 | BC8 | 83659.21764579204 | 85987.45367287444 | 88380.48450859054 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 9 | BC9 | 86277.41652123476 | 88678.51702302071 | 91146.44015177138 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 10 | BC10 | 88977.55454868331 | 91453.79989177317 | 93998.95914276122 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 11 | BC11 | 91762.19609583891 | 94315.93801318611 | 96940.75056809308 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
BC | 12 | BC12 | 94633.98578485429 | 97267.64960924679 | 99974.60829787212 | 0.031296 | 0.031296 | 0.031296 | 0.02783 | 0.02783
 | Top Out | 0.025 | 96999.83542947564 | 99699.34084947796 | 102473.9735053189 | 0.025 | 0.025 | 0.025 | 0.02783 | 0.02783