[Orca-users] Charting Procallator Collected data
jon.tankersley at eds.com
Fri Jan 26 11:35:11 PST 2007
Biggest problem we see is the limitations of Excel with regards to
columns and/or rows.
We've got some scripts that will strip out pertinent columns into a new
file - and with some perl modules, write an excel file.
From: orca-users-bounces+jon.tankersley=eds.com at orcaware.com
[mailto:orca-users-bounces+jon.tankersley=eds.com at orcaware.com] On
Behalf Of David Michaels
Sent: Friday, January 26, 2007 10:57 AM
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
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
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).
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
always stay connected
Orca-users mailing list
Orca-users at orcaware.com
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Orca-users