What's new
Fantasy Football - Footballguys Forums

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

MixTape Draft - Back to School edition. Make your picks and post your mix! (1 Viewer)

3.xx  Steely Dan - My Old School

I remember the thirty-five sweet goodbyes

When you put me on the Wolverine

Up to Annandale

It was still September

When your daddy was quite surprised

To find you with the working girls

In the county jail

I was smoking with the boys upstairs

When I heard about the whole affair

I said oh no

William and Mary won't do


Well I did not think the girl

Could be so cruel

And I'm never going back

To my old school


Oleanders growing outside her door

Soon they're gonna be in bloom

Up in Annandale

I can't stand her

Doing what she did before

Living like a gypsy queen

In a fairy tale

Well I hear the whistle but I can't go

I'm gonna take her down to Mexico

She said oh no

Guadalajara won't do


Well I did not think the girl

Could be so cruel

And I'm never going back

To my old school


California tumbles into the sea

That'll be the day I go

Back to Annandale

Tried to warn you

About Chino and Daddy Gee

But I can't seem to get to you

Through the U.S. Mail

Well I hear the whistle but I can't go

I'm gonna take her down to Mexico

She said oh no

Guadalajara won't do


Well I did not think the girl

Could be so cruel

And I'm never going back

To my old school

 
Sorry, took a step away.

Going with an English class, in honor of the Yes induction to the RRHOF this weekend.

3.07 - Starship Trooper - Yes

While not exactly the same storyline as the Robert H. Heinlein novel, Jon Anderson was aware of the book when the song was written.

 
3.8 Aces High- Iron Maiden, History





There goes the siren that warns off the air raidThen comes the sound of the guns sending flakOut for the scramble we've got to get airborneGot to get up for the coming attack.Jump in the cockpit and start up the enginesRemove all the wheelblocksThere's no time to wasteGathering speed as we head down the runwayGotta get airborne before it's too lateRunning, scrambling, flyingRolling, turning, diving, going in againRun, live to fly, fly to live, do or dieWon't you run, live to fly,Fly to live, Aces highMove in to fire at the mainstream of bombersLet off a sharp burst and then turn awayRoll over, spin round to come in behind themMove to their blindsides and firing againBandits at 8 o'clock move in behind usTen ME-109's out of the sunAscending and turning out spitfires to face themHeading straight for them I press my guns.Rolling, turning, divingRolling, turning, diving, going in againRolling, turning, divingRolling, turning, divingRun, live to fly, fly to live, do or dieWon't you run, live to fly, fly to live, Aces high



 
With 3 Maiden songs(so far) Acerfc has already won the award for my fav mix of this draft. 

Going to be rough at the end of the draft- 10+ songs I planned to take aren't on Spotify.

 
@AcerFC - "Fixed" the summary sheets. For the sheet of the songs in alpha to solve the issue with the title row, I used a named range and added a ",1" to the end as that supposedly marks the 'header row(s)' and it seems to be working fine.

For the 'Artists by Alpha' I have it set to count the total number of songs per Artist.

Here is the query that I am using =Query(Draft, "select G, Count (F) Group By G", 1)

The 'Draft' is a named range for only the rounds we have done any drafting in (up to 3rd). This one is unfortunately counting the blank rows, and a row with 300+ for the total is annoying, so I limited the range, and it shows how many we still have to pick.

Can you get the select* where G <> '' or something like that into the 'Artists by Alpha' query, so we can have it running on the whole page?

Thanks!

 
Mr. Ected said:
@AcerFC - "Fixed" the summary sheets. For the sheet of the songs in alpha to solve the issue with the title row, I used a named range and added a ",1" to the end as that supposedly marks the 'header row(s)' and it seems to be working fine.

For the 'Artists by Alpha' I have it set to count the total number of songs per Artist.

Here is the query that I am using =Query(Draft, "select G, Count (F) Group By G", 1)

The 'Draft' is a named range for only the rounds we have done any drafting in (up to 3rd). This one is unfortunately counting the blank rows, and a row with 300+ for the total is annoying, so I limited the range, and it shows how many we still have to pick.

Can you get the select* where G <> '' or something like that into the 'Artists by Alpha' query, so we can have it running on the whole page?

Thanks!
Click to expand...
Im at the beach this week and dont have access to a computer. I would rather not play with anything on mobile. 

Plus, I think you are much more capable than I. I basically copied and pasted from an old jukebox draft I set up the querry for

 
AcerFC said:
Mr. Ected said:
@AcerFC - "Fixed" the summary sheets. For the sheet of the songs in alpha to solve the issue with the title row, I used a named range and added a ",1" to the end as that supposedly marks the 'header row(s)' and it seems to be working fine.

For the 'Artists by Alpha' I have it set to count the total number of songs per Artist.

Here is the query that I am using =Query(Draft, "select G, Count (F) Group By G", 1)

The 'Draft' is a named range for only the rounds we have done any drafting in (up to 3rd). This one is unfortunately counting the blank rows, and a row with 300+ for the total is annoying, so I limited the range, and it shows how many we still have to pick.

Can you get the select* where G <> '' or something like that into the 'Artists by Alpha' query, so we can have it running on the whole page?

Thanks!
Click to expand...
Im at the beach this week and dont have access to a computer. I would rather not play with anything on mobile. 

Plus, I think you are much more capable than I. I basically copied and pasted from an old jukebox draft I set up the querry for
Click to expand...
I'll look into it. Enjoy the beach!!!

 
Sticking on the East Coast, let's go with from Halifax born power pop specialists, Sloan. Nova Scotia is the most populous of Canada's maritime provinces. The ocean there is cold.

The N.S. - Sloan

But if you think that it's cold when you're swimming in the ocean
It's hard to believe you're a Nova Scotian boy!
Have you considered the cost of abusing your devotion?
And if we get lost we can find out
Where it was we used to be
We're following signs to the sea

 
Morning, Class.

Kris Kristofferson wrote this song with Marijohn Wilkin, and it would become a #1 hit in several countries including the United States. 

3.xx - One Day At A Time - Ivan Parker and Joy Gardner 

Some of you students must remember this popular chorus from the song, right? There may be a bonus question related to this song coming up on a test. 

One day at a time sweet JesusThat's all that I'm asking from You.Just give me the strength to do every day what I have to do.Yesterday's gone sweet Jesus and tomorrow may never be mine.Lord help me today and show me the way one day at a time.

 
Last edited by a moderator:
3.17 - The New Bomb Turks - Born Toulouse-Lautrec

Art History 101, Economic Theory

This one could have gone towards the back end of the draft easily (this was not likely getting sniped) but I've enjoyed it so much over the years that I figured I'd take it where it deserves to be taken around where the real meat of my mixes converge with my taste -- around the third round. Anyway, it's got some pretty nice word play, a Dr. Pepper jingle re-written into a Marxian declaration to flip snout at corporate America, and a general good sense of what it means to me an artist and get reimbursed for one's efforts in labor in a capitalist society.  

I had a friendHe said he was an artistLeast more than the average schmuckHe said he must have been givenA real giftWell I said that was just dumb luckAll work is honorableYet art is just a jobLet me spend my paycheck on a beerNo heroes, no leaders, no artists, no godsI'm a worker, you're a workerWouldn't you like to be a worker too?My work he saidIs so complexNot so much so he couldn't sell it at an auctionHe shuts his mouthAnd dotes awayI guess he serves to serve a functionAll work is honorable

Yet art is just a jobLet me spend my paycheck on a beerNo heroes, no leaders, no artists, no godsI'm a worker, you're a workerWouldn't you like to be a worker too?What's to thinkIs the difference betweenThe tortured artist or the union JoeFrom the market I live inTo the world I seeWhatever we reap we're lucky if we sowAll work is honorableYet art is just a jobLet me spend my paycheck on a beerNo heroes, no leaders, no artists, no godsI'm a worker, you're a workerWouldn't you like to be a worker too?
 

 
Last edited by a moderator:
Mr. Ected said:
You pick again, next after JZilla does his two!

Or if you want to do a redo, it's NBD.
Click to expand...


simey said:
Delete your song and redo.
Click to expand...
Naw, I'm cool, guys. Thanks for that. I put it there and did the write-up. I was being a little hyperbolic. I'm just thinking of sequencing now, but last mixtape we got to order at the end.  The other ones will be around. Thanks for that, though. I have a lot more to choose from than I thought. They kind of flash in and out of my head, fireflies in summer.  

 
Last edited by a moderator:
Go.. I have nothing.. my second choice will be there when I figure out a replacement for the femmes

Too sick to think

 
Okay, 

I'll roll with it. Hope you feel better, JZilla. This is one that announced a punk rock movement, almost as if the band reported from the front lines back to the inhabitants in safer areas. It's a metaphor from the division of the avant garde and the pedestrian, or at least that's how Wire themselves have described it in the book about this album that was excerpted just enough in Google Books. Love it.  

4.02 - Wire - Reuters

Journalism 301 - War Correspondent Edition  

Our own correspondent is sorry to tell
Of an uneasy time that all is not well
On the borders there's movement
In the hills there is trouble
Food is short, crime is double

Prices have risen as the government fell
Casualties increase as the enemy shell
The climate's unhealthy, flies and rats thrive
And sooner or later the end will arrive

This is your correspondent, running out of tape
Gunfire's increasing
Looting, burning, rape
Rape (repeat to militaristic march music)
 

 
Last edited by a moderator:
You must log in or register to reply here.

Similar threads

rockaction
Cinnamon To The Front Stage -- A Gentleman's Club Mix That Omits Hip Hop And Eighties Cheese (Mon Dieu!)
Replies
12
Views
932
Northern Voice
Northern Voice
cosjobs
Mix Tape Draft for your Wake or End of Life - now underway
12 13 14
Replies
674
Views
21K
Leroy Hoard
Leroy Hoard
Eephus
Desert Island "Discs" Draft (2010-2019) - We Did It
26 27 28
Replies
1K
Views
48K
rockaction
rockaction

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top