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 5, 2020, 10:53 am
#1
Original Poster
Join Date: Jan 2018
Location: London
Programs: BAEC Gold, Accor Live Limitless Gold, Hilton Honours Gold, Avis Preferred Plus
Posts: 1,806
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/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:
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/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:
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/d/1TRTobiGawg3qlOHh24Zn1RguMqkPslahQzySB2vS3uw/edit#gid=0&fvid=1896029868
I suggest people opening in an "In Private" window thus keeping their personal Google accounts out of it.
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/d/1TRTobiGawg3qlOHh24Zn1RguMqkPslahQzySB2vS3uw/edit#gid=0&fvid=1896029868
I suggest people opening in an "In Private" window thus keeping their personal Google accounts out of it.
Last edited by wilsnunn; Feb 3, 2020 at 3:05 am Reason: Updated link to include fliter view
Jan 5, 2020, 11:43 am
#2
Join Date: May 2000
Location: HFA
Posts: 1,712
Maybe keep the entries sorted by flight number?
Shuly
Shuly
Jan 5, 2020, 11:47 am
#3
Join Date: Feb 2010
Location: London
Programs: BA GGL (for now) and Lifetime Gold, Marriott fan thanks to Bonvoy Moments
Posts: 5,115
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!
Jan 5, 2020, 12:09 pm
#4
Original Poster
Join Date: Jan 2018
Location: London
Programs: BAEC Gold, Accor Live Limitless Gold, Hilton Honours Gold, Avis Preferred Plus
Posts: 1,806
Jan 5, 2020, 12:24 pm
#5
FlyerTalk Evangelist
Join Date: Mar 2010
Location: JER
Programs: BA Gold/OWE, several MUCCI, and assorted Pensions!
Posts: 32,145
The Google sheet is here:
Last edited by T8191; Jan 5, 2020 at 12:31 pm
Jan 5, 2020, 12:27 pm
#6
Original Poster
Join Date: Jan 2018
Location: London
Programs: BAEC Gold, Accor Live Limitless Gold, Hilton Honours Gold, Avis Preferred Plus
Posts: 1,806
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.
Jan 5, 2020, 12:35 pm
#7
Original Poster
Join Date: Jan 2018
Location: London
Programs: BAEC Gold, Accor Live Limitless Gold, Hilton Honours Gold, Avis Preferred Plus
Posts: 1,806
You just used your first filter view!
Only your view has changed, but the list of filter views is shared with collaborators.
Important: Editing data changes it for everyone.
Only your view has changed, but the list of filter views is shared with collaborators.
Important: Editing data changes it for everyone.
Jan 5, 2020, 1:03 pm
#9
Join Date: Jun 2016
Location: London
Programs: BAEC Gold
Posts: 2,219
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!
Jan 5, 2020, 1:11 pm
#10
Original Poster
Join Date: Jan 2018
Location: London
Programs: BAEC Gold, Accor Live Limitless Gold, Hilton Honours Gold, Avis Preferred Plus
Posts: 1,806
EDIT: It should put the date in the correct format automatically from now on (regardless of how you enter it).
Last edited by wilsnunn; Jan 5, 2020 at 1:16 pm
Jan 5, 2020, 1:31 pm
#11
Join Date: Oct 2018
Location: London, UK
Programs: BAEC
Posts: 3,440
Well done for sorting this out! It is looking good already.
Jan 5, 2020, 1:45 pm
#12
Join Date: Oct 2010
Location: Switzerland
Programs: AY+ Platinum, SK Gold, BAEC Silver, airbaltic VIP, Radisson VIP
Posts: 6,529
Cool idea!
Jan 5, 2020, 2:02 pm
#13
Join Date: Jan 2015
Location: London
Programs: BA GGL, Gold for life
Posts: 127
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.
Jan 5, 2020, 2:02 pm
#14
Join Date: Jul 2019
Programs: BAEC Bronze, Mucci recipient
Posts: 1,785
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_
BA0502 LHR T3 to LIS date flown 4 Jan 2020 AJA_
Jan 5, 2020, 2:05 pm
#15
Original Poster
Join Date: Jan 2018
Location: London
Programs: BAEC Gold, Accor Live Limitless Gold, Hilton Honours Gold, Avis Preferred Plus
Posts: 1,806
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_
BA0502 LHR T3 to LIS date flown 4 Jan 2020 AJA_
Have added the flights to the spreadsheet for both of you.