Tips And Tricks

Having trouble finding the flight you want?

Moderator: Moderating Team

Post Reply
FJ flyer
Management/Moderator
Posts: 2415
Joined: 05 Feb 2007, 23:44
Location: Christchurch New Zealand

Tips And Tricks

Post by FJ flyer » 03 Dec 2008, 04:07

To explain how things work in Excel (a couple of people have asked), here is what it says in the timetable:

Excel Tips
1) Flights can be sorted or filtered based on various criteria. Click the arrow of the headers to explore this feature.
2) If the text appears too small, zoom in using the zoom level or by ctrl+scrollwheel.
3) Use the find feature (ctrl+F) to search for specific flights or to move around the timetable.


Hopefully this clears a couple of things up.

Can a moderator or admin please sticky this?
Image
Enigma Simulations | Texture Artist and Aircraft Designer
Click my banner to see my paints via Avsim.

User avatar
Aaron Robinson
Administrator
Posts: 3747
Joined: 07 Jan 2005, 18:14
Location: Atlanta, GA
Contact:

Re: Tips And Tricks

Post by Aaron Robinson » 03 Dec 2008, 04:24

Others you feel are worth adding?
Aaron Robinson | Managing Director and Owner
aaron.robinson@simairline.net | AIM: SimAirlineNet
Read the latest SimAirline.net news and updates at Viewpoint
SimAirline.net on Facebook and LinkedIn

SteveM
Pilot
Posts: 1
Joined: 01 Mar 2009, 12:00

Re: Tips And Tricks

Post by SteveM » 07 Mar 2009, 18:18

I have the Excel timetable 1.5.8 16th Feb but cannot workout how to use the sort feature

"Click the arrow of the headers to explore this feature "

Does not seem to work for me.Am i doing something wrong ?

Steve

RatherBFlyin
Moderator
Posts: 3086
Joined: 09 Jan 2005, 06:52
Location: Apex, NC
Contact:

Re: Tips And Tricks

Post by RatherBFlyin » 07 Mar 2009, 19:40

Here is how to use the filtering feature in Excel:

1) select any cell of data below the column headers.

2) In the menu, select Data > Filter > AutoFilter

3) You should notice small arrows appear in the bottom right corner of each header cell.

4) If you click on the arrow, a drop-down box will appear containing a list of the various content in each cell in the column.

5) Select the information you want to filter by, and the spreadsheet will hide everything that does not match that data in that column.

6) You can filter by several columns at once (eg. Airline and Departure Airport).

If you have done steps one and two, but cannot see the arrows in step three, I'm afraid I do not know what is wrong and can't assist further. :(

User avatar
cpt nick
Pilot
Posts: 568
Joined: 25 May 2008, 22:16
Location: Barnsley,England
Contact:

Re: Tips And Tricks

Post by cpt nick » 17 Jul 2009, 13:19

With the .pdf version if theres a certain place you wish to visit then use the search bar at the top and search say 'EGCC' for flights in an out of Manchester intl airport UK or '747-400' for obviously flights using the Booeing 747-400.
Just a small pointer for those of us without Microsoft Excel. :)
Image
Image
^My Simairline.net statistics^
high flyin' Banner by Nick Anderson
www.youtube.com/user/speedbird125
Find me on Facebook and Bebo.

Post Reply