Points & SC's on a OneWorld RTW ticket | Australian Frequent Flyer
Australian Frequent Flyer

Welcome to Australia's leading independent Frequent Flyer and Travel Resource since 1998!
Our site contains tons of information that will improve your travel experience.

Joining AFF is fast, simple & absolutely free - register now and take immediate advantage of these great BENEFITS.

Once registered, this box will disappear. And you will see fewer advertisements :)

Points & SC's on a OneWorld RTW ticket

Status
Not open for further replies.

NickP

Intern
Joined
May 24, 2005
Messages
65
Guys & Gals

Some help please. In Sept / Oct I'm going to be doing the above, luckily enough in business class. I've pretty much figured it all out with my agent, however I'm wondering how many points & sc's [I'm a QFF] I'd earn for the following direct sectors:

LA - LHR on BA
LHR - IST - on BA
IST - LHR - on BA

Help would be gratefully received.
Cheers
Nick
 

simongr

Enthusiast
Joined
Jul 10, 2006
Messages
14,229
I think this is:

Code:
Carrier	Origin	Dest	COS	Miles	COS	Status	Total	Status	SCs
BA	LAX	LHR	bus	 5,448 	 1,362 	 1,362 	 8,172 	PS	140
BA	LHR	IST	bus	 1,563 	 391 	 391 	 2,345 	PS	80
BA	IST	LHR	bus	 1,563 	 391 	 391 	 2,345 	PS	80
									
BA	LAX	LHR	bus	 5,448 	 1,362 	 2,724 	 9,534 	SG	140
BA	LHR	IST	bus	 1,563 	 391 	 782 	 2,735 	SG	80
BA	IST	LHR	bus	 1,563 	 391 	 782 	 2,735 	SG	80
									
BA	LAX	LHR	bus	 5,448 	 1,362 	 5,448 	 12,258	WP	140
BA	LHR	IST	bus	 1,563 	 391 	 1,563 	 3,517 	WP	80
BA	IST	LHR	bus	 1,563 	 391 	 1,563 	 3,517 	WP	80
Wasn't sure of your status.


S
 

NickP

Intern
Joined
May 24, 2005
Messages
65
Thanks mate, excellent info. I'm WP, so thanks for including the detail, as I'd forgotten to ask.

Cheers
Nick
 

v8Statesman

Established Member
Joined
Dec 16, 2005
Messages
2,199
Flights
My Map
simongr said:
I think this is:

Code:
Carrier    Origin    Dest    COS    Miles    COS    Status    Total    Status    SCs
BA    LAX    LHR    bus     5,448      1,362      1,362      8,172     PS    140
BA    LHR    IST    bus     1,563      391      391      2,345     PS    80
BA    IST    LHR    bus     1,563      391      391      2,345     PS    80
 
BA    LAX    LHR    bus     5,448      1,362      2,724      9,534     SG    140
BA    LHR    IST    bus     1,563      391      782      2,735     SG    80
BA    IST    LHR    bus     1,563      391      782      2,735     SG    80
 
BA    LAX    LHR    bus     5,448      1,362      5,448      12,258    WP    140
BA    LHR    IST    bus     1,563      391      1,563      3,517     WP    80
BA    IST    LHR    bus     1,563      391      1,563      3,517     WP    80
Wasn't sure of your status.


S

May I ask how that wonderful table was generated?
 

simongr

Enthusiast
Joined
Jul 10, 2006
Messages
14,229
I have a spreadhseet!!!!

Basically it has a lot more columns than shown there. It takes the origin/destination in two columns, concatenates them into a single 6 letter reference, does a lookup in a table of potential destinations (taken from mileage monkey by putting in possible OW destinations from point X and then reversing for the return journey - most major hubs covered for Europe, NAM, ANZ and Asia - I dont fly to Africa so they would only be picked up from a another destination flying there), looks up the fare basis and class of service and calculates based on your status and the program posting to the qpoints, SCs and mileage earned.

I use it to forecast status etc and if i need to put in points from Amex. I just havent been able to get it to deal with the change of status on anniversary dates if you havent requalified.

I am using it to decide whether to go with AA only long term or flick enough to QF for SG/WP.

On the next trip (Sep) I will fix up the status tables so it should be automated and rolling year on year.

I have also put in a neat feature to forecast what you could do with the points on the two programs - to compare (havent automated fuel surcharges and taxes though ;))

S

EDIT

SO to actually answer the question rather than showing about fancy spreadsheets... I put in the detsinations, selected d/bus fares and flexed the status across the three levels (forced).

S
 

Alanslegal

Senior Member
Joined
Jun 22, 2007
Messages
5,231
Where do you find the time to create a spreadsheet SIR?

And may I have a copy of the spreadsheet please?? :D
 

simongr

Enthusiast
Joined
Jul 10, 2006
Messages
14,229
I think a lot of FFers have their own spreadsheets. A lot of the work has been done on the train in the mornings and in airport lounges (mostly HKG).

I want to do some tweaking before I release to the public - but I will be uploading it :)
 

v8Statesman

Established Member
Joined
Dec 16, 2005
Messages
2,199
Flights
My Map
simongr said:
I think a lot of FFers have their own spreadsheets. A lot of the work has been done on the train in the mornings and in airport lounges (mostly HKG).

I want to do some tweaking before I release to the public - but I will be uploading it :)
Champion!

If I see you in a QP I'll shout you a beer :p
 

simongr

Enthusiast
Joined
Jul 10, 2006
Messages
14,229
Not a problem. The main driver for the spreadsheet is for people to how much better off they will be under AA (most of my nonAFF friends who fly a lot are in paid J on business so AA is streets ahead).

I have gained a lot from this site so anything I can give back I am happy to :)
 

simongr

Enthusiast
Joined
Jul 10, 2006
Messages
14,229
Well we have had a breakthrough! The spreadsheet is now able to flex your AA status based on status changes during the year and on the status change date of 1 March - only thing is that you cant travel on 31/12 1/1 28/2 and 1/3 :)

Next stage to flex QF status based non standard anniversary dates :confused:

Should be done next week in fact as a result of some quality time on the train.

All that is left to do is:

- QF rolling status
- Linking forecasts of potential trips to the current points balance (so it can tell how many domestic trips you could do in J between the two programs as an example)
- Validating fare earning tables
- Factoring in converting stickers to 500 miles under AA
- Factoring in loyalty bonuses on QF
- Creating destination pairs for African/S AM locations
- Creating FALSE statements for lookups where I havent got the destination pair working

Not long now!
 

simongr

Enthusiast
Joined
Jul 10, 2006
Messages
14,229
Hmm - you had to remind people of that :p

It hant moved much - my trip through China has been a little more unstable than originally planned (dates back from PVG changed three times and I was only there for 4 days...)

I will aim to have it finished either on my trip to NRT or on my 15 hour monster to DFW.
 
Status
Not open for further replies.

AFF on Air Podcast

  • jb747’s Stellar Career with Qantas – AIR013
    Sat, 15 Jun 2019 03:00:41 AEST
      In this special edition of the podcast, Matt chats to John Bartels (a.k.a. jb747) about his flying career with Qantas, the A380, the QF30 incident, flight training, retirem ...
  • Cheap Virgin Australia Business Class – AIR012
    Sat, 01 Jun 2019 03:05:28 AEST
      Find out how to get cut-price Virgin Australia Business Class tickets by buying and redeeming Etihad Guest miles! This episode also includes some listener Q&A and an interv ...
  • Star Alliance Status – AIR011
    Sat, 18 May 2019 09:39:41 AEST
      Find out how to easily earn Star Alliance Gold status with several different frequent flyer programs! This episode also includes an interview with John Blom, Australia’s ...
  • Premium Economy – AIR010
    Sat, 04 May 2019 00:21:32 AEST
      Premium Economy is a great compromise if you want a more comfortable experience than Economy, without paying for Business or First class airfares! In this episode, AFF’s ...
  • Hyperinflation of Points – AIR009
    Sat, 20 Apr 2019 04:49:59 AEST
      Frequent flyer points are a valuable currency, but they aren’t immune from hyperinflation! In this episode, Matt discusses why frequent flyer points are a terrible long-t ...

Community Statistics

Threads
81,574
Messages
1,883,326
Members
49,467
Latest member
pam43
Top