|
Reference
Centerline
Coordinate List Memo, August 25, 2003
This program can be found under the Roadway toolbar called "RD_VBA"

The Centerline Coordinate List Program is broken out into three
major components.
- Set COGO Information
- Create Centerline Coordinate List
- Create Centerline Coordinate Sheet
Set COGO Information
Optimal Settings for Geopak COGO User Preferences
Settings used for English Project.

|
Settings used for Metric Project.

|
Note the differences between the station formats and output
accuracy in stationing and angle depending on the Unit System
used. This is a direct correlation to the preferences used in
NCDOT Roadway plans.
The Initial State of the Centerline Coordinate List Program
Once the Job Number, Chain, and Increment distance have been
selected, the Beginning and Ending Station fields are automatically
populated.
Again, note the stationing format depending on the Geopak COGO
Preferences settings.
Designers can edit the Beginning and Endings Station fields
by keying in the numeric station values and it will automatically
reformatted to the station format. If a station entered is not
within the selected chain, the beginning or ending station is
entered in its place. Anytime the Designer wants to know the
beginning and ending stations for a selected Chain, place the
mouse pointer to the Beg Sta: or End
Sta: label and then the station information is displayed.
As an added feature, if either of these two labels is clicked
on, the beginning and ending stations are resetted back to the
original default value.

Create Centerline Coordinate List
If the Create button is clicked, then an Excel Centerline Coordinate
List is generated.

The Program then prompts the Designer if additional Chains
are to be appended to the list.


Note that the Job Number combo box has changed color to red
and it is now locked.

There are a series of tests the program goes through at this
stage. Three of which are considered "critical" and
will exit the program completely. The series of tests are performed
in this order with the corresponding error and action to fix
message.
Critical error raised if NCDOT V8 Workspace not configured
and set.

Critical error raised if the Excel template file used in the
program is not found.

Critical error raised if the Excel spreadsheet file has been
terminated when the program is going to write to it.

Error raised if the chain stationing is not in the correct
order.

Error raised if the beginning chain station is not within the
chain.

Error raised if the ending chain station is not within the
chain.

Error raised if the beginning chain station is not an even
station..

Warning message raised if the beginning chain station is not
an even 100 station.

Create Centerline Coordinate Sheet
While the Centerline Coordinate List (XY_COORD_L) is being
generated, the Centerline Coordinate Sheet (Centerline Coordinate
Sheet) is also being generated. There are two sheets with a
maximum of 820 point numbers.

Note that "easy" print buttons have been created
for Roadway Design prints only with the Centerline Coordinate
Sheet.

Before closing, the spreadsheet, Designers are prompted to
save or not save the generated spreadsheet file. If the spreadsheet
is to be saved, then save as an Excel (XLS) file in the \\Roadway\Proj
folder..

|