AAV formula for 2013 All Value team

[Penfold]

There's a question in the comments of the ALL-Value team about how to determine AAV, and Matt replies that the formula is in the Forecaster.

And this is it:

y= -9.8in(x) + 57.8

You know when your PC freezes? Well that's what happened to my brain when I read that.

if y is the AAV, and x is the ADP, what is in(x). I know forecaster says that in(x) is the natural log function, but those of us who were messing around at the back of class during maths lessons don't now what a natural log function is.

I've tried using a LOG function in Excel but I dont get the right answer...

Any ideas?

[Penfold]

y= -9.8in(x) + 57.8

Oh I can be an idiot sometimes. I think that it might have been a biscuit* crumb because I moved the book to another part of the table just now and the formula magically becomes

y= -9.8ln(x) + 57.8

using the function =LN(number) if you want to play with it in Excel.

and the formula I've got in my spreadsheet is:

=-9.8*(LN(x))+57.8

where x is the cell where you have ADP stored.

Works a treat!

Thanks to myself for answering my own question...

* I believe you call them "cookies" on your side of "the pond".