210 likes | 431 Views
Rogers Sourcing Using Excel to Upload Responses into Ariba. Who should you call? Technical problems – contact Ariba Help Desk 1-866-218-2155 help.sourcing@ariba.com Content or process questions about the event Compose Message button. Assume the “Rule of Four” applies to YOU!
E N D
Rogers SourcingUsing Excel to Upload Responses into Ariba Who should you call? Technical problems – contact Ariba Help Desk 1-866-218-2155 help.sourcing@ariba.com Content or process questions about the event Compose Message button Assume the “Rule of Four” applies to YOU! It will take at least 4 attempts to upload a full RFX response successfully. So, either upload individual sections as you finish them or allow enough time before the event closes to fix any upload issues.
1 Download all attachment for review. Store in working folder.
2 Download Content (entire RFX text) and save to working directory. Refer to downloaded files as required for response.
Save to working folder, then Open for editing/preparation
Identify and Avoid the “Problem” questions: • Complex Multiple Choice • Attachments • Tables
Find “Comments” by cell (generally cell level explanations required in the Price tab) SAVE the worksheet
Begin to answer questions. Leave blanks as necessary.
1) Find the file to upload 2) Highlight the filename and click the Open button 3) Click the Upload button
Congratulations. Click OK to finish upload.
Open the online event to confirm your upload. Answer “tough” questions.
See the Answer Type column for help on how to respond. This will Fail.
Row 4 – Excel has a header row that Ariba ignores. So check the NEXT ROW (#5). Sheet 2 Requirements is the TAB to look on What Ariba didn’t like (Yes or No would be valid boolean answers) Make yourself read the Notice!!!!!!
1) Find the file to upload • Advice: • If you have answered any questions manually after you do an upload, you MUST download again. This ensures your changes are captured in the new worksheet. • Don’t attach files until the end of your upload process. • Don’t add comments until the end of your upload process. • X • X • x 2) Highlight the filename and click the Open button 3) Click the Upload button
Rogers SourcingUsing Excel to Upload Responses into Ariba Who should you call? Technical problems – contact Ariba Help Desk 1-866-218-2155 help.sourcing@ariba.com Content or process questions about the event Compose Message button Assume the “Rule of Four” applies to YOU! It will take at least 4 attempts to upload a full RFX response successfully. So, either upload individual sections as you finish them or allow enough time before the event closes to fix any upload issues.