View Single Post
  #1  
Old 03-02-2011, 06:12 PM
kinetic's Avatar
kinetic (Steve)
ATMer and Saganist

kinetic is offline
 
Join Date: Jun 2008
Location: Adelaide S.A.
Posts: 2,293
MS Excel question

Hi ,

I wonder if anyone familiar with Excel could help me because I can't
find anything in Tutorials or helpfiles that explains what I want to do.
I want a column of numbers to all be adjusted with a 'bias' so that
when displayed with the chart wizard, they all reference above and below
a flat line which is zero.
I know this is simply using the function feature but I can't tweak it
to do what I want. I'm >|---|< this close to working it out myself but
I'm doing my head in!

To draw a mental picture, imagine the numbers when drawn as a chart
show a sine wave but the sine wave goes 'uphill' or 'downhill'
I want to adjust all of the numbers so the sinewave just goes 'flatline'
left to right.

For the periodic error experts...it is a PE file but tracking the sky at
the wrong rate...too slow is uphill, too fast is downhill.

thanks in advance,
Steve
Reply With Quote