Alright, I made an excel file that should be useful, hopefully. http://www.megaupload.com/?d=ZQBPGXI6
Basically it's got a sheet where you dump in the songs and their ranks, and a formula that compares rank to point value which is listed on a separate sheet. Then there are suggestions and examples for making a pivot table to corral the data, or a suggestion for doing it manually.
I hope it's useful! /nerd
― she started dancing to that (Finefinemusic), Wednesday, 22 June 2011 15:11 (1 year ago) Permalink
^^if I didn't make it clear.. I'm really hoping someone will find it useful. This is why I chose computers over English ;)
I'll do Pulp at #4 if no one else objects? Understand if too close to Pulp/Manics/Boos. Mostly I just want to play with my Excel file now.
― she started dancing to that (Finefinemusic), Wednesday, 22 June 2011 15:13 (1 year ago) Permalink
― she started dancing to that (Finefinemusic), Wednesday, June 22, 2011 10:11 AM (6 minutes ago)
I'll say! I was dreading doing all that ciphering manually. Thank you!
― Mr. Patrick Batman (WmC), Wednesday, 22 June 2011 15:22 (1 year ago) Permalink
No problem. I've got this thread bookmarked so if there are any glitches, let me know!
― she started dancing to that (Finefinemusic), Wednesday, 22 June 2011 15:26 (1 year ago) Permalink
Neeto!
― Alpaca Lips (Johnny Fever), Wednesday, 22 June 2011 19:16 (1 year ago) Permalink
I love a good excel file. Been so jealous of jaymc.xls for so long!
― she started dancing to that (Finefinemusic), Wednesday, 22 June 2011 19:17 (1 year ago) Permalink
:-)
Ok, I thought about this long and hard, and I really want to host a Kate Bush songs poll. Put me down. I'm down.
― ...wow! (Le Bateau Ivre), Thursday, 23 June 2011 00:47 (1 year ago) Permalink
1. pet shop boys - billy dods2. Beatles - Mark G3. ________________4. Pulp - Finefinemusic5. Led Zeppelin - WmC6. Guided By Voices - Johnny Fever7. Kate Bush - Le Bateau Ivre8. _________________9. beach boys - iatee
― Mr. Patrick Batman (WmC), Thursday, 23 June 2011 01:29 (1 year ago) Permalink
a Pet Shop Boys Poll! My brain is already hurting.
― Gukbe, Thursday, 23 June 2011 01:31 (1 year ago) Permalink
excited about the zep/GBV/KB succession. i think i could really get behind all three of those.
― charlie h, Thursday, 23 June 2011 01:33 (1 year ago) Permalink
Oh shit wait. What is the timing of this? Because I'm getting married aug 20 and I feel like poll #4 will be mid august; I gotta swap out for a later spot, don't need added activities!!
― she started dancing to that (Finefinemusic), Thursday, 23 June 2011 01:54 (1 year ago) Permalink
You must delay the marriage!
― Alpaca Lips (Johnny Fever), Thursday, 23 June 2011 01:56 (1 year ago) Permalink
congratulations, finefinemusic!
― Iago Galdston, Thursday, 23 June 2011 01:56 (1 year ago) Permalink
These shouldn't take more than a week per, imo. Depends on whether you think late July will be stressful enough already.
― Mr. Patrick Batman (WmC), Thursday, 23 June 2011 02:03 (1 year ago) Permalink
It might be; month end at work and tying up loose ends (I'm not getting a lot of help planning this stuff, haha) but I can happily do a poll after September 20 (late honeymoon).
Thanks for the good vibes!
― she started dancing to that (Finefinemusic), Thursday, 23 June 2011 02:30 (1 year ago) Permalink
HEY! HEY!!! Put me down for Prince ;-)
― I'm A Genius, Too! (Jamie_ATP), Thursday, 23 June 2011 07:29 (1 year ago) Permalink
Pet Shop Boys are go!
― The multi-talented F.R. David (Billy Dods), Thursday, 23 June 2011 08:44 (1 year ago) Permalink
OK, after reading the Madonna: Classic or Dud thread, I totally want to do Madonna.
(OK, I've totally wanted to do Madonna for a while, but what I mean is, I want to run the Madonna poll. So long as I don't get SB'd off the board first.)
― Karen D. Tregaskin, Thursday, 23 June 2011 09:56 (1 year ago) Permalink
someone do Aphex pls - I don't think I have time, much as I'd like to.
― the Sandalled Vandal (dog latin), Thursday, 23 June 2011 10:13 (1 year ago) Permalink
I can't do both Madonna *and* Aphex, much as I would love to.
Don't make me choose. I still never voted in that taking sides poll.
― Karen D. Tregaskin, Thursday, 23 June 2011 10:16 (1 year ago) Permalink
OK, I'll do Aphex, if someone else takes Madonna.
Because although I'm probably more *familiar* with (most of) Aphex's (released) (acknowledged) work, I'm actually more *curious* about the hidden bits of Madonna's work that I don't know.
― Karen D. Tregaskin, Thursday, 23 June 2011 10:17 (1 year ago) Permalink
.. which would make you a better Madonna host.
Judjing by the "Alphabet Faves" thread, there's a lot of Aphex fans. Unless it's just because no-one could think of another A Artist.
― Mark G, Thursday, 23 June 2011 10:19 (1 year ago) Permalink
Yeah, but I think the Aphex poll would be easier to run. Lots of list-making nerds who will probably number and bulletpoint things so easily I don't have to do any work. While on the other hand, trying to squeeze a spreadsheet out of, fr'instance, the Lex is gonna be like pulling hen's teeth.
― Karen D. Tregaskin, Thursday, 23 June 2011 10:24 (1 year ago) Permalink
1. pet shop boys - billy dods2. Beatles - Mark G3. Prince - Jamie_ATP4. ______________5. Led Zeppelin - WmC6. Guided By Voices - Johnny Fever7. Kate Bush - Le Bateau Ivre8. _________________9. beach boys - iatee10. Pulp - Finefinemusic
Jamie, are you OK with Prince after the Beatles?
KDT, do you want spot #4 or #8 for whichever choice you make?
― Mr. Patrick Batman (WmC), Thursday, 23 June 2011 12:55 (1 year ago) Permalink
Thanks for adding me WmC!
Any approx idea when I the KB poll will commence? September?
― ...wow! (Le Bateau Ivre), Thursday, 23 June 2011 13:09 (1 year ago) Permalink
Pls slot Madonna in for No. 4
Please can Aphex Twin go in at No. 8 because after his last interview, we know he's just dying to be underneath Kate Bush. FnarGiggleSnort.
― Karen D. Tregaskin, Thursday, 23 June 2011 13:11 (1 year ago) Permalink
Ha! Can we read that somewhere?
― ...wow! (Le Bateau Ivre), Thursday, 23 June 2011 13:24 (1 year ago) Permalink
1. pet shop boys - billy dods2. Beatles - Mark G3. Prince - Jamie_ATP4. Madonna - Karen D Tregaskin5. Led Zeppelin - WmC6. Guided By Voices - Johnny Fever7. Kate Bush - Le Bateau Ivre8. Aphex Twin - Karen D Tregaskin9. beach boys - iatee10. Pulp - Finefinemusic
Dunno really, we'll have a better idea after the first couple have come and gone. My guess would be the 2nd half of August, but that's a very rough guess.
― Mr. Patrick Batman (WmC), Thursday, 23 June 2011 13:34 (1 year ago) Permalink
Shit, I revived a thread for ya, LBI but turns out it's on ILE:
I dreamed of kate bush
― Karen D. Tregaskin, Thursday, 23 June 2011 13:37 (1 year ago) Permalink
yay, thanks WmC! That seems much less stressful for me. :)
― she started dancing to that (Finefinemusic), Thursday, 23 June 2011 13:41 (1 year ago) Permalink
ty Kate :-)
― ...wow! (Le Bateau Ivre), Thursday, 23 June 2011 13:42 (1 year ago) Permalink
yep up for that
― I'm A Genius, Too! (Jamie_ATP), Thursday, 23 June 2011 14:13 (1 year ago) Permalink
1. pet shop boys - billy dods (Now in progress, voting closes July 2nd)2. Beatles - Mark G3. Prince - Jamie_ATP4. Madonna - Karen D Tregaskin5. Led Zeppelin - WmC6. Guided By Voices - Johnny Fever7. Kate Bush - Le Bateau Ivre8. Aphex Twin - Karen D Tregaskin9. beach boys - iatee10. Pulp - Finefinemusic
My own inclination for Zep was to allow 3 days for voting and 2 days for the reveal. Billy's 10-day vote window for PSB seems too long, but is my time frame too short?
― Mr. Patrick Batman (WmC), Thursday, 23 June 2011 14:57 (1 year ago) Permalink
You suggested 3 days right? I think that's too short. Needs to be a week, I think.
― ...wow! (Le Bateau Ivre), Thursday, 23 June 2011 16:39 (1 year ago) Permalink
I was originally going to go for a week, but that would mean finishing on a Thursday/Friday and I didn't want to roll out the results over the weekend, hence my extending it a few days. I agree with LBI I think 3 days is too short.
― The multi-talented F.R. David (Billy Dods), Thursday, 23 June 2011 18:18 (1 year ago) Permalink
Yeah, I'm coming around on that, 3 days is too short. Agreed on the weekday reveal as well. Obv everybody will wing it as needed for each ballot.
― Mr. Patrick Batman (WmC), Thursday, 23 June 2011 18:28 (1 year ago) Permalink
maybe it should be up to the person in charge of the poll...people have different schedules...but 1 week max?
― iatee, Thursday, 23 June 2011 19:01 (1 year ago) Permalink
I'm happy w/ how organized this ended up
― iatee, Thursday, 23 June 2011 19:02 (1 year ago) Permalink
imo long voting period (although more than a week isn't necessary) and brief reveal period is the way to go
― some dude, Thursday, 23 June 2011 19:34 (1 year ago) Permalink
^ Ignore this dude and his quest to rid the world of the unnecessary
― Food Processors Are Grebt (Nasty, Brutish & Short), Thursday, 23 June 2011 19:45 (1 year ago) Permalink
eh if we're gonna do these i do think there are better and worse ways to execute them
― some dude, Thursday, 23 June 2011 19:46 (1 year ago) Permalink
id like to see a sonic youth poll like this
― gman59, Friday, 24 June 2011 06:23 (1 year ago) Permalink
Sign up for #11!
― frogbs went a-courtin' (WmC), Friday, 24 June 2011 12:40 (1 year ago) Permalink
okay someone put me down for a "Producers" poll. I might need some help with this lol
― winoa ryder sexes creatures of the night (Shakey Mo Collier), Tuesday, 28 June 2011 19:15 (1 year ago) Permalink
yeah can we make sure the non-artist polls stick to this too?
― iatee, Tuesday, 28 June 2011 19:22 (1 year ago) Permalink
1. pet shop boys - billy dods (Now in progress, voting closes July 2nd)2. Beatles - Mark G3. Prince - Jamie_ATP4. Madonna - Karen D Tregaskin5. Led Zeppelin - WmC6. Guided By Voices - Johnny Fever7. Kate Bush - Le Bateau Ivre8. Aphex Twin - Karen D Tregaskin9. beach boys - iatee10. Pulp - Finefinemusic11. "Producers" - Shakey Mo Collier
left it in quotes 'cause it'll mean different things to different voters obv
at this pace, it'll be a late summer thing
― the presidential candidate inside me (WmC), Tuesday, 28 June 2011 19:23 (1 year ago) Permalink
iatee, you mean like label polls/ballots?
yeah
― iatee, Tuesday, 28 June 2011 19:24 (1 year ago) Permalink
My work schedule peaked last night for a few weeks; if anybody in #2-4 wants more time, I can trade with them, but no problem staying at #5 either.
― the presidential candidate inside me (WmC), Tuesday, 28 June 2011 19:27 (1 year ago) Permalink