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

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!

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.

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.

I'd be happy to roll out as long as ppl don't mind receiving their results ~from the future~

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.

I second giving duties to Moka (thank you).

do it.

That a yes?

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.

?

So late never sent me the ballots. Sorry peeps I tried.

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