Account Options>

  1. Sign in
Spreadsheet documentation template
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
Descriptive Title
2
AuthorPeter J MELLALIEU
3
Creation date1/8/2013
4
Modification date8/8/2013
5
Version1.1
6
7
PURPOSE
8
A succinct description of what the spreadsheet achieves, including key inputs, and outputs produced.
9
10
11
12
INPUTS
13
Keep all input data close to the top of your spreadsheet. Signal the place where the user enters input data .
14
15
16
17
OUTPUTS
18
Present the flow of your calculations in a natural flow from top to bottom, left to right. Annotate the tables with a brief heading description.
19
20
21
22
LIMITATIONS
23
Detail warnings about the range of problems and data to which the spreadsheet can be applied. Document all assumptions.
24
25
26
27
QUALITY ASSURANCE
28
Provide details of how the spreadsheet was tested or audited.
29
30
31
32
MODIFICATION HISTORY
33
Notes about the modifications made according to version number.
34
35
36
37
NOTES
38
39
40
41
42
REFERENCES
43
Mellalieu, P. J. (2013, August 2). Guidance on best practice for spreadsheet design. Innovation & chaos ... in search of optimality. Retrieved August 1, 2013
44
Barlow, J. (2006, January 9). Excel Models for Business and Operations Management [online e-book]. John Wiley & Sons.
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
Loading...
 
 
 
Sheet1