Sections in this category

Cost Calculation page

  • Updated

You can build cost calculation formulas to evaluate supplier bids on the Cost Calculation page. Cost calculation formulas are created using arithmetic operators, comparison operators, functions, and bid sheet columns.

Cost Calculation page
Figure 1. Cost Calculation page
  1. Cost calculation field: Enter your primary cost calculation formula in this field, or else use the buttons in the Formula area to build your formula.
  2. Display type list: Select which format the result is displayed in: Number or Currency.
  3. Manage secondary calculations: Click to add and manage additional secondary formulas.
  4. Formula area: Use the arithmetic operators, comparison operators, function buttons, and bid sheet columns to build your formula.
  5. Test Calculation area: Enter sample values in the fields and then run a test calculation to test your formula.

You must create a cost calculation formula before you can publish your event. Ensure that your cost calculation does not evaluate to zero.

Arithmetic operators

Use arithmetic operators to create mathematical expressions in your formula. Table 1 describes the arithmetic operators available for building formulas.

Table 1. Arithmetic operators
Operator Description
+ Addition
- Subtraction and negation
* Multiplication
/ Division
( Left parenthesis
) Right parenthesis

Comparison operators

Use comparison operators to compare values in your formula. Table 2 describes the comparison operators available for building formulas.

Table 2. Comparison operators
Operator Description
= Checks if two values are equal
Checks if a value is greater than another value
Checks if a value is less than another value
>= Checks if a value is greater than or equal to another value
<= Checks if a value is less than or equal to another value
<>  Checks if two values are not equal to each other

Functions

Functions are predefined formulas. Table 3 describes the functions available for building cost calculation formulas.

Table 3. Functions
Operator Description
IF() Tests for a condition.
AND() Check if all conditions in a test are true.
OR() Check if any conditions in a test are true.
MIN() Returns the smallest number in a set of values.
MAX() Returns the largest number in a set of values
SUM() Adds all of the values in the argument.
AVERAGE()

Returns the average of the values in the argument.

MEDIAN() Returns the median of the values in the argument.
ROUND() Rounds a number to a specified number of decimal places.
ROUNDUP() Rounds a number up, always.
ROUNDDOWN() Rounds a number down, always.
CONCATENATE() Joins text strings together into one string.
BIDDER() Returns the bidder organization name.
ISBLANK() Checks if a cell is blank and returns either TRUE or FALSE.

Bid Sheet Columns

The Bid Sheet Columns area of the Cost Calculation page lists the columns from your bid sheet that you can use to build your cost calculation formula. You can only use bid sheet columns that have been configured as mandatory. Optional columns are not available when configuring a cost calculation.

Ensure that your cost calculation formula is not configured to equal a text input column.

Want to become a Keelvar pro?

Discover our online training courses, Bite-sized videos and more!

Contact your CSM to enroll.

Click here to find out more