2012 Pay Scale Calculator

MetroStateCTI · Posted: 08-06-2012, 04:15 PM

As a non elite member I couldn't access the pay scale calculator provided on this site so I thought I would make a quick rough copy version for those having the same problem. I will update as soon as the 2013 Pay Band comes out. Insert the locality percentage in cell B22 (ei: 22.52), and press enter then the "calculate" button and it will generate the 2012 Pay Band including locality pay. Let me know of any issues.

***Edit: If the calculate button isn't working, you need to enable macros. Hit the office button, Excel Options, Trust Center, Trust Center Settings, Macro Settings, Enable all macros.

Also, the AG row has been corrected from $37k to $37,070. New file has been uploaded.

ATC_Bound · Posted: 08-06-2012, 04:20 PM

Oh the day I make CPC will be a great day.

MetroStateCTI · Posted: 08-06-2012, 05:08 PM

Quote:

Originally Posted by ATC_Bound

Oh the day I make CPC will be a great day.

Glad it works. The day I get my FOL will be a great day. Keep me updated if you hear anything.

Genot · Posted: 08-06-2012, 06:11 PM

Quote:

Originally Posted by BSHATC01

How does the whole min / max thing work? I would assume you would start at the bottom once you begin the final step of becoming cpc, but does it then at that point take several years of progression to reach the max or is this attained once fully certified? I guess my real question is how long does it take to hit the top of the scale?

Depends. How much are your raises each year? We could get a 0.6% raise every year from now till everyone on this site is retired. We could end up getting 5% raises every year for a decade. We could go back to the SCI and OSCI formula or whatever it was called under the IWRs, so my answer may be different than your answer.

Unless you have a crystal ball and can predict how Congress and the President as well as the FAA and NATCA are going to allow/negotiate/suspend/halt/freeze/change rating systems throughout your career, nobody anywhere knows.

Of course if you get a double downgrade, you'll hit the top of your new payband pretty freaking fast.

Short answer, between 2 years (save pay post downgrade) and never.

N813JB · Posted: 08-06-2012, 07:03 PM

Quote:

Originally Posted by MetroStateCTI

As a non elite member I couldn't access the pay scale calculator provided on this site so I thought I would make a quick rough copy version for those having the same problem. I will update as soon as the 2013 Pay Band comes out. Insert the locality percentage in cell B22 (ei: 22.52), and press enter then the "calculate" button and it will generate the 2012 Pay Band including locality pay. Let me know of any issues.

AG is still $37,070 for 2012.

MetroStateCTI · Posted: 08-07-2012, 09:27 AM

Quote:

Originally Posted by N813JB

AG is still $37,070 for 2012.

Thanks, fixed.

BOILER_UP · Posted: 08-07-2012, 09:34 AM

Quote:

Originally Posted by N813JB

AG is still $37,070 for 2012.

Better not make this mistake when looking at call signs! Haha! I'm kidding man. Thanks for building the calculator.

PapaEchoBravo · Posted: 08-07-2012, 09:43 AM

How is COLA figured into this?

CharT · Posted: 08-07-2012, 11:16 AM

I don't know what's wrong with mine. I followed the directions correctly (with enabled macros), yet right after I hit calculate, I get a new 2012 (including locality pay) pay band right underneath it that shows nothing but a bunch of #REF! everywhere where a $ value should be.

MetroStateCTI · Posted: 08-07-2012, 11:35 AM

Quote:

Originally Posted by CharT

I don't know what's wrong with mine. I followed the directions correctly (with enabled macros), yet right after I hit calculate, I get a new 2012 (including locality pay) pay band right underneath it that shows nothing but a bunch of #REF! everywhere where a $ value should be.

PM me your email and I'll send you the unzipped excel file.