Greenland Summary Report

[FunkyJunky]

A. Overall Goal of this thread:
To produce a Summary Greenland report once a week for the following LIN number ranges. The report will have stats and graphs so that we can judge some trends:
LIN02-075-5####
LIN02-100-5####
LIN02-125-5####
LIN02-150-5####
LIN02-175-5####
LIN02-200-5####

B. Purposes of this individual post:
To solicit help from you guys so that I can overcome the 1000 per day limit and produce the report sooner.

If you can help and know how to use the Greenland script, then do the following:

For each LIN02-xxx above, volunteer to scan one of the ranges of LIN numbers by posting a message in this thread, claiming a LIN02xxx and one of the following ranges:
50000 to 50999
51000 to 51999
52000 to 52999
53000 to 53999
54000 to 54999
55000 to 55999
56000 to 56999
57000 to 57999
I don't think there will be more than 56000, but we need to check.

Please note that I already have LIN02-100-##### populated.

Once you have scanned your range, post it here (Excel file)

I will then collect all the results and post the summary as soon as I have a comprehensive list.

[gheewalabhai888]

individuals to do this on a weekly basis(350-400 maximum per day scan limit), which I doubt can happen that easily. But this is a great idea. In a worst case even a partial post can tell us some trend...
Keep up the good work.

[orca]

FunkyJunky: Do you think it will be helpful if you include a percentage of approved and initially-adjudicated cases like the one I have done here?

[orca]

ND 12 March 2002

[orca]

ND 8 April 2002

[orca]

ND 19 April 2002

[chao chao]

Here's a list for ND200.

[chao chao]

Here's what I have and can post...

[FunkyJunky]

Great Work Chao Chao,

I have posted an updated summary report which includes your numbers. As you can see, I still have "holes" for 125 and 175 days.

I got kicked off the server today for too many queries, so I will have to continue tomorrow.

Thanks

[kjkool]

Hi,
In the stats sheet, the dates in row 4 show years as 01 in column E, 02 in column F, 04 in column H.
What does this mean? Were these scans conducted on these dates? or is this the ND with wrong year?

Thanks.

[FunkyJunky]

You have a point (I made an error by dragging Excel cells - Excel incremented them and I didn't notice)

I have repaired this in my template

[rumali09]

Dear Funky Junky,

Please run a report for the lin numbers
LIN 02 060 xxxxx
LIN 02 058 xxxxx

This is Dec 01 case.

Kindly revert.

Thanks

[FunkyJunky]

I can only run 1000 LIN #'s per day and I still have another 3 categories to run through. At 6 runs per day with 3 catagories, it means that I will only get to that in 18 days or so.

Send me your email address and I will send you a file you can run on your own. I will help you set it up and then maybe you can provide the Summary Report with feedback.

Thanks

[rumali09]

Funky Junky

Thanks

Please send the file to kals294@yahoo.com

Also please let me know if BCIS can find about running the report.

[Seth_Chamaklal]

Keep up the good work.

[chao chao]

I will check ND 130, 140, and 160 sometime this week and post the summary here.

Can you focus on the other dates?

[rumali09]

Funky Junky

Please help me running a report for

LIN 02 058 and LIN 02 060

I tired. The report ran and the XL sheet is blank

Please help

Thanks

[Pork Chop]

i have been scanning LINs 02-075 (ND Jan 2, 2002) and 02-119 (ND Feb 25, 2002). go ahead and include it in your summary report, which, btw, i think is quite cool.

[rumali09]

Hi Guys,

I am not able to get the results when I run the scan. The XL sheet is blank.

Please help. LIn 02 058 and LIN 02060

Thanks

[wizia]

Very Frastruating not to know anything form last 1.5 years..never updated my secondFP information

Please run as soon as possible

LIN-02-087-XXXXX

This Jan 11 the case

[chao chao]

                        ND130         ND140         ND150         ND160
----------------------------------------------------------------------------------
Approved              286(31.5%)    243(33.9%)      2( 0.5%)     11( 4.7%)
FP sent               132(14.6%)     87(12.2%)     79(22.1%)     38(16.3%)
Misc                   31( 3.4%)     57( 8.0%)     21( 5.9%)     31(13.3%)
Received              332(36.6%)    272(38.0%)    235(65.8%)    134(57.5%)
Resumed/FP recvd       72( 7.9%)     13( 1.8%)      6( 1.7%)      0( 0.0%)
RFE recvd              20( 2.2%)     17( 2.4%)      1( 0.3%)      2( 0.9%)
RFE sent               11( 1.1%)     21( 2.9%)      0( 0.0%)      0( 0.0%)
Transferred            23( 2.5%)      5( 0.7%)     13( 3.6%)     17( 7.3%)
----------------------------------------------------------------------------------
Total count           907           715           357           233

I used a partial list for ND150.

[march02485info]

=========> 02-142
Approved 230(32%)
FP sent 108(15%)
Misc 22( 3%)
Received 289(40%)
Resumed/FP recvd 14(2%)
RFE recvd 22(3%)
RFE sent 14(2%)
Transferred 22(3%)
===============================
Total 721

[FunkyJunky]

Ok Guys, here is an update.

You will notice that a lot of the numbers are old. The reason is that I am still populating numbers and not scanning new ones yet.

Thanks Pork Chop for the updated numbers. They are in the report.

ChaoChao, I have your numbers that you sent. I haven't been able to run them yet (1000 limit).

Thanks for the help guys.

[Pork Chop]

thanks for the summary report. like i said, it is really cool.

btw, just one correction: the ND for LIN 02-119 in your summary report is mentioned as Feb 22, 02. it should be Feb 25, 02.

thanks!

[wandergirlus]

FunckyJuncky, here is my 02-098 run. The case number only goes up to 55000. I spot check a few case number after that, they are all not existed. So I think they only received less than 5000 cases that day. I will run the update once a week and send the result to you. Now I am available to run some of yours so just let me know which date you want me to help with. It might take a while but I'll get it done. Thanks.

[chao chao]

Funky Junky,

Thank you for the updates.

I ran the script for ND170, 180, and 190 on Sep 6.
The dates for these NDs are Apr 26, May 8, and May 20.
I don't think I will check these dates periodically at least for now since there aren't many activities going on there.

The last summary post for ND130, 140, 150, and 160 were based on the result of run made on Sep 4. These are dates March 11, March 22, Apr 3, and Apr 15.

btw, can you set up an email account so that people can send result xls files to update summary report?

[FunkyJunky]

Another incremental update. Thanks chao , Pork and wandergirlus for the input.

Pork - I put together an Excel spreadsheet trying to calculate the LIN#'s vs. the RD but it seems that I don't have all the BCIS "down" days listed, so my estimate is off.

[FunkyJunky]

Ran an update for LIN-140.

I am having trouble getting a complete list for LIN-089 (I only have 63 valid numbers). Can anybody out there check and see if this is in fact a complete list? If you can help, please post a list of valid LIN numbers (for I485) here.

Thanks

PS. I fixed up some formula bugs I found in the previous summary report.

[FunkyJunky]

Updated a range of days. As expected, there is a lot more activity on the lower LIN's than the later ones.

[bootsncamo]

Hey guys ... here's my data for LIN 02-150 (April 3, 2002).
I checked LIN-02-150-5[0000..6000]; I last updated the categories on 9/8/03.