Go Back  FlyerTalk Forums > Miles&Points > Global Airline Alliances > oneworld
Reload this Page >

Excel Workbook with OWE Prices

Community
Wiki Posts
Search

Excel Workbook with OWE Prices

Thread Tools
 
Search this Thread
 
Old Jul 31, 2003 | 9:13 pm
  #1  
Original Poster
In Memoriam
 
Join Date: May 2000
Location: Boca Raton, FL DL FO/MM AA EXP SPG PLT
Posts: 968
Excel Workbook with OWE Prices

I have created a new Excel workbook with the Sabre OWE fares provided here by UserMark. This Excel workbook can be downloaded here. It is contained in a self extracting ZIP file. Just double click the archive and save the workbook to your disk.

This book contains a new feature -- automated download of the desired base currency. You select the currency for which you want to see the fares from a menu and the currency conversions are downloaded from the WWW. Unfortunately, this automation relies on software contained in the newer versions of Windows and Office. The chances are not good that the automated currency function will work with Office 97, Win95 or Win98 or on any system that has not had IE5 or later installed. There is a manual download function that should work in some earlier versions. Read the Instructions sheet first for information on how the program works.
ExMo is offline  
Old Aug 1, 2003 | 12:55 pm
  #2  
 
Join Date: Mar 2002
Programs: QF Platinum (OW Emerald); QF Lifestime Silver; BD Diamond Club Gold (*A Gold)
Posts: 4,786
Great work ExMo, you're certainly more on the ball than OW HQ is at responding to emails!
virtualtroy is offline  
Old Aug 4, 2003 | 8:03 am
  #3  
 
Join Date: Jun 2001
Location: Columbus, OH
Programs: AA-EXP 3MM, Bonvoy Lifetime Titanium
Posts: 582
Awesome resource. Thanks for all your efforts.
GeneCMH is offline  
Old Aug 4, 2003 | 9:39 am
  #4  
FlyerTalk Evangelist
40 Countries Visited
3M
All eyes on you!
25 Years on Site
 
Join Date: May 1998
Location: Massachusetts, USA; AA 2.996MM & Plat Pro, DL 1MM, GM & Flying Colonel
Posts: 25,034
Truly excellent. The basic spreadsheet works fine on Macs too, though I haven't tried currency conversion rate updating.

However, the .exe extension combined with the lack of Mac OS type/creator information mean it won't expand by double-clicking. Mac users who have an unzipping program (most recent versions of Stuffit can handle zipped files, or get the shareware ZipIt) can launch the program and select this file from within it; drag this file on top of the program icon; or (c) in System X, change the file name extension to .zip.
Efrem is offline  
Old Aug 4, 2003 | 2:50 pm
  #5  
Original Poster
In Memoriam
 
Join Date: May 2000
Location: Boca Raton, FL DL FO/MM AA EXP SPG PLT
Posts: 968
I would be amazed if the automatic download currency conversion worked on a Mac. The manual download conversion might work. If not, let me know and I'll Email you a URL to use to get the needed table. Let me know the base currency you want to use, also.

BTW, I have uploaded a plain ZIP file here for those users who want to save about 60K in the download and who already have an unZIPper or Stuffit on the Mac. As a former Mac user and fan of Ray Lau's initial work, I'll do whatever I can to help out those remaining Mac users.
ExMo is offline  
Old Aug 7, 2003 | 10:02 pm
  #6  
50 Countries Visited
5M
All eyes on you!
25 Years on Site
 
Join Date: Oct 1999
Location: Don't know....
Programs: BA LTG, SQ TPPS, CX DMP, AA EXP, Bonvoy LTT, ALL PLT, Hilton DM
Posts: 4,035
Thanks ExMo!
bagold is offline  
Old Aug 10, 2003 | 10:22 pm
  #7  
10 Countries Visited
20 Countries Visited
30 Countries Visited
20 Years on Site
 
Join Date: Jul 2002
Location: Salt Lake City, UT
Programs: AA Life time Platinum, Marriott Platinum, SPG Platinum
Posts: 234
Excellent work ExMo.

I have a question about currency exchange. Forex rates differ for buy/sell and obviously most times the vendor will take advantage of this during all the transactions. For the excel work sheet did you use buy or sell rate for each currency.

Thanks
rnprasad is offline  
Old Aug 11, 2003 | 12:58 pm
  #8  
Original Poster
In Memoriam
 
Join Date: May 2000
Location: Boca Raton, FL DL FO/MM AA EXP SPG PLT
Posts: 968
The currency rates are the average of the median bid/ask interbank market rates (generally based on transactions valued at or greater than US$1,000,000) for the preceding 24 hour period computed at 2300 MET (Middle European Time - GMT+1). Retail bank exchange and credit card rates can be 1-10% higher.
ExMo is offline  
Old Aug 12, 2003 | 1:21 am
  #9  
10 Countries Visited
20 Countries Visited
30 Countries Visited
20 Years on Site
 
Join Date: Jul 2002
Location: Salt Lake City, UT
Programs: AA Life time Platinum, Marriott Platinum, SPG Platinum
Posts: 234
Thanks for the quick reply. A simple suggestion. How about adding the ONE rules on a additional worksheet in the same Exel document! It then covers everything ( almost)
rnprasad is offline  
Old Aug 13, 2003 | 9:18 am
  #10  
50 Countries Visited
5M
All eyes on you!
20 Years on Site
 
Join Date: Aug 2002
Location: WAS/TYO
Programs: UA 1K, AA EXP (3MM), DL PM, BONVOY TITANIUM, HYATT GLOBALIST, HILTON DIAMOND, IHG DIAMOND AMB, et al
Posts: 6,271
Fantastic program! Thanks.

-FlyerBeek
FlyerBeek is offline  
Old Aug 28, 2003 | 12:29 pm
  #11  
 
Join Date: Sep 1999
Location: MA Quals: Lifetime Plat, SPG Gold
Posts: 198
Spectacular work. I may fly the Concorde yet.
Toofewmiles is offline  
Old Aug 28, 2003 | 8:34 pm
  #12  
50 Countries Visited
All eyes on you!
20 Years on Site
 
Join Date: May 2003
Location: MEL, Australia.
Programs: VA PLAT, HH Diamond
Posts: 214
Thanks for a great resource.
Kurwah is offline  
Old Aug 30, 2003 | 1:59 am
  #13  
20 Years on Site
 
Join Date: Jan 2003
Location: london & tokyo
Posts: 1,034
Many thanks - this is so useful!
eutow is offline  
Old Sep 2, 2003 | 12:28 am
  #14  
Original Poster
In Memoriam
 
Join Date: May 2000
Location: Boca Raton, FL DL FO/MM AA EXP SPG PLT
Posts: 968
I have updated the Excel workbook with a couple of small price changes that were effective at the end of July in Australia and New Zealand. The self extracting (on Windows) archive is here and the plain ZIP'd archive for those with an unZIPper or a Mac is here. If you are not going to originate in either of these countries, you do not need to download this new workbook as the other prices have not changed.

As the rules change frequently and there are several versions on line, I have decided not to include them with the pricing information.
ExMo is offline  
Old Nov 27, 2003 | 12:23 pm
  #15  
 
Join Date: Jun 2003
Location: NYC
Programs: AA Lifetime Gold
Posts: 242
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">Originally posted by ExMo:
I have updated the Excel workbook. </font>
This is an excellent program indeed. Having never done a Round the world before, the data s a bit overwhelming. Is there a website or a FAQ that walks one through the process? Thanks!
wannabe_plat is offline  


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.