Spreadsheet: 328460d1403901666-complex-if-formula-using-timestamp-allocation-of-meal-tickets-edit
Sheet: Oct 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) | Reurned unsued
ie MAY01 | [NAME] | ie Student X / [NAME] | x1 | Specials [NAME] | 1st May 2013 | RTJ | F Sewell
Oct01-05 | [NAME] | [NAME] | x5 | [NAME] | 07/10/13-11/10/13 | RTM | N Sarson
Oct06-10 | [NAME] | [NAME] | x5 | [NAME] | 07/10/13-11/10/13 | RTM | N Sarson
oct11-15 | [NAME] | [NAME] | x5 | [NAME] | 07/10/13-11/10/13 | RTM | N Sarson
Oct16-20 | [NAME] | [NAME] | x5 | [NAME] | 07/10/13-11/10/13 | RTM | N Sarson | Not needed
Oct21-25 | [NAME] | [NAME] | x5 | [NAME] | 07/10/13-11/10/13 | RTM | N Sarson
oct26-33 |  | P Cave | [NAME] | IPLDP | 07/10/13-11/10/13 | RTK | N Sarson | No longer required
Oct34-41 |  | B [NAME] | [NAME] | IPLDP | 07/10/13-11/10/13 | RTK | N Sarson | No longer required
Oct42-47 |  | M Reedman | x6 | IPLDP | 08/10/13-11/10/13 | RTK | N Sarson | No longer required
1948-10-01 00:00:00 | [NAME] | A Uzzell | x1 | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
1949-10-01 00:00:00 | [NAME] | [NAME] | [NAME] | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
1950-10-01 00:00:00 | [NAME] | F Whittaker | x1 | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
1951-10-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
1952-10-01 00:00:00 | [NAME] | A denton | [NAME] | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
53 | [NAME] | J mears | [NAME] | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
54 | [NAME] | Les paynes | x1 | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
55 | [NAME] | K walker | x1 | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
56 | [NAME] | P hatton | x1 | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
57 | [NAME] | M Dolan | x1 | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
58 | [NAME] | G williamson | x1 | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
59 | [NAME] | [NAME] | x1 | IPLDP | 2013-10-04 00:00:00 | RTK | N Sarson
1960-10-01 00:00:00 | [NAME] | G williamson | x1 | IPLDP | 2013-10-08 00:00:00 | RTK | N Sarson
1961-10-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 2013-10-08 00:00:00 | RTK | N Sarson
oct 62-66 | [NAME] | R Gregory | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
oct 67-71 | [NAME] | D Brown | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
72-76 | [NAME] | C [NAME] | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
77-80 | [NAME] | P Chambers | x4 | Assessors | 14-18/10/2013 | RHA | N Sarson
81-85 | [NAME] | B Marlow | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
86-90 | [NAME] | [NAME] | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
90-95 | [NAME] | S Ward | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
96-100 | [NAME] | H Ledger | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
101-105 | [NAME] | M Routledge | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
106-110 | [NAME] | M Paracha | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
111-115 | [NAME] | K Ford | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
116-120 | [NAME] | P Burton | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
121-125 | [NAME] | M Haycox | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
126-130 | [NAME] | M Souter | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
131-135 | [NAME] | A [NAME] | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
136-140 | [NAME] | S Mansell | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
141-145 | [NAME] | G Merchant | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
146-150 | [NAME] | A Cooke | x5 | Assessors | 14-18/10/2013 | RHA | N Sarson
151 | M Warrick | M Warrick | x1 | [NAME] | 2013-10-09 00:00:00 | RTM | P Bullion
152 | K Hylton | K Hylton | x1 | [NAME] | 2013-10-09 00:00:00 | RTM | P Bullion
153 | Sandra Beaumont | [NAME] | x1 | [NAME] | 2013-10-09 00:00:00 | RTM | P Bullion
154 | [NAME] | [NAME] | x1 | [NAME] | 2013-10-09 00:00:00 | RTM | P Bullion
155 | [NAME] | Sandra Beaumont | x1 | [NAME] | 2013-10-10 00:00:00 | RTM | N Sarson
156 | [NAME] | [NAME] | x1 | [NAME] | 2013-10-10 00:00:00 | RTM | N Sarson
157 | [NAME] | S Lyth | x1 | [NAME] | 2013-10-10 00:00:00 | RTM | N Sarson
157 | [NAME] | [NAME] | x1 | [NAME] | 10/010/13 | RTM | N Sarson
Oct 158-165 |  | S Carter | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
166-173 |  | M Cumming | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
174-181 |  | R Fenemore | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
181-189 |  | T Reeves | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson | x
190-197 |  | J Smith | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
198-205 |  | N Tancred | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
206-213 |  | Jade Lock | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
214-221 |  | [NAME] | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
228-229 |  | J Sage | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
230-233 |  | [NAME] | x4 | IPLDP | 14/10 & 17/10 | RTK | N Sarson
Oct 234 | [NAME] | [NAME] | x1 | volunteer | 2013-10-11 00:00:00 | RTK | N Sarson
235 | [NAME] | A Mclellan | x1 | [NAME] | 2013-10-10 00:00:00 | RTM | N Sarson
236-243 |  | G Bowyer | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
243-251 |  | A Broad | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
252-259 |  | L Lewis | [NAME] | IPLDP | 14/10/13-19/10/13 | RTK | N Sarson
260 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
261 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
262 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
263 | [NAME] | Les paynes | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion | Not needed
264 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion | x
265 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
266 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
267 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
268 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
269 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
270 | [NAME] | [NAME] | x1 | PCSO | 11/102013 | RTI | P Bullion
271 | [NAME] | [NAME] | X1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
272 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
273 | [NAME] | [NAME] | x1 | PCSO | 2013-10-11 00:00:00 | RTI | P Bullion
274-281 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
282-289 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
290-297 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
298-305 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
306-313 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
314-321 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
322-329 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
330-337 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
338-345 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
346-353 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
354-361 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
362-369 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
370-377 | [NAME] | as over | [NAME] | IPLDP | 2013-10-14 00:00:00 | RTK | P Bullion
378-383 | [NAME] | as over | x6 | Lead | 2013-10-14 00:00:00 | RTG | P Bullion
384-389 | [NAME] | as over | x6 | lead | 2013-10-14 00:00:00 | RTG | P Bullion
390-395 | [NAME] | as over | x6 | [NAME] | 2013-10-14 00:00:00 | RTG | P Bullion
391-398 | [NAME] | as over | [NAME] | [NAME] | 2013-10-14 00:00:00 | RTG | P Bullion
399-404 | [NAME] | as over | x6 | Lead | 2013-10-14 00:00:00 | RTG | P Bullion
405-410 | fritha [NAME] | as over | x6 | IPLDP | 2013-10-14 00:00:00 | RTG | P Bullion
411 | [NAME] | [NAME] | x1 | IPLDP | 2013-10-16 00:00:00 | RTK | P Bullion
412 | [NAME] | [NAME] | x1 | IPLDP | 2013-10-16 00:00:00 | RTK | P Bullion | x
413 | [NAME] | [NAME] | x1 | IPLDP | 2013-10-17 00:00:00 | RTK | P Bullion
414 | [NAME] | [NAME] | X1 | IPLDP | 2013-10-17 00:00:00 | RTK | P Bullion
415 | [NAME] | Siri Moorby | x1 | IPLDP | 2013-10-17 00:00:00 | RTK | P Bullion
416 | [NAME] | [NAME] | x1 | [NAME] | 2013-10-14 00:00:00 | RTM | P Bullion
417 | [NAME] | [NAME] | x1 | [NAME] | 2013-10-14 00:00:00 | RTM | P Bullion
418/428 | [NAME] | Museum Visit | x11 | Museum | 2013-10-15 00:00:00 | RTG | P Bullion
429/431 | [NAME] | [NAME] | [NAME] | [NAME] | 2013-10-16 00:00:00 | RTM | P Bullion
432 | [NAME] | gary Smales | x01 | IPLDP | 2013-10-15 00:00:00 | RTK | P Bullion
433 | [NAME] | J Billson | x1 | IPLDP | 2013-10-17 00:00:00 | RTK | N Sarson | x
434-438 | [NAME] | [NAME] | x5 | [NAME] | 21-25/10/13 | RTM | N Sarson | x
439-443 | [NAME] | Laural bruce | x5 | [NAME] | 21-25/10/13 | RTM | N Sarson | x
444-448 | [NAME] | [NAME] | x5 | [NAME] | 21-25/10/13 | RTM | N Sarson | x
449 | [NAME] | [NAME] | x1 | [NAME] | 2013-10-18 00:00:00 | RTK | N Sarson
450 | [NAME] | mark Mulcahy | x1 | SMT | 2013-10-23 00:00:00 | RTG | P Bullion
451 | [NAME] | [NAME] | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
452 | [NAME] | [NAME] | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
453 | [NAME] | G williamson | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
454 | [NAME] | [NAME] | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
455 | [NAME] | [NAME] | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
456 | [NAME] | B Barnes | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson | x
457 | [NAME] | Les paynes | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
458 | [NAME] | S Sherbourne | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
459 | [NAME] | J Mears | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
460 | [NAME] | S Moorby | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
461 | [NAME] | J Smith | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
462 | [NAME] | N Nagy | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
463 | [NAME] | A Miles | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
464 | [NAME] | J Giacomet | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
465 | [NAME] | M Chapman | x1 | [NAME] | 2013-10-24 00:00:00 | RTK | N Sarson
466 | [NAME] | [NAME] | x1 | volunteer | 2013-10-25 00:00:00 | rtk | N Sarson
467 | Kirsty hawkins | [NAME] | x1 | volunteer | 251013 | RTH | Nur
468 | [NAME] | [NAME] | x1 | [NAME] | 2013-10-28 00:00:00 | RTM | P Bullion
469/471 | Student | D McBroom | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
472/474 | Student | C Appleby | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
475/477 | Student | A Robertson | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
478/480 | Student | H Sparkes | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
481/483 | Student | A [NAME] | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
484/486 | Student | P [NAME] | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
487/489 | Student | J [NAME] | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
490/492 | Student | R Cutler | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
493/495 | Student | R Miller | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
496/498 | Student | [NAME] matthews | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
499/501 | Student | M Barber | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
502/504 | Student | J Stephemson | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
505/507 | Student | E Parrey | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
508/510 | Student | N lampard | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
511/513 | Student | D Willis | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
514/516 | Student | J Hill | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
517/519 | Student | M McGinnigle | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
520/522 | Student | A Popat | [NAME] | IPLDP | 2013-10-30 00:00:00 | RTK | P Bullion
523 | [NAME] | [NAME] | x 1 | First Aid | 2013-10-29 00:00:00 | RTH | E Wood
524 | [NAME] | [NAME] | x1 | ICIDP | 2013-10-30 00:00:00 | RTM | P Bullion
525 | [NAME] | [NAME] | x1 | volunteer | 2013-10-31 00:00:00 | RTK | N Sarson
526 | [NAME] | [NAME] | X1 | volunteer | 2013-10-31 00:00:00 | RTK | N Sarson
527 | [NAME] | [NAME] | x1 | Custody | 2013-11-08 00:00:00 | RTG | N Sarson
528 | [NAME] | Jan Penny | x1 | Custody | 2013-11-12 00:00:00 | RTG | N Sarson
529 | [NAME] | [NAME] | x1 | [NAME] | 2013-11-01 00:00:00 | RTK | N Sarson