ABCDEFG
1
USABILITY TESTING MANAGEMENT TOOLV 0.9
2
This free spreadsheet will help you to plan, run, analyze and present usability testing studies, from the data collection to the solution prioritization. The primary audiences are UX researchers, designers and product managers. Feel free to copy, use, modify and share :-)

To start using it, just access the Sheets menu above: FILE > MAKE A COPY*

Comments, bug reports, suggestions?
3
Please visit my website:
www.carlosrosemberg.com
4
*NOTE: Do not add rows to any of the worksheets. Adding rows will negatively affect the formulas on all sheets.
5
HOW THIS SPREADSHEET IS ORGANIZED
6
SUMMARY
A brief consolidation of the data that can be used to generate, report and present the main takeaways of the study
7
TEST PLAN
The configuration tab, where the predefined values / parameters of your study can be set
8
ISSUES
The area for logging issues and comments
9
TASK PERFORMANCE
The area for calculating success rates and task times
10
SOLUTIONS
The area for defining and prioritizing solutions
11
12
13
VERSION HISTORY
14
15
09/21/20170.9Adding a count in the summary for the number of screens / elements tested
16
05/04/20170.8Issue frequency count now uses the function 'COUNT' instead of 'COUNTA' ; Participant description not required anymore; Participant profile/persona now is required
17
04/19/20170.7Adding 'Task' tab, adding test plan tab, new sumary tab, lots of bug fixes
18
12/06/20160.3Adding instructions to the "Tables and Graphs" area and minor updates in the look and feel
19
11/07/20160.2Adding history log
20
11/03/20160.1First public release
21
22
LICENSE (MIT)
23
24
Copyright (c) 2016 Carlos Rosemberg

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
25
26
27
28
29
30
See more: https://opensource.org/licenses/MIT
31
Modified 12/18/21 by Deborah Prewitt