Show me the money spreadsheet

[DB.Cooper]

For DB.
All numbers are rounded up. If you would like to unprotect sheet, password is Rural.
Through current payperiod backpay for Table 1 Step 12 46K would be 1692 total.
Lmk if any problems with math.

I just checked out my $80k+ new online PP16 paystub.... js.... SHOW ME THE MONEY $$$$$ !!!!!!!!!!!

 

[Voglio-il mio]

For DB.
All numbers are rounded up. If you would like to unprotect sheet, password is Rural.
Through current payperiod backpay for Table 1 Step 12 46K would be 1692 total.
Lmk if any problems with math.

I was just trying your spread sheet but I'm not sure of what to pug in on line labeled.

Effective Back Pay Pay Period

Should that PP #16?

 

[FrozenToes]

I was just trying your spread sheet but I'm not sure of what to pug in on line labeled.

Effective Back Pay Pay Period

Should that PP #16?

Yes to 16. But I'm not sure if I have the weeks right. Have an updated one at home.

 

[FrozenToes]

I was just trying your spread sheet but I'm not sure of what to pug in on line labeled.

Effective Back Pay Pay Period

Should that PP #16?

Updated spreadsheet.
Password is Rural.
A majority of numbers are rounded. So it could be off a few bucks.
Need your salary from 2021.
DACA numbers are if 100% of the days are either 5 or 3.
Let me know if any math problems.

 

[Voglio-il mio]

Thanks, just getting back to this now.
Have you eliminated the Effective Back Pay Period Entry from the updated spread sheet?

 

[FrozenToes]

Thanks, just getting back to this now.
Have you eliminated the Effective Back Pay Period Entry from the updated spread sheet?

Yes.
Also, as before, the spreadsheet doesn't account for step increases, extra pay ( ie. second trips) or any overtime besides Daca 3 and 5.

 

[Voglio-il mio]

Thanks again "Frozen Toes"

Your spread sheet gives me about $500 more than what I had estimated.

 

[mail1000]

Updated spreadsheet.
Password is Rural.
A majority of numbers are rounded. So it could be off a few bucks.
Need your salary from 2021.
DACA numbers are if 100% of the days are either 5 or 3.
Let me know if any math problems.

I humbly THANK YOU for doing this...the time and effort you put in is much appreciated!

 

[FrozenToes]

Update.
I just realized DACA pay is calculated for only K routes.
Apologies.

 

[LLVnoise]

For DB.
All numbers are rounded up. If you would like to unprotect sheet, password is Rural.
Through current payperiod backpay for Table 1 Step 12 46K would be 1692 total.
Lmk if any problems with math.

Just ran my numbers. The math gets a little fuzzy because I have a total of 24 relief days worked and some are daca 3 and most are daca 5. In the end the math is around $7,771. What would you bet the union will give us a back pay date at the convention as a way of telling us they are actually working hard. What a joke.

 

[FrozenToes]

Just ran my numbers. The math gets a little fuzzy because I have a total of 24 relief days worked and some are daca 3 and most are daca 5. In the end the math is around $7,771. What would you bet the union will give us a back pay date at the convention as a way of telling us they are actually working hard. What a joke.

You sure? I'm Table 1, Top Step, 46K. Worked 30 Daca 5.
Just over $4000.

 

[LLVnoise]

You sure? I'm Table 1, Top Step, 46K. Worked 30 Daca 5.
Just over $4000.

You know what. I added the total back pay and total annual raise. Is that not what I should of done?

 

[FrozenToes]

You know what. I added the total back pay and total annual raise. Is that not what I should of done?

No. Just backpay and the DACA total you choose.

 

[MAStew]

What about back COLAs?

 

[FrozenToes]

What about back COLAs?

The spreadsheet has the 2 COLAs and 1 General Wage Increase.

 

[DB.Cooper]

Just ran my numbers. The math gets a little fuzzy because I have a total of 24 relief days worked and some are daca 3 and most are daca 5. In the end the math is around $7,771. What would you bet the union will give us a back pay date at the convention as a way of telling us they are actually working hard. What a joke.

Almost $8K..... js.... SHOW YOU THE $$$$$ MONEY!!!!! $$$$$$$$

 

[FrozenToes]

Almost $8K..... js.... SHOW YOU THE $$$$$ MONEY!!!!! $$$$$$$$

I believe that number not to be accurate. Added the annual raise to the back pay figure.

 

[DB.Cooper]

I believe that number not to be accurate. Added the annual raise to the back pay figure.

Still, as I was looking thru the thread, I saw some guy named DB gloating about seeing his salary go above $80k just back in August..... now he's up over $86k.... js.... how can peeps not like seeing this past contract passed.... largest raises I've seen in my over 20 years at the good ole gravy train USPS....

 

[lbpd16]

I want to use the spreadsheet but on 2/27/2021 I was still a RCA. I did not convert until 9/11/21. My route was at a 43K on paper at that time. It was found to actually be way over a 48K in november of 2021. So trying to use the spreadsheet with all these different factors is a bit confusing.

Anyone have any idea what I should input? I don't expect an exact number but just want an idea as to what to expect.

Thanks

 

[RuralConfusion22]

I want to use the spreadsheet but on 2/27/2021 I was still a RCA. I did not convert until 9/11/21. My route was at a 43K on paper at that time. It was found to actually be way over a 48K in november of 2021. So trying to use the spreadsheet with all these different factors is a bit confusing.

Anyone have any idea what I should input? I don't expect an exact number but just want an idea as to what to expect.

Thanks

Set your expectations low and you maybe pleasantly surprised.. I was a 48k the whole time so I'm expecting close to 3K ish...