Difference between revisions of "Excel Output format"

Latest revision as of 10:33, 15 May 2019

Introduction

It was added the ability to create an output in Excel format.
The input format (for the template) and the output format (the produced report) are compatible with any version of Excel 12 (Office 2007) or higher versions.

Measured Features Values

The template report will fill the information coming from ARCO locating the various values in the cells that carry one of the below listed names:

• “ID”: It represents an auto-incremented value that is assigned to each row produced in output
• “TYPE”: It represents the type of the measured object (CIRCLE, POINT, DISTANCE, etc.)
• “NAME”: It represents the name of the measured object
• “ACTUAL”: It represents the actual value of the measured object
• “NOMINAL”: It represents the nominal value of the measured object
• “DEVIATION”: It represents the deviation of the measured object
• “LOWERTOLERANCE”: It represents the lower limit of the tolerance of the measured object
• “UPPERTOLERANCE”: It represents the upper limit of the tolerance of the measured object
• “OUTOFTOLERANCE”: it represents the amount out of tolerance of the measured object if present
• “DESCRIPTION”: to be implemented
• “OUTPUTTYPE”: the characteristic sent to output
• “CRITICITY”: to be implemented
• “MODIFIER”: tolerance modifier (if present)
• “INNEROUTER”: two possible values "INNER/OUTER" based on the value of the feature
• “DATUM”: the description of datum
• “FULLDESCRIPTION”: to be implemented
• “PROJECTION”: the projection axis
• “APPLIEDTO”: the element to which is applied the tolerance

Worksheet Formatting

Some extra cells names shall be used when the worksheet requires some auto formatting rules:

• "TODUPLICATE": the cells contained in this range will be duplicated on the next COLUMN on the RIGHT in order to add extra columns to the sheet automatically
• "OUTPUTBLOCK": the cells contained in this range will be duplicated on the next ROW on the BOTTOM in order to add extra rows to the sheet automatically
• "FOOTER": the cells contained in this range will NOT be duplicated and must be place at the bottom of the worksheet. (This feature is available from Version 3.6.712)

Adding QIS variable

When in the DMIS program are created QIS variable, the same can be sent to EXCEL by simply creating a cell name called an the QIS variable name.