xlCurves adds 100+ custom functions to Microsoft Excel

xlCurves adds 100+ custom functions to Microsoft Excel

The xlCurves functions are designed specifically to compute the non-compartmental parameters associated with the area under a given curve.

The xlCurves computation algorithms are well researched, designed, implemented, and tested.

The xlCurves functions allow for fast computation that is otherwise time-consuming, tedious, and error-prone, if not difficult / impossible.

Each xlCurves function has extensive custom data quality checking built in.

xlCurves integrates seamlessly into Microsoft Excel

xlCurves integrates seamlessly into Microsoft Excel

There is no Link Not Found message when the workbook, containing the xlCurves functions, saved in one computer is open in another.

The xlCurves functions are organized into seven logical custom categories in Insert Function wizard:

(The xlCurves categories)

Description of what the xlCurves function computes, when the function is selected, in the Insert Function wizard:

(SP.YVAL returns the superpositioned dependent value to an independent value of the curve)

A succinct description of the argument, when the argument is on focus, in Function Arguments wizard:

(X’s array takes a set of known independent values that defines the curve)

Help is available on each xlCurves function by clicking the Help on this function link in Insert Function wizard / Function Arguments wizard:

(Help on SP.YVAL function)

Options to selectively include / exclude x-y data pairs

Options to selectively include / exclude x-y data pairs

Each function has two extra optional arguments, Exclude’s? and Match?, at the end of the argument list:

(STD.HALFLIFE function with Exclude’s? and Match? arguments)

Where appropriate the function also has Include’s and Match? version:

(STD.HALFLIFE function with Include’s and Match? arguments)

The Match? value is optional, when utilized it augments the Exclude’s? / Include’s array.

The auto-exclude option is also available for functions with Exclude’s? and Match? arguments.

The alert and informative messages

The alert and informative messages

A targeted alert message is displayed if the computation could not proceed:

(The lamda z value is not valid)

Useful informative messages are displayed when appropriate:

(This dialog box displays not one, but two messages)