Excel for Mechanical Engineer, cost saving by Risk Based Inspection

how to use excel for Risk Based Inspection? We will figure out inspection plan using data in the previous article. First we will find optimum inspection date base on fixed interval and RBI interval using simple excel spreadsheet. Use excel function “ + ; MAX”.   remark: next inspection – fixed = Last inspection date + fixed inspection interval ( 5 years) next inspection – RBI = Last inspection date + RBI inspection interval next inspection date = Maximum (optimum) value between next inspection – fixed and next – inspection RBI. We extend inspection interval using Risk Based Inspection study.[…]

Read more