PDA

View Full Version : Max/min In Data Spreadsheet Report?


VONDY
05-01-2008, 01:34 PM
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
05-01-2008, 05:13 PM
This is not possible. The spreadsheet report displays the values (Nom/Up/Low/Measured) of each transaction. Where would the max/min go?

VONDY
05-05-2008, 07:12 AM
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
06-04-2008, 04:29 PM
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
07-11-2008, 09:30 PM
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
07-11-2008, 09:34 PM
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
07-14-2008, 06:08 AM
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
07-14-2008, 11:44 PM
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