REB 23.003 Processing
Regulations for Electronic Construction Invoicing (REB) describes the calculation methods and interfaces for exchanging data for general quantity determination. COSMO Project Construction uses REB 23.003 (commonly known as General Construction Accounting) and offers two types of formulas:
- 91 – a free formula that allows arithmetic operations (addition, subtraction, multiplication, and division) and mathematical operations (parentheses, exponents/roots) that can include many calculations.
- 00 – a fixed formula that allows arithmetic operations (addition, subtraction, multiplication, and division) but uses a formula editor to calculate up to five individual calculations.
In either case, an equal sign (=) must follow the formula.
Arithmetic Operations
Both formula types allow addition, subtraction, multiplication, division while Formula 91 also allows parentheses and ways to represent exponents and roots.
| Formula | Operation | Description | Example |
|---|---|---|---|
| 91 / 00 | + | Addition | 4+2= |
| 91 / 00 | - | Subtraction | 4-2= |
| 91 / 00 | * | Multiplication | 4*2= |
| 91 / 00 | / | Division | 4/2= |
| 91 | ( ) | Parentheses | 2*(2.25*4.35) + 2*(2.25*3.70)= |
| 91 | ** | To represent exponents/roots in formulas | To indicate 125³, enter 125 ** 3 To indicate ∛125, enter 125 ** 0.3333 or 125 ** (1/3) |
Measurement Formulas
Formulas used with REB 23.003 processing must be defined in the Measurement Formulas page, accessed from Tell Me by choosing the 
icon, entering Measurement Formulas, and then choosing the related link.
The fields in this page are described in the following table.
| Field | Description |
|---|---|
| Code | Indicates a unique identifier of the formula. This will typically be 91 or 00 but can be different if necessary. The code transfers to the Measurement document but the actual formula 91 or 00 is used during import/export (see Export/Import). |
| Description | Specifies a short description of the formula. |
| Process Description | Specifies the process description for the formula. |
| REB Formula No. | Indicates the formula number. The options are 91 and 00. |
In the Picture FactBox, you can add pictures that are specific to each formula using the standard picture import function. For example, a graphic to show calculations that are allowed for the formula.
Formulas in Measurement Lines
When measurements are created, either for a full BoQ or when BoQ positions are added to measurement lines, 91 defaults to the Formula No. field. This value can be changed to 00 as needed. If the Line Tag field is set to * Comment, then the Formula No. field is cleared.
To enter calculations for Formula 91
In the Formula field, manually enter the formula as simple or as complex as described in Arithmetic Operations. The equal sign (=) is automatically entered at the end of the formula but you can add it as well. The Quantity field is updated based on the calculation.
Examples
A measurement line has a BoQ Quantity of 12 but only 10 are needed. In the Formula field, 2*5= is entered. After leaving the field, the Quantity field is set to 10.
A measurement line has a BoQ Quantity of 12, which is the quantity needed. In the Formula field, 12= is entered. After leaving the field, the Quantity field is set to 12.
To enter calculations for Formula 00
In the Formula field, choose the ellipsis button to open the Measurement Formula Editor page. The Formula FastTab shows the number and description. The Values FastTab has five input boxes where you enter the formulas. Each box can only contain one value ending with an arithmetic operation as described in Arithmetic Operations. The last entry must have the equal sign (=); an error occurs if you try to enter another operation on a line after one with an equal sign. After entering the formulas, the Quantity field is updated based on the calculation.
Example
A measurement line has a BoQ Quantity of 205 but only 198 are needed. The formula to calculate this is 115+95-12. Open the Measurement Formula Editor for the measurement line and then:
- In the first box, enter 115+
- In the second box, enter 95-
- In the third box, enter 12=
Choose the OK button to close the formula editor. The Formula field shows the calculation with spaces between each operation and the Quantity field is set to 198.
The spaces are added between the operations because each is captured in a separate field and are used in other processes.
Note
The Measurement Formula Editor is accessible for both Formula 91 and 00. However, there is only one input box for lines with Formula 91.
Assume BoQ Quantity
The Assume BoQ Quantity action on the Actions menu transfers the BoQ Quantity to the Quantity field and remaining quantity to the Formula in the measurement lines set with Formula No. = 91. Existing formulas in these lines are overwritten with the remaining quantity. If the remaining quantity is 0, then 0= is entered.
No changes are made to the Formula field for lines with Formula No. = 00 or Line Tag = * Comment.
Export/Import
When exporting or importing to the Measurement Interface from Measurements, Registered Measurements, and Measurement Summaries, the REB Formula No. from the Measurement Formulas page is used. Therefore, if you chose a different Code, the export/import will indicate either 99 or 00, respectively.
When a Measurement is created from the Measurement Interface, the value of the Code is transferred instead of the REB Formula No. value.
For more information, see Measurement Interface.
See Also
Feedback
Submit feedback for this page .