Bent Tram A/S
Mechanical Testing Solutions

Spreadsheet

A spreadsheet shows the data in a set. The display of the spreadsheet is divided into areas of data for the set. There may be various layouts (number of columns, widths, headings) for each spreadsheet. If there is more than one template variant for the type, there will be corresponding layouts of the spreadsheet for the set in question.

The entire spreadsheet is displayed in a layout with five sections - headers, specimen headers, specimens, statistics and footer. At the top is a header with description of the set and type. The middle section is the specimen area, divided into specimen headers, specimens and statistics. The spcimen headers contains the headers for each column. Each line in the specimen area represents a specimen for testing. The specimen area may be scrolled horizontally and vertically. The statistics area contain rows with general statistical data, e.g. average, standard deviation and comments. These lines are always shown, and they are scrolled horizontally along with the specimen area. At the bottom of the spreadsheet, the footer section contains cells with data common to set (like in the headers section).

You may edit the value of the cells in some columns in the specimen area. By double clicking on the cell, a small window is displayed for entering a new value. If you double click a cell that is protected, a message will appear telling you this.

When entering numerical data in a cell, You must use your local decimal separator, i.e. comma or period as the decimal character.

In the spreadsheet a "cursor" is shown that highlights the active cell. This cursor can be moved around using the arrow keys on your keyboard. To edit the active cell, press Enter. It is usually much faster to navigate around the spreadsheet with the keyboard, once you get used to it.

Norm values might have been defined for certain data in the spreadsheet. Norm values represent the allowed range. If a number in the spreadsheet is outside the norm it will be emphasised with a bold red font (depending on the template). This is also shown in printouts of the spreadsheet.

File menu

Edit menu

Show menu

Test menu

Current template

The current template menu is used to change the template used to view the set. The menu contains the associated templates availeble to use with the type of the current set. The template currently used to display the set is marked with a sign.

Language

The language menu is used to change the language used inside the spreadsheet. The manu contains the available languages. The currently used language is grayed out.

See also: