Welcome, guest! Log in or register. (click here for help) If you have forgotten your password and a recovery email has not arrived, please click here to send us an email.
 |
  |
| Spreadsheet, Chart spreadsheet idea |
| Track this thread | Email this thread | Print this thread | Download this thread | Subscribe to this forum |
 24th June 2021, 12:30 PM
Post
#1
|
|
 BuzzJack Climber
Joined: 4 August 2012
Posts: 126 User: 17,441 
  |
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? |
 |
 
|
|
24th June 2021, 12:32 PM
Post
#2
|
|
|
BuzzJack Legend
Joined: 13 November 2015
Posts: 35,557 User: 22,665
  |
personally Sales Info but not sure if it's legal to have them?
|
|
|
|
|
24th June 2021, 12:41 PM
Post
#3
|
|
|
BuzzJack Climber
Joined: 4 August 2012
Posts: 126 User: 17,441
|
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: 24th June 2021, 12:44 PM |
|
|
|
|
24th June 2021, 06:26 PM
Post
#4
|
|
|
BuzzJack Enthusiast
Joined: 25 July 2020
Posts: 690 User: 110,261
|
This is a great idea. I am interested in chart runs by the way.
|
|
|
|
|
25th June 2021, 06:25 AM
Post
#5
|
|
|
BuzzJack Climber
Joined: 4 August 2012
Posts: 126 User: 17,441
|
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). |
|
|
|
|
25th June 2021, 08:28 AM
Post
#6
|
|
|
BuzzJack Gold Member
Joined: 4 April 2006
Posts: 3,476 User: 366
|
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?) 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 Mondayi 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). 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. |
|
|
|
|
25th June 2021, 04:55 PM
Post
#7
|
|
 I wanna be your ally
Joined: 14 February 2009
Posts: 116,676 User: 8,300
                 |
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. |
|
|
|
|
25th November 2021, 12:30 PM
Post
#8
|
|
|
BuzzJack Enthusiast
Joined: 8 July 2007
Posts: 1,094 User: 3,866
|
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 |
|
|
|
|
25th November 2021, 12:35 PM
Post
#9
|
|
|
BuzzJack Enthusiast
Joined: 8 July 2007
Posts: 1,094 User: 3,866
|
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: 25th November 2021, 12:42 PM |
|
|
|
|
29th November 2021, 01:56 AM
Post
#10
|
|
|
PROVE THAT IT HAUNTS ME
Joined: 14 July 2013
Posts: 23,110 User: 19,534
    |
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. |
|
|
|
|
29th November 2021, 06:46 AM
Post
#11
|
|
|
With Kristina in heart
Joined: 28 March 2017
Posts: 4,388 User: 28,104
  |
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. 
|
|
|
|
|
29th November 2021, 02:34 PM
Post
#12
|
|
|
BuzzJack Regular
Joined: 29 July 2014
Posts: 207 User: 21,106
|
Just to say I like this idea Mick if you can assemble all the relevant and reliable info.
|
|
|
|
|
29th November 2021, 10:58 PM
Post
#13
|
|
|
BuzzJack Gold Member
Joined: 9 May 2009
Posts: 3,651 User: 8,809
 |
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. |
|
|
|
|
| Time is now: 13th December 2024, 04:26 PM |
Copyright © 2006 - 2024 BuzzJack.com
