I am in the process of creating a "survival" vs "age" curve for component data, similar to Exhibit C-10 in Appendix C of the RCM report by Nowlan & Heap. Instead of relying on specialized software, I am attempting to replicate the process using MS Excel by following the methodology outlined in the report. While trying to replicate their example to ensure accuracy in my own analysis, I encountered a challenge in transitioning from Exhibit C-9 (which I successfully replicated) to Exhibit C-10 (which I struggled to replicate). These specific steps are discussed on page 406 of the appendix. Although my Excel file is currently disorganized, I am working on cleaning it up before sharing. If anyone can recommend a detailed resource explaining these steps further, or if you have experience with a similar analysis and are willing to provide guidance, please let me know. Thank you, Matt.
Hello Matt, I have attached a spreadsheet containing an example of a fictitious accelerated life test that may be beneficial to you. I often use this in my engineering classes to illustrate how to analyze the resulting data and create reliability functions such as R(t), f(t), F(t), h(t), and mean life for each interval. Please take note that columns J and K display the same values for the function h(t), but are calculated differently (column K based on the Nowlan and Heap RCM report). Pay attention to the R(t) curve, as it seems to be of particular interest to you. If you have any questions, feel free to reach out. Regards, Attachment: Life_test.xls (57 KB, 1 version)
In the example provided, a total of 300 electric switches were tested until all eventually failed. A significant portion of the switches experienced failure early on in the testing process, known as "infant mortality". This common occurrence demonstrates the importance of rigorous testing procedures in identifying and addressing faults in electrical components.
Thank you so much for your assistance, Rui. I will carefully review your response over the weekend. Appreciatively, Matt.
In my book, I have illustrated the N&H failure patterns using dummy data on pages 47-53 of Appendix 3-1. Due to my frequent travels, I may not be able to promptly address comments or posts. I apologize for any inconvenience this may cause.
Hi Matt, I remembered discussing the various exhibits and consolidating all the data into one place. I believe that is what I have done in the spreadsheet I am sharing with you. I created this spreadsheet a while ago for training purposes. Please let me know if it meets your requirements. The graphs included are specific to the training I conduct, so don't focus too much on them. I will review the appendix again tonight and provide feedback on both the appendix and the spreadsheet. I trust everything is going well on your end. Attachment: actuarial analysis spreadsheet (38 KB, 1 version).
Hi Matt, It sounds like you're undertaking an interesting project! I've worked on similar pursuits in the past and have faced similar issues concerning Exhibit C-10. A resource I found extremely useful was an online blog called Nathan's Excel Tutorials. They have an in-depth article specifically for creating survival vs. age curves with Excel that might help clarify the steps you’re trying to replicate. Additionally, you might find it beneficial to organize your Excel file into distinguishable sections as you go along - it can be more manageable and less confusing. Hope this helps and I'm looking forward to seeing your successful graph.
✅ Work Order Management
✅ Asset Tracking
✅ Preventive Maintenance
✅ Inspection Report
We have received your information. We will share Schedule Demo details on your Mail Id.
Answer: Answer: The Nowlan and Heap methodology, as outlined in their RCM report, involves analyzing component data to create a survival vs age curve. This method is commonly used in reliability-centered maintenance (RCM) practices.
Answer: Answer: Replicating Exhibit C-10 in MS Excel may require following the specific steps outlined in the report. It's important to ensure accuracy in transitioning from earlier exhibits like C-9 to successfully create the survival vs age curve.
Answer: Answer: To find detailed resources or guidance on replicating Exhibit C-10 from the Nowlan and Heap report in Excel, you may consider searching online for related articles, tutorials, or forums where others have shared their experiences with similar analyses.
Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.