This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
en:infra-convert:add-in:use [2016/08/08 15:44] mw created |
en:infra-convert:add-in:use [2019/09/06 11:14] (current) me |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Using the ELIAS Excel Add-In ====== | + | ~~NOTOC~~ |
| + | |||
| + | <WRAP noprint> | ||
| + | |||
| + | > #@IC_OLD_HTML@# > Excel Report Add-In | ||
| + | |||
| + | </WRAP> | ||
| + | |||
| + | ====== Operation ====== | ||
| + | |||
| + | ---- | ||
| After the Excel Report Add-In was installed you have a new slider in Excel called "ELIAS Reports". Activate this slider to use the Add-In: | After the Excel Report Add-In was installed you have a new slider in Excel called "ELIAS Reports". Activate this slider to use the Add-In: | ||
| + | {{ :en:infra-convert:add-in:exceladdin_1.png?direct&960 |}} | ||
| + | |||
| + | These are the functions of the Add-In: | ||
| + | |||
| + | - **Load inspection plan:** Load an ICP file. Load the contents of the infra-CONVERT project file into the template (see below). | ||
| + | - **Add inspection plan:** Load an additional ICP file in this inspection plan. The features will be added to the current features. | ||
| + | - **Save inspection plan:** Saves the current document as an Excel file. This file can be edited with another computer which has Excel installed. You don't need infra-CONVERT there! | ||
| + | - **infra-CONVERT:** Opens a drawing or project file in infra-CONVERT to create or edit an inspection plan. The data will then appear in the template which is selected. | ||
| + | - **Template:** Choose a template in which the data of the project file or infra-CONVERT will be loaded into. | ||
| + | - **Backup file:** If you start infra-CONVERT out of this Add-In, this option allows you to specify a backup directory where the project file will be saved. Specify the path with the three dots <wrap em>...</wrap> behind the option text. | ||
| + | - **Help:** Opens this wiki in your web browser. | ||
| + | - **Language:** Choose the language of the Add-In. | ||
| + | |||
| + | ===== Gathering measurement data ===== | ||
| + | After you created the inspection plan, it's possible to collect the measurement data inside of Excel, without the Report Add-In or infra-CONVERT. | ||
| + | |||
| + | {{ :en:infra-convert:add-in:exceladdin_2.png?direct&960 |}} | ||
| + | |||
| + | The Data Sheet contains all relevant data for the report. You don't have to type any informations into the following documents. The document evaluates the measurement data for you. | ||
| + | |||
| + | Attributive features should be evaluated with „i.O.“, „iO“, „ja“ or „1“. Any other value will result in a "not o.k.". | ||
| + | |||
| + | <WRAP tip 750px>Create **backups** of your created inspection plans (point 6). Because this option is often overlooked, we recommend using the function **Load inspection plan** after creating them with infra-CONVERT.</WRAP> | ||
| + | |||
| + | <WRAP noprint> | ||
| + | |||
| + | ---- | ||
| + | |||
| + | <WRAP group> | ||
| + | <WRAP col2> | ||
| + | |||
| + | <WRAP rightalign> | ||
| + | **Go to previous page**\\ | ||
| + | Excel Report Add-in > [[en:infra-convert:add-in:installation|Installation]] | ||
| + | |||
| + | </WRAP> | ||
| + | |||
| + | **Go to next page**\\ | ||
| + | Excel Report Add-in > [[en:infra-convert:add-in:customize|Create and integrate templates]] | ||
| + | |||
| + | </WRAP> | ||
| + | </WRAP> | ||
| + | </WRAP> | ||