1 / 10

Wirtschaftsingenieurwesen Maschinenbau und Logistik

Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR). Quelle: Google. Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR). target.

seda
Download Presentation

Wirtschaftsingenieurwesen Maschinenbau und Logistik

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ceylan Isik 07.11.2012 1 Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR) Quelle: Google

  2. Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR) target Ceylan Isik 07.11.2012 2 I got the machine 6 and the objective consists of the analysis of the files inExcel, the availability and efficiency of each machine to calculate for each observation period from.

  3. Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR) Description ofthesolution • Put the LOG file in exel • LOG file open. Copy and paste it into a new Excel-file. • Set the filter to your own machine (machine 6).Create another table standstill cause, with an additional table (SU_Text). Step 1 Ceylan Isik 07.11.2012 3

  4. Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR) Step 2 • Set a filter and order by ascending time • Then calculatethe : respective stoppage(see table), event time (TIME = (B2, C2, D2) and event transmission (= + I2 + TIME (0, 0, H2) See the picture: Ceylan Isik 07.11.2012 4

  5. Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR) Step 3 • plausibility check • Next day / previous day observed.First formula: = IF (I2 <J3, "positive", "negative") wrong still negative values​​, observed a day • Final formula: = IF (I2 <J3, "positive", IF (A2 <A3, "positive", "negative")) correctlyif everything is positive, false if there are negative statements. Ceylan Isik 07.11.2012 5

  6. Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR) Step 4 • Then I calculated what is TRU (rest period), TI (technical difficulties) and TW (maintenance period). • an overview of the downtime causes which I first converted in seconds (s) had the formula = SUMIF (F: F, 1, H: H) • then formatted into the format of hours (h) • The respective stoppage causes the respective region (TRU, TI, TW) ordered Ceylan Isik 07.11.2012 6

  7. Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR) STEP 5 • Calculate efficiency • formula: • Formula for the utilization in Excel: = SUM (((C5-C6-C7-C8) / C5) * 100) SUM(((TB-TRU-TI-TW)/TB)*100 The utilizationrate is 85,45% Ceylan Isik 07.11.2012 7

  8. Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR) Step 6 • availabilitycharge • formula: • MTBF = TB-TI • MMTR =TI Availability:MTBF + MMTR Ceylan Isik 07.11.2012 8

  9. Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR) Flow chart Ceylan Isik 07.11.2012 10

  10. Wirtschaftsingenieurwesen Maschinenbau und Logistik Betriebsinformatik und Programmieren (BIPR) Thank you for your attention Ceylan Isik 07.11.2012 9

More Related