October Approvals needed.

aks999 said:
can someone please point me to the place where the tracking tool is?? I will try to run from my machine. Appreciate, if you can also write few lines on how to use it.

Thanks,
aks

Sorry I missed this earlier. Here's the "raw" scan macro (attached).

Make sure you have macros enabled in Excel. Under Tools->Macro->Macros select the macro you want to run (e.g. I140Scan).

Click Run.

Enter yy-ddd to scan. Note that the year starts on Oct. 1 and that ddd only seems to include working days (more or less). The date comes from the Notice Date (ND) for the cases.

So, to scan for cases with a ND of 10/01/03, I've been using 04-001. For 10/23/03 (my own ND), I'd use 04-016 (not 04-023 since ddd is the number of work days).

Now you'll be asked for the case # range. These usually seem to be in 50000 - 54000 or thereabouts. Don't specify more than about 250 cases -- after this you will be locked out for your IP (or perhaps your entire company / ISP IP) for some period of time).

If there are "hits" (e.g. an I-140 case is found), the results will be pasted into the spreadsheet. This should show the case EAC#, it's status and last updated date.

Afaik, there's no easy way to find all cases for a given day apart from the way I've been doing it (probe all case #'s from 50000 through 54000 in groups of 250).

Note, if you run the scan and then run it again for the same yy-ddd (or save the results from a search and load the scan again, it won't ask for a range -- it will use the EAC #'s which are already present from the previous scan.

This is good if you want to repeat a scan for previously found cases.

Otherwise, you can delete the sheet (right click on the tab at the bottom and delete it) and the scan will be done anew.

ETA
 
No changes to I-140 cases in 10/01/03 - 10/21/03

Added a few more cases to the list and scanned these just now. What I'll probably do is scan these every day or so starting on Tuesday and only post something if there's a change...

EAC0400151408 Received 10/1/2003 Received
EAC0400151422 Received 10/1/2003 Received
EAC0400151473 Received 10/1/2003 Received
EAC0400151529 Received 10/1/2003 Received
EAC0400151590 Received 10/1/2003 Received
EAC0400151689 Received 10/1/2003 Received
EAC0400151839 Received 10/1/2003 Received
EAC0400151871 Received 10/1/2003 Received
EAC0400151980 Received 10/1/2003 Received
EAC0400151999 Received 10/1/2003 Received
EAC0400152095 Received 10/1/2003 Received
EAC0400152177 Received 10/1/2003 Received
EAC0400152233 Received 10/1/2003 Received
EAC0400152239 Received 10/1/2003 Received
EAC0400152282 Received 10/1/2003 Received
EAC0400152315 Received 10/1/2003 Received
EAC0400251206 Received 10/2/2003 Received
EAC0400251260 Received 10/2/2003 Received
EAC0400251288 Received 10/2/2003 Received
EAC0400351218 Received 10/3/2003 Received
EAC0400351340 Received 10/3/2003 Received
EAC0400351368 Received 10/3/2003 Received
EAC0400451250 Received 10/6/2003 Received
EAC0400451287 Received 10/6/2003 Received
EAC0400451309 Received 10/6/2003 Received
EAC0400451326 Received 10/6/2003 Received
EAC0400451338 Received 10/6/2003 Received
EAC0400551215 Received 10/7/2003 Received
EAC0400551231 Received 10/7/2003 Received
EAC0400551274 Received 10/7/2003 Received
EAC0400551364 Received 10/7/2003 Received
EAC0400551392 Received 10/7/2003 Received
EAC0400651282 Received 10/8/2003 Received
EAC0400651293 Received 10/8/2003 Received
EAC0400651374 Received 10/8/2003 Received
EAC0400851281 Received 10/10/2003 Received
EAC0400851287 Received 10/10/2003 Received
EAC0400851303 Received 10/10/2003 Received
EAC0400851313 Received 10/10/2003 Received
EAC0400851334 Received 10/10/2003 Received
EAC0400851349 Received 10/10/2003 Received
EAC0400851375 Received 10/10/2003 Received
EAC0401151249 Received 10/16/2003 Received
EAC0401451413 Received 10/21/2003 Received
EAC0401451420 Received 10/21/2003 Received
EAC0401451426 Received 10/21/2003 Received

ETA
 
ETA-GC said:
Afaik, there's no easy way to find all cases for a given day apart from the way I've been doing it (probe all case #'s from 50000 through 54000 in groups of 250).
ETA

I would go till 54500.I think 55000 is max no usually.
My I485 ND oct 2 03 goes beyond 54000
 
EAC04002 (Oct 2nd Cases)

I did a sample scan for these cases. I am posting full scan results including approved cases. I did scan little more than 1000 (1300) cases. I have to say i see lot of I181 cases which were filed and approved .

EAC Status Date Status Group
EAC0400250604 Received 10/2/2003 Received
EAC0400250643 Approved 5/3/2004 Approved/Completed
EAC0400250697 Approved 5/3/2004 Approved/Completed
EAC0400250733 Received 10/2/2003 Received
EAC0400250760 Received 10/2/2003 Received
EAC0400250788 Received 10/2/2003 Received
EAC0400250805 Received 10/2/2003 Received
EAC0400250825 Approved 5/20/2004 Approved/Completed
EAC0400250849 Received 10/2/2003 Received
EAC0400250999 Approved 12/29/2003 Approved/Completed
EAC0400251056 Received 10/2/2003 Received
EAC0400251130 Approved 12/29/2003 Approved/Completed
EAC0400251161 Approved 12/22/2003 Approved/Completed
EAC0400251206 Received 10/2/2003 Received

Looks like there were quiet a few folks who are got approved in Dec 03.
 
hmd said:
I did a sample scan for these cases. I am posting full scan results including approved cases. I did scan little more than 1000 (1300) cases. I have to say i see lot of I181 cases which were filed and approved .

EAC Status Date Status Group
EAC0400250604 Received 10/2/2003 Received
EAC0400250643 Approved 5/3/2004 Approved/Completed
EAC0400250697 Approved 5/3/2004 Approved/Completed
EAC0400250733 Received 10/2/2003 Received
EAC0400250760 Received 10/2/2003 Received
EAC0400250788 Received 10/2/2003 Received
EAC0400250805 Received 10/2/2003 Received
EAC0400250825 Approved 5/20/2004 Approved/Completed
EAC0400250849 Received 10/2/2003 Received
EAC0400250999 Approved 12/29/2003 Approved/Completed
EAC0400251056 Received 10/2/2003 Received
EAC0400251130 Approved 12/29/2003 Approved/Completed
EAC0400251161 Approved 12/22/2003 Approved/Completed
EAC0400251206 Received 10/2/2003 Received

Looks like there were quiet a few folks who are got approved in Dec 03.

I'd guess that most of those approvals were cases with RFE's (after the response to the RFE, the cases were / are often adjucated shortly thereafter).

ETA
 
Dec 03 Approval

I was talking to my employer and he said one of the cases filed by our Company Dec 03 was approved without RFE. Mine is Sep 03 Still waiting...Unfortunately as a policy he could not give my any part of the EAC Num or the actual ND. But I wanted to share this base info of a Dec03 approval.

Yeppo
 
Yeah, its funny how the odd case seems to trickle through "ahead of its time" (like the 10/01/03 approval from last week). Maybe sometimes a case officer ends up with the odd case by accident.

Hopefully we'll see some more approvals this week / get more insight into how/if/when the VSC is switching over to the FO guidelines...

ETA
 
I guess I am getting frustrated - FO memo or not - things should keep moving - that is all that is needed.
 
Jharkhandi said:
I guess I am getting frustrated - FO memo or not - things should keep moving - that is all that is needed.


Well..things will move at the pace of CIS. so not to sound pesimestic but i think by Oct 1 04 which will start of new fiscal year(05) for CIS the official processing Date for I140 at VSC will be close to Current or may be One to Two Months behind. PPl getting actual approvals might be another matter.
 
I am getting frustrated as I do not see FP notices coming in bulk. I think a nice analysis by nemessis is need of the hour.
 
I would like to be able to do that, but with the 250 limit it is impossible. Also I was wondering why did they stop sending FP for July 2003. The answer might be that they've sent FP2 (I have seen ppl from 2002 reporting FP2 done in Apr-May 2004). I hope that they are done with the FP2 and they'll start sending FP1 again.

Jharkhandi said:
I am getting frustrated as I do not see FP notices coming in bulk. I think a nice analysis by nemessis is need of the hour.
 
Does anybody know is there a limit to number of cases in a representative portfolio?
If we could add a large number of handpicked cases in a portfolio and then a few of us privately share the password, wouldn't that make the progress tracking easier than the constant scanning?
 
Jharkhandi said:
Who is going to enter cases? They are in cool 4 digits/month.
It's a tradeoff. There is more work upfront, but then we just sit and wait for email notifications.
We could split the work among different people or write a script for that.
Anyway, I'm not really pushing for that since it may even not be possible.
 
I know it's not related but ...

I copy/pasted here the results from the last spreadsheet I posted Sunday on I485 from the sampling data. Please take a look over these dates, these are the approval dates for all 2003 approved applic (all EAC # togheter). I arranged them in the same column to see if there is a variation in the work volume in time:

12/19/2002
12/21/2002
2/1/2003
2/5/2003
2/7/2003
2/7/2003
2/7/2003
2/14/2003
2/14/2003
2/25/2003
2/25/2003
3/20/2003
4/10/2003
5/13/2003
6/16/2003
7/8/2003
9/18/2003
9/23/2003
9/27/2003
9/30/2003
10/1/2003
10/1/2003
10/3/2003
10/4/2003
10/20/2003
10/27/2003
10/27/2003
11/6/2003
11/8/2003
11/20/2003
11/20/2003
11/20/2003
11/20/2003
11/21/2003
11/21/2003
12/4/2003
12/9/2003
12/9/2003
12/16/2003
12/23/2003
1/2/2004
1/6/2004
1/12/2004
1/13/2004
1/13/2004
1/13/2004
1/13/2004
1/13/2004
1/13/2004
1/13/2004
1/13/2004
1/13/2004
1/21/2004
1/21/2004
1/21/2004
2/6/2004
2/9/2004
2/9/2004
2/18/2004
2/23/2004
2/24/2004
2/27/2004
3/12/2004
3/12/2004
3/15/2004
3/15/2004
3/15/2004
3/16/2004
3/16/2004
3/16/2004
3/16/2004
3/16/2004
3/16/2004
3/17/2004
3/19/2004
3/19/2004
3/19/2004
3/20/2004
3/20/2004
3/20/2004
3/23/2004
3/23/2004
3/23/2004
3/23/2004
3/23/2004
3/23/2004
3/23/2004
3/23/2004
3/23/2004
3/23/2004
3/23/2004
3/24/2004
3/25/2004
3/25/2004
3/25/2004
3/26/2004
3/26/2004
3/26/2004
3/29/2004
3/30/2004
3/30/2004
3/30/2004
3/30/2004
3/30/2004
3/30/2004
3/30/2004
3/30/2004
3/30/2004
3/31/2004
3/31/2004
3/31/2004
4/1/2004
4/1/2004
4/1/2004
4/2/2004
4/2/2004
4/6/2004
4/6/2004
4/6/2004
4/6/2004
4/8/2004
4/14/2004
4/15/2004
4/15/2004
4/15/2004
4/20/2004
4/22/2004
4/30/2004
4/30/2004
5/4/2004
5/10/2004
5/10/2004
5/10/2004
5/10/2004
5/10/2004
5/10/2004
5/11/2004
5/12/2004
5/12/2004
5/12/2004
5/12/2004
5/12/2004
5/13/2004
5/13/2004
5/13/2004
5/13/2004
5/13/2004
5/13/2004
5/14/2004
5/14/2004
5/18/2004
5/18/2004
5/18/2004
5/18/2004
5/18/2004
5/18/2004
5/18/2004
5/21/2004
5/21/2004
5/24/2004
5/24/2004
5/25/2004
5/25/2004
5/25/2004
5/26/2004
5/26/2004
5/26/2004
5/26/2004
5/26/2004
5/26/2004


Don't you feel that the rate of approvals is increasing from this series of data? The pattern looks very different in 2004 compared with 2003, especially in the last 2 months ... From a total of 170 approvals a third of them are in the last 2 months ... a fourth in the last month ...
 
Nemesis

Could post the EAC no's too if that is not too much work. That will give us an idea which ND are getting apporved at least in last two months.
 
Go to:
http://www.immigrationportal.com/showthread.php?t=125115&page=2

and download the last worksheet: 5_30_2004.xls. The last spreadsheet has all the approvals with the EAC # and the approval dates. Here I just put them togheter in a column and ordered them to see if the approval rates increased, and that seems to be the case.


hmd said:
Nemesis

Could post the EAC no's too if that is not too much work. That will give us an idea which ND are getting apporved at least in last two months.
 
nemessis said:
Don't you feel that the rate of approvals is increasing from this series of data? The pattern looks very different in 2004 compared with 2003, especially in the last 2 months ... From a total of 170 approvals a third of them are in the last 2 months ... a fourth in the last month ...

Very interesting and encouraging. I can't wait to see the progress in June. Thanks nemessis !!!
 
Top