Functions > Examples

Examples of functions in TILIGO are presented below.

A simple example of the use of a function is:

=Trunc((L-554)/1400+1)

An equivalent may be

Trunc((L-554)/1400+1)

As opposed to MS Excel, in TILIGO it is not necessary to include "=" before a function.

Functions in TILIGO may be very complex. MS Excel allows only 6 levels of brackets. In TILIGO the number of brackets is practically unlimited.

An example of a complex function:

FullBarLength(L;If(A<800;2975;1000);400;1)*FullBarQty(L;If(A<800;2975;1000);400;1)+CutBarLength(L;If(A<800;2975;1000);400;1)*CutBarQty(L;If(A<800;2975;1000);400;1)

An example of a very complex function:

if(and(sz>=1;sz<=10;l<500);0;if(and(sz>=1;sz<=10;l=500);236;if(and(sz>=1;sz<=10;l<=600);238;if(and(sz>=1;sz<=10;l<=700);239;if(and(sz>=1;sz<=10;l<=800);241;if(and(sz>=1;sz<=10;l<=900);243;if(and(sz>=1;sz<=10;l<=1000);245;if(and(sz>=1;sz<=10;l<=1100);247;if(and(sz>=1;sz<=10;l<=1200);248;if(and(sz>=1;sz<=10;l<=1300);249;if(and(sz>=1;sz<=10;l<=1400);252;if(and(sz>=1;sz<=10;l<=1500);254;if(and(sz>=11;sz<=50;l<500);0;if(and(sz>=11;sz<=50;l=500);227;if(and(sz>=11;sz<=50;l<=600);228;if(and(sz>=11;sz<=50;l<=700);230;if(and(sz>=11;sz<=50;l<=800);232;if(and(sz>=11;sz<=50;l<=900);234;if(and(sz>=11;sz<=50;l<=1000);235;if(and(sz>=11;sz<=50;l<=1100);237;if(and(sz>=11;sz<=50;l<=1200);239;if(and(sz>=11;sz<=50;l<=1300);239;if(and(sz>=11;sz<=50;l<=1400);242;if(and(sz>=11;sz<=50;l<=1500);244;if(and(sz>=51;sz<=100;l<500);0;if(and(sz>=51;sz<=100;l=500);218;if(and(sz>=51;sz<=100;l<=600);220;if(and(sz>=51;sz<=100;l<=700);222;if(and(sz>=51;sz<=100;l<=800);223;if(and(sz>=51;sz<=100;l<=900);225;if(and(sz>=51;sz<=100;l<=1000);226;if(and(sz>=51;sz<=100;l<=1100);228;if(and(sz>=51;sz<=100;l<=1200);230;if(and(sz>=51;sz<=100;l<=1300);230;if(and(sz>=51;sz<=100;l<=1400);233;if(and(sz>=51;sz<=100;l<=1500);235;if(and(sz>100;l<500);0;if(and(sz>100;l=500);210;if(and(sz>100;l<=600);212;if(and(sz>100;l<=700);214;if(and(sz>100;l<=800);215;if(and(sz>100;l<=900);217;if(and(sz>100;l<=1000);218;if(and(sz>100;l<=1100);220;if(and(sz>100;l<=1200);221;if(and(sz>100;l<=1300);222;if(and(sz>100;l<=1400);225;if(and(sz>100;l<=1500);226;0))))))))))))))))))))))))))))))))))))))))))))))))

As tests have shown, the use of an abundance of very complex functions does not reduce the efficiency of TILIGO in any discernible way.