CSC & project Kashmir
Guys,
Check
http://immigrationportal.com/showthread.php?s=&threadid=78398&perpage=15&pagenumber=1
The CSC folks started on this 'project kashmir' in April and are doing similar collection of data & its analysis.
This thread is though 57 pages long & growing.
The Awesome Guy behind this ,
Kashmir has writen Java programs .
We could use some of his ideas here.
If anyone else can read thru that thread and suggest some ideas?
Kashmir's process -
1st step -
java program Kashmir3.java to collect SRC numbers & the statuses.
2nd step
Java program kashmir2.java to compute the statistics.
code:-
-------------------------------------------------------------------------------
% wc -l wac02046-i485.txt
513 wac02046-i485.txt
% cat wac02046-i485.txt | java -jar kashmir1.zip > wac02046-i485-raw-20030406.tsv
% cat wac02046-i485-raw-20030406.tsv | java -jar kashmir2.zip
Approved/Completed ... 224 (44%)
Transferred .......... 36 ( 7%)
RFE Received ......... 32 ( 6%)
RFE Sent ............. 9 ( 2%)
Resumed/FP Received .. 140 (27%)
FP Sent .............. 8 ( 2%)
Received ............. 53 (10%)
Denied/Withdrawn ..... 4 ( 1%)
Misc ................. 7 ( 1%)
Total ................ 513
Now we are already having the Excel Macros - 1485Scan & Makechart do these 2 steps.
Kashmir's output is in a text format whereas the we have similar data in excel. Do we prefer to have the output in text format, so further analysis or storing in a particular output becomes easier?
what do rest fo you guys suggest?