hexagon logo

Excel Form Report and Looping

Looping a program for a capability study, reporting out with Excel Form Report. I have it set up for 30 parts.
2020R2.
It keeps reporting the first part rather than each new part. This used to work. What may have changed?
Parents
  • 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?

    Attached Files
  • -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
Reply
  • -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
Children
No Data