Thursday, 18 July 2013

Netball League Table Generator in Excel

I recently helped a reader out by creating a netball league table generator in Excel.

She wanted to be able to enter the results onto a sheet and have the league table automatically update to rank teams appropriately.

The spreadsheet allows 5 points for a win and 3 for a draw. 1 point is earned if the losing team scores half the points of the winning team. It also provides the ability deduct penalty points from a team.

Download the Netball league table spreadsheet.

The spreadsheet demonstrates some awesome Excel skills that are worth adding to your existing skillset. These include;
  • The use of Tables for intelligent referencing within formulas, and to the make the ranges dynamic.
  • The Vlookup function to retrieve data for the league table.
  • The Sumproduct function to perform multiple conditional testing.

No comments:

Post a Comment