iSixSigma

Graphs

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #30396

    Lisa
    Participant

    I have been trying to find a way to make a graph that looks like a speedometer, with an arrow that points to current measurement, the “speedometer” numbers in various colors to allow to see danger ranges and target areas. Does anyone know of a program that lets you do that?
    thanks

    0
    #79153

    Robert Butler
    Participant

      I don’t know of any plotting routines that would do this.  However, I would like to offer the following thoughts concerning such an effort. 
      Giving people a sense of where they are at some particular moment is laudable, however, just knowing where you are and not knowing where you have been or where you might be going is the woodsman’s definition of being lost.  As you described it, this is exactly what your speedometer will do-location without any sense of direction. 
      A much better approach would be a time plot (not a control chart-just a time sequence plot) of the measurements over time.  The chart can have colored bands corresponding to excellent, good, indifferent, poor, and unacceptable regions.  By providing a snapshot of the process for say 3 months you will have all of the visual interest of a speedometer along with the visual value of a map.
      If the measurements are too frequent so that a point-by-point plot will resemble nothing more than a busy squiggle, try grouping the data on some convenient basis such as hour, day, week, etc. and represent it as a series of time sequenced box-plots. 
      By putting the current measurements in this context you will have a much more meaningful graphic which will help promote independent thinking about your process. 
      If you wish to consider meaningful ways of representing your process you might want to read the three books by Tufte – The Visual Display of Quantitative Information, Visual Explanations, and Envisioning Information.  They are very readable and all three are packed with example after visual example of ways to present your data.

    0
    #79159

    me
    Participant

    I could make you one pretty quick if you would like?  let me know what the alarm points are and what you want to call them.  As an example ” Make a gage from 25 to 100.  At 75 say check set up and at 90 say Defect”
     

    0
    #79165

    Speedo
    Member

    I think its a great idea – add a clock with date/time to your dashboard…add a control below that that looks a like a break pedal that when pressed increments the date/time to display historical data…and a gas pedal to display ‘predicted’ data based on historical trends.
    If everyone that had an idea was so quickly dismissed we’d still be in caves….keep up the brainstorming…its an element of problem solving that requires a certain part of the brain that a whole lotta folks forget to use.

    0
    #79167

    Ovidiu Contras
    Participant

    You might want to try http://www.globalmajic.com / Samples / ActiveX Samples .
    Hope this helps

    0
    #79180

    Mike Carnell
    Participant

    Lisa,
    Try a website at http://www.MarkwoodTech.net. There are several dashboards shown as examples. I don’t know he specifically has a speedometer but he does a lot of the custom dashboard work.
    Good luck.

    0
    #79182

    Mike Carnell
    Participant

    Robert,
    In general I would agree with the need for the additional data. In a lot of cases dash boards are generated for a single point in time for a manager that simply wants to know the sky isn’t falling and if they need to switch a priority. In many cases like this it is probably better if they don’t have a lot of information (then they don’t try to help whoever is mangeing an operation or trouble shooting a problem).
    The appropriate graph is really more application specific and without knowing the application it is a tough call.

    0
    #79214

    Speedo
    Member

    SPC/DMS software from http://www.hertzler.com is a very well rounded app for both manual and automated (file read, gageport, odbc, rs232, etc) data collection and most charting & reporting that is needed. Developed in the ’80’s for Motorola the vendor suprisingly doesn’t do much advertising but has a real good traceability ‘drill-down’ feature that I haven’t seen in any other app and which is extremely useful to analysis of possible causes. No speedometers, but they offer-up their API for customezing to meet your needs.

    0
    #79224

    abasu
    Participant

    You can do this in Excel.  As a starting point refer to Excel 2002 formulas by John Walkenbach (pg 482).  You can also refer to his website http://www.j-walk.com/ss/
    ps.
     

    0
Viewing 9 posts - 1 through 9 (of 9 total)

The forum ‘General’ is closed to new topics and replies.