Insert transmitter values: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(8 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
When you work in firesys with numerical values in Excel, you can use what are called transmitter values. A transmitter value is the value of an Excel cell that is transferred to the firesys MeetingPoint that is connected to Excel. This value can subsequently be used by all other Excel workbooks, for example for cross-file validation.
When you work in firesys with numerical values in Excel, you can use what are called transmitter values. A transmitter value is the value of an Excel cell that is transferred to the firesys MeetingPoint that is connected to Excel. This value can subsequently be used by all other Excel workbooks, for example for cross-file validation. You can also use the "Master values history" button to display the history of your Transmitter values.
 
[[Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Einfügen.jpg|center|1200px]]


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


desc none
</imagemap>




Zeile 13: Zeile 12:


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


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




[[Datei:EN_Excel Werte einfügen Schaubild17.jpg|800px|center|link=]]
[[Datei:EN Excel Inhalt Zentralwerte Einfügen Senderwert.jpg|800px|center|link=]]




The diagram explains the interaction of the different components that are required for working with master values. You can create a new transmitter value by using the &ldquo;New transmitter value&rdquo; function in the &ldquo;Master values&rdquo; group. The starting point is the currently selected Excel cell that is used as the transmitter value and thus permanently makes your current value (changes to the value of the transmitter cells are recognised by firesys when the workbook is saved) available to the firesys MeetingPoint. The transmitter value is saved in the MeetingPoint and when the &ldquo;Insert&rdquo; function is used, it can be inserted in the same group into any cell that is not locked or contains a different master value.
The diagram illustrates the interaction of the various components required for working with master values. Using the "Insert" function in the Master values group, you can create a new Transmitter value. The starting point is your currently selected Excel cell, which is used as the Transmitter value and thus permanently makes your current value available to the firesys MeetingPoint in the future. Changes to the sender cell value are detected by the firesys software when the workbook is saved. The transmitter value stored in the MeetingPoint can be selected via the "Insert" function under the "Master value" option in the "Insert values" selection dialog that then opens. The Transmitter value can be inserted in any Excel cell that is not locked or contains another master value.




Zeile 33: Zeile 32:
== Working with transmitter values ==
== Working with transmitter values ==


=== Case study - Create a transmitter value ===  
=== Video: Create a transmitter value ===  




{{Vorlage:Video- Senderwert erstellenENG}}
{{Vorlage:Video- Senderwert erstellen-English}}




=== Case stury - Insert a transmitter value ===  
=== Video: Insert a transmitter value ===  




{{Vorlage:Video- Senderwert einfügenENG}}
{{Vorlage:Video- Senderwert einfügen-English}}




Zeile 63: Zeile 62:




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




Zeile 70: Zeile 69:
[[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_account_values|Insert account values]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Insert_account_values|Insert account 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|Additional functions in the master value manager]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Additional_functions_in_the_master_value_manager|Additional functions in the master value manager]]  <br>

Aktuelle Version vom 19. November 2021, 13:03 Uhr

When you work in firesys with numerical values in Excel, you can use what are called transmitter values. A transmitter value is the value of an Excel cell that is transferred to the firesys MeetingPoint that is connected to Excel. This value can subsequently be used by all other Excel workbooks, for example for cross-file validation. You can also use the "Master values history" button to display the history of your Transmitter values.

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



Image.Fire.Info.32.png
Definition

A transmitter value contains a numerical value which is found at a different location in the workbook, or in a different Excel workbook (transmitter values cannot be created in workbooks that are created by firesys).


The description of the individual components when working with transmitter values

Glossar

The schematic view

EN Excel Inhalt Zentralwerte Einfügen Senderwert.jpg


The diagram illustrates the interaction of the various components required for working with master values. Using the "Insert" function in the Master values group, you can create a new Transmitter value. The starting point is your currently selected Excel cell, which is used as the Transmitter value and thus permanently makes your current value available to the firesys MeetingPoint in the future. Changes to the sender cell value are detected by the firesys software when the workbook is saved. The transmitter value stored in the MeetingPoint can be selected via the "Insert" function under the "Master value" option in the "Insert values" selection dialog that then opens. The Transmitter value can be inserted in any Excel cell that is not locked or contains another master value.


Glühbirne neu.png
Good to know

Always bear in mind the difference between a transmitter value that acts as a transmitter, and a transmitter value that receives the corresponding numerical value and displays it at a different location in your workbook. The worksheet inspector provides the “Transmitter value (transmitter cell)” and “Transmitter value (recipient cell)” overviews for this purpose. If a transmitter cell does not exist (any more), you can define an existing recipient value as a new transmitter cell at any time.

Working with transmitter values

Video: Create a transmitter value


A detailed explanation of the individual steps

How to create a transmitter value:

  1. Open the Excel workbook that contains the transmitter value you require.

  2. Select the cell of the required transmitter value.

  3. Click the "Insert" button in the "*Content" ribbon in the "Master values" group.
    → A dialog opens.

  4. Select the "Transmitter value" option.
    Note: You must save the Excel file beforehand and you must select a cell that contains a number.

    → A dialogue box opens displaying the position and current value of the selected cell.

  5. Assign a unique label.

  6. You can optionally add a comment.

  7. Click on "Ok".
    → The transmitter value is created.



Video: Insert a transmitter value


A detailed explanation of the individual steps

How to insert a transmitter value:

  1. Open the Excel workbook in which the transmitter value is to be inserted.

  2. Select a cell.

  3. Click on the "Insert" button in the "*Content" ribbon in the "Master values" group.
    → A dialog opens.

  4. Select the option "Master value".

    Note: You must save the Excel file beforehand and you must select a cell that contains a number.

    → The "Insert values" task pane opens.

  5. In the "Data type" range, select the entry "Transmitter values" from the drop-down menu.

  6. Select the desired value in the "Actions" list area.

  7. Click on the button Image.Cell.ProgrammableSheet.InsertValue.16.png „Insert selected value“.
    → The transmitter value is inserted.



Additional functions

Select master values/transmitter cells

The header area of the worksheet inspector

You can automatically select all master values or transmitter cells in your worksheet. To do this, open the worksheet inspector and in the header area in the “Select master values” group, use the two icons either to select all master values that obtain information from the MeetingPoint, or all transmitter values that transfer 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 rechts.svg Insert manual values
Navigation rechts.svg Insert account 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