Excel Client:ElemSelect

ElemSelect(Dimension, Element)

A cell containing a formula of this kind serves as a filter cell in the CoPlanner Excel Client. By double-clicking on this cell, you can open a dialogue that displays the dimension as a tree (see Editing a Filter). The desired element can be selected from the tree. If the element is not present for any reason, a value of “E.n.F.” is returned (see Constants and Return Values).

Parameter

Dimension	The name of the dimension.
Element	The selected element.

Example

Function	Result
ElemSelect(„Produkte“;„Rennräder“)	Rennräder

The function can be expanded to offer the option of creating a plan selector. To do so, please use “Plan” as your dimension name. When you subsequently double-click on the cell containing the function, the plan selector will be displayed. If a plan is not (or no longer) present in the model, the function will return a value of “P.n.F.” (See Constants and Return Values).

Example

Function	Result
ElemSelect(„Plan“;„Budget 2006“)	„Budget 2006“