excel交通规划“四阶段法”教程

Input 1: Traffic Network from_node_id

to_node_id length_in_m number_of_l

1210413204155421104242042554312043410436544220443104465451545254561056354645465105

Trip Generation

Objective: Estimate the number of trips entering and leaving each zone

Inputs: Zone Characteristics (# of HH, HH Income, Auto Ownership, Employment, etc.)Outputs: # of Productions, # of Attractions

Input 2:

Household Demographic Information Income Low Middle High Low Middle 0 Cars 400080008000200040001 Car 1200032000360008000260002 Cars 400020000160001000030000

Income Low Middle High Low Middle 0 Cars 000001 Car 2000800010000040002 Cars 80002200030000016000Input 4: Trip Production Table:Cars/HH

HH Income HBW HBO NHB Total Low 0.520.9 3.4Middle 1.13 1.2 5.3High 1.4 3.9 1.87.1Low 0.8 3.2 1.3 5.3Middle 1.5 3.9 1.67High 1.8 4.9 2.28.9Low 1.4 5.2 2.18.7Middle 2.1 5.7 2.310.1High 2.5 6.8 3.112.4Description: Identifies # of households in each zone with the specified car owne # of Productions/HH

1

2

Zone 1Zone 2

Zone 3Zone 4

Martin,W.A. and N.A.McGuckin (1998). Travel Estimation Techniques for Ur NCHRP Report 365, Transportation Research Board, Washington, DC.

Input 5: Trip Attraction Coefficient Table Trip Attraction Table Trip Type # of HH

Retail Service Other HBW 0 1.45 1.45 1.45HBO 0.99 1.70.5NHB 0.5 4.1 1.20.5Equation HBW = 1.45(Total Employment)

HBO = 0.9(# of Households) + 9(Retail Employment) + 1.7(Service Employment) + 0.5(Other NHB = 0.5(# of Households) + 4.1(Retail Employment) + 1.2(Service Employment) + 0.5(Othe Alternative Trip Attraction Table Trip Type # of HH Retail Other HBW 0 1.7 1.7HBO 1100.5NHB 0.52 2.5Trip Distribution

Objective: Estimate the number of trips made between each zone Inputs: Productions, Attractions, Travel time between zones Outputs: # of Person Trips from Zone i to Zone j

Input 6: Travel Time Table: Time in (minutes)

TAZ 1

TAZ 2TAZ 3TAZ 4

TAZ 1 2.5102020TAZ 210 2.52020TAZ 32020 2.510TAZ 4

202010 2.555515156

15

1555

Trip Purpose a b c

HBW 28507-0.02

-0.123HBO 139173-1.285-0.094NHB 219113

-1.332

-0.1

Friction Factor Mode

i = origin zone

SOLUTION PROCESS j = destination zone

Trip Productions Method:

Cross Classification

Process:

Destination

O r i g i n

Employment Type Employment Type