The following is a tutorial on ho
from Problem Set 5. See the Exc
Problems 21, 22, and 24.
Make a column of constant nam
the iteration scheme. By doing
Furthermore, you can change t
having to redo the iteration tab
You may also wish to create a s
the inputs so that the units use
conversions in Excel you should
Select the desired cell in the sp
You can use values from other
Figure 1 a formula is being ente
converts the units of B from cm
calculate constants that are fun
equations of state.
Figure 1: Entering a formula in a
Now use Excel to create the iter
below.
Iteration, i
V1(i
1
2
3
4
5
6
7
8
9
10
Iteration Tutorial for Excel
ow to use Excel to create an iteration scheme
cel spreadsheet for completed iteration exam
mes and a corresponding column of constant v
this you will only have to enter the constants
the constants in the list as needed for new pro
ble.
second set of columns where you convert the
ed in your iteration scheme are consistent. For
ld create a formula so that Excel does the calcu
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Winter '10
 SHELL

Click to edit the document details