TSC I485 Tracker in April 04

G

goastros

Registered Users (C)
What is this all about ?

This excel program checks the status of a range of SRC numbers using the USCIS online status check facility and store the 485
numbers in the excelsheet for future checks of status changes.

The credit of first writing this ingenious VB/excel
macro goes to OFF_PATIENCE
And then other fellow forum members have modifed it since.

Individual Scan results have then been consolidated and stored in 1 common file - all_cons.xls.
Please see the summary sheet to understand it.

How to Scan?
These are Instructions to run the macro for the 1st Time to scan a New SRC Range

1> Download the attached Excel file.

2> Inform here which date you are going to scan and make sure that you are not doing the scan for same date some one else is doing or has not done.

3> Before you run the macro check the security level of your Excel
file.
Security Level tab is found at (Tools menu, Macro
submenu, Security command).
The level cannot be at High, it should be changed to Medium
or Low.
Now you are ready to run the macro.

4> To run the macro you have to go to the menu at the top of the
screen and look for Tools,
then look for the submenu Macro and then Macros.
It will pop up a box titled Macro.
You can see 4 Macros listed (I485Scan, MakeChart, MultiScan & Sort485).
Select I485Scan and hit the Run button at the right.
Another box will pop up titled Excel.
There, you have to enter the first five digits corresponding to
the SRC range you want to check.
for eg - 01-001 and press OK.
Another box will pup up and enter the range of the last five
digits to check.
Start from 50000 to 51000 and go all the way to 56000.
Note - at a time, you can only scan for 1000 cases from the
same IP address before
'We are sorry' message. After that you have to change
your IP or wait for 24 hours
before you can scan again.
Important Note - When you try to scan more than
3 invalid SRCs, you get blocked as well.
So be wise in choosing the right range of SRC numbers.

5> The usual range starts from 50001-55999. Don't exceed 1000 at a time for a single IP address.

6> The macro will run and will show the results found.
It will create a excel sheet with SRC and write down only the
485 cases.

7> After your 1st run is complete, for next set of 1000 nos,
rename the excel sheet by double clicking on the excel sheet tab.
It will allow you to rename the sheet.
Then repeat step 4>.
After this scan is over combine the 2 results.
Repeat this until you have exhausted finding the date range
or you feel exhausted..

9> You can use proxy servers if you would like to scan more on the same day. You can get some proxies for free if you search internet eg:-
www.atomintersoft.com

To change proxy open internet explorer or other browser. Goto Menu
Tools..Internet options...Connections...Lan Settings...click Use proxy and then enter Ip address and port info say ok and repeat from step 4.

And don't forget to post your results here or add to the consolidated file.

Thanks to Pradha for the current version.

Note - Please feel free to suggest any changes
 
Last edited by a moderator:
RESCANNING

[Size=large]What is this freedom Zip file?[/Size]

1> Download the attached Zipped file.
The name of the zip file will be freedom_verxxx.zip
Use winzip to get a excel file all_cons.xls. Open this excel file. It may ask if you want to enable Macros.

2> Please take a look at the Members sheet which is the penultimate sheet. Check to see your id is listed in there as per your RD or not? If not, please add your id or post here and someone will update it.

3> Then take a look at the summary sheet. This summarizes about all the data created and then there is month-wise Approvals, RFEs, Transfers. ALso take a look at the no of approvals and the graphs below it.
It gives you a picture of of how TSC processing 485 cases, which months 485 it is currently processing etc.
Any Definite prediction based on this abt TSC is futile.
It just gives some idea.

4> If your particular SRC data or SRC number is not found in the data, then that is because the data has not been collected. You can help by collecting more data by following the instructions given in the 1st thread.

5> Or else you can help by Rescanning the data. The 'L' column tells us on what date this particular SRC was last scanned.

These are Instructions to rescan multiple sheets

6> Before you run the macro check the security level of your Excel
file.
Security Level tab is found at (Tools menu, Macro
submenu, Security command).
The level cannot be at High, it should be changed to Medium
or Low.
Now you are ready to run the macro.

7> To run the macro you have to go to the menu at the top of the
screen and look for Tools,
then look for the submenu Macro and then Macros.
It will pop up a box titled Macro.
You can see 4 Macros listed (I485Scan, MakeChart, MultiScan & Sort485).
Select MultiScan and hit the Run button at the
right.
Another box will pop up titled Excel.

After that it is very easy, give the range of sheets to be scanned in the following format YYDDD-YYDDD.

8> The macro will suspend calculations to the summary sheet, do the scan until it reaches a count of 990 and then stop, calculate the summary sheet.

9> After you run a Rescan, Rename the file to the next version number (freedom_verxxx.zip) and then zip and post the file here.
 
Last edited by a moderator:
Re: v254.zip

Originally posted by Braves2003
Scanned 02-073 to 02-083. Lot of approvals on 31st.
Click to expand...

Braves2003, your ver 254 has 02-07 scanned as of 03/29 ?
so looks like probably you have put a wrong file.
can I request you to delete your current post and re-create your file based on ver 255.

guys since we are in new month, can we please all join to scan
from 02-036 all the way till the end.

we usually scan the active region but TSC is full of suprises for us.
I had added Indianboyindallas's postings of Feb 2003 and you guys can see there is 1 approval for Feb 2003.

Usually there are only few people who do the rescan.
Can I please request more of you, who regular download the file
to help in this rescan effort.

The good news is that TSC is seeing lot of approvals.
We used to have people like EB2_,kumarsin,maybesoon,dvorak etc who would help in rescan.
But the other Good news is that they got approved..
So let that serve as another Incentive...:D :D
 
goastros !

While I am able to unzip, save, scan, save the file from Braves2003, I am not able to do that with your freedom_ver255. I am able to do eveything upto rescanning, but not able save. Application is kicking me out. Somebody else is having same problem ? Please try to open and save that XL and see.


Thanks
 
Re: goastros !

Originally posted by GC_Aspirant_11
While I am able to unzip, save, scan, save the file from Braves2003, I am not able to do that with your freedom_ver255. I am able to do eveything upto rescanning, but not able save. Application is kicking me out. Somebody else is having same problem ? Please try to open and save that XL and see.


Thanks
Click to expand...

I don't know why that has started happening. you are not the only person, GC_aspirant because Pradha is hvg the same issue
with my postings.
can you try this file -
 
Last edited by a moderator:
Ver257.

Goastros, Here is the new version. This includes the dates I have scanned before. 02-073 to 02-083.

Feb approval count - 1879
Mar approval count - 1882 so far..

Still lot of dates needs to be scanned in the active region.
 
Last edited by a moderator:
Thanks for the update Braves2003 - we need more folks to join in. As goastros said the good karma from the scanning/re-scanning may speed your approval! :)
 
Re: Nop !

Originally posted by GC_Aspirant_11
Samething ! Goastros!
Click to expand...
gc_aspirant, were you then able to download the file from braves2003 and run it correctly ?

braves2003, looks like you created ver 257 from my posted 256 which means my posting works correctly for you ?
see that is strange thing that my postings are not working for pradha & gc_aspirant but working for braves & others?
anyways, can someone scan from 02-037 onwards till 02-071
and then later on.
 
Re: Re: Nop !

Originally posted by goastros
gc_aspirant, were you then able to download the file from braves2003 and run it correctly ?

braves2003, looks like you created ver 257 from my posted 256 which means my posting works correctly for you ?
see that is strange thing that my postings are not working for pradha & gc_aspirant but working for braves & others?
anyways, can someone scan from 02-037 onwards till 02-071
and then later on.
Click to expand...

Yes! I am able to save Braves file.
 
A friend of mine just got RFE. His RD/ND is around end of Jan or beginning of Feb 2002. SRC02-097. This new trend in 02 is still progressing.
 
Last edited by a moderator:
scanned SRC03-072

Scanned SRC03-072, Please someone add this to Consolidated file.

Thanks
 
Last edited by a moderator:
Scanned SRC03-074

Scanned SRC03-074, Please someone add this to Consolidated file.

Thanks
 
Last edited by a moderator:
Scanned SRC03-073

Scanned SRC03-073, Please someone add this to Consolidated file.

Thanks
 
Last edited by a moderator:
Scanned SRC03-069

Scanned SRC03-069, Please someone add this to Consolidated file.

Thanks
 
Last edited by a moderator:
Start scan from March 1st

I had few unsuccessful saves after scanning of XL file. But I have remembered some counts.
I did scan about 2 days ago and found 4 approvals for March1st .
I scanned Feb-2002 cases from ver 259, now the approval count for March is 1944 and for Apr it is 30.
I did scan Apr-2002 cases also, but there are no approvals since the last update. So, there is no need to scan this range now.
If someone could start scan from March -2002 onwards.
 
Version 261

- added 01-232, 233, 234, 235, 237, 238, 239, 241
- rescanned from 01-233 upto 01-252 51027
- rescanned from 02-114 upto 02-134 55446

march approval count reached 2027
 
Last edited by a moderator:
Version 262

The previous version has a problem in Transferred column.

rescanned upto 01267 50903
rescanned upto 02155 53502

march approval 2036, but the weekly rate is lower than Feb.
transferred 543.

although the march count is above 2000 now, it is still less than approval count back in march 2002.
 
Last edited by a moderator:
You must log in or register to reply here.
Top