CITE to Excel

The image above shows a typical CITE Bill of Quantities which can be used as input in the CITE to Excel converter. This CITE input file was actually created as an output file using the Calculix to CITE converter.

If you want to try it for yourself you can download the input file here (.ebq file)

The created excel output file can be downloaded here  (.xls file)

The image above shows the simple BQFilter user interface in which you select which conversion you wish to run and are then prompted with an options screen (see image below). You are asked a few questions about the input file you are using and the format of the output file you are creating. After the options are set, you are prompted for an input filename. On completion of the process a message box will inform you of the name of the output filename. This will be the same as the input file with the extension .xls instead of .ebq

Note: If the output filename already exists then it will be overwritten each time the program is run.

BQ Directory

This setting, which is browseable, describes the location of your input files. The output files will be placed in the same directory on your hard drive.

QSPro CSV Format

If you tick this checkbox, the Excel output will be in comma separated variable text format similar to that output by QSPro software instead of the usual Excel worksheet BQ. There is an additional option to remove leading spaces before description separators in the output.

Suppress I/O from item references

If you tick this checkbox,  the Excel output will not include the character "I" or "O" in item referencing in the BQ. These references were often suppressed in traditional Bills of Quantities.

Excel Sheet Formatting

These eight settings describe the formatting to be produced in the Excel output document. The options available for each CITE ID level are :









A typical excerpt from your CITE input file will look something like this :


2         D GROUNDWORK


4         Excavating

5         To reduce levels

9 1/1/A   1 m maximum depth         ...             165 m3

The leftmost number of each line is the CITE identifier. For non-quantity lines this number will be an integer of 8 or less. Have a look at the input file with (say) Wordpad and for each CITE ID, use the drop down box to tell BQ Filter whether that description should be bold, underlined etc.

Select "n/a" from the drop down box to tell BQ Filter if the particular CITE identifier is unused. This would be for ID's 6 through to 8 in the above example.

You will note in the settings there is reference to "ID0" and under the CITE standard the identifiers should be only be from 1 to 8. This functionality has been included in BQ Filter to cope with CITE files from some estimating packages which don't strictly comply with the CITE 4.2 standard.

Lines per Page

This setting tells BQ Filter where to put page breaks in the Excel output document. This number must not exceed that at which your printer inserts an automatic page break or the document will be numbered and paginated incorrectly.

Multiple Lines or Single Cell

This setting determines whether BQ Filter puts long descriptions on multiple lines or wordwrapped within a single cell in the Excel output document.

Continuation Heading

This setting can be changed between YES and NO to determine whether a continuation heading (the previous higher level description) is to be used where quantity descriptions would otherwise appear at the top of a new page.

Include CITE item references

This setting can be changed between YES and NO to determine whether item references from the CITE input file are shown in the Excel output BQ. Generally, users will select NO to produce a formatted BQ in its own right (ie. irrespective of the CITE file from which it was created). This option will add an extra column with the CITE references and squash the other columns up a little so that it still fits on a page. If you don't want the CITE reference, column B is hidden within Excel and so can be printed exactly as before with earlier versions of BQFilter. The hidden references can be "unhidden" manually later if desired.

Element/Workgroup on new page or worksheet 

This setting can be changed between "New Page", "New Worksheet" and "NO" to determine whether each BQ  main heading (eg. Substructure) begins on a new page, on a new worksheet or on the same page as the preceding item.

CITE Element ID

As per the example shown earlier, CITE heading identifiers are numbered from 1 to 8 but no title is given to any particular level. Only that 1 is at a higher level than 2 etc. This setting tells the BQ Filter program which reference (usually 1) is used at the top level. A new page or worksheet may be used at this level as determined by the previous setting.


This example shows a typical Excel output file.


Back to Top




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