Bls: [belajar-excel] Menghitung MTTR & MTBF [2 Attachments]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: [belajar-excel] Menghitung MTTR & MTBF [2 Attachments]

Milis Belajar Excel mailing list
hai odong,terima kasih untuk sarannya.
Dear All,
Inti dari yang saya tanyakan adalah rumus seperti apa ya yang bisa saya pakai bila saya ingin mencari nilai MTTR & MTBF dan dapat menghasilkan berapa persen PA unit sesuai dengan data repair report yang saya lampirkan.

    Pada Kamis, 27 Juli 2017 19:42, "odong nando [hidden email] [belajar-excel]" <[hidden email]> menulis:
 

    

 hai reza,
coba di buatkan dummy nya dalam bentuk excel, bagaimana cara ngitungnya dan apa hasil yang di inginkan...pasti nanti banyak yang komen deh... br,

odong nando


      Dari: "Reza Suhartono [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: [hidden email]
Cc: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 27 Juli 2017 17:13
 Judul: [belajar-excel] Menghitung MTTR & MTBF
 
    Selamat Siang,
Mau tanya seperti apa ya rumus untuk menghitung MTTR & MTBF unit dump truck agar bisa sinkron ke Physical Availibility (PA). Ditunggu feedbacknya.  

     #yiv8839993422 -- #yiv8839993422ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8839993422 #yiv8839993422ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8839993422 #yiv8839993422ygrp-mkp #yiv8839993422hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8839993422 #yiv8839993422ygrp-mkp #yiv8839993422ads {margin-bottom:10px;}#yiv8839993422 #yiv8839993422ygrp-mkp .yiv8839993422ad {padding:0 0;}#yiv8839993422 #yiv8839993422ygrp-mkp .yiv8839993422ad p {margin:0;}#yiv8839993422 #yiv8839993422ygrp-mkp .yiv8839993422ad a {color:#0000ff;text-decoration:none;}#yiv8839993422 #yiv8839993422ygrp-sponsor #yiv8839993422ygrp-lc {font-family:Arial;}#yiv8839993422 #yiv8839993422ygrp-sponsor #yiv8839993422ygrp-lc #yiv8839993422hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8839993422 #yiv8839993422ygrp-sponsor #yiv8839993422ygrp-lc .yiv8839993422ad {margin-bottom:10px;padding:0 0;}#yiv8839993422 #yiv8839993422actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8839993422 #yiv8839993422activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8839993422 #yiv8839993422activity span {font-weight:700;}#yiv8839993422 #yiv8839993422activity span:first-child {text-transform:uppercase;}#yiv8839993422 #yiv8839993422activity span a {color:#5085b6;text-decoration:none;}#yiv8839993422 #yiv8839993422activity span span {color:#ff7900;}#yiv8839993422 #yiv8839993422activity span .yiv8839993422underline {text-decoration:underline;}#yiv8839993422 .yiv8839993422attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8839993422 .yiv8839993422attach div a {text-decoration:none;}#yiv8839993422 .yiv8839993422attach img {border:none;padding-right:5px;}#yiv8839993422 .yiv8839993422attach label {display:block;margin-bottom:5px;}#yiv8839993422 .yiv8839993422attach label a {text-decoration:none;}#yiv8839993422 blockquote {margin:0 0 0 4px;}#yiv8839993422 .yiv8839993422bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8839993422 .yiv8839993422bold a {text-decoration:none;}#yiv8839993422 dd.yiv8839993422last p a {font-family:Verdana;font-weight:700;}#yiv8839993422 dd.yiv8839993422last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8839993422 dd.yiv8839993422last p span.yiv8839993422yshortcuts {margin-right:0;}#yiv8839993422 div.yiv8839993422attach-table div div a {text-decoration:none;}#yiv8839993422 div.yiv8839993422attach-table {width:400px;}#yiv8839993422 div.yiv8839993422file-title a, #yiv8839993422 div.yiv8839993422file-title a:active, #yiv8839993422 div.yiv8839993422file-title a:hover, #yiv8839993422 div.yiv8839993422file-title a:visited {text-decoration:none;}#yiv8839993422 div.yiv8839993422photo-title a, #yiv8839993422 div.yiv8839993422photo-title a:active, #yiv8839993422 div.yiv8839993422photo-title a:hover, #yiv8839993422 div.yiv8839993422photo-title a:visited {text-decoration:none;}#yiv8839993422 div#yiv8839993422ygrp-mlmsg #yiv8839993422ygrp-msg p a span.yiv8839993422yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8839993422 .yiv8839993422green {color:#628c2a;}#yiv8839993422 .yiv8839993422MsoNormal {margin:0 0 0 0;}#yiv8839993422 o {font-size:0;}#yiv8839993422 #yiv8839993422photos div {float:left;width:72px;}#yiv8839993422 #yiv8839993422photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8839993422 #yiv8839993422photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8839993422 #yiv8839993422reco-category {font-size:77%;}#yiv8839993422 #yiv8839993422reco-desc {font-size:77%;}#yiv8839993422 .yiv8839993422replbq {margin:4px;}#yiv8839993422 #yiv8839993422ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8839993422 #yiv8839993422ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8839993422 #yiv8839993422ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8839993422 #yiv8839993422ygrp-mlmsg select, #yiv8839993422 input, #yiv8839993422 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8839993422 #yiv8839993422ygrp-mlmsg pre, #yiv8839993422 code {font:115% monospace;}#yiv8839993422 #yiv8839993422ygrp-mlmsg * {line-height:1.22em;}#yiv8839993422 #yiv8839993422ygrp-mlmsg #yiv8839993422logo {padding-bottom:10px;}#yiv8839993422 #yiv8839993422ygrp-msg p a {font-family:Verdana;}#yiv8839993422 #yiv8839993422ygrp-msg p#yiv8839993422attach-count span {color:#1E66AE;font-weight:700;}#yiv8839993422 #yiv8839993422ygrp-reco #yiv8839993422reco-head {color:#ff7900;font-weight:700;}#yiv8839993422 #yiv8839993422ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8839993422 #yiv8839993422ygrp-sponsor #yiv8839993422ov li a {font-size:130%;text-decoration:none;}#yiv8839993422 #yiv8839993422ygrp-sponsor #yiv8839993422ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8839993422 #yiv8839993422ygrp-sponsor #yiv8839993422ov ul {margin:0;padding:0 0 0 8px;}#yiv8839993422 #yiv8839993422ygrp-text {font-family:Georgia;}#yiv8839993422 #yiv8839993422ygrp-text p {margin:0 0 1em 0;}#yiv8839993422 #yiv8839993422ygrp-text tt {font-size:120%;}#yiv8839993422 #yiv8839993422ygrp-vital ul li:last-child {border-right:none !important;}#yiv8839993422

   

mtbf_mttr_calculation.xls (41K) Download Attachment
Contoh laporan.xlsx (190K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: [belajar-excel] Menghitung MTTR & MTBF [1 Attachment]

Milis Belajar Excel mailing list
Dear Reza,
Sambil menunggu dari rekan yang lainnya, berikut contoh yang dapat diberikan semoga sesuai keinginan

Samsudin


    Pada Jumat, 28 Juli 2017 11:40, "Reza Suhartono [hidden email] [belajar-excel]" <[hidden email]> menulis:


     hai odong,terima kasih untuk sarannya.
Dear All,
Inti dari yang saya tanyakan adalah rumus seperti apa ya yang bisa saya pakai bila saya ingin mencari nilai MTTR & MTBF dan dapat menghasilkan berapa persen PA unit sesuai dengan data repair report yang saya lampirkan.

    Pada Kamis, 27 Juli 2017 19:42, "odong nando [hidden email] [belajar-excel]" <[hidden email]> menulis:


  

 hai reza,
coba di buatkan dummy nya dalam bentuk excel, bagaimana cara ngitungnya dan apa hasil yang di inginkan...pasti nanti banyak yang komen deh... br,

odong nando


      Dari: "Reza Suhartono [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: [hidden email]
Cc: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 27 Juli 2017 17:13
 Judul: [belajar-excel] Menghitung MTTR & MTBF

    Selamat Siang,
Mau tanya seperti apa ya rumus untuk menghitung MTTR & MTBF unit dump truck agar bisa sinkron ke Physical Availibility (PA). Ditunggu feedbacknya.



     #yiv3519047703 #yiv3519047703 -- #yiv3519047703ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3519047703 #yiv3519047703ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3519047703 #yiv3519047703ygrp-mkp #yiv3519047703hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3519047703 #yiv3519047703ygrp-mkp #yiv3519047703ads {margin-bottom:10px;}#yiv3519047703 #yiv3519047703ygrp-mkp .yiv3519047703ad {padding:0 0;}#yiv3519047703 #yiv3519047703ygrp-mkp .yiv3519047703ad p {margin:0;}#yiv3519047703 #yiv3519047703ygrp-mkp .yiv3519047703ad a {color:#0000ff;text-decoration:none;}#yiv3519047703 #yiv3519047703ygrp-sponsor #yiv3519047703ygrp-lc {font-family:Arial;}#yiv3519047703 #yiv3519047703ygrp-sponsor #yiv3519047703ygrp-lc #yiv3519047703hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3519047703 #yiv3519047703ygrp-sponsor #yiv3519047703ygrp-lc .yiv3519047703ad {margin-bottom:10px;padding:0 0;}#yiv3519047703 #yiv3519047703actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3519047703 #yiv3519047703activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3519047703 #yiv3519047703activity span {font-weight:700;}#yiv3519047703 #yiv3519047703activity span:first-child {text-transform:uppercase;}#yiv3519047703 #yiv3519047703activity span a {color:#5085b6;text-decoration:none;}#yiv3519047703 #yiv3519047703activity span span {color:#ff7900;}#yiv3519047703 #yiv3519047703activity span .yiv3519047703underline {text-decoration:underline;}#yiv3519047703 .yiv3519047703attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3519047703 .yiv3519047703attach div a {text-decoration:none;}#yiv3519047703 .yiv3519047703attach img {border:none;padding-right:5px;}#yiv3519047703 .yiv3519047703attach label {display:block;margin-bottom:5px;}#yiv3519047703 .yiv3519047703attach label a {text-decoration:none;}#yiv3519047703 blockquote {margin:0 0 0 4px;}#yiv3519047703 .yiv3519047703bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3519047703 .yiv3519047703bold a {text-decoration:none;}#yiv3519047703 dd.yiv3519047703last p a {font-family:Verdana;font-weight:700;}#yiv3519047703 dd.yiv3519047703last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3519047703 dd.yiv3519047703last p span.yiv3519047703yshortcuts {margin-right:0;}#yiv3519047703 div.yiv3519047703attach-table div div a {text-decoration:none;}#yiv3519047703 div.yiv3519047703attach-table {width:400px;}#yiv3519047703 div.yiv3519047703file-title a, #yiv3519047703 div.yiv3519047703file-title a:active, #yiv3519047703 div.yiv3519047703file-title a:hover, #yiv3519047703 div.yiv3519047703file-title a:visited {text-decoration:none;}#yiv3519047703 div.yiv3519047703photo-title a, #yiv3519047703 div.yiv3519047703photo-title a:active, #yiv3519047703 div.yiv3519047703photo-title a:hover, #yiv3519047703 div.yiv3519047703photo-title a:visited {text-decoration:none;}#yiv3519047703 div#yiv3519047703ygrp-mlmsg #yiv3519047703ygrp-msg p a span.yiv3519047703yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3519047703 .yiv3519047703green {color:#628c2a;}#yiv3519047703 .yiv3519047703MsoNormal {margin:0 0 0 0;}#yiv3519047703 o {font-size:0;}#yiv3519047703 #yiv3519047703photos div {float:left;width:72px;}#yiv3519047703 #yiv3519047703photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3519047703 #yiv3519047703photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3519047703 #yiv3519047703reco-category {font-size:77%;}#yiv3519047703 #yiv3519047703reco-desc {font-size:77%;}#yiv3519047703 .yiv3519047703replbq {margin:4px;}#yiv3519047703 #yiv3519047703ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3519047703 #yiv3519047703ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3519047703 #yiv3519047703ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3519047703 #yiv3519047703ygrp-mlmsg select, #yiv3519047703 input, #yiv3519047703 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3519047703 #yiv3519047703ygrp-mlmsg pre, #yiv3519047703 code {font:115% monospace;}#yiv3519047703 #yiv3519047703ygrp-mlmsg * {line-height:1.22em;}#yiv3519047703 #yiv3519047703ygrp-mlmsg #yiv3519047703logo {padding-bottom:10px;}#yiv3519047703 #yiv3519047703ygrp-msg p a {font-family:Verdana;}#yiv3519047703 #yiv3519047703ygrp-msg p#yiv3519047703attach-count span {color:#1E66AE;font-weight:700;}#yiv3519047703 #yiv3519047703ygrp-reco #yiv3519047703reco-head {color:#ff7900;font-weight:700;}#yiv3519047703 #yiv3519047703ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3519047703 #yiv3519047703ygrp-sponsor #yiv3519047703ov li a {font-size:130%;text-decoration:none;}#yiv3519047703 #yiv3519047703ygrp-sponsor #yiv3519047703ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3519047703 #yiv3519047703ygrp-sponsor #yiv3519047703ov ul {margin:0;padding:0 0 0 8px;}#yiv3519047703 #yiv3519047703ygrp-text {font-family:Georgia;}#yiv3519047703 #yiv3519047703ygrp-text p {margin:0 0 1em 0;}#yiv3519047703 #yiv3519047703ygrp-text tt {font-size:120%;}#yiv3519047703 #yiv3519047703ygrp-vital ul li:last-child {border-right:none !important;}#yiv3519047703


Contoh laporan Rev.1.xlsx (922K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: [belajar-excel] Menghitung MTTR & MTBF

Milis Belajar Excel mailing list
Dear Bang Samsudin,
Terima kasih untuk contohnya namun apakah ada rumusnya bang untuk hitung MTTR sendiri trus MTBF sendiri setelah itu di compare menjadi nilai PA & MA?Terima kasih atas bantuannya bang.

    Pada Senin, 31 Juli 2017 12:32, "Samsudin Sam [hidden email] [belajar-excel]" <[hidden email]> menulis:


     Dear Reza,
Sambil menunggu dari rekan yang lainnya, berikut contoh yang dapat diberikan semoga sesuai keinginan

Samsudin


    Pada Jumat, 28 Juli 2017 11:40, "Reza Suhartono [hidden email] [belajar-excel]" <[hidden email]> menulis:


     hai odong,terima kasih untuk sarannya.
Dear All,
Inti dari yang saya tanyakan adalah rumus seperti apa ya yang bisa saya pakai bila saya ingin mencari nilai MTTR & MTBF dan dapat menghasilkan berapa persen PA unit sesuai dengan data repair report yang saya lampirkan.

    Pada Kamis, 27 Juli 2017 19:42, "odong nando [hidden email] [belajar-excel]" <[hidden email]> menulis:


  

 hai reza,
coba di buatkan dummy nya dalam bentuk excel, bagaimana cara ngitungnya dan apa hasil yang di inginkan...pasti nanti banyak yang komen deh... br,

odong nando


      Dari: "Reza Suhartono [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: [hidden email]
Cc: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 27 Juli 2017 17:13
 Judul: [belajar-excel] Menghitung MTTR & MTBF

    Selamat Siang,
Mau tanya seperti apa ya rumus untuk menghitung MTTR & MTBF unit dump truck agar bisa sinkron ke Physical Availibility (PA). Ditunggu feedbacknya.





     #yiv4090953418 #yiv4090953418 -- #yiv4090953418ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4090953418 #yiv4090953418ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4090953418 #yiv4090953418ygrp-mkp #yiv4090953418hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4090953418 #yiv4090953418ygrp-mkp #yiv4090953418ads {margin-bottom:10px;}#yiv4090953418 #yiv4090953418ygrp-mkp .yiv4090953418ad {padding:0 0;}#yiv4090953418 #yiv4090953418ygrp-mkp .yiv4090953418ad p {margin:0;}#yiv4090953418 #yiv4090953418ygrp-mkp .yiv4090953418ad a {color:#0000ff;text-decoration:none;}#yiv4090953418 #yiv4090953418ygrp-sponsor #yiv4090953418ygrp-lc {font-family:Arial;}#yiv4090953418 #yiv4090953418ygrp-sponsor #yiv4090953418ygrp-lc #yiv4090953418hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4090953418 #yiv4090953418ygrp-sponsor #yiv4090953418ygrp-lc .yiv4090953418ad {margin-bottom:10px;padding:0 0;}#yiv4090953418 #yiv4090953418actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4090953418 #yiv4090953418activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4090953418 #yiv4090953418activity span {font-weight:700;}#yiv4090953418 #yiv4090953418activity span:first-child {text-transform:uppercase;}#yiv4090953418 #yiv4090953418activity span a {color:#5085b6;text-decoration:none;}#yiv4090953418 #yiv4090953418activity span span {color:#ff7900;}#yiv4090953418 #yiv4090953418activity span .yiv4090953418underline {text-decoration:underline;}#yiv4090953418 .yiv4090953418attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4090953418 .yiv4090953418attach div a {text-decoration:none;}#yiv4090953418 .yiv4090953418attach img {border:none;padding-right:5px;}#yiv4090953418 .yiv4090953418attach label {display:block;margin-bottom:5px;}#yiv4090953418 .yiv4090953418attach label a {text-decoration:none;}#yiv4090953418 blockquote {margin:0 0 0 4px;}#yiv4090953418 .yiv4090953418bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4090953418 .yiv4090953418bold a {text-decoration:none;}#yiv4090953418 dd.yiv4090953418last p a {font-family:Verdana;font-weight:700;}#yiv4090953418 dd.yiv4090953418last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4090953418 dd.yiv4090953418last p span.yiv4090953418yshortcuts {margin-right:0;}#yiv4090953418 div.yiv4090953418attach-table div div a {text-decoration:none;}#yiv4090953418 div.yiv4090953418attach-table {width:400px;}#yiv4090953418 div.yiv4090953418file-title a, #yiv4090953418 div.yiv4090953418file-title a:active, #yiv4090953418 div.yiv4090953418file-title a:hover, #yiv4090953418 div.yiv4090953418file-title a:visited {text-decoration:none;}#yiv4090953418 div.yiv4090953418photo-title a, #yiv4090953418 div.yiv4090953418photo-title a:active, #yiv4090953418 div.yiv4090953418photo-title a:hover, #yiv4090953418 div.yiv4090953418photo-title a:visited {text-decoration:none;}#yiv4090953418 div#yiv4090953418ygrp-mlmsg #yiv4090953418ygrp-msg p a span.yiv4090953418yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4090953418 .yiv4090953418green {color:#628c2a;}#yiv4090953418 .yiv4090953418MsoNormal {margin:0 0 0 0;}#yiv4090953418 o {font-size:0;}#yiv4090953418 #yiv4090953418photos div {float:left;width:72px;}#yiv4090953418 #yiv4090953418photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4090953418 #yiv4090953418photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4090953418 #yiv4090953418reco-category {font-size:77%;}#yiv4090953418 #yiv4090953418reco-desc {font-size:77%;}#yiv4090953418 .yiv4090953418replbq {margin:4px;}#yiv4090953418 #yiv4090953418ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4090953418 #yiv4090953418ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4090953418 #yiv4090953418ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4090953418 #yiv4090953418ygrp-mlmsg select, #yiv4090953418 input, #yiv4090953418 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4090953418 #yiv4090953418ygrp-mlmsg pre, #yiv4090953418 code {font:115% monospace;}#yiv4090953418 #yiv4090953418ygrp-mlmsg * {line-height:1.22em;}#yiv4090953418 #yiv4090953418ygrp-mlmsg #yiv4090953418logo {padding-bottom:10px;}#yiv4090953418 #yiv4090953418ygrp-msg p a {font-family:Verdana;}#yiv4090953418 #yiv4090953418ygrp-msg p#yiv4090953418attach-count span {color:#1E66AE;font-weight:700;}#yiv4090953418 #yiv4090953418ygrp-reco #yiv4090953418reco-head {color:#ff7900;font-weight:700;}#yiv4090953418 #yiv4090953418ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4090953418 #yiv4090953418ygrp-sponsor #yiv4090953418ov li a {font-size:130%;text-decoration:none;}#yiv4090953418 #yiv4090953418ygrp-sponsor #yiv4090953418ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4090953418 #yiv4090953418ygrp-sponsor #yiv4090953418ov ul {margin:0;padding:0 0 0 8px;}#yiv4090953418 #yiv4090953418ygrp-text {font-family:Georgia;}#yiv4090953418 #yiv4090953418ygrp-text p {margin:0 0 1em 0;}#yiv4090953418 #yiv4090953418ygrp-text tt {font-size:120%;}#yiv4090953418 #yiv4090953418ygrp-vital ul li:last-child {border-right:none !important;}#yiv4090953418

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: [belajar-excel] Menghitung MTTR & MTBF

Milis Belajar Excel mailing list
Dear All,
apakah ada yang sudah punya jawaban untuk pertanyaan saya untuk MTTR & MTBF?

    Pada Senin, 31 Juli 2017 14:18, "Reza Suhartono [hidden email] [belajar-excel]" <[hidden email]> menulis:


     Dear Bang Samsudin,
Terima kasih untuk contohnya namun apakah ada rumusnya bang untuk hitung MTTR sendiri trus MTBF sendiri setelah itu di compare menjadi nilai PA & MA?Terima kasih atas bantuannya bang.

    Pada Senin, 31 Juli 2017 12:32, "Samsudin Sam [hidden email] [belajar-excel]" <[hidden email]> menulis:


     Dear Reza,
Sambil menunggu dari rekan yang lainnya, berikut contoh yang dapat diberikan semoga sesuai keinginan

Samsudin


    Pada Jumat, 28 Juli 2017 11:40, "Reza Suhartono [hidden email] [belajar-excel]" <[hidden email]> menulis:


     hai odong,terima kasih untuk sarannya.
Dear All,
Inti dari yang saya tanyakan adalah rumus seperti apa ya yang bisa saya pakai bila saya ingin mencari nilai MTTR & MTBF dan dapat menghasilkan berapa persen PA unit sesuai dengan data repair report yang saya lampirkan.

    Pada Kamis, 27 Juli 2017 19:42, "odong nando [hidden email] [belajar-excel]" <[hidden email]> menulis:


  

 hai reza,
coba di buatkan dummy nya dalam bentuk excel, bagaimana cara ngitungnya dan apa hasil yang di inginkan...pasti nanti banyak yang komen deh... br,

odong nando


      Dari: "Reza Suhartono [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: [hidden email]
Cc: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 27 Juli 2017 17:13
 Judul: [belajar-excel] Menghitung MTTR & MTBF

    Selamat Siang,
Mau tanya seperti apa ya rumus untuk menghitung MTTR & MTBF unit dump truck agar bisa sinkron ke Physical Availibility (PA). Ditunggu feedbacknya.







     #yiv5742235414 #yiv5742235414 -- #yiv5742235414ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5742235414 #yiv5742235414ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5742235414 #yiv5742235414ygrp-mkp #yiv5742235414hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5742235414 #yiv5742235414ygrp-mkp #yiv5742235414ads {margin-bottom:10px;}#yiv5742235414 #yiv5742235414ygrp-mkp .yiv5742235414ad {padding:0 0;}#yiv5742235414 #yiv5742235414ygrp-mkp .yiv5742235414ad p {margin:0;}#yiv5742235414 #yiv5742235414ygrp-mkp .yiv5742235414ad a {color:#0000ff;text-decoration:none;}#yiv5742235414 #yiv5742235414ygrp-sponsor #yiv5742235414ygrp-lc {font-family:Arial;}#yiv5742235414 #yiv5742235414ygrp-sponsor #yiv5742235414ygrp-lc #yiv5742235414hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5742235414 #yiv5742235414ygrp-sponsor #yiv5742235414ygrp-lc .yiv5742235414ad {margin-bottom:10px;padding:0 0;}#yiv5742235414 #yiv5742235414actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5742235414 #yiv5742235414activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5742235414 #yiv5742235414activity span {font-weight:700;}#yiv5742235414 #yiv5742235414activity span:first-child {text-transform:uppercase;}#yiv5742235414 #yiv5742235414activity span a {color:#5085b6;text-decoration:none;}#yiv5742235414 #yiv5742235414activity span span {color:#ff7900;}#yiv5742235414 #yiv5742235414activity span .yiv5742235414underline {text-decoration:underline;}#yiv5742235414 .yiv5742235414attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5742235414 .yiv5742235414attach div a {text-decoration:none;}#yiv5742235414 .yiv5742235414attach img {border:none;padding-right:5px;}#yiv5742235414 .yiv5742235414attach label {display:block;margin-bottom:5px;}#yiv5742235414 .yiv5742235414attach label a {text-decoration:none;}#yiv5742235414 blockquote {margin:0 0 0 4px;}#yiv5742235414 .yiv5742235414bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5742235414 .yiv5742235414bold a {text-decoration:none;}#yiv5742235414 dd.yiv5742235414last p a {font-family:Verdana;font-weight:700;}#yiv5742235414 dd.yiv5742235414last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5742235414 dd.yiv5742235414last p span.yiv5742235414yshortcuts {margin-right:0;}#yiv5742235414 div.yiv5742235414attach-table div div a {text-decoration:none;}#yiv5742235414 div.yiv5742235414attach-table {width:400px;}#yiv5742235414 div.yiv5742235414file-title a, #yiv5742235414 div.yiv5742235414file-title a:active, #yiv5742235414 div.yiv5742235414file-title a:hover, #yiv5742235414 div.yiv5742235414file-title a:visited {text-decoration:none;}#yiv5742235414 div.yiv5742235414photo-title a, #yiv5742235414 div.yiv5742235414photo-title a:active, #yiv5742235414 div.yiv5742235414photo-title a:hover, #yiv5742235414 div.yiv5742235414photo-title a:visited {text-decoration:none;}#yiv5742235414 div#yiv5742235414ygrp-mlmsg #yiv5742235414ygrp-msg p a span.yiv5742235414yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5742235414 .yiv5742235414green {color:#628c2a;}#yiv5742235414 .yiv5742235414MsoNormal {margin:0 0 0 0;}#yiv5742235414 o {font-size:0;}#yiv5742235414 #yiv5742235414photos div {float:left;width:72px;}#yiv5742235414 #yiv5742235414photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5742235414 #yiv5742235414photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5742235414 #yiv5742235414reco-category {font-size:77%;}#yiv5742235414 #yiv5742235414reco-desc {font-size:77%;}#yiv5742235414 .yiv5742235414replbq {margin:4px;}#yiv5742235414 #yiv5742235414ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5742235414 #yiv5742235414ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5742235414 #yiv5742235414ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5742235414 #yiv5742235414ygrp-mlmsg select, #yiv5742235414 input, #yiv5742235414 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5742235414 #yiv5742235414ygrp-mlmsg pre, #yiv5742235414 code {font:115% monospace;}#yiv5742235414 #yiv5742235414ygrp-mlmsg * {line-height:1.22em;}#yiv5742235414 #yiv5742235414ygrp-mlmsg #yiv5742235414logo {padding-bottom:10px;}#yiv5742235414 #yiv5742235414ygrp-msg p a {font-family:Verdana;}#yiv5742235414 #yiv5742235414ygrp-msg p#yiv5742235414attach-count span {color:#1E66AE;font-weight:700;}#yiv5742235414 #yiv5742235414ygrp-reco #yiv5742235414reco-head {color:#ff7900;font-weight:700;}#yiv5742235414 #yiv5742235414ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5742235414 #yiv5742235414ygrp-sponsor #yiv5742235414ov li a {font-size:130%;text-decoration:none;}#yiv5742235414 #yiv5742235414ygrp-sponsor #yiv5742235414ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5742235414 #yiv5742235414ygrp-sponsor #yiv5742235414ov ul {margin:0;padding:0 0 0 8px;}#yiv5742235414 #yiv5742235414ygrp-text {font-family:Georgia;}#yiv5742235414 #yiv5742235414ygrp-text p {margin:0 0 1em 0;}#yiv5742235414 #yiv5742235414ygrp-text tt {font-size:120%;}#yiv5742235414 #yiv5742235414ygrp-vital ul li:last-child {border-right:none !important;}#yiv5742235414

Loading...