Data Consolidation Project

Status
Not open for further replies.
E

eb2_I485_RD0901

Registered Users (C)
Hi All,

In an attempt to consolidate the Excel Sheet , I have gone thru the various posts to see who is doing what days:

SRC01-139 vzexemp
SRC01-156 vkalya
SRC01-xxx (JUNE 29, 200) tscnd
SRC01-246 ukr
SRC01-248 (AUG 20, 2001) vettipuls
SRC01-248 goastros
SRC01-279 eb2_I485_RD0901
SRC01-280 eb2_I485_RD0901
SRC01-281 eb2_I485_RD0901
SRC02-135 SRC02-176 AND SRC01-135 vili
SRC02-160 Manolacho

If any body is doing more days please add to this list. Once we have significant members we can then consolidate the sheet.

PLEASE share your results and analysis.
 
Jaxen the moderator

I also have
SRC02-176 - 17th May 02
SRC02-096 - 1st Feb 02.

Some people have expressed their reservations in giving the actual SRCs on this forum.
Jaxen, what is your opinion if people post their excel sheets with actual SRC numbers?

Or should we take this topic offline and work thru e-mails in collecting the data.
we could then work with Advait's & others to consolidate & make sure we are not duplicating efforts.
EB2 & Villi & anyone else , you can e-mail at spj318ti@yahoo.com.
Advait is at advait_k@hotmail.com
 
I have the feeling that Advait has a different vision. He wants to merge all the data into a big file and later run it to find the updates only. I think he is too ambitious and I don't know about the feasibility of his plan with very limited resources. For each day we need one man week. For 600 days with 20 people we would need 30 weeks.

My analysis needs less data, however, it needs the files without merging. Ideally, one sample day for each month would be enough. But we have to analyze and follow the time distribution more and we want to know more than just the updates.

Goastros:
Can you ask Advait to share the data (unmerged files ) with us? We can share the analysis.
 
Actual SRC

I don't understand, why people have to hide the SRC numbers in the excel files? Those numbers can be obtained by anybody who wants to run the macro. But how can we know their actual numbers among many?
 
Villi,

My idea is if we can as a starting point get 01 + early 02 cases, it would be a good start.

So the 01 cases SRC numbers are approx from 01-125 to 02- 160.
==> about 300 days. Now how many "PENDING" 485 cases are in this range is anybodys guess !!. Now note I say pending because we can remove the "Approved" cases from our list. ( No use running the macro on these , it will just waste valuable attempts out of the 1000 max / IP.

The idea is to monitor the "DYNAMICS" not a %.

Also I agree the SRC numbers should not be masked out !
 
Advait

I just read Advait's latest post on another forum. He wants to keep the data private only for the contributors for some reasons.
I don't know whether we can make the file public when we work with them.

For our purpose to understand TSC, I would like to keep it open as the analysis needs as many brains as possible. However, if necessary, we can agree to publish only the statistics not the Excel files.

In the Excel files, there is a macro ModifiedScan, it does not scan the approved cases. However, for analysis, we should keep all these cases. It costs no time to run Excel with them in it.
 
vili,

>In the Excel files, there is a macro ModifiedScan, it does not scan the approved cases.
Can you post the Excel file that has the ModifiedScan macro? When I use the "I485Scan" macro, I end up with the "too much usage" error. ModifiedScan might avoid that problem and make things run faster.

BTW, I can provide SRC-02-039 (50000 to 53282).
 
Balajis

For some reason I cannot upload it right now. Can you go to the thread Order Pattern and download the file posted by Goastros ? I have been using that from Goastros. It is really good. ModifiedScan scans only non-approved I-485 cases and saves you a lot of time. Please post the result after you are done.

I am working on SRC01-135. Surprisingly, so many approved cases. I thought that TSC is focusing on 01 files right now but my preliminary result does not support that assumption as until now I see only one case approved in 03. I hope to see more.
 
More Volunteers Needed.

Here is the updated List:-->

SRC01-139 vzexemp
SRC01-156 vkalya
SRC01-246 ukr
SRC01-248 (AUG 20, 2001) vettipuls
SRC01-248 (AUG 20, 2001) goastros
SRC01-251 muse
SRC01-279 (Sep 27, 2001) eb2_I485_RD0901
SRC01-280 (Sep 28, 2001) eb2_I485_RD0901
SRC01-281 (Sep 29, 2001) eb2_I485_RD0901
SRC01-xxx (JUN 29, 2001) tscnd
SRC02-039 bajis
SRC02-096 (FEB 01, 2002) goastros
SRC02-135 SRC02-176 AND SRC01-135 vili
SRC02-160 Manolacho
SRC02-176 (May 17, 2002) goastros
 
my inputs

Data as of 15 July 2003 02034-52XXX (ND 10 Nov, 2001)

Approved Completed: 31

(4 approvals in 2003,
3/28, 4/2, 4/2 & 7/3;
all other approvals in
May/June/July/Aug 2002)

Resumed/FP Rcvd: 11
Transferred: 7
Received: 15
Miscellaneous: 2
RFE: 1 (4/28/2003)

Total Cases: 67


Been a passive participant on the TSC I485 Forum so far.
Used to be active on TSC I-140 forum.

--
RD 10/10/01
ND 11/10/01
FP 01/16/03
 
Last edited by a moderator:
Some more inputs

Data as of 15 July 2003 02034-51XXX (ND 10 Nov, 2001)

Approved Completed: 9 (2 approvals in 2003, 3/6, 5/22 ; all other approvals in Mar/Apr 2002)
Resumed/FP Rcvd: 8
Transferred: 2
Received: 12
Miscellaneous: 3

Total Cases: 34


Max'd out on # of inquiries for today.

Will try and run 02034-53xxx sometime later.

Hope these statistical data atleast provide some sort of consolation.

--
RD 10/10/01
ND 11/10/01
FP 01/16/03
 
Last edited by a moderator:
ModifiedScan

jaysee ,

R U using the modifiedScan Macro. It does not recheck approved cases ..this will increase the numbers you can scan.

See Villi's post in this thread.
 
Full Day data needed

I am glad that we have a lot of participant. If possible please run the whole day as full day data is needed for analysis. If you cannot run full day please let us know then somebody will take care about the rest.

Also if possible please post the Excel data sheet as well, so we can use as a common data source, and later on everybody can run ModifiedScan. If for some reasons, somebody has reservation with posting the Excel data sheets, then please post the statistics with the format on the thread "Order Pattern at TSC" then we can discuss.

I have completed today'quota of SRC01-135 ( correction SRC02-176 is the contribution of Goastros). I believe 1000 cases is the limit and don't want to be blocked by running more.

The result is wonderful: I will post the details and statistics when I have complete result for the whole day. However, if I take
current SRC01-135 as typical result for 2001 ( very rough) and SRC02-135 as typical result for 2002, there are few intesresting
conclusion I can draw.

I thought that RFE rate must be higher for 2001, but it is also 1% ( this rate is almost for all the data I have had and can be considered as typical RFE rate for TSC and for both 2001 and 2002).

The approval rate for SRC01-135 is 67% and only 13% remains as "Received" ( untouched).

Most of cases were approved between May-October 2002. Only two cases were approved in 2003 ( June 25 and March 10)
So, there is a "blank desert" between November 2002-March 2003 where TSC does not work much on I-485. Also, very little activities go on in 2003 irrespectively 2001 or 2002. I originally thought that TSC is focusing on 2001 now and the approval rate for 2001 should be higher.

My result is not complete as I don't have the full day data for SRC01-135. Don't take it to seriously. I just provide some preliminary informations to share and to inspire common thinking.
 
Modified MACRO

I am hoping somebody can post the modified macro.

As an intrim solution :
-save copy of sheet.
-Do Auto fillter.
-Select all aproved cases.
-Now you can delete them.
-Now the macro can be run.
-Note you can club various dates under the same sheet name (!)
because the Marco picks the complete SRC #.


If nobody posts it I will look at the marco and try to modify it tonight.
 
vili,

You said you have run the macro for 02-135.

Just wanted to know what range of #'s within 02-135 did you run ?

I ran the macro for 02-034-51xxx & 02-034-52xxx and posted the results. I might run for 02-034-50xxx & 53xxx. Are there any applns. with the last five digits beginning in 54/55/56 etc etc ?

Thx.
 
may

that looks most people are approved in the range u put in
is it the entire population for a day?
 
Status
Not open for further replies.
Top