[Orca-users] Charting Procallator Collected data

[Tankersley, Jon]

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
	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/a0530122/attachment.html>