ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
@dropdown
2
3
4
5
STEP 2:
6
7
Next step, select the specific day you want to record. If this is your first day using this, use 'Day 1: % of Tips' tab enter each employee's worked hours in the 'Worked hours' column and their tip amounts in the 'Tips' column.
8
9
10
You can enter a single total tip for the day in the yellow cell at the bottom of the 'Tips' column.
11
12
13
STEP 3:
14
Use the 'Total Tip Out' coloumn to calculate each employee's portion and distribute the tips accordingly.
15
16
STEP 4:
17
To create additional sheets with the same calculator functionality as "Day 1" and "Day 2," simply duplicate these existing sheets.
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100