- Home
- Forums
- Immigrant Visas (Green Cards)
- I-485 Issues
- I-485 Issues Common to All Services Centers
- General I-485 and Related Issues
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Data Consolidation Project February Thread
- Thread starter goastros
- Start date
Matrixone123
Registered Users (C)
SRC-02-025
Ran the script yesterday from 5600 to 5700.
Enclosed please find the results.
Matrix
Ran the script yesterday from 5600 to 5700.
Enclosed please find the results.
Matrix
Re: No I-485 Receipt Dates.
GcCare, we were discussing abt this.
PatiencelessTx & pradha usually keep the information in 'I' & 'J' column.
The problem is if it is a completely new sheet like for eg - 01/08/2001, we don't know if anyone ever tried to scan it.
It has also been found there are certain dates where no data was found.
for eg - patiencelessTX has posted a empty sheet 01-189 and left information as to what ranges he has scanned.
Picsarus has suggested we also include such empty sheets in the Summary sheets so that anyone who sees the summary sheet will know that someone attempted to find 01-189.
What does everyone think of that ?
Or shd we create a new sheet (at the end after Members) where all such info is stored, so anyone who starts a new sheet reads
that before he/she starts a scan?
Originally posted by GCcare
Hi Gastros,
as one of members request, I tried to scan Aug01/01, and there were no I-485 Application in the range 50000-51034. If there were any such dates, could you publish them.
GcCare, we were discussing abt this.
PatiencelessTx & pradha usually keep the information in 'I' & 'J' column.
The problem is if it is a completely new sheet like for eg - 01/08/2001, we don't know if anyone ever tried to scan it.
It has also been found there are certain dates where no data was found.
for eg - patiencelessTX has posted a empty sheet 01-189 and left information as to what ranges he has scanned.
Picsarus has suggested we also include such empty sheets in the Summary sheets so that anyone who sees the summary sheet will know that someone attempted to find 01-189.
What does everyone think of that ?
Or shd we create a new sheet (at the end after Members) where all such info is stored, so anyone who starts a new sheet reads
that before he/she starts a scan?
Re: Dec01_Jan02
rr_67,
How do you add this sheet to the consolidated file??
Last time I randomly checked and as they were only rescan I just skipped and next rescan probably took care of all those.
If some one has to replace the consolidated sheet he has to be doubly sure and , hence has to check one by one each sheet and that takes considerable amount of time and effort and in the end there is a potential for mistake.
I suggest,
If it is a rescan please do that on the consildated sheet.
If it is a new sheet either add it to the consolidated sheet or post only that perticular sheet, so that the next person can blindly pick and add.
Just my views ....
as one of members request, I tried to scan Aug01/01, and there were no I-485 Application in the range 50000-51034. If there were any such dates, could you publish them.
I am in favour of leaving those sheets in consolidated file once some one scans some range, irrespective of you find 485 cases or not , wiith some history of what you have already done.
I keep the start/ End scanned in Column I/J some where from row 2 down.
patiencelessTx I think cuts and pastes the finishing message at end of scan to same place.
Either way it gives what is already done.
There is little problem to add the sheets in summary if you have no 485s found. The total column will show as 0, and the percentage will get a devide by zero and show some #err message.
One way is just leave a SRC0 in cell A2. But that will add one dummy to total column for every sheet of that nature. It may not really matter for statistical purpose. I did some time back for one sheet that way.
However my vote is just keep the sheet and not in summary.
As there are few people showing interest in getting some more data let me put the sheets I have partially worked on just to avoid duplication
SRC02-026
SRC02-028
SRC02-033
SRC02-116 Apears to be totally blank
SRC02-117
SRC02-127
SRC02-129
SRC02-136
SRC02-137
--pr
Originally posted by RR_67
Please add this to the Consolidated file
rr_67,
How do you add this sheet to the consolidated file??
Last time I randomly checked and as they were only rescan I just skipped and next rescan probably took care of all those.
If some one has to replace the consolidated sheet he has to be doubly sure and , hence has to check one by one each sheet and that takes considerable amount of time and effort and in the end there is a potential for mistake.
I suggest,
If it is a rescan please do that on the consildated sheet.
If it is a new sheet either add it to the consolidated sheet or post only that perticular sheet, so that the next person can blindly pick and add.
Just my views ....
as one of members request, I tried to scan Aug01/01, and there were no I-485 Application in the range 50000-51034. If there were any such dates, could you publish them.
I am in favour of leaving those sheets in consolidated file once some one scans some range, irrespective of you find 485 cases or not , wiith some history of what you have already done.
I keep the start/ End scanned in Column I/J some where from row 2 down.
patiencelessTx I think cuts and pastes the finishing message at end of scan to same place.
Either way it gives what is already done.
There is little problem to add the sheets in summary if you have no 485s found. The total column will show as 0, and the percentage will get a devide by zero and show some #err message.
One way is just leave a SRC0 in cell A2. But that will add one dummy to total column for every sheet of that nature. It may not really matter for statistical purpose. I did some time back for one sheet that way.
However my vote is just keep the sheet and not in summary.
As there are few people showing interest in getting some more data let me put the sheets I have partially worked on just to avoid duplication
SRC02-026
SRC02-028
SRC02-033
SRC02-116 Apears to be totally blank
SRC02-117
SRC02-127
SRC02-129
SRC02-136
SRC02-137
--pr
Last edited by a moderator:
Re: scanned
tombaan, I didn't follow if you see the file you have attached, it is not scanned upto 01-201 for yesterday or today's date.
Did you put it a wrong attachement ?
Originally posted by tombaan
from beggining upto 201
tombaan, I didn't follow if you see the file you have attached, it is not scanned upto 01-201 for yesterday or today's date.
Did you put it a wrong attachement ?
Originally posted by dfkj45
Goastros,
What is the total 40539 means? the total of all or the total of pending 485 up to RD scanned to-date?
That is total no of 485 SRCs that we have collected.
Originally posted by xjb
I just scaned SCR02130 page.
Can you please post the excel file then?
Re: Oops...
Hi rr_67,
If it sounded like instructions I apologize for the tone. Last time I made post after your's. I just checked randomly and skipped your file as I thought little nervous to replace the sheets in the consolidated sheet, though I felt bad after you have scanned a range. Of course it will be covered in next rescan, but if you add some data in between we will simply miss it. My intention was only to bring it to your notice when I saw the file.
--pr
Originally posted by RR_67
I am sorry. I thought it would be easy to consolidate the individual files with the multi scans, if I upload the worksheets, I scanned on that day.
I will follow your instructions.
Thanks,
- RR
Hi rr_67,
If it sounded like instructions I apologize for the tone. Last time I made post after your's. I just checked randomly and skipped your file as I thought little nervous to replace the sheets in the consolidated sheet, though I felt bad after you have scanned a range. Of course it will be covered in next rescan, but if you add some data in between we will simply miss it. My intention was only to bring it to your notice when I saw the file.
--pr