Lifetime Tier points mission (im)possible?
#121
Join Date: Aug 2015
Location: SIN
Programs: AY+ Plat, GA Plat, SQ Gold
Posts: 316
#122
Moderator, Finnair
Join Date: May 2011
Location: MMX (CPH)
Programs: Eurobonus Diamond, QR Gold, AY+ Platinum, A3*G, Nordic Choice Lifetime Platinum, SJ Prio Black
Posts: 14,174
Very interesting question. I guess we all need to calculate our LT balance to see if something is missing.
#124
Ambassador: Finnair
Join Date: May 2003
Location: HEL
Programs: AY Lumo, BA Silver, HHonors Gold
Posts: 4,268
#125
Ambassador: Finnair
Join Date: May 2003
Location: HEL
Programs: AY Lumo, BA Silver, HHonors Gold
Posts: 4,268
The AY lifetime limits might sound tough to many of us mortals...for the real flyers they are nothing...many of us know(=have read about) the fellow FT member who has some 17mm lifetime with United and I think at least 2 years with >1M BIS miles...and AY is all about kilometers with cabin/tier bonuses...(no idea how much award miles that 17mm guy makes but 1M flown in 12 months is insane, even in First.)
#126
Moderator, Finnair
Join Date: May 2011
Location: MMX (CPH)
Programs: Eurobonus Diamond, QR Gold, AY+ Platinum, A3*G, Nordic Choice Lifetime Platinum, SJ Prio Black
Posts: 14,174
I am short 12125 LT tierpoints according to my spreadsheet. Now that may be something I missed in the early days but since the bonus points adds up perfectly (and that is more complex) I am slightly suspicious. I do know that 250 points disappeared in 2013, can't track the rest.
#127
Join Date: Aug 2015
Location: SIN
Programs: AY+ Plat, GA Plat, SQ Gold
Posts: 316
#128
Join Date: Jan 2006
Location: Helsinki-Vantaa APT, Finland
Programs: AY LUMO
Posts: 6,057
#129
Moderator, Finnair
Join Date: May 2011
Location: MMX (CPH)
Programs: Eurobonus Diamond, QR Gold, AY+ Platinum, A3*G, Nordic Choice Lifetime Platinum, SJ Prio Black
Posts: 14,174
It used to copy nicely, but since a while back, it does not. If you are handy with the text import guide, you can make it somewhat less manual than typing it all. But if done regularly then typing is sadly the way to go.
#130
Join Date: Aug 2015
Location: SIN
Programs: AY+ Plat, GA Plat, SQ Gold
Posts: 316
Copy the list manually and run this on the tier points cells =VALUE(SUBSTITUTE(MID(D2;14;6);"+";" "))
Works for the Finnish layout as the cell is formatted like "TASOPISTEET:+ 6276+ 6276". Should be easy to adjust for other languages. The substitute is needed to work properly on the 3 digit accruals.
I truly am 167759 LT's low.. EDIT: It was an IT glitch (how surprising). The list starts over after the 2-year cutoff. Didn't even realize there's no way to find older data so no way of checking this..
Works for the Finnish layout as the cell is formatted like "TASOPISTEET:+ 6276+ 6276". Should be easy to adjust for other languages. The substitute is needed to work properly on the 3 digit accruals.
I truly am 167759 LT's low.. EDIT: It was an IT glitch (how surprising). The list starts over after the 2-year cutoff. Didn't even realize there's no way to find older data so no way of checking this..
Last edited by Unsub; Apr 19, 2017 at 3:58 am
#132
Join Date: May 2015
Location: ATL/MCO
Programs: Costco Executive, RaceTrac Sultan of Soda, Chick-fil-A Red
Posts: 5,662
#133
Moderator, Finnair
Join Date: May 2011
Location: MMX (CPH)
Programs: Eurobonus Diamond, QR Gold, AY+ Platinum, A3*G, Nordic Choice Lifetime Platinum, SJ Prio Black
Posts: 14,174
I am one of all these members hoovering around halfway to LT gold and with current earning pace (200k/year) there really is no point in bothering or keeping track.
I'm still short the 11 875 LT points that disappeared earlier, I wonder what would happen if I demanded a recount. Like I said, I don't want to put time and energy into fighting for a program that has very little relevancy to me, but I am curious if they would brush me off or actually pull my entire flight record to see who is wrong.
I'm still short the 11 875 LT points that disappeared earlier, I wonder what would happen if I demanded a recount. Like I said, I don't want to put time and energy into fighting for a program that has very little relevancy to me, but I am curious if they would brush me off or actually pull my entire flight record to see who is wrong.
#134
Join Date: May 2013
Location: HEL
Programs: AY Plat (OWE), SK EBG (*A Gold), KQ Plat (STE+), Accor Plat
Posts: 3,157
I am one of all these members hoovering around halfway to LT gold and with current earning pace (200k/year) there really is no point in bothering or keeping track.
I'm still short the 11 875 LT points that disappeared earlier, I wonder what would happen if I demanded a recount. Like I said, I don't want to put time and energy into fighting for a program that has very little relevancy to me, but I am curious if they would brush me off or actually pull my entire flight record to see who is wrong.
I'm still short the 11 875 LT points that disappeared earlier, I wonder what would happen if I demanded a recount. Like I said, I don't want to put time and energy into fighting for a program that has very little relevancy to me, but I am curious if they would brush me off or actually pull my entire flight record to see who is wrong.
#135
Moderator, Finnair
Join Date: May 2011
Location: MMX (CPH)
Programs: Eurobonus Diamond, QR Gold, AY+ Platinum, A3*G, Nordic Choice Lifetime Platinum, SJ Prio Black
Posts: 14,174
Well... I already got some sorrows from looking at my excel history. My eyes fell on a old GOT-HKG trip that earned 94 000 tier points.
Those days are never coming back. Now we get excited for the breadcrumbs they throw at us, 100 game point here and there.
Anyway, I had to look at my photos from the trip and realise that was the time I went to Taipei, stayed in a hotel with mirrors in the ceiling, all the other guests were going at it like minks while I was alone because (former) Taiwanese GF was sick and unable to make it. I couldn't find the best site for lantern festival and the place I went to had no lanterns, but a "snow-machine" that hacked ice into smaller pieces of ice and spread through the air and everyone thought that is how snowing is and were very excited.
Then back to Hong Kong realising even luxury hotels have crappy rooms, but hey they have turn-down-service so that should compensate for kitchen ventilation being loosely bolted to my wall and noisy all night. Taking the bus to top of Victoria peek, finding out that potential HK GF didn't really share my views on just how big that potential was, but hey we had a nice walk downhill which incidentally described our relationship future too.
(Slightly exaggerated for drama)
So yeah - perhaps not pull up all this old stuff
Those days are never coming back. Now we get excited for the breadcrumbs they throw at us, 100 game point here and there.
Anyway, I had to look at my photos from the trip and realise that was the time I went to Taipei, stayed in a hotel with mirrors in the ceiling, all the other guests were going at it like minks while I was alone because (former) Taiwanese GF was sick and unable to make it. I couldn't find the best site for lantern festival and the place I went to had no lanterns, but a "snow-machine" that hacked ice into smaller pieces of ice and spread through the air and everyone thought that is how snowing is and were very excited.
Then back to Hong Kong realising even luxury hotels have crappy rooms, but hey they have turn-down-service so that should compensate for kitchen ventilation being loosely bolted to my wall and noisy all night. Taking the bus to top of Victoria peek, finding out that potential HK GF didn't really share my views on just how big that potential was, but hey we had a nice walk downhill which incidentally described our relationship future too.
(Slightly exaggerated for drama)
So yeah - perhaps not pull up all this old stuff