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:

Recommended Columns:

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


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).

Hymn number Title Original language title First line Refrain first line Text language Original language Text person name Text person relationship Text year
1 I Bind unto Myself Today I bind unto myself today the strong name of the Trinity English St Patrick Author c. 430
Cecil Frances Alexander Paraphraser 189
2 Holy, Holy, Holy! Lord God Almighty Holy, holy, holy! Lord God Almighty English Reginald Heber Author 1826; alt.
3 Holy God, We Praise Your Name Holy God we praise your name English Ignaz Franz (attr.) Author c. 1774
4 Father, I Adore You Father, I adore you English Terrye Coelho Author 1972


Text source Text copyright statement Tune name Key Meter Tune person name Tune person relationship Tune year Tune source Tune copyright statement Notes
Prayer
NICAEA D Major 11.12.12.10 John B. Dykes Composer 1861
GROSSER GOTT, WIR LOBEN DICH F Minor 7.8.7.8.7.7 Donald P. Hustad (desc.) Composer 1989 Katholisches Gesangbuch, Vienna, 1774 Desc. © 1990 Hope Publishing Company
© 1972 Maranatha! Music MARANATHA F Major 6.6.4 Terrye Coelho Composer 1972 © 1972 Maranatha! Music