The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Quality Engineering >> Quality Methodologies

Pages: 1
marcio10
Newbie


Reged: 06/19/12
Posts: 7
Excel Software Quality metrics templates
      #710828 - 06/27/12 01:13 AM

Hi,
I am looking for excel software quality metrics templates.
Since I am not proficient with Excel I thought of using your help to find some pre defined templates which I can use and just reconfigure the values/column names etc.
Thanks in advance
Meir


Post Extras: Print Post   Remind Me!   Notify Moderator  
Joe Strazzere
Moderator


Reged: 05/15/00
Posts: 12344
Loc: Massachusetts, USA
Re: Excel Software Quality metrics templates [Re: marcio10]
      #710846 - 06/27/12 04:42 AM

What kind of metrics do you collect?

--------------------
- Joe
Visit AllThingsQuality.com to learn more about quality, testing, and QA!

I speak only for me. I do not speak for my employer, nor for anyone else.


Post Extras: Print Post   Remind Me!   Notify Moderator  
marcio10
Newbie


Reged: 06/19/12
Posts: 7
Re: Excel Software Quality metrics templates [Re: Joe Strazzere]
      #710854 - 06/27/12 05:32 AM

Currently there are 2 types I need:
How many customer bugs were opened per week and the ration between opened and resolved bugs


Post Extras: Print Post   Remind Me!   Notify Moderator  
AUF_Testing
Newbie


Reged: 02/26/11
Posts: 18
Re: Excel Software Quality metrics templates [Re: marcio10]
      #713563 - 08/01/12 03:27 PM

Ok, next question:

What bug/defect tracking tool it used (or is it Excel) and how are the incidents imported into Excel?

From the glimpse you've provided, I'd say a lot of the hard work should be done by the 'creator' of the data you're using.

Some more details would be great.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Shaili
Newbie


Reged: 08/03/12
Posts: 1
Re: Excel Software Quality metrics templates [Re: AUF_Testing]
      #713684 - 08/03/12 01:59 AM

Hi Meir,

Create three column named customer bugs(Open), customer bugs(Resolved), Ratio. In the ratio column use a formula (customer bugs(Open)/customer bugs(Resolved) by following below steps:
1) Click equals to
2) Select the cell where you have entered the value of customer bugs(Open)
3) Click / (Devide by)
4) Select the cell where you have entered the value of customer bugs(Resolved)
5)Press enter
6)Copy this formula and paste this in remaining cell

Hope this helps.

Regards,
Shaili


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 4 anonymous users are browsing this forum.

Moderator:  blueinatl, AJ, michaeljf, swt88 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 5720

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5