Translating the flight plan

Step 0: Donate to the UCF AIAA Rocket League

University of Central Florida Rocket League GoFundMe page

My son, James, is involved in the University of Central Florida Rocket league. The link above goes to the UCF Rocket League donation page. This is strictly voluntary and I will not be checking to see who donates and who does not. You can even check the box to donate anonymously. Anything is appreciated. I was hoping to get enough people donating the value of a beverage or two.

Step 1: Get the flight plan

Copy and paste the flight plan from iCrew into the text box below. Only use the plain text version from iCrew as opposed to the .pdf version. iCrew mobile only offers the .pdf version which will not work.

iOS note: Double tap on the rectangular map icon in iCrew, but hold on the second tap. This should highlight the whole page. The option to copy should appear at the top. In iOS 11, the copy option will appear, but may take a full minute. If the whole page highlights, just be patient.

Windows: The easiest way to is to select all of the text and then paste all of the text. The keyboard shortcuts are: ctrl-A to select all, ctrl-C to copy, ctrl-V to paste. Do not worry about the extra "junk" that you copy. The page will filter it out.

Go directly to iCrew (icrew.delta.com)

Step 2 (optional): Include Google Earth files?

Do you want to translate the flight plan into Google Earth also. This will include the kmz file in the e-mail attachment.

 

This will determine the alternate shading in Google Earth and Google Maps.

 

Other options






 (maps lat/long points, but not named points, if you include the NAT in the flight plan from iCrew)

Step 3 (optional): e-mail options

A.

B. Send copy to these email addresses. Use a semi-colon or comma for multiple addresses.

Notes:

The email usually takes a minute or two to arrive.

You can use option A, B, both, or none. Since the Surface 3 has Delta e-mail, I have an option to send the translation to each pilot in the crew list by checking the box. Using the e-mail address of <6-digit employee number>@delta.com works the same as the email address based on your name.

I am not really tracking e-mail addresses, but I see them because I bcc a copy to myself so that I can get an idea of how much this is being used and to provide some examples.

If you can't find the e-mail, check your junk/spam folder.

Step 4: Make it go

Choose your operatings system:

Run the translation by clicking the button below:

Notes:

This should take less than 10 seconds if everything works correctly and the internet connection is good, but may take up to 90 seconds. I have the cheap hosting plan. If you get an error, you may have to refresh the whole page and start over.

Step 5: View the results

The TRFP file will be returned as a download. Look at the bottom of the page. You will be able to reload it from what is usually your Download folder depending on where you save it.

Home page

In case you have been given this link directly. I have some other resources including other Surface resources on my home page.

www.johnfbell.com

More Documentation and Instructions:

I have more information as well as how to use this translation on the Surface here:

Watch the video

Disclamer:

This is not approved or endorsed by Delta Air Lines or ALPA, nor are they involved in its creation. This is my own pet project. Double check the translation and consider this is all advisory in nature. This is especially true for the TP's. While I hope that I catch them all, there is a good chance that I failed to parse one or the parsing has drawn it somewhere far, far, away.

Feedback:

My ability to execute any suggestions is probably limited by my abilities, but I would very much enjoy your feedback.

The best way: Fill in my feedback form

An equally good way: My e-mail and phone number are in DBMS. Look up Bell, J. I am listed as Bell, John Fr.

KML suffix

You should not have to set this. If you really want to know what this does, it allows you to add a suffix to the kml file. Google maps only references the first version of the file that you send. If you attempt to look at an update, Google Maps will not recongnize the update. Google Earth is not effect by this. This box allows you to add a suffix such as "version 2" so that Google Maps will recognize the change. Since I added the release number and map options if any are deselected to the file name, there is very little likelyhood this will be of any use to anybody, so I moved it to the bottom of the page out of the way.   

Updates:
01/15/2018Changed the timer and overall formating to better display on the iPad.
01/15/2018I changed the route extract algorithm a little. I now use the lat lon format for lat lon points unless there is a DCT in front or behind the point. In that case, such as some Canadian routes, I look for the corresponding waypoint name instead of using the lat long format for the point.
12/20/2017Updated alternate list.
12/06/2017Added normal alternates to crf file by creating ETP alternates at S90.0E000.0.
12/05/2017Re-arranged the note in the crosswind calculator.
12/02/2017The CRF file which is linked to or attached to the e-mail should now open the route. It only did ETOPS points before.
11/22/2017Added mag var to crosswind calculator.
11/12/2017Added kml that opens in ForeFlight (iOS) for flights with ETP Points.
11/12/2017I added QR code for ForeFlight back in having discovered that it works through the camera without another app.
11/04/2017Minor aesthetic changes to the calculators.
11/01/2017Added logic that will alert if the Weather Briefing, NOTAMS, or Company NOTAMS are not found. This adds an alert to contact me. Even if I dont find the section to add the link, the full text of the flight plan including that section will be available.
11/01/2017Added time totaler calculator.
10/31/2017Added conversion and crosswind calculator.
10/28/2017I tried to fix the e-mail.
10/25/2017Added a link to John Bell Tools.
10/25/2017Fixed issue with some of the formatting, such as a red title, on the returned file when e-mail was selected.
10/25/2017Fixed to adapt to the relabeling of NOTAMS section to Government Notams.
09/30/2017I updated the alternate data to the 8/30/2017 data.
09/30/2017I changed the D-zero timer to UTC timer. Same functionality with a new label.
09/14/2017I made the Google Earth file creation optional. This project started with Google Earth in order to visualize the flight. That was before Jepp FD. It takes up unecessary processing time and disk space. However, it is still available as an option if you like it.
08/02/2017Fixed sun time at breaks on 3 man section.
07/29/2017Added the ability to change minimum break times on 3 man section.
07/12/2017Since ForeFlight 9.2 added Jeppesen data, I changed the ForeFlight routing so that it uses the SID and STAR name instead of the corresponding waypoints from the fix list.
07/03/2017Added the angle of the sun for breaks.
06/27/2017Major re-write of break calculator to take into account Delta's 3 pilot break exemption from the FAA. I also eliminated the AA pattern option. Simply use the even beaks and skip the end of the first and third breaks.
06/17/2017Added new section in Alternates to create a list of airports along the route for the Jeppesen Trip Kit.
03/25/2017Added hyperlinks to jump back and forth between waypoints from HOWGOZIT to Times section and back.
03/25/2017Added option to open file directly. This is to accomodate iOS users.
03/18/2017I had the TRFP open directly when we were using the Surface 2 because it was hard to find and open the file. With the retirement of the Surface 2, I now have the TRFP dowload so that you can get it easily if you reboot.
03/11/2017Added Jeppesen crf file to open ETOPS points into Jepp FD.
03/08/2017Added bolder header for each airport in the NOTAMS section.
03/08/2017There is a problem in the NOTAMS within the flight plan text where a new airport does not begin on a new line. I revised my code to deal with this until it is fixed.
02/27/2017Added a test XML format.
02/27/2017Eliminated Jepp iOS and ForeFlight lat lon only route.
02/22/2017Added ETOP entry and exit points to Google Earth.
01/30/2017Fixed issue with breaks that I introduced in the last update.
01/30/2017Made Enter key work in several areas where times are entered.
Moved time before or after waypoint below breaks.
I deleted the LCL Time column. I kind of like it, but it is no longer needed with the Sun Angle.
I added the flight plan altitude at each point.
I re-arranged the columns in the time calculator.
01/05/2017I added a listing of ETP points in the route extract for flights that have them.
12/27/2016Jepp FD no longer requires "." and ".." so I eliminated them in the route translation. I also made some internal changes to better match the algorithm in the code that Delta will use if they implement a version of this flight plan.
12/27/2016I eliminated the FDP calculations from the break calculater. I don't think they are necessary anymore and I don't think anybody used them anyway.
12/18/2016I figured out how to unhighlight.
12/15/2016The flight plan started to indend the section headers by 7 places. This update fixes the links to work with the new format.
12/01/2016I added another input field for SOB calculation. I also did away with the class type labels.
11/27/2016Added logic to get terrain box alternates from Dispatcher Remarks section. These are added to the Always Include section of the alterantes.
11/19/2016Added option to send e-mail to all pilots on the crew.
11/06/2016Updated alternate data to 10/11/16 data.
10/13/2016Addded Flight Ops Alert links.
10/04/2016Fixed ETP points in Google Earth (.kmz) file.
09/30/2016Added links to the company NOTAMS section. I might better integrate or make them collapsible later when I have time.
09/28/2016I added an open route in ForeFlight link to the e-mail. I usually translate on my Surface. This link allows me to open the route in ForeFlight from e-mail on the iPad without having to download the TRFP file.
09/28/2016I removed the Clear Route Box button. If you need to process a new flight plan, refresh the page. There is a problem with a "stale" page not connecting to the server. I have not analyzed it in depth, but the problem does not seem to occur with a "fresh" page.
09/15/2016Added ForeFlight Web link in the Online Links section.
08/31/2016I did some work with the ForeFlight routing. ForeFlight 8 has global data which appears to eliminate the need to use the lat/lon only route. This generally appears to work with the web version of ForeFlight also. However, it will not work over 180 longitude yet.
08/30/2016I fixed a problem where BGSF was not showing up as an alternate.
08/26/2016If you open the page in iOS from an e-mail attachment, the Javascript and menu bar do not work without opening it into GoodReader or Offline Pages. I added some links within the warning so that it is still possible to quickly load the route into ForeFlight.
08/23/2016Made attempt to fix TPs with trop storms.
08/23/2016Fixed pax count issue.
08/16/2016Added links to SAQ videos for destination if available.
08/08/2016Add D-Zero timer.
07/26/2016Fixed summary where planned landing fuel was showing re-dispatch landing fuel.
07/22/2016Added summary section.
07/13/2016Updated FDP calculations.
07/12/2016Added alternate count and warning if no ac selected.
07/10/2016Added new alternates logic.
07/01/2016Added Deltanet Weather link.
06/23/2016Updated alternate data to 5/18/2016 data and added A321.
06/10/2016Changed order to make flight plan first.
06/10/2016Made the TOC for flight plan bigger for fat fingers.
06/08/2016Made route extract text areas read only.
06/03/2016Fixed issue where times included re-dispatch portion of HOWGOZIT.
05/28/2016Added lat/lon only ForeFlight route.
05/25/2016Added Wx Viewer backup route.
04/28/2016Added NOTOC link.
04/11/2016Fixed line feed when pasting route into Jepp FD.
03/19/2016With help from my son John Michael, I improved the highlighting code.
03/19/2016Updated JeppFD ETP route. It now adds ETPs at first point in the route.
03/19/2016Fixed night mode highlight to green so white text can be seen.
03/19/2016Added text highlighting tool to TRFP.
03/18/2016Fixed skiping of flight info when plan has "***** ATTENTION CAPTAIN" note.
03/05/2016FP route appears to no longer include DCT for first point. PVG LAMEN is an exmple. If the first fix list point and first route point are the same, I add an extra . to the extract.
03/05/2016FP wording changed ETP/ETOP to ETP/ETOPS. Thus, I missed the section. Fixed.
03/05/2016Fixed problem where Google Earth file routed back to origin in some cases.
02/23/2016Removed option to automatically open the pages below. It caused too many problems.
02/10/2016Added option to open SkyVector, WX Underground, Alternates, and Google Maps if online.
02/10/2016I think that I fixed this so that the aiports are colored in Google Maps as well as earth.
02/10/2016Messing with the font and borders a little to still offer some iPad support.
02/08/2016Improved the font size a little.
02/07/2016Added link withing the generate TRFP file to https://dl.dropboxusercontent.com/u/18240150/JeppFDAlternates.htm
02/06/2016Fixed Google Maps link.
02/06/2016Replaced section links with menu bar.
01/20/2016I added an experimental printed table of contents for NOTAMS.
12/21/2015I put all of the links into the TRFP file.
12/21/2015Changed page so that TRFP loads automatically.
12/16/2015Eliminated Bing map link since it did not work in all cases.
12/16/2015Consolidated Google Maps link into one link with airports if so checked and no radar since the radar did not display correctly.
12/11/2015Added exapand and contract button to Notams and Weather in FP contents.
12/01/2015Updated flight plan links for new notams.
11/30/2015Added SkyVector.com link
10/25/2015Added solar elevation to the TRFP file.
09/15/2015Changed NOAA routing to Flight Weather Viewer routing. Label and algorithm change.
08/10/2015Combined the Times and Flight Plan files.
08/10/2015Re-arranged results to be more Surface centric.
06/24/2015Added feature to add ETP points to Jepp FD.
02/22/2015Added formatting and labeling of airports by AC type.
01/12/2015Added code to remove procedures like DIVAL1A and added note for manual selection.
01/17/2015Added experimental Surface RT box with ETP points.
10/25/2014Updated ForeFlight info to include a text box for easier copy and pasting.
10/25/2014Fixed .. in NAT for ForeFlight and SkyVector section.
10/25/2014Added reference to SkyVector.com in ForeFlight route.
10/25/2014Changed kml to display arctic and anartic circles in Android. Equator still does not show in Android Google Earth.
08/14/2014Hopefully fixed 11 character lat lon on NCAC routes
08/11/2014Fixed 11 character lat lon format.
06/09/2014Fixed problem when route is changed and notice of the change is in route section.
05/17/2014Added QR links.
04/29/2014Added NWS radar and warnings.
04/16/2014Fixed new howgozit functionality to work in IE.
04/16/2014The waypoint times initially load based on planned off time until updated.
04/02/2014Added origin and destination airports to Jepp FD for Win 8 routing.
04/02/2014Added Foreflight route link.
03/13/2014Filtered out SIDs and STARs with no transitions.
03/13/2014Modified lat/lon waypoints for better formatting.
03/07/2014Changed the Jepp FD to text boxes to solve wrapping problem.
03/07/2014Changed Surface Jepp FD route to use SID and STAR instead of fixes.
03/04/2014Added Jepp FD routing for Surface.
02/25/2014I corrected some some shading of TP's.
01/01/2014Added GPX file.
12/09/2013 Updated Jepp FD route algorithm.
11/08/2013Added full FDR as an attachment when you enter an e-mail.u enter an e-mail.
11/06/2013I eliminated much of the instructional text and added the top of the release to the e-mail text.
11/04/2013I moved much of the instructional information into a seperate document.
11/03/2013I added information on how to downgrade Google Earth for iOS under the iPad tricks section.
10/28/2013I added more info in the route box at the completion to check the spam/junk folder if the e-mail did not send.
10/14/2013Fixed problem where pasting from iOS7 Safari would color all TP's red and double label.
10/02/2013Added logic to accept pasting the whole iCrew page from iOS 7 Safari.
10/02/2013Updated airports from the AM. This is both and update and inclusion of narrow body airports.
09/30/2013Fixed wave TP areas.
09/24/2013Updated tips for iOS 7.
09/06/2013Fixed TP's over Europe that have east and west cooridinates. 08/22/2013: Added ForeFlight routing.
07/15/2013Changed HOWGOZIT to retain times when switching tabs in GoodReader.
06/25/2013I changed the Jepp FD route section to use the fix list for the SID and STAR parts of the route.
06/12/2013Fixed TP that goes across date line so that it no longer wraps around the earth.
06/03/2013I no longer show the flight plan when the page reloads. This saves some time over slow connections such as the crew lounge.
06/03/2013Fixed North Atlantic Tracks.
05/20/2013Added North Atlantic Tracks if they are pasted with the flight plan text.
05/11/2013Changed airport icons.
05/04/2013Added purpose
05/04/2013Added code to recongnize multiple releases and add options to the title if any are deselected. Since this was the reason behind the kml suffix, I moved it to the bottom of the page.
04/30/2013Added elapsed time to button.
04/30/2013I fixed some error messages that show up on IE 8 on XP. up on IE 8 on XP.
04/21/2013Added NOAA Flight Path Tool routing.
04/19/2013Added shading to TP's.
04/19/2013Major internal re-write.  I also added a simplified version for less clutter in Google and Bing maps.
03/30/2013Added mountain wave area TP capability.
03/29/2013Updated Johannesburg from FAJS to FAOR.
03/09/2013Fixed times to work in GoodReader.
02/26/2013To reduce clutter, I only show IATA where it is different from the last three characters of the ICAO. I also eliminated the space in the label for cases where I have IATA and ICAO.
02/21/2013I added an iCrew link. This only works from Delta computers.
02/15/2013Changed format of SkyVector and JeppFD output from text box to plain text to improve iPad copy behavior.
02/05/2013Change the order so that TPs are presented on top of the route in the points list.
02/05/2013Added icon to TP areas to allow easier tapping on the iPad. This is additional functionality. You can still tap on the line on the PC/Mac or Google Maps.
02/04/2013I added some color to the main run button. The color changes to indicate that the script is running.
02/04/2013Changed the clear button to a less conspicuous grey and made it a local acting Javascript function to only clear the route box.
01/31/2013Added breaks to times calculator.
01/30/2013Changed the Google Earth format from kml to kmz. Kmz is a zipped format which also contains the icons. Loading the kmz file from the e-mail offline will now load the icons.
01/20/2013Added waypoint elapsed, remaining times, and planned times.
01/20/2013Added email
01/20/2013Added kml (Google Earth, keyhole markup language) format.
01/19/2013Eding of the form to make it a little more readable.
01/18/2013Major update. I added kml parsing and Google Maps link.
01/09/2013Updated latitude and longitude to format N20.5W30.0. This appears to be common between JeppFD and SkyVector.
12/30/2012Updated to read 30 degree NAT such as N2030 as opposed to 2030N.
12/30/2012Updated to translate full waypoints such as 8530N14100Ws 8530N14100W