Quelltext der Seite Insert transmitter values

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.


{{
Vorlage:Definition-SenderwertENG
}}


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

=== The schematic view ===


[[Datei:EN_Excel Werte einfügen Schaubild17.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.


{{
Vorlage:GoodtoKnow

|Gutzuwissen = 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 &ldquo;Transmitter value (transmitter cell)&rdquo; and &ldquo;Transmitter value (recipient cell)&rdquo; 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 ==

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


{{Vorlage:Video- Senderwert erstellen}}


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


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


== Zusätzliche Funktionen ==

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

[[Datei:EN_Excel Werte-einfügen BlattInspektor.jpg|mini|upright=2.0|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 &ldquo;Select master values&rdquo; 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. 


{{

Vorlage:GoodtoKnow

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

}}


{{Vorlage:Zentralwerte_hervorheben}}


== See also ==
[[Datei:Navigation_hoch.svg|link=]]  [[Insert_values_in_Excel|Insert values from the MeetingPoint into Excel]] <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_an_account_calculation|Insert an account calculation]]   <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>

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