Insert account values: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(27 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
When you work in firesys with numerical values in Excel, you can use what are called account values. An account value represents a data record (consisting of a value, a corresponding name, an account and a key date) which is transferred to the firesys MeetingPoint that is connected to Excel. This account value can then be used by all other Excel workbooks for cross-file validation, for example.
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_Excel_Menüband_Inhalt_Zentralwerte_Senderwerte_einfügen.jpg|center|1200px
[[Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Einfügen.jpg|center|1200px]]
 


desc none
</imagemap>




Zeile 17: Zeile 16:


== The description of the individual components when working with manual values ==
== The description of the individual components when working with manual values ==
[[An_overview_of_all_terms|&rarr;  An overview of all terms]]
[[Glossary|&rarr;  Glossary]]


=== The schematic view ===
=== The schematic view ===




[[Datei:EN_Excel_Werte_einfügen_Schaubild2.jpg|800px|center|link=]]
[[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:
The first diagram shows the context of the individual components that are required for creating an account value:
</p><p>By using the &ldquo;Insert&rdquo; function in the &ldquo;Management&rdquo; group in the master value manager, you can create an account group (if one does not already exist) which is required as the central management unit of all account values. By using the &ldquo;Create&rdquo; function (in the &ldquo;*Content&rdquo; menu ribbon in the &ldquo;Account workbook&rdquo; group), you can create an account workbook that references the previously created account group. In this account workbook (an Excel worksheet that opens), you can define the individual components of the individual account values. Here, it is important that a unique combination of the assigned account and key date is used for each individual account value. All account values can then be transferred to the firesys MeetingPoint by using the &ldquo;Transfer&rdquo; function (in the &ldquo;*Content&rdquo; menu ribbon in the &ldquo;Account workbook&rdquo; group).  
 
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_Werte_einfügen_Schaubild4.jpg|800px|center|link=]]
[[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:
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>You can use the &ldquo;Transfer&rdquo; function (in the &ldquo;*Content&rdquo; menu ribbon in the &ldquo;Account workbook&rdquo; 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 &ldquo;Insert&rdquo; function (in the &ldquo;*Content&rdquo; menu ribbon in the &ldquo;Master values&rdquo; group).  
</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.  




Zeile 46: Zeile 48:




=== Example===  
[[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}}
 


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




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


== Additional functions ==
== Additional functions ==


=== Select master values/transmitter cells ===
=== [[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]]
[[Datei:EN_Excel_Werte-einfügen_BlattInspektor.jpg|mini|upright=2.0|The header area of the worksheet inspector]]
Zeile 64: Zeile 96:
{{
{{


Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


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




{{Vorlage:Zentralwerte_hervorhebenENG}}
{{Vorlage:Video-Zentralwerte_hervorheben-English}}


== See also ==
== See also ==
[[Datei:Navigation_hoch.svg|link=]]  [[Insert_values_in_Excel|Insert values from the MeetingPoint into Excel]] <br>
[[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_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_manual_values|Insert manual values]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Insert_an_account_calculation|Insert an account calculation]]  <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=]]  [[Synchronise_and_detach|Synchronise and detach values]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Additional_functions_in_the_master_value_manager|Manage inserted values]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Additional_functions_in_the_master_value_manager|Additional functions in the master value manager]]  <br>


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

Aktuelle Version vom 2. März 2023, 09:40 Uhr

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.


EN Menüband Excel Inhalt Zentralwerte Einfügen.jpg



Image.Fire.Info.32.png
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.
Note: A unique combination of an account and a key date must always be assigned to an account value.

Create an account group by using the “Add” function (on the “Management” tab page in the master value manager). You can then use the “Create” function (in the “*Content” menu ribbon in the “Account workbook” 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 “Transfer” function (in the “*Content” menu ribbon in the “Account workbook” 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 “Insert” function on the “*Content” menu ribbon in the “Master values” group.


The description of the individual components when working with manual values

→ Glossary

The schematic view

EN Excel Inhalt Zentralwerte Einfügen.jpg


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.


EN Excel Inhalt Zentralwerte Einfügen weitere-Arbeit.jpg


The second diagram shows the context of working further with account values once the account values have been created in the master value manager:

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.


Glühbirne neu.png
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

Task pane "Insert values"

Task Pane Insert values

Firesys Icons BubbleTransparent 1 white background.png Data type

Here you can select between Transmitter values, Manual values, Account values as well as Account calculations and Account aggregates.

Firesys Icons BubbleTransparent 2 white background.png Account group

At this point you can select an account group.

Firesys Icons BubbleTransparent 3 white background.png Key date

Here you can select the key date for values in an account group.

Firesys Icons BubbleTransparent 4 white background.png Actions

Image.Cell.ProgrammableSheet.InsertValue.16.png Insert the selected value
Inserts a value into the selected cell.

Image.Cell.EditFakeValue.32.png Open the rounding wizard
Opens the rounding wizard for editing and account calculations and ratio aggregates.

Image.Cell.ProgrammableSheet.InsertKeyDate.16.png Insert key date
Inserts the key date selected above into the selected cell.


Video: Create account values


A detailed explanation of the individual steps

How to create an account value:

  1. Open an Excel workbook and activate firesys.
    Note: A prerequisite is that a compatible MeetingPoint was already connected.

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

  3. In the “Management” group, click on the “Add” button.
    → A selection dialogue box opens.

  4. Select the “Account group” option and in the input dialogue box that opens, enter the name you require.

  5. Then close the master value manager and in the “Account workbook” group, click on the “Create” button.
    → This opens a dialogue box

  6. 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.

  7. This opens a new Excel worksheet in which you can define the components of the individual account values.

  8. 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.


Video: Create Import definition

A detailed explanation of the individual steps

To add a new Import definition in the Data Import Manager:

  1. Create an Import definition after which your data should be inserted into the MeetingPoint. Select the “Data Import Manager” button in the “Data Import” group in the “*Content” menu bar.
    → The data import manager opens.

  2. Choose the “Create” button in the “Import definition” group.
    → A dialogue box opens.

  3. File selection: In the dialog you have the possibility to select a data source from which the data should be read. In the Details area, further meta information can be added to the import definition. As a target for your data you can use an already existing key date in the firesys-MeetingPoint or you can define a new one at this point.

  4. Click on “Next” to go to the “File Settings” tab.

  5. File settings: Determine whether column headings are present in the import file If this is the case, the option will not transfer the first line of the file. Furthermore the column delimiter must be specified, so that firesys can recognize and transfer the records correctly.

  6. In the area “Number format” the decimal separator and the thousand separator of the import file are set.

  7. Click on “Next” to access the “Assignment & Options” tab.

  8. Assignment & Options: In the area “Column assignment and preview” the data records must be structured. The area contains the live view of the import options. To import the data into the firesys-MeetingPoint the columns of the import file must be defined. There are four types for the data columns to choose from:

    • account

    • name

    • value

    • comment

  9. The account, name and value columns are mandatory for data import; the Comment column is optional. All columns can only be assigned once.

  10. In the area “Import options” additional options can be created that are applied when the data is read in. With the help of these options the data can be modelled and then transferred to the firesys-MeetingPoint.

  11. In the video, an option is created to divide the account values by 1 million during transfer.

  12. There are further options, the choices depend on the “target column”.

  13. If you want to work with multiple read options, the order in which the options should be applied must be defined.

  14. Click on “Finish” to enter the data import manager.
    → The created import definition is now available.


Video: Insert account values


A detailed explanation of the individual steps

How to insert an account value:

  1. Open the Excel workbook in which the account value 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.
    → The "Insert" task pane opens.

  4. Select the value type "Account values" from the drop-down menu in the "Data type" area

  5. 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

Image.Cell.Type.TargetCell.32.png Select master values/ Image.Cell.Type.ExcelValue.24.png transmitter cells

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 “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.


Glühbirne neu.png
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

Navigation hoch.svg Insert values in Excel
Navigation hoch.svg Insert transmitter values
Navigation rechts.svg Insert manual values
Navigation rechts.svg Insert an account calculation or account aggregate
Navigation rechts.svg Synchronise and detach values
Navigation rechts.svg Additional functions in the master value manager

Further contents

firesys website
Customer area
YouTube