Orchestra Technology

1. Requirements

Microsoft Office Excel 2007

2. Objective

Recently, I was engaged on a project to review a .NET application code. At the beginning, while clarifying customer’s expectations about the output of this job, I have found that customer wanted to have a dashboard that could him to have an idea of the “healthy” of the application or to help him to decide when a version would be ready to be deployed in production.

First, I defined 4 categories of issues that could be found during revision process: performance, scalability, maintainability and security. Also, I have attributed to each on these categories a threshold based on what customer feels it is more important. The sum of these values cannot exceed 100% because “an application that needs to be very secure will not be as fast as it could be”.

This is very handy because companies of different segments have different expectations about software, for example, on one hand security could be a number one priority for financial companies, on the other hand performance could be a priority for telemarketing companies.

3. Walkthrough

Enter the name of all development team members in the People sheet:

Enter the types of issues that can be found during code revision and their thresholds on the Threshold sheet. Remember that the sum of theses values cannot exceed 100%:

Review the application code and fill up the Defects sheet:

Follow the results on the Report sheet and discuss them with your caustomer: