Bid Rate Trended Chart

The Bid Rate Trended chart tracks the change in bid rate over the analysis period you specify. You can display rates for months, quarters, or years.

The intersection of the chart line with the grid line for each time segment represents the bid rate for opportunities that have a bid rate analysis date within that month, quarter, or year.

 

In this topic

Chart Format

Chart Data

Example: Bid Rate Calculation

Bid Opportunities and No-Bid Opportunities

Bid Rate Analysis Date and Analysis Period

Pipeline Amounts

Maximize the Chart

Focus the Chart

Change the Horizontal Axis Periods

Display Data Point Information

Send the Chart Data to Excel

Other Chart Actions

Chart Format

Chart Item

Description

Horizontal axis: calendar months, quarters, or years

The horizontal axis displays the range of calendar months, quarters, or years included in the bid rate analysis period. You can use the Cycle button (Basics_CycleButtonNoDownArrow.png) to cycle through the three analysis period options.

Vertical axis: bid rate

The vertical axis displays the bid rate range (0 – 100 percent).

Chart line: bid rate by month, quarter, or year

Each intersection of the chart line with the grid line for a time segment represents the bid rate for opportunities that have a bid rate analysis date within that month, quarter, or year.

Chart Data

Data Item

Description

Bid rate for a period

Number of bid opportunities ÷ (Number of bid opportunities + Number of no-bid opportunities)

Or

Pipeline amount for bid opportunities ÷ (Pipeline amount for bid opportunities + Pipeline amount for no-bid opportunities)

The calculation used depends on whether you select Count or Amount in Display Trended Rates Based On.

The rate is displayed as a percentage.

For descriptions of the sources of the chart data, see Data Sources.

Example: Bid Rate Calculation

Your firm uses the opportunity open date as the bid rate analysis date. The total pipeline amounts for the bid opportunities and no-bid opportunities with an open date in November 2012 are the following:

When you select Amount in Display Trended Rates Based On, Capture Analytics displays a 40% bid rate for November 2012:

2,000,000 ÷ (2,000,000 + 3,000,000) = .4 = 40%

Bid Rate Analysis Date and Analysis Period

As part of the Costpoint Analytics configuration process, your system administrator specifies the date field from opportunity records in GovWin Capture Management that Costpoint Analytics uses to build the calendar for the bid rate portion of the Bid and Win Rate Analytics. That calendar is used to determine which opportunities to include in the bid rate calculations when you use the calendar bar to select an analysis period.

For example, your firm could use the opportunity open date. When you select a year in the calendar bar above the Bid Rate Trended chart to specify an analysis period for bid rates, Costpoint Analytics includes all bid and no-bid opportunities with an open date that falls within that year.

The bid rate analysis date field can be, and often is, different than the win rate analysis date field. If the two date fields are the same, however, the analysis period you select for the bid rate analytics is automatically applied to the win rate analytics as well.

Bid Opportunities and No-Bid Opportunities

As part of the Costpoint Analytics configuration process, your system administrator specifies how Costpoint Analytics is to determine which opportunities are bid and no-bid opportunities for the purpose of calculating your firm's bid rates. That determination can be based on stage, on a user-defined field from the Opportunity table in GovWin Capture Management, or on a combination of the two.

For more information, see Bid and Win Rate Settings.

Pipeline Amounts

When your firm implements Capture Analytics, it can select two amount fields from opportunity records in GovWin Capture Management to analyze as pipeline. The options under Pipeline Amount enable you to display bid rates calculated using amounts from either of those two fields. If you select Amount in Display Trended Rates Based On, Capture Analytics displays bid rates for the Bid Rate Trended chart based on amounts from the selected field.

Pipeline amounts used to calculate bid rates are unweighted amounts.

Maximize the Chart

Click maximizechart.png at the top right of the chart to display the chart at its maximum size. Click RestoreChart.png to restore the chart to its original size and location on the tab.

Focus the Chart

To focus the chart on a particular set of data points, click and drag the mouse pointer over the chart so that the green selection area touches only the data points you want to include. Common_DropDown_Down.gifIllustration

 To focus the chart on a more restricted analysis period, do either of the following:

It is much easier to make selections on the chart itself if you first maximize the chart.

If you use any of the above actions to change the chart, Capture Analytics applies the same changes, as appropriate, to other analytic objects.

Change the Horizontal Axis Periods

Use the Cycle button (Basics_CycleButtonNoDownArrow.png) to select any of the three analysis period options for the horizontal axis: Month, Quarter, and Year:

Display Data Point Information

To see the bid rate data for a specific data point, position the mouse pointer over the intersection of the chart line and the grid line for the time segment. When you do, Capture Analytics displays the month, quarter, or year and the bid rate. Common_DropDown_Down.gifIllustration

It is much easier to position the mouse pointer over a data point if you first maximize the chart.

Send the Chart Data to Excel

Click SendToExcel.png to send the data underlying the chart to Microsoft Excel. More...

Other Chart Actions

In addition to the actions described above, you can also do the following:

For more on these actions, see Print, Email, or Export Analytic Data and Attach Notes to Analytics.