Spreadsheet: 328460d1403901666-complex-if-formula-using-timestamp-allocation-of-meal-tickets-edit
Sheet: July 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 unusued
ie MAY01 | [NAME] | ie Student X / [NAME] | x1 | Specials [NAME] | 1st May 2013 | RTJ | F Sewell
2001-07-01 00:00:00 | [NAME] | [NAME] | 1 | IPLDP Volunteer | 2013-07-01 00:00:00 | RTK | E Wood
2002-07-01 00:00:00 | [NAME] | [NAME] | 1 | Visitor | 2013-07-01 00:00:00 | RTW | E Wood
2003-07-01 00:00:00 | [NAME]Sue | [NAME] | x5 | Specials [NAME] | 2013-07-05 00:00:00 | RTJ | F Sewell
Jul04-08 | CI [NAME] | Insp Dave Humphries | x5 | PIM Course | 15-19 Jul |  | F Sewell
Jul09-13 | CI [NAME] | CI [NAME] | x5 | PIM Course | 15-19 Jul |  | F Sewell
Jul14-18 | CI [NAME] | Insp [NAME] | x5 | PIM Course | 15-19 Jul |  | F Sewell
Jul19-23 | CI [NAME] | [NAME] | x5 | PIM Course | 15-19 Jul |  | F Sewell
Jul24-28 | CI [NAME] | [NAME] | x5 | PIM Course | 15-19 Jul |  | F Sewell
Jul29-33 | CI [NAME] | [NAME] | x5 | PIM Course | 15-19 Jul |  | F Sewell
Jul34-38 | CI [NAME] | [NAME] | x5 | PIM Course | 15-19 Jul |  | F Sewell
Jul39-43 | CI [NAME] | CI [NAME] | x5 | PIM Course | 15-19 Jul |  | F Sewell
Jul44-48 | CI [NAME] | Insp Coppard | x5 | PIM Course | 15-19 Jul |  | F Sewell
jul49-53 | CI [NAME] | Insp [NAME] | x5 | PIM Course | 15-19 Jul |  | F Sewell
jul54-58 | CI [NAME] | DCI Kinley-Smith | x5 | PIM Course | 15-19 Jul |  | F Sewell
Jul59-63 | CI [NAME] | Insp Sharman Wicks | x5 | PIM Course | 15-19 Jul |  | F Sewell
[NAME] | CI [NAME] | PS Joe Short | x5 | PIM Course | 15-19 Jul |  | F Sewell
Jul69-73 | CI [NAME] | CI [NAME] | x5 | PIM Course | 15-19 Jul |  | F Sewell
1974-07-01 00:00:00 | [NAME]Sue | [NAME] | x1 | Specials [NAME] | 2013-07-12 00:00:00 | RTJ | E Wood
1975-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-17 00:00:00 | RTM | P Bullion
1976-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-17 00:00:00 | RTM | P Bullion
1977-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-17 00:00:00 | RTM | P Bullion
1978-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-18 00:00:00 | RTM | P Bullion
1979-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-18 00:00:00 | RTM | P Bullion
1980-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-18 00:00:00 | RTM | P Bullion
1981-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-23 00:00:00 | RTM | P Bullion
1982-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-23 00:00:00 | RTM | P Bullion
1983-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-23 00:00:00 | RTM | P Bullion
1984-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-25 00:00:00 | RTM | P Bullion
1985-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-25 00:00:00 | RTM | P Bullion
1986-07-01 00:00:00 | [NAME] | Actor | x1 | VRI Course | 2013-07-25 00:00:00 | RTM | P Bullion
1987-07-01 00:00:00 | [NAME] | First Aid Actor | x1 | FA | 2013-07-16 00:00:00 | RTH | P Bullion
1988-07-01 00:00:00 | [NAME] | First Aid Actor | x1 | FA | 2013-07-16 00:00:00 | RTH | P Bullion
 | [NAME] | [NAME] | x1 | Specials [NAME] | 2013-07-18 00:00:00 | RTJ | Nur
1989-07-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
1990-07-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
1991-07-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
1992-07-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
1993-07-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
1994-07-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
1995-07-01 00:00:00 | [NAME] | [NAME] | 1x | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
1996-07-01 00:00:00 | [NAME] | [NAME] | 1x | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
1997-07-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
1998-07-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
1999-07-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
jul100 | [NAME] | M Oakley | x1 | IPLDP Volunteer | 2013-07-19 00:00:00 | RTK | F Sewell
Jul101 | [NAME] | [NAME] | x1 | DAIU Course | 2013-08-24 00:00:00 | RTM | P Bullion
Jul 102 | [NAME] | [NAME] | x1 | DAIU Course | 2013-08-24 00:00:00 | RTM | P Bullion
Jul103 | [NAME] | [NAME] | x1 | ABE Course | 2013-07-25 00:00:00 | RTM | F Sewell
Jul104 | [NAME] | [NAME] | x1 | Joint Investigation | 2013-07-29 00:00:00 | RTM | F Sewell
Jul105 | [NAME] | [NAME] | x1 | Joint Investigation | 29/07/2013 rtm | RTM | F Sewell
[NAME] | [NAME] | [NAME] | X1 | Joint Investigation | 2013-07-29 00:00:00 | RTM | F Sewell
[NAME] | [NAME] | [NAME] | X1 | Joint Investigation | 2013-07-29 00:00:00 | RTM | F Sewell
jul108 | [NAME] | Claire Sherlock | X1 | Joint Investigation | 2013-07-29 00:00:00 | RTM | F Sewell
[NAME] | [NAME] | Darlington Ihenacho | X1 | Joint Investigation | 2013-07-29 00:00:00 | RTM | F Sewell
jul110 | [NAME] | unknown actor | X1 | Joint Investigation | 2013-07-31 00:00:00 | RTM | F Sewell
JUL111 | [NAME] | unknown actor | X1 | Joint Investigation | 2013-07-31 00:00:00 | RTM | F Sewell
JUL112 | [NAME] | unknown actor | X1 | Joint Investigation | 2013-07-31 00:00:00 | RTM | F Sewell
JUL113 | [NAME] | unknown actor | X1 | Joint Investigation | 2013-08-01 00:00:00 | RTM | F Sewell | x
JUL114 | [NAME] | unknown actor | X1 | Joint Investigation | 2013-08-01 00:00:00 | RTM | F Sewell | x
JUL115 | [NAME] | unknown actor | X1 | Joint Investigation | 2013-08-01 00:00:00 | RTM | F Sewell | x
Jul116 | [NAME] | [NAME] | x1 | Joint Investigation | 2013-07-30 00:00:00 | RTM | P Bullion
Jul117 | [NAME] | [NAME] | x1 | Joint Investigation | 2013-07-30 00:00:00 | RTM | P Bullion
Jul 118 | [NAME] | [NAME] | x1 | Joint Investigation | 2013-07-30 00:00:00 | RTM | P Bullion
Jul 119 | [NAME] | [NAME] | x1 | Joint Investigation | 2013-07-30 00:00:00 | RTM | P Bullion
Jul 120 | [NAME] | Claire Sherlock | x1 | Joint Investigation | 30/072013 | RTM | P Bullion
Jul 121 | [NAME] | Darlington Ihenacho | x1 | Joint Investigation | 2013-07-30 00:00:00 | RTM | P Bullion
Jul 122 | [NAME] | [NAME] | x1 | Joint Investigation | 2013-07-31 00:00:00 | RTM | P Bullion
Jul 123 | [NAME] | [NAME] | x1 | Joint Investigation | 2013-07-31 00:00:00 | RTM | P Bullion
Jul 124 | [NAME] | [NAME] | x1 | Joint Investigation | 2013-07-31 00:00:00 | RTM | P Bullion
Jul 125 | [NAME] | [NAME] | x1 | Joint Investigation | 2013-07-31 00:00:00 | RTM | P Bullion
Jul 126 | [NAME] | Claire Sherlock | x1 | Joint Investigation | 2013-07-31 00:00:00 | RTM | P Bullion
Jul 127 | [NAME] | Darlington Ihenacho | x1 | Joint Investigation | 2013-07-31 00:00:00 | RTM | P Bullion