the calculation's not so much the problem, more just getting the shit into a spreadsheet
ok so first of all i want to be able to disaggregate the data so i want to preserve the ballots in the spreadsheet
i got five columns in my spreadsheet
they go: artist, song, remixer, points, voter
my method has been to import everyone's ballot in using hyphen and parenthesis as delimiters
theo parrish - falling up (carl craig remix)
becomes
theo parrish / falling up / carl craig
the nice thing about this is that i can then just copy in the assigned points in the fourth column and copy the voters' name into the fifth column
now the problem is that people have spaced their ballots all weird
one person might do
theo parrish - falling up
and another might do
theo parrish-falling up
and a third might do
which go into the spreadsheet as three different things: " falling up", "falling up" and " falling up", which jacks up the column sorting scheme
seriously though if somebody wants to enter all of this shit manually, that works for me
apologies everyone, i didn't anticipate being unemployed right now
― the late great, Friday, 13 July 2012 19:30 (eleven years ago) link
i nominate jaymc as official results calculator, he said he'd LOVE to do it
I do like tabulating stuff, but I'm pretty low-tech and math-dumb, so I'd pretty much be doing what Moka suggested.
― Never translate Dutch (jaymc), Friday, 13 July 2012 19:40 (eleven years ago) link
I saved my votes and could resend my vote with these guidelines artist, song, remixer, points, voter?
― JacobSanders, Friday, 13 July 2012 22:44 (eleven years ago) link
Who wants to post their ballot for me to fixate over?
― viborg, Saturday, 14 July 2012 06:56 (eleven years ago) link
I'd love to resend my ballot. I have 2 crucial entries that I'd like to put in.
― dan138zig (Durrr Durrr Durrrrrr), Saturday, 14 July 2012 09:56 (eleven years ago) link
has this just been swept under the carpet then?
― second only to popcorn (or something), Sunday, 29 July 2012 19:35 (eleven years ago) link
just give the dang data to someone who has offered to do it imo
― karl...arlk...rlka...lkar..., Sunday, 29 July 2012 21:12 (eleven years ago) link
someone who has offered to do it imo
no one who has offered to do it has followed up w/ a second webmail
alsoi've been
1) embarrassed to directly ask anyone
2) approaching the level of motivation i need to do it myself
3) crossing my fingers i'll get another flurry of ballots because honestly i feel like 35 voters is way less interesting than 50 voters3)
― the late great, Sunday, 29 July 2012 21:24 (eleven years ago) link
^^ part of it is my fucked up keyboard that is missing at this point five keys
― the late great, Sunday, 29 July 2012 21:25 (eleven years ago) link
make it v difficult to do serious detail work
it just needs a push in one way or another. i almost don't like anything i've voted for anymore.
― second only to popcorn (or something), Sunday, 29 July 2012 22:03 (eleven years ago) link
not sure what kind of push you're asking for pardner
― the late great, Sunday, 29 July 2012 22:32 (eleven years ago) link
I can't believe this is happening.
― dan138zig (Durrr Durrr Durrrrrr), Sunday, 29 July 2012 22:46 (eleven years ago) link
what????
― the late great, Sunday, 29 July 2012 22:47 (eleven years ago) link
nothing!!
― second only to popcorn (or something), Sunday, 29 July 2012 22:50 (eleven years ago) link
that there's even a possibility we wouldn't get to see the results
― dan138zig (Durrr Durrr Durrrrrr), Sunday, 29 July 2012 23:39 (eleven years ago) link
hey man don't put that on me
if you want i'll email you all of the ballots
― the late great, Monday, 30 July 2012 00:20 (eleven years ago) link
anyway
http://repairstemcell.files.wordpress.com/2012/04/there-is-always-hope.jpg
― the late great, Monday, 30 July 2012 00:21 (eleven years ago) link
I'll do it. Gotta learn the Excel thing but how hard could that be?
― Legendary General Cypher Raige (Gukbe), Monday, 30 July 2012 00:24 (eleven years ago) link
just give it to jaymc!
― ¥╡*ٍ*╞¥ (sic), Monday, 30 July 2012 00:57 (eleven years ago) link
or do a new deadline and another push for votes first
no, I'm not blaming anybody tbh. it's not like I can give a hand. sorry.
― dan138zig (Durrr Durrr Durrrrrr), Monday, 30 July 2012 03:15 (eleven years ago) link
I can tabulate -- but as I said, it would be rudimentary. But as long as we have results, that's good, right? Would prefer to have someone else actually roll out, though.
― Trewster Dare (jaymc), Monday, 30 July 2012 04:00 (eleven years ago) link
I'd be happy to roll out as long as ppl don't mind receiving their results ~from the future~
― ¥╡*ٍ*╞¥ (sic), Monday, 30 July 2012 04:18 (eleven years ago) link
late you have at least 5 people in here willing to do it for you.
here is my email adress motelmoka @ gmail
Send it to me and I'll have it done by wednesday.
― Moka, Monday, 30 July 2012 04:23 (eleven years ago) link
I second giving duties to Moka (thank you).
― azaera, Monday, 30 July 2012 05:13 (eleven years ago) link
do it.
― second only to popcorn (or something), Monday, 30 July 2012 11:22 (eleven years ago) link
That a yes?
― Moka, Tuesday, 31 July 2012 00:09 (eleven years ago) link
I have all the evening free so I might even get it done by tomorrow if you send the ballots right now.
i don't particularly want to be the one to say this but something doesn't feel quite right here.
― second only to popcorn (or something), Wednesday, 1 August 2012 19:24 (eleven years ago) link
?
― Chewshabadoo, Wednesday, 1 August 2012 19:35 (eleven years ago) link
So late never sent me the ballots. Sorry peeps I tried.
― Moka, Wednesday, 1 August 2012 19:36 (eleven years ago) link
i sent them just now to yr motel address
just to address what or something said, there is a long IRL hard luck story that involves unemployment, destitution, health problems etc but it's really neither here nor there
― the late great, Wednesday, 1 August 2012 20:41 (eleven years ago) link
sorry to sound like a dick but there was a huge lack of dialogue. hope it was nothing serious dude.
― second only to popcorn (or something), Wednesday, 1 August 2012 20:43 (eleven years ago) link
yeah I didn't mean to come off as a dick in pressuring or anything, just wanted to help out. I've also got health problems that have led to long-term unemployment and, consequently, some form of destitution so I feel ya.
― Legendary General Cypher Raige (Gukbe), Wednesday, 1 August 2012 20:46 (eleven years ago) link
there was a serious chance of being bankrupt and/or evicted and/or murdering my "best friend" who moved in w/o telling me he had no savings w/ which to pay rent but it seems to have passed
― the late great, Wednesday, 1 August 2012 20:47 (eleven years ago) link
When will these results be rolled out? Dont wish to step on anyones toes with the poll im doing and i believe theres an indie poll too
― Algerian Goalkeeper, Wednesday, 1 August 2012 21:20 (eleven years ago) link
what's this indie poll?
― Legendary General Cypher Raige (Gukbe), Wednesday, 1 August 2012 21:23 (eleven years ago) link
whoa whole lotta polls will start counting.
― Moka, Wednesday, 1 August 2012 21:25 (eleven years ago) link
i just read up a bit and it seems theres problems? sorry to hassle you.
gukbe i was informed there's an indie singles poll or something? i didn't know about it until i had decided to run my own poll (no its not an exclusively metal poll honest!)
Anyway i havent noticed a thread for it but i hadnt really been following ilm lately
― Algerian Goalkeeper, Wednesday, 1 August 2012 21:27 (eleven years ago) link
i think there's a 90s electronic poll too? So we're last in the queue so im hoping to work out when we can start voting. Hopefully before xmas haha
― Algerian Goalkeeper, Wednesday, 1 August 2012 21:28 (eleven years ago) link
Quick question:
Ranked ballots get 50 points 1st place and 1 vote 50th place, right?
I'm going to do a simple count. Only points per song and number of first place votes. Wont put the names of the voters next to each track.
― Moka, Wednesday, 1 August 2012 21:37 (eleven years ago) link
Only unranked ballot is citizen smith's. What do I do about that one?
― Moka, Wednesday, 1 August 2012 22:00 (eleven years ago) link
Give every song 25 points
― Frank O'Fiall (Nasty, Brutish & Short), Wednesday, 1 August 2012 22:04 (eleven years ago) link
"Ranked ballots get 50 points 1st place and 1 vote 50th place, right?"
I agree. Don't know about the others..
― dan138zig (Durrr Durrr Durrrrrr), Wednesday, 1 August 2012 22:46 (eleven years ago) link
Only 5 ballots so far. This takes more time than I thought. Usually I start placing the numbers as the ballots get in the mail. Doing it all at once is exhausting.
I quit.
― Moka, Thursday, 2 August 2012 02:50 (eleven years ago) link
just kidding. Hopefully I'll get final results by next week. Right now the top 10 is looking pretty weird safe for the first place which I'm sure will remain there.
― Moka, Thursday, 2 August 2012 02:51 (eleven years ago) link
hi moka, can I resend my ballot?
― dan138zig (Durrr Durrr Durrrrrr), Thursday, 2 August 2012 02:52 (eleven years ago) link
only if i havent counted it yet.
So far I've counted:
Mine, Lamp, Tuomas and some guys names Josiah and Matt (ilm alias wasnt provided).
Is your name Josiah or Matt?
― Moka, Thursday, 2 August 2012 02:59 (eleven years ago) link
also counted EDB and some Thomas cracklebox right now.
― Moka, Thursday, 2 August 2012 03:47 (eleven years ago) link