Data Consolidation Project (Thread #7)

Status
Not open for further replies.
G

goastros

Registered Users (C)
INSTRUCTIONS TO RUN THE EXCEL MACRO

These are Instructions to run the macro for the 1st Time to scan a New SRC Range

1> Download the attached Excel file.

2> Open this file and check if there is a Worksheet with the name
of the dates you want to check.
for eg - if you are searching for SRC01-170, look for a
Worksheet with the name SRC01-170.
If you find one, simply rename it to maintain that data in case
needed in the future.
Then, run the macro.

3> Before you run the macro check the security level of your Excel
file.
Security Level tab is found at (Tools menu, Macro
submenu, Security command).
The level cannot be at High, it should be changed to Medium
or Low.
Now you are ready to run the macro.

4> To run the macro you have to go to the menu at the top of the
screen and look for Tools,
then look for the submenu Macro and then Macros.
It will pop up a box titled Macro.
You can see 4 Macros listed (I485Scan, MakeChart, MultiScan & Sort485).
Select I485Scan[\B] and hit the Run button at the
right.
Another box will pop up titled Excel.
There, you have to enter the first five digits corresponding to
the SRC range you want
to check.
for eg - 01-001 and press OK.
Another box will pup up and enter the range of the last five
digits to check.
Start from 50000 to 51000 and go all the way to 56000.
Note - at a time, you can only scan for 1000 cases from the
same IP address before
'We are sorry' message. After that you have to change
your IP or wait for 24 hours
before you can scan again.
Important Note - When you try to scan more than
3 invalid SRCs, you get blocked as well.
So be wise in choosing the right range of SRC numbers.

5> The macro will run and will show the results found.
It will create a excel sheet with SRC and write down only the
485 cases.

6> If you want, you can also run the second macro (MakeChart)
to obtain a summary and chart of the results gathered.

7> After your 1st run is complete, for next set of 1000 nos,
rename the excel sheet by clicking on the excel tab. Then
repeat step 4>.
After this scan is over combine the 2 results.
Repeat this until you have exhausted finding the date range
or you feel exhausted..

And don't forget to post your results here or add to the consolidated file.
 
INSTRUCTIONS TO RESCAN

These are Instructions to rescan multiple sheets

1> Download the attached Zipped file & Unzip it to a Excel file.

2> Before you run the macro check the security level of your Excel
file.
Security Level tab is found at (Tools menu, Macro
submenu, Security command).
The level cannot be at High, it should be changed to Medium
or Low.
Now you are ready to run the macro.

3> To run the macro you have to go to the menu at the top of the
screen and look for Tools,
then look for the submenu Macro and then Macros.
It will pop up a box titled Macro.
You can see 4 Macros listed (I485Scan, MakeChart, MultiScan & Sort485).
Select MultiScan[\B] and hit the Run button at the
right.
Another box will pop up titled Excel.

After that it is very easy, give the range of sheets to be scanned in the following format YYDDD-YYDDD.

4> The macro will suspend calculations to the summary sheet, do the scan until it reaches a count of 990 and then stop, calculate the summary sheet.

5> Rename the file to the next version number and then zip and post the file here.
 
SRC02-001

I have scanned from 50000 to 55250 for SRC02-001 and would post the results once I run them thro' latest rescan macros.

Here is the summary for the range 50000-55250:

total 485 cases : 353
Approved/Completed : 166
denied/withdrawn : 2
RFE received : 2
RFE sent : 4
Transferred : 18 (1 to Dallas, 2 to San Antonio and rest to Miami)
Resumed/FP recvd : 80
FP sent : 8
Received : 60
Misc : 13

Could someone scan from 55250 to 59999 to make SRC02-001 scanning complete ?

-- rbls5
 
Re: SRC02-001

Originally posted by rbls5
I have scanned from 50000 to 55250 for SRC02-001 and would post the results once I run them thro' latest rescan macros.

Could someone scan from 55250 to 59999 to make SRC02-001 scanning complete ?

-- rbls5
Click to expand...

rbls5, thanks for scanning for Src02-001. Usually many of us have observed after 55999, we start getting Invalid numbers, making us believe that SRc range for that particular date has exhausted.
Though there are certain dates esp in May-Sep 01 range which have nos beyond 56000.
So my point being you might have scanned & collected the entire Data for SRC02-001.
 
ver 96.0

Here is the next version.
I have scanned upto SRC02-123. Next person can take it from there or Also the range from 01-251 onwards has not been scanned in 1 week.
I have added some more numbers in SRC-01-172.
171 approvals for Dec 03 so far.
Some approvals seen as late as on 29th Dec.
 
version 97

I have scanned upto 02-175, next person can start from 02-176. Approvals for Dec is 177
 
completed upto src02-182

next person take it from there. or i can do it tomorrow;) approval still is 177
 
Could some one please scan the SRC 030305XXX and add it to the consolidation file.

Thanks,
HDBoy
 
Could some one please scan the SRC 030305XXX and add it to the consolidation file.

Thanks,
HDBoy
 
Because I was bored, I started to scan the day before my date (src01-231). I'll post the results of src01-230 (July 30th) when complete, but i did notice 1 approval and 1 RFE dated 30-Decemeber-2003!
 
HDBOY

self help is the best way. People here are all doing it out of their time and if you want any date added please go ahead and do it:eek:
 
I deligently followed the instruction posted in the beginning. I'm repeatedly getting the following message.

" Macros in this workbook are disabled because the security level is high, and the macros have not been digitally signed or verified as safe. To run the macros, you can either have them signed or change your security level. Click Help for more information"

To my disbelief, I found that the security level is "Medium". Even after changing it to "Low". I'm still getting the above mentioned message.
I would appreciate if some one help me or scan SRC 03030-5XXXX.

Thanks,
HDBoy
 
tried scanning 02-158

Hi guys,

This is my first try at scanning. I have scanned the SRC 02-158 range. Could someone please consolidate the data. Could manage doing it till here.

Thanks
 
HDBoy,


A wild shot ....


Is there another id you can sign on to your pc with more privilege ( like local admin) or you are the only userid

What is the next tab in security trusted sources show , Mine shows trust all installed add_ins and templates ticked and the other not ticked

---pr
 
new scan for 02114

not much activity here.
Next person, please add it to consolidated file. I don't want to mess it up.
thanks,
 
ver 99.0

Next version -
+ Added Tirednconfused's data for SRC02-158
+ Added Dvorak's data for SRC02-114
+ Started ReScan ( it was my attempt to see if TSC has started working/approving again in the new year).
Whoever finds the 1st approval for 2004 gets a shinny quarter ( send postage)..:D
Next person take it from SRC01-248.
 
approval spoted for 28th Aug-01

One case is approved on 5th January 04. receipt date 28th August. this case was Fp'ed in Oct 03.

Hope to see more and more for the coming days.
 
no approvals in src02158

No approvals in SRC02158. Looks like they havent started work in the new year. Must be a new year resolution.

:(
 
Status
Not open for further replies.
Top