~dricottone/fmg-timesheets

ref: c041ec57595dc0e315a64b892633df30acf57509 fmg-timesheets/notes -rw-r--r-- 1.0 KiB
c041ec57Dominic Ricottone Initial commit 2 years ago
                                                                                
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)