Electronic Sacrament Meeting program

Do you have a useful link that involves the Church and the technology discussed on this site? Post your links and resources here.
kennethjorgensen
Community Moderators
Posts: 421
Joined: Mon Sep 10, 2007 12:29 am
Location: Alnwick, UK

Electronic Sacrament Meeting program

Postby kennethjorgensen » Tue Nov 24, 2015 3:14 pm

LDS Ward Sacrament Meetings v2-2.xls
(169.5 KiB) Downloaded 73 times
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
LDS Ward Sacrament Meetings v2-1.xls
(169 KiB) Downloaded 415 times

LDS Ward Sacrament Meetings v2-2.xls
(169.5 KiB) Downloaded 73 times

kennethjorgensen
Community Moderators
Posts: 421
Joined: Mon Sep 10, 2007 12:29 am
Location: Alnwick, UK

Re: Electronic Sacrament Meeting program

Postby kennethjorgensen » Thu Jan 07, 2016 5:17 am

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

tylerjamessmith1
New Member
Posts: 2
Joined: Sun Feb 26, 2017 2:21 pm

Re: Electronic Sacrament Meeting program

Postby tylerjamessmith1 » Sun Mar 26, 2017 1:22 pm

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

kennethjorgensen
Community Moderators
Posts: 421
Joined: Mon Sep 10, 2007 12:29 am
Location: Alnwick, UK

Re: Electronic Sacrament Meeting program

Postby kennethjorgensen » Sun Mar 26, 2017 10:31 pm

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.

tylerjamessmith1
New Member
Posts: 2
Joined: Sun Feb 26, 2017 2:21 pm

Re: Electronic Sacrament Meeting program

Postby tylerjamessmith1 » Sun Apr 16, 2017 9:23 am

Fantastic work Brother Jorgensen! Thank you

lystadk
New Member
Posts: 1
Joined: Fri Dec 30, 2016 8:28 pm

Re: Electronic Sacrament Meeting program

Postby lystadk » Tue Aug 22, 2017 3:11 pm

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

kennethjorgensen
Community Moderators
Posts: 421
Joined: Mon Sep 10, 2007 12:29 am
Location: Alnwick, UK

Re: Electronic Sacrament Meeting program

Postby kennethjorgensen » Sat Dec 23, 2017 2:33 pm

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.

ngoodl
New Member
Posts: 2
Joined: Fri Dec 02, 2016 9:23 pm

Re: Electronic Sacrament Meeting program

Postby ngoodl » Wed Dec 27, 2017 7:20 pm

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

kennethjorgensen
Community Moderators
Posts: 421
Joined: Mon Sep 10, 2007 12:29 am
Location: Alnwick, UK

Re: Electronic Sacrament Meeting program

Postby kennethjorgensen » Thu Dec 28, 2017 3:47 am

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.


Return to “Links & Resources”

Who is online

Users browsing this forum: No registered users and 1 guest