AS9102 export of actuals only

[[Be...]]

We are new to Calypso and are trying to come up with a best practice for exporting data that we can compile in our AS9102 DIPs. Currently with MCOSMOS we can assign actuals to variables named Item 1, 2 and so on, and send them to a file appended in a column, in the correct order matching the bubbled print. We then have to use a macro or Text Collector to get them in separate columns to do min/max reporting of the actuals. Does anybody do this regularly and has a developed practice that gets to the end result in a relatively easy manner?

[img]https://photos.app.goo.gl/W5VlJ6N209nO2IMb2[/img]

DIP Ex.jpg

[[Da...]]

We use AS9102 FAIR and DIP sheets too. I came up with a way to get characteristic values into our AS9102 Form 3 excel sheets. No idea if it is ideal, but it is what I have come up with.

When I am programming the part, I create each characteristic. Name it whatever I want, then append "#Bubble Number" to each one as appropriate. Where there are multiple instances, it is "#Bubble Number.Instance".

This is exported into an excel file using the default Characteristic.xlt template that came with Calypso.

This gives me an excel file with Characteristic name, Actual, Nominal, Upper and Lower Tol, and deviation. I then use a macro to chew on the data, which imports the data into the AS9102 workbook, creates max and min results for each bubble, and enters the result into our FAIR sheet on the appropriate line. I don't need to sort my characteristics by bubble number or anything.

Actually programming the bubble numbers into calypso takes time, but seems to be working well so far.