Printable version of thread

Click here to view this topic in its original format

BuzzJack Music Forum _ UK Charts _ Spreadsheet

Posted by: mick745 24th June 2021, 12:30 PM

I am thinking about putting a chart spreadsheet together to capture available information in one place.

Each row would be one chart week, identified by the w/e date.

I would like to include the broadcast date for that chart, the chart show presenter, the number of songs on chart, the number of new entries, with a running total for songs on chart, whether the chart has featured on pick of the pops, and the number 1 artist and song that week.

I could do similar for the album chart also.

It would be a definite list of totals for chart weeks and charted hits for anyone to check against.

Is this something people would be intetested in? What information would be useful to include?

Posted by: Bjork 24th June 2021, 12:32 PM

personally Sales Info but not sure if it's legal to have them?

Posted by: mick745 24th June 2021, 12:41 PM

I have put together a rough idea of what i am meaning. Sales data would be useful if in public domain


https://docs.google.com/spreadsheets/d/1ujnZdl4ufeny6SSawALDrT6saOPzc0_9UwVeF2bu4Ok/edit?usp=drivesdk

Posted by: adrianreavill83 24th June 2021, 06:26 PM

This is a great idea. I am interested in chart runs by the way.

Posted by: mick745 25th June 2021, 06:25 AM

Does anyone have examples of the chart show being broadcast on a day other than a Sunday (e.g. for bank holidays or special events?)

i have picked up two examples of the chart not being broadcast at all, in 1987 (switched to new chart being announced on Sunday) and 1997 ( Diana's death).

Posted by: Robbie 25th June 2021, 08:28 AM

QUOTE(mick745 @ Jun 25 2021, 07:25 AM) *
Does anyone have examples of the chart show being broadcast on a day other than a Sunday (e.g. for bank holidays or special events?)

i have picked up two examples of the chart not being broadcast at all, in 1987 (switched to new chart being announced on Sunday) and 1997 ( Diana's death).
Back in 1988 the Christmas chart was broadcast a day late, Monday 26 December rather than Sunday 25 December. I think it may have been due to the chart compilation being pushed back to the Monday

https://genome.ch.bbc.co.uk/schedules/service_bbc_radio_one/1988-12-26 (see the listings for 17:00 / 5pm)

The next time a chart day fell on Christmas Day (in 1994) the new chart did get broadcast on the Sunday.



Posted by: Bré 25th June 2021, 04:55 PM

QUOTE(mick745 @ Jun 25 2021, 07:25 AM) *
Does anyone have examples of the chart show being broadcast on a day other than a Sunday (e.g. for bank holidays or special events?)

i have picked up two examples of the chart not being broadcast at all, in 1987 (switched to new chart being announced on Sunday) and 1997 ( Diana's death).


And more recently the chart immediately after Prince Philip's death also wasn't aired.

Posted by: DanChartFan 25th November 2021, 12:30 PM

QUOTE(mick745 @ Jun 24 2021, 12:30 PM) *
I am thinking about putting a chart spreadsheet together to capture available information in one place.

Each row would be one chart week, identified by the w/e date.

I would like to include the broadcast date for that chart, the chart show presenter, the number of songs on chart, the number of new entries, with a running total for songs on chart, whether the chart has featured on pick of the pops, and the number 1 artist and song that week.

I could do similar for the album chart also.

It would be a definite list of totals for chart weeks and charted hits for anyone to check against.

Is this something people would be intetested in? What information would be useful to include?


Excuse the late reply, but I only just saw this thread when searching for something else. The spreadsheet idea is a good one, but bear in mind that before 1969 there was no official chart and that the ones that were subsequently used by Guinness (and then others) afterwards (NME 1952-1960 and Record Retailer 19660-1969) were just one of multiple magazine charts available in those days, which didn't even all get compiled on the same day or used the same sales periods to each other. The BBC would average all (or as many as they could get hold of in time) of the charts to create their own chart which didn't necessarily match any of the others, so for any line in the spreadsheet before February 1969 the chart being unveiled by the named chart show presenter would have a been a different one to the 'official' one in the books and databases you would probably be referring to for the other statistics on that line.

As far as identifying who each week's chart show presenter was, there is a thread that sm1ffj and I worked on that attempted just that for the entire run of the show, which you could use, and I which I occasionally spend time searching for and then updating. Searching for it is tricky as the search engine on here doesn't like words of 5 or less letters, so whenever I want to find it I use the tactic of searching for a very obscure guest presenter, but then first have to use genome to establish who that is, as he is so osbcure that I never remember his name (Clive Warren in case anyone is wondering). Even then the correct thread was somehow on the second page of search results when I did this just now, even though Clive Warren isn't someone that is likely to be written about all that often on this forum. The link for that thread is: http://www.buzzjack.com/forums/index.php?showtopic=159682

Posted by: DanChartFan 25th November 2021, 12:35 PM

QUOTE(mick745 @ Jun 25 2021, 06:25 AM) *
Does anyone have examples of the chart show being broadcast on a day other than a Sunday (e.g. for bank holidays or special events?)

i have picked up two examples of the chart not being broadcast at all, in 1987 (switched to new chart being announced on Sunday) and 1997 ( Diana's death).


In the case of the 1987 one there wasn't a missed broadcast though, it was just that the source chart being used skipped forward a week during October (from that point playing the incoming chart just announced, rather than the outgoing one that was just about to be out of date, as had previously been the case), leaving one week's chart unused by the Sunday chart show, despite there not being Sunday that had no chart show broadcast.

The 1988 xmas chart was announced and broadcast on Boxing Day Monday, with the industry still agreeing to consider it as the xams chart despite being announced afterwards. This was done to avoid having to calculate, distribute and broadcast e a new chart on a day that was both Christmas Day AND a Sunday (when Sunday working was still unsual outside of the most essential roles, and either Christmas Day or Sunday would have attracted at least double time on their own, and both together would have probably led to at least triple time being paid out to those who worked it).

The chart for New Year's week was often times either not broadcast at all, or run down very quickly in passing, to allow for a chart of the year to be broadcast in the relevant Sunday slot instead (though other times they have been separate shows from the weekly chart show).

Posted by: Riser 29th November 2021, 01:56 AM

QUOTE(DanChartFan @ Nov 25 2021, 07:30 AM) *
As far as identifying who each week's chart show presenter was, there is a thread that sm1ffj and I worked on that attempted just that for the entire run of the show, which you could use, and I which I occasionally spend time searching for and then updating. Searching for it is tricky as the search engine on here doesn't like words of 5 or less letters, so whenever I want to find it I use the tactic of searching for a very obscure guest presenter, but then first have to use genome to establish who that is, as he is so osbcure that I never remember his name (Clive Warren in case anyone is wondering). Even then the correct thread was somehow on the second page of search results when I did this just now, even though Clive Warren isn't someone that is likely to be written about all that often on this forum. The link for that thread is: http://www.buzzjack.com/forums/index.php?showtopic=159682
For future reference, it might be easier for you to go to sm1ffj's profile, click "Options" on the left and then "Find member's topics". That thread should appear at or near the top since it's sorted based on most recent reply, not the date the thread was started.

Posted by: Last Dreamer 29th November 2021, 06:46 AM

QUOTE(mick745 @ Jun 24 2021, 03:30 PM) *
Is this something people would be intetested in?
What information would be useful to include?


Yes, of course.

Find and watch Billboard Pop ME excel file in Internet and do the same for UK chart. smile.gif

Posted by: Gambo 29th November 2021, 02:34 PM

Just to say I like this idea Mick if you can assemble all the relevant and reliable info.

Posted by: zenon 29th November 2021, 10:58 PM

QUOTE(DanChartFan @ Nov 25 2021, 02:35 PM) *
The chart for New Year's week was often times either not broadcast at all, or run down very quickly in passing, to allow for a chart of the year to be broadcast in the relevant Sunday slot instead (though other times they have been separate shows from the weekly chart show).


When the chart was still on a Sunday it was only mentioned in passing during Radio 1's Big Weekend. Thankfully the move to Fridays eliminated this problem.

Powered by Invision Power Board
© Invision Power Services