Live Results?

IamWEB

IamWEB

Legend
Joined
Nov 22, 2008
Messages
2,853
Location
Right Here
WCA ID
2009BOAR01
YouTube
Visit Channel
Who needs to be contacted in order to use the live results system?
How can they be contacted?
Is there any particular reasons why they haven't been used lately? It's like a wave of live results systems showed up around here, and then they started dissapearing (at least from thread titles). Is there a price for using it (w/o webcams)?
 
Last edited:
I've created it and tried to use it at competitions with internet, but not every organizer has wanted to use it. My system is still somewhat messy, and needs some hackery to work. It also requires MySQL in order to run. I'm pretty sure Rafal's system uses mysql as well, but with mine, you can still use the normal competition xls file to enter data. If you are really set on using it, I can give you the code, but it would probably take a bit of work to get it working, which I'm not really prone on doing.
 
the code is all written, it just takes some basic hackery to the xls sheet to work correctly. If you also have python installed on your computer, i have an autouploader that uploads results at a specific interval. I should probably port it to jython/java but I really don't have the time/want to do this.
 
I know of the following main "live" results systems:
1) Rafal Studnicki's, used at Polish comps (and some others).
1a) My derivative. I used Rafal's code and customized it for SF09 and EPGY.
2) Uploading into the WCA database at the end of an event/day. Used at Worlds, and by Clement for Swiss Open, I think.
3) Dan Cohen's, which was written from scratch, and took the good features of my/Rafal's presentation.

Of these, I think mine was the fastest and most custom, as every single updated time was immediately updated online, too. However, turning the times into a spreadsheet could be much nicer.
I think Dan's system is the best, because it maintains the existing spreadsheet system, and can be kept in sync arbitrarily frequently.

If I ever get the time, I want to write a system essentially like Dan's, but as clean, usable, and portable as possible.
 
There's also the one I made for the Ohio Open (here), which I could give people the code for. Its literally just code I found that displays .xls files that I modified a bit, and wrote some extra code so you can see individual competitors results.

It is nice in that data is very easy to manage like Dan's, since it is all done on the spreadsheet (which the code just selectively displays fields from). It may not be the most 'efficient' code, but since there really isn't that much data in the spreadsheets, that really isn't an issue. One of the downsides is that it will display exactly what is on the spreadsheet, so it should be sorted, etc, before it is put online. Another plus is that all that has to be done to upload results is copying the file to wherever it is being read from. Only PHP required too, no mysql or anything.

I also need to touch up the CSS a bit for Chrome now, aparrantly...
 
Last edited:
I also did some minor changes in Rafal's system that we used for Danish Open 09. We didn't use the export to spreadsheet function so all times was entered in both in the live update and the WCA spreadsheet. (Thanks Trine!)
 
Ton said:
hr.mohr said:
I also did some minor changes in Rafal's system that we used for Danish Open 09. We didn't use the export to spreadsheet function so all times was entered in both in the live update and the WCA spreadsheet. (Thanks Trine!)
Click to expand...

With your help I can look if we can set it up for Czech Open....
Click to expand...

No problem Ton. Just let me know when :-)
 
masterofthebass said:
the code is all written, it just takes some basic hackery to the xls sheet to work correctly. If you also have python installed on your computer, i have an autouploader that uploads results at a specific interval. I should probably port it to jython/java but I really don't have the time/want to do this.
Click to expand...
Python FTW!!! :-)
 
Here's the script I wrote, for whoever is interested. It should be pretty portable, since all you need is a server with PHP (no mysql). It should also be very simple to get up and running, since it's just copy/paste the folder where you want it, and reference the spreadsheet. It should also be pretty easy to include in the theme of a site.

Feel free to edit it or comment. Script is here:
http://koii.cubingusa.com/cm/results.zip
Demo is here:
http://koii.cubingusa.com/cm/results/
 
JBCM627 said:
Here's the script I wrote, for whoever is interested. It should be pretty portable, since all you need is a server with PHP (no mysql). It should also be very simple to get up and running, since it's just copy/paste the folder where you want it, and reference the spreadsheet. It should also be pretty easy to include in the theme of a site.

Feel free to edit it or comment. Script is here:
http://koii.cubingusa.com/cm/results.zip
Demo is here:
http://koii.cubingusa.com/cm/results/
Click to expand...

Looks simple, can you ZIP it again in a compatible format I can not unzip it with WInrar or with Windows
 
Last edited:
Ton said:
Oke,

Can you check why I do not see the event in a test sheet for Czech
http://www.speedcubing.com/events/Czech2009/results/


A copy of the sheet http://www.speedcubing.com/events/Czech2009/results_WCA.xls
Click to expand...

It looks like the excel reader doesn't follow references to other sheets in the book; so every cell that has a formula that references another sheet it considers blank. I'll look into this more over the weekend; what you have done with the workbook is very interesting.
 
JBCM627 said:
Ton said:
Oke,

Can you check why I do not see the event in a test sheet for Czech
http://www.speedcubing.com/events/Czech2009/results/


A copy of the sheet http://www.speedcubing.com/events/Czech2009/results_WCA.xls
Click to expand...

It looks like the excel reader doesn't follow references to other sheets in the book; so every cell that has a formula that references another sheet it considers blank. I'll look into this more over the weekend; what you have done with the workbook is very interesting.
Click to expand...
 
I use the new short cuts for the name of the sheet

e.g You have a 2x2 sheet , I have 222 , the same name used in the WCA registration page. might this be the problem?


My results sheet has orginal much more in it, it was merged with the idea of Clement and Ron

So the sheets get the name directly of the registration sheet

My WCA sheet has the followings specs
-Results per event are automated filled in , when the event start you have to copy/ paste special the names as value to remove the formulas (else you can not sort)
-Make grouping list
-print scoresheet per event + the group
-Print Certifactes with the name and result, for this you need just prepared certifacates without the name and result
-Print result of all events per competitor, when uses it takes at least 60 min for 100 competitors to print, so I can not use this most of the times
 
Ton said:
I use the new short cuts for the name of the sheet

e.g You have a 2x2 sheet , I have 222 , the same name used in the WCA registration page. might this be the problem?

My results sheet has orginal much more in it, it was merged with the idea of Clement and Ron

So the sheets get the name directly of the registration sheet

My WCA sheet has the followings specs
-Results per event are automated filled in , when the event start you have to copy/ paste special the names as value to remove the formulas (else you can not sort)
-Make grouping list
-print scoresheet per event + the group
-Print Certifactes with the name and result, for this you need just prepared certifacates without the name and result
-Print result of all events per competitor, when uses it takes at least 60 min for 100 competitors to print, so I can not use this most of the times
Click to expand...

Yeah, I've been looking at your spreadsheet for a little while now... it is very ingenious. I may try using some of what you have done for future spreadsheets of mine.

The problem with the script is actually in the excel reader code... its former maintainer never bothered to handle some of the data. Fortunately, about a month ago, it looks like a new maintainer took over, and has (as of last month) released new code fixing this bug.

I've updated my script to incorporate this new version, which should fix the problem you were having. Same links as before^^
 
Last edited:
You must log in or register to reply here.

Similar threads

S
New York New Year 2024 Live Stream
Replies
0
Views
546
Silky
S
Lucas Garron
live.cubing.net - Live Results for your Official Competition
Replies
11
Views
7,291
Lucas Garron
Lucas Garron
C
Montpellier Open live results
Replies
1
Views
853
ryo
R
Matthew
Polish Nationals 2010 - Live Results
2 3
Replies
52
Views
13,256
Crazycubemom
Crazycubemom
Harris_Karsch
MIT Spring 2010 Live Results
2 3
Replies
40
Views
6,926
AlexandertheGreat
AlexandertheGreat
Back
Top