jbh001 wrote:Over the years of service in various music callings and bishoprics, I have developed and refined some spreadsheets that track hymns and sacrament meeting items. I am attaching them as Excel spreadsheets (though I did most of the original work in Quattro Pro, if anyone wants those versions).
Some explanatory notes:
The purpose of the Sacrament Meeting Tracking form is to help the bishopric plan future sacrament meetings by being able to see at a glance (1) what Sundays they have to prepare for, and (2) who has done what recently so that we don't call on the STP's (same ten people) to speak and pray. At the end of the year, a completed version of this sheet is printed for quick reference and placed with the conducting sheets for that year sort of as an index.
Also in our unit we have a team of 4 choristers and 4 organists to share the load. That way each organist and chorister does a sacrament meeting only about once a month. This might not apply to your unit, so you may not need those columns.
The hymn tracking sheet is designed so that you can type in the hymn number, and the title fills itself in. I usually forward this spreadsheet to the ward music chairman so they can use it in selecting hymns.
In my prior unit, we had a Spanish sacrament meeting separate from the English sacrament meeting (we didn't have quite enough at that time to make a Spanish branch or even a dependent Spanish branch). The Spanish hymn tracking sheet is designed so that the English hymn number is entered into the first column, and then the Spanish hymn number and title fill themselves in in the remaining columns. Hymns that appear only in the Spanish hymnal (there are 15 of them) are numbered consecutively starting as English hymn number 401.
Thank you very much for creating this spreadsheet that correlates the English and Spanish hymns it will be very useful for my mission, I'll make sure to print it out and stick it in my Spanish hymn book!