Clicking on an item from the content will take you to the relevant paragraph.
The structure of the sheets in the workbook was described in the chapter "Control, structure and syntax of calculations". A detailed description of the structure of some sheets (in views of the applicable modifications) and the possible and permissible procedures with their modifications and extensions are given in this chapter.
State after installation of the product.
The formulas (algorithms) of the calculation are entered into the named cells and ranges (more on the named ranges, see MS Excel Help). Entries of algorithms are much better arranged and easier to understand. The formulas then include names of the cells instead of their numbers.
Names of the variables used in the calculation are distinguished by their initial symbols as follows:
Knowledge of MS Excel and the respective engineering problems to an extent adequate to the intended changes is necessary for extension of calculations, their modifications, changes or formatting. When modifying the calculations, pay attention to the following recommendations:
The "Calculation" sheet has rows 1-98, columns A-H and other hidden columns as necessary. The following table shows a layout of the ranges and their meaning.
Displaying the marking of rows and columns is disabled to enlarge the desktop. It can be enabled in the MS Excel menu "Setting -> Options -> Displaying".
Extension of calculation - The calculation can easily be extended by a solution of extreme problems, the addition of various coefficients or indexes (requirements: basic knowledge of MS Excel). Enter the new relations behind the existing calculation into the C range.
Modifications of the existing calculation - it is possible (after unlocking the sheet) to modify the used formulas or coefficients both in C range and D range as well. (requirements: very good knowledge of MS Excel, excellent knowledge of the solved problems).
If the calculation includes material tables, these tables can be found on the "Materials" sheet. In addition to pre-filled material values, it is possible to define new "user materials". A white background on the cells differentiates the range of user materials. If you add your own materials, fill out all values in the units that are given in the headers of the material tables.
The "Tables" sheet, present with most calculations, contains data, coefficients, selection lists and other basic materials necessary for the calculation. A white background on the cells differentiates the ranges that can be changed. All the tables are given headers to provide clear information of what is included inside. Despite this, it is advisable that only experienced users who know very well the problems of the given calculation perform changes in the tables.
The "Dictionary" sheet contains a list of all translated terms. The first row of the sheet includes a list of all languages, beginning with column "G" (Marking columns according to ISO 639-1). If you wish to translate a calculation or its part, enter the corresponding equivalent of the password into the respective column. If no translated term is found in the translation process, the English term will be used automatically.
The "DXF" sheet contains definitions for the creation of 2D drawings and connections to 2D CAD systems. Details can be found in the chapter "Graphic output, CAD systems".
Interconnection on more calculations including your own tables can provide solutions of more complex tasks. MS Excel Help provides information on how to interconnect workbooks. Some recommendations are given below.