Cataloguing

I'm still working on the same excel sheet as previously.  Today my assignment was to check the songs of the Cold Chillin'/Songs of Marl catalogs against Chuks' work of calculating how much we get from clients as royalties.  Chuks is the guy in Nigeria that David outsourced to do his accounting for CAK.  So if a song on the song split list didn't have an artist listed for whatever reason, I went through and did a search in Chuks' file for the song.  The same row would have who the client was (aka who we were collecting royalties from).  If it was EMI, we knew it was Marley Marl's label, and if it said ASCAP, Universal, etc., I had to go through our files we made and check against the statements for the song.  ASCAP has "song ID #s" for each of the entries on a royalty statement (if it was collected in the States; if not, good luck finding the song info).  I would use the song ID (if listed) to search for the song on the ASCAP database, and find the artist if listed.  If not, then I had to do a song search by title and do the same deal.