Thread for coordinating the order and timing of ILM ballot polls

could someone please send me that spreadsheet for calculating the results? i heard there's a super easy one to use.

Sent, to the poll address.

Thanks!

WmC, could you add the Italo one at the end of the list? thx

Can mods edit individual posts? So that the first post can have a link to the spreadsheet?

daavid, thanks for the reminder -- I've edited Italo onto the end of the updated list a few posts upthread.

Leee, the spreadsheet has been uploaded to various fileshare sites several times, but the DL links eventually expire, so I've just been emailing the .xls to folks as needed. I don't have a domain where I can park it permanently. Would Dropbox work for a permanent hosting spot? I see it used for images.

google docs?

Hmm, yeah, why not.

Here's Finefinemusic's spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AmhW_PgsyKKodGZkUi14NV9mYUZ2bUhyV29QU3hBV3c

I made it visible to anyone with the link, but not editable. I think whoever is doing a poll can Make A Copy/Save As and their copy would be editable.

I might edit the link into the OP after I've had more coffee.

56. US Indie Singles of the 1980s - NickB

I don't know quite what I was thinking of when I proposed this, but it's a daft idea, especially with those other 80s polls going on right now, so please can you delete me from the list WmC? Thanks!

Awwwww, I'm sorry Nick! By the time it comes round everyone will have forgotten the 80s poll.

with a bit of luck

:(

No matter what he thinks it's going to be a good poll and I hope you all enjoy it. and I hope nick changes his mind too.

nick you're still on for wang chung at 78 though, right?

I too think the 'under two minutes' poll would be great fun

I'm a little confused about the best way to use this spreadsheet. Do I just add each ballot manually when it comes in?

nick you're still on for wang chung at 78 though, right?

Now you're talking! My personal ranking:

Dance Hall Days >>>>>>> To Live and Die in L.A. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Let's Go > Everybody Have Fun Tonight

Here's how I did it (and advanced users please don't laugh at me too hard if any of it sounds dumb). Go to the Vote Weight tab (see there at the bottom) and select/copy the ranks 1-20 in column A. Go back to the Tracks tab and paste that 1-20 into column C, Rank, a bunch of times, as many times as you think you'll have ballots. You can always add more later. So you'll have a repeating list of 1 to 20 down as far as you need it.

As ballots come in, copy the ballot, go to the Song column (column B) and paste at the next available #1 ranking. The song will automatically be assigned a number of points (in column D, Points) based on its rank in column C. The best ballots are the ones that come in without numbers next to them, because what you want is just a list of song titles. If you get a ballot without a full 20 (hi clemenza!), just delete the rows between the last song on the ballot and the next #1.

You have to make sure you order by song name regularly to avoid vote splitting due to spelling/punctuation errors.

^^^ yes yes

Once all the ballots are in and entered, sort by song to see your total number of points. I never figured out how to use a pivot table, so at that point I transferred the song list to a new spreadsheet that included Album and Year columns, which would be the spreadsheet that everybody got a link to post-voting for datamining and such. Once that was all set up, sort by Points and there's your winning order.

Has there been a Smiths poll? Can anyone point me to it. Thanks.

"How soon is now" won, okthxbye

Would anyone be up for a Talking Heads + associated acts poll?

And you don't need to worry about resizing, ilx does it for you.

Depends on the stylesheet you're using. I use kenan_style.css and it doesn't seem to resize anything.

Hm, in that case sorry.

Would anyone be up for a Talking Heads + associated acts poll?

i was going to do Talking Heads but decided to do The Boo Radleys instead. i know less people will vote for in it but should be a blast to do...

I would vote in Talking Heads if anyone ran it. IMO it would be more interesting if it included solo albums, Tom Tom Club, etc.

On another matter at hand, Mordy's inclination (as best I can divine it) in the Joni Mitchell poll was for results not to roll out until approximately Oct. 10th. Any objection to getting the Neptunes poll rolling to run concurrently, if V79's schedule permits?

yeah if Talking Heads can play "Genius Of Love" and The Catherine Wheel songs in their concerts then that stuff might as well be eligible in a TH poll. we could even ::stifles smile:: make room for No Talking, Just Head ::loses composure, bursts into laughter::

I've been on a mini-PJH kick lately, very advanced prep-work for the poll, it seems!

Talking Heads has to happen sooner or later. I kind of assume it'll run itself somehow even if nobody volunteers.

There can't be too much overlap between Joni and The Neptunes, I'd guess they'd be fine to run concurrently.

Just to remind anyone who may be interested that voting closes for 1980'S ROCK POLL ALBUMS/TRACKS VOTING THREAD. (Voting closes September 20) (all welcome to vote inc Lurkers) on THURSDAY.

Thanks.

I've emailed V79 about the Neptunes poll, but his last ILX post was the one upthread a month ago, so I dunno.

does anyone want to do a YMO one??

I'm struggling a little bit to get the spreadsheet working. I'm able to input all the titles and everything, but I'm using Numbers (not Office) and can't figure out how to sort the columns alphabetically. Does anyone know how to do that in Numbers?

I've never used Numbers -- I was using OpenOffice until I discovered Google Docs was a million times easier. Are there contextual menus? Right-click on the column header bringing up Sort options?

No... I've hunted around and even googled for answers. Maybe I'll download OpenOffice this week and copy the ballots over.

I recommend Googledocs! Here's a copy of the basic poll .xls, just Save a Copy and go to town on it.

https://docs.google.com/spreadsheet/ccc?key=0AmhW_PgsyKKodGZkUi14NV9mYUZ2bUhyV29QU3hBV3c

(thx WmC for your email!)

been away from ILX again lately, but of course I'll gladly run the Neptunes poll for everyone's pleasure (there *are* people waiting for it, I guess?). If I could only ask for about 24 more hours for preparation? my poll knowledge needs a bit of dusting off, it's been a while for me (sadly)

No problem! This was short notice.

I see aero's voodoo curse is taking effect.

Did rock n roll die?

Apparently so.

Can we just skip ahead to Wang Chung?

Counting down Joni Mitchell poll here:
Oh I Wish I Had a POLL, I Could Skate Away On: The Joni Mitchell Tracks/Albums Results Thread (ILM ARTIST POLL #26)

Albums today, tracks over the rest of the week.

have been pretty excited about the Neptunes poll! V79 lemme know if you want any help or advice i can offer from my experience running the Timbaland poll. i was thinking i might start putting together a Neptunes discog playlist on Spotify. i'm really hoping you a) do a 'worst' sub-poll and b) include Pharrell and Chad solo productions.

scott walker poll would be nice too, especially maybe a month after bish bosch comes out.

someone do blue oyster cult svp

I emailed V79 again. Hope he's up for this even with sparse ILXing.

¯\(°_o)/¯