Excel Form Report and Looping

Does your loop ID=NO? You could also try to put the print command at the beginning inside the loop before any features are measured.

no lol

Lemme fix and try again sorry

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?

Hello all,
I'm needing some help with the CMM data results downloading to excel. The software i was running had a delete buffer button you clicked after you saved the cmm data to a file but this software continues to dump all my measurements into the spreadsheet no matter how many parts I run.

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

Hello all,
I'm needing some help with the CMM data results downloading to excel. The software i was running had a delete buffer button you clicked after you saved the cmm data to a file but this software continues to dump all my measurements into the spreadsheet no matter how many parts I run.

Hey Tim,

You should start a new post & show us your code or it will be very difficult to help you

-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

Did you write the whole program or is it someone else's you are running? It sounds like maybe inside your F5 selections you have something selected for automatically reporting, or you have the print command checked to where it automatically wants to output a report. Let me look and see if I can get pictures for reference. I would listen to Dan_M though and create a new post with code so we can see.

When inside a program go to FILE -> PRINTING -> REPORT WINDOW PRINT SETUP and see if you have anything checked, this used to automatically populate a PDF for me and the previous programmer had the commend as a default above any alignment stuff so I never noticed.

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