I have CSV file from one of our device with the range of 0-5 volts. But I need to convert this range from 0-5 to 1-5 volts to use it in another application. I have tried with "Convert a number range to another range, maintaining ratio". This equation is not working with value 0=1 & 5=5. It is changing the 1st & last values. For example-
NewValue = (((OldValue - OldMin) * (NewMax - NewMin)) / (OldMax - OldMin)) + NewMin
Old MIn- 0, Old max-5
New Min- 1, New Max-5
Let's use old value=5
New value= (((5-0)* (5-1))/(5-0)+1)
The answer for new value comes out as 3.3333 but I need the max value to be 5 & min value to change from 0=1. If I follow the same method 0 comes out as 0 not 1.
This is the one equation I tried but it is not working well.
I need a conversion of range 0-5 volts into the 1-5 volts.
((5-0)* (5-1))/(5-0)+1 is 5 not 3.3333. Perhaps you are trying this out on a calculator and having trouble entering the expression? In any event, in this case the computation simplifies to
new_value = (4/5)*old_value + 1