Early Cash Box C&W and RnB charts - 1946 and later

Moderators: trebor, kingofskiffle, nympho

 

Postby Chartaholic » Mon Feb 19, 2018 6:05 am

DrTravel wrote:Here are the Cash Box C&W charts for 1947-1979 - including chart runs for all songs:

http://www42.zippyshare.com/v/aiHWjoMO/file.html

Here are the Cash Box C&W "Looking Ahead" charts for 1973-1977 - including chart runs for all songs:

http://www118.zippyshare.com/v/uYmOOQU1/file.html

The Looking Ahead charts are the equivalent to Billboard's "Bubbling Under" charts but only ran for a few years.

Am currently working on the Cash Box R&B charts 1975-1979. Should be finished in a week or two.

These charts should be posted on-line shortly at http://98.130.35.56/archives-c.htm
Thank you DrTravel. As always an interesting read.

Curiosity question: what is your process for making one of these spreadsheets. As in, is it all hand-entered. Charts and then runs manually worked out. Or do you have a way to generate the runs in the spreadsheet.
Chartaholic
Groupie
 
Posts: 94
Joined: Tue Mar 14, 2017

Postby RokinRobinOfLocksley » Mon Feb 19, 2018 3:46 pm

kingofskiffle wrote:
DrTravel wrote:Here are the Cash Box C&W charts for 1947-1979 - including chart runs for all songs:

http://www42.zippyshare.com/v/aiHWjoMO/file.html

Here are the Cash Box C&W "Looking Ahead" charts for 1973-1977 - including chart runs for all songs:

http://www118.zippyshare.com/v/uYmOOQU1/file.html

The Looking Ahead charts are the equivalent to Billboard's "Bubbling Under" charts but only ran for a few years.

Am currently working on the Cash Box R&B charts 1975-1979. Should be finished in a week or two.

These charts should be posted on-line shortly at http://98.130.35.56/archives-c.htm
Huge thanks Dr Travel. Dropbox links below for anybody struggling with the Zippyshare ones.

The links are at risk and may vanish at any time.

Cash Box C&W charts for 1947-1979
https://www.dropbox.com/s/z4apwt43x7fn0 ... .xlsx?dl=0

Cash Box C&W "Looking Ahead" charts for 1973-1977
https://www.dropbox.com/s/nbsast0q5ybvx ... 9.xls?dl=0
Thanks DrTravel !!!

Thanks KoS for reposting !!! Zippyshare still isn't a friend of my PC, ugh.

For those having trouble with KoS's large dropbox file 47-79, hang in there, it will eventually work. It took a while for the file to come up on screen, and at first I could only see the first 2 charts of the first tab, couldn't scroll down or navigate to other tabs. When I tried to scroll around, got an error warning "dropbox is not responding." Eventually the first tab finished loading and I could scroll around. Could also eventually see the 2nd tab and scroll around, but never could get to the other 3 tabs. We're talking in terms of minutes here. My advice: once you get the first tab to where you can scroll around on it, then just click the download button to download the whole shebang. Then open it on your PC. Cheers !!!
User avatar
RokinRobinOfLocksley
Groupie
 
Posts: 136
Joined: Tue Sep 10, 2013
Location: Richmond, Virginia, USA

Postby DrTravel » Mon Feb 19, 2018 7:22 pm

Chartaholic wrote:Thank you DrTravel. As always an interesting read.

Curiosity question: what is your process for making one of these spreadsheets. As in, is it all hand-entered. Charts and then runs manually worked out. Or do you have a way to generate the runs in the spreadsheet.
Everything is hand-entered and processed manually - although I have developed techniques that kind of reduce the time I spent on certain tasks. It is still a tedious and time intensive process.

Step One - compile the weekly charts from the originals. For all new entries, have to verify that the song title, artist and label/number is correct as the info found on the charts is often incorrect or changes during the song's chart run. This is the most time consuming part of the process as it is simple manual data entries. Because these charts are not available in an on-line database (such as the billboard.biz archives) there is no way to cut and paste nor can I take a photo of the chart and have some magical app produce the charts! Of course this assumes possessing copies of the original charts which always require some additional pre-Step One effort.

Step Two - Sort these charts by song title, artist name and chart date and then produce the weekly chart runs. Mostly cut and pasting from vertical weekly chart positions to the horizontal chart run. Process is tedious but not as time consuming as Step One. This allows me to verify the info on the original charts as errors are bound to happen. A pain is when a song drops off and later returns - I have to leave empty weekly chart positions for this.

Step Three - Generate the overall chart data, such as weeks charts, peak position etc. Simple process using Excel formulas. If I had a SS showing Whitburn's data I can verify to see if Joel or I made a mistake. About 1/3 of the time I'm wrong but the other 2/3 Joel is incorrect and I note this on a separate spreadsheet tab.

Step Four - Compare this spreadsheet to the master Cash Box Pop and Looking Ahead spreadsheets to generate the chart positions of the C&W songs on the pop charts. Another opportunity to verify song titles, labels etc. Tedious but not too bad.

Step Five - Post to the forums (and share with others) who may find errors and notify me. I then make these corrections. No such thing as a perfect SS although I try my best. Remember these are living documents.

Hope I answered any questions you had. Oh by the way...sometimes you need to just take a break during the process to get your senses back!!
DrTravel
Roadie
 
Posts: 311
Joined: Thu Dec 25, 2014

Postby Chartaholic » Tue Feb 20, 2018 2:57 am

DrTravel wrote:
Chartaholic wrote:Thank you DrTravel. As always an interesting read.

Curiosity question: what is your process for making one of these spreadsheets. As in, is it all hand-entered. Charts and then runs manually worked out. Or do you have a way to generate the runs in the spreadsheet.
Everything is hand-entered and processed manually - although I have developed techniques that kind of reduce the time I spent on certain tasks. It is still a tedious and time intensive process.

Step One - compile the weekly charts from the originals. For all new entries, have to verify that the song title, artist and label/number is correct as the info found on the charts is often incorrect or changes during the song's chart run. This is the most time consuming part of the process as it is simple manual data entries. Because these charts are not available in an on-line database (such as the billboard.biz archives) there is no way to cut and paste nor can I take a photo of the chart and have some magical app produce the charts! Of course this assumes possessing copies of the original charts which always require some additional pre-Step One effort.

Step Two - Sort these charts by song title, artist name and chart date and then produce the weekly chart runs. Mostly cut and pasting from vertical weekly chart positions to the horizontal chart run. Process is tedious but not as time consuming as Step One. This allows me to verify the info on the original charts as errors are bound to happen. A pain is when a song drops off and later returns - I have to leave empty weekly chart positions for this.

Step Three - Generate the overall chart data, such as weeks charts, peak position etc. Simple process using Excel formulas. If I had a SS showing Whitburn's data I can verify to see if Joel or I made a mistake. About 1/3 of the time I'm wrong but the other 2/3 Joel is incorrect and I note this on a separate spreadsheet tab.

Step Four - Compare this spreadsheet to the master Cash Box Pop and Looking Ahead spreadsheets to generate the chart positions of the C&W songs on the pop charts. Another opportunity to verify song titles, labels etc. Tedious but not too bad.

Step Five - Post to the forums (and share with others) who may find errors and notify me. I then make these corrections. No such thing as a perfect SS although I try my best. Remember these are living documents.

Hope I answered any questions you had. Oh by the way...sometimes you need to just take a break during the process to get your senses back!!
Thank you very much for taking the time to answer. And in such detail.

That was exactly what I was looking for. My experience is in databases and my spreadsheet experience is very limited. I was puzzled how it was done and it all makes sense now. And efficient.
Chartaholic
Groupie
 
Posts: 94
Joined: Tue Mar 14, 2017

Postby xsergan » Thu Feb 22, 2018 8:48 pm

Most of the files have sadly expired. Any chance of reupload? Big thanks for the work.
xsergan
Groupie
 
Posts: 15
Joined: Thu Jul 11, 2013

Postby kjell » Wed Feb 28, 2018 1:59 pm

Interesting postings happen while on vacation. DrTravels Cash Box postings are most welcome. His explanation of methods are also impressive and goes beyond my doings after step three. The quality of his Stateside chart work is insurmountable, the only one I can see coming close is kingofskiffle. We anglophile chart fans are lucky to have the two of them doing the charts and chartruns of UK and US and sharing the results with us. We can enjoy and work onwards in our special niches. Personally I’m now working on a file of non-Billboard country hits made possible by DrTravels postings and Whitburns book on RW country.
A special thank you to kingofskiffle for making DrTravels postings available to us outside zippyshare, making access possible in a virus free zone.
kjell
Groupie
 
Posts: 48
Joined: Fri Sep 07, 2007
Location: Oslo, Norway

Postby DrTravel » Thu Mar 01, 2018 1:31 am

Here are the Cash Box R&B charts for 1953-1979 - including chart runs for all songs:

http://www8.zippyshare.com/v/H2XKIeyU/file.html
DrTravel
Roadie
 
Posts: 311
Joined: Thu Dec 25, 2014

Postby kingofskiffle » Thu Mar 01, 2018 5:38 pm

http://thechartbook.co.uk - for the latest are best chart book - By Decade!
User avatar
kingofskiffle
Superstar
 
Posts: 5973
Joined: Thu Jan 08, 2004
Location: On The Internet

Postby RokinRobinOfLocksley » Thu Mar 01, 2018 7:24 pm

Thanks DrTravel & KingOfSkiffle !!
User avatar
RokinRobinOfLocksley
Groupie
 
Posts: 136
Joined: Tue Sep 10, 2013
Location: Richmond, Virginia, USA

Postby DrTravel » Tue Mar 20, 2018 3:28 am

A little off topic but I'm not sure I ever posted this SS before. It's the C&W singles per Joel Whitburn's Record World book (with a few corrections) with an added column showing each songs peak on the Billboard C&W charts. I will add another column showing the peak position on the Cashbox C&W charts when I finish the 1982 charts.

http://www48.zippyshare.com/v/10d0FRZL/file.html

Hey Rockin - have you tried a different browser to download from zippyshare? Google Chrome, Firefox etc. You are the only person I know who has difficulty in grabbing things off there and I've been using them for a long time.
DrTravel
Roadie
 
Posts: 311
Joined: Thu Dec 25, 2014

Postby kjell » Tue Mar 20, 2018 7:57 am

You’re not off topic at all, just a bit ahead of me. Will you also include CB country hits not in RW in this SS?

Several of us have problems with zippyshare, seems our anti virus systems aren’t perfectly aimed, but kingofskiffle gives us a way around these problems.

Thanks for keeping up the good work.
kjell
Groupie
 
Posts: 48
Joined: Fri Sep 07, 2007
Location: Oslo, Norway

Postby kingofskiffle » Tue Mar 20, 2018 8:15 am

Thanks for doing this DrTravel. Interesting to see the ones that didn’t chart on Billboard.

https://www.dropbox.com/s/cew6kszy2jl8g ... .xlsx?dl=0

Dropbox for those who wish Dropbox.

I suspect the problems come from browser settings or anti virus conflicts. I to get lots of pop ups but Adblocker removes them. Not endorsing adblocker.
http://thechartbook.co.uk - for the latest are best chart book - By Decade!
User avatar
kingofskiffle
Superstar
 
Posts: 5973
Joined: Thu Jan 08, 2004
Location: On The Internet

Postby trebor » Tue Mar 20, 2018 11:30 am

Off topic
I have access to Mediabase Research's full Country charts (USA, Canada, all songs down to 1 play; current, recurrent, Gold).
On-line data is complete and starting with August 2001 (IIRC).
Is this something that you would be interested in?
If so, I would be starting a new project for when I'm r-e-a-l-l-y bored! (Not in the immediate future, though)
-> @KingOfSkiffle: Please evaluate copyright situation for such information made public (Holders are: IHeartMedia [and Liberty Media]).
User avatar
trebor
Legend
 
Posts: 13618
Joined: Fri Aug 01, 2014

Postby kingofskiffle » Tue Mar 20, 2018 12:07 pm

Wow. Seems like that’s a nice project.

In terms of copyrite always post and if they dislike thy will say and then we take it down.
http://thechartbook.co.uk - for the latest are best chart book - By Decade!
User avatar
kingofskiffle
Superstar
 
Posts: 5973
Joined: Thu Jan 08, 2004
Location: On The Internet

Postby trebor » Tue Mar 20, 2018 12:31 pm

I'm visualizing the concept as an interactive .xls file (access-type) in a similar format as @DrTravel's.
And linking to four sources: comprehensive (current/recurrent), current, recurrent and Gold.
Gold uses a different methodology and cannot be merged into the comprehensive database.
For the moment, it's just a train of thought. Will figure it out over the next few years...
Copyright: You're a rebel! :wink: 8-) :lol:
User avatar
trebor
Legend
 
Posts: 13618
Joined: Fri Aug 01, 2014

Postby RokinRobinOfLocksley » Wed Mar 21, 2018 2:12 am

DrTravel wrote:A little off topic but I'm not sure I ever posted this SS before. It's the C&W singles per Joel Whitburn's Record World book (with a few corrections) with an added column showing each songs peak on the Billboard C&W charts. I will add another column showing the peak position on the Cashbox C&W charts when I finish the 1982 charts.

http://www48.zippyshare.com/v/10d0FRZL/file.html

Hey Rockin - have you tried a different browser to download from zippyshare? Google Chrome, Firefox etc. You are the only person I know who has difficulty in grabbing things off there and I've been using them for a long time.
Thanks DrT and KoS !!!
I haven't tried another browser yet, good idea, thanks, worth a try. I just know Internet Explorer 11 with Norton Security and Adblocker, and Microsoft Edge, do not like / work with Zippyshare. Cheers !!
User avatar
RokinRobinOfLocksley
Groupie
 
Posts: 136
Joined: Tue Sep 10, 2013
Location: Richmond, Virginia, USA

Postby DrTravel » Mon Mar 26, 2018 12:05 am

Updated - the C&W singles per Joel Whitburn's Record World book (with a few corrections) with an added column showing each songs peak on the Billboard C&W charts PLUS another column showing the peak position on the Cashbox C&W charts up to mid 1979. I've updated my Cash Box C&W spreadsheet showing RW/MV and BB C&W peak positions plus I updated my Billboard C&W spreadsheet showing RW/MV and Cash Box R&W peak positions. After I finish the Cash Box C&W charts to the end of 1982 I'll have all the info needed for Whitburn to produce a C&W "Comparison" book like he did for the pop charts.

http://www91.zippyshare.com/v/zaa7jyai/file.html
DrTravel
Roadie
 
Posts: 311
Joined: Thu Dec 25, 2014

Postby kingofskiffle » Mon Mar 26, 2018 6:55 am

http://thechartbook.co.uk - for the latest are best chart book - By Decade!
User avatar
kingofskiffle
Superstar
 
Posts: 5973
Joined: Thu Jan 08, 2004
Location: On The Internet

Postby RokinRobinOfLocksley » Mon Mar 26, 2018 1:32 pm

Thanks DrTravel & KingOfSkiffle !!
User avatar
RokinRobinOfLocksley
Groupie
 
Posts: 136
Joined: Tue Sep 10, 2013
Location: Richmond, Virginia, USA

Postby croatia » Fri Apr 06, 2018 10:14 pm

Dr. Travel, this is fantastic!
A BIG Thanks from me too
croatia
Groupie
 
Posts: 197
Joined: Wed Aug 09, 2006

Return to Chart Analysis