Excel Makeover - Company Softball Team

Back

About MrExcel

Consulting Services

Learn Excel Resources

Challenge of the Month

Excel Makeover - Company Softball Team

Amber MacArthur, Bill Jelen, Leo LaPorte, Andy Walker on the set of Call for Help on TechTV Canada.

The tip in this show is from Learn Excel from MrExcel.

This summer, MrExcel.com is sponsoring the Toronto 'Cellers. softball team. When the team is sponsored by MrExcel.com, they not only need to play well, but they have to have the best stats workbook of anyone in the league!

On today's episode of Call for Help, we take a look at the stats workbook.

You might expect a company softball team to have something that looks like this:

Some problems with this spreadsheet:

If a player did not play, there are errors in the Batting Average and Slugging columns.
There is not a good way to find the leaders in each category

After the Excel makeover, the worksheet looks like this: The grid for each game:

The grid for the season total:

The season leaders in several categories:

You can download the improved spreadsheet to check out all of the formulas. Be sure to check out:

Select AC57:AP77 to see all of the items in white font in that range. This hidden section helps calculate the season leaders.
Choose cell I8 and then Format - Conditional Format to see how those batting 1.000 are highlighted in blue.

Leo invited viewers to send in their best softball spreadsheet. Drop me a line at "bill at mrexcel dot com" with your spreadsheet samples.

If you have an application that could use an Excel makeover and you would like your spreadsheet to appear on the show, send me your ideas to the address above.

For the BEST TV show on technology, check out Call for Help.

This tip was originally published on July 24, 2006 and aired on TechTV in Canada and Australia on July 24, 2006.

The permanent URL for this page is http://www.mrexcel.com/tip131.shtml.

If you are looking for show notes from another episode, visit my complete list of TechTV appearances.

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.