13 Responses for "Graphs still drive me insane"

1. Anonymous January 31st, 2007 at 3:27 1

   if you plan on using excel, you need make columns C and D equal to the vote counts (i believe this is what that perl script does)

   set C1 to “=0+(A1=172)”
   set C2 to “=C1+(A2=172)”

   click C2, then use the little dot in the bottom right of the cell to to drag it down to the final row, which will expand the formula down the entire column. for column D;

   set D1 to “=0+(A1=173)”
   set D2 to “=D1+(A2=173)”

   then repeat the process. you should have four columns, the final two showing the cumulative vote count for each candidate at a given time. use “Format Cells” to change column Bs format to a time format. then select columns B, C, D and set up your line graph. or save as a csv and import into gnuplot.

2. mwgamera January 31st, 2007 at 11:58 2

   ‘tac’ is one of the standard commands in unix-like systems. It prints the file in reverse, last line becomes first.

   I did it this way, because you’ve provided SQL dump as a text file and I didn’t want to import it, just to use as is. However, probably much better would be to get this data directly from database with this script and prepare it for gnuplot in one step. In fact, this can be done with anything, even PHP on server-side would do (it may be even more comfortable). And of course this plot I’ve shown is very raw. It can be made less ugly with gnuplot, probably it may be even similar to this one made with excel (but to achieve this I would need to check the manual).

   At least, with gnuplot, you don’t need human interaction to generate plot, once you made a script. And it can be even automatically generated with use of cron or something like that.

   And unfortunately, I don’t know how do you run script with ActivePerl because I don’t have Windows.

3. Anonymous January 31st, 2007 at 15:57 3

   Try this: disqualify both. Problem solved. The end.

4. Beowulf Lee January 31st, 2007 at 23:33 4

   >>>Try this: disqualify both. Problem solved. The end.

   The point of the graph isn’t to decide whether to disqualify someone or not.

5. Beowulf Lee January 31st, 2007 at 23:33 5

   Or at least I hope not.

6. Anonymous January 31st, 2007 at 23:40 6

   No I’m sure it’s not about deciding legitimate votes. It’s just a way of showing how the battle progressed. And since we can’t see the running counts any more, it’d be cool to have graphs after each battle.

7. abq January 31st, 2007 at 23:54 7

   I think I give up. If the interest is there I could dump the relevant data each day and wait for some kind soul to do it and then put it in the post.

8. abq February 1st, 2007 at 1:05 8

   >mwgamera

   Get the data from the database with what script? I use phpMyAdmin when I have to mess around with the database.

9. Anonymous February 1st, 2007 at 5:56 9

   i think the graphs are cool, especially now that we’re voting blind. i’ll make graphs if you post the data.

10. abq February 1st, 2007 at 7:37 10

    Great. I will post Rika vs Fate when it is over.

11. Anonymous February 1st, 2007 at 7:56 11

    1. get gnuplot (http://www.gnuplot.info/)
    2. add it to PATH (in my computer->settings->something->environment variables append directory where gnuplot.exe is to PATH variable)
    3. save this -> http://phpfi.com/199379 as graph.pl
    4. add this line:
    (’Misuzu Kamio (Air)’,'Suigintou (Rozen Maiden)’)
    to your .sql file
    5. run cmd (start->run->cmd) and change dir to whereve you saved your .pl file
    6. enter following:
    andrey@a1111:~$ perl graph.pl wp_pollsip.sql battle
    and you’ll get battle.png file in same dir with your silly graph

12. mwgamera February 1st, 2007 at 19:38 12

    abq, You should post all data from previous battles as well.

13. abq February 1st, 2007 at 22:23 13

    Yay, I got it to work! I will go through the previous rounds eventually. Thanks anonymous (all of you?) and mwgamera