Jan 5, 2020, 12:46 pm
Last edit by: wilsnunn
The Google sheet is here: https://docs.google.com/spreadsheets...vid=1896029868
Edited 03/02/2020 to include links with Filter View enabled
COPY of Post 1 (from wilsnunn) for if the thread gets too long:
How much of the BA flight network does the BAEC FlyerTalk community fly in 2020?
It was suggested in another thread (see here: Any Gaps in our collective knowledge?) 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:
The Google sheet is here: https://docs.google.com/spreadsheets...vid=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:
Quote:
Originally Posted by wilsnunn
I have made myself an anonymous account and have put together a basic version of the Google Sheet.
It is fully editable by users who are not signed in and my account shows as "wilsnunn Flyertalk" so keeps me in the same position as I am here.
https://docs.google.com/spreadsheets...vid=1896029868
I suggest people opening in an "In Private" window thus keeping their personal Google accounts out of it.
Edited 03/02/2020 to include links with Filter View enabled
COPY of Post 1 (from wilsnunn) for if the thread gets too long:
How much of the BA flight network does the BAEC FlyerTalk community fly in 2020?
It was suggested in another thread (see here: Any Gaps in our collective knowledge?) 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
The Google sheet is here: https://docs.google.com/spreadsheets...vid=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:
Quote:
Originally Posted by wilsnunn
I have made myself an anonymous account and have put together a basic version of the Google Sheet.
It is fully editable by users who are not signed in and my account shows as "wilsnunn Flyertalk" so keeps me in the same position as I am here.
https://docs.google.com/spreadsheets...vid=1896029868
I suggest people opening in an "In Private" window thus keeping their personal Google accounts out of it.
How much of the BA flight network does the BAEC FlyerTalk community fly in 2020?
Jan 11, 2020, 6:09 am
#31
Join Date: Jun 2016
Location: London
Programs: BAEC Gold
Posts: 2,222
Poised* to add another to the list next week!
*I don’t fly as much as most of you, so please excuse my excitement!
*I don’t fly as much as most of you, so please excuse my excitement!
Jan 11, 2020, 6:39 am
#32
Original Poster
Join Date: Jan 2018
Location: London
Programs: BAEC Gold, Accor Live Limitless Gold, Hilton Honours Gold, Avis Preferred Plus
Posts: 1,807
I know how you feel, after a rollercoaster 2019, I have no flights planned at all this year at the moment due to the end of my PhD approaching quickly and sorting out my future after that. I am itching to get back onto a plane!
Jan 11, 2020, 6:48 am
#33
Join Date: Mar 2018
Programs: British Airways Gold, IHG Spire Elite
Posts: 128
I flew BA890 on 1/1/20 - can’t see it on there yet (this is LHR-SOF)
Jan 11, 2020, 8:59 am
#34
Original Poster
Join Date: Jan 2018
Location: London
Programs: BAEC Gold, Accor Live Limitless Gold, Hilton Honours Gold, Avis Preferred Plus
Posts: 1,807
Jan 11, 2020, 10:21 am
#35
Join Date: Jan 2000
Programs: Latinpass Million Miler. BA Gold.
Posts: 3,544
Interesting, but if you want to know how much of the BA network is covered, you need to know what the complete BA network is. I just had a look, and there are 1700 different flight numbers currently filed for BA for 2020. That includes all BA operated flights, as well as franchises and wetleases.
It seems you are also including code share flights, ie flights that have a BA code but operated by another airline (such the BA7001, which is operated by QR). If you add all those in as well you'll have to add another 7700 flights in. I think actually for the codeshares your spreadsheet should really show who is operating the flight.
It seems you are also including code share flights, ie flights that have a BA code but operated by another airline (such the BA7001, which is operated by QR). If you add all those in as well you'll have to add another 7700 flights in. I think actually for the codeshares your spreadsheet should really show who is operating the flight.
Jan 11, 2020, 1:27 pm
#36
Join Date: Oct 2018
Location: London, UK
Programs: BAEC
Posts: 3,440
Sorry don’t have access to a laptop right now so please could someone add this for me.
BA2703
TFS-LGW
11th Jan
BA2703
TFS-LGW
11th Jan
Jan 11, 2020, 2:15 pm
#37
Join Date: Feb 2012
Programs: ex BD(LG),HH(D),SPG(P)/(LG), BA(G)
Posts: 215
Cracking idea, and have added my ORD-LHR in there (surprisingly the first to have done it this year). Given that this is Flyertalk though, in the interest of full disclosure should we not include the cabin flown, so we can ensure all flights are covered in every cabin? A simple WT, WTP, C (perhaps also CS as it is rolled out), and F after your name maybe? Just a thought...
Jan 11, 2020, 5:23 pm
#38
Join Date: Nov 2018
Location: Belfast
Programs: BA Silver
Posts: 379
I flew BA1423 BHD LHR on 11 Jan and will be on BA1422 LHR BHD 12 Jan. Mobile is not playing nice with editing so will update when I get home.
Jan 11, 2020, 5:55 pm
#39
Join Date: Mar 2018
Posts: 608
Also unable to edit on mobile
11/01 BA0854 LHR-PRG
11/01 BA0861 PRG-LHR
Would be grateful if someone could add
11/01 BA0854 LHR-PRG
11/01 BA0861 PRG-LHR
Would be grateful if someone could add
Jan 12, 2020, 3:01 pm
#42
Original Poster
Join Date: Jan 2018
Location: London
Programs: BAEC Gold, Accor Live Limitless Gold, Hilton Honours Gold, Avis Preferred Plus
Posts: 1,807
A quick update:
This spreadsheet has beeen posted for 1 week now and I wanted to provide a quick update.
- So far we have 80 flights marked as flown by the community here
- Only two of the flight numbers have been flown more than once (both have been flown twice so far)
- I have added a second sheet with some very rudimentary stats: number of flights flown and the most flown route (if multiple are equally popular then it will just pick the one with the lowest flight number)
If anybody is a Google Sheets wizz and wants to add any more formulas/stats/measurements then please feel free to do so (something like most visited non London airport would be interesting.)
Thanks to everybody who has taken part so far, lets see where this goes from here.
- So far we have 80 flights marked as flown by the community here
- Only two of the flight numbers have been flown more than once (both have been flown twice so far)
- I have added a second sheet with some very rudimentary stats: number of flights flown and the most flown route (if multiple are equally popular then it will just pick the one with the lowest flight number)
If anybody is a Google Sheets wizz and wants to add any more formulas/stats/measurements then please feel free to do so (something like most visited non London airport would be interesting.)
Thanks to everybody who has taken part so far, lets see where this goes from here.
Jan 12, 2020, 4:42 pm
#43
Join Date: Dec 2018
Programs: BAEC Silver
Posts: 31
Added BA0738 and I should be on BA0735 on Friday
Jan 13, 2020, 11:45 am
#44
Join Date: Feb 2018
Programs: Mucci, BAEC Silver, IHG Platinum Elite
Posts: 1,038
It was suggested in another thread (see here: Any Gaps in our collective knowledge?) 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.
Jan 13, 2020, 6:08 pm
#45
Join Date: Jun 2016
Location: London
Programs: BAEC Gold
Posts: 2,222
BA229 LHR-BWI added!