GEOPAK Quantity Manager

1
GEOPAK Quantity Manager
Steve Willoughby Bentley Civil
2
Objectives

• New application for managing ALL design
  quantities
• Easy user interface to review/manipulate
  quantities
• Manual entry of quantities
• Tight integration with Design Computation
  Manager
• Choice of DBMS
• Funding computations
• Custom report capabilities
• Interface with estimating systems
• Cost estimates and comparison

3
Standalone Application

• Java application
• Standalone installer
• Activation via Windows Desktop
• Activation via Windows Start Menu

4
Plan View Quantities

• Design and Computation Manager - Compute
• Standard units or 3PC
• Direct connection to databases
• Create
• Update
• Delete

5
Cross Section Quantities (Future)

• Earthwork
• Seeding
• Clearing

6
Non-Graphic Quantities

• Mobilization
• Human Resources
• Equipment

7
Choice of DBMS

• Microsoft Access 2000
• SQL Server
• Oracle
• Possibly others

8
Database Organization

• Project information
• Data source information (GPK, DDB, DGN)
• Payitem information
• Quantity information
• Element information
• Funding information

9
Navigating Pay Items
Quantity View
Pay Item Tree
Element View
10
Database Table Relationships
11
Customizing User Interface

• Tree view
• Table view
• Horizontally tiled panes
• Adjustable windows and sashes
• Show/Hide/Adjust/Move columns
• Sortable columns
• View by category
• View by phase

12
Creating a New Project Database

• Project number
• Project description
• Unit system English or Metric
• Spec year
• Geometry database
• aecXML payitem document
• aecXML funding source document

13
Creating Quantity Entries from CAD
14
Manually Entering Quantities

• Create categories
• Create pay items
• Create quantities
• General properties
• Location properties

15
Creating a New Pay Item

• Pay item name
• Pay item description
• Unit cost
• Unit of measure
• Lump sum item?
• Total rounding

16
Lump Sum Pay Items
17
Manually Entering Quantities

• Create categories
• Create pay items
• Create quantities
• General properties
• Location properties

18
Creating Quantity Manually General Properties
19
Creating Quantity Manually General Properties
20
Creating Quantity Manually General Properties
21
Creating Quantity Manually Location Properties
22
Creating Quantity Manually Location Properties

• Baseline chain
• Minimum station / region / offset
• Maximum station / region / offset

Max Station
Min Station
baseline
23
Phases

• Quantities may be organized into different phases
• Example phases
• Design Estimate
• Preliminary
• Construction Final
• Bid Estimate
• Total quantities of different phases may be
  compared

24
Creating Payers or Funding Sources

• Payer name
• Payer description

25
Creating a Funding Rule
26
Creating a Funding Rule

• Assign percent of participation to existing
  payers
• Assign station range of influence
• Apply funding rules to selected quantities

27
Funding Computation by Selection
28
Funding Computation by Station
29
Creating Custom Reports Define Style

• Style name
• Style description
• Target Payitem type
• Report Granularity
• XSL file name

30
Target Pay Item Type

• Each
• Linear
• Area
• General

31
Report Granularity

• Payitem Only
• Payitem Quantity
• Payitem Quantity Element

32
XSL File Name
33
Creating Custom Reports Select Quantities
34
Sample Output Each
35
Sample Output Linear
36
Sample Output Area
37
Sample Output Summary Sheet
38
Estimation System Interface
39
Payitem List in Trnsprt CES
40
Fund Source List in Trnsprt CES
41
Exporting Payitem List to aecXML
42
Importing Pay Items to QM
43
Importing Payers into QM
44
Exporting Quantities to aecXML
45
Importing an aecXML Design Project into Trnsprt
CES
46
Project Quantities in Trnsprt CES
47
Naming Convention when Transporting to Trnsprt
48
Demonstration
49
Questions?
50
GEOPAK Quantity Manager
Steve Willoughby Bentley Civil