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.