This chart is based on a points system - 100 points for #1, 1 point for #100.

It encompasses the Official UK Top 100 Singles charts from week ending 10th January 2009 to week ending 2nd January 2010.

Yes, this chart has a bias towards songs released earlier, because they have more chart weeks that count here, but there's nothing I can do about this sadly.

 

To start, here's the chart from #76 to #200

 

#76) Pixie Lott – Boys And Girls [#1] // 1,044 points // 17 weeks

#77) Michael Jackson – Man In The Mirror [#2] // 1,041 points // 20 weeks

#78) N-Dubz – Strong Again [#24] // 1,031 points // 21 weeks

#79) The All-American Rejects – Gives You Hell [#19] // 1,023 points // 18 weeks

#80) Britney Spears – Circus [#13] // 1,016 points // 18 weeks

#81) Florence + The Machine – You’ve Got The Love [#13] // 1,015 points // 21 weeks

#82) Florence + The Machine – Rabbit Heart (Raise It Up) [#12] // 1,014 points // 16 weeks

#83) The Pussycat Dolls – Hush Hush; Hush Hush [#17] // 1,011 points // 15 weeks

#84) Tinchy Stryder ft. Amelle Berrabah – Never Leave You [#1] // 996 points // 14 weeks

#85) Katy Perry – Waking Up In Vegas [#19] // 983 points // 18 weeks

=#86) Akon – Right Now (Na Na Na) [#15] // 965 points // 19 weeks

=#86) Dizzee Rascal ft. Calvin Harris and Chrome – Dance Wiv Me [#31] // 965 points // 34 weeks

#88) Alexandra Burke ft. Flo Rida – Bad Boys [#1] // 961 points // 11 weeks

#89) Dizzee Rascal ft. Chrome – Holiday [#1] // 943 points // 15 weeks

#90) Deadmau5 and Kaskade – I Remember [#14] // 939 points // 20 weeks

#91) Empire Of The Sun – We Are The People [#14] // 937 points // 21 weeks

#92) Cheryl Cole – Fight For This Love [#1] // 935 points // 10 weeks

#93) Jay-Z ft. Rihanna and Kanye West – Run This Town [#1] // 934 points // 14 weeks

#94) Michael Bublé – Haven’t Met You Yet [#5] // 931 points // 11 weeks

#95) Take That – Greatest Day [#10] // 928 points // 22 weeks

#96) Lady GaGa – LoveGame [#19] // 887 points // 21 weeks

#97) Coldplay – Viva La Vida [#27] // 880 points // 23 weeks

=#98) Whitney Houston – Million Dollar Bill [#5] // 879 points // 12 weeks

=#98) Chipmunk ft. Emeli Sandé – Diamond Rings [#6] // 879 points // 16 weeks

#100) M.I.A – Paper Planes [#28] // 868 points // 21 weeks

#101) The Pussycat Dolls ft. Missy Elliott – Whatcha Think About That [#9] // 863 points // 13 weeks

#102) Lady GaGa – Bad Romance [#1] // 851 points // 9 weeks

#103) Chipmunk ft. Dayo Olatunji – Oopsy Daisy [#1] // 849 points // 12 weeks

#104) P!nk – So What [#17] // 840 points // 22 weeks

#105) The Guru Josh Project – Infinity 2008 [#18] // 836 points // 18 weeks

=#106) Dizzee Rascal – Dirtee Cash [#10] // 833 points // 13 weeks

=#106) Alexandra Burke – Hallelujah [#1] // 833 points // 18 weeks

#108) Britney Spears – Womanizer [#9] // 829 points // 22 weeks

#109) Kanye West – Heartless [#10] // 824 points // 15 weeks

#110) Girls Aloud – The Promise [#15] // 796 points // 20 weeks

#111) Linkin Park – New Divide [#19] // 786 points // 14 weeks

=#112) Ne-Yo – Mad [#19] // 779 points // 15 weeks

=#112) Ironik ft. Chipmunk and Elton John – Tiny Dancer (Hold Me Closer) [#3] // 779 points // 16 weeks

#114) Jay Sean ft. Lil Wayne – Down [#3] // 763 points // 9 weeks

#115) The Saturdays – Just Can’t Get Enough [#2] // 762 points // 14 weeks

#116) T.I. ft. Rihanna – Live Your Life [#12] // 754 points // 15 weeks

#117) Ke$ha – TiK ToK [#5] // 749 points // 8 weeks

#118) The Script – Breakeven [#21] // 745 points // 20 weeks

#119) Take That – Up All Night [#14] // 739 points // 13 weeks

#120) Westlife – What About Now [#2] // 734 points // 9 weeks

=#121) Girls Aloud – The Loving Kind [#10] // 732 points // 15 weeks

=#121) Madcon – Beggin’ [#34] // 732 points // 20 weeks

=#123) Calvin Harris ft. Mary Pearce – Ready For The Weekend [#3] // 728 points // 11 weeks

=#123) Flo Rida ft. T-Pain – Low [#44] // 728 points // 32 weeks

=#125) Esmée Denters – Outta Here [#7] // 714 points // 11 weeks

=#125) Take That – Rule The World [#45] // 714 points // 29 weeks

#127) Eminem – Beautiful [#12] // 711 points // 13 weeks

=#128) Freemasons ft. Sophie Ellis-Bextor – Heartbreak (Make Me A Dancer) [#13] // 707 points // 12 weeks

=#128) Britney Spears – If U Seek Amy [#20] // 707 points // 12 weeks

#130) Chicane – Poppiholla [#7] // 704 points // 11 weeks

#131) JLS – Everybody In Love [#1] // 699 points // 8 weeks

#132) Paolo Nutini – Pencil Full Of Lead [#17] // 697 points // 11 weeks

#133) Tinchy Stryder – You’re Not Alone [#14] // 693 points // 11 weeks

#134) Cheryl Cole ft. will.i.am – 3 Words [#4] // 682 points // 9 weeks

#135) Asher Roth – I Love College [#26] // 679 points // 12 weeks

#136) Taylor Swift – You Belong With Me [30] // 671 points // 16 weeks

#137) Steve Angello and Laidback Luke ft. Robin S. – Show Me Love [#11] // 666 points // 12 weeks

#138) Marmaduke Duke – Rubber Lover [#12] // 655 points // 10 weeks

#139) The Saturdays – Work [#22] // 652 points // 11 weeks

=#140) The Big Pink – Dominos [#27] // 651 points // 12 weeks

=#140) Paolo Nutini – Candy [#19] // 651 points // 15 weeks

#142) Jeremih – Birthday Sex [#15] // 647 points // 11 weeks

#143) Girls Aloud – Untouchable [#11] // 646 points // 11 weeks

#144) Paloma Faith – New York [#15] // 645 points // 10 weeks

#145) Lily Allen – 22 [#14] // 638 points // 12 weeks

=#146) Sugababes – Get Sexy [#2] // 634 points // 9 weeks

=#146) Muse – Uprising [#9] // 634 points // 13 weeks

#148) Miley Cyrus – Hoedown Throwdown [#18] // 633 points // 11 weeks

#149) Robbie Williams – Bodies [#2] // 628 points // 11 weeks

#150) Pixie Lott – Cry Me Out [#12] // 626 points // 8 weeks

#151) Mini Viva – Left My Heart In Tokyo [#7] // 624 points // 10 weeks

#152) Alesha Dixon – Let’s Get Excited [#13] // 617 points // 10 weeks

#153) Take That – Said It All [#9] // 615 points // 12 weeks

#154) Miley Cyrus – Party In The U.S.A. [#11] // 614 points // 9 weeks

#155) Beyoncé – Broken-Hearted Girl [#27] // 607 points // 12 weeks

#156) The Saturdays – Forever Is Over [#2] // 600 points // 10 weeks

=#157) Jordin Sparks – S.O.S. (Let The Music Play) [#13] // 587 points // 9 weeks

=#157) Green Day – Know Your Enemy [#21] // 587 points // 10 weeks

#159) Robbie Williams – You Know Me [#6] // 584 points // 7 weeks

=#160) Franz Ferdinand – No You Girls [#22] // 582 points // 10 weeks

=#160) The Pussycat Dolls – I Hate This Part [#20] // 582 points // 12 weeks

#162) Katy Perry – Thinking Of You [#7] // 581 points // 12 weeks

#163) Leona Lewis – Happy [#2] // 573 points // 7 weeks

#164) Peter Kay’s Animated All Star Band – The Official BBC Children In Need Medley [#1] // 569 points // 6 weeks

#165) Shontelle ft. Akon – Stuck With Each Other [#23] // 556 points // 14 weeks

#166) 3OH!3 – Don’t Trust Me [#21] // 553 points // 11 weeks

#167) Jason Derülo – Whatcha Say [#3] // 551 points // 6 weeks

#168) The X Factor Finalists 2009 – You Are Not Alone [#1] // 546 points // 6 weeks

#169) Flo Rida ft. Nelly Furtado – Jump [#21] // 544 points // 10 weeks

=#170) K.I.G – Head Shoulders Kneez & Toez [#18] // 543 points // 10 weeks

=#170) Kanye West – Love Lockdown [#28] // 543 points // 11 weeks

#172) Jamie T – Sticks ‘N’ Stones [#15] // 535 points // 12 weeks

=#173) N-Dubz – I Need You [#5] // 532 points // 7 weeks

=#173) Elbow – One Day Like This [#35] // 532 points // 27 weeks

=#175) Just Jack – The Day I Died [#11] // 526 points // 8 weeks

=#175) Jay-Z ft. Mr Hudson – Young Forever [#30] // 526 points // 12 weeks

#177) Chase & Status ft. Plan B – End Credits [#9] // 524 points // 8 weeks

=#178) Jordin Sparks – One Step At A Time [#16] // 522 points // 9 weeks

=#178) James Morrison – Please Don’t Stop The Rain [#33] // 522 points // 15 weeks

#180) Chris Brown ft. Lil Wayne and Swizz Beatz – I Can Transform Ya [#26] // 520 points // 8 weeks

#181) Calvin Harris – Flashback [#18] // 516 points // 9 weeks

#182) Michael Jackson – Billie Jean [#10] // 515 points // 9 weeks

#183) MGMT – Time To Pretend [#36] // 511 points // 13 weeks

#184) Michael Jackson – Thriller [#12] // 508 points // 11 weeks

#185) Britney Spears – 3 [#7] // 502 points // 7 weeks

=#186) Keri Hilson ft. Timbaland – Return The Favor [#19] // 498 points // 10 weeks

=#186) Little Boots – New In Town [#13] // 498 points // 11 weeks

#188) Example – Watch The Sun Come Up [#19] // 489 points // 8 weeks

#189) Mika – We Are Golden [#4] // 485 points // 7 weeks

#190) Rihanna – Russian Roulette [#2] // 478 points // 5 weeks

#191) Madonna – Celebration [#3] // 476 points // 7 weeks

=#192) Chipmunk ft. Talay Riley – Look For Me [#10] // 464 points // 6 weeks

=#192) Sugababes – About A Girl [#8] // 464 points // 7 weeks

#194) Jennifer Hudson – If This Isn’t Love [#37] // 453 points // 11 weeks

#195) Rihanna ft. Justin Timberlake – Rehab [#25] // 450 points // 10 weeks

=#196) Michael Jackson – Smooth Criminal [#13] // 448 points / 8 weeks

=#196) Daughtry – What About Now [#11] // 448 points // 9 weeks

=#198) 50 Cent ft. Ne-Yo – Baby By Me [#17] // 445 points // 6 weeks

=#198) Mumford & Sons – Little Lion Man [#24] // 445 points // 15 weeks

#200) Miley Cyrus – Fly On The Wall [#16] // 444 points // 10 weeks

 

I'll post #41 to #75 at 5:00, til then, I'll leave this topic to fester ;o

Edited January 8, 201015 yr by BrayFish

Whoop the B-Rye chart is back. :)

Whoop the B-Rye chart is back. :)

 

It is :lol:

It's a one-off though, unless I'm still around at the beginning of 2011.

Sorry to be ignorant but what is this based on. It's probably been on this forum for ages but I don't know. Sorry again

Sorry to be ignorant but what is this based on. It's probably been on this forum for ages but I don't know. Sorry again

 

Hmm I thought I'd explained it in the first post, but basically it's based on a points system for chart positions (nothing to do with sales).

 

If a song is #1 one week, it will get 100 points, #2 gets 99 points, #3 98 points etc. down to #100 which gets 1 point. This chart encompasses 52 sets of the UK Official Top 100 Singles Chart compiled by the OCC from w/e 10 Jan 2009 to w/e 2 Jan 2010.

Edited January 7, 201015 yr by BrayFish

Hmm I thought I'd explained it in the first post, but basically it's based on a points system for chart positions (nothing to do with sales).

 

If a song is #1 one week, it will get 100 points, #2 gets 99 points, #3 98 points etc. down to #100 which gets 1 point. This chart encompasses 52 sets of the UK Official Top 100 Singles Chart compiled by the OCC from w/e 10 Jan 2009 to w/e 2 Jan 2010.

 

Sorry didn't read the first post properly. My bad. :cry:

Here's #41 to #75... no ties here!

 

#41) Jay-Z ft. Alicia Keys – Empire State Of Mind [#2] // 1,332 points // 15 weeks

#42) Agnes – Release Me [#3] // 1,328 points // 19 weeks

#43) The Veronicas – Untouched [#8] // 1,325 points // 24 weeks

#44) The Temper Trap – Sweet Disposition [#6] // 1,324 points // 21 weeks

#45) MGMT – Kids [#16] // 1,292 points // 27 weeks

#46) Cascada – Evacuate The Dancefloor [#1] // 1,277 points // 18 weeks

#47) Beyoncé – If I Were A Boy [#4] // 1,257 points // 26 weeks

#48) Soulja Boy Tell ‘Em ft. Sammie – Kiss Me Thru The Phone [#6] // 1,255 points // 18 weeks

#49) Pixie Lott – Mama Do (Uh Oh, Uh Oh) [#1] // 1,248 points // 21 weeks

#50) Mr Hudson ft. Kanye West – Supernova [#2] // 1,233 points // 17 weeks

#51) P!nk – Please Don’t Leave Me [#12] // 1,222 points // 24 weeks

#52) Little Boots – Remedy [#6] // 1,206 points // 18 weeks

#53) Kelly Clarkson – My Life Would Suck Without You [#1] // 1,193 points // 17 weeks

#54) The Prodigy – Warrior’s Dance [#9] // 1,185 points // 24 weeks

#55) Taio Cruz – Break Your Heart [#1] // 1,175 points // 15 weeks

#56) P!nk – Sober [#9] // 1,174 points // 21 weeks

#57) Kasabian – Fire [#3] // 1,165 points // 22 weeks

#58) Jordin Sparks – Battlefield [#11] // 1,163 points // 17 weeks

#59) Shontelle – T-Shirt [#6] // 1,161 points // 19 weeks

#60) Sean Kingston – Fire Burning [#12] // 1,155 points // 19 weeks

#61) Miley Cyrus – The Climb [#11] // 1,136 points // 21 weeks

#62) Pitbull – Hotel Room Service [#9] // 1,127 points // 18 weeks

#63) The Saturdays – Up [#27] // 1,122 points // 25 weeks

#64) Eminem – We Made You [#4] // 1,116 points // 17 weeks

#65) Ciara ft. Justin Timberlake – Love Sex Magic [#5] // 1,104 points // 17 weeks

#66) Journey – Don’t Stop Believin’ [#7] // 1,097 points // 35 weeks

#67) The Saturdays – Issues [#4] // 1,091 points // 16 weeks

#68) Eminem ft. Dr. Dre and 50 Cent – Crack A Bottle [#4] // 1,090 points // 19 weeks

#69) Shakira – She Wolf [#4] // 1,088 points // 16 weeks

#70) Kevin Rudolf ft. Lil Wayne – Let It Rock [#5] // 1,079 points // 16 weeks

#71) The Ian Carey Project – Get Shaky [#9] // 1,074 points // 16 weeks

#72) The Black Eyed Peas – Meet Me Halfway [#1] // 1,068 points // 12 weeks

#73) Noisettes – Never Forget You [#20] // 1,065 points // 20 weeks

#74) Flo Rida ft. Wynter – Sugar [#18] // 1,049 points // 18 weeks

#75) Alesha Dixon – The Boy Does Nothing [#13] // 1,047 points // 22 weeks

 

I can confirm that 'Up' at #63 has ranked higher than all 5 of the Saturdays' more recent efforts - 'Issues' is #67, 'Just Can't Get Enough' #115, 'Work' #139, 'Forever Is Over' #156 and 'Ego' #261.

 

#21 to #40 shall be posted at 6pm. So exciting :drama:

Edited January 7, 201015 yr by BrayFish

Great chart but I have a slight urge to weight tracks released later in the year. Look at how badly Meet Me Half Way has done compared to say Up from The Saturdays...

Great chart but I have a slight urge to weight tracks released later in the year. Look at how badly Meet Me Half Way has done compared to say Up from The Saturdays...

 

I'd love to do this, but I have absolutely no idea how I could weight it effectively.

 

I had an idea of dividing the points by the weeks, but I realised that that would just make later releases more favoured - Joe would have 99.5 points, and 2nd place would be far behind, 96 points for 3OH!3. It would also disadvantage songs that entered in the low top 100 onalbum downloads and slowly climbed - or in the case of RATM (73.333... points) very quickly climbed. And songs which charted fairly high then completely vanished (Airi L 22-out, Honey Ryder 31-out etc.) would also have an unfair advantage.

 

Also, BEP have actually done extremely well to make the top 75 in just 12 weeks here, especially considering that one of those weeks it was #67.

Edited January 7, 201015 yr by BrayFish

Kings Of Leon for #1. :teresa:

I'd love to do this, but I have absolutely no idea how I could weight it effectively.

 

I had an idea of dividing the points by the weeks, but I realised that that would just make later releases more favoured - Joe would have 99.5 points, and 2nd place would be far behind, 96 points for 3OH!3. It would also disadvantage songs that entered in the low top 100 onalbum downloads and slowly climbed - or in the case of RATM (73.333... points) very quickly climbed. And songs which charted fairly high then completely vanished (Airi L 22-out, Honey Ryder 31-out etc.) would also have an unfair advantage.

 

Also, BEP have actually done extremely well to make the top 75 in just 12 weeks here, especially considering that one of those weeks it was #67.

 

 

yeah...dividing by weeks will just give you an average inverted position...if you know what I mean.

 

Whatever way you do it Joe and RATM would do well event hough they are obviously not going to be in the chart in three months time which isn't the point of the chart.

 

What I suppose would balance out is that if this was done on a rolling basis instead of just a 12 month chunk.

 

So each month a points chart is published of the previous 12 months. Then songs that sell over the new year would rise to a natural peak and then fall again.

 

 

yeah...dividing by weeks will just give you an average inverted position...if you know what I mean.

 

Whatever way you do it Joe and RATM would do well event hough they are obviously not going to be in the chart in three months time which isn't the point of the chart.

 

What I suppose would balance out is that if this was done on a rolling basis instead of just a 12 month chunk.

 

So each month a points chart is published of the previous 12 months. Then songs that sell over the new year would rise to a natural peak and then fall again.

 

That seems like a good idea, but I don't think I could quite cope with typing out a list of 200 every month :lol:

22-40 time...

With chart runs this time. ;D

 

#22) DIZZEE RASCAL AND ARMAND VAN HELDEN – BONKERS [#1]

1,618 points // 26 weeks

1-1-2-4-6-9-14-15-19-20-21-30-36-39-30-37-49-55-42-59-69-85-81-90-94-x(6)-100-

#23) ALESHA DIXON – BREATHE SLOW [#3]

1,616 points // 25 weeks

92-39-23-13-6-5-3-5-10-15-15-18-24-25-29-34-45-47-44-45-55-61-85-83-88-x

#24) DAVID GUETTA FT. AKON – SEXY BITCH [#1]

1,611 points // 20 weeks

21-1-2-3-2-2-2-3-5-10-13-18-24-31-36-35-43-47-59-52-

#25) LILY ALLEN – THE FEAR [#1]

1,591 points // 21 weeks

1-1-1-1-5-7-12-17-17-19-19-19-28-29-31-35-43-45-58-65-77-x

#26) TAYLOR SWIFT – LOVE STORY [#2]

1,575 points // 30 weeks

22-2-5-5-5-6-8-10-13-21-25-26-27-38-41-46-55-61-89-x(2)-92-85-79-82-91-89-90-x(3)-82-94-x(6)-88-78-x

#27) DAVID GUETTA FT. KELLY ROWLAND – WHEN LOVE TAKES OVER [#1]

1,567 points // 23 weeks

7-1-2-4-5-6-6-9-11-16-19-22-28-35-42-44-49-55-65-71-83-85-91-x

#28) KERI HILSON FT. KANYE WEST AND NE-YO – KNOCK YOU DOWN [#5]

1,565 points // 22 weeks

44-24-12-6-6-5-5-8-8-12-14-15-20-26-34-36-42-53-66-70-74-77-x

#29) LA ROUX – BULLETPROOF [#1]

1,556 points // 23 weeks

1-3-2-4-5-7-8-12-16-19-22-28-33-36-43-52-50-54-54-78-84-x(1)-69-87-x

#30) KID CUDI VS. CROOKERS – DAY ‘N’ NITE [#2]

1,507 points // 23 weeks

2-2-3-6-9-13-18-20-24-28-30-30-34-41-49-45-47-56-68-71-83-67-70-x

#31) METRO STATION – SHAKE IT [#6]

1,458 points // 26 weeks

94-54-37-22-9-6-8-9-11-15-14-19-22-25-29-35-41-64-85-93-77-76-85-74-76-88-x

#32) ENRIQUE IGLESIAS FT. CIARA – TAKIN’ BACK MY LOVE [#12]

1,404 points // 24 weeks

88-59-51-54-30-20-16-13-12-15-18-15-20-26-28-33-34-38-56-72-76-72-83-91-x

#33) FLO RIDA FT. KE$HA – RIGHT ROUND [#1]

1,387 points // 24 weeks

1-2-2-3-4-9-11-14-20-27-33-42-46-57-64-66-93-x(1)-92-75-71-77-84-65-79-x

#34) THE PRODIGY – OMEN [#4]

1,355 points // 21 weeks

8-4-11-12-16-15-19-21-26-31-36-41-40-30-41-51-59-63-58-88-x(9)-96-x

#35) T.I. FT. JUSTIN TIMBERLAKE – DEAD AND GONE [#4]

1,354 points // 20 weeks

88-58-47-30-17-4-6-7-6-7-10-14-17-25-28-37-46-60-70-89-x

#36) TINCHY STRYDER FT. TAIO CRUZ – TAKE ME BACK [#3]

1,353 points // 21 weeks

70-39-3-4-3-5-11-15-18-25-32-36-39-33-35-41-50-60-68-90-x(12)-91-x

=#37) PITBULL – I KNOW YOU WANT ME (CALLE OCHO) [#4]

1,350 points // 21 weeks

54-28-13-9-7-4-6-8-14-16-21-31-37-38-46-49-57-69-81-86-97-x

=#37) KATY PERRY – HOT N COLD [#7]

1,350 points // 25 weeks

7-9-15-18-22-18-23-29-31-33-34-40-46-53-52-58-67-70-66-72-73-76-96-82-85-x

#39) NOISETTES – DON’T UPSET THE RHYTHM (GO BABY GO) [#2]

1,348 points // 22 weeks

2-2-5-7-10-14-16-23-34-40-42-45-46-63-64-58-51-45-52-68-89-x(1)-98-x

#40) LEONA LEWIS – RUN [#2]

1,333 points // 31 weeks

2-4-9-12-20-26-31-38-43-55-32-43-62-57-56-67-75-69-75-76-88-96-x(14)-98-80-x(2)-73-80-87-x(1)-98-67-79-100-x

 

It's only 22-40 because believe it or not there's a tie at #20. How two songs could come up with exactly the same number of points when they're over 1,600 is a bit beyond me, but it happened :P

 

#11 to #20 (with videos) will be posted at 7pm, then the top 10 will be posted at 6 minute intervals from then on, so it'll be finished by 8pm. Fun! :lol:

Edited January 7, 201015 yr by BrayFish

That seems like a good idea, but I don't think I could quite cope with typing out a list of 200 every month :lol:

 

No way. Typing should never be done. Surely copy/paste is the way forward. And a Top 50 would do. I might consider doing it.

No way. Typing should never be done. Surely copy/paste is the way forward. And a Top 50 would do. I might consider doing it.

 

Actually yeah, copy/pasting would be more effective :lol: I could probably cope with doing a top 100.

 

In case you're wondering, I have a spreadsheet to work out the points and weeks, so if there are any errors it was me typing in the weekly positions wrong :P

do you use a pivot table to do it?

do you use a pivot table to do it?

 

I don't know what this means, but if it helps, the layout is this:

 

Column A = Artist

Column B = Song

Columns C-BB = Weeks 1-52

Column BC = Points (formula: =5252-SUM(C#:BB#)-((52-BD#)*101))

Column BD = Weeks (formula: =IF(C#,1,0)+IF(D#,1,0)+IF(E#,1,0)+IF(F#,1,0)+IF(G#,1,0)+IF(H#,1,0)+IF(I#,1,0)+IF... etc. I wish I knew a more concise formula for this but I'm not exactly an Excel whiz :lol:)

Column BE = Peak (formula: =MIN(C#:BB#))

# replaced by the row number

 

I'm backtracking through older years for my own personal interest/geekity/boredom, and I've started a new page for 2010 with the same formulas.

Edited January 7, 201015 yr by BrayFish

I don't know what this means, but if it helps, the layout is this:

 

There should be a quicker way to do it than that.

 

I am indeed an excel whiz. I will try and develop something. Although I dont have a working version of Excel...

 

I will have to buy one soon.

 

There should be a quicker way to do it than that.

 

I am indeed an excel whiz. I will try and develop something. Although I dont have a working version of Excel...

 

I will have to buy one soon.

 

Is there a formula to count the number of cells in a selection that contain data?

If there is I could make the formula in Column BD a hell of a lot shorter.

Edited January 7, 201015 yr by BrayFish

You know what, to bump up the post count and make it look like this thread has had more discussion (although what would you expect from a thread started by me :lol:) I'm going to count down the top 20 one by one, at 6 minute intervals, starting at 7:06pm.

 

The top 21 in alphabetical order by song are:

 

"Beat Again" by JLS

"Beautiful" by Akon ft. Kardinal Offishall and Colby O'Donis

"Boom Boom Pow" by The Black Eyed Peas

"Broken Strings" by James Morrison ft. Nelly Furtado

"Halo" by Beyoncé

"Human" by The Killers

"I Gotta Feeling" by The Black Eyed Peas

"I'm Not Alone" by Calvin Harris

"I'm Yours" by Jason Mraz

"In For The Kill" by La Roux

"Jai Ho! (You Are My Destiny)" by A.R. Rahman and The Pussycat Dolls ft. Nicole Scherzinger

"Just Dance" by Lady GaGa ft. Colby O'Donis

"Not Fair" by Lily Allen

"Number 1" by Tinchy Stryder ft. N-Dubz

"Paparazzi" by Lady GaGa

"Poker Face" by Lady GaGa

"Red" by Daniel Merriweather

"Sex On Fire" by Kings Of Leon

"Single Ladies (Put A Ring On It)" by Beyoncé

"Sweet Dreams" by Beyoncé

"Use Somebody" by Kings Of Leon