Originally Posted by
Meppso Hi All,
I have a small maths problem. I am trying to create a relationship between two sets of numbers. The non-linear value comes from a light sensor and the other set of values are LUX levels. The values are as follows :-
LUX Value
10, 40800
20, 26500
30, 20400
40, 17000
50, 14700
60, 13020
70, 11780
80, 10750
90, 10230
100, 9320
I have plotted these values out and they appear to give a decaying exponential curve. What I am aiming for is two cells in excel, one in which I can enter a LuX value and the other cell will display the associated ohms value.
Regards,
Andrew.