project Transportation engr
Danny@1
PeakHourSpreadsheet.xlsxApproach 1
| Name: | Kevin Mendez | ||||||||
| Period: | 7am-9am (North Mary St) | ||||||||
| Date | 11/16/21 | ||||||||
| Approach 1 | |||||||||
| 1-2 | 1-3 | 1-4 | |||||||
| Period | LV | HV | Queue | LV | HV | Queue | LV | HV | Queue |
| 7:00 - 7:05 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 7:05 - 7:10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 7:10 - 7:15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 7:15 - 7:20 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 7:20 - 7:25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 7:25 - 7:30 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 |
| 7:30 - 7:35 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 |
| 7:35 - 7:40 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 7:40 - 7:45 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 7:45 -7:50 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 |
| 7:50 - 7:55 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 |
| 7:55 - 8:00 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 |
| 8:00 - 8:05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 8:05 - 8:10 | 0 | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 0 |
| 8:10 - 8:15 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 |
| 8:15 - 8:20 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 8:20 - 8:25 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 8:25 - 8:30 | 0 | 0 | 0 | 1 | 1 | 0 | 3 | 0 | 0 |
| 8:30 - 8:35 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 8:35 - 8:40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 8:40 - 8:45 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 8:45 -8:50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 8:50 - 8:55 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 8:55 - 9:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Approach 2
| Name: | Fernando Becerra | ||||||||
| Period: | 7am to 9 am east to west on Border st. | ||||||||
| Date | 11/16/21 | ||||||||
| Approach Number | |||||||||
| 2-1 | 2-3 | 2-4 | |||||||
| Period | LV | HV | Queue | LV | HV | Queue | LV | HV | Queue |
| 7:00 - 7:05 | 1 | 0 | 1 | 1 | 0 | 0 | 5 | 0 | 0 |
| 7:05 - 7:10 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 |
| 7:10 - 7:15 | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 1 | 0 |
| 7:15 - 7:20 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 |
| 7:20 - 7:25 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 |
| 7:25 - 7:30 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 |
| 7:30 - 7:35 | 0 | 0 | 0 | 1 | 0 | 0 | 5 | 1 | 0 |
| 7:35 - 7:40 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 |
| 7:40 - 7:45 | 1 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 1 |
| 7:45 -7:50 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 0 |
| 7:50 - 7:55 | 1 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 1 |
| 7:55 - 8:00 | 0 | 0 | 0 | 1 | 0 | 0 | 13 | 0 | 0 |
| 8:00 - 8:05 | 3 | 0 | 0 | 1 | 0 | 0 | 6 | 0 | 0 |
| 8:05 - 8:10 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 |
| 8:10 - 8:15 | 1 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 0 |
| 8:15 - 8:20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 |
| 8:20 - 8:25 | 0 | 0 | 0 | 2 | 0 | 0 | 3 | 0 | 0 |
| 8:25 - 8:30 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 |
| 8:30 - 8:35 | 0 | 0 | 0 | 1 | 0 | 0 | 4 | 0 | 0 |
| 8:35 - 8:40 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 |
| 8:40 - 8:45 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 |
| 8:45 -8:50 | 2 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 |
| 8:50 - 8:55 | 1 | 0 | 0 | 1 | 0 | 0 | 7 | 0 | 0 |
| 8:55 - 9:00 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 0 |
Approach 3
| Name: | Gabriel Almeida | ||||||||
| Period: | 7am to 9 am South to north on Mary St. | ||||||||
| Date | 11/16/21 | ||||||||
| Approach Number | |||||||||
| 3-4 | 3-1 | 3-2 | |||||||
| Period | LV | HV | Queue | LV | HV | Queue | LV | HV | Queue |
| 7:00 - 7:05 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 |
| 7:05 - 7:10 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 7:10 - 7:15 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 7:15 - 7:20 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 |
| 7:20 - 7:25 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 |
| 7:25 - 7:30 | 1 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 |
| 7:30 - 7:35 | 0 | 0 | 0 | 2 | 0 | 1 | 2 | 0 | 0 |
| 7:35 - 7:40 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 0 |
| 7:40 - 7:45 | 0 | 0 | 0 | 6 | 0 | 0 | 2 | 0 | 0 |
| 7:45 -7:50 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 7:50 - 7:55 | 0 | 0 | 0 | 6 | 0 | 0 | 4 | 0 | 0 |
| 7:55 - 8:00 | 1 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 |
| 8:00 - 8:05 | 1 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 0 |
| 8:05 - 8:10 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 |
| 8:10 - 8:15 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 8:15 - 8:20 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 |
| 8:20 - 8:25 | 1 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 |
| 8:25 - 8:30 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 0 |
| 8:30 - 8:35 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 |
| 8:35 - 8:40 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 |
| 8:40 - 8:45 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 |
| 8:45 -8:50 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 |
| 8:50 - 8:55 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 |
| 8:55 - 9:00 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 |
Approach 4
| Name: | Isaac Kehrman | ||||||||
| Period: | 4 (W Border St) | ||||||||
| Date | 11/16/21 | ||||||||
| 4 | |||||||||
| 4-1 | 4-2 | 4-3 | |||||||
| Period | LV | HV | Queue | LV | HV | Queue | LV | HV | Queue |
| 7:00 - 7:05 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 |
| 7:05 - 7:10 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 0 |
| 7:10 - 7:15 | 2 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 |
| 7:15 - 7:20 | 3 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 |
| 7:20 - 7:25 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 |
| 7:25 - 7:30 | 1 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 |
| 7:30 - 7:35 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 |
| 7:35 - 7:40 | 1 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 |
| 7:40 - 7:45 | 2 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 |
| 7:45 -7:50 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 |
| 7:50 - 7:55 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 7:55 - 8:00 | 3 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 |
| 8:00 - 8:05 | 4 | 0 | 0 | 7 | 0 | 0 | 2 | 0 | 0 |
| 8:05 - 8:10 | 1 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 |
| 8:10 - 8:15 | 1 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 |
| 8:15 - 8:20 | 0 | 0 | 0 | 7 | 0 | 0 | 1 | 0 | 0 |
| 8:20 - 8:25 | 2 | 0 | 0 | 6 | 0 | 0 | 1 | 0 | 0 |
| 8:25 - 8:30 | 0 | 0 | 0 | 8 | 0 | 0 | 1 | 0 | 0 |
| 8:30 - 8:35 | 4 | 0 | 0 | 4 | 0 | 0 | 2 | 0 | 0 |
| 8:35 - 8:40 | 1 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 |
| 8:40 - 8:45 | 2 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 |
| 8:45 -8:50 | 2 | 0 | 0 | 5 | 0 | 0 | 1 | 0 | 0 |
| 8:50 - 8:55 | 1 | 0 | 0 | 9 | 0 | 0 | 1 | 0 | 0 |
| 8:55 - 9:00 | 3 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 |
