Go Back  FlyerTalk Forums > Miles&Points > Airlines and Mileage Programs > American Airlines | AAdvantage
Reload this Page >

Quickly check date to see if widebody is flying - new spreadsheet tool

Quickly check date to see if widebody is flying - new spreadsheet tool

Old Nov 7, 2019, 8:34 pm
  #1  
Original Poster
 
Join Date: Jul 2019
Location: CMI, ORD, NYC
Programs: AA Plat
Posts: 92
Quickly check date to see if widebody is flying - new spreadsheet tool

So I'm planning a status run and wanted to see if I can maybe try out some of the widebodies domestically. I've never been on the 787 so that's my goal. I noticed TPG has a pretty good timetable but it sucks if I'm planning for a specific date(s). So I quickly grabbed everything and threw it in Excel. I'm sharing it here in Google Sheets just in case anyone else would find it useful.

https://docs.google.com/spreadsheets...it?usp=sharing

Basically, enter the dates you want to travel in cells B4 and B5. Example, you would enter November 16 as 16-Nov. (I believe any date format would work).

Then, the sheet will quickly check if your dates fit any of the routes. Column N checks your outbound date, and column O checks your Inbound date. If your date is in the range, the cell will say TRUE and be highlighted green.

I'm not planning on updating this (unless someone points out an error), but I'll probably do it again for the next timetable TPG puts out. It takes 10mins to throw together.

Cheers

Edit: It's locked as view only. You'll have to save as your own copy to edit. It also ignores frequency of the flight (Ex. MWF flights) so keep that in mind.
hawaii-bound, rktsci and flybie like this.

Last edited by peaches070; Nov 7, 2019 at 8:37 pm Reason: clarification on getting copy
peaches070 is offline  
Old Nov 7, 2019, 8:40 pm
  #2  
 
Join Date: Feb 2011
Posts: 696
Thumbs up

Wow. Thanks for your effort.
flybie is offline  
Old Nov 8, 2019, 5:31 am
  #3  
 
Join Date: Jun 2018
Programs: AA PPro
Posts: 632
Cool project, I am also a fan of AA domestic widebody flights (taken 763 and 772 multiple times MIA-JFK, 772 MIA-DFW, 773 MIA-LAX). Just an FYI for you TPG makes their post based on the publicly available AA cargo domestic widebody timetable: https://www.aacargo.com/ship/schedules.html
HiAperture is offline  
Old Nov 8, 2019, 7:14 am
  #4  
Original Poster
 
Join Date: Jul 2019
Location: CMI, ORD, NYC
Programs: AA Plat
Posts: 92
thank you! that helps a lot actually
peaches070 is offline  

Thread Tools
Search this Thread

Contact Us - Manage Preferences - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.