FlyerTalk Forums - View Single Post - Is there a consolidated award chart that contains multiple carriers?
Old Mar 1, 2011 | 10:56 am
  #15  
FrequentFlyer9000
15 Years on Site
 
Join Date: Sep 2006
Posts: 526
You are going to have to have a flat file Excel database that is used by a pivot table for filtering. Don't even waste time trying to create a visual chart from scratch. I wasted a few hours on that dead end.

Your flat file will need columns like

Airline
From (Zone)
To (Zone)
Season (Peak/off)
Class (...)

Then you will need lookup tables to relate Zones to specific countries for each airline. Having a line for every country-country combo will be way too tedious, while simply trying do a zone-zone mapping will not work because different airlines have different zone definitions.

Like I said, I tried this and it is a ...... It will take you many hours. But it can be a useful tool if well-constructed, no doubt.
FrequentFlyer9000 is offline