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?
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?