|
here's a snapshot of my league win/loss tracking sheet (I know everyone has their own style/etc).... basically each team gets two columns (wins / losses), and those are summed up at the bottom.... at the far left, those wins/losses are pulled over and the winning percentage is calculated.... all the team columns/rows in this section never change position and never get sorted/moved around.... the 0 entry is just an empty column at the end where a new team can be added in when more teams move up....
for the sortable chart to post for standings, I do what Maxfire5 mentioned and have another chart just below that have absolute references to all four columns (team name / wins / losses / pct)... that way I can sort those and they will always reference the same cells regardless of order
|