Benchmarking tables for MTBF of Mechanical equipment

[Osama73]

Actually I fully appressiate for your Excell sheet
When we want to calculate MTBF for equipment and component
different authors but different type for calculation as follows :-

1 - Heinz bloch :- put No of equipment failed as guide line to calculate MTBF and failure rate.

2 - William forsthoffer :-
Put running time of equipment as guide line to calculate MTBF.

3 - there is statistical analysis done. To determine running time.

4 - take running time as guide line for determine actual MTBF

Our question is as follows :-

Which one of four methods are more accurate than other, ??

After calculate MTBF by your method is there reference tables to make bench marking for improving issue?.

Is your calculation applied for any mechanical equipment like pumps, and it's component.?

Thanks in advance for your support and valuable Excell sheet you did

Warm regards
Osama

[AliGW]

I believe your query is referring back to this thread: https://www.excelforum.com/excel-for...-and-mttr.html

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[Osama73]

Hi aligw
Thank you, Actually I looking for reference tables to use it as benchnarking for data which use at link which you share.
The data is collected and analyise but the results of analysis for MTBF is it acceptable or need to upgrade.?.
This what I looking for
Best regards
Osama

[AliGW]

You need to attach any relevant files here - download any from the other thread that are yourself and then upload them to this thread. Thanks.

[Osama73]

Hi dears,
To enforce my idea Kindly take a look for the attach.
This table generate by heinz bloch for bench marking MTBF from calculated by first method
I looking if there is any tables to make reference for using fourth method mention at four method mention by folks in this
site..??

Thanks gentlemen for your valuable advice in advance
Best regards
Osama

[Osama73]

Hi gentlemen,

Is there any feedback.
Thank you
Best regards
Osama

[AliGW]

You still haven't attached a workbook. We can't work with a picture.

In the workbook you need to manually mock up what youare trying to do. The lack of response shows that you haven't been clear in your request.