Chart Soccer spreadsheet coming soon

Just a heads up, if you are interested in the Chart Soccer pages, in particular the A.F.L. Chart Soccer, I plan to make a spreadsheet available in Excel format that can be used to play a version of Chart Soccer. The spreadsheet will have a 20-Team Super League, a Challenge Cup (like the F.A. Cup) starting at the 64-team stage and a European Cup also starting at the 64-team stage.

What the spreadsheet will do

The spreadsheet will be able to create a fixture list into which results can be entered, and automatically create a league table, points recorder (to help determine “form” teams) and a results table. The cup competitions will allow for teams to be allocated to draw numbers, and the matches to be auto-populated based on the draw numbers entered. As results are entered, the qualifiers for the next round will be automatically generated, and will take account of replays, penalties and, for the European Cup, aggregate scores and the away goals rule.

What the spreadsheet won’t do

The spreadsheet will not be able to

  • Generate the results – Separate dice or a dice roller spreadsheet would have to be used;
  • Make draws – These would have to be done using cards, counters or some other method (there will be an explanation of how to create a random draw generator in Excel in the user guide);
  • Create data exports – This is something I may add later, but for now I’m keeping it simple. In the meantime, screen prints will of course be possible.
When will it be available

Watch this space, I will post here soon when this becomes be available and how to obtain it.