hexagon logo

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?
  • This is not possible. The spreadsheet report displays the values (Nom/Up/Low/Measured) of each transaction. Where would the max/min go?
  • 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
  • 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.
  • 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.
  • 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?
  • 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
  • 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.
    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