FREEWARE DOWNLOADS

Pricing

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

 

Pricing

  1. Pricing
  2. Pricing menu - Generally
  3. Pricing Terminology
  4. The Price File
  5. The Price Library
  6. Price a bill
  7. Add Prices
  8. Display of the rate extension - Pricing
  9. Edit Prices
  10. Price from Master - Auto-pricing
  11. Price Flags In the Editing Routine
  12. Unpriced Items - Pricing
  13. Add Prices
  14. Pricing by UNIT
  15. Tender analysis - Pricing - Processing
  16. Output filenames - Tender Analysis
  17. Minibills - Pricing

 

Pricing

The Pricing routines allow the Bill of Quantities to be priced and checked against Tender documents.

 

Back to Top

Pricing menu - Generally

The Pricing facility allows the contractor's or other unit rates to be entered against Bill Items. Once the rates are entered Calculix takes over and produces the extensions, totals and the Contract Sum and uses the pricing information in the VALUATION and VARIATION ROUTINES. Pricing can either be entered from scratch or edited as required.

 

Back to Top

Pricing Terminology

The price system uses a separate file for storing prices. This file is in the same form as usual with the contract code followed by p.kl. Each file will contain all of the price libraries on a job and the files can be copied in the operating system in the usual way.

 

Back to Top

The Price File

The price File is the p.kl system file and is referenced with the appropriate contract code.

A price File can contain many Libraries and it is therefore necessary to specify which one is being referred to.

 

Back to Top

The Price Library

The price Library is a collection of prices used for a bill.

The price library for any bill is automatically stored in the contract price file.

 

Back to Top

Price a bill

Details of pricing a bill are as listed below.

 

Back to Top

Add Prices

The Add Prices routine is specially adapted to only display those items which are Unpriced. This routine will skip all those items which have got prices and only display those that haven't got a price. Remember that a price of 0.00 is real and items with a 0.00 price will not be displayed by the Add Prices routine.

 

Back to Top
 

Display of the rate extension - Pricing

After entering the bill rate, if the RETURN key is pressed, the display will pause at the extension field so that it can be checked and/or compared with the tender value. A second press of the RETURN key will move on to the next item.

 

Back to Top
 

Edit Prices

When the Pricing option is selected the operator will be asked for an item description code from which to start. The procedure will start with the next item to the code selected, entering just the trade code will therefore start at the beginning of that trade etc. The Bill Items will be displayed, one at a time, starting from the code selected. A <RETURN> will start at the beginning.

After entering the Bill Type, the Description Code must also be entered.

The items then displayed are in unformatted form with each part of the item code displaying its individual description. The quantity is also displayed. The appropriate rate should be typed in followed by a <RETURN>. The entered price will be multiplied by the quantity and the resulting value displayed in the extension field. The next item will then be displayed.

If there is insufficient space for the whole of an item to be displayed on the screen the message "Ready" will appear and you must press <RETURN> to see the rest of the item.

<ESC> will terminate the routine.

 

Back to Top
 

Price from Master - Auto-pricing

A bill can be automatically price from the Master price list. This also provides a mechanism for copying price files if required.

 

Back to Top
 

Price Flags In the Editing Routine

Price flags can be used to indicate some special pricing conditions. To implement this feature function key F8 is pressed whilst editing a price/rate.

? =Query - the rate has been queried for some reason or other

L = Lump sum - the rate entered is for the whole item and the quantity is to be ignored

P = Provisional - the rate is provisional and should be confirmed

I = Included - the cost of this item is included elsewhere

Page totals are not calculated during the entry of prices rates because the work file does not know where the page breaks will occur. The Page totals will, however, be automatically calculated, together with COLLECTIONS and SUMMARIES, whenever the Bill is subsequently produced.

Page totals can be checked as you proceed by using the pricing totals buffer. If at the end of a page you press <F11> the totals buffer is reset or zeroed, allowing the next page total to be checked.

The Pricing routine appends prices to the Bill items and can therefore only be run after a Bill has been calculated. Thereafter prices entered will be used on all subsequent re-runs of the calculate Bill process and any changes made to the quantities will automatically be priced.

Note that if the quantities change to the point of altering the items themselves, then the new item may not have a corresponding price entry.

e.g. If the invert level of a manhole is changed so that the excavation is no longer "exceeding 1m and not exceeding 2m" but is now "exceeding 2m and not exceeding 4m" the price entered for the original item will not be used for the new item. The old price will remain in the system, however, and if a new item is created for "excavation exceeding 1m and not exceeding 2m" the price will be automatically used again.

 

Back to Top
 

Unpriced Items - Pricing

Wherever practicable, Calculix will highlight a missing price by placing an * (asterisk) against any dependant total in the word-processed draft Bill. Items that are not priced should, therefore, be entered with 0.00.

 

Back to Top
 

Add Prices

The Add Prices routine is specially adapted to only display those items which are Unpriced. This routine will skip all those items which have got prices and only display those that haven't got a price. Remember that a price of 0.00 is real and items with a 0.00 price will not be displayed by the Add Prices routine.

This option is particularly useful for partially priced bills and it is a good check before printing or processing a priced bill to ensure that no items have been overlooked.

 

Back to Top
 

Pricing by UNIT

The pricing routines store the prices by location UNIT. This allows very complex possibilities where the rates for the same item are different around the Estate.

This would normally cause a problem for simple projects where the same rate would be use to cover ALL occurrences of the same item. Calculix therefore filters the pricing routines through the Estate Configuration and if the same items occur in different UNITS within the same estate then Calculix will treat them as one item and give them all the same rate. In this way you only have to price the item once even though it occurs in several different UNITS.

 

Back to Top
 

Tender analysis - Pricing - Processing

Whilst Tender Analysis is a feature of the pricing routines, it is accessed from the Bill Production menu.

Tender Analysis has been introduced to allow comparison of several tenders for a project. Four tenders are currently reported with the first one entered representing the reference bill against which the others are compared. A percentage figure can be entered which will define what variance in the alternative tenders will be highlighted. At the moment the variance only highlights instances where the alternative tenders are cheaper than the reference bill.

Alternative bills are priced using the same Bill type as was used for the bill itself but specifying a different price library. As many price libraries can be created as required.

Alternative bills can be priced using another library in the same job if required.

 

Back to Top
 

Output filenames - Tender Analysis

Tender analysis and the new traditional valuation routines produce word processing reports in the same way as the bill production itself. To avoid the need to keep changing the output filename these reports take the filename in the Specific bill format as the stem and add a suffix for identification as follows : Tender analysis - filename suffix t, Gross Valuation g, Net Valuation n.

 

Back to Top
 

Minibills - Pricing

Minibills have been introduced. These enable bill items to be cross referenced with a letter which will enable a Minibill of all items with the same letter to be produced. The facility is principally intended for producing subcontract bills for tender purposes.

 

Back to Top

 
 

 

Home Services

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