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

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-01-01 00:00:00 | [NAME] | Jan penny | x1 | Custody | 2014-01-14 00:00:00 | RTG | P Bullion
2002-01-01 00:00:00 | [NAME] | [NAME] paskell | x1 | Custody | 2014-01-14 00:00:00 | RTG | P Bullion
3 | [NAME] | Alistair Campbell | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
4 | [NAME] | Teresa Thorpe | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
5 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
6 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
7 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
8 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
9 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
10 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
11 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
12 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
13 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
14 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
15 | [NAME] | [NAME] | x1 | SURV | 2014-01-18 00:00:00 | RTN | P Bullion
16 | [NAME] | [NAME] | x1 | ICIDP | 2014-01-16 00:00:00 | RTM | F Sewell
17 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
18 | [NAME] | [NAME] | X1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
19 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
20 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
21 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
22 | [NAME] | Les Payne | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
23 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
24 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
25 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
26 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
27 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
28 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
29 | [NAME] | [NAME] | x1 | IPLDP Roleplay | 2014-01-16 00:00:00 | RTK | F Sewell
30 | [NAME] | [NAME] | x1 | INV | 2014-01-20 00:00:00 | RTM | P Bullion
31 | [NAME] | [NAME] | x1 | INV | 2014-01-20 00:00:00 | RTM | P Bullion
32 | [NAME] | [NAME] | x1 | INV | 2014-01-20 00:00:00 | RTM | P Bullion
33 | [NAME] | [NAME] | x1 | INV | 2014-01-20 00:00:00 | RTM | P Bullion
34 | [NAME] | [NAME] | x1 | INV | 2014-01-20 00:00:00 | RTM | P Bullion
35 | [NAME] | [NAME] | x1 | INV | 2014-01-20 00:00:00 | RTM | P Bullion
36 | [NAME] | [NAME] | x1 | INV | 2014-01-21 00:00:00 | RTM | P Bullion
37 | [NAME] | [NAME] | x1 | INV | 2014-01-21 00:00:00 | RTM | P Bullion
38 | [NAME] | [NAME] | x1 | INV | 2014-01-21 00:00:00 | RTM | P Bullion
39 | [NAME] | [NAME] | x1 | INV | 2014-01-21 00:00:00 | RTM | P Bullion
40 | [NAME] | [NAME] | x1 | INV | 2014-01-21 00:00:00 | RTM | P Bullion
41 | [NAME] | [NAME] | x1 | INV | 2014-01-21 00:00:00 | RTM | P Bullion
42 | [NAME] | [NAME] | x1 | INV | 2014-01-22 00:00:00 | RTM | P Bullion
43 | [NAME] | [NAME] | x1 | INV | 2014-01-22 00:00:00 | RTM | P Bullion
44 | [NAME] | [NAME] | x1 | INV | 2014-01-22 00:00:00 | RTM | P Bullion
45 | [NAME] | [NAME] | x1 | INV | 2014-01-22 00:00:00 | RTM | P Bullion
46 | [NAME] | [NAME] | x1 | INV | 2014-01-22 00:00:00 | RTM | P Bullion
47 | [NAME] | [NAME] | x1 | INV | 2014-01-22 00:00:00 | RTM | P Bullion
48 | [NAME] | [NAME] | x1 | INV | 2014-01-23 00:00:00 | RTM | P Bullion
49 | [NAME] | [NAME] | x1 | INV | 2014-01-23 00:00:00 | RTM | P Bullion
50 | [NAME] | [NAME] | x1 | INV | 2014-01-23 00:00:00 | RTM | P Bullion
51 | [NAME] | [NAME] | x1 | INV | 2014-01-23 00:00:00 | RTM | P Bullion
52 | [NAME] | [NAME] | x1 | INV | 2014-01-23 00:00:00 | RTM | P Bullion
53 | [NAME] | [NAME] | x1 | INV | 2014-01-23 00:00:00 | RTM | P Bullion
54 | [NAME] | [NAME] | x1 | INV | 2014-01-24 00:00:00 | RTM | P Bullion
55 | [NAME] | [NAME] | x1 | INV | 2014-01-24 00:00:00 | RTM | P Bullion
56 | [NAME] | [NAME] | x1 | INV | 2014-01-24 00:00:00 | RTM | P Bullion
57 | [NAME] | [NAME] | x1 | INV | 2014-01-24 00:00:00 | RTM | P Bullion
58 | [NAME] | [NAME] | x1 | INV | 2014-01-24 00:00:00 | RTM | P Bullion
59 | [NAME] | [NAME] | x1 | INV | 2014-01-24 00:00:00 | RTM | P Bullion
60 | Alison Raeburn | [NAME] | x1 | INV | 2014-01-23 00:00:00 | RTM | P Bullion
61 | Alison Raeburn | [NAME] | x1 | INV | 2014-01-23 00:00:00 | RTM | P Bullion
62 | Alison Raeburn | [NAME] | x1 | INV | 2014-01-23 00:00:00 | RTM | P Bullion
63 | Alison Raeburn | [NAME] | x1 | INV | 2014-01-22 00:00:00 | RTM | P Bullion
64 | Alison Raeburn | [NAME] | x1 | INV | 2014-01-22 00:00:00 | RTM | P Bullion
65 | Alison Raeburn | [NAME] | x1 | INV | 2014-01-22 00:00:00 | RTM | P Bullion
66 | [NAME] | [NAME] | x1 | PCSO | 2014-01-31 00:00:00 | RTI | P Bullion
67 | [NAME] | [NAME] | x1 | PCSO | 2014-01-31 00:00:00 | RTI | P Bullion
68 | [NAME] | [NAME] | x1 | PCSO | 2014-01-31 00:00:00 | RTI | P Bullion
69 | [NAME] | [NAME] | x1 | PCSO | 2014-01-31 00:00:00 | RTI | P Bullion
70 | [NAME] | [NAME] | x1 | PCSO | 2014-01-31 00:00:00 | RTI | P Bullion
71 | [NAME] | Les Payne | x1 | PCSO | 2014-01-31 00:00:00 | RTI | P Bullion
72 | [NAME] | [NAME] | x1 | PCSO | 2014-01-31 00:00:00 | RTI | P Bullion
73 | [NAME] | [NAME] | x1 | PCSO | 2014-01-31 00:00:00 | RTI | P Bullion
74 | [NAME] | [NAME] | x1 | PCSO | 2014-01-31 00:00:00 | RTI | P Bullion
75 | [NAME] | [NAME] | x1 | PCSO | 2014-01-31 00:00:00 | RTI | P Bullion
76 | [NAME] | [NAME] | x1 | ICIDP | 30.01.2014 | RTM | Fsewell
77 | Direct to volunteer | [NAME] | x1 | IPLDP Volunteer | 31.01.2014 | RTW | Fsewell