Page 474 - Excel for Scientists and Engineers: Numerical Methods
P. 474
INDEX 45 1
scale factor, in Solver model 326 slow convergence 153
scaling arrays 64 SMALL worksheet function 346
scoping a subroutine 30 Solver Add-In 3 17
secant method 160 Solver Estimates, Derivatives and
second derivative 99, 102, 103, 106 Search 326
of a worksheet formula 12 1 Solver Options 32 1,324
second-order differential equation Solver Parameters dialog box 320,
245,258,263,282 323
Select Case statement 25 Solver perturbation factor 3 16
series Solver Results dialog box 32 1 , 322
alternating 69 Solver Statistics macro 115, 328
convergent 69 Solver
formulas, evaluating 70 Add, Change, Delete 324
power 69 Assume Linear Model 325
sumofa 69 Assume Non-Negative 325
Set Cell box (Goal Seek) 158, 181 By Changing Cell 323
Set keyword 32,43,47 changing cells 3 16, 326
Set Target Cell box 320 constraints 324
Sheets 32 Convergence 325
shooting method 245 discontinuous functions 323
shortcut key, add 15 external references 323
assigning 9 global minimum 324
shortcut keys for VBA 15,387 Guess 324
shortcut to enter a function 13 initial estimates for 323
Show Iteration Results (Solver manual scaling 326
options) 325 Max Time and Iterations 324
simply supported beam 246 Maximum Change 325
Simpson's 1/3 rule 128 objective 3 16,326
Simpson's 3/8 rule 129 Precision and Tolerance 324
Simpson's method 127, 128, 133, Reset All 324
134, 136 Save Model ... and Load Model ...
simulating a normal random 326
distribution 349 scale factor 326
simultaneous differential equations, Show Iteration Results 325
systems of 229 target cell 3 16
simultaneous equations 65 Unable to Find a Solution 323
SimultEqNL custom function 208 Use Automatic Scaling 325
size of an array 44 use of HLOOKUP in models 323
slope 99 use of VLOOKUP in models 323
ofacurve 155 Sort ... 345
least-squares 288 square matrix 57
SLOPE worksheet function 289, 291
