# TURNS5 Turning Movement Analysis Tool - Teach America

Document Sample

```					          TURNS5 Turning Movement Analysis Tool

Enter
Input

Check
Input

Sheet #1 (Turning                  Sheet #2 (Project

Prepare
Output

NOTES
The input process is fully menu driven - just fill in data at the prompts.
Manually changing the data on the InputSheet page will NOT invoke the macros.
The input from previous runs will automatically be shown in prompts.
TURNS5 ANALYSIS SHEET - INPUT
Analyst:
Date:          5-Apr-13
Highway:
Intersection:
From:
To:
County:
Enter Yes or No
Is the Mainline          Yes
Oriented North/South?            No

K Factors        Mainline                       D Factors                  Mainline
7.00%                                                     50.0%                Northbound (NB)
Sidestreet                                                  50.0%                Southbound (SB)
7.00%                                                   Sidestreet
50.0%                Westbound (WB)
50.0%                Eastbound (EB)

Enter Yes or No                    Summarized 1/2 of Calculated AADT
Do you have FTSUTMS Model Year traffic from which you would like to                                       Yes
From West:    From East:    From North:   From South:
interpolate/extrapolate for project years? (Y/N)                                                                                    Year       EB Approach   WB Approach   SB Approach   NB Approach           TOTAL
No
0              0             0             0               0                0
If "Yes" go to cell C47                          If "No" go to cell C31         0            #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
0            #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
0            #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
Enter Year and Growth Rates from Base Year:                                          Mainline Growth Function                calc method          1             1             1               1
Year                   Rate (1.0% = 0.01)                                     Linear
Base                    Mainline      Side Street                                   Exponential
Opening                                                                                 Decaying
Mid
Side Street Growth Function
Design
Linear
Enter Base Year AADTs for Volume Comparison:                                               Exponential                                           Linear Calcs
(growth rates are used to calculate other project years)                       Decaying
Calculated by Extrapolation using Rates
From West:      From East:           From North:   From South:                                                                               From West:    From East:    From North:   From South:
EB Approach     WB Approach          SB Approach   NB Approach                TOTAL                                              Year        EB Approach   WB Approach   SB Approach   NB Approach           TOTAL
0                   0               0                0                    0                                                 0                0            0              0               0               0
0                0            0              0               0               0
0                0            0              0               0               0
Enter Project and Model Years                                                                                                     0                0            0              0               0               0
Year
Base                                                                                                                   Rates              0.00%         0.00%         0.00%            0.00%
Opening
Mid
Design
Model

Enter Base and Model Year AADTs for Volume Comparison:                                                                       Calculated by Interpolation Using Model Output
(volumes for other project years are calculated by interpolation)                                                               From West:    From East:    From North:   From South:
Year        EB Approach   WB Approach   SB Approach   NB Approach           TOTAL
From West:      From East:           From North:   From South:                                                                    0               0             0             0               0                0
EB Approach     WB Approach          SB Approach   NB Approach                TOTAL                                               0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
0         0                   0               0                0                    0                                                 0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
0         0                   0               0                0                    0                                                 0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!

1st Guess       Actual/Counted
Turning %'s for      Traffic
(EB LT)         West-to-North                            0
(EB THRU)       West-to-East            100%             0                                                                   Calculated by Extrapolation using Rates
(EB RT)         West-to-South                            0                                                                                   From West:    From East:    From North:   From South:
Year        EB Approach   WB Approach   SB Approach   NB Approach           TOTAL
(WB LT)         East-to-South                              0                    (must be done manually)                           0                0            0              0               0               0
(WB THRU)       East-to-West            100%               0                                                                      0                0            0              0               0               0
(WB RT)         East-to-North                              0                                                                      0                0            0              0               0               0
0                0            0              0               0               0
(SB LT)         North-to-East                              0
(SB THRU)       North-to-South          100%               0                                                                 Rates              0.00%         0.00%         0.00%            0.00%
(SB RT)         North-to-West                              0

(NB LT)         South-to-West                              0
(NB THRU)       South-to-North          100%               0
(NB RT)         South-to-East                              0
Calculated by Interpolation Using Model Output
Desired Closure:                         0.01                                                                                                From West:    From East:    From North:   From South:
Year        EB Approach   WB Approach   SB Approach   NB Approach           TOTAL
0               0             0             0               0                0
0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!

Decaying Exponential (Logarithmic)
Calcs
Calculated by Extrapolation using Rates
From West:    From East:    From North:   From South:
Year        EB Approach   WB Approach   SB Approach   NB Approach           TOTAL
0               0             0             0               0                0
0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!

Linear Rate        0.00%         0.00%         0.00%           0.00%
Out Year (y2)         0             0             0               0
In Year (y1)          0             0             0               0
b                  #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!

Calculated by Interpolation Using Model Output
From West:    From East:    From North:   From South:
Year        EB Approach   WB Approach   SB Approach   NB Approach           TOTAL
0               0             0             0               0                0
0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!
0             #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!          #DIV/0!

y1=a+b*ln x1             x1= 1                            y1= row 110 values
y2=a+b*ln x2             x2= 1                            y2= row 59 values
n = year - 0
b=(y2-y1)/(ln(x2))
y1=a=               0             0           0                    0
y2-y1              0             0           0                    0
b    #DIV/0!         #DIV/0!     #DIV/0!          #DIV/0!
TURNFLOW - Intersection Turning Movement Program
(c) Mark C. Schaefer, May 1988, Version 1.00

Modified to Version 4.00, 10/95
by Susan C. Newman / Richard Oujevolk - TEI Orlando,FL
Adapted to Windows 2000, Windows XP, Microsoft Excel2003 by Mike Phillips and Loren Bloomberg CH2M HILL 5/2005

NOTE TO USERS:

PURPOSE:               This program computes a likely set of intersection turning movements
from intersection approach counts and the user's "best guess" of the
turning proportions from each approach.

REFERENCE:             E. Hauer, E. Pagitsas, and B.T. Shin. "Estimation of Turning Flows
from Automatic Counts". Transportation Research Record #795. 1981.

Following are the calculations of the algorithm which produce the output summary table.
The spreadsheet offers no new theory to that proposed in the technical reference identified
above. Users are advised against customizing the spreadsheet since changes may affect
the correct functioning of the macros built into the spreadsheet.

BASE YEAR CALCULATIONS:                                       0
eb A1 =   #DIV/0!                            33.59193005 These cells are updated by the
wb A2 =   #DIV/0!                            33.59193005 macro code - do not protect
sb A3 =  #DIV/0!                            9.327466113 this range or enter any data in
nb A4 =   #DIV/0!                            9.327466113              them.

COMPUTE Bj                 0
wb B1 =               0.000
eb B2 =               0.000
nb B3 =               0.000
sb B4 =              0.000

COMPUTE Anew                  0
eb A1 =                0.000
wb A2 =                0.000
sb A3 =                0.000
nb A4 =                0.000

COMPUTE DIFFERENCE A current - A new
- ANEW =                                              CLOSURE           FLAG
DIFF             ABS(DIFF)                         (1=TRUE)           KEY
33.592              33.592                               1
33.592               33.592             1
9.327                9.327             1
9.327                9.327             1
Max of Abs=            33.592             1          1

COMPUTE TURNING MOVEMENTS
Proportion
0            of Total
West-to-East            0.00            0.0%
West-to-North           0.00            0.0%
West-to-South           0.00            0.0%
0.00           100.0%

East-to-West            0.00            0.0%
East-to-North           0.00            0.0%
East-to-South           0.00            0.0%
0.00           100.0%

North-to-West           0.00            0.0%
North-to-East           0.00            0.0%
North-to-South          0.00            0.0%
0.00           100.0%

South-to-West           0.00            0.0%
South-to-East           0.00            0.0%
South-to-North          0.00            0.0%
0.00           100.0%

VISUAL check for user that total link volumes match after calculations

TO          CALCULATED           ORIGINAL       DIFFERENCE
Total to West            0                   0                0
Total to East            0                   0                0
Total to North           0                   0                0
Total to South           0                   0                0
TOTAL:                   0                   0                0     OK
FROM          CALCULATED           ORIGINAL       DIFFERENCE
Total from West          0                   0                0
Total from East          0                   0                0
Total from North         0                   0                0
Total from South         0                   0                0
TOTAL:                 69500                 0                0     OK

U-TURN CHECK
FROM > TO
FROM            VOLUME               TO             VOLUME  (1=TRUE)
Total from West           0                E,N,S                0      0
Total from East           0                W,N,S                0      0
Total from North          0                W,E,S                0      0
Total from South          0                W,E,N                0      0
0     OK
NOTE: Cell E102 must be zero, or the macro generates a "UTURN" error.
OPENING YEAR CALCULATIONS:                      0
eb A1 =   #DIV/0!               37.0875875 These cells are updated by the
wb A2 =   #DIV/0!               37.0875875 macro code - do not protect
sb A3 =  #DIV/0!              13.81554013 this range or enter any data in
nb A4 =   #DIV/0!              13.81554013              them.

COMPUTE Bj         0
wb B1 =       #DIV/0!
eb B2 =       #DIV/0!
nb B3 =       #DIV/0!
sb B4 =      #DIV/0!

COMPUTE Anew         0
eb A1 =       #DIV/0!
wb A2 =       #DIV/0!
sb A3 =       #DIV/0!
nb A4 =       #DIV/0!

COMPUTE DIFFERENCE A current - A new
- ANEW =                           CLOSURE       FLAG
DIFF             ABS(DIFF)      (1=TRUE)       KEY
#DIV/0!              #DIV/0!        #DIV/0!
#DIV/0!              #DIV/0!        #DIV/0!
#DIV/0!              #DIV/0!        #DIV/0!
#DIV/0!              #DIV/0!        #DIV/0!
Max of Abs=            #DIV/0!        #DIV/0!     #DIV/0!

COMPUTE TURNING MOVEMENTS
Proportion
0          of Total
West-to-East        #DIV/0!       #DIV/0!
West-to-North       #DIV/0!       #DIV/0!
West-to-South       #DIV/0!       #DIV/0!
#DIV/0!       100.0%

East-to-West        #DIV/0!       #DIV/0!
East-to-North       #DIV/0!       #DIV/0!
East-to-South       #DIV/0!       #DIV/0!
#DIV/0!       100.0%

North-to-West       #DIV/0!       #DIV/0!
North-to-East       #DIV/0!       #DIV/0!
North-to-South      #DIV/0!       #DIV/0!
#DIV/0!       100.0%
South-to-West         #DIV/0!          #DIV/0!
South-to-East         #DIV/0!          #DIV/0!
South-to-North        #DIV/0!          #DIV/0!
#DIV/0!          100.0%

VISUAL check for user that total link volumes match after calculations

TO          CALCULATED           ORIGINAL       DIFFERENCE
Total to West          #DIV/0!             #DIV/0!         #DIV/0!
Total to East          #DIV/0!             #DIV/0!         #DIV/0!
Total to North         #DIV/0!             #DIV/0!         #DIV/0!
Total to South         #DIV/0!             #DIV/0!         #DIV/0!
TOTAL:                 #DIV/0!             #DIV/0!         #DIV/0!       #DIV/0!
FROM          CALCULATED           ORIGINAL       DIFFERENCE
Total from West        #DIV/0!             #DIV/0!         #DIV/0!
Total from East        #DIV/0!             #DIV/0!         #DIV/0!
Total from North       #DIV/0!             #DIV/0!         #DIV/0!
Total from South       #DIV/0!             #DIV/0!         #DIV/0!
TOTAL:                  69500              #DIV/0!         #DIV/0!       #DIV/0!

U-TURN CHECK
FROM > TO
FROM            VOLUME               TO             VOLUME  (1=TRUE)
Total from West        #DIV/0!             E,N,S           #DIV/0!  #DIV/0!
Total from East        #DIV/0!             W,N,S           #DIV/0!  #DIV/0!
Total from North       #DIV/0!             W,E,S           #DIV/0!  #DIV/0!
Total from South       #DIV/0!             W,E,N           #DIV/0!  #DIV/0!
#DIV/0!   #DIV/0!
NOTE: Cell E182 must be zero, or the macro generates a "UTURN" error.

MID-YEAR CALCULATIONS:                              0
eb A1 =  #DIV/0!                  40.28805344 These cells are updated by the
wb A2 =  #DIV/0!                  40.28805344 macro code - do not protect
sb A3 =  #DIV/0!                  17.50403791 this range or enter any data in
nb A4 =  #DIV/0!                  17.50403791              them.

COMPUTE Bj           0
wb B1 =         #DIV/0!
eb B2 =         #DIV/0!
nb B3 =         #DIV/0!
sb B4 =        #DIV/0!

COMPUTE Anew           0
eb A1 =         #DIV/0!
wb A2 =         #DIV/0!
sb A3 =         #DIV/0!
nb A4 =         #DIV/0!
COMPUTE DIFFERENCE A current - A new
- ANEW =                                 CLOSURE          FLAG
DIFF             ABS(DIFF)            (1=TRUE)          KEY
#DIV/0!              #DIV/0!              #DIV/0!
#DIV/0!              #DIV/0!              #DIV/0!
#DIV/0!              #DIV/0!              #DIV/0!
#DIV/0!              #DIV/0!              #DIV/0!
Max of Abs=            #DIV/0!              #DIV/0!        #DIV/0!

COMPUTE TURNING MOVEMENTS
Proportion
0             of Total
West-to-East          #DIV/0!          #DIV/0!
West-to-North         #DIV/0!          #DIV/0!
West-to-South         #DIV/0!          #DIV/0!
#DIV/0!          100.0%

East-to-West          #DIV/0!          #DIV/0!
East-to-North         #DIV/0!          #DIV/0!
East-to-South         #DIV/0!          #DIV/0!
#DIV/0!          100.0%

North-to-West         #DIV/0!          #DIV/0!
North-to-East         #DIV/0!          #DIV/0!
North-to-South        #DIV/0!          #DIV/0!
#DIV/0!          100.0%

South-to-West         #DIV/0!          #DIV/0!
South-to-East         #DIV/0!          #DIV/0!
South-to-North        #DIV/0!          #DIV/0!
#DIV/0!          100.0%

VISUAL check for user that total link volumes match after calculations

TO          CALCULATED           ORIGINAL       DIFFERENCE
Total to West          #DIV/0!             #DIV/0!         #DIV/0!
Total to East          #DIV/0!             #DIV/0!         #DIV/0!
Total to North         #DIV/0!             #DIV/0!         #DIV/0!
Total to South         #DIV/0!             #DIV/0!         #DIV/0!
TOTAL:                 #DIV/0!             #DIV/0!         #DIV/0!        #DIV/0!
FROM          CALCULATED           ORIGINAL       DIFFERENCE
Total from West        #DIV/0!             #DIV/0!         #DIV/0!
Total from East        #DIV/0!             #DIV/0!         #DIV/0!
Total from North       #DIV/0!             #DIV/0!         #DIV/0!
Total from South       #DIV/0!             #DIV/0!         #DIV/0!
TOTAL:                  69500              #DIV/0!         #DIV/0!        #DIV/0!

U-TURN CHECK
FROM > TO
FROM             VOLUME                TO            VOLUME         (1=TRUE)
Total from West        #DIV/0!           E,N,S          #DIV/0!    #DIV/0!
Total from East        #DIV/0!           W,N,S          #DIV/0!    #DIV/0!
Total from North       #DIV/0!           W,E,S          #DIV/0!    #DIV/0!
Total from South       #DIV/0!           W,E,N          #DIV/0!    #DIV/0!
#DIV/0!    #DIV/0!
NOTE: Cell E262 must be zero, or the macro generates a "UTURN" error.

DESIGN YEAR CALCULATIONS:                          0
eb A1 =  #DIV/0!                 43.26013385 These cells are updated by the
wb A2 =  #DIV/0!                 43.26013385 macro code - do not protect
sb A3 =  #DIV/0!                 20.68997784 this range or enter any data in
nb A4 =  #DIV/0!                 20.68997784              them.

COMPUTE Bj           0
wb B1 =         #DIV/0!
eb B2 =         #DIV/0!
nb B3 =         #DIV/0!
sb B4 =        #DIV/0!

COMPUTE Anew           0
eb A1 =         #DIV/0!
wb A2 =         #DIV/0!
sb A3 =         #DIV/0!
nb A4 =         #DIV/0!

COMPUTE DIFFERENCE A current - A new
- ANEW =                              CLOSURE       FLAG
DIFF             ABS(DIFF)         (1=TRUE)       KEY
#DIV/0!              #DIV/0!           #DIV/0!
#DIV/0!              #DIV/0!           #DIV/0!
#DIV/0!              #DIV/0!           #DIV/0!
#DIV/0!              #DIV/0!           #DIV/0!
Max of Abs=            #DIV/0!           #DIV/0!     #DIV/0!

COMPUTE TURNING MOVEMENTS
Proportion
0           of Total
West-to-East         #DIV/0!        #DIV/0!
West-to-North        #DIV/0!        #DIV/0!
West-to-South        #DIV/0!        #DIV/0!
#DIV/0!        100.0%

East-to-West         #DIV/0!        #DIV/0!
East-to-North        #DIV/0!        #DIV/0!
East-to-South        #DIV/0!        #DIV/0!
#DIV/0!        100.0%
North-to-West         #DIV/0!          #DIV/0!
North-to-East         #DIV/0!          #DIV/0!
North-to-South        #DIV/0!          #DIV/0!
#DIV/0!          100.0%

South-to-West         #DIV/0!          #DIV/0!
South-to-East         #DIV/0!          #DIV/0!
South-to-North        #DIV/0!          #DIV/0!
#DIV/0!          100.0%

VISUAL check for user that total link volumes match after calculations

TO          CALCULATED           ORIGINAL       DIFFERENCE
Total to West          #DIV/0!             #DIV/0!         #DIV/0!
Total to East          #DIV/0!             #DIV/0!         #DIV/0!
Total to North         #DIV/0!             #DIV/0!         #DIV/0!
Total to South         #DIV/0!             #DIV/0!         #DIV/0!
TOTAL:                 #DIV/0!             #DIV/0!         #DIV/0!       #DIV/0!
FROM          CALCULATED           ORIGINAL       DIFFERENCE
Total from West        #DIV/0!             #DIV/0!         #DIV/0!
Total from East        #DIV/0!             #DIV/0!         #DIV/0!
Total from North       #DIV/0!             #DIV/0!         #DIV/0!
Total from South       #DIV/0!             #DIV/0!         #DIV/0!
TOTAL:                  69500              #DIV/0!         #DIV/0!       #DIV/0!

U-TURN CHECK
FROM > TO
FROM           VOLUME              TO            VOLUME     (1=TRUE)
Total from West       #DIV/0!            E,N,S           #DIV/0!    #DIV/0!
Total from East       #DIV/0!           W,N,S            #DIV/0!    #DIV/0!
Total from North      #DIV/0!           W,E,S            #DIV/0!    #DIV/0!
Total from South      #DIV/0!           W,E,N            #DIV/0!    #DIV/0!
#DIV/0!   #DIV/0!
NOTE: Cell E342 must be zero, or the macro generates a "UTURN" error.
TURNS5 INITIAL TURNING VOLUME SUMMARY

Highway:                                 0                            County:                   0
Intersection:                            0
From:                                    0                            Analyst:                  0
To:                                      0                            Date:      5-Apr-13

0                     0                            0                         0                            0
Approach-To-           Initial        Final         Turning        Final     Calculated     Final          Turning        Final         Calculated
Approach             Estimate       Estimate       Volume        Estimate    Volume       Estimate        Volume        Estimate        Volume

West-To-North (LT)          0.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
West-To-East (Thru)         1.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
West-To-South (RT)          0.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

Total Flow From West:                                   0                         #DIV/0!                   #DIV/0!                       #DIV/0!

East-To-South (LT)          0.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
East-To-West (Thru)         1.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
East-To-North (RT)          0.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

Total Flow From East:                                   0                         #DIV/0!                   #DIV/0!                       #DIV/0!

North-To-East (LT)          0.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
North-To-South (Thru)       1.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
North-To-West (RT)          0.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

Total Flow From North:                                  0                         #DIV/0!                   #DIV/0!                       #DIV/0!

South-To-West (LT)          0.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
South-To-North (Thru)       1.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
South-To-East (RT)          0.00         0.000            0           #DIV/0!       #DIV/0!    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

Total Flow From South:                                  0                         #DIV/0!                   #DIV/0!                       #DIV/0!

PLEASE NOTE: These are the Initial Balanced Turning Movements. They are directional.
The volumes as shown in the the output Turning Movement Diagrams have been smoothed to reflect two-way flow.
PROJECT TRAFFIC FOR AT : TO
2-WAY AADT TURNING MOVEMENTS IN YEAR 0                                                                    2-WAY AADT TURNING MOVEMENTS IN YEAR 0

0                  0                                                                                     0      #DIV/0!
0                                                                                                   #DIV/0!
0%       0%            0%                                                                             #DIV/0! #DIV/0! #DIV/0!
0        0             0             0                                                               #DIV/0! #DIV/0! #DIV/0!        #DIV/0!
0                                                                                                 0
0     0%                                                                                  #DIV/0!   #DIV/0!
0                               0                            0     0%      0                           #DIV/0!                #DIV/0!                  #DIV/0!   #DIV/0!   #DIV/0!
0                                                                                        0     0%              #DIV/0!                                                             #DIV/0!   #DIV/0!
0%       0                                                                             0                 ##### #DIV/0!                                                                 #DIV/0!
0       0%       0                                      0                                              #DIV/0!   ##### #DIV/0!                        #DIV/0!
0%       0                                                               0                               ##### #DIV/0!                                             #DIV/0!

0                           0                                                                                0                      #DIV/0!
0         0        0                                                                          #DIV/0! #DIV/0! #DIV/0!
0%        0%       0%                                                                          #DIV/0! #DIV/0! #DIV/0!
0                                                                                           #DIV/0!
0             0                                                                                    #DIV/0!     0

2-WAY AADT TURNING MOVEMENTS IN YEAR 0                                                                    2-WAY AADT TURNING MOVEMENTS IN YEAR 0

0      #DIV/0!                                                                                           0      #DIV/0!
#DIV/0!                                                                                                  #DIV/0!
#DIV/0! #DIV/0! #DIV/0!                                                                                  #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!                  #DIV/0!                                                         #DIV/0! #DIV/0! #DIV/0!        #DIV/0!
0                                                                                                 0
#DIV/0! #DIV/0!                                                                                  #DIV/0! #DIV/0!
#DIV/0!                       #DIV/0!                      #DIV/0! #DIV/0!   #DIV/0!                       #DIV/0!                #DIV/0!                  #DIV/0! #DIV/0!     #DIV/0!
#DIV/0!                                                                              #DIV/0! #DIV/0!             #DIV/0!                                                             #DIV/0! #DIV/0!
##### #DIV/0!                                                                            #DIV/0!             ##### #DIV/0!                                                                 #DIV/0!
#DIV/0!       ##### #DIV/0!                                 #DIV/0!                                              #DIV/0!   ##### #DIV/0!                        #DIV/0!
##### #DIV/0!                                                          #DIV/0!                               ##### #DIV/0!                                             #DIV/0!

0                           #DIV/0!                                                                          0                      #DIV/0!
#DIV/0! #DIV/0! #DIV/0!                                                                                  #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!                                                                                  #DIV/0! #DIV/0! #DIV/0!
#DIV/0!                                                                                                  #DIV/0!
#DIV/0!     0                                                                                            #DIV/0!     0
PROJECT TRAFFIC FOR AT : TO
1-WAY DESIGN HOUR TURNING MOVEMENTS IN YEAR 0                                                    1-WAY DESIGN HOUR TURNING MOVEMENTS IN YEAR 0

0                                                                                                0
0                                                                                         #DIV/0!

0         0        0                                                                        #DIV/0! #DIV/0! #DIV/0!
0                                                                                              0
0                                                                                        #DIV/0!
0           0                                                                            #DIV/0!        #DIV/0!
0                                                                                        #DIV/0!
0                                                                                          #DIV/0!
0           0                                                                              #DIV/0!     #DIV/0!
0                                                                                          #DIV/0!

0                                                                                                    0
0         0       0             D Factors                                                  #DIV/0! #DIV/0! #DIV/0!             D Factors
50.0% NB                                                                                       50.0% NB
0                     50.0% SB                                                           #DIV/0!                     50.0% SB
K ML =       7.00%                                             0                 50.0% WB            K ML =   7.00%                                            0                50.0% WB
K SS =       7.00%                                                               50.0% EB            K SS =   7.00%                                                             50.0% EB
1-WAY DESIGN HOUR TURNING MOVEMENTS IN YEAR 0                                                    1-WAY DESIGN HOUR TURNING MOVEMENTS IN YEAR 0

0                                                                                                0
#DIV/0!                                                                                         #DIV/0!

#DIV/0! #DIV/0! #DIV/0!                                                                          #DIV/0! #DIV/0! #DIV/0!
0                                                                                              0
#DIV/0!                                                                                        #DIV/0!
#DIV/0!        #DIV/0!                                                                         #DIV/0!        #DIV/0!
#DIV/0!                                                                                        #DIV/0!
#DIV/0!                                                                                          #DIV/0!
#DIV/0!         #DIV/0!                                                                              #DIV/0!     #DIV/0!
#DIV/0!                                                                                          #DIV/0!

0                                                                                                    0
#DIV/0! #DIV/0! #DIV/0!              D Factors                                                  #DIV/0! #DIV/0! #DIV/0!             D Factors
50.0% NB                                                                                       50.0% NB
#DIV/0!                     50.0% SB                                                           #DIV/0!                     50.0% SB
K ML =       7.00%                                             0                 50.0% WB            K ML =   7.00%                                            0                50.0% WB
K SS =       7.00%                                                               50.0% EB            K SS =   7.00%                                                             50.0% EB
PROJECT TRAFFIC FOR AT : TO
0 TRAFFIC                                                     0 TRAFFIC COMPARED TO 0 TRAFFIC

0
0                                                                 #DIV/0!
0     N/A              0
0                     0                                            #DIV/0!                #DIV/0!
0                                                             N/A       0            N/A

0             0              0                   0
0             0               0              0           0         #DIV/0!           #DIV/0!    #DIV/0!               0   #DIV/0!
N/A             N/A       N/A                       N/A

0                      0
0                     0                                            #DIV/0!                #DIV/0!
N/A           0        N/A
0                                    XXXX       0                 #DIV/0!
XXXX        0                                                             XXXX       0                  N/A
X.XX      Ratio
0 TRAFFIC COMPARED TO 0 TRAFFIC                                          0 TRAFFIC COMPARED TO 0 TRAFFIC

0                                                                       0
#DIV/0!                                                                 #DIV/0!
0      N/A             0                                                 0     N/A              0
#DIV/0!                #DIV/0!                                           #DIV/0!                #DIV/0!
N/A        0           N/A                                               N/A       0            N/A

0              0              0                           0               0             0              0                   0
#DIV/0!            #DIV/0!    #DIV/0!               0           #DIV/0!   #DIV/0!           #DIV/0!    #DIV/0!               0   #DIV/0!
N/A              N/A       N/A                               N/A          N/A             N/A       N/A                       N/A

0                      0                                                 0                      0
#DIV/0!                #DIV/0!                                           #DIV/0!                #DIV/0!
N/A            0       N/A                                               N/A           0        N/A
XXXX        0                  #DIV/0!                                    XXXX       0                 #DIV/0!
XXXX        0                   N/A                                       XXXX       0                  N/A
X.XX       Ratio                                                          X.XX      Ratio

PROJECT TRAFFIC FOR AT : TO
0 ACTUAL TRAFFIC COMPARED TO 0 DHV                                                       0 ACTUAL TRAFFIC COMPARED TO 0 DHV

0                                                                                        0
0      0        0                                                                       0       0       0
0      0        0                                                                     #DIV/0! #DIV/0! #DIV/0!
N/A    N/A      N/A                                                                     N/A     N/A     N/A

N/A         0    0                                                                       N/A       #DIV/0! 0
N/A         0    0                                                                       N/A       #DIV/0! 0
N/A         0    0                                                                       N/A       #DIV/0! 0
0     0 N/A                                                                              0 ##### N/A
0     0 N/A                                                                              0 ##### N/A
0     0 N/A                                                                              0 ##### N/A

0                                                                                        0
N/A     N/A     N/A                                                                     N/A     N/A     N/A
0       0       0                                                                     #DIV/0! #DIV/0! #DIV/0!
(XXX)         Actual 0 Traffic              0       0       0                            (XXX)         Actual 0 Traffic             0       0       0
XXX         Calculated 0 DHV                                            0                XXX         Calculated 0 DHV                                            0
X.XX              Ratio                                                                  X.XX              Ratio
0 ACTUAL TRAFFIC COMPARED TO 0 DHV                                                       0 ACTUAL TRAFFIC COMPARED TO 0 DHV

0                                                                                        0
0       0       0                                                                        0       0       0
#DIV/0! #DIV/0! #DIV/0!                                                                  #DIV/0! #DIV/0! #DIV/0!
N/A     N/A     N/A                                                                      N/A     N/A     N/A

N/A       #DIV/0! 0                                                                      N/A       #DIV/0! 0
N/A       #DIV/0! 0                                                                      N/A       #DIV/0! 0
N/A       #DIV/0! 0                                                                      N/A       #DIV/0! 0
0 ##### N/A                                                                              0 ##### N/A
0 ##### N/A                                                                              0 ##### N/A
0 ##### N/A                                                                              0 ##### N/A

0                                                                                        0
N/A     N/A     N/A                                                                      N/A     N/A     N/A
#DIV/0! #DIV/0! #DIV/0!                                                                  #DIV/0! #DIV/0! #DIV/0!
(XXX)         Actual 0 Traffic             0       0       0                             (XXX)         Actual 0 Traffic             0       0       0
XXX         Calculated 0 DHV                                            0                XXX         Calculated 0 DHV                                            0
X.XX              Ratio                                                                  X.XX              Ratio
Mainline N/S?        yes          Automatic Estimating?             yes
FSUTMS input?        yes
Intersection                  4 (2,3,4)
Two-Way Selected              1           0          0          1
Three-Way Selected            0           1          1          1
Macro Run            no
Errors               Growth
1           1 1=Linear, 2 = Exponential, 3 = Decaying for ML, side street
PIN
Location

aying for ML, side street
year       k30main k30side    OWDHTM_NB_T   OWDHTM_NB_RT
EXISTING          0       7.00      7.00             0                0
OPEN              0       7.00      7.00    #DIV/0!        #DIV/0!
MID               0       7.00      7.00    #DIV/0!        #DIV/0!
DESIGN            0       7.00      7.00    #DIV/0!        #DIV/0!

OWDHTM     One Way Design Hour Turning Movement
T          Through
LT         Left Turn
RT         Right Turn
OWDHTM_NB_LT        OWDHTM_SB_T        OWDHTM_SB_RT       OWDHTM_SB_LT
0                  0                  0                  0
#DIV/0!            #DIV/0!           #DIV/0!            #DIV/0!
#DIV/0!            #DIV/0!           #DIV/0!            #DIV/0!
#DIV/0!            #DIV/0!           #DIV/0!            #DIV/0!
OWDHTM_EB_T       OWDHTM_EB_RT OWDHTM_EB_LT OWDHTM_WB_T OWDHTM_WB_RT
0               0            0           0            0
#DIV/0!          #DIV/0!       #DIV/0!     #DIV/0!      #DIV/0!
#DIV/0!          #DIV/0!       #DIV/0!     #DIV/0!      #DIV/0!
#DIV/0!          #DIV/0!       #DIV/0!     #DIV/0!      #DIV/0!
0              0                 0
#DIV/0!                0                 0
#DIV/0!                0                 0
#DIV/0!                0                 0
NOTES

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 0 posted: 4/5/2013 language: Unknown pages: 27