Difference between revisions of "Excel Output format"

From ArcoWiki
Jump to: navigation, search
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 contain the data identified by their ID, specifically the data available can be chosen among the following:
+
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 line produced in output
+
*“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 measure
+
*“ACTUAL”: It represents the actual value of the measured object
*“NOMINAL”: It represents the nominal value of the measure
+
*“NOMINAL”: It represents the nominal value of the measured object
*“DEVIATION”: It represents the deviation of the measure
+
*“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 OOT value if present
+
*“OUTOFTOLERANCE”: it represents the amount out of tolerance of the measured object if present
 
*“DESCRIPTION”: to be implemented
 
*“DESCRIPTION”: to be implemented
*“OUTPUTTYPE”:  the feature to run in output
+
*“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 eventual datum
+
*“DATUM”: the description of datum
 
*“FULLDESCRIPTION”: to be implemented
 
*“FULLDESCRIPTION”: to be implemented
*“PROJECTION”: the eventual projection axis
+
*“PROJECTION”: the projection axis
*“APPLIEDTO”: the eventual element to which is applied the tolerance
+
*“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.