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

 | Allocation of Meal Tickets
Time Stamp for Formatting | 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 |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 | 2001-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass
 | 2002-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass
 | 2003-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 | 2004-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass |  | Date Valid: |  |  |  |  | Date Valid:
 | 2005-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass |  | Course: |  |  |  |  | Course:
 | 2006-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 | 2007-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass
 | 2008-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass
 | 2009-09-01 00:00:00 | [NAME] bates | P Lesiakowska | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass
 | 2010-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 | 2011-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass
 | 2012-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass
 | 2013-09-01 00:00:00 | [NAME] bates | [NAME] leach | x1 | Specials | 8th -12th Sep | RTJ | T5598M Cass |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 | 2014-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass |  | Date Valid: |  |  |  |  | Date Valid:
 | 2015-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass |  | Course: |  |  |  |  | Course:
 | 2016-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 | 2017-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass
 | 2018-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass
 | 2019-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass
 | 2020-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 | 2021-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass
 | 2022-09-01 00:00:00 | [NAME] bates | P Lesiakowska | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass
 | 2023-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 | 2024-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass |  | Date Valid: |  |  |  |  | Date Valid:
 | 2025-09-01 00:00:00 | [NAME] bates | [NAME] | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass |  | Course: |  |  |  |  | Course:
 | 2026-09-01 00:00:00 | [NAME] bates | [NAME] leach | x1 | Specials | 15th -19th Sep | RTJ | T5598M Cass |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: