Simple VBA module for Microsoft Excel that batch processes data fro XML reports from ProjNet | Dr Checks exported from reviews. Consolidates data relevant for meets and collaboration, color-codes response statuses, and includes a user region for notes, etc.
Working on a bug where only the header region is created if there are no response comments (evaluations/backchecks). Working on updating this to at least provide the comments.
Success message opens as modal, while shell opens file location. Change message to report success and ask user if they want to open the file or folder, etc.
Will shortly add a feature that summarizes comment counts by:
discipline
reviewer
open vs closed (open ratio)
average closure time
It will also provide data on closed vs open comments.
Currently, the get days open function calculates how long comments have been sitting open. Will likely include some sort of reviewer latency rating along with the stats.
With regards to evaluator responses, will likely add the following: