UK Singles Charts: 1985 (including chart panel sales)

[Jesse'77]

So last night (30/12) i started to add the lower 76 - 200 figures from the wonderful weekly charts spreadsheet using kobyhadrians charts to hanboo's database.which i have copied into an excel spreadsheet. Boy did i ever underestimate how many times 'Love Will Tear Us Apart' re-entered between 83 and 85. Thank goodness no one ever had the foresight to ask hanboo at the time for an Ann Breen chart run as i might lose the will to live typing in all the times 'Pal Of My Cradle Days' re-entered. Back to adding by artist and anything that needs to be updated i can update as i go along.

[Robbie]

Apologies, I didn't realise I had filtered the file to the chart for 23-03-1985. I'm not sure why I've filtered it to that date either. I possibly chose a random chart to make sure the filter was working and then forgot to change it back.

I've amended the file and have reuploaded it. You should be able to view all of the 1985 charts now.

https://www.dropbox.com/scl/fi/d7bh1...y81nq8sj1bnzp3

[xymox970]

Many thanks for those tips!

This time it will surely work!

[kingofskiffle]

Hmmm.......I`using Excel Viewer......could that be the problem ?

Oh probably. You can use OpenOffice (which is free) or upload into a Google Drive account to similarly remove it. If your on Mac the file will open in Pages and and do the same thing.

[xymox970]

Hmmm.......I`using Excel Viewer......could that be the problem ?

[kingofskiffle]

I did download it and saved it to my computer.

Well.....I must be doing something wrong then, because that link in post #532 appears to contain only the chart for 23-03-1985.
I cannot scroll up or down to find the complete 1985 chart.

That's because the file is filtered. Somewhere in the excel settings - depends on your version - is a button called Sort and Filter - usually on the ribbon to the right. Press, remove filter, and there you go.

[xymox970]

The link in my post turned out to be the final version. It's in an excel format - you need to click download to save it to your computer.

I did download it and saved it to my computer.

Well.....I must be doing something wrong then, because that link in post #532 appears to contain only the chart for 23-03-1985.
I cannot scroll up or down to find the complete 1985 chart.

[Robbie]

Hi Robbie

any chance you could upload the 1985 chart in excel format soon or do you plan to put it together with 1986 once it is done ?

Thanks!

The link in my post turned out to be the final version. It's in an excel format - you need to click download to save it to your computer.

[xymox970]

Just adding a quick update. I haven't forgot about adding the 1985 charts to Dropbox but I haven't had the time this weekend to do any checking. This is a draft of the file. Once I've had a chance to check through it I'll upload the final version, which will also include the 1983 and 1984 weekly charts. That said, it should be hopefully free from (many) errors as it is the spreadsheet I used to copy and paste the charts I posted each day, though that means any errors in the weekly charts will be replicated here. As an added bonus, the file also contains the catalogue numbers of the 7" versions of each chart entry (or 12" version if no 7" was released).

Again, the multiplier used is 17 (more on multipliers later today or tomorrow in the 1986 thread) and the charts can also be filtered by date if downloaded as an excel file.

https://www.dropbox.com/scl/fi/bzv64...zq662btudmq9qo

Hi Robbie

any chance you could upload the 1985 chart in excel format soon or do you plan to put it together with 1986 once it is done ?

Thanks!

[seanyboy]

For the 1985 year end chart, Gallup combined sales of the 1985 re-release with the 1984 original. The 1985 re-release meant a new chart run but it's possible that sales of the 1984 original were included in those weekly sales. There were so few copies of the original remaining that it's hard to tell.

Thanks for the reply. My original point was that on the year end chart published in this thread at No. 33 is Wham's 'Last Christmas' (peak No.6, 6 weeks on chart, 20,902 points which equates to 355,344 sales).
A quick scan of the 1985 charts shows 'Last Christmas / Everything She Wants' started the year at No.2 and spent 33 weeks on the Top 200; the re-issue did peak at No.6 with 6 weeks on chart. The majority of its 1985 points/sales come from the 1984 original double A sided single.

[Robbie]

Just adding a quick update. I haven't forgot about adding the 1985 charts to Dropbox but I haven't had the time this weekend to do any checking. This is a draft of the file. Once I've had a chance to check through it I'll upload the final version, which will also include the 1983 and 1984 weekly charts. That said, it should be hopefully free from (many) errors as it is the spreadsheet I used to copy and paste the charts I posted each day, though that means any errors in the weekly charts will be replicated here. As an added bonus, the file also contains the catalogue numbers of the 7" versions of each chart entry (or 12" version if no 7" was released).

Again, the multiplier used is 17 (more on multipliers later today or tomorrow in the 1986 thread) and the charts can also be filtered by date if downloaded as an excel file.

https://www.dropbox.com/scl/fi/bzv64...zq662btudmq9qo

[Robbie]

Excellent work compiling these charts.

I was just wondering if you will be able to make an additional xlsx document with all weekly Gallup charts for 1985 as you previously did with 1983 and 1984 ?

Many thanks!

I will do. I'll try and do it in the next few days. The document is there already, I just need to tidy it up a bit and will then make it available to download.

[xymox970]

Excellent work compiling these charts.

I was just wondering if you will be able to make an additional xlsx document with all weekly Gallup charts for 1985 as you previously did with 1983 and 1984 ?

Many thanks!

[Robbie]

Just enquiring peak of No.6 and 6 weeks on chart; and are the year end sales for both "Everything She Wants / Last Christmas" from 1984 and the re-issue from November 1985?
Cheers.

For the 1985 year end chart, Gallup combined sales of the 1985 re-release with the 1984 original. The 1985 re-release meant a new chart run but it's possible that sales of the 1984 original were included in those weekly sales. There were so few copies of the original remaining that it's hard to tell.

[seanyboy]

Best Selling Singles 1985

33	6	6	Last Christmas	Wham!	20902	355,334

Just enquiring peak of No.6 and 6 weeks on chart; and are the year end sales for both "Everything She Wants / Last Christmas" from 1984 and the re-issue from November 1985?
Cheers.

[Robbie]

I guess that dance tracks such as Jingo sustained their popularity by being played at clubs & discos (although I have to admit I had never heard, or even heard OF 'Jingo' until several months ago when I noticed it was one of the enduring 'bubblers' and decided to give it a listen. Pleasant enough, I thought, but it didn't immediately scream "classic" at me....)

'Jingo' by Candido was one of the most enduring dancefloor hits in clubs during the whole of the 1980s. The single was originally released in August 1979 and was regularly re-issued / re-pressed during the 1980s to meet demand. The track was a top 20 hit for Jellybean in 1987/88.

[UnfazedPenguin]

I guess that dance tracks such as Jingo sustained their popularity by being played at clubs & discos (although I have to admit I had never heard, or even heard OF 'Jingo' until several months ago when I noticed it was one of the enduring 'bubblers' and decided to give it a listen. Pleasant enough, I thought, but it didn't immediately scream "classic" at me....)
Marillion built up their fanbase by consistent touring, and I imagine they sold a fair few records to satisfied gig-goers. I think 'Market Square Heroes' and its B-side were both non-album tracks, which probably helped too.
(In fact, it might be interesting to plot the links between bands' tour dates and the reappearance of their singles in these charts?)
I always thought that U2 missed a trick in '85: If they had rushed into a studio and brought out a new single straight after Live Aid, I bet they could have had their first No.1. Instead, they were right at the tail-end of the 'Unforgettable Fire' period.
Tracks like 'Jimmy Mack' could have been popular in Northern Soul clubs?
...But the endurance of Ann Breen's 'Pal' still stumps me! How (and to whom) was it marketed? Was it played in Irish Centres up and down the country? I've seen ladies take the microphone and give heart-tugging renditions of 'Danny Boy' with tears streaming down their faces, and so I can see it's appeal, but somehow 'Pal' doesn't quite seem to be in the same league, I wouldn't have said anyway.

[Robbie]

^
an interesting list and an interesting mix of records which shows that records that continued to sell while outside the top 200 covered more than just the rock or indie genres

[UnfazedPenguin]

Another thing I thought of doing was to subtract [Sum of panel sales per 52 x weekly Top 200] from [Panel sales per EOY Top 1000] to see which charting records had the most p/sales from weeks spent outside of the 200. So here's the Top 50:

1	Jingo	Candido	411
1	New Years Day	U2	411
3	Ain't Nobody	Rufus And Chaka Khan	404
4	Theme from New York New York	Frank Sinatra	399
5	Market Square Heroes	Marillion	398
6	Village Fire (EP)	James	377
7	The Singles 1981 To 1983	Bauhaus	374
8	Resurrection Joe	The Cult	373
9	(The Best Part Of) Breakin' Up	Roni Griffith	372
10	Lost In Music	Sister Sledge	358
10	The Reflex	Duran Duran	358
12	Temple Of Love	The Sisters Of Mercy	356
13	Wake Me Up Before You Go Go	Wham!	354
14	Jimmy Mack	Martha And The Vandellas	346
15	Girls On Film	Duran Duran	342
15	Number One / That's Livin' Alright	Joe Fagin	342
17	Eyes Without A Face	Billy Idol	340
18	Pal Of My Cradle Days	Ann Breen	338
19	Love Will Tear Us Apart	Joy Division	336
20	Seasons In The Sun	Terry Jacks	329
20	Slippery People (Live Version)	Talking Heads	329
22	Agadoo	Black Lace	327
23	Endless Love	Diana Ross & Lionel Richie	324
24	White Lines (Don't Don't Do It)	Grandmaster & Melle Mel	320
25	Hello	Lionel Richie	317
26	Postman Pat	Ken Barrie	309
27	Pearly-Dewdrops' Drops	Cocteau Twins	306
28	Assassing	Marillion	304
28	Pride (In The Name Of Love)	U2	304
28	You're The Best Thing	The Style Council	304
31	Heartbeat City	The Cars	302
32	Liberator	Spear Of Destiny	296
32	Why?	Bronski Beat	296
34	Din Daa Daa (Trommeltanz)	George Kranz	290
35	Dr. Mabuse	Propaganda	287
36	Hide And Seek	Howard Jones	285
37	Thieves Like Us	New Order	282
38	Hot Hot Hot	Arrow	279
39	Shout	Lulu And The Luvers	278
40	Shout To The Top	The Style Council	277
41	Every Breath You Take	The Police	273
42	Ben	Michael Jackson	272
43	Song To The Siren	This Mortal Coil	269
44	Missing You	John Waite	266
45	This Charming Man	The Smiths	262
46	What's Love Got To Do With It	Tina Turner	260
47	When Doves Cry	Prince	259
48	The Wild Boys	Duran Duran	257
49	Move Closer	Phyllis Nelson	255
50	Theme From Cheers	Gary Portnoy	252

[Robbie]

That's weird as it allows me to paste directly from excel for my attempts to create the RM chart in that thread. Perhaps it's a size issue as my tables are only about 14 or so lines whereas yours are 250+....

It could be. I've tried a number of times to post directly from excel to the forum but nothing I do seems to make a difference.

[braindeadpj]

Yes, it's strange. For some reason the forum software will not let me copy and paste directly from excel. Instead I have to copy to Word and then copy and paste from there. On the other hand it does mean that I have every weekly chart saved as a Word file which is handy if I quickly want to look at a previous chart.

That's weird as it allows me to paste directly from excel for my attempts to create the RM chart in that thread. Perhaps it's a size issue as my tables are only about 14 or so lines whereas yours are 250+....

[UnfazedPenguin]

Let me try that again....

Tonight She Comes	The Cars	291
Easier Said Than Done	Jon Anderson	275
Fletch Get Outta Town	Dan Hartman	275
Words With The Shaman (EP)	David Sylvian# Jon Hassell • Steve Jansen# Holger Czukay	272
Day Tripper / We Can Work It Out	The Beatles	270
(Sexual) Healing	Marvin Gaye	261
No Rope As Long As Time / Radio Africa	Latin Quarter	261
Burning Heart	Survivor	256
Slammers	King Kurt	253
Frozen Heart	FM	251
In Search Of Love	Barry Manilow	245
Miss Marple - Theme From The BBC TV Series	Consort	245
Que Te Quiero? (kay-tay-key-aero)	Katrina And The Waves	245
Discipline Of Love	Robert Palmer	243
An Extract From This Is What She's Like	Dexy's Midnight Runners	242
No Faith Is Blind	Silent Running	242
Rock 'N' Roll Jamboree (Medley)	Chas & Dave	240
Bite This	Roxanne Shanté	232
Jazz Rap	Cargo	229
Raise The Roof	The Conway Brothers	228
All Or Nothing (Traditional)	Spectrum	227
You Take My Breath Away	H2O	227
Lose Your Love	Blancmange	225
Too Much Time	The Boothill Foot-Tappers	225
Ain't No Stoppin' Us / Bring Family Back	McFadden & Whitehead / Billy Paul	224
Sunday Bloody Sunday (German Import) (12#)	U2	224
My Guy# My Girl	Amii Stewart & Deon Estus	223
Thank You Very Much Mr. Eastwood	Dermot Morgan	219
Just As I Am	Air Supply	218
Mama Said	Oliver Cheatham	218

Ah, brill, I see how to do it now, thanks Robbie / kos

[UnfazedPenguin]

Thanks for that info, kos!

[Robbie]

The DNC listing was based on those with positions as technically a starred out entry does not have a position

to past into the forum I know Robbie goes from spreadsheet then paste into word and then copy the table from that into the forum.

Yes, it's strange. For some reason the forum software will not let me copy and paste directly from excel. Instead I have to copy to Word and then copy and paste from there. On the other hand it does mean that I have every weekly chart saved as a Word file which is handy if I quickly want to look at a previous chart.

[kingofskiffle]

The DNC listing was based on those with positions as technically a starred out entry does not have a position

to past into the forum I know Robbie goes from spreadsheet then paste into word and then copy the table from that into the forum.