FREEWARE DOWNLOADS

Worksheets

Introduction
Worksheets
Editing Commands
Running Calculix
Autocode
Autotrad
Abstract
Elements
Formulae Functions & Operators
Creating New Elements
Room Data
Vertical Data
Pipelines
Element Schedules
Worked-Up Data
Descriptions
Validation
General Bill Data
Site Layout
Formatting
Processing
Pricing
Valuations
Printing
File Maintenance
Master Libraries
Filing Utilities

 

Worksheets

  1. Worksheets Generally
  2. Worksheet Records and Fields
  3. Worksheet Records
  4. Worksheet Fields
  5. Worksheet NULL or Blank data
  6. Restore a Field to NULL entry (F12 command)
  7. Worksheet Commands
  8. End - Command
  9. ESC command
  10. HOME (HELP) command
  11. TAB command
  12. Cursor Movement Commands
  13. Worksheet Movement between fields
  14. Worksheet Movement within fields -F9
  15. Worksheet Movement within fields -F10
  16. Worksheet Movement within fields -Insert, delete, backspace, f12
  17. Movement from screen to screen -Page down <next scrn>
  18. Movement from screen to screen -Page up <prev scrn>

 

Worksheets Generally

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.

 

Back to Top

Worksheet Records and Fields

The  worksheets are divided into Records and Fields.

 

Back to Top

Worksheet Records

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..

 

Back to Top

Worksheet Fields

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.

Back to Top

Worksheet NULL or Blank data

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.

Back to Top

Restore a Field to NULL entry (F12 command)

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.

 

 

Back to Top

Worksheet Commands

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.

 

Back to Top

 

END - Command

The <END> command SAVES the data from the screen and writes it away onto the hard disc and returns you to the menu.

 

Back to Top

 

ESC command

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.

 

Back to Top

 

HOME (HELP) command

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.

 

Back to Top

 

TAB command

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.

 

Back to Top

 

Cursor Movement Commands

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.

 

Back to Top

 

Worksheet Movement between fields

RIGHT ( or RIGHT ARROW ) The <RIGHT> command moves the cursor to the next field on the Right.

Old command

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.

Old command

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.

Old command

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.

Old command

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.

 

Back to Top

 

Movement within fields - F9

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

 

 

Back to Top

 

Movement within fields - F10

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

 

Back to Top

 

Movement within fields - Insert, delete, backspace, F12

These keys are also useful for moving inside a field. See the section on Editing Commands for more details

 

Back to Top

 

Movement from screen to screen - Page down <next scrn>

The <PAGE DOWN> command SAVES the current screen and displays the Next screenful of data.

 

Back to Top

 

Movement from screen to screen - Page up <prev scrn>

The <PAGE UP> command SAVES the current screen and displays the Previous screenful of data.

 

Back to Top

 

 

Home Services

Send mail to with questions or comments about this web site.
Copyright E-Quantities Ltd.