Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Metrics in Excel
Topic Summary:
Created On: 12-May-2008 16:48
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 12-May-2008 16:48
User is offline View Users Profile Print this message


Brandi McLeod

Posts: 9
Joined: 12-Mar-2008

I want to export metrics to an Excel spreadsheet, but not just a total count. I need the code to identify the object text that contains TBD, list each object, and then for each TBD that's listed, look under the attribute "verification status" and display either Yes or No in the next column for each TBD listed.
Report this to a Moderator Report this to a Moderator
 12-May-2008 16:59
User is offline View Users Profile Print this message


Brandi McLeod

Posts: 9
Joined: 12-Mar-2008

I realize that it is easy to show with a filter, however, I need this status reported monthly to show a trend in the data, which is why I would like a script, so it can be done automatically.
Report this to a Moderator Report this to a Moderator
 12-May-2008 17:36
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

You just make a DXL program that you call from a batch file nightly or monthly. And you can apply your filter in DXL.

But heres a quick and dirty. You can find my Excel functions include file with a quick search.

EDIT: I put it up on Kevin's site.

Excel Interface

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com

Edited: 12-May-2008 at 18:35 by David Pechacek
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.