Spreadsheet: 154519d1336471114-using-bins-in-excel-2007-not-for-histogram-methex-2
Sheet: Sheet2

 |  |  |  |  |  |  | Hours rule
Jobs requested per day | Probability |  | estimated time for job | Probability |  |  | Hours Available per worker | 7
2 | 0.1 |  | 2 | 0.1
3 | 0.2 |  | 3 | 0.1
4 | 0.3 |  | 4 | 0.3
5 | 0.4 |  | 5 | 0.3
 |  |  | 6 | 0.2
 |  |  |  |  |  |  |  |  | [NAME] turned down
Day | No. of jobs requested | ET J1 | ET J2 | ET J3 | ET J4 | ET J5 | Total job hours | Jobs accepted | no. | hours
1 | 2 | 2 | 2 |  |  |  |  | 2
2 | 5 | 5 | 2 | 4 | 5 | 6 |  | 3 | 2 | 9
3 | 4 | 2 | 2 | 4 | 6 |  |  | 3 | 1 | 2
4 | 5 | 4 | 3 | 4 | 5 | 3 |  | 4 | 1 | 5
5 | 4 | 4 | 5 | 6 | 2 |  |  | 3 | 1 | 4
6 | 5 | 5 | 6 | 3 | 4 | 5 |  | 3 | 2 | 10
7 | 3 | 4 | 3 | 2 |  |  |  | 3
8 | 3 | 2 | 4 | 4 |  |  |  | 3
9 | 4 | 4 | 4 | 4 | 5 |  |  | 2 | 2 | 8
10 | 3 | 2 | 4 | 4 |  |  |  | 3
11 | 2 | 3 | 2 |  |  |  |  | 2
12 | 5 | 6 | 6 | 6 | 6 | 6 |  | 2 | 3 | 18
13 | 4 | 5 | 4 | 2 | 6 |  |  | 3 | 1 | 4
14 | 3 | 2 | 3 | 4 |  |  |  | 2
15 | 3 | 4 | 6 | 5 |  |  |  | 2 | 1 | 4
16 | 2 | 5 | 4 |  |  |  |  | 2
17 | 5 | 4 | 6 | 2 | 3 | 4 |  | 3 | 2 | 6
18 | 2 | 4 | 5 |  |  |  |  | 2
19 | 3 | 5 | 5 | 4 |  |  |  | 2 | 1 | 4
20 | 5 | 5 | 6 | 3 | 4 | 5 |  | 3 | 2 | 10
21 | 5 | 3 | 2 | 5 | 2 | 5 |  | 4 | 1 | 3
22 | 4 | 5 | 3 | 6 | 5 |  |  | 2 | 2 | 8
23 | 5 | 4 | 4 | 6 | 5 | 3 |  | 3 | 2 | 9
24 | 2 | 6 | 4 |  |  |  |  | 2
25 | 4 | 2 | 6 | 4 | 6 |  |  | 3 | 1 | 6
26 | 5 | 4 | 3 | 5 | 6 | 4 |  | 3 | 2 | 9
27 | 5 | 4 | 4 | 6 | 4 | 6 |  | 2 | 3 | 12
28 | 3 | 2 | 3 | 3 |  |  |  | 3
29 | 4 | 4 | 4 | 4 | 5 |  |  | 2 | 2 | 8
30 | 4 | 4 | 5 | 6 | 2 |  |  | 3 | 1 | 5
31 | 5 | 6 | 6 | 5 | 5 | 5 |  | 2 | 3 | 15
32 | 5 | 4 | 4 | 6 | 4 | 5 |  | 2 | 3 | 12
33 | 4 | 4 | 5 | 2 | 4 |  |  | 3 | 1 | 4
34 | 3 | 4 | 3 | 6 |  |  |  | 3
35 | 4 | 6 | 5 | 3 | 5 |  |  | 2 | 2 | 8
36 | 5 | 4 | 4 | 2 | 5 | 4 |  | 3 | 2 | 8
37 | 5 | 4 | 5 | 4 | 6 | 4 |  | 2 | 3 | 12
38 | 5 | 5 | 6 | 2 | 4 | 4 |  | 3 | 2 | 8
39 | 3 | 5 | 5 | 6 |  |  |  | 2 | 1 | 5
40 | 4 | 5 | 4 | 2 | 6 |  |  | 3 | 1 | 4
41 | 4 | 5 | 3 | 6 | 5 |  |  | 2 | 2 | 8
42 | 4 | 4 | 5 | 6 | 2 |  |  | 3 | 1 | 4
43 | 5 | 6 | 5 | 5 | 5 | 5 |  | 2 | 3 | 15
44 | 3 | 4 | 6 | 5 |  |  |  | 2 | 1 | 4
45 | 4 | 5 | 4 | 6 | 5 |  |  | 2 | 2 | 9
46 | 5 | 5 | 2 | 3 | 4 | 4 |  | 4 | 1 | 4
47 | 3 | 4 | 2 | 6 |  |  |  | 3
48 | 5 | 6 | 5 | 4 | 4 | 3 |  | 3 | 2 | 9
49 | 5 | 5 | 3 | 4 | 5 | 2 |  | 4 | 1 | 5
50 | 3 | 4 | 3 | 2 |  |  |  | 3
51 | 3 | 5 | 5 | 3 |  |  |  | 2 | 1 | 3
52 | 5 | 4 | 4 | 5 | 4 | 5 |  | 2 | 3 | 12
53 | 5 | 5 | 2 | 4 | 4 | 5 |  | 3 | 2 | 8
54 | 3 | 4 | 2 | 6 |  |  |  | 3
55 | 2 | 4 | 5 |  |  |  |  | 2
56 | 2 | 5 | 4 |  |  |  |  | 2
57 | 3 | 4 | 2 | 6 |  |  |  | 3
58 | 5 | 2 | 5 | 4 | 3 | 6 |  | 4 | 1 | 6
59 | 4 | 5 | 3 | 6 | 5 |  |  | 2 | 2 | 8
60 | 4 | 6 | 5 | 2 | 4 |  |  | 3 | 1 | 4
61 | 5 | 5 | 5 | 5 | 5 | 5 |  | 2 | 3 | 15
62 | 5 | 2 | 4 | 6 | 4 | 3 |  | 3 | 2 | 6
63 | 5 | 4 | 4 | 2 | 5 | 3 |  | 4 | 1 | 4
64 | 4 | 4 | 5 | 6 | 3 |  |  | 3 | 1 | 5
65 | 5 | 3 | 3 | 5 | 2 | 5 |  | 3 | 2 | 6
66 | 4 | 6 | 3 | 5 | 4 |  |  | 3 | 1 | 5
67 | 4 | 2 | 5 | 2 | 4 |  |  | 4
68 | 4 | 2 | 5 | 5 | 6 |  |  | 3 | 1 | 5
69 | 4 | 4 | 5 | 6 | 2 |  |  | 3 | 1 | 4
70 | 4 | 3 | 6 | 3 | 5 |  |  | 2 | 2 | 6
71 | 4 | 5 | 5 | 5 | 5 |  |  | 2 | 2 | 10
72 | 5 | 5 | 3 | 4 | 5 | 5 |  | 3 | 2 | 10
73 | 5 | 5 | 4 | 6 | 4 | 5 |  | 2 | 3 | 13
74 | 4 | 4 | 4 | 4 | 4 |  |  | 2 | 2 | 8
75 | 2 | 4 | 6 |  |  |  |  | 2
76 | 3 | 4 | 6 | 5 |  |  |  | 2 | 1 | 4
77 | 4 | 6 | 4 | 2 | 5 |  |  | 3 | 1 | 4
78 | 3 | 6 | 4 | 4 |  |  |  | 2 | 1 | 4
79 | 3 | 5 | 5 | 4 |  |  |  | 2 | 1 | 4
80 | 5 | 3 | 4 | 6 | 4 | 2 |  | 4 | 1 | 6
81 | 4 | 4 | 4 | 3 | 2 |  |  | 4
82 | 5 | 6 | 5 | 5 | 5 | 4 |  | 2 | 3 | 14
83 | 5 | 3 | 5 | 4 | 2 | 6 |  | 4 | 1 | 6
84 | 4 | 5 | 4 | 4 | 4 |  |  | 2 | 2 | 8
85 | 4 | 5 | 6 | 5 | 4 |  |  | 2 | 2 | 9
86 | 5 | 4 | 3 | 4 | 6 | 3 |  | 4 | 1 | 6
87 | 4 | 5 | 2 | 5 | 4 |  |  | 3 | 1 | 4
88 | 5 | 4 | 3 | 5 | 6 | 4 |  | 3 | 2 | 9
89 | 5 | 4 | 2 | 4 | 5 | 2 |  | 4 | 1 | 4
90 | 2 | 3 | 6 |  |  |  |  | 2
91 | 4 | 5 | 4 | 4 | 3 |  |  | 3 | 1 | 4
92 | 4 | 2 | 5 | 3 | 5 |  |  | 3 | 1 | 3
93 | 5 | 3 | 4 | 6 | 5 | 4 |  | 3 | 2 | 9
94 | 3 | 4 | 3 | 2 |  |  |  | 2
95 | 4 | 5 | 2 | 6 | 5 |  |  | 3 | 1 | 5
96 | 2 | 5 | 4 |  |  |  |  | 2
97 | 4 | 5 | 4 | 6 | 5 |  |  | 2 | 2 | 9
98 | 3 | 5 | 5 | 3 |  |  |  | 2 | 1 | 3
99 | 2 | 4 | 5 |  |  |  |  | 2
100 | 5 | 5 | 5 | 6 | 2 | 3 |  | 3 | 2 | 8