Spreadsheet: 112701d1308742296-index-match-multiple-criteria-multiple-sheets-lookup-multiple-conditions-2
Sheet: SP

Phasing Data
RECORDNAME | INTID | D1 | D2 | D3 | D4 | D5 | D6 | D7 | D8 | D10 | D11 | D12 | D14 | D15 | D16
BRP | 1 | 111 | 112 | 211 | 212 | 121 | 122 | 213 | 214 | 312 | 411 | 412 | 322 | 421 | 422
MinGreen | 1 | 7 | 20 | 7 | 10 | 7 | 20
MaxGreen | 1 | 10.5 | 44 | 11 | 17.5 | 16.5 | 38
VehExt | 1 | 3 | 3 | 3 | 3 | 3 | 3
TimeBeforeReduce | 1 | 0 | 0 | 0 | 0 | 0 | 0
TimeToReduce | 1 | 0 | 0 | 0 | 0 | 0 | 0
MinGap | 1 | 3 | 3 | 3 | 3 | 3 | 3
Yellow | 1 | 4.5 | 4.5 | 3 | 3.5 | 4.5 | 4.5
AllRed | 1 | 2 | 2.5 | 4 | 3 | 2 | 2.5
Recall | 1 | 0 | 3 | 0 | 0 | 0 | 3
Walk | 1 |  | 7 | 7 | 7 |  | 7
DontWalk | 1 |  | 25 | 24 | 23 |  | 29
PedCalls | 1 |  | 0 | 0 | 0 |  | 0
MinSplit | 1 | 17 | 33 | 18 | 21 | 17 | 33
DualEntry | 1 | 0 | 1 | 1 | 1 | 0 | 1
InhibitMax | 1 | 1 | 1 | 1 | 1 | 1 | 1
Start | 1 | 71 | 88 | 29 | 47 | 71 | 94
End | 1 | 88 | 29 | 47 | 71 | 94 | 29
Yield | 1 | 81.5 | 22 | 40 | 64.5 | 87.5 | 22
Yield170 | 1 | 81.5 | 107 | 40 | 64.5 | 87.5 | 103
LocalStart | 1 | 49 | 66 | 7 | 25 | 49 | 72
LocalYield | 1 | 59.5 | 0 | 18 | 42.5 | 65.5 | 0
LocalYield170 | 1 | 59.5 | 85 | 18 | 42.5 | 65.5 | 81
ActGreen | 1 | 1.4 | 62.1 | 7.2 | 12.3 | 11.6 | 51.9
BRP | 2 | 111 | 112 | 211 | 212 | 121 | 122 | 221 | 222 | 312 | 411 | 412 | 322 | 421 | 422
MinGreen | 2 |  | 20 |  | 7 | 7 | 20 |  | 7
MaxGreen | 2 |  | 78 |  | 18 | 20 | 51 |  | 16
VehExt | 2 |  | 3 |  | 3 | 3 | 3 |  | 3
TimeBeforeReduce | 2 |  | 0 |  | 0 | 0 | 0 |  | 0
TimeToReduce | 2 |  | 0 |  | 0 | 0 | 0 |  | 0
MinGap | 2 |  | 3 |  | 3 | 3 | 3 |  | 3
Yellow | 2 |  | 4.5 |  | 3 | 4.5 | 4 |  | 3
AllRed | 2 |  | 2.5 |  | 4 | 2.5 | 3 |  | 6
Recall | 2 |  | 3 |  | 0 | 0 | 3 |  | 0
Walk | 2 |  | 7 |  | 7 |  | 7 |  | 7
DontWalk | 2 |  | 15 |  | 22 |  | 23 |  | 24
PedCalls | 2 |  | 0 |  | 0 |  | 0 |  | 0
MinSplit | 2 |  | 33 |  | 18 | 18 | 33 |  | 20
DualEntry | 2 |  | 1 |  | 1 | 0 | 1 |  | 1
InhibitMax | 2 |  | 1 |  | 1 | 1 | 1 |  | 1
Start | 2 |  | 22 |  | 107 | 22 | 49 |  | 107
End | 2 |  | 107 |  | 22 | 49 | 107 |  | 22
Yield | 2 |  | 100 |  | 15 | 42 | 100 |  | 13
Yield170 | 2 |  | 85 |  | 15 | 42 | 77 |  | 13
LocalStart | 2 |  | 32 |  | 7 | 32 | 59 |  | 7
LocalYield | 2 |  | 0 |  | 25 | 52 | 0 |  | 23
LocalYield170 | 2 |  | 95 |  | 25 | 52 | 87 |  | 23
ActGreen | 2 |  | 84.7 |  | 11.3 | 8.3 | 69.4 |  | 9.3
BRP | 3 | 111 | 112 | 211 | 212 | 121 | 122 | 213 | 214 | 312 | 411 | 412 | 322 | 421 | 422
MinGreen | 3 |  | 20 | 7 | 7 |  | 20
MaxGreen | 3 |  | 57.5 | 14 | 15 |  | 58
VehExt | 3 |  | 3 | 3 | 3 |  | 3
TimeBeforeReduce | 3 |  | 0 | 0 | 0 |  | 0
TimeToReduce | 3 |  | 0 | 0 | 0 |  | 0
MinGap | 3 |  | 3 | 3 | 3 |  | 3
Yellow | 3 |  | 4 | 3 | 3 |  | 4
AllRed | 3 |  | 3.5 | 6 | 4 |  | 3
Recall | 3 |  | 3 | 0 | 0 |  | 3
Walk | 3 |  | 7 | 7 | 7 |  | 7
DontWalk | 3 |  | 25 | 20 | 22 |  | 26
PedCalls | 3 |  | 0 | 0 | 0 |  | 0
MinSplit | 3 |  | 34 | 20 | 18 |  | 33
DualEntry | 3 |  | 1 | 1 | 1 |  | 1
InhibitMax | 3 |  | 1 | 1 | 1 |  | 1
Start | 3 |  | 45.5 | 0.5 | 23.5 |  | 45.5
End | 3 |  | 0.5 | 23.5 | 45.5 |  | 0.5
Yield | 3 |  | 103 | 14.5 | 38.5 |  | 103.5
Yield170 | 3 |  | 78 | 14.5 | 38.5 |  | 77.5
LocalStart | 3 |  | 52.5 | 7.5 | 30.5 |  | 52.5
LocalYield | 3 |  | 0 | 21.5 | 45.5 |  | 0.5
LocalYield170 | 3 |  | 85 | 21.5 | 45.5 |  | 84.5
ActGreen | 3 |  | 60.6 | 12.9 | 13 |  | 61.1
BRP | 4 | 111 | 112 | 211 | 212 | 121 | 122 | 221 | 222 | 312 | 411 | 412 | 322 | 421 | 422
MinGreen | 4 |  | 20 |  | 7 |  | 20 |  | 7
MaxGreen | 4 |  | 66.5 |  | 30.5 |  | 66.5 |  | 30.5
VehExt | 4 |  | 3 |  | 3 |  | 3 |  | 4
TimeBeforeReduce | 4 |  | 0 |  | 0 |  | 0 |  | 0
TimeToReduce | 4 |  | 0 |  | 0 |  | 0 |  | 0
MinGap | 4 |  | 3 |  | 3 |  | 3 |  | 4
Yellow | 4 |  | 4 |  | 3 |  | 4 |  | 3
AllRed | 4 |  | 2.5 |  | 3.5 |  | 2.5 |  | 3.5
Recall | 4 |  | 3 |  | 0 |  | 3 |  | 0
Walk | 4 |  | 10 |  | 10 |  | 10 |  | 10
DontWalk | 4 |  | 14 |  | 22 |  | 14 |  | 22
PedCalls | 4 |  | 0 |  | 0 |  | 0 |  | 0
MinSplit | 4 |  | 33 |  | 17 |  | 33 |  | 17
DualEntry | 4 |  | 1 |  | 1 |  | 1 |  | 1
InhibitMax | 4 |  | 1 |  | 1 |  | 1 |  | 1
Start | 4 |  | 28.5 |  | 101.5 |  | 28.5 |  | 101.5
End | 4 |  | 101.5 |  | 28.5 |  | 101.5 |  | 28.5
Yield | 4 |  | 95 |  | 22 |  | 95 |  | 22
Yield170 | 4 |  | 81 |  | 22 |  | 81 |  | 22
LocalStart | 4 |  | 43.5 |  | 6.5 |  | 43.5 |  | 6.5
LocalYield | 4 |  | 0 |  | 37 |  | 0 |  | 37
LocalYield170 | 4 |  | 96 |  | 37 |  | 96 |  | 37
ActGreen | 4 |  | 88 |  | 9 |  | 88 |  | 9
BRP | 5 | 111 | 112 | 211 | 212 | 121 | 122 | 221 | 222 | 312 | 411 | 412 | 322 | 421 | 422
MinGreen | 5 | 7 | 20 |  | 7 |  | 20 |  | 7
MaxGreen | 5 | 14.5 | 60.5 |  | 15.5 |  | 81.5 |  | 15.5
VehExt | 5 | 3 | 3 |  | 3 |  | 3 |  | 3
TimeBeforeReduce | 5 | 0 | 0 |  | 0 |  | 0 |  | 0
TimeToReduce | 5 | 0 | 0 |  | 0 |  | 0 |  | 0
MinGap | 5 | 3 | 3 |  | 3 |  | 3 |  | 3
Yellow | 5 | 4 | 4 |  | 3 |  | 4 |  | 3
AllRed | 5 | 2.5 | 2.5 |  | 3.5 |  | 2.5 |  | 3.5
Recall | 5 | 0 | 3 |  | 0 |  | 3 |  | 0
Walk | 5 |  | 10 |  | 10 |  | 10 |  | 10
DontWalk | 5 |  | 14 |  | 22 |  | 13 |  | 23
PedCalls | 5 |  | 0 |  | 0 |  | 0 |  | 0
MinSplit | 5 | 17 | 33 |  | 17 |  | 33 |  | 17
DualEntry | 5 | 0 | 1 |  | 1 |  | 1 |  | 1
InhibitMax | 5 | 1 | 1 |  | 1 |  | 1 |  | 1
Start | 5 | 22.5 | 43.5 |  | 0.5 |  | 22.5 |  | 0.5
End | 5 | 43.5 | 0.5 |  | 22.5 |  | 0.5 |  | 22.5
Yield | 5 | 37 | 104 |  | 16 |  | 104 |  | 16
Yield170 | 5 | 37 | 90 |  | 16 |  | 91 |  | 16
LocalStart | 5 | 28.5 | 49.5 |  | 6.5 |  | 28.5 |  | 6.5
LocalYield | 5 | 43 | 0 |  | 22 |  | 0 |  | 22
LocalYield170 | 5 | 43 | 96 |  | 22 |  | 97 |  | 22
ActGreen | 5 | 4.2 | 74.1 |  | 12.2 |  | 84.8 |  | 12.2
BRP | 6 | 111 | 112 | 211 | 212 | 121 | 122 | 221 | 222 | 312 | 411 | 412 | 322 | 421 | 422
MinGreen | 6 |  | 20 |  | 7 |  | 20 |  | 7
MaxGreen | 6 |  | 64 |  | 32.5 |  | 64.5 |  | 32.5
VehExt | 6 |  | 4 |  | 4 |  | 4 |  | 4
TimeBeforeReduce | 6 |  | 0 |  | 0 |  | 0 |  | 0
TimeToReduce | 6 |  | 0 |  | 0 |  | 0 |  | 0
MinGap | 6 |  | 4 |  | 4 |  | 4 |  | 4
Yellow | 6 |  | 4 |  | 3 |  | 4 |  | 3
AllRed | 6 |  | 3 |  | 3.5 |  | 2.5 |  | 3.5
Recall | 6 |  | 3 |  | 0 |  | 3 |  | 0
Walk | 6 |  | 7 |  | 7 |  | 7 |  | 7
DontWalk | 6 |  | 18 |  | 19 |  | 13 |  | 20
PedCalls | 6 |  | 0 |  | 0 |  | 0 |  | 0
MinSplit | 6 |  | 33 |  | 17 |  | 33 |  | 17
DualEntry | 6 |  | 1 |  | 1 |  | 1 |  | 1
InhibitMax | 6 |  | 1 |  | 1 |  | 1 |  | 1
Start | 6 |  | 97.5 |  | 58.5 |  | 97.5 |  | 58.5
End | 6 |  | 58.5 |  | 97.5 |  | 58.5 |  | 97.5
Yield | 6 |  | 51.5 |  | 91 |  | 52 |  | 91
Yield170 | 6 |  | 33.5 |  | 91 |  | 39 |  | 91
LocalStart | 6 |  | 46 |  | 7 |  | 46 |  | 7
LocalYield | 6 |  | 0 |  | 39.5 |  | 0.5 |  | 39.5
LocalYield170 | 6 |  | 92 |  | 39.5 |  | 97.5 |  | 39.5
ActGreen | 6 |  | 84.3 |  | 12.2 |  | 84.8 |  | 12.2
BRP | 7 | 111 | 112 | 211 | 212 | 121 | 122 | 221 | 222 | 312 | 411 | 412 | 322 | 421 | 422
MinGreen | 7 | 7 | 20 | 7 | 10 | 7 | 20 | 7 | 10
MaxGreen | 7 | 11 | 34 | 13.5 | 20 | 11 | 34 | 11.5 | 23
VehExt | 7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
TimeBeforeReduce | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TimeToReduce | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MinGap | 7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Yellow | 7 | 4 | 4 | 3.5 | 3 | 4 | 4 | 3 | 3.5
AllRed | 7 | 3 | 4 | 5 | 5 | 3 | 4 | 5.5 | 3.5
Recall | 7 | 0 | 3 | 0 | 0 | 0 | 3 | 0 | 0
Walk | 7 |  | 7 |  | 10 |  | 7 |  | 9
DontWalk | 7 |  | 31 |  | 23 |  | 29 |  | 19
PedCalls | 7 |  | 0 |  | 0 |  | 0 |  | 0
MinSplit | 7 | 18 | 35 | 20 | 23 | 18 | 35 | 20 | 21
DualEntry | 7 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1
InhibitMax | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Start | 7 | 79 | 97 | 29 | 51 | 79 | 97 | 29 | 49
End | 7 | 97 | 29 | 51 | 79 | 97 | 29 | 49 | 79
Yield | 7 | 90 | 21 | 42.5 | 71 | 90 | 21 | 40.5 | 72
Yield170 | 7 | 90 | 100 | 42.5 | 71 | 90 | 102 | 40.5 | 72
LocalStart | 7 | 58 | 76 | 8 | 30 | 58 | 76 | 8 | 28
LocalYield | 7 | 69 | 0 | 21.5 | 50 | 69 | 0 | 19.5 | 51
LocalYield170 | 7 | 69 | 79 | 21.5 | 50 | 69 | 81 | 19.5 | 51
ActGreen | 7 | 8.6 | 43.2 | 11 | 15.7 | 8.7 | 43.1 | 10.1 | 17.6
BRP | 8 | 111 | 112 | 211 | 212 | 121 | 122 | 221 | 222 | 312 | 411 | 412 | 322 | 421 | 422
MinGreen | 8 |  | 20 |  | 7 |  | 20 | 7 | 7
MaxGreen | 8 |  | 59 |  | 37 |  | 59 | 19 | 11
VehExt | 8 |  | 3 |  | 3 |  | 3 | 3 | 3
TimeBeforeReduce | 8 |  | 0 |  | 0 |  | 0 | 0 | 0
TimeToReduce | 8 |  | 0 |  | 0 |  | 0 | 0 | 0
MinGap | 8 |  | 3 |  | 3 |  | 3 | 3 | 3
Yellow | 8 |  | 4 |  | 3 |  | 4 | 3 | 3
AllRed | 8 |  | 3 |  | 4 |  | 3 | 4 | 4
Recall | 8 |  | 3 |  | 0 |  | 3 | 0 | 0
Walk | 8 |  | 7 |  | 7 |  | 8 |  | 7
DontWalk | 8 |  | 16 |  | 19 |  | 16 |  | 27
PedCalls | 8 |  | 0 |  | 0 |  | 0 |  | 0
MinSplit | 8 |  | 33 |  | 18 |  | 33 | 18 | 18
DualEntry | 8 |  | 1 |  | 1 |  | 1 | 0 | 1
InhibitMax | 8 |  | 1 |  | 1 |  | 1 | 1 | 1
Start | 8 |  | 95.5 |  | 51.5 |  | 95.5 | 51.5 | 77.5
End | 8 |  | 51.5 |  | 95.5 |  | 51.5 | 77.5 | 95.5
Yield | 8 |  | 44.5 |  | 88.5 |  | 44.5 | 70.5 | 88.5
Yield170 | 8 |  | 28.5 |  | 88.5 |  | 28.5 | 70.5 | 88.5
LocalStart | 8 |  | 51 |  | 7 |  | 51 | 7 | 33
LocalYield | 8 |  | 0 |  | 44 |  | 0 | 26 | 44
LocalYield170 | 8 |  | 94 |  | 44 |  | 94 | 26 | 44
ActGreen | 8 |  | 68.7 |  | 27.3 |  | 68.7 | 15.9 | 4.4
BRP | 9 | 111 | 112 | 211 | 311 | 121 | 122 | 212 | 321 | 312 | 411 | 412 | 322 | 421 | 422
MinGreen | 9 | 7 | 20 | 7 | 7 | 7 | 20 |  | 7
MaxGreen | 9 | 10.5 | 40.5 | 13 | 13.5 | 13 | 38.5 |  | 13.5
VehExt | 9 | 3 | 3 | 3 | 3 | 3 | 3 |  | 3
TimeBeforeReduce | 9 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
TimeToReduce | 9 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
MinGap | 9 | 3 | 3 | 3 | 3 | 3 | 3 |  | 3
Yellow | 9 | 4.5 | 4 | 3 | 3 | 4 | 4.5 |  | 3
AllRed | 9 | 3 | 3.5 | 6 | 5.5 | 3 | 3 |  | 5.5
Recall | 9 | 0 | 3 | 0 | 0 | 0 | 3 |  | 0
Walk | 9 |  |  | 7 | 7 |  | 7 |  | 7
DontWalk | 9 |  |  | 19 | 6 |  | 17 |  | 30
PedCalls | 9 |  |  | 0 | 0 |  | 0 |  | 0
MinSplit | 9 | 18 | 34 | 20 | 20 | 18 | 34 |  | 20
DualEntry | 9 | 0 | 1 | 1 | 1 | 0 | 1 |  | 1
InhibitMax | 9 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1
Start | 9 | 36 | 54 | 102 | 14 | 36 | 56 |  | 14
End | 9 | 54 | 102 | 14 | 36 | 56 | 102 |  | 36
Yield | 9 | 46.5 | 94.5 | 5 | 27.5 | 49 | 94.5 |  | 27.5
Yield170 | 9 | 46.5 | 94.5 | 5 | 27.5 | 49 | 77.5 |  | 27.5
LocalStart | 9 | 90 | 108 | 46 | 68 | 90 | 0 |  | 68
LocalYield | 9 | 100.5 | 38.5 | 59 | 81.5 | 103 | 38.5 |  | 81.5
LocalYield170 | 9 | 100.5 | 38.5 | 59 | 81.5 | 103 | 21.5 |  | 81.5
ActGreen | 9 | 2.8 | 62.4 | 7.3 | 5 | 4.4 | 61.3 |  | 5