ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Hours of Overlap Chart
2
by Mark Kilby (mark@markkilby.com) and Johanna Rothman (jr@jrothman.com)
3
If using the Google Sheets version, Go to File > "make a copy" to use this file
4
This sheet is intended for use by a distributed team to caculate their hours of overlap in their workday for possible collaboration times.
5
6
Instructions:
7
1) Copy one of the examples and modify to fit your teams as follows
8
2) Copy a line (blue) for each city and timezone represented
9
3) Create a row (white) for each team member in that city / timezone
10
4) Ask each team member to fill out their row as follows:
11
Mark 1 in each cell below an hour if they are working and available to the team for that entire hour.
12
If they are available less than that hour, indicate by how much (i.e. 0.5 for a half hour break)
13
If the team member is meeting with someone outside the team (even if in the same company), they should leave those hours blank.
14
If they step out for a couple of hours for personal reasons (exercise, meet with family or friends) on a regular basis, they should leave those hours blank
15
5) Make sure for each column that each team members availability is summed up in the corresponding Overlap Probability cell.
16
11insufficient
17
27minimal
In the Google Sheet version, the cell should automatically change color to indicate possible collaboration as shown.
18
44fair
19
83good
For the PDF version, you get to color your own.
20
100complete
21
22
For more information on hours of overlap and using these charts, see:
https://www.markkilby.com/hours-of-overlap-hoo/
23
24
This work is licensed as a ...
25
26
27
28
Mark Kilby
mark@markkilby.com
29
Johanna Rothman
jr@jrothman.com
30
31
Contributors:VersionDateContactContribution
32
M. Kilby & J. Rothman
7/11/2018(see above)original version
33
Andre Wyrwa1.211/30/2018
Improved the sufficient collaboration totals
34
M. Kilby1.33/22/2019
mark@markkilby.com
Made further improvements to the collaboration % totals
35
36
Andrew Blain1.410/26/2020
Created a version for R:AF to visualize daylight hours. Learn more at http://remoteagileframework.com
37
M. Kilby1.511/28/2020
mark@markkilby.com
Small updates for remote interviewing course at https://school.lucidmeetings.com/p/remote-interview-hire/
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