I am not sure on the correct method for calculating a normalised value from a data range.

For example:

65 ~ 122

75 ~ 140

The value can be anywhere in those ranges, and I need a single value from 0~1, the ranges have in theory any possible maximum but the score needs to increase with the ranges.

I don't have a math degree only computer science so I am a little limited in my mathematical notation, also note my spelling is because I am English!

Since I use vbscript/vba/excel the most I have managed to write it out in such, and I hope someone can help correct me if I am wrong (I am sure I am).

Score = rand(Min, Max)

Value_Range = abs(Min)+abs(Max)

Normalised_Value = (Score - Min) / Value_Range

Kind regards,

Hugh Wood