1 / 13

Machine data collection (MDC)

Machine data collection (MDC). Defininition. We have a lot of data sets and with these we calculate availability and capacity factor . Given data sets. Step 1-4. Choice one of 24 machine File „ xls “ in a siutable form Filtering to machine one Sort to date h,m,s. Step 5-7.

zaina
Download Presentation

Machine data collection (MDC)

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. Machinedatacollection(MDC)

  2. Defininition Wehave a lotofdatasetsandwiththesewecalculateavailabilityandcapacityfactor.

  3. Givendatasets

  4. Step 1-4 • Choice oneof 24 machine • File „xls“ in a siutable form • Filteringtomachineone • Sorttodateh,m,s

  5. Step 5-7 • Calculatedeadlock beginn with=ZEIT(B2;C2;D2) • Deadlock time in seconds =G2/86400

  6. Step 8-10 • Calculate Deadlock end with =H2+I2 • Delete lapmistakewith=WENN(F2=1;WENN(A2=A3;WENN(J2>H3;"JA";"Nein");"");WENN(F2=2;WENN(A2=A3;WENN(J2>H3;"JA";"Nein");"");WENN(F2=5;WENN(A2=A3;WENN(J2>H3;"JA";"Nein");"");WENN(F2=9;WENN(A2=A3;WENN(J2>H3;"JA";"Nein");"");""))))

  7. Step 11-14 • Lap time withWENN(A2=A3;WENN(J2>H3;J2-H3;"");"") • Mistakes in twocleaving:=WENN(F2=3;WERT(I2);WENN(F2=4;WERT(I2);WENN(F2=6;WERT(I2);WENN(F2=7;WERT(I2);WENN(F2=8;WERT(I2);""))))) =WENN(F2=1;WERT(I2);WENN(F2=2;WERT(I2);WENN(F2=5;WERT(I2);WENN(F2=9;WERT(I2); "")))))

  8. Step 13-14

  9. Step 15-21 • All datas in seconds • Calculate time ofmachinewith=39*24 • Calculatedeadlock time with=SUMME(I:I) • Lap time with=SUMME(M:M) • Deadlock time with=R10-R12; =SUMME(N:N)

  10. Calculateavailability

  11. Calculatecapacityfactor

  12. Finish datasets

  13. Mistakes • Wehave a bigproblemwhichweeliminatewith a complicatedformel

More Related