Macro or Auto-Sort “Standings”

In this corner, we have the number 1 contender, Auto-sort, versus the champion, Macros, in a title bout for the “Most User-friendly APBA Football Standings”. In this title bout the APBA Football community is the winner because both methods are tremendous timesavers. I’m always looking for ways to improve all facets (preparation, method of play, data input and reporting) of my replays and am blessed to have really smart friends. Denny Hodge created the auto-sort version and my APBA Football brother, Mark Zarb, created the macro-version.

These standings are designed to use in conjunction with the team workbooks that I posted a few days back. All you have to do is link each teams win, loss, tie, points scored and points allowed to the template. If using the auto-sort workbook, just link to gray-colored section.

Usage is very simple, for the auto-sort just open the file and the standings automatically adjust for each team’s winning percentage. For the macro version, just simultaneously press CTRL R keys and each divisions winning percentage is sorted. Press a second time and each divisions win record is sorted and press a third time and each division is alphabetically for teams with identical records. These functions happen a mind-numbing speed.

I know which one is my favorite but they are both winners in my book! Unfortunately WordPress doesn’t allow macro files to be inserted into a post but if interested email me at greg.barath@oguard62.net and I will send you the file.

2002 Standings(auto sort)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s