Page 5 of 5

Re: Newsletter, LDS tools, and Sacrament Programs

Posted: Sun Nov 27, 2016 10:59 pm
by ag_boy
For anyone interested in a template for Sacrament Meeting Programs, using Google Docs, please follow the links included here.

There are two docs:
1) A word-style template for the actual program. It uses multiple tables for layout, like a web page. Easily modified.
2) A bulletin spreadsheet that records speakers, songs, and musical numbers. It dynamically finds hymn numbers based on an included song database, and pulls all this data into a sheet which can be directly copied and pasted into the program template. There are a lot of formulas to process the data, so some ranges are protected with a warning (you can edit them all)

This has been a fantastic tool to remote coordinate with the music director and bishopric as many of our people travel the world, and can still fulfill their duties. It eliminates a lot of emailing, as the people who need to affect the program information have direct access to it.

Program layout
https://drive.google.com/open?id=1sQwtH ... kkDE8bIghc

Spreadsheet
https://drive.google.com/open?id=1Vgy8h ... vjF10zxS7s


Please copy to your local Google account and share as needed.


And at all times, lobby the church website folk to include this kind of functionality locally for everyone without the use of Google ;)

UPDATED LINKS - Newsletter, LDS tools, and Sacrament Programs

Posted: Mon Nov 28, 2016 9:44 pm
by ag_boy
Updating the links for the Sunday Program bulletin

Please use these links instead:

Program layout
https://docs.google.com/document/d/1sQw ... bIghc/copy

Spreadsheet
https://docs.google.com/spreadsheets/d/ ... zxS7s/copy

Re: Newsletter, LDS tools, and Sacrament Programs

Posted: Mon Nov 28, 2016 9:48 pm
by ag_boy
The first links will allow you to see the documents. If you want to make a copy and edit the files for your own use, please log in to your google docs account first, and then click the new links.

This should make a copy to your local Google account, that you can edit at will.