review of nominations and VOTING for (very nebulously defined) ELECTRONIC DANCE TRACKS of the 00s

let's just forget about it, it was a shit idea in the first place.

House is a feeling, What Happened?

let's just forget about it, it was a shit idea in the first place.

― second only to popcorn (or something)

otm

late great, why don't you just pass the data to someone who's willing to calculate?

I wanna know!

i would be happy to but afaict nobody wants to calculate

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.

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

sent

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?

short of asking everyone to enter their ballots into a google spreadsheet themselves, which i haven't ruled out ...

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

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.

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

will using csv strip out the extra spaces in people's emails?

another problem i'm having is with inconsistent spacing

If it's a question of just reformatting ballots in word and sending them back i can definitely do that

In a text document you can find and replace double spaces with single spaces.

Don't use word to format.

txt to csv then excel once the formatting's done.

using textedit, it's really just a lack of consistency

let's just forget about it, it was a shit idea in the first place.

― second only to popcorn (or something)

otm

― 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 :)

i would be happy to but afaict nobody wants to calculate

I would LOVE to calculate, are you kidding?

(But it sounds like there's stuff happening...)

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.

so, somehow i only just noticed this thread now...

... so if i could submit an incredibly late ballot, I'm not really clear on the ideal formatting for it.

I'm only getting 100 of the tracks on the Spotify play list Any help?

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.

Yea, why not tell us what format you want them in. Most should still have ballets in their sent items.

i nominate jaymc as official results calculator, he said he'd LOVE to do it

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

theo parrish - falling up

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

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.

I saved my votes and could resend my vote with these guidelines artist, song, remixer, points, voter?

Who wants to post their ballot for me to fixate over?

I'd love to resend my ballot. I have 2 crucial entries that I'd like to put in.

has this just been swept under the carpet then?

just give the dang data to someone who has offered to do it imo

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 voters
3)

^^ part of it is my fucked up keyboard that is missing at this point five keys

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.

not sure what kind of push you're asking for pardner

I can't believe this is happening.

what????

nothing!!

that there's even a possibility we wouldn't get to see the results

hey man don't put that on me

if you want i'll email you all of the ballots

anyway

http://repairstemcell.files.wordpress.com/2012/04/there-is-always-hope.jpg

I'll do it. Gotta learn the Excel thing but how hard could that be?

just give it to jaymc!