{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle1"],"not_rendered":{"charts":0,"images":1,"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":"Tabelle1","index":0,"n_rows":36,"n_cols":109,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,1,34,22],[35,1,35,22],[32,1,32,22],[28,0,28,32],[9,7,11,7],[13,7,15,7],[17,7,19,7],[33,1,33,22],[4,3,4,4],[0,7,2,7],[5,7,7,7]]}
["Heim- Mannschaft","Gast- Mannschaft",null,"Heim-Punkte","Gast-Punkte","Gesamt-Punkte",null,"IST","Historie/ Ballwechsel",1,{"$f":"J1+1","v":2},{"$f":"K1+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,{"$f":"BW1+1","v":67},68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100]
["VFL","FCA",null,1,3,{"$f":"D2+E2","v":4},null,null,"Heim",{"$f":"IF($F$2=J$1,$D$2,\"\")","v":""},"","",{"$f":"IF($F$2=M$1,$D$2,\"\")","v":1},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($F$2=BY$1,$D$2,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,"Gast",{"$f":"IF($F$2=J$1,$E$2,\"\")","v":""},"","",{"$f":"IF($F$2=M$1,$E$2,\"\")","v":3},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($F$2=BY$1,$E$2,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,null,null,"P u n k t e"]
[null,null,null,null,null,null,null,"SOLL 1)","Historie/ Ballwechsel",1,{"$f":"J6+1","v":2},{"$f":"K6+1","v":3},{"$f":"L6+1","v":4},{"$f":"M6+1","v":5},{"$f":"N6+1","v":6},{"$f":"O6+1","v":7},". . ."]
[null,null,null,null,null,null,null,null,"Heim",0]
[null,null,null,null,null,null,null,null,"Gast",1]
[]
[null,null,null,null,null,null,null,"SOLL 2)","Historie/ Ballwechsel",1,{"$f":"J10+1","v":2},{"$f":"K10+1","v":3},{"$f":"L10+1","v":4},{"$f":"M10+1","v":5},{"$f":"N10+1","v":6},{"$f":"O10+1","v":7},". . ."]
[null,null,null,null,null,null,null,null,"Heim",0,0]
[null,null,null,null,null,null,null,null,"Gast",1,2]
[]
[null,null,null,null,null,null,null,"SOLL 3)","Historie/ Ballwechsel",1,{"$f":"J14+1","v":2},{"$f":"K14+1","v":3},{"$f":"L14+1","v":4},{"$f":"M14+1","v":5},{"$f":"N14+1","v":6},{"$f":"O14+1","v":7},". . ."]
[null,null,null,null,null,null,null,null,"Heim",0,0,1]
[null,null,null,null,null,null,null,null,"Gast",1,2,2]
[]
[null,null,null,null,null,null,null,"SOLL 4)","Historie/ Ballwechsel",1,{"$f":"J18+1","v":2},{"$f":"K18+1","v":3},{"$f":"L18+1","v":4},{"$f":"M18+1","v":5},{"$f":"N18+1","v":6},{"$f":"O18+1","v":7},". . ."]
[null,null,null,null,null,null,null,null,"Heim",0,0,1,1]
[null,null,null,null,null,null,null,null,"Gast",1,2,2,3]
[]
[]
["Erläuterung:"]
[]
["Es sollte ein zusätzlicher Schalter (Steuerelement) eingefügt werden, mit dem ein Neustart ermöglicht wird (Eintragung von jeweils einem 0- Wert in den Zellen D2 und E2 sowie Leerzellen in den Bereichen J2 bis DE3)."]
[]
["Demonstration:"]
[]
["Der Bereich ab Spalte J in den Zeilen 2 und 3 zeigt den IST- Zustand mit den derzeitigen Formeln an. Es werden lediglich die Werte aus D2 und E2 in den Zeilen 2 und 3 gezeigt, bei denen die Addition aus beiden Werten dem Eintrag in den Spalten J1 bis DE1 entspricht. Alle davor angezeigten niedrigeren Werte werden nicht angezeigt."]
[]
["Der Bereich ab Spalte J in den Zeilen 7 und 8 zeigt die gewünschten SOLL- Werte an, die sich aufgrund der nachstehend beschriebenen beispielhaften Aktionen ergeben."]
[]
["SOLL 1)","Das mit Zelle E2 verknüpfte rechte Drehfeld wird im oberen Teil angeclickt. Die Addition von D2 (=0) und E2 (=1) beträgt 1. Dieser Wert wird in Zelle F2 ausgewiesen und findet sich in der Zelle J6.\nDeshalb wird in Zelle J7 der Wert 0 aus Zelle D2 und in Zelle J8 der Wert 1 aus Zelle E2 eingetragen."]
["SOLL 2)","Das mit Zelle E2 verknüpfte rechte Drehfeld wird im oberen Teil angeclickt. Die Addition von D2 (=0) und E2 (=2) beträgt 2. Dieser Wert wird in Zelle F2 ausgewiesen und findet sich in der Zelle K10.\nDeshalb wird in Zelle K11 der Wert 0 aus Zelle D2 und in Zelle K12 der Wert 2 aus Zelle E2 eingetragen, während weiterhin die Werte 0 in J11 und 1 in J12 aus SOLL 1) angezeigt werden."]
["SOLL 3)","Das mit Zelle D2 verknüpfte linke Drehfeld wird im oberen Teil angeclickt. Die Addition von D2 (=1) und E2 (=2) beträgt 3. Dieser Wert wird in Zelle F2 ausgewiesen und findet sich in der Zelle L14.\nDeshalb wird in Zelle L15 der Wert 1 aus Zelle D2 und in Zelle L16 der Wert 2 aus Zelle E2 eingetragen, während weiterhin die Werte 0 in J15 und 1 in J16 aus SOLL 1) sowie die Werte 0 in K15 und 2 in K16 aus SOLL 2) angezeigt werden."]
["SOLL 4)","Das mit Zelle E2 verknüpfte rechte Drehfeld wird im oberen Teil angeclickt. Die Addition von D2 (=1) und E2 (=3) beträgt 4. Dieser Wert wird in Zelle F2 ausgewiesen und findet sich in der Zelle M18.\nDeshalb wird in Zelle M19 der Wert 1 aus Zelle D2 und in Zelle M20 der Wert 3 aus Zelle E2 eingetragen, während weiterhin die Werte 0 in J19 und 1 in J20 aus SOLL 1), die Werte 0 in K19 und 2 in K20 aus SOLL 2) sowie die Werte 1 in L19 und 2 in L20 aus SOLL 3) angezeigt werden."]