CharlieFlags

C1HT1N

It’s well known that the key change is a key feature of classic Eurovision, being a feature of some of the best Eurovision songs of all time (including the very best, Serbia’s 2007 winner Molitva). But what is it about the key change that makes it particularly… Eurovision-y?

I have a few ideas but would love to hear more:

1. It is a key change that happens at Eurovision. That is the most obvious, but I think there are other things too.

2. it usually happens about 2 minutes into the song. I can’t think of any early key changes?

3. it’s usually a big payoff. The song usually builds to that point and the key change is the big moment in the song.

Is there anything else? Are there any songs

Hey all! I’m looking for a bag that can take a couple of tennis rackets and a padel racket for days that I want to play both. It doesn’t need to have a specialist padel racket section, it just needs to be big enough that can have it in there. Ideally, it’ll also have a laptop sleeve/compartment but that’s more of a nice to have.

I’m thinking that a 6-racket tennis bag would be fine, but it would be good to hear any thoughts from anyone that does this regularly!

I’m also in the UK, if that influences availability. Thanks all!

I'm trying to find anywhere that sells tamales - so far none of the Mexican restaurants i know of (Cargo Cantina, Viva la Mexicana, Chido Wey) don't do them. Does anyone know of anywhere that does?? Thanks!!

It's results day! Congratulations to everyone getting results today - it's an exciting time.

I've worked in student recruitment at a university for the past four years, and i've given advice to hundreds of people about their university choices. I'd like to help out anyone here who's unsure on what to do or needs help with anything at all. (I'm happy to send proof of this to the mods if they like)!

Obviously i'm not speaking on behalf of my university, nor will i be saying what it is - you'll likely be able to guess if you trawl hard enough but being anonymous means i can be far more free with my answers rather than being attached to a particular university.

These threads have been real

Hi everyone,

TL;DR: This is the spreadsheet! Go to the 'Consensus Mocks' tab to see who is (basically) picked most commonly for each team. Alternatively, see my consensus-driven mock draft as a comment to this post.

https://docs.google.com/spreadsheets/d/1hbsJQ03HY0PXLCdGXdMsLRlvaLu4QwzDF6M7MkoRVVw/edit?usp=sharing

Intro

You may remember seeing this a while back, when the project was in its' infancy. As of right now, there are 850 mock drafts from all corners of the internet, fully loaded into one place for your viewing pleasure. There's also another interesting project using this data that will be coming in the near future, so look out on r/NFL_Draft for that - it s

Don't know if anyone has had a similar problem - i try to connect Spotify with Chromecast (2nd gen) and for some reason it doesn't connect, the screen stays black and eventually just goes back to the home screen. I've tried resetting both my phone (iPhone 6+) and the chrome cast, and then restoring the chrome cast to factory settings, and it's still happening. Anyone got any ideas?

Hi everyone,

TL;DR: This is the spreadsheet! Go to the 'Consensus Mocks' tab to see who is (basically) picked most commonly for each team.

https://docs.google.com/spreadsheets/d/1hbsJQ03HY0PXLCdGXdMsLRlvaLu4QwzDF6M7MkoRVVw/edit?usp=sharing

Intro

Since the Super Bowl, I have been collecting mock drafts from around the internet. These have been from a vast range of sources, including NFL analysts, professional sports writers, and this very subreddit. I will be continuing this up until the draft, posting my progress at major points in the process. I believe this is the single biggest database of mocks drafts anywhere on the internet - if there’s anything bigger, i’d lov

Hi there,

So i'm trying to count the number of names in a given column that would then print to another place in the sheet/workbook. I won't know the names in advance, and i would like the printed list to update as i add names. Then, next to those values, i'd like to count how many times they appear in the column. So as an example, this column:

Atlanta Falcons
Jaylon Smith
Reggie Ragland
Emmanuel Ogbah
Reggie Ragland
Emmanuel Ogbah
Darron Lee
Jaylon Smith
Jack Conklin
Braxton Miller
Jaylon Smith
Reggie Ragland
Vonn Bell
Jaylon Smith
Jayron Kearse

Would become:

Atlanta Falcons
Jaylon Smith          4
Reggie Ragland   

Title says it all - i'd like to do a project that ranks players based on their combine stats but i'm not sure where to go for them. Cheers!