Download
Version: 2.1.1 - New Tools Release
Release Date: July 18, 2011
System Requirements
Windows 2000 SP3+, Windows X SP2+, Windows Vista, Windows 7
Excel 2002 or greater
Office XP Tool: Web Components [free from Microsoft] not required from version 1.2.2+
Optional: Microsoft Outlook 2000 or greater [required to automatically email reports]
Optional: ClearQuest windows application (required only for ClearQuest reports)
Optional: QualityCenter application (required only for QualityCenter reports)
Optional: MS Project (required only for reports from MS Project files)
New Excel Tools To Enter Formulas For You
Count of Cells With A Special Condition
Count - cells that contain odd numbers Count - cells that contain even numbers Count - cells that are evenly divisible by a number Counf if cells = TRUE Count if cells = FALSE
Count of Cells With Errors
#DIV/0! errors in a range #GETTING_DATA errors in a range #N/A errors in a range #NAME? errors in a range #NULL! errors in a range #NUM! errors in a range #REF! errors in a range #VALUE! errors in a range errors in a range
Count Cells in a Filtered List That Match Criteria
Count - exact string match in filtered data Count - filtered data that CONTAINS a string Count - filtered data that does NOT contain a string Count - filtered data that CONTAINS a string (case sensitive) Count - filtered data that does NOT contain a string (case sensitive) Count - exact number match in filtered data Count - cells greater than > a number in filtered data Count - cells greater than or equal to >= a number in filtered data Count - cells less than < a number in filtered data Count - cells less than or equal to <= a number in filtered data
Dates
Formula that determines if a cell contains a leap year
Hyperlinks
Hyperlink To Cell on the Same Worksheet Hyperlink To Cell in the Same Workbook
Fixes
Fixed link to request a new tool
Microsoft Project Extension Available
Create reports from Microsoft Project plans using the RNA-Project extension. This extension requires ReportsDNA 1.1 or greater. ReportsDNA 1.1 includes the RNA-Project extension in your installation folder (the default folder is c:\Program Files\ReportsDNA).
HP Quality Center Extension
Create defect reports from HP Quality Center using the RNA-QualityCenter extension. This extension requires ReportsDNA 1.1 or greater
ReportsDNA / ReportZilla Uninstaller
Note: This download is not needed by ReportsDNA 1.4 or greater as it includes an automated uninstaller.
This spreadsheet will uninstall ReportsDNA and ReportZilla from all versions of Excel. It can also delete ReportsDNA and ReportZilla to ensure Excel doesn't load older versions that exist on our computer.
