Page Spreadsheet

A Page Spreadsheet should be provided as part of the hymnal installation process. It should consist of the following columns, in any order (click on the column name for further details):

Required columns:

• Hymn number
• First line

Recommended Columns:

• Title
• Refrain first line
• Original language
• Original language title
• Notes
• Text person name
• Text person relationship
• Text year
• Text language
• Text copyright statement
• Text source
• Meter
• Key
• Tune name
• Tune person name
• Tune person relationship
• Tune year
• Tune copyright statement
• Tune source

Optionally, you may also include the following columns in any order:

• Page number
• Publication date
• Text authority
• Text person authority
• Tune authority
• Incipit
• Tune person authority

Notes

• If there are multiple text persons or tune persons for a hymn, add another row below to enter the second (or third) person; e.g. author on the first row of the entry, translator or co-author on the row below in the same column. Leave the hymn number column blank for subsequent rows belonging to the same hymn.
• Sometimes the text and tune copyright are in one statement. In that case, enter the same copyright statement in both text and tune copyright statement columns (copy and paste).
• If there is more than one copyright statement, use a subsequent row.
• If there is more than one source, use a subsequent row.

Example

Below is what part of a Page Spreadsheet could look like (split up so into two parts so that it is not too wide). A complete example can also be downloaded here (zip file).