To help keep track of the world cup!!

xern · 30-09-2003 2:26pm #1

To help keep track of the world cup. just input the scores and it keeps track of all the tables!!

I havent fully tested it but it should work!!

Enjoy

Clinical Waste · 30-09-2003 2:32pm

Brilliant!
Thanks.

jonno · 30-09-2003 5:04pm

Does it calculate the bonus as well?

Clinical Waste · 30-09-2003 6:16pm

Ah,

I did find a bug which I thought you may wish to know.

Groups B, C and D do not record Draws, instead giving a win to the first team.
Group A however works perfectly recording draws.

And yes there seems to be a problem with the points:
http://www.rugby2003.com.au/background/tournament/rules.asp
Match points system:
The following number of match points will be awarded for each Pool phase match:
Win 4 points
Draw 2 points
4 or more tries 1 point
Loss by 7 points or less 1 point

As it stands this spreadsheet gives 3 for a win, 1 for a draw and no bonus' points.

Bummer.

xern · 01-10-2003 7:13am

Ah Feck it !!! I'll have to got on to who ever made it and get them to fix it!!!

Clinical Waste · 01-10-2003 7:34am

I think I've found another version (possibly by the same author -Logie) but with correct scoring.

http://www.scrum.com/rwc2003/spreadsheet/RWC2003.xls

xern · 01-10-2003 11:30am

that one seems to be much better. good stuff.

Hairy Homer · 01-10-2003 5:22pm

Cool.

I've always wanted to know how to do these. I have to use a really kludgy manual way of inputting the scores on mine.

The second one may work better but you can't see how he did it because the bugger protected the worksheet. Obviously not an Open Source head, eh?

The first one though let's you see how he did it. Even if it doesn't work absolutely properly.

Lots of fun working out what the Offset function does.

Clinical Waste · 01-10-2003 9:57pm

Actually, I emailed the author and got this reply this evening:

"You are using the prototype version, created in June and sent to a few friends. It does contain a few glitches and does not include the bonus points scoring system.
Obtain the up-to-date version from www.scrum.com
Regards,
Kevin"

eirebhoy · 05-10-2003 11:01am

I have downloaded the newer version of the spreadsheat but when I try to open it, first of all it say's selecr a worksheet and the only one listed is RWC2003 so I clicked that. But then I get a message saying:

This document is password-protected or encrypted.
Open it in the application that saved it, remove the password or encryption, then save it again. Then try open it again in works.

Any idea's what could be wrong?

Clinical Waste · 09-10-2003 10:49am

You need MS Excel.

It will not open in Works, because it is a protected document.

eirebhoy · 10-10-2003 8:49am

Is there anywhere I can download Excel for free? I always thought I had it on the computer but I must not. The best I could find was Microsft Excel Viewer which is a program to view files but you can't edit them.

Clinical Waste · 10-10-2003 9:06am

No.

But there are alternatives. OpenOffice etc... but not sure on their exact compatibility (esp for protected documents)

To help keep track of the world cup!!

Comments