Zmanim Charts

Introduction

 

As explained on the home page the function of the Member Database is to create a central location to manage all lists. The basic concept is that all the information related to each Shul member, family member, and guest are located in one Google Sheet. That information is used multiple times in other tabs within that sheet (or workbook in Excel vernacular) and in other sheets. When updating or adding a member to the master list, their information gets populated on any other list they belong to, based on the information chosen on the master list. Each sublist has specific fields and specific formatting for its intended use and contains only the type of member that belongs on that list. Keep on reading the below sections and this will become clear.

Set Up

Members Info

This tab contains all information for all Shul members and family members

  1. Contact Information [Name, Address, Phone Number]
  2. Member Type [Regular, Occasional, Family]
  3. Notification Preferences [Email or SMS for Billing, Membership, and Simchas]
  4. Information for Aliyas [Hebrew name and fathers name, כהן\לוי\ישראל]
  5. Yartzeit info, Wifes Hebrew name and father’s and mother’s name for Mi Shebeirach]

Gabbai List

A list for the Gabbai automatically gets populated from the member database.

  • This is a tab in the worksheet that will automatically add each member that has a name for Aliya listed
  • This list is automatically sorted by  כהן-לוי-ישראל
  • All you need to do is print this sheet out; it updates itself based on the information added to the member database

Aliya Cards

Similar to the Gabbai list above, a list of names and information for Aliya cards is generated based on the member database.

  • On the member database, there is a column that you can choose yes/no to control which people cards are printed for as you don’t necessarily want to print cards for all family members and guests
  • This list updates itself