Table 1. Predefined Excel range and constant names to specify input for and output from CXTFIT/Excel Macros

Name	Description
ObjFuncCell	Cell for objective function
ParameterRange	Range for parameters to be estimated
PredictionRange	Range of predictions corresponding to observations, and/or the Jacobian, error propagation to be calculated
OffsetParaStd	Offset from ParameterRange for input of standard deviations for estimated parameters
OffsetParaPtb	Offset from the ParameterRange for input of user specified peturbations for derivative calculation, not used if not defined or zero
NoParaConstraint	No constraint to be imposed on the estimated parameters if defined. Otherwise, the values in the two columns next to ParameterRange are used as lower and upper constraints for parameter estimation.
OffsetPredStd	Offset from PredictionRange for input of the standard deviation of the observations
OffsetPredJcb	Offset from PredictionRange for output of Jacobian matrix
OffsetPredEP	Offset from PredictionRange for output of parameter uncertainty propagation
PenaltyCell	Cell for relative penalty, default value 1 if not defined
MCMeritCell	Cell for merit function or error measure for Monte Carlo analysis
MCParaInputRange	Range of user input random values for parameters
MCCurrentCell	Cell to show index of current set of parameters for which model prediction is running
SolveUserFinish	If defined, the results dialog for solver will not pop up
RSMeritCell	Cell for the merit function for response surface calculation
RSVRange	A continuous range in a column for response surface calculation
RSHRange	A continuous range in a row for response surface calculation

Back to Tutorial Home Page