The Spreadsheet
| Type: | Version: | Date: | Range: | Link: |
|---|---|---|---|---|
| Macro Version | 999885m | 15 December 2010 | 1939-1989 | |
| Macro Version with 1940-1980 Whitburn Sheet | 999885mw | 15 December 2010 | 1939-1989 | |
| Non-Macro Version | 999885 | 15 December 2010 | 1939-1999 |
Overview:
The Britburn spreadsheet contains information on every entry in the UK charts, from sheetmusic sales totals in 1939, through the commencement of the British record sales chart in 1952 and, when complete, to the present day. Songs are grouped statistically by their chart performance and assigned a serial number within their year(s) of chart influence.
Each Record Sales entry includes the A-Side (B-sides until the CD era) titles, performers, composers, label and number, chart run and whatever session details are known. Sheetmusic entries include the prominent performer(s) and associated vinyl releases and publishers (where known).
The non-macro version no longer includes the full week by weeks charts. There are now available here. The macro version will generate any dates chart on-the-fly.
The macro version of the spreadsheet runs under Microsoft Excel 2000 or later and adds functionality for statistical reports to be generated. Mp3's can be played and labels and other images present on your system (.jpg format) are displayed, including lyric files (.txt or .lrc).
By default the Windows mp3 player and environmental space are used. These can be changed in User Configuration. (To restore defaults enter nothing for 'Player' and 'Temp Folder'). Players tested include Winamp, Windows Media Player, and BSPlayer.
Duplicate entries, LP's or EP's launch an m3u Playlist containing all tracks, otherwise the selected side and label plays.
Reports are launched by double clicking the appropriate column or cell in the Britburn sheet. These can be exported to an m3u Playlist, Notepad or the clipboard. Clicking any row in a Report plays that track, if present. Sorting by any column in the report is possible (click column heading). Labels do not show for Playlists.
User Configuration:
Entering your information here is essential for the macro spreadsheet to function as intended.
PLEASE NOTE: Spreadsheet Status becomes [Active] automatically after you've entered enough required information. The Check Resources button displays a summary of labels and mp3s present on your system. A checksum feature compare your files with our library copies and shows any differences. Britburn mp3's, images and lyrics files can in Imported from any folder and automatically moved to their project destination folders.
Chartology
A track's chart run data is obtained by double clicking Britburn serial number. Chart runs are defined as the period a song was on the charts, including time off where time off does not exceed 6 months. The year a chart run is assigned is the Year of its (first) highest position. Where a track re-enters in subsequent years this is considered a new chart run. Each track and chart run is assigned an exclusive serial number. (See the Info sheet for more details)
Web Site
A link to the Britburn web site is launched by double clicking any Serial number cell.
Charts and ChartPlay
Any weeks chart is shown by selecting a date from the Calendar. Double clicking the charts playlist icon launches an m3u playlist for that week. The number of entries to include and playing order are set in User Configuration.
The Calendar is selected by a left click on the Britburn logo. The Charts icon on the main control Form will display that entries peak week.
Events
Most fields in the Britburn and SheetMusic Sheet launch unique events or generate reports when double-clicked:
| Field: | Report Generated / Event Triggered: |
|---|---|
| Year | Date Peaked, A-Side Title, Artist, Label & Cat, ChartRun and Peak. |
| Prefix | Main Control Form. Shows full details for both A and B-Sides, labels and lyrics. Links to that track at www.britburn.co.uk |
| Artist | Date Entered, A-Side, B-Side, Label & Cat, ChartRun and Peak. This also allows selection of A Side, B Side, or both |
| Title | Plays A-Side, if present. If more than one instance of Title is found a Report is created with Date Entered, Artist, Composer, Label & Cat, ChartRun and Peak. |
| Label | Date Entered, Catalogue number, Artist, A-Side Title, ChartRun and Peak. |
| Composer(s) | Date Entered, Artist, A-Side Title, Label & Cat, ChartRun and Peak. |
| B-Side | Plays B-Side (and images) if present. |
| Date Entered | Every track entering the charts on that date. Date Peaked, Artist, Title, Label & Cat, ChartRun, Peak and Date Left. |
| Date Peaked | Every track peaking on that date. |
| Date Left | Every track leaving the charts on that date. |
Images
Labels displayed for the chosen side, plus any further images associated with that track. Click on the image to change its size. Navagation button indicates further images exist.
Macro's
Apart from some procedures used conditionally, all code is written by amateurs. Nothing is guaranteed or implied. No responsibility is accepted for any problems associated with using these macros. Anything (apart from where noted) is free to copy or modify. Excel 2000 or later required and recommended screen size is 1152x864 or higher.
The versions available here, are the latest but may well contain bugs and problems not yet envisaged by the developer(s). However, they represents the best of our efforts and any problems that arise will be fixed. Comments, questions etc are welcomed in the Britburn Forum, available from the menu above.
kirkm
September 2010
Release Notes
It's intended, from version v991m onwards, to document all changes, corrections, bug fixes etc, plus any changes to label/lyric files. New spreadsheets can be assumed to contain data updates & corrections but these will not be documented.
| Version: | Date: | Changes: |
|---|---|---|
| v991m | 27 September 2007 |
|
| -- | 8 October 2007 |
|
| v992m | 12 October 2007 |
|
| -- | 4 January 2008 |
|
| -- | 5 January 2008 |
|
| -- | 6 January 2008 |
|
| -- | 7 January 2008 |
|
| v995m | 17 March 2008 |
|
| -- | 28 May 2008 |
|
| -- | July-October 2008 |
|
| v999 | October 2008 |
|
| v99951 | December 2008 |
|
| v9996 | March 2009 |
|
| v99997 | October 2009 |
|
| v99973 | November 2009 |
|
| -- | December 2009 |
|
| v999752 | February 2010 |
|
| v99980 | April 2010 |
|
| -- | September 2010 |
|
| v999885 | December 2010 |
|