{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Anleitung","Grunddaten","Firma A","Firma B","Firma C","Firma D","Firma E","Jahr 1","Jahr 2","Jahr 3","Jahr 4","Auswertung Managerlöhne","Auswertung Firmen","Grafiken","Musterlösung"],"not_rendered":{"charts":6,"images":9,"macros":1,"external_links":0,"defined_names":0,"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":"Anleitung","index":0,"n_rows":91,"n_cols":2,"rows_kept":91,"cut":false,"hidden":false,"merged":[[3,8,5,10],[7,0,8,8],[3,0,5,7],[29,1,33,7],[44,1,51,7],[10,0,23,7],[25,0,27,7],[35,1,38,7],[39,1,42,7],[90,0,91,7],[53,1,60,7],[62,1,70,7],[87,0,88,7],[83,0,85,7],[72,0,75,7],[77,0,81,7]]}
["Spieltheorie - Spitzenverdiener"]
["Anleitung Auswertung Lernspiel Cheflöhne"]
[]
["Hinweis: Die konkrete Spielanleitung befindet sich im Dokument «Spielanleitung Cheflöhne». Es werden hier lediglich die Schritte zur Auswertung des Spiels erläutert. Die Grunddaten des Spiels sind im Tabellenblatt «Grunddaten» hinterlegt."]
[]
[]
[]
["Falls Sie das Spiel bereits einmal durchgeführt haben, müssen Sie hier den Spielstand auf 0 setzen:"]
[]
[]
["Schritt 1: Nach erfolgter Besprechung in den Gruppen überträgt die Lehrperson (oder die Lernenden selbst) für das Jahr 1 die entsprechenden Höchstgebote der jeweiligen Firma für jede der vier Führungspersonen vom «Formular für die Lernenden» in das entsprechende, für jede Firma individuelle, Tabellenblatt (Firma A - Firma E). Starten Sie mit Firma A und bewegen Sie sich mit den grünen Vorwärts-Buttons zur jeweils nächsten Firma."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Schritt 2: Nachdem Sie für alle Firmen die Angebote für das Jahr 1 eingegeben haben, können Sie sich mit dem grünen Vorwärts-Button im Tabellenblatt der Firma E zur Zuweisung der Managerinnen und Manager (Jahr 1) begeben. "]
[]
[]
[]
[null,"a) In der ersten Tabelle «Angebote» werden alle Angebote von Firma A bis Firma E automatisch erfasst. Für alle Managerinnen und Manager, beginnend mit demjenigen, welcher den höchsten Bruttogewinn generiert (Albert Adam), wird das jeweilige Höchstgebot ermittelt. Hat eine Firma eine entsprechende Managerin oder einen entsprechenden Manager erworben, fällt sie für das Bieten um die daraufolgenden (schlechteren) Managerinnen und Manager aus dem Rennen. Dies wird durch das Durchstreichen der Angebote ersichtlich gemacht. Falls keine der Zellen rot markiert wird, können Sie die nächsten drei Punkte (b,c und d) überspringen."]
[]
[]
[]
[]
[]
[null,"b) Falls es mehrere gleichwertige Maximas gibt, werden die entsprechenden Zellen rot markiert. Gemäss Spielregeln muss dann ein Münzwurf ausgeführt werden. Drücken Sie dafür die entsprechenden Münzwürfe an, welche ausgeführt werden müssen. Den gleichbietenden Firmen wird dabei eine Zufallszahl zwischen 0 und 1 zugeteilt. Diejenige Firma mit der höchsten Zufallszahl gewinnt."]
[]
[]
[]
[null,"Beispiel: In dem konkreten Fall rechts müssen Sie beispielsweise zuerst einen Münzwurf für Claudia Custer und danach einen für Dieter Diem durchführen. Falls Sie mehr als einen Münzwurf durchführen müssen, sollten Sie immer mit demjenigen für die Managerin oder den Manager starten, welche(r) den höheren Bruttogewinn generiert (Albert Adam > Bertha Binnig > Claudia Custer > Dieter Diem)."]
[]
[]
[]
[]
[null,"c) In der Tabelle Zufallszahlen werden die bei einem allfälligen Münzwurf zugeteilten Zahlen entsprechend gelb markiert."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"d) Sind alle notwendigen Münzwürfe durchgeführt, wird dies entsprechend angezeigt."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"e) Die Tabellen «Rang» und «Angebote» markieren in grün jeweils das entsprechend höchste Gebot.\n\nf) Die Tabelle «Zuweisung» unten rechts fasst die entsprechend höchstbietenden Firmen und Gebote zusammen.\n\ng) Zur entsprechenden Auswertung gelangen Sie wiederum mit dem Vorwärts-Button."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Schritt 3: Im Tabellenblatt «Auswertung Managerlöhne» wird für alle Managerinnen und Manager das jeweils höchste Gehalt pro Spielrunde fesgehalten."]
[]
[]
[]
[]
["Schritt 4: Im Tabellenblatt «Auswertung Firmen» werden für alle Firmen die entsprechenden Brutto- und Nettogewinne sowie Kapitalrenditen automatisch berechnet und festgehalten. Dieses Tabellenblatt dient somit als Lösungshinweis für die Tabelle auf Seite 2 im «Formular für die Lernenden»."]
[]
[]
[]
[]
[]
["Schritt 5: Widerholen Sie diesen Vorgang (Schritt 1-4), bis vier alle 4 Perioden (Jahre) gespielt sind. Wie in der Spielanleitung vermerkt, veränderen sich die Grunddaten und insbesondere das Kapital während dem Spiel nicht, d.h. der Gewinn wird Ende Jahr jeweils vollständig ausgeschüttet."]
[]
[]
[]
["Schritt 6: Die Ergebnisse über alle Jahre werden im Tabellenblatt «Grafiken» entsprechend grafisch dargestellt. Diese Grafiken können als Grundlage für eine anschliessende Diskussion verwendet werden."]
[]
[]
["Hinweis: Im Tabellenblatt Musterlösung wird die spieltheoretisch optimale Lösung präsentiert (vgl. Aufgabe 2 im Aufgabenset)."]

{"sheet":"Grunddaten","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,0,3,2],[11,0,11,2],[12,1,12,2],[17,1,17,2],[16,1,16,2],[15,1,15,2],[14,1,14,2],[13,1,13,2]]}
["Spieltheorie - Spitzenverdiener"]
["Grunddaten Lernspiel Cheflöhne"]
[]
["Markt für Manager"]
["Manager","Bruttogewinn (% Firmenkapital) ","Jahreslohn"]
["Albert Adam",0.14000000000000001,"zu verhandeln"]
["Bertha Binnig",0.13,"zu verhandeln"]
["Claudia Custer",0.12,"zu verhandeln"]
["Dieter Diem",0.11,"zu verhandeln"]
["Normal",0.1,300000]
[]
["Kapitalisierung der Unternehmen"]
["Firma","Kapitalisierung"]
["Firma A",5000000]
["Firma B",10000000]
["Firma C",30000000]
["Firma D",400000000]
["Firma E",7000000000]

{"sheet":"Firma A","index":2,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Angebote Firma A"]
[]
["Kapitalisierung:",{"$f":"Grunddaten!B14","v":5000000}]
[]
["1. Jahr","Manager","Jahresgehalt",null,"3. Jahr","Manager","Jahresgehalt"]
[null,"Albert Adam",null,null,null,"Albert Adam"]
[null,"Bertha Binnig",null,null,null,"Bertha Binnig"]
[null,"Claudia Custer",null,null,null,"Claudia Custer"]
[null,"Dieter Diem",null,null,null,"Dieter Diem"]
[null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000},null,null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000}]
[]
[" 2. Jahr","Manager","Jahresgehalt",null,"4. Jahr","Manager","Jahresgehalt"]
[null,"Albert Adam",null,null,null,"Albert Adam"]
[null,"Bertha Binnig",null,null,null,"Bertha Binnig"]
[null,"Claudia Custer",null,null,null,"Claudia Custer"]
[null,"Dieter Diem",null,null,null,"Dieter Diem"]
[null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000},null,null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000}]
[]
[]
[]
[null,"Zurück zur Anleitung",null,null,null,"Vorwärts zu Firma B"]

{"sheet":"Firma B","index":3,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Angebote Firma B"]
[]
["Kapitalisierung:",{"$f":"Grunddaten!B15","v":10000000}]
[]
["1. Jahr","Manager","Jahresgehalt",null,"3. Jahr","Manager","Jahresgehalt"]
[null,"Albert Adam",null,null,null,"Albert Adam"]
[null,"Bertha Binnig",null,null,null,"Bertha Binnig"]
[null,"Claudia Custer",null,null,null,"Claudia Custer"]
[null,"Dieter Diem",null,null,null,"Dieter Diem"]
[null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000},null,null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000}]
[]
[" 2. Jahr","Manager","Jahresgehalt",null,"4. Jahr","Manager","Jahresgehalt"]
[null,"Albert Adam",null,null,null,"Albert Adam"]
[null,"Bertha Binnig",null,null,null,"Bertha Binnig"]
[null,"Claudia Custer",null,null,null,"Claudia Custer"]
[null,"Dieter Diem",null,null,null,"Dieter Diem"]
[null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000},null,null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000}]
[]
[]
[]
[null,"Zurück zur Anleitung",null,null,null,"Vorwärts zu Firma C"]

{"sheet":"Firma C","index":4,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Angebote Firma C"]
[]
["Kapitalisierung:",{"$f":"Grunddaten!B16","v":30000000}]
[]
["1. Jahr","Manager","Jahresgehalt",null,"3. Jahr","Manager","Jahresgehalt"]
[null,"Albert Adam",null,null,null,"Albert Adam"]
[null,"Bertha Binnig",null,null,null,"Bertha Binnig"]
[null,"Claudia Custer",null,null,null,"Claudia Custer"]
[null,"Dieter Diem",null,null,null,"Dieter Diem"]
[null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000},null,null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000}]
[]
[" 2. Jahr","Manager","Jahresgehalt",null,"4. Jahr","Manager","Jahresgehalt"]
[null,"Albert Adam",null,null,null,"Albert Adam"]
[null,"Bertha Binnig",null,null,null,"Bertha Binnig"]
[null,"Claudia Custer",null,null,null,"Claudia Custer"]
[null,"Dieter Diem",null,null,null,"Dieter Diem"]
[null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000},null,null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000}]
[]
[]
[]
[null,"Zurück zur Anleitung",null,null,null,"Vorwärts zu Firma D"]

{"sheet":"Firma D","index":5,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Angebote Firma D"]
[]
["Kapitalisierung:",{"$f":"Grunddaten!B17","v":400000000}]
[]
["1. Jahr","Manager","Jahresgehalt",null,"3. Jahr","Manager","Jahresgehalt"]
[null,"Albert Adam",null,null,null,"Albert Adam"]
[null,"Bertha Binnig",null,null,null,"Bertha Binnig"]
[null,"Claudia Custer",null,null,null,"Claudia Custer"]
[null,"Dieter Diem",null,null,null,"Dieter Diem"]
[null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000},null,null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000}]
[]
[" 2. Jahr","Manager","Jahresgehalt",null,"4. Jahr","Manager","Jahresgehalt"]
[null,"Albert Adam",null,null,null,"Albert Adam"]
[null,"Bertha Binnig",null,null,null,"Bertha Binnig"]
[null,"Claudia Custer",null,null,null,"Claudia Custer"]
[null,"Dieter Diem",null,null,null,"Dieter Diem"]
[null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000},null,null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000}]
[]
[]
[]
[null,"Zurück zur Anleitung",null,null,null,"Vorwärts zu Firma E"]

{"sheet":"Firma E","index":6,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Angebote Firma E"]
[]
["Kapitalisierung:",{"$f":"Grunddaten!B18","v":7000000000}]
[]
["1. Jahr","Manager","Jahresgehalt",null,"3. Jahr","Manager","Jahresgehalt"]
[null,"Albert Adam",null,null,null,"Albert Adam"]
[null,"Bertha Binnig",null,null,null,"Bertha Binnig"]
[null,"Claudia Custer",null,null,null,"Claudia Custer"]
[null,"Dieter Diem",null,null,null,"Dieter Diem"]
[null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000},null,null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000}]
[]
[" 2. Jahr","Manager","Jahresgehalt",null,"4. Jahr","Manager","Jahresgehalt"]
[null,"Albert Adam",null,null,null,"Albert Adam"]
[null,"Bertha Binnig",null,null,null,"Bertha Binnig"]
[null,"Claudia Custer",null,null,null,"Claudia Custer"]
[null,"Dieter Diem",null,null,null,"Dieter Diem"]
[null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000},null,null,"Normale Führungsperson",{"$f":"Grunddaten!C10","v":300000}]
[]
[]
[]
[null,"Zurück zur Anleitung",null,null,null,"Vorwärts zur Zuweisung Manager Jahr 1"]
[]
[null,null,null,null,null,"Vorwärts zur Zuweisung Manager Jahr 2"]
[]
[null,null,null,null,null,"Vorwärts zur Zuweisung Manager Jahr 3"]
[]
[null,null,null,null,null,"Vorwärts zur Zuweisung Manager Jahr 4"]

{"sheet":"Jahr 1","index":7,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,7,8,9]]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Zuweisung Manager (1. Jahr)"]
[]
["Angebote im 1. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E",null,"Maximum","# Maxima","Münzwurf "]
["Albert Adam",{"$f":"'Firma A'!C7","v":0},{"$f":"'Firma B'!C7","v":0},{"$f":"'Firma C'!C7","v":0},{"$f":"'Firma D'!C7","v":0},{"$f":"'Firma E'!C7","v":0},null,{"$f":"MAX(B5:F5)","v":0},{"$f":"COUNTIF(B5:F5,H5)","v":5},{"$f":"IF(I5>1,\"JA\",\"NEIN\")","v":"JA"},"NEIN"]
["Bertha Binnig",{"$f":"'Firma A'!C8","v":0},{"$f":"'Firma B'!C8","v":0},{"$f":"'Firma C'!C8","v":0},{"$f":"'Firma D'!C8","v":0},{"$f":"'Firma E'!C8","v":0},null,{"$f":"MAX(IF(B31:F31>1,IF(ISNUMBER(B31:F31)=TRUE,B6:F6)))","v":0},{"$f":"COUNTIFS(B6:F6,H6,B31:F31,\"<>1\",B31:F31,\"<>NA\")","v":0},{"$f":"IF(I6>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Claudia Custer",{"$f":"'Firma A'!C9","v":0},{"$f":"'Firma B'!C9","v":0},{"$f":"'Firma C'!C9","v":0},{"$f":"'Firma D'!C9","v":0},{"$f":"'Firma E'!C9","v":0},null,{"$f":"MAX(IF(B32:F32>1,IF(ISNUMBER(B32:F32)=TRUE,B7:F7)))","v":0},{"$f":"COUNTIFS(B7:F7,H7,B32:F32,\"<>1\",B32:F32,\"<>NA\")","v":0},{"$f":"IF(I7>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Dieter Diem",{"$f":"'Firma A'!C10","v":0},{"$f":"'Firma B'!C10","v":0},{"$f":"'Firma C'!C10","v":0},{"$f":"'Firma D'!C10","v":0},{"$f":"'Firma E'!C10","v":0},null,{"$f":"MAX(IF(B33:F33>1,IF(ISNUMBER(B33:F33)=TRUE,B8:F8)))","v":0},{"$f":"COUNTIFS(B8:F8,H8,B33:F33,\"<>1\",B33:F33,\"<>NA\")","v":0},{"$f":"IF(I8>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Normal",{"$f":"'Firma A'!C11","v":300000},{"$f":"'Firma B'!C11","v":300000},{"$f":"'Firma C'!C11","v":300000},{"$f":"'Firma D'!C11","v":300000},{"$f":"'Firma E'!C11","v":300000},null,{"$f":"IF(K9=0,\"Sie müssen keinen Münzwurf (mehr) ausführen!\",\"Sie müssen mind. noch einen Münzwurf ausführen!\")","v":"Sie müssen mind. noch einen Münzwurf ausführen!"},null,null,{"$f":"IF(OR(J5=\"JA\",J6=\"JA\",J7=\"JA\",J8=\"JA\"),IF(J5=K5,IF(J6=K6,IF(J7=K7,IF(J8=K8,0,1),1),1),1),0)","v":1}]
[]
["Zufallszahlen im 1. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"IF(AND(B5=$H$5,$I$5>1),RAND(),\"\")","v":0.22212063005398264},{"$f":"IF(AND(C5=$H$5,$I$5>1),RAND(),\"\")","v":6.1557098269034549E-2},{"$f":"IF(AND(D5=$H$5,$I$5>1),RAND(),\"\")","v":0.66247509867982546},{"$f":"IF(AND(E5=$H$5,$I$5>1),RAND(),\"\")","v":0.45797084707281988},{"$f":"IF(AND(F5=$H$5,$I$5>1),RAND(),\"\")","v":0.57232556160240278}]
["Bertha Binnig",{"$f":"IF(AND(B6=$H$6,$I$6>1,B31>1,B31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C6=$H$6,$I$6>1,C31>1,C31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D6=$H$6,$I$6>1,D31>1,D31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E6=$H$6,$I$6>1,E31>1,E31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F6=$H$6,$I$6>1,F31>1,F31<>\"na\"),RAND(),\"\")","v":""}]
["Claudia Custer",{"$f":"IF(AND(B7=$H$7,$I$7>1,B32>1,B32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C7=$H$7,$I$7>1,C32>1,C32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D7=$H$7,$I$7>1,D32>1,D32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E7=$H$7,$I$7>1,E32>1,E32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F7=$H$7,$I$7>1,F32>1,F32<>\"na\"),RAND(),\"\")","v":""}]
["Dieter Diem",{"$f":"IF(AND(B8=$H$8,$I$8>1,B33>1,B33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C8=$H$8,$I$8>1,C33>1,C33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D8=$H$8,$I$8>1,D33>1,D33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E8=$H$8,$I$8>1,E33>1,E33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F8=$H$8,$I$8>1,F33>1,F33<>\"na\"),RAND(),\"\")","v":""}]
[]
["Zufallszahlen im 1. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam"]
["Bertha Binnig"]
["Claudia Custer"]
["Dieter Diem"]
[]
["Angebote* im 1. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"IF(AND($I$5>1,B5=$H$5),B5+1*B18,B5)","v":0},{"$f":"IF(AND($I$5>1,C5=$H$5),C5+1*C18,C5)","v":0},{"$f":"IF(AND($I$5>1,D5=$H$5),D5+1*D18,D5)","v":0},{"$f":"IF(AND($I$5>1,E5=$H$5),E5+1*E18,E5)","v":0},{"$f":"IF(AND($I$5>1,F5=$H$5),F5+1*F18,F5)","v":0}]
["Bertha Binnig",{"$f":"IF(AND($I$6>1,B6=$H$6),B6+1*B19,B6)","v":0},{"$f":"IF(AND($I$6>1,C6=$H$6),C6+1*C19,C6)","v":0},{"$f":"IF(AND($I$6>1,D6=$H$6),D6+1*D19,D6)","v":0},{"$f":"IF(AND($I$6>1,E6=$H$6),E6+1*E19,E6)","v":0},{"$f":"IF(AND($I$6>1,F6=$H$6),F6+1*F19,F6)","v":0}]
["Claudia Custer",{"$f":"IF(AND($I$7>1,B7=$H$7),B7+1*B20,B7)","v":0},{"$f":"IF(AND($I$7>1,C7=$H$7),C7+1*C20,C7)","v":0},{"$f":"IF(AND($I$7>1,D7=$H$7),D7+1*D20,D7)","v":0},{"$f":"IF(AND($I$7>1,E7=$H$7),E7+1*E20,E7)","v":0},{"$f":"IF(AND($I$7>1,F7=$H$7),F7+1*F20,F7)","v":0}]
["Dieter Diem",{"$f":"IF(AND($I$8>1,B8=$H$8),B8+1*B21,B8)","v":0},{"$f":"IF(AND($I$8>1,C8=$H$8),C8+1*C21,C8)","v":0},{"$f":"IF(AND($I$8>1,D8=$H$8),D8+1*D21,D8)","v":0},{"$f":"IF(AND($I$8>1,E8=$H$8),E8+1*E21,E8)","v":0},{"$f":"IF(AND($I$8>1,F8=$H$8),F8+1*F21,F8)","v":0}]
["Normal",{"$f":"B9","v":300000},{"$f":"C9","v":300000},{"$f":"D9","v":300000},{"$f":"E9","v":300000},{"$f":"F9","v":300000}]
[]
["Rang im 1. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"RANK(B24,$B$24:$F$24)","v":1},{"$f":"RANK(C24,$B$24:$F$24)","v":1},{"$f":"RANK(D24,$B$24:$F$24)","v":1},{"$f":"RANK(E24,$B$24:$F$24)","v":1},{"$f":"RANK(F24,$B$24:$F$24)","v":1}]
["Bertha Binnig",{"$f":"IF(AND(B$31>1,B$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&B25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$31>1,C$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&C25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$31>1,D$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&D25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$31>1,E$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&E25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$31>1,F$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&F25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"}]
["Claudia Custer",{"$f":"IF(AND(B$32>1,B$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&B26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$32>1,C$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&C26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$32>1,D$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&D26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$32>1,E$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&E26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$32>1,F$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&F26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"}]
["Dieter Diem",{"$f":"IF(AND(B$33>1,B$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&B27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$33>1,C$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&C27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$33>1,D$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&D27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$33>1,E$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&E27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$33>1,F$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&F27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"}]
["Normal",{"$f":"IF(AND(B$34>1,B$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&B28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$34>1,C$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&C28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$34>1,D$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&D28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$34>1,E$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&E28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$34>1,F$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&F28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"}]
[]
["Angebote im 1. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E",null,"Zuweisung","Firma","Jahresgehalt"]
["Albert Adam",{"$f":"B5","v":0},0,0,0,0,null,"Albert Adam",{"$f":"INDEX($B$30:$F$30,MATCH(1,B31:F31,0))","v":"Firma A"},{"$f":"INDEX(B5:F5,MATCH(I38,$B$4:$F$4,0))","v":0},null,null,"Zurück zur Anleitung"]
["Bertha Binnig",0,0,0,0,0,null,"Bertha Binnig",{"$f":"INDEX($B$30:$F$30,MATCH(1,B32:F32,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B6:F6,MATCH(I39,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Claudia Custer",0,0,0,0,0,null,"Claudia Custer",{"$f":"INDEX($B$30:$F$30,MATCH(1,B33:F33,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B7:F7,MATCH(I40,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Dieter Diem",0,0,0,0,0,null,"Dieter Diem",{"$f":"INDEX($B$30:$F$30,MATCH(1,B34:F34,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B8:F8,MATCH(I41,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Normal",300000,300000,300000,300000,300000,null,"Normal",{"$f":"INDEX($B$30:$F$30,MATCH(1,B35:F35,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B9:F9,MATCH(I42,$B$4:$F$4,0))","v":{"$error":"#N/A"}},null,null,"Vorwärts zur Auswertung Managerlöhne"]

{"sheet":"Jahr 2","index":8,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,7,8,9]]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Zuweisung Manager (2. Jahr)"]
[]
["Angebote im 2. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E",null,"Maximum","# Maxima","Münzwurf"]
["Albert Adam",{"$f":"'Firma A'!C14","v":0},{"$f":"'Firma B'!C14","v":0},{"$f":"'Firma C'!C14","v":0},{"$f":"'Firma D'!C14","v":0},{"$f":"'Firma E'!C14","v":0},null,{"$f":"MAX(B5:F5)","v":0},{"$f":"COUNTIF(B5:F5,H5)","v":5},{"$f":"IF(I5>1,\"JA\",\"NEIN\")","v":"JA"},"NEIN"]
["Bertha Binnig",{"$f":"'Firma A'!C15","v":0},{"$f":"'Firma B'!C15","v":0},{"$f":"'Firma C'!C15","v":0},{"$f":"'Firma D'!C15","v":0},{"$f":"'Firma E'!C15","v":0},null,{"$f":"MAX(IF(B31:F31>1,IF(ISNUMBER(B31:F31)=TRUE,B6:F6)))","v":0},{"$f":"COUNTIFS(B6:F6,H6,B31:F31,\"<>1\",B31:F31,\"<>NA\")","v":0},{"$f":"IF(I6>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Claudia Custer",{"$f":"'Firma A'!C16","v":0},{"$f":"'Firma B'!C16","v":0},{"$f":"'Firma C'!C16","v":0},{"$f":"'Firma D'!C16","v":0},{"$f":"'Firma E'!C16","v":0},null,{"$f":"MAX(IF(B32:F32>1,IF(ISNUMBER(B32:F32)=TRUE,B7:F7)))","v":0},{"$f":"COUNTIFS(B7:F7,H7,B32:F32,\"<>1\",B32:F32,\"<>NA\")","v":0},{"$f":"IF(I7>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Dieter Diem",{"$f":"'Firma A'!C17","v":0},{"$f":"'Firma B'!C17","v":0},{"$f":"'Firma C'!C17","v":0},{"$f":"'Firma D'!C17","v":0},{"$f":"'Firma E'!C17","v":0},null,{"$f":"MAX(IF(B33:F33>1,IF(ISNUMBER(B33:F33)=TRUE,B8:F8)))","v":0},{"$f":"COUNTIFS(B8:F8,H8,B33:F33,\"<>1\",B33:F33,\"<>NA\")","v":0},{"$f":"IF(I8>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Normal",{"$f":"'Firma A'!C18","v":300000},{"$f":"'Firma B'!C18","v":300000},{"$f":"'Firma C'!C18","v":300000},{"$f":"'Firma D'!C18","v":300000},{"$f":"'Firma E'!C18","v":300000},null,{"$f":"IF(K9=0,\"Sie müssen keinen Münzwurf mehr ausführen!\",\"Sie müssen mind. noch einen Münzwurf ausführen!\")","v":"Sie müssen mind. noch einen Münzwurf ausführen!"},null,null,{"$f":"IF(OR(J5=\"JA\",J6=\"JA\",J7=\"JA\",J8=\"JA\"),IF(J5=K5,IF(J6=K6,IF(J7=K7,IF(J8=K8,0,1),1),1),1),0)","v":1}]
[]
["Zufallszahlen im 2. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"IF(AND(B5=$H$5,$I$5>1),RAND(),\"\")","v":0.27136316249656944},{"$f":"IF(AND(C5=$H$5,$I$5>1),RAND(),\"\")","v":0.68388568364877655},{"$f":"IF(AND(D5=$H$5,$I$5>1),RAND(),\"\")","v":4.653963177055187E-2},{"$f":"IF(AND(E5=$H$5,$I$5>1),RAND(),\"\")","v":0.37993570772966323},{"$f":"IF(AND(F5=$H$5,$I$5>1),RAND(),\"\")","v":0.92590376463260027}]
["Bertha Binnig",{"$f":"IF(AND(B6=$H$6,$I$6>1,B31>1,B31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C6=$H$6,$I$6>1,C31>1,C31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D6=$H$6,$I$6>1,D31>1,D31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E6=$H$6,$I$6>1,E31>1,E31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F6=$H$6,$I$6>1,F31>1,F31<>\"na\"),RAND(),\"\")","v":""}]
["Claudia Custer",{"$f":"IF(AND(B7=$H$7,$I$7>1,B32>1,B32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C7=$H$7,$I$7>1,C32>1,C32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D7=$H$7,$I$7>1,D32>1,D32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E7=$H$7,$I$7>1,E32>1,E32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F7=$H$7,$I$7>1,F32>1,F32<>\"na\"),RAND(),\"\")","v":""}]
["Dieter Diem",{"$f":"IF(AND(B8=$H$8,$I$8>1,B33>1,B33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C8=$H$8,$I$8>1,C33>1,C33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D8=$H$8,$I$8>1,D33>1,D33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E8=$H$8,$I$8>1,E33>1,E33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F8=$H$8,$I$8>1,F33>1,F33<>\"na\"),RAND(),\"\")","v":""}]
[]
["Zufallszahlen im 2. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam"]
["Bertha Binnig"]
["Claudia Custer"]
["Dieter Diem"]
[]
["Angebote* im 2. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"IF(AND($I$5>1,B5=$H$5),B5+1*B18,B5)","v":0},{"$f":"IF(AND($I$5>1,C5=$H$5),C5+1*C18,C5)","v":0},{"$f":"IF(AND($I$5>1,D5=$H$5),D5+1*D18,D5)","v":0},{"$f":"IF(AND($I$5>1,E5=$H$5),E5+1*E18,E5)","v":0},{"$f":"IF(AND($I$5>1,F5=$H$5),F5+1*F18,F5)","v":0}]
["Bertha Binnig",{"$f":"IF(AND($I$6>1,B6=$H$6),B6+1*B19,B6)","v":0},{"$f":"IF(AND($I$6>1,C6=$H$6),C6+1*C19,C6)","v":0},{"$f":"IF(AND($I$6>1,D6=$H$6),D6+1*D19,D6)","v":0},{"$f":"IF(AND($I$6>1,E6=$H$6),E6+1*E19,E6)","v":0},{"$f":"IF(AND($I$6>1,F6=$H$6),F6+1*F19,F6)","v":0}]
["Claudia Custer",{"$f":"IF(AND($I$7>1,B7=$H$7),B7+1*B20,B7)","v":0},{"$f":"IF(AND($I$7>1,C7=$H$7),C7+1*C20,C7)","v":0},{"$f":"IF(AND($I$7>1,D7=$H$7),D7+1*D20,D7)","v":0},{"$f":"IF(AND($I$7>1,E7=$H$7),E7+1*E20,E7)","v":0},{"$f":"IF(AND($I$7>1,F7=$H$7),F7+1*F20,F7)","v":0}]
["Dieter Diem",{"$f":"IF(AND($I$8>1,B8=$H$8),B8+1*B21,B8)","v":0},{"$f":"IF(AND($I$8>1,C8=$H$8),C8+1*C21,C8)","v":0},{"$f":"IF(AND($I$8>1,D8=$H$8),D8+1*D21,D8)","v":0},{"$f":"IF(AND($I$8>1,E8=$H$8),E8+1*E21,E8)","v":0},{"$f":"IF(AND($I$8>1,F8=$H$8),F8+1*F21,F8)","v":0}]
["Normal",{"$f":"B9","v":300000},{"$f":"C9","v":300000},{"$f":"D9","v":300000},{"$f":"E9","v":300000},{"$f":"F9","v":300000}]
[]
["Rang im 2. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"RANK(B24,$B$24:$F$24)","v":1},{"$f":"RANK(C24,$B$24:$F$24)","v":1},{"$f":"RANK(D24,$B$24:$F$24)","v":1},{"$f":"RANK(E24,$B$24:$F$24)","v":1},{"$f":"RANK(F24,$B$24:$F$24)","v":1}]
["Bertha Binnig",{"$f":"IF(AND(B$31>1,B$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&B25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$31>1,C$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&C25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$31>1,D$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&D25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$31>1,E$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&E25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$31>1,F$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&F25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"}]
["Claudia Custer",{"$f":"IF(AND(B$32>1,B$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&B26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$32>1,C$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&C26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$32>1,D$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&D26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$32>1,E$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&E26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$32>1,F$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&F26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"}]
["Dieter Diem",{"$f":"IF(AND(B$33>1,B$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&B27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$33>1,C$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&C27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$33>1,D$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&D27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$33>1,E$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&E27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$33>1,F$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&F27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"}]
["Normal",{"$f":"IF(AND(B$34>1,B$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&B28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$34>1,C$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&C28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$34>1,D$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&D28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$34>1,E$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&E28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$34>1,F$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&F28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"}]
[]
["Angebote im 2. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E",null,"Zuweisung","Firma","Jahresgehalt"]
["Albert Adam",{"$f":"B5","v":0},0,0,0,0,null,"Albert Adam",{"$f":"INDEX($B$30:$F$30,MATCH(1,B31:F31,0))","v":"Firma A"},{"$f":"INDEX(B5:F5,MATCH(I38,$B$4:$F$4,0))","v":0},null,null,"Zurück zur Anleitung"]
["Bertha Binnig",0,0,0,0,0,null,"Bertha Binnig",{"$f":"INDEX($B$30:$F$30,MATCH(1,B32:F32,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B6:F6,MATCH(I39,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Claudia Custer",0,0,0,0,0,null,"Claudia Custer",{"$f":"INDEX($B$30:$F$30,MATCH(1,B33:F33,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B7:F7,MATCH(I40,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Dieter Diem",{"$f":"B8","v":0},0,0,0,0,null,"Dieter Diem",{"$f":"INDEX($B$30:$F$30,MATCH(1,B34:F34,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B8:F8,MATCH(I41,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Normal",{"$f":"B9","v":300000},{"$f":"C9","v":300000},{"$f":"D9","v":300000},{"$f":"E9","v":300000},{"$f":"F9","v":300000},null,"Normal",{"$f":"INDEX($B$30:$F$30,MATCH(1,B35:F35,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B9:F9,MATCH(I42,$B$4:$F$4,0))","v":{"$error":"#N/A"}},null,null,"Vorwärts zur Auswertung Managerlöhne"]

{"sheet":"Jahr 3","index":9,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,7,8,9]]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Zuweisung Manager (3. Jahr)"]
[]
["Angebote im 3. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E",null,"Maximum","# Maxima","Münzwurf"]
["Albert Adam",{"$f":"'Firma A'!G7","v":0},{"$f":"'Firma B'!G7","v":0},{"$f":"'Firma C'!G7","v":0},{"$f":"'Firma D'!G7","v":0},{"$f":"'Firma E'!G7","v":0},null,{"$f":"MAX(B5:F5)","v":0},{"$f":"COUNTIF(B5:F5,H5)","v":5},{"$f":"IF(I5>1,\"JA\",\"NEIN\")","v":"JA"},"NEIN"]
["Bertha Binnig",{"$f":"'Firma A'!G8","v":0},{"$f":"'Firma B'!G8","v":0},{"$f":"'Firma C'!G8","v":0},{"$f":"'Firma D'!G8","v":0},{"$f":"'Firma E'!G8","v":0},null,{"$f":"MAX(IF(B31:F31>1,IF(ISNUMBER(B31:F31)=TRUE,B6:F6)))","v":0},{"$f":"COUNTIFS(B6:F6,H6,B31:F31,\"<>1\",B31:F31,\"<>NA\")","v":0},{"$f":"IF(I6>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Claudia Custer",{"$f":"'Firma A'!G9","v":0},{"$f":"'Firma B'!G9","v":0},{"$f":"'Firma C'!G9","v":0},{"$f":"'Firma D'!G9","v":0},{"$f":"'Firma E'!G9","v":0},null,{"$f":"MAX(IF(B32:F32>1,IF(ISNUMBER(B32:F32)=TRUE,B7:F7)))","v":0},{"$f":"COUNTIFS(B7:F7,H7,B32:F32,\"<>1\",B32:F32,\"<>NA\")","v":0},{"$f":"IF(I7>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Dieter Diem",{"$f":"'Firma A'!G10","v":0},{"$f":"'Firma B'!G10","v":0},{"$f":"'Firma C'!G10","v":0},{"$f":"'Firma D'!G10","v":0},{"$f":"'Firma E'!G10","v":0},null,{"$f":"MAX(IF(B33:F33>1,IF(ISNUMBER(B33:F33)=TRUE,B8:F8)))","v":0},{"$f":"COUNTIFS(B8:F8,H8,B33:F33,\"<>1\",B33:F33,\"<>NA\")","v":0},{"$f":"IF(I8>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Normal",{"$f":"'Firma A'!G11","v":300000},{"$f":"'Firma B'!G11","v":300000},{"$f":"'Firma C'!G11","v":300000},{"$f":"'Firma D'!G11","v":300000},{"$f":"'Firma E'!G11","v":300000},null,{"$f":"IF(K9=0,\"Sie müssen keinen Münzwurf mehr ausführen!\",\"Sie müssen mind. noch einen Münzwurf ausführen!\")","v":"Sie müssen mind. noch einen Münzwurf ausführen!"},null,null,{"$f":"IF(OR(J5=\"JA\",J6=\"JA\",J7=\"JA\",J8=\"JA\"),IF(J5=K5,IF(J6=K6,IF(J7=K7,IF(J8=K8,0,1),1),1),1),0)","v":1}]
[]
["Zufallszahlen im 3. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"IF(AND(B5=$H$5,$I$5>1),RAND(),\"\")","v":0.44289693758483772},{"$f":"IF(AND(C5=$H$5,$I$5>1),RAND(),\"\")","v":0.46024808283508312},{"$f":"IF(AND(D5=$H$5,$I$5>1),RAND(),\"\")","v":0.62010403692189675},{"$f":"IF(AND(E5=$H$5,$I$5>1),RAND(),\"\")","v":0.25652887254284551},{"$f":"IF(AND(F5=$H$5,$I$5>1),RAND(),\"\")","v":0.659435419119071}]
["Bertha Binnig",{"$f":"IF(AND(B6=$H$6,$I$6>1,B31>1,B31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C6=$H$6,$I$6>1,C31>1,C31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D6=$H$6,$I$6>1,D31>1,D31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E6=$H$6,$I$6>1,E31>1,E31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F6=$H$6,$I$6>1,F31>1,F31<>\"na\"),RAND(),\"\")","v":""}]
["Claudia Custer",{"$f":"IF(AND(B7=$H$7,$I$7>1,B32>1,B32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C7=$H$7,$I$7>1,C32>1,C32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D7=$H$7,$I$7>1,D32>1,D32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E7=$H$7,$I$7>1,E32>1,E32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F7=$H$7,$I$7>1,F32>1,F32<>\"na\"),RAND(),\"\")","v":""}]
["Dieter Diem",{"$f":"IF(AND(B8=$H$8,$I$8>1,B33>1,B33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C8=$H$8,$I$8>1,C33>1,C33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D8=$H$8,$I$8>1,D33>1,D33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E8=$H$8,$I$8>1,E33>1,E33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F8=$H$8,$I$8>1,F33>1,F33<>\"na\"),RAND(),\"\")","v":""}]
[]
["Zufallszahlen im 3. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam"]
["Bertha Binnig"]
["Claudia Custer"]
["Dieter Diem"]
[]
["Angebote* im 3. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"IF(AND($I$5>1,B5=$H$5),B5+1*B18,B5)","v":0},{"$f":"IF(AND($I$5>1,C5=$H$5),C5+1*C18,C5)","v":0},{"$f":"IF(AND($I$5>1,D5=$H$5),D5+1*D18,D5)","v":0},{"$f":"IF(AND($I$5>1,E5=$H$5),E5+1*E18,E5)","v":0},{"$f":"IF(AND($I$5>1,F5=$H$5),F5+1*F18,F5)","v":0}]
["Bertha Binnig",{"$f":"IF(AND($I$6>1,B6=$H$6),B6+1*B19,B6)","v":0},{"$f":"IF(AND($I$6>1,C6=$H$6),C6+1*C19,C6)","v":0},{"$f":"IF(AND($I$6>1,D6=$H$6),D6+1*D19,D6)","v":0},{"$f":"IF(AND($I$6>1,E6=$H$6),E6+1*E19,E6)","v":0},{"$f":"IF(AND($I$6>1,F6=$H$6),F6+1*F19,F6)","v":0}]
["Claudia Custer",{"$f":"IF(AND($I$7>1,B7=$H$7),B7+1*B20,B7)","v":0},{"$f":"IF(AND($I$7>1,C7=$H$7),C7+1*C20,C7)","v":0},{"$f":"IF(AND($I$7>1,D7=$H$7),D7+1*D20,D7)","v":0},{"$f":"IF(AND($I$7>1,E7=$H$7),E7+1*E20,E7)","v":0},{"$f":"IF(AND($I$7>1,F7=$H$7),F7+1*F20,F7)","v":0}]
["Dieter Diem",{"$f":"IF(AND($I$8>1,B8=$H$8),B8+1*B21,B8)","v":0},{"$f":"IF(AND($I$8>1,C8=$H$8),C8+1*C21,C8)","v":0},{"$f":"IF(AND($I$8>1,D8=$H$8),D8+1*D21,D8)","v":0},{"$f":"IF(AND($I$8>1,E8=$H$8),E8+1*E21,E8)","v":0},{"$f":"IF(AND($I$8>1,F8=$H$8),F8+1*F21,F8)","v":0}]
["Normal",{"$f":"B9","v":300000},{"$f":"C9","v":300000},{"$f":"D9","v":300000},{"$f":"E9","v":300000},{"$f":"F9","v":300000}]
[]
["Rang im 3. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"RANK(B24,$B$24:$F$24)","v":1},{"$f":"RANK(C24,$B$24:$F$24)","v":1},{"$f":"RANK(D24,$B$24:$F$24)","v":1},{"$f":"RANK(E24,$B$24:$F$24)","v":1},{"$f":"RANK(F24,$B$24:$F$24)","v":1}]
["Bertha Binnig",{"$f":"IF(AND(B$31>1,B$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&B25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$31>1,C$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&C25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$31>1,D$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&D25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$31>1,E$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&E25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$31>1,F$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&F25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"}]
["Claudia Custer",{"$f":"IF(AND(B$32>1,B$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&B26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$32>1,C$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&C26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$32>1,D$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&D26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$32>1,E$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&E26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$32>1,F$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&F26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"}]
["Dieter Diem",{"$f":"IF(AND(B$33>1,B$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&B27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$33>1,C$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&C27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$33>1,D$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&D27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$33>1,E$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&E27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$33>1,F$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&F27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"}]
["Normal",{"$f":"IF(AND(B$34>1,B$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&B28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$34>1,C$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&C28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$34>1,D$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&D28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$34>1,E$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&E28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$34>1,F$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&F28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"}]
[]
["Angebote im 3. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E",null,"Zuweisung","Firma","Jahresgehalt"]
["Albert Adam",{"$f":"B5","v":0},0,0,0,0,null,"Albert Adam",{"$f":"INDEX($B$30:$F$30,MATCH(1,B31:F31,0))","v":"Firma A"},{"$f":"INDEX(B5:F5,MATCH(I38,$B$4:$F$4,0))","v":0},null,null,"Zurück zur Anleitung"]
["Bertha Binnig",0,0,0,0,0,null,"Bertha Binnig",{"$f":"INDEX($B$30:$F$30,MATCH(1,B32:F32,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B6:F6,MATCH(I39,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Claudia Custer",0,0,0,0,0,null,"Claudia Custer",{"$f":"INDEX($B$30:$F$30,MATCH(1,B33:F33,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B7:F7,MATCH(I40,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Dieter Diem",{"$f":"B8","v":0},0,0,0,0,null,"Dieter Diem",{"$f":"INDEX($B$30:$F$30,MATCH(1,B34:F34,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B8:F8,MATCH(I41,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Normal",{"$f":"B9","v":300000},{"$f":"C9","v":300000},{"$f":"D9","v":300000},{"$f":"E9","v":300000},{"$f":"F9","v":300000},null,"Normal",{"$f":"INDEX($B$30:$F$30,MATCH(1,B35:F35,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B9:F9,MATCH(I42,$B$4:$F$4,0))","v":{"$error":"#N/A"}},null,null,"Vorwärts zur Auswertung Managerlöhne"]

{"sheet":"Jahr 4","index":10,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,7,8,9]]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Zuweisung Manager (4. Jahr)"]
[]
["Angebote im 4. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E",null,"Maximum","# Maxima","Münzwurf"]
["Albert Adam",{"$f":"'Firma A'!G14","v":0},{"$f":"'Firma B'!G14","v":0},{"$f":"'Firma C'!G14","v":0},{"$f":"'Firma D'!G14","v":0},{"$f":"'Firma E'!G14","v":0},null,{"$f":"MAX(B5:F5)","v":0},{"$f":"COUNTIF(B5:F5,H5)","v":5},{"$f":"IF(I5>1,\"JA\",\"NEIN\")","v":"JA"},"NEIN"]
["Bertha Binnig",{"$f":"'Firma A'!G15","v":0},{"$f":"'Firma B'!G15","v":0},{"$f":"'Firma C'!G15","v":0},{"$f":"'Firma D'!G15","v":0},{"$f":"'Firma E'!G15","v":0},null,{"$f":"MAX(IF(B31:F31>1,IF(ISNUMBER(B31:F31)=TRUE,B6:F6)))","v":0},{"$f":"COUNTIFS(B6:F6,H6,B31:F31,\"<>1\",B31:F31,\"<>NA\")","v":0},{"$f":"IF(I6>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Claudia Custer",{"$f":"'Firma A'!G16","v":0},{"$f":"'Firma B'!G16","v":0},{"$f":"'Firma C'!G16","v":0},{"$f":"'Firma D'!G16","v":0},{"$f":"'Firma E'!G16","v":0},null,{"$f":"MAX(IF(B32:F32>1,IF(ISNUMBER(B32:F32)=TRUE,B7:F7)))","v":0},{"$f":"COUNTIFS(B7:F7,H7,B32:F32,\"<>1\",B32:F32,\"<>NA\")","v":0},{"$f":"IF(I7>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Dieter Diem",{"$f":"'Firma A'!G17","v":0},{"$f":"'Firma B'!G17","v":0},{"$f":"'Firma C'!G17","v":0},{"$f":"'Firma D'!G17","v":0},{"$f":"'Firma E'!G17","v":0},null,{"$f":"MAX(IF(B33:F33>1,IF(ISNUMBER(B33:F33)=TRUE,B8:F8)))","v":0},{"$f":"COUNTIFS(B8:F8,H8,B33:F33,\"<>1\",B33:F33,\"<>NA\")","v":0},{"$f":"IF(I8>1,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
["Normal",{"$f":"'Firma A'!G18","v":300000},{"$f":"'Firma B'!G18","v":300000},{"$f":"'Firma C'!G18","v":300000},{"$f":"'Firma D'!G18","v":300000},{"$f":"'Firma E'!G18","v":300000},null,{"$f":"IF(K9=0,\"Sie müssen keinen Münzwurf mehr ausführen!\",\"Sie müssen mind. noch einen Münzwurf ausführen!\")","v":"Sie müssen mind. noch einen Münzwurf ausführen!"},null,null,{"$f":"IF(OR(J5=\"JA\",J6=\"JA\",J7=\"JA\",J8=\"JA\"),IF(J5=K5,IF(J6=K6,IF(J7=K7,IF(J8=K8,0,1),1),1),1),0)","v":1}]
[]
["Zufallszahlen im 4. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"IF(AND(B5=$H$5,$I$5>1),RAND(),\"\")","v":0.75054467111909695},{"$f":"IF(AND(C5=$H$5,$I$5>1),RAND(),\"\")","v":0.48994444135447124},{"$f":"IF(AND(D5=$H$5,$I$5>1),RAND(),\"\")","v":0.4017489279842823},{"$f":"IF(AND(E5=$H$5,$I$5>1),RAND(),\"\")","v":7.9089115787908559E-2},{"$f":"IF(AND(F5=$H$5,$I$5>1),RAND(),\"\")","v":0.56163106815580921}]
["Bertha Binnig",{"$f":"IF(AND(B6=$H$6,$I$6>1,B31>1,B31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C6=$H$6,$I$6>1,C31>1,C31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D6=$H$6,$I$6>1,D31>1,D31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E6=$H$6,$I$6>1,E31>1,E31<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F6=$H$6,$I$6>1,F31>1,F31<>\"na\"),RAND(),\"\")","v":""}]
["Claudia Custer",{"$f":"IF(AND(B7=$H$7,$I$7>1,B32>1,B32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C7=$H$7,$I$7>1,C32>1,C32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D7=$H$7,$I$7>1,D32>1,D32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E7=$H$7,$I$7>1,E32>1,E32<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F7=$H$7,$I$7>1,F32>1,F32<>\"na\"),RAND(),\"\")","v":""}]
["Dieter Diem",{"$f":"IF(AND(B8=$H$8,$I$8>1,B33>1,B33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(C8=$H$8,$I$8>1,C33>1,C33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(D8=$H$8,$I$8>1,D33>1,D33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(E8=$H$8,$I$8>1,E33>1,E33<>\"na\"),RAND(),\"\")","v":""},{"$f":"IF(AND(F8=$H$8,$I$8>1,F33>1,F33<>\"na\"),RAND(),\"\")","v":""}]
[]
["Zufallszahlen im 4. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam"]
["Bertha Binnig"]
["Claudia Custer"]
["Dieter Diem"]
[]
["Angebote* im 4. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"IF(AND($I$5>1,B5=$H$5),B5+1*B18,B5)","v":0},{"$f":"IF(AND($I$5>1,C5=$H$5),C5+1*C18,C5)","v":0},{"$f":"IF(AND($I$5>1,D5=$H$5),D5+1*D18,D5)","v":0},{"$f":"IF(AND($I$5>1,E5=$H$5),E5+1*E18,E5)","v":0},{"$f":"IF(AND($I$5>1,F5=$H$5),F5+1*F18,F5)","v":0}]
["Bertha Binnig",{"$f":"IF(AND($I$6>1,B6=$H$6),B6+1*B19,B6)","v":0},{"$f":"IF(AND($I$6>1,C6=$H$6),C6+1*C19,C6)","v":0},{"$f":"IF(AND($I$6>1,D6=$H$6),D6+1*D19,D6)","v":0},{"$f":"IF(AND($I$6>1,E6=$H$6),E6+1*E19,E6)","v":0},{"$f":"IF(AND($I$6>1,F6=$H$6),F6+1*F19,F6)","v":0}]
["Claudia Custer",{"$f":"IF(AND($I$7>1,B7=$H$7),B7+1*B20,B7)","v":0},{"$f":"IF(AND($I$7>1,C7=$H$7),C7+1*C20,C7)","v":0},{"$f":"IF(AND($I$7>1,D7=$H$7),D7+1*D20,D7)","v":0},{"$f":"IF(AND($I$7>1,E7=$H$7),E7+1*E20,E7)","v":0},{"$f":"IF(AND($I$7>1,F7=$H$7),F7+1*F20,F7)","v":0}]
["Dieter Diem",{"$f":"IF(AND($I$8>1,B8=$H$8),B8+1*B21,B8)","v":0},{"$f":"IF(AND($I$8>1,C8=$H$8),C8+1*C21,C8)","v":0},{"$f":"IF(AND($I$8>1,D8=$H$8),D8+1*D21,D8)","v":0},{"$f":"IF(AND($I$8>1,E8=$H$8),E8+1*E21,E8)","v":0},{"$f":"IF(AND($I$8>1,F8=$H$8),F8+1*F21,F8)","v":0}]
["Normal",{"$f":"B9","v":300000},{"$f":"C9","v":300000},{"$f":"D9","v":300000},{"$f":"E9","v":300000},{"$f":"F9","v":300000}]
[]
["Rang im 4. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E"]
["Albert Adam",{"$f":"RANK(B24,$B$24:$F$24)","v":1},{"$f":"RANK(C24,$B$24:$F$24)","v":1},{"$f":"RANK(D24,$B$24:$F$24)","v":1},{"$f":"RANK(E24,$B$24:$F$24)","v":1},{"$f":"RANK(F24,$B$24:$F$24)","v":1}]
["Bertha Binnig",{"$f":"IF(AND(B$31>1,B$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&B25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$31>1,C$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&C25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$31>1,D$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&D25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$31>1,E$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&E25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$31>1,F$31<>\"NA\"),COUNTIFS($B$25:$F$25,\">\"&F25,$B$31:$F$31,\">\"&1)+1,\"NA\")","v":"NA"}]
["Claudia Custer",{"$f":"IF(AND(B$32>1,B$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&B26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$32>1,C$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&C26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$32>1,D$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&D26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$32>1,E$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&E26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$32>1,F$32<>\"NA\"),COUNTIFS($B$26:$F$26,\">\"&F26,$B$32:$F$32,\">\"&1)+1,\"NA\")","v":"NA"}]
["Dieter Diem",{"$f":"IF(AND(B$33>1,B$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&B27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$33>1,C$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&C27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$33>1,D$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&D27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$33>1,E$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&E27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$33>1,F$33<>\"NA\"),COUNTIFS($B$27:$F$27,\">\"&F27,$B$33:$F$33,\">\"&1)+1,\"NA\")","v":"NA"}]
["Normal",{"$f":"IF(AND(B$34>1,B$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&B28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(C$34>1,C$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&C28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(D$34>1,D$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&D28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(E$34>1,E$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&E28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"},{"$f":"IF(AND(F$34>1,F$34<>\"NA\"),COUNTIFS($B$28:$F$28,\">\"&F28,$B$34:$F$34,\">\"&1)+1,\"NA\")","v":"NA"}]
[]
["Angebote im 4. Jahr","Firma A","Firma B","Firma C","Firma D","Firma E",null,"Zuweisung","Firma","Jahresgehalt"]
["Albert Adam",{"$f":"B5","v":0},0,0,0,0,null,"Albert Adam",{"$f":"INDEX($B$30:$F$30,MATCH(1,B31:F31,0))","v":"Firma A"},{"$f":"INDEX(B5:F5,MATCH(I38,$B$4:$F$4,0))","v":0},null,null,"Zurück zur Anleitung"]
["Bertha Binnig",0,0,0,0,0,null,"Bertha Binnig",{"$f":"INDEX($B$30:$F$30,MATCH(1,B32:F32,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B6:F6,MATCH(I39,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Claudia Custer",0,0,0,0,0,null,"Claudia Custer",{"$f":"INDEX($B$30:$F$30,MATCH(1,B33:F33,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B7:F7,MATCH(I40,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Dieter Diem",{"$f":"B8","v":0},0,0,0,0,null,"Dieter Diem",{"$f":"INDEX($B$30:$F$30,MATCH(1,B34:F34,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B8:F8,MATCH(I41,$B$4:$F$4,0))","v":{"$error":"#N/A"}}]
["Normal",{"$f":"B9","v":300000},{"$f":"C9","v":300000},{"$f":"D9","v":300000},{"$f":"E9","v":300000},{"$f":"F9","v":300000},null,"Normal",{"$f":"INDEX($B$30:$F$30,MATCH(1,B35:F35,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(B9:F9,MATCH(I42,$B$4:$F$4,0))","v":{"$error":"#N/A"}},null,null,"Vorwärts zur Auswertung Managerlöhne"]

{"sheet":"Auswertung Managerlöhne","index":11,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Auswertung Jahreslohn Manager"]
[]
["CEO","1. Jahr","2. Jahr","3. Jahr","4. Jahr"]
["Albert Adam",{"$f":"INDEX('Jahr 1'!$J$38:$J$42,MATCH(A5,'Jahr 1'!$H$38:$H$42,0))","v":0},{"$f":"INDEX('Jahr 2'!$J$38:$J$42,MATCH(A5,'Jahr 2'!$H$38:$H$42,0))","v":0},{"$f":"INDEX('Jahr 3'!$J$38:$J$42,MATCH(A5,'Jahr 3'!$H$38:$H$42,0))","v":0},{"$f":"INDEX('Jahr 4'!$J$38:$J$42,MATCH(A5,'Jahr 4'!$H$38:$H$42,0))","v":0}]
["Bertha Binnig",{"$f":"INDEX('Jahr 1'!$J$38:$J$42,MATCH(A6,'Jahr 1'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 2'!$J$38:$J$42,MATCH(A6,'Jahr 2'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 3'!$J$38:$J$42,MATCH(A6,'Jahr 3'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 4'!$J$38:$J$42,MATCH(A6,'Jahr 4'!$H$38:$H$42,0))","v":{"$error":"#N/A"}}]
["Claudia Custer",{"$f":"INDEX('Jahr 1'!$J$38:$J$42,MATCH(A7,'Jahr 1'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 2'!$J$38:$J$42,MATCH(A7,'Jahr 2'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 3'!$J$38:$J$42,MATCH(A7,'Jahr 3'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 4'!$J$38:$J$42,MATCH(A7,'Jahr 4'!$H$38:$H$42,0))","v":{"$error":"#N/A"}}]
["Dieter Diem",{"$f":"INDEX('Jahr 1'!$J$38:$J$42,MATCH(A8,'Jahr 1'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 2'!$J$38:$J$42,MATCH(A8,'Jahr 2'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 3'!$J$38:$J$42,MATCH(A8,'Jahr 3'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 4'!$J$38:$J$42,MATCH(A8,'Jahr 4'!$H$38:$H$42,0))","v":{"$error":"#N/A"}}]
["Normal",{"$f":"INDEX('Jahr 1'!$J$38:$J$42,MATCH(A9,'Jahr 1'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 2'!$J$38:$J$42,MATCH(A9,'Jahr 2'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 3'!$J$38:$J$42,MATCH(A9,'Jahr 3'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 4'!$J$38:$J$42,MATCH(A9,'Jahr 4'!$H$38:$H$42,0))","v":{"$error":"#N/A"}},null,null,"Vorwärts zur Firmenauswertung"]

{"sheet":"Auswertung Firmen","index":12,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,1,5,1],[3,7,5,7],[3,6,5,6],[3,5,5,5],[3,4,5,4],[3,3,5,3],[3,2,5,2]]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Auswertung Firmen"]
[]
[null,"Siehe Grunddaten","Siehe entspr. Jahr","Siehe Grunddaten","Kapitalrendite (brutto, %) * Kapitalisierung","Siehe entspr. Jahr","Gewinn (brutto, CHF) - Jahresgehalt (CHF)","Gewinn (netto, CHF) / Kapitalisierung",null,null,"Zurück zu Firma A"]
[]
[null,null,null,null,null,null,null,null,null,null,"Vorwärts zu den Grafiken"]
[]
["1. Jahr","Kapitalisierung","CEO","Kapitalrendite brutto, in %","Gewinn brutto, in CHF","Jahresgehalt, in CHF","Gewinn netto, in CHF","Kapitalrendite netto, in %"]
["Firma A",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A9,Grunddaten!$A$14:$A$18,0))","v":5000000},{"$f":"INDEX('Jahr 1'!$H$38:$H$42,MATCH('Auswertung Firmen'!A9,'Jahr 1'!$I$38:$I$42,0))","v":"Albert Adam"},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C9,Grunddaten!$A$6:$A$10,0))","v":0.14000000000000001},{"$f":"D9*B9","v":700000.00000000012},{"$f":"INDEX('Jahr 1'!$J$38:$J$42,MATCH('Auswertung Firmen'!A9,'Jahr 1'!$I$38:$I$42,0))","v":0},{"$f":"E9-F9","v":700000.00000000012},{"$f":"G9/B9","v":0.14000000000000001}]
["Firma B",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A10,Grunddaten!$A$14:$A$18,0))","v":10000000},{"$f":"INDEX('Jahr 1'!$H$38:$H$42,MATCH('Auswertung Firmen'!A10,'Jahr 1'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C10,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D10*B10","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 1'!$J$38:$J$42,MATCH('Auswertung Firmen'!A10,'Jahr 1'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E10-F10","v":{"$error":"#N/A"}},{"$f":"G10/B10","v":{"$error":"#N/A"}}]
["Firma C",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A11,Grunddaten!$A$14:$A$18,0))","v":30000000},{"$f":"INDEX('Jahr 1'!$H$38:$H$42,MATCH('Auswertung Firmen'!A11,'Jahr 1'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C11,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D11*B11","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 1'!$J$38:$J$42,MATCH('Auswertung Firmen'!A11,'Jahr 1'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E11-F11","v":{"$error":"#N/A"}},{"$f":"G11/B11","v":{"$error":"#N/A"}}]
["Firma D",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A12,Grunddaten!$A$14:$A$18,0))","v":400000000},{"$f":"INDEX('Jahr 1'!$H$38:$H$42,MATCH('Auswertung Firmen'!A12,'Jahr 1'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C12,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D12*B12","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 1'!$J$38:$J$42,MATCH('Auswertung Firmen'!A12,'Jahr 1'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E12-F12","v":{"$error":"#N/A"}},{"$f":"G12/B12","v":{"$error":"#N/A"}}]
["Firma E",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A13,Grunddaten!$A$14:$A$18,0))","v":7000000000},{"$f":"INDEX('Jahr 1'!$H$38:$H$42,MATCH('Auswertung Firmen'!A13,'Jahr 1'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C13,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D13*B13","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 1'!$J$38:$J$42,MATCH('Auswertung Firmen'!A13,'Jahr 1'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E13-F13","v":{"$error":"#N/A"}},{"$f":"G13/B13","v":{"$error":"#N/A"}},null,null,"Zurück zur Zuweisung Manager Jahr 1"]
[]
["2. Jahr","Kapitalisierung","CEO","Kapitalrendite brutto, in %","Gewinn brutto, in CHF","Jahresgehalt, in CHF","Gewinn netto, in CHF","Kapitalrendite netto, in %"]
["Firma A",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A16,Grunddaten!$A$14:$A$18,0))","v":5000000},{"$f":"INDEX('Jahr 2'!$H$38:$H$42,MATCH('Auswertung Firmen'!A16,'Jahr 2'!$I$38:$I$42,0))","v":"Albert Adam"},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C16,Grunddaten!$A$6:$A$10,0))","v":0.14000000000000001},{"$f":"D16*B16","v":700000.00000000012},{"$f":"INDEX('Jahr 2'!$J$38:$J$42,MATCH('Auswertung Firmen'!A16,'Jahr 2'!$I$38:$I$42,0))","v":0},{"$f":"E16-F16","v":700000.00000000012},{"$f":"G16/B16","v":0.14000000000000001}]
["Firma B",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A17,Grunddaten!$A$14:$A$18,0))","v":10000000},{"$f":"INDEX('Jahr 2'!$H$38:$H$42,MATCH('Auswertung Firmen'!A17,'Jahr 2'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C17,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D17*B17","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 2'!$J$38:$J$42,MATCH('Auswertung Firmen'!A17,'Jahr 2'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E17-F17","v":{"$error":"#N/A"}},{"$f":"G17/B17","v":{"$error":"#N/A"}}]
["Firma C",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A18,Grunddaten!$A$14:$A$18,0))","v":30000000},{"$f":"INDEX('Jahr 2'!$H$38:$H$42,MATCH('Auswertung Firmen'!A18,'Jahr 2'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C18,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D18*B18","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 2'!$J$38:$J$42,MATCH('Auswertung Firmen'!A18,'Jahr 2'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E18-F18","v":{"$error":"#N/A"}},{"$f":"G18/B18","v":{"$error":"#N/A"}}]
["Firma D",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A19,Grunddaten!$A$14:$A$18,0))","v":400000000},{"$f":"INDEX('Jahr 2'!$H$38:$H$42,MATCH('Auswertung Firmen'!A19,'Jahr 2'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C19,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D19*B19","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 2'!$J$38:$J$42,MATCH('Auswertung Firmen'!A19,'Jahr 2'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E19-F19","v":{"$error":"#N/A"}},{"$f":"G19/B19","v":{"$error":"#N/A"}}]
["Firma E",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A20,Grunddaten!$A$14:$A$18,0))","v":7000000000},{"$f":"INDEX('Jahr 2'!$H$38:$H$42,MATCH('Auswertung Firmen'!A20,'Jahr 2'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C20,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D20*B20","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 2'!$J$38:$J$42,MATCH('Auswertung Firmen'!A20,'Jahr 2'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E20-F20","v":{"$error":"#N/A"}},{"$f":"G20/B20","v":{"$error":"#N/A"}},null,null,"Zurück zur Zuweisung Manager Jahr 2"]
[]
["3. Jahr","Kapitalisierung","CEO","Kapitalrendite brutto, in %","Gewinn brutto, in CHF","Jahresgehalt, in CHF","Gewinn netto, in CHF","Kapitalrendite netto, in %"]
["Firma A",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A23,Grunddaten!$A$14:$A$18,0))","v":5000000},{"$f":"INDEX('Jahr 3'!$H$38:$H$42,MATCH('Auswertung Firmen'!A23,'Jahr 3'!$I$38:$I$42,0))","v":"Albert Adam"},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C23,Grunddaten!$A$6:$A$10,0))","v":0.14000000000000001},{"$f":"D23*B23","v":700000.00000000012},{"$f":"INDEX('Jahr 3'!$J$38:$J$42,MATCH('Auswertung Firmen'!A23,'Jahr 3'!$I$38:$I$42,0))","v":0},{"$f":"E23-F23","v":700000.00000000012},{"$f":"G23/B23","v":0.14000000000000001}]
["Firma B",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A24,Grunddaten!$A$14:$A$18,0))","v":10000000},{"$f":"INDEX('Jahr 3'!$H$38:$H$42,MATCH('Auswertung Firmen'!A24,'Jahr 3'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C24,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D24*B24","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 3'!$J$38:$J$42,MATCH('Auswertung Firmen'!A24,'Jahr 3'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E24-F24","v":{"$error":"#N/A"}},{"$f":"G24/B24","v":{"$error":"#N/A"}}]
["Firma C",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A25,Grunddaten!$A$14:$A$18,0))","v":30000000},{"$f":"INDEX('Jahr 3'!$H$38:$H$42,MATCH('Auswertung Firmen'!A25,'Jahr 3'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C25,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D25*B25","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 3'!$J$38:$J$42,MATCH('Auswertung Firmen'!A25,'Jahr 3'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E25-F25","v":{"$error":"#N/A"}},{"$f":"G25/B25","v":{"$error":"#N/A"}}]
["Firma D",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A26,Grunddaten!$A$14:$A$18,0))","v":400000000},{"$f":"INDEX('Jahr 3'!$H$38:$H$42,MATCH('Auswertung Firmen'!A26,'Jahr 3'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C26,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D26*B26","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 3'!$J$38:$J$42,MATCH('Auswertung Firmen'!A26,'Jahr 3'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E26-F26","v":{"$error":"#N/A"}},{"$f":"G26/B26","v":{"$error":"#N/A"}}]
["Firma E",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A27,Grunddaten!$A$14:$A$18,0))","v":7000000000},{"$f":"INDEX('Jahr 3'!$H$38:$H$42,MATCH('Auswertung Firmen'!A27,'Jahr 3'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C27,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D27*B27","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 3'!$J$38:$J$42,MATCH('Auswertung Firmen'!A27,'Jahr 3'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E27-F27","v":{"$error":"#N/A"}},{"$f":"G27/B27","v":{"$error":"#N/A"}},null,null,"Zurück zur Zuweisung Manager Jahr 3"]
[]
["4. Jahr","Kapitalisierung","CEO","Kapitalrendite brutto, in %","Gewinn brutto, in CHF","Jahresgehalt, in CHF","Gewinn netto, in CHF","Kapitalrendite netto, in %"]
["Firma A",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A30,Grunddaten!$A$14:$A$18,0))","v":5000000},{"$f":"INDEX('Jahr 4'!$H$38:$H$42,MATCH('Auswertung Firmen'!A30,'Jahr 4'!$I$38:$I$42,0))","v":"Albert Adam"},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C30,Grunddaten!$A$6:$A$10,0))","v":0.14000000000000001},{"$f":"D30*B30","v":700000.00000000012},{"$f":"INDEX('Jahr 4'!$J$38:$J$42,MATCH('Auswertung Firmen'!A30,'Jahr 4'!$I$38:$I$42,0))","v":0},{"$f":"E30-F30","v":700000.00000000012},{"$f":"G30/B30","v":0.14000000000000001}]
["Firma B",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A31,Grunddaten!$A$14:$A$18,0))","v":10000000},{"$f":"INDEX('Jahr 4'!$H$38:$H$42,MATCH('Auswertung Firmen'!A31,'Jahr 4'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C31,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D31*B31","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 4'!$J$38:$J$42,MATCH('Auswertung Firmen'!A31,'Jahr 4'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E31-F31","v":{"$error":"#N/A"}},{"$f":"G31/B31","v":{"$error":"#N/A"}}]
["Firma C",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A32,Grunddaten!$A$14:$A$18,0))","v":30000000},{"$f":"INDEX('Jahr 4'!$H$38:$H$42,MATCH('Auswertung Firmen'!A32,'Jahr 4'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C32,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D32*B32","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 4'!$J$38:$J$42,MATCH('Auswertung Firmen'!A32,'Jahr 4'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E32-F32","v":{"$error":"#N/A"}},{"$f":"G32/B32","v":{"$error":"#N/A"}}]
["Firma D",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A33,Grunddaten!$A$14:$A$18,0))","v":400000000},{"$f":"INDEX('Jahr 4'!$H$38:$H$42,MATCH('Auswertung Firmen'!A33,'Jahr 4'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C33,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D33*B33","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 4'!$J$38:$J$42,MATCH('Auswertung Firmen'!A33,'Jahr 4'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E33-F33","v":{"$error":"#N/A"}},{"$f":"G33/B33","v":{"$error":"#N/A"}}]
["Firma E",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A34,Grunddaten!$A$14:$A$18,0))","v":7000000000},{"$f":"INDEX('Jahr 4'!$H$38:$H$42,MATCH('Auswertung Firmen'!A34,'Jahr 4'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Grunddaten!$B$6:$B$10,MATCH(C34,Grunddaten!$A$6:$A$10,0))","v":{"$error":"#N/A"}},{"$f":"D34*B34","v":{"$error":"#N/A"}},{"$f":"INDEX('Jahr 4'!$J$38:$J$42,MATCH('Auswertung Firmen'!A34,'Jahr 4'!$I$38:$I$42,0))","v":{"$error":"#N/A"}},{"$f":"E34-F34","v":{"$error":"#N/A"}},{"$f":"G34/B34","v":{"$error":"#N/A"}},null,null,"Zurück zur Zuweisung Manager Jahr 4"]

{"sheet":"Grafiken","index":13,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Grafiken"]

{"sheet":"Musterlösung","index":14,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[13,1,14,1],[13,0,14,0],[21,1,21,5],[3,7,4,7],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6]]}
["Spieltheorie - Spitzenverdiener"]
["Lernspiel Cheflöhne - Musterlösung (vgl. Aufgabe 2 im Aufgabenset)"]
[]
[null,"Siehe Grunddaten","Siehe Lösung unten","Siehe Grunddaten","Kapitalrendite (brutto, %) * Kapitalisierung","Siehe Lösung unten","Gewinn (brutto, CHF) - Jahresgehalt (CHF)","Gewinn (netto, CHF) / Kapitalisierung"]
[]
[]
[null,"Kapitalisierung","CEO","Kapitalrendite brutto, in %","Gewinn brutto, in CHF","Jahresgehalt, in CHF","Gewinn netto, in CHF","Kapitalrendite netto, in %"]
["Firma A",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A8,Grunddaten!$A$14:$A$18,0))","v":5000000},"Normale Führungsperson ",0.1,{"$f":"D8*B8","v":500000},300000,{"$f":"E8-F8","v":200000},{"$f":"G8/B8","v":0.04}]
["Firma B",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A9,Grunddaten!$A$14:$A$18,0))","v":10000000},"Dieter Dim ",0.11,{"$f":"D9*B9","v":1100000},{"$f":"C24","v":350000},{"$f":"E9-F9","v":750000},{"$f":"G9/B9","v":7.4999999999999997E-2}]
["Firma C",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A10,Grunddaten!$A$14:$A$18,0))","v":30000000},"Claudia Custer ",0.12,{"$f":"D10*B10","v":3600000},{"$f":"D25","v":500000},{"$f":"E10-F10","v":3100000},{"$f":"G10/B10","v":0.10333333333333333}]
["Firma D",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A11,Grunddaten!$A$14:$A$18,0))","v":400000000},"Bertha Binnig ",0.13,{"$f":"D11*B11","v":52000000},{"$f":"E26","v":1200000},{"$f":"E11-F11","v":50800000},{"$f":"G11/B11","v":0.127}]
["Firma E",{"$f":"INDEX(Grunddaten!$B$14:$B$18,MATCH(A12,Grunddaten!$A$14:$A$18,0))","v":7000000000},"Albert Adam ",0.14000000000000001,{"$f":"D12*B12","v":980000000.00000012},{"$f":"F27","v":16300000},{"$f":"E12-F12","v":963700000.00000012},{"$f":"G12/B12","v":0.13767142857142858}]
[]
[null,"Zahlungsbereitschaft für 1 Prozent mehr Gewinn"]
[]
["Firma A",{"$f":"B8*0.01","v":50000}]
["Firma B",{"$f":"B9*0.01","v":100000}]
["Firma C",{"$f":"B10*0.01","v":300000}]
["Firma D",{"$f":"B11*0.01","v":4000000}]
["Firma E",{"$f":"B12*0.01","v":70000000}]
[]
[null,"Zahlungsbereitschaft für Führungskräfte"]
[null,"Normale Führungsperson ","Dieter Diem ","Claudia Custer ","Bertha Binnig ","Albert Adam "]
["Firma A",300000,{"$f":"B24+B16","v":350000},{"$f":"B24+2*B16","v":400000},{"$f":"B24+3*B16","v":450000},{"$f":"B24+4*B16","v":500000}]
["Firma B",300000,{"$f":"B25+B17","v":400000},{"$f":"B25+2*B17","v":500000},{"$f":"B25+3*B17","v":600000},{"$f":"B25+4*B17","v":700000}]
["Firma C",300000,{"$f":"B26+B18","v":600000},{"$f":"B26+2*B18","v":900000},{"$f":"B26+3*B18","v":1200000},{"$f":"B26+4*B18","v":1500000}]
["Firma D",300000,{"$f":"B27+B19","v":4300000},{"$f":"B27+2*B19","v":8300000},{"$f":"B27+3*B19","v":12300000},{"$f":"B27+4*B19","v":16300000}]
["Firma E",300000,{"$f":"B28+B20","v":70300000},{"$f":"B28+2*B20","v":140300000},{"$f":"B28+3*B20","v":210300000},{"$f":"B28+4*B20","v":280300000}]
[]
["Lösung: "]
["Firma A engagiert eine normale Führungsperson zu 0.3 Mio. "]
["Firma B engagiert Dieter Dim zu 0.35 Mio."]
["Firma C engagiert Claudia Custer zu 0.5 Mio."]
["Firma D engagiert Bertha Binnig zu 1.2 Mio."]
["Firma E engagiert Albert Adam zu 16.3 Mio. "]