{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Übungsblatt GEFF OEE","Beispiel","Tabelle3","Tabelle2"],"not_rendered":{"charts":1,"images":4,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Übungsblatt GEFF OEE","index":0,"n_rows":47,"n_cols":66,"rows_kept":47,"merged":[[0,0,0,67],[4,23,5,35]],"flags":["formulas_cached_only"]}
["Übungsblatt: GEFF / OEE - Graphische Darstellung der Verluste"]
[]
[null,null,"Betriebsmittel Inv. Nr.:",{"$nulls":20},"  Monat:",{"$nulls":21},"    Jahr:"]
[]
[{"$nulls":23},"Alle Angaben in Minuten"]
[]
[null,null,"Stillstand:"]
[]
[null,null,"Leistungsverlust:"]
[]
[null,null,"Qualitätsverlust:"]
[]
[]
[null,null,"Nutzung:"]
{"$rows_empty":25}
[{"$nulls":5},1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,13,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20,null,21,null,22,null,23,null,24,null,25,null,26,null,27,null,28,null,29,null,30,null,31]
[]
[]
[]
[{"$nulls":17},"Arbeitsanweisung:"]
[{"$nulls":17},"1. Tragen Sie die Verlustwerte in die Tabelle ein."]
[{"$nulls":17},"2. Errechen Sie die Nutzung abzüglich aller Verluste."]
[{"$nulls":17},"3. Zeichnen Sie die Verlustminuten als Balkendiagramm in das Diagramm ein."]

{"sheet":"Beispiel","index":1,"n_rows":46,"n_cols":66,"rows_kept":46,"merged":[[0,0,0,67],[4,23,5,35],[43,5,44,55],[45,5,46,55]],"flags":["formulas_cached_only"]}
["Datenerfassung (Beispiel)"]
[]
[null,null,"Betriebsmittel Inv. Nr.:",{"$nulls":20},"  Monat:",{"$nulls":21},"    Jahr:"]
[]
[{"$nulls":23},"Alle Angaben in Minuten"]
[]
[null,null,"Stillstand:",null,null,80,null,80,null,40,null,40,null,60,null,20,null,40]
[]
[null,null,"Leistungsverlust:",null,null,40,null,40,null,20,null,20,null,40,null,40,null,40]
[]
[null,null,"Qualitätsverlust:",null,null,40,null,0,null,40,null,20,null,20,null,20,null,20]
[]
[]
[null,null,"Nutzung:",null,null,320,null,360,null,380,null,400,null,360,null,400,null,380]
{"$rows_empty":25}
[{"$nulls":5},1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,13,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20,null,21,null,22,null,23,null,24,null,25,null,26,null,27,null,28,null,29,null,30,null,31]
[]
[]
[]
[{"$nulls":5},"Hinter den drei großen Verlustarten verbergen sich anlagenspezifisch einzelne Stör- und Stillstandsgründe."]
[]
[{"$nulls":5},"Die konsequente und detaillierte Erfassung dieser Schwerpunkte hilft uns bei der Analyse der Verbesserungspotentiale"]

{"sheet":"Tabelle3","index":2,"n_rows":42,"n_cols":35,"rows_kept":42,"merged":[[0,0,0,36],[1,4,1,9],[1,15,1,20],[1,26,1,31],[3,4,3,10],[3,11,3,17],[3,18,3,24],[3,25,3,31],[3,32,3,34],[14,1,15,1],[21,1,22,1]],"flags":["formulas_cached_only"]}
["Übungsblatt: Gesamt - Anlagen - Effizienz  GEFF / OEE"]
[null,null,"Betriebsmittel Inv. Nr.:",null,"Masch. DW-08",{"$nulls":8},"  Monat:",null,"Mai",{"$nulls":8},"    Jahr:",null,2006]
[]
[null,null,"Woche",null,"KW 18",{"$nulls":6},"KW 19",{"$nulls":6},"KW 20",{"$nulls":6},"KW 21",{"$nulls":6},"KW 22"]
[null,null,"Tag",null,1,2,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]
[null,null,"Verfügungszeit:",null,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480]
[null,null,"-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,"Stillstände:",null,80,80,40,40,60,20,40,40,80]
[null,null,"÷",null,"÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷"]
[null,null,"Verfügungszeit:",null,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480]
[null,null,"=",null,"=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","="]
[null,null,"Verfügbarkeitsfaktor",null,0.8333333333333334,0.8333333333333334,0.9166666666666666,0.9166666666666666,0.875,0.9583333333333334,0.9166666666666666,{"v":0.9166666666666666,"d":"0.92"},{"v":0.8333333333333334,"d":"0.83"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[null,null,"Leistungszeit",null,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420]
[null,null,"-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"X","Leistungsverluste",null,40,40,20,20,40,40,40,40,40]
[null,null,"÷",null,"÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷"]
[null,null,"Leistungszeit",null,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420]
[null,null,"=",null,"=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","="]
[null,null,"Leistungsfaktor",null,{"v":0.9047619047619048,"d":"0.90"},{"v":0.9047619047619048,"d":"0.90"},{"v":0.9523809523809523,"d":"0.95"},{"v":0.9523809523809523,"d":"0.95"},{"v":0.9047619047619048,"d":"0.90"},{"v":0.9047619047619048,"d":"0.90"},{"v":0.9047619047619048,"d":"0.90"},{"v":0.9047619047619048,"d":"0.90"},{"v":0.9047619047619048,"d":"0.90"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[null,null,"Nutzungszeit",null,320,360,380,400,360,400,380,380,320,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480]
[null,null,"-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"X","Qualitätsverluste",null,40,0,40,20,20,20,20,20,40]
[null,null,"÷",null,"÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷"]
[null,null,"Nutzungszeit",null,320,360,380,400,360,400,380,380,320,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480]
[null,null,"=",null,"=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","="]
[null,null,"Qualitätsfaktor x 100",null,{"v":0.875,"d":"0.88"},{"v":1,"d":"1.00"},{"v":0.8947368421052632,"d":"0.89"},0.95,{"v":0.9444444444444444,"d":"0.94"},0.95,{"v":0.9473684210526315,"d":"0.95"},{"v":0.9473684210526315,"d":"0.95"},{"v":0.875,"d":"0.88"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[]
[null,null," =  GEFF / OEE in %",null,{"v":65.97222222222221,"d":"66"},{"v":75.39682539682539,"d":"75"},{"v":78.11194653299916,"d":"78"},{"v":82.93650793650792,"d":"83"},{"v":74.7685185185185,"d":"75"},{"v":82.37103174603175,"d":"82"},{"v":78.57142857142856,"d":"79"},{"v":78.57142857142856,"d":"79"},{"v":65.97222222222221,"d":"66"},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
[]
[{"$nulls":4},1,2,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]
{"$rows_empty":11}
[{"$nulls":4},1,2,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]

{"sheet":"Tabelle2","index":3,"n_rows":43,"n_cols":35,"rows_kept":43,"merged":[[0,0,0,36],[1,4,1,9],[1,15,1,20],[1,26,1,31],[3,4,3,10],[3,11,3,17],[3,18,3,24],[3,25,3,31],[3,32,3,34],[14,1,15,1],[21,1,22,1],[27,2,27,3],[28,2,28,3],[42,4,42,10],[42,11,42,17],[42,18,42,24],[42,25,42,31],[42,32,42,34]],"flags":["formulas_cached_only"]}
["Übungsblatt: Gesamt - Anlagen - Effizienz  GEFF / OEE"]
[null,null,"Betriebsmittel Inv. Nr.:",null,"Masch. DW-08",{"$nulls":8},"  Monat:",null,"Mai",{"$nulls":8},"    Jahr:",null,2006]
[]
[null,null,"Woche",null,"KW 18",{"$nulls":6},"KW 19",{"$nulls":6},"KW 20",{"$nulls":6},"KW 21",{"$nulls":6},"KW 22"]
[null,null,"Tag",null,1,2,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]
[null,null,"Verfügungszeit:",null,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480]
[null,null,"-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,"Stillstände:",null,80,60,60,80,80,60,60,60,80]
[null,null,"÷",null,"÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷"]
[null,null,"Verfügungszeit:",null,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480]
[null,null,"=",null,"=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","="]
[null,null,"Verfügbarkeitsfaktor",null,0.8333333333333334,0.875,0.875,0.8333333333333334,0.8333333333333334,0.875,0.875,{"v":0.875,"d":"0.88"},{"v":0.8333333333333334,"d":"0.83"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[null,null,"Leistungszeit",null,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420]
[null,null,"-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"X","Leistungsverluste",null,80,80,60,60,80,50,80,60,50]
[null,null,"÷",null,"÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷"]
[null,null,"Leistungszeit",null,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420]
[null,null,"=",null,"=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","="]
[null,null,"Leistungsfaktor",null,{"v":0.8095238095238095,"d":"0.81"},{"v":0.8095238095238095,"d":"0.81"},{"v":0.8571428571428571,"d":"0.86"},{"v":0.8571428571428571,"d":"0.86"},{"v":0.8095238095238095,"d":"0.81"},{"v":0.8809523809523809,"d":"0.88"},{"v":0.8095238095238095,"d":"0.81"},{"v":0.8571428571428571,"d":"0.86"},{"v":0.8809523809523809,"d":"0.88"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[null,null,"Nutzungszeit",null,260,300,300,300,260,320,300,300,300,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480]
[null,null,"-",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"X","Qualitätsverluste",null,60,40,60,40,60,50,40,60,50]
[null,null,"÷",null,"÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷","÷"]
[null,null,"Nutzungszeit",null,260,300,300,300,260,320,300,300,300,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480]
[null,null,"=",null,"=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","=","="]
[null,null,"Qualitätsfaktor x 100",null,{"v":0.7692307692307693,"d":"0.77"},{"v":0.8666666666666667,"d":"0.87"},{"v":0.8,"d":"0.80"},{"v":0.8666666666666667,"d":"0.87"},{"v":0.7692307692307693,"d":"0.77"},{"v":0.84375,"d":"0.84"},{"v":0.8666666666666667,"d":"0.87"},{"v":0.8,"d":"0.80"},{"v":0.8333333333333334,"d":"0.83"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[]
[null,null," =  GEFF / OEE in %",null,{"v":51.8925518925519,"d":"52"},{"v":61.38888888888889,"d":"61"},{"v":60.00000000000001,"d":"60"},{"v":61.904761904761905,"d":"62"},{"v":51.8925518925519,"d":"52"},{"v":65.03906249999999,"d":"65"},{"v":61.38888888888889,"d":"61"},{"v":60.00000000000001,"d":"60"},{"v":61.177248677248684,"d":"61"},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
[null,null,"Ziel",null,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75]
{"$rows_empty":13}
[{"$nulls":4},"01. - 07.05.06  KW-18",{"$nulls":6},"08. - 14.05.06  KW-19",{"$nulls":6},"15. - 21.05.06  KW-20",{"$nulls":6},"22. - 28.05.06  KW-21",{"$nulls":6},"KW-22"]