These facilities allow you to Customise the Calculix Output documents to suit your requirements.
The Bill Format worksheets determine the appearance of the various Bills of Quantities that can be produced.
The options available are extensive and are divided into two separate worksheets :
Each contract can have as many different Bill Formats as required, each one being given a name which will be used to select the appropriate details when producing the Bill.
Both of the worksheets have to be completed in order to produce a Bill although the Specific Bill Format includes a record of which Basic Bill Format is to be used with it.
The Basic worksheet is, ideally, set up for the normal office presentation and then never altered. The Specific worksheet is to cater for the individual needs of each Contract Bill and as such must be set up for each document.
The options available on the Basic Bill Format are explained in detail below.
The number of lines to each page of stationery being used; A4 = 70 lines, standard computer stationery = 66 lines.
NOTE Laser printers can't always address the whole page and it may be necessary to artificially reduce the Page length to allow for this.
The number of characters that will fit on to each line of the page. This will depend not only on the size of the page but also on the "pitch" of the characters being used by the printer
NOTE If the document is being output to a word processor the last character of a line may be specially defined for the "carriage return" and this should be allowed for. Make sure also that the line length in the word processor is the same length as used here or the line will not fit properly onto the word processor screen.
The number of lines from the top of the page before the first line of text will appear. It will include any header lines asked for.
The line number on which the bottom line of the text will be placed. This is the last line of "Text" on the page and excludes any footer lines and also the line containing page number.
Page length = Last line of Text
+ footer lines
+ page number line
+ 1 spare line at bottom of page.
If the settings are such that there is insufficient space for the Footer the Last Line of Text will be reduced to make enough space available.
If there are spare lines left over these will be inserted after the last line of Text and before the Footer.
This field determines where the first character i.e. column 1 of the Bill will be printed. It is as much to do with where the page is positioned in the printer as anything else, but generally assumes that the page is positioned so that column one of the printer corresponds to the first character position on the paper. In this case the binding margin represents the column number of the first character to be printed.
The first character is, in fact, the item reference letter. All subsequent column numbers relate back to column one as defined by the binding margin.
The column number of the left hand side of the description field.
This is the number of spaces by which Items are indented. It is ONLY used in conjunction with the Split/Continuous option described further down the page. The indentation is measured from the Text Left Margin.
This gives you the option of choosing how many spaces Written short items are indented by. The indentation is measured from the Text Left Margin.
The column number of the right hand side of the description field.
All of the number fields are right hand justified and this is the column number of the right hand side of the quantity field.
The left hand column of the Unit field.
The column number of the right hand side of the Rate field.
The column number of the right hand side of the Extension field. (i.e. product of the quantity x rate).
The column number on which the Page number and any associated Prefix will start.
The number of decimal places to which quantities in tonnes will be printed ie 2 or 3.
This option allows a variety of different presentation styles in which the dimensions of a bill item will appear. They will normally be associated with a clause in the Preliminaries indicating how the dimensions will be shown.
Option Style for Dimension Style for Dimension Letter 1 metre and over Less than 1 metre
A Decimal metres - units stated Decimal metres - units stated
B Decimal metres - units assumed Decimal metres - units assumed
C Millimetres - units stated Millimetres - units stated
D Millimetres - units assumed Millimetres - units assumed
E Decimal metres - units stated Millimetres - units assumed
F Decimal metres - units assumed Millimetres - units stated
G Decimal metres - units stated Millimetres - units stated
Three different options are available for Page Totalling.
FF = Carry Forward / Brought Forward
The cumulative total of preceding pages in this Section is printed at the bottom of each page and also at the top of the following page. The two totals are annotated "carried forward" and "brought forward" and the process continues until the end of the Section when the Total is printed. The levels at which the Section Totals are printed are determined by the "Totals" entry of the Basic Bill Format.
CC = To Collection
This option prints the individual page total at the bottom of each page. The page total is also Formatted into a Collection Page. The Collection Page is printed at the end of the Section and includes a Total which is carried to Summary.
PP = Page Totals
This option merely prints the individual page total at the bottom of each page.
This option relates to the format of "Items" in the Bill.
SS = Split Item
If the Split option is selected, the item descriptions will be split with the descriptions for items 1a and 1b printed as a HEADING and the descriptions for items 2a and 2b printed as the item description proper.
The heading and the item description will be separated by a blank line and the item description will be indented according to the Item Indent field.
CC = Continuous Item
If the Continuous option is selected, the separate descriptions which make up the item (items 1a, 1b, 2a and 2b) will be joined together to form a continuous description.
The next batch of data is a table providing a series of options for the different levels of description. The levels of description affected are all those above item description level
The options available for each level are as below:
The text can be printed Normally or it can be enhanced with Bold text, Underlined text or it can be printed with All enhancements ie bold and underline.
The descriptions can be positioned as follows :
L = Left justified - text starts at left and works forward.
R = Right justified - text finishes at right and works backward.
C = Centered - text positioned at centre of each page.
This facility allows any of the heading descriptions to extend beyond the item description field and into the quantity and unit columns. The options are yes or no. If no, the "Text right margin" determines the right hand side of the description. If yes, the right margin of the unit column is used as the right hand margin for the text description.
The page option allows you to force a page break whenever a new entry at the appropriate level is encountered.
You can't select a new page at Specification level
When producing a Trade Bill, you must have a new page for the beginning of each Trade.
When producing an Elemental Bill you do not have to have a new page for each new Trade.
This option will provide sub-totals for the appropriate section if the selection is yes.
These entries show which sequences of characters must be used to print the special characters such as quarter, half and three-quarters, degrees, squares, cubes and the pound sign. They can be altered to suit different printers.
When selected this option will print the Section heading in the top right hand corner of all pages in the section except the first page. For a Trade Bill the section heading will be the current Trade and for an Elemental bill the section heading will be the current Elemental section.
The bottom of the extension column can be ruled off to introduce the page total. If you are using pre-printed stationery you may not want this.
When selected this option automatically prints "To Collection" in the Footing before the page total.
This field is only used when Collection pages have been selected on the "C/F - B/F, Page Totals, Collect" option.
There are 3 ways in which the Collection Page will be produced.
Force will always start the Collection on a new page.
Yes will start the Collection on a new page UNLESS there is only one page in the Collection. If there is only one page the "To Collection Footer" will be modified and the page Total will be carried straight to the SUMMARY without an intervening Collection.
No will fit the whole Collection page onto the last page of the Section IF THERE IS SUFFICIENT ROOM. Otherwise the Collection will start on a New page.
This option determines the line spacing of the Collection page (when used).
S will introduce a single line between successive Page totals of the Collection
D will insert two lines between successive entries.
entries on the Specific Bill Format worksheet are as follows :
Headers and Footers are text which appear at the top and bottom of each page of the Bill e.g. Company name, job name etc.. Note that any text entered will appear on every page of the Bill.
Justify: Each line of Header and Footer text can be justified as follows :
L = Left justified - text starts at left and works forward.
R = Right justified - text finishes at right and works backward.
C = Centered - text positioned in the centre of the page.
Each line of Headers and Footer text can be enhanced as follows:
B = Bold - The text will be emboldened
U = Underlined - The text will be underlined
A = All enhancements - The text will be emboldened AND underlined
N = Normal - The text will be printed normally.
Insert the page number required on the 1st page of the Bill Document. Subsequent pages will be numbered sequentially starting from this number.
This facility allows a description to be indented to suit the users' requirements. Wherever the description contains Indent A the text will be indented by the number of spaces assigned to A on this form and so on. These 'indents' may be set to any number.
If the Bill is to be used by contractors to prepare an analytical estimate, it is often desirable to have adequate space under each item for handwritten prices. The amount of space can be selected by the number of lines entered against this option. One blank line will be left by default.
Selecting this option inhibits all bolding and underlining and therefore speeds up the production of the Bill.
This option determines how the NEDO work categories are to be incorporated into the text.
N - Option N
If N is selected then the NEDO work categories will NOT be printed at all.
Y - Option Y
If Y is selected the work categories will be printed in () (round brackets) after the Sub-section text.
M - Option M
If M is selected, the work category will be printed in the binding margin on the sub-section line.
D - Option D
If D is selected the Nedo work category will be printed against every item description in the binding margin before the description.
I - Option I
If I is selected the Nedo work category will be printed against every item description in the binding margin on the last line of the description i.e. on the same line as the quantity.
This option allows the bill rates to be either printed out or suppressed. The Bill rates will obviously only be printed if they have been previously entered in the Pricing process. The option is yes or no.
This is archaic and is assumed not to be used. It will be removed from future versions.
This offers the opportunity to suppress the quantities when producing the bill. The option is yes or no.
If required the description codes can be printed in the bill beneath the description. The option is yes or no.
This is the space for the name of the Basic Bill Format which is to be used in conjunction with this Specific Bill Format. If the <HOME> key is pressed on this option, Calculix will list all of the available Basic Bill Formats.
Calculix will check to see that it is a valid file name. The File name is displayed on the screen when the processor Formats the Bill.
Text of up to 10 characters which will precede the page number on every page
e.g. Bill no 2/.
Complete Work Groups or Trades can be included and others can be excluded as required. Calculix automatically knows whether it is processing a Work Group or a Trade Bill and uses this code to Include and exclude the relevant sections.
This facility allows Elements to be included and omitted from an Elemental Bill. It is a 3 character field which would normally start with "000" and end with "zzz".
NOTE These are Elemental Analysis type Elements and NOT Calculix Elements.
The Valuation Chart processes are designed to re-process the priced Bill into a suitable form for assessing the value of the work in progress for Interim Certificate purposes.
The Format of the Chart is based on the Traditional tick chart with the Work Stages arranged in rows down the page and with Work Locations arranged in columns across the page.
The work stages are automatically determined as the work contained within each Trade sub-section, Work Group Section whichever is relevant.
The Work Locations are determined by the column numbers assigned to each room in the Valuation Column number.
The Valuation Chart can be formatted in a variety of different ways to suit the users' requirements:
Each Project can be divided into as many valuation charts as is convenient. Each chart will be identified by a different name which will be used to specify which chart is being processed.
As with the Bill Format, Valuation Chart Formats are stored in the system for future processing.
The Valuation chart will start with the column number specified in the first column field and finish with the column number specified in the last column field.
The Valuation Chart will contain all Bill Sections covered by the entries in the range "Include From _ To _". These entries would normally be all-embracing to include the whole bill.
A group of Bill Sections can be omitted from the Chart by completing the entries
"Omit From _ To _".
Only one continuous range of "Include" and "Omit" sections is possible. It is expected that the M & E sections will normally be the ones that will be omitted.
Calculix automatically knows whether it is processing a Work Group Valuation Chart or a Trade Valuation Chart. It determines this by an entry in the Work Group code field ( A trade chart will be blank in this field ). The entries made in these fields will automatically be either the Work Group or the Trade codes as applicable.
There is no restriction on the length of a description, but the width of the description printed on the Valuation Chart will be restricted to the number of columns specified here. If the description is longer than this, two things can happen. If the word-wrap selection is No, then the description will be truncated at the end of the specified length. If the word-wrap selection is Yes, the description text which will not fit on the first line will be put on the next line etc.. Valuation Charts will frequently use more than one page width to get all of the data on. Successive continuation pages will also contain the description field if the appropriate field is set to Yes.
Sub-totals are automatically calculated for each row of each page. These totals will be printed out at the end of each continuation page, the start of each continuation page and the end of the last page if the appropriate field is set to Yes.
This field determines the number of lines assigned to each row of data, and will normally be 1 for single line spacing. It is not necessary to consider complications such as where descriptions are word-wrapped on the next line.
This field determines the number of character positions allocated to each column of the chart.
The Width of each page of the Valuation Chart is set by the actual size of the paper in the printer and entered in this field. Where the chart is too large for the paper, Calculix will automatically organise the document for continuation sheets. Continuation sheets down the chart are allocated consecutive page numbers and continuation sheets across the chart are allocated consecutive section letters.
If required the decimal pence can be suppressed by setting this field to Yes. In this case each cell of the Valuation Chart will be rounded to the nearest pound. The Totals and Sub-totals will all be calculated to the nearest pence and rounded at the end of processing. This will prevent cumulative inaccuracies.
Send mail to
with questions or comments about this web site.