Spreadsheet: 328460d1403901666-complex-if-formula-using-timestamp-allocation-of-meal-tickets-edit
Sheet: Nov 13

Allocation of Meal Tickets
Ticket No: | Name of person ticket issued to | Ticket holders name | Quantity | Course and Code | Date Required | Budget Code | signed by (receptionist)
ie MAY01 | [NAME] | ie Student X / [NAME] | x1 | Specials [NAME] | 1st May 2013 | RTJ | F Sewell
2001-11-01 00:00:00 | mark Baggott | Chrissie Wilding | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | P Bullion
2002-11-01 00:00:00 | mark Baggott | [NAME] Wilding | x1 | Rem Service | 08/11/013 | RTG | P Bullion
3 | mark Baggott | [NAME] | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | P Bullion
4 | mark Baggott | [NAME] | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | P Bullion
5 | mark Baggott | [NAME] | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | P Bullion
6 | mark Baggott | Di Youdan | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | P Bullion
7 | mark Baggott | [NAME] Dykes | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | P Bullion
8 | mark Baggott | [NAME] | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | P Bullion
9 | mark Baggott | [NAME] | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | P Bullion
10 | mark Baggott | [NAME] | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | P Bullion
11 | [NAME] | M Gilroy | x1 | INV SKILLS | 2013-11-06 00:00:00 | RTM | P Bullion
12 | [NAME] | K Hyton | x1 | INV SKILLS | 2013-11-06 00:00:00 | RTM | P Bullion
13 | [NAME] | S [NAME] | x1 | INV SKILLS | 2013-11-06 00:00:00 | RTM | P Bullion
14 | [NAME] | S [NAME] | x1 | INV SKILLS | 2013-11-07 00:00:00 | RTM | N Sarson
15 | [NAME] | [NAME] | x1 | INV SKILLS | 2013-11-07 00:00:00 | RTM | N Sarson
16 | [NAME] | [NAME] | x1 | INV SKILLS | 2013-11-07 00:00:00 | RTM | N Sarson
17 | mark Baggott | [NAME] | x1 | volunteer | 2013-11-08 00:00:00 | RTK | N Sarson
18 | mark Baggott | R Ayes | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | N Sarson
19 | mark Baggott | christine | [NAME] | Rem Service | 2013-11-08 00:00:00 | RTG | N Sarson
20 | mark Baggott | [NAME] | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | N Sarson
21 | mark Baggott | [NAME] | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | N Sarson
22 | mark Baggott | [NAME] | x1 | Rem Service | 2013-11-08 00:00:00 | RTG | N Sarson
23 | mark Baggott | [NAME] | x1 | IPLDP | 2013-11-13 00:00:00 | RTK | P Bullion
24 | mark Baggott | [NAME] | x1 | IPLDP | 2013-11-13 00:00:00 | RTK | P Bullion
25 | [NAME] | Jan Penny | x1 | Custody | 2013-11-12 00:00:00 | RTV | Nur | x
26 | [NAME] | [NAME] | x1 | Custody | 2013-11-12 00:00:00 | RTV | Nur | x
27 | [NAME] | [NAME] warwick | x1 | ABE Course | 2013-11-12 00:00:00 | RTM | P Bullion
28 | [NAME] | [NAME] | x1 | ABE course | 2013-11-12 00:00:00 | RTM | P Bullion
29 | [NAME] | Sadie Lyth | x1 | ABE Course | 2013-11-12 00:00:00 | RTM | P Bullion
30 | [NAME] | S Lowe | x1 | ABE Course | 2013-11-14 00:00:00 | RTM | N Sarson
31 | [NAME] | B Martin | x1 | ABE Course | 2013-11-14 00:00:00 | RTM | N Sarson
32 | [NAME] | [NAME] | x1 | ABE Course | 2013-11-14 00:00:00 | RTM | N Sarson
33 | [NAME] | [NAME] | x1 | ABE Course | 2013-11-14 00:00:00 | RTM | N Sarson
34 | [NAME] | [NAME] | x1 | volunteer | 2013-11-15 00:00:00 | RTK | N Sarson
35 | [NAME] | [NAME] | x1 | Invest Skills | 2013-11-15 00:00:00 | RTM | Nur
36-38 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
39-41 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
42-44 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
45-47 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
48-50 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
51-53 | [NAME] | Daniel Clayton Drabb | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
54-56 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
57-59 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
60-62 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
63-65 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
66-68 | [NAME] | Rebecca wade | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
69-71 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
72-74 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
75-77 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
78-80 | [NAME] | [NAME] | [NAME] | FDS Student | 2013-11-19 00:00:00 | RTT | P Bullion
81-83 | [NAME] | [NAME] | [NAME] | FDS Student | 19//11/2013 | RTT | P Bullion
84-86 | [NAME] | [NAME] | [NAME] | FDS Student | 19//11/2013 | RTT | P Bullion
87-89 | [NAME] | [NAME] | [NAME] | FDS Student | 19//11/2013 | RTT | P Bullion
90-92 | [NAME] | [NAME] | [NAME] | FDS Student | 19//11/2013 | RTT | P Bullion
93 | mark Baggott | A Uzzell | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
94 | mark Baggott | J Giacomet | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
95 | mark Baggott | S Moorby | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
96 | mark Baggott | J Ewins | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
97 | mark Baggott | A Miles | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
98 | mark Baggott | N Naggy | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
99 | mark Baggott | J Mears | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
100 | mark Baggott | S Sherbourne | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson | x
101 | mark Baggott | Les Payne | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
102 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
103 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
104 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-21 00:00:00 | RTK | N Sarson
105 | mark Baggott | A Uzzell | x1 | [NAME] | 2013-11-22 00:00:00 | RTK | N Sarson
106 | mark Baggott | S Smith | x1 | [NAME] | 2013-11-22 00:00:00 | RTK | N Sarson | x
107 | mark Baggott | P Coe | x1 | [NAME] | 2013-11-22 00:00:00 | RTK | N Sarson
108 | mark Baggott | J Giacomet | x1 | [NAME] | 2013-11-22 00:00:00 | RTK | N Sarson
109 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-22 00:00:00 | RTK | N Sarson
110 | mark Baggott | J Smith | x1 | [NAME] | 2013-11-22 00:00:00 | RTK | N Sarson
111 | mark Baggott | J mears | x1 | [NAME] | 2013-11-22 00:00:00 | RTK | N Sarson
112 | mark Baggott | Les Payne | x1 | [NAME] | 2013-11-22 00:00:00 | RTK | N Sarson
113 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-22 00:00:00 | RTK | N Sarson
114 | mark Baggott | F Torrance | x1 | [NAME] | 2013-11-22 00:00:00 | RTK | N Sarson | x
115 | mark Baggott | [NAME] | x1 | volunteer | 2013-11-22 00:00:00 | rtk | N Sarson
116 | [NAME] | [NAME] | x1 | [NAME] | 2013-11-25 00:00:00 | RTH | P Bullion
117 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-29 00:00:00 | RTI | P Bullion
118 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-29 00:00:00 | RTI | P Bullion
119 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-29 00:00:00 | RTI | P Bullion
120 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-29 00:00:00 | RTI | P Bullion
121 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-29 00:00:00 | RTI | P Bullion
122 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-29 00:00:00 | RTI | P Bullion
123 | mark Baggott | Adrian Uzzell | x1 | [NAME] | 2013-11-29 00:00:00 | RTI | P Bullion
124 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-29 00:00:00 | RTI | P Bullion
125 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-29 00:00:00 | RTI | P Bullion | x
126 | [NAME] | [NAME] | x1 | domestic abuse | 2013-12-04 00:00:00 | RTM | N Sarson
127 | [NAME] | [NAME] | x1 | domestic abuse | 2013-12-04 00:00:00 | RTM | N Sarson
128 | [NAME] | [NAME] | x1 | domestic abuse | 2013-12-02 00:00:00 | RTM | N Sarson | x
129 | mark Baggott | [NAME] | x1 | [NAME] | 2013-11-29 00:00:00 | RTK | N Sarson