sunseeker

to the mods
since the chart refered to in the "useful reference links" is often not very up to date and searching the *A tool to find out prices in like 50 countries is quite a timeconsuming stunt, would it be possibible to make a "sticky" which will be permanatly updated by contributors to this forum?
it seems that especially new members would appreciate this.....

sunseeker

BUMP....

AMRivlin

ity bump

ramolnar

In late November, I compiled prices for a lot (but not all) locations on all three alliances. Prices are in USD. I haven't heard of any big price changes since. It's in Excel 2007 format here:

http://twelvefruits.com/rtw27nov09.xlsx

sunseeker

that would be nice, however, this is what i get after unzipping and opening sheet 1:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:mv="urn:schemas-microsoft-com:mac:vml" mc:Ignorable="mv" mc:PreserveAttributes="mv:*">
<dimension ref="A1:K34" />
- <sheetViews>
- <sheetView workbookViewId="0">
<selection activeCell="A2" sqref="A2" />
</sheetView>
</sheetViews>
<sheetFormatPr baseColWidth="10" defaultRowHeight="13" />
- <cols>
<col min="1" max="1" width="20.28515625" customWidth="1" />
<col min="2" max="2" width="8" bestFit="1" customWidth="1" />
<col min="3" max="5" width="9.140625" bestFit="1" customWidth="1" />
<col min="6" max="8" width="9.28515625" bestFit="1" customWidth="1" />
<col min="9" max="11" width="9.140625" bestFit="1" customWidth="1" />
<col min="12" max="51" width="6" customWidth="1" />
</cols>
- <sheetData>
- <row r="1" spans="1:11">
- <c r="A1" t="s">
<v>79</v>
</c>
</row>
- <row r="3" spans="1:11">
- <c r="A3" t="s">

a.s.o, a.s.o.......

henry999

Erm ... ramolnar's very nice spreadsheet is not 'zipped'. Why would you want to unzip it?

(Hint: just open it with Excel.)

cheers,

Henry

zara

It is an Excel spreadsheet created with Office 2007/2010 (Windows) or Office 2008 (Mac).
That is why the extension says ".xlsx" instead of ".xls".
If you are using Office 2003 or older, your system does not know how to handle these files properly.
Basically it is a zipped XLS file. That is why your machine tries to unzip it.

I recommend searching for a freeware converter software.
Just google for "office 2007 converter" + "insert your operating system here".

sunseeker

... for this sound advice.
however, the admin won't allow me to download any software;
so no dice...

Robbiedeluxe

I converted ramolnar's spreadsheet to Excel 2003. Pick it up from my Dropbox: http://dl.dropbox.com/u/346078/rtw27nov09_oldformat.xls

sunseeker

thank you, robbie
good man! ^

crimson2k6

Thanks a lot for this file!

I've had a look at many of the price categories, but I'm having a hard time replicating any of these prices in the book and fly tool of *Alliance.

I'm not sure if I'm doing something wrong, but I'm getting 3600EUR all in for a 16 coupon, 28,000 mile RTW (YRWSTAR1) originating in Germany. Is it possible that the prices in the spreadsheet don't contain any taxes or surcharges?

According to the sheet, the Euro+ price should be 3700USD, which should be 2600EUR.

The routing I'm trying to create is the following:

STR-FRA-SIN-BWN-BKK-PVG-NRT-HNL-SFO-ANC-LAX-LAS-ORD-IAD-MUC-STR

If any of you guys have any suggestions, I'd really appreciate it!

Crimson

P.S: I tried routing through Cairo, which came out quite a bit cheaper but still at roughly 3000EUR (900USD more what it should be according to the sheet)

henry999

How could it be otherwise?

cheers,

Henry

crimson2k6

I was assuming that the chart was based on an estimate of average taxes/surcharges, though I guess airport taxes might vary widely, leading to a skewed result..

crimson2k6

Also, the Star Alliance website mentions that 5 stopovers are permitted on a RTW if travel commences outside the US.

I called up the United 1k line and was told that this "5 stopovers rule" only counts for the contiguous US. Since I'm stopping over in Hawaii and Alaska as well, the Book and Fly program sends me back an error of too many stopovers in the US, and counts the HI and AK stops as well.

Do any of you guys have experience with this situation?

ramolnar

They don't include taxes or surcharges. Those are route-dependent, and as you say, vary widely. From playing around, I think a reasonable estimate for economy would be 900USD.

Cairo should still keep you under 29,000 miles, so I suggest that. I don't see much else. If you removed ANC, you would get under 26,000 for the possible Special, but I think you want more than 5 stops.

I don't know what to do about the Hawaii / Alaska thing, sorry.