Data Consolidation Project (Part 3)

V35

Updated Sheet.

One hint to new memebers : Do not run the Macro from the consolidated sheet. The formulas in the Summary sheet are dynamic , so for each update it calculates the cells again, this is time consuming.

copy the required sheet in another file which has the macro and run it from there. After the macro completes copy back the sheet to the consolidated sheet.
 
Procedure

Hi there,

I am reletively new to this forum. I am willing to take initiative in scanning for a few more dates. Can you please tell me how I can scan the dates and post the results here?
 
ver 36.0

Here a newer version.
New updates for the remaining dates.
new addition - Oocyte's data for SRC03-002 to SRC03-004.

One thing to note is so far we have seen 42 approvals in the month of Sep 03 & 8 in this month. There are other approvals
for this month which are not in our consolidated file
viz.
VVrajan 04/01/01 - 10/6
TXRUS 11/01 - 10/4
Agni's friend - SRC01251 10/01
 
w8nc & Tivam

There is a 24 hour limit of 1000 hits from 1 particular IP.
After you exceed the limit it will give you a message that you have to wait for 24 hours.

Also when it run 3-4 invalid numbers, you also get blocked out and have to wait for 24 hours ( sucks). Since you are running for the 1st time, you might want to use smaller ranges.
If you have a dial-up connection then you can re-connect and you would usually get a new IP.
If you have a DSL, then there is a way of using a proxy connection
and running more scans.
After you have found all the valid 485 SRCs, the next runs are easier. for that I would suggest you use this version of macro written by Luta. It also records the prior status of the case.
Also when you guys are done, you might want to add your excel sheets to the consolidated file and create the new zipped version. Else you can post the excel sheet here and someone can add it to the consolidated file. Hope this helps.
 
Hi

I got my I-140 approved last week, and just looking at this forum and i will get the SRC03 044 to SRC03 076 data updated soon...

I have all this data from my previous scannings...


Count on me..



Thanks
 
June 22, 2001

Have been scanning repeatedly....dont see any change from my first scan close to 2 months back. :mad:
 
I see 4 cases for my ND approved

I was trying to find the status of my case and checked on the cases submitted with ND of October,30,2002.
I saw 4 cases out of them are approved.
All these were approved on September 17, 2003.

ND : October30,2002

SRC0302251XXX

Approved - 4
FP/Recd - 11
Case received - 47
 
ND Aug 28, 2001 scanned on Oct 13 added

Can one of the senior members check and see if I messed up the file. thanks
 
Looks good, except that your have 29-Aug-2001 in the ND column. Since it does not effect any calculations, it is okay.

The person doing the next version, please change it to 28-Aug-2003.
 
>The person doing the next version, please change it to 28-Aug-2003: DONE!

Updated the following data to V38:
==========================
SRC-02-039: 50000 - 53375

Last Scan Date: 10/15/2003
Notice Date: 11/17/2001
Last Activity: 10/14/2003 (RFE Reply Received)

Last Approval: 09/02/2003
Last Transfer: 07/23/2003
Last Resumed/FP Recv: 07/16/2003

Total Cases: 197

Approved/Completed: 81 (41%)
Withdrawn: 1 (1%)
FP sent: 1 (1%)
Misc: 10 (5%)
Received: 38 (19%)
Resumed/FP recvd: 43 (22%)
RFE Sent: 1 (1%)
RFE Recvd: 1 (1%)
Transferred: 21 (11%)
 
You must log in or register to reply here.
Top