Spreadsheet: 328460d1403901666-complex-if-formula-using-timestamp-allocation-of-meal-tickets-edit
Sheet: Sep 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) | Returned unused
ie MAY01 | [NAME] | ie Student X / [NAME] | x1 | Specials [NAME] | 1st May 2013 | RTJ | F Sewell | X
2001-09-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 2nd September | RTK | P Bullion | X
2002-09-01 00:00:00 | [NAME] baines | m. Gilroy | x1 | special witness course | 2013-09-05 00:00:00 | [NAME] | n sarson
2003-09-01 00:00:00 | [NAME] baines | [NAME] | x1 | special witness course | 2013-09-05 00:00:00 | rjj | nsarson
SEP04-09 | [NAME] | Carly Meads | x6 | IPLDP | 10/9/13-13/09-13 | RTK | nsarson | X
SEP10-17 | [NAME] | [NAME] | [NAME] | IPLDP | 9/9/13-13/9/13 | RTK | nsarson
SEP18-25 | [NAME] | [NAME] | [NAME] | IPLDP | 9/9-13/9 | RTK | nsarson
SEP26-33 | [NAME] | [NAME] | [NAME] | IPLDP | 9/9-13/9 | RTK | nsarson | X 2 used
SEP34-41 | [NAME] | [NAME] | [NAME] | IPLDP | 9/9-13/9 | RTK | nsarson
SEP42-49 | [NAME] | [NAME] | [NAME] | IPLDP | 9/9-13/9 | RTK | nsarson
SEP50-57 | [NAME] | Jonothon Quaife | [NAME] | IPLDP | 9/9-13/9 | RTK | nsarson
SEP58-65 | [NAME] | [NAME] | [NAME] | IPLDP | 9/9-13/9 | RTK | nsarson | X 2 used
SEP66-73 | [NAME] | [NAME] | [NAME] | IPLDP | 9/9-13/9 | RTK | nsarson | X
SEP74-81 | [NAME] | [NAME] | [NAME] | IPLDP | 9/9-13/9 | RTK | nsarson
SEP82-89 | [NAME] | Tyron Thorpe | [NAME] | IPLDP | 9/9-13/9 | RTK | nsarson
1990-09-01 00:00:00 | [NAME] | [NAME] | x1 | guest | 2013-09-10 00:00:00 | RTG | nsarson
1991-09-01 00:00:00 | [NAME] | Jany Penny | x1 | guest speaker | 2013-09-10 00:00:00 | RTG | nsarson
1992-09-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 2013-09-09 00:00:00 | RTK | P Bullion
1993-09-01 00:00:00 | [NAME] | [NAME] | X1 | IPLDP | 2013-09-09 00:00:00 | RTK | P Bullion
1994-09-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 2013-09-09 00:00:00 | RTK | P Bullion
1995-09-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 2013-09-09 00:00:00 | RTK | P Bullion
1996-09-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 2013-09-09 00:00:00 | RTK | P Bullion
1997-09-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 1109/2013 | RTK | P Bullion
1998-09-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 1109/2013 | RTK | P Bullion
1999-09-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 1109/2013 | RTK | P Bullion
Sept-100 | [NAME] | [NAME] | x1 | IPLDP | 1109/2013 | RTK | P Bullion
Sept-101 | [NAME] | [NAME] | x1 | IPLDP | 1109/2013 | RTK | P Bullion
Sept-102 | [NAME] | [NAME] | x1 | IPLDP | 1109/2013 | RTK | P Bullion
Sept-103 | [NAME] | [NAME] | x1 | IPLDP | 1109/2013 | RTK | P Bullion
Sept-104 | [NAME] | [NAME] | x1 | IPLDP | 1109/2013 | RTK | P Bullion
Sept-105 | Siri Mourby | Siri Mourby | x1 | IPLDP | 1109/2013 | RTK | P Bullion
Sept-106 | [NAME] | [NAME] | x1 | IPLDP | 1109/2013 | RTK | P Bullion
Sept-107 | [NAME] | [NAME] | x1 | IPLDP | 1109/2013 | RTK | P Bullion
Sept 108 | MarkBaggott | [NAME] | x1 | IPLDP | 2013-09-12 00:00:00 | RTK | P Bullion
Sept 109 | MarkBaggott | [NAME] | x1 | IPLDP | 2013-09-12 00:00:00 | RTK | P Bullion
Sept 110 | [NAME] | [NAME] | x1 | INV Skills | 2013-09-09 00:00:00 | RTM | P Bullion
Sept 111 | [NAME] | [NAME] | x1 | INV Skills | 2013-09-09 00:00:00 | RTM | P Bullion
Sept 112 | [NAME] | Melody Schroder | x1 | INV Skills | 2013-09-09 00:00:00 | RTM | P Bullion
Sept 113 | Huw James | [NAME] | x1 | INV Skills | 2013-09-11 00:00:00 | RTM | P Bullion
Sept 114 | Huw James | [NAME] | x1 | INV Skills | 2013-09-11 00:00:00 | RTM | P Bullion
sep 115 | Maddy wright | [NAME] | x1 | sp volunteer | 2013-09-13 00:00:00 | RTJ | n sarson
sep 116 | [NAME] | K Hylton | x1 | inv skills | 2013-09-12 00:00:00 | RTM | nsarson
sep 117 | [NAME] | R Thorn | x1 | inv skills | 2013-09-12 00:00:00 | RTM | nsarson
sep 118 | [NAME] | B Hale | x1 | inv skills | 2013-09-12 00:00:00 | RTM | nsarson
sep 119 | [NAME] | [NAME] | x1 | IPLDP | 2013-09-12 00:00:00 | RTK | nsarson
sep 120 | [NAME] | [NAME] | x1 | IPLDP | 2013-09-12 00:00:00 | RTK | nsarson
SEP121 | [NAME] womack | [NAME] gibbs | x1 | SECB-RUG | 2013-09-12 00:00:00 | RTE | nsarson
SEP122 | [NAME] womack | [NAME] | x1 | SECB-RUG | 2013-09-12 00:00:00 | RTE | nsarson
SEP123 | [NAME] womack | [NAME] | x1 | SECB-RUG | 2013-09-12 00:00:00 | RTE | nsarson
SEP124 | [NAME] womack | [NAME] | x1 | SECB-RUG | 2013-09-12 00:00:00 | RTE | nsarson
SEP124 | [NAME] womack | [NAME] womack | x1 | SECB-RUG | 2013-09-12 00:00:00 | RTE | nsarson
sep125-132 |  | J Burchell | X8 | IPLDP | 16/09-20/09 | RTK | nsarson
SEP133-140 |  | P Cave | X8 | IPLDP | 16/09-20/09 | RTK | nsarson
SEP 141-147 |  | B [NAME] | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
SEP148-152 |  | M Reedman | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson | x
SEP 153-160 |  | S Slater | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
161-168 |  | T Thorpe | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
169-176 |  | B Cox | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
177-184 |  | S Carter | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
185-192 |  | M Cumming | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
193-200 |  | R Fenemore | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
200-208 |  | J [NAME] | x8x | IPLDP | 16/09-20/09 | RTK | nsarson
209-216 |  | J Lock | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
217-224 |  | T Reeves | x8x | IPLDP | 16/09-20/09 | RTK | nsarson
225-232 |  | N Tancred | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson | x
233-240 |  | I Kyffin | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
241-248 |  | L Lewis | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson | x
249-256 |  | J Sage | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
257-264 |  | G Smales | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
265-272 |  | N Wheeler | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
273-280 |  | N Widdison | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
281-288 |  | J Quaife | [NAME] | IPLDP | 16/09-20/09 | RTK | nsarson
289-296 |  | R.Ashton | x8x | CUSTODY | 16/09-20/09 | RTG | nsarson
279-286 |  | M Woodrow | [NAME] | CUSTODY | 16/09-20/09 | RTG | nsarson
287-294 |  | L Coburn | [NAME] | CUSTODY | 16/09-20/09 | RTG | nsarson
295-302 |  | A Atherden | [NAME] | CUSTODY | 16/09-20/09 | RTG | nsarson | x
303-310 |  | S Timms | [NAME] | INV014 | 16/09-20/09 | RTM | nsarson | x
311-317 |  | T Digby | [NAME] | INV014 | 16/09-20/09 | RTM | nsarson | x
318-325 |  | K Thandi | [NAME] | INV014 | 16/09-20/09 | RTM | nsarson | x
Sep 326 | [NAME] | [NAME] hawkins | x1 | Fist aid | 2013-09-16 00:00:00 | RTH | P Bullion
Sep 327 | [NAME] | [NAME] | x1 | First aid | 2013-09-16 00:00:00 | RTH | P Bullion
Sep 328 | [NAME] | Mr Rivett | x1 | First aid | 2013-09-17 00:00:00 | RTG | P Bullion
Sept 329 | [NAME] | [NAME] | x1 | First Aid | 2013-09-17 00:00:00 | RTG | P Bullion
Sept 330 | [NAME] | [NAME] | x1 | INV | 2013-09-17 00:00:00 | RTM | P Bullion
Sept 331 | [NAME] | [NAME] | x1 | INV | 2013-09-17 00:00:00 | RTM | P Bullion
Sept 332 | [NAME] | [NAME] | x1 | INV | 2013-09-17 00:00:00 | RTM | P Bullion
Sept 333 | [NAME] | [NAME] | x1 | IPLDP | 2012-09-17 00:00:00 | RTK | P Bullion
Sept 334 | [NAME] | Siri Mourby | x1 | IPLDP | 2013-09-17 00:00:00 | RTK | P Bullion | x
Sept 335 | [NAME] | [NAME] | x1 | IPLDP | 2013-09-18 00:00:00 | RTK | P Bullion
Sept 336 | [NAME] | [NAME] | x1 | IPLDP | 2013-09-18 00:00:00 | RTK | P Bullion
Sept 337 | [NAME] | [NAME] | x1 | IPLDP | 2013-09-18 00:00:00 | RTM | P Bullion
sep 338 | [NAME] | L.CAMPBELL | X1 | INV Skills | 2013-09-19 00:00:00 | RTM | n sarson
sep 339 | [NAME] | [NAME] | x1 | INV Skills | 2013-09-19 00:00:00 | RTM | n sarson
sep 340 | [NAME] | M WARRICK | x1 | INV Skills | 2013-09-19 00:00:00 | RTM | n sarson
sep 341-348 |  | J Burchell | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | n sarson
349-356 |  | J Quaife | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
357-364 |  | P Cave | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
365-372 |  | B [NAME] | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
373-374 |  | M Reedman | X2 | IPLDP | 24/09/13-25/09/13 | RTK | nsarson
375-382 |  | S Slater | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
383 | [NAME] | [NAME] | x1 | INV Skills | 2013-09-19 00:00:00 | RTM | nsarson
383-390 |  | T Thorpe | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
391-398 |  | B Cox | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
399-406 |  | S Carter | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
407-414 |  | M Cumming | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
415-422 |  | R Fenemore | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
423-430 |  | J [NAME] | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
431-438 |  | J Lock | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
439-446 |  | T Reeves | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson | x
447-453 |  | J Smith | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
454-461 |  | N Tancred | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
462-469 |  | I Kyffin | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
470-477 |  | L Lewis | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
478/485 |  | J Sage | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
486-493 |  | G Smales | X8 | IPLDP | 23/09/13-27/09/13 | RTK | nsarson | X 2 used
494-500 |  | N Wheeler | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
501-506 |  | N Widdison | x6 | IPLDP | 23/09/13-26/09/13 | RTK | nsarson
507-514 |  | M Irshad | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
515-522 |  | D Franklin | [NAME] | IPLDP | 23/09/13-26/09/13 | RTK | nsarson
523-530 |  | A [NAME] | x8x | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
531-538 |  | O Brixey | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
539-543 |  | A Cummings | x6 | IPLDP | 23/09/13-25/09/13 | RTK | nsarson | x
 |  | A Coburn | x6 | IPLDP | 23/09/13-25/09/13 | RTK | nsarson | \
550-557 |  | D Little | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
558-665 |  | T Dorman | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson | x
666-673 |  | R Dhardwar | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
674-681 |  | Kibblewhite | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
682-689 |  | J Philpott | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
690-697 |  | A Trevivian | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
698-704 |  | D Waite | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
705-712 |  | R Nightingale | x8x | IPLDP | 23/09/13-27/09/13 | RTK | nsarson | x
713-720 |  | S Rumsey | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
721-728 |  | S McGee | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson | x
729-736 |  | J Lawes | [NAME] | IPLDP | 23/09/13-27/09/13 | RTK | nsarson
734 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-26 00:00:00 | RTK | nsarson
735 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-26 00:00:00 | RTK | nsarson
736 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-26 00:00:00 | RTK | nsarson
737 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-26 00:00:00 | RTK | nsarson
738 | [NAME] | Siri Mourby | x1 | IPLDP Volunteer | 2013-09-26 00:00:00 | RTK | nsarson
739 | [NAME] | [NAME] | [NAME] | IPLDP Volunteer | 2013-09-26 00:00:00 | RTK | nsarson
740 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-26 00:00:00 | RTK | nsarson | x
741 | [NAME] | Les Payne | x1 | IPLDP Volunteer | 2013-09-26 00:00:00 | RTK | nsarson
742 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-26 00:00:00 | RTK | nsarson
734 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
sep735 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
736 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
737 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
738 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
739 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
740 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
741 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
742 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
743 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
744 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
745 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
746 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
747 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
748 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
749 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
750 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-09-27 00:00:00 | RTK | nsarson
SEPT 751 | [NAME] | [NAME] | x1 | First aid volunteer | 2013-09-30 00:00:00 | RTH | Ewood
SEPT 752 | [NAME] | [NAME] | x1 | First aid volunteer | 2013-10-01 00:00:00 | RTH | E Wood