Linked In profile

Flight Plan

Translate a Delta flight plan

Delta 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

Help test the next iCrew version of the html flight plan.

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

Analysis for 11/19/2018 AE award

Latest data: The projected category list based on the award.

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,, and check it out.

The AE analysis

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.

PDF summary

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.

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