Data Consolidation Project

Status
Not open for further replies.
By just looking at the number of ppl. commenting about their numbers not being present in the consolidated data sheet, it amazes me to think how much we ASSUME (you know , in the process making an ASS of U and ME) things. Take things for granted to the extent that we go on to complain about the inefficiencies of even voluntary work even without contributing an iota to the whole project.

It pains to see somebody like BAJIS blowing his top. BAJIS, don't get frustrated by these posts. And to you guys reading this post and complaining about missing numbers ... HARD LUCK .. nothing comes free in this country. The least you can do is run the script for your RD/ND to see for any progess.

To all the ppl. who have contributed to this consolidated data sheet, please continue to remain patient and not get worked up.

Keep up the spirits folks !
 
How TO????

Hay Jaysee,

I also want to help in the effort, at least for some days but I don't know how it works. Is there a way I can learn about it?

Thanks.
 
'How To'

I will make an attempt at writing 'How to' for IndianInDallas.
I have inserted a excel file, download it , open it and click on
Tools, Macro ,Macros
Choose I485Scan.
It will ask for ND year & day (that is the SRC's 1st 5 digits) in YY-DDD format.
For the 1st run, it will ask for the SRC range, start with a smaller range initially. valid ranges exists from 50000 to 56000.
On a day, you will be allowed to check for only 1000 cases from a IP address. Again if you hit an invalid range sequence, you will get blocked for 1 day.
The macro will do the rest, create the Excel sheet and write down only the 485 cases.
On subsequent runs, if you choose already existing sheet, it will only check the Non-Approved 485 cases.
Hope this helps, IndianinDallas or anyone else.
 
Version 15

New features
+ All updates up to August 6th , 2003 for
SRC02-176
SRC02-131
SRC02-096 ( found few more Cases)
SRC01-050 ( found few more Cases)
 
Do we want to feed the data for Notice Date after August 02 with SRC #03 or is it too early?
Should we create seperate data for Concurrent filers?

Thanks

Khush
 
Please add my details too.

PD 10/99
ND 9/2001
FP 03/2003
SRC01280xxxxx

Thanks!
 
Last edited by a moderator:
ajith

it is not adding details. if you read through you will find people have downloaded this information from the tsc web site. probably you could help us by downloading your date and help add more data to the efforts. more data more accurate trend analysis

thanks:(
 
more data

I just added src01146 (ND April, 11, 2001) data to the consolidation file.

Please see the attached
 
Goastros

Can you post what range you have used for SRC02-176.

This Data Consolidation is pretty neat and very informative too.

All the Luck.

RD/ND: 05/17/02
FP: 06/12/03
AD: ?????:confused: :confused: :confused: :mad: :mad:
 
Just added SRC-02-039 to the ZIP file.

Notice Date: 11/17/2001
Range: SRC-02-039-50000 to SRC-02-039-53375
Number of cases: 197
Macro run date: 08/02/2003

Approval: 80 (41%)
Withdrawn/Denied: 1 (1%)
FP Sent: 1 (1%)
Misc: 11 (6%)
Received: 40 (20%)
Resumed/FP Recv: 43 (22%)
Transferred: 21 (11%)

Last Approval: 03/13/2003
Last Resumed/FP Recv: 7/16/2003
Last Transfer: 7/23/2003 (last activity date for this range)
 
Version 18

Optimized some formulas in the Summary Sheet.

Also added the "Date Scanned" Column in the summary Sheet.


It is good to see some more people contributing. However this thread has now over 10000 views but we only have about 45 days of data :-( .
 
Version 19

Added
+ SRC01-069
Date is 03-Jan-2001
The % approval for this date is bad considering it is Jan 2001.

Approved/Completed Count 57 ( just 56.7%)
Misc Count 6
Received Count 19
RFE recvd Count 1
RFE sent Count 2
Transferred Count 12
Grand Count 97
 
One more date SRC1-256. My first post here and I did not want to mess up the consolidated file. Hope this works. Someone please add this to the consolidated file. thanks.
 
Here is another date SRC1-245. ND is 08/16/2001. This file was generated yesterday, aug 7. Do you know how long it will be for me to have access again to the online status?
 
ver 20.0

+ Added SRC01-245 & SRC01-256

Thanks Dvorak & Woody.

Woody , wait for 24 hours and you can access agin. Or else change your IP and try.
 
GCMemPhis

GCMemphis - This is the entire range that I could find for SRC02-176.
Why, do you have any other numbers for SRC02-176.
If so, can you please provide us.
Also if you could scan & add any more day, that would be great.
Maybe , 1 year before or early 2001 date.
 
summary report?

Anybody please provide some trending report?

BTW, I found some recent apporvals in sep 2002

SRC0226550397 Approved 06/02/2003 Approved/Completed
SRC0226550413 Card ordered 05/29/2003 Approved/Completed
SRC0226550430 Card ordered 05/29/2003 Approved/Completed
SRC0226550438 RFE sent 03/07/2003 RFE sent
SRC0226550472 Transferred 11/06/2002 Transferred
SRC0226550498 Transferred 04/15/2003 Transferred
SRC0226550512 Card ordered 05/14/2003 Approved/Completed
not sure they are captured in any data sheets.

It looks like total random processing.
 
Status
Not open for further replies.
Top