Spreadsheet: 538116d1505410596-function-or-pivot-table-oeldere-538112d1505409182-function-or-pivot-table-forum-example
Sheet: Sheet1

Lesson Number | Expected Duration |  |  |  | Students
 |  | Student 1 |  |  | Student 2 |  |  | Student 3
Lesson Number | Expected Duration | Instructor | Actual Hours | Diff | Instructor2 | Actual Hours3 | Diff4 | Instructor5 | Actual Hours6 | Diff7
1 | 1.4 | [NAME] | 1.4 | 0 | [NAME] | 1.1 | -0.2999999999999998 | [NAME] | 1.5 | 0.1000000000000001
2 | 1.4 | [NAME] | 1.4 | 0 | [NAME] | 1.4 | 0 | [NAME] | 1.4 | 0
3 | 1.4 | [NAME] | 1.5 | 0.1000000000000001 | [NAME] | 1.4 | 0 | [NAME] | 1.4 | 0
4 | 1.4 | [NAME] | 1.5 | 0.1000000000000001 | Adam | 1.4 | 0 | [NAME] | 1.4 | 0
5 | 1.2 | [NAME] | 0.5 | -0.7 | [NAME] | 1.3 | 0.1000000000000001 | Adam | 1.4 | 0.2
6 | 1.4 | [NAME] | 1.4 | 0 | [NAME] | 1.4 | 0 | [NAME] | 1.2 | -0.2
7 | 1.2 | [NAME] | 1.1 | -0.09999999999999987 | [NAME] | 1.2 | 0 | [NAME] | 1.1 | -0.09999999999999987
8 | 1.2 | [NAME] | 1.1 | -0.09999999999999987 | [NAME] | 1.2 | 0 | [NAME] | 0.7 | -0.5
9 | 1.2 | [NAME] | 1.3 | 0.1000000000000001 | [NAME] | 1.2 | 0 | [NAME] | 0.7 | -0.5
10 | 1.2 | [NAME] | 1.3 | 0.1000000000000001 | [NAME] | 1.1 | -0.09999999999999987 | Adam | 1.3 | 0.1000000000000001
11 | 1.2 | [NAME] | 1.5 | 0.3 | [NAME] | 1 | -0.2 | [NAME] | 1.1 | -0.09999999999999987
12 | 1.2 | [NAME] | 1.5 | 0.3 | [NAME] | 1.2 | 0 | [NAME] | 0.5 | -0.7
13 | 1.2 | [NAME] | 1.4 | 0.2 | [NAME] | 0.9 | -0.2999999999999999 | [NAME] | 1.5 | 0.3
14 | 0.8 | [NAME] | 0.9 | 0.09999999999999998 | [NAME] | 0.9 | 0.09999999999999998 | [NAME] | 0.9 | 0.09999999999999998
15 | 1.2 | SELF | 1.3 | 0.1000000000000001 | [NAME] | 1.1 | -0.09999999999999987 | [NAME] | 1.2 | 0
16 | 1.2 | [NAME] | 1.2 | 0 | [NAME] | 1.4 | 0.2 | [NAME] | 1.1 | -0.09999999999999987
17 | 1 | [NAME] | 0.9 | -0.09999999999999998 | [NAME] | 1.4 | 0.3999999999999999 | [NAME] | 1.1 | 0.1000000000000001
18 | 1.2 | [NAME] | 1.2 | 0 | Adam | 1 | -0.2 | [NAME] | 1.3 | 0.1000000000000001
19 | 1.3 | [NAME] | 1.3 | 0 | Adam | 1.4 | 0.09999999999999987 | [NAME] | 1.2 | -0.1000000000000001
20 | 1.4 | [NAME] | 1.5 | 0.1000000000000001 | [NAME] | 1.3 | -0.09999999999999987 | [NAME] | 1.3 | -0.09999999999999987
21 | 1.4 | [NAME] | 1.3 | -0.09999999999999987 | [NAME] | 1.4 | 0 | [NAME] | 1.3 | -0.09999999999999987
22 | 1.6 | [NAME] | 1.3 | -0.3 | [NAME] | 1.5 | -0.1000000000000001 | Adam | 1.5 | -0.1000000000000001
23 | 1.5 | [NAME] | 1.4 | -0.1000000000000001 | [NAME] | 1.5 | 0 | [NAME] | 1.5 | 0
24 | 1.4 | [NAME] | 1.5 | 0.1000000000000001 | [NAME] | 1.4 | 0 | [NAME] | 1.2 | -0.2
25 | 1.5 | [NAME] | 2.2 | 0.7000000000000002 | [NAME] | 2 | 0.5 | [NAME] | 2.3 | 0.7999999999999998
26 | 1 | [NAME] | 1 | 0 | [NAME] | 1 | 0 | [NAME] | 1.1 | 0.1000000000000001
27 | 1 | [NAME] | 0 | -1 | [NAME] | 0 | -1 | [NAME] | 0 | -1
28 | 1 | [NAME] | 1.1 | 0.1000000000000001 | [NAME] | 1.2 | 0.2 | [NAME] | 1.1 | 0.1000000000000001
29 | 1 | [NAME] | 0 | -1
30 | 1.4 | [NAME] | 1.4 | 0 | [NAME] | 1.7 | 0.3 | [NAME] | 1.2 | -0.2
31 | 1.4 | [NAME] | 0.5 | -0.8999999999999999 | [NAME] | 1.3 | -0.09999999999999987 | [NAME] | 1.6 | 0.2000000000000002
32 | 1.5 | [NAME] | 1.7 | 0.2 | [NAME] | 1.5 | 0 | [NAME] | 1.6 | 0.1000000000000001
33 | 1.6 | [NAME] | 1.7 | 0.09999999999999987 | [NAME] | 1.7 | 0.09999999999999987 | [NAME] | 1.6 | 0
34 | 1.6 | [NAME] | 1.7 | 0.09999999999999987 | [NAME] | 1.3 | -0.3 | [NAME] | 1.9 | 0.2999999999999998
35 | 1.5
36 | 1 | [NAME] | 0 | -1 | [NAME] | 0 | -1 | [NAME] | 0 | -1
37 | 1 | [NAME] | 0 | -1 | [NAME] | 0 | -1 | [NAME] | 0 | -1
38 | 1 | [NAME] | 0 | -1 | [NAME] | 0 | -1 | [NAME] | 0 | -1
39 | 1 | [NAME] | 0 | -1 | [NAME] | 0 | -1 | [NAME] | 0 | -1
40 | 1.5 | [NAME] | 1.5 | 0 | [NAME] | 1.6 | 0.1000000000000001 | [NAME] | 1.4 | -0.1000000000000001
41 | 1.9 | [NAME] | 1.8 | -0.09999999999999987 | Amanda | 1.9 | 0 | [NAME] | 1.7 | -0.2
42 | 2.6 | [NAME] | 2.8 | 0.1999999999999997 | [NAME] | 2.8 | 0.1999999999999997 | [NAME] | 2.9 | 0.2999999999999998
43 | 2.3 | [NAME] | 2.2 | -0.09999999999999964 |  |  |  | [NAME] | 2.1 | -0.1999999999999997
44 | 2.8 | [NAME] | 1.4 | -1.4 |  |  |  | [NAME] | 1.5 | -1.3
45 | 2 |  |  |  | [NAME] | 2.1 | 0.1000000000000001 | [NAME] | 1.6 | -0.3999999999999999
46 | 2 | Nick | 0.9 | -1.1 | Nick | 2.2 | 0.2000000000000002
47 | 1.4 | [NAME] | 1.4 | 0 | [NAME] | 1.4 | 0
48 | 1.2 | [NAME] | 1.2 | 0 | [NAME] | 1.2 | 0