1)
For a given country, compute unit vehicle operating
costs (VOC) and speeds function of roughness
using the RED - HDM-III VOC Workbook
or the RED - HDM-4 VOC Workbook or
any other model, and define cubic polynomials
relating unit VOCs and speeds to roughness,
which are essential to the use of the RED -
MAIN Workbook.
Use
the RED - HDM-III VOC Workbook to compute VOCs
and speeds for motorized vehicles, following
the HDM-III relationships, following the steps
below:
a)
Enter the country specific vehicle fleet data
on the Basic Input Data Worksheet.
b)
If necessary, enter the country specific calibration
data on the Calibration Data Worksheet.
c)
Compute the results by pressing the corresponding
button on the Compute Results Worksheet.
d)
Copy the results automatically into the RED
- MAIN Workbook by pressing the corresponding
button on the Compute Results Worksheet. Note
that RED - HDM-III VOC copies all the corresponding
results of the nine possible vehicle types
into RED - MAIN.
e)
If needed, view the results on the following
worksheets:
Coefficients
Worksheet -> Cubic polynomials
coefficients relating vehicle operating
costs and speeds to roughness (copied into
the RED-MAIN Workbook)
Speeds
Worksheet -> Speeds function
of roughness for all vehicles and road classes
VOC
Worksheet -> Vehicle operating
costs function of roughness for all vehicles
and road classes
Typical
VOC and Speeds -> Typical unit
vehicle operating costs and speeds for different
road classes
HDM-III
& Equations Comparison Worksheet
-> Comparison between HDM-III results
and cubic polynomials
Graph
VOC - Polynomial Worksheet ->
Graph comparing HDM-III results and cubic
polynomial equation
Graph
Speeds - Polynomial Worksheet ->
Graph comparing HDM-III results and cubic
polynomial equation
Graph
VOC - Exponential Worksheet ->
Graph comparing HDM-III results and cubic
exponential equation
Graph
Speeds - Exponential Worksheet ->
Graph comparing HDM-III results and cubic
exponential equation
Use
the RED - HDM-4 VOC Workbook to compute VOCs
and speeds for motorized vehicles, following
the HDM-4 relationships, following the steps
below:
a)
Enter the country specific vehicle fleet data
on the Basic Input Data Worksheet
.
b)
If necessary, enter the country specific calibration
data on the Calibration Data Worksheet.
c)
Compute the results by pressing the corresponding
button on the Compute Results Worksheet.
d)
Copy the results automatically into the RED
- MAIN Workbook by pressing the corresponding
button on the Compute Results Worksheet.
Note that RED - HDM-4 VOC copies all the corresponding
results of the nine possible vehicle types
into RED - MAIN.
e)
If needed, view the results on the following
worksheets:
Coefficients
Worksheet -> Cubic polynomials
coefficients relating vehicle operating
costs and speeds to roughness (copied into
the RED-MAIN Workbook)
Speeds
Worksheet -> Speeds function
of roughness for all vehicles and road classes
VOC
Worksheet -> Vehicle operating
costs function of roughness for all vehicles
and road classes
HDM-4
& Equations Comparison Worksheet
-> Comparison between HDM-4 results and
cubic polynomials
Typical
VOC and Speeds -> Typical unit
vehicle operating costs and speeds for different
road classes
Other
alternative is to use any other model to compute
VOCs and speeds as a function of roughness,
for motorized and non-motorized vehicles, and
to copy the corresponding cubic polynomial results
manually into the RED - MAIN workbook.
2)
Perform the economic evaluation of a given project
(road) using the RED - MAIN Workbook.
a)
Enter the control data on the Control
and Setup Worksheet.
b)
Review the VOC and Speeds cubic polynomial
coefficients copied from the VOC workbooks
on the Unit VOC and Speeds Worksheet.
c)
Enter the time and accidents data on the Time
and Accidents Worksheet .
d)
Enter the traffic data on the Traffic
Worksheet.
e)
Enter the project-alternatives data on the
Project-Alter. Main Features Worksheet
.
f)
If needed, enter additional net benefits on
the Project-Alter. Other Benefits
Worksheet .
The
economic evaluation results are computed automatically.
Therefore, there is no need to press a button
to compute the results.
g)
View a summary of the economic indicators
results for all project-alternatives on the
Project-Alter. Solution Worksheet.
h)
View the a graph of the Net Present Value
or the Total Society Costs.
i)
View the detailed results for each project-alternative
on the following worksheets:
Alter.
1, 2 or 3 Feasibility Worksheet ->
Input data and resulting cost streams and
economic indicators
Alter.
1, 2 or 3 User Impact Worksheet ->
Benefits to road users
Alter.
1, 2 or 3 Benefits Distribution Worksheet
-> Distribution of net benefits among
vehicle types
Alter.
1, 2 or 3 Sensitivity Worksheet ->
Sensitivity analysis for the main input
parameters
Alter.
1, 2 or 3 Switching Values Worksheet
-> Sensitivity analysis for the main
input parameters
Note
that to calculate the sensitivity and switching
values, you have to press a button on the
corresponding worksheet.
3)
If needed, perform a risk analysis using the
RED - RISK Workbook.
a)
Enter the triangular distributions for the
main input parameter on the Basic
Input Data Worksheet.
b)
Enter the number of scenarios to evaluate
on the Compute Results Worksheet .
c)
Perform the risk analysis by pressing the
corresponding button on the Compute
Results Worksheet.
d)
View the results on the following worksheets:
Risk
Analysis Solution Worksheet ->
Summary risk analysis results for all project-options
Alter.
1, 2 or 3 - Net Present Value Worksheet
-> Output net present value frequency distribution
Alter.
1, 2 or 3 - Rate of Return Worksheet ->
Output rate of return frequency distribution
Inputs
Distribution Worksheet -> Frequency
distributions for the main input parameters
4)
If you are evaluating a series of road sections,
you can use the RED - PROGRAM Workbook to evaluate
a series of sections automatically, withor without
budget constraints.
a)
Enter the road sections characteristics on
the RED Inputs Worksheet,
where each row represents a road section and
each column collectsthe corresponding RED
Main Worksheet inputs. Note that you define
up to 7 project-alternative per road section.
b)
Press the Execute RED Model button on the
RED Inputs Worksheet.
c)
View the economic evaluation results for all
road sections on the RED Outputs Worksheet.
d)
View a graph of the NPV and the main results
for a road section on the Road Section
Net Present Value Worksheet.
e)
View the unconstrained budget program on the
Unconstrained Budget Worksheet .
f)
Perform a budget constraint optimization on
the Budget Constraint A, B, C, D,
and E Worksheets. For each budget
scenario, enter theavailable budget and press
the Perform Budget Optimization and Collect
Optimization Results buttons.
g)
Define a recommended program on the Recommended
Program Worksheet, by selecting one
project-alternative per road.
h)
View the program Net Present Value for the
different budget constraints scenarios at
the Program Net Present Value Worksheet.
i)
View the multi-criteria results for the recommended
program on the Multi-Criteria Worksheet.
Press the Update Multi-Criteria Analysis button.