base wave

y is the vertical position of the wave at a point x. x is the horizontal position of the wave. y is a function of x: as x changes, y changes. the formula y=A*sin(wx)+d calculates the vertical position of the wave at a horizontal point x. A is the wave amplitude. Here, it's 1. I want zero to be the wave bottoms. When d=0, the wave oscillates around the zero y line. Setting d to .5 causes the wave to oscillate around the y=.5 line. Since the wave has amplitude 1, this places wave bottoms at 0 and wave tops at 1.

next wave post
I'm charting 100 units along x. I want the wave to oscillate no more than twice across the chart, so I want to set w, wave length, to 50. I have to correct that in the formula. Then I'll paste the formula into cells B2 to B99. This will put the value for y for the corresponding value in the A column into each B column cell. We'll see what happens.