Delta uses a version of this in iCrew labeled the "html" flight plan. My version has a couple of more bells and whistles and Delta's version is easier to create.
Count of unique release numbers translated Example routes
This is a bit of a pain in the neck to use. However, it is only meant for testing. If you want to convert a couple of flight plans using the latest code that I have given to Delta and test the translation out, go to http://johnfbell.com/iCrewFP_code_test.html.
The fresher data is the projected category list based on the AE which is now out in Deltanet. I no longer publish an analysis of the projected category list because ALPA now has its "Pilot Dashboard" based on this data. It will tell you where you can expect to be on different equipment and bases. I highly encourage you to check it out. Log into the ALPA website, https://www.alpa.org/dal, and check it out.
Disclaimer: This analysis is something that I have done on my own and neither ALPA or Delta have any responsibility for its accuracy.
Note that these links will require you to sign into Deltanet and are not available publicly. The online interactive version (last link in this section) allows you to see an analysis online by entering your employee number. It works in the browser instead of needing to download the Excel file. If this doesn't work for you, you will need to download the Excel file. Also note that the Surface and lounge computers do not have Excel, but Excel reader. Excel reader will allow you to view the file, but not to make changes such as entering your employee number.
View only version of the Excel file. Download this file to use it.
Online interactive version:
You should be able to enter your employee number into this version and it should give you a personalized analysis. The problem is that you may get a warning that you do not have access and must request it. The trick appears to be to log into Deltanet first and then click on the link below. iPad note: Assuming that you can get to the file, this will work. You have to play around with tapping in the Employee Number input box and tap just right. I have found a double tap where the second tap is held tends to work.
1. Log into Deltanet
2. Online interactive version of the Excel spreadsheet. If you cannot get access, use the first link.
If you just want to use the tools, go here: John Bell Tools
Delta has Cloud Tops in the iOS version of the weather viewer. I think this is a big deal that not a lot of pilots know about. This is especially a big deal where there is no radar coverage. I have brief overview:
Using IR Cloud Tops.pdf
Link to Pairings Summaries
Note that the above link will require you to sign into Deltanet and the files are not available publicly. While I am flattered by the fact that many people find these useful, I would highly encourage that you learn about the analysis tool in the PBS Web App. More details are available in the PBS Gouge or the YouTube videos produced by the PBS Committee. Both are linked from http://pbshelp.info/delta.
FAR 117 calculator in Excel. This uses a copy and paste of the pairings from iCrew to calculate some of the FAR 117 cumulative parameters.FAR 117 calculator in ExcelReserve Pay Calculator:HTML version of the Reserve Pay Calculator optimized for the iPad. note: This should work on any computer.Reserve Line Simulator
PBS Reserve Pay Excel Spreadsheet
Online version of the Reserve Pay Excel Spreadsheet
This is a tool that allows you to switch days from X to R and see how many work days you have used in a row, X day blocks, etc. This was created to help answer e-mails with reserve questions. This may not cover every scenario and is offered on a use at your own risk basis. enario and is offered on a use at your own risk basis.Pairing Formats:
PBS reserve line simulator in Excel
Online version of PBS Reserve simulatoriPad notes:
- If you have Office 365 with Excel on your iPad: Use the normal link. Use the square with an arrow comming out icon near the URL window to send the file to Excel.
- If you do not have OneDrive or Office 365: Use the "online" link. This should work in Safari. However, selecting cells with pull down menus such as the month can be problematic. I find the trick is to do a double tap, but continue to hold your finger down on the second tap until the menu appears.
- If you have OneDrive installed, but do not have Office 365: I have not found a good solution other than to find another device or computer.Test format translation for rotation display
Test format to convert rotation to .ics file
I have an Excel workbook that allows you to create flash cards in an html format. I have an example below of for 777 Memory and Limitations. I also have an example as well as a blank version of the Excel file so that you can create your own.
777 html flash cards
Blank version of Workbook
Version of Workbook with 777 questions as an example.
Create cached test page