Leonard Cohen Web Directory and Custom Search Engine

LeonardCohenSearch header image 5

Calculating The Number Of Covers Listed At A Thousand Covers Deep

January 4th, 2009 · No Comments

The List of Covers of Leonard Cohen Songs designated by the LeonardCohenSearch Web Directory is A Thousand Covers Deep at LeonardCohenFiles.  It is, to my knowledge, the most complete and updated catalog available.

Consequently it is especially useful to satisfy ones curiosity, to settle arguments, to win bar bets, and to  compose posts such as those generated during the Hallelujah Hootenanny Britain recently hosted. For example, in  Leonard Cohen’s Hallelujah – The Fun Facts, I wrote

This morning,  A Thousand Covers Deep,  the database of covers of Leonard Cohen songs at LeonardCohenFiles.com, contained 181 versions of Hallelujah. For the record, Suzanne is still (barely) the most covered Leonard Cohen song, with 185 versions listed at  A Thousand Covers Deep.

On these occasions, one needs  the exact number of covers of a given Cohen song.  This can be a problematic task because the list of covers is not numbered and some of the songs have well over 100 covers, making counting by hand cumbersome. Counting covers by hand is also likely to induce errors and, in any case, is annoying. There is, however, a relatively simple means of calculating this number:

  1. Open Excel or any spreadsheet. If no spreadsheet is available, open a text editor such as Microsoft Word.
  2. Copy the group of covers to be counted, taking care to include all of the covers but not copying extra lines.
  3. Paste this into the upper left margin of the spreadsheet.

Each cover should automatically be placed into one row of the spreadsheet. The row numbers on the left indicate the number of covers. If Microsoft Word is used instead of a spreadsheet, take care to paste the contents such that the first cover is on the first line of the Word document. Go to Preferences-Properties. In the box that opens, click the “statistics” tab. The number of lines listed will be the same as the number of covers.

Tags: How-To

0 responses so far ↓

  • There are no comments yet...Kick things off by filling out the form below.

Leave a Comment