I am not sure on the correct method for calculating a normalised value from a data range.
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