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[…]

Read more