Difference between revisions of "Excel Output format"
From ArcoWiki
(Created page with "It was added the ability to create an output in Excel format.<br /> The input format (for the template) and the output format (the produced report) are compatible with any ver...") |
|||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | == Introduction == | ||
It was added the ability to create an output in Excel format.<br /> | It was added the ability to create an output in Excel format.<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 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 | + | |
| − | *“ID”: It represents an auto-incremented value that is assigned to each | + | == 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.) | *“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 |
| + | |||
| + | == 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. | ||
| + | |||
| + | |||
| + | [[it:Formato di output di Excel]] | ||
| + | [[zh-cn:Excel输出格式]] | ||
| + | [[pt:Formato de saída do Excel]] | ||
| + | [[de:Excel-Ausgabeformat]] | ||
| + | [[es:Formato de salida de Excel]] | ||
| + | [[en:Excel Output format]] | ||
[[Category:ReadMe3.5.100]] | [[Category:ReadMe3.5.100]] | ||
| + | [[Category:ReadMe3.6]] | ||
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.
