Having trouble with report generation formatting

[geotech2018]

Hello!

I am having trouble formatting the Excel document when using report generation. I want a reading recorded for my two pressure transducers, two load cells, and thermocouple every second with each sensor assigned to a column in one Excel document (with the time in the first column). Right now multiple Excel documents are created at each time step showing a 5X2 matrix with the current time of the test in the first column and the current value of the five sensors in the second column.

Thank you,

Claire

[Gregory]

Do not create a new report inside the loop, create it before the loop. Then carry the report in a shift register. You can use transpose 2d array if the data is not oriented correctly.

[Bob_Schor]

Have you read the Help for all of the RGT functions?  Have you looked at any of the RGT examples?  Here's a Leading Question -- what is the name of the Excel file that you think you are writing?  Do you have one name or multiple names?

Bob Schor

[geotech2018]

Thank you, gregoryj. I appreciate your help!