Spreadsheet: 133024d1324094351-conditional-formating-for-muliple-cells-with-t-f-formula-in-seperate-cell-test_book
Sheet: Route Compare

Route Compare Complete:
Baan Operations |  |  |  |  | PFSv4 Operations |  |  |  |  | Compares
BaaN OP | TASK | Work Center | Count Point |  | [NAME] | Task | Work Center | Count Point |  | Operation | Task | Work Center | Count Point
1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 |  | 2 | 2 | 2 | 2 |  | 1 | 1 | 1 | 1
3 | 3 | 3 | 3 |  | 3 | 3 | 2 | 3 |  | 1 | 1 | 0 | 1
4 | 4 | 4 | 4 |  | 4 | 4 | 4 | 4 |  | 1 | 1 | 1 | 1
 | 5 | 5 | 5 |  |  | 5 | 5 |  |  |  | 1 | 1 | 0
6 | 6 | 6 | 6 |  | 6 | 6 | 6 | 6 |  | 1 | 1 | 1 | 1
7 |  | 7 | 7 |  | 7 |  | 7 | 7 |  | 1 |  | 1 | 1
8 | 8 | 8 | 8 |  | 8 | 8 | 8 | 8 |  | 1 | 1 | 1 | 1
9 | 9 | 9 | 9 |  | 10 | 9 | 9 | 9 |  | 0 | 1 | 1 | 1
10 | 10 | 10 | 10 |  | 10 |  | 10 | 9 |  | 1 | 0 | 1 | 0
11 | 11 | 11 | 11 |  | 11 | 11 | 11 | 11 |  | 1 | 1 | 1 | 1
12 | 12 | 12 | 12 |  |  | 12 | 12 | 12 |  | 0 | 1 | 1 | 1
13 | 13 | 13 |  |  | 13 | 13 | 13 |  |  | 1 | 1 | 1
14 |  | 14 | 14 |  | 14 |  | 14 | 14 |  | 1 |  | 1 | 1
16 | 16 | 16 | 16 |  | 16 | 16 | 16 | 16 |  | 1 | 1 | 1 | 1
17 | 17 | 17 | 17 |  | 17 | 17 | 17 | 17 |  | 1 | 1 | 1 | 1
18 | 18 | 18 | 18 |  | 18 | 18 | 18 |  |  | 1 | 1 | 1 | 0
19 | 19 | 19 | 18 |  |  | 20 | 19 | 18 |  | 0 | 0 | 1 | 1
20 | 20 | 20 | 20 |  | 20 | 20 |  | 20 |  | 1 | 1 | 0 | 1
21 | 21 | 21 | 21 |  | 21 | 21 | 21 | 21 |  | 1 | 1 | 1 | 1
22 | 22 | 22 | 22 |  | 22 | 22 | 22 | 22 |  | 1 | 1 | 1 | 1
23 |  | 23 | 23 |  |  |  | 23 | 23 |  | 0 |  | 1 | 1
24 | 24 | 24 | 24 |  | 24 | 24 | 24 | 24 |  | 1 | 1 | 1 | 1
25 | 25 | 25 | 25 |  | 25 | 25 | 24 |  |  | 1 | 1 | 0 | 0
26 |  | 26 | 26 |  | 26 |  | 26 | 26 |  | 1 |  | 1 | 1
 | 27 | 27 | 27 |  |  | 27 | 27 | 27 |  |  | 1 | 1 | 1
 | 28 | 28 | 28 |  |  | 28 | 28 | 28 |  |  | 1 | 1 | 1
TEMPLATE
OPERATION | TASK | [NAME] | WORK CENTER | MACHINE WORK CENTER | WORK CENTER SET UP | CYCLE TIME MIN / ASM | FIXED DURATION | MAN OCC SET-UP (# OF PEOPLE) | MAN OCC PROD (# OF PEOPLE) | MACHINE OCC | TRANSFER 100% (Y/N) | TRANSFER QTY | COUNT POINT
1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  | 4 | 4 | 4 | 4 | 4
5 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 |  | 6
7 | 6 | 7 | 7 | 7 | 7 | 7 | 7 | 6 | 7 | 7 | 7 | 7 | 7
8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
9 | 9 | 9 | 9 | 9 |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
10 | 10 |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11
12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
12 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13
14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
17 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17
18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18
19 | 19 | 19 |  | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19
20 | 20 | 20 | 20 | 20 | 19 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21
22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 |  | 22 | 22 | 22
23 | 23 | 23 | 23 | 22 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23
24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24
25 | 25 | 25 | 25 | 25 | 25 | 25 | 24 | 25 | 25 | 25 | 25 | 25 | 25
26 |  | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26
27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 |  | 27 | 27 | 27 | 27
28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28
BaaN Route
OPERATION | TASK | [NAME] | WORK CENTER | MACHINE WORK CENTER | WORK CENTER SET UP | CYCLE TIME MIN / ASM | FIXED DURATION | MAN OCC SET-UP (# OF PEOPLE) | MAN OCC PROD (# OF PEOPLE) | MACHINE OCC | TRANSFER 100% (Y/N) | TRANSFER QTY | COUNT POINT
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
7 |  | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 7 | 8 | 8 | 8 | 8 | 8
9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  | 9
10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  | 10 | 10 | 10 | 10 | 10
11 | 11 | 11 | 11 | 11 | 11 | 11 | 10 | 11 | 11 | 11 | 11 | 11 | 11
12 | 12 | 12 | 12 | 11 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
13 | 13 | 13 |  | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13
14 |  | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17
18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18
19 | 19 | 19 | 18 |  | 19 | 19 | 19 | 19 |  | 19 | 19 | 19 | 19
20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21
22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22
23 |  | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23
24 | 24 | 24 | 24 | 24 | 24 | 23 | 24 | 24 | 24 | 24 |  | 24 | 24
25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 24 | 25 | 25 | 25 | 25
26 |  | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26
 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27
 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28
COMPARES
OPERATION | TASK | [NAME] | WORK CENTER | MACHINE WORK CENTER | WORK CENTER SET UP | CYCLE TIME MIN / ASM | FIXED DURATION | MAN OCC SET-UP (# OF PEOPLE) | MAN OCC PROD (# OF PEOPLE) | MACHINE OCC | TRANSFER 100% (Y/N) | TRANSFER QTY | COUNT POINT
1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1
0 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1
1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1
1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1
1 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1
1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1
0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1