RPA Bot Development for Excel Calculations
Budget: $50 – $60 USD
Hello, I need to create a small RPA bot with Automation Anywhere according to the following details:
Overview
Your bot must get some information from a Microsoft Excel file, perform some calculations on the data, and write it to a new Microsoft Excel file.
Business Rules
The bot you build must adhere to these instructions:
Download the source data from here:
https://rpademo.automationanywhere.com/autograder/usecases/acme_weighbridge_sw_output.xlsx
and save it to your local drive.
Create a new Excel output file. Use the headings found at the end of this document.
Perform the following calculations on the source data and put it into the new Excel output file:
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 receive a 3% discount on Total Before Deductions and Charges if an all-electric or petrol hybrid-electric vehicle is used. If the deduction is not applicable, the value of the cell is 0 (zero).
d. Hazardous waste disposal incurs a levy of 50%.
Non-hazardous waste has no additional levy.
Hazardous waste tax must be calculated based on the Total before deductions and charges.
e. Total after deductions and charges = Total before deductions and charges - Green vehicle discount + hazardous waste tax.
f. Any number or currency value should only contain the number only, no extra characters, rounded to the nearest 2 decimal points.
For example: 23456.78 or 123.4, not $23,456.78 or 123.456789.
Use only the following Packages in your bot:
Browser
If
Loop
Number
Excel Advanced or Excel Basic
Comment and/or Step
File
Submitting Your Bot
During bot development, take note of the URL of each bot in edit mode. You will need these three URLs when you submit your bots for grading.
Example:
https://community2.cloud-2.automationanywhere.digital/#/bots/repository/private/taskbots/12345/edit
Keep your use cases in the order that they are assigned to you. Name your output files so you can remember which of the three use cases it is for.
Example: usecase1.xlsx
Return to Automation Anywhere University and continue your Master Certification course to the Bot Submission section.
Final Notes
The format of the output file must be as follows (headings must be on one line):
HEADER: Customer Name | Total Weight Deposited (KG) | Total before deductions and charges | Ref. No. | Green Vehicle Discount | Hazardous Waste Tax | Total after deductions and charges:
RECORD: ABC Company | 12345 | 123.45 | 1 | 12.34 | 23.45 | 246.8
I need the bot to run and generate the requested output, and for the submission we will meet to share the information: Please apply only if you have experience in RPA automation. The deadline is 8 calendar days
Overview
Your bot must get some information from a Microsoft Excel file, perform some calculations on the data, and write it to a new Microsoft Excel file.
Business Rules
The bot you build must adhere to these instructions:
Download the source data from here:
https://rpademo.automationanywhere.com/autograder/usecases/acme_weighbridge_sw_output.xlsx
and save it to your local drive.
Create a new Excel output file. Use the headings found at the end of this document.
Perform the following calculations on the source data and put it into the new Excel output file:
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 receive a 3% discount on Total Before Deductions and Charges if an all-electric or petrol hybrid-electric vehicle is used. If the deduction is not applicable, the value of the cell is 0 (zero).
d. Hazardous waste disposal incurs a levy of 50%.
Non-hazardous waste has no additional levy.
Hazardous waste tax must be calculated based on the Total before deductions and charges.
e. Total after deductions and charges = Total before deductions and charges - Green vehicle discount + hazardous waste tax.
f. Any number or currency value should only contain the number only, no extra characters, rounded to the nearest 2 decimal points.
For example: 23456.78 or 123.4, not $23,456.78 or 123.456789.
Use only the following Packages in your bot:
Browser
If
Loop
Number
Excel Advanced or Excel Basic
Comment and/or Step
File
Submitting Your Bot
During bot development, take note of the URL of each bot in edit mode. You will need these three URLs when you submit your bots for grading.
Example:
https://community2.cloud-2.automationanywhere.digital/#/bots/repository/private/taskbots/12345/edit
Keep your use cases in the order that they are assigned to you. Name your output files so you can remember which of the three use cases it is for.
Example: usecase1.xlsx
Return to Automation Anywhere University and continue your Master Certification course to the Bot Submission section.
Final Notes
The format of the output file must be as follows (headings must be on one line):
HEADER: Customer Name | Total Weight Deposited (KG) | Total before deductions and charges | Ref. No. | Green Vehicle Discount | Hazardous Waste Tax | Total after deductions and charges:
RECORD: ABC Company | 12345 | 123.45 | 1 | 12.34 | 23.45 | 246.8
I need the bot to run and generate the requested output, and for the submission we will meet to share the information: Please apply only if you have experience in RPA automation. The deadline is 8 calendar days