question for math wizards

[Acetronics2]

Acetronics,

Yes, its not me its Excel !!

Are you really sure your Math is good ???

I'm not ...

for counts = 0 to 10000
knots = ((SQR(counts*100))*1563)/10000
knotsRem = (SQR(counts*100)*1563)//10000

1) due to your ADC ... "Counts" granularity is 1/1024 or 1/4096 ( let's dream ) ... just a detail ... but important.

2) knots = ((SQR(counts*100))*1563)/10000 = SQR ( counts ) * 1563 / 1000 ... YESSS, no need to multiply "Counts", as granularity will remain the same ... !!!

3) you can't use the remainder trick ... as it is a SQUARE function ... remember SQR ( A ) + SQR ( B ) != SQR ( A+B )

Ok, I don't have the easy solution at the time ... but' Im on the way !!!

Alain