VSC I485 Fiscal Yr 2002 - Progress Reports

sbctsublc

Registered Users (C)
VSC I485 Fiscal Yr 2002 - Progress Scan Reports

I'll be posting my scan results and report time to time.
I was able to scan only for partial jan 2002 ND cases. If there are more people to scan and share the results, we can cover more period and have a better picture.
I know many are benefited from this forum. It is time for you to contribute. Spare just 15 minutes a day to scan minimum of 1000 cases and you can pick all 485 cases for a day in just 5 days max. On average there are 300-450 485 cases for a day.

STEPS TO SCAN

1. 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
2. Open the following excel attachment
3. Press Ctrl+Z which will open a small window.
4. Enter the first 8 digits of EAC eg EAC02-087
5. Give the range ( usually starts from 50001. So give for eg 50001-50999.) Don't exceed 1000 at a time for a single IP address
6. If you want to scan for the next range, (say next day) copy this sheet to different name and again give same EAC number and next range of 1000. Then cut and paste to combine previous and current sheet.
7. 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 3.

Thats all. Its is so easy. 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

Thanks to Original author of this program OFF_PATIENCE.

Hope to see some volunteers.....


On 7/28/03,
Attaching modified program (already posted in a different post just copying the same here, since this is the first post and easily seen by many), This program will exit as soon as BLOCKED message appears


Added 1/18/04

I've started another thread to post Fiscal Year 2003 Scan Reports.
Click here to go to that thread
 
Last edited by a moderator:
485 case status for jan 2002 ND (1/2 to 1/15)

REPORT DATE:-18-JUN-03
DETAILS OF 563 APPROVED CASES WITH NOTICE DATES IN JAN 2002


291 CASE(S) WERE APPROVED IN MAY-2003
196 CASE(S) WERE APPROVED IN JUN-2003
16 CASE(S) WERE APPROVED IN SEP-2002
9 CASE(S) WERE APPROVED IN JUL-2002
8 CASE(S) WERE APPROVED IN APR-2003
7 CASE(S) WERE APPROVED IN NOV-2002
6 CASE(S) WERE APPROVED IN AUG-2002
5 CASE(S) WERE APPROVED IN MAR-2002
4 CASE(S) WERE APPROVED IN MAY-2002
4 CASE(S) WERE APPROVED IN MAR-2003
4 CASE(S) WERE APPROVED IN FEB-2002
3 CASE(S) WERE APPROVED IN DEC-2002
2 CASE(S) WERE APPROVED IN OCT-2002
2 CASE(S) WERE APPROVED IN JUN-2002
1 CASE(S) WERE APPROVED IN FEB-2003



REPORT DATE:-18-JUN-03
DETAILS OF 717 TRANSFERRED CASES WITH NOTICE DATES IN JAN 2002


177 CASE(S) WERE TRANSFERRED TO NEW YORK
135 CASE(S) WERE TRANSFERRED TO NEWARK AND TETERBORO
110 CASE(S) WERE TRANSFERRED TO BALTIMORE
93 CASE(S) WERE TRANSFERRED TO WASHINGTON
83 CASE(S) WERE TRANSFERRED TO BOSTON
37 CASE(S) WERE TRANSFERRED TO HARTFORD
35 CASE(S) WERE TRANSFERRED TO PHILADELPHIA
11 CASE(S) WERE TRANSFERRED TO PITTSBURGH
9 CASE(S) WERE TRANSFERRED TO NORFOLK
7 CASE(S) WERE TRANSFERRED TO SAN JUAN
4 CASE(S) WERE TRANSFERRED TO DALLAS
2 CASE(S) WERE TRANSFERRED TO CLEVELAND
2 CASE(S) WERE TRANSFERRED TO SAN ANTONIO
2 CASE(S) WERE TRANSFERRED TO INDIANAPOLIS
2 CASE(S) WERE TRANSFERRED TO HOUSTON
1 CASE(S) WERE TRANSFERRED TO CHARLOTTE
1 CASE(S) WERE TRANSFERRED TO LATHAM
1 CASE(S) WERE TRANSFERRED TO ST LOUIS
1 CASE(S) WERE TRANSFERRED TO SEATTLE
1 CASE(S) WERE TRANSFERRED TO PROVIDENCE
1 CASE(S) WERE TRANSFERRED TO MIAMI
1 CASE(S) WERE TRANSFERRED TO LOS ANGELES
1 CASE(S) WERE TRANSFERRED TO DENVER


E&OE
 
Last edited by a moderator:
It does not work

When I press Ctrl+Z
The Macro"attachement.php?s=postid=511233!ModeuleI485scan
cannot be found

And also when I click on the small window, it say "The macro in this project are disabled"


Check it yourself.
 
Hi brightstar,
It works fine for me. I just checked again. You have to download this file to your computer first and then You have to press 'Enable Macros' When you open the file and when it issues a warning that the document contains macros.

Try again. Good Luck.
 
Last edited by a moderator:
sbctsublc,

Sorry, it's not clear to me what exactly do you want us to do. Just scan a range of EACs daily? Or do you need actual 485 case numers, as result of running that script?
 
Originally posted by rickz
sbctsublc,

Sorry, it's not clear to me what exactly do you want us to do. Just scan a range of EACs daily? Or do you need actual 485 case numers, as result of running that script?

Many of us scan for our own (in and around) EAC numbers to know status and the results are scattered all over this forum. Currently BCIS is processing Jan02 and Feb 02 ND cases. In order to get accurate results (how many approved and how many pending) we need to pick all 485 cases that fall within these notice dates first. This process will take a long long time if it is done only by single person. So people who have already scanned 485 cases for these dates (for jan ND EAC02-075 to EAC02-099 need to find out for FEB) or willing to scan are welcome. I have already picked cases from 075 to 089. Also JanMM has data for 099. Like wise if more people could scan for other dates, we can complete jan, feb ND cases sooner. Later we can scan for March, April and so on.
Once 485 cases are picked, I'm willing to run status regularly (say every week) and post the consolidated results. Also we can share our data through private messages or by posting here, so that whoever has better tools to analyze the data and publish reports can do that and everybody can be benifited.
Any other suggestions or ideas are welcome....

Rickz,
So can You scan for some dates and share the picked actual 485 case numbers with me?
 
Last edited by a moderator:
Hi Vijayrc

Thank you very much.

Please do scan until you get 4 or 5 consecutive "the status of this case cannot found at this time". We can assume that you have got complete list of 485 cases on that date. Usually it does not reach 55000 (so on average you have to scan atleast 4000-5000) to get a complete 485 list for that day.

Also please post your results as excel attachment so that I can add that to my sheet.
Or you can send to my private email
sbctsublc@cox.net

Once again Thanks for your effort and keep it up

Others,
Now EAC Nos taken for to pick 485 cases are
EAC02-075 to EAC02-088, 099 JAN ND
EAC02-105(vijay) EAC02-108, 131, 132, 133 FEB ND

Any one else to scan for other dates?
 
EAC-02-119 stats

Date 6/18/2003
Grand Accont 369
FP Resumed 278
Received Count 53
Transferred Count 34
Approved 1
RFE 1
Misc Count 3
FP Sent 1
 
Re: EAC-02-119 stats

Originally posted by robertx71
Date 6/18/2003
Grand Accont 369
FP Resumed 278
Received Count 53
Transferred Count 34
Approved 1
RFE 1
Misc Count 3
FP Sent 1

Please share the picked EAC numbers by attaching the excel sheet or send thru email to me sbctsublc@cox.net for consolidation purposes

Thanks
 
02-111 & 02-112

sbctsublc,

thanx for explanation.

Here's my contribution :)

It holds ranges:
from 02-111-500001 to 02-111-500300
and
from 02-112-500001 to 02-112-500400
 
Last edited by a moderator:
Originally posted by rickz
I will.
Step by step. Sounds like a lot of cases, if you consider all 50000 of them.

No Rickz

Not 50,000 cases. Just 4000-5000 cases and on average few above 4000 cases. You start from 50,000 and mostly by the time you reach 54500 (ie total 4500 to scan), you will receive consecutive 4 or 5 error message "This status cannot be found at this time", and also you will get "you are blocked blah blah" message. (But if 1000 case limit not reached, you can close browser and restart for another day now since this error is because you have given invalid ie non existing numbers consecutively more than 4/5 times) When you reach here, you can comfortably assume that you have scanned all the cases for that day.
 
keeping this thread alive

lets keep this thread alive..we can keep posting
the scan results over here...any series..any ND/RD..
keep posting them here..i will do the same!!!

thanks to sbctsublc
 
02-098 series scan

Hi sbctsublc,

I'm taking care of 02-098 series.
So far 50000-52000 range has been scanned (see attachments)
Will keep updating...
 
EAC RANGE INFO & SIGN UP INFO

Hi Rickz & grivn,
Thanks

Hi All,

EAC RANGE

JAN 2002 ND EAC02-075 thru EAC02-099
FEB 2002 ND EAC02-100 thru EAC02-121

Case Assignment Info

EAC02-075......EAC02-097 sb
EAC02-098 grivn
EAC02-099 Jan MM
So Jan02 almost complete

Feb 02
EAC02-100 sb
EAC02-105 Vijayrc
EAC02-108 sb
EAC02-109 DNJ
EAC02-111, 112 rickz
EAC02-121 sb

Hope to start March soon....
 
Top