[Orca-users] Charting Procallator Collected data

[Cockcroft, Adrian]

The format always used to be whitespace separated, so click the multiple
option as well as the spaces as delimeter.

 

I used to import the daily files into Excel quite often.

 

Adrian

 

________________________________

From: orca-users-bounces+acockcroft=ebay.com at orcaware.com
[mailto:orca-users-bounces+acockcroft=ebay.com at orcaware.com] On Behalf
Of David Michaels
Sent: Friday, January 26, 2007 8:57 AM
To: csarid
Cc: orca-users at orcaware.com
Subject: Re: [Orca-users] Charting Procallator Collected data

 

Importing procollator data into Excel should be pretty straight-forward.
The columns are tab-delimited, I think.

I have a procedure by which I bring orcallator files into Excel.  I
can't imagine procollator files being much different.  It goes sort of
like this:

1.	Concatenate all interesting files into one large file, and give
it a .tsv extension
2.	Open the file in Excel.  You'll be prompted by the Text Import
Wizard
3.	1st step of the Wizard: declare the data to be delimited (versus
fixed-width).  Click Next.
4.	2nd step:  define the delimiter as Tab (or whatever your
delimiting character actually is/are, if different).  Click Next.
5.	3rd step:  optionally identify columns that you don't want to
import (this can be handy if the file is very big).  You can also define
data types for your columns.  "General" is fine for all of them, though
you may wish to make the first column of the Date type.  I usually do
this after the file has been loaded, by selecting the column and going
to Format -> Cells, and defining it as the Date type with the default
format (in the file, it's in seconds since the epoch, I think, but Excel
figures it out).

--Dragon


csarid wrote: 

Hello Everyone,

 

 

I am looking for information on using collected procallator data in
excel for charting. Has anyone tried this? and if so, can you please
provide any information or point me to a site that may have this info. 

 

Thanks Very much!

________________________________

Don't be flakey. Get Yahoo! Mail for Mobile
<http://us.rd.yahoo.com/evt=43909/*http:/mobile.yahoo.com/mail>  and 
always stay connected
<http://us.rd.yahoo.com/evt=43909/*http:/mobile.yahoo.com/mail>  to
friends. 

 



________________________________



 
_______________________________________________
Orca-users mailing list
Orca-users at orcaware.com
http://www.orcaware.com/mailman/listinfo/orca-users
  

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/orca-users/attachments/20070126/dc75a18d/attachment-0002.html>