[Orca-users] Charting Procallator Collected data

[Cockcroft, Adrian]

If you are trying to handle large amounts of data, the free stats
package "R" works very well. Easy data import and graphing that you can
play with and script. I've been discussing it on my blog
http://perfcap.blogspot.com/2006/11/cockcroft-headroom-plot-part-1.html
and I've got some more advanced scripts now that I need to get around to
writing up on the blog....

 

Adrian

 

________________________________

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

 

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