Sorting the Schedule

Using Excel to get a better schedule.

Microsoft Excel uses what is called a stable sort.

So you can Sort the data twice to get more useful information. First we sort the course by:

Note that we have to click options "My list has Header row" and the "Options" button to specify the sort order of the first key as

"Sun, Mon, Tue, Wed, Thu, Fri, Sat".

Unfortunately, we can only specify the "First key sort order", so

we have to depend on Stable sorting to keep the data sorted by

Day when we have equal keys on the first key of the second sort.

The second sort is where we sort by _CourseNo. The trick is here to select "(none)" for the sort order of the other two "Then by" keys.

So the result is listed by _CourseNo and shows classes which meet at multiple times in order by the day of week and the starting time.

If you want to have the longest classes at each hour show first, use the following Sort Settings

See also:

Sorting by Most recent changes

References:

Stable sorting

Enjoy,

Christopher Lent