Spreadsheet: 00bf2ad1-6a22-48c2-981a-2fba9dd825f9
Sheet: Sheet1

TALLY SHEET CALCULATOR | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
Begin by entering your chapter name and select your state from the drop down list in the blue fields. Enter your name and contact information as well as the date. Next, enter the number of members in each category in the yellow shaded fields; the division amount will be calculated automatically based on the state you selected. Any special amounts should be noted in the green shaded fields. The spreadsheet will do all the calculations--just print two copies and submit along with your check! You can also save the completed sheet as an Excel file for future reference.
Chapter Name: |  |  |  |  |  |  |  |  |  |  |  | State:
Your Name: |  |  |  |  |  |  |  |  |  |  |  | Phone:
E-mail: |  |  |  |  |  |  |  |  |  |  |  | Date:
National Dues |  |  | # | Rate |  |  | # | Rate |  |  | # | Rate | Line item Total
New Individual Members (RG)
 |  | 1 Year |  | 40 |  | 1/2 Year |  | 20 |  | 1-1/2 Year |  | 60 | 0 |  |  |  |  |  | STATE | RG-LF-LB | FM-FL-FB | ST | YH | SC | SR | SF
New Family Members (FM) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alabama | 0 | 0 | 0 | 0
 |  | 1 Year |  | 60 |  | 1/2 Year |  | 30 |  | 1-1/2 Year |  | 90 | 0 |  |  |  |  |  | California | 4.5 | 7.5 | 1 | 0
New Student Members (ST) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Colorado | 1.5 | 2.25 | 0.75 | 0 |  | 30 | 30
 |  | 1 Year |  | 20 |  | 1/2 Year |  | 10 |  | 1-1/2 Year |  | 30 | 0 |  |  |  |  |  | England | 0 | 0 | 0 | 0
New Youth Members (YH) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Florida | 4 | 6 | 0 | 0
 |  | 1 Year |  | 8 |  | 1/2 Year |  | 4 |  | 1-1/2 Year |  | 12 | 0 |  |  |  |  |  | Georgia | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Idaho | 0 | 0 | 0 | 0
Renewing Members |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Illinois | 5 | 7.5 | 2.5 | 2.5 | 2.5
 |  | Individual (RG) |  | 40 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Indiana | 8 | 12 | 6 | 2.5 | 6 | 100 | 150
 |  | Family (FM) |  | 60 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Iowa | 10 | 14 | 5 | 5 |  | 125 | 200
 |  | Student (ST) |  | 20 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Maryland | 5 | 7.5 | 2.5 | 1 |  | 100 | 150
 |  | Youth (YH) |  | 8 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Massachusetts | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Michigan | 0 | 0 | 0 | 0
New Life Memberships |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Minnesota | 12.5 | 15 | 10 | 6.8 |  | 250 | 300
 |  | New Lifes (LF) |  | 1000 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Nebraska | 10 | 15 | 10 | 10
 |  | New Family Lifes (FL) |  | 1500 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | New Jersey | 0 | 0 | 0 | 0
 |  | New Life Benefactors (LB) |  | 2000 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | New York | 2 | 4 | 1 | 1
 |  | New Family Life Benefactors (FB) |  | 2500 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | North Carolina | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North Dakota | 0 | 0 | 0 | 0
Upgrades (use if the member is ALREADY renewed; otherwise, include on the correct renewal line above below) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ohio | 7 | 8 | 0 | 0 |  | 125 | 150
 |  | Upgrading from Student to Individual |  | 20 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Oklahoma | 0 | 0 | 0 | 0
 |  | Upgrading from Individual to Family |  | 20 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Oregon | 5 | 5 | 5 | 5 |  | 50 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pennsylvania | 5 | 10 | 0 | 0
Renewing Life Members |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South Dakota | 10 | 15 | 4 | 0 |  | 75 | 150
 |  | Current Lifes (LF) |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Tennessee | 0 | 0 | 0 | 0
 |  | Current Family Lifes (FL) |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Virginia | 6 | 7 | 2 | 0
 |  | Current Life Benefactors (LB) |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Washington | 0 | 0 | 0 | 0
 |  | Current Family Life Benefactors (FB) |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | West Virginia | 2 | 4 | 1.5 | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wisconsin | 3 | 4.5 | 0 | 0
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wyoming | 0 | 0 | 0 | 0
Total National Dues |  |  |  |  |  |  |  |  |  |  |  |  | 0
Division Dues |  |  | # | Division Rate |  |  | # | Division Rate |  |  | # | Division Rate | Line Item Total
Individual, Life & Life Benefactors (RG, LF, & LB)
 |  | 1 Year | 0 |  |  | 1/2 Year | 0 |  |  | 1-1/2 Year | 0
Family, Family Life & Family Life Benefactors (FM, FL, & FB) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Please review your entries. The total number of members in the division dues section does not match the number of members listed in the national dues section.
 |  | 1 Year | 0 |  |  | 1/2 Year | 0 |  |  | 1-1/2 Year | 0
Students (ST)
 |  | 1 Year | 0 |  |  | 1/2 Year | 0 |  |  | 1-1/2 Year | 0
Youth (YH)
 |  | 1 Year | 0 |  |  | 1/2 Year | 0 |  |  | 1-1/2 Year | 0
Division Seniors (SC)
 |  | 1 Year |  |  |  | 1/2 Year |  |  |  | 1-1/2 Year
New Individual State Life Members
New Family State Life Members
Current State Life Members (SL) |  |  |  | 0 |  |  |  |  |  |  |  |  | 0
Upgrade from Student to Individual |  |  | 0
Upgrade from Individual to Family |  |  | 0
 |  | 0
Total Division Dues
Total National & Division Dues
 |  |  |  | Fill in Amount
IWL Trust or Other Donations (provide details)
Credit Voucher (amount to DEDUCT from total due)
Balance Owed (amount to ADD TO total due)
Total Amount Due for Tally Sheet