ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Session NumberThe Session Number only needs to be entered one time on the RapidTimeEntryTemplate
2
tab. The CopySessionNumber macro copies the Session Number from the first cell to all cells
3
in the Session Number column and displays an error message if it is missing. Cells in error are
4
marked in RED, warnings are marked in YELLOW.
5
6
Empl IDThe RapidTimeEntryTemplate tab uses the EmplIDLeadingZeros macro to force leading
7
zeros when the client enters an Empl ID that is less than 6-digits and converts it to Text
8
format. It uses the ValidateEmplID macro to make sure there is a value in the Empl ID column and
9
displays an error message if it is missing. Cells in error are marked RED, warnings are marked in
10
YELLOW.
11
12
Empl RecordThis column is pre-defined as Number with a format of -1234.
13
The RapidTimeEntryTemplate tab uses the ValidateEmplRecPositionNbr macro to make sure the
14
Empl Record is between 0 and 99 and displays a warning message if any Empl Records are not
15
within those limits. It also makes sure that if the Empl Record is blank there is a value in the
16
corresponding Position Number. Cells in error are marked RED, warnings are marked in YELLOW.
17
18
Date Under ReportThis column is pre-defined as Date with a format of MM/DD/YYYY.
19
The RapidTimeEntryTemplate tab uses the ValidateDateUnderReport macro to make sure the
20
Date Under Report is a valid date and it is equal to or greater than (after) January 1, 2014, and if not
21
the date is marked as an error. It also checks to see if the Date Under Report is 6 months before
22
today's date or 1 month after today's date, and if so the date is marked with a warning. Cells in error
23
are marked RED, warnings are marked in YELLOW.
24
25
Sequence NumberSequence Number Formula: IF(B3 = B2, IF(C3 = C2, IF(D3 = D2, E2 + 1,1),1),1)
26
The Sequence Number is automatically incremented by 1 when the combination of
27
Empl ID, Empl Record, and Date Under Report are all equal.
28
The RapidTimeEntryTemplate tab uses the CopySequenceNumber macro to copy the Sequence
29
Number formula from the first cell to all cells in the Sequence Number column.
30
31
Time Reporting CodeThe RapidTimeEntryTemplate tab uses the ConvertTRCtoUppercase macro to convert TRC codes
32
to be UPPERCASE.
33
The RapidTimeEntryTemplate tab uses the ValidateTRC macro to make sure there is a value in the
34
Time Reporting Code, it is found on the TRC tab and displays an error message if it is missing.
35
Cells in error are marked RED, warnings are marked in YELLOW.
36
37
QuantityThis column is pre-defined as Number with a format of -1234.10.
38
The RapidTimeEntryTemplate tab uses the ValidateQuantity macro to make sure the quantity for
39
hour/unit TRCs is between 0.01 and 24, the quantity for amount TRCs is between 0.01 and 300, and
40
displays a warning message if any quantities are not within those limits. The quantity should only have a
41
max of 2 decimal places. The macro displays a critical error message when the quantity has more than
42
2 decimal places. Cells in error are marked RED, warnings are marked in YELLOW,
43
44
Override RateThis column is pre-defined as Number with a format of -1234.10.
45
The RapidTimeEntryTemplate tab uses the ValidateOverrideRatey macro to make sure the optional
46
Override Rate is between 0.01 and 130 and displays a warning message if any rates are not within
47
those limits. Less than the minimum is an error but greater than the maximum is a warning. An
48
Override Rate with an amount TRC is an error. Cells in error are marked RED, warnings are marked
49
in YELLOW.
50
51
Combination CodeThe RapidTimeEntryTemplate tab uses the ComboCodeLeadingZeros macro to force leading zeros
52
when the client enters a 4-digit Combination Code (or one that is less than 9-digits) and convert it
53
to Text format.
54
The RapidTimeEntryTemplate tab uses the ValidateComboCode macro to make sure there is a
55
value in the Combination Code and displays an error message if it is missing. Cells in error are
56
marked RED, warnings are marked in YELLOW.
57
58
Position NumberThis column is pre-defined as Text.
59
The RapidTimeEntryTemplate tab uses the ValidateEmplRecPositionNbr macro to make sure an
60
8-digit position number has been entered and displays an error message if any position numbers are
61
less than or greater than 8-digits in length. It also makes sure that if the Position Number is blank
62
there is a vallue in the corresponding Empl Record column. Cells in error are marked RED, warnings
63
are marked in YELLOW.
64
65
Validate ButtonThe Validate button runs all of the macros to validate and sort data on the RapidTimeEntryTemplate.
66
The Validate should be run after all time entries have been entered and the spreadsheet saved.
67
However, it can be run multiple times as required. If there are more than 500 time entries a warning
68
message will be displayed as the recommended maximum is 500 entries per Session Number.
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