Insert an account calculation or account aggregate

When you work in firesys with numerical values in Excel, you can use what are called account calculations. An account calculation consists of an addition or subtraction of the account values that are saved in firesys and can be used for all key dates. The calculation result of an account calculation can be changed as it is being created by using mathematical functions according to the specifications that are relevant to you. Furthermore, after you insert an account calculation, you can also add a manual rounding value, which you can use to change the result of the account calculation manually to improve how it is presented and to allow you to continue working on it.

<imagemap>Datei:EN_Excel Menüband Inhalt Zentralwerte Einfügen.jpg|center|1200px

desc none </imagemap>

Definition

A key date-independent account calculation or account aggregate always consists of the addition or subtraction of one or more accounts. For each key date, the account calculation and account aggregate are then available with the respective account values. An account calculation and an account aggregate are only correct and valid if the corresponding key dates exist for all account values. You can use the “Add” function (on the “Management” tab page in the master value manager) to create a new account calculation or a new account aggregate. You can add together or subtract all accounts and account aggregates that are assigned to an account group (you define the subtraction by right-clicking on the respective account). This calculation result can also be enhanced with a mathematical operator that recalculates the result with the help of the factors defined above and where applicable this result can subsequently be rounded up to any number of decimal places. An account calculation and an account aggregate are automatically transferred to the MeetingPoint after it is created and is available to all key dates. The account calculations and account aggregates that are defined in the MeetingPoint can be inserted into all Excel workbooks in which firesys is used by using the “Insert” function on the “*Content“ tab page in the “Master values” group, and optionally also changed with a manual rounding value so that the results of the account calculation or account aggregate can be processed further.

The description of the individual components when working with account calculations

→ An overview of all terms

The schematic view

Datei:EN Excel Werte einfügen Schaubild3.jpg

The first diagram shows the relationship between the individual components that are required for creating an account calculation:

The initial situation is that your MeetingPoint already contains account values. You can use the “Insert” function in the “Management” group in the master value manager to create an account calculation. The account calculation dialogue box opens, the firesys tool for creating an account calculation. Each account calculation requires a name (which is unique for the account group that is used). You can then select the account group from which the accounts for the account calculation should be used. All available accounts are displayed in the list area. You can left-click on the relevant list entry to select all accounts that should be added - and right-click all accounts that should be subtracted.

You can then click on the “OK” button to create an account calculation - or optionally, to add a mathematical operator, a pre-defined factor and, where applicable, rounding (to a defined number of decimal places) to the calculation - and then finish creating it by clicking on “OK”. This automatically saves the account calculation in the MeetingPoint.

Note: For each key date, the account calculation is then available with the respective account values for the key date.

Datei:EN Excel Werte einfügen Schaubild4.jpg

The second diagram shows the context of working further with account calculations, once one or more account calculation(s) have been created in the master value manager and transferred to the MeetingPoint.

The firesys MeetingPoint is used here as the central organisational unit and collection point for all account calculations. From here, the account calculations that exist in the MeetingPoint can 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 calculations are always related to key dates. Sometimes, account calculations cannot be inserted correctly and used for certain key dates, whereas on other key dates, not all required account values are available (yet) which means that incorrect account calculations are created.

Create an account calculation

A detailed explanation of the individual steps

How to create an account calculation:

1. Make sure that account values are already stored in your MeetingPoint.

2. Open the Master value manager in the "*Content" menu ribbon in the "Master values" group.

3. Click on the "Add" button in the "Management" group.
   → A selection dialogue box opens.

4. Select the “Account calculation” option.
   → The account calculation dialogue box opens.

5. Here you have to enter a unique name for the account group that you used and select the account group in which the account values that are required for the account calculation are located.

6. From the list area with all account values, select those account values that you want to add with a left click, and those that you want to subtract with a right click.

Optional options:


7. You can also configure a mathematical operator, a factor and automatic rounding of the result.

8. Exit the dialogue box by clicking on the “OK” button.
   → The account calculation is now automatically transferred to the MeetingPoint.

Insert an account calculation

A detailed explanation of the individual steps

How to insert an account calculation:

1. Open the Excel workbook in which the account calculation should be inserted.

2. Select the cell you require.

3. In the “*Content” menu ribbon, in the “Master values” group, click on the “Insert” button.
   → A dialogue opens.

4. Click on "Master value".
   → The task pane "Insert values" opens.

5. In the work area, select “Account calculation” as the data type and then the account group you require and the correct key date.

6. The stored Account calculations appear in the list area. Select the desired Account calculation here.

7. If you do not require a manual rounding value, you can click on the left-hand button in the “Actions” area to insert the account calculation.
   → Account calculation is inserted in the selected cell

Edit an account calculation

A detailed explanation of the individual steps

To edit an account calculation:

Preparatory activities:



1. Make sure that an account calculation already exists in your MeetingPoint.

2. In the “*Content” menu ribbon, in the “Master values” group, open the master value manager.

3. In the list view, navigate to the desired account calculation.

4. Click the “Edit” button in the “Management” group.
   → The account calculation dialog opens.

5. From the list area with all account values, select those account values that you want to add with a left click, and those that you want to subtract with a right click.

6. You can also configure a mathematical operator, a factor and automatic rounding of the result.

7. Exit the dialogue box by clicking on the “OK” button.
   → The account calculation is now automatically adjusted in the MeetingPoint.

8. If you have already inserted the Account calculation in your Excel workbook, click on the "Synchronise values" button in the "*Contents" ribbon in the "Master values" group.
   → The adjustments are transferred to Excel.

Additional functions

Using a manual rounding value

Once you have added an account calculation, you see the result immediately in the respective cell. You can use this result further in other account calculations or validations, or it can be used as a presentation number in Word. You can use a manual rounding value to change the final result of an account calculation. The process is explained in more detail in the following diagram:

Datei:EN Excel Werte einfügen Schaubild6.jpg

The initial situation is that you have already created an account calculation, or you are currently creating a new account calculation. To add a manual rounding value, the work area of the “Insert values” function must be opened and selected as data type “Account calculation”.

	Good to know
	Always ensure that you have selected the correct key date when you create a manual rounding value.

You can now select the account calculation you require in the list area. When you click on the “Rounding wizard” button, you see the initial value of the selected account calculation. In the “Manual rounding value” dialogue box that follows, enter any number you like (you can also use the − icon to enter negative numbers). When you enter one or more figures, the calculation result automatically changes under “Final result”. As soon as you have entered an appropriate manual rounding value, you can confirm the entry by clicking on “OK”.

Good to know

As soon as you have made changes to an account calculation that is dependent on key dates, the new end result is automatically transferred to the MeetingPoint and the value of the initial value is thus overwritten, which will affect all other workbooks that reference this account calculation. You can reset a manual rounding value at any time by removing the rounding value that was manually entered beforehand.

Case study: Inserting an account calculation

A detailed explanation of the individual steps

How to use the manual rounding value in firesys:

• Open an Excel workbook and select the cell on the worksheet whose account calculation or account aggregate is to be provided with a rounding value.

• Click on the "Insert" button in the "Central values" group in the "*Contents" menu band.

• The rounding wizard opens.

• Enter the desired positive or negative rounding value.

• Confirm your entry with "Ok".

• Then press to select the desired account calculation or account aggregate and insert it into your worksheet using the "Insert values" function.

Select master values/transmitter cells

The header area of the worksheet inspector

As soon as you have made changes to an account calculation that is dependent on key dates, the new end result is automatically transferred to the MeetingPoint and the value of the initial value is thus overwritten, which will affect all other workbooks that reference this account calculation. You can reset a manual rounding value at any time by removing the rounding value that was manually entered beforehand.

	Good to know
	You can select either all transmitter values, or all master values. You cannot select both value types at the same time.

A detailed explanation of the individual steps

To highlight a master value on your worksheet:

1. Open an Excel workbook and activate firesys.
   Note: It is assumed that a compatible MeetingPoint has already been connected.

2. Open the Sheet Inspector in the "*Status" menu band in the "Information" group.

3. 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 in Excel
Insert transmitter values
Insert manual values
Insert account values
Synchronise and detach values
Additional functions in the master value manager

Further contents

→ firesys website
→ Customer area
→ YouTube