Spreadsheet - BuzzJack Music Forum

BuzzJack - Entertainment Discussion _ Music Charts _ UK Charts

Latest Site News

Wham are at number one again

Jack Harlow gets a third week at number one

Jack Harlow remains at the top of the singles char

Spreadsheet, Chart spreadsheet idea

Display Modes

Track this topic - Email this topic - Print this topic - Download this topic - Subscribe to this forum

mick745 View Member Profile	Jun 24 2021, 12:30 PM Post #1
BuzzJack Climber Group: Members Posts: 126 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?


Bjork View Member Profile	Jun 24 2021, 12:32 PM Post #2
BuzzJack Legend Group: Members Posts: 31,866 Member No.: 22,665 Joined: 13-November 15 No Gallery Pics	personally Sales Info but not sure if it's legal to have them?


mick745 View Member Profile	Jun 24 2021, 12:41 PM Post #3
BuzzJack Climber Group: Members Posts: 126 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


adrianreavill83 View Member Profile	Jun 24 2021, 06:26 PM Post #4
BuzzJack Enthusiast Group: Members Posts: 504 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.


mick745 View Member Profile	Jun 25 2021, 06:25 AM Post #5
BuzzJack Climber Group: Members Posts: 126 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).


Robbie View Member Profile	Jun 25 2021, 08:28 AM Post #6
BuzzJack Gold Member Group: Members Posts: 3,394 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.


Michael Bubré View Member Profile	Jun 25 2021, 04:55 PM Post #7
one hand behind the devil, the other touching grace Group: Genre Mod Posts: 113,259 Member No.: 8,300 Joined: 14-February 09 User's Gallery	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.


DanChartFan View Member Profile	Nov 25 2021, 12:30 PM Post #8
BuzzJack Enthusiast Group: Members Posts: 1,060 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


DanChartFan View Member Profile	Nov 25 2021, 12:35 PM Post #9
BuzzJack Enthusiast Group: Members Posts: 1,060 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


Riser View Member Profile	Nov 29 2021, 01:56 AM Post #10
It might be gravel but it feels like gold Group: Moderator Posts: 21,127 Member No.: 19,534 Joined: 14-July 13 User's Gallery	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.


Last Dreamer View Member Profile	Nov 29 2021, 06:46 AM Post #11
With Kristina in heart Group: Members Posts: 3,392 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.


Gambo View Member Profile	Nov 29 2021, 02:34 PM Post #12
BuzzJack Climber Group: Members Posts: 189 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.


zenon View Member Profile	Nov 29 2021, 10:58 PM Post #13
BuzzJack Gold Member Group: Members Posts: 3,555 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.