
B 
C 
D 
E 
F 
G 
4 
Team1 





5 
Name 
Start 
End 
Break1 
Break2 
Break3 
6 
Name1 
07:00 
15:30 
=VLOOKUP(C6,Breaks!$A$2:$E$28,3,0) 
=VLOOKUP(C6,Breaks!$A$2:$E$28,4,0) 
=VLOOKUP(C6,Breaks!$A$2:$E$28,5,0) 
7 
Name2 
07:00 
15:30 
=IF(C7=C6,E6+0.01389,VLOOKUP(C7,Breaks!$A$2:$E$28,3,0)) 
=IF(C7=C6,F6+0.0105,VLOOKUP(C7,Breaks!$A$2:$E$28,4,0)) 
=IF(C7=C6,G6+0.00695,VLOOKUP(C7,Breaks!$A$2:$E$28,5,0)) 
8 
Name3 
07:00 
15:30 
=IF(C8=C7,E7+0.01389,VLOOKUP(C8,Breaks!$A$2:$E$28,3,0)) 
=IF(C8=C7,F7+0.0105,VLOOKUP(C8,Breaks!$A$2:$E$28,4,0)) 
=IF(C8=C7,G7+0.00695,VLOOKUP(C8,Breaks!$A$2:$E$28,5,0)) 
9 
Name4 
09:00 
17:30 
=IF(C9=C8,E8+0.01389,VLOOKUP(C9,Breaks!$A$2:$E$28,3,0)) 
=IF(C9=C8,F8+0.0105,VLOOKUP(C9,Breaks!$A$2:$E$28,4,0)) 
=IF(C9=C8,G8+0.00695,VLOOKUP(C9,Breaks!$A$2:$E$28,5,0)) 
10 
Name5 
09:00 
17:30 
=IF(C10=C9,E9+0.01389,VLOOKUP(C10,Breaks!$A$2:$E$28,3,0)) 
=IF(C10=C9,F9+0.0105,VLOOKUP(C10,Breaks!$A$2:$E$28,4,0)) 
=IF(C10=C9,G9+0.00695,VLOOKUP(C10,Breaks!$A$2:$E$28,5,0)) 
11 
Name6 
09:00 
17:30 
=IF(C11=C10,E10+0.01389,VLOOKUP(C11,Breaks!$A$2:$E$28,3,0)) 
=IF(C11=C10,F10+0.0105,VLOOKUP(C11,Breaks!$A$2:$E$28,4,0)) 
=IF(C11=C10,G10+0.00695,VLOOKUP(C11,Breaks!$A$2:$E$28,5,0)) 
12 
Name7 
09:00 
17:30 
=IF(C12=C11,E11+0.01389,VLOOKUP(C12,Breaks!$A$2:$E$28,3,0)) 
=IF(C12=C11,F11+0.0105,VLOOKUP(C12,Breaks!$A$2:$E$28,4,0)) 
=IF(C12=C11,G11+0.00695,VLOOKUP(C12,Breaks!$A$2:$E$28,5,0)) 
13 
Name8 
11:30 
20:00 
=IF(C13=C12,E12+0.01389,VLOOKUP(C13,Breaks!$A$2:$E$28,3,0)) 
=IF(C13=C12,F12+0.0105,VLOOKUP(C13,Breaks!$A$2:$E$28,4,0)) 
=IF(C13=C12,G12+0.00695,VLOOKUP(C13,Breaks!$A$2:$E$28,5,0)) 
14 
Name9 
11:30 
20:00 
=IF(C14=C13,E13+0.01389,VLOOKUP(C14,Breaks!$A$2:$E$28,3,0)) 
=IF(C14=C13,F13+0.0105,VLOOKUP(C14,Breaks!$A$2:$E$28,4,0)) 
=IF(C14=C13,G13+0.00695,VLOOKUP(C14,Breaks!$A$2:$E$28,5,0)) 
15 
Name10 
13:30 
22:00 
=IF(C15=C14,E14+0.01389,VLOOKUP(C15,Breaks!$A$2:$E$28,3,0)) 
=IF(C15=C14,F14+0.0105,VLOOKUP(C15,Breaks!$A$2:$E$28,4,0)) 
=IF(C15=C14,G14+0.00695,VLOOKUP(C15,Breaks!$A$2:$E$28,5,0)) 
16 
Name11 
13:30 
22:00 
=IF(C16=C15,E15+0.01389,VLOOKUP(C16,Breaks!$A$2:$E$28,3,0)) 
=IF(C16=C15,F15+0.0105,VLOOKUP(C16,Breaks!$A$2:$E$28,4,0)) 
=IF(C16=C15,G15+0.00695,VLOOKUP(C16,Breaks!$A$2:$E$28,5,0)) 
17 
Name12 
13:30 
22:00 
=IF(C17=C16,E16+0.01389,VLOOKUP(C17,Breaks!$A$2:$E$28,3,0)) 
=IF(C17=C16,F16+0.0105,VLOOKUP(C17,Breaks!$A$2:$E$28,4,0)) 
=IF(C17=C16,G16+0.00695,VLOOKUP(C17,Breaks!$A$2:$E$28,5,0)) 
18 
Name13 
13:30 
22:00 
=IF(C18=C17,E17+0.01389,VLOOKUP(C18,Breaks!$A$2:$E$28,3,0)) 
=IF(C18=C17,F17+0.0105,VLOOKUP(C18,Breaks!$A$2:$E$28,4,0)) 
=IF(C18=C17,G17+0.00695,VLOOKUP(C18,Breaks!$A$2:$E$28,5,0)) 
19 
Name14 
13:30 
22:00 
=IF(C19=C18,E18+0.01389,VLOOKUP(C19,Breaks!$A$2:$E$28,3,0)) 
=IF(C19=C18,F18+0.0105,VLOOKUP(C19,Breaks!$A$2:$E$28,4,0)) 
=IF(C19=C18,G18+0.00695,VLOOKUP(C19,Breaks!$A$2:$E$28,5,0)) 
20 
Name15 
15:30 
00:00 
=IF(C20=C19,E19+0.01389,VLOOKUP(C20,Breaks!$A$2:$E$28,3,0)) 
=IF(C20=C19,F19+0.0105,VLOOKUP(C20,Breaks!$A$2:$E$28,4,0)) 
=IF(C20=C19,G19+0.00695,VLOOKUP(C20,Breaks!$A$2:$E$28,5,0)) 
21 
Name16 
15:30 
00:00 
=IF(C21=C20,E20+0.01389,VLOOKUP(C21,Breaks!$A$2:$E$28,3,0)) 
=IF(C21=C20,F20+0.0105,VLOOKUP(C21,Breaks!$A$2:$E$28,4,0)) 
=IF(C21=C20,G20+0.00695,VLOOKUP(C21,Breaks!$A$2:$E$28,5,0)) 
Bookmarks