infra CONVERT
blue DAT • infra DAT
mdm TOOL
Sidebar
en:infra-convert:add-in:customize
This is an old revision of the document!
Table of Contents
Create and integrate your own templates
All files you need to embed your own templates into the Excel Add-In can be found at:
%ProgramData%\ELIAS GmbH\ELIASExcelReport
Structure of the Excel templates
The templates delivered with the Excel Add-In can be adjusted to your need. We recommend to make a copy of the existing templates and save them under a new name. How to embed them into the Add-In is described below.
We deliver these templates:
| Name of the template | Content |
|---|---|
| ELIAS_EMPB_DE_2012.xltx | Initial sample test report of VDA, status of 2012, German |
| ELIAS_EMPB_EN_2012.xltx | Initial sample test report of VDA, status of 2012, English |
| ELIAS_EMPB_DE_2013.xltx | Initial sample test report of VDA, status of 2013, German |
| ELIAS_EMPB_EN_2013.xltx | Initial sample test report of VDA, status of 2013, English |
| ELIAS_EMPB_DE_2015.xltx | Initial sample test report of VDA, status of 2015, German, cover sheet in landscape format |
Those files are Excel templates which don't use macros.
Please note: To open a template in Excel, use the “File / Open” dialog of Excel. If you open a template by double clicking it in the file explorer Excel won't save it as a template!
These are the sheets used by our templates:
| Name of sheet EN/DE | Content |
|---|---|
| Data Sheet / Datenblatt | Input mask for your data and measurements |
| Cover Sheet / Deckblatt | The cover sheet |
| Contents PPF / Inhalt PPF | Table of contents |
| Documents / Dokumente | Reference to other documents |
| PP1 to PP7 | Product related test results |
All of our templates contain a data sheet. This sheet should be the only one you have to type into.
If you create your own template you should copy one of our data sheets. This makes your work a lot easier.
Specific features of our templates
Our templates use conditional links in this form:
=IF('Data Sheet'!C1="";"";'Data Sheet'!C1)
This results into the following effect: The cell will only be filled, if the referenced cell has a content. This “trick” eliminates the zeros (“0”) in the report sheets.
The data sheets is able to evaluate your measurement data. You don't have to use an infra-CONVERT license to fill out the document. You only have to use an Excel, once the document has been created by the Add-In.
Due to the complexity of the data sheet we strongly recommend not to change it! If you add columns to the data sheet you have to adjust the cells which evaluate the measurement data!
en/infra-convert/add-in/customize.1470992781.txt.gz · Last modified: 2016/08/12 11:06 by mw
