Quelltext der Seite 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 and account aggregates. An account calculation and an account aggregate 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 or an account aggregate 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 or an account aggregate, you can also add a manual rounding value, which you can use to change the result of the account calculation or account aggregate manually to improve how it is presented and to allow you to continue working on it.


[[Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Einfügen.jpg|center|1200px]]




{{
Vorlage:Definition-KontenberechnungENG
}}


== The description of the individual components when working with account calculations or account aggregates ==
[[Glossary|&rarr; Glossary]]

=== The schematic view ===


[[Datei:EN Excel Inhalt Zentralwerte Einfügen Kontenberechnung-oder-Kontenaggregat.jpg|800px|center|link=]]


The first diagram shows the relationship between the individual components that are required for creating an account calculation or an account aggregate:
</p><p>The initial situation is that your MeetingPoint already contains account values. You can use the &ldquo;Insert&rdquo; function in the &ldquo;Management&rdquo; group in the master value manager to create an account calculation or an account aggregate. The account calculation dialogue box opens, the firesys tool for creating an account calculation or account aggregate. Each account calculation or account aggregate 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 or account aggregate 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. 
</p><p>You can then click on the &ldquo;OK&rdquo; button to create an account calculation or an account aggregate - 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 &ldquo;OK&rdquo;. This automatically saves the account calculation or account aggregate in the MeetingPoint. 
</p><p><b>Note</b>: For each key date, the account calculation or account aggregate is then available with the respective account values for the key date.


[[Datei:EN Excel Inhalt Zentralwerte Einfügen weitere-Arbeit.jpg|800px|center|link=]]


The second diagram shows the context of working further with account calculations or account aggregates, once one or more account calculation(s) or account aggregate(s) have been created in the master value manager and transferred to the MeetingPoint. 
</p><p>The firesys MeetingPoint is used here as the central organisational unit and collection point for all account calculations and account aggregates. From here, the account calculations or account aggregates 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 &ldquo;Insert&rdquo; function (in the &ldquo;*Content&rdquo; menu ribbon in the &ldquo;Master values&rdquo; group). 


{{
Vorlage:GoodtoKnow

|Gutzuwissen = Account calculations and account aggregates are always related to key dates. Sometimes, account calculations or account aggregates 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 or account aggregates are created. 

}}

== Video: Create an account calculation ==

{{Vorlage:Video- Kontenberechnung erstellen-English}}

== Video: Insert an account calculation ==

{{Vorlage:Video-_Kontenberechnung_einfügen-English}}

== Video: Edit an account calculation ==

{{Vorlage:Video-_Kontenberechnung_bearbeiten-English}}

== Video: Create an account aggregate ==

{{Vorlage:Video-Kontenaggregat erstellen-English}}


== Additional functions ==

=== Using a manual rounding value ===

Once you have added an account calculation or an account aggregate, you see the result immediately in the respective cell. You can use this result further in other account calculations, account aggregates 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 or an account aggregate. The process is explained in more detail in the following diagram:


[[Datei:EN Excel Inhalt Zentralwerte manueller-Rundungswert.jpg|800px|center|link=]]


The initial situation is that you have already created an account calculation or account aggregate, or you are currently creating a new account calculation or account aggregate. To add a manual rounding value, the work area of the &ldquo;Insert values&rdquo; function must be opened and selected as data type &ldquo;Account calculation&rdquo;. <br>
Alternatively, you can open the manual rounding wizard via the Master value manager. To do this, click on the button “Master value manager” in the menu ribbon “*Contents” in the group “Master values”. Select the desired account calculation or the desired account aggregate and then click on the “Edit” button in the Master value manager. A dialogue opens where you can select the option “Manual rounding value”. 


{{
Vorlage:GoodtoKnow

|Gutzuwissen = Always ensure that you have selected the correct key date when you create a manual rounding value.

}}

<!--
You can now select the account calculation or account aggregate you require in the list area. When you click on the &ldquo;Rounding wizard&rdquo; button, you see the initial value of the selected account calculation or account aggregate. In the &ldquo;Manual rounding value&rdquo; 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 &ldquo;Final result&rdquo;. As soon as you have entered an appropriate manual rounding value, you can confirm the entry by clicking on &ldquo;OK&rdquo;. 
-->


Select the desired account calculation or account aggregate in the list area. 
If you click on the button “Open the rounding wizard” ([[Datei:Image.Cell.EditFakeValue.32.png|16px]] - Symbol), the initial value of the selected account calculation or account aggregate is displayed. 
You can then choose between the following three rounding types under the item "Rounding type" in the drop-down menu: 


==== Manual rounding ====
[[Datei:EN Excel Inhalt Zentralwerte Manuelle Rundung.jpg|250px|center|link=]]

In the input window “Manual rounding value” you can enter any number (negative numbers can also be entered with the - symbol). 
When entering one or more digits, the invoice result under “Final result” is automatically adjusted in each case. 
As soon as you have entered a suitable manual rounding value, you can confirm the entry by clicking “Ok”.


==== Manual rounding with delta ====
[[Datei:EN Excel Inhalt Zentralwerte Manuelle Rundung mit Delta.jpg|250px|center|link=]]

For manual rounding with delta, you can add any value in addition to the manual rounding value in the “Delta” input window. 
With the help of the delta, a value range determined by you is defined within which the manual rounding value you entered is applied.


==== Fixed value with delta ====
[[Datei:EN Excel Inhalt Zentralwerte Manuelle Rundung Festwert mit Delta.jpg|250px|center|link=]]

For manual rounding with delta, you can select a delta with a fixed value in addition to the manual rounding value. 
Here you can use the delta to define a certain range of values. Under “Fixed value” you can enter any value that is displayed within the delta you have defined. 

Optionally, a comment can be added to all three rounding types, which is displayed in the Master value manager. 


{{
Vorlage:GoodtoKnow

|Gutzuwissen = There are two ways to add a manual rounding value. The first way is via the task pane "Insert values". Select "Account calculations and account aggregates" as the data type and then Open the rounding wizard under "Actions". 
The second way is via the Master value manager. To do this, click on the button "Master value manager" in the menu ribbon "*Contents" in the group "Master values". Select the desired account calculation or the desired account aggregate and then click on the "Edit" button in the Master value manager. A dialogue opens where you can select the option "Manual rounding value".
}}


==== Change of the base value ====

If underlying values of the account calculation are changed, a base value selection appears for the rounding types “Manual rounding with delta” and “Fixed value with delta”, in which you can select between the original base value and the currently value as the base.


[[Datei:EN Excel Inhalt Zentralwerte Manuelle Rundung Basiswertauswahl.jpg|600px|center|link=]]


The following diagram explains the process in more detail:


[[Datei:EN Excel Inhalt Zentralwerte Ursprünglicher Basiswert Aktueller Wert als Basis.jpg|center|800px]]


The initial situation is that new values are transferred to the MeetingPoint by account workbook or data import. If existing account calculations or aggregates containing “Manual rounding with delta” or “Fixed value with delta” are changed by adding or subtracting values, it is then possible to choose between the original base value or the current value as basis for the account calculation or aggregate.


{{
Vorlage:GoodtoKnow

|Gutzuwissen = As soon as you have made changes to an account calculation or account aggregate 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 or account aggregate. You can reset a manual rounding value at any time by removing the rounding value that was manually entered beforehand. 

}}



==== Delete manual rounding value ====

If you want to delete a manual rounding value, click on the “Master value manager” button in the “*Content” ribbon in the “Master values” group. 
In the Master value manager, select the account calculation or account aggregate whose manual rounding value you want to delete. 
Note that you must select a key date-related account calculation or a key date-related account aggregate for this. 
Then click on the “Delete” button in the “Management” group in the Master value manager. 

A dialogue is displayed asking whether the rounding value for this calculation should really be deleted. 

[[Datei:EN Excel Inhalt Zentralwert-Manager Löschen Manueller Rundungswert.jpg|center|500px]]


Confirm with “Yes” if the manual rounding value is to be deleted.  
A note about the deletion of the manual rounding value is displayed in the Master value manager in the drop-down menu of the value concerned. 


==== Video: The Rounding Wizard-Create a manual rounding ====

{{Vorlage:Video-Rundungs-Assistent-Manuelle Rundung erstellen-English}}


==== Video: The Rounding Wizard-Create a Manual Rounding with delta ====


{{Vorlage:Video-Rundungs-Assistent-Manuelle Rundung mit Delta erstellen-English}}


==== Video: The Rounding Wizard-Create a Fixed Value with delta ==== 


{{Vorlage:Video-Rundungs-Assistent-Festwert mit Delta erstellen-English}}


=== Select master values/transmitter cells ===

[[Datei:EN_Excel_Werte-einfügen_BlattInspektor.jpg|mini|upright=2.0|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.


{{

Vorlage:GoodtoKnowSmall

|Gutzuwissen = You can select either all transmitter values, or all master values. You cannot select both value types at the same time. 

}}

<b>Video: Highlight master values</b>

{{Vorlage:Video-Zentralwerte_hervorheben-English}}

== See also ==
[[Datei:Navigation_hoch.svg|link=]]  [[Insert_values_in_Excel|Insert in Excel]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[Insert_transmitter_values|Insert transmitter values]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Insert_manual_values|Insert manual values]]   <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Insert_account_values|Insert account values]]   <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Synchronise_and_detach|Synchronise and detach values]]   <br>

{{MoreContent}}
[[Kategorie:English-Excel Werte einfügen]]