Linked In profile

Flight Plan

Translate a Delta flight plan

Delta iCrew Version compared with my version

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.

Some stats and example route extracts

Count of unique release numbers translated      Example routes

iCrew version of the html flight plan.

There is a new version of the html flight plan that is now in testing. Not that I am not interested, but it is too late for me to act on any feedback that you might. If you want to see what is coming, translate an example, etc, I have more information here:

Analysis for 1/25/2019 AE award

Disclaimer: This analysis is something that I have done on my own and neither ALPA or Delta have any responsibility for its accuracy.

This is a "light" version in that I do not have the part where you can input your employee number and see your new seniority analysis. To generate that analysis, it requires me to correlate the current seniority list, the projected category list, and the AE award. I plan on resuming this feature for future bids.

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) 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.

PDF summary

Online interactive version:

You warning that you do not have access and must request it. I will not grant access because it might corrupt the data. If this does not work, use the link above.

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 to the Excel file.

HTML Calculators in Content Locker/Offline tools for the iPad

I have several tools/calculators that are simply web pages with JavaScript. These could be used in a document library such as Content Locker.

If you just want to use the tools, go here: John Bell Tools

If you want to load some of the files into Content Locker to demonstrate the concept, go here: JavaScript calculator demo.

IR Cloud Tops

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

Pairing Summaries

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

PBS and Scheduling Tools

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 Excel
Reserve Pay Calculator:
HTML version of the Reserve Pay Calculator optimized for the iPad. note: This should work on any computer.

PBS Reserve Pay Excel Spreadsheet
Online version of the Reserve Pay Excel Spreadsheet
Reserve Line Simulator
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.

PBS reserve line simulator in Excel
Online version of PBS Reserve simulator
iPad 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.
Pairing Formats:
Test format translation for rotation display
Test format to convert rotation to .ics file

HTML Flash Cards

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.


Regatta Stuff

timer link


Create cached test page