Hello,
My name is Billy, I am new here to the forum.
I am a total newb to excel, I have used it in a limited way in the past for keeping track of inventory as well as keeping track of grades and such for students.
I am now working as a part 121 cargo pilot and would like to use it to keep track of rest rule requirements to make sure that I am legal to fly per the Federal Aviation Regulations.
Below are the Federal rules that I am dealing with...
Sec. 121.503 — Flight time limitations: Pilots: airplanes.
(a) A certificate holder conducting supplemental operations may schedule a pilot to fly in an airplane for eight hours or less during any 24 consecutive hours without a rest period during those eight hours.
(b) Each pilot who has flown more than eight hours during any 24 consecutive hours must be given at least 16 hours of rest before being assigned to any duty with the certificate holder.
(c) Each certificate holder conducting supplemental operations shall relieve each pilot from all duty for at least 24 consecutive hours at least once during any seven consecutive days.
(d) No pilot may fly as a crewmember in air transportation more than 100 hours during any 30 consecutive days.
(e) No pilot may fly as a crewmember in air transportation more than 1,000 hours during any calendar year.
Sec. 121.505 — Flight time limitations: Two pilot crews: airplanes.
(a) If a certificate holder conducting supplemental operations schedules a pilot to fly more than eight hours during any 24 consecutive hours, it shall give him an intervening rest period at or before the end of eight scheduled hours of flight duty. This rest period must be at least twice the number of hours flown since the preceding rest period, but not less than eight hours. The certificate holder conducting supplemental operations shall relieve that pilot of all duty with it during that rest period.
(b) No pilot of an airplane that has a crew of two pilots may be on duty for more than 16 hours during any 24 consecutive hours.
Now, does anyone have any idea the best way to program a worksheet to keep track of rolling 24 hours periods? Or Rolling 30 day periods? Or finally, how to get it to automatically double "the number of hours flown since the preceding rest period, but not less than eight hours?"
It's a tall ask I know. Any guidance would be appreciated.
Thanks everyone!
Billy
Bookmarks