Spreadsheet: 99503d1298117163-finding-data-from-other-sheets-main
Sheet: wc 9-8-10

 | Claims sent from: |  | BELLE VALE |  |  |  |  |  |  | Date: | 2010-08-10 00:00:00
 | Exporting office |  |  |  |  |  |  | Importing Office |  |  |  |  | CCG section
 | Surname | First Name | NINO | Date Sent | App NO | Bundle No | Bag No | Date recd by exprting office | date of decision | Name of DM | [NAME] to Belle Vale | Bag No | Date rec by [NAME] | Date cleared on S/F tracker
1 | mcdermott | pamala | YS888077C | 2010-08-10 00:00:00 | 1 | 1 | 1
2 | mccomiskie | [NAME] | YR547615D | 2010-08-10 00:00:00 | 7 | 1 | 1
3 | lunt | mark | NY468014D | 2010-08-10 00:00:00 | 36 | 1 | 1
4 | [NAME] | natalie | JK476391D | 2010-08-10 00:00:00 | 6 | 1 | 1
5 | lawton | [NAME] | WM236997A | 2010-08-10 00:00:00 | 33 | 1 | 1
6 | [NAME] | [NAME] | YM785304A | 2010-08-10 00:00:00 | 5 | 1 | 1
7 | [NAME] | [NAME] | JW734422C | 2010-08-10 00:00:00 | 14 | 1 | 1
8 | kirwan | christine | WP043138D | 2010-08-10 00:00:00 | 98 | 1 | 1
9 | [NAME] | [NAME] | NM326445C | 2010-08-10 00:00:00 | 12 | 1 | 1
10 | [NAME] | cecilia | YZ936727D | 2010-08-10 00:00:00 | 3 | 1 | 1
11 | [NAME] | leanne | JK565681B | 2010-08-10 00:00:00 | 36 | 1 | 1
12 | [NAME] | mark | JS183449B | 2010-08-10 00:00:00 | 2 | 1 | 1
13 | hulthen | wilfred | [NAME] | 2010-08-10 00:00:00 | 1 | 1 | 1
14 | hughes | mary | PW484999D | 2010-08-10 00:00:00 | 1 | 1 | 1
15 | hopkins | lisa | JG327794C | 2010-08-10 00:00:00 | 76 | 1 | 1
16
17 | riley | jason | [NAME] | 2010-08-10 00:00:00 | 32 | 2 | 1
18 | maciuleviciute | vida | SE794751D | 2010-08-10 00:00:00 | 6 | 2 | 1
19 | halliday | [NAME] | JL014925B | 2010-08-10 00:00:00 | 8 | 2 | 1
20 | shields | [NAME] | YY908326B | 2010-08-10 00:00:00 | 48 | 2 | 1
21 | sherman | clare | JK695098C | 2010-08-10 00:00:00 | 8 | 2 | 1
22 | sherlock | sean | NB230127D | 2010-08-10 00:00:00 | 74 | 2 | 1
23 | shelly | [NAME] | NS067114C | 2010-08-10 00:00:00 | 35 | 2 | 1
24 | sealeaf | [NAME] | PW488853B | 2010-08-10 00:00:00 | 91 | 2 | 1
25 | savage | elisha | JX087131D | 2010-08-10 00:00:00 | 2 | 2 | 1
26 | sarson | philpi | JN922642C | 2010-08-10 00:00:00 | 30 | 2 | 1
27 | hopkins | [NAME] | JK757325B | 2010-08-10 00:00:00 | 45 | 2 | 1
28 | hodge | [NAME] | YE229240A | 2010-08-10 00:00:00 | 2 | 2 | 1
29 | [NAME] | [NAME] | JN373024A | 2010-08-10 00:00:00 | 12 | 2 | 1
30 | heath | tracee | JK753328A | 2010-08-10 00:00:00 | 12 | 2 | 1
31 | griffin | ian | JK541736A | 2010-08-10 00:00:00 | 1 | 2 | 1
32
33 | duckworth | harly | JM617267D | 2010-08-10 00:00:00 | 3 | 3 | 1
34 | downes | lorraine | YT847813B | 2010-08-10 00:00:00 | 15 | 3 | 1
35 | donnelly | clare | JL752545B | 2010-08-10 00:00:00 | 21 | 3 | 1
36 | [NAME] | [NAME] | JL259002C | 2010-08-10 00:00:00 | 12 | 3 | 1
37 | delahunty | [NAME] | TW224367D | 2010-08-10 00:00:00 | 2 | 3 | 1
38 | davies | christine | NA194137B | 2010-08-10 00:00:00 | 1 | 3 | 1
39 | crayden | george | [NAME] | 2010-08-10 00:00:00 | 5 | 3 | 1
40 | hayes-mcwha | jade | JW325763D | 2010-08-10 00:00:00 | 5 | 3 | 1
41 | haslam | [NAME] | JN363773B | 2010-08-10 00:00:00 | 50 | 3 | 1
42 | griffith | [NAME] | [NAME] | 2010-08-10 00:00:00 | 23 | 3 | 1
43 | greylish | [NAME] | WP004222C | 2010-08-10 00:00:00 | 3 | 3 | 1
44 | gilfoyle | [NAME] | [NAME] | 2010-08-10 00:00:00 | 26 | 3 | 1
45 | francis | [NAME] | NE666709B | 2010-08-10 00:00:00 | 10 | 3 | 1
46 | [NAME] | neil | [NAME] | 2010-08-10 00:00:00 | 51 | 3 | 1
47 | [NAME] | gary | [NAME] | 2010-08-10 00:00:00 | 17 | 3 | 1
48
49 | fitzgibbon | emma | JJ723168A | 2010-08-10 00:00:00 | 15 | 4 | 1
50 | [NAME] | shauna | JH011498C | 2010-08-10 00:00:00 | 24 | 4 | 1
51 | edmunds | [NAME] | JP089111D | 2010-08-10 00:00:00 | 15 | 4 | 1
52 | hughes | jennifer | YW576385B | 2010-08-10 00:00:00 | 53 | 4 | 1
53 | hunter | [NAME] | HA750953A | 2010-08-10 00:00:00 | 3 | 4 | 1
54 | noone | debbie | [NAME] | 2010-08-10 00:00:00 | 41 | 4 | 1
55 | mosawe | rachid | PX846221B | 2010-08-10 00:00:00 | 36 | 4 | 1
56 | morley | kate | JP048189B | 2010-08-10 00:00:00 | 36 | 4 | 1
57 | molyneux | elaine | NS102150B | 2010-08-10 00:00:00 | 9 | 4 | 1
58 | mather | irene | ZY786518D | 2010-08-10 00:00:00 | 17 | 4 | 1
59 | martin | [NAME] | YK502674D | 2010-08-10 00:00:00 | 23 | 4 | 1
60 | mekenna | [NAME] | WK694393D | 2010-08-10 00:00:00 | 1 | 4 | 1
61 | lampkin | [NAME] | JJ747696A | 2010-08-10 00:00:00 | 15 | 4 | 1
62 | karim | [NAME] | SC388488A | 2010-08-10 00:00:00 | 3 | 4 | 1
63 | jones | gwyneth | WM927902D | 2010-08-10 00:00:00 | 1 | 4 | 1
64
65 | jones | [NAME] | YY657574B | 2010-08-10 00:00:00 | 60 | 5 | 1
66 | [NAME] | jacquline | NR032728B | 2010-08-10 00:00:00 | 17 | 5 | 1
67 | rowe | [NAME] | JG274647D | 2010-08-10 00:00:00 | 1 | 5 | 1
68 | rowe | [NAME] | ZX558538D | 2010-08-10 00:00:00 | 4 | 5 | 1
69 | round | [NAME] | NX107767A | 2010-08-10 00:00:00 | 60 | 5 | 1
70 | robinson | [NAME] | JW054838C | 2010-08-10 00:00:00 | 10 | 5 | 1
71 | rice | mica | JK467960A | 2010-08-10 00:00:00 | 6 | 5 | 1
72 | rice | [NAME] | JM494441B | 2010-08-10 00:00:00 | 21 | 5 | 1
73 | ready | amanda | [NAME] | 2010-08-10 00:00:00 | 14 | 5 | 1
74 | priestley | [NAME] | JS814938C | 2010-08-10 00:00:00 | 15 | 5 | 1
75 | stuart | [NAME] | NS722424A | 2010-08-10 00:00:00 | 6 | 5 | 1
76 | Porter | chantelle | JG219480A | 2010-08-10 00:00:00 | 39 | 5 | 1
77 | pinsent | holly | JM910238C | 2010-08-10 00:00:00 | 1 | 5 | 1
78 | peacock | [NAME] | NX472666A | 2010-08-10 00:00:00 | 35 | 5 | 1
79 | [NAME] | [NAME] | JM396283D | 2010-08-10 00:00:00 | 28 | 5 | 1
80
81 | o'shaughnessy | pierre | JH172564A | 2010-08-10 00:00:00 | 41 | 6 | 1
82 | [NAME] | zelmab | SE445417B | 2010-08-10 00:00:00 | 6 | 6 | 1
83 | o'connor | [NAME] | JH511766C | 2010-08-10 00:00:00 | 35 | 6 | 1
84 | yeo | quey hat | PX120695D | 2010-08-10 00:00:00 | 2 | 6 | 1
85 | wilson | yvonne | WP291410D | 2010-08-10 00:00:00 | 32 | 6 | 1
86 | [NAME] | glyn | NP623902C | 2010-08-10 00:00:00 | 5 | 6 | 1
87 | [NAME] | adele | JK199400A | 2010-08-10 00:00:00 | 16 | 6 | 1
88 | [NAME] | carol | YZ824867C | 2010-08-10 00:00:00 | 6 | 6 | 1
89 | whelan | kyrsty | JS029662C | 2010-08-10 00:00:00 | 5 | 6 | 1
90 | turner | ian | YY801441D | 2010-08-10 00:00:00 | 1 | 6 | 1
91 | [NAME] | [NAME] | NY897605A | 2010-08-10 00:00:00 | 11 | 6 | 1
92 | townsend | helen | JC715807D | 2010-08-10 00:00:00 | 2 | 6 | 1
93 | swindells | lynsey | JE751027D | 2010-08-10 00:00:00 | 62 | 6 | 1
94 | [NAME] | sean | JK228945B | 2010-08-10 00:00:00 | 80 | 6 | 1
95 | [NAME] | jason | JK905355D | 2010-08-10 00:00:00 | 1 | 6 | 1
96
97 | greenwood | gillian | YX465029D | 2010-08-10 00:00:00 | 12 | 7 | 1
98 | gray | sonya | JA207813B | 2010-08-10 00:00:00 | 16 | 7 | 1
99 | gowe | melody | SC456302C | 2010-08-10 00:00:00 | 1 | 7 | 1
100 | [NAME] | [NAME] | JE928068A | 2010-08-10 00:00:00 | 81 | 7 | 1
101 | [NAME] | [NAME] | JS200699D | 2010-08-10 00:00:00 | 9 | 7 | 1
102 | fletcher | [NAME] | JP636618C | 2010-08-10 00:00:00 | 46 | 7 | 1
103 | ebanks | barbara | [NAME] | 2010-08-10 00:00:00 | 34 | 7 | 1
104 | ellis-thomas | [NAME] | WE360697B | 2010-08-10 00:00:00 | 3 | 7 | 1
105 | dunn | [NAME] | JS817168A | 2010-08-10 00:00:00 | 21 | 7 | 1
106 | duggan | karen | WK055452D | 2010-08-10 00:00:00 | 1 | 7 | 1
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202