Insert manual values: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 53: Zeile 53:
   
   


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




Zeile 59: Zeile 59:




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




Zeile 80: Zeile 80:




{{Vorlage:Zentralwerte_hervorheben}}
{{Vorlage:Zentralwerte_hervorhebenENG}}





Version vom 21. April 2020, 13:40 Uhr

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.


<imagemap>Datei:Excel Menüband Inhalt Einfügen Andere-Werte.jpg|center|1200px rect 1 79 208 191 Die_Basisfunktionen_von_firesy rect 212 78 283 190 Die_Kontenmappe rect 287 77 365 189 Arbeit_mit_Zentralwerten rect 371 76 513 108 Die_Kontenmappe#Kontenmappen_sortieren rect 372 110 512 139 Die_Kontenmappe#Zeilen_l.C3.B6schen rect 373 140 510 171 Die_Kontenmappe#Der_Kontowert-Verlauf rect 535 83 623 190 Der_Zentralwert-Manager rect 626 82 731 191 Werte_synchronisieren_und_lösen rect 735 83 888 112 Werte_in_Excel_einfügen rect 733 112 888 135 Werte_synchronisieren_und_lösen#Werte_l.C3.B6sen rect 736 135 888 169 Senderwerte_einfügen rect 894 81 991 188 Das_Validierungsblatt rect 998 80 1122 110 Validierungen_erstellen rect 996 112 1118 137 Validierung_bearbeiten rect 995 141 1118 176 Validierung_löschen rect 1132 81 1287 190 Die_Vorrollen_Funktionen_in_der_Übersicht desc none </imagemap>


Image.Fire.Info.32.png
Definition

A manual value is a data record in the firesys MeetingPoint that must contain a numerical value and a name - and can also contain an optional comment.


The description of the individual components when working with manual values

→ An overview of all terms

The schematic view


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 “Insert” function in the “Management” 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 “Insert” function.


Glühbirne neu.png
Good to know

By using the “Convert transmitter value” function in the “Management” group in the master value manager, you can convert any transmitter value into a manual value.

Die Arbeit mit manuellen Werten

Einen manuellen Wert erstellen

Vorlage:Video- ManuellerWert erstellenENG


Einen manuellen Wert einfügen

Vorlage:Video- ManuellerWert einfügenENG


Additional functions

Select master values/transmitter cells

Datei:Excel Werte-einfügen BlattInspektor.png
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 “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.


Vorlage:Zentralwerte hervorhebenENG


See also

Navigation hoch.svg Insert values from the MeetingPoint into Excel
Navigation hoch.svg Insert transmitter values
Navigation rechts.svg Insert account values
Navigation rechts.svg Insert an account calculation
Navigation rechts.svg Synchronise and detach values
Navigation rechts.svg Manage inserted values

Further contents

firesys website
Customer area
YouTube