Max/min In Data Spreadsheet Report?

[VONDY]

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?

[SABarber]

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

[VONDY]

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

[The Dude]

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.

[Sinned]

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.

[Sinned]

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?

[VONDY]

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

[Sinned]

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