This excel is composed of a few tabs:1. How to Use
This is the first tab and its purpose is to give you guidance on how to use it and what are the purposes and goals of this tool.2. Template
Here is where the magic happens. The "Template" tab is the main point of entry for data for the UX audit and its UX debt calculator. Fulling this tab will generate the results and graphs that you need to help your team(s) to make better decisions.3. UX Audit Results
Use this tab to uncover where your experience is failing your users. As soon as you start filling out the 'Template' tab, this session will automatically start generating visual graphs to illustrate where your experience is been weaker. You will be able to analyze the experience not only by heuristics but also breaking it down by sub-heuristics.4. Design Debt Results
This tab does exactly the same as the previous one, but instead of covering the heuristics been audited, it will provide you feedback regarding your volume of design debt. Here, you will uncover where your symptoms. As soon as you start filling out the 'Template' tab, this session will automatically start generating visual graphs to illustrate where your design needs the most payout. You will be able to analyze the debt not only by heuristics but also by UX, visual, and operational design debt.5. Impact-effort Matrix
Do you have lots of work that waiting to prioritize?
It is much compeller to prioritize when you have a great number of works to do. It is essential to standardize your decision-making method. This excel will help you do that in a very simple method. By using an Impact-Effort Matrix. In this tab, you will know which work is not worth the effort, which work you should address first, and the work you maybe can consider for later. In this way, it will be much easier to eliminate the works which not contribute to your business value.6. Issues Distribution
Visual reference of the distribution of issues per Severity and Heuristic.7. Lookup Heuristics
All of these metrics were retrieved from the scientific contribution of Nielsen and Norman.
- Nielsen, J. (1995). 10 Usability Heuristics for User Interface Design
- Nielsen, J. (1994). Enhancing the explanatory power of usability heuristics
. In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (CHI '94). Association for Computing Machinery, New York, NY, USA, 152–158.