General information and notes on the add-in
With the visual energy 4 add-in, you can access visual energy 4 energy data in Excel. Several special functions allow you to create individual evaluations and update them on demand. You can use a project explorer for assistance. You can also use one of several predefined queries.
Please consider the following factors when using the add-in:
- System requirements and installation
- The same user rights and rolesapply
- The Excel client requires an http connection to the visual energy 4 web server.
- If the Excel sheets are forwarded to other users, the recipients require the Excel add-in and an http connection to the visual energy 4 web server as well. Only sheets containing data without any visual energy functions can be opened without the add-in.
- For a list of functions, go to:
The add-in is also excellently suited to create cost centers.
Connection to visual energy 4
To work with the add-in, you need access to visual energy 4 data. Technically speaking, this is done using an http web service. If you can access the visual energy 4 web from your local computer with a web browser, you should also be able to access the Excel add-in with the web service.
For identification in visual energy 4, you need to log in with your user name and password.
In general, the same parameters apply as for access with a web browser. The user has to at least have the 'Energy data manager read-only' user role.
Add-in toolbar
Bereich | Funktion | Hinweis | |
---|---|---|---|
Documents | Open in the Web | Loads Excel files from a visual energy document folder. | |
Documents | Save in the Web | Saves Excel files in a visual energy 4 document folder. | |
Data view | Project | Show/hide project explorer | |
Data view | Meter point | Show meter point information dialog | |
Data view | Assignments | Opens a dialog for editing the cost centers / energy benefits | |
List | Objects | Adds new sheet, e.g. with meter points of a medium | |
List | Reports | Adds new sheet, e.g. with cost centers | |
Ad | Templates | Opens sample templates | |
Settings | Server / project | Displays server connection settings dialog | |
Settings | Versions information | Displays the current version of the add-in | |
Settings | Check the connection | Enables you to check the visual energy 4 web service connection | |
calculation | Manual / automatic | Switches between the automatic and manual calculation modes |