{"action":"created","issue":{"url":"https://api.github.com/repos/18F/calc/issues/255","labels_url":"https://api.github.com/repos/18F/calc/issues/255/labels{/name}","comments_url":"https://api.github.com/repos/18F/calc/issues/255/comments","events_url":"https://api.github.com/repos/18F/calc/issues/255/events","html_url":"https://github.com/18F/calc/issues/255","id":113127047,"number":255,"title":"Load Schedule 70 data into CALC. >>> Current bid: 2800 <<<","user":{"login":"vzvenyach","id":4153048,"avatar_url":"https://avatars.githubusercontent.com/u/4153048?v=3","gravatar_id":"","url":"https://api.github.com/users/vzvenyach","html_url":"https://github.com/vzvenyach","followers_url":"https://api.github.com/users/vzvenyach/followers","following_url":"https://api.github.com/users/vzvenyach/following{/other_user}","gists_url":"https://api.github.com/users/vzvenyach/gists{/gist_id}","starred_url":"https://api.github.com/users/vzvenyach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vzvenyach/subscriptions","organizations_url":"https://api.github.com/users/vzvenyach/orgs","repos_url":"https://api.github.com/users/vzvenyach/repos","events_url":"https://api.github.com/users/vzvenyach/events{/privacy}","received_events_url":"https://api.github.com/users/vzvenyach/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/18F/calc/labels/micro-purchase","name":"micro-purchase","color":"5319e7"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-10-24T01:53:45Z","updated_at":"2015-10-27T08:20:12Z","closed_at":null,"body":"As [previously explained](https://18f.gsa.gov/2015/10/13/open-source-micropurchasing/), this issue has been tagged as a \"micro-purchase\" issue. The opening \"bid\" for this issue is $3,499, and vendors may offer lower bids. The vendor with the lowest bid at closing time will have 10 working days to provide code that satisfies the requirements and acceptance criteria below. Upon successful completion, the vendor will be paid. If the vendor fails to complete the requirements and satisfy the acceptance criteria within the 10 working day period, then the vendor with the next lowest bid shall have 10 working days to provide the code. If the acceptance criteria are not satisfied, vendors shall not receive payment pursuant to this competition.\r\n\r\n## Description of issue\r\n\r\nCurrently, CALC uses a [management command to load data](https://github.com/18F/calc/blob/master/contracts/management/commands/load_data.py) from 7 different schedules. We want to load the Schedule 70 data provided into CALC (note, the data will likely need to be reformatted). The data is available here: https://github.com/18F/calc/tree/s70/contracts/docs/s70\r\n\r\n## Acceptance criteria\r\n\r\n1. Either a new Django management command or modification to https://github.com/18F/calc/blob/master/contracts/management/commands/load_data.py to load the Schedule 70 as Contract objects in the database.\r\n2. Whether a new command or a modification to the existing command, the rating from https://codeclimate.com/github/18F/calc for the file must be at a B or better rating, and test coverage for the command at 90% or better upon completion. \r\n3. Front-end changes to ensure the ability to filter results by schedule type (e.g. Schedule 70 data or others) and easily see the schedule source for each row in the results.\r\n\r\n## Bid submission deadline\r\n\r\nBids for this issue close at 12 p.m. EST on Thursday, Oct. 29, 2015. To bid on the issue, click here: https://docs.google.com/a/gsa.gov/forms/d/1eRFX0hSTTXMc2FulK6kPP2P02ZApQqlYZL7oVDghJJo/viewform"},"comment":{"url":"https://api.github.com/repos/18F/calc/issues/comments/151411219","html_url":"https://github.com/18F/calc/issues/255#issuecomment-151411219","issue_url":"https://api.github.com/repos/18F/calc/issues/255","id":151411219,"user":{"login":"vzvenyach","id":4153048,"avatar_url":"https://avatars.githubusercontent.com/u/4153048?v=3","gravatar_id":"","url":"https://api.github.com/users/vzvenyach","html_url":"https://github.com/vzvenyach","followers_url":"https://api.github.com/users/vzvenyach/followers","following_url":"https://api.github.com/users/vzvenyach/following{/other_user}","gists_url":"https://api.github.com/users/vzvenyach/gists{/gist_id}","starred_url":"https://api.github.com/users/vzvenyach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vzvenyach/subscriptions","organizations_url":"https://api.github.com/users/vzvenyach/orgs","repos_url":"https://api.github.com/users/vzvenyach/repos","events_url":"https://api.github.com/users/vzvenyach/events{/privacy}","received_events_url":"https://api.github.com/users/vzvenyach/received_events","type":"User","site_admin":false},"created_at":"2015-10-27T08:20:12Z","updated_at":"2015-10-27T08:20:12Z","body":"@borromeotlhs Thanks for the comment! I'll let @theresaanna correct me if I have this wrong, but I'm pretty sure that the current data is pulled from here: https://github.com/18F/calc/blob/master/contracts/docs/hourly_prices.csv\r\n\r\nA schedule (http://www.gsa.gov/portal/category/100615) is basically a contract vehicle that makes it easier for companies to contract with the government. Schedule 70 is for IT contracts. Within Calc right now, there's an explanation here https://calc.gsa.gov/about/#schedules that lists the schedules that are currently loaded.\r\n\r\nDoes that help clarify?"}}