Originally posted by -Kev-
View Post
Announcement
Collapse
No announcement yet.
NSB Pick 'em 2017
Collapse
-
Originally posted by jas View PostBob shall I ask BPP to see if he can get his programmers to look into making a automated prediction league which means you don't have to manually tally up the scores and predictions? Hopefully they can make the software
I had written some stuff for scraping and tallying the scores myself initially, then I transitioned over to an excel sheet where I copy and paste each new poll into a new sheet and have a macro that adds up points for every existing user that voted in the poll. The part that takes time is going over the names of the people who voted and finding who among them is new (and thus have not received credit automatically from above) and adding them to the sheet. There is probably some automatic way of doing this part that I haven't thought of yet.
There are a couple of usernames that make my macro results incorrect, and I then handle those by hand. I could probably fix the macro but I have been too lazy.
Then I quickly read through the comments in the thread as well as messages I received and put in everyone who put a multiplier or changed their pick from the one they put into the poll. This used to be done partially automatically but I found that I do it more accurately and quickly by hand.
Once the number of people who have received x pts in my master sheet lines up with the number of people who voted in such a way as to receive x pts, I then make a copy of the sheet, truncate off the columns for each indivudal fight's score and multipliers used. Then I convert the sheet to a csv and run a small script (just a couple of lines) that converts the csv to an HTML table that is formatted so that when I paste it into the OP you will see a reasonable enough looking table.
I have thought about writing a small independent app off of this site in order for it to be a 100% automatic process, but I wonder if people would want to go off site to participate in this contest.
But if someone else wants to put something together they are by all means welcome to take that upon themselves and fill me in on what they have.Last edited by BrometheusBob.; 07-12-2017, 05:06 PM.
Comment
-
Ah shiet I forgot about Eubank - Abraham
Ah well, Smith-Barrera and Berchelt-Miura are both better fights anyhow
Comment
-
The Pick 'Em fights for today at
Berchelt-Miura:
//krikya360.com/forums/s...d.php?t=751751
Joe Smith Jr - Sullivan Barrera
//krikya360.com/forums/s...php?p=17862090
I did a mention for players in roughly the top 100ish and/or have participated in at least half of the fights so far who did not place a vote yet for Smith - Barrera.
I may do another mention for Berchelt-Miura since the number of votes so far are quite low compared to recent pick em threads.
Comment
-
-
-
-
Yo billybob I think all the points may be messed up
Uneven numbers like chrismart got 479?
It might just be me but that don't add up
Shouldn't everybody's points be even numbers?
Some dudes got half a point haha
Comment
-
Originally posted by *TonyMontana* View PostYo billybob I think all the points may be messed up
Uneven numbers like chrismart got 479?
It might just be me but that don't add up
Shouldn't everybody's points be even numbers?
Some dudes got half a point haha
The half point you are referring to came from a bonus multiplier that wasn't an even number (1.75X).
Comment
Comment