Formula Hits: 1514
A Formula is a calculation of a certain Value which can be defined by the User himself. Within Profit-Alura Formulas can be used in various places.

 

Formula Conversion Actual Contents>Unit

 

With the phenomanon Conversion Feature>Stock-Unit is meant the Formula which is used to convert the Values of the individual (Dynamic Features) to a representing quantity Stock-Unit. The Formula consists of one Line which is to be determined freely and in which the Feature Values are used as argument.

 

For example, if as an Item's Features Length, Width and Thickness have been determined, the conversion to the Stock-Unit (M3) will normally take place according to the Formula Length x Width x Thickness; Literally the Formula will look like L*W*T.

 

If fact all possible calculations are possible;

If it is wanted for example that only 50% of the Width is to be included in the calculations for the number of M3, the Formula will look like L*(W/2)*T.

 

The result must always be numerical and will be projected on the Actual Contents.

 

Note that in addition to the 3 possible Value and Non Value Bound Features also the Product -to be calculated through the Formula- of the Features is important, namely the Actual Contents.

The Actual Contents may in fact be seen as a separate Feature as it in some cases can count apart from the "actual" Features as Selection Criterion.

 

For example : The Demand for Isolation Material could be in numbers M3, with which it is stated that the Length, Width and Thickness is not important (stuffing Wall). This, whereas the Isolation Material is indeed on Stock in Length, Width and Thickness.

 

Anyway, the Formula allows it to for example express a Quantity of M3 which has been "dumped" as a derivative of the actual Quantity of M3 (for example Pieces of Wood).

 

In theory it is possible to execute through the Formula (f.e.) Dynamic Volume Calculations which are depending on the external Variables such as Temperature, Atmospheric Humidity, etc.; These external Variables will not be offered by Profit at this moment, however, creating such can be done in a couple of hours.

 

To be clear: By for example adjusting such a Variable daily, all concerning Stock Items will be adjusted implicitely; thus adjusting the Temperature Variable will implicitely have the Stock

Volume increase.

 

Note in this respect that the Actual Cost Price is related to the Actual Contents (= the Result of the Formula) and that the Value of the concerning Stock Items thus is adjusted implicitely too.

 

The Formula Production Order, which can be found with the Recipe Lines can be used to define a Formula with which complex Calculations in Recipes can be executed.

 

The Actual Contents of a Recipe Line can be depending on certain quantities of other Recipe Lines. An example: the Time needed the pack a number of Profiles depends on the number of Appearances, whereas the duration of a certain Preliminary Treatment could be depending on the total Surface of the Profiles.

 

A Recipe Line can also be depending on a Feature of an Item at a Higher Situated Recipe Line.

 

An example: the quantity of Paint which is needed to paint a Door is depending on the Surface of the Door but also of the Type of Wood which is used (one Type of Wood "absorbs" more than the other one), where the Wood could have a Feature which determines the quantity of Paint per M2 (the "Absorbing Factor").

 

To be able to use certain numercial data in Formulas to be defined by oneself, the following syntax is to be used:

 

xx->yyy where xx is the requested Value

yyy is the Line Number

Examples:

 

L->100 refers to the Feature L of the Item on Line 100.

B->250 refers to the Feature B of the Item on Line 250.

 

As already shown above it must also be possible to retrieve the Actual Contents, the number of Units and the number

of Appearances of a Recipe Line. There are three "commands" to do so:

 

 

WI->yyy results in the Actual Contents

AE->yyy the number of Units

and AV->yyy the number of Appearances of Line yyy.

 

Another Example:

 

 

 

2*SQRT(AE->200*WI->250) : Twice the Root of the number of Units on Line 200 times the Actual Contents of Line 250.

 

Attention: on a Recipe Line one can only refer to Lines with a Lower Line Number than the 'own' Line Number.

 

One can also use the Mathmetical Functions which are standard present in Foxpro such as EXP, SQRT etc.


CategoryKeywords, CategoryLogistics