Spreadsheet: 93191d1292794638-conditional-format-based-on-sum-of-value-assigned-to-partial-text-field-shift-schedule-live
Sheet: Dec26 - Jan8

NAME | 2010-12-26 00:00:00 | 2010-12-27 00:00:00 | 2010-12-28 00:00:00 | 2010-12-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00
 | 2010-12-26 00:00:00 | 2010-12-27 00:00:00 | 2010-12-28 00:00:00 | 2010-12-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00
a |  | A-LAX |  | A-LAX | A-LAX |  |  |  | A-LAX | A-LAX |  | A-LAX
b | P-AX |  | A-AX |  | A-AX | A-LAX |  | P-AX |  |  |  | A-AX | A-AX
c | X | X |  |  | A-FO |  |  | A-AX | X |  |  |  | A-AX | A-AX
d
e | X | A-FO | A-FO | P-FO |  |  |  |  |  | P-AX | P-AX |  |  | P-AX
f | X | X | X | X | X | X | X | X | x |  |  |  | P-LAX | P-LAX
g | X |  |  |  |  |  | A-FO | D-FO |  |  |  |  |  | X
h | X | E-AX |  | E-AX |  |  | A-FO |  | A-FO |  | A-FO | A-FO
i |  |  | P-LAX |  |  | P-LAX | P-LAX |  |  |  |  | P-AX
j | X | X | X |  |  | X | X |  | P-AX | X | 7p-11p AX
k | X | X | X | X | P-LAX |  |  |  |  |  |  |  | P-AX
l | X | X | X | X | A-FO |  |  | A-FO |  |  | D-FO |  | D-FO
m |  | A-FO |  | D-AX | A-FO |  | A-AX | A-AX |  | A-AX | A-AX |  |  | A-AX
n |  | A-AX | A-AX | D-AX |  | X | X | X | X | X | X | X | X
o | X | X | A-AX | A-AX | A-AX |  |  |  |  | A-AX |  |  | A-AX | A-AX
p | X |  | D-FO |  |  | A-FO | A-LFO |  |  | A-LFO |  | A-LFO
q | A-AX |  |  |  |  | A-AX | A-AX | A-AX |  |  |  |  |  | A-AX
r |  |  | A-LFO | A-LFO | A-LFO | A-LFO |  |  | R | V | V | V | R | R
s | X | P-LAX |  | P-LAX | P-AX | X | X | X | X | X | X | X | X | P-AX
t
u | X | D-AX |  |  |  |  |  | D-AX | D-AX | X | D-AX
v |  | P-FO | P-FO |  |  | E-AX |  |  | P-FO | P-FO |  |  | E-FO
w | X | A-LFO | A-FO |  |  |  |  |  |  |  | A-LFO | A-FO
x | P-FO |  |  |  |  | P-FO |  | P-FO |  | E-FO | A-FO
y |  | A-AX |  |  | A-AX | A-AX | D-AX
z |  |  | P-FO | P-FO | P-FO |  |  | X | X | X | X | X | X | RES
aa |  |  |  |  |  |  |  | 7p-11p AX |  |  |  |  |  | 7p-11p FO
bb |  |  |  | P-FO | P-FO | X | N-FO |  | P-FO | P-FO | P-FO
cc |  |  |  | A-AX
dd |  |  | E-AX |  | E-AX |  |  |  |  | E-AX |  | E-AX
ee | X | X |  |  | X | X | E-FO | x | x | x | N-FO | N-FO |  | N-FO
ff | X | X | X | X | X | X | R | X | X |  | A-AX | A-AX | A-AX
gg | Resigned | Resigned | Resigned | Resigned | Resigned | Resigned | Resigned | Resigned | Resigned | Resigned | Resigned | Resigned | Resigned | Resigned
hh | A-AX | A-AX |  |  |  | A-FO | A-FO |  | A-FO |  |  | A-FO | A-FO
ii | X | X | X |  | A-AX | D-AX |  |  | A-AX | A-AX | A-AX
jj | A-FO | R/O | R/O | R/O | R/O | R/O | R/O | R/O | R/O | R/O | R/O | R/O | R/O | R/O
kk | A-FO | X | X | X | X | X | A-FO | A-FO |  |  |  |  |  | A-FO
ll | A-AX |  | A-LAX | A-FO | X | X | X | X | X | A-FO |  |  | A-FO | A-FO
[NAME] | X | X | A-AX |  |  | A-AX | P-AX | X | X | A-FO |  | P-FO | P-FO
nn | P-LFO |  |  |  |  | P-LFO | P-LFO | P-LFO |  |  |  |  | P-LFO | P-LFO
oo | P-FO | P-FO |  |  |  | P-FO
pp
qq | d-fo | d-fo | d-fo | d-fo | d-fo |  |  |  |  |  |  |  |  |  |  | fine
New Employee
rr
ss |  |  |  |  |  |  |  |  | D
tt |  |  |  |  |  |  |  |  | D
uu |  |  |  |  |  |  |  |  | D
vv
ww
xx
yy
FO SHIFT TOTAL
0700 - 1100 | 2 | 3 | 4 | 2 | 4 | 3 | 5 | 3 | 2 | 3 | 4 | 4 | 3 | 2
1100 - 1500 | 2 | 3 | 4 | 2 | 4 | 3 | 5 | 3 | 2 | 3 | 4 | 4 | 3 | 2
1500-1900 | 2 | 3 | 3 | 2 | 4 | 3 | 6 | 2 | 2 | 4 | 3 | 4 | 3 | 2
1900 - 2300 | 3 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 2 | 3 | 1 | 1 | 3 | 1
2300 - 0300 | 3 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
0300 - 0700 | 3 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
AM Lead? | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
PM Lead? | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Need at FO
AX SHIFT TOTAL
0700 - 1100 | 3 | 5 | 5 | 5 | 5 | 5 | 3 | 4 | 3 | 4 | 4 | 3 | 4 | 4
1100 - 1500 | 3 | 5 | 5 | 5 | 5 | 5 | 3 | 4 | 3 | 4 | 4 | 3 | 4 | 4
1500-1900 | 3 | 5 | 6 | 4 | 6 | 5 | 2 | 3 | 2 | 5 | 3 | 4 | 4 | 4
1900 - 2300 | 1 | 2 | 2 | 2 | 3 | 2 | 2 | 1 | 1 | 2 | 1 | 2 | 2 | 3
2300 - 0300 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 3
0300 - 0700 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 3
AM Lead? | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
PM Lead? | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Need at AX
Shift Guide | A- | 0700-1900
 | D- | 0700-1500
 | E- | 1500-2300
 | P- | 1900-0700
 | N- | 2300-0700