ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
6
7
8
9
10
11
12
13
You will get a security prompt that reads: Protected View> Be careful files from the Internet can contain viruses
14
Unless you need to edit, it's safer to stay in Protected View. Click: Enable Editing to begin your input.
15
Please review the instructions below for using the excel worksheets/workbook.
16
 Step 1
Please review the bottom of this open sheet which is identified as "Instructions." . To the left of your Instruction
17
sheet you will see a couple of arrows (use these to assist you in navigating between sheets left or right)
18
Note: There are a total of "five" sheets created for inputting your Compliments.
19
See Worksheets Examples Below:
20
1st2nd3rd4th5th
21
Compliment 1 WorksheetsCompliment 2 WorksheetsCompliment 3 WorksheetsCompliment 4 WorksheetsCompliment 5 Worksheets
22
23
Step 1
To begin using the form please select "Compliment Worksheet 1" (this is the the 1st sheet of 5 Compliment Worksheets
24
in the Compliment Workbook.
25
26
Step 2
In "Compliment Worksheet 1 " type the required information in the spaces provided next to each heading
27
listed, the Supervisor's Name, Jurisdiction Name, Prelate Name, Contact Telephone Number
28
Once you enter the above information, no need to enter it again on the remaining worksheets. The Supervisor's Name
29
and Jurisdiction Name is automatically carried over to ALL the other worksheets in the workbook.
30
31
Step 3
Under the column entitled "Names" began typing each patron's name (one person per line). On that same line,
32
TAB over beneath the column entitled "Amount Received and type 3 for the $3.00 patron gave.
33
Or whatever dollar amount given by each patron Example: ( 6 for $6.00 and so on) to report the dollar amount
34
collected from each person.
35
Do not skip lines when entering information. IT IS NOT NECESSARY TO TYPE THE PERSON NAME TWICE.
EXAMPLE: JOHN DOE PAID $6.00 DOLLARS TYPE IN 6
36
37
Please refrain from using "TITLES" except those in the following list: Bishop, Supervisor (Supv.),
38
Assistant Supervisor (Asst. Supv.), Administrative Assistant (Admn. Asst.), Supertendent (Supt.),
39
and District Missionary (DM).
40
41
NOTE:
DO NOT USE INDIVIDUAL SHEETS TO DISPLAY BY DISTRICT. If you desire to show by
42
"District" please add District Name followed by Names and Amount Received on the same sheet
43
per Supervisor until the sheet is filled down to the last line of each Worksheets)
44
Please proceed to Step 4 once you type on the last line of each worksheet.
45
46
Step 4
Select "Compliments 2 Worksheets " and continue to type remaining "Name(s) and the "Amount Received" a line per person.
47
Remember: No need to re-enter Supervisor's Name and Jurisdiction Name, once this information is entered on
48
"Compliment 1 Worksheets" it is automatically added to all the other worksheets in the entire workbook.
49
50
Reminder:
51
Please use all lines provided in each Compliment Worksheet before selecting the next set of Compliment Worksheets.
52
Do not skip lines when inputting/typing your patrons information.
53
NOTE:
DO NOT COPY AND PASTE INTO FORMS. USE THE WORKSHEETS PROVIDED (Compliment Worksheets 1 thru Compliment
54
Worksheet 5).
55
56
Explaining Totals:
57
The "Sheet Total": Each worksheet is designed to automatically calculate the $3.00 entries you
58
typed in the "Amount Received" column.
59
60
The "Grand Total" found ONLY on the first page of the workbook entitled "Compliment 1 Worksheets .
61
This field is designed to give you a combined total of all the monies you input on every sheet you
62
used in the workbook.
63
64
65
Printing Excel Sheet(s)/Workbook
66
Please follow the instructions for printing.
67
68
AFTER YOU FINISHED INPUTTING ALL YOUR PATRONS AND THEIR MONIES FOR EACH COMPLIMENT WORKSHEETS.
69
70
Step 1
CLICK ON FILE LOCATED IN THE TOP LEFT HAND CORNER
71
A DROP DOWN MENU WILL APPEAR.
72
73
Step 2CLICK ON PRINT
74
ON YOUR RIGHT YOU SHOULD SEE PART OF YOUR COMPLIMENT INVOICE YOU JUST CREATED.
75
76
Step 3
UNDER SETTINGS YOU WILL FIND SEVERAL CHOICES FOR PRINTING.
77
CLICK ON THE DOWN ARROW ______ NEXT TO THE FIRST CHOICE THAT READS "PRINT ACTIVE SHEETS"
78
A DROPPED DOWN LIST OF 3 PRINTING CHOICES WILL APPEAR. HERE YOU MAY CHOOSE TO PRINT ENTIRE WORK BY
79
CLICKING ON THAT SELECTION OR WHICHEVER METHOD YOU CHOOSE TO USE.
80
SAFE TIP: TO AVOID POSSIBLE PAPER JAMS, YOU MAY CHOOSE TO PRINT A FEW PAGES AT A TIME.
81
82
83
UNDER SETTINGS FIND THE WORD “ PAGES”: THERE SHOULD BE TWO BOXES WITH UP AND DOWN
84
ARROWS. HERE YOU WILL INPUT WHAT PAGES YOU WOULD LIKE TO PRINT.
85
OR
86
CLICK PRINT AND ALL THE INFORMATION YOU ENTERED ON THE OPENED COMPLIMENT SHEETS WILL PRINT.
87
ALL THE SHEETS IN THIS PARTICULAR WORKSHEET FILE.
88
STARTING WITH PAGE 1 – PAGE 22
89
90
WHILE UNDER THE PRINT MENU; LOOK NEAR THE BOTTOM OF THE SHEET TO BE PRINTED; YOU
91
WILL SEE THE NUMBER OF PAGES YOU WILL BE PRINTING ON THIS COMPLEMENT
92
 WORKSHEET ONLY.
93
94
TO PRINT THE OTHER COMPLIMENT WORKSHEETS CLICK ON THAT SET OF WORKSHEETS AND FOLLOW STEPS 1
95
THRU 3 UNTIL YOU HAVE COMPLETE PRINTING ALL YOUR INPUTTED WORK.
96
97
NOTE:
TO NAVIGATE BETWEEN SHEETS: AT THE BOTTOM LEFT CORNER OF YOUR SCREEN; YOU WILL SEE
98
ONE OR TWO ARROWS. CLICKING ON ONE (ARROW) WILL ALLOW YOU TO MOVE RIGHT OR LEFT OF
99
THIS WORKBOOK. IF YOU CANNOT SEE COMPLIMENT 4 AND 5 WORKSHEETS, USE THESE
100
ARROWS TO MOVE TO WHERE YOU CAN SEE THOSE COMPLEMENT SHEETS.