Insert values in Excel: Unterschied zwischen den Versionen

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


<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Senderwerte_einfügen]]-->
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Senderwerte_einfügen]]-->
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 on workbooks that are created by firesys). <small> '''[[Senderwerte_einfügen|mehr]]'''</small>
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 on workbooks that are created by firesys). <small> '''[[Senderwerte_einfügen|more]]'''</small>
----
----


Zeile 41: Zeile 41:


<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Manuelle_Werte_einfügen]]-->
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Manuelle_Werte_einfügen]]-->
A manual value is a data record in the firesys MeetingPoint that contains a numerical value and a name and can be created directly in the firesys menu ribbon.  <small>'''[[Manuelle_Werte_einfügen|mehr]]'''</small>  
A manual value is a data record in the firesys MeetingPoint that contains a numerical value and a name and can be created directly in the firesys menu ribbon.  <small>'''[[Manuelle_Werte_einfügen|more]]'''</small>  
-----
-----
| style="width: 30%"|<!-- ABS.1: Rechte Spalte ----------------------------------------------------------------------->
| style="width: 30%"|<!-- ABS.1: Rechte Spalte ----------------------------------------------------------------------->
Zeile 47: Zeile 47:


<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Kontenwerte_einfügen]]-->
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Kontenwerte_einfügen]]-->
An account value is a master value in firesys that can be written to the MeetingPoint via the account workbook and has a high level of integrity as a result of the key date reference. <small>'''[[Kontenwerte_einfügen|mehr]]'''</small>  
An account value is a master value in firesys that can be written to the MeetingPoint via the account workbook and has a high level of integrity as a result of the key date reference. <small>'''[[Kontenwerte_einfügen|more]]'''</small>  
-----
-----
</div>
</div>
Zeile 57: Zeile 57:


<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Kontenberechnung_einfügen]]-->
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Kontenberechnung_einfügen]]-->
An account calculation consists of the mathematical addition/subtraction of several account values. <small>'''[[Kontenberechnung_einfügen|mehr]]'''</small>
An account calculation consists of the mathematical addition/subtraction of several account values. <small>'''[[Kontenberechnung_einfügen|more]]'''</small>
-----
-----


Zeile 65: Zeile 65:


<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Werte_synchronisieren_und_lösen]]-->
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Werte_synchronisieren_und_lösen]]-->
The constant integrity of your data is a fundamental element of firesys. It should be possible to update even cross-file document structures through their connection to the firesys MeetingPoint just by pressing a button. <small>'''[[Werte_synchronisieren_und_lösen|mehr]]'''</small>
The constant integrity of your data is a fundamental element of firesys. It should be possible to update even cross-file document structures through their connection to the firesys MeetingPoint just by pressing a button. <small>'''[[Werte_synchronisieren_und_lösen|more]]'''</small>
-----
-----
|  style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
|  style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
Zeile 72: Zeile 72:


<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Weitere_Funktionen_Zentralwert-Manager]]-->
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Weitere_Funktionen_Zentralwert-Manager]]-->
In addition to inserting and synchronising master values, there are additional tools in firesys that can facilitate working with or managing master values. <small>'''[[Weitere_Funktionen_Zentralwert-Manager|mehr]]'''</small>
In addition to inserting and synchronising master values, there are additional tools in firesys that can facilitate working with or managing master values. <small>'''[[Weitere_Funktionen_Zentralwert-Manager|more]]'''</small>
-----
-----
|}
|}

Version vom 21. April 2020, 09:23 Uhr

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

Excel Funktionen 64.png
Insert values in Excel

With version 20.1., firesys is offering you a way of inserting numerical values from the MeetingPoint into your Excel document. You can use these numbers as the basis of additional operations.

Excel Funktionen 64.png

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 on workbooks that are created by firesys). more


A manual value is a data record in the firesys MeetingPoint that contains a numerical value and a name and can be created directly in the firesys menu ribbon. more


An account value is a master value in firesys that can be written to the MeetingPoint via the account workbook and has a high level of integrity as a result of the key date reference. more



An account calculation consists of the mathematical addition/subtraction of several account values. more


The constant integrity of your data is a fundamental element of firesys. It should be possible to update even cross-file document structures through their connection to the firesys MeetingPoint just by pressing a button. more


In addition to inserting and synchronising master values, there are additional tools in firesys that can facilitate working with or managing master values. more


Siehe auch

Navigation hoch.svg Die firesys-Funktionen in Excel
Navigation rechts.svg Die Gestaltungs-Funktionen in Excel
Navigation rechts.svg Übersetzungen in Excel
Navigation rechts.svg Der Blatt-Status

Weitere Inhalte

Webseite
Kundenbereich
YouTube