{"text_format":"1","workbook":"xlsx","n_sheets":55,"sheets":["Start","Vorlage","Vorlage_","Zufallszahlen","Zufallszahlen_","01 Notizen machen","01 Notizen machen_","02 Hilfe","02 Hilfe_","03 Tastenkürzel","03 Tastenkürzel_","04 Funktionen Deutsch-Englisch","05 Formel kopieren","05 Formel kopieren_","06 Einfügen","06 Einfügen_","07 Bereichsnamen","07 Bereichsnamen_","08 Stammdaten","09 Office Zwischenablage","09 Office Zwischenablage_","10 Bedingte Formatierung 1","10 Bedingte Formatierung 1_","11 Bedingte Format. 2 (A)","11 Bedingte Format. 2 (A)_","12 Absoluter Zellbezug (A)","12 Absoluter Zellbezug (A)_","13 Datenüberprüfung","13 Datenüberprüfung_","13 List data","14 Absol.-relativ-kumul. (A)","14 Absol.-relativ-kumul. (A)_","15 Spur und Fehlerüberprüf.","15 Spur und Fehlerüberprüf._","16 Blattschutz","16 Blattschutz_","17 Benutzerdef. Listen","17 Benutzerdef. Listen_","18 Benutzerdef. Formate","18 Benutzerdef. Formate_","19 Regionalisierung","19 Regionalisierung_","20 Zahlenformate","21 Währungsformate","22 Prozentformate","23 Datumsformate","24 Zeitdifferenzen (A)","24 Zeitdifferenzen (A)_","25 KALENDERWOCHE()","25 KALENDERWOCHE()_","26 WOCHENTAG()","26 WOCHENTAG()_","27 \"Seltsame\" Zeitformate (A)","28 UNIZEICHEN()","27 \"Seltsame\" Zeitformate (A)_"],"not_rendered":{"charts":1,"images":74,"macros":1,"external_links":2,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[4,6,33,6],[4,5,33,5]]}
[null,null,null,null,null,1,2,null,0]
[1,"Start"]
[2,"Start"]
[]
[0,null,null,2,0,"I have developed a set of Excel files, which may be used in lectures, but which are also usable for self-studying.\n\nThis file contains many explanations for basic Excel techniques, which are used in the other files.\n\nTherefore - if in the other files it is said \"Do this … and that …\" and you don't know how to do it - please have a look into this file. Hopefully you will find the needed explanations here. \n\nIf not - send me a short notice to stern@jade-hs.de!\n\nBefore you start working with the other files you should definitely work through the two sheets \"How to make notes\" and \"Help ...\" in this file!\n\nIf the buttons for language switching don't work, please click the following:\n\nFile / Options / Trust Center / Trust Center Settings / Macro Settings / Enable All Macros \n\nThen close and re-open this file again.","Ich habe eine Reihe von Excel-Dateien entwickelt, die in Vorlesungen benutzt werden können, die aber auch zum Selbststudium geeignet sind.\n\nDiese Datei hier enthält detaillierte Erläuterungen zu vielen grundlegenen Excel-Techniken, die in den anderen Dateien benutzt werden.\n\nWenn es daher in einer der anderen Dateien heißt \"Machen Sie dieses … und jenes …\" und Sie wissen nicht wie - sehen Sie bitte hier nach. Hoffentlich finden Sie dann die benötigten Erklärungen.\n\nWenn nicht - schicken Sie mir bitte einen Hinweis an stern@jade-hs.de!\n\nBevor Sie beginnen, mit den anderen Dateien zu arbeiten, sollten Sie aber auf jeden Fall zuerst die beiden Blätter \"Notizen machen\" und \"Hilfe ...\" hier in dieser Datei durchgearbeitet haben!\n\nWenn die Buttons zur Sprachumschaltung nicht funktionieren, klicken Sie bitte folgendes an:\n\nDatei / Optionen / Trust-Center / Einstellungen für das Trust-Center / Makroeinstellungen / Alle Makros aktivieren\n\nDann diese Datei schließen und erneut öffnen."]
[null,null,"Start"]
[null,null,"Vorlage"]
[null,null,"Zufallszahlen"]
[null,null,"01 Notizen machen",null,1009.5]
[null,null,"02 Hilfe",null,102]
[null,null,"03 Tastenkürzel",null,0]
[null,null,"04 Funktionen Deutsch-Englisch"]
[null,null,"05 Formel kopieren"]
[null,null,"06 Einfügen"]
[null,null,"07 Bereichsnamen"]
[null,null,"08 Stammdaten"]
[null,null,"09 Office Zwischenablage"]
[null,null,"10 Bedingte Formatierung 1"]
[null,null,"11 Bedingte Format. 2 (A)"]
[null,null,"12 Absoluter Zellbezug (A)"]
[null,null,"13 Datenüberprüfung"]
[null,null,"13 List data"]
[null,null,"14 Absol.-relativ-kumul. (A)"]
[null,null,"15 Spur und Fehlerüberprüf."]
[null,null,"16 Blattschutz"]
[null,null,"17 Benutzerdef. Listen"]
[null,null,"18 Benutzerdef. Formate"]
[null,null,"19 Regionalisierung"]
[null,null,"20 Zahlenformate"]
[null,null,"21 Währungsformate"]
[null,null,"22 Prozentformate"]
[null,null,"23 Datumsformate"]
[null,null,"24 Zeitdifferenzen (A)"]
[null,null,"25 KALENDERWOCHE()"]
[null,null,"26 WOCHENTAG()"]
[null,null,"27 \"Seltsame\" Zeitformate (A)"]
[null,null,"28 UNIZEICHEN()"]

{"sheet":"Vorlage","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[null,null,null,null,null,0]
[1,"Template",null,null,null,"Back to Start"]
[2,"Vorlage",null,null,null,"Startseite"]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"Vorlage_","index":2,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"Template_",null,null,null,{"$f":"B2","v":"Template_"}]
[2,"Vorlage_"]
[0]
[null,1,"In meinen Übungsdateien können Sie nicht wie üblich durch Klick auf das Pluszeichen ein neues Arbeitsblatt anlegen. \n\nWenn Sie ein neues Blatt brauchen, müssen Sie eine Kopie des Blattes \"Vorlage\" anlegen.\n\nACHTUNG: Denken Sie daran, die Option \"Kopie erstellen\" zu aktivieren!\n\n\n\n",null,1,"In my exercise files you cannot create a new worksheet by clicking on the plus sign as usual. \n\nIf you need a new sheet, you have to create a copy of the sheet \"Template\".\n\nATTENTION: Please remember to activate the option \"Create copy\"!\n\n\n"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Nachdem Sie eine Kopie dieses Blattes angelegt haben, ändern Sie dessen Namen NICHT wie üblich unten auf dem Register.\n\nStattdessen schreiben Sie den Blattnamen in die Zelle B3 des kopierten Blattes.\n\nAnschließend wechseln Sie auf das \"Start\"-Blatt und klicken dort erneut auf den Sprachbutton. \n\nDann müssen Sie evtl. etwas Geduld haben, weil Excel alle Blätter - auch die ausgeblendeten mit den Videotexten - durchgeht, um sie in's Inhaltsverzeichnis aufzunehmen.\n\nDer neue Name erscheint dann in der Liste der Blätter auf dem \"Start\"-Blatt und auf dem Register des kopierten Blattes.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"After you have created a copy of this sheet, DO NOT change its name as usual at the bottom of the tab.\n\nInstead, write the sheet name in cell B2 of the copied sheet.\n\nThen switch to the \"Start\" page and click on the language button again. \n\nThen you may have to have some patience, because Excel goes through all sheets - even the hidden ones with the video texts - to include them into the table of contents.\n\nThe new name then appears in the list of sheets on the \"Start\" sheet and on the tab of the copied sheet."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":""},null,null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":""}]

{"sheet":"Zufallszahlen","index":3,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[42,2,42,8],[1,1,1,4],[2,1,2,4],[4,2,8,9],[9,2,12,9],[41,2,41,8]]}
[null,null,null,null,null,null,null,null,null,0]
[1,"Random numbers",null,null,null,"Back to Start"]
[2,"Zufallszahlen",null,null,null,"Startseite"]
[]
[2,"Achtung","Wenn Sie nach dem Drücken von Strg-Umschalt-N eine Fehlermeldung bekommen, müssen Sie zunächst die Makros aktivieren:\n\n\"Datei / Optionen / Trust Center / Einstellungen für das Trust Center / Makroeinstellungen / Alle Makros aktivieren / OK / OK\""]
[2]
[2]
[2]
[2]
[1,"Attention","If you see an error message after pressing Ctrl-Shift-N you have to activate the macros first:\n\n\"File / Options / Trust Center / Trust Center Settings / Macro Settings / Enable all macros / OK / OK\""]
[1]
[1]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"Exercise","Try it!"]
[2,"Übung","Probieren Sie es aus!"]
[0]

{"sheet":"Zufallszahlen_","index":4,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"Random numbers_",null,null,null,{"$f":"B2","v":"Random numbers_"}]
[2,"Zufallszahlen_"]
[0]
[null,1,"Diese Excel-Datei enthält ein Formular zur Generierung von Zufallszahlen.\n\nSie können es mit der Tastenkombination Strg-Umschalt-N öffnen.\n\nDann können Sie es benutzen, um sich schnell beliebige Mengen von Übungsdaten zu generieren!",null,1,"This Excel file contains a form for the generation of random numbers.\n\nYou can open it with the shortcut Ctrl-Shift-N.\n\nThen you can use it to generate very quickly any number of trial data!"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Dazu müssen Sie zuerst einen Bereich markieren, der mit Zufallszahlen gefüllt werden soll. Dieser Bereich kann auch aus mehreren nicht zusammenhängenden Teilbereichen bestehen! (markieren mit gedrückter Strg-Taste)\n\nDann geben Sie die Parameter für die Generierung der Zufallszahlen ein und drücken \"Bereich(e) füllen\".\n\nSie können auswählen, ob\n- ein Teil der Zellen leer bleiben soll,\n- ein Teil der Zahlen negativ sein soll,\n- nur ganze Zahlen generiert werden sollen.\n\nMit dem Button \"Bereich(e) leeren\" können Sie … ok … das muss ich wohl nicht beschreiben.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"To do this, you must first select a range to be filled with random numbers. This range can also consist of several non-contiguous sub ranges! (selected with pressed Ctrl key)\n\nThen enter the parameters for the generation of the random numbers and press \"Fill range(s)\".\n\nYou can choose whether\n- some of the cells should remain empty,\n- some of the numbers should be negative,\n- only integer numbers should be generated.\n\nWith the button \"Clear range(s)\" you can ... ok ... I don't have to describe that.\n\n"]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":""},null,null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":""}]

{"sheet":"01 Notizen machen","index":5,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[[12,13,16,14],[65,2,65,7],[66,2,66,7],[1,1,1,4],[2,1,2,4],[4,2,5,8],[6,2,7,8]]}
[null,null,null,null,null,null,null,null,0]
[1,"01 How to make notes",null,null,null,"Back to Start"]
[2,"01 Notizen machen",null,null,null,"Startseite"]
[]
[2,null,"Hier möchte ich Ihnen einige Tipps geben, wie Sie sich Notizen machen können - speziell auch zur Funktionsweise von Excel-Formeln."]
[2]
[1,null,"Here I want to give you some tips, how to make notes - especially concerning the functioning of Excel formulas."]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"FORMELTEXT()"]
[1,"FORMULATEXT()"]
[]
[null,null,null,25,null,null,25]
[null,null,null,15,null,null,15]
[null,null,null,78,null,null,78]
[null,null,null,{"$f":"SUM(D34:D36)","v":118},{"$f":"_xlfn.FORMULATEXT(D37)","v":"=SUMME(D34:D36)"},null,{"$f":"AVERAGE(G34:G36)","v":39.333333333333336},{"$f":"_xlfn.FORMULATEXT(G37)","v":"=MITTELWERT(G34:G36)"}]
[]
[2,"Hochkomma",null,"=SUMME(D34:D36)"]
[1,"Inverted comma",null,"=SUM(D34:D36)"]
[]
[2,"Formeln anzeigen"]
[1,"Show Formulas"]
[]
[2,"\"Drucken\"-Taste"]
[1,"\"Print\" key"]
[]
[2,"\"Alt\"-\"Drucken\""]
[1,"\"Alt\"-\"Print\""]
[]
[2,"Snipping Tool"]
[1,"Snipping Tool"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"Offene Menüs"]
[1,"Open Menus"]
[]
[2,"Übung","Üben Sie diese Techniken mit einem beliebigen Excel-Arbeitsblatt!"]
[1,"Exercise","Train these techniques with any Excel worksheet!"]
[]
[0]

{"sheet":"01 Notizen machen_","index":6,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"01 How to make notes_",null,null,null,{"$f":"B2","v":"01 How to make notes_"}]
[2,"01 Notizen machen_"]
[]
[0,1,"Wenn Sie einen längeren Text schreiben wollen, schaffen Sie sich so den nötigen Platz:\n\n- markieren Sie mehrere Zellen\n\n- Klicken Sie auf \"Start / Ausrichtung / Verbinden und zentrieren\"\n\n- Aktivieren Sie \"Start / Ausrichtung / Textumbruch\" + \"Linksbündig\" + \"Oben ausrichten\"\n",null,1,"If you want to write a longer text, you can create the necessary space as follows:\n   \n- highlight several cells\n\n- Click \"Home / Alignment / Merge & Center\"\n\n- Activate \"Home / Alignment / Wrap Text\" + \"Align Left\" + \"Top Align\"\n"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Wenn Sie dann feststellen, dass der Bereich zu klein ist, können Sie einen größeren Bereich markieren, der den vorhandenen (zu kleinen) Bereich mit einschließt und noch einmal \"Verbinden und zentrieren\" ausführen. \n\nSie müssen das allerdings zweimal tun, weil beim ersten mal nur die Verbindung des zu kleinen Bereiches aufgehoben wird. Erst beim zweiten mal wird der größere Bereich verbunden.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"If you reccognize, that the range for your text is too small, you can mark a larger range, which includes the existing (too small) range and execute again \"Merge & Center\". \n\nBut you have to do this twice, because at the first time, only the merge of the the small range is removed. Then, at the second time, the larger range is merged."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Für einen Zeilenumbruch im Text drücken Sie Alt-Enter statt nur Enter.\n\nManchmal funktioniert der Zeilenumbruch nicht. Dann müssen Sie die Zeilenhöhe durch Ziehen mit der Maus selber vergrößern.",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"For a line break in your text press Alt-Enter instead of only Enter.\n\nSometimes \"Wrap Text\" does not work. Then you must increase the row height yourself by dragging it with the mouse."]
[null,4,"Mit Hilfe der Funktion FORMELTEXT() können Sie sich in einer Zelle anzeigen lassen, welche Formel in einer anderen Zelle steht.",null,4,"Using the function FORMULATEXT() you can display in one cell, which formula another cell contains:"]
[null,5,"Wenn Sie die Eingabe in einer Zelle mit einem Hochkomma beginnen, interpretiert Excel den Zellinhalt als Text und nicht als Formel.",null,5,"If you start the input in a cell with an inverted comma, Excel interprets the cell content as text and not as a formula."]
[null,6,"Wenn Sie \"Formeln / Formelüberwachung / Formeln anzeigen\" anklicken, werden alle Formeln anstelle ihrer Ergebnisse angezeigt.",null,6,"If you click \"Formulas / Formula Auditing / Show Formulas\" all formulas are displayed instead of their results."]
[null,7,"Wenn Sie die \"Drucken\"-Taste drücken, wird der gesamte Bildschirminhalt in die Zwischenablage kopiert. Sie können das Bild dann mit Strg-V in Ihr Dokument einfügen.\n\nWenn Sie die Tastenkombination \"Alt\"-\"Drucken\" drücken, wird nur das aktuelle Fenster in die Zwischenablage kopiert. Sie können das Bild dann mit Strg-V in Ihr Dokument einfügen.",null,7,"If you press the \"Print\" key on your keyboard, the complete screen is copied to the clipboard. Then you can insert the picture into your document with Ctrl-V.\n\nIf you press the \"Alt\" key together with the \"Print\" key, only the current window is copied to the clipboard. Then you can insert the picture into your document with Ctrl-V."]
[null,8,"Mit dem Snipping Tool können Sie beliebige (auch nicht rechteckige!) Bereiche Ihres Bildschirms \"fotografieren\", in die Zwischenablage kopieren und dann mit Strg-V in Ihr Dokument einfügen.\n\nUm schnell darauf zugreifen zu können, sollten Sie sich das Snipping Tool per Drag&Drop in die Befehlszeile am unteren Bildschirmrand legen!\nSie finden das Snipping Tool unter \"Start / Windows-Zubehör\".",null,8,"Using the Snipping Tool you can \"take a photo\" from any (also not rectangular!) range of your screen, copy it to the clipboard and insert it into your document with Ctrl-V.\n\nFor a quick access to the snipping tool you should put it via drag&drop into the command line at the lower border of your screen!\nYou can find the snipping tool under \"Windows / Accessories\"."]
[null,9,"Mit den hier beschriebenen Methoden erscheint es zunächst unmöglich, geöffnete Menüs zu fotografieren. Es gibt dafür aber die folgenden zwei Techniken:\n\nERSTENS: Öffnen Sie das Menü und machen dann mit der \"Drucken\"-Taste ein Foto des gesamten Bildschirms. Fügen Sie dieses in Ihr Dokument ein. Schneiden Sie dann mit dem Snipping Tool den gewünschten Bereich daraus aus. Dann löschen Sie das Bild des gesamten Bildschirms und fügen den ausgeschnittenen Bereich ein.",null,9,"With the methods described here it seems impossible to take photos of open menus. But there are two techniques for that:\n\nFIRST: Open the menu and take a photo of the whole screen by pressing the \"Print\" key. Insert it into your document. Then use the snipping tool to take a photo of the range of your interest. Delete the screenshot and insert the photo you have made with the snipping tool."]
[null,10,"Mit den hier beschriebenen Methoden erscheint es zunächst unmöglich, geöffnete Menüs zu fotografieren. Es gibt dafür aber die folgenden zwei Techniken:\n\nZWEITENS: Öffnen Sie das Snipping Tool, stellen Sie dort eine Verzögerungszeit ein und klicken auf \"Neu\". Öffnen Sie dann (schnell!) das Menü, das Sie fotografieren wollen, und warten Sie, bis die Verzögerungszeit abgelaufen ist. Jetzt bleibt das Menü offen, während Sie den zu fotografierenden Bereich mit der Maus markieren!",null,10,"With the methods described here it seems impossible to take photos of open menus. But there are two techniques for that:\n\nSECOND: Open the snipping tool, enter a delay time there and click to \"New\". Now open (quickly!) the menu, of which you want to take a photo and wait until the delay time is over. Now the menu remains open while you are marking the range for your photo! "]

{"sheet":"02 Hilfe","index":7,"n_rows":97,"n_cols":14,"rows_kept":97,"cut":false,"hidden":false,"merged":[[76,2,80,7],[82,2,87,7],[89,2,93,7],[62,2,62,8],[63,2,63,8],[64,2,64,8],[65,2,65,8],[66,2,66,8],[69,2,74,7],[38,2,38,9],[40,2,40,9],[41,2,41,11],[42,2,42,10],[43,2,43,9],[44,10,61,18],[1,1,1,4],[2,1,2,4],[4,2,4,4],[5,2,5,4],[36,2,36,9],[37,2,37,13]]}
[null,null,null,null,null,null,null,null,null,0]
[1,"02 Help",null,null,null,"Back to Start"]
[2,"02 Hilfe",null,null,null,"Startseite"]
[]
[1,"… in the internet:","https://support.office.com/en-gb/excel"]
[2,"… im Internet:","https://support.office.com/de-de/excel"]
[]
[]
[1,"… for functions"]
[2,"… zu Funktionen:"]
[]
[2,"Wenn Sie zu einer Excel-Funktion Hilfe brauchen und …"]
[1,"If you need help for an Excel function and …"]
[]
[2,"… bereits wissen, wie die Funktion heißt:"]
[1,"… you know already the name of the function:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,30]
[null,null,75]
[null,null,18]
[null,null,22]
[null,null,44]
[null,null,{"$f":"SUM(C24:C28)","v":189}]
[]
[2,"optionale Argumente"]
[1,"optional arguments"]
[]
[null,null,{"$f":"TODAY()","v":"2023-02-28"},"==>",{"$f":"WEEKDAY(C34)","v":"1900-01-03"}]
[]
[2,"… noch nicht wissen, welche Funktion Sie benötigen:"]
[2,null,"https://support.microsoft.com/de-de/excel "]
[2,null,"https://support.microsoft.com/de-de/office/formeln-und-funktionen-294d9486-b332-48ed-b489-abe7d0f9eda9?ui=de-DE&rs=de-DE&ad=DE#ID0EAABAAA=Formulas"]
[2,null,"https://support.microsoft.com/de-de/office/excel-funktionen-nach-kategorie-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb"]
[1,"… you don't know, which function you may need:"]
[1,null,"https://support.microsoft.com/en-gb/excel"]
[1,null,"https://support.microsoft.com/en-gb/office/formulas-and-functions-294d9486-b332-48ed-b489-abe7d0f9eda9?ui=en-US&rs=en-GB&ad=GB"]
[1,null,"https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb"]
[]
[null,null,null,null,null,null,null,null,null,null,"Guten Tag Herr Stern,\n\nich hoffe Sie hatten eine angenehme vorlesungsfreie Zeit. Nachdem ich mich an Ihr Angebot erinnere, auch mal bei Fragen außerhalb der Vorlesungen zu helfen, würde ich mich gerne an Sie mit folgendem Problem wenden:\n\nWir nutzen in der Firma eine Exceltabelle zur Erfassung des Datums, an welchem ein Datenfile an uns geschickt wurde. Hierbei wird händisch das Datum des Erhalts in die jeweilige Zelle eingetragen.\n\nNun die Frage: Haben Sie eine Idee, wie man eine bedingte Formatierung gestalten könnte, sodass sich die Zelle rot färbt, wenn das eingetragene Datum kleiner ist als das des zweitletzten Tages des vorangegangenen Monats und ansonsten grün, wenn das Datum jünger ist. Das Problem dabei ist, dass ich es nicht so formatiert bekomme, dass die bedingte Formatierung den vorletzten Tag des Vormonats nehmen würde und nicht den letzten.\n\nSollten Ihnen noch Informationen fehlen oder meine Schilderung Unklarheiten beinhalten, lassen Sie mich das gerne noch wissen.\n\nVielen Dank und freundliche Grüße,"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"… im Internet:","http://www.office-fragen.de/index.php/board,82.0.html"]
[2,null,"http://www.office-loesung.de/index3.php ",null,null,null,null,null,null,null,"aktuelles","zweitletzter",null,"Datum"]
[2,null,"http://www.office-loesung.de/p/viewforum.php?f=166&sid=6ac2b80af05761b2f0c89ec56632c7d5 ",null,null,null,null,null,null,null,"Datum","Tag des Vormonats",null,"des Files"]
[2,null,"https://www.clever-excel-forum.de/",null,null,null,null,null,null,null,"2023-02-28",{"$f":"EOMONTH($K$66,-1)-1","v":"2023-01-30"},null,"2022-12-25"]
[2,null,"https://www.ms-office-forum.net/forum/forumdisplay.php?f=29",null,null,null,null,null,null,null,null,null,null,"2022-12-31"]
[2,"!!!","https://www.herber.de/excelformeln/",null,null,null,null,null,null,null,null,null,null,"2023-01-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-12"]
[2,"Übung 1","Finden Sie heraus, welches Ergebnis die folgenden Funktionen liefern und welche Art von Argumenten sie benötigen:\n   (a) LINKS()\n   (b) TEIL()\n   (c) WENN()\n   (d) SUMMEWENN()",null,null,null,null,null,null,null,null,null,null,"2023-02-20"]
[2]
[2]
[2]
[2]
[2]
[2]
[2,"Übung 2","Finden Sie heraus, welche Funktion Sie jeweils benötigen, um folgendes zu tun:\n   (a) den arithmetischen Mittelwert zu berechnen\n   (b) die Kalenderwoche eines Datums ermitteln\n   (c) die Anzahl der Zeilen in einem Bereich ermitteln\n   (d) den Barwert einer Investition ausrechnen"]
[2]
[2]
[2]
[2]
[]
[1,"Exercise 1","Find out, which result the following functions provide and which kind of arguments they need:\n   (a) LEFT()\n   (b) MID()\n   (c) IF()\n   (d) SUMIF()"]
[]
[1]
[1]
[1]
[1]
[1]
[1,"Exercise 2","Find out, which function you will need to do the following:\n   (a) to calculate the average of some numbers\n   (b) to find out the calendar week of a date\n   (c) to find the number of rows in a range\n   (d) to calculate the present value of an investment"]
[1]
[1]
[1]
[1]
[]
[]
[0]

{"sheet":"02 Hilfe_","index":8,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,null,2,2,1,1,1,0]
[1,"02 Help_",null,null,null,{"$f":"B2","v":"02 Help_"}]
[2,"02 Hilfe_"]
[]
[0,1,"Geben Sie ein Gleichheitszeichen ein, den Namen der Funktion und die öffnende Klammer. Daraufhin erscheint unter dem Funktionsnamen ein kleines Hilfefenster. Wenn Sie darin auf den Funktionsnamen klicken, sind Sie sofort an der richtigen Stelle in der Excel-Hilfe!",null,1,"Enter the equal sign, the name of the function and the open bracket. Then a small window will appear below the function name. If you click there on the function name, you are immediately at the right position in the Excel help!"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"In eckigen Klammern angezeigte Funktionsargumente sind optional - d.h. Sie können sie bei der Eingabe der Funktion weglassen. Das bedeutet aber, dass Excel dann automatisch Standardwerte dafür einsetzt.\nSicherheitshalber sollten Sie sich in der Hilfe informieren, welche Standardwerte Excel einsetzt!",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"Arguments in square brackets are optional, i.e. you don't have to enter them. But that means, that Excel automatically enters standard values.\nTo be sure you should inform yourself in the Excel help, which standard values Excel will enter!"]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Rufen Sie mit der F1-Taste die online-Hilfe auf. Geben Sie den Suchbegriff \"Funktionen\" ein. Klicken Sie auf den Treffer \"Excel-Funktionen (nach Kategorie)\". \n\nWählen Sie jetzt die Kategorie aus, zu der Sie eine Funktion suchen (z.B. \"Datums- und Uhrzeitfunktionen\"). Scrollen Sie durch die Liste und lesen Sie die Beschreibungen der Funktionen. Bestimmt ist eine dabei, die Ihr Problem löst!\n\nDie Hilfe wird übrigens von Microsoft online zur Verfügung gestellt. Sie können den Link auch direkt benutzen und den Hilfetext im Brower lesen.",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"Call the Excel help by pressing the F1 key. Enter the search word \"functions\". Click on the hit \"Excel functions (by category)\". \n\nSelect now the category, which may contain the function you are looking for (e.g. \"Date and time functions\"). Scroll through the list and read the descriptions of the functions. Surely there will be one, that solves your problem!\n\nBy the way, the help is provided online by Microsoft. You can also use the link directly and read the help text in the browser."]
[null,{"$f":"IF(C8<>\"\",B7+1,\"\")","v":4},"Wenn gar nichts anderes hilft, sollten Sie sich an ein Forum wenden.\n\nAber ACHTUNG: Mit ziemlicher Sicherheit hat jemand anderes Ihr Problem auch schon mal gehabt. \n\nDarum immer erst die Suchfunktion benutzen, bevor Sie die Leute im Forum nerven, indem Sie eine bereits beantwortete Frage erneut stellen!\n\nHier sehen Sie einige Beispiele für Foren. Die Links können aber schon veraltet sein, wenn Sie diese Datei benutzen. Also einfach mal selber googeln ...",null,{"$f":"IF(F8<>\"\",E7+1,\"\")","v":4},"If nothing else helps, you should contact a forum.\n\nBut ATTENTION: It is almost certain that someone else has had your problem as well. \n\nTherefore, always use the search function first before you annoy people in the forum by asking an already answered question again!"]

{"sheet":"03 Tastenkürzel","index":9,"n_rows":250,"n_cols":14,"rows_kept":250,"cut":false,"hidden":false,"merged":[[4,5,7,5],[4,6,7,6]]}
[null,null,null,2,1,2,1,null,null,0]
[1,"03 Shortcuts","Back to Start"]
[2,"03 Tastenkürzel","Startseite"]
[null,null,null,"Markieren","Highlight"]
[null,null,null,"Strg-Umschalt-Pfeil_unten","Ctrl-Shift-Arrow_down","schnelles Markieren einer Liste","quick highlighting of a list",null,20,97,56,74,76,61]
[null,null,null,"Strg-Umschalt-Pfeil_oben","Ctrl-Shift-Arrow_up",null,null,null,97,66,41,53,50,1]
[null,null,null,"Strg-Umschalt-Pfeil_links","Ctrl-Shift-Arrow_left",null,null,null,53,97,5,14,84,57]
[null,null,null,"Strg-Umschalt-Pfeil_rechts","Ctrl-Shift-Arrow_right",null,null,null,51,69,32,60,26,19]
[null,null,null,null,null,null,null,null,51,96,57,90,28,73]
[null,null,null,"Strg-A","Ctrl-A","Alles markieren","highlight all",null,16,86,58,22,7,30]
[null,null,null,null,null,null,null,null,5,20,41,12,38,43]
[null,null,null,"Copy&Paste","Copy&Paste",null,null,null,54,9,20,94,89,73]
[null,null,null,"Strg-C","Ctrl-C","Kopieren","copy",null,52,80,26,69,76,17]
[null,null,null,"Strg-Einfg","Ctrl-Ins","Kopieren","copy",null,73,57,97,82,12,99]
[null,null,null,null,null,null,null,null,92,92,33,31,66,92]
[null,null,null,"Strg-V","Ctrl-V","Einfügen","paste",null,87,53,46,3,58,21]
[null,null,null,"Umschalt-Einfg","Shift-Ins","Einfügen","paste",null,46,34,33,27,60,67]
[null,null,null,null,null,null,null,null,16,26,13,78,76,75]
[0,null,null,"Strg-X","Ctrl-X","Ausschneiden","cut",null,72,9,70,31,21,22]
[null,null,null,null,null,null,null,null,5,89,7,67,26,16]
[null,null,null,"Screenshot","Screenshot",null,null,null,13,30,38,56,34,21]
[null,null,null,"Drucken","Print","Kopie des Bildschirms in die Zwischenablage","copy the screen into the clipboard",null,54,93,77,32,60,32]
[null,null,null,"Alt-Drucken","Alt-Print","Kopie des aktuellen Fensters in die Zwischenablage","copy the current window into the clipboard",null,36,31,95,41,60,72]
[null,null,null,null,null,null,null,null,37,60,42,82,24,37]
[null,null,null,"Matrixformeln","Matrix formulas",null,null,null,48,22,24,31,98,35]
[null,null,null,"Strg-Umschalt-Enter","Ctrl-Shift-Enter","Eingabe einer Matrixformel","Enter a matrix formula",null,31,93,26,7,94,40]
[null,null,null,null,null,null,null,null,64,39,64,41,54,55]
[null,null,null,null,null,null,null,null,67,41,87,35,100,97]
[null,null,null,null,null,null,null,null,58,64,61,48,56,14]
[null,null,null,null,null,null,null,null,90,9,74,50,48,83]
[null,null,null,null,null,null,null,null,46,59,12,9,6,3]
[null,null,null,null,null,null,null,null,1,24,74,100,22,60]
[null,null,null,null,null,null,null,null,69,29,45,58,44,61]
[null,null,null,null,null,null,null,null,1,11,45,9,6,31]
[null,null,null,null,null,null,null,null,100,13,8,41,27,41]
[null,null,null,null,null,null,null,null,62,94,74,21,26,12]
[null,null,null,null,null,null,null,null,74,94,91,57,38,95]
[null,null,null,null,null,null,null,null,18,21,59,58,24,40]
[null,null,null,null,null,null,null,null,54,43,72,44,19,93]
[null,null,null,null,null,null,null,null,95,17,20,14,50,94]
[null,null,null,null,null,null,null,null,3,79,87,73,27,56]
[null,null,null,null,null,null,null,null,46,64,28,66,84,49]
[null,null,null,null,null,null,null,null,2,60,25,81,21,26]
[null,null,null,null,null,null,null,null,26,95,63,15,82,54]
[null,null,null,null,null,null,null,null,76,99,49,17,65,51]
[null,null,null,null,null,null,null,null,89,26,100,48,45,30]
[null,null,null,null,null,null,null,null,54,98,41,22,63,3]
[null,null,null,null,null,null,null,null,4,9,14,29,13,100]
[null,null,null,null,null,null,null,null,51,17,71,32,18,11]
[null,null,null,null,null,null,null,null,6,1,13,12,90,39]
[null,null,null,null,null,null,null,null,80,59,95,98,13,32]
[null,null,null,null,null,null,null,null,58,75,100,82,85,48]
[null,null,null,null,null,null,null,null,77,89,73,45,19,35]
[null,null,null,null,null,null,null,null,56,39,47,16,83,61]
[null,null,null,null,null,null,null,null,67,66,13,44,28,17]
[null,null,null,null,null,null,null,null,41,92,12,72,42,68]
[null,null,null,null,null,null,null,null,40,16,49,16,12,43]
[null,null,null,null,null,null,null,null,50,99,67,8,11,68]
[null,null,null,null,null,null,null,null,65,13,24,56,5,7]
[null,null,null,null,null,null,null,null,83,91,55,15,78,43]
[null,null,null,null,null,null,null,null,17,97,22,87,9,24]
[null,null,null,null,null,null,null,null,100,97,78,85,38,63]
[null,null,null,null,null,null,null,null,39,13,6,35,29,45]
[null,null,null,null,null,null,null,null,40,87,99,98,90,10]
[null,null,null,null,null,null,null,null,22,74,92,32,31,91]
[null,null,null,null,null,null,null,null,70,57,77,38,56,32]
[null,null,null,null,null,null,null,null,16,51,41,42,24,22]
[null,null,null,null,null,null,null,null,48,26,25,29,27,16]
[null,null,null,null,null,null,null,null,60,85,84,11,67,24]
[null,null,null,null,null,null,null,null,25,62,95,2,33,94]
[null,null,null,null,null,null,null,null,40,30,62,45,4,22]
[null,null,null,null,null,null,null,null,65,37,82,85,38,64]
[null,null,null,null,null,null,null,null,74,13,100,13,19,23]
[null,null,null,null,null,null,null,null,84,1,58,11,63,49]
[null,null,null,null,null,null,null,null,17,25,2,70,22,76]
[null,null,null,null,null,null,null,null,27,84,30,64,26,67]
[null,null,null,null,null,null,null,null,96,36,70,11,53,61]
[null,null,null,null,null,null,null,null,63,23,26,40,17,34]
[null,null,null,null,null,null,null,null,67,32,48,50,19,8]
[null,null,null,null,null,null,null,null,100,12,95,36,92,93]
[null,null,null,null,null,null,null,null,98,79,97,13,48,30]
[null,null,null,null,null,null,null,null,34,82,50,63,93,64]
[null,null,null,null,null,null,null,null,75,15,87,76,75,90]
[null,null,null,null,null,null,null,null,21,99,16,88,92,21]
[null,null,null,null,null,null,null,null,39,61,15,8,49,91]
[null,null,null,null,null,null,null,null,68,92,21,96,65,91]
[null,null,null,null,null,null,null,null,40,61,57,49,62,87]
[null,null,null,null,null,null,null,null,57,5,96,80,82,85]
[null,null,null,null,null,null,null,null,20,46,32,16,13,27]
[null,null,null,null,null,null,null,null,88,74,17,53,33,46]
[null,null,null,null,null,null,null,null,24,24,100,25,87,12]
[null,null,null,null,null,null,null,null,51,26,53,91,68,28]
[null,null,null,null,null,null,null,null,29,94,83,44,63,90]
[null,null,null,null,null,null,null,null,20,8,57,92,74,96]
[null,null,null,null,null,null,null,null,5,82,7,69,48,70]
[null,null,null,null,null,null,null,null,73,37,69,70,62,52]
[null,null,null,null,null,null,null,null,94,10,79,28,35,55]
[null,null,null,null,null,null,null,null,39,79,49,66,93,89]
[null,null,null,null,null,null,null,null,22,81,72,4,83,13]
[null,null,null,null,null,null,null,null,68,48,38,89,22,65]
[null,null,null,null,null,null,null,null,30,95,58,89,29,64]
[null,null,null,null,null,null,null,null,24,32,38,75,69,6]
[null,null,null,null,null,null,null,null,32,87,41,60,17,90]
[null,null,null,null,null,null,null,null,8,50,20,86,12,33]
[null,null,null,null,null,null,null,null,95,94,35,80,60,80]
[null,null,null,null,null,null,null,null,4,21,60,13,10,12]
[null,null,null,null,null,null,null,null,52,39,59,25,16,92]
[null,null,null,null,null,null,null,null,44,70,90,22,45,31]
[null,null,null,null,null,null,null,null,32,48,52,37,5,39]
[null,null,null,null,null,null,null,null,10,55,89,18,98,3]
[null,null,null,null,null,null,null,null,17,92,25,97,34,8]
[null,null,null,null,null,null,null,null,50,15,85,29,38,90]
[null,null,null,null,null,null,null,null,26,45,26,29,58,94]
[null,null,null,null,null,null,null,null,25,51,89,26,45,59]
[null,null,null,null,null,null,null,null,23,76,39,28,63,70]
[null,null,null,null,null,null,null,null,79,25,56,58,57,52]
[null,null,null,null,null,null,null,null,49,65,1,8,74,71]
[null,null,null,null,null,null,null,null,34,87,63,18,36,92]
[null,null,null,null,null,null,null,null,81,38,52,80,86,8]
[null,null,null,null,null,null,null,null,10,25,20,30,70,12]
[null,null,null,null,null,null,null,null,13,35,100,57,25,13]
[null,null,null,null,null,null,null,null,71,45,2,68,85,99]
[null,null,null,null,null,null,null,null,66,97,18,74,25,95]
[null,null,null,null,null,null,null,null,97,70,6,87,98,77]
[null,null,null,null,null,null,null,null,20,78,68,44,44,36]
[null,null,null,null,null,null,null,null,75,67,37,97,81,7]
[null,null,null,null,null,null,null,null,69,90,41,36,90,1]
[null,null,null,null,null,null,null,null,23,99,9,41,62,11]
[null,null,null,null,null,null,null,null,9,62,30,70,81,77]
[null,null,null,null,null,null,null,null,34,2,87,21,41,27]
[null,null,null,null,null,null,null,null,42,29,26,51,30,39]
[null,null,null,null,null,null,null,null,46,85,37,25,37,84]
[null,null,null,null,null,null,null,null,10,49,37,17,49,40]
[null,null,null,null,null,null,null,null,39,58,12,2,57,3]
[null,null,null,null,null,null,null,null,53,41,33,13,84,20]
[null,null,null,null,null,null,null,null,52,82,61,42,96,25]
[null,null,null,null,null,null,null,null,91,47,16,100,74,52]
[null,null,null,null,null,null,null,null,31,48,59,96,49,61]
[null,null,null,null,null,null,null,null,33,26,19,73,30,99]
[null,null,null,null,null,null,null,null,1,78,67,14,66,71]
[null,null,null,null,null,null,null,null,9,61,21,19,46,10]
[null,null,null,null,null,null,null,null,55,47,15,6,13,62]
[null,null,null,null,null,null,null,null,27,5,96,89,33,27]
[null,null,null,null,null,null,null,null,82,43,7,35,75,17]
[null,null,null,null,null,null,null,null,60,39,82,4,72,30]
[null,null,null,null,null,null,null,null,5,34,57,28,71,47]
[null,null,null,null,null,null,null,null,46,67,76,77,1,98]
[null,null,null,null,null,null,null,null,59,80,45,18,3,65]
[null,null,null,null,null,null,null,null,30,25,55,70,20,99]
[null,null,null,null,null,null,null,null,79,48,99,5,23,91]
[null,null,null,null,null,null,null,null,14,24,23,63,26,5]
[null,null,null,null,null,null,null,null,24,75,8,48,30,75]
[null,null,null,null,null,null,null,null,43,9,76,63,72,26]
[null,null,null,null,null,null,null,null,24,35,46,76,93,52]
[null,null,null,null,null,null,null,null,17,55,2,27,45,83]
[null,null,null,null,null,null,null,null,45,47,39,30,90,15]
[null,null,null,null,null,null,null,null,14,76,2,13,77,88]
[null,null,null,null,null,null,null,null,91,99,41,23,85,21]
[null,null,null,null,null,null,null,null,57,63,31,60,79,64]
[null,null,null,null,null,null,null,null,16,98,45,37,17,12]
[null,null,null,null,null,null,null,null,93,55,72,84,95,82]
[null,null,null,null,null,null,null,null,80,51,16,26,26,71]
[null,null,null,null,null,null,null,null,1,19,28,9,90,25]
[null,null,null,null,null,null,null,null,8,63,46,64,96,98]
[null,null,null,null,null,null,null,null,24,72,47,19,52,78]
[null,null,null,null,null,null,null,null,95,62,42,7,23,9]
[null,null,null,null,null,null,null,null,29,15,63,31,29,39]
[null,null,null,null,null,null,null,null,19,57,27,78,15,65]
[null,null,null,null,null,null,null,null,87,98,68,98,86,63]
[null,null,null,null,null,null,null,null,91,8,80,86,7,23]
[null,null,null,null,null,null,null,null,84,13,8,38,87,23]
[null,null,null,null,null,null,null,null,22,32,87,63,12,13]
[null,null,null,null,null,null,null,null,51,100,2,81,2,98]
[null,null,null,null,null,null,null,null,23,25,29,28,87,36]
[null,null,null,null,null,null,null,null,24,94,87,51,42,90]
[null,null,null,null,null,null,null,null,18,20,88,76,29,98]
[null,null,null,null,null,null,null,null,25,87,90,63,16,61]
[null,null,null,null,null,null,null,null,99,56,78,92,97,53]
[null,null,null,null,null,null,null,null,72,13,23,50,13,98]
[null,null,null,null,null,null,null,null,85,87,7,92,56,86]
[null,null,null,null,null,null,null,null,8,68,3,19,11,2]
[null,null,null,null,null,null,null,null,28,2,55,84,49,10]
[null,null,null,null,null,null,null,null,64,43,94,21,7,1]
[null,null,null,null,null,null,null,null,26,81,85,59,89,98]
[null,null,null,null,null,null,null,null,36,93,85,59,81,91]
[null,null,null,null,null,null,null,null,71,71,75,4,82,29]
[null,null,null,null,null,null,null,null,100,26,78,9,71,98]
[null,null,null,null,null,null,null,null,21,84,76,43,71,67]
[null,null,null,null,null,null,null,null,36,11,11,76,86,69]
[null,null,null,null,null,null,null,null,91,29,95,98,10,62]
[null,null,null,null,null,null,null,null,94,26,4,66,39,83]
[null,null,null,null,null,null,null,null,78,60,1,81,51,79]
[null,null,null,null,null,null,null,null,72,14,28,94,1,95]
[null,null,null,null,null,null,null,null,2,52,60,6,73,46]
[null,null,null,null,null,null,null,null,25,78,2,3,87,96]
[null,null,null,null,null,null,null,null,79,6,92,30,25,32]
[null,null,null,null,null,null,null,null,98,90,13,21,62,2]
[null,null,null,null,null,null,null,null,18,71,53,16,91,49]
[null,null,null,null,null,null,null,null,84,35,57,37,77,70]
[null,null,null,null,null,null,null,null,36,1,46,19,94,78]
[null,null,null,null,null,null,null,null,8,72,17,99,22,39]
[null,null,null,null,null,null,null,null,7,26,48,8,8,22]
[null,null,null,null,null,null,null,null,30,23,52,44,13,87]
[null,null,null,null,null,null,null,null,33,58,74,96,9,80]
[null,null,null,null,null,null,null,null,84,89,20,50,97,29]
[null,null,null,null,null,null,null,null,38,14,55,10,44,51]
[null,null,null,null,null,null,null,null,32,86,22,8,86,22]
[null,null,null,null,null,null,null,null,86,72,51,79,24,58]
[null,null,null,null,null,null,null,null,47,14,76,31,15,13]
[null,null,null,null,null,null,null,null,30,42,77,45,47,3]
[null,null,null,null,null,null,null,null,24,40,6,71,26,96]
[null,null,null,null,null,null,null,null,82,72,67,6,42,39]
[null,null,null,null,null,null,null,null,9,17,68,80,72,4]
[null,null,null,null,null,null,null,null,6,72,54,79,41,77]
[null,null,null,null,null,null,null,null,56,20,92,81,54,24]
[null,null,null,null,null,null,null,null,39,68,76,87,70,7]
[null,null,null,null,null,null,null,null,17,12,54,71,76,34]
[null,null,null,null,null,null,null,null,38,76,13,76,76,56]
[null,null,null,null,null,null,null,null,41,32,70,46,28,68]
[null,null,null,null,null,null,null,null,49,5,44,52,66,57]
[null,null,null,null,null,null,null,null,11,10,19,57,98,5]
[null,null,null,null,null,null,null,null,2,83,25,44,80,56]
[null,null,null,null,null,null,null,null,4,3,83,80,97,85]
[null,null,null,null,null,null,null,null,32,9,3,99,88,38]
[null,null,null,null,null,null,null,null,69,64,24,26,24,42]
[null,null,null,null,null,null,null,null,24,29,45,87,7,77]
[null,null,null,null,null,null,null,null,37,29,75,57,47,76]
[null,null,null,null,null,null,null,null,84,39,99,48,48,10]
[null,null,null,null,null,null,null,null,56,27,59,48,6,37]
[null,null,null,null,null,null,null,null,32,9,71,53,87,48]
[null,null,null,null,null,null,null,null,45,26,39,57,54,40]
[null,null,null,null,null,null,null,null,27,38,41,91,58,89]
[null,null,null,null,null,null,null,null,79,93,87,27,7,4]
[null,null,null,null,null,null,null,null,6,26,88,87,77,83]
[null,null,null,null,null,null,null,null,97,82,74,18,33,18]
[null,null,null,null,null,null,null,null,60,80,53,37,82,100]
[null,null,null,null,null,null,null,null,33,53,99,49,55,27]
[null,null,null,null,null,null,null,null,26,39,19,78,10,31]
[null,null,null,null,null,null,null,null,75,5,27,86,89,49]
[null,null,null,null,null,null,null,null,9,24,22,68,85,23]
[null,null,null,null,null,null,null,null,51,44,64,33,94,11]
[null,null,null,null,null,null,null,null,25,17,80,10,46,21]
[null,null,null,null,null,null,null,null,28,72,49,65,64,16]
[null,null,null,null,null,null,null,null,76,60,51,85,85,50]
[null,null,null,null,null,null,null,null,56,98,76,79,29,29]
[null,null,null,null,null,null,null,null,38,85,21,15,22,14]
[null,null,null,null,null,null,null,null,16,81,40,67,91,97]
[null,null,null,null,null,null,null,null,89,62,6,58,99,27]
[null,null,null,null,null,null,null,null,10,91,6,23,81,78]
[null,null,null,null,null,null,null,null,50,77,86,18,1,58]

{"sheet":"03 Tastenkürzel_","index":10,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"03 Shortcuts_",null,null,null,{"$f":"B2","v":"03 Shortcuts_"}]
[2,"03 Tastenkürzel_"]
[]
[null,1,"In Excel gibt es eine ganze Reihe von Tastenkürzeln, die die tägliche Arbeit vereinfachen und beschleunigen.\nMit Strg-Umschalt-Pfeil_unten (bzw. _oben, _rechts, _links) können Sie eine Spalte einer Liste schnell markieren. Das ist bei sehr langen Listen enorm hilfreich.\nMit Strg-Umschalt-Pfeil_unten + Strg-Umschalt-Pfeil_rechts können Sie alle Spalten und Zeilen einer Liste markieren.\nNoch viel schneller geht das mit Strg-A!\n\nABER ACHTUNG: Das funktioniert immer nur bis zu einer Leerzelle in der Zeile und Spalte, in der sich die markierte Zelle befindet! Klingt unverständlich? Ok, ich zeig's Ihnen.\n\nSie müssen also gewährleisten, dass Ihre Liste in der ersten Spalte und in der ersten Zeile keine Leerzellen enthält.\n\nSie können dieses Tastenkürzel auch benutzen, um Leerzellen in Ihrer Liste aufzuspüren!",null,1,"In Excel there is a whole range of shortcuts that simplify and speed up your daily work.\nYou can use Ctrl-Shift-DownArrow (or -Up, -Right, -Left) to quickly select a column in a list. This is extremely helpful for very long lists.\nWith Ctrl-Shift-DownArrow + Ctrl-Shift-RightArrow you can mark all columns and rows of a list.\nThis is even faster with Ctrl-A!\n\nBUT ATTENTION: This only works up to one empty cell in the row and column in which the marked cell is located! Sounds incomprehensible? Ok, I'll show you.\n\nSo you have to make sure that your list does not contain any empty cells in the first column and the first line.\n\nYou can also use this shortcut to find empty cells in your list!"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Die Tastenkürzel für Copy&Paste kennt wahrscheinlich jeder!?\n\nStatt Strg-C können Sie auch Strg-X benutzen, wenn der Zellinhalt am Ursprungsort verschwinden soll (\"verschieben\" anstelle von \"kopieren\").\n\nDas Verschieben geht aber noch viel einfacher, wenn Sie die Zelle am Rand mit der Maus anfassen und dann an den neuen Ort bewegen.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"Everybody knows the shortcuts for Copy&Paste!\n\nInstead of Ctrl-C you can also use Ctrl-X if you want the cell content to disappear at the original location (\"move\" instead of \"copy\").\n\nBut moving is much easier if you grab the cell at the edge with the mouse and then move it to the new location."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Mit der Taste „Drucken“ bzw. mit der Tastenkombination „Alt-Drucken“ können Sie ein Bildschirmfoto anfertigen – und zwar entweder vom ganzen Bildschirm oder vom aktiven Fenster. Dieses Foto landet dann in der Zwischenablage. Da diese unsichtbar ist, sehen Sie zunächst keine Reaktion.\n\nAnschließend können Sie aber den Inhalt der Zwischenablage mit dem bekannten Tastenkürzel Strg-V in Excel oder in Powerpoint oder in Word einfügen.\n\nWenn Sie nicht das ganze Fenster, sondern nur einen rechteckigen Ausschnitt fotografieren wollen, müssen Sie das Windows-Snipping-Tool benutzen.",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"With the \"Print\" key or with the key combination \"Alt-Print\" you can take a screenshot - either of the whole screen or of the active window. This photo will then end up on the clipboard. As this is invisible, you will not see any reaction at first.\n\nAfterwards, however, you can paste the contents of the clipboard into Excel, PowerPoint or Word using the well-known shortcut Ctrl-V.\n\nIf you don't want to photograph the whole window but only a rectangular section, you have to use the Windows snipping tool."]
[null,4,"Mit der Tastenkombination Strg-Alt-Enter können Sie Matrixformeln eingeben. Das Thema würde hier den Rahmen sprengen. Ein Beispiel für eine Matrixformel finden Sie in meiner Übungsdatei „Statistics“ beim Thema „Klasseneinteilung“!\n\nIch arbeite auch ein einer extra Übungsdatei zum Thema „Matrixformeln“. Schauen Sie mal nach – vielleicht gibt es sie schon.",null,4,"You can enter matrix formulas with the key combination Ctrl-Alt-Enter. The topic would go beyond the scope here. You can find an example of a matrix formula in my exercise file \"Statistics\" in the topic \"Classes\"!\n\nI am also working on an extra exercise file on the topic \"Matrix formulas\". Have a look - maybe it already exist."]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"04 Funktionen Deutsch-Englisch","index":11,"n_rows":496,"n_cols":8,"rows_kept":496,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[null,null,null,null,null,0]
[1,"04 Functions German-English",null,null,null,"Back to Start"]
[2,"04 Funktionen Deutsch-Englisch",null,null,null,"Startseite"]
[]
[2,null,"Tolle Sache:","https://de.excel-translator.de/","!!!!"]
[]
[null,null,"Deutsch","Englisch",null,null,"English","German"]
[null,null,"A",null,null,null,"A"]
[null,null,"ABRUNDEN","ROUNDDOWN",null,null,"ABS","ABS"]
[null,null,"ABS","ABS",null,null,"ACCRINT","AUFGELZINS"]
[null,null,"ACHSENABSCHNITT","INTERCEPT",null,null,"ACCRINTM","AUFGELZINSF"]
[null,null,"ADRESSE","ADDRESS",null,null,"ACOS","ARCCOS"]
[null,null,"AGGREGAT","AGGREGATE",null,null,"ACOSH","ARCCOSHYP"]
[null,null,"AMORDEGRK","AMORDEGRC",null,null,"ACOT","ARCCOT"]
[null,null,"AMORLINEARK","AMORLINC",null,null,"ACOTH","ARCCOTHYP"]
[null,null,"ANZAHL","COUNT",null,null,"ADDRESS","ADRESSE"]
[null,null,"ANZAHL2","COUNTA",null,null,"AGGREGATE","AGGREGAT"]
[null,null,"ANZAHLLEEREZELLEN","COUNTBLANK",null,null,"AMORDEGRC","AMORDEGRK"]
[null,null,"ARABISCH","ARABIC",null,null,"AMORLINC","AMORLINEARK"]
[0,null,"ARBEITSTAG","WORKDAY",null,null,"AND","UND"]
[null,null,"ARBEITSTAG.INTL","WORKDAY.INTL",null,null,"ARABIC","ARABISCH"]
[null,null,"ARCCOS","ACOS",null,null,"AREAS","BEREICHE"]
[null,null,"ARCCOSHYP","ACOSH",null,null,"ASC","ASC"]
[null,null,"ARCCOT","ACOT",null,null,"ASIN","ARCSIN"]
[null,null,"ARCCOTHYP","ACOTH",null,null,"ASINH","ARCSINHYP"]
[null,null,"ARCSIN","ASIN",null,null,"ATAN","ARCTAN"]
[null,null,"ARCSINHYP","ASINH",null,null,"ATAN2","ARCTAN2"]
[null,null,"ARCTAN","ATAN",null,null,"ATANH","ARCTANHYP"]
[null,null,"ARCTAN2","ATAN2",null,null,"AVEDEV","MITTELABW"]
[null,null,"ARCTANHYP","ATANH",null,null,"AVERAGE","MITTELWERT"]
[null,null,"ASC","ASC",null,null,"AVERAGEA","MITTELWERTA"]
[null,null,"AUFGELZINS","ACCRINT",null,null,"AVERAGEIF","MITTELWERTWENN"]
[null,null,"AUFGELZINSF","ACCRINTM",null,null,"AVERAGEIFS","MITTELWERTWENNS"]
[null,null,"AUFRUNDEN","ROUNDUP",null,null,"B"]
[null,null,"AUSZAHLUNG","RECEIVED",null,null,"BAHTTEXT","BAHTTEXT"]
[null,null,"B",null,null,null,"BASE","BASIS"]
[null,null,"BAHTTEXT","BAHTTEXT",null,null,"BESSELI","BESSELI"]
[null,null,"BASIS","BASE",null,null,"BESSELJ","BESSELJ"]
[null,null,"BEREICH.VERSCHIEBEN","OFFSET",null,null,"BESSELK","BESSELK"]
[null,null,"BEREICHE","AREAS",null,null,"BESSELY","BESSELY"]
[null,null,"BESSELI","BESSELI",null,null,"BETA.DIST","BETA.VERT"]
[null,null,"BESSELJ","BESSELJ",null,null,"BETA.INV","BETA.INV"]
[null,null,"BESSELK","BESSELK",null,null,"BETADIST","BETAVERT"]
[null,null,"BESSELY","BESSELY",null,null,"BETAINV","BETAINV"]
[null,null,"BESTIMMTHEITSMASS","RSQ",null,null,"BIN2DEC","BININDEZ"]
[null,null,"BETA.INV","BETA.INV",null,null,"BIN2HEX","BININHEX"]
[null,null,"BETA.VERT","BETA.DIST",null,null,"BIN2OCT","BININOKT"]
[null,null,"BETAINV","BETAINV",null,null,"BINOM.DIST","BINOM.VERT"]
[null,null,"BETAVERT","BETADIST",null,null,"BINOM.DIST.RANGE","BINOM.VERT.BEREICH"]
[null,null,"BININDEZ","BIN2DEC",null,null,"BINOM.INV","BINOM.INV"]
[null,null,"BININHEX","BIN2HEX",null,null,"BINOMDIST","BINOMVERT"]
[null,null,"BININOKT","BIN2OCT",null,null,"BITAND","BITUND"]
[null,null,"BINOM.INV","BINOM.INV",null,null,"BITLSHIFT","BITLVERSCHIEB"]
[null,null,"BINOM.VERT","BINOM.DIST",null,null,"BITOR","BITODER"]
[null,null,"BINOM.VERT.BEREICH","BINOM.DIST.RANGE",null,null,"BITRSHIFT","BITRVERSCHIEB"]
[null,null,"BINOMVERT","BINOMDIST",null,null,"BITXOR","BITXODER"]
[null,null,"BITLVERSCHIEB","BITLSHIFT",null,null,"C"]
[null,null,"BITODER","BITOR",null,null,"CEILING","OBERGRENZE"]
[null,null,"BITRVERSCHIEB","BITRSHIFT",null,null,"CEILING.MATH","OBERGRENZE.MATHEMATIK"]
[null,null,"BITUND","BITAND",null,null,"CEILING.PRECISE","OBERGRENZE.GENAU"]
[null,null,"BITXODER","BITXOR",null,null,"CELL","ZELLE"]
[null,null,"BLATT","SHEET",null,null,"CHAR","ZEICHEN"]
[null,null,"BLÄTTER","SHEETS",null,null,"CHIDIST","CHIVERT"]
[null,null,"BOGENMASS","RADIANS",null,null,"CHIINV","CHIINV"]
[null,null,"BRTEILJAHRE","YEARFRAC",null,null,"CHISQ.DIST","CHIQU.VERT"]
[null,null,"BW","PV",null,null,"CHISQ.DIST.RT","CHIQU.VERT.RE"]
[null,null,"C",null,null,null,"CHISQ.INV","CHIQU.INV"]
[null,null,"CHIINV","CHIINV",null,null,"CHISQ.INV.RT","CHIQU.INV.RE"]
[null,null,"CHIQU.INV","CHISQ.INV",null,null,"CHISQ.TEST","CHIQU.TEST"]
[null,null,"CHIQU.INV.RE","CHISQ.INV.RT",null,null,"CHITEST","CHITEST"]
[null,null,"CHIQU.TEST","CHISQ.TEST",null,null,"CHOOSE","WAHL"]
[null,null,"CHIQU.VERT","CHISQ.DIST",null,null,"CLEAN","SÄUBERN"]
[null,null,"CHIQU.VERT.RE","CHISQ.DIST.RT",null,null,"CODE","CODE"]
[null,null,"CHITEST","CHITEST",null,null,"COLUMN","SPALTE"]
[null,null,"CHIVERT","CHIDIST",null,null,"COLUMNS","SPALTEN"]
[null,null,"CODE","CODE",null,null,"COMBIN","KOMBINATIONEN"]
[null,null,"COS","COS",null,null,"COMBINA","KOMBINATIONEN2"]
[null,null,"COSEC","CSC",null,null,"COMPLEX","KOMPLEXE"]
[null,null,"COSECHYP","CSCH",null,null,"CONCATENATE","VERKETTEN"]
[null,null,"COSHYP","COSH",null,null,"CONFIDENCE","KONFIDENZ"]
[null,null,"COT","COT",null,null,"CONFIDENCE.NORM","KONFIDENZ.NORM"]
[null,null,"COTHYP","COTH",null,null,"CONFIDENCE.T","KONFIDENZ.T"]
[null,null,"CUBEELEMENT","CUBEMEMBER",null,null,"CONVERT","UMWANDELN"]
[null,null,"CUBEELEMENTEIGENSCHAFT","CUBEMEMBERPROPERTY",null,null,"CORREL","KORREL"]
[null,null,"CUBEKPIELEMENT","CUBEKPIMEMBER",null,null,"COS","COS"]
[null,null,"CUBEMENGE","CUBESET",null,null,"COSH","COSHYP"]
[null,null,"CUBEMENGENANZAHL","CUBESETCOUNT",null,null,"COT","COT"]
[null,null,"CUBERANGELEMENT","CUBERANKEDMEMBER",null,null,"COTH","COTHYP"]
[null,null,"CUBEWERT","CUBEVALUE",null,null,"COUNT","ANZAHL"]
[null,null,"D",null,null,null,"COUNTA","ANZAHL2"]
[null,null,"DATEDIF","DATEDIF",null,null,"COUNTBLANK","ANZAHLLEEREZELLEN"]
[null,null,"DATUM","DATE",null,null,"COUNTIF","ZÄHLENWENN"]
[null,null,"DATWERT","DATEVALUE",null,null,"COUNTIFS","ZÄHLENWENNS"]
[null,null,"DBANZAHL","DCOUNT",null,null,"COUPDAYBS","ZINSTERMTAGVA"]
[null,null,"DBANZAHL2","DCOUNTA",null,null,"COUPDAYS","ZINSTERMTAGE"]
[null,null,"DBAUSZUG","DGET",null,null,"COUPDAYSNC","ZINSTERMTAGNZ"]
[null,null,"DBMAX","DMAX",null,null,"COUPNCD","ZINSTERMNZ"]
[null,null,"DBMIN","DMIN",null,null,"COUPNUM","ZINSTERMZAHL"]
[null,null,"DBMITTELWERT","DAVERAGE",null,null,"COUPPCD","ZINSTERMVZ"]
[null,null,"DBPRODUKT","DPRODUCT",null,null,"COVAR","KOVAR"]
[null,null,"DBSTDABW","DSTDEV",null,null,"COVARIANCE.P","KOVARIANZ.P"]
[null,null,"DBSTDABWN","DSTDEVP",null,null,"COVARIANCE.S","KOVARIANZ.S"]
[null,null,"DBSUMME","DSUM",null,null,"CRITBINOM","KRITBINOM"]
[null,null,"DBVARIANZ","DVAR",null,null,"CSC","COSEC"]
[null,null,"DBVARIANZEN","DVARP",null,null,"CSCH","COSECHYP"]
[null,null,"DELTA","DELTA",null,null,"CUBEKPIMEMBER","CUBEKPIELEMENT"]
[null,null,"DEZIMAL","DECIMAL",null,null,"CUBEMEMBER","CUBEELEMENT"]
[null,null,"DEZINBIN","DEC2BIN",null,null,"CUBEMEMBERPROPERTY","CUBEELEMENTEIGENSCHAFT"]
[null,null,"DEZINHEX","DEC2HEX",null,null,"CUBERANKEDMEMBER","CUBERANGELEMENT"]
[null,null,"DEZINOKT","DEC2OCT",null,null,"CUBESET","CUBEMENGE"]
[null,null,"DIA","SYD",null,null,"CUBESETCOUNT","CUBEMENGENANZAHL"]
[null,null,"DISAGIO","DISC",null,null,"CUBEVALUE","CUBEWERT"]
[null,null,"DM","DOLLAR",null,null,"CUMIPMT","KUMZINSZ"]
[null,null,"DURATION","DURATION",null,null,"CUMPRINC","KUMKAPITAL"]
[null,null,"E",null,null,null,"D"]
[null,null,"EDATUM","EDATE",null,null,"DATE","DATUM"]
[null,null,"EFFEKTIV","EFFECT",null,null,"DATEDIF","DATEDIF"]
[null,null,"ERSETZEN","REPLACE",null,null,"DATEVALUE","DATWERT"]
[null,null,"ERSETZENB","REPLACEB",null,null,"DAVERAGE","DBMITTELWERT"]
[null,null,"EXP","EXP",null,null,"DAY","TAG"]
[null,null,"EXPON.VERT","EXPON.DIST",null,null,"DAYS","TAGE"]
[null,null,"EXPONVERT","EXPONDIST",null,null,"DAYS360","TAGE360"]
[null,null,"F",null,null,null,"DB","GDA2"]
[null,null,"F.INV","F.INV",null,null,"DCOUNT","DBANZAHL"]
[null,null,"F.INV.RE","F.INV.RT",null,null,"DCOUNTA","DBANZAHL2"]
[null,null,"F.TEST","F.TEST",null,null,"DDB","GDA"]
[null,null,"F.VERT","F.DIST",null,null,"DEC2BIN","DEZINBIN"]
[null,null,"F.VERT.RE","F.DIST.RT",null,null,"DEC2HEX","DEZINHEX"]
[null,null,"FAKULTÄT","FACT",null,null,"DEC2OCT","DEZINOKT"]
[null,null,false,"FALSE",null,null,"DECIMAL","DEZIMAL"]
[null,null,"FEHLER.TYP","ERROR.TYPE",null,null,"DEGREES","GRAD"]
[null,null,"FEST","FIXED",null,null,"DELTA","DELTA"]
[null,null,"FINDEN","FIND",null,null,"DEVSQ","SUMQUADABW"]
[null,null,"FINDENB","FINDB",null,null,"DGET","DBAUSZUG"]
[null,null,"FINV","FINV",null,null,"DISC","DISAGIO"]
[null,null,"FISHER","FISHER",null,null,"DMAX","DBMAX"]
[null,null,"FISHERINV","FISHERINV",null,null,"DMIN","DBMIN"]
[null,null,"FORMELTEXT","FORMULATEXT",null,null,"DOLLAR","DM"]
[null,null,"FTEST","FTEST",null,null,"DOLLARDE","NOTIERUNGDEZ"]
[null,null,"FVERT","FDIST",null,null,"DOLLARFR","NOTIERUNGBRU"]
[null,null,"G",null,null,null,"DPRODUCT","DBPRODUKT"]
[null,null,"G.TEST","Z.TEST",null,null,"DSTDEV","DBSTDABW"]
[null,null,"GAMMA","GAMMA",null,null,"DSTDEVP","DBSTDABWN"]
[null,null,"GAMMA.INV","GAMMA.INV",null,null,"DSUM","DBSUMME"]
[null,null,"GAMMA.VERT","GAMMA.DIST",null,null,"DURATION","DURATION"]
[null,null,"GAMMAINV","GAMMAINV",null,null,"DVAR","DBVARIANZ"]
[null,null,"GAMMALN","GAMMALN",null,null,"DVARP","DBVARIANZEN"]
[null,null,"GAMMALN.GENAU","GAMMALN.PRECISE",null,null,"E"]
[null,null,"GAMMAVERT","GAMMADIST",null,null,"EDATE","EDATUM"]
[null,null,"GANZZAHL","INT",null,null,"EFFECT","EFFEKTIV"]
[null,null,"GAUSS","GAUSS",null,null,"ENCODEURL","URLCODIEREN"]
[null,null,"GAUSSF.GENAU","ERF.PRECISE",null,null,"EOMONTH","MONATSENDE"]
[null,null,"GAUSSFEHLER","ERF",null,null,"ERF","GAUSSFEHLER"]
[null,null,"GAUSSFKOMPL","ERFC",null,null,"ERF.PRECISE","GAUSSF.GENAU"]
[null,null,"GAUSSFKOMPL.GENAU","ERFC.PRECISE",null,null,"ERFC","GAUSSFKOMPL"]
[null,null,"GDA","DDB",null,null,"ERFC.PRECISE","GAUSSFKOMPL.GENAU"]
[null,null,"GDA2","DB",null,null,"ERROR.TYPE","FEHLER.TYP"]
[null,null,"GEOMITTEL","GEOMEAN",null,null,"EVEN","GERADE"]
[null,null,"GERADE","EVEN",null,null,"EXACT","IDENTISCH"]
[null,null,"GESTUTZTMITTEL","TRIMMEAN",null,null,"EXP","EXP"]
[null,null,"GGANZZAHL","GESTEP",null,null,"EXPON.DIST","EXPON.VERT"]
[null,null,"GGT","GCD",null,null,"EXPONDIST","EXPONVERT"]
[null,null,"GLÄTTEN","TRIM",null,null,"F"]
[null,null,"GRAD","DEGREES",null,null,"F.DIST","F.VERT"]
[null,null,"GROSS","UPPER",null,null,"F.DIST.RT","F.VERT.RE"]
[null,null,"GROSS2","PROPER",null,null,"F.INV","F.INV"]
[null,null,"GTEST","ZTEST",null,null,"F.INV.RT","F.INV.RE"]
[null,null,"H",null,null,null,"F.TEST","F.TEST"]
[null,null,"HARMITTEL","HARMEAN",null,null,"FACT","FAKULTÄT"]
[null,null,"HÄUFIGKEIT","FREQUENCY",null,null,"FACTDOUBLE","ZWEIFAKULTÄT"]
[null,null,"HEUTE","TODAY",null,null,"FALSE",false]
[null,null,"HEXINBIN","HEX2BIN",null,null,"FDIST","FVERT"]
[null,null,"HEXINDEZ","HEX2DEC",null,null,"FILTERXML","XMLFILTERN"]
[null,null,"HEXINOKT","HEX2OCT",null,null,"FIND","FINDEN"]
[null,null,"HYPERLINK","HYPERLINK",null,null,"FINDB","FINDENB"]
[null,null,"HYPGEOM.VERT","HYPGEOM.DIST",null,null,"FINV","FINV"]
[null,null,"HYPGEOMVERT","HYPGEOMDIST",null,null,"FISHER","FISHER"]
[null,null,"I",null,null,null,"FISHERINV","FISHERINV"]
[null,null,"IDENTISCH","EXACT",null,null,"FIXED","FEST"]
[null,null,"IKV","IRR",null,null,"FLOOR","UNTERGRENZE"]
[null,null,"IMABS","IMABS",null,null,"FLOOR.MATH","UNTERGRENZE.MATHEMATIK"]
[null,null,"IMAGINÄRTEIL","IMAGINARY",null,null,"FLOOR.PRECISE","UNTERGRENZE.GENAU"]
[null,null,"IMAPOTENZ","IMPOWER",null,null,"FORECAST","SCHÄTZER"]
[null,null,"IMARGUMENT","IMARGUMENT",null,null,"FORMULATEXT","FORMELTEXT"]
[null,null,"IMCOS","IMCOS",null,null,"FREQUENCY","HÄUFIGKEIT"]
[null,null,"IMCOSEC","IMCSC",null,null,"FTEST","FTEST"]
[null,null,"IMCOSECHYP","IMCSCH",null,null,"FV","ZW"]
[null,null,"IMCOSHYP","IMCOSH",null,null,"FVSCHEDULE","ZW2"]
[null,null,"IMCOT","IMCOT",null,null,"G"]
[null,null,"IMDIV","IMDIV",null,null,"GAMMA","GAMMA"]
[null,null,"IMEXP","IMEXP",null,null,"GAMMA.DIST","GAMMA.VERT"]
[null,null,"IMKONJUGIERTE","IMCONJUGATE",null,null,"GAMMA.INV","GAMMA.INV"]
[null,null,"IMLN","IMLN",null,null,"GAMMADIST","GAMMAVERT"]
[null,null,"IMLOG10","IMLOG10",null,null,"GAMMAINV","GAMMAINV"]
[null,null,"IMLOG2","IMLOG2",null,null,"GAMMALN","GAMMALN"]
[null,null,"IMPRODUKT","IMPRODUCT",null,null,"GAMMALN.PRECISE","GAMMALN.GENAU"]
[null,null,"IMREALTEIL","IMREAL",null,null,"GAUSS","GAUSS"]
[null,null,"IMSEC","IMSEC",null,null,"GCD","GGT"]
[null,null,"IMSECHYP","IMSECH",null,null,"GEOMEAN","GEOMITTEL"]
[null,null,"IMSIN","IMSIN",null,null,"GESTEP","GGANZZAHL"]
[null,null,"IMSINHYP","IMSINH",null,null,"GETPIVOTDATA","PIVOTDATENZUORDNEN"]
[null,null,"IMSUB","IMSUB",null,null,"GROWTH","VARIATION"]
[null,null,"IMSUMME","IMSUM",null,null,"H"]
[null,null,"IMTAN","IMTAN",null,null,"HARMEAN","HARMITTEL"]
[null,null,"IMWURZEL","IMSQRT",null,null,"HEX2BIN","HEXINBIN"]
[null,null,"INDEX","INDEX",null,null,"HEX2DEC","HEXINDEZ"]
[null,null,"INDIREKT","INDIRECT",null,null,"HEX2OCT","HEXINOKT"]
[null,null,"INFO","INFO",null,null,"HLOOKUP","WVERWEIS"]
[null,null,"ISO.OBERGRENZE","ISO.CEILING",null,null,"HOUR","STUNDE"]
[null,null,"ISOKALENDERWOCHE","ISOWEEKNUM",null,null,"HYPERLINK","HYPERLINK"]
[null,null,"ISPMT","ISPMT",null,null,"HYPGEOM.DIST","HYPGEOM.VERT"]
[null,null,"ISTBEZUG","ISREF",null,null,"HYPGEOMDIST","HYPGEOMVERT"]
[null,null,"ISTFEHL","ISERR",null,null,"I"]
[null,null,"ISTFEHLER","ISERROR",null,null,"IF","WENN"]
[null,null,"ISTFORMEL","ISFORMULA",null,null,"IFERROR","WENNFEHLER"]
[null,null,"ISTGERADE","ISEVEN",null,null,"IFNA","WENNNV"]
[null,null,"ISTKTEXT","ISNONTEXT",null,null,"IMABS","IMABS"]
[null,null,"ISTLEER","ISBLANK",null,null,"IMAGINARY","IMAGINÄRTEIL"]
[null,null,"ISTLOG","ISLOGICAL",null,null,"IMARGUMENT","IMARGUMENT"]
[null,null,"ISTNV","ISNA",null,null,"IMCONJUGATE","IMKONJUGIERTE"]
[null,null,"ISTTEXT","ISTEXT",null,null,"IMCOS","IMCOS"]
[null,null,"ISTUNGERADE","ISODD",null,null,"IMCOSH","IMCOSHYP"]
[null,null,"ISTZAHL","ISNUMBER",null,null,"IMCOT","IMCOT"]
[null,null,"J",null,null,null,"IMCSC","IMCOSEC"]
[null,null,"JAHR","YEAR",null,null,"IMCSCH","IMCOSECHYP"]
[null,null,"JETZT","NOW",null,null,"IMDIV","IMDIV"]
[null,null,"JIS","JIS",null,null,"IMEXP","IMEXP"]
[null,null,"K",null,null,null,"IMLN","IMLN"]
[null,null,"KALENDERWOCHE","WEEKNUM",null,null,"IMLOG10","IMLOG10"]
[null,null,"KAPZ","PPMT",null,null,"IMLOG2","IMLOG2"]
[null,null,"KGRÖSSTE","LARGE",null,null,"IMPOWER","IMAPOTENZ"]
[null,null,"KGV","LCM",null,null,"IMPRODUCT","IMPRODUKT"]
[null,null,"KKLEINSTE","SMALL",null,null,"IMREAL","IMREALTEIL"]
[null,null,"KLEIN","LOWER",null,null,"IMSEC","IMSEC"]
[null,null,"KOMBINATIONEN","COMBIN",null,null,"IMSECH","IMSECHYP"]
[null,null,"KOMBINATIONEN2","COMBINA",null,null,"IMSIN","IMSIN"]
[null,null,"KOMPLEXE","COMPLEX",null,null,"IMSINH","IMSINHYP"]
[null,null,"KONFIDENZ","CONFIDENCE",null,null,"IMSQRT","IMWURZEL"]
[null,null,"KONFIDENZ.NORM","CONFIDENCE.NORM",null,null,"IMSUB","IMSUB"]
[null,null,"KONFIDENZ.T","CONFIDENCE.T",null,null,"IMSUM","IMSUMME"]
[null,null,"KORREL","CORREL",null,null,"IMTAN","IMTAN"]
[null,null,"KOVAR","COVAR",null,null,"INDEX","INDEX"]
[null,null,"KOVARIANZ.P","COVARIANCE.P",null,null,"INDIRECT","INDIREKT"]
[null,null,"KOVARIANZ.S","COVARIANCE.S",null,null,"INFO","INFO"]
[null,null,"KRITBINOM","CRITBINOM",null,null,"INT","GANZZAHL"]
[null,null,"KUMKAPITAL","CUMPRINC",null,null,"INTERCEPT","ACHSENABSCHNITT"]
[null,null,"KUMZINSZ","CUMIPMT",null,null,"INTRATE","ZINSSATZ"]
[null,null,"KURS","PRICE",null,null,"IPMT","ZINSZ"]
[null,null,"KURSDISAGIO","PRICEDISC",null,null,"IRR","IKV"]
[null,null,"KURSFÄLLIG","PRICEMAT",null,null,"ISBLANK","ISTLEER"]
[null,null,"KURT","KURT",null,null,"ISERR","ISTFEHL"]
[null,null,"KÜRZEN","TRUNC",null,null,"ISERROR","ISTFEHLER"]
[null,null,"L",null,null,null,"ISEVEN","ISTGERADE"]
[null,null,"LÄNGE","LEN",null,null,"ISFORMULA","ISTFORMEL"]
[null,null,"LÄNGEB","LENB",null,null,"ISLOGICAL","ISTLOG"]
[null,null,"LIA","SLN",null,null,"ISNA","ISTNV"]
[null,null,"LINKS","LEFT",null,null,"ISNONTEXT","ISTKTEXT"]
[null,null,"LINKSB","LEFTB",null,null,"ISNUMBER","ISTZAHL"]
[null,null,"LN","LN",null,null,"ISO.CEILING","ISO.OBERGRENZE"]
[null,null,"LOG","LOG",null,null,"ISODD","ISTUNGERADE"]
[null,null,"LOG10","LOG10",null,null,"ISOWEEKNUM","ISOKALENDERWOCHE"]
[null,null,"LOGINV","LOGINV",null,null,"ISPMT","ISPMT"]
[null,null,"LOGNORM.INV","LOGNORM.INV",null,null,"ISREF","ISTBEZUG"]
[null,null,"LOGNORM.VERT","LOGNORM.DIST",null,null,"ISTEXT","ISTTEXT"]
[null,null,"LOGNORMVERT","LOGNORMDIST",null,null,"J"]
[null,null,"M",null,null,null,"JIS","JIS"]
[null,null,"MAX","MAX",null,null,"K"]
[null,null,"MAXA","MAXA",null,null,"KURT","KURT"]
[null,null,"MDET","MDETERM",null,null,"L"]
[null,null,"MDURATION","MDURATION",null,null,"LARGE","KGRÖSSTE"]
[null,null,"MEDIAN","MEDIAN",null,null,"LCM","KGV"]
[null,null,"MEINHEIT","MUNIT",null,null,"LEFT","LINKS"]
[null,null,"MIN","MIN",null,null,"LEFTB","LINKSB"]
[null,null,"MINA","MINA",null,null,"LEN","LÄNGE"]
[null,null,"MINUTE","MINUTE",null,null,"LENB","LÄNGEB"]
[null,null,"MINV","MINVERSE",null,null,"LINEST","RGP"]
[null,null,"MITTELABW","AVEDEV",null,null,"LN","LN"]
[null,null,"MITTELWERT","AVERAGE",null,null,"LOG","LOG"]
[null,null,"MITTELWERTA","AVERAGEA",null,null,"LOG10","LOG10"]
[null,null,"MITTELWERTWENN","AVERAGEIF",null,null,"LOGEST","RKP"]
[null,null,"MITTELWERTWENNS","AVERAGEIFS",null,null,"LOGINV","LOGINV"]
[null,null,"MMULT","MMULT",null,null,"LOGNORM.DIST","LOGNORM.VERT"]
[null,null,"MODALWERT","MODE",null,null,"LOGNORM.INV","LOGNORM.INV"]
[null,null,"MODUS.EINF","MODE.SNGL",null,null,"LOGNORMDIST","LOGNORMVERT"]
[null,null,"MODUS.VIELF","MODE.MULT",null,null,"LOOKUP","VERWEIS"]
[null,null,"MONAT","MONTH",null,null,"LOWER","KLEIN"]
[null,null,"MONATSENDE","EOMONTH",null,null,"M"]
[null,null,"MTRANS","TRANSPOSE",null,null,"MATCH","VERGLEICH"]
[null,null,"N",null,null,null,"MAX","MAX"]
[null,null,"N","N",null,null,"MAXA","MAXA"]
[null,null,"NBW","NPV",null,null,"MDETERM","MDET"]
[null,null,"NEGBINOM.VERT","NEGBINOM.DIST",null,null,"MDURATION","MDURATION"]
[null,null,"NEGBINOMVERT","NEGBINOMDIST",null,null,"MEDIAN","MEDIAN"]
[null,null,"NETTOARBEITSTAGE","NETWORKDAYS",null,null,"MID","TEIL"]
[null,null,"NETTOARBEITSTAGE.INTL","NETWORKDAYS.INTL",null,null,"MIDB","TEILB"]
[null,null,"NICHT","NOT",null,null,"MIN","MIN"]
[null,null,"NOMINAL","NOMINAL",null,null,"MINA","MINA"]
[null,null,"NORM.INV","NORM.INV",null,null,"MINUTE","MINUTE"]
[null,null,"NORM.S.INV","NORM.S.INV",null,null,"MINVERSE","MINV"]
[null,null,"NORM.S.VERT","NORM.S.DIST",null,null,"MIRR","QIKV"]
[null,null,"NORM.VERT","NORM.DIST",null,null,"MMULT","MMULT"]
[null,null,"NORMINV","NORMINV",null,null,"MOD","REST"]
[null,null,"NORMVERT","NORMDIST",null,null,"MODE","MODALWERT"]
[null,null,"NOTIERUNGBRU","DOLLARFR",null,null,"MODE.MULT","MODUS.VIELF"]
[null,null,"NOTIERUNGDEZ","DOLLARDE",null,null,"MODE.SNGL","MODUS.EINF"]
[null,null,"NV","NA",null,null,"MONTH","MONAT"]
[null,null,"O",null,null,null,"MROUND","VRUNDEN"]
[null,null,"OBERGRENZE","CEILING",null,null,"MULTINOMIAL","POLYNOMIAL"]
[null,null,"OBERGRENZE.GENAU","CEILING.PRECISE",null,null,"MUNIT","MEINHEIT"]
[null,null,"OBERGRENZE.MATHEMATIK","CEILING.MATH",null,null,"N"]
[null,null,"ODER","OR",null,null,"N","N"]
[null,null,"OKTINBIN","OCT2BIN",null,null,"NA","NV"]
[null,null,"OKTINDEZ","OCT2DEC",null,null,"NEGBINOM.DIST","NEGBINOM.VERT"]
[null,null,"OKTINHEX","OCT2HEX",null,null,"NEGBINOMDIST","NEGBINOMVERT"]
[null,null,"P",null,null,null,"NETWORKDAYS","NETTOARBEITSTAGE"]
[null,null,"PDURATION","PDURATION",null,null,"NETWORKDAYS.INTL","NETTOARBEITSTAGE.INTL"]
[null,null,"PEARSON","PEARSON",null,null,"NOMINAL","NOMINAL"]
[null,null,"PHI","PHI",null,null,"NORM.DIST","NORM.VERT"]
[null,null,"PHONETIC","PHONETIC",null,null,"NORM.INV","NORM.INV"]
[null,null,"PI","PI",null,null,"NORM.S.DIST","NORM.S.VERT"]
[null,null,"PIVOTDATENZUORDNEN","GETPIVOTDATA",null,null,"NORM.S.INV","NORM.S.INV"]
[null,null,"POISSON","POISSON",null,null,"NORMDIST","NORMVERT"]
[null,null,"POISSON.VERT","POISSON.DIST",null,null,"NORMINV","NORMINV"]
[null,null,"POLYNOMIAL","MULTINOMIAL",null,null,"NORMSDIST","STANDNORMVERT"]
[null,null,"POTENZ","POWER",null,null,"NORMSINV","STANDNORMINV"]
[null,null,"POTENZREIHE","SERIESSUM",null,null,"NOT","NICHT"]
[null,null,"PRODUKT","PRODUCT",null,null,"NOW","JETZT"]
[null,null,"Q",null,null,null,"NPER","ZZR"]
[null,null,"QIKV","MIRR",null,null,"NPV","NBW"]
[null,null,"QUADRATESUMME","SUMSQ",null,null,"NUMBERVALUE","ZAHLENWERT"]
[null,null,"QUANTIL","PERCENTILE",null,null,"O"]
[null,null,"QUANTIL.EXKL","PERCENTILE.EXC",null,null,"OCT2BIN","OKTINBIN"]
[null,null,"QUANTIL.INKL","PERCENTILE.INC",null,null,"OCT2DEC","OKTINDEZ"]
[null,null,"QUANTILSRANG","PERCENTRANK",null,null,"OCT2HEX","OKTINHEX"]
[null,null,"QUANTILSRANG.EXKL","PERCENTRANK.EXC",null,null,"ODD","UNGERADE"]
[null,null,"QUANTILSRANG.INKL","PERCENTRANK.INC",null,null,"ODDFPRICE","UNREGER.KURS"]
[null,null,"QUARTILE","QUARTILE",null,null,"ODDFYIELD","UNREGER.REND"]
[null,null,"QUARTILE.EXKL","QUARTILE.EXC",null,null,"ODDLPRICE","UNREGLE.KURS"]
[null,null,"QUARTILE.INKL","QUARTILE.INC",null,null,"ODDLYIELD","UNREGLE.REND"]
[null,null,"QUOTIENT","QUOTIENT",null,null,"OFFSET","BEREICH.VERSCHIEBEN"]
[null,null,"R",null,null,null,"OR","ODER"]
[null,null,"RANG","RANK",null,null,"P"]
[null,null,"RANG.GLEICH","RANK.EQ",null,null,"PDURATION","PDURATION"]
[null,null,"RANG.MITTELW","RANK.AVG",null,null,"PEARSON","PEARSON"]
[null,null,"RECHTS","RIGHT",null,null,"PERCENTILE","QUANTIL"]
[null,null,"RECHTSB","RIGHTB",null,null,"PERCENTILE.EXC","QUANTIL.EXKL"]
[null,null,"RENDITE","YIELD",null,null,"PERCENTILE.INC","QUANTIL.INKL"]
[null,null,"RENDITEDIS","YIELDDISC",null,null,"PERCENTRANK","QUANTILSRANG"]
[null,null,"RENDITEFÄLL","YIELDMAT",null,null,"PERCENTRANK.EXC","QUANTILSRANG.EXKL"]
[null,null,"REST","MOD",null,null,"PERCENTRANK.INC","QUANTILSRANG.INKL"]
[null,null,"RGP","LINEST",null,null,"PERMUT","VARIATIONEN"]
[null,null,"RKP","LOGEST",null,null,"PERMUTATIONA","VARIATIONEN2"]
[null,null,"RMZ","PMT",null,null,"PHI","PHI"]
[null,null,"RÖMISCH","ROMAN",null,null,"PHONETIC","PHONETIC"]
[null,null,"RTD","RTD",null,null,"PI","PI"]
[null,null,"RUNDEN","ROUND",null,null,"PMT","RMZ"]
[null,null,"S",null,null,null,"POISSON","POISSON"]
[null,null,"SÄUBERN","CLEAN",null,null,"POISSON.DIST","POISSON.VERT"]
[null,null,"SCHÄTZER","FORECAST",null,null,"POWER","POTENZ"]
[null,null,"SCHIEFE","SKEW",null,null,"PPMT","KAPZ"]
[null,null,"SCHIEFE.P","SKEW.P",null,null,"PRICE","KURS"]
[null,null,"SEC","SEC",null,null,"PRICEDISC","KURSDISAGIO"]
[null,null,"SECHYP","SECH",null,null,"PRICEMAT","KURSFÄLLIG"]
[null,null,"SEKUNDE","SECOND",null,null,"PROB","WAHRSCHBEREICH"]
[null,null,"SIN","SIN",null,null,"PRODUCT","PRODUKT"]
[null,null,"SINHYP","SINH",null,null,"PROPER","GROSS2"]
[null,null,"SPALTE","COLUMN",null,null,"PV","BW"]
[null,null,"SPALTEN","COLUMNS",null,null,"Q"]
[null,null,"STABW","STDEV",null,null,"QUARTILE","QUARTILE"]
[null,null,"STABW.N","STDEV.P",null,null,"QUARTILE.EXC","QUARTILE.EXKL"]
[null,null,"STABW.S","STDEV.S",null,null,"QUARTILE.INC","QUARTILE.INKL"]
[null,null,"STABWA","STDEVA",null,null,"QUOTIENT","QUOTIENT"]
[null,null,"STABWN","STDEVP",null,null,"R"]
[null,null,"STABWNA","STDEVPA",null,null,"RADIANS","BOGENMASS"]
[null,null,"STANDARDISIERUNG","STANDARDIZE",null,null,"RAND","ZUFALLSZAHL"]
[null,null,"STANDNORMINV","NORMSINV",null,null,"RANDBETWEEN","ZUFALLSBEREICH"]
[null,null,"STANDNORMVERT","NORMSDIST",null,null,"RANK","RANG"]
[null,null,"STEIGUNG","SLOPE",null,null,"RANK.AVG","RANG.MITTELW"]
[null,null,"STFEHLERYX","STEYX",null,null,"RANK.EQ","RANG.GLEICH"]
[null,null,"STUNDE","HOUR",null,null,"RATE","ZINS"]
[null,null,"SUCHEN","SEARCH",null,null,"RECEIVED","AUSZAHLUNG"]
[null,null,"SUCHENB","SEARCHB",null,null,"REPLACE","ERSETZEN"]
[null,null,"SUMME","SUM",null,null,"REPLACEB","ERSETZENB"]
[null,null,"SUMMENPRODUKT","SUMPRODUCT",null,null,"REPT","WIEDERHOLEN"]
[null,null,"SUMMEWENN","SUMIF",null,null,"RIGHT","RECHTS"]
[null,null,"SUMMEWENNS","SUMIFS",null,null,"RIGHTB","RECHTSB"]
[null,null,"SUMMEX2MY2","SUMX2MY2",null,null,"ROMAN","RÖMISCH"]
[null,null,"SUMMEX2PY2","SUMX2PY2",null,null,"ROUND","RUNDEN"]
[null,null,"SUMMEXMY2","SUMXMY2",null,null,"ROUNDDOWN","ABRUNDEN"]
[null,null,"SUMQUADABW","DEVSQ",null,null,"ROUNDUP","AUFRUNDEN"]
[null,null,"SVERWEIS","VLOOKUP",null,null,"ROW","ZEILE"]
[null,null,"T",null,null,null,"ROWS","ZEILEN"]
[null,null,"T","T",null,null,"RRI","ZSATZINVEST"]
[null,null,"T.INV","T.INV",null,null,"RSQ","BESTIMMTHEITSMASS"]
[null,null,"T.INV.2S","T.INV.2T",null,null,"RTD","RTD"]
[null,null,"T.TEST","T.TEST",null,null,"S"]
[null,null,"T.VERT","T.DIST",null,null,"SEARCH","SUCHEN"]
[null,null,"T.VERT.2S","T.DIST.2T",null,null,"SEARCHB","SUCHENB"]
[null,null,"T.VERT.RE","T.DIST.RT",null,null,"SEC","SEC"]
[null,null,"TAG","DAY",null,null,"SECH","SECHYP"]
[null,null,"TAGE","DAYS",null,null,"SECOND","SEKUNDE"]
[null,null,"TAGE360","DAYS360",null,null,"SERIESSUM","POTENZREIHE"]
[null,null,"TAN","TAN",null,null,"SHEET","BLATT"]
[null,null,"TANHYP","TANH",null,null,"SHEETS","BLÄTTER"]
[null,null,"TBILLÄQUIV","TBILLEQ",null,null,"SIGN","VORZEICHEN"]
[null,null,"TBILLKURS","TBILLPRICE",null,null,"SIN","SIN"]
[null,null,"TBILLRENDITE","TBILLYIELD",null,null,"SINH","SINHYP"]
[null,null,"TEIL","MID",null,null,"SKEW","SCHIEFE"]
[null,null,"TEILB","MIDB",null,null,"SKEW.P","SCHIEFE.P"]
[null,null,"TEILERGEBNIS","SUBTOTAL",null,null,"SLN","LIA"]
[null,null,"TEXT","TEXT",null,null,"SLOPE","STEIGUNG"]
[null,null,"TINV","TINV",null,null,"SMALL","KKLEINSTE"]
[null,null,"TREND","TREND",null,null,"SQRT","WURZEL"]
[null,null,"TTEST","TTEST",null,null,"SQRTPI","WURZELPI"]
[null,null,"TVERT","TDIST",null,null,"STANDARDIZE","STANDARDISIERUNG"]
[null,null,"TYP","TYPE",null,null,"STDEV","STABW"]
[null,null,"U",null,null,null,"STDEV.P","STABW.N"]
[null,null,"UMWANDELN","CONVERT",null,null,"STDEV.S","STABW.S"]
[null,null,"UND","AND",null,null,"STDEVA","STABWA"]
[null,null,"UNGERADE","ODD",null,null,"STDEVP","STABWN"]
[null,null,"UNICODE","UNICODE",null,null,"STDEVPA","STABWNA"]
[null,null,"UNIZEICHEN","UNICHAR",null,null,"STEYX","STFEHLERYX"]
[null,null,"UNREGER.KURS","ODDFPRICE",null,null,"SUBSTITUTE","WECHSELN"]
[null,null,"UNREGER.REND","ODDFYIELD",null,null,"SUBTOTAL","TEILERGEBNIS"]
[null,null,"UNREGLE.KURS","ODDLPRICE",null,null,"SUM","SUMME"]
[null,null,"UNREGLE.REND","ODDLYIELD",null,null,"SUMIF","SUMMEWENN"]
[null,null,"UNTERGRENZE","FLOOR",null,null,"SUMIFS","SUMMEWENNS"]
[null,null,"UNTERGRENZE.GENAU","FLOOR.PRECISE",null,null,"SUMPRODUCT","SUMMENPRODUKT"]
[null,null,"UNTERGRENZE.MATHEMATIK","FLOOR.MATH",null,null,"SUMSQ","QUADRATESUMME"]
[null,null,"URLCODIEREN","ENCODEURL",null,null,"SUMX2MY2","SUMMEX2MY2"]
[null,null,"USDOLLAR","USDOLLAR",null,null,"SUMX2PY2","SUMMEX2PY2"]
[null,null,"V",null,null,null,"SUMXMY2","SUMMEXMY2"]
[null,null,"VAR.P","VAR.P",null,null,"SYD","DIA"]
[null,null,"VAR.S","VAR.S",null,null,"T"]
[null,null,"VARIANZ","VAR",null,null,"T","T"]
[null,null,"VARIANZA","VARA",null,null,"T.DIST","T.VERT"]
[null,null,"VARIANZEN","VARP",null,null,"T.DIST.2T","T.VERT.2S"]
[null,null,"VARIANZENA","VARPA",null,null,"T.DIST.RT","T.VERT.RE"]
[null,null,"VARIATION","GROWTH",null,null,"T.INV","T.INV"]
[null,null,"VARIATIONEN","PERMUT",null,null,"T.INV.2T","T.INV.2S"]
[null,null,"VARIATIONEN2","PERMUTATIONA",null,null,"T.TEST","T.TEST"]
[null,null,"VDB","VDB",null,null,"TAN","TAN"]
[null,null,"VERGLEICH","MATCH",null,null,"TANH","TANHYP"]
[null,null,"VERKETTEN","CONCATENATE",null,null,"TBILLEQ","TBILLÄQUIV"]
[null,null,"VERWEIS","LOOKUP",null,null,"TBILLPRICE","TBILLKURS"]
[null,null,"VORZEICHEN","SIGN",null,null,"TBILLYIELD","TBILLRENDITE"]
[null,null,"VRUNDEN","MROUND",null,null,"TDIST","TVERT"]
[null,null,"W",null,null,null,"TEXT","TEXT"]
[null,null,"WAHL","CHOOSE",null,null,"TIME","ZEIT"]
[null,null,true,"TRUE",null,null,"TIMEVALUE","ZEITWERT"]
[null,null,"WAHRSCHBEREICH","PROB",null,null,"TINV","TINV"]
[null,null,"WEBDIENST","WEBSERVICE",null,null,"TODAY","HEUTE"]
[null,null,"WECHSELN","SUBSTITUTE",null,null,"TRANSPOSE","MTRANS"]
[null,null,"WEIBULL","WEIBULL",null,null,"TREND","TREND"]
[null,null,"WEIBULL.VERT","WEIBULL.DIST",null,null,"TRIM","GLÄTTEN"]
[null,null,"WENN","IF",null,null,"TRIMMEAN","GESTUTZTMITTEL"]
[null,null,"WENNFEHLER","IFERROR",null,null,"TRUE",true]
[null,null,"WENNNV","IFNA",null,null,"TRUNC","KÜRZEN"]
[null,null,"WERT","VALUE",null,null,"TTEST","TTEST"]
[null,null,"WIEDERHOLEN","REPT",null,null,"TYPE","TYP"]
[null,null,"WOCHENTAG","WEEKDAY",null,null,"U"]
[null,null,"WURZEL","SQRT",null,null,"UNICHAR","UNIZEICHEN"]
[null,null,"WURZELPI","SQRTPI",null,null,"UNICODE","UNICODE"]
[null,null,"WVERWEIS","HLOOKUP",null,null,"UPPER","GROSS"]
[null,null,"X",null,null,null,"USDOLLAR","USDOLLAR"]
[null,null,"XINTZINSFUSS","XIRR",null,null,"V"]
[null,null,"XKAPITALWERT","XNPV",null,null,"VALUE","WERT"]
[null,null,"XMLFILTERN","FILTERXML",null,null,"VAR","VARIANZ"]
[null,null,"XODER","XOR",null,null,"VAR.P","VAR.P"]
[null,null,"Z",null,null,null,"VAR.S","VAR.S"]
[null,null,"ZÄHLENWENN","COUNTIF",null,null,"VARA","VARIANZA"]
[null,null,"ZÄHLENWENNS","COUNTIFS",null,null,"VARP","VARIANZEN"]
[null,null,"ZAHLENWERT","NUMBERVALUE",null,null,"VARPA","VARIANZENA"]
[null,null,"ZEICHEN","CHAR",null,null,"VDB","VDB"]
[null,null,"ZEILE","ROW",null,null,"VLOOKUP","SVERWEIS"]
[null,null,"ZEILEN","ROWS",null,null,"W"]
[null,null,"ZEIT","TIME",null,null,"WEBSERVICE","WEBDIENST"]
[null,null,"ZEITWERT","TIMEVALUE",null,null,"WEEKDAY","WOCHENTAG"]
[null,null,"ZELLE","CELL",null,null,"WEEKNUM","KALENDERWOCHE"]
[null,null,"ZINS","RATE",null,null,"WEIBULL","WEIBULL"]
[null,null,"ZINSSATZ","INTRATE",null,null,"WEIBULL.DIST","WEIBULL.VERT"]
[null,null,"ZINSTERMNZ","COUPNCD",null,null,"WORKDAY","ARBEITSTAG"]
[null,null,"ZINSTERMTAGE","COUPDAYS",null,null,"WORKDAY.INTL","ARBEITSTAG.INTL"]
[null,null,"ZINSTERMTAGNZ","COUPDAYSNC",null,null,"X"]
[null,null,"ZINSTERMTAGVA","COUPDAYBS",null,null,"XIRR","XINTZINSFUSS"]
[null,null,"ZINSTERMVZ","COUPPCD",null,null,"XNPV","XKAPITALWERT"]
[null,null,"ZINSTERMZAHL","COUPNUM",null,null,"XOR","XODER"]
[null,null,"ZINSZ","IPMT",null,null,"Y"]
[null,null,"ZSATZINVEST","RRI",null,null,"YEAR","JAHR"]
[null,null,"ZUFALLSBEREICH","RANDBETWEEN",null,null,"YEARFRAC","BRTEILJAHRE"]
[null,null,"ZUFALLSZAHL","RAND",null,null,"YIELD","RENDITE"]
[null,null,"ZW","FV",null,null,"YIELDDISC","RENDITEDIS"]
[null,null,"ZW2","FVSCHEDULE",null,null,"YIELDMAT","RENDITEFÄLL"]
[null,null,"ZWEIFAKULTÄT","FACTDOUBLE",null,null,"Z"]
[null,null,"ZZR","NPER",null,null,"Z.TEST","G.TEST"]
[null,null,null,null,null,null,"ZTEST","GTEST"]

{"sheet":"05 Formel kopieren","index":12,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[29,1,29,3],[41,2,41,7],[42,2,42,7],[1,1,1,4],[2,1,2,4],[15,1,15,3],[16,1,16,3],[28,1,28,3]]}
[null,null,null,null,null,0]
[1,"05 Copy a formula",null,null,null,"Back to Start"]
[2,"05 Formel kopieren",null,null,null,"Startseite"]
[]
[]
[null,null,"category","Federal Shipping","Speedy Express","United Package","total"]
[null,null,"beverages",91505.909999999989,57741.67,118620.58000000002,{"$f":"SUM(D7:F7)","v":267868.16000000003}]
[null,null,"cereals",24711.75,29587.510000000002,41445.329999999994]
[null,null,"meat",47602.989999999991,31138.79,84280.59]
[null,null,"milk products",64693.600000000006,78517.760000000009,91243.4]
[null,null,"natural products",34038.799999999996,24226.03,41719.740000000005]
[null,null,"sea food",40459.339999999997,37687.72,53114.67]
[null,null,"spices",27509.649999999998,39674.720000000008,38862.699999999997]
[null,null,"sweets",52830.89,50265.709999999992,64260.590000000011]
[]
[2,"Falsch (mit linker Maustaste):"]
[1,"Wrong (with left mouse button):"]
[]
[null,null,"category","Federal Shipping","Speedy Express","United Package","total"]
[null,null,"beverages",91505.909999999989,57741.67,118620.58000000002,{"$f":"SUM(D20:F20)","v":267868.16000000003}]
[null,null,"cereals",24711.75,29587.510000000002,41445.329999999994,{"$f":"SUM(D21:F21)","v":95744.59}]
[null,null,"meat",47602.989999999991,31138.79,84280.59,163022.37]
[null,null,"milk products",64693.600000000006,78517.760000000009,91243.4,234454.76]
[null,null,"natural products",34038.799999999996,24226.03,41719.740000000005,99984.57]
[null,null,"sea food",40459.339999999997,37687.72,53114.67,131261.72999999998]
[null,null,"spices",27509.649999999998,39674.720000000008,38862.699999999997,106047.07]
[null,null,"sweets",52830.89,50265.709999999992,64260.590000000011,167357.19]
[]
[2,"Richtig (mit rechter Maustaste):"]
[1,"Right (with right mouse button):"]
[]
[null,null,"category","Federal Shipping","Speedy Express","United Package","total"]
[null,null,"beverages",91505.909999999989,57741.67,118620.58000000002,{"$f":"SUM(D33:F33)","v":267868.16000000003}]
[null,null,"cereals",24711.75,29587.510000000002,41445.329999999994,{"$f":"SUM(D34:F34)","v":95744.59}]
[null,null,"meat",47602.989999999991,31138.79,84280.59,163022.37]
[null,null,"milk products",64693.600000000006,78517.760000000009,91243.4,234454.76]
[null,null,"natural products",34038.799999999996,24226.03,41719.740000000005,99984.57]
[null,null,"sea food",40459.339999999997,37687.72,53114.67,131261.72999999998]
[null,null,"spices",27509.649999999998,39674.720000000008,38862.699999999997,106047.07]
[null,null,"sweets",52830.89,50265.709999999992,64260.590000000011,167357.19]
[]
[2,"Übung","Üben Sie diese Technik mit der Tabelle ganz oben auf diesem Arbeitsblatt!"]
[1,"Exercise","Train this technique with the table on top of this worksheet!"]
[]
[]
[0]

{"sheet":"05 Formel kopieren_","index":13,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"05 Copy a formula_",null,null,null,{"$f":"B2","v":"05 Copy a formula_"}]
[2,"05 Formel kopieren_"]
[]
[null,1,"Ein besonderer Geheimtipp von mir für Sie betrifft das Kopieren in formatierten Tabellen. Es ist nämlich so: \n\nWenn Sie eine Zelle in bekannter Weise an der rechten unteren Ecke herunter ziehen, kopiert Excel nicht nur den Zellinhalt (i.a. die Formel), sondern auch deren Format! Damit zerstören Sie sich aber die Formatierung der Tabelle und müssen Sie zeitaufwändig wieder herstellen.\n\nAlso – was tun? Wir ziehen die rechte untere Ecke der Zelle nicht mit der linken, sondern mit gedrückter RECHTER Maustaste herunter! Dann erscheint ein Kontextmenü, in dem Sie auswählen können: „Ohne Formatierung ausfüllen“. \n\nACHTUNG - interessante Alternative: Sie können auch „Nur Formate ausfüllen“ auswählen, um die Formatierung einer Zelle auf eine ganze Zeile oder Spalte auszudehnen! ",null,1,"A special secret tip from me for you concerns copying in formatted tables. It's like this: \n\nIf you drag a cell down the bottom right corner in the usual way, Excel copies not only the cell content (usually the formula), but also its format! But this destroys the formatting of the table and you have to restore it in a time-consuming way.\n\nSo - what to do? We do not drag down the bottom right corner of the cell with the left mouse button, but with the RIGHT mouse button pressed! Then a context menu appears where you can select: \"Fill without formatting\". \n\nATTENTION - interesting alternative: You can also select \"Fill only formats\" to extend the formatting of a cell to a whole row or column! "]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":""},null,null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":""}]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":""},null,null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":""}]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"06 Einfügen","index":14,"n_rows":82,"n_cols":20,"rows_kept":82,"cut":false,"hidden":false,"merged":[[77,2,78,10],[79,2,80,10],[15,9,15,12],[18,9,18,12],[20,9,20,12],[72,6,72,7],[73,6,73,7],[74,6,74,7],[75,6,75,7],[72,4,72,5],[73,4,73,5],[74,4,74,5],[75,4,75,5],[22,9,22,12],[15,14,15,17],[18,14,18,17],[20,14,20,17],[1,1,1,4],[2,1,2,4],[22,14,22,17],[68,4,68,5],[69,4,69,5],[70,4,70,5],[71,4,71,5],[68,6,68,7],[69,6,69,7],[70,6,70,7],[71,6,71,7]]}
[null,null,null,null,null,null,null,null,null,2,2,2,2,null,1,1,1,1,null,0]
[1,"06 Paste",null,null,null,"Back to Start"]
[2,"06 Einfügen",null,null,null,"Startseite"]
[]
[]
[null,null,"category","total sales","relative share"]
[null,null,"beverages",267868.15999999997,{"$f":"D7/SUM($D$7:$D$14)","v":0.21162961341426362}]
[null,null,"milk products",234454.76,{"$f":"D8/SUM($D$7:$D$14)","v":0.1852313101412798}]
[null,null,"sweets",167357.19,0.13222078137915858]
[null,null,"meat",163022.37,0.12879605079221454]
[null,null,"sea food",131261.73000000001,0.10370351286240012]
[null,null,"spices",106047.07,8.3782635561521601E-2]
[null,null,"natural products",99984.57,7.8992948980914274E-2]
[null,null,"cereals",95744.59,7.5643146868247316E-2]
[]
[null,null,null,null,null,null,null,null,null,"Einfügen",null,null,null,null,"Paste"]
[null,null,null,null,null,null,null,null,null,"Einfügen","Formeln","Formeln und Zahlenformat","Ursprüngliche Formatierung beibehalten",null,"Paste","Formulas","Formulas & Number Formatting","Keep Source Formatting"]
[null,null,null,null,null,null,null,null,null,"keine Rahmenlinien","Breite der Ursprungsspalte beibehalten","Transponieren",null,null,"No Borders","Keep Source Column Width","Transpose"]
[null,null,null,null,null,null,null,null,null,"Werte einfügen",null,null,null,null,"Paste Values"]
[null,null,null,null,null,null,null,null,null,"Werte","Werte und Zahlenformat","Werte und Quellformatierung",null,null,"Values","Values & Number Formatting","Values & Source Formatting"]
[null,null,null,null,null,null,null,null,null,"Weitere Einfügeoptionen",null,null,null,null,"Other Paste Options"]
[null,null,null,null,null,null,null,null,null,"Formatierung","Verknüpfung einfügen","Grafik","Verknüpfte Grafik",null,"Formatting","Paste Link","Picture","Linked Picture"]
[null,null,null,null,null,null,null,null,null,"Inhalte einfügen …",null,null,null,null,"Paste Special …"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,null,"first name","last name","name",null,"\"Paste Values\""]
[2,null,"Vorname","Nachname","Name",null,"\"Wertekopie\""]
[null,null,"Alexander","Plottner",{"$f":"C69&\" \"&D69","v":"Alexander Plottner"},null,"Alexander Plottner"]
[null,null,"Adriana","Pfeiffer",{"$f":"C70&\" \"&D70","v":"Adriana Pfeiffer"},null,"Adriana Pfeiffer"]
[null,null,"Albert","Pittner","Albert Pittner",null,"Albert Pittner"]
[null,null,"Angela","Peseler","Angela Peseler",null,"Angela Peseler"]
[null,null,"Agnes","Pilz","Agnes Pilz",null,"Agnes Pilz"]
[null,null,"Amanda ","Pechstein","Amanda  Pechstein",null,"Amanda  Pechstein"]
[null,null,"Arabella ","Leupold","Arabella  Leupold",null,"Arabella  Leupold"]
[null,null,"Adelheid ","Oberländer","Adelheid  Oberländer",null,"Adelheid  Oberländer"]
[]
[1,"Exercise","Try out all the different options for \"Paste\"!"]
[1]
[2,"Übung","Probieren Sie die verschiedenen Möglichkeiten für das Einfügen aus!"]
[2]
[0]

{"sheet":"06 Einfügen_","index":15,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"06 Paste_",null,null,null,{"$f":"B2","v":"06 Paste_"}]
[2,"06 Einfügen_"]
[]
[null,1,"Sie kennen \"Kopieren&Einfügen\" (\"copy&paste\")? Wirklich? Ich bin mir sicher, dass Sie die \"normale\" Version kennen (Strg-C / Strg-V) - aber es gibt zahlreiche fortgeschrittene Versionen des Einfügens (\"Kopieren\" ist immer dasselbe einfache Ding …). \n\nHier sehen Sie kurze Erklärungen für die verschiedenen Einfüge-Optionen. Die meisten davon sind selbsterklärend - probieren Sie sie einfach aus!",null,1,"You know \"copy&paste\"? Really? I'm sure you know the \"normal\" version (Ctrl-C / Ctrl-V) - but there are several advanced versions of \"paste\" (\"copy\" is always the same simple thing…). \n\nBelow you can see the short explanations of the different options for \"Paste\". Most of them are self-explaining - simply try them!"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Besonders hinweisen möchte ich auf folgende Optionen:\n\nTransponieren\nDamit kann eine Zeile mit Daten in eine Spalte verwandelt werden - und umgekehrt.\n\nGrafik\nDamit verwandeln Sie ein Excel-Objekt (eine Tabelle oder ein Diagramm) in ein Bild. Das kann für Illustrationen benutzt werden (siehe hier in dieser Datei).\n\nWerte \nDas ist besonders wichtig. Daher will ich es ausführlich erklären.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"I would like to highlight the following options:\n\nTranspose\nThis can be used to convert a row of data into a column of data - and vice versa.     \n\nPicture\nThis changes an Excel object (a table or a chart) into a picture. This may be needed for illustrations (see for example  here in this file).\n\nValues\nThis is particularly important. I will therefore explain it in detail."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Zuvor aber noch der Hinweis:\n\nWenn Sie auf \"Inhalte einfügen\" klicken, öffnet sich ein neues Fenster und Sie haben nochmal die Möglichkeit, verschiedene Einfügeoptionen auszuwählen.",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"But before that, a note:\n\nIf you click on \"Paste Special\", a new window will open and you will again have the possibility to choose different insertion options."]
[null,4,"Kommen wir jetzt zur Wertekopie:\n\nSie ersetzt eine Formel durch ihr Ergebnis - siehe das Beispiel hier: In der dritten Spalte werden die Vor- und Nachnamen mit Hilfe des &-Operators miteinander verbunden. \n\nStellen Sie sich vor, Sie haben die Listen mit den Vor- und Nachnamen von jemandem bekommen und in Ihre Excel-Datei importiert. Sie haben sie miteinander verbunden und brauchen die einzelnen Vor- und Nachnamen nun nicht mehr. \n\nAber was passiert, wenn Sie sie löschen? Probieren Sie es aus!\n",null,4,"Let us now come to \"Paste Values\":\n\nIt replaces a formula by its result - see example below: In the third column the first name and the last name are connected with each other using the &-operator. \n\nImagine, that you got the list of first names and last names from somebody else and imported them it into your Excel file. You have connected them and now you don't need the columns with the first names and the last names any longer. \n\nBut what happens, if you delete them ? Try it!"]
[null,5,"Vorteil der Wertekopie:\n\nWeil das Ergebnis der Formel nicht mehr mit deren Eingabewerten gekoppelt ist, können Sie mit den Eingabewerten machen, was Sie wollen (z.B. löschen), ohne das Ergebnis zu beeinflussen.\n\nNachteil der Wertekopie:\n\nWeil das Ergebnis der Formel nicht mehr mit deren Eingabewerten gekoppelt ist,  wirken sich Änderungen der Eingabedaten (z.B. die Korrektur einer falschen Schreibweise) nicht mehr auf das Ergebnis aus (d.h. die falsche Schreibweise bleibt bestehen).",null,5,"Advantage of \"Paste Values\":\n\nSince the result of a formula is no longer coupled to its input you can do whatever you want with the input data (i.e. delete them) without any influence on the result.\n\nDisadvantage of \"Paste Values\": \n\nSince the result of a formula is no longer coupled to its input any changes of the input (i.e. the correction of a wrong spelling of a name) will not influence the result (e.g. the wrong spelling remains). \n"]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"07 Bereichsnamen","index":16,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[40,5,40,7],[41,5,41,7],[6,2,7,8],[1,1,1,4],[2,1,2,4],[4,2,5,8],[34,6,35,11],[37,6,38,11],[26,5,26,6],[27,5,27,6],[29,5,29,6],[30,5,30,6]]}
[null,null,null,null,null,0]
[1,"07 Range names",null,null,null,"Back to Start"]
[2,"07 Bereichsnamen",null,null,null,"Startseite"]
[]
[2,null,"Schreiben Sie NIEMALS Zahlen, die sich ändern könnten (z.B. Steuersätze oder Währungskurse) direkt in Formeln! \nSollten sich diese Zahlen nämlich mal ändern, haben Sie\n(erstens) viel Aufwand, alle Formeln zu ändern und\n(zweitens) vergessen Sie bestimmt eine Änderung und die entspr. Formel berechnet dann ein falsches Ergebnis.\n\nSchreiben Sie stattdessen den Wert in eine Zelle und benutzen Sie in der Formel die Zelladresse. Da Sie i.A. den Wert auf mehreren Excel-Arbeitsblättern verwenden wollen, schreiben Sie den Wert auf ein gesondertes Blatt, das Sie z.B. \"Stammdaten\" nennen (siehe hier in dieser Datei).\n\nNoch perfekter wird Ihre Lösung, wenn Sie dann auf dem Stammdatenblatt der Zelle mit dem Wert einen Namen geben. Dann können Sie nämlich z.B.\n=D36*(1+MwSt)\nschreiben statt\n=D36*(1+Stammdaten!D2)\n\nDen Namen können Sie im Namenfeld links oben im Excel-Fenster eingeben.\nACHTUNG: Die Eingabe müssen Sie mit der Enter-Taste bestätigen!"]
[2]
[1,null,"NEVER write numbers that could change (e. g. tax rates or exchange rates) directly in formulas!\nIf these numbers should change, you will have\n(firstly) a lot of effort to change all formulas, and\n(secondly) you will certainly forget a change and the corresponding formula will then calculate an incorrect result.\n\nInstead, write the value in a cell and use the cell address in the formula. Since you generally want to use the value on several Excel worksheets, write the value on a separate sheet, which you call \"base data\", for example (see here in this file).\n\nYour solution will be even more perfect if you then enter a name for the cell with the value on the base data sheet. Then you can, for example, write\n=D36*(1+VAT)\ninstead of\n=D36*(1+'base data'!D2)\n\nYou can enter the name in the name box in the upper left corner of the Excel window.\nATTENTION: The entry must be confirmed with the Enter key! "]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,null,null,"net","gross","formula",null,"VAT:",0.19]
[1,null,null,100,{"$f":"D22*(1+I21)","v":119},{"$f":"_xlfn.FORMULATEXT(E22)","v":"=D22*(1+I21)"}]
[]
[2,null,null,"netto","brutto","Formel",null,"MwSt:",0.19]
[2,null,null,100,{"$f":"D25*(1+I24)","v":119},{"$f":"_xlfn.FORMULATEXT(E25)","v":"=D25*(1+I24)"}]
[]
[1,null,null,"net","gross","formula"]
[1,null,null,100,{"$f":"D28*(1+'08 Stammdaten'!I8)","v":119},{"$f":"_xlfn.FORMULATEXT(E28)","v":"=D28*(1+'08 Stammdaten'!I8)"}]
[]
[2,null,null,"netto","brutto","Formel"]
[2,null,null,100,{"$f":"D31*(1+'08 Stammdaten'!I8)","v":119},{"$f":"_xlfn.FORMULATEXT(E31)","v":"=D31*(1+'08 Stammdaten'!I8)"}]
[]
[]
[]
[1,null,null,"net","gross","formula","Here the \"local\" name definition from this sheet is used - in contrast to the same calculation on the sheet \"base data\"!"]
[1,null,null,100,{"$f":"D36*(1+VAT)","v":114.99999999999999},{"$f":"_xlfn.FORMULATEXT(E36)","v":"=D36*(1+VAT)"}]
[]
[2,null,null,"netto","brutto","Formel","Hier wird der auf diesem Blatt definierte \"lokale\" Name benutzt - im Gegensatz zu derselben Berechnung auf dem Blatt \"Stammdaten\"!"]
[2,null,null,100,{"$f":"D39*(1+MwSt)","v":114.99999999999999},{"$f":"_xlfn.FORMULATEXT(E39)","v":"=D39*(1+MwSt)"}]
[]
[2,null,null,"Mehrwertsteuer (MwSt):",0.15,"<- eine \"lokale\" Namensdefinition!"]
[1,null,null,"Value added tax (VAT):",0.15,"<- a \"local name definition!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"07 Bereichsnamen_","index":17,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"07 Range names_",null,null,null,{"$f":"B2","v":"07 Range names_"}]
[2,"07 Bereichsnamen_"]
[]
[null,1,"Schreiben Sie NIEMALS, NIEMALS, NIEMALS Zahlen, die sich ändern könnten (z.B. Steuersätze oder Währungskurse) direkt in Formeln!\n\nSollten sich diese Zahlen nämlich mal ändern, haben Sie\n\n(erstens) viel Aufwand, alle Formeln zu ändern und\n\n(zweitens) vergessen Sie bestimmt eine Änderung und die entspr. Formel berechnet dann ein falsches Ergebnis.\n\nSchreiben Sie stattdessen den Wert in eine Zelle und benutzen Sie in der Formel die Zelladresse. Da Sie i.A. den Wert auf mehreren Excel-Arbeitsblättern verwenden wollen, schreiben Sie den Wert auf ein gesondertes Blatt, das Sie z.B. \"Stammdaten\" nennen (siehe hier in dieser Datei).",null,1,"NEVER, NEVER, NEVER write numbers that could change (e. g. tax rates or exchange rates) directly in formulas!\n\nIf these numbers should change, you will have\n\n(firstly) a lot of effort to change all formulas, and\n\n(secondly) you will certainly forget a change and the corresponding formula will then calculate an incorrect result.\n\nInstead, write the value in a cell and use the cell address in the formula. Since you generally want to use the value on several Excel worksheets, write the value on a separate sheet, which you call \"base data\", for example (see here in this file)."]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Noch perfekter wird Ihre Lösung, wenn Sie dann auf dem Stammdatenblatt der Zelle mit dem Wert einen Namen geben. Dann können Sie nämlich z.B.\n=D36*(1+MwSt)\nschreiben statt\n=D36*(1+Stammdaten!D2)\n\nDen Namen können Sie im Namenfeld links oben im Excel-Fenster eingeben.\n\nACHTUNG: Die Eingabe müssen Sie mit der Enter-Taste bestätigen!",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"Your solution will be even more perfect if you then enter a name for the cell with the value on the base data sheet. Then you can, for example, write\n=D36*(1+VAT)\ninstead of\n=D36*(1+'base data'!D2)\n\nYou can enter the name in the name box in the upper left corner of the Excel window.\nATTENTION: The entry must be confirmed with the Enter key! "]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Bei der Vergabe von Bereichsnamen gibt es noch eine Besonderheit - und zwar bezüglich des Bereichs, in dem dieser Name dann gültig ist und in Formeln benutzt werden kann. Wenn Sie den Namen in der oben beschriebenen Weise über das Namenfeld vergeben, ist er immer automatisch für die ganze Datei (\"Arbeitsmappe\") gültig. Sie können ihn also auf allen Arbeitsblättern benutzen.\n\nUnd jetzt kommt es:\n\nSie können denselben Namen trotzdem auf einem beliebigen Arbeitsblatt erneut vergeben - auch mehrfach auf mehreren Arbeitsblättern. Es kann also eine \"globale\" Namensdefinition geben, die für alle Arbeitsblätter gilt und zusätzlich \"lokale\" Namensdefinitionen, die nur für ein Arbeitsblatt gelten.",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"When assigning range names, there is another special feature - namely the scope in which this name is valid and can be used in formulas. If you enter the name as described above in the name box, it is always automatically valid for the entire file (\"Workbook\"). So you can use it on all worksheets.\n\nAnd here it comes:\n\nYou can still reassign the same name on any worksheet - even multiple times on multiple worksheets. So there can be a \"global\" name definition that is valid for all worksheets and additionally \"local\" name definitions that are valid for only one worksheet."]
[null,4,"Wenn Sie den Namen auf einem Arbeitsblatt ohne \"lokale\" Definition benutzen, gilt die \"globale\" Definition - ansonsten die \"lokale\". (vergleichen Sie dazu das Beispiel auf diesem Blatt und das auf dem Blatt \"Stammdaten\"!)\n\nDas ist also ganz schön kompliziert!\n\nEs wird aber noch komplizierter: Die \"lokale\" Namensdefinition funktioniert nämlich NICHT über das Namenfeld. Wenn Sie dort einen Namen zum zweiten Mal eingeben, springt Excel zu der Zelle mit der \"globalen\" Defintion.\n\nDie \"lokale\" Definition erfolgt über den Namensmanager:\n\n\"Formeln / Definierte Namen / Namens-Manager\"",null,4,"If you use the name on a worksheet without a \"local\" definition, the \"global\" definition applies - otherwise the \"local\" definition (compare the examples below this text and on the worksheet \"base data\"!)\n\nSo that's pretty complicated!\n\nBut it becomes even more complicated: The \"local\" name definition does NOT work with the name box. If you enter a name there for the second time, Excel jumps to the cell with the \"global\" definition.\n\nThe \"local\" definition is carried out with the name manager:\n\n\"Formulas / Defined Names / Name Manager\" "]
[null,5,"Dort klicken Sie auf \"Neu…\" und es öffnet sich ein Fenster, in dem Sie folgendes festlegen können:\n- den Namen\n- den Gültigkeitsbereich (ganze Arbeitsmappe oder ein einzelnes Blatt)\n- die Zelladresse für den Namen\n\nEinen einmal festgelegten Gültigkeitsbereich können Sie nachträglich nicht mehr ändern. Wählen Sie dazu mal einen vorhandenen Namen im Namensmanager aus und klicken Sie auf \"Bearbeiten...\". In dem sich öffnenden Fenster ist \"Bereich\" deaktiviert.\n\nZur Änderung des Gültigkeitsbereichs müssten Sie den Namen also löschen und neu mit anderem Gültigkeitsbereich anlegen.",null,5,"There you click on \"New...\" and a window opens in which you can specify the following:\n- the name\n- the scope (entire workbook or a single sheet)\n- the cell address for the name\n\nOnce you have defined a scope, you can no longer change it. Select an existing name in the name manager and click on \"Edit...\". In the window that opens, \"Scope\" is deactivated.\n\nTo change the scope, you would have to delete the name and create it again with a different scope."]
[null,6,"ACHTUNG:\n\nRICHTIG verwirrend wird es, wenn Sie ein Arbeitsblatt aus einer Datei mit darin definierten Namen in eine andere Datei kopieren. Dann werden nämlich die Namen mit kopiert!\n\nDabei kann es zu Konflikten mit gleichlautenden Namen in der anderen Datei kommen.\n\nNach einer solchen Kopieraktion sollten Sie also UNBEDINGT den Namensmanager in der zweiten Datei aufrufen und dort nach dem Rechten sehen!! ",null,6,"ATTENTION:\n\nIt becomes REALLY confusing when you copy a worksheet from one file with names therein to another file. Then the names will also be copied!\n\nThis can lead to conflicts with identical names in the other file.\n\nAfter such a copy action you should ABSOLUTELY call the name manager in the second file and check the situation! "]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"08 Stammdaten","index":18,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[11,6,12,11],[14,6,15,11],[1,1,1,4],[2,1,2,4],[7,4,7,6],[8,4,8,6],[4,2,4,7],[5,2,5,7]]}
[null,null,null,null,null,0]
[1,"08 Base data",null,null,null,"Back to Start"]
[2,"08 Stammdaten",null,null,null,"Startseite"]
[]
[2,null,"Lesen Sie bitte die Erläuterungen auf dem Blatt \"Bereichsnamen\"!"]
[1,null,"Please read the explanations on the sheet \"Range names\"!"]
[]
[2,null,"Mehrwertsteuer (MwSt):",0.19,"<- eine \"globale\" Namensdefinition!",null,null,null,0.19]
[1,null,"Value added tax (VAT):",0.19,"<- a \"global\" name definition!"]
[]
[]
[1,null,null,"net","gross","formula","Here the \"global\" name definition is used - in contrast to the same calculation on the sheet \"Range names\"!"]
[1,null,null,100,{"$f":"D13*(1+VAT)","v":119},{"$f":"_xlfn.FORMULATEXT(E13)","v":"=D13*(1+VAT)"}]
[]
[2,null,null,"netto","brutto","Formel","Hier wird die \"globale\" Namensdefinition benutzt - im Gegensatz zu derselben Berechnung auf dem Blatt \"Bereichsnamen\"!"]
[2,null,null,100,{"$f":"D16*(1+MwSt)","v":119},{"$f":"_xlfn.FORMULATEXT(E16)","v":"=D16*(1+MwSt)"}]
[]
[]
[]
[]
[]
[0]

{"sheet":"09 Office Zwischenablage","index":19,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[36,2,37,8],[38,2,39,8]]}
[null,null,null,null,null,0]
[1,"09 Office clipboard",null,null,null,"Back to Start"]
[2,"09 Office Zwischenablage",null,null,null,"Startseite"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"Exercise","Open the Office clipboard and train the copy&paste with it!"]
[1]
[2,"Übung","Öffnen Sie die Office-Zwischenablage und üben Sie das Copy&Paste damit!"]
[2]
[0]

{"sheet":"09 Office Zwischenablage_","index":20,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"09 Office clipboard_",null,null,null,{"$f":"B2","v":"09 Office clipboard_"}]
[2,"09 Office Zwischenablage_"]
[]
[null,1,"Ich bin mir sicher, dass Ihnen die \"Kopieren&Einfügen\"-Technik (\"copy&paste\") gut bekannt ist. Sie benutzt die \"normale\" Windows-Zwischenablage:\n\n\"Kopieren\" bedeutet \n\"einen Text oder eine Grafik vom Excel-Blatt in die Windows-Zwischenablage kopieren\".\n\n\"Einfügen\" bedeutet \n\"den Text oder die Grafik aus der Windows-Zwischenablage holen und auf dem Excel-Blatt einfügen.",null,1,"I am sure, the copy&paste technique is well known to you. It uses the \"normal\" Windows clipboard:\n\n\"Copy\" means: \"to copy a text or a chart from the Excel sheet to the Windows clipboard\". \n\n\"Paste\" means: \"to get the text or the chart from the Windows clipboard and to insert it on the Excel sheet\"."]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Es gibt aber noch eine andere Art von Zwischenablage: Die Office-Zwischenablage! In einigen Fällen, wenn die \"normale\" Windows-Zwischenablage nicht das tut, was Sie wollen, sollten Sie die Office-Zwischenablage benutzen.\n\nSie öffnen die Office-Zwischenablage durch einen Klick auf den kleinen Butten im \"Zwischenablage\"-Menü von \"Start\".",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"But there is also another kind of clipboard: The Office clipboard! In some cases, when the \"normal\" Windows clipboard doesn't do what you intend to do, you should use the Office clipboard.\n\nYou can open the Office clipboard by clicking on the small button in the \"Clipboard\" menu of \"Home\"."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Die Office-Zwischenablage hat gegenüber der \"normalen\" Windows-Zwischenablage einige Vorteile:\n\n(1) Sie ist für Benutzer sichtbar.\n(2) Sie kann nicht nur ein einzelnes Objekt enthalten, sondern mehrere.\n(3) Benutzer können eines der Objekte einfach per Mausklick einfügen. \n(4) Sie ist \"clever\" und macht, was der Benutzer will.\n\nDer letzte Vorteil klingt etwas mysteriös - aber Sie werden erkennen, was gemeint ist, wenn Sie das Thema \"Teilergebnisse\" in der Datei \"Excel-Lists\" durcharbeiten!",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"The Office clipboard has some advantages over the \"normal\" Windows clipboard:\n\n(1) It is visible to you.\n(2) It can contain not only one object but several ones.\n(3) You can insert one of the objects simply with a mouse click.\n(4) It is \"clever\" and does what you intend to do.\n\nThe last advantage sounds a bit mysterious - but you will see, what is meant, if you work through the topic \"Subtotals\" in the file \"Excel-Lists\"!"]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"10 Bedingte Formatierung 1","index":21,"n_rows":64,"n_cols":6,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[null,null,null,null,null,0]
[1,"10 Conditional formatting 1",null,null,null,"Back to Start"]
[2,"10 Bedingte Formatierung 1",null,null,null,"Startseite"]
[]
[null,null,"category","Federal Shipping","Speedy Express","United Package"]
[null,null,"beverages",91505.909999999989,57741.67,118620.58000000002]
[null,null,"cereals",24711.75,29587.510000000002,41445.329999999994]
[null,null,"meat",47602.989999999991,31138.79,84280.59]
[null,null,"milk products",64693.600000000006,78517.760000000009,91243.4]
[null,null,"natural products",34038.799999999996,24226.03,41719.740000000005]
[null,null,"sea food",40459.339999999997,37687.72,53114.67]
[null,null,"spices",27509.649999999998,39674.720000000008,38862.699999999997]
[null,null,"sweets",52830.89,50265.709999999992,64260.590000000011]
[null,null,"milk products",64693.600000000006,78517.760000000009,91243.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"10 Bedingte Formatierung 1_","index":22,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"10 Conditional formatting 1_",null,null,null,{"$f":"B2","v":"10 Conditional formatting 1_"}]
[2,"10 Bedingte Formatierung 1_"]
[]
[null,1,"Sie können die bedingte Formatierung benutzen, um einen größeren Bereich mit Zahlen übersichtlicher zu gestalten. Dabei werden die Zellen nach bestimmten Regeln gefärbt. \n\nBitte probieren Sie selber aus, was damit gemeint ist. Markieren Sie den Bereich mit Zahlen in der folgenden Tabelle und wählen Sie dann\n\n\"Start / Formatvorlagen / Bedingte Formatierung\"\n\nDort sind die ersten fünf Menüeintrage selbsterklärend ...",null,1,"You can use the conditional formatting to make a range with many numbers more overseeable. To this end the cells are colored according to certain conditions. \n\nPlease try it by yourself to understand, what I mean. Mark the range with numbers in the following table and select\n\n\"Home / Styles / Conditional Formatting\"\n\nThere the first five menu items are self-explaining ..."]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Wenn Sie auf \"Neue Regel…\" klicken, erscheint das folgende Fenster. Dort sind die ersten fünf Regeltypen wieder selbsterklärend. Bitte probieren Sie sie aus, um zu verstehen, was diese Regeltypen bedeuten. Der letzte Regeltyp ist etwas komplizierter und wird auf dem nächsten Arbeitsblatt erklärt.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"If you click on \"New Rule...\" the following window appears. There the first five rule types are again self-explaining. Please try them with the above table to understand, what these rules do. The last rule type is a bit more complicated and is explained on the next worksheet."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":""},null,null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":""}]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"11 Bedingte Format. 2 (A)","index":23,"n_rows":72,"n_cols":8,"rows_kept":72,"cut":false,"hidden":false,"merged":[[67,2,69,7],[1,1,1,4],[2,1,2,4],[4,2,5,7],[6,2,7,7],[64,2,66,7]]}
[null,null,null,null,null,0]
[1,"11 Conditional format. 2 (E)",null,null,null,"Back to Start"]
[2,"11 Bedingte Format. 2 (A)",null,null,null,"Startseite"]
[]
[2,"Achtung","Bevor Sie dies hier lesen, arbeiten Sie bitte zuerst das vorherige Arbeitsblatt \"Bedingte Formatierung 1\" durch!"]
[2]
[1,"Attention","Before you read this, please work through the preceding worksheet \"Conditional formatting 1\"!"]
[1]
[]
[null,null,"category","Federal Shipping","Speedy Express","United Package","Total","Category"]
[null,null,"beverages",91505.909999999989,57741.67,118620.58000000002,{"$f":"SUM(D11:F11)","v":267868.16000000003},"A"]
[null,null,"milk products",64693.600000000006,78517.760000000009,91243.4,234454.76,"A"]
[null,null,"sweets",52830.89,50265.709999999992,64260.590000000011,167357.19,"B"]
[null,null,"meat",47602.989999999991,31138.79,84280.59,163022.37,"B"]
[null,null,"sea food",40459.339999999997,37687.72,53114.67,131261.72999999998,"B"]
[null,null,"spices",27509.649999999998,39674.720000000008,38862.699999999997,106047.07,"B"]
[null,null,"natural products",34038.799999999996,24226.03,41719.740000000005,99984.57,"C"]
[null,null,"cereals",24711.75,29587.510000000002,41445.329999999994,95744.59,"C"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"Übung","Definieren Sie für obige Tabelle zwei Regeln, die die komplette Zeile gelb bzw. rot färben, wenn in der letzen Spalte ein \"B\" bzw. ein \"C\" steht! Probieren Sie aus, ob Ihre bedingte Formatierug funktioniert, indem Sie aus einem \"A\" ein \"B\" machen bzw. aus einem \"B\" ein \"C\"!"]
[2]
[2]
[1,"Exercise","Define two rules for the above table, which color the complete row in yellow and red, respectively, if there is a \"B\" or a \"C\" in the last column! Try if your conditional formatting works by changing an \"A\" into a \"B\" and a \"B\" into a \"C\"."]
[1]
[1]
[]
[0]

{"sheet":"11 Bedingte Format. 2 (A)_","index":24,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"11 Conditional format. 2 (E)_",null,null,null,{"$f":"B2","v":"11 Conditional format. 2 (E)_"}]
[2,"11 Bedingte Format. 2 (A)_"]
[]
[null,1,"Normalerweise besagt eine Regel für die bedingte Formatierung z.B.:\n      \"Wenn der Wert in DIESER Zelle größer als 50 ist, färbe sie rot!\"\nEine besondere Regel zur bedingten Formatierung besagt aber z.B.:\n      \"Wenn der Wert in DIESER Zelle eine bestimmte Bedingung erfüllt, färbe ANDERE ZELLEN rot!\"\nDas bedeutet, die Formatierung einer Zelle hängt nicht vom Inhalt der Zelle selber ab, sondern vom Inhalt einer ANDEREN Zelle!\n\nBEISPIEL: In der folgenden Tabelle soll die gesamte Zeile grün gefärbt werden, wenn in der letzten Spalte ein \"A\" steht.",null,1,"Usually, a rule for conditional formatting says, for example: \n        \"If the value in THIS cell is larger than 50, color it red.\" \nBut a special rule for conditional formatting says, for example: \n        \"If the value in THIS cell satisfies a certain condition, color OTHER CELLS red.\"\nThat means, the formatting of a cell doesn't depend on the content of the cell itself, but on the content of ANOTHER cell!\n\nEXAMPLE: In the following table the complete row shall be colored in green, if there is an \"A\" in the last column."]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Die folgenden Screenshots zeigen, wie die entsprechende Regel einzugeben ist.\n\nACHTUNG:\nDie Regel enthält ZWEI Gleichheitszeichen!\nDas erste Gleichheitszeichen muss als \"Wenn …\" gelesen werden. Das zweite Gleichheitszeichen bezeichnet einen Vergleich - in diesem Fall zwischen dem Inhalt von Zelle H11 und dem Wert \"A\"!\n\nDas bedeutet: Die Regel ist erfüllt, wenn in H11 ein \"A\" steht.\nWenn die Regel erfüllt ist, wird der in der Regel festgelegte Bereich formatiert.\n\nNOCHMAL ACHTUNG:\nBitte beachten Sie sehr aufmerksam das richtige Setzen der $-Zeichen in der Regel und in deren Gültigkeitsbereich! ",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"The following screenshots show, how to enter the corresponding rule.\n\nATTENTION:\nThe rule contains TWO equal signs! \nThe first equal sign should be read as: \"If ...\". The second equal sign is a comparison between two values - in the example between the content of cell H11 and the value \"A\"!\n\nThat means: The rule is fulfilled, if there is an \"A\" in cell H11. \nIf the rule is fulfilled, the range of cells, specified in the rule, is formatted.\n\nAGAIN ATTENTION:\nPlease consider very attentively the right setting of $ signs in the rule as well as in the range for its application!"]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Es ist schwer zu verstehen - und leider auch schwer zu erklären - warum die Formatierungsregel lauten muss =$H11=\"A\". Es handelt sich um eine Formel. Wenn diese horizontal oder vertikal kopiert wird, werden die Zelladressen entsprechend angepasst. Durch ein Dollarzeichen kann man das verhindern (\"absolute Zelladressierung\").\n\n",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"It's hard to understand - and unfortunately also hard to explain - why the format rule must be =$H11=\"A\". It's a formula. If it is copied horizontally or vertically, the cell addresses are adapted. You can avoid this with dollar signs (\"absolute cell addressing\").\n\n"]
[null,4,"Sie müssen sich die Definition der bedingten Formatierung daher so vorstellen:\n\nDie Eingabe der Formel =$H11=\"A\", die die Bedingung beschreibt, erfolgt in der rechten oberen Ecke des Bereiches C11:H18, auf den sie angewandt werden soll. Diese bedingte Formatierung wird dann von H11 nach links bis C11 und nach unten bis H18 \"ausgedehnt\". Das ist so, als würde die Formel =$H11=\"A\" horizontal und vertikal kopiert. Beim horizontalen Kopieren nach links soll die Spalte H nicht verändert werden. Beim vertikalen Kopieren nach unten soll aber die 11 zur 12, zur 13, ... usw werden. Daher müssen wir ein Dollarzeichen vor den Buchstaben H schreiben - aber nicht vor die Zahl 11. Alles klar? Wahrscheinlich nicht. Denken Sie nochmal darüber nach!\n\nVielleicht verstehen Sie auch besser, was gemeint ist, wenn Sie einfach mal absichtlich eine falsche Bedingung eingeben (z.B. =H$11=\"A\" oder =H11=\"A\") und beobachten, was passiert.",null,4,"Therefore, you can imagine the definition of the conditional formatting as follows:\n\nThe formula =$H11=\"A\", which describes the condition, is entered in the upper right corner of the range, for which it shall be valid. It is then expanded horizontally to C11 and vertically to H18. It's the same procedure as if the formula =$H11=\"A\" was copied horizontally and vertically. In case of the horizonal copy the letter H shall not be changed. In case of the vertical copy the number 11 shall be changed to 12, to 13, ... and so on. Therefore we have to write a $ before the letter H - but not before the number 11. You got it? May be not. Please think again about it!\n\nMay be you will get a better understanding, if you deliberately enter a wrong condition (e.g. =H$11=\"A\" or =H11=\"A\") and observe, what will happen."]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"12 Absoluter Zellbezug (A)","index":25,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[26,2,27,10],[16,2,16,10],[24,2,24,10],[34,2,35,2],[34,3,35,3],[34,4,34,7],[34,8,34,11],[29,2,31,2],[29,6,29,7],[29,8,29,10],[30,8,30,10],[31,8,31,10],[1,1,1,4],[2,1,2,4],[21,2,23,2],[21,6,21,7],[21,8,21,10],[22,8,22,10],[23,8,23,10],[18,2,19,10]]}
[null,null,null,null,null,null,null,null,null,0]
[1,"12 Absolute cell reference (E)",null,null,null,"Back to Start"]
[2,"12 Absoluter Zellbezug (A)",null,null,null,"Startseite"]
[]
[]
[null,null,"=A6*B6","column changed","=C6*D6"]
[null,null,"row "]
[null,null,"changed",null,"=$A6*B6","fixed column","=$A6*D6"]
[null,null,"=A9*B9",null,"no"]
[null,null,null,null,"effect",null,"=A$6*B6","no effect","=C$6*D6"]
[null,null,null,null,"=$A9*B9",null,"fixed"]
[null,null,null,null,null,null,"row",null,"=$A$6*B6","fixed column","=$A$6*D6"]
[null,null,null,null,null,null,"=A$6*B9",null,"fixed"]
[null,null,null,null,null,null,null,null,"row"]
[null,null,null,null,null,null,null,null,"=$A$6*B9"]
[]
[2,"Achtung","Für die Eingabe der $-Zeichen benutzen Sie die F4-Taste!!"]
[2]
[2,"Übung","Geben Sie in der folgenden Tabelle in der gelb markierten Zelle die Formel zur Berechnung der Gesamtkosten ein. Setzen Sie die Dollarzeichen so, dass Sie die Formel nach rechts und nach unten kopieren können."]
[2]
[2]
[2,null,"Kosten der Zentrale pro Quartal:",null,null,null,"Gesamtkosten=",null,"anteilige Kosten der Zentrale"]
[2,null,null,null,null,null,null,null,"plus Fixkosten der Filiale"]
[2,null,null,null,null,null,null,null,"plus variable Kosten der Filiale"]
[1,"Attention","Use the F4 key to enter the $ characters!!"]
[1]
[1,"Exercise","Enter the formula for the calculation of the total costs into the yellow cell in the following table. Set the $ characters in such a way, that you can copy the formula to the right and down."]
[1]
[1]
[1,null,"costs of the headquarters per quarter:",null,null,null,"total costs=",null,"proportional costs of the headquarters"]
[1,null,null,null,null,null,null,null,"plus fixed costs of the branch"]
[1,null,null,null,null,null,null,null,"plus variable costs of the branch"]
[null,null,null,12000]
[]
[null,null,"branch","fixed costs per quarter","variable costs",null,null,null,"total costs"]
[null,null,null,null,"1st quarter","2nd quarter","3rd quarter","4th quarter","1st quarter","2nd quarter","3rd quarter","4th quarter"]
[null,null,"Oldenburg",8000,21827,14637,17389,21940]
[null,null,"Bremen",6000,26195,19994,19552,14893]
[null,null,"Hamburg",7500,24932,20073,10374,27393]
[]
[]
[2,"Ziel:"]
[1,"Objective:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"12 Absoluter Zellbezug (A)_","index":26,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"12 Absolute cell reference (E)_",null,null,null,{"$f":"B2","v":"12 Absolute cell reference (E)_"}]
[2,"12 Absoluter Zellbezug (A)_"]
[]
[null,1,"Sie wissen: \n\nWenn Sie eine Excel-Formel horizontal oder vertikal kopieren, werden die Zelladressen in der Formel an die neue Position der Formel angepasst. Wenn Sie das verhindern wollen, weil Sie in der Formel eine feste Zelladresse verwenden wollen, müssen Sie ein Dollarzeichen vor dem Spaltenbuchstaben, vor der Zeilennummer oder vor beiden hinzufügen.\n\nACHTUNG:\n\nFür die Eingabe der $-Zeichen benutzen Sie die F4-Taste!!",null,1,"You know: \n\nIf you copy an Excel formula horizontally or vertically then the cell addresses in the formula are adapted to the new position of the formula. If you want to prevent this, beause you want to use a fixed cell address in your formula, you have to add a Dollar character either before the column letter or before the row number or before both of them.\n\nATTENTION:\n\nUse the F4 key to enter the $ characters!!"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Zur Übung geben Sie in der folgenden Tabelle in der gelb markierten Zelle die Formel zur Berechnung der Gesamtkosten ein. \n\nSetzen Sie die Dollarzeichen so, dass Sie die Formel nach rechts und nach unten kopieren können.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"To train this, enter the formula for the calculation of the total costs into the yellow cell in the following table. \n\nSet the $ characters in such a way, that you can copy the formula to the right and down."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":""},null,null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":""}]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"13 Datenüberprüfung","index":27,"n_rows":99,"n_cols":14,"rows_kept":99,"cut":false,"hidden":false,"merged":[[84,4,84,5],[65,2,66,3],[65,4,67,9],[68,2,69,3],[68,4,70,9],[72,2,74,8],[75,2,77,8],[50,2,51,8],[1,1,1,4],[2,1,2,4],[35,5,35,6],[35,7,35,8],[48,2,49,8]]}
[null,null,null,null,null,0]
[1,"13 Data Validation",null,null,null,"Back to Start"]
[2,"13 Datenüberprüfung",null,null,null,"Startseite"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"arrival",null,"departure"]
[null,null,"container nr","size","type","day","month","day","month",null,null,null,"list of sizes","list of types"]
[null,null,"HBLU23164734","20'",null,null,null,null,null,null,null,null,"20'","standard"]
[null,null,"BNGT56431890","20'",null,null,null,null,null,null,null,null,"40'","open top"]
[null,null,"CNMK87453190","40'",null,null,null,null,null,null,null,null,null,"flat"]
[null,null,"GTFR98676741","40'",null,null,null,null,null,null,null,null,null,"reefer"]
[null,null,"FRSE88689077","20'",null,null,null,null,null,null,null,null,null,"high cube"]
[]
[]
[]
[]
[]
[]
[2,"Übung","Definieren Sie in der Beispieltabelle eine Datenüberprüfung für die Tage und Monate! Finden Sie heraus, wie Sie die \"Eingabemeldung\" und die \"Fehlermeldung\" benutzen können!"]
[2]
[1,"Exercise","Define a data validation in the example table for the days and months! Find out how to use the \"Input Message\" and the \"Error Alert\"!"]
[1]
[]
[]
[]
[2,"abhängige"]
[2,"Kombina-"]
[2,"tionsfelder","Transport","von",null,"nach"]
[1,"depending"]
[1,"combo"]
[1,"boxes","Transport","from",null,"to"]
[null,null,null,"Germany",null,"France"]
[null,null,null,"Berlin",null,"Bordeaux"]
[]
[]
[2,null,"Formel für die Datenquelle der Stadt in D63:",null,"=WENN(D62='13 List data'!B5;'13 List data'!B6:B13;WENN(D62='13 List data'!C5;'13 List data'!C6:C11;WENN(D62='13 List data'!D5;'13 List data'!D6:D8;WENN(D62='13 List data'!E5;'13 List data'!E6:E10))))"]
[2]
[2]
[1,null,"Formula for the data source of the city in D63:",null,"=IF(D62='13 List data'!B5;'13 List data'!B6:B13;IF(D62='13 List data'!C5;'13 List data'!C6:C11;IF(D62='13 List data'!D5;'13 List data'!D6:D8;IF(D62='13 List data'!E5;'13 List data'!E6:E10))))"]
[1]
[1]
[]
[2,"Übung","Definieren Sie eine Datenüberprüfung für die Auswahl der Reederei. In dem Feld \"Schiff\" sollen dann die Schiffe der Rederei auswählbar sein. Die notwendigen Daten finden Sie auf dem Blatt \"13 List data\"."]
[2]
[2]
[1,"Exercise","Define a data validation for the selection of the shipping company. The vessels of the shipping company should then be selectable in the field \"Vessel\". The necessary data can be found on the sheet \"13 List data\"."]
[1]
[1]
[]
[1,null,null,"Shipping company:"]
[2,null,null,"Reederei:"]
[]
[1,null,null,"Vessel:"]
[2,null,null,"Schiff:"]
[]
[]
[]
[2,null,"Transport","von",null,"nach"]
[1,null,"Transport","from",null,"to"]
[null,null,null,"Germany",null,"Netherlands"]
[null,null,null,"Berlin",null,"Den Haag"]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"13 Datenüberprüfung_","index":28,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"13 Data Validation_",null,null,null,{"$f":"B2","v":"13 Data Validation_"}]
[2,"13 Datenüberprüfung_"]
[]
[null,1,"Viele Fehler entstehen dadurch, dass Benutzer falsche Daten eingeben. Sie können das weitgehend (aber leider niemals vollständig) verhindern, indem Sie die Datenüberprüfung benutzen:\n\n\"Daten / Datentools / Datenüberprüfung / Datenüberprüfung\"\n\nDort können Sie festlegen, dass in bestimmten Zellen nur bestimmte Werte eingegeben werden dürfen - z.B. ganze Zahlen oder ein Datum. \n\nBesonders nützlich ist die Auswahl \"Liste\".",null,1,"The reason for many errors is, that users enter wrong data. You can avoid this as far as possible (but unfortunately never completely) by using the data validation:\n\n\"Data / Data Tools / Data Validation / Data Validation\"\n\nThere you can define that certain cells can only contain certain values - e.g. integer numbers or a dates. \n\nEspecially useful is the selection \"List\"."]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Dort können Sie dann unter \"Quelle\" einen Bereich angeben, der die zugelassenen Werte enthält. \n\nWenn Sie anschließend in die Zelle klicken, für die Sie die Datenüberprüfung definiert haben, erscheint rechts daneben ein Button. Damit können Sie die Liste der zugelassenen Werte aufklappen und einen Wert auswählen. \n\nBitte probieren Sie das in der Beispieltabelle aus!",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"Under \"Source\" you can enter a range, wich contains the allowed values. \n\nIf you then click into the cell for which you have defined the data validation, a button appears right to it. It can be used to open a list of allowed values and to select one of them. \n\nPlease try this with the example table!"]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Sie können die Datenüberprüfung auch benutzen, um abhängige Kombinationsfelder zu entwickeln. Das bedeutet: Was in einem Kombinationsfeld angezeigt wird, hängt davon ab, was VORHER in einem ANDEREN Kombinationsfeld ausgewählt wurde - z.B. Länder und Städte. \n\nWenn ein anderes Land ausgewählt wird, werden im zweiten Feld auch andere Städte angezeigt.","B56",3,"You can also use data validation to develop dependent combo boxes. This means: What is displayed in a combo box depends on what was selected BEFORE in ANOTHER combo box - e.g. countries and cities. \n\nIf another country is selected, other cities will also be displayed in the second field.","B56"]
[null,4,"Sie können das erreichen, indem Sie unter \"Quelle\" eine entsprechende WENN-Formel eingeben. Das Ergebnis der WENN-Formel ist ein Zellbereich auf dem Blatt \"13 List data\". Die Lage dieses Zellbereichs hängt davon ab, welches Land in der Zelle über der Stadt ausgewählt wurde.\n\nWenn z.B. als Land \"Germany\" ausgewählt wurde, ist die Datenquelle für die Stadt der Bereich B6:B13. Wenn \"France\" ausgewählt wurde, ist die Datenquelle für die Stadt der Bereich C6:C11.",null,4,"You can achieve this by entering a corresponding IF formula under \"Source\". The result of the IF formula is a cell range on the sheet \"13 List data\". The location of this cell range depends on which country was selected in the cell above the city.\n\nFor example, if \"Germany\" was selected as the country, the data source for the city is the range B6:B13. If \"France\" was selected, the data source for the city is the range C6:C11."]
[null,5,"Diese Nutzung der Datenüberprüfung ist elegant und nützlich - aber leider unflexibel. Wenn Sie weitere Länder und/oder Städte hinzufügen wollen oder wenn sich die Eingabefelder für Land und Stadt auf dem Excelblatt verschieben, müssen Sie die WENN-Formel sorgfältig und mit viel Aufwand anpassen.\n\nWenn Sie die totale Flexibilität brauchen, müssen Sie etwas mehr Aufwand bei der Definition der Datenquelle der Datenüberprüfung treiben. Das Stichwort hierzu lautet: \"Als Tabelle formatieren\". Das klingt etwas kurios, weil in Excel ja sowieso alle Daten in Tabellenform vorliegen. Mit \"Als Tabelle formatieren\" ist aber eine spezielle Funktion im Menü \"Start\" gemeint.",null,5,"This use of data validation is elegant and useful - but unfortunately inflexible. If you want to add more countries and/or cities, or if the input fields for country and city move on the Excel sheet, you have to adjust the IF formula carefully and with a lot of effort.\n\nIf you need total flexibility, you need to put a little more effort into defining the data source of the data validation. The keyword here is: \"Format as table\". This sounds a bit strange, because in Excel all data is in table form anyway. However, \"Format as table\" refers to a special function in the \"Start\" menu."]
[null,6,"Ich habe die Liste der Länder auf dem Blatt \"13 List data\" schon als Tabelle formatiert. Zur Erläuterung führe ich das noch einmal vor: Liste markieren + \"Start / Formatvorlagen / Als Tabelle formatieren\". Fertig!\n\nAnschließend geben wir der Tabelle einen Namen, den wir einfach links oben im Namensfeld eingeben. Da der Name \"Countries\" schon vergeben ist, nenne ich sie \"Countries2\". Anschließend kann ich mir unter \"Formeln / Namensmanager\" das Ergebnis ansehen.",null,{"$f":"IF(F10<>\"\",E9+1,\"\")","v":6},"I have already formatted the list of countries on the sheet \"13 List data\" as a table. I will show you how to do this again: Mark the list + \"Start / Styles / Format as table\". Done!\n\nThen we give the table a name, which we simply enter in the name field at the top left. Since the name \"Countries\" is already taken, I call it \"Countries2\". Then I can look at the result under \"Formulas / Name manager\"."]
[null,7,"Jetzt lösche ich diesen Namen und auch die dazugehörige Liste wieder und arbeite mit der Tabelle \"Countries\" weiter.\n\nDas Interessante an der als Tabelle formatierten Liste ist, dass neue Listeneinträge automatisch zur benannten Tabelle hinzugefügt werden.\n\nZur Tabelle \"Countries\" gehört als jetzt auch \"Danmark\".",null,7,"Now I delete this name and also the associated list again and continue working with the table \"Countries\".\n\nThe interesting thing about the list formatted as a table is that new list entries are automatically added to the named table.\n\nThe table \"Countries\" now also includes \"Danmark\"."]
[null,8,"ACHTUNG: \nBeachten Sie, dass Sie Einträge aus der Tabelle nicht einfach durch Löschen des Zellinhalts entfernen können. Dann haben Sie nämlich in der Tabelle einen Leereintrag! Sie müssen also die ganze Zeile löschen.\n\nDarum ist es auch wichtig, dass Sie die Listen UNTEREINANDER anlegen statt nebeneinander!",null,8,"ATTENTION: \nNote that you cannot remove entries from the table simply by deleting the cell content. Then you will have an empty entry in the table! You must therefore delete the whole row.\n\nThat is why it is also important that you create the lists BELOW each other instead of next to each other!"]
[null,9,"Und jetzt kommen wir wieder zur Datenüberprüfung. Hier gebe ich nämlich jetzt als Quelle keinen Zellbereich mit Zeilen und Spalten an, sondern den Namen der als Tabelle formatierten Liste: \"Countries\". \n\nACHTUNG: Der Name der Tabelle muss für einen Bereich vergeben werden, der die Zeile \"Countries\" nicht enthält - sonst erscheint \"Countries\" nachher in der Liste der Länder!\n\nWenn ich dort ein weiteres Land hinzufüge, erscheint es automatisch im Kombinationsfeld der Datenüberprüfung. \n\nWenn ich in \"Countries\" einen Zellinhalt lösche, erscheint im Kombinationsfeld eine Leerzeile. Ich muss also in der Tabelle \"Countries\" wirklich die ganze Zeile löschen!",null,9,"And now we come back to the data validation. Here I do not enter a cell range with rows and columns as the source, but the name of the list formatted as a table: \"Countries\". \n\nATTENTION: The name of the table must be assigned for a range that does not contain the row \"Countries\" - otherwise \"Countries\" will appear later in the list of countries!\n\nIf I add another country there, it automatically appears in the combo box of the data validation. \n\nIf I delete a cell content in \"Countries\", an empty row appears in the combo box. So I really have to delete the whole row in the \"Countries\" table!"]
[null,10,"Und jetzt wird es richtig interessant: Jetzt sollen in der Zelle unter dem Land die dazugehörigen Städte ausgewählt werden können. Dazu formatiere ich die Listen mit den Städten wieder als Tabellen und nennen sie so, wie das dazughörige Land. Die Tabelle mit den deutschen Städten heißt also z.B. \"Germany\".\n \nACHTUNG: Der Name der Tabelle muss für einen Bereich vergeben werden, der den Namen des Landes nicht enthält - sonst erscheint er nachher in der Liste der Städte!\n \nDadurch wird folgender Supertrick möglich: Als Datenquelle für die Zelle mit dem Stadtnamen schreibe ich einfach: =INDIREKT($D$90)",null,10,"And now it's getting really interesting: Now it should be possible to select the corresponding cities in the cell below the country. To do this, I format the lists with the cities as tables again and name them like the associated country. The table with the German cities is therefore called \"Germany\", for example.\n\nATTENTION: The name of the table must be assigned for an area that does not contain the name of the country - otherwise it will appear later in the list of cities!\n\nThis makes the following super trick possible: I simply write: =INDIRECT($D$90) as the data source for the cell with the city name.\n\n"]
[null,11,"Die Funktion INDIREKT() liefert als Ergebnis die Adresse einer Zelle oder eines Bereichs - in diesem Fall z.B. den Bereich mit dem Namen \"Germany\" - also die Liste der Städte in Deutschland.\n\nZum besseren Verständnis demonstriere ich die Funktion INDIREKT() mal am Beispiel der Summe.\n\nEs hat keinen Sinn, \"=INDIREKT(...)\" in eine Zelle zu schreiben. \n\nINDIREKT() kann immer nur als Argument einer anderen Funktion benutzt werden - und zwar immer dort, wo eine Zelle oder ein Bereich angegeben werden müssen.",null,11,"The function INDIRECT() returns the address of a cell or a range as the result - in this case, for example, the range with the name \"Germany\" - i.e. the list of cities in Germany. \n\nFor a better understanding, I will demonstrate the function INDIRECT() using the example of the sum.\n\nIt makes no sense to write \"=INDIRECT(...)\" in a cell. \n\nINDIRECT(...) can only be used as an argument of another function - and always where a cell or a range must be specified."]
[null,12,"Ich kann jetzt nachträglich alle Listen ändern. Wenn ich ein Land hinzufüge, muss ich natürlich eine Liste mit Städten anlegen und ihr den Namen des Landes geben.\n\nJetzt habe ich die totale Flexibilität in beiden Kombinationsfeldern für das Land und die Stadt!",null,12,"I can now change all the lists afterwards. When I add a country, of course I have to create a list of cities and give it the name of the country.\n\nNow I have total flexibility in both combo boxes for the country and the city!"]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"13 List data","index":29,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[null,null,null,null,null,0]
[1,"13 List data",null,null,null,"Back to Start"]
[2,"13 List data",null,null,null,"Startseite"]
[]
[null,"Germany","France","Netherlands","Belgium",null,"CMA","Contship","Hanjin","Hapag-Lloyd"]
[null,"Berlin","Paris","Amsterdam","Brüssel",null,"CMA CGM BERLIOZ","NORDPACIFIC","PEKING SENATOR","SANTIAGO EXPRESS"]
[null,"Hamburg","Bordeaux","Den Haag","Antwerpen",null,"CMA CGM KOMODO","TMM YUCATAN","PORTLAND SENATOR","SIERRA EXPRESS"]
[null,"Bremen","Marseille","Rotterdam","Lüttich",null,"CMA CGM BAUDELAIRE","NYK PASION","PUSAN SENATOR","HUMBOLDT EXPRESS"]
[null,"Frankfurt","Lyon",null,"Brügge",null,"CMA CGM COLOMBIE","LYKES ENVOY","PUDONG SENATOR","ALEMANIA EXPRESS"]
[null,"Köln","Nantes",null,"Gent",null,"CMA CGM KALAMATA","NYK PASION","PUGWASH SENATOR","BUNGA RAYA DUA"]
[null,"München","Nizza",null,null,null,"CMA CGM VOLTAIRE","ALTONIA","PUNJAB SENATOR","SIERRA EXPRESS"]
[null,"Stuttgart",null,null,null,null,"CMA CGM CLAUDEL",null,"YOKOHAMA SENATOR","NEDLLOYD EUROPA"]
[null,"Essen",null,null,null,null,"CMA CGM NORMANDIE",null,"PORTUGAL SENATOR","SANTIAGO EXPRESS"]
[null,null,null,null,null,null,"CMA CGM MAKASSAR",null,"PENANG SENATOR"]
[null,null,null,null,null,null,"CMA CGM RAVEL",null,"POHANG SENATOR"]
[null,null,null,null,null,null,"CMA CGM SEINE",null,"PEKING SENATOR"]
[null,null,null,null,null,null,"CMA CGM DEBUSSY",null,"PORTLAND SENATOR"]
[null,null,null,null,null,null,"CMA CGM BALZAC"]
[null,null,null,null,null,null,"CMA CGM VERLAINE"]
[null,null,null,null,null,null,"CMA CGM PUGET"]
[null,null,null,null,null,null,"CMA CGM BIZET"]
[null,null,null,null,null,null,"CMA CGM COLOMBIE"]
[null,null,null,null,null,null,"CMA CGM BERLIOZ"]
[]
[]
[null,"Countries"]
[null,"Germany"]
[null,"France"]
[null,"Netherlands"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Germany"]
[null,"Berlin"]
[null,"Hamburg"]
[null,"Bremen"]
[null,"Frankfurt"]
[null,"Köln"]
[null,"München"]
[null,"Stuttgart"]
[null,"Essen"]
[]
[]
[]
[null,"France"]
[null,"Paris"]
[null,"Bordeaux"]
[null,"Marseille"]
[null,"Lyon"]
[null,"Nantes"]
[null,"Nizza"]
[]
[]
[]
[]
[null,"Netherlands"]
[null,"Amsterdam"]
[null,"Den Haag"]
[null,"Rotterdam"]
[]
[]
[]
[]
[null,"Belgium"]
[null,"Brüssel"]
[null,"Antwerpen"]
[null,"Lüttich"]
[null,"Brügge"]
[null,"Gent"]
[]
[]
[0]

{"sheet":"14 Absol.-relativ-kumul. (A)","index":30,"n_rows":120,"n_cols":10,"rows_kept":120,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[57,2,57,7],[56,2,56,7],[17,2,17,8],[19,2,19,8],[38,2,38,8],[40,2,40,8],[32,3,33,8],[34,3,35,8],[51,3,52,8],[53,3,54,8],[20,3,20,8],[21,3,21,8],[95,2,95,3],[96,2,96,3],[97,2,97,3],[98,2,98,3],[83,3,86,7],[87,3,90,7],[94,2,94,3],[92,2,92,3],[93,2,93,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[110,2,110,3],[111,2,111,3],[112,2,112,3],[113,2,113,3],[119,2,119,3],[114,2,114,3],[115,2,115,3],[116,2,116,3],[117,2,117,3],[118,2,118,3]]}
[null,null,null,null,null,null,null,null,null,0]
[1,"14 Absol.-relative-cumul. (E)",null,null,null,"Back to Start"]
[2,"14 Absol.-relativ-kumul. (A)",null,null,null,"Startseite"]
[]
[1,"Relative share"]
[2,"Relativer Anteil"]
[null,null,null,"category","total sales","relative share"]
[null,null,null,"beverages",267868.15999999997,{"$f":"E8/SUM($E$8:$E$15)","v":0.21162961341426362},null,{"$f":"_xlfn.FORMULATEXT(F8)","v":"=E8/SUMME($E$8:$E$15)"}]
[null,null,null,"milk products",234454.76,0.1852313101412798,null,{"$f":"_xlfn.FORMULATEXT(F9)","v":"=E9/SUMME($E$8:$E$15)"}]
[null,null,null,"sweets",167357.19,0.13222078137915858,null,"=E10/SUMME($E$8:$E$15)"]
[null,null,null,"meat",163022.37,0.12879605079221454,null,"=E11/SUMME($E$8:$E$15)"]
[null,null,null,"sea food",131261.73000000001,0.10370351286240012,null,"=E12/SUMME($E$8:$E$15)"]
[null,null,null,"spices",106047.07,8.3782635561521601E-2,null,"=E13/SUMME($E$8:$E$15)"]
[null,null,null,"natural products",99984.57,7.8992948980914274E-2,null,"=E14/SUMME($E$8:$E$15)"]
[null,null,null,"cereals",95744.59,7.5643146868247316E-2,null,"=E15/SUMME($E$8:$E$15)"]
[]
[1,"Cumulated absolute values"]
[1,null,"Attention: The cumulation does only make sense, if the values are ordered descending!"]
[2,"Kumulierte absolute Werte"]
[2,null,"Achtung: Das Kumulieren hat nur Sinn, wenn die Werte absteigend sortiert sind!"]
[2,null,"ACHTUNG!!!","Es heißt weder kommulieren, noch kummulieren, noch krummulieren, noch kommolieren, sondern   k u m u l i e r e n !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!"]
[2,null,null,"!!!!!  kumulieren  !!!!!"]
[null,null,null,"category","total sales","cumulated absolute values"]
[null,null,null,"beverages",267868.15999999997,{"$f":"SUM($E$24:E24)","v":267868.15999999997},null,{"$f":"_xlfn.FORMULATEXT(F24)","v":"=SUMME($E$24:E24)"}]
[null,null,null,"milk products",234454.76,{"$f":"SUM($E$24:E25)","v":502322.92},null,{"$f":"_xlfn.FORMULATEXT(F25)","v":"=SUMME($E$24:E25)"}]
[null,null,null,"sweets",167357.19,{"$f":"SUM($E$24:E26)","v":669680.11},null,"=SUMME($E$24:E26)"]
[null,null,null,"meat",163022.37,{"$f":"SUM($E$24:E27)","v":832702.48},null,"=SUMME($E$24:E27)"]
[null,null,null,"sea food",131261.73000000001,{"$f":"SUM($E$24:E28)","v":963964.21},null,"=SUMME($E$24:E28)"]
[null,null,null,"spices",106047.07,{"$f":"SUM($E$24:E29)","v":1070011.28},null,"=SUMME($E$24:E29)"]
[null,null,null,"natural products",99984.57,{"$f":"SUM($E$24:E30)","v":1169995.8500000001},null,"=SUMME($E$24:E30)"]
[null,null,null,"cereals",95744.59,{"$f":"SUM($E$24:E31)","v":1265740.4400000002},null,"=SUMME($E$24:E31)"]
[]
[1,null,"=>","\"Our total turnover with the three top-selling product categories (beverages, milk products and sweets) is about 670.000€.\""]
[1]
[2,null,"=>","\"Unser Gesamtumsatz mit den drei umsatzstärksten Produktgruppen (Getränke, Milchprodukte und Süßigkeiten) beträgt ca. 670.000€.\""]
[2]
[]
[1,"Cumulated relative values"]
[1,null,"Attention: The cumulation does only make sense, if the values are ordered descending!"]
[2,"Kumulierte relative Werte"]
[2,null,"Achtung: Das Kumulieren hat nur Sinn, wenn die Werte absteigend sortiert sind!"]
[null,null,null,"category","total sales","cumulated relative values"]
[null,null,null,"beverages",267868.15999999997,{"$f":"SUM($E$43:E43)/SUM($E$43:$E$50)","v":0.21162961341426362},null,{"$f":"_xlfn.FORMULATEXT(F43)","v":"=SUMME($E$43:E43)/SUMME($E$43:$E$50)"}]
[null,null,null,"milk products",234454.76,{"$f":"SUM($E$43:E44)/SUM($E$43:$E$50)","v":0.39686092355554342},null,{"$f":"_xlfn.FORMULATEXT(F44)","v":"=SUMME($E$43:E44)/SUMME($E$43:$E$50)"}]
[null,null,null,"sweets",167357.19,{"$f":"SUM($E$43:E45)/SUM($E$43:$E$50)","v":0.52908170493470197},null,"=SUMME($E$43:E45)/SUMME($E$43:$E$50)"]
[null,null,null,"meat",163022.37,{"$f":"SUM($E$43:E46)/SUM($E$43:$E$50)","v":0.65787775572691654},null,"=SUMME($E$43:E46)/SUMME($E$43:$E$50)"]
[null,null,null,"sea food",131261.73000000001,{"$f":"SUM($E$43:E47)/SUM($E$43:$E$50)","v":0.76158126858931663},null,"=SUMME($E$43:E47)/SUMME($E$43:$E$50)"]
[null,null,null,"spices",106047.07,{"$f":"SUM($E$43:E48)/SUM($E$43:$E$50)","v":0.84536390415083829},null,"=SUMME($E$43:E48)/SUMME($E$43:$E$50)"]
[null,null,null,"natural products",99984.57,{"$f":"SUM($E$43:E49)/SUM($E$43:$E$50)","v":0.92435685313175264},null,"=SUMME($E$43:E49)/SUMME($E$43:$E$50)"]
[null,null,null,"cereals",95744.59,{"$f":"SUM($E$43:E50)/SUM($E$43:$E$50)","v":1},null,"=SUMME($E$43:E50)/SUMME($E$43:$E$50)"]
[]
[1,null,"=>","\"We make about half of our turnover with the three top-selling product categories (beverages, milk products and sweets).\""]
[1]
[2,null,"=>","\"Wir machen etwa die Hälfte unseres Gesamtumsatzes mit den drei umsatzstärksten Produktgruppen (Getränke, Milchprodukte und Süßigkeiten).\""]
[2]
[]
[1,"Exercise 1","Calculate the relative shares and the cumulated values in the following table:"]
[2,"Übung 1","Berechnen Sie relativen Anteile und die kumulierten Werte in folgender Tabelle:"]
[]
[null,null,null,"country","total sales","relative \nshare","cumulated absolute values","cumulated relative values"]
[null,null,null,"Argentina",8119.1]
[null,null,null,"Austria",128003.83]
[null,null,null,"Belgium",33824.85]
[null,null,null,"Brasilia",106925.78]
[null,null,null,"Canada",51129.79]
[null,null,null,"Danmark",32661.02]
[null,null,null,"Finland",18810.05]
[null,null,null,"France",81305.81]
[null,null,null,"Germany",229351.11]
[null,null,null,"Great Britain",58971.31]
[null,null,null,"Ireland",49979.91]
[null,null,null,"Italy",15770.15]
[null,null,null,"Mexico",23582.07]
[null,null,null,"Norway",5735.15]
[null,null,null,"Poland",3531.95]
[null,null,null,"Portugal",11472.36]
[null,null,null,"Spain",17983.2]
[null,null,null,"Sweden",54495.14]
[null,null,null,"Switzerland",31692.639999999999]
[null,null,null,"USA",245584.59]
[null,null,null,"Venezuela",56810.63]
[]
[]
[2,"Übung 2",null,"In der folgenden Tabelle werden Arbeitszeiten erfasst. In Spalte J sollen die Überstunden kumuliert werden. Entwickeln Sie die entsprechende Formel!\nAm Wochenende (=wenn es keinen Eintrag in Spalte E gibt), soll Spalte J leer bleiben. (-> mit einer WENN()-Formel!)"]
[2]
[2]
[2]
[1,"Exercise 2",null,"The following table records working hours. In column J, the extra hours are to be cumulated. Develop the corresponding formula!\nAt weekends (=if there is no entry in column E), column J should remain empty. (-> with an IF()-formula!)"]
[1]
[1]
[1]
[]
[2,null,"Tag",null,"Beginn","Ende","Pause","Ist-Arbeitszeit","Soll-Arbeitszeit","Überstunden"]
[1,null,"day",null,"start","end","break","working hours","regular hours","extra hours"]
[null,null,"2020-09-07",null,"07:35:00","16:20:00","00:45:00",{"$f":"IF(E95<>\"\",F95-E95-G95,\"\")","v":"08:00:00"},"07:00:00"]
[null,null,"2020-09-08",null,"07:40:00","15:25:00","00:45:00","07:00:00","07:00:00"]
[null,null,"2020-09-09",null,"07:15:00","17:00:00","00:45:00","09:00:00","07:00:00"]
[null,null,"2020-09-10",null,"07:20:00","15:05:00","00:45:00","07:00:00","07:00:00"]
[null,null,"2020-09-11",null,"07:30:00","14:15:00","00:45:00","06:00:00","06:00:00"]
[null,null,"2020-09-12",null,null,null,null,""]
[null,null,"2020-09-13",null,null,null,null,""]
[null,null,"2020-09-14",null,"07:15:00","17:00:00","00:45:00","09:00:00","07:00:00"]
[0,null,"2020-09-15",null,"07:35:00","16:20:00","00:45:00","08:00:00","07:00:00"]
[null,null,"2020-09-16",null,"07:35:00","16:20:00","00:45:00","08:00:00","07:00:00"]
[null,null,"2020-09-17",null,"07:30:00","14:15:00","00:45:00","06:00:00","07:00:00"]
[null,null,"2020-09-18",null,"07:20:00","15:05:00","00:45:00","07:00:00","06:00:00"]
[null,null,"2020-09-19",null,null,null,null,""]
[null,null,"2020-09-20",null,null,null,null,""]
[null,null,"2020-09-21",null,"07:20:00","15:05:00","00:45:00","07:00:00","07:00:00"]
[null,null,"2020-09-22",null,"07:35:00","16:20:00","00:45:00","08:00:00","07:00:00"]
[null,null,"2020-09-23",null,"07:30:00","14:15:00","00:45:00","06:00:00","07:00:00"]
[null,null,"2020-09-24",null,"07:15:00","17:00:00","00:45:00","09:00:00","07:00:00"]
[null,null,"2020-09-25",null,"07:35:00","16:20:00","00:45:00","08:00:00","06:00:00"]
[null,null,"2020-09-26",null,null,null,null,{"$f":"IF(E114<>\"\",F114-E114-G114,\"\")","v":""}]
[null,null,"2020-09-27",null,null,null,null,""]
[null,null,"2020-09-28",null,null,null,null,""]
[null,null,"2020-09-29",null,null,null,null,""]
[null,null,"2020-09-30",null,null,null,null,""]
[null,null,"2020-10-01",null,null,null,null,""]
[null,null,"2020-10-02",null,null,null,null,""]

{"sheet":"14 Absol.-relativ-kumul. (A)_","index":31,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"14 Absol.-relative-cumul. (E)_",null,null,null,{"$f":"B2","v":"14 Absol.-relative-cumul. (E)_"}]
[2,"14 Absol.-relativ-kumul. (A)_"]
[]
[null,1,"Was ein relativer Anteil ist und wie er berechnet wird, sollte jedem klar sein. Die 267.868,16€ Umsatz, die mit Getränken gemacht wurden, sind eben 21,2% vom Gesamtumsatz. \n\nDazu wird in der entsprechenden Formel der Getränkeumsatz durch den Gesamtumsatz (mit Dollarzeichen!) dividiert. Alles klar!",null,1,"What a relative share is and how it is calculated should be clear to everyone. The 267,868.16€ turnover made with beverages is just 21.2% of the total turnover. \n\nFor this purpose, the corresponding formula divides the beverage turnover by the total turnover (with dollar signs!). You got it!"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Kumulieren (ACHTUNG: Weder kummulieren noch kommulieren noch komulieren!) bedeutet, dass über die ersten zwei, drei, vier, … usw. Werte summiert wird. Mit Getränken, Milchprodukten und Süßigkeiten wurden also zusammen 669.680,11€ Umsatz gemacht. \n\nDie entsprechende Formel ist schon etwas trickreicher. Der Beginn des aufzusummierenden Bereichs wird mit Dollarzeichen festgehalten – das Ende nicht. Dadurch entsteht beim herunterkopieren eine Formel, die besagt: „Summiere von oben bis hier!“. Alles klar?\n\nACHTUNG: Das Kumulieren hat nur Sinn, wenn die Werteliste absteigend sortiert wird! Nur dann kann man nämlich sagen: „Mit den drei (oder vier oder fünf) umsatzstärksten Produkten machen wir einen Umsatz von … Euro.“ ",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"Cumulate (ATTENTION: Neither cummulate nor commulate nor comulate!) means that the first two, three, four, ... etc. values are added. Beverages, milk products and sweets together accounted for 669,680.11€ of sales. \n\nThe corresponding formula is a bit more tricky. The beginning of the area to be added up is fixed with dollar signs - the end is not. This means that when you copy it down, you get a formula that says: \"Sum from top to here!\" You got it?\n\nATTENTION: Cumulating only makes sense if the value list is sorted in descending order! Only then can you say: \"With the three (or four or five) top-selling products we make a turnover of ... Euro\". "]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Auf den ersten Blick erscheint die Formel für das relative Kumulieren besonders trickreich. Wenn Sie aber verstanden haben, was relative Anteile sind (Wert / Gesamtsumme) und was kumulierte Werte sind (Summe von oben bis hier), dann verstehen Sie auch die Formel für’s relative Kumulieren: \n\nDas sind einfach beide Formeln zusammen!! “Summe von oben bis hier – geteilt durch Summe über alle Werte.“\n\nEs werden also nicht absolute Werte, sondern relative Anteile kumuliert: „Mit den drei umsatzstärksten Produkten haben wir 52,9% unseres gesamten Umsatzes gemacht!“\n\nACHTUNG: Achten Sie beim Anwenden dieser Formel auf das richtige Setzen der Dollarzeichen!",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"At first glance, the formula for relative cumulation seems particularly tricky. But once you have understood what relative shares are (value / total sum) and what cumulative values are (sum from top to here), you will also understand the formula for relative cumulation: \n\nThese are simply both formulas together! \"Sum from top to here - divided by sum over all values.\"\n\nSo it is not absolute values but relative shares that are cumulated: \"With the three products with the highest turnover we made 52.9% of our total turnover!\"\n\nATTENTION: When applying this formula, make sure that you set the dollar signs correctly!"]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"15 Spur und Fehlerüberprüf.","index":32,"n_rows":106,"n_cols":19,"rows_kept":106,"cut":false,"hidden":false,"merged":[[104,2,104,8],[1,1,1,4],[2,1,2,4],[103,2,103,8]]}
[null,null,null,null,null,0]
[1,"15 Trace and Error Check",null,null,null,"Back to Start"]
[2,"15 Spur und Fehlerüberprüf.",null,null,null,"Startseite"]
[]
[2,"Spur zum Vorgänger / Nachfolger"]
[1,"Trace Precedents / Dependents"]
[]
[null,null,"container nr.","type","size","net costs","handling costs","cleaning costs","total costs"]
[null,null,"BGTR24175698","standard","40'",120,30,null,{"$f":"F9+G9+H9","v":150}]
[null,null,"KLPT76341290","standard","40'",210,62.5,40,{"$f":"SUM(F10:H10)","v":312.5}]
[null,null,"GTRQ54908754","reefer","40'",180,55,40,{"$f":"SUM(F11:H11)","v":275}]
[null,null,"HZWA43566532","flat","20'",150,37.5,null,{"$f":"SUM(F12:H12)","v":187.5}]
[null,null,null,null,null,null,null,"total net",{"$f":"SUM(I9:I12)","v":925}]
[null,null,null,null,null,null,0.19,"VAT",{"$f":"I13*G14","v":175.75}]
[null,null,null,null,null,null,null,"total gross",{"$f":"I13+I14","v":1100.75}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"Spur zum Fehler"]
[1,"Trace Error"]
[]
[]
[null,null,"container nr.","type","size","net costs","handling costs","cleaning costs","total costs"]
[null,null,"BGTR24175698","standard","40'",120,30,null,{"$f":"F46+G46+H46","v":150},{"$f":"_xlfn.FORMULATEXT(I46)","v":"=F46+G46+H46"}]
[null,null,"KLPT76341290","standard","40'",210,62.5,40,{"$f":"SUM(F47:H47)","v":312.5},{"$f":"_xlfn.FORMULATEXT(I47)","v":"=SUMME(F47:H47)"}]
[null,null,"GTRQ54908754","reefer","40'",180,55,40,{"$f":"SUM(F48:H48)","v":275},{"$f":"_xlfn.FORMULATEXT(I48)","v":"=SUMME(F48:H48)"}]
[null,null,"HZWA43566532","flat","20'",150,37.5,null,{"$f":"SUM(F49:H49)","v":187.5},{"$f":"_xlfn.FORMULATEXT(I49)","v":"=SUMME(F49:H49)"}]
[null,null,null,null,null,null,null,"total net",{"$f":"SUM(I46:I49)","v":925}]
[null,null,null,null,null,null,0.19,"VAT",{"$f":"I50*G51","v":175.75}]
[null,null,null,null,null,null,null,"total gross",{"$f":"I50+I51","v":1100.75}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"Zirkelbezug"]
[1,"Circular reference"]
[]
[null,null,"container nr.","type","size","net costs","handling costs","cleaning costs","total costs",null,"handling costs","test",0.2]
[null,null,"BGTR24175698","standard","40'",120,30,null,{"$f":"F82+G82+H82","v":150},null,{"$f":"$M$81*(F82+H82)/(1-$M$81)","v":30},{"$f":"K82/I82","v":0.2},null,null,null,"net + 0,2*total + cleaning","=","total"]
[null,null,"KLPT76341290","standard","40'",210,62.5,40,{"$f":"SUM(F83:H83)","v":312.5},null,{"$f":"$M$81*(F83+H83)/(1-$M$81)","v":62.5},{"$f":"K83/I83","v":0.2},null,null,null,"net + cleaning","=","0,8*total"]
[null,null,"GTRQ54908754","reefer","40'",180,55,40,{"$f":"SUM(F84:H84)","v":275},null,55,0.2,null,null,null,"total","=","(net + cleaning)/0,8"]
[null,null,"HZWA43566532","flat","20'",150,37.5,null,{"$f":"SUM(F85:H85)","v":187.5},null,{"$f":"$M$81*(F85+H85)/(1-$M$81)","v":37.5},0.2,null,null,null,"0,2*total","=","handling","= 0,2*(net + cleaning) / 0,8"]
[null,null,null,null,null,null,null,"total net",{"$f":"SUM(I82:I85)","v":925}]
[null,null,null,null,null,null,0.19,"VAT",{"$f":"I86*G87","v":175.75}]
[null,null,null,null,null,null,null,"total gross",{"$f":"I86+I87","v":1100.75}]
[]
[2,"ACHTUNG:"]
[1,"ATTENTION:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"Exercise","Train these techniques with the example table above!"]
[2,"Übung","Üben Sie diese Techniken mit der obigen Beispieltabelle!"]
[0]

{"sheet":"15 Spur und Fehlerüberprüf._","index":33,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"15 Trace and Error Check_",null,null,null,{"$f":"B2","v":"15 Trace and Error Check_"}]
[2,"15 Spur und Fehlerüberprüf._"]
[]
[null,1,"Auf Excel-Blättern gibt es häufig eine Kette von Berechnungen. Im Beispiel werden \n   - die Gesamt-Nettokosten pro Zeile (Spalte I) \n     aus den Einzelkosten (Spalten F, G, H)\n\n   - die Gesamt-Nettokosten (I13)\n     aus den Gesamt-Nettokosten \n     pro Zeile (I9:I12)\n\n   - die Gesamt-Bruttokosten (I15)\n     aus den Gesamt-Nettokosten (I13) und \n     der Mehrwertsteuer (I14)\n\nberechnet. \n\nWenn Sie jetzt in die letzte Zelle dieser Kette klicken (Bruttosumme) können Sie herausbekommen, aus welchen anderen Zellen sich dieser Wert berechnet. Dazu klicken Sie einfach mehrfach auf\n   - \"Formeln / Formelüberwachung / Spur zum Vorgänger\"\n\n",null,1,"On Excel worksheets there are often \"calculation chains\". In the example the total net costs per row (column I) are calculated \n          from the individual costs (columns F, G, H)\n   - the total net costs are calculated \n          from the total net costs per row and\n   - the total gross costs are calculated \n          from the total net costs and the VAT.\n\nIf you click into the last cell of this chain (the total gross costs) you can find out, how this value is calculated by clicking several times\n   - \"Formulas / Formula Auditing / Trace Precedents\"\n\n"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Umgekehrt können Sie z.B. eine Zelle in Spalte F (Nettokosten) anklicken und durch mehrfaches Klicken auf\n   - \"Formeln / Formelüberwachung / Spur zum Nachfolger\"\nherausbekommen, wo dieser Wert weiter zu Berechnungen verwendet wird.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"Vice versa you can also click in one cell in column F (net costs) and find out, how this value is used in other cells for calculations by clicking several times on\n   - \"Formulas / Formula Auditing / Trace Dependents\""]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Bei solchen \"Berechnungsketten\" kann eine \"Fehlerfortpflanzung\" entstehen: Ein Fehler in einer Zelle zieht eine Reihe von Fehlern in weiteren, davon abhängigen Zellen nach sich. Im Beispiel wurde Text statt einer Zahl eingegeben.\n\nACHTUNG: \nBeachten Sie, dass die Formel SUMME() trotzdem funktioniert!\n\nDieser Fehler pflanzt sich über die Zeilensummen und die Nettosummen bis zur Bruttosumme fort. Sie können dann in die Zelle mit der Bruttosumme klicken und mit  \n      - \"Formeln / Formelüberwachung / Fehlerüberprüfung / Spur zum Fehler\"\nvon der letzten Zelle aus (Bruttosumme) zurückverfolgen, wo der Fehler ursprünglich her kommt (Nettokosten). Nebenbei bekommen Sie auch eine Info über die Art des Fehlers.",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"In such \"calculation chains\" an \"error propagation\" may happen: One error in one cell is the cause for more errors in other cells. In the example, a text was entered instead of a number for the net costs.\n\nATTENTION: \nPlease note that the  formula SUM() nevertheless works!\n\nThis error propagates via the row sum and the net sum to the total gross. Now you can click into the cell with the total gross and click\n   - \"Formulas / Formula Auditing / Error Checking / Trace Error\"\nto trace back the error from the last cell (total gross) to its initial cause (total costs). Then you will also get an information about the type of error."]
[null,4,"Angenommen Sie versuchen folgendes: \nDie Handlingkosten sollen 20% der Gesamtkosten eines Containers betragen. Deshalb tragen Sie für die Handlingkosten in G82 folgende Formel ein: =I82*0,2. Daraufhin bekommen Sie eine Fehlermeldung, die Sie auf einen Zirkelbezug hinweist. Das bedeutet: Die Formel in I82 benötigt den Wert in G82 - aber die Formel in G82 benötigt wiederum den Wert in I82. Die Zellen beziehen sich also wechselseitig aufeinander. Das nennt man einen Zirkelbezug!\n\nProbieren Sie das bitte mit der Beispiel-Tabelle aus!\n\nACHTUNG: Diese Formel kann nicht funktionieren - Excel erlaubt Ihnen aber trotzdem, sie einzugeben! \n\nEs erscheint aber ein Pfeil zwischen den beiden Zellen, der Sie auf das Problem aufmerksam macht. Sie sollten es also am besten sofort beseitigen, indem Sie eine andere Formel eingeben.",null,4,"You may possibly try the following: The handling costs should be 20% of the total costs for one container. Therefore you enter the following formula for the handling costs in cell G82: =I82*0.2. Then you get an error message, which informs you about a circular reference. That means: The formula in I82 needs the value in G82 - but on the other hand the formula in G82 needs the value in I82. Both formulas references each other. This is called a \"circular reference\"!\n\nPlease check this out with the example table!\n\nATTENTION: This formula is incorrect - but nevertheless Excel allows you to enter it. \n\nBut an arrow appears between the two cells which draws your attention to this problem. Therefore you should correct the wrong formula immediately."]
[null,5,"Nebenbei etwas Mathematik - falls Sie sich fragen, wie Sie denn nun das Problem mit den 20% Handlingkosten lösen können.\n\nHier sehen Sie anhand einiger Gleichungsumformungen, wie man auf die Formel in Spalte K kommt.\n\nIch gehe davon aus, dass Sie das jetzt so schnell nicht überblicken. Sehen Sie sich das später in Ruhe in der Übungsdatei an. Vielleicht können Sie so etwas ja mal gebrauchen.",null,5,"Some mathematics on the side - in case you are wondering how to solve the problem with the 20% handling costs.\n\nHere you can see by means of some equation conversions how to get the formula in column K."]
[null,6,"ACHTUNG:\n\nEs kann vorkommen, dass Sie eine Excel-Datei (die Sie z.B. von jemand anderem bekommen haben) öffnen und Ihnen wird ein Zirkelbezug gemeldet. Die Stelle, an der sich dieser befindet, bekommen Sie leicht heraus: \n\n\"Formeln / Fehlerüberwachung / Fehlerüberprüfung / Zirkelbezüge\"\n\nDieser Menüpunkt ist natürlich nur aktiviert, wenn es tatsächlich Zirkelbezüge in der Datei gibt. Bitte probieren Sie das wieder mit der Beispiel-Tabelle aus!",null,6,"ATTENTION:\n\nIt may happen, that you open an Excel file (which you may have got from another person) and you get the error message \"Circular reference!\". The location of this circular reference can easily be detected:\n\n\"Formulas / Formula Auditing / Error Checking / Circular References\"\n\nOf course, this menu item is only activated, if there are circular references in the file.\nPlease check this out with the table above!"]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"16 Blattschutz","index":34,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[35,2,36,8],[37,2,38,8],[33,2,33,8],[1,1,1,4],[2,1,2,4],[32,2,32,8]]}
[null,null,null,null,null,0]
[1,"16 Sheet Protection",null,null,null,"Back to Start"]
[2,"16 Blattschutz",null,null,null,"Startseite"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"container nr.","type","size","net costs","handling costs","cleaning costs","total costs"]
[null,null,"BGTR24175698","standard","40''",120,{"$f":"0.2*(F24+H24)/(1-0.2)","v":30},null,{"$f":"SUM(F24:H24)","v":150}]
[null,null,"KLPT76341290","standard","40''",210,{"$f":"0.2*(F25+H25)/(1-0.2)","v":62.5},40,{"$f":"SUM(F25:H25)","v":312.5}]
[null,null,"GTRQ54908754","reefer","40''",180,55,40,{"$f":"SUM(F26:H26)","v":275}]
[null,null,"HZWA43566532","flat","20''",150,37.5,null,{"$f":"SUM(F27:H27)","v":187.5}]
[null,null,null,null,null,null,null,"total net",{"$f":"SUM(I24:I27)","v":925}]
[null,null,null,null,null,null,0.19,"VAT",{"$f":"I28*G29","v":175.75}]
[null,null,null,null,null,null,null,"total gross",{"$f":"I28+I29","v":1100.75}]
[]
[]
[1,"Exercise 1","Train this technique with the example table!"]
[2,"Übung 1","Üben Sie diese Technik mit der Beispieltabelle!"]
[]
[1,"Exercise 2","Try out what happens, if you deactivate the first two options in the window \"Protect Sheet\"!"]
[1]
[2,"Übung 2","Probieren Sie aus, was passiert, wenn Sie die ersten beiden Optionen im Fenster \"Blatt schützen\" deaktivieren!"]
[2]
[]
[]
[0]

{"sheet":"16 Blattschutz_","index":35,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"16 Sheet Protection_",null,null,null,{"$f":"B2","v":"16 Sheet Protection_"}]
[2,"16 Blattschutz_"]
[]
[null,1,"Wenn Sie ein Excel-Blatt entwickelt haben, möchten Sie bestimmt nicht, dass es von anderen oder sogar von Ihnen selber unabsichtlich zerstört wird - dass also z.B. Formeln gelöscht oder Formatierungen verändert werden. Daher sollten Sie Ihr Blatt vor unbeabsichtigten Veränderungen schützen.\n\nEs gibt aber auch Zellen, die verändert werden dürfen - in der Beispieltabelle z.B. die gelb markierten Zellen. Dort können Containerdaten eingetragen werden. Alles andere - insbesondere die Formeln zur Berechnung der Kosten in Spalte I - soll aber nicht verändert werden.\n\n",null,1,"If you have developed an Excel worksheet, then you certainly don't want, that somebody else (or even yourself!) destroyes something unintendedly - for example formulas may be deleted or formattings may be changed. Therefore you should protect the worksheet against unintended changes.\n\nOn the other hand there are also cells, which should be changed - for example the yellow range in the table. There you can enter container data. Everything else - especially the calculations in column I - must not be changed.\n\n"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Daher gehen Sie so vor:\n   - markieren Sie den gelben Bereich \n          (=Zellen die verändert werden dürfen \n           = nicht geschützt sind!)\n   - Klicken Sie mit der rechten Maustaste \n     in den markierten Bereich und\n   - wählen Sie \"Zellen formatieren\".\n   - Wählen Sie dann \"Schutz\" und\n   - deaktivieren Sie das Kontrollkästchen bei \"Gesperrt\".\n\nJetzt wird der markierte Bereich NICHT geschützt.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"Therefore do the following:\n   - mark the yellow range \n          (=cells which should be modifiable \n           = not protected!)\n   - click with the right mouse button \n     into the marked range and\n   - select \"Format Cells\".\n   - Select \"Protection\" and\n   - deactivate the check box \"Locked\".\n\nNow the marked range will NOT be protected. "]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Anschließend klicken Sie auf\n\n   \"Überprüfen / Änderungen / Blatt schützen\"\n\nDort können Sie dem Benutzer verschiedene Aktivitäten erlauben oder verbieten. Standardmäßig lassen Sie einfach die ersten beiden Optionen aktiviert und die übrigen deaktiviert.\n\nEin Kennwort sollten Sie nur vergeben, wenn das wirklich notwendig ist. Kennwörter werden leicht vergessen und dann können Sie Ihr Arbeitsblatt selber nicht mehr bearbeiten! ",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"Then click on\n\n   \"Review / Changes / Protect Sheet\"\n\nThere you can allow or forbid certain actions for the user. By default let the first two options activated and the rest deactivated.\n\nYou should only enter a password, if this is really necessary. Passwords are often forgotten and then you are unable to work with your own worksheet!"]
[null,4,"Wenn Sie jetzt auf \"OK\" klicken, wird das ganze Blatt geschützt - mit Ausnahme der Zellen, die Sie vorher vom Schutz ausgenommen haben (gelber Bereich).\n\nDie Zellen im gelben Bereich kann ich also jetzt bearbeiten - die übrigen nicht.",null,4,"If you now click \"OK\", the whole worksheet will be protected - with the exception of the cells you have marked before and defined as \"not to be protected\".\n\nSo I can now edit the cells in the yellow area - not the others."]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"17 Benutzerdef. Listen","index":36,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[null,null,null,null,null,0]
[1,"17 Custom lists",null,null,null,"Back to Start"]
[2,"17 Benutzerdef. Listen",null,null,null,"Startseite"]
[]
[]
[]
[]
[]
[]
[]
[0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Januar"]
[null,null,null,"Februar"]
[null,null,null,"März"]
[null,null,null,"April"]
[null,null,null,"Mai"]
[null,null,null,"Juni"]
[null,null,null,"Juli"]
[null,null,null,"August"]
[null,null,null,"September"]
[null,null,null,"Oktober"]
[null,null,null,"November"]
[null,null,null,"Dezember"]

{"sheet":"17 Benutzerdef. Listen_","index":37,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"17 Custom lists_",null,null,null,{"$f":"B2","v":"17 Custom lists_"}]
[2,"17 Benutzerdef. Listen_"]
[]
[null,1,"Excel kann bestimmte angefangene Reihen automatisch fortsetzen. Wenn Sie z.B. Januar und Februar in zwei untereinander liegende Zellen schreiben, dann beide Zellen markieren und gemeinsam herunter kopieren, setzt Excel automatisch mit März, April, … fort. Das nennt man \"Benutzerdefinierte Listen\". \n\nWelche Listen es gibt, sehen Sie hier:\n\n\"Datei / Optionen / Erweitert / Allgemein\"\n\nDort können Sie durch einen Klick auf \"Neue Liste\" auch neue Listen erstellen - siehe z.B. A, B, C, ... im Screenshot:",null,1,"Excel can automatically continue a series of values. If you - for example - enter January and February in two cells lying one below the other, then mark these two cells and copy them down together, Excel will automatically continue with March, April, …. This is called \"Custom lists\".\n\nYou can see, which lists are available, if you click:\n\n\"File / Options / Advanced / General\"\n\nThere you can also define new lists by clicking \"NEW LIST\" - see for example A, B, C, ... in the screenshot."]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":""},null,null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":""}]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":""},null,null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":""}]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"18 Benutzerdef. Formate","index":38,"n_rows":100,"n_cols":17,"rows_kept":100,"cut":false,"hidden":false,"merged":[[94,2,98,8],[1,1,1,4],[2,1,2,4],[89,2,93,8],[72,5,72,8],[73,5,73,8],[85,2,85,12],[87,2,87,12]]}
[null,null,null,null,null,null,null,null,null,null,null,1,1,2,2,null,0]
[1,"18 Custom formats",null,null,null,"Back to Start"]
[2,"18 Benutzerdef. Formate",null,null,null,"Startseite"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"Beispiel","unformatiert","formatiert","mit:","_-* #.##0,00 €_-;-* #.##0,00 €_-;_-* \"-\"?? €_-;_-@_-"]
[1,"Example","unformatted","formatted","with:","_-* #.##0,00 €_-;-* #.##0,00 €_-;_-* \"-\"?? €_-;_-@_-"]
[null,null,123456.78,{"$f":"C75","v":123456.78},null,null,null,null,null,null,"_-","means:","display an empty space as broad as a minus sign","bedeutet:","zeige ein Leerzeichen, das so breit ist wie ein Minuszeichen"]
[null,null,123,{"$f":"C76","v":123},null,null,null,null,null,null,"* ","means:","repeat the character behind the star (here: a space) to fill the cell completely","bedeutet:","wiederhole das Zeichen hinter dem Stern (hier: ein Leerzeichen) bis die gesamte Zelle ausgefüllt ist"]
[null,null,0.45669999999999999,{"$f":"C77","v":0.45669999999999999},null,null,null,null,null,null,"#","means:","display a decimal digit if there is one (\"can be\")","bedeutet:","zeige eine Dezimalstelle, wenn es eine gibt (\"kann\")"]
[null,null,0,{"$f":"C78","v":0},null,null,null,null,null,null,0,"means:","display a decimal digit (\"must be\"); if not existing, then 0","bedeutet:","zeige eine Dezimalstelle (\"muss\"); wenn keine vorhanden, dann 0"]
[null,null,null,0,null,null,null,null,null,null,"?","means:","display a decimal digit (\"must be\"); if not existing, then empty space","bedeutet:","zeige eine Dezimalstelle (\"muss\"); wenn keine vorhanden, dann Leerzeichen"]
[null,null,-123.45,-123.45,null,null,null,null,null,null,"\"-\"","means:","display a minus character","bedeutet:","zeige ein Minuszeichen"]
[null,null,-123,-123,null,null,null,null,null,null,"€","means:","display the € symbol","bedeutet:","zeige das Euro-Symbol"]
[null,null,-0.45,-0.45,null,null,null,null,null,null,"@","means:","display a text","bedeutet:","zeige einen Text an"]
[null,null,"text","text"]
[]
[2,"Hilfe","Hilfe / \"benutzerdefiniertes Format\" -> Treffer: \"Erstellen oder Löschen eines benutzerdefinierten Zahlenformats\""]
[2,null,"https://support.office.com/de-de/article/Erstellen-oder-L%C3%B6schen-eines-benutzerdefinierten-Zahlenformats-78f2a361-936b-4c03-8772-09fab54be7f4#"]
[1,"Help","Help / \"Custom format\" -> Hit: \"Create or delete a custom number format\""]
[1,null,"https://support.office.com/en-us/article/Create-or-delete-a-custom-number-format-78f2a361-936b-4c03-8772-09fab54be7f4"]
[]
[1,"Exercise","Explain the meaning of the following format definitions:\n   number:      0,00E+00\n   currency:    [Blue]#,#.\" T€ \";[Red]- #,#.\" T€ \";0\n   percent:      0,00%\n   date:           mm.dd.yyyy\" \"hh:mm AM/PM"]
[1]
[1]
[1]
[1]
[2,"Übung","Erklären Sie die Bedeutung der folgenden Formatdefinitionen:\n   Zahl:            0,00E+00\n   Währung:    [Blau]#,#.\" T€ \";[Rot]- #,#.\" T€ \";0\n   Prozent:      0,00%\n   Datum:        mm.tt.jjjj\" \"hh:mm AM/PM"]
[2]
[2]
[2]
[2]
[0]

{"sheet":"18 Benutzerdef. Formate_","index":39,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"18 Custom formats_",null,null,null,{"$f":"B2","v":"18 Custom formats_"}]
[2,"18 Benutzerdef. Formate_"]
[]
[null,1,"Mit \"Start / Zahl\" können Sie den Inhalt einer Zelle als Zahl, Währung, Datum, … usw. formatieren. Manchmal reichen die vorgegebenen Standardformate nicht aus. \n\nDann können Sie sich durch einen Klick auf \"Mehr …\" selber Formate definieren. Da das nicht ganz einfach ist, hat Microsoft schon ein paar häufig benötigte Spezialformate für Sie definiert. Das kann erschreckend kompliziert aussehen.\n",null,1,"With \"Home / Number\" you can format the content of a cell as a number, a currency, a date, … and so on. Sometimes the standard formats are not sufficient. \n\nThen you can click on \"More Number Formats …\" and define your own formats. Because this is not so simple, Microsoft has already pre-defined some of the mostly used special formats. This may look terrifying complicated.\n"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Für die Definition der Formate werden bestimmte Codezeichen benutzt - z.B. 0, #, _, ... usw. Die wichtigsten werden hier kurz erläutert.\n\nAußerdem kann jede Formatdefinition bis zu vier Definitionen enthalten - und zwar für positive Zahlen, negative Zahlen, Nullen und Texte. Die einzelnen Definitionen werden durch Semikolons voneinander getrennt. Dann sieht das z.B. so aus:\n\n_-* #.##0,00 €_- ; -* #.##0,00 €_- ; _-* \"-\"?? €_- ; _-@_-\n\nd.h.\npositive Zahlen so: _-* #.##0,00 €_-\nnegative Zahlen so: -* #.##0,00 €_-\nNullen so: _-* \"-\"?? €_-\nTexte so: _-@_-",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"For the definition of formats certain code symbols are used - like 0, #, _, ... and so on. The most important ones are explained here shortly.\n\nAdditionally, each format definition can contain up to four definitions - for positive and negative numbers, for zeros and for texts. The different definitions are separated from each other by semicolons:\n\n_-* #.##0,00 €_- ; -* #.##0,00 €_- ; _-* \"-\"?? €_- ; _-@_-\n\ni.e.\npositive numbers as: _-* #.##0,00 €_-\nnegative numbers as: -* #.##0,00 €_-\nzeros as: _-* \"-\"?? €_-\ntexts as: _-@_-"]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Das sieht kompliziert aus und das ist leider auch kompliziert. Das sollte für Sie aber kein Grund sein, sich nicht mit dem Thema zu beschäftigen. Benutzerdefinierte Formate sind außerordentlich nützlich - z.B. bei der Beschriftung von Achsen in Diagrammen.\n\nMeine Empfehlung: Versuchen Sie zunächst, bereits vorhandene benutzerdefinierte Formate zu verstehen und zu benutzen. Dann können Sie sich später daran wagen, selber welche zu definieren.\n\nAuf den folgenden Blättern dieser Datei gibt es viele Beispiele für benutzerdefinierte Formate. Bitte sehen Sie sich diese Formate an und \"spielen\" Sie etwas damit herum, um damit vertraut zu werden.",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"That looks complicated and unfortunately it is complicated. But that should not be a reason for you not to deal with the subject. Custom formats are extremely useful - e.g. when labelling axes in charts.\n\nMy recommendation: First try to understand and use existing custom formats. Then you can later dare to define some yourself.\n\nOn the following sheets of this file there are many examples of custom formats. Please have a look at these formats and \"play\" around with them a bit to get familiar with them."]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"19 Regionalisierung","index":40,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[null,null,null,null,null,0]
[1,"19 Regionalisation",null,null,null,"Back to Start"]
[2,"19 Regionalisierung",null,null,null,"Startseite"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"19 Regionalisierung_","index":41,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"19 Regionalisation_",null,null,null,{"$f":"B2","v":"19 Regionalisation_"}]
[2,"19 Regionalisierung_"]
[]
[null,1,"Wenn Zahlen, Währungsangaben, Datumsangaben oder Uhrzeiten nicht richtig angezeigt werden oder wenn Berechnungen nicht funktionieren, kann das auch an den regionalen Einstellungen auf Ihrem Computer liegen. \n\nDieses Problem entsteht insbesondere dann, wenn Sie Excel-Blätter auf einem Computer entwickelt haben und dann dieselbe Datei auf einem anderen Computer mit anderen regionalen Einstellungen benutzen wollen - z.B. erst auf Deutsch, dann auf Englisch.\n\nDie regionalen Einstellungen können Sie folgendermaßen überprüfen und ggf. ändern: (Microsoft hat das entsprechende Fenster leider sehr sorgfältig versteckt ;-)",null,1,"If numbers, currencies, dates or times are not displayed correctly of if calculations don't work, the reason may be the regional settings on your computer. \n\nThis problem arises especially then, if you have developed Excel worksheets on one computer and then try to use them on another one with other regional settings - e.g. first English and then German.\n\nYou can check and possibly change the regional settings as follows: (Microsoft has unfortunately hidden the corresponding window very carefully ;-)"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"\"Start\" (ACHTUNG: Nicht \"Excel-Start\", sondern \"Windows-Start\"!)\n\n\"Einstellungen\"\n\n\"Zeit und Sprache\"\n\n\"Region\"\n\n\"Verwandte Einstellungen (Zusätzliche Datums-, Uhrzeit- und Ländereinstellungen)\"\n\n\"Region (Datums-, Uhrzeit- oder Zahlenformat ändern)\"      \n\n\"Weitere Einstellungen …\"\n\n\"Zahlen\" / Währung\" / \"Uhrzeit\" / \"Datum\"",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"\"Home\" (ATTENTION: Not \"Excel Home\", but \"Windows Home\"!)\n\n\"Settings\"\n\n\"Time & Language\"\n\n\"Region\"\n\n\"Related settings (Additional date, time & regional settings)\"\n\n\"Region (Change date, time or number formats)\"\n\n\"Additional setings …\"\n\n\"Numbers\" / \"Currency\" / \"Time\" / Date\""]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"ACHTUNG:\n\nBeachten Sie insbesondere die Kategorie \"Kalender\" auf dem Register \"Datum\"! Dort können Sie festlegen, wie Excel zweistellige Jahreszahlen interpretiert:\n\n2.1.49 ==> 2.1.2049\n30.12.50 ==> 30.12.1950\n\nWenn Sie mein Video also nach 2050 sehen, sollten Sie diese Einstellung verändern.",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"ATTENTION:\n\nConsider especially the category \"Calendar\" on the register \"Date\"! There you can define, how Excel interprets two-digits years:\n\n1/2/49 ==> 1/2/2049\n12/30/50 ==> 12/30/1950\n\nSo if you watch my video after 2050, you should change this setting."]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"20 Zahlenformate","index":42,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[36,2,37,7],[38,2,39,7]]}
[null,null,null,null,null,null,null,null,2,1,null,null,null,0]
[1,"20 Number formats",null,null,null,"Back to Start"]
[2,"20 Zahlenformate",null,null,null,"Startseite"]
[]
[null,null,1234567.8,0,-98765.432100000005,0.1234,12.345000000000001,null,"\"Start / Zahl / Standard\"","\"Home / Number / Standard\""]
[]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},{"$f":"$G$5","v":12.345000000000001},null,"\"Start / Zahl / Zahlenformat\"","\"Home / Number / Number Format\""]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},12.345000000000001,null,"\"Start / Zahl / Währung\"","\"Home / Number / Currency\""]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},12.345000000000001,null,"\"Start / Zahl / Buchhaltung\"","\"Home / Number / Accounting\""]
[]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},12.345000000000001,null,"#.##0","#.##0"]
[]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},12.345000000000001,null,"#.##0,00","#.##0,00"]
[]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},12.345000000000001,null,"#.###,##","#.###,##"]
[]
[null,null,1234567.8,0,-98765.432100000005,{"$f":"$F$5","v":0.1234},12.345000000000001,null,"#.###,???","#.###,???"]
[]
[null,null,1234567.8,0,-98765.432100000005,{"$f":"$F$5","v":0.1234},12.345000000000001,null,"0.,## \"T\"","0.,## \"T\""]
[]
[null,null,1234567.8,0,-98765.432100000005,{"$f":"$F$5","v":0.1234},12.345000000000001,null,"0..,## \"Mio.\"","0..,## \"Mio.\""]
[]
[null,null,1234567.8,0,-98765.432100000005,{"$f":"$F$5","v":0.1234},12.345000000000001,null,"[Blau]* #.###,00\" € \";[Rot]-* #.###,00\" € \";0","[Blue]* #.###,00\" € \";[Red]-* #.###,00\" € \";0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"Exercise","Explain the different custom formats and what that means for the display of the different numbers!"]
[1]
[2,"Übung","Erläutern Sie die verschiedenen benutzerdefinierten Formate und was das für die Darstellung der verschiedenen Zahlen bedeutet!"]
[2]
[]
[0]

{"sheet":"21 Währungsformate","index":43,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[36,2,37,7],[38,2,39,7]]}
[null,null,null,null,null,null,null,null,2,1,null,0]
[1,"21 Currency formats",null,null,null,"Back to Start"]
[2,"21 Währungsformate",null,null,null,"Startseite"]
[]
[null,null,1234567.8,0,-98765.432100000005,0.1234,12.345000000000001,null,"\"Start / Zahl / Standard\"","\"Home / Number / Standard\""]
[]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},{"$f":"$G$5","v":12.345000000000001},null,"\"Start / Zahl / Zahlenformat\"","\"Home / Number / Number Format\""]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},12.345000000000001,null,"\"Start / Zahl / Währung\"","\"Home / Number / Currency\""]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},12.345000000000001,null,"\"Start / Zahl / Buchhaltung\"","\"Home / Number / Accounting\""]
[]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},12.345000000000001,null,"#.##0 _€;-#.##0 _€","#.##0 _€;-#.##0 _€"]
[]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},12.345000000000001,null,"#.##0 €;[Rot]-#.##0 €","#.##0 €;[Rot]-#.##0 €"]
[]
[null,null,{"$f":"$C$5","v":1234567.8},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-98765.432100000005},{"$f":"$F$5","v":0.1234},12.345000000000001,null,"_-* #.##0,00 €_-;-* #.##0,00 €_-;_-* \"-\"?? €_-;_-@_-","_-* #.##0,00 €_-;-* #.##0,00 €_-;_-* \"-\"?? €_-;_-@_-"]
[]
[null,null,1234567.8,0,-98765.432100000005,{"$f":"$F$5","v":0.1234},12.345000000000001,null,"[Blau]+ #.###,##\" € \";[Rot]- #.###,##\" € \";0","[Blue]+ #.###,##\" € \";[Red]- #.###,##\" € \";0"]
[]
[null,null,1234567.8,0,-98765.432100000005,{"$f":"$F$5","v":0.1234},12.345000000000001,null,"0.,## \"T€\"","0.,## \"T€\""]
[]
[null,null,1234567.8,0,-98765.432100000005,{"$f":"$F$5","v":0.1234},12.345000000000001,null,"0..,## \"Mio.€\"","0..,## \"Mio.€\""]
[]
[null,null,1234567.8,0,-98765.432100000005,{"$f":"$F$5","v":0.1234},12.345000000000001,null,"[Blau]* #.###,00\" € \";[Rot]-* #.###,00\" € \";0","[Blue]* #.###,00\" € \";[Red]-* #.###,00\" € \";0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"Exercise","Explain the different custom formats and what that means for the display of the different numbers!"]
[1]
[2,"Übung","Erläutern Sie die verschiedenen benutzerdefinierten Formate und was das für die Darstellung der verschiedenen Zahlen bedeutet!"]
[2]
[]
[0]

{"sheet":"22 Prozentformate","index":44,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[15,2,16,7],[17,2,18,7]]}
[null,null,null,null,null,null,null,null,2,1,null,0]
[1,"22 Percentage formats",null,null,null,"Back to Start"]
[2,"22 Prozentformate",null,null,null,"Startseite"]
[]
[null,null,0.45669999999999999,0,-0.43209999999999998,-0.05,0.2,null,"\"Start / Zahl / Standard\"","\"Home / Number / Standard\""]
[]
[null,null,{"$f":"$C$5","v":0.45669999999999999},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-0.43209999999999998},{"$f":"$F$5","v":-0.05},{"$f":"$G$5","v":0.2},null,"\"Start / Zahl / Prozent\"","\"Home / Number / Percentage\""]
[]
[null,null,{"$f":"$C$5","v":0.45669999999999999},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-0.43209999999999998},{"$f":"$F$5","v":-0.05},{"$f":"$G$5","v":0.2},null,"[Blau]+ #,##\" % \";[Rot]- #,##\" % \";0","[Blue]+ #,##\" % \";[Red]- #,##\" % \";0"]
[]
[null,null,{"$f":"$C$5","v":0.45669999999999999},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-0.43209999999999998},{"$f":"$F$5","v":-0.05},{"$f":"$G$5","v":0.2},null,"[Blau]* #,00\" % \";[Rot]-* #,00\" % \";0","[Blue]* #,00\" % \";[Red]-* #,00\" % \";0"]
[]
[null,null,{"$f":"$C$5","v":0.45669999999999999},{"$f":"$D$5","v":0},{"$f":"$E$5","v":-0.43209999999999998},{"$f":"$F$5","v":-0.05},{"$f":"$G$5","v":0.2},null,"[Blau]* 0,00\" % \";[Rot]-* 0,00\" % \";0","[Blue]* 0,00\" % \";[Red]-* 0,00\" % \";0"]
[]
[]
[1,"Exercise","Explain the different custom formats and what that means for the display of the different numbers!"]
[1]
[2,"Übung","Erläutern Sie die verschiedenen benutzerdefinierten Formate und was das für die Darstellung der verschiedenen Zahlen bedeutet!"]
[2]
[]
[]
[]
[0]

{"sheet":"23 Datumsformate","index":45,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":false,"merged":[[57,2,58,3],[59,2,60,3],[1,1,1,2],[2,1,2,2],[39,2,42,3],[43,2,46,3],[4,1,4,3],[5,1,5,3],[52,2,55,3],[48,2,51,3]]}
[null,null,null,null,null,2,1,null,0]
[1,"23 Date formats",null,"Back to Start"]
[2,"23 Datumsformate",null,"Startseite"]
[]
[1,"Excel stores a date as \"Time since the 1st, January, 1900\" (days before the point, hours after the point)"]
[2,"Excel speichert ein Datum als \"Zeit seit dem 1.1.1900\" (Tage vor dem Komma, Stunden nach dem Komma)"]
[]
[null,null,"2016-12-03","2016-12-03T18:00:00"]
[]
[null,null,{"$f":"$C$8","v":42707},{"$f":"$D$8","v":42707.75},null,"\"Start / Zahl / Standard\"","\"Home / Number / Standard\"",null,null,null,{"$f":"J10-I10","v":0}]
[null,null,{"$f":"$C$8","v":"2016-12-03"},{"$f":"$D$8","v":"2016-12-03T18:00:00"},null,"\"Start / Zahl / Datum, kurz\"","\"Home / Number / Short Date\""]
[null,null,"2016-12-03","2016-12-03T18:00:00",null,"\"Start / Zahl / Datum, lang\"","\"Home / Number / Long Date\""]
[null,null,42707,42707.75,null,"\"Start / Zahl / Zeit\"","\"Home / Number / Time\""]
[]
[2,null,"2016-12-03","2016-12-03T18:00:00",null,"\"Start / Zahl / Mehr...\" / \"Datum\"","\"Home / Number / More Number Formats ...\" / \"Date\""]
[1,null,"2016-12-03","2016-12-03T18:00:00",null,"\"Start / Zahl / Mehr...\" / \"Datum\"","\"Home / Number / More Number Formats ...\" / \"Date\""]
[]
[2,null,"2016-12-03","2016-12-03T18:00:00",null,"T.M.JJ"]
[1,null,"2016-12-03","2016-12-03T18:00:00",null,null,"d/m/yy"]
[]
[2,null,"2016-12-03","2016-12-03T18:00:00",null,"TT.MM.JJJJ"]
[1,null,"2016-12-03","2016-12-03T18:00:00",null,null,"m/d/yyyy"]
[]
[2,null,"2016-12-03","2016-12-03T18:00:00",null,"TT.MM.JJJJ hh:mm"]
[1,null,"2016-12-03","2016-12-03T18:00:00",null,null,"mm/dd/yyyy\" \"hh:mm AM/PM"]
[]
[2,null,"2016-12-03","2016-12-03T18:00:00",null,"TTT\", \"TT.MMM\" \"JJJJ"]
[1,null,"2016-12-03","2016-12-03T18:00:00",null,null,"mmm/ddd/dd/yyyy"]
[]
[2,null,"2016-12-03","2016-12-03T18:00:00",null,"TTTT\", \"TT.MMMM\" \"JJJJ"]
[1,null,"2016-12-03","2016-12-03T18:00:00",null,null,"mmmm/dddd/dd/yyyy"]
[]
[2,null,"2016-12-03","2016-12-03T18:00:00",null,"TTTT\", den \"T.MMMM\" \"JJJJ"]
[1,null,"2016-12-03","2016-12-03T18:00:00",null,null,"dddd\", the \"d\". of\" mmmm\" \"yyyy"]
[]
[2,null,"2016-12-03","2016-12-03T18:00:00",null,"TTTT\", den \"T.MMMM\" \"JJJJ\" um \"hh:mm\" Uhr\""]
[1,null,"2016-12-03","2016-12-03T18:00:00",null,null,"dddd\", the \"d\". of\" mmmm\" \"yyyy\" at \"hh:mm AM/PM"]
[]
[]
[1,"Attention","There is a special setting for the interpretation of two-digits year numbers (see sheet \"Regionalisation\" in this file!):\n2/1/29     ==> 2/1/2029\n12/30/30 ==> 12/30/1903"]
[1]
[1]
[1]
[2,"Achtung","Für die Interpretation von zweistelligen Jahreszahlen gibt es eine besondere Einstellung (siehe in dieser Datei auf dem Blatt \"Regionalisierung\"!):\n1.2.30     ==> 1.2.2030\n30.12.29 ==> 30.12.1929"]
[2]
[2]
[2]
[]
[1,"Attention","You can enter a date before the 1st, January 1900 - but it doesn't have the format \"Date\". You can realise this, because a date is displayed right-aligned whereas a text is displayed left-aligned. -------------------->\nThat means, you can not calculate with such a date - e.g. time differences. Nevertheless there is of course a trick - see \"Time differences\" in this file!",null,null,"1900-01-05"]
[1,null,null,null,null,"12/25/1899"]
[1,null,null,null,null,{"$f":"F49-F50","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.FORMULATEXT(F51)","v":"=F49-F50"}]
[1]
[2,"Achtung","Ein Datum vor dem 1.1.1900 können Sie zwar eingeben - es hat dann aber nicht das Format \"Datum\". Das erkennen Sie daran, dass ein Datum rechtsbündig, ein Text linksbündig angezeigt wird.  -------------->\nDas bedeutet, Sie können damit nicht rechnen - z.B. Zeitdifferenzen berechnen. Trotzdem gibt es dafür natürlich wieder einen Trick - siehe \"Zeitdifferenzen\" in dieser Datei!",null,null,"1900-01-05"]
[2,null,null,null,null,"25.12.1899"]
[2,null,null,null,null,{"$f":"F53-F54","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.FORMULATEXT(F55)","v":"=F53-F54"}]
[2]
[]
[1,"Exercise","Explain the different custom formats and what that means for the display of the dates!"]
[1]
[2,"Übung","Erläutern Sie die verschiedenen benutzerdefinierten Formate und was das für die Darstellung der Datumsangaben bedeutet!"]
[2]
[]
[0]

{"sheet":"24 Zeitdifferenzen (A)","index":46,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":false,"merged":[[103,4,103,6],[101,4,101,6],[102,4,102,6],[56,2,56,6],[1,1,1,4],[2,1,2,4],[4,1,4,6],[5,1,5,6],[32,2,33,6],[34,2,35,6],[55,2,55,6],[86,2,86,6],[87,2,87,6],[68,2,68,6],[69,2,69,6]]}
[null,null,null,null,null,null,null,null,0]
[1,"24 Time differences (E)",null,null,null,"Back to Start"]
[2,"24 Zeitdifferenzen (A)",null,null,null,"Startseite"]
[]
[1,"Excel stores a date as \"Time since the 1st, January, 1900\" (days before the point, hours after the point)"]
[2,"Excel speichert ein Datum als \"Zeit seit dem 1.1.1900\" (Tage vor dem Komma, Stunden nach dem Komma)"]
[]
[2,"Formeln","Format:",null,null,"Format = \"Standard\""]
[1,"Formulas","Format:",null,null,"Format = \"General\""]
[null,null,"\"TT.MM.JJJJ hh:mm\"",{"$f":"NOW()","v":"2023-02-28T10:21:25.980"},{"$f":"_xlfn.FORMULATEXT(D10)","v":"=JETZT()"},{"$f":"D10","v":44985.431550694448}]
[null,null,"\"Datum\" ... \"Date\"",{"$f":"TODAY()","v":"2023-02-28"},{"$f":"_xlfn.FORMULATEXT(D11)","v":"=HEUTE()"},{"$f":"D11","v":44985}]
[null,null,"\"Standard\" ... \"General\"",{"$f":"YEAR(TODAY())","v":2023},{"$f":"_xlfn.FORMULATEXT(D12)","v":"=JAHR(HEUTE())"},{"$f":"D12","v":2023}]
[null,null,"\"Standard\" ... \"General\"",{"$f":"MONTH(TODAY())","v":2},{"$f":"_xlfn.FORMULATEXT(D13)","v":"=MONAT(HEUTE())"},{"$f":"D13","v":2}]
[null,null,"\"Standard\" ... \"General\"",{"$f":"DAY(TODAY())","v":28},{"$f":"_xlfn.FORMULATEXT(D14)","v":"=TAG(HEUTE())"},{"$f":"D14","v":28}]
[]
[]
[1,"Diff. in hours",null,null,null,null,null,"may be wrong!","right!","may be wrong!","right!","may be wrong!"]
[2,"Diff. in Stunden",null,null,null,null,null,"kann falsch sein!","richtig!","kann falsch sein!","richtig!","kann falsch sein!"]
[1,null,"time difference \non one day","date 1","date 2","Format \n\"General\"","* 24","Format \n\"Time\"","custom format \n[hh]:mm","custom format \nhh:mm","custom format \ndd hh:mm","custom format \ndd [hh]:mm"]
[2,null,"Zeitdifferenz \nan einem Tag","Datum 1","Datum 2","Format \n\"Standard\"","mal 24","Format \n\"Uhrzeit\"","benutzerdefiniertes Format [hh]:mm","benutzerdefiniertes Format hh:mm","benutzerdefiniertes Format TT hh:mm","benutzerdefiniertes Format TT [hh]:mm"]
[null,null,null,"2020-05-10T08:30:00","2020-05-10T15:00:00",{"$f":"E21-D21","v":0.27083333333575865},{"$f":"(E21-D21)*24","v":6.5000000000582077},{"$f":"E21-D21","v":"06:30:00"},{"$f":"E21-D21","v":0.27083333333575865},{"$f":"E21-D21","v":"06:30:00"},{"$f":"E21-D21","v":"06:30:00"},{"$f":"E21-D21","v":0.27083333333575865}]
[]
[2,null,"Zeitdifferenz über zwei Tage"]
[1,null,"time difference over  two days"]
[null,null,"less than 24 hours","2020-05-09T18:00:00","2020-05-10T15:00:00",{"$f":"E25-D25","v":0.875},{"$f":"(E25-D25)*24","v":21},{"$f":"E25-D25","v":"21:00:00"},{"$f":"E25-D25","v":0.875},{"$f":"E25-D25","v":"21:00:00"},{"$f":"E25-D25","v":"21:00:00"},{"$f":"E25-D25","v":0.875}]
[null,null,"more than 24 hours","2020-05-09T10:00:00","2020-05-10T15:00:00",{"$f":"E26-D26","v":1.2083333333357587},{"$f":"(E26-D26)*24","v":29.000000000058208},{"$f":"E26-D26","v":1.2083333333357587},{"$f":"E26-D26","v":1.2083333333357587},1.2083333333357587,{"$f":"E26-D26","v":"1900-01-01T05:00:00"},1.2083333333357587]
[]
[2,null,"Zeitdifferenz über mehrere Tage"]
[1,null,"time difference over many days"]
[null,null,null,"2020-05-02T12:30:00","2020-05-10T15:00:00",{"$f":"E30-D30","v":8.1041666666642413},{"$f":"(E30-D30)*24","v":194.49999999994179},{"$f":"E30-D30","v":8.1041666666642413},{"$f":"E30-D30","v":8.1041666666642413},8.1041666666642413,{"$f":"E30-D30","v":"1900-01-08T02:30:00"},8.1041666666642413]
[]
[]
[1,"Exercise 1","Calculate the following time differences!"]
[1]
[2,"Übung 1","Berechnen Sie die folgende Zeitdifferenzen!"]
[2]
[]
[1,null,"arrival","departure","stay time (in hours, format \"General\")","stay time (in hours, \nformat \"[hh]:mm\")","stay time \n(format \"dd hh:mm\")"]
[2,null,"Ankunft","Abfahrt","Aufenthalt (in Std., Format \"Standard\")","Aufenthalt (in Std., Format \"[hh]:mm\")","Aufenthalt \n(Format \"TT hh:mm\")"]
[null,null,"2020-07-08T10:30:00","2020-07-08T16:00:00"]
[null,null,"2020-07-08T07:45:00","2020-07-08T16:00:00"]
[null,null,"2020-07-07T18:30:00","2020-07-08T16:00:00"]
[null,null,"2020-07-07T12:45:00","2020-07-08T16:00:00"]
[null,null,"2020-07-02T17:00:00","2020-07-08T16:00:00"]
[null,null,"2020-07-02T08:15:00","2020-07-08T16:00:00"]
[]
[1,"Diff. in months"]
[2,"Diff. in Monaten"]
[]
[1,null,"begin","Ende","difference in months"]
[2,null,"Beginn","Ende","Differenz in Monaten"]
[null,null,"2020-01-05","2020-03-06",{"$f":"DATEDIF(C52,D52,\"M\")","v":2},{"$f":"_xlfn.FORMULATEXT(E52)","v":"=DATEDIF(C52;D52;\"M\")"}]
[null,null,"2020-01-05","2020-04-04",{"$f":"DATEDIF(C53,D53,\"M\")","v":2},{"$f":"_xlfn.FORMULATEXT(E53)","v":"=DATEDIF(C53;D53;\"M\")"}]
[null,null,"2020-01-05","2020-04-10",{"$f":"DATEDIF(C54,D54,\"M\")","v":3},{"$f":"_xlfn.FORMULATEXT(E54)","v":"=DATEDIF(C54;D54;\"M\")"}]
[]
[1,"Attention","The difference is calculated in complete months - the additional days are neglected!"]
[2,"Achtung","Die Differenz wird in ganzen Monaten berechnet - zusätzliche Tage werden vernachlässigt!"]
[]
[1,"In 3 Monaten"]
[2,"In 3 months"]
[1,null,"2020-02-10","+ three months =",{"$f":"EDATE(C61,3)","v":"2020-05-10"},{"$f":"_xlfn.FORMULATEXT(E61)","v":"=EDATUM(C61;3)"},"difference in days:",{"$f":"E61-C61","v":90}]
[1,null,"2020-03-10","+ three months =",{"$f":"EDATE(C62,3)","v":"2020-06-10"},"=EDATUM(C62;3)","difference in days:",{"$f":"E62-C62","v":92}]
[1,null,"2020-03-31","+ three months =","2020-06-30","=EDATUM(C63;3)","difference in days:",91]
[2,null,"2020-02-10","+ drei Monate =","2020-05-10","=EDATUM(C64;3)","Differenz in Tagen:",90]
[2,null,"2020-03-10","+ drei Monate =","2020-06-10","=EDATUM(C65;3)","Differenz in Tagen:",92]
[2,null,"2020-03-31","+ drei Monate =","2020-06-30","=EDATUM(C66;3)","Differenz in Tagen:",91]
[]
[]
[1,"Exercise 2","Calculate the missing values in the following table!"]
[2,"Übung 2","Berechnen Sie die fehlenden Werte in der folgenden Tabelle!"]
[]
[1,null,"begin","end","diff. in months","begin + 3 months"]
[2,null,"Beginn","Ende","Diff. in Monaten","Beginn + 3 Monate"]
[null,null,"2020-01-12","2020-08-26"]
[null,null,"2020-04-01","2020-08-26"]
[null,null,"2020-01-01","2020-08-26"]
[null,null,"2020-03-31","2020-08-26"]
[]
[]
[1,"Diff. in years"]
[2,"Diff. in Jahren"]
[1,null,"date of birth","current date","age (in years)",null,"WRONG!"]
[2,null,"Geburtstag","aktuelles Datum","Alter (in Jahren)",null,"FALSCH!"]
[null,null,"1990-04-12","2020-04-11",{"$f":"DATEDIF(C84,D84,\"Y\")","v":29},{"$f":"_xlfn.FORMULATEXT(E84)","v":"=DATEDIF(C84;D84;\"Y\")"},{"$f":"(D84-C84)/365","v":30.019178082191782},{"$f":"_xlfn.FORMULATEXT(G84)","v":"=(D84-C84)/365"}]
[null,null,"1990-04-12","2020-04-12",{"$f":"DATEDIF(C85,D85,\"Y\")","v":30},{"$f":"_xlfn.FORMULATEXT(E85)","v":"=DATEDIF(C85;D85;\"Y\")"},{"$f":"(D85-C85)/365","v":30.021917808219179},{"$f":"_xlfn.FORMULATEXT(G85)","v":"=(D85-C85)/365"}]
[]
[1,"Exercise 3","Calculate the following ages!"]
[2,"Übung 3","Berechnen Sie die folgenden Altersangaben!"]
[1,null,"date of birth","current date","age (in years)"]
[2,null,"Geburtstag","aktuelles Datum","Alter (in Jahren)"]
[null,null,"1990-03-01","2020-02-27"]
[null,null,"1990-03-01","2020-03-02"]
[null,null,"1977-02-27","2020-02-25"]
[null,null,"1977-02-27","2020-03-02"]
[null,null,"1962-08-30","2020-08-27"]
[null,null,"1962-08-30","2020-09-02"]
[null,null,"1958-04-24","2020-04-20"]
[null,null,"1958-04-24","2020-04-24"]
[]
[1,"Before 1900/1/1"]
[2,"Vor dem 1.1.1900"]
[null,null,"1900-01-10",{"$f":"DATE(YEAR(C102)+400,MONTH(C102),DAY(C102))","v":"2300-01-10"},{"$f":"_xlfn.FORMULATEXT(D102)","v":"=DATUM(JAHR(C102)+400;MONAT(C102);TAG(C102))"}]
[null,null,"25.12.1899",{"$f":"DATE(RIGHT(C103,4)+400,MID(C103,4,2),MID(C103,1,2))","v":"2299-12-25"},{"$f":"_xlfn.FORMULATEXT(D103)","v":"=DATUM(RECHTS(C103;4)+400;TEIL(C103;4;2);TEIL(C103;1;2))"}]
[null,null,{"$f":"C102-C103","v":{"$error":"#VALUE!"}},{"$f":"D102-D103","v":16},{"$f":"_xlfn.FORMULATEXT(D104)","v":"=D102-D103"}]
[]
[]
[0]

{"sheet":"24 Zeitdifferenzen (A)_","index":47,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"24 Time differences (E)_",null,null,null,{"$f":"B2","v":"24 Time differences (E)_"}]
[2,"24 Zeitdifferenzen (A)_"]
[]
[null,1,"Die Berechnung von Zeitdifferenzen ist ein enorm wichtiges Thema für praktische Excel-Anwendungen im Unternehmen. Sie müssen Arbeitszeiten, Fahrzeiten von LKW's, Transportzeiten, … usw. berechnen.\n\nAls Voraussetzung dafür ist es erforderlich, dass Sie genau wissen, wie Excel Datum und Uhrzeit eigentlich speichert. Das ist nämlich gar nicht so selbstverständlich!",null,1,"The calculation of time differences is an enormously important topic for practical Excel applications in companies. You have to calculate working times, driving times of trucks, transport times, ... etc.\n\nAs a prerequisite, you need to know exactly how Excel actually stores the date and time. This is not a matter of course!"]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Das Wichtigste, was man zum Thema „Datum und Uhrzeit in Excel“ wissen muss, ist, dass Excel\n\ndas DATUM als ganze Zahl speichert, die die Anzahl der Tage seit dem 1.1.1900 angibt\nund\ndie UHRZEIT als Kommazahl dahinter. 12 Uhr mittags ist also …,5 – d.h. ein halber Tag.\n\nSehen Sie sich dazu bitte das Beispiel auf dem Blatt an. Hier werden mit Hilfe der Funktion JETZT() immer das aktuelle Datum und die aktuelle Uhrzeit angezeigt.\n\nUm das in der Zelle auch zu sehen, müssen Sie sie benutzerdefiniert formatieren. Mit dem Format „Datum“ sehen Sie die Uhrzeit nicht.\nWenn Sie die Zelle als „Standard“ formatieren, sehen Sie die Zahlen vor und nach dem Komma.\n\nWas HEUTE(), JAHR(), MONAT() und TAG() machen, sollte klar sein.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"The most important thing to know about \"Date and Time in Excel\" is that Excel\n\nstores the DATE as an integer number indicating the number of days since 1st, January 1900\nand\nthe TIME as a decimal point behind it. 12 noon is therefore ...,5 - i.e. half a day.\n\nPlease have a look at the example on the sheet. Here the function NOW() always shows the current date and time.\n\nTo see this in the cell too, you have to use a custom format. With the format \"date\" you will not see the time.\nIf you format the cell as \"standard\", you will see the numbers before and after the decimal point.\n\nWhat TODAY(), YEAR(), MONTH() and DAY() do should be clear."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Kommen wir jetzt also zu den Zeitdifferenzen. Die Speicherung eines Datums als Zahl erscheint zunächst merkwürdig – erweist sich aber bei der Berechnung von Zeitdifferenzen als äußerst nützlich. Sie können nämlich einfach zwei Datumsangaben voneinander abziehen.\n\nACHTUNG: Das Ergebnis hat die Maßeinheit „Tage“!\n\nWenn Sie es in Stunden haben wollen, müssen Sie es mit 24 multiplizieren. Ein halber Tag (0,5) sind also 0,5*24=12 Stunden. Ein viertel Tag (0,25) sind entsprechend 0,25*24=6 Stunden.\n",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"Let us now turn to the time differences. The storage of a date as a number seems to be strange at first - but it proves to be extremely useful in the calculation of time differences. You can simply subtract two dates from each other.\n\nATTENTION: The result has the measurement unit \"days\"!\n\nIf you want it in hours, you have to multiply it by 24. So half a day (0.5) is 0.5*24=12 hours. A quarter day (0.25) is equivalent to 0.25*24=6 hours."]
[null,4,"ACHTUNG: Jetzt kommt eine ganz gemeine Falle!\n\nWenn Sie die Zeitdifferenz nicht als „6,5“, sondern als „6:30“ angezeigt haben wollen, müssen Sie ein ganz bestimmtes benutzerdefiniertes Format benutzen: [hh]:mm\n\nACHTUNG: Die eckigen Klammern sind sehr wichtig!!\n\nWenn Sie einfach nur das Format „Uhrzeit“ benutzen, KANN die Anzeige falsch werden- und zwar dann, wenn die Zeitdifferenz größer als 24 Stunden ist.\nBitte sehen Sie sich dazu das Beispiel an: „Uhrzeit“ – mit eckigen Klammern – ohne eckige Klammern.",null,4,"ATTENTION: Now comes a very nasty trap!\n\nIf you want the time difference to be displayed as \"6:30\" instead of \"6.5\", you have to use a very specific custom format: [hh]:mm\n\nATTENTION: The square brackets are very important!\n\nIf you simply use the \"Time\" format, the display MAY become incorrect if the time difference is greater than 24 hours.\nPlease have a look at the example: \"Time\" - with square brackets - without square brackets."]
[null,5,"Jetzt wird es aber noch verrückter!\n\nVielleicht möchten Sie 29 Stunden nicht als „29:00“ angezeigt bekommen, sondern als „1 05:00“ – also „ein Tag und 5 Stunden“. Dann müssen Sie das Format TT hh:mm benutzen – also OHNE eckige Klammern.\nWas sich Microsoft wohl dabei gedacht hat???\n\nBitte sehen Sie sich auch dazu wieder das Beispiel an: „Uhrzeit“ – ohne eckige Klammern – mit eckigen Klammern\n\n(Das Thema \"Benutzerdefinierte Formate\" wird detailliert erläutert in meiner Übungs-Datei \"Excel-Basics\"!)\n\nMit diesen Beispieldaten können Sie die Berechnung und Darstellung von Zeitdifferenzen üben.",null,5,"But now things are getting even crazier!\n\nMaybe you would like to have 29 hours displayed not as \"29:00\" but as \"1 05:00\" - that is \"one day and 5 hours\". Then you have to use the format TT hh:mm - that is WITHOUT square brackets.\nI wonder what Microsoft was thinking??\n\nPlease have a look at the example again: \"Time\" - without square brackets - with square brackets\n\n(The topic \"custom formats\" is explained in detail in my exercise file \"Excel-Basics\")!\n\nWith these example data you can practice the calculation and presentation of time differences."]
[null,6,"Die Differenz zweier Datumsangaben hat die Maßeinheit \"Tage\". Zur Umrechnung in\n   - Stunden nehmen Sie die Differenz also mit 24 mal\n   - Wochen teilen Sie die Differenz durch 7\n\nAber was ist mit Monaten? \nEin Monat kann ja 28, 29, 30 oder 31 Tage haben. \nDafür gibt es eine spezielle Excel-Funktion: DATEDIF().",null,6,"The difference between two dates is measured in days. To convert it into\n   - hours you have to multiply the difference with 24\n   - weeks you have to divide the difference by 7\n\nBut what about months? \nA month can have 28, 29, 30 or 31 days. \nTherefore there is a special Excel function: DATEDIF()"]
[null,7,"Ein weiteres Problem entsteht, wenn Sie von einem bestimmten Datum aus sagen wollen \"in 3 Monaten\". Wie viele Tage sollen Sie dann addieren? Auch hierfür gibt es eine spezielle Excel-Funktion: EDATUM().\n\nHier können Sie DATEDIF() und EDATUM() üben.",null,7,"Another problem arises, if you want to start at a certain date and then say \"in 3 months time\". How many days should you add? Also for this purpose there is a special Excel function: EDATE().\n\nHere you can train DATEDIF() and EDATE()."]
[null,8,"Ein ähnliches Problem wie bei den Monaten entsteht auch mit den Jahren.Wie können Sie eine Zeitdifferenz in Jahre umrechnen? Ein Jahr kann 365 oder 366 Tage haben! Sie können aber auch jetzt wieder DATEDIF() benutzen.\n\nHier können Sie das wieder üben.",null,8,"A similar problem as with the months arises with years. How can you convert a time difference into years? A year may have 365 or 366 days! Here you can also use the before mentioned Excel function DATEDIF().\n\nHere you can train it."]
[null,9,"Auf dem Blatt \"Datumsformate\" in dieser Datei wurde bereits darauf hingewiesen, dass man mit Datumsangaben vor dem 1.1.1900 nicht rechnen kann. Aber es gibt natürlich Tricks, die das trotzdem erlauben. Einer davon beruht darauf, dass unser Kalender so aufgebaut ist, dass er sich alle 400 Jahre wiederholt.\n\nDas bedeutet z.B., dass der 12.3.1618 auf denselben Wochentag fiel wie der 12.3.2018 - nämlich einen Dienstag.\n\nWenn Sie also die Differenz zweier Zeitangaben berechnen wollen, von denen eine oder beide vor dem 1.1.1900 liegen, können Sie zu beiden Zeiten 400 Jahre addieren und dann damit rechnen:",null,9,"On the sheet \"Date formats\" it was already said, that you can not calculate with dates before the 1st, January 1900. Nevertheless there are tricks, which make this possible. One of them is based on the fact, that our calendar repeats every 400 years.\n\nThat means, for example, that the 12th, March 1618 fell on the same weekday as the 12th, March 2018 - a tuesday.\n\nSo, if you want to calculate the difference between two dates, where one or both are before the 1st, January 1900, you can add 400 years to both dates and calculate with these dates:"]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"25 KALENDERWOCHE()","index":48,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,4,6,5],[1,1,1,4],[2,1,2,4],[5,6,5,9],[5,4,5,5],[6,8,6,9],[6,6,6,7]]}
[null,null,null,null,null,null,null,null,0]
[1,"25 WEEKNUM()",null,null,null,"Back to Start"]
[2,"25 KALENDERWOCHE()",null,null,null,"Startseite"]
[]
[]
[null,null,null,"Day","Week \n(Sunday = 1st Day)",null,"Week \n(Monday = 1st Day)"]
[null,null,null,null,"(-> US, UAE!)",null,"System 1",null,"System 2 (-> Europe!)"]
[null,null,"Saturday","2016-01-09",{"$f":"WEEKNUM(D8,1)","v":2},{"$f":"_xlfn.FORMULATEXT(E8)","v":"=KALENDERWOCHE(D8;1)"},{"$f":"WEEKNUM(D8,2)","v":2},{"$f":"_xlfn.FORMULATEXT(G8)","v":"=KALENDERWOCHE(D8;2)"},{"$f":"WEEKNUM(D8,21)","v":1},{"$f":"_xlfn.FORMULATEXT(I8)","v":"=KALENDERWOCHE(D8;21)"}]
[null,null,"Sunday","2016-01-10",{"$f":"WEEKNUM(D9,1)","v":3},{"$f":"_xlfn.FORMULATEXT(E9)","v":"=KALENDERWOCHE(D9;1)"},{"$f":"WEEKNUM(D9,2)","v":2},{"$f":"_xlfn.FORMULATEXT(G9)","v":"=KALENDERWOCHE(D9;2)"},{"$f":"WEEKNUM(D9,21)","v":1},{"$f":"_xlfn.FORMULATEXT(I9)","v":"=KALENDERWOCHE(D9;21)"}]
[null,null,"Monday","2016-01-11",3,"=KALENDERWOCHE(D10;1)",{"$f":"WEEKNUM(D10,2)","v":3},"=KALENDERWOCHE(D10;2)",{"$f":"WEEKNUM(D10,21)","v":2},"=KALENDERWOCHE(D10;21)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"25 KALENDERWOCHE()_","index":49,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"25 WEEKNUM()_",null,null,null,{"$f":"B2","v":"25 WEEKNUM()_"}]
[2,"25 KALENDERWOCHE()_"]
[]
[null,1,"Manchmal (z.B. bei der Projektplanung) braucht man die Kalenderwoche eines Datums. Sie wird mit der Excel-Funktion KALENDERWOCHE() berechnet. Leider ist das aus zwei Gründen etwas kompliziert:\n\n(1) In manchen Ländern ist der Sonntag der erste Tag der Woche und in anderen der Montag.\n\n(2) In manchen Ländern ist die Woche mit dem 1. Januar die erste Woche des Jahres (=\"System 1\"), in manchen die Woche mit dem ersten Donnerstag (=\"System 2\")\n\nDaher hat KALENDERWOCHE() neben dem Datum ein zweites Argument, mit dem das eingestellt werden kann.",null,1,"Sometimes (e.g. for project plans) the calendar week of a date is needed. It is calculated with the Excel function WEEKNUM(). Unfortunately their use is a bit complicated, because of two reasons:\n\n(1) In some countries the Sunday is the first day of the week and in other coutries the Monday.\n\n(2) In some countries the week with the 1st, January is the first week of the year (=\"System 1\"), in some coutries the week with the first Thursday (=\"System 2\"). \n\nTherefore WEEKNUM() has besides the date a second argument which can be used to define this."]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Der 1.1.2016 war ein Freitag. Daher begann die erste Woche des Jahres 2016 in den USA schon am 27.12.2015 - in Europa aber erst am Montag, den 4.1.2016!\n\nIn den USA muss man also als zweites Argument der Funktion KALENDERWOCHE() eine 1 einsetzen.\n\nUnd jetzt wird's wieder kurios:\n\nWenn Sie denken, Sie müssten für Europa - wie in der Hilfe angegeben - eine 2 einsetzen, dann liegen Sie leider falsch. Das funktioniert nicht! Sie müssen eine 21 schreiben. Verrückt! Muss man aber wissen.",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"The 1st January 2016 was a Friday. Therefore, in the US the first week of the year 2016 has already begun on Sunday,  27th December 2015 - whereas in Europe it began only on Monday, 4th January 2016!\n\nYou must therefore insert a 1 as the second argument of the WEEKNUM() function.\n\nAnd now it gets curious again:\n\nIf you think you have to insert a 2 for Europe - as indicated in the help - you are unfortunately wrong. This does not work! You have to write a 21. Crazy! But you have to know."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":""},null,null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":""}]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"26 WOCHENTAG()","index":50,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[18,6,18,7],[33,14,34,18],[35,14,36,18],[17,2,17,3],[17,4,17,5],[17,6,17,7],[33,2,34,7],[35,2,36,7],[18,2,18,3],[18,4,18,5]]}
[null,null,null,null,null,null,null,null,null,0]
[1,"26 WEEKDAY()",null,null,null,"Back to Start"]
[2,"26 WOCHENTAG()",null,null,null,"Startseite"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,null,"without second argument",null,"second argument = 1",null,"second argument = 2",null,"Format: \nDDDD",null,"Format: \nDDDD",null,"Format: \nDDDD",null,"with conditional formatting"]
[2,null,"ohne zweites Argument",null,"zweites Argument = 1",null,"zweites Argument = 2",null,"Format: \nTTTT",null,"Format: \nTTTT",null,"Format: \nTTTT",null,"mit\nbedingter\nFormatierung"]
[null,{"$f":"TODAY()+B21","v":"2023-03-05"}]
[null,5]
[null,{"$f":"B23-1","v":"2023-02-23"},{"$f":"WEEKDAY(B22)","v":5},{"$f":"_xlfn.FORMULATEXT(C22)","v":"=WOCHENTAG(B22)"},{"$f":"WEEKDAY(B22,1)","v":5},{"$f":"_xlfn.FORMULATEXT(E22)","v":"=WOCHENTAG(B22;1)"},{"$f":"WEEKDAY(B22,2)","v":4},{"$f":"_xlfn.FORMULATEXT(G22)","v":"=WOCHENTAG(B22;2)"},{"$f":"WEEKDAY(B22)","v":"1900-01-05"},{"$f":"_xlfn.FORMULATEXT(I22)","v":"=WOCHENTAG(B22)"},{"$f":"WEEKDAY(B22,1)","v":"1900-01-05"},{"$f":"_xlfn.FORMULATEXT(K22)","v":"=WOCHENTAG(B22;1)"},{"$f":"WEEKDAY(B22,2)","v":"1900-01-04"},{"$f":"_xlfn.FORMULATEXT(M22)","v":"=WOCHENTAG(B22;2)"},{"$f":"WEEKDAY(B22)","v":"1900-01-05"},{"$f":"_xlfn.FORMULATEXT(O22)","v":"=WOCHENTAG(B22)"}]
[null,"2023-02-24",{"$f":"WEEKDAY(B23)","v":6},{"$f":"_xlfn.FORMULATEXT(C23)","v":"=WOCHENTAG(B23)"},{"$f":"WEEKDAY(B23,1)","v":6},{"$f":"_xlfn.FORMULATEXT(E23)","v":"=WOCHENTAG(B23;1)"},{"$f":"WEEKDAY(B23,2)","v":5},{"$f":"_xlfn.FORMULATEXT(G23)","v":"=WOCHENTAG(B23;2)"},{"$f":"WEEKDAY(B23)","v":"1900-01-06"},{"$f":"_xlfn.FORMULATEXT(I23)","v":"=WOCHENTAG(B23)"},{"$f":"WEEKDAY(B23,1)","v":"1900-01-06"},{"$f":"_xlfn.FORMULATEXT(K23)","v":"=WOCHENTAG(B23;1)"},{"$f":"WEEKDAY(B23,2)","v":"1900-01-05"},{"$f":"_xlfn.FORMULATEXT(M23)","v":"=WOCHENTAG(B23;2)"},"1900-01-06",{"$f":"_xlfn.FORMULATEXT(O23)","v":"=WOCHENTAG(B23)"}]
[null,"2023-02-25",7,"=WOCHENTAG(B24)",7,"=WOCHENTAG(B24;1)",6,"=WOCHENTAG(B24;2)","1900-01-07","=WOCHENTAG(B24)","1900-01-07","=WOCHENTAG(B24;1)","1900-01-06","=WOCHENTAG(B24;2)","1900-01-07","=WOCHENTAG(B24)"]
[null,"2023-02-26",1,"=WOCHENTAG(B25)",1,"=WOCHENTAG(B25;1)",7,"=WOCHENTAG(B25;2)","1900-01-01","=WOCHENTAG(B25)","1900-01-01","=WOCHENTAG(B25;1)","1900-01-07","=WOCHENTAG(B25;2)","1900-01-01","=WOCHENTAG(B25)"]
[null,"2023-02-27",2,"=WOCHENTAG(B26)",2,"=WOCHENTAG(B26;1)",1,"=WOCHENTAG(B26;2)","1900-01-02","=WOCHENTAG(B26)","1900-01-02","=WOCHENTAG(B26;1)","1900-01-01","=WOCHENTAG(B26;2)","1900-01-02","=WOCHENTAG(B26)"]
[null,"2023-02-28",3,"=WOCHENTAG(B27)",3,"=WOCHENTAG(B27;1)",2,"=WOCHENTAG(B27;2)","1900-01-03","=WOCHENTAG(B27)","1900-01-03","=WOCHENTAG(B27;1)","1900-01-02","=WOCHENTAG(B27;2)","1900-01-03","=WOCHENTAG(B27)"]
[null,"2023-03-01",4,"=WOCHENTAG(B28)",4,"=WOCHENTAG(B28;1)",3,"=WOCHENTAG(B28;2)","1900-01-04","=WOCHENTAG(B28)","1900-01-04","=WOCHENTAG(B28;1)","1900-01-03","=WOCHENTAG(B28;2)","1900-01-04","=WOCHENTAG(B28)"]
[null,"2023-03-02",5,"=WOCHENTAG(B29)",5,"=WOCHENTAG(B29;1)",4,"=WOCHENTAG(B29;2)","1900-01-05","=WOCHENTAG(B29)","1900-01-05","=WOCHENTAG(B29;1)","1900-01-04","=WOCHENTAG(B29;2)","1900-01-05","=WOCHENTAG(B29)"]
[null,"2023-03-03",6,"=WOCHENTAG(B30)",6,"=WOCHENTAG(B30;1)",5,"=WOCHENTAG(B30;2)","1900-01-06","=WOCHENTAG(B30)","1900-01-06","=WOCHENTAG(B30;1)","1900-01-05","=WOCHENTAG(B30;2)","1900-01-06","=WOCHENTAG(B30)"]
[null,{"$f":"B32-1","v":"2023-03-04"},7,"=WOCHENTAG(B31)",7,"=WOCHENTAG(B31;1)",6,"=WOCHENTAG(B31;2)","1900-01-07","=WOCHENTAG(B31)","1900-01-07","=WOCHENTAG(B31;1)","1900-01-06","=WOCHENTAG(B31;2)","1900-01-07","=WOCHENTAG(B31)"]
[null,{"$f":"B20","v":"2023-03-05"},1,"=WOCHENTAG(B32)",1,"=WOCHENTAG(B32;1)",7,"=WOCHENTAG(B32;2)","1900-01-01","=WOCHENTAG(B32)","1900-01-01","=WOCHENTAG(B32;1)","1900-01-07","=WOCHENTAG(B32;2)","1900-01-01","=WOCHENTAG(B32)"]
[]
[2,"Achtung","Der heutige Tag wird durch bedingte Formatierung hervorgehoben! (siehe Blatt \"Bedingte Formatierung 2\" in dieser Datei!)",null,null,null,null,null,null,null,null,null,"FALSCH!!",null,"Das Wochenende wird durch bedingte Formatierung hervorgehoben! (siehe Blatt \"Einfache bed. Format.\" in dieser Datei!)"]
[2]
[1,"Attention","The current day is highlighted by conditional formatting! (see worksheet \"Conditional formatting 2\" in this file!)",null,null,null,null,null,null,null,null,null,"WRONG!!",null,"The weekend is highlighted by conditional formatting! (see \"Simple cond. format.\" in this file!)"]
[1]
[]
[0]

{"sheet":"26 WOCHENTAG()_","index":51,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"26 WEEKDAY()_",null,null,null,{"$f":"B2","v":"26 WEEKDAY()_"}]
[2,"26 WOCHENTAG()_"]
[]
[null,1,"Um herauszufinden, ob ein bestimmtes Datum auf einen Montag, Dienstag, … fällt, können Sie die Excel-Funktion WOCHENTAG() benutzen. Das ist wieder etwas kompliziert, weil Excel das Datum nicht direkt in \"Montag\", \"Dienstag\", … umwandelt, sondern in eine ganze Zahl, die die Nummer des Tages in der Woche angibt. \n\nEs hängt dann davon ab, wie der erste Tag der Woche definiert ist, ob z.B. der Tag Nummer 2 ein Montag ist (=Woche startet am Sonntag) oder ein Dienstag (=Woche startet am Montag).\n\nDaher hat WOCHENTAG() neben dem Datum ein zweites Argument, mit dem das eingestellt werden kann.",null,1,"To find out, that a certain date is a Monday, a Tuesday, … you can use the Excel function WEEKDAY(). Again this is a bit complicated, because Excel doesn't convert the date directly into \"Monday\", \"Tuesday\", …. but into an integer number which is the number of the day in the week. \n\nThen it depends on the definition of the start of the week, whether the day number 2, for example, is a Monday (=week starts on Sunday) or a Tuesday (=week starts on Monday). \n\nTherefore the function WEEKDAY() besides the date has a second argument, which can be used to define this."]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Bitte sehen Sie sich dazu die Liste mit Beispieldaten an. Das aktuelle Datum befindet sich in der Mitte der Liste. Ein Steuerelement vom Typ „Drehfeld“ wird benutzt, um das aktuelle Datum nach oben bzw. unten zu verschieben.\n\n(Steuerelemente werden ausführlich in meiner Übungsdatei „Excel-Controls“ erläutert!)\n\nDie Zeile mit dem aktuellen Datum wird mit bedingter Formatierung hervorgehoben (siehe \"Bedingte Formatierung 2\" hier in dieser Datei!).",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"Please have a look at the list with sample data. The current date is in the middle of the list. A control of the type \"spin button\" is used to move the current date up or down.\n\n(Controls are explained in detail in my exercise file \"Excel-Controls\"!)\n\nThe row with the current date is highlighted using conditional formatting (\"see \"Conditional formatting 2\" in this file)."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"In den Spalten rechts daneben sehen Sie die Ergebnisse der Funktion WOCHENTAG() ohne zweites Argument bzw. mit einer 1 oder einer 2 als zweites Argument. Unformatiert ist das Ergebnis nur eine Zahl. Wollen Sie den Wochentag ausgeschrieben haben, müssen Sie die Zelle mit dem benutzerdefinierten Format TTTT formatieren. \n\n(Benutzerdefinierte Formate werden ausführlich auf einem anderen Blatt dieser Übungsdatei erläutert!)",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"In the columns to the right you see the results of the function WEEKDAY() without a second argument or with a 1 or a 2 as second argument. Unformatted the result is just a number. If you want to write out the weekday, you have to format the cell with the user defined format DDDD. \n\n(Custom formats are explained in detail on another sheet in this exercise!)"]
[null,4,"ACHTUNG: Hier gibt es wieder eine gemeine Falle!\n\nSehen wir uns dazu einen Donnerstag an. Mit dem Argument \"1\" wird daraus eine 5 - in den USA ist es also der fünfte Tag der Woche. Mit dem Argument \"2\" wird daraus entsprechend eine 4, denn in Europa ist der Donnerstag der vierte Tag der Woche.\n\nFormatieren wir die Zelle mit dem benutzerdefinierten Format TTTT, wird der Name des Tages im System 2 (Europa) falsch, denn aus \"4\" wird \"Mittwoch\". Die Formatierung geht also offensichtlich immer vom System 1 (USA) aus!\n\nDaher scheint es am besten zu sein, wenn Sie WOCHENTAG() ohne zweites Argument benutzen. Dann geht Excel standardmäßig von System 1 aus und gibt den Namen des Wochentages richtig aus.",null,4,"ATTENTION: There is a nasty trap here again!\n\nLet's have a look at a Thursday. With the argument \"1\" it becomes a 5 - so in the USA it is the fifth day of the week. With the argument \"2\" it becomes a 4, because in Europe Thursday is the fourth day of the week.\n\nIf we format the cell with the user-defined format DDDD, the name of the day in system 2 (Europe) becomes wrong, because \"4\" becomes \"Wednesday\". So the formatting obviously always starts from system 1 (USA)!\n\nTherefore it seems to be best to use WEEKDAY() without a second argument. Then Excel assumes system 1 by default and prints the name of the weekday correctly."]
[null,5,"Dieselbe Falle schlägt zu, wenn Sie das Wochenende durch bedingte Formatierung hervorheben wollen. Dort müssen Sie als Bedingung für \"Sonntag\" eine \"1\" und für \"Samstag\" eine \"7\" benutzen! (=System 1)",null,5,"The same trap applies if you want to highlight the weekend with conditional formatting. There you have to use a \"1\" for \"Sunday\" and a \"7\" for \"Saturday\"! (=System 1)"]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]

{"sheet":"27 \"Seltsame\" Zeitformate (A)","index":52,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":false,"merged":[[33,10,36,11],[33,13,36,14],[33,15,36,17],[33,18,36,19],[1,1,1,4],[2,1,2,4],[6,10,6,20],[7,10,7,20],[29,10,32,11],[29,13,32,14],[29,15,32,17],[29,18,32,19]]}
[null,null,null,null,null,null,null,null,2,1,null,0]
[1,"27 \"Strange\" time formats (E)",null,null,null,"Back to Start"]
[2,"27 \"Seltsame\" Zeitformate (A)",null,null,null,"Startseite"]
[]
[]
[]
[2,null,null,null,null,null,null,null,null,null,"Berechnung der Löschdauer"]
[1,null,null,null,null,null,null,null,null,null,"Calculation of the duration of the discharge"]
[]
[null,null,null,null,null,null,null,null,null,null,"Format",null,null,"Format",null,"Format","Format","Format","Format","Format","Format"]
[2,"Schiff","Löschbeginn","Löschende","Ladebeginn","Ladeende","ETD","ATD",null,null,"Standard",null,null,"Standard",null,"Datum","Zeit","hh:mm","[hh]:mm","TT hh:mm","TT [hh]:mm"]
[1,"Vessel","Discharge Start","Discharge End","Load Start","Load End","ETD","ATD",null,null,"General",null,null,"General",null,"Date","Time","hh:mm","[hh]:mm","dd hh:mm","dd [hh]:mm"]
[null,"A","06.02.2019 02:45","06.02.2019 06:00","06.02.2019 03:50","06.02.2019 06:30","06.02.2019 08:00","06.02.2019 08:00",null,null,{"$f":"D13-C13","v":0.13541666666424135},{"$f":"_xlfn.FORMULATEXT(K13)","v":"=D13-C13"}]
[null,"B","06.02.2019 06:40","06.02.2019 10:05","06.02.2019 03:45","06.02.2019 20:35","06.02.2019 20:00","06.02.2019 20:55"]
[null,"C","06.02.2019 03:10","06.02.2019 12:55","06.02.2019 06:50","06.02.2019 14:00","06.02.2019 14:30","06.02.2019 14:30"]
[null,"D","06.02.2019 07:20","06.02.2019 12:40","06.02.2019 10:00","06.02.2019 11:45","06.02.2019 17:00","06.02.2019 12:45"]
[null,"E","06.02.2019 11:55","06.02.2019 12:10","06.02.2019 12:10","06.02.2019 12:35","06.02.2019 14:30","06.02.2019 12:40"]
[null,"F","06.02.2019 13:00","06.02.2019 14:45","06.02.2019 14:45","06.02.2019 19:05","06.02.2019 19:00","06.02.2019 19:15"]
[null,"G","06.02.2019 15:00","06.02.2019 18:45","06.02.2019 16:45","06.02.2019 17:00","06.02.2019 20:00","06.02.2019 19:40"]
[null,"H","06.02.2019 15:00","06.02.2019 16:30","06.02.2019 16:00","06.02.2019 17:15","06.02.2019 18:00","06.02.2019 17:30"]
[null,"I","06.02.2019 19:35","07.02.2019 02:50","06.02.2019 20:45","07.02.2019 04:40","07.02.2019 07:00","07.02.2019 07:00"]
[null,"J","06.02.2019 18:50","08.02.2019 05:00","06.02.2019 23:30","08.02.2019 10:00","08.02.2019 10:00","08.02.2019 10:20",null,null,null,null,null,null,null,null,null,null,null,null,null,"!!!"]
[null,"K","06.02.2019 23:05","07.02.2019 19:56","07.02.2019 00:50","08.02.2019 00:05","08.02.2019 00:30","08.02.2019 00:30"]
[]
[null,null,null,null,null,null,null,null,"Gesamtzeit:","Total time:",{"$f":"SUM(K13:K23)","v":0.13541666666424135},null,null,{"$f":"SUM(N13:N23)","v":0},null,0,0,0,0,0,0]
[]
[1,null,null,null,null,null,null,null,null,null,"in days",null,null,"in hours",null,"wrong!","wrong!","wrong!","right!","right!","wrong!"]
[2,null,null,null,null,null,null,null,null,null,"in Tagen",null,null,"in Stunden",null,"falsch!","falsch!","falsch!","richtig!","richtig!","falsch!"]
[1]
[1,null,null,null,null,null,null,null,null,null,"ATTENTION:\nThe measurement unit of time differences is DAYS!!",null,null,"For the conversion into hours you must multiply the difference with 24.",null,"The right  display format is very important. Some formats show wrong values!",null,null,"ATTENTION:\nPlease consider the right usage of squared brackets!!"]
[1]
[1]
[1]
[2,null,null,null,null,null,null,null,null,null,"ACHTUNG:\nDie Maßeinheit von Zeitdifferenzen ist TAGE!!",null,null,"Zur Umrechnung in Stunden müssen Sie die Differenz mit 24 multiplizieren.",null,"Die richtige Wahl des Anzeigeformats ist sehr wichtig. Einige Formate zeigen falsche Werte an!",null,null,"ACHTUNG:\nBitte beachten Sie die richtige Benutzung der eckigen Klammern!!"]
[2]
[2]
[2]
[]
[]
[0]

{"sheet":"28 UNIZEICHEN()","index":53,"n_rows":150,"n_cols":8,"rows_kept":150,"cut":false,"hidden":false,"merged":[[11,2,14,8],[1,1,1,4],[2,1,2,4],[4,2,7,8],[9,2,9,4],[9,6,9,8],[37,2,37,10],[16,2,16,4],[16,6,16,8],[18,2,18,4],[18,6,18,8],[20,2,24,8],[26,6,26,8],[28,2,31,8],[33,6,33,8],[35,2,35,4],[35,6,35,8],[36,2,36,4],[46,3,46,8],[47,2,47,8],[117,2,120,7],[121,2,124,7],[38,2,38,9],[39,6,39,8],[41,2,41,8],[42,3,42,8],[43,2,43,8],[45,2,45,8]]}
[null,null,null,null,null,0]
[1,"28 UNICHAR()",null,null,null,"Back to Start"]
[2,"28 UNIZEICHEN()",null,null,null,"Startseite"]
[]
[2,null,"Bei der Vorbereitung meiner Mathe-Vorlesung bin ich auf folgendes Problem gestoßen:\n\nDie Formatierung eines Zeichens als \"hochgestellt\" wird nicht übernommen, wenn man sich von einer anderen Zelle aus darauf bezieht:"]
[2]
[2]
[2]
[2]
[2,null,"Hier steht der formatierte Text:",null,null,null,"Hier will ich denselbem Text haben:"]
[]
[1,null,"When preparing for my maths lecture, I encountered the following problem:\n\nThe formatting of a character as \"superscript\" is not taken over if one refers to it from another cell:"]
[1]
[1]
[1]
[1]
[1,null,"This is the formatted text:",null,null,null,"Here I want to have the same text:"]
[]
[null,null,"y=2*x4 + 5*x3 - 8*x2 + x - 7",null,null,null,{"$f":"C19","v":"y=2*x4 + 5*x3 - 8*x2 + x - 7"}]
[]
[2,null,"Was kann man tun? Das Zauberwort lautet \"Unicode\"! Mit ihm können über 1 Million verschiedener Zeichen dargestellt werden. Zur Zeit (2022) werden davon nur ca. 300.000 genutzt. Das reicht aber schon, um kaum einen Wunsch offen zu lassen.\nDie obige Formel muss dann so geschrieben werden:"]
[2]
[2]
[2]
[2]
[2]
[2,null,null,null,null,null,"Dann funktioniert auch der Zellbezug:"]
[]
[1,null,"What can be done? The magic word is \"Unicode\"! It can be used to represent over 1 million different characters. At present (2022), only about 300,000 of them are used. But that is enough to leave hardly any wish unfulfilled.\nThe above formula must then be written like this:"]
[1]
[1]
[1]
[1]
[1,null,null,null,null,null,"Then the cell reference also works:"]
[]
[null,null,{"$f":"\"y=2*x\"&_xlfn.UNICHAR(8308)&\" + 5*x\"&_xlfn.UNICHAR(179)&\" - 8*x\"&_xlfn.UNICHAR(178)&\" + x - 7\"","v":"y=2*x⁴ + 5*x³ - 8*x² + x - 7"},null,null,null,{"$f":"C36","v":"y=2*x⁴ + 5*x³ - 8*x² + x - 7"}]
[1,null,{"$f":"\"y=2*x\"&_xludf.UNICHAR(8308)&\" + 5*x\"&_xludf.UNICHAR(179)&\" - 8*x\"&_xludf.UNICHAR(178)&\" + x - 7\"","v":{"$error":"#NAME?"}}]
[2,null,{"$f":"_xlfn.FORMULATEXT(C36)","v":"=\"y=2*x\"&UNIZEICHEN(8308)&\" + 5*x\"&UNIZEICHEN(179)&\" - 8*x\"&UNIZEICHEN(178)&\" + x - 7\""}]
[1,null,{"$f":"_xlfn.FORMULATEXT(C37)","v":"=\"y=2*x\"&UNICHAR(8308)&\" + 5*x\"&UNICHAR(179)&\" - 8*x\"&UNICHAR(178)&\" + x - 7\""}]
[null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(G36)","v":"=C36"}]
[]
[2,null,"Sehen Sie sich mal die Liste der Unicode-Zeichen an:"]
[2,null,null,"https://de.wikipedia.org/wiki/Liste_der_Unicodebl%C3%B6cke"]
[2,null,"Wie gesagt - da bleibt kein Wunsch offen!"]
[]
[1,null,"Take a look at the list of Unicode characters:"]
[1,null,null,"https://en.wikipedia.org/wiki/Unicode_block"]
[1,null,"As I said - no wish remains unfulfilled!"]
[]
[1,null,"dec","hex","UNICODE","example"]
[2,null,"dez","hex","UNIZEICHEN","Beispiel"]
[]
[null,null,185,{"$f":"DEC2HEX(C53)","v":"B9"},{"$f":"_xlfn.UNICHAR(C53)","v":"¹"},{"$f":"\"x\"&_xlfn.UNICHAR(C53)","v":"x¹"}]
[null,null,178,"B2","²","x²"]
[null,null,179,"B3","³","x³"]
[null,null,739,"2E3","ˣ",{"$f":"\"e\"&_xlfn.UNICHAR(C56)","v":"eˣ"},{"$f":"\"e\"&_xlfn.UNICHAR(179)&_xlfn.UNICHAR(8317)&_xlfn.UNICHAR(739)&_xlfn.UNICHAR(8315)&_xlfn.UNICHAR(185)&_xlfn.UNICHAR(8318)","v":"e³⁽ˣ⁻¹⁾"}]
[null,null,916,"394","Δ",{"$f":"_xlfn.UNICHAR(916)&\"x\"","v":"Δx"}]
[null,null,945,"3B1","α"]
[null,null,946,"3B2","β"]
[null,null,947,"3B3","γ"]
[null,null,948,"3B4","δ"]
[null,null,949,"3B5","ε"]
[null,null,950,"3B6","ζ"]
[null,null,8304,{"$f":"DEC2HEX(C64)","v":"2070"},{"$f":"_xlfn.UNICHAR(C64)","v":"⁰"},{"$f":"\"x\"&_xlfn.UNICHAR(C64)","v":"x⁰"}]
[null,null,8305,{"$f":"DEC2HEX(C65)","v":"2071"},{"$f":"_xlfn.UNICHAR(C65)","v":"ⁱ"},{"$f":"\"x\"&_xlfn.UNICHAR(C65)","v":"xⁱ"}]
[null,null,8306]
[null,null,8307]
[null,null,8308,{"$f":"DEC2HEX(C68)","v":"2074"},{"$f":"_xlfn.UNICHAR(C68)","v":"⁴"},"x⁴"]
[null,null,8309,{"$f":"DEC2HEX(C69)","v":"2075"},{"$f":"_xlfn.UNICHAR(C69)","v":"⁵"},"x⁵"]
[null,null,8310,{"$f":"DEC2HEX(C70)","v":"2076"},{"$f":"_xlfn.UNICHAR(C70)","v":"⁶"},"x⁶"]
[null,null,8311,{"$f":"DEC2HEX(C71)","v":"2077"},{"$f":"_xlfn.UNICHAR(C71)","v":"⁷"},"x⁷"]
[null,null,8312,{"$f":"DEC2HEX(C72)","v":"2078"},{"$f":"_xlfn.UNICHAR(C72)","v":"⁸"},"x⁸"]
[null,null,8313,{"$f":"DEC2HEX(C73)","v":"2079"},{"$f":"_xlfn.UNICHAR(C73)","v":"⁹"},"x⁹"]
[null,null,8314,"207A","⁺","x⁺"]
[null,null,8315,"207B","⁻","x⁻"]
[null,null,8316,"207C","⁼","x⁼"]
[null,null,8317,"207D","⁽","x⁽"]
[null,null,8318,"207E","⁾","x⁾"]
[null,null,8319,"207F","ⁿ",{"$f":"\"x\"&_xlfn.UNICHAR(C79)","v":"xⁿ"}]
[null,null,7488,"1D40","ᵀ",{"$f":"\"A\"&_xlfn.UNICHAR(C80)","v":"Aᵀ"}]
[]
[null,null,8320,"2080","₀","x₀"]
[null,null,8321,"2081","₁","x₁",{"$f":"\"x\"&_xlfn.UNICHAR(8321)&_xlfn.UNICHAR(8322)&\"=\"","v":"x₁₂="}]
[null,null,8322,"2082","₂","x₂"]
[null,null,8323,"2083","₃","x₃"]
[null,null,8324,"2084","₄","x₄"]
[null,null,8325,"2085","₅","x₅"]
[null,null,8326,"2086","₆","x₆"]
[null,null,8327,"2087","₇","x₇"]
[null,null,8328,"2088","₈","x₈"]
[null,null,8329,"2089","₉","x₉"]
[null,null,8330,"208A","₊","x₊"]
[null,null,8331,"208B","₋","x₋"]
[null,null,8332,"208C","₌","x₌"]
[null,null,8333,"208D","₍","x₍"]
[null,null,8334,"208E","₎","x₎"]
[null,null,8335]
[null,null,8336,"2090","ₐ","xₐ"]
[null,null,8337,"2091","ₑ","xₑ"]
[null,null,8341,"2095","ₕ","xₕ"]
[null,null,7522,"1D62","ᵢ","xᵢ"]
[null,null,8342,"2096","ₖ","xₖ"]
[null,null,8343,"2097","ₗ","xₗ"]
[null,null,8344,"2098","ₘ","xₘ",{"$f":"\"G\"&_xlfn.UNICHAR(8344)&_xlfn.UNICHAR(8336)&_xlfn.UNICHAR(8339)&\"=\"","v":"Gₘₐₓ="},{"$f":"\"G\"&_xlfn.UNICHAR(8344)&_xlfn.UNICHAR(7522)&_xlfn.UNICHAR(8345)&\"=\"","v":"Gₘᵢₙ="}]
[null,null,8345,"2099","ₙ","xₙ",{"$f":"\"x\"&_xlfn.UNICHAR(8345)&_xlfn.UNICHAR(8331)&_xlfn.UNICHAR(8321)","v":"xₙ₋₁"}]
[null,null,8338,"2092","ₒ","xₒ"]
[null,null,8346,"209A","ₚ","xₚ"]
[null,null,7523,"1D63","ᵣ","xᵣ"]
[null,null,8347,"209B","ₛ","xₛ"]
[null,null,8348,"209C","ₜ","xₜ"]
[null,null,7524,"1D64","ᵤ","xᵤ"]
[null,null,7525,"1D65","ᵥ","xᵥ"]
[null,null,8339,"2093","ₓ","xₓ"]
[null,null,8747,"222B","∫"]
[]
[]
[]
[2,"Anwendung","Eine mögliche Anwendung dieses Tricks ist hier zu sehen. Beachten Sie, dass y1 mit UNIZEICHEN() erzeugt wurde, y2 aber mit einer Formatierung. Letztere wird in der Legende des Diagramms nicht übernommen!"]
[2]
[2]
[2]
[1,"Application","A possible application of this trick can be seen here. Note that y1 was created with UNICHAR(), but y2 with formatting. The latter is not taken over in the legend of the chart!"]
[1]
[1]
[1]
[null,null,"x",{"$f":"\"y\"&_xlfn.UNICHAR(8321)","v":"y₁"},"y2"]
[null,null,-50,{"$f":"5*C127+50","v":-200},{"$f":"2*C127+100","v":0}]
[null,null,-45,{"$f":"5*C128+50","v":-175},{"$f":"2*C128+100","v":10}]
[null,null,-40,-150,20]
[null,null,-35,-125,30]
[null,null,-30,-100,40]
[null,null,-25,-75,50]
[null,null,-20,-50,60]
[null,null,-15,-25,70]
[null,null,-10,0,80]
[null,null,-5,25,90]
[null,null,0,50,100]
[null,null,5,75,110]
[null,null,10,100,120]
[null,null,15,125,130]
[null,null,20,150,140]
[null,null,25,175,150]
[null,null,30,200,160]
[null,null,35,225,170]
[null,null,40,250,180]
[null,null,45,275,190]
[null,null,50,300,200]
[]
[]
[0]

{"sheet":"27 \"Seltsame\" Zeitformate (A)_","index":54,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,2,2,2,1,1,1,0]
[1,"27 \"Strange\" time formats (E)_",null,null,null,{"$f":"B2","v":"27 \"Strange\" time formats (E)_"}]
[2,"27 \"Seltsame\" Zeitformate (A)_"]
[]
[null,1,"Die Zeitangaben in der Liste haben ein Format, das es in Excel gar nicht gibt. Es ist unmöglich, solche Daten einzugeben!\n\nSie können das überprüfen, indem Sie eine der Zellen doppelt anklicken und dann auf die Enter-Taste drücken. Der Zellinhalt wird automatisch in ein \"richtiges\" Excel-Zeitformat umgewandelt! Außerdem wird die Zelle rechtsbündig formatiert.\n\nSolche \"seltsamen\" Zeitformate entstehen beim Export von Daten aus anderen Anwendungen nach Excel.",null,1,"The time data in the above list have a format, which doesn't exist in Excel. It is not possible to enter such data!\n\nYou can check this, if you click into one of the cells and then press the \"Enter\" key. The content of the cell is automatically converted into a \"right\" Excel time format. The cell is also formatted right-aligned.\n\nSuch \"strange\" time formats appear if data are exported from other applications to Excel."]
[null,{"$f":"IF(C6<>\"\",B5+1,\"\")","v":2},"Sie können das auch überprüfen, indem Sie eine der Zellen anklicken und dann die Formatbox im Menü \"Start / Zahl\" öffnen.\n\nEine \"richtige\" Excel-Zeit wird dort unter \"Zahlenformat\" als Kommazahl angezeigt (z.B.: 43711,67).\n\nDie \"falsche\" Excel-Zeit wird dort als Zeit angezeigt (z.B. 03.09.2019 16:00).",null,{"$f":"IF(F6<>\"\",E5+1,\"\")","v":2},"You can also check this, if you click into one of the cells and then open the format box in the menu \"Home / Number\".\n\nA \"right\" Excel time is displayed there under \"Number\" as a decimal (e.g. 43711,67).\n\nThe \"wrong\" Excel time is displayed as a time (e.g. 03.09.2019 16:00)."]
[null,{"$f":"IF(C7<>\"\",B6+1,\"\")","v":3},"Zur Umwandlung des \"falschen\" Formats in das \"richtige\" Excel-Zeitformat können Sie den Excel-Formatkonverter benutzen:\n\n\"Daten / Datentools / Text in Spalten\"\n\nAllerdings funktioniert das immer nur für eine Spalte.\n\nZur Übung füllen Sie dann bitte die Tabelle in den Spalten K bis U aus und beobachten Sie sorgfältig, welche Zellen richtige und welche falsche Ergebnisse enthalten!",null,{"$f":"IF(F7<>\"\",E6+1,\"\")","v":3},"To change the \"wrong\" format to the \"right\" Excel time format you can use the Excel format converter:\n\n\"Data / Data Tools / Text to Columns\"\n\nHowever, this only works for one column at a time.\n\nFor practice, please fill in the table in columns K to U and observe carefully which cells contain correct results and which one incorrect ones!"]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[null,"",null,null,""]
[0,null,null,null,""]