0

I try to exponentially decrease a value (force) over specific 10 to 11 range.

In other words, if a length of a vector d is 10 cm then force needs to be 1000 Newton. If length d is close to 11 cm then force should be close to 0.

My exponential decreasing formula is doing it, but on a large scale, and i have no idea how to bring it within 10-11 range.

Any help is appreciated!

Here is a demo in excel with the formula unrolled:

Cell M16 = 1000

Cell L17 = 10.1

enter image description here

Avi
  • 101

1 Answers1

2

You want to find the exponential function: $$f(d)=Ae^{rd},$$ where $r$ is the rate of decay and $A$ is a parameter.

Now plug the two points: $(d,f)=(10,1000)$ and $(11,0)$ to make up a system of equations for $d$ and $A$. Once you find the function, you can use it in Excel.

farruhota
  • 31,482