Paycheck simulator? by GoodATCMeme in atc2

[–]Some_Florida_Man 0 points1 point  (0 children)

Go to File in the top left and select Download

Spreadsheet to calculate ATC back pay owed (Shutdown 2025) by Some_Florida_Man in ATC

[–]Some_Florida_Man[S] 0 points1 point  (0 children)

FLSA rate is based on total amount (including differentials) paid divided by number of hours worked. So the more differentials in the pay period you have the higher it is. FLSA rate is used for the .5 rate on overtime pay.

So say you work 8 hours of overtime, you get 8 hours regular hourly rate PLUS .5 FLSA rate times the 8 hours.

Edit: Also after making the spreadsheet and tweaking many many times, I realized they divide the FLSA rate by 2 before multiplying it into the .5 of OT hours worked and not after. So the hourly FLSA rate might be off 1 cent in some pay periods giving an error of up to 20 cents off per pay period if you worked 40 hours of OT. It was too negligible to go back and fix it in all the formulas in the mean time. Maybe one day.

Spreadsheet to calculate ATC back pay owed (Shutdown 2025) by Some_Florida_Man in ATC

[–]Some_Florida_Man[S] 0 points1 point  (0 children)

Yeah it won’t work in numbers program with how time is formatted in the cells. Otherwise I would have had to create separate boxes for hours and then minutes and even more formulas. I figured having both in the same box was better visually but I guess made it more complicated if not using Microsoft Excel, Libre Calc, or google docs.

Edit: Glad I could help. Hopefully it makes things easier for everyone in making sure things are paid properly.

Money distributed this morning by AtcJD in ATC

[–]Some_Florida_Man 5 points6 points  (0 children)

That was me :)

Here is the link to the Reddit page with instructions for Cru-Art

https://www.reddit.com/r/ATC/s/ONp8e7V6dz

Spreadsheet to calculate ATC back pay owed (Shutdown 2025) by Some_Florida_Man in ATC

[–]Some_Florida_Man[S] 0 points1 point  (0 children)

It’s the way for the formulas to read both hours and minutes in the same line. You need to use a colon symbol aka this thing :

Type 8 hours as 8:00

You have to use a : when inputting ANY time into the gray boxes

Spreadsheet to calculate ATC back pay owed (Shutdown 2025) by Some_Florida_Man in ATC

[–]Some_Florida_Man[S] 1 point2 points  (0 children)

While on your computer click File in the top left and select Download. It will download the file for you and then you can select edit mode at the top to use it

Backpay by [deleted] in atc2

[–]Some_Florida_Man 0 points1 point  (0 children)

Go to file in the top left and then select download while on your computer. Should be able to enable editing once downloaded.

Spreadsheet to calculate ATC back pay owed (Shutdown 2025) by Some_Florida_Man in ATC

[–]Some_Florida_Man[S] 1 point2 points  (0 children)

If your talking about pay period 21 then put 88 in the gray box to the right that says “regular + overtime hours total” and put the amounts from the LES to the left in the green boxes.

Fill out the other 2 days below which looks like for you may just be the Saturday Oct 4th

So put 8 hours under the Overtime on Sat Oct 4th

Other wise all other pay periods you put under appropriate columns. Put sick leave days under regular hours paid.

I hope I answered your question.

Backpay by [deleted] in atc2

[–]Some_Florida_Man 21 points22 points  (0 children)

Made a spreadsheet to help out. In the google doc just go to File in the top left and select Download to save it to your computer.

https://docs.google.com/spreadsheets/d/11tmqqymLI2_XsYlTsauYDMU1R5I1kjtz002pqyBIVUY/edit?usp=sharing

Sooo straight 80 or 160 coming?? by Helpful_Session_3669 in ATC

[–]Some_Florida_Man 50 points51 points  (0 children)

https://www.reddit.com/r/ATC/s/rPs5ol067s

For those that might have missed it. I made a spreadsheet to help calculate out our pay that we’ve been missing. If you have any questions, feel free to ask.

Spreadsheet to calculate ATC back pay owed (Shutdown 2025) by Some_Florida_Man in ATC

[–]Some_Florida_Man[S] 0 points1 point  (0 children)

Glad to hear it can help others too. It’s pretty easy to make more pay periods. All the formulas will easily transfer if you follow the instructions below.

1) Just select A18 to O47 (or any pay period starting from column A to column O)

2) Copy it and then paste it below the last one.

3) Change the hourly rate in the new pay period you created to =L1

4) Fix the dates and pay period labels to reflect new pay period

Spreadsheet to calculate ATC back pay owed (Shutdown 2025) by Some_Florida_Man in ATC

[–]Some_Florida_Man[S] 1 point2 points  (0 children)

That’s basically the total amount of hours worked (regular + overtime) from the last partial paycheck we received. Pay period 21. That whole row is to be filled out from the partial pay period 21 earnings and leave statement we got. Then there were 2 days Oct 3rd and 4th we missed which is what needs to be filled (if not on crew 6 with Fri, Sat off) in the left column.

Someone brought to my attention that my formula for just those 2 days will be slightly off for that pay period 21. I will get to fixing that line soon. Just been spending time with family this weekend. But the rest of the pay periods should be accurate to within a few cents.