View Single Post
Old 12-09-2015, 03:28 PM   #48 (permalink)
ArchmageAU
HF Support
 
Posts: 6,850
Thread Starter Thread Starter
 
My HF Map location
Join Date: Jan 2013
Default

Quote:
Originally Posted by Heliboy31 View Post
Just programming my new DX9 and came across this brilliant thread. Having read all the posts a couple of times I think I now understand the "magic" of Spektrum Tx mixes. So, a big thank you to all the posters here.......but .....being slightly OCD in character I have been using the excel spreadsheet method to help reinforce the learning. Here I ran into a small query on post #34 from ArchmageAU. (extract attached here).
Could I confirm if there are a couple of typos in the line that reads:-

cell B5=IF($A5>0,(($A5-$B$3)/100)*$B$1),(($A5-$B$3)/100)*(-$B$1))

Should it perhaps read:-

cell B5=IF(($A5-$B$3)>0,(($A5-$B$3)/100*$B$1),(($A5-$B$3)/100)*(-$B$2))

I would really appreciate a comment on this as it currently leaves me with an itch which I just can't seem to scratch.
Once again many thanks
H31
Yes, you are correct.

Formula should be as you described.
cell B5=IF(($A5-$B$3)>0,(($A5-$B$3)/100*$B$1),(($A5-$B$3)/100)*(-$B$2))
Thank you for pointing that out. I will ocrrect the original post.

(Hopefully that relieves the itch )
__________________
TRex 700E Pro DFC HV (BD3SX) - Gaui X5 (6S/BD3SX), Blade 130X, RealFlight, Heli-X, Taranis+DSMX
ArchmageAU is offline        Reply With Quote