In the same way that manual taking-off is easier when done on specially organised forms, so computer work is easier if the screen is formatted into forms called worksheets.
Data is Created by inserting on a blank worksheet and this data can be subsequently changed or added to by Editing. Data can be added and/or edited as often as required right up to the time of the preparation of the final Bill.
When entering data on a worksheet you can change the data as often as you like by moving around the worksheet and editing the fields until you are satisfied with the input. No files are created or updated until the <END> key is pressed. If the <ESC> key is pressed instead the worksheet will be Abandoned and any input will be discarded.
worksheets are divided into Records and Fields.
A Record is a batch of data comprising one or more Fields which belong together and jointly describe the Record. An Element item is a Record containing fields for Dimensions, Item Codes, Formulae etc..
A Field is a discrete item of input data. A Wall Length is a Field and so is an Item Code. Each Field comprises a series of characters, the whole of which makes up the particular bit of data concerned.
When entering a Field the cursor will be located at the first character position. Departing from a Field can be performed from any position within the Field.
Each Field on a worksheet is formatted on the screen using NULL characters. These characters appear as UNDERLINE characters but they are not the same. When entries are made on a worksheet the typed characters take the place of the NULL characters.
Spaces are valid characters and are not the same as NULL characters.
UNDERLINES are also valid characters and are also distinct from NULL characters although they look the same on the screen.
To restore a Field to NULL entry (either to correct a mistake, to make a change, or to change the status of an item) the entered text must be either :-
(i) deleted using the <BACKSPACE> command, or
(ii) deleted using the <DELETE> command, or
(iii) deleted using the Delete-to-End-of-Field command <F12>.
The <DELETE> command removes the current character and the <BACKSPACE> command removes the previous character. The <DELETE> command is, therefore, the most convenient when the Cursor is at the beginning of a text string, and the <BACKSPACE> command is the most convenient when the Cursor is at the end of a text string.
The Delete-to-End-of-Field command <F12> will delete all characters from the current Cursor position to the end of the current Field. If there are no characters to the right of the cursor <F12> will place the cursor at the beginning of the field.
To assist with the Creating and Editing of data on the Calculix worksheets the Calculix system uses a number of Commands which tell the computer what to do. The Worksheet Commands are described below.
The following Commands are Executed by pressing the appropriate FUNCTION KEY of the computer keyboard. The labels on the keys vary for different computers. The arrangement for your computer is set out in APPENDIX C at the back of this manual. You should familiarise yourself with the details whilst studying the various worksheets.
The <END> command SAVES the data from the screen and writes it away onto the hard disc and returns you to the menu.
The <ESC> command ABANDONS the screen and does not update the hard disc and returns you to the menu. Therefore the data will be the same as when you Quit entered the worksheet.
The <HOME> command displays information relevant to the field or process you are working on. When the Help current field is a code field the <HOME> command displays a list of all the existing records of that type. If the current field contains a code (or part of a code) the list displayed will start at that record (or the first record found starting from the partial code that was entered).
When entering a date in a date field, the <HOME> key will display a calendar, which allows you to pick the day and the month using arrow keys and automatically enters the date for you when END is pressed.
The <TAB> command displays a list of the functions performed by the FUNCTION KEYS, relevant to the key Functions operators position within the system. The display operates in worksheets and menus and, if more than the six displayed functions are possible, press <TAB> again to display the remaining FUNCTION KEY operations.
The cursor movement commands have been modified to perform in the same way as the popular spreadsheet programs. The OLD commands can still be used by pressing <CTRL> F.
RIGHT ( or RIGHT ARROW ) The <RIGHT> command moves the cursor to the next field on the Right.
The <RIGHT> command moves the cursor one character to the right in the current field. If the cursor is already at the end of the Field the BELL will "beep" and the cursor will stay at the end of the Field.
LEFT ( or LEFT ARROW )The <LEFT> command moves the cursor to the previous field on the left.
The <LEFT> command moves the cursor one character to the Left within the current Field. If the cursor is already at the beginning of the Field the BELL will "beep" and the cursor will remain at the start of the Field.
DOWN ( or DOWN ARROW )The <DOWN> command moves the cursor vertically down to the field below.
The <DOWN> command moves the cursor to the first character of the Next Field. If the cursor is already on the Last Field of the current screen it will jump to the First Field of the screen.
UP ( or UP ARROW )The <UP> command moves the cursor up to the field vertically above.
The <UP> command moves the cursor to the first character of the Previous Field. If the cursor is already on the First Field of the current screen it will jump to the Last Field of the screen.
RETURN The <RETURN> command moves the cursor from the current position to the First character of the First Field of the Next Record. This is normally the beginning of the next line.
The <F9> command moves the cursor to the left in the current field. If the cursor is already at the beginning of the field it will jump to the end of the previous field.
Old command F9
Moves the cursor to the first character of the field below
The <F10> command moves the cursor to the right in the current field. If the cursor is already at the end of the field it will jump to the beginning of the next field.
Old F10 command
The <F10> command moves the cursor to the first character of the Field above
These keys are also useful for moving inside a field. See the section on Editing Commands for more details
The <PAGE DOWN> command SAVES the current screen and displays the Next screenful of data.
The <PAGE UP> command SAVES the current screen and displays the Previous screenful of data.
Send mail to
with questions or comments about this web site.