Duration Calibration Template

	A	B	C	D	E	F	G	H	I
1	Explanation: how my duration calibration spreadsheet works
2			https://intend.do/$USERNAME/user.css
3			↳ use this url to get your goal colors
4			https://intend.do/	estimate bounds			green means it went faster than expected, red slower
5		↓ conditionally colored by my complice goal color		lower	upper	actual time	↓ calculated automatically...
6		goal	Thing	L	U	A	Error	Cause	Notes
7		==== February 2		3	9	10		← 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	1	3	6	-100%	scope creep
9		3	colorize yearly payers differently	2	6	4	✓	taste
10								↑ common causes for me
11			To use					taste	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.					complexity	something 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/stopwatch					distraction	I 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 2024 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