## Mechanical Engineer creates value from Risk Based Inspection

how to get a vlue from risk based inspection ? A wise man said “if you buy a product from a manufacturer at \$100 and sell it again to customer at \$120, it is traditional trader. You need more than that. Successful man is selling a product at \$120 even there is not manufacturer available yet.” In previous articles, we learned about processing data to provide lower inspection cost. In simple way, we can classify that activities into 3 block diagram: input, process and output. IPO diagram : Input – Process – Output Input  : last inspection record, equipment data, Risk Based Inspection-RBI study, inspection cost Process  : inspection planning using simple tool i.e. excel spreadsheet Output : inspection schedule, inspection budget and the most important is “lower inspection cost by 50%” Customer : his supervisor, Inspection Manager It just an example of Mechanical engineer job in oil and gas industry. For average mechanical engineer, he only think about inspection schedule & inspection budget for normal process. Yes, it was satisfy his leader. But, for successful Mechanical Engineer, he will think alternate process to create more value to the company. In this example, the value is lower inspection cost by[…]

## 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. Second, we will find inspection cost using excel function: Short / IF and PIVOT Table. Mechanical engineer, please be creative! Group equipment type using unique equipment number. Vessel equipment number always begin with “V” letter and Heat Exchanger equipment number always begin with “HE” letter. Do you see it? For small quantity of equipment and consist only 2 equipment type, it much easier we use “short” function. But when we have thousand equipment data with hundred equipment type, it will not work to use “short” function. We need more smart excel function like “IF”. At this stage, I put all[…]