Calculation table - Calculations

  When using the program, clicking on this icon opens the calculation table. We encounter this icon both in setting the basic elements and editing the size system.

Here, a system consisting of up to 20 rows of mathematical and logical operations and dependencies can be edited, resulting in a single final value, the desired calculated value.

• Each row can contain a maximum of 5 data elements with up to 4 mathematical or logical operations between them, or it can monitor a switch position.
  
  
• Each row has a letter symbol and a result. The result of the last row is the final result (yellow field).
  
  
• References to the results of previous rows are possible within each row, using the symbol of the respective row.
  
  
• Operations are always executed from top to bottom, so you can only refer to the row directly above within a given row.
  
  
• The last row does not have a symbol. This row cannot be used as a switch either.
  
  
• Within a row, operations always proceed from left to right.

IMPORTANT! Disregard standard mathematical priorities. For example, 3 + 2 × 2 = 10 and not 7. If multiplication should precede addition, it must be entered in two separate rows.

Input data

Clicking on any of the data fields opens a data entry window below or above for lower rows.

You can choose from 12 data types and then enter the desired value into the lower input field. To facilitate this, especially when entering indexes, you can choose from lists.

Material link

• When selecting a material in the left-hand list, the materials entered into the program appear, with a triple choice underneath.
  
  
  • In the upper list are the material groups, and below them are the materials belonging to each group.
    
    
  • First, select the material group containing the material.
    
    
• Clicking on a material automatically inserts its index, and the data field value becomes the size of the material.
  
  
• Since each material has 3 sizes (see Basic components page), you need to select which of these under the left list.
  
  
  
  
• Pressing the OK button hides the input window, the data field turns white, and the selected data appears on it.

Appearance of a material link.

• The letter "a" indicates a material link, and within parentheses is the index of the chosen material.
  
  
• If the 2nd or 3rd size of the material is selected, the index is followed within parentheses by the number 2 or 3 separated by a comma.
  
  
• Hovering the cursor over the field displays an explanatory text (Tooltip) with the name of the selected material and its three sizes.
  
  

Size link

Here, the values ​​of the size system appear in the left-hand list. Clicking on these also writes the index of the respective size.

Appearance of a size link.

• The letter "m" indicates a size link, and within parentheses is the index of the selected size.
  
  
• As a Tooltip, the name of the size and its current value appear.

Variable

(A-S) This allows referencing the result of any previous row. You can either directly enter it or click on the symbol of the chosen row.

  The uppercase character appears in the data field in this case.

Number

  Any arbitrary number can be entered, and it also appears in the data field.

Pi

  The value of Pi (3.14...).

Non needed

  If this data is included in the final result, then the respective element will not appear on the drawing or production lists.

Before or after dividing

  Dimensions before or after X or Y dividers.

The    icons next to the input field allow you to increase or decrease the numerical value inside.

Selecting material link	Selecting size link

Entering operations

Operations can be entered into the narrower fields between data fields. Clicking on the field displays a list of operation symbols to choose from, including mathematical and logical operations, trigonometric functions.

+ - × / - basic operations, addition, subtraction, multiplication, division
\ - division without remainder
mod - remainder after division
^ - exponentiation
sqrt - square root
sin, cos, tg - trigonometric functions
Asin, Acos, Atg - arcus sinus…. (reverse functions of the above functions)
int - omission of decimal values
== - logical equality
<, <=, >, >= - less than, less than or equal, greater than, greater than or equal
<> - not equal

Below the table, you will find reminders of a few mathematical relationships.

Interpreting rows

Each row can be used in 3 different modes.

Mathematical operations

Operations proceed from left to right and do not follow standard priorities. There must be an operation between each data. If one is missing, calculations cease.

Always start with the first data, unless the row starts with a function such as "sinus A". In this case, take the data (A) to the 2nd position and place the function (sin) in front. Therefore, the first field will be empty.

Switches

Switches can be set in blue fields. Clicking on these allows selection from switches in the left-hand list.

• A switch can have a maximum of 5 positions, corresponding to 5 data in the respective row.
  
  
• The result of the row is determined by the position of the switch.
  
  
• Interpretation of the above line: 
  • If switch 3 (rear wall solution) is set to position 1, the result of the row will be the result of row A,
    
    
  • if it goes to position 2, then G,
    
    
  • if in position 3, then value NO.
    
    
• In the blue field, in parentheses, you can see the current state of the 3rd switch from the 1st. In this case, no operations need to be entered between the data.
  
  
• In the top left corner, you can test the set switch after selecting how it affects the final result in the table, for example.
  
  

Logical choice

• If a logical symbol (> < = etc.) is placed between the first and second data, then the result of the row depends on whether the logical relationship is true or false.
  
  
• If true, the result will be the 3rd data; if false, then the 4th. Interpreting the above row:
  
  
  • If the result of row G is less than or equal to the result of row B, then the result will be 0, otherwise it will be the 1st index material's 1st size (left material thickness).
    
    
• Here too, no operation symbols need to be entered between the 2nd, 3rd, and 4th data.
  
  

General

• Values in cells can be deleted with the right mouse button.
  
  
• A reminder text can be written for each row.
  
  
• By right-clicking on the symbols of rows (A=, B=, C= etc.), if there is any data in the row, the respective row moves down by one with all those below it.
  
  
  • If there is no data in the selected row, those below move up by one.
    
    
  • Changes in rows are also tracked in references.
    
    
• The entire table can be cleared with the icon 0.
  
  
• Using the negative switch reverses the sign of the final result.
  
  
• Results are rounded to 1 decimal place.
  
  
• The complete table can be copied using the    buttons in the upper right corner of the window and pasted elsewhere.
  
  

Keywords: #calculation table #calculations #material link #size link #logical choice