I am trying to develop a decision matrix and I cant figure out how to do it
even tho it seems to be staring me in the face.
I have information from several different sources that provide subjective
numeric criteria in various categories about the same item, but the format
from each source is unique and dissimilar from the other.
I want to be able to create a formula that will convert the source data into
a useable format that will help in the decision process.
For example one source may rate an item from 1 €“ 10 with 1 being the most
desirable; another source may rate the same item on a scale of 1 -5 with 5
being the best. There are other sources that likewise provide information in
a distinct format. None of the sources present the info in a consistent
manner.
The formula I would like to create will convert a typed number from one
source into a uniform score that, when totaled will help make a decision.
For example, where in the above 1 -10 example, if a 1 were typed in a cell,
the formula might convert the 1 to, say, a value of 5. When totaled the best
recommendations from each source would yield the highest number.
Any assistance would be greatly appreciated