2.6.1 Adding up Calculation Lines

The results of a number of calculation lines are added via Calculate - Sum of calculated lines - Create. Information about the format and unit of measurement is gathered from the table's last calculation line. Nesting of several additions is unfeasible. 

The result can be assigned a variable. The text previous to the table result is automatically queried and can be freely selected. This variable may be modified at all times (see below). 

If calculation lines in the table are deleted or modified or lines are copied into the table, the result is automatically adjusted. All calculations depending on the result are updated. 

Important: The tables are provided with beginning and end marks (display with CTRL+M). This bracketing must be marked, while copying, deleting and cutting.


Generating a summation
  1. With the mouse: Mark the lines and call up the Sum of calculated lines function in the context menu (right mouse key).
  2. Via the keyboard: Call up the Calculate - Sum of calculated lines - Create function. A blank line must be inserted prior to the first and last calculation line for correctly allocating the table when using F12.
Modifying a summation
  1. Clear result: Click on the result and call up  Clear Result in the context menu.
  2. Changing text or variable:
  3. One of the simplest methods is clicking on the result and calling up the Text before result function in the context menu.








Calculate-Sum of calculated lines-Create






Calculate-Sum of calculated lines-Clear






Calculate-Sum of calculated lines-Text before result

Result single-lined/right

This feature has been realized mainly for the reason to right-justify special values and to visually adopt the look of a summation (see Example 1). 

The line is blocked after an entry, but can be re-activated or modified by using the context menu with Modify calculation line or with ALT+ENTER.




Calculate-Result single-lined/right

2.6.2 Calculate - Table Functions

The Main Principle

The addition of calculation lines mentioned above is often sufficient for simple calculations. 

However the classic tabular form is often more space-saving and more clearly arranged. We never intended to develop a new spreadsheet program. The goal was to provide an efficient tool for supporting the compilation of cross-section values, stresses and strains in tabular form. Additionally such tables are implemented into the existing calculation concept, so the results can be used for further calculations. 

A marker is set in a table. This defines the number of decimal places for the result and the alignment of columns. (see figure). 

Specifications for the calculating component can be entered in lines and columns behind or below this marker. This defines variables and formulae. Formulae start with a "=" (see below). 

Example 1

Example 2


Calculate-Arithmetic Table - Define

Example of Arithmetic Expressions

: The arithmetic expressions can be suppressed on a printout. All values can be changed via keyboard or by double-click.

Unlike classic spreadsheets, in VCmaster a formula applies to a complete table row or column. Any specifications and formulae can be entered in the table cells to the right of or below the mark. These may even contain variables of the calculating component. For more details, see the variables D and E in the example.

The instructions may sound a bit complicated, however the procedure is simpler and quicker as with conventional spreadsheets since a definition of a formula for each cell is not required. After one or two test runs, the input becomes intuitive. 

Sum, minimum and maximum of lines and columns

Results of the arithmetic tables can be added line by line or column by column or the minimums or maximums can be determined. These totals can be used for further calculation. This requires a marker in the corresponding cell: 


Calculate-Arithmetic Table - Sum of lines


Calculate-Arithmetic Table - Sum of column

Additional information on design

Headings and units of measurement are usually specified before the expression. If the expressions are hidden, it is sensible to specify headings explicitly. For simple cases it is sufficient if the expression is used as a heading. Please note that either all arithmetic expressions or no arithmetic expressions within a document are hidden. Therefore it is recommended not to mix different practices. 

The lines are drawn with the Frame and Shading function (see on the right). The function can be called up via the context menu. 


Table-Frame and Shading
Alternatively the toolbox is available.

2.6.3 Integrating spreadsheet programs

Tables that have been created with other programs can be integrated using OLE technology. The precondition is that the program is OLE-compatible which is normally the case with standard software.

Example: Displaying an EXCEL* calculation (right) in VCmaster (left):

Additional notes on the OLE interface are given in the Chapter "OLE interface"
*EXCEL is a registered trademark of Microsoft Inc.