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

Allocation of Meal Tickets
Ticket No: | Name of person ticket issued to | Ticket holders name | Quantity | Course and Code | Date Issued | 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
2001-08-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] |  | 1st Aug 2013 | RTM | P Bullion
2002-08-01 00:00:00 | [NAME] | [NAME] | X1 | [NAME] |  | 1st August 2013 | RTM | P Bullion
2003-08-01 00:00:00 | [NAME] | [NAME] | X1 | [NAME] |  | 1st August 2013 | RTM | P Bullion
2004-08-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] |  | 1st August 2013 | RTM | P Bullion
2005-08-01 00:00:00 | [NAME] | Claire Sherlock | x1 | [NAME] |  | 1st August 2013 | RTM | P Bullion
2006-08-01 00:00:00 | [NAME] | Darlington Ihenacho | x1 | [NAME] |  | 1st August 2013 | RTM | P Bullion
2007-08-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] |  | 2nd August 2013 | RTM | P Bullion
2008-08-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] |  | 2nd August 2013 | RTM | P Bullion
2009-08-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] |  | 2nd August 2013 | RTM | P Bullion
2010-08-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] |  | 2nd August 2013 | RTM | P Bullion
2011-08-01 00:00:00 | [NAME] | Claire Sherlock | x1 | [NAME] |  | 2nd August 2013 | RTM | P Bullion
2012-08-01 00:00:00 | [NAME] | Darlington Ihenacho | x1 | [NAME] |  | 2nd August 2013 | RTM | P Bullion
2013-08-01 00:00:00 | [NAME] | [NAME] | x 1 | [NAME] | 2013-08-01 00:00:00 | 2013-08-01 00:00:00 | RTM | E Wood
2014-08-01 00:00:00 | [NAME] | [NAME] | x 1 | [NAME] | 2013-08-01 00:00:00 | 2013-08-01 00:00:00 | RTM | E Wood
2015-08-01 00:00:00 | [NAME] | [NAME] | x 1 | [NAME] | 2013-08-01 00:00:00 | 2013-08-01 00:00:00 | RTM | E Wood
2016-08-01 00:00:00 | [NAME] | Characters' Actor | x 1 | [NAME] | 2013-08-01 00:00:00 | 2013-08-01 00:00:00 | RTM | E Wood
2017-08-01 00:00:00 | [NAME] | [NAME] Speaker | x 1 | ICIDP | 2013-08-01 00:00:00 | 2013-08-01 00:00:00 | RTM | E Wood
2018-08-01 00:00:00 | Direct to volunteer | [NAME] | x1 | Specials [NAME] | 2013-08-02 00:00:00 | 2013-08-02 00:00:00 | RTW | F Sewell
Aug 19-21 | Left at reception | [NAME] S8003 | X4 | Special Constable | 2013-08-02 00:00:00 | 7/8/9&15th Aug | RTJ | F Sewell
Aug 22-26 | [NAME] | [NAME] | x5 | [NAME] | 5th August | 5/6/7/8/9th Aug | RTM | P Bullion
Aug 27-31 | [NAME] | [NAME] | x5 | [NAME] | 5th August | 5/6/7/8/9th Aug | RTM | P Bullion
Aug 32-36 | [NAME] | [NAME] | x5 | [NAME] | 5th August | 5/6/7/8/9th Aug | RTM | P Bullion
Aug 42-46 | [NAME] | [NAME] | x5 | [NAME] | 5th August | 5/6/7/8/9th Aug | RTM | P Bullion
Aug 47-51 | [NAME] | Iasbel Prinsloo | x5 | [NAME] | 5th August | 5/6/7/8/9th Aug | RTM | P Bullion
1952-08-01 00:00:00 | [NAME] | [NAME] | x1 | NIE Crammer | 5th August | 6th August | RTM | P Bullion
1953-08-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] | 7th August | 7th August | RTM | P Bullion
1954-08-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] | 7th August | 7th August | RTM | P Bullion
1955-08-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] | 7th August | 7th August | RTM | P Bullion
1956-08-01 00:00:00 | [NAME] | [NAME] | x1 | Invest Skills | 8th August | 8th August | RTM | Nur
1957-08-01 00:00:00 | [NAME] | D Cooper | x1 | Invest Skills | 8th August | 8th August | RTM | Nur
1958-08-01 00:00:00 | [NAME] | S Lyth | x1 | Invest Skills | 8th August | 8th August | RTM | Nur
1959-08-01 00:00:00 | [NAME] | Intermedary | x1 | Invest Skills | 8th August | 8th August | RTM | Nur
1960-08-01 00:00:00 | [NAME] | [NAME] | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1961-08-01 00:00:00 | [NAME] | [NAME] | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1962-08-01 00:00:00 | [NAME] | [NAME] | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1963-08-01 00:00:00 | [NAME] | Les payne | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1964-08-01 00:00:00 | [NAME] | Marcus Ward | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1965-08-01 00:00:00 | [NAME] | [NAME] | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1966-08-01 00:00:00 | [NAME] | [NAME] | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1967-08-01 00:00:00 | [NAME] | [NAME] | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1968-08-01 00:00:00 | [NAME] | [NAME] | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1969-08-01 00:00:00 | [NAME] | [NAME] | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1970-08-01 00:00:00 | [NAME] | [NAME] | x1 | PCSO | 9th August | 9th August | RTI | P Bullion
1971-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 12th August | 12th August | RTK | P Bullion
1972-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 12th August | 12th August | RTK | P Bullion
1973-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 12th August | 12th August | RTK | P Bullion
1974-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1975-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1976-08-01 00:00:00 | [NAME] | Les payne | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1977-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1978-08-01 00:00:00 | [NAME] | mary Colbeck | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1979-08-01 00:00:00 | [NAME] | Adrian Uzzell | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1980-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1981-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1982-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1983-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1984-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1985-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1986-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1987-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 13th August | 14th August | RTK | P Bullion
1988-08-01 00:00:00 | [NAME] | [NAME] | x1 | IPLDP | 14th August | 14th August | RTK | P Bullion
1989-08-01 00:00:00 | [NAME] | [NAME] | X1 | IPLDP | 15th August | 16th August | RTK | Nur
1990-08-01 00:00:00 | [NAME] | [NAME] | X1 | IPLDP | 15th August | 16th August | RTK | Nur
1991-08-01 00:00:00 | [NAME] | [NAME] | X1 | PCSO | 15th August | 16th August | RTI | Nur
1992-08-01 00:00:00 | [NAME] | [NAME] | X1 | PCSO | 15th August | 16th August | RTI | Nur
1993-08-01 00:00:00 | [NAME] | [NAME] | X1 | IPLDP | 15th August | 16th August | RTK | Nur
1994-08-01 00:00:00 | [NAME] | [NAME] | X1 | PCSO | 15th August | 16th August | RTI | Nur
1995-08-01 00:00:00 | [NAME] | [NAME] | X1 | PCSO | 15th August | 16th August | RTI | Nur
1996-08-01 00:00:00 | [NAME] | [NAME] | X1 | PCSO | 15th August | 16th August | RTI | Nur
1997-08-01 00:00:00 | [NAME] | [NAME] | X1 | IPLDP | 15th August | 16th August | RTK | Nur
1998-08-01 00:00:00 | [NAME] | [NAME] | X1 | IPLDP | 15th August | 16th August | RTK | Nur
1999-08-01 00:00:00 | [NAME] | [NAME] | X1 | IPLDP | 15th August | 16th August | RTK | Nur
Aug 100 | [NAME] | [NAME] | X1 | IPLDP | 15th August | 16th August | RTK | Nur
Aug 101 | [NAME] | [NAME] | X1 | IPLDP | 15th August | 16th August | RTK | Nur
Aug 102 | [NAME] | [NAME] | X1 | IPLDP | 15th August | 16th August | RTK | Nur
Aug 103 | [NAME] | [NAME] | X1 | IPLDP | 15th August | 16th August | RTK | Nur
Aug 104 | [NAME] | [NAME] | X1 | Specials [NAME] | 16th Augu | 16th August | RTW | Nur
Aug 105 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 19th August | 21st August | RTK | P Bullion
Aug 106 | [NAME] | [NAME] | x1 | IPLDP Volunteer | 19th August | 21st August | RTK | P Bullion
Aug 107 | Quoc Vo | Quoc Vo | x1 | Staying at Bramshill | 19th August | 19th August | RTG | P Bullion
Aug 108 | Quoc Vo | Quoc Vo | x1 | Staying at Bramshill | 19th August | 20th August | RTG | P Bullion
Aug 109 | [NAME] | [NAME] | x1 | PCSO | 20th August | 22nd August | RTI | P Bullion
Aug 110 | [NAME] | [NAME] | x1 | PCSO | 20th August | 22nd August | RTI | P Bullion
|Aug 111 | Quoc Vo | Quoc Vo | x1 | Staying at Bramshill | 20th August | 21st August | RTI | P Bullion
Aug 112 | Quoc Vo | Quoc Vo | x1 | Staying at Bramshill | 20th August | 21st August | RTI | P Bullion
Aug 113 | Quoc Vo | Quoc Vo | x1 | Staying at Bramshill | 20th August | 21st August | RTI | P Bullion
Aug 114 | Quoc Vo | Quoc Vo | x1 | Staying at Bramshill | 20th August | 22nd August | RTI | P Bullion
.Aug 115 | [NAME] | [NAME] | x1 | PCSO | 20th August | 23rd August | RTI | P Bullion
Aug 116 | [NAME] | [NAME] | x1 | PCSO | 20th August | 23rd August | RTI | P Bullion
Aug 117 | [NAME] | [NAME] | x1 | PCSO | 20th August | 23rd August | RTI | P Bullion
Aug 118 | [NAME] | [NAME] | x1 | PCSO | 20th August | 23rd August | RTI | P Bullion
Aug 119 | [NAME] | [NAME] | x1 | PCSO | 20th August | 23rd August | RTI | P Bullion
Aug 120 | [NAME] | Adrian Uzzell | x1 | PCSO | 20th August | 23rd August | RTI | P Bullion
Aug 121 | [NAME] | [NAME] | x1 | PCSO | 20th August | 23rd August | RTI | P Bullion
Aug 122 | [NAME] | [NAME] | x1 | PCSO | 20th August | 23rd August | RTI | P Bullion
Aug 123 | [NAME] | [NAME] | x1 | PCSO | 20th August | 23rd August | RTI | P Bullion
Aug 124 | [NAME] | [NAME] | x1 | IPLDP | 21st August | 21st August | RTK | P Bullion
Aug 125 | [NAME] | [NAME] | x1 | IPLDP | 21st August | 21st August | RTK | P Bullion
Aug 126 | [NAME] | [NAME] | x1 | Specials [NAME] | 23rd August | 23rd August | RTJ | P Bullion
Aug 127 | [NAME] | [NAME] | x1 | IPLDP VOLUNTEERS | 29TH August | 29th august | RTK | N Sarson
Aug 128 | [NAME] | [NAME] | x1 | IPLDP VOLUNTEERS | 29TH August | 29th august | RTK | N Sarson
Aug 129 | [NAME] | [NAME] | x1 | IPLDP Volunteers | 29TH August | 29th august | RTK | N Sarson
Aug 130 | [NAME] | [NAME] | x1 | IPLDP Volunteers | 29TH August | 29th august | RTK | N Sarson
Aug 131 | [NAME] | mary Colbeck | x1 | IPLDP Volunteers | 29TH August | 29th august | RTK | N Sarson
aug 132 | [NAME] | Les payne | x1 | IPLDP Volunteers | 29TH August | 29th august | RTK | N Sarson
Aug 133 | [NAME] | [NAME] | x1 | IPLDP Volunteers | 29TH August | 29th august | RTK | N Sarson
Aug 134 | [NAME] | [NAME] | x1 | IPLDP Volunteers | 29TH August | 29th august | RTK | N Sarson
Aug 135 | [NAME] | [NAME] | x1 | Specials [NAME] | 29th August | 30th August | RTJ | N Sarson
Aug136-140 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | N Sarson
Aug141-145 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
146-150 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
151-154 | [NAME] | [NAME] | x4 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
155-159 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
160-164 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
165-179 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
180-184 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
185-189 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
190-194 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
195-199 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
200-204 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
205-209 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
210-214 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
215-219 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS
220-224 | [NAME] | [NAME] | x5 | Assessor | 29TH August | 02/09/13-06/09/13 | RHA | NS