Hi,
I need some help with a formula to give me a score based on certain criteria.
I have a list of objects each with 10 attributes (all numeric scores, with a set scale from percentile data).
Each of these attributes has a weighting to give me an overall score.
I need to use the scale (10 numeric values with varying range) I have for each of the 10 attributes to give a score for each of these attributes - i.e. if attribute (i) scores 5.6 and its 10pt scale ranges from 0-6, what will be the score for that attribute, etc for each of the 10 attributes for this object.
Then use these scores to calculate an overall score using the weighting factor for each.
I hope that makes sense and someone can help me out with this.
I need some help with a formula to give me a score based on certain criteria.
I have a list of objects each with 10 attributes (all numeric scores, with a set scale from percentile data).
Each of these attributes has a weighting to give me an overall score.
I need to use the scale (10 numeric values with varying range) I have for each of the 10 attributes to give a score for each of these attributes - i.e. if attribute (i) scores 5.6 and its 10pt scale ranges from 0-6, what will be the score for that attribute, etc for each of the 10 attributes for this object.
Then use these scores to calculate an overall score using the weighting factor for each.
I hope that makes sense and someone can help me out with this.
