Updated *A RTW Spreadsheet (Updated 1 Jan 2011)
Jan 14, 2009, 4:22 am
#31
Join Date: Jan 2005
Location: Tampere
Programs: BA EC Gold, Hilton Diamond
Posts: 3,237
Mar 21, 2009, 7:34 am
#34
Join Date: Jul 2008
Location: HKG
Programs: Marriott Ambassador (Titanium Lifetime), BA Gold, Ex-Hertz 5* PC, Ex-HH Diamond, Ex-BD*G
Posts: 3,062
I'm curious, where are the actual fares populated from on this worksheet?
I've just updated a version of the spreadsheet to get the latest currency exchange rates, but I know from reading other threads that the prices have also been changing (Have passed the info on that to JayhawkCO too).
Does ExpertFlyer provide these fare costs (as I think I saw 'EF' mentioned in a few places)?
My situation is looking into a RTW, probably CRWSTAR3 (maybe FRWSTAR3) combined with a circle pass or two potentially. I have time/money (or frequent flier miles) to spend going to an exotic country to ticket/start/end the journey if needed so trying to just get an idea of which country is the cheapest, and how to update that knowledge when I get closer to ticketing (in a 6 months perhaps). I'm trying for more exotic journeys which means that 39k miles isn't really enough as standard, hence starting in an exotic location (I'm based in LON) means I can already save some of those 39k miles as I'm trying to avoid Europe for the most part anyway.
I've just updated a version of the spreadsheet to get the latest currency exchange rates, but I know from reading other threads that the prices have also been changing (Have passed the info on that to JayhawkCO too).
Does ExpertFlyer provide these fare costs (as I think I saw 'EF' mentioned in a few places)?
My situation is looking into a RTW, probably CRWSTAR3 (maybe FRWSTAR3) combined with a circle pass or two potentially. I have time/money (or frequent flier miles) to spend going to an exotic country to ticket/start/end the journey if needed so trying to just get an idea of which country is the cheapest, and how to update that knowledge when I get closer to ticketing (in a 6 months perhaps). I'm trying for more exotic journeys which means that 39k miles isn't really enough as standard, hence starting in an exotic location (I'm based in LON) means I can already save some of those 39k miles as I'm trying to avoid Europe for the most part anyway.
Mar 21, 2009, 10:11 am
#35
Original Member
Join Date: May 1998
Location: Canada
Programs: AC SE 2MM, HH Dd, SPG; IC Pl/A; AA; DL
Posts: 14,323
Expertflyer provides RTW fares. Just plug in the same cities in each box, eg. LAX-LAX and you will get all the RTW fares (as well as some other types like Circle Asia/Pacific etc.
Mar 21, 2009, 10:13 am
#36
Join Date: Jul 2008
Location: HKG
Programs: Marriott Ambassador (Titanium Lifetime), BA Gold, Ex-Hertz 5* PC, Ex-HH Diamond, Ex-BD*G
Posts: 3,062
Thanks BlondeBomber, guess I'm going to need to get myself a subscription as I get closer to actually booking my trip.
May 14, 2009, 5:34 pm
#38
Join Date: Dec 2008
Location: San Francisco, CA
Programs: UA 1P, AA Plat, SW AL/CP
Posts: 253
New/Updated Version of the JayHawkCo spreadsheet
So I've taken the liberty of updating JayHawkCo's spreadsheet to reflect the latest prices/exchange rates, as well as added the 26,000 mile YRWSPCL fare. I retrieved the prices from ExpertFlyer, which only had ~30-40 currencies. So for the one's it didn't have, I put the fare in USD.
Enjoy: Star_Alliance_RTW_050809.xls
Enjoy: Star_Alliance_RTW_050809.xls
May 14, 2009, 6:02 pm
#39
Join Date: Mar 2009
Location: YWG
Programs: AC 35K, Marriott Silver
Posts: 271
So I've taken the liberty of updating JayHawkCo's spreadsheet to reflect the latest prices/exchange rates, as well as added the 26,000 mile YRWSPCL fare. I retrieved the prices from ExpertFlyer, which only had ~30-40 currencies. So for the one's it didn't have, I put the fare in USD.
Enjoy: Star_Alliance_RTW_050809.xls
Enjoy: Star_Alliance_RTW_050809.xls
Wow, looks like the UK of all places is a good "launching point" now --if I'm reading the table correctly.
May 14, 2009, 7:24 pm
#40
Join Date: Dec 2008
Location: San Francisco, CA
Programs: UA 1P, AA Plat, SW AL/CP
Posts: 253
Well the UK certainly comes in cheaper than most of Europe & North America, but, Asia, Africa and Oceania are even cheaper. That all said, the best "launching point" is certainly Fiji.
May 14, 2009, 8:04 pm
#41
Join Date: Mar 2009
Location: YWG
Programs: AC 35K, Marriott Silver
Posts: 271
Ah thanks for pointing that out. Column P should have been the basis of my sort --did not catch that it was GBP.
May 15, 2009, 12:21 am
#43
Join Date: Dec 2008
Location: San Francisco, CA
Programs: UA 1P, AA Plat, SW AL/CP
Posts: 253
May 15, 2009, 10:49 am
#44
Join Date: Dec 2008
Location: San Francisco, CA
Programs: UA 1P, AA Plat, SW AL/CP
Posts: 253
NLK - Norfolk Island
NOU - Noumea
PPT - Tahiti
IUE - Niue
RAR - Cook Islands
PRN - Kosovo
I was going to add GUM - Guam, but I don't believe (at least according to the *A tool) that there are any *A flights to/from GUM.
Here it is: Star_Alliance_RTW_050809_v2.xls
May 16, 2009, 10:05 pm
#45
Join Date: Apr 2008
Location: Auckland, NZ
Programs: AirNZ *G, HHonors, Hertz Gold, OmniHotels Black card
Posts: 75