{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Personalkosten","Maschinenkosten"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",4]
[null,"Thema","Methoden der Datenaufbereitung"]
[]
[null,"Inhalt","SUMMEWENNund"]
[null,null,"Zusammenstellung von Daten"]
[null,null,"mit SUMMEWENN und ZÄHLENWENN"]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Personalkosten","index":1,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Produkt","Bauteil","Anzahl","Std","Lohn","MNr","MSatz"]
["A",1,7,3.5,29.8,6,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":40.914999999999999}]
["A",2,1,4.3,69.52,1,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":32.299999999999997}]
["A",1,4,2.5,27.45,5,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":40.396666666666668}]
["A",3,2,4.4000000000000004,76.31,14,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":52.926666666666669}]
["A",4,0,6.9,57.09,16,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":32.473333333333336}]
["A",5,17,9.5,85.88,16,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":32.473333333333336}]
["A",6,1,7.5,79.510000000000005,1,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":32.299999999999997}]
["A",7,7,4.8,86.93,15,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":50.769999999999996}]
["A",8,19,1.4,27.68,15,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":50.769999999999996}]
["A",9,14,2.8,9.2200000000000006,14,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":52.926666666666669}]
["A",10,2,10.6,57.02,9,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":58.534999999999997}]
["A",11,3,5.9,98.69,1,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":32.299999999999997}]
["A",12,17,18.7,37.25,17,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":32.243333333333332}]
["A",13,1,10.5,21.45,8,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":66.39}]
["A",14,2,17.899999999999999,1.57,18,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":61.085000000000001}]
["A",15,9,3.8,2.39,5,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":40.396666666666668}]
["B",1,17,2.4,96.02,9,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":58.534999999999997}]
["B",2,19,6.7,51.6,12,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":42.325000000000003}]
["B",3,0,10.6,20.37,6,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":40.914999999999999}]
["B",4,8,4.8,29.28,2,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":45.32}]
["B",5,14,2.2000000000000002,16.38,7,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":21.793333333333333}]
["B",6,14,10.1,87.71,9,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":58.534999999999997}]
["B",7,15,1.4,77.64,13,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":53.696666666666665}]
["C",1,2,2.2000000000000002,13.07,17,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":32.243333333333332}]
["C",2,9,19.8,29.82,11,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":31.393333333333334}]
["C",3,14,7.8,47.73,3,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":66.39}]
["C",4,8,14.7,13.95,13,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":53.696666666666665}]
["C",5,7,6.9,79.97,5,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":40.396666666666668}]
["C",6,18,6.7,27.53,14,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":52.926666666666669}]
["C",7,0,11.3,70.7,3,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":66.39}]
["C",8,13,11.3,87.97,12,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":42.325000000000003}]
["C",9,8,4.7,28.97,18,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":61.085000000000001}]
["C",10,4,11.9,58.61,13,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":53.696666666666665}]
["C",11,6,2.6,21.31,16,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":32.473333333333336}]
["D",1,1,4.8,19.5,1,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":32.299999999999997}]
["D",2,2,5,12.95,15,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":50.769999999999996}]
["D",3,1,18.2,99.01,6,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":40.914999999999999}]
["D",4,18,9,57.26,13,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":53.696666666666665}]
["D",5,3,11.3,57.83,18,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":61.085000000000001}]
["D",6,11,10.5,5.8,8,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":66.39}]
["E",1,15,12.6,59.56,1,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":32.299999999999997}]
["E",2,4,3.1,71,2,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":45.32}]
["E",3,15,19.2,78.84,19,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":51.093333333333334}]
["E",4,20,6.5,50.5,12,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":42.325000000000003}]
["E",5,0,0.8,40.619999999999997,15,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":50.769999999999996}]
["E",6,11,12.8,79.03,2,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":45.32}]
["E",7,9,15.1,44.28,13,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":53.696666666666665}]
["E",8,6,9.3000000000000007,29.42,20,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":43.75}]
["E",9,12,16,93.79,12,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":42.325000000000003}]
["E",10,9,6.9,22.3,11,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":31.393333333333334}]
["E",11,6,5.7,49.37,20,{"$f":"SUMIF(Maschinen[MNr],Produktion[[#This Row],[MNr]],Maschinen[Stundensatz])/COUNTIF(Maschinen[MNr],Produktion[[#This Row],[MNr]])","v":43.75}]

{"sheet":"Maschinenkosten","index":2,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["MNr","Stundensatz","1. Satz","2. Satz","3. Satz","Mittelwert"]
[7,21.42,{"$f":"LARGE(($A$2:$A$50=$A2)*($B$2:$B$50),COLUMN(A$1))","v":22.1},{"$f":"LARGE(($A$2:$A$50=$A2)*($B$2:$B$50),COLUMN(B$1))","v":21.86},{"$f":"LARGE(($A$2:$A$50=$A2)*($B$2:$B$50),COLUMN(C$1))","v":21.42},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":21.793333333333333}]
[7,21.86,{"$f":"LARGE(($A$2:$A$50=$A3)*($B$2:$B$50),COLUMN(A$1))","v":22.1},{"$f":"LARGE(($A$2:$A$50=$A3)*($B$2:$B$50),COLUMN(B$1))","v":21.86},{"$f":"LARGE(($A$2:$A$50=$A3)*($B$2:$B$50),COLUMN(C$1))","v":21.42},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":21.793333333333333}]
[16,32.22,{"$f":"LARGE(($A$2:$A$50=$A4)*($B$2:$B$50),COLUMN(A$1))","v":34.42},{"$f":"LARGE(($A$2:$A$50=$A4)*($B$2:$B$50),COLUMN(B$1))","v":32.22},{"$f":"LARGE(($A$2:$A$50=$A4)*($B$2:$B$50),COLUMN(C$1))","v":30.78},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":32.473333333333336}]
[7,22.1,{"$f":"LARGE(($A$2:$A$50=$A5)*($B$2:$B$50),COLUMN(A$1))","v":22.1},{"$f":"LARGE(($A$2:$A$50=$A5)*($B$2:$B$50),COLUMN(B$1))","v":21.86},{"$f":"LARGE(($A$2:$A$50=$A5)*($B$2:$B$50),COLUMN(C$1))","v":21.42},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":21.793333333333333}]
[17,30.19,{"$f":"LARGE(($A$2:$A$50=$A6)*($B$2:$B$50),COLUMN(A$1))","v":33.869999999999997},{"$f":"LARGE(($A$2:$A$50=$A6)*($B$2:$B$50),COLUMN(B$1))","v":32.67},{"$f":"LARGE(($A$2:$A$50=$A6)*($B$2:$B$50),COLUMN(C$1))","v":30.19},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":32.243333333333332}]
[11,30.73,{"$f":"LARGE(($A$2:$A$50=$A7)*($B$2:$B$50),COLUMN(A$1))","v":32.56},{"$f":"LARGE(($A$2:$A$50=$A7)*($B$2:$B$50),COLUMN(B$1))","v":30.89},{"$f":"LARGE(($A$2:$A$50=$A7)*($B$2:$B$50),COLUMN(C$1))","v":30.73},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":31.393333333333334}]
[16,30.78,{"$f":"LARGE(($A$2:$A$50=$A8)*($B$2:$B$50),COLUMN(A$1))","v":34.42},{"$f":"LARGE(($A$2:$A$50=$A8)*($B$2:$B$50),COLUMN(B$1))","v":32.22},{"$f":"LARGE(($A$2:$A$50=$A8)*($B$2:$B$50),COLUMN(C$1))","v":30.78},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":32.473333333333336}]
[11,30.89,{"$f":"LARGE(($A$2:$A$50=$A9)*($B$2:$B$50),COLUMN(A$1))","v":32.56},{"$f":"LARGE(($A$2:$A$50=$A9)*($B$2:$B$50),COLUMN(B$1))","v":30.89},{"$f":"LARGE(($A$2:$A$50=$A9)*($B$2:$B$50),COLUMN(C$1))","v":30.73},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":31.393333333333334}]
[1,31.25,{"$f":"LARGE(($A$2:$A$50=$A10)*($B$2:$B$50),COLUMN(A$1))","v":33.35},{"$f":"LARGE(($A$2:$A$50=$A10)*($B$2:$B$50),COLUMN(B$1))","v":31.25},{"$f":"LARGE(($A$2:$A$50=$A10)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":32.299999999999997}]
[11,32.56,{"$f":"LARGE(($A$2:$A$50=$A11)*($B$2:$B$50),COLUMN(A$1))","v":32.56},{"$f":"LARGE(($A$2:$A$50=$A11)*($B$2:$B$50),COLUMN(B$1))","v":30.89},{"$f":"LARGE(($A$2:$A$50=$A11)*($B$2:$B$50),COLUMN(C$1))","v":30.73},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":31.393333333333334}]
[17,32.67,{"$f":"LARGE(($A$2:$A$50=$A12)*($B$2:$B$50),COLUMN(A$1))","v":33.869999999999997},{"$f":"LARGE(($A$2:$A$50=$A12)*($B$2:$B$50),COLUMN(B$1))","v":32.67},{"$f":"LARGE(($A$2:$A$50=$A12)*($B$2:$B$50),COLUMN(C$1))","v":30.19},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":32.243333333333332}]
[1,33.35,{"$f":"LARGE(($A$2:$A$50=$A13)*($B$2:$B$50),COLUMN(A$1))","v":33.35},{"$f":"LARGE(($A$2:$A$50=$A13)*($B$2:$B$50),COLUMN(B$1))","v":31.25},{"$f":"LARGE(($A$2:$A$50=$A13)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":32.299999999999997}]
[17,33.869999999999997,{"$f":"LARGE(($A$2:$A$50=$A14)*($B$2:$B$50),COLUMN(A$1))","v":33.869999999999997},{"$f":"LARGE(($A$2:$A$50=$A14)*($B$2:$B$50),COLUMN(B$1))","v":32.67},{"$f":"LARGE(($A$2:$A$50=$A14)*($B$2:$B$50),COLUMN(C$1))","v":30.19},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":32.243333333333332}]
[16,34.42,{"$f":"LARGE(($A$2:$A$50=$A15)*($B$2:$B$50),COLUMN(A$1))","v":34.42},{"$f":"LARGE(($A$2:$A$50=$A15)*($B$2:$B$50),COLUMN(B$1))","v":32.22},{"$f":"LARGE(($A$2:$A$50=$A15)*($B$2:$B$50),COLUMN(C$1))","v":30.78},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":32.473333333333336}]
[5,39.96,{"$f":"LARGE(($A$2:$A$50=$A16)*($B$2:$B$50),COLUMN(A$1))","v":41.13},{"$f":"LARGE(($A$2:$A$50=$A16)*($B$2:$B$50),COLUMN(B$1))","v":40.1},{"$f":"LARGE(($A$2:$A$50=$A16)*($B$2:$B$50),COLUMN(C$1))","v":39.96},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":40.396666666666668}]
[5,40.1,{"$f":"LARGE(($A$2:$A$50=$A17)*($B$2:$B$50),COLUMN(A$1))","v":41.13},{"$f":"LARGE(($A$2:$A$50=$A17)*($B$2:$B$50),COLUMN(B$1))","v":40.1},{"$f":"LARGE(($A$2:$A$50=$A17)*($B$2:$B$50),COLUMN(C$1))","v":39.96},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":40.396666666666668}]
[6,40.549999999999997,{"$f":"LARGE(($A$2:$A$50=$A18)*($B$2:$B$50),COLUMN(A$1))","v":41.28},{"$f":"LARGE(($A$2:$A$50=$A18)*($B$2:$B$50),COLUMN(B$1))","v":40.549999999999997},{"$f":"LARGE(($A$2:$A$50=$A18)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":40.914999999999999}]
[5,41.13,{"$f":"LARGE(($A$2:$A$50=$A19)*($B$2:$B$50),COLUMN(A$1))","v":41.13},{"$f":"LARGE(($A$2:$A$50=$A19)*($B$2:$B$50),COLUMN(B$1))","v":40.1},{"$f":"LARGE(($A$2:$A$50=$A19)*($B$2:$B$50),COLUMN(C$1))","v":39.96},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":40.396666666666668}]
[6,41.28,{"$f":"LARGE(($A$2:$A$50=$A20)*($B$2:$B$50),COLUMN(A$1))","v":41.28},{"$f":"LARGE(($A$2:$A$50=$A20)*($B$2:$B$50),COLUMN(B$1))","v":40.549999999999997},{"$f":"LARGE(($A$2:$A$50=$A20)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":40.914999999999999}]
[12,41.56,{"$f":"LARGE(($A$2:$A$50=$A21)*($B$2:$B$50),COLUMN(A$1))","v":43.09},{"$f":"LARGE(($A$2:$A$50=$A21)*($B$2:$B$50),COLUMN(B$1))","v":41.56},{"$f":"LARGE(($A$2:$A$50=$A21)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":42.325000000000003}]
[12,43.09,{"$f":"LARGE(($A$2:$A$50=$A22)*($B$2:$B$50),COLUMN(A$1))","v":43.09},{"$f":"LARGE(($A$2:$A$50=$A22)*($B$2:$B$50),COLUMN(B$1))","v":41.56},{"$f":"LARGE(($A$2:$A$50=$A22)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":42.325000000000003}]
[20,43.22,{"$f":"LARGE(($A$2:$A$50=$A23)*($B$2:$B$50),COLUMN(A$1))","v":44.28},{"$f":"LARGE(($A$2:$A$50=$A23)*($B$2:$B$50),COLUMN(B$1))","v":43.22},{"$f":"LARGE(($A$2:$A$50=$A23)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":43.75}]
[20,44.28,{"$f":"LARGE(($A$2:$A$50=$A24)*($B$2:$B$50),COLUMN(A$1))","v":44.28},{"$f":"LARGE(($A$2:$A$50=$A24)*($B$2:$B$50),COLUMN(B$1))","v":43.22},{"$f":"LARGE(($A$2:$A$50=$A24)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":43.75}]
[2,44.87,{"$f":"LARGE(($A$2:$A$50=$A25)*($B$2:$B$50),COLUMN(A$1))","v":45.77},{"$f":"LARGE(($A$2:$A$50=$A25)*($B$2:$B$50),COLUMN(B$1))","v":44.87},{"$f":"LARGE(($A$2:$A$50=$A25)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":45.32}]
[2,45.77,{"$f":"LARGE(($A$2:$A$50=$A26)*($B$2:$B$50),COLUMN(A$1))","v":45.77},{"$f":"LARGE(($A$2:$A$50=$A26)*($B$2:$B$50),COLUMN(B$1))","v":44.87},{"$f":"LARGE(($A$2:$A$50=$A26)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":45.32}]
[19,50.43,{"$f":"LARGE(($A$2:$A$50=$A27)*($B$2:$B$50),COLUMN(A$1))","v":51.47},{"$f":"LARGE(($A$2:$A$50=$A27)*($B$2:$B$50),COLUMN(B$1))","v":51.38},{"$f":"LARGE(($A$2:$A$50=$A27)*($B$2:$B$50),COLUMN(C$1))","v":50.43},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":51.093333333333334}]
[15,50.73,{"$f":"LARGE(($A$2:$A$50=$A28)*($B$2:$B$50),COLUMN(A$1))","v":50.81},{"$f":"LARGE(($A$2:$A$50=$A28)*($B$2:$B$50),COLUMN(B$1))","v":50.73},{"$f":"LARGE(($A$2:$A$50=$A28)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":50.769999999999996}]
[15,50.81,{"$f":"LARGE(($A$2:$A$50=$A29)*($B$2:$B$50),COLUMN(A$1))","v":50.81},{"$f":"LARGE(($A$2:$A$50=$A29)*($B$2:$B$50),COLUMN(B$1))","v":50.73},{"$f":"LARGE(($A$2:$A$50=$A29)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":50.769999999999996}]
[19,51.38,{"$f":"LARGE(($A$2:$A$50=$A30)*($B$2:$B$50),COLUMN(A$1))","v":51.47},{"$f":"LARGE(($A$2:$A$50=$A30)*($B$2:$B$50),COLUMN(B$1))","v":51.38},{"$f":"LARGE(($A$2:$A$50=$A30)*($B$2:$B$50),COLUMN(C$1))","v":50.43},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":51.093333333333334}]
[19,51.47,{"$f":"LARGE(($A$2:$A$50=$A31)*($B$2:$B$50),COLUMN(A$1))","v":51.47},{"$f":"LARGE(($A$2:$A$50=$A31)*($B$2:$B$50),COLUMN(B$1))","v":51.38},{"$f":"LARGE(($A$2:$A$50=$A31)*($B$2:$B$50),COLUMN(C$1))","v":50.43},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":51.093333333333334}]
[14,51.98,{"$f":"LARGE(($A$2:$A$50=$A32)*($B$2:$B$50),COLUMN(A$1))","v":53.4},{"$f":"LARGE(($A$2:$A$50=$A32)*($B$2:$B$50),COLUMN(B$1))","v":53.4},{"$f":"LARGE(($A$2:$A$50=$A32)*($B$2:$B$50),COLUMN(C$1))","v":51.98},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":52.926666666666669}]
[13,52.99,{"$f":"LARGE(($A$2:$A$50=$A33)*($B$2:$B$50),COLUMN(A$1))","v":54.34},{"$f":"LARGE(($A$2:$A$50=$A33)*($B$2:$B$50),COLUMN(B$1))","v":53.76},{"$f":"LARGE(($A$2:$A$50=$A33)*($B$2:$B$50),COLUMN(C$1))","v":52.99},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":53.696666666666665}]
[14,53.4,{"$f":"LARGE(($A$2:$A$50=$A34)*($B$2:$B$50),COLUMN(A$1))","v":53.4},{"$f":"LARGE(($A$2:$A$50=$A34)*($B$2:$B$50),COLUMN(B$1))","v":53.4},{"$f":"LARGE(($A$2:$A$50=$A34)*($B$2:$B$50),COLUMN(C$1))","v":51.98},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":52.926666666666669}]
[14,53.4,{"$f":"LARGE(($A$2:$A$50=$A35)*($B$2:$B$50),COLUMN(A$1))","v":53.4},{"$f":"LARGE(($A$2:$A$50=$A35)*($B$2:$B$50),COLUMN(B$1))","v":53.4},{"$f":"LARGE(($A$2:$A$50=$A35)*($B$2:$B$50),COLUMN(C$1))","v":51.98},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":52.926666666666669}]
[13,53.76,{"$f":"LARGE(($A$2:$A$50=$A36)*($B$2:$B$50),COLUMN(A$1))","v":54.34},{"$f":"LARGE(($A$2:$A$50=$A36)*($B$2:$B$50),COLUMN(B$1))","v":53.76},{"$f":"LARGE(($A$2:$A$50=$A36)*($B$2:$B$50),COLUMN(C$1))","v":52.99},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":53.696666666666665}]
[10,53.98,{"$f":"LARGE(($A$2:$A$50=$A37)*($B$2:$B$50),COLUMN(A$1))","v":55.65},{"$f":"LARGE(($A$2:$A$50=$A37)*($B$2:$B$50),COLUMN(B$1))","v":53.98},{"$f":"LARGE(($A$2:$A$50=$A37)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":54.814999999999998}]
[13,54.34,{"$f":"LARGE(($A$2:$A$50=$A38)*($B$2:$B$50),COLUMN(A$1))","v":54.34},{"$f":"LARGE(($A$2:$A$50=$A38)*($B$2:$B$50),COLUMN(B$1))","v":53.76},{"$f":"LARGE(($A$2:$A$50=$A38)*($B$2:$B$50),COLUMN(C$1))","v":52.99},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":53.696666666666665}]
[4,55.26,{"$f":"LARGE(($A$2:$A$50=$A39)*($B$2:$B$50),COLUMN(A$1))","v":56.12},{"$f":"LARGE(($A$2:$A$50=$A39)*($B$2:$B$50),COLUMN(B$1))","v":55.26},{"$f":"LARGE(($A$2:$A$50=$A39)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":55.69}]
[10,55.65,{"$f":"LARGE(($A$2:$A$50=$A40)*($B$2:$B$50),COLUMN(A$1))","v":55.65},{"$f":"LARGE(($A$2:$A$50=$A40)*($B$2:$B$50),COLUMN(B$1))","v":53.98},{"$f":"LARGE(($A$2:$A$50=$A40)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":54.814999999999998}]
[4,56.12,{"$f":"LARGE(($A$2:$A$50=$A41)*($B$2:$B$50),COLUMN(A$1))","v":56.12},{"$f":"LARGE(($A$2:$A$50=$A41)*($B$2:$B$50),COLUMN(B$1))","v":55.26},{"$f":"LARGE(($A$2:$A$50=$A41)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":55.69}]
[9,58.17,{"$f":"LARGE(($A$2:$A$50=$A42)*($B$2:$B$50),COLUMN(A$1))","v":58.9},{"$f":"LARGE(($A$2:$A$50=$A42)*($B$2:$B$50),COLUMN(B$1))","v":58.17},{"$f":"LARGE(($A$2:$A$50=$A42)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":58.534999999999997}]
[9,58.9,{"$f":"LARGE(($A$2:$A$50=$A43)*($B$2:$B$50),COLUMN(A$1))","v":58.9},{"$f":"LARGE(($A$2:$A$50=$A43)*($B$2:$B$50),COLUMN(B$1))","v":58.17},{"$f":"LARGE(($A$2:$A$50=$A43)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":58.534999999999997}]
[18,59.88,{"$f":"LARGE(($A$2:$A$50=$A44)*($B$2:$B$50),COLUMN(A$1))","v":62.29},{"$f":"LARGE(($A$2:$A$50=$A44)*($B$2:$B$50),COLUMN(B$1))","v":59.88},{"$f":"LARGE(($A$2:$A$50=$A44)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":61.085000000000001}]
[18,62.29,{"$f":"LARGE(($A$2:$A$50=$A45)*($B$2:$B$50),COLUMN(A$1))","v":62.29},{"$f":"LARGE(($A$2:$A$50=$A45)*($B$2:$B$50),COLUMN(B$1))","v":59.88},{"$f":"LARGE(($A$2:$A$50=$A45)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":61.085000000000001}]
[3,63.32,{"$f":"LARGE(($A$2:$A$50=$A46)*($B$2:$B$50),COLUMN(A$1))","v":69.87},{"$f":"LARGE(($A$2:$A$50=$A46)*($B$2:$B$50),COLUMN(B$1))","v":65.98},{"$f":"LARGE(($A$2:$A$50=$A46)*($B$2:$B$50),COLUMN(C$1))","v":63.32},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":66.39}]
[8,65.44,{"$f":"LARGE(($A$2:$A$50=$A47)*($B$2:$B$50),COLUMN(A$1))","v":67.34},{"$f":"LARGE(($A$2:$A$50=$A47)*($B$2:$B$50),COLUMN(B$1))","v":65.44},{"$f":"LARGE(($A$2:$A$50=$A47)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":66.39}]
[3,65.98,{"$f":"LARGE(($A$2:$A$50=$A48)*($B$2:$B$50),COLUMN(A$1))","v":69.87},{"$f":"LARGE(($A$2:$A$50=$A48)*($B$2:$B$50),COLUMN(B$1))","v":65.98},{"$f":"LARGE(($A$2:$A$50=$A48)*($B$2:$B$50),COLUMN(C$1))","v":63.32},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":66.39}]
[8,67.34,{"$f":"LARGE(($A$2:$A$50=$A49)*($B$2:$B$50),COLUMN(A$1))","v":67.34},{"$f":"LARGE(($A$2:$A$50=$A49)*($B$2:$B$50),COLUMN(B$1))","v":65.44},{"$f":"LARGE(($A$2:$A$50=$A49)*($B$2:$B$50),COLUMN(C$1))","v":0},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":66.39}]
[3,69.87,{"$f":"LARGE(($A$2:$A$50=$A50)*($B$2:$B$50),COLUMN(A$1))","v":69.87},{"$f":"LARGE(($A$2:$A$50=$A50)*($B$2:$B$50),COLUMN(B$1))","v":65.98},{"$f":"LARGE(($A$2:$A$50=$A50)*($B$2:$B$50),COLUMN(C$1))","v":63.32},{"$f":"SUM(Maschinen[[#This Row],[1. Satz]:[3. Satz]])/COUNTIF(Maschinen[[#This Row],[1. Satz]:[3. Satz]],\">0\")","v":66.39}]