Antweight Ranking Table

Post by **BeligerAnt** » Fri May 06, 2011 8:09 pm

OK, here are the results for AWS32, 33 and 34 with points applied per my algorithm described previously:

http://homepage.ntlworld.com/g0xan/aws-points/

The biggest problem will be inconsistencies in naming of robots. Not sure of the best way to overcome that one.

If someone with database-wrangling skills wishes to take up the reins now, I think it should be possible to generate an overall ranking automatically. The only manual data massaging that may be required is matching up spellings and capitalisation of robot names.

Maybe capitalisation can be fixed by forcing all the robot names in the import to all lower case, with another table to provide nicely capitalised names?

Simon Windisch · Post by **Simon Windisch** » Sat May 07, 2011 6:02 pm

I did it mostly manually. See http://www.windisch.co.uk/robots/wp-con ... -AWS34.pdf
Let me know if I made any glaring errors.

joey_picus · Post by **joey_picus** » Sat May 07, 2011 6:10 pm

...there is no way in Leeds that Jigsaw's the best current antweight XD

I can't see any glaring errors though, looks pretty statistically solid to me - maybe to get around the spelling/capitalisation issues the table could be updated manually? It'd only have to be done three times a year so there's no need for the responsiveness of having it all automated (unless I've vastly underestimated how much work it is, which I freely admit I might have done as computers aren't my forte

)

Simon Windisch · Post by **Simon Windisch** » Sat May 07, 2011 6:32 pm

Only took 20 minutes.

Note: When I came across different names/spellings/capitalisations for what was obviously the same robot or the same "bloodline" I renamed the robot to the name at AWS 32 or the stem name if it seemed more sensible.

daliad100 · Post by **daliad100** » Sat May 07, 2011 7:07 pm

I neeed to actually learn SQL for my computing exam and could possibly write a program to automate this.

Might give me something to do in my lessons.

joey_picus · Post by **joey_picus** » Sat May 07, 2011 7:40 pm

Actually, just spotted one error; Inersiant and Inertia 2 are different robots (and Inersiant competed at AWS34 as well - it lost to Spall somehow!)

Simon Windisch · Post by **Simon Windisch** » Sat May 07, 2011 10:36 pm

Hi Joey,

That was an early error, but I corrected it. If you refresh your browser you should see the change.

Simon

Simon Windisch · Post by **Simon Windisch** » Sun May 08, 2011 7:27 pm

Out of interest, here is AWS33 analysed by average wins versus Gary's scoring system. http://www.windisch.co.uk/robots/wp-con ... -match.pdf