You can use ALVAO Asset Management to perform analyses in MS Excel. This is done using the "Asset Management Analysis enu.xlsm" file in the English language and the "Asset Management Analysis csy.xlsm" file in the Czech language. The files contain contingency tables and a script for database connection. The first sheets in the workbooks contain instructions for use.

The analysis can be opened from the Asset Management Console using the Data analysis command available in the main menu in the Tools section. By this command you open the file in the "C:\Users\{User}\Documents\ALVAO\" folder. If the workbook is not present in the location, it will be restored from the installation folder.

Note:

The Data analysis command works with the workbook which is in your preferred language. If you use another preferred language than English or Czech, the command will open the English workbook.

We recommend using the analytical database for data analysis.

Tip:

If you want to restore the original workbook, you can simply delete the current file from the "Documents\ALVAO" folder. The workbook will be restored from the installation folder after the next use of the Data analysis command.

Note:

The workbook copy is not upgraded after an upgrade to a new ALVAO version, therefore some sheets may cease to work. In this case, rename/delete the file in the "Documents\ALVAO" folder and create a new one using the Data analysis command.

Note:

After installation, the "Asset Management Analysis enu.xlsm" and "Asset Management Analysis csy.xlsm" files can be found in the "{installation folder}\ALVAO\Asset Management Console\" folder. We recommend not using or deleting these files. You can copy them and use the copied versions.

Did not find what you were looking for? Ask our technical support team.