[Orca-users] Charting Procallator Collected data

[csarid]

Folks,
   
  Thanks very much for all the help thus far. This is giving me some really good ideas and options.
   
  Thanks again!
   
  ====

"Cockcroft, Adrian" <acockcroft at ebay.com> wrote:
        v\:* {behavior:url(#default#VML);}  o\:* {behavior:url(#default#VML);}  w\:* {behavior:url(#default#VML);}  .shape {behavior:url(#default#VML);}                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:
    
   Concatenate all interesting files into one large file, and give it a .tsv extension   
   Open the file in Excel.  You'll be prompted by the Text Import Wizard   
   1st step of the Wizard: declare the data to be delimited (versus fixed-width).  Click Next.  
   2nd step:  define the delimiter as Tab (or whatever your delimiting character actually is/are, if different).  Click Next.  
   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 and 
always stay connected to friends. 

    
---------------------------------
    

 

_______________________________________________

Orca-users mailing list

Orca-users at orcaware.com

http://www.orcaware.com/mailman/listinfo/orca-users

  
   



 
---------------------------------
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/orca-users/attachments/20070126/48be50c9/attachment-0002.html>