Updated source for xONEx prices by starting location?
May 1, 2008 | 6:22 pm
#16
Join Date: Jan 2005
Location: Sydney, Australia
Programs: QF Gold LTG (ow Saph), HHon Silver, Marriot Gold
Posts: 3,010
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
AONEs in USD
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
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
Last edited by moa999; May 1, 2008 at 6:38 pm Reason: formatting
May 2, 2008 | 2:33 am
#19
Join Date: Jan 2005
Location: Sydney, Australia
Programs: QF Gold LTG (ow Saph), HHon Silver, Marriot Gold
Posts: 3,010
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
AND I agree with the comments above that this IS nonetheless a hugely useful resource
May 2, 2008 | 10:45 am
#21
Join Date: Jul 2004
Location: SIN
Programs: SQ PPS, LH SEN, Amex something, nothing everywhere else
Posts: 994
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.
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.
Last edited by WearyBizTrvlr; May 2, 2008 at 10:46 am Reason: fixed link
Jan 10, 2009 | 8:41 pm
#24
Suspended
Join Date: Dec 2008
Posts: 610
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)
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)