Tuesday, September 18, 2012

How to Calculate Softball Standings With Excel


1. Launch Microsoft Excel 2010 to open a new spreadsheet. Click on cell 'A1' and type 'Team Name' into the cell. Click on cell 'A2' and enter the name of the first team. Continue to enter names down the first column until you have entered the name of every team.
2. Select cell 'B1' and type 'Wins' into this cell. Select cell 'B2' and enter the number of wins for the team listed in cell 'A2.' Repeat this process for every team.
3. Click on the cell at the top of the next empty column and type 'Winning Percentage' into this cell. Click on the next cell in this column and enter the following formula:=(B2 (D2*0.5))/SUM(B2:D2)If ties are worth a third of a win in your league, enter '0.3333' instead of '0.5.' If your league does not track ties, use the following formula instead:=B2/SUM(B2:B3)Press 'Enter' to complete your formula.
4. Move your mouse over the small fill-handle in the lower right corner of the cell that contains your formula. Click and drag the mouse down to the last row that contains team information and release the mouse button. Excel will automatically copy the formula down the entire column.
5. Click on cell 'A1.' Click the 'Insert' tab at the top of the screen, then click the 'Table' button in the Tables area of the ribbon. Excel will automatically select every cell where you entered data, so just click 'OK' in the Create Table window to continue.
6. Click the drop-down arrow next to the 'Winning Percentage' cell and choose 'Sort Largest to Smallest' from the menu. Your softball standings will now be sorted by winning percentage, placing the best teams at the top of the standings.

Blogger news