How much of the BA flight network does the BAEC FlyerTalk community fly in 2020?
 

It was suggested in another thread (see here: https://www.flyertalk.com/forum/brit...owledge-5.html) that it would be a fun/interesting task to see how much of the whole BA network of flights we as a community here on FlyerTalk actually fly in a given year.

After a bit of discussion in the afore mentioned thread, we came up with the idea of a Google Sheets document to track flights taken by the community.

If people here are genuinely interested in persuing this task then I am sure that it would lead to some very interesting results.

Rules:

• You must only edit the Google Sheet when not logged into your own Google account (personal/business etc) so as to remain anonymous to the community (and to me the owner of the Google sheet using a new account that is not being used for anything else)
• You can only add your flight to the list once you have flown it (incase of IRROPS, change of plans etc)
• You have to have flown on the flight using its BA flight number
  • This means that if you flew on BA113 but were ticketed as AA6134 for example this should not be included
  • This also means that if you have flown QR1 but it was actually ticketed as BA7001 this should be included

In addition to when the route is first flown in the year, this could give some insight into the most popular routes for the members of the community here, as such there is a counter built into the spreadsheet (a simple COUNTA() function) so even if you are not the first to fly that route and want to participate in this experiment, it would be great to see how popular certain routes are.

The Google sheet is here: https://docs.google.com/spreadsheets/d/1TRTobiGawg3qlOHh24Zn1RguMqkPslahQzySB2vS3uw/edit#gid=0&fvid=1896029868

Obviously this will not be of interest to everybody but for those who are interested, I hope that this proves to be a fun and interesting experiment.

Note: if you wish to participate but wish to add an extra level of anonymity on top of your FT username, then please feel free to assign yourself another pseudonym and participate that way.

If you have any questions then please let me know.



My post from the afore mentioned thread for reference:

Maybe keep the entries sorted by flight number?

Shuly

Must remember this - I’m on the first flight of a summer route this year so should have a decent chance of being the first FTer to record it for the year!

I have included a "Filter" so that it is easy to sort it by flight number whenever anybody adds a new one on.

Sorry, not that IT aware. What do I do? Just fill in the next line in the spreadsheet once I’ve flown? I can see a bunch of pre-loaded BA Flights showing 0.

Exactly, if the flight that you have flown is not already on the list (I pre-populated some and other people have added some already) then simply add to a new row, the flight number, origin and destination, then add your FT username and date flown in the first empty column under User 1, User 2, etc.

If you are first to fly the route then please also fill in the "First Flown" column.

The "Number of times flown" column will automatically do its thing so no need to worry about that.

Need to look into this more, it seems that the filter is user specific.

YES Please. I have reordered the current ones, but if adding a new flight number please add a new row in the correct location, this will also make checking if the flight had already been added.

I’ve had a go at updating the spreadsheet! Can somebody confirm that I have saved it correctly? BA18 on 2nd January. Also, I couldn’t fathom how to set the date format correctly. i.e. 02-Jan rather than 2/1/20!

Looks good to me, I will look into seeing if I can get the formatting of the date to do itself automatically too regardless of the input format.

EDIT: It should put the date in the correct format automatically from now on (regardless of how you enter it).

Well done for sorting this out! It is looking good already.

Cool idea!

My IT skills are not up to being able to edit this from my iPhone but I am on BA251 to Santiago (SCL) tonight which isn’t on the list.

I like this however I can't seem to edit the spreadsheet from my mobile phone. It seems to want me to download and install Google docs even though I have it already. As I am on a mobile network I don't want to download again (data speed is a bit slow). Can someone please edit the spreadsheet for me to add:

BA0502 LHR T3 to LIS date flown 4 Jan 2020 AJA_

The mobile issue is something that I hadn't thought of yet, I think that if you download the app then you have to be logged into a Google account - clearly not ideal for the purposes of this. Will look into it.

Have added the flights to the spreadsheet for both of you.