Football leagues Screen Shots

The Football Files Screen Shots

When the file is first opens if the user does not have the macros enabled then all that will appear is the following page

Welcome Page

Once the macros are enabled when the file is opened the start page is the instruction sheet.

All the other worksheets can be brought into use from the toggle buttons here and when not required can be hidden away again.

Instruction Page 1

Also on the page is the toggle button to adjust the Third positioning criteria (see Excel instructions page)

Instruction Page 2

Teams are Input via a separate worksheet which can be called and hidden again from the Instruction sheet. A particular team can be highlighted from the rest by placing the Team number into the appropriate cell on the Team Sheet. Also the League Header Name can be applied from this sheet

Team Input Page

Any Teams points can be individually adjusted e.g. for disciplinary measures via the Points Adjust Page

Points Adjust Page

Match Scores are Input to the Top table on the League Table Page and the bottom table showing the Positions will automatically adjust with each score input.

Top Score Table

Bottom Position Table

There is a Print Page which gives a smaller version of the two Tables which can be printed out.

Also these results can be used to publish to the web or a database. Please check out further details of this on the links top right.

Print Out Top

Print Out Bottom

If the 2 Home and 2 Away Option is to be used then on the Instruction page there is a League Table 2 identical to the League Table Page for the further matches and if used the scores from here will auto feed into the League Table page and the poition Table. There is a further Print Page 2 which will show the results for all these additional matches

The site for Excel Football Leagues

Instant Downloads Available

LEAGUES ONLY.com

Football leagues. Excel Automated. Self Positioning. Flexible scoring systems

Football items for sale now on ebay