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

Flatulencno.

I have some spare time at the moment, so do you think it'd be okay if I already started the nominations thread for the 90s electronic tracks poll? Obviously I won't start the actual poll thread until after this one is over.

why not?

Okay, if no one's against it, I'll start the nomination thread soon.

Here you go:

1990s electronic music poll (tracks and albums): nomination thread

;_;

some real bullshit going on here: http://www.electrospective.com/

It was all good until about 1998.

I will roll this out if you want, V.

Why do the claim Tangerine Dream's Phaedra came out in 1967, when it was released in 1974?

they don't

Sorry to be tetchy, but is there a revised schedule for this or what?

be tetchy for us jaymc, someone had to

still so excited, you guys

be tetchy for us jaymc, someone had to

― karl...arlk...rlka...lkar..., Friday, July 6, 2012 1:13 PM (2 hours ago) Bookmark Flag Post Permalink

otm. i've posted like maybe twice in this whole thread but i really want this to staaart.

(taps watch)
.
.
.
.
(mutters)

somebody want to do this for me, i'm up to my neck in family / work / life bullshit IRL

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

Yeah I can do it, depending on what "it" is. Starting a thread for/rolling out results is no problem.

do it!

So....um......

http://www.susanwhitcomb.com/wp-content/uploads/2011/05/impatient-interviewee.bmp
http://www.dreamstime.com/impatient-class-woman-with-silver-knife-and-fork-thumb7496316.jpg
http://static2.bigstockphoto.com/thumbs/7/0/1/large2/10761083.jpg

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.