DataPage sort?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • DataPage sort?

    Does anyone know if there is a way to get DP to print charts with measurement readings above or below a certain value? I am running several hundred parts on a short pc-dmis prog to sort for accept/reject. I need to print histograms of each catagory so we know what we are sending to the customer and how we might salvage the 'rejects.' The only way that comes to mind is to print a run chart by stat-count, then tag each transaction according to which side of the spec limit it's on.

    Any suggestions greatly appreciated.
    v2013 MR1, v2015.1
    B&S Global 544, 555
    Mitutoyo A504 w/PC-DMIS

    sigpic
    Since 1994

    Never force anything. Get a bigger hammer.
    (Advice from my dad.)

  • #2
    Not sure if this applies but I would try putting a TRACE value in the PCDMIS part program and set this value based on the measurement ("1" for above, "-1" for below, "0" for just right). You can then sort (or just choose) based on this TRACE value.

    Comment


    • #3
      Sounds like a good feature to have in the prog before running 1400 parts. Something to remember for next time.

      Thanks.
      v2013 MR1, v2015.1
      B&S Global 544, 555
      Mitutoyo A504 w/PC-DMIS

      sigpic
      Since 1994

      Never force anything. Get a bigger hammer.
      (Advice from my dad.)

      Comment


      • #4
        Spread Sheet Report

        Do a spread sheet Report.
        File>Save to>Save Current Report> (text file)
        I have my text file set up to be coma seperated.
        Then I open excel
        Data>import>Import external data
        click on file name
        after import click on column Header line
        Data>filter>auto filter
        click on drop down arrow for measured and click on up arrow to sort descending or sort ascending.

        This puts parts in order.
        I have a trace fields are also visable.
        2014 SP5, DataPage + v5.0 #331
        [testing v2015.1]

        Comment


        • #5
          Thanks, Dave. After some trial & error, I got it to work.
          v2013 MR1, v2015.1
          B&S Global 544, 555
          Mitutoyo A504 w/PC-DMIS

          sigpic
          Since 1994

          Never force anything. Get a bigger hammer.
          (Advice from my dad.)

          Comment


          • #6
            Have you looked into queries? I was told by someone at Wilcox that you can sort the data any way you want with them. I haven't tried it yet but it looks like you can do what you're looking for.

            Comment


            • #7
              The queries are based on the TRACE values.

              Comment


              • #8
                Guess I was told wrong. Nevermind.

                Comment

                Related Topics

                Collapse

                Working...
                X