Windows (including Surface):
You will need to download this file and open it from your computer. This is due to restrictions, which I vehemently disagree with, imposed by Delta Cybersecurity.
Due to this file opening the output in another tab, there is no practical way of using this. I have another version on www.johnfbell.com that puts the output into the same page so that you can use it in Adobe Reader or GoodReader in a manner similar to the html flight plan.
This is started as a way to capture a total block and minutes under for Standards pilots. However, I kept on adding a some more things. Pilot pay is complex and not one of my primary interests. I might miss some things, but hopefully this is useful. Let me know if you find any issues: firstname.lastname@example.org.
Copy the entire rotation from iCrew and paste it into the box. Both of these procedures will copy a bunch of extra text. Don't worry about it, this code will ignore it.
This will extract the block and M/U for each leg and get a total for the rotation. I will pre-selected "L" legs to be included as standard pay. However, if a leg should be included that I have not flagged or vice versa, change the checked box and the totals will change.
The sums are at the top of the pairing in the same line as EFFECTIVE. There is also a summary at the top of the page.
The credit for the trip is simply the total value minus the total block including minutes under. The rate is at the rate for the last non-deadhead leg. PWA12.L.2 note). I caclualte this.
Deadhead legs pay at the rate of the next non-deadhead leg, unless the deadhead is the last leg, in which case the deadhead leg will pay at the rate of the previous non-deadhead leg. PWA 8.A.1. This must be manually selected.
I do not have an easy way of deciding which legs qualify for international override so I set the default to checked if the block is over 8:00. You will probably need to adjust a few of these.
The credit value is derived by taking the total value of the trip and subtracting the block plus minutes under.
1. You can examine the code yourself by saving the file and opening it in a text editor such as Notepad.
2. Link to a more detailed explanation on my Delta One Drive account.
I really do not offer any support. However, if you have any comments or problems, look me up in iCrew. John Bell
|2023/07/19||Fixed to work on pairings with no line check legs.|
|2023/07/03||Added logic so that credit pay rate is based on the last non-deadhead pay rate (12.L.2 note).|
|2023/07/02||Added logic so that an "L" carries forward to the next leg with the same flight number.|
|2023/07/01||Added Pay rate line.|
|2023/07/01||Fixed issue with some pay being one row off. I had eliminated 787 in one list but not the other.|
|2023/07/01||Fixed standards pay to use 350 FO table if FO selected. I forgot to figure LVP pilots.|
|2023/07/01||Fixed MU not being added correctly.|