1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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
index 20px
timecode (usually "ST") 40px
project 39px
timetype 201px
day1 571px or 572px
day2 597px
day3 622px
day4 646px or 647px
day5 671px or 672px
day6 696px or 697px
day7 721px or 722px
rowtotal 751px or 753px or 756px
document header:
"Timesheet"
"Mon N, YYYY - Mon N, YYYY"
"Location:"
"[E01] Fors Marsh Group"
"Department:"
"[3200] Advanced Analytics"
"Employee Type:"
"[1] Annual Salary"
"Location (Default"
"[LOCAL] Location"
"Function:"
"Exempt:"
"Status:"
"[1] Full Time"
"Yes"
"Approved"
"Post Status:"
"Validation:"
"Date/Time:"
"Posted"
"Passed"
"Mon N, YYYY HH:MM"
"Total Tomesheet:"
"Standard Hours:"
"Total Billable:"
"Percent Billability:"
<total hours on spreadsheet>
<minimum hours for spreadsheet>
<total billable hours on spreadsheet>
<total billable hours / total hours>
left column header:
"ID"
"Time Code"
"Project"
"TimeType"
right colummn header:
"Mon"
"Tues Wed"
"Thu"
"Fri"
"Sat"
"Sun"
(or some cycled version of this)