8 Replies Latest reply on Apr 21, 2008 1:43 PM by 1-5YT7VZ

Dealing with data

1-5YT7VZ Mar 24, 2008 6:50 PM

Hello all,

I was hoping that someone out there has come up with a simple way to plot data from several batch runs on to one graph. I have 3 main variables, flow, torque and rpm. To get a useful graph I set one at a constant and need to plot the other two. Is there a simple way to do this short of entering the points by hand?

Thanks up front.

Bill

Dealing with data

Basil Gello Mar 24, 2008 9:39 PM (in response to 1-5YT7VZ)

Bill,
try exporting goals to Excel, then, if you have created several workbooks, copy & paste the worksheets to the resulting one and plot the graph. Or, write a macro that should do this concatenation automatically.

Regards, Basil
Like Show 0 Likes(0)

Actions
- Dealing with data
  
  Rich Bayless Mar 26, 2008 8:01 PM (in response to Basil Gello)
  
  HI Bill,
  
  have you tried 'Floworks,Tools,Parametric Study'? I've seen it, but haven't tried running with it yet.
  
  Rich.
  
  Like Show 0 Likes(0)
  
  Actions
  - Dealing with data
    
    1-5YT7VZ Apr 14, 2008 8:42 PM (in response to Rich Bayless)
    
    Rich,
    Thanks for the idea, unfortunately the "Parametric Study" option is somewhat limited. RPM is not a variable that can be used. It does not solve for the greatest value. For it to solve the values must be a curve or line that is always in creasing or always decreasing. My plots are more of a bell curve and because the limits are lower values it can't find convergence. It can not find a value of 5 if the first end is 1 and the other end is 2. If that makes sense? Still looking at a better way. I am looking into writing a macro and such to do it.
    
    Like Show 0 Likes(0)
    
    Actions
    - Dealing with data
      
      1-5YT7VZ Apr 17, 2008 2:00 PM (in response to 1-5YT7VZ)
      
      Has anyone else worked on this? If I write something, any one interested? Any suggestions?
      
      Like Show 0 Likes(0)
      
      Actions
      - Dealing with data
        
        Basil Gello Apr 18, 2008 5:12 AM (in response to 1-5YT7VZ)
        
        Bill,
        yes we are interested...but have you written for example a postprocessor?
        Regards, Basil
        
        Like Show 0 Likes(0)
        
        Actions
        
        Dealing with data
        
        1-5YT7VZ Apr 18, 2008 12:19 PM (in response to Basil Gello)
        
        I have edited a few for CNC machines postprocessors and such. I am not sure what you are asking?
        
        Bill
        Kf6SYH@yahoo.com
        
        Like Show 0 Likes(0)
        
        Actions
        
        Dealing with data
        
        Basil Gello Apr 19, 2008 7:14 AM (in response to 1-5YT7VZ)
        
        Bill,
        
        I have meant just a postprocessor for COSMOS multiple runs' results...
        
        Regards,Basil
        
        Like Show 0 Likes(0)
        
        Actions
        
        Dealing with data
        
        1-5YT7VZ Apr 21, 2008 1:43 PM (in response to Basil Gello)
        
        Rich,
        I was going to attack it as after the batch run processing. Set up a program that pulls the data from pre determined boxes from the excel file and merge them into a single excel file.
        
        Bill
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post