Excel Scientific and Engineering Cookbook (Cookbooks (OReilly)) - page 195



Index


[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

net present worth, calculating
New Web Queries
Newton's method for solving equations
Newton-Cotes integration formulas
Next statement
nonlinear equations, solving iteratively
nonlinear systems of equations, solving
NORMSINV function
NPER function
NPV function
number systems, conversion between
numerator degrees of freedom
numerical differentiation
numerical integration
     computing the center of an area
     computing the second moment of an area
     double integrals
     integrating a definite integral
     trapezoidal rule
         VBA, implementing in



Index


[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

Object Browser
     Classes list
object-oriented programming
objects
     creating
     members
ODD function
operator precedence
optimization analysis
     engineering design problems
     integer constraints, using
     locally optimal versus globally optimal solutions
     resource allocation optimization
     traditional linear programming
Option Base statement
ordinary differential equations, solving
     boundary value problems
     coupled equations
         Euler's method
         Runge-Kutta method
     first-order initial value problems
     second-order initial value problems
     solution methods



Index


[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

parabolic equations
parentheses ( )
partial differential equations, solving
     finite difference equations
     finite element method
     initial value problems
Paste and Paste Special
PEARSON function
PERCENTILE function
PERCENTRANK function
PI function
PMT function 2nd
pointers
Poisson equation
POWER function
procedural programs
PRODUCT function
product mix problems
properties
Public keyword
PV function 2nd



Index


[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

QUOTIENT function



Index


[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

R1C1-style cell references
Radar charts
     types
RADIANS function
random number generation
random sampling
Range objects
ranges
RANK function
     Spearman rank correlation using
rate of return, estimating
relative references
Rem keyword
required rate of return
resource optimization allocation
return on interest, calculating
Reynolds number
Roman, Steven
roots, finding graphically
ROUND function
Round( )
rounding functions
Runge-Kutta method
     coupled equations, solving
     second-order initial value problems, applying to
     VBA code for nonlinear system