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

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]

F-test
F2 shortcut key
fifth-order formula
Filip.txt
Filippelli, A.
financial calculations
break-even point on investment, calculating
cash flow alternatives
future value, calculating
inverse problems
monthly payments on debt
net present worth, calculating
rate of return, estimating
required rate of return
return on interest
target value, calculating investment required
financial functions
finite difference method
finite element method (FEM)
Fisher, R. A.
fixed-width data
For Each loops
For loops versus Do loops
For Next loops
FORECAST function and time series analysis
forecasting
Format Axis dialog box
Format Cells dialog box
Format Data Series dialog box
formatting
custom styles, defining
style drop-down lists
formulas
cell references
cells, entering into
exponents
mathematical operators used in
operator precedence
Fourier transforms
FREQUENCY function
FTEST function
Function Arguments dialog box
Function keyword
functions 2nd
arguments
built-in financial formulas
built-in functions
lookup functions
derivative of a function
documentation
Excel functions versus VBA functions
FV function
Insert Function button
IRR function
NPER function
NPV function
PMT function 2nd
PV function 2nd
SUM function
future value, calculating
FV function
Fylstra, Daniel

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]

Galerkin method
Gauss-Seidel iteration
GCD function
genes
genetic algorithm
chromosome class, creating
chromosomes and genes
Class_Initialize method
Copy method
EvaluateFitness subroutine
EvaluateZ method
Evolve button
event handler
genetic material
genetic optimization
global variables
Mate method
Mutate method
MutationRate property
SelectChromosome function
global scope
Goal Seek
inverse solutions to financial calculations
nonlinear equations, automating solutions with VBA
nonlinear equations, solving iteratively