US flag signifying that this is a United States Federal Government website An official website of the United States Government

Update labor category filter in CALC tool

Ended on 09/02/2016
Winning bid (Summers, Dane): $400.00


HTML, JavaScript, and Python

As a user of CALC, I want to look up labor categories by SIN prefix (not the entire SIN number) rather than the old schedule name, so that I can be confident that I am getting the current prices (since the recent data upload migrated the old schedules into one professional services schedule with SIN prefix replacing of the current and former schedule names).

For example, If I want to see all labor categories in FABS (former schedule name), then I should be able to filter all labor categories with SIN prefix of 520. I should also be able to do this for SIN prefix 132/IT 70 (current schedule name)

Acceptance Criteria

Scenario: Filters are adjusted so they show former (or current) schedule name, along with SIN prefix

  • Given I am a visitor to CALC (no authentication required)
  • When I am on the CALC homepage (
  • Then I should see the following values for the schedule filter (pattern [SIN prefix] - [current or former schedule name])
520 - Formerly FABS
541 - Formerly AIMS
73802 - Formerly Language
871 - Formerly PES
874 - Formerly Mobis
87405 - Formerly Logistics
899 - Formerly Environmental
132 - IT 70

Scenario: Filtering by SIN prefix/schedule name picks up all labor categories with that SIN prefix

  • Given I am a visitor to CALC (
  • When I select [SIN prefix] - [current or former schedule name] from the schedule filter
  • Then my view should be filtered so that I see data only for vendors that have the selected SIN prefix

Scenario: Help text to explain SIN prefix/schedule name migration

  • When I visit
  • Then for each schedule listed except for schedule 70, I should see a sub-header containing the current SIN prefix for each of the schedule followed by “(formally known as [former schedule name])”
  • And for Schedule 70, I should see a sub-header containing the SIN prefix followed by “(Schedule 70)”

Scenario: Update API to return the correct information when filtering by SIN prefix

  • Given I am an authorized user of the CALC API
  • When I make a request for schedule data using a valid SIN prefix
  • Then the response should include data for all vendors in the schedule with that SIN prefix

Scenario: Update API documentation

General Acceptance Criteria

Bidder DUNS Amount Date (EST)
Summers, Dane 080194337 $400.00 * September 02, 2016 12:50:33 PM EDT
Scampersand 080287835 $1,599.00 September 02, 2016 10:52:05 AM EDT
Mile Two 079913221 $720.00 September 02, 2016 09:15:11 AM EDT
Abnoba LLC 080260077 $445.00 September 01, 2016 10:10:09 AM EDT
Digital Alchemy, LLC 080033370 $2,400.00 August 31, 2016 07:30:26 PM EDT
Saul Shanabrook 080251758 $999.00 August 31, 2016 07:18:52 PM EDT

* - winning bid

Bidding closed

Bidding for this auction closed on September 02, 2016 01:00:00 PM EDT.

Auction started at

August 31, 2016 01:00:00 PM EDT

Auction ended at

September 02, 2016 01:00:00 PM EDT

Delivery deadline

September 12, 2016 01:00:00 PM EDT

Eligible vendors only



Auction type:

Sealed bid (rules)

Paid at:

September 28, 2016 05:21:31 PM EDT

Accepted at:

September 27, 2016 08:55:45 AM EDT

View on GitHub