Insert manual values: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(18 dazwischenliegende Versionen von 4 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
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.
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.




<imagemap>Datei:Excel Menüband Inhalt Einfügen Andere-Werte.jpg|center|1200px
[[Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Einfügen.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>




Zeile 29: Zeile 12:


== The description of the individual components when working with manual values ==
== The description of the individual components when working with manual values ==
&rarr; [[Zur Übersicht aller Begrifflichkeiten]]
[[Glossary|&rarr; Glossary]]


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




[[Datei:EN_Excel_Werte_einfügen_Schaubild15.jpg|800px|center|link=]]
[[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;Insert&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.  
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:GoodtoKnow
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.  
|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.  
Zeile 47: Zeile 30:
}}
}}


== Die Arbeit mit manuellen Werten==
== Working with manual values==




=== Einen manuellen Wert erstellen===
=== To create a manual value===
   
   


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




=== Einen manuellen Wert einfügen ===
=== Insert a manual value===




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




Zeile 66: Zeile 49:
=== Select master values/transmitter cells ===
=== Select master values/transmitter cells ===


[[Datei:Excel_Werte-einfügen_BlattInspektor.png|mini|upright=2.0|Der Kopfbereich des Blatt-Inspektors]]
[[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.   
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.   
Zeile 73: Zeile 56:
{{
{{


Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


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




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


== Siehe auch ==
[[Datei:Navigation_hoch.svg|link=]]  [[Werte_in_Excel_einfügen|Werte aus dem MeetingPoint in Excel einfügen]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Senderwerte_einfügen|Senderwerte einfügen]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Kontenwerte_einfügen|Kontenwerte einfügen]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Kontenberechnung_einfügen|Eine Kontenberechnung einfügen]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Werte_synchronisieren und lösen|Werte synchronisieren und lösen]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Weitere_Funktionen_Zentralwert-Manager|Eingefügte Werte verwalten]]  <br>


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


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

Aktuelle Version vom 2. März 2023, 09:39 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. In addition, you can use the "Master values history" button to display the history of your manual values.


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


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

→ Glossary

The schematic view

EN Excel Inhalt Zentralwerte Einfügen manueller-Wert.jpg


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 “Add” 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.

Working with manual values

To create a manual value


A detailed explanation of the individual steps

How to create a manual value:

  1. Open an Excel workbook and activate firesys.
    Note: A prerequisite is that a compatible MeetingPoint was already connected.

  2. In the “*Content” menu ribbon, in the “Master values” group, open the master value manager.

  3. In the “Management” group, click on the “Add” button.
    → A selection dialogue box opens.

  4. Select the “Manual value” option.

  5. An input dialogue opens in which you can assign a name and a numerical value to the manual value. You also have the option of entering a comment. Then confirm by clicking on “OK”
    → the manual value is created.


Insert a manual value


A detailed explanation of the individual steps

How to insert a transmitter value:

  1. Open the Excel workbook in which the manual value should be inserted.

  2. Select the cell you require.

  3. In the “*Content” menu ribbon, in the “Master values” group, click on the “Insert” button.
    → A work area opens.

  4. In the "Data type" range, select "Manual values" from the drop-down menu.

  5. In the "Actions" range, select the desired value in the list area and then click on the left button "Insert selected value".
    → The manual value is inserted.


Additional functions

Select master values/transmitter cells

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.



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 hoch.svg Insert transmitter 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