AntLog - double elimination result logging tool

Place discussions about upcoming events here in this thread.

Moderators: petec, administrator, BeligerAnt

User avatar
BeligerAnt
Posts: 2431
Joined: Wed May 15, 2002 12:00 am
Location: Brighton
Contact:

AntLog - double elimination result logging tool

Postby BeligerAnt » Sun Dec 06, 2009 5:25 pm

After much effort and some considerable wailing and gnashing of teeth, I have managed to automate Peter Waller's most excellent double-elimination charts, now the de-facto standard for AWS competitions (and most other antweight events).

AntLog is a spreadsheet template for OpenOffice.org, with macros built in to handle events from 16 to 48 entrants.

One other handy feature is that it tracks which order the fights happen in - very useful information when trying to edit the video!

The reasons for using OpenOffice rather than Excel are as follow (you may choose to disagree with me):
OpenOffice.org is free
OpenOffice.org is available for Windows, Mac and Linux
Not everyone has MS Office and not everyone runs Windows
I couldn't figure out how to get Excel to track the order in which the fights happen.

If you have OpenOffice.org, please download AntLog and the instruction sheet and have a play with it. This is the first release so there may well be a few "features" :wink:

http://garya.org.uk/antweight-robots

mirror at:

http://homepage.ntlworld.com/g0xan/robots/

The printable charts for those that don't wish to trust electrons are available here
Edit: Updated website link
Gary, Team BeligerAnt

User avatar
Craig_Anto3
Posts: 1399
Joined: Sun Feb 17, 2002 12:00 am
Location: Bristol
Contact:

Postby Craig_Anto3 » Sun Dec 06, 2009 6:01 pm

very good Gary
Image

User avatar
peterwaller
Posts: 3476
Joined: Fri Feb 15, 2002 12:00 am
Location: Aylesbury Bucks
Contact:

Postby peterwaller » Sun Dec 06, 2009 6:24 pm

That is going to save me a lot of work Gary well done. At the moment I have to print out 8 of each group size to cover every possibilty.
Just one thing where do I find the AntLog.odt

User avatar
BeligerAnt
Posts: 2431
Joined: Wed May 15, 2002 12:00 am
Location: Brighton
Contact:

Postby BeligerAnt » Sun Dec 06, 2009 8:04 pm

Sorry Peter, a bit of a typong probelm :oops:

The file is actually antlog.ots If you click on the "Download Antlog Tool" link it should download the .ots file. I will update the PDF file soon (but not on the same PC at the mo')

Other than that I think the instructions are correct. Let me know how it goes.
Gary, Team BeligerAnt

User avatar
EpicentrE
Posts: 1075
Joined: Mon Jun 09, 2003 12:00 am
Location: Coventry
Contact:

Postby EpicentrE » Sun Dec 06, 2009 8:58 pm

That's excellent Gary - just gave it a test run with random numbers and random names, and it all seems to work excellently. The only thing I noticed was that in the final, if the winner from the losers side wins, it counts that ant as the winner, whereas it should then just have a rematch (since both ants have lost one at this point), if you understand what I mean. I don't know whether this is important to implement this or if we can just remember, but it's something I thought I'd point out :P

Apart from that, great job!
Scott Fyfe-Jamieson, Captain of Epic Robotics. Champion of AWS38/41/42.
http://www.epicrobotics.co.uk

User avatar
peterwaller
Posts: 3476
Joined: Fri Feb 15, 2002 12:00 am
Location: Aylesbury Bucks
Contact:

Postby peterwaller » Sun Dec 06, 2009 8:59 pm

Still no luck.
I get the following directories in my download area.
antlog
.....Basic
.....Configurations2
.....Dialogs
.....META_INF
.....Thumbnails
The only file I get called antlog is antlog.xml and I get an error if I try to open it.

User avatar
BeligerAnt
Posts: 2431
Joined: Wed May 15, 2002 12:00 am
Location: Brighton
Contact:

Postby BeligerAnt » Sun Dec 06, 2009 9:49 pm

Scott, I tried to simplify things by just automating the predictable bits. So I didn't bother with the double final as it's a bit complicated. The important thing is to record the final winner. If I get some time & enthusiasm I'll give it a go.

Peter, it works for me, so I am struggling to find your problem.
What operating system and version of OpenOffice are you running?
Gary, Team BeligerAnt

User avatar
bobblebot
Posts: 267
Joined: Wed Jan 07, 2004 12:00 am
Location: Southampton, UK
Contact:

Postby bobblebot » Sun Dec 06, 2009 10:01 pm

Just to confirm it seems to work fine in OOo 3.1 on Mac OS X.

User avatar
BeligerAnt
Posts: 2431
Joined: Wed May 15, 2002 12:00 am
Location: Brighton
Contact:

Postby BeligerAnt » Mon Dec 07, 2009 8:10 am

Peter, thinking about it over night, maybe you need to right-click on the "Download AntLog Tool" link and select "Save target as..." or similar.
The OOo file format is compressed, and it looks as if your download is getting uncompressed. By just saving the file it should download intact. If still no joy I will email it to you tonight as it's only about 22kB.

Mike, thanks for confirming Mac OS X.
Gary, Team BeligerAnt

User avatar
peterwaller
Posts: 3476
Joined: Fri Feb 15, 2002 12:00 am
Location: Aylesbury Bucks
Contact:

Postby peterwaller » Mon Dec 07, 2009 9:55 am

I am using Windows Vista and OO3.1.
I get the zip file OK and it is 22k.
When I expand it I get the directories listed above.
When I look in those directories the only file named Antlog is Antlog.xml
If I double click this file I get:

The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------------------------------------------------------------
Access is denied. Error processing resource 'module.dtd'. Error processing resource 'file:///C:/antlog/Basic/Standard/AntL...

<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">

User avatar
EpicentrE
Posts: 1075
Joined: Mon Jun 09, 2003 12:00 am
Location: Coventry
Contact:

Postby EpicentrE » Mon Dec 07, 2009 10:19 am

A Zip file, Peter? The only file on Gary's Website for Antlog is just antlog.ots, which is here http://homepage.ntlworld.com/g0xan/robots/antlog.ots. Do you maybe have some compression software (Winrar or 7zip, maybe?) that's seeing the Open Office file as a compressed folder (as this is kind've how Open Office files work, in a way, I think) and uncompressing it? If so, if you just go to Open Office Calc, and file>open the file (before it's uncompressed) then this should work. I would also imagine there's a option somewhere in Open Office to re-associate the relative file type (.ots, in this case) with Open Office, if indeed that's what the problem is.

Hope this helps!
Scott Fyfe-Jamieson, Captain of Epic Robotics. Champion of AWS38/41/42.
http://www.epicrobotics.co.uk

User avatar
peterwaller
Posts: 3476
Joined: Fri Feb 15, 2002 12:00 am
Location: Aylesbury Bucks
Contact:

Postby peterwaller » Mon Dec 07, 2009 11:27 am

Cheers Scott that helped a lot.
Windows Vista insists that the file downloaded is Antlog.zip and if I double click on the file windows decompresses it.
I have tried renaming it Antlog.ots but it still tacks the .zip on the end.
The only way I have found I can run it is by going into Openoffice Calc and opening the file, then it all appears to work.
Gary this looks very good we will just need to ensure someone brings a laptop with them to events.
As to the double elimination on the final my charts never covered that and I am not really convinced that it is a good idea anyway. I beleive the final should be just that.

User avatar
peterwaller
Posts: 3476
Joined: Fri Feb 15, 2002 12:00 am
Location: Aylesbury Bucks
Contact:

Postby peterwaller » Mon Dec 07, 2009 11:38 am

It is even better with macro's enabled.

User avatar
EpicentrE
Posts: 1075
Joined: Mon Jun 09, 2003 12:00 am
Location: Coventry
Contact:

Postby EpicentrE » Mon Dec 07, 2009 11:55 am

I'm glad you managed to get it working, Peter. It's possible it's a Vista-specific problem, as I'm running Windows 7 and, as I said above, I had no problems with it whatsoever.

Gary, I think it's worth mentioning that Open Office seems to set macro security to high by default, meaning that it won't even ask you if you want to enable them. People will have to change the security level to medium, then open the file and select "Enable Macros" for it to work as intended.

About the final in double elimination, we've always done it that way. The entire point of double elimination is that you have to lose two fights before you're out of the competition, and it's only completely fair if that rule applies to every single robot, no matter what happens. The way our system is set up, you will always have a robot in the final that has not lost one fight, and a robot that has lost one. If the robot from the losers side then won, then both robots would have lost one each, making it even. Especially as it's possible to have two robots fight earlier in the competition, then again in the final (as with Void and Anticide at AWS30). If I'd won that first final fight, it would've been 1-1 between us. I think it's the difference of what "seems right" to the robots who are actually fighting, compared to what is logically fair in the scope of the whole tournament.

I don't mind it not being on the charts; at the end of the day the people who are running events know how the system they are using works - and it's obviously their jurisdiction which way they choose to do it.
Scott Fyfe-Jamieson, Captain of Epic Robotics. Champion of AWS38/41/42.
http://www.epicrobotics.co.uk

User avatar
leo-rcc
Posts: 469
Joined: Thu Aug 03, 2006 8:44 am
Location: Hoogvliet, The Netherlands
Contact:

Postby leo-rcc » Mon Dec 07, 2009 1:50 pm

EpicentrE wrote:I'm glad you managed to get it working, Peter. It's possible it's a Vista-specific problem, as I'm running Windows 7 and, as I said above, I had no problems with it whatsoever.


I am on Vista here and it downloaded it as a OTS file just fine.
Best regards,

Leo van Miert.
Dutchrobotgames
Team RCC website


Return to “Events”

Who is online

Users browsing this forum: No registered users and 1 guest