The idea is to create an animation of the equation y = A cos(omega t - k x)
We will be installing a scroll bar (slider) whose
'Linked Cell' will be G1 (instructions are below)
This is the cell where the integer value of of the slider will be located
The slider will drive the animation by incrementing and increasing the time
The time itself in cell B3 will be created from delta_t and the slider integer in G1
We will need the quantities listed below.
First type the labels in cells A2..A9.
(The first one is delta_t, typed in cell A2, then time, typed in cell A3, etc.)
Naming the cells B2 through B9
Then click on cell B2 and go to Insert/Name/Define, and click OK. [This takes the name from what is typed in A2.]
This Names the cell B2 as 'delta_t'. Then it can be referred to by other cells.
Insert the Names for the other cells B3..B9 [ Be careful not to put the Names in cells A3..A9 ! ]
This means you select cell B3 and do the same Insert/Name/Define, and click OK,
all the way down to selecting cell B9, and doing Insert/Name/Define, and click OK.
Then enter the contents of cells B2..B9 as indicated below in
the righthand column.
This begins with entering 0.001 in cell B2, then entering '=G1*delta_t' in cell B3, etc.
In cells A12..A112 we want the x-values:
In cell A12 enter 0
In cell A13 enter =A12+0.01
Copy cell A13 down to A112. [A112 should then have a value of 1]
In cells B12..B112 we want the y(x,t) values:
In cell B12 enter =A*cos(omega*time-k*A12)
Copy cell B12down to B112.
To insert the slider (scroll bar) go to View/Toolbars and click Control Toolbox.
Now click on the scroll bar triangle at the right and see the time increment
by delta_t each time
The graph should move a little when you do this.
Click in the gray area to the right of the scroll button and see the time increase by 10 delta_t each time
The graph should move more when you do this.
Drag the slider button and watch the graph change. Drag it back to zero to re-start.