- Welcome to Pricing Sheets
- Getting Started With Pricing Sheets
- Building Your Pricing Sheet
- Posting Your Pricing Sheet
- Further Reading and FAQs
Welcome to Pricing Sheets
Bonfire is excited to release Pricing Sheets, an easy way to simplify your organization's price-only or most straightforward bids while retaining all of the feature-rich functionality you need for best-value, solution-based RFPs.
Pricing Sheets allow buyers to set up a list of line items on these types of projects quickly and efficiently, with very little training, and are ideal for bids, quotes, or tenders that have fewer than 20 line items.
Getting Started With Pricing Sheets
Note: Before you can use Pricing Sheets, this feature must be enabled by your dedicated Client Success Manager or Bonfire Support. Please reach out to us for more info!
After selecting Pricing Sheet, the pricing sheet will be located in the Requested Information Accordion. It is generated with a default set of columns and 5 sample items.
The default columns cannot be edited or deleted, and are used in the Total Cost formula.
- Item Name - Text column that is the unique identifier for each line item. This is a buyer column.
- Quantity Required - Numerical column to indicate the # of items needed. This is a buyer column.
- Unit Price - Price/Currency column for the vendor to enter their bid(s) into. This is a vendor column
- Total Cost - Calculated column that uses the formula Unit Price X Quantity Required to determine the vendor’s total quoted price for each item.
Each column header includes a Column Type Indicator to show you what type of columns you have on the Pricing Sheet. This is appended to the end of the column title on the buyer side, but is not visible to vendors. The Column Type Indicators are as follows:
- (Aa) - indicates text column
- (#) - indicates number column
- ($) - indicates currency/price column
The title of the Pricing Sheet can be changed using the input field at the top of the table. This title acts like the Bid Table title, and will appear on the Requested Information, Bid Table Excel template, Submission page, etc.
To enter content into the Pricing Sheet, you can click on any cell and start typing. You can also navigate through the Pricing Sheet using your tab key, and click enter or start typing to enter content into the cell.
Buyer Columns are either blank or contain text. These are the columns where you will input information into before the project goes live.
Vendor Columns are shown on the Pricing Sheet by the Vendor Response pill located inside the cells. These are columns that you add to the sheet so that vendors can submit bids on each line item.
Building Your Pricing Sheet
Adding or Removing Line Items and Rows
The large + Item button at the bottom of the table is used to add more line items, while the garbage can icon to the right of each Item Name field can be used to delete line items if needed.
Reordering Line Items or Rows
Rows can be reordered by first clicking on the six-dotted icon beside each row number, then dragging the row up or down.
Adding or Editing Custom Columns
In addition to the default rows on the Pricing Sheet, you can set up as many custom buyer and vendor columns as you may need. Additional columns are added by clicking on the + Buyer Column and + Vendor Column buttons.
After clicking on the buttons to add columns, you will be prompted to name the column and select a column type.
After saving a custom column, you can always go back to edit your custom columns using the edit button on the column header.
Reordering Custom Columns
Columns can be reordered by clicking on the six-dotted icon in each column header, then dragging the column left or right.
This option only appears when the Pricing Sheet has more than one buyer column or more than one vendor column. All buyer columns must be on the left side of the sheet, and all vendor columns must be on the right side of the sheet.
Edit and Read Only Modes
When you first create a project, the Pricing Sheet is in Edit Mode. This means that the cells and buttons are in a editable, and you can make changes to the Pricing Sheet.
After you are finished making edits, you can click on the Exit Edit Mode button to enter Read Only mode. This removes the ability to edit cells, and hides the buttons on the Pricing Sheet so that there are no accidental data or content changes. After the initial setup, every time a buyer accesses the project page the Pricing Sheet will default to Read Only mode.
Read Only Mode:
To return to Edit Mode, simply click the Edit button at the top right of the Pricing Sheet.
The Settings button opens a window that allows your to further configure the pricing sheet. The options available are:
Vendors can respond with “No Bid”
- Allows vendors to select Bid/No Bid on each item. This behaves the exact same way that it does on a Bid Table.
Vendors can provide additional responses
- Allows vendors add additional responses if they want to provide quotes on substitute items. This behaves the exact same way that it does on a Bid Table.
Posting Your Pricing Sheet
After setting up the Pricing Sheet, it needs to be mapped to Requested Information just like a Bid Table. Using the Add Requested BidTable button, you can add the Pricing Sheet to your Requested Information and Criteria so that vendors can submit to the project.
After the Pricing Sheet has been set up and added to Requested Information, it will appear as a Bid Table to vendors and evaluators. Vendors submit the same way they would to a Bid Table: either by using the Excel template or the New Submission Experience. Evaluators, including you as the Project Owner, review the submissions and the prices through the orderlist like they would do for a Bid Table.
Further Reading and FAQs
What happens to the Pricing Sheet once the project is opened?
After the Pricing Sheet has been set up and added to Requested Information, it will appear as a Bid Table to vendors and evaluators. Vendors submit the same way they would to a Bid Table, either by using the Excel template or the New Submission Experience. Evaluators, including the Buyer, review the submissions and the prices through the orderlist like they would do for a Bid Table.
How does a vendor submit to a pricing sheet?
On the vendor side, vendors don’t see the difference between a BidTable and a Pricing Sheet. The Pricing Sheet can be used with both the classic BidTable submission experience, and the New BidTable submission experience, depending on the buyer’s preference.
When are changes to the Pricing Sheet saved?
Changes to the Pricing Sheet are saved in real time as they are made. You can see the latest save time by looking to the left of Settings, along the top of the Pricing Sheet.
What happens when a Pricing Sheet is edited when a project is open?
If the Pricing Sheet is edited while a project is open, a banner prompting you to issue a Public Notice to communicate project changes will appear at the top of the project page.
If there are already vendor submissions associated with the Pricing Sheet, you will not be able to delete vendor columns that have been set up on the Pricing Sheet.
How were the default columns and total cost column chosen for the Pricing Sheet?
The default column setup was validated based on research with a wide variety of Bonfire clients. The intention is for the default columns of the Pricing Sheet to apply to 80%+ of bids, but there will be some projects that don’t lend themselves to the default columns and either require a Bid Table, or a workaround setup using the custom columns that a buyer can set up. Contact your dedicated Client Success Manager or Bonfire Support for more information or for 1:1 assistance.
Are the column type indicators visible to vendors?
No, the column type indicators are only seen by the buyer, and are not shown on the Bid Table Excel template or the New Submission Experience.
- Creating a Project in Bonfire - Overview
- Creating a BidTable
- How to Evaluate a Project with a BidTable
- How do I map a BidTable as Requested Information?
More questions? Please contact us at firstname.lastname@example.org!