- What you'll want to do is to go to the general airport details screen for a given airport. I will use BWI since that's my home. http://ae31.airline-...fo.php?city=BWI
-
Now copy the entire table from the "City" label to the last "Research" link. Open up an excel document (or use mine as a template). I would recommend pasting without formatting which is CTRL + SHIFT + V in Google Sheets or right click and select with Excel.
-
Open up the Find/Replace tool (usually CTRL + F and click replace). Type in " Y", yes that's Y with a space and submit. I usually use the economy seats for this data, but you can use other ones too so find and replace " F" and " C".
-
Ok now go to the blank column to the right of "Research." This is the M column. You can delete the research column, but I usually don't because then when you replace the table with new data, it overwrites your formulas.
-
Select the entire column and go to Format->Percent and select "Percentage."
-
Now go to the 4th row which is the first row with data. Type =<SeatsColumnRow>/<DemandColumnRow> where the <> is replaced by the column and the relevant row. For economy, the formula should be E4/H4
-
Copy and paste that all the way down the column. Don't do the whole column because that can cause performance issues if you have it all the way to like 200000, for example, but do it manually to row 500.
-
Okay! Now for the fun part. Select the table starting at row 4. Go to sort and sort by column M ascending.
-
That's it! It will display the percentage that a route is saturated. You can also sort by price (column K)
Hope this helps! I'm sure someone on here is better than me at Excel so any tips would be appreciated as well. On the last tab you can see I've been trying to make a listing of the total passengers of a plane over time. This helps to calculate what plane would be more worth it given their turnaround time. Any suggestions for improvements to that? Or maybe someone on here has made something like this already?
City" label to the last "Research" link. Open up an excel document (or use mine as a template). I would recommend pasting without formatting which is CTRL + SHIFT + V in Google Sheets or right click and select with Excel.