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!!