This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:infra-convert:add-in:use [2016/08/08 15:49] mw |
en:infra-convert:add-in:use [2019/09/06 11:14] 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 |}} | {{ :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> |