Insert account values
When working in firesys with numerical values in Excel, the so-called account values can be used. An account value represents a value with a unique designation on a key date. This can be transferred to the firesys MeetingPoint linked to Excel via the Data import or an account folder. It can then be used by all other Excel workbooks, e.g. for cross-file validation. You can also use the "Master values history" button to display the history of your account values.
<imagemap>Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Einfügen.jpg|center|1200px
desc none </imagemap>
 |
Definition
|
|---|---|
An account value is a data record in the firesys MeetingPoint that must contain a numerical value, a name, an associated account and a key date - it can also contain an optional free text. |
The description of the individual components when working with manual values
The schematic view
The first diagram shows the context of the individual components that are required for creating an account value:
Using the "Insert" function in the "Administration" group in the Master value manager, you can create an account group (if it does not already exist) that is needed as the central administration unit for all account values. Using the "Create" function (in the "*Contents" ribbon in the "Account Workbook" group) you can create an account workbook that references the previously created account group. In this account workbook (a newly opened Excel worksheet) you can define the individual components of each account value. It is important to note that a unique combination of assigned account and key date must be used for each individual account value. All account values can then be transferred to the firesys MeetingPoint using the "Transfer account workbook" function (in the "*Contents" ribbon in the "Account workbook" group).
The second diagram shows the context of working further with account values once the account values have been created in the master value manager:
You can use the “Transfer” function (in the “*Content” menu ribbon in the “Account workbook” group) to transfer all account values to the firesys MeetingPoint. The firesys MeetingPoint is used here as the central organisational unit and collection point of all master values. The account values that exist in the MeetingPoint can subsequently be inserted into any cell that is not locked or which contains a different master value by using the “Insert” function (in the “*Content” menu ribbon in the “Master values” group).
 |
Good to know
|
|---|---|
Account values can (but do not have to) contain different numerical values for different key dates. An account value and its corresponding key date always map unique information. |
Create and insert an account value
Example
How to create an account value:
-
Open an Excel workbook and activate firesys.
Note: A prerequisite is that a compatible MeetingPoint was already connected. -
In the “*Content” menu ribbon, in the “Master values” group,
→ open the master value manager. -
In the “Management” group, click on the “Add” button.
→ A selection dialogue box opens. -
Select the “Account group” option and in the input dialogue box that opens, enter the name you require.
-
Then close the master value manager and in the “Account workbook” group, click on the “Create” button.
→ This opens a dialogue box -
which you can select the account workbook to which the account values should be written, and also whether you want to create a new account workbook or load an existing one from the MeetingPoint.
-
This opens a new Excel worksheet in which you can define the components of the individual account values.
-
By using the “Transfer” function (in the “Account workbook” group), you can transfer all of the account values that exist in the account workbook into the MeetingPoint.
→ You have created an account value.
How to insert an account value:
-
Open the Excel workbook in which the account value should be inserted.
-
Select the cell you require.
-
In the “*Content” menu ribbon, in the “Master values” group, click on the “Insert” button.
→ The "Insert" task pane opens. -
Select the value type "Account values" from the drop-down menu in the "Data type" area
-
Select the desired account value in the list area and click on the left button "Insert selected value" in the "Actions" area.
→ The account value is inserted.
Additional functions
Select master values/transmitter cells
An option is available for selecting all master values or transmitter cells automatically on your worksheet. To do this, you can open the worksheet inspector and in the header area in the “Select master values” group, use the two icons to select either all master values that obtain information from the MeetingPoint or all transmitter values that transmit information to the MeetingPoint.
|
Good to know
|
|---|---|
You can select either all transmitter values, or all master values. You cannot select both value types at the same time. |
To highlight a master value on your worksheet:
-
Open an Excel workbook and activate firesys.
Note: It is assumed that a compatible MeetingPoint has already been connected. -
Open the Sheet Inspector in the "*Status" menu band in the "Information" group.
-
Click on one of the two buttons in the "Select master values" group in the task pane.
→ Click on the left symbol (select master values) to highlight all Excel cells that receive information from the MeetingPoint.
→ Click on the right symbol (select sender cells) to highlight all Excel cells that send information to the MeetingPoint.
See also
Insert values in Excel
Insert transmitter values
Insert manual values
Insert an account calculation or account aggregate
Synchronise and detach values
Additional functions in the master value manager