Hi,

I am currently tasked with assisting building a new computer maintenance management system for our fleet. Which involves the use of excel and SFI coding (see below description)

• The SFI Code System provides a structured way to categorize ship components, including spare parts, using a four-digit numerical code

• The first digit identifies the main function, the second the system, and the third the sub-system.
• We have gone to fourth and fifth coding subcategories.
• Our equipment starts at number 3 and runs to 4 example

We currently have two SFI coding to component mapping spreadsheets, I would like to be able to use simply put one column with numerical descending from number 3 - 393 and one column with component description. We do have equipment variation from vessel to vessel so we have occurrences where its not possible to assign the same SFI code to a component due to terminology differences.

I want to assign the SFI descending numbering code from column A and C which matches component names in column B and D to create a match with component names in column F and assign the already used SFI numbering code from columns A and C any none matches will require a new SFI numbering code. As we expand out fleet I would like to use further columns to do the same function.

I have attached the copy of the data I am talking about as well as a numerical coding sequence to help better understand my request.

Thanks in advance

Lee