Thursday, June 16, 2016

To Find alphabets, numbers and special char count from given string

str="Trupti12345@gmail.com"
 numbers=0
 alphabets=0
 specialchar=0
 for i = 1 to len(str)
 b = mid(str,i,1)
 if isnumeric(b) then
  numbers=numbers+1
 ElseIf (asc(b)>=97)and (asc(b)<=122) or asc(i)>=65 and asc(i)<=90 then
  alphabets=alphabets+1
 else
  specialchar=specialchar+1
 End if
 next
 msgbox numbers
 msgbox alphabets
 msgbox specialchar

Monday, June 13, 2016

ROI- Return on Investment

Automation of software testing process always sounds good to Test Managers. Intuitively, you see that creating an automated test one time and then running it hundreds or thousands of times will enable you to expand test coverage, find defects earlier, and focus manual test effort where it is really needed.

Thought of sharing the basic formula for calculating ROI(Return on Investment):-

 Automation Cost = Price Of Hardware + Price of Software(Tools) + Development Cost + Maintenance Cost + Execution Cost

Manual Testing Cost = Development Cost + Maintenance Cost + Execution Cost

 ROI = (Manual Testing Cost - Automation Cost)/Automation Cost

 Now as Regression increases, thus resulting in repeat ion in execution of Test cases, it results in surge in ROI by Automation Tool.

We can say that general Principle for Automation is "More Repetitive tasks are ideal candidate for Automation" producing more ROI

The aim is to have an ROI >>> than 1 

ROI=Gain-Investment/Investment
Gain=Manual Test Execution/Analysis time * Total no of TCs(manual+automated)* period of ROI/8
Investment= A+B+C+D+E

(a) Automated test script development time = (Hourly automation time per test * Number of automated test cases) / 8
(b) Automated test script execution time = (Automated test execution time per test * Number of automated test cases*Period of ROI) / 18
(c)Automated test analysis time = (Test Analysis time * Period of ROI) / 8
(d) Automated test maintenance time = (Maintenance time * Period of ROI) / 8
(e) Manual Execution Time = (Manual test execution time * Number of manual test cases * Period of ROI) / 8

Notes: Period of ROI is the number of weeks for which ROI is to be calculated. Divided by 8 is done wherever manual effort is needed. Divided by 18 is done wherever automation is done. In this method, time investment gains are considered rather than monetary gains. Once gains and investment costs are calculated, we can insert the values of these variables into the formula and get the total Efficiency ROI. In the Efficiency ROI calculation method in test automation, focus is on the actual efficiency of the automation and not just the money factor.