BuzzJack
Entertainment Discussion

Welcome Guest ( Log In | Register | Help )

Latest Site News
> -
 
Reply to this topicStart new topic
> Spreadsheet, Chart spreadsheet idea
Track this topic - Email this topic - Print this topic - Download this topic - Subscribe to this forum
mick745
post Jun 24 2021, 12:30 PM
Post #1
BuzzJack Climber
**
Group: Members
Posts: 123
Member No.: 17,441
Joined: 4-August 12
   No Gallery Pics
 


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?
Go to the top of the page
 
+Quote Post
Bjork
post Jun 24 2021, 12:32 PM
Post #2
BuzzJack Legend
*******
Group: Members
Posts: 26,598
Member No.: 22,665
Joined: 13-November 15
   No Gallery Pics
 


personally Sales Info but not sure if it's legal to have them?
Go to the top of the page
 
+Quote Post
mick745
post Jun 24 2021, 12:41 PM
Post #3
BuzzJack Climber
**
Group: Members
Posts: 123
Member No.: 17,441
Joined: 4-August 12
   No Gallery Pics
 


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/1ujn...it?usp=drivesdk


This post has been edited by mick745: Jun 24 2021, 12:44 PM
Go to the top of the page
 
+Quote Post
adrianreavill83
post Jun 24 2021, 06:26 PM
Post #4
BuzzJack Regular
***
Group: Members
Posts: 328
Member No.: 110,261
Joined: 25-July 20
   No Gallery Pics
 


This is a great idea. I am interested in chart runs by the way.
Go to the top of the page
 
+Quote Post
mick745
post Jun 25 2021, 06:25 AM
Post #5
BuzzJack Climber
**
Group: Members
Posts: 123
Member No.: 17,441
Joined: 4-August 12
   No Gallery Pics
 


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).
Go to the top of the page
 
+Quote Post
Robbie
post Jun 25 2021, 08:28 AM
Post #6
BuzzJack Gold Member
*****
Group: Members
Posts: 3,314
Member No.: 366
Joined: 4-April 06
   No Gallery Pics
 


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/servi..._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.


Go to the top of the page
 
+Quote Post
Bumblebrė
post Jun 25 2021, 04:55 PM
Post #7
leave society, be a monke
********
Group: Genre Mod
Posts: 104,330
Member No.: 8,300
Joined: 14-February 09
 


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.
Go to the top of the page
 
+Quote Post
DanChartFan
post Nov 25 2021, 12:30 PM
Post #8
BuzzJack Enthusiast
****
Group: Members
Posts: 991
Member No.: 3,866
Joined: 8-July 07
   No Gallery Pics
 


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
Go to the top of the page
 
+Quote Post
DanChartFan
post Nov 25 2021, 12:35 PM
Post #9
BuzzJack Enthusiast
****
Group: Members
Posts: 991
Member No.: 3,866
Joined: 8-July 07
   No Gallery Pics
 


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).


This post has been edited by DanChartFan: Nov 25 2021, 12:42 PM
Go to the top of the page
 
+Quote Post
Riser
post Nov 29 2021, 01:56 AM
Post #10
blindside butterbeans
******
Group: Moderator
Posts: 18,672
Member No.: 19,534
Joined: 14-July 13
 


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.
Go to the top of the page
 
+Quote Post
Last Dreamer
post Nov 29 2021, 06:46 AM
Post #11
With dagger in heart
*****
Group: Members
Posts: 2,495
Member No.: 28,104
Joined: 28-March 17
   No Gallery Pics
 


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
Go to the top of the page
 
+Quote Post
Gambo
post Nov 29 2021, 02:34 PM
Post #12
BuzzJack Climber
**
Group: Members
Posts: 182
Member No.: 21,106
Joined: 29-July 14
   No Gallery Pics
 


Just to say I like this idea Mick if you can assemble all the relevant and reliable info.
Go to the top of the page
 
+Quote Post
zenon
post Nov 29 2021, 10:58 PM
Post #13
BuzzJack Gold Member
*****
Group: Members
Posts: 3,407
Member No.: 8,809
Joined: 9-May 09
   No Gallery Pics
 


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.
Go to the top of the page
 
+Quote Post


Reply to this topicStart new topic

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


 

Lo-Fi Version Time is now: 9th August 2022 - 05:37 AM