Quelltext der Seite Insert manual values

When you work in firesys with numerical figures in Excel, you can use what are called manual values. A manual value represents a data record 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. In addition, you can use the "Master values history" button to display the history of your manual values.


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



{{
Vorlage:Definition-ManuellerWertENG
}}


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

=== The schematic view ===


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


he diagram explains the interaction of the different components that are required for working with master values. You can create a new manual value by using the &ldquo;Add&rdquo; function in the &ldquo;Management&rdquo; group in the master value manager. This value is subsequently provided to the firesys MeetingPoint. The manual value is saved in the MeetingPoint and can be inserted into any cell that is not locked or which contains a different master value by using the &ldquo;Insert&rdquo; function. 


{{
Vorlage:GoodtoKnowSmall

|Gutzuwissen = By using the &ldquo;Convert transmitter value&rdquo; function in the &ldquo;Management&rdquo; group in the master value manager, you can convert any transmitter value into a manual value. 

}}

== Working with manual values==


=== To create a manual value===
 

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


=== Insert a manual value===


{{Vorlage:Video- ManuellerWert einfügen-English}}


== Additional functions ==

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

[[Datei:EN_Excel_Werte-einfügen_BlattInspektor.jpg|mini|upright=2.0|Der Kopfbereich des Blatt-Inspektors]]

You can automatically select all master values or transmitter cells in 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_account_values|Insert account 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]]