Effort estimates for 4 processes

rpa_efforts_estimates.md

RPA Effort Estimate

Summary

Total : 96 Hours (12 Days)

Development : 72 Hours (8 days)

Testing : 24 Hours (3 days)

Scope

Transfer rates from Currency Conversion sheet received via Mail to Application 1

Effort Estimates

Development Efforts : 32 hours of development effort

Testing Efforts : 8 hours of development effort

Steps

1. Open Application 1
   1. If required login to application
   2. Navigate to desire form
2. Login to mailbox
3. Read all unread emails from specific "from" address
4. Look for emails that has Excel as attachment with specific name
5. Download this attachment in some folder
6. Read downloaded excel
7. For each row read three cells (source currency, target currency, conversion rate)
8. Read above data and input in given form controls
9. Submit to application

Transfer rates from Currency Conversion sheet received via Mail to Application 2

Assumption : This application is different, and we cannot reuse code. But since steps are same efforts will be less.

Development Efforts : 24 hours of development effort

Testing Efforts : 8 hours of development effort

Steps

1. Open Application 1
   1. If required login to application
   2. Navigate to desire form
2. Login to mailbox
3. Read all unread emails from specific "from" address
4. Look for emails that has Excel as attachment with specific name
5. Download this attachment in some folder
6. Read downloaded excel
7. For each row read three cells (source currency, target currency, conversion rate)
8. Read above data and input in given form controls
9. Submit to application

Look up data from 1st website and save the screen grab to the user’s desktop.

Development Efforts : 8 hours of development effort

Testing Efforts : 4 hours of development effort

Steps

1. Login to web application
2. Navigate to require web page
3. Take a screenshot
4. Save it to desktop folder

Look up data from 2nd website and save the screen grab to the user’s desktop

Assumption : This application is different, and we cannot reuse code

Development Efforts : 8 hours of development effort

Testing Efforts : 4 hours of development effort

Steps

1. Login to web application
2. Navigate to require web page
3. Take a screenshot
4. Save it to desktop folder

Assumptions

• This project will be shared using Github
• Installation and management of UiPath infrastructure on machines(prod, stage, test) is out of scope (Attended and Unattended assistants)
• Managing and deploying of project on different environment(prod, stage, test) is out of scope.
• Scheduling of processes is out of scope

Prerequisites for testing

• Microsoft Outlook/Exchange credentials
• Login access to 2 Web applications