SOW_FBO_Draft.docx

STATEMENT OF WORK

TITLE: Creo Elements/Direct Manager Server Database File Update

Background The Research Facility Operations (RFO) Mechanical Engineering group at the National Institute of Standards and Technology (NIST) Center for Neutron Research (NCNR) is responsible for designing, constructing, and maintaining neutron research instruments for the scientific community. The RFO Mechanical Engineering group relies on computer aided design (CAD) software to produce 2D and 3D data. The NCNR CAD database has been migrated multiples times since its inception to new database types as the database types in use became obsolete. The existing NCNR CAD database consists of PTC Creo Elements Direct Manager Server software using a Microsoft SQL Server database. The database has close to 500,000 elements with a file storage area containing over 3 million files filling almost 300 gigabytes of storage space. This is for a contractor to develop a software tool that will update the files in the database while maintaining the file attributes, links, and other important data.

Scope The Contractor shall draft a Software Tool Development Plan and design a tool as described in the development plan, that will automatically detect 3D CAD files older than a to be determined file version and to overwrite them in the PTC Creo Elements/Direct Manager Server database while maintaining existing database links and file attributes.

tasks Task 1, Software Tool Development Plan The contractor shall develop a detailed development plan for developing, testing, and implementing a tool to automatically detect files older than a to be determined version and then overwrite these files without changing any existing database links or attributes. The tool shall integrate seamlessly with the existing PTC Creo Elements Direct Manager Server implementation at the NCNR and shall run automatically when a 3D load is initiated. If 3D files older than a to be determined version are detected the tool shall alert the user with a prompt to choose whether or not the tool shall overwrite these 3D files with new 3D files. If the user chooses to overwrite the files, the Contractor developed tool shall create new files and overwrite the existing files in the file storage area on the server. The overwrite process shall take place in the background and shall not change any of the Model Manager part or master data attributes including owner, created date, modified date, name, etc. and existing links in the database shall be maintained.

Task 2, Software Tool Prototype The contractor shall build a prototype of the Software Tool to implement and test on a test server and a test client. Delivery of the Software Tool Prototype shall include the following documents and files:

· Required files to implement the software tool on a test server and test client.

· Software Tool Installation Instructions, which include instructions on how to run the test.

Task 3, Final Software Tool The Contractor shall develop the Software Tool based on the test results of the Software Tool Prototype and build the final version of the Software Tool. Delivery of the Software Tool shall include the following documents and files:

· Required files to implement the Software Tool on the production server and on the clients.

· Software Tool Documentation which describes how the software tool works, how to install the tool on the server and clients and source code for the tool itself.

Deliverables Number/ Reference

Standards for Acceptance of Deliverables:

The NIST TPOC will provide written comments on each deliverable within fifteen (15) calendar days from receipt of a given deliverable. The Contractor shall make any needed changes and resubmit the deliverables within 15 calendar days from receipt of electronic or written comments from the TPOC. The TPOC will provide written notification via email when a deliverable is accepted.

Performance Requirement Summary

Performance Standard Monitoring Method

Revise Software Tool Development Plan as required Deliver all drafts and final Software Tool Development Plan no later than (NLT) the delivery due date All submitted Software Tool Plans will be reviewed and approved by the Technical Point of Contact (TPOC)

Deliver the files NLT than the delivery due date 100% review and approval by the TPOC

Deliver the instruction manual NLT the delivery due date 100% review and approval by the TPOC

Deliver the files NLT than the delivery due date 100% review and approval by the TPOC

Revise document as required Deliver all drafts and final description document no later than (NLT) the delivery due date All submitted description documents will be reviewed and approved by the Technical Point of Contact (TPOC)

Government Furnished Property All property, data and information provided by the Government in the performance of this task remains the property of the Government and shall be surrendered to the Government upon completion or termination of this requirement. Likewise, all deliverables generated under this requirement remain the property of the Government.

Upon award of this requirement the Government shall provide the Contractor with all access to all equipment and resources needed in the performance of this requirement.

The Government will provide a copy of the production PTC Creo Elements/Direct Manager Server database as well as site customizations in use at the NCNR.

Place of Performance All work is to be performed at the contractors site.

Period of Performance Period of performance shall be 6 months after award offer (ARO).

Contractor Qualifications

· No less than 10 years of experience working with Creo Elements Direct.

· No less than 5 years of experience configuring and customizing Creo Elements Direct software for clients.

· Must provide documentation which demonstrates experience.