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: http://johnfbell.com/iCrewFP_code_test.html.

AE awards and Projected categories

Disclaimer: This analysis is something that I have done on my own and neither ALPA or Delta have any responsibility for its accuracy.
Note: I have links that are published publically. However, you must sign into DeltaNet to see the actual information.

Overview:

The award analysis becomes stale data once Delta publishes the projected category list based on the latest award. The projected category list is where Delta expects things to shake out as a result of the award. This is what you want to reference for planning to bid the next AE.

The AE award analysis is meant to see how the latest award will impact you. Think of it as my projection of the what the projected category list will look like before the projected category list is produced. I still leave the latest one up because it also has some additional information such as where pilots have come from and gone to and some other analysis that might be interesting.

Other sources of analysis:

You might also consider two more detailed sources of analysis.

Delta ALPA Pilot Dashboard This is generally updated to reflect the latest projected category list and there is some lag after the award due to the wait for the projected category list. However, this offers more detailed analysis than my Excel version of the projected list.

Curly Culp's Widget Seniority Curly usually updates his site quickly after the award and has a lot of detailed information.

Information on view in browser version:

You can download the Excel file or you can view the file in your browser if you do not have Excel or do not want to download he file. The option to web version will not always work, but I have not figured out why. The trick to this web version appears to be to log into DeltaNet first and then click on the link. I will ignore any requests to share the file. It is not that I do not want you to have the information. The problem is that if I share it so that you can edit it online, you can also corrupt it.

 iPad note: Assuming that you can get to the file, this web version 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.

The files

Projected Category List 01AUG19 AS OF 08FEB19. This is based on the 1/25/2019 award

Online version of the Projected Category List

View only version of the Excel file. Download this file to use it.

Analysis for 1/25/2019 AE award

This was a small bid and I just did a "lite" version of the analysis.

View only version of the Excel file. Download this file to use it.

PDF summary

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 http://pbshelp.info/delta.

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.

Rowing

Regatta Stuff

timer link

Other

Create cached test page