The purpose of this procedure is to:
The procedure also includes checking the formulas through simulation.
Before you can begin to create a formula, the following prerequisites must be met:
Follow the steps below to create a formula.
Select program 'Formula. Open' (CRS570). Include panels E and 1 in your panel sequence.
Create a formula.
Fill in or change the information in the formula header in panel E. Specify the search hierarchy to be used, since this simplifies creating formula lines. The hierarchy has a certain effect on response times, but is most important when there are features, drawing measurements or projects with the same ID. Program 'Formula. Open' (CRS575) is now opened. If program CRS575 is run for the first time, options should be set using F13=Parameters.
Enter the formula lines using Related Option 11. If a calculation has more than two factors, continue to the next line without entering a result. If a calculation should be made and different formulas used depending on the value of a factor, then Boolean algebra (IF, OR, AND, ELSE and END) can be used. The sequence number regulates the order of the calculations. If it is left blank, it is set automatically according to the range specified in the panel reached using F13=Parameters. The same applies for the factor type, which is set according to the hierarchy selected in the formula header. A formula can have several results, so similar calculations can be combined in one formula. This can be useful when subtotals in one calculation should be reused in another calculation, since results cannot be obtained from other formulas.
A brief textual note for each formula can be entered in the detail panel. In this panel, processing of negative values which are normally only entered in the formula header can be overriden.
Simulate the formula using program 'Formula. Simulate' (CRS576). To call this program, press F15=Simulation. Enter the values and perform the simulation. Sorting order 2 in program CRS576 offers more of an overview, while sorting order 1 allows you to follow the calculation step by step.
A formula is created when using this procedure. It can be manipulated using simulations, and can be used to calculate sales price, material consumption, run time for an operation and various measurements.
In the example below, several calculations are to be performed.
Width - 40 = Wid01 (Answer should be rounded upwards to one decimal place)
Wid01- 1 = Wid02
Depth - 34 = Dep01
Width * Depth * (Height /1000) = Price if width > 100, otherwise price = 10000
In these calculations, Width, Depth and Height are features. To perform the following calculations, a formula can be created as outlined below.
Sno |
Boo |
Op |
Par |
Ftp |
Factor 1 |
Par |
Op |
Par |
Ftp |
Factor 2 |
Par |
Res |
Neg |
Rnd |
Rul |
10 |
3 |
WIDTH |
- |
1 |
40 |
WID01 |
1,0 |
+ |
|||||||
20 |
3 |
WID01 |
- |
1 |
1 |
WID02 |
|||||||||
110 |
3 |
DEPTH |
- |
1 |
34 |
DEP01 |
|||||||||
180 |
IF |
3 |
WIDTH |
> |
1 |
100 |
|||||||||
190 |
DO |
3 |
WIDTH |
* |
3 |
DEPTH |
|||||||||
200 |
DO |
* |
( |
3 |
HEIGHT |
/ |
1 |
1000 |
) |
PRICE |
|||||
210 |
EL |
1 |
10000 |
PRICE |
|||||||||||
220 |
EN |