Difference between revisions of "Excel Output format"
From ArcoWiki
| Line 2: | Line 2: | ||
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.<br /> | 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.<br /> | ||
| − | The report will | + | 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 | + | *“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.) | *“TYPE”: It represents the type of the measured object (CIRCLE, POINT, DISTANCE, etc.) | ||
*“NAME”: It represents the name of the measured object | *“NAME”: It represents the name of the measured object | ||
| − | *“ACTUAL”: It represents the actual value of the | + | *“ACTUAL”: It represents the actual value of the measured object |
| − | *“NOMINAL”: It represents the nominal value of the | + | *“NOMINAL”: It represents the nominal value of the measured object |
| − | *“DEVIATION”: It represents the deviation of the | + | *“DEVIATION”: It represents the deviation of the measured object |
| − | *“LOWERTOLERANCE”: It represents the lower limit of the tolerance | + | *“LOWERTOLERANCE”: It represents the lower limit of the tolerance of the measured object |
| − | *“UPPERTOLERANCE”: It represents the upper limit of the tolerance | + | *“UPPERTOLERANCE”: It represents the upper limit of the tolerance of the measured object |
| − | *“OUTOFTOLERANCE”: it represents the | + | *“OUTOFTOLERANCE”: it represents the amount out of tolerance of the measured object if present |
*“DESCRIPTION”: to be implemented | *“DESCRIPTION”: to be implemented | ||
| − | *“OUTPUTTYPE”: the | + | *“OUTPUTTYPE”: the characteristic sent to output |
*“CRITICITY”: to be implemented | *“CRITICITY”: to be implemented | ||
*“MODIFIER”: tolerance modifier (if present) | *“MODIFIER”: tolerance modifier (if present) | ||
*“INNEROUTER”: two possible values "INNER/OUTER" based on the value of the feature | *“INNEROUTER”: two possible values "INNER/OUTER" based on the value of the feature | ||
| − | *“DATUM”: the description of | + | *“DATUM”: the description of datum |
*“FULLDESCRIPTION”: to be implemented | *“FULLDESCRIPTION”: to be implemented | ||
| − | *“PROJECTION”: the | + | *“PROJECTION”: the projection axis |
| − | *“APPLIEDTO”: the | + | *“APPLIEDTO”: the element to which is applied the tolerance |
| + | |||
| + | 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) | ||
| + | |||
| + | Handling of the 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. | ||
| + | |||
[[it:Formato di output di Excel]] | [[it:Formato di output di Excel]] | ||
Revision as of 07:13, 15 May 2019
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.
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
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)
Handling of the 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.
