Excel equiv. of Map() function

Lynxmotion Rovers, Sumo, and Tracked
1

I’m working on modeling some sensor readings in Excel, but I need help to figure out the equivalent of the Arduino Map() function.

I’ve got a sensor reading that is returning a value between 0.4 and about 2.16. On the Arduino, I would Map that to a new value between 1 and 10.

Does anyone know how I could simulate this in Excel?

2

You can do a simple linear regression using very basic math:
Based on this generic line equation: y = ax+b

You can suppose the two following equalities and solve for a and b.
1 = a*(0.4)+b
10 = a*(1.16)+b

Then simple use the formula to compute the desired values.