Reserve Pay Calculator

version: 1.0l: 06/07/2023

Use this at your own risk. However, let me know if you find any errors so that I can fix them.

Pay

Bid Month

Year

Bid month dates

---

Days in the month

ALV (hhmm)

Extra X day for 20% reserve staffing

Normal reserve guarantee with no adjustments:

Pro rata portion of the ALV

Pro rata portion of the reserve guarantee

Pro rata share

note: Reserve pro rata share is the value of a dropped reserve day.

Days

Daily
Credit

Credit

Normal reserve guarantee with no adjustments

Vacation days

0:00

Qual training

3:05

0:00

Parental Leave (Pre-Posted)

0:00

Activity based on pro-rated ALV

0:00

Unpaid leave

0:00

Other (hmm for daily credit)

0:00

Other (hmm for daily credit)

0:00

Pro rata reduction

0:00

Total

Additional Overrride (hmm for daily credit)

0:00

Total

Carry In Credit (hhmm)

C27 Adjusted reserve guarantee

Credit over guarantee

Total

Days

Days of availability for 12.M

X days

On Call days

Maximum Short Call Days

Post PBS Award Calculations (Drop, IVD, Parental Leave)

Number of reserve days dropped

0:00

Number of replacement days

0:00

Total

Notes

All time inputs support are hmm or hhmm. In iOS entering h:mm or h:mm is like entering 0. I do not like the inconsistency of not having h:mm or hh:mm, but I did this so that the keyboard with the numbers row comes up in iOS.
Rounding: I show hh:mm, but I use the full unrounded values behind the scenes. This might cause slightly strange looking results. For example 5 days at 2:00 might show as 10:02 because the calculation is really 5 * 2:00:29 = 10:02:25. I don't know where the company does the rounding, but the differences should be small if any.
ALPP days are treated as on call days for the purposes of pay calculation. For example, if this sheet calculates that you have 17 on call days and you have 2 ALPP days, 2 of the on call days would be taken by ALPP and PBS would have to place 15 more. However, ALPP days do not count as work when calculating the work block length for reserve line construction rules. For example: RES RES ALPP ALPP is a two day work block not a four day work block.
Drop: After PBS, On Call Days are valued at the reserve pro-rata share value (PWA 14.A.11) which is the reserve guarantee divided by the number of on call days in the month without correcting for absences. Thus ML, PD, APDs, SK days that overlap a reserve on call day will deduct this value for each day from the guarantee.
Carry in: Carry in pairing days are treated as on call days with flying already assigned. For example, if this sheet calculates that you have 17 on call days and you have 3 carry in pairing days, those 3 carry in days count as on call and PBS would have to give you 14 more on call days when building your line. They have no effect on your pay unless the carry in credit exceeds the guarantee.
IVD: Drop the number of IVD days and replace them with the same number of days at the vacation pay rate. Make sure that you enter both the number of days dropped and the number of days at 4:00.
Standards Meetings: Use one of the "Other" entries at 5:00 for each meeting day as well as for each travel day.
Parental Leave (Pre-Posted only): The calculations in this calculator only apply to pre-posted parental leave.

Disclaimer

Use this at your own risk.
I am not a reserve pay expert, so do not use this as evidence of what you should get paid.
I do not want to put out bad info, so please let me know if you find and error! thejohnbell@gmail.com

Updates

2024/06/07 Added override.

2023/12/02 Updated Parental leave value for April of 2024 and 2025.

2023/12/02 Updated CQ value for Jan 2024.

2023/12/02 Updated vacations to reflect changes in April of 2024 and 2025.

2023/11/05 Changed - to a + in replacement days and added display of daily vacation value.

2023/09/26 I added pre-paid Parental Leave back in.

2023/09/08 Removed Parentl Leave instructions until I can properly model it.

2023/09/08 I combined the logic of IVD and drop. You can drop days and have a seperate input to allow replacement days. This allows the two lines to work for IVD, drop, and Parental Leave.

2023/08/21 Fixed )ther input to jump to daily credit after entering days instead of attempting to calculate and creating an error.

2023/07/21 Added post PBS run calculations for IVD and drop.

2023/03/05 Fixed qual training. TA incorrectly had pro-rate, but PWA has 3:05.

2023/03/03 Fixed short call table.

2023/03/01 Changed vacation day to 4:00 and CQ to 4:15.

2020/08/11 Changed PWA X day table reference from 12N to 12M.

2019/09/30 Took recency out of CQ section.

2019/04/15 Fixed label on 330 vacation.

2019/02/27 Updated to work with VAC of 345 and 330.

2018/10/08 Added note that carry in days count as on call days.

2018/10/06 Created error message when entering less than 4 digits for ALV.