Automation Anywhere Certified Master
RPA Professional (A2019)
Use Case 2 for Bot Development
This document contains instructions to build a bot for Use Case 2. In this use case, you will build
a bot for a garbage disposal company to calculate weight fees based on vehicle type and
specific criteria for disposing the garbage in a landfill.
Detailed instructions for bot submission are available in the Additional References tab on
Automation Anywhere Certified Master RPA Professional (A2019). Any deviation in following
the instructions will lead to an invalid attempt.
If you have any additional queries, send an email to learning@automationanywhere.com
or submit a query on the Automation Anywhere Contact us page.
Prerequisites
Ensure you have access to:
• Automation Anywhere Community Edition or any cloud instance (on-prem is not
allowed)
• Master Certification Bot Exporter
USA Headquarters Phone Email
633 River Oaks Pkwy. +1.888.484.3535 {sales} sales@automationanywhere.com
San Jose, CA 95134 +1.408.834.7676 {intl}
Building the Bot
Build a bot to automate the process using Automation Anywhere Community Edition.
The bot must perform the following steps:
1. Copy the Blank Total Cost and Weight.xlsx file to a file name in this format:
youremailaddress_Bot_2_Output.xlsx.
2. Read the ACME_Weighbridge_SW_Output.xlsx file and perform the calculations based
on the criteria stated below. Write the results to the new file in the appropriate
columns.
a. Calculate the Total Weight Deposited (KG) by subtracting the Weight on
Departure from the Weight on Entry.
b. The Total before deductions and charges is based on a per metric ton basis.
• Public sector customers pay $2 per metric ton
• Private sector enterprises pay $20 per metric ton
• 1000kg = 1 metric ton
c. Customers to receive a 3% discount on Total Before Deductions and charges, if
an all-electric or petrol hybrid-electric vehicle is used. In case deduction is not
applicable, then value of cell to be set as 0.
d. Hazardous waste disposal incurs a levy of + 50%. In case not applicable then
value to be set as 0. Hazardous waste tax must be calculated based on Total
before deductions and charges.
e. Total after deductions and charges = Total before deductions and charges -
Green Value Discount + Hazardous Waste Tax.
f. Any number or currency value depicted should only contain the number and no
separators. For example:
• Accepted format: 234567
• Not accepted format: 234,567 or $234567
• The output should not have any extra spaces or special characters
USA Headquarters Phone Email
633 River Oaks Pkwy. +1.888.484.3535 {sales} sales@automationanywhere.com
San Jose, CA 95134 +1.408.834.7676 {intl}
Important Note
Do not manually modify the output Excel file or the text automation listing. Your bots will be
graded using an automated system and extraneous edits or modifications will disqualify your
submission.
Read the Instructions for Bot Submission document before you submit the bot files. For
example, if you choose to submit a CSV file instead of an Excel file, your submission will be
marked as invalid.
All the relevant documents are available in the Additional References tab on Automation
Anywhere Certified Master RPA Professional (A2019).
Good luck and Go Be Great!
USA Headquarters Phone Email
633 River Oaks Pkwy. +1.888.484.3535 {sales} sales@automationanywhere.com
San Jose, CA 95134 +1.408.834.7676 {intl}
