eBidding: Creating Tables - Specifications

How to: Create a Specifications table from scratch

*To copy a specifications table, see : eBidding: Creating Tables - Copying Existing Table\

*To upload a specifications table from a CSV file, see : eBidding: Creating Tables - Import from a CSV File

  • To build a “Specifications” table, click “Create” and select “Specifications” from the drop-down menu:

  • The table set up wizard will open. Fill in the necessary fields:
    • Table name
    • Indicate if the table is required. If “Yes”, the vendor will not be able to submit without completing the table. If “No” the vendor will be able to opt-out of the table.
    • If you would like the system to number the lines, select “Yes”, if not select “No
    • Indicate the number the system will start numbering at
    • Indicate the number of rows
  • To build a column select the column type and fill in the column name:

  • For a specifications table, there may be a variation of columns that will be used. Below are some common columns names corresponding to their type:

Column Type

Column Name

Yes – No

Yes – No

Proponent Response

True - False

True – False

Proponent Response

Exceeds – Meets – Does Not Meet

Exceeds – Meets – Does Not Meet

Proponent Response

Text

Description,

Question,

Comments

Location,

Dates etc.

(allows the vendor to type into a text field)

Quantity

Quantity,

Estimated Quantity

(the amount of goods needs)

Unit

Unit,

Unit of Measure

Unit Price

Unit Price

Total

Total,

Extended Amount,

Total Price

Estimate


Not visible to the vendor. Estimated dollar amount per unit. In bid analysis, you will be able to see the estimated price per unit versus what the vendor provided.

 

Points

The number of points allocated per each line item.

  • If the vendor needs to provide an answer, check the box “Vendor to Input
  • If it is mandatory for the vendor to provide an answer, check the box “Required
  • if you want to hide a column from the vendors, check the box "Hidden on Public"

  • Click “Add” to add the column. Once you do so, the column will appear in the Table Layout. Continue adding all of the necessary columns. Once completed, the table layout will have all of the columns.
  • To modify the width of the columns, hover over the headings, click and drag to expand. Do not go beyond the width of the table as it will cut off the table on the public side:

  • Once you have completed building the columns, click on “Save Changes”:

  • The specification table will now appear under filter type “Specifications” or “All”. Enter the data into the text fields as required:

  • To make changes to the table layout, click on “Edit Properties”.
  • To delete, add, move rows, click on the drop down menu next to the row:

 

  • If you want to make a row mandatory, check the “Req” box for the corresponding row. Click “Save Table” when finished.

 

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk