Summary of formula available
Product dimensions
X product width
Y product height
Z product depth
Part dimensions
X part length
Y part width
Z part thickness
Basic Maths operations
+ add
- subtract
* multiply
/ divide
Maths Functions
F(23-1/2) fractional inches
SQRT(X/2+12) square root
(Z-12)^2 square
INT() - Integer part of float
MOD() - Fractional part of float
ABS() - Absolute value (changes negative to positive)
PI 3.141592 (value of PI)
CEIL() - Rounds up to the next ceiling value
RND(number, decimal places) - Round a number
Trigonometric functions
SIN() - sine
COS() - cosine
TAN() - tan
ASIN() - arc sine (inverse)
ACOS() - arc cosine
ATAN() - arc tan
Conditions and tests
(X>400) conditional statements
> greater than
< less than
= equal to
>= greater than or equal to
<= less than or equal to
<> not equal to
!: does not contain
-> starts with
<- ends with
IF(condition,true value, false value) - If the given condition is true return true value if not return the false value
AND - both items are true
OR - Either item true
Material thickness
T(MFC18) material thickness
TEDGE(TEAKTAPE) edge thickness
Variables
@BACK@+2.0
@SHELFMATERIAL@
Formula table
XBORE: X start for shelf holes: (X-18)+3
YBORE: Y start for shelf holes: (Y-24)+6
xStart &XBORE&
yStart &YBORE&
String Functions
+ add strings together
CELL(table name,row name, column name) - Retrieve a value from a user defined table
INSTR(string, search string) - Find the first instance of the search string within another string searching from left and return position
LEN(string)- Return the length of a string
LEFT(string, number of characters) - Return the leftmost characters of a string up to and including the number given.
MID(string, start position, number of characters) - Return a string from the given start position with a length up to that given.
REPLACE(initial string, search string, replace string) - Find a string and replace with another string.
RIGHT(string, number of characters)- Return the rightmost characters of a string up to and including the number given.
RINSTR(string, search string) - Find first instance of the search string within another string searching from right and return position.
TOLOWER(string) - Convert string to lower case.
TOUPPER(string) - Convert string to upper case.
