Here's the Mini League Spreadsheet for this season.



The spreadsheet functions exactly the same as the last seasons sheet. If you didn't use the sheet last season, please read the Instructions.

For OpenOffice users - Download & install the latest version of OpenOffice. Open the spreadsheet and go to the macro editor. Bearing in mind I've never used Open Office, try

Tools > Macros > Organize Macros > OpenOffice.org Basic. Then double click on ThisWorkbook while in the Macro Editor, and paste / type :-

Option VBASupport 1

into the code window which appears. That should mean VBA Support should load everytime you open the spreadsheet, and all the macros will work.

Cheers
Andy

Thanks a million. Much appreciated.

thanks great stuff.

Thanks Andi

Awesome, as always, Andi. Your work is much appreciated.

Great work again Andi, Thanks

Bumpety Bump, I know more than 88 people want this, it must be decent, no one is posting 'this is wrong' 'that is wrong', apart from Terry.

Thanks Andi. Great job again

For those in doubt, you now need to press the Finish P1 Scoring button, on the Players sheet. This will fix the scores in Column F. Additional points will now be added to Column G.

Hi Andi. Great spreadsheet again this year, real timesaver as always. Quick question, my spreadsheet is functioning fine after transfers etc. but the colours appear to be distorted on the main league table - quite a few are black, when should be green for moving up, red for moving down etc. Is there anyway to change them without ruining the formulas?

Thanks

Tom

It's time to press the Finish P2 Scoring button, on the Players sheet. This will fix the scores in Column F & G. Additional points will now be added to Column H.

Also,don't forget that anyone who dropped a player at the end of P1, but brings them back for P3, you will need to zero the players P2 score.

Andi,

I need to remove a few of the teams from my mini league who did not pay their entry fee, what's the proper way to do this without mucking up any of the formatting?

Regards,

Mark W

It's time to press the Finish P3 Scoring button, on the Players sheet.

Hi Andi,

Really sorry, I never did thank you for the fabulous spreadsheet.

It's been working a treat all season, even when I missed the transfer deadline at TW4 I was able to salvage the information.

Regards,

Mark W.

No problem, don't forget to press the Finish P5 Scoring button, on the Players sheet, before you update the scores Thursday morning.

There's a game tonight though.... So don't the scores need to be "finished" before that?

Yes, of course.......... the meaning of my post was hit the button before you update the scores, after tonights game, which is the 1st game of Period 6.