Reserve Pay Calculator

version: 1.0 c: 10/08/2018

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

thejohnbell@gmail.com.

Pay

Bid Month
Year (only needed for Feb to check leap 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 portion of the reserve guarantee
 
Days Daily
Credit
Credit
Normal reserve guarantee with no adjustments
Vacation days 3:30 + 0:00
CQ and Recency Training 4:00 + 0:00
Training or other Activity based on pro-rated ALV + 0:00
Unpaid leave 0:00 + 0:00
Other (hmm for daily credit) + 0:00
Other (hmm for daily credit) + 0:00
Pro rata reduction - 0:00
Total
 
Carry In Credit (hhmm)
C27 Adjusted reserve guarantee
Credit over guarantee +
Total
 

Days

Days of availability for 12.N
X days
On Call days
Maximum Short Call Days
 

Notes

Updates