Recent content by td3201

I think I talked myself out of my concern. The reason I was concerned is if we ever change the range, it would mess with the quality of the scores. However, we are capturing the raw (non-weighted) data so we can re-calculate as needed. This is a very low possibility but fun to project either...

This seems to work pretty well. However, it does not seem to scale if I change the range. Is there a way to make the "grade" the same based on the range? Range = 1000-200 CategoryA Score = 504.2 Percentage Grade = 59.9% Range = 850-300 CategoryA Score = 509.14 Percentage Grade =...

Scratch that, not it.

I just had a thought. Would it work if I made all of the weights in the category equal 1 (100%)?

I am doing a survey of questions grouped into categories. Each question has a weight applied to it. I want to then total and average each category. Lastly, I want to total and average all the categories together. Here's the challenge: I want all of categories and the total average to have the...