Tithing Settlement

Use this forum to discuss issues that are not found in any of the other clerk and stake technology specialist forums.
pelschaumkel
New Member
Posts: 1
Joined: Tue Aug 26, 2014 3:40 am

Tithing Settlement

Postby pelschaumkel » Mon Oct 26, 2015 5:54 am

Does anyone have a tithing settlement sign up sheet that they use? I know I can create one myself but just curious to see what others use.

bballrob
Member
Posts: 106
Joined: Wed Sep 14, 2011 6:20 am
Location: The Great White North

Re: Tithing Settlement

Postby bballrob » Thu Oct 29, 2015 8:24 am

We just use a simple form we've created in Excel. Unfortunately, it's still parked on the clerk's office computer and not in the cloud so I can't share a copy with you at the moment.

davesudweeks
Senior Member
Posts: 550
Joined: Sun May 09, 2010 8:16 pm
Location: Owasso, OK, USA

Re: Tithing Settlement

Postby davesudweeks » Thu Oct 29, 2015 10:25 am

We used a very simple format that can be easily regenerated in different software programs. It was essentially a 2-column table with times down the left (depending on how long the bishop wants to allow per family) and a blank on the right for the families to sign up. Sometimes the bishop asked for short times and then encouraged larger families to sign up for 2 or 3 blocks. Other times we would try to move people up if the bishop got ahead of the schedule.

We only would put out a few sheets at a time to encourage families to sign up earlier rather than wait for the last available slot. Some members erroneously think that they cannot have tithing settlement before they have paid all their tithing for the year.

russellhltn
Community Administrator
Posts: 20767
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Tithing Settlement

Postby russellhltn » Thu Oct 29, 2015 10:37 am

Here's a little trick when using spreadsheets: By using formulas and cut and paste, you can easily create a number of slots without having to type each one.

Example:

For cell A1, enter "Time" for the header
For cell A2, enter the first time slot (example 1:00 PM)
For cell A3, enter "=TIMEVALUE("0:10")+A2" to create increments of 10 minutes.
Copy cell A3 and paste it for the rest of column A for the page.

Bingo, you now have a grid of sign-up times. Need a new set for Tuesday starting at 6:00 PM? Just enter 6:00 PM in cell A2 - the rest will self-calculate.
Have you searched the Wiki?
Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.

User avatar
johnshaw
Senior Member
Posts: 1839
Joined: Fri Jan 19, 2007 1:55 pm
Location: Syracuse, UT

Re: Tithing Settlement

Postby johnshaw » Wed Nov 04, 2015 1:33 pm

Whatever you do can it the sacred funds request form, my current stake has an interesting form.
“A long habit of not thinking a thing wrong, gives it a superficial appearance of being right, and raises at first a formidable outcry in defense of custom.”
― Thomas Paine, Common Sense

User avatar
sbradshaw
Senior Member
Posts: 2494
Joined: Mon Sep 26, 2011 8:42 pm
Location: Provo, UT
Contact:

Re: Tithing Settlement

Postby sbradshaw » Wed Nov 04, 2015 10:02 pm

russellhltn wrote:Here's a little trick when using spreadsheets: By using formulas and cut and paste, you can easily create a number of slots without having to type each one.

Example:

For cell A1, enter "Time" for the header
For cell A2, enter the first time slot (example 1:00 PM)
For cell A3, enter "=TIMEVALUE("0:10")+A2" to create increments of 10 minutes.
Copy cell A3 and paste it for the rest of column A for the page.

Bingo, you now have a grid of sign-up times. Need a new set for Tuesday starting at 6:00 PM? Just enter 6:00 PM in cell A2 - the rest will self-calculate.

You can also type "1:00 PM" in one cell, then "1:10 PM" in the cell below it, select both cells, and drag the little square on the bottom right corner of the selection border downward. When you let go, it will automatically fill in the rest of the times on 10-minute increments.
Samuel Bradshaw • Interested in church apps and sites, creative recordkeeping, clerk support, YSA wards and stakes, LDS music, Vineyard at BYU, and online service.

russellhltn
Community Administrator
Posts: 20767
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Tithing Settlement

Postby russellhltn » Wed Nov 04, 2015 11:05 pm

sbradshaw wrote:You can also type "1:00 PM" in one cell, then "1:10 PM" in the cell below it, select both cells, and drag the little square on the bottom right corner of the selection border downward. When you let go, it will automatically fill in the rest of the times on 10-minute increments.

Nice! Will that work in open/libreoffice as well?
Have you searched the Wiki?

Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.

User avatar
gregwanderson
Senior Member
Posts: 696
Joined: Thu Apr 15, 2010 9:34 pm
Location: Huntsville, UT, USA

Re: Tithing Settlement

Postby gregwanderson » Thu Nov 05, 2015 10:38 am

Yes, the trick that sbradshaw told us to try will work on LibreOffice. I just tried it.

User avatar
sbradshaw
Senior Member
Posts: 2494
Joined: Mon Sep 26, 2011 8:42 pm
Location: Provo, UT
Contact:

Re: Tithing Settlement

Postby sbradshaw » Fri Nov 06, 2015 11:50 pm

It also works for other increments, such as months – start typing January, February, then drag to fill in the rest of the months. This works in Excel, Numbers, and Google Sheets, so it will probably work in OpenOffice and LibreOffice too.
Samuel Bradshaw • Interested in church apps and sites, creative recordkeeping, clerk support, YSA wards and stakes, LDS music, Vineyard at BYU, and online service.

lehrschallbrian
Member
Posts: 79
Joined: Wed Apr 14, 2010 6:56 am
Location: Raleigh, North Carolina

Re: Tithing Settlement

Postby lehrschallbrian » Mon Nov 09, 2015 6:44 am

We use a signupgenius


Return to “General Clerk Discussions”

Who is online

Users browsing this forum: No registered users and 1 guest