Max/min In Data Spreadsheet Report?

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

  • Max/min In Data Spreadsheet Report?

    I Would Like To Have Max & Min Included When I Use And Export The Spreadsheet Report. Can This Be Added And Where Would I Go To Do This If I Can?
    sigpic

    B&S ADVANTAGE 12-22-10, EXCEL 9-15-9, ETC.
    PCDMIS 4.1, 3.5mr2,

  • #2
    This is not possible. The spreadsheet report displays the values (Nom/Up/Low/Measured) of each transaction. Where would the max/min go?

    Comment


    • #3
      Originally posted by SABarber View Post
      This is not possible. The spreadsheet report displays the values (Nom/Up/Low/Measured) of each transaction. Where would the max/min go?
      In my spreadsheet report, I have the part, date,time variable, nom, up, low, meas., stats cout, tracefield(s), and maybe more that I am just not seeing in this particular report. This data is all pulled from my program report somehow. I guess I was just asking if there is a checkbox somewhere that I can choose that will show the max.min. as well. It just seemed logical that anything that is selected in the 'format/text' options would be available in the spreadsheet report. I will be asking software support to add this as I think it is something I would like to see when I do my spreadsheet. Thanks for your help
      sigpic

      B&S ADVANTAGE 12-22-10, EXCEL 9-15-9, ETC.
      PCDMIS 4.1, 3.5mr2,

      Comment


      • #4
        Re: Max/Min

        You can get Datapage to report the Max/Min, but, you must make the Max and the Min basically their own seperate entity. If you assign a variable to the max and to the min, and then create a generic feature using those 2 variables, you can report the max and the min as a dimension unto itself. There may be an easier way, but this is what I have done in the past.
        sigpic

        Comment


        • #5
          Spreadsheets basically reprot each seperate run for each seperate variable. The best way to do this would be to turn on Upper Deviation and Lower Deviation in a Statistical Report.
          sigpic
          If A Pretty Poster And A Cute Saying Are All It Takes To Motivate You,
          You Probably Have A Very Easy Job. The Kind Robots Will Be Doing Soon.

          Comment


          • #6
            I know it's been awhile since you posted this, but were you looking for a max/min of a feature set (scan, etc..) or between runs?
            Last edited by Sinned; 07-14-2008, 11:17 PM.
            sigpic
            If A Pretty Poster And A Cute Saying Are All It Takes To Motivate You,
            You Probably Have A Very Easy Job. The Kind Robots Will Be Doing Soon.

            Comment


            • #7
              Scans, Perpendicularity, parallelism, ......................
              Anything that would have a high and low range.
              Seems like it would be an easy optional add on for Datapage to include.
              Thanks
              sigpic

              B&S ADVANTAGE 12-22-10, EXCEL 9-15-9, ETC.
              PCDMIS 4.1, 3.5mr2,

              Comment


              • #8
                Well then, my sugestion is to do what The Dude said. I if you do a textual analysis in PC-DMIS it will report it out for you, but not send it to Datapage. Here is some code that follows The Dude's suggestion, where x will equal your max, and y your min.
                Code:
                PRO        =FEAT/SCAN,LINEARCLOSE,SHOWHITS=NO,SHOWALLPARAMS=NO
                            MEAS/SCAN
                            BASICSCAN/LINE,SHOWHITS=NO,SHOWALLPARAMS=NO
                            ENDSCAN
                            ENDMEAS/
                DIM PROFILE
                AX   NOMINAL     MEAS       +TOL       -TOL        DEV      OUTTOL   
                M      0.0000     0.0029     0.0040     0.0020     0.0029     0.0000 -#-------
                PRO MAX/MIN=GENERIC/POINT,DEPENDENT,RECT,$
                            NOM/XYZ,PROFILE.MAX,PROFILE.MIN,0,$
                            MEAS/XYZ,0,0,0,$
                            NOM/IJK,0,0,1,$
                            MEAS/IJK,0,0,1
                DIM MAX/MIN 
                AX   NOMINAL     MEAS       +TOL       -TOL        DEV      OUTTOL   
                X      0.0018     0.0000     0.0040     0.0020    -0.0018     0.0000 #--------
                Y     -0.0011     0.0000     0.0040     0.0020     0.0011     0.0000 ----#----
                            END OF DIMENSION MAX/MIN
                sigpic
                If A Pretty Poster And A Cute Saying Are All It Takes To Motivate You,
                You Probably Have A Very Easy Job. The Kind Robots Will Be Doing Soon.

                Comment

                Related Topics

                Collapse

                Working...
                X