Hi Hank,
What kind of math did you use for your excel graph? Wondering if we can get close to that without a lookup.
Hi Hank,
What kind of math did you use for your excel graph? Wondering if we can get close to that without a lookup.
http://www.scalerobotics.com
It wasn't that slick...nor scientific - basically I was after an anti log type of slope...now when it comes to maths & trig, I'm an epic fail - the only excel function I could get to work was Excel's 'log' (I'm not particularly familiar with excel either!), so I simply dragged down the rows to 512 - applied the log formula (log (A1,512) ...which gave me all the log values ....I then inverted the result in Excel (there's got to be a better way, but I work with the tool & knowledge constraints I have - I don't have time each time I hit a problem to park up & learn how to do it the right way!)
So basically it's an anti log.....but I'd imagine doing the calculation in in PBP, would be like having your kneecaps drilled, then filled with salt & vinegar.
Bookmarks