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 15, 2020, 7:49 am
#61
Join Date: Oct 2018
Location: UK
Programs: BA Silver (temp demotion), *A Silver, HH Gold, IHG Diamond
Posts: 492
Jan 15, 2020, 10:18 am
#62
Join Date: Mar 2000
Location: West Country, UK
Programs: BA gold UA MM
Posts: 474
BA109
Hi
on an iPhone I can’t add BA 109 lhr-dxb on 12 Jan if someone can add it for me? Thanks. Great idea
Louise
on an iPhone I can’t add BA 109 lhr-dxb on 12 Jan if someone can add it for me? Thanks. Great idea
Louise
Jan 15, 2020, 10:23 am
#63
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 15, 2020, 10:29 am
#64
Original Poster
Join Date: Jan 2018
Location: London
Programs: BAEC Gold, Accor Live Limitless Gold, Hilton Honours Gold, Avis Preferred Plus
Posts: 1,807
tigertanaka , you are down as having flown BA1314 as LHR-NCL but that seems to be a LHR-ABZ flight, could you check that please?
Jan 15, 2020, 12:57 pm
#65
Join Date: Jul 2018
Location: Mexico
Programs: BAEC Gold / Marriott Platinum
Posts: 3,545
Jan 15, 2020, 1:01 pm
#66
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 saw that you had left it at the bottom of the list rather than inserting it in the correct numerical order. There are two ways to get around this:
1) Insert a new row where your flight should be (in numerical order) then fill it in
2) Fill it in at the bottom then select all columns and all rows apart from Row 1 then go to "Data > Sort Range by Column A, A -> Z"
1) Insert a new row where your flight should be (in numerical order) then fill it in
2) Fill it in at the bottom then select all columns and all rows apart from Row 1 then go to "Data > Sort Range by Column A, A -> Z"
Jan 15, 2020, 1:10 pm
#67
Join Date: Jul 2018
Location: Mexico
Programs: BAEC Gold / Marriott Platinum
Posts: 3,545
Ah perfect. Got ya! will do that next time! Thanks
Jan 15, 2020, 11:39 pm
#68
Join Date: May 2006
Location: Canberra, AU
Programs: QF Plat
Posts: 188
Just got to add my first for 2020. Gvien that I'm based in Sydney these days, I don't often get a BA trip. Got 6 to add in in the next week before I head back South. Thanks for ths.
Jan 16, 2020, 3:55 am
#69
Join Date: Dec 2013
Location: Glasgow
Programs: BAEC Silver, Sixt Platinum, HHons Diamond
Posts: 927
Have added in BA0379 and BA1494 to the list. It is starting to make interesting reading.
Jan 17, 2020, 11:26 am
#70
Join Date: May 2009
Location: Bath, UK
Programs: BAEC Silver
Posts: 1,002
Jan 17, 2020, 3:51 pm
#71
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 18, 2020, 12:40 am
#72
Join Date: Nov 2015
Location: Oxford
Programs: BA Silver, HH Silver, IHG Plat
Posts: 169
On my phone so can't add it, could someone add BA2157 LGW-ANU 17/1 please.
Jan 18, 2020, 9:49 am
#75
Join Date: Mar 2018
Location: London
Programs: BAEC | qantas | IHG | Hilton Honors | Priority Pass | Nandos
Posts: 868