Excel Form Report and Looping

S_Cliff

see attached.

I got it to work but the first dimension repeats to the 2nd. If i run 6, I get 5 total parts measured, with 1 and 2 being the same result. any idea why?

S_Cliff

see attached.

I got it to work but the first dimension repeats to the 2nd. If i run 6, I get 5 total parts measured, with 1 and 2 being the same result. any idea why?

I'd have to see your code. Here's an example of mine that works.

manual alignment

LOOP1 =LOOP/START,ID=NO,NUMBER=99,START=1,SKIP=,
OFFSET:XAXIS=0,YAXIS=0,ZAXIS=0,ANGLE=0
PRINT/REPORT,EXEC MODE=END,$
TO_FILE=OFF,AUTO=1,AUTO OPEN=OFF,$
TO_PRINTER=OFF,COPIES=1,$
TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
REPORT_THEORETICALS=NONE,REPORT_FEATURE_WITH_DIMENSIONS=NO,$
TO_EXCEL=OFF,$
PREVIOUS_RUNS=DELETE_INSTANCES

program: DCC alignment, features, & dimensions

EXCEL_FORM1 =EXCELFORMREPORT/TEMPLATE=Large Chassis Template, TYPE=XLSX
RESULT FOLDER/C:\PC_DMIS Search Path\Reports\Excel Reports
LOOP/END

-Header stuff
-Manual alignment
-Various Tracefields for details on form

=LOOP/START,ID=NO,NUMBER=V2,START=1,SKIP=,
OFFSET:XAXIS=0,YAXIS=0,ZAXIS=0,ANGLE=0
MODE/DCC
COMMENT/OPER,NO,FULL SCREEN=YES,AUTO-CONTINUE=NO,
PRESS OK WHEN SAFE TO INITIATE
CLEARP/ZPLUS,12.7,ZPLUS,0,ON
MOVE/CLEARPLANE

-Dcc Alignment, measure features

PLN_FLAT_SURFACE =FEAT/PLANE,CARTESIAN,TRIANGLE,NO,LEAST_SQR
THEO/<20.934,57.363,0>,<0,0,1>
ACTL/<20.934,57.362,-0.183>,<0.001185,0.0012402,0.9999985>
CONSTR/PLANE,BF,PNT8,PNT9,PNT10,PNT11,PNT12,PNT13,PNT14,PNT15,PNT16,PNT17,PNT18,PNT19,PNT20,PNT21,PNT22,PNT23,PNT24,PNT25,PNT26,PNT27,PNT28,PNT29,,
OUTLIER_REMOVAL/OFF,3
FILTER/OFF,WAVELENGTH=0
MOVE/CLEARPLANE
MOVE/POINT,NORMAL,<0,175,25.4>
FLATNESS =GEOMETRIC_TOLERANCE/STANDARD=ASME Y14.5,SHOWEXPANDED=NO,
SEGMENT_1,FLATNESS,0.5,TOL_ZONE_MATH=DEFAULT,
ADD
FEATURES/PLN_FLAT_SURFACE,,
DIM HOLE SIZE= LOCATION OF CIRCLE CIR3 UNITS=MM ,$
GRAPH=OFF TEXT=OFF MULT=10.00 OUTPUT=BOTH HALF ANGLE=NO
AX NOMINAL +TOL -TOL MEAS DEV OUTTOL
D 6.800 0.100 -0.100 6.929 0.129 0.029 -------->
END OF DIMENSION HOLE SIZE
EXCEL_FORM1 =EXCELFORMREPORT/TEMPLATE=TEST SAMPLE, TYPE=XLSX
RESULT FOLDER/C:\Users\Public\Documents\Hexagon\PC-DMIS\2020 R2\ExcelFormReport\Results
PRINT/REPORT,EXEC MODE=END,$
TO_FILE=OFF,AUTO=1,AUTO OPEN=OFF,$
TO_PRINTER=OFF,COPIES=1,$
TO_DMIS_REPORT=OFF,FILE_OPTION=INDEX,FILENAME=,$
REPORT_THEORETICALS=NONE,REPORT_FEATURE_WITH_DIMENSIONS=NO,$
TO_EXCEL=OFF,$
PREVIOUS_RUNS=DELETE_INSTANCES
LOOP/END

I'd try to move the print command to the beginning of the loop to see if that works.

That seems to have done it. going to run a 6 part sample to ensure they're all different but my 3pc test looks like they're all different, 2 parts are just super close in flatness. the 2nd dimension i added is far different so i dont believe its repeating.

Glad you got it working!

All thanks to you! Thank you immensely. Can I send you a gift as gratitude?

No that's not necessary. I'm just paying it forward. I'm usually the one asking for help. I've learned so much from this forum. I'm just glad I can help now.