Formulas play an important role within Spaix. Formulas are used for calculations, dynamic names and search keys as well as fort the output of values on data sheets. In some cases it is possible to enter an object name, for example in Additional components.

Subject area:	Data maintenance
Target group:	Project Managers / Data entry personnel at the pump manufacturer
Product:	Spaix Classic/Online + Spaix Database
Version:	2.1 or higher

Reserved characters or signs are those used as operators in formulas (e.g. plus, minus or brackets) or those with a special function such as parentheses.

If the name of the relevant component contains such a reserved sign Spaix would accidentally interpret it as a symbol and part of the formula and generate a false or no result at all.

To work around this problem you encode these special characters: you write down the ASCCII value of the character and place it in between two ‚#’ (pound sign or number sign.). That, however, means that also the pound sign itself has to be encoded.

Example: Access to a pump component

The name	P.NAME[Co,Temperature sensor - RT]
becomes	P.NAME[Co,Temperature sensor #45# RT]

Below you will find a table of some commonly used characters and symbols. The method, of course, works for every character and sign.

Name	Sign	Coded Version
Plus	+	#43#
Minus	-	#45#
Asterisk	*	#42#
Slash	/	#47#
Equal Sign	=	#61#
Pound / Number Sign	#	#35#
Left parenthesis	(	#40#
Right parenthesis	)	#41#
Left brace	{	#123#
Right brace	}	#125#

We hope this information is helpful when working with Spaix. If you have questions on this or other subject matters our expert software support team is here to help you. Simply send an e-mail to: support@vsx.net

About Spaix Inside
Spaix Inside is a series of white papers by developers, members of software support and power users for the efficient use of the Spaix product family to select and configure pumps and to generate quotes.

Spaix® is a product by VSX - VOGEL SOFTWARE GmbH