CE 573 Transportation Planning - Fall 2001

Administration Course materials Other links
week 1 week 2 week 3 week 4
week 5 week 6 week 7 week 8
week 9 week 10 week 11 week 12
week 13 week 14 week 15

Assignment  15 - Solution

1. The trip generation equations, in Visual Basic form as functions, are listed below:

Public Function ProdHBW(HH)
ProdHBW = 9.2 * 0.2 * HH
End Function

Public Function ProdHBO(HH)
ProdHBO = 9.2 * 0.57 * HH
End Function

Public Function ProdNHB(HH)
ProdNHB = 9.2 * 0.23 * HH
End Function

Public Function AttHBW(TE)
AttHBW = 1.45 * TE
End Function

Public Function AttHBO(RE, SE, OE, HH)
AttHBO = 2 * RE + 1.7 * SE + 0.5 * OE + 0.9 * HH
End Function

Public Function AttNHB(RE, SE, OE, HH)
AttNHB = 1.4 * RE + 1.2 * SE + 0.5 * OE + 0.5 * HH
End Function

The table below shows the calculations of the productions and attractions for each trip purpose, using the above equations and the land use information given in the assignment.   The given data is shown in columns 2 through 5, number of households, retail employment, service employment, and other employment.  The trip generation

 
Zone HH RE SE OE P-HBW P-HBO P-NHB A-HBW A-HBO A-NHB P-Total A-Total
1 300 5000 10000 1500 552 1573 635 23925 28020 19900 2760 71845
2 100 2000 0 0 184 524 212 2900 4090 2850 920 9840
3 0 0 0 2500 0 0 0 3625 1250 1250 0 6125
4 500 0 0 0 920 2622 1058 0 450 250 4600 700
5 1000 0 0 0 1840 5244 2116 0 900 500 9200 1400
6 1500 0 0 0 2760 7866 3174 0 1350 750 13800 2100
7 1500 0 0 0 2760 7866 3174 0 1350 750 13800 2100
8 2500 0 0 0 4600 13110 5290 0 2250 1250 23000 3500
9 3000 0 0 0 5520 15732 6348 0 2700 1500 27600 4200
                       
Total 10400 7000 10000 4000 19136 54538 22006 30450 42360 29000 95680 101810

Using the data from the table above, here are two sample calculations:

Sample calculation #1:

P-HBW (zone 1) = (9.2)(0.2)(HH) = (9.2)(0.2)(300) = 552

Sample calculation #2:

A-NHB (zone 3) = 4.10NCBDRE + 1.2SE + 0.5OE + 0.5HH = 0.5(2500) = 1250

2. The table below lists the data for the highway network, including the distance, speed, capacity, and travel time for each link.  The link distances were computed using the user-defined distance function described previously. 

 
Anode Bnode Distance Speed Capacity Time
1 10 2.25 55 4000 2.46
1 11 1.25 30 1800 2.50
1 12 2.36 30 1800 4.72
1 14 2.03 40 900 3.05
2 13 2.88 30 1800 5.75
2 14 0.63 30 1800 1.25
3 10 5.15 30 1800 10.31
4 17 1.26 30 1800 2.51
5 18 1.25 30 1800 2.50
6 19 4.43 30 1800 8.86
7 15 1.13 30 1800 2.25
7 16 0.88 30 1800 1.75
8 13 4.50 30 1800 9.00
9 16 1.25 30 1800 2.50
10 11 1.88 30 1800 3.75
10 13 0.75 55 4000 0.82
11 12 2.00 30 1800 4.00
11 15 0.75 30 1800 1.50
12 16 0.75 30 1800 1.50
13 17 6.66 55 4000 7.26
14 15 0.38 30 1800 0.75
14 18 5.51 40 900 8.27
15 18 5.50 30 1800 11.00
16 19 6.88 30 1800 13.75
17 18 1.88 30 1800 3.75
18 19 2.13 30 1800 4.25

3. The table above shows a total productions of 95,680 and a total attractions of 101,810.  Since these are daily estimates, we assume that they should be equal.  The procedure described in pages 40 through 43 are used to balance the productions.  We recompute the attractions based on the total number of productions as a guide.  The table below shows the results of these computations.  Note that the sum of the adjusted number of attractions now equals the total number of productions (95,680).

 
Balancing Productions and Attractions
Zone P-HBW P-HBO P-NHB A-HBW A-HBO A-NHB P-Total A-Total
1 552 1573 635 15035 36075 15101 2760 66212
2 184 524 212 1822 5266 2163 920 9251
3 0 0 0 2278 1609 949 0 4836
4 920 2622 1058 0 579 190 4600 769
5 1840 5244 2116 0 1159 379 9200 1538
6 2760 7866 3174 0 1738 569 13800 2307
7 2760 7866 3174 0 1738 569 13800 2307
8 4600 13110 5290 0 2897 949 23000 3845
9 5520 15732 6348 0 3476 1138 27600 4614
               
19136 54538 22006 19136 54538 22006 95680 95680
 

Using the data in the table above, here are two sample calculations:

Sample calculation #1 (zone 1, HBW):

Control total for productions for HBW = 19,136

Sum of all attractions for HBW = 30,450

Balanced trip attractions Az' for zone 1 for HBW:

A1' = (19,136)(23,925)/(30,450) = 15,035

Sample calculation #2 (zone 5, NHB):

Control total for productions for NHB = 22,006

Sum of all attractions for NHB = 29,000

Balanced trip attractions Az' for zone 5 for NHB:

A1' = (22,006)(500)/(29,000) = 379