Thursday, June 16, 2016

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

 for i = 1 to len(str)
 b = mid(str,i,1)
 if isnumeric(b) then
 ElseIf (asc(b)>=97)and (asc(b)<=122) or asc(i)>=65 and asc(i)<=90 then
 End if
 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 

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.

Saturday, September 12, 2015

Test Metrics


Couple of Test Matrics formulas.

Formulae :
Test Coverage (%) = (No. of Test Cases Executed / No. of Test Cases Planned) * 100
Test Case Effectiveness (%) = (1 - (No. of Inadeqaute Test Cases Detected / Actual No. of Test Cases)) * 100
Quality of Testing (%) = (No. of Defects Accepted / No. of Defects Reported) * 100
Automation Suite Test Coverage (%) = (No. of Test Cases Automated / Total No. of Test Cases) * 100
Environmental Availability (%) = (1 - (Total Down Time / Total Cycle Time)) * 100


Saturday, April 18, 2015

About Capital Market

Financial markets can be categorized into two types. 1.Money markets 2.Capital markets Money markets are the markets through which governments or corporates raise money to meet their short term money requirements (like meeting their working capital requirements). The government, through money markets can raise money for very short periods like 15 days also. Capital markets are the markets through which corporate bodies raise money for their long term needs Capital markets can again be categorise as 1.primary markets 2.Secondary markets

Friday, December 12, 2014

Remove leading 0 from number-formatnumber


Remove leading 0 from number using QTP. For example 0.09 should display. 09

Msgbox Strnew
'output is . 09

Msgbox strnew
'output is 20,000.00

'output 20,000.00
'output 20,000.00000 setting number of decimals
'output 0.20 with leading 0
'output -50.00 negative value
'output (50.00) negative value inside parenthesis
'output 1000000.00 not grouping number
'output 1,000,000.00 grouping number