Quelltext der Seite 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.


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




{{
Vorlage:Definition

|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. <br><b>Note</b>: A unique combination of an account and a key date must always be assigned to an account value. <br><br> Create an account group by using the &ldquo;Add&rdquo; function (on the &ldquo;Management&rdquo; tab page in the master value manager). You can then use the &ldquo;Create&rdquo; function (in the &ldquo;*Content&rdquo; menu ribbon in the &ldquo;Account workbook&rdquo; group) to create an account workbook. The individual account values (with the components named above) are defined in this account workbook and subsequently transferred to the MeetingPoint by using the &ldquo;Transfer&rdquo; function (in the &ldquo;*Content&rdquo; menu ribbon in the &ldquo;Account workbook&rdquo; group). The account values that are saved in the MeetingPoint can be inserted into all Excel workbooks in which firesys is used by using the &ldquo;Insert&rdquo; function on the &ldquo;*Content&rdquo; menu ribbon in the &ldquo;Master values&rdquo; group. 
</p>
}}


== The description of the individual components when working with manual values ==
[[Glossar|&rarr;  Glossar]]

=== The schematic view ===


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


The first diagram shows the context of the individual components that are required for creating an account value:

Using the "Add" 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 management unit of all account values. Using the "Create account workbook" function (in the "*Content" ribbon in the "Data import" 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 "*Content" menu ribbon in the "Data import" group). 

Alternatively, you can also transfer account values to the MeetingPoint via the Data import. Using the "Create" function in the Data import manager (in the "*Content" ribbon in the "Data import" group), you can create an import definition that makes it possible to integrate a large number of records from upstream systems into the firesys environment. In the Import definition, select a data source from which you want to obtain your account values. It is important that you assign a title to the Import definition as well as an account group and a key date. The data can be configured using import options and will end up being imported into the MeetingPoint as master values.


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


The second diagram shows the context of working further with account values once the account values have been created in the master value manager:
</p><p>Using the "Transfer account workbook" function (in the "*Contents" ribbon in the "Data import" group), you can transfer all account values to the firesys MeetingPoint. Alternatively, you can transfer account values using the Data import manager in the "Data import" group. The firesys MeetingPoint serves as the central organizational unit and collection point for all master values. Subsequently, the account values present in the MeetingPoint can be inserted by using the "Insert" function (in the "*Content" menu ribbon in the "Master values" group) in any cell that is not locked or contains another master value. 


{{
Vorlage:GoodtoKnow

|Gutzuwissen = 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 ==


[[Datei: EN Excel Inhalt Zentralwerte Einfügen Zentralwert Werte einfügen.jpg |mini|upright=1.0|Task pane "Insert values"]]

=== Task Pane Insert values===

===[[File:Firesys Icons BubbleTransparent 1 white background.png|link=|24px]] Data type===
Here you can select between Transmitter values, Manual values, Account values as well as Account calculations and Account aggregates.

=== [[File:Firesys Icons BubbleTransparent 2 white background.png|link=|24px]] Account group ===
At this point you can select an account group. 

===[[File:Firesys Icons BubbleTransparent 3 white background.png|link=|24px]] Key date ===
Here you can select the key date for values in an account group. 

=== [[File:Firesys Icons BubbleTransparent 4 white background.png|link=|24px]] Actions ===

<b> [[Datei:Image.Cell.ProgrammableSheet.InsertValue.16.png|16px]] Insert the selected value</b> <br>
Inserts a value into the selected cell.

<b> [[Datei:Image.Cell.EditFakeValue.32.png|16px]] Open the rounding wizard </b> <br>
Opens the rounding wizard for editing and account calculations and ratio aggregates. 

<b> [[Datei:Image.Cell.ProgrammableSheet.InsertKeyDate.16.png|16px]] Insert key date </b> <br>
Inserts the key date selected above into the selected cell.


===Video: Create account values===

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


===Video: Create Import definition===
{{Vorlage:Video-Import-Definition erstellen-English}}


===Video: Insert account values===
{{Vorlage:Video-Tabellenassistent - Kontowerte einfügen-English}}

== Additional functions ==

=== [[Datei:Image.Cell.Type.TargetCell.32.png|16px]] Select master values/ [[Datei:Image.Cell.Type.ExcelValue.24.png|16px]] transmitter cells ===

[[Datei:EN_Excel_Werte-einfügen_BlattInspektor.jpg|mini|upright=2.0|The header area of the worksheet inspector]]

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 &ldquo;Select master values&rdquo; 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. 


{{

Vorlage:GoodtoKnowSmall

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

}}


{{Vorlage:Video-Zentralwerte_hervorheben-English}}

== See also ==
[[Datei:Navigation_hoch.svg|link=]]  [[Insert_values_in_Excel|Insert values 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_an_account_calculation or account aggregate|Insert an account calculation or account aggregate]]   <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Synchronise_and_detach|Synchronise and detach values]]   <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Additional_functions_in_the_master_value_manager|Additional functions in the master value manager]]   <br>

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