In order to calculate based on a transpose value we have to copy the values to a new column. It would be useful if you could set up a calculated column which automatically converts the result entered according to the transpose boundaries.
e.g. Transpose element set up as
90 - 1
78 - 2
70 - 3
55 - 4
40 - 5
0 - 6
user enters 79, the calculated column automatically populates with 2, user enters 43 calculated column automatically populates with 5