bboat11
Moderator
Pulse's Resident Martina McBride Expert
Joined: February 2013
Posts: 27,251
Pronouns: He/Him/His
Staff
|
Post by bboat11 on Jan 28, 2017 4:14:56 GMT -5
Hey born , would you please add a George Strait #1s Rankdown to the queue for me? :) With 60 #1s, his career is pretty much made for a rankdown! Lol! Also, zaclord is considering doing a 2005 year-end country rankdown after the 2015 one ends. ( zaclord 🌈 , do you officially want 2005 Country Year-End added to the queue, or are you still considering which year to do?) The 2005 one will wait until 2015 ends, and George can wait until Carrie ends :)
|
|
born
Diamond Member
can't come to the phone right now
BLACK LIVES MATTER
Joined: August 2014
Posts: 12,441
Pronouns: he/him
|
Post by born on Jan 28, 2017 5:31:10 GMT -5
The queue isn't anything binding, it just helps us keep track of our future Rankdowns etc. I'll definitely add that to the queue later today.
|
|
zaclord 🌈
Diamond Member
Jesus Jamz POTY
It'll all be alright...
Joined: July 2009
Posts: 10,791
|
Post by zaclord 🌈 on Jan 28, 2017 16:38:38 GMT -5
Yes, I'll do 2005 to start :)
|
|
matteeeb
3x Platinum Member
Joined: June 2015
Posts: 3,358
Pronouns: he/him
|
Post by matteeeb on Jan 30, 2017 23:42:21 GMT -5
Does anyone know how to find the average rank? Lol, I know it seems simple but im an idiot with math. Do I do the point score divided by the amount of people who participated or?
|
|
Deleted
Joined: January 1970
Posts: 0
|
Post by Deleted on Jan 30, 2017 23:47:34 GMT -5
Does anyone know how to find the average rank? Lol, I know it seems simple but im an idiot with math. Do I do the point score divided by the amount of people who participated or? Are you not doing this on google spreadsheets? If you do then you can highlight the ranks for a certain song and on bottom right it'll say stuff like sum or whatever and you can click it and then Change it to average. That's how I did my 2016 country rankdown but instead of points, I just used the points it gave me and didn't reverse it so the higher the points there was the lower the rank. That's just the way I did it and it was very easy for me. The only thing that took A while was putting everyone's ranks 1 by 1. I had to sort the song names by abc order to make it a little easier. Took like 20 min then an extra 20 for getting all the averages. But it's pretty simple Imo.
|
|
matteeeb
3x Platinum Member
Joined: June 2015
Posts: 3,358
Pronouns: he/him
|
Post by matteeeb on Jan 30, 2017 23:54:56 GMT -5
Does anyone know how to find the average rank? Lol, I know it seems simple but im an idiot with math. Do I do the point score divided by the amount of people who participated or? Are you not doing this on google spreadsheets? If you do then you can highlight the ranks for a certain song and on bottom right it'll say stuff like sum or whatever and you can click it and then Change it to average. That's how I did my 2016 country rankdown but instead of points, I just used the points it gave me and didn't reverse it so the higher the points there was the lower the rank. That's just the way I did it and it was very easy for me. The only thing that took A while was putting everyone's ranks 1 by 1. I had to sort the song names by abc order to make it a little easier. Took like 20 min then an extra 20 for getting all the averages. But it's pretty simple Imo. Yeah im using spreadsheet. Where do I fins the settings for this?
|
|
Deleted
Joined: January 1970
Posts: 0
|
Post by Deleted on Jan 30, 2017 23:58:17 GMT -5
Idk try to play around with it and see what you find. Not home right now but when I get home and if I remember I'll see if i can find it for you.
What settings are you looking for anyway? Just all the settings in general? They should be at the top of I'm not mistaken but I could be wrong.
|
|
matteeeb
3x Platinum Member
Joined: June 2015
Posts: 3,358
Pronouns: he/him
|
Post by matteeeb on Jan 31, 2017 0:06:26 GMT -5
Idk try to play around with it and see what you find. Not home right now but when I get home and if I remember I'll see if i can find it for you. What settings are you looking for anyway? Just all the settings in general? They should be at the top of I'm not mistaken but I could be wrong. Found it, but it looks really confusing. The help forum is no help either...
|
|
|
Post by Leaf on Jan 31, 2017 0:16:39 GMT -5
Idk try to play around with it and see what you find. Not home right now but when I get home and if I remember I'll see if i can find it for you. What settings are you looking for anyway? Just all the settings in general? They should be at the top of I'm not mistaken but I could be wrong. Found it, but it looks really confusing. The help forum is no help either... Try clicking on an empty cell and typing "=average(" without the quotation marks, then highlight all the numbers you want to take the average of, then hit enter. Alternatively, you could input the range of cell numbers (so like if you want the average numbers in the third row from column B to column R, you would type "=average(B3:R3)" with a colon between the two cells). If you choose the cell in the same row as the row that you are averaging, you can click and drag the little blue square (in the bottom right corner of the selected cell) up and/or down to get the averages for all the other songs.
|
|
born
Diamond Member
can't come to the phone right now
BLACK LIVES MATTER
Joined: August 2014
Posts: 12,441
Pronouns: he/him
|
Post by born on Feb 7, 2017 8:56:33 GMT -5
Is there anyone who wants to host a Rankdown but doesn't have any ideas?!?
|
|
Deleted
Joined: January 1970
Posts: 0
|
Post by Deleted on Feb 7, 2017 10:43:55 GMT -5
Is there anyone who wants to host a Rankdown but doesn't have any ideas?!? Me again. I'll host pink but there are way too many rankdowns going on right now. I'll prob host 2000s decade and 2007 one in future too. Maybe a urban 2016 as well. We will see.
|
|
matteeeb
3x Platinum Member
Joined: June 2015
Posts: 3,358
Pronouns: he/him
|
Post by matteeeb on Feb 7, 2017 14:21:49 GMT -5
A Coldplay one would be awesome!
|
|
Deleted
Joined: January 1970
Posts: 0
|
Post by Deleted on Feb 11, 2017 18:10:11 GMT -5
I have an idea for one maybe Only Songs that feature a certain artist, Nicki Minaj for instance has at least 50 songs she is featured in: so has Chris brown
|
|
.indulgecountry
Diamond Member
Best Country Poster 2011, 2017, & 2018
"You left a mark on my face // And brought a dozen red flags in a vase"
|
Post by .indulgecountry on Feb 11, 2017 18:28:29 GMT -5
I have an idea for one maybe Only Songs that feature a certain artist, Nicki Minaj for instance has at least 50 songs she is featured in: Oh I like this idea! If we do Nicki Minaj features anyway.
|
|
aerodynamite
4x Platinum Member
Joined: October 2016
Posts: 4,031
|
Post by aerodynamite on Feb 11, 2017 19:49:11 GMT -5
I'd love a Nicki Minaj features rankdown. There's quite a bit of variety, so that'll add to the fun.
|
|
Deleted
Joined: January 1970
Posts: 0
|
Post by Deleted on Feb 11, 2017 19:53:19 GMT -5
I'm here waiting for a Gaga Singles Rankdown even though it's gonna break my heart to have to rank one of the best single sets in history
|
|
born
Diamond Member
can't come to the phone right now
BLACK LIVES MATTER
Joined: August 2014
Posts: 12,441
Pronouns: he/him
|
Post by born on Feb 12, 2017 2:18:26 GMT -5
I like both of these ideas, especially the Gaga one. I just hope there's someone to host the Rankdowns. I can't host any Rankdowns before summer so someone has to do that.
|
|
zaclord 🌈
Diamond Member
Jesus Jamz POTY
It'll all be alright...
Joined: July 2009
Posts: 10,791
|
Post by zaclord 🌈 on Feb 14, 2017 11:34:00 GMT -5
Another idea for a country rankdown down the road: songs that never made the top 30 for a certain year so basically excluding all the hits and just ranking the songs that deservedly or undeservedly flopped on country radio. I think that would be fun to see how we rank songs when we exclude all of the superstars of the format :)
|
|
Leo ✔
Diamond Member
Julia Michaels Stan
Happy happy happy ♪
Joined: June 2016
Posts: 72,255
My Charts
Pronouns: He/him/his
|
Post by Leo ✔ on Feb 15, 2017 15:59:00 GMT -5
I wanna do Katy Perry's Rankdown
|
|
Deleted
Joined: January 1970
Posts: 0
|
Post by Deleted on Feb 15, 2017 16:01:26 GMT -5
Queue
2000s Decade Year End Top 100 Katy Perry Lady Gaga Nicki Minaj features 2016 Urban Coldplay
Any others I forgot?
|
|
|
Post by Willow Rinadoobee Breakfast on Feb 15, 2017 16:26:29 GMT -5
2009 and 2007 YE.
|
|
Deleted
Joined: January 1970
Posts: 0
|
Post by Deleted on Feb 15, 2017 16:46:33 GMT -5
And 2013 too possibly. How about every Rankdown from Year End on queue list since they could all end up happening.
|
|
bboat11
Moderator
Pulse's Resident Martina McBride Expert
Joined: February 2013
Posts: 27,251
Pronouns: He/Him/His
Staff
|
Post by bboat11 on Feb 15, 2017 17:35:14 GMT -5
Queue 2000s Decade Year End Top 100 Katy Perry Lady Gaga Nicki Minaj features 2016 Urban Coldplay Any others I forgot? Yeah, you forgot all the rankdowns that are in the actual queue ;)
|
|
Deleted
Joined: January 1970
Posts: 0
|
Post by Deleted on Feb 15, 2017 17:35:53 GMT -5
Oops, I fail then, lol.
|
|
YotamTS
2x Platinum Member
"It's funny how the music put times in perspective. Add a soundtrack to your life and perfect it"
Joined: December 2015
Posts: 2,503
|
Post by YotamTS on Feb 18, 2017 10:21:26 GMT -5
Maybe add the 2015 country and the starboy rankdowns to the finished? there are also the emotion, britney, maroon5 and 2011 rankdowns currently presenting results
|
|
Deleted
Joined: January 1970
Posts: 0
|
Post by Deleted on Feb 18, 2017 11:29:11 GMT -5
After Britney is over, I'd suggest starting either the Katy or Gaga Rankdown I'd love both cause I love like almost every single each has released
I'd also die if you included promo singles cause to Katy's that would add on more songs I love: Walking On Air, Circle The Drain, & Not Like The Movies And for Gaga: Beautiful Dirty Rich, Venus, Hair, Dope, & A-YO
|
|
Leo ✔
Diamond Member
Julia Michaels Stan
Happy happy happy ♪
Joined: June 2016
Posts: 72,255
My Charts
Pronouns: He/him/his
|
Post by Leo ✔ on Feb 19, 2017 11:22:18 GMT -5
^ Ill do Katy Perry
|
|
YotamTS
2x Platinum Member
"It's funny how the music put times in perspective. Add a soundtrack to your life and perfect it"
Joined: December 2015
Posts: 2,503
|
Post by YotamTS on Feb 19, 2017 11:36:54 GMT -5
I'll do a 2016 urban sometime in March probably
|
|
nick64
Diamond Member
Joined: November 2011
Posts: 14,418
|
Post by nick64 on Feb 19, 2017 19:18:01 GMT -5
Would anyone be interested in an album comparison rankdown? So like for example: BEYONCE v. Lemonade, you would rank all songs from both albums together, and see how they stack up in the end.
Some ideas I had: The Beyonce one above but we already did Lemonade 21 vs 25 Storyteller vs Piece by Piece Views vs Anti Revival vs Confident Artpop vs Prism Glory vs Joanne 1989 vs Teenage Dream Mind of Mine vs Last Year Was Complicated Purpose vs Made in the AM Flops Edition: Me. I Am Mariah. vs Rebel Heart
|
|
ry4n
7x Platinum Member
Joined: November 2014
Posts: 7,199
My Charts
Pronouns: he/him
|
Post by ry4n on Feb 20, 2017 22:57:58 GMT -5
Posting here to make it official You can add Az Paynter to the queue for Kelly Clarkson singles, and myself to the queue for Beyonce singles~
|
|