-
-
I tried to write a script to save the pages but I couldn't get something to work consistently. I bet Bobby Deez would know how to do it, because there was a long period where he was doing like 500 posts per day and he must have written something to do that.
What I ended up doing most weeks is going to each page, right clicking and hitting save as. This gave me a copy of each page locally as it stood at the time I saved it. I changed my settings to view 40 posts per page, so usually this only required me to save a few pages. Not too bad. The only inconvenience is that it required me to be vigilant about saving when the fight started since I couldn't make the poll close whenever I wanted.
Then I'd copy and paste from the saved poll page into an excel sheet and with it update the main sheet. Then I'd go through very quickly in the saved thread pages to look for posts with a multiplier or changed pick. Ideally if everyone follows the format for multipliers exactly, that part could be automated but in practice so many people did not that it actually made more sense to just thumb through the pages by hand.
Then the last step was a script that converted the main excel sheet into an HTML table formatted in a way that would look reasonable on the forum. I'd take that table and paste it into the OP.
The most expensive part was figuring who hadn't picked before and adding new rows to the main sheet for them. I had just figured an ugly way to automatically compare the list of names from spreadsheet for one fight with the main spreadsheet the last week I was in charge of the leaderboard.
Also, users who changed their names would show up twice in the leaderboard when doing it the way I did it. For a few regulars I just remembered who they were so I could change their name on my copy to their original name. EG. I would change 'DramaShow' to 'BigDramaShow' so that his new pick would be added to his existing row.Last edited by BrometheusBob.; 03-11-2018, 12:01 PM.Comment
-
Cheers BroBob, I knew you'd be automating it to a degree somehow, but I wasn't really sure how to start going about it. My script-writing skills are pretty much non-existent, but I'm usually fairly quick at picking stuff up if necessary. I've managed to get quite quick at inputting the data directly via the post editor, though it does require a fairly keen eye (I've found myself calling on the skills I ain't used since a job doing data entry back in my teens man, that's a long damn time). It works, but it's slow, carries a high chance of error (hence multiple back up screen shots), and perhaps most importantly for these purposes, ain't an easily transferable skill. Ideally we need a method which can be picked up with simple instructions by someone with very limited com*****g skills. Added to which any extra software needed would need be available to anyone who might need to do the job - I'm a free software kind of dude, for instance, so it's Libre Office on Linux for me, but another user might not be able to follow my instructions (if I eventually come up with them) using a different package.
For the time being, with Siablo or john compiling the results I managed to get last weeks inputted in a coupla hours, which is doable, but I'm just concerned that if I need to drop out for some reason we need a system which isn't too labour intensive in case we ain't got another OCD oddball ready to step in.Last edited by Citizen Koba; 03-11-2018, 01:25 PM.Comment
-
RESULTS FROM PICK EM #8 Scott Quigg vs Oscar Valdez & #9 Mikey Garcia vs Sergey Lipinets
As usual new players will only be added to the leaderboard if they have made at least one successful pick (ie for Valdez or Garcia). Players who are not already on the leaderboard will not be added if they picked unsuccessfully.
Players to be added to the leaderboard have been highlighted in red - although looking down the picks, I'm seeing very few new names this week.
an * by a player indicates that their leaderboard entry has been updated for this fight.
EDIT: New players added: kidbazooka, jpowell100Last edited by PICK EM CREW; 03-11-2018, 06:55 PM.Comment
-
I had a horrible week. 20 whole points on Mikey. Oh well I still got multipliers in my pocket and big fights to come!
#WLARA!Comment
Tweet
Comment