View Single Post
Old 04-08-11, 12:50 AM   #18
Gargamel
Lucky Sailor
 
Join Date: Oct 2010
Location: Rome
Posts: 4,273
Downloads: 81
Uploads: 0
Default

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.
__________________
Luck is a residue of Design.



Last edited by Gargamel; 04-08-11 at 01:20 AM. Reason: Removed all the FUBAR'd stuff, I'll have the other charts up tommorow.
Gargamel is offline   Reply With Quote