Duration Calibration Template
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Explanation: how my duration calibration spreadsheet works
2
https://complice.co/$USERNAME/user.css
3
↳ use this url to get your goal colors
4
https://complice.co/
estimate bounds
green means it went faster than expected, red slower
5
↓ conditionally colored by my complice goal colorlowerupper
actual time
↓ calculated automatically...
6
goalThingLUAErrorCauseNotes
7
==== February 23910
← this row shows aggregates for each day (you have to manually adjust the sum's range)
8
1
construct query to get users to send monthly to
136-100%scope creep
9
3colorize yearly payers differently264taste
10
↑ common causes for me
11
To usetaste
I tweak the UI more than I anticipated to make it look pretty
12
1. Enter a lower and upper estimate for how long the task will take.
complexitysomething unanticipated required to make it work
13
2. Start a timer that counts up. I like this one:
prodistraction
I do other useful things that aren't required for the timed task
14
http://www.yeahit.com/stopwatchdistractionI do something totally useless
15
3. Work on that task (and only that task!)confusion...huh?
16
4. When you're done, come back and enter the timed time under the A column
17
Repeat!
18
By Malcolm Ocean
19
Once you've read the above,
http://malcolmocean.com/
20
Click the 2017 tab down here to get started
malcolm@malcolmocean.com
21
22
23
24
25
26
27
28
29
30
31
(stop scrolling :P it's outside of the sheet!)
32
33
34
35
36
37
38
39
40
41
42
43
44
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
100
Loading...
 
 
 
Explanation
2017