project Transportation engr

Danny@1
PeakHourSpreadsheet.xlsx
Home>Engineering homework help>Civil Engineering homework help>project Transportation engr

Approach 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