# Trip distribution.xlsx - Given Zone Production 1 Attraction...

• 11
• 100% (1) 1 out of 1 people found this document helpful

This preview shows page 1 - 11 out of 11 pages.

Given: Zone 1 2 Production 250 450 Attraction 395 180 Travel Time in Minutes Zone 1 2 1 6 4 2 2 8 3 1 3 Time versus Friction Factor Time (min) Friction Factor 1 82 2 52 3 50 4 41 5 39 6 26 7 20 8 13
3 Total 300 1000 425 1000 3 2 3 5
Solution: For all Zone, K = 1 Zone 1 2 3 1 26 41 52 2 52 13 50 3 82 50 39 Initial Zone 1 2 3 Production 250 450 300 Attraction 395 180 425 First Iteration: Zone 1 39750 2 44130 3 57965 Zone 1 2 3 1 65 46 139 2 209 24 217 3 168 47 86 A computed 442 117 442 A given 395 180 425 Computed Given P 1001 1000 A 1001 1000 Needs Adjustment F ij Values: Number of Trips Produced, T ij ∑_𝑗▒ ?_𝑗 𝐹_𝑖𝑗 𝐾_𝑖𝑗 ?_𝑖𝑗=𝑃_𝑖 [(?_𝑗 𝐹_𝑖𝑗 𝐾_𝑖𝑗)/(∑_𝑗▒ ?_𝑗 𝐹_𝑖𝑗 𝐾_𝑖𝑗 )]
Zone 1 2 3 First Iteration: Total Zone 1000 Production 1000 Attraction Second Iteration: Zone 1 2 3 P computed P given Zone 250 250 1 450 450 2 301 300 3 A computed A given P A N F ij Values: Number of Trips Pro
1 2 3 26 41 52 52 13 50 82 50 39 1 2 3 Total 250 450 300 1000 353 277 409 1039 41803 42407 58747 1 2 3 P computed P given 55 68 127 250 250 195 38 217 450 450 148 71 81 300 300 398 177 425 395 180 425 Computed Given 1000 1000 1000 1000 No Adjustment oduced, T ij ∑_𝑗▒ ?_𝑗 𝐹_𝑖𝑗 𝐾_𝑖𝑗 ?_𝑖𝑗=𝑃_𝑖 [(?_𝑗 𝐹_𝑖𝑗 𝐾_𝑖𝑗)/(∑_𝑗▒ ?_𝑗 𝐹_𝑖𝑗 𝐾_𝑖𝑗 )]
Given: District 1 Productions 1000 Attractions 1000 Travel Time District 1 1 5 2 8 3 12 4 15 Time versus F Time (min) 1 5 6 7 8 10 12 15
Solution: Initial: District Productions Attractions First Iteration: 2 3 4 2000 3000 2200 700 6000 500 e in Minutes 2 3 4 8 12 15 5 10 8 10 5 7 8 7 5 Friction Factor Friction Factor 2 1.3 1.1 1 0.95 0.85 0.8 0.65
For all Zone, K = 1