FlyerTalk Forums - Updated source for xONEx prices by starting location?

FlyerTalk Forums (https://www.flyertalk.com/forum/index.php)

- oneworld (https://www.flyertalk.com/forum/oneworld-411/)

- - Updated source for xONEx prices by starting location? (https://www.flyertalk.com/forum/oneworld/818227-updated-source-xonex-prices-starting-location.html)

To see the input sheets (ie Raw Data)

Format->Sheet->Unhide then Unhide the OWData sheet.

Inputed prices are contained in Columns E through P.

What strikes me is that there are a number of countries that appear to have odd inputs (ie decimal points), whereas by and large according to the OW website flights are price in Round Numbers. Unsure what WearyBiz's source for the data was.

If I go through and check the data with the OW website database for the cheap DONE4 fares - Mauritius and Syria increases quite a bit, Namibia, Pakistan and Indonesia slightly. OW provides no prices on Malawi, Iran, Amenia, Azerbijian, Georgia

So for prices (as from OW website and currency today) excluding those with no prices I get the following

DONEs in USD

Code:

                   DONE3        DONE4        DONE5        DONE6

South Africa                5,265        5,970        6,985

Namibia                          5,667        6,123        6,787

Mauritius                6,083        6,877        8,010

Ukraine            5,850        6,500        7,550        8,700

Pakistan           5,852        6,589        7,578        8,715

Korea            5,623        6,702        7,703        8,690

Indonesia        5,928        6,779        7,725        8,630

Saudi Arabia        5,939        6,817        7,696        8,575

Gibraltar          6,140        6,932        7,724        8,913

Africa                        7,000        7,600        8,200   (includes Angola, Ethiopa, Ghana, Kenya, Nigeria, Tanzania, Uganda, Zimbabwe)

Philippines        6,134        7,022        8,001        8,925

Syrian Arab R.        6,074        7,041        8,283        9,923

Sri Lanka        6,242        7,117        8,183        9,320

AONEs in USD

Code:

                       AONE3        AONE4        AONE5        AONE6

South Africa                6,852        8,698        10,121

Mauritius                    7,103        8,123        9,257

Namibia                    8,142        8,924        9,575

Saudi Arabia        7,936        9,081        10,226        11,398

Ukraine            8,650        9,300        10,900        11,900

Indonesia        8,198        9,370        10,670        11,948

Africa                    9,400        10,100        11,300

Philippines        8,481        9,734        11,088        12,390

Syrian Arab R.        8,559        9,801        11,459        12,701

Jordan            8,705        9,969        11,654        12,918

Korea            8,783        9,987        11,476        13,197

Israel            8,800        10,000        11,700        13,000

Ouch, back to the drawing board it is... I'll try to get the mispricings fixed shortly.

Notwithstanding any glitches, this is magnificent work, WBT. Heaps of praise and thanks be upon you.

Weary send me a PM with your email address and I can send you my partially updated spreadsheet...

AND I agree with the comments above that this IS nonetheless a hugely useful resource

Quote:

Originally Posted by Gardyloo (Post 9665566)

Notwithstanding any glitches, this is magnificent work, WBT. Heaps of praise and thanks be upon you.

Second that

Thank you all for your kind words.

I have uploaded a corrected version that is much closer to moa999's numbers here. I think I found the glitch... for those afflicted by caching problems, the direct link is http://qsi.cc/users/wbt/RTWFares2.0.1.xls.

One more conference call and it's all South African wines for me tonight. :)

Thanks from me too. I have found your past work very useful and am happy to see the update. It is much appreciated.

OW useful reference links is updated for the new version.

Hi there,

just wondering is there an update to this excel fare sheet. Given the changes in USD, I think a direct calc from oanada will be really useful

thanks

Is it possible to also linking the Oneworld prices directly into the sheet (given they seem to increase their prices without much notice)