Electronic Sacrament Meeting program

The electronic Sacrament Meeting program we use I thought might be useful for other people.

It is an Excel spreadsheet with two workbooks, Schedule and Agenda.

On the Schedule you will see the Sundays with details of who is conducting, the hymn numbers, prayers, speakers.
On the Agenda you will see the program for the upcoming Sunday.

There is also a hidden workbook with details of all the hymn numbers and titles, hence how you only input the hymn number on the schedule but it prints the hymn title on the agenda as well

It is simple and it works. There are no frilly extras.

If anyone fancy "beautifying" it feel free and repost your changed version.

Example is attached

I have now fixed a number of issues with the spreadsheet so it should cope better with the following:

• Year 2016
  Online version of Excel versus Desktop version
  Blank Entries

Thanks for posting. I like the simplicity and I think we could really use it in our unit.

However, I open it and its in Protected View. Once I enable it much of the primary functions stop working (hymn lookup, etc.). I'm not sure what I'm doing wrong?

Thanks!

Tyler Smith

I have now updated it to work. Next Sunday is conference but you can still fill it in as if it was a normal Sunday to see it working.

Fantastic work Brother Jorgensen! Thank you

The only version I see here isn't functioning for me to do hymn look ups etc. It didn't come up as Read only, but I don't know how to get it to fill in the hymn numbers.
I am using my desktop with windows ten and excel 2007.

Am I doing something wrong? Thanks. (no rush I don't need it for myself, and not sure if our ward leaders need it or not.) I just happened across this while figuring out my calling as ATS.

Thanks, k lystad

I have attached another version with the last two Sundays of the year filled in so it should show how it works.
If you still have problems then feel free to message me directly and send some screenshots to show the problem.

is this the same template you use to print and hand out to the congregation?

ngoodl wrote:is this the same template you use to print and hand out to the congregation?

We personally don't have a need to print anything out to the congregation.
We keep ours online (with login req) for the Bishopric, Music Director, Exec Sec, Clerk etc to fill out their bit in advance and then its printed for the person conducting the meeting.

Hello,

Excuse my ignorance on this forum. I am looking for a way to electronically make available the program on Sunday for the members if they choose not to have them printed out. Many show up late and sometimes we run out of printed material. Any idea's? Thanks

We still print a small number of programs, that we create in Word. We also create a PDF version of it in a different layout which is emailed to those in the Ward that say they wish to receive the program. We created a Google Form, and let the Ward know if they wanted to receive it, they simply went there, added their email and checked two boxes, one for yes to receive the program, the other if they were willing to get notifications if we needed to send anything out. We could have used the leader and clerk "send a message" link, but not all the emails were in there and up to date. Also we felt that we needed to make it opt-in as well, and not assume everyone wanted it. Right now we have just under half the ward receive it electronically, with more signing up each week. The goal is to not print one at all, but right now we have not hit the tipping point. Just thought I would share.

Here's a version I've created inspired by the original from Brother Jorgensen, along with a few style elements from the ones on the wiki https://tech.lds.org/wiki/Callings#Resources

It's in Google Sheets which allows us to share with all the members of the Bishopric to edit and update it from tablets, phones etc. It can either be printed off (double sided works best) before Sacrament meeting, or printed to PDF and emailed to the person conducting.

It also makes use of a Google script to archive weeks which have passed, and to hide or show certain rows depending on whether its a Fast Sunday. I'm not a professional programmer, so if anyone has suggestions for code improvement they'll be happily received.

Finally it has two graphs to show all those who have given prayers or talks in the past 12 months.

Feel free to mess around and change it as required, and repost any improvements.

https://goo.gl/JsgfkK - Creates a copy in Google Drive

https://goo.gl/1XpfqG - View only version if problems with link above

Looks great until you enable editing. I agree with lystadk's post. I don't see the updated version that makes this work. I also have the same question as jim.plant143 above. Is there functionality on churchofJesusChrist.org that would enable a posting of Sunday bulletin?

kdsgraham wrote:Is there functionality on churchofJesusChrist.org that would enable a posting of Sunday bulletin?

Not currently, and I'm not aware of any plans.

I have just downloaded the v. 2-2 to spot the issues and I have now uploaded a corrected version 2.3.
If you have further problems let me know and I will correct it.

EDIT : The latest version is now v2-4, this includes to highlight Fast Sundays on the correct days since I changed the start date to be in 2019. Small change but makes it easier for people to get started with this.

If you want to print the Agenda, select the Agenda and click print, change the settings to be "Print Active Sheet" and "Fit Sheet on One Page".

To kieranjorgensen, I created a copy of the google sheets and it works great. I created a new tab that contains content we will use for our Sunday bulletin. Is there a way to share just one sheet? Not the archive, upcoming etc. When I share it shares ALL of the sheets.

kvanderstel wrote:To kieranjorgensen, I created a copy of the google sheets and it works great. I created a new tab that contains content we will use for our Sunday bulletin. Is there a way to share just one sheet? Not the archive, upcoming etc. When I share it shares ALL of the sheets.

It's not possible to share only one sheet of a document in Google Drive, however, it is possible to lock some of the sheets so they're view-only, while allowing others to be edited.

It is now 4 years since we started this and I thought it might be useful to share something which could make things much easier for a lot of units who want to create their own sacrament meeting schedule.

Simply go ahead and continue to create a Google Sheet with the information in but instead of using the spreadsheet to enter and alter the information you now link up the spreadsheet with a mobile app you create without the use of a single line of code.

The tool to use is https://www.glideapps.com

I have already tried it and it only took me minutes to create a sacrament meeting schedule app based on my existing spreadsheet. It has the advantage those inputting the information can do it easier on their mobile.

I have several problems, I'm not too skilled at this, hopefully you can assist:

My dates are wrong, today Oct 28, and yes I tried to convert from Euro to U.S. on the formats, maybe I broke it
my next Upcoming date is 11/17/2019, should be 11/2/2019
Archive shows 11/10/2019, should be Oct 27

kvanderstel wrote:I have several problems, I'm not too skilled at this, hopefully you can assist:

My dates are wrong, today Oct 28, and yes I tried to convert from Euro to U.S. on the formats, maybe I broke it
my next Upcoming date is 11/17/2019, should be 11/2/2019
Archive shows 11/10/2019, should be Oct 27

Without seeing it it is hard to work out where the problem is.
Send me a private message and you can share it with me so I can see it and work out where the problem is.

It is possible to make any document, spreadsheet, presentation able to be viewed, linked, and distributed online.

Setup a "free" Google account (gmail) if you don't already have one.
Upload the document onto your Google Drive
Click Share the document, and copy the URL for it's location
Broadcast the link to Ward/ Stake/ Group membership
You can also make any of these documents/ forms editable - live and interactive (another discussion)[/list][/list]

I hope this helps.

Charlie

crobertson3 wrote:Broadcast the link to Ward/ Stake/ Group membership

If you go back a few posts there is this post by kennethjorgensen in which he recommends:

kennethjorgensen wrote:Simply go ahead and continue to create a Google Sheet with the information in but instead of using the spreadsheet to enter and alter the information you now link up the spreadsheet with a mobile app you create without the use of a single line of code.

The tool to use is https://www.glideapps.com

how do I access the Edgemont 11 Ward Sacrament meeting

kcbaird wrote:how do I access the Edgemont 11 Ward Sacrament meeting

You'll need to contact someone active or in leadership in that ward. To find contact information for the bishop of that ward, use the Meetinghouse Locator ( https://www.churchofjesuschrist.org/map ... 0&lang=eng ) and enter an address in that ward.

Where do we find the weekly message that goes onto the Sunday Bulletin under the picture of Jesus on the front of the bulletin?

susanssmith2012 wrote:Where do we find the weekly message that goes onto the Sunday Bulletin under the picture of Jesus on the front of the bulletin?

There's no Church-provided weekly message or bulletin design. Leaders in each ward decide what information, images, and/or quotes a bulletin should have (and some wards don't have a bulletin at all).

When I was doing the bulletin a couple years back I created a program and would also upload it to [URL removed]. if anyone is interested I can dig up the file but it is done in MS Publisher (I get it as part of my MS HUP)

There are a lot of good ideas here but being a graphic designer, I like to have more design control than word editors or spreadsheets afford. I just have a template in a program called Affinity Publisher (you can use what's comfortable), convert it to a pdf, then upload it to google drive. It is emailed to a list and there are QR codes linked to the program outside of the chapel people can scan. It's not the best or the easiest but we have cut back on printing from 80 to 10 and we are about done with printing at all at this point.

I made the program interactive. you can find an example here: https://docs.google.com/document/d/1qZ_ ... ue&sd=true