So, taking the above data, I compared Speed vs Range and it's effects on the score per 5 minutes for the Seahorse Platform. I will also do Triton and Remora, but I won't do Gator and Shark. Gator is either in the zone or not, and Shark's ranges depend on which way your pointing so it won't be accurate.
And while some may find this chart very intuitive, and ask why we even need it, I did it just to do it. Some may find it useful as It helps them visual the scoring 'bubble' each platform can operate in.
And to be honest, it was kinda fun, trying to work out the following formula was interesting. This had to go in each cell you see:
Quote:
|
=IF(CP$2<=$B$33; IF($A14 <= $B$32;1500-(30/(($B$29/$A14)^2)); IF($A14 <=$B$30 ; 500-(30/(($B$29/$A14)^2)); -30/(($B$29/$A14)^2) ));IF(CP$2 <=$B$31;IF($A14 <= $B$30 ; 500-(30/(($B$29/$A14)^2)); -30/(($B$29/$A14)^2) );-30/(($B$29/$A14)^2)))
|
So for seahorse we get:
Each box is 50 yds, upto 7500 yds out. Sorry bout the hash marks, but when you shrink a number to less than it can show, you get a #, hence why it looks darkened.
Please comment on these, if anybody wants, I can email them the spreadsheet I've been playing with so they can mess around with my numbers.