somebody want to do this for me, i'm up to my neck in family / work / life bullshit IRL
― the late great, Saturday, 7 July 2012 09:22 (eleven years ago) link
I'll do it for you if nobody else wants to, but I'd rather let someone else do it - let's give it 24 hours to see if anyone volunteers
― Özil Gummidge (Nasty, Brutish & Short), Saturday, 7 July 2012 12:19 (eleven years ago) link
Yeah I can do it, depending on what "it" is. Starting a thread for/rolling out results is no problem.
― EDB, Saturday, 7 July 2012 14:02 (eleven years ago) link
do it!
― second only to popcorn (or something), Sunday, 8 July 2012 12:27 (eleven years ago) link
So....um......
― Özil Gummidge (Nasty, Brutish & Short), Wednesday, 11 July 2012 22:59 (eleven years ago) link
http://www.susanwhitcomb.com/wp-content/uploads/2011/05/impatient-interviewee.bmphttp://www.dreamstime.com/impatient-class-woman-with-silver-knife-and-fork-thumb7496316.jpghttp://static2.bigstockphoto.com/thumbs/7/0/1/large2/10761083.jpg
― EDB, Thursday, 12 July 2012 17:55 (eleven years ago) link
let's just forget about it, it was a shit idea in the first place.
― second only to popcorn (or something), Friday, 13 July 2012 00:12 (eleven years ago) link
House is a feeling, What Happened?
― JacobSanders, Friday, 13 July 2012 00:21 (eleven years ago) link
― second only to popcorn (or something)
otm
― the late great, Friday, 13 July 2012 00:25 (eleven years ago) link
late great, why don't you just pass the data to someone who's willing to calculate?
― dan138zig (Durrr Durrr Durrrrrr), Friday, 13 July 2012 00:34 (eleven years ago) link
I wanna know!
― Legendary General Cypher Raige (Gukbe), Friday, 13 July 2012 00:43 (eleven years ago) link
i would be happy to but afaict nobody wants to calculate
― the late great, Friday, 13 July 2012 00:48 (eleven years ago) link
i floated the idea upthread but got no webmails
I'll do it but I've never done it before and am not entirely sure what it entails.
― Legendary General Cypher Raige (Gukbe), Friday, 13 July 2012 00:55 (eleven years ago) link
ok do you have a gmail account? if so gmail me at the address at the top of the thread
the dot essential dot mix dot 77 at gmail dot com
replace dot and at with . and @
i can show you how to help and maybe we can divvy up the rest of the work
― the late great, Friday, 13 July 2012 00:58 (eleven years ago) link
sent
― Legendary General Cypher Raige (Gukbe), Friday, 13 July 2012 01:02 (eleven years ago) link
hi everyone
i had about half the votes put into a spreadsheet when excel crashed and i haven't had any luck recovering my work
one of the things that's making this so tedious and time-consuming is that i got the ballots in many different formats and reconciling them into a spreadsheet is taking a long-ass time
it would be much easier if the emails were all delimited in the same ways. apparently excel has extremely limited capabilities in converting delimited text to spreadsheet
any ideas?
― the late great, Friday, 13 July 2012 05:57 (eleven years ago) link
short of asking everyone to enter their ballots into a google spreadsheet themselves, which i haven't ruled out ...
― the late great, Friday, 13 July 2012 05:58 (eleven years ago) link
for my paul simon poll i just put everything into notepad and from there into excel where i had the formulas already input e.g. 1st = x points and the calculations for average placement &c &c so the only stuff i had to do by hand were the # of first place votes... i think i had to clean up a couple of ballots first but it was p easy
for the spec fic poll i had an access database set up but i still had to reformat some stuff by hand before i could sort and calculate
― Lamp, Friday, 13 July 2012 06:20 (eleven years ago) link
I'd suggest copying all the text to a text file, find and replace '-' with ',' and then saving that as a csv file.
When you open it in Excel the ',' will force cell divisions between each comma.
― du mein bestie (micarl), Friday, 13 July 2012 06:35 (eleven years ago) link
the problem is that half the people didn't follow that format, i have a lot of supposedly tab-delimited stuff that's actually not
― the late great, Friday, 13 July 2012 07:54 (eleven years ago) link
will using csv strip out the extra spaces in people's emails?
another problem i'm having is with inconsistent spacing
― the late great, Friday, 13 July 2012 07:55 (eleven years ago) link
If it's a question of just reformatting ballots in word and sending them back i can definitely do that
― EDB, Friday, 13 July 2012 09:40 (eleven years ago) link
In a text document you can find and replace double spaces with single spaces.
― du mein bestie (micarl), Friday, 13 July 2012 11:33 (eleven years ago) link
Don't use word to format.
txt to csv then excel once the formatting's done.
― du mein bestie (micarl), Friday, 13 July 2012 11:34 (eleven years ago) link
using textedit, it's really just a lack of consistency
― the late great, Friday, 13 July 2012 11:38 (eleven years ago) link
― the late great, Friday, 13 July 2012 01:25 (11 hours ago) Bookmark Flag Post Permalink
ftr i wasn't being entirely serious here but i'm glad we've got some dialogue going :)
― second only to popcorn (or something), Friday, 13 July 2012 11:47 (eleven years ago) link
I would LOVE to calculate, are you kidding?
― Never translate Dutch (jaymc), Friday, 13 July 2012 13:06 (eleven years ago) link
(But it sounds like there's stuff happening...)
― Never translate Dutch (jaymc), Friday, 13 July 2012 13:07 (eleven years ago) link
I've already said I'm happy to do it if nobody else wants to, but I'm happy to let someone else do it - it sounds like jaymc is that man.
― Özil Gummidge (Nasty, Brutish & Short), Friday, 13 July 2012 13:24 (eleven years ago) link
so, somehow i only just noticed this thread now...
― Porto for Pyros (The Cursed Return of the Dastardly Thermo Thinwall), Friday, 13 July 2012 13:35 (eleven years ago) link
... so if i could submit an incredibly late ballot, I'm not really clear on the ideal formatting for it.
― Porto for Pyros (The Cursed Return of the Dastardly Thermo Thinwall), Friday, 13 July 2012 14:14 (eleven years ago) link
I'm only getting 100 of the tracks on the Spotify play list Any help?
― broom air, Friday, 13 July 2012 16:36 (eleven years ago) link
You can do what I did. Make an excel list with all of the songs by alphabetical order and then start filling up the next column with numbers. So say if someone voted for 'song a' you put a 1 next to it and if in the next ballot someone voted for that one again you change it for a 2, and so on. It's a tedious process but that's the problem of not submitting through some sort of program first. (I cant remember who on ILM makes the polls that run through a webpage first that sorts results automatically).
Anyhoo you can do that and I'm willing to help you count the numbers, or you can ask everyone to resubmit their ballots in whichever format you need.
― Moka, Friday, 13 July 2012 17:04 (eleven years ago) link
Yea, why not tell us what format you want them in. Most should still have ballets in their sent items.
― du mein bestie (micarl), Friday, 13 July 2012 17:27 (eleven years ago) link
i nominate jaymc as official results calculator, he said he'd LOVE to do it
― karl...arlk...rlka...lkar..., Friday, 13 July 2012 18:34 (eleven years ago) link
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 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