Excel Form Report and Looping

The excel form report requires you to use the PCD ID and if you're needing to measure 30 parts make sure you have at least 30 columns with {Measured Value} in the data field. When using the excel form report with a loop, you need to turn the loop ID to NO. And I put a print command inside the start of the loop to delete previous instances or you could put it before the loop end but after the excel form report command.

See attached picture for REF. of issue.

If you want results in rows instead of columns you'll have to create a new template in the reverse of your current template. Have you fixed the issue that the first part results repeat for all parts?

Yes I have, it reports the parts separately now however in column format. So you mean run the "measured" aspects on the form to a column, and it'll output in a row? Will try that now.

Should look something like this. This a screenshot from when I was having Excel Form Report issues.

I am trying to replicate this, the problem is the workplace has a pre-made format that I have to adhere to, because it has formulas within for statistical analysis.

When you did this, where did you add the command for excel form report, inside the loop after the dimensions or post loop at the end of program? Whenever I put the excel form report within the loop it repeats data from initial part to all others within table as synonymous data.

I put my excel form report inside the loop. So I had to put a print command after the EFR command but still inside the loop to delete previous instances. And I had to set the loop ID to NO. I had made this row template and discovered I prefer it in columns. The spreadsheet just gets way too wide for me.

What did you set the print command to in order to get it to spit data onto the EFR? Or did you leave it unchecked and it automatically populates data into the EFR?

The only thing its doing is deleting the data from the previous part. Otherwise it retains the data from the initial part and fills the EFR with the initial part data only.

No change. same thing happening. See below:

PLN_FLAT_SURFACE =FEAT/PLANE,CARTESIAN,TRIANGLE,NO,LEAST_SQR
THEO/<20.934,57.363,0>,<0,0,1>
ACTL/<20.933,57.362,-0.18>,<0.0009803,0.0013251,0.9999986>
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,,
EXCEL_FORM1 =EXCELFORMREPORT/TEMPLATE=Dimensional Data Sheet_REV7, 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