Importing your responses using a spreadsheet is helpful if there are many lines in a large negotiation.
To download a spreadsheet and prepare your bid or quote offline:
Access the open negotiation to which you wish to respond.
From the negotiation summary page, select Create Quote/Bid/Respond from the Actions menu and click Go.
On the Create Quote/Bid/Response page, click Quote/Bid/Respond By Spreadsheet.
On the Quote/Bid/Respond By Spreadsheet page, select the type of spreadsheet format you wish to use: XML Spreadsheet or Tab-Delimited (you can open the XML Spreadsheet in Excel if you have version 2003 or later). If you choose Tab delimited, you will also have to select which spreadsheet you wish to download: Requirement or line. Click Export.
If the negotiation you are responding to is a very large negotiation, a concurrent program is generated to create the spreadsheet. When you click Export, you receive a Confirmation message that contains a link to the Download Requests page. You can monitor the progress of the job from this page, and once it completes, you can click the link provided to down the completed spreadsheet.
Save the spreadsheet file to a convenient location.
Open the spreadsheet file and complete according to the instructions in the Read Me file included in the zip. Save the file.
Navigate back to the Quote/Bid/Respond By Spreadsheet page.
Select the format of the spreadsheet you wish to import Browse to the location where you saved your spreadsheet file. Click Import. The system will validate the response information you entered in your spreadsheet.
Verify the details of your quote/ bid/response. If there are errors, click Quote/Bid/Respond By Spreadsheet to access and correct your spreadsheet file. Once you have corrected your file, upload again.
On the Create Quote/Bid/Response page, click Continue to review the details of the quote/bid/response process.
On the Review and Submit page, click Submit to submit your quote/bid/response.
The Bid Confirmation/Quote Confirmation/Response Confirmation page displays your bid/quote/response number.
If this is a large or very large negotiation, the response submission is performed by a concurrent program. You can monitor the progress of this job by clicking the link to the Manage Draft Reponses page. Once the response submission is complete, your response appears with a status of active on the Negotiation Home page under Your Active and Draft Responses.