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
Format menu
formatting
     custom styles, defining
         style drop-down lists
     spreadsheets
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
     add-in worksheet functions, creating
     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
     linear fits with spreadsheet functions
     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
Gaussian quadratures
GCD function
Generalized Reduced Gradient optimization algorithm
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