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

Allocation of Meal Tickets
BRK = BREAKFAST |  | DIN = Dinner | L = Lunch
Ticket No: | Name of person ticket issued to | Ticket holders name | Quantity& Type | 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
2009-05-01 00:00:00 | [NAME] | [NAME] | x1,  L | Specials [NAME] | 10th May 13 | RTJ | Fsewell
May 09-13 | direct to student via Pam | [NAME] | x5,  BRK | IPLDP B13 | 13-17 May | RTK | Fsewell
May 14-18 | direct to student via Pam | [NAME] | x5,  BRK | IPLDP B13 | 13-17 May | RTK | Fsewell
May 19-23 | direct to student via Pam | [NAME] | x5,  BRK | IPLDP B13 | 13-17 May | RTK | Fsewell
May 24-28 | direct to student via Pam | [NAME] | x5,  BRK | IPLDP B13 | 13-17 May | RTK | Fsewell
May 29-33 | direct to student via Pam | [NAME] | x5,  BRK | IPLDP B13 | 13-17 May | RTK | Fsewell
May 34-38 | direct to student via Pam | [NAME] | X5  BRK | IPLDP B13 | 13-17 May | RTK | Fsewell
May 39-43 | direct to student via Pam | [NAME] | X5  BRK | IPLDP B13 | 13-17 May | RTK | Fsewell
May 44-48 | direct to student via Pam | [NAME] | X5  BRK | IPLDP B13 | 13-17 May | RTK | Fsewell
May 49-53 | direct to student via Pam | [NAME] | x5 BRK | IPLDP B13 | 13-17 May | RTK | Fsewell
May 54-58 | direct to student via Pam | [NAME] | X5  BRK | IPLDP B13 | 13-17 May | RTK | Fsewell | [NAME]
May 59-63 | direct to student via Pam | [NAME] | x5  DIN | IPLDP B13 | 13-17 May | RTK | Fsewell
May 64-68 | direct to student via Pam | [NAME] | x5  DIN | IPLDP B13 | 13-17 May | RTK | Fsewell
May 69-73 | direct to student via Pam | [NAME] | x5  DIN | IPLDP B13 | 13-17 May | RTK | Fsewell
May 74-78 | direct to student via Pam | [NAME] | x5  DIN | IPLDP B13 | 13-17 May | RTK | Fsewell
May 79-83 | direct to student via Pam | [NAME] | x5  DIN | IPLDP B13 | 13-17 May | RTK | Fsewell
May 84-88 | direct to student via Pam | [NAME] | x5  DIN | IPLDP B13 | 13-17 | RTK | Fsewell
May 89-93 | direct to student via Pam | [NAME] | x5  DIN | IPLDP B13 | 13-17 May | RTK | Fsewell
May 94-98 | direct to student via Pam | [NAME] | x5  DIN | IPLDP B13 | 13-17 May | RTK | Fsewell
May 99-103 | direct to student via Pam | [NAME] | x5  DIN | IPLDP B13 | 13-17 May | RTK | Fsewell
May 104 - 105 | given to [NAME] | [NAME] | x2 Brk | [NAME] | 13th 14th May | RTH | E Wood
May 106 | [NAME] | [NAME] | 1 x Lunch | [NAME] | 17th May | RTW | E Wood
May107 | [NAME] | [NAME] | 1 x Lunch | [NAME] | 24th May | RTW | NUR
May108 | [NAME] | [NAME] | 1 x Lunch | [NAME] | 24th May | RTW | NUR
May109 | [NAME] | [NAME] | 1 x Lunch | IPLDP Volunteer | 29th May | RTK | E Wood
May110 | [NAME] | [NAME] | 1 x Lunch | IPLDP Volunteer | 29th May | RTK | E Wood
May111 | [NAME] | [NAME] | 1 x Lunch | IPLDP Volunteer | 30th May | RTK | E Wood
May 112 | [NAME] | [NAME] | 1 x Lunch | IPLDP Volunteer | 30th May | RTK | E Wood
May 113&114 | [NAME] | [NAME] | 2x Lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X1
May 115 &116 | [NAME] | [NAME] | 2x Lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X1
May 117 & 118 | [NAME] | [NAME] | 2x Lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X2
May 119 & 120 | [NAME] | [NAME] Friday | 2x Lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X1
May 121 & 122 | [NAME] | [NAME] | 2x Lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X1
May 123 & 124 | [NAME] | [NAME] | 2x Lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X1
May 125 & 126 | [NAME] | [NAME] | 2x Lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X1
May 127 & 128 | [NAME] | [NAME] | 2x Lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X1
May 129 & 130 | [NAME] | [NAME] | 2x Lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X1
May 131 & 132 | [NAME] | [NAME] | 2x Lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X1
May 123 & 134 | [NAME] | [NAME] | 2x lunch | SFIC Upskills | 5th 6th June | RTN | F Sewell | X1
May 135 | direct to volunteer | [NAME] | 1x Lunch | [NAME] | 31st May 13 | RTJ | F Sewell
May 136 - 143 | direct to student via Pam | Darren Pomroy | 4x Brk 4x Din | ICIDP | 3rd-6th June | RTM | F Sewell
May 144 - 151 | direct to student via Pam | [NAME] | 4x Brk 4x Din | ICIDP | 3rd-6th June | RTM | F Sewell
May 152 - 159 | direct to student via Pam | [NAME] | 4x Brk 4x Din | ICIDP | 3rd-6th June | RTM | F Sewell
May 160 - 167 | direct to student via Pam | [NAME] | 4x Brk 4x Din | ICIDP | 3rd-6th June | RTM | F Sewell
May 168 - 175 | direct to student via Pam | [NAME] | 4x Brk 4x Din | ICIDP | 3rd-6th June | RTM | F Sewell | X8
May 176 - 184 | direct to student via Pam | [NAME] | 4x Brk 4x Din | ICIDP | 3rd-6th June | RTM | F Sewell