Quote:
Originally Posted by revmcgator
Here's an Excel file to help those who calculate larger leagues.
Instructions
1. Use Team vs. Team report.
2. Open Report in Browser. (I use Safari. Hopefully this works with your browser of choice)
3. Copy from Name of first team to the last record of the last team.
4. Paste into Excel sheet at A3, using Paste Special, As Text
5. Add "Record" in Column B below the last row.
At this point, you should be able to see the totals for OL teams easily. Copy those results into your own reporting sheet.
If you have some other way that is simpler or more elegant, please share  |
here's the one I use.... update the team names in row 1 (they will automatically update in column A once changed in the top row). Name should be updated above the 'wins' column, leaving the slot above 'losses' blank. Then just fill in the wins/losses vs each team in the appropriate cross sections.
Totals rack up in row 26, which also transfers to columns B and C.
For sorting of records, scroll down and use columns A-D, Rows 29-51 (as needed depending on number of teams). Those wins/losses also update automatically and are fixed to a specific cell, so the sort/movement doesn't matter/won't link them to the wrong team. Highlight that section and sort by column D.
For posting, I just open Paint, then copy/paste the standings section there, crop it down and save as a 2d image.